ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 7181 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Illinois 4
- Alabama 3
- Louisiana 3
- Mississippi 3
- New York 3
- West Virginia 3
- Georgia 2
- North Carolina 2
- Pennsylvania 2
- Puerto Rico 2
- Tennessee 2
- Virginia 2
- California 1
- Florida 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Minnesota 1
- New Hampshire 1
- New Jersey 1
- Oregon 1
- Texas 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501960 | 2501960 | 2022-05-13 | Manati | Puerto Rico | 72091 | 7181 | |
2496048 | 2496048 | 2022-05-11 | Halifax | Virginia | 51083 | 7181 | 159 |
2361369 | 2361369 | 2022-03-31 | Unknown | New Hampshire | 7181 | 26 | |
2359087 | 2359087 | 2022-03-30 | Kleberg | Texas | 48273 | 7181 | 146 |
2304756 | 2304756 | 2022-03-14 | Lumpkin | Georgia | 13187 | 7181 | 128 |
2212373 | 2212373 | 2022-02-13 | Rio Grande | Puerto Rico | 72119 | 7181 | |
2165557 | 2165557 | 2022-01-30 | Allen | Louisiana | 22003 | 7181 | 120 |
2162302 | 2162302 | 2022-01-29 | Allen | Louisiana | 22003 | 7181 | 120 |
2159047 | 2159047 | 2022-01-28 | Allen | Louisiana | 22003 | 7181 | 120 |
2077990 | 2077990 | 2022-01-03 | Morrison | Minnesota | 27097 | 7181 | 87 |
2037497 | 2037497 | 2021-12-21 | Ohio | West Virginia | 54069 | 7181 | 125 |
2021416 | 2021416 | 2021-12-17 | Russell | Alabama | 1113 | 7181 | 66 |
2014718 | 2014718 | 2021-12-14 | Fayette | West Virginia | 54019 | 7181 | 144 |
1970043 | 1970043 | 2021-12-01 | Stephenson | Illinois | 17177 | 7181 | 124 |
1916420 | 1916420 | 2021-11-14 | Venango | Pennsylvania | 42121 | 7181 | 152 |
1881518 | 1881518 | 2021-11-03 | Dunn | Wisconsin | 55033 | 7181 | 46 |
1859916 | 1859916 | 2021-10-28 | Knox | Kentucky | 21121 | 7181 | 53 |
1806161 | 1806161 | 2021-10-11 | Cocke | Tennessee | 47029 | 7181 | 103 |
1756690 | 1756690 | 2021-09-26 | Salem | New Jersey | 34033 | 7181 | 200 |
1721404 | 1721404 | 2021-09-15 | Yamhill | Oregon | 41071 | 7181 | 96 |
1676776 | 1676776 | 2021-09-01 | Harrison | West Virginia | 54033 | 7181 | 83 |
1534027 | 1534027 | 2021-07-20 | Jackson | Alabama | 1071 | 7181 | 117 |
1301720 | 1301720 | 2021-05-09 | Lauderdale | Mississippi | 28075 | 7181 | 240 |
1298472 | 1298472 | 2021-05-08 | Lauderdale | Mississippi | 28075 | 7181 | 240 |
1295226 | 1295226 | 2021-05-07 | Lauderdale | Mississippi | 28075 | 7181 | 240 |
1284736 | 1284736 | 2021-05-04 | Whiteside | Illinois | 17195 | 7181 | 208 |
1269684 | 1269684 | 2021-04-29 | Oswego | New York | 36075 | 7181 | 90 |
1223042 | 1223042 | 2021-04-15 | Williamson | Illinois | 17199 | 7181 | 138 |
1128599 | 1128599 | 2021-03-17 | Dougherty | Georgia | 13095 | 7181 | 286 |
1012103 | 1012103 | 2021-02-09 | Warrick | Indiana | 18173 | 7181 | 140 |
1009277 | 1009277 | 2021-02-08 | Carroll | Maryland | 24013 | 7181 | 203 |
978132 | 978132 | 2021-01-29 | Anderson | Tennessee | 47001 | 7181 | 125 |
928825 | 928825 | 2021-01-14 | Ulster | New York | 36111 | 7181 | 179 |
929230 | 929230 | 2021-01-14 | Lycoming | Pennsylvania | 42081 | 7181 | 170 |
847776 | 847776 | 2020-12-20 | Randolph | North Carolina | 37151 | 7181 | 109 |
753671 | 753671 | 2020-11-21 | Union | North Carolina | 37179 | 7181 | 72 |
745519 | 745519 | 2020-11-19 | Clay | Florida | 12019 | 7181 | 139 |
728999 | 728999 | 2020-11-14 | Lee | Alabama | 1081 | 7181 | 65 |
693489 | 693489 | 2020-11-03 | Marin | California | 6041 | 7181 | 127 |
618413 | 618413 | 2020-10-10 | Loudoun | Virginia | 51107 | 7181 | 128 |
606398 | 606398 | 2020-10-07 | Winnebago | Illinois | 17201 | 7181 | 156 |
276285 | 276285 | 2020-06-26 | Erie | New York | 36029 | 7181 | 594 |
139049 | 139049 | 2020-05-12 | King | Washington | 53033 | 7181 | 513 |
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);