ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where cases = 1987 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- Virginia 16
- Arkansas 15
- Puerto Rico 14
- Georgia 12
- Missouri 12
- Tennessee 12
- Iowa 9
- Montana 9
- North Dakota 9
- Illinois 8
- Mississippi 8
- North Carolina 8
- Wisconsin 8
- Kansas 6
- Louisiana 6
- Minnesota 6
- New Mexico 6
- West Virginia 6
- Colorado 5
- Indiana 5
- Kentucky 5
- Ohio 5
- Oklahoma 5
- California 4
- Idaho 4
- South Carolina 4
- Alabama 3
- Pennsylvania 3
- Alaska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502777 | 2502777 | 2022-05-13 | Menominee | Wisconsin | 55078 | 1987 | 14 |
2498361 | 2498361 | 2022-05-12 | Pembina | North Dakota | 38067 | 1987 | 16 |
2495103 | 2495103 | 2022-05-11 | Pembina | North Dakota | 38067 | 1987 | 16 |
2491845 | 2491845 | 2022-05-10 | Pembina | North Dakota | 38067 | 1987 | 16 |
2492944 | 2492944 | 2022-05-10 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2488587 | 2488587 | 2022-05-09 | Pembina | North Dakota | 38067 | 1987 | 16 |
2489686 | 2489686 | 2022-05-09 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2485330 | 2485330 | 2022-05-08 | Pembina | North Dakota | 38067 | 1987 | 16 |
2486495 | 2486495 | 2022-05-08 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2482072 | 2482072 | 2022-05-07 | Pembina | North Dakota | 38067 | 1987 | 16 |
2483237 | 2483237 | 2022-05-07 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2478814 | 2478814 | 2022-05-06 | Pembina | North Dakota | 38067 | 1987 | 16 |
2479979 | 2479979 | 2022-05-06 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2476721 | 2476721 | 2022-05-05 | Pepin | Wisconsin | 55091 | 1987 | 18 |
2430900 | 2430900 | 2022-04-21 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2427644 | 2427644 | 2022-04-20 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2424388 | 2424388 | 2022-04-19 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2421132 | 2421132 | 2022-04-18 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2325628 | 2325628 | 2022-03-20 | Quay | New Mexico | 35037 | 1987 | 49 |
2322374 | 2322374 | 2022-03-19 | Quay | New Mexico | 35037 | 1987 | 49 |
2319120 | 2319120 | 2022-03-18 | Quay | New Mexico | 35037 | 1987 | 49 |
2315867 | 2315867 | 2022-03-17 | Quay | New Mexico | 35037 | 1987 | 49 |
2278819 | 2278819 | 2022-03-06 | Benewah | Idaho | 16009 | 1987 | 40 |
2275566 | 2275566 | 2022-03-05 | Benewah | Idaho | 16009 | 1987 | 40 |
2272313 | 2272313 | 2022-03-04 | Benewah | Idaho | 16009 | 1987 | 40 |
2268587 | 2268587 | 2022-03-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 1987 | 17 |
2265334 | 2265334 | 2022-03-02 | Southeast Fairbanks Census Area | Alaska | 2240 | 1987 | 17 |
2267611 | 2267611 | 2022-03-02 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2264358 | 2264358 | 2022-03-01 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2261108 | 2261108 | 2022-02-28 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2257110 | 2257110 | 2022-02-27 | Blaine | Montana | 30005 | 1987 | 31 |
2257857 | 2257857 | 2022-02-27 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2253859 | 2253859 | 2022-02-26 | Blaine | Montana | 30005 | 1987 | 31 |
2250608 | 2250608 | 2022-02-25 | Blaine | Montana | 30005 | 1987 | 31 |
2236534 | 2236534 | 2022-02-21 | Wilcox | Georgia | 13315 | 1987 | 66 |
2220225 | 2220225 | 2022-02-16 | Montgomery | Georgia | 13209 | 1987 | 49 |
2218055 | 2218055 | 2022-02-15 | Oregon | Missouri | 29149 | 1987 | 31 |
2195426 | 2195426 | 2022-02-08 | Holt | Nebraska | 31089 | 1987 | 18 |
2193567 | 2193567 | 2022-02-07 | Doddridge | West Virginia | 54017 | 1987 | 16 |
2124429 | 2124429 | 2022-01-17 | Forest | Pennsylvania | 42053 | 1987 | 33 |
2118443 | 2118443 | 2022-01-15 | Parmer | Texas | 48369 | 1987 | 45 |
2080816 | 2080816 | 2022-01-04 | Linn | Kansas | 20107 | 1987 | 23 |
2077564 | 2077564 | 2022-01-03 | Linn | Kansas | 20107 | 1987 | 23 |
2061723 | 2061723 | 2021-12-29 | Koochiching | Minnesota | 27071 | 1987 | 29 |
2037744 | 2037744 | 2021-12-22 | Desha | Arkansas | 5041 | 1987 | 35 |
2039028 | 2039028 | 2021-12-22 | Yellow Medicine | Minnesota | 27173 | 1987 | 25 |
2016515 | 2016515 | 2021-12-15 | Richland | Montana | 30083 | 1987 | 27 |
2002034 | 2002034 | 2021-12-11 | Stone | Arkansas | 5137 | 1987 | 46 |
1985043 | 1985043 | 2021-12-05 | Duval | Texas | 48131 | 1987 | 60 |
1981793 | 1981793 | 2021-12-04 | Duval | Texas | 48131 | 1987 | 60 |
1935690 | 1935690 | 2021-11-20 | Harrison | Ohio | 39067 | 1987 | 50 |
1929956 | 1929956 | 2021-11-18 | Ward | Texas | 48475 | 1987 | 34 |
1921667 | 1921667 | 2021-11-16 | Lyon | Kentucky | 21143 | 1987 | 26 |
1918934 | 1918934 | 2021-11-15 | Ripley | Missouri | 29181 | 1987 | 25 |
1915684 | 1915684 | 2021-11-14 | Ripley | Missouri | 29181 | 1987 | 25 |
1912434 | 1912434 | 2021-11-13 | Ripley | Missouri | 29181 | 1987 | 24 |
1909124 | 1909124 | 2021-11-12 | Dent | Missouri | 29065 | 1987 | 42 |
1898808 | 1898808 | 2021-11-09 | Nemaha | Kansas | 20131 | 1987 | 56 |
1895558 | 1895558 | 2021-11-08 | Nemaha | Kansas | 20131 | 1987 | 56 |
1890480 | 1890480 | 2021-11-06 | Morovis | Puerto Rico | 72101 | 1987 | |
1887230 | 1887230 | 2021-11-05 | Morovis | Puerto Rico | 72101 | 1987 | |
1883980 | 1883980 | 2021-11-04 | Morovis | Puerto Rico | 72101 | 1987 | |
1880731 | 1880731 | 2021-11-03 | Morovis | Puerto Rico | 72101 | 1987 | |
1877482 | 1877482 | 2021-11-02 | Morovis | Puerto Rico | 72101 | 1987 | |
1874233 | 1874233 | 2021-11-01 | Morovis | Puerto Rico | 72101 | 1987 | |
1869785 | 1869785 | 2021-10-31 | West Carroll | Louisiana | 22123 | 1987 | 48 |
1870984 | 1870984 | 2021-10-31 | Morovis | Puerto Rico | 72101 | 1987 | |
1866536 | 1866536 | 2021-10-30 | West Carroll | Louisiana | 22123 | 1987 | 48 |
1863287 | 1863287 | 2021-10-29 | West Carroll | Louisiana | 22123 | 1987 | 48 |
1853295 | 1853295 | 2021-10-26 | Jackson | Kansas | 20085 | 1987 | 19 |
1855435 | 1855435 | 2021-10-26 | Klickitat | Washington | 53039 | 1987 | 18 |
1850046 | 1850046 | 2021-10-25 | Jackson | Kansas | 20085 | 1987 | 19 |
1839335 | 1839335 | 2021-10-21 | Big Horn | Wyoming | 56003 | 1987 | 50 |
1811749 | 1811749 | 2021-10-13 | Glacier | Montana | 30035 | 1987 | 49 |
1787234 | 1787234 | 2021-10-05 | Grant | West Virginia | 54023 | 1987 | 31 |
1779118 | 1779118 | 2021-10-03 | Webster | Mississippi | 28155 | 1987 | 43 |
1775868 | 1775868 | 2021-10-02 | Webster | Mississippi | 28155 | 1987 | 43 |
1772618 | 1772618 | 2021-10-01 | Webster | Mississippi | 28155 | 1987 | 43 |
1766668 | 1766668 | 2021-09-29 | Ramsey | North Dakota | 38071 | 1987 | 33 |
1767606 | 1767606 | 2021-09-29 | Greene | Virginia | 51079 | 1987 | 27 |
1761348 | 1761348 | 2021-09-27 | Washburn | Wisconsin | 55129 | 1987 | 25 |
1723781 | 1723781 | 2021-09-16 | Renville | Minnesota | 27129 | 1987 | 47 |
1718313 | 1718313 | 2021-09-14 | Bamberg | South Carolina | 45009 | 1987 | 59 |
1719006 | 1719006 | 2021-09-14 | Hardy | West Virginia | 54031 | 1987 | 25 |
1713115 | 1713115 | 2021-09-13 | Jasper | Georgia | 13159 | 1987 | 47 |
1694716 | 1694716 | 2021-09-07 | Macon | Missouri | 29121 | 1987 | 19 |
1675659 | 1675659 | 2021-09-01 | Warren | North Carolina | 37185 | 1987 | 20 |
1672963 | 1672963 | 2021-08-31 | Decatur | Tennessee | 47039 | 1987 | 39 |
1664615 | 1664615 | 2021-08-29 | Warren | Illinois | 17187 | 1987 | 54 |
1666688 | 1666688 | 2021-08-29 | Leon | Texas | 48289 | 1987 | 48 |
1661367 | 1661367 | 2021-08-28 | Warren | Illinois | 17187 | 1987 | 54 |
1663440 | 1663440 | 2021-08-28 | Leon | Texas | 48289 | 1987 | 48 |
1658119 | 1658119 | 2021-08-27 | Warren | Illinois | 17187 | 1987 | 54 |
1653795 | 1653795 | 2021-08-25 | Wilbarger | Texas | 48487 | 1987 | 56 |
1650562 | 1650562 | 2021-08-24 | Carbon | Utah | 49007 | 1987 | 20 |
1632690 | 1632690 | 2021-08-19 | Cheboygan | Michigan | 26031 | 1987 | 50 |
1629443 | 1629443 | 2021-08-18 | Cheboygan | Michigan | 26031 | 1987 | 50 |
1608966 | 1608966 | 2021-08-12 | Elbert | Colorado | 8039 | 1987 | 15 |
1596332 | 1596332 | 2021-08-08 | Ford | Illinois | 17053 | 1987 | 58 |
1593083 | 1593083 | 2021-08-07 | Ford | Illinois | 17053 | 1987 | 58 |
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);