ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 6327 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Michigan 10
- Indiana 9
- Georgia 6
- Texas 6
- Pennsylvania 5
- Virginia 5
- Louisiana 4
- North Carolina 4
- Tennessee 4
- Colorado 3
- Maryland 3
- Ohio 3
- Illinois 2
- Mississippi 2
- New Jersey 2
- New York 2
- South Carolina 2
- West Virginia 2
- Wisconsin 2
- California 1
- Florida 1
- Kentucky 1
- Missouri 1
- Montana 1
- New Mexico 1
- North Dakota 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461005 | 2461005 | 2022-05-01 | Stephens | Georgia | 13257 | 6327 | 158 |
2457749 | 2457749 | 2022-04-30 | Stephens | Georgia | 13257 | 6327 | 158 |
2454493 | 2454493 | 2022-04-29 | Stephens | Georgia | 13257 | 6327 | 158 |
2451237 | 2451237 | 2022-04-28 | Stephens | Georgia | 13257 | 6327 | 158 |
2447981 | 2447981 | 2022-04-27 | Stephens | Georgia | 13257 | 6327 | 158 |
2423756 | 2423756 | 2022-04-19 | Aguada | Puerto Rico | 72003 | 6327 | |
2377147 | 2377147 | 2022-04-05 | Oceana | Michigan | 26127 | 6327 | 89 |
2373895 | 2373895 | 2022-04-04 | Oceana | Michigan | 26127 | 6327 | 89 |
2370499 | 2370499 | 2022-04-03 | Sabine | Louisiana | 22085 | 6327 | 109 |
2370642 | 2370642 | 2022-04-03 | Oceana | Michigan | 26127 | 6327 | 89 |
2367246 | 2367246 | 2022-04-02 | Sabine | Louisiana | 22085 | 6327 | 109 |
2367389 | 2367389 | 2022-04-02 | Oceana | Michigan | 26127 | 6327 | 89 |
2363993 | 2363993 | 2022-04-01 | Sabine | Louisiana | 22085 | 6327 | 109 |
2364136 | 2364136 | 2022-04-01 | Oceana | Michigan | 26127 | 6327 | 89 |
2360739 | 2360739 | 2022-03-31 | Sabine | Louisiana | 22085 | 6327 | 109 |
2282777 | 2282777 | 2022-03-07 | Emmet | Michigan | 26047 | 6327 | 83 |
2235736 | 2235736 | 2022-02-20 | Louisa | Virginia | 51109 | 6327 | 69 |
2232485 | 2232485 | 2022-02-19 | Louisa | Virginia | 51109 | 6327 | 69 |
2229234 | 2229234 | 2022-02-18 | Louisa | Virginia | 51109 | 6327 | 69 |
2199064 | 2199064 | 2022-02-09 | Henry | Ohio | 39069 | 6327 | 100 |
2196397 | 2196397 | 2022-02-08 | DeWitt | Texas | 48123 | 6327 | 88 |
2179866 | 2179866 | 2022-02-03 | Abbeville | South Carolina | 45001 | 6327 | 61 |
2145645 | 2145645 | 2022-01-24 | Greene | Indiana | 18055 | 6327 | 117 |
2135066 | 2135066 | 2022-01-20 | Door | Wisconsin | 55029 | 6327 | 53 |
2078934 | 2078934 | 2022-01-03 | Snyder | Pennsylvania | 42109 | 6327 | 128 |
2075318 | 2075318 | 2022-01-02 | Jackson | North Carolina | 37099 | 6327 | 79 |
2072067 | 2072067 | 2022-01-01 | Jackson | North Carolina | 37099 | 6327 | 79 |
2068816 | 2068816 | 2021-12-31 | Jackson | North Carolina | 37099 | 6327 | 79 |
2065905 | 2065905 | 2021-12-30 | Greene | Pennsylvania | 42059 | 6327 | 79 |
2055744 | 2055744 | 2021-12-27 | Orleans | New York | 36073 | 6327 | 103 |
2027761 | 2027761 | 2021-12-18 | Wayne | West Virginia | 54099 | 6327 | 92 |
2020391 | 2020391 | 2021-12-16 | Clarion | Pennsylvania | 42031 | 6327 | 167 |
2004171 | 2004171 | 2021-12-11 | Perry | Pennsylvania | 42099 | 6327 | 135 |
2000888 | 2000888 | 2021-12-10 | Clinton | Pennsylvania | 42035 | 6327 | 96 |
2001471 | 2001471 | 2021-12-10 | Wharton | Texas | 48481 | 6327 | 190 |
1891205 | 1891205 | 2021-11-06 | Fayette | West Virginia | 54019 | 6327 | 130 |
1863615 | 1863615 | 2021-10-29 | Camden | Missouri | 29029 | 6327 | 125 |
1846576 | 1846576 | 2021-10-24 | DeKalb | Indiana | 18033 | 6327 | 102 |
1843326 | 1843326 | 2021-10-23 | DeKalb | Indiana | 18033 | 6327 | 102 |
1840076 | 1840076 | 2021-10-22 | DeKalb | Indiana | 18033 | 6327 | 102 |
1789240 | 1789240 | 2021-10-06 | Herkimer | New York | 36043 | 6327 | 120 |
1763972 | 1763972 | 2021-09-28 | Obion | Tennessee | 47131 | 6327 | 108 |
1742127 | 1742127 | 2021-09-22 | Tuolumne | California | 6109 | 6327 | 100 |
1577529 | 1577529 | 2021-08-02 | St. Joseph | Michigan | 26149 | 6327 | 103 |
1574281 | 1574281 | 2021-08-01 | St. Joseph | Michigan | 26149 | 6327 | 103 |
1571033 | 1571033 | 2021-07-31 | St. Joseph | Michigan | 26149 | 6327 | 103 |
1567785 | 1567785 | 2021-07-30 | St. Joseph | Michigan | 26149 | 6327 | 103 |
1550981 | 1550981 | 2021-07-25 | Marshall | Indiana | 18099 | 6327 | 118 |
1547734 | 1547734 | 2021-07-24 | Marshall | Indiana | 18099 | 6327 | 118 |
1544487 | 1544487 | 2021-07-23 | Marshall | Indiana | 18099 | 6327 | 118 |
1527765 | 1527765 | 2021-07-18 | Garfield | Colorado | 8045 | 6327 | 52 |
1524518 | 1524518 | 2021-07-17 | Garfield | Colorado | 8045 | 6327 | 52 |
1521270 | 1521270 | 2021-07-16 | Garfield | Colorado | 8045 | 6327 | 52 |
1448912 | 1448912 | 2021-06-23 | Jefferson | Tennessee | 47089 | 6327 | 126 |
1445667 | 1445667 | 2021-06-22 | Jefferson | Tennessee | 47089 | 6327 | 126 |
1441061 | 1441061 | 2021-06-21 | Cecil | Maryland | 24015 | 6327 | 152 |
1437815 | 1437815 | 2021-06-20 | Cecil | Maryland | 24015 | 6327 | 152 |
1434568 | 1434568 | 2021-06-19 | Cecil | Maryland | 24015 | 6327 | 152 |
1381782 | 1381782 | 2021-06-03 | Jackson | Florida | 12063 | 6327 | 158 |
1328839 | 1328839 | 2021-05-17 | Roane | Tennessee | 47145 | 6327 | 105 |
1259519 | 1259519 | 2021-04-26 | Lowndes | Mississippi | 28087 | 6327 | 144 |
1201670 | 1201670 | 2021-04-08 | Ashtabula | Ohio | 39007 | 6327 | 161 |
1190616 | 1190616 | 2021-04-05 | Morgan | Indiana | 18109 | 6327 | 139 |
1172464 | 1172464 | 2021-03-30 | Geauga | Ohio | 39055 | 6327 | 144 |
1172612 | 1172612 | 2021-03-30 | Deschutes | Oregon | 41017 | 6327 | 70 |
1166916 | 1166916 | 2021-03-28 | Rockingham | Virginia | 51165 | 6327 | 103 |
1130896 | 1130896 | 2021-03-17 | Hood | Texas | 48221 | 6327 | 122 |
1127977 | 1127977 | 2021-03-16 | Chelan | Washington | 53007 | 6327 | 64 |
1037813 | 1037813 | 2021-02-17 | Walker | Georgia | 13295 | 6327 | 74 |
1036197 | 1036197 | 2021-02-16 | Creek | Oklahoma | 40037 | 6327 | 106 |
997068 | 997068 | 2021-02-04 | Rutherford | North Carolina | 37161 | 6327 | 181 |
993633 | 993633 | 2021-02-03 | Cape May | New Jersey | 34009 | 6327 | 165 |
970209 | 970209 | 2021-01-27 | Oldham | Kentucky | 21185 | 6327 | 63 |
956836 | 956836 | 2021-01-23 | Williamson | Illinois | 17199 | 6327 | 119 |
847417 | 847417 | 2020-12-20 | Cascade | Montana | 30013 | 6327 | 84 |
840765 | 840765 | 2020-12-18 | Madison | Mississippi | 28089 | 6327 | 126 |
833562 | 833562 | 2020-12-16 | LaPorte | Indiana | 18091 | 6327 | 119 |
813270 | 813270 | 2020-12-09 | Jefferson | Wisconsin | 55055 | 6327 | 48 |
727735 | 727735 | 2020-11-13 | Grand Forks | North Dakota | 38035 | 6327 | 29 |
698944 | 698944 | 2020-11-04 | Berkeley | South Carolina | 45015 | 6327 | 96 |
669969 | 669969 | 2020-10-26 | Bell | Texas | 48027 | 6327 | 100 |
666726 | 666726 | 2020-10-25 | Bell | Texas | 48027 | 6327 | 100 |
663481 | 663481 | 2020-10-24 | Bell | Texas | 48027 | 6327 | 99 |
565368 | 565368 | 2020-09-24 | Bernalillo | New Mexico | 35001 | 6327 | 174 |
521226 | 521226 | 2020-09-10 | Loudoun | Virginia | 51107 | 6327 | 118 |
465064 | 465064 | 2020-08-24 | Burlington | New Jersey | 34005 | 6327 | 482 |
191334 | 191334 | 2020-05-30 | Kane | Illinois | 17089 | 6327 | 176 |
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);