ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where deaths = 783 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- New York 21
- Michigan 19
- Texas 12
- Pennsylvania 11
- Colorado 9
- Kansas 9
- Ohio 9
- Louisiana 8
- California 5
- Arizona 4
- Florida 4
- Georgia 3
- Arkansas 2
- Illinois 2
- Indiana 2
- Maryland 2
- New Hampshire 2
- New Jersey 2
- North Carolina 2
- Connecticut 1
- Delaware 1
- Hawaii 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- Puerto Rico 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491116 | 2491116 | 2022-05-10 | Ottawa | Michigan | 26139 | 75716 | 783 |
2487859 | 2487859 | 2022-05-09 | Ottawa | Michigan | 26139 | 75716 | 783 |
2484601 | 2484601 | 2022-05-08 | Ottawa | Michigan | 26139 | 75716 | 783 |
2481343 | 2481343 | 2022-05-07 | Ottawa | Michigan | 26139 | 75716 | 783 |
2478085 | 2478085 | 2022-05-06 | Ottawa | Michigan | 26139 | 75716 | 783 |
2474827 | 2474827 | 2022-05-05 | Ottawa | Michigan | 26139 | 75716 | 783 |
2471570 | 2471570 | 2022-05-04 | Ottawa | Michigan | 26139 | 75716 | 783 |
2420042 | 2420042 | 2022-04-18 | Oneida | New York | 36065 | 55009 | 783 |
2416787 | 2416787 | 2022-04-17 | Oneida | New York | 36065 | 54913 | 783 |
2413531 | 2413531 | 2022-04-16 | Oneida | New York | 36065 | 54781 | 783 |
2410275 | 2410275 | 2022-04-15 | Oneida | New York | 36065 | 54630 | 783 |
2407019 | 2407019 | 2022-04-14 | Oneida | New York | 36065 | 54480 | 783 |
2403763 | 2403763 | 2022-04-13 | Oneida | New York | 36065 | 54323 | 783 |
2360888 | 2360888 | 2022-03-31 | Ottawa | Michigan | 26139 | 74601 | 783 |
2357634 | 2357634 | 2022-03-30 | Ottawa | Michigan | 26139 | 74601 | 783 |
2347876 | 2347876 | 2022-03-27 | Ottawa | Michigan | 26139 | 74526 | 783 |
2344623 | 2344623 | 2022-03-26 | Ottawa | Michigan | 26139 | 74526 | 783 |
2341370 | 2341370 | 2022-03-25 | Ottawa | Michigan | 26139 | 74526 | 783 |
2314526 | 2314526 | 2022-03-17 | Muscogee | Georgia | 13215 | 37910 | 783 |
2312718 | 2312718 | 2022-03-16 | Forsyth | North Carolina | 37067 | 91776 | 783 |
2286703 | 2286703 | 2022-03-08 | Gaston | North Carolina | 37071 | 64780 | 783 |
2262109 | 2262109 | 2022-03-01 | Benton | Arkansas | 5007 | 65846 | 783 |
2255703 | 2255703 | 2022-02-27 | Merced | California | 6047 | 70648 | 783 |
2252452 | 2252452 | 2022-02-26 | Merced | California | 6047 | 70648 | 783 |
2249201 | 2249201 | 2022-02-25 | Merced | California | 6047 | 70648 | 783 |
2221052 | 2221052 | 2022-02-16 | St. Clair | Michigan | 26147 | 39683 | 783 |
2209475 | 2209475 | 2022-02-12 | Jefferson | Texas | 48245 | 42550 | 783 |
2171645 | 2171645 | 2022-02-01 | Winnebago | Illinois | 17201 | 73194 | 783 |
2173582 | 2173582 | 2022-02-01 | Bell | Texas | 48027 | 60734 | 783 |
2168200 | 2168200 | 2022-01-31 | Richmond | Georgia | 13245 | 47657 | 783 |
2169286 | 2169286 | 2022-01-31 | St. Charles | Missouri | 29183 | 98013 | 783 |
2150452 | 2150452 | 2022-01-25 | Cumberland | Pennsylvania | 42041 | 46699 | 783 |
2132000 | 2132000 | 2022-01-20 | Navajo | Arizona | 4017 | 32154 | 783 |
2132673 | 2132673 | 2022-01-20 | St. Joseph | Indiana | 18141 | 64773 | 783 |
2124246 | 2124246 | 2022-01-17 | Lorain | Ohio | 39093 | 62885 | 783 |
2120994 | 2120994 | 2022-01-16 | Lorain | Ohio | 39093 | 62529 | 783 |
2117742 | 2117742 | 2022-01-15 | Lorain | Ohio | 39093 | 62105 | 783 |
2114491 | 2114491 | 2022-01-14 | Lorain | Ohio | 39093 | 61289 | 783 |
2098412 | 2098412 | 2022-01-09 | Dauphin | Pennsylvania | 42043 | 48629 | 783 |
2084905 | 2084905 | 2022-01-05 | Hillsborough | New Hampshire | 33011 | 68309 | 783 |
2081653 | 2081653 | 2022-01-04 | Hillsborough | New Hampshire | 33011 | 67202 | 783 |
2034784 | 2034784 | 2021-12-21 | Clayton | Georgia | 13063 | 41872 | 783 |
2002408 | 2002408 | 2021-12-11 | Honolulu | Hawaii | 15003 | 60356 | 783 |
1993991 | 1993991 | 2021-12-08 | Rockland | New York | 36087 | 56362 | 783 |
1990740 | 1990740 | 2021-12-07 | Rockland | New York | 36087 | 56262 | 783 |
1987489 | 1987489 | 2021-12-06 | Rockland | New York | 36087 | 56166 | 783 |
1984239 | 1984239 | 2021-12-05 | Rockland | New York | 36087 | 56085 | 783 |
1980989 | 1980989 | 2021-12-04 | Rockland | New York | 36087 | 55960 | 783 |
1977739 | 1977739 | 2021-12-03 | Rockland | New York | 36087 | 55844 | 783 |
1974489 | 1974489 | 2021-12-02 | Rockland | New York | 36087 | 55730 | 783 |
1971240 | 1971240 | 2021-12-01 | Rockland | New York | 36087 | 55617 | 783 |
1967990 | 1967990 | 2021-11-30 | Rockland | New York | 36087 | 55509 | 783 |
1968560 | 1968560 | 2021-11-30 | Richland | South Carolina | 45079 | 70222 | 783 |
1964739 | 1964739 | 2021-11-29 | Rockland | New York | 36087 | 55405 | 783 |
1961487 | 1961487 | 2021-11-28 | Rockland | New York | 36087 | 55357 | 783 |
1958236 | 1958236 | 2021-11-27 | Rockland | New York | 36087 | 55272 | 783 |
1929164 | 1929164 | 2021-11-18 | Butler | Ohio | 39017 | 54354 | 783 |
1925914 | 1925914 | 2021-11-17 | Butler | Ohio | 39017 | 54204 | 783 |
1922664 | 1922664 | 2021-11-16 | Butler | Ohio | 39017 | 54022 | 783 |
1886727 | 1886727 | 2021-11-05 | Orange | New York | 36071 | 58798 | 783 |
1883478 | 1883478 | 2021-11-04 | Orange | New York | 36071 | 58697 | 783 |
1880229 | 1880229 | 2021-11-03 | Orange | New York | 36071 | 58595 | 783 |
1838420 | 1838420 | 2021-10-21 | Northampton | Pennsylvania | 42095 | 43966 | 783 |
1835171 | 1835171 | 2021-10-20 | Northampton | Pennsylvania | 42095 | 43861 | 783 |
1647925 | 1647925 | 2021-08-24 | Adams | Colorado | 8001 | 66377 | 783 |
1644602 | 1644602 | 2021-08-23 | Pulaski | Arkansas | 5119 | 52630 | 783 |
1644677 | 1644677 | 2021-08-23 | Adams | Colorado | 8001 | 66377 | 783 |
1641427 | 1641427 | 2021-08-22 | Adams | Colorado | 8001 | 66230 | 783 |
1600082 | 1600082 | 2021-08-09 | Caddo | Louisiana | 22017 | 31138 | 783 |
1581787 | 1581787 | 2021-08-03 | Westmoreland | Pennsylvania | 42129 | 34825 | 783 |
1563321 | 1563321 | 2021-07-29 | Mohave | Arizona | 4015 | 25364 | 783 |
1560073 | 1560073 | 2021-07-28 | Mohave | Arizona | 4015 | 25260 | 783 |
1523688 | 1523688 | 2021-07-16 | Denton | Texas | 48121 | 77935 | 783 |
1520440 | 1520440 | 2021-07-15 | Denton | Texas | 48121 | 77820 | 783 |
1444079 | 1444079 | 2021-06-22 | Sedgwick | Kansas | 20173 | 57780 | 783 |
1440834 | 1440834 | 2021-06-21 | Sedgwick | Kansas | 20173 | 57780 | 783 |
1437587 | 1437587 | 2021-06-20 | Sedgwick | Kansas | 20173 | 57732 | 783 |
1434340 | 1434340 | 2021-06-19 | Sedgwick | Kansas | 20173 | 57732 | 783 |
1431094 | 1431094 | 2021-06-18 | Sedgwick | Kansas | 20173 | 57732 | 783 |
1427849 | 1427849 | 2021-06-17 | Sedgwick | Kansas | 20173 | 57688 | 783 |
1424604 | 1424604 | 2021-06-16 | Sedgwick | Kansas | 20173 | 57688 | 783 |
1421356 | 1421356 | 2021-06-15 | Sedgwick | Kansas | 20173 | 57633 | 783 |
1418111 | 1418111 | 2021-06-14 | Sedgwick | Kansas | 20173 | 57633 | 783 |
1355738 | 1355738 | 2021-05-26 | Jefferson | Colorado | 8059 | 47745 | 783 |
1286366 | 1286366 | 2021-05-04 | York | Pennsylvania | 42133 | 44608 | 783 |
1283120 | 1283120 | 2021-05-03 | York | Pennsylvania | 42133 | 44485 | 783 |
1279873 | 1279873 | 2021-05-02 | York | Pennsylvania | 42133 | 44398 | 783 |
1276626 | 1276626 | 2021-05-01 | York | Pennsylvania | 42133 | 44286 | 783 |
1272332 | 1272332 | 2021-04-30 | Kent | Michigan | 26081 | 68106 | 783 |
1273379 | 1273379 | 2021-04-30 | York | Pennsylvania | 42133 | 44127 | 783 |
1261573 | 1261573 | 2021-04-27 | El Paso | Colorado | 8041 | 62982 | 783 |
1264083 | 1264083 | 2021-04-27 | Lubbock | Texas | 48303 | 48830 | 783 |
1258326 | 1258326 | 2021-04-26 | El Paso | Colorado | 8041 | 62522 | 783 |
1260836 | 1260836 | 2021-04-26 | Lubbock | Texas | 48303 | 48815 | 783 |
1255079 | 1255079 | 2021-04-25 | El Paso | Colorado | 8041 | 62522 | 783 |
1257589 | 1257589 | 2021-04-25 | Lubbock | Texas | 48303 | 48798 | 783 |
1251832 | 1251832 | 2021-04-24 | El Paso | Colorado | 8041 | 62254 | 783 |
1254342 | 1254342 | 2021-04-24 | Lubbock | Texas | 48303 | 48798 | 783 |
1251095 | 1251095 | 2021-04-23 | Lubbock | Texas | 48303 | 48798 | 783 |
1247848 | 1247848 | 2021-04-22 | Lubbock | Texas | 48303 | 48779 | 783 |
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);