ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 10335 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Michigan 7
- Mississippi 7
- Louisiana 3
- Idaho 2
- Ohio 2
- Pennsylvania 2
- Texas 2
- Alabama 1
- Arkansas 1
- Florida 1
- Georgia 1
- Maryland 1
- Minnesota 1
- Missouri 1
- Nevada 1
- New Hampshire 1
- North Dakota 1
- Oregon 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469334 | 2469334 | 2022-05-03 | Wayne | Pennsylvania | 42127 | 10335 | 171 |
2422691 | 2422691 | 2022-04-19 | Hillsdale | Michigan | 26059 | 10335 | 204 |
2419435 | 2419435 | 2022-04-18 | Hillsdale | Michigan | 26059 | 10335 | 204 |
2416179 | 2416179 | 2022-04-17 | Hillsdale | Michigan | 26059 | 10335 | 204 |
2412923 | 2412923 | 2022-04-16 | Hillsdale | Michigan | 26059 | 10335 | 204 |
2409667 | 2409667 | 2022-04-15 | Hillsdale | Michigan | 26059 | 10335 | 204 |
2406411 | 2406411 | 2022-04-14 | Hillsdale | Michigan | 26059 | 10335 | 204 |
2403155 | 2403155 | 2022-04-13 | Hillsdale | Michigan | 26059 | 10335 | 204 |
2228293 | 2228293 | 2022-02-18 | Williams | North Dakota | 38105 | 10335 | 68 |
2154273 | 2154273 | 2022-01-26 | Unknown | Texas | 10335 | 0 | |
2088156 | 2088156 | 2022-01-06 | Grafton | New Hampshire | 33009 | 10335 | 48 |
2043135 | 2043135 | 2021-12-23 | Bradford | Pennsylvania | 42015 | 10335 | 150 |
1899191 | 1899191 | 2021-11-09 | Crow Wing | Minnesota | 27035 | 10335 | 117 |
1894596 | 1894596 | 2021-11-08 | Autauga | Alabama | 1001 | 10335 | 151 |
1779077 | 1779077 | 2021-10-03 | Lamar | Mississippi | 28073 | 10335 | 134 |
1775827 | 1775827 | 2021-10-02 | Lamar | Mississippi | 28073 | 10335 | 134 |
1772577 | 1772577 | 2021-10-01 | Lamar | Mississippi | 28073 | 10335 | 134 |
1685486 | 1685486 | 2021-09-04 | Columbiana | Ohio | 39029 | 10335 | 236 |
1576807 | 1576807 | 2021-08-02 | Twin Falls | Idaho | 16083 | 10335 | 134 |
1542723 | 1542723 | 2021-07-22 | Deschutes | Oregon | 41017 | 10335 | 87 |
1543529 | 1543529 | 2021-07-22 | Spotsylvania | Virginia | 51177 | 10335 | 125 |
1486747 | 1486747 | 2021-07-05 | Madison | Mississippi | 28089 | 10335 | 227 |
1483501 | 1483501 | 2021-07-04 | Madison | Mississippi | 28089 | 10335 | 227 |
1480255 | 1480255 | 2021-07-03 | Madison | Mississippi | 28089 | 10335 | 227 |
1477008 | 1477008 | 2021-07-02 | Madison | Mississippi | 28089 | 10335 | 227 |
1431631 | 1431631 | 2021-06-18 | Clay | Missouri | 29047 | 10335 | 170 |
1378320 | 1378320 | 2021-06-02 | Garland | Arkansas | 5051 | 10335 | 261 |
1324169 | 1324169 | 2021-05-16 | Terrebonne | Louisiana | 22109 | 10335 | 222 |
1320923 | 1320923 | 2021-05-15 | Terrebonne | Louisiana | 22109 | 10335 | 222 |
1317676 | 1317676 | 2021-05-14 | Terrebonne | Louisiana | 22109 | 10335 | 222 |
1177201 | 1177201 | 2021-04-01 | Citrus | Florida | 12017 | 10335 | 429 |
1175738 | 1175738 | 2021-03-31 | Miami | Ohio | 39109 | 10335 | 206 |
946828 | 946828 | 2021-01-20 | Coweta | Georgia | 13077 | 10335 | 104 |
684119 | 684119 | 2020-10-31 | Canyon | Idaho | 16027 | 10335 | 111 |
610717 | 610717 | 2020-10-08 | Washoe | Nevada | 32031 | 10335 | 167 |
593932 | 593932 | 2020-10-03 | Anne Arundel | Maryland | 24003 | 10335 | 252 |
424018 | 424018 | 2020-08-11 | Fort Bend | Texas | 48157 | 10335 | 164 |
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);