ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Jefferson" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1070203 | 1070203 | 2021-02-27 | Jefferson | Georgia | 13163 | 1864 | 58 |
1066958 | 1066958 | 2021-02-26 | Jefferson | Georgia | 13163 | 1862 | 58 |
1063713 | 1063713 | 2021-02-25 | Jefferson | Georgia | 13163 | 1859 | 58 |
1060468 | 1060468 | 2021-02-24 | Jefferson | Georgia | 13163 | 1856 | 56 |
1057222 | 1057222 | 2021-02-23 | Jefferson | Georgia | 13163 | 1854 | 56 |
1053976 | 1053976 | 2021-02-22 | Jefferson | Georgia | 13163 | 1845 | 54 |
1050729 | 1050729 | 2021-02-21 | Jefferson | Georgia | 13163 | 1841 | 54 |
1047482 | 1047482 | 2021-02-20 | Jefferson | Georgia | 13163 | 1838 | 54 |
1044237 | 1044237 | 2021-02-19 | Jefferson | Georgia | 13163 | 1835 | 54 |
1040992 | 1040992 | 2021-02-18 | Jefferson | Georgia | 13163 | 1828 | 54 |
1037747 | 1037747 | 2021-02-17 | Jefferson | Georgia | 13163 | 1821 | 54 |
1034502 | 1034502 | 2021-02-16 | Jefferson | Georgia | 13163 | 1818 | 54 |
1031256 | 1031256 | 2021-02-15 | Jefferson | Georgia | 13163 | 1816 | 54 |
1028009 | 1028009 | 2021-02-14 | Jefferson | Georgia | 13163 | 1814 | 54 |
1024764 | 1024764 | 2021-02-13 | Jefferson | Georgia | 13163 | 1811 | 54 |
1021519 | 1021519 | 2021-02-12 | Jefferson | Georgia | 13163 | 1800 | 54 |
1018274 | 1018274 | 2021-02-11 | Jefferson | Georgia | 13163 | 1795 | 54 |
1015029 | 1015029 | 2021-02-10 | Jefferson | Georgia | 13163 | 1788 | 54 |
1011784 | 1011784 | 2021-02-09 | Jefferson | Georgia | 13163 | 1783 | 54 |
1008538 | 1008538 | 2021-02-08 | Jefferson | Georgia | 13163 | 1769 | 54 |
1005292 | 1005292 | 2021-02-07 | Jefferson | Georgia | 13163 | 1762 | 54 |
1002046 | 1002046 | 2021-02-06 | Jefferson | Georgia | 13163 | 1758 | 54 |
998800 | 998800 | 2021-02-05 | Jefferson | Georgia | 13163 | 1746 | 53 |
995554 | 995554 | 2021-02-04 | Jefferson | Georgia | 13163 | 1733 | 52 |
992308 | 992308 | 2021-02-03 | Jefferson | Georgia | 13163 | 1721 | 52 |
989062 | 989062 | 2021-02-02 | Jefferson | Georgia | 13163 | 1715 | 50 |
985815 | 985815 | 2021-02-01 | Jefferson | Georgia | 13163 | 1710 | 49 |
982568 | 982568 | 2021-01-31 | Jefferson | Georgia | 13163 | 1707 | 49 |
979322 | 979322 | 2021-01-30 | Jefferson | Georgia | 13163 | 1705 | 49 |
976077 | 976077 | 2021-01-29 | Jefferson | Georgia | 13163 | 1697 | 48 |
972832 | 972832 | 2021-01-28 | Jefferson | Georgia | 13163 | 1688 | 48 |
969587 | 969587 | 2021-01-27 | Jefferson | Georgia | 13163 | 1675 | 48 |
966343 | 966343 | 2021-01-26 | Jefferson | Georgia | 13163 | 1672 | 48 |
963098 | 963098 | 2021-01-25 | Jefferson | Georgia | 13163 | 1671 | 48 |
959853 | 959853 | 2021-01-24 | Jefferson | Georgia | 13163 | 1664 | 48 |
956607 | 956607 | 2021-01-23 | Jefferson | Georgia | 13163 | 1658 | 48 |
953362 | 953362 | 2021-01-22 | Jefferson | Georgia | 13163 | 1652 | 47 |
950117 | 950117 | 2021-01-21 | Jefferson | Georgia | 13163 | 1639 | 47 |
946871 | 946871 | 2021-01-20 | Jefferson | Georgia | 13163 | 1604 | 47 |
943624 | 943624 | 2021-01-19 | Jefferson | Georgia | 13163 | 1595 | 46 |
940379 | 940379 | 2021-01-18 | Jefferson | Georgia | 13163 | 1586 | 44 |
937134 | 937134 | 2021-01-17 | Jefferson | Georgia | 13163 | 1570 | 44 |
933889 | 933889 | 2021-01-16 | Jefferson | Georgia | 13163 | 1554 | 44 |
930644 | 930644 | 2021-01-15 | Jefferson | Georgia | 13163 | 1535 | 41 |
927399 | 927399 | 2021-01-14 | Jefferson | Georgia | 13163 | 1521 | 41 |
924153 | 924153 | 2021-01-13 | Jefferson | Georgia | 13163 | 1510 | 41 |
920908 | 920908 | 2021-01-12 | Jefferson | Georgia | 13163 | 1493 | 41 |
917663 | 917663 | 2021-01-11 | Jefferson | Georgia | 13163 | 1480 | 41 |
914418 | 914418 | 2021-01-10 | Jefferson | Georgia | 13163 | 1449 | 41 |
911173 | 911173 | 2021-01-09 | Jefferson | Georgia | 13163 | 1432 | 41 |
907928 | 907928 | 2021-01-08 | Jefferson | Georgia | 13163 | 1422 | 41 |
904682 | 904682 | 2021-01-07 | Jefferson | Georgia | 13163 | 1406 | 40 |
901437 | 901437 | 2021-01-06 | Jefferson | Georgia | 13163 | 1395 | 40 |
898192 | 898192 | 2021-01-05 | Jefferson | Georgia | 13163 | 1379 | 40 |
894947 | 894947 | 2021-01-04 | Jefferson | Georgia | 13163 | 1359 | 40 |
891700 | 891700 | 2021-01-03 | Jefferson | Georgia | 13163 | 1352 | 40 |
888453 | 888453 | 2021-01-02 | Jefferson | Georgia | 13163 | 1337 | 40 |
885208 | 885208 | 2021-01-01 | Jefferson | Georgia | 13163 | 1323 | 40 |
881963 | 881963 | 2020-12-31 | Jefferson | Georgia | 13163 | 1305 | 40 |
878718 | 878718 | 2020-12-30 | Jefferson | Georgia | 13163 | 1291 | 40 |
875473 | 875473 | 2020-12-29 | Jefferson | Georgia | 13163 | 1276 | 40 |
872228 | 872228 | 2020-12-28 | Jefferson | Georgia | 13163 | 1268 | 41 |
868983 | 868983 | 2020-12-27 | Jefferson | Georgia | 13163 | 1258 | 41 |
865738 | 865738 | 2020-12-26 | Jefferson | Georgia | 13163 | 1254 | 41 |
862493 | 862493 | 2020-12-25 | Jefferson | Georgia | 13163 | 1251 | 41 |
859248 | 859248 | 2020-12-24 | Jefferson | Georgia | 13163 | 1244 | 41 |
856003 | 856003 | 2020-12-23 | Jefferson | Georgia | 13163 | 1219 | 40 |
852758 | 852758 | 2020-12-22 | Jefferson | Georgia | 13163 | 1210 | 40 |
849513 | 849513 | 2020-12-21 | Jefferson | Georgia | 13163 | 1200 | 40 |
846268 | 846268 | 2020-12-20 | Jefferson | Georgia | 13163 | 1193 | 40 |
843022 | 843022 | 2020-12-19 | Jefferson | Georgia | 13163 | 1190 | 40 |
839777 | 839777 | 2020-12-18 | Jefferson | Georgia | 13163 | 1176 | 40 |
836532 | 836532 | 2020-12-17 | Jefferson | Georgia | 13163 | 1169 | 40 |
833286 | 833286 | 2020-12-16 | Jefferson | Georgia | 13163 | 1152 | 40 |
830039 | 830039 | 2020-12-15 | Jefferson | Georgia | 13163 | 1141 | 40 |
826793 | 826793 | 2020-12-14 | Jefferson | Georgia | 13163 | 1120 | 40 |
823546 | 823546 | 2020-12-13 | Jefferson | Georgia | 13163 | 1114 | 40 |
820300 | 820300 | 2020-12-12 | Jefferson | Georgia | 13163 | 1108 | 40 |
817054 | 817054 | 2020-12-11 | Jefferson | Georgia | 13163 | 1099 | 40 |
813808 | 813808 | 2020-12-10 | Jefferson | Georgia | 13163 | 1083 | 40 |
810564 | 810564 | 2020-12-09 | Jefferson | Georgia | 13163 | 1069 | 40 |
807319 | 807319 | 2020-12-08 | Jefferson | Georgia | 13163 | 1057 | 40 |
804074 | 804074 | 2020-12-07 | Jefferson | Georgia | 13163 | 1054 | 40 |
800829 | 800829 | 2020-12-06 | Jefferson | Georgia | 13163 | 1050 | 40 |
797584 | 797584 | 2020-12-05 | Jefferson | Georgia | 13163 | 1048 | 40 |
794339 | 794339 | 2020-12-04 | Jefferson | Georgia | 13163 | 1034 | 40 |
791094 | 791094 | 2020-12-03 | Jefferson | Georgia | 13163 | 1028 | 40 |
787849 | 787849 | 2020-12-02 | Jefferson | Georgia | 13163 | 1016 | 40 |
784605 | 784605 | 2020-12-01 | Jefferson | Georgia | 13163 | 1006 | 39 |
781360 | 781360 | 2020-11-30 | Jefferson | Georgia | 13163 | 1002 | 39 |
778114 | 778114 | 2020-11-29 | Jefferson | Georgia | 13163 | 1001 | 39 |
774869 | 774869 | 2020-11-28 | Jefferson | Georgia | 13163 | 998 | 40 |
771624 | 771624 | 2020-11-27 | Jefferson | Georgia | 13163 | 994 | 39 |
768379 | 768379 | 2020-11-26 | Jefferson | Georgia | 13163 | 990 | 39 |
765133 | 765133 | 2020-11-25 | Jefferson | Georgia | 13163 | 989 | 39 |
761888 | 761888 | 2020-11-24 | Jefferson | Georgia | 13163 | 986 | 39 |
758643 | 758643 | 2020-11-23 | Jefferson | Georgia | 13163 | 987 | 39 |
755396 | 755396 | 2020-11-22 | Jefferson | Georgia | 13163 | 984 | 39 |
752150 | 752150 | 2020-11-21 | Jefferson | Georgia | 13163 | 980 | 39 |
748904 | 748904 | 2020-11-20 | Jefferson | Georgia | 13163 | 977 | 40 |
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);