ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 8232 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Indiana 7
- Pennsylvania 6
- New York 5
- South Carolina 5
- Kansas 4
- North Carolina 4
- Wisconsin 4
- Michigan 3
- Virgin Islands 3
- Georgia 2
- Minnesota 2
- Texas 2
- Virginia 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Illinois 1
- Louisiana 1
- Mississippi 1
- Montana 1
- New Mexico 1
- Ohio 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486217 | 2486217 | 2022-05-08 | St. Croix | Virgin Islands | 78010 | 8232 | 49 |
2482959 | 2482959 | 2022-05-07 | St. Croix | Virgin Islands | 78010 | 8232 | 49 |
2479701 | 2479701 | 2022-05-06 | St. Croix | Virgin Islands | 78010 | 8232 | 49 |
2469760 | 2469760 | 2022-05-03 | Kendall | Texas | 48259 | 8232 | 118 |
2466504 | 2466504 | 2022-05-02 | Kendall | Texas | 48259 | 8232 | 118 |
2410679 | 2410679 | 2022-04-15 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2407423 | 2407423 | 2022-04-14 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2404167 | 2404167 | 2022-04-13 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2400912 | 2400912 | 2022-04-12 | Clarion | Pennsylvania | 42031 | 8232 | 202 |
2283414 | 2283414 | 2022-03-07 | Wyoming | New York | 36121 | 8232 | 82 |
2280162 | 2280162 | 2022-03-06 | Wyoming | New York | 36121 | 8232 | 82 |
2276909 | 2276909 | 2022-03-05 | Wyoming | New York | 36121 | 8232 | 82 |
2243262 | 2243262 | 2022-02-23 | Ripley | Indiana | 18137 | 8232 | 130 |
2226200 | 2226200 | 2022-02-17 | Trempealeau | Wisconsin | 55121 | 8232 | 59 |
2195837 | 2195837 | 2022-02-08 | Ottawa | Ohio | 39123 | 8232 | 130 |
2185817 | 2185817 | 2022-02-05 | Greene | New York | 36039 | 8232 | 115 |
2156969 | 2156969 | 2022-01-27 | Jefferson | Pennsylvania | 42065 | 8232 | 204 |
1997174 | 1997174 | 2021-12-09 | Curry | New Mexico | 35009 | 8232 | 131 |
1986526 | 1986526 | 2021-12-06 | Finney | Kansas | 20055 | 8232 | 95 |
1983276 | 1983276 | 2021-12-05 | Finney | Kansas | 20055 | 8232 | 94 |
1980026 | 1980026 | 2021-12-04 | Finney | Kansas | 20055 | 8232 | 94 |
1976776 | 1976776 | 2021-12-03 | Finney | Kansas | 20055 | 8232 | 94 |
1970534 | 1970534 | 2021-12-01 | Washington | Louisiana | 22117 | 8232 | 218 |
1930443 | 1930443 | 2021-11-19 | Graham | Arizona | 4009 | 8232 | 123 |
1846633 | 1846633 | 2021-10-24 | Shelby | Indiana | 18145 | 8232 | 130 |
1849018 | 1849018 | 2021-10-24 | Calumet | Wisconsin | 55015 | 8232 | 59 |
1843383 | 1843383 | 2021-10-23 | Shelby | Indiana | 18145 | 8232 | 130 |
1845768 | 1845768 | 2021-10-23 | Calumet | Wisconsin | 55015 | 8232 | 59 |
1840133 | 1840133 | 2021-10-22 | Shelby | Indiana | 18145 | 8232 | 130 |
1842518 | 1842518 | 2021-10-22 | Calumet | Wisconsin | 55015 | 8232 | 59 |
1740613 | 1740613 | 2021-09-21 | Pender | North Carolina | 37141 | 8232 | 91 |
1711825 | 1711825 | 2021-09-12 | Cherokee | South Carolina | 45021 | 8232 | 176 |
1708578 | 1708578 | 2021-09-11 | Cherokee | South Carolina | 45021 | 8232 | 176 |
1705331 | 1705331 | 2021-09-10 | Cherokee | South Carolina | 45021 | 8232 | 176 |
1652810 | 1652810 | 2021-08-25 | Oswego | New York | 36075 | 8232 | 95 |
1650024 | 1650024 | 2021-08-24 | Caguas | Puerto Rico | 72025 | 8232 | |
1620764 | 1620764 | 2021-08-15 | Somerset | Pennsylvania | 42111 | 8232 | 219 |
1587259 | 1587259 | 2021-08-05 | Montcalm | Michigan | 26117 | 8232 | 121 |
1584008 | 1584008 | 2021-08-04 | Montcalm | Michigan | 26117 | 8232 | 121 |
1580759 | 1580759 | 2021-08-03 | Montcalm | Michigan | 26117 | 8232 | 121 |
1528203 | 1528203 | 2021-07-18 | Bartholomew | Indiana | 18005 | 8232 | 162 |
1529482 | 1529482 | 2021-07-18 | Sampson | North Carolina | 37163 | 8232 | 115 |
1524956 | 1524956 | 2021-07-17 | Bartholomew | Indiana | 18005 | 8232 | 162 |
1526235 | 1526235 | 2021-07-17 | Sampson | North Carolina | 37163 | 8232 | 115 |
1521708 | 1521708 | 2021-07-16 | Bartholomew | Indiana | 18005 | 8232 | 162 |
1522988 | 1522988 | 2021-07-16 | Sampson | North Carolina | 37163 | 8232 | 115 |
1512652 | 1512652 | 2021-07-13 | Rice | Minnesota | 27131 | 8232 | 111 |
1495197 | 1495197 | 2021-07-08 | Pope | Arkansas | 5115 | 8232 | 111 |
1363295 | 1363295 | 2021-05-28 | Clay | Minnesota | 27027 | 8232 | 92 |
1335172 | 1335172 | 2021-05-19 | Greenwood | South Carolina | 45047 | 8232 | 173 |
1329941 | 1329941 | 2021-05-18 | Gordon | Georgia | 13129 | 8232 | 117 |
1309792 | 1309792 | 2021-05-11 | Roanoke | Virginia | 51161 | 8232 | 144 |
1231870 | 1231870 | 2021-04-17 | Roanoke city | Virginia | 51770 | 8232 | 187 |
1139523 | 1139523 | 2021-03-20 | Cascade | Montana | 30013 | 8232 | 150 |
1046216 | 1046216 | 2021-02-19 | Oconee | South Carolina | 45073 | 8232 | 120 |
1008760 | 1008760 | 2021-02-08 | Vermilion | Illinois | 17183 | 8232 | 126 |
998354 | 998354 | 2021-02-05 | DeKalb | Alabama | 1049 | 8232 | 149 |
938122 | 938122 | 2021-01-17 | Madison | Mississippi | 28089 | 8232 | 162 |
667847 | 667847 | 2020-10-26 | Richmond | Georgia | 13245 | 8232 | 182 |
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);