ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where cases = 2966 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 18
- Arkansas 11
- Texas 11
- Georgia 10
- South Dakota 9
- North Carolina 8
- North Dakota 8
- Ohio 8
- Florida 7
- Illinois 6
- West Virginia 6
- Alabama 5
- Colorado 5
- Indiana 5
- Mississippi 5
- Missouri 5
- Puerto Rico 5
- Tennessee 5
- Nebraska 4
- Virginia 4
- Wyoming 4
- California 3
- Kentucky 3
- Louisiana 3
- New Mexico 3
- Oklahoma 3
- Pennsylvania 3
- South Carolina 3
- Wisconsin 3
- Iowa 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491714 | 2491714 | 2022-05-10 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2488456 | 2488456 | 2022-05-09 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2485199 | 2485199 | 2022-05-08 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2481941 | 2481941 | 2022-05-07 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2478683 | 2478683 | 2022-05-06 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2475425 | 2475425 | 2022-05-05 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2472168 | 2472168 | 2022-05-04 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2440970 | 2440970 | 2022-04-25 | Coosa | Alabama | 1037 | 2966 | 58 |
2437714 | 2437714 | 2022-04-24 | Coosa | Alabama | 1037 | 2966 | 58 |
2434458 | 2434458 | 2022-04-23 | Coosa | Alabama | 1037 | 2966 | 58 |
2431202 | 2431202 | 2022-04-22 | Coosa | Alabama | 1037 | 2966 | 58 |
2426002 | 2426002 | 2022-04-20 | Aitkin | Minnesota | 27001 | 2966 | 61 |
2384360 | 2384360 | 2022-04-07 | Barnes | North Dakota | 38003 | 2966 | 47 |
2381105 | 2381105 | 2022-04-06 | Barnes | North Dakota | 38003 | 2966 | 47 |
2377850 | 2377850 | 2022-04-05 | Barnes | North Dakota | 38003 | 2966 | 47 |
2374597 | 2374597 | 2022-04-04 | Barnes | North Dakota | 38003 | 2966 | 47 |
2371345 | 2371345 | 2022-04-03 | Barnes | North Dakota | 38003 | 2966 | 47 |
2368092 | 2368092 | 2022-04-02 | Barnes | North Dakota | 38003 | 2966 | 47 |
2364839 | 2364839 | 2022-04-01 | Barnes | North Dakota | 38003 | 2966 | 47 |
2324077 | 2324077 | 2022-03-20 | Moffat | Colorado | 8081 | 2966 | 51 |
2325202 | 2325202 | 2022-03-20 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2320823 | 2320823 | 2022-03-19 | Moffat | Colorado | 8081 | 2966 | 51 |
2321948 | 2321948 | 2022-03-19 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2317569 | 2317569 | 2022-03-18 | Moffat | Colorado | 8081 | 2966 | 51 |
2318694 | 2318694 | 2022-03-18 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2314316 | 2314316 | 2022-03-17 | Moffat | Colorado | 8081 | 2966 | 51 |
2315441 | 2315441 | 2022-03-17 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2312188 | 2312188 | 2022-03-16 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2286150 | 2286150 | 2022-03-08 | Pope | Minnesota | 27121 | 2966 | 17 |
2265454 | 2265454 | 2022-03-02 | Mariposa | California | 6043 | 2966 | 26 |
2236103 | 2236103 | 2022-02-21 | Bradley | Arkansas | 5011 | 2966 | 44 |
2210109 | 2210109 | 2022-02-13 | Desha | Arkansas | 5041 | 2966 | 37 |
2206856 | 2206856 | 2022-02-12 | Desha | Arkansas | 5041 | 2966 | 37 |
2198622 | 2198622 | 2022-02-09 | Roosevelt | Montana | 30085 | 2966 | 70 |
2187728 | 2187728 | 2022-02-06 | Telfair | Georgia | 13271 | 2966 | 76 |
2184475 | 2184475 | 2022-02-05 | Telfair | Georgia | 13271 | 2966 | 76 |
2181223 | 2181223 | 2022-02-04 | Telfair | Georgia | 13271 | 2966 | 76 |
2163523 | 2163523 | 2022-01-29 | Barceloneta | Puerto Rico | 72017 | 2966 | |
2155139 | 2155139 | 2022-01-27 | Jasper | Georgia | 13159 | 2966 | 66 |
2137180 | 2137180 | 2022-01-21 | McKenzie | North Dakota | 38053 | 2966 | 23 |
2123496 | 2123496 | 2022-01-17 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2124028 | 2124028 | 2022-01-17 | Schuyler | New York | 36097 | 2966 | 23 |
2120244 | 2120244 | 2022-01-16 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2116992 | 2116992 | 2022-01-15 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2113741 | 2113741 | 2022-01-14 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2109085 | 2109085 | 2022-01-12 | Richland | Wisconsin | 55103 | 2966 | 38 |
2098536 | 2098536 | 2022-01-09 | Yauco | Puerto Rico | 72153 | 2966 | |
2095648 | 2095648 | 2022-01-08 | Llano | Texas | 48299 | 2966 | 86 |
2079632 | 2079632 | 2022-01-03 | Nottoway | Virginia | 51135 | 2966 | 71 |
2076478 | 2076478 | 2022-01-02 | Hardy | West Virginia | 54031 | 2966 | 40 |
2073227 | 2073227 | 2022-01-01 | Hardy | West Virginia | 54031 | 2966 | 40 |
2069976 | 2069976 | 2021-12-31 | Hardy | West Virginia | 54031 | 2966 | 40 |
2066725 | 2066725 | 2021-12-30 | Hardy | West Virginia | 54031 | 2966 | 40 |
2061927 | 2061927 | 2021-12-29 | Moniteau | Missouri | 29135 | 2966 | 46 |
2059496 | 2059496 | 2021-12-28 | Naranjito | Puerto Rico | 72105 | 2966 | |
2052981 | 2052981 | 2021-12-26 | Isabela | Puerto Rico | 72071 | 2966 | |
2031723 | 2031723 | 2021-12-20 | Cass | Illinois | 17017 | 2966 | 40 |
2005805 | 2005805 | 2021-12-12 | White | Illinois | 17193 | 2966 | 43 |
2002554 | 2002554 | 2021-12-11 | White | Illinois | 17193 | 2966 | 43 |
1999304 | 1999304 | 2021-12-10 | White | Illinois | 17193 | 2966 | 43 |
1978687 | 1978687 | 2021-12-03 | Shelby | Texas | 48419 | 2966 | 113 |
1972939 | 1972939 | 2021-12-02 | Dixie | Florida | 12029 | 2966 | 38 |
1975437 | 1975437 | 2021-12-02 | Shelby | Texas | 48419 | 2966 | 113 |
1969689 | 1969689 | 2021-12-01 | Dixie | Florida | 12029 | 2966 | 38 |
1966439 | 1966439 | 2021-11-30 | Dixie | Florida | 12029 | 2966 | 38 |
1938604 | 1938604 | 2021-11-21 | Washington | Nebraska | 31177 | 2966 | 29 |
1935354 | 1935354 | 2021-11-20 | Washington | Nebraska | 31177 | 2966 | 29 |
1932104 | 1932104 | 2021-11-19 | Washington | Nebraska | 31177 | 2966 | 29 |
1923416 | 1923416 | 2021-11-16 | Robertson | Texas | 48395 | 2966 | 66 |
1917814 | 1917814 | 2021-11-15 | Jeff Davis | Georgia | 13161 | 2966 | 60 |
1916425 | 1916425 | 2021-11-14 | Wyoming | Pennsylvania | 42131 | 2966 | 65 |
1907575 | 1907575 | 2021-11-11 | Carbon | Wyoming | 56007 | 2966 | 40 |
1904326 | 1904326 | 2021-11-10 | Carbon | Wyoming | 56007 | 2966 | 40 |
1897520 | 1897520 | 2021-11-08 | Windsor | Vermont | 50027 | 2966 | 31 |
1887145 | 1887145 | 2021-11-05 | Juniata | Pennsylvania | 42067 | 2966 | 116 |
1860442 | 1860442 | 2021-10-28 | Ray | Missouri | 29177 | 2966 | 50 |
1768068 | 1768068 | 2021-09-30 | Colusa | California | 6011 | 2966 | 18 |
1765177 | 1765177 | 2021-09-29 | Worth | Georgia | 13321 | 2966 | 84 |
1758232 | 1758232 | 2021-09-27 | La Paz | Arizona | 4012 | 2966 | 86 |
1725809 | 1725809 | 2021-09-17 | Randolph | Arkansas | 5121 | 2966 | 50 |
1722157 | 1722157 | 2021-09-15 | Orange | Virginia | 51137 | 2966 | 44 |
1667558 | 1667558 | 2021-08-30 | Appling | Georgia | 13001 | 2966 | 75 |
1654328 | 1654328 | 2021-08-26 | Logan | Arkansas | 5083 | 2966 | 28 |
1649006 | 1649006 | 2021-08-24 | Wexford | Michigan | 26165 | 2966 | 48 |
1645757 | 1645757 | 2021-08-23 | Wexford | Michigan | 26165 | 2966 | 48 |
1622153 | 1622153 | 2021-08-16 | Haralson | Georgia | 13143 | 2966 | 91 |
1608059 | 1608059 | 2021-08-11 | Smith | Tennessee | 47159 | 2966 | 40 |
1569236 | 1569236 | 2021-07-30 | Limestone | Texas | 48293 | 2966 | 81 |
1541627 | 1541627 | 2021-07-22 | Franklin | Louisiana | 22041 | 2966 | 108 |
1539922 | 1539922 | 2021-07-21 | Deaf Smith | Texas | 48117 | 2966 | 68 |
1536675 | 1536675 | 2021-07-20 | Deaf Smith | Texas | 48117 | 2966 | 68 |
1498110 | 1498110 | 2021-07-08 | Mason | Washington | 53045 | 2966 | 35 |
1459469 | 1459469 | 2021-06-27 | Johnson | Arkansas | 5071 | 2966 | 38 |
1456224 | 1456224 | 2021-06-26 | Johnson | Arkansas | 5071 | 2966 | 38 |
1452979 | 1452979 | 2021-06-25 | Johnson | Arkansas | 5071 | 2966 | 38 |
1449733 | 1449733 | 2021-06-24 | Johnson | Arkansas | 5071 | 2966 | 38 |
1440424 | 1440424 | 2021-06-21 | Cassia | Idaho | 16031 | 2966 | 28 |
1426083 | 1426083 | 2021-06-16 | Beadle | South Dakota | 46005 | 2966 | 40 |
1421556 | 1421556 | 2021-06-15 | West Baton Rouge | Louisiana | 22121 | 2966 | 62 |
1421874 | 1421874 | 2021-06-15 | Barry | Missouri | 29009 | 2966 | 47 |
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);