ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
258 rows where cases = 2237 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 32
- Georgia 18
- Iowa 18
- Tennessee 17
- North Carolina 14
- Arkansas 13
- Michigan 11
- Pennsylvania 11
- Virginia 11
- Colorado 9
- Missouri 9
- Louisiana 8
- Illinois 7
- Texas 6
- Indiana 5
- Minnesota 5
- South Carolina 5
- Kansas 4
- Mississippi 4
- New Mexico 4
- Ohio 4
- Puerto Rico 4
- West Virginia 4
- Maryland 3
- New York 3
- North Dakota 3
- Washington 3
- Wisconsin 3
- Alabama 2
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484318 | 2484318 | 2022-05-08 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2481060 | 2481060 | 2022-05-07 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2477802 | 2477802 | 2022-05-06 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2474544 | 2474544 | 2022-05-05 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2471287 | 2471287 | 2022-05-04 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2468031 | 2468031 | 2022-05-03 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2464776 | 2464776 | 2022-05-02 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2461520 | 2461520 | 2022-05-01 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2458264 | 2458264 | 2022-04-30 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2455008 | 2455008 | 2022-04-29 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2451752 | 2451752 | 2022-04-28 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2448496 | 2448496 | 2022-04-27 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2445240 | 2445240 | 2022-04-26 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2441984 | 2441984 | 2022-04-25 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2436816 | 2436816 | 2022-04-23 | Jayuya | Puerto Rico | 72073 | 2237 | |
2428244 | 2428244 | 2022-04-21 | Unknown | Connecticut | 2237 | 1 | |
2378437 | 2378437 | 2022-04-05 | Moore | Tennessee | 47127 | 2237 | 39 |
2375183 | 2375183 | 2022-04-04 | Moore | Tennessee | 47127 | 2237 | 39 |
2371931 | 2371931 | 2022-04-03 | Moore | Tennessee | 47127 | 2237 | 39 |
2368678 | 2368678 | 2022-04-02 | Moore | Tennessee | 47127 | 2237 | 39 |
2365425 | 2365425 | 2022-04-01 | Moore | Tennessee | 47127 | 2237 | 39 |
2362172 | 2362172 | 2022-03-31 | Moore | Tennessee | 47127 | 2237 | 39 |
2358918 | 2358918 | 2022-03-30 | Moore | Tennessee | 47127 | 2237 | 39 |
2355664 | 2355664 | 2022-03-29 | Moore | Tennessee | 47127 | 2237 | 40 |
2352411 | 2352411 | 2022-03-28 | Moore | Tennessee | 47127 | 2237 | 40 |
2349159 | 2349159 | 2022-03-27 | Moore | Tennessee | 47127 | 2237 | 40 |
2345707 | 2345707 | 2022-03-26 | Sabana Grande | Puerto Rico | 72121 | 2237 | |
2345906 | 2345906 | 2022-03-26 | Moore | Tennessee | 47127 | 2237 | 40 |
2342653 | 2342653 | 2022-03-25 | Moore | Tennessee | 47127 | 2237 | 40 |
2339099 | 2339099 | 2022-03-24 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2339400 | 2339400 | 2022-03-24 | Moore | Tennessee | 47127 | 2237 | 40 |
2334098 | 2334098 | 2022-03-23 | Wilkes | Georgia | 13317 | 2237 | 49 |
2335845 | 2335845 | 2022-03-23 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2336146 | 2336146 | 2022-03-23 | Moore | Tennessee | 47127 | 2237 | 40 |
2332591 | 2332591 | 2022-03-22 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2327346 | 2327346 | 2022-03-21 | San Miguel | Colorado | 8113 | 2237 | 8 |
2329338 | 2329338 | 2022-03-21 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2326086 | 2326086 | 2022-03-20 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2322833 | 2322833 | 2022-03-19 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2319579 | 2319579 | 2022-03-18 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2316325 | 2316325 | 2022-03-17 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2311325 | 2311325 | 2022-03-16 | Wilkes | Georgia | 13317 | 2237 | 49 |
2313072 | 2313072 | 2022-03-16 | Forest | Pennsylvania | 42053 | 2237 | 35 |
2313930 | 2313930 | 2022-03-16 | Webster | West Virginia | 54101 | 2237 | 29 |
2308072 | 2308072 | 2022-03-15 | Wilkes | Georgia | 13317 | 2237 | 49 |
2245379 | 2245379 | 2022-02-23 | Grand | Utah | 49019 | 2237 | 6 |
2242239 | 2242239 | 2022-02-22 | Lunenburg | Virginia | 51111 | 2237 | 28 |
2237930 | 2237930 | 2022-02-21 | Graham | North Carolina | 37075 | 2237 | 30 |
2187986 | 2187986 | 2022-02-06 | Switzerland | Indiana | 18155 | 2237 | 15 |
2184733 | 2184733 | 2022-02-05 | Switzerland | Indiana | 18155 | 2237 | 15 |
2181481 | 2181481 | 2022-02-04 | Switzerland | Indiana | 18155 | 2237 | 15 |
2182236 | 2182236 | 2022-02-04 | Grundy | Missouri | 29079 | 2237 | 62 |
2172336 | 2172336 | 2022-02-01 | Rock | Minnesota | 27133 | 2237 | 32 |
2156500 | 2156500 | 2022-01-27 | Los Alamos | New Mexico | 35028 | 2237 | 12 |
2146419 | 2146419 | 2022-01-24 | Bollinger | Missouri | 29017 | 2237 | 35 |
2128937 | 2128937 | 2022-01-19 | Prowers | Colorado | 8099 | 2237 | 45 |
2101717 | 2101717 | 2022-01-10 | Barceloneta | Puerto Rico | 72017 | 2237 | |
2085151 | 2085151 | 2022-01-05 | McLean | North Dakota | 38055 | 2237 | 47 |
2081443 | 2081443 | 2022-01-04 | Pemiscot | Missouri | 29155 | 2237 | 59 |
2076885 | 2076885 | 2022-01-03 | Gunnison | Colorado | 8051 | 2237 | 13 |
2078621 | 2078621 | 2022-01-03 | Barnes | North Dakota | 38003 | 2237 | 40 |
2034512 | 2034512 | 2021-12-21 | Lee | Arkansas | 5077 | 2237 | 54 |
2032567 | 2032567 | 2021-12-20 | Lawrence | Mississippi | 28077 | 2237 | 43 |
2028148 | 2028148 | 2021-12-19 | Moffat | Colorado | 8081 | 2237 | 48 |
2024897 | 2024897 | 2021-12-18 | Moffat | Colorado | 8081 | 2237 | 48 |
2021646 | 2021646 | 2021-12-17 | Moffat | Colorado | 8081 | 2237 | 48 |
1989689 | 1989689 | 2021-12-07 | Hancock | Iowa | 19081 | 2237 | 40 |
1986439 | 1986439 | 2021-12-06 | Hancock | Iowa | 19081 | 2237 | 40 |
1983189 | 1983189 | 2021-12-05 | Hancock | Iowa | 19081 | 2237 | 40 |
1979939 | 1979939 | 2021-12-04 | Hancock | Iowa | 19081 | 2237 | 40 |
1976689 | 1976689 | 2021-12-03 | Hancock | Iowa | 19081 | 2237 | 40 |
1973440 | 1973440 | 2021-12-02 | Hancock | Iowa | 19081 | 2237 | 40 |
1973930 | 1973930 | 2021-12-02 | Aitkin | Minnesota | 27001 | 2237 | 51 |
1970190 | 1970190 | 2021-12-01 | Hancock | Iowa | 19081 | 2237 | 40 |
1966950 | 1966950 | 2021-11-30 | Jefferson | Iowa | 19101 | 2237 | 43 |
1963546 | 1963546 | 2021-11-29 | Wabash | Illinois | 17185 | 2237 | 22 |
1963698 | 1963698 | 2021-11-29 | Jefferson | Iowa | 19101 | 2237 | 43 |
1960447 | 1960447 | 2021-11-28 | Jefferson | Iowa | 19101 | 2237 | 43 |
1957196 | 1957196 | 2021-11-27 | Jefferson | Iowa | 19101 | 2237 | 43 |
1953945 | 1953945 | 2021-11-26 | Jefferson | Iowa | 19101 | 2237 | 43 |
1950694 | 1950694 | 2021-11-25 | Jefferson | Iowa | 19101 | 2237 | 43 |
1947443 | 1947443 | 2021-11-24 | Jefferson | Iowa | 19101 | 2237 | 43 |
1927248 | 1927248 | 2021-11-18 | Marion | Arkansas | 5089 | 2237 | 61 |
1925409 | 1925409 | 2021-11-17 | Mississippi | Missouri | 29133 | 2237 | 45 |
1922251 | 1922251 | 2021-11-16 | Roosevelt | Montana | 30085 | 2237 | 60 |
1918780 | 1918780 | 2021-11-15 | Greene | Mississippi | 28041 | 2237 | 49 |
1911026 | 1911026 | 2021-11-13 | Van Buren | Arkansas | 5141 | 2237 | 44 |
1891207 | 1891207 | 2021-11-06 | Grant | West Virginia | 54023 | 2237 | 33 |
1875058 | 1875058 | 2021-11-01 | Rusk | Wisconsin | 55107 | 2237 | 35 |
1850261 | 1850261 | 2021-10-25 | Madison | Louisiana | 22065 | 2237 | 52 |
1852267 | 1852267 | 2021-10-25 | Burnett | Wisconsin | 55013 | 2237 | 32 |
1844663 | 1844663 | 2021-10-23 | Walsh | North Dakota | 38099 | 2237 | 29 |
1814613 | 1814613 | 2021-10-14 | Antrim | Michigan | 26009 | 2237 | 36 |
1812007 | 1812007 | 2021-10-13 | Schoharie | New York | 36095 | 2237 | 21 |
1808692 | 1808692 | 2021-10-12 | Grant | New Mexico | 35017 | 2237 | 49 |
1805121 | 1805121 | 2021-10-11 | Bates | Missouri | 29013 | 2237 | 39 |
1790700 | 1790700 | 2021-10-07 | Kodiak Island Borough | Alaska | 2150 | 2237 | 7 |
1785382 | 1785382 | 2021-10-05 | Charlevoix | Michigan | 26029 | 2237 | 29 |
1782719 | 1782719 | 2021-10-04 | Taos | New Mexico | 35055 | 2237 | 62 |
1759689 | 1759689 | 2021-09-27 | Madison | Missouri | 29123 | 2237 | 20 |
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);