ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where deaths = 874 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Pennsylvania 14
- New Jersey 10
- California 9
- Texas 8
- Illinois 7
- Louisiana 7
- Michigan 7
- Indiana 6
- Colorado 4
- Florida 4
- Georgia 4
- Tennessee 4
- Alabama 3
- Arizona 3
- Maryland 3
- New Mexico 2
- South Carolina 2
- Connecticut 1
- Massachusetts 1
- New York 1
- North Carolina 1
- Ohio 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500353 | 2500353 | 2022-05-13 | St. Joseph | Indiana | 18141 | 71793 | 874 |
2497095 | 2497095 | 2022-05-12 | St. Joseph | Indiana | 18141 | 71645 | 874 |
2493837 | 2493837 | 2022-05-11 | St. Joseph | Indiana | 18141 | 71645 | 874 |
2490579 | 2490579 | 2022-05-10 | St. Joseph | Indiana | 18141 | 71550 | 874 |
2487322 | 2487322 | 2022-05-09 | St. Joseph | Indiana | 18141 | 71550 | 874 |
2405551 | 2405551 | 2022-04-14 | Chatham | Georgia | 13051 | 63621 | 874 |
2369846 | 2369846 | 2022-04-03 | Richmond | Georgia | 13245 | 50054 | 874 |
2366593 | 2366593 | 2022-04-02 | Richmond | Georgia | 13245 | 50054 | 874 |
2363340 | 2363340 | 2022-04-01 | Richmond | Georgia | 13245 | 50054 | 874 |
2309813 | 2309813 | 2022-03-15 | Cumberland | Pennsylvania | 42041 | 50713 | 874 |
2306560 | 2306560 | 2022-03-14 | Cumberland | Pennsylvania | 42041 | 50701 | 874 |
2306913 | 2306913 | 2022-03-14 | Bell | Texas | 48027 | 66646 | 874 |
2303309 | 2303309 | 2022-03-13 | Cumberland | Pennsylvania | 42041 | 50699 | 874 |
2303662 | 2303662 | 2022-03-13 | Bell | Texas | 48027 | 66635 | 874 |
2300057 | 2300057 | 2022-03-12 | Cumberland | Pennsylvania | 42041 | 50689 | 874 |
2300410 | 2300410 | 2022-03-12 | Bell | Texas | 48027 | 66624 | 874 |
2297158 | 2297158 | 2022-03-11 | Bell | Texas | 48027 | 66616 | 874 |
2284497 | 2284497 | 2022-03-07 | Henrico | Virginia | 51087 | 63480 | 874 |
2278306 | 2278306 | 2022-03-06 | Montgomery | Alabama | 1101 | 54452 | 874 |
2275053 | 2275053 | 2022-03-05 | Montgomery | Alabama | 1101 | 54452 | 874 |
2271800 | 2271800 | 2022-03-04 | Montgomery | Alabama | 1101 | 54452 | 874 |
2265445 | 2265445 | 2022-03-02 | Imperial | California | 6025 | 65442 | 874 |
2262194 | 2262194 | 2022-03-01 | Imperial | California | 6025 | 65389 | 874 |
2258943 | 2258943 | 2022-02-28 | Imperial | California | 6025 | 65381 | 874 |
2251778 | 2251778 | 2022-02-25 | McLennan | Texas | 48309 | 56153 | 874 |
2248527 | 2248527 | 2022-02-24 | McLennan | Texas | 48309 | 56081 | 874 |
2188520 | 2188520 | 2022-02-06 | Saginaw | Michigan | 26145 | 48414 | 874 |
2185267 | 2185267 | 2022-02-05 | Saginaw | Michigan | 26145 | 48414 | 874 |
2182015 | 2182015 | 2022-02-04 | Saginaw | Michigan | 26145 | 48414 | 874 |
2163067 | 2163067 | 2022-01-29 | Rockland | New York | 36087 | 89435 | 874 |
1858047 | 1858047 | 2021-10-27 | Horry | South Carolina | 45051 | 61914 | 874 |
1854635 | 1854635 | 2021-10-26 | Chester | Pennsylvania | 42029 | 50555 | 874 |
1831420 | 1831420 | 2021-10-19 | Somerset | New Jersey | 34035 | 34602 | 874 |
1828171 | 1828171 | 2021-10-18 | Somerset | New Jersey | 34035 | 34564 | 874 |
1824922 | 1824922 | 2021-10-17 | Somerset | New Jersey | 34035 | 34546 | 874 |
1821673 | 1821673 | 2021-10-16 | Somerset | New Jersey | 34035 | 34526 | 874 |
1818424 | 1818424 | 2021-10-15 | Somerset | New Jersey | 34035 | 34504 | 874 |
1809443 | 1809443 | 2021-10-12 | Knox | Tennessee | 47093 | 76953 | 874 |
1712750 | 1712750 | 2021-09-13 | Mohave | Arizona | 4015 | 29655 | 874 |
1715420 | 1715420 | 2021-09-13 | Lubbock | Texas | 48303 | 60971 | 874 |
1709503 | 1709503 | 2021-09-12 | Mohave | Arizona | 4015 | 29552 | 874 |
1712174 | 1712174 | 2021-09-12 | Lubbock | Texas | 48303 | 60296 | 874 |
1696645 | 1696645 | 2021-09-08 | Tulare | California | 6107 | 69045 | 874 |
1693397 | 1693397 | 2021-09-07 | Tulare | California | 6107 | 68885 | 874 |
1690148 | 1690148 | 2021-09-06 | Tulare | California | 6107 | 68732 | 874 |
1686898 | 1686898 | 2021-09-05 | Tulare | California | 6107 | 68536 | 874 |
1686919 | 1686919 | 2021-09-05 | Denver | Colorado | 8031 | 81350 | 874 |
1683669 | 1683669 | 2021-09-04 | Denver | Colorado | 8031 | 81350 | 874 |
1680418 | 1680418 | 2021-09-03 | Denver | Colorado | 8031 | 81350 | 874 |
1648325 | 1648325 | 2021-08-24 | Kane | Illinois | 17089 | 62536 | 874 |
1645077 | 1645077 | 2021-08-23 | Kane | Illinois | 17089 | 62439 | 874 |
1641828 | 1641828 | 2021-08-22 | Kane | Illinois | 17089 | 62111 | 874 |
1638578 | 1638578 | 2021-08-21 | Kane | Illinois | 17089 | 62111 | 874 |
1635328 | 1635328 | 2021-08-20 | Kane | Illinois | 17089 | 62111 | 874 |
1632078 | 1632078 | 2021-08-19 | Kane | Illinois | 17089 | 61980 | 874 |
1627241 | 1627241 | 2021-08-17 | Lehigh | Pennsylvania | 42077 | 41271 | 874 |
1623994 | 1623994 | 2021-08-16 | Lehigh | Pennsylvania | 42077 | 41186 | 874 |
1619727 | 1619727 | 2021-08-15 | Kent | Michigan | 26081 | 75475 | 874 |
1620747 | 1620747 | 2021-08-15 | Lehigh | Pennsylvania | 42077 | 41115 | 874 |
1616479 | 1616479 | 2021-08-14 | Kent | Michigan | 26081 | 75475 | 874 |
1617499 | 1617499 | 2021-08-14 | Lehigh | Pennsylvania | 42077 | 41043 | 874 |
1613231 | 1613231 | 2021-08-13 | Kent | Michigan | 26081 | 75475 | 874 |
1614251 | 1614251 | 2021-08-13 | Lehigh | Pennsylvania | 42077 | 40974 | 874 |
1577346 | 1577346 | 2021-08-02 | East Baton Rouge | Louisiana | 22033 | 48076 | 874 |
1574098 | 1574098 | 2021-08-01 | East Baton Rouge | Louisiana | 22033 | 47277 | 874 |
1570850 | 1570850 | 2021-07-31 | East Baton Rouge | Louisiana | 22033 | 47277 | 874 |
1567602 | 1567602 | 2021-07-30 | East Baton Rouge | Louisiana | 22033 | 47277 | 874 |
1469323 | 1469323 | 2021-06-30 | El Paso | Colorado | 8041 | 73368 | 874 |
1297348 | 1297348 | 2021-05-08 | Brevard | Florida | 12009 | 41637 | 874 |
1294102 | 1294102 | 2021-05-07 | Brevard | Florida | 12009 | 41545 | 874 |
1290636 | 1290636 | 2021-05-06 | Pinal | Arizona | 4021 | 51667 | 874 |
1142296 | 1142296 | 2021-03-21 | Jefferson | Louisiana | 22051 | 44684 | 874 |
1139050 | 1139050 | 2021-03-20 | Jefferson | Louisiana | 22051 | 44684 | 874 |
1135804 | 1135804 | 2021-03-19 | Jefferson | Louisiana | 22051 | 44684 | 874 |
1130708 | 1130708 | 2021-03-17 | Davidson | Tennessee | 47037 | 92262 | 874 |
1097512 | 1097512 | 2021-03-07 | Bernalillo | New Mexico | 35001 | 53036 | 874 |
1098245 | 1098245 | 2021-03-07 | Davidson | Tennessee | 47037 | 90336 | 874 |
1094265 | 1094265 | 2021-03-06 | Bernalillo | New Mexico | 35001 | 53036 | 874 |
1094997 | 1094997 | 2021-03-06 | Davidson | Tennessee | 47037 | 90336 | 874 |
1085152 | 1085152 | 2021-03-03 | Greenville | South Carolina | 45045 | 64238 | 874 |
1081433 | 1081433 | 2021-03-02 | Mecklenburg | North Carolina | 37119 | 97203 | 874 |
1061204 | 1061204 | 2021-02-24 | Baltimore city | Maryland | 24510 | 40058 | 874 |
1042788 | 1042788 | 2021-02-18 | Berks | Pennsylvania | 42011 | 34794 | 874 |
1011549 | 1011549 | 2021-02-09 | Stanislaus | California | 6099 | 53278 | 874 |
992062 | 992062 | 2021-02-03 | San Joaquin | California | 6077 | 62890 | 874 |
927303 | 927303 | 2021-01-14 | Polk | Florida | 12105 | 44252 | 874 |
927578 | 927578 | 2021-01-14 | Lake | Illinois | 17097 | 52264 | 874 |
857609 | 857609 | 2020-12-23 | Cuyahoga | Ohio | 39035 | 64653 | 874 |
850247 | 850247 | 2020-12-21 | Baltimore | Maryland | 24005 | 36087 | 874 |
805886 | 805886 | 2020-12-07 | Delaware | Pennsylvania | 42045 | 22470 | 874 |
739931 | 739931 | 2020-11-17 | Plymouth | Massachusetts | 25023 | 13146 | 874 |
732953 | 732953 | 2020-11-15 | Marion | Indiana | 18097 | 35590 | 874 |
711300 | 711300 | 2020-11-08 | Monmouth | New Jersey | 34025 | 15341 | 874 |
708056 | 708056 | 2020-11-07 | Monmouth | New Jersey | 34025 | 15220 | 874 |
704813 | 704813 | 2020-11-06 | Monmouth | New Jersey | 34025 | 15036 | 874 |
701570 | 701570 | 2020-11-05 | Monmouth | New Jersey | 34025 | 14919 | 874 |
698326 | 698326 | 2020-11-04 | Monmouth | New Jersey | 34025 | 14784 | 874 |
691257 | 691257 | 2020-11-02 | Montgomery | Maryland | 24031 | 26317 | 874 |
556147 | 556147 | 2020-09-21 | Montgomery | Pennsylvania | 42091 | 11962 | 874 |
552910 | 552910 | 2020-09-20 | Montgomery | Pennsylvania | 42091 | 11932 | 874 |
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);