senate_polls

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

51 rows where answer = "Hegar"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: pollster_id, pollster, sponsor_ids, sponsors, display_name, pollster_rating_id, pollster_rating_name, fte_grade, population, population_full, methodology, internal, partisan, pct

Link rowid ▼ question_id poll_id cycle state pollster_id pollster sponsor_ids sponsors display_name pollster_rating_id pollster_rating_name fte_grade sample_size population population_full methodology office_type seat_number seat_name start_date end_date election_date sponsor_candidate internal partisan tracking nationwide_batch ranked_choice_reallocated created_at notes url stage race_id answer candidate_id candidate_name candidate_party pct
167 167 136577 72774 2020 Texas 1522 Swayable     Swayable 543 Swayable C 1042 lv lv Online U.S. Senate 2 Class II 10/27/20 11/2/20 11/3/20   0     0 0 11/2/20 22:16   https://www.swayable.com/polls/2020-11-02-large.html general 6295 Hegar 13459 Mary Jennings Hegar DEM 43.5
217 217 136217 72583 2020 Texas 1515 Data for Progress     Data for Progress 522 Data for Progress B 926 lv lv Online/Text U.S. Senate 2 Class II 10/27/20 11/1/20 11/3/20   0     0 0 11/1/20 21:26   https://filesforprogress.org/datasets/2020/11/2020-election-polls/toplines/dfp_tx_11.1.20.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 47.0
299 299 136088 72518 2020 Texas 1102 Emerson College     Emerson College 88 Emerson College A- 763 lv lv IVR/Online/Text U.S. Senate 2 Class II 10/29/20 10/31/20 11/3/20   0     0 0 11/1/20 17:15   https://emersonpolling.reportablenews.com/pr/super-poll-sunday-democrats-within-striking-distance-in-key-southern-states general 6295 Hegar 13459 Mary Jennings Hegar DEM 47.0
313 313 136276 72614 2020 Texas 1189 Morning Consult     Morning Consult 218 Morning Consult B 3267 lv lv Online U.S. Senate 2 Class II 10/22/20 10/31/20 11/3/20   0   1 0 0 11/2/20 07:20   https://morningconsult.com/form/2020-u-s-election-tracker/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 42.5
393 393 135688 72229 2020 Texas 1554 RMG Research 1475 PoliticalIQ RMG Research 555 RMG Research B- 800 lv lv IVR/Text U.S. Senate 2 Class II 10/27/20 10/28/20 11/3/20   0     0 0 10/30/20 10:47   http://politicaliq.com/2020/10/30/tx-senate-cornyn-r-48-hegar-d-42/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 42.0
401 401 136057 72498 2020 Texas 801 Gravis Marketing     Gravis Marketing 124 Gravis Marketing B 670 lv lv IVR/Online U.S. Senate 2 Class II 10/27/20 10/28/20 11/3/20   0     0 0 11/1/20 13:21   https://gravismarketing.com/texas-poll/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 43.0
554 554 135652 72308 2020 Texas 1522 Swayable     Swayable 543 Swayable C 492 lv lv Online U.S. Senate 2 Class II 10/23/20 10/26/20 11/3/20   0     0 0 10/30/20 07:55   https://www.swayable.com/polls/2020-10-28.html general 6295 Hegar 13459 Mary Jennings Hegar DEM 47.6
560 560 135451 72206 2020 Texas 1234 University of Massachusetts Lowell     University of Massachusetts Lowell 355 University of Massachusetts Lowell B+ 873 lv lv Online U.S. Senate 2 Class II 10/20/20 10/26/20 11/3/20   0     0 0 10/29/20 12:46   https://www.uml.edu/docs/2020-Texas-Oct-Topline_tcm18-331627.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 44.0
570 570 134886 71957 2020 Texas 1515 Data for Progress 1155,1452 Crooked Media | Indivisible Data for Progress 522 Data for Progress B 1018 lv lv Online U.S. Senate 2 Class II 10/22/20 10/25/20 11/3/20   0 DEM   0 0 10/26/20 11:53   https://filesforprogress.org/memos/2020-senate-project/week-6/dfp_psp_tx_10.26.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 46.0
586 586 134908 71967 2020 Texas 1424 Siena College/The New York Times Upshot     Siena College/The New York Times Upshot 448 Siena College/The New York Times Upshot A+ 802 lv lv Live Phone U.S. Senate 2 Class II 10/20/20 10/25/20 11/3/20   0     0 0 10/26/20 13:03   https://int.nyt.com/data/documenttools/tx102020-crosstabs-1/a1e2440aa9de6f2e/full.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 38.0
595 595 135279 72149 2020 Texas 1499 Univision/Latino Decisions/North Star Opinion Research 1245 University of Houston Univision/Latino Decisions/North Star Opinion Research 516 Univision/Latino Decisions/North Star Opinion Research B/C 758 rv rv Live Phone/Online U.S. Senate 2 Class II 10/17/20 10/25/20 11/3/20   0     0 0 10/28/20 13:00   https://st1.uvnimg.com/33/8f/ed1016da4a5fb16ec7e34cd5568a/univision-crosstabs-october-final.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 40.0
699 699 135401 72186 2020 Texas 1620 Citizen Data     Citizen Data 616 Citizen Data B/C 1000 lv lv IVR/Online U.S. Senate 2 Class II 10/17/20 10/20/20 11/3/20   0     0 0 10/29/20 08:18   https://github.com/GetCitizenData/VoteByMail/blob/master/VoteByMail-Texas/Modeling/October/Corrected%20Texas%20VBM%20Toplines%2010_29_20.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 40.62
714 714 134739 71884 2020 Texas 1474 University of Texas at Tyler 1164 Dallas Morning News University of Texas at Tyler 458 University of Texas at Tyler B/C 1012 rv rv Live Phone/Online U.S. Senate 2 Class II 10/13/20 10/20/20 11/3/20   0     0 0 10/25/20 07:34   https://www.uttyler.edu/politicalscience/files/oct2020-rv-codebook-dmn-uttyler-poll.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 32.0
718 718 134740 71884 2020 Texas 1474 University of Texas at Tyler 1164 Dallas Morning News University of Texas at Tyler 458 University of Texas at Tyler B/C 925 lv lv Live Phone/Online U.S. Senate 2 Class II 10/13/20 10/20/20 11/3/20   0     0 0 10/25/20 07:34   https://www.uttyler.edu/politicalscience/files/oct2020-lv-codebook-dmn-uttyler-poll.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 34.0
722 722 134883 71955 2020 Texas 568 YouGov 1245 University of Houston YouGov 391 YouGov B+ 1000 lv lv Online U.S. Senate 2 Class II 10/13/20 10/20/20 11/3/20   0     0 0 10/26/20 10:44   https://uh.edu/hobby/election2020/texas2020.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 41.6
738 738 134232 71647 2020 Texas 1189 Morning Consult     Morning Consult 218 Morning Consult B 3347 lv lv Online U.S. Senate 2 Class II 10/11/20 10/20/20 11/3/20   0   1 0 0 10/22/20 07:35   https://morningconsult.com/form/2020-u-s-election-tracker/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 41.0
740 740 133839 71458 2020 Texas 1347 Cygnal 1479 Ready Education Network Cygnal 67 Cygnal B+ 600 lv lv IVR/Live Phone/Text U.S. Senate 2 Class II 10/18/20 10/19/20 11/3/20   0     0 0 10/20/20 13:39   https://www.cygn.al/cygnal-poll-cornyn-leads-hegar-by-eight-points/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 40.8
767 767 134044 71556 2020 Texas 396 Quinnipiac University     Quinnipiac University 267 Quinnipiac University A- 1145 lv lv Live Phone U.S. Senate 2 Class II 10/16/20 10/19/20 11/3/20   0     0 0 10/21/20 14:02   https://poll.qu.edu/pennsylvania/release-detail?ReleaseID=3680 general 6295 Hegar 13459 Mary Jennings Hegar DEM 43.0
808 808 133786 71437 2020 Texas 1515 Data for Progress 1155,1452 Crooked Media | Indivisible Data for Progress 522 Data for Progress B 933 lv lv Online/Text U.S. Senate 2 Class II 10/15/20 10/18/20 11/3/20   0 DEM   0 0 10/19/20 21:53   https://filesforprogress.org/memos/2020-senate-project/week-5/toplines/tx.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 41.0
840 840 133244 71169 2020 Texas 383 Public Policy Polling     Public Policy Polling 263 Public Policy Polling A- 712 v v IVR/Text U.S. Senate 2 Class II 10/14/20 10/15/20 11/3/20   0     0 0 10/16/20 09:20   https://www.publicpolicypolling.com/wp-content/uploads/2020/10/TexasSenatePollOctober2020-1.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 46.0
998 998 132382 70762 2020 Texas 1189 Morning Consult     Morning Consult 218 Morning Consult B 3455 lv lv Online U.S. Senate 2 Class II 10/2/20 10/11/20 11/3/20   0   1 0 0 10/13/20 07:47   https://morningconsult.com/form/2020-u-s-election-tracker/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 38.0
1054 1054 132201 70682 2020 Texas 1226 Rasmussen Reports/Pulse Opinion Research     Pulse Opinion Research 277 Rasmussen Reports/Pulse Opinion Research B 1000 lv lv IVR U.S. Senate 2 Class II 10/5/20 10/6/20 11/3/20   0     0 0 10/8/20 15:04   https://crosswindpr.com/texas-statewide-poll-shows-trump-leading-biden-7-among-likely-voters/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 39.0
1060 1060 132069 70630 2020 Texas 1447 Civiqs 185 Daily Kos Civiqs 471 Civiqs B- 895 lv lv Online U.S. Senate 2 Class II 10/3/20 10/6/20 11/3/20   0     0 0 10/7/20 08:26   https://civiqs.com/documents/Civiqs_DailyKos_TX_banner_book_2020_10_cm5k3s.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 46.0
1111 1111 132129 70658 2020 Texas 1515 Data for Progress 1155,1452 Crooked Media | Indivisible Data for Progress 522 Data for Progress B 1949 lv lv Online/Text U.S. Senate 2 Class II 9/30/20 10/5/20 11/3/20   0 DEM   0 0 10/7/20 18:23   https://filesforprogress.org/memos/2020-senate-project/week-3/TX.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 42.0
1143 1143 132240 70694 2020 Texas 568 YouGov 216,406 Texas Tribune | University of Texas YouGov 391 YouGov B+ 908 lv lv Online U.S. Senate 2 Class II 9/25/20 10/4/20 11/3/20   0     0 0 10/9/20 07:55   https://static.texastribune.org/media/files/922524cf3ab155eb04b70075f96948ab/uttt-2020-10-day1topline.pdf?_ga=2.167788513.1578857801.1602243186-1274457702.1602243185 general 6295 Hegar 13459 Mary Jennings Hegar DEM 42.0
1276 1276 130476 70046 2020 Texas 1234 University of Massachusetts Lowell     University of Massachusetts Lowell 355 University of Massachusetts Lowell B+ 882 lv lv Online U.S. Senate 2 Class II 9/18/20 9/25/20 11/3/20   0     0 0 9/29/20 13:51   https://www.uml.edu/docs/2020-Texas-Sept-Topline_tcm18-330588.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 40.0
1321 1321 129986 69711 2020 Texas 1424 Siena College/The New York Times Upshot     Siena College/The New York Times Upshot 448 Siena College/The New York Times Upshot A+ 653 lv lv Live Phone U.S. Senate 2 Class II 9/16/20 9/22/20 11/3/20   0     0 0 9/24/20 05:06   https://int.nyt.com/data/documenttools/ga-ia-tx-crosstabs/ca61e64eaef883ac/full.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 37.0
1326 1326 130315 69975 2020 Texas 1515 Data for Progress 1455 Defend Students Action Fund Data for Progress 522 Data for Progress B 726 lv lv Online U.S. Senate 2 Class II 9/15/20 9/22/20 11/3/20   0     0 0 9/25/20 10:13   https://filesforprogress.org/memos/student-debt-project-electoral.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 38.0
1357 1357 130272 69955 2020 Texas 396 Quinnipiac University     Quinnipiac University 267 Quinnipiac University A- 1078 lv lv Live Phone U.S. Senate 2 Class II 9/17/20 9/21/20 11/3/20   0     0 0 9/24/20 14:02   https://poll.qu.edu/ohio/release-detail?ReleaseID=3675 general 6295 Hegar 13459 Mary Jennings Hegar DEM 42.0
1406 1406 129835 69642 2020 Texas 1189 Morning Consult     Morning Consult 218 Morning Consult B 2616 lv lv Online U.S. Senate 2 Class II 9/11/20 9/20/20 11/3/20   0   1 0 0 9/22/20 06:03   https://morningconsult.com/2020/09/22/majority-makers-south-carolina-senate-harrison-graham/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 39.0
1452 1452 129608 69565 2020 Texas 568 YouGov 133 CBS News YouGov 391 YouGov B+ 1129 lv lv Online U.S. Senate 2 Class II 9/15/20 9/18/20 11/3/20   0     0 0 9/20/20 10:33   https://drive.google.com/file/d/1ZsMPYa9d2L2vg4YYk-DFcwlXosTMmMYP/view general 6295 Hegar 13459 Mary Jennings Hegar DEM 41.0
1472 1472 132389 70770 2020 Texas 1189 Morning Consult     Morning Consult 218 Morning Consult B 2555 lv lv Online U.S. Senate 2 Class II 9/8/20 9/17/20 11/3/20   0   1 0 0 10/13/20 08:02   https://morningconsult.com/2020/10/13/senate-graham-harrison-supreme-court-polling/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 38.45
1635 1635 128273 68513 2020 Texas 383 Public Policy Polling 1011 Giffords Public Policy Polling 263 Public Policy Polling A- 743 v v IVR/Text U.S. Senate 2 Class II 9/1/20 9/2/20 11/3/20   0 DEM   0 0 9/8/20 13:44   https://giffords.org/wp-content/uploads/2020/09/TexasResults1.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 40.0
1652 1652 128224 68492 2020 Texas 1474 University of Texas at Tyler 1164 Dallas Morning News University of Texas at Tyler 458 University of Texas at Tyler B/C 1176 rv rv Live Phone/Online U.S. Senate 2 Class II 8/28/20 9/2/20 11/3/20   0     0 0 9/6/20 05:46   https://www.scribd.com/document/475037655/Aug28-Sept2-DMN-UTTyler-2020-Poll-Codebook-4 general 6295 Hegar 13459 Mary Jennings Hegar DEM 24.0
1656 1656 128225 68492 2020 Texas 1474 University of Texas at Tyler 1164 Dallas Morning News University of Texas at Tyler 458 University of Texas at Tyler B/C 901 lv lv Live Phone/Online U.S. Senate 2 Class II 8/28/20 9/2/20 11/3/20   0     0 0 9/6/20 05:46   https://www.scribd.com/document/475037655/Aug28-Sept2-DMN-UTTyler-2020-Poll-Codebook-4 general 6295 Hegar 13459 Mary Jennings Hegar DEM 28.0
1719 1719 128199 68480 2020 Texas 1515 Data for Progress 1439,1440,1441 Jolt Initiative | MOVE Texas | Texas Rising Data for Progress 522 Data for Progress B 2295 lv lv Online U.S. Senate 2 Class II 8/20/20 8/25/20 11/3/20   0     0 0 9/4/20 13:42   https://filesforprogress.org/datasets/2020/9/dfp_tx_survey_key_findings_sept4.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 40.0
1721 1721 129667 69578 2020 Texas 1571 The Tyson Group 229 Consumer Energy Alliance The Tyson Group 334 The Tyson Group B/C 906 lv lv Live Phone U.S. Senate 2 Class II 8/20/20 8/25/20 11/3/20   0     0 0 9/21/20 09:19   https://projects.fivethirtyeight.com/polls/20200921_TX.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 42.0
1755 1755 127527 68082 2020 Texas 568 YouGov 1164,1428,1429 Dallas Morning News | Texas Hispanic Policy Foundation | Rice University YouGov 391 YouGov B+ 846 rv rv Online U.S. Senate 2 Class II 8/4/20 8/13/20 11/3/20   0     0 0 8/17/20 09:32   https://www.txhpf.org/wp-content/uploads/2020/08/THPFFinalAug17.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 37.4
1835 1835 127096 67882 2020 Texas 1189 Morning Consult     Morning Consult 218 Morning Consult B 2576 lv lv Online U.S. Senate 2 Class II 7/24/20 8/2/20 11/3/20   0   1 0 0 8/4/20 06:21   https://morningconsult.com/2020/08/04/senate-presidential-polling-alabama-kentucky-sc-texas/ general 6295 Hegar 13459 Mary Jennings Hegar DEM 38.0
1870 1870 127097 67883 2020 Texas 1598 Global Strategy Group/Latino Decisions 24 DSCC Global Strategy Group/Latino Decisions 595 Global Strategy Group/Latino Decisions   700 lv lv Live Phone/Online U.S. Senate 2 Class II 7/25/20 7/29/20 11/3/20   1 DEM   0 0 8/4/20 06:24   https://www.politico.com/f/?id=00000173-b621-d8c4-a7f7-f76173a60000 general 6295 Hegar 13459 Mary Jennings Hegar DEM 42.0
1956 1956 126514 67617 2020 Texas 396 Quinnipiac University     Quinnipiac University 267 Quinnipiac University A- 880 rv rv Live Phone U.S. Senate 2 Class II 7/16/20 7/20/20 11/3/20   0     0 0 7/22/20 14:01   https://poll.qu.edu/texas/release-detail?ReleaseID=3667 general 6295 Hegar 13459 Mary Jennings Hegar DEM 38.0
1958 1958 126539 67629 2020 Texas 1488 Spry Strategies 1260 American Principles Project Spry Strategies 508 Spry Strategies B/C 750 lv lv IVR/Online U.S. Senate 2 Class II 7/16/20 7/20/20 11/3/20   0 REP   0 0 7/22/20 18:48   https://americanprinciplesproject.org/wp-content/uploads/2020/07/APP.Texas_.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 37.27
2011 2011 125293 67057 2020 Texas 568 YouGov 133 CBS News YouGov 391 YouGov B+ 1179 lv lv Online U.S. Senate 2 Class II 7/7/20 7/10/20 11/3/20   0     0 0 7/12/20 10:34   https://drive.google.com/file/d/18HFC79lmRr1KVcbrUysfJd6XpLZxZxaP/view general 6295 Hegar 13459 Mary Jennings Hegar DEM 36.0
2035 2035 125285 67054 2020 Texas 1474 University of Texas at Tyler 1164 Dallas Morning News University of Texas at Tyler 458 University of Texas at Tyler B/C 1909 rv rv Live Phone/Online U.S. Senate 2 Class II 6/29/20 7/7/20 11/3/20   0     0 0 7/12/20 07:43   https://www.uttyler.edu/politicalscience/files/codebook-dmn-uttyler-poll-july-2020-RV.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 26.0
2037 2037 125286 67054 2020 Texas 1474 University of Texas at Tyler 1164 Dallas Morning News University of Texas at Tyler 458 University of Texas at Tyler B/C 1677 lv lv Live Phone/Online U.S. Senate 2 Class II 6/29/20 7/7/20 11/3/20   0     0 0 7/12/20 07:43   https://projects.fivethirtyeight.com/polls/20200712_TX.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 29.0
2093 2093 125103 66979 2020 Texas 383 Public Policy Polling 32 Emily's List Public Policy Polling 263 Public Policy Polling A- 729 v v IVR/Text U.S. Senate 2 Class II 6/24/20 6/25/20 11/3/20   0 DEM   0 0 7/2/20 08:35   https://www.publicpolicypolling.com/wp-content/uploads/2020/07/TXToplines7220.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 35.0
2111 2111 124959 66919 2020 Texas 590 Fox News/Beacon Research/Shaw & Co. Research     Fox News 103 Fox News/Beacon Research/Shaw & Co. Research A 1001 rv rv Live Phone U.S. Senate 2 Class II 6/20/20 6/23/20 11/3/20   0     0 0 6/25/20 18:08   https://static.foxnews.com/foxnews.com/content/uploads/2020/06/Fox_June-20-23-2020_Complete_Texas_Topline_June-25-Release.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 36.0
2285 2285 122510 66043 2020 Texas 1474 University of Texas at Tyler 1164 Dallas Morning News University of Texas at Tyler 458 University of Texas at Tyler B/C 1183 rv rv Live Phone/Online U.S. Senate 2 Class II 4/18/20 4/27/20 11/3/20   0     0 0 5/2/20 16:43   https://projects.fivethirtyeight.com/polls/20200502_TX.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 24.0
2396 2396 119337 64640 2020 Texas 1205 Marist College 132 NBC News Marist College 183 Marist College A 2409 rv rv Live Phone U.S. Senate 2 Class II 2/23/20 2/27/20 11/3/20   0     0 0 3/1/20 09:04   http://maristpoll.marist.edu/wp-content/uploads/2020/02/NBC-News_Marist-Poll-TX-NOS-and-Tables_2002281546.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 41.0
2486 2486 114143 62992 2020 Texas 1523 Beacon Research 1214 Democratic Policy Institute Beacon Research 545 Beacon Research B/C 601 rv rv Live Phone/Online U.S. Senate 2 Class II 11/9/19 11/21/19 11/3/20   0 DEM   0 0 12/2/19 20:39   http://democraticpolicyinstitute.com/wp-content/uploads/2019/12/12.2.19-Texas-Senate-Poll-Beto-v-Cornyn.pdf general 6295 Hegar 13459 Mary Jennings Hegar DEM 30.0
2581 2581 100825 57962 2020 Texas 1102 Emerson College     Emerson College 88 Emerson College A- 799 rv rv IVR/Online U.S. Senate 2 Class II 4/25/19 4/28/19 11/3/20   0     0 0 8/20/19 16:31   https://emersonpolling.reportablenews.com/pr/2020-texas-biden-and-beto-in-dead-heat-in-democratic-primary general 6295 Hegar 13459 Mary Jennings Hegar DEM 11.8

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "senate_polls" (
"question_id" INTEGER,
  "poll_id" INTEGER,
  "cycle" INTEGER,
  "state" TEXT,
  "pollster_id" INTEGER,
  "pollster" TEXT,
  "sponsor_ids" TEXT,
  "sponsors" TEXT,
  "display_name" TEXT,
  "pollster_rating_id" INTEGER,
  "pollster_rating_name" TEXT,
  "fte_grade" TEXT,
  "sample_size" INTEGER,
  "population" TEXT,
  "population_full" TEXT,
  "methodology" TEXT,
  "office_type" TEXT,
  "seat_number" INTEGER,
  "seat_name" TEXT,
  "start_date" TEXT,
  "end_date" TEXT,
  "election_date" TEXT,
  "sponsor_candidate" TEXT,
  "internal" INTEGER,
  "partisan" TEXT,
  "tracking" TEXT,
  "nationwide_batch" INTEGER,
  "ranked_choice_reallocated" INTEGER,
  "created_at" TEXT,
  "notes" TEXT,
  "url" TEXT,
  "stage" TEXT,
  "race_id" INTEGER,
  "answer" TEXT,
  "candidate_id" INTEGER,
  "candidate_name" TEXT,
  "candidate_party" TEXT,
  "pct" REAL
);