ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
314 rows where cases = 2055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 57
- Iowa 19
- Georgia 14
- Michigan 14
- Virginia 13
- Illinois 12
- Missouri 12
- Texas 12
- Kentucky 11
- Mississippi 11
- Tennessee 10
- Alabama 8
- Arkansas 8
- Indiana 8
- Oklahoma 8
- Puerto Rico 8
- South Carolina 8
- Minnesota 7
- West Virginia 7
- Louisiana 6
- Ohio 6
- Washington 6
- Kansas 5
- Nevada 5
- New Hampshire 5
- Utah 5
- North Carolina 4
- Pennsylvania 4
- Wisconsin 4
- Vermont 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499290 | 2499290 | 2022-05-12 | Fairfax city | Virginia | 51600 | 2055 | 43 |
2440069 | 2440069 | 2022-04-24 | Hormigueros | Puerto Rico | 72067 | 2055 | |
2423038 | 2423038 | 2022-04-19 | Carbon | Montana | 30009 | 2055 | 28 |
2399477 | 2399477 | 2022-04-12 | Keokuk | Iowa | 19107 | 2055 | 48 |
2396221 | 2396221 | 2022-04-11 | Keokuk | Iowa | 19107 | 2055 | 48 |
2392966 | 2392966 | 2022-04-10 | Keokuk | Iowa | 19107 | 2055 | 48 |
2389710 | 2389710 | 2022-04-09 | Keokuk | Iowa | 19107 | 2055 | 48 |
2386454 | 2386454 | 2022-04-08 | Keokuk | Iowa | 19107 | 2055 | 48 |
2383200 | 2383200 | 2022-04-07 | Keokuk | Iowa | 19107 | 2055 | 48 |
2379945 | 2379945 | 2022-04-06 | Keokuk | Iowa | 19107 | 2055 | 48 |
2291151 | 2291151 | 2022-03-09 | Pleasants | West Virginia | 54073 | 2055 | 34 |
2268250 | 2268250 | 2022-03-02 | Madison | Virginia | 51113 | 2055 | 36 |
2244910 | 2244910 | 2022-02-23 | Allendale | South Carolina | 45005 | 2055 | 24 |
2242349 | 2242349 | 2022-02-22 | Gilmer | West Virginia | 54021 | 2055 | 18 |
2214243 | 2214243 | 2022-02-14 | Bracken | Kentucky | 21023 | 2055 | 23 |
2210876 | 2210876 | 2022-02-13 | Anderson | Kansas | 20003 | 2055 | 24 |
2211320 | 2211320 | 2022-02-13 | Clearwater | Minnesota | 27029 | 2055 | 29 |
2207623 | 2207623 | 2022-02-12 | Anderson | Kansas | 20003 | 2055 | 24 |
2208067 | 2208067 | 2022-02-12 | Clearwater | Minnesota | 27029 | 2055 | 29 |
2204370 | 2204370 | 2022-02-11 | Anderson | Kansas | 20003 | 2055 | 24 |
2204814 | 2204814 | 2022-02-11 | Clearwater | Minnesota | 27029 | 2055 | 29 |
2201117 | 2201117 | 2022-02-10 | Anderson | Kansas | 20003 | 2055 | 24 |
2197863 | 2197863 | 2022-02-09 | Anderson | Kansas | 20003 | 2055 | 24 |
2180462 | 2180462 | 2022-02-03 | Northampton | Virginia | 51131 | 2055 | 52 |
2170440 | 2170440 | 2022-01-31 | Jim Hogg | Texas | 48247 | 2055 | 20 |
2134920 | 2134920 | 2022-01-20 | Poquoson city | Virginia | 51735 | 2055 | 24 |
2112179 | 2112179 | 2022-01-13 | Sussex | Virginia | 51183 | 2055 | 31 |
2103159 | 2103159 | 2022-01-11 | Turner | Georgia | 13287 | 2055 | 50 |
2103990 | 2103990 | 2022-01-11 | Koochiching | Minnesota | 27071 | 2055 | 32 |
2104133 | 2104133 | 2022-01-11 | Bollinger | Missouri | 29017 | 2055 | 36 |
2084315 | 2084315 | 2022-01-05 | Piscataquis | Maine | 23021 | 2055 | 23 |
2066020 | 2066020 | 2021-12-30 | Yabucoa | Puerto Rico | 72151 | 2055 | |
2062049 | 2062049 | 2021-12-29 | Colfax | Nebraska | 31037 | 2055 | 23 |
2046461 | 2046461 | 2021-12-24 | Catano | Puerto Rico | 72033 | 2055 | |
2043211 | 2043211 | 2021-12-23 | Catano | Puerto Rico | 72033 | 2055 | |
2037729 | 2037729 | 2021-12-22 | Bradley | Arkansas | 5011 | 2055 | 42 |
1996489 | 1996489 | 2021-12-09 | Claiborne | Louisiana | 22027 | 2055 | 66 |
1970943 | 1970943 | 2021-12-01 | Ripley | Missouri | 29181 | 2055 | 49 |
1966181 | 1966181 | 2021-11-30 | Ketchikan Gateway Borough | Alaska | 2130 | 2055 | 11 |
1960888 | 1960888 | 2021-11-28 | Leelanau | Michigan | 26089 | 2055 | 32 |
1957637 | 1957637 | 2021-11-27 | Leelanau | Michigan | 26089 | 2055 | 32 |
1954386 | 1954386 | 2021-11-26 | Leelanau | Michigan | 26089 | 2055 | 32 |
1951135 | 1951135 | 2021-11-25 | Leelanau | Michigan | 26089 | 2055 | 32 |
1947884 | 1947884 | 2021-11-24 | Leelanau | Michigan | 26089 | 2055 | 32 |
1920235 | 1920235 | 2021-11-15 | Juab | Utah | 49023 | 2055 | 18 |
1916985 | 1916985 | 2021-11-14 | Juab | Utah | 49023 | 2055 | 18 |
1913735 | 1913735 | 2021-11-13 | Juab | Utah | 49023 | 2055 | 18 |
1910485 | 1910485 | 2021-11-12 | Juab | Utah | 49023 | 2055 | 18 |
1899423 | 1899423 | 2021-11-09 | Pemiscot | Missouri | 29155 | 2055 | 44 |
1896173 | 1896173 | 2021-11-08 | Pemiscot | Missouri | 29155 | 2055 | 44 |
1892923 | 1892923 | 2021-11-07 | Pemiscot | Missouri | 29155 | 2055 | 44 |
1886423 | 1886423 | 2021-11-05 | Pemiscot | Missouri | 29155 | 2055 | 44 |
1875774 | 1875774 | 2021-11-02 | Piatt | Illinois | 17147 | 2055 | 20 |
1872525 | 1872525 | 2021-11-01 | Piatt | Illinois | 17147 | 2055 | 20 |
1858609 | 1858609 | 2021-10-27 | Martinsville city | Virginia | 51690 | 2055 | 89 |
1847328 | 1847328 | 2021-10-24 | Perry | Mississippi | 28111 | 2055 | 56 |
1844078 | 1844078 | 2021-10-23 | Perry | Mississippi | 28111 | 2055 | 56 |
1840828 | 1840828 | 2021-10-22 | Perry | Mississippi | 28111 | 2055 | 56 |
1833479 | 1833479 | 2021-10-20 | De Witt | Illinois | 17039 | 2055 | 37 |
1829810 | 1829810 | 2021-10-19 | Inyo | California | 6027 | 2055 | 40 |
1822965 | 1822965 | 2021-10-16 | Braxton | West Virginia | 54007 | 2055 | 15 |
1784273 | 1784273 | 2021-10-05 | Lee | Arkansas | 5077 | 2055 | 48 |
1778286 | 1778286 | 2021-10-03 | Mason | Illinois | 17125 | 2055 | 52 |
1775036 | 1775036 | 2021-10-02 | Mason | Illinois | 17125 | 2055 | 52 |
1771786 | 1771786 | 2021-10-01 | Mason | Illinois | 17125 | 2055 | 52 |
1768951 | 1768951 | 2021-09-30 | Magoffin | Kentucky | 21153 | 2055 | 18 |
1762217 | 1762217 | 2021-09-28 | Harrison | Iowa | 19085 | 2055 | 76 |
1758969 | 1758969 | 2021-09-27 | Harrison | Iowa | 19085 | 2055 | 76 |
1755721 | 1755721 | 2021-09-26 | Harrison | Iowa | 19085 | 2055 | 76 |
1752473 | 1752473 | 2021-09-25 | Harrison | Iowa | 19085 | 2055 | 76 |
1749224 | 1749224 | 2021-09-24 | Harrison | Iowa | 19085 | 2055 | 76 |
1745974 | 1745974 | 2021-09-23 | Harrison | Iowa | 19085 | 2055 | 76 |
1742725 | 1742725 | 2021-09-22 | Harrison | Iowa | 19085 | 2055 | 76 |
1739895 | 1739895 | 2021-09-21 | Charlevoix | Michigan | 26029 | 2055 | 29 |
1733627 | 1733627 | 2021-09-19 | Walthall | Mississippi | 28147 | 2055 | 57 |
1733888 | 1733888 | 2021-09-19 | Seward | Nebraska | 31159 | 2055 | 34 |
1730377 | 1730377 | 2021-09-18 | Walthall | Mississippi | 28147 | 2055 | 57 |
1730638 | 1730638 | 2021-09-18 | Seward | Nebraska | 31159 | 2055 | 34 |
1727127 | 1727127 | 2021-09-17 | Walthall | Mississippi | 28147 | 2055 | 57 |
1727388 | 1727388 | 2021-09-17 | Seward | Nebraska | 31159 | 2055 | 34 |
1724139 | 1724139 | 2021-09-16 | Seward | Nebraska | 31159 | 2055 | 34 |
1725539 | 1725539 | 2021-09-16 | Wetzel | West Virginia | 54103 | 2055 | 36 |
1720890 | 1720890 | 2021-09-15 | Seward | Nebraska | 31159 | 2055 | 34 |
1721615 | 1721615 | 2021-09-15 | Clay | South Dakota | 46027 | 2055 | 15 |
1717642 | 1717642 | 2021-09-14 | Seward | Nebraska | 31159 | 2055 | 34 |
1714394 | 1714394 | 2021-09-13 | Seward | Nebraska | 31159 | 2055 | 34 |
1711148 | 1711148 | 2021-09-12 | Seward | Nebraska | 31159 | 2055 | 34 |
1707901 | 1707901 | 2021-09-11 | Seward | Nebraska | 31159 | 2055 | 34 |
1704654 | 1704654 | 2021-09-10 | Seward | Nebraska | 31159 | 2055 | 34 |
1701404 | 1701404 | 2021-09-09 | Seward | Nebraska | 31159 | 2055 | 34 |
1698155 | 1698155 | 2021-09-08 | Seward | Nebraska | 31159 | 2055 | 34 |
1694275 | 1694275 | 2021-09-07 | Webster | Kentucky | 21233 | 2055 | 28 |
1694907 | 1694907 | 2021-09-07 | Seward | Nebraska | 31159 | 2055 | 34 |
1691658 | 1691658 | 2021-09-06 | Seward | Nebraska | 31159 | 2055 | 34 |
1688408 | 1688408 | 2021-09-05 | Seward | Nebraska | 31159 | 2055 | 34 |
1689759 | 1689759 | 2021-09-05 | Barbour | West Virginia | 54001 | 2055 | 35 |
1685158 | 1685158 | 2021-09-04 | Seward | Nebraska | 31159 | 2055 | 34 |
1681907 | 1681907 | 2021-09-03 | Seward | Nebraska | 31159 | 2055 | 34 |
1678659 | 1678659 | 2021-09-02 | Seward | Nebraska | 31159 | 2055 | 34 |
1675411 | 1675411 | 2021-09-01 | Seward | Nebraska | 31159 | 2055 | 34 |
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);