ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
309 rows where cases = 1428 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 37
- Virginia 22
- California 17
- Georgia 15
- Tennessee 15
- Texas 15
- Puerto Rico 13
- Mississippi 11
- Alaska 10
- Illinois 10
- Pennsylvania 9
- Alabama 8
- Indiana 8
- Kentucky 8
- Minnesota 8
- Florida 7
- Michigan 7
- Missouri 7
- North Carolina 7
- Ohio 7
- Arkansas 6
- New York 6
- Wisconsin 6
- Colorado 5
- Idaho 5
- Kansas 4
- Montana 4
- South Dakota 4
- Utah 4
- Maryland 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500534 | 2500534 | 2022-05-13 | Mitchell | Kansas | 20123 | 1428 | 22 |
2498571 | 2498571 | 2022-05-12 | Lake | Oregon | 41037 | 1428 | 29 |
2467085 | 2467085 | 2022-05-03 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1428 | 8 |
2463830 | 2463830 | 2022-05-02 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1428 | 8 |
2460574 | 2460574 | 2022-05-01 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1428 | 8 |
2457318 | 2457318 | 2022-04-30 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1428 | 8 |
2454062 | 2454062 | 2022-04-29 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1428 | 8 |
2450806 | 2450806 | 2022-04-28 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1428 | 8 |
2447550 | 2447550 | 2022-04-27 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1428 | 8 |
2372344 | 2372344 | 2022-04-03 | Mathews | Virginia | 51115 | 1428 | 28 |
2369091 | 2369091 | 2022-04-02 | Mathews | Virginia | 51115 | 1428 | 28 |
2365838 | 2365838 | 2022-04-01 | Mathews | Virginia | 51115 | 1428 | 28 |
2362585 | 2362585 | 2022-03-31 | Mathews | Virginia | 51115 | 1428 | 28 |
2300132 | 2300132 | 2022-03-12 | Guanica | Puerto Rico | 72055 | 1428 | |
2285035 | 2285035 | 2022-03-08 | Huerfano | Colorado | 8055 | 1428 | 31 |
2210740 | 2210740 | 2022-02-13 | Ohio | Indiana | 18115 | 1428 | 17 |
2207487 | 2207487 | 2022-02-12 | Ohio | Indiana | 18115 | 1428 | 17 |
2204234 | 2204234 | 2022-02-11 | Ohio | Indiana | 18115 | 1428 | 17 |
2198346 | 2198346 | 2022-02-09 | Norman | Minnesota | 27107 | 1428 | 13 |
2189997 | 2189997 | 2022-02-06 | Mills | Texas | 48333 | 1428 | 30 |
2186744 | 2186744 | 2022-02-05 | Mills | Texas | 48333 | 1428 | 30 |
2174791 | 2174791 | 2022-02-02 | Power | Idaho | 16077 | 1428 | 18 |
2177377 | 2177377 | 2022-02-02 | Iron | Wisconsin | 55051 | 1428 | 45 |
2146388 | 2146388 | 2022-01-24 | Quitman | Mississippi | 28119 | 1428 | 28 |
2129102 | 2129102 | 2022-01-19 | Hancock | Georgia | 13141 | 1428 | 83 |
2110432 | 2110432 | 2022-01-13 | Montmorency | Michigan | 26119 | 1428 | 43 |
2107181 | 2107181 | 2022-01-12 | Montmorency | Michigan | 26119 | 1428 | 43 |
2088052 | 2088052 | 2022-01-06 | Butler | Nebraska | 31023 | 1428 | 12 |
2083206 | 2083206 | 2022-01-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 1428 | 14 |
2079954 | 2079954 | 2022-01-04 | Southeast Fairbanks Census Area | Alaska | 2240 | 1428 | 14 |
2076702 | 2076702 | 2022-01-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 1428 | 14 |
2060534 | 2060534 | 2021-12-29 | Searcy | Arkansas | 5129 | 1428 | 29 |
2058753 | 2058753 | 2021-12-28 | Madison | Montana | 30057 | 1428 | 20 |
2060074 | 2060074 | 2021-12-28 | Essex | Virginia | 51057 | 1428 | 21 |
2053914 | 2053914 | 2021-12-27 | Perry | Alabama | 1105 | 1428 | 41 |
2055504 | 2055504 | 2021-12-27 | Madison | Montana | 30057 | 1428 | 20 |
2050664 | 2050664 | 2021-12-26 | Perry | Alabama | 1105 | 1428 | 41 |
2047414 | 2047414 | 2021-12-25 | Perry | Alabama | 1105 | 1428 | 41 |
2040814 | 2040814 | 2021-12-22 | Pepin | Wisconsin | 55091 | 1428 | 12 |
2030886 | 2030886 | 2021-12-19 | Poquoson city | Virginia | 51735 | 1428 | 23 |
2027635 | 2027635 | 2021-12-18 | Poquoson city | Virginia | 51735 | 1428 | 23 |
2024384 | 2024384 | 2021-12-17 | Poquoson city | Virginia | 51735 | 1428 | 23 |
2011916 | 2011916 | 2021-12-14 | Yuma | Colorado | 8125 | 1428 | 20 |
2008517 | 2008517 | 2021-12-13 | Nevada | Arkansas | 5099 | 1428 | 41 |
2001265 | 2001265 | 2021-12-10 | Castro | Texas | 48069 | 1428 | 40 |
1994143 | 1994143 | 2021-12-08 | Pembina | North Dakota | 38067 | 1428 | 14 |
1966419 | 1966419 | 2021-11-30 | Unknown | Connecticut | 1428 | 3 | |
1944186 | 1944186 | 2021-11-23 | Howard | Iowa | 19089 | 1428 | 24 |
1946493 | 1946493 | 2021-11-23 | Tyler | West Virginia | 54095 | 1428 | 24 |
1940936 | 1940936 | 2021-11-22 | Howard | Iowa | 19089 | 1428 | 24 |
1937686 | 1937686 | 2021-11-21 | Howard | Iowa | 19089 | 1428 | 24 |
1939332 | 1939332 | 2021-11-21 | Grant | South Dakota | 46051 | 1428 | 46 |
1934436 | 1934436 | 2021-11-20 | Howard | Iowa | 19089 | 1428 | 24 |
1936082 | 1936082 | 2021-11-20 | Grant | South Dakota | 46051 | 1428 | 46 |
1931185 | 1931185 | 2021-11-19 | Howard | Iowa | 19089 | 1428 | 24 |
1932832 | 1932832 | 2021-11-19 | Grant | South Dakota | 46051 | 1428 | 46 |
1927934 | 1927934 | 2021-11-18 | Howard | Iowa | 19089 | 1428 | 24 |
1924684 | 1924684 | 2021-11-17 | Howard | Iowa | 19089 | 1428 | 24 |
1916448 | 1916448 | 2021-11-14 | Coamo | Puerto Rico | 72043 | 1428 | |
1900184 | 1900184 | 2021-11-09 | Anasco | Puerto Rico | 72011 | 1428 | |
1896934 | 1896934 | 2021-11-08 | Anasco | Puerto Rico | 72011 | 1428 | |
1882939 | 1882939 | 2021-11-04 | Clearwater | Minnesota | 27029 | 1428 | 18 |
1859514 | 1859514 | 2021-10-28 | Marshall | Illinois | 17123 | 1428 | 23 |
1823579 | 1823579 | 2021-10-17 | Irwin | Georgia | 13155 | 1428 | 37 |
1826253 | 1826253 | 2021-10-17 | Ritchie | West Virginia | 54085 | 1428 | 17 |
1820330 | 1820330 | 2021-10-16 | Irwin | Georgia | 13155 | 1428 | 37 |
1817081 | 1817081 | 2021-10-15 | Irwin | Georgia | 13155 | 1428 | 37 |
1793464 | 1793464 | 2021-10-07 | Swisher | Texas | 48437 | 1428 | 22 |
1790175 | 1790175 | 2021-10-06 | Ochiltree | Texas | 48357 | 1428 | 32 |
1773536 | 1773536 | 2021-10-01 | Yauco | Puerto Rico | 72153 | 1428 | |
1769502 | 1769502 | 2021-09-30 | Deer Lodge | Montana | 30023 | 1428 | 24 |
1770286 | 1770286 | 2021-09-30 | Yauco | Puerto Rico | 72153 | 1428 | |
1767149 | 1767149 | 2021-09-29 | Todd | South Dakota | 46121 | 1428 | 33 |
1760034 | 1760034 | 2021-09-27 | Yates | New York | 36123 | 1428 | 26 |
1756130 | 1756130 | 2021-09-26 | Arenac | Michigan | 26011 | 1428 | 31 |
1752882 | 1752882 | 2021-09-25 | Arenac | Michigan | 26011 | 1428 | 31 |
1749634 | 1749634 | 2021-09-24 | Arenac | Michigan | 26011 | 1428 | 31 |
1746167 | 1746167 | 2021-09-23 | Edmonson | Kentucky | 21061 | 1428 | 26 |
1740636 | 1740636 | 2021-09-21 | Washington | North Carolina | 37187 | 1428 | 34 |
1719646 | 1719646 | 2021-09-15 | Pulaski | Georgia | 13235 | 1428 | 52 |
1701191 | 1701191 | 2021-09-09 | Grundy | Missouri | 29079 | 1428 | 41 |
1694036 | 1694036 | 2021-09-07 | Shelby | Iowa | 19165 | 1428 | 39 |
1690787 | 1690787 | 2021-09-06 | Shelby | Iowa | 19165 | 1428 | 39 |
1687537 | 1687537 | 2021-09-05 | Shelby | Iowa | 19165 | 1428 | 39 |
1684287 | 1684287 | 2021-09-04 | Shelby | Iowa | 19165 | 1428 | 39 |
1681036 | 1681036 | 2021-09-03 | Shelby | Iowa | 19165 | 1428 | 39 |
1677788 | 1677788 | 2021-09-02 | Shelby | Iowa | 19165 | 1428 | 39 |
1678006 | 1678006 | 2021-09-02 | Pendleton | Kentucky | 21191 | 1428 | 5 |
1674541 | 1674541 | 2021-09-01 | Shelby | Iowa | 19165 | 1428 | 39 |
1675251 | 1675251 | 2021-09-01 | Ripley | Missouri | 29181 | 1428 | 19 |
1670858 | 1670858 | 2021-08-31 | Evans | Georgia | 13109 | 1428 | 37 |
1664132 | 1664132 | 2021-08-29 | Mono | California | 6051 | 1428 | 5 |
1660737 | 1660737 | 2021-08-28 | Wilcox | Alabama | 1131 | 1428 | 32 |
1660884 | 1660884 | 2021-08-28 | Mono | California | 6051 | 1428 | 5 |
1657636 | 1657636 | 2021-08-27 | Mono | California | 6051 | 1428 | 5 |
1654388 | 1654388 | 2021-08-26 | Mono | California | 6051 | 1428 | 5 |
1649671 | 1649671 | 2021-08-24 | Swain | North Carolina | 37173 | 1428 | 19 |
1646553 | 1646553 | 2021-08-23 | Noble | Ohio | 39121 | 1428 | 40 |
1641779 | 1641779 | 2021-08-22 | Shoshone | Idaho | 16079 | 1428 | 41 |
1638529 | 1638529 | 2021-08-21 | Shoshone | Idaho | 16079 | 1428 | 41 |
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);