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 218
- Arkansas 211
- Indiana 211
- Oregon 211
- Louisiana 208
- Wisconsin 206
- Kentucky 203
- North Dakota 200
- New Mexico 199
- Oklahoma 197
- West Virginia 188
- Kansas 176
- Minnesota 168
- South Dakota 164
- Nebraska 31
fips 15
county 1
- Grant · 2,791 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635613 | 635613 | 2020-10-16 | Grant | Indiana | 18053 | 1536 | 42 |
635812 | 635812 | 2020-10-16 | Grant | Kansas | 20067 | 389 | 8 |
635925 | 635925 | 2020-10-16 | Grant | Kentucky | 21081 | 214 | 6 |
636026 | 636026 | 2020-10-16 | Grant | Louisiana | 22043 | 512 | 30 |
636236 | 636236 | 2020-10-16 | Grant | Minnesota | 27051 | 84 | 4 |
636591 | 636591 | 2020-10-16 | Grant | Nebraska | 31075 | 2 | 0 |
636706 | 636706 | 2020-10-16 | Grant | New Mexico | 35017 | 159 | 2 |
636906 | 636906 | 2020-10-16 | Grant | North Dakota | 38037 | 55 | 1 |
637058 | 637058 | 2020-10-16 | Grant | Oklahoma | 40053 | 74 | 1 |
637121 | 637121 | 2020-10-16 | Grant | Oregon | 41023 | 10 | 0 |
637368 | 637368 | 2020-10-16 | Grant | South Dakota | 46051 | 244 | 2 |
637951 | 637951 | 2020-10-16 | Grant | Washington | 53025 | 3412 | 23 |
637990 | 637990 | 2020-10-16 | Grant | West Virginia | 54023 | 177 | 7 |
638055 | 638055 | 2020-10-16 | Grant | Wisconsin | 55043 | 1610 | 23 |
631775 | 631775 | 2020-10-15 | Grant | Arkansas | 5053 | 329 | 4 |
632367 | 632367 | 2020-10-15 | Grant | Indiana | 18053 | 1511 | 42 |
632566 | 632566 | 2020-10-15 | Grant | Kansas | 20067 | 379 | 8 |
632679 | 632679 | 2020-10-15 | Grant | Kentucky | 21081 | 213 | 6 |
632780 | 632780 | 2020-10-15 | Grant | Louisiana | 22043 | 514 | 30 |
632990 | 632990 | 2020-10-15 | Grant | Minnesota | 27051 | 81 | 4 |
633345 | 633345 | 2020-10-15 | Grant | Nebraska | 31075 | 2 | 0 |
633460 | 633460 | 2020-10-15 | Grant | New Mexico | 35017 | 156 | 2 |
633660 | 633660 | 2020-10-15 | Grant | North Dakota | 38037 | 54 | 1 |
633812 | 633812 | 2020-10-15 | Grant | Oklahoma | 40053 | 72 | 1 |
633875 | 633875 | 2020-10-15 | Grant | Oregon | 41023 | 10 | 0 |
634122 | 634122 | 2020-10-15 | Grant | South Dakota | 46051 | 237 | 2 |
634706 | 634706 | 2020-10-15 | Grant | Washington | 53025 | 3381 | 23 |
634745 | 634745 | 2020-10-15 | Grant | West Virginia | 54023 | 177 | 7 |
634810 | 634810 | 2020-10-15 | Grant | Wisconsin | 55043 | 1592 | 23 |
628531 | 628531 | 2020-10-14 | Grant | Arkansas | 5053 | 324 | 4 |
629123 | 629123 | 2020-10-14 | Grant | Indiana | 18053 | 1499 | 41 |
629322 | 629322 | 2020-10-14 | Grant | Kansas | 20067 | 379 | 8 |
629435 | 629435 | 2020-10-14 | Grant | Kentucky | 21081 | 209 | 6 |
629536 | 629536 | 2020-10-14 | Grant | Louisiana | 22043 | 512 | 30 |
629745 | 629745 | 2020-10-14 | Grant | Minnesota | 27051 | 81 | 4 |
630100 | 630100 | 2020-10-14 | Grant | Nebraska | 31075 | 2 | 0 |
630215 | 630215 | 2020-10-14 | Grant | New Mexico | 35017 | 151 | 2 |
630415 | 630415 | 2020-10-14 | Grant | North Dakota | 38037 | 53 | 1 |
630567 | 630567 | 2020-10-14 | Grant | Oklahoma | 40053 | 70 | 1 |
630630 | 630630 | 2020-10-14 | Grant | Oregon | 41023 | 10 | 0 |
630877 | 630877 | 2020-10-14 | Grant | South Dakota | 46051 | 228 | 2 |
631461 | 631461 | 2020-10-14 | Grant | Washington | 53025 | 3345 | 23 |
631500 | 631500 | 2020-10-14 | Grant | West Virginia | 54023 | 177 | 7 |
631565 | 631565 | 2020-10-14 | Grant | Wisconsin | 55043 | 1535 | 23 |
625288 | 625288 | 2020-10-13 | Grant | Arkansas | 5053 | 313 | 4 |
625880 | 625880 | 2020-10-13 | Grant | Indiana | 18053 | 1494 | 41 |
626079 | 626079 | 2020-10-13 | Grant | Kansas | 20067 | 371 | 8 |
626191 | 626191 | 2020-10-13 | Grant | Kentucky | 21081 | 205 | 6 |
626292 | 626292 | 2020-10-13 | Grant | Louisiana | 22043 | 512 | 30 |
626501 | 626501 | 2020-10-13 | Grant | Minnesota | 27051 | 82 | 4 |
626856 | 626856 | 2020-10-13 | Grant | Nebraska | 31075 | 2 | 0 |
626971 | 626971 | 2020-10-13 | Grant | New Mexico | 35017 | 147 | 2 |
627171 | 627171 | 2020-10-13 | Grant | North Dakota | 38037 | 50 | 1 |
627323 | 627323 | 2020-10-13 | Grant | Oklahoma | 40053 | 68 | 1 |
627386 | 627386 | 2020-10-13 | Grant | Oregon | 41023 | 10 | 0 |
627633 | 627633 | 2020-10-13 | Grant | South Dakota | 46051 | 224 | 2 |
628217 | 628217 | 2020-10-13 | Grant | Washington | 53025 | 3325 | 23 |
628256 | 628256 | 2020-10-13 | Grant | West Virginia | 54023 | 176 | 7 |
628321 | 628321 | 2020-10-13 | Grant | Wisconsin | 55043 | 1503 | 20 |
622045 | 622045 | 2020-10-12 | Grant | Arkansas | 5053 | 307 | 3 |
622638 | 622638 | 2020-10-12 | Grant | Indiana | 18053 | 1478 | 40 |
622837 | 622837 | 2020-10-12 | Grant | Kansas | 20067 | 352 | 7 |
622949 | 622949 | 2020-10-12 | Grant | Kentucky | 21081 | 204 | 6 |
623050 | 623050 | 2020-10-12 | Grant | Louisiana | 22043 | 510 | 30 |
623259 | 623259 | 2020-10-12 | Grant | Minnesota | 27051 | 80 | 4 |
623614 | 623614 | 2020-10-12 | Grant | Nebraska | 31075 | 2 | 0 |
623729 | 623729 | 2020-10-12 | Grant | New Mexico | 35017 | 146 | 2 |
623929 | 623929 | 2020-10-12 | Grant | North Dakota | 38037 | 50 | 1 |
624081 | 624081 | 2020-10-12 | Grant | Oklahoma | 40053 | 67 | 1 |
624144 | 624144 | 2020-10-12 | Grant | Oregon | 41023 | 10 | 0 |
624391 | 624391 | 2020-10-12 | Grant | South Dakota | 46051 | 222 | 2 |
624974 | 624974 | 2020-10-12 | Grant | Washington | 53025 | 3308 | 23 |
625013 | 625013 | 2020-10-12 | Grant | West Virginia | 54023 | 174 | 7 |
625078 | 625078 | 2020-10-12 | Grant | Wisconsin | 55043 | 1472 | 19 |
618802 | 618802 | 2020-10-11 | Grant | Arkansas | 5053 | 305 | 3 |
619394 | 619394 | 2020-10-11 | Grant | Indiana | 18053 | 1467 | 40 |
619593 | 619593 | 2020-10-11 | Grant | Kansas | 20067 | 352 | 7 |
619705 | 619705 | 2020-10-11 | Grant | Kentucky | 21081 | 204 | 6 |
619806 | 619806 | 2020-10-11 | Grant | Louisiana | 22043 | 509 | 30 |
620016 | 620016 | 2020-10-11 | Grant | Minnesota | 27051 | 78 | 4 |
620371 | 620371 | 2020-10-11 | Grant | Nebraska | 31075 | 2 | 0 |
620486 | 620486 | 2020-10-11 | Grant | New Mexico | 35017 | 146 | 2 |
620686 | 620686 | 2020-10-11 | Grant | North Dakota | 38037 | 50 | 1 |
620838 | 620838 | 2020-10-11 | Grant | Oklahoma | 40053 | 65 | 1 |
620901 | 620901 | 2020-10-11 | Grant | Oregon | 41023 | 10 | 0 |
621148 | 621148 | 2020-10-11 | Grant | South Dakota | 46051 | 217 | 2 |
621731 | 621731 | 2020-10-11 | Grant | Washington | 53025 | 3252 | 22 |
621770 | 621770 | 2020-10-11 | Grant | West Virginia | 54023 | 174 | 7 |
621835 | 621835 | 2020-10-11 | Grant | Wisconsin | 55043 | 1453 | 19 |
615560 | 615560 | 2020-10-10 | Grant | Arkansas | 5053 | 303 | 2 |
616152 | 616152 | 2020-10-10 | Grant | Indiana | 18053 | 1457 | 40 |
616351 | 616351 | 2020-10-10 | Grant | Kansas | 20067 | 343 | 7 |
616463 | 616463 | 2020-10-10 | Grant | Kentucky | 21081 | 200 | 6 |
616564 | 616564 | 2020-10-10 | Grant | Louisiana | 22043 | 504 | 30 |
616774 | 616774 | 2020-10-10 | Grant | Minnesota | 27051 | 74 | 4 |
617129 | 617129 | 2020-10-10 | Grant | Nebraska | 31075 | 2 | 0 |
617244 | 617244 | 2020-10-10 | Grant | New Mexico | 35017 | 143 | 2 |
617444 | 617444 | 2020-10-10 | Grant | North Dakota | 38037 | 47 | 1 |
617596 | 617596 | 2020-10-10 | Grant | Oklahoma | 40053 | 63 | 1 |
617659 | 617659 | 2020-10-10 | Grant | Oregon | 41023 | 10 | 0 |
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);