ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
256 rows where cases = 2506 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 24
- Georgia 18
- Iowa 15
- Virginia 14
- Alabama 13
- Kentucky 12
- Mississippi 12
- Arkansas 10
- Missouri 10
- Puerto Rico 9
- Oklahoma 8
- Tennessee 8
- Illinois 7
- Nevada 7
- Idaho 6
- Indiana 6
- Kansas 6
- Louisiana 6
- North Carolina 6
- Ohio 6
- Minnesota 5
- Pennsylvania 5
- Utah 5
- Colorado 3
- Florida 3
- Maryland 3
- Nebraska 3
- New Hampshire 3
- North Dakota 3
- South Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491576 | 2491576 | 2022-05-10 | Humboldt | Nevada | 32013 | 2506 | 54 |
2488318 | 2488318 | 2022-05-09 | Humboldt | Nevada | 32013 | 2506 | 54 |
2485061 | 2485061 | 2022-05-08 | Humboldt | Nevada | 32013 | 2506 | 54 |
2481803 | 2481803 | 2022-05-07 | Humboldt | Nevada | 32013 | 2506 | 54 |
2478545 | 2478545 | 2022-05-06 | Humboldt | Nevada | 32013 | 2506 | 54 |
2475287 | 2475287 | 2022-05-05 | Humboldt | Nevada | 32013 | 2506 | 54 |
2472030 | 2472030 | 2022-05-04 | Humboldt | Nevada | 32013 | 2506 | 54 |
2365184 | 2365184 | 2022-04-01 | Ciales | Puerto Rico | 72039 | 2506 | |
2339207 | 2339207 | 2022-03-24 | Santa Isabel | Puerto Rico | 72133 | 2506 | |
2320700 | 2320700 | 2022-03-19 | Perry | Arkansas | 5105 | 2506 | 37 |
2313577 | 2313577 | 2022-03-16 | Morris | Texas | 48343 | 2506 | 70 |
2286388 | 2286388 | 2022-03-08 | Deer Lodge | Montana | 30023 | 2506 | 28 |
2284152 | 2284152 | 2022-03-07 | Blanco | Texas | 48031 | 2506 | 33 |
2278857 | 2278857 | 2022-03-06 | Valley | Idaho | 16085 | 2506 | 16 |
2280900 | 2280900 | 2022-03-06 | Blanco | Texas | 48031 | 2506 | 33 |
2275604 | 2275604 | 2022-03-05 | Valley | Idaho | 16085 | 2506 | 16 |
2277647 | 2277647 | 2022-03-05 | Blanco | Texas | 48031 | 2506 | 33 |
2272351 | 2272351 | 2022-03-04 | Valley | Idaho | 16085 | 2506 | 16 |
2274394 | 2274394 | 2022-03-04 | Blanco | Texas | 48031 | 2506 | 33 |
2263482 | 2263482 | 2022-03-01 | Tunica | Mississippi | 28143 | 2506 | 45 |
2260231 | 2260231 | 2022-02-28 | Tunica | Mississippi | 28143 | 2506 | 44 |
2256980 | 2256980 | 2022-02-27 | Tunica | Mississippi | 28143 | 2506 | 44 |
2253729 | 2253729 | 2022-02-26 | Tunica | Mississippi | 28143 | 2506 | 44 |
2250478 | 2250478 | 2022-02-25 | Tunica | Mississippi | 28143 | 2506 | 44 |
2245465 | 2245465 | 2022-02-23 | Galax city | Virginia | 51640 | 2506 | 72 |
2239955 | 2239955 | 2022-02-22 | Crawford | Indiana | 18025 | 2506 | 35 |
2188211 | 2188211 | 2022-02-06 | Bath | Kentucky | 21011 | 2506 | 35 |
2184958 | 2184958 | 2022-02-05 | Bath | Kentucky | 21011 | 2506 | 35 |
2181706 | 2181706 | 2022-02-04 | Bath | Kentucky | 21011 | 2506 | 35 |
2171826 | 2171826 | 2022-02-01 | Union | Iowa | 19175 | 2506 | 46 |
2168573 | 2168573 | 2022-01-31 | Union | Iowa | 19175 | 2506 | 46 |
2165318 | 2165318 | 2022-01-30 | Union | Iowa | 19175 | 2506 | 46 |
2162063 | 2162063 | 2022-01-29 | Union | Iowa | 19175 | 2506 | 46 |
2158808 | 2158808 | 2022-01-28 | Union | Iowa | 19175 | 2506 | 46 |
2155151 | 2155151 | 2022-01-27 | Long | Georgia | 13183 | 2506 | 29 |
2155554 | 2155554 | 2022-01-27 | Union | Iowa | 19175 | 2506 | 46 |
2152301 | 2152301 | 2022-01-26 | Union | Iowa | 19175 | 2506 | 46 |
2152884 | 2152884 | 2022-01-26 | Noxubee | Mississippi | 28103 | 2506 | 46 |
2150198 | 2150198 | 2022-01-25 | McLean | North Dakota | 38055 | 2506 | 48 |
2140792 | 2140792 | 2022-01-22 | Orocovis | Puerto Rico | 72107 | 2506 | |
2137294 | 2137294 | 2022-01-21 | Vinton | Ohio | 39163 | 2506 | 46 |
2125969 | 2125969 | 2022-01-18 | Gooding | Idaho | 16047 | 2506 | 45 |
2112048 | 2112048 | 2022-01-13 | Orange | Vermont | 50017 | 2506 | 9 |
2108958 | 2108958 | 2022-01-12 | Klickitat | Washington | 53039 | 2506 | 36 |
2100398 | 2100398 | 2022-01-10 | Carroll | Kentucky | 21041 | 2506 | 38 |
2041018 | 2041018 | 2021-12-23 | Marion | Arkansas | 5089 | 2506 | 69 |
2043842 | 2043842 | 2021-12-23 | Greene | Virginia | 51079 | 2506 | 46 |
2043905 | 2043905 | 2021-12-23 | Southampton | Virginia | 51175 | 2506 | 72 |
2012447 | 2012447 | 2021-12-14 | Harrison | Iowa | 19085 | 2506 | 80 |
2009196 | 2009196 | 2021-12-13 | Harrison | Iowa | 19085 | 2506 | 80 |
2005945 | 2005945 | 2021-12-12 | Harrison | Iowa | 19085 | 2506 | 80 |
2002694 | 2002694 | 2021-12-11 | Harrison | Iowa | 19085 | 2506 | 80 |
1999444 | 1999444 | 2021-12-10 | Harrison | Iowa | 19085 | 2506 | 80 |
2001459 | 2001459 | 2021-12-10 | Tyler | Texas | 48457 | 2506 | 73 |
1996193 | 1996193 | 2021-12-09 | Harrison | Iowa | 19085 | 2506 | 80 |
1992942 | 1992942 | 2021-12-08 | Harrison | Iowa | 19085 | 2506 | 80 |
1994102 | 1994102 | 2021-12-08 | Warren | North Carolina | 37185 | 2506 | 33 |
1994160 | 1994160 | 2021-12-08 | Walsh | North Dakota | 38099 | 2506 | 30 |
1989497 | 1989497 | 2021-12-07 | Johnson | Illinois | 17087 | 2506 | 38 |
1983415 | 1983415 | 2021-12-05 | Larue | Kentucky | 21123 | 2506 | 53 |
1980165 | 1980165 | 2021-12-04 | Larue | Kentucky | 21123 | 2506 | 53 |
1976915 | 1976915 | 2021-12-03 | Larue | Kentucky | 21123 | 2506 | 53 |
1973387 | 1973387 | 2021-12-02 | Tipton | Indiana | 18159 | 2506 | 69 |
1946633 | 1946633 | 2021-11-24 | Lamar | Alabama | 1075 | 2506 | 53 |
1937744 | 1937744 | 2021-11-21 | Atchison | Kansas | 20005 | 2506 | 27 |
1934494 | 1934494 | 2021-11-20 | Atchison | Kansas | 20005 | 2506 | 27 |
1930484 | 1930484 | 2021-11-19 | Howard | Arkansas | 5061 | 2506 | 38 |
1931243 | 1931243 | 2021-11-19 | Atchison | Kansas | 20005 | 2506 | 27 |
1920146 | 1920146 | 2021-11-15 | Nolan | Texas | 48353 | 2506 | 79 |
1914347 | 1914347 | 2021-11-14 | Chaffee | Colorado | 8015 | 2506 | 33 |
1916896 | 1916896 | 2021-11-14 | Nolan | Texas | 48353 | 2506 | 79 |
1911097 | 1911097 | 2021-11-13 | Chaffee | Colorado | 8015 | 2506 | 33 |
1913646 | 1913646 | 2021-11-13 | Nolan | Texas | 48353 | 2506 | 79 |
1907848 | 1907848 | 2021-11-12 | Chaffee | Colorado | 8015 | 2506 | 33 |
1904500 | 1904500 | 2021-11-11 | Madison | Arkansas | 5087 | 2506 | 40 |
1905474 | 1905474 | 2021-11-11 | Bienville | Louisiana | 22013 | 2506 | 99 |
1906258 | 1906258 | 2021-11-11 | Bertie | North Carolina | 37015 | 2506 | 52 |
1907538 | 1907538 | 2021-11-11 | Marquette | Wisconsin | 55077 | 2506 | 35 |
1902224 | 1902224 | 2021-11-10 | Bienville | Louisiana | 22013 | 2506 | 99 |
1903009 | 1903009 | 2021-11-10 | Bertie | North Carolina | 37015 | 2506 | 52 |
1829753 | 1829753 | 2021-10-19 | Izard | Arkansas | 5065 | 2506 | 55 |
1832528 | 1832528 | 2021-10-19 | Orleans | Vermont | 50019 | 2506 | 13 |
1828808 | 1828808 | 2021-10-18 | Lee | South Carolina | 45061 | 2506 | 74 |
1819012 | 1819012 | 2021-10-15 | San Sebastian | Puerto Rico | 72131 | 2506 | |
1812786 | 1812786 | 2021-10-13 | Colorado | Texas | 48089 | 2506 | 51 |
1806932 | 1806932 | 2021-10-12 | Washington | Alabama | 1129 | 2506 | 50 |
1806587 | 1806587 | 2021-10-11 | Fluvanna | Virginia | 51065 | 2506 | 22 |
1803337 | 1803337 | 2021-10-10 | Fluvanna | Virginia | 51065 | 2506 | 22 |
1800088 | 1800088 | 2021-10-09 | Fluvanna | Virginia | 51065 | 2506 | 22 |
1796839 | 1796839 | 2021-10-08 | Fluvanna | Virginia | 51065 | 2506 | 22 |
1791226 | 1791226 | 2021-10-07 | Bond | Illinois | 17005 | 2506 | 30 |
1786324 | 1786324 | 2021-10-05 | Murray | Oklahoma | 40099 | 2506 | 49 |
1786649 | 1786649 | 2021-10-05 | Union | South Dakota | 46127 | 2506 | 44 |
1787244 | 1787244 | 2021-10-05 | Lincoln | West Virginia | 54043 | 2506 | 37 |
1782489 | 1782489 | 2021-10-04 | Wright | Missouri | 29229 | 2506 | 46 |
1783075 | 1783075 | 2021-10-04 | Murray | Oklahoma | 40099 | 2506 | 49 |
1783649 | 1783649 | 2021-10-04 | Llano | Texas | 48299 | 2506 | 68 |
1779239 | 1779239 | 2021-10-03 | Wright | Missouri | 29229 | 2506 | 46 |
1779826 | 1779826 | 2021-10-03 | Murray | Oklahoma | 40099 | 2506 | 49 |
1776576 | 1776576 | 2021-10-02 | Murray | Oklahoma | 40099 | 2506 | 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);