ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 12883 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Indiana 3
- North Carolina 3
- West Virginia 3
- California 2
- Puerto Rico 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Connecticut 1
- Florida 1
- Georgia 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- New Mexico 1
- New York 1
- Ohio 1
- Pennsylvania 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489727 | 2489727 | 2022-05-09 | Grant | Wisconsin | 55043 | 12883 | 145 |
2427950 | 2427950 | 2022-04-21 | Dale | Alabama | 1045 | 12883 | 231 |
2427017 | 2427017 | 2022-04-20 | Arecibo | Puerto Rico | 72013 | 12883 | |
2338755 | 2338755 | 2022-03-24 | Haywood | North Carolina | 37087 | 12883 | 198 |
2335501 | 2335501 | 2022-03-23 | Haywood | North Carolina | 37087 | 12883 | 198 |
2292617 | 2292617 | 2022-03-10 | Goodhue | Minnesota | 27049 | 12883 | 126 |
2269680 | 2269680 | 2022-03-03 | Washington | Louisiana | 22117 | 12883 | 241 |
2210135 | 2210135 | 2022-02-13 | Mississippi | Arkansas | 5093 | 12883 | 175 |
2171662 | 2171662 | 2022-02-01 | Dearborn | Indiana | 18029 | 12883 | 122 |
2160580 | 2160580 | 2022-01-28 | Caldwell | Texas | 48055 | 12883 | 164 |
2148642 | 2148642 | 2022-01-25 | Laurens | Georgia | 13175 | 12883 | 266 |
2120741 | 2120741 | 2022-01-16 | Clinton | New York | 36019 | 12883 | 64 |
2057837 | 2057837 | 2021-12-28 | Floyd | Indiana | 18043 | 12883 | 245 |
1990937 | 1990937 | 2021-12-07 | Erie | Ohio | 39043 | 12883 | 207 |
1922391 | 1922391 | 2021-11-16 | Cape May | New Jersey | 34009 | 12883 | 242 |
1844126 | 1844126 | 2021-10-23 | Christian | Missouri | 29043 | 12883 | 157 |
1836322 | 1836322 | 2021-10-21 | Napa | California | 6055 | 12883 | 100 |
1831875 | 1831875 | 2021-10-19 | Adams | Pennsylvania | 42001 | 12883 | 215 |
1675576 | 1675576 | 2021-09-01 | Brunswick | North Carolina | 37019 | 12883 | 183 |
1630016 | 1630016 | 2021-08-18 | McKinley | New Mexico | 35031 | 12883 | 483 |
1555816 | 1555816 | 2021-07-26 | Bayamon | Puerto Rico | 72021 | 12883 | |
1507866 | 1507866 | 2021-07-11 | Berkeley | West Virginia | 54003 | 12883 | 133 |
1504620 | 1504620 | 2021-07-10 | Berkeley | West Virginia | 54003 | 12883 | 133 |
1501374 | 1501374 | 2021-07-09 | Berkeley | West Virginia | 54003 | 12883 | 133 |
1492095 | 1492095 | 2021-07-07 | Middlesex | Connecticut | 9007 | 12883 | 374 |
1126360 | 1126360 | 2021-03-16 | Jackson | Mississippi | 28059 | 12883 | 236 |
933624 | 933624 | 2021-01-16 | Madera | California | 6039 | 12883 | 130 |
635222 | 635222 | 2020-10-16 | Escambia | Florida | 12033 | 12883 | 268 |
605807 | 605807 | 2020-10-07 | Yuma | Arizona | 4027 | 12883 | 347 |
348174 | 348174 | 2020-07-19 | Marion | Indiana | 18097 | 12883 | 752 |
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);