ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where county = "Grant" and deaths = 22 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Kentucky 35
- Kansas 21
- Oregon 13
- West Virginia 9
- Washington 7
- Indiana 6
- New Mexico 5
- Arkansas 1
- Louisiana 1
- South Dakota 1
county 1
- Grant · 99 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
927065 | 927065 | 2021-01-14 | Grant | Arkansas | 5053 | 1239 | 22 |
160969 | 160969 | 2020-05-20 | Grant | Indiana | 18053 | 204 | 22 |
163997 | 163997 | 2020-05-21 | Grant | Indiana | 18053 | 211 | 22 |
167030 | 167030 | 2020-05-22 | Grant | Indiana | 18053 | 214 | 22 |
170067 | 170067 | 2020-05-23 | Grant | Indiana | 18053 | 221 | 22 |
173108 | 173108 | 2020-05-24 | Grant | Indiana | 18053 | 226 | 22 |
176152 | 176152 | 2020-05-25 | Grant | Indiana | 18053 | 230 | 22 |
1635612 | 1635612 | 2021-08-20 | Grant | Kansas | 20067 | 1063 | 22 |
1638862 | 1638862 | 2021-08-21 | Grant | Kansas | 20067 | 1063 | 22 |
1642112 | 1642112 | 2021-08-22 | Grant | Kansas | 20067 | 1063 | 22 |
1645361 | 1645361 | 2021-08-23 | Grant | Kansas | 20067 | 1071 | 22 |
1648609 | 1648609 | 2021-08-24 | Grant | Kansas | 20067 | 1071 | 22 |
1651858 | 1651858 | 2021-08-25 | Grant | Kansas | 20067 | 1071 | 22 |
1655105 | 1655105 | 2021-08-26 | Grant | Kansas | 20067 | 1078 | 22 |
1658353 | 1658353 | 2021-08-27 | Grant | Kansas | 20067 | 1083 | 22 |
1661601 | 1661601 | 2021-08-28 | Grant | Kansas | 20067 | 1083 | 22 |
1664849 | 1664849 | 2021-08-29 | Grant | Kansas | 20067 | 1083 | 22 |
1668096 | 1668096 | 2021-08-30 | Grant | Kansas | 20067 | 1089 | 22 |
1671343 | 1671343 | 2021-08-31 | Grant | Kansas | 20067 | 1093 | 22 |
1674592 | 1674592 | 2021-09-01 | Grant | Kansas | 20067 | 1093 | 22 |
1677839 | 1677839 | 2021-09-02 | Grant | Kansas | 20067 | 1099 | 22 |
1681087 | 1681087 | 2021-09-03 | Grant | Kansas | 20067 | 1100 | 22 |
1684338 | 1684338 | 2021-09-04 | Grant | Kansas | 20067 | 1100 | 22 |
1687588 | 1687588 | 2021-09-05 | Grant | Kansas | 20067 | 1100 | 22 |
1690838 | 1690838 | 2021-09-06 | Grant | Kansas | 20067 | 1100 | 22 |
1694087 | 1694087 | 2021-09-07 | Grant | Kansas | 20067 | 1100 | 22 |
1697335 | 1697335 | 2021-09-08 | Grant | Kansas | 20067 | 1111 | 22 |
1700584 | 1700584 | 2021-09-09 | Grant | Kansas | 20067 | 1117 | 22 |
1262349 | 1262349 | 2021-04-27 | Grant | Kentucky | 21081 | 2404 | 22 |
1265596 | 1265596 | 2021-04-28 | Grant | Kentucky | 21081 | 2408 | 22 |
1268843 | 1268843 | 2021-04-29 | Grant | Kentucky | 21081 | 2410 | 22 |
1272090 | 1272090 | 2021-04-30 | Grant | Kentucky | 21081 | 2412 | 22 |
1275337 | 1275337 | 2021-05-01 | Grant | Kentucky | 21081 | 2412 | 22 |
1278584 | 1278584 | 2021-05-02 | Grant | Kentucky | 21081 | 2412 | 22 |
1281831 | 1281831 | 2021-05-03 | Grant | Kentucky | 21081 | 2421 | 22 |
1285078 | 1285078 | 2021-05-04 | Grant | Kentucky | 21081 | 2425 | 22 |
1288324 | 1288324 | 2021-05-05 | Grant | Kentucky | 21081 | 2429 | 22 |
1291570 | 1291570 | 2021-05-06 | Grant | Kentucky | 21081 | 2433 | 22 |
1294816 | 1294816 | 2021-05-07 | Grant | Kentucky | 21081 | 2436 | 22 |
1298062 | 1298062 | 2021-05-08 | Grant | Kentucky | 21081 | 2436 | 22 |
1301309 | 1301309 | 2021-05-09 | Grant | Kentucky | 21081 | 2436 | 22 |
1304556 | 1304556 | 2021-05-10 | Grant | Kentucky | 21081 | 2439 | 22 |
1307802 | 1307802 | 2021-05-11 | Grant | Kentucky | 21081 | 2444 | 22 |
1311048 | 1311048 | 2021-05-12 | Grant | Kentucky | 21081 | 2449 | 22 |
1314295 | 1314295 | 2021-05-13 | Grant | Kentucky | 21081 | 2451 | 22 |
1317542 | 1317542 | 2021-05-14 | Grant | Kentucky | 21081 | 2454 | 22 |
1320789 | 1320789 | 2021-05-15 | Grant | Kentucky | 21081 | 2454 | 22 |
1324035 | 1324035 | 2021-05-16 | Grant | Kentucky | 21081 | 2454 | 22 |
1327281 | 1327281 | 2021-05-17 | Grant | Kentucky | 21081 | 2459 | 22 |
1330528 | 1330528 | 2021-05-18 | Grant | Kentucky | 21081 | 2467 | 22 |
1333775 | 1333775 | 2021-05-19 | Grant | Kentucky | 21081 | 2469 | 22 |
1337022 | 1337022 | 2021-05-20 | Grant | Kentucky | 21081 | 2471 | 22 |
1340269 | 1340269 | 2021-05-21 | Grant | Kentucky | 21081 | 2473 | 22 |
1343517 | 1343517 | 2021-05-22 | Grant | Kentucky | 21081 | 2473 | 22 |
1346765 | 1346765 | 2021-05-23 | Grant | Kentucky | 21081 | 2473 | 22 |
1350012 | 1350012 | 2021-05-24 | Grant | Kentucky | 21081 | 2480 | 22 |
1398698 | 1398698 | 2021-06-08 | Grant | Kentucky | 21081 | 2515 | 22 |
1401943 | 1401943 | 2021-06-09 | Grant | Kentucky | 21081 | 2520 | 22 |
1405188 | 1405188 | 2021-06-10 | Grant | Kentucky | 21081 | 2521 | 22 |
1408434 | 1408434 | 2021-06-11 | Grant | Kentucky | 21081 | 2528 | 22 |
1411679 | 1411679 | 2021-06-12 | Grant | Kentucky | 21081 | 2528 | 22 |
1414924 | 1414924 | 2021-06-13 | Grant | Kentucky | 21081 | 2528 | 22 |
1418170 | 1418170 | 2021-06-14 | Grant | Kentucky | 21081 | 2531 | 22 |
438600 | 438600 | 2020-08-16 | Grant | Louisiana | 22043 | 357 | 22 |
931995 | 931995 | 2021-01-15 | Grant | New Mexico | 35017 | 1159 | 22 |
935240 | 935240 | 2021-01-16 | Grant | New Mexico | 35017 | 1172 | 22 |
938485 | 938485 | 2021-01-17 | Grant | New Mexico | 35017 | 1185 | 22 |
941730 | 941730 | 2021-01-18 | Grant | New Mexico | 35017 | 1191 | 22 |
944975 | 944975 | 2021-01-19 | Grant | New Mexico | 35017 | 1201 | 22 |
2384595 | 2384595 | 2022-04-07 | Grant | Oregon | 41023 | 1676 | 22 |
2387850 | 2387850 | 2022-04-08 | Grant | Oregon | 41023 | 1676 | 22 |
2391106 | 2391106 | 2022-04-09 | Grant | Oregon | 41023 | 1676 | 22 |
2394362 | 2394362 | 2022-04-10 | Grant | Oregon | 41023 | 1676 | 22 |
2397617 | 2397617 | 2022-04-11 | Grant | Oregon | 41023 | 1676 | 22 |
2400872 | 2400872 | 2022-04-12 | Grant | Oregon | 41023 | 1681 | 22 |
2404127 | 2404127 | 2022-04-13 | Grant | Oregon | 41023 | 1683 | 22 |
2407383 | 2407383 | 2022-04-14 | Grant | Oregon | 41023 | 1687 | 22 |
2410639 | 2410639 | 2022-04-15 | Grant | Oregon | 41023 | 1692 | 22 |
2413895 | 2413895 | 2022-04-16 | Grant | Oregon | 41023 | 1692 | 22 |
2417151 | 2417151 | 2022-04-17 | Grant | Oregon | 41023 | 1692 | 22 |
2420406 | 2420406 | 2022-04-18 | Grant | Oregon | 41023 | 1692 | 22 |
2423663 | 2423663 | 2022-04-19 | Grant | Oregon | 41023 | 1694 | 22 |
858016 | 858016 | 2020-12-23 | Grant | South Dakota | 46051 | 807 | 22 |
602278 | 602278 | 2020-10-05 | Grant | Washington | 53025 | 3173 | 22 |
605520 | 605520 | 2020-10-06 | Grant | Washington | 53025 | 3191 | 22 |
608763 | 608763 | 2020-10-07 | Grant | Washington | 53025 | 3215 | 22 |
612005 | 612005 | 2020-10-08 | Grant | Washington | 53025 | 3238 | 22 |
615246 | 615246 | 2020-10-09 | Grant | Washington | 53025 | 3252 | 22 |
618488 | 618488 | 2020-10-10 | Grant | Washington | 53025 | 3252 | 22 |
621731 | 621731 | 2020-10-11 | Grant | Washington | 53025 | 3252 | 22 |
1001437 | 1001437 | 2021-02-05 | Grant | West Virginia | 54023 | 1010 | 22 |
1004683 | 1004683 | 2021-02-06 | Grant | West Virginia | 54023 | 1015 | 22 |
1007929 | 1007929 | 2021-02-07 | Grant | West Virginia | 54023 | 1015 | 22 |
1011175 | 1011175 | 2021-02-08 | Grant | West Virginia | 54023 | 1019 | 22 |
1014420 | 1014420 | 2021-02-09 | Grant | West Virginia | 54023 | 1020 | 22 |
1017665 | 1017665 | 2021-02-10 | Grant | West Virginia | 54023 | 1020 | 22 |
1020910 | 1020910 | 2021-02-11 | Grant | West Virginia | 54023 | 1021 | 22 |
1024155 | 1024155 | 2021-02-12 | Grant | West Virginia | 54023 | 1027 | 22 |
1027400 | 1027400 | 2021-02-13 | Grant | West Virginia | 54023 | 1031 | 22 |
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);