ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Tallapoosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917254 | 917254 | 2021-01-11 | Tallapoosa | Alabama | 1123 | 2554 | 107 |
914009 | 914009 | 2021-01-10 | Tallapoosa | Alabama | 1123 | 2552 | 107 |
910764 | 910764 | 2021-01-09 | Tallapoosa | Alabama | 1123 | 2540 | 107 |
907519 | 907519 | 2021-01-08 | Tallapoosa | Alabama | 1123 | 2531 | 107 |
904273 | 904273 | 2021-01-07 | Tallapoosa | Alabama | 1123 | 2504 | 100 |
901028 | 901028 | 2021-01-06 | Tallapoosa | Alabama | 1123 | 2487 | 99 |
897783 | 897783 | 2021-01-05 | Tallapoosa | Alabama | 1123 | 2464 | 98 |
894537 | 894537 | 2021-01-04 | Tallapoosa | Alabama | 1123 | 2418 | 98 |
891291 | 891291 | 2021-01-03 | Tallapoosa | Alabama | 1123 | 2411 | 98 |
888044 | 888044 | 2021-01-02 | Tallapoosa | Alabama | 1123 | 2395 | 98 |
884799 | 884799 | 2021-01-01 | Tallapoosa | Alabama | 1123 | 2383 | 98 |
881554 | 881554 | 2020-12-31 | Tallapoosa | Alabama | 1123 | 2368 | 98 |
878309 | 878309 | 2020-12-30 | Tallapoosa | Alabama | 1123 | 2354 | 98 |
875064 | 875064 | 2020-12-29 | Tallapoosa | Alabama | 1123 | 2329 | 98 |
871819 | 871819 | 2020-12-28 | Tallapoosa | Alabama | 1123 | 2304 | 98 |
868574 | 868574 | 2020-12-27 | Tallapoosa | Alabama | 1123 | 2293 | 98 |
865329 | 865329 | 2020-12-26 | Tallapoosa | Alabama | 1123 | 2293 | 98 |
862084 | 862084 | 2020-12-25 | Tallapoosa | Alabama | 1123 | 2283 | 98 |
858839 | 858839 | 2020-12-24 | Tallapoosa | Alabama | 1123 | 2250 | 98 |
855594 | 855594 | 2020-12-23 | Tallapoosa | Alabama | 1123 | 2231 | 97 |
852349 | 852349 | 2020-12-22 | Tallapoosa | Alabama | 1123 | 2212 | 96 |
849104 | 849104 | 2020-12-21 | Tallapoosa | Alabama | 1123 | 2188 | 96 |
845859 | 845859 | 2020-12-20 | Tallapoosa | Alabama | 1123 | 2167 | 96 |
842613 | 842613 | 2020-12-19 | Tallapoosa | Alabama | 1123 | 2163 | 96 |
839368 | 839368 | 2020-12-18 | Tallapoosa | Alabama | 1123 | 2141 | 96 |
836123 | 836123 | 2020-12-17 | Tallapoosa | Alabama | 1123 | 2131 | 96 |
832877 | 832877 | 2020-12-16 | Tallapoosa | Alabama | 1123 | 2106 | 95 |
829630 | 829630 | 2020-12-15 | Tallapoosa | Alabama | 1123 | 2085 | 93 |
826384 | 826384 | 2020-12-14 | Tallapoosa | Alabama | 1123 | 2061 | 93 |
823137 | 823137 | 2020-12-13 | Tallapoosa | Alabama | 1123 | 2055 | 93 |
819891 | 819891 | 2020-12-12 | Tallapoosa | Alabama | 1123 | 2046 | 93 |
816645 | 816645 | 2020-12-11 | Tallapoosa | Alabama | 1123 | 2036 | 93 |
813399 | 813399 | 2020-12-10 | Tallapoosa | Alabama | 1123 | 2018 | 92 |
810155 | 810155 | 2020-12-09 | Tallapoosa | Alabama | 1123 | 2000 | 92 |
806910 | 806910 | 2020-12-08 | Tallapoosa | Alabama | 1123 | 1983 | 92 |
803665 | 803665 | 2020-12-07 | Tallapoosa | Alabama | 1123 | 1950 | 92 |
800420 | 800420 | 2020-12-06 | Tallapoosa | Alabama | 1123 | 1934 | 92 |
797175 | 797175 | 2020-12-05 | Tallapoosa | Alabama | 1123 | 1928 | 92 |
793930 | 793930 | 2020-12-04 | Tallapoosa | Alabama | 1123 | 1926 | 92 |
790685 | 790685 | 2020-12-03 | Tallapoosa | Alabama | 1123 | 1902 | 91 |
787440 | 787440 | 2020-12-02 | Tallapoosa | Alabama | 1123 | 1891 | 91 |
784196 | 784196 | 2020-12-01 | Tallapoosa | Alabama | 1123 | 1872 | 91 |
780951 | 780951 | 2020-11-30 | Tallapoosa | Alabama | 1123 | 1843 | 91 |
777705 | 777705 | 2020-11-29 | Tallapoosa | Alabama | 1123 | 1770 | 91 |
774460 | 774460 | 2020-11-28 | Tallapoosa | Alabama | 1123 | 1763 | 91 |
771215 | 771215 | 2020-11-27 | Tallapoosa | Alabama | 1123 | 1757 | 91 |
767969 | 767969 | 2020-11-26 | Tallapoosa | Alabama | 1123 | 1754 | 91 |
764724 | 764724 | 2020-11-25 | Tallapoosa | Alabama | 1123 | 1733 | 91 |
761479 | 761479 | 2020-11-24 | Tallapoosa | Alabama | 1123 | 1717 | 90 |
758234 | 758234 | 2020-11-23 | Tallapoosa | Alabama | 1123 | 1692 | 90 |
754987 | 754987 | 2020-11-22 | Tallapoosa | Alabama | 1123 | 1685 | 90 |
751741 | 751741 | 2020-11-21 | Tallapoosa | Alabama | 1123 | 1681 | 90 |
748495 | 748495 | 2020-11-20 | Tallapoosa | Alabama | 1123 | 1668 | 89 |
745249 | 745249 | 2020-11-19 | Tallapoosa | Alabama | 1123 | 1665 | 89 |
742002 | 742002 | 2020-11-18 | Tallapoosa | Alabama | 1123 | 1642 | 89 |
738755 | 738755 | 2020-11-17 | Tallapoosa | Alabama | 1123 | 1614 | 88 |
735511 | 735511 | 2020-11-16 | Tallapoosa | Alabama | 1123 | 1611 | 88 |
732265 | 732265 | 2020-11-15 | Tallapoosa | Alabama | 1123 | 1604 | 88 |
729020 | 729020 | 2020-11-14 | Tallapoosa | Alabama | 1123 | 1592 | 88 |
725777 | 725777 | 2020-11-13 | Tallapoosa | Alabama | 1123 | 1564 | 88 |
722534 | 722534 | 2020-11-12 | Tallapoosa | Alabama | 1123 | 1542 | 87 |
719291 | 719291 | 2020-11-11 | Tallapoosa | Alabama | 1123 | 1517 | 87 |
716048 | 716048 | 2020-11-10 | Tallapoosa | Alabama | 1123 | 1506 | 87 |
712804 | 712804 | 2020-11-09 | Tallapoosa | Alabama | 1123 | 1486 | 87 |
709560 | 709560 | 2020-11-08 | Tallapoosa | Alabama | 1123 | 1476 | 87 |
706316 | 706316 | 2020-11-07 | Tallapoosa | Alabama | 1123 | 1467 | 87 |
703073 | 703073 | 2020-11-06 | Tallapoosa | Alabama | 1123 | 1454 | 87 |
699830 | 699830 | 2020-11-05 | Tallapoosa | Alabama | 1123 | 1443 | 87 |
696586 | 696586 | 2020-11-04 | Tallapoosa | Alabama | 1123 | 1430 | 87 |
693344 | 693344 | 2020-11-03 | Tallapoosa | Alabama | 1123 | 1419 | 87 |
690101 | 690101 | 2020-11-02 | Tallapoosa | Alabama | 1123 | 1409 | 87 |
686856 | 686856 | 2020-11-01 | Tallapoosa | Alabama | 1123 | 1403 | 87 |
683612 | 683612 | 2020-10-31 | Tallapoosa | Alabama | 1123 | 1398 | 87 |
680369 | 680369 | 2020-10-30 | Tallapoosa | Alabama | 1123 | 1385 | 87 |
677126 | 677126 | 2020-10-29 | Tallapoosa | Alabama | 1123 | 1372 | 87 |
673883 | 673883 | 2020-10-28 | Tallapoosa | Alabama | 1123 | 1353 | 87 |
670641 | 670641 | 2020-10-27 | Tallapoosa | Alabama | 1123 | 1339 | 87 |
667398 | 667398 | 2020-10-26 | Tallapoosa | Alabama | 1123 | 1330 | 87 |
664153 | 664153 | 2020-10-25 | Tallapoosa | Alabama | 1123 | 1329 | 87 |
660909 | 660909 | 2020-10-24 | Tallapoosa | Alabama | 1123 | 1317 | 87 |
657665 | 657665 | 2020-10-23 | Tallapoosa | Alabama | 1123 | 1313 | 87 |
654420 | 654420 | 2020-10-22 | Tallapoosa | Alabama | 1123 | 1305 | 87 |
651175 | 651175 | 2020-10-21 | Tallapoosa | Alabama | 1123 | 1295 | 87 |
647931 | 647931 | 2020-10-20 | Tallapoosa | Alabama | 1123 | 1286 | 86 |
644686 | 644686 | 2020-10-19 | Tallapoosa | Alabama | 1123 | 1272 | 86 |
641438 | 641438 | 2020-10-18 | Tallapoosa | Alabama | 1123 | 1269 | 86 |
638191 | 638191 | 2020-10-17 | Tallapoosa | Alabama | 1123 | 1267 | 86 |
634946 | 634946 | 2020-10-16 | Tallapoosa | Alabama | 1123 | 1249 | 86 |
631701 | 631701 | 2020-10-15 | Tallapoosa | Alabama | 1123 | 1245 | 85 |
628457 | 628457 | 2020-10-14 | Tallapoosa | Alabama | 1123 | 1236 | 85 |
625214 | 625214 | 2020-10-13 | Tallapoosa | Alabama | 1123 | 1233 | 85 |
621971 | 621971 | 2020-10-12 | Tallapoosa | Alabama | 1123 | 1222 | 85 |
618728 | 618728 | 2020-10-11 | Tallapoosa | Alabama | 1123 | 1220 | 85 |
615486 | 615486 | 2020-10-10 | Tallapoosa | Alabama | 1123 | 1220 | 85 |
612245 | 612245 | 2020-10-09 | Tallapoosa | Alabama | 1123 | 1213 | 85 |
609003 | 609003 | 2020-10-08 | Tallapoosa | Alabama | 1123 | 1211 | 85 |
605760 | 605760 | 2020-10-07 | Tallapoosa | Alabama | 1123 | 1209 | 85 |
602518 | 602518 | 2020-10-06 | Tallapoosa | Alabama | 1123 | 1201 | 85 |
599275 | 599275 | 2020-10-05 | Tallapoosa | Alabama | 1123 | 1197 | 85 |
596032 | 596032 | 2020-10-04 | Tallapoosa | Alabama | 1123 | 1195 | 85 |
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);