ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
235 rows where cases = 2423 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 36
- Oklahoma 14
- Virginia 13
- Georgia 12
- South Dakota 12
- Tennessee 11
- Indiana 10
- Iowa 10
- Missouri 9
- Arkansas 8
- Mississippi 8
- North Carolina 8
- Ohio 7
- South Carolina 7
- Kentucky 6
- Puerto Rico 6
- Kansas 5
- Wisconsin 5
- Arizona 4
- New York 4
- California 3
- Idaho 3
- Illinois 3
- Louisiana 3
- Wyoming 3
- Alabama 2
- Colorado 2
- Florida 2
- Minnesota 2
- Nebraska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486096 | 2486096 | 2022-05-08 | Ochiltree | Texas | 48357 | 2423 | 48 |
2482838 | 2482838 | 2022-05-07 | Ochiltree | Texas | 48357 | 2423 | 48 |
2479580 | 2479580 | 2022-05-06 | Ochiltree | Texas | 48357 | 2423 | 48 |
2476322 | 2476322 | 2022-05-05 | Ochiltree | Texas | 48357 | 2423 | 48 |
2473065 | 2473065 | 2022-05-04 | Ochiltree | Texas | 48357 | 2423 | 48 |
2469809 | 2469809 | 2022-05-03 | Ochiltree | Texas | 48357 | 2423 | 48 |
2470007 | 2470007 | 2022-05-03 | Madison | Virginia | 51113 | 2423 | 41 |
2466553 | 2466553 | 2022-05-02 | Ochiltree | Texas | 48357 | 2423 | 48 |
2463298 | 2463298 | 2022-05-01 | Ochiltree | Texas | 48357 | 2423 | 48 |
2459608 | 2459608 | 2022-04-30 | Jayuya | Puerto Rico | 72073 | 2423 | |
2460042 | 2460042 | 2022-04-30 | Ochiltree | Texas | 48357 | 2423 | 48 |
2456786 | 2456786 | 2022-04-29 | Ochiltree | Texas | 48357 | 2423 | 48 |
2453530 | 2453530 | 2022-04-28 | Ochiltree | Texas | 48357 | 2423 | 48 |
2450274 | 2450274 | 2022-04-27 | Ochiltree | Texas | 48357 | 2423 | 48 |
2447017 | 2447017 | 2022-04-26 | Ochiltree | Texas | 48357 | 2423 | 48 |
2443762 | 2443762 | 2022-04-25 | Ochiltree | Texas | 48357 | 2423 | 48 |
2443958 | 2443958 | 2022-04-25 | Lunenburg | Virginia | 51111 | 2423 | 37 |
2440506 | 2440506 | 2022-04-24 | Ochiltree | Texas | 48357 | 2423 | 48 |
2437250 | 2437250 | 2022-04-23 | Ochiltree | Texas | 48357 | 2423 | 48 |
2433994 | 2433994 | 2022-04-22 | Ochiltree | Texas | 48357 | 2423 | 48 |
2430738 | 2430738 | 2022-04-21 | Ochiltree | Texas | 48357 | 2423 | 48 |
2430983 | 2430983 | 2022-04-21 | Sussex | Virginia | 51183 | 2423 | 41 |
2424471 | 2424471 | 2022-04-19 | Sussex | Virginia | 51183 | 2423 | 41 |
2404935 | 2404935 | 2022-04-13 | Sussex | Virginia | 51183 | 2423 | 41 |
2355589 | 2355589 | 2022-03-29 | Roberts | South Dakota | 46109 | 2423 | 52 |
2352336 | 2352336 | 2022-03-28 | Roberts | South Dakota | 46109 | 2423 | 52 |
2349084 | 2349084 | 2022-03-27 | Roberts | South Dakota | 46109 | 2423 | 52 |
2345831 | 2345831 | 2022-03-26 | Roberts | South Dakota | 46109 | 2423 | 52 |
2342578 | 2342578 | 2022-03-25 | Roberts | South Dakota | 46109 | 2423 | 52 |
2339325 | 2339325 | 2022-03-24 | Roberts | South Dakota | 46109 | 2423 | 52 |
2336071 | 2336071 | 2022-03-23 | Roberts | South Dakota | 46109 | 2423 | 52 |
2237034 | 2237034 | 2022-02-21 | Hancock | Kentucky | 21091 | 2423 | 20 |
2217335 | 2217335 | 2022-02-15 | Louisa | Iowa | 19115 | 2423 | 60 |
2214084 | 2214084 | 2022-02-14 | Louisa | Iowa | 19115 | 2423 | 60 |
2214736 | 2214736 | 2022-02-14 | Bollinger | Missouri | 29017 | 2423 | 35 |
2215714 | 2215714 | 2022-02-14 | Dewey | South Dakota | 46041 | 2423 | 38 |
2210832 | 2210832 | 2022-02-13 | Louisa | Iowa | 19115 | 2423 | 60 |
2212358 | 2212358 | 2022-02-13 | Luquillo | Puerto Rico | 72089 | 2423 | |
2207579 | 2207579 | 2022-02-12 | Louisa | Iowa | 19115 | 2423 | 60 |
2204326 | 2204326 | 2022-02-11 | Louisa | Iowa | 19115 | 2423 | 60 |
2201073 | 2201073 | 2022-02-10 | Louisa | Iowa | 19115 | 2423 | 60 |
2197819 | 2197819 | 2022-02-09 | Louisa | Iowa | 19115 | 2423 | 60 |
2198380 | 2198380 | 2022-02-09 | Yellow Medicine | Minnesota | 27173 | 2423 | 28 |
2189888 | 2189888 | 2022-02-06 | Dawson | Texas | 48115 | 2423 | 91 |
2186635 | 2186635 | 2022-02-05 | Dawson | Texas | 48115 | 2423 | 91 |
2173147 | 2173147 | 2022-02-01 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2173876 | 2173876 | 2022-02-01 | Amelia | Virginia | 51007 | 2423 | 47 |
2169895 | 2169895 | 2022-01-31 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2166640 | 2166640 | 2022-01-30 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2163385 | 2163385 | 2022-01-29 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2160130 | 2160130 | 2022-01-28 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2156875 | 2156875 | 2022-01-27 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2153622 | 2153622 | 2022-01-26 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2148876 | 2148876 | 2022-01-25 | Brown | Indiana | 18013 | 2423 | 58 |
2150352 | 2150352 | 2022-01-25 | Johnston | Oklahoma | 40069 | 2423 | 49 |
2147100 | 2147100 | 2022-01-24 | Johnston | Oklahoma | 40069 | 2423 | 49 |
2143846 | 2143846 | 2022-01-23 | Johnston | Oklahoma | 40069 | 2423 | 49 |
2140591 | 2140591 | 2022-01-22 | Johnston | Oklahoma | 40069 | 2423 | 49 |
2137335 | 2137335 | 2022-01-21 | Johnston | Oklahoma | 40069 | 2423 | 49 |
2134081 | 2134081 | 2022-01-20 | Johnston | Oklahoma | 40069 | 2423 | 49 |
2130829 | 2130829 | 2022-01-19 | Johnston | Oklahoma | 40069 | 2423 | 49 |
2099588 | 2099588 | 2022-01-10 | Mono | California | 6051 | 2423 | 4 |
2100812 | 2100812 | 2022-01-10 | Greene | Mississippi | 28041 | 2423 | 50 |
2101606 | 2101606 | 2022-01-10 | Baker | Oregon | 41001 | 2423 | 37 |
2072235 | 2072235 | 2022-01-01 | Noble | Ohio | 39121 | 2423 | 50 |
2068984 | 2068984 | 2021-12-31 | Noble | Ohio | 39121 | 2423 | 50 |
2060941 | 2060941 | 2021-12-29 | Gooding | Idaho | 16047 | 2423 | 44 |
2063208 | 2063208 | 2021-12-29 | Terry | Texas | 48445 | 2423 | 73 |
2059958 | 2059958 | 2021-12-28 | Terry | Texas | 48445 | 2423 | 73 |
2056709 | 2056709 | 2021-12-27 | Terry | Texas | 48445 | 2423 | 73 |
2039188 | 2039188 | 2021-12-22 | Osage | Missouri | 29151 | 2423 | 36 |
2034545 | 2034545 | 2021-12-21 | Van Buren | Arkansas | 5141 | 2423 | 44 |
2034006 | 2034006 | 2021-12-20 | Millard | Utah | 49027 | 2423 | 31 |
2034044 | 2034044 | 2021-12-20 | Alleghany | Virginia | 51005 | 2423 | 85 |
2013174 | 2013174 | 2021-12-14 | Mississippi | Missouri | 29133 | 2423 | 49 |
1943990 | 1943990 | 2021-11-23 | Johnson | Illinois | 17087 | 2423 | 38 |
1938340 | 1938340 | 2021-11-21 | Yalobusha | Mississippi | 28161 | 2423 | 47 |
1935090 | 1935090 | 2021-11-20 | Yalobusha | Mississippi | 28161 | 2423 | 47 |
1931840 | 1931840 | 2021-11-19 | Yalobusha | Mississippi | 28161 | 2423 | 47 |
1928653 | 1928653 | 2021-11-18 | Madison | Missouri | 29123 | 2423 | 39 |
1906343 | 1906343 | 2021-11-11 | Warren | North Carolina | 37185 | 2423 | 33 |
1903094 | 1903094 | 2021-11-10 | Warren | North Carolina | 37185 | 2423 | 33 |
1900244 | 1900244 | 2021-11-09 | San Lorenzo | Puerto Rico | 72129 | 2423 | |
1896994 | 1896994 | 2021-11-08 | San Lorenzo | Puerto Rico | 72129 | 2423 | |
1881640 | 1881640 | 2021-11-04 | Macon | Alabama | 1087 | 2423 | 63 |
1882001 | 1882001 | 2021-11-04 | Brooks | Georgia | 13027 | 2423 | 70 |
1879409 | 1879409 | 2021-11-03 | Knott | Kentucky | 21119 | 2423 | 36 |
1871114 | 1871114 | 2021-10-31 | Oglala Lakota | South Dakota | 46102 | 2423 | 53 |
1871834 | 1871834 | 2021-10-31 | Goshen | Wyoming | 56015 | 2423 | 38 |
1867865 | 1867865 | 2021-10-30 | Oglala Lakota | South Dakota | 46102 | 2423 | 53 |
1868585 | 1868585 | 2021-10-30 | Goshen | Wyoming | 56015 | 2423 | 38 |
1864616 | 1864616 | 2021-10-29 | Oglala Lakota | South Dakota | 46102 | 2423 | 53 |
1865336 | 1865336 | 2021-10-29 | Goshen | Wyoming | 56015 | 2423 | 38 |
1857987 | 1857987 | 2021-10-27 | Moca | Puerto Rico | 72099 | 2423 | |
1823073 | 1823073 | 2021-10-16 | Sawyer | Wisconsin | 55113 | 2423 | 31 |
1819824 | 1819824 | 2021-10-15 | Sawyer | Wisconsin | 55113 | 2423 | 31 |
1816575 | 1816575 | 2021-10-14 | Sawyer | Wisconsin | 55113 | 2423 | 31 |
1803137 | 1803137 | 2021-10-10 | Leon | Texas | 48289 | 2423 | 62 |
1799888 | 1799888 | 2021-10-09 | Leon | Texas | 48289 | 2423 | 62 |
1763835 | 1763835 | 2021-09-28 | Saluda | South Carolina | 45081 | 2423 | 50 |
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);