ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
237 rows where cases = 2507 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23
- Oklahoma 22
- Iowa 17
- Florida 16
- Georgia 12
- Kansas 12
- Virginia 11
- Indiana 10
- Louisiana 9
- Missouri 7
- Nevada 7
- Washington 7
- Montana 6
- Tennessee 6
- Alabama 5
- Arkansas 5
- Idaho 5
- Puerto Rico 5
- Wisconsin 5
- Kentucky 4
- Minnesota 4
- Mississippi 4
- Nebraska 4
- North Carolina 4
- Ohio 4
- Arizona 3
- Wyoming 3
- Maryland 2
- Michigan 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499935 | 2499935 | 2022-05-13 | Liberty | Florida | 12077 | 2507 | 30 |
2496677 | 2496677 | 2022-05-12 | Liberty | Florida | 12077 | 2507 | 30 |
2499410 | 2499410 | 2022-05-12 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2493419 | 2493419 | 2022-05-11 | Liberty | Florida | 12077 | 2507 | 30 |
2496152 | 2496152 | 2022-05-11 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2490161 | 2490161 | 2022-05-10 | Liberty | Florida | 12077 | 2507 | 30 |
2492894 | 2492894 | 2022-05-10 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2486904 | 2486904 | 2022-05-09 | Liberty | Florida | 12077 | 2507 | 30 |
2489636 | 2489636 | 2022-05-09 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2483646 | 2483646 | 2022-05-08 | Liberty | Florida | 12077 | 2507 | 30 |
2480388 | 2480388 | 2022-05-07 | Liberty | Florida | 12077 | 2507 | 30 |
2477130 | 2477130 | 2022-05-06 | Liberty | Florida | 12077 | 2507 | 30 |
2472649 | 2472649 | 2022-05-04 | Patillas | Puerto Rico | 72109 | 2507 | |
2443908 | 2443908 | 2022-04-25 | Charlotte | Virginia | 51037 | 2507 | 46 |
2351444 | 2351444 | 2022-03-28 | Fergus | Montana | 30027 | 2507 | 54 |
2352671 | 2352671 | 2022-03-28 | Trinity | Texas | 48455 | 2507 | 72 |
2348192 | 2348192 | 2022-03-27 | Fergus | Montana | 30027 | 2507 | 54 |
2349419 | 2349419 | 2022-03-27 | Trinity | Texas | 48455 | 2507 | 72 |
2344939 | 2344939 | 2022-03-26 | Fergus | Montana | 30027 | 2507 | 54 |
2346166 | 2346166 | 2022-03-26 | Trinity | Texas | 48455 | 2507 | 72 |
2341686 | 2341686 | 2022-03-25 | Fergus | Montana | 30027 | 2507 | 54 |
2338433 | 2338433 | 2022-03-24 | Fergus | Montana | 30027 | 2507 | 54 |
2335179 | 2335179 | 2022-03-23 | Fergus | Montana | 30027 | 2507 | 54 |
2332069 | 2332069 | 2022-03-22 | Humboldt | Nevada | 32013 | 2507 | 53 |
2327207 | 2327207 | 2022-03-21 | Perry | Arkansas | 5105 | 2507 | 37 |
2328816 | 2328816 | 2022-03-21 | Humboldt | Nevada | 32013 | 2507 | 53 |
2323954 | 2323954 | 2022-03-20 | Perry | Arkansas | 5105 | 2507 | 37 |
2325564 | 2325564 | 2022-03-20 | Humboldt | Nevada | 32013 | 2507 | 53 |
2322310 | 2322310 | 2022-03-19 | Humboldt | Nevada | 32013 | 2507 | 53 |
2319056 | 2319056 | 2022-03-18 | Humboldt | Nevada | 32013 | 2507 | 53 |
2315803 | 2315803 | 2022-03-17 | Humboldt | Nevada | 32013 | 2507 | 53 |
2316830 | 2316830 | 2022-03-17 | Morris | Texas | 48343 | 2507 | 71 |
2312550 | 2312550 | 2022-03-16 | Humboldt | Nevada | 32013 | 2507 | 53 |
2287404 | 2287404 | 2022-03-08 | Blanco | Texas | 48031 | 2507 | 33 |
2243206 | 2243206 | 2022-02-23 | Crawford | Indiana | 18025 | 2507 | 35 |
2241422 | 2241422 | 2022-02-22 | Hughes | Oklahoma | 40063 | 2507 | 53 |
2238171 | 2238171 | 2022-02-21 | Hughes | Oklahoma | 40063 | 2507 | 53 |
2234920 | 2234920 | 2022-02-20 | Hughes | Oklahoma | 40063 | 2507 | 53 |
2231669 | 2231669 | 2022-02-19 | Hughes | Oklahoma | 40063 | 2507 | 53 |
2228418 | 2228418 | 2022-02-18 | Hughes | Oklahoma | 40063 | 2507 | 53 |
2225167 | 2225167 | 2022-02-17 | Hughes | Oklahoma | 40063 | 2507 | 53 |
2221916 | 2221916 | 2022-02-16 | Hughes | Oklahoma | 40063 | 2507 | 53 |
2210932 | 2210932 | 2022-02-13 | Marshall | Kansas | 20117 | 2507 | 40 |
2212935 | 2212935 | 2022-02-13 | Clarke | Virginia | 51043 | 2507 | 38 |
2207679 | 2207679 | 2022-02-12 | Marshall | Kansas | 20117 | 2507 | 40 |
2209682 | 2209682 | 2022-02-12 | Clarke | Virginia | 51043 | 2507 | 38 |
2204426 | 2204426 | 2022-02-11 | Marshall | Kansas | 20117 | 2507 | 40 |
2206429 | 2206429 | 2022-02-11 | Clarke | Virginia | 51043 | 2507 | 38 |
2201173 | 2201173 | 2022-02-10 | Marshall | Kansas | 20117 | 2507 | 40 |
2197919 | 2197919 | 2022-02-09 | Marshall | Kansas | 20117 | 2507 | 40 |
2194520 | 2194520 | 2022-02-08 | Calhoun | Iowa | 19025 | 2507 | 21 |
2194793 | 2194793 | 2022-02-08 | McLean | Kentucky | 21149 | 2507 | 44 |
2195940 | 2195940 | 2022-02-08 | Washita | Oklahoma | 40149 | 2507 | 38 |
2191266 | 2191266 | 2022-02-07 | Calhoun | Iowa | 19025 | 2507 | 21 |
2192686 | 2192686 | 2022-02-07 | Washita | Oklahoma | 40149 | 2507 | 38 |
2188013 | 2188013 | 2022-02-06 | Calhoun | Iowa | 19025 | 2507 | 21 |
2189432 | 2189432 | 2022-02-06 | Washita | Oklahoma | 40149 | 2507 | 38 |
2184760 | 2184760 | 2022-02-05 | Calhoun | Iowa | 19025 | 2507 | 21 |
2186179 | 2186179 | 2022-02-05 | Washita | Oklahoma | 40149 | 2507 | 38 |
2181508 | 2181508 | 2022-02-04 | Calhoun | Iowa | 19025 | 2507 | 21 |
2182927 | 2182927 | 2022-02-04 | Washita | Oklahoma | 40149 | 2507 | 38 |
2178257 | 2178257 | 2022-02-03 | Calhoun | Iowa | 19025 | 2507 | 21 |
2179675 | 2179675 | 2022-02-03 | Washita | Oklahoma | 40149 | 2507 | 38 |
2175004 | 2175004 | 2022-02-02 | Calhoun | Iowa | 19025 | 2507 | 21 |
2176424 | 2176424 | 2022-02-02 | Washita | Oklahoma | 40149 | 2507 | 38 |
2149576 | 2149576 | 2022-01-25 | Watonwan | Minnesota | 27165 | 2507 | 22 |
2121577 | 2121577 | 2022-01-16 | Eastland | Texas | 48133 | 2507 | 91 |
2073545 | 2073545 | 2022-01-02 | Van Buren | Arkansas | 5141 | 2507 | 45 |
2063270 | 2063270 | 2021-12-29 | Addison | Vermont | 50001 | 2507 | 10 |
2041217 | 2041217 | 2021-12-23 | Jefferson | Florida | 12065 | 2507 | 36 |
2037967 | 2037967 | 2021-12-22 | Jefferson | Florida | 12065 | 2507 | 36 |
2034717 | 2034717 | 2021-12-21 | Jefferson | Florida | 12065 | 2507 | 36 |
2031467 | 2031467 | 2021-12-20 | Jefferson | Florida | 12065 | 2507 | 36 |
2033748 | 2033748 | 2021-12-20 | Bandera | Texas | 48019 | 2507 | 64 |
2028216 | 2028216 | 2021-12-19 | Jefferson | Florida | 12065 | 2507 | 36 |
2030839 | 2030839 | 2021-12-19 | Giles | Virginia | 51071 | 2507 | 35 |
2024965 | 2024965 | 2021-12-18 | Jefferson | Florida | 12065 | 2507 | 36 |
2027588 | 2027588 | 2021-12-18 | Giles | Virginia | 51071 | 2507 | 35 |
2021714 | 2021714 | 2021-12-17 | Jefferson | Florida | 12065 | 2507 | 36 |
2024337 | 2024337 | 2021-12-17 | Giles | Virginia | 51071 | 2507 | 35 |
2003382 | 2003382 | 2021-12-11 | Dallas | Missouri | 29059 | 2507 | 57 |
2004710 | 2004710 | 2021-12-11 | Tyler | Texas | 48457 | 2507 | 73 |
2001248 | 2001248 | 2021-12-10 | Bosque | Texas | 48035 | 2507 | 57 |
1998125 | 1998125 | 2021-12-09 | Leon | Texas | 48289 | 2507 | 71 |
1967607 | 1967607 | 2021-11-30 | Bates | Missouri | 29013 | 2507 | 57 |
1944363 | 1944363 | 2021-11-23 | Caldwell | Kentucky | 21033 | 2507 | 51 |
1939623 | 1939623 | 2021-11-21 | Madison | Texas | 48313 | 2507 | 45 |
1936373 | 1936373 | 2021-11-20 | Madison | Texas | 48313 | 2507 | 45 |
1930356 | 1930356 | 2021-11-19 | Clay | Alabama | 1027 | 2507 | 69 |
1926622 | 1926622 | 2021-11-17 | Madison | Texas | 48313 | 2507 | 45 |
1915222 | 1915222 | 2021-11-14 | Bienville | Louisiana | 22013 | 2507 | 99 |
1911972 | 1911972 | 2021-11-13 | Bienville | Louisiana | 22013 | 2507 | 99 |
1908723 | 1908723 | 2021-11-12 | Bienville | Louisiana | 22013 | 2507 | 99 |
1895710 | 1895710 | 2021-11-08 | Union | Kentucky | 21225 | 2507 | 35 |
1881611 | 1881611 | 2021-11-04 | Cleburne | Alabama | 1029 | 2507 | 60 |
1836501 | 1836501 | 2021-10-21 | Bacon | Georgia | 13005 | 2507 | 58 |
1824816 | 1824816 | 2021-10-17 | Gage | Nebraska | 31067 | 2507 | 27 |
1821567 | 1821567 | 2021-10-16 | Gage | Nebraska | 31067 | 2507 | 27 |
1818318 | 1818318 | 2021-10-15 | Gage | Nebraska | 31067 | 2507 | 27 |
1810181 | 1810181 | 2021-10-13 | Washington | Alabama | 1129 | 2507 | 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);