ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 6099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Virginia 9
- Washington 7
- Florida 5
- North Carolina 5
- Pennsylvania 5
- Kentucky 4
- Tennessee 4
- Missouri 3
- Ohio 3
- Puerto Rico 3
- Texas 3
- Arkansas 2
- Kansas 2
- New York 2
- South Carolina 2
- Wisconsin 2
- Alabama 1
- California 1
- Illinois 1
- Minnesota 1
- Mississippi 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495811 | 2495811 | 2022-05-11 | Jasper | Texas | 48241 | 6099 | 187 |
2433540 | 2433540 | 2022-04-22 | Cayey | Puerto Rico | 72035 | 6099 | |
2424429 | 2424429 | 2022-04-19 | Mecklenburg | Virginia | 51117 | 6099 | 119 |
2388977 | 2388977 | 2022-04-09 | Carroll | Arkansas | 5015 | 6099 | 102 |
2355470 | 2355470 | 2022-03-29 | San Sebastian | Puerto Rico | 72131 | 6099 | |
2352217 | 2352217 | 2022-03-28 | San Sebastian | Puerto Rico | 72131 | 6099 | |
2336542 | 2336542 | 2022-03-23 | Hopewell city | Virginia | 51670 | 6099 | 118 |
2329038 | 2329038 | 2022-03-21 | Transylvania | North Carolina | 37175 | 6099 | 69 |
2316025 | 2316025 | 2022-03-17 | Transylvania | North Carolina | 37175 | 6099 | 69 |
2293982 | 2293982 | 2022-03-10 | Gray | Texas | 48179 | 6099 | 122 |
2281248 | 2281248 | 2022-03-06 | Hopewell city | Virginia | 51670 | 6099 | 119 |
2276875 | 2276875 | 2022-03-05 | Lewis | New York | 36049 | 6099 | 47 |
2277995 | 2277995 | 2022-03-05 | Hopewell city | Virginia | 51670 | 6099 | 119 |
2274742 | 2274742 | 2022-03-04 | Hopewell city | Virginia | 51670 | 6099 | 119 |
2269549 | 2269549 | 2022-03-03 | Harrison | Kentucky | 21097 | 6099 | 62 |
2264984 | 2264984 | 2022-03-01 | Hopewell city | Virginia | 51670 | 6099 | 117 |
2206755 | 2206755 | 2022-02-12 | Geneva | Alabama | 1061 | 6099 | 146 |
2125222 | 2125222 | 2022-01-17 | Okanogan | Washington | 53047 | 6099 | 106 |
2121970 | 2121970 | 2022-01-16 | Okanogan | Washington | 53047 | 6099 | 106 |
2118718 | 2118718 | 2022-01-15 | Okanogan | Washington | 53047 | 6099 | 106 |
2115466 | 2115466 | 2022-01-14 | Okanogan | Washington | 53047 | 6099 | 106 |
2078166 | 2078166 | 2022-01-03 | Laclede | Missouri | 29105 | 6099 | 153 |
2053672 | 2053672 | 2021-12-26 | York | Virginia | 51199 | 6099 | 84 |
2050422 | 2050422 | 2021-12-25 | York | Virginia | 51199 | 6099 | 84 |
2047172 | 2047172 | 2021-12-24 | York | Virginia | 51199 | 6099 | 84 |
1972949 | 1972949 | 2021-12-02 | Hardee | Florida | 12049 | 6099 | 103 |
1969699 | 1969699 | 2021-12-01 | Hardee | Florida | 12049 | 6099 | 103 |
1966449 | 1966449 | 2021-11-30 | Hardee | Florida | 12049 | 6099 | 103 |
1864194 | 1864194 | 2021-10-29 | Guernsey | Ohio | 39059 | 6099 | 73 |
1812195 | 1812195 | 2021-10-13 | Crawford | Ohio | 39033 | 6099 | 127 |
1808448 | 1808448 | 2021-10-12 | Phelps | Missouri | 29161 | 6099 | 178 |
1738558 | 1738558 | 2021-09-20 | Dunn | Wisconsin | 55033 | 6099 | 40 |
1610966 | 1610966 | 2021-08-12 | Armstrong | Pennsylvania | 42005 | 6099 | 148 |
1611863 | 1611863 | 2021-08-12 | Columbia | Wisconsin | 55021 | 6099 | 73 |
1575551 | 1575551 | 2021-08-01 | Monroe | Tennessee | 47123 | 6099 | 98 |
1576056 | 1576056 | 2021-08-01 | Walla Walla | Washington | 53071 | 6099 | 72 |
1572303 | 1572303 | 2021-07-31 | Monroe | Tennessee | 47123 | 6099 | 98 |
1572808 | 1572808 | 2021-07-31 | Walla Walla | Washington | 53071 | 6099 | 72 |
1569055 | 1569055 | 2021-07-30 | Monroe | Tennessee | 47123 | 6099 | 98 |
1569560 | 1569560 | 2021-07-30 | Walla Walla | Washington | 53071 | 6099 | 72 |
1469279 | 1469279 | 2021-06-30 | San Benito | California | 6069 | 6099 | 63 |
1412907 | 1412907 | 2021-06-12 | Bradford | Pennsylvania | 42015 | 6099 | 92 |
1340775 | 1340775 | 2021-05-21 | Joplin | Missouri | 6099 | 108 | |
1329615 | 1329615 | 2021-05-18 | Crittenden | Arkansas | 5035 | 6099 | 97 |
1279819 | 1279819 | 2021-05-02 | Carbon | Pennsylvania | 42025 | 6099 | 167 |
1243276 | 1243276 | 2021-04-21 | Lafayette | Mississippi | 28071 | 6099 | 118 |
1234020 | 1234020 | 2021-04-18 | Duplin | North Carolina | 37061 | 6099 | 128 |
1230772 | 1230772 | 2021-04-17 | Duplin | North Carolina | 37061 | 6099 | 128 |
1227524 | 1227524 | 2021-04-16 | Duplin | North Carolina | 37061 | 6099 | 128 |
1216198 | 1216198 | 2021-04-13 | Jackson | Florida | 12063 | 6099 | 156 |
1194088 | 1194088 | 2021-04-06 | Saline | Kansas | 20169 | 6099 | 108 |
1190838 | 1190838 | 2021-04-05 | Saline | Kansas | 20169 | 6099 | 108 |
1187712 | 1187712 | 2021-04-04 | Pulaski | Kentucky | 21199 | 6099 | 93 |
1184465 | 1184465 | 2021-04-03 | Pulaski | Kentucky | 21199 | 6099 | 93 |
1181218 | 1181218 | 2021-04-02 | Pulaski | Kentucky | 21199 | 6099 | 93 |
1125615 | 1125615 | 2021-03-16 | Whiteside | Illinois | 17195 | 6099 | 193 |
1103525 | 1103525 | 2021-03-09 | Blue Earth | Minnesota | 27013 | 6099 | 37 |
1072276 | 1072276 | 2021-02-27 | Cumberland | Tennessee | 47035 | 6099 | 120 |
1055941 | 1055941 | 2021-02-22 | Georgetown | South Carolina | 45043 | 6099 | 132 |
993690 | 993690 | 2021-02-03 | Chemung | New York | 36015 | 6099 | 119 |
916389 | 916389 | 2021-01-10 | Lancaster | South Carolina | 45057 | 6099 | 95 |
912821 | 912821 | 2021-01-09 | Muskingum | Ohio | 39119 | 6099 | 39 |
838774 | 838774 | 2020-12-17 | Gregg | Texas | 48183 | 6099 | 137 |
734530 | 734530 | 2020-11-15 | Westmoreland | Pennsylvania | 42129 | 6099 | 135 |
430066 | 430066 | 2020-08-13 | Lancaster | Pennsylvania | 42071 | 6099 | 418 |
418444 | 418444 | 2020-08-10 | Brevard | Florida | 12009 | 6099 | 151 |
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);