ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where deaths = 815 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 23
- Pennsylvania 16
- California 13
- Alabama 9
- Texas 8
- Georgia 7
- Louisiana 6
- New Jersey 6
- Maryland 4
- Arizona 3
- Massachusetts 3
- Delaware 2
- Missouri 2
- Colorado 1
- Hawaii 1
- Illinois 1
- Kentucky 1
- Michigan 1
- Minnesota 1
- North Carolina 1
- South Carolina 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2408193 | 2408193 | 2022-04-14 | Virginia Beach city | Virginia | 51810 | 89636 | 815 |
2395581 | 2395581 | 2022-04-11 | Merced | California | 6047 | 72189 | 815 |
2392325 | 2392325 | 2022-04-10 | Merced | California | 6047 | 72121 | 815 |
2389069 | 2389069 | 2022-04-09 | Merced | California | 6047 | 72121 | 815 |
2385814 | 2385814 | 2022-04-08 | Merced | California | 6047 | 72121 | 815 |
2382559 | 2382559 | 2022-04-07 | Merced | California | 6047 | 72093 | 815 |
2379304 | 2379304 | 2022-04-06 | Merced | California | 6047 | 72062 | 815 |
2376050 | 2376050 | 2022-04-05 | Merced | California | 6047 | 72038 | 815 |
2324250 | 2324250 | 2022-03-20 | Hall | Georgia | 13139 | 53516 | 815 |
2320996 | 2320996 | 2022-03-19 | Hall | Georgia | 13139 | 53516 | 815 |
2317742 | 2317742 | 2022-03-18 | Hall | Georgia | 13139 | 53516 | 815 |
2294015 | 2294015 | 2022-03-10 | Jefferson | Texas | 48245 | 44856 | 815 |
2225693 | 2225693 | 2022-02-17 | Galveston | Texas | 48167 | 94029 | 815 |
2220243 | 2220243 | 2022-02-16 | Richmond | Georgia | 13245 | 49113 | 815 |
2222442 | 2222442 | 2022-02-16 | Galveston | Texas | 48167 | 93957 | 815 |
2177497 | 2177497 | 2022-02-03 | Montgomery | Alabama | 1101 | 52692 | 815 |
2177552 | 2177552 | 2022-02-03 | Navajo | Arizona | 4017 | 35832 | 815 |
2179044 | 2179044 | 2022-02-03 | St. Charles | Missouri | 29183 | 98845 | 815 |
2174244 | 2174244 | 2022-02-02 | Montgomery | Alabama | 1101 | 52692 | 815 |
2174299 | 2174299 | 2022-02-02 | Navajo | Arizona | 4017 | 35587 | 815 |
2171047 | 2171047 | 2022-02-01 | Navajo | Arizona | 4017 | 35470 | 815 |
2130930 | 2130930 | 2022-01-19 | Dauphin | Pennsylvania | 42043 | 53531 | 815 |
2125809 | 2125809 | 2022-01-18 | Clayton | Georgia | 13063 | 55380 | 815 |
2122557 | 2122557 | 2022-01-17 | Clayton | Georgia | 13063 | 55165 | 815 |
2106431 | 2106431 | 2022-01-12 | Honolulu | Hawaii | 15003 | 109185 | 815 |
2058904 | 2058904 | 2021-12-28 | Atlantic | New Jersey | 34001 | 46696 | 815 |
1965165 | 1965165 | 2021-11-29 | Northampton | Pennsylvania | 42095 | 48397 | 815 |
1961913 | 1961913 | 2021-11-28 | Northampton | Pennsylvania | 42095 | 48274 | 815 |
1958662 | 1958662 | 2021-11-27 | Northampton | Pennsylvania | 42095 | 48147 | 815 |
1955411 | 1955411 | 2021-11-26 | Northampton | Pennsylvania | 42095 | 48053 | 815 |
1952160 | 1952160 | 2021-11-25 | Northampton | Pennsylvania | 42095 | 47879 | 815 |
1891677 | 1891677 | 2021-11-07 | Citrus | Florida | 12017 | 20464 | 815 |
1888427 | 1888427 | 2021-11-06 | Citrus | Florida | 12017 | 20464 | 815 |
1885177 | 1885177 | 2021-11-05 | Citrus | Florida | 12017 | 20464 | 815 |
1881928 | 1881928 | 2021-11-04 | Citrus | Florida | 12017 | 20392 | 815 |
1878679 | 1878679 | 2021-11-03 | Citrus | Florida | 12017 | 20392 | 815 |
1875430 | 1875430 | 2021-11-02 | Citrus | Florida | 12017 | 20392 | 815 |
1872181 | 1872181 | 2021-11-01 | Citrus | Florida | 12017 | 20392 | 815 |
1868932 | 1868932 | 2021-10-31 | Citrus | Florida | 12017 | 20392 | 815 |
1851751 | 1851751 | 2021-10-25 | Brazoria | Texas | 48039 | 59168 | 815 |
1848501 | 1848501 | 2021-10-24 | Brazoria | Texas | 48039 | 59168 | 815 |
1845251 | 1845251 | 2021-10-23 | Brazoria | Texas | 48039 | 59168 | 815 |
1813737 | 1813737 | 2021-10-14 | Osceola | Florida | 12097 | 70591 | 815 |
1810488 | 1810488 | 2021-10-13 | Osceola | Florida | 12097 | 70591 | 815 |
1807239 | 1807239 | 2021-10-12 | Osceola | Florida | 12097 | 70591 | 815 |
1803988 | 1803988 | 2021-10-11 | Osceola | Florida | 12097 | 70591 | 815 |
1800739 | 1800739 | 2021-10-10 | Osceola | Florida | 12097 | 70591 | 815 |
1797490 | 1797490 | 2021-10-09 | Osceola | Florida | 12097 | 70591 | 815 |
1794241 | 1794241 | 2021-10-08 | Osceola | Florida | 12097 | 70591 | 815 |
1790993 | 1790993 | 2021-10-07 | Osceola | Florida | 12097 | 70069 | 815 |
1787744 | 1787744 | 2021-10-06 | Osceola | Florida | 12097 | 70069 | 815 |
1784495 | 1784495 | 2021-10-05 | Osceola | Florida | 12097 | 70069 | 815 |
1781246 | 1781246 | 2021-10-04 | Osceola | Florida | 12097 | 70069 | 815 |
1777996 | 1777996 | 2021-10-03 | Osceola | Florida | 12097 | 70069 | 815 |
1740583 | 1740583 | 2021-09-21 | Guilford | North Carolina | 37081 | 61326 | 815 |
1721469 | 1721469 | 2021-09-15 | Westmoreland | Pennsylvania | 42129 | 38466 | 815 |
1582982 | 1582982 | 2021-08-04 | Jefferson | Colorado | 8059 | 50581 | 815 |
1580614 | 1580614 | 2021-08-03 | Orleans | Louisiana | 22071 | 36328 | 815 |
1456271 | 1456271 | 2021-06-26 | Contra Costa | California | 6013 | 71000 | 815 |
1386976 | 1386976 | 2021-06-04 | Luzerne | Pennsylvania | 42079 | 31886 | 815 |
1387003 | 1387003 | 2021-06-04 | York | Pennsylvania | 42133 | 46516 | 815 |
1383731 | 1383731 | 2021-06-03 | Luzerne | Pennsylvania | 42079 | 31857 | 815 |
1383758 | 1383758 | 2021-06-03 | York | Pennsylvania | 42133 | 46465 | 815 |
1371742 | 1371742 | 2021-05-31 | Mobile | Alabama | 1097 | 41551 | 815 |
1368496 | 1368496 | 2021-05-30 | Mobile | Alabama | 1097 | 41551 | 815 |
1365250 | 1365250 | 2021-05-29 | Mobile | Alabama | 1097 | 41551 | 815 |
1362004 | 1362004 | 2021-05-28 | Mobile | Alabama | 1097 | 41551 | 815 |
1358758 | 1358758 | 2021-05-27 | Mobile | Alabama | 1097 | 41515 | 815 |
1355512 | 1355512 | 2021-05-26 | Mobile | Alabama | 1097 | 41475 | 815 |
1352266 | 1352266 | 2021-05-25 | Mobile | Alabama | 1097 | 41454 | 815 |
1346861 | 1346861 | 2021-05-23 | East Baton Rouge | Louisiana | 22033 | 40049 | 815 |
1343613 | 1343613 | 2021-05-22 | East Baton Rouge | Louisiana | 22033 | 40049 | 815 |
1340365 | 1340365 | 2021-05-21 | East Baton Rouge | Louisiana | 22033 | 40049 | 815 |
1341685 | 1341685 | 2021-05-21 | Spartanburg | South Carolina | 45083 | 41600 | 815 |
1310326 | 1310326 | 2021-05-12 | New Castle | Delaware | 10003 | 62915 | 815 |
1307080 | 1307080 | 2021-05-11 | New Castle | Delaware | 10003 | 62862 | 815 |
1240388 | 1240388 | 2021-04-20 | Somerset | New Jersey | 34035 | 28958 | 815 |
1237141 | 1237141 | 2021-04-19 | Somerset | New Jersey | 34035 | 28864 | 815 |
1233894 | 1233894 | 2021-04-18 | Somerset | New Jersey | 34035 | 28803 | 815 |
1230646 | 1230646 | 2021-04-17 | Somerset | New Jersey | 34035 | 28703 | 815 |
1227398 | 1227398 | 2021-04-16 | Somerset | New Jersey | 34035 | 28597 | 815 |
1173863 | 1173863 | 2021-03-31 | Tulare | California | 6107 | 49054 | 815 |
1170616 | 1170616 | 2021-03-30 | Tulare | California | 6107 | 49039 | 815 |
1167368 | 1167368 | 2021-03-29 | Tulare | California | 6107 | 49005 | 815 |
1083078 | 1083078 | 2021-03-03 | Marion | Florida | 12083 | 27819 | 815 |
1012460 | 1012460 | 2021-02-09 | Jefferson | Louisiana | 22051 | 42339 | 815 |
1005968 | 1005968 | 2021-02-07 | Jefferson | Louisiana | 22051 | 42104 | 815 |
994105 | 994105 | 2021-02-03 | Berks | Pennsylvania | 42011 | 32957 | 815 |
989648 | 989648 | 2021-02-02 | Jefferson | Kentucky | 21111 | 68205 | 815 |
972597 | 972597 | 2021-01-28 | Stanislaus | California | 6099 | 50008 | 815 |
917642 | 917642 | 2021-01-11 | Fulton | Georgia | 13121 | 65130 | 815 |
904910 | 904910 | 2021-01-07 | Will | Illinois | 17197 | 54678 | 815 |
844815 | 844815 | 2020-12-19 | Allegheny | Pennsylvania | 42003 | 45699 | 815 |
821034 | 821034 | 2020-12-12 | Baltimore | Maryland | 24005 | 33567 | 815 |
743169 | 743169 | 2020-11-18 | Bristol | Massachusetts | 25005 | 16791 | 815 |
695564 | 695564 | 2020-11-03 | Delaware | Pennsylvania | 42045 | 14219 | 815 |
692322 | 692322 | 2020-11-02 | Delaware | Pennsylvania | 42045 | 14081 | 815 |
675055 | 675055 | 2020-10-28 | Hampden | Massachusetts | 25013 | 9901 | 815 |
673416 | 673416 | 2020-10-27 | Tarrant | Texas | 48439 | 64727 | 815 |
657977 | 657977 | 2020-10-23 | Pinellas | Florida | 12103 | 24789 | 815 |
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);