ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 16006 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Colorado 3
- Minnesota 3
- Texas 3
- Virginia 3
- Washington 3
- Louisiana 2
- Alabama 1
- Missouri 1
- New Mexico 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2439043 | 2439043 | 2022-04-24 | Crow Wing | Minnesota | 27035 | 16006 | 169 |
2435787 | 2435787 | 2022-04-23 | Crow Wing | Minnesota | 27035 | 16006 | 169 |
2432531 | 2432531 | 2022-04-22 | Crow Wing | Minnesota | 27035 | 16006 | 169 |
2415168 | 2415168 | 2022-04-17 | Eagle | Colorado | 8037 | 16006 | 35 |
2411912 | 2411912 | 2022-04-16 | Eagle | Colorado | 8037 | 16006 | 35 |
2408656 | 2408656 | 2022-04-15 | Eagle | Colorado | 8037 | 16006 | 35 |
2140002 | 2140002 | 2022-01-22 | St. Francois | Missouri | 29187 | 16006 | 251 |
2084935 | 2084935 | 2022-01-05 | Chaves | New Mexico | 35005 | 16006 | 236 |
1958692 | 1958692 | 2021-11-27 | Bayamon | Puerto Rico | 72021 | 16006 | |
1910885 | 1910885 | 2021-11-13 | Limestone | Alabama | 1083 | 16006 | 217 |
1712491 | 1712491 | 2021-09-12 | Thurston | Washington | 53067 | 16006 | 166 |
1709244 | 1709244 | 2021-09-11 | Thurston | Washington | 53067 | 16006 | 166 |
1705997 | 1705997 | 2021-09-10 | Thurston | Washington | 53067 | 16006 | 166 |
1621378 | 1621378 | 2021-08-15 | Arlington | Virginia | 51013 | 16006 | 258 |
1618130 | 1618130 | 2021-08-14 | Arlington | Virginia | 51013 | 16006 | 258 |
1614882 | 1614882 | 2021-08-13 | Arlington | Virginia | 51013 | 16006 | 258 |
1449184 | 1449184 | 2021-06-23 | Taylor | Texas | 48441 | 16006 | 414 |
1403707 | 1403707 | 2021-06-09 | Parker | Texas | 48367 | 16006 | 185 |
614843 | 614843 | 2020-10-09 | Collin | Texas | 48085 | 16006 | 162 |
457968 | 457968 | 2020-08-22 | Jefferson | Louisiana | 22051 | 16006 | 537 |
454740 | 454740 | 2020-08-21 | Jefferson | Louisiana | 22051 | 16006 | 537 |
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);