ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1121 and state = "Alabama" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
274552 | 274552 | 2020-06-26 | Talladega | Alabama | 1121 | 214 | 6 |
277700 | 277700 | 2020-06-27 | Talladega | Alabama | 1121 | 228 | 6 |
280848 | 280848 | 2020-06-28 | Talladega | Alabama | 1121 | 231 | 6 |
283994 | 283994 | 2020-06-29 | Talladega | Alabama | 1121 | 253 | 6 |
287140 | 287140 | 2020-06-30 | Talladega | Alabama | 1121 | 265 | 7 |
290290 | 290290 | 2020-07-01 | Talladega | Alabama | 1121 | 275 | 8 |
293443 | 293443 | 2020-07-02 | Talladega | Alabama | 1121 | 290 | 8 |
296598 | 296598 | 2020-07-03 | Talladega | Alabama | 1121 | 308 | 8 |
299760 | 299760 | 2020-07-04 | Talladega | Alabama | 1121 | 311 | 8 |
302924 | 302924 | 2020-07-05 | Talladega | Alabama | 1121 | 317 | 8 |
306088 | 306088 | 2020-07-06 | Talladega | Alabama | 1121 | 325 | 8 |
309257 | 309257 | 2020-07-07 | Talladega | Alabama | 1121 | 331 | 8 |
312426 | 312426 | 2020-07-08 | Talladega | Alabama | 1121 | 342 | 8 |
315601 | 315601 | 2020-07-09 | Talladega | Alabama | 1121 | 361 | 8 |
318774 | 318774 | 2020-07-10 | Talladega | Alabama | 1121 | 379 | 8 |
321953 | 321953 | 2020-07-11 | Talladega | Alabama | 1121 | 406 | 8 |
325134 | 325134 | 2020-07-12 | Talladega | Alabama | 1121 | 423 | 8 |
328320 | 328320 | 2020-07-13 | Talladega | Alabama | 1121 | 448 | 8 |
331506 | 331506 | 2020-07-14 | Talladega | Alabama | 1121 | 467 | 8 |
334699 | 334699 | 2020-07-15 | Talladega | Alabama | 1121 | 485 | 8 |
337894 | 337894 | 2020-07-16 | Talladega | Alabama | 1121 | 547 | 8 |
341090 | 341090 | 2020-07-17 | Talladega | Alabama | 1121 | 580 | 9 |
344289 | 344289 | 2020-07-18 | Talladega | Alabama | 1121 | 615 | 9 |
347489 | 347489 | 2020-07-19 | Talladega | Alabama | 1121 | 635 | 9 |
350690 | 350690 | 2020-07-20 | Talladega | Alabama | 1121 | 658 | 9 |
353892 | 353892 | 2020-07-21 | Talladega | Alabama | 1121 | 681 | 9 |
357095 | 357095 | 2020-07-22 | Talladega | Alabama | 1121 | 705 | 9 |
360300 | 360300 | 2020-07-23 | Talladega | Alabama | 1121 | 733 | 9 |
363506 | 363506 | 2020-07-24 | Talladega | Alabama | 1121 | 760 | 9 |
366713 | 366713 | 2020-07-25 | Talladega | Alabama | 1121 | 799 | 9 |
369923 | 369923 | 2020-07-26 | Talladega | Alabama | 1121 | 821 | 10 |
373135 | 373135 | 2020-07-27 | Talladega | Alabama | 1121 | 855 | 10 |
376349 | 376349 | 2020-07-28 | Talladega | Alabama | 1121 | 877 | 10 |
379565 | 379565 | 2020-07-29 | Talladega | Alabama | 1121 | 916 | 13 |
382782 | 382782 | 2020-07-30 | Talladega | Alabama | 1121 | 944 | 13 |
386000 | 386000 | 2020-07-31 | Talladega | Alabama | 1121 | 983 | 13 |
389217 | 389217 | 2020-08-01 | Talladega | Alabama | 1121 | 1005 | 14 |
392434 | 392434 | 2020-08-02 | Talladega | Alabama | 1121 | 1035 | 14 |
395650 | 395650 | 2020-08-03 | Talladega | Alabama | 1121 | 1075 | 14 |
398866 | 398866 | 2020-08-04 | Talladega | Alabama | 1121 | 1096 | 14 |
402082 | 402082 | 2020-08-05 | Talladega | Alabama | 1121 | 1116 | 14 |
405300 | 405300 | 2020-08-06 | Talladega | Alabama | 1121 | 1187 | 14 |
408520 | 408520 | 2020-08-07 | Talladega | Alabama | 1121 | 1229 | 14 |
411739 | 411739 | 2020-08-08 | Talladega | Alabama | 1121 | 1257 | 14 |
414959 | 414959 | 2020-08-09 | Talladega | Alabama | 1121 | 1274 | 15 |
418180 | 418180 | 2020-08-10 | Talladega | Alabama | 1121 | 1298 | 15 |
421401 | 421401 | 2020-08-11 | Talladega | Alabama | 1121 | 1324 | 15 |
424622 | 424622 | 2020-08-12 | Talladega | Alabama | 1121 | 1339 | 15 |
427846 | 427846 | 2020-08-13 | Talladega | Alabama | 1121 | 1359 | 15 |
431074 | 431074 | 2020-08-14 | Talladega | Alabama | 1121 | 1374 | 15 |
434299 | 434299 | 2020-08-15 | Talladega | Alabama | 1121 | 1395 | 15 |
437525 | 437525 | 2020-08-16 | Talladega | Alabama | 1121 | 1419 | 15 |
440751 | 440751 | 2020-08-17 | Talladega | Alabama | 1121 | 1432 | 16 |
443977 | 443977 | 2020-08-18 | Talladega | Alabama | 1121 | 1460 | 16 |
447204 | 447204 | 2020-08-19 | Talladega | Alabama | 1121 | 1490 | 16 |
450432 | 450432 | 2020-08-20 | Talladega | Alabama | 1121 | 1520 | 16 |
453660 | 453660 | 2020-08-21 | Talladega | Alabama | 1121 | 1525 | 16 |
456888 | 456888 | 2020-08-22 | Talladega | Alabama | 1121 | 1522 | 17 |
460115 | 460115 | 2020-08-23 | Talladega | Alabama | 1121 | 1530 | 17 |
463344 | 463344 | 2020-08-24 | Talladega | Alabama | 1121 | 1581 | 17 |
466573 | 466573 | 2020-08-25 | Talladega | Alabama | 1121 | 1593 | 17 |
469802 | 469802 | 2020-08-26 | Talladega | Alabama | 1121 | 1645 | 17 |
473034 | 473034 | 2020-08-27 | Talladega | Alabama | 1121 | 1659 | 19 |
476267 | 476267 | 2020-08-28 | Talladega | Alabama | 1121 | 1679 | 19 |
479500 | 479500 | 2020-08-29 | Talladega | Alabama | 1121 | 1733 | 19 |
482734 | 482734 | 2020-08-30 | Talladega | Alabama | 1121 | 1752 | 20 |
485969 | 485969 | 2020-08-31 | Talladega | Alabama | 1121 | 1764 | 20 |
489202 | 489202 | 2020-09-01 | Talladega | Alabama | 1121 | 1787 | 21 |
492435 | 492435 | 2020-09-02 | Talladega | Alabama | 1121 | 1791 | 22 |
495669 | 495669 | 2020-09-03 | Talladega | Alabama | 1121 | 1810 | 23 |
498902 | 498902 | 2020-09-04 | Talladega | Alabama | 1121 | 1826 | 24 |
502136 | 502136 | 2020-09-05 | Talladega | Alabama | 1121 | 1841 | 24 |
505370 | 505370 | 2020-09-06 | Talladega | Alabama | 1121 | 1848 | 24 |
508602 | 508602 | 2020-09-07 | Talladega | Alabama | 1121 | 1857 | 24 |
511835 | 511835 | 2020-09-08 | Talladega | Alabama | 1121 | 1875 | 24 |
515068 | 515068 | 2020-09-09 | Talladega | Alabama | 1121 | 1877 | 24 |
518303 | 518303 | 2020-09-10 | Talladega | Alabama | 1121 | 1903 | 24 |
521540 | 521540 | 2020-09-11 | Talladega | Alabama | 1121 | 1921 | 24 |
524776 | 524776 | 2020-09-12 | Talladega | Alabama | 1121 | 1933 | 25 |
528012 | 528012 | 2020-09-13 | Talladega | Alabama | 1121 | 1949 | 25 |
531249 | 531249 | 2020-09-14 | Talladega | Alabama | 1121 | 1966 | 25 |
534484 | 534484 | 2020-09-15 | Talladega | Alabama | 1121 | 1981 | 25 |
537720 | 537720 | 2020-09-16 | Talladega | Alabama | 1121 | 1991 | 25 |
540957 | 540957 | 2020-09-17 | Talladega | Alabama | 1121 | 1999 | 25 |
544193 | 544193 | 2020-09-18 | Talladega | Alabama | 1121 | 2034 | 26 |
547430 | 547430 | 2020-09-19 | Talladega | Alabama | 1121 | 2050 | 26 |
550669 | 550669 | 2020-09-20 | Talladega | Alabama | 1121 | 2069 | 26 |
553908 | 553908 | 2020-09-21 | Talladega | Alabama | 1121 | 2077 | 26 |
557145 | 557145 | 2020-09-22 | Talladega | Alabama | 1121 | 2099 | 27 |
560381 | 560381 | 2020-09-23 | Talladega | Alabama | 1121 | 2106 | 28 |
563620 | 563620 | 2020-09-24 | Talladega | Alabama | 1121 | 2127 | 28 |
566861 | 566861 | 2020-09-25 | Talladega | Alabama | 1121 | 2146 | 28 |
570102 | 570102 | 2020-09-26 | Talladega | Alabama | 1121 | 2166 | 29 |
573344 | 573344 | 2020-09-27 | Talladega | Alabama | 1121 | 2171 | 29 |
576588 | 576588 | 2020-09-28 | Talladega | Alabama | 1121 | 2177 | 29 |
579829 | 579829 | 2020-09-29 | Talladega | Alabama | 1121 | 2178 | 30 |
583068 | 583068 | 2020-09-30 | Talladega | Alabama | 1121 | 2190 | 30 |
586308 | 586308 | 2020-10-01 | Talladega | Alabama | 1121 | 2192 | 30 |
589549 | 589549 | 2020-10-02 | Talladega | Alabama | 1121 | 2201 | 30 |
592789 | 592789 | 2020-10-03 | Talladega | Alabama | 1121 | 2247 | 30 |
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);