ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 22357 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- South Carolina 3
- New York 2
- North Carolina 2
- Wisconsin 2
- Arizona 1
- Connecticut 1
- Florida 1
- Ohio 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424622 | 2424622 | 2022-04-19 | Ozaukee | Wisconsin | 55089 | 22357 | 185 |
2257935 | 2257935 | 2022-02-27 | Greenwood | South Carolina | 45047 | 22357 | 282 |
2254684 | 2254684 | 2022-02-26 | Greenwood | South Carolina | 45047 | 22357 | 282 |
2251433 | 2251433 | 2022-02-25 | Greenwood | South Carolina | 45047 | 22357 | 282 |
2215545 | 2215545 | 2022-02-14 | Northumberland | Pennsylvania | 42097 | 22357 | 504 |
2106190 | 2106190 | 2022-01-12 | Middlesex | Connecticut | 9007 | 22357 | 430 |
1929074 | 1929074 | 2021-11-18 | Randolph | North Carolina | 37151 | 22357 | 323 |
1818753 | 1818753 | 2021-10-15 | Trumbull | Ohio | 39155 | 22357 | 552 |
1753510 | 1753510 | 2021-09-25 | Niagara | New York | 36063 | 22357 | 385 |
1467728 | 1467728 | 2021-06-29 | Cabarrus | North Carolina | 37025 | 22357 | 262 |
1268182 | 1268182 | 2021-04-29 | St. Johns | Florida | 12109 | 22357 | 209 |
991794 | 991794 | 2021-02-02 | Racine | Wisconsin | 55101 | 22357 | 328 |
870391 | 870391 | 2020-12-27 | Orange | New York | 36071 | 22357 | 503 |
524820 | 524820 | 2020-09-12 | Pima | Arizona | 4019 | 22357 | 602 |
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);