ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where cases = 2831 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 38
- Texas 20
- Oklahoma 15
- Arkansas 13
- Iowa 11
- Georgia 10
- Indiana 9
- Tennessee 9
- North Carolina 8
- Washington 8
- Utah 7
- Alabama 6
- Kentucky 6
- New York 6
- Ohio 6
- Mississippi 5
- Puerto Rico 5
- Virginia 5
- West Virginia 5
- Minnesota 4
- Nevada 4
- Connecticut 3
- Missouri 3
- Maryland 2
- Michigan 2
- Nebraska 2
- South Dakota 2
- California 1
- Colorado 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502727 | 2502727 | 2022-05-13 | Summers | West Virginia | 54089 | 2831 | 54 |
2438883 | 2438883 | 2022-04-24 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2435627 | 2435627 | 2022-04-23 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2432371 | 2432371 | 2022-04-22 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2429115 | 2429115 | 2022-04-21 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2425859 | 2425859 | 2022-04-20 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2422603 | 2422603 | 2022-04-19 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2424419 | 2424419 | 2022-04-19 | Lexington city | Virginia | 51678 | 2831 | 40 |
2419347 | 2419347 | 2022-04-18 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2416091 | 2416091 | 2022-04-17 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2412835 | 2412835 | 2022-04-16 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2409579 | 2409579 | 2022-04-15 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2406323 | 2406323 | 2022-04-14 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2403067 | 2403067 | 2022-04-13 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2399813 | 2399813 | 2022-04-12 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2396557 | 2396557 | 2022-04-11 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2393302 | 2393302 | 2022-04-10 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2390046 | 2390046 | 2022-04-09 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2386790 | 2386790 | 2022-04-08 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2383535 | 2383535 | 2022-04-07 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2380280 | 2380280 | 2022-04-06 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2377025 | 2377025 | 2022-04-05 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2373773 | 2373773 | 2022-04-04 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2370520 | 2370520 | 2022-04-03 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2367267 | 2367267 | 2022-04-02 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2364014 | 2364014 | 2022-04-01 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2360760 | 2360760 | 2022-03-31 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2357506 | 2357506 | 2022-03-30 | West Feliciana | Louisiana | 22125 | 2831 | 46 |
2332956 | 2332956 | 2022-03-22 | Camp | Texas | 48063 | 2831 | 74 |
2329703 | 2329703 | 2022-03-21 | Camp | Texas | 48063 | 2831 | 74 |
2326451 | 2326451 | 2022-03-20 | Camp | Texas | 48063 | 2831 | 74 |
2323198 | 2323198 | 2022-03-19 | Camp | Texas | 48063 | 2831 | 74 |
2301337 | 2301337 | 2022-03-13 | Unknown | Connecticut | 2831 | 7 | |
2298085 | 2298085 | 2022-03-12 | Unknown | Connecticut | 2831 | 7 | |
2294833 | 2294833 | 2022-03-11 | Unknown | Connecticut | 2831 | 7 | |
2262794 | 2262794 | 2022-03-01 | Allamakee | Iowa | 19005 | 2831 | 59 |
2259543 | 2259543 | 2022-02-28 | Allamakee | Iowa | 19005 | 2831 | 59 |
2256292 | 2256292 | 2022-02-27 | Allamakee | Iowa | 19005 | 2831 | 59 |
2258570 | 2258570 | 2022-02-27 | Jefferson | Washington | 53031 | 2831 | 27 |
2253041 | 2253041 | 2022-02-26 | Allamakee | Iowa | 19005 | 2831 | 59 |
2255319 | 2255319 | 2022-02-26 | Jefferson | Washington | 53031 | 2831 | 27 |
2249790 | 2249790 | 2022-02-25 | Allamakee | Iowa | 19005 | 2831 | 59 |
2252068 | 2252068 | 2022-02-25 | Jefferson | Washington | 53031 | 2831 | 27 |
2246539 | 2246539 | 2022-02-24 | Allamakee | Iowa | 19005 | 2831 | 59 |
2248817 | 2248817 | 2022-02-24 | Jefferson | Washington | 53031 | 2831 | 25 |
2242506 | 2242506 | 2022-02-23 | Conecuh | Alabama | 1035 | 2831 | 65 |
2243288 | 2243288 | 2022-02-23 | Allamakee | Iowa | 19005 | 2831 | 59 |
2245566 | 2245566 | 2022-02-23 | Jefferson | Washington | 53031 | 2831 | 25 |
2213379 | 2213379 | 2022-02-14 | Lee | Arkansas | 5077 | 2831 | 55 |
2202366 | 2202366 | 2022-02-10 | Vinton | Ohio | 39163 | 2831 | 51 |
2196604 | 2196604 | 2022-02-08 | Juab | Utah | 49023 | 2831 | 22 |
2147793 | 2147793 | 2022-01-24 | Zapata | Texas | 48505 | 2831 | 47 |
2119286 | 2119286 | 2022-01-16 | Bleckley | Georgia | 13023 | 2831 | 86 |
2116034 | 2116034 | 2022-01-15 | Bleckley | Georgia | 13023 | 2831 | 86 |
2112783 | 2112783 | 2022-01-14 | Bleckley | Georgia | 13023 | 2831 | 86 |
2107858 | 2107858 | 2022-01-12 | Polk | North Carolina | 37149 | 2831 | 49 |
2058815 | 2058815 | 2021-12-28 | Gage | Nebraska | 31067 | 2831 | 31 |
2053510 | 2053510 | 2021-12-26 | San Juan | Utah | 49037 | 2831 | 45 |
2050260 | 2050260 | 2021-12-25 | San Juan | Utah | 49037 | 2831 | 45 |
2047010 | 2047010 | 2021-12-24 | San Juan | Utah | 49037 | 2831 | 45 |
2043760 | 2043760 | 2021-12-23 | San Juan | Utah | 49037 | 2831 | 45 |
2019255 | 2019255 | 2021-12-16 | Jackson | Louisiana | 22049 | 2831 | 64 |
2016005 | 2016005 | 2021-12-15 | Jackson | Louisiana | 22049 | 2831 | 64 |
2012754 | 2012754 | 2021-12-14 | Jackson | Louisiana | 22049 | 2831 | 64 |
1992237 | 1992237 | 2021-12-08 | Franklin | Arkansas | 5047 | 2831 | 56 |
1982473 | 1982473 | 2021-12-05 | Clay | Arkansas | 5021 | 2831 | 76 |
1979223 | 1979223 | 2021-12-04 | Clay | Arkansas | 5021 | 2831 | 75 |
1929004 | 1929004 | 2021-11-18 | Avery | North Carolina | 37011 | 2831 | 39 |
1925265 | 1925265 | 2021-11-17 | Calhoun | Mississippi | 28013 | 2831 | 49 |
1884621 | 1884621 | 2021-11-04 | Powhatan | Virginia | 51145 | 2831 | 28 |
1865223 | 1865223 | 2021-10-29 | Lincoln | West Virginia | 54043 | 2831 | 44 |
1831809 | 1831809 | 2021-10-19 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1828560 | 1828560 | 2021-10-18 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1825311 | 1825311 | 2021-10-17 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1822062 | 1822062 | 2021-10-16 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1818813 | 1818813 | 2021-10-15 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1815564 | 1815564 | 2021-10-14 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1812316 | 1812316 | 2021-10-13 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1803749 | 1803749 | 2021-10-11 | Drew | Arkansas | 5043 | 2831 | 54 |
1800500 | 1800500 | 2021-10-10 | Drew | Arkansas | 5043 | 2831 | 54 |
1800029 | 1800029 | 2021-10-09 | Bennington | Vermont | 50003 | 2831 | 26 |
1791868 | 1791868 | 2021-10-07 | Alpena | Michigan | 26007 | 2831 | 69 |
1793650 | 1793650 | 2021-10-07 | Radford city | Virginia | 51750 | 2831 | 30 |
1788619 | 1788619 | 2021-10-06 | Alpena | Michigan | 26007 | 2831 | 69 |
1777762 | 1777762 | 2021-10-03 | Grant | Arkansas | 5053 | 2831 | 47 |
1770683 | 1770683 | 2021-09-30 | Panola | Texas | 48365 | 2831 | 100 |
1755661 | 1755661 | 2021-09-26 | Starke | Indiana | 18149 | 2831 | 66 |
1752413 | 1752413 | 2021-09-25 | Starke | Indiana | 18149 | 2831 | 66 |
1749164 | 1749164 | 2021-09-24 | Starke | Indiana | 18149 | 2831 | 66 |
1745302 | 1745302 | 2021-09-23 | Polk | Arkansas | 5113 | 2831 | 97 |
1720221 | 1720221 | 2021-09-15 | McCreary | Kentucky | 21147 | 2831 | 37 |
1699304 | 1699304 | 2021-09-08 | Sevier | Utah | 49041 | 2831 | 16 |
1679280 | 1679280 | 2021-09-02 | Juncos | Puerto Rico | 72077 | 2831 | |
1679559 | 1679559 | 2021-09-02 | Burleson | Texas | 48051 | 2831 | 51 |
1673669 | 1673669 | 2021-09-01 | Butler | Alabama | 1013 | 2831 | 75 |
1669933 | 1669933 | 2021-08-30 | Lavaca | Texas | 48285 | 2831 | 79 |
1663038 | 1663038 | 2021-08-28 | Humacao | Puerto Rico | 72069 | 2831 | |
1631722 | 1631722 | 2021-08-19 | Morgan | Colorado | 8087 | 2831 | 96 |
1633824 | 1633824 | 2021-08-19 | Rio Grande | Puerto Rico | 72119 | 2831 | |
1630177 | 1630177 | 2021-08-18 | Transylvania | North Carolina | 37175 | 2831 | 33 |
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);