ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
350 rows where cases = 1334 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- North Dakota 22
- Puerto Rico 21
- Mississippi 20
- Iowa 17
- Minnesota 17
- Missouri 16
- Kentucky 15
- North Carolina 15
- Virginia 15
- Georgia 12
- Illinois 11
- Arkansas 10
- Michigan 10
- Kansas 8
- Ohio 8
- Indiana 7
- Virgin Islands 7
- Alabama 6
- Colorado 6
- Maine 6
- New Mexico 6
- Florida 5
- Louisiana 5
- Tennessee 5
- Wisconsin 5
- Montana 4
- Nebraska 4
- Washington 4
- Connecticut 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447172 | 2447172 | 2022-04-26 | Cumberland | Virginia | 51049 | 1334 | 26 |
2361626 | 2361626 | 2022-03-31 | Sioux | North Dakota | 38085 | 1334 | 19 |
2358372 | 2358372 | 2022-03-30 | Sioux | North Dakota | 38085 | 1334 | 19 |
2355118 | 2355118 | 2022-03-29 | Sioux | North Dakota | 38085 | 1334 | 19 |
2351865 | 2351865 | 2022-03-28 | Sioux | North Dakota | 38085 | 1334 | 19 |
2348613 | 2348613 | 2022-03-27 | Sioux | North Dakota | 38085 | 1334 | 19 |
2345360 | 2345360 | 2022-03-26 | Sioux | North Dakota | 38085 | 1334 | 19 |
2342107 | 2342107 | 2022-03-25 | Sioux | North Dakota | 38085 | 1334 | 19 |
2338854 | 2338854 | 2022-03-24 | Sioux | North Dakota | 38085 | 1334 | 19 |
2335600 | 2335600 | 2022-03-23 | Sioux | North Dakota | 38085 | 1334 | 19 |
2332346 | 2332346 | 2022-03-22 | Sioux | North Dakota | 38085 | 1334 | 19 |
2329093 | 2329093 | 2022-03-21 | Sioux | North Dakota | 38085 | 1334 | 19 |
2325841 | 2325841 | 2022-03-20 | Sioux | North Dakota | 38085 | 1334 | 19 |
2322588 | 2322588 | 2022-03-19 | Sioux | North Dakota | 38085 | 1334 | 19 |
2318965 | 2318965 | 2022-03-18 | Burt | Nebraska | 31021 | 1334 | 16 |
2319334 | 2319334 | 2022-03-18 | Sioux | North Dakota | 38085 | 1334 | 19 |
2315712 | 2315712 | 2022-03-17 | Burt | Nebraska | 31021 | 1334 | 16 |
2293314 | 2293314 | 2022-03-10 | Sioux | North Dakota | 38085 | 1334 | 19 |
2290062 | 2290062 | 2022-03-09 | Sioux | North Dakota | 38085 | 1334 | 19 |
2286810 | 2286810 | 2022-03-08 | Sioux | North Dakota | 38085 | 1334 | 19 |
2283558 | 2283558 | 2022-03-07 | Sioux | North Dakota | 38085 | 1334 | 19 |
2280306 | 2280306 | 2022-03-06 | Sioux | North Dakota | 38085 | 1334 | 19 |
2277053 | 2277053 | 2022-03-05 | Sioux | North Dakota | 38085 | 1334 | 19 |
2264376 | 2264376 | 2022-03-01 | Maunabo | Puerto Rico | 72095 | 1334 | |
2261126 | 2261126 | 2022-02-28 | Maunabo | Puerto Rico | 72095 | 1334 | |
2257875 | 2257875 | 2022-02-27 | Maunabo | Puerto Rico | 72095 | 1334 | |
2244997 | 2244997 | 2022-02-23 | McCook | South Dakota | 46087 | 1334 | 31 |
2223958 | 2223958 | 2022-02-17 | Republic | Kansas | 20157 | 1334 | 14 |
2224808 | 2224808 | 2022-02-17 | Guadalupe | New Mexico | 35019 | 1334 | 16 |
2225335 | 2225335 | 2022-02-17 | Ceiba | Puerto Rico | 72037 | 1334 | |
2226216 | 2226216 | 2022-02-17 | Crook | Wyoming | 56011 | 1334 | 24 |
2220707 | 2220707 | 2022-02-16 | Republic | Kansas | 20157 | 1334 | 14 |
2222084 | 2222084 | 2022-02-16 | Ceiba | Puerto Rico | 72037 | 1334 | |
2172468 | 2172468 | 2022-02-01 | Dade | Missouri | 29057 | 1334 | 38 |
2169042 | 2169042 | 2022-01-31 | Grant | Minnesota | 27051 | 1334 | 12 |
2170325 | 2170325 | 2022-01-31 | Bailey | Texas | 48017 | 1334 | 31 |
2058475 | 2058475 | 2021-12-28 | Lac qui Parle | Minnesota | 27073 | 1334 | 26 |
2055438 | 2055438 | 2021-12-27 | Ozark | Missouri | 29153 | 1334 | 44 |
2037439 | 2037439 | 2021-12-21 | Jefferson | Washington | 53031 | 1334 | 21 |
2029304 | 2029304 | 2021-12-19 | Humphreys | Mississippi | 28053 | 1334 | 39 |
2026053 | 2026053 | 2021-12-18 | Humphreys | Mississippi | 28053 | 1334 | 39 |
2022802 | 2022802 | 2021-12-17 | Humphreys | Mississippi | 28053 | 1334 | 39 |
2001235 | 2001235 | 2021-12-10 | Archer | Texas | 48009 | 1334 | 24 |
1998036 | 1998036 | 2021-12-09 | Dallam | Texas | 48111 | 1334 | 29 |
1994785 | 1994785 | 2021-12-08 | Dallam | Texas | 48111 | 1334 | 29 |
1974444 | 1974444 | 2021-12-02 | Sierra | New Mexico | 35051 | 1334 | 60 |
1941784 | 1941784 | 2021-11-22 | Cuming | Nebraska | 31039 | 1334 | 15 |
1928065 | 1928065 | 2021-11-18 | Pratt | Kansas | 20151 | 1334 | 27 |
1929132 | 1929132 | 2021-11-18 | Pembina | North Dakota | 38067 | 1334 | 13 |
1924815 | 1924815 | 2021-11-17 | Pratt | Kansas | 20151 | 1334 | 27 |
1922261 | 1922261 | 2021-11-16 | Valley | Montana | 30105 | 1334 | 28 |
1920294 | 1920294 | 2021-11-15 | Charlotte | Virginia | 51037 | 1334 | 27 |
1905987 | 1905987 | 2021-11-11 | Madison | Montana | 30057 | 1334 | 13 |
1906288 | 1906288 | 2021-11-11 | Graham | North Carolina | 37075 | 1334 | 28 |
1902738 | 1902738 | 2021-11-10 | Madison | Montana | 30057 | 1334 | 13 |
1903039 | 1903039 | 2021-11-10 | Graham | North Carolina | 37075 | 1334 | 28 |
1899789 | 1899789 | 2021-11-09 | Graham | North Carolina | 37075 | 1334 | 28 |
1892772 | 1892772 | 2021-11-07 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1893289 | 1893289 | 2021-11-07 | Graham | North Carolina | 37075 | 1334 | 28 |
1889522 | 1889522 | 2021-11-06 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1890039 | 1890039 | 2021-11-06 | Graham | North Carolina | 37075 | 1334 | 28 |
1886272 | 1886272 | 2021-11-05 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1886789 | 1886789 | 2021-11-05 | Graham | North Carolina | 37075 | 1334 | 28 |
1881879 | 1881879 | 2021-11-04 | Lincoln | Colorado | 8073 | 1334 | 8 |
1883023 | 1883023 | 2021-11-04 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1883214 | 1883214 | 2021-11-04 | Blaine | Montana | 30005 | 1334 | 27 |
1879774 | 1879774 | 2021-11-03 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1881292 | 1881292 | 2021-11-03 | Buena Vista city | Virginia | 51530 | 1334 | 27 |
1876525 | 1876525 | 2021-11-02 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1873047 | 1873047 | 2021-11-01 | Piscataquis | Maine | 23021 | 1334 | 12 |
1873276 | 1873276 | 2021-11-01 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1869798 | 1869798 | 2021-10-31 | Piscataquis | Maine | 23021 | 1334 | 12 |
1866549 | 1866549 | 2021-10-30 | Piscataquis | Maine | 23021 | 1334 | 12 |
1866926 | 1866926 | 2021-10-30 | Oregon | Missouri | 29149 | 1334 | 11 |
1857562 | 1857562 | 2021-10-27 | Jones | North Carolina | 37103 | 1334 | 31 |
1850493 | 1850493 | 2021-10-25 | Pipestone | Minnesota | 27117 | 1334 | 27 |
1847243 | 1847243 | 2021-10-24 | Pipestone | Minnesota | 27117 | 1334 | 27 |
1847282 | 1847282 | 2021-10-24 | Choctaw | Mississippi | 28019 | 1334 | 26 |
1843993 | 1843993 | 2021-10-23 | Pipestone | Minnesota | 27117 | 1334 | 27 |
1844032 | 1844032 | 2021-10-23 | Choctaw | Mississippi | 28019 | 1334 | 26 |
1840743 | 1840743 | 2021-10-22 | Pipestone | Minnesota | 27117 | 1334 | 27 |
1840782 | 1840782 | 2021-10-22 | Choctaw | Mississippi | 28019 | 1334 | 26 |
1836316 | 1836316 | 2021-10-21 | Mariposa | California | 6043 | 1334 | 16 |
1837533 | 1837533 | 2021-10-21 | Choctaw | Mississippi | 28019 | 1334 | 26 |
1834237 | 1834237 | 2021-10-20 | Murray | Minnesota | 27101 | 1334 | 10 |
1835868 | 1835868 | 2021-10-20 | Nelson | Virginia | 51125 | 1334 | 16 |
1830981 | 1830981 | 2021-10-19 | Marshall | Minnesota | 27089 | 1334 | 19 |
1826929 | 1826929 | 2021-10-18 | Boundary | Idaho | 16021 | 1334 | 25 |
1793040 | 1793040 | 2021-10-07 | Allendale | South Carolina | 45005 | 1334 | 21 |
1789762 | 1789762 | 2021-10-06 | Quebradillas | Puerto Rico | 72115 | 1334 | |
1785042 | 1785042 | 2021-10-05 | Doniphan | Kansas | 20043 | 1334 | 27 |
1786514 | 1786514 | 2021-10-05 | Quebradillas | Puerto Rico | 72115 | 1334 | |
1781793 | 1781793 | 2021-10-04 | Doniphan | Kansas | 20043 | 1334 | 27 |
1783265 | 1783265 | 2021-10-04 | Quebradillas | Puerto Rico | 72115 | 1334 | |
1767874 | 1767874 | 2021-09-29 | Washakie | Wyoming | 56043 | 1334 | 27 |
1758221 | 1758221 | 2021-09-27 | Valdez-Cordova Census Area | Alaska | 2261 | 1334 | 2 |
1758055 | 1758055 | 2021-09-26 | Forest | Wisconsin | 55041 | 1334 | 31 |
1753994 | 1753994 | 2021-09-25 | Guayama | Puerto Rico | 72057 | 1334 | |
1754037 | 1754037 | 2021-09-25 | Utuado | Puerto Rico | 72141 | 1334 | |
1754807 | 1754807 | 2021-09-25 | Forest | Wisconsin | 55041 | 1334 | 31 |
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);