ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 5337 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Florida 10
- Georgia 9
- Wisconsin 8
- Illinois 6
- Ohio 6
- Virginia 6
- Louisiana 4
- New York 3
- Texas 3
- Colorado 2
- Kansas 2
- Michigan 2
- Missouri 2
- North Carolina 2
- South Dakota 2
- Washington 2
- California 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- New Mexico 1
- North Dakota 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Tennessee 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427640 | 2427640 | 2022-04-20 | Dinwiddie | Virginia | 51053 | 5337 | 89 |
2424476 | 2424476 | 2022-04-19 | Waynesboro city | Virginia | 51820 | 5337 | 60 |
2421220 | 2421220 | 2022-04-18 | Waynesboro city | Virginia | 51820 | 5337 | 60 |
2285454 | 2285454 | 2022-03-08 | Union | Illinois | 17181 | 5337 | 67 |
2218343 | 2218343 | 2022-02-15 | Essex | New York | 36031 | 5337 | 54 |
2194000 | 2194000 | 2022-02-08 | Morgan | Colorado | 8087 | 5337 | 132 |
2109362 | 2109362 | 2022-01-13 | Siskiyou | California | 6093 | 5337 | 81 |
2096670 | 2096670 | 2022-01-09 | White | Georgia | 13311 | 5337 | 135 |
2097308 | 2097308 | 2022-01-09 | West Baton Rouge | Louisiana | 22121 | 5337 | 79 |
2093418 | 2093418 | 2022-01-08 | White | Georgia | 13311 | 5337 | 135 |
2094056 | 2094056 | 2022-01-08 | West Baton Rouge | Louisiana | 22121 | 5337 | 79 |
2090166 | 2090166 | 2022-01-07 | White | Georgia | 13311 | 5337 | 135 |
2090804 | 2090804 | 2022-01-07 | West Baton Rouge | Louisiana | 22121 | 5337 | 79 |
2086915 | 2086915 | 2022-01-06 | White | Georgia | 13311 | 5337 | 135 |
2088878 | 2088878 | 2022-01-06 | Meade | South Dakota | 46093 | 5337 | 56 |
2083663 | 2083663 | 2022-01-05 | White | Georgia | 13311 | 5337 | 135 |
2020865 | 2020865 | 2021-12-16 | Kendall | Texas | 48259 | 5337 | 102 |
1963155 | 1963155 | 2021-11-29 | Summit | Colorado | 8117 | 5337 | 12 |
1964830 | 1964830 | 2021-11-29 | Person | North Carolina | 37145 | 5337 | 89 |
1927419 | 1927419 | 2021-11-18 | Bradford | Florida | 12007 | 5337 | 119 |
1924169 | 1924169 | 2021-11-17 | Bradford | Florida | 12007 | 5337 | 119 |
1920920 | 1920920 | 2021-11-16 | Bradford | Florida | 12007 | 5337 | 119 |
1917670 | 1917670 | 2021-11-15 | Bradford | Florida | 12007 | 5337 | 119 |
1914420 | 1914420 | 2021-11-14 | Bradford | Florida | 12007 | 5337 | 119 |
1911170 | 1911170 | 2021-11-13 | Bradford | Florida | 12007 | 5337 | 119 |
1913482 | 1913482 | 2021-11-13 | Bee | Texas | 48025 | 5337 | 131 |
1907921 | 1907921 | 2021-11-12 | Bradford | Florida | 12007 | 5337 | 119 |
1906194 | 1906194 | 2021-11-11 | Allegany | New York | 36003 | 5337 | 107 |
1892014 | 1892014 | 2021-11-07 | Monroe | Illinois | 17133 | 5337 | 105 |
1888764 | 1888764 | 2021-11-06 | Monroe | Illinois | 17133 | 5337 | 105 |
1885514 | 1885514 | 2021-11-05 | Monroe | Illinois | 17133 | 5337 | 105 |
1878978 | 1878978 | 2021-11-03 | Fulton | Illinois | 17057 | 5337 | 90 |
1872520 | 1872520 | 2021-11-01 | Morgan | Illinois | 17137 | 5337 | 123 |
1871551 | 1871551 | 2021-10-31 | Charlottesville city | Virginia | 51540 | 5337 | 59 |
1868302 | 1868302 | 2021-10-30 | Charlottesville city | Virginia | 51540 | 5337 | 59 |
1865053 | 1865053 | 2021-10-29 | Charlottesville city | Virginia | 51540 | 5337 | 59 |
1769334 | 1769334 | 2021-09-30 | Lincoln | Mississippi | 28085 | 5337 | 133 |
1753708 | 1753708 | 2021-09-25 | Clinton | Ohio | 39027 | 5337 | 81 |
1748233 | 1748233 | 2021-09-23 | Whitman | Washington | 53075 | 5337 | 55 |
1727719 | 1727719 | 2021-09-17 | Defiance | Ohio | 39039 | 5337 | 100 |
1712600 | 1712600 | 2021-09-12 | Polk | Wisconsin | 55095 | 5337 | 69 |
1709353 | 1709353 | 2021-09-11 | Polk | Wisconsin | 55095 | 5337 | 69 |
1706106 | 1706106 | 2021-09-10 | Polk | Wisconsin | 55095 | 5337 | 69 |
1604466 | 1604466 | 2021-08-10 | Yamhill | Oregon | 41071 | 5337 | 84 |
1582109 | 1582109 | 2021-08-03 | Burnet | Texas | 48053 | 5337 | 73 |
1529642 | 1529642 | 2021-07-18 | Washington | Ohio | 39167 | 5337 | 111 |
1520986 | 1520986 | 2021-07-15 | Fremont | Wyoming | 56013 | 5337 | 87 |
1507129 | 1507129 | 2021-07-11 | Guaynabo | Puerto Rico | 72061 | 5337 | |
1475381 | 1475381 | 2021-07-01 | Lewis | Washington | 53041 | 5337 | 77 |
1462531 | 1462531 | 2021-06-27 | Shawano | Wisconsin | 55115 | 5337 | 85 |
1459286 | 1459286 | 2021-06-26 | Shawano | Wisconsin | 55115 | 5337 | 85 |
1456041 | 1456041 | 2021-06-25 | Shawano | Wisconsin | 55115 | 5337 | 85 |
1452796 | 1452796 | 2021-06-24 | Shawano | Wisconsin | 55115 | 5337 | 85 |
1449550 | 1449550 | 2021-06-23 | Shawano | Wisconsin | 55115 | 5337 | 85 |
1412670 | 1412670 | 2021-06-12 | Morton | North Dakota | 38059 | 5337 | 101 |
1403034 | 1403034 | 2021-06-09 | Seneca | Ohio | 39147 | 5337 | 126 |
1396544 | 1396544 | 2021-06-07 | Seneca | Ohio | 39147 | 5337 | 126 |
1362380 | 1362380 | 2021-05-28 | Coffee | Georgia | 13069 | 5337 | 172 |
1355887 | 1355887 | 2021-05-26 | Coffee | Georgia | 13069 | 5337 | 173 |
1340832 | 1340832 | 2021-05-21 | Taney | Missouri | 29213 | 5337 | 94 |
1331057 | 1331057 | 2021-05-18 | Newton | Missouri | 29145 | 5337 | 78 |
1300651 | 1300651 | 2021-05-09 | Suwannee | Florida | 12121 | 5337 | 139 |
1297404 | 1297404 | 2021-05-08 | Suwannee | Florida | 12121 | 5337 | 139 |
1294158 | 1294158 | 2021-05-07 | Suwannee | Florida | 12121 | 5337 | 138 |
1295906 | 1295906 | 2021-05-07 | Sandusky | Ohio | 39143 | 5337 | 120 |
1256068 | 1256068 | 2021-04-25 | Branch | Michigan | 26023 | 5337 | 118 |
1252821 | 1252821 | 2021-04-24 | Branch | Michigan | 26023 | 5337 | 118 |
1236497 | 1236497 | 2021-04-19 | St. Charles | Louisiana | 22089 | 5337 | 90 |
1192327 | 1192327 | 2021-04-05 | Brown | South Dakota | 46013 | 5337 | 91 |
1152113 | 1152113 | 2021-03-24 | St. Mary's | Maryland | 24037 | 5337 | 120 |
1098316 | 1098316 | 2021-03-07 | Warren | Tennessee | 47177 | 5337 | 77 |
1052216 | 1052216 | 2021-02-21 | Lee | North Carolina | 37105 | 5337 | 66 |
921360 | 921360 | 2021-01-12 | Ford | Kansas | 20057 | 5337 | 10 |
918115 | 918115 | 2021-01-11 | Ford | Kansas | 20057 | 5337 | 10 |
907911 | 907911 | 2021-01-08 | Gordon | Georgia | 13129 | 5337 | 66 |
875540 | 875540 | 2020-12-29 | Walton | Georgia | 13297 | 5337 | 88 |
676121 | 676121 | 2020-10-28 | Luzerne | Pennsylvania | 42079 | 5337 | 198 |
669212 | 669212 | 2020-10-26 | Onondaga | New York | 36067 | 5337 | 186 |
464624 | 464624 | 2020-08-24 | Dakota | Minnesota | 27037 | 5337 | 110 |
439262 | 439262 | 2020-08-16 | Bernalillo | New Mexico | 35001 | 5337 | 137 |
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);