ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Madison" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382766 | 382766 | 2020-07-30 | Madison | Alabama | 1089 | 4744 | 30 |
379549 | 379549 | 2020-07-29 | Madison | Alabama | 1089 | 4581 | 30 |
376333 | 376333 | 2020-07-28 | Madison | Alabama | 1089 | 4522 | 25 |
373119 | 373119 | 2020-07-27 | Madison | Alabama | 1089 | 4403 | 25 |
369907 | 369907 | 2020-07-26 | Madison | Alabama | 1089 | 4303 | 25 |
366697 | 366697 | 2020-07-25 | Madison | Alabama | 1089 | 4202 | 25 |
363490 | 363490 | 2020-07-24 | Madison | Alabama | 1089 | 4099 | 25 |
360284 | 360284 | 2020-07-23 | Madison | Alabama | 1089 | 3941 | 20 |
357079 | 357079 | 2020-07-22 | Madison | Alabama | 1089 | 3792 | 20 |
353876 | 353876 | 2020-07-21 | Madison | Alabama | 1089 | 3706 | 16 |
350674 | 350674 | 2020-07-20 | Madison | Alabama | 1089 | 3633 | 15 |
347473 | 347473 | 2020-07-19 | Madison | Alabama | 1089 | 3505 | 15 |
344273 | 344273 | 2020-07-18 | Madison | Alabama | 1089 | 3366 | 15 |
341074 | 341074 | 2020-07-17 | Madison | Alabama | 1089 | 3190 | 15 |
337878 | 337878 | 2020-07-16 | Madison | Alabama | 1089 | 3014 | 14 |
334683 | 334683 | 2020-07-15 | Madison | Alabama | 1089 | 2942 | 13 |
331490 | 331490 | 2020-07-14 | Madison | Alabama | 1089 | 2767 | 10 |
328304 | 328304 | 2020-07-13 | Madison | Alabama | 1089 | 2573 | 10 |
325118 | 325118 | 2020-07-12 | Madison | Alabama | 1089 | 2304 | 10 |
321937 | 321937 | 2020-07-11 | Madison | Alabama | 1089 | 2150 | 10 |
318758 | 318758 | 2020-07-10 | Madison | Alabama | 1089 | 2012 | 10 |
315585 | 315585 | 2020-07-09 | Madison | Alabama | 1089 | 1934 | 9 |
312410 | 312410 | 2020-07-08 | Madison | Alabama | 1089 | 1646 | 9 |
309241 | 309241 | 2020-07-07 | Madison | Alabama | 1089 | 1579 | 9 |
306072 | 306072 | 2020-07-06 | Madison | Alabama | 1089 | 1516 | 8 |
302908 | 302908 | 2020-07-05 | Madison | Alabama | 1089 | 1455 | 8 |
299744 | 299744 | 2020-07-04 | Madison | Alabama | 1089 | 1384 | 8 |
296582 | 296582 | 2020-07-03 | Madison | Alabama | 1089 | 1296 | 8 |
293427 | 293427 | 2020-07-02 | Madison | Alabama | 1089 | 1129 | 8 |
290274 | 290274 | 2020-07-01 | Madison | Alabama | 1089 | 1084 | 8 |
287124 | 287124 | 2020-06-30 | Madison | Alabama | 1089 | 1047 | 7 |
283978 | 283978 | 2020-06-29 | Madison | Alabama | 1089 | 1021 | 7 |
280832 | 280832 | 2020-06-28 | Madison | Alabama | 1089 | 930 | 7 |
277684 | 277684 | 2020-06-27 | Madison | Alabama | 1089 | 921 | 7 |
274536 | 274536 | 2020-06-26 | Madison | Alabama | 1089 | 889 | 7 |
271396 | 271396 | 2020-06-25 | Madison | Alabama | 1089 | 842 | 6 |
268262 | 268262 | 2020-06-24 | Madison | Alabama | 1089 | 775 | 6 |
265133 | 265133 | 2020-06-23 | Madison | Alabama | 1089 | 749 | 6 |
262004 | 262004 | 2020-06-22 | Madison | Alabama | 1089 | 733 | 6 |
258877 | 258877 | 2020-06-21 | Madison | Alabama | 1089 | 723 | 6 |
255750 | 255750 | 2020-06-20 | Madison | Alabama | 1089 | 708 | 6 |
252631 | 252631 | 2020-06-19 | Madison | Alabama | 1089 | 671 | 6 |
249516 | 249516 | 2020-06-18 | Madison | Alabama | 1089 | 646 | 6 |
246404 | 246404 | 2020-06-17 | Madison | Alabama | 1089 | 598 | 6 |
243291 | 243291 | 2020-06-16 | Madison | Alabama | 1089 | 598 | 6 |
240180 | 240180 | 2020-06-15 | Madison | Alabama | 1089 | 587 | 5 |
237072 | 237072 | 2020-06-14 | Madison | Alabama | 1089 | 553 | 5 |
233965 | 233965 | 2020-06-13 | Madison | Alabama | 1089 | 493 | 5 |
230860 | 230860 | 2020-06-12 | Madison | Alabama | 1089 | 477 | 5 |
227756 | 227756 | 2020-06-11 | Madison | Alabama | 1089 | 449 | 5 |
224655 | 224655 | 2020-06-10 | Madison | Alabama | 1089 | 434 | 5 |
221559 | 221559 | 2020-06-09 | Madison | Alabama | 1089 | 418 | 5 |
218467 | 218467 | 2020-06-08 | Madison | Alabama | 1089 | 407 | 5 |
215377 | 215377 | 2020-06-07 | Madison | Alabama | 1089 | 397 | 5 |
212290 | 212290 | 2020-06-06 | Madison | Alabama | 1089 | 392 | 5 |
209205 | 209205 | 2020-06-05 | Madison | Alabama | 1089 | 380 | 4 |
206123 | 206123 | 2020-06-04 | Madison | Alabama | 1089 | 374 | 4 |
203044 | 203044 | 2020-06-03 | Madison | Alabama | 1089 | 367 | 4 |
199968 | 199968 | 2020-06-02 | Madison | Alabama | 1089 | 365 | 4 |
196895 | 196895 | 2020-06-01 | Madison | Alabama | 1089 | 363 | 4 |
193825 | 193825 | 2020-05-31 | Madison | Alabama | 1089 | 339 | 4 |
190759 | 190759 | 2020-05-30 | Madison | Alabama | 1089 | 327 | 4 |
187695 | 187695 | 2020-05-29 | Madison | Alabama | 1089 | 324 | 4 |
184638 | 184638 | 2020-05-28 | Madison | Alabama | 1089 | 318 | 4 |
181586 | 181586 | 2020-05-27 | Madison | Alabama | 1089 | 315 | 4 |
178542 | 178542 | 2020-05-26 | Madison | Alabama | 1089 | 309 | 4 |
175497 | 175497 | 2020-05-25 | Madison | Alabama | 1089 | 302 | 4 |
172454 | 172454 | 2020-05-24 | Madison | Alabama | 1089 | 296 | 4 |
169413 | 169413 | 2020-05-23 | Madison | Alabama | 1089 | 292 | 4 |
166377 | 166377 | 2020-05-22 | Madison | Alabama | 1089 | 286 | 4 |
163345 | 163345 | 2020-05-21 | Madison | Alabama | 1089 | 284 | 4 |
160317 | 160317 | 2020-05-20 | Madison | Alabama | 1089 | 285 | 4 |
157293 | 157293 | 2020-05-19 | Madison | Alabama | 1089 | 278 | 4 |
154277 | 154277 | 2020-05-18 | Madison | Alabama | 1089 | 278 | 4 |
151265 | 151265 | 2020-05-17 | Madison | Alabama | 1089 | 275 | 4 |
148256 | 148256 | 2020-05-16 | Madison | Alabama | 1089 | 275 | 4 |
145253 | 145253 | 2020-05-15 | Madison | Alabama | 1089 | 274 | 4 |
142254 | 142254 | 2020-05-14 | Madison | Alabama | 1089 | 272 | 4 |
139258 | 139258 | 2020-05-13 | Madison | Alabama | 1089 | 259 | 4 |
136267 | 136267 | 2020-05-12 | Madison | Alabama | 1089 | 255 | 4 |
133277 | 133277 | 2020-05-11 | Madison | Alabama | 1089 | 250 | 4 |
130287 | 130287 | 2020-05-10 | Madison | Alabama | 1089 | 247 | 4 |
127297 | 127297 | 2020-05-09 | Madison | Alabama | 1089 | 247 | 4 |
124312 | 124312 | 2020-05-08 | Madison | Alabama | 1089 | 244 | 4 |
121332 | 121332 | 2020-05-07 | Madison | Alabama | 1089 | 241 | 4 |
118366 | 118366 | 2020-05-06 | Madison | Alabama | 1089 | 238 | 4 |
115407 | 115407 | 2020-05-05 | Madison | Alabama | 1089 | 238 | 4 |
112524 | 112524 | 2020-05-04 | Madison | Alabama | 1089 | 237 | 4 |
109649 | 109649 | 2020-05-03 | Madison | Alabama | 1089 | 234 | 4 |
106780 | 106780 | 2020-05-02 | Madison | Alabama | 1089 | 233 | 4 |
103915 | 103915 | 2020-05-01 | Madison | Alabama | 1089 | 225 | 4 |
101060 | 101060 | 2020-04-30 | Madison | Alabama | 1089 | 227 | 4 |
98210 | 98210 | 2020-04-29 | Madison | Alabama | 1089 | 224 | 4 |
95365 | 95365 | 2020-04-28 | Madison | Alabama | 1089 | 222 | 4 |
92535 | 92535 | 2020-04-27 | Madison | Alabama | 1089 | 214 | 4 |
89717 | 89717 | 2020-04-26 | Madison | Alabama | 1089 | 211 | 4 |
86901 | 86901 | 2020-04-25 | Madison | Alabama | 1089 | 210 | 4 |
84093 | 84093 | 2020-04-24 | Madison | Alabama | 1089 | 202 | 4 |
81292 | 81292 | 2020-04-23 | Madison | Alabama | 1089 | 205 | 4 |
78499 | 78499 | 2020-04-22 | Madison | Alabama | 1089 | 205 | 4 |
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);