state_iec
211 rows where committee = "Coloradans Creating Opportunities" and type = "Other" sorted by date_delivered
This data as json, CSV (advanced)
Suggested facets: vendor, date_spent, date_delivered, position, candidate, district
affiliation 2 ✖
- Democratic 210
- Unknown 1
Link | rowid | committee | vendor | amount_spent | date_spent | date_delivered ▼ | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
380 | 380 | Coloradans Creating Opportunities | Ascend Digital Strategies | 268.14 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
381 | 381 | Coloradans Creating Opportunities | Ascend Digital Strategies | 98.04 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
400 | 400 | Coloradans Creating Opportunities | Ascend Digital Strategies | 58.2 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
429 | 429 | Coloradans Creating Opportunities | Ascend Digital Strategies | 238.77 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Cutter, Lisa Ann | Democratic | House District 25 |
448 | 448 | Coloradans Creating Opportunities | Ascend Digital Strategies | 220.08 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Daugherty, Lindsey; Zenzinger, Rachel | Democratic | House District 29/Senate District 19 |
466 | 466 | Coloradans Creating Opportunities | Ascend Digital Strategies | 374.13 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
491 | 491 | Coloradans Creating Opportunities | Ascend Digital Strategies | 36.33 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
531 | 531 | Coloradans Creating Opportunities | Ascend Digital Strategies | 246.27 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
532 | 532 | Coloradans Creating Opportunities | Ascend Digital Strategies | 120.48 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Kolker, Chris; Ortiz, David Daniel | Democratic | Senate District 27/House District 38 |
570 | 570 | Coloradans Creating Opportunities | Ascend Digital Strategies | 205.98 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Mitkowski, Jennifer | Democratic | House District 43 |
598 | 598 | Coloradans Creating Opportunities | Ascend Digital Strategies | 227.01 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Parker, Mary K | Democratic | House District 22 |
627 | 627 | Coloradans Creating Opportunities | Ascend Digital Strategies | 60.24 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Titone, Brianna Caterina | Democratic | House District 27 |
628 | 628 | Coloradans Creating Opportunities | Ascend Digital Strategies | 205.29 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Titone, Brianna Caterina; Zenzinger, Rachel | Democratic | House District 27/Senate District 19 |
658 | 658 | Coloradans Creating Opportunities | Ascend Digital Strategies | 5.73 | 10/13/20 | 10/12/2020-10/18/2020 | Other | Supporting | Zenzinger, Rachel | Democratic | Senate District 19 |
382 | 382 | Coloradans Creating Opportunities | Ascend Digital Strategies | 261.6 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
383 | 383 | Coloradans Creating Opportunities | Ascend Digital Strategies | 52.41 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Bridges, Jeff; Ortiz, David Daniel | Democratic | Senate District 26/House District 38 |
401 | 401 | Coloradans Creating Opportunities | Ascend Digital Strategies | 93.06 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
430 | 430 | Coloradans Creating Opportunities | Ascend Digital Strategies | 105.12 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Cutter, Lisa Ann | Democratic | House District 25 |
449 | 449 | Coloradans Creating Opportunities | Ascend Digital Strategies | 135.54 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Daugherty, Lindsey | Democratic | House District 29 |
450 | 450 | Coloradans Creating Opportunities | Ascend Digital Strategies | 135.54 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Daugherty, Lindsey; Zenzinger, Rachel | Democratic | House District 29/Senate District 19 |
467 | 467 | Coloradans Creating Opportunities | Ascend Digital Strategies | 235.29 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
492 | 492 | Coloradans Creating Opportunities | Ascend Digital Strategies | 101.34 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
515 | 515 | Coloradans Creating Opportunities | Ascend Digital Strategies | 176.58 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
533 | 533 | Coloradans Creating Opportunities | Ascend Digital Strategies | 219.03 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
534 | 534 | Coloradans Creating Opportunities | Ascend Digital Strategies | 110.97 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Kolker, Chris; Zenzinger, Rachel | Democratic | Senate District 27/Senate District 19 |
535 | 535 | Coloradans Creating Opportunities | Ascend Digital Strategies | 63.63 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Kolker, Chris; Ortiz, David Daniel | Democratic | Senate District 27/Houose District 38 |
571 | 571 | Coloradans Creating Opportunities | Ascend Digital Strategies | 76.98 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Mitkowski, Jennifer | Democratic | House District 43 |
585 | 585 | Coloradans Creating Opportunities | Ascend Digital Strategies | 116.04 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Ortiz, David Daniel | Democratic | House District 38 |
599 | 599 | Coloradans Creating Opportunities | Ascend Digital Strategies | 90.84 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Parker, Mary K | Democratic | House District 22 |
629 | 629 | Coloradans Creating Opportunities | Ascend Digital Strategies | 139.68 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Titone, Brianna Caterina | Democratic | House District 27 |
659 | 659 | Coloradans Creating Opportunities | Ascend Digital Strategies | 248.01 | 10/19/20 | 10/16/2020-10/22/2020 | Other | Supporting | Zenzinger, Rachel | Democratic | Senate District 19 |
395 | 395 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 3572.58 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
412 | 412 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 575.12 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
442 | 442 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 2238.88 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Cutter, Lisa Ann | Democratic | House District 25 |
460 | 460 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 1980.23 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Daugherty, Lindsey | Democratic | House District 29 |
476 | 476 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 3444.15 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Dickerson, Paula Jane | Democratic | Senate District 25 |
486 | 486 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 300.91 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Esgar, Daneya Leigh | Democratic | House District 46 |
504 | 504 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 455.38 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Exum Sr, Thomas Earl | Democratic | House District 17 |
524 | 524 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 4647.62 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
547 | 547 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 3308.85 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Kolker, Chris | Democratic | Senate District 27 |
559 | 559 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 1867.86 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Mclachlan, Barbara | Democratic | House District 59 |
568 | 568 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 1729.45 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Michaelson Jenet, Dafna | Democratic | House District 30 |
592 | 592 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 2054.44 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Ortiz, David Daniel | Democratic | House District 38 |
621 | 621 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 1916.35 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Sullivan, Tom | Democratic | House District 37 |
647 | 647 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 2395.8 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Titone, Brianna Caterina | Democratic | House District 27 |
670 | 670 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 5672.38 | 10/2/20 | 10/2/2020-10/20/2020 | Other | Supporting | Zenzinger, Rachel | Democratic | Senate District 19 |
384 | 384 | Coloradans Creating Opportunities | Ascend Digital Strategies | 261.6 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
385 | 385 | Coloradans Creating Opportunities | Ascend Digital Strategies | 52.41 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Bridges, Jeff; Ortiz, David Daniel | Democratic | Senate District 26/House District 38 |
402 | 402 | Coloradans Creating Opportunities | Ascend Digital Strategies | 93.06 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
431 | 431 | Coloradans Creating Opportunities | Ascend Digital Strategies | 105.12 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Cutter, Lisa Ann | Democratic | House District 25 |
451 | 451 | Coloradans Creating Opportunities | Ascend Digital Strategies | 135.54 | 10/26/20 | 10/23/2020-11/3/2020 | Other | Supporting | Daugherty, Lindsey; Zenzinger, Rachel | Democratic | House District 29/Senate District 19 |
452 | 452 | Coloradans Creating Opportunities | Ascend Digital Strategies | 135.54 | 10/26/20 | 10/23/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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
398 | 398 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 15665.45 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Bridges, Jeff | Democratic | Senate District 26 |
415 | 415 | Coloradans Creating Opportunities | Grassroots Voter Outreach | 5874.99 | 10/26/20 | 10/24/2020-11/3/2020 | Other | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
569 | 569 | Coloradans Creating Opportunities | Ascend Digital Strategies | 177.93 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Mitkowski, Jennifer | Democratic | House District 43 |
596 | 596 | Coloradans Creating Opportunities | Ascend Digital Strategies | 211.68 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Parker, Mary K | Democratic | House District 22 |
624 | 624 | Coloradans Creating Opportunities | Ascend Digital Strategies | 53.91 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Titone, Brianna Caterina | Democratic | House District 27 |
625 | 625 | Coloradans Creating Opportunities | Ascend Digital Strategies | 194.58 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Titone, Brianna Caterina; Zenzinger, Rachel | Democratic | House District 27/Senate District 19 |
656 | 656 | Coloradans Creating Opportunities | Ascend Digital Strategies | 5.22 | 10/8/20 | 10/3/2020-10/8/2020 | Other | Supporting | Zenzinger, Rachel | Democratic | Senate District 19 |
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 |
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 |
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 );