ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 7825 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Texas 5
- Massachusetts 4
- West Virginia 4
- Colorado 3
- Illinois 3
- Ohio 3
- Indiana 2
- New York 2
- North Carolina 2
- Arizona 1
- Arkansas 1
- Georgia 1
- Mississippi 1
- Montana 1
- Nebraska 1
- New Mexico 1
- Oregon 1
- Tennessee 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398188 | 2398188 | 2022-04-11 | Polk | Texas | 48373 | 7825 | 247 |
2377660 | 2377660 | 2022-04-05 | Cibola | New Mexico | 35006 | 7825 | 182 |
2333428 | 2333428 | 2022-03-22 | Mineral | West Virginia | 54057 | 7825 | 155 |
2330174 | 2330174 | 2022-03-21 | Mineral | West Virginia | 54057 | 7825 | 155 |
2308207 | 2308207 | 2022-03-15 | Saline | Illinois | 17165 | 7825 | 108 |
2258910 | 2258910 | 2022-02-28 | Poinsett | Arkansas | 5111 | 7825 | 117 |
2202883 | 2202883 | 2022-02-10 | Cherokee | Texas | 48073 | 7825 | 238 |
2199842 | 2199842 | 2022-02-09 | Wood | Texas | 48499 | 7825 | 261 |
2133777 | 2133777 | 2022-01-20 | Orleans | New York | 36073 | 7825 | 105 |
2094989 | 2094989 | 2022-01-08 | Mercer | Ohio | 39107 | 7825 | 110 |
1943994 | 1943994 | 2021-11-23 | Knox | Illinois | 17095 | 7825 | 206 |
1912709 | 1912709 | 2021-11-13 | Genesee | New York | 36037 | 7825 | 139 |
1897772 | 1897772 | 2021-11-08 | Grant | Wisconsin | 55043 | 7825 | 117 |
1888196 | 1888196 | 2021-11-06 | Graham | Arizona | 4009 | 7825 | 119 |
1831554 | 1831554 | 2021-10-19 | Granville | North Carolina | 37077 | 7825 | 99 |
1771014 | 1771014 | 2021-09-30 | Putnam | West Virginia | 54079 | 7825 | 109 |
1755146 | 1755146 | 2021-09-26 | Eagle | Colorado | 8037 | 7825 | 31 |
1751898 | 1751898 | 2021-09-25 | Eagle | Colorado | 8037 | 7825 | 31 |
1748649 | 1748649 | 2021-09-24 | Eagle | Colorado | 8037 | 7825 | 31 |
1733368 | 1733368 | 2021-09-19 | Berkshire | Massachusetts | 25003 | 7825 | 309 |
1730118 | 1730118 | 2021-09-18 | Berkshire | Massachusetts | 25003 | 7825 | 309 |
1726868 | 1726868 | 2021-09-17 | Berkshire | Massachusetts | 25003 | 7825 | 309 |
1447067 | 1447067 | 2021-06-23 | Floyd | Indiana | 18043 | 7825 | 185 |
1398194 | 1398194 | 2021-06-08 | Walker | Georgia | 13295 | 7825 | 88 |
1356253 | 1356253 | 2021-05-26 | Warrick | Indiana | 18173 | 7825 | 158 |
1238314 | 1238314 | 2021-04-19 | Hanover | Virginia | 51085 | 7825 | 150 |
1082571 | 1082571 | 2021-03-02 | Cabell | West Virginia | 54011 | 7825 | 160 |
1058665 | 1058665 | 2021-02-23 | Brunswick | North Carolina | 37019 | 7825 | 132 |
1054954 | 1054954 | 2021-02-22 | Jones | Mississippi | 28067 | 7825 | 142 |
1003220 | 1003220 | 2021-02-06 | Missoula | Montana | 30063 | 7825 | 82 |
998930 | 998930 | 2021-02-05 | Adams | Illinois | 17001 | 7825 | 138 |
864083 | 864083 | 2020-12-25 | Allen | Ohio | 39003 | 7825 | 108 |
860838 | 860838 | 2020-12-24 | Allen | Ohio | 39003 | 7825 | 108 |
734463 | 734463 | 2020-11-15 | Washington | Oregon | 41067 | 7825 | 89 |
633362 | 633362 | 2020-10-15 | Lancaster | Nebraska | 31109 | 7825 | 33 |
488498 | 488498 | 2020-08-31 | Rutherford | Tennessee | 47149 | 7825 | 70 |
467742 | 467742 | 2020-08-25 | Hampden | Massachusetts | 25013 | 7825 | 739 |
414513 | 414513 | 2020-08-08 | Webb | Texas | 48479 | 7825 | 163 |
280394 | 280394 | 2020-06-27 | Travis | Texas | 48453 | 7825 | 117 |
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);