ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 951 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Texas 12
- Michigan 10
- Tennessee 10
- Rhode Island 7
- Arizona 6
- Pennsylvania 6
- Maryland 4
- New Jersey 4
- Ohio 4
- California 3
- Indiana 3
- Massachusetts 3
- Georgia 2
- Idaho 2
- Illinois 2
- Minnesota 2
- North Carolina 2
- Arkansas 1
- Florida 1
- Missouri 1
- Nevada 1
- New Mexico 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468317 | 2468317 | 2022-05-03 | Saginaw | Michigan | 26145 | 50629 | 951 |
2465062 | 2465062 | 2022-05-02 | Saginaw | Michigan | 26145 | 50629 | 951 |
2461806 | 2461806 | 2022-05-01 | Saginaw | Michigan | 26145 | 50629 | 951 |
2458550 | 2458550 | 2022-04-30 | Saginaw | Michigan | 26145 | 50629 | 951 |
2455294 | 2455294 | 2022-04-29 | Saginaw | Michigan | 26145 | 50629 | 951 |
2452038 | 2452038 | 2022-04-28 | Saginaw | Michigan | 26145 | 50629 | 951 |
2448782 | 2448782 | 2022-04-27 | Saginaw | Michigan | 26145 | 50629 | 951 |
2322828 | 2322828 | 2022-03-19 | Dauphin | Pennsylvania | 42043 | 58930 | 951 |
2319574 | 2319574 | 2022-03-18 | Dauphin | Pennsylvania | 42043 | 58925 | 951 |
2313617 | 2313617 | 2022-03-16 | Smith | Texas | 48423 | 45297 | 951 |
2310364 | 2310364 | 2022-03-15 | Smith | Texas | 48423 | 45292 | 951 |
2307111 | 2307111 | 2022-03-14 | Smith | Texas | 48423 | 45287 | 951 |
2303860 | 2303860 | 2022-03-13 | Smith | Texas | 48423 | 45283 | 951 |
2300608 | 2300608 | 2022-03-12 | Smith | Texas | 48423 | 45281 | 951 |
2283620 | 2283620 | 2022-03-07 | Lorain | Ohio | 39093 | 66238 | 951 |
2280368 | 2280368 | 2022-03-06 | Lorain | Ohio | 39093 | 66237 | 951 |
2277115 | 2277115 | 2022-03-05 | Lorain | Ohio | 39093 | 66230 | 951 |
2273862 | 2273862 | 2022-03-04 | Lorain | Ohio | 39093 | 66223 | 951 |
2219127 | 2219127 | 2022-02-15 | Brazoria | Texas | 48039 | 91890 | 951 |
2215023 | 2215023 | 2022-02-14 | Atlantic | New Jersey | 34001 | 67371 | 951 |
2200777 | 2200777 | 2022-02-10 | Ada | Idaho | 16001 | 113318 | 951 |
2197523 | 2197523 | 2022-02-09 | Ada | Idaho | 16001 | 112425 | 951 |
2198775 | 2198775 | 2022-02-09 | Somerset | New Jersey | 34035 | 65410 | 951 |
2063719 | 2063719 | 2021-12-30 | Yavapai | Arizona | 4025 | 36284 | 951 |
2021530 | 2021530 | 2021-12-17 | Pulaski | Arkansas | 5119 | 61322 | 951 |
2018815 | 2018815 | 2021-12-16 | Allen | Indiana | 18003 | 71135 | 951 |
1967653 | 1967653 | 2021-11-30 | Kansas City | Missouri | 67668 | 951 | |
1968679 | 1968679 | 2021-11-30 | Knox | Tennessee | 47093 | 80929 | 951 |
1922374 | 1922374 | 2021-11-16 | Washoe | Nevada | 32031 | 67361 | 951 |
1909898 | 1909898 | 2021-11-12 | Lehigh | Pennsylvania | 42077 | 49611 | 951 |
1906649 | 1906649 | 2021-11-11 | Lehigh | Pennsylvania | 42077 | 49519 | 951 |
1848560 | 1848560 | 2021-10-24 | Fort Bend | Texas | 48157 | 99485 | 951 |
1845310 | 1845310 | 2021-10-23 | Fort Bend | Texas | 48157 | 99485 | 951 |
1842060 | 1842060 | 2021-10-22 | Fort Bend | Texas | 48157 | 99485 | 951 |
1838439 | 1838439 | 2021-10-21 | York | Pennsylvania | 42133 | 60866 | 951 |
1838811 | 1838811 | 2021-10-21 | Fort Bend | Texas | 48157 | 99392 | 951 |
1835562 | 1835562 | 2021-10-20 | Fort Bend | Texas | 48157 | 98905 | 951 |
1823352 | 1823352 | 2021-10-17 | Tulare | California | 6107 | 78945 | 951 |
1820103 | 1820103 | 2021-10-16 | Tulare | California | 6107 | 78945 | 951 |
1816854 | 1816854 | 2021-10-15 | Tulare | California | 6107 | 78945 | 951 |
1810221 | 1810221 | 2021-10-13 | Mohave | Arizona | 4015 | 32242 | 951 |
1777170 | 1777170 | 2021-10-02 | Montgomery | Texas | 48339 | 85161 | 951 |
1690015 | 1690015 | 2021-09-06 | Pinal | Arizona | 4021 | 64160 | 951 |
1686765 | 1686765 | 2021-09-05 | Pinal | Arizona | 4021 | 63981 | 951 |
1683515 | 1683515 | 2021-09-04 | Pinal | Arizona | 4021 | 63936 | 951 |
1680264 | 1680264 | 2021-09-03 | Pinal | Arizona | 4021 | 63747 | 951 |
1588854 | 1588854 | 2021-08-05 | Salt Lake | Utah | 49035 | 161151 | 951 |
1487834 | 1487834 | 2021-07-05 | Davidson | Tennessee | 47037 | 99433 | 951 |
1484587 | 1484587 | 2021-07-04 | Davidson | Tennessee | 47037 | 99433 | 951 |
1481341 | 1481341 | 2021-07-03 | Davidson | Tennessee | 47037 | 99433 | 951 |
1478094 | 1478094 | 2021-07-02 | Davidson | Tennessee | 47037 | 99433 | 951 |
1474848 | 1474848 | 2021-07-01 | Davidson | Tennessee | 47037 | 99452 | 951 |
1471602 | 1471602 | 2021-06-30 | Davidson | Tennessee | 47037 | 99452 | 951 |
1468357 | 1468357 | 2021-06-29 | Davidson | Tennessee | 47037 | 99533 | 951 |
1465112 | 1465112 | 2021-06-28 | Davidson | Tennessee | 47037 | 99533 | 951 |
1396223 | 1396223 | 2021-06-07 | Bernalillo | New Mexico | 35001 | 58631 | 951 |
1385941 | 1385941 | 2021-06-04 | Genesee | Michigan | 26049 | 41635 | 951 |
1379984 | 1379984 | 2021-06-02 | Mercer | New Jersey | 34021 | 33990 | 951 |
1376739 | 1376739 | 2021-06-01 | Mercer | New Jersey | 34021 | 33987 | 951 |
1377483 | 1377483 | 2021-06-01 | Davidson | Tennessee | 47037 | 99318 | 951 |
1311971 | 1311971 | 2021-05-12 | Mecklenburg | North Carolina | 37119 | 111871 | 951 |
1308724 | 1308724 | 2021-05-11 | Mecklenburg | North Carolina | 37119 | 111720 | 951 |
1224610 | 1224610 | 2021-04-15 | Berks | Pennsylvania | 42011 | 42915 | 951 |
1191065 | 1191065 | 2021-04-05 | Baltimore city | Maryland | 24510 | 45847 | 951 |
1187817 | 1187817 | 2021-04-04 | Baltimore city | Maryland | 24510 | 45682 | 951 |
1151639 | 1151639 | 2021-03-24 | Lake | Indiana | 18089 | 49632 | 951 |
1073435 | 1073435 | 2021-02-28 | Gwinnett | Georgia | 13135 | 92269 | 951 |
1070189 | 1070189 | 2021-02-27 | Gwinnett | Georgia | 13135 | 92036 | 951 |
1041221 | 1041221 | 2021-02-18 | Will | Illinois | 17197 | 63856 | 951 |
992487 | 992487 | 2021-02-03 | Lake | Illinois | 17097 | 56469 | 951 |
892434 | 892434 | 2021-01-03 | Baltimore | Maryland | 24005 | 39637 | 951 |
840545 | 840545 | 2020-12-18 | Plymouth | Massachusetts | 25023 | 20152 | 951 |
823449 | 823449 | 2020-12-13 | Pinellas | Florida | 12103 | 37753 | 951 |
811326 | 811326 | 2020-12-09 | Hampden | Massachusetts | 25013 | 19242 | 951 |
791373 | 791373 | 2020-12-03 | Marion | Indiana | 18097 | 48921 | 951 |
778860 | 778860 | 2020-11-29 | Montgomery | Maryland | 24031 | 33145 | 951 |
741094 | 741094 | 2020-11-17 | Unknown | Puerto Rico | 2505 | 951 | |
695691 | 695691 | 2020-11-03 | Providence | Rhode Island | 44007 | 23320 | 951 |
692449 | 692449 | 2020-11-02 | Providence | Rhode Island | 44007 | 23320 | 951 |
689205 | 689205 | 2020-11-01 | Providence | Rhode Island | 44007 | 23320 | 951 |
685960 | 685960 | 2020-10-31 | Providence | Rhode Island | 44007 | 23320 | 951 |
682717 | 682717 | 2020-10-30 | Providence | Rhode Island | 44007 | 23320 | 951 |
679474 | 679474 | 2020-10-29 | Providence | Rhode Island | 44007 | 23320 | 951 |
676231 | 676231 | 2020-10-28 | Providence | Rhode Island | 44007 | 23320 | 951 |
616775 | 616775 | 2020-10-10 | Hennepin | Minnesota | 27053 | 29929 | 951 |
613534 | 613534 | 2020-10-09 | Hennepin | Minnesota | 27053 | 29661 | 951 |
416183 | 416183 | 2020-08-09 | Macomb | Michigan | 26099 | 10674 | 951 |
412963 | 412963 | 2020-08-08 | Macomb | Michigan | 26099 | 10580 | 951 |
241339 | 241339 | 2020-06-15 | Suffolk | Massachusetts | 25025 | 19334 | 951 |
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);