ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
288 rows where cases = 1505 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 23
- Tennessee 20
- Texas 19
- Kentucky 15
- Virginia 14
- Mississippi 13
- North Carolina 13
- Colorado 12
- Michigan 12
- Iowa 11
- Minnesota 11
- Missouri 11
- Puerto Rico 10
- Indiana 9
- Illinois 8
- Arkansas 7
- Wisconsin 7
- Nebraska 6
- Washington 5
- Connecticut 4
- Idaho 4
- Ohio 4
- Oregon 4
- South Dakota 4
- Virgin Islands 4
- Alabama 3
- Louisiana 3
- New Mexico 3
- Utah 3
- West Virginia 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461871 | 2461871 | 2022-05-01 | Norman | Minnesota | 27107 | 1505 | 13 |
2458615 | 2458615 | 2022-04-30 | Norman | Minnesota | 27107 | 1505 | 13 |
2455359 | 2455359 | 2022-04-29 | Norman | Minnesota | 27107 | 1505 | 13 |
2381843 | 2381843 | 2022-04-06 | Jack | Texas | 48237 | 1505 | 28 |
2378588 | 2378588 | 2022-04-05 | Jack | Texas | 48237 | 1505 | 28 |
2375334 | 2375334 | 2022-04-04 | Jack | Texas | 48237 | 1505 | 28 |
2372082 | 2372082 | 2022-04-03 | Jack | Texas | 48237 | 1505 | 28 |
2368829 | 2368829 | 2022-04-02 | Jack | Texas | 48237 | 1505 | 28 |
2325476 | 2325476 | 2022-03-20 | Cedar | Nebraska | 31027 | 1505 | 14 |
2322222 | 2322222 | 2022-03-19 | Cedar | Nebraska | 31027 | 1505 | 14 |
2312462 | 2312462 | 2022-03-16 | Cedar | Nebraska | 31027 | 1505 | 14 |
2304528 | 2304528 | 2022-03-14 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2301276 | 2301276 | 2022-03-13 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2298024 | 2298024 | 2022-03-12 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2294772 | 2294772 | 2022-03-11 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2292950 | 2292950 | 2022-03-10 | Cedar | Nebraska | 31027 | 1505 | 14 |
2289610 | 2289610 | 2022-03-09 | Shelby | Missouri | 29205 | 1505 | 15 |
2283198 | 2283198 | 2022-03-07 | Clay | Nebraska | 31035 | 1505 | 21 |
2223591 | 2223591 | 2022-02-17 | Calhoun | Illinois | 17013 | 1505 | 8 |
2173541 | 2173541 | 2022-02-01 | Pickett | Tennessee | 47137 | 1505 | 28 |
2169250 | 2169250 | 2022-01-31 | Maries | Missouri | 29125 | 1505 | 28 |
2170289 | 2170289 | 2022-01-31 | Pickett | Tennessee | 47137 | 1505 | 28 |
2167035 | 2167035 | 2022-01-30 | Pickett | Tennessee | 47137 | 1505 | 28 |
2162699 | 2162699 | 2022-01-29 | Clark | Missouri | 29045 | 1505 | 28 |
2163780 | 2163780 | 2022-01-29 | Pickett | Tennessee | 47137 | 1505 | 28 |
2160525 | 2160525 | 2022-01-28 | Pickett | Tennessee | 47137 | 1505 | 28 |
2157269 | 2157269 | 2022-01-27 | Pickett | Tennessee | 47137 | 1505 | 28 |
2154016 | 2154016 | 2022-01-26 | Pickett | Tennessee | 47137 | 1505 | 28 |
2133198 | 2133198 | 2022-01-20 | Montmorency | Michigan | 26119 | 1505 | 43 |
2129945 | 2129945 | 2022-01-19 | Montmorency | Michigan | 26119 | 1505 | 43 |
2105641 | 2105641 | 2022-01-11 | Northampton | Virginia | 51131 | 1505 | 50 |
2096910 | 2096910 | 2022-01-09 | Union | Indiana | 18161 | 1505 | 19 |
2093658 | 2093658 | 2022-01-08 | Union | Indiana | 18161 | 1505 | 19 |
2090406 | 2090406 | 2022-01-07 | Union | Indiana | 18161 | 1505 | 19 |
2092343 | 2092343 | 2022-01-07 | Hamilton | Texas | 48193 | 1505 | 29 |
2084656 | 2084656 | 2022-01-05 | Harrison | Missouri | 29081 | 1505 | 25 |
2086085 | 2086085 | 2022-01-05 | Fairfax city | Virginia | 51600 | 1505 | 36 |
2074813 | 2074813 | 2022-01-02 | Kemper | Mississippi | 28069 | 1505 | 42 |
2071562 | 2071562 | 2022-01-01 | Kemper | Mississippi | 28069 | 1505 | 42 |
2068311 | 2068311 | 2021-12-31 | Kemper | Mississippi | 28069 | 1505 | 42 |
2065060 | 2065060 | 2021-12-30 | Kemper | Mississippi | 28069 | 1505 | 42 |
2066555 | 2066555 | 2021-12-30 | Buena Vista city | Virginia | 51530 | 1505 | 33 |
2060662 | 2060662 | 2021-12-29 | San Miguel | Colorado | 8113 | 1505 | 7 |
2038089 | 2038089 | 2021-12-22 | Lanier | Georgia | 13173 | 1505 | 17 |
2036888 | 2036888 | 2021-12-21 | Turner | South Dakota | 46125 | 1505 | 62 |
2028284 | 2028284 | 2021-12-19 | Clinch | Georgia | 13065 | 1505 | 36 |
2025033 | 2025033 | 2021-12-18 | Clinch | Georgia | 13065 | 1505 | 36 |
2021782 | 2021782 | 2021-12-17 | Clinch | Georgia | 13065 | 1505 | 36 |
2023772 | 2023772 | 2021-12-17 | Yauco | Puerto Rico | 72153 | 1505 | |
2024469 | 2024469 | 2021-12-17 | Doddridge | West Virginia | 54017 | 1505 | 12 |
1995114 | 1995114 | 2021-12-08 | Nelson | Virginia | 51125 | 1505 | 22 |
1988446 | 1988446 | 2021-12-06 | Swisher | Texas | 48437 | 1505 | 22 |
1983447 | 1983447 | 2021-12-05 | Owen | Kentucky | 21187 | 1505 | 28 |
1980197 | 1980197 | 2021-12-04 | Owen | Kentucky | 21187 | 1505 | 28 |
1976947 | 1976947 | 2021-12-03 | Owen | Kentucky | 21187 | 1505 | 28 |
1973988 | 1973988 | 2021-12-02 | Pipestone | Minnesota | 27117 | 1505 | 29 |
1962438 | 1962438 | 2021-11-28 | Somervell | Texas | 48425 | 1505 | 24 |
1959187 | 1959187 | 2021-11-27 | Somervell | Texas | 48425 | 1505 | 24 |
1955936 | 1955936 | 2021-11-26 | Somervell | Texas | 48425 | 1505 | 24 |
1951218 | 1951218 | 2021-11-25 | Marshall | Minnesota | 27089 | 1505 | 21 |
1952685 | 1952685 | 2021-11-25 | Somervell | Texas | 48425 | 1505 | 24 |
1947967 | 1947967 | 2021-11-24 | Marshall | Minnesota | 27089 | 1505 | 21 |
1949434 | 1949434 | 2021-11-24 | Somervell | Texas | 48425 | 1505 | 24 |
1946183 | 1946183 | 2021-11-23 | Somervell | Texas | 48425 | 1505 | 24 |
1928343 | 1928343 | 2021-11-18 | Baraga | Michigan | 26013 | 1505 | 47 |
1930062 | 1930062 | 2021-11-18 | Floyd | Virginia | 51063 | 1505 | 31 |
1925093 | 1925093 | 2021-11-17 | Baraga | Michigan | 26013 | 1505 | 47 |
1925897 | 1925897 | 2021-11-17 | Traill | North Dakota | 38097 | 1505 | 21 |
1922978 | 1922978 | 2021-11-16 | Naguabo | Puerto Rico | 72103 | 1505 | |
1919729 | 1919729 | 2021-11-15 | Naguabo | Puerto Rico | 72103 | 1505 | |
1920486 | 1920486 | 2021-11-15 | Ritchie | West Virginia | 54085 | 1505 | 20 |
1916479 | 1916479 | 2021-11-14 | Naguabo | Puerto Rico | 72103 | 1505 | |
1913229 | 1913229 | 2021-11-13 | Naguabo | Puerto Rico | 72103 | 1505 | |
1881889 | 1881889 | 2021-11-04 | Park | Colorado | 8093 | 1505 | 10 |
1883017 | 1883017 | 2021-11-04 | Benton | Mississippi | 28009 | 1505 | 39 |
1879768 | 1879768 | 2021-11-03 | Benton | Mississippi | 28009 | 1505 | 39 |
1876519 | 1876519 | 2021-11-02 | Benton | Mississippi | 28009 | 1505 | 39 |
1869180 | 1869180 | 2021-10-31 | Fremont | Idaho | 16043 | 1505 | 16 |
1865931 | 1865931 | 2021-10-30 | Fremont | Idaho | 16043 | 1505 | 16 |
1862682 | 1862682 | 2021-10-29 | Fremont | Idaho | 16043 | 1505 | 16 |
1852654 | 1852654 | 2021-10-26 | Rio Grande | Colorado | 8105 | 1505 | 22 |
1855242 | 1855242 | 2021-10-26 | Emery | Utah | 49015 | 1505 | 17 |
1815882 | 1815882 | 2021-10-14 | Roberts | South Dakota | 46109 | 1505 | 43 |
1804135 | 1804135 | 2021-10-11 | Stewart | Georgia | 13259 | 1505 | 28 |
1800886 | 1800886 | 2021-10-10 | Stewart | Georgia | 13259 | 1505 | 28 |
1797637 | 1797637 | 2021-10-09 | Stewart | Georgia | 13259 | 1505 | 28 |
1797713 | 1797713 | 2021-10-09 | Owyhee | Idaho | 16073 | 1505 | 38 |
1794388 | 1794388 | 2021-10-08 | Stewart | Georgia | 13259 | 1505 | 28 |
1788958 | 1788958 | 2021-10-06 | Ralls | Missouri | 29173 | 1505 | 14 |
1764535 | 1764535 | 2021-09-28 | Bayfield | Wisconsin | 55007 | 1505 | 24 |
1745527 | 1745527 | 2021-09-23 | Atkinson | Georgia | 13003 | 1505 | 26 |
1739110 | 1739110 | 2021-09-21 | Johnson | Georgia | 13167 | 1505 | 54 |
1732549 | 1732549 | 2021-09-19 | Candler | Georgia | 13043 | 1505 | 73 |
1729299 | 1729299 | 2021-09-18 | Candler | Georgia | 13043 | 1505 | 73 |
1726049 | 1726049 | 2021-09-17 | Candler | Georgia | 13043 | 1505 | 73 |
1718011 | 1718011 | 2021-09-14 | Morgan | Ohio | 39115 | 1505 | 28 |
1702547 | 1702547 | 2021-09-09 | Morgan | Utah | 49029 | 1505 | 11 |
1679151 | 1679151 | 2021-09-02 | Hood River | Oregon | 41027 | 1505 | 35 |
1679733 | 1679733 | 2021-09-02 | Runnels | Texas | 48399 | 1505 | 47 |
1664449 | 1664449 | 2021-08-29 | Towns | Georgia | 13281 | 1505 | 64 |
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);