ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
299 rows where cases = 2140 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 36
- Texas 30
- Georgia 22
- Minnesota 15
- Mississippi 14
- Michigan 12
- Colorado 11
- Illinois 11
- Missouri 11
- Iowa 9
- Montana 9
- Arkansas 8
- Florida 8
- Indiana 7
- North Carolina 7
- Tennessee 7
- Kentucky 6
- Nebraska 5
- North Dakota 5
- Ohio 5
- Puerto Rico 5
- South Carolina 5
- Wisconsin 4
- Alabama 3
- Idaho 3
- Louisiana 3
- Nevada 3
- Oregon 3
- Pennsylvania 3
- Utah 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381873 | 2381873 | 2022-04-06 | Live Oak | Texas | 48297 | 2140 | 42 |
2378618 | 2378618 | 2022-04-05 | Live Oak | Texas | 48297 | 2140 | 42 |
2373947 | 2373947 | 2022-04-04 | Jackson | Minnesota | 27063 | 2140 | 17 |
2375298 | 2375298 | 2022-04-04 | Gaines | Texas | 48165 | 2140 | 83 |
2375364 | 2375364 | 2022-04-04 | Live Oak | Texas | 48297 | 2140 | 42 |
2370694 | 2370694 | 2022-04-03 | Jackson | Minnesota | 27063 | 2140 | 17 |
2370761 | 2370761 | 2022-04-03 | Claiborne | Mississippi | 28021 | 2140 | 46 |
2372046 | 2372046 | 2022-04-03 | Gaines | Texas | 48165 | 2140 | 83 |
2372112 | 2372112 | 2022-04-03 | Live Oak | Texas | 48297 | 2140 | 42 |
2367441 | 2367441 | 2022-04-02 | Jackson | Minnesota | 27063 | 2140 | 17 |
2367508 | 2367508 | 2022-04-02 | Claiborne | Mississippi | 28021 | 2140 | 46 |
2368793 | 2368793 | 2022-04-02 | Gaines | Texas | 48165 | 2140 | 83 |
2368859 | 2368859 | 2022-04-02 | Live Oak | Texas | 48297 | 2140 | 42 |
2364188 | 2364188 | 2022-04-01 | Jackson | Minnesota | 27063 | 2140 | 17 |
2364255 | 2364255 | 2022-04-01 | Claiborne | Mississippi | 28021 | 2140 | 46 |
2365540 | 2365540 | 2022-04-01 | Gaines | Texas | 48165 | 2140 | 83 |
2365606 | 2365606 | 2022-04-01 | Live Oak | Texas | 48297 | 2140 | 42 |
2360934 | 2360934 | 2022-03-31 | Jackson | Minnesota | 27063 | 2140 | 17 |
2361001 | 2361001 | 2022-03-31 | Claiborne | Mississippi | 28021 | 2140 | 46 |
2362353 | 2362353 | 2022-03-31 | Live Oak | Texas | 48297 | 2140 | 42 |
2357680 | 2357680 | 2022-03-30 | Jackson | Minnesota | 27063 | 2140 | 17 |
2357747 | 2357747 | 2022-03-30 | Claiborne | Mississippi | 28021 | 2140 | 46 |
2359099 | 2359099 | 2022-03-30 | Live Oak | Texas | 48297 | 2140 | 42 |
2354427 | 2354427 | 2022-03-29 | Jackson | Minnesota | 27063 | 2140 | 17 |
2354494 | 2354494 | 2022-03-29 | Claiborne | Mississippi | 28021 | 2140 | 46 |
2354728 | 2354728 | 2022-03-29 | Sanders | Montana | 30089 | 2140 | 46 |
2355845 | 2355845 | 2022-03-29 | Live Oak | Texas | 48297 | 2140 | 42 |
2351242 | 2351242 | 2022-03-28 | Claiborne | Mississippi | 28021 | 2140 | 46 |
2351475 | 2351475 | 2022-03-28 | Sanders | Montana | 30089 | 2140 | 46 |
2348223 | 2348223 | 2022-03-27 | Sanders | Montana | 30089 | 2140 | 46 |
2344970 | 2344970 | 2022-03-26 | Sanders | Montana | 30089 | 2140 | 46 |
2341717 | 2341717 | 2022-03-25 | Sanders | Montana | 30089 | 2140 | 46 |
2335210 | 2335210 | 2022-03-23 | Sanders | Montana | 30089 | 2140 | 46 |
2297224 | 2297224 | 2022-03-11 | Franklin | Texas | 48159 | 2140 | 40 |
2293972 | 2293972 | 2022-03-10 | Franklin | Texas | 48159 | 2140 | 40 |
2258509 | 2258509 | 2022-02-27 | Northumberland | Virginia | 51133 | 2140 | 43 |
2255258 | 2255258 | 2022-02-26 | Northumberland | Virginia | 51133 | 2140 | 43 |
2252007 | 2252007 | 2022-02-25 | Northumberland | Virginia | 51133 | 2140 | 43 |
2244031 | 2244031 | 2022-02-23 | Howard | Missouri | 29089 | 2140 | 23 |
2237555 | 2237555 | 2022-02-21 | Monroe | Missouri | 29137 | 2140 | 40 |
2234304 | 2234304 | 2022-02-20 | Monroe | Missouri | 29137 | 2140 | 40 |
2231053 | 2231053 | 2022-02-19 | Monroe | Missouri | 29137 | 2140 | 40 |
2227802 | 2227802 | 2022-02-18 | Monroe | Missouri | 29137 | 2140 | 40 |
2189594 | 2189594 | 2022-02-06 | Penuelas | Puerto Rico | 72111 | 2140 | |
2173235 | 2173235 | 2022-02-01 | Forest | Pennsylvania | 42053 | 2140 | 34 |
2151667 | 2151667 | 2022-01-26 | Bent | Colorado | 8011 | 2140 | 46 |
2110083 | 2110083 | 2022-01-13 | Marshall | Kansas | 20117 | 2140 | 37 |
2106832 | 2106832 | 2022-01-12 | Marshall | Kansas | 20117 | 2140 | 37 |
2086501 | 2086501 | 2022-01-06 | Desha | Arkansas | 5041 | 2140 | 36 |
2088059 | 2088059 | 2022-01-06 | Colfax | Nebraska | 31037 | 2140 | 24 |
2088278 | 2088278 | 2022-01-06 | Alleghany | North Carolina | 37005 | 2140 | 10 |
2039957 | 2039957 | 2021-12-22 | Cabo Rojo | Puerto Rico | 72023 | 2140 | |
2019195 | 2019195 | 2021-12-16 | Metcalfe | Kentucky | 21169 | 2140 | 48 |
1986372 | 1986372 | 2021-12-06 | Pulaski | Indiana | 18131 | 2140 | 60 |
1985345 | 1985345 | 2021-12-05 | King William | Virginia | 51101 | 2140 | 25 |
1982095 | 1982095 | 2021-12-04 | King William | Virginia | 51101 | 2140 | 25 |
1978845 | 1978845 | 2021-12-03 | King William | Virginia | 51101 | 2140 | 25 |
1943631 | 1943631 | 2021-11-23 | Moffat | Colorado | 8081 | 2140 | 47 |
1945468 | 1945468 | 2021-11-23 | Noble | Ohio | 39121 | 2140 | 47 |
1900926 | 1900926 | 2021-11-09 | Klickitat | Washington | 53039 | 2140 | 24 |
1891966 | 1891966 | 2021-11-07 | De Witt | Illinois | 17039 | 2140 | 37 |
1888716 | 1888716 | 2021-11-06 | De Witt | Illinois | 17039 | 2140 | 37 |
1885466 | 1885466 | 2021-11-05 | De Witt | Illinois | 17039 | 2140 | 37 |
1881278 | 1881278 | 2021-11-03 | Alleghany | Virginia | 51005 | 2140 | 78 |
1881479 | 1881479 | 2021-11-03 | Morgan | West Virginia | 54065 | 2140 | 46 |
1876553 | 1876553 | 2021-11-02 | Lawrence | Mississippi | 28077 | 2140 | 40 |
1873304 | 1873304 | 2021-11-01 | Lawrence | Mississippi | 28077 | 2140 | 40 |
1869298 | 1869298 | 2021-10-31 | Washington | Illinois | 17189 | 2140 | 35 |
1866049 | 1866049 | 2021-10-30 | Washington | Illinois | 17189 | 2140 | 35 |
1862800 | 1862800 | 2021-10-29 | Washington | Illinois | 17189 | 2140 | 35 |
1848749 | 1848749 | 2021-10-24 | Millard | Utah | 49027 | 2140 | 25 |
1845499 | 1845499 | 2021-10-23 | Millard | Utah | 49027 | 2140 | 25 |
1842249 | 1842249 | 2021-10-22 | Millard | Utah | 49027 | 2140 | 25 |
1830271 | 1830271 | 2021-10-19 | Mason | Illinois | 17125 | 2140 | 53 |
1826792 | 1826792 | 2021-10-18 | Dade | Georgia | 13083 | 2140 | 19 |
1816598 | 1816598 | 2021-10-14 | Goshen | Wyoming | 56015 | 2140 | 34 |
1810761 | 1810761 | 2021-10-13 | Jo Daviess | Illinois | 17085 | 2140 | 32 |
1790804 | 1790804 | 2021-10-07 | Van Buren | Arkansas | 5141 | 2140 | 37 |
1788861 | 1788861 | 2021-10-06 | Walthall | Mississippi | 28147 | 2140 | 62 |
1789730 | 1789730 | 2021-10-06 | Fajardo | Puerto Rico | 72053 | 2140 | |
1785683 | 1785683 | 2021-10-05 | Macon | Missouri | 29121 | 2140 | 20 |
1764246 | 1764246 | 2021-09-28 | Wilbarger | Texas | 48487 | 2140 | 57 |
1758897 | 1758897 | 2021-09-27 | Pike | Indiana | 18125 | 2140 | 41 |
1736504 | 1736504 | 2021-09-20 | Washington | Kentucky | 21229 | 2140 | 42 |
1717388 | 1717388 | 2021-09-14 | Yalobusha | Mississippi | 28161 | 2140 | 47 |
1713764 | 1713764 | 2021-09-13 | Webster | Kentucky | 21233 | 2140 | 29 |
1694948 | 1694948 | 2021-09-07 | Sullivan | New Hampshire | 33019 | 2140 | 29 |
1692678 | 1692678 | 2021-09-06 | Leon | Texas | 48289 | 2140 | 50 |
1686924 | 1686924 | 2021-09-05 | Elbert | Colorado | 8039 | 2140 | 16 |
1683674 | 1683674 | 2021-09-04 | Elbert | Colorado | 8039 | 2140 | 16 |
1680423 | 1680423 | 2021-09-03 | Elbert | Colorado | 8039 | 2140 | 16 |
1653542 | 1653542 | 2021-08-25 | Union | Tennessee | 47173 | 2140 | 35 |
1650295 | 1650295 | 2021-08-24 | Union | Tennessee | 47173 | 2140 | 35 |
1628897 | 1628897 | 2021-08-18 | Carroll | Indiana | 18015 | 2140 | 26 |
1615252 | 1615252 | 2021-08-14 | Randolph | Alabama | 1111 | 2140 | 53 |
1612003 | 1612003 | 2021-08-13 | Randolph | Alabama | 1111 | 2140 | 53 |
1614345 | 1614345 | 2021-08-13 | San Lorenzo | Puerto Rico | 72129 | 2140 | |
1610265 | 1610265 | 2021-08-12 | Moniteau | Missouri | 29135 | 2140 | 33 |
1606179 | 1606179 | 2021-08-11 | Fulton | Indiana | 18049 | 2140 | 46 |
1597099 | 1597099 | 2021-08-08 | Roseau | Minnesota | 27135 | 2140 | 21 |
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);