ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
996 rows where cases = 188 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 130
- Virginia 62
- Kansas 47
- Georgia 41
- Kentucky 39
- Indiana 34
- Missouri 32
- North Dakota 30
- Iowa 29
- Puerto Rico 27
- Montana 26
- Illinois 25
- Nebraska 25
- Colorado 24
- Ohio 24
- North Carolina 22
- Arkansas 21
- Louisiana 20
- New York 20
- South Dakota 20
- California 19
- West Virginia 19
- Minnesota 18
- Tennessee 18
- Alabama 17
- Wyoming 17
- Michigan 16
- Mississippi 15
- Idaho 14
- Hawaii 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449827 | 2449827 | 2022-04-27 | Culebra | Puerto Rico | 72049 | 188 | |
2446058 | 2446058 | 2022-04-26 | Unknown | New Mexico | 188 | 9 | |
2446570 | 2446570 | 2022-04-26 | Culebra | Puerto Rico | 72049 | 188 | |
2246041 | 2246041 | 2022-02-24 | San Juan | Colorado | 8111 | 188 | 0 |
2177749 | 2177749 | 2022-02-03 | San Juan | Colorado | 8111 | 188 | 0 |
2163894 | 2163894 | 2022-01-29 | Glasscock | Texas | 48173 | 188 | 3 |
2150869 | 2150869 | 2022-01-25 | Foard | Texas | 48155 | 188 | 10 |
2144417 | 2144417 | 2022-01-23 | Kent | Texas | 48263 | 188 | 3 |
2133564 | 2133564 | 2022-01-20 | Wibaux | Montana | 30109 | 188 | 8 |
2082664 | 2082664 | 2022-01-04 | Motley | Texas | 48345 | 188 | 9 |
2079412 | 2079412 | 2022-01-03 | Motley | Texas | 48345 | 188 | 9 |
2040316 | 2040316 | 2021-12-22 | Foard | Texas | 48155 | 188 | 10 |
2037066 | 2037066 | 2021-12-21 | Foard | Texas | 48155 | 188 | 10 |
2033816 | 2033816 | 2021-12-20 | Foard | Texas | 48155 | 188 | 10 |
2030566 | 2030566 | 2021-12-19 | Foard | Texas | 48155 | 188 | 10 |
2027315 | 2027315 | 2021-12-18 | Foard | Texas | 48155 | 188 | 10 |
2024064 | 2024064 | 2021-12-17 | Foard | Texas | 48155 | 188 | 10 |
1965374 | 1965374 | 2021-11-29 | Sully | South Dakota | 46119 | 188 | 3 |
1942351 | 1942351 | 2021-11-22 | Sherman | Oregon | 41055 | 188 | 3 |
1937792 | 1937792 | 2021-11-21 | Lane | Kansas | 20101 | 188 | 8 |
1939101 | 1939101 | 2021-11-21 | Sherman | Oregon | 41055 | 188 | 3 |
1934542 | 1934542 | 2021-11-20 | Lane | Kansas | 20101 | 188 | 8 |
1935851 | 1935851 | 2021-11-20 | Sherman | Oregon | 41055 | 188 | 3 |
1931291 | 1931291 | 2021-11-19 | Lane | Kansas | 20101 | 188 | 8 |
1932601 | 1932601 | 2021-11-19 | Sherman | Oregon | 41055 | 188 | 3 |
1929350 | 1929350 | 2021-11-18 | Sherman | Oregon | 41055 | 188 | 3 |
1926831 | 1926831 | 2021-11-17 | Highland | Virginia | 51091 | 188 | 4 |
1920686 | 1920686 | 2021-11-16 | Wrangell City and Borough | Alaska | 2275 | 188 | 0 |
1923581 | 1923581 | 2021-11-16 | Highland | Virginia | 51091 | 188 | 4 |
1920332 | 1920332 | 2021-11-15 | Highland | Virginia | 51091 | 188 | 4 |
1917082 | 1917082 | 2021-11-14 | Highland | Virginia | 51091 | 188 | 4 |
1913832 | 1913832 | 2021-11-13 | Highland | Virginia | 51091 | 188 | 4 |
1910582 | 1910582 | 2021-11-12 | Highland | Virginia | 51091 | 188 | 4 |
1907333 | 1907333 | 2021-11-11 | Highland | Virginia | 51091 | 188 | 4 |
1881851 | 1881851 | 2021-11-04 | Cheyenne | Colorado | 8017 | 188 | 7 |
1877841 | 1877841 | 2021-11-02 | Irion | Texas | 48235 | 188 | 2 |
1877993 | 1877993 | 2021-11-02 | Piute | Utah | 49031 | 188 | 2 |
1874592 | 1874592 | 2021-11-01 | Irion | Texas | 48235 | 188 | 2 |
1852588 | 1852588 | 2021-10-26 | Sierra | California | 6091 | 188 | 0 |
1849339 | 1849339 | 2021-10-25 | Sierra | California | 6091 | 188 | 0 |
1851603 | 1851603 | 2021-10-25 | Hyde | South Dakota | 46069 | 188 | 1 |
1846089 | 1846089 | 2021-10-24 | Sierra | California | 6091 | 188 | 0 |
1842839 | 1842839 | 2021-10-23 | Sierra | California | 6091 | 188 | 0 |
1839589 | 1839589 | 2021-10-22 | Sierra | California | 6091 | 188 | 0 |
1836340 | 1836340 | 2021-10-21 | Sierra | California | 6091 | 188 | 0 |
1769655 | 1769655 | 2021-09-30 | Storey | Nevada | 32029 | 188 | 4 |
1764889 | 1764889 | 2021-09-29 | Dolores | Colorado | 8033 | 188 | 1 |
1738283 | 1738283 | 2021-09-20 | Rich | Utah | 49033 | 188 | 0 |
1735033 | 1735033 | 2021-09-19 | Rich | Utah | 49033 | 188 | 0 |
1731783 | 1731783 | 2021-09-18 | Rich | Utah | 49033 | 188 | 0 |
1728533 | 1728533 | 2021-09-17 | Rich | Utah | 49033 | 188 | 0 |
1714087 | 1714087 | 2021-09-13 | Issaquena | Mississippi | 28055 | 188 | 6 |
1696478 | 1696478 | 2021-09-08 | Denali Borough | Alaska | 2068 | 188 | 0 |
1649022 | 1649022 | 2021-08-24 | Cook | Minnesota | 27031 | 188 | 0 |
1631279 | 1631279 | 2021-08-18 | Wahkiakum | Washington | 53069 | 188 | 5 |
1628004 | 1628004 | 2021-08-17 | Columbia | Washington | 53013 | 188 | 6 |
1623333 | 1623333 | 2021-08-16 | McCone | Montana | 30055 | 188 | 2 |
1619357 | 1619357 | 2021-08-15 | Comanche | Kansas | 20033 | 188 | 10 |
1620086 | 1620086 | 2021-08-15 | McCone | Montana | 30055 | 188 | 2 |
1616109 | 1616109 | 2021-08-14 | Comanche | Kansas | 20033 | 188 | 10 |
1616838 | 1616838 | 2021-08-14 | McCone | Montana | 30055 | 188 | 2 |
1612860 | 1612860 | 2021-08-13 | Comanche | Kansas | 20033 | 188 | 10 |
1613590 | 1613590 | 2021-08-13 | McCone | Montana | 30055 | 188 | 2 |
1614595 | 1614595 | 2021-08-13 | Briscoe | Texas | 48045 | 188 | 7 |
1610341 | 1610341 | 2021-08-12 | McCone | Montana | 30055 | 188 | 2 |
1611346 | 1611346 | 2021-08-12 | Briscoe | Texas | 48045 | 188 | 7 |
1607118 | 1607118 | 2021-08-11 | Wheatland | Montana | 30107 | 188 | 8 |
1608098 | 1608098 | 2021-08-11 | Briscoe | Texas | 48045 | 188 | 7 |
1602287 | 1602287 | 2021-08-10 | Petersburg Borough | Alaska | 2195 | 188 | 1 |
1603869 | 1603869 | 2021-08-10 | Wheatland | Montana | 30107 | 188 | 8 |
1551217 | 1551217 | 2021-07-25 | Stanton | Kansas | 20187 | 188 | 6 |
1547970 | 1547970 | 2021-07-24 | Stanton | Kansas | 20187 | 188 | 6 |
1544723 | 1544723 | 2021-07-23 | Stanton | Kansas | 20187 | 188 | 6 |
1541475 | 1541475 | 2021-07-22 | Stanton | Kansas | 20187 | 188 | 6 |
1543573 | 1543573 | 2021-07-22 | San Juan | Washington | 53055 | 188 | 0 |
1538228 | 1538228 | 2021-07-21 | Stanton | Kansas | 20187 | 188 | 6 |
1540325 | 1540325 | 2021-07-21 | San Juan | Washington | 53055 | 188 | 0 |
1537078 | 1537078 | 2021-07-20 | San Juan | Washington | 53055 | 188 | 0 |
1533830 | 1533830 | 2021-07-19 | San Juan | Washington | 53055 | 188 | 0 |
1518743 | 1518743 | 2021-07-15 | Stanton | Kansas | 20187 | 188 | 6 |
1519770 | 1519770 | 2021-07-15 | Divide | North Dakota | 38023 | 188 | 2 |
1515496 | 1515496 | 2021-07-14 | Stanton | Kansas | 20187 | 188 | 6 |
1516522 | 1516522 | 2021-07-14 | Divide | North Dakota | 38023 | 188 | 2 |
1512250 | 1512250 | 2021-07-13 | Stanton | Kansas | 20187 | 188 | 6 |
1513275 | 1513275 | 2021-07-13 | Divide | North Dakota | 38023 | 188 | 2 |
1509003 | 1509003 | 2021-07-12 | Stanton | Kansas | 20187 | 188 | 6 |
1505757 | 1505757 | 2021-07-11 | Stanton | Kansas | 20187 | 188 | 6 |
1502511 | 1502511 | 2021-07-10 | Stanton | Kansas | 20187 | 188 | 6 |
1499265 | 1499265 | 2021-07-09 | Stanton | Kansas | 20187 | 188 | 6 |
1494468 | 1494468 | 2021-07-07 | Dickens | Texas | 48125 | 188 | 10 |
1491221 | 1491221 | 2021-07-06 | Dickens | Texas | 48125 | 188 | 10 |
1487974 | 1487974 | 2021-07-05 | Dickens | Texas | 48125 | 188 | 10 |
1484727 | 1484727 | 2021-07-04 | Dickens | Texas | 48125 | 188 | 10 |
1481481 | 1481481 | 2021-07-03 | Dickens | Texas | 48125 | 188 | 10 |
1478234 | 1478234 | 2021-07-02 | Dickens | Texas | 48125 | 188 | 10 |
1474988 | 1474988 | 2021-07-01 | Dickens | Texas | 48125 | 188 | 10 |
1468497 | 1468497 | 2021-06-29 | Dickens | Texas | 48125 | 188 | 10 |
1464582 | 1464582 | 2021-06-28 | Divide | North Dakota | 38023 | 188 | 2 |
1461337 | 1461337 | 2021-06-27 | Divide | North Dakota | 38023 | 188 | 2 |
1458092 | 1458092 | 2021-06-26 | Divide | North Dakota | 38023 | 188 | 2 |
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);