ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
614 rows where cases = 551 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 63
- Texas 50
- Kansas 37
- Georgia 36
- Oklahoma 33
- Virginia 30
- Missouri 29
- North Dakota 25
- Iowa 21
- Nebraska 21
- Minnesota 18
- North Carolina 17
- Kentucky 15
- West Virginia 13
- Arkansas 12
- Mississippi 12
- South Dakota 12
- Alabama 11
- Colorado 11
- Idaho 11
- Illinois 11
- Indiana 10
- New York 10
- Louisiana 9
- Montana 9
- New Mexico 8
- Ohio 8
- Florida 7
- Maryland 7
- Tennessee 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381479 | 2381479 | 2022-04-06 | Maricao | Puerto Rico | 72093 | 551 | |
2378224 | 2378224 | 2022-04-05 | Maricao | Puerto Rico | 72093 | 551 | |
2374970 | 2374970 | 2022-04-04 | Maricao | Puerto Rico | 72093 | 551 | |
2371718 | 2371718 | 2022-04-03 | Maricao | Puerto Rico | 72093 | 551 | |
2351159 | 2351159 | 2022-03-28 | Cook | Minnesota | 27031 | 551 | 4 |
2347906 | 2347906 | 2022-03-27 | Cook | Minnesota | 27031 | 551 | 4 |
2344653 | 2344653 | 2022-03-26 | Cook | Minnesota | 27031 | 551 | 4 |
2341400 | 2341400 | 2022-03-25 | Cook | Minnesota | 27031 | 551 | 4 |
2313585 | 2313585 | 2022-03-16 | Oldham | Texas | 48359 | 551 | 6 |
2241963 | 2241963 | 2022-02-22 | Hardeman | Texas | 48197 | 551 | 17 |
2238712 | 2238712 | 2022-02-21 | Hardeman | Texas | 48197 | 551 | 16 |
2235461 | 2235461 | 2022-02-20 | Hardeman | Texas | 48197 | 551 | 16 |
2232210 | 2232210 | 2022-02-19 | Hardeman | Texas | 48197 | 551 | 16 |
2228959 | 2228959 | 2022-02-18 | Hardeman | Texas | 48197 | 551 | 16 |
2225708 | 2225708 | 2022-02-17 | Hardeman | Texas | 48197 | 551 | 16 |
2222457 | 2222457 | 2022-02-16 | Hardeman | Texas | 48197 | 551 | 15 |
2219206 | 2219206 | 2022-02-15 | Hardeman | Texas | 48197 | 551 | 15 |
2171862 | 2171862 | 2022-02-01 | Edwards | Kansas | 20047 | 551 | 13 |
2172968 | 2172968 | 2022-02-01 | Griggs | North Dakota | 38039 | 551 | 2 |
2168609 | 2168609 | 2022-01-31 | Edwards | Kansas | 20047 | 551 | 13 |
2166441 | 2166441 | 2022-01-30 | Adams | North Dakota | 38001 | 551 | 9 |
2131962 | 2131962 | 2022-01-20 | Aleutians East Borough | Alaska | 2013 | 551 | 3 |
2128708 | 2128708 | 2022-01-19 | Aleutians East Borough | Alaska | 2013 | 551 | 3 |
2110045 | 2110045 | 2022-01-13 | Decatur | Kansas | 20039 | 551 | 16 |
2106794 | 2106794 | 2022-01-12 | Decatur | Kansas | 20039 | 551 | 16 |
2098618 | 2098618 | 2022-01-09 | Hanson | South Dakota | 46061 | 551 | 5 |
2095366 | 2095366 | 2022-01-08 | Hanson | South Dakota | 46061 | 551 | 5 |
2091185 | 2091185 | 2022-01-07 | Mercer | Missouri | 29129 | 551 | 11 |
2092114 | 2092114 | 2022-01-07 | Hanson | South Dakota | 46061 | 551 | 5 |
2082047 | 2082047 | 2022-01-04 | Harper | Oklahoma | 40059 | 551 | 10 |
2082332 | 2082332 | 2022-01-04 | Bennett | South Dakota | 46007 | 551 | 9 |
2078795 | 2078795 | 2022-01-03 | Harper | Oklahoma | 40059 | 551 | 10 |
2075544 | 2075544 | 2022-01-02 | Harper | Oklahoma | 40059 | 551 | 10 |
2072293 | 2072293 | 2022-01-01 | Harper | Oklahoma | 40059 | 551 | 10 |
2069042 | 2069042 | 2021-12-31 | Harper | Oklahoma | 40059 | 551 | 10 |
2065791 | 2065791 | 2021-12-30 | Harper | Oklahoma | 40059 | 551 | 10 |
2062541 | 2062541 | 2021-12-29 | Harper | Oklahoma | 40059 | 551 | 10 |
2059284 | 2059284 | 2021-12-28 | Ellis | Oklahoma | 40045 | 551 | 6 |
2056035 | 2056035 | 2021-12-27 | Ellis | Oklahoma | 40045 | 551 | 6 |
2052786 | 2052786 | 2021-12-26 | Ellis | Oklahoma | 40045 | 551 | 6 |
2049536 | 2049536 | 2021-12-25 | Ellis | Oklahoma | 40045 | 551 | 6 |
2046286 | 2046286 | 2021-12-24 | Ellis | Oklahoma | 40045 | 551 | 6 |
2043036 | 2043036 | 2021-12-23 | Ellis | Oklahoma | 40045 | 551 | 6 |
2043799 | 2043799 | 2021-12-23 | Bath | Virginia | 51017 | 551 | 15 |
2039787 | 2039787 | 2021-12-22 | Ellis | Oklahoma | 40045 | 551 | 6 |
2040550 | 2040550 | 2021-12-22 | Bath | Virginia | 51017 | 551 | 15 |
2013362 | 2013362 | 2021-12-14 | Stanton | Nebraska | 31167 | 551 | 11 |
2009984 | 2009984 | 2021-12-13 | Fallon | Montana | 30025 | 551 | 8 |
2010111 | 2010111 | 2021-12-13 | Stanton | Nebraska | 31167 | 551 | 11 |
2010384 | 2010384 | 2021-12-13 | Hettinger | North Dakota | 38041 | 551 | 7 |
2011192 | 2011192 | 2021-12-13 | Shackelford | Texas | 48417 | 551 | 7 |
2006860 | 2006860 | 2021-12-12 | Stanton | Nebraska | 31167 | 551 | 11 |
2007133 | 2007133 | 2021-12-12 | Hettinger | North Dakota | 38041 | 551 | 7 |
2007941 | 2007941 | 2021-12-12 | Shackelford | Texas | 48417 | 551 | 7 |
2003609 | 2003609 | 2021-12-11 | Stanton | Nebraska | 31167 | 551 | 11 |
2003723 | 2003723 | 2021-12-11 | Hamilton | New York | 36041 | 551 | 3 |
2003882 | 2003882 | 2021-12-11 | Hettinger | North Dakota | 38041 | 551 | 7 |
2000359 | 2000359 | 2021-12-10 | Stanton | Nebraska | 31167 | 551 | 11 |
1995425 | 1995425 | 2021-12-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 551 | 1 |
1992174 | 1992174 | 2021-12-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 551 | 1 |
1982911 | 1982911 | 2021-12-05 | Adams | Idaho | 16003 | 551 | 14 |
1979661 | 1979661 | 2021-12-04 | Adams | Idaho | 16003 | 551 | 14 |
1974415 | 1974415 | 2021-12-02 | Unknown | New Jersey | 551 | 0 | |
1942113 | 1942113 | 2021-11-22 | Eddy | North Dakota | 38027 | 551 | 6 |
1938863 | 1938863 | 2021-11-21 | Eddy | North Dakota | 38027 | 551 | 6 |
1935613 | 1935613 | 2021-11-20 | Eddy | North Dakota | 38027 | 551 | 6 |
1932363 | 1932363 | 2021-11-19 | Eddy | North Dakota | 38027 | 551 | 6 |
1928644 | 1928644 | 2021-11-18 | Knox | Missouri | 29103 | 551 | 8 |
1896633 | 1896633 | 2021-11-08 | Nelson | North Dakota | 38063 | 551 | 16 |
1893383 | 1893383 | 2021-11-07 | Nelson | North Dakota | 38063 | 551 | 16 |
1890133 | 1890133 | 2021-11-06 | Nelson | North Dakota | 38063 | 551 | 16 |
1886883 | 1886883 | 2021-11-05 | Nelson | North Dakota | 38063 | 551 | 16 |
1883634 | 1883634 | 2021-11-04 | Nelson | North Dakota | 38063 | 551 | 16 |
1875692 | 1875692 | 2021-11-02 | Oneida | Idaho | 16071 | 551 | 9 |
1876504 | 1876504 | 2021-11-02 | Traverse | Minnesota | 27155 | 551 | 5 |
1878055 | 1878055 | 2021-11-02 | Craig | Virginia | 51045 | 551 | 8 |
1874806 | 1874806 | 2021-11-01 | Craig | Virginia | 51045 | 551 | 8 |
1864442 | 1864442 | 2021-10-29 | Arroyo | Puerto Rico | 72015 | 551 | |
1860848 | 1860848 | 2021-10-28 | Tyrrell | North Carolina | 37177 | 551 | 7 |
1861193 | 1861193 | 2021-10-28 | Arroyo | Puerto Rico | 72015 | 551 | |
1857268 | 1857268 | 2021-10-27 | Sweet Grass | Montana | 30097 | 551 | 8 |
1857944 | 1857944 | 2021-10-27 | Arroyo | Puerto Rico | 72015 | 551 | |
1851743 | 1851743 | 2021-10-25 | Baylor | Texas | 48023 | 551 | 21 |
1848493 | 1848493 | 2021-10-24 | Baylor | Texas | 48023 | 551 | 21 |
1845243 | 1845243 | 2021-10-23 | Baylor | Texas | 48023 | 551 | 21 |
1841993 | 1841993 | 2021-10-22 | Baylor | Texas | 48023 | 551 | 21 |
1837162 | 1837162 | 2021-10-21 | Hickman | Kentucky | 21105 | 551 | 19 |
1838744 | 1838744 | 2021-10-21 | Baylor | Texas | 48023 | 551 | 20 |
1825123 | 1825123 | 2021-10-17 | Bowman | North Dakota | 38011 | 551 | 7 |
1811944 | 1811944 | 2021-10-13 | Hidalgo | New Mexico | 35023 | 551 | 11 |
1813147 | 1813147 | 2021-10-13 | Rappahannock | Virginia | 51157 | 551 | 4 |
1808695 | 1808695 | 2021-10-12 | Hidalgo | New Mexico | 35023 | 551 | 11 |
1808926 | 1808926 | 2021-10-12 | Wells | North Dakota | 38103 | 551 | 9 |
1809649 | 1809649 | 2021-10-12 | Mason | Texas | 48319 | 551 | 7 |
1789693 | 1789693 | 2021-10-06 | Sullivan | Pennsylvania | 42113 | 551 | 24 |
1781181 | 1781181 | 2021-10-04 | Washington | Colorado | 8121 | 551 | 14 |
1778304 | 1778304 | 2021-10-03 | Putnam | Illinois | 17155 | 551 | 5 |
1775054 | 1775054 | 2021-10-02 | Putnam | Illinois | 17155 | 551 | 5 |
1771804 | 1771804 | 2021-10-01 | Putnam | Illinois | 17155 | 551 | 5 |
1754013 | 1754013 | 2021-09-25 | Maunabo | Puerto Rico | 72095 | 551 |
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);