ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where deaths = 810 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- California 18
- Kansas 14
- New Jersey 10
- Pennsylvania 9
- Oklahoma 8
- Colorado 7
- Florida 7
- Georgia 7
- South Carolina 7
- Ohio 5
- Arkansas 4
- Illinois 3
- Maryland 3
- Minnesota 3
- Texas 3
- Virginia 3
- Arizona 2
- Indiana 2
- Missouri 2
- New York 2
- Washington 2
- Alabama 1
- Connecticut 1
- Hawaii 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490131 | 2490131 | 2022-05-10 | Charlotte | Florida | 12015 | 36528 | 810 |
2486874 | 2486874 | 2022-05-09 | Charlotte | Florida | 12015 | 36528 | 810 |
2483616 | 2483616 | 2022-05-08 | Charlotte | Florida | 12015 | 36528 | 810 |
2480358 | 2480358 | 2022-05-07 | Charlotte | Florida | 12015 | 36528 | 810 |
2477100 | 2477100 | 2022-05-06 | Charlotte | Florida | 12015 | 36528 | 810 |
2473842 | 2473842 | 2022-05-05 | Charlotte | Florida | 12015 | 36110 | 810 |
2470585 | 2470585 | 2022-05-04 | Charlotte | Florida | 12015 | 36110 | 810 |
2395172 | 2395172 | 2022-04-10 | Virginia Beach city | Virginia | 51810 | 89405 | 810 |
2391916 | 2391916 | 2022-04-09 | Virginia Beach city | Virginia | 51810 | 89405 | 810 |
2388660 | 2388660 | 2022-04-08 | Virginia Beach city | Virginia | 51810 | 89405 | 810 |
2382845 | 2382845 | 2022-04-07 | Muscogee | Georgia | 13215 | 38149 | 810 |
2379590 | 2379590 | 2022-04-06 | Muscogee | Georgia | 13215 | 38146 | 810 |
2350026 | 2350026 | 2022-03-28 | Merced | California | 6047 | 71883 | 810 |
2346773 | 2346773 | 2022-03-27 | Merced | California | 6047 | 71842 | 810 |
2343520 | 2343520 | 2022-03-26 | Merced | California | 6047 | 71842 | 810 |
2340267 | 2340267 | 2022-03-25 | Merced | California | 6047 | 71842 | 810 |
2337014 | 2337014 | 2022-03-24 | Merced | California | 6047 | 71817 | 810 |
2333760 | 2333760 | 2022-03-23 | Merced | California | 6047 | 71798 | 810 |
2330506 | 2330506 | 2022-03-22 | Merced | California | 6047 | 71606 | 810 |
2327254 | 2327254 | 2022-03-21 | Merced | California | 6047 | 71602 | 810 |
2304387 | 2304387 | 2022-03-14 | Benton | Arkansas | 5007 | 66228 | 810 |
2301135 | 2301135 | 2022-03-13 | Benton | Arkansas | 5007 | 66195 | 810 |
2301480 | 2301480 | 2022-03-13 | Hall | Georgia | 13139 | 53431 | 810 |
2297883 | 2297883 | 2022-03-12 | Benton | Arkansas | 5007 | 66161 | 810 |
2298228 | 2298228 | 2022-03-12 | Hall | Georgia | 13139 | 53431 | 810 |
2294976 | 2294976 | 2022-03-11 | Hall | Georgia | 13139 | 53431 | 810 |
2277754 | 2277754 | 2022-03-05 | Jefferson | Texas | 48245 | 44483 | 810 |
2220435 | 2220435 | 2022-02-16 | Winnebago | Illinois | 17201 | 75153 | 810 |
2217184 | 2217184 | 2022-02-15 | Winnebago | Illinois | 17201 | 75062 | 810 |
2213933 | 2213933 | 2022-02-14 | Winnebago | Illinois | 17201 | 74996 | 810 |
2206183 | 2206183 | 2022-02-11 | Galveston | Texas | 48167 | 93106 | 810 |
2178226 | 2178226 | 2022-02-03 | St. Joseph | Indiana | 18141 | 68971 | 810 |
2180319 | 2180319 | 2022-02-03 | Williamson | Texas | 48491 | 125733 | 810 |
2173370 | 2173370 | 2022-02-01 | Charleston | South Carolina | 45019 | 106203 | 810 |
2170118 | 2170118 | 2022-01-31 | Charleston | South Carolina | 45019 | 105922 | 810 |
2102826 | 2102826 | 2022-01-11 | Imperial | California | 6025 | 45751 | 810 |
2105084 | 2105084 | 2022-01-11 | Richland | South Carolina | 45079 | 90724 | 810 |
2099575 | 2099575 | 2022-01-10 | Imperial | California | 6025 | 45279 | 810 |
2090174 | 2090174 | 2022-01-07 | Honolulu | Hawaii | 15003 | 95627 | 810 |
2081753 | 2081753 | 2022-01-04 | Rockland | New York | 36087 | 71182 | 810 |
2039406 | 2039406 | 2021-12-22 | Atlantic | New Jersey | 34001 | 44717 | 810 |
2036156 | 2036156 | 2021-12-21 | Atlantic | New Jersey | 34001 | 44475 | 810 |
2032906 | 2032906 | 2021-12-20 | Atlantic | New Jersey | 34001 | 44300 | 810 |
2033534 | 2033534 | 2021-12-20 | Anderson | South Carolina | 45007 | 38822 | 810 |
2029655 | 2029655 | 2021-12-19 | Atlantic | New Jersey | 34001 | 44103 | 810 |
2026404 | 2026404 | 2021-12-18 | Atlantic | New Jersey | 34001 | 43936 | 810 |
2006988 | 2006988 | 2021-12-12 | Orange | New York | 36071 | 65087 | 810 |
1995195 | 1995195 | 2021-12-08 | Snohomish | Washington | 53061 | 73778 | 810 |
1811667 | 1811667 | 2021-10-13 | Kansas City | Missouri | 62328 | 810 | |
1780068 | 1780068 | 2021-10-03 | Horry | South Carolina | 45051 | 59821 | 810 |
1776818 | 1776818 | 2021-10-02 | Horry | South Carolina | 45051 | 59821 | 810 |
1773568 | 1773568 | 2021-10-01 | Horry | South Carolina | 45051 | 59821 | 810 |
1714973 | 1714973 | 2021-09-13 | Westmoreland | Pennsylvania | 42129 | 38211 | 810 |
1711727 | 1711727 | 2021-09-12 | Westmoreland | Pennsylvania | 42129 | 38091 | 810 |
1708480 | 1708480 | 2021-09-11 | Westmoreland | Pennsylvania | 42129 | 37986 | 810 |
1705233 | 1705233 | 2021-09-10 | Westmoreland | Pennsylvania | 42129 | 37831 | 810 |
1677079 | 1677079 | 2021-09-02 | Pulaski | Arkansas | 5119 | 54486 | 810 |
1632374 | 1632374 | 2021-08-19 | Johnson | Kansas | 20091 | 67036 | 810 |
1629127 | 1629127 | 2021-08-18 | Johnson | Kansas | 20091 | 67036 | 810 |
1625880 | 1625880 | 2021-08-17 | Johnson | Kansas | 20091 | 66528 | 810 |
1622633 | 1622633 | 2021-08-16 | Johnson | Kansas | 20091 | 66528 | 810 |
1608804 | 1608804 | 2021-08-12 | Mohave | Arizona | 4015 | 26500 | 810 |
1573943 | 1573943 | 2021-08-01 | Sedgwick | Kansas | 20173 | 59910 | 810 |
1570695 | 1570695 | 2021-07-31 | Sedgwick | Kansas | 20173 | 59910 | 810 |
1567447 | 1567447 | 2021-07-30 | Sedgwick | Kansas | 20173 | 59910 | 810 |
1564199 | 1564199 | 2021-07-29 | Sedgwick | Kansas | 20173 | 59650 | 810 |
1560951 | 1560951 | 2021-07-28 | Sedgwick | Kansas | 20173 | 59650 | 810 |
1557704 | 1557704 | 2021-07-27 | Sedgwick | Kansas | 20173 | 59410 | 810 |
1554457 | 1554457 | 2021-07-26 | Sedgwick | Kansas | 20173 | 59410 | 810 |
1551210 | 1551210 | 2021-07-25 | Sedgwick | Kansas | 20173 | 59200 | 810 |
1547963 | 1547963 | 2021-07-24 | Sedgwick | Kansas | 20173 | 59200 | 810 |
1544716 | 1544716 | 2021-07-23 | Sedgwick | Kansas | 20173 | 59200 | 810 |
1534266 | 1534266 | 2021-07-20 | Jefferson | Colorado | 8059 | 49480 | 810 |
1531019 | 1531019 | 2021-07-19 | Jefferson | Colorado | 8059 | 49480 | 810 |
1527772 | 1527772 | 2021-07-18 | Jefferson | Colorado | 8059 | 49393 | 810 |
1524525 | 1524525 | 2021-07-17 | Jefferson | Colorado | 8059 | 49393 | 810 |
1521277 | 1521277 | 2021-07-16 | Jefferson | Colorado | 8059 | 49393 | 810 |
1518029 | 1518029 | 2021-07-15 | Jefferson | Colorado | 8059 | 49361 | 810 |
1427060 | 1427060 | 2021-06-17 | Contra Costa | California | 6013 | 70478 | 810 |
1423815 | 1423815 | 2021-06-16 | Contra Costa | California | 6013 | 70428 | 810 |
1420567 | 1420567 | 2021-06-15 | Contra Costa | California | 6013 | 70389 | 810 |
1417322 | 1417322 | 2021-06-14 | Contra Costa | California | 6013 | 70358 | 810 |
1414076 | 1414076 | 2021-06-13 | Contra Costa | California | 6013 | 70328 | 810 |
1396518 | 1396518 | 2021-06-07 | Lucas | Ohio | 39095 | 43203 | 810 |
1393271 | 1393271 | 2021-06-06 | Lucas | Ohio | 39095 | 43187 | 810 |
1390026 | 1390026 | 2021-06-05 | Lucas | Ohio | 39095 | 43178 | 810 |
1386781 | 1386781 | 2021-06-04 | Lucas | Ohio | 39095 | 43166 | 810 |
1364284 | 1364284 | 2021-05-28 | York | Pennsylvania | 42133 | 46271 | 810 |
1361011 | 1361011 | 2021-05-27 | Luzerne | Pennsylvania | 42079 | 31727 | 810 |
1342669 | 1342669 | 2021-05-22 | Contra Costa | California | 6013 | 69288 | 810 |
1329535 | 1329535 | 2021-05-18 | Mobile | Alabama | 1097 | 41331 | 810 |
1310272 | 1310272 | 2021-05-12 | El Paso | Colorado | 8041 | 66796 | 810 |
1211160 | 1211160 | 2021-04-11 | Somerset | New Jersey | 34035 | 28088 | 810 |
1207911 | 1207911 | 2021-04-10 | Somerset | New Jersey | 34035 | 28007 | 810 |
1204663 | 1204663 | 2021-04-09 | Somerset | New Jersey | 34035 | 27870 | 810 |
1201415 | 1201415 | 2021-04-08 | Somerset | New Jersey | 34035 | 27734 | 810 |
1149847 | 1149847 | 2021-03-23 | Oklahoma | Oklahoma | 40109 | 82710 | 810 |
1146600 | 1146600 | 2021-03-22 | Oklahoma | Oklahoma | 40109 | 82710 | 810 |
1143353 | 1143353 | 2021-03-21 | Oklahoma | Oklahoma | 40109 | 82710 | 810 |
1140106 | 1140106 | 2021-03-20 | Oklahoma | Oklahoma | 40109 | 82710 | 810 |
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);