ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
276 rows where cases = 2134 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 30
- Texas 27
- Virginia 22
- Kentucky 20
- Missouri 20
- Mississippi 15
- Indiana 13
- Minnesota 8
- North Carolina 8
- North Dakota 7
- South Dakota 7
- Wyoming 7
- Arkansas 6
- Wisconsin 6
- Iowa 5
- Nevada 5
- Ohio 5
- Pennsylvania 5
- Utah 5
- Alabama 4
- California 4
- Idaho 4
- Illinois 4
- Michigan 4
- Puerto Rico 4
- Tennessee 4
- Colorado 3
- Louisiana 3
- New York 3
- Oregon 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395763 | 2395763 | 2022-04-11 | Atkinson | Georgia | 13003 | 2134 | 47 |
2392507 | 2392507 | 2022-04-10 | Atkinson | Georgia | 13003 | 2134 | 47 |
2389251 | 2389251 | 2022-04-09 | Atkinson | Georgia | 13003 | 2134 | 47 |
2385996 | 2385996 | 2022-04-08 | Atkinson | Georgia | 13003 | 2134 | 47 |
2312136 | 2312136 | 2022-03-16 | Jackson | Minnesota | 27063 | 2134 | 17 |
2308883 | 2308883 | 2022-03-15 | Jackson | Minnesota | 27063 | 2134 | 17 |
2296911 | 2296911 | 2022-03-11 | Rincon | Puerto Rico | 72117 | 2134 | |
2290720 | 2290720 | 2022-03-09 | Franklin | Texas | 48159 | 2134 | 40 |
2291029 | 2291029 | 2022-03-09 | Northampton | Virginia | 51131 | 2134 | 61 |
2287537 | 2287537 | 2022-03-08 | Live Oak | Texas | 48297 | 2134 | 40 |
2284285 | 2284285 | 2022-03-07 | Live Oak | Texas | 48297 | 2134 | 40 |
2284525 | 2284525 | 2022-03-07 | Northampton | Virginia | 51131 | 2134 | 61 |
2279683 | 2279683 | 2022-03-06 | Claiborne | Mississippi | 28021 | 2134 | 46 |
2281033 | 2281033 | 2022-03-06 | Live Oak | Texas | 48297 | 2134 | 40 |
2276430 | 2276430 | 2022-03-05 | Claiborne | Mississippi | 28021 | 2134 | 46 |
2277780 | 2277780 | 2022-03-05 | Live Oak | Texas | 48297 | 2134 | 40 |
2273177 | 2273177 | 2022-03-04 | Claiborne | Mississippi | 28021 | 2134 | 46 |
2274527 | 2274527 | 2022-03-04 | Live Oak | Texas | 48297 | 2134 | 40 |
2269925 | 2269925 | 2022-03-03 | Claiborne | Mississippi | 28021 | 2134 | 46 |
2271274 | 2271274 | 2022-03-03 | Live Oak | Texas | 48297 | 2134 | 40 |
2266672 | 2266672 | 2022-03-02 | Claiborne | Mississippi | 28021 | 2134 | 46 |
2268022 | 2268022 | 2022-03-02 | Live Oak | Texas | 48297 | 2134 | 40 |
2251325 | 2251325 | 2022-02-25 | Adjuntas | Puerto Rico | 72001 | 2134 | |
2237529 | 2237529 | 2022-02-21 | Howard | Missouri | 29089 | 2134 | 23 |
2234278 | 2234278 | 2022-02-20 | Howard | Missouri | 29089 | 2134 | 23 |
2231027 | 2231027 | 2022-02-19 | Howard | Missouri | 29089 | 2134 | 23 |
2227776 | 2227776 | 2022-02-18 | Howard | Missouri | 29089 | 2134 | 23 |
2219892 | 2219892 | 2022-02-16 | Nevada | Arkansas | 5099 | 2134 | 43 |
2197720 | 2197720 | 2022-02-09 | Martin | Indiana | 18101 | 2134 | 24 |
2194466 | 2194466 | 2022-02-08 | Martin | Indiana | 18101 | 2134 | 24 |
2187805 | 2187805 | 2022-02-06 | Washington | Idaho | 16087 | 2134 | 53 |
2184552 | 2184552 | 2022-02-05 | Washington | Idaho | 16087 | 2134 | 53 |
2174744 | 2174744 | 2022-02-02 | Wilkinson | Georgia | 13319 | 2134 | 50 |
2164878 | 2164878 | 2022-01-30 | Evans | Georgia | 13109 | 2134 | 61 |
2161623 | 2161623 | 2022-01-29 | Evans | Georgia | 13109 | 2134 | 61 |
2158367 | 2158367 | 2022-01-28 | Evans | Georgia | 13109 | 2134 | 61 |
2133092 | 2133092 | 2022-01-20 | Piscataquis | Maine | 23021 | 2134 | 23 |
2130173 | 2130173 | 2022-01-19 | Douglas | Missouri | 29067 | 2134 | 68 |
2088623 | 2088623 | 2022-01-06 | Morrow | Oregon | 41049 | 2134 | 26 |
2053516 | 2053516 | 2021-12-26 | Unknown | Utah | 2134 | 53 | |
2050266 | 2050266 | 2021-12-25 | Unknown | Utah | 2134 | 53 | |
2047016 | 2047016 | 2021-12-24 | Unknown | Utah | 2134 | 53 | |
2040574 | 2040574 | 2021-12-22 | Dickenson | Virginia | 51051 | 2134 | 33 |
2016091 | 2016091 | 2021-12-15 | Dukes | Massachusetts | 25007 | 2134 | 0 |
1990429 | 1990429 | 2021-12-07 | Pemiscot | Missouri | 29155 | 2134 | 59 |
1991744 | 1991744 | 2021-12-07 | Juab | Utah | 49023 | 2134 | 19 |
1983366 | 1983366 | 2021-12-05 | Breathitt | Kentucky | 21025 | 2134 | 41 |
1980116 | 1980116 | 2021-12-04 | Breathitt | Kentucky | 21025 | 2134 | 41 |
1976866 | 1976866 | 2021-12-03 | Breathitt | Kentucky | 21025 | 2134 | 41 |
1967574 | 1967574 | 2021-11-30 | Perry | Mississippi | 28111 | 2134 | 56 |
1964322 | 1964322 | 2021-11-29 | Perry | Mississippi | 28111 | 2134 | 56 |
1942352 | 1942352 | 2021-11-22 | Tillamook | Oregon | 41057 | 2134 | 43 |
1938967 | 1938967 | 2021-11-21 | Noble | Ohio | 39121 | 2134 | 47 |
1918688 | 1918688 | 2021-11-15 | Cottonwood | Minnesota | 27033 | 2134 | 30 |
1917099 | 1917099 | 2021-11-14 | Martinsville city | Virginia | 51690 | 2134 | 89 |
1913849 | 1913849 | 2021-11-13 | Martinsville city | Virginia | 51690 | 2134 | 89 |
1910599 | 1910599 | 2021-11-12 | Martinsville city | Virginia | 51690 | 2134 | 89 |
1869637 | 1869637 | 2021-10-31 | Fleming | Kentucky | 21069 | 2134 | 34 |
1866388 | 1866388 | 2021-10-30 | Fleming | Kentucky | 21069 | 2134 | 34 |
1863139 | 1863139 | 2021-10-29 | Fleming | Kentucky | 21069 | 2134 | 34 |
1859009 | 1859009 | 2021-10-28 | Marion | Arkansas | 5089 | 2134 | 57 |
1849804 | 1849804 | 2021-10-25 | Washington | Illinois | 17189 | 2134 | 34 |
1823543 | 1823543 | 2021-10-17 | Dade | Georgia | 13083 | 2134 | 19 |
1820294 | 1820294 | 2021-10-16 | Dade | Georgia | 13083 | 2134 | 19 |
1817045 | 1817045 | 2021-10-15 | Dade | Georgia | 13083 | 2134 | 19 |
1819285 | 1819285 | 2021-10-15 | Comanche | Texas | 48093 | 2134 | 62 |
1809847 | 1809847 | 2021-10-12 | Greene | Virginia | 51079 | 2134 | 30 |
1782364 | 1782364 | 2021-10-04 | Walthall | Mississippi | 28147 | 2134 | 62 |
1779184 | 1779184 | 2021-10-03 | Macon | Missouri | 29121 | 2134 | 20 |
1770234 | 1770234 | 2021-09-30 | Fajardo | Puerto Rico | 72053 | 2134 | |
1762882 | 1762882 | 2021-09-28 | Bates | Missouri | 29013 | 2134 | 39 |
1741787 | 1741787 | 2021-09-21 | Wetzel | West Virginia | 54103 | 2134 | 37 |
1719905 | 1719905 | 2021-09-15 | Parke | Indiana | 18121 | 2134 | 20 |
1716791 | 1716791 | 2021-09-14 | Atchison | Kansas | 20005 | 2134 | 23 |
1717452 | 1717452 | 2021-09-14 | Madison | Missouri | 29123 | 2134 | 18 |
1713545 | 1713545 | 2021-09-13 | Atchison | Kansas | 20005 | 2134 | 23 |
1701181 | 1701181 | 2021-09-09 | Dallas | Missouri | 29059 | 2134 | 38 |
1693138 | 1693138 | 2021-09-06 | Carbon | Wyoming | 56007 | 2134 | 31 |
1689889 | 1689889 | 2021-09-05 | Carbon | Wyoming | 56007 | 2134 | 31 |
1686639 | 1686639 | 2021-09-04 | Carbon | Wyoming | 56007 | 2134 | 31 |
1682202 | 1682202 | 2021-09-03 | Richland | North Dakota | 38077 | 2134 | 19 |
1683389 | 1683389 | 2021-09-03 | Carbon | Wyoming | 56007 | 2134 | 31 |
1665924 | 1665924 | 2021-08-29 | Yancey | North Carolina | 37199 | 2134 | 28 |
1666935 | 1666935 | 2021-08-29 | Nottoway | Virginia | 51135 | 2134 | 55 |
1662676 | 1662676 | 2021-08-28 | Yancey | North Carolina | 37199 | 2134 | 28 |
1663687 | 1663687 | 2021-08-28 | Nottoway | Virginia | 51135 | 2134 | 55 |
1659428 | 1659428 | 2021-08-27 | Yancey | North Carolina | 37199 | 2134 | 28 |
1660439 | 1660439 | 2021-08-27 | Nottoway | Virginia | 51135 | 2134 | 55 |
1652819 | 1652819 | 2021-08-25 | Seneca | New York | 36099 | 2134 | 57 |
1644103 | 1644103 | 2021-08-22 | Washington | Vermont | 50023 | 2134 | 16 |
1625650 | 1625650 | 2021-08-17 | Carroll | Indiana | 18015 | 2134 | 26 |
1627271 | 1627271 | 2021-08-17 | Aguada | Puerto Rico | 72003 | 2134 | |
1624428 | 1624428 | 2021-08-16 | Houston | Texas | 48225 | 2134 | 60 |
1621181 | 1621181 | 2021-08-15 | Houston | Texas | 48225 | 2134 | 60 |
1603203 | 1603203 | 2021-08-10 | Adair | Kentucky | 21001 | 2134 | 57 |
1599954 | 1599954 | 2021-08-09 | Adair | Kentucky | 21001 | 2134 | 57 |
1581971 | 1581971 | 2021-08-03 | Oglala Lakota | South Dakota | 46102 | 2134 | 49 |
1582155 | 1582155 | 2021-08-03 | Falls | Texas | 48145 | 2134 | 33 |
1578722 | 1578722 | 2021-08-02 | Oglala Lakota | South Dakota | 46102 | 2134 | 49 |
1575474 | 1575474 | 2021-08-01 | Oglala Lakota | South Dakota | 46102 | 2134 | 49 |
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);