senate_polls

Table actions

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

58 rows where sponsor_ids = 576

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: question_id, poll_id, state, sample_size, methodology, seat_number, seat_name, start_date, end_date, created_at, url, race_id, answer, candidate_id, candidate_name, candidate_party, 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
201 201 136503 72726 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 409 lv lv Online/Text U.S. Senate 2 Class III 10/29/20 11/1/20 11/3/20   0     0 0 11/2/20 19:43   https://changeresearch.com/wp-content/uploads/2020/11/CNBC-CR_Battleground_Toplines_Final-Wave_Oct-29-Nov-1.pdf general 6268 Kelly 13445 Mark Kelly DEM 51.0
202 202 136503 72726 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 409 lv lv Online/Text U.S. Senate 2 Class III 10/29/20 11/1/20 11/3/20   0     0 0 11/2/20 19:43   https://changeresearch.com/wp-content/uploads/2020/11/CNBC-CR_Battleground_Toplines_Final-Wave_Oct-29-Nov-1.pdf general 6268 McSally 13446 Martha McSally REP 47.0
203 203 136504 72728 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 383 lv lv Online/Text U.S. Senate 2 Class II 10/29/20 11/1/20 11/3/20   0     0 0 11/2/20 19:43   https://changeresearch.com/wp-content/uploads/2020/11/CNBC-CR_Battleground_Toplines_Final-Wave_Oct-29-Nov-1.pdf general 6280 Peters 13453 Gary C. Peters DEM 51.0
204 204 136504 72728 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 383 lv lv Online/Text U.S. Senate 2 Class II 10/29/20 11/1/20 11/3/20   0     0 0 11/2/20 19:43   https://changeresearch.com/wp-content/uploads/2020/11/CNBC-CR_Battleground_Toplines_Final-Wave_Oct-29-Nov-1.pdf general 6280 James 13454 John James REP 46.0
205 205 136505 72729 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 473 lv lv Online/Text U.S. Senate 0 Class II 10/29/20 11/1/20 11/3/20   0     0 0 11/2/20 19:43   https://changeresearch.com/wp-content/uploads/2020/11/CNBC-CR_Battleground_Toplines_Final-Wave_Oct-29-Nov-1.pdf general 6284 Cunningham 13468 Cal Cunningham DEM 50.0
206 206 136505 72729 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 473 lv lv Online/Text U.S. Senate 0 Class II 10/29/20 11/1/20 11/3/20   0     0 0 11/2/20 19:43   https://changeresearch.com/wp-content/uploads/2020/11/CNBC-CR_Battleground_Toplines_Final-Wave_Oct-29-Nov-1.pdf general 6284 Tillis 13461 Thom Tillis REP 46.0
761 761 133963 71519 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 232 lv lv Online/Text U.S. Senate 2 Class III 10/16/20 10/19/20 11/3/20   0     0 0 10/20/20 20:42   https://www.cnbc.com/2020/10/20/voters-want-senate-to-choose-coronavirus-stimulus-over-supreme-court.html general 6268 Kelly 13445 Mark Kelly DEM 54.0
762 762 133963 71519 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 232 lv lv Online/Text U.S. Senate 2 Class III 10/16/20 10/19/20 11/3/20   0     0 0 10/20/20 20:42   https://www.cnbc.com/2020/10/20/voters-want-senate-to-choose-coronavirus-stimulus-over-supreme-court.html general 6268 McSally 13446 Martha McSally REP 43.0
763 763 133964 71521 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 718 lv lv Online/Text U.S. Senate 2 Class II 10/16/20 10/19/20 11/3/20   0     0 0 10/20/20 20:42   https://www.cnbc.com/2020/10/20/voters-want-senate-to-choose-coronavirus-stimulus-over-supreme-court.html general 6280 Peters 13453 Gary C. Peters DEM 51.0
764 764 133964 71521 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 718 lv lv Online/Text U.S. Senate 2 Class II 10/16/20 10/19/20 11/3/20   0     0 0 10/20/20 20:42   https://www.cnbc.com/2020/10/20/voters-want-senate-to-choose-coronavirus-stimulus-over-supreme-court.html general 6280 James 13454 John James REP 46.0
765 765 133965 71522 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 521 lv lv Online/Text U.S. Senate 0 Class II 10/16/20 10/19/20 11/3/20   0     0 0 10/20/20 20:42   https://www.cnbc.com/2020/10/20/voters-want-senate-to-choose-coronavirus-stimulus-over-supreme-court.html general 6284 Cunningham 13468 Cal Cunningham DEM 51.0
766 766 133965 71522 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 521 lv lv Online/Text U.S. Senate 0 Class II 10/16/20 10/19/20 11/3/20   0     0 0 10/20/20 20:42   https://www.cnbc.com/2020/10/20/voters-want-senate-to-choose-coronavirus-stimulus-over-supreme-court.html general 6284 Tillis 13461 Thom Tillis REP 45.0
1120 1120 132074 70604 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 296 lv lv Online/Text U.S. Senate 2 Class III 10/2/20 10/4/20 11/3/20   0     0 0 10/7/20 09:24   https://changeresearch.com/post/states-of-play-battleground-wave-15/ general 6268 Kelly 13445 Mark Kelly DEM 51.0
1121 1121 132074 70604 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 296 lv lv Online/Text U.S. Senate 2 Class III 10/2/20 10/4/20 11/3/20   0     0 0 10/7/20 09:24   https://changeresearch.com/post/states-of-play-battleground-wave-15/ general 6268 McSally 13446 Martha McSally REP 43.0
1122 1122 132075 70606 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 676 lv lv Online/Text U.S. Senate 2 Class II 10/2/20 10/4/20 11/3/20   0     0 0 10/7/20 09:24   https://changeresearch.com/post/states-of-play-battleground-wave-15/ general 6280 Peters 13453 Gary C. Peters DEM 51.0
1123 1123 132075 70606 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 676 lv lv Online/Text U.S. Senate 2 Class II 10/2/20 10/4/20 11/3/20   0     0 0 10/7/20 09:24   https://changeresearch.com/post/states-of-play-battleground-wave-15/ general 6280 James 13454 John James REP 43.0
1124 1124 132076 70607 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 396 lv lv Online/Text U.S. Senate 0 Class II 10/2/20 10/4/20 11/3/20   0     0 0 10/7/20 09:25   https://changeresearch.com/post/states-of-play-battleground-wave-15/ general 6284 Cunningham 13468 Cal Cunningham DEM 50.0
1125 1125 132076 70607 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 396 lv lv Online/Text U.S. Senate 0 Class II 10/2/20 10/4/20 11/3/20   0     0 0 10/7/20 09:25   https://changeresearch.com/post/states-of-play-battleground-wave-15/ general 6284 Tillis 13461 Thom Tillis REP 46.0
1369 1369 129909 69681 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 262 lv lv Online/Text U.S. Senate 2 Class III 9/18/20 9/20/20 11/3/20   0     0 0 9/23/20 08:36   https://changeresearch.com/post/states-of-play-battleground-wave-14/ general 6268 Kelly 13445 Mark Kelly DEM 51.0
1370 1370 129909 69681 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 262 lv lv Online/Text U.S. Senate 2 Class III 9/18/20 9/20/20 11/3/20   0     0 0 9/23/20 08:36   https://changeresearch.com/post/states-of-play-battleground-wave-14/ general 6268 McSally 13446 Martha McSally REP 43.0
1371 1371 129910 69683 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 568 lv lv Online/Text U.S. Senate 2 Class II 9/18/20 9/20/20 11/3/20   0     0 0 9/23/20 08:36   https://changeresearch.com/post/states-of-play-battleground-wave-14/ general 6280 Peters 13453 Gary C. Peters DEM 50.0
1372 1372 129910 69683 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 568 lv lv Online/Text U.S. Senate 2 Class II 9/18/20 9/20/20 11/3/20   0     0 0 9/23/20 08:36   https://changeresearch.com/post/states-of-play-battleground-wave-14/ general 6280 James 13454 John James REP 44.0
1373 1373 129911 69684 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 579 lv lv Online/Text U.S. Senate 0 Class II 9/18/20 9/20/20 11/3/20   0     0 0 9/23/20 08:36   https://changeresearch.com/post/states-of-play-battleground-wave-14/ general 6284 Cunningham 13468 Cal Cunningham DEM 48.0
1374 1374 129911 69684 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 579 lv lv Online/Text U.S. Senate 0 Class II 9/18/20 9/20/20 11/3/20   0     0 0 9/23/20 08:36   https://changeresearch.com/post/states-of-play-battleground-wave-14/ general 6284 Tillis 13461 Thom Tillis REP 43.0
1597 1597 128359 68533 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 470 lv lv Online U.S. Senate 2 Class III 9/4/20 9/6/20 11/3/20   0     0 0 9/9/20 13:48   https://changeresearch.com/post/states-of-play-battleground-wave-13/ general 6268 Kelly 13445 Mark Kelly DEM 51.0
1598 1598 128359 68533 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 470 lv lv Online U.S. Senate 2 Class III 9/4/20 9/6/20 11/3/20   0     0 0 9/9/20 13:48   https://changeresearch.com/post/states-of-play-battleground-wave-13/ general 6268 McSally 13446 Martha McSally REP 45.0
1599 1599 128360 68535 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 876 lv lv Online U.S. Senate 2 Class II 9/4/20 9/6/20 11/3/20   0     0 0 9/9/20 13:48   https://changeresearch.com/post/states-of-play-battleground-wave-13/ general 6280 Peters 13453 Gary C. Peters DEM 50.0
1600 1600 128360 68535 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 876 lv lv Online U.S. Senate 2 Class II 9/4/20 9/6/20 11/3/20   0     0 0 9/9/20 13:48   https://changeresearch.com/post/states-of-play-battleground-wave-13/ general 6280 James 13454 John James REP 46.0
1601 1601 128361 68536 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 442 lv lv Online U.S. Senate 0 Class II 9/4/20 9/6/20 11/3/20   0     0 0 9/9/20 13:48   https://changeresearch.com/post/states-of-play-battleground-wave-13/ general 6284 Cunningham 13468 Cal Cunningham DEM 51.0
1602 1602 128361 68536 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 442 lv lv Online U.S. Senate 0 Class II 9/4/20 9/6/20 11/3/20   0     0 0 9/9/20 13:48   https://changeresearch.com/post/states-of-play-battleground-wave-13/ general 6284 Tillis 13461 Thom Tillis REP 44.0
1723 1723 127747 68206 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 809 lv lv Online U.S. Senate 2 Class II 8/21/20 8/23/20 11/3/20   0     0 0 8/26/20 05:30   https://changeresearch.com/post/states-of-play-battleground-wave-12/ general 6280 Peters 13453 Gary C. Peters DEM 50.0
1724 1724 127747 68206 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 809 lv lv Online U.S. Senate 2 Class II 8/21/20 8/23/20 11/3/20   0     0 0 8/26/20 05:30   https://changeresearch.com/post/states-of-play-battleground-wave-12/ general 6280 James 13454 John James REP 45.0
1725 1725 127748 68207 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 560 lv lv Online U.S. Senate 0 Class II 8/21/20 8/23/20 11/3/20   0     0 0 8/26/20 05:30   https://changeresearch.com/post/states-of-play-battleground-wave-12/ general 6284 Cunningham 13468 Cal Cunningham DEM 52.0
1726 1726 127748 68207 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 560 lv lv Online U.S. Senate 0 Class II 8/21/20 8/23/20 11/3/20   0     0 0 8/26/20 05:30   https://changeresearch.com/post/states-of-play-battleground-wave-12/ general 6284 Tillis 13461 Thom Tillis REP 42.0
1777 1777 127368 68011 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 428 lv lv Online U.S. Senate 2 Class III 8/7/20 8/9/20 11/3/20   0     0 0 8/12/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-11 general 6268 Kelly 13445 Mark Kelly DEM 49.0
1778 1778 127368 68011 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 428 lv lv Online U.S. Senate 2 Class III 8/7/20 8/9/20 11/3/20   0     0 0 8/12/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-11 general 6268 McSally 13446 Martha McSally REP 43.0
1779 1779 127369 68013 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 413 lv lv Online U.S. Senate 2 Class II 8/7/20 8/9/20 11/3/20   0     0 0 8/12/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-11 general 6280 Peters 13453 Gary C. Peters DEM 48.0
1780 1780 127369 68013 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 413 lv lv Online U.S. Senate 2 Class II 8/7/20 8/9/20 11/3/20   0     0 0 8/12/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-11 general 6280 James 13454 John James REP 45.0
1781 1781 127370 68014 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 491 lv lv Online U.S. Senate 0 Class II 8/7/20 8/9/20 11/3/20   0     0 0 8/12/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-11 general 6284 Cunningham 13468 Cal Cunningham DEM 48.0
1782 1782 127370 68014 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 491 lv lv Online U.S. Senate 0 Class II 8/7/20 8/9/20 11/3/20   0     0 0 8/12/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-11 general 6284 Tillis 13461 Thom Tillis REP 43.0
1906 1906 126908 67808 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 365 lv lv Online U.S. Senate 2 Class III 7/24/20 7/26/20 11/3/20   0     0 0 7/29/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-10 general 6268 Kelly 13445 Mark Kelly DEM 47.0
1907 1907 126908 67808 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 365 lv lv Online U.S. Senate 2 Class III 7/24/20 7/26/20 11/3/20   0     0 0 7/29/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-10 general 6268 McSally 13446 Martha McSally REP 45.0
1908 1908 126909 67810 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 413 lv lv Online U.S. Senate 2 Class II 7/24/20 7/26/20 11/3/20   0     0 0 7/29/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-10 general 6280 Peters 13453 Gary C. Peters DEM 48.0
1909 1909 126909 67810 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 413 lv lv Online U.S. Senate 2 Class II 7/24/20 7/26/20 11/3/20   0     0 0 7/29/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-10 general 6280 James 13454 John James REP 44.0
1910 1910 126910 67811 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 284 lv lv Online U.S. Senate 0 Class II 7/24/20 7/26/20 11/3/20   0     0 0 7/29/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-10 general 6284 Cunningham 13468 Cal Cunningham DEM 52.0
1911 1911 126910 67811 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 284 lv lv Online U.S. Senate 0 Class II 7/24/20 7/26/20 11/3/20   0     0 0 7/29/20 05:36   https://www.changeresearch.com/post/states-of-play-battleground-wave-10 general 6284 Tillis 13461 Thom Tillis REP 40.0
1996 1996 125356 67087 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 345 lv lv Online U.S. Senate 2 Class III 7/10/20 7/12/20 11/3/20   0     0 0 7/15/20 05:39   https://www.changeresearch.com/post/states-of-play-battleground-wave-9 general 6268 Kelly 13445 Mark Kelly DEM 52.0
1997 1997 125356 67087 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 345 lv lv Online U.S. Senate 2 Class III 7/10/20 7/12/20 11/3/20   0     0 0 7/15/20 05:39   https://www.changeresearch.com/post/states-of-play-battleground-wave-9 general 6268 McSally 13446 Martha McSally REP 45.0
1998 1998 125358 67089 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 824 lv lv Online U.S. Senate 2 Class II 7/10/20 7/12/20 11/3/20   0     0 0 7/15/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-9 general 6280 Peters 13453 Gary C. Peters DEM 50.0
1999 1999 125358 67089 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 824 lv lv Online U.S. Senate 2 Class II 7/10/20 7/12/20 11/3/20   0     0 0 7/15/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-9 general 6280 James 13454 John James REP 43.0
2000 2000 125359 67090 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 655 lv lv Online U.S. Senate 0 Class II 7/10/20 7/12/20 11/3/20   0     0 0 7/15/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-9 general 6284 Cunningham 13468 Cal Cunningham DEM 49.0
2001 2001 125359 67090 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 655 lv lv Online U.S. Senate 0 Class II 7/10/20 7/12/20 11/3/20   0     0 0 7/15/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-9 general 6284 Tillis 13461 Thom Tillis REP 42.0
2070 2070 125035 66956 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 311 lv lv Online U.S. Senate 2 Class III 6/26/20 6/28/20 11/3/20   0     0 0 7/1/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-8 general 6268 Kelly 13445 Mark Kelly DEM 53.0
2071 2071 125035 66956 2020 Arizona 1365 Change Research 576 CNBC Change Research 48 Change Research B- 311 lv lv Online U.S. Senate 2 Class III 6/26/20 6/28/20 11/3/20   0     0 0 7/1/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-8 general 6268 McSally 13446 Martha McSally REP 44.0
2072 2072 125036 66958 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 699 lv lv Online U.S. Senate 2 Class II 6/26/20 6/28/20 11/3/20   0     0 0 7/1/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-8 general 6280 Peters 13453 Gary C. Peters DEM 49.0
2073 2073 125036 66958 2020 Michigan 1365 Change Research 576 CNBC Change Research 48 Change Research B- 699 lv lv Online U.S. Senate 2 Class II 6/26/20 6/28/20 11/3/20   0     0 0 7/1/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-8 general 6280 James 13454 John James REP 42.0
2074 2074 125037 66959 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 468 lv lv Online U.S. Senate 0 Class II 6/26/20 6/28/20 11/3/20   0     0 0 7/1/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-8 general 6284 Cunningham 13468 Cal Cunningham DEM 51.0
2075 2075 125037 66959 2020 North Carolina 1365 Change Research 576 CNBC Change Research 48 Change Research B- 468 lv lv Online U.S. Senate 0 Class II 6/26/20 6/28/20 11/3/20   0     0 0 7/1/20 05:40   https://www.changeresearch.com/post/states-of-play-battleground-wave-8 general 6284 Tillis 13461 Thom Tillis REP 41.0

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
);