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 786
- Arkansas 779
- Oregon 779
- Indiana 778
- Louisiana 775
- Wisconsin 774
- Kentucky 770
- North Dakota 767
- New Mexico 766
- Oklahoma 764
- West Virginia 756
- Kansas 743
- Minnesota 735
- South Dakota 732
- Nebraska 598
fips 15
county 1
- Grant · 11,302 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482275 | 2482275 | 2022-05-07 | Grant | Oregon | 41023 | 1701 | 21 |
2482522 | 2482522 | 2022-05-07 | Grant | South Dakota | 46051 | 2044 | 51 |
2483108 | 2483108 | 2022-05-07 | Grant | Washington | 53025 | 27146 | 259 |
2483147 | 2483147 | 2022-05-07 | Grant | West Virginia | 54023 | 3787 | 56 |
2483212 | 2483212 | 2022-05-07 | Grant | Wisconsin | 55043 | 12863 | 145 |
2476907 | 2476907 | 2022-05-06 | Grant | Arkansas | 5053 | 4464 | 61 |
2477501 | 2477501 | 2022-05-06 | Grant | Indiana | 18053 | 17352 | 352 |
2477701 | 2477701 | 2022-05-06 | Grant | Kansas | 20067 | 2263 | 36 |
2477814 | 2477814 | 2022-05-06 | Grant | Kentucky | 21081 | 7814 | 62 |
2477915 | 2477915 | 2022-05-06 | Grant | Louisiana | 22043 | 5858 | 94 |
2478125 | 2478125 | 2022-05-06 | Grant | Minnesota | 27051 | 1495 | 12 |
2478481 | 2478481 | 2022-05-06 | Grant | Nebraska | 31075 | 104 | 5 |
2478598 | 2478598 | 2022-05-06 | Grant | New Mexico | 35017 | 6698 | 90 |
2478799 | 2478799 | 2022-05-06 | Grant | North Dakota | 38037 | 451 | 11 |
2478954 | 2478954 | 2022-05-06 | Grant | Oklahoma | 40053 | 1035 | 16 |
2479017 | 2479017 | 2022-05-06 | Grant | Oregon | 41023 | 1701 | 21 |
2479264 | 2479264 | 2022-05-06 | Grant | South Dakota | 46051 | 2044 | 51 |
2479850 | 2479850 | 2022-05-06 | Grant | Washington | 53025 | 27146 | 259 |
2479889 | 2479889 | 2022-05-06 | Grant | West Virginia | 54023 | 3787 | 56 |
2479954 | 2479954 | 2022-05-06 | Grant | Wisconsin | 55043 | 12863 | 145 |
2473649 | 2473649 | 2022-05-05 | Grant | Arkansas | 5053 | 4464 | 61 |
2474243 | 2474243 | 2022-05-05 | Grant | Indiana | 18053 | 17352 | 352 |
2474443 | 2474443 | 2022-05-05 | Grant | Kansas | 20067 | 2263 | 36 |
2474556 | 2474556 | 2022-05-05 | Grant | Kentucky | 21081 | 7802 | 61 |
2474657 | 2474657 | 2022-05-05 | Grant | Louisiana | 22043 | 5858 | 94 |
2474867 | 2474867 | 2022-05-05 | Grant | Minnesota | 27051 | 1493 | 12 |
2475223 | 2475223 | 2022-05-05 | Grant | Nebraska | 31075 | 104 | 5 |
2475340 | 2475340 | 2022-05-05 | Grant | New Mexico | 35017 | 6694 | 90 |
2475541 | 2475541 | 2022-05-05 | Grant | North Dakota | 38037 | 451 | 11 |
2475696 | 2475696 | 2022-05-05 | Grant | Oklahoma | 40053 | 1035 | 16 |
2475759 | 2475759 | 2022-05-05 | Grant | Oregon | 41023 | 1701 | 21 |
2476006 | 2476006 | 2022-05-05 | Grant | South Dakota | 46051 | 2044 | 51 |
2476592 | 2476592 | 2022-05-05 | Grant | Washington | 53025 | 27146 | 259 |
2476631 | 2476631 | 2022-05-05 | Grant | West Virginia | 54023 | 3785 | 56 |
2476696 | 2476696 | 2022-05-05 | Grant | Wisconsin | 55043 | 12851 | 145 |
2470392 | 2470392 | 2022-05-04 | Grant | Arkansas | 5053 | 4464 | 61 |
2470986 | 2470986 | 2022-05-04 | Grant | Indiana | 18053 | 17352 | 352 |
2471186 | 2471186 | 2022-05-04 | Grant | Kansas | 20067 | 2263 | 36 |
2471299 | 2471299 | 2022-05-04 | Grant | Kentucky | 21081 | 7802 | 61 |
2471400 | 2471400 | 2022-05-04 | Grant | Louisiana | 22043 | 5858 | 94 |
2471610 | 2471610 | 2022-05-04 | Grant | Minnesota | 27051 | 1487 | 12 |
2471966 | 2471966 | 2022-05-04 | Grant | Nebraska | 31075 | 104 | 5 |
2472083 | 2472083 | 2022-05-04 | Grant | New Mexico | 35017 | 6694 | 89 |
2472284 | 2472284 | 2022-05-04 | Grant | North Dakota | 38037 | 451 | 11 |
2472439 | 2472439 | 2022-05-04 | Grant | Oklahoma | 40053 | 1034 | 16 |
2472502 | 2472502 | 2022-05-04 | Grant | Oregon | 41023 | 1697 | 21 |
2472749 | 2472749 | 2022-05-04 | Grant | South Dakota | 46051 | 2044 | 51 |
2473334 | 2473334 | 2022-05-04 | Grant | Washington | 53025 | 27146 | 259 |
2473373 | 2473373 | 2022-05-04 | Grant | West Virginia | 54023 | 3785 | 56 |
2473438 | 2473438 | 2022-05-04 | Grant | Wisconsin | 55043 | 12840 | 145 |
2467136 | 2467136 | 2022-05-03 | Grant | Arkansas | 5053 | 4464 | 61 |
2467730 | 2467730 | 2022-05-03 | Grant | Indiana | 18053 | 17348 | 351 |
2467930 | 2467930 | 2022-05-03 | Grant | Kansas | 20067 | 2262 | 36 |
2468043 | 2468043 | 2022-05-03 | Grant | Kentucky | 21081 | 7802 | 61 |
2468144 | 2468144 | 2022-05-03 | Grant | Louisiana | 22043 | 5857 | 94 |
2468354 | 2468354 | 2022-05-03 | Grant | Minnesota | 27051 | 1487 | 12 |
2468710 | 2468710 | 2022-05-03 | Grant | Nebraska | 31075 | 106 | 5 |
2468827 | 2468827 | 2022-05-03 | Grant | New Mexico | 35017 | 6688 | 89 |
2469028 | 2469028 | 2022-05-03 | Grant | North Dakota | 38037 | 451 | 11 |
2469183 | 2469183 | 2022-05-03 | Grant | Oklahoma | 40053 | 1034 | 16 |
2469246 | 2469246 | 2022-05-03 | Grant | Oregon | 41023 | 1696 | 21 |
2469493 | 2469493 | 2022-05-03 | Grant | South Dakota | 46051 | 2040 | 51 |
2470078 | 2470078 | 2022-05-03 | Grant | Washington | 53025 | 27123 | 259 |
2470116 | 2470116 | 2022-05-03 | Grant | West Virginia | 54023 | 3785 | 56 |
2470181 | 2470181 | 2022-05-03 | Grant | Wisconsin | 55043 | 12820 | 145 |
2463881 | 2463881 | 2022-05-02 | Grant | Arkansas | 5053 | 4464 | 61 |
2464475 | 2464475 | 2022-05-02 | Grant | Indiana | 18053 | 17348 | 351 |
2464675 | 2464675 | 2022-05-02 | Grant | Kansas | 20067 | 2262 | 36 |
2464788 | 2464788 | 2022-05-02 | Grant | Kentucky | 21081 | 7802 | 61 |
2464889 | 2464889 | 2022-05-02 | Grant | Louisiana | 22043 | 5857 | 94 |
2465099 | 2465099 | 2022-05-02 | Grant | Minnesota | 27051 | 1483 | 12 |
2465454 | 2465454 | 2022-05-02 | Grant | Nebraska | 31075 | 106 | 5 |
2465571 | 2465571 | 2022-05-02 | Grant | New Mexico | 35017 | 6684 | 89 |
2465772 | 2465772 | 2022-05-02 | Grant | North Dakota | 38037 | 451 | 11 |
2465927 | 2465927 | 2022-05-02 | Grant | Oklahoma | 40053 | 1034 | 16 |
2465990 | 2465990 | 2022-05-02 | Grant | Oregon | 41023 | 1697 | 21 |
2466237 | 2466237 | 2022-05-02 | Grant | South Dakota | 46051 | 2040 | 51 |
2466822 | 2466822 | 2022-05-02 | Grant | Washington | 53025 | 27123 | 259 |
2466860 | 2466860 | 2022-05-02 | Grant | West Virginia | 54023 | 3785 | 56 |
2466925 | 2466925 | 2022-05-02 | Grant | Wisconsin | 55043 | 12814 | 145 |
2460625 | 2460625 | 2022-05-01 | Grant | Arkansas | 5053 | 4464 | 61 |
2461219 | 2461219 | 2022-05-01 | Grant | Indiana | 18053 | 17347 | 351 |
2461419 | 2461419 | 2022-05-01 | Grant | Kansas | 20067 | 2261 | 36 |
2461532 | 2461532 | 2022-05-01 | Grant | Kentucky | 21081 | 7802 | 61 |
2461633 | 2461633 | 2022-05-01 | Grant | Louisiana | 22043 | 5857 | 94 |
2461843 | 2461843 | 2022-05-01 | Grant | Minnesota | 27051 | 1481 | 12 |
2462199 | 2462199 | 2022-05-01 | Grant | Nebraska | 31075 | 106 | 5 |
2462316 | 2462316 | 2022-05-01 | Grant | New Mexico | 35017 | 6684 | 88 |
2462517 | 2462517 | 2022-05-01 | Grant | North Dakota | 38037 | 451 | 11 |
2462672 | 2462672 | 2022-05-01 | Grant | Oklahoma | 40053 | 1034 | 16 |
2462735 | 2462735 | 2022-05-01 | Grant | Oregon | 41023 | 1694 | 21 |
2462982 | 2462982 | 2022-05-01 | Grant | South Dakota | 46051 | 2040 | 51 |
2463567 | 2463567 | 2022-05-01 | Grant | Washington | 53025 | 27123 | 259 |
2463605 | 2463605 | 2022-05-01 | Grant | West Virginia | 54023 | 3785 | 56 |
2463670 | 2463670 | 2022-05-01 | Grant | Wisconsin | 55043 | 12789 | 145 |
2457369 | 2457369 | 2022-04-30 | Grant | Arkansas | 5053 | 4464 | 61 |
2457963 | 2457963 | 2022-04-30 | Grant | Indiana | 18053 | 17347 | 351 |
2458163 | 2458163 | 2022-04-30 | Grant | Kansas | 20067 | 2261 | 36 |
2458276 | 2458276 | 2022-04-30 | Grant | Kentucky | 21081 | 7802 | 61 |
2458377 | 2458377 | 2022-04-30 | Grant | Louisiana | 22043 | 5857 | 94 |
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);