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 14
- Washington 108
- Arkansas 102
- Indiana 101
- Oregon 101
- Louisiana 98
- Wisconsin 96
- Kentucky 93
- North Dakota 90
- New Mexico 89
- Oklahoma 87
- West Virginia 78
- Kansas 66
- Minnesota 58
- South Dakota 54
fips 14
county 1
- Grant · 1,221 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280919 | 280919 | 2020-06-28 | Grant | Arkansas | 5053 | 34 | 0 |
281501 | 281501 | 2020-06-28 | Grant | Indiana | 18053 | 373 | 29 |
281698 | 281698 | 2020-06-28 | Grant | Kansas | 20067 | 40 | 1 |
281802 | 281802 | 2020-06-28 | Grant | Kentucky | 21081 | 57 | 4 |
281902 | 281902 | 2020-06-28 | Grant | Louisiana | 22043 | 82 | 1 |
282111 | 282111 | 2020-06-28 | Grant | Minnesota | 27051 | 6 | 0 |
282543 | 282543 | 2020-06-28 | Grant | New Mexico | 35017 | 18 | 0 |
282740 | 282740 | 2020-06-28 | Grant | North Dakota | 38037 | 3 | 0 |
282889 | 282889 | 2020-06-28 | Grant | Oklahoma | 40053 | 2 | 0 |
282948 | 282948 | 2020-06-28 | Grant | Oregon | 41023 | 1 | 0 |
283192 | 283192 | 2020-06-28 | Grant | South Dakota | 46051 | 13 | 0 |
283758 | 283758 | 2020-06-28 | Grant | Washington | 53025 | 577 | 5 |
283795 | 283795 | 2020-06-28 | Grant | West Virginia | 54023 | 16 | 0 |
283859 | 283859 | 2020-06-28 | Grant | Wisconsin | 55043 | 150 | 13 |
277772 | 277772 | 2020-06-27 | Grant | Arkansas | 5053 | 34 | 0 |
278353 | 278353 | 2020-06-27 | Grant | Indiana | 18053 | 368 | 29 |
278550 | 278550 | 2020-06-27 | Grant | Kansas | 20067 | 40 | 1 |
278654 | 278654 | 2020-06-27 | Grant | Kentucky | 21081 | 57 | 4 |
278754 | 278754 | 2020-06-27 | Grant | Louisiana | 22043 | 82 | 1 |
278963 | 278963 | 2020-06-27 | Grant | Minnesota | 27051 | 6 | 0 |
279396 | 279396 | 2020-06-27 | Grant | New Mexico | 35017 | 18 | 0 |
279594 | 279594 | 2020-06-27 | Grant | North Dakota | 38037 | 2 | 0 |
279743 | 279743 | 2020-06-27 | Grant | Oklahoma | 40053 | 2 | 0 |
279802 | 279802 | 2020-06-27 | Grant | Oregon | 41023 | 1 | 0 |
280046 | 280046 | 2020-06-27 | Grant | South Dakota | 46051 | 13 | 0 |
280612 | 280612 | 2020-06-27 | Grant | Washington | 53025 | 577 | 5 |
280649 | 280649 | 2020-06-27 | Grant | West Virginia | 54023 | 16 | 0 |
280713 | 280713 | 2020-06-27 | Grant | Wisconsin | 55043 | 145 | 13 |
274624 | 274624 | 2020-06-26 | Grant | Arkansas | 5053 | 33 | 0 |
275205 | 275205 | 2020-06-26 | Grant | Indiana | 18053 | 371 | 29 |
275402 | 275402 | 2020-06-26 | Grant | Kansas | 20067 | 40 | 1 |
275506 | 275506 | 2020-06-26 | Grant | Kentucky | 21081 | 57 | 4 |
275606 | 275606 | 2020-06-26 | Grant | Louisiana | 22043 | 82 | 1 |
275815 | 275815 | 2020-06-26 | Grant | Minnesota | 27051 | 6 | 0 |
276248 | 276248 | 2020-06-26 | Grant | New Mexico | 35017 | 17 | 0 |
276446 | 276446 | 2020-06-26 | Grant | North Dakota | 38037 | 2 | 0 |
276595 | 276595 | 2020-06-26 | Grant | Oklahoma | 40053 | 2 | 0 |
276654 | 276654 | 2020-06-26 | Grant | Oregon | 41023 | 1 | 0 |
276898 | 276898 | 2020-06-26 | Grant | South Dakota | 46051 | 13 | 0 |
277464 | 277464 | 2020-06-26 | Grant | Washington | 53025 | 564 | 5 |
277501 | 277501 | 2020-06-26 | Grant | West Virginia | 54023 | 16 | 0 |
277565 | 277565 | 2020-06-26 | Grant | Wisconsin | 55043 | 141 | 12 |
271484 | 271484 | 2020-06-25 | Grant | Arkansas | 5053 | 30 | 0 |
272063 | 272063 | 2020-06-25 | Grant | Indiana | 18053 | 364 | 29 |
272259 | 272259 | 2020-06-25 | Grant | Kansas | 20067 | 37 | 1 |
272363 | 272363 | 2020-06-25 | Grant | Kentucky | 21081 | 57 | 4 |
272463 | 272463 | 2020-06-25 | Grant | Louisiana | 22043 | 81 | 1 |
272672 | 272672 | 2020-06-25 | Grant | Minnesota | 27051 | 6 | 0 |
273103 | 273103 | 2020-06-25 | Grant | New Mexico | 35017 | 17 | 0 |
273300 | 273300 | 2020-06-25 | Grant | North Dakota | 38037 | 2 | 0 |
273448 | 273448 | 2020-06-25 | Grant | Oklahoma | 40053 | 2 | 0 |
273507 | 273507 | 2020-06-25 | Grant | Oregon | 41023 | 1 | 0 |
273751 | 273751 | 2020-06-25 | Grant | South Dakota | 46051 | 13 | 0 |
274316 | 274316 | 2020-06-25 | Grant | Washington | 53025 | 513 | 5 |
274353 | 274353 | 2020-06-25 | Grant | West Virginia | 54023 | 16 | 0 |
274417 | 274417 | 2020-06-25 | Grant | Wisconsin | 55043 | 136 | 12 |
268349 | 268349 | 2020-06-24 | Grant | Arkansas | 5053 | 28 | 0 |
268926 | 268926 | 2020-06-24 | Grant | Indiana | 18053 | 364 | 29 |
269122 | 269122 | 2020-06-24 | Grant | Kansas | 20067 | 37 | 1 |
269227 | 269227 | 2020-06-24 | Grant | Kentucky | 21081 | 55 | 4 |
269327 | 269327 | 2020-06-24 | Grant | Louisiana | 22043 | 81 | 1 |
269535 | 269535 | 2020-06-24 | Grant | Minnesota | 27051 | 6 | 0 |
269964 | 269964 | 2020-06-24 | Grant | New Mexico | 35017 | 17 | 0 |
270161 | 270161 | 2020-06-24 | Grant | North Dakota | 38037 | 2 | 0 |
270309 | 270309 | 2020-06-24 | Grant | Oklahoma | 40053 | 2 | 0 |
270368 | 270368 | 2020-06-24 | Grant | Oregon | 41023 | 1 | 0 |
270612 | 270612 | 2020-06-24 | Grant | South Dakota | 46051 | 13 | 0 |
271176 | 271176 | 2020-06-24 | Grant | Washington | 53025 | 478 | 5 |
271213 | 271213 | 2020-06-24 | Grant | West Virginia | 54023 | 16 | 0 |
271277 | 271277 | 2020-06-24 | Grant | Wisconsin | 55043 | 134 | 12 |
265219 | 265219 | 2020-06-23 | Grant | Arkansas | 5053 | 28 | 0 |
265796 | 265796 | 2020-06-23 | Grant | Indiana | 18053 | 361 | 29 |
265992 | 265992 | 2020-06-23 | Grant | Kansas | 20067 | 24 | 1 |
266094 | 266094 | 2020-06-23 | Grant | Kentucky | 21081 | 54 | 4 |
266194 | 266194 | 2020-06-23 | Grant | Louisiana | 22043 | 78 | 1 |
266402 | 266402 | 2020-06-23 | Grant | Minnesota | 27051 | 6 | 0 |
266829 | 266829 | 2020-06-23 | Grant | New Mexico | 35017 | 17 | 0 |
267027 | 267027 | 2020-06-23 | Grant | North Dakota | 38037 | 2 | 0 |
267175 | 267175 | 2020-06-23 | Grant | Oklahoma | 40053 | 2 | 0 |
267234 | 267234 | 2020-06-23 | Grant | Oregon | 41023 | 1 | 0 |
267478 | 267478 | 2020-06-23 | Grant | South Dakota | 46051 | 13 | 0 |
268042 | 268042 | 2020-06-23 | Grant | Washington | 53025 | 470 | 5 |
268079 | 268079 | 2020-06-23 | Grant | West Virginia | 54023 | 16 | 0 |
268143 | 268143 | 2020-06-23 | Grant | Wisconsin | 55043 | 130 | 12 |
262091 | 262091 | 2020-06-22 | Grant | Arkansas | 5053 | 27 | 0 |
262668 | 262668 | 2020-06-22 | Grant | Indiana | 18053 | 354 | 29 |
262864 | 262864 | 2020-06-22 | Grant | Kansas | 20067 | 24 | 1 |
262967 | 262967 | 2020-06-22 | Grant | Kentucky | 21081 | 53 | 4 |
263067 | 263067 | 2020-06-22 | Grant | Louisiana | 22043 | 76 | 1 |
263276 | 263276 | 2020-06-22 | Grant | Minnesota | 27051 | 6 | 0 |
263702 | 263702 | 2020-06-22 | Grant | New Mexico | 35017 | 17 | 0 |
263899 | 263899 | 2020-06-22 | Grant | North Dakota | 38037 | 2 | 0 |
264047 | 264047 | 2020-06-22 | Grant | Oklahoma | 40053 | 2 | 0 |
264106 | 264106 | 2020-06-22 | Grant | Oregon | 41023 | 1 | 0 |
264350 | 264350 | 2020-06-22 | Grant | South Dakota | 46051 | 13 | 0 |
264913 | 264913 | 2020-06-22 | Grant | Washington | 53025 | 470 | 4 |
264950 | 264950 | 2020-06-22 | Grant | West Virginia | 54023 | 16 | 0 |
265014 | 265014 | 2020-06-22 | Grant | Wisconsin | 55043 | 129 | 12 |
258964 | 258964 | 2020-06-21 | Grant | Arkansas | 5053 | 26 | 0 |
259541 | 259541 | 2020-06-21 | Grant | Indiana | 18053 | 354 | 28 |
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);