ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 6538 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 7
- Louisiana 5
- Wisconsin 5
- North Carolina 4
- South Dakota 4
- Tennessee 4
- Texas 4
- Washington 4
- Georgia 3
- Indiana 3
- Kansas 3
- Virginia 3
- Alabama 2
- Arizona 2
- Colorado 2
- Florida 2
- Maryland 2
- Ohio 2
- Pennsylvania 2
- Puerto Rico 2
- West Virginia 2
- Arkansas 1
- California 1
- Idaho 1
- Illinois 1
- Maine 1
- Minnesota 1
- Missouri 1
- New Hampshire 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471624 | 2471624 | 2022-05-04 | Le Sueur | Minnesota | 27079 | 6538 | 51 |
2446569 | 2446569 | 2022-04-26 | Corozal | Puerto Rico | 72047 | 6538 | |
2302024 | 2302024 | 2022-03-13 | Allen | Kentucky | 21003 | 6538 | 94 |
2298772 | 2298772 | 2022-03-12 | Allen | Kentucky | 21003 | 6538 | 94 |
2295520 | 2295520 | 2022-03-11 | Allen | Kentucky | 21003 | 6538 | 94 |
2292268 | 2292268 | 2022-03-10 | Allen | Kentucky | 21003 | 6538 | 94 |
2289016 | 2289016 | 2022-03-09 | Allen | Kentucky | 21003 | 6538 | 94 |
2291117 | 2291117 | 2022-03-09 | Boone | West Virginia | 54005 | 6538 | 74 |
2285765 | 2285765 | 2022-03-08 | Allen | Kentucky | 21003 | 6538 | 94 |
2287121 | 2287121 | 2022-03-08 | Dorado | Puerto Rico | 72051 | 6538 | |
2282513 | 2282513 | 2022-03-07 | Allen | Kentucky | 21003 | 6538 | 94 |
2271003 | 2271003 | 2022-03-03 | Lawrence | South Dakota | 46081 | 6538 | 82 |
2257997 | 2257997 | 2022-02-27 | Lawrence | South Dakota | 46081 | 6538 | 82 |
2254746 | 2254746 | 2022-02-26 | Lawrence | South Dakota | 46081 | 6538 | 82 |
2251495 | 2251495 | 2022-02-25 | Lawrence | South Dakota | 46081 | 6538 | 82 |
2237150 | 2237150 | 2022-02-21 | Richland | Louisiana | 22083 | 6538 | 92 |
2203339 | 2203339 | 2022-02-10 | Jackson | West Virginia | 54035 | 6538 | 120 |
2164962 | 2164962 | 2022-01-30 | Toombs | Georgia | 13279 | 6538 | 178 |
2161707 | 2161707 | 2022-01-29 | Toombs | Georgia | 13279 | 6538 | 178 |
2158451 | 2158451 | 2022-01-28 | Toombs | Georgia | 13279 | 6538 | 178 |
2157478 | 2157478 | 2022-01-27 | Palo Pinto | Texas | 48363 | 6538 | 137 |
2149386 | 2149386 | 2022-01-25 | Queen Anne's | Maryland | 24035 | 6538 | 102 |
2141836 | 2141836 | 2022-01-23 | St. Francis | Arkansas | 5123 | 6538 | 74 |
2111864 | 2111864 | 2022-01-13 | Hill | Texas | 48217 | 6538 | 178 |
2089233 | 2089233 | 2022-01-06 | Washington | Texas | 48477 | 6538 | 135 |
2081065 | 2081065 | 2022-01-04 | Somerset | Maine | 23025 | 6538 | 72 |
2033428 | 2033428 | 2021-12-20 | Perry | Pennsylvania | 42099 | 6538 | 145 |
2033547 | 2033547 | 2021-12-20 | Dillon | South Carolina | 45033 | 6538 | 119 |
2012788 | 2012788 | 2021-12-14 | Vernon | Louisiana | 22115 | 6538 | 167 |
2013467 | 2013467 | 2021-12-14 | Cortland | New York | 36023 | 6538 | 90 |
2009537 | 2009537 | 2021-12-13 | Vernon | Louisiana | 22115 | 6538 | 167 |
1989623 | 1989623 | 2021-12-07 | Putnam | Indiana | 18133 | 6538 | 89 |
1986168 | 1986168 | 2021-12-06 | Bonner | Idaho | 16017 | 6538 | 133 |
1988562 | 1988562 | 2021-12-06 | Danville city | Virginia | 51590 | 6538 | 199 |
1984501 | 1984501 | 2021-12-05 | Williams | Ohio | 39171 | 6538 | 99 |
1970109 | 1970109 | 2021-12-01 | Miami | Indiana | 18103 | 6538 | 114 |
1906280 | 1906280 | 2021-11-11 | Davie | North Carolina | 37059 | 6538 | 80 |
1903031 | 1903031 | 2021-11-10 | Davie | North Carolina | 37059 | 6538 | 80 |
1880130 | 1880130 | 2021-11-03 | Belknap | New Hampshire | 33001 | 6538 | 126 |
1881305 | 1881305 | 2021-11-03 | Culpeper | Virginia | 51047 | 6538 | 86 |
1833111 | 1833111 | 2021-10-20 | Broomfield | Colorado | 8014 | 6538 | 81 |
1827091 | 1827091 | 2021-10-18 | Gibson | Indiana | 18051 | 6538 | 117 |
1815959 | 1815959 | 2021-10-14 | Obion | Tennessee | 47131 | 6538 | 110 |
1807506 | 1807506 | 2021-10-12 | Henry | Illinois | 17073 | 6538 | 105 |
1700819 | 1700819 | 2021-09-09 | St. Bernard | Louisiana | 22087 | 6538 | 86 |
1702403 | 1702403 | 2021-09-09 | Jim Wells | Texas | 48249 | 6538 | 134 |
1678847 | 1678847 | 2021-09-02 | Edgecombe | North Carolina | 37065 | 6538 | 115 |
1565818 | 1565818 | 2021-07-29 | Roane | Tennessee | 47145 | 6538 | 109 |
1507927 | 1507927 | 2021-07-11 | Calumet | Wisconsin | 55015 | 6538 | 56 |
1504681 | 1504681 | 2021-07-10 | Calumet | Wisconsin | 55015 | 6538 | 56 |
1501435 | 1501435 | 2021-07-09 | Calumet | Wisconsin | 55015 | 6538 | 56 |
1498189 | 1498189 | 2021-07-08 | Calumet | Wisconsin | 55015 | 6538 | 56 |
1494942 | 1494942 | 2021-07-07 | Calumet | Wisconsin | 55015 | 6538 | 56 |
1491518 | 1491518 | 2021-07-06 | Harrisonburg city | Virginia | 51660 | 6538 | 95 |
1469302 | 1469302 | 2021-06-30 | Yuba | California | 6115 | 6538 | 51 |
1456345 | 1456345 | 2021-06-26 | Fremont | Colorado | 8043 | 6538 | 63 |
1335262 | 1335262 | 2021-05-19 | Bedford | Tennessee | 47003 | 6538 | 129 |
1189673 | 1189673 | 2021-04-04 | Chelan | Washington | 53007 | 6538 | 64 |
1186426 | 1186426 | 2021-04-03 | Chelan | Washington | 53007 | 6538 | 64 |
1183179 | 1183179 | 2021-04-02 | Chelan | Washington | 53007 | 6538 | 64 |
1167227 | 1167227 | 2021-03-29 | Gila | Arizona | 4007 | 6538 | 219 |
1124212 | 1124212 | 2021-03-15 | Coffee | Tennessee | 47031 | 6538 | 116 |
1104013 | 1104013 | 2021-03-09 | Eddy | New Mexico | 35015 | 6538 | 119 |
1079533 | 1079533 | 2021-03-02 | Walker | Alabama | 1127 | 6538 | 258 |
1078390 | 1078390 | 2021-03-01 | Creek | Oklahoma | 40037 | 6538 | 117 |
998174 | 998174 | 2021-02-04 | Thurston | Washington | 53067 | 6538 | 69 |
954100 | 954100 | 2021-01-22 | Carroll | Maryland | 24013 | 6538 | 186 |
951161 | 951161 | 2021-01-21 | Cass | Missouri | 29037 | 6538 | 68 |
846769 | 846769 | 2020-12-20 | Reno | Kansas | 20155 | 6538 | 87 |
843523 | 843523 | 2020-12-19 | Reno | Kansas | 20155 | 6538 | 86 |
840278 | 840278 | 2020-12-18 | Reno | Kansas | 20155 | 6538 | 84 |
792897 | 792897 | 2020-12-03 | Centre | Pennsylvania | 42027 | 6538 | 68 |
771205 | 771205 | 2020-11-27 | Morgan | Alabama | 1103 | 6538 | 50 |
734346 | 734346 | 2020-11-15 | Warren | Ohio | 39165 | 6538 | 72 |
686899 | 686899 | 2020-11-01 | Navajo | Arizona | 4017 | 6538 | 241 |
497392 | 497392 | 2020-09-03 | Burlington | New Jersey | 34005 | 6538 | 482 |
489495 | 489495 | 2020-09-01 | Lake | Florida | 12069 | 6538 | 118 |
441015 | 441015 | 2020-08-17 | Brevard | Florida | 12009 | 6538 | 178 |
232687 | 232687 | 2020-06-12 | Mecklenburg | North Carolina | 37119 | 6538 | 123 |
110675 | 110675 | 2020-05-03 | Orleans | Louisiana | 22071 | 6538 | 441 |
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);