ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
368 rows where cases = 1443 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 32
- Indiana 25
- Iowa 24
- Nevada 19
- Texas 19
- Virginia 18
- Colorado 16
- Illinois 15
- Montana 14
- Puerto Rico 14
- Missouri 13
- West Virginia 13
- Michigan 12
- Minnesota 11
- Georgia 10
- Alabama 9
- Nebraska 9
- Pennsylvania 8
- South Dakota 7
- Ohio 6
- Arkansas 5
- Maine 5
- Mississippi 5
- Oklahoma 5
- Oregon 5
- Tennessee 5
- Florida 4
- Kansas 4
- North Carolina 4
- South Carolina 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475041 | 2475041 | 2022-05-05 | Dade | Missouri | 29057 | 1443 | 42 |
2437969 | 2437969 | 2022-04-24 | Huerfano | Colorado | 8055 | 1443 | 32 |
2434713 | 2434713 | 2022-04-23 | Huerfano | Colorado | 8055 | 1443 | 32 |
2431457 | 2431457 | 2022-04-22 | Huerfano | Colorado | 8055 | 1443 | 32 |
2428201 | 2428201 | 2022-04-21 | Huerfano | Colorado | 8055 | 1443 | 32 |
2424945 | 2424945 | 2022-04-20 | Huerfano | Colorado | 8055 | 1443 | 31 |
2421689 | 2421689 | 2022-04-19 | Huerfano | Colorado | 8055 | 1443 | 31 |
2418433 | 2418433 | 2022-04-18 | Huerfano | Colorado | 8055 | 1443 | 31 |
2415177 | 2415177 | 2022-04-17 | Huerfano | Colorado | 8055 | 1443 | 31 |
2417916 | 2417916 | 2022-04-17 | Mathews | Virginia | 51115 | 1443 | 28 |
2411921 | 2411921 | 2022-04-16 | Huerfano | Colorado | 8055 | 1443 | 31 |
2414660 | 2414660 | 2022-04-16 | Mathews | Virginia | 51115 | 1443 | 28 |
2408665 | 2408665 | 2022-04-15 | Huerfano | Colorado | 8055 | 1443 | 31 |
2411404 | 2411404 | 2022-04-15 | Mathews | Virginia | 51115 | 1443 | 28 |
2405409 | 2405409 | 2022-04-14 | Huerfano | Colorado | 8055 | 1443 | 31 |
2402154 | 2402154 | 2022-04-13 | Huerfano | Colorado | 8055 | 1443 | 31 |
2399388 | 2399388 | 2022-04-12 | Ohio | Indiana | 18115 | 1443 | 19 |
2396133 | 2396133 | 2022-04-11 | Ohio | Indiana | 18115 | 1443 | 19 |
2392877 | 2392877 | 2022-04-10 | Ohio | Indiana | 18115 | 1443 | 19 |
2389621 | 2389621 | 2022-04-09 | Ohio | Indiana | 18115 | 1443 | 19 |
2386366 | 2386366 | 2022-04-08 | Ohio | Indiana | 18115 | 1443 | 19 |
2376602 | 2376602 | 2022-04-05 | Ohio | Indiana | 18115 | 1443 | 19 |
2373350 | 2373350 | 2022-04-04 | Ohio | Indiana | 18115 | 1443 | 19 |
2370097 | 2370097 | 2022-04-03 | Ohio | Indiana | 18115 | 1443 | 19 |
2366844 | 2366844 | 2022-04-02 | Ohio | Indiana | 18115 | 1443 | 19 |
2363591 | 2363591 | 2022-04-01 | Ohio | Indiana | 18115 | 1443 | 19 |
2360337 | 2360337 | 2022-03-31 | Ohio | Indiana | 18115 | 1443 | 19 |
2357083 | 2357083 | 2022-03-30 | Ohio | Indiana | 18115 | 1443 | 19 |
2347325 | 2347325 | 2022-03-27 | Ohio | Indiana | 18115 | 1443 | 19 |
2344072 | 2344072 | 2022-03-26 | Ohio | Indiana | 18115 | 1443 | 19 |
2340819 | 2340819 | 2022-03-25 | Ohio | Indiana | 18115 | 1443 | 19 |
2337566 | 2337566 | 2022-03-24 | Ohio | Indiana | 18115 | 1443 | 19 |
2334312 | 2334312 | 2022-03-23 | Ohio | Indiana | 18115 | 1443 | 19 |
2331058 | 2331058 | 2022-03-22 | Ohio | Indiana | 18115 | 1443 | 19 |
2319648 | 2319648 | 2022-03-18 | Guanica | Puerto Rico | 72055 | 1443 | |
2314792 | 2314792 | 2022-03-17 | Ohio | Indiana | 18115 | 1443 | 19 |
2311539 | 2311539 | 2022-03-16 | Ohio | Indiana | 18115 | 1443 | 19 |
2282863 | 2282863 | 2022-03-07 | Grant | Minnesota | 27051 | 1443 | 12 |
2256577 | 2256577 | 2022-02-27 | Menifee | Kentucky | 21165 | 1443 | 30 |
2253326 | 2253326 | 2022-02-26 | Menifee | Kentucky | 21165 | 1443 | 30 |
2250075 | 2250075 | 2022-02-25 | Menifee | Kentucky | 21165 | 1443 | 30 |
2224667 | 2224667 | 2022-02-17 | Cedar | Nebraska | 31027 | 1443 | 11 |
2225776 | 2225776 | 2022-02-17 | Mills | Texas | 48333 | 1443 | 33 |
2221416 | 2221416 | 2022-02-16 | Cedar | Nebraska | 31027 | 1443 | 11 |
2222525 | 2222525 | 2022-02-16 | Mills | Texas | 48333 | 1443 | 33 |
2197475 | 2197475 | 2022-02-09 | Randolph | Georgia | 13243 | 1443 | 47 |
2126691 | 2126691 | 2022-01-18 | Montmorency | Michigan | 26119 | 1443 | 43 |
2123439 | 2123439 | 2022-01-17 | Montmorency | Michigan | 26119 | 1443 | 43 |
2120187 | 2120187 | 2022-01-16 | Montmorency | Michigan | 26119 | 1443 | 43 |
2121706 | 2121706 | 2022-01-16 | Refugio | Texas | 48391 | 1443 | 31 |
2116935 | 2116935 | 2022-01-15 | Montmorency | Michigan | 26119 | 1443 | 43 |
2113684 | 2113684 | 2022-01-14 | Montmorency | Michigan | 26119 | 1443 | 43 |
2107545 | 2107545 | 2022-01-12 | Valley | Montana | 30105 | 1443 | 32 |
2085538 | 2085538 | 2022-01-05 | Allendale | South Carolina | 45005 | 1443 | 22 |
2063662 | 2063662 | 2021-12-30 | Perry | Alabama | 1105 | 1443 | 41 |
2061977 | 2061977 | 2021-12-29 | Blaine | Montana | 30005 | 1443 | 28 |
2058728 | 2058728 | 2021-12-28 | Blaine | Montana | 30005 | 1443 | 28 |
2059451 | 2059451 | 2021-12-28 | Barceloneta | Puerto Rico | 72017 | 1443 | |
2055479 | 2055479 | 2021-12-27 | Blaine | Montana | 30005 | 1443 | 28 |
2052229 | 2052229 | 2021-12-26 | Blaine | Montana | 30005 | 1443 | 28 |
2052393 | 2052393 | 2021-12-26 | White Pine | Nevada | 32033 | 1443 | 18 |
2052990 | 2052990 | 2021-12-26 | Luquillo | Puerto Rico | 72089 | 1443 | |
2053317 | 2053317 | 2021-12-26 | Franklin | Texas | 48159 | 1443 | 37 |
2048979 | 2048979 | 2021-12-25 | Blaine | Montana | 30005 | 1443 | 28 |
2049143 | 2049143 | 2021-12-25 | White Pine | Nevada | 32033 | 1443 | 18 |
2050067 | 2050067 | 2021-12-25 | Franklin | Texas | 48159 | 1443 | 37 |
2045729 | 2045729 | 2021-12-24 | Blaine | Montana | 30005 | 1443 | 28 |
2045893 | 2045893 | 2021-12-24 | White Pine | Nevada | 32033 | 1443 | 18 |
2046817 | 2046817 | 2021-12-24 | Franklin | Texas | 48159 | 1443 | 37 |
2042479 | 2042479 | 2021-12-23 | Blaine | Montana | 30005 | 1443 | 28 |
2042643 | 2042643 | 2021-12-23 | White Pine | Nevada | 32033 | 1443 | 18 |
2043567 | 2043567 | 2021-12-23 | Franklin | Texas | 48159 | 1443 | 37 |
2039230 | 2039230 | 2021-12-22 | Blaine | Montana | 30005 | 1443 | 28 |
2039394 | 2039394 | 2021-12-22 | White Pine | Nevada | 32033 | 1443 | 18 |
2035980 | 2035980 | 2021-12-21 | Blaine | Montana | 30005 | 1443 | 28 |
2036144 | 2036144 | 2021-12-21 | White Pine | Nevada | 32033 | 1443 | 18 |
2031214 | 2031214 | 2021-12-20 | Greenlee | Arizona | 4011 | 1443 | 24 |
2032730 | 2032730 | 2021-12-20 | Blaine | Montana | 30005 | 1443 | 28 |
2032894 | 2032894 | 2021-12-20 | White Pine | Nevada | 32033 | 1443 | 18 |
2029643 | 2029643 | 2021-12-19 | White Pine | Nevada | 32033 | 1443 | 18 |
2026392 | 2026392 | 2021-12-18 | White Pine | Nevada | 32033 | 1443 | 18 |
2023141 | 2023141 | 2021-12-17 | White Pine | Nevada | 32033 | 1443 | 18 |
2019890 | 2019890 | 2021-12-16 | White Pine | Nevada | 32033 | 1443 | 18 |
2020448 | 2020448 | 2021-12-16 | Anasco | Puerto Rico | 72011 | 1443 | |
2020874 | 2020874 | 2021-12-16 | La Salle | Texas | 48283 | 1443 | 40 |
2016640 | 2016640 | 2021-12-15 | White Pine | Nevada | 32033 | 1443 | 18 |
2017809 | 2017809 | 2021-12-15 | Charlotte | Virginia | 51037 | 1443 | 28 |
2013389 | 2013389 | 2021-12-14 | White Pine | Nevada | 32033 | 1443 | 18 |
2010138 | 2010138 | 2021-12-13 | White Pine | Nevada | 32033 | 1443 | 18 |
2006887 | 2006887 | 2021-12-12 | White Pine | Nevada | 32033 | 1443 | 18 |
2003636 | 2003636 | 2021-12-11 | White Pine | Nevada | 32033 | 1443 | 18 |
2000386 | 2000386 | 2021-12-10 | White Pine | Nevada | 32033 | 1443 | 18 |
1997135 | 1997135 | 2021-12-09 | White Pine | Nevada | 32033 | 1443 | 18 |
1984039 | 1984039 | 2021-12-05 | Cheyenne | Nebraska | 31033 | 1443 | 19 |
1980789 | 1980789 | 2021-12-04 | Cheyenne | Nebraska | 31033 | 1443 | 19 |
1977539 | 1977539 | 2021-12-03 | Cheyenne | Nebraska | 31033 | 1443 | 19 |
1972726 | 1972726 | 2021-12-02 | Cleveland | Arkansas | 5025 | 1443 | 33 |
1974317 | 1974317 | 2021-12-02 | Holt | Nebraska | 31089 | 1443 | 16 |
1972461 | 1972461 | 2021-12-01 | Doddridge | West Virginia | 54017 | 1443 | 11 |
1962711 | 1962711 | 2021-11-28 | Gilmer | West Virginia | 54021 | 1443 | 14 |
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);