ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Franklin" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1073427 | 1073427 | 2021-02-28 | Franklin | Georgia | 13119 | 2565 | 43 |
1070181 | 1070181 | 2021-02-27 | Franklin | Georgia | 13119 | 2562 | 43 |
1066936 | 1066936 | 2021-02-26 | Franklin | Georgia | 13119 | 2560 | 42 |
1063691 | 1063691 | 2021-02-25 | Franklin | Georgia | 13119 | 2556 | 42 |
1060446 | 1060446 | 2021-02-24 | Franklin | Georgia | 13119 | 2553 | 42 |
1057200 | 1057200 | 2021-02-23 | Franklin | Georgia | 13119 | 2540 | 42 |
1053954 | 1053954 | 2021-02-22 | Franklin | Georgia | 13119 | 2525 | 42 |
1050707 | 1050707 | 2021-02-21 | Franklin | Georgia | 13119 | 2518 | 42 |
1047460 | 1047460 | 2021-02-20 | Franklin | Georgia | 13119 | 2515 | 42 |
1044215 | 1044215 | 2021-02-19 | Franklin | Georgia | 13119 | 2511 | 42 |
1040970 | 1040970 | 2021-02-18 | Franklin | Georgia | 13119 | 2506 | 41 |
1037725 | 1037725 | 2021-02-17 | Franklin | Georgia | 13119 | 2502 | 41 |
1034480 | 1034480 | 2021-02-16 | Franklin | Georgia | 13119 | 2499 | 40 |
1031234 | 1031234 | 2021-02-15 | Franklin | Georgia | 13119 | 2484 | 40 |
1027987 | 1027987 | 2021-02-14 | Franklin | Georgia | 13119 | 2482 | 40 |
1024742 | 1024742 | 2021-02-13 | Franklin | Georgia | 13119 | 2480 | 40 |
1021497 | 1021497 | 2021-02-12 | Franklin | Georgia | 13119 | 2477 | 40 |
1018252 | 1018252 | 2021-02-11 | Franklin | Georgia | 13119 | 2465 | 38 |
1015007 | 1015007 | 2021-02-10 | Franklin | Georgia | 13119 | 2456 | 38 |
1011762 | 1011762 | 2021-02-09 | Franklin | Georgia | 13119 | 2447 | 38 |
1008516 | 1008516 | 2021-02-08 | Franklin | Georgia | 13119 | 2435 | 38 |
1005270 | 1005270 | 2021-02-07 | Franklin | Georgia | 13119 | 2429 | 38 |
1002024 | 1002024 | 2021-02-06 | Franklin | Georgia | 13119 | 2424 | 38 |
998778 | 998778 | 2021-02-05 | Franklin | Georgia | 13119 | 2417 | 37 |
995532 | 995532 | 2021-02-04 | Franklin | Georgia | 13119 | 2403 | 36 |
992286 | 992286 | 2021-02-03 | Franklin | Georgia | 13119 | 2396 | 35 |
989040 | 989040 | 2021-02-02 | Franklin | Georgia | 13119 | 2378 | 34 |
985793 | 985793 | 2021-02-01 | Franklin | Georgia | 13119 | 2354 | 34 |
982546 | 982546 | 2021-01-31 | Franklin | Georgia | 13119 | 2350 | 34 |
979300 | 979300 | 2021-01-30 | Franklin | Georgia | 13119 | 2338 | 34 |
976055 | 976055 | 2021-01-29 | Franklin | Georgia | 13119 | 2331 | 34 |
972810 | 972810 | 2021-01-28 | Franklin | Georgia | 13119 | 2321 | 33 |
969565 | 969565 | 2021-01-27 | Franklin | Georgia | 13119 | 2305 | 33 |
966321 | 966321 | 2021-01-26 | Franklin | Georgia | 13119 | 2295 | 33 |
963076 | 963076 | 2021-01-25 | Franklin | Georgia | 13119 | 2281 | 31 |
959831 | 959831 | 2021-01-24 | Franklin | Georgia | 13119 | 2275 | 31 |
956585 | 956585 | 2021-01-23 | Franklin | Georgia | 13119 | 2267 | 31 |
953340 | 953340 | 2021-01-22 | Franklin | Georgia | 13119 | 2242 | 31 |
950095 | 950095 | 2021-01-21 | Franklin | Georgia | 13119 | 2219 | 30 |
946849 | 946849 | 2021-01-20 | Franklin | Georgia | 13119 | 2203 | 30 |
943602 | 943602 | 2021-01-19 | Franklin | Georgia | 13119 | 2186 | 30 |
940357 | 940357 | 2021-01-18 | Franklin | Georgia | 13119 | 2167 | 30 |
937112 | 937112 | 2021-01-17 | Franklin | Georgia | 13119 | 2155 | 30 |
933867 | 933867 | 2021-01-16 | Franklin | Georgia | 13119 | 2148 | 30 |
930622 | 930622 | 2021-01-15 | Franklin | Georgia | 13119 | 2128 | 30 |
927377 | 927377 | 2021-01-14 | Franklin | Georgia | 13119 | 2105 | 30 |
924131 | 924131 | 2021-01-13 | Franklin | Georgia | 13119 | 2086 | 30 |
920886 | 920886 | 2021-01-12 | Franklin | Georgia | 13119 | 2071 | 30 |
917641 | 917641 | 2021-01-11 | Franklin | Georgia | 13119 | 2044 | 29 |
914396 | 914396 | 2021-01-10 | Franklin | Georgia | 13119 | 2023 | 29 |
911151 | 911151 | 2021-01-09 | Franklin | Georgia | 13119 | 2008 | 29 |
907906 | 907906 | 2021-01-08 | Franklin | Georgia | 13119 | 1984 | 28 |
904660 | 904660 | 2021-01-07 | Franklin | Georgia | 13119 | 1944 | 27 |
901415 | 901415 | 2021-01-06 | Franklin | Georgia | 13119 | 1904 | 27 |
898170 | 898170 | 2021-01-05 | Franklin | Georgia | 13119 | 1890 | 26 |
894925 | 894925 | 2021-01-04 | Franklin | Georgia | 13119 | 1873 | 26 |
891678 | 891678 | 2021-01-03 | Franklin | Georgia | 13119 | 1867 | 26 |
888431 | 888431 | 2021-01-02 | Franklin | Georgia | 13119 | 1853 | 26 |
885186 | 885186 | 2021-01-01 | Franklin | Georgia | 13119 | 1840 | 26 |
881941 | 881941 | 2020-12-31 | Franklin | Georgia | 13119 | 1815 | 26 |
878696 | 878696 | 2020-12-30 | Franklin | Georgia | 13119 | 1782 | 26 |
875451 | 875451 | 2020-12-29 | Franklin | Georgia | 13119 | 1768 | 26 |
872206 | 872206 | 2020-12-28 | Franklin | Georgia | 13119 | 1733 | 26 |
868961 | 868961 | 2020-12-27 | Franklin | Georgia | 13119 | 1730 | 26 |
865716 | 865716 | 2020-12-26 | Franklin | Georgia | 13119 | 1720 | 26 |
862471 | 862471 | 2020-12-25 | Franklin | Georgia | 13119 | 1706 | 26 |
859226 | 859226 | 2020-12-24 | Franklin | Georgia | 13119 | 1680 | 26 |
855981 | 855981 | 2020-12-23 | Franklin | Georgia | 13119 | 1638 | 26 |
852736 | 852736 | 2020-12-22 | Franklin | Georgia | 13119 | 1617 | 26 |
849491 | 849491 | 2020-12-21 | Franklin | Georgia | 13119 | 1589 | 25 |
846246 | 846246 | 2020-12-20 | Franklin | Georgia | 13119 | 1576 | 25 |
843000 | 843000 | 2020-12-19 | Franklin | Georgia | 13119 | 1561 | 25 |
839755 | 839755 | 2020-12-18 | Franklin | Georgia | 13119 | 1544 | 25 |
836510 | 836510 | 2020-12-17 | Franklin | Georgia | 13119 | 1518 | 25 |
833264 | 833264 | 2020-12-16 | Franklin | Georgia | 13119 | 1485 | 25 |
830017 | 830017 | 2020-12-15 | Franklin | Georgia | 13119 | 1466 | 25 |
826771 | 826771 | 2020-12-14 | Franklin | Georgia | 13119 | 1455 | 25 |
823524 | 823524 | 2020-12-13 | Franklin | Georgia | 13119 | 1437 | 25 |
820278 | 820278 | 2020-12-12 | Franklin | Georgia | 13119 | 1431 | 25 |
817032 | 817032 | 2020-12-11 | Franklin | Georgia | 13119 | 1416 | 25 |
813786 | 813786 | 2020-12-10 | Franklin | Georgia | 13119 | 1390 | 25 |
810542 | 810542 | 2020-12-09 | Franklin | Georgia | 13119 | 1370 | 24 |
807297 | 807297 | 2020-12-08 | Franklin | Georgia | 13119 | 1353 | 23 |
804052 | 804052 | 2020-12-07 | Franklin | Georgia | 13119 | 1342 | 23 |
800807 | 800807 | 2020-12-06 | Franklin | Georgia | 13119 | 1330 | 23 |
797562 | 797562 | 2020-12-05 | Franklin | Georgia | 13119 | 1328 | 23 |
794317 | 794317 | 2020-12-04 | Franklin | Georgia | 13119 | 1320 | 23 |
791072 | 791072 | 2020-12-03 | Franklin | Georgia | 13119 | 1295 | 23 |
787827 | 787827 | 2020-12-02 | Franklin | Georgia | 13119 | 1285 | 23 |
784583 | 784583 | 2020-12-01 | Franklin | Georgia | 13119 | 1263 | 23 |
781338 | 781338 | 2020-11-30 | Franklin | Georgia | 13119 | 1252 | 23 |
778092 | 778092 | 2020-11-29 | Franklin | Georgia | 13119 | 1248 | 23 |
774847 | 774847 | 2020-11-28 | Franklin | Georgia | 13119 | 1244 | 23 |
771602 | 771602 | 2020-11-27 | Franklin | Georgia | 13119 | 1235 | 23 |
768357 | 768357 | 2020-11-26 | Franklin | Georgia | 13119 | 1223 | 23 |
765111 | 765111 | 2020-11-25 | Franklin | Georgia | 13119 | 1204 | 22 |
761866 | 761866 | 2020-11-24 | Franklin | Georgia | 13119 | 1194 | 22 |
758621 | 758621 | 2020-11-23 | Franklin | Georgia | 13119 | 1182 | 22 |
755374 | 755374 | 2020-11-22 | Franklin | Georgia | 13119 | 1176 | 22 |
752128 | 752128 | 2020-11-21 | Franklin | Georgia | 13119 | 1172 | 21 |
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);