ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 1115 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531247 | 531247 | 2020-09-14 | St. Clair | Alabama | 1115 | 2132 | 34 |
528010 | 528010 | 2020-09-13 | St. Clair | Alabama | 1115 | 2114 | 34 |
524774 | 524774 | 2020-09-12 | St. Clair | Alabama | 1115 | 2083 | 34 |
521538 | 521538 | 2020-09-11 | St. Clair | Alabama | 1115 | 2056 | 33 |
518301 | 518301 | 2020-09-10 | St. Clair | Alabama | 1115 | 2030 | 33 |
515066 | 515066 | 2020-09-09 | St. Clair | Alabama | 1115 | 2012 | 32 |
511833 | 511833 | 2020-09-08 | St. Clair | Alabama | 1115 | 1997 | 32 |
508600 | 508600 | 2020-09-07 | St. Clair | Alabama | 1115 | 1981 | 32 |
505368 | 505368 | 2020-09-06 | St. Clair | Alabama | 1115 | 1968 | 32 |
502134 | 502134 | 2020-09-05 | St. Clair | Alabama | 1115 | 1959 | 32 |
498900 | 498900 | 2020-09-04 | St. Clair | Alabama | 1115 | 1933 | 32 |
495667 | 495667 | 2020-09-03 | St. Clair | Alabama | 1115 | 1914 | 30 |
492433 | 492433 | 2020-09-02 | St. Clair | Alabama | 1115 | 1888 | 30 |
489200 | 489200 | 2020-09-01 | St. Clair | Alabama | 1115 | 1877 | 29 |
485967 | 485967 | 2020-08-31 | St. Clair | Alabama | 1115 | 1844 | 29 |
482732 | 482732 | 2020-08-30 | St. Clair | Alabama | 1115 | 1833 | 28 |
479498 | 479498 | 2020-08-29 | St. Clair | Alabama | 1115 | 1811 | 28 |
476265 | 476265 | 2020-08-28 | St. Clair | Alabama | 1115 | 1795 | 27 |
473032 | 473032 | 2020-08-27 | St. Clair | Alabama | 1115 | 1765 | 26 |
469800 | 469800 | 2020-08-26 | St. Clair | Alabama | 1115 | 1749 | 25 |
466571 | 466571 | 2020-08-25 | St. Clair | Alabama | 1115 | 1704 | 25 |
463342 | 463342 | 2020-08-24 | St. Clair | Alabama | 1115 | 1701 | 25 |
460113 | 460113 | 2020-08-23 | St. Clair | Alabama | 1115 | 1677 | 25 |
456886 | 456886 | 2020-08-22 | St. Clair | Alabama | 1115 | 1641 | 25 |
453658 | 453658 | 2020-08-21 | St. Clair | Alabama | 1115 | 1639 | 24 |
450430 | 450430 | 2020-08-20 | St. Clair | Alabama | 1115 | 1614 | 24 |
447202 | 447202 | 2020-08-19 | St. Clair | Alabama | 1115 | 1591 | 23 |
443975 | 443975 | 2020-08-18 | St. Clair | Alabama | 1115 | 1558 | 23 |
440749 | 440749 | 2020-08-17 | St. Clair | Alabama | 1115 | 1535 | 23 |
437523 | 437523 | 2020-08-16 | St. Clair | Alabama | 1115 | 1528 | 21 |
434297 | 434297 | 2020-08-15 | St. Clair | Alabama | 1115 | 1506 | 21 |
431072 | 431072 | 2020-08-14 | St. Clair | Alabama | 1115 | 1499 | 21 |
427844 | 427844 | 2020-08-13 | St. Clair | Alabama | 1115 | 1493 | 22 |
424620 | 424620 | 2020-08-12 | St. Clair | Alabama | 1115 | 1488 | 22 |
421399 | 421399 | 2020-08-11 | St. Clair | Alabama | 1115 | 1474 | 21 |
418178 | 418178 | 2020-08-10 | St. Clair | Alabama | 1115 | 1457 | 19 |
414957 | 414957 | 2020-08-09 | St. Clair | Alabama | 1115 | 1441 | 18 |
411737 | 411737 | 2020-08-08 | St. Clair | Alabama | 1115 | 1431 | 18 |
408518 | 408518 | 2020-08-07 | St. Clair | Alabama | 1115 | 1413 | 17 |
405298 | 405298 | 2020-08-06 | St. Clair | Alabama | 1115 | 1379 | 16 |
402080 | 402080 | 2020-08-05 | St. Clair | Alabama | 1115 | 1342 | 15 |
398864 | 398864 | 2020-08-04 | St. Clair | Alabama | 1115 | 1325 | 12 |
395648 | 395648 | 2020-08-03 | St. Clair | Alabama | 1115 | 1305 | 12 |
392432 | 392432 | 2020-08-02 | St. Clair | Alabama | 1115 | 1265 | 12 |
389215 | 389215 | 2020-08-01 | St. Clair | Alabama | 1115 | 1248 | 11 |
385998 | 385998 | 2020-07-31 | St. Clair | Alabama | 1115 | 1226 | 9 |
382780 | 382780 | 2020-07-30 | St. Clair | Alabama | 1115 | 1179 | 9 |
379563 | 379563 | 2020-07-29 | St. Clair | Alabama | 1115 | 1166 | 9 |
376347 | 376347 | 2020-07-28 | St. Clair | Alabama | 1115 | 1104 | 9 |
373133 | 373133 | 2020-07-27 | St. Clair | Alabama | 1115 | 1078 | 9 |
369921 | 369921 | 2020-07-26 | St. Clair | Alabama | 1115 | 1042 | 8 |
366711 | 366711 | 2020-07-25 | St. Clair | Alabama | 1115 | 1016 | 8 |
363504 | 363504 | 2020-07-24 | St. Clair | Alabama | 1115 | 990 | 7 |
360298 | 360298 | 2020-07-23 | St. Clair | Alabama | 1115 | 959 | 7 |
357093 | 357093 | 2020-07-22 | St. Clair | Alabama | 1115 | 928 | 5 |
353890 | 353890 | 2020-07-21 | St. Clair | Alabama | 1115 | 897 | 4 |
350688 | 350688 | 2020-07-20 | St. Clair | Alabama | 1115 | 865 | 4 |
347487 | 347487 | 2020-07-19 | St. Clair | Alabama | 1115 | 824 | 4 |
344287 | 344287 | 2020-07-18 | St. Clair | Alabama | 1115 | 797 | 4 |
341088 | 341088 | 2020-07-17 | St. Clair | Alabama | 1115 | 766 | 4 |
337892 | 337892 | 2020-07-16 | St. Clair | Alabama | 1115 | 732 | 4 |
334697 | 334697 | 2020-07-15 | St. Clair | Alabama | 1115 | 688 | 4 |
331504 | 331504 | 2020-07-14 | St. Clair | Alabama | 1115 | 663 | 3 |
328318 | 328318 | 2020-07-13 | St. Clair | Alabama | 1115 | 614 | 3 |
325132 | 325132 | 2020-07-12 | St. Clair | Alabama | 1115 | 560 | 3 |
321951 | 321951 | 2020-07-11 | St. Clair | Alabama | 1115 | 528 | 3 |
318772 | 318772 | 2020-07-10 | St. Clair | Alabama | 1115 | 499 | 2 |
315599 | 315599 | 2020-07-09 | St. Clair | Alabama | 1115 | 481 | 2 |
312424 | 312424 | 2020-07-08 | St. Clair | Alabama | 1115 | 452 | 2 |
309255 | 309255 | 2020-07-07 | St. Clair | Alabama | 1115 | 426 | 2 |
306086 | 306086 | 2020-07-06 | St. Clair | Alabama | 1115 | 412 | 2 |
302922 | 302922 | 2020-07-05 | St. Clair | Alabama | 1115 | 392 | 2 |
299758 | 299758 | 2020-07-04 | St. Clair | Alabama | 1115 | 376 | 2 |
296596 | 296596 | 2020-07-03 | St. Clair | Alabama | 1115 | 357 | 2 |
293441 | 293441 | 2020-07-02 | St. Clair | Alabama | 1115 | 329 | 2 |
290288 | 290288 | 2020-07-01 | St. Clair | Alabama | 1115 | 314 | 2 |
287138 | 287138 | 2020-06-30 | St. Clair | Alabama | 1115 | 302 | 2 |
283992 | 283992 | 2020-06-29 | St. Clair | Alabama | 1115 | 285 | 2 |
280846 | 280846 | 2020-06-28 | St. Clair | Alabama | 1115 | 257 | 2 |
277698 | 277698 | 2020-06-27 | St. Clair | Alabama | 1115 | 255 | 2 |
274550 | 274550 | 2020-06-26 | St. Clair | Alabama | 1115 | 245 | 2 |
271410 | 271410 | 2020-06-25 | St. Clair | Alabama | 1115 | 236 | 2 |
268276 | 268276 | 2020-06-24 | St. Clair | Alabama | 1115 | 227 | 2 |
265147 | 265147 | 2020-06-23 | St. Clair | Alabama | 1115 | 218 | 2 |
262018 | 262018 | 2020-06-22 | St. Clair | Alabama | 1115 | 212 | 2 |
258891 | 258891 | 2020-06-21 | St. Clair | Alabama | 1115 | 209 | 2 |
255764 | 255764 | 2020-06-20 | St. Clair | Alabama | 1115 | 204 | 2 |
252645 | 252645 | 2020-06-19 | St. Clair | Alabama | 1115 | 201 | 2 |
249530 | 249530 | 2020-06-18 | St. Clair | Alabama | 1115 | 190 | 2 |
246418 | 246418 | 2020-06-17 | St. Clair | Alabama | 1115 | 188 | 2 |
243305 | 243305 | 2020-06-16 | St. Clair | Alabama | 1115 | 184 | 2 |
240194 | 240194 | 2020-06-15 | St. Clair | Alabama | 1115 | 181 | 2 |
237086 | 237086 | 2020-06-14 | St. Clair | Alabama | 1115 | 178 | 2 |
233979 | 233979 | 2020-06-13 | St. Clair | Alabama | 1115 | 175 | 2 |
230874 | 230874 | 2020-06-12 | St. Clair | Alabama | 1115 | 166 | 2 |
227770 | 227770 | 2020-06-11 | St. Clair | Alabama | 1115 | 161 | 2 |
224669 | 224669 | 2020-06-10 | St. Clair | Alabama | 1115 | 157 | 2 |
221573 | 221573 | 2020-06-09 | St. Clair | Alabama | 1115 | 149 | 2 |
218481 | 218481 | 2020-06-08 | St. Clair | Alabama | 1115 | 149 | 2 |
215391 | 215391 | 2020-06-07 | St. Clair | Alabama | 1115 | 148 | 2 |
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);