ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
366 rows where cases = 1588 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 62
- Virginia 26
- Wyoming 24
- Missouri 21
- Texas 20
- Georgia 13
- Alabama 12
- Illinois 11
- Mississippi 11
- North Carolina 11
- Tennessee 11
- West Virginia 11
- Louisiana 10
- Wisconsin 10
- Florida 9
- Minnesota 9
- Nebraska 9
- Indiana 8
- Kentucky 8
- Utah 8
- Arkansas 7
- Michigan 7
- Puerto Rico 7
- Montana 6
- Kansas 5
- California 3
- Colorado 3
- New York 3
- Oklahoma 3
- South Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500373 | 2500373 | 2022-05-13 | Adair | Iowa | 19001 | 1588 | 50 |
2502832 | 2502832 | 2022-05-13 | Weston | Wyoming | 56045 | 1588 | 18 |
2497115 | 2497115 | 2022-05-12 | Adair | Iowa | 19001 | 1588 | 50 |
2499574 | 2499574 | 2022-05-12 | Weston | Wyoming | 56045 | 1588 | 18 |
2493314 | 2493314 | 2022-05-11 | Clear Creek | Colorado | 8019 | 1588 | 12 |
2493857 | 2493857 | 2022-05-11 | Adair | Iowa | 19001 | 1588 | 50 |
2496316 | 2496316 | 2022-05-11 | Weston | Wyoming | 56045 | 1588 | 18 |
2490599 | 2490599 | 2022-05-10 | Adair | Iowa | 19001 | 1588 | 50 |
2493058 | 2493058 | 2022-05-10 | Weston | Wyoming | 56045 | 1588 | 18 |
2487342 | 2487342 | 2022-05-09 | Adair | Iowa | 19001 | 1588 | 50 |
2484084 | 2484084 | 2022-05-08 | Adair | Iowa | 19001 | 1588 | 50 |
2480826 | 2480826 | 2022-05-07 | Adair | Iowa | 19001 | 1588 | 50 |
2477568 | 2477568 | 2022-05-06 | Adair | Iowa | 19001 | 1588 | 50 |
2474310 | 2474310 | 2022-05-05 | Adair | Iowa | 19001 | 1588 | 50 |
2475111 | 2475111 | 2022-05-05 | Shelby | Missouri | 29205 | 1588 | 15 |
2471053 | 2471053 | 2022-05-04 | Adair | Iowa | 19001 | 1588 | 50 |
2466998 | 2466998 | 2022-05-02 | Weston | Wyoming | 56045 | 1588 | 18 |
2463743 | 2463743 | 2022-05-01 | Weston | Wyoming | 56045 | 1588 | 18 |
2460487 | 2460487 | 2022-04-30 | Weston | Wyoming | 56045 | 1588 | 18 |
2457231 | 2457231 | 2022-04-29 | Weston | Wyoming | 56045 | 1588 | 18 |
2453975 | 2453975 | 2022-04-28 | Weston | Wyoming | 56045 | 1588 | 18 |
2450719 | 2450719 | 2022-04-27 | Weston | Wyoming | 56045 | 1588 | 18 |
2447463 | 2447463 | 2022-04-26 | Weston | Wyoming | 56045 | 1588 | 18 |
2398625 | 2398625 | 2022-04-11 | Weston | Wyoming | 56045 | 1588 | 18 |
2395370 | 2395370 | 2022-04-10 | Weston | Wyoming | 56045 | 1588 | 18 |
2392114 | 2392114 | 2022-04-09 | Weston | Wyoming | 56045 | 1588 | 18 |
2388858 | 2388858 | 2022-04-08 | Weston | Wyoming | 56045 | 1588 | 18 |
2385603 | 2385603 | 2022-04-07 | Weston | Wyoming | 56045 | 1588 | 18 |
2382348 | 2382348 | 2022-04-06 | Weston | Wyoming | 56045 | 1588 | 18 |
2379093 | 2379093 | 2022-04-05 | Weston | Wyoming | 56045 | 1588 | 18 |
2375839 | 2375839 | 2022-04-04 | Weston | Wyoming | 56045 | 1588 | 18 |
2372587 | 2372587 | 2022-04-03 | Weston | Wyoming | 56045 | 1588 | 18 |
2369334 | 2369334 | 2022-04-02 | Weston | Wyoming | 56045 | 1588 | 18 |
2366081 | 2366081 | 2022-04-01 | Weston | Wyoming | 56045 | 1588 | 18 |
2331168 | 2331168 | 2022-03-22 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2327916 | 2327916 | 2022-03-21 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2324663 | 2324663 | 2022-03-20 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2321409 | 2321409 | 2022-03-19 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2318155 | 2318155 | 2022-03-18 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2314902 | 2314902 | 2022-03-17 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2311649 | 2311649 | 2022-03-16 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2283105 | 2283105 | 2022-03-07 | Shannon | Missouri | 29203 | 1588 | 35 |
2279852 | 2279852 | 2022-03-06 | Shannon | Missouri | 29203 | 1588 | 35 |
2276599 | 2276599 | 2022-03-05 | Shannon | Missouri | 29203 | 1588 | 35 |
2273346 | 2273346 | 2022-03-04 | Shannon | Missouri | 29203 | 1588 | 35 |
2246220 | 2246220 | 2022-02-24 | Lincoln | Georgia | 13181 | 1588 | 35 |
2242969 | 2242969 | 2022-02-23 | Lincoln | Georgia | 13181 | 1588 | 35 |
2239718 | 2239718 | 2022-02-22 | Lincoln | Georgia | 13181 | 1588 | 35 |
2236467 | 2236467 | 2022-02-21 | Lincoln | Georgia | 13181 | 1588 | 35 |
2187734 | 2187734 | 2022-02-06 | Treutlen | Georgia | 13283 | 1588 | 58 |
2184481 | 2184481 | 2022-02-05 | Treutlen | Georgia | 13283 | 1588 | 58 |
2181229 | 2181229 | 2022-02-04 | Treutlen | Georgia | 13283 | 1588 | 58 |
2177136 | 2177136 | 2022-02-02 | Bland | Virginia | 51021 | 1588 | 19 |
2155914 | 2155914 | 2022-01-27 | Alcona | Michigan | 26001 | 1588 | 63 |
2152661 | 2152661 | 2022-01-26 | Alcona | Michigan | 26001 | 1588 | 63 |
2130332 | 2130332 | 2022-01-19 | Cuming | Nebraska | 31039 | 1588 | 15 |
2109596 | 2109596 | 2022-01-13 | Irwin | Georgia | 13155 | 1588 | 42 |
2110109 | 2110109 | 2022-01-13 | Russell | Kansas | 20167 | 1588 | 34 |
2110158 | 2110158 | 2022-01-13 | Crittenden | Kentucky | 21055 | 1588 | 39 |
2112374 | 2112374 | 2022-01-13 | Sublette | Wyoming | 56035 | 1588 | 24 |
2106858 | 2106858 | 2022-01-12 | Russell | Kansas | 20167 | 1588 | 34 |
2107917 | 2107917 | 2022-01-12 | Pembina | North Dakota | 38067 | 1588 | 16 |
2105287 | 2105287 | 2022-01-11 | Castro | Texas | 48069 | 1588 | 43 |
2095514 | 2095514 | 2022-01-08 | Blanco | Texas | 48031 | 1588 | 28 |
2063470 | 2063470 | 2021-12-29 | Gilmer | West Virginia | 54021 | 1588 | 15 |
2058531 | 2058531 | 2021-12-28 | Benton | Mississippi | 28009 | 1588 | 40 |
2041274 | 2041274 | 2021-12-23 | Candler | Georgia | 13043 | 1588 | 90 |
2039157 | 2039157 | 2021-12-22 | Iron | Missouri | 29093 | 1588 | 29 |
2032499 | 2032499 | 2021-12-20 | Pipestone | Minnesota | 27117 | 1588 | 30 |
2022902 | 2022902 | 2021-12-17 | Howard | Missouri | 29089 | 1588 | 19 |
2019180 | 2019180 | 2021-12-16 | Livingston | Kentucky | 21139 | 1588 | 47 |
1973579 | 1973579 | 2021-12-02 | Rice | Kansas | 20159 | 1588 | 16 |
1970329 | 1970329 | 2021-12-01 | Rice | Kansas | 20159 | 1588 | 16 |
1928662 | 1928662 | 2021-11-18 | Montgomery | Missouri | 29139 | 1588 | 32 |
1925429 | 1925429 | 2021-11-17 | Ralls | Missouri | 29173 | 1588 | 15 |
1893323 | 1893323 | 2021-11-07 | Perquimans | North Carolina | 37143 | 1588 | 15 |
1894343 | 1894343 | 2021-11-07 | Lexington city | Virginia | 51678 | 1588 | 36 |
1890073 | 1890073 | 2021-11-06 | Perquimans | North Carolina | 37143 | 1588 | 15 |
1891093 | 1891093 | 2021-11-06 | Lexington city | Virginia | 51678 | 1588 | 36 |
1886823 | 1886823 | 2021-11-05 | Perquimans | North Carolina | 37143 | 1588 | 15 |
1887843 | 1887843 | 2021-11-05 | Lexington city | Virginia | 51678 | 1588 | 36 |
1884593 | 1884593 | 2021-11-04 | Lexington city | Virginia | 51678 | 1588 | 36 |
1860145 | 1860145 | 2021-10-28 | Luce | Michigan | 26095 | 1588 | 6 |
1860391 | 1860391 | 2021-10-28 | Grundy | Missouri | 29079 | 1588 | 48 |
1860480 | 1860480 | 2021-10-28 | Deer Lodge | Montana | 30023 | 1588 | 24 |
1856896 | 1856896 | 2021-10-27 | Luce | Michigan | 26095 | 1588 | 6 |
1833998 | 1833998 | 2021-10-20 | East Carroll | Louisiana | 22035 | 1588 | 30 |
1830998 | 1830998 | 2021-10-19 | Pope | Minnesota | 27121 | 1588 | 8 |
1827078 | 1827078 | 2021-10-18 | Crawford | Indiana | 18025 | 1588 | 24 |
1825017 | 1825017 | 2021-10-17 | Yates | New York | 36123 | 1588 | 27 |
1805273 | 1805273 | 2021-10-11 | Richland | Montana | 30083 | 1588 | 18 |
1802024 | 1802024 | 2021-10-10 | Richland | Montana | 30083 | 1588 | 18 |
1798775 | 1798775 | 2021-10-09 | Richland | Montana | 30083 | 1588 | 18 |
1795526 | 1795526 | 2021-10-08 | Richland | Montana | 30083 | 1588 | 18 |
1792548 | 1792548 | 2021-10-07 | Clay | North Carolina | 37043 | 1588 | 34 |
1782093 | 1782093 | 2021-10-04 | Kent | Maryland | 24029 | 1588 | 53 |
1764582 | 1764582 | 2021-09-28 | Price | Wisconsin | 55099 | 1588 | 8 |
1761022 | 1761022 | 2021-09-27 | Morgan | Utah | 49029 | 1588 | 11 |
1755061 | 1755061 | 2021-09-26 | Stone | Arkansas | 5137 | 1588 | 39 |
1757774 | 1757774 | 2021-09-26 | Morgan | Utah | 49029 | 1588 | 11 |
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);