ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,003 rows where cases = 176 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 85
- Texas 68
- Georgia 59
- Montana 44
- Virginia 42
- Puerto Rico 41
- Kansas 39
- Alaska 37
- Indiana 36
- Minnesota 35
- South Dakota 35
- Michigan 33
- Missouri 32
- Colorado 28
- New York 28
- Illinois 27
- Ohio 24
- Iowa 23
- Kentucky 23
- North Carolina 19
- Pennsylvania 19
- Alabama 18
- West Virginia 18
- California 17
- Washington 17
- Mississippi 13
- North Dakota 13
- Arkansas 12
- Louisiana 12
- Oklahoma 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491549 | 2491549 | 2022-05-10 | Rock | Nebraska | 31149 | 176 | 2 |
2488291 | 2488291 | 2022-05-09 | Rock | Nebraska | 31149 | 176 | 2 |
2485034 | 2485034 | 2022-05-08 | Rock | Nebraska | 31149 | 176 | 2 |
2481776 | 2481776 | 2022-05-07 | Rock | Nebraska | 31149 | 176 | 2 |
2478518 | 2478518 | 2022-05-06 | Rock | Nebraska | 31149 | 176 | 2 |
2475260 | 2475260 | 2022-05-05 | Rock | Nebraska | 31149 | 176 | 2 |
2472003 | 2472003 | 2022-05-04 | Rock | Nebraska | 31149 | 176 | 2 |
2468747 | 2468747 | 2022-05-03 | Rock | Nebraska | 31149 | 176 | 2 |
2465491 | 2465491 | 2022-05-02 | Rock | Nebraska | 31149 | 176 | 2 |
2462236 | 2462236 | 2022-05-01 | Rock | Nebraska | 31149 | 176 | 2 |
2458980 | 2458980 | 2022-04-30 | Rock | Nebraska | 31149 | 176 | 2 |
2455724 | 2455724 | 2022-04-29 | Rock | Nebraska | 31149 | 176 | 2 |
2452468 | 2452468 | 2022-04-28 | Rock | Nebraska | 31149 | 176 | 2 |
2449212 | 2449212 | 2022-04-27 | Rock | Nebraska | 31149 | 176 | 2 |
2445955 | 2445955 | 2022-04-26 | Rock | Nebraska | 31149 | 176 | 2 |
2442700 | 2442700 | 2022-04-25 | Rock | Nebraska | 31149 | 176 | 2 |
2427035 | 2427035 | 2022-04-20 | Culebra | Puerto Rico | 72049 | 176 | |
2267748 | 2267748 | 2022-03-02 | Jones | South Dakota | 46075 | 176 | 2 |
2264495 | 2264495 | 2022-03-01 | Jones | South Dakota | 46075 | 176 | 2 |
2261245 | 2261245 | 2022-02-28 | Jones | South Dakota | 46075 | 176 | 2 |
2257994 | 2257994 | 2022-02-27 | Jones | South Dakota | 46075 | 176 | 2 |
2254743 | 2254743 | 2022-02-26 | Jones | South Dakota | 46075 | 176 | 2 |
2251492 | 2251492 | 2022-02-25 | Jones | South Dakota | 46075 | 176 | 2 |
2248241 | 2248241 | 2022-02-24 | Jones | South Dakota | 46075 | 176 | 2 |
2244990 | 2244990 | 2022-02-23 | Jones | South Dakota | 46075 | 176 | 2 |
2132196 | 2132196 | 2022-01-20 | San Juan | Colorado | 8111 | 176 | 0 |
2115094 | 2115094 | 2022-01-14 | Glasscock | Texas | 48173 | 176 | 3 |
2059908 | 2059908 | 2021-12-28 | Motley | Texas | 48345 | 176 | 9 |
2056659 | 2056659 | 2021-12-27 | Motley | Texas | 48345 | 176 | 9 |
2053410 | 2053410 | 2021-12-26 | Motley | Texas | 48345 | 176 | 9 |
2050160 | 2050160 | 2021-12-25 | Motley | Texas | 48345 | 176 | 9 |
2046910 | 2046910 | 2021-12-24 | Motley | Texas | 48345 | 176 | 9 |
2043660 | 2043660 | 2021-12-23 | Motley | Texas | 48345 | 176 | 9 |
1984021 | 1984021 | 2021-12-05 | Wibaux | Montana | 30109 | 176 | 8 |
1980771 | 1980771 | 2021-12-04 | Wibaux | Montana | 30109 | 176 | 8 |
1977521 | 1977521 | 2021-12-03 | Wibaux | Montana | 30109 | 176 | 8 |
1974271 | 1974271 | 2021-12-02 | Wibaux | Montana | 30109 | 176 | 8 |
1971022 | 1971022 | 2021-12-01 | Wibaux | Montana | 30109 | 176 | 8 |
1962073 | 1962073 | 2021-11-28 | Campbell | South Dakota | 46021 | 176 | 4 |
1958822 | 1958822 | 2021-11-27 | Campbell | South Dakota | 46021 | 176 | 4 |
1955571 | 1955571 | 2021-11-26 | Campbell | South Dakota | 46021 | 176 | 4 |
1952320 | 1952320 | 2021-11-25 | Campbell | South Dakota | 46021 | 176 | 4 |
1949069 | 1949069 | 2021-11-24 | Campbell | South Dakota | 46021 | 176 | 4 |
1945818 | 1945818 | 2021-11-23 | Campbell | South Dakota | 46021 | 176 | 4 |
1906602 | 1906602 | 2021-11-11 | Sherman | Oregon | 41055 | 176 | 3 |
1903353 | 1903353 | 2021-11-10 | Sherman | Oregon | 41055 | 176 | 3 |
1848844 | 1848844 | 2021-10-24 | Highland | Virginia | 51091 | 176 | 3 |
1845594 | 1845594 | 2021-10-23 | Highland | Virginia | 51091 | 176 | 3 |
1842344 | 1842344 | 2021-10-22 | Highland | Virginia | 51091 | 176 | 3 |
1839095 | 1839095 | 2021-10-21 | Highland | Virginia | 51091 | 176 | 3 |
1823344 | 1823344 | 2021-10-17 | Sierra | California | 6091 | 176 | 0 |
1820095 | 1820095 | 2021-10-16 | Sierra | California | 6091 | 176 | 0 |
1816846 | 1816846 | 2021-10-15 | Sierra | California | 6091 | 176 | 0 |
1754375 | 1754375 | 2021-09-25 | Irion | Texas | 48235 | 176 | 2 |
1751127 | 1751127 | 2021-09-24 | Irion | Texas | 48235 | 176 | 2 |
1746914 | 1746914 | 2021-09-23 | Storey | Nevada | 32029 | 176 | 4 |
1747878 | 1747878 | 2021-09-23 | Irion | Texas | 48235 | 176 | 2 |
1744628 | 1744628 | 2021-09-22 | Irion | Texas | 48235 | 176 | 2 |
1724029 | 1724029 | 2021-09-16 | Liberty | Montana | 30051 | 176 | 1 |
1720784 | 1720784 | 2021-09-15 | Meagher | Montana | 30059 | 176 | 7 |
1699300 | 1699300 | 2021-09-08 | Rich | Utah | 49033 | 176 | 0 |
1696052 | 1696052 | 2021-09-07 | Rich | Utah | 49033 | 176 | 0 |
1696064 | 1696064 | 2021-09-07 | Wayne | Utah | 49055 | 176 | 0 |
1659802 | 1659802 | 2021-08-27 | Maricao | Puerto Rico | 72093 | 176 | |
1656553 | 1656553 | 2021-08-26 | Maricao | Puerto Rico | 72093 | 176 | |
1653306 | 1653306 | 2021-08-25 | Maricao | Puerto Rico | 72093 | 176 | |
1650059 | 1650059 | 2021-08-24 | Maricao | Puerto Rico | 72093 | 176 | |
1646810 | 1646810 | 2021-08-23 | Maricao | Puerto Rico | 72093 | 176 | |
1641725 | 1641725 | 2021-08-22 | Webster | Georgia | 13307 | 176 | 4 |
1638475 | 1638475 | 2021-08-21 | Webster | Georgia | 13307 | 176 | 4 |
1635225 | 1635225 | 2021-08-20 | Webster | Georgia | 13307 | 176 | 4 |
1605297 | 1605297 | 2021-08-10 | Wahkiakum | Washington | 53069 | 176 | 4 |
1600295 | 1600295 | 2021-08-09 | Cook | Minnesota | 27031 | 176 | 0 |
1602047 | 1602047 | 2021-08-09 | Wahkiakum | Washington | 53069 | 176 | 4 |
1602192 | 1602192 | 2021-08-09 | Niobrara | Wyoming | 56027 | 176 | 3 |
1597047 | 1597047 | 2021-08-08 | Cook | Minnesota | 27031 | 176 | 0 |
1593798 | 1593798 | 2021-08-07 | Cook | Minnesota | 27031 | 176 | 0 |
1590549 | 1590549 | 2021-08-06 | Cook | Minnesota | 27031 | 176 | 0 |
1587300 | 1587300 | 2021-08-05 | Cook | Minnesota | 27031 | 176 | 0 |
1584049 | 1584049 | 2021-08-04 | Cook | Minnesota | 27031 | 176 | 0 |
1579965 | 1579965 | 2021-08-03 | Quitman | Georgia | 13239 | 176 | 3 |
1580800 | 1580800 | 2021-08-03 | Cook | Minnesota | 27031 | 176 | 0 |
1576717 | 1576717 | 2021-08-02 | Quitman | Georgia | 13239 | 176 | 3 |
1573469 | 1573469 | 2021-08-01 | Quitman | Georgia | 13239 | 176 | 3 |
1573873 | 1573873 | 2021-08-01 | Comanche | Kansas | 20033 | 176 | 10 |
1570221 | 1570221 | 2021-07-31 | Quitman | Georgia | 13239 | 176 | 3 |
1570625 | 1570625 | 2021-07-31 | Comanche | Kansas | 20033 | 176 | 10 |
1566973 | 1566973 | 2021-07-30 | Quitman | Georgia | 13239 | 176 | 3 |
1567377 | 1567377 | 2021-07-30 | Comanche | Kansas | 20033 | 176 | 10 |
1563725 | 1563725 | 2021-07-29 | Quitman | Georgia | 13239 | 176 | 3 |
1560477 | 1560477 | 2021-07-28 | Quitman | Georgia | 13239 | 176 | 3 |
1557230 | 1557230 | 2021-07-27 | Quitman | Georgia | 13239 | 176 | 3 |
1553983 | 1553983 | 2021-07-26 | Quitman | Georgia | 13239 | 176 | 3 |
1556121 | 1556121 | 2021-07-26 | Briscoe | Texas | 48045 | 176 | 6 |
1550736 | 1550736 | 2021-07-25 | Quitman | Georgia | 13239 | 176 | 3 |
1552874 | 1552874 | 2021-07-25 | Briscoe | Texas | 48045 | 176 | 6 |
1547489 | 1547489 | 2021-07-24 | Quitman | Georgia | 13239 | 176 | 3 |
1549627 | 1549627 | 2021-07-24 | Briscoe | Texas | 48045 | 176 | 6 |
1544242 | 1544242 | 2021-07-23 | Quitman | Georgia | 13239 | 176 | 3 |
1546380 | 1546380 | 2021-07-23 | Briscoe | Texas | 48045 | 176 | 6 |
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);