ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 7940 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Georgia 9
- North Carolina 8
- Oklahoma 7
- West Virginia 5
- Indiana 4
- Missouri 4
- Louisiana 3
- New Jersey 2
- New York 2
- Ohio 2
- Pennsylvania 2
- Virginia 2
- Alabama 1
- Arizona 1
- California 1
- Colorado 1
- Connecticut 1
- Florida 1
- Iowa 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Oregon 1
- Tennessee 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495299 | 2495299 | 2022-05-11 | Columbia | Oregon | 41009 | 7940 | 95 |
2468965 | 2468965 | 2022-05-03 | Macon | North Carolina | 37113 | 7940 | 117 |
2465709 | 2465709 | 2022-05-02 | Macon | North Carolina | 37113 | 7940 | 117 |
2462454 | 2462454 | 2022-05-01 | Macon | North Carolina | 37113 | 7940 | 117 |
2459198 | 2459198 | 2022-04-30 | Macon | North Carolina | 37113 | 7940 | 117 |
2455942 | 2455942 | 2022-04-29 | Macon | North Carolina | 37113 | 7940 | 117 |
2452686 | 2452686 | 2022-04-28 | Macon | North Carolina | 37113 | 7940 | 117 |
2449430 | 2449430 | 2022-04-27 | Macon | North Carolina | 37113 | 7940 | 117 |
2447343 | 2447343 | 2022-04-26 | Mingo | West Virginia | 54059 | 7940 | 122 |
2444087 | 2444087 | 2022-04-25 | Mingo | West Virginia | 54059 | 7940 | 122 |
2404038 | 2404038 | 2022-04-13 | Adair | Oklahoma | 40001 | 7940 | 73 |
2400783 | 2400783 | 2022-04-12 | Adair | Oklahoma | 40001 | 7940 | 73 |
2397528 | 2397528 | 2022-04-11 | Adair | Oklahoma | 40001 | 7940 | 73 |
2394273 | 2394273 | 2022-04-10 | Adair | Oklahoma | 40001 | 7940 | 73 |
2391017 | 2391017 | 2022-04-09 | Adair | Oklahoma | 40001 | 7940 | 73 |
2387761 | 2387761 | 2022-04-08 | Adair | Oklahoma | 40001 | 7940 | 73 |
2384506 | 2384506 | 2022-04-07 | Adair | Oklahoma | 40001 | 7940 | 73 |
2385483 | 2385483 | 2022-04-07 | Mingo | West Virginia | 54059 | 7940 | 119 |
2382228 | 2382228 | 2022-04-06 | Mingo | West Virginia | 54059 | 7940 | 119 |
2378973 | 2378973 | 2022-04-05 | Mingo | West Virginia | 54059 | 7940 | 119 |
2189331 | 2189331 | 2022-02-06 | Perry | Ohio | 39127 | 7940 | 112 |
2149393 | 2149393 | 2022-01-25 | Worcester | Maryland | 24047 | 7940 | 141 |
2132183 | 2132183 | 2022-01-20 | Montrose | Colorado | 8085 | 7940 | 150 |
2125142 | 2125142 | 2022-01-17 | Manassas city | Virginia | 51683 | 7940 | 57 |
2109105 | 2109105 | 2022-01-12 | Albany | Wyoming | 56001 | 7940 | 44 |
2074121 | 2074121 | 2022-01-02 | Montgomery | Indiana | 18107 | 7940 | 134 |
2070870 | 2070870 | 2022-01-01 | Montgomery | Indiana | 18107 | 7940 | 134 |
2067619 | 2067619 | 2021-12-31 | Montgomery | Indiana | 18107 | 7940 | 134 |
2064368 | 2064368 | 2021-12-30 | Montgomery | Indiana | 18107 | 7940 | 134 |
2054287 | 2054287 | 2021-12-27 | Colquitt | Georgia | 13071 | 7940 | 203 |
2051107 | 2051107 | 2021-12-26 | Murray | Georgia | 13213 | 7940 | 150 |
2052206 | 2052206 | 2021-12-26 | Scott | Missouri | 29201 | 7940 | 133 |
2047857 | 2047857 | 2021-12-25 | Murray | Georgia | 13213 | 7940 | 150 |
2048956 | 2048956 | 2021-12-25 | Scott | Missouri | 29201 | 7940 | 133 |
2044607 | 2044607 | 2021-12-24 | Murray | Georgia | 13213 | 7940 | 150 |
2045706 | 2045706 | 2021-12-24 | Scott | Missouri | 29201 | 7940 | 133 |
2042456 | 2042456 | 2021-12-23 | Scott | Missouri | 29201 | 7940 | 133 |
2032526 | 2032526 | 2021-12-20 | Winona | Minnesota | 27169 | 7940 | 61 |
2019981 | 2019981 | 2021-12-16 | Livingston | New York | 36051 | 7940 | 85 |
2012134 | 2012134 | 2021-12-14 | Thomas | Georgia | 13275 | 7940 | 183 |
1965178 | 1965178 | 2021-11-29 | Venango | Pennsylvania | 42121 | 7940 | 164 |
1943148 | 1943148 | 2021-11-22 | Washington | Virginia | 51191 | 7940 | 156 |
1903177 | 1903177 | 2021-11-10 | Darke | Ohio | 39037 | 7940 | 170 |
1883406 | 1883406 | 2021-11-04 | Salem | New Jersey | 34033 | 7940 | 209 |
1873797 | 1873797 | 2021-11-01 | Halifax | North Carolina | 37083 | 7940 | 139 |
1858159 | 1858159 | 2021-10-27 | Franklin | Tennessee | 47051 | 7940 | 102 |
1722894 | 1722894 | 2021-09-16 | Polk | Georgia | 13233 | 7940 | 120 |
1699677 | 1699677 | 2021-09-09 | Dale | Alabama | 1045 | 7940 | 139 |
1607304 | 1607304 | 2021-08-11 | Chemung | New York | 36015 | 7940 | 137 |
1489048 | 1489048 | 2021-07-06 | Rockdale | Georgia | 13247 | 7940 | 177 |
1306869 | 1306869 | 2021-05-11 | Santa Cruz | Arizona | 4023 | 7940 | 176 |
1206435 | 1206435 | 2021-04-10 | Columbia | Florida | 12023 | 7940 | 164 |
1086276 | 1086276 | 2021-03-04 | Tolland | Connecticut | 9013 | 7940 | 169 |
956674 | 956674 | 2021-01-23 | Walton | Georgia | 13297 | 7940 | 128 |
951952 | 951952 | 2021-01-21 | Monroe | Pennsylvania | 42089 | 7940 | 234 |
875430 | 875430 | 2020-12-29 | Coweta | Georgia | 13077 | 7940 | 83 |
875881 | 875881 | 2020-12-29 | Story | Iowa | 19169 | 7940 | 29 |
707425 | 707425 | 2020-11-07 | St. Tammany | Louisiana | 22103 | 7940 | 274 |
704182 | 704182 | 2020-11-06 | St. Tammany | Louisiana | 22103 | 7940 | 274 |
599447 | 599447 | 2020-10-05 | Sonoma | California | 6097 | 7940 | 122 |
562118 | 562118 | 2020-09-23 | Morris | New Jersey | 34027 | 7940 | 831 |
244440 | 244440 | 2020-06-16 | Bristol | Massachusetts | 25005 | 7940 | 520 |
222622 | 222622 | 2020-06-09 | Jefferson | Louisiana | 22051 | 7940 | 462 |
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);