ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 7475 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Florida 17
- Ohio 9
- South Carolina 3
- Wyoming 3
- Colorado 2
- Indiana 2
- New York 2
- North Carolina 2
- Pennsylvania 2
- Texas 2
- Virginia 2
- Wisconsin 2
- Alabama 1
- Arkansas 1
- Georgia 1
- Illinois 1
- Iowa 1
- Kentucky 1
- Maryland 1
- Michigan 1
- Mississippi 1
- Montana 1
- North Dakota 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441626 | 2441626 | 2022-04-25 | Perry | Illinois | 17145 | 7475 | 106 |
2428254 | 2428254 | 2022-04-21 | Bradford | Florida | 12007 | 7475 | 149 |
2424998 | 2424998 | 2022-04-20 | Bradford | Florida | 12007 | 7475 | 149 |
2421742 | 2421742 | 2022-04-19 | Bradford | Florida | 12007 | 7475 | 149 |
2418486 | 2418486 | 2022-04-18 | Bradford | Florida | 12007 | 7475 | 149 |
2415230 | 2415230 | 2022-04-17 | Bradford | Florida | 12007 | 7475 | 149 |
2411974 | 2411974 | 2022-04-16 | Bradford | Florida | 12007 | 7475 | 149 |
2408718 | 2408718 | 2022-04-15 | Bradford | Florida | 12007 | 7475 | 149 |
2405462 | 2405462 | 2022-04-14 | Bradford | Florida | 12007 | 7475 | 149 |
2402207 | 2402207 | 2022-04-13 | Bradford | Florida | 12007 | 7475 | 149 |
2398952 | 2398952 | 2022-04-12 | Bradford | Florida | 12007 | 7475 | 148 |
2395697 | 2395697 | 2022-04-11 | Bradford | Florida | 12007 | 7475 | 148 |
2392441 | 2392441 | 2022-04-10 | Bradford | Florida | 12007 | 7475 | 148 |
2389185 | 2389185 | 2022-04-09 | Bradford | Florida | 12007 | 7475 | 148 |
2385930 | 2385930 | 2022-04-08 | Bradford | Florida | 12007 | 7475 | 148 |
2381188 | 2381188 | 2022-04-06 | Gallia | Ohio | 39053 | 7475 | 124 |
2377933 | 2377933 | 2022-04-05 | Gallia | Ohio | 39053 | 7475 | 124 |
2374679 | 2374679 | 2022-04-04 | Gallia | Ohio | 39053 | 7475 | 124 |
2371427 | 2371427 | 2022-04-03 | Gallia | Ohio | 39053 | 7475 | 124 |
2368174 | 2368174 | 2022-04-02 | Gallia | Ohio | 39053 | 7475 | 124 |
2364921 | 2364921 | 2022-04-01 | Gallia | Ohio | 39053 | 7475 | 124 |
2361668 | 2361668 | 2022-03-31 | Gallia | Ohio | 39053 | 7475 | 124 |
2322909 | 2322909 | 2022-03-19 | Humacao | Puerto Rico | 72069 | 7475 | |
2104776 | 2104776 | 2022-01-11 | Williams | Ohio | 39171 | 7475 | 132 |
2057389 | 2057389 | 2021-12-28 | La Plata | Colorado | 8067 | 7475 | 67 |
2044173 | 2044173 | 2021-12-24 | Tallapoosa | Alabama | 1123 | 7475 | 204 |
1971265 | 1971265 | 2021-12-01 | Beaufort | North Carolina | 37013 | 7475 | 132 |
1946848 | 1946848 | 2021-11-24 | Broomfield | Colorado | 8014 | 7475 | 84 |
1900155 | 1900155 | 2021-11-09 | Mifflin | Pennsylvania | 42087 | 7475 | 207 |
1836034 | 1836034 | 2021-10-20 | Grant | Wisconsin | 55043 | 7475 | 114 |
1764306 | 1764306 | 2021-09-28 | Albemarle | Virginia | 51003 | 7475 | 92 |
1759188 | 1759188 | 2021-09-27 | Jessamine | Kentucky | 21113 | 7475 | 85 |
1758109 | 1758109 | 2021-09-26 | Campbell | Wyoming | 56005 | 7475 | 74 |
1754861 | 1754861 | 2021-09-25 | Campbell | Wyoming | 56005 | 7475 | 74 |
1751613 | 1751613 | 2021-09-24 | Campbell | Wyoming | 56005 | 7475 | 74 |
1669059 | 1669059 | 2021-08-30 | St. Lawrence | New York | 36089 | 7475 | 99 |
1543160 | 1543160 | 2021-07-22 | Coryell | Texas | 48099 | 7475 | 89 |
1533946 | 1533946 | 2021-07-19 | Portage | Wisconsin | 55097 | 7475 | 75 |
1429737 | 1429737 | 2021-06-17 | Wise | Texas | 48497 | 7475 | 124 |
1375091 | 1375091 | 2021-06-01 | Lonoke | Arkansas | 5085 | 7475 | 121 |
1309203 | 1309203 | 2021-05-11 | Kershaw | South Carolina | 45055 | 7475 | 140 |
1305957 | 1305957 | 2021-05-10 | Kershaw | South Carolina | 45055 | 7475 | 140 |
1285262 | 1285262 | 2021-05-04 | Wicomico | Maryland | 24045 | 7475 | 152 |
1244825 | 1244825 | 2021-04-21 | Lynchburg city | Virginia | 51680 | 7475 | 145 |
1190583 | 1190583 | 2021-04-05 | Floyd | Indiana | 18043 | 7475 | 179 |
1189762 | 1189762 | 2021-04-04 | Wood | West Virginia | 54107 | 7475 | 164 |
1171809 | 1171809 | 2021-03-30 | Forrest | Mississippi | 28035 | 7475 | 144 |
1118268 | 1118268 | 2021-03-13 | Thurston | Washington | 53067 | 7475 | 78 |
1039531 | 1039531 | 2021-02-17 | Umatilla | Oregon | 41059 | 7475 | 79 |
1034398 | 1034398 | 2021-02-16 | Nassau | Florida | 12089 | 7475 | 107 |
1016178 | 1016178 | 2021-02-10 | Cascade | Montana | 30013 | 7475 | 149 |
1016524 | 1016524 | 2021-02-10 | Moore | North Carolina | 37125 | 7475 | 143 |
922635 | 922635 | 2021-01-12 | Muskogee | Oklahoma | 40101 | 7475 | 56 |
846509 | 846509 | 2020-12-20 | Clark | Indiana | 18019 | 7475 | 110 |
827194 | 827194 | 2020-12-14 | Pottawattamie | Iowa | 19155 | 7475 | 78 |
802778 | 802778 | 2020-12-06 | Berkeley | South Carolina | 45015 | 7475 | 105 |
779748 | 779748 | 2020-11-29 | Lorain | Ohio | 39093 | 7475 | 106 |
750453 | 750453 | 2020-11-20 | Grand Forks | North Dakota | 38035 | 7475 | 39 |
576882 | 576882 | 2020-09-28 | Lake | Florida | 12069 | 7475 | 190 |
502431 | 502431 | 2020-09-05 | Leon | Florida | 12073 | 7475 | 39 |
476663 | 476663 | 2020-08-28 | Hall | Georgia | 13139 | 7475 | 122 |
314592 | 314592 | 2020-07-08 | Delaware | Pennsylvania | 42045 | 7475 | 706 |
304667 | 304667 | 2020-07-05 | Erie | New York | 36029 | 7475 | 599 |
107948 | 107948 | 2020-05-02 | Oakland | Michigan | 26125 | 7475 | 745 |
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);