ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
311 rows where cases = 1831 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 47
- Virginia 25
- Kentucky 23
- Illinois 16
- Iowa 15
- Tennessee 15
- Georgia 12
- Michigan 12
- Missouri 12
- Oklahoma 12
- Puerto Rico 11
- Arkansas 9
- Indiana 8
- Minnesota 8
- West Virginia 8
- Wisconsin 7
- Mississippi 6
- North Carolina 6
- Alabama 5
- California 5
- Oregon 5
- Colorado 4
- Kansas 4
- Ohio 4
- Maryland 3
- New Mexico 3
- Pennsylvania 3
- Florida 2
- Idaho 2
- Montana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500419 | 2500419 | 2022-05-13 | Ida | Iowa | 19093 | 1831 | 49 |
2501268 | 2501268 | 2022-05-13 | Cuming | Nebraska | 31039 | 1831 | 15 |
2497161 | 2497161 | 2022-05-12 | Ida | Iowa | 19093 | 1831 | 49 |
2499380 | 2499380 | 2022-05-12 | Williamsburg city | Virginia | 51830 | 1831 | 22 |
2493903 | 2493903 | 2022-05-11 | Ida | Iowa | 19093 | 1831 | 49 |
2440710 | 2440710 | 2022-04-24 | Middlesex | Virginia | 51119 | 1831 | 47 |
2437454 | 2437454 | 2022-04-23 | Middlesex | Virginia | 51119 | 1831 | 47 |
2434198 | 2434198 | 2022-04-22 | Middlesex | Virginia | 51119 | 1831 | 47 |
2430942 | 2430942 | 2022-04-21 | Middlesex | Virginia | 51119 | 1831 | 47 |
2421174 | 2421174 | 2022-04-18 | Middlesex | Virginia | 51119 | 1831 | 46 |
2395227 | 2395227 | 2022-04-10 | Calhoun | West Virginia | 54013 | 1831 | 13 |
2391971 | 2391971 | 2022-04-09 | Calhoun | West Virginia | 54013 | 1831 | 13 |
2388715 | 2388715 | 2022-04-08 | Calhoun | West Virginia | 54013 | 1831 | 13 |
2385460 | 2385460 | 2022-04-07 | Calhoun | West Virginia | 54013 | 1831 | 13 |
2382205 | 2382205 | 2022-04-06 | Calhoun | West Virginia | 54013 | 1831 | 13 |
2368900 | 2368900 | 2022-04-02 | Rains | Texas | 48379 | 1831 | 59 |
2365172 | 2365172 | 2022-04-01 | Arroyo | Puerto Rico | 72015 | 1831 | |
2365199 | 2365199 | 2022-04-01 | Hormigueros | Puerto Rico | 72067 | 1831 | |
2365647 | 2365647 | 2022-04-01 | Rains | Texas | 48379 | 1831 | 59 |
2362394 | 2362394 | 2022-03-31 | Rains | Texas | 48379 | 1831 | 59 |
2359140 | 2359140 | 2022-03-30 | Rains | Texas | 48379 | 1831 | 59 |
2355886 | 2355886 | 2022-03-29 | Rains | Texas | 48379 | 1831 | 59 |
2352633 | 2352633 | 2022-03-28 | Rains | Texas | 48379 | 1831 | 59 |
2352658 | 2352658 | 2022-03-28 | Stephens | Texas | 48429 | 1831 | 45 |
2349381 | 2349381 | 2022-03-27 | Rains | Texas | 48379 | 1831 | 59 |
2349406 | 2349406 | 2022-03-27 | Stephens | Texas | 48429 | 1831 | 45 |
2346128 | 2346128 | 2022-03-26 | Rains | Texas | 48379 | 1831 | 59 |
2346153 | 2346153 | 2022-03-26 | Stephens | Texas | 48429 | 1831 | 45 |
2342875 | 2342875 | 2022-03-25 | Rains | Texas | 48379 | 1831 | 59 |
2339622 | 2339622 | 2022-03-24 | Rains | Texas | 48379 | 1831 | 59 |
2336368 | 2336368 | 2022-03-23 | Rains | Texas | 48379 | 1831 | 59 |
2333114 | 2333114 | 2022-03-22 | Rains | Texas | 48379 | 1831 | 59 |
2329861 | 2329861 | 2022-03-21 | Rains | Texas | 48379 | 1831 | 58 |
2326609 | 2326609 | 2022-03-20 | Rains | Texas | 48379 | 1831 | 58 |
2323356 | 2323356 | 2022-03-19 | Rains | Texas | 48379 | 1831 | 58 |
2320102 | 2320102 | 2022-03-18 | Rains | Texas | 48379 | 1831 | 58 |
2316848 | 2316848 | 2022-03-17 | Rains | Texas | 48379 | 1831 | 58 |
2313595 | 2313595 | 2022-03-16 | Rains | Texas | 48379 | 1831 | 58 |
2310342 | 2310342 | 2022-03-15 | Rains | Texas | 48379 | 1831 | 58 |
2307089 | 2307089 | 2022-03-14 | Rains | Texas | 48379 | 1831 | 57 |
2286048 | 2286048 | 2022-03-08 | Lake | Michigan | 26085 | 1831 | 35 |
2282796 | 2282796 | 2022-03-07 | Lake | Michigan | 26085 | 1831 | 35 |
2264613 | 2264613 | 2022-03-01 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2260686 | 2260686 | 2022-02-28 | Gates | North Carolina | 37073 | 1831 | 19 |
2261363 | 2261363 | 2022-02-28 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2258112 | 2258112 | 2022-02-27 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2254861 | 2254861 | 2022-02-26 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2251610 | 2251610 | 2022-02-25 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2248359 | 2248359 | 2022-02-24 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2245108 | 2245108 | 2022-02-23 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2177915 | 2177915 | 2022-02-03 | Irwin | Georgia | 13155 | 1831 | 42 |
2170637 | 2170637 | 2022-01-31 | Buena Vista city | Virginia | 51530 | 1831 | 36 |
2159964 | 2159964 | 2022-01-28 | Pembina | North Dakota | 38067 | 1831 | 16 |
2160771 | 2160771 | 2022-01-28 | Swisher | Texas | 48437 | 1831 | 30 |
2148850 | 2148850 | 2022-01-25 | Schuyler | Illinois | 17169 | 1831 | 27 |
2145335 | 2145335 | 2022-01-24 | Clinch | Georgia | 13065 | 1831 | 37 |
2127443 | 2127443 | 2022-01-18 | Traill | North Dakota | 38097 | 1831 | 21 |
2092877 | 2092877 | 2022-01-08 | Bullock | Alabama | 1011 | 1831 | 46 |
2078017 | 2078017 | 2022-01-03 | Swift | Minnesota | 27151 | 1831 | 30 |
2057689 | 2057689 | 2021-12-28 | Franklin | Idaho | 16041 | 1831 | 26 |
2058104 | 2058104 | 2021-12-28 | Thomas | Kansas | 20193 | 1831 | 23 |
2054855 | 2054855 | 2021-12-27 | Thomas | Kansas | 20193 | 1831 | 23 |
2056272 | 2056272 | 2021-12-27 | Yauco | Puerto Rico | 72153 | 1831 | |
2039007 | 2039007 | 2021-12-22 | Rock | Minnesota | 27133 | 1831 | 32 |
2034877 | 2034877 | 2021-12-21 | Screven | Georgia | 13251 | 1831 | 62 |
2018750 | 2018750 | 2021-12-16 | Jasper | Illinois | 17079 | 1831 | 23 |
2008886 | 2008886 | 2021-12-13 | Towns | Georgia | 13281 | 1831 | 84 |
1973117 | 1973117 | 2021-12-02 | Screven | Georgia | 13251 | 1831 | 62 |
1920773 | 1920773 | 2021-11-16 | Stone | Arkansas | 5137 | 1831 | 44 |
1921812 | 1921812 | 2021-11-16 | Kent | Maryland | 24029 | 1831 | 56 |
1918562 | 1918562 | 2021-11-15 | Kent | Maryland | 24029 | 1831 | 56 |
1901114 | 1901114 | 2021-11-10 | Coosa | Alabama | 1037 | 1831 | 43 |
1874504 | 1874504 | 2021-11-01 | Callahan | Texas | 48059 | 1831 | 55 |
1869850 | 1869850 | 2021-10-31 | Arenac | Michigan | 26011 | 1831 | 34 |
1869871 | 1869871 | 2021-10-31 | Gogebic | Michigan | 26053 | 1831 | 54 |
1871255 | 1871255 | 2021-10-31 | Callahan | Texas | 48059 | 1831 | 55 |
1866601 | 1866601 | 2021-10-30 | Arenac | Michigan | 26011 | 1831 | 34 |
1866622 | 1866622 | 2021-10-30 | Gogebic | Michigan | 26053 | 1831 | 54 |
1868006 | 1868006 | 2021-10-30 | Callahan | Texas | 48059 | 1831 | 55 |
1863352 | 1863352 | 2021-10-29 | Arenac | Michigan | 26011 | 1831 | 34 |
1863373 | 1863373 | 2021-10-29 | Gogebic | Michigan | 26053 | 1831 | 54 |
1851589 | 1851589 | 2021-10-25 | Dewey | South Dakota | 46041 | 1831 | 31 |
1837665 | 1837665 | 2021-10-21 | Linn | Missouri | 29115 | 1831 | 26 |
1838425 | 1838425 | 2021-10-21 | Potter | Pennsylvania | 42105 | 1831 | 44 |
1838678 | 1838678 | 2021-10-21 | Houston | Tennessee | 47083 | 1831 | 43 |
1814263 | 1814263 | 2021-10-14 | Allen | Kansas | 20001 | 1831 | 25 |
1810556 | 1810556 | 2021-10-13 | Early | Georgia | 13099 | 1831 | 57 |
1811014 | 1811014 | 2021-10-13 | Allen | Kansas | 20001 | 1831 | 25 |
1807946 | 1807946 | 2021-10-12 | Martin | Kentucky | 21159 | 1831 | 35 |
1769533 | 1769533 | 2021-09-30 | Roosevelt | Montana | 30085 | 1831 | 57 |
1769868 | 1769868 | 2021-09-30 | Swain | North Carolina | 37173 | 1831 | 22 |
1762568 | 1762568 | 2021-09-28 | Franklin | Maine | 23007 | 1831 | 18 |
1760358 | 1760358 | 2021-09-27 | Baker | Oregon | 41001 | 1831 | 24 |
1733172 | 1733172 | 2021-09-19 | Estill | Kentucky | 21065 | 1831 | 12 |
1735331 | 1735331 | 2021-09-19 | Marquette | Wisconsin | 55077 | 1831 | 29 |
1729922 | 1729922 | 2021-09-18 | Estill | Kentucky | 21065 | 1831 | 12 |
1732081 | 1732081 | 2021-09-18 | Marquette | Wisconsin | 55077 | 1831 | 29 |
1726672 | 1726672 | 2021-09-17 | Estill | Kentucky | 21065 | 1831 | 12 |
1728831 | 1728831 | 2021-09-17 | Marquette | Wisconsin | 55077 | 1831 | 29 |
1722144 | 1722144 | 2021-09-15 | Martinsville city | Virginia | 51690 | 1831 | 84 |
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);