ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 12088 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- North Carolina 5
- Texas 5
- Wyoming 4
- Florida 2
- Michigan 2
- New York 2
- Wisconsin 2
- Arkansas 1
- Hawaii 1
- Indiana 1
- Kentucky 1
- Minnesota 1
- Ohio 1
- Pennsylvania 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465619 | 2465619 | 2022-05-02 | Livingston | New York | 36051 | 12088 | 116 |
2353047 | 2353047 | 2022-03-28 | Campbell | Wyoming | 56005 | 12088 | 145 |
2349795 | 2349795 | 2022-03-27 | Campbell | Wyoming | 56005 | 12088 | 145 |
2346542 | 2346542 | 2022-03-26 | Campbell | Wyoming | 56005 | 12088 | 145 |
2343289 | 2343289 | 2022-03-25 | Campbell | Wyoming | 56005 | 12088 | 145 |
2225784 | 2225784 | 2022-02-17 | Navarro | Texas | 48349 | 12088 | 212 |
2053473 | 2053473 | 2021-12-26 | Walker | Texas | 48471 | 12088 | 188 |
2050223 | 2050223 | 2021-12-25 | Walker | Texas | 48471 | 12088 | 188 |
2046973 | 2046973 | 2021-12-24 | Walker | Texas | 48471 | 12088 | 188 |
2043723 | 2043723 | 2021-12-23 | Walker | Texas | 48471 | 12088 | 188 |
2038165 | 2038165 | 2021-12-22 | Hawaii | Hawaii | 15001 | 12088 | 148 |
2037567 | 2037567 | 2021-12-21 | Portage | Wisconsin | 55097 | 12088 | 125 |
2016252 | 2016252 | 2021-12-15 | Rice | Minnesota | 27131 | 12088 | 147 |
1961589 | 1961589 | 2021-11-28 | Stanly | North Carolina | 37167 | 12088 | 198 |
1958338 | 1958338 | 2021-11-27 | Stanly | North Carolina | 37167 | 12088 | 198 |
1955087 | 1955087 | 2021-11-26 | Stanly | North Carolina | 37167 | 12088 | 198 |
1951836 | 1951836 | 2021-11-25 | Stanly | North Carolina | 37167 | 12088 | 198 |
1948585 | 1948585 | 2021-11-24 | Stanly | North Carolina | 37167 | 12088 | 198 |
1919629 | 1919629 | 2021-11-15 | Crawford | Pennsylvania | 42039 | 12088 | 201 |
1901249 | 1901249 | 2021-11-10 | Lonoke | Arkansas | 5085 | 12088 | 175 |
1872866 | 1872866 | 2021-11-01 | Bullitt | Kentucky | 21029 | 12088 | 128 |
1678155 | 1678155 | 2021-09-02 | Allegan | Michigan | 26005 | 12088 | 166 |
1674907 | 1674907 | 2021-09-01 | Allegan | Michigan | 26005 | 12088 | 166 |
1219063 | 1219063 | 2021-04-13 | Walworth | Wisconsin | 55127 | 12088 | 155 |
1201494 | 1201494 | 2021-04-08 | Schenectady | New York | 36093 | 12088 | 189 |
1171127 | 1171127 | 2021-03-30 | Madison | Indiana | 18095 | 12088 | 353 |
916399 | 916399 | 2021-01-10 | Pickens | South Carolina | 45077 | 12088 | 175 |
901343 | 901343 | 2021-01-06 | Santa Rosa | Florida | 12113 | 12088 | 142 |
719602 | 719602 | 2020-11-11 | Pasco | Florida | 12101 | 12088 | 251 |
381559 | 381559 | 2020-07-29 | Cuyahoga | Ohio | 39035 | 12088 | 465 |
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);