ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where cases = 5735 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Tennessee 12
- Kentucky 8
- Georgia 7
- North Carolina 7
- Texas 6
- Illinois 5
- Kansas 4
- Utah 4
- Louisiana 3
- Virginia 3
- Arkansas 2
- Colorado 2
- Maryland 2
- Mississippi 2
- Missouri 2
- Pennsylvania 2
- Florida 1
- Indiana 1
- Iowa 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Nebraska 1
- New York 1
- Ohio 1
- Oklahoma 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499864 | 2499864 | 2022-05-13 | Morgan | Colorado | 8087 | 5735 | 138 |
2474729 | 2474729 | 2022-05-05 | Garrett | Maryland | 24023 | 5735 | 116 |
2471472 | 2471472 | 2022-05-04 | Garrett | Maryland | 24023 | 5735 | 116 |
2278712 | 2278712 | 2022-03-06 | Grady | Georgia | 13131 | 5735 | 107 |
2275459 | 2275459 | 2022-03-05 | Grady | Georgia | 13131 | 5735 | 107 |
2272206 | 2272206 | 2022-03-04 | Grady | Georgia | 13131 | 5735 | 107 |
2270103 | 2270103 | 2022-03-03 | Stone | Missouri | 29209 | 5735 | 114 |
2219076 | 2219076 | 2022-02-15 | Morgan | Tennessee | 47129 | 5735 | 72 |
2215825 | 2215825 | 2022-02-14 | Morgan | Tennessee | 47129 | 5735 | 72 |
2212574 | 2212574 | 2022-02-13 | Morgan | Tennessee | 47129 | 5735 | 72 |
2209321 | 2209321 | 2022-02-12 | Morgan | Tennessee | 47129 | 5735 | 72 |
2206068 | 2206068 | 2022-02-11 | Morgan | Tennessee | 47129 | 5735 | 72 |
2202815 | 2202815 | 2022-02-10 | Morgan | Tennessee | 47129 | 5735 | 72 |
2199561 | 2199561 | 2022-02-09 | Morgan | Tennessee | 47129 | 5735 | 72 |
2188254 | 2188254 | 2022-02-06 | Harrison | Kentucky | 21097 | 5735 | 58 |
2188274 | 2188274 | 2022-02-06 | Lincoln | Kentucky | 21137 | 5735 | 113 |
2185001 | 2185001 | 2022-02-05 | Harrison | Kentucky | 21097 | 5735 | 58 |
2185021 | 2185021 | 2022-02-05 | Lincoln | Kentucky | 21137 | 5735 | 113 |
2181749 | 2181749 | 2022-02-04 | Harrison | Kentucky | 21097 | 5735 | 58 |
2181769 | 2181769 | 2022-02-04 | Lincoln | Kentucky | 21137 | 5735 | 113 |
2155758 | 2155758 | 2022-01-27 | Montgomery | Kentucky | 21173 | 5735 | 85 |
2131578 | 2131578 | 2022-01-19 | Amherst | Virginia | 51009 | 5735 | 65 |
2119429 | 2119429 | 2022-01-16 | White | Georgia | 13311 | 5735 | 135 |
2116177 | 2116177 | 2022-01-15 | White | Georgia | 13311 | 5735 | 135 |
2112926 | 2112926 | 2022-01-14 | White | Georgia | 13311 | 5735 | 135 |
2110266 | 2110266 | 2022-01-13 | De Soto | Louisiana | 22031 | 5735 | 119 |
2107015 | 2107015 | 2022-01-12 | De Soto | Louisiana | 22031 | 5735 | 119 |
2103764 | 2103764 | 2022-01-11 | De Soto | Louisiana | 22031 | 5735 | 119 |
2087325 | 2087325 | 2022-01-06 | McPherson | Kansas | 20113 | 5735 | 105 |
2084073 | 2084073 | 2022-01-05 | McPherson | Kansas | 20113 | 5735 | 105 |
2009369 | 2009369 | 2021-12-13 | Boyle | Kentucky | 21021 | 5735 | 109 |
2006668 | 2006668 | 2021-12-12 | Marion | Missouri | 29127 | 5735 | 100 |
1928834 | 1928834 | 2021-11-18 | Platte | Nebraska | 31141 | 5735 | 56 |
1926160 | 1926160 | 2021-11-17 | Pike | Pennsylvania | 42103 | 5735 | 66 |
1891245 | 1891245 | 2021-11-06 | Wayne | West Virginia | 54099 | 5735 | 79 |
1872138 | 1872138 | 2021-11-01 | Montrose | Colorado | 8085 | 5735 | 87 |
1870589 | 1870589 | 2021-10-31 | Scotland | North Carolina | 37165 | 5735 | 107 |
1867340 | 1867340 | 2021-10-30 | Scotland | North Carolina | 37165 | 5735 | 107 |
1864091 | 1864091 | 2021-10-29 | Scotland | North Carolina | 37165 | 5735 | 107 |
1823816 | 1823816 | 2021-10-17 | Woodford | Illinois | 17203 | 5735 | 105 |
1820567 | 1820567 | 2021-10-16 | Woodford | Illinois | 17203 | 5735 | 105 |
1817318 | 1817318 | 2021-10-15 | Woodford | Illinois | 17203 | 5735 | 105 |
1724456 | 1724456 | 2021-09-16 | Auglaize | Ohio | 39011 | 5735 | 88 |
1721996 | 1721996 | 2021-09-15 | Uvalde | Texas | 48463 | 5735 | 86 |
1711394 | 1711394 | 2021-09-12 | Vance | North Carolina | 37181 | 5735 | 92 |
1708147 | 1708147 | 2021-09-11 | Vance | North Carolina | 37181 | 5735 | 92 |
1704900 | 1704900 | 2021-09-10 | Vance | North Carolina | 37181 | 5735 | 92 |
1670218 | 1670218 | 2021-08-30 | Washington | Virginia | 51191 | 5735 | 115 |
1629652 | 1629652 | 2021-08-18 | Oktibbeha | Mississippi | 28105 | 5735 | 102 |
1627736 | 1627736 | 2021-08-17 | Nacogdoches | Texas | 48347 | 5735 | 177 |
1624923 | 1624923 | 2021-08-16 | Fremont | Wyoming | 56013 | 5735 | 88 |
1598323 | 1598323 | 2021-08-08 | Warren | Tennessee | 47177 | 5735 | 85 |
1595074 | 1595074 | 2021-08-07 | Warren | Tennessee | 47177 | 5735 | 85 |
1591825 | 1591825 | 2021-08-06 | Warren | Tennessee | 47177 | 5735 | 85 |
1560617 | 1560617 | 2021-07-28 | Knox | Illinois | 17095 | 5735 | 188 |
1519604 | 1519604 | 2021-07-15 | Cattaraugus | New York | 36009 | 5735 | 92 |
1516443 | 1516443 | 2021-07-14 | Edgecombe | North Carolina | 37065 | 5735 | 113 |
1441105 | 1441105 | 2021-06-21 | Branch | Michigan | 26023 | 5735 | 120 |
1385180 | 1385180 | 2021-06-04 | Polk | Georgia | 13233 | 5735 | 97 |
1329828 | 1329828 | 2021-05-18 | Gadsden | Florida | 12039 | 5735 | 99 |
1290170 | 1290170 | 2021-05-05 | Iron | Utah | 49021 | 5735 | 32 |
1286924 | 1286924 | 2021-05-04 | Iron | Utah | 49021 | 5735 | 32 |
1283678 | 1283678 | 2021-05-03 | Iron | Utah | 49021 | 5735 | 32 |
1274910 | 1274910 | 2021-05-01 | Clinton | Illinois | 17027 | 5735 | 99 |
1262232 | 1262232 | 2021-04-27 | Ford | Kansas | 20057 | 5735 | 74 |
1258985 | 1258985 | 2021-04-26 | Ford | Kansas | 20057 | 5735 | 74 |
1252286 | 1252286 | 2021-04-24 | Dearborn | Indiana | 18029 | 5735 | 79 |
1197586 | 1197586 | 2021-04-07 | Berkshire | Massachusetts | 25003 | 5735 | 281 |
1154294 | 1154294 | 2021-03-25 | Mississippi | Arkansas | 5093 | 5735 | 106 |
1151047 | 1151047 | 2021-03-24 | Mississippi | Arkansas | 5093 | 5735 | 106 |
1143912 | 1143912 | 2021-03-21 | Lamar | Texas | 48277 | 5735 | 151 |
1140665 | 1140665 | 2021-03-20 | Lamar | Texas | 48277 | 5735 | 151 |
1137419 | 1137419 | 2021-03-19 | Lamar | Texas | 48277 | 5735 | 151 |
1134173 | 1134173 | 2021-03-18 | Lamar | Texas | 48277 | 5735 | 151 |
1120598 | 1120598 | 2021-03-14 | Grady | Oklahoma | 40051 | 5735 | 80 |
1111904 | 1111904 | 2021-03-11 | Waupaca | Wisconsin | 55135 | 5735 | 158 |
1091785 | 1091785 | 2021-03-05 | Loudon | Tennessee | 47105 | 5735 | 67 |
1041881 | 1041881 | 2021-02-18 | Kandiyohi | Minnesota | 27067 | 5735 | 74 |
997362 | 997362 | 2021-02-04 | Clearfield | Pennsylvania | 42033 | 5735 | 104 |
986803 | 986803 | 2021-02-01 | Lowndes | Mississippi | 28087 | 5735 | 127 |
962280 | 962280 | 2021-01-24 | Tooele | Utah | 49045 | 5735 | 20 |
655204 | 655204 | 2020-10-22 | Johnson | Iowa | 19103 | 5735 | 30 |
605073 | 605073 | 2020-10-06 | Williamson | Tennessee | 47187 | 5735 | 40 |
466259 | 466259 | 2020-08-24 | Loudoun | Virginia | 51107 | 5735 | 115 |
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);