ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clarke" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053924 | 1053924 | 2021-02-22 | Clarke | Georgia | 13059 | 13933 | 112 |
1050677 | 1050677 | 2021-02-21 | Clarke | Georgia | 13059 | 13924 | 110 |
1047430 | 1047430 | 2021-02-20 | Clarke | Georgia | 13059 | 13910 | 110 |
1044185 | 1044185 | 2021-02-19 | Clarke | Georgia | 13059 | 13888 | 109 |
1040940 | 1040940 | 2021-02-18 | Clarke | Georgia | 13059 | 13853 | 109 |
1037695 | 1037695 | 2021-02-17 | Clarke | Georgia | 13059 | 13819 | 109 |
1034450 | 1034450 | 2021-02-16 | Clarke | Georgia | 13059 | 13783 | 109 |
1031204 | 1031204 | 2021-02-15 | Clarke | Georgia | 13059 | 13750 | 106 |
1027957 | 1027957 | 2021-02-14 | Clarke | Georgia | 13059 | 13718 | 106 |
1024712 | 1024712 | 2021-02-13 | Clarke | Georgia | 13059 | 13688 | 106 |
1021467 | 1021467 | 2021-02-12 | Clarke | Georgia | 13059 | 13646 | 106 |
1018222 | 1018222 | 2021-02-11 | Clarke | Georgia | 13059 | 13602 | 105 |
1014977 | 1014977 | 2021-02-10 | Clarke | Georgia | 13059 | 13567 | 104 |
1011732 | 1011732 | 2021-02-09 | Clarke | Georgia | 13059 | 13509 | 104 |
1008486 | 1008486 | 2021-02-08 | Clarke | Georgia | 13059 | 13469 | 102 |
1005240 | 1005240 | 2021-02-07 | Clarke | Georgia | 13059 | 13444 | 101 |
1001994 | 1001994 | 2021-02-06 | Clarke | Georgia | 13059 | 13410 | 101 |
998748 | 998748 | 2021-02-05 | Clarke | Georgia | 13059 | 13347 | 99 |
995502 | 995502 | 2021-02-04 | Clarke | Georgia | 13059 | 13289 | 98 |
992256 | 992256 | 2021-02-03 | Clarke | Georgia | 13059 | 13218 | 96 |
989010 | 989010 | 2021-02-02 | Clarke | Georgia | 13059 | 13154 | 95 |
985763 | 985763 | 2021-02-01 | Clarke | Georgia | 13059 | 13097 | 93 |
982516 | 982516 | 2021-01-31 | Clarke | Georgia | 13059 | 13068 | 92 |
979270 | 979270 | 2021-01-30 | Clarke | Georgia | 13059 | 13025 | 92 |
976025 | 976025 | 2021-01-29 | Clarke | Georgia | 13059 | 12961 | 88 |
972780 | 972780 | 2021-01-28 | Clarke | Georgia | 13059 | 12867 | 87 |
969535 | 969535 | 2021-01-27 | Clarke | Georgia | 13059 | 12750 | 87 |
966291 | 966291 | 2021-01-26 | Clarke | Georgia | 13059 | 12674 | 87 |
963046 | 963046 | 2021-01-25 | Clarke | Georgia | 13059 | 12560 | 84 |
959801 | 959801 | 2021-01-24 | Clarke | Georgia | 13059 | 12528 | 84 |
956555 | 956555 | 2021-01-23 | Clarke | Georgia | 13059 | 12482 | 84 |
953310 | 953310 | 2021-01-22 | Clarke | Georgia | 13059 | 12318 | 84 |
950065 | 950065 | 2021-01-21 | Clarke | Georgia | 13059 | 12227 | 81 |
946819 | 946819 | 2021-01-20 | Clarke | Georgia | 13059 | 12133 | 81 |
943572 | 943572 | 2021-01-19 | Clarke | Georgia | 13059 | 12052 | 81 |
940327 | 940327 | 2021-01-18 | Clarke | Georgia | 13059 | 11959 | 80 |
937082 | 937082 | 2021-01-17 | Clarke | Georgia | 13059 | 11916 | 79 |
933837 | 933837 | 2021-01-16 | Clarke | Georgia | 13059 | 11859 | 79 |
930592 | 930592 | 2021-01-15 | Clarke | Georgia | 13059 | 11778 | 77 |
927347 | 927347 | 2021-01-14 | Clarke | Georgia | 13059 | 11664 | 74 |
924101 | 924101 | 2021-01-13 | Clarke | Georgia | 13059 | 11554 | 74 |
920856 | 920856 | 2021-01-12 | Clarke | Georgia | 13059 | 11409 | 70 |
917611 | 917611 | 2021-01-11 | Clarke | Georgia | 13059 | 11296 | 70 |
914366 | 914366 | 2021-01-10 | Clarke | Georgia | 13059 | 11224 | 70 |
911121 | 911121 | 2021-01-09 | Clarke | Georgia | 13059 | 11131 | 70 |
907876 | 907876 | 2021-01-08 | Clarke | Georgia | 13059 | 10950 | 70 |
904630 | 904630 | 2021-01-07 | Clarke | Georgia | 13059 | 10799 | 70 |
901385 | 901385 | 2021-01-06 | Clarke | Georgia | 13059 | 10687 | 69 |
898140 | 898140 | 2021-01-05 | Clarke | Georgia | 13059 | 10555 | 67 |
894895 | 894895 | 2021-01-04 | Clarke | Georgia | 13059 | 10441 | 66 |
891648 | 891648 | 2021-01-03 | Clarke | Georgia | 13059 | 10393 | 66 |
888401 | 888401 | 2021-01-02 | Clarke | Georgia | 13059 | 10296 | 66 |
885156 | 885156 | 2021-01-01 | Clarke | Georgia | 13059 | 10189 | 66 |
881911 | 881911 | 2020-12-31 | Clarke | Georgia | 13059 | 10088 | 66 |
878666 | 878666 | 2020-12-30 | Clarke | Georgia | 13059 | 9988 | 65 |
875421 | 875421 | 2020-12-29 | Clarke | Georgia | 13059 | 9889 | 65 |
872176 | 872176 | 2020-12-28 | Clarke | Georgia | 13059 | 9763 | 65 |
868931 | 868931 | 2020-12-27 | Clarke | Georgia | 13059 | 9741 | 64 |
865686 | 865686 | 2020-12-26 | Clarke | Georgia | 13059 | 9707 | 64 |
862441 | 862441 | 2020-12-25 | Clarke | Georgia | 13059 | 9664 | 63 |
859196 | 859196 | 2020-12-24 | Clarke | Georgia | 13059 | 9616 | 63 |
855951 | 855951 | 2020-12-23 | Clarke | Georgia | 13059 | 9543 | 61 |
852706 | 852706 | 2020-12-22 | Clarke | Georgia | 13059 | 9448 | 61 |
849461 | 849461 | 2020-12-21 | Clarke | Georgia | 13059 | 9394 | 61 |
846216 | 846216 | 2020-12-20 | Clarke | Georgia | 13059 | 9342 | 61 |
842970 | 842970 | 2020-12-19 | Clarke | Georgia | 13059 | 9291 | 61 |
839725 | 839725 | 2020-12-18 | Clarke | Georgia | 13059 | 9229 | 60 |
836480 | 836480 | 2020-12-17 | Clarke | Georgia | 13059 | 9136 | 60 |
833234 | 833234 | 2020-12-16 | Clarke | Georgia | 13059 | 9062 | 59 |
829987 | 829987 | 2020-12-15 | Clarke | Georgia | 13059 | 8978 | 59 |
826741 | 826741 | 2020-12-14 | Clarke | Georgia | 13059 | 8897 | 58 |
823494 | 823494 | 2020-12-13 | Clarke | Georgia | 13059 | 8872 | 58 |
820248 | 820248 | 2020-12-12 | Clarke | Georgia | 13059 | 8810 | 58 |
817002 | 817002 | 2020-12-11 | Clarke | Georgia | 13059 | 8743 | 58 |
813756 | 813756 | 2020-12-10 | Clarke | Georgia | 13059 | 8651 | 57 |
810512 | 810512 | 2020-12-09 | Clarke | Georgia | 13059 | 8576 | 57 |
807267 | 807267 | 2020-12-08 | Clarke | Georgia | 13059 | 8498 | 56 |
804022 | 804022 | 2020-12-07 | Clarke | Georgia | 13059 | 8438 | 56 |
800777 | 800777 | 2020-12-06 | Clarke | Georgia | 13059 | 8395 | 56 |
797532 | 797532 | 2020-12-05 | Clarke | Georgia | 13059 | 8379 | 56 |
794287 | 794287 | 2020-12-04 | Clarke | Georgia | 13059 | 8282 | 56 |
791042 | 791042 | 2020-12-03 | Clarke | Georgia | 13059 | 8202 | 56 |
787797 | 787797 | 2020-12-02 | Clarke | Georgia | 13059 | 8127 | 56 |
784553 | 784553 | 2020-12-01 | Clarke | Georgia | 13059 | 8038 | 55 |
781308 | 781308 | 2020-11-30 | Clarke | Georgia | 13059 | 7985 | 56 |
778062 | 778062 | 2020-11-29 | Clarke | Georgia | 13059 | 7943 | 56 |
774817 | 774817 | 2020-11-28 | Clarke | Georgia | 13059 | 7927 | 56 |
771572 | 771572 | 2020-11-27 | Clarke | Georgia | 13059 | 7903 | 56 |
768327 | 768327 | 2020-11-26 | Clarke | Georgia | 13059 | 7873 | 56 |
765081 | 765081 | 2020-11-25 | Clarke | Georgia | 13059 | 7823 | 56 |
761836 | 761836 | 2020-11-24 | Clarke | Georgia | 13059 | 7761 | 54 |
758591 | 758591 | 2020-11-23 | Clarke | Georgia | 13059 | 7723 | 54 |
755344 | 755344 | 2020-11-22 | Clarke | Georgia | 13059 | 7698 | 53 |
752098 | 752098 | 2020-11-21 | Clarke | Georgia | 13059 | 7689 | 53 |
748852 | 748852 | 2020-11-20 | Clarke | Georgia | 13059 | 7604 | 52 |
745606 | 745606 | 2020-11-19 | Clarke | Georgia | 13059 | 7562 | 52 |
742359 | 742359 | 2020-11-18 | Clarke | Georgia | 13059 | 7522 | 52 |
739112 | 739112 | 2020-11-17 | Clarke | Georgia | 13059 | 7479 | 51 |
735868 | 735868 | 2020-11-16 | Clarke | Georgia | 13059 | 7439 | 51 |
732622 | 732622 | 2020-11-15 | Clarke | Georgia | 13059 | 7426 | 51 |
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);