ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where cases = 4427 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 15
- Texas 12
- Georgia 9
- Louisiana 9
- Oklahoma 9
- Illinois 7
- Wisconsin 7
- Michigan 6
- North Carolina 5
- Ohio 5
- Arkansas 4
- Virginia 4
- Alaska 3
- Idaho 3
- Minnesota 3
- Montana 3
- New York 3
- Pennsylvania 3
- Tennessee 3
- Alabama 2
- Florida 2
- Indiana 2
- Puerto Rico 2
- California 1
- Colorado 1
- Iowa 1
- Kentucky 1
- Maine 1
- Maryland 1
- Missouri 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453667 | 2453667 | 2022-04-28 | Bristol city | Virginia | 51520 | 4427 | 80 |
2418788 | 2418788 | 2022-04-18 | Ford | Illinois | 17053 | 4427 | 73 |
2348920 | 2348920 | 2022-03-27 | Coamo | Puerto Rico | 72043 | 4427 | |
2337990 | 2337990 | 2022-03-24 | Winn | Louisiana | 22127 | 4427 | 62 |
2330380 | 2330380 | 2022-03-22 | Northwest Arctic Borough | Alaska | 2188 | 4427 | 13 |
2327128 | 2327128 | 2022-03-21 | Northwest Arctic Borough | Alaska | 2188 | 4427 | 13 |
2261430 | 2261430 | 2022-02-28 | Deaf Smith | Texas | 48117 | 4427 | 109 |
2258179 | 2258179 | 2022-02-27 | Deaf Smith | Texas | 48117 | 4427 | 109 |
2254928 | 2254928 | 2022-02-26 | Deaf Smith | Texas | 48117 | 4427 | 109 |
2245773 | 2245773 | 2022-02-24 | Henry | Alabama | 1067 | 4427 | 69 |
2239745 | 2239745 | 2022-02-22 | Putnam | Georgia | 13237 | 4427 | 100 |
2196740 | 2196740 | 2022-02-08 | Prince Edward | Virginia | 51147 | 4427 | 58 |
2188845 | 2188845 | 2022-02-06 | Lincoln | Montana | 30053 | 4427 | 77 |
2185592 | 2185592 | 2022-02-05 | Lincoln | Montana | 30053 | 4427 | 77 |
2181900 | 2181900 | 2022-02-04 | Waldo | Maine | 23027 | 4427 | 51 |
2182340 | 2182340 | 2022-02-04 | Lincoln | Montana | 30053 | 4427 | 77 |
2155948 | 2155948 | 2022-01-27 | Iosco | Michigan | 26069 | 4427 | 126 |
2152695 | 2152695 | 2022-01-26 | Iosco | Michigan | 26069 | 4427 | 126 |
2110254 | 2110254 | 2022-01-13 | Assumption | Louisiana | 22007 | 4427 | 57 |
2107003 | 2107003 | 2022-01-12 | Assumption | Louisiana | 22007 | 4427 | 57 |
2103752 | 2103752 | 2022-01-11 | Assumption | Louisiana | 22007 | 4427 | 57 |
2077257 | 2077257 | 2022-01-03 | Jersey | Illinois | 17083 | 4427 | 76 |
2053797 | 2053797 | 2021-12-26 | Kewaunee | Wisconsin | 55061 | 4427 | 49 |
2050547 | 2050547 | 2021-12-25 | Kewaunee | Wisconsin | 55061 | 4427 | 49 |
2047297 | 2047297 | 2021-12-24 | Kewaunee | Wisconsin | 55061 | 4427 | 49 |
1967316 | 1967316 | 2021-11-30 | Dorchester | Maryland | 24019 | 4427 | 87 |
1961092 | 1961092 | 2021-11-28 | Wayne | Mississippi | 28153 | 4427 | 72 |
1957841 | 1957841 | 2021-11-27 | Wayne | Mississippi | 28153 | 4427 | 72 |
1954590 | 1954590 | 2021-11-26 | Wayne | Mississippi | 28153 | 4427 | 72 |
1951339 | 1951339 | 2021-11-25 | Wayne | Mississippi | 28153 | 4427 | 72 |
1948088 | 1948088 | 2021-11-24 | Wayne | Mississippi | 28153 | 4427 | 72 |
1944837 | 1944837 | 2021-11-23 | Wayne | Mississippi | 28153 | 4427 | 72 |
1941278 | 1941278 | 2021-11-22 | West Baton Rouge | Louisiana | 22121 | 4427 | 77 |
1941586 | 1941586 | 2021-11-22 | Wayne | Mississippi | 28153 | 4427 | 72 |
1938336 | 1938336 | 2021-11-21 | Wayne | Mississippi | 28153 | 4427 | 72 |
1935086 | 1935086 | 2021-11-20 | Wayne | Mississippi | 28153 | 4427 | 72 |
1931836 | 1931836 | 2021-11-19 | Wayne | Mississippi | 28153 | 4427 | 72 |
1918059 | 1918059 | 2021-11-15 | Clay | Indiana | 18021 | 4427 | 61 |
1914768 | 1914768 | 2021-11-14 | Perry | Illinois | 17145 | 4427 | 85 |
1911518 | 1911518 | 2021-11-13 | Perry | Illinois | 17145 | 4427 | 85 |
1908269 | 1908269 | 2021-11-12 | Perry | Illinois | 17145 | 4427 | 85 |
1905141 | 1905141 | 2021-11-11 | White | Indiana | 18181 | 4427 | 67 |
1899941 | 1899941 | 2021-11-09 | Hardin | Ohio | 39065 | 4427 | 94 |
1883415 | 1883415 | 2021-11-04 | Cibola | New Mexico | 35006 | 4427 | 144 |
1869044 | 1869044 | 2021-10-31 | Emanuel | Georgia | 13107 | 4427 | 131 |
1865795 | 1865795 | 2021-10-30 | Emanuel | Georgia | 13107 | 4427 | 131 |
1862546 | 1862546 | 2021-10-29 | Emanuel | Georgia | 13107 | 4427 | 131 |
1833445 | 1833445 | 2021-10-20 | Latah | Idaho | 16057 | 4427 | 33 |
1834014 | 1834014 | 2021-10-20 | Morehouse | Louisiana | 22067 | 4427 | 115 |
1815332 | 1815332 | 2021-10-14 | Montgomery | North Carolina | 37123 | 4427 | 108 |
1812018 | 1812018 | 2021-10-13 | Washington | New York | 36115 | 4427 | 65 |
1803683 | 1803683 | 2021-10-11 | Winston | Alabama | 1133 | 4427 | 99 |
1791786 | 1791786 | 2021-10-07 | Sabine | Louisiana | 22085 | 4427 | 84 |
1732570 | 1732570 | 2021-09-19 | Dawson | Georgia | 13085 | 4427 | 55 |
1729320 | 1729320 | 2021-09-18 | Dawson | Georgia | 13085 | 4427 | 55 |
1726070 | 1726070 | 2021-09-17 | Dawson | Georgia | 13085 | 4427 | 55 |
1726204 | 1726204 | 2021-09-17 | Bonner | Idaho | 16017 | 4427 | 59 |
1716964 | 1716964 | 2021-09-14 | Logan | Kentucky | 21141 | 4427 | 77 |
1675986 | 1675986 | 2021-09-01 | Venango | Pennsylvania | 42121 | 4427 | 106 |
1673659 | 1673659 | 2021-08-31 | Teton | Wyoming | 56039 | 4427 | 11 |
1649055 | 1649055 | 2021-08-24 | Morrison | Minnesota | 27097 | 4427 | 62 |
1627068 | 1627068 | 2021-08-17 | Putnam | Ohio | 39137 | 4427 | 104 |
1607840 | 1607840 | 2021-08-11 | Ponce | Puerto Rico | 72113 | 4427 | |
1578290 | 1578290 | 2021-08-02 | Defiance | Ohio | 39039 | 4427 | 99 |
1560111 | 1560111 | 2021-07-28 | Independence | Arkansas | 5063 | 4427 | 129 |
1554746 | 1554746 | 2021-07-26 | Hillsdale | Michigan | 26059 | 4427 | 94 |
1551499 | 1551499 | 2021-07-25 | Hillsdale | Michigan | 26059 | 4427 | 94 |
1548252 | 1548252 | 2021-07-24 | Hillsdale | Michigan | 26059 | 4427 | 94 |
1545005 | 1545005 | 2021-07-23 | Hillsdale | Michigan | 26059 | 4427 | 94 |
1536199 | 1536199 | 2021-07-20 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1532951 | 1532951 | 2021-07-19 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1529704 | 1529704 | 2021-07-18 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1530076 | 1530076 | 2021-07-18 | Lincoln | Tennessee | 47103 | 4427 | 67 |
1526457 | 1526457 | 2021-07-17 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1526829 | 1526829 | 2021-07-17 | Lincoln | Tennessee | 47103 | 4427 | 67 |
1523210 | 1523210 | 2021-07-16 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1523582 | 1523582 | 2021-07-16 | Lincoln | Tennessee | 47103 | 4427 | 67 |
1519962 | 1519962 | 2021-07-15 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1516714 | 1516714 | 2021-07-14 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1468243 | 1468243 | 2021-06-29 | Dillon | South Carolina | 45033 | 4427 | 85 |
1464429 | 1464429 | 2021-06-28 | Fulton | New York | 36035 | 4427 | 93 |
1429722 | 1429722 | 2021-06-17 | Van Zandt | Texas | 48467 | 4427 | 122 |
1426477 | 1426477 | 2021-06-16 | Van Zandt | Texas | 48467 | 4427 | 122 |
1423230 | 1423230 | 2021-06-15 | Van Zandt | Texas | 48467 | 4427 | 122 |
1407549 | 1407549 | 2021-06-11 | Miller | Arkansas | 5091 | 4427 | 38 |
1383537 | 1383537 | 2021-06-03 | Madison | Ohio | 39097 | 4427 | 65 |
1373181 | 1373181 | 2021-05-31 | Warren | Mississippi | 28149 | 4427 | 122 |
1338938 | 1338938 | 2021-05-20 | Danville city | Virginia | 51590 | 4427 | 137 |
1294403 | 1294403 | 2021-05-07 | Franklin | Illinois | 17055 | 4427 | 86 |
1287361 | 1287361 | 2021-05-05 | Kenai Peninsula Borough | Alaska | 2122 | 4427 | 19 |
1261262 | 1261262 | 2021-04-26 | Polk | Wisconsin | 55095 | 4427 | 49 |
1258015 | 1258015 | 2021-04-25 | Polk | Wisconsin | 55095 | 4427 | 49 |
1221826 | 1221826 | 2021-04-14 | Hill | Texas | 48217 | 4427 | 105 |
1218578 | 1218578 | 2021-04-13 | Hill | Texas | 48217 | 4427 | 105 |
1201529 | 1201529 | 2021-04-08 | Chatham | North Carolina | 37037 | 4427 | 85 |
1201587 | 1201587 | 2021-04-08 | Richmond | North Carolina | 37153 | 4427 | 92 |
1194484 | 1194484 | 2021-04-06 | Mower | Minnesota | 27099 | 4427 | 32 |
1194576 | 1194576 | 2021-04-06 | Panola | Mississippi | 28107 | 4427 | 103 |
1191327 | 1191327 | 2021-04-05 | Panola | Mississippi | 28107 | 4427 | 103 |
1188079 | 1188079 | 2021-04-04 | Panola | Mississippi | 28107 | 4427 | 103 |
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);