ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Whitfield" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054051 | 1054051 | 2021-02-22 | Whitfield | Georgia | 13313 | 15787 | 210 |
1050804 | 1050804 | 2021-02-21 | Whitfield | Georgia | 13313 | 15776 | 209 |
1047557 | 1047557 | 2021-02-20 | Whitfield | Georgia | 13313 | 15764 | 209 |
1044312 | 1044312 | 2021-02-19 | Whitfield | Georgia | 13313 | 15742 | 209 |
1041067 | 1041067 | 2021-02-18 | Whitfield | Georgia | 13313 | 15718 | 207 |
1037822 | 1037822 | 2021-02-17 | Whitfield | Georgia | 13313 | 15676 | 206 |
1034577 | 1034577 | 2021-02-16 | Whitfield | Georgia | 13313 | 15643 | 205 |
1031331 | 1031331 | 2021-02-15 | Whitfield | Georgia | 13313 | 15628 | 204 |
1028084 | 1028084 | 2021-02-14 | Whitfield | Georgia | 13313 | 15619 | 204 |
1024839 | 1024839 | 2021-02-13 | Whitfield | Georgia | 13313 | 15604 | 204 |
1021594 | 1021594 | 2021-02-12 | Whitfield | Georgia | 13313 | 15568 | 202 |
1018349 | 1018349 | 2021-02-11 | Whitfield | Georgia | 13313 | 15527 | 201 |
1015104 | 1015104 | 2021-02-10 | Whitfield | Georgia | 13313 | 15483 | 197 |
1011859 | 1011859 | 2021-02-09 | Whitfield | Georgia | 13313 | 15428 | 194 |
1008613 | 1008613 | 2021-02-08 | Whitfield | Georgia | 13313 | 15403 | 188 |
1005367 | 1005367 | 2021-02-07 | Whitfield | Georgia | 13313 | 15387 | 188 |
1002121 | 1002121 | 2021-02-06 | Whitfield | Georgia | 13313 | 15350 | 188 |
998875 | 998875 | 2021-02-05 | Whitfield | Georgia | 13313 | 15321 | 183 |
995629 | 995629 | 2021-02-04 | Whitfield | Georgia | 13313 | 15276 | 178 |
992383 | 992383 | 2021-02-03 | Whitfield | Georgia | 13313 | 15216 | 178 |
989137 | 989137 | 2021-02-02 | Whitfield | Georgia | 13313 | 15143 | 177 |
985890 | 985890 | 2021-02-01 | Whitfield | Georgia | 13313 | 15091 | 174 |
982643 | 982643 | 2021-01-31 | Whitfield | Georgia | 13313 | 15075 | 174 |
979397 | 979397 | 2021-01-30 | Whitfield | Georgia | 13313 | 15002 | 174 |
976152 | 976152 | 2021-01-29 | Whitfield | Georgia | 13313 | 14948 | 172 |
972907 | 972907 | 2021-01-28 | Whitfield | Georgia | 13313 | 14862 | 171 |
969662 | 969662 | 2021-01-27 | Whitfield | Georgia | 13313 | 14777 | 169 |
966418 | 966418 | 2021-01-26 | Whitfield | Georgia | 13313 | 14702 | 168 |
963173 | 963173 | 2021-01-25 | Whitfield | Georgia | 13313 | 14648 | 166 |
959928 | 959928 | 2021-01-24 | Whitfield | Georgia | 13313 | 14604 | 165 |
956682 | 956682 | 2021-01-23 | Whitfield | Georgia | 13313 | 14585 | 165 |
953437 | 953437 | 2021-01-22 | Whitfield | Georgia | 13313 | 14500 | 163 |
950192 | 950192 | 2021-01-21 | Whitfield | Georgia | 13313 | 14385 | 163 |
946946 | 946946 | 2021-01-20 | Whitfield | Georgia | 13313 | 14255 | 163 |
943699 | 943699 | 2021-01-19 | Whitfield | Georgia | 13313 | 14162 | 162 |
940454 | 940454 | 2021-01-18 | Whitfield | Georgia | 13313 | 14076 | 160 |
937209 | 937209 | 2021-01-17 | Whitfield | Georgia | 13313 | 14022 | 156 |
933964 | 933964 | 2021-01-16 | Whitfield | Georgia | 13313 | 13945 | 156 |
930719 | 930719 | 2021-01-15 | Whitfield | Georgia | 13313 | 13866 | 153 |
927474 | 927474 | 2021-01-14 | Whitfield | Georgia | 13313 | 13746 | 151 |
924228 | 924228 | 2021-01-13 | Whitfield | Georgia | 13313 | 13587 | 141 |
920983 | 920983 | 2021-01-12 | Whitfield | Georgia | 13313 | 13396 | 139 |
917738 | 917738 | 2021-01-11 | Whitfield | Georgia | 13313 | 13285 | 137 |
914493 | 914493 | 2021-01-10 | Whitfield | Georgia | 13313 | 13173 | 137 |
911248 | 911248 | 2021-01-09 | Whitfield | Georgia | 13313 | 13028 | 137 |
908003 | 908003 | 2021-01-08 | Whitfield | Georgia | 13313 | 12851 | 136 |
904757 | 904757 | 2021-01-07 | Whitfield | Georgia | 13313 | 12643 | 135 |
901512 | 901512 | 2021-01-06 | Whitfield | Georgia | 13313 | 12539 | 135 |
898267 | 898267 | 2021-01-05 | Whitfield | Georgia | 13313 | 12339 | 132 |
895022 | 895022 | 2021-01-04 | Whitfield | Georgia | 13313 | 12248 | 127 |
891775 | 891775 | 2021-01-03 | Whitfield | Georgia | 13313 | 12174 | 127 |
888528 | 888528 | 2021-01-02 | Whitfield | Georgia | 13313 | 12090 | 126 |
885283 | 885283 | 2021-01-01 | Whitfield | Georgia | 13313 | 11988 | 126 |
882038 | 882038 | 2020-12-31 | Whitfield | Georgia | 13313 | 11815 | 126 |
878793 | 878793 | 2020-12-30 | Whitfield | Georgia | 13313 | 11613 | 121 |
875548 | 875548 | 2020-12-29 | Whitfield | Georgia | 13313 | 11424 | 121 |
872303 | 872303 | 2020-12-28 | Whitfield | Georgia | 13313 | 11339 | 116 |
869058 | 869058 | 2020-12-27 | Whitfield | Georgia | 13313 | 11306 | 116 |
865813 | 865813 | 2020-12-26 | Whitfield | Georgia | 13313 | 11209 | 116 |
862568 | 862568 | 2020-12-25 | Whitfield | Georgia | 13313 | 11174 | 114 |
859323 | 859323 | 2020-12-24 | Whitfield | Georgia | 13313 | 11092 | 113 |
856078 | 856078 | 2020-12-23 | Whitfield | Georgia | 13313 | 10908 | 113 |
852833 | 852833 | 2020-12-22 | Whitfield | Georgia | 13313 | 10758 | 113 |
849588 | 849588 | 2020-12-21 | Whitfield | Georgia | 13313 | 10639 | 111 |
846343 | 846343 | 2020-12-20 | Whitfield | Georgia | 13313 | 10539 | 111 |
843097 | 843097 | 2020-12-19 | Whitfield | Georgia | 13313 | 10419 | 111 |
839852 | 839852 | 2020-12-18 | Whitfield | Georgia | 13313 | 10295 | 109 |
836607 | 836607 | 2020-12-17 | Whitfield | Georgia | 13313 | 10078 | 109 |
833361 | 833361 | 2020-12-16 | Whitfield | Georgia | 13313 | 9860 | 105 |
830114 | 830114 | 2020-12-15 | Whitfield | Georgia | 13313 | 9726 | 101 |
826868 | 826868 | 2020-12-14 | Whitfield | Georgia | 13313 | 9627 | 100 |
823621 | 823621 | 2020-12-13 | Whitfield | Georgia | 13313 | 9556 | 100 |
820375 | 820375 | 2020-12-12 | Whitfield | Georgia | 13313 | 9452 | 100 |
817129 | 817129 | 2020-12-11 | Whitfield | Georgia | 13313 | 9282 | 98 |
813883 | 813883 | 2020-12-10 | Whitfield | Georgia | 13313 | 9109 | 97 |
810639 | 810639 | 2020-12-09 | Whitfield | Georgia | 13313 | 8952 | 97 |
807394 | 807394 | 2020-12-08 | Whitfield | Georgia | 13313 | 8763 | 97 |
804149 | 804149 | 2020-12-07 | Whitfield | Georgia | 13313 | 8686 | 96 |
800904 | 800904 | 2020-12-06 | Whitfield | Georgia | 13313 | 8596 | 90 |
797659 | 797659 | 2020-12-05 | Whitfield | Georgia | 13313 | 8516 | 90 |
794414 | 794414 | 2020-12-04 | Whitfield | Georgia | 13313 | 8387 | 89 |
791169 | 791169 | 2020-12-03 | Whitfield | Georgia | 13313 | 8203 | 87 |
787924 | 787924 | 2020-12-02 | Whitfield | Georgia | 13313 | 8061 | 85 |
784680 | 784680 | 2020-12-01 | Whitfield | Georgia | 13313 | 7964 | 84 |
781435 | 781435 | 2020-11-30 | Whitfield | Georgia | 13313 | 7887 | 83 |
778189 | 778189 | 2020-11-29 | Whitfield | Georgia | 13313 | 7872 | 83 |
774944 | 774944 | 2020-11-28 | Whitfield | Georgia | 13313 | 7846 | 82 |
771699 | 771699 | 2020-11-27 | Whitfield | Georgia | 13313 | 7755 | 82 |
768454 | 768454 | 2020-11-26 | Whitfield | Georgia | 13313 | 7703 | 82 |
765208 | 765208 | 2020-11-25 | Whitfield | Georgia | 13313 | 7610 | 81 |
761963 | 761963 | 2020-11-24 | Whitfield | Georgia | 13313 | 7539 | 79 |
758718 | 758718 | 2020-11-23 | Whitfield | Georgia | 13313 | 7430 | 77 |
755471 | 755471 | 2020-11-22 | Whitfield | Georgia | 13313 | 7359 | 77 |
752225 | 752225 | 2020-11-21 | Whitfield | Georgia | 13313 | 7282 | 77 |
748979 | 748979 | 2020-11-20 | Whitfield | Georgia | 13313 | 7167 | 75 |
745733 | 745733 | 2020-11-19 | Whitfield | Georgia | 13313 | 7056 | 75 |
742486 | 742486 | 2020-11-18 | Whitfield | Georgia | 13313 | 6939 | 76 |
739239 | 739239 | 2020-11-17 | Whitfield | Georgia | 13313 | 6883 | 75 |
735995 | 735995 | 2020-11-16 | Whitfield | Georgia | 13313 | 6811 | 71 |
732749 | 732749 | 2020-11-15 | Whitfield | Georgia | 13313 | 6745 | 71 |
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);