ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where cases = 7047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Oklahoma 14
- North Carolina 9
- Texas 8
- Alabama 5
- Ohio 5
- Louisiana 4
- Minnesota 4
- Idaho 3
- Indiana 3
- Mississippi 3
- Montana 3
- Kentucky 2
- Virginia 2
- Arizona 1
- Arkansas 1
- Connecticut 1
- Florida 1
- Georgia 1
- Iowa 1
- New Hampshire 1
- New Jersey 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492614 | 2492614 | 2022-05-10 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2489356 | 2489356 | 2022-05-09 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2486099 | 2486099 | 2022-05-08 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2482841 | 2482841 | 2022-05-07 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2456852 | 2456852 | 2022-04-29 | Willacy | Texas | 48489 | 7047 | 130 |
2452060 | 2452060 | 2022-04-28 | Cass | Minnesota | 27021 | 7047 | 80 |
2439354 | 2439354 | 2022-04-24 | Ravalli | Montana | 30081 | 7047 | 141 |
2436098 | 2436098 | 2022-04-23 | Ravalli | Montana | 30081 | 7047 | 141 |
2432842 | 2432842 | 2022-04-22 | Ravalli | Montana | 30081 | 7047 | 141 |
2290380 | 2290380 | 2022-03-09 | Gurabo | Puerto Rico | 72063 | 7047 | |
2286858 | 2286858 | 2022-03-08 | Hardin | Ohio | 39065 | 7047 | 150 |
2260175 | 2260175 | 2022-02-28 | Covington | Mississippi | 28031 | 7047 | 108 |
2217897 | 2217897 | 2022-02-15 | Adams | Mississippi | 28001 | 7047 | 139 |
2157527 | 2157527 | 2022-01-27 | Upshur | Texas | 48459 | 7047 | 163 |
2101500 | 2101500 | 2022-01-10 | Ottawa | Ohio | 39123 | 7047 | 116 |
1991065 | 1991065 | 2021-12-07 | Pittsburg | Oklahoma | 40121 | 7047 | 164 |
1987814 | 1987814 | 2021-12-06 | Pittsburg | Oklahoma | 40121 | 7047 | 164 |
1983517 | 1983517 | 2021-12-05 | St. Bernard | Louisiana | 22087 | 7047 | 99 |
1984564 | 1984564 | 2021-12-05 | Pittsburg | Oklahoma | 40121 | 7047 | 164 |
1980267 | 1980267 | 2021-12-04 | St. Bernard | Louisiana | 22087 | 7047 | 99 |
1981314 | 1981314 | 2021-12-04 | Pittsburg | Oklahoma | 40121 | 7047 | 164 |
1977017 | 1977017 | 2021-12-03 | St. Bernard | Louisiana | 22087 | 7047 | 99 |
1978064 | 1978064 | 2021-12-03 | Pittsburg | Oklahoma | 40121 | 7047 | 164 |
1973959 | 1973959 | 2021-12-02 | Isanti | Minnesota | 27059 | 7047 | 85 |
1974814 | 1974814 | 2021-12-02 | Pittsburg | Oklahoma | 40121 | 7047 | 158 |
1971565 | 1971565 | 2021-12-01 | Pittsburg | Oklahoma | 40121 | 7047 | 158 |
1883664 | 1883664 | 2021-11-04 | Auglaize | Ohio | 39011 | 7047 | 105 |
1856712 | 1856712 | 2021-10-27 | Shelby | Kentucky | 21211 | 7047 | 105 |
1853508 | 1853508 | 2021-10-26 | Lincoln | Louisiana | 22061 | 7047 | 115 |
1809003 | 1809003 | 2021-10-12 | Seneca | Ohio | 39147 | 7047 | 143 |
1782343 | 1782343 | 2021-10-04 | Oktibbeha | Mississippi | 28105 | 7047 | 125 |
1713056 | 1713056 | 2021-09-13 | Camden | Georgia | 13039 | 7047 | 75 |
1646858 | 1646858 | 2021-08-23 | Cherokee | South Carolina | 45021 | 7047 | 162 |
1488571 | 1488571 | 2021-07-06 | Jackson | Alabama | 1071 | 7047 | 114 |
1485324 | 1485324 | 2021-07-05 | Jackson | Alabama | 1071 | 7047 | 114 |
1487226 | 1487226 | 2021-07-05 | Franklin | North Carolina | 37069 | 7047 | 54 |
1482078 | 1482078 | 2021-07-04 | Jackson | Alabama | 1071 | 7047 | 114 |
1483980 | 1483980 | 2021-07-04 | Franklin | North Carolina | 37069 | 7047 | 54 |
1478831 | 1478831 | 2021-07-03 | Jackson | Alabama | 1071 | 7047 | 114 |
1480734 | 1480734 | 2021-07-03 | Franklin | North Carolina | 37069 | 7047 | 54 |
1475585 | 1475585 | 2021-07-02 | Jackson | Alabama | 1071 | 7047 | 114 |
1477487 | 1477487 | 2021-07-02 | Franklin | North Carolina | 37069 | 7047 | 54 |
1474241 | 1474241 | 2021-07-01 | Franklin | North Carolina | 37069 | 7047 | 54 |
1467750 | 1467750 | 2021-06-29 | Franklin | North Carolina | 37069 | 7047 | 54 |
1446441 | 1446441 | 2021-06-23 | Gila | Arizona | 4007 | 7047 | 229 |
1445263 | 1445263 | 2021-06-22 | Creek | Oklahoma | 40037 | 7047 | 165 |
1442018 | 1442018 | 2021-06-21 | Creek | Oklahoma | 40037 | 7047 | 165 |
1438773 | 1438773 | 2021-06-20 | Creek | Oklahoma | 40037 | 7047 | 165 |
1435526 | 1435526 | 2021-06-19 | Creek | Oklahoma | 40037 | 7047 | 165 |
1432279 | 1432279 | 2021-06-18 | Creek | Oklahoma | 40037 | 7047 | 165 |
1429033 | 1429033 | 2021-06-17 | Creek | Oklahoma | 40037 | 7047 | 165 |
1425788 | 1425788 | 2021-06-16 | Creek | Oklahoma | 40037 | 7047 | 165 |
1422312 | 1422312 | 2021-06-15 | Franklin | North Carolina | 37069 | 7047 | 54 |
1419066 | 1419066 | 2021-06-14 | Franklin | North Carolina | 37069 | 7047 | 54 |
1330511 | 1330511 | 2021-05-18 | Christian | Kentucky | 21047 | 7047 | 104 |
1209939 | 1209939 | 2021-04-11 | Madison | Idaho | 16065 | 7047 | 23 |
1206690 | 1206690 | 2021-04-10 | Madison | Idaho | 16065 | 7047 | 23 |
1203442 | 1203442 | 2021-04-09 | Madison | Idaho | 16065 | 7047 | 23 |
1195427 | 1195427 | 2021-04-06 | Somerset | Pennsylvania | 42111 | 7047 | 190 |
1195781 | 1195781 | 2021-04-06 | Coryell | Texas | 48099 | 7047 | 84 |
1170529 | 1170529 | 2021-03-30 | Lonoke | Arkansas | 5085 | 7047 | 116 |
1123010 | 1123010 | 2021-03-15 | Clay | Minnesota | 27027 | 7047 | 89 |
1096490 | 1096490 | 2021-03-07 | Wayne | Indiana | 18177 | 7047 | 195 |
1093244 | 1093244 | 2021-03-06 | Wayne | Indiana | 18177 | 7047 | 195 |
1085483 | 1085483 | 2021-03-03 | Liberty | Texas | 48291 | 7047 | 162 |
1076128 | 1076128 | 2021-02-28 | Wood | West Virginia | 54107 | 7047 | 131 |
1022834 | 1022834 | 2021-02-12 | Merrimack | New Hampshire | 33013 | 7047 | 102 |
1005527 | 1005527 | 2021-02-07 | Bartholomew | Indiana | 18005 | 7047 | 143 |
1006735 | 1006735 | 2021-02-07 | Brunswick | North Carolina | 37019 | 7047 | 107 |
998115 | 998115 | 2021-02-04 | Roanoke city | Virginia | 51770 | 7047 | 127 |
935492 | 935492 | 2021-01-16 | Columbiana | Ohio | 39029 | 7047 | 124 |
920200 | 920200 | 2021-01-11 | Newport News city | Virginia | 51700 | 7047 | 73 |
898033 | 898033 | 2021-01-05 | Middlesex | Connecticut | 9007 | 7047 | 258 |
709878 | 709878 | 2020-11-08 | St. Johns | Florida | 12109 | 7047 | 88 |
658495 | 658495 | 2020-10-23 | Woodbury | Iowa | 19193 | 7047 | 94 |
400184 | 400184 | 2020-08-04 | Ramsey | Minnesota | 27123 | 7047 | 261 |
248067 | 248067 | 2020-06-17 | Camden | New Jersey | 34007 | 7047 | 417 |
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);