ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where cases = 6129 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Tennessee 8
- Pennsylvania 7
- Indiana 6
- Minnesota 6
- Arkansas 5
- Virginia 4
- Wyoming 4
- Alaska 3
- California 3
- Ohio 3
- Texas 3
- Wisconsin 3
- Georgia 2
- Illinois 2
- Kentucky 2
- New York 2
- Puerto Rico 2
- Alabama 1
- Colorado 1
- Florida 1
- Massachusetts 1
- Michigan 1
- Mississippi 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493177 | 2493177 | 2022-05-11 | Carroll | Arkansas | 5015 | 6129 | 102 |
2476914 | 2476914 | 2022-05-06 | Jackson | Arkansas | 5067 | 6129 | 63 |
2473656 | 2473656 | 2022-05-05 | Jackson | Arkansas | 5067 | 6129 | 63 |
2470399 | 2470399 | 2022-05-04 | Jackson | Arkansas | 5067 | 6129 | 63 |
2394527 | 2394527 | 2022-04-10 | Vega Alta | Puerto Rico | 72143 | 6129 | |
2354940 | 2354940 | 2022-03-29 | Lewis | New York | 36049 | 6129 | 49 |
2351687 | 2351687 | 2022-03-28 | Lewis | New York | 36049 | 6129 | 49 |
2314531 | 2314531 | 2022-03-17 | Peach | Georgia | 13225 | 6129 | 125 |
2263100 | 2263100 | 2022-03-01 | Russell | Kentucky | 21207 | 6129 | 79 |
2246358 | 2246358 | 2022-02-24 | Crawford | Illinois | 17033 | 6129 | 58 |
2223277 | 2223277 | 2022-02-17 | Pitkin | Colorado | 8097 | 6129 | 6 |
2077950 | 2077950 | 2022-01-03 | Carlton | Minnesota | 27017 | 6129 | 80 |
2075901 | 2075901 | 2022-01-02 | Carroll | Tennessee | 47017 | 6129 | 127 |
2072190 | 2072190 | 2022-01-01 | Coshocton | Ohio | 39031 | 6129 | 131 |
2072650 | 2072650 | 2022-01-01 | Carroll | Tennessee | 47017 | 6129 | 127 |
2068939 | 2068939 | 2021-12-31 | Coshocton | Ohio | 39031 | 6129 | 131 |
2069399 | 2069399 | 2021-12-31 | Carroll | Tennessee | 47017 | 6129 | 127 |
2066148 | 2066148 | 2021-12-30 | Carroll | Tennessee | 47017 | 6129 | 127 |
2017166 | 2017166 | 2021-12-15 | McKean | Pennsylvania | 42083 | 6129 | 111 |
1991134 | 1991134 | 2021-12-07 | Clarion | Pennsylvania | 42031 | 6129 | 157 |
1978635 | 1978635 | 2021-12-03 | Matagorda | Texas | 48321 | 6129 | 161 |
1918115 | 1918115 | 2021-11-15 | Putnam | Indiana | 18133 | 6129 | 85 |
1838509 | 1838509 | 2021-10-21 | Toa Baja | Puerto Rico | 72137 | 6129 | |
1834217 | 1834217 | 2021-10-20 | Itasca | Minnesota | 27061 | 6129 | 82 |
1806604 | 1806604 | 2021-10-11 | Henry | Virginia | 51089 | 6129 | 144 |
1803354 | 1803354 | 2021-10-10 | Henry | Virginia | 51089 | 6129 | 144 |
1800105 | 1800105 | 2021-10-09 | Henry | Virginia | 51089 | 6129 | 144 |
1796856 | 1796856 | 2021-10-08 | Henry | Virginia | 51089 | 6129 | 144 |
1759550 | 1759550 | 2021-09-27 | Bolivar | Mississippi | 28011 | 6129 | 145 |
1754750 | 1754750 | 2021-09-25 | Jefferson | West Virginia | 54037 | 6129 | 72 |
1709461 | 1709461 | 2021-09-12 | Tallapoosa | Alabama | 1123 | 6129 | 163 |
1667815 | 1667815 | 2021-08-30 | Knox | Illinois | 17095 | 6129 | 188 |
1667147 | 1667147 | 2021-08-29 | Campbell | Wyoming | 56005 | 6129 | 67 |
1663899 | 1663899 | 2021-08-28 | Campbell | Wyoming | 56005 | 6129 | 67 |
1660651 | 1660651 | 2021-08-27 | Campbell | Wyoming | 56005 | 6129 | 67 |
1641259 | 1641259 | 2021-08-22 | Kenai Peninsula Borough | Alaska | 2122 | 6129 | 20 |
1638009 | 1638009 | 2021-08-21 | Kenai Peninsula Borough | Alaska | 2122 | 6129 | 20 |
1634759 | 1634759 | 2021-08-20 | Kenai Peninsula Borough | Alaska | 2122 | 6129 | 20 |
1632814 | 1632814 | 2021-08-19 | Otter Tail | Minnesota | 27111 | 6129 | 88 |
1582847 | 1582847 | 2021-08-04 | Hot Spring | Arkansas | 5059 | 6129 | 83 |
1578861 | 1578861 | 2021-08-02 | Caldwell | Texas | 48055 | 6129 | 100 |
1573736 | 1573736 | 2021-08-01 | Shelby | Indiana | 18145 | 6129 | 109 |
1570488 | 1570488 | 2021-07-31 | Shelby | Indiana | 18145 | 6129 | 109 |
1567240 | 1567240 | 2021-07-30 | Shelby | Indiana | 18145 | 6129 | 109 |
1561067 | 1561067 | 2021-07-28 | Pike | Kentucky | 21195 | 6129 | 112 |
1517728 | 1517728 | 2021-07-14 | Waupaca | Wisconsin | 55135 | 6129 | 167 |
1455102 | 1455102 | 2021-06-25 | Bradford | Pennsylvania | 42015 | 6129 | 94 |
1451857 | 1451857 | 2021-06-24 | Bradford | Pennsylvania | 42015 | 6129 | 94 |
1377260 | 1377260 | 2021-06-01 | Union | Pennsylvania | 42119 | 6129 | 87 |
1363294 | 1363294 | 2021-05-28 | Chisago | Minnesota | 27025 | 6129 | 52 |
1333487 | 1333487 | 2021-05-19 | Marshall | Indiana | 18099 | 6129 | 114 |
1319709 | 1319709 | 2021-05-14 | Sauk | Wisconsin | 55111 | 6129 | 54 |
1314532 | 1314532 | 2021-05-13 | Isabella | Michigan | 26073 | 6129 | 91 |
1312571 | 1312571 | 2021-05-12 | Hawkins | Tennessee | 47073 | 6129 | 107 |
1263880 | 1263880 | 2021-04-27 | Jefferson | Tennessee | 47089 | 6129 | 124 |
1250944 | 1250944 | 2021-04-23 | Anderson | Texas | 48001 | 6129 | 118 |
1197717 | 1197717 | 2021-04-07 | Kandiyohi | Minnesota | 27067 | 6129 | 79 |
1150180 | 1150180 | 2021-03-23 | Carter | Tennessee | 47019 | 6129 | 155 |
1122036 | 1122036 | 2021-03-15 | Monroe | Florida | 12087 | 6129 | 47 |
1101033 | 1101033 | 2021-03-08 | Geauga | Ohio | 39055 | 6129 | 142 |
1086670 | 1086670 | 2021-03-04 | Boone | Indiana | 18011 | 6129 | 94 |
946931 | 946931 | 2021-01-20 | Troup | Georgia | 13285 | 6129 | 148 |
876342 | 876342 | 2020-12-29 | Clay | Minnesota | 27027 | 6129 | 77 |
845787 | 845787 | 2020-12-19 | Natrona | Wyoming | 56025 | 6129 | 74 |
815917 | 815917 | 2020-12-10 | Madison | Tennessee | 47113 | 6129 | 125 |
816524 | 816524 | 2020-12-10 | Manitowoc | Wisconsin | 55071 | 6129 | 42 |
777869 | 777869 | 2020-11-29 | San Luis Obispo | California | 6079 | 6129 | 36 |
774624 | 774624 | 2020-11-28 | San Luis Obispo | California | 6079 | 6129 | 36 |
771379 | 771379 | 2020-11-27 | San Luis Obispo | California | 6079 | 6129 | 36 |
761238 | 761238 | 2020-11-23 | Franklin | Washington | 53021 | 6129 | 72 |
643678 | 643678 | 2020-10-18 | Lehigh | Pennsylvania | 42077 | 6129 | 362 |
494632 | 494632 | 2020-09-02 | Berks | Pennsylvania | 42011 | 6129 | 382 |
107888 | 107888 | 2020-05-02 | Worcester | Massachusetts | 25027 | 6129 | 292 |
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);