ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 5867 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 7
- South Dakota 7
- Ohio 5
- Indiana 4
- Louisiana 4
- Tennessee 4
- Alabama 3
- Connecticut 3
- Michigan 3
- Minnesota 3
- New Mexico 3
- North Carolina 3
- Arkansas 2
- Kansas 2
- Pennsylvania 2
- South Carolina 2
- Texas 2
- Virginia 2
- Arizona 1
- California 1
- Delaware 1
- Florida 1
- Idaho 1
- Illinois 1
- Maine 1
- Missouri 1
- New Hampshire 1
- New York 1
- Oregon 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491150 | 2491150 | 2022-05-10 | Dodge | Minnesota | 27039 | 5867 | 21 |
2423212 | 2423212 | 2022-04-19 | Unknown | New Hampshire | 5867 | 2 | |
2420002 | 2420002 | 2022-04-18 | San Miguel | New Mexico | 35047 | 5867 | 56 |
2355551 | 2355551 | 2022-03-29 | Davison | South Dakota | 46035 | 5867 | 78 |
2352298 | 2352298 | 2022-03-28 | Davison | South Dakota | 46035 | 5867 | 78 |
2349046 | 2349046 | 2022-03-27 | Davison | South Dakota | 46035 | 5867 | 78 |
2345793 | 2345793 | 2022-03-26 | Davison | South Dakota | 46035 | 5867 | 78 |
2342540 | 2342540 | 2022-03-25 | Davison | South Dakota | 46035 | 5867 | 78 |
2339287 | 2339287 | 2022-03-24 | Davison | South Dakota | 46035 | 5867 | 78 |
2336033 | 2336033 | 2022-03-23 | Davison | South Dakota | 46035 | 5867 | 78 |
2272952 | 2272952 | 2022-03-04 | Waldo | Maine | 23027 | 5867 | 53 |
2267692 | 2267692 | 2022-03-02 | Jasper | South Carolina | 45053 | 5867 | 92 |
2221342 | 2221342 | 2022-02-16 | Washington | Missouri | 29221 | 5867 | 126 |
2222170 | 2222170 | 2022-02-16 | Fairfield | South Carolina | 45039 | 5867 | 102 |
2218718 | 2218718 | 2022-02-15 | Crook | Oregon | 41013 | 5867 | 68 |
2200796 | 2200796 | 2022-02-10 | Elmore | Idaho | 16039 | 5867 | 58 |
2179820 | 2179820 | 2022-02-03 | Juncos | Puerto Rico | 72077 | 5867 | |
2124944 | 2124944 | 2022-01-17 | Palo Pinto | Texas | 48363 | 5867 | 133 |
2010682 | 2010682 | 2021-12-13 | Tioga | Pennsylvania | 42117 | 5867 | 161 |
1968302 | 1968302 | 2021-11-30 | McCurtain | Oklahoma | 40089 | 5867 | 129 |
1965051 | 1965051 | 2021-11-29 | McCurtain | Oklahoma | 40089 | 5867 | 129 |
1965911 | 1965911 | 2021-11-29 | Wise | Virginia | 51195 | 5867 | 130 |
1961799 | 1961799 | 2021-11-28 | McCurtain | Oklahoma | 40089 | 5867 | 129 |
1958548 | 1958548 | 2021-11-27 | McCurtain | Oklahoma | 40089 | 5867 | 129 |
1955297 | 1955297 | 2021-11-26 | McCurtain | Oklahoma | 40089 | 5867 | 129 |
1951696 | 1951696 | 2021-11-25 | Allegany | New York | 36003 | 5867 | 119 |
1952046 | 1952046 | 2021-11-25 | McCurtain | Oklahoma | 40089 | 5867 | 129 |
1948795 | 1948795 | 2021-11-24 | McCurtain | Oklahoma | 40089 | 5867 | 129 |
1939429 | 1939429 | 2021-11-21 | Marion | Tennessee | 47115 | 5867 | 57 |
1936179 | 1936179 | 2021-11-20 | Marion | Tennessee | 47115 | 5867 | 57 |
1932929 | 1932929 | 2021-11-19 | Marion | Tennessee | 47115 | 5867 | 57 |
1871963 | 1871963 | 2021-11-01 | Baxter | Arkansas | 5005 | 5867 | 179 |
1868714 | 1868714 | 2021-10-31 | Baxter | Arkansas | 5005 | 5867 | 179 |
1784101 | 1784101 | 2021-10-04 | Albany | Wyoming | 56001 | 5867 | 28 |
1760265 | 1760265 | 2021-09-27 | Shelby | Ohio | 39149 | 5867 | 104 |
1719197 | 1719197 | 2021-09-15 | Russell | Alabama | 1113 | 5867 | 53 |
1691090 | 1691090 | 2021-09-06 | Webster | Louisiana | 22119 | 5867 | 131 |
1687840 | 1687840 | 2021-09-05 | Webster | Louisiana | 22119 | 5867 | 131 |
1684590 | 1684590 | 2021-09-04 | Webster | Louisiana | 22119 | 5867 | 131 |
1681339 | 1681339 | 2021-09-03 | Webster | Louisiana | 22119 | 5867 | 131 |
1648430 | 1648430 | 2021-08-24 | Lawrence | Indiana | 18093 | 5867 | 138 |
1647229 | 1647229 | 2021-08-23 | Nacogdoches | Texas | 48347 | 5867 | 178 |
1642503 | 1642503 | 2021-08-22 | Tuscola | Michigan | 26157 | 5867 | 176 |
1639253 | 1639253 | 2021-08-21 | Tuscola | Michigan | 26157 | 5867 | 176 |
1636003 | 1636003 | 2021-08-20 | Tuscola | Michigan | 26157 | 5867 | 176 |
1626771 | 1626771 | 2021-08-17 | Otero | New Mexico | 35035 | 5867 | 88 |
1584654 | 1584654 | 2021-08-04 | Halifax | North Carolina | 37083 | 5867 | 116 |
1563455 | 1563455 | 2021-07-29 | Tehama | California | 6103 | 5867 | 66 |
1527513 | 1527513 | 2021-07-18 | Coffee | Alabama | 1031 | 5867 | 130 |
1503661 | 1503661 | 2021-07-10 | Union | Ohio | 39159 | 5867 | 49 |
1500415 | 1500415 | 2021-07-09 | Union | Ohio | 39159 | 5867 | 49 |
1460704 | 1460704 | 2021-06-27 | Otter Tail | Minnesota | 27111 | 5867 | 85 |
1356182 | 1356182 | 2021-05-26 | Dearborn | Indiana | 18029 | 5867 | 81 |
1332649 | 1332649 | 2021-05-18 | Columbia | Wisconsin | 55021 | 5867 | 69 |
1309026 | 1309026 | 2021-05-11 | Armstrong | Pennsylvania | 42005 | 5867 | 134 |
1263885 | 1263885 | 2021-04-27 | Lawrence | Tennessee | 47099 | 5867 | 86 |
1255485 | 1255485 | 2021-04-25 | Ogle | Illinois | 17141 | 5867 | 86 |
1130097 | 1130097 | 2021-03-17 | Duplin | North Carolina | 37061 | 5867 | 128 |
1105127 | 1105127 | 2021-03-09 | Bedford | Virginia | 51019 | 5867 | 86 |
1058884 | 1058884 | 2021-02-23 | Scioto | Ohio | 39145 | 5867 | 105 |
1050611 | 1050611 | 2021-02-21 | Jackson | Florida | 12063 | 5867 | 146 |
1035011 | 1035011 | 2021-02-16 | Saline | Kansas | 20169 | 5867 | 102 |
1031765 | 1031765 | 2021-02-15 | Saline | Kansas | 20169 | 5867 | 102 |
1008825 | 1008825 | 2021-02-08 | Morgan | Indiana | 18109 | 5867 | 126 |
1001592 | 1001592 | 2021-02-06 | Colbert | Alabama | 1033 | 5867 | 111 |
974348 | 974348 | 2021-01-28 | Stanly | North Carolina | 37167 | 5867 | 92 |
969215 | 969215 | 2021-01-27 | Gila | Arizona | 4007 | 5867 | 182 |
801077 | 801077 | 2020-12-06 | Delaware | Indiana | 18035 | 5867 | 113 |
802195 | 802195 | 2020-12-06 | Sandoval | New Mexico | 35043 | 5867 | 90 |
777957 | 777957 | 2020-11-29 | New London | Connecticut | 9011 | 5867 | 168 |
774712 | 774712 | 2020-11-28 | New London | Connecticut | 9011 | 5867 | 168 |
771467 | 771467 | 2020-11-27 | New London | Connecticut | 9011 | 5867 | 168 |
773289 | 773289 | 2020-11-27 | Trumbull | Ohio | 39155 | 5867 | 148 |
484015 | 484015 | 2020-08-30 | Dakota | Minnesota | 27037 | 5867 | 110 |
421658 | 421658 | 2020-08-11 | Sussex | Delaware | 10005 | 5867 | 192 |
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);