ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
237 rows where cases = 2364 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 29
- Kentucky 16
- Texas 15
- Georgia 13
- Nebraska 12
- Idaho 10
- Oklahoma 10
- Virginia 9
- Louisiana 8
- North Carolina 8
- Ohio 8
- Alaska 7
- Puerto Rico 7
- Mississippi 6
- Alabama 5
- Colorado 5
- Indiana 5
- Missouri 5
- Tennessee 5
- Wisconsin 5
- Kansas 4
- Pennsylvania 4
- Washington 4
- Illinois 3
- Michigan 3
- Minnesota 3
- New Mexico 3
- New York 3
- West Virginia 3
- Arkansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490630 | 2490630 | 2022-05-10 | Emmet | Iowa | 19063 | 2364 | 52 |
2487373 | 2487373 | 2022-05-09 | Emmet | Iowa | 19063 | 2364 | 52 |
2484115 | 2484115 | 2022-05-08 | Emmet | Iowa | 19063 | 2364 | 52 |
2485032 | 2485032 | 2022-05-08 | Red Willow | Nebraska | 31145 | 2364 | 20 |
2480857 | 2480857 | 2022-05-07 | Emmet | Iowa | 19063 | 2364 | 52 |
2481774 | 2481774 | 2022-05-07 | Red Willow | Nebraska | 31145 | 2364 | 20 |
2477599 | 2477599 | 2022-05-06 | Emmet | Iowa | 19063 | 2364 | 52 |
2478516 | 2478516 | 2022-05-06 | Red Willow | Nebraska | 31145 | 2364 | 20 |
2474341 | 2474341 | 2022-05-05 | Emmet | Iowa | 19063 | 2364 | 52 |
2475258 | 2475258 | 2022-05-05 | Red Willow | Nebraska | 31145 | 2364 | 20 |
2471084 | 2471084 | 2022-05-04 | Emmet | Iowa | 19063 | 2364 | 52 |
2472001 | 2472001 | 2022-05-04 | Red Willow | Nebraska | 31145 | 2364 | 20 |
2459630 | 2459630 | 2022-04-30 | Rincon | Puerto Rico | 72117 | 2364 | |
2427503 | 2427503 | 2022-04-20 | Runnels | Texas | 48399 | 2364 | 66 |
2382099 | 2382099 | 2022-04-06 | Lunenburg | Virginia | 51111 | 2364 | 36 |
2314631 | 2314631 | 2022-03-17 | Washington | Idaho | 16087 | 2364 | 56 |
2311378 | 2311378 | 2022-03-16 | Washington | Idaho | 16087 | 2364 | 56 |
2289625 | 2289625 | 2022-03-09 | Wayne | Missouri | 29223 | 2364 | 47 |
2269791 | 2269791 | 2022-03-03 | Mackinac | Michigan | 26097 | 2364 | 28 |
2266538 | 2266538 | 2022-03-02 | Mackinac | Michigan | 26097 | 2364 | 28 |
2251352 | 2251352 | 2022-02-25 | Florida | Puerto Rico | 72054 | 2364 | |
2240775 | 2240775 | 2022-02-22 | Grundy | Missouri | 29079 | 2364 | 63 |
2201266 | 2201266 | 2022-02-10 | Hancock | Kentucky | 21091 | 2364 | 20 |
2147725 | 2147725 | 2022-01-24 | Pecos | Texas | 48371 | 2364 | 60 |
2129240 | 2129240 | 2022-01-19 | Teton | Idaho | 16081 | 2364 | 8 |
2130232 | 2130232 | 2022-01-19 | Ripley | Missouri | 29181 | 2364 | 53 |
2124792 | 2124792 | 2022-01-17 | Callahan | Texas | 48059 | 2364 | 62 |
2088215 | 2088215 | 2022-01-06 | Torrance | New Mexico | 35057 | 2364 | 37 |
2050694 | 2050694 | 2021-12-26 | Nome Census Area | Alaska | 2180 | 2364 | 3 |
2047444 | 2047444 | 2021-12-25 | Nome Census Area | Alaska | 2180 | 2364 | 3 |
2044194 | 2044194 | 2021-12-24 | Nome Census Area | Alaska | 2180 | 2364 | 3 |
2040945 | 2040945 | 2021-12-23 | Nome Census Area | Alaska | 2180 | 2364 | 3 |
2037695 | 2037695 | 2021-12-22 | Nome Census Area | Alaska | 2180 | 2364 | 3 |
2040844 | 2040844 | 2021-12-22 | Converse | Wyoming | 56009 | 2364 | 48 |
2037519 | 2037519 | 2021-12-21 | Ashland | Wisconsin | 55003 | 2364 | 24 |
2037594 | 2037594 | 2021-12-21 | Converse | Wyoming | 56009 | 2364 | 48 |
2018193 | 2018193 | 2021-12-16 | Northwest Arctic Borough | Alaska | 2188 | 2364 | 9 |
2014943 | 2014943 | 2021-12-15 | Northwest Arctic Borough | Alaska | 2188 | 2364 | 9 |
2015129 | 2015129 | 2021-12-15 | Grand | Colorado | 8049 | 2364 | 18 |
2011878 | 2011878 | 2021-12-14 | Grand | Colorado | 8049 | 2364 | 18 |
2008627 | 2008627 | 2021-12-13 | Grand | Colorado | 8049 | 2364 | 17 |
2008939 | 2008939 | 2021-12-13 | Idaho | Idaho | 16049 | 2364 | 39 |
2010200 | 2010200 | 2021-12-13 | Socorro | New Mexico | 35053 | 2364 | 66 |
1995756 | 1995756 | 2021-12-09 | Bleckley | Georgia | 13023 | 2364 | 85 |
1998375 | 1998375 | 2021-12-09 | Patrick | Virginia | 51141 | 2364 | 60 |
1989663 | 1989663 | 2021-12-07 | Cass | Iowa | 19029 | 2364 | 67 |
1986413 | 1986413 | 2021-12-06 | Cass | Iowa | 19029 | 2364 | 67 |
1986638 | 1986638 | 2021-12-06 | Fleming | Kentucky | 21069 | 2364 | 41 |
1983163 | 1983163 | 2021-12-05 | Cass | Iowa | 19029 | 2364 | 67 |
1979913 | 1979913 | 2021-12-04 | Cass | Iowa | 19029 | 2364 | 67 |
1976433 | 1976433 | 2021-12-03 | Gooding | Idaho | 16047 | 2364 | 42 |
1976663 | 1976663 | 2021-12-03 | Cass | Iowa | 19029 | 2364 | 67 |
1973184 | 1973184 | 2021-12-02 | Gooding | Idaho | 16047 | 2364 | 42 |
1973414 | 1973414 | 2021-12-02 | Cass | Iowa | 19029 | 2364 | 67 |
1975582 | 1975582 | 2021-12-02 | Greene | Virginia | 51079 | 2364 | 45 |
1970164 | 1970164 | 2021-12-01 | Cass | Iowa | 19029 | 2364 | 67 |
1968914 | 1968914 | 2021-11-30 | Pecos | Texas | 48371 | 2364 | 55 |
1965663 | 1965663 | 2021-11-29 | Pecos | Texas | 48371 | 2364 | 55 |
1946287 | 1946287 | 2021-11-23 | Bristol city | Virginia | 51520 | 2364 | 49 |
1922344 | 1922344 | 2021-11-16 | Seward | Nebraska | 31159 | 2364 | 38 |
1909973 | 1909973 | 2021-11-12 | Manati | Puerto Rico | 72091 | 2364 | |
1903390 | 1903390 | 2021-11-10 | Fulton | Pennsylvania | 42057 | 2364 | 33 |
1893110 | 1893110 | 2021-11-07 | York | Nebraska | 31185 | 2364 | 19 |
1889860 | 1889860 | 2021-11-06 | York | Nebraska | 31185 | 2364 | 19 |
1886610 | 1886610 | 2021-11-05 | York | Nebraska | 31185 | 2364 | 19 |
1883361 | 1883361 | 2021-11-04 | York | Nebraska | 31185 | 2364 | 19 |
1880112 | 1880112 | 2021-11-03 | York | Nebraska | 31185 | 2364 | 19 |
1881216 | 1881216 | 2021-11-03 | Wilbarger | Texas | 48487 | 2364 | 62 |
1853419 | 1853419 | 2021-10-26 | Larue | Kentucky | 21123 | 2364 | 47 |
1839222 | 1839222 | 2021-10-21 | Hardy | West Virginia | 54031 | 2364 | 29 |
1833468 | 1833468 | 2021-10-20 | Carroll | Illinois | 17015 | 2364 | 39 |
1830673 | 1830673 | 2021-10-19 | Larue | Kentucky | 21123 | 2364 | 45 |
1826607 | 1826607 | 2021-10-18 | Alamosa | Colorado | 8003 | 2364 | 44 |
1790634 | 1790634 | 2021-10-07 | Clay | Alabama | 1027 | 2364 | 66 |
1785026 | 1785026 | 2021-10-05 | Bourbon | Kansas | 20011 | 2364 | 41 |
1781777 | 1781777 | 2021-10-04 | Bourbon | Kansas | 20011 | 2364 | 41 |
1779539 | 1779539 | 2021-10-03 | Bertie | North Carolina | 37015 | 2364 | 49 |
1776289 | 1776289 | 2021-10-02 | Bertie | North Carolina | 37015 | 2364 | 49 |
1773039 | 1773039 | 2021-10-01 | Bertie | North Carolina | 37015 | 2364 | 49 |
1767012 | 1767012 | 2021-09-29 | Naranjito | Puerto Rico | 72105 | 2364 | |
1762006 | 1762006 | 2021-09-28 | Ford | Illinois | 17053 | 2364 | 66 |
1759244 | 1759244 | 2021-09-27 | Union | Kentucky | 21225 | 2364 | 25 |
1738166 | 1738166 | 2021-09-20 | Madison | Texas | 48313 | 2364 | 40 |
1733266 | 1733266 | 2021-09-19 | Bienville | Louisiana | 22013 | 2364 | 87 |
1734916 | 1734916 | 2021-09-19 | Madison | Texas | 48313 | 2364 | 40 |
1730016 | 1730016 | 2021-09-18 | Bienville | Louisiana | 22013 | 2364 | 87 |
1731012 | 1731012 | 2021-09-18 | Paulding | Ohio | 39125 | 2364 | 42 |
1731666 | 1731666 | 2021-09-18 | Madison | Texas | 48313 | 2364 | 40 |
1726766 | 1726766 | 2021-09-17 | Bienville | Louisiana | 22013 | 2364 | 87 |
1716709 | 1716709 | 2021-09-14 | Clay | Iowa | 19041 | 2364 | 27 |
1719108 | 1719108 | 2021-09-14 | Vernon | Wisconsin | 55123 | 2364 | 49 |
1713463 | 1713463 | 2021-09-13 | Clay | Iowa | 19041 | 2364 | 27 |
1714536 | 1714536 | 2021-09-13 | Seneca | New York | 36099 | 2364 | 58 |
1710216 | 1710216 | 2021-09-12 | Clay | Iowa | 19041 | 2364 | 27 |
1711731 | 1711731 | 2021-09-12 | Aguada | Puerto Rico | 72003 | 2364 | |
1706969 | 1706969 | 2021-09-11 | Clay | Iowa | 19041 | 2364 | 27 |
1703721 | 1703721 | 2021-09-10 | Clay | Iowa | 19041 | 2364 | 27 |
1705259 | 1705259 | 2021-09-10 | Corozal | Puerto Rico | 72047 | 2364 | |
1700471 | 1700471 | 2021-09-09 | Clay | Iowa | 19041 | 2364 | 27 |
1697222 | 1697222 | 2021-09-08 | Clay | Iowa | 19041 | 2364 | 27 |
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);