ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 5582 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 6
- Indiana 5
- Arkansas 4
- Minnesota 4
- South Carolina 4
- Alabama 3
- Illinois 3
- Michigan 3
- Puerto Rico 3
- Florida 2
- Georgia 2
- Kansas 2
- Missouri 2
- New York 2
- Tennessee 2
- Virginia 2
- West Virginia 2
- Alaska 1
- Colorado 1
- Idaho 1
- Iowa 1
- New Jersey 1
- New Mexico 1
- North Carolina 1
- Ohio 1
- Oklahoma 1
- Pennsylvania 1
- South Dakota 1
- Texas 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453070 | 2453070 | 2022-04-28 | Cabo Rojo | Puerto Rico | 72023 | 5582 | |
2375609 | 2375609 | 2022-04-04 | Page | Virginia | 51139 | 5582 | 119 |
2362375 | 2362375 | 2022-03-31 | Moore | Texas | 48341 | 5582 | 110 |
2336680 | 2336680 | 2022-03-23 | McDowell | West Virginia | 54047 | 5582 | 67 |
2209098 | 2209098 | 2022-02-12 | Juana Diaz | Puerto Rico | 72075 | 5582 | |
2159511 | 2159511 | 2022-01-28 | Randolph | Missouri | 29175 | 5582 | 90 |
2143025 | 2143025 | 2022-01-23 | Le Sueur | Minnesota | 27079 | 5582 | 46 |
2139770 | 2139770 | 2022-01-22 | Le Sueur | Minnesota | 27079 | 5582 | 46 |
2136514 | 2136514 | 2022-01-21 | Le Sueur | Minnesota | 27079 | 5582 | 46 |
2133726 | 2133726 | 2022-01-20 | Luna | New Mexico | 35029 | 5582 | 110 |
2104112 | 2104112 | 2022-01-11 | Tippah | Mississippi | 28139 | 5582 | 88 |
2097622 | 2097622 | 2022-01-09 | Yazoo | Mississippi | 28163 | 5582 | 94 |
2094370 | 2094370 | 2022-01-08 | Yazoo | Mississippi | 28163 | 5582 | 94 |
2091118 | 2091118 | 2022-01-07 | Yazoo | Mississippi | 28163 | 5582 | 94 |
2080821 | 2080821 | 2022-01-04 | McPherson | Kansas | 20113 | 5582 | 102 |
2077569 | 2077569 | 2022-01-03 | McPherson | Kansas | 20113 | 5582 | 102 |
2035637 | 2035637 | 2021-12-21 | Houghton | Michigan | 26061 | 5582 | 66 |
2032387 | 2032387 | 2021-12-20 | Houghton | Michigan | 26061 | 5582 | 66 |
2020578 | 2020578 | 2021-12-16 | Brookings | South Dakota | 46011 | 5582 | 41 |
2017309 | 2017309 | 2021-12-15 | Marion | South Carolina | 45067 | 5582 | 143 |
1944088 | 1944088 | 2021-11-23 | Jefferson | Indiana | 18077 | 5582 | 105 |
1859534 | 1859534 | 2021-10-28 | Randolph | Illinois | 17157 | 5582 | 107 |
1856107 | 1856107 | 2021-10-27 | Pickens | Georgia | 13227 | 5582 | 114 |
1812548 | 1812548 | 2021-10-13 | Colleton | South Carolina | 45029 | 5582 | 188 |
1762726 | 1762726 | 2021-09-28 | Douglas | Minnesota | 27041 | 5582 | 84 |
1719170 | 1719170 | 2021-09-15 | Franklin | Alabama | 1059 | 5582 | 92 |
1716434 | 1716434 | 2021-09-14 | Wayne | Georgia | 13305 | 5582 | 122 |
1706021 | 1706021 | 2021-09-10 | Jefferson | West Virginia | 54037 | 5582 | 65 |
1605529 | 1605529 | 2021-08-11 | Kenai Peninsula Borough | Alaska | 2122 | 5582 | 20 |
1527637 | 1527637 | 2021-07-18 | Hot Spring | Arkansas | 5059 | 5582 | 78 |
1524390 | 1524390 | 2021-07-17 | Hot Spring | Arkansas | 5059 | 5582 | 78 |
1521142 | 1521142 | 2021-07-16 | Hot Spring | Arkansas | 5059 | 5582 | 78 |
1416761 | 1416761 | 2021-06-13 | Box Elder | Utah | 49003 | 5582 | 53 |
1387693 | 1387693 | 2021-06-04 | Pittsylvania | Virginia | 51143 | 5582 | 82 |
1367602 | 1367602 | 2021-05-29 | Unknown | Puerto Rico | 5582 | 2499 | |
1229177 | 1229177 | 2021-04-17 | Gadsden | Florida | 12039 | 5582 | 93 |
1174922 | 1174922 | 2021-03-31 | Midland | Michigan | 26111 | 5582 | 69 |
1158137 | 1158137 | 2021-03-26 | Marshall | Indiana | 18099 | 5582 | 107 |
1154856 | 1154856 | 2021-03-25 | Dearborn | Indiana | 18029 | 5582 | 75 |
1101522 | 1101522 | 2021-03-08 | Lawrence | Tennessee | 47099 | 5582 | 84 |
1098276 | 1098276 | 2021-03-07 | Lawrence | Tennessee | 47099 | 5582 | 83 |
1098854 | 1098854 | 2021-03-07 | Barron | Wisconsin | 55005 | 5582 | 76 |
1089820 | 1089820 | 2021-03-05 | Clinton | Illinois | 17027 | 5582 | 98 |
1042399 | 1042399 | 2021-02-18 | Ontario | New York | 36069 | 5582 | 88 |
1016008 | 1016008 | 2021-02-10 | Lafayette | Mississippi | 28071 | 5582 | 110 |
1000211 | 1000211 | 2021-02-05 | Oswego | New York | 36075 | 5582 | 85 |
967329 | 967329 | 2021-01-26 | Lowndes | Mississippi | 28087 | 5582 | 123 |
927517 | 927517 | 2021-01-14 | Madison | Idaho | 16065 | 5582 | 21 |
898421 | 898421 | 2021-01-05 | Williamson | Illinois | 17199 | 5582 | 107 |
895205 | 895205 | 2021-01-04 | Grant | Indiana | 18053 | 5582 | 106 |
888688 | 888688 | 2021-01-02 | Bartholomew | Indiana | 18005 | 5582 | 93 |
845836 | 845836 | 2020-12-20 | Lauderdale | Alabama | 1077 | 5582 | 64 |
789356 | 789356 | 2020-12-02 | Randolph | North Carolina | 37151 | 5582 | 88 |
753954 | 753954 | 2020-11-21 | Centre | Pennsylvania | 42027 | 5582 | 34 |
740850 | 740850 | 2020-11-17 | Canadian | Oklahoma | 40017 | 5582 | 25 |
728129 | 728129 | 2020-11-13 | Aiken | South Carolina | 45003 | 5582 | 91 |
673011 | 673011 | 2020-10-27 | Florence | South Carolina | 45041 | 5582 | 203 |
639636 | 639636 | 2020-10-17 | Boone | Missouri | 29019 | 5582 | 14 |
540937 | 540937 | 2020-09-17 | Lee | Alabama | 1081 | 5582 | 59 |
520042 | 520042 | 2020-09-10 | Somerset | New Jersey | 34035 | 5582 | 568 |
505630 | 505630 | 2020-09-06 | Alachua | Florida | 12001 | 5582 | 33 |
481547 | 481547 | 2020-08-29 | Montgomery | Ohio | 39113 | 5582 | 128 |
444180 | 444180 | 2020-08-18 | El Paso | Colorado | 8041 | 5582 | 145 |
415067 | 415067 | 2020-08-09 | Pulaski | Arkansas | 5119 | 5582 | 85 |
265938 | 265938 | 2020-06-23 | Polk | Iowa | 19153 | 5582 | 169 |
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);