ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 6489 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kansas 9
- Virginia 6
- Kentucky 5
- Michigan 5
- Minnesota 4
- Texas 4
- Georgia 3
- Idaho 3
- Illinois 3
- Ohio 3
- California 2
- Indiana 2
- Maine 2
- Mississippi 2
- New Mexico 2
- North Carolina 2
- South Carolina 2
- West Virginia 2
- Arkansas 1
- Louisiana 1
- Massachusetts 1
- Nebraska 1
- New Hampshire 1
- Pennsylvania 1
- Puerto Rico 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2406038 | 2406038 | 2022-04-14 | Barton | Kansas | 20009 | 6489 | 96 |
2402782 | 2402782 | 2022-04-13 | Barton | Kansas | 20009 | 6489 | 96 |
2399528 | 2399528 | 2022-04-12 | Barton | Kansas | 20009 | 6489 | 96 |
2396272 | 2396272 | 2022-04-11 | Barton | Kansas | 20009 | 6489 | 96 |
2393017 | 2393017 | 2022-04-10 | Barton | Kansas | 20009 | 6489 | 96 |
2389761 | 2389761 | 2022-04-09 | Barton | Kansas | 20009 | 6489 | 96 |
2386505 | 2386505 | 2022-04-08 | Barton | Kansas | 20009 | 6489 | 96 |
2247564 | 2247564 | 2022-02-24 | Grant | New Mexico | 35017 | 6489 | 76 |
2245210 | 2245210 | 2022-02-23 | Hale | Texas | 48189 | 6489 | 234 |
2245438 | 2245438 | 2022-02-23 | Carroll | Virginia | 51035 | 6489 | 132 |
2187655 | 2187655 | 2022-02-06 | Gilmer | Georgia | 13123 | 6489 | 153 |
2184402 | 2184402 | 2022-02-05 | Gilmer | Georgia | 13123 | 6489 | 153 |
2181150 | 2181150 | 2022-02-04 | Gilmer | Georgia | 13123 | 6489 | 153 |
2177215 | 2177215 | 2022-02-02 | Orange | Virginia | 51137 | 6489 | 75 |
2155402 | 2155402 | 2022-01-27 | Greene | Indiana | 18055 | 6489 | 121 |
2149087 | 2149087 | 2022-01-25 | Ellis | Kansas | 20051 | 6489 | 78 |
2145835 | 2145835 | 2022-01-24 | Ellis | Kansas | 20051 | 6489 | 78 |
2122014 | 2122014 | 2022-01-16 | Mineral | West Virginia | 54057 | 6489 | 139 |
2092746 | 2092746 | 2022-01-07 | Marshall | West Virginia | 54051 | 6489 | 134 |
2078031 | 2078031 | 2022-01-03 | Alcorn | Mississippi | 28003 | 6489 | 115 |
2037220 | 2037220 | 2021-12-21 | Uvalde | Texas | 48463 | 6489 | 118 |
2027975 | 2027975 | 2021-12-19 | Baxter | Arkansas | 5005 | 6489 | 196 |
1969919 | 1969919 | 2021-12-01 | Bonner | Idaho | 16017 | 6489 | 128 |
1938220 | 1938220 | 2021-11-21 | Morrison | Minnesota | 27097 | 6489 | 77 |
1934970 | 1934970 | 2021-11-20 | Morrison | Minnesota | 27097 | 6489 | 77 |
1931720 | 1931720 | 2021-11-19 | Morrison | Minnesota | 27097 | 6489 | 77 |
1883678 | 1883678 | 2021-11-04 | Defiance | Ohio | 39039 | 6489 | 109 |
1875845 | 1875845 | 2021-11-02 | Knox | Indiana | 18083 | 6489 | 111 |
1807071 | 1807071 | 2021-10-12 | Lake | California | 6033 | 6489 | 97 |
1778663 | 1778663 | 2021-10-03 | Franklin | Kentucky | 21073 | 6489 | 71 |
1775413 | 1775413 | 2021-10-02 | Franklin | Kentucky | 21073 | 6489 | 71 |
1772163 | 1772163 | 2021-10-01 | Franklin | Kentucky | 21073 | 6489 | 71 |
1770866 | 1770866 | 2021-09-30 | James City | Virginia | 51095 | 6489 | 88 |
1762415 | 1762415 | 2021-09-28 | Floyd | Kentucky | 21071 | 6489 | 94 |
1759594 | 1759594 | 2021-09-27 | Neshoba | Mississippi | 28099 | 6489 | 201 |
1705187 | 1705187 | 2021-09-10 | Columbia | Pennsylvania | 42037 | 6489 | 139 |
1694408 | 1694408 | 2021-09-07 | Barry | Michigan | 26015 | 6489 | 74 |
1636787 | 1636787 | 2021-08-20 | Lawrence | Ohio | 39087 | 6489 | 108 |
1632104 | 1632104 | 2021-08-19 | Ogle | Illinois | 17141 | 6489 | 92 |
1633407 | 1633407 | 2021-08-19 | Pender | North Carolina | 37141 | 6489 | 72 |
1588385 | 1588385 | 2021-08-05 | Cherokee | South Carolina | 45021 | 6489 | 159 |
1567660 | 1567660 | 2021-07-30 | Penobscot | Maine | 23019 | 6489 | 106 |
1532678 | 1532678 | 2021-07-19 | Duplin | North Carolina | 37061 | 6489 | 142 |
1509283 | 1509283 | 2021-07-12 | Grand Traverse | Michigan | 26055 | 6489 | 100 |
1506037 | 1506037 | 2021-07-11 | Grand Traverse | Michigan | 26055 | 6489 | 100 |
1502791 | 1502791 | 2021-07-10 | Grand Traverse | Michigan | 26055 | 6489 | 100 |
1499545 | 1499545 | 2021-07-09 | Grand Traverse | Michigan | 26055 | 6489 | 100 |
1440096 | 1440096 | 2021-06-21 | Yuba | California | 6115 | 6489 | 51 |
1376129 | 1376129 | 2021-06-01 | Kennebec | Maine | 23011 | 6489 | 71 |
1335716 | 1335716 | 2021-05-19 | Harrisonburg city | Virginia | 51660 | 6489 | 94 |
1286622 | 1286622 | 2021-05-04 | McMinn | Tennessee | 47107 | 6489 | 98 |
1282134 | 1282134 | 2021-05-03 | Crow Wing | Minnesota | 27035 | 6489 | 87 |
1184063 | 1184063 | 2021-04-03 | Whiteside | Illinois | 17195 | 6489 | 201 |
1183193 | 1183193 | 2021-04-02 | Kitsap | Washington | 53035 | 6489 | 95 |
1091051 | 1091051 | 2021-03-05 | Valencia | New Mexico | 35061 | 6489 | 99 |
1086977 | 1086977 | 2021-03-04 | Bullitt | Kentucky | 21029 | 6489 | 49 |
1035819 | 1035819 | 2021-02-16 | Strafford | New Hampshire | 33017 | 6489 | 70 |
1027336 | 1027336 | 2021-02-13 | Suffolk city | Virginia | 51800 | 6489 | 120 |
929047 | 929047 | 2021-01-14 | Muskingum | Ohio | 39119 | 6489 | 39 |
916804 | 916804 | 2021-01-10 | Walker | Texas | 48471 | 6489 | 90 |
891788 | 891788 | 2021-01-03 | Bannock | Idaho | 16005 | 6489 | 65 |
888541 | 888541 | 2021-01-02 | Bannock | Idaho | 16005 | 6489 | 65 |
792961 | 792961 | 2020-12-03 | Bayamon | Puerto Rico | 72021 | 6489 | |
783340 | 783340 | 2020-11-30 | Pickens | South Carolina | 45077 | 6489 | 88 |
537406 | 537406 | 2020-09-15 | Loudoun | Virginia | 51107 | 6489 | 119 |
516176 | 516176 | 2020-09-09 | St. Tammany | Louisiana | 22103 | 6489 | 245 |
459554 | 459554 | 2020-08-22 | Jefferson | Texas | 48245 | 6489 | 101 |
263593 | 263593 | 2020-06-22 | Douglas | Nebraska | 31055 | 6489 | 80 |
241333 | 241333 | 2020-06-15 | Hampden | Massachusetts | 25013 | 6489 | 640 |
151837 | 151837 | 2020-05-17 | Lake | Illinois | 17097 | 6489 | 215 |
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);