ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 2857 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- Kentucky 15
- Missouri 11
- Indiana 9
- Ohio 9
- Tennessee 7
- Virginia 7
- Georgia 6
- Alabama 5
- Louisiana 5
- North Carolina 5
- West Virginia 5
- Wisconsin 5
- Arkansas 4
- Minnesota 4
- California 3
- Illinois 3
- Maryland 3
- Mississippi 3
- Puerto Rico 3
- Washington 3
- Florida 2
- Pennsylvania 2
- South Carolina 2
- Utah 2
- Arizona 1
- Colorado 1
- Kansas 1
- Maine 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502579 | 2502579 | 2022-05-13 | Lexington city | Virginia | 51678 | 2857 | 40 |
2497823 | 2497823 | 2022-05-12 | Barton | Missouri | 29011 | 2857 | 52 |
2494565 | 2494565 | 2022-05-11 | Barton | Missouri | 29011 | 2857 | 52 |
2491307 | 2491307 | 2022-05-10 | Barton | Missouri | 29011 | 2857 | 52 |
2488049 | 2488049 | 2022-05-09 | Barton | Missouri | 29011 | 2857 | 52 |
2484792 | 2484792 | 2022-05-08 | Barton | Missouri | 29011 | 2857 | 52 |
2481534 | 2481534 | 2022-05-07 | Barton | Missouri | 29011 | 2857 | 52 |
2478276 | 2478276 | 2022-05-06 | Barton | Missouri | 29011 | 2857 | 52 |
2417565 | 2417565 | 2022-04-17 | Callahan | Texas | 48059 | 2857 | 72 |
2414309 | 2414309 | 2022-04-16 | Callahan | Texas | 48059 | 2857 | 72 |
2411053 | 2411053 | 2022-04-15 | Callahan | Texas | 48059 | 2857 | 72 |
2407797 | 2407797 | 2022-04-14 | Callahan | Texas | 48059 | 2857 | 72 |
2347649 | 2347649 | 2022-03-27 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2348953 | 2348953 | 2022-03-27 | Orocovis | Puerto Rico | 72107 | 2857 | |
2344396 | 2344396 | 2022-03-26 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2345700 | 2345700 | 2022-03-26 | Orocovis | Puerto Rico | 72107 | 2857 | |
2341143 | 2341143 | 2022-03-25 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2337890 | 2337890 | 2022-03-24 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2334636 | 2334636 | 2022-03-23 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2331382 | 2331382 | 2022-03-22 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2328130 | 2328130 | 2022-03-21 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2216122 | 2216122 | 2022-02-14 | Juab | Utah | 49023 | 2857 | 22 |
2200236 | 2200236 | 2022-02-10 | Coosa | Alabama | 1037 | 2857 | 53 |
2148874 | 2148874 | 2022-01-25 | Blackford | Indiana | 18009 | 2857 | 61 |
2114423 | 2114423 | 2022-01-14 | Ramsey | North Dakota | 38071 | 2857 | 47 |
2110216 | 2110216 | 2022-01-13 | Monroe | Kentucky | 21171 | 2857 | 69 |
2110689 | 2110689 | 2022-01-13 | Madison | Missouri | 29123 | 2857 | 45 |
2103289 | 2103289 | 2022-01-11 | Massac | Illinois | 17127 | 2857 | 64 |
2063258 | 2063258 | 2021-12-29 | San Juan | Utah | 49037 | 2857 | 45 |
2056805 | 2056805 | 2021-12-27 | Buckingham | Virginia | 51029 | 2857 | 41 |
2053757 | 2053757 | 2021-12-26 | Taylor | West Virginia | 54091 | 2857 | 50 |
2047516 | 2047516 | 2021-12-25 | Madison | Arkansas | 5087 | 2857 | 44 |
2050507 | 2050507 | 2021-12-25 | Taylor | West Virginia | 54091 | 2857 | 50 |
2047257 | 2047257 | 2021-12-24 | Taylor | West Virginia | 54091 | 2857 | 50 |
2044007 | 2044007 | 2021-12-23 | Taylor | West Virginia | 54091 | 2857 | 50 |
2009924 | 2009924 | 2021-12-13 | Moniteau | Missouri | 29135 | 2857 | 46 |
1970554 | 1970554 | 2021-12-01 | Waldo | Maine | 23027 | 2857 | 36 |
1919306 | 1919306 | 2021-11-15 | Madison | North Carolina | 37115 | 2857 | 62 |
1906460 | 1906460 | 2021-11-11 | Meigs | Ohio | 39105 | 2857 | 57 |
1877050 | 1877050 | 2021-11-02 | Hertford | North Carolina | 37091 | 2857 | 72 |
1877658 | 1877658 | 2021-11-02 | Grundy | Tennessee | 47061 | 2857 | 38 |
1873801 | 1873801 | 2021-11-01 | Hertford | North Carolina | 37091 | 2857 | 71 |
1874587 | 1874587 | 2021-11-01 | Houston | Texas | 48225 | 2857 | 80 |
1871338 | 1871338 | 2021-10-31 | Houston | Texas | 48225 | 2857 | 80 |
1868089 | 1868089 | 2021-10-30 | Houston | Texas | 48225 | 2857 | 80 |
1864227 | 1864227 | 2021-10-29 | Paulding | Ohio | 39125 | 2857 | 47 |
1861591 | 1861591 | 2021-10-28 | Houston | Texas | 48225 | 2857 | 80 |
1801131 | 1801131 | 2021-10-10 | Orange | Indiana | 18117 | 2857 | 64 |
1797882 | 1797882 | 2021-10-09 | Orange | Indiana | 18117 | 2857 | 64 |
1794633 | 1794633 | 2021-10-08 | Orange | Indiana | 18117 | 2857 | 64 |
1795941 | 1795941 | 2021-10-08 | Carroll | Ohio | 39019 | 2857 | 57 |
1767600 | 1767600 | 2021-09-29 | Fredericksburg city | Virginia | 51630 | 2857 | 25 |
1746145 | 1746145 | 2021-09-23 | Bourbon | Kentucky | 21017 | 2857 | 23 |
1719332 | 1719332 | 2021-09-15 | Colusa | California | 6011 | 2857 | 18 |
1715948 | 1715948 | 2021-09-14 | Randolph | Alabama | 1111 | 2857 | 55 |
1718490 | 1718490 | 2021-09-14 | Polk | Tennessee | 47139 | 2857 | 25 |
1712838 | 1712838 | 2021-09-13 | Colusa | California | 6011 | 2857 | 18 |
1708556 | 1708556 | 2021-09-11 | Vega Alta | Puerto Rico | 72143 | 2857 | |
1697526 | 1697526 | 2021-09-08 | Woodford | Kentucky | 21239 | 2857 | 23 |
1699400 | 1699400 | 2021-09-08 | Lee | Virginia | 51105 | 2857 | 48 |
1695300 | 1695300 | 2021-09-07 | Van Wert | Ohio | 39161 | 2857 | 68 |
1683533 | 1683533 | 2021-09-04 | Conway | Arkansas | 5029 | 2857 | 41 |
1677403 | 1677403 | 2021-09-02 | Morgan | Georgia | 13211 | 2857 | 31 |
1668540 | 1668540 | 2021-08-30 | Meeker | Minnesota | 27093 | 2857 | 46 |
1669932 | 1669932 | 2021-08-30 | Lampasas | Texas | 48281 | 2857 | 40 |
1667099 | 1667099 | 2021-08-29 | Jackson | Wisconsin | 55053 | 2857 | 29 |
1663851 | 1663851 | 2021-08-28 | Jackson | Wisconsin | 55053 | 2857 | 29 |
1660603 | 1660603 | 2021-08-27 | Jackson | Wisconsin | 55053 | 2857 | 29 |
1644859 | 1644859 | 2021-08-23 | Cook | Georgia | 13075 | 2857 | 45 |
1646848 | 1646848 | 2021-08-23 | Abbeville | South Carolina | 45001 | 2857 | 42 |
1641930 | 1641930 | 2021-08-22 | LaGrange | Indiana | 18087 | 2857 | 75 |
1638680 | 1638680 | 2021-08-21 | LaGrange | Indiana | 18087 | 2857 | 75 |
1635430 | 1635430 | 2021-08-20 | LaGrange | Indiana | 18087 | 2857 | 75 |
1632600 | 1632600 | 2021-08-19 | St. James | Louisiana | 22093 | 2857 | 57 |
1630093 | 1630093 | 2021-08-18 | Anson | North Carolina | 37007 | 2857 | 59 |
1624401 | 1624401 | 2021-08-16 | Gillespie | Texas | 48171 | 2857 | 54 |
1621154 | 1621154 | 2021-08-15 | Gillespie | Texas | 48171 | 2857 | 54 |
1617906 | 1617906 | 2021-08-14 | Gillespie | Texas | 48171 | 2857 | 54 |
1606535 | 1606535 | 2021-08-11 | Mercer | Kentucky | 21167 | 2857 | 52 |
1585767 | 1585767 | 2021-08-04 | Wythe | Virginia | 51197 | 2857 | 81 |
1562577 | 1562577 | 2021-07-28 | Smith | Tennessee | 47159 | 2857 | 40 |
1559804 | 1559804 | 2021-07-27 | Okanogan | Washington | 53047 | 2857 | 42 |
1533911 | 1533911 | 2021-07-19 | Door | Wisconsin | 55029 | 2857 | 33 |
1521069 | 1521069 | 2021-07-16 | Winston | Alabama | 1133 | 2857 | 72 |
1512472 | 1512472 | 2021-07-13 | Dorchester | Maryland | 24019 | 2857 | 65 |
1509225 | 1509225 | 2021-07-12 | Dorchester | Maryland | 24019 | 2857 | 65 |
1505979 | 1505979 | 2021-07-11 | Dorchester | Maryland | 24019 | 2857 | 65 |
1449705 | 1449705 | 2021-06-24 | Carroll | Arkansas | 5015 | 2857 | 46 |
1450674 | 1450674 | 2021-06-24 | Montgomery | Kentucky | 21173 | 2857 | 30 |
1451670 | 1451670 | 2021-06-24 | Fayette | Ohio | 39047 | 2857 | 50 |
1447744 | 1447744 | 2021-06-23 | Todd | Minnesota | 27153 | 2857 | 33 |
1448424 | 1448424 | 2021-06-23 | Fayette | Ohio | 39047 | 2857 | 50 |
1423882 | 1423882 | 2021-06-16 | Delta | Colorado | 8029 | 2857 | 64 |
1402056 | 1402056 | 2021-06-09 | Morehouse | Louisiana | 22067 | 2857 | 78 |
1398811 | 1398811 | 2021-06-08 | Morehouse | Louisiana | 22067 | 2857 | 78 |
1397491 | 1397491 | 2021-06-07 | Mason | Washington | 53045 | 2857 | 33 |
1358049 | 1358049 | 2021-05-26 | McNairy | Tennessee | 47109 | 2857 | 54 |
1293605 | 1293605 | 2021-05-06 | Kittitas | Washington | 53037 | 2857 | 33 |
1288465 | 1288465 | 2021-05-05 | West Baton Rouge | Louisiana | 22121 | 2857 | 59 |
1233985 | 1233985 | 2021-04-18 | Washington | New York | 36115 | 2857 | 55 |
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);