ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
706 rows where cases = 364 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 83
- South Dakota 72
- Kansas 44
- Georgia 36
- Colorado 31
- North Dakota 29
- Puerto Rico 29
- Kentucky 28
- Missouri 28
- Virginia 27
- Indiana 21
- Alaska 18
- Iowa 13
- Minnesota 12
- New York 12
- North Carolina 12
- Oklahoma 12
- Pennsylvania 12
- New Mexico 11
- Tennessee 11
- Idaho 10
- Illinois 10
- Mississippi 10
- Nebraska 10
- Ohio 10
- Washington 10
- West Virginia 10
- Wisconsin 10
- Wyoming 10
- Utah 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415166 | 2415166 | 2022-04-17 | Dolores | Colorado | 8033 | 364 | 8 |
2411910 | 2411910 | 2022-04-16 | Dolores | Colorado | 8033 | 364 | 8 |
2408654 | 2408654 | 2022-04-15 | Dolores | Colorado | 8033 | 364 | 8 |
2405398 | 2405398 | 2022-04-14 | Dolores | Colorado | 8033 | 364 | 8 |
2356059 | 2356059 | 2022-03-29 | Highland | Virginia | 51091 | 364 | 7 |
2352806 | 2352806 | 2022-03-28 | Highland | Virginia | 51091 | 364 | 7 |
2349554 | 2349554 | 2022-03-27 | Highland | Virginia | 51091 | 364 | 7 |
2346301 | 2346301 | 2022-03-26 | Highland | Virginia | 51091 | 364 | 7 |
2343048 | 2343048 | 2022-03-25 | Highland | Virginia | 51091 | 364 | 7 |
2179087 | 2179087 | 2022-02-03 | Liberty | Montana | 30051 | 364 | 2 |
2169741 | 2169741 | 2022-01-31 | Steele | North Dakota | 38091 | 364 | 2 |
2151262 | 2151262 | 2022-01-25 | Wahkiakum | Washington | 53069 | 364 | 5 |
2147823 | 2147823 | 2022-01-24 | Wayne | Utah | 49055 | 364 | 0 |
2148010 | 2148010 | 2022-01-24 | Wahkiakum | Washington | 53069 | 364 | 5 |
2144403 | 2144403 | 2022-01-23 | Irion | Texas | 48235 | 364 | 2 |
2144569 | 2144569 | 2022-01-23 | Wayne | Utah | 49055 | 364 | 0 |
2141314 | 2141314 | 2022-01-22 | Wayne | Utah | 49055 | 364 | 0 |
2138058 | 2138058 | 2022-01-21 | Wayne | Utah | 49055 | 364 | 0 |
2132403 | 2132403 | 2022-01-20 | Quitman | Georgia | 13239 | 364 | 4 |
2115030 | 2115030 | 2022-01-14 | Briscoe | Texas | 48045 | 364 | 8 |
2098505 | 2098505 | 2022-01-09 | Maricao | Puerto Rico | 72093 | 364 | |
2088859 | 2088859 | 2022-01-06 | Haakon | South Dakota | 46055 | 364 | 11 |
2085130 | 2085130 | 2022-01-05 | Burke | North Dakota | 38013 | 364 | 3 |
2077957 | 2077957 | 2022-01-03 | Cook | Minnesota | 27031 | 364 | 1 |
2060663 | 2060663 | 2021-12-29 | Sedgwick | Colorado | 8115 | 364 | 6 |
2057414 | 2057414 | 2021-12-28 | Sedgwick | Colorado | 8115 | 364 | 6 |
2054165 | 2054165 | 2021-12-27 | Sedgwick | Colorado | 8115 | 364 | 6 |
2050915 | 2050915 | 2021-12-26 | Sedgwick | Colorado | 8115 | 364 | 6 |
2047665 | 2047665 | 2021-12-25 | Sedgwick | Colorado | 8115 | 364 | 6 |
2044415 | 2044415 | 2021-12-24 | Sedgwick | Colorado | 8115 | 364 | 6 |
2041166 | 2041166 | 2021-12-23 | Sedgwick | Colorado | 8115 | 364 | 6 |
2037916 | 2037916 | 2021-12-22 | Sedgwick | Colorado | 8115 | 364 | 6 |
2034666 | 2034666 | 2021-12-21 | Sedgwick | Colorado | 8115 | 364 | 6 |
2031416 | 2031416 | 2021-12-20 | Sedgwick | Colorado | 8115 | 364 | 6 |
2019018 | 2019018 | 2021-12-16 | Clark | Kansas | 20025 | 364 | 7 |
2015768 | 2015768 | 2021-12-15 | Clark | Kansas | 20025 | 364 | 7 |
2016883 | 2016883 | 2021-12-15 | Grant | North Dakota | 38037 | 364 | 9 |
2014441 | 2014441 | 2021-12-14 | Schleicher | Texas | 48413 | 364 | 9 |
2011190 | 2011190 | 2021-12-13 | Schleicher | Texas | 48413 | 364 | 9 |
2007939 | 2007939 | 2021-12-12 | Schleicher | Texas | 48413 | 364 | 9 |
2004688 | 2004688 | 2021-12-11 | Schleicher | Texas | 48413 | 364 | 9 |
2001437 | 2001437 | 2021-12-10 | Schleicher | Texas | 48413 | 364 | 9 |
1998187 | 1998187 | 2021-12-09 | Schleicher | Texas | 48413 | 364 | 9 |
1994936 | 1994936 | 2021-12-08 | Schleicher | Texas | 48413 | 364 | 9 |
1991685 | 1991685 | 2021-12-07 | Schleicher | Texas | 48413 | 364 | 9 |
1988434 | 1988434 | 2021-12-06 | Schleicher | Texas | 48413 | 364 | 9 |
1985184 | 1985184 | 2021-12-05 | Schleicher | Texas | 48413 | 364 | 9 |
1981934 | 1981934 | 2021-12-04 | Schleicher | Texas | 48413 | 364 | 9 |
1978684 | 1978684 | 2021-12-03 | Schleicher | Texas | 48413 | 364 | 9 |
1973524 | 1973524 | 2021-12-02 | Elk | Kansas | 20049 | 364 | 6 |
1970274 | 1970274 | 2021-12-01 | Elk | Kansas | 20049 | 364 | 6 |
1942605 | 1942605 | 2021-11-22 | Miner | South Dakota | 46097 | 364 | 11 |
1939355 | 1939355 | 2021-11-21 | Miner | South Dakota | 46097 | 364 | 11 |
1936105 | 1936105 | 2021-11-20 | Miner | South Dakota | 46097 | 364 | 11 |
1932855 | 1932855 | 2021-11-19 | Miner | South Dakota | 46097 | 364 | 11 |
1919366 | 1919366 | 2021-11-15 | Golden Valley | North Dakota | 38033 | 364 | 4 |
1916116 | 1916116 | 2021-11-14 | Golden Valley | North Dakota | 38033 | 364 | 4 |
1896623 | 1896623 | 2021-11-08 | Kidder | North Dakota | 38043 | 364 | 11 |
1893373 | 1893373 | 2021-11-07 | Kidder | North Dakota | 38043 | 364 | 11 |
1890123 | 1890123 | 2021-11-06 | Kidder | North Dakota | 38043 | 364 | 11 |
1891012 | 1891012 | 2021-11-06 | Grand Isle | Vermont | 50013 | 364 | 2 |
1886873 | 1886873 | 2021-11-05 | Kidder | North Dakota | 38043 | 364 | 11 |
1887651 | 1887651 | 2021-11-05 | Oldham | Texas | 48359 | 364 | 6 |
1883624 | 1883624 | 2021-11-04 | Kidder | North Dakota | 38043 | 364 | 11 |
1884401 | 1884401 | 2021-11-04 | Oldham | Texas | 48359 | 364 | 6 |
1880375 | 1880375 | 2021-11-03 | Kidder | North Dakota | 38043 | 364 | 11 |
1876048 | 1876048 | 2021-11-02 | Lincoln | Kansas | 20105 | 364 | 6 |
1872799 | 1872799 | 2021-11-01 | Lincoln | Kansas | 20105 | 364 | 6 |
1869517 | 1869517 | 2021-10-31 | Decatur | Kansas | 20039 | 364 | 13 |
1866268 | 1866268 | 2021-10-30 | Decatur | Kansas | 20039 | 364 | 13 |
1863019 | 1863019 | 2021-10-29 | Decatur | Kansas | 20039 | 364 | 13 |
1852173 | 1852173 | 2021-10-25 | Columbia | Washington | 53013 | 364 | 8 |
1837941 | 1837941 | 2021-10-21 | Mora | New Mexico | 35033 | 364 | 11 |
1823369 | 1823369 | 2021-10-17 | Costilla | Colorado | 8023 | 364 | 10 |
1820120 | 1820120 | 2021-10-16 | Costilla | Colorado | 8023 | 364 | 10 |
1816871 | 1816871 | 2021-10-15 | Costilla | Colorado | 8023 | 364 | 10 |
1818657 | 1818657 | 2021-10-15 | Renville | North Dakota | 38075 | 364 | 14 |
1797440 | 1797440 | 2021-10-09 | Unknown | Delaware | 364 | 0 | |
1782928 | 1782928 | 2021-10-04 | Towner | North Dakota | 38095 | 364 | 11 |
1779679 | 1779679 | 2021-10-03 | Towner | North Dakota | 38095 | 364 | 11 |
1776429 | 1776429 | 2021-10-02 | Towner | North Dakota | 38095 | 364 | 11 |
1760647 | 1760647 | 2021-09-27 | Sanborn | South Dakota | 46111 | 364 | 3 |
1757399 | 1757399 | 2021-09-26 | Sanborn | South Dakota | 46111 | 364 | 3 |
1754151 | 1754151 | 2021-09-25 | Sanborn | South Dakota | 46111 | 364 | 3 |
1750903 | 1750903 | 2021-09-24 | Sanborn | South Dakota | 46111 | 364 | 3 |
1747654 | 1747654 | 2021-09-23 | Sanborn | South Dakota | 46111 | 364 | 3 |
1728306 | 1728306 | 2021-09-17 | Collingsworth | Texas | 48087 | 364 | 9 |
1721416 | 1721416 | 2021-09-15 | Cameron | Pennsylvania | 42023 | 364 | 10 |
1682025 | 1682025 | 2021-09-03 | Hamilton | New York | 36041 | 364 | 3 |
1682189 | 1682189 | 2021-09-03 | McIntosh | North Dakota | 38051 | 364 | 7 |
1678776 | 1678776 | 2021-09-02 | Hamilton | New York | 36041 | 364 | 3 |
1678940 | 1678940 | 2021-09-02 | McIntosh | North Dakota | 38051 | 364 | 7 |
1673114 | 1673114 | 2021-08-31 | Fisher | Texas | 48151 | 364 | 14 |
1669866 | 1669866 | 2021-08-30 | Fisher | Texas | 48151 | 364 | 14 |
1666619 | 1666619 | 2021-08-29 | Fisher | Texas | 48151 | 364 | 14 |
1663371 | 1663371 | 2021-08-28 | Fisher | Texas | 48151 | 364 | 14 |
1653942 | 1653942 | 2021-08-25 | Norton city | Virginia | 51720 | 364 | 7 |
1643702 | 1643702 | 2021-08-22 | Stanley | South Dakota | 46117 | 364 | 2 |
1640452 | 1640452 | 2021-08-21 | Stanley | South Dakota | 46117 | 364 | 2 |
1637202 | 1637202 | 2021-08-20 | Stanley | South Dakota | 46117 | 364 | 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);