ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 4682 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 11
- North Carolina 8
- Indiana 7
- Georgia 6
- Mississippi 6
- Alabama 5
- Virginia 5
- Washington 5
- Kentucky 4
- Ohio 4
- Puerto Rico 4
- Wisconsin 4
- Iowa 3
- New York 3
- Utah 3
- Alaska 2
- Colorado 2
- Idaho 2
- Louisiana 2
- Missouri 2
- South Dakota 2
- Texas 2
- West Virginia 2
- Arizona 1
- Delaware 1
- Florida 1
- Illinois 1
- Maryland 1
- Minnesota 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460620 | 2460620 | 2022-05-01 | Drew | Arkansas | 5043 | 4682 | 70 |
2457364 | 2457364 | 2022-04-30 | Drew | Arkansas | 5043 | 4682 | 70 |
2454108 | 2454108 | 2022-04-29 | Drew | Arkansas | 5043 | 4682 | 70 |
2450852 | 2450852 | 2022-04-28 | Drew | Arkansas | 5043 | 4682 | 70 |
2447596 | 2447596 | 2022-04-27 | Drew | Arkansas | 5043 | 4682 | 70 |
2444340 | 2444340 | 2022-04-26 | Drew | Arkansas | 5043 | 4682 | 70 |
2441084 | 2441084 | 2022-04-25 | Drew | Arkansas | 5043 | 4682 | 70 |
2437828 | 2437828 | 2022-04-24 | Drew | Arkansas | 5043 | 4682 | 70 |
2314062 | 2314062 | 2022-03-17 | Hale | Alabama | 1065 | 4682 | 103 |
2268804 | 2268804 | 2022-03-03 | Teller | Colorado | 8119 | 4682 | 56 |
2266346 | 2266346 | 2022-03-02 | Powell | Kentucky | 21197 | 4682 | 37 |
2260243 | 2260243 | 2022-02-28 | Andrew | Missouri | 29003 | 4682 | 53 |
2233515 | 2233515 | 2022-02-20 | Starke | Indiana | 18149 | 4682 | 93 |
2230264 | 2230264 | 2022-02-19 | Starke | Indiana | 18149 | 4682 | 93 |
2227013 | 2227013 | 2022-02-18 | Starke | Indiana | 18149 | 4682 | 93 |
2223062 | 2223062 | 2022-02-17 | Kodiak Island Borough | Alaska | 2150 | 4682 | 11 |
2219811 | 2219811 | 2022-02-16 | Kodiak Island Borough | Alaska | 2150 | 4682 | 11 |
2190267 | 2190267 | 2022-02-06 | Adams | Washington | 53001 | 4682 | 35 |
2187014 | 2187014 | 2022-02-05 | Adams | Washington | 53001 | 4682 | 35 |
2183761 | 2183761 | 2022-02-04 | Adams | Washington | 53001 | 4682 | 35 |
2153762 | 2153762 | 2022-01-26 | Cabo Rojo | Puerto Rico | 72023 | 4682 | |
2150532 | 2150532 | 2022-01-25 | Hatillo | Puerto Rico | 72065 | 4682 | |
2147300 | 2147300 | 2022-01-24 | Naranjito | Puerto Rico | 72105 | 4682 | |
2043891 | 2043891 | 2021-12-23 | Pulaski | Virginia | 51155 | 4682 | 104 |
1930929 | 1930929 | 2021-11-19 | Latah | Idaho | 16057 | 4682 | 40 |
1927679 | 1927679 | 2021-11-18 | Latah | Idaho | 16057 | 4682 | 40 |
1925259 | 1925259 | 2021-11-17 | Adams | Mississippi | 28001 | 4682 | 125 |
1920533 | 1920533 | 2021-11-15 | Lincoln | Wisconsin | 55069 | 4682 | 113 |
1884057 | 1884057 | 2021-11-04 | Union | South Carolina | 45087 | 4682 | 106 |
1878534 | 1878534 | 2021-11-03 | Yell | Arkansas | 5149 | 4682 | 78 |
1871916 | 1871916 | 2021-11-01 | Winston | Alabama | 1133 | 4682 | 103 |
1868667 | 1868667 | 2021-10-31 | Winston | Alabama | 1133 | 4682 | 103 |
1866905 | 1866905 | 2021-10-30 | Lafayette | Missouri | 29107 | 4682 | 73 |
1847706 | 1847706 | 2021-10-24 | Allegany | New York | 36003 | 4682 | 98 |
1837152 | 1837152 | 2021-10-21 | Grayson | Kentucky | 21085 | 4682 | 88 |
1809979 | 1809979 | 2021-10-12 | Greenbrier | West Virginia | 54025 | 4682 | 84 |
1774387 | 1774387 | 2021-10-02 | Clarke | Alabama | 1025 | 4682 | 80 |
1746184 | 1746184 | 2021-09-23 | Harlan | Kentucky | 21095 | 4682 | 102 |
1737704 | 1737704 | 2021-09-20 | Pike | Pennsylvania | 42103 | 4682 | 56 |
1721391 | 1721391 | 2021-09-15 | Malheur | Oregon | 41045 | 4682 | 67 |
1697185 | 1697185 | 2021-09-08 | Steuben | Indiana | 18151 | 4682 | 66 |
1675034 | 1675034 | 2021-09-01 | McLeod | Minnesota | 27085 | 4682 | 61 |
1668948 | 1668948 | 2021-08-30 | Belknap | New Hampshire | 33001 | 4682 | 105 |
1650721 | 1650721 | 2021-08-24 | Shenandoah | Virginia | 51171 | 4682 | 137 |
1638112 | 1638112 | 2021-08-21 | Union | Arkansas | 5139 | 4682 | 118 |
1640013 | 1640013 | 2021-08-21 | Defiance | Ohio | 39039 | 4682 | 99 |
1610570 | 1610570 | 2021-08-12 | Madison | New York | 36053 | 4682 | 89 |
1611284 | 1611284 | 2021-08-12 | Marshall | Tennessee | 47117 | 4682 | 65 |
1608411 | 1608411 | 2021-08-11 | Danville city | Virginia | 51590 | 4682 | 146 |
1596462 | 1596462 | 2021-08-08 | Montgomery | Indiana | 18107 | 4682 | 94 |
1593213 | 1593213 | 2021-08-07 | Montgomery | Indiana | 18107 | 4682 | 94 |
1589964 | 1589964 | 2021-08-06 | Montgomery | Indiana | 18107 | 4682 | 94 |
1573356 | 1573356 | 2021-08-01 | Baldwin | Georgia | 13009 | 4682 | 137 |
1570108 | 1570108 | 2021-07-31 | Baldwin | Georgia | 13009 | 4682 | 137 |
1566860 | 1566860 | 2021-07-30 | Baldwin | Georgia | 13009 | 4682 | 137 |
1559980 | 1559980 | 2021-07-28 | Chilton | Alabama | 1021 | 4682 | 117 |
1511677 | 1511677 | 2021-07-13 | Chattahoochee | Georgia | 13053 | 4682 | 17 |
1506235 | 1506235 | 2021-07-11 | Panola | Mississippi | 28107 | 4682 | 112 |
1502989 | 1502989 | 2021-07-10 | Panola | Mississippi | 28107 | 4682 | 112 |
1499743 | 1499743 | 2021-07-09 | Panola | Mississippi | 28107 | 4682 | 112 |
1496497 | 1496497 | 2021-07-08 | Panola | Mississippi | 28107 | 4682 | 112 |
1498014 | 1498014 | 2021-07-08 | Henry | Virginia | 51089 | 4682 | 124 |
1403637 | 1403637 | 2021-06-09 | Howard | Texas | 48227 | 4682 | 101 |
1400392 | 1400392 | 2021-06-08 | Howard | Texas | 48227 | 4682 | 101 |
1388361 | 1388361 | 2021-06-05 | Effingham | Georgia | 13103 | 4682 | 69 |
1381870 | 1381870 | 2021-06-03 | Effingham | Georgia | 13103 | 4682 | 69 |
1357373 | 1357373 | 2021-05-26 | Beaufort | North Carolina | 37013 | 4682 | 95 |
1347647 | 1347647 | 2021-05-23 | Chatham | North Carolina | 37037 | 4682 | 88 |
1344399 | 1344399 | 2021-05-22 | Chatham | North Carolina | 37037 | 4682 | 88 |
1341151 | 1341151 | 2021-05-21 | Chatham | North Carolina | 37037 | 4682 | 88 |
1337903 | 1337903 | 2021-05-20 | Chatham | North Carolina | 37037 | 4682 | 88 |
1339174 | 1339174 | 2021-05-20 | Monroe | Wisconsin | 55081 | 4682 | 39 |
1324944 | 1324944 | 2021-05-16 | Hoke | North Carolina | 37093 | 4682 | 55 |
1321698 | 1321698 | 2021-05-15 | Hoke | North Carolina | 37093 | 4682 | 55 |
1318452 | 1318452 | 2021-05-14 | Hoke | North Carolina | 37093 | 4682 | 55 |
1274174 | 1274174 | 2021-04-30 | Mercer | West Virginia | 54055 | 4682 | 116 |
1243884 | 1243884 | 2021-04-21 | Williams | North Dakota | 38105 | 4682 | 38 |
1153977 | 1153977 | 2021-03-24 | Skagit | Washington | 53057 | 4682 | 63 |
1119282 | 1119282 | 2021-03-14 | Marshall | Iowa | 19127 | 4682 | 74 |
1119514 | 1119514 | 2021-03-14 | Nelson | Kentucky | 21179 | 4682 | 44 |
1116035 | 1116035 | 2021-03-13 | Marshall | Iowa | 19127 | 4682 | 74 |
1107502 | 1107502 | 2021-03-10 | Athens | Ohio | 39009 | 4682 | 50 |
1100642 | 1100642 | 2021-03-08 | Dodge | Nebraska | 31053 | 4682 | 56 |
1052360 | 1052360 | 2021-02-21 | Jefferson | Ohio | 39081 | 4682 | 105 |
1040469 | 1040469 | 2021-02-17 | Oconto | Wisconsin | 55083 | 4682 | 54 |
1006713 | 1006713 | 2021-02-07 | St. Lawrence | New York | 36089 | 4682 | 73 |
1001227 | 1001227 | 2021-02-05 | Summit | Utah | 49043 | 4682 | 7 |
940797 | 940797 | 2021-01-18 | Webster | Iowa | 19187 | 4682 | 71 |
925172 | 925172 | 2021-01-13 | Washington | Mississippi | 28151 | 4682 | 121 |
922902 | 922902 | 2021-01-12 | Brown | South Dakota | 46013 | 4682 | 68 |
923470 | 923470 | 2021-01-12 | Rockingham | Virginia | 51165 | 4682 | 50 |
900062 | 900062 | 2021-01-05 | Caguas | Puerto Rico | 72025 | 4682 | |
889792 | 889792 | 2021-01-02 | Sussex | New Jersey | 34037 | 4682 | 215 |
878092 | 878092 | 2020-12-29 | Thurston | Washington | 53067 | 4682 | 54 |
843672 | 843672 | 2020-12-19 | Acadia | Louisiana | 22001 | 4682 | 132 |
840427 | 840427 | 2020-12-18 | Acadia | Louisiana | 22001 | 4682 | 132 |
829704 | 829704 | 2020-12-15 | Garland | Arkansas | 5051 | 4682 | 131 |
750570 | 750570 | 2020-11-20 | Trumbull | Ohio | 39155 | 4682 | 143 |
702643 | 702643 | 2020-11-05 | Cache | Utah | 49005 | 4682 | 12 |
570348 | 570348 | 2020-09-26 | Weld | Colorado | 8123 | 4682 | 149 |
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);