ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 6151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Tennessee 10
- Texas 10
- Minnesota 6
- Pennsylvania 5
- Arkansas 3
- Georgia 3
- Indiana 3
- Kentucky 3
- Missouri 3
- Ohio 3
- Florida 2
- North Carolina 2
- Virginia 2
- Alabama 1
- Colorado 1
- Kansas 1
- Louisiana 1
- Maine 1
- New Jersey 1
- New York 1
- Puerto Rico 1
- Vermont 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2391264 | 2391264 | 2022-04-09 | San Sebastian | Puerto Rico | 72131 | 6151 | |
2356608 | 2356608 | 2022-03-30 | Montezuma | Colorado | 8083 | 6151 | 72 |
2332893 | 2332893 | 2022-03-22 | Morgan | Tennessee | 47129 | 6151 | 80 |
2333218 | 2333218 | 2022-03-22 | Orleans | Vermont | 50019 | 6151 | 37 |
2329640 | 2329640 | 2022-03-21 | Morgan | Tennessee | 47129 | 6151 | 80 |
2326388 | 2326388 | 2022-03-20 | Morgan | Tennessee | 47129 | 6151 | 80 |
2323135 | 2323135 | 2022-03-19 | Morgan | Tennessee | 47129 | 6151 | 80 |
2319881 | 2319881 | 2022-03-18 | Morgan | Tennessee | 47129 | 6151 | 80 |
2316627 | 2316627 | 2022-03-17 | Morgan | Tennessee | 47129 | 6151 | 80 |
2313374 | 2313374 | 2022-03-16 | Morgan | Tennessee | 47129 | 6151 | 80 |
2196771 | 2196771 | 2022-02-08 | Winchester city | Virginia | 51840 | 6151 | 70 |
2156768 | 2156768 | 2022-01-27 | Henry | Ohio | 39069 | 6151 | 97 |
2143038 | 2143038 | 2022-01-23 | Nobles | Minnesota | 27105 | 6151 | 56 |
2139783 | 2139783 | 2022-01-22 | Nobles | Minnesota | 27105 | 6151 | 56 |
2139935 | 2139935 | 2022-01-22 | Dunklin | Missouri | 29069 | 6151 | 93 |
2136527 | 2136527 | 2022-01-21 | Nobles | Minnesota | 27105 | 6151 | 56 |
2131622 | 2131622 | 2022-01-19 | Gloucester | Virginia | 51073 | 6151 | 84 |
2021248 | 2021248 | 2021-12-16 | Preston | West Virginia | 54077 | 6151 | 109 |
1969466 | 1969466 | 2021-12-01 | Baxter | Arkansas | 5005 | 6151 | 188 |
1942651 | 1942651 | 2021-11-22 | Giles | Tennessee | 47055 | 6151 | 127 |
1924970 | 1924970 | 2021-11-17 | Beauregard | Louisiana | 22011 | 6151 | 124 |
1869699 | 1869699 | 2021-10-31 | Perry | Kentucky | 21193 | 6151 | 88 |
1866450 | 1866450 | 2021-10-30 | Perry | Kentucky | 21193 | 6151 | 88 |
1863201 | 1863201 | 2021-10-29 | Perry | Kentucky | 21193 | 6151 | 88 |
1841682 | 1841682 | 2021-10-22 | Venango | Pennsylvania | 42121 | 6151 | 131 |
1806314 | 1806314 | 2021-10-11 | Erath | Texas | 48143 | 6151 | 96 |
1803064 | 1803064 | 2021-10-10 | Erath | Texas | 48143 | 6151 | 96 |
1799815 | 1799815 | 2021-10-09 | Erath | Texas | 48143 | 6151 | 96 |
1783749 | 1783749 | 2021-10-04 | Wood | Texas | 48499 | 6151 | 198 |
1780500 | 1780500 | 2021-10-03 | Wood | Texas | 48499 | 6151 | 197 |
1777250 | 1777250 | 2021-10-02 | Wood | Texas | 48499 | 6151 | 197 |
1773024 | 1773024 | 2021-10-01 | Tompkins | New York | 36109 | 6151 | 59 |
1774000 | 1774000 | 2021-10-01 | Wood | Texas | 48499 | 6151 | 197 |
1678457 | 1678457 | 2021-09-02 | Johnson | Missouri | 29101 | 6151 | 64 |
1464523 | 1464523 | 2021-06-28 | Lee | North Carolina | 37105 | 6151 | 83 |
1425943 | 1425943 | 2021-06-16 | Union | Pennsylvania | 42119 | 6151 | 89 |
1422696 | 1422696 | 2021-06-15 | Union | Pennsylvania | 42119 | 6151 | 89 |
1419450 | 1419450 | 2021-06-14 | Union | Pennsylvania | 42119 | 6151 | 89 |
1382768 | 1382768 | 2021-06-03 | Chisago | Minnesota | 27025 | 6151 | 52 |
1379522 | 1379522 | 2021-06-02 | Chisago | Minnesota | 27025 | 6151 | 52 |
1369643 | 1369643 | 2021-05-30 | Penobscot | Maine | 23019 | 6151 | 93 |
1345862 | 1345862 | 2021-05-23 | Greene | Arkansas | 5055 | 6151 | 77 |
1339366 | 1339366 | 2021-05-21 | Greene | Arkansas | 5055 | 6151 | 77 |
1312302 | 1312302 | 2021-05-12 | Indiana | Pennsylvania | 42063 | 6151 | 173 |
1297743 | 1297743 | 2021-05-08 | Dubois | Indiana | 18037 | 6151 | 118 |
1294497 | 1294497 | 2021-05-07 | Dubois | Indiana | 18037 | 6151 | 118 |
1261661 | 1261661 | 2021-04-27 | Jackson | Florida | 12063 | 6151 | 156 |
1212974 | 1212974 | 2021-04-12 | Putnam | Florida | 12107 | 6151 | 136 |
1200966 | 1200966 | 2021-04-08 | Kandiyohi | Minnesota | 27067 | 6151 | 79 |
1191788 | 1191788 | 2021-04-05 | Columbus | North Carolina | 37047 | 6151 | 149 |
1157401 | 1157401 | 2021-03-26 | Colbert | Alabama | 1033 | 6151 | 125 |
1136748 | 1136748 | 2021-03-19 | Hancock | Ohio | 39063 | 6151 | 121 |
1104736 | 1104736 | 2021-03-09 | Cumberland | Tennessee | 47035 | 6151 | 123 |
1096456 | 1096456 | 2021-03-07 | Morgan | Indiana | 18109 | 6151 | 134 |
1052812 | 1052812 | 2021-02-21 | Gibson | Tennessee | 47053 | 6151 | 139 |
966326 | 966326 | 2021-01-26 | Gordon | Georgia | 13129 | 6151 | 81 |
894973 | 894973 | 2021-01-04 | Newton | Georgia | 13217 | 6151 | 127 |
848510 | 848510 | 2020-12-20 | Gregg | Texas | 48183 | 6151 | 140 |
845265 | 845265 | 2020-12-19 | Gregg | Texas | 48183 | 6151 | 139 |
842019 | 842019 | 2020-12-18 | Gregg | Texas | 48183 | 6151 | 138 |
813325 | 813325 | 2020-12-09 | Laramie | Wyoming | 56021 | 6151 | 35 |
779164 | 779164 | 2020-11-29 | Cole | Missouri | 29051 | 6151 | 49 |
746169 | 746169 | 2020-11-19 | Shawnee | Kansas | 20177 | 6151 | 104 |
581832 | 581832 | 2020-09-29 | Butler | Ohio | 39017 | 6151 | 112 |
259279 | 259279 | 2020-06-21 | Gwinnett | Georgia | 13135 | 6151 | 162 |
96933 | 96933 | 2020-04-28 | Ocean | New Jersey | 34029 | 6151 | 342 |
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);