ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,208 rows where cases = 6 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 947
- Kansas 669
- Nebraska 575
- Missouri 503
- Kentucky 437
- Minnesota 389
- Virginia 371
- Oklahoma 362
- West Virginia 348
- South Dakota 332
- Tennessee 298
- Iowa 286
- Arkansas 284
- North Dakota 282
- Montana 270
- Ohio 270
- Colorado 261
- Illinois 227
- Georgia 220
- Wisconsin 197
- Indiana 193
- Oregon 184
- New Mexico 176
- California 175
- North Carolina 158
- Michigan 156
- Utah 156
- Pennsylvania 130
- Northern Mariana Islands 116
- Vermont 106
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2406338 | 2406338 | 2022-04-14 | Unknown | Maine | 6 | 0 | |
2396572 | 2396572 | 2022-04-11 | Unknown | Maine | 6 | 0 | |
2393317 | 2393317 | 2022-04-10 | Unknown | Maine | 6 | 0 | |
2390061 | 2390061 | 2022-04-09 | Unknown | Maine | 6 | 0 | |
2374436 | 2374436 | 2022-04-04 | Unknown | New Mexico | 6 | 0 | |
2354268 | 2354268 | 2022-03-29 | Unknown | Maine | 6 | 0 | |
2334750 | 2334750 | 2022-03-23 | Unknown | Maine | 6 | 0 | |
2272137 | 2272137 | 2022-03-04 | Unknown | Florida | 6 | 1207 | |
2100576 | 2100576 | 2022-01-10 | Unknown | Maine | 6 | 0 | |
2097325 | 2097325 | 2022-01-09 | Unknown | Maine | 6 | 0 | |
2094073 | 2094073 | 2022-01-08 | Unknown | Maine | 6 | 0 | |
2087570 | 2087570 | 2022-01-06 | Unknown | Maine | 6 | 0 | |
2058311 | 2058311 | 2021-12-28 | Unknown | Maine | 6 | 1 | |
2016059 | 2016059 | 2021-12-15 | Unknown | Maine | 6 | 0 | |
2016920 | 2016920 | 2021-12-15 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
2013670 | 2013670 | 2021-12-14 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
2010419 | 2010419 | 2021-12-13 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
2007168 | 2007168 | 2021-12-12 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
2003917 | 2003917 | 2021-12-11 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
2000666 | 2000666 | 2021-12-10 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1997416 | 1997416 | 2021-12-09 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1994165 | 1994165 | 2021-12-08 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1990914 | 1990914 | 2021-12-07 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1987663 | 1987663 | 2021-12-06 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1984413 | 1984413 | 2021-12-05 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1981163 | 1981163 | 2021-12-04 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1977913 | 1977913 | 2021-12-03 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1974663 | 1974663 | 2021-12-02 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1971414 | 1971414 | 2021-12-01 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1968164 | 1968164 | 2021-11-30 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1964913 | 1964913 | 2021-11-29 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1961661 | 1961661 | 2021-11-28 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1958410 | 1958410 | 2021-11-27 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1955159 | 1955159 | 2021-11-26 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1951908 | 1951908 | 2021-11-25 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1948657 | 1948657 | 2021-11-24 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1945406 | 1945406 | 2021-11-23 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1942155 | 1942155 | 2021-11-22 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1938905 | 1938905 | 2021-11-21 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1935655 | 1935655 | 2021-11-20 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1931544 | 1931544 | 2021-11-19 | Unknown | Maine | 6 | 0 | |
1932405 | 1932405 | 2021-11-19 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1928293 | 1928293 | 2021-11-18 | Unknown | Maine | 6 | 0 | |
1929154 | 1929154 | 2021-11-18 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1925904 | 1925904 | 2021-11-17 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1922655 | 1922655 | 2021-11-16 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1919405 | 1919405 | 2021-11-15 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1916155 | 1916155 | 2021-11-14 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1912905 | 1912905 | 2021-11-13 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1909655 | 1909655 | 2021-11-12 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1906406 | 1906406 | 2021-11-11 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1903157 | 1903157 | 2021-11-10 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1899907 | 1899907 | 2021-11-09 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1896657 | 1896657 | 2021-11-08 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1893407 | 1893407 | 2021-11-07 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1890157 | 1890157 | 2021-11-06 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1886907 | 1886907 | 2021-11-05 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1883658 | 1883658 | 2021-11-04 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1880409 | 1880409 | 2021-11-03 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1877160 | 1877160 | 2021-11-02 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1873911 | 1873911 | 2021-11-01 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1870662 | 1870662 | 2021-10-31 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1867413 | 1867413 | 2021-10-30 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1864164 | 1864164 | 2021-10-29 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1860915 | 1860915 | 2021-10-28 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1857666 | 1857666 | 2021-10-27 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1853556 | 1853556 | 2021-10-26 | Unknown | Maine | 6 | 0 | |
1854417 | 1854417 | 2021-10-26 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1851168 | 1851168 | 2021-10-25 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1847918 | 1847918 | 2021-10-24 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1844668 | 1844668 | 2021-10-23 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1841418 | 1841418 | 2021-10-22 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1838169 | 1838169 | 2021-10-21 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1834920 | 1834920 | 2021-10-20 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1831671 | 1831671 | 2021-10-19 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1828422 | 1828422 | 2021-10-18 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1825173 | 1825173 | 2021-10-17 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1821924 | 1821924 | 2021-10-16 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1818675 | 1818675 | 2021-10-15 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1815426 | 1815426 | 2021-10-14 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1812178 | 1812178 | 2021-10-13 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1808929 | 1808929 | 2021-10-12 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1805678 | 1805678 | 2021-10-11 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1802429 | 1802429 | 2021-10-10 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1799180 | 1799180 | 2021-10-09 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1795931 | 1795931 | 2021-10-08 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1792682 | 1792682 | 2021-10-07 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1789433 | 1789433 | 2021-10-06 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1786185 | 1786185 | 2021-10-05 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1782936 | 1782936 | 2021-10-04 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1779687 | 1779687 | 2021-10-03 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1776437 | 1776437 | 2021-10-02 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1773187 | 1773187 | 2021-10-01 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1769937 | 1769937 | 2021-09-30 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1766688 | 1766688 | 2021-09-29 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1762578 | 1762578 | 2021-09-28 | Unknown | Maine | 6 | 0 | |
1763439 | 1763439 | 2021-09-28 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1760190 | 1760190 | 2021-09-27 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1756942 | 1756942 | 2021-09-26 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
1753694 | 1753694 | 2021-09-25 | Tinian | Northern Mariana Islands | 69120 | 6 | 0 |
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);