ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
150 rows where cases = 4054 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 17
- Virginia 10
- Illinois 9
- Indiana 8
- Oklahoma 8
- Texas 8
- West Virginia 7
- Minnesota 6
- Michigan 5
- Mississippi 5
- Ohio 5
- Wisconsin 5
- Alabama 4
- Florida 4
- Kentucky 4
- Louisiana 4
- Missouri 4
- Tennessee 4
- Alaska 3
- Montana 3
- Puerto Rico 3
- Idaho 2
- Maryland 2
- New Jersey 2
- New Mexico 2
- New York 2
- North Carolina 2
- Pennsylvania 2
- South Carolina 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486272 | 2486272 | 2022-05-08 | Grayson | Virginia | 51077 | 4054 | 83 |
2483014 | 2483014 | 2022-05-07 | Grayson | Virginia | 51077 | 4054 | 83 |
2479655 | 2479655 | 2022-05-06 | Zavala | Texas | 48507 | 4054 | 68 |
2479756 | 2479756 | 2022-05-06 | Grayson | Virginia | 51077 | 4054 | 83 |
2466728 | 2466728 | 2022-05-02 | Grayson | Virginia | 51077 | 4054 | 82 |
2408118 | 2408118 | 2022-04-14 | Giles | Virginia | 51071 | 4054 | 49 |
2404862 | 2404862 | 2022-04-13 | Giles | Virginia | 51071 | 4054 | 49 |
2347234 | 2347234 | 2022-03-27 | Moultrie | Illinois | 17139 | 4054 | 52 |
2343981 | 2343981 | 2022-03-26 | Moultrie | Illinois | 17139 | 4054 | 52 |
2340728 | 2340728 | 2022-03-25 | Moultrie | Illinois | 17139 | 4054 | 52 |
2337475 | 2337475 | 2022-03-24 | Moultrie | Illinois | 17139 | 4054 | 52 |
2334221 | 2334221 | 2022-03-23 | Moultrie | Illinois | 17139 | 4054 | 52 |
2269533 | 2269533 | 2022-03-03 | Estill | Kentucky | 21065 | 4054 | 42 |
2257141 | 2257141 | 2022-02-27 | Park | Montana | 30067 | 4054 | 34 |
2253890 | 2253890 | 2022-02-26 | Park | Montana | 30067 | 4054 | 34 |
2250639 | 2250639 | 2022-02-25 | Park | Montana | 30067 | 4054 | 34 |
2220788 | 2220788 | 2022-02-16 | Jackson | Kentucky | 21109 | 4054 | 69 |
2191522 | 2191522 | 2022-02-07 | Lawrence | Kentucky | 21127 | 4054 | 54 |
2192369 | 2192369 | 2022-02-07 | Avery | North Carolina | 37011 | 4054 | 40 |
2163592 | 2163592 | 2022-01-29 | Yabucoa | Puerto Rico | 72151 | 4054 | |
2137495 | 2137495 | 2022-01-21 | Camuy | Puerto Rico | 72027 | 4054 | |
2137915 | 2137915 | 2022-01-21 | Lamb | Texas | 48279 | 4054 | 102 |
2130061 | 2130061 | 2022-01-19 | Attala | Mississippi | 28007 | 4054 | 91 |
2127232 | 2127232 | 2022-01-18 | Taos | New Mexico | 35055 | 4054 | 75 |
2114272 | 2114272 | 2022-01-14 | Schoharie | New York | 36095 | 4054 | 31 |
2106030 | 2106030 | 2022-01-12 | Logan | Arkansas | 5083 | 4054 | 57 |
1997037 | 1997037 | 2021-12-09 | Cass | Nebraska | 31025 | 4054 | 23 |
1995229 | 1995229 | 2021-12-08 | Mason | West Virginia | 54053 | 4054 | 62 |
1991082 | 1991082 | 2021-12-07 | Woodward | Oklahoma | 40153 | 4054 | 54 |
1987831 | 1987831 | 2021-12-06 | Woodward | Oklahoma | 40153 | 4054 | 54 |
1984581 | 1984581 | 2021-12-05 | Woodward | Oklahoma | 40153 | 4054 | 54 |
1981331 | 1981331 | 2021-12-04 | Woodward | Oklahoma | 40153 | 4054 | 54 |
1978081 | 1978081 | 2021-12-03 | Woodward | Oklahoma | 40153 | 4054 | 54 |
1978594 | 1978594 | 2021-12-03 | Hutchinson | Texas | 48233 | 4054 | 96 |
1974831 | 1974831 | 2021-12-02 | Woodward | Oklahoma | 40153 | 4054 | 51 |
1970122 | 1970122 | 2021-12-01 | Posey | Indiana | 18129 | 4054 | 44 |
1971582 | 1971582 | 2021-12-01 | Woodward | Oklahoma | 40153 | 4054 | 51 |
1937593 | 1937593 | 2021-11-21 | LaGrange | Indiana | 18087 | 4054 | 91 |
1940014 | 1940014 | 2021-11-21 | Door | Wisconsin | 55029 | 4054 | 41 |
1934343 | 1934343 | 2021-11-20 | LaGrange | Indiana | 18087 | 4054 | 91 |
1936764 | 1936764 | 2021-11-20 | Door | Wisconsin | 55029 | 4054 | 41 |
1931092 | 1931092 | 2021-11-19 | LaGrange | Indiana | 18087 | 4054 | 91 |
1933514 | 1933514 | 2021-11-19 | Door | Wisconsin | 55029 | 4054 | 41 |
1907098 | 1907098 | 2021-11-11 | Karnes | Texas | 48255 | 4054 | 56 |
1903849 | 1903849 | 2021-11-10 | Karnes | Texas | 48255 | 4054 | 56 |
1900599 | 1900599 | 2021-11-09 | Karnes | Texas | 48255 | 4054 | 56 |
1897713 | 1897713 | 2021-11-08 | Jackson | West Virginia | 54035 | 4054 | 87 |
1876364 | 1876364 | 2021-11-02 | Dickinson | Michigan | 26043 | 4054 | 82 |
1873115 | 1873115 | 2021-11-01 | Dickinson | Michigan | 26043 | 4054 | 82 |
1852034 | 1852034 | 2021-10-25 | Accomack | Virginia | 51001 | 4054 | 75 |
1827952 | 1827952 | 2021-10-18 | Saline | Missouri | 29195 | 4054 | 46 |
1824703 | 1824703 | 2021-10-17 | Saline | Missouri | 29195 | 4054 | 46 |
1794454 | 1794454 | 2021-10-08 | Jerome | Idaho | 16053 | 4054 | 42 |
1766679 | 1766679 | 2021-09-29 | Stutsman | North Dakota | 38093 | 4054 | 82 |
1761061 | 1761061 | 2021-09-27 | Amherst | Virginia | 51009 | 4054 | 50 |
1709291 | 1709291 | 2021-09-11 | Randolph | West Virginia | 54083 | 4054 | 25 |
1676964 | 1676964 | 2021-09-02 | Pike | Alabama | 1109 | 4054 | 84 |
1663779 | 1663779 | 2021-08-28 | Fayette | West Virginia | 54019 | 4054 | 90 |
1659320 | 1659320 | 2021-08-27 | Tioga | New York | 36107 | 4054 | 65 |
1660531 | 1660531 | 2021-08-27 | Fayette | West Virginia | 54019 | 4054 | 90 |
1655561 | 1655561 | 2021-08-26 | Polk | Minnesota | 27119 | 4054 | 75 |
1630722 | 1630722 | 2021-08-18 | Carroll | Tennessee | 47017 | 4054 | 84 |
1607882 | 1607882 | 2021-08-11 | Colleton | South Carolina | 45029 | 4054 | 136 |
1608124 | 1608124 | 2021-08-11 | Cooke | Texas | 48097 | 4054 | 72 |
1595775 | 1595775 | 2021-08-08 | Bethel Census Area | Alaska | 2050 | 4054 | 22 |
1592526 | 1592526 | 2021-08-07 | Bethel Census Area | Alaska | 2050 | 4054 | 22 |
1589277 | 1589277 | 2021-08-06 | Bethel Census Area | Alaska | 2050 | 4054 | 22 |
1518533 | 1518533 | 2021-07-15 | Steuben | Indiana | 18151 | 4054 | 62 |
1519823 | 1519823 | 2021-07-15 | Brown | Ohio | 39015 | 4054 | 61 |
1466311 | 1466311 | 2021-06-29 | Oconee | Georgia | 13219 | 4054 | 73 |
1463066 | 1463066 | 2021-06-28 | Oconee | Georgia | 13219 | 4054 | 73 |
1464643 | 1464643 | 2021-06-28 | Crawford | Ohio | 39033 | 4054 | 111 |
1459821 | 1459821 | 2021-06-27 | Oconee | Georgia | 13219 | 4054 | 73 |
1456576 | 1456576 | 2021-06-26 | Oconee | Georgia | 13219 | 4054 | 73 |
1458153 | 1458153 | 2021-06-26 | Crawford | Ohio | 39033 | 4054 | 111 |
1453331 | 1453331 | 2021-06-25 | Oconee | Georgia | 13219 | 4054 | 73 |
1450085 | 1450085 | 2021-06-24 | Oconee | Georgia | 13219 | 4054 | 73 |
1446840 | 1446840 | 2021-06-23 | Oconee | Georgia | 13219 | 4054 | 73 |
1446971 | 1446971 | 2021-06-23 | Fulton | Illinois | 17057 | 4054 | 67 |
1443595 | 1443595 | 2021-06-22 | Oconee | Georgia | 13219 | 4054 | 73 |
1440350 | 1440350 | 2021-06-21 | Oconee | Georgia | 13219 | 4054 | 73 |
1437103 | 1437103 | 2021-06-20 | Oconee | Georgia | 13219 | 4054 | 73 |
1433856 | 1433856 | 2021-06-19 | Oconee | Georgia | 13219 | 4054 | 73 |
1430610 | 1430610 | 2021-06-18 | Oconee | Georgia | 13219 | 4054 | 73 |
1427365 | 1427365 | 2021-06-17 | Oconee | Georgia | 13219 | 4054 | 73 |
1414381 | 1414381 | 2021-06-13 | Oconee | Georgia | 13219 | 4054 | 73 |
1411136 | 1411136 | 2021-06-12 | Oconee | Georgia | 13219 | 4054 | 73 |
1404942 | 1404942 | 2021-06-10 | Whitley | Indiana | 18183 | 4054 | 42 |
1395740 | 1395740 | 2021-06-07 | Beltrami | Minnesota | 27007 | 4054 | 60 |
1392494 | 1392494 | 2021-06-06 | Beltrami | Minnesota | 27007 | 4054 | 60 |
1389249 | 1389249 | 2021-06-05 | Beltrami | Minnesota | 27007 | 4054 | 60 |
1386004 | 1386004 | 2021-06-04 | Beltrami | Minnesota | 27007 | 4054 | 60 |
1382692 | 1382692 | 2021-06-03 | Delta | Michigan | 26041 | 4054 | 94 |
1382893 | 1382893 | 2021-06-03 | Neshoba | Mississippi | 28099 | 4054 | 178 |
1370770 | 1370770 | 2021-05-30 | Venango | Pennsylvania | 42121 | 4054 | 96 |
1346888 | 1346888 | 2021-05-23 | St. Bernard | Louisiana | 22087 | 4054 | 52 |
1343640 | 1343640 | 2021-05-22 | St. Bernard | Louisiana | 22087 | 4054 | 52 |
1340392 | 1340392 | 2021-05-21 | St. Bernard | Louisiana | 22087 | 4054 | 52 |
1336042 | 1336042 | 2021-05-20 | Tallapoosa | Alabama | 1123 | 4054 | 152 |
1328020 | 1328020 | 2021-05-17 | Belknap | New Hampshire | 33001 | 4054 | 100 |
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);