ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Chambers" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917201 | 917201 | 2021-01-11 | Chambers | Alabama | 1017 | 2651 | 66 |
913956 | 913956 | 2021-01-10 | Chambers | Alabama | 1017 | 2639 | 66 |
910711 | 910711 | 2021-01-09 | Chambers | Alabama | 1017 | 2620 | 63 |
907466 | 907466 | 2021-01-08 | Chambers | Alabama | 1017 | 2592 | 63 |
904220 | 904220 | 2021-01-07 | Chambers | Alabama | 1017 | 2552 | 63 |
900975 | 900975 | 2021-01-06 | Chambers | Alabama | 1017 | 2519 | 63 |
897730 | 897730 | 2021-01-05 | Chambers | Alabama | 1017 | 2474 | 63 |
894484 | 894484 | 2021-01-04 | Chambers | Alabama | 1017 | 2415 | 63 |
891238 | 891238 | 2021-01-03 | Chambers | Alabama | 1017 | 2402 | 63 |
887991 | 887991 | 2021-01-02 | Chambers | Alabama | 1017 | 2386 | 63 |
884746 | 884746 | 2021-01-01 | Chambers | Alabama | 1017 | 2366 | 63 |
881501 | 881501 | 2020-12-31 | Chambers | Alabama | 1017 | 2341 | 63 |
878256 | 878256 | 2020-12-30 | Chambers | Alabama | 1017 | 2310 | 62 |
875011 | 875011 | 2020-12-29 | Chambers | Alabama | 1017 | 2275 | 61 |
871766 | 871766 | 2020-12-28 | Chambers | Alabama | 1017 | 2229 | 61 |
868521 | 868521 | 2020-12-27 | Chambers | Alabama | 1017 | 2214 | 61 |
865276 | 865276 | 2020-12-26 | Chambers | Alabama | 1017 | 2203 | 61 |
862031 | 862031 | 2020-12-25 | Chambers | Alabama | 1017 | 2200 | 61 |
858786 | 858786 | 2020-12-24 | Chambers | Alabama | 1017 | 2191 | 61 |
855541 | 855541 | 2020-12-23 | Chambers | Alabama | 1017 | 2176 | 61 |
852296 | 852296 | 2020-12-22 | Chambers | Alabama | 1017 | 2161 | 61 |
849051 | 849051 | 2020-12-21 | Chambers | Alabama | 1017 | 2133 | 60 |
845806 | 845806 | 2020-12-20 | Chambers | Alabama | 1017 | 2125 | 60 |
842560 | 842560 | 2020-12-19 | Chambers | Alabama | 1017 | 2116 | 60 |
839315 | 839315 | 2020-12-18 | Chambers | Alabama | 1017 | 2090 | 58 |
836070 | 836070 | 2020-12-17 | Chambers | Alabama | 1017 | 2076 | 58 |
832824 | 832824 | 2020-12-16 | Chambers | Alabama | 1017 | 2064 | 57 |
829577 | 829577 | 2020-12-15 | Chambers | Alabama | 1017 | 2040 | 57 |
826331 | 826331 | 2020-12-14 | Chambers | Alabama | 1017 | 2022 | 57 |
823084 | 823084 | 2020-12-13 | Chambers | Alabama | 1017 | 2013 | 57 |
819838 | 819838 | 2020-12-12 | Chambers | Alabama | 1017 | 1997 | 57 |
816592 | 816592 | 2020-12-11 | Chambers | Alabama | 1017 | 1982 | 55 |
813346 | 813346 | 2020-12-10 | Chambers | Alabama | 1017 | 1977 | 55 |
810102 | 810102 | 2020-12-09 | Chambers | Alabama | 1017 | 1961 | 55 |
806857 | 806857 | 2020-12-08 | Chambers | Alabama | 1017 | 1945 | 54 |
803612 | 803612 | 2020-12-07 | Chambers | Alabama | 1017 | 1915 | 54 |
800367 | 800367 | 2020-12-06 | Chambers | Alabama | 1017 | 1906 | 54 |
797122 | 797122 | 2020-12-05 | Chambers | Alabama | 1017 | 1901 | 54 |
793877 | 793877 | 2020-12-04 | Chambers | Alabama | 1017 | 1891 | 54 |
790632 | 790632 | 2020-12-03 | Chambers | Alabama | 1017 | 1875 | 51 |
787387 | 787387 | 2020-12-02 | Chambers | Alabama | 1017 | 1859 | 50 |
784143 | 784143 | 2020-12-01 | Chambers | Alabama | 1017 | 1827 | 50 |
780898 | 780898 | 2020-11-30 | Chambers | Alabama | 1017 | 1779 | 50 |
777652 | 777652 | 2020-11-29 | Chambers | Alabama | 1017 | 1772 | 50 |
774407 | 774407 | 2020-11-28 | Chambers | Alabama | 1017 | 1768 | 50 |
771162 | 771162 | 2020-11-27 | Chambers | Alabama | 1017 | 1765 | 50 |
767916 | 767916 | 2020-11-26 | Chambers | Alabama | 1017 | 1764 | 50 |
764671 | 764671 | 2020-11-25 | Chambers | Alabama | 1017 | 1737 | 49 |
761426 | 761426 | 2020-11-24 | Chambers | Alabama | 1017 | 1714 | 48 |
758181 | 758181 | 2020-11-23 | Chambers | Alabama | 1017 | 1680 | 48 |
754934 | 754934 | 2020-11-22 | Chambers | Alabama | 1017 | 1675 | 48 |
751688 | 751688 | 2020-11-21 | Chambers | Alabama | 1017 | 1669 | 48 |
748442 | 748442 | 2020-11-20 | Chambers | Alabama | 1017 | 1663 | 48 |
745196 | 745196 | 2020-11-19 | Chambers | Alabama | 1017 | 1641 | 48 |
741949 | 741949 | 2020-11-18 | Chambers | Alabama | 1017 | 1620 | 48 |
738702 | 738702 | 2020-11-17 | Chambers | Alabama | 1017 | 1595 | 48 |
735458 | 735458 | 2020-11-16 | Chambers | Alabama | 1017 | 1572 | 48 |
732212 | 732212 | 2020-11-15 | Chambers | Alabama | 1017 | 1570 | 48 |
728967 | 728967 | 2020-11-14 | Chambers | Alabama | 1017 | 1556 | 48 |
725724 | 725724 | 2020-11-13 | Chambers | Alabama | 1017 | 1545 | 48 |
722481 | 722481 | 2020-11-12 | Chambers | Alabama | 1017 | 1514 | 48 |
719238 | 719238 | 2020-11-11 | Chambers | Alabama | 1017 | 1508 | 48 |
715995 | 715995 | 2020-11-10 | Chambers | Alabama | 1017 | 1507 | 48 |
712751 | 712751 | 2020-11-09 | Chambers | Alabama | 1017 | 1489 | 48 |
709507 | 709507 | 2020-11-08 | Chambers | Alabama | 1017 | 1485 | 48 |
706263 | 706263 | 2020-11-07 | Chambers | Alabama | 1017 | 1483 | 48 |
703020 | 703020 | 2020-11-06 | Chambers | Alabama | 1017 | 1469 | 48 |
699777 | 699777 | 2020-11-05 | Chambers | Alabama | 1017 | 1461 | 48 |
696533 | 696533 | 2020-11-04 | Chambers | Alabama | 1017 | 1449 | 48 |
693291 | 693291 | 2020-11-03 | Chambers | Alabama | 1017 | 1428 | 47 |
690048 | 690048 | 2020-11-02 | Chambers | Alabama | 1017 | 1397 | 47 |
686803 | 686803 | 2020-11-01 | Chambers | Alabama | 1017 | 1392 | 47 |
683559 | 683559 | 2020-10-31 | Chambers | Alabama | 1017 | 1389 | 47 |
680316 | 680316 | 2020-10-30 | Chambers | Alabama | 1017 | 1381 | 47 |
677073 | 677073 | 2020-10-29 | Chambers | Alabama | 1017 | 1380 | 47 |
673830 | 673830 | 2020-10-28 | Chambers | Alabama | 1017 | 1370 | 47 |
670588 | 670588 | 2020-10-27 | Chambers | Alabama | 1017 | 1368 | 47 |
667345 | 667345 | 2020-10-26 | Chambers | Alabama | 1017 | 1352 | 44 |
664100 | 664100 | 2020-10-25 | Chambers | Alabama | 1017 | 1350 | 44 |
660856 | 660856 | 2020-10-24 | Chambers | Alabama | 1017 | 1350 | 44 |
657612 | 657612 | 2020-10-23 | Chambers | Alabama | 1017 | 1343 | 43 |
654367 | 654367 | 2020-10-22 | Chambers | Alabama | 1017 | 1336 | 43 |
651122 | 651122 | 2020-10-21 | Chambers | Alabama | 1017 | 1330 | 43 |
647878 | 647878 | 2020-10-20 | Chambers | Alabama | 1017 | 1301 | 43 |
644633 | 644633 | 2020-10-19 | Chambers | Alabama | 1017 | 1273 | 43 |
641385 | 641385 | 2020-10-18 | Chambers | Alabama | 1017 | 1266 | 43 |
638138 | 638138 | 2020-10-17 | Chambers | Alabama | 1017 | 1266 | 43 |
634893 | 634893 | 2020-10-16 | Chambers | Alabama | 1017 | 1263 | 43 |
631648 | 631648 | 2020-10-15 | Chambers | Alabama | 1017 | 1260 | 43 |
628404 | 628404 | 2020-10-14 | Chambers | Alabama | 1017 | 1256 | 43 |
625161 | 625161 | 2020-10-13 | Chambers | Alabama | 1017 | 1254 | 43 |
621918 | 621918 | 2020-10-12 | Chambers | Alabama | 1017 | 1245 | 43 |
618675 | 618675 | 2020-10-11 | Chambers | Alabama | 1017 | 1242 | 43 |
615433 | 615433 | 2020-10-10 | Chambers | Alabama | 1017 | 1242 | 43 |
612192 | 612192 | 2020-10-09 | Chambers | Alabama | 1017 | 1238 | 43 |
608950 | 608950 | 2020-10-08 | Chambers | Alabama | 1017 | 1222 | 43 |
605707 | 605707 | 2020-10-07 | Chambers | Alabama | 1017 | 1211 | 43 |
602465 | 602465 | 2020-10-06 | Chambers | Alabama | 1017 | 1210 | 42 |
599222 | 599222 | 2020-10-05 | Chambers | Alabama | 1017 | 1208 | 42 |
595979 | 595979 | 2020-10-04 | Chambers | Alabama | 1017 | 1205 | 42 |
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);