ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
460 rows where cases = 782 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 69
- Nebraska 34
- Virginia 31
- Kentucky 20
- New Mexico 19
- Georgia 17
- Kansas 16
- Puerto Rico 16
- South Dakota 16
- Louisiana 14
- Illinois 13
- Montana 13
- Tennessee 13
- Missouri 10
- North Carolina 10
- Alabama 9
- Michigan 9
- Ohio 9
- Iowa 8
- West Virginia 8
- Wyoming 8
- Indiana 7
- Pennsylvania 7
- Washington 7
- Colorado 6
- Minnesota 6
- South Carolina 6
- Mississippi 5
- Oregon 5
- Virgin Islands 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471921 | 2471921 | 2022-05-04 | Sweet Grass | Montana | 30097 | 782 | 13 |
2468665 | 2468665 | 2022-05-03 | Sweet Grass | Montana | 30097 | 782 | 13 |
2465409 | 2465409 | 2022-05-02 | Sweet Grass | Montana | 30097 | 782 | 13 |
2401413 | 2401413 | 2022-04-12 | Mason | Texas | 48319 | 782 | 12 |
2398158 | 2398158 | 2022-04-11 | Mason | Texas | 48319 | 782 | 12 |
2394903 | 2394903 | 2022-04-10 | Mason | Texas | 48319 | 782 | 12 |
2391647 | 2391647 | 2022-04-09 | Mason | Texas | 48319 | 782 | 12 |
2388391 | 2388391 | 2022-04-08 | Mason | Texas | 48319 | 782 | 12 |
2385136 | 2385136 | 2022-04-07 | Mason | Texas | 48319 | 782 | 12 |
2381881 | 2381881 | 2022-04-06 | Mason | Texas | 48319 | 782 | 12 |
2382025 | 2382025 | 2022-04-06 | St. John | Virgin Islands | 78020 | 782 | 5 |
2378770 | 2378770 | 2022-04-05 | St. John | Virgin Islands | 78020 | 782 | 5 |
2355577 | 2355577 | 2022-03-29 | Marshall | South Dakota | 46091 | 782 | 13 |
2352324 | 2352324 | 2022-03-28 | Marshall | South Dakota | 46091 | 782 | 13 |
2349072 | 2349072 | 2022-03-27 | Marshall | South Dakota | 46091 | 782 | 13 |
2345819 | 2345819 | 2022-03-26 | Marshall | South Dakota | 46091 | 782 | 13 |
2342566 | 2342566 | 2022-03-25 | Marshall | South Dakota | 46091 | 782 | 13 |
2339313 | 2339313 | 2022-03-24 | Marshall | South Dakota | 46091 | 782 | 13 |
2336059 | 2336059 | 2022-03-23 | Marshall | South Dakota | 46091 | 782 | 13 |
2283977 | 2283977 | 2022-03-07 | Bennett | South Dakota | 46007 | 782 | 13 |
2248216 | 2248216 | 2022-02-24 | Clark | South Dakota | 46025 | 782 | 8 |
2240179 | 2240179 | 2022-02-22 | Jewell | Kansas | 20089 | 782 | 13 |
2236928 | 2236928 | 2022-02-21 | Jewell | Kansas | 20089 | 782 | 13 |
2233703 | 2233703 | 2022-02-20 | Osborne | Kansas | 20141 | 782 | 16 |
2230452 | 2230452 | 2022-02-19 | Osborne | Kansas | 20141 | 782 | 16 |
2227201 | 2227201 | 2022-02-18 | Osborne | Kansas | 20141 | 782 | 16 |
2223969 | 2223969 | 2022-02-17 | Sheridan | Kansas | 20179 | 782 | 18 |
2220718 | 2220718 | 2022-02-16 | Sheridan | Kansas | 20179 | 782 | 18 |
2145030 | 2145030 | 2022-01-24 | Calhoun | Arkansas | 5013 | 782 | 9 |
2133373 | 2133373 | 2022-01-20 | Sharkey | Mississippi | 28125 | 782 | 21 |
2120619 | 2120619 | 2022-01-16 | Nuckolls | Nebraska | 31129 | 782 | 13 |
2117367 | 2117367 | 2022-01-15 | Nuckolls | Nebraska | 31129 | 782 | 13 |
2114116 | 2114116 | 2022-01-14 | Nuckolls | Nebraska | 31129 | 782 | 13 |
2111843 | 2111843 | 2022-01-13 | Goliad | Texas | 48175 | 782 | 28 |
2105293 | 2105293 | 2022-01-11 | Coke | Texas | 48081 | 782 | 18 |
2097971 | 2097971 | 2022-01-09 | Union | New Mexico | 35059 | 782 | 12 |
2094719 | 2094719 | 2022-01-08 | Union | New Mexico | 35059 | 782 | 12 |
2091467 | 2091467 | 2022-01-07 | Union | New Mexico | 35059 | 782 | 12 |
2084703 | 2084703 | 2022-01-05 | Putnam | Missouri | 29171 | 782 | 20 |
2085804 | 2085804 | 2022-01-05 | Delta | Texas | 48119 | 782 | 22 |
2080172 | 2080172 | 2022-01-04 | Washington | Colorado | 8121 | 782 | 25 |
2080455 | 2080455 | 2022-01-04 | Lincoln | Idaho | 16063 | 782 | 14 |
2082883 | 2082883 | 2022-01-04 | Norton city | Virginia | 51720 | 782 | 20 |
2062621 | 2062621 | 2021-12-29 | Wallowa | Oregon | 41063 | 782 | 13 |
2055920 | 2055920 | 2021-12-27 | Wells | North Dakota | 38103 | 782 | 11 |
2052934 | 2052934 | 2021-12-26 | Sullivan | Pennsylvania | 42113 | 782 | 28 |
2034903 | 2034903 | 2021-12-21 | Warren | Georgia | 13301 | 782 | 26 |
2019809 | 2019809 | 2021-12-16 | Fillmore | Nebraska | 31059 | 782 | 13 |
2012564 | 2012564 | 2021-12-14 | Meade | Kansas | 20119 | 782 | 14 |
2014568 | 2014568 | 2021-12-14 | Cumberland | Virginia | 51049 | 782 | 19 |
2009313 | 2009313 | 2021-12-13 | Meade | Kansas | 20119 | 782 | 14 |
2006111 | 2006111 | 2021-12-12 | Ballard | Kentucky | 21007 | 782 | 25 |
2002860 | 2002860 | 2021-12-11 | Ballard | Kentucky | 21007 | 782 | 25 |
1999610 | 1999610 | 2021-12-10 | Ballard | Kentucky | 21007 | 782 | 25 |
1993725 | 1993725 | 2021-12-08 | Chouteau | Montana | 30015 | 782 | 8 |
1980691 | 1980691 | 2021-12-04 | Reynolds | Missouri | 29179 | 782 | 12 |
1971842 | 1971842 | 2021-12-01 | Gregory | South Dakota | 46053 | 782 | 31 |
1969059 | 1969059 | 2021-11-30 | Covington city | Virginia | 51580 | 782 | 18 |
1929487 | 1929487 | 2021-11-18 | Sabana Grande | Puerto Rico | 72121 | 782 | |
1925519 | 1925519 | 2021-11-17 | Boone | Nebraska | 31011 | 782 | 4 |
1926237 | 1926237 | 2021-11-17 | Sabana Grande | Puerto Rico | 72121 | 782 | |
1921231 | 1921231 | 2021-11-16 | Henderson | Illinois | 17071 | 782 | 23 |
1876750 | 1876750 | 2021-11-02 | Pondera | Montana | 30073 | 782 | 6 |
1873501 | 1873501 | 2021-11-01 | Pondera | Montana | 30073 | 782 | 6 |
1837095 | 1837095 | 2021-10-21 | Sherman | Kansas | 20181 | 782 | 13 |
1837476 | 1837476 | 2021-10-21 | Lincoln | Minnesota | 27081 | 782 | 5 |
1833846 | 1833846 | 2021-10-20 | Sherman | Kansas | 20181 | 782 | 13 |
1819002 | 1819002 | 2021-10-15 | Penuelas | Puerto Rico | 72111 | 782 | |
1814983 | 1814983 | 2021-10-14 | Broadwater | Montana | 30007 | 782 | 16 |
1815753 | 1815753 | 2021-10-14 | Penuelas | Puerto Rico | 72111 | 782 | |
1812505 | 1812505 | 2021-10-13 | Penuelas | Puerto Rico | 72111 | 782 | |
1805335 | 1805335 | 2021-10-11 | Jefferson | Nebraska | 31095 | 782 | 3 |
1802086 | 1802086 | 2021-10-10 | Jefferson | Nebraska | 31095 | 782 | 3 |
1798837 | 1798837 | 2021-10-09 | Jefferson | Nebraska | 31095 | 782 | 3 |
1795588 | 1795588 | 2021-10-08 | Jefferson | Nebraska | 31095 | 782 | 3 |
1792339 | 1792339 | 2021-10-07 | Jefferson | Nebraska | 31095 | 782 | 3 |
1778314 | 1778314 | 2021-10-03 | Stark | Illinois | 17175 | 782 | 27 |
1775064 | 1775064 | 2021-10-02 | Stark | Illinois | 17175 | 782 | 27 |
1771814 | 1771814 | 2021-10-01 | Stark | Illinois | 17175 | 782 | 27 |
1769179 | 1769179 | 2021-09-30 | Montmorency | Michigan | 26119 | 782 | 23 |
1765930 | 1765930 | 2021-09-29 | Montmorency | Michigan | 26119 | 782 | 23 |
1766874 | 1766874 | 2021-09-29 | Lake | Oregon | 41037 | 782 | 8 |
1759214 | 1759214 | 2021-09-27 | Menifee | Kentucky | 21165 | 782 | 19 |
1746855 | 1746855 | 2021-09-23 | Kearney | Nebraska | 31099 | 782 | 5 |
1743606 | 1743606 | 2021-09-22 | Kearney | Nebraska | 31099 | 782 | 5 |
1741009 | 1741009 | 2021-09-21 | Lajas | Puerto Rico | 72079 | 782 | |
1737760 | 1737760 | 2021-09-20 | Lajas | Puerto Rico | 72079 | 782 | |
1725568 | 1725568 | 2021-09-16 | Iron | Wisconsin | 55051 | 782 | 42 |
1715649 | 1715649 | 2021-09-13 | Mathews | Virginia | 51115 | 782 | 15 |
1710374 | 1710374 | 2021-09-12 | Republic | Kansas | 20157 | 782 | 15 |
1707127 | 1707127 | 2021-09-11 | Republic | Kansas | 20157 | 782 | 15 |
1703879 | 1703879 | 2021-09-10 | Republic | Kansas | 20157 | 782 | 15 |
1698218 | 1698218 | 2021-09-08 | Unknown | New Jersey | 782 | 0 | |
1698240 | 1698240 | 2021-09-08 | Quay | New Mexico | 35037 | 782 | 12 |
1699185 | 1699185 | 2021-09-08 | Martin | Texas | 48317 | 782 | 21 |
1676060 | 1676060 | 2021-09-01 | Santa Isabel | Puerto Rico | 72133 | 782 | |
1671546 | 1671546 | 2021-08-31 | Cameron | Louisiana | 22023 | 782 | 8 |
1668299 | 1668299 | 2021-08-30 | Cameron | Louisiana | 22023 | 782 | 8 |
1668762 | 1668762 | 2021-08-30 | Shelby | Missouri | 29205 | 782 | 7 |
1665052 | 1665052 | 2021-08-29 | Cameron | Louisiana | 22023 | 782 | 8 |
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);