ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where cases = 2681 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 17
- Oklahoma 16
- Texas 15
- Georgia 12
- Virginia 11
- Florida 10
- Iowa 8
- Kansas 7
- North Carolina 7
- Ohio 7
- Tennessee 7
- Alabama 6
- Minnesota 6
- New York 6
- Wisconsin 6
- Arkansas 5
- Indiana 5
- Kentucky 5
- Louisiana 5
- Nebraska 5
- Puerto Rico 4
- Alaska 3
- Michigan 3
- North Dakota 3
- Pennsylvania 3
- South Carolina 3
- Washington 3
- Idaho 2
- Mississippi 2
- Oregon 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499662 | 2499662 | 2022-05-13 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 |
2496404 | 2496404 | 2022-05-12 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 |
2493146 | 2493146 | 2022-05-11 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 |
2475912 | 2475912 | 2022-05-05 | Sabana Grande | Puerto Rico | 72121 | 2681 | |
2470180 | 2470180 | 2022-05-03 | Forest | Wisconsin | 55041 | 2681 | 52 |
2466924 | 2466924 | 2022-05-02 | Forest | Wisconsin | 55041 | 2681 | 52 |
2461129 | 2461129 | 2022-05-01 | Jasper | Illinois | 17079 | 2681 | 32 |
2463669 | 2463669 | 2022-05-01 | Forest | Wisconsin | 55041 | 2681 | 52 |
2457873 | 2457873 | 2022-04-30 | Jasper | Illinois | 17079 | 2681 | 32 |
2460413 | 2460413 | 2022-04-30 | Forest | Wisconsin | 55041 | 2681 | 52 |
2454617 | 2454617 | 2022-04-29 | Jasper | Illinois | 17079 | 2681 | 32 |
2457157 | 2457157 | 2022-04-29 | Forest | Wisconsin | 55041 | 2681 | 52 |
2451361 | 2451361 | 2022-04-28 | Jasper | Illinois | 17079 | 2681 | 32 |
2448105 | 2448105 | 2022-04-27 | Jasper | Illinois | 17079 | 2681 | 32 |
2444849 | 2444849 | 2022-04-26 | Jasper | Illinois | 17079 | 2681 | 32 |
2445024 | 2445024 | 2022-04-26 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2441593 | 2441593 | 2022-04-25 | Jasper | Illinois | 17079 | 2681 | 32 |
2441768 | 2441768 | 2022-04-25 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2438512 | 2438512 | 2022-04-24 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2435256 | 2435256 | 2022-04-23 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2432000 | 2432000 | 2022-04-22 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2428744 | 2428744 | 2022-04-21 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2425488 | 2425488 | 2022-04-20 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2359335 | 2359335 | 2022-03-30 | Nelson | Virginia | 51125 | 2681 | 32 |
2198999 | 2198999 | 2022-02-09 | McLean | North Dakota | 38055 | 2681 | 49 |
2178447 | 2178447 | 2022-02-03 | Wilson | Kansas | 20205 | 2681 | 35 |
2175194 | 2175194 | 2022-02-02 | Wilson | Kansas | 20205 | 2681 | 35 |
2160071 | 2160071 | 2022-01-28 | Vinton | Ohio | 39163 | 2681 | 47 |
2106033 | 2106033 | 2022-01-12 | Marion | Arkansas | 5089 | 2681 | 75 |
2100042 | 2100042 | 2022-01-10 | Menard | Illinois | 17129 | 2681 | 19 |
2098016 | 2098016 | 2022-01-09 | Schuyler | New York | 36097 | 2681 | 23 |
2092256 | 2092256 | 2022-01-07 | Bandera | Texas | 48019 | 2681 | 65 |
2089346 | 2089346 | 2022-01-06 | Giles | Virginia | 51071 | 2681 | 38 |
2068893 | 2068893 | 2021-12-31 | McKenzie | North Dakota | 38053 | 2681 | 23 |
2060380 | 2060380 | 2021-12-29 | Crenshaw | Alabama | 1041 | 2681 | 79 |
2061887 | 2061887 | 2021-12-29 | Dallas | Missouri | 29059 | 2681 | 59 |
2063294 | 2063294 | 2021-12-29 | Appomattox | Virginia | 51011 | 2681 | 38 |
2021344 | 2021344 | 2021-12-16 | Goshen | Wyoming | 56015 | 2681 | 50 |
1989361 | 1989361 | 2021-12-07 | Rabun | Georgia | 13241 | 2681 | 76 |
1967993 | 1967993 | 2021-11-30 | Schoharie | New York | 36095 | 2681 | 24 |
1945546 | 1945546 | 2021-11-23 | Murray | Oklahoma | 40099 | 2681 | 53 |
1942295 | 1942295 | 2021-11-22 | Murray | Oklahoma | 40099 | 2681 | 53 |
1939045 | 1939045 | 2021-11-21 | Murray | Oklahoma | 40099 | 2681 | 53 |
1935795 | 1935795 | 2021-11-20 | Murray | Oklahoma | 40099 | 2681 | 53 |
1932545 | 1932545 | 2021-11-19 | Murray | Oklahoma | 40099 | 2681 | 53 |
1927697 | 1927697 | 2021-11-18 | Bond | Illinois | 17005 | 2681 | 34 |
1929294 | 1929294 | 2021-11-18 | Murray | Oklahoma | 40099 | 2681 | 53 |
1926044 | 1926044 | 2021-11-17 | Murray | Oklahoma | 40099 | 2681 | 53 |
1898460 | 1898460 | 2021-11-09 | Clay | Illinois | 17025 | 2681 | 59 |
1882662 | 1882662 | 2021-11-04 | Lawrence | Kentucky | 21127 | 2681 | 40 |
1857377 | 1857377 | 2021-10-27 | Humboldt | Nevada | 32013 | 2681 | 32 |
1849578 | 1849578 | 2021-10-25 | Jefferson | Georgia | 13163 | 2681 | 86 |
1831805 | 1831805 | 2021-10-19 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1826941 | 1826941 | 2021-10-18 | Gem | Idaho | 16045 | 2681 | 55 |
1828556 | 1828556 | 2021-10-18 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1824459 | 1824459 | 2021-10-17 | Dodge | Minnesota | 27039 | 2681 | 9 |
1825307 | 1825307 | 2021-10-17 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1821210 | 1821210 | 2021-10-16 | Dodge | Minnesota | 27039 | 2681 | 9 |
1822058 | 1822058 | 2021-10-16 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1817961 | 1817961 | 2021-10-15 | Dodge | Minnesota | 27039 | 2681 | 9 |
1818809 | 1818809 | 2021-10-15 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1815560 | 1815560 | 2021-10-14 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1812312 | 1812312 | 2021-10-13 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1790756 | 1790756 | 2021-10-07 | Franklin | Arkansas | 5047 | 2681 | 52 |
1748161 | 1748161 | 2021-09-23 | Prince Edward | Virginia | 51147 | 2681 | 43 |
1738222 | 1738222 | 2021-09-20 | Shelby | Texas | 48419 | 2681 | 89 |
1734972 | 1734972 | 2021-09-19 | Shelby | Texas | 48419 | 2681 | 89 |
1731722 | 1731722 | 2021-09-18 | Shelby | Texas | 48419 | 2681 | 89 |
1725418 | 1725418 | 2021-09-16 | Radford city | Virginia | 51750 | 2681 | 29 |
1710665 | 1710665 | 2021-09-12 | Emmet | Michigan | 26047 | 2681 | 45 |
1707418 | 1707418 | 2021-09-11 | Emmet | Michigan | 26047 | 2681 | 45 |
1704171 | 1704171 | 2021-09-10 | Emmet | Michigan | 26047 | 2681 | 45 |
1669076 | 1669076 | 2021-08-30 | Ashe | North Carolina | 37009 | 2681 | 45 |
1654537 | 1654537 | 2021-08-26 | Madison | Florida | 12079 | 2681 | 45 |
1650983 | 1650983 | 2021-08-25 | Pickens | Alabama | 1107 | 2681 | 63 |
1651290 | 1651290 | 2021-08-25 | Madison | Florida | 12079 | 2681 | 45 |
1647734 | 1647734 | 2021-08-24 | Pickens | Alabama | 1107 | 2681 | 63 |
1648041 | 1648041 | 2021-08-24 | Madison | Florida | 12079 | 2681 | 45 |
1644485 | 1644485 | 2021-08-23 | Pickens | Alabama | 1107 | 2681 | 63 |
1644793 | 1644793 | 2021-08-23 | Madison | Florida | 12079 | 2681 | 45 |
1641543 | 1641543 | 2021-08-22 | Madison | Florida | 12079 | 2681 | 45 |
1638293 | 1638293 | 2021-08-21 | Madison | Florida | 12079 | 2681 | 45 |
1635043 | 1635043 | 2021-08-20 | Madison | Florida | 12079 | 2681 | 45 |
1630129 | 1630129 | 2021-08-18 | Greene | North Carolina | 37079 | 2681 | 49 |
1614274 | 1614274 | 2021-08-13 | Warren | Pennsylvania | 42123 | 2681 | 107 |
1605454 | 1605454 | 2021-08-11 | Barbour | Alabama | 1005 | 2681 | 64 |
1603423 | 1603423 | 2021-08-10 | Somerset | Maryland | 24039 | 2681 | 42 |
1596226 | 1596226 | 2021-08-08 | Tattnall | Georgia | 13267 | 2681 | 70 |
1596326 | 1596326 | 2021-08-08 | Douglas | Illinois | 17041 | 2681 | 42 |
1592977 | 1592977 | 2021-08-07 | Tattnall | Georgia | 13267 | 2681 | 70 |
1593077 | 1593077 | 2021-08-07 | Douglas | Illinois | 17041 | 2681 | 42 |
1589728 | 1589728 | 2021-08-06 | Tattnall | Georgia | 13267 | 2681 | 70 |
1589828 | 1589828 | 2021-08-06 | Douglas | Illinois | 17041 | 2681 | 42 |
1586444 | 1586444 | 2021-08-05 | McDuffie | Georgia | 13189 | 2681 | 52 |
1586579 | 1586579 | 2021-08-05 | Douglas | Illinois | 17041 | 2681 | 42 |
1588375 | 1588375 | 2021-08-05 | Abbeville | South Carolina | 45001 | 2681 | 41 |
1561877 | 1561877 | 2021-07-28 | Anson | North Carolina | 37007 | 2681 | 57 |
1556226 | 1556226 | 2021-07-26 | Karnes | Texas | 48255 | 2681 | 37 |
1552979 | 1552979 | 2021-07-25 | Karnes | Texas | 48255 | 2681 | 37 |
1549732 | 1549732 | 2021-07-24 | Karnes | Texas | 48255 | 2681 | 37 |
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);