ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
719 rows where cases = 355 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 69
- Texas 62
- Virginia 44
- Georgia 41
- Kansas 33
- North Dakota 30
- Puerto Rico 26
- Iowa 25
- Louisiana 23
- Colorado 22
- Mississippi 22
- Missouri 22
- Michigan 18
- Nebraska 18
- Kentucky 16
- Minnesota 16
- New Mexico 16
- Ohio 16
- Montana 15
- Oklahoma 15
- Arkansas 13
- Illinois 11
- Indiana 11
- New York 11
- Idaho 10
- North Carolina 10
- West Virginia 10
- Pennsylvania 9
- Alaska 8
- Oregon 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2385196 | 2385196 | 2022-04-07 | Stonewall | Texas | 48433 | 355 | 7 |
2381941 | 2381941 | 2022-04-06 | Stonewall | Texas | 48433 | 355 | 7 |
2378686 | 2378686 | 2022-04-05 | Stonewall | Texas | 48433 | 355 | 7 |
2375432 | 2375432 | 2022-04-04 | Stonewall | Texas | 48433 | 355 | 7 |
2372180 | 2372180 | 2022-04-03 | Stonewall | Texas | 48433 | 355 | 7 |
2356583 | 2356583 | 2022-03-30 | Dolores | Colorado | 8033 | 355 | 8 |
2337066 | 2337066 | 2022-03-24 | Dolores | Colorado | 8033 | 355 | 8 |
2311039 | 2311039 | 2022-03-16 | Dolores | Colorado | 8033 | 355 | 8 |
2301283 | 2301283 | 2022-03-13 | Dolores | Colorado | 8033 | 355 | 8 |
2298031 | 2298031 | 2022-03-12 | Dolores | Colorado | 8033 | 355 | 8 |
2294779 | 2294779 | 2022-03-11 | Dolores | Colorado | 8033 | 355 | 8 |
2288275 | 2288275 | 2022-03-09 | Dolores | Colorado | 8033 | 355 | 8 |
2248729 | 2248729 | 2022-02-24 | Highland | Virginia | 51091 | 355 | 5 |
2214935 | 2214935 | 2022-02-14 | Garden | Nebraska | 31069 | 355 | 1 |
2172566 | 2172566 | 2022-02-01 | Daniels | Montana | 30019 | 355 | 9 |
2169313 | 2169313 | 2022-01-31 | Daniels | Montana | 30019 | 355 | 9 |
2153060 | 2153060 | 2022-01-26 | McCone | Montana | 30055 | 355 | 9 |
2109672 | 2109672 | 2022-01-13 | Webster | Georgia | 13307 | 355 | 7 |
2107895 | 2107895 | 2022-01-12 | Divide | North Dakota | 38023 | 355 | 3 |
2105321 | 2105321 | 2022-01-11 | Edwards | Texas | 48137 | 355 | 9 |
2092001 | 2092001 | 2022-01-07 | Maricao | Puerto Rico | 72093 | 355 | |
2092252 | 2092252 | 2022-01-07 | Armstrong | Texas | 48011 | 355 | 8 |
2078643 | 2078643 | 2022-01-03 | Logan | North Dakota | 38047 | 355 | 11 |
2079104 | 2079104 | 2022-01-03 | Haakon | South Dakota | 46055 | 355 | 11 |
2075392 | 2075392 | 2022-01-02 | Logan | North Dakota | 38047 | 355 | 11 |
2072141 | 2072141 | 2022-01-01 | Logan | North Dakota | 38047 | 355 | 11 |
2033623 | 2033623 | 2021-12-20 | Mellette | South Dakota | 46095 | 355 | 4 |
1998144 | 1998144 | 2021-12-09 | Menard | Texas | 48327 | 355 | 11 |
1994128 | 1994128 | 2021-12-08 | Grant | North Dakota | 38037 | 355 | 8 |
1994893 | 1994893 | 2021-12-08 | Menard | Texas | 48327 | 355 | 11 |
1990877 | 1990877 | 2021-12-07 | Grant | North Dakota | 38037 | 355 | 8 |
1991642 | 1991642 | 2021-12-07 | Menard | Texas | 48327 | 355 | 11 |
1918446 | 1918446 | 2021-11-15 | Robertson | Kentucky | 21201 | 355 | 16 |
1910357 | 1910357 | 2021-11-12 | Knox | Texas | 48275 | 355 | 21 |
1907108 | 1907108 | 2021-11-11 | Knox | Texas | 48275 | 355 | 21 |
1884107 | 1884107 | 2021-11-04 | Miner | South Dakota | 46097 | 355 | 11 |
1884428 | 1884428 | 2021-11-04 | Schleicher | Texas | 48413 | 355 | 9 |
1878014 | 1878014 | 2021-11-02 | Grand Isle | Vermont | 50013 | 355 | 2 |
1874654 | 1874654 | 2021-11-01 | Oldham | Texas | 48359 | 355 | 6 |
1874765 | 1874765 | 2021-11-01 | Grand Isle | Vermont | 50013 | 355 | 2 |
1871405 | 1871405 | 2021-10-31 | Oldham | Texas | 48359 | 355 | 6 |
1871516 | 1871516 | 2021-10-31 | Grand Isle | Vermont | 50013 | 355 | 2 |
1868156 | 1868156 | 2021-10-30 | Oldham | Texas | 48359 | 355 | 6 |
1853276 | 1853276 | 2021-10-26 | Edwards | Kansas | 20047 | 355 | 13 |
1854094 | 1854094 | 2021-10-26 | Perkins | Nebraska | 31135 | 355 | 12 |
1850027 | 1850027 | 2021-10-25 | Edwards | Kansas | 20047 | 355 | 13 |
1850845 | 1850845 | 2021-10-25 | Perkins | Nebraska | 31135 | 355 | 12 |
1847595 | 1847595 | 2021-10-24 | Perkins | Nebraska | 31135 | 355 | 12 |
1844345 | 1844345 | 2021-10-23 | Perkins | Nebraska | 31135 | 355 | 12 |
1841095 | 1841095 | 2021-10-22 | Perkins | Nebraska | 31135 | 355 | 12 |
1836367 | 1836367 | 2021-10-21 | Custer | Colorado | 8027 | 355 | 7 |
1837846 | 1837846 | 2021-10-21 | Perkins | Nebraska | 31135 | 355 | 12 |
1838135 | 1838135 | 2021-10-21 | Kidder | North Dakota | 38043 | 355 | 11 |
1834886 | 1834886 | 2021-10-20 | Kidder | North Dakota | 38043 | 355 | 11 |
1827995 | 1827995 | 2021-10-18 | Granite | Montana | 30039 | 355 | 2 |
1824945 | 1824945 | 2021-10-17 | Mora | New Mexico | 35033 | 355 | 11 |
1821696 | 1821696 | 2021-10-16 | Mora | New Mexico | 35033 | 355 | 11 |
1818447 | 1818447 | 2021-10-15 | Mora | New Mexico | 35033 | 355 | 11 |
1815067 | 1815067 | 2021-10-14 | Frontier | Nebraska | 31063 | 355 | 1 |
1786167 | 1786167 | 2021-10-05 | Renville | North Dakota | 38075 | 355 | 14 |
1782918 | 1782918 | 2021-10-04 | Renville | North Dakota | 38075 | 355 | 14 |
1779669 | 1779669 | 2021-10-03 | Renville | North Dakota | 38075 | 355 | 14 |
1776419 | 1776419 | 2021-10-02 | Renville | North Dakota | 38075 | 355 | 14 |
1773169 | 1773169 | 2021-10-01 | Renville | North Dakota | 38075 | 355 | 14 |
1769901 | 1769901 | 2021-09-30 | Griggs | North Dakota | 38039 | 355 | 2 |
1766652 | 1766652 | 2021-09-29 | Griggs | North Dakota | 38039 | 355 | 2 |
1766670 | 1766670 | 2021-09-29 | Renville | North Dakota | 38075 | 355 | 14 |
1739604 | 1739604 | 2021-09-21 | Osborne | Kansas | 20141 | 355 | 13 |
1736355 | 1736355 | 2021-09-20 | Osborne | Kansas | 20141 | 355 | 13 |
1738301 | 1738301 | 2021-09-20 | Essex | Vermont | 50009 | 355 | 2 |
1733105 | 1733105 | 2021-09-19 | Osborne | Kansas | 20141 | 355 | 13 |
1729855 | 1729855 | 2021-09-18 | Osborne | Kansas | 20141 | 355 | 13 |
1726605 | 1726605 | 2021-09-17 | Osborne | Kansas | 20141 | 355 | 13 |
1714920 | 1714920 | 2021-09-13 | Cameron | Pennsylvania | 42023 | 355 | 10 |
1711674 | 1711674 | 2021-09-12 | Cameron | Pennsylvania | 42023 | 355 | 10 |
1702322 | 1702322 | 2021-09-09 | Collingsworth | Texas | 48087 | 355 | 9 |
1699073 | 1699073 | 2021-09-08 | Collingsworth | Texas | 48087 | 355 | 9 |
1692427 | 1692427 | 2021-09-06 | Sanborn | South Dakota | 46111 | 355 | 3 |
1689178 | 1689178 | 2021-09-05 | Sanborn | South Dakota | 46111 | 355 | 3 |
1685928 | 1685928 | 2021-09-04 | Sanborn | South Dakota | 46111 | 355 | 3 |
1682184 | 1682184 | 2021-09-03 | Hettinger | North Dakota | 38041 | 355 | 4 |
1682677 | 1682677 | 2021-09-03 | Sanborn | South Dakota | 46111 | 355 | 3 |
1673953 | 1673953 | 2021-09-01 | Ouray | Colorado | 8091 | 355 | 5 |
1667619 | 1667619 | 2021-08-30 | Glascock | Georgia | 13125 | 355 | 19 |
1664169 | 1664169 | 2021-08-29 | Baca | Colorado | 8009 | 355 | 5 |
1660921 | 1660921 | 2021-08-28 | Baca | Colorado | 8009 | 355 | 5 |
1657673 | 1657673 | 2021-08-27 | Baca | Colorado | 8009 | 355 | 5 |
1659290 | 1659290 | 2021-08-27 | Hamilton | New York | 36041 | 355 | 2 |
1642745 | 1642745 | 2021-08-22 | Mercer | Missouri | 29129 | 355 | 2 |
1632797 | 1632797 | 2021-08-19 | Lake of the Woods | Minnesota | 27077 | 355 | 4 |
1623056 | 1623056 | 2021-08-16 | Lake of the Woods | Minnesota | 27077 | 355 | 4 |
1619809 | 1619809 | 2021-08-15 | Lake of the Woods | Minnesota | 27077 | 355 | 4 |
1616561 | 1616561 | 2021-08-14 | Lake of the Woods | Minnesota | 27077 | 355 | 4 |
1613313 | 1613313 | 2021-08-13 | Lake of the Woods | Minnesota | 27077 | 355 | 4 |
1610729 | 1610729 | 2021-08-12 | McIntosh | North Dakota | 38051 | 355 | 7 |
1611655 | 1611655 | 2021-08-12 | Craig | Virginia | 51045 | 355 | 6 |
1588332 | 1588332 | 2021-08-05 | Las Marias | Puerto Rico | 72083 | 355 | |
1559241 | 1559241 | 2021-07-27 | Stanley | South Dakota | 46117 | 355 | 2 |
1555994 | 1555994 | 2021-07-26 | Stanley | South Dakota | 46117 | 355 | 2 |
1552747 | 1552747 | 2021-07-25 | Stanley | South Dakota | 46117 | 355 | 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);