state_iec
347 rows where position = "Supporting" and type = "Other" sorted by date_spent
This data as json, CSV (advanced)
Link | rowid | committee | vendor | amount_spent | date_spent ▼ | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
463 | 463 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 7751.04 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Daugherty, Lindsey | Democratic | House District 29 |
468 | 468 | Coloradans Creating Opportunities | Ascend Digital Strategies | 235.29 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
478 | 478 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 11002.24 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
493 | 493 | Coloradans Creating Opportunities | Ascend Digital Strategies | 101.34 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
506 | 506 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 4796.18 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
516 | 516 | Coloradans Creating Opportunities | Ascend Digital Strategies | 176.58 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
526 | 526 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 7583.52 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
536 | 536 | Coloradans Creating Opportunities | Ascend Digital Strategies | 219.03 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
537 | 537 | Coloradans Creating Opportunities | Ascend Digital Strategies | 63.63 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Kolker, Chris; Ortiz, David Daniel | Democratic | Senate District 27/Houose District 38 |
551 | 551 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 17285.95 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
572 | 572 | Coloradans Creating Opportunities | Ascend Digital Strategies | 76.98 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Mitkowski, Jennifer | Democratic | House District 43 |
579 | 579 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 8400.75 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Mitkowski, Jennifer | Democratic | House District 43 |
586 | 586 | Coloradans Creating Opportunities | Ascend Digital Strategies | 116.04 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Ortiz, David Daniel | Democratic | House District 38 |
594 | 594 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 10211.09 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Ortiz, David Daniel | Democratic | House District 38 |
605 | 605 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 8596.85 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Parker, Mary K | Democratic | House District 22 |
630 | 630 | Coloradans Creating Opportunities | Ascend Digital Strategies | 139.68 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Titone, Brianna Caterina | Democratic | House District 27 |
631 | 631 | Coloradans Creating Opportunities | Ascend Digital Strategies | 110.97 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Titone, Brianna Caterina; Zenzinger, Rachel | Democratic | House District 27/Senate District 19 |
649 | 649 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 8564.66 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Titone, Brianna Caterina | Democratic | House District 27 |
660 | 660 | Coloradans Creating Opportunities | Ascend Digital Strategies | 248.01 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Zenzinger, Rachel | Democratic | Senate District 19 |
672 | 672 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 14147.66 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Zenzinger, Rachel | Democratic | Senate District 19 |
1159 | 1159 | Colorado Working Families Party Independent Expenditure Committee | Base Builder | 15000.0 | 10/26/20 | 10/27/2020 - 10/31/2020 | Other | Supporting | King, Alexis | Democratic | Jefferson County District Attorney |
1166 | 1166 | Colorado Working Families Party Independent Expenditure Committee | Base Builder | 11500.0 | 10/26/20 | 10/29/2020 - 10/31/2020 | Other | Supporting | Padden, Amy L | Democratic | Arapahoe County District Attorney |
1205 | 1205 | Conservation Colorado Victory Fund | Solidarity Strategies, Llc | 6981.86 | 10/26/20 | 10/26/20 | Other | Supporting | Henry, Eva J; holen, Bill Lee; Keith, Idris; Kerr, Andy; Kraft-Tharp, Tracy; Robinson, Leslie A; Soto, Beatriz; Tedesco, Charles "Chaz"; Warren-Gully, Carrie L | Democratic | multiple |
353 | 353 | CCJRC4Action | Bacon, Jimmy | 471.92 | 10/27/20 | 10/13/2020 - 11/3/2020 | Other | Supporting | King, Alexis; Padden, Amy L | Democratic | Jefferson County District Attorney/Arapahoe County District Attorney |
355 | 355 | CCJRC4Action | Ross, Jasmine | 500.0 | 10/27/20 | 10/13/2020 - 11/3/2020 | Other | Supporting | King, Alexis; Padden, Amy L | Democratic | Jefferson County District Attorney/Arapahoe County District Attorney |
357 | 357 | CCJRC4Action | Wheeler, Leanne | 3750.0 | 10/27/20 | 10/13/2020 - 11/3/2020 | Other | Supporting | King, Alexis | Democratic | Jefferson County District Attorney/Arapahoe County District Attorney |
358 | 358 | CCJRC4Action | Williams, Richard | 598.33 | 10/27/20 | 10/13/2020 - 11/3/2020 | Other | Supporting | King, Alexis; Padden, Amy L | Democratic | Jefferson County District Attorney/Arapahoe County District Attorney |
1129 | 1129 | Colorado Sierra Club Independent Action | Stones Phones | 6000.0 | 10/27/20 | 10/28/20 | Other | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1135 | 1135 | Colorado Sierra Club Independent Action | Stones Phones | 6000.0 | 10/27/20 | 10/28/20 | Other | Supporting | Shadduck-Mcnally, Jody; Stephens, Kristin | Democratic | Larimer County Commissioner |
2000 | 2000 | NRA Political Victory Fund | I360, Llc | 1924.32 | 10/28/20 | 10/21/2020 THROUGH 10/28/2020 | Other | Supporting | Champion, Richard Alan; Cornell, Caroline; Gerber, Lynn T; Gutierrez, Kerrie Anne; Harris, Marilyn Joan; Priola, Kevin; Pyne, Vicki C; Rosier, Donald; Roth, Robert C; Staiert, Suzanne | Republican | multiple |
2001 | 2001 | NRA Political Victory Fund | I360, Llc | -1924.32 | 10/28/20 | 10/21/2020 THROUGH 10/28/2020 | Other | Supporting | Champion, Richard Alan; Cornell, Caroline; Gerber, Lynn T; Gutierrez, Kerrie Anne; Harris, Marilyn Joan; Priola, Kevin; Pyne, Vicki C; Rosier, Donald; Roth, Robert C; Staiert, Suzanne | Republican | multiple |
2002 | 2002 | NRA Political Victory Fund | I360, Llc | 1924.32 | 10/28/20 | 10/21/2020 THROUGH 10/28/2020 | Other | Supporting | Champion, Richard Alan; Cornell, Caroline; Gerber, Lynn T; Gutierrez, Kerrie Anne; Harris, Marilyn Joan; Priola, Kevin; Pyne, Vicki C; Rosier, Donald; Roth, Robert C; Staiert, Suzanne | Republican | multiple |
2387 | 2387 | Take Back Colorado | Rearden Strategic, Inc | 6000.0 | 10/28/20 | 10/28/20-11/2/20 | Other | Supporting | Luck, Stephanie; Pyne, Vicki C; Van Winkle, Kevin | Republican | House District 47 |
2445 | 2445 | Unite For Colorado Action | Telephone Town Hall Meeting | 1456.0 | 10/28/20 | 10/28/20 - 10/30/20 | Other | Supporting | Rankin, Bob | Republican | Senate District 08 |
969 | 969 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Bacon, Jennifer | Democratic | House District 07 |
985 | 985 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Buckner, Janet | Democratic | Senate District 28 |
1002 | 1002 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Duran, Monica | Democratic | House District 24 |
1019 | 1019 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Jackson, Dominique | Democratic | House District 42 |
1034 | 1034 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Jodeh, Iman | Democratic | House District 41 |
1047 | 1047 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Tipper, Kerry | Democratic | House District 28 |
1063 | 1063 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Weissman, Mike | Democratic | House District 36 |
1078 | 1078 | Colorado People's Action Committee | Colorado People's Action | 533.59 | 10/29/20 | 10/29/20 0:00 | Other | Supporting | Young, Mary | Democratic | House District 50 |
356 | 356 | CCJRC4Action | Scott, Mecca | 300.0 | 10/30/20 | 10/13/2020 - 11/3/2020 | Other | Supporting | King, Alexis; Padden, Amy L | Democratic | Jefferson County District Attorney/Arapahoe County District Attorney |
372 | 372 | Coloradans Creating Opportunities | Ascend Digital Strategies | 1014.51 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Boccella, Sally | Democratic | Senate District 23 |
374 | 374 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 3350.0 | 10/30/20 | 10/29/2020-11/3/2020 | Other | Supporting | Boccella, Sally | Democratic | Senate District 23 |
375 | 375 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 17000.0 | 10/30/20 | 10/29/2020-11/3/2020 | Other | Supporting | Boccella, Sally | Democratic | Senate District 23 |
376 | 376 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 2000.0 | 10/30/20 | 10/29/2020-11/3/2020 | Other | Supporting | Boccella, Sally | Democratic | Senate District 23 |
386 | 386 | Coloradans Creating Opportunities | Ascend Digital Strategies | 196.56 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Bridges, Jeff; Ortiz, David Daniel | Democratic | Senate District 26/House District 38 |
387 | 387 | Coloradans Creating Opportunities | Ascend Digital Strategies | 717.78 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
403 | 403 | Coloradans Creating Opportunities | Ascend Digital Strategies | 288.45 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
432 | 432 | Coloradans Creating Opportunities | Ascend Digital Strategies | 410.01 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Cutter, Lisa Ann | Democratic | House District 25 |
453 | 453 | Coloradans Creating Opportunities | Ascend Digital Strategies | 492.03 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Daugherty, Lindsey; Zenzinger, Rachel | Democratic | House District 29/Senate District 19 |
469 | 469 | Coloradans Creating Opportunities | Ascend Digital Strategies | 843.93 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
494 | 494 | Coloradans Creating Opportunities | Ascend Digital Strategies | 307.95 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
517 | 517 | Coloradans Creating Opportunities | Ascend Digital Strategies | 722.79 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
538 | 538 | Coloradans Creating Opportunities | Ascend Digital Strategies | 562.89 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
539 | 539 | Coloradans Creating Opportunities | Ascend Digital Strategies | 239.1 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Kolker, Chris; Ortiz, David Daniel | Democratic | Senate District 27/House District 38 |
573 | 573 | Coloradans Creating Opportunities | Ascend Digital Strategies | 312.54 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Mitkowski, Jennifer | Democratic | House District 43 |
601 | 601 | Coloradans Creating Opportunities | Ascend Digital Strategies | 370.71 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Parker, Mary K | Democratic | House District 22 |
632 | 632 | Coloradans Creating Opportunities | Ascend Digital Strategies | 108.63 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Titone, Brianna Caterina | Democratic | House District 27 |
633 | 633 | Coloradans Creating Opportunities | Ascend Digital Strategies | 415.62 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Titone, Brianna Caterina; Zenzinger, Rachel | Democratic | House District 27/Senate District 19 |
661 | 661 | Coloradans Creating Opportunities | Ascend Digital Strategies | 6.81 | 10/30/20 | 10/30/2020-11/3/2020 | Other | Supporting | Zenzinger, Rachel | Democratic | Senate District 19 |
971 | 971 | Colorado People's Action Committee | Colorado People's Action | 107.5 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Bacon, Jennifer | Democratic | House District 07 |
972 | 972 | Colorado People's Action Committee | Colorado People's Action | 5.27 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Bacon, Jennifer | Democratic | House District 07 |
987 | 987 | Colorado People's Action Committee | Colorado People's Action | 211.47 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Buckner, Janet | Democratic | Senate District 28 |
988 | 988 | Colorado People's Action Committee | Colorado People's Action | 9.23 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Buckner, Janet | Democratic | Senate District 28 |
1004 | 1004 | Colorado People's Action Committee | Colorado People's Action | 40.0 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Duran, Monica | Democratic | House District 24 |
1005 | 1005 | Colorado People's Action Committee | Colorado People's Action | 5.76 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Duran, Monica | Democratic | House District 24 |
1021 | 1021 | Colorado People's Action Committee | Colorado People's Action | 81.34 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Jackson, Dominique | Democratic | House District 42 |
1022 | 1022 | Colorado People's Action Committee | Colorado People's Action | 5.76 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Jackson, Dominique | Democratic | House District 42 |
1036 | 1036 | Colorado People's Action Committee | Colorado People's Action | 37.94 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Jodeh, Iman | Democratic | House District 41 |
1037 | 1037 | Colorado People's Action Committee | Colorado People's Action | 5.27 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Jodeh, Iman | Democratic | House District 41 |
1049 | 1049 | Colorado People's Action Committee | Colorado People's Action | 256.07 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Tipper, Kerry | Democratic | House District 28 |
1050 | 1050 | Colorado People's Action Committee | Colorado People's Action | 5.27 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Tipper, Kerry | Democratic | House District 28 |
1065 | 1065 | Colorado People's Action Committee | Colorado People's Action | 53.11 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Weissman, Mike | Democratic | House District 36 |
1066 | 1066 | Colorado People's Action Committee | Colorado People's Action | 5.76 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Weissman, Mike | Democratic | House District 36 |
1080 | 1080 | Colorado People's Action Committee | Colorado People's Action | 47.47 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Young, Mary | Democratic | House District 50 |
1081 | 1081 | Colorado People's Action Committee | Colorado People's Action | 5.76 | 10/31/20 | 10/31/20 0:00 | Other | Supporting | Young, Mary | Democratic | House District 50 |
1162 | 1162 | Colorado Working Families Party Independent Expenditure Committee | Robodial.Org | 199.01 | 10/31/20 | 10/31/20 | Other | Supporting | King, Alexis | Democratic | Jefferson County District Attorney |
1170 | 1170 | Colorado Working Families Party Independent Expenditure Committee | Robodial.Org | 180.54 | 10/31/20 | 10/31/20 | Other | Supporting | Padden, Amy L | Democratic | Arapahoe County District Attorney |
2338 | 2338 | Senate Majority Fund | Campaign Headquarters | 8561.88 | 10/31/20 | 10/031/2020-11/3/2020 | Other | Supporting | Kirkmeyer, Barbara | Republican | Senate District 23 |
2343 | 2343 | Senate Majority Fund | Campaign Headquarters | 4811.24 | 10/31/20 | 10/31/2020-11/3/2020 | Other | Supporting | Priola, Kevin | Republican | Senate District 25 |
2356 | 2356 | Senate Majority Fund | Campaign Headquarters | 5576.6 | 10/31/20 | 10/31/2020-11/3/2020 | Other | Supporting | Rankin, Bob | Republican | Senate District 08 |
377 | 377 | Coloradans Creating Opportunities | Ascend Digital Strategies | 89.7 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Bridges, Jeff; Ortiz, David Daniel | Democratic | Senate District 26/House District 38 |
378 | 378 | Coloradans Creating Opportunities | Ascend Digital Strategies | 250.98 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
396 | 396 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 3650.57 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
413 | 413 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 10.51 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
427 | 427 | Coloradans Creating Opportunities | Ascend Digital Strategies | 215.76 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Cutter, Lisa Ann | Democratic | House District 25 |
443 | 443 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 1479.66 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Cutter, Lisa Ann | Democratic | House District 25 |
446 | 446 | Coloradans Creating Opportunities | Ascend Digital Strategies | 208.35 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Daugherty, Lindsey; Zenzinger, Rachel | Democratic | House District 29/Senate District 19 |
461 | 461 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 2154.89 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Daugherty, Lindsey | Democratic | House District 29 |
464 | 464 | Coloradans Creating Opportunities | Ascend Digital Strategies | 347.4 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
477 | 477 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 4610.44 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
489 | 489 | Coloradans Creating Opportunities | Ascend Digital Strategies | 33.48 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
505 | 505 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 638.25 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
512 | 512 | Coloradans Creating Opportunities | Ascend Digital Strategies | 406.65 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
525 | 525 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 4869.44 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
528 | 528 | Coloradans Creating Opportunities | Ascend Digital Strategies | 113.49 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Kolker, Chris; Tipper, Kerry | Democratic | Senate District 27/House District 28 |
529 | 529 | Coloradans Creating Opportunities | Ascend Digital Strategies | 229.89 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
548 | 548 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 3055.0 | 10/8/20 | 10/7/2020-10/25/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_iec" ( "committee" TEXT, "vendor" TEXT, "amount_spent" REAL, "date_spent" TEXT, "date_delivered" TEXT, "type" TEXT, "position" TEXT, "candidate" TEXT, "affiliation" TEXT, "district" TEXT );