ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
416 rows where cases = 1232 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 52
- Kansas 40
- Virginia 26
- Iowa 22
- Idaho 19
- Oklahoma 16
- Montana 15
- Arkansas 13
- Kentucky 12
- Minnesota 12
- Tennessee 12
- Georgia 11
- Illinois 11
- Oregon 11
- Missouri 10
- Puerto Rico 10
- Wisconsin 10
- Louisiana 9
- Alabama 8
- Nebraska 8
- Indiana 7
- West Virginia 7
- Colorado 6
- Mississippi 6
- Pennsylvania 6
- North Carolina 5
- South Dakota 5
- Vermont 5
- Utah 4
- Wyoming 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428860 | 2428860 | 2022-04-21 | Gray | Kansas | 20069 | 1232 | 23 |
2425604 | 2425604 | 2022-04-20 | Gray | Kansas | 20069 | 1232 | 23 |
2422348 | 2422348 | 2022-04-19 | Gray | Kansas | 20069 | 1232 | 23 |
2419092 | 2419092 | 2022-04-18 | Gray | Kansas | 20069 | 1232 | 23 |
2415836 | 2415836 | 2022-04-17 | Gray | Kansas | 20069 | 1232 | 23 |
2412580 | 2412580 | 2022-04-16 | Gray | Kansas | 20069 | 1232 | 23 |
2409324 | 2409324 | 2022-04-15 | Gray | Kansas | 20069 | 1232 | 23 |
2406068 | 2406068 | 2022-04-14 | Gray | Kansas | 20069 | 1232 | 23 |
2402812 | 2402812 | 2022-04-13 | Gray | Kansas | 20069 | 1232 | 23 |
2399558 | 2399558 | 2022-04-12 | Gray | Kansas | 20069 | 1232 | 23 |
2396302 | 2396302 | 2022-04-11 | Gray | Kansas | 20069 | 1232 | 23 |
2393047 | 2393047 | 2022-04-10 | Gray | Kansas | 20069 | 1232 | 23 |
2389791 | 2389791 | 2022-04-09 | Gray | Kansas | 20069 | 1232 | 23 |
2386535 | 2386535 | 2022-04-08 | Gray | Kansas | 20069 | 1232 | 23 |
2385085 | 2385085 | 2022-04-07 | Hemphill | Texas | 48211 | 1232 | 7 |
2381830 | 2381830 | 2022-04-06 | Hemphill | Texas | 48211 | 1232 | 7 |
2378575 | 2378575 | 2022-04-05 | Hemphill | Texas | 48211 | 1232 | 7 |
2375321 | 2375321 | 2022-04-04 | Hemphill | Texas | 48211 | 1232 | 7 |
2372069 | 2372069 | 2022-04-03 | Hemphill | Texas | 48211 | 1232 | 7 |
2368816 | 2368816 | 2022-04-02 | Hemphill | Texas | 48211 | 1232 | 7 |
2365563 | 2365563 | 2022-04-01 | Hemphill | Texas | 48211 | 1232 | 7 |
2347494 | 2347494 | 2022-03-27 | Gray | Kansas | 20069 | 1232 | 23 |
2344241 | 2344241 | 2022-03-26 | Gray | Kansas | 20069 | 1232 | 23 |
2340988 | 2340988 | 2022-03-25 | Gray | Kansas | 20069 | 1232 | 23 |
2337735 | 2337735 | 2022-03-24 | Gray | Kansas | 20069 | 1232 | 23 |
2334481 | 2334481 | 2022-03-23 | Gray | Kansas | 20069 | 1232 | 23 |
2316860 | 2316860 | 2022-03-17 | Sabine | Texas | 48403 | 1232 | 88 |
2313607 | 2313607 | 2022-03-16 | Sabine | Texas | 48403 | 1232 | 88 |
2313694 | 2313694 | 2022-03-16 | Essex | Vermont | 50009 | 1232 | 3 |
2310354 | 2310354 | 2022-03-15 | Sabine | Texas | 48403 | 1232 | 88 |
2307101 | 2307101 | 2022-03-14 | Sabine | Texas | 48403 | 1232 | 88 |
2303850 | 2303850 | 2022-03-13 | Sabine | Texas | 48403 | 1232 | 88 |
2300598 | 2300598 | 2022-03-12 | Sabine | Texas | 48403 | 1232 | 88 |
2297346 | 2297346 | 2022-03-11 | Sabine | Texas | 48403 | 1232 | 88 |
2294094 | 2294094 | 2022-03-10 | Sabine | Texas | 48403 | 1232 | 88 |
2290974 | 2290974 | 2022-03-09 | Cumberland | Virginia | 51049 | 1232 | 24 |
2287473 | 2287473 | 2022-03-08 | Garza | Texas | 48169 | 1232 | 27 |
2284221 | 2284221 | 2022-03-07 | Garza | Texas | 48169 | 1232 | 27 |
2279200 | 2279200 | 2022-03-06 | Kearny | Kansas | 20093 | 1232 | 20 |
2280969 | 2280969 | 2022-03-06 | Garza | Texas | 48169 | 1232 | 27 |
2275947 | 2275947 | 2022-03-05 | Kearny | Kansas | 20093 | 1232 | 20 |
2277716 | 2277716 | 2022-03-05 | Garza | Texas | 48169 | 1232 | 27 |
2272694 | 2272694 | 2022-03-04 | Kearny | Kansas | 20093 | 1232 | 20 |
2267509 | 2267509 | 2022-03-02 | Wallowa | Oregon | 41063 | 1232 | 14 |
2264256 | 2264256 | 2022-03-01 | Wallowa | Oregon | 41063 | 1232 | 14 |
2260476 | 2260476 | 2022-02-28 | Morrill | Nebraska | 31123 | 1232 | 18 |
2261006 | 2261006 | 2022-02-28 | Wallowa | Oregon | 41063 | 1232 | 14 |
2251823 | 2251823 | 2022-02-25 | San Saba | Texas | 48411 | 1232 | 33 |
2246683 | 2246683 | 2022-02-24 | Kearny | Kansas | 20093 | 1232 | 20 |
2248572 | 2248572 | 2022-02-24 | San Saba | Texas | 48411 | 1232 | 33 |
2243432 | 2243432 | 2022-02-23 | Kearny | Kansas | 20093 | 1232 | 20 |
2245321 | 2245321 | 2022-02-23 | San Saba | Texas | 48411 | 1232 | 33 |
2240181 | 2240181 | 2022-02-22 | Kearny | Kansas | 20093 | 1232 | 20 |
2236930 | 2236930 | 2022-02-21 | Kearny | Kansas | 20093 | 1232 | 20 |
2218221 | 2218221 | 2022-02-15 | Pierce | Nebraska | 31139 | 1232 | 21 |
2211718 | 2211718 | 2022-02-13 | Pierce | Nebraska | 31139 | 1232 | 21 |
2208465 | 2208465 | 2022-02-12 | Pierce | Nebraska | 31139 | 1232 | 21 |
2204059 | 2204059 | 2022-02-11 | Lemhi | Idaho | 16059 | 1232 | 25 |
2205212 | 2205212 | 2022-02-11 | Pierce | Nebraska | 31139 | 1232 | 21 |
2186629 | 2186629 | 2022-02-05 | Crane | Texas | 48103 | 1232 | 21 |
2173671 | 2173671 | 2022-02-01 | Hartley | Texas | 48205 | 1232 | 3 |
2170419 | 2170419 | 2022-01-31 | Hartley | Texas | 48205 | 1232 | 3 |
2167671 | 2167671 | 2022-01-30 | Crook | Wyoming | 56011 | 1232 | 22 |
2164416 | 2164416 | 2022-01-29 | Crook | Wyoming | 56011 | 1232 | 22 |
2161161 | 2161161 | 2022-01-28 | Crook | Wyoming | 56011 | 1232 | 22 |
2110725 | 2110725 | 2022-01-13 | Shelby | Missouri | 29205 | 1232 | 13 |
2080544 | 2080544 | 2022-01-04 | Pulaski | Illinois | 17153 | 1232 | 15 |
2056741 | 2056741 | 2021-12-27 | Beaver | Utah | 49001 | 1232 | 14 |
2049717 | 2049717 | 2021-12-25 | Comerio | Puerto Rico | 72045 | 1232 | |
2035298 | 2035298 | 2021-12-21 | Harper | Kansas | 20077 | 1232 | 25 |
2032048 | 2032048 | 2021-12-20 | Harper | Kansas | 20077 | 1232 | 25 |
2034115 | 2034115 | 2021-12-20 | Madison | Virginia | 51113 | 1232 | 24 |
2014858 | 2014858 | 2021-12-14 | Weston | Wyoming | 56045 | 1232 | 14 |
2008837 | 2008837 | 2021-12-13 | Lincoln | Georgia | 13181 | 1232 | 33 |
1990583 | 1990583 | 2021-12-07 | Merrick | Nebraska | 31121 | 1232 | 15 |
1970863 | 1970863 | 2021-12-01 | Caldwell | Missouri | 29025 | 1232 | 26 |
1965999 | 1965999 | 2021-11-29 | Tucker | West Virginia | 54093 | 1232 | 31 |
1944885 | 1944885 | 2021-11-23 | Hickory | Missouri | 29085 | 1232 | 43 |
1917646 | 1917646 | 2021-11-15 | San Miguel | Colorado | 8113 | 1232 | 5 |
1916657 | 1916657 | 2021-11-14 | Hancock | Tennessee | 47067 | 1232 | 20 |
1917295 | 1917295 | 2021-11-14 | Pepin | Wisconsin | 55091 | 1232 | 10 |
1913407 | 1913407 | 2021-11-13 | Hancock | Tennessee | 47067 | 1232 | 20 |
1914045 | 1914045 | 2021-11-13 | Pepin | Wisconsin | 55091 | 1232 | 10 |
1910157 | 1910157 | 2021-11-12 | Hancock | Tennessee | 47067 | 1232 | 20 |
1910795 | 1910795 | 2021-11-12 | Pepin | Wisconsin | 55091 | 1232 | 10 |
1906908 | 1906908 | 2021-11-11 | Hancock | Tennessee | 47067 | 1232 | 20 |
1903659 | 1903659 | 2021-11-10 | Hancock | Tennessee | 47067 | 1232 | 20 |
1877485 | 1877485 | 2021-11-02 | Orocovis | Puerto Rico | 72107 | 1232 | |
1871364 | 1871364 | 2021-10-31 | La Salle | Texas | 48283 | 1232 | 40 |
1868115 | 1868115 | 2021-10-30 | La Salle | Texas | 48283 | 1232 | 40 |
1864866 | 1864866 | 2021-10-29 | La Salle | Texas | 48283 | 1232 | 40 |
1849632 | 1849632 | 2021-10-25 | Terrell | Georgia | 13273 | 1232 | 56 |
1846887 | 1846887 | 2021-10-24 | Cumberland | Kentucky | 21057 | 1232 | 19 |
1843637 | 1843637 | 2021-10-23 | Cumberland | Kentucky | 21057 | 1232 | 19 |
1832526 | 1832526 | 2021-10-19 | Lamoille | Vermont | 50015 | 1232 | 6 |
1816314 | 1816314 | 2021-10-14 | Charlotte | Virginia | 51037 | 1232 | 25 |
1808922 | 1808922 | 2021-10-12 | Traill | North Dakota | 38097 | 1232 | 19 |
1798717 | 1798717 | 2021-10-09 | St. Clair | Missouri | 29185 | 1232 | 14 |
1784155 | 1784155 | 2021-10-05 | Greene | Alabama | 1063 | 1232 | 44 |
1784298 | 1784298 | 2021-10-05 | Searcy | Arkansas | 5129 | 1232 | 24 |
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);