ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 8788 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Missouri 5
- Georgia 4
- New York 4
- Arkansas 3
- Idaho 3
- Kentucky 3
- Minnesota 3
- Virginia 3
- Alabama 2
- North Dakota 2
- California 1
- Hawaii 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- New Jersey 1
- North Carolina 1
- Ohio 1
- Texas 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441065 | 2441065 | 2022-04-25 | Baxter | Arkansas | 5005 | 8788 | 247 |
2433055 | 2433055 | 2022-04-22 | Greene | New York | 36039 | 8788 | 125 |
2328628 | 2328628 | 2022-03-21 | Pulaski | Missouri | 29169 | 8788 | 114 |
2324357 | 2324357 | 2022-03-20 | Bonner | Idaho | 16017 | 8788 | 179 |
2321103 | 2321103 | 2022-03-19 | Bonner | Idaho | 16017 | 8788 | 179 |
2317849 | 2317849 | 2022-03-18 | Bonner | Idaho | 16017 | 8788 | 179 |
2279593 | 2279593 | 2022-03-06 | Carlton | Minnesota | 27017 | 8788 | 95 |
2276340 | 2276340 | 2022-03-05 | Carlton | Minnesota | 27017 | 8788 | 95 |
2273087 | 2273087 | 2022-03-04 | Carlton | Minnesota | 27017 | 8788 | 95 |
2235741 | 2235741 | 2022-02-20 | Manassas city | Virginia | 51683 | 8788 | 65 |
2232490 | 2232490 | 2022-02-19 | Manassas city | Virginia | 51683 | 8788 | 65 |
2229239 | 2229239 | 2022-02-18 | Manassas city | Virginia | 51683 | 8788 | 65 |
2177628 | 2177628 | 2022-02-03 | Union | Arkansas | 5139 | 8788 | 159 |
2106302 | 2106302 | 2022-01-12 | Coffee | Georgia | 13069 | 8788 | 249 |
2088405 | 2088405 | 2022-01-06 | Morton | North Dakota | 38059 | 8788 | 131 |
1994251 | 1994251 | 2021-12-08 | Washington | Ohio | 39167 | 8788 | 159 |
1994736 | 1994736 | 2021-12-08 | Atascosa | Texas | 48013 | 8788 | 208 |
1989009 | 1989009 | 2021-12-07 | Mississippi | Arkansas | 5093 | 8788 | 152 |
1937856 | 1937856 | 2021-11-21 | Boyd | Kentucky | 21019 | 8788 | 112 |
1934606 | 1934606 | 2021-11-20 | Boyd | Kentucky | 21019 | 8788 | 112 |
1931355 | 1931355 | 2021-11-19 | Boyd | Kentucky | 21019 | 8788 | 112 |
1778066 | 1778066 | 2021-10-03 | Effingham | Georgia | 13103 | 8788 | 142 |
1774816 | 1774816 | 2021-10-02 | Effingham | Georgia | 13103 | 8788 | 142 |
1771566 | 1771566 | 2021-10-01 | Effingham | Georgia | 13103 | 8788 | 142 |
1752837 | 1752837 | 2021-09-25 | Allegany | Maryland | 24001 | 8788 | 231 |
1706704 | 1706704 | 2021-09-11 | Hawaii | Hawaii | 15001 | 8788 | 65 |
1361811 | 1361811 | 2021-05-27 | Cabell | West Virginia | 54011 | 8788 | 173 |
1318353 | 1318353 | 2021-05-14 | Chautauqua | New York | 36013 | 8788 | 140 |
1184962 | 1184962 | 2021-04-03 | St. Francois | Missouri | 29187 | 8788 | 110 |
1052144 | 1052144 | 2021-02-21 | Rensselaer | New York | 36083 | 8788 | 130 |
1024315 | 1024315 | 2021-02-13 | Cullman | Alabama | 1043 | 8788 | 171 |
951701 | 951701 | 2021-01-21 | Ward | North Dakota | 38101 | 8788 | 186 |
902945 | 902945 | 2021-01-06 | Randolph | North Carolina | 37151 | 8788 | 133 |
899569 | 899569 | 2021-01-05 | Broome | New York | 36007 | 8788 | 215 |
846023 | 846023 | 2020-12-20 | San Luis Obispo | California | 6079 | 8788 | 59 |
843804 | 843804 | 2020-12-19 | Berrien | Michigan | 26021 | 8788 | 166 |
826363 | 826363 | 2020-12-14 | Lee | Alabama | 1081 | 8788 | 73 |
803416 | 803416 | 2020-12-06 | Benton | Washington | 53005 | 8788 | 150 |
642913 | 642913 | 2020-10-18 | Greene | Missouri | 29077 | 8788 | 121 |
639665 | 639665 | 2020-10-17 | Greene | Missouri | 29077 | 8788 | 121 |
636419 | 636419 | 2020-10-16 | Greene | Missouri | 29077 | 8788 | 121 |
432792 | 432792 | 2020-08-14 | Camden | New Jersey | 34007 | 8788 | 581 |
361459 | 361459 | 2020-07-23 | Bristol | Massachusetts | 25005 | 8788 | 615 |
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);