ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
432 rows where cases = 1086 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 28
- Missouri 27
- Mississippi 25
- Virginia 23
- Texas 22
- Kentucky 19
- Puerto Rico 19
- New Mexico 18
- Illinois 15
- Montana 14
- Georgia 13
- Oregon 13
- Florida 12
- Oklahoma 12
- Vermont 12
- Idaho 11
- Michigan 11
- Wisconsin 11
- Colorado 10
- Minnesota 9
- Arkansas 8
- Indiana 8
- Kansas 7
- Louisiana 7
- North Dakota 7
- Maine 6
- New York 6
- North Carolina 6
- Ohio 6
- Tennessee 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473435 | 2473435 | 2022-05-04 | Florence | Wisconsin | 55037 | 1086 | 16 |
2470178 | 2470178 | 2022-05-03 | Florence | Wisconsin | 55037 | 1086 | 16 |
2466922 | 2466922 | 2022-05-02 | Florence | Wisconsin | 55037 | 1086 | 16 |
2463667 | 2463667 | 2022-05-01 | Florence | Wisconsin | 55037 | 1086 | 16 |
2460411 | 2460411 | 2022-04-30 | Florence | Wisconsin | 55037 | 1086 | 16 |
2457155 | 2457155 | 2022-04-29 | Florence | Wisconsin | 55037 | 1086 | 16 |
2453899 | 2453899 | 2022-04-28 | Florence | Wisconsin | 55037 | 1086 | 16 |
2378892 | 2378892 | 2022-04-05 | Surry | Virginia | 51181 | 1086 | 19 |
2375638 | 2375638 | 2022-04-04 | Surry | Virginia | 51181 | 1086 | 19 |
2372386 | 2372386 | 2022-04-03 | Surry | Virginia | 51181 | 1086 | 19 |
2369133 | 2369133 | 2022-04-02 | Surry | Virginia | 51181 | 1086 | 19 |
2365880 | 2365880 | 2022-04-01 | Surry | Virginia | 51181 | 1086 | 19 |
2361221 | 2361221 | 2022-03-31 | Mineral | Montana | 30061 | 1086 | 17 |
2362627 | 2362627 | 2022-03-31 | Surry | Virginia | 51181 | 1086 | 19 |
2357967 | 2357967 | 2022-03-30 | Mineral | Montana | 30061 | 1086 | 17 |
2358150 | 2358150 | 2022-03-30 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2359373 | 2359373 | 2022-03-30 | Surry | Virginia | 51181 | 1086 | 19 |
2354714 | 2354714 | 2022-03-29 | Mineral | Montana | 30061 | 1086 | 17 |
2354897 | 2354897 | 2022-03-29 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2351644 | 2351644 | 2022-03-28 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2348392 | 2348392 | 2022-03-27 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2345139 | 2345139 | 2022-03-26 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2341886 | 2341886 | 2022-03-25 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2338633 | 2338633 | 2022-03-24 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2335379 | 2335379 | 2022-03-23 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2332125 | 2332125 | 2022-03-22 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2328872 | 2328872 | 2022-03-21 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2325620 | 2325620 | 2022-03-20 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2322366 | 2322366 | 2022-03-19 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2319112 | 2319112 | 2022-03-18 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2315859 | 2315859 | 2022-03-17 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2312606 | 2312606 | 2022-03-16 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2308113 | 2308113 | 2022-03-15 | Lincoln | Idaho | 16063 | 1086 | 15 |
2309353 | 2309353 | 2022-03-15 | Hidalgo | New Mexico | 35023 | 1086 | 14 |
2263671 | 2263671 | 2022-03-01 | Boone | Nebraska | 31011 | 1086 | 4 |
2238902 | 2238902 | 2022-02-21 | Essex | Vermont | 50009 | 1086 | 3 |
2235651 | 2235651 | 2022-02-20 | Essex | Vermont | 50009 | 1086 | 3 |
2232400 | 2232400 | 2022-02-19 | Essex | Vermont | 50009 | 1086 | 3 |
2229149 | 2229149 | 2022-02-18 | Essex | Vermont | 50009 | 1086 | 3 |
2225898 | 2225898 | 2022-02-17 | Essex | Vermont | 50009 | 1086 | 3 |
2222647 | 2222647 | 2022-02-16 | Essex | Vermont | 50009 | 1086 | 3 |
2222690 | 2222690 | 2022-02-16 | Craig | Virginia | 51045 | 1086 | 13 |
2215962 | 2215962 | 2022-02-14 | Hemphill | Texas | 48211 | 1086 | 5 |
2212711 | 2212711 | 2022-02-13 | Hemphill | Texas | 48211 | 1086 | 5 |
2209458 | 2209458 | 2022-02-12 | Hemphill | Texas | 48211 | 1086 | 5 |
2182288 | 2182288 | 2022-02-04 | Reynolds | Missouri | 29179 | 1086 | 20 |
2173656 | 2173656 | 2022-02-01 | Goliad | Texas | 48175 | 1086 | 29 |
2163963 | 2163963 | 2022-01-29 | Martin | Texas | 48317 | 1086 | 24 |
2139903 | 2139903 | 2022-01-22 | Atchison | Missouri | 29005 | 1086 | 19 |
2133513 | 2133513 | 2022-01-20 | Broadwater | Montana | 30007 | 1086 | 18 |
2133848 | 2133848 | 2022-01-20 | Hyde | North Carolina | 37095 | 1086 | 13 |
2122822 | 2122822 | 2022-01-17 | Scott | Illinois | 17171 | 1086 | 9 |
2119157 | 2119157 | 2022-01-16 | Huerfano | Colorado | 8055 | 1086 | 28 |
2119570 | 2119570 | 2022-01-16 | Scott | Illinois | 17171 | 1086 | 9 |
2115905 | 2115905 | 2022-01-15 | Huerfano | Colorado | 8055 | 1086 | 28 |
2116318 | 2116318 | 2022-01-15 | Scott | Illinois | 17171 | 1086 | 9 |
2112654 | 2112654 | 2022-01-14 | Huerfano | Colorado | 8055 | 1086 | 28 |
2113067 | 2113067 | 2022-01-14 | Scott | Illinois | 17171 | 1086 | 9 |
2115160 | 2115160 | 2022-01-14 | Lynn | Texas | 48305 | 1086 | 29 |
2097572 | 2097572 | 2022-01-09 | Jefferson | Mississippi | 28063 | 1086 | 35 |
2094320 | 2094320 | 2022-01-08 | Jefferson | Mississippi | 28063 | 1086 | 35 |
2091068 | 2091068 | 2022-01-07 | Jefferson | Mississippi | 28063 | 1086 | 35 |
2079358 | 2079358 | 2022-01-03 | Jack | Texas | 48237 | 1086 | 22 |
2058195 | 2058195 | 2021-12-28 | Menifee | Kentucky | 21165 | 1086 | 26 |
2029215 | 2029215 | 2021-12-19 | Grant | Minnesota | 27051 | 1086 | 12 |
2025964 | 2025964 | 2021-12-18 | Grant | Minnesota | 27051 | 1086 | 12 |
2022713 | 2022713 | 2021-12-17 | Grant | Minnesota | 27051 | 1086 | 12 |
2019705 | 2019705 | 2021-12-16 | Shelby | Missouri | 29205 | 1086 | 13 |
2011819 | 2011819 | 2021-12-14 | Modoc | California | 6049 | 1086 | 10 |
2010713 | 2010713 | 2021-12-13 | Comerio | Puerto Rico | 72045 | 1086 | |
2007462 | 2007462 | 2021-12-12 | Comerio | Puerto Rico | 72045 | 1086 | |
2004211 | 2004211 | 2021-12-11 | Comerio | Puerto Rico | 72045 | 1086 | |
2000960 | 2000960 | 2021-12-10 | Comerio | Puerto Rico | 72045 | 1086 | |
1975597 | 1975597 | 2021-12-02 | Lancaster | Virginia | 51103 | 1086 | 23 |
1970914 | 1970914 | 2021-12-01 | Maries | Missouri | 29125 | 1086 | 21 |
1924122 | 1924122 | 2021-11-17 | Lake | Colorado | 8065 | 1086 | 1 |
1926195 | 1926195 | 2021-11-17 | Ciales | Puerto Rico | 72039 | 1086 | |
1922945 | 1922945 | 2021-11-16 | Ciales | Puerto Rico | 72039 | 1086 | |
1919696 | 1919696 | 2021-11-15 | Ciales | Puerto Rico | 72039 | 1086 | |
1915609 | 1915609 | 2021-11-14 | Carter | Missouri | 29035 | 1086 | 14 |
1916446 | 1916446 | 2021-11-14 | Ciales | Puerto Rico | 72039 | 1086 | |
1912359 | 1912359 | 2021-11-13 | Carter | Missouri | 29035 | 1086 | 14 |
1913196 | 1913196 | 2021-11-13 | Ciales | Puerto Rico | 72039 | 1086 | |
1909604 | 1909604 | 2021-11-12 | Bottineau | North Dakota | 38009 | 1086 | 21 |
1898442 | 1898442 | 2021-11-09 | Power | Idaho | 16077 | 1086 | 15 |
1882920 | 1882920 | 2021-11-04 | Unknown | Michigan | 1086 | 12 | |
1884535 | 1884535 | 2021-11-04 | Bland | Virginia | 51021 | 1086 | 17 |
1857547 | 1857547 | 2021-10-27 | Gates | North Carolina | 37073 | 1086 | 19 |
1858202 | 1858202 | 2021-10-27 | Pickett | Tennessee | 47137 | 1086 | 24 |
1834399 | 1834399 | 2021-10-20 | Hickory | Missouri | 29085 | 1086 | 21 |
1831150 | 1831150 | 2021-10-19 | Hickory | Missouri | 29085 | 1086 | 21 |
1827901 | 1827901 | 2021-10-18 | Hickory | Missouri | 29085 | 1086 | 21 |
1824652 | 1824652 | 2021-10-17 | Hickory | Missouri | 29085 | 1086 | 21 |
1823012 | 1823012 | 2021-10-16 | Webster | West Virginia | 54101 | 1086 | 17 |
1794432 | 1794432 | 2021-10-08 | Benewah | Idaho | 16009 | 1086 | 17 |
1777293 | 1777293 | 2021-10-02 | Orange | Vermont | 50017 | 1086 | 4 |
1770505 | 1770505 | 2021-09-30 | Archer | Texas | 48009 | 1086 | 14 |
1766165 | 1766165 | 2021-09-29 | Harrison | Missouri | 29081 | 1086 | 17 |
1755995 | 1755995 | 2021-09-26 | Trimble | Kentucky | 21223 | 1086 | 9 |
1752747 | 1752747 | 2021-09-25 | Trimble | Kentucky | 21223 | 1086 | 9 |
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);