ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,078 rows where cases = 149 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 112
- Nebraska 85
- Virginia 52
- Kentucky 45
- Montana 45
- North Dakota 42
- Georgia 41
- South Dakota 41
- Michigan 37
- Iowa 34
- Puerto Rico 34
- Minnesota 33
- Kansas 31
- Missouri 31
- North Carolina 31
- Illinois 28
- West Virginia 28
- Indiana 24
- Tennessee 20
- Arkansas 19
- Wisconsin 18
- Alabama 17
- Idaho 16
- Ohio 16
- Colorado 15
- New York 15
- Mississippi 14
- Oregon 14
- Pennsylvania 14
- Wyoming 14
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491531 | 2491531 | 2022-05-10 | Logan | Nebraska | 31113 | 149 | 0 |
2488273 | 2488273 | 2022-05-09 | Logan | Nebraska | 31113 | 149 | 0 |
2485016 | 2485016 | 2022-05-08 | Logan | Nebraska | 31113 | 149 | 0 |
2481758 | 2481758 | 2022-05-07 | Logan | Nebraska | 31113 | 149 | 0 |
2478500 | 2478500 | 2022-05-06 | Logan | Nebraska | 31113 | 149 | 0 |
2475242 | 2475242 | 2022-05-05 | Logan | Nebraska | 31113 | 149 | 0 |
2471985 | 2471985 | 2022-05-04 | Logan | Nebraska | 31113 | 149 | 0 |
2468729 | 2468729 | 2022-05-03 | Logan | Nebraska | 31113 | 149 | 0 |
2465473 | 2465473 | 2022-05-02 | Logan | Nebraska | 31113 | 149 | 0 |
2462218 | 2462218 | 2022-05-01 | Logan | Nebraska | 31113 | 149 | 0 |
2458962 | 2458962 | 2022-04-30 | Logan | Nebraska | 31113 | 149 | 0 |
2455706 | 2455706 | 2022-04-29 | Logan | Nebraska | 31113 | 149 | 0 |
2452450 | 2452450 | 2022-04-28 | Logan | Nebraska | 31113 | 149 | 0 |
2449194 | 2449194 | 2022-04-27 | Logan | Nebraska | 31113 | 149 | 0 |
2445937 | 2445937 | 2022-04-26 | Logan | Nebraska | 31113 | 149 | 0 |
2426163 | 2426163 | 2022-04-20 | Unknown | Mississippi | 149 | 8 | |
2291835 | 2291835 | 2022-03-10 | Camas | Idaho | 16025 | 149 | 2 |
2288583 | 2288583 | 2022-03-09 | Camas | Idaho | 16025 | 149 | 2 |
2257126 | 2257126 | 2022-02-27 | Golden Valley | Montana | 30037 | 149 | 5 |
2253875 | 2253875 | 2022-02-26 | Golden Valley | Montana | 30037 | 149 | 5 |
2250624 | 2250624 | 2022-02-25 | Golden Valley | Montana | 30037 | 149 | 5 |
2247373 | 2247373 | 2022-02-24 | Golden Valley | Montana | 30037 | 149 | 5 |
2244122 | 2244122 | 2022-02-23 | Golden Valley | Montana | 30037 | 149 | 5 |
2240871 | 2240871 | 2022-02-22 | Golden Valley | Montana | 30037 | 149 | 5 |
2237620 | 2237620 | 2022-02-21 | Golden Valley | Montana | 30037 | 149 | 5 |
2234369 | 2234369 | 2022-02-20 | Golden Valley | Montana | 30037 | 149 | 5 |
2231118 | 2231118 | 2022-02-19 | Golden Valley | Montana | 30037 | 149 | 5 |
2227867 | 2227867 | 2022-02-18 | Golden Valley | Montana | 30037 | 149 | 5 |
2224616 | 2224616 | 2022-02-17 | Golden Valley | Montana | 30037 | 149 | 5 |
2221365 | 2221365 | 2022-02-16 | Golden Valley | Montana | 30037 | 149 | 5 |
2218114 | 2218114 | 2022-02-15 | Golden Valley | Montana | 30037 | 149 | 5 |
2214863 | 2214863 | 2022-02-14 | Golden Valley | Montana | 30037 | 149 | 5 |
2206250 | 2206250 | 2022-02-11 | Loving | Texas | 48301 | 149 | 0 |
2203105 | 2203105 | 2022-02-10 | Daggett | Utah | 49009 | 149 | 0 |
2199851 | 2199851 | 2022-02-09 | Daggett | Utah | 49009 | 149 | 0 |
2160714 | 2160714 | 2022-01-28 | McMullen | Texas | 48311 | 149 | 8 |
2124959 | 2124959 | 2022-01-17 | Roberts | Texas | 48393 | 149 | 1 |
2121707 | 2121707 | 2022-01-16 | Roberts | Texas | 48393 | 149 | 1 |
2036863 | 2036863 | 2021-12-21 | Jones | South Dakota | 46075 | 149 | 1 |
2033613 | 2033613 | 2021-12-20 | Jones | South Dakota | 46075 | 149 | 1 |
2030363 | 2030363 | 2021-12-19 | Jones | South Dakota | 46075 | 149 | 1 |
2030620 | 2030620 | 2021-12-19 | Kent | Texas | 48263 | 149 | 3 |
2027112 | 2027112 | 2021-12-18 | Jones | South Dakota | 46075 | 149 | 1 |
2027369 | 2027369 | 2021-12-18 | Kent | Texas | 48263 | 149 | 3 |
2023861 | 2023861 | 2021-12-17 | Jones | South Dakota | 46075 | 149 | 1 |
2020610 | 2020610 | 2021-12-16 | Jones | South Dakota | 46075 | 149 | 1 |
2017359 | 2017359 | 2021-12-15 | Jones | South Dakota | 46075 | 149 | 1 |
1995639 | 1995639 | 2021-12-09 | Mineral | Colorado | 8079 | 149 | 1 |
1992388 | 1992388 | 2021-12-08 | Mineral | Colorado | 8079 | 149 | 1 |
1868693 | 1868693 | 2021-10-31 | Wrangell City and Borough | Alaska | 2275 | 149 | 0 |
1865444 | 1865444 | 2021-10-30 | Wrangell City and Borough | Alaska | 2275 | 149 | 0 |
1862195 | 1862195 | 2021-10-29 | Wrangell City and Borough | Alaska | 2275 | 149 | 0 |
1828600 | 1828600 | 2021-10-18 | Gilliam | Oregon | 41021 | 149 | 4 |
1805312 | 1805312 | 2021-10-11 | Deuel | Nebraska | 31049 | 149 | 2 |
1805322 | 1805322 | 2021-10-11 | Garden | Nebraska | 31069 | 149 | 1 |
1802063 | 1802063 | 2021-10-10 | Deuel | Nebraska | 31049 | 149 | 2 |
1802073 | 1802073 | 2021-10-10 | Garden | Nebraska | 31069 | 149 | 1 |
1798814 | 1798814 | 2021-10-09 | Deuel | Nebraska | 31049 | 149 | 2 |
1798824 | 1798824 | 2021-10-09 | Garden | Nebraska | 31069 | 149 | 1 |
1795565 | 1795565 | 2021-10-08 | Deuel | Nebraska | 31049 | 149 | 2 |
1795575 | 1795575 | 2021-10-08 | Garden | Nebraska | 31069 | 149 | 1 |
1793117 | 1793117 | 2021-10-07 | Hyde | South Dakota | 46069 | 149 | 1 |
1789868 | 1789868 | 2021-10-06 | Hyde | South Dakota | 46069 | 149 | 1 |
1790169 | 1790169 | 2021-10-06 | Motley | Texas | 48345 | 149 | 8 |
1786835 | 1786835 | 2021-10-05 | Glasscock | Texas | 48173 | 149 | 3 |
1786921 | 1786921 | 2021-10-05 | Motley | Texas | 48345 | 149 | 8 |
1782646 | 1782646 | 2021-10-04 | Eureka | Nevada | 32011 | 149 | 0 |
1783586 | 1783586 | 2021-10-04 | Glasscock | Texas | 48173 | 149 | 3 |
1767521 | 1767521 | 2021-09-29 | Piute | Utah | 49031 | 149 | 2 |
1763047 | 1763047 | 2021-09-28 | Wibaux | Montana | 30109 | 149 | 7 |
1741109 | 1741109 | 2021-09-21 | Campbell | South Dakota | 46021 | 149 | 4 |
1737909 | 1737909 | 2021-09-20 | Sully | South Dakota | 46119 | 149 | 3 |
1734659 | 1734659 | 2021-09-19 | Sully | South Dakota | 46119 | 149 | 3 |
1731409 | 1731409 | 2021-09-18 | Sully | South Dakota | 46119 | 149 | 3 |
1728159 | 1728159 | 2021-09-17 | Sully | South Dakota | 46119 | 149 | 3 |
1724910 | 1724910 | 2021-09-16 | Sully | South Dakota | 46119 | 149 | 3 |
1721661 | 1721661 | 2021-09-15 | Sully | South Dakota | 46119 | 149 | 3 |
1722127 | 1722127 | 2021-09-15 | Highland | Virginia | 51091 | 149 | 1 |
1710346 | 1710346 | 2021-09-12 | Lane | Kansas | 20101 | 149 | 7 |
1707099 | 1707099 | 2021-09-11 | Lane | Kansas | 20101 | 149 | 7 |
1703851 | 1703851 | 2021-09-10 | Lane | Kansas | 20101 | 149 | 7 |
1679749 | 1679749 | 2021-09-02 | Sterling | Texas | 48431 | 149 | 5 |
1670676 | 1670676 | 2021-08-31 | Dolores | Colorado | 8033 | 149 | 1 |
1664441 | 1664441 | 2021-08-29 | Taliaferro | Georgia | 13265 | 149 | 3 |
1661193 | 1661193 | 2021-08-28 | Taliaferro | Georgia | 13265 | 149 | 3 |
1657945 | 1657945 | 2021-08-27 | Taliaferro | Georgia | 13265 | 149 | 3 |
1656695 | 1656695 | 2021-08-26 | Sully | South Dakota | 46119 | 149 | 3 |
1653448 | 1653448 | 2021-08-25 | Sully | South Dakota | 46119 | 149 | 3 |
1650201 | 1650201 | 2021-08-24 | Sully | South Dakota | 46119 | 149 | 3 |
1634504 | 1634504 | 2021-08-19 | Garfield | Washington | 53023 | 149 | 6 |
1631256 | 1631256 | 2021-08-18 | Garfield | Washington | 53023 | 149 | 6 |
1566283 | 1566283 | 2021-07-29 | Columbia | Washington | 53013 | 149 | 6 |
1509714 | 1509714 | 2021-07-12 | Frontier | Nebraska | 31063 | 149 | 1 |
1506468 | 1506468 | 2021-07-11 | Frontier | Nebraska | 31063 | 149 | 1 |
1503222 | 1503222 | 2021-07-10 | Frontier | Nebraska | 31063 | 149 | 1 |
1499976 | 1499976 | 2021-07-09 | Frontier | Nebraska | 31063 | 149 | 1 |
1496730 | 1496730 | 2021-07-08 | Frontier | Nebraska | 31063 | 149 | 1 |
1492326 | 1492326 | 2021-07-07 | Webster | Georgia | 13307 | 149 | 4 |
1493483 | 1493483 | 2021-07-07 | Frontier | Nebraska | 31063 | 149 | 1 |
1490236 | 1490236 | 2021-07-06 | Frontier | Nebraska | 31063 | 149 | 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);