ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,010 rows where cases = 153 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 99
- Montana 64
- Kansas 54
- Virginia 49
- Georgia 46
- Puerto Rico 41
- South Dakota 39
- Missouri 37
- Kentucky 35
- Indiana 34
- Michigan 34
- Ohio 33
- Nebraska 32
- Alaska 27
- Minnesota 25
- Illinois 23
- Iowa 23
- Arkansas 22
- North Carolina 22
- Oklahoma 21
- Tennessee 21
- Colorado 20
- Mississippi 20
- West Virginia 20
- North Dakota 18
- New York 14
- Utah 14
- Wisconsin 14
- Louisiana 13
- Alabama 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502466 | 2502466 | 2022-05-13 | Daggett | Utah | 49009 | 153 | 0 |
2499208 | 2499208 | 2022-05-12 | Daggett | Utah | 49009 | 153 | 0 |
2495950 | 2495950 | 2022-05-11 | Daggett | Utah | 49009 | 153 | 0 |
2492692 | 2492692 | 2022-05-10 | Daggett | Utah | 49009 | 153 | 0 |
2489434 | 2489434 | 2022-05-09 | Daggett | Utah | 49009 | 153 | 0 |
2421504 | 2421504 | 2022-04-19 | Skagway Municipality | Alaska | 2230 | 153 | 0 |
2418248 | 2418248 | 2022-04-18 | Skagway Municipality | Alaska | 2230 | 153 | 0 |
2414992 | 2414992 | 2022-04-17 | Skagway Municipality | Alaska | 2230 | 153 | 0 |
2411736 | 2411736 | 2022-04-16 | Skagway Municipality | Alaska | 2230 | 153 | 0 |
2408480 | 2408480 | 2022-04-15 | Skagway Municipality | Alaska | 2230 | 153 | 0 |
2405224 | 2405224 | 2022-04-14 | Skagway Municipality | Alaska | 2230 | 153 | 0 |
2401969 | 2401969 | 2022-04-13 | Skagway Municipality | Alaska | 2230 | 153 | 0 |
2309013 | 2309013 | 2022-03-15 | Unknown | Mississippi | 153 | 13 | |
2217681 | 2217681 | 2022-02-15 | Unknown | Maine | 153 | 0 | |
2170478 | 2170478 | 2022-01-31 | McMullen | Texas | 48311 | 153 | 8 |
2147736 | 2147736 | 2022-01-24 | Roberts | Texas | 48393 | 153 | 1 |
2144482 | 2144482 | 2022-01-23 | Roberts | Texas | 48393 | 153 | 1 |
2141227 | 2141227 | 2022-01-22 | Roberts | Texas | 48393 | 153 | 1 |
2137971 | 2137971 | 2022-01-21 | Roberts | Texas | 48393 | 153 | 1 |
2134717 | 2134717 | 2022-01-20 | Roberts | Texas | 48393 | 153 | 1 |
2131465 | 2131465 | 2022-01-19 | Roberts | Texas | 48393 | 153 | 1 |
2104891 | 2104891 | 2022-01-11 | Wheeler | Oregon | 41069 | 153 | 2 |
2098625 | 2098625 | 2022-01-09 | Jones | South Dakota | 46075 | 153 | 1 |
2095373 | 2095373 | 2022-01-08 | Jones | South Dakota | 46075 | 153 | 1 |
2092121 | 2092121 | 2022-01-07 | Jones | South Dakota | 46075 | 153 | 1 |
2088869 | 2088869 | 2022-01-06 | Jones | South Dakota | 46075 | 153 | 1 |
2076899 | 2076899 | 2022-01-03 | Mineral | Colorado | 8079 | 153 | 1 |
2073648 | 2073648 | 2022-01-02 | Mineral | Colorado | 8079 | 153 | 1 |
2070397 | 2070397 | 2022-01-01 | Mineral | Colorado | 8079 | 153 | 1 |
2067146 | 2067146 | 2021-12-31 | Mineral | Colorado | 8079 | 153 | 1 |
1846789 | 1846789 | 2021-10-24 | Greeley | Kansas | 20071 | 153 | 2 |
1843539 | 1843539 | 2021-10-23 | Greeley | Kansas | 20071 | 153 | 2 |
1840289 | 1840289 | 2021-10-22 | Greeley | Kansas | 20071 | 153 | 2 |
1842068 | 1842068 | 2021-10-22 | Glasscock | Texas | 48173 | 153 | 3 |
1838629 | 1838629 | 2021-10-21 | Sully | South Dakota | 46119 | 153 | 3 |
1838819 | 1838819 | 2021-10-21 | Glasscock | Texas | 48173 | 153 | 3 |
1835098 | 1835098 | 2021-10-20 | Gilliam | Oregon | 41021 | 153 | 4 |
1835380 | 1835380 | 2021-10-20 | Sully | South Dakota | 46119 | 153 | 3 |
1835570 | 1835570 | 2021-10-20 | Glasscock | Texas | 48173 | 153 | 3 |
1832131 | 1832131 | 2021-10-19 | Sully | South Dakota | 46119 | 153 | 3 |
1832321 | 1832321 | 2021-10-19 | Glasscock | Texas | 48173 | 153 | 3 |
1828882 | 1828882 | 2021-10-18 | Sully | South Dakota | 46119 | 153 | 3 |
1829158 | 1829158 | 2021-10-18 | Motley | Texas | 48345 | 153 | 9 |
1825633 | 1825633 | 2021-10-17 | Sully | South Dakota | 46119 | 153 | 3 |
1825909 | 1825909 | 2021-10-17 | Motley | Texas | 48345 | 153 | 9 |
1822384 | 1822384 | 2021-10-16 | Sully | South Dakota | 46119 | 153 | 3 |
1822660 | 1822660 | 2021-10-16 | Motley | Texas | 48345 | 153 | 9 |
1819135 | 1819135 | 2021-10-15 | Sully | South Dakota | 46119 | 153 | 3 |
1819411 | 1819411 | 2021-10-15 | Motley | Texas | 48345 | 153 | 9 |
1811771 | 1811771 | 2021-10-13 | Prairie | Montana | 30079 | 153 | 2 |
1812610 | 1812610 | 2021-10-13 | Harding | South Dakota | 46063 | 153 | 1 |
1808522 | 1808522 | 2021-10-12 | Prairie | Montana | 30079 | 153 | 2 |
1779294 | 1779294 | 2021-10-03 | Wibaux | Montana | 30109 | 153 | 7 |
1776044 | 1776044 | 2021-10-02 | Wibaux | Montana | 30109 | 153 | 7 |
1772794 | 1772794 | 2021-10-01 | Wibaux | Montana | 30109 | 153 | 7 |
1746082 | 1746082 | 2021-09-23 | Lane | Kansas | 20101 | 153 | 7 |
1742833 | 1742833 | 2021-09-22 | Lane | Kansas | 20101 | 153 | 7 |
1744873 | 1744873 | 2021-09-22 | Highland | Virginia | 51091 | 153 | 1 |
1739584 | 1739584 | 2021-09-21 | Lane | Kansas | 20101 | 153 | 7 |
1741624 | 1741624 | 2021-09-21 | Highland | Virginia | 51091 | 153 | 1 |
1736335 | 1736335 | 2021-09-20 | Lane | Kansas | 20101 | 153 | 7 |
1738375 | 1738375 | 2021-09-20 | Highland | Virginia | 51091 | 153 | 1 |
1733085 | 1733085 | 2021-09-19 | Lane | Kansas | 20101 | 153 | 7 |
1729835 | 1729835 | 2021-09-18 | Lane | Kansas | 20101 | 153 | 7 |
1726585 | 1726585 | 2021-09-17 | Lane | Kansas | 20101 | 153 | 7 |
1722464 | 1722464 | 2021-09-16 | Haines Borough | Alaska | 2100 | 153 | 0 |
1693419 | 1693419 | 2021-09-07 | Dolores | Colorado | 8033 | 153 | 1 |
1623310 | 1623310 | 2021-08-16 | Carter | Montana | 30011 | 153 | 5 |
1620063 | 1620063 | 2021-08-15 | Carter | Montana | 30011 | 153 | 5 |
1616815 | 1616815 | 2021-08-14 | Carter | Montana | 30011 | 153 | 5 |
1613567 | 1613567 | 2021-08-13 | Carter | Montana | 30011 | 153 | 5 |
1607070 | 1607070 | 2021-08-11 | Carter | Montana | 30011 | 153 | 5 |
1603821 | 1603821 | 2021-08-10 | Carter | Montana | 30011 | 153 | 5 |
1600572 | 1600572 | 2021-08-09 | Carter | Montana | 30011 | 153 | 5 |
1597324 | 1597324 | 2021-08-08 | Carter | Montana | 30011 | 153 | 5 |
1594075 | 1594075 | 2021-08-07 | Carter | Montana | 30011 | 153 | 5 |
1590826 | 1590826 | 2021-08-06 | Carter | Montana | 30011 | 153 | 5 |
1574604 | 1574604 | 2021-08-01 | Meagher | Montana | 30059 | 153 | 7 |
1576027 | 1576027 | 2021-08-01 | Columbia | Washington | 53013 | 153 | 6 |
1571356 | 1571356 | 2021-07-31 | Meagher | Montana | 30059 | 153 | 7 |
1572779 | 1572779 | 2021-07-31 | Columbia | Washington | 53013 | 153 | 6 |
1568108 | 1568108 | 2021-07-30 | Meagher | Montana | 30059 | 153 | 7 |
1569531 | 1569531 | 2021-07-30 | Columbia | Washington | 53013 | 153 | 6 |
1564860 | 1564860 | 2021-07-29 | Meagher | Montana | 30059 | 153 | 7 |
1561612 | 1561612 | 2021-07-28 | Meagher | Montana | 30059 | 153 | 7 |
1558364 | 1558364 | 2021-07-27 | Meagher | Montana | 30059 | 153 | 7 |
1537782 | 1537782 | 2021-07-21 | Webster | Georgia | 13307 | 153 | 4 |
1534534 | 1534534 | 2021-07-20 | Webster | Georgia | 13307 | 153 | 4 |
1516885 | 1516885 | 2021-07-14 | Maricao | Puerto Rico | 72093 | 153 | |
1513638 | 1513638 | 2021-07-13 | Maricao | Puerto Rico | 72093 | 153 | |
1510392 | 1510392 | 2021-07-12 | Maricao | Puerto Rico | 72093 | 153 | |
1507145 | 1507145 | 2021-07-11 | Maricao | Puerto Rico | 72093 | 153 | |
1503899 | 1503899 | 2021-07-10 | Maricao | Puerto Rico | 72093 | 153 | |
1500653 | 1500653 | 2021-07-09 | Maricao | Puerto Rico | 72093 | 153 | |
1496672 | 1496672 | 2021-07-08 | Meagher | Montana | 30059 | 153 | 7 |
1493425 | 1493425 | 2021-07-07 | Meagher | Montana | 30059 | 153 | 7 |
1426713 | 1426713 | 2021-06-16 | Wahkiakum | Washington | 53069 | 153 | 1 |
1360413 | 1360413 | 2021-05-27 | Garfield | Nebraska | 31071 | 153 | 1 |
1357167 | 1357167 | 2021-05-26 | Garfield | Nebraska | 31071 | 153 | 1 |
1353921 | 1353921 | 2021-05-25 | Garfield | Nebraska | 31071 | 153 | 1 |
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);