ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11,402 rows where county = "Grant" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 15
- Washington 212
- Arkansas 205
- Indiana 204
- Oregon 204
- Louisiana 201
- Wisconsin 200
- Kentucky 196
- North Dakota 193
- New Mexico 192
- Oklahoma 190
- West Virginia 182
- Kansas 169
- Minnesota 161
- South Dakota 158
- Nebraska 24
fips 15
county 1
- Grant · 2,691 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
617905 | 617905 | 2020-10-10 | Grant | South Dakota | 46051 | 213 | 2 |
618488 | 618488 | 2020-10-10 | Grant | Washington | 53025 | 3252 | 22 |
618527 | 618527 | 2020-10-10 | Grant | West Virginia | 54023 | 172 | 7 |
618592 | 618592 | 2020-10-10 | Grant | Wisconsin | 55043 | 1438 | 19 |
612319 | 612319 | 2020-10-09 | Grant | Arkansas | 5053 | 297 | 2 |
612911 | 612911 | 2020-10-09 | Grant | Indiana | 18053 | 1450 | 40 |
613110 | 613110 | 2020-10-09 | Grant | Kansas | 20067 | 343 | 7 |
613222 | 613222 | 2020-10-09 | Grant | Kentucky | 21081 | 198 | 6 |
613323 | 613323 | 2020-10-09 | Grant | Louisiana | 22043 | 504 | 30 |
613533 | 613533 | 2020-10-09 | Grant | Minnesota | 27051 | 71 | 4 |
613888 | 613888 | 2020-10-09 | Grant | Nebraska | 31075 | 2 | 0 |
614002 | 614002 | 2020-10-09 | Grant | New Mexico | 35017 | 140 | 2 |
614202 | 614202 | 2020-10-09 | Grant | North Dakota | 38037 | 44 | 1 |
614354 | 614354 | 2020-10-09 | Grant | Oklahoma | 40053 | 60 | 1 |
614417 | 614417 | 2020-10-09 | Grant | Oregon | 41023 | 10 | 0 |
614663 | 614663 | 2020-10-09 | Grant | South Dakota | 46051 | 206 | 2 |
615246 | 615246 | 2020-10-09 | Grant | Washington | 53025 | 3252 | 22 |
615285 | 615285 | 2020-10-09 | Grant | West Virginia | 54023 | 169 | 7 |
615350 | 615350 | 2020-10-09 | Grant | Wisconsin | 55043 | 1376 | 19 |
609077 | 609077 | 2020-10-08 | Grant | Arkansas | 5053 | 292 | 2 |
609669 | 609669 | 2020-10-08 | Grant | Indiana | 18053 | 1429 | 40 |
609868 | 609868 | 2020-10-08 | Grant | Kansas | 20067 | 343 | 7 |
609980 | 609980 | 2020-10-08 | Grant | Kentucky | 21081 | 195 | 6 |
610081 | 610081 | 2020-10-08 | Grant | Louisiana | 22043 | 503 | 30 |
610291 | 610291 | 2020-10-08 | Grant | Minnesota | 27051 | 71 | 4 |
610646 | 610646 | 2020-10-08 | Grant | Nebraska | 31075 | 2 | 0 |
610761 | 610761 | 2020-10-08 | Grant | New Mexico | 35017 | 136 | 2 |
610961 | 610961 | 2020-10-08 | Grant | North Dakota | 38037 | 43 | 1 |
611113 | 611113 | 2020-10-08 | Grant | Oklahoma | 40053 | 58 | 1 |
611176 | 611176 | 2020-10-08 | Grant | Oregon | 41023 | 10 | 0 |
611422 | 611422 | 2020-10-08 | Grant | South Dakota | 46051 | 197 | 1 |
612005 | 612005 | 2020-10-08 | Grant | Washington | 53025 | 3238 | 22 |
612044 | 612044 | 2020-10-08 | Grant | West Virginia | 54023 | 165 | 7 |
612109 | 612109 | 2020-10-08 | Grant | Wisconsin | 55043 | 1353 | 19 |
605834 | 605834 | 2020-10-07 | Grant | Arkansas | 5053 | 284 | 2 |
606426 | 606426 | 2020-10-07 | Grant | Indiana | 18053 | 1415 | 40 |
606625 | 606625 | 2020-10-07 | Grant | Kansas | 20067 | 336 | 7 |
606738 | 606738 | 2020-10-07 | Grant | Kentucky | 21081 | 194 | 6 |
606839 | 606839 | 2020-10-07 | Grant | Louisiana | 22043 | 502 | 30 |
607049 | 607049 | 2020-10-07 | Grant | Minnesota | 27051 | 71 | 4 |
607404 | 607404 | 2020-10-07 | Grant | Nebraska | 31075 | 1 | 0 |
607519 | 607519 | 2020-10-07 | Grant | New Mexico | 35017 | 134 | 2 |
607719 | 607719 | 2020-10-07 | Grant | North Dakota | 38037 | 43 | 1 |
607871 | 607871 | 2020-10-07 | Grant | Oklahoma | 40053 | 55 | 1 |
607934 | 607934 | 2020-10-07 | Grant | Oregon | 41023 | 10 | 0 |
608180 | 608180 | 2020-10-07 | Grant | South Dakota | 46051 | 194 | 1 |
608763 | 608763 | 2020-10-07 | Grant | Washington | 53025 | 3215 | 22 |
608802 | 608802 | 2020-10-07 | Grant | West Virginia | 54023 | 163 | 7 |
608867 | 608867 | 2020-10-07 | Grant | Wisconsin | 55043 | 1320 | 19 |
602592 | 602592 | 2020-10-06 | Grant | Arkansas | 5053 | 282 | 2 |
603184 | 603184 | 2020-10-06 | Grant | Indiana | 18053 | 1405 | 40 |
603383 | 603383 | 2020-10-06 | Grant | Kansas | 20067 | 334 | 7 |
603496 | 603496 | 2020-10-06 | Grant | Kentucky | 21081 | 192 | 6 |
603597 | 603597 | 2020-10-06 | Grant | Louisiana | 22043 | 502 | 30 |
603806 | 603806 | 2020-10-06 | Grant | Minnesota | 27051 | 70 | 4 |
604161 | 604161 | 2020-10-06 | Grant | Nebraska | 31075 | 2 | 0 |
604276 | 604276 | 2020-10-06 | Grant | New Mexico | 35017 | 132 | 2 |
604476 | 604476 | 2020-10-06 | Grant | North Dakota | 38037 | 41 | 1 |
604628 | 604628 | 2020-10-06 | Grant | Oklahoma | 40053 | 55 | 1 |
604691 | 604691 | 2020-10-06 | Grant | Oregon | 41023 | 10 | 0 |
604937 | 604937 | 2020-10-06 | Grant | South Dakota | 46051 | 188 | 1 |
605520 | 605520 | 2020-10-06 | Grant | Washington | 53025 | 3191 | 22 |
605559 | 605559 | 2020-10-06 | Grant | West Virginia | 54023 | 163 | 7 |
605624 | 605624 | 2020-10-06 | Grant | Wisconsin | 55043 | 1290 | 19 |
599349 | 599349 | 2020-10-05 | Grant | Arkansas | 5053 | 278 | 2 |
599941 | 599941 | 2020-10-05 | Grant | Indiana | 18053 | 1376 | 40 |
600140 | 600140 | 2020-10-05 | Grant | Kansas | 20067 | 331 | 6 |
600253 | 600253 | 2020-10-05 | Grant | Kentucky | 21081 | 189 | 6 |
600354 | 600354 | 2020-10-05 | Grant | Louisiana | 22043 | 502 | 30 |
600564 | 600564 | 2020-10-05 | Grant | Minnesota | 27051 | 70 | 4 |
600919 | 600919 | 2020-10-05 | Grant | Nebraska | 31075 | 2 | 0 |
601034 | 601034 | 2020-10-05 | Grant | New Mexico | 35017 | 131 | 2 |
601234 | 601234 | 2020-10-05 | Grant | North Dakota | 38037 | 40 | 1 |
601386 | 601386 | 2020-10-05 | Grant | Oklahoma | 40053 | 55 | 1 |
601449 | 601449 | 2020-10-05 | Grant | Oregon | 41023 | 10 | 0 |
601695 | 601695 | 2020-10-05 | Grant | South Dakota | 46051 | 185 | 1 |
602278 | 602278 | 2020-10-05 | Grant | Washington | 53025 | 3173 | 22 |
602317 | 602317 | 2020-10-05 | Grant | West Virginia | 54023 | 163 | 7 |
602382 | 602382 | 2020-10-05 | Grant | Wisconsin | 55043 | 1269 | 19 |
596106 | 596106 | 2020-10-04 | Grant | Arkansas | 5053 | 277 | 2 |
596699 | 596699 | 2020-10-04 | Grant | Indiana | 18053 | 1367 | 40 |
596898 | 596898 | 2020-10-04 | Grant | Kansas | 20067 | 321 | 5 |
597011 | 597011 | 2020-10-04 | Grant | Kentucky | 21081 | 185 | 6 |
597112 | 597112 | 2020-10-04 | Grant | Louisiana | 22043 | 500 | 30 |
597321 | 597321 | 2020-10-04 | Grant | Minnesota | 27051 | 69 | 4 |
597675 | 597675 | 2020-10-04 | Grant | Nebraska | 31075 | 2 | 0 |
597790 | 597790 | 2020-10-04 | Grant | New Mexico | 35017 | 131 | 2 |
597991 | 597991 | 2020-10-04 | Grant | North Dakota | 38037 | 37 | 1 |
598143 | 598143 | 2020-10-04 | Grant | Oklahoma | 40053 | 55 | 1 |
598206 | 598206 | 2020-10-04 | Grant | Oregon | 41023 | 10 | 0 |
598452 | 598452 | 2020-10-04 | Grant | South Dakota | 46051 | 180 | 1 |
599035 | 599035 | 2020-10-04 | Grant | Washington | 53025 | 3131 | 21 |
599074 | 599074 | 2020-10-04 | Grant | West Virginia | 54023 | 163 | 7 |
599139 | 599139 | 2020-10-04 | Grant | Wisconsin | 55043 | 1250 | 19 |
592864 | 592864 | 2020-10-03 | Grant | Arkansas | 5053 | 276 | 2 |
593457 | 593457 | 2020-10-03 | Grant | Indiana | 18053 | 1365 | 40 |
593656 | 593656 | 2020-10-03 | Grant | Kansas | 20067 | 321 | 5 |
593769 | 593769 | 2020-10-03 | Grant | Kentucky | 21081 | 184 | 6 |
593870 | 593870 | 2020-10-03 | Grant | Louisiana | 22043 | 495 | 30 |
594080 | 594080 | 2020-10-03 | Grant | Minnesota | 27051 | 66 | 4 |
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);