ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where cases = 3036 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Tennessee 13
- Virginia 11
- Florida 10
- Mississippi 8
- Puerto Rico 7
- Georgia 6
- Alabama 5
- Louisiana 5
- Pennsylvania 5
- South Carolina 5
- Colorado 4
- Minnesota 4
- Missouri 4
- Montana 4
- North Carolina 4
- Ohio 4
- Oklahoma 4
- Illinois 3
- Kentucky 3
- California 2
- Indiana 2
- Kansas 2
- Michigan 2
- New Mexico 2
- West Virginia 2
- Wisconsin 2
- Arizona 1
- Iowa 1
- New York 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470541 | 2470541 | 2022-05-04 | Moffat | Colorado | 8081 | 3036 | 52 |
2305896 | 2305896 | 2022-03-14 | Custer | Montana | 30017 | 3036 | 46 |
2239762 | 2239762 | 2022-02-22 | Telfair | Georgia | 13271 | 3036 | 78 |
2235539 | 2235539 | 2022-02-20 | Nolan | Texas | 48353 | 3036 | 93 |
2232288 | 2232288 | 2022-02-19 | Nolan | Texas | 48353 | 3036 | 93 |
2197223 | 2197223 | 2022-02-09 | Crowley | Colorado | 8025 | 3036 | 28 |
2196323 | 2196323 | 2022-02-08 | Stewart | Tennessee | 47161 | 3036 | 47 |
2193069 | 2193069 | 2022-02-07 | Stewart | Tennessee | 47161 | 3036 | 47 |
2189815 | 2189815 | 2022-02-06 | Stewart | Tennessee | 47161 | 3036 | 47 |
2186562 | 2186562 | 2022-02-05 | Stewart | Tennessee | 47161 | 3036 | 47 |
2183310 | 2183310 | 2022-02-04 | Stewart | Tennessee | 47161 | 3036 | 47 |
2180058 | 2180058 | 2022-02-03 | Stewart | Tennessee | 47161 | 3036 | 47 |
2175539 | 2175539 | 2022-02-02 | Cottonwood | Minnesota | 27033 | 3036 | 38 |
2176807 | 2176807 | 2022-02-02 | Stewart | Tennessee | 47161 | 3036 | 47 |
2152462 | 2152462 | 2022-01-26 | Green | Kentucky | 21087 | 3036 | 40 |
2153514 | 2153514 | 2022-01-26 | Harrison | Ohio | 39067 | 3036 | 63 |
2125072 | 2125072 | 2022-01-17 | Appomattox | Virginia | 51011 | 3036 | 38 |
2112071 | 2112071 | 2022-01-13 | Bristol city | Virginia | 51520 | 3036 | 58 |
2101374 | 2101374 | 2022-01-10 | Warren | North Carolina | 37185 | 3036 | 36 |
2102082 | 2102082 | 2022-01-10 | Freestone | Texas | 48161 | 3036 | 75 |
2086714 | 2086714 | 2022-01-06 | Gulf | Florida | 12045 | 3036 | 65 |
2088718 | 2088718 | 2022-01-06 | Catano | Puerto Rico | 72033 | 3036 | |
2083462 | 2083462 | 2022-01-05 | Gulf | Florida | 12045 | 3036 | 65 |
2080210 | 2080210 | 2022-01-04 | Gulf | Florida | 12045 | 3036 | 65 |
2076958 | 2076958 | 2022-01-03 | Gulf | Florida | 12045 | 3036 | 65 |
2073707 | 2073707 | 2022-01-02 | Gulf | Florida | 12045 | 3036 | 65 |
2070456 | 2070456 | 2022-01-01 | Gulf | Florida | 12045 | 3036 | 65 |
2067205 | 2067205 | 2021-12-31 | Gulf | Florida | 12045 | 3036 | 65 |
2052039 | 2052039 | 2021-12-26 | Clarke | Mississippi | 28023 | 3036 | 96 |
2048789 | 2048789 | 2021-12-25 | Clarke | Mississippi | 28023 | 3036 | 96 |
2045539 | 2045539 | 2021-12-24 | Clarke | Mississippi | 28023 | 3036 | 96 |
2042289 | 2042289 | 2021-12-23 | Clarke | Mississippi | 28023 | 3036 | 96 |
2039040 | 2039040 | 2021-12-22 | Clarke | Mississippi | 28023 | 3036 | 96 |
2032166 | 2032166 | 2021-12-20 | Henry | Kentucky | 21103 | 3036 | 36 |
1998381 | 1998381 | 2021-12-09 | Prince Edward | Virginia | 51147 | 3036 | 52 |
1991953 | 1991953 | 2021-12-07 | Barbour | West Virginia | 54001 | 3036 | 52 |
1972869 | 1972869 | 2021-12-02 | Elbert | Colorado | 8039 | 3036 | 26 |
1968869 | 1968869 | 2021-11-30 | Lamb | Texas | 48279 | 3036 | 93 |
1904015 | 1904015 | 2021-11-10 | Orleans | Vermont | 50019 | 3036 | 19 |
1873274 | 1873274 | 2021-11-01 | Chickasaw | Mississippi | 28017 | 3036 | 67 |
1852284 | 1852284 | 2021-10-25 | Green Lake | Wisconsin | 55047 | 3036 | 31 |
1844974 | 1844974 | 2021-10-23 | Humacao | Puerto Rico | 72069 | 3036 | |
1818948 | 1818948 | 2021-10-15 | Aguadilla | Puerto Rico | 72005 | 3036 | |
1815699 | 1815699 | 2021-10-14 | Aguadilla | Puerto Rico | 72005 | 3036 | |
1811695 | 1811695 | 2021-10-13 | Perry | Missouri | 29157 | 3036 | 33 |
1812451 | 1812451 | 2021-10-13 | Aguadilla | Puerto Rico | 72005 | 3036 | |
1774477 | 1774477 | 2021-10-02 | La Paz | Arizona | 4012 | 3036 | 92 |
1770447 | 1770447 | 2021-09-30 | Humphreys | Tennessee | 47085 | 3036 | 44 |
1764660 | 1764660 | 2021-09-29 | Henry | Alabama | 1067 | 3036 | 58 |
1701524 | 1701524 | 2021-09-09 | Lewis | New York | 36049 | 3036 | 36 |
1667170 | 1667170 | 2021-08-30 | Barbour | Alabama | 1005 | 3036 | 65 |
1668570 | 1668570 | 2021-08-30 | Todd | Minnesota | 27153 | 3036 | 33 |
1653640 | 1653640 | 2021-08-25 | Gonzales | Texas | 48177 | 3036 | 61 |
1637039 | 1637039 | 2021-08-20 | Dorado | Puerto Rico | 72051 | 3036 | |
1586864 | 1586864 | 2021-08-05 | Cherokee | Kansas | 20021 | 3036 | 60 |
1583614 | 1583614 | 2021-08-04 | Cherokee | Kansas | 20021 | 3036 | 60 |
1579250 | 1579250 | 2021-08-02 | Smyth | Virginia | 51173 | 3036 | 96 |
1561045 | 1561045 | 2021-07-28 | Marshall | Kentucky | 21157 | 3036 | 63 |
1562901 | 1562901 | 2021-07-28 | Amherst | Virginia | 51009 | 3036 | 40 |
1558311 | 1558311 | 2021-07-27 | Saline | Missouri | 29195 | 3036 | 40 |
1528032 | 1528032 | 2021-07-18 | Unknown | Georgia | 3036 | 6 | |
1524785 | 1524785 | 2021-07-17 | Unknown | Georgia | 3036 | 6 | |
1521537 | 1521537 | 2021-07-16 | Unknown | Georgia | 3036 | 6 | |
1518188 | 1518188 | 2021-07-15 | Decatur | Georgia | 13087 | 3036 | 73 |
1406740 | 1406740 | 2021-06-10 | Overton | Tennessee | 47133 | 3036 | 61 |
1401385 | 1401385 | 2021-06-09 | Lumpkin | Georgia | 13187 | 3036 | 76 |
1387723 | 1387723 | 2021-06-04 | Warren | Virginia | 51187 | 3036 | 59 |
1352020 | 1352020 | 2021-05-24 | Warren | Virginia | 51187 | 3036 | 58 |
1339554 | 1339554 | 2021-05-21 | Bradford | Florida | 12007 | 3036 | 57 |
1326280 | 1326280 | 2021-05-17 | Lawrence | Alabama | 1079 | 3036 | 98 |
1287183 | 1287183 | 2021-05-04 | Wayne | West Virginia | 54099 | 3036 | 40 |
1282444 | 1282444 | 2021-05-03 | Ravalli | Montana | 30081 | 3036 | 32 |
1279197 | 1279197 | 2021-05-02 | Ravalli | Montana | 30081 | 3036 | 32 |
1275950 | 1275950 | 2021-05-01 | Ravalli | Montana | 30081 | 3036 | 32 |
1246252 | 1246252 | 2021-04-22 | Vernon | Louisiana | 22115 | 3036 | 101 |
1247599 | 1247599 | 2021-04-22 | Yankton | South Dakota | 46135 | 3036 | 30 |
1234519 | 1234519 | 2021-04-18 | Edgefield | South Carolina | 45037 | 3036 | 41 |
1218386 | 1218386 | 2021-04-13 | Claiborne | Tennessee | 47025 | 3036 | 73 |
1215201 | 1215201 | 2021-04-12 | Scott | Tennessee | 47151 | 3036 | 45 |
1201102 | 1201102 | 2021-04-08 | Yazoo | Mississippi | 28163 | 3036 | 68 |
1202341 | 1202341 | 2021-04-08 | Hopkins | Texas | 48223 | 3036 | 108 |
1199092 | 1199092 | 2021-04-07 | Hopkins | Texas | 48223 | 3036 | 108 |
1184972 | 1184972 | 2021-04-03 | Warren | Missouri | 29219 | 3036 | 30 |
1159699 | 1159699 | 2021-03-26 | Pike | Pennsylvania | 42103 | 3036 | 50 |
1152961 | 1152961 | 2021-03-24 | Champaign | Ohio | 39021 | 3036 | 52 |
1142272 | 1142272 | 2021-03-21 | Allen | Louisiana | 22003 | 3036 | 90 |
1142626 | 1142626 | 2021-03-21 | Scott | Mississippi | 28123 | 3036 | 71 |
1139026 | 1139026 | 2021-03-20 | Allen | Louisiana | 22003 | 3036 | 90 |
1135780 | 1135780 | 2021-03-19 | Allen | Louisiana | 22003 | 3036 | 90 |
1129498 | 1129498 | 2021-03-17 | Carlton | Minnesota | 27017 | 3036 | 50 |
1129715 | 1129715 | 2021-03-17 | Lafayette | Missouri | 29107 | 3036 | 56 |
1130475 | 1130475 | 2021-03-17 | Perry | Pennsylvania | 42099 | 3036 | 88 |
1124422 | 1124422 | 2021-03-15 | Kendall | Texas | 48259 | 3036 | 66 |
1121176 | 1121176 | 2021-03-14 | Kendall | Texas | 48259 | 3036 | 66 |
1117929 | 1117929 | 2021-03-13 | Kendall | Texas | 48259 | 3036 | 66 |
1098148 | 1098148 | 2021-03-07 | Marlboro | South Carolina | 45069 | 3036 | 50 |
1093852 | 1093852 | 2021-03-06 | Steele | Minnesota | 27147 | 3036 | 11 |
1076528 | 1076528 | 2021-03-01 | Summit | Colorado | 8117 | 3036 | 7 |
1078412 | 1078412 | 2021-03-01 | Lincoln | Oklahoma | 40081 | 3036 | 54 |
1037474 | 1037474 | 2021-02-17 | Humboldt | California | 6023 | 3036 | 32 |
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);