ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
229 rows where cases = 2098 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 23
- Missouri 17
- Arkansas 14
- Texas 11
- Mississippi 10
- Michigan 9
- Minnesota 9
- North Carolina 9
- Oklahoma 9
- Kentucky 8
- Virginia 8
- West Virginia 8
- Washington 7
- Tennessee 6
- Colorado 5
- Idaho 5
- Indiana 5
- South Dakota 5
- Utah 5
- Wisconsin 5
- Kansas 4
- Pennsylvania 4
- Puerto Rico 4
- Alabama 3
- Florida 3
- Illinois 3
- Iowa 3
- New York 3
- Oregon 3
- South Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492919 | 2492919 | 2022-05-10 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2489661 | 2489661 | 2022-05-09 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2483854 | 2483854 | 2022-05-08 | Boundary | Idaho | 16021 | 2098 | 62 |
2480596 | 2480596 | 2022-05-07 | Boundary | Idaho | 16021 | 2098 | 62 |
2477338 | 2477338 | 2022-05-06 | Boundary | Idaho | 16021 | 2098 | 62 |
2448837 | 2448837 | 2022-04-27 | Marshall | Minnesota | 27089 | 2098 | 23 |
2450580 | 2450580 | 2022-04-27 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2447324 | 2447324 | 2022-04-26 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2327455 | 2327455 | 2022-03-21 | Candler | Georgia | 13043 | 2098 | 94 |
2325390 | 2325390 | 2022-03-20 | St. Clair | Missouri | 29185 | 2098 | 33 |
2322136 | 2322136 | 2022-03-19 | St. Clair | Missouri | 29185 | 2098 | 33 |
2318882 | 2318882 | 2022-03-18 | St. Clair | Missouri | 29185 | 2098 | 33 |
2314204 | 2314204 | 2022-03-17 | Searcy | Arkansas | 5129 | 2098 | 44 |
2315629 | 2315629 | 2022-03-17 | St. Clair | Missouri | 29185 | 2098 | 33 |
2313150 | 2313150 | 2022-03-16 | Jayuya | Puerto Rico | 72073 | 2098 | |
2304835 | 2304835 | 2022-03-14 | Benewah | Idaho | 16009 | 2098 | 40 |
2268891 | 2268891 | 2022-03-03 | Atkinson | Georgia | 13003 | 2098 | 46 |
2265638 | 2265638 | 2022-03-02 | Atkinson | Georgia | 13003 | 2098 | 44 |
2254948 | 2254948 | 2022-02-26 | Franklin | Texas | 48159 | 2098 | 40 |
2246902 | 2246902 | 2022-02-24 | Red River | Louisiana | 22081 | 2098 | 52 |
2243651 | 2243651 | 2022-02-23 | Red River | Louisiana | 22081 | 2098 | 52 |
2218140 | 2218140 | 2022-02-15 | Sanders | Montana | 30089 | 2098 | 44 |
2214765 | 2214765 | 2022-02-14 | Gentry | Missouri | 29075 | 2098 | 29 |
2210462 | 2210462 | 2022-02-13 | Macon | Georgia | 13193 | 2098 | 47 |
2207209 | 2207209 | 2022-02-12 | Macon | Georgia | 13193 | 2098 | 47 |
2203956 | 2203956 | 2022-02-11 | Macon | Georgia | 13193 | 2098 | 47 |
2206622 | 2206622 | 2022-02-11 | Tyler | West Virginia | 54095 | 2098 | 27 |
2203304 | 2203304 | 2022-02-10 | Lincoln | Washington | 53043 | 2098 | 27 |
2200050 | 2200050 | 2022-02-09 | Lincoln | Washington | 53043 | 2098 | 27 |
2171697 | 2171697 | 2022-02-01 | Martin | Indiana | 18101 | 2098 | 23 |
2168195 | 2168195 | 2022-01-31 | Pulaski | Georgia | 13235 | 2098 | 68 |
2168238 | 2168238 | 2022-01-31 | Wilkinson | Georgia | 13319 | 2098 | 50 |
2151540 | 2151540 | 2022-01-26 | Cleveland | Arkansas | 5025 | 2098 | 33 |
2154228 | 2154228 | 2022-01-26 | Parmer | Texas | 48369 | 2098 | 46 |
2073482 | 2073482 | 2022-01-02 | Chicot | Arkansas | 5017 | 2098 | 48 |
2061877 | 2061877 | 2021-12-29 | Cedar | Missouri | 29039 | 2098 | 42 |
2054935 | 2054935 | 2021-12-27 | Lyon | Kentucky | 21143 | 2098 | 29 |
2024265 | 2024265 | 2021-12-17 | Unknown | Utah | 2098 | 50 | |
1996432 | 1996432 | 2021-12-09 | Martin | Kentucky | 21159 | 2098 | 37 |
1987609 | 1987609 | 2021-12-06 | Barnes | North Dakota | 38003 | 2098 | 39 |
1974594 | 1974594 | 2021-12-02 | Swain | North Carolina | 37173 | 2098 | 28 |
1967521 | 1967521 | 2021-11-30 | Amite | Mississippi | 28005 | 2098 | 57 |
1964269 | 1964269 | 2021-11-29 | Amite | Mississippi | 28005 | 2098 | 57 |
1965743 | 1965743 | 2021-11-29 | Juab | Utah | 49023 | 2098 | 18 |
1941671 | 1941671 | 2021-11-22 | Pemiscot | Missouri | 29155 | 2098 | 56 |
1938421 | 1938421 | 2021-11-21 | Pemiscot | Missouri | 29155 | 2098 | 56 |
1927802 | 1927802 | 2021-11-18 | Blackford | Indiana | 18009 | 2098 | 46 |
1920880 | 1920880 | 2021-11-16 | Moffat | Colorado | 8081 | 2098 | 46 |
1919662 | 1919662 | 2021-11-15 | Potter | Pennsylvania | 42105 | 2098 | 51 |
1906575 | 1906575 | 2021-11-11 | Baker | Oregon | 41001 | 2098 | 30 |
1906918 | 1906918 | 2021-11-11 | Jackson | Tennessee | 47087 | 2098 | 40 |
1903326 | 1903326 | 2021-11-10 | Baker | Oregon | 41001 | 2098 | 30 |
1903669 | 1903669 | 2021-11-10 | Jackson | Tennessee | 47087 | 2098 | 40 |
1882536 | 1882536 | 2021-11-04 | Jackson | Kansas | 20085 | 2098 | 19 |
1879287 | 1879287 | 2021-11-03 | Jackson | Kansas | 20085 | 2098 | 19 |
1816509 | 1816509 | 2021-10-14 | Taylor | West Virginia | 54091 | 2098 | 36 |
1809477 | 1809477 | 2021-10-12 | Stewart | Tennessee | 47161 | 2098 | 34 |
1810076 | 1810076 | 2021-10-12 | Rusk | Wisconsin | 55107 | 2098 | 32 |
1787528 | 1787528 | 2021-10-06 | Marion | Arkansas | 5089 | 2098 | 55 |
1788070 | 1788070 | 2021-10-06 | Washington | Illinois | 17189 | 2098 | 34 |
1788407 | 1788407 | 2021-10-06 | Estill | Kentucky | 21065 | 2098 | 12 |
1788947 | 1788947 | 2021-10-06 | Osage | Missouri | 29151 | 2098 | 22 |
1760939 | 1760939 | 2021-09-27 | Pecos | Texas | 48371 | 2098 | 44 |
1746490 | 1746490 | 2021-09-23 | Houston | Minnesota | 27055 | 2098 | 16 |
1719554 | 1719554 | 2021-09-15 | Charlton | Georgia | 13049 | 2098 | 50 |
1718250 | 1718250 | 2021-09-14 | Fajardo | Puerto Rico | 72053 | 2098 | |
1715002 | 1715002 | 2021-09-13 | Fajardo | Puerto Rico | 72053 | 2098 | |
1701498 | 1701498 | 2021-09-09 | Taos | New Mexico | 35055 | 2098 | 56 |
1691218 | 1691218 | 2021-09-06 | Osceola | Michigan | 26133 | 2098 | 31 |
1691391 | 1691391 | 2021-09-06 | Tallahatchie | Mississippi | 28135 | 2098 | 46 |
1687968 | 1687968 | 2021-09-05 | Osceola | Michigan | 26133 | 2098 | 31 |
1684718 | 1684718 | 2021-09-04 | Osceola | Michigan | 26133 | 2098 | 31 |
1681467 | 1681467 | 2021-09-03 | Osceola | Michigan | 26133 | 2098 | 31 |
1673683 | 1673683 | 2021-09-01 | Crenshaw | Alabama | 1041 | 2098 | 61 |
1673456 | 1673456 | 2021-08-31 | Southampton | Virginia | 51175 | 2098 | 58 |
1654755 | 1654755 | 2021-08-26 | Gem | Idaho | 16045 | 2098 | 47 |
1657287 | 1657287 | 2021-08-26 | Hampshire | West Virginia | 54027 | 2098 | 36 |
1647100 | 1647100 | 2021-08-23 | Colorado | Texas | 48089 | 2098 | 34 |
1631209 | 1631209 | 2021-08-18 | Powhatan | Virginia | 51145 | 2098 | 17 |
1627313 | 1627313 | 2021-08-17 | Las Piedras | Puerto Rico | 72085 | 2098 | |
1606665 | 1606665 | 2021-08-11 | Garrett | Maryland | 24023 | 2098 | 66 |
1602130 | 1602130 | 2021-08-09 | Green Lake | Wisconsin | 55047 | 2098 | 25 |
1598615 | 1598615 | 2021-08-08 | Bennington | Vermont | 50003 | 2098 | 15 |
1595366 | 1595366 | 2021-08-07 | Bennington | Vermont | 50003 | 2098 | 15 |
1592117 | 1592117 | 2021-08-06 | Bennington | Vermont | 50003 | 2098 | 15 |
1587364 | 1587364 | 2021-08-05 | Wabasha | Minnesota | 27157 | 2098 | 3 |
1581658 | 1581658 | 2021-08-03 | Murray | Oklahoma | 40099 | 2098 | 44 |
1578409 | 1578409 | 2021-08-02 | Murray | Oklahoma | 40099 | 2098 | 44 |
1575161 | 1575161 | 2021-08-01 | Murray | Oklahoma | 40099 | 2098 | 44 |
1571913 | 1571913 | 2021-07-31 | Murray | Oklahoma | 40099 | 2098 | 44 |
1568665 | 1568665 | 2021-07-30 | Murray | Oklahoma | 40099 | 2098 | 44 |
1565417 | 1565417 | 2021-07-29 | Murray | Oklahoma | 40099 | 2098 | 44 |
1560133 | 1560133 | 2021-07-28 | Phillips | Arkansas | 5107 | 2098 | 45 |
1562169 | 1562169 | 2021-07-28 | Murray | Oklahoma | 40099 | 2098 | 44 |
1557012 | 1557012 | 2021-07-27 | Otero | Colorado | 8089 | 2098 | 67 |
1553765 | 1553765 | 2021-07-26 | Otero | Colorado | 8089 | 2098 | 67 |
1537714 | 1537714 | 2021-07-21 | Lamar | Georgia | 13171 | 2098 | 59 |
1519537 | 1519537 | 2021-07-15 | Coos | New Hampshire | 33007 | 2098 | 45 |
1516290 | 1516290 | 2021-07-14 | Coos | New Hampshire | 33007 | 2098 | 45 |
1509619 | 1509619 | 2021-07-12 | Texas | Missouri | 29215 | 2098 | 23 |
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);