ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
197 rows where cases = 2927 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 21
- South Dakota 19
- Puerto Rico 13
- Virginia 11
- Texas 10
- North Carolina 9
- Idaho 8
- Kentucky 8
- Minnesota 8
- Mississippi 8
- Ohio 8
- Oklahoma 8
- Tennessee 7
- Missouri 6
- Indiana 5
- Colorado 4
- Georgia 4
- Pennsylvania 4
- West Virginia 4
- Michigan 3
- New York 3
- South Carolina 3
- Alabama 2
- Arkansas 2
- Florida 2
- Illinois 2
- Louisiana 2
- Nevada 2
- Oregon 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500376 | 2500376 | 2022-05-13 | Appanoose | Iowa | 19007 | 2927 | 68 |
2501959 | 2501959 | 2022-05-13 | Luquillo | Puerto Rico | 72089 | 2927 | |
2497118 | 2497118 | 2022-05-12 | Appanoose | Iowa | 19007 | 2927 | 68 |
2493860 | 2493860 | 2022-05-11 | Appanoose | Iowa | 19007 | 2927 | 68 |
2475032 | 2475032 | 2022-05-05 | Cedar | Missouri | 29039 | 2927 | 56 |
2466432 | 2466432 | 2022-05-02 | Dawson | Texas | 48115 | 2927 | 94 |
2463177 | 2463177 | 2022-05-01 | Dawson | Texas | 48115 | 2927 | 94 |
2459921 | 2459921 | 2022-04-30 | Dawson | Texas | 48115 | 2927 | 94 |
2456665 | 2456665 | 2022-04-29 | Dawson | Texas | 48115 | 2927 | 94 |
2453409 | 2453409 | 2022-04-28 | Dawson | Texas | 48115 | 2927 | 94 |
2423896 | 2423896 | 2022-04-19 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2420640 | 2420640 | 2022-04-18 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2417384 | 2417384 | 2022-04-17 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2414128 | 2414128 | 2022-04-16 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2410872 | 2410872 | 2022-04-15 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2407616 | 2407616 | 2022-04-14 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2404360 | 2404360 | 2022-04-13 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2401105 | 2401105 | 2022-04-12 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2397850 | 2397850 | 2022-04-11 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2394595 | 2394595 | 2022-04-10 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2391339 | 2391339 | 2022-04-09 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2388083 | 2388083 | 2022-04-08 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2384828 | 2384828 | 2022-04-07 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2381573 | 2381573 | 2022-04-06 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2303432 | 2303432 | 2022-03-13 | Villalba | Puerto Rico | 72149 | 2927 | |
2300180 | 2300180 | 2022-03-12 | Villalba | Puerto Rico | 72149 | 2927 | |
2296928 | 2296928 | 2022-03-11 | Villalba | Puerto Rico | 72149 | 2927 | |
2293676 | 2293676 | 2022-03-10 | Villalba | Puerto Rico | 72149 | 2927 | |
2289922 | 2289922 | 2022-03-09 | Alleghany | North Carolina | 37005 | 2927 | 12 |
2290424 | 2290424 | 2022-03-09 | Villalba | Puerto Rico | 72149 | 2927 | |
2287172 | 2287172 | 2022-03-08 | Villalba | Puerto Rico | 72149 | 2927 | |
2283920 | 2283920 | 2022-03-07 | Villalba | Puerto Rico | 72149 | 2927 | |
2280668 | 2280668 | 2022-03-06 | Villalba | Puerto Rico | 72149 | 2927 | |
2277415 | 2277415 | 2022-03-05 | Villalba | Puerto Rico | 72149 | 2927 | |
2274162 | 2274162 | 2022-03-04 | Villalba | Puerto Rico | 72149 | 2927 | |
2269081 | 2269081 | 2022-03-03 | Idaho | Idaho | 16049 | 2927 | 49 |
2262887 | 2262887 | 2022-03-01 | Winnebago | Iowa | 19189 | 2927 | 44 |
2259636 | 2259636 | 2022-02-28 | Winnebago | Iowa | 19189 | 2927 | 44 |
2256385 | 2256385 | 2022-02-27 | Winnebago | Iowa | 19189 | 2927 | 44 |
2253134 | 2253134 | 2022-02-26 | Winnebago | Iowa | 19189 | 2927 | 44 |
2249883 | 2249883 | 2022-02-25 | Winnebago | Iowa | 19189 | 2927 | 44 |
2246632 | 2246632 | 2022-02-24 | Winnebago | Iowa | 19189 | 2927 | 44 |
2243381 | 2243381 | 2022-02-23 | Winnebago | Iowa | 19189 | 2927 | 44 |
2218480 | 2218480 | 2022-02-15 | Washington | North Carolina | 37187 | 2927 | 45 |
2215229 | 2215229 | 2022-02-14 | Washington | North Carolina | 37187 | 2927 | 45 |
2201437 | 2201437 | 2022-02-10 | Kent | Maryland | 24029 | 2927 | 64 |
2170697 | 2170697 | 2022-01-31 | Martinsville city | Virginia | 51690 | 2927 | 101 |
2147034 | 2147034 | 2022-01-24 | Morgan | Ohio | 39115 | 2927 | 48 |
2129703 | 2129703 | 2022-01-19 | Knott | Kentucky | 21119 | 2927 | 51 |
2100725 | 2100725 | 2022-01-10 | Faribault | Minnesota | 27043 | 2927 | 42 |
2019464 | 2019464 | 2021-12-16 | Houston | Minnesota | 27055 | 2927 | 17 |
2020848 | 2020848 | 2021-12-16 | Houston | Texas | 48225 | 2927 | 89 |
2008937 | 2008937 | 2021-12-13 | Gem | Idaho | 16045 | 2927 | 69 |
2007058 | 2007058 | 2021-12-12 | Hertford | North Carolina | 37091 | 2927 | 72 |
2003807 | 2003807 | 2021-12-11 | Hertford | North Carolina | 37091 | 2927 | 72 |
2000556 | 2000556 | 2021-12-10 | Hertford | North Carolina | 37091 | 2927 | 72 |
1991682 | 1991682 | 2021-12-07 | San Jacinto | Texas | 48407 | 2927 | 82 |
1964814 | 1964814 | 2021-11-29 | Madison | North Carolina | 37115 | 2927 | 66 |
1945905 | 1945905 | 2021-11-23 | Grundy | Tennessee | 47061 | 2927 | 42 |
1941502 | 1941502 | 2021-11-22 | Wadena | Minnesota | 27159 | 2927 | 37 |
1915183 | 1915183 | 2021-11-14 | Morgan | Kentucky | 21175 | 2927 | 10 |
1911933 | 1911933 | 2021-11-13 | Morgan | Kentucky | 21175 | 2927 | 10 |
1912366 | 1912366 | 2021-11-13 | Clinton | Missouri | 29049 | 2927 | 77 |
1908684 | 1908684 | 2021-11-12 | Morgan | Kentucky | 21175 | 2927 | 10 |
1890221 | 1890221 | 2021-11-06 | Paulding | Ohio | 39125 | 2927 | 47 |
1864979 | 1864979 | 2021-10-29 | Young | Texas | 48503 | 2927 | 66 |
1861259 | 1861259 | 2021-10-28 | Vega Alta | Puerto Rico | 72143 | 2927 | |
1861688 | 1861688 | 2021-10-28 | Shelby | Texas | 48419 | 2927 | 109 |
1858010 | 1858010 | 2021-10-27 | Vega Alta | Puerto Rico | 72143 | 2927 | |
1847213 | 1847213 | 2021-10-24 | Hubbard | Minnesota | 27057 | 2927 | 44 |
1843963 | 1843963 | 2021-10-23 | Hubbard | Minnesota | 27057 | 2927 | 44 |
1840713 | 1840713 | 2021-10-22 | Hubbard | Minnesota | 27057 | 2927 | 44 |
1823399 | 1823399 | 2021-10-17 | Montezuma | Colorado | 8083 | 2927 | 36 |
1820150 | 1820150 | 2021-10-16 | Montezuma | Colorado | 8083 | 2927 | 36 |
1816901 | 1816901 | 2021-10-15 | Montezuma | Colorado | 8083 | 2927 | 36 |
1814612 | 1814612 | 2021-10-14 | Alpena | Michigan | 26007 | 2927 | 69 |
1811364 | 1811364 | 2021-10-13 | Alpena | Michigan | 26007 | 2927 | 69 |
1808476 | 1808476 | 2021-10-12 | Vernon | Missouri | 29217 | 2927 | 64 |
1790345 | 1790345 | 2021-10-06 | Fredericksburg city | Virginia | 51630 | 2927 | 25 |
1738441 | 1738441 | 2021-09-20 | Waynesboro city | Virginia | 51820 | 2927 | 39 |
1726719 | 1726719 | 2021-09-17 | McCreary | Kentucky | 21147 | 2927 | 41 |
1722683 | 1722683 | 2021-09-16 | Pitkin | Colorado | 8097 | 2927 | 4 |
1713088 | 1713088 | 2021-09-13 | Elbert | Georgia | 13105 | 2927 | 78 |
1694531 | 1694531 | 2021-09-07 | Meeker | Minnesota | 27093 | 2927 | 46 |
1666858 | 1666858 | 2021-08-29 | Botetourt | Virginia | 51023 | 2927 | 39 |
1663610 | 1663610 | 2021-08-28 | Botetourt | Virginia | 51023 | 2927 | 39 |
1660362 | 1660362 | 2021-08-27 | Botetourt | Virginia | 51023 | 2927 | 39 |
1620732 | 1620732 | 2021-08-15 | Elk | Pennsylvania | 42047 | 2927 | 41 |
1609162 | 1609162 | 2021-08-12 | Harris | Georgia | 13145 | 2927 | 66 |
1581675 | 1581675 | 2021-08-03 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1578426 | 1578426 | 2021-08-02 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1575178 | 1575178 | 2021-08-01 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1571930 | 1571930 | 2021-07-31 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1568682 | 1568682 | 2021-07-30 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1565434 | 1565434 | 2021-07-29 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1562186 | 1562186 | 2021-07-28 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1557526 | 1557526 | 2021-07-27 | Bremer | Iowa | 19017 | 2927 | 63 |
1554279 | 1554279 | 2021-07-26 | Bremer | Iowa | 19017 | 2927 | 63 |
1551032 | 1551032 | 2021-07-25 | Bremer | Iowa | 19017 | 2927 | 63 |
1547785 | 1547785 | 2021-07-24 | Bremer | Iowa | 19017 | 2927 | 63 |
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);