ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 5758 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Texas 9
- Louisiana 7
- Illinois 6
- Georgia 5
- Michigan 4
- Pennsylvania 4
- Virginia 4
- Arkansas 3
- New York 3
- Puerto Rico 3
- Alabama 2
- Kansas 2
- Maryland 2
- Minnesota 2
- Missouri 2
- Ohio 2
- Tennessee 2
- California 1
- Florida 1
- Idaho 1
- Indiana 1
- Kentucky 1
- North Carolina 1
- South Carolina 1
- South Dakota 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501117 | 2501117 | 2022-05-13 | Henry | Missouri | 29083 | 5758 | 86 |
2463127 | 2463127 | 2022-05-01 | Austin | Texas | 48015 | 5758 | 73 |
2404639 | 2404639 | 2022-04-13 | Karnes | Texas | 48255 | 5758 | 70 |
2358696 | 2358696 | 2022-03-30 | Juana Diaz | Puerto Rico | 72075 | 5758 | |
2220742 | 2220742 | 2022-02-16 | Bourbon | Kentucky | 21017 | 5758 | 49 |
2196193 | 2196193 | 2022-02-08 | Davison | South Dakota | 46035 | 5758 | 79 |
2192896 | 2192896 | 2022-02-07 | Fairfield | South Carolina | 45039 | 5758 | 101 |
2133050 | 2133050 | 2022-01-20 | Morehouse | Louisiana | 22067 | 5758 | 120 |
2058665 | 2058665 | 2021-12-28 | Lawrence | Missouri | 29109 | 5758 | 139 |
2028531 | 2028531 | 2021-12-19 | Montgomery | Illinois | 17135 | 5758 | 91 |
2025280 | 2025280 | 2021-12-18 | Montgomery | Illinois | 17135 | 5758 | 91 |
2022029 | 2022029 | 2021-12-17 | Montgomery | Illinois | 17135 | 5758 | 91 |
1978242 | 1978242 | 2021-12-03 | Ponce | Puerto Rico | 72113 | 5758 | |
1973283 | 1973283 | 2021-12-02 | Randolph | Illinois | 17157 | 5758 | 109 |
1968726 | 1968726 | 2021-11-30 | White | Tennessee | 47185 | 5758 | 98 |
1942944 | 1942944 | 2021-11-22 | Titus | Texas | 48449 | 5758 | 104 |
1939694 | 1939694 | 2021-11-21 | Titus | Texas | 48449 | 5758 | 104 |
1936444 | 1936444 | 2021-11-20 | Titus | Texas | 48449 | 5758 | 104 |
1887710 | 1887710 | 2021-11-05 | Washington | Texas | 48477 | 5758 | 129 |
1884460 | 1884460 | 2021-11-04 | Washington | Texas | 48477 | 5758 | 128 |
1874178 | 1874178 | 2021-11-01 | Wayne | Pennsylvania | 42127 | 5758 | 109 |
1870929 | 1870929 | 2021-10-31 | Wayne | Pennsylvania | 42127 | 5758 | 109 |
1850464 | 1850464 | 2021-10-25 | Isanti | Minnesota | 27059 | 5758 | 74 |
1825187 | 1825187 | 2021-10-17 | Clinton | Ohio | 39027 | 5758 | 90 |
1813479 | 1813479 | 2021-10-14 | Baxter | Arkansas | 5005 | 5758 | 174 |
1805943 | 1805943 | 2021-10-11 | Venango | Pennsylvania | 42121 | 5758 | 118 |
1781467 | 1781467 | 2021-10-04 | Nez Perce | Idaho | 16069 | 5758 | 86 |
1782956 | 1782956 | 2021-10-04 | Defiance | Ohio | 39039 | 5758 | 101 |
1748414 | 1748414 | 2021-09-24 | Franklin | Alabama | 1059 | 5758 | 101 |
1652909 | 1652909 | 2021-08-25 | Richmond | North Carolina | 37153 | 5758 | 114 |
1572439 | 1572439 | 2021-07-31 | Harrison | Texas | 48203 | 5758 | 112 |
1539088 | 1539088 | 2021-07-21 | Cattaraugus | New York | 36009 | 5758 | 92 |
1528667 | 1528667 | 2021-07-18 | St. Martin | Louisiana | 22099 | 5758 | 119 |
1525420 | 1525420 | 2021-07-17 | St. Martin | Louisiana | 22099 | 5758 | 119 |
1522172 | 1522172 | 2021-07-16 | St. Martin | Louisiana | 22099 | 5758 | 119 |
1514984 | 1514984 | 2021-07-14 | Laurens | Georgia | 13175 | 5758 | 173 |
1505933 | 1505933 | 2021-07-11 | St. Charles | Louisiana | 22089 | 5758 | 98 |
1502687 | 1502687 | 2021-07-10 | St. Charles | Louisiana | 22089 | 5758 | 98 |
1499441 | 1499441 | 2021-07-09 | St. Charles | Louisiana | 22089 | 5758 | 98 |
1492288 | 1492288 | 2021-07-07 | Polk | Georgia | 13233 | 5758 | 100 |
1404762 | 1404762 | 2021-06-10 | Coles | Illinois | 17029 | 5758 | 102 |
1389819 | 1389819 | 2021-06-05 | Wayne | New York | 36117 | 5758 | 69 |
1355804 | 1355804 | 2021-05-26 | Gadsden | Florida | 12039 | 5758 | 99 |
1324375 | 1324375 | 2021-05-16 | Otter Tail | Minnesota | 27111 | 5758 | 78 |
1314178 | 1314178 | 2021-05-13 | Ford | Kansas | 20057 | 5758 | 75 |
1310931 | 1310931 | 2021-05-12 | Ford | Kansas | 20057 | 5758 | 75 |
1306441 | 1306441 | 2021-05-10 | Albemarle | Virginia | 51003 | 5758 | 83 |
1303195 | 1303195 | 2021-05-09 | Albemarle | Virginia | 51003 | 5758 | 83 |
1293416 | 1293416 | 2021-05-06 | Iron | Utah | 49021 | 5758 | 32 |
1256036 | 1256036 | 2021-04-25 | St. Mary's | Maryland | 24037 | 5758 | 123 |
1240902 | 1240902 | 2021-04-20 | Union | Pennsylvania | 42119 | 5758 | 86 |
1232860 | 1232860 | 2021-04-18 | Shelby | Indiana | 18145 | 5758 | 105 |
1218423 | 1218423 | 2021-04-13 | Lawrence | Tennessee | 47099 | 5758 | 86 |
1186768 | 1186768 | 2021-04-04 | Mississippi | Arkansas | 5093 | 5758 | 106 |
1169892 | 1169892 | 2021-03-29 | Lamar | Texas | 48277 | 5758 | 152 |
1146289 | 1146289 | 2021-03-22 | Steuben | New York | 36101 | 5758 | 140 |
1132712 | 1132712 | 2021-03-18 | Montcalm | Michigan | 26117 | 5758 | 96 |
1037414 | 1037414 | 2021-02-17 | Greene | Arkansas | 5055 | 5758 | 74 |
989128 | 989128 | 2021-02-02 | Walker | Georgia | 13295 | 5758 | 72 |
917256 | 917256 | 2021-01-11 | Walker | Alabama | 1127 | 5758 | 170 |
915150 | 915150 | 2021-01-10 | Allegany | Maryland | 24001 | 5758 | 162 |
885982 | 885982 | 2021-01-01 | Allegan | Michigan | 26005 | 5758 | 66 |
882737 | 882737 | 2020-12-31 | Allegan | Michigan | 26005 | 5758 | 66 |
879492 | 879492 | 2020-12-30 | Allegan | Michigan | 26005 | 5758 | 66 |
822173 | 822173 | 2020-12-12 | Carolina | Puerto Rico | 72031 | 5758 | |
757857 | 757857 | 2020-11-22 | Arlington | Virginia | 51013 | 5758 | 156 |
729440 | 729440 | 2020-11-14 | Lowndes | Georgia | 13185 | 5758 | 121 |
553549 | 553549 | 2020-09-20 | Chesterfield | Virginia | 51041 | 5758 | 91 |
402247 | 402247 | 2020-08-05 | San Mateo | California | 6081 | 5758 | 120 |
303280 | 303280 | 2020-07-05 | Cobb | Georgia | 13067 | 5758 | 246 |
139829 | 139829 | 2020-05-13 | Lake | Illinois | 17097 | 5758 | 194 |
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);