ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where cases = 2402 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 19
- Texas 15
- Iowa 14
- Kentucky 12
- Illinois 10
- Puerto Rico 10
- Louisiana 9
- California 8
- Georgia 8
- Nebraska 8
- Ohio 7
- Missouri 6
- Tennessee 6
- Virginia 6
- Wisconsin 6
- Montana 5
- Alabama 4
- Kansas 4
- Mississippi 4
- Nevada 4
- Alaska 3
- Arkansas 3
- Indiana 3
- Michigan 3
- New York 3
- Florida 2
- North Dakota 2
- Oregon 2
- Pennsylvania 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476282 | 2476282 | 2022-05-05 | La Salle | Texas | 48283 | 2402 | 48 |
2399504 | 2399504 | 2022-04-12 | Sac | Iowa | 19161 | 2402 | 32 |
2396248 | 2396248 | 2022-04-11 | Sac | Iowa | 19161 | 2402 | 32 |
2392993 | 2392993 | 2022-04-10 | Sac | Iowa | 19161 | 2402 | 32 |
2389737 | 2389737 | 2022-04-09 | Sac | Iowa | 19161 | 2402 | 32 |
2386481 | 2386481 | 2022-04-08 | Sac | Iowa | 19161 | 2402 | 32 |
2383227 | 2383227 | 2022-04-07 | Sac | Iowa | 19161 | 2402 | 32 |
2379972 | 2379972 | 2022-04-06 | Sac | Iowa | 19161 | 2402 | 32 |
2337410 | 2337410 | 2022-03-24 | Brown | Illinois | 17009 | 2402 | 21 |
2193873 | 2193873 | 2022-02-08 | Perry | Arkansas | 5105 | 2402 | 30 |
2193100 | 2193100 | 2022-02-07 | Blanco | Texas | 48031 | 2402 | 30 |
2178156 | 2178156 | 2022-02-03 | Benton | Indiana | 18007 | 2402 | 21 |
2155646 | 2155646 | 2022-01-27 | Rice | Kansas | 20159 | 2402 | 17 |
2152393 | 2152393 | 2022-01-26 | Rice | Kansas | 20159 | 2402 | 17 |
2152972 | 2152972 | 2022-01-26 | Lewis | Missouri | 29111 | 2402 | 31 |
2148980 | 2148980 | 2022-01-25 | Chickasaw | Iowa | 19037 | 2402 | 28 |
2145728 | 2145728 | 2022-01-24 | Chickasaw | Iowa | 19037 | 2402 | 28 |
2142473 | 2142473 | 2022-01-23 | Chickasaw | Iowa | 19037 | 2402 | 28 |
2139218 | 2139218 | 2022-01-22 | Chickasaw | Iowa | 19037 | 2402 | 28 |
2135962 | 2135962 | 2022-01-21 | Chickasaw | Iowa | 19037 | 2402 | 28 |
2132710 | 2132710 | 2022-01-20 | Chickasaw | Iowa | 19037 | 2402 | 28 |
2129457 | 2129457 | 2022-01-19 | Chickasaw | Iowa | 19037 | 2402 | 28 |
2107535 | 2107535 | 2022-01-12 | Roosevelt | Montana | 30085 | 2402 | 70 |
2097343 | 2097343 | 2022-01-09 | Kent | Maryland | 24029 | 2402 | 60 |
2083199 | 2083199 | 2022-01-05 | Nome Census Area | Alaska | 2180 | 2402 | 3 |
2084648 | 2084648 | 2022-01-05 | Dent | Missouri | 29065 | 2402 | 64 |
2079947 | 2079947 | 2022-01-04 | Nome Census Area | Alaska | 2180 | 2402 | 3 |
2076695 | 2076695 | 2022-01-03 | Nome Census Area | Alaska | 2180 | 2402 | 3 |
2061843 | 2061843 | 2021-12-29 | Tallahatchie | Mississippi | 28135 | 2402 | 53 |
2056672 | 2056672 | 2021-12-27 | Pecos | Texas | 48371 | 2402 | 58 |
2040089 | 2040089 | 2021-12-22 | Clay | South Dakota | 46027 | 2402 | 17 |
1998335 | 1998335 | 2021-12-09 | Greene | Virginia | 51079 | 2402 | 45 |
1994030 | 1994030 | 2021-12-08 | Chowan | North Carolina | 37041 | 2402 | 43 |
1990779 | 1990779 | 2021-12-07 | Chowan | North Carolina | 37041 | 2402 | 43 |
1980661 | 1980661 | 2021-12-04 | Macon | Missouri | 29121 | 2402 | 34 |
1981481 | 1981481 | 2021-12-04 | Manati | Puerto Rico | 72091 | 2402 | |
1960675 | 1960675 | 2021-11-28 | Magoffin | Kentucky | 21153 | 2402 | 26 |
1961350 | 1961350 | 2021-11-28 | Seward | Nebraska | 31159 | 2402 | 38 |
1957424 | 1957424 | 2021-11-27 | Magoffin | Kentucky | 21153 | 2402 | 26 |
1958099 | 1958099 | 2021-11-27 | Seward | Nebraska | 31159 | 2402 | 38 |
1954173 | 1954173 | 2021-11-26 | Magoffin | Kentucky | 21153 | 2402 | 26 |
1954848 | 1954848 | 2021-11-26 | Seward | Nebraska | 31159 | 2402 | 38 |
1950922 | 1950922 | 2021-11-25 | Magoffin | Kentucky | 21153 | 2402 | 26 |
1951597 | 1951597 | 2021-11-25 | Seward | Nebraska | 31159 | 2402 | 38 |
1947671 | 1947671 | 2021-11-24 | Magoffin | Kentucky | 21153 | 2402 | 26 |
1948346 | 1948346 | 2021-11-24 | Seward | Nebraska | 31159 | 2402 | 38 |
1941726 | 1941726 | 2021-11-22 | Glacier | Montana | 30035 | 2402 | 60 |
1938824 | 1938824 | 2021-11-21 | Polk | North Carolina | 37149 | 2402 | 49 |
1935574 | 1935574 | 2021-11-20 | Polk | North Carolina | 37149 | 2402 | 49 |
1935650 | 1935650 | 2021-11-20 | Walsh | North Dakota | 38099 | 2402 | 29 |
1932324 | 1932324 | 2021-11-19 | Polk | North Carolina | 37149 | 2402 | 49 |
1915858 | 1915858 | 2021-11-14 | York | Nebraska | 31185 | 2402 | 19 |
1912608 | 1912608 | 2021-11-13 | York | Nebraska | 31185 | 2402 | 19 |
1909358 | 1909358 | 2021-11-12 | York | Nebraska | 31185 | 2402 | 19 |
1855253 | 1855253 | 2021-10-26 | San Juan | Utah | 49037 | 2402 | 41 |
1838505 | 1838505 | 2021-10-21 | San Lorenzo | Puerto Rico | 72129 | 2402 | |
1835256 | 1835256 | 2021-10-20 | San Lorenzo | Puerto Rico | 72129 | 2402 | |
1829751 | 1829751 | 2021-10-19 | Howard | Arkansas | 5061 | 2402 | 35 |
1824884 | 1824884 | 2021-10-17 | Humboldt | Nevada | 32013 | 2402 | 25 |
1821635 | 1821635 | 2021-10-16 | Humboldt | Nevada | 32013 | 2402 | 25 |
1818386 | 1818386 | 2021-10-15 | Humboldt | Nevada | 32013 | 2402 | 25 |
1814268 | 1814268 | 2021-10-14 | Bourbon | Kansas | 20011 | 2402 | 41 |
1811019 | 1811019 | 2021-10-13 | Bourbon | Kansas | 20011 | 2402 | 41 |
1804245 | 1804245 | 2021-10-11 | Ford | Illinois | 17053 | 2402 | 66 |
1800996 | 1800996 | 2021-10-10 | Ford | Illinois | 17053 | 2402 | 66 |
1797747 | 1797747 | 2021-10-09 | Ford | Illinois | 17053 | 2402 | 66 |
1794498 | 1794498 | 2021-10-08 | Ford | Illinois | 17053 | 2402 | 66 |
1786238 | 1786238 | 2021-10-05 | Meigs | Ohio | 39105 | 2402 | 45 |
1783110 | 1783110 | 2021-10-04 | Crook | Oregon | 41013 | 2402 | 40 |
1770258 | 1770258 | 2021-09-30 | Moca | Puerto Rico | 72099 | 2402 | |
1767009 | 1767009 | 2021-09-29 | Moca | Puerto Rico | 72099 | 2402 | |
1747466 | 1747466 | 2021-09-23 | Wyoming | Pennsylvania | 42131 | 2402 | 55 |
1742927 | 1742927 | 2021-09-22 | Garrard | Kentucky | 21079 | 2402 | 40 |
1741306 | 1741306 | 2021-09-21 | Colorado | Texas | 48089 | 2402 | 44 |
1735355 | 1735355 | 2021-09-19 | Vernon | Wisconsin | 55123 | 2402 | 51 |
1732105 | 1732105 | 2021-09-18 | Vernon | Wisconsin | 55123 | 2402 | 51 |
1728855 | 1728855 | 2021-09-17 | Vernon | Wisconsin | 55123 | 2402 | 51 |
1721671 | 1721671 | 2021-09-15 | Benton | Tennessee | 47005 | 2402 | 44 |
1718835 | 1718835 | 2021-09-14 | Buckingham | Virginia | 51029 | 2402 | 34 |
1697972 | 1697972 | 2021-09-08 | Moniteau | Missouri | 29135 | 2402 | 37 |
1691860 | 1691860 | 2021-09-06 | Hertford | North Carolina | 37091 | 2402 | 65 |
1688610 | 1688610 | 2021-09-05 | Hertford | North Carolina | 37091 | 2402 | 65 |
1683542 | 1683542 | 2021-09-04 | Franklin | Arkansas | 5047 | 2402 | 46 |
1685360 | 1685360 | 2021-09-04 | Hertford | North Carolina | 37091 | 2402 | 65 |
1682109 | 1682109 | 2021-09-03 | Hertford | North Carolina | 37091 | 2402 | 65 |
1677585 | 1677585 | 2021-09-02 | Pike | Illinois | 17149 | 2402 | 58 |
1673151 | 1673151 | 2021-08-31 | Houston | Texas | 48225 | 2402 | 63 |
1655940 | 1655940 | 2021-08-26 | Churchill | Nevada | 32001 | 2402 | 49 |
1623062 | 1623062 | 2021-08-16 | Martin | Minnesota | 27091 | 2402 | 33 |
1617346 | 1617346 | 2021-08-14 | Wyandot | Ohio | 39175 | 2402 | 57 |
1609898 | 1609898 | 2021-08-12 | Somerset | Maine | 23025 | 2402 | 34 |
1602693 | 1602693 | 2021-08-10 | Mitchell | Georgia | 13205 | 2402 | 85 |
1592647 | 1592647 | 2021-08-07 | Colusa | California | 6011 | 2402 | 18 |
1589398 | 1589398 | 2021-08-06 | Colusa | California | 6011 | 2402 | 18 |
1586491 | 1586491 | 2021-08-05 | Union | Georgia | 13291 | 2402 | 85 |
1561931 | 1561931 | 2021-07-28 | Martin | North Carolina | 37117 | 2402 | 46 |
1557987 | 1557987 | 2021-07-27 | Emmet | Michigan | 26047 | 2402 | 43 |
1491587 | 1491587 | 2021-07-06 | Waynesboro city | Virginia | 51820 | 2402 | 38 |
1462801 | 1462801 | 2021-06-28 | Siskiyou | California | 6093 | 2402 | 38 |
1459556 | 1459556 | 2021-06-27 | Siskiyou | California | 6093 | 2402 | 38 |
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);