ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
201 rows where cases = 2403 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 17
- Puerto Rico 13
- Virginia 13
- Texas 12
- Alaska 10
- Missouri 10
- Louisiana 9
- Mississippi 8
- Ohio 8
- Georgia 7
- Indiana 7
- Rhode Island 7
- California 6
- West Virginia 6
- Illinois 5
- Kentucky 5
- Minnesota 5
- South Carolina 5
- Wisconsin 4
- Alabama 3
- Colorado 3
- Maryland 3
- Nebraska 3
- New York 3
- Pennsylvania 3
- Tennessee 3
- Washington 3
- Iowa 2
- Maine 2
- Michigan 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469397 | 2469397 | 2022-05-03 | Rincon | Puerto Rico | 72117 | 2403 | |
2347169 | 2347169 | 2022-03-27 | Brown | Illinois | 17009 | 2403 | 21 |
2343916 | 2343916 | 2022-03-26 | Brown | Illinois | 17009 | 2403 | 21 |
2340663 | 2340663 | 2022-03-25 | Brown | Illinois | 17009 | 2403 | 21 |
2291157 | 2291157 | 2022-03-09 | Ritchie | West Virginia | 54085 | 2403 | 30 |
2287905 | 2287905 | 2022-03-08 | Ritchie | West Virginia | 54085 | 2403 | 30 |
2262483 | 2262483 | 2022-03-01 | McIntosh | Georgia | 13191 | 2403 | 35 |
2222586 | 2222586 | 2022-02-16 | Trinity | Texas | 48455 | 2403 | 70 |
2190292 | 2190292 | 2022-02-06 | Pend Oreille | Washington | 53051 | 2403 | 29 |
2187039 | 2187039 | 2022-02-05 | Pend Oreille | Washington | 53051 | 2403 | 29 |
2183786 | 2183786 | 2022-02-04 | Pend Oreille | Washington | 53051 | 2403 | 29 |
2177169 | 2177169 | 2022-02-02 | Franklin city | Virginia | 51620 | 2403 | 43 |
2168286 | 2168286 | 2022-01-31 | Shoshone | Idaho | 16079 | 2403 | 71 |
2124492 | 2124492 | 2022-01-17 | Comerio | Puerto Rico | 72045 | 2403 | |
2121576 | 2121576 | 2022-01-16 | Duval | Texas | 48131 | 2403 | 62 |
2104204 | 2104204 | 2022-01-11 | Pemiscot | Missouri | 29155 | 2403 | 59 |
2104663 | 2104663 | 2022-01-11 | Mountrail | North Dakota | 38061 | 2403 | 32 |
2081115 | 2081115 | 2022-01-04 | Arenac | Michigan | 26011 | 2403 | 51 |
2076895 | 2076895 | 2022-01-03 | Las Animas | Colorado | 8071 | 2403 | 33 |
2077863 | 2077863 | 2022-01-03 | Arenac | Michigan | 26011 | 2403 | 51 |
2079224 | 2079224 | 2022-01-03 | Stewart | Tennessee | 47161 | 2403 | 44 |
2073446 | 2073446 | 2022-01-02 | Northwest Arctic Borough | Alaska | 2188 | 2403 | 9 |
2070195 | 2070195 | 2022-01-01 | Northwest Arctic Borough | Alaska | 2188 | 2403 | 9 |
2066944 | 2066944 | 2021-12-31 | Northwest Arctic Borough | Alaska | 2188 | 2403 | 9 |
2063694 | 2063694 | 2021-12-30 | Northwest Arctic Borough | Alaska | 2188 | 2403 | 9 |
2060444 | 2060444 | 2021-12-29 | Northwest Arctic Borough | Alaska | 2188 | 2403 | 9 |
2050692 | 2050692 | 2021-12-26 | Kusilvak Census Area | Alaska | 2158 | 2403 | 9 |
2047442 | 2047442 | 2021-12-25 | Kusilvak Census Area | Alaska | 2158 | 2403 | 9 |
2044192 | 2044192 | 2021-12-24 | Kusilvak Census Area | Alaska | 2158 | 2403 | 9 |
2040943 | 2040943 | 2021-12-23 | Kusilvak Census Area | Alaska | 2158 | 2403 | 9 |
2037693 | 2037693 | 2021-12-22 | Kusilvak Census Area | Alaska | 2158 | 2403 | 9 |
2012952 | 2012952 | 2021-12-14 | Cottonwood | Minnesota | 27033 | 2403 | 33 |
2007033 | 2007033 | 2021-12-12 | Chowan | North Carolina | 37041 | 2403 | 44 |
2003782 | 2003782 | 2021-12-11 | Chowan | North Carolina | 37041 | 2403 | 44 |
2000531 | 2000531 | 2021-12-10 | Chowan | North Carolina | 37041 | 2403 | 44 |
1978984 | 1978984 | 2021-12-03 | Morgan | West Virginia | 54065 | 2403 | 50 |
1973796 | 1973796 | 2021-12-02 | Knox | Maine | 23013 | 2403 | 16 |
1969044 | 1969044 | 2021-11-30 | Bristol city | Virginia | 51520 | 2403 | 50 |
1925403 | 1925403 | 2021-11-17 | Madison | Missouri | 29123 | 2403 | 27 |
1926229 | 1926229 | 2021-11-17 | Naranjito | Puerto Rico | 72105 | 2403 | |
1922979 | 1922979 | 2021-11-16 | Naranjito | Puerto Rico | 72105 | 2403 | |
1919730 | 1919730 | 2021-11-15 | Naranjito | Puerto Rico | 72105 | 2403 | |
1915590 | 1915590 | 2021-11-14 | Yalobusha | Mississippi | 28161 | 2403 | 47 |
1912340 | 1912340 | 2021-11-13 | Yalobusha | Mississippi | 28161 | 2403 | 47 |
1909090 | 1909090 | 2021-11-12 | Yalobusha | Mississippi | 28161 | 2403 | 47 |
1905111 | 1905111 | 2021-11-11 | Parke | Indiana | 18121 | 2403 | 31 |
1882206 | 1882206 | 2021-11-04 | Carroll | Illinois | 17015 | 2403 | 40 |
1858547 | 1858547 | 2021-10-27 | Buchanan | Virginia | 51027 | 2403 | 60 |
1855470 | 1855470 | 2021-10-26 | Hardy | West Virginia | 54031 | 2403 | 30 |
1834605 | 1834605 | 2021-10-20 | Saline | Nebraska | 31151 | 2403 | 6 |
1819876 | 1819876 | 2021-10-16 | Clay | Alabama | 1027 | 2403 | 67 |
1813770 | 1813770 | 2021-10-14 | Brooks | Georgia | 13027 | 2403 | 67 |
1803010 | 1803010 | 2021-10-10 | Bosque | Texas | 48035 | 2403 | 52 |
1799761 | 1799761 | 2021-10-09 | Bosque | Texas | 48035 | 2403 | 52 |
1793422 | 1793422 | 2021-10-07 | Nolan | Texas | 48353 | 2403 | 71 |
1786893 | 1786893 | 2021-10-05 | Leon | Texas | 48289 | 2403 | 61 |
1776758 | 1776758 | 2021-10-02 | Moca | Puerto Rico | 72099 | 2403 | |
1773508 | 1773508 | 2021-10-01 | Moca | Puerto Rico | 72099 | 2403 | |
1765251 | 1765251 | 2021-09-29 | Edgar | Illinois | 17045 | 2403 | 65 |
1762773 | 1762773 | 2021-09-28 | Roseau | Minnesota | 27135 | 2403 | 24 |
1763711 | 1763711 | 2021-09-28 | Aguada | Puerto Rico | 72003 | 2403 | |
1760462 | 1760462 | 2021-09-27 | Aguada | Puerto Rico | 72003 | 2403 | |
1757214 | 1757214 | 2021-09-26 | Aguada | Puerto Rico | 72003 | 2403 | |
1740608 | 1740608 | 2021-09-21 | Northampton | North Carolina | 37131 | 2403 | 62 |
1740761 | 1740761 | 2021-09-21 | Paulding | Ohio | 39125 | 2403 | 43 |
1724281 | 1724281 | 2021-09-16 | Seneca | New York | 36099 | 2403 | 58 |
1724968 | 1724968 | 2021-09-16 | Lewis | Tennessee | 47101 | 2403 | 31 |
1711766 | 1711766 | 2021-09-12 | Isabela | Puerto Rico | 72071 | 2403 | |
1701565 | 1701565 | 2021-09-09 | Avery | North Carolina | 37011 | 2403 | 26 |
1658981 | 1658981 | 2021-08-27 | Livingston | Missouri | 29117 | 2403 | 56 |
1642609 | 1642609 | 2021-08-22 | Clay | Mississippi | 28025 | 2403 | 56 |
1639359 | 1639359 | 2021-08-21 | Clay | Mississippi | 28025 | 2403 | 56 |
1636109 | 1636109 | 2021-08-20 | Clay | Mississippi | 28025 | 2403 | 56 |
1625078 | 1625078 | 2021-08-17 | Hempstead | Arkansas | 5057 | 2403 | 20 |
1624729 | 1624729 | 2021-08-16 | Salem city | Virginia | 51775 | 2403 | 50 |
1596913 | 1596913 | 2021-08-08 | Caroline | Maryland | 24011 | 2403 | 30 |
1577694 | 1577694 | 2021-08-02 | Tishomingo | Mississippi | 28141 | 2403 | 70 |
1563960 | 1563960 | 2021-07-29 | Jennings | Indiana | 18079 | 2403 | 51 |
1535399 | 1535399 | 2021-07-20 | Waseca | Minnesota | 27161 | 2403 | 23 |
1529488 | 1529488 | 2021-07-18 | Transylvania | North Carolina | 37175 | 2403 | 33 |
1526241 | 1526241 | 2021-07-17 | Transylvania | North Carolina | 37175 | 2403 | 33 |
1522994 | 1522994 | 2021-07-16 | Transylvania | North Carolina | 37175 | 2403 | 33 |
1515582 | 1515582 | 2021-07-14 | Marion | Kentucky | 21155 | 2403 | 38 |
1507112 | 1507112 | 2021-07-11 | Canovanas | Puerto Rico | 72029 | 2403 | |
1497272 | 1497272 | 2021-07-08 | Jefferson | Oregon | 41031 | 2403 | 42 |
1494025 | 1494025 | 2021-07-07 | Jefferson | Oregon | 41031 | 2403 | 42 |
1488340 | 1488340 | 2021-07-05 | Waynesboro city | Virginia | 51820 | 2403 | 38 |
1485093 | 1485093 | 2021-07-04 | Waynesboro city | Virginia | 51820 | 2403 | 38 |
1481847 | 1481847 | 2021-07-03 | Waynesboro city | Virginia | 51820 | 2403 | 38 |
1475354 | 1475354 | 2021-07-01 | Waynesboro city | Virginia | 51820 | 2403 | 38 |
1472108 | 1472108 | 2021-06-30 | Waynesboro city | Virginia | 51820 | 2403 | 38 |
1447411 | 1447411 | 2021-06-23 | Lincoln | Kentucky | 21137 | 2403 | 59 |
1444166 | 1444166 | 2021-06-22 | Lincoln | Kentucky | 21137 | 2403 | 59 |
1406233 | 1406233 | 2021-06-10 | Gallia | Ohio | 39053 | 2403 | 50 |
1402987 | 1402987 | 2021-06-09 | Gallia | Ohio | 39053 | 2403 | 50 |
1373683 | 1373683 | 2021-05-31 | Transylvania | North Carolina | 37175 | 2403 | 33 |
1370438 | 1370438 | 2021-05-30 | Transylvania | North Carolina | 37175 | 2403 | 33 |
1367192 | 1367192 | 2021-05-29 | Transylvania | North Carolina | 37175 | 2403 | 33 |
1363946 | 1363946 | 2021-05-28 | Transylvania | North Carolina | 37175 | 2403 | 33 |
1341289 | 1341289 | 2021-05-21 | Adams | Ohio | 39001 | 2403 | 54 |
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);