ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 7221 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Texas 8
- Mississippi 5
- Georgia 4
- Ohio 4
- Virginia 3
- Colorado 2
- Missouri 2
- New York 2
- Pennsylvania 2
- California 1
- Delaware 1
- Illinois 1
- Kentucky 1
- Maryland 1
- Minnesota 1
- New Hampshire 1
- New Mexico 1
- North Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491024 | 2491024 | 2022-05-10 | Queen Anne's | Maryland | 24035 | 7221 | 110 |
2424159 | 2424159 | 2022-04-19 | Hopkins | Texas | 48223 | 7221 | 178 |
2420825 | 2420825 | 2022-04-18 | Cass | Texas | 48067 | 7221 | 196 |
2421099 | 2421099 | 2022-04-18 | Amherst | Virginia | 51009 | 7221 | 88 |
2417569 | 2417569 | 2022-04-17 | Cass | Texas | 48067 | 7221 | 196 |
2414313 | 2414313 | 2022-04-16 | Cass | Texas | 48067 | 7221 | 196 |
2411057 | 2411057 | 2022-04-15 | Cass | Texas | 48067 | 7221 | 196 |
2407801 | 2407801 | 2022-04-14 | Cass | Texas | 48067 | 7221 | 196 |
2379577 | 2379577 | 2022-04-06 | Lumpkin | Georgia | 13187 | 7221 | 131 |
2376323 | 2376323 | 2022-04-05 | Lumpkin | Georgia | 13187 | 7221 | 131 |
2378873 | 2378873 | 2022-04-05 | Pulaski | Virginia | 51155 | 7221 | 135 |
2373071 | 2373071 | 2022-04-04 | Lumpkin | Georgia | 13187 | 7221 | 131 |
2261722 | 2261722 | 2022-02-28 | Gloucester | Virginia | 51073 | 7221 | 99 |
2244450 | 2244450 | 2022-02-23 | Macon | North Carolina | 37113 | 7221 | 104 |
2156994 | 2156994 | 2022-01-27 | Susquehanna | Pennsylvania | 42115 | 7221 | 99 |
2107295 | 2107295 | 2022-01-12 | Alcorn | Mississippi | 28003 | 7221 | 119 |
2098982 | 2098982 | 2022-01-09 | Uvalde | Texas | 48463 | 7221 | 120 |
2026728 | 2026728 | 2021-12-18 | Mercer | Ohio | 39107 | 7221 | 104 |
2011886 | 2011886 | 2021-12-14 | La Plata | Colorado | 8067 | 7221 | 65 |
1967974 | 1967974 | 2021-11-30 | Livingston | New York | 36051 | 7221 | 76 |
1889690 | 1889690 | 2021-11-06 | Scott | Missouri | 29201 | 7221 | 117 |
1860402 | 1860402 | 2021-10-28 | Johnson | Missouri | 29101 | 7221 | 73 |
1782258 | 1782258 | 2021-10-04 | Otter Tail | Minnesota | 27111 | 7221 | 99 |
1735655 | 1735655 | 2021-09-20 | Fremont | Colorado | 8043 | 7221 | 72 |
1654780 | 1654780 | 2021-08-26 | Boone | Illinois | 17007 | 7221 | 93 |
1627027 | 1627027 | 2021-08-17 | Geauga | Ohio | 39055 | 7221 | 153 |
1627031 | 1627031 | 2021-08-17 | Hancock | Ohio | 39063 | 7221 | 138 |
1609113 | 1609113 | 2021-08-12 | Catoosa | Georgia | 13047 | 7221 | 77 |
1470902 | 1470902 | 2021-06-30 | Valencia | New Mexico | 35061 | 7221 | 119 |
1356914 | 1356914 | 2021-05-26 | Lauderdale | Mississippi | 28075 | 7221 | 240 |
1353668 | 1353668 | 2021-05-25 | Lauderdale | Mississippi | 28075 | 7221 | 240 |
1315536 | 1315536 | 2021-05-13 | Crawford | Pennsylvania | 42039 | 7221 | 149 |
1290182 | 1290182 | 2021-05-05 | Tooele | Utah | 49045 | 7221 | 41 |
1276178 | 1276178 | 2021-05-01 | Oswego | New York | 36075 | 7221 | 90 |
1227041 | 1227041 | 2021-04-16 | Lauderdale | Mississippi | 28075 | 7221 | 237 |
1228461 | 1228461 | 2021-04-16 | Wise | Texas | 48497 | 7221 | 118 |
1223793 | 1223793 | 2021-04-15 | Lauderdale | Mississippi | 28075 | 7221 | 237 |
971235 | 971235 | 2021-01-27 | Muskingum | Ohio | 39119 | 7221 | 42 |
846028 | 846028 | 2020-12-20 | Shasta | California | 6089 | 7221 | 66 |
818370 | 818370 | 2020-12-11 | Rockingham | New Hampshire | 33015 | 7221 | 115 |
618985 | 618985 | 2020-10-11 | Sussex | Delaware | 10005 | 7221 | 211 |
396638 | 396638 | 2020-08-03 | Jefferson | Kentucky | 21111 | 7221 | 248 |
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);