ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
194 rows where cases = 2778 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 22
- Arkansas 13
- Texas 12
- Kentucky 9
- Colorado 8
- Minnesota 8
- Missouri 8
- South Carolina 8
- Tennessee 8
- Georgia 6
- Illinois 6
- Indiana 6
- North Carolina 6
- Puerto Rico 6
- Alabama 5
- Louisiana 5
- Ohio 5
- Mississippi 4
- Nevada 4
- Pennsylvania 4
- Florida 3
- Idaho 3
- Iowa 3
- New York 3
- Alaska 2
- Arizona 2
- Kansas 2
- Maryland 2
- New Mexico 2
- Virgin Islands 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499694 | 2499694 | 2022-05-13 | Chicot | Arkansas | 5017 | 2778 | 60 |
2496436 | 2496436 | 2022-05-12 | Chicot | Arkansas | 5017 | 2778 | 60 |
2493178 | 2493178 | 2022-05-11 | Chicot | Arkansas | 5017 | 2778 | 60 |
2495247 | 2495247 | 2022-05-11 | Haskell | Oklahoma | 40061 | 2778 | 41 |
2491989 | 2491989 | 2022-05-10 | Haskell | Oklahoma | 40061 | 2778 | 41 |
2488731 | 2488731 | 2022-05-09 | Haskell | Oklahoma | 40061 | 2778 | 41 |
2485474 | 2485474 | 2022-05-08 | Haskell | Oklahoma | 40061 | 2778 | 41 |
2482216 | 2482216 | 2022-05-07 | Haskell | Oklahoma | 40061 | 2778 | 41 |
2482428 | 2482428 | 2022-05-07 | Sabana Grande | Puerto Rico | 72121 | 2778 | |
2478958 | 2478958 | 2022-05-06 | Haskell | Oklahoma | 40061 | 2778 | 41 |
2475070 | 2475070 | 2022-05-05 | Lewis | Missouri | 29111 | 2778 | 36 |
2475700 | 2475700 | 2022-05-05 | Haskell | Oklahoma | 40061 | 2778 | 41 |
2475878 | 2475878 | 2022-05-05 | Florida | Puerto Rico | 72054 | 2778 | |
2475896 | 2475896 | 2022-05-05 | Luquillo | Puerto Rico | 72089 | 2778 | |
2472465 | 2472465 | 2022-05-04 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2469209 | 2469209 | 2022-05-03 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2465953 | 2465953 | 2022-05-02 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2462698 | 2462698 | 2022-05-01 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2459442 | 2459442 | 2022-04-30 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2456186 | 2456186 | 2022-04-29 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2452930 | 2452930 | 2022-04-28 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2449674 | 2449674 | 2022-04-27 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2446417 | 2446417 | 2022-04-26 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2443162 | 2443162 | 2022-04-25 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2439906 | 2439906 | 2022-04-24 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2436650 | 2436650 | 2022-04-23 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2433394 | 2433394 | 2022-04-22 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2430138 | 2430138 | 2022-04-21 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2374945 | 2374945 | 2022-04-04 | Comerio | Puerto Rico | 72045 | 2778 | |
2352244 | 2352244 | 2022-03-28 | Calhoun | South Carolina | 45017 | 2778 | 61 |
2346861 | 2346861 | 2022-03-27 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2348992 | 2348992 | 2022-03-27 | Calhoun | South Carolina | 45017 | 2778 | 61 |
2343608 | 2343608 | 2022-03-26 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2345739 | 2345739 | 2022-03-26 | Calhoun | South Carolina | 45017 | 2778 | 61 |
2340355 | 2340355 | 2022-03-25 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2342486 | 2342486 | 2022-03-25 | Calhoun | South Carolina | 45017 | 2778 | 61 |
2337096 | 2337096 | 2022-03-24 | Park | Colorado | 8093 | 2778 | 20 |
2339233 | 2339233 | 2022-03-24 | Calhoun | South Carolina | 45017 | 2778 | 61 |
2335979 | 2335979 | 2022-03-23 | Calhoun | South Carolina | 45017 | 2778 | 61 |
2332725 | 2332725 | 2022-03-22 | Calhoun | South Carolina | 45017 | 2778 | 61 |
2293959 | 2293959 | 2022-03-10 | Eastland | Texas | 48133 | 2778 | 111 |
2268589 | 2268589 | 2022-03-03 | Valdez-Cordova Census Area | Alaska | 2261 | 2778 | 16 |
2265336 | 2265336 | 2022-03-02 | Valdez-Cordova Census Area | Alaska | 2261 | 2778 | 16 |
2255879 | 2255879 | 2022-02-27 | Unknown | Florida | 2778 | 888 | |
2252628 | 2252628 | 2022-02-26 | Unknown | Florida | 2778 | 888 | |
2236303 | 2236303 | 2022-02-21 | Unknown | Connecticut | 2778 | 0 | |
2192366 | 2192366 | 2022-02-07 | Alleghany | North Carolina | 37005 | 2778 | 11 |
2170960 | 2170960 | 2022-02-01 | Coosa | Alabama | 1037 | 2778 | 52 |
2148146 | 2148146 | 2022-01-24 | Converse | Wyoming | 56009 | 2778 | 49 |
2142793 | 2142793 | 2022-01-23 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2142876 | 2142876 | 2022-01-23 | Kent | Maryland | 24029 | 2778 | 62 |
2139538 | 2139538 | 2022-01-22 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2136282 | 2136282 | 2022-01-21 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2123172 | 2123172 | 2022-01-17 | Fleming | Kentucky | 21069 | 2778 | 44 |
2119920 | 2119920 | 2022-01-16 | Fleming | Kentucky | 21069 | 2778 | 44 |
2116668 | 2116668 | 2022-01-15 | Fleming | Kentucky | 21069 | 2778 | 44 |
2113417 | 2113417 | 2022-01-14 | Fleming | Kentucky | 21069 | 2778 | 44 |
2099389 | 2099389 | 2022-01-10 | Cleburne | Alabama | 1029 | 2778 | 61 |
2102610 | 2102610 | 2022-01-10 | Goshen | Wyoming | 56015 | 2778 | 53 |
2073382 | 2073382 | 2022-01-02 | Crenshaw | Alabama | 1041 | 2778 | 79 |
2016563 | 2016563 | 2021-12-15 | Gage | Nebraska | 31067 | 2778 | 31 |
2009749 | 2009749 | 2021-12-13 | Renville | Minnesota | 27129 | 2778 | 51 |
1995497 | 1995497 | 2021-12-09 | Izard | Arkansas | 5065 | 2778 | 56 |
1998253 | 1998253 | 2021-12-09 | San Juan | Utah | 49037 | 2778 | 43 |
1986681 | 1986681 | 2021-12-06 | Mason | Kentucky | 21161 | 2778 | 75 |
1986957 | 1986957 | 2021-12-06 | Houston | Minnesota | 27055 | 2778 | 17 |
1982956 | 1982956 | 2021-12-05 | Bond | Illinois | 17005 | 2778 | 34 |
1979706 | 1979706 | 2021-12-04 | Bond | Illinois | 17005 | 2778 | 34 |
1976456 | 1976456 | 2021-12-03 | Bond | Illinois | 17005 | 2778 | 34 |
1970923 | 1970923 | 2021-12-01 | Morgan | Missouri | 29141 | 2778 | 73 |
1960991 | 1960991 | 2021-11-28 | Redwood | Minnesota | 27127 | 2778 | 45 |
1957740 | 1957740 | 2021-11-27 | Redwood | Minnesota | 27127 | 2778 | 45 |
1954489 | 1954489 | 2021-11-26 | Redwood | Minnesota | 27127 | 2778 | 45 |
1933050 | 1933050 | 2021-11-19 | Freestone | Texas | 48161 | 2778 | 71 |
1927717 | 1927717 | 2021-11-18 | Edgar | Illinois | 17045 | 2778 | 70 |
1929799 | 1929799 | 2021-11-18 | Freestone | Texas | 48161 | 2778 | 71 |
1882743 | 1882743 | 2021-11-04 | Jackson | Louisiana | 22049 | 2778 | 64 |
1879122 | 1879122 | 2021-11-03 | Rush | Indiana | 18139 | 2778 | 32 |
1876936 | 1876936 | 2021-11-02 | Roosevelt | New Mexico | 35041 | 2778 | 69 |
1872116 | 1872116 | 2021-11-01 | Elbert | Colorado | 8039 | 2778 | 23 |
1873674 | 1873674 | 2021-11-01 | Grant | New Mexico | 35017 | 2778 | 51 |
1857497 | 1857497 | 2021-10-27 | Seneca | New York | 36099 | 2778 | 63 |
1848601 | 1848601 | 2021-10-24 | Jackson | Texas | 48239 | 2778 | 50 |
1845351 | 1845351 | 2021-10-23 | Jackson | Texas | 48239 | 2778 | 50 |
1842101 | 1842101 | 2021-10-22 | Jackson | Texas | 48239 | 2778 | 50 |
1834983 | 1834983 | 2021-10-20 | Paulding | Ohio | 39125 | 2778 | 47 |
1828406 | 1828406 | 2021-10-18 | Rolette | North Dakota | 38079 | 2778 | 31 |
1825671 | 1825671 | 2021-10-17 | Grundy | Tennessee | 47061 | 2778 | 37 |
1822422 | 1822422 | 2021-10-16 | Grundy | Tennessee | 47061 | 2778 | 37 |
1819173 | 1819173 | 2021-10-15 | Grundy | Tennessee | 47061 | 2778 | 37 |
1810859 | 1810859 | 2021-10-13 | Jay | Indiana | 18075 | 2778 | 49 |
1808275 | 1808275 | 2021-10-12 | Wabasha | Minnesota | 27157 | 2778 | 5 |
1767814 | 1767814 | 2021-09-29 | Langlade | Wisconsin | 55067 | 2778 | 54 |
1764302 | 1764302 | 2021-09-28 | St. Croix | Virgin Islands | 78010 | 2778 | 24 |
1761053 | 1761053 | 2021-09-27 | St. Croix | Virgin Islands | 78010 | 2778 | 24 |
1735525 | 1735525 | 2021-09-20 | Grant | Arkansas | 5053 | 2778 | 47 |
1735527 | 1735527 | 2021-09-20 | Hempstead | Arkansas | 5057 | 2778 | 25 |
1722556 | 1722556 | 2021-09-16 | Polk | Arkansas | 5113 | 2778 | 95 |
1694240 | 1694240 | 2021-09-07 | Meade | Kentucky | 21163 | 2778 | 30 |
1696194 | 1696194 | 2021-09-07 | Russell | Virginia | 51167 | 2778 | 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);