ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 19175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- California 4
- Texas 4
- Florida 1
- Iowa 1
- Maryland 1
- New York 1
- Oregon 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494960 | 2494960 | 2022-05-11 | Sullivan | New York | 36105 | 19175 | 130 |
1669974 | 1669974 | 2021-08-30 | Parker | Texas | 48367 | 19175 | 220 |
1666727 | 1666727 | 2021-08-29 | Parker | Texas | 48367 | 19175 | 220 |
1663479 | 1663479 | 2021-08-28 | Parker | Texas | 48367 | 19175 | 220 |
1660231 | 1660231 | 2021-08-27 | Parker | Texas | 48367 | 19175 | 218 |
1490765 | 1490765 | 2021-07-06 | Clackamas | Oregon | 41005 | 19175 | 240 |
1350186 | 1350186 | 2021-05-24 | Howard | Maryland | 24027 | 19175 | 236 |
1102009 | 1102009 | 2021-03-08 | Clark | Washington | 53011 | 19175 | 233 |
1038128 | 1038128 | 2021-02-17 | Linn | Iowa | 19113 | 19175 | 305 |
1024510 | 1024510 | 2021-02-13 | Placer | California | 6061 | 19175 | 222 |
1021265 | 1021265 | 2021-02-12 | Placer | California | 6061 | 19175 | 222 |
1018020 | 1018020 | 2021-02-11 | Placer | California | 6061 | 19175 | 222 |
703247 | 703247 | 2020-11-06 | Stanislaus | California | 6099 | 19175 | 407 |
508896 | 508896 | 2020-09-07 | Lee | Florida | 12071 | 19175 | 438 |
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);