ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 8095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Pennsylvania 8
- Texas 5
- Louisiana 4
- Missouri 4
- Michigan 2
- Minnesota 2
- Montana 2
- Ohio 2
- West Virginia 2
- Arkansas 1
- Florida 1
- Idaho 1
- Indiana 1
- Maine 1
- Mississippi 1
- New York 1
- North Carolina 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459096 | 2459096 | 2022-04-30 | Delaware | New York | 36025 | 8095 | 72 |
2371658 | 2371658 | 2022-04-03 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2368405 | 2368405 | 2022-04-02 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2365152 | 2365152 | 2022-04-01 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2361899 | 2361899 | 2022-03-31 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2348116 | 2348116 | 2022-03-27 | Laclede | Missouri | 29105 | 8095 | 174 |
2344863 | 2344863 | 2022-03-26 | Laclede | Missouri | 29105 | 8095 | 174 |
2341610 | 2341610 | 2022-03-25 | Laclede | Missouri | 29105 | 8095 | 174 |
2338357 | 2338357 | 2022-03-24 | Laclede | Missouri | 29105 | 8095 | 174 |
2310282 | 2310282 | 2022-03-15 | Kendall | Texas | 48259 | 8095 | 117 |
2283818 | 2283818 | 2022-03-07 | McKean | Pennsylvania | 42083 | 8095 | 137 |
2221393 | 2221393 | 2022-02-16 | Silver Bow | Montana | 30093 | 8095 | 122 |
2206324 | 2206324 | 2022-02-11 | Titus | Texas | 48449 | 8095 | 120 |
2197531 | 2197531 | 2022-02-09 | Bonner | Idaho | 16017 | 8095 | 165 |
2173640 | 2173640 | 2022-02-01 | Erath | Texas | 48143 | 8095 | 113 |
2170833 | 2170833 | 2022-01-31 | Randolph | West Virginia | 54083 | 8095 | 66 |
2133383 | 2133383 | 2022-01-20 | Union | Mississippi | 28145 | 8095 | 104 |
2085770 | 2085770 | 2022-01-05 | Burnet | Texas | 48053 | 8095 | 136 |
2039026 | 2039026 | 2021-12-22 | Winona | Minnesota | 27169 | 8095 | 62 |
1909730 | 1909730 | 2021-11-12 | Seneca | Ohio | 39147 | 8095 | 153 |
1875014 | 1875014 | 2021-11-01 | Columbia | Wisconsin | 55021 | 8095 | 80 |
1825253 | 1825253 | 2021-10-17 | Union | Ohio | 39159 | 8095 | 56 |
1733309 | 1733309 | 2021-09-19 | St. Martin | Louisiana | 22099 | 8095 | 153 |
1730059 | 1730059 | 2021-09-18 | St. Martin | Louisiana | 22099 | 8095 | 153 |
1726809 | 1726809 | 2021-09-17 | St. Martin | Louisiana | 22099 | 8095 | 153 |
1697601 | 1697601 | 2021-09-08 | Penobscot | Maine | 23019 | 8095 | 115 |
1676396 | 1676396 | 2021-09-01 | Hood | Texas | 48221 | 8095 | 152 |
1582611 | 1582611 | 2021-08-03 | Wood | West Virginia | 54107 | 8095 | 177 |
1542806 | 1542806 | 2021-07-22 | Somerset | Pennsylvania | 42111 | 8095 | 219 |
1539558 | 1539558 | 2021-07-21 | Somerset | Pennsylvania | 42111 | 8095 | 219 |
1342660 | 1342660 | 2021-05-22 | White | Arkansas | 5145 | 8095 | 118 |
1334125 | 1334125 | 2021-05-19 | Rice | Minnesota | 27131 | 8095 | 108 |
1255547 | 1255547 | 2021-04-25 | Hancock | Indiana | 18059 | 8095 | 143 |
1100912 | 1100912 | 2021-03-08 | Moore | North Carolina | 37125 | 8095 | 182 |
1083097 | 1083097 | 2021-03-03 | Sumter | Florida | 12119 | 8095 | 241 |
1020254 | 1020254 | 2021-02-11 | Orangeburg | South Carolina | 45075 | 8095 | 197 |
960701 | 960701 | 2021-01-24 | St. Clair | Michigan | 26147 | 8095 | 224 |
890252 | 890252 | 2021-01-02 | Blair | Pennsylvania | 42013 | 8095 | 176 |
814590 | 814590 | 2020-12-10 | Berrien | Michigan | 26021 | 8095 | 135 |
808476 | 808476 | 2020-12-08 | Gallatin | Montana | 30031 | 8095 | 25 |
629524 | 629524 | 2020-10-14 | Calcasieu | Louisiana | 22019 | 8095 | 221 |
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);