ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
491 rows where cases = 817 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 72
- Georgia 31
- Iowa 29
- Mississippi 24
- Puerto Rico 23
- Virginia 23
- Nebraska 21
- South Dakota 18
- Indiana 17
- Kansas 17
- Kentucky 17
- Missouri 14
- Colorado 13
- West Virginia 13
- Arkansas 12
- Minnesota 11
- Ohio 11
- Wisconsin 10
- Tennessee 9
- North Carolina 8
- North Dakota 8
- Montana 7
- New Mexico 7
- Alabama 6
- Idaho 6
- Illinois 6
- Louisiana 6
- Washington 6
- Wyoming 5
- New Jersey 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502400 | 2502400 | 2022-05-13 | Real | Texas | 48385 | 817 | 25 |
2499142 | 2499142 | 2022-05-12 | Real | Texas | 48385 | 817 | 25 |
2495884 | 2495884 | 2022-05-11 | Real | Texas | 48385 | 817 | 25 |
2492626 | 2492626 | 2022-05-10 | Real | Texas | 48385 | 817 | 25 |
2489368 | 2489368 | 2022-05-09 | Real | Texas | 48385 | 817 | 25 |
2472898 | 2472898 | 2022-05-04 | Baylor | Texas | 48023 | 817 | 32 |
2469642 | 2469642 | 2022-05-03 | Baylor | Texas | 48023 | 817 | 32 |
2466386 | 2466386 | 2022-05-02 | Baylor | Texas | 48023 | 817 | 32 |
2463131 | 2463131 | 2022-05-01 | Baylor | Texas | 48023 | 817 | 32 |
2459875 | 2459875 | 2022-04-30 | Baylor | Texas | 48023 | 817 | 32 |
2456619 | 2456619 | 2022-04-29 | Baylor | Texas | 48023 | 817 | 32 |
2445007 | 2445007 | 2022-04-26 | Adams | Iowa | 19003 | 817 | 13 |
2441751 | 2441751 | 2022-04-25 | Adams | Iowa | 19003 | 817 | 13 |
2438495 | 2438495 | 2022-04-24 | Adams | Iowa | 19003 | 817 | 13 |
2435239 | 2435239 | 2022-04-23 | Adams | Iowa | 19003 | 817 | 13 |
2431983 | 2431983 | 2022-04-22 | Adams | Iowa | 19003 | 817 | 13 |
2428727 | 2428727 | 2022-04-21 | Adams | Iowa | 19003 | 817 | 13 |
2425471 | 2425471 | 2022-04-20 | Adams | Iowa | 19003 | 817 | 13 |
2376638 | 2376638 | 2022-04-05 | Adams | Iowa | 19003 | 817 | 13 |
2373386 | 2373386 | 2022-04-04 | Adams | Iowa | 19003 | 817 | 13 |
2370133 | 2370133 | 2022-04-03 | Adams | Iowa | 19003 | 817 | 13 |
2366880 | 2366880 | 2022-04-02 | Adams | Iowa | 19003 | 817 | 13 |
2363627 | 2363627 | 2022-04-01 | Adams | Iowa | 19003 | 817 | 13 |
2360373 | 2360373 | 2022-03-31 | Adams | Iowa | 19003 | 817 | 13 |
2357119 | 2357119 | 2022-03-30 | Adams | Iowa | 19003 | 817 | 13 |
2353866 | 2353866 | 2022-03-29 | Adams | Iowa | 19003 | 817 | 13 |
2350614 | 2350614 | 2022-03-28 | Adams | Iowa | 19003 | 817 | 13 |
2347361 | 2347361 | 2022-03-27 | Adams | Iowa | 19003 | 817 | 13 |
2344108 | 2344108 | 2022-03-26 | Adams | Iowa | 19003 | 817 | 13 |
2340855 | 2340855 | 2022-03-25 | Adams | Iowa | 19003 | 817 | 13 |
2337602 | 2337602 | 2022-03-24 | Adams | Iowa | 19003 | 817 | 13 |
2334348 | 2334348 | 2022-03-23 | Adams | Iowa | 19003 | 817 | 13 |
2269553 | 2269553 | 2022-03-03 | Hickman | Kentucky | 21105 | 817 | 23 |
2266300 | 2266300 | 2022-03-02 | Hickman | Kentucky | 21105 | 817 | 23 |
2263049 | 2263049 | 2022-03-01 | Hickman | Kentucky | 21105 | 817 | 23 |
2259798 | 2259798 | 2022-02-28 | Hickman | Kentucky | 21105 | 817 | 23 |
2194004 | 2194004 | 2022-02-08 | Phillips | Colorado | 8095 | 817 | 16 |
2190750 | 2190750 | 2022-02-07 | Phillips | Colorado | 8095 | 817 | 16 |
2193276 | 2193276 | 2022-02-07 | Reagan | Texas | 48383 | 817 | 13 |
2187495 | 2187495 | 2022-02-06 | Ouray | Colorado | 8091 | 817 | 6 |
2188110 | 2188110 | 2022-02-06 | Chautauqua | Kansas | 20019 | 817 | 16 |
2184242 | 2184242 | 2022-02-05 | Ouray | Colorado | 8091 | 817 | 6 |
2184857 | 2184857 | 2022-02-05 | Chautauqua | Kansas | 20019 | 817 | 16 |
2180990 | 2180990 | 2022-02-04 | Ouray | Colorado | 8091 | 817 | 6 |
2181605 | 2181605 | 2022-02-04 | Chautauqua | Kansas | 20019 | 817 | 16 |
2180113 | 2180113 | 2022-02-03 | Cochran | Texas | 48079 | 817 | 21 |
2128422 | 2128422 | 2022-01-18 | Rappahannock | Virginia | 51157 | 817 | 7 |
2117654 | 2117654 | 2022-01-15 | Foster | North Dakota | 38031 | 817 | 20 |
2111505 | 2111505 | 2022-01-13 | Las Marias | Puerto Rico | 72083 | 817 | |
2108356 | 2108356 | 2022-01-12 | Corson | South Dakota | 46031 | 817 | 15 |
2097350 | 2097350 | 2022-01-09 | Unknown | Maryland | 817 | 250 | |
2095546 | 2095546 | 2022-01-08 | Concho | Texas | 48095 | 817 | 10 |
2089364 | 2089364 | 2022-01-06 | King and Queen | Virginia | 51097 | 817 | 9 |
2078155 | 2078155 | 2022-01-03 | Holt | Missouri | 29087 | 817 | 24 |
2076094 | 2076094 | 2022-01-02 | Hemphill | Texas | 48211 | 817 | 3 |
2072843 | 2072843 | 2022-01-01 | Hemphill | Texas | 48211 | 817 | 3 |
2069592 | 2069592 | 2021-12-31 | Hemphill | Texas | 48211 | 817 | 3 |
2066341 | 2066341 | 2021-12-30 | Hemphill | Texas | 48211 | 817 | 3 |
2066559 | 2066559 | 2021-12-30 | Charles City | Virginia | 51036 | 817 | 22 |
2062115 | 2062115 | 2021-12-29 | Thayer | Nebraska | 31169 | 817 | 8 |
2056820 | 2056820 | 2021-12-27 | Cumberland | Virginia | 51049 | 817 | 19 |
2026200 | 2026200 | 2021-12-18 | Reynolds | Missouri | 29179 | 817 | 12 |
2020499 | 2020499 | 2021-12-16 | Penuelas | Puerto Rico | 72111 | 817 | |
2017248 | 2017248 | 2021-12-15 | Penuelas | Puerto Rico | 72111 | 817 | |
2013998 | 2013998 | 2021-12-14 | Penuelas | Puerto Rico | 72111 | 817 | |
2010747 | 2010747 | 2021-12-13 | Penuelas | Puerto Rico | 72111 | 817 | |
2007496 | 2007496 | 2021-12-12 | Penuelas | Puerto Rico | 72111 | 817 | |
2004245 | 2004245 | 2021-12-11 | Penuelas | Puerto Rico | 72111 | 817 | |
2000994 | 2000994 | 2021-12-10 | Penuelas | Puerto Rico | 72111 | 817 | |
1984028 | 1984028 | 2021-12-05 | Boone | Nebraska | 31011 | 817 | 4 |
1980778 | 1980778 | 2021-12-04 | Boone | Nebraska | 31011 | 817 | 4 |
1977528 | 1977528 | 2021-12-03 | Boone | Nebraska | 31011 | 817 | 4 |
1969990 | 1969990 | 2021-12-01 | Henderson | Illinois | 17071 | 817 | 23 |
1959873 | 1959873 | 2021-11-28 | Huerfano | Colorado | 8055 | 817 | 21 |
1961251 | 1961251 | 2021-11-28 | Pondera | Montana | 30073 | 817 | 6 |
1958000 | 1958000 | 2021-11-27 | Pondera | Montana | 30073 | 817 | 6 |
1954749 | 1954749 | 2021-11-26 | Pondera | Montana | 30073 | 817 | 6 |
1941845 | 1941845 | 2021-11-22 | Sheridan | Nebraska | 31161 | 817 | 23 |
1928071 | 1928071 | 2021-11-18 | Rooks | Kansas | 20163 | 817 | 13 |
1928835 | 1928835 | 2021-11-18 | Polk | Nebraska | 31143 | 817 | 18 |
1924821 | 1924821 | 2021-11-17 | Rooks | Kansas | 20163 | 817 | 13 |
1926356 | 1926356 | 2021-11-17 | Moody | South Dakota | 46101 | 817 | 21 |
1893027 | 1893027 | 2021-11-07 | Burt | Nebraska | 31021 | 817 | 12 |
1893119 | 1893119 | 2021-11-07 | Lander | Nevada | 32015 | 817 | 16 |
1893176 | 1893176 | 2021-11-07 | Los Alamos | New Mexico | 35028 | 817 | 9 |
1889777 | 1889777 | 2021-11-06 | Burt | Nebraska | 31021 | 817 | 12 |
1889869 | 1889869 | 2021-11-06 | Lander | Nevada | 32015 | 817 | 16 |
1889926 | 1889926 | 2021-11-06 | Los Alamos | New Mexico | 35028 | 817 | 9 |
1886527 | 1886527 | 2021-11-05 | Burt | Nebraska | 31021 | 817 | 12 |
1886619 | 1886619 | 2021-11-05 | Lander | Nevada | 32015 | 817 | 16 |
1886676 | 1886676 | 2021-11-05 | Los Alamos | New Mexico | 35028 | 817 | 9 |
1883278 | 1883278 | 2021-11-04 | Burt | Nebraska | 31021 | 817 | 12 |
1880029 | 1880029 | 2021-11-03 | Burt | Nebraska | 31021 | 817 | 12 |
1857977 | 1857977 | 2021-10-27 | Lajas | Puerto Rico | 72079 | 817 | |
1847521 | 1847521 | 2021-10-24 | Teton | Montana | 30099 | 817 | 9 |
1844271 | 1844271 | 2021-10-23 | Teton | Montana | 30099 | 817 | 9 |
1841021 | 1841021 | 2021-10-22 | Teton | Montana | 30099 | 817 | 9 |
1823014 | 1823014 | 2021-10-16 | Wirt | West Virginia | 54105 | 817 | 12 |
1814297 | 1814297 | 2021-10-14 | Gray | Kansas | 20069 | 817 | 15 |
1811048 | 1811048 | 2021-10-13 | Gray | Kansas | 20069 | 817 | 15 |
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);