ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
537 rows where cases = 576 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 60
- Virginia 42
- Nebraska 30
- Minnesota 26
- Illinois 19
- Kansas 19
- Puerto Rico 19
- Arizona 18
- Mississippi 18
- South Dakota 18
- Georgia 17
- Alabama 14
- Kentucky 14
- Missouri 14
- Oklahoma 14
- California 12
- Indiana 12
- Louisiana 12
- North Dakota 12
- Washington 12
- Iowa 11
- Michigan 11
- Idaho 10
- Tennessee 10
- Arkansas 9
- Colorado 9
- West Virginia 9
- New York 8
- North Carolina 8
- Ohio 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430314 | 2430314 | 2022-04-21 | Maricao | Puerto Rico | 72093 | 576 | |
2203289 | 2203289 | 2022-02-10 | Columbia | Washington | 53013 | 576 | 13 |
2200035 | 2200035 | 2022-02-09 | Columbia | Washington | 53013 | 576 | 13 |
2176898 | 2176898 | 2022-02-02 | Fisher | Texas | 48151 | 576 | 20 |
2141725 | 2141725 | 2022-01-23 | Aleutians East Borough | Alaska | 2013 | 576 | 3 |
2138469 | 2138469 | 2022-01-22 | Aleutians East Borough | Alaska | 2013 | 576 | 3 |
2135214 | 2135214 | 2022-01-21 | Aleutians East Borough | Alaska | 2013 | 576 | 3 |
2134366 | 2134366 | 2022-01-20 | Buffalo | South Dakota | 46017 | 576 | 17 |
2130302 | 2130302 | 2022-01-19 | Sheridan | Montana | 30091 | 576 | 10 |
2126952 | 2126952 | 2022-01-18 | Mercer | Missouri | 29129 | 576 | 11 |
2127048 | 2127048 | 2022-01-18 | Sheridan | Montana | 30091 | 576 | 10 |
2124654 | 2124654 | 2022-01-17 | Potter | South Dakota | 46107 | 576 | 5 |
2121402 | 2121402 | 2022-01-16 | Potter | South Dakota | 46107 | 576 | 5 |
2118150 | 2118150 | 2022-01-15 | Potter | South Dakota | 46107 | 576 | 5 |
2114899 | 2114899 | 2022-01-14 | Potter | South Dakota | 46107 | 576 | 5 |
2099213 | 2099213 | 2022-01-09 | San Juan | Washington | 53055 | 576 | 0 |
2094465 | 2094465 | 2022-01-08 | Schuyler | Missouri | 29197 | 576 | 22 |
2095962 | 2095962 | 2022-01-08 | San Juan | Washington | 53055 | 576 | 0 |
2092710 | 2092710 | 2022-01-07 | San Juan | Washington | 53055 | 576 | 0 |
2087736 | 2087736 | 2022-01-06 | Lake of the Woods | Minnesota | 27077 | 576 | 5 |
2032980 | 2032980 | 2021-12-20 | Hamilton | New York | 36041 | 576 | 4 |
2033132 | 2033132 | 2021-12-20 | Eddy | North Dakota | 38027 | 576 | 6 |
2029882 | 2029882 | 2021-12-19 | Eddy | North Dakota | 38027 | 576 | 6 |
2024932 | 2024932 | 2021-12-18 | Unknown | Delaware | 576 | 0 | |
2026631 | 2026631 | 2021-12-18 | Eddy | North Dakota | 38027 | 576 | 6 |
2013990 | 2013990 | 2021-12-14 | Maunabo | Puerto Rico | 72095 | 576 | |
2010739 | 2010739 | 2021-12-13 | Maunabo | Puerto Rico | 72095 | 576 | |
2005355 | 2005355 | 2021-12-12 | Baca | Colorado | 8009 | 576 | 6 |
2007488 | 2007488 | 2021-12-12 | Maunabo | Puerto Rico | 72095 | 576 | |
2002104 | 2002104 | 2021-12-11 | Baca | Colorado | 8009 | 576 | 6 |
1998854 | 1998854 | 2021-12-10 | Baca | Colorado | 8009 | 576 | 6 |
1995603 | 1995603 | 2021-12-09 | Baca | Colorado | 8009 | 576 | 6 |
1985170 | 1985170 | 2021-12-05 | Real | Texas | 48385 | 576 | 20 |
1981920 | 1981920 | 2021-12-04 | Real | Texas | 48385 | 576 | 20 |
1978670 | 1978670 | 2021-12-03 | Real | Texas | 48385 | 576 | 20 |
1975420 | 1975420 | 2021-12-02 | Real | Texas | 48385 | 576 | 20 |
1968567 | 1968567 | 2021-11-30 | Aurora | South Dakota | 46003 | 576 | 17 |
1968824 | 1968824 | 2021-11-30 | Hall | Texas | 48191 | 576 | 15 |
1965573 | 1965573 | 2021-11-29 | Hall | Texas | 48191 | 576 | 15 |
1951884 | 1951884 | 2021-11-25 | Nelson | North Dakota | 38063 | 576 | 16 |
1945622 | 1945622 | 2021-11-23 | Cameron | Pennsylvania | 42023 | 576 | 13 |
1927686 | 1927686 | 2021-11-18 | Oneida | Idaho | 16071 | 576 | 10 |
1922748 | 1922748 | 2021-11-16 | Beaver | Oklahoma | 40007 | 576 | 9 |
1919499 | 1919499 | 2021-11-15 | Beaver | Oklahoma | 40007 | 576 | 9 |
1919981 | 1919981 | 2021-11-15 | Baylor | Texas | 48023 | 576 | 24 |
1916249 | 1916249 | 2021-11-14 | Beaver | Oklahoma | 40007 | 576 | 9 |
1916731 | 1916731 | 2021-11-14 | Baylor | Texas | 48023 | 576 | 24 |
1912999 | 1912999 | 2021-11-13 | Beaver | Oklahoma | 40007 | 576 | 9 |
1913481 | 1913481 | 2021-11-13 | Baylor | Texas | 48023 | 576 | 24 |
1909749 | 1909749 | 2021-11-12 | Beaver | Oklahoma | 40007 | 576 | 9 |
1906008 | 1906008 | 2021-11-11 | Sweet Grass | Montana | 30097 | 576 | 8 |
1906500 | 1906500 | 2021-11-11 | Beaver | Oklahoma | 40007 | 576 | 9 |
1902759 | 1902759 | 2021-11-10 | Sweet Grass | Montana | 30097 | 576 | 8 |
1903251 | 1903251 | 2021-11-10 | Beaver | Oklahoma | 40007 | 576 | 9 |
1903878 | 1903878 | 2021-11-10 | Mason | Texas | 48319 | 576 | 8 |
1900628 | 1900628 | 2021-11-09 | Mason | Texas | 48319 | 576 | 8 |
1892025 | 1892025 | 2021-11-07 | Putnam | Illinois | 17155 | 576 | 5 |
1888775 | 1888775 | 2021-11-06 | Putnam | Illinois | 17155 | 576 | 5 |
1885525 | 1885525 | 2021-11-05 | Putnam | Illinois | 17155 | 576 | 5 |
1857432 | 1857432 | 2021-10-27 | Hidalgo | New Mexico | 35023 | 576 | 11 |
1858635 | 1858635 | 2021-10-27 | Rappahannock | Virginia | 51157 | 576 | 4 |
1847035 | 1847035 | 2021-10-24 | Unknown | Louisiana | 576 | 0 | |
1843785 | 1843785 | 2021-10-23 | Unknown | Louisiana | 576 | 0 | |
1840535 | 1840535 | 2021-10-22 | Unknown | Louisiana | 576 | 0 | |
1841415 | 1841415 | 2021-10-22 | Wells | North Dakota | 38103 | 576 | 9 |
1837286 | 1837286 | 2021-10-21 | Unknown | Louisiana | 576 | 0 | |
1834037 | 1834037 | 2021-10-20 | Unknown | Louisiana | 576 | 0 | |
1824502 | 1824502 | 2021-10-17 | Red Lake | Minnesota | 27125 | 576 | 9 |
1821253 | 1821253 | 2021-10-16 | Red Lake | Minnesota | 27125 | 576 | 9 |
1818004 | 1818004 | 2021-10-15 | Red Lake | Minnesota | 27125 | 576 | 9 |
1764265 | 1764265 | 2021-09-28 | Garfield | Utah | 49017 | 576 | 11 |
1764371 | 1764371 | 2021-09-28 | King and Queen | Virginia | 51097 | 576 | 7 |
1747875 | 1747875 | 2021-09-23 | Hudspeth | Texas | 48229 | 576 | 13 |
1744625 | 1744625 | 2021-09-22 | Hudspeth | Texas | 48229 | 576 | 13 |
1735901 | 1735901 | 2021-09-20 | Schley | Georgia | 13249 | 576 | 6 |
1732651 | 1732651 | 2021-09-19 | Schley | Georgia | 13249 | 576 | 6 |
1729401 | 1729401 | 2021-09-18 | Schley | Georgia | 13249 | 576 | 6 |
1726151 | 1726151 | 2021-09-17 | Schley | Georgia | 13249 | 576 | 6 |
1722229 | 1722229 | 2021-09-15 | Skamania | Washington | 53059 | 576 | 3 |
1681698 | 1681698 | 2021-09-03 | Holt | Missouri | 29087 | 576 | 16 |
1678409 | 1678409 | 2021-09-02 | Atchison | Missouri | 29005 | 576 | 6 |
1672891 | 1672891 | 2021-08-31 | Corson | South Dakota | 46031 | 576 | 12 |
1668784 | 1668784 | 2021-08-30 | Broadwater | Montana | 30007 | 576 | 8 |
1666877 | 1666877 | 2021-08-29 | Cumberland | Virginia | 51049 | 576 | 10 |
1663629 | 1663629 | 2021-08-28 | Cumberland | Virginia | 51049 | 576 | 10 |
1660381 | 1660381 | 2021-08-27 | Cumberland | Virginia | 51049 | 576 | 10 |
1642221 | 1642221 | 2021-08-22 | Fulton | Kentucky | 21075 | 576 | 16 |
1638971 | 1638971 | 2021-08-21 | Fulton | Kentucky | 21075 | 576 | 16 |
1635721 | 1635721 | 2021-08-20 | Fulton | Kentucky | 21075 | 576 | 16 |
1633913 | 1633913 | 2021-08-19 | Deuel | South Dakota | 46039 | 576 | 10 |
1611371 | 1611371 | 2021-08-12 | Concho | Texas | 48095 | 576 | 9 |
1611664 | 1611664 | 2021-08-12 | Fairfax city | Virginia | 51600 | 576 | 19 |
1608417 | 1608417 | 2021-08-11 | Fairfax city | Virginia | 51600 | 576 | 19 |
1605168 | 1605168 | 2021-08-10 | Fairfax city | Virginia | 51600 | 576 | 19 |
1601918 | 1601918 | 2021-08-09 | Fairfax city | Virginia | 51600 | 576 | 19 |
1586168 | 1586168 | 2021-08-05 | Modoc | California | 6049 | 576 | 7 |
1582918 | 1582918 | 2021-08-04 | Modoc | California | 6049 | 576 | 7 |
1579668 | 1579668 | 2021-08-03 | Modoc | California | 6049 | 576 | 7 |
1582424 | 1582424 | 2021-08-03 | Fairfax city | Virginia | 51600 | 576 | 19 |
1576420 | 1576420 | 2021-08-02 | Modoc | California | 6049 | 576 | 7 |
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);