ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
165 rows where cases = 3267 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 12
- Texas 11
- South Dakota 10
- Wyoming 9
- Arkansas 8
- Georgia 8
- Iowa 8
- North Dakota 8
- Utah 8
- South Carolina 7
- Virginia 7
- Michigan 6
- Missouri 6
- Kentucky 5
- Wisconsin 5
- Louisiana 4
- Puerto Rico 4
- Illinois 3
- Minnesota 3
- Nebraska 3
- Washington 3
- Alabama 2
- Colorado 2
- Hawaii 2
- Indiana 2
- Kansas 2
- Maryland 2
- Mississippi 2
- New Jersey 2
- Oklahoma 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500826 | 2500826 | 2022-05-13 | Arenac | Michigan | 26011 | 3267 | 67 |
2497568 | 2497568 | 2022-05-12 | Arenac | Michigan | 26011 | 3267 | 67 |
2498354 | 2498354 | 2022-05-12 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2494310 | 2494310 | 2022-05-11 | Arenac | Michigan | 26011 | 3267 | 67 |
2495096 | 2495096 | 2022-05-11 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2491838 | 2491838 | 2022-05-10 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2488580 | 2488580 | 2022-05-09 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2489492 | 2489492 | 2022-05-09 | Brunswick | Virginia | 51025 | 3267 | 47 |
2485323 | 2485323 | 2022-05-08 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2486499 | 2486499 | 2022-05-08 | Price | Wisconsin | 55099 | 3267 | 33 |
2482065 | 2482065 | 2022-05-07 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2483241 | 2483241 | 2022-05-07 | Price | Wisconsin | 55099 | 3267 | 33 |
2478807 | 2478807 | 2022-05-06 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2479983 | 2479983 | 2022-05-06 | Price | Wisconsin | 55099 | 3267 | 33 |
2470060 | 2470060 | 2022-05-03 | Westmoreland | Virginia | 51193 | 3267 | 51 |
2430827 | 2430827 | 2022-04-21 | Millard | Utah | 49027 | 3267 | 35 |
2427571 | 2427571 | 2022-04-20 | Millard | Utah | 49027 | 3267 | 35 |
2424315 | 2424315 | 2022-04-19 | Millard | Utah | 49027 | 3267 | 35 |
2421059 | 2421059 | 2022-04-18 | Millard | Utah | 49027 | 3267 | 35 |
2417803 | 2417803 | 2022-04-17 | Millard | Utah | 49027 | 3267 | 35 |
2414547 | 2414547 | 2022-04-16 | Millard | Utah | 49027 | 3267 | 35 |
2411291 | 2411291 | 2022-04-15 | Millard | Utah | 49027 | 3267 | 35 |
2408035 | 2408035 | 2022-04-14 | Millard | Utah | 49027 | 3267 | 35 |
2398412 | 2398412 | 2022-04-11 | Rockbridge | Virginia | 51163 | 3267 | 77 |
2356472 | 2356472 | 2022-03-30 | Little River | Arkansas | 5081 | 3267 | 102 |
2353219 | 2353219 | 2022-03-29 | Little River | Arkansas | 5081 | 3267 | 102 |
2355456 | 2355456 | 2022-03-29 | Naguabo | Puerto Rico | 72103 | 3267 | |
2349967 | 2349967 | 2022-03-28 | Little River | Arkansas | 5081 | 3267 | 102 |
2352203 | 2352203 | 2022-03-28 | Naguabo | Puerto Rico | 72103 | 3267 | |
2346714 | 2346714 | 2022-03-27 | Little River | Arkansas | 5081 | 3267 | 102 |
2348951 | 2348951 | 2022-03-27 | Naguabo | Puerto Rico | 72103 | 3267 | |
2343461 | 2343461 | 2022-03-26 | Little River | Arkansas | 5081 | 3267 | 102 |
2340208 | 2340208 | 2022-03-25 | Little River | Arkansas | 5081 | 3267 | 102 |
2257306 | 2257306 | 2022-02-27 | Unknown | New Jersey | 3267 | 0 | |
2244302 | 2244302 | 2022-02-23 | Unknown | New Jersey | 3267 | 0 | |
2179079 | 2179079 | 2022-02-03 | Glacier | Montana | 30035 | 3267 | 65 |
2168093 | 2168093 | 2022-01-31 | Brooks | Georgia | 13027 | 3267 | 77 |
2167673 | 2167673 | 2022-01-30 | Goshen | Wyoming | 56015 | 3267 | 53 |
2164418 | 2164418 | 2022-01-29 | Goshen | Wyoming | 56015 | 3267 | 53 |
2161163 | 2161163 | 2022-01-28 | Goshen | Wyoming | 56015 | 3267 | 53 |
2143216 | 2143216 | 2022-01-23 | Livingston | Missouri | 29117 | 3267 | 85 |
2130388 | 2130388 | 2022-01-19 | Saline | Nebraska | 31151 | 3267 | 8 |
2108326 | 2108326 | 2022-01-12 | Lee | South Carolina | 45061 | 3267 | 83 |
2102542 | 2102542 | 2022-01-10 | Crawford | Wisconsin | 55023 | 3267 | 26 |
2079056 | 2079056 | 2022-01-03 | Hampton | South Carolina | 45049 | 3267 | 75 |
2075805 | 2075805 | 2022-01-02 | Hampton | South Carolina | 45049 | 3267 | 75 |
2072554 | 2072554 | 2022-01-01 | Hampton | South Carolina | 45049 | 3267 | 75 |
2069303 | 2069303 | 2021-12-31 | Hampton | South Carolina | 45049 | 3267 | 75 |
2060849 | 2060849 | 2021-12-29 | Meriwether | Georgia | 13199 | 3267 | 121 |
2062204 | 2062204 | 2021-12-29 | Taos | New Mexico | 35055 | 3267 | 73 |
2056655 | 2056655 | 2021-12-27 | Montague | Texas | 48337 | 3267 | 99 |
2031093 | 2031093 | 2021-12-19 | Carbon | Wyoming | 56007 | 3267 | 46 |
2027842 | 2027842 | 2021-12-18 | Carbon | Wyoming | 56007 | 3267 | 46 |
2024591 | 2024591 | 2021-12-17 | Carbon | Wyoming | 56007 | 3267 | 46 |
2009372 | 2009372 | 2021-12-13 | Breckinridge | Kentucky | 21027 | 3267 | 48 |
2005661 | 2005661 | 2021-12-12 | Kauai | Hawaii | 15007 | 3267 | 13 |
1995518 | 1995518 | 2021-12-09 | Phillips | Arkansas | 5107 | 3267 | 78 |
1966502 | 1966502 | 2021-11-30 | Ben Hill | Georgia | 13017 | 3267 | 107 |
1941702 | 1941702 | 2021-11-22 | Vernon | Missouri | 29217 | 3267 | 78 |
1927387 | 1927387 | 2021-11-18 | Pitkin | Colorado | 8097 | 3267 | 6 |
1897168 | 1897168 | 2021-11-08 | Humphreys | Tennessee | 47085 | 3267 | 47 |
1893918 | 1893918 | 2021-11-07 | Humphreys | Tennessee | 47085 | 3267 | 47 |
1894407 | 1894407 | 2021-11-07 | Adams | Washington | 53001 | 3267 | 33 |
1889305 | 1889305 | 2021-11-06 | Caroline | Maryland | 24011 | 3267 | 51 |
1890668 | 1890668 | 2021-11-06 | Humphreys | Tennessee | 47085 | 3267 | 47 |
1891157 | 1891157 | 2021-11-06 | Adams | Washington | 53001 | 3267 | 33 |
1887418 | 1887418 | 2021-11-05 | Humphreys | Tennessee | 47085 | 3267 | 47 |
1887907 | 1887907 | 2021-11-05 | Adams | Washington | 53001 | 3267 | 33 |
1864753 | 1864753 | 2021-10-29 | Burleson | Texas | 48051 | 3267 | 59 |
1861290 | 1861290 | 2021-10-28 | Fairfield | South Carolina | 45039 | 3267 | 93 |
1849112 | 1849112 | 2021-10-25 | Butler | Alabama | 1013 | 3267 | 96 |
1848321 | 1848321 | 2021-10-24 | Beadle | South Dakota | 46005 | 3267 | 43 |
1845071 | 1845071 | 2021-10-23 | Beadle | South Dakota | 46005 | 3267 | 43 |
1841821 | 1841821 | 2021-10-22 | Beadle | South Dakota | 46005 | 3267 | 43 |
1830232 | 1830232 | 2021-10-19 | Douglas | Illinois | 17041 | 3267 | 43 |
1808439 | 1808439 | 2021-10-12 | New Madrid | Missouri | 29143 | 3267 | 55 |
1788100 | 1788100 | 2021-10-06 | Fountain | Indiana | 18045 | 3267 | 60 |
1781979 | 1781979 | 2021-10-04 | Rowan | Kentucky | 21205 | 3267 | 26 |
1774045 | 1774045 | 2021-10-01 | Rutland | Vermont | 50021 | 3267 | 26 |
1762188 | 1762188 | 2021-09-28 | Carroll | Iowa | 19027 | 3267 | 53 |
1758940 | 1758940 | 2021-09-27 | Carroll | Iowa | 19027 | 3267 | 53 |
1755692 | 1755692 | 2021-09-26 | Carroll | Iowa | 19027 | 3267 | 53 |
1752444 | 1752444 | 2021-09-25 | Carroll | Iowa | 19027 | 3267 | 53 |
1749195 | 1749195 | 2021-09-24 | Carroll | Iowa | 19027 | 3267 | 53 |
1745945 | 1745945 | 2021-09-23 | Carroll | Iowa | 19027 | 3267 | 53 |
1742696 | 1742696 | 2021-09-22 | Carroll | Iowa | 19027 | 3267 | 53 |
1718839 | 1718839 | 2021-09-14 | Carroll | Virginia | 51035 | 3267 | 81 |
1679680 | 1679680 | 2021-09-02 | Limestone | Texas | 48293 | 3267 | 90 |
1647672 | 1647672 | 2021-08-23 | Park | Wyoming | 56029 | 3267 | 35 |
1625987 | 1625987 | 2021-08-17 | Harlan | Kentucky | 21095 | 3267 | 93 |
1606477 | 1606477 | 2021-08-11 | Clay | Kentucky | 21051 | 3267 | 46 |
1606610 | 1606610 | 2021-08-11 | Pointe Coupee | Louisiana | 22077 | 3267 | 75 |
1604681 | 1604681 | 2021-08-10 | Davison | South Dakota | 46035 | 3267 | 69 |
1601432 | 1601432 | 2021-08-09 | Davison | South Dakota | 46035 | 3267 | 69 |
1598184 | 1598184 | 2021-08-08 | Davison | South Dakota | 46035 | 3267 | 69 |
1594935 | 1594935 | 2021-08-07 | Davison | South Dakota | 46035 | 3267 | 69 |
1591686 | 1591686 | 2021-08-06 | Davison | South Dakota | 46035 | 3267 | 69 |
1588437 | 1588437 | 2021-08-05 | Davison | South Dakota | 46035 | 3267 | 69 |
1585187 | 1585187 | 2021-08-04 | Davison | South Dakota | 46035 | 3267 | 69 |
1576249 | 1576249 | 2021-08-02 | Lawrence | Alabama | 1079 | 3267 | 100 |
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);