ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 6875 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 16
- Oklahoma 7
- Virginia 7
- Georgia 4
- Florida 3
- Louisiana 3
- Arkansas 2
- Indiana 2
- Kansas 2
- Michigan 2
- Minnesota 2
- Mississippi 2
- Missouri 2
- New Mexico 2
- New York 2
- North Carolina 2
- Wisconsin 2
- Illinois 1
- Massachusetts 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499062 | 2499062 | 2022-05-12 | Howard | Texas | 48227 | 6875 | 184 |
2443657 | 2443657 | 2022-04-25 | Fannin | Texas | 48147 | 6875 | 183 |
2440401 | 2440401 | 2022-04-24 | Fannin | Texas | 48147 | 6875 | 183 |
2437145 | 2437145 | 2022-04-23 | Fannin | Texas | 48147 | 6875 | 183 |
2422212 | 2422212 | 2022-04-19 | White | Indiana | 18181 | 6875 | 96 |
2418956 | 2418956 | 2022-04-18 | White | Indiana | 18181 | 6875 | 96 |
2278708 | 2278708 | 2022-03-06 | Gilmer | Georgia | 13123 | 6875 | 165 |
2275455 | 2275455 | 2022-03-05 | Gilmer | Georgia | 13123 | 6875 | 165 |
2272202 | 2272202 | 2022-03-04 | Gilmer | Georgia | 13123 | 6875 | 165 |
2262427 | 2262427 | 2022-03-01 | Dawson | Georgia | 13085 | 6875 | 97 |
2258476 | 2258476 | 2022-02-27 | Halifax | Virginia | 51083 | 6875 | 143 |
2255225 | 2255225 | 2022-02-26 | Halifax | Virginia | 51083 | 6875 | 143 |
2251974 | 2251974 | 2022-02-25 | Halifax | Virginia | 51083 | 6875 | 143 |
2243869 | 2243869 | 2022-02-23 | Nobles | Minnesota | 27105 | 6875 | 58 |
2232145 | 2232145 | 2022-02-19 | Cass | Texas | 48067 | 6875 | 181 |
2220880 | 2220880 | 2022-02-16 | Jefferson Davis | Louisiana | 22053 | 6875 | 143 |
2221211 | 2221211 | 2022-02-16 | Simpson | Mississippi | 28127 | 6875 | 139 |
2222661 | 2222661 | 2022-02-16 | Accomack | Virginia | 51001 | 6875 | 102 |
2194695 | 2194695 | 2022-02-08 | Seward | Kansas | 20175 | 6875 | 59 |
2191441 | 2191441 | 2022-02-07 | Seward | Kansas | 20175 | 6875 | 59 |
2089430 | 2089430 | 2022-01-06 | York | Virginia | 51199 | 6875 | 87 |
2060070 | 2060070 | 2021-12-28 | Danville city | Virginia | 51590 | 6875 | 210 |
1990228 | 1990228 | 2021-12-07 | Morrison | Minnesota | 27097 | 6875 | 82 |
1970843 | 1970843 | 2021-12-01 | Warren | Mississippi | 28149 | 6875 | 178 |
1943987 | 1943987 | 2021-11-23 | Jefferson | Illinois | 17081 | 6875 | 148 |
1847725 | 1847725 | 2021-10-24 | Herkimer | New York | 36043 | 6875 | 128 |
1826323 | 1826323 | 2021-10-17 | Shawano | Wisconsin | 55115 | 6875 | 90 |
1809697 | 1809697 | 2021-10-12 | San Patricio | Texas | 48409 | 6875 | 268 |
1753713 | 1753713 | 2021-09-25 | Darke | Ohio | 39037 | 6875 | 137 |
1739763 | 1739763 | 2021-09-21 | Avoyelles | Louisiana | 22009 | 6875 | 168 |
1701918 | 1701918 | 2021-09-09 | Yamhill | Oregon | 41071 | 6875 | 91 |
1604362 | 1604362 | 2021-08-10 | Carter | Oklahoma | 40019 | 6875 | 132 |
1601113 | 1601113 | 2021-08-09 | Carter | Oklahoma | 40019 | 6875 | 132 |
1597865 | 1597865 | 2021-08-08 | Carter | Oklahoma | 40019 | 6875 | 132 |
1594027 | 1594027 | 2021-08-07 | Newton | Missouri | 29145 | 6875 | 94 |
1594616 | 1594616 | 2021-08-07 | Carter | Oklahoma | 40019 | 6875 | 132 |
1591367 | 1591367 | 2021-08-06 | Carter | Oklahoma | 40019 | 6875 | 132 |
1588118 | 1588118 | 2021-08-05 | Carter | Oklahoma | 40019 | 6875 | 132 |
1584262 | 1584262 | 2021-08-04 | Lincoln | Missouri | 29113 | 6875 | 53 |
1584868 | 1584868 | 2021-08-04 | Carter | Oklahoma | 40019 | 6875 | 132 |
1576347 | 1576347 | 2021-08-02 | Greene | Arkansas | 5055 | 6875 | 81 |
1324264 | 1324264 | 2021-05-16 | Gratiot | Michigan | 26057 | 6875 | 118 |
1321018 | 1321018 | 2021-05-15 | Gratiot | Michigan | 26057 | 6875 | 118 |
1246919 | 1246919 | 2021-04-22 | Valencia | New Mexico | 35061 | 6875 | 105 |
1215240 | 1215240 | 2021-04-12 | Bowie | Texas | 48037 | 6875 | 208 |
1195553 | 1195553 | 2021-04-06 | Laurens | South Carolina | 45059 | 6875 | 165 |
1181970 | 1181970 | 2021-04-02 | Chemung | New York | 36015 | 6875 | 131 |
1149962 | 1149962 | 2021-03-23 | Somerset | Pennsylvania | 42111 | 6875 | 185 |
1143134 | 1143134 | 2021-03-21 | Rutherford | North Carolina | 37161 | 6875 | 201 |
1139887 | 1139887 | 2021-03-20 | Rutherford | North Carolina | 37161 | 6875 | 201 |
1108811 | 1108811 | 2021-03-11 | Crawford | Arkansas | 5033 | 6875 | 111 |
1021397 | 1021397 | 2021-02-12 | Highlands | Florida | 12055 | 6875 | 282 |
1020833 | 1020833 | 2021-02-11 | Roanoke | Virginia | 51161 | 6875 | 89 |
965251 | 965251 | 2021-01-25 | Angelina | Texas | 48005 | 6875 | 206 |
962006 | 962006 | 2021-01-24 | Angelina | Texas | 48005 | 6875 | 205 |
958761 | 958761 | 2021-01-23 | Angelina | Texas | 48005 | 6875 | 203 |
955515 | 955515 | 2021-01-22 | Angelina | Texas | 48005 | 6875 | 201 |
952270 | 952270 | 2021-01-21 | Angelina | Texas | 48005 | 6875 | 200 |
910667 | 910667 | 2021-01-08 | St. Croix | Wisconsin | 55109 | 6875 | 34 |
885089 | 885089 | 2021-01-01 | Indian River | Florida | 12061 | 6875 | 159 |
881844 | 881844 | 2020-12-31 | Indian River | Florida | 12061 | 6875 | 159 |
812838 | 812838 | 2020-12-09 | Johnson | Texas | 48251 | 6875 | 122 |
801485 | 801485 | 2020-12-06 | Bossier | Louisiana | 22015 | 6875 | 158 |
688614 | 688614 | 2020-11-01 | Doña Ana | New Mexico | 35013 | 6875 | 82 |
689519 | 689519 | 2020-11-01 | Hays | Texas | 48209 | 6875 | 87 |
686274 | 686274 | 2020-10-31 | Hays | Texas | 48209 | 6875 | 87 |
683031 | 683031 | 2020-10-30 | Hays | Texas | 48209 | 6875 | 87 |
146378 | 146378 | 2020-05-15 | Plymouth | Massachusetts | 25023 | 6875 | 444 |
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);