ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 3307 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Texas 13
- Kentucky 7
- Mississippi 6
- Tennessee 6
- Virginia 6
- New York 5
- Puerto Rico 5
- Alabama 4
- Arkansas 4
- Colorado 4
- Illinois 4
- Indiana 4
- Louisiana 4
- Maryland 4
- North Carolina 4
- Minnesota 3
- Ohio 3
- West Virginia 3
- Kansas 2
- Missouri 2
- New Mexico 2
- North Dakota 2
- Oregon 2
- Wyoming 2
- California 1
- Hawaii 1
- Idaho 1
- Iowa 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378249 | 2378249 | 2022-04-05 | Utuado | Puerto Rico | 72141 | 3307 | |
2374995 | 2374995 | 2022-04-04 | Utuado | Puerto Rico | 72141 | 3307 | |
2294228 | 2294228 | 2022-03-10 | Dickenson | Virginia | 51051 | 3307 | 45 |
2284202 | 2284202 | 2022-03-07 | Duval | Texas | 48131 | 3307 | 68 |
2280950 | 2280950 | 2022-03-06 | Duval | Texas | 48131 | 3307 | 68 |
2277697 | 2277697 | 2022-03-05 | Duval | Texas | 48131 | 3307 | 68 |
2254298 | 2254298 | 2022-02-26 | Walsh | North Dakota | 38099 | 3307 | 34 |
2251047 | 2251047 | 2022-02-25 | Walsh | North Dakota | 38099 | 3307 | 34 |
2234728 | 2234728 | 2022-02-20 | Swain | North Carolina | 37173 | 3307 | 34 |
2231477 | 2231477 | 2022-02-19 | Swain | North Carolina | 37173 | 3307 | 34 |
2228226 | 2228226 | 2022-02-18 | Swain | North Carolina | 37173 | 3307 | 34 |
2211090 | 2211090 | 2022-02-13 | Trigg | Kentucky | 21221 | 3307 | 38 |
2207837 | 2207837 | 2022-02-12 | Trigg | Kentucky | 21221 | 3307 | 38 |
2204584 | 2204584 | 2022-02-11 | Trigg | Kentucky | 21221 | 3307 | 38 |
2205364 | 2205364 | 2022-02-11 | Schuyler | New York | 36097 | 3307 | 23 |
2197246 | 2197246 | 2022-02-09 | Las Animas | Colorado | 8071 | 3307 | 39 |
2171212 | 2171212 | 2022-02-01 | Grand | Colorado | 8049 | 3307 | 22 |
2168723 | 2168723 | 2022-01-31 | Estill | Kentucky | 21065 | 3307 | 40 |
2145937 | 2145937 | 2022-01-24 | Casey | Kentucky | 21045 | 3307 | 65 |
2108644 | 2108644 | 2022-01-12 | Lamb | Texas | 48279 | 3307 | 100 |
2060340 | 2060340 | 2021-12-28 | Carbon | Wyoming | 56007 | 3307 | 46 |
2047474 | 2047474 | 2021-12-25 | Ashley | Arkansas | 5003 | 3307 | 53 |
2044224 | 2044224 | 2021-12-24 | Ashley | Arkansas | 5003 | 3307 | 53 |
2036728 | 2036728 | 2021-12-21 | Gurabo | Puerto Rico | 72063 | 3307 | |
2036731 | 2036731 | 2021-12-21 | Humacao | Puerto Rico | 72069 | 3307 | |
2021084 | 2021084 | 2021-12-16 | Fredericksburg city | Virginia | 51630 | 3307 | 26 |
2007859 | 2007859 | 2021-12-12 | Jones | Texas | 48253 | 3307 | 78 |
1942745 | 1942745 | 2021-11-22 | Burleson | Texas | 48051 | 3307 | 60 |
1936513 | 1936513 | 2021-11-20 | Orleans | Vermont | 50019 | 3307 | 23 |
1919781 | 1919781 | 2021-11-15 | Fairfield | South Carolina | 45039 | 3307 | 93 |
1907715 | 1907715 | 2021-11-12 | Clark | Arkansas | 5019 | 3307 | 60 |
1905554 | 1905554 | 2021-11-11 | Caroline | Maryland | 24011 | 3307 | 52 |
1829659 | 1829659 | 2021-10-19 | Monroe | Alabama | 1099 | 3307 | 62 |
1831029 | 1831029 | 2021-10-19 | Attala | Mississippi | 28007 | 3307 | 89 |
1793915 | 1793915 | 2021-10-08 | Marengo | Alabama | 1091 | 3307 | 89 |
1784901 | 1784901 | 2021-10-05 | Spencer | Indiana | 18147 | 3307 | 38 |
1768957 | 1768957 | 2021-09-30 | McCreary | Kentucky | 21147 | 3307 | 46 |
1770019 | 1770019 | 2021-09-30 | Van Wert | Ohio | 39161 | 3307 | 72 |
1767422 | 1767422 | 2021-09-29 | Moore | Texas | 48341 | 3307 | 79 |
1740600 | 1740600 | 2021-09-21 | Martin | North Carolina | 37117 | 3307 | 61 |
1732593 | 1732593 | 2021-09-19 | Grady | Georgia | 13131 | 3307 | 77 |
1729343 | 1729343 | 2021-09-18 | Grady | Georgia | 13131 | 3307 | 77 |
1726093 | 1726093 | 2021-09-17 | Grady | Georgia | 13131 | 3307 | 77 |
1720308 | 1720308 | 2021-09-15 | St. James | Louisiana | 22093 | 3307 | 62 |
1714169 | 1714169 | 2021-09-13 | Crawford | Missouri | 29055 | 3307 | 47 |
1696185 | 1696185 | 2021-09-07 | Pulaski | Virginia | 51155 | 3307 | 72 |
1690335 | 1690335 | 2021-09-06 | Cook | Georgia | 13075 | 3307 | 48 |
1692475 | 1692475 | 2021-09-06 | Haywood | Tennessee | 47075 | 3307 | 66 |
1687085 | 1687085 | 2021-09-05 | Cook | Georgia | 13075 | 3307 | 48 |
1689226 | 1689226 | 2021-09-05 | Haywood | Tennessee | 47075 | 3307 | 66 |
1683835 | 1683835 | 2021-09-04 | Cook | Georgia | 13075 | 3307 | 48 |
1685976 | 1685976 | 2021-09-04 | Haywood | Tennessee | 47075 | 3307 | 66 |
1680584 | 1680584 | 2021-09-03 | Cook | Georgia | 13075 | 3307 | 48 |
1682725 | 1682725 | 2021-09-03 | Haywood | Tennessee | 47075 | 3307 | 66 |
1680036 | 1680036 | 2021-09-02 | Mineral | West Virginia | 54057 | 3307 | 92 |
1674874 | 1674874 | 2021-09-01 | Dorchester | Maryland | 24019 | 3307 | 68 |
1665385 | 1665385 | 2021-08-29 | Newton | Mississippi | 28101 | 3307 | 67 |
1665801 | 1665801 | 2021-08-29 | Orleans | New York | 36073 | 3307 | 83 |
1662137 | 1662137 | 2021-08-28 | Newton | Mississippi | 28101 | 3307 | 67 |
1658889 | 1658889 | 2021-08-27 | Newton | Mississippi | 28101 | 3307 | 67 |
1642784 | 1642784 | 2021-08-22 | Stoddard | Missouri | 29207 | 3307 | 54 |
1591941 | 1591941 | 2021-08-06 | Hockley | Texas | 48219 | 3307 | 107 |
1577363 | 1577363 | 2021-08-02 | Morehouse | Louisiana | 22067 | 3307 | 80 |
1550378 | 1550378 | 2021-07-25 | Lincoln | Arkansas | 5079 | 3307 | 49 |
1533800 | 1533800 | 2021-07-19 | Wise | Virginia | 51195 | 3307 | 105 |
1523871 | 1523871 | 2021-07-16 | Willacy | Texas | 48489 | 3307 | 92 |
1517563 | 1517563 | 2021-07-14 | Wise | Virginia | 51195 | 3307 | 105 |
1387526 | 1387526 | 2021-06-04 | Upshur | Texas | 48459 | 3307 | 75 |
1381035 | 1381035 | 2021-06-02 | Upshur | Texas | 48459 | 3307 | 75 |
1316006 | 1316006 | 2021-05-13 | Kendall | Texas | 48259 | 3307 | 72 |
1301010 | 1301010 | 2021-05-09 | Jefferson | Indiana | 18077 | 3307 | 82 |
1269632 | 1269632 | 2021-04-29 | Luna | New Mexico | 35029 | 3307 | 85 |
1250223 | 1250223 | 2021-04-23 | Wyoming | New York | 36121 | 3307 | 51 |
1250657 | 1250657 | 2021-04-23 | Arecibo | Puerto Rico | 72013 | 3307 | |
1251442 | 1251442 | 2021-04-23 | Marshall | West Virginia | 54051 | 3307 | 77 |
1236667 | 1236667 | 2021-04-19 | Carlton | Minnesota | 27017 | 3307 | 52 |
1223822 | 1223822 | 2021-04-15 | Sunflower | Mississippi | 28133 | 3307 | 89 |
1220877 | 1220877 | 2021-04-14 | Cheshire | New Hampshire | 33005 | 3307 | 33 |
1211250 | 1211250 | 2021-04-11 | Warren | New York | 36113 | 3307 | 55 |
1198611 | 1198611 | 2021-04-07 | Polk | Oregon | 41053 | 3307 | 50 |
1190360 | 1190360 | 2021-04-05 | Pickens | Georgia | 13227 | 3307 | 74 |
1177398 | 1177398 | 2021-04-01 | Toombs | Georgia | 13279 | 3307 | 108 |
1157688 | 1157688 | 2021-03-26 | Summit | Colorado | 8117 | 3307 | 7 |
1154340 | 1154340 | 2021-03-25 | Lake | California | 6033 | 3307 | 43 |
1151178 | 1151178 | 2021-03-24 | Montrose | Colorado | 8085 | 3307 | 57 |
1141705 | 1141705 | 2021-03-21 | Maui | Hawaii | 15009 | 3307 | 36 |
1131946 | 1131946 | 2021-03-18 | Upson | Georgia | 13293 | 3307 | 120 |
1129390 | 1129390 | 2021-03-17 | Worcester | Maryland | 24047 | 3307 | 92 |
1122897 | 1122897 | 2021-03-15 | Worcester | Maryland | 24047 | 3307 | 92 |
1080123 | 1080123 | 2021-03-02 | Logan | Illinois | 17107 | 3307 | 66 |
1073584 | 1073584 | 2021-02-28 | Bureau | Illinois | 17011 | 3307 | 86 |
1070274 | 1070274 | 2021-02-27 | Wayne | Georgia | 13305 | 3307 | 77 |
1070386 | 1070386 | 2021-02-27 | Logan | Illinois | 17107 | 3307 | 66 |
1071595 | 1071595 | 2021-02-27 | Fulton | New York | 36035 | 3307 | 83 |
1069048 | 1069048 | 2021-02-26 | Hardin | Tennessee | 47071 | 3307 | 63 |
1043763 | 1043763 | 2021-02-18 | Teton | Wyoming | 56039 | 3307 | 9 |
1037300 | 1037300 | 2021-02-17 | Dallas | Alabama | 1047 | 3307 | 133 |
1033644 | 1033644 | 2021-02-15 | Waller | Texas | 48473 | 3307 | 37 |
1025031 | 1025031 | 2021-02-13 | Huntington | Indiana | 18069 | 3307 | 77 |
1018738 | 1018738 | 2021-02-11 | Harvey | Kansas | 20079 | 3307 | 52 |
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);