ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
163 rows where cases = 3738 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 14
- Tennessee 13
- Virginia 13
- Texas 12
- Kentucky 11
- Ohio 10
- Oklahoma 7
- Georgia 6
- Minnesota 6
- North Carolina 6
- Alabama 5
- Arkansas 5
- Illinois 5
- Louisiana 5
- Pennsylvania 4
- Colorado 3
- Michigan 3
- Mississippi 3
- Missouri 3
- Nebraska 3
- New York 3
- Washington 3
- California 2
- Puerto Rico 2
- South Carolina 2
- West Virginia 2
- Wisconsin 2
- Arizona 1
- Florida 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502131 | 2502131 | 2022-05-13 | Decatur | Tennessee | 47039 | 3738 | 70 |
2498873 | 2498873 | 2022-05-12 | Decatur | Tennessee | 47039 | 3738 | 70 |
2495615 | 2495615 | 2022-05-11 | Decatur | Tennessee | 47039 | 3738 | 70 |
2492357 | 2492357 | 2022-05-10 | Decatur | Tennessee | 47039 | 3738 | 70 |
2489099 | 2489099 | 2022-05-09 | Decatur | Tennessee | 47039 | 3738 | 70 |
2485842 | 2485842 | 2022-05-08 | Decatur | Tennessee | 47039 | 3738 | 70 |
2482584 | 2482584 | 2022-05-07 | Decatur | Tennessee | 47039 | 3738 | 70 |
2482912 | 2482912 | 2022-05-07 | Zapata | Texas | 48505 | 3738 | 55 |
2479326 | 2479326 | 2022-05-06 | Decatur | Tennessee | 47039 | 3738 | 70 |
2476068 | 2476068 | 2022-05-05 | Decatur | Tennessee | 47039 | 3738 | 70 |
2472811 | 2472811 | 2022-05-04 | Decatur | Tennessee | 47039 | 3738 | 70 |
2467766 | 2467766 | 2022-05-03 | Pike | Indiana | 18125 | 3738 | 49 |
2464511 | 2464511 | 2022-05-02 | Pike | Indiana | 18125 | 3738 | 49 |
2393162 | 2393162 | 2022-04-10 | Green | Kentucky | 21087 | 3738 | 44 |
2389906 | 2389906 | 2022-04-09 | Green | Kentucky | 21087 | 3738 | 44 |
2386650 | 2386650 | 2022-04-08 | Green | Kentucky | 21087 | 3738 | 44 |
2388000 | 2388000 | 2022-04-08 | Quebradillas | Puerto Rico | 72115 | 3738 | |
2383395 | 2383395 | 2022-04-07 | Green | Kentucky | 21087 | 3738 | 44 |
2380140 | 2380140 | 2022-04-06 | Green | Kentucky | 21087 | 3738 | 44 |
2376885 | 2376885 | 2022-04-05 | Green | Kentucky | 21087 | 3738 | 44 |
2373633 | 2373633 | 2022-04-04 | Green | Kentucky | 21087 | 3738 | 44 |
2333233 | 2333233 | 2022-03-22 | Appomattox | Virginia | 51011 | 3738 | 51 |
2328393 | 2328393 | 2022-03-21 | Faribault | Minnesota | 27043 | 3738 | 50 |
2329980 | 2329980 | 2022-03-21 | Appomattox | Virginia | 51011 | 3738 | 51 |
2325140 | 2325140 | 2022-03-20 | Faribault | Minnesota | 27043 | 3738 | 50 |
2321886 | 2321886 | 2022-03-19 | Faribault | Minnesota | 27043 | 3738 | 50 |
2318632 | 2318632 | 2022-03-18 | Faribault | Minnesota | 27043 | 3738 | 50 |
2305777 | 2305777 | 2022-03-14 | Bates | Missouri | 29013 | 3738 | 89 |
2297217 | 2297217 | 2022-03-11 | Falls | Texas | 48145 | 3738 | 63 |
2284903 | 2284903 | 2022-03-08 | Howard | Arkansas | 5061 | 3738 | 48 |
2239372 | 2239372 | 2022-02-22 | Franklin | Arkansas | 5047 | 3738 | 68 |
2235681 | 2235681 | 2022-02-20 | Buckingham | Virginia | 51029 | 3738 | 48 |
2232430 | 2232430 | 2022-02-19 | Buckingham | Virginia | 51029 | 3738 | 48 |
2229179 | 2229179 | 2022-02-18 | Buckingham | Virginia | 51029 | 3738 | 48 |
2216425 | 2216425 | 2022-02-14 | Marquette | Wisconsin | 55077 | 3738 | 48 |
2173854 | 2173854 | 2022-02-01 | Addison | Vermont | 50001 | 3738 | 13 |
2150335 | 2150335 | 2022-01-25 | Craig | Oklahoma | 40035 | 3738 | 40 |
2147083 | 2147083 | 2022-01-24 | Craig | Oklahoma | 40035 | 3738 | 40 |
2143829 | 2143829 | 2022-01-23 | Craig | Oklahoma | 40035 | 3738 | 40 |
2140574 | 2140574 | 2022-01-22 | Craig | Oklahoma | 40035 | 3738 | 40 |
2137318 | 2137318 | 2022-01-21 | Craig | Oklahoma | 40035 | 3738 | 40 |
2134064 | 2134064 | 2022-01-20 | Craig | Oklahoma | 40035 | 3738 | 40 |
2130812 | 2130812 | 2022-01-19 | Craig | Oklahoma | 40035 | 3738 | 40 |
2098047 | 2098047 | 2022-01-09 | Caswell | North Carolina | 37033 | 3738 | 39 |
2094795 | 2094795 | 2022-01-08 | Caswell | North Carolina | 37033 | 3738 | 39 |
2091543 | 2091543 | 2022-01-07 | Caswell | North Carolina | 37033 | 3738 | 39 |
2064084 | 2064084 | 2021-12-30 | Jones | Georgia | 13169 | 3738 | 99 |
2005728 | 2005728 | 2021-12-12 | Douglas | Illinois | 17041 | 3738 | 44 |
2005835 | 2005835 | 2021-12-12 | Fulton | Indiana | 18049 | 3738 | 75 |
2002477 | 2002477 | 2021-12-11 | Douglas | Illinois | 17041 | 3738 | 44 |
2002584 | 2002584 | 2021-12-11 | Fulton | Indiana | 18049 | 3738 | 75 |
1999227 | 1999227 | 2021-12-10 | Douglas | Illinois | 17041 | 3738 | 44 |
1999334 | 1999334 | 2021-12-10 | Fulton | Indiana | 18049 | 3738 | 75 |
1976969 | 1976969 | 2021-12-03 | Wayne | Kentucky | 21231 | 3738 | 71 |
1978672 | 1978672 | 2021-12-03 | Reeves | Texas | 48389 | 3738 | 59 |
1949778 | 1949778 | 2021-11-24 | Jackson | Wisconsin | 55053 | 3738 | 34 |
1939899 | 1939899 | 2021-11-21 | Waynesboro city | Virginia | 51820 | 3738 | 50 |
1936649 | 1936649 | 2021-11-20 | Waynesboro city | Virginia | 51820 | 3738 | 50 |
1933399 | 1933399 | 2021-11-19 | Waynesboro city | Virginia | 51820 | 3738 | 50 |
1923147 | 1923147 | 2021-11-16 | Fentress | Tennessee | 47049 | 3738 | 68 |
1888000 | 1888000 | 2021-11-05 | Wyoming | West Virginia | 54109 | 3738 | 65 |
1879452 | 1879452 | 2021-11-03 | Rowan | Kentucky | 21205 | 3738 | 30 |
1869928 | 1869928 | 2021-10-31 | Wexford | Michigan | 26165 | 3738 | 53 |
1866679 | 1866679 | 2021-10-30 | Wexford | Michigan | 26165 | 3738 | 53 |
1863430 | 1863430 | 2021-10-29 | Wexford | Michigan | 26165 | 3738 | 53 |
1863604 | 1863604 | 2021-10-29 | Audrain | Missouri | 29007 | 3738 | 64 |
1858976 | 1858976 | 2021-10-28 | Cleburne | Arkansas | 5023 | 3738 | 91 |
1855146 | 1855146 | 2021-10-26 | Milam | Texas | 48331 | 3738 | 83 |
1852144 | 1852144 | 2021-10-25 | Russell | Virginia | 51167 | 3738 | 60 |
1826806 | 1826806 | 2021-10-18 | Fannin | Georgia | 13111 | 3738 | 101 |
1807973 | 1807973 | 2021-10-12 | Russell | Kentucky | 21207 | 3738 | 59 |
1809285 | 1809285 | 2021-10-12 | Abbeville | South Carolina | 45001 | 3738 | 47 |
1804722 | 1804722 | 2021-10-11 | Russell | Kentucky | 21207 | 3738 | 59 |
1780332 | 1780332 | 2021-10-03 | Frio | Texas | 48163 | 3738 | 65 |
1777082 | 1777082 | 2021-10-02 | Frio | Texas | 48163 | 3738 | 65 |
1773832 | 1773832 | 2021-10-01 | Frio | Texas | 48163 | 3738 | 65 |
1770582 | 1770582 | 2021-09-30 | Frio | Texas | 48163 | 3738 | 65 |
1741080 | 1741080 | 2021-09-21 | Jasper | South Carolina | 45053 | 3738 | 65 |
1716607 | 1716607 | 2021-09-14 | Clay | Indiana | 18021 | 3738 | 54 |
1715302 | 1715302 | 2021-09-13 | Cass | Texas | 48067 | 3738 | 111 |
1712056 | 1712056 | 2021-09-12 | Cass | Texas | 48067 | 3738 | 111 |
1708809 | 1708809 | 2021-09-11 | Cass | Texas | 48067 | 3738 | 111 |
1702035 | 1702035 | 2021-09-09 | Mayaguez | Puerto Rico | 72097 | 3738 | |
1702586 | 1702586 | 2021-09-09 | Amherst | Virginia | 51009 | 3738 | 44 |
1672231 | 1672231 | 2021-08-31 | Cibola | New Mexico | 35006 | 3738 | 130 |
1654849 | 1654849 | 2021-08-26 | Perry | Illinois | 17145 | 3738 | 75 |
1652811 | 1652811 | 2021-08-25 | Otsego | New York | 36077 | 3738 | 48 |
1652999 | 1652999 | 2021-08-25 | Champaign | Ohio | 39021 | 3738 | 60 |
1644261 | 1644261 | 2021-08-22 | Kittitas | Washington | 53037 | 3738 | 39 |
1641011 | 1641011 | 2021-08-21 | Kittitas | Washington | 53037 | 3738 | 39 |
1637761 | 1637761 | 2021-08-20 | Kittitas | Washington | 53037 | 3738 | 39 |
1633286 | 1633286 | 2021-08-19 | Chenango | New York | 36017 | 3738 | 79 |
1619187 | 1619187 | 2021-08-15 | Jefferson | Indiana | 18077 | 3738 | 88 |
1615939 | 1615939 | 2021-08-14 | Jefferson | Indiana | 18077 | 3738 | 88 |
1612690 | 1612690 | 2021-08-13 | Jefferson | Indiana | 18077 | 3738 | 88 |
1583209 | 1583209 | 2021-08-04 | Pickens | Georgia | 13227 | 3738 | 79 |
1582095 | 1582095 | 2021-08-03 | Bee | Texas | 48025 | 3738 | 75 |
1503643 | 1503643 | 2021-07-10 | Ottawa | Ohio | 39123 | 3738 | 81 |
1500397 | 1500397 | 2021-07-09 | Ottawa | Ohio | 39123 | 3738 | 81 |
1497151 | 1497151 | 2021-07-08 | Ottawa | Ohio | 39123 | 3738 | 81 |
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);