ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 3573 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Georgia 9
- Tennessee 9
- Iowa 8
- Indiana 6
- Alaska 5
- Illinois 5
- Missouri 5
- New Mexico 5
- North Carolina 5
- Ohio 5
- Arkansas 4
- Minnesota 4
- Wisconsin 4
- Colorado 3
- Mississippi 3
- Nebraska 3
- Oklahoma 3
- Pennsylvania 3
- South Dakota 3
- Virginia 3
- Alabama 2
- Kansas 2
- Kentucky 2
- Maryland 2
- Arizona 1
- California 1
- Hawaii 1
- Louisiana 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502161 | 2502161 | 2022-05-13 | Lewis | Tennessee | 47101 | 3573 | 60 |
2497679 | 2497679 | 2022-05-12 | Kanabec | Minnesota | 27065 | 3573 | 57 |
2498903 | 2498903 | 2022-05-12 | Lewis | Tennessee | 47101 | 3573 | 60 |
2495645 | 2495645 | 2022-05-11 | Lewis | Tennessee | 47101 | 3573 | 60 |
2444478 | 2444478 | 2022-04-26 | Grand | Colorado | 8049 | 3573 | 26 |
2441222 | 2441222 | 2022-04-25 | Grand | Colorado | 8049 | 3573 | 26 |
2404224 | 2404224 | 2022-04-13 | Anasco | Puerto Rico | 72011 | 3573 | |
2302726 | 2302726 | 2022-03-13 | Gage | Nebraska | 31067 | 3573 | 40 |
2299474 | 2299474 | 2022-03-12 | Gage | Nebraska | 31067 | 3573 | 40 |
2296222 | 2296222 | 2022-03-11 | Gage | Nebraska | 31067 | 3573 | 40 |
2243121 | 2243121 | 2022-02-23 | Greene | Illinois | 17061 | 3573 | 56 |
2239318 | 2239318 | 2022-02-22 | Kusilvak Census Area | Alaska | 2158 | 3573 | 10 |
2236067 | 2236067 | 2022-02-21 | Kusilvak Census Area | Alaska | 2158 | 3573 | 10 |
2232816 | 2232816 | 2022-02-20 | Kusilvak Census Area | Alaska | 2158 | 3573 | 10 |
2229565 | 2229565 | 2022-02-19 | Kusilvak Census Area | Alaska | 2158 | 3573 | 10 |
2226314 | 2226314 | 2022-02-18 | Kusilvak Census Area | Alaska | 2158 | 3573 | 10 |
2224542 | 2224542 | 2022-02-17 | Macon | Missouri | 29121 | 3573 | 48 |
2225918 | 2225918 | 2022-02-17 | Appomattox | Virginia | 51011 | 3573 | 50 |
2160702 | 2160702 | 2022-01-28 | Llano | Texas | 48299 | 3573 | 88 |
2131412 | 2131412 | 2022-01-19 | Lee | Texas | 48287 | 3573 | 55 |
2126912 | 2126912 | 2022-01-18 | Cooper | Missouri | 29053 | 3573 | 64 |
2103567 | 2103567 | 2022-01-11 | Jefferson | Kansas | 20087 | 3573 | 53 |
2100316 | 2100316 | 2022-01-10 | Jefferson | Kansas | 20087 | 3573 | 53 |
2079736 | 2079736 | 2022-01-03 | Lincoln | West Virginia | 54043 | 3573 | 57 |
2007406 | 2007406 | 2021-12-12 | Juniata | Pennsylvania | 42067 | 3573 | 137 |
2007572 | 2007572 | 2021-12-12 | Beadle | South Dakota | 46005 | 3573 | 48 |
2004321 | 2004321 | 2021-12-11 | Beadle | South Dakota | 46005 | 3573 | 48 |
2001070 | 2001070 | 2021-12-10 | Beadle | South Dakota | 46005 | 3573 | 48 |
2001438 | 2001438 | 2021-12-10 | Scurry | Texas | 48415 | 3573 | 85 |
1992577 | 1992577 | 2021-12-08 | Jones | Georgia | 13169 | 3573 | 99 |
1986612 | 1986612 | 2021-12-06 | Bourbon | Kentucky | 21017 | 3573 | 39 |
1939611 | 1939611 | 2021-11-21 | Lampasas | Texas | 48281 | 3573 | 68 |
1936361 | 1936361 | 2021-11-20 | Lampasas | Texas | 48281 | 3573 | 68 |
1925058 | 1925058 | 2021-11-17 | Garrett | Maryland | 24023 | 3573 | 85 |
1853161 | 1853161 | 2021-10-26 | Bremer | Iowa | 19017 | 3573 | 68 |
1849912 | 1849912 | 2021-10-25 | Bremer | Iowa | 19017 | 3573 | 68 |
1846662 | 1846662 | 2021-10-24 | Bremer | Iowa | 19017 | 3573 | 68 |
1843412 | 1843412 | 2021-10-23 | Bremer | Iowa | 19017 | 3573 | 68 |
1840162 | 1840162 | 2021-10-22 | Bremer | Iowa | 19017 | 3573 | 68 |
1836913 | 1836913 | 2021-10-21 | Bremer | Iowa | 19017 | 3573 | 68 |
1833664 | 1833664 | 2021-10-20 | Bremer | Iowa | 19017 | 3573 | 68 |
1821450 | 1821450 | 2021-10-16 | Randolph | Missouri | 29175 | 3573 | 36 |
1759467 | 1759467 | 2021-09-27 | Cass | Minnesota | 27021 | 3573 | 38 |
1742962 | 1742962 | 2021-09-22 | Marion | Kentucky | 21155 | 3573 | 40 |
1732545 | 1732545 | 2021-09-19 | Burke | Georgia | 13033 | 3573 | 69 |
1729295 | 1729295 | 2021-09-18 | Burke | Georgia | 13033 | 3573 | 69 |
1726045 | 1726045 | 2021-09-17 | Burke | Georgia | 13033 | 3573 | 69 |
1718172 | 1718172 | 2021-09-14 | Clarion | Pennsylvania | 42031 | 3573 | 100 |
1695391 | 1695391 | 2021-09-07 | Coos | Oregon | 41011 | 3573 | 57 |
1695815 | 1695815 | 2021-09-07 | Cass | Texas | 48067 | 3573 | 106 |
1664558 | 1664558 | 2021-08-29 | Iroquois | Illinois | 17075 | 3573 | 71 |
1661310 | 1661310 | 2021-08-28 | Iroquois | Illinois | 17075 | 3573 | 71 |
1658062 | 1658062 | 2021-08-27 | Iroquois | Illinois | 17075 | 3573 | 71 |
1611283 | 1611283 | 2021-08-12 | Marion | Tennessee | 47115 | 3573 | 50 |
1577544 | 1577544 | 2021-08-02 | Carlton | Minnesota | 27017 | 3573 | 58 |
1562117 | 1562117 | 2021-07-28 | Williams | Ohio | 39171 | 3573 | 78 |
1557258 | 1557258 | 2021-07-27 | Upson | Georgia | 13293 | 3573 | 133 |
1543049 | 1543049 | 2021-07-22 | Hardeman | Tennessee | 47069 | 3573 | 64 |
1529313 | 1529313 | 2021-07-18 | Cibola | New Mexico | 35006 | 3573 | 128 |
1526066 | 1526066 | 2021-07-17 | Cibola | New Mexico | 35006 | 3573 | 128 |
1526886 | 1526886 | 2021-07-17 | Bee | Texas | 48025 | 3573 | 75 |
1522819 | 1522819 | 2021-07-16 | Cibola | New Mexico | 35006 | 3573 | 128 |
1523856 | 1523856 | 2021-07-16 | Upshur | Texas | 48459 | 3573 | 77 |
1519570 | 1519570 | 2021-07-15 | Cibola | New Mexico | 35006 | 3573 | 126 |
1516323 | 1516323 | 2021-07-14 | Cibola | New Mexico | 35006 | 3573 | 126 |
1444647 | 1444647 | 2021-06-22 | Laclede | Missouri | 29105 | 3573 | 71 |
1343264 | 1343264 | 2021-05-22 | Wabash | Indiana | 18169 | 3573 | 81 |
1329510 | 1329510 | 2021-05-18 | Dallas | Alabama | 1047 | 3573 | 153 |
1306770 | 1306770 | 2021-05-11 | Chambers | Alabama | 1017 | 3573 | 123 |
1286317 | 1286317 | 2021-05-04 | Clinton | Pennsylvania | 42035 | 3573 | 62 |
1275066 | 1275066 | 2021-05-01 | Putnam | Indiana | 18133 | 3573 | 60 |
1275907 | 1275907 | 2021-05-01 | Webster | Missouri | 29225 | 3573 | 54 |
1264733 | 1264733 | 2021-04-28 | St. Francis | Arkansas | 5123 | 3573 | 42 |
1261486 | 1261486 | 2021-04-27 | St. Francis | Arkansas | 5123 | 3573 | 42 |
1262166 | 1262166 | 2021-04-27 | Marion | Iowa | 19125 | 3573 | 75 |
1254992 | 1254992 | 2021-04-25 | St. Francis | Arkansas | 5123 | 3573 | 42 |
1234207 | 1234207 | 2021-04-18 | Ottawa | Ohio | 39123 | 3573 | 78 |
1234666 | 1234666 | 2021-04-18 | Macon | Tennessee | 47111 | 3573 | 76 |
1231418 | 1231418 | 2021-04-17 | Macon | Tennessee | 47111 | 3573 | 76 |
1228170 | 1228170 | 2021-04-16 | Macon | Tennessee | 47111 | 3573 | 76 |
1202768 | 1202768 | 2021-04-08 | Clark | Wisconsin | 55019 | 3573 | 62 |
1199377 | 1199377 | 2021-04-07 | Petersburg city | Virginia | 51730 | 3573 | 79 |
1189825 | 1189825 | 2021-04-04 | Trempealeau | Wisconsin | 55121 | 3573 | 41 |
1186578 | 1186578 | 2021-04-03 | Trempealeau | Wisconsin | 55121 | 3573 | 41 |
1175610 | 1175610 | 2021-03-31 | Scotland | North Carolina | 37165 | 3573 | 80 |
1170932 | 1170932 | 2021-03-30 | Maui | Hawaii | 15009 | 3573 | 40 |
1125711 | 1125711 | 2021-03-16 | Whitley | Indiana | 18183 | 3573 | 39 |
1122839 | 1122839 | 2021-03-15 | St. John the Baptist | Louisiana | 22095 | 3573 | 135 |
1124341 | 1124341 | 2021-03-15 | Cooke | Texas | 48097 | 3573 | 65 |
1121095 | 1121095 | 2021-03-14 | Cooke | Texas | 48097 | 3573 | 65 |
1117848 | 1117848 | 2021-03-13 | Cooke | Texas | 48097 | 3573 | 65 |
1108334 | 1108334 | 2021-03-10 | Sanpete | Utah | 49039 | 3573 | 19 |
1094557 | 1094557 | 2021-03-06 | Logan | Ohio | 39091 | 3573 | 73 |
1070487 | 1070487 | 2021-02-27 | Miami | Indiana | 18103 | 3573 | 64 |
1049015 | 1049015 | 2021-02-20 | Yadkin | North Carolina | 37197 | 3573 | 45 |
1042726 | 1042726 | 2021-02-18 | Ottawa | Oklahoma | 40115 | 3573 | 40 |
1028746 | 1028746 | 2021-02-14 | Calvert | Maryland | 24009 | 3573 | 63 |
1021228 | 1021228 | 2021-02-12 | Union | Arkansas | 5139 | 3573 | 97 |
1001784 | 1001784 | 2021-02-06 | Mendocino | California | 6045 | 3573 | 39 |
1004563 | 1004563 | 2021-02-06 | James City | Virginia | 51095 | 3573 | 41 |
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);