ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 10703 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Illinois 3
- Pennsylvania 3
- Kentucky 2
- New York 2
- Texas 2
- Florida 1
- Iowa 1
- Michigan 1
- Minnesota 1
- New Jersey 1
- New Mexico 1
- North Carolina 1
- Ohio 1
- Vermont 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2384211 | 2384211 | 2022-04-07 | Cortland | New York | 36023 | 10703 | 116 |
2364729 | 2364729 | 2022-04-01 | Tioga | New York | 36107 | 10703 | 82 |
2287635 | 2287635 | 2022-03-08 | Wilson | Texas | 48493 | 10703 | 155 |
2283514 | 2283514 | 2022-03-07 | Yadkin | North Carolina | 37197 | 10703 | 107 |
2197607 | 2197607 | 2022-02-09 | Jefferson | Illinois | 17081 | 10703 | 164 |
2171988 | 2171988 | 2022-02-01 | Greenup | Kentucky | 21089 | 10703 | 114 |
2163478 | 2163478 | 2022-01-29 | Huntingdon | Pennsylvania | 42061 | 10703 | 224 |
2163508 | 2163508 | 2022-01-29 | Venango | Pennsylvania | 42121 | 10703 | 218 |
2157875 | 2157875 | 2022-01-27 | Pierce | Wisconsin | 55093 | 10703 | 65 |
2133715 | 2133715 | 2022-01-20 | Curry | New Mexico | 35009 | 10703 | 150 |
2128311 | 2128311 | 2022-01-18 | Unknown | Vermont | 10703 | 0 | |
2104731 | 2104731 | 2022-01-11 | Knox | Ohio | 39083 | 10703 | 194 |
1973628 | 1973628 | 2021-12-02 | Christian | Kentucky | 21047 | 10703 | 149 |
1854657 | 1854657 | 2021-10-26 | Lawrence | Pennsylvania | 42073 | 10703 | 261 |
1599573 | 1599573 | 2021-08-09 | DeKalb | Illinois | 17037 | 10703 | 128 |
1512596 | 1512596 | 2021-07-13 | Carver | Minnesota | 27019 | 10703 | 49 |
1433092 | 1433092 | 2021-06-18 | Hampton city | Virginia | 51650 | 10703 | 181 |
1223214 | 1223214 | 2021-04-15 | Pottawattamie | Iowa | 19155 | 10703 | 162 |
1152146 | 1152146 | 2021-03-24 | Calhoun | Michigan | 26025 | 10703 | 242 |
1092027 | 1092027 | 2021-03-05 | Rockwall | Texas | 48397 | 10703 | 133 |
1031133 | 1031133 | 2021-02-15 | Hernando | Florida | 12053 | 10703 | 368 |
674522 | 674522 | 2020-10-28 | Winnebago | Illinois | 17201 | 10703 | 189 |
468302 | 468302 | 2020-08-25 | Monmouth | New Jersey | 34025 | 10703 | 860 |
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);