ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
285 rows where cases = 1655 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 30
- Arkansas 27
- Iowa 23
- Georgia 15
- Puerto Rico 14
- Illinois 13
- Virginia 13
- Missouri 10
- Kentucky 9
- Louisiana 9
- Ohio 9
- Alabama 8
- Indiana 8
- Minnesota 8
- New York 8
- North Carolina 8
- Texas 8
- Mississippi 7
- North Dakota 7
- Idaho 5
- Tennessee 5
- Wisconsin 5
- Florida 3
- Michigan 3
- Montana 3
- Nebraska 3
- New Hampshire 3
- Pennsylvania 3
- Wyoming 3
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475879 | 2475879 | 2022-05-05 | Guanica | Puerto Rico | 72055 | 1655 | |
2358491 | 2358491 | 2022-03-30 | Coal | Oklahoma | 40029 | 1655 | 23 |
2355237 | 2355237 | 2022-03-29 | Coal | Oklahoma | 40029 | 1655 | 23 |
2351984 | 2351984 | 2022-03-28 | Coal | Oklahoma | 40029 | 1655 | 23 |
2348732 | 2348732 | 2022-03-27 | Coal | Oklahoma | 40029 | 1655 | 23 |
2345479 | 2345479 | 2022-03-26 | Coal | Oklahoma | 40029 | 1655 | 23 |
2342226 | 2342226 | 2022-03-25 | Coal | Oklahoma | 40029 | 1655 | 23 |
2338973 | 2338973 | 2022-03-24 | Coal | Oklahoma | 40029 | 1655 | 23 |
2335719 | 2335719 | 2022-03-23 | Coal | Oklahoma | 40029 | 1655 | 23 |
2335794 | 2335794 | 2022-03-23 | Grant | Oregon | 41023 | 1655 | 20 |
2332465 | 2332465 | 2022-03-22 | Coal | Oklahoma | 40029 | 1655 | 23 |
2329212 | 2329212 | 2022-03-21 | Coal | Oklahoma | 40029 | 1655 | 23 |
2325960 | 2325960 | 2022-03-20 | Coal | Oklahoma | 40029 | 1655 | 23 |
2322707 | 2322707 | 2022-03-19 | Coal | Oklahoma | 40029 | 1655 | 23 |
2319453 | 2319453 | 2022-03-18 | Coal | Oklahoma | 40029 | 1655 | 23 |
2316199 | 2316199 | 2022-03-17 | Coal | Oklahoma | 40029 | 1655 | 23 |
2307821 | 2307821 | 2022-03-15 | Rio Blanco | Colorado | 8103 | 1655 | 13 |
2173132 | 2173132 | 2022-02-01 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2169880 | 2169880 | 2022-01-31 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2166625 | 2166625 | 2022-01-30 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2163370 | 2163370 | 2022-01-29 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2160115 | 2160115 | 2022-01-28 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2156860 | 2156860 | 2022-01-27 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2152450 | 2152450 | 2022-01-26 | Elliott | Kentucky | 21063 | 1655 | 14 |
2153607 | 2153607 | 2022-01-26 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2131889 | 2131889 | 2022-01-19 | Sublette | Wyoming | 56035 | 1655 | 24 |
2074734 | 2074734 | 2022-01-02 | Marshall | Minnesota | 27089 | 1655 | 23 |
2071483 | 2071483 | 2022-01-01 | Marshall | Minnesota | 27089 | 1655 | 23 |
2068232 | 2068232 | 2021-12-31 | Marshall | Minnesota | 27089 | 1655 | 23 |
2064981 | 2064981 | 2021-12-30 | Marshall | Minnesota | 27089 | 1655 | 23 |
2059165 | 2059165 | 2021-12-28 | Traill | North Dakota | 38097 | 1655 | 21 |
2054025 | 2054025 | 2021-12-27 | Perry | Arkansas | 5105 | 1655 | 24 |
2055916 | 2055916 | 2021-12-27 | Traill | North Dakota | 38097 | 1655 | 21 |
2056246 | 2056246 | 2021-12-27 | Naguabo | Puerto Rico | 72103 | 1655 | |
2030817 | 2030817 | 2021-12-19 | Clarke | Virginia | 51043 | 1655 | 33 |
2027566 | 2027566 | 2021-12-18 | Clarke | Virginia | 51043 | 1655 | 33 |
2021922 | 2021922 | 2021-12-17 | Benewah | Idaho | 16009 | 1655 | 29 |
2024315 | 2024315 | 2021-12-17 | Clarke | Virginia | 51043 | 1655 | 33 |
2012473 | 2012473 | 2021-12-14 | Montgomery | Iowa | 19137 | 1655 | 47 |
2013137 | 2013137 | 2021-12-14 | DeKalb | Missouri | 29063 | 1655 | 37 |
2009222 | 2009222 | 2021-12-13 | Montgomery | Iowa | 19137 | 1655 | 47 |
2005971 | 2005971 | 2021-12-12 | Montgomery | Iowa | 19137 | 1655 | 47 |
2002720 | 2002720 | 2021-12-11 | Montgomery | Iowa | 19137 | 1655 | 47 |
2004266 | 2004266 | 2021-12-11 | Yabucoa | Puerto Rico | 72151 | 1655 | |
1999470 | 1999470 | 2021-12-10 | Montgomery | Iowa | 19137 | 1655 | 47 |
2001015 | 2001015 | 2021-12-10 | Yabucoa | Puerto Rico | 72151 | 1655 | |
1995798 | 1995798 | 2021-12-09 | Evans | Georgia | 13109 | 1655 | 54 |
1996219 | 1996219 | 2021-12-09 | Montgomery | Iowa | 19137 | 1655 | 47 |
1997691 | 1997691 | 2021-12-09 | Aguas Buenas | Puerto Rico | 72007 | 1655 | |
1997765 | 1997765 | 2021-12-09 | Yabucoa | Puerto Rico | 72151 | 1655 | |
1997952 | 1997952 | 2021-12-09 | Perry | Tennessee | 47135 | 1655 | 35 |
1992968 | 1992968 | 2021-12-08 | Montgomery | Iowa | 19137 | 1655 | 47 |
1994440 | 1994440 | 2021-12-08 | Aguas Buenas | Puerto Rico | 72007 | 1655 | |
1994701 | 1994701 | 2021-12-08 | Perry | Tennessee | 47135 | 1655 | 35 |
1970061 | 1970061 | 2021-12-01 | Benton | Indiana | 18007 | 1655 | 17 |
1967242 | 1967242 | 2021-11-30 | East Carroll | Louisiana | 22035 | 1655 | 31 |
1963990 | 1963990 | 2021-11-29 | East Carroll | Louisiana | 22035 | 1655 | 31 |
1941497 | 1941497 | 2021-11-22 | Swift | Minnesota | 27151 | 1655 | 22 |
1924418 | 1924418 | 2021-11-17 | Clearwater | Idaho | 16035 | 1655 | 26 |
1924554 | 1924554 | 2021-11-17 | Brown | Indiana | 18013 | 1655 | 50 |
1921169 | 1921169 | 2021-11-16 | Clearwater | Idaho | 16035 | 1655 | 26 |
1900074 | 1900074 | 2021-11-09 | Woods | Oklahoma | 40151 | 1655 | 26 |
1896824 | 1896824 | 2021-11-08 | Woods | Oklahoma | 40151 | 1655 | 26 |
1893574 | 1893574 | 2021-11-07 | Woods | Oklahoma | 40151 | 1655 | 26 |
1890324 | 1890324 | 2021-11-06 | Woods | Oklahoma | 40151 | 1655 | 26 |
1887074 | 1887074 | 2021-11-05 | Woods | Oklahoma | 40151 | 1655 | 26 |
1882357 | 1882357 | 2021-11-04 | Newton | Indiana | 18111 | 1655 | 53 |
1883824 | 1883824 | 2021-11-04 | Woods | Oklahoma | 40151 | 1655 | 26 |
1878784 | 1878784 | 2021-11-03 | Dooly | Georgia | 13093 | 1655 | 59 |
1879973 | 1879973 | 2021-11-03 | Dawson | Montana | 30021 | 1655 | 47 |
1880575 | 1880575 | 2021-11-03 | Woods | Oklahoma | 40151 | 1655 | 26 |
1875983 | 1875983 | 2021-11-02 | Union | Iowa | 19175 | 1655 | 38 |
1872734 | 1872734 | 2021-11-01 | Union | Iowa | 19175 | 1655 | 38 |
1869485 | 1869485 | 2021-10-31 | Union | Iowa | 19175 | 1655 | 38 |
1866236 | 1866236 | 2021-10-30 | Union | Iowa | 19175 | 1655 | 38 |
1862987 | 1862987 | 2021-10-29 | Union | Iowa | 19175 | 1655 | 38 |
1859738 | 1859738 | 2021-10-28 | Union | Iowa | 19175 | 1655 | 38 |
1856489 | 1856489 | 2021-10-27 | Union | Iowa | 19175 | 1655 | 38 |
1857263 | 1857263 | 2021-10-27 | Rosebud | Montana | 30087 | 1655 | 56 |
1841501 | 1841501 | 2021-10-22 | Vinton | Ohio | 39163 | 1655 | 25 |
1817832 | 1817832 | 2021-10-15 | Kent | Maryland | 24029 | 1655 | 55 |
1815399 | 1815399 | 2021-10-14 | Mercer | North Dakota | 38057 | 1655 | 12 |
1785630 | 1785630 | 2021-10-05 | Bollinger | Missouri | 29017 | 1655 | 19 |
1778106 | 1778106 | 2021-10-03 | Long | Georgia | 13183 | 1655 | 20 |
1779633 | 1779633 | 2021-10-03 | Barnes | North Dakota | 38003 | 1655 | 32 |
1774856 | 1774856 | 2021-10-02 | Long | Georgia | 13183 | 1655 | 20 |
1771606 | 1771606 | 2021-10-01 | Long | Georgia | 13183 | 1655 | 20 |
1772318 | 1772318 | 2021-10-01 | Knox | Maine | 23013 | 1655 | 10 |
1768049 | 1768049 | 2021-09-30 | Scott | Arkansas | 5127 | 1655 | 25 |
1764800 | 1764800 | 2021-09-29 | Scott | Arkansas | 5127 | 1655 | 25 |
1767530 | 1767530 | 2021-09-29 | Unknown | Utah | 1655 | 35 | |
1761979 | 1761979 | 2021-09-28 | Washington | Idaho | 16087 | 1655 | 34 |
1733586 | 1733586 | 2021-09-19 | Jefferson Davis | Mississippi | 28065 | 1655 | 41 |
1730336 | 1730336 | 2021-09-18 | Jefferson Davis | Mississippi | 28065 | 1655 | 41 |
1727086 | 1727086 | 2021-09-17 | Jefferson Davis | Mississippi | 28065 | 1655 | 41 |
1667318 | 1667318 | 2021-08-30 | Little River | Arkansas | 5081 | 1655 | 44 |
1648346 | 1648346 | 2021-08-24 | Mercer | Illinois | 17131 | 1655 | 34 |
1650045 | 1650045 | 2021-08-24 | Hatillo | Puerto Rico | 72065 | 1655 | |
1647467 | 1647467 | 2021-08-23 | Rockbridge | Virginia | 51163 | 1655 | 48 |
1620796 | 1620796 | 2021-08-15 | Cidra | Puerto Rico | 72041 | 1655 |
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);