ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 10339 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Missouri 6
- California 4
- Georgia 4
- Maine 3
- North Carolina 3
- Texas 3
- Puerto Rico 2
- Arkansas 1
- Hawaii 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- New Jersey 1
- New Mexico 1
- New York 1
- Pennsylvania 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2383751 | 2383751 | 2022-04-07 | Steele | Minnesota | 27147 | 10339 | 61 |
2293124 | 2293124 | 2022-03-10 | Cortland | New York | 36023 | 10339 | 114 |
2290874 | 2290874 | 2022-03-09 | Van Zandt | Texas | 48467 | 10339 | 273 |
2287622 | 2287622 | 2022-03-08 | Van Zandt | Texas | 48467 | 10339 | 273 |
2200361 | 2200361 | 2022-02-10 | Independence | Arkansas | 5063 | 10339 | 187 |
2186825 | 2186825 | 2022-02-05 | Wilson | Texas | 48493 | 10339 | 151 |
2149603 | 2149603 | 2022-01-25 | Hancock | Mississippi | 28045 | 10339 | 141 |
2114783 | 2114783 | 2022-01-14 | Toa Alta | Puerto Rico | 72135 | 10339 | |
2087976 | 2087976 | 2022-01-06 | Taney | Missouri | 29213 | 10339 | 180 |
2059991 | 2059991 | 2021-12-28 | Box Elder | Utah | 49003 | 10339 | 99 |
1992341 | 1992341 | 2021-12-08 | Tehama | California | 6103 | 10339 | 133 |
1993937 | 1993937 | 2021-12-08 | Otero | New Mexico | 35035 | 10339 | 128 |
1965454 | 1965454 | 2021-11-29 | Roane | Tennessee | 47145 | 10339 | 160 |
1960156 | 1960156 | 2021-11-28 | Maui | Hawaii | 15009 | 10339 | 99 |
1869117 | 1869117 | 2021-10-31 | Spalding | Georgia | 13255 | 10339 | 306 |
1865868 | 1865868 | 2021-10-30 | Spalding | Georgia | 13255 | 10339 | 306 |
1862619 | 1862619 | 2021-10-29 | Spalding | Georgia | 13255 | 10339 | 306 |
1827548 | 1827548 | 2021-10-18 | Androscoggin | Maine | 23001 | 10339 | 96 |
1824299 | 1824299 | 2021-10-17 | Androscoggin | Maine | 23001 | 10339 | 96 |
1821050 | 1821050 | 2021-10-16 | Androscoggin | Maine | 23001 | 10339 | 96 |
1716423 | 1716423 | 2021-09-14 | Troup | Georgia | 13285 | 10339 | 267 |
1619956 | 1619956 | 2021-08-15 | Cape Girardeau | Missouri | 29031 | 10339 | 142 |
1616708 | 1616708 | 2021-08-14 | Cape Girardeau | Missouri | 29031 | 10339 | 142 |
1613460 | 1613460 | 2021-08-13 | Cape Girardeau | Missouri | 29031 | 10339 | 142 |
1610211 | 1610211 | 2021-08-12 | Cape Girardeau | Missouri | 29031 | 10339 | 142 |
1606963 | 1606963 | 2021-08-11 | Cape Girardeau | Missouri | 29031 | 10339 | 142 |
1580627 | 1580627 | 2021-08-03 | St. Landry | Louisiana | 22097 | 10339 | 269 |
1506715 | 1506715 | 2021-07-11 | Henderson | North Carolina | 37089 | 10339 | 165 |
1503469 | 1503469 | 2021-07-10 | Henderson | North Carolina | 37089 | 10339 | 165 |
1500223 | 1500223 | 2021-07-09 | Henderson | North Carolina | 37089 | 10339 | 165 |
1487634 | 1487634 | 2021-07-05 | Carolina | Puerto Rico | 72031 | 10339 | |
1420569 | 1420569 | 2021-06-15 | El Dorado | California | 6017 | 10339 | 116 |
1417324 | 1417324 | 2021-06-14 | El Dorado | California | 6017 | 10339 | 116 |
1059039 | 1059039 | 2021-02-23 | Fayette | Pennsylvania | 42051 | 10339 | 261 |
722700 | 722700 | 2020-11-12 | Santa Barbara | California | 6083 | 10339 | 131 |
610733 | 610733 | 2020-10-08 | Camden | New Jersey | 34007 | 10339 | 616 |
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);