ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where deaths = 1062 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Florida 15
- Texas 9
- Ohio 8
- Pennsylvania 8
- Illinois 7
- California 5
- Missouri 4
- Colorado 3
- Indiana 3
- Kansas 3
- Maryland 3
- Michigan 3
- New Jersey 3
- Oregon 3
- Massachusetts 2
- Arizona 1
- Georgia 1
- Louisiana 1
- Nebraska 1
- New York 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459116 | 2459116 | 2022-04-30 | Onondaga | New York | 36067 | 119467 | 1062 |
2377045 | 2377045 | 2022-04-05 | Anne Arundel | Maryland | 24003 | 89340 | 1062 |
2373793 | 2373793 | 2022-04-04 | Anne Arundel | Maryland | 24003 | 89313 | 1062 |
2280514 | 2280514 | 2022-03-06 | Multnomah | Oregon | 41051 | 111223 | 1062 |
2277261 | 2277261 | 2022-03-05 | Multnomah | Oregon | 41051 | 111223 | 1062 |
2274008 | 2274008 | 2022-03-04 | Multnomah | Oregon | 41051 | 111223 | 1062 |
2262366 | 2262366 | 2022-03-01 | Osceola | Florida | 12097 | 112194 | 1062 |
2259115 | 2259115 | 2022-02-28 | Osceola | Florida | 12097 | 112194 | 1062 |
2255864 | 2255864 | 2022-02-27 | Osceola | Florida | 12097 | 112194 | 1062 |
2252613 | 2252613 | 2022-02-26 | Osceola | Florida | 12097 | 112194 | 1062 |
2249362 | 2249362 | 2022-02-25 | Osceola | Florida | 12097 | 112194 | 1062 |
2246111 | 2246111 | 2022-02-24 | Osceola | Florida | 12097 | 111633 | 1062 |
2247438 | 2247438 | 2022-02-24 | Douglas | Nebraska | 31055 | 141529 | 1062 |
2242860 | 2242860 | 2022-02-23 | Osceola | Florida | 12097 | 111633 | 1062 |
2211523 | 2211523 | 2022-02-13 | Jackson | Missouri | 29095 | 92941 | 1062 |
2208270 | 2208270 | 2022-02-12 | Jackson | Missouri | 29095 | 92941 | 1062 |
2205017 | 2205017 | 2022-02-11 | Jackson | Missouri | 29095 | 92941 | 1062 |
2201764 | 2201764 | 2022-02-10 | Jackson | Missouri | 29095 | 92941 | 1062 |
2177558 | 2177558 | 2022-02-03 | Yuma | Arizona | 4027 | 59797 | 1062 |
2148546 | 2148546 | 2022-01-25 | St. Lucie | Florida | 12111 | 66811 | 1062 |
2145294 | 2145294 | 2022-01-24 | St. Lucie | Florida | 12111 | 66811 | 1062 |
2142039 | 2142039 | 2022-01-23 | St. Lucie | Florida | 12111 | 66811 | 1062 |
2138784 | 2138784 | 2022-01-22 | St. Lucie | Florida | 12111 | 66811 | 1062 |
2135528 | 2135528 | 2022-01-21 | St. Lucie | Florida | 12111 | 66811 | 1062 |
2136942 | 2136942 | 2022-01-21 | Burlington | New Jersey | 34005 | 93673 | 1062 |
2132276 | 2132276 | 2022-01-20 | St. Lucie | Florida | 12111 | 62521 | 1062 |
2129023 | 2129023 | 2022-01-19 | St. Lucie | Florida | 12111 | 62521 | 1062 |
2036166 | 2036166 | 2021-12-21 | Mercer | New Jersey | 34021 | 45231 | 1062 |
1991630 | 1991630 | 2021-12-07 | Lubbock | Texas | 48303 | 68812 | 1062 |
1972040 | 1972040 | 2021-12-01 | Denton | Texas | 48121 | 111194 | 1062 |
1926935 | 1926935 | 2021-11-17 | Spokane | Washington | 53063 | 76604 | 1062 |
1874644 | 1874644 | 2021-11-01 | Montgomery | Texas | 48339 | 87917 | 1062 |
1871395 | 1871395 | 2021-10-31 | Montgomery | Texas | 48339 | 87917 | 1062 |
1868146 | 1868146 | 2021-10-30 | Montgomery | Texas | 48339 | 87917 | 1062 |
1830878 | 1830878 | 2021-10-19 | Genesee | Michigan | 26049 | 50574 | 1062 |
1827629 | 1827629 | 2021-10-18 | Genesee | Michigan | 26049 | 50574 | 1062 |
1823377 | 1823377 | 2021-10-17 | El Paso | Colorado | 8041 | 97085 | 1062 |
1820128 | 1820128 | 2021-10-16 | El Paso | Colorado | 8041 | 97085 | 1062 |
1816879 | 1816879 | 2021-10-15 | El Paso | Colorado | 8041 | 97085 | 1062 |
1806285 | 1806285 | 2021-10-11 | Collin | Texas | 48085 | 126634 | 1062 |
1803035 | 1803035 | 2021-10-10 | Collin | Texas | 48085 | 126354 | 1062 |
1714914 | 1714914 | 2021-09-13 | Berks | Pennsylvania | 42011 | 52464 | 1062 |
1711668 | 1711668 | 2021-09-12 | Berks | Pennsylvania | 42011 | 52359 | 1062 |
1708421 | 1708421 | 2021-09-11 | Berks | Pennsylvania | 42011 | 52237 | 1062 |
1700792 | 1700792 | 2021-09-09 | East Baton Rouge | Louisiana | 22033 | 60609 | 1062 |
1592058 | 1592058 | 2021-08-06 | Travis | Texas | 48453 | 91894 | 1062 |
1578327 | 1578327 | 2021-08-02 | Montgomery | Ohio | 39113 | 54055 | 1062 |
1575079 | 1575079 | 2021-08-01 | Montgomery | Ohio | 39113 | 53995 | 1062 |
1571831 | 1571831 | 2021-07-31 | Montgomery | Ohio | 39113 | 53918 | 1062 |
1568583 | 1568583 | 2021-07-30 | Montgomery | Ohio | 39113 | 53804 | 1062 |
1565335 | 1565335 | 2021-07-29 | Montgomery | Ohio | 39113 | 53732 | 1062 |
1562087 | 1562087 | 2021-07-28 | Montgomery | Ohio | 39113 | 53658 | 1062 |
1558839 | 1558839 | 2021-07-27 | Montgomery | Ohio | 39113 | 53542 | 1062 |
1505517 | 1505517 | 2021-07-11 | Lake | Indiana | 18089 | 56617 | 1062 |
1502271 | 1502271 | 2021-07-10 | Lake | Indiana | 18089 | 56617 | 1062 |
1499025 | 1499025 | 2021-07-09 | Lake | Indiana | 18089 | 56617 | 1062 |
1329723 | 1329723 | 2021-05-18 | Stanislaus | California | 6099 | 62336 | 1062 |
1329910 | 1329910 | 2021-05-18 | Cobb | Georgia | 13067 | 79353 | 1062 |
1330137 | 1330137 | 2021-05-18 | Lake | Illinois | 17097 | 67508 | 1062 |
1326890 | 1326890 | 2021-05-17 | Lake | Illinois | 17097 | 67459 | 1062 |
1310707 | 1310707 | 2021-05-12 | Will | Illinois | 17197 | 75352 | 1062 |
1307461 | 1307461 | 2021-05-11 | Will | Illinois | 17197 | 75240 | 1062 |
1304215 | 1304215 | 2021-05-10 | Will | Illinois | 17197 | 75162 | 1062 |
1300968 | 1300968 | 2021-05-09 | Will | Illinois | 17197 | 75056 | 1062 |
1298226 | 1298226 | 2021-05-08 | Baltimore city | Maryland | 24510 | 51850 | 1062 |
1120722 | 1120722 | 2021-03-14 | Lancaster | Pennsylvania | 42071 | 45335 | 1062 |
1117475 | 1117475 | 2021-03-13 | Lancaster | Pennsylvania | 42071 | 45247 | 1062 |
1114228 | 1114228 | 2021-03-12 | Lancaster | Pennsylvania | 42071 | 45127 | 1062 |
1073972 | 1073972 | 2021-02-28 | Unknown | Kansas | 0 | 1062 | |
1070726 | 1070726 | 2021-02-27 | Unknown | Kansas | 0 | 1062 | |
1067481 | 1067481 | 2021-02-26 | Unknown | Kansas | 0 | 1062 | |
1037613 | 1037613 | 2021-02-17 | Duval | Florida | 12031 | 86872 | 1062 |
945439 | 945439 | 2021-01-19 | Delaware | Pennsylvania | 42045 | 34717 | 1062 |
941985 | 941985 | 2021-01-18 | Cuyahoga | Ohio | 39035 | 82613 | 1062 |
927148 | 927148 | 2021-01-14 | Sacramento | California | 6067 | 78267 | 1062 |
895098 | 895098 | 2021-01-04 | DuPage | Illinois | 17043 | 63396 | 1062 |
848104 | 848104 | 2020-12-20 | Montgomery | Pennsylvania | 42091 | 31421 | 1062 |
807071 | 807071 | 2020-12-08 | San Diego | California | 6073 | 95508 | 1062 |
803826 | 803826 | 2020-12-07 | San Diego | California | 6073 | 94232 | 1062 |
800581 | 800581 | 2020-12-06 | San Diego | California | 6073 | 92234 | 1062 |
659407 | 659407 | 2020-10-23 | Ocean | New Jersey | 34029 | 16424 | 1062 |
516246 | 516246 | 2020-09-09 | Worcester | Massachusetts | 25027 | 13678 | 1062 |
478832 | 478832 | 2020-08-28 | Bexar | Texas | 48029 | 46095 | 1062 |
400036 | 400036 | 2020-08-04 | Suffolk | Massachusetts | 25025 | 21481 | 1062 |
232083 | 232083 | 2020-06-12 | Oakland | Michigan | 26125 | 11286 | 1062 |
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);