ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where cases = 4941 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 10
- North Carolina 6
- Montana 5
- Ohio 5
- Wisconsin 5
- Arkansas 4
- Georgia 4
- Illinois 4
- Kentucky 4
- Nebraska 4
- New Mexico 4
- Texas 4
- Utah 4
- Indiana 3
- Minnesota 3
- Pennsylvania 3
- California 2
- Colorado 2
- Florida 2
- Idaho 2
- Iowa 2
- Mississippi 2
- Missouri 2
- New York 2
- North Dakota 2
- Puerto Rico 2
- Tennessee 2
- Alabama 1
- Alaska 1
- Louisiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427596 | 2427596 | 2022-04-20 | Orange | Vermont | 50017 | 4941 | 14 |
2312669 | 2312669 | 2022-03-16 | Schoharie | New York | 36095 | 4941 | 34 |
2306618 | 2306618 | 2022-03-14 | Cabo Rojo | Puerto Rico | 72023 | 4941 | |
2303367 | 2303367 | 2022-03-13 | Cabo Rojo | Puerto Rico | 72023 | 4941 | |
2279873 | 2279873 | 2022-03-06 | Big Horn | Montana | 30003 | 4941 | 92 |
2276620 | 2276620 | 2022-03-05 | Big Horn | Montana | 30003 | 4941 | 92 |
2273367 | 2273367 | 2022-03-04 | Big Horn | Montana | 30003 | 4941 | 92 |
2258486 | 2258486 | 2022-02-27 | King George | Virginia | 51099 | 4941 | 35 |
2255235 | 2255235 | 2022-02-26 | King George | Virginia | 51099 | 4941 | 35 |
2251984 | 2251984 | 2022-02-25 | King George | Virginia | 51099 | 4941 | 35 |
2248733 | 2248733 | 2022-02-24 | King George | Virginia | 51099 | 4941 | 35 |
2238821 | 2238821 | 2022-02-21 | Scurry | Texas | 48415 | 4941 | 100 |
2200146 | 2200146 | 2022-02-09 | Green Lake | Wisconsin | 55047 | 4941 | 59 |
2187768 | 2187768 | 2022-02-06 | Blaine | Idaho | 16013 | 4941 | 29 |
2184515 | 2184515 | 2022-02-05 | Blaine | Idaho | 16013 | 4941 | 29 |
2167493 | 2167493 | 2022-01-30 | Waynesboro city | Virginia | 51820 | 4941 | 55 |
2164238 | 2164238 | 2022-01-29 | Waynesboro city | Virginia | 51820 | 4941 | 55 |
2160983 | 2160983 | 2022-01-28 | Waynesboro city | Virginia | 51820 | 4941 | 55 |
2156771 | 2156771 | 2022-01-27 | Holmes | Ohio | 39075 | 4941 | 167 |
2157424 | 2157424 | 2022-01-27 | Karnes | Texas | 48255 | 4941 | 60 |
2147547 | 2147547 | 2022-01-24 | Austin | Texas | 48015 | 4941 | 60 |
2143569 | 2143569 | 2022-01-23 | Ashe | North Carolina | 37009 | 4941 | 62 |
2140314 | 2140314 | 2022-01-22 | Ashe | North Carolina | 37009 | 4941 | 62 |
2137058 | 2137058 | 2022-01-21 | Ashe | North Carolina | 37009 | 4941 | 62 |
2132006 | 2132006 | 2022-01-20 | Arkansas | Arkansas | 5001 | 4941 | 67 |
2120567 | 2120567 | 2022-01-16 | Cass | Nebraska | 31025 | 4941 | 31 |
2117315 | 2117315 | 2022-01-15 | Cass | Nebraska | 31025 | 4941 | 31 |
2114064 | 2114064 | 2022-01-14 | Cass | Nebraska | 31025 | 4941 | 31 |
2099877 | 2099877 | 2022-01-10 | Peach | Georgia | 13225 | 4941 | 115 |
2014668 | 2014668 | 2021-12-14 | Wythe | Virginia | 51197 | 4941 | 114 |
2010175 | 2010175 | 2021-12-13 | Cibola | New Mexico | 35006 | 4941 | 153 |
1996798 | 1996798 | 2021-12-09 | Itawamba | Mississippi | 28057 | 4941 | 107 |
1974006 | 1974006 | 2021-12-02 | Todd | Minnesota | 27153 | 4941 | 43 |
1966648 | 1966648 | 2021-11-30 | White | Georgia | 13311 | 4941 | 132 |
1894510 | 1894510 | 2021-11-07 | Clark | Wisconsin | 55019 | 4941 | 80 |
1891260 | 1891260 | 2021-11-06 | Clark | Wisconsin | 55019 | 4941 | 80 |
1888010 | 1888010 | 2021-11-05 | Clark | Wisconsin | 55019 | 4941 | 80 |
1881389 | 1881389 | 2021-11-03 | Smyth | Virginia | 51173 | 4941 | 119 |
1875265 | 1875265 | 2021-11-02 | Poinsett | Arkansas | 5111 | 4941 | 100 |
1870437 | 1870437 | 2021-10-31 | Rio Arriba | New Mexico | 35039 | 4941 | 85 |
1867188 | 1867188 | 2021-10-30 | Rio Arriba | New Mexico | 35039 | 4941 | 85 |
1863939 | 1863939 | 2021-10-29 | Rio Arriba | New Mexico | 35039 | 4941 | 85 |
1856956 | 1856956 | 2021-10-27 | Freeborn | Minnesota | 27047 | 4941 | 42 |
1857728 | 1857728 | 2021-10-27 | Ottawa | Ohio | 39123 | 4941 | 86 |
1849776 | 1849776 | 2021-10-25 | Montgomery | Illinois | 17135 | 4941 | 89 |
1789497 | 1789497 | 2021-10-06 | Perry | Ohio | 39127 | 4941 | 56 |
1771121 | 1771121 | 2021-09-30 | Teton | Wyoming | 56039 | 4941 | 13 |
1761027 | 1761027 | 2021-09-27 | Sanpete | Utah | 49039 | 4941 | 30 |
1757779 | 1757779 | 2021-09-26 | Sanpete | Utah | 49039 | 4941 | 30 |
1754531 | 1754531 | 2021-09-25 | Sanpete | Utah | 49039 | 4941 | 30 |
1751283 | 1751283 | 2021-09-24 | Sanpete | Utah | 49039 | 4941 | 30 |
1745205 | 1745205 | 2021-09-23 | Bethel Census Area | Alaska | 2050 | 4941 | 23 |
1742898 | 1742898 | 2021-09-22 | Boyle | Kentucky | 21021 | 4941 | 80 |
1741214 | 1741214 | 2021-09-21 | Lauderdale | Tennessee | 47097 | 4941 | 55 |
1737965 | 1737965 | 2021-09-20 | Lauderdale | Tennessee | 47097 | 4941 | 55 |
1730471 | 1730471 | 2021-09-18 | Polk | Missouri | 29167 | 4941 | 52 |
1719810 | 1719810 | 2021-09-15 | Morgan | Illinois | 17137 | 4941 | 117 |
1697201 | 1697201 | 2021-09-08 | Whitley | Indiana | 18183 | 4941 | 48 |
1651644 | 1651644 | 2021-08-25 | Clinton | Indiana | 18023 | 4941 | 64 |
1649949 | 1649949 | 2021-08-24 | Bedford | Pennsylvania | 42009 | 4941 | 144 |
1622108 | 1622108 | 2021-08-16 | Chattahoochee | Georgia | 13053 | 4941 | 17 |
1624886 | 1624886 | 2021-08-16 | Monroe | Wisconsin | 55081 | 4941 | 51 |
1613529 | 1613529 | 2021-08-13 | Platte | Missouri | 29165 | 4941 | 53 |
1602212 | 1602212 | 2021-08-10 | Chilton | Alabama | 1021 | 4941 | 117 |
1601089 | 1601089 | 2021-08-09 | Shelby | Ohio | 39149 | 4941 | 98 |
1596710 | 1596710 | 2021-08-08 | Barren | Kentucky | 21009 | 4941 | 106 |
1593461 | 1593461 | 2021-08-07 | Barren | Kentucky | 21009 | 4941 | 106 |
1590212 | 1590212 | 2021-08-06 | Barren | Kentucky | 21009 | 4941 | 106 |
1565463 | 1565463 | 2021-07-29 | Klamath | Oregon | 41035 | 4941 | 79 |
1557375 | 1557375 | 2021-07-27 | Livingston | Illinois | 17105 | 4941 | 105 |
1506717 | 1506717 | 2021-07-11 | Hoke | North Carolina | 37093 | 4941 | 56 |
1503471 | 1503471 | 2021-07-10 | Hoke | North Carolina | 37093 | 4941 | 56 |
1500225 | 1500225 | 2021-07-09 | Hoke | North Carolina | 37093 | 4941 | 56 |
1497679 | 1497679 | 2021-07-08 | Burnet | Texas | 48053 | 4941 | 67 |
1332537 | 1332537 | 2021-05-18 | Washington | Virginia | 51191 | 4941 | 110 |
1292224 | 1292224 | 2021-05-06 | Dodge | Nebraska | 31053 | 4941 | 60 |
1284532 | 1284532 | 2021-05-04 | Murray | Georgia | 13213 | 4941 | 86 |
1274935 | 1274935 | 2021-05-01 | Jackson | Illinois | 17077 | 4941 | 74 |
1240446 | 1240446 | 2021-04-20 | Herkimer | New York | 36043 | 4941 | 107 |
1161511 | 1161511 | 2021-03-27 | Sioux | Iowa | 19167 | 4941 | 69 |
1134797 | 1134797 | 2021-03-19 | Hot Spring | Arkansas | 5059 | 4941 | 68 |
1131550 | 1131550 | 2021-03-18 | Hot Spring | Arkansas | 5059 | 4941 | 68 |
1106617 | 1106617 | 2021-03-10 | Vermilion | Louisiana | 22113 | 4941 | 109 |
1094717 | 1094717 | 2021-03-06 | Armstrong | Pennsylvania | 42005 | 4941 | 116 |
1078257 | 1078257 | 2021-03-01 | Morton | North Dakota | 38059 | 4941 | 94 |
1075012 | 1075012 | 2021-02-28 | Morton | North Dakota | 38059 | 4941 | 94 |
940129 | 940129 | 2021-01-18 | San Benito | California | 6069 | 4941 | 43 |
937029 | 937029 | 2021-01-17 | Monroe | Florida | 12087 | 4941 | 37 |
919324 | 919324 | 2021-01-11 | Scioto | Ohio | 39145 | 4941 | 52 |
896114 | 896114 | 2021-01-04 | Lewis and Clark | Montana | 30049 | 4941 | 42 |
882944 | 882944 | 2020-12-31 | Lauderdale | Mississippi | 28075 | 4941 | 171 |
866600 | 866600 | 2020-12-26 | Blue Earth | Minnesota | 27013 | 4941 | 28 |
820019 | 820019 | 2020-12-12 | Butte | California | 6007 | 4941 | 67 |
800692 | 800692 | 2020-12-06 | Columbia | Florida | 12023 | 4941 | 99 |
713620 | 713620 | 2020-11-09 | Story | Iowa | 19169 | 4941 | 18 |
639799 | 639799 | 2020-10-17 | Yellowstone | Montana | 30111 | 4941 | 77 |
585331 | 585331 | 2020-09-30 | York | Pennsylvania | 42133 | 4941 | 159 |
578957 | 578957 | 2020-09-28 | Florence | South Carolina | 45041 | 4941 | 190 |
574015 | 574015 | 2020-09-27 | Hamilton | Indiana | 18057 | 4941 | 118 |
502349 | 502349 | 2020-09-05 | Jefferson | Colorado | 8059 | 4941 | 243 |
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);