ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where county = "Grant" and deaths = 16 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
- Oklahoma 44
- Kentucky 14
- Wisconsin 13
- Washington 11
- Kansas 9
- Oregon 6
- Louisiana 3
- New Mexico 2
- West Virginia 2
- Arkansas 1
- Indiana 1
county 1
- Grant · 106 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
914084 | 914084 | 2021-01-10 | Grant | Arkansas | 5053 | 1195 | 16 |
124957 | 124957 | 2020-05-08 | Grant | Indiana | 18053 | 170 | 16 |
966800 | 966800 | 2021-01-26 | Grant | Kansas | 20067 | 946 | 16 |
970044 | 970044 | 2021-01-27 | Grant | Kansas | 20067 | 949 | 16 |
973289 | 973289 | 2021-01-28 | Grant | Kansas | 20067 | 949 | 16 |
976534 | 976534 | 2021-01-29 | Grant | Kansas | 20067 | 950 | 16 |
979780 | 979780 | 2021-01-30 | Grant | Kansas | 20067 | 950 | 16 |
983026 | 983026 | 2021-01-31 | Grant | Kansas | 20067 | 950 | 16 |
986273 | 986273 | 2021-02-01 | Grant | Kansas | 20067 | 950 | 16 |
989520 | 989520 | 2021-02-02 | Grant | Kansas | 20067 | 950 | 16 |
992766 | 992766 | 2021-02-03 | Grant | Kansas | 20067 | 950 | 16 |
1145438 | 1145438 | 2021-03-22 | Grant | Kentucky | 21081 | 2312 | 16 |
1148685 | 1148685 | 2021-03-23 | Grant | Kentucky | 21081 | 2312 | 16 |
1151932 | 1151932 | 2021-03-24 | Grant | Kentucky | 21081 | 2312 | 16 |
1155179 | 1155179 | 2021-03-25 | Grant | Kentucky | 21081 | 2316 | 16 |
1158426 | 1158426 | 2021-03-26 | Grant | Kentucky | 21081 | 2318 | 16 |
1161674 | 1161674 | 2021-03-27 | Grant | Kentucky | 21081 | 2318 | 16 |
1164922 | 1164922 | 2021-03-28 | Grant | Kentucky | 21081 | 2318 | 16 |
1168170 | 1168170 | 2021-03-29 | Grant | Kentucky | 21081 | 2327 | 16 |
1171418 | 1171418 | 2021-03-30 | Grant | Kentucky | 21081 | 2330 | 16 |
1174665 | 1174665 | 2021-03-31 | Grant | Kentucky | 21081 | 2333 | 16 |
1177912 | 1177912 | 2021-04-01 | Grant | Kentucky | 21081 | 2341 | 16 |
1181159 | 1181159 | 2021-04-02 | Grant | Kentucky | 21081 | 2341 | 16 |
1184406 | 1184406 | 2021-04-03 | Grant | Kentucky | 21081 | 2341 | 16 |
1187653 | 1187653 | 2021-04-04 | Grant | Kentucky | 21081 | 2341 | 16 |
406374 | 406374 | 2020-08-06 | Grant | Louisiana | 22043 | 292 | 16 |
409594 | 409594 | 2020-08-07 | Grant | Louisiana | 22043 | 298 | 16 |
412814 | 412814 | 2020-08-08 | Grant | Louisiana | 22043 | 298 | 16 |
906033 | 906033 | 2021-01-07 | Grant | New Mexico | 35017 | 1030 | 16 |
909279 | 909279 | 2021-01-08 | Grant | New Mexico | 35017 | 1050 | 16 |
2361757 | 2361757 | 2022-03-31 | Grant | Oklahoma | 40053 | 1031 | 16 |
2365010 | 2365010 | 2022-04-01 | Grant | Oklahoma | 40053 | 1031 | 16 |
2368263 | 2368263 | 2022-04-02 | Grant | Oklahoma | 40053 | 1031 | 16 |
2371516 | 2371516 | 2022-04-03 | Grant | Oklahoma | 40053 | 1031 | 16 |
2374768 | 2374768 | 2022-04-04 | Grant | Oklahoma | 40053 | 1031 | 16 |
2378022 | 2378022 | 2022-04-05 | Grant | Oklahoma | 40053 | 1031 | 16 |
2381277 | 2381277 | 2022-04-06 | Grant | Oklahoma | 40053 | 1031 | 16 |
2384532 | 2384532 | 2022-04-07 | Grant | Oklahoma | 40053 | 1031 | 16 |
2387787 | 2387787 | 2022-04-08 | Grant | Oklahoma | 40053 | 1031 | 16 |
2391043 | 2391043 | 2022-04-09 | Grant | Oklahoma | 40053 | 1031 | 16 |
2394299 | 2394299 | 2022-04-10 | Grant | Oklahoma | 40053 | 1031 | 16 |
2397554 | 2397554 | 2022-04-11 | Grant | Oklahoma | 40053 | 1031 | 16 |
2400809 | 2400809 | 2022-04-12 | Grant | Oklahoma | 40053 | 1031 | 16 |
2404064 | 2404064 | 2022-04-13 | Grant | Oklahoma | 40053 | 1031 | 16 |
2407320 | 2407320 | 2022-04-14 | Grant | Oklahoma | 40053 | 1031 | 16 |
2410576 | 2410576 | 2022-04-15 | Grant | Oklahoma | 40053 | 1031 | 16 |
2413832 | 2413832 | 2022-04-16 | Grant | Oklahoma | 40053 | 1031 | 16 |
2417088 | 2417088 | 2022-04-17 | Grant | Oklahoma | 40053 | 1031 | 16 |
2420343 | 2420343 | 2022-04-18 | Grant | Oklahoma | 40053 | 1031 | 16 |
2423600 | 2423600 | 2022-04-19 | Grant | Oklahoma | 40053 | 1031 | 16 |
2426856 | 2426856 | 2022-04-20 | Grant | Oklahoma | 40053 | 1031 | 16 |
2430112 | 2430112 | 2022-04-21 | Grant | Oklahoma | 40053 | 1032 | 16 |
2433368 | 2433368 | 2022-04-22 | Grant | Oklahoma | 40053 | 1032 | 16 |
2436624 | 2436624 | 2022-04-23 | Grant | Oklahoma | 40053 | 1032 | 16 |
2439880 | 2439880 | 2022-04-24 | Grant | Oklahoma | 40053 | 1032 | 16 |
2443136 | 2443136 | 2022-04-25 | Grant | Oklahoma | 40053 | 1032 | 16 |
2446391 | 2446391 | 2022-04-26 | Grant | Oklahoma | 40053 | 1032 | 16 |
2449648 | 2449648 | 2022-04-27 | Grant | Oklahoma | 40053 | 1032 | 16 |
2452904 | 2452904 | 2022-04-28 | Grant | Oklahoma | 40053 | 1034 | 16 |
2456160 | 2456160 | 2022-04-29 | Grant | Oklahoma | 40053 | 1034 | 16 |
2459416 | 2459416 | 2022-04-30 | Grant | Oklahoma | 40053 | 1034 | 16 |
2462672 | 2462672 | 2022-05-01 | Grant | Oklahoma | 40053 | 1034 | 16 |
2465927 | 2465927 | 2022-05-02 | Grant | Oklahoma | 40053 | 1034 | 16 |
2469183 | 2469183 | 2022-05-03 | Grant | Oklahoma | 40053 | 1034 | 16 |
2472439 | 2472439 | 2022-05-04 | Grant | Oklahoma | 40053 | 1034 | 16 |
2475696 | 2475696 | 2022-05-05 | Grant | Oklahoma | 40053 | 1035 | 16 |
2478954 | 2478954 | 2022-05-06 | Grant | Oklahoma | 40053 | 1035 | 16 |
2482212 | 2482212 | 2022-05-07 | Grant | Oklahoma | 40053 | 1035 | 16 |
2485470 | 2485470 | 2022-05-08 | Grant | Oklahoma | 40053 | 1035 | 16 |
2488727 | 2488727 | 2022-05-09 | Grant | Oklahoma | 40053 | 1035 | 16 |
2491985 | 2491985 | 2022-05-10 | Grant | Oklahoma | 40053 | 1035 | 16 |
2495243 | 2495243 | 2022-05-11 | Grant | Oklahoma | 40053 | 1035 | 16 |
2498501 | 2498501 | 2022-05-12 | Grant | Oklahoma | 40053 | 1036 | 16 |
2501759 | 2501759 | 2022-05-13 | Grant | Oklahoma | 40053 | 1036 | 16 |
1978093 | 1978093 | 2021-12-03 | Grant | Oregon | 41023 | 1091 | 16 |
1981343 | 1981343 | 2021-12-04 | Grant | Oregon | 41023 | 1091 | 16 |
1984593 | 1984593 | 2021-12-05 | Grant | Oregon | 41023 | 1091 | 16 |
1987843 | 1987843 | 2021-12-06 | Grant | Oregon | 41023 | 1091 | 16 |
1991094 | 1991094 | 2021-12-07 | Grant | Oregon | 41023 | 1092 | 16 |
1994345 | 1994345 | 2021-12-08 | Grant | Oregon | 41023 | 1092 | 16 |
498663 | 498663 | 2020-09-03 | Grant | Washington | 53025 | 2467 | 16 |
501897 | 501897 | 2020-09-04 | Grant | Washington | 53025 | 2497 | 16 |
505131 | 505131 | 2020-09-05 | Grant | Washington | 53025 | 2497 | 16 |
508363 | 508363 | 2020-09-06 | Grant | Washington | 53025 | 2497 | 16 |
511596 | 511596 | 2020-09-07 | Grant | Washington | 53025 | 2497 | 16 |
514829 | 514829 | 2020-09-08 | Grant | Washington | 53025 | 2587 | 16 |
518064 | 518064 | 2020-09-09 | Grant | Washington | 53025 | 2601 | 16 |
521301 | 521301 | 2020-09-10 | Grant | Washington | 53025 | 2643 | 16 |
524537 | 524537 | 2020-09-11 | Grant | Washington | 53025 | 2661 | 16 |
527773 | 527773 | 2020-09-12 | Grant | Washington | 53025 | 2661 | 16 |
531010 | 531010 | 2020-09-13 | Grant | Washington | 53025 | 2661 | 16 |
848904 | 848904 | 2020-12-20 | Grant | West Virginia | 54023 | 651 | 16 |
852149 | 852149 | 2020-12-21 | Grant | West Virginia | 54023 | 667 | 16 |
430939 | 430939 | 2020-08-13 | Grant | Wisconsin | 55043 | 375 | 16 |
434164 | 434164 | 2020-08-14 | Grant | Wisconsin | 55043 | 387 | 16 |
437390 | 437390 | 2020-08-15 | Grant | Wisconsin | 55043 | 391 | 16 |
440616 | 440616 | 2020-08-16 | Grant | Wisconsin | 55043 | 396 | 16 |
443842 | 443842 | 2020-08-17 | Grant | Wisconsin | 55043 | 398 | 16 |
447069 | 447069 | 2020-08-18 | Grant | Wisconsin | 55043 | 402 | 16 |
450297 | 450297 | 2020-08-19 | Grant | Wisconsin | 55043 | 409 | 16 |
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);