ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 6285 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- North Carolina 10
- Texas 8
- Georgia 5
- Virginia 5
- Alabama 4
- Kentucky 4
- Missouri 4
- California 3
- Indiana 3
- Minnesota 3
- Illinois 2
- New Jersey 2
- Ohio 2
- Pennsylvania 2
- Puerto Rico 2
- Wyoming 2
- Colorado 1
- Louisiana 1
- Maine 1
- Mississippi 1
- Nevada 1
- Oklahoma 1
- South Carolina 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420522 | 2420522 | 2022-04-18 | Corozal | Puerto Rico | 72047 | 6285 | |
2336834 | 2336834 | 2022-03-24 | Geneva | Alabama | 1061 | 6285 | 163 |
2326851 | 2326851 | 2022-03-20 | Winchester city | Virginia | 51840 | 6285 | 76 |
2323598 | 2323598 | 2022-03-19 | Winchester city | Virginia | 51840 | 6285 | 76 |
2320344 | 2320344 | 2022-03-18 | Winchester city | Virginia | 51840 | 6285 | 76 |
2278774 | 2278774 | 2022-03-06 | Stephens | Georgia | 13257 | 6285 | 138 |
2275521 | 2275521 | 2022-03-05 | Stephens | Georgia | 13257 | 6285 | 138 |
2272268 | 2272268 | 2022-03-04 | Stephens | Georgia | 13257 | 6285 | 138 |
2257841 | 2257841 | 2022-02-27 | Canovanas | Puerto Rico | 72029 | 6285 | |
2224350 | 2224350 | 2022-02-17 | Le Sueur | Minnesota | 27079 | 6285 | 49 |
2180132 | 2180132 | 2022-02-03 | DeWitt | Texas | 48123 | 6285 | 87 |
2173361 | 2173361 | 2022-02-01 | Abbeville | South Carolina | 45001 | 6285 | 59 |
2157613 | 2157613 | 2022-01-27 | Botetourt | Virginia | 51023 | 6285 | 71 |
2154661 | 2154661 | 2022-01-26 | Park | Wyoming | 56029 | 6285 | 126 |
2077622 | 2077622 | 2022-01-03 | Bell | Kentucky | 21013 | 6285 | 121 |
1970683 | 1970683 | 2021-12-01 | Becker | Minnesota | 27005 | 6285 | 74 |
1962466 | 1962466 | 2021-11-28 | Wharton | Texas | 48481 | 6285 | 189 |
1959215 | 1959215 | 2021-11-27 | Wharton | Texas | 48481 | 6285 | 189 |
1955964 | 1955964 | 2021-11-26 | Wharton | Texas | 48481 | 6285 | 189 |
1952713 | 1952713 | 2021-11-25 | Wharton | Texas | 48481 | 6285 | 189 |
1949462 | 1949462 | 2021-11-24 | Wharton | Texas | 48481 | 6285 | 189 |
1875504 | 1875504 | 2021-11-02 | Bryan | Georgia | 13029 | 6285 | 70 |
1858831 | 1858831 | 2021-10-27 | Albany | Wyoming | 56001 | 6285 | 32 |
1837277 | 1837277 | 2021-10-21 | St. John the Baptist | Louisiana | 22095 | 6285 | 170 |
1832466 | 1832466 | 2021-10-19 | Uvalde | Texas | 48463 | 6285 | 105 |
1828430 | 1828430 | 2021-10-18 | Brown | Ohio | 39015 | 6285 | 82 |
1805392 | 1805392 | 2021-10-11 | Lyon | Nevada | 32019 | 6285 | 97 |
1766623 | 1766623 | 2021-09-29 | Vance | North Carolina | 37181 | 6285 | 93 |
1763686 | 1763686 | 2021-09-28 | Mifflin | Pennsylvania | 42087 | 6285 | 185 |
1725334 | 1725334 | 2021-09-16 | Campbell | Virginia | 51031 | 6285 | 118 |
1721740 | 1721740 | 2021-09-15 | Rhea | Tennessee | 47143 | 6285 | 89 |
1715919 | 1715919 | 2021-09-14 | Escambia | Alabama | 1053 | 6285 | 97 |
1665025 | 1665025 | 2021-08-29 | Scott | Kentucky | 21209 | 6285 | 37 |
1661777 | 1661777 | 2021-08-28 | Scott | Kentucky | 21209 | 6285 | 37 |
1658529 | 1658529 | 2021-08-27 | Scott | Kentucky | 21209 | 6285 | 37 |
1591015 | 1591015 | 2021-08-06 | Salem | New Jersey | 34033 | 6285 | 190 |
1589053 | 1589053 | 2021-08-05 | Walla Walla | Washington | 53071 | 6285 | 74 |
1554146 | 1554146 | 2021-07-26 | Ogle | Illinois | 17141 | 6285 | 92 |
1508282 | 1508282 | 2021-07-12 | Garfield | Colorado | 8045 | 6285 | 50 |
1508767 | 1508767 | 2021-07-12 | Marshall | Indiana | 18099 | 6285 | 118 |
1506724 | 1506724 | 2021-07-11 | Lenoir | North Carolina | 37107 | 6285 | 126 |
1503478 | 1503478 | 2021-07-10 | Lenoir | North Carolina | 37107 | 6285 | 126 |
1500232 | 1500232 | 2021-07-09 | Lenoir | North Carolina | 37107 | 6285 | 126 |
1415078 | 1415078 | 2021-06-13 | Penobscot | Maine | 23019 | 6285 | 94 |
1399106 | 1399106 | 2021-06-08 | Lafayette | Mississippi | 28071 | 6285 | 120 |
1329731 | 1329731 | 2021-05-18 | Yuba | California | 6115 | 6285 | 49 |
1326484 | 1326484 | 2021-05-17 | Yuba | California | 6115 | 6285 | 49 |
1324928 | 1324928 | 2021-05-16 | Duplin | North Carolina | 37061 | 6285 | 133 |
1321682 | 1321682 | 2021-05-15 | Duplin | North Carolina | 37061 | 6285 | 133 |
1318436 | 1318436 | 2021-05-14 | Duplin | North Carolina | 37061 | 6285 | 133 |
1279471 | 1279471 | 2021-05-02 | Columbus | North Carolina | 37047 | 6285 | 150 |
1276224 | 1276224 | 2021-05-01 | Columbus | North Carolina | 37047 | 6285 | 150 |
1272977 | 1272977 | 2021-04-30 | Columbus | North Carolina | 37047 | 6285 | 150 |
1249664 | 1249664 | 2021-04-23 | Crow Wing | Minnesota | 27035 | 6285 | 86 |
1171134 | 1171134 | 2021-03-30 | Morgan | Indiana | 18109 | 6285 | 139 |
1123969 | 1123969 | 2021-03-15 | Lawrence | Pennsylvania | 42073 | 6285 | 189 |
991462 | 991462 | 2021-02-02 | Wise | Texas | 48497 | 6285 | 99 |
937368 | 937368 | 2021-01-17 | Bartholomew | Indiana | 18005 | 6285 | 100 |
892747 | 892747 | 2021-01-03 | Christian | Missouri | 29043 | 6285 | 49 |
889501 | 889501 | 2021-01-02 | Christian | Missouri | 29043 | 6285 | 49 |
890122 | 890122 | 2021-01-02 | Tuscarawas | Ohio | 39157 | 6285 | 154 |
886255 | 886255 | 2021-01-01 | Christian | Missouri | 29043 | 6285 | 49 |
883010 | 883010 | 2020-12-31 | Christian | Missouri | 29043 | 6285 | 49 |
828118 | 828118 | 2020-12-14 | Cumberland | New Jersey | 34011 | 6285 | 193 |
671188 | 671188 | 2020-10-27 | Champaign | Illinois | 17019 | 6285 | 29 |
631641 | 631641 | 2020-10-15 | Baldwin | Alabama | 1003 | 6285 | 66 |
632103 | 632103 | 2020-10-15 | Henry | Georgia | 13151 | 6285 | 106 |
508604 | 508604 | 2020-09-07 | Tuscaloosa | Alabama | 1125 | 6285 | 104 |
495814 | 495814 | 2020-09-03 | Marin | California | 6041 | 6285 | 96 |
349612 | 349612 | 2020-07-19 | Tulsa | Oklahoma | 40143 | 6285 | 84 |
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);