ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
203 rows where cases = 2448 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 17
- Puerto Rico 15
- Virginia 12
- Kansas 11
- Illinois 10
- Louisiana 10
- Texas 9
- West Virginia 9
- Indiana 7
- South Carolina 7
- Alabama 6
- Mississippi 6
- Georgia 5
- Iowa 5
- Missouri 5
- Arizona 4
- Arkansas 4
- North Carolina 4
- North Dakota 4
- Ohio 4
- Wisconsin 4
- Colorado 3
- Idaho 3
- Minnesota 3
- New Hampshire 3
- New Mexico 3
- New York 3
- Oregon 3
- South Dakota 3
- Washington 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499326 | 2499326 | 2022-05-12 | Madison | Virginia | 51113 | 2448 | 41 |
2440844 | 2440844 | 2022-04-24 | Ritchie | West Virginia | 54085 | 2448 | 31 |
2437588 | 2437588 | 2022-04-23 | Ritchie | West Virginia | 54085 | 2448 | 31 |
2434332 | 2434332 | 2022-04-22 | Ritchie | West Virginia | 54085 | 2448 | 31 |
2431076 | 2431076 | 2022-04-21 | Ritchie | West Virginia | 54085 | 2448 | 31 |
2358698 | 2358698 | 2022-03-30 | Lajas | Puerto Rico | 72079 | 2448 | |
2339757 | 2339757 | 2022-03-24 | Charlotte | Virginia | 51037 | 2448 | 46 |
2336503 | 2336503 | 2022-03-23 | Charlotte | Virginia | 51037 | 2448 | 46 |
2302068 | 2302068 | 2022-03-13 | Hancock | Kentucky | 21091 | 2448 | 21 |
2298816 | 2298816 | 2022-03-12 | Hancock | Kentucky | 21091 | 2448 | 21 |
2295564 | 2295564 | 2022-03-11 | Hancock | Kentucky | 21091 | 2448 | 21 |
2292312 | 2292312 | 2022-03-10 | Hancock | Kentucky | 21091 | 2448 | 21 |
2294120 | 2294120 | 2022-03-10 | Trinity | Texas | 48455 | 2448 | 72 |
2289060 | 2289060 | 2022-03-09 | Hancock | Kentucky | 21091 | 2448 | 21 |
2290393 | 2290393 | 2022-03-09 | Luquillo | Puerto Rico | 72089 | 2448 | |
2290868 | 2290868 | 2022-03-09 | Trinity | Texas | 48455 | 2448 | 72 |
2285809 | 2285809 | 2022-03-08 | Hancock | Kentucky | 21091 | 2448 | 21 |
2287141 | 2287141 | 2022-03-08 | Luquillo | Puerto Rico | 72089 | 2448 | |
2282557 | 2282557 | 2022-03-07 | Hancock | Kentucky | 21091 | 2448 | 21 |
2283889 | 2283889 | 2022-03-07 | Luquillo | Puerto Rico | 72089 | 2448 | |
2280637 | 2280637 | 2022-03-06 | Luquillo | Puerto Rico | 72089 | 2448 | |
2277384 | 2277384 | 2022-03-05 | Luquillo | Puerto Rico | 72089 | 2448 | |
2265081 | 2265081 | 2022-03-01 | Pend Oreille | Washington | 53051 | 2448 | 32 |
2261831 | 2261831 | 2022-02-28 | Pend Oreille | Washington | 53051 | 2448 | 32 |
2240807 | 2240807 | 2022-02-22 | Montgomery | Missouri | 29139 | 2448 | 52 |
2238960 | 2238960 | 2022-02-21 | Franklin city | Virginia | 51620 | 2448 | 45 |
2218834 | 2218834 | 2022-02-15 | Ciales | Puerto Rico | 72039 | 2448 | |
2215583 | 2215583 | 2022-02-14 | Ciales | Puerto Rico | 72039 | 2448 | |
2198496 | 2198496 | 2022-02-09 | Douglas | Missouri | 29067 | 2448 | 70 |
2179277 | 2179277 | 2022-02-03 | Los Alamos | New Mexico | 35028 | 2448 | 12 |
2179421 | 2179421 | 2022-02-03 | Pamlico | North Carolina | 37137 | 2448 | 27 |
2176230 | 2176230 | 2022-02-02 | Mercer | North Dakota | 38057 | 2448 | 23 |
2171896 | 2171896 | 2022-02-01 | Marshall | Kansas | 20117 | 2448 | 39 |
2168643 | 2168643 | 2022-01-31 | Marshall | Kansas | 20117 | 2448 | 39 |
2153236 | 2153236 | 2022-01-26 | Colfax | New Mexico | 35007 | 2448 | 58 |
2148679 | 2148679 | 2022-01-25 | Screven | Georgia | 13251 | 2448 | 62 |
2149755 | 2149755 | 2022-01-25 | Ripley | Missouri | 29181 | 2448 | 53 |
2102839 | 2102839 | 2022-01-11 | Mono | California | 6051 | 2448 | 4 |
2082872 | 2082872 | 2022-01-04 | Martinsville city | Virginia | 51690 | 2448 | 100 |
2065976 | 2065976 | 2021-12-30 | Hatillo | Puerto Rico | 72065 | 2448 | |
2066503 | 2066503 | 2021-12-30 | Millard | Utah | 49027 | 2448 | 31 |
2063253 | 2063253 | 2021-12-29 | Millard | Utah | 49027 | 2448 | 31 |
2052956 | 2052956 | 2021-12-26 | Cabo Rojo | Puerto Rico | 72023 | 2448 | |
2034995 | 2034995 | 2021-12-21 | Greene | Illinois | 17061 | 2448 | 53 |
2029654 | 2029654 | 2021-12-19 | Unknown | New Hampshire | 2448 | 16 | |
2026403 | 2026403 | 2021-12-18 | Unknown | New Hampshire | 2448 | 16 | |
2023152 | 2023152 | 2021-12-17 | Unknown | New Hampshire | 2448 | 16 | |
2012505 | 2012505 | 2021-12-14 | Allen | Kansas | 20001 | 2448 | 26 |
2009254 | 2009254 | 2021-12-13 | Allen | Kansas | 20001 | 2448 | 26 |
1995207 | 1995207 | 2021-12-08 | Braxton | West Virginia | 54007 | 2448 | 27 |
1995236 | 1995236 | 2021-12-08 | Morgan | West Virginia | 54065 | 2448 | 50 |
1971736 | 1971736 | 2021-12-01 | Moca | Puerto Rico | 72099 | 2448 | |
1962894 | 1962894 | 2021-11-29 | Macon | Alabama | 1087 | 2448 | 64 |
1964908 | 1964908 | 2021-11-29 | Walsh | North Dakota | 38099 | 2448 | 30 |
1961656 | 1961656 | 2021-11-28 | Walsh | North Dakota | 38099 | 2448 | 30 |
1940860 | 1940860 | 2021-11-22 | Parke | Indiana | 18121 | 2448 | 31 |
1927351 | 1927351 | 2021-11-18 | Crowley | Colorado | 8025 | 2448 | 25 |
1926177 | 1926177 | 2021-11-17 | Aguada | Puerto Rico | 72003 | 2448 | |
1910881 | 1910881 | 2021-11-13 | Lamar | Alabama | 1075 | 2448 | 52 |
1880861 | 1880861 | 2021-11-03 | Oglala Lakota | South Dakota | 46102 | 2448 | 53 |
1876747 | 1876747 | 2021-11-02 | Park | Montana | 30067 | 2448 | 29 |
1864872 | 1864872 | 2021-10-29 | Leon | Texas | 48289 | 2448 | 69 |
1861707 | 1861707 | 2021-10-28 | Tyler | Texas | 48457 | 2448 | 70 |
1858458 | 1858458 | 2021-10-27 | Tyler | Texas | 48457 | 2448 | 70 |
1854588 | 1854588 | 2021-10-26 | Clatsop | Oregon | 41007 | 2448 | 28 |
1855209 | 1855209 | 2021-10-26 | Tyler | Texas | 48457 | 2448 | 70 |
1846553 | 1846553 | 2021-10-24 | Warren | Illinois | 17187 | 2448 | 69 |
1843303 | 1843303 | 2021-10-23 | Warren | Illinois | 17187 | 2448 | 69 |
1839377 | 1839377 | 2021-10-22 | Crenshaw | Alabama | 1041 | 2448 | 75 |
1840053 | 1840053 | 2021-10-22 | Warren | Illinois | 17187 | 2448 | 69 |
1821907 | 1821907 | 2021-10-16 | Richland | North Dakota | 38077 | 2448 | 19 |
1801421 | 1801421 | 2021-10-10 | Henry | Kentucky | 21103 | 2448 | 24 |
1798172 | 1798172 | 2021-10-09 | Henry | Kentucky | 21103 | 2448 | 24 |
1794923 | 1794923 | 2021-10-08 | Henry | Kentucky | 21103 | 2448 | 24 |
1792460 | 1792460 | 2021-10-07 | San Miguel | New Mexico | 35047 | 2448 | 21 |
1780855 | 1780855 | 2021-10-03 | Carbon | Wyoming | 56007 | 2448 | 36 |
1777475 | 1777475 | 2021-10-02 | Barbour | West Virginia | 54001 | 2448 | 41 |
1777605 | 1777605 | 2021-10-02 | Carbon | Wyoming | 56007 | 2448 | 36 |
1774355 | 1774355 | 2021-10-01 | Carbon | Wyoming | 56007 | 2448 | 36 |
1768181 | 1768181 | 2021-09-30 | Teller | Colorado | 8119 | 2448 | 24 |
1768839 | 1768839 | 2021-09-30 | Neosho | Kansas | 20133 | 2448 | 47 |
1765590 | 1765590 | 2021-09-29 | Neosho | Kansas | 20133 | 2448 | 47 |
1755486 | 1755486 | 2021-09-26 | Bond | Illinois | 17005 | 2448 | 29 |
1752238 | 1752238 | 2021-09-25 | Bond | Illinois | 17005 | 2448 | 29 |
1748989 | 1748989 | 2021-09-24 | Bond | Illinois | 17005 | 2448 | 29 |
1741950 | 1741950 | 2021-09-22 | Washington | Alabama | 1129 | 2448 | 48 |
1737002 | 1737002 | 2021-09-20 | Wright | Missouri | 29229 | 2448 | 44 |
1724787 | 1724787 | 2021-09-16 | San Sebastian | Puerto Rico | 72131 | 2448 | |
1700050 | 1700050 | 2021-09-09 | Banks | Georgia | 13011 | 2448 | 50 |
1696539 | 1696539 | 2021-09-08 | Franklin | Arkansas | 5047 | 2448 | 47 |
1683035 | 1683035 | 2021-09-03 | Young | Texas | 48503 | 2448 | 50 |
1666360 | 1666360 | 2021-08-29 | Hampton | South Carolina | 45049 | 2448 | 57 |
1663112 | 1663112 | 2021-08-28 | Hampton | South Carolina | 45049 | 2448 | 57 |
1658945 | 1658945 | 2021-08-27 | Clinton | Missouri | 29049 | 2448 | 70 |
1659864 | 1659864 | 2021-08-27 | Hampton | South Carolina | 45049 | 2448 | 57 |
1635890 | 1635890 | 2021-08-20 | Caroline | Maryland | 24011 | 2448 | 32 |
1632855 | 1632855 | 2021-08-19 | Chickasaw | Mississippi | 28017 | 2448 | 60 |
1629274 | 1629274 | 2021-08-18 | Morgan | Kentucky | 21175 | 2448 | 5 |
1631259 | 1631259 | 2021-08-18 | Island | Washington | 53029 | 2448 | 32 |
1609191 | 1609191 | 2021-08-12 | Mitchell | Georgia | 13205 | 2448 | 85 |
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);