ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 9932 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Louisiana 5
- Texas 5
- Wyoming 5
- Kentucky 4
- Pennsylvania 4
- Michigan 3
- New Hampshire 3
- Wisconsin 3
- South Carolina 2
- Arkansas 1
- Hawaii 1
- Iowa 1
- Massachusetts 1
- Missouri 1
- New York 1
- North Dakota 1
- Ohio 1
- South Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442134 | 2442134 | 2022-04-25 | Vernon | Louisiana | 22115 | 9932 | 191 |
2438878 | 2438878 | 2022-04-24 | Vernon | Louisiana | 22115 | 9932 | 191 |
2435622 | 2435622 | 2022-04-23 | Vernon | Louisiana | 22115 | 9932 | 191 |
2432366 | 2432366 | 2022-04-22 | Vernon | Louisiana | 22115 | 9932 | 191 |
2429110 | 2429110 | 2022-04-21 | Vernon | Louisiana | 22115 | 9932 | 191 |
2398622 | 2398622 | 2022-04-11 | Teton | Wyoming | 56039 | 9932 | 16 |
2395367 | 2395367 | 2022-04-10 | Teton | Wyoming | 56039 | 9932 | 16 |
2392111 | 2392111 | 2022-04-09 | Teton | Wyoming | 56039 | 9932 | 16 |
2388855 | 2388855 | 2022-04-08 | Teton | Wyoming | 56039 | 9932 | 16 |
2279283 | 2279283 | 2022-03-06 | Clark | Kentucky | 21049 | 9932 | 53 |
2276030 | 2276030 | 2022-03-05 | Clark | Kentucky | 21049 | 9932 | 53 |
2272777 | 2272777 | 2022-03-04 | Clark | Kentucky | 21049 | 9932 | 53 |
2180307 | 2180307 | 2022-02-03 | Van Zandt | Texas | 48467 | 9932 | 250 |
2142963 | 2142963 | 2022-01-23 | Newaygo | Michigan | 26123 | 9932 | 137 |
2144833 | 2144833 | 2022-01-23 | Douglas | Wisconsin | 55031 | 9932 | 71 |
2139708 | 2139708 | 2022-01-22 | Newaygo | Michigan | 26123 | 9932 | 137 |
2141578 | 2141578 | 2022-01-22 | Douglas | Wisconsin | 55031 | 9932 | 71 |
2136452 | 2136452 | 2022-01-21 | Newaygo | Michigan | 26123 | 9932 | 137 |
2138322 | 2138322 | 2022-01-21 | Douglas | Wisconsin | 55031 | 9932 | 71 |
2023495 | 2023495 | 2021-12-17 | Sandusky | Ohio | 39143 | 9932 | 177 |
1964703 | 1964703 | 2021-11-29 | Cattaraugus | New York | 36009 | 9932 | 156 |
1869157 | 1869157 | 2021-10-31 | Maui | Hawaii | 15009 | 9932 | 94 |
1793124 | 1793124 | 2021-10-07 | Lincoln | South Dakota | 46083 | 9932 | 78 |
1627743 | 1627743 | 2021-08-17 | Orange | Texas | 48361 | 9932 | 159 |
1623998 | 1623998 | 2021-08-16 | Mercer | Pennsylvania | 42085 | 9932 | 269 |
1624496 | 1624496 | 2021-08-16 | Orange | Texas | 48361 | 9932 | 158 |
1621249 | 1621249 | 2021-08-15 | Orange | Texas | 48361 | 9932 | 158 |
1618001 | 1618001 | 2021-08-14 | Orange | Texas | 48361 | 9932 | 158 |
1591472 | 1591472 | 2021-08-06 | Adams | Pennsylvania | 42001 | 9932 | 190 |
1445547 | 1445547 | 2021-06-22 | Oconee | South Carolina | 45073 | 9932 | 138 |
1442302 | 1442302 | 2021-06-21 | Oconee | South Carolina | 45073 | 9932 | 138 |
1424669 | 1424669 | 2021-06-16 | Hardin | Kentucky | 21093 | 9932 | 167 |
1420362 | 1420362 | 2021-06-14 | Laramie | Wyoming | 56021 | 9932 | 117 |
1392952 | 1392952 | 2021-06-06 | Strafford | New Hampshire | 33017 | 9932 | 94 |
1389707 | 1389707 | 2021-06-05 | Strafford | New Hampshire | 33017 | 9932 | 94 |
1386462 | 1386462 | 2021-06-04 | Strafford | New Hampshire | 33017 | 9932 | 94 |
1146418 | 1146418 | 2021-03-22 | Grand Forks | North Dakota | 38035 | 9932 | 76 |
1115312 | 1115312 | 2021-03-13 | Garland | Arkansas | 5051 | 9932 | 243 |
1094759 | 1094759 | 2021-03-06 | Monroe | Pennsylvania | 42089 | 9932 | 272 |
759063 | 759063 | 2020-11-23 | Woodbury | Iowa | 19193 | 9932 | 114 |
542130 | 542130 | 2020-09-17 | Norfolk | Massachusetts | 25021 | 9932 | 1042 |
519788 | 519788 | 2020-09-10 | Kansas City | Missouri | 9932 | 101 | |
465532 | 465532 | 2020-08-24 | Allegheny | Pennsylvania | 42003 | 9932 | 306 |
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);