ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

11,402 rows where county = "Grant" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 15

county 1

  • Grant · 11,402 ✖
Link rowid date ▲ county state fips cases deaths
2499712 2499712 2022-05-13 Grant Arkansas 5053 4468 61
2500306 2500306 2022-05-13 Grant Indiana 18053 17380 354
2500506 2500506 2022-05-13 Grant Kansas 20067 2265 36
2500619 2500619 2022-05-13 Grant Kentucky 21081 7855 62
2500720 2500720 2022-05-13 Grant Louisiana 22043 5861 94
2500930 2500930 2022-05-13 Grant Minnesota 27051 1506 12
2501286 2501286 2022-05-13 Grant Nebraska 31075 100 5
2501403 2501403 2022-05-13 Grant New Mexico 35017 6748 90
2501604 2501604 2022-05-13 Grant North Dakota 38037 451 11
2501759 2501759 2022-05-13 Grant Oklahoma 40053 1036 16
2501822 2501822 2022-05-13 Grant Oregon 41023 1704 21
2502069 2502069 2022-05-13 Grant South Dakota 46051 2047 51
2502655 2502655 2022-05-13 Grant Washington 53025 27251 259
2502694 2502694 2022-05-13 Grant West Virginia 54023 3786 56
2502759 2502759 2022-05-13 Grant Wisconsin 55043 12945 146
2496454 2496454 2022-05-12 Grant Arkansas 5053 4466 61
2497048 2497048 2022-05-12 Grant Indiana 18053 17369 353
2497248 2497248 2022-05-12 Grant Kansas 20067 2265 36
2497361 2497361 2022-05-12 Grant Kentucky 21081 7814 62
2497462 2497462 2022-05-12 Grant Louisiana 22043 5860 94
2497672 2497672 2022-05-12 Grant Minnesota 27051 1502 12
2498028 2498028 2022-05-12 Grant Nebraska 31075 100 5
2498145 2498145 2022-05-12 Grant New Mexico 35017 6736 90
2498346 2498346 2022-05-12 Grant North Dakota 38037 451 11
2498501 2498501 2022-05-12 Grant Oklahoma 40053 1036 16
2498564 2498564 2022-05-12 Grant Oregon 41023 1704 21
2498811 2498811 2022-05-12 Grant South Dakota 46051 2047 51
2499397 2499397 2022-05-12 Grant Washington 53025 27251 259
2499436 2499436 2022-05-12 Grant West Virginia 54023 3786 56
2499501 2499501 2022-05-12 Grant Wisconsin 55043 12930 146
2493196 2493196 2022-05-11 Grant Arkansas 5053 4467 61
2493790 2493790 2022-05-11 Grant Indiana 18053 17369 353
2493990 2493990 2022-05-11 Grant Kansas 20067 2265 36
2494103 2494103 2022-05-11 Grant Kentucky 21081 7814 62
2494204 2494204 2022-05-11 Grant Louisiana 22043 5859 94
2494414 2494414 2022-05-11 Grant Minnesota 27051 1502 12
2494770 2494770 2022-05-11 Grant Nebraska 31075 100 5
2494887 2494887 2022-05-11 Grant New Mexico 35017 6731 90
2495088 2495088 2022-05-11 Grant North Dakota 38037 451 11
2495243 2495243 2022-05-11 Grant Oklahoma 40053 1035 16
2495306 2495306 2022-05-11 Grant Oregon 41023 1702 21
2495553 2495553 2022-05-11 Grant South Dakota 46051 2047 51
2496139 2496139 2022-05-11 Grant Washington 53025 27146 259
2496178 2496178 2022-05-11 Grant West Virginia 54023 3786 56
2496243 2496243 2022-05-11 Grant Wisconsin 55043 12913 146
2489938 2489938 2022-05-10 Grant Arkansas 5053 4465 61
2490532 2490532 2022-05-10 Grant Indiana 18053 17366 352
2490732 2490732 2022-05-10 Grant Kansas 20067 2265 36
2490845 2490845 2022-05-10 Grant Kentucky 21081 7814 62
2490946 2490946 2022-05-10 Grant Louisiana 22043 5859 94
2491156 2491156 2022-05-10 Grant Minnesota 27051 1500 12
2491512 2491512 2022-05-10 Grant Nebraska 31075 104 5
2491629 2491629 2022-05-10 Grant New Mexico 35017 6718 90
2491830 2491830 2022-05-10 Grant North Dakota 38037 451 11
2491985 2491985 2022-05-10 Grant Oklahoma 40053 1035 16
2492048 2492048 2022-05-10 Grant Oregon 41023 1702 21
2492295 2492295 2022-05-10 Grant South Dakota 46051 2044 51
2492881 2492881 2022-05-10 Grant Washington 53025 27146 259
2492920 2492920 2022-05-10 Grant West Virginia 54023 3786 56
2492985 2492985 2022-05-10 Grant Wisconsin 55043 12896 145
2486681 2486681 2022-05-09 Grant Arkansas 5053 4464 61
2487275 2487275 2022-05-09 Grant Indiana 18053 17366 352
2487475 2487475 2022-05-09 Grant Kansas 20067 2264 36
2487588 2487588 2022-05-09 Grant Kentucky 21081 7814 62
2487689 2487689 2022-05-09 Grant Louisiana 22043 5859 94
2487899 2487899 2022-05-09 Grant Minnesota 27051 1497 12
2488254 2488254 2022-05-09 Grant Nebraska 31075 104 5
2488371 2488371 2022-05-09 Grant New Mexico 35017 6707 90
2488572 2488572 2022-05-09 Grant North Dakota 38037 451 11
2488727 2488727 2022-05-09 Grant Oklahoma 40053 1035 16
2488790 2488790 2022-05-09 Grant Oregon 41023 1701 21
2489037 2489037 2022-05-09 Grant South Dakota 46051 2044 51
2489623 2489623 2022-05-09 Grant Washington 53025 27146 259
2489662 2489662 2022-05-09 Grant West Virginia 54023 3786 56
2489727 2489727 2022-05-09 Grant Wisconsin 55043 12883 145
2483423 2483423 2022-05-08 Grant Arkansas 5053 4464 61
2484017 2484017 2022-05-08 Grant Indiana 18053 17352 352
2484217 2484217 2022-05-08 Grant Kansas 20067 2263 36
2484330 2484330 2022-05-08 Grant Kentucky 21081 7814 62
2484431 2484431 2022-05-08 Grant Louisiana 22043 5858 94
2484641 2484641 2022-05-08 Grant Minnesota 27051 1495 12
2484997 2484997 2022-05-08 Grant Nebraska 31075 104 5
2485114 2485114 2022-05-08 Grant New Mexico 35017 6698 90
2485315 2485315 2022-05-08 Grant North Dakota 38037 451 11
2485470 2485470 2022-05-08 Grant Oklahoma 40053 1035 16
2485533 2485533 2022-05-08 Grant Oregon 41023 1701 21
2485780 2485780 2022-05-08 Grant South Dakota 46051 2044 51
2486366 2486366 2022-05-08 Grant Washington 53025 27146 259
2486405 2486405 2022-05-08 Grant West Virginia 54023 3787 56
2486470 2486470 2022-05-08 Grant Wisconsin 55043 12863 145
2480165 2480165 2022-05-07 Grant Arkansas 5053 4463 61
2480759 2480759 2022-05-07 Grant Indiana 18053 17352 352
2480959 2480959 2022-05-07 Grant Kansas 20067 2263 36
2481072 2481072 2022-05-07 Grant Kentucky 21081 7814 62
2481173 2481173 2022-05-07 Grant Louisiana 22043 5858 94
2481383 2481383 2022-05-07 Grant Minnesota 27051 1495 12
2481739 2481739 2022-05-07 Grant Nebraska 31075 104 5
2481856 2481856 2022-05-07 Grant New Mexico 35017 6698 90
2482057 2482057 2022-05-07 Grant North Dakota 38037 451 11
2482212 2482212 2022-05-07 Grant Oklahoma 40053 1035 16

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);