ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 6659 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 9
- Kentucky 8
- Mississippi 5
- Ohio 5
- Arkansas 4
- Texas 4
- Indiana 3
- Puerto Rico 3
- Kansas 2
- South Carolina 2
- Alabama 1
- Connecticut 1
- Georgia 1
- Michigan 1
- Missouri 1
- New Hampshire 1
- New Jersey 1
- New York 1
- Pennsylvania 1
- Utah 1
- Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456353 | 2456353 | 2022-04-29 | Juana Diaz | Puerto Rico | 72075 | 6659 | |
2416010 | 2416010 | 2022-04-17 | Rowan | Kentucky | 21205 | 6659 | 64 |
2412754 | 2412754 | 2022-04-16 | Rowan | Kentucky | 21205 | 6659 | 64 |
2409498 | 2409498 | 2022-04-15 | Rowan | Kentucky | 21205 | 6659 | 64 |
2406242 | 2406242 | 2022-04-14 | Rowan | Kentucky | 21205 | 6659 | 64 |
2402986 | 2402986 | 2022-04-13 | Rowan | Kentucky | 21205 | 6659 | 64 |
2399732 | 2399732 | 2022-04-12 | Rowan | Kentucky | 21205 | 6659 | 64 |
2396476 | 2396476 | 2022-04-11 | Rowan | Kentucky | 21205 | 6659 | 64 |
2384712 | 2384712 | 2022-04-07 | Dorado | Puerto Rico | 72051 | 6659 | |
2316775 | 2316775 | 2022-03-17 | Hutchinson | Texas | 48233 | 6659 | 135 |
2281656 | 2281656 | 2022-03-07 | Johnson | Arkansas | 5071 | 6659 | 73 |
2278403 | 2278403 | 2022-03-06 | Johnson | Arkansas | 5071 | 6659 | 73 |
2235476 | 2235476 | 2022-02-20 | Howard | Texas | 48227 | 6659 | 167 |
2232225 | 2232225 | 2022-02-19 | Howard | Texas | 48227 | 6659 | 166 |
2172373 | 2172373 | 2022-02-01 | Covington | Mississippi | 28031 | 6659 | 98 |
2155153 | 2155153 | 2022-01-27 | Lumpkin | Georgia | 13187 | 6659 | 112 |
2109475 | 2109475 | 2022-01-13 | Hardee | Florida | 12049 | 6659 | 104 |
2106224 | 2106224 | 2022-01-12 | Hardee | Florida | 12049 | 6659 | 104 |
2102973 | 2102973 | 2022-01-11 | Hardee | Florida | 12049 | 6659 | 104 |
2099722 | 2099722 | 2022-01-10 | Hardee | Florida | 12049 | 6659 | 104 |
2096471 | 2096471 | 2022-01-09 | Hardee | Florida | 12049 | 6659 | 104 |
2093219 | 2093219 | 2022-01-08 | Hardee | Florida | 12049 | 6659 | 104 |
2089967 | 2089967 | 2022-01-07 | Hardee | Florida | 12049 | 6659 | 104 |
2009128 | 2009128 | 2021-12-13 | Putnam | Indiana | 18133 | 6659 | 90 |
1978181 | 1978181 | 2021-12-03 | Wayne | Pennsylvania | 42127 | 6659 | 124 |
1968201 | 1968201 | 2021-11-30 | Highland | Ohio | 39071 | 6659 | 119 |
1918090 | 1918090 | 2021-11-15 | Knox | Indiana | 18083 | 6659 | 113 |
1899916 | 1899916 | 2021-11-09 | Brown | Ohio | 39015 | 6659 | 101 |
1900833 | 1900833 | 2021-11-09 | Henry | Virginia | 51089 | 6659 | 165 |
1837581 | 1837581 | 2021-10-21 | Pontotoc | Mississippi | 28115 | 6659 | 102 |
1746683 | 1746683 | 2021-09-23 | Johnson | Missouri | 29101 | 6659 | 68 |
1734501 | 1734501 | 2021-09-19 | Guaynabo | Puerto Rico | 72061 | 6659 | |
1724522 | 1724522 | 2021-09-16 | Sandusky | Ohio | 39143 | 6659 | 132 |
1717383 | 1717383 | 2021-09-14 | Washington | Mississippi | 28151 | 6659 | 146 |
1662480 | 1662480 | 2021-08-28 | Salem | New Jersey | 34033 | 6659 | 193 |
1589334 | 1589334 | 2021-08-06 | Crittenden | Arkansas | 5035 | 6659 | 101 |
1541936 | 1541936 | 2021-07-22 | Lamar | Mississippi | 28073 | 6659 | 88 |
1509114 | 1509114 | 2021-07-12 | Pulaski | Kentucky | 21199 | 6659 | 122 |
1352593 | 1352593 | 2021-05-25 | Putnam | Florida | 12107 | 6659 | 156 |
1286124 | 1286124 | 2021-05-04 | Geauga | Ohio | 39055 | 6659 | 148 |
1270239 | 1270239 | 2021-04-29 | Georgetown | South Carolina | 45043 | 6659 | 139 |
1032238 | 1032238 | 2021-02-15 | Lauderdale | Mississippi | 28075 | 6659 | 219 |
962942 | 962942 | 2021-01-25 | Tolland | Connecticut | 9013 | 6659 | 127 |
963332 | 963332 | 2021-01-25 | Bartholomew | Indiana | 18005 | 6659 | 106 |
959749 | 959749 | 2021-01-24 | Nassau | Florida | 12089 | 6659 | 79 |
939113 | 939113 | 2021-01-17 | Oconee | South Carolina | 45073 | 6659 | 81 |
932317 | 932317 | 2021-01-15 | Wayne | Ohio | 39169 | 6659 | 162 |
904201 | 904201 | 2021-01-06 | Natrona | Wyoming | 56025 | 6659 | 96 |
852322 | 852322 | 2020-12-22 | Houston | Alabama | 1069 | 6659 | 53 |
853259 | 853259 | 2020-12-22 | Reno | Kansas | 20155 | 6659 | 89 |
850014 | 850014 | 2020-12-21 | Reno | Kansas | 20155 | 6659 | 88 |
730743 | 730743 | 2020-11-14 | Hillsborough | New Hampshire | 33011 | 6659 | 328 |
668603 | 668603 | 2020-10-26 | Genesee | Michigan | 26049 | 6659 | 334 |
495108 | 495108 | 2020-09-02 | Jefferson | Texas | 48245 | 6659 | 107 |
469923 | 469923 | 2020-08-26 | Washington | Arkansas | 5143 | 6659 | 55 |
359895 | 359895 | 2020-07-22 | Utah | Utah | 49049 | 6659 | 31 |
229478 | 229478 | 2020-06-11 | Erie | New York | 36029 | 6659 | 566 |
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);