ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
447 rows where cases = 1043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 37
- Georgia 28
- Oklahoma 28
- Virginia 25
- Missouri 24
- Kentucky 20
- Indiana 19
- Puerto Rico 18
- Tennessee 16
- Michigan 15
- Idaho 14
- Illinois 14
- Mississippi 14
- Arkansas 13
- Wisconsin 12
- Colorado 11
- Minnesota 11
- Ohio 11
- Florida 8
- Nebraska 8
- South Carolina 8
- South Dakota 8
- Alabama 6
- California 6
- Iowa 6
- Maine 6
- North Dakota 6
- West Virginia 6
- Montana 5
- Oregon 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500476 | 2500476 | 2022-05-13 | Barber | Kansas | 20007 | 1043 | 8 |
2502063 | 2502063 | 2022-05-13 | Deuel | South Dakota | 46039 | 1043 | 12 |
2498805 | 2498805 | 2022-05-12 | Deuel | South Dakota | 46039 | 1043 | 12 |
2495547 | 2495547 | 2022-05-11 | Deuel | South Dakota | 46039 | 1043 | 12 |
2474876 | 2474876 | 2022-05-05 | Kittson | Minnesota | 27069 | 1043 | 27 |
2471619 | 2471619 | 2022-05-04 | Kittson | Minnesota | 27069 | 1043 | 27 |
2468363 | 2468363 | 2022-05-03 | Kittson | Minnesota | 27069 | 1043 | 27 |
2470036 | 2470036 | 2022-05-03 | Rappahannock | Virginia | 51157 | 1043 | 10 |
2465108 | 2465108 | 2022-05-02 | Kittson | Minnesota | 27069 | 1043 | 27 |
2466780 | 2466780 | 2022-05-02 | Rappahannock | Virginia | 51157 | 1043 | 10 |
2461852 | 2461852 | 2022-05-01 | Kittson | Minnesota | 27069 | 1043 | 27 |
2458596 | 2458596 | 2022-04-30 | Kittson | Minnesota | 27069 | 1043 | 27 |
2455340 | 2455340 | 2022-04-29 | Kittson | Minnesota | 27069 | 1043 | 27 |
2401547 | 2401547 | 2022-04-12 | Grand Isle | Vermont | 50013 | 1043 | 5 |
2282099 | 2282099 | 2022-03-07 | Lincoln | Idaho | 16063 | 1043 | 15 |
2266787 | 2266787 | 2022-03-02 | Holt | Missouri | 29087 | 1043 | 27 |
2259380 | 2259380 | 2022-02-28 | Hardin | Illinois | 17069 | 1043 | 19 |
2256129 | 2256129 | 2022-02-27 | Hardin | Illinois | 17069 | 1043 | 19 |
2252878 | 2252878 | 2022-02-26 | Hardin | Illinois | 17069 | 1043 | 19 |
2249627 | 2249627 | 2022-02-25 | Hardin | Illinois | 17069 | 1043 | 19 |
2235384 | 2235384 | 2022-02-20 | Brewster | Texas | 48043 | 1043 | 26 |
2232133 | 2232133 | 2022-02-19 | Brewster | Texas | 48043 | 1043 | 26 |
2224659 | 2224659 | 2022-02-17 | Boone | Nebraska | 31011 | 1043 | 4 |
2222108 | 2222108 | 2022-02-16 | Las Marias | Puerto Rico | 72083 | 1043 | |
2215057 | 2215057 | 2022-02-14 | Hidalgo | New Mexico | 35023 | 1043 | 13 |
2200141 | 2200141 | 2022-02-09 | Florence | Wisconsin | 55037 | 1043 | 15 |
2180411 | 2180411 | 2022-02-03 | Emporia city | Virginia | 51595 | 1043 | 47 |
2148802 | 2148802 | 2022-01-25 | Henderson | Illinois | 17071 | 1043 | 24 |
2151116 | 2151116 | 2022-01-25 | Charles City | Virginia | 51036 | 1043 | 22 |
2130362 | 2130362 | 2022-01-19 | Kearney | Nebraska | 31099 | 1043 | 7 |
2131320 | 2131320 | 2022-01-19 | Crane | Texas | 48103 | 1043 | 19 |
2108383 | 2108383 | 2022-01-12 | Lyman | South Dakota | 46085 | 1043 | 12 |
2102207 | 2102207 | 2022-01-10 | San Saba | Texas | 48411 | 1043 | 29 |
2098173 | 2098173 | 2022-01-09 | Sioux | North Dakota | 38085 | 1043 | 18 |
2092422 | 2092422 | 2022-01-07 | Newton | Texas | 48351 | 1043 | 54 |
2089602 | 2089602 | 2022-01-06 | Crook | Wyoming | 56011 | 1043 | 22 |
2076853 | 2076853 | 2022-01-03 | Trinity | California | 6105 | 1043 | 17 |
2073602 | 2073602 | 2022-01-02 | Trinity | California | 6105 | 1043 | 17 |
2070351 | 2070351 | 2022-01-01 | Trinity | California | 6105 | 1043 | 17 |
2067100 | 2067100 | 2021-12-31 | Trinity | California | 6105 | 1043 | 17 |
2063849 | 2063849 | 2021-12-30 | Trinity | California | 6105 | 1043 | 17 |
2033143 | 2033143 | 2021-12-20 | McHenry | North Dakota | 38049 | 1043 | 28 |
2029893 | 2029893 | 2021-12-19 | McHenry | North Dakota | 38049 | 1043 | 28 |
2021118 | 2021118 | 2021-12-16 | Middlesex | Virginia | 51119 | 1043 | 33 |
2010992 | 2010992 | 2021-12-13 | Bailey | Texas | 48017 | 1043 | 28 |
1991075 | 1991075 | 2021-12-07 | Tillman | Oklahoma | 40141 | 1043 | 25 |
1991262 | 1991262 | 2021-12-07 | Villalba | Puerto Rico | 72149 | 1043 | |
1987824 | 1987824 | 2021-12-06 | Tillman | Oklahoma | 40141 | 1043 | 25 |
1988011 | 1988011 | 2021-12-06 | Villalba | Puerto Rico | 72149 | 1043 | |
1983948 | 1983948 | 2021-12-05 | Shelby | Missouri | 29205 | 1043 | 13 |
1984574 | 1984574 | 2021-12-05 | Tillman | Oklahoma | 40141 | 1043 | 25 |
1981324 | 1981324 | 2021-12-04 | Tillman | Oklahoma | 40141 | 1043 | 25 |
1978074 | 1978074 | 2021-12-03 | Tillman | Oklahoma | 40141 | 1043 | 25 |
1974824 | 1974824 | 2021-12-02 | Tillman | Oklahoma | 40141 | 1043 | 24 |
1971575 | 1971575 | 2021-12-01 | Tillman | Oklahoma | 40141 | 1043 | 24 |
1936701 | 1936701 | 2021-11-20 | Calhoun | West Virginia | 54013 | 1043 | 5 |
1931939 | 1931939 | 2021-11-19 | Shannon | Missouri | 29203 | 1043 | 27 |
1920346 | 1920346 | 2021-11-15 | Madison | Virginia | 51113 | 1043 | 23 |
1828085 | 1828085 | 2021-10-18 | Knox | Nebraska | 31107 | 1043 | 13 |
1824356 | 1824356 | 2021-10-17 | Alcona | Michigan | 26001 | 1043 | 40 |
1821107 | 1821107 | 2021-10-16 | Alcona | Michigan | 26001 | 1043 | 40 |
1817858 | 1817858 | 2021-10-15 | Alcona | Michigan | 26001 | 1043 | 40 |
1814859 | 1814859 | 2021-10-14 | Wilkinson | Mississippi | 28157 | 1043 | 39 |
1816303 | 1816303 | 2021-10-14 | Bland | Virginia | 51021 | 1043 | 15 |
1813111 | 1813111 | 2021-10-13 | Lancaster | Virginia | 51103 | 1043 | 21 |
1805859 | 1805859 | 2021-10-11 | Harney | Oregon | 41025 | 1043 | 24 |
1787260 | 1787260 | 2021-10-05 | Pocahontas | West Virginia | 54075 | 1043 | 17 |
1767965 | 1767965 | 2021-09-30 | Southeast Fairbanks Census Area | Alaska | 2240 | 1043 | 9 |
1767733 | 1767733 | 2021-09-29 | Clay | West Virginia | 54015 | 1043 | 16 |
1763566 | 1763566 | 2021-09-28 | Kiowa | Oklahoma | 40075 | 1043 | 29 |
1760317 | 1760317 | 2021-09-27 | Kiowa | Oklahoma | 40075 | 1043 | 29 |
1757069 | 1757069 | 2021-09-26 | Kiowa | Oklahoma | 40075 | 1043 | 29 |
1753821 | 1753821 | 2021-09-25 | Kiowa | Oklahoma | 40075 | 1043 | 29 |
1750573 | 1750573 | 2021-09-24 | Kiowa | Oklahoma | 40075 | 1043 | 29 |
1746777 | 1746777 | 2021-09-23 | Madison | Montana | 30057 | 1043 | 8 |
1747323 | 1747323 | 2021-09-23 | Kiowa | Oklahoma | 40075 | 1043 | 29 |
1744074 | 1744074 | 2021-09-22 | Kiowa | Oklahoma | 40075 | 1043 | 29 |
1744941 | 1744941 | 2021-09-22 | Williamsburg city | Virginia | 51830 | 1043 | 14 |
1739667 | 1739667 | 2021-09-21 | Cumberland | Kentucky | 21057 | 1043 | 17 |
1741359 | 1741359 | 2021-09-21 | Hansford | Texas | 48195 | 1043 | 26 |
1736418 | 1736418 | 2021-09-20 | Cumberland | Kentucky | 21057 | 1043 | 17 |
1738110 | 1738110 | 2021-09-20 | Hansford | Texas | 48195 | 1043 | 26 |
1732446 | 1732446 | 2021-09-19 | Yuma | Colorado | 8125 | 1043 | 18 |
1734860 | 1734860 | 2021-09-19 | Hansford | Texas | 48195 | 1043 | 26 |
1729196 | 1729196 | 2021-09-18 | Yuma | Colorado | 8125 | 1043 | 18 |
1731242 | 1731242 | 2021-09-18 | Comerio | Puerto Rico | 72045 | 1043 | |
1731610 | 1731610 | 2021-09-18 | Hansford | Texas | 48195 | 1043 | 26 |
1725946 | 1725946 | 2021-09-17 | Yuma | Colorado | 8125 | 1043 | 18 |
1727992 | 1727992 | 2021-09-17 | Comerio | Puerto Rico | 72045 | 1043 | |
1728360 | 1728360 | 2021-09-17 | Hansford | Texas | 48195 | 1043 | 26 |
1722697 | 1722697 | 2021-09-16 | Yuma | Colorado | 8125 | 1043 | 18 |
1721491 | 1721491 | 2021-09-15 | Ciales | Puerto Rico | 72039 | 1043 | |
1715345 | 1715345 | 2021-09-13 | Floyd | Texas | 48153 | 1043 | 31 |
1712015 | 1712015 | 2021-09-12 | Van Buren | Tennessee | 47175 | 1043 | 24 |
1712099 | 1712099 | 2021-09-12 | Floyd | Texas | 48153 | 1043 | 31 |
1708768 | 1708768 | 2021-09-11 | Van Buren | Tennessee | 47175 | 1043 | 24 |
1708852 | 1708852 | 2021-09-11 | Floyd | Texas | 48153 | 1043 | 31 |
1705521 | 1705521 | 2021-09-10 | Van Buren | Tennessee | 47175 | 1043 | 24 |
1690476 | 1690476 | 2021-09-06 | Boundary | Idaho | 16021 | 1043 | 14 |
1690698 | 1690698 | 2021-09-06 | Warren | Indiana | 18171 | 1043 | 18 |
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);