ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where cases = 4567 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Wisconsin 8
- Arkansas 7
- Georgia 7
- Kentucky 7
- Alabama 6
- Ohio 6
- Tennessee 5
- Indiana 4
- New Jersey 4
- West Virginia 4
- Colorado 3
- Florida 3
- Illinois 3
- Mississippi 3
- South Carolina 3
- Utah 3
- California 2
- Minnesota 2
- Missouri 2
- Montana 2
- New York 2
- Oklahoma 2
- Puerto Rico 2
- Iowa 1
- Louisiana 1
- Maryland 1
- Michigan 1
- New Mexico 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493198 | 2493198 | 2022-05-11 | Hempstead | Arkansas | 5057 | 4567 | 68 |
2489940 | 2489940 | 2022-05-10 | Hempstead | Arkansas | 5057 | 4567 | 68 |
2486683 | 2486683 | 2022-05-09 | Hempstead | Arkansas | 5057 | 4567 | 68 |
2483425 | 2483425 | 2022-05-08 | Hempstead | Arkansas | 5057 | 4567 | 68 |
2480167 | 2480167 | 2022-05-07 | Hempstead | Arkansas | 5057 | 4567 | 68 |
2452358 | 2452358 | 2022-04-28 | Hill | Montana | 30041 | 4567 | 73 |
2453038 | 2453038 | 2022-04-28 | Montour | Pennsylvania | 42093 | 4567 | 93 |
2449102 | 2449102 | 2022-04-27 | Hill | Montana | 30041 | 4567 | 73 |
2440913 | 2440913 | 2022-04-24 | Sawyer | Wisconsin | 55113 | 4567 | 62 |
2437657 | 2437657 | 2022-04-23 | Sawyer | Wisconsin | 55113 | 4567 | 62 |
2434401 | 2434401 | 2022-04-22 | Sawyer | Wisconsin | 55113 | 4567 | 62 |
2431145 | 2431145 | 2022-04-21 | Sawyer | Wisconsin | 55113 | 4567 | 62 |
2320095 | 2320095 | 2022-03-18 | Panola | Texas | 48365 | 4567 | 129 |
2302100 | 2302100 | 2022-03-13 | Mason | Kentucky | 21161 | 4567 | 98 |
2298848 | 2298848 | 2022-03-12 | Mason | Kentucky | 21161 | 4567 | 98 |
2295596 | 2295596 | 2022-03-11 | Mason | Kentucky | 21161 | 4567 | 98 |
2292344 | 2292344 | 2022-03-10 | Mason | Kentucky | 21161 | 4567 | 98 |
2289092 | 2289092 | 2022-03-09 | Mason | Kentucky | 21161 | 4567 | 98 |
2290480 | 2290480 | 2022-03-09 | Beadle | South Dakota | 46005 | 4567 | 57 |
2285841 | 2285841 | 2022-03-08 | Mason | Kentucky | 21161 | 4567 | 98 |
2282589 | 2282589 | 2022-03-07 | Mason | Kentucky | 21161 | 4567 | 98 |
2273868 | 2273868 | 2022-03-04 | Meigs | Ohio | 39105 | 4567 | 80 |
2251334 | 2251334 | 2022-02-25 | Barranquitas | Puerto Rico | 72019 | 4567 | |
2213496 | 2213496 | 2022-02-14 | Elbert | Colorado | 8039 | 4567 | 36 |
2180828 | 2180828 | 2022-02-04 | Cross | Arkansas | 5037 | 4567 | 75 |
2153025 | 2153025 | 2022-01-26 | Vernon | Missouri | 29217 | 4567 | 93 |
2142145 | 2142145 | 2022-01-23 | McDuffie | Georgia | 13189 | 4567 | 83 |
2144311 | 2144311 | 2022-01-23 | Burleson | Texas | 48051 | 4567 | 62 |
2138890 | 2138890 | 2022-01-22 | McDuffie | Georgia | 13189 | 4567 | 83 |
2135634 | 2135634 | 2022-01-21 | McDuffie | Georgia | 13189 | 4567 | 83 |
2123949 | 2123949 | 2022-01-17 | Unknown | New Jersey | 4567 | 1 | |
2080160 | 2080160 | 2022-01-04 | Pitkin | Colorado | 8097 | 4567 | 6 |
2080638 | 2080638 | 2022-01-04 | Randolph | Indiana | 18135 | 4567 | 121 |
2056899 | 2056899 | 2021-12-27 | Russell | Virginia | 51167 | 4567 | 74 |
2032253 | 2032253 | 2021-12-20 | East Feliciana | Louisiana | 22037 | 4567 | 145 |
2017295 | 2017295 | 2021-12-15 | Edgefield | South Carolina | 45037 | 4567 | 60 |
2014045 | 2014045 | 2021-12-14 | Edgefield | South Carolina | 45037 | 4567 | 60 |
1974433 | 1974433 | 2021-12-02 | Luna | New Mexico | 35029 | 4567 | 97 |
1955226 | 1955226 | 2021-11-26 | Pike | Ohio | 39131 | 4567 | 76 |
1943972 | 1943972 | 2021-11-23 | Fayette | Illinois | 17051 | 4567 | 72 |
1890499 | 1890499 | 2021-11-06 | Trujillo Alto | Puerto Rico | 72139 | 4567 | |
1848985 | 1848985 | 2021-10-24 | Mingo | West Virginia | 54059 | 4567 | 79 |
1832889 | 1832889 | 2021-10-20 | Geneva | Alabama | 1061 | 4567 | 126 |
1829640 | 1829640 | 2021-10-19 | Geneva | Alabama | 1061 | 4567 | 126 |
1813599 | 1813599 | 2021-10-14 | Siskiyou | California | 6093 | 4567 | 59 |
1811533 | 1811533 | 2021-10-13 | Adams | Mississippi | 28001 | 4567 | 119 |
1796676 | 1796676 | 2021-10-08 | Palo Pinto | Texas | 48363 | 4567 | 109 |
1790509 | 1790509 | 2021-10-06 | Preston | West Virginia | 54077 | 4567 | 63 |
1780528 | 1780528 | 2021-10-03 | Uintah | Utah | 49047 | 4567 | 39 |
1777278 | 1777278 | 2021-10-02 | Uintah | Utah | 49047 | 4567 | 39 |
1774028 | 1774028 | 2021-10-01 | Uintah | Utah | 49047 | 4567 | 39 |
1697194 | 1697194 | 2021-09-08 | Wabash | Indiana | 18169 | 4567 | 88 |
1695893 | 1695893 | 2021-09-07 | Hopkins | Texas | 48223 | 4567 | 126 |
1669883 | 1669883 | 2021-08-30 | Grimes | Texas | 48185 | 4567 | 76 |
1631711 | 1631711 | 2021-08-19 | La Plata | Colorado | 8067 | 4567 | 45 |
1598305 | 1598305 | 2021-08-08 | Rhea | Tennessee | 47143 | 4567 | 83 |
1595056 | 1595056 | 2021-08-07 | Rhea | Tennessee | 47143 | 4567 | 83 |
1591807 | 1591807 | 2021-08-06 | Rhea | Tennessee | 47143 | 4567 | 83 |
1574831 | 1574831 | 2021-08-01 | Livingston | New York | 36051 | 4567 | 60 |
1563951 | 1563951 | 2021-07-29 | Harrison | Indiana | 18061 | 4567 | 79 |
1543849 | 1543849 | 2021-07-23 | Boone | Arkansas | 5009 | 4567 | 81 |
1484773 | 1484773 | 2021-07-04 | Hill | Texas | 48217 | 4567 | 111 |
1481527 | 1481527 | 2021-07-03 | Hill | Texas | 48217 | 4567 | 111 |
1478280 | 1478280 | 2021-07-02 | Hill | Texas | 48217 | 4567 | 111 |
1475034 | 1475034 | 2021-07-01 | Hill | Texas | 48217 | 4567 | 110 |
1448211 | 1448211 | 2021-06-23 | Madison | New York | 36053 | 4567 | 89 |
1430638 | 1430638 | 2021-06-18 | Thomas | Georgia | 13275 | 4567 | 124 |
1415984 | 1415984 | 2021-06-13 | Knox | Ohio | 39083 | 4567 | 112 |
1412738 | 1412738 | 2021-06-12 | Knox | Ohio | 39083 | 4567 | 112 |
1395871 | 1395871 | 2021-06-07 | Marshall | Mississippi | 28093 | 4567 | 105 |
1378058 | 1378058 | 2021-06-01 | Marion | West Virginia | 54049 | 4567 | 51 |
1338777 | 1338777 | 2021-05-20 | Nacogdoches | Texas | 48347 | 4567 | 171 |
1312545 | 1312545 | 2021-05-12 | Cheatham | Tennessee | 47021 | 4567 | 56 |
1296890 | 1296890 | 2021-05-07 | Jefferson | West Virginia | 54037 | 4567 | 50 |
1218496 | 1218496 | 2021-04-13 | Burnet | Texas | 48053 | 4567 | 63 |
1193745 | 1193745 | 2021-04-06 | Henry | Illinois | 17073 | 4567 | 89 |
1137107 | 1137107 | 2021-03-19 | Newberry | South Carolina | 45071 | 4567 | 93 |
1126186 | 1126186 | 2021-03-16 | Grand Traverse | Michigan | 26055 | 4567 | 73 |
1105933 | 1105933 | 2021-03-10 | Murray | Georgia | 13213 | 4567 | 76 |
1108524 | 1108524 | 2021-03-10 | Skagit | Washington | 53057 | 4567 | 61 |
1104257 | 1104257 | 2021-03-09 | Auglaize | Ohio | 39011 | 4567 | 82 |
1088684 | 1088684 | 2021-03-04 | Harrison | Texas | 48203 | 4567 | 95 |
1058172 | 1058172 | 2021-02-23 | Bolivar | Mississippi | 28011 | 4567 | 120 |
1040544 | 1040544 | 2021-02-18 | Dale | Alabama | 1045 | 4567 | 105 |
1041380 | 1041380 | 2021-02-18 | Marshall | Iowa | 19127 | 4567 | 70 |
1010166 | 1010166 | 2021-02-08 | Huron | Ohio | 39077 | 4567 | 85 |
980400 | 980400 | 2021-01-30 | Joplin | Missouri | 4567 | 94 | |
974555 | 974555 | 2021-01-28 | McClain | Oklahoma | 40087 | 4567 | 38 |
952907 | 952907 | 2021-01-22 | Coffee | Alabama | 1031 | 4567 | 62 |
930932 | 930932 | 2021-01-15 | Noble | Indiana | 18113 | 4567 | 60 |
920778 | 920778 | 2021-01-12 | Gadsden | Florida | 12039 | 4567 | 62 |
880468 | 880468 | 2020-12-30 | Wagoner | Oklahoma | 40145 | 4567 | 45 |
868473 | 868473 | 2020-12-26 | Sauk | Wisconsin | 55111 | 4567 | 31 |
865228 | 865228 | 2020-12-25 | Sauk | Wisconsin | 55111 | 4567 | 31 |
755544 | 755544 | 2020-11-22 | DeKalb | Illinois | 17037 | 4567 | 45 |
758127 | 758127 | 2020-11-22 | Portage | Wisconsin | 55097 | 4567 | 37 |
744472 | 744472 | 2020-11-18 | Bradley | Tennessee | 47011 | 4567 | 30 |
739121 | 739121 | 2020-11-17 | Coweta | Georgia | 13077 | 4567 | 68 |
735390 | 735390 | 2020-11-15 | Manitowoc | Wisconsin | 55071 | 4567 | 33 |
717383 | 717383 | 2020-11-10 | St. Louis | Minnesota | 27137 | 4567 | 77 |
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);