ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Lumpkin" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1073461 | 1073461 | 2021-02-28 | Lumpkin | Georgia | 13187 | 2793 | 60 |
1070215 | 1070215 | 2021-02-27 | Lumpkin | Georgia | 13187 | 2792 | 60 |
1066970 | 1066970 | 2021-02-26 | Lumpkin | Georgia | 13187 | 2790 | 60 |
1063725 | 1063725 | 2021-02-25 | Lumpkin | Georgia | 13187 | 2784 | 59 |
1060480 | 1060480 | 2021-02-24 | Lumpkin | Georgia | 13187 | 2779 | 59 |
1057234 | 1057234 | 2021-02-23 | Lumpkin | Georgia | 13187 | 2772 | 57 |
1053988 | 1053988 | 2021-02-22 | Lumpkin | Georgia | 13187 | 2763 | 56 |
1050741 | 1050741 | 2021-02-21 | Lumpkin | Georgia | 13187 | 2761 | 56 |
1047494 | 1047494 | 2021-02-20 | Lumpkin | Georgia | 13187 | 2760 | 56 |
1044249 | 1044249 | 2021-02-19 | Lumpkin | Georgia | 13187 | 2749 | 55 |
1041004 | 1041004 | 2021-02-18 | Lumpkin | Georgia | 13187 | 2748 | 54 |
1037759 | 1037759 | 2021-02-17 | Lumpkin | Georgia | 13187 | 2744 | 54 |
1034514 | 1034514 | 2021-02-16 | Lumpkin | Georgia | 13187 | 2739 | 54 |
1031268 | 1031268 | 2021-02-15 | Lumpkin | Georgia | 13187 | 2730 | 54 |
1028021 | 1028021 | 2021-02-14 | Lumpkin | Georgia | 13187 | 2731 | 53 |
1024776 | 1024776 | 2021-02-13 | Lumpkin | Georgia | 13187 | 2723 | 52 |
1021531 | 1021531 | 2021-02-12 | Lumpkin | Georgia | 13187 | 2717 | 52 |
1018286 | 1018286 | 2021-02-11 | Lumpkin | Georgia | 13187 | 2711 | 51 |
1015041 | 1015041 | 2021-02-10 | Lumpkin | Georgia | 13187 | 2702 | 51 |
1011796 | 1011796 | 2021-02-09 | Lumpkin | Georgia | 13187 | 2700 | 51 |
1008550 | 1008550 | 2021-02-08 | Lumpkin | Georgia | 13187 | 2690 | 50 |
1005304 | 1005304 | 2021-02-07 | Lumpkin | Georgia | 13187 | 2682 | 50 |
1002058 | 1002058 | 2021-02-06 | Lumpkin | Georgia | 13187 | 2679 | 50 |
998812 | 998812 | 2021-02-05 | Lumpkin | Georgia | 13187 | 2669 | 49 |
995566 | 995566 | 2021-02-04 | Lumpkin | Georgia | 13187 | 2661 | 49 |
992320 | 992320 | 2021-02-03 | Lumpkin | Georgia | 13187 | 2650 | 47 |
989074 | 989074 | 2021-02-02 | Lumpkin | Georgia | 13187 | 2636 | 44 |
985827 | 985827 | 2021-02-01 | Lumpkin | Georgia | 13187 | 2619 | 40 |
982580 | 982580 | 2021-01-31 | Lumpkin | Georgia | 13187 | 2616 | 40 |
979334 | 979334 | 2021-01-30 | Lumpkin | Georgia | 13187 | 2614 | 40 |
976089 | 976089 | 2021-01-29 | Lumpkin | Georgia | 13187 | 2605 | 39 |
972844 | 972844 | 2021-01-28 | Lumpkin | Georgia | 13187 | 2597 | 38 |
969599 | 969599 | 2021-01-27 | Lumpkin | Georgia | 13187 | 2585 | 37 |
966355 | 966355 | 2021-01-26 | Lumpkin | Georgia | 13187 | 2571 | 37 |
963110 | 963110 | 2021-01-25 | Lumpkin | Georgia | 13187 | 2549 | 37 |
959865 | 959865 | 2021-01-24 | Lumpkin | Georgia | 13187 | 2543 | 37 |
956619 | 956619 | 2021-01-23 | Lumpkin | Georgia | 13187 | 2535 | 37 |
953374 | 953374 | 2021-01-22 | Lumpkin | Georgia | 13187 | 2513 | 37 |
950129 | 950129 | 2021-01-21 | Lumpkin | Georgia | 13187 | 2492 | 36 |
946883 | 946883 | 2021-01-20 | Lumpkin | Georgia | 13187 | 2468 | 36 |
943636 | 943636 | 2021-01-19 | Lumpkin | Georgia | 13187 | 2435 | 33 |
940391 | 940391 | 2021-01-18 | Lumpkin | Georgia | 13187 | 2399 | 32 |
937146 | 937146 | 2021-01-17 | Lumpkin | Georgia | 13187 | 2395 | 32 |
933901 | 933901 | 2021-01-16 | Lumpkin | Georgia | 13187 | 2386 | 32 |
930656 | 930656 | 2021-01-15 | Lumpkin | Georgia | 13187 | 2361 | 31 |
927411 | 927411 | 2021-01-14 | Lumpkin | Georgia | 13187 | 2319 | 28 |
924165 | 924165 | 2021-01-13 | Lumpkin | Georgia | 13187 | 2286 | 24 |
920920 | 920920 | 2021-01-12 | Lumpkin | Georgia | 13187 | 2247 | 25 |
917675 | 917675 | 2021-01-11 | Lumpkin | Georgia | 13187 | 2203 | 24 |
914430 | 914430 | 2021-01-10 | Lumpkin | Georgia | 13187 | 2182 | 24 |
911185 | 911185 | 2021-01-09 | Lumpkin | Georgia | 13187 | 2175 | 24 |
907940 | 907940 | 2021-01-08 | Lumpkin | Georgia | 13187 | 2147 | 24 |
904694 | 904694 | 2021-01-07 | Lumpkin | Georgia | 13187 | 2097 | 24 |
901449 | 901449 | 2021-01-06 | Lumpkin | Georgia | 13187 | 2077 | 24 |
898204 | 898204 | 2021-01-05 | Lumpkin | Georgia | 13187 | 2044 | 23 |
894959 | 894959 | 2021-01-04 | Lumpkin | Georgia | 13187 | 2009 | 23 |
891712 | 891712 | 2021-01-03 | Lumpkin | Georgia | 13187 | 2003 | 23 |
888465 | 888465 | 2021-01-02 | Lumpkin | Georgia | 13187 | 1992 | 23 |
885220 | 885220 | 2021-01-01 | Lumpkin | Georgia | 13187 | 1984 | 23 |
881975 | 881975 | 2020-12-31 | Lumpkin | Georgia | 13187 | 1944 | 23 |
878730 | 878730 | 2020-12-30 | Lumpkin | Georgia | 13187 | 1898 | 23 |
875485 | 875485 | 2020-12-29 | Lumpkin | Georgia | 13187 | 1849 | 22 |
872240 | 872240 | 2020-12-28 | Lumpkin | Georgia | 13187 | 1831 | 22 |
868995 | 868995 | 2020-12-27 | Lumpkin | Georgia | 13187 | 1829 | 21 |
865750 | 865750 | 2020-12-26 | Lumpkin | Georgia | 13187 | 1823 | 21 |
862505 | 862505 | 2020-12-25 | Lumpkin | Georgia | 13187 | 1812 | 21 |
859260 | 859260 | 2020-12-24 | Lumpkin | Georgia | 13187 | 1795 | 21 |
856015 | 856015 | 2020-12-23 | Lumpkin | Georgia | 13187 | 1748 | 21 |
852770 | 852770 | 2020-12-22 | Lumpkin | Georgia | 13187 | 1718 | 21 |
849525 | 849525 | 2020-12-21 | Lumpkin | Georgia | 13187 | 1676 | 20 |
846280 | 846280 | 2020-12-20 | Lumpkin | Georgia | 13187 | 1669 | 20 |
843034 | 843034 | 2020-12-19 | Lumpkin | Georgia | 13187 | 1664 | 20 |
839789 | 839789 | 2020-12-18 | Lumpkin | Georgia | 13187 | 1640 | 20 |
836544 | 836544 | 2020-12-17 | Lumpkin | Georgia | 13187 | 1620 | 20 |
833298 | 833298 | 2020-12-16 | Lumpkin | Georgia | 13187 | 1573 | 20 |
830051 | 830051 | 2020-12-15 | Lumpkin | Georgia | 13187 | 1547 | 20 |
826805 | 826805 | 2020-12-14 | Lumpkin | Georgia | 13187 | 1531 | 20 |
823558 | 823558 | 2020-12-13 | Lumpkin | Georgia | 13187 | 1527 | 20 |
820312 | 820312 | 2020-12-12 | Lumpkin | Georgia | 13187 | 1526 | 20 |
817066 | 817066 | 2020-12-11 | Lumpkin | Georgia | 13187 | 1488 | 20 |
813820 | 813820 | 2020-12-10 | Lumpkin | Georgia | 13187 | 1454 | 20 |
810576 | 810576 | 2020-12-09 | Lumpkin | Georgia | 13187 | 1416 | 20 |
807331 | 807331 | 2020-12-08 | Lumpkin | Georgia | 13187 | 1393 | 20 |
804086 | 804086 | 2020-12-07 | Lumpkin | Georgia | 13187 | 1385 | 20 |
800841 | 800841 | 2020-12-06 | Lumpkin | Georgia | 13187 | 1376 | 20 |
797596 | 797596 | 2020-12-05 | Lumpkin | Georgia | 13187 | 1376 | 20 |
794351 | 794351 | 2020-12-04 | Lumpkin | Georgia | 13187 | 1362 | 20 |
791106 | 791106 | 2020-12-03 | Lumpkin | Georgia | 13187 | 1346 | 20 |
787861 | 787861 | 2020-12-02 | Lumpkin | Georgia | 13187 | 1324 | 20 |
784617 | 784617 | 2020-12-01 | Lumpkin | Georgia | 13187 | 1313 | 20 |
781372 | 781372 | 2020-11-30 | Lumpkin | Georgia | 13187 | 1296 | 20 |
778126 | 778126 | 2020-11-29 | Lumpkin | Georgia | 13187 | 1294 | 20 |
774881 | 774881 | 2020-11-28 | Lumpkin | Georgia | 13187 | 1289 | 20 |
771636 | 771636 | 2020-11-27 | Lumpkin | Georgia | 13187 | 1285 | 20 |
768391 | 768391 | 2020-11-26 | Lumpkin | Georgia | 13187 | 1282 | 20 |
765145 | 765145 | 2020-11-25 | Lumpkin | Georgia | 13187 | 1272 | 20 |
761900 | 761900 | 2020-11-24 | Lumpkin | Georgia | 13187 | 1262 | 20 |
758655 | 758655 | 2020-11-23 | Lumpkin | Georgia | 13187 | 1245 | 20 |
755408 | 755408 | 2020-11-22 | Lumpkin | Georgia | 13187 | 1244 | 20 |
752162 | 752162 | 2020-11-21 | Lumpkin | Georgia | 13187 | 1243 | 20 |
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);