ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 10069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Mississippi 6
- Idaho 4
- Illinois 4
- Alaska 3
- Minnesota 3
- Pennsylvania 3
- North Carolina 2
- Texas 2
- Alabama 1
- Arkansas 1
- California 1
- Delaware 1
- Missouri 1
- New Hampshire 1
- New York 1
- North Dakota 1
- Puerto Rico 1
- Tennessee 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489827 | 2489827 | 2022-05-10 | Escambia | Alabama | 1053 | 10069 | 170 |
2461907 | 2461907 | 2022-05-01 | Alcorn | Mississippi | 28003 | 10069 | 160 |
2458651 | 2458651 | 2022-04-30 | Alcorn | Mississippi | 28003 | 10069 | 160 |
2455395 | 2455395 | 2022-04-29 | Alcorn | Mississippi | 28003 | 10069 | 160 |
2452139 | 2452139 | 2022-04-28 | Alcorn | Mississippi | 28003 | 10069 | 160 |
2448883 | 2448883 | 2022-04-27 | Alcorn | Mississippi | 28003 | 10069 | 160 |
2445627 | 2445627 | 2022-04-26 | Alcorn | Mississippi | 28003 | 10069 | 160 |
2377197 | 2377197 | 2022-04-05 | Isanti | Minnesota | 27059 | 10069 | 117 |
2373945 | 2373945 | 2022-04-04 | Isanti | Minnesota | 27059 | 10069 | 117 |
2329375 | 2329375 | 2022-03-21 | Wayne | Pennsylvania | 42127 | 10069 | 167 |
2109081 | 2109081 | 2022-01-12 | Polk | Wisconsin | 55095 | 10069 | 111 |
2089778 | 2089778 | 2022-01-07 | Mississippi | Arkansas | 5093 | 10069 | 160 |
1796171 | 1796171 | 2021-10-08 | Lawrence | Pennsylvania | 42073 | 10069 | 250 |
1763659 | 1763659 | 2021-09-28 | Clearfield | Pennsylvania | 42033 | 10069 | 177 |
1690468 | 1690468 | 2021-09-06 | Bannock | Idaho | 16005 | 10069 | 125 |
1687218 | 1687218 | 2021-09-05 | Bannock | Idaho | 16005 | 10069 | 125 |
1683968 | 1683968 | 2021-09-04 | Bannock | Idaho | 16005 | 10069 | 125 |
1680717 | 1680717 | 2021-09-03 | Bannock | Idaho | 16005 | 10069 | 125 |
1555476 | 1555476 | 2021-07-26 | Wilson | North Carolina | 37195 | 10069 | 181 |
1542542 | 1542542 | 2021-07-22 | Ward | North Dakota | 38101 | 10069 | 201 |
1533345 | 1533345 | 2021-07-19 | Robertson | Tennessee | 47147 | 10069 | 141 |
1505461 | 1505461 | 2021-07-11 | Vermilion | Illinois | 17183 | 10069 | 165 |
1502215 | 1502215 | 2021-07-10 | Vermilion | Illinois | 17183 | 10069 | 165 |
1498969 | 1498969 | 2021-07-09 | Vermilion | Illinois | 17183 | 10069 | 165 |
1444884 | 1444884 | 2021-06-22 | Strafford | New Hampshire | 33017 | 10069 | 97 |
1324513 | 1324513 | 2021-05-16 | Clay | Missouri | 29047 | 10069 | 165 |
1310627 | 1310627 | 2021-05-12 | DeKalb | Illinois | 17037 | 10069 | 124 |
1186693 | 1186693 | 2021-04-04 | Matanuska-Susitna Borough | Alaska | 2170 | 10069 | 35 |
1183446 | 1183446 | 2021-04-03 | Matanuska-Susitna Borough | Alaska | 2170 | 10069 | 35 |
1180199 | 1180199 | 2021-04-02 | Matanuska-Susitna Borough | Alaska | 2170 | 10069 | 35 |
1126883 | 1126883 | 2021-03-16 | Nash | North Carolina | 37127 | 10069 | 172 |
1078121 | 1078121 | 2021-03-01 | Ulster | New York | 36111 | 10069 | 228 |
1065581 | 1065581 | 2021-02-25 | Bayamon | Puerto Rico | 72021 | 10069 | |
809536 | 809536 | 2020-12-08 | Ector | Texas | 48135 | 10069 | 151 |
806291 | 806291 | 2020-12-07 | Ector | Texas | 48135 | 10069 | 151 |
768228 | 768228 | 2020-11-26 | Sussex | Delaware | 10005 | 10069 | 258 |
586473 | 586473 | 2020-10-01 | San Mateo | California | 6081 | 10069 | 150 |
235235 | 235235 | 2020-06-13 | Hennepin | Minnesota | 27053 | 10069 | 712 |
184312 | 184312 | 2020-05-27 | Fairfax | Virginia | 51059 | 10069 | 364 |
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);