ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where county = "Grant" and deaths = 14 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Kansas 29
- Oklahoma 29
- Oregon 27
- Wisconsin 22
- Kentucky 18
- Washington 13
- Indiana 4
- West Virginia 2
- Arkansas 1
- Louisiana 1
county 1
- Grant · 146 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
901103 | 901103 | 2021-01-06 | Grant | Arkansas | 5053 | 1155 | 14 |
107419 | 107419 | 2020-05-02 | Grant | Indiana | 18053 | 154 | 14 |
110289 | 110289 | 2020-05-03 | Grant | Indiana | 18053 | 155 | 14 |
113164 | 113164 | 2020-05-04 | Grant | Indiana | 18053 | 158 | 14 |
116047 | 116047 | 2020-05-05 | Grant | Indiana | 18053 | 159 | 14 |
827250 | 827250 | 2020-12-14 | Grant | Kansas | 20067 | 877 | 14 |
830496 | 830496 | 2020-12-15 | Grant | Kansas | 20067 | 878 | 14 |
833743 | 833743 | 2020-12-16 | Grant | Kansas | 20067 | 880 | 14 |
836989 | 836989 | 2020-12-17 | Grant | Kansas | 20067 | 880 | 14 |
840234 | 840234 | 2020-12-18 | Grant | Kansas | 20067 | 889 | 14 |
843479 | 843479 | 2020-12-19 | Grant | Kansas | 20067 | 892 | 14 |
846725 | 846725 | 2020-12-20 | Grant | Kansas | 20067 | 892 | 14 |
849970 | 849970 | 2020-12-21 | Grant | Kansas | 20067 | 897 | 14 |
853215 | 853215 | 2020-12-22 | Grant | Kansas | 20067 | 897 | 14 |
856460 | 856460 | 2020-12-23 | Grant | Kansas | 20067 | 901 | 14 |
859705 | 859705 | 2020-12-24 | Grant | Kansas | 20067 | 907 | 14 |
862950 | 862950 | 2020-12-25 | Grant | Kansas | 20067 | 907 | 14 |
866195 | 866195 | 2020-12-26 | Grant | Kansas | 20067 | 907 | 14 |
869440 | 869440 | 2020-12-27 | Grant | Kansas | 20067 | 907 | 14 |
872685 | 872685 | 2020-12-28 | Grant | Kansas | 20067 | 907 | 14 |
875930 | 875930 | 2020-12-29 | Grant | Kansas | 20067 | 907 | 14 |
879175 | 879175 | 2020-12-30 | Grant | Kansas | 20067 | 911 | 14 |
882420 | 882420 | 2020-12-31 | Grant | Kansas | 20067 | 912 | 14 |
885665 | 885665 | 2021-01-01 | Grant | Kansas | 20067 | 912 | 14 |
888911 | 888911 | 2021-01-02 | Grant | Kansas | 20067 | 912 | 14 |
892157 | 892157 | 2021-01-03 | Grant | Kansas | 20067 | 912 | 14 |
895404 | 895404 | 2021-01-04 | Grant | Kansas | 20067 | 915 | 14 |
898649 | 898649 | 2021-01-05 | Grant | Kansas | 20067 | 916 | 14 |
901894 | 901894 | 2021-01-06 | Grant | Kansas | 20067 | 920 | 14 |
905139 | 905139 | 2021-01-07 | Grant | Kansas | 20067 | 920 | 14 |
908385 | 908385 | 2021-01-08 | Grant | Kansas | 20067 | 923 | 14 |
911630 | 911630 | 2021-01-09 | Grant | Kansas | 20067 | 927 | 14 |
914875 | 914875 | 2021-01-10 | Grant | Kansas | 20067 | 927 | 14 |
918120 | 918120 | 2021-01-11 | Grant | Kansas | 20067 | 927 | 14 |
1083757 | 1083757 | 2021-03-03 | Grant | Kentucky | 21081 | 2229 | 14 |
1087003 | 1087003 | 2021-03-04 | Grant | Kentucky | 21081 | 2240 | 14 |
1090248 | 1090248 | 2021-03-05 | Grant | Kentucky | 21081 | 2249 | 14 |
1093494 | 1093494 | 2021-03-06 | Grant | Kentucky | 21081 | 2255 | 14 |
1096740 | 1096740 | 2021-03-07 | Grant | Kentucky | 21081 | 2261 | 14 |
1099988 | 1099988 | 2021-03-08 | Grant | Kentucky | 21081 | 2262 | 14 |
1103234 | 1103234 | 2021-03-09 | Grant | Kentucky | 21081 | 2263 | 14 |
1106480 | 1106480 | 2021-03-10 | Grant | Kentucky | 21081 | 2271 | 14 |
1109726 | 1109726 | 2021-03-11 | Grant | Kentucky | 21081 | 2280 | 14 |
1112972 | 1112972 | 2021-03-12 | Grant | Kentucky | 21081 | 2287 | 14 |
1116218 | 1116218 | 2021-03-13 | Grant | Kentucky | 21081 | 2287 | 14 |
1119465 | 1119465 | 2021-03-14 | Grant | Kentucky | 21081 | 2288 | 14 |
1122712 | 1122712 | 2021-03-15 | Grant | Kentucky | 21081 | 2288 | 14 |
1125958 | 1125958 | 2021-03-16 | Grant | Kentucky | 21081 | 2288 | 14 |
1129204 | 1129204 | 2021-03-17 | Grant | Kentucky | 21081 | 2294 | 14 |
1132452 | 1132452 | 2021-03-18 | Grant | Kentucky | 21081 | 2296 | 14 |
1135699 | 1135699 | 2021-03-19 | Grant | Kentucky | 21081 | 2308 | 14 |
1138945 | 1138945 | 2021-03-20 | Grant | Kentucky | 21081 | 2308 | 14 |
403156 | 403156 | 2020-08-05 | Grant | Louisiana | 22043 | 288 | 14 |
2221911 | 2221911 | 2022-02-16 | Grant | Oklahoma | 40053 | 1019 | 14 |
2225162 | 2225162 | 2022-02-17 | Grant | Oklahoma | 40053 | 1019 | 14 |
2228413 | 2228413 | 2022-02-18 | Grant | Oklahoma | 40053 | 1019 | 14 |
2231664 | 2231664 | 2022-02-19 | Grant | Oklahoma | 40053 | 1019 | 14 |
2234915 | 2234915 | 2022-02-20 | Grant | Oklahoma | 40053 | 1019 | 14 |
2238166 | 2238166 | 2022-02-21 | Grant | Oklahoma | 40053 | 1019 | 14 |
2241417 | 2241417 | 2022-02-22 | Grant | Oklahoma | 40053 | 1019 | 14 |
2244668 | 2244668 | 2022-02-23 | Grant | Oklahoma | 40053 | 1021 | 14 |
2247919 | 2247919 | 2022-02-24 | Grant | Oklahoma | 40053 | 1021 | 14 |
2251170 | 2251170 | 2022-02-25 | Grant | Oklahoma | 40053 | 1021 | 14 |
2254421 | 2254421 | 2022-02-26 | Grant | Oklahoma | 40053 | 1021 | 14 |
2257672 | 2257672 | 2022-02-27 | Grant | Oklahoma | 40053 | 1021 | 14 |
2260923 | 2260923 | 2022-02-28 | Grant | Oklahoma | 40053 | 1021 | 14 |
2264173 | 2264173 | 2022-03-01 | Grant | Oklahoma | 40053 | 1021 | 14 |
2267426 | 2267426 | 2022-03-02 | Grant | Oklahoma | 40053 | 1027 | 14 |
2270678 | 2270678 | 2022-03-03 | Grant | Oklahoma | 40053 | 1027 | 14 |
2273931 | 2273931 | 2022-03-04 | Grant | Oklahoma | 40053 | 1027 | 14 |
2277184 | 2277184 | 2022-03-05 | Grant | Oklahoma | 40053 | 1027 | 14 |
2280437 | 2280437 | 2022-03-06 | Grant | Oklahoma | 40053 | 1027 | 14 |
2283689 | 2283689 | 2022-03-07 | Grant | Oklahoma | 40053 | 1027 | 14 |
2286941 | 2286941 | 2022-03-08 | Grant | Oklahoma | 40053 | 1027 | 14 |
2290193 | 2290193 | 2022-03-09 | Grant | Oklahoma | 40053 | 1027 | 14 |
2293445 | 2293445 | 2022-03-10 | Grant | Oklahoma | 40053 | 1028 | 14 |
2296697 | 2296697 | 2022-03-11 | Grant | Oklahoma | 40053 | 1028 | 14 |
2299949 | 2299949 | 2022-03-12 | Grant | Oklahoma | 40053 | 1028 | 14 |
2303201 | 2303201 | 2022-03-13 | Grant | Oklahoma | 40053 | 1028 | 14 |
2306452 | 2306452 | 2022-03-14 | Grant | Oklahoma | 40053 | 1028 | 14 |
2309705 | 2309705 | 2022-03-15 | Grant | Oklahoma | 40053 | 1028 | 14 |
2312958 | 2312958 | 2022-03-16 | Grant | Oklahoma | 40053 | 1028 | 14 |
1877339 | 1877339 | 2021-11-02 | Grant | Oregon | 41023 | 1016 | 14 |
1880588 | 1880588 | 2021-11-03 | Grant | Oregon | 41023 | 1021 | 14 |
1883837 | 1883837 | 2021-11-04 | Grant | Oregon | 41023 | 1024 | 14 |
1887087 | 1887087 | 2021-11-05 | Grant | Oregon | 41023 | 1039 | 14 |
1890337 | 1890337 | 2021-11-06 | Grant | Oregon | 41023 | 1039 | 14 |
1893587 | 1893587 | 2021-11-07 | Grant | Oregon | 41023 | 1039 | 14 |
1896837 | 1896837 | 2021-11-08 | Grant | Oregon | 41023 | 1041 | 14 |
1900087 | 1900087 | 2021-11-09 | Grant | Oregon | 41023 | 1071 | 14 |
1903337 | 1903337 | 2021-11-10 | Grant | Oregon | 41023 | 1070 | 14 |
1906586 | 1906586 | 2021-11-11 | Grant | Oregon | 41023 | 1070 | 14 |
1909835 | 1909835 | 2021-11-12 | Grant | Oregon | 41023 | 1072 | 14 |
1913085 | 1913085 | 2021-11-13 | Grant | Oregon | 41023 | 1072 | 14 |
1916335 | 1916335 | 2021-11-14 | Grant | Oregon | 41023 | 1072 | 14 |
1919585 | 1919585 | 2021-11-15 | Grant | Oregon | 41023 | 1072 | 14 |
1922834 | 1922834 | 2021-11-16 | Grant | Oregon | 41023 | 1072 | 14 |
1926084 | 1926084 | 2021-11-17 | Grant | Oregon | 41023 | 1073 | 14 |
1929334 | 1929334 | 2021-11-18 | Grant | Oregon | 41023 | 1077 | 14 |
1932585 | 1932585 | 2021-11-19 | Grant | Oregon | 41023 | 1083 | 14 |
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);