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 county
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 |
---|---|---|---|---|---|---|---|
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 |
340955 | 340955 | 2020-07-16 | Grant | Wisconsin | 55043 | 231 | 14 |
344154 | 344154 | 2020-07-17 | Grant | Wisconsin | 55043 | 236 | 14 |
347354 | 347354 | 2020-07-18 | Grant | Wisconsin | 55043 | 243 | 14 |
350555 | 350555 | 2020-07-19 | Grant | Wisconsin | 55043 | 248 | 14 |
353757 | 353757 | 2020-07-20 | Grant | Wisconsin | 55043 | 250 | 14 |
356960 | 356960 | 2020-07-21 | Grant | Wisconsin | 55043 | 252 | 14 |
360165 | 360165 | 2020-07-22 | Grant | Wisconsin | 55043 | 256 | 14 |
363371 | 363371 | 2020-07-23 | Grant | Wisconsin | 55043 | 261 | 14 |
366578 | 366578 | 2020-07-24 | Grant | Wisconsin | 55043 | 266 | 14 |
369788 | 369788 | 2020-07-25 | Grant | Wisconsin | 55043 | 282 | 14 |
373000 | 373000 | 2020-07-26 | Grant | Wisconsin | 55043 | 286 | 14 |
376214 | 376214 | 2020-07-27 | Grant | Wisconsin | 55043 | 291 | 14 |
379430 | 379430 | 2020-07-28 | Grant | Wisconsin | 55043 | 299 | 14 |
382647 | 382647 | 2020-07-29 | Grant | Wisconsin | 55043 | 303 | 14 |
385865 | 385865 | 2020-07-30 | Grant | Wisconsin | 55043 | 313 | 14 |
389082 | 389082 | 2020-07-31 | Grant | Wisconsin | 55043 | 318 | 14 |
392299 | 392299 | 2020-08-01 | Grant | Wisconsin | 55043 | 320 | 14 |
395515 | 395515 | 2020-08-02 | Grant | Wisconsin | 55043 | 328 | 14 |
398731 | 398731 | 2020-08-03 | Grant | Wisconsin | 55043 | 329 | 14 |
401947 | 401947 | 2020-08-04 | Grant | Wisconsin | 55043 | 331 | 14 |
403156 | 403156 | 2020-08-05 | Grant | Louisiana | 22043 | 288 | 14 |
405165 | 405165 | 2020-08-05 | Grant | Wisconsin | 55043 | 332 | 14 |
408385 | 408385 | 2020-08-06 | Grant | Wisconsin | 55043 | 341 | 14 |
450193 | 450193 | 2020-08-19 | Grant | Washington | 53025 | 1993 | 14 |
453421 | 453421 | 2020-08-20 | Grant | Washington | 53025 | 2021 | 14 |
456649 | 456649 | 2020-08-21 | Grant | Washington | 53025 | 2098 | 14 |
459876 | 459876 | 2020-08-22 | Grant | Washington | 53025 | 2098 | 14 |
463105 | 463105 | 2020-08-23 | Grant | Washington | 53025 | 2098 | 14 |
466334 | 466334 | 2020-08-24 | Grant | Washington | 53025 | 2170 | 14 |
469563 | 469563 | 2020-08-25 | Grant | Washington | 53025 | 2179 | 14 |
479261 | 479261 | 2020-08-28 | Grant | Washington | 53025 | 2310 | 14 |
482495 | 482495 | 2020-08-29 | Grant | Washington | 53025 | 2310 | 14 |
485730 | 485730 | 2020-08-30 | Grant | Washington | 53025 | 2310 | 14 |
488963 | 488963 | 2020-08-31 | Grant | Washington | 53025 | 2371 | 14 |
492196 | 492196 | 2020-09-01 | Grant | Washington | 53025 | 2371 | 14 |
495430 | 495430 | 2020-09-02 | Grant | Washington | 53025 | 2427 | 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 |
842413 | 842413 | 2020-12-18 | Grant | West Virginia | 54023 | 636 | 14 |
843479 | 843479 | 2020-12-19 | Grant | Kansas | 20067 | 892 | 14 |
845659 | 845659 | 2020-12-19 | Grant | West Virginia | 54023 | 647 | 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 |
901103 | 901103 | 2021-01-06 | Grant | Arkansas | 5053 | 1155 | 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 |
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 |
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);