ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 11362 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Oklahoma 7
- Minnesota 3
- Ohio 3
- Virginia 3
- Pennsylvania 2
- Texas 2
- Arkansas 1
- Georgia 1
- Indiana 1
- Michigan 1
- Montana 1
- North Carolina 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2376250 | 2376250 | 2022-04-05 | Camden | Georgia | 13039 | 11362 | 118 |
2330243 | 2330243 | 2022-03-21 | Oconto | Wisconsin | 55083 | 11362 | 116 |
2279588 | 2279588 | 2022-03-06 | Beltrami | Minnesota | 27007 | 11362 | 122 |
2276335 | 2276335 | 2022-03-05 | Beltrami | Minnesota | 27007 | 11362 | 122 |
2273082 | 2273082 | 2022-03-04 | Beltrami | Minnesota | 27007 | 11362 | 122 |
2244786 | 2244786 | 2022-02-23 | Huntingdon | Pennsylvania | 42061 | 11362 | 238 |
2225942 | 2225942 | 2022-02-17 | Culpeper | Virginia | 51047 | 11362 | 125 |
2205799 | 2205799 | 2022-02-11 | Union | Pennsylvania | 42119 | 11362 | 144 |
2044239 | 2044239 | 2021-12-24 | Crawford | Arkansas | 5033 | 11362 | 190 |
2017940 | 2017940 | 2021-12-15 | Lewis | Washington | 53041 | 11362 | 184 |
1922763 | 1922763 | 2021-11-16 | Creek | Oklahoma | 40037 | 11362 | 263 |
1919514 | 1919514 | 2021-11-15 | Creek | Oklahoma | 40037 | 11362 | 263 |
1916264 | 1916264 | 2021-11-14 | Creek | Oklahoma | 40037 | 11362 | 263 |
1913014 | 1913014 | 2021-11-13 | Creek | Oklahoma | 40037 | 11362 | 263 |
1909764 | 1909764 | 2021-11-12 | Creek | Oklahoma | 40037 | 11362 | 263 |
1906515 | 1906515 | 2021-11-11 | Creek | Oklahoma | 40037 | 11362 | 263 |
1903266 | 1903266 | 2021-11-10 | Creek | Oklahoma | 40037 | 11362 | 263 |
1807575 | 1807575 | 2021-10-12 | Bartholomew | Indiana | 18005 | 11362 | 183 |
1809851 | 1809851 | 2021-10-12 | Hanover | Virginia | 51085 | 11362 | 189 |
1650724 | 1650724 | 2021-08-24 | Spotsylvania | Virginia | 51177 | 11362 | 127 |
1400369 | 1400369 | 2021-06-08 | Grayson | Texas | 48181 | 11362 | 343 |
1285963 | 1285963 | 2021-05-04 | Cleveland | North Carolina | 37045 | 11362 | 224 |
1264130 | 1264130 | 2021-04-27 | Rockwall | Texas | 48397 | 11362 | 155 |
1240641 | 1240641 | 2021-04-20 | Allen | Ohio | 39003 | 11362 | 229 |
1159013 | 1159013 | 2021-03-26 | Flathead | Montana | 30029 | 11362 | 82 |
886817 | 886817 | 2021-01-01 | Delaware | Ohio | 39041 | 11362 | 65 |
883572 | 883572 | 2020-12-31 | Delaware | Ohio | 39041 | 11362 | 65 |
834090 | 834090 | 2020-12-16 | Ingham | Michigan | 26065 | 11362 | 155 |
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);