ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 8973 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Missouri 7
- Ohio 7
- Massachusetts 4
- Kentucky 3
- Texas 3
- Wyoming 3
- California 2
- New York 2
- North Carolina 2
- Pennsylvania 2
- Alabama 1
- Guam 1
- Mississippi 1
- Puerto Rico 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283660 | 2283660 | 2022-03-07 | Williams | Ohio | 39171 | 8973 | 158 |
2279869 | 2279869 | 2022-03-06 | Webster | Missouri | 29225 | 8973 | 139 |
2276616 | 2276616 | 2022-03-05 | Webster | Missouri | 29225 | 8973 | 139 |
2273363 | 2273363 | 2022-03-04 | Webster | Missouri | 29225 | 8973 | 139 |
2271364 | 2271364 | 2022-03-03 | Washington | Texas | 48477 | 8973 | 144 |
2180310 | 2180310 | 2022-02-03 | Waller | Texas | 48473 | 8973 | 97 |
2120983 | 2120983 | 2022-01-16 | Highland | Ohio | 39071 | 8973 | 143 |
2037822 | 2037822 | 2021-12-22 | Mendocino | California | 6045 | 8973 | 103 |
2028868 | 2028868 | 2021-12-19 | Barren | Kentucky | 21009 | 8973 | 175 |
2025617 | 2025617 | 2021-12-18 | Barren | Kentucky | 21009 | 8973 | 175 |
2022366 | 2022366 | 2021-12-17 | Barren | Kentucky | 21009 | 8973 | 175 |
2016310 | 2016310 | 2021-12-15 | Lafayette | Mississippi | 28071 | 8973 | 143 |
1945618 | 1945618 | 2021-11-23 | Bradford | Pennsylvania | 42015 | 8973 | 135 |
1917323 | 1917323 | 2021-11-14 | Campbell | Wyoming | 56005 | 8973 | 111 |
1914073 | 1914073 | 2021-11-13 | Campbell | Wyoming | 56005 | 8973 | 111 |
1910823 | 1910823 | 2021-11-12 | Campbell | Wyoming | 56005 | 8973 | 111 |
1906446 | 1906446 | 2021-11-11 | Huron | Ohio | 39077 | 8973 | 149 |
1903199 | 1903199 | 2021-11-10 | Jefferson | Ohio | 39081 | 8973 | 210 |
1900191 | 1900191 | 2021-11-09 | Caguas | Puerto Rico | 72025 | 8973 | |
1869831 | 1869831 | 2021-10-31 | Berkshire | Massachusetts | 25003 | 8973 | 323 |
1866582 | 1866582 | 2021-10-30 | Berkshire | Massachusetts | 25003 | 8973 | 323 |
1863333 | 1863333 | 2021-10-29 | Berkshire | Massachusetts | 25003 | 8973 | 323 |
1857901 | 1857901 | 2021-10-27 | Indiana | Pennsylvania | 42063 | 8973 | 224 |
1792501 | 1792501 | 2021-10-07 | Ontario | New York | 36069 | 8973 | 103 |
1676216 | 1676216 | 2021-09-01 | Gibson | Tennessee | 47053 | 8973 | 161 |
1513111 | 1513111 | 2021-07-13 | Chautauqua | New York | 36013 | 8973 | 145 |
1464165 | 1464165 | 2021-06-28 | St. Francois | Missouri | 29187 | 8973 | 116 |
1460920 | 1460920 | 2021-06-27 | St. Francois | Missouri | 29187 | 8973 | 116 |
1457675 | 1457675 | 2021-06-26 | St. Francois | Missouri | 29187 | 8973 | 116 |
1454430 | 1454430 | 2021-06-25 | St. Francois | Missouri | 29187 | 8973 | 116 |
1373766 | 1373766 | 2021-05-31 | Columbiana | Ohio | 39029 | 8973 | 229 |
1370521 | 1370521 | 2021-05-30 | Columbiana | Ohio | 39029 | 8973 | 229 |
1338838 | 1338838 | 2021-05-20 | Victoria | Texas | 48469 | 8973 | 210 |
1319596 | 1319596 | 2021-05-14 | Whatcom | Washington | 53073 | 8973 | 95 |
1284588 | 1284588 | 2021-05-04 | Unknown | Guam | 8973 | 138 | |
1282025 | 1282025 | 2021-05-03 | Hampshire | Massachusetts | 25015 | 8973 | 291 |
1124955 | 1124955 | 2021-03-16 | Lauderdale | Alabama | 1077 | 8973 | 216 |
1110642 | 1110642 | 2021-03-11 | Lincoln | North Carolina | 37109 | 8973 | 75 |
1013280 | 1013280 | 2021-02-09 | Nash | North Carolina | 37127 | 8973 | 149 |
948530 | 948530 | 2021-01-20 | Richland | Ohio | 39139 | 8973 | 117 |
560548 | 560548 | 2020-09-23 | Santa Barbara | California | 6083 | 8973 | 113 |
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);