ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 1001 and state = "Alabama" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
293383 | 293383 | 2020-07-02 | Autauga | Alabama | 1001 | 561 | 13 |
296538 | 296538 | 2020-07-03 | Autauga | Alabama | 1001 | 568 | 13 |
299700 | 299700 | 2020-07-04 | Autauga | Alabama | 1001 | 591 | 13 |
302864 | 302864 | 2020-07-05 | Autauga | Alabama | 1001 | 615 | 13 |
306028 | 306028 | 2020-07-06 | Autauga | Alabama | 1001 | 618 | 13 |
309197 | 309197 | 2020-07-07 | Autauga | Alabama | 1001 | 644 | 13 |
312366 | 312366 | 2020-07-08 | Autauga | Alabama | 1001 | 651 | 13 |
315541 | 315541 | 2020-07-09 | Autauga | Alabama | 1001 | 661 | 14 |
318714 | 318714 | 2020-07-10 | Autauga | Alabama | 1001 | 670 | 15 |
321893 | 321893 | 2020-07-11 | Autauga | Alabama | 1001 | 684 | 15 |
325074 | 325074 | 2020-07-12 | Autauga | Alabama | 1001 | 706 | 16 |
328260 | 328260 | 2020-07-13 | Autauga | Alabama | 1001 | 728 | 16 |
331446 | 331446 | 2020-07-14 | Autauga | Alabama | 1001 | 746 | 18 |
334639 | 334639 | 2020-07-15 | Autauga | Alabama | 1001 | 756 | 19 |
337834 | 337834 | 2020-07-16 | Autauga | Alabama | 1001 | 780 | 20 |
341030 | 341030 | 2020-07-17 | Autauga | Alabama | 1001 | 789 | 21 |
344229 | 344229 | 2020-07-18 | Autauga | Alabama | 1001 | 827 | 21 |
347429 | 347429 | 2020-07-19 | Autauga | Alabama | 1001 | 842 | 21 |
350630 | 350630 | 2020-07-20 | Autauga | Alabama | 1001 | 857 | 21 |
353832 | 353832 | 2020-07-21 | Autauga | Alabama | 1001 | 865 | 21 |
357035 | 357035 | 2020-07-22 | Autauga | Alabama | 1001 | 886 | 21 |
360240 | 360240 | 2020-07-23 | Autauga | Alabama | 1001 | 905 | 21 |
363446 | 363446 | 2020-07-24 | Autauga | Alabama | 1001 | 921 | 21 |
366653 | 366653 | 2020-07-25 | Autauga | Alabama | 1001 | 932 | 21 |
369863 | 369863 | 2020-07-26 | Autauga | Alabama | 1001 | 942 | 21 |
373075 | 373075 | 2020-07-27 | Autauga | Alabama | 1001 | 965 | 21 |
376289 | 376289 | 2020-07-28 | Autauga | Alabama | 1001 | 974 | 21 |
379505 | 379505 | 2020-07-29 | Autauga | Alabama | 1001 | 987 | 21 |
382722 | 382722 | 2020-07-30 | Autauga | Alabama | 1001 | 1002 | 21 |
385940 | 385940 | 2020-07-31 | Autauga | Alabama | 1001 | 1015 | 21 |
389157 | 389157 | 2020-08-01 | Autauga | Alabama | 1001 | 1030 | 21 |
392374 | 392374 | 2020-08-02 | Autauga | Alabama | 1001 | 1052 | 21 |
395590 | 395590 | 2020-08-03 | Autauga | Alabama | 1001 | 1066 | 21 |
398806 | 398806 | 2020-08-04 | Autauga | Alabama | 1001 | 1073 | 21 |
402022 | 402022 | 2020-08-05 | Autauga | Alabama | 1001 | 1073 | 22 |
405240 | 405240 | 2020-08-06 | Autauga | Alabama | 1001 | 1096 | 22 |
408460 | 408460 | 2020-08-07 | Autauga | Alabama | 1001 | 1113 | 22 |
411679 | 411679 | 2020-08-08 | Autauga | Alabama | 1001 | 1134 | 22 |
414899 | 414899 | 2020-08-09 | Autauga | Alabama | 1001 | 1217 | 22 |
418120 | 418120 | 2020-08-10 | Autauga | Alabama | 1001 | 1222 | 22 |
421341 | 421341 | 2020-08-11 | Autauga | Alabama | 1001 | 1215 | 23 |
424562 | 424562 | 2020-08-12 | Autauga | Alabama | 1001 | 1241 | 23 |
427786 | 427786 | 2020-08-13 | Autauga | Alabama | 1001 | 1250 | 23 |
431014 | 431014 | 2020-08-14 | Autauga | Alabama | 1001 | 1252 | 23 |
434239 | 434239 | 2020-08-15 | Autauga | Alabama | 1001 | 1262 | 23 |
437465 | 437465 | 2020-08-16 | Autauga | Alabama | 1001 | 1273 | 23 |
440691 | 440691 | 2020-08-17 | Autauga | Alabama | 1001 | 1274 | 23 |
443917 | 443917 | 2020-08-18 | Autauga | Alabama | 1001 | 1291 | 23 |
447144 | 447144 | 2020-08-19 | Autauga | Alabama | 1001 | 1298 | 23 |
450372 | 450372 | 2020-08-20 | Autauga | Alabama | 1001 | 1298 | 23 |
453600 | 453600 | 2020-08-21 | Autauga | Alabama | 1001 | 1313 | 23 |
456828 | 456828 | 2020-08-22 | Autauga | Alabama | 1001 | 1322 | 23 |
460055 | 460055 | 2020-08-23 | Autauga | Alabama | 1001 | 1324 | 23 |
463284 | 463284 | 2020-08-24 | Autauga | Alabama | 1001 | 1351 | 23 |
466513 | 466513 | 2020-08-25 | Autauga | Alabama | 1001 | 1355 | 23 |
469742 | 469742 | 2020-08-26 | Autauga | Alabama | 1001 | 1366 | 23 |
472974 | 472974 | 2020-08-27 | Autauga | Alabama | 1001 | 1377 | 23 |
476207 | 476207 | 2020-08-28 | Autauga | Alabama | 1001 | 1389 | 23 |
479440 | 479440 | 2020-08-29 | Autauga | Alabama | 1001 | 1400 | 23 |
482674 | 482674 | 2020-08-30 | Autauga | Alabama | 1001 | 1438 | 23 |
485909 | 485909 | 2020-08-31 | Autauga | Alabama | 1001 | 1442 | 23 |
489142 | 489142 | 2020-09-01 | Autauga | Alabama | 1001 | 1453 | 24 |
492375 | 492375 | 2020-09-02 | Autauga | Alabama | 1001 | 1452 | 24 |
495609 | 495609 | 2020-09-03 | Autauga | Alabama | 1001 | 1466 | 24 |
498842 | 498842 | 2020-09-04 | Autauga | Alabama | 1001 | 1475 | 24 |
502076 | 502076 | 2020-09-05 | Autauga | Alabama | 1001 | 1492 | 24 |
505310 | 505310 | 2020-09-06 | Autauga | Alabama | 1001 | 1498 | 24 |
508542 | 508542 | 2020-09-07 | Autauga | Alabama | 1001 | 1504 | 24 |
511775 | 511775 | 2020-09-08 | Autauga | Alabama | 1001 | 1508 | 24 |
515008 | 515008 | 2020-09-09 | Autauga | Alabama | 1001 | 1522 | 24 |
518243 | 518243 | 2020-09-10 | Autauga | Alabama | 1001 | 1544 | 24 |
521480 | 521480 | 2020-09-11 | Autauga | Alabama | 1001 | 1551 | 24 |
524716 | 524716 | 2020-09-12 | Autauga | Alabama | 1001 | 1565 | 24 |
527952 | 527952 | 2020-09-13 | Autauga | Alabama | 1001 | 1576 | 24 |
531189 | 531189 | 2020-09-14 | Autauga | Alabama | 1001 | 1585 | 24 |
534424 | 534424 | 2020-09-15 | Autauga | Alabama | 1001 | 1601 | 24 |
537660 | 537660 | 2020-09-16 | Autauga | Alabama | 1001 | 1619 | 24 |
540897 | 540897 | 2020-09-17 | Autauga | Alabama | 1001 | 1624 | 24 |
544133 | 544133 | 2020-09-18 | Autauga | Alabama | 1001 | 1664 | 24 |
547370 | 547370 | 2020-09-19 | Autauga | Alabama | 1001 | 1673 | 24 |
550609 | 550609 | 2020-09-20 | Autauga | Alabama | 1001 | 1690 | 24 |
553848 | 553848 | 2020-09-21 | Autauga | Alabama | 1001 | 1691 | 24 |
557085 | 557085 | 2020-09-22 | Autauga | Alabama | 1001 | 1714 | 25 |
560321 | 560321 | 2020-09-23 | Autauga | Alabama | 1001 | 1715 | 25 |
563560 | 563560 | 2020-09-24 | Autauga | Alabama | 1001 | 1738 | 25 |
566801 | 566801 | 2020-09-25 | Autauga | Alabama | 1001 | 1757 | 25 |
570042 | 570042 | 2020-09-26 | Autauga | Alabama | 1001 | 1764 | 25 |
573284 | 573284 | 2020-09-27 | Autauga | Alabama | 1001 | 1773 | 25 |
576528 | 576528 | 2020-09-28 | Autauga | Alabama | 1001 | 1785 | 25 |
579769 | 579769 | 2020-09-29 | Autauga | Alabama | 1001 | 1787 | 27 |
583008 | 583008 | 2020-09-30 | Autauga | Alabama | 1001 | 1791 | 27 |
586248 | 586248 | 2020-10-01 | Autauga | Alabama | 1001 | 1798 | 28 |
589489 | 589489 | 2020-10-02 | Autauga | Alabama | 1001 | 1805 | 27 |
592729 | 592729 | 2020-10-03 | Autauga | Alabama | 1001 | 1818 | 27 |
595971 | 595971 | 2020-10-04 | Autauga | Alabama | 1001 | 1828 | 27 |
599214 | 599214 | 2020-10-05 | Autauga | Alabama | 1001 | 1831 | 27 |
602457 | 602457 | 2020-10-06 | Autauga | Alabama | 1001 | 1839 | 27 |
605699 | 605699 | 2020-10-07 | Autauga | Alabama | 1001 | 1852 | 27 |
608942 | 608942 | 2020-10-08 | Autauga | Alabama | 1001 | 1863 | 28 |
612184 | 612184 | 2020-10-09 | Autauga | Alabama | 1001 | 1882 | 28 |
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);