ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
287 rows where cases = 1760 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 19
- Texas 18
- Illinois 16
- Virginia 16
- North Carolina 15
- Puerto Rico 13
- Colorado 12
- Georgia 12
- Mississippi 11
- West Virginia 11
- Minnesota 10
- Ohio 9
- Idaho 8
- Iowa 8
- Missouri 8
- Tennessee 8
- Alabama 7
- Arkansas 7
- Florida 7
- South Carolina 7
- Indiana 6
- Kentucky 6
- Nebraska 6
- Pennsylvania 6
- California 5
- Louisiana 5
- New Mexico 4
- New York 3
- Washington 3
- Arizona 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497683 | 2497683 | 2022-05-12 | Lac qui Parle | Minnesota | 27073 | 1760 | 29 |
2498684 | 2498684 | 2022-05-12 | Guanica | Puerto Rico | 72055 | 1760 | |
2494425 | 2494425 | 2022-05-11 | Lac qui Parle | Minnesota | 27073 | 1760 | 29 |
2446132 | 2446132 | 2022-04-26 | Camden | North Carolina | 37029 | 1760 | 9 |
2442877 | 2442877 | 2022-04-25 | Camden | North Carolina | 37029 | 1760 | 9 |
2439621 | 2439621 | 2022-04-24 | Camden | North Carolina | 37029 | 1760 | 9 |
2436365 | 2436365 | 2022-04-23 | Camden | North Carolina | 37029 | 1760 | 9 |
2433109 | 2433109 | 2022-04-22 | Camden | North Carolina | 37029 | 1760 | 9 |
2429853 | 2429853 | 2022-04-21 | Camden | North Carolina | 37029 | 1760 | 9 |
2426597 | 2426597 | 2022-04-20 | Camden | North Carolina | 37029 | 1760 | 9 |
2404942 | 2404942 | 2022-04-13 | Williamsburg city | Virginia | 51830 | 1760 | 22 |
2395060 | 2395060 | 2022-04-10 | Bland | Virginia | 51021 | 1760 | 21 |
2391804 | 2391804 | 2022-04-09 | Bland | Virginia | 51021 | 1760 | 21 |
2388548 | 2388548 | 2022-04-08 | Bland | Virginia | 51021 | 1760 | 21 |
2382038 | 2382038 | 2022-04-06 | Bland | Virginia | 51021 | 1760 | 21 |
2355892 | 2355892 | 2022-03-29 | Refugio | Texas | 48391 | 1760 | 35 |
2278643 | 2278643 | 2022-03-06 | Unknown | Florida | 1760 | 1207 | |
2275390 | 2275390 | 2022-03-05 | Unknown | Florida | 1760 | 1207 | |
2254610 | 2254610 | 2022-02-26 | Hormigueros | Puerto Rico | 72067 | 1760 | |
2251359 | 2251359 | 2022-02-25 | Hormigueros | Puerto Rico | 72067 | 1760 | |
2213509 | 2213509 | 2022-02-14 | Lake | Colorado | 8065 | 1760 | 2 |
2213659 | 2213659 | 2022-02-14 | Crawford | Georgia | 13079 | 1760 | 50 |
2215917 | 2215917 | 2022-02-14 | Delta | Texas | 48119 | 1760 | 24 |
2211516 | 2211516 | 2022-02-13 | Harrison | Missouri | 29081 | 1760 | 27 |
2208263 | 2208263 | 2022-02-12 | Harrison | Missouri | 29081 | 1760 | 27 |
2205010 | 2205010 | 2022-02-11 | Harrison | Missouri | 29081 | 1760 | 27 |
2201757 | 2201757 | 2022-02-10 | Harrison | Missouri | 29081 | 1760 | 27 |
2198459 | 2198459 | 2022-02-09 | Wilkinson | Mississippi | 28157 | 1760 | 43 |
2195353 | 2195353 | 2022-02-08 | Madison | Montana | 30057 | 1760 | 20 |
2192074 | 2192074 | 2022-02-07 | Blaine | Montana | 30005 | 1760 | 28 |
2180729 | 2180729 | 2022-02-04 | Greene | Alabama | 1063 | 1760 | 47 |
2167574 | 2167574 | 2022-01-30 | Pendleton | West Virginia | 54071 | 1760 | 16 |
2154662 | 2154662 | 2022-01-26 | Platte | Wyoming | 56031 | 1760 | 38 |
2141516 | 2141516 | 2022-01-22 | Doddridge | West Virginia | 54017 | 1760 | 16 |
2131122 | 2131122 | 2022-01-19 | Custer | South Dakota | 46033 | 1760 | 21 |
2126730 | 2126730 | 2022-01-18 | Clearwater | Minnesota | 27029 | 1760 | 27 |
2122237 | 2122237 | 2022-01-17 | Greenlee | Arizona | 4011 | 1760 | 30 |
2105630 | 2105630 | 2022-01-11 | Manassas Park city | Virginia | 51685 | 1760 | 16 |
2099924 | 2099924 | 2022-01-10 | Wilkes | Georgia | 13317 | 1760 | 40 |
2102483 | 2102483 | 2022-01-10 | Clay | West Virginia | 54015 | 1760 | 28 |
2095273 | 2095273 | 2022-01-08 | Santa Isabel | Puerto Rico | 72133 | 1760 | |
2090189 | 2090189 | 2022-01-07 | Boundary | Idaho | 16021 | 1760 | 51 |
2086533 | 2086533 | 2022-01-06 | Perry | Arkansas | 5105 | 1760 | 26 |
2077189 | 2077189 | 2022-01-03 | Clearwater | Idaho | 16035 | 1760 | 28 |
2077208 | 2077208 | 2022-01-03 | Owyhee | Idaho | 16073 | 1760 | 42 |
2073938 | 2073938 | 2022-01-02 | Clearwater | Idaho | 16035 | 1760 | 28 |
2070687 | 2070687 | 2022-01-01 | Clearwater | Idaho | 16035 | 1760 | 28 |
2067436 | 2067436 | 2021-12-31 | Clearwater | Idaho | 16035 | 1760 | 28 |
2064185 | 2064185 | 2021-12-30 | Clearwater | Idaho | 16035 | 1760 | 28 |
2040645 | 2040645 | 2021-12-22 | Richmond | Virginia | 51159 | 1760 | 16 |
2035502 | 2035502 | 2021-12-21 | East Carroll | Louisiana | 22035 | 1760 | 33 |
2031645 | 2031645 | 2021-12-20 | Turner | Georgia | 13287 | 1760 | 50 |
2030895 | 2030895 | 2021-12-19 | Richmond | Virginia | 51159 | 1760 | 16 |
2027644 | 2027644 | 2021-12-18 | Richmond | Virginia | 51159 | 1760 | 16 |
2024393 | 2024393 | 2021-12-17 | Richmond | Virginia | 51159 | 1760 | 16 |
1998129 | 1998129 | 2021-12-09 | Live Oak | Texas | 48297 | 1760 | 38 |
1994878 | 1994878 | 2021-12-08 | Live Oak | Texas | 48297 | 1760 | 38 |
1991627 | 1991627 | 2021-12-07 | Live Oak | Texas | 48297 | 1760 | 38 |
1988376 | 1988376 | 2021-12-06 | Live Oak | Texas | 48297 | 1760 | 38 |
1978769 | 1978769 | 2021-12-03 | Lamoille | Vermont | 50015 | 1760 | 9 |
1972768 | 1972768 | 2021-12-02 | Pike | Arkansas | 5109 | 1760 | 37 |
1967466 | 1967466 | 2021-11-30 | Koochiching | Minnesota | 27071 | 1760 | 23 |
1964826 | 1964826 | 2021-11-29 | Pamlico | North Carolina | 37137 | 1760 | 26 |
1961977 | 1961977 | 2021-11-28 | Loiza | Puerto Rico | 72087 | 1760 | |
1962744 | 1962744 | 2021-11-28 | Roane | West Virginia | 54087 | 1760 | 25 |
1958726 | 1958726 | 2021-11-27 | Loiza | Puerto Rico | 72087 | 1760 | |
1959493 | 1959493 | 2021-11-27 | Roane | West Virginia | 54087 | 1760 | 25 |
1955475 | 1955475 | 2021-11-26 | Loiza | Puerto Rico | 72087 | 1760 | |
1956242 | 1956242 | 2021-11-26 | Roane | West Virginia | 54087 | 1760 | 25 |
1952224 | 1952224 | 2021-11-25 | Loiza | Puerto Rico | 72087 | 1760 | |
1952991 | 1952991 | 2021-11-25 | Roane | West Virginia | 54087 | 1760 | 25 |
1949740 | 1949740 | 2021-11-24 | Roane | West Virginia | 54087 | 1760 | 25 |
1942002 | 1942002 | 2021-11-22 | Alleghany | North Carolina | 37005 | 1760 | 6 |
1937093 | 1937093 | 2021-11-21 | Archuleta | Colorado | 8007 | 1760 | 7 |
1933843 | 1933843 | 2021-11-20 | Archuleta | Colorado | 8007 | 1760 | 7 |
1930408 | 1930408 | 2021-11-19 | Wilcox | Alabama | 1131 | 1760 | 38 |
1930591 | 1930591 | 2021-11-19 | Archuleta | Colorado | 8007 | 1760 | 7 |
1927996 | 1927996 | 2021-11-18 | Brown | Kansas | 20013 | 1760 | 40 |
1924746 | 1924746 | 2021-11-17 | Brown | Kansas | 20013 | 1760 | 40 |
1922776 | 1922776 | 2021-11-16 | Hughes | Oklahoma | 40063 | 1760 | 44 |
1919527 | 1919527 | 2021-11-15 | Hughes | Oklahoma | 40063 | 1760 | 44 |
1919770 | 1919770 | 2021-11-15 | Calhoun | South Carolina | 45017 | 1760 | 53 |
1920305 | 1920305 | 2021-11-15 | Dickenson | Virginia | 51051 | 1760 | 28 |
1916277 | 1916277 | 2021-11-14 | Hughes | Oklahoma | 40063 | 1760 | 44 |
1913027 | 1913027 | 2021-11-13 | Hughes | Oklahoma | 40063 | 1760 | 44 |
1909777 | 1909777 | 2021-11-12 | Hughes | Oklahoma | 40063 | 1760 | 44 |
1906528 | 1906528 | 2021-11-11 | Hughes | Oklahoma | 40063 | 1760 | 44 |
1903279 | 1903279 | 2021-11-10 | Hughes | Oklahoma | 40063 | 1760 | 44 |
1895262 | 1895262 | 2021-11-08 | Menard | Illinois | 17129 | 1760 | 18 |
1891641 | 1891641 | 2021-11-07 | Prowers | Colorado | 8099 | 1760 | 32 |
1888391 | 1888391 | 2021-11-06 | Prowers | Colorado | 8099 | 1760 | 32 |
1890467 | 1890467 | 2021-11-06 | Juana Diaz | Puerto Rico | 72075 | 1760 | |
1885025 | 1885025 | 2021-11-05 | Stone | Arkansas | 5137 | 1760 | 44 |
1885141 | 1885141 | 2021-11-05 | Prowers | Colorado | 8099 | 1760 | 32 |
1878566 | 1878566 | 2021-11-03 | Plumas | California | 6063 | 1760 | 7 |
1878598 | 1878598 | 2021-11-03 | Bent | Colorado | 8011 | 1760 | 27 |
1873261 | 1873261 | 2021-11-01 | Watonwan | Minnesota | 27165 | 1760 | 14 |
1831813 | 1831813 | 2021-10-19 | Nowata | Oklahoma | 40105 | 1760 | 24 |
1832503 | 1832503 | 2021-10-19 | Morgan | Utah | 49029 | 1760 | 11 |
1828564 | 1828564 | 2021-10-18 | Nowata | Oklahoma | 40105 | 1760 | 24 |
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);