ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where cases = 5225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Georgia 12
- Iowa 7
- Minnesota 6
- Puerto Rico 6
- Illinois 5
- New York 4
- North Carolina 4
- Ohio 4
- Virginia 4
- Tennessee 3
- Kentucky 2
- Michigan 2
- Missouri 2
- Pennsylvania 2
- Wisconsin 2
- Alabama 1
- Alaska 1
- Arkansas 1
- Connecticut 1
- Idaho 1
- Louisiana 1
- Maryland 1
- Mississippi 1
- Nebraska 1
- New Mexico 1
- Texas 1
- Utah 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381475 | 2381475 | 2022-04-06 | Las Piedras | Puerto Rico | 72085 | 5225 | |
2284882 | 2284882 | 2022-03-08 | Clark | Arkansas | 5019 | 5225 | 77 |
2281945 | 2281945 | 2022-03-07 | Dodge | Georgia | 13091 | 5225 | 146 |
2267646 | 2267646 | 2022-03-02 | San Lorenzo | Puerto Rico | 72129 | 5225 | |
2264393 | 2264393 | 2022-03-01 | San Lorenzo | Puerto Rico | 72129 | 5225 | |
2261143 | 2261143 | 2022-02-28 | San Lorenzo | Puerto Rico | 72129 | 5225 | |
2180348 | 2180348 | 2022-02-03 | Sevier | Utah | 49041 | 5225 | 24 |
2163535 | 2163535 | 2022-01-29 | Cidra | Puerto Rico | 72041 | 5225 | |
2117989 | 2117989 | 2022-01-15 | Corozal | Puerto Rico | 72047 | 5225 | |
2081994 | 2081994 | 2022-01-04 | Pike | Ohio | 39131 | 5225 | 82 |
2061817 | 2061817 | 2021-12-29 | Leflore | Mississippi | 28083 | 5225 | 144 |
1964231 | 1964231 | 2021-11-29 | Nobles | Minnesota | 27105 | 5225 | 54 |
1945665 | 1945665 | 2021-11-23 | Snyder | Pennsylvania | 42109 | 5225 | 110 |
1899163 | 1899163 | 2021-11-09 | Sanilac | Michigan | 26151 | 5225 | 139 |
1895913 | 1895913 | 2021-11-08 | Sanilac | Michigan | 26151 | 5225 | 139 |
1896150 | 1896150 | 2021-11-08 | Lawrence | Missouri | 29109 | 5225 | 107 |
1881620 | 1881620 | 2021-11-04 | Dallas | Alabama | 1047 | 5225 | 207 |
1772333 | 1772333 | 2021-10-01 | Calvert | Maryland | 24009 | 5225 | 95 |
1759502 | 1759502 | 2021-09-27 | McLeod | Minnesota | 27085 | 5225 | 65 |
1691321 | 1691321 | 2021-09-06 | Winona | Minnesota | 27169 | 5225 | 52 |
1688071 | 1688071 | 2021-09-05 | Winona | Minnesota | 27169 | 5225 | 52 |
1684821 | 1684821 | 2021-09-04 | Winona | Minnesota | 27169 | 5225 | 52 |
1681570 | 1681570 | 2021-09-03 | Winona | Minnesota | 27169 | 5225 | 52 |
1671279 | 1671279 | 2021-08-31 | Muscatine | Iowa | 19139 | 5225 | 107 |
1668032 | 1668032 | 2021-08-30 | Muscatine | Iowa | 19139 | 5225 | 107 |
1669302 | 1669302 | 2021-08-30 | Shelby | Ohio | 39149 | 5225 | 98 |
1670367 | 1670367 | 2021-08-30 | Pierce | Wisconsin | 55093 | 5225 | 44 |
1664325 | 1664325 | 2021-08-29 | Bryan | Georgia | 13029 | 5225 | 42 |
1664623 | 1664623 | 2021-08-29 | Woodford | Illinois | 17203 | 5225 | 97 |
1664785 | 1664785 | 2021-08-29 | Muscatine | Iowa | 19139 | 5225 | 107 |
1661077 | 1661077 | 2021-08-28 | Bryan | Georgia | 13029 | 5225 | 42 |
1661375 | 1661375 | 2021-08-28 | Woodford | Illinois | 17203 | 5225 | 97 |
1661537 | 1661537 | 2021-08-28 | Muscatine | Iowa | 19139 | 5225 | 107 |
1657829 | 1657829 | 2021-08-27 | Bryan | Georgia | 13029 | 5225 | 42 |
1658127 | 1658127 | 2021-08-27 | Woodford | Illinois | 17203 | 5225 | 97 |
1658289 | 1658289 | 2021-08-27 | Muscatine | Iowa | 19139 | 5225 | 107 |
1655041 | 1655041 | 2021-08-26 | Muscatine | Iowa | 19139 | 5225 | 107 |
1651794 | 1651794 | 2021-08-25 | Muscatine | Iowa | 19139 | 5225 | 107 |
1644173 | 1644173 | 2021-08-22 | James City | Virginia | 51095 | 5225 | 73 |
1640923 | 1640923 | 2021-08-21 | James City | Virginia | 51095 | 5225 | 73 |
1637673 | 1637673 | 2021-08-20 | James City | Virginia | 51095 | 5225 | 73 |
1532610 | 1532610 | 2021-07-19 | Herkimer | New York | 36043 | 5225 | 110 |
1529363 | 1529363 | 2021-07-18 | Herkimer | New York | 36043 | 5225 | 110 |
1526116 | 1526116 | 2021-07-17 | Herkimer | New York | 36043 | 5225 | 110 |
1522869 | 1522869 | 2021-07-16 | Herkimer | New York | 36043 | 5225 | 110 |
1508472 | 1508472 | 2021-07-12 | Habersham | Georgia | 13137 | 5225 | 164 |
1505226 | 1505226 | 2021-07-11 | Habersham | Georgia | 13137 | 5225 | 164 |
1501980 | 1501980 | 2021-07-10 | Habersham | Georgia | 13137 | 5225 | 164 |
1498734 | 1498734 | 2021-07-09 | Habersham | Georgia | 13137 | 5225 | 164 |
1495487 | 1495487 | 2021-07-08 | Habersham | Georgia | 13137 | 5225 | 164 |
1492241 | 1492241 | 2021-07-07 | Habersham | Georgia | 13137 | 5225 | 164 |
1444928 | 1444928 | 2021-06-22 | Otero | New Mexico | 35035 | 5225 | 80 |
1415802 | 1415802 | 2021-06-13 | Carteret | North Carolina | 37031 | 5225 | 56 |
1412556 | 1412556 | 2021-06-12 | Carteret | North Carolina | 37031 | 5225 | 56 |
1409311 | 1409311 | 2021-06-11 | Carteret | North Carolina | 37031 | 5225 | 56 |
1380247 | 1380247 | 2021-06-02 | Athens | Ohio | 39009 | 5225 | 60 |
1214204 | 1214204 | 2021-04-12 | Taney | Missouri | 29213 | 5225 | 90 |
1208181 | 1208181 | 2021-04-10 | Darke | Ohio | 39037 | 5225 | 121 |
1147416 | 1147416 | 2021-03-22 | Pittsylvania | Virginia | 51143 | 5225 | 75 |
1142829 | 1142829 | 2021-03-21 | Buffalo | Nebraska | 31019 | 5225 | 56 |
1126082 | 1126082 | 2021-03-16 | St. Charles | Louisiana | 22089 | 5225 | 90 |
1111594 | 1111594 | 2021-03-11 | Chittenden | Vermont | 50007 | 5225 | 91 |
1091856 | 1091856 | 2021-03-05 | Caldwell | Texas | 48055 | 5225 | 87 |
1081412 | 1081412 | 2021-03-02 | Granville | North Carolina | 37077 | 5225 | 76 |
1065790 | 1065790 | 2021-02-25 | Dyer | Tennessee | 47045 | 5225 | 101 |
1060502 | 1060502 | 2021-02-24 | Polk | Georgia | 13233 | 5225 | 78 |
986445 | 986445 | 2021-02-01 | Pulaski | Kentucky | 21199 | 5225 | 77 |
978184 | 978184 | 2021-01-29 | Loudon | Tennessee | 47105 | 5225 | 57 |
937687 | 937687 | 2021-01-17 | Christian | Kentucky | 21047 | 5225 | 69 |
921135 | 921135 | 2021-01-12 | Whiteside | Illinois | 17195 | 5225 | 172 |
917890 | 917890 | 2021-01-11 | Whiteside | Illinois | 17195 | 5225 | 171 |
907532 | 907532 | 2021-01-08 | Fairbanks North Star Borough | Alaska | 2090 | 5225 | 20 |
898036 | 898036 | 2021-01-05 | Tolland | Connecticut | 9013 | 5225 | 113 |
896786 | 896786 | 2021-01-04 | Northumberland | Pennsylvania | 42097 | 5225 | 236 |
867876 | 867876 | 2020-12-26 | Tipton | Tennessee | 47167 | 5225 | 51 |
781287 | 781287 | 2020-11-30 | Bartow | Georgia | 13015 | 5225 | 107 |
761350 | 761350 | 2020-11-23 | Jefferson | Wisconsin | 55055 | 5225 | 34 |
713339 | 713339 | 2020-11-09 | Twin Falls | Idaho | 16083 | 5225 | 61 |
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);