ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
290 rows where cases = 1975 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 20
- Iowa 18
- Puerto Rico 16
- Arkansas 14
- Tennessee 14
- Missouri 13
- Texas 13
- Michigan 12
- Illinois 11
- Virginia 11
- Indiana 9
- North Dakota 9
- Louisiana 8
- Oklahoma 8
- West Virginia 8
- Kentucky 7
- Minnesota 7
- North Carolina 7
- Massachusetts 6
- Mississippi 6
- New Mexico 6
- South Carolina 6
- Alabama 5
- California 5
- Georgia 5
- Pennsylvania 5
- South Dakota 5
- Wisconsin 5
- Colorado 4
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497002 | 2497002 | 2022-05-12 | Schuyler | Illinois | 17169 | 1975 | 29 |
2474423 | 2474423 | 2022-05-05 | Clay | Kansas | 20027 | 1975 | 35 |
2475525 | 2475525 | 2022-05-05 | Benson | North Dakota | 38005 | 1975 | 23 |
2471166 | 2471166 | 2022-05-04 | Clay | Kansas | 20027 | 1975 | 35 |
2472268 | 2472268 | 2022-05-04 | Benson | North Dakota | 38005 | 1975 | 23 |
2467910 | 2467910 | 2022-05-03 | Clay | Kansas | 20027 | 1975 | 35 |
2469012 | 2469012 | 2022-05-03 | Benson | North Dakota | 38005 | 1975 | 23 |
2464655 | 2464655 | 2022-05-02 | Clay | Kansas | 20027 | 1975 | 35 |
2465756 | 2465756 | 2022-05-02 | Benson | North Dakota | 38005 | 1975 | 23 |
2461399 | 2461399 | 2022-05-01 | Clay | Kansas | 20027 | 1975 | 35 |
2462501 | 2462501 | 2022-05-01 | Benson | North Dakota | 38005 | 1975 | 23 |
2458143 | 2458143 | 2022-04-30 | Clay | Kansas | 20027 | 1975 | 35 |
2459245 | 2459245 | 2022-04-30 | Benson | North Dakota | 38005 | 1975 | 23 |
2454887 | 2454887 | 2022-04-29 | Clay | Kansas | 20027 | 1975 | 35 |
2455989 | 2455989 | 2022-04-29 | Benson | North Dakota | 38005 | 1975 | 23 |
2395087 | 2395087 | 2022-04-10 | Fairfax city | Virginia | 51600 | 1975 | 42 |
2391831 | 2391831 | 2022-04-09 | Fairfax city | Virginia | 51600 | 1975 | 42 |
2388575 | 2388575 | 2022-04-08 | Fairfax city | Virginia | 51600 | 1975 | 42 |
2289849 | 2289849 | 2022-03-09 | Quay | New Mexico | 35037 | 1975 | 49 |
2286597 | 2286597 | 2022-03-08 | Quay | New Mexico | 35037 | 1975 | 49 |
2266632 | 2266632 | 2022-03-02 | Pipestone | Minnesota | 27117 | 1975 | 34 |
2263381 | 2263381 | 2022-03-01 | Pipestone | Minnesota | 27117 | 1975 | 34 |
2248878 | 2248878 | 2022-02-24 | Pocahontas | West Virginia | 54075 | 1975 | 27 |
2214849 | 2214849 | 2022-02-14 | Carbon | Montana | 30009 | 1975 | 27 |
2215710 | 2215710 | 2022-02-14 | Custer | South Dakota | 46033 | 1975 | 22 |
2187378 | 2187378 | 2022-02-06 | Searcy | Arkansas | 5129 | 1975 | 38 |
2183808 | 2183808 | 2022-02-04 | Doddridge | West Virginia | 54017 | 1975 | 16 |
2126381 | 2126381 | 2022-01-18 | Thomas | Kansas | 20193 | 1975 | 23 |
2123129 | 2123129 | 2022-01-17 | Thomas | Kansas | 20193 | 1975 | 23 |
2119877 | 2119877 | 2022-01-16 | Thomas | Kansas | 20193 | 1975 | 23 |
2115795 | 2115795 | 2022-01-15 | Perry | Arkansas | 5105 | 1975 | 27 |
2116625 | 2116625 | 2022-01-15 | Thomas | Kansas | 20193 | 1975 | 23 |
2113374 | 2113374 | 2022-01-14 | Thomas | Kansas | 20193 | 1975 | 23 |
2108396 | 2108396 | 2022-01-12 | Roberts | South Dakota | 46109 | 1975 | 45 |
2103918 | 2103918 | 2022-01-11 | Luce | Michigan | 26095 | 1975 | 6 |
2099584 | 2099584 | 2022-01-10 | Mariposa | California | 6043 | 1975 | 18 |
2100667 | 2100667 | 2022-01-10 | Luce | Michigan | 26095 | 1975 | 6 |
2089545 | 2089545 | 2022-01-06 | Forest | Wisconsin | 55041 | 1975 | 43 |
2083159 | 2083159 | 2022-01-05 | Lowndes | Alabama | 1085 | 1975 | 68 |
2077255 | 2077255 | 2022-01-03 | Jasper | Illinois | 17079 | 1975 | 25 |
2073661 | 2073661 | 2022-01-02 | Rio Grande | Colorado | 8105 | 1975 | 40 |
2070410 | 2070410 | 2022-01-01 | Rio Grande | Colorado | 8105 | 1975 | 40 |
2067159 | 2067159 | 2021-12-31 | Rio Grande | Colorado | 8105 | 1975 | 40 |
2063627 | 2063627 | 2021-12-30 | Conecuh | Alabama | 1035 | 1975 | 62 |
2062394 | 2062394 | 2021-12-29 | Mercer | North Dakota | 38057 | 1975 | 22 |
2062883 | 2062883 | 2021-12-29 | Todd | South Dakota | 46121 | 1975 | 39 |
2059446 | 2059446 | 2021-12-28 | Aguas Buenas | Puerto Rico | 72007 | 1975 | |
2033684 | 2033684 | 2021-12-20 | Houston | Tennessee | 47083 | 1975 | 48 |
2018321 | 2018321 | 2021-12-16 | Mono | California | 6051 | 1975 | 4 |
2015071 | 2015071 | 2021-12-15 | Mono | California | 6051 | 1975 | 4 |
2008488 | 2008488 | 2021-12-13 | Desha | Arkansas | 5041 | 1975 | 33 |
1968357 | 1968357 | 2021-11-30 | Morrow | Oregon | 41049 | 1975 | 25 |
1941181 | 1941181 | 2021-11-22 | Metcalfe | Kentucky | 21169 | 1975 | 44 |
1942785 | 1942785 | 2021-11-22 | Duval | Texas | 48131 | 1975 | 59 |
1938082 | 1938082 | 2021-11-21 | Nantucket | Massachusetts | 25019 | 1975 | 0 |
1938687 | 1938687 | 2021-11-21 | Socorro | New Mexico | 35053 | 1975 | 64 |
1939535 | 1939535 | 2021-11-21 | Duval | Texas | 48131 | 1975 | 59 |
1934832 | 1934832 | 2021-11-20 | Nantucket | Massachusetts | 25019 | 1975 | 0 |
1935437 | 1935437 | 2021-11-20 | Socorro | New Mexico | 35053 | 1975 | 64 |
1931582 | 1931582 | 2021-11-19 | Nantucket | Massachusetts | 25019 | 1975 | 0 |
1932187 | 1932187 | 2021-11-19 | Socorro | New Mexico | 35053 | 1975 | 64 |
1928331 | 1928331 | 2021-11-18 | Nantucket | Massachusetts | 25019 | 1975 | 0 |
1929576 | 1929576 | 2021-11-18 | Dewey | South Dakota | 46041 | 1975 | 32 |
1925081 | 1925081 | 2021-11-17 | Nantucket | Massachusetts | 25019 | 1975 | 0 |
1921832 | 1921832 | 2021-11-16 | Nantucket | Massachusetts | 25019 | 1975 | 0 |
1918366 | 1918366 | 2021-11-15 | Carroll | Kentucky | 21041 | 1975 | 29 |
1900032 | 1900032 | 2021-11-09 | Johnston | Oklahoma | 40069 | 1975 | 47 |
1896782 | 1896782 | 2021-11-08 | Johnston | Oklahoma | 40069 | 1975 | 47 |
1893532 | 1893532 | 2021-11-07 | Johnston | Oklahoma | 40069 | 1975 | 47 |
1894258 | 1894258 | 2021-11-07 | Caledonia | Vermont | 50005 | 1975 | 20 |
1890282 | 1890282 | 2021-11-06 | Johnston | Oklahoma | 40069 | 1975 | 47 |
1887032 | 1887032 | 2021-11-05 | Johnston | Oklahoma | 40069 | 1975 | 47 |
1883782 | 1883782 | 2021-11-04 | Johnston | Oklahoma | 40069 | 1975 | 47 |
1880533 | 1880533 | 2021-11-03 | Johnston | Oklahoma | 40069 | 1975 | 47 |
1873189 | 1873189 | 2021-11-01 | Chippewa | Minnesota | 27023 | 1975 | 40 |
1853322 | 1853322 | 2021-10-26 | Osage | Kansas | 20139 | 1975 | 35 |
1850073 | 1850073 | 2021-10-25 | Osage | Kansas | 20139 | 1975 | 35 |
1835242 | 1835242 | 2021-10-20 | Morovis | Puerto Rico | 72101 | 1975 | |
1831993 | 1831993 | 2021-10-19 | Morovis | Puerto Rico | 72101 | 1975 | |
1828744 | 1828744 | 2021-10-18 | Morovis | Puerto Rico | 72101 | 1975 | |
1825495 | 1825495 | 2021-10-17 | Morovis | Puerto Rico | 72101 | 1975 | |
1822246 | 1822246 | 2021-10-16 | Morovis | Puerto Rico | 72101 | 1975 | |
1818997 | 1818997 | 2021-10-15 | Morovis | Puerto Rico | 72101 | 1975 | |
1815748 | 1815748 | 2021-10-14 | Morovis | Puerto Rico | 72101 | 1975 | |
1812500 | 1812500 | 2021-10-13 | Morovis | Puerto Rico | 72101 | 1975 | |
1809251 | 1809251 | 2021-10-12 | Morovis | Puerto Rico | 72101 | 1975 | |
1806001 | 1806001 | 2021-10-11 | Morovis | Puerto Rico | 72101 | 1975 | |
1793751 | 1793751 | 2021-10-07 | Monroe | West Virginia | 54063 | 1975 | 25 |
1787054 | 1787054 | 2021-10-05 | Alleghany | Virginia | 51005 | 1975 | 61 |
1787284 | 1787284 | 2021-10-05 | Burnett | Wisconsin | 55013 | 1975 | 29 |
1769011 | 1769011 | 2021-09-30 | Claiborne | Louisiana | 22027 | 1975 | 62 |
1758249 | 1758249 | 2021-09-27 | Chicot | Arkansas | 5017 | 1975 | 44 |
1759706 | 1759706 | 2021-09-27 | Pemiscot | Missouri | 29155 | 1975 | 41 |
1755001 | 1755001 | 2021-09-26 | Chicot | Arkansas | 5017 | 1975 | 44 |
1739299 | 1739299 | 2021-09-21 | Massac | Illinois | 17127 | 1975 | 47 |
1720964 | 1720964 | 2021-09-15 | Grant | New Mexico | 35017 | 1975 | 47 |
1712795 | 1712795 | 2021-09-13 | Lee | Arkansas | 5077 | 1975 | 41 |
1715065 | 1715065 | 2021-09-13 | Bamberg | South Carolina | 45009 | 1975 | 59 |
1715758 | 1715758 | 2021-09-13 | Hardy | West Virginia | 54031 | 1975 | 25 |
1709548 | 1709548 | 2021-09-12 | Lee | Arkansas | 5077 | 1975 | 41 |
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);