ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
357 rows where cases = 1638 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 47
- Texas 35
- Kansas 28
- Virginia 27
- Puerto Rico 23
- Kentucky 21
- North Carolina 21
- Florida 14
- Alabama 11
- Minnesota 11
- Georgia 10
- Illinois 9
- Missouri 9
- Arkansas 8
- Michigan 7
- Mississippi 7
- Tennessee 7
- Indiana 6
- South Carolina 5
- Wisconsin 5
- Colorado 4
- Idaho 4
- Louisiana 4
- Oklahoma 4
- Montana 3
- Pennsylvania 3
- Alaska 2
- Connecticut 2
- New Mexico 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498704 | 2498704 | 2022-05-12 | Maunabo | Puerto Rico | 72095 | 1638 | |
2474509 | 2474509 | 2022-05-05 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2471252 | 2471252 | 2022-05-04 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2467996 | 2467996 | 2022-05-03 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2469366 | 2469366 | 2022-05-03 | Guanica | Puerto Rico | 72055 | 1638 | |
2469672 | 2469672 | 2022-05-03 | Coleman | Texas | 48083 | 1638 | 71 |
2464741 | 2464741 | 2022-05-02 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2466110 | 2466110 | 2022-05-02 | Guanica | Puerto Rico | 72055 | 1638 | |
2466416 | 2466416 | 2022-05-02 | Coleman | Texas | 48083 | 1638 | 71 |
2461485 | 2461485 | 2022-05-01 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2463161 | 2463161 | 2022-05-01 | Coleman | Texas | 48083 | 1638 | 71 |
2458229 | 2458229 | 2022-04-30 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2459905 | 2459905 | 2022-04-30 | Coleman | Texas | 48083 | 1638 | 71 |
2454973 | 2454973 | 2022-04-29 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2456649 | 2456649 | 2022-04-29 | Coleman | Texas | 48083 | 1638 | 71 |
2451717 | 2451717 | 2022-04-28 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2453393 | 2453393 | 2022-04-28 | Coleman | Texas | 48083 | 1638 | 71 |
2448461 | 2448461 | 2022-04-27 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2445205 | 2445205 | 2022-04-26 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2441949 | 2441949 | 2022-04-25 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2438693 | 2438693 | 2022-04-24 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2435437 | 2435437 | 2022-04-23 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2432181 | 2432181 | 2022-04-22 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2308936 | 2308936 | 2022-03-15 | Wilkin | Minnesota | 27167 | 1638 | 22 |
2305685 | 2305685 | 2022-03-14 | Wilkin | Minnesota | 27167 | 1638 | 22 |
2256428 | 2256428 | 2022-02-27 | Harper | Kansas | 20077 | 1638 | 25 |
2253177 | 2253177 | 2022-02-26 | Harper | Kansas | 20077 | 1638 | 25 |
2249926 | 2249926 | 2022-02-25 | Harper | Kansas | 20077 | 1638 | 25 |
2246037 | 2246037 | 2022-02-24 | Rio Blanco | Colorado | 8103 | 1638 | 13 |
2246675 | 2246675 | 2022-02-24 | Harper | Kansas | 20077 | 1638 | 25 |
2243424 | 2243424 | 2022-02-23 | Harper | Kansas | 20077 | 1638 | 25 |
2234656 | 2234656 | 2022-02-20 | Camden | North Carolina | 37029 | 1638 | 9 |
2231405 | 2231405 | 2022-02-19 | Camden | North Carolina | 37029 | 1638 | 9 |
2228154 | 2228154 | 2022-02-18 | Camden | North Carolina | 37029 | 1638 | 9 |
2178765 | 2178765 | 2022-02-03 | Schoolcraft | Michigan | 26153 | 1638 | 13 |
2175513 | 2175513 | 2022-02-02 | Schoolcraft | Michigan | 26153 | 1638 | 13 |
2168179 | 2168179 | 2022-01-31 | Miller | Georgia | 13201 | 1638 | 25 |
2155603 | 2155603 | 2022-01-27 | Greenwood | Kansas | 20073 | 1638 | 20 |
2152350 | 2152350 | 2022-01-26 | Greenwood | Kansas | 20073 | 1638 | 20 |
2144629 | 2144629 | 2022-01-23 | Falls Church city | Virginia | 51610 | 1638 | 14 |
2141374 | 2141374 | 2022-01-22 | Falls Church city | Virginia | 51610 | 1638 | 14 |
2137964 | 2137964 | 2022-01-21 | Rains | Texas | 48379 | 1638 | 50 |
2138118 | 2138118 | 2022-01-21 | Falls Church city | Virginia | 51610 | 1638 | 14 |
2133260 | 2133260 | 2022-01-20 | Lake | Minnesota | 27075 | 1638 | 26 |
2110159 | 2110159 | 2022-01-13 | Cumberland | Kentucky | 21057 | 1638 | 23 |
2105000 | 2105000 | 2022-01-11 | Lajas | Puerto Rico | 72079 | 1638 | |
2105465 | 2105465 | 2022-01-11 | Somervell | Texas | 48425 | 1638 | 27 |
2099148 | 2099148 | 2022-01-09 | Poquoson city | Virginia | 51735 | 1638 | 23 |
2095897 | 2095897 | 2022-01-08 | Poquoson city | Virginia | 51735 | 1638 | 23 |
2092645 | 2092645 | 2022-01-07 | Poquoson city | Virginia | 51735 | 1638 | 23 |
2038984 | 2038984 | 2021-12-22 | Marshall | Minnesota | 27089 | 1638 | 23 |
2030795 | 2030795 | 2021-12-19 | Amelia | Virginia | 51007 | 1638 | 43 |
2027544 | 2027544 | 2021-12-18 | Amelia | Virginia | 51007 | 1638 | 43 |
2024293 | 2024293 | 2021-12-17 | Amelia | Virginia | 51007 | 1638 | 43 |
1989060 | 1989060 | 2021-12-07 | Mariposa | California | 6043 | 1638 | 18 |
1983384 | 1983384 | 2021-12-05 | Edmonson | Kentucky | 21061 | 1638 | 33 |
1980134 | 1980134 | 2021-12-04 | Edmonson | Kentucky | 21061 | 1638 | 33 |
1976884 | 1976884 | 2021-12-03 | Edmonson | Kentucky | 21061 | 1638 | 33 |
1960599 | 1960599 | 2021-11-28 | Wilson | Kansas | 20205 | 1638 | 34 |
1961186 | 1961186 | 2021-11-28 | Ralls | Missouri | 29173 | 1638 | 17 |
1962453 | 1962453 | 2021-11-28 | Trinity | Texas | 48455 | 1638 | 61 |
1957348 | 1957348 | 2021-11-27 | Wilson | Kansas | 20205 | 1638 | 34 |
1957935 | 1957935 | 2021-11-27 | Ralls | Missouri | 29173 | 1638 | 17 |
1959202 | 1959202 | 2021-11-27 | Trinity | Texas | 48455 | 1638 | 61 |
1954097 | 1954097 | 2021-11-26 | Wilson | Kansas | 20205 | 1638 | 34 |
1954684 | 1954684 | 2021-11-26 | Ralls | Missouri | 29173 | 1638 | 17 |
1955951 | 1955951 | 2021-11-26 | Trinity | Texas | 48455 | 1638 | 61 |
1950846 | 1950846 | 2021-11-25 | Wilson | Kansas | 20205 | 1638 | 34 |
1951433 | 1951433 | 2021-11-25 | Ralls | Missouri | 29173 | 1638 | 17 |
1952700 | 1952700 | 2021-11-25 | Trinity | Texas | 48455 | 1638 | 61 |
1947595 | 1947595 | 2021-11-24 | Wilson | Kansas | 20205 | 1638 | 34 |
1948182 | 1948182 | 2021-11-24 | Ralls | Missouri | 29173 | 1638 | 17 |
1949449 | 1949449 | 2021-11-24 | Trinity | Texas | 48455 | 1638 | 61 |
1945942 | 1945942 | 2021-11-23 | Perry | Tennessee | 47135 | 1638 | 34 |
1940387 | 1940387 | 2021-11-22 | Park | Colorado | 8093 | 1638 | 11 |
1928043 | 1928043 | 2021-11-18 | Linn | Kansas | 20107 | 1638 | 21 |
1929070 | 1929070 | 2021-11-18 | Perquimans | North Carolina | 37143 | 1638 | 15 |
1924793 | 1924793 | 2021-11-17 | Linn | Kansas | 20107 | 1638 | 21 |
1925469 | 1925469 | 2021-11-17 | Deer Lodge | Montana | 30023 | 1638 | 27 |
1903388 | 1903388 | 2021-11-10 | Forest | Pennsylvania | 42053 | 1638 | 25 |
1903506 | 1903506 | 2021-11-10 | Yabucoa | Puerto Rico | 72151 | 1638 | |
1900256 | 1900256 | 2021-11-09 | Yabucoa | Puerto Rico | 72151 | 1638 | |
1895171 | 1895171 | 2021-11-08 | Clearwater | Idaho | 16035 | 1638 | 26 |
1897006 | 1897006 | 2021-11-08 | Yabucoa | Puerto Rico | 72151 | 1638 | |
1891987 | 1891987 | 2021-11-07 | Jasper | Illinois | 17079 | 1638 | 23 |
1888737 | 1888737 | 2021-11-06 | Jasper | Illinois | 17079 | 1638 | 23 |
1885487 | 1885487 | 2021-11-05 | Jasper | Illinois | 17079 | 1638 | 23 |
1861189 | 1861189 | 2021-10-28 | Aguas Buenas | Puerto Rico | 72007 | 1638 | |
1857940 | 1857940 | 2021-10-27 | Aguas Buenas | Puerto Rico | 72007 | 1638 | |
1854691 | 1854691 | 2021-10-26 | Aguas Buenas | Puerto Rico | 72007 | 1638 | |
1851442 | 1851442 | 2021-10-25 | Aguas Buenas | Puerto Rico | 72007 | 1638 | |
1830438 | 1830438 | 2021-10-19 | Emmet | Iowa | 19063 | 1638 | 42 |
1830441 | 1830441 | 2021-10-19 | Franklin | Iowa | 19069 | 1638 | 28 |
1827189 | 1827189 | 2021-10-18 | Emmet | Iowa | 19063 | 1638 | 42 |
1827192 | 1827192 | 2021-10-18 | Franklin | Iowa | 19069 | 1638 | 28 |
1829157 | 1829157 | 2021-10-18 | Morris | Texas | 48343 | 1638 | 50 |
1823940 | 1823940 | 2021-10-17 | Emmet | Iowa | 19063 | 1638 | 42 |
1823943 | 1823943 | 2021-10-17 | Franklin | Iowa | 19069 | 1638 | 28 |
1825908 | 1825908 | 2021-10-17 | Morris | Texas | 48343 | 1638 | 50 |
1820691 | 1820691 | 2021-10-16 | Emmet | Iowa | 19063 | 1638 | 42 |
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);