ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 6020 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Oklahoma 7
- Texas 7
- Virginia 7
- Kansas 5
- Tennessee 5
- Missouri 4
- North Carolina 4
- Arkansas 3
- Kentucky 3
- Mississippi 2
- Colorado 1
- Florida 1
- Georgia 1
- Idaho 1
- Illinois 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- New York 1
- North Dakota 1
- Ohio 1
- Pennsylvania 1
- Puerto Rico 1
- Utah 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333306 | 2333306 | 2022-03-22 | Mecklenburg | Virginia | 51117 | 6020 | 112 |
2330053 | 2330053 | 2022-03-21 | Mecklenburg | Virginia | 51117 | 6020 | 112 |
2310921 | 2310921 | 2022-03-16 | Jackson | Arkansas | 5067 | 6020 | 58 |
2307668 | 2307668 | 2022-03-15 | Jackson | Arkansas | 5067 | 6020 | 58 |
2304417 | 2304417 | 2022-03-14 | Jackson | Arkansas | 5067 | 6020 | 58 |
2270899 | 2270899 | 2022-03-03 | San Sebastian | Puerto Rico | 72131 | 6020 | |
2235483 | 2235483 | 2022-02-20 | Jasper | Texas | 48241 | 6020 | 176 |
2220802 | 2220802 | 2022-02-16 | Lincoln | Kentucky | 21137 | 6020 | 118 |
2152755 | 2152755 | 2022-01-26 | Cass | Minnesota | 27021 | 6020 | 70 |
2077626 | 2077626 | 2022-01-03 | Boyle | Kentucky | 21021 | 6020 | 116 |
2055003 | 2055003 | 2021-12-27 | Evangeline | Louisiana | 22039 | 6020 | 144 |
2033651 | 2033651 | 2021-12-20 | Carroll | Tennessee | 47017 | 6020 | 114 |
2030675 | 2030675 | 2021-12-19 | Polk | Texas | 48373 | 6020 | 219 |
2024211 | 2024211 | 2021-12-17 | Titus | Texas | 48449 | 6020 | 104 |
1972502 | 1972502 | 2021-12-01 | Wayne | West Virginia | 54099 | 6020 | 91 |
1951705 | 1951705 | 2021-11-25 | Cortland | New York | 36023 | 6020 | 88 |
1925973 | 1925973 | 2021-11-17 | Preble | Ohio | 39135 | 6020 | 136 |
1894884 | 1894884 | 2021-11-08 | Montrose | Colorado | 8085 | 6020 | 91 |
1883179 | 1883179 | 2021-11-04 | Platte | Missouri | 29165 | 6020 | 61 |
1833957 | 1833957 | 2021-10-20 | Perry | Kentucky | 21193 | 6020 | 87 |
1806577 | 1806577 | 2021-10-11 | Danville city | Virginia | 51590 | 6020 | 175 |
1803327 | 1803327 | 2021-10-10 | Danville city | Virginia | 51590 | 6020 | 175 |
1800078 | 1800078 | 2021-10-09 | Danville city | Virginia | 51590 | 6020 | 175 |
1796829 | 1796829 | 2021-10-08 | Danville city | Virginia | 51590 | 6020 | 175 |
1773822 | 1773822 | 2021-10-01 | Erath | Texas | 48143 | 6020 | 93 |
1711347 | 1711347 | 2021-09-12 | Haywood | North Carolina | 37087 | 6020 | 113 |
1708100 | 1708100 | 2021-09-11 | Haywood | North Carolina | 37087 | 6020 | 113 |
1704853 | 1704853 | 2021-09-10 | Haywood | North Carolina | 37087 | 6020 | 113 |
1682946 | 1682946 | 2021-09-03 | Medina | Texas | 48325 | 6020 | 131 |
1668656 | 1668656 | 2021-08-30 | Warren | Mississippi | 28149 | 6020 | 145 |
1669118 | 1669118 | 2021-08-30 | Hoke | North Carolina | 37093 | 6020 | 59 |
1642097 | 1642097 | 2021-08-22 | Crawford | Kansas | 20037 | 6020 | 96 |
1638847 | 1638847 | 2021-08-21 | Crawford | Kansas | 20037 | 6020 | 96 |
1635597 | 1635597 | 2021-08-20 | Crawford | Kansas | 20037 | 6020 | 96 |
1597283 | 1597283 | 2021-08-08 | Pettis | Missouri | 29159 | 6020 | 81 |
1542753 | 1542753 | 2021-07-22 | Armstrong | Pennsylvania | 42005 | 6020 | 148 |
1534623 | 1534623 | 2021-07-20 | Grundy | Illinois | 17063 | 6020 | 83 |
1410279 | 1410279 | 2021-06-11 | Iron | Utah | 49021 | 6020 | 33 |
1309981 | 1309981 | 2021-05-11 | Waupaca | Wisconsin | 55135 | 6020 | 164 |
1217394 | 1217394 | 2021-04-13 | Joplin | Missouri | 6020 | 106 | |
1204304 | 1204304 | 2021-04-09 | Lafayette | Mississippi | 28071 | 6020 | 117 |
1197279 | 1197279 | 2021-04-07 | Finney | Kansas | 20055 | 6020 | 49 |
1194031 | 1194031 | 2021-04-06 | Finney | Kansas | 20055 | 6020 | 49 |
1172532 | 1172532 | 2021-03-30 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1169285 | 1169285 | 2021-03-29 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1166037 | 1166037 | 2021-03-28 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1162789 | 1162789 | 2021-03-27 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1159540 | 1159540 | 2021-03-26 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1156293 | 1156293 | 2021-03-25 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1153046 | 1153046 | 2021-03-24 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1134010 | 1134010 | 2021-03-18 | Roane | Tennessee | 47145 | 6020 | 96 |
1121009 | 1121009 | 2021-03-14 | McMinn | Tennessee | 47107 | 6020 | 93 |
1117762 | 1117762 | 2021-03-13 | McMinn | Tennessee | 47107 | 6020 | 93 |
1114515 | 1114515 | 2021-03-12 | McMinn | Tennessee | 47107 | 6020 | 93 |
1056128 | 1056128 | 2021-02-22 | Anderson | Texas | 48001 | 6020 | 104 |
1052882 | 1052882 | 2021-02-21 | Anderson | Texas | 48001 | 6020 | 104 |
1008579 | 1008579 | 2021-02-08 | Rockdale | Georgia | 13247 | 6020 | 117 |
1008656 | 1008656 | 2021-02-08 | Madison | Idaho | 16065 | 6020 | 21 |
999565 | 999565 | 2021-02-05 | Hampshire | Massachusetts | 25015 | 6020 | 239 |
936449 | 936449 | 2021-01-16 | Roanoke city | Virginia | 51770 | 6020 | 110 |
921646 | 921646 | 2021-01-12 | Carroll | Maryland | 24013 | 6020 | 178 |
883037 | 883037 | 2020-12-31 | Jasper | Missouri | 29097 | 6020 | 84 |
656369 | 656369 | 2020-10-22 | Burleigh | North Dakota | 38015 | 6020 | 74 |
281152 | 281152 | 2020-06-28 | Pinellas | Florida | 12103 | 6020 | 154 |
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);