ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
835 rows where cases = 327 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 78
- Oklahoma 75
- Texas 51
- Kansas 45
- Virginia 43
- Georgia 40
- Nebraska 38
- Illinois 33
- California 28
- Kentucky 28
- Colorado 27
- South Dakota 24
- North Carolina 23
- Minnesota 19
- Puerto Rico 19
- Michigan 15
- Ohio 14
- Arkansas 13
- Iowa 13
- Louisiana 13
- New York 13
- Indiana 12
- New Mexico 12
- Tennessee 12
- Montana 11
- Oregon 11
- Idaho 10
- Missouri 10
- Washington 10
- Alabama 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2247392 | 2247392 | 2022-02-24 | Powder River | Montana | 30075 | 327 | 10 |
2240890 | 2240890 | 2022-02-22 | Powder River | Montana | 30075 | 327 | 10 |
2237639 | 2237639 | 2022-02-21 | Powder River | Montana | 30075 | 327 | 10 |
2234388 | 2234388 | 2022-02-20 | Powder River | Montana | 30075 | 327 | 10 |
2231137 | 2231137 | 2022-02-19 | Powder River | Montana | 30075 | 327 | 10 |
2227886 | 2227886 | 2022-02-18 | Powder River | Montana | 30075 | 327 | 10 |
2218260 | 2218260 | 2022-02-15 | Storey | Nevada | 32029 | 327 | 9 |
2180344 | 2180344 | 2022-02-03 | Rich | Utah | 49033 | 327 | 0 |
2177039 | 2177039 | 2022-02-02 | Stonewall | Texas | 48433 | 327 | 7 |
2177093 | 2177093 | 2022-02-02 | Rich | Utah | 49033 | 327 | 0 |
2173840 | 2173840 | 2022-02-01 | Rich | Utah | 49033 | 327 | 0 |
2166133 | 2166133 | 2022-01-30 | Dundy | Nebraska | 31057 | 327 | 6 |
2162878 | 2162878 | 2022-01-29 | Dundy | Nebraska | 31057 | 327 | 6 |
2159623 | 2159623 | 2022-01-28 | Dundy | Nebraska | 31057 | 327 | 6 |
2157745 | 2157745 | 2022-01-27 | Garfield | Washington | 53023 | 327 | 7 |
2154492 | 2154492 | 2022-01-26 | Garfield | Washington | 53023 | 327 | 7 |
2130266 | 2130266 | 2022-01-19 | Daniels | Montana | 30019 | 327 | 9 |
2108973 | 2108973 | 2022-01-12 | Wahkiakum | Washington | 53069 | 327 | 5 |
2104305 | 2104305 | 2022-01-11 | Boyd | Nebraska | 31015 | 327 | 5 |
2104333 | 2104333 | 2022-01-11 | Garfield | Nebraska | 31071 | 327 | 2 |
2104336 | 2104336 | 2022-01-11 | Greeley | Nebraska | 31077 | 327 | 2 |
2023992 | 2023992 | 2021-12-17 | Armstrong | Texas | 48011 | 327 | 8 |
2020609 | 2020609 | 2021-12-16 | Jerauld | South Dakota | 46073 | 327 | 19 |
2010375 | 2010375 | 2021-12-13 | Divide | North Dakota | 38023 | 327 | 3 |
2007124 | 2007124 | 2021-12-12 | Divide | North Dakota | 38023 | 327 | 3 |
2003873 | 2003873 | 2021-12-11 | Divide | North Dakota | 38023 | 327 | 3 |
1989848 | 1989848 | 2021-12-07 | Wallace | Kansas | 20199 | 327 | 5 |
1986598 | 1986598 | 2021-12-06 | Wallace | Kansas | 20199 | 327 | 5 |
1983286 | 1983286 | 2021-12-05 | Hamilton | Kansas | 20075 | 327 | 2 |
1980036 | 1980036 | 2021-12-04 | Hamilton | Kansas | 20075 | 327 | 2 |
1976786 | 1976786 | 2021-12-03 | Hamilton | Kansas | 20075 | 327 | 2 |
1967924 | 1967924 | 2021-11-30 | De Baca | New Mexico | 35011 | 327 | 3 |
1921515 | 1921515 | 2021-11-16 | Elk | Kansas | 20049 | 327 | 6 |
1918265 | 1918265 | 2021-11-15 | Elk | Kansas | 20049 | 327 | 6 |
1906046 | 1906046 | 2021-11-11 | Franklin | Nebraska | 31061 | 327 | 7 |
1894040 | 1894040 | 2021-11-07 | Edwards | Texas | 48137 | 327 | 7 |
1890790 | 1890790 | 2021-11-06 | Edwards | Texas | 48137 | 327 | 7 |
1887540 | 1887540 | 2021-11-05 | Edwards | Texas | 48137 | 327 | 7 |
1861343 | 1861343 | 2021-10-28 | Haakon | South Dakota | 46055 | 327 | 11 |
1858094 | 1858094 | 2021-10-27 | Haakon | South Dakota | 46055 | 327 | 11 |
1851136 | 1851136 | 2021-10-25 | Logan | North Dakota | 38047 | 327 | 11 |
1847886 | 1847886 | 2021-10-24 | Logan | North Dakota | 38047 | 327 | 11 |
1844636 | 1844636 | 2021-10-23 | Logan | North Dakota | 38047 | 327 | 11 |
1841386 | 1841386 | 2021-10-22 | Logan | North Dakota | 38047 | 327 | 11 |
1824826 | 1824826 | 2021-10-17 | Hitchcock | Nebraska | 31087 | 327 | 5 |
1821577 | 1821577 | 2021-10-16 | Hitchcock | Nebraska | 31087 | 327 | 5 |
1822778 | 1822778 | 2021-10-16 | Grand Isle | Vermont | 50013 | 327 | 2 |
1818328 | 1818328 | 2021-10-15 | Hitchcock | Nebraska | 31087 | 327 | 5 |
1807773 | 1807773 | 2021-10-12 | Chase | Kansas | 20017 | 327 | 4 |
1807784 | 1807784 | 2021-10-12 | Decatur | Kansas | 20039 | 327 | 13 |
1807970 | 1807970 | 2021-10-12 | Robertson | Kentucky | 21201 | 327 | 16 |
1804522 | 1804522 | 2021-10-11 | Chase | Kansas | 20017 | 327 | 4 |
1804533 | 1804533 | 2021-10-11 | Decatur | Kansas | 20039 | 327 | 13 |
1804719 | 1804719 | 2021-10-11 | Robertson | Kentucky | 21201 | 327 | 16 |
1805450 | 1805450 | 2021-10-11 | Mora | New Mexico | 35033 | 327 | 10 |
1801284 | 1801284 | 2021-10-10 | Decatur | Kansas | 20039 | 327 | 13 |
1802201 | 1802201 | 2021-10-10 | Mora | New Mexico | 35033 | 327 | 10 |
1798035 | 1798035 | 2021-10-09 | Decatur | Kansas | 20039 | 327 | 13 |
1798952 | 1798952 | 2021-10-09 | Mora | New Mexico | 35033 | 327 | 10 |
1794786 | 1794786 | 2021-10-08 | Decatur | Kansas | 20039 | 327 | 13 |
1795703 | 1795703 | 2021-10-08 | Mora | New Mexico | 35033 | 327 | 10 |
1783385 | 1783385 | 2021-10-04 | Miner | South Dakota | 46097 | 327 | 11 |
1779327 | 1779327 | 2021-10-03 | Frontier | Nebraska | 31063 | 327 | 1 |
1776077 | 1776077 | 2021-10-02 | Frontier | Nebraska | 31063 | 327 | 1 |
1772827 | 1772827 | 2021-10-01 | Frontier | Nebraska | 31063 | 327 | 1 |
1751189 | 1751189 | 2021-09-24 | Oldham | Texas | 48359 | 327 | 5 |
1747940 | 1747940 | 2021-09-23 | Oldham | Texas | 48359 | 327 | 4 |
1744690 | 1744690 | 2021-09-22 | Oldham | Texas | 48359 | 327 | 4 |
1740643 | 1740643 | 2021-09-21 | Adams | North Dakota | 38001 | 327 | 3 |
1702590 | 1702590 | 2021-09-09 | Bath | Virginia | 51017 | 327 | 11 |
1692822 | 1692822 | 2021-09-06 | Essex | Vermont | 50009 | 327 | 2 |
1670683 | 1670683 | 2021-08-31 | Gilpin | Colorado | 8047 | 327 | 3 |
1667436 | 1667436 | 2021-08-30 | Gilpin | Colorado | 8047 | 327 | 3 |
1667561 | 1667561 | 2021-08-30 | Baker | Georgia | 13007 | 327 | 11 |
1664189 | 1664189 | 2021-08-29 | Gilpin | Colorado | 8047 | 327 | 3 |
1660941 | 1660941 | 2021-08-28 | Gilpin | Colorado | 8047 | 327 | 3 |
1657693 | 1657693 | 2021-08-27 | Gilpin | Colorado | 8047 | 327 | 3 |
1643458 | 1643458 | 2021-08-22 | Cameron | Pennsylvania | 42023 | 327 | 10 |
1640208 | 1640208 | 2021-08-21 | Cameron | Pennsylvania | 42023 | 327 | 10 |
1633058 | 1633058 | 2021-08-19 | Fallon | Montana | 30025 | 327 | 3 |
1633692 | 1633692 | 2021-08-19 | Wallowa | Oregon | 41063 | 327 | 6 |
1625391 | 1625391 | 2021-08-17 | Glascock | Georgia | 13125 | 327 | 19 |
1613990 | 1613990 | 2021-08-13 | Renville | North Dakota | 38075 | 327 | 14 |
1608991 | 1608991 | 2021-08-12 | Ouray | Colorado | 8091 | 327 | 5 |
1610741 | 1610741 | 2021-08-12 | Renville | North Dakota | 38075 | 327 | 14 |
1610751 | 1610751 | 2021-08-12 | Towner | North Dakota | 38095 | 327 | 11 |
1607503 | 1607503 | 2021-08-11 | Towner | North Dakota | 38095 | 327 | 11 |
1604254 | 1604254 | 2021-08-10 | Towner | North Dakota | 38095 | 327 | 11 |
1601005 | 1601005 | 2021-08-09 | Towner | North Dakota | 38095 | 327 | 11 |
1597571 | 1597571 | 2021-08-08 | Hamilton | New York | 36041 | 327 | 2 |
1597757 | 1597757 | 2021-08-08 | Towner | North Dakota | 38095 | 327 | 11 |
1598720 | 1598720 | 2021-08-08 | Norton city | Virginia | 51720 | 327 | 7 |
1594322 | 1594322 | 2021-08-07 | Hamilton | New York | 36041 | 327 | 2 |
1594508 | 1594508 | 2021-08-07 | Towner | North Dakota | 38095 | 327 | 11 |
1595471 | 1595471 | 2021-08-07 | Norton city | Virginia | 51720 | 327 | 7 |
1591259 | 1591259 | 2021-08-06 | Towner | North Dakota | 38095 | 327 | 11 |
1592222 | 1592222 | 2021-08-06 | Norton city | Virginia | 51720 | 327 | 7 |
1588010 | 1588010 | 2021-08-05 | Towner | North Dakota | 38095 | 327 | 11 |
1584760 | 1584760 | 2021-08-04 | Towner | North Dakota | 38095 | 327 | 11 |
1581510 | 1581510 | 2021-08-03 | Towner | North Dakota | 38095 | 327 | 11 |
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);