ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where deaths = 763 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Texas 19
- California 12
- Georgia 12
- Illinois 11
- Kansas 10
- Pennsylvania 10
- New York 8
- Colorado 7
- Washington 5
- Louisiana 4
- Maryland 4
- North Carolina 4
- Arizona 3
- Delaware 3
- Virginia 3
- Florida 2
- Minnesota 2
- Missouri 2
- New Jersey 2
- Alabama 1
- Arkansas 1
- Idaho 1
- Indiana 1
- Massachusetts 1
- Nevada 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2397676 | 2397676 | 2022-04-11 | Lackawanna | Pennsylvania | 42069 | 43526 | 763 |
2394421 | 2394421 | 2022-04-10 | Lackawanna | Pennsylvania | 42069 | 43517 | 763 |
2354414 | 2354414 | 2022-03-29 | Dakota | Minnesota | 27037 | 109593 | 763 |
2330697 | 2330697 | 2022-03-22 | Bibb | Georgia | 13021 | 36952 | 763 |
2313685 | 2313685 | 2022-03-16 | Utah | Utah | 49049 | 201221 | 763 |
2301709 | 2301709 | 2022-03-13 | St. Clair | Illinois | 17163 | 68942 | 763 |
2298457 | 2298457 | 2022-03-12 | St. Clair | Illinois | 17163 | 68942 | 763 |
2295205 | 2295205 | 2022-03-11 | St. Clair | Illinois | 17163 | 68942 | 763 |
2291953 | 2291953 | 2022-03-10 | St. Clair | Illinois | 17163 | 68927 | 763 |
2267186 | 2267186 | 2022-03-02 | Forsyth | North Carolina | 37067 | 91336 | 763 |
2255789 | 2255789 | 2022-02-27 | Pueblo | Colorado | 8101 | 43914 | 763 |
2252538 | 2252538 | 2022-02-26 | Pueblo | Colorado | 8101 | 43914 | 763 |
2249287 | 2249287 | 2022-02-25 | Pueblo | Colorado | 8101 | 43914 | 763 |
2246036 | 2246036 | 2022-02-24 | Pueblo | Colorado | 8101 | 43865 | 763 |
2224312 | 2224312 | 2022-02-17 | Anoka | Minnesota | 27003 | 96671 | 763 |
2220191 | 2220191 | 2022-02-16 | Hall | Georgia | 13139 | 52964 | 763 |
2213440 | 2213440 | 2022-02-14 | Merced | California | 6047 | 69498 | 763 |
2210188 | 2210188 | 2022-02-13 | Merced | California | 6047 | 68563 | 763 |
2206935 | 2206935 | 2022-02-12 | Merced | California | 6047 | 68563 | 763 |
2203682 | 2203682 | 2022-02-11 | Merced | California | 6047 | 68563 | 763 |
2200429 | 2200429 | 2022-02-10 | Merced | California | 6047 | 68563 | 763 |
2190777 | 2190777 | 2022-02-07 | Sussex | Delaware | 10005 | 59493 | 763 |
2187524 | 2187524 | 2022-02-06 | Sussex | Delaware | 10005 | 59415 | 763 |
2184271 | 2184271 | 2022-02-05 | Sussex | Delaware | 10005 | 59323 | 763 |
2174610 | 2174610 | 2022-02-02 | Chatham | Georgia | 13051 | 59146 | 763 |
2171357 | 2171357 | 2022-02-01 | Chatham | Georgia | 13051 | 58851 | 763 |
2168104 | 2168104 | 2022-01-31 | Chatham | Georgia | 13051 | 58668 | 763 |
2164849 | 2164849 | 2022-01-30 | Chatham | Georgia | 13051 | 57916 | 763 |
2167425 | 2167425 | 2022-01-30 | Henrico | Virginia | 51087 | 59010 | 763 |
2161594 | 2161594 | 2022-01-29 | Chatham | Georgia | 13051 | 57916 | 763 |
2164170 | 2164170 | 2022-01-29 | Henrico | Virginia | 51087 | 59010 | 763 |
2158338 | 2158338 | 2022-01-28 | Chatham | Georgia | 13051 | 57916 | 763 |
2160915 | 2160915 | 2022-01-28 | Henrico | Virginia | 51087 | 59010 | 763 |
2145616 | 2145616 | 2022-01-24 | Winnebago | Illinois | 17201 | 70774 | 763 |
2132553 | 2132553 | 2022-01-20 | Madison | Illinois | 17119 | 63025 | 763 |
2112001 | 2112001 | 2022-01-13 | Williamson | Texas | 48491 | 101813 | 763 |
2106656 | 2106656 | 2022-01-12 | St. Joseph | Indiana | 18141 | 60802 | 763 |
2064121 | 2064121 | 2021-12-30 | Richmond | Georgia | 13245 | 37547 | 763 |
2014395 | 2014395 | 2021-12-14 | McLennan | Texas | 48309 | 43552 | 763 |
1937266 | 1937266 | 2021-11-21 | Clayton | Georgia | 13063 | 39914 | 763 |
1934016 | 1934016 | 2021-11-20 | Clayton | Georgia | 13063 | 39914 | 763 |
1930764 | 1930764 | 2021-11-19 | Clayton | Georgia | 13063 | 39914 | 763 |
1884896 | 1884896 | 2021-11-05 | Montgomery | Alabama | 1101 | 34290 | 763 |
1884687 | 1884687 | 2021-11-04 | Snohomish | Washington | 53061 | 66839 | 763 |
1856810 | 1856810 | 2021-10-27 | Anne Arundel | Maryland | 24003 | 52847 | 763 |
1852914 | 1852914 | 2021-10-26 | Ada | Idaho | 16001 | 80154 | 763 |
1833058 | 1833058 | 2021-10-20 | Imperial | California | 6025 | 35906 | 763 |
1835695 | 1835695 | 2021-10-20 | Smith | Texas | 48423 | 36127 | 763 |
1829809 | 1829809 | 2021-10-19 | Imperial | California | 6025 | 35832 | 763 |
1826560 | 1826560 | 2021-10-18 | Imperial | California | 6025 | 35794 | 763 |
1823311 | 1823311 | 2021-10-17 | Imperial | California | 6025 | 35642 | 763 |
1823805 | 1823805 | 2021-10-17 | Unknown | Illinois | 0 | 763 | |
1820062 | 1820062 | 2021-10-16 | Imperial | California | 6025 | 35642 | 763 |
1820556 | 1820556 | 2021-10-16 | Unknown | Illinois | 0 | 763 | |
1816813 | 1816813 | 2021-10-15 | Imperial | California | 6025 | 35642 | 763 |
1817307 | 1817307 | 2021-10-15 | Unknown | Illinois | 0 | 763 | |
1786005 | 1786005 | 2021-10-05 | Orange | New York | 36071 | 55843 | 763 |
1782756 | 1782756 | 2021-10-04 | Orange | New York | 36071 | 55744 | 763 |
1783187 | 1783187 | 2021-10-04 | Northampton | Pennsylvania | 42095 | 42552 | 763 |
1779507 | 1779507 | 2021-10-03 | Orange | New York | 36071 | 55674 | 763 |
1779938 | 1779938 | 2021-10-03 | Northampton | Pennsylvania | 42095 | 42417 | 763 |
1780270 | 1780270 | 2021-10-03 | Brazoria | Texas | 48039 | 57379 | 763 |
1777020 | 1777020 | 2021-10-02 | Brazoria | Texas | 48039 | 57379 | 763 |
1702448 | 1702448 | 2021-09-09 | Montgomery | Texas | 48339 | 78534 | 763 |
1698185 | 1698185 | 2021-09-08 | Washoe | Nevada | 32031 | 56215 | 763 |
1682045 | 1682045 | 2021-09-03 | Rockland | New York | 36087 | 49429 | 763 |
1678796 | 1678796 | 2021-09-02 | Rockland | New York | 36087 | 49369 | 763 |
1675548 | 1675548 | 2021-09-01 | Rockland | New York | 36087 | 49276 | 763 |
1672301 | 1672301 | 2021-08-31 | Rockland | New York | 36087 | 49219 | 763 |
1669053 | 1669053 | 2021-08-30 | Rockland | New York | 36087 | 49169 | 763 |
1643178 | 1643178 | 2021-08-22 | Wake | North Carolina | 37183 | 103805 | 763 |
1639928 | 1639928 | 2021-08-21 | Wake | North Carolina | 37183 | 103805 | 763 |
1636678 | 1636678 | 2021-08-20 | Wake | North Carolina | 37183 | 103805 | 763 |
1621862 | 1621862 | 2021-08-16 | Pulaski | Arkansas | 5119 | 51139 | 763 |
1524495 | 1524495 | 2021-07-17 | Adams | Colorado | 8001 | 62718 | 763 |
1521247 | 1521247 | 2021-07-16 | Adams | Colorado | 8001 | 62718 | 763 |
1508118 | 1508118 | 2021-07-12 | Mohave | Arizona | 4015 | 24229 | 763 |
1504872 | 1504872 | 2021-07-11 | Mohave | Arizona | 4015 | 24215 | 763 |
1492912 | 1492912 | 2021-07-07 | Caddo | Louisiana | 22017 | 27371 | 763 |
1489665 | 1489665 | 2021-07-06 | Caddo | Louisiana | 22017 | 27343 | 763 |
1392106 | 1392106 | 2021-06-06 | Johnson | Kansas | 20091 | 59267 | 763 |
1388861 | 1388861 | 2021-06-05 | Johnson | Kansas | 20091 | 59267 | 763 |
1385616 | 1385616 | 2021-06-04 | Johnson | Kansas | 20091 | 59267 | 763 |
1382370 | 1382370 | 2021-06-03 | Johnson | Kansas | 20091 | 59208 | 763 |
1379125 | 1379125 | 2021-06-02 | Johnson | Kansas | 20091 | 59208 | 763 |
1358147 | 1358147 | 2021-05-26 | Denton | Texas | 48121 | 75959 | 763 |
1354544 | 1354544 | 2021-05-25 | Westmoreland | Pennsylvania | 42129 | 33989 | 763 |
1354901 | 1354901 | 2021-05-25 | Denton | Texas | 48121 | 75902 | 763 |
1330428 | 1330428 | 2021-05-18 | Johnson | Kansas | 20091 | 58676 | 763 |
1327181 | 1327181 | 2021-05-17 | Johnson | Kansas | 20091 | 58676 | 763 |
1323935 | 1323935 | 2021-05-16 | Johnson | Kansas | 20091 | 58499 | 763 |
1320689 | 1320689 | 2021-05-15 | Johnson | Kansas | 20091 | 58499 | 763 |
1317442 | 1317442 | 2021-05-14 | Johnson | Kansas | 20091 | 58499 | 763 |
1240909 | 1240909 | 2021-04-20 | York | Pennsylvania | 42133 | 42693 | 763 |
1237662 | 1237662 | 2021-04-19 | York | Pennsylvania | 42133 | 42532 | 763 |
1234415 | 1234415 | 2021-04-18 | York | Pennsylvania | 42133 | 42464 | 763 |
1234886 | 1234886 | 2021-04-18 | Nueces | Texas | 48355 | 38024 | 763 |
1231638 | 1231638 | 2021-04-17 | Nueces | Texas | 48355 | 37994 | 763 |
1228390 | 1228390 | 2021-04-16 | Nueces | Texas | 48355 | 37938 | 763 |
1203118 | 1203118 | 2021-04-09 | El Paso | Colorado | 8041 | 58702 | 763 |
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);