ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 9748 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- North Carolina 4
- Mississippi 3
- Idaho 2
- Minnesota 2
- North Dakota 2
- Wisconsin 2
- California 1
- Georgia 1
- Indiana 1
- Louisiana 1
- Michigan 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358159 | 2358159 | 2022-03-30 | Rio Arriba | New Mexico | 35039 | 9748 | 131 |
2315916 | 2315916 | 2022-03-17 | Otsego | New York | 36077 | 9748 | 88 |
2311340 | 2311340 | 2022-03-16 | Bingham | Idaho | 16011 | 9748 | 151 |
2101623 | 2101623 | 2022-01-10 | Klamath | Oregon | 41035 | 9748 | 174 |
2098063 | 2098063 | 2022-01-09 | Edgecombe | North Carolina | 37065 | 9748 | 127 |
2094811 | 2094811 | 2022-01-08 | Edgecombe | North Carolina | 37065 | 9748 | 127 |
2091559 | 2091559 | 2022-01-07 | Edgecombe | North Carolina | 37065 | 9748 | 127 |
1983822 | 1983822 | 2021-12-05 | Pearl River | Mississippi | 28109 | 9748 | 244 |
1980572 | 1980572 | 2021-12-04 | Pearl River | Mississippi | 28109 | 9748 | 244 |
1977322 | 1977322 | 2021-12-03 | Pearl River | Mississippi | 28109 | 9748 | 244 |
1884800 | 1884800 | 2021-11-04 | Portage | Wisconsin | 55097 | 9748 | 102 |
1791962 | 1791962 | 2021-10-07 | Clay | Minnesota | 27027 | 9748 | 98 |
1764540 | 1764540 | 2021-09-28 | Chippewa | Wisconsin | 55017 | 9748 | 108 |
1669157 | 1669157 | 2021-08-30 | Surry | North Carolina | 37171 | 9748 | 183 |
1646552 | 1646552 | 2021-08-23 | Muskingum | Ohio | 39119 | 9748 | 139 |
1535778 | 1535778 | 2021-07-20 | Merrimack | New Hampshire | 33013 | 9748 | 116 |
1488772 | 1488772 | 2021-07-06 | Sutter | California | 6101 | 9748 | 114 |
1424220 | 1424220 | 2021-06-16 | Twin Falls | Idaho | 16083 | 9748 | 132 |
1344277 | 1344277 | 2021-05-22 | Hunterdon | New Jersey | 34019 | 9748 | 175 |
1318557 | 1318557 | 2021-05-14 | Ward | North Dakota | 38101 | 9748 | 194 |
1285301 | 1285301 | 2021-05-04 | Eaton | Michigan | 26045 | 9748 | 189 |
1263654 | 1263654 | 2021-04-27 | Carolina | Puerto Rico | 72031 | 9748 | |
1248144 | 1248144 | 2021-04-22 | Grant | Washington | 53025 | 9748 | 114 |
1226925 | 1226925 | 2021-04-16 | Carver | Minnesota | 27019 | 9748 | 45 |
1126092 | 1126092 | 2021-03-16 | Terrebonne | Louisiana | 22109 | 9748 | 211 |
1089703 | 1089703 | 2021-03-05 | Newton | Georgia | 13217 | 9748 | 202 |
1032999 | 1032999 | 2021-02-15 | Rogers | Oklahoma | 40131 | 9748 | 108 |
989347 | 989347 | 2021-02-02 | Monroe | Indiana | 18105 | 9748 | 121 |
685561 | 685561 | 2020-10-31 | Cass | North Dakota | 38017 | 9748 | 85 |
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);