ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,132 rows where county = "Sumter" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 4
- Florida 787
- Georgia 785
- South Carolina 785
- Alabama 775
county 1
- Sumter · 3,132 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
19707 | 19707 | 2020-03-30 | Sumter | Alabama | 1119 | 1 | 0 |
21779 | 21779 | 2020-03-31 | Sumter | Alabama | 1119 | 1 | 0 |
23935 | 23935 | 2020-04-01 | Sumter | Alabama | 1119 | 3 | 0 |
26157 | 26157 | 2020-04-02 | Sumter | Alabama | 1119 | 4 | 0 |
28454 | 28454 | 2020-04-03 | Sumter | Alabama | 1119 | 7 | 0 |
30811 | 30811 | 2020-04-04 | Sumter | Alabama | 1119 | 6 | 0 |
33215 | 33215 | 2020-04-05 | Sumter | Alabama | 1119 | 7 | 0 |
35654 | 35654 | 2020-04-06 | Sumter | Alabama | 1119 | 10 | 0 |
38142 | 38142 | 2020-04-07 | Sumter | Alabama | 1119 | 15 | 0 |
40684 | 40684 | 2020-04-08 | Sumter | Alabama | 1119 | 17 | 0 |
43258 | 43258 | 2020-04-09 | Sumter | Alabama | 1119 | 17 | 0 |
45856 | 45856 | 2020-04-10 | Sumter | Alabama | 1119 | 18 | 0 |
48485 | 48485 | 2020-04-11 | Sumter | Alabama | 1119 | 19 | 0 |
51147 | 51147 | 2020-04-12 | Sumter | Alabama | 1119 | 20 | 0 |
53825 | 53825 | 2020-04-13 | Sumter | Alabama | 1119 | 23 | 0 |
56517 | 56517 | 2020-04-14 | Sumter | Alabama | 1119 | 26 | 0 |
59225 | 59225 | 2020-04-15 | Sumter | Alabama | 1119 | 30 | 0 |
61943 | 61943 | 2020-04-16 | Sumter | Alabama | 1119 | 31 | 0 |
64676 | 64676 | 2020-04-17 | Sumter | Alabama | 1119 | 33 | 0 |
67424 | 67424 | 2020-04-18 | Sumter | Alabama | 1119 | 35 | 0 |
70186 | 70186 | 2020-04-19 | Sumter | Alabama | 1119 | 36 | 0 |
72955 | 72955 | 2020-04-20 | Sumter | Alabama | 1119 | 40 | 0 |
75731 | 75731 | 2020-04-21 | Sumter | Alabama | 1119 | 44 | 0 |
78514 | 78514 | 2020-04-22 | Sumter | Alabama | 1119 | 46 | 1 |
81307 | 81307 | 2020-04-23 | Sumter | Alabama | 1119 | 47 | 1 |
84108 | 84108 | 2020-04-24 | Sumter | Alabama | 1119 | 51 | 1 |
86916 | 86916 | 2020-04-25 | Sumter | Alabama | 1119 | 51 | 1 |
89732 | 89732 | 2020-04-26 | Sumter | Alabama | 1119 | 53 | 2 |
92550 | 92550 | 2020-04-27 | Sumter | Alabama | 1119 | 55 | 2 |
95380 | 95380 | 2020-04-28 | Sumter | Alabama | 1119 | 55 | 2 |
98225 | 98225 | 2020-04-29 | Sumter | Alabama | 1119 | 56 | 2 |
101075 | 101075 | 2020-04-30 | Sumter | Alabama | 1119 | 64 | 2 |
103930 | 103930 | 2020-05-01 | Sumter | Alabama | 1119 | 68 | 3 |
106795 | 106795 | 2020-05-02 | Sumter | Alabama | 1119 | 72 | 3 |
109664 | 109664 | 2020-05-03 | Sumter | Alabama | 1119 | 77 | 3 |
112539 | 112539 | 2020-05-04 | Sumter | Alabama | 1119 | 81 | 3 |
115422 | 115422 | 2020-05-05 | Sumter | Alabama | 1119 | 85 | 3 |
118381 | 118381 | 2020-05-06 | Sumter | Alabama | 1119 | 87 | 4 |
121347 | 121347 | 2020-05-07 | Sumter | Alabama | 1119 | 92 | 4 |
124327 | 124327 | 2020-05-08 | Sumter | Alabama | 1119 | 93 | 4 |
127312 | 127312 | 2020-05-09 | Sumter | Alabama | 1119 | 98 | 4 |
130302 | 130302 | 2020-05-10 | Sumter | Alabama | 1119 | 100 | 4 |
133292 | 133292 | 2020-05-11 | Sumter | Alabama | 1119 | 106 | 4 |
136282 | 136282 | 2020-05-12 | Sumter | Alabama | 1119 | 110 | 4 |
139273 | 139273 | 2020-05-13 | Sumter | Alabama | 1119 | 110 | 4 |
142269 | 142269 | 2020-05-14 | Sumter | Alabama | 1119 | 115 | 4 |
145268 | 145268 | 2020-05-15 | Sumter | Alabama | 1119 | 120 | 4 |
148271 | 148271 | 2020-05-16 | Sumter | Alabama | 1119 | 124 | 4 |
151280 | 151280 | 2020-05-17 | Sumter | Alabama | 1119 | 127 | 4 |
154292 | 154292 | 2020-05-18 | Sumter | Alabama | 1119 | 136 | 4 |
157308 | 157308 | 2020-05-19 | Sumter | Alabama | 1119 | 148 | 4 |
160332 | 160332 | 2020-05-20 | Sumter | Alabama | 1119 | 164 | 5 |
163360 | 163360 | 2020-05-21 | Sumter | Alabama | 1119 | 170 | 5 |
166392 | 166392 | 2020-05-22 | Sumter | Alabama | 1119 | 172 | 6 |
169428 | 169428 | 2020-05-23 | Sumter | Alabama | 1119 | 185 | 6 |
172469 | 172469 | 2020-05-24 | Sumter | Alabama | 1119 | 191 | 6 |
175512 | 175512 | 2020-05-25 | Sumter | Alabama | 1119 | 193 | 6 |
178557 | 178557 | 2020-05-26 | Sumter | Alabama | 1119 | 204 | 6 |
181601 | 181601 | 2020-05-27 | Sumter | Alabama | 1119 | 210 | 6 |
184653 | 184653 | 2020-05-28 | Sumter | Alabama | 1119 | 213 | 6 |
187710 | 187710 | 2020-05-29 | Sumter | Alabama | 1119 | 216 | 6 |
190774 | 190774 | 2020-05-30 | Sumter | Alabama | 1119 | 220 | 6 |
193840 | 193840 | 2020-05-31 | Sumter | Alabama | 1119 | 224 | 7 |
196910 | 196910 | 2020-06-01 | Sumter | Alabama | 1119 | 225 | 7 |
199983 | 199983 | 2020-06-02 | Sumter | Alabama | 1119 | 227 | 7 |
203059 | 203059 | 2020-06-03 | Sumter | Alabama | 1119 | 229 | 7 |
206138 | 206138 | 2020-06-04 | Sumter | Alabama | 1119 | 229 | 7 |
209220 | 209220 | 2020-06-05 | Sumter | Alabama | 1119 | 237 | 9 |
212305 | 212305 | 2020-06-06 | Sumter | Alabama | 1119 | 244 | 8 |
215392 | 215392 | 2020-06-07 | Sumter | Alabama | 1119 | 246 | 8 |
218482 | 218482 | 2020-06-08 | Sumter | Alabama | 1119 | 248 | 9 |
221574 | 221574 | 2020-06-09 | Sumter | Alabama | 1119 | 249 | 9 |
224670 | 224670 | 2020-06-10 | Sumter | Alabama | 1119 | 249 | 10 |
227771 | 227771 | 2020-06-11 | Sumter | Alabama | 1119 | 254 | 11 |
230875 | 230875 | 2020-06-12 | Sumter | Alabama | 1119 | 258 | 11 |
233980 | 233980 | 2020-06-13 | Sumter | Alabama | 1119 | 261 | 11 |
237087 | 237087 | 2020-06-14 | Sumter | Alabama | 1119 | 264 | 11 |
240195 | 240195 | 2020-06-15 | Sumter | Alabama | 1119 | 264 | 11 |
243306 | 243306 | 2020-06-16 | Sumter | Alabama | 1119 | 264 | 11 |
246419 | 246419 | 2020-06-17 | Sumter | Alabama | 1119 | 265 | 11 |
249531 | 249531 | 2020-06-18 | Sumter | Alabama | 1119 | 267 | 12 |
252646 | 252646 | 2020-06-19 | Sumter | Alabama | 1119 | 268 | 12 |
255765 | 255765 | 2020-06-20 | Sumter | Alabama | 1119 | 269 | 12 |
258892 | 258892 | 2020-06-21 | Sumter | Alabama | 1119 | 269 | 12 |
262019 | 262019 | 2020-06-22 | Sumter | Alabama | 1119 | 269 | 12 |
265148 | 265148 | 2020-06-23 | Sumter | Alabama | 1119 | 270 | 12 |
268277 | 268277 | 2020-06-24 | Sumter | Alabama | 1119 | 272 | 12 |
271411 | 271411 | 2020-06-25 | Sumter | Alabama | 1119 | 272 | 12 |
274551 | 274551 | 2020-06-26 | Sumter | Alabama | 1119 | 275 | 12 |
277699 | 277699 | 2020-06-27 | Sumter | Alabama | 1119 | 275 | 12 |
280847 | 280847 | 2020-06-28 | Sumter | Alabama | 1119 | 275 | 12 |
283993 | 283993 | 2020-06-29 | Sumter | Alabama | 1119 | 275 | 12 |
287139 | 287139 | 2020-06-30 | Sumter | Alabama | 1119 | 276 | 12 |
290289 | 290289 | 2020-07-01 | Sumter | Alabama | 1119 | 277 | 12 |
293442 | 293442 | 2020-07-02 | Sumter | Alabama | 1119 | 280 | 12 |
296597 | 296597 | 2020-07-03 | Sumter | Alabama | 1119 | 285 | 12 |
299759 | 299759 | 2020-07-04 | Sumter | Alabama | 1119 | 285 | 12 |
302923 | 302923 | 2020-07-05 | Sumter | Alabama | 1119 | 286 | 12 |
306087 | 306087 | 2020-07-06 | Sumter | Alabama | 1119 | 286 | 12 |
309256 | 309256 | 2020-07-07 | Sumter | Alabama | 1119 | 286 | 12 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);