ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where cases = 2356 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 23
- Wyoming 21
- Illinois 11
- Michigan 11
- Texas 11
- Alabama 10
- Iowa 10
- North Carolina 10
- Idaho 8
- Indiana 8
- Kentucky 7
- Virginia 7
- Puerto Rico 6
- Arkansas 5
- Colorado 5
- Kansas 5
- Maryland 5
- Minnesota 5
- New York 5
- West Virginia 5
- Florida 4
- Missouri 4
- Ohio 4
- Montana 3
- Nevada 3
- South Carolina 3
- Maine 2
- Mississippi 2
- Pennsylvania 2
- Tennessee 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489799 | 2489799 | 2022-05-09 | Washakie | Wyoming | 56043 | 2356 | 44 |
2486542 | 2486542 | 2022-05-08 | Washakie | Wyoming | 56043 | 2356 | 44 |
2483284 | 2483284 | 2022-05-07 | Washakie | Wyoming | 56043 | 2356 | 44 |
2480026 | 2480026 | 2022-05-06 | Washakie | Wyoming | 56043 | 2356 | 44 |
2476768 | 2476768 | 2022-05-05 | Washakie | Wyoming | 56043 | 2356 | 44 |
2473510 | 2473510 | 2022-05-04 | Washakie | Wyoming | 56043 | 2356 | 44 |
2470253 | 2470253 | 2022-05-03 | Washakie | Wyoming | 56043 | 2356 | 44 |
2443981 | 2443981 | 2022-04-25 | Poquoson city | Virginia | 51735 | 2356 | 30 |
2444206 | 2444206 | 2022-04-25 | Washakie | Wyoming | 56043 | 2356 | 44 |
2440950 | 2440950 | 2022-04-24 | Washakie | Wyoming | 56043 | 2356 | 44 |
2437694 | 2437694 | 2022-04-23 | Washakie | Wyoming | 56043 | 2356 | 44 |
2434438 | 2434438 | 2022-04-22 | Washakie | Wyoming | 56043 | 2356 | 44 |
2431182 | 2431182 | 2022-04-21 | Washakie | Wyoming | 56043 | 2356 | 44 |
2427926 | 2427926 | 2022-04-20 | Washakie | Wyoming | 56043 | 2356 | 44 |
2424670 | 2424670 | 2022-04-19 | Washakie | Wyoming | 56043 | 2356 | 44 |
2421414 | 2421414 | 2022-04-18 | Washakie | Wyoming | 56043 | 2356 | 43 |
2418158 | 2418158 | 2022-04-17 | Washakie | Wyoming | 56043 | 2356 | 43 |
2414902 | 2414902 | 2022-04-16 | Washakie | Wyoming | 56043 | 2356 | 43 |
2411646 | 2411646 | 2022-04-15 | Washakie | Wyoming | 56043 | 2356 | 43 |
2408390 | 2408390 | 2022-04-14 | Washakie | Wyoming | 56043 | 2356 | 43 |
2405134 | 2405134 | 2022-04-13 | Washakie | Wyoming | 56043 | 2356 | 43 |
2401879 | 2401879 | 2022-04-12 | Washakie | Wyoming | 56043 | 2356 | 43 |
2362579 | 2362579 | 2022-03-31 | Lunenburg | Virginia | 51111 | 2356 | 35 |
2347007 | 2347007 | 2022-03-27 | Evans | Georgia | 13109 | 2356 | 65 |
2343754 | 2343754 | 2022-03-26 | Evans | Georgia | 13109 | 2356 | 65 |
2340501 | 2340501 | 2022-03-25 | Evans | Georgia | 13109 | 2356 | 65 |
2330740 | 2330740 | 2022-03-22 | Evans | Georgia | 13109 | 2356 | 65 |
2327488 | 2327488 | 2022-03-21 | Evans | Georgia | 13109 | 2356 | 65 |
2324235 | 2324235 | 2022-03-20 | Evans | Georgia | 13109 | 2356 | 65 |
2320981 | 2320981 | 2022-03-19 | Evans | Georgia | 13109 | 2356 | 65 |
2317727 | 2317727 | 2022-03-18 | Evans | Georgia | 13109 | 2356 | 65 |
2263287 | 2263287 | 2022-03-01 | Mackinac | Michigan | 26097 | 2356 | 28 |
2260036 | 2260036 | 2022-02-28 | Mackinac | Michigan | 26097 | 2356 | 28 |
2240231 | 2240231 | 2022-02-22 | Thomas | Kansas | 20193 | 2356 | 27 |
2236980 | 2236980 | 2022-02-21 | Thomas | Kansas | 20193 | 2356 | 27 |
2233172 | 2233172 | 2022-02-20 | Dooly | Georgia | 13093 | 2356 | 65 |
2229921 | 2229921 | 2022-02-19 | Dooly | Georgia | 13093 | 2356 | 65 |
2226670 | 2226670 | 2022-02-18 | Dooly | Georgia | 13093 | 2356 | 65 |
2200017 | 2200017 | 2022-02-09 | Sussex | Virginia | 51183 | 2356 | 33 |
2186325 | 2186325 | 2022-02-05 | Lajas | Puerto Rico | 72079 | 2356 | |
2175781 | 2175781 | 2022-02-02 | Ralls | Missouri | 29173 | 2356 | 19 |
2176838 | 2176838 | 2022-02-02 | Blanco | Texas | 48031 | 2356 | 30 |
2173740 | 2173740 | 2022-02-01 | Morris | Texas | 48343 | 2356 | 61 |
2166090 | 2166090 | 2022-01-30 | Richland | Montana | 30083 | 2356 | 30 |
2166815 | 2166815 | 2022-01-30 | Luquillo | Puerto Rico | 72089 | 2356 | |
2162835 | 2162835 | 2022-01-29 | Richland | Montana | 30083 | 2356 | 30 |
2159580 | 2159580 | 2022-01-28 | Richland | Montana | 30083 | 2356 | 30 |
2152014 | 2152014 | 2022-01-26 | Shoshone | Idaho | 16079 | 2356 | 70 |
2142418 | 2142418 | 2022-01-23 | Newton | Indiana | 18111 | 2356 | 63 |
2144471 | 2144471 | 2022-01-23 | Pecos | Texas | 48371 | 2356 | 60 |
2139163 | 2139163 | 2022-01-22 | Newton | Indiana | 18111 | 2356 | 63 |
2135326 | 2135326 | 2022-01-21 | Stone | Arkansas | 5137 | 2356 | 51 |
2135907 | 2135907 | 2022-01-21 | Newton | Indiana | 18111 | 2356 | 63 |
2128706 | 2128706 | 2022-01-19 | Wilcox | Alabama | 1131 | 2356 | 38 |
2130053 | 2130053 | 2022-01-19 | Watonwan | Minnesota | 27165 | 2356 | 22 |
2051043 | 2051043 | 2021-12-26 | Dade | Georgia | 13083 | 2356 | 22 |
2047793 | 2047793 | 2021-12-25 | Dade | Georgia | 13083 | 2356 | 22 |
2044543 | 2044543 | 2021-12-24 | Dade | Georgia | 13083 | 2356 | 22 |
1995624 | 1995624 | 2021-12-09 | Grand | Colorado | 8049 | 2356 | 17 |
1989696 | 1989696 | 2021-12-07 | Iowa | Iowa | 19095 | 2356 | 36 |
1986446 | 1986446 | 2021-12-06 | Iowa | Iowa | 19095 | 2356 | 36 |
1983196 | 1983196 | 2021-12-05 | Iowa | Iowa | 19095 | 2356 | 36 |
1979946 | 1979946 | 2021-12-04 | Iowa | Iowa | 19095 | 2356 | 36 |
1976696 | 1976696 | 2021-12-03 | Iowa | Iowa | 19095 | 2356 | 36 |
1973447 | 1973447 | 2021-12-02 | Iowa | Iowa | 19095 | 2356 | 36 |
1970197 | 1970197 | 2021-12-01 | Iowa | Iowa | 19095 | 2356 | 36 |
1947789 | 1947789 | 2021-11-24 | Knox | Maine | 23013 | 2356 | 15 |
1944373 | 1944373 | 2021-11-23 | Clinton | Kentucky | 21053 | 2356 | 35 |
1946257 | 1946257 | 2021-11-23 | Caledonia | Vermont | 50005 | 2356 | 21 |
1925227 | 1925227 | 2021-11-17 | Pennington | Minnesota | 27113 | 2356 | 29 |
1884741 | 1884741 | 2021-11-04 | Taylor | West Virginia | 54091 | 2356 | 38 |
1878385 | 1878385 | 2021-11-03 | Lamar | Alabama | 1075 | 2356 | 51 |
1827752 | 1827752 | 2021-10-18 | Redwood | Minnesota | 27127 | 2356 | 43 |
1823721 | 1823721 | 2021-10-17 | Carroll | Illinois | 17015 | 2356 | 39 |
1820472 | 1820472 | 2021-10-16 | Carroll | Illinois | 17015 | 2356 | 39 |
1817223 | 1817223 | 2021-10-15 | Carroll | Illinois | 17015 | 2356 | 39 |
1777915 | 1777915 | 2021-10-03 | Otero | Colorado | 8089 | 2356 | 75 |
1774665 | 1774665 | 2021-10-02 | Otero | Colorado | 8089 | 2356 | 75 |
1771415 | 1771415 | 2021-10-01 | Otero | Colorado | 8089 | 2356 | 75 |
1755286 | 1755286 | 2021-09-26 | Brooks | Georgia | 13027 | 2356 | 60 |
1756191 | 1756191 | 2021-09-26 | Osceola | Michigan | 26133 | 2356 | 34 |
1752038 | 1752038 | 2021-09-25 | Brooks | Georgia | 13027 | 2356 | 60 |
1752943 | 1752943 | 2021-09-25 | Osceola | Michigan | 26133 | 2356 | 34 |
1748789 | 1748789 | 2021-09-24 | Brooks | Georgia | 13027 | 2356 | 60 |
1749695 | 1749695 | 2021-09-24 | Osceola | Michigan | 26133 | 2356 | 34 |
1745763 | 1745763 | 2021-09-23 | Ford | Illinois | 17053 | 2356 | 64 |
1746214 | 1746214 | 2021-09-23 | Mason | Kentucky | 21161 | 2356 | 49 |
1741762 | 1741762 | 2021-09-21 | McDowell | West Virginia | 54047 | 2356 | 30 |
1731218 | 1731218 | 2021-09-18 | Wyoming | Pennsylvania | 42131 | 2356 | 55 |
1716855 | 1716855 | 2021-09-14 | Neosho | Kansas | 20133 | 2356 | 43 |
1713609 | 1713609 | 2021-09-13 | Neosho | Kansas | 20133 | 2356 | 43 |
1695539 | 1695539 | 2021-09-07 | Moca | Puerto Rico | 72099 | 2356 | |
1680334 | 1680334 | 2021-09-03 | Sharp | Arkansas | 5135 | 2356 | 57 |
1671637 | 1671637 | 2021-08-31 | Talbot | Maryland | 24041 | 2356 | 48 |
1669871 | 1669871 | 2021-08-30 | Freestone | Texas | 48161 | 2356 | 55 |
1665215 | 1665215 | 2021-08-29 | Mason | Michigan | 26105 | 2356 | 39 |
1661967 | 1661967 | 2021-08-28 | Mason | Michigan | 26105 | 2356 | 39 |
1658719 | 1658719 | 2021-08-27 | Mason | Michigan | 26105 | 2356 | 39 |
1630106 | 1630106 | 2021-08-18 | Caswell | North Carolina | 37033 | 2356 | 30 |
1624989 | 1624989 | 2021-08-17 | Monroe | Alabama | 1099 | 2356 | 42 |
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);