generic_ballot_polls

Table actions

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

71 rows where notes = "probabilistic voting question"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ question_id poll_id race_id cycle state pollster_id pollster sponsor_ids sponsors partisan display_name pollster_rating_id pollster_rating_name fte_grade sample_size population population_full methodology office_type seat_number start_date end_date sponsor_candidate tracking nationwide_batch created_at notes url stage dem rep ind
14 14 136615 72808 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5413 lv lv Online U.S. House   10/20/20 11/2/20   1 0 11/4/20 10:28 probabilistic voting question https://election.usc.edu/ general 52.59 44.59  
18 18 136282 72601 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5372 lv lv Online U.S. House   10/19/20 11/1/20   1 0 11/2/20 08:25 probabilistic voting question https://election.usc.edu/ general 52.34 44.77  
21 21 136027 72485 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5354 lv lv Online U.S. House   10/18/20 10/31/20   1 0 11/1/20 07:34 probabilistic voting question https://election.usc.edu/ general 52.45 44.51  
23 23 135840 72398 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5333 lv lv Online U.S. House   10/17/20 10/30/20   1 0 10/31/20 08:22 probabilistic voting question https://election.usc.edu/ general 52.28 44.57  
26 26 135662 72312 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5322 lv lv Online U.S. House   10/16/20 10/29/20   1 0 10/30/20 07:59 probabilistic voting question https://election.usc.edu/ general 52.24 44.55  
30 30 135410 72190 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5271 lv lv Online U.S. House   10/15/20 10/28/20   1 0 10/29/20 08:37 probabilistic voting question https://election.usc.edu/ general 52.37 44.43  
35 35 135409 72079 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5261 lv lv Online U.S. House   10/14/20 10/27/20   1 0 10/29/20 08:37 probabilistic voting question https://election.usc.edu/ general 52.39 44.35  
42 42 135041 72035 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5285 lv lv Online U.S. House   10/13/20 10/26/20   1 0 10/27/20 08:10 probabilistic voting question https://election.usc.edu/ general 51.81 44.92  
46 46 134861 71945 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5348 lv lv Online U.S. House   10/12/20 10/25/20   1 0 10/26/20 07:41 probabilistic voting question https://election.usc.edu/ general 51.9 44.9  
48 48 134735 71882 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5333 lv lv Online U.S. House   10/11/20 10/24/20   1 0 10/25/20 07:16 probabilistic voting question https://election.usc.edu/ general 51.62 45.2  
50 50 134608 71820 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5225 lv lv Online U.S. House   10/10/20 10/23/20   1 0 10/24/20 08:59 probabilistic voting question https://election.usc.edu/ general 51.62 45.23  
52 52 134402 71737 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5273 lv lv Online U.S. House   10/9/20 10/22/20   1 0 10/23/20 07:50 probabilistic voting question https://election.usc.edu/ general 51.85 45.08  
54 54 134205 71635 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5309 lv lv Online U.S. House   10/8/20 10/21/20   1 0 10/22/20 07:30 probabilistic voting question https://election.usc.edu/ general 51.8 44.94  
60 60 133978 71532 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5401 lv lv Online U.S. House   10/7/20 10/20/20   1 0 10/21/20 07:36 probabilistic voting question https://election.usc.edu/ general 51.89 44.6  
64 64 133791 71440 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5483 lv lv Online U.S. House   10/6/20 10/19/20   1 0 10/20/20 07:19 probabilistic voting question https://election.usc.edu/ general 52.06 44.39  
68 68 133620 71354 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5549 lv lv Online U.S. House   10/5/20 10/18/20   1 0 10/19/20 07:30 probabilistic voting question https://election.usc.edu/ general 52.25 44.27  
70 70 133494 71293 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5665 lv lv Online U.S. House   10/4/20 10/17/20   1 0 10/18/20 07:08 probabilistic voting question https://election.usc.edu/ general 52.33 44.2  
72 72 133380 71236 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5637 lv lv Online U.S. House   10/3/20 10/16/20   1 0 10/17/20 07:59 probabilistic voting question https://election.usc.edu/ general 52.39 44.17  
74 74 133231 71165 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5534 lv lv Online U.S. House   10/2/20 10/15/20   1 0 10/16/20 07:15 probabilistic voting question https://election.usc.edu/ general 51.99 44.4  
76 76 133015 71066 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5425 lv lv Online U.S. House   10/1/20 10/14/20   1 0 10/15/20 07:47 probabilistic voting question https://election.usc.edu/ general 51.85 44.36  
80 80 132814 70980 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5249 lv lv Online U.S. House   9/30/20 10/13/20   1 0 10/14/20 07:45 probabilistic voting question https://election.usc.edu/ general 52.07 44.26  
84 84 132356 70751 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5081 lv lv Online U.S. House   9/29/20 10/12/20   1 0 10/13/20 07:42 probabilistic voting question https://election.usc.edu/ general 52.34 43.96  
88 88 132316 70729 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5065 lv lv Online U.S. House   9/28/20 10/11/20   1 0 10/12/20 07:24 probabilistic voting question https://election.usc.edu/ general 52.26 43.94  
90 90 132304 70723 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5091 lv lv Online U.S. House   9/27/20 10/10/20   1 0 10/11/20 07:35 probabilistic voting question https://election.usc.edu/ general 52.12 44.1  
92 92 132271 70714 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5198 lv lv Online U.S. House   9/26/20 10/9/20   1 0 10/10/20 08:44 probabilistic voting question https://election.usc.edu/ general 51.99 44.18  
94 94 132241 70697 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5153 lv lv Online U.S. House   9/25/20 10/8/20   1 0 10/9/20 08:01 probabilistic voting question https://election.usc.edu/ general 51.83 44.24  
96 96 132152 70664 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5107 lv lv Online U.S. House   9/24/20 10/7/20   1 0 10/8/20 07:35 probabilistic voting question https://election.usc.edu/ general 51.96 44.26  
98 98 132058 70626 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4992 lv lv Online U.S. House   9/23/20 10/6/20   1 0 10/7/20 06:56 probabilistic voting question https://election.usc.edu/ general 51.71 44.46  
101 101 131989 70592 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4907 lv lv Online U.S. House   9/22/20 10/5/20   1 0 10/6/20 07:56 probabilistic voting question https://election.usc.edu/ general 51.93 44.31  
103 103 131618 70554 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4832 lv lv Online U.S. House   9/21/20 10/4/20   1 0 10/5/20 07:25 probabilistic voting question https://election.usc.edu/ general 52.03 44.19  
107 107 131586 70545 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4683 lv lv Online U.S. House   9/20/20 10/3/20   1 0 10/4/20 07:42 probabilistic voting question https://election.usc.edu/ general 51.65 44.55  
112 112 131478 70543 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4704 lv lv Online U.S. House   9/19/20 10/2/20   1 0 10/3/20 18:24 probabilistic voting question https://election.usc.edu/ general 51.75 44.44  
115 115 131477 70542 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4794 lv lv Online U.S. House   9/18/20 10/1/20   1 0 10/3/20 18:24 probabilistic voting question https://election.usc.edu/ general 51.9 44.41  
120 120 131476 70541 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4938 lv lv Online U.S. House   9/17/20 9/30/20   1 0 10/3/20 18:24 probabilistic voting question https://election.usc.edu/ general 51.81 44.21  
122 122 131475 70540 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5092 lv lv Online U.S. House   9/16/20 9/29/20   1 0 10/3/20 18:24 probabilistic voting question https://election.usc.edu/ general 51.33 44.56  
124 124 131474 70539 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5256 lv lv Online U.S. House   9/15/20 9/28/20   1 0 10/3/20 18:24 probabilistic voting question https://election.usc.edu/ general 51.39 44.32  
129 129 131473 70538 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5248 lv lv Online U.S. House   9/14/20 9/27/20   1 0 10/3/20 18:24 probabilistic voting question https://election.usc.edu/ general 51.33 44.35  
131 131 131472 70537 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5251 lv lv Online U.S. House   9/13/20 9/26/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 51.17 44.54  
134 134 131471 70536 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5323 lv lv Online U.S. House   9/12/20 9/25/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.99 44.74  
136 136 131470 70535 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5370 lv lv Online U.S. House   9/11/20 9/24/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.98 44.64  
140 140 131469 70534 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5362 lv lv Online U.S. House   9/10/20 9/23/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.9 44.63  
145 145 131468 70533 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5432 lv lv Online U.S. House   9/9/20 9/22/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.82 44.77  
147 147 131467 70532 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5474 lv lv Online U.S. House   9/8/20 9/21/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.65 44.76  
150 150 131466 70531 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5438 lv lv Online U.S. House   9/7/20 9/20/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.45 44.75  
152 152 131465 70530 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5447 lv lv Online U.S. House   9/6/20 9/19/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.71 44.5  
154 154 131464 70529 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5439 lv lv Online U.S. House   9/5/20 9/18/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.43 44.74  
157 157 131463 70528 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5458 lv lv Online U.S. House   9/4/20 9/17/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.3 44.9  
161 161 131462 70527 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5416 lv lv Online U.S. House   9/3/20 9/16/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.27 45.0  
165 165 131461 70526 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5408 lv lv Online U.S. House   9/2/20 9/15/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.43 44.9  
167 167 131460 70525 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5373 lv lv Online U.S. House   9/1/20 9/14/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.53 45.05  
169 169 131459 70524 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5387 lv lv Online U.S. House   8/31/20 9/13/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.43 44.93  
172 172 131458 70523 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5366 lv lv Online U.S. House   8/30/20 9/12/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.55 44.68  
175 175 131457 70522 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5251 lv lv Online U.S. House   8/29/20 9/11/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 51.04 44.13  
178 178 131456 70521 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5214 lv lv Online U.S. House   8/28/20 9/10/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.99 44.24  
181 181 131455 70520 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5235 lv lv Online U.S. House   8/27/20 9/9/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.83 44.15  
187 187 131454 70519 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5195 lv lv Online U.S. House   8/26/20 9/8/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 51.15 43.91  
190 190 131453 70518 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5138 lv lv Online U.S. House   8/25/20 9/7/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 50.92 44.15  
192 192 131452 70517 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5157 lv lv Online U.S. House   8/24/20 9/6/20   1 0 10/3/20 18:23 probabilistic voting question https://election.usc.edu/ general 51.17 44.0  
194 194 131451 70516 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5125 lv lv Online U.S. House   8/23/20 9/5/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.04 44.01  
196 196 131450 70515 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5125 lv lv Online U.S. House   8/22/20 9/4/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.31 43.92  
198 198 131449 70514 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5109 lv lv Online U.S. House   8/21/20 9/3/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.26 43.84  
200 200 131448 70513 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5091 lv lv Online U.S. House   8/20/20 9/2/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.39 43.95  
203 203 131447 70512 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5070 lv lv Online U.S. House   8/19/20 9/1/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.68 43.49  
206 206 131446 70511 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 5003 lv lv Online U.S. House   8/18/20 8/31/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.65 43.35  
209 209 131445 70510 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4905 lv lv Online U.S. House   8/17/20 8/30/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.73 43.4  
211 211 131444 70509 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4863 lv lv Online U.S. House   8/16/20 8/29/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.89 43.23  
214 214 131443 70508 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4797 lv lv Online U.S. House   8/15/20 8/28/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.38 43.6  
216 216 131442 70507 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4731 lv lv Online U.S. House   8/14/20 8/27/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.61 43.43  
220 220 131441 70506 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4630 lv lv Online U.S. House   8/13/20 8/26/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.77 43.5  
223 223 131440 70505 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4511 lv lv Online U.S. House   8/12/20 8/25/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.71 43.59  
225 225 131439 70504 8274 2020   1610 USC Dornsife/Los Angeles Times       USC Dornsife 343 USC Dornsife/Los Angeles Times B/C 4321 lv lv Online U.S. House   8/11/20 8/24/20   1 0 10/3/20 18:22 probabilistic voting question https://election.usc.edu/ general 51.94 43.51  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "generic_ballot_polls" (
"question_id" INTEGER,
  "poll_id" INTEGER,
  "race_id" INTEGER,
  "cycle" INTEGER,
  "state" INTEGER,
  "pollster_id" INTEGER,
  "pollster" TEXT,
  "sponsor_ids" TEXT,
  "sponsors" TEXT,
  "partisan" 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,
  "start_date" TEXT,
  "end_date" TEXT,
  "sponsor_candidate" INTEGER,
  "tracking" TEXT,
  "nationwide_batch" INTEGER,
  "created_at" TEXT,
  "notes" TEXT,
  "url" TEXT,
  "stage" TEXT,
  "dem" REAL,
  "rep" REAL,
  "ind" INTEGER
);