ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 7424 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Alabama 6
- California 5
- Louisiana 3
- North Carolina 3
- Kentucky 2
- Maine 2
- Massachusetts 2
- Ohio 2
- Wisconsin 2
- Florida 1
- Indiana 1
- Iowa 1
- Maryland 1
- Oklahoma 1
- Pennsylvania 1
- South Carolina 1
- Texas 1
- Utah 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428161 | 2428161 | 2022-04-21 | Siskiyou | California | 6093 | 7424 | 105 |
2424905 | 2424905 | 2022-04-20 | Siskiyou | California | 6093 | 7424 | 105 |
2421649 | 2421649 | 2022-04-19 | Siskiyou | California | 6093 | 7424 | 105 |
2418393 | 2418393 | 2022-04-18 | Siskiyou | California | 6093 | 7424 | 105 |
2415137 | 2415137 | 2022-04-17 | Siskiyou | California | 6093 | 7424 | 105 |
2403073 | 2403073 | 2022-04-13 | Hancock | Maine | 23009 | 7424 | 84 |
2327098 | 2327098 | 2022-03-21 | Pike | Alabama | 1109 | 7424 | 132 |
2243207 | 2243207 | 2022-02-23 | Daviess | Indiana | 18027 | 7424 | 147 |
2122144 | 2122144 | 2022-01-17 | Chambers | Alabama | 1017 | 7424 | 147 |
2084306 | 2084306 | 2022-01-05 | Aroostook | Maine | 23003 | 7424 | 110 |
2070121 | 2070121 | 2022-01-01 | Chilton | Alabama | 1021 | 7424 | 173 |
2066870 | 2066870 | 2021-12-31 | Chilton | Alabama | 1021 | 7424 | 173 |
2027923 | 2027923 | 2021-12-19 | Tallapoosa | Alabama | 1123 | 7424 | 204 |
1762484 | 1762484 | 2021-09-28 | Scott | Kentucky | 21209 | 7424 | 40 |
1734415 | 1734415 | 2021-09-19 | Carbon | Pennsylvania | 42025 | 7424 | 185 |
1701722 | 1701722 | 2021-09-09 | Belmont | Ohio | 39013 | 7424 | 181 |
1623626 | 1623626 | 2021-08-16 | Duplin | North Carolina | 37061 | 7424 | 146 |
1425605 | 1425605 | 2021-06-16 | Rutherford | North Carolina | 37161 | 7424 | 216 |
1422358 | 1422358 | 2021-06-15 | Rutherford | North Carolina | 37161 | 7424 | 216 |
1390790 | 1390790 | 2021-06-05 | Wise | Texas | 48497 | 7424 | 122 |
1381384 | 1381384 | 2021-06-02 | Portage | Wisconsin | 55097 | 7424 | 72 |
1358362 | 1358362 | 2021-05-26 | Tooele | Utah | 49045 | 7424 | 44 |
1322192 | 1322192 | 2021-05-15 | Laurens | South Carolina | 45059 | 7424 | 172 |
1309671 | 1309671 | 2021-05-11 | Chittenden | Vermont | 50007 | 7424 | 102 |
1269028 | 1269028 | 2021-04-29 | Wicomico | Maryland | 24045 | 7424 | 152 |
1239672 | 1239672 | 2021-04-20 | Oldham | Kentucky | 21185 | 7424 | 82 |
1077459 | 1077459 | 2021-03-01 | Hampshire | Massachusetts | 25015 | 7424 | 261 |
1056812 | 1056812 | 2021-02-23 | Talladega | Alabama | 1121 | 7424 | 161 |
1042692 | 1042692 | 2021-02-18 | Garfield | Oklahoma | 40047 | 7424 | 69 |
974485 | 974485 | 2021-01-28 | Pickaway | Ohio | 39129 | 7424 | 50 |
910653 | 910653 | 2021-01-08 | Ozaukee | Wisconsin | 55089 | 7424 | 62 |
827201 | 827201 | 2020-12-14 | Story | Iowa | 19169 | 7424 | 23 |
434615 | 434615 | 2020-08-15 | Seminole | Florida | 12117 | 7424 | 145 |
406381 | 406381 | 2020-08-06 | Lafayette | Louisiana | 22055 | 7424 | 91 |
188749 | 188749 | 2020-05-29 | Jefferson | Louisiana | 22051 | 7424 | 446 |
185691 | 185691 | 2020-05-28 | Jefferson | Louisiana | 22051 | 7424 | 441 |
167517 | 167517 | 2020-05-22 | Plymouth | Massachusetts | 25023 | 7424 | 492 |
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);