ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 17574 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- California 6
- Louisiana 3
- Texas 3
- New York 2
- Alabama 1
- Indiana 1
- Michigan 1
- Minnesota 1
- New Jersey 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440377 | 2440377 | 2022-04-24 | Coryell | Texas | 48099 | 17574 | 211 |
2437121 | 2437121 | 2022-04-23 | Coryell | Texas | 48099 | 17574 | 211 |
2416811 | 2416811 | 2022-04-17 | Wayne | New York | 36117 | 17574 | 173 |
2330540 | 2330540 | 2022-03-22 | Yuba | California | 6115 | 17574 | 117 |
2327288 | 2327288 | 2022-03-21 | Yuba | California | 6115 | 17574 | 117 |
2324035 | 2324035 | 2022-03-20 | Yuba | California | 6115 | 17574 | 117 |
2320781 | 2320781 | 2022-03-19 | Yuba | California | 6115 | 17574 | 117 |
2317527 | 2317527 | 2022-03-18 | Yuba | California | 6115 | 17574 | 117 |
2314274 | 2314274 | 2022-03-17 | Yuba | California | 6115 | 17574 | 117 |
2239969 | 2239969 | 2022-02-22 | Grant | Indiana | 18053 | 17574 | 338 |
2075246 | 2075246 | 2022-01-02 | Oswego | New York | 36075 | 17574 | 148 |
1894630 | 1894630 | 2021-11-08 | Houston | Alabama | 1069 | 17574 | 418 |
1809968 | 1809968 | 2021-10-12 | Berkeley | West Virginia | 54003 | 17574 | 167 |
1642343 | 1642343 | 2021-08-22 | Rapides | Louisiana | 22079 | 17574 | 367 |
1639093 | 1639093 | 2021-08-21 | Rapides | Louisiana | 22079 | 17574 | 367 |
1635843 | 1635843 | 2021-08-20 | Rapides | Louisiana | 22079 | 17574 | 367 |
1566249 | 1566249 | 2021-07-29 | Richmond city | Virginia | 51760 | 17574 | 280 |
1489930 | 1489930 | 2021-07-06 | Scott | Minnesota | 27139 | 17574 | 139 |
1400466 | 1400466 | 2021-06-08 | Potter | Texas | 48375 | 17574 | 458 |
1314556 | 1314556 | 2021-05-13 | Muskegon | Michigan | 26121 | 17574 | 353 |
155893 | 155893 | 2020-05-18 | Hudson | New Jersey | 34017 | 17574 | 1068 |
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);