ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 4838 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 11
- Wisconsin 9
- Louisiana 8
- Arkansas 7
- Oklahoma 7
- Georgia 6
- Minnesota 6
- Mississippi 6
- Illinois 5
- Vermont 5
- Iowa 4
- Washington 4
- Kentucky 3
- Ohio 3
- West Virginia 3
- New York 2
- North Carolina 2
- Puerto Rico 2
- Alabama 1
- California 1
- Colorado 1
- Idaho 1
- Indiana 1
- Michigan 1
- Missouri 1
- Montana 1
- Nebraska 1
- New Jersey 1
- New Mexico 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502683 | 2502683 | 2022-05-13 | Barbour | West Virginia | 54001 | 4838 | 73 |
2446572 | 2446572 | 2022-04-26 | Fajardo | Puerto Rico | 72053 | 4838 | |
2444173 | 2444173 | 2022-04-25 | Taylor | Wisconsin | 55119 | 4838 | 72 |
2421721 | 2421721 | 2022-04-19 | Teller | Colorado | 8119 | 4838 | 57 |
2398331 | 2398331 | 2022-04-11 | Colonial Heights city | Virginia | 51570 | 4838 | 96 |
2395076 | 2395076 | 2022-04-10 | Colonial Heights city | Virginia | 51570 | 4838 | 96 |
2391820 | 2391820 | 2022-04-09 | Colonial Heights city | Virginia | 51570 | 4838 | 96 |
2388564 | 2388564 | 2022-04-08 | Colonial Heights city | Virginia | 51570 | 4838 | 96 |
2378799 | 2378799 | 2022-04-05 | Colonial Heights city | Virginia | 51570 | 4838 | 96 |
2375545 | 2375545 | 2022-04-04 | Colonial Heights city | Virginia | 51570 | 4838 | 96 |
2356796 | 2356796 | 2022-03-30 | Lamar | Georgia | 13171 | 4838 | 112 |
2327657 | 2327657 | 2022-03-21 | Clark | Illinois | 17023 | 4838 | 60 |
2324404 | 2324404 | 2022-03-20 | Clark | Illinois | 17023 | 4838 | 60 |
2321150 | 2321150 | 2022-03-19 | Clark | Illinois | 17023 | 4838 | 60 |
2317896 | 2317896 | 2022-03-18 | Clark | Illinois | 17023 | 4838 | 60 |
2310445 | 2310445 | 2022-03-15 | Orange | Vermont | 50017 | 4838 | 14 |
2225954 | 2225954 | 2022-02-17 | Fluvanna | Virginia | 51065 | 4838 | 37 |
2213380 | 2213380 | 2022-02-14 | Lincoln | Arkansas | 5079 | 4838 | 61 |
2210128 | 2210128 | 2022-02-13 | Lincoln | Arkansas | 5079 | 4838 | 61 |
2198802 | 2198802 | 2022-02-09 | Roosevelt | New Mexico | 35041 | 4838 | 89 |
2190857 | 2190857 | 2022-02-07 | Berrien | Georgia | 13019 | 4838 | 72 |
2186603 | 2186603 | 2022-02-05 | Burleson | Texas | 48051 | 4838 | 63 |
2154794 | 2154794 | 2022-01-27 | Columbia | Arkansas | 5027 | 4838 | 77 |
2137547 | 2137547 | 2022-01-21 | San Lorenzo | Puerto Rico | 72129 | 4838 | |
2051735 | 2051735 | 2021-12-26 | Allen | Louisiana | 22003 | 4838 | 119 |
2052028 | 2052028 | 2021-12-26 | Adams | Mississippi | 28001 | 4838 | 125 |
2053536 | 2053536 | 2021-12-26 | Windsor | Vermont | 50027 | 4838 | 42 |
2048485 | 2048485 | 2021-12-25 | Allen | Louisiana | 22003 | 4838 | 119 |
2048778 | 2048778 | 2021-12-25 | Adams | Mississippi | 28001 | 4838 | 125 |
2050286 | 2050286 | 2021-12-25 | Windsor | Vermont | 50027 | 4838 | 42 |
2045235 | 2045235 | 2021-12-24 | Allen | Louisiana | 22003 | 4838 | 119 |
2045528 | 2045528 | 2021-12-24 | Adams | Mississippi | 28001 | 4838 | 125 |
2047036 | 2047036 | 2021-12-24 | Windsor | Vermont | 50027 | 4838 | 42 |
2041986 | 2041986 | 2021-12-23 | Allen | Louisiana | 22003 | 4838 | 119 |
2042278 | 2042278 | 2021-12-23 | Adams | Mississippi | 28001 | 4838 | 125 |
2043786 | 2043786 | 2021-12-23 | Windsor | Vermont | 50027 | 4838 | 42 |
2038736 | 2038736 | 2021-12-22 | Allen | Louisiana | 22003 | 4838 | 119 |
2039029 | 2039029 | 2021-12-22 | Adams | Mississippi | 28001 | 4838 | 125 |
2035486 | 2035486 | 2021-12-21 | Allen | Louisiana | 22003 | 4838 | 119 |
2032236 | 2032236 | 2021-12-20 | Allen | Louisiana | 22003 | 4838 | 118 |
1989989 | 1989989 | 2021-12-07 | De Soto | Louisiana | 22031 | 4838 | 113 |
1953037 | 1953037 | 2021-11-25 | Lincoln | Wisconsin | 55069 | 4838 | 116 |
1948462 | 1948462 | 2021-11-24 | Greene | New York | 36039 | 4838 | 88 |
1885024 | 1885024 | 2021-11-05 | St. Francis | Arkansas | 5123 | 4838 | 67 |
1872333 | 1872333 | 2021-11-01 | Lumpkin | Georgia | 13187 | 4838 | 107 |
1871665 | 1871665 | 2021-10-31 | Clallam | Washington | 53009 | 4838 | 60 |
1868416 | 1868416 | 2021-10-30 | Clallam | Washington | 53009 | 4838 | 60 |
1865167 | 1865167 | 2021-10-29 | Clallam | Washington | 53009 | 4838 | 60 |
1830315 | 1830315 | 2021-10-19 | Adams | Indiana | 18001 | 4838 | 76 |
1813143 | 1813143 | 2021-10-13 | Prince George | Virginia | 51149 | 4838 | 38 |
1761252 | 1761252 | 2021-09-27 | Marshall | West Virginia | 54051 | 4838 | 96 |
1744353 | 1744353 | 2021-09-22 | Brookings | South Dakota | 46011 | 4838 | 37 |
1739664 | 1739664 | 2021-09-21 | Clay | Kentucky | 21051 | 4838 | 52 |
1740298 | 1740298 | 2021-09-21 | Silver Bow | Montana | 30093 | 4838 | 93 |
1722578 | 1722578 | 2021-09-16 | Amador | California | 6005 | 4838 | 58 |
1708258 | 1708258 | 2021-09-11 | Logan | Ohio | 39091 | 4838 | 82 |
1677437 | 1677437 | 2021-09-02 | Toombs | Georgia | 13279 | 4838 | 136 |
1655532 | 1655532 | 2021-08-26 | Itasca | Minnesota | 27061 | 4838 | 69 |
1608842 | 1608842 | 2021-08-12 | Independence | Arkansas | 5063 | 4838 | 132 |
1595817 | 1595817 | 2021-08-08 | Baxter | Arkansas | 5005 | 4838 | 128 |
1582449 | 1582449 | 2021-08-03 | James City | Virginia | 51095 | 4838 | 72 |
1515564 | 1515564 | 2021-07-14 | Jessamine | Kentucky | 21113 | 4838 | 73 |
1511215 | 1511215 | 2021-07-12 | Polk | Wisconsin | 55095 | 4838 | 64 |
1507968 | 1507968 | 2021-07-11 | Polk | Wisconsin | 55095 | 4838 | 64 |
1504722 | 1504722 | 2021-07-10 | Polk | Wisconsin | 55095 | 4838 | 64 |
1501476 | 1501476 | 2021-07-09 | Polk | Wisconsin | 55095 | 4838 | 64 |
1498230 | 1498230 | 2021-07-08 | Polk | Wisconsin | 55095 | 4838 | 64 |
1494983 | 1494983 | 2021-07-07 | Polk | Wisconsin | 55095 | 4838 | 64 |
1469747 | 1469747 | 2021-06-30 | Stephenson | Illinois | 17177 | 4838 | 104 |
1437956 | 1437956 | 2021-06-20 | Goodhue | Minnesota | 27049 | 4838 | 74 |
1434709 | 1434709 | 2021-06-19 | Goodhue | Minnesota | 27049 | 4838 | 74 |
1435213 | 1435213 | 2021-06-19 | Clinton | New York | 36019 | 4838 | 33 |
1431462 | 1431462 | 2021-06-18 | Goodhue | Minnesota | 27049 | 4838 | 74 |
1428217 | 1428217 | 2021-06-17 | Goodhue | Minnesota | 27049 | 4838 | 74 |
1405694 | 1405694 | 2021-06-10 | Johnson | Missouri | 29101 | 4838 | 57 |
1340093 | 1340093 | 2021-05-21 | Muscatine | Iowa | 19139 | 4838 | 103 |
1336846 | 1336846 | 2021-05-20 | Muscatine | Iowa | 19139 | 4838 | 101 |
1330346 | 1330346 | 2021-05-18 | Marshall | Iowa | 19127 | 4838 | 75 |
1306784 | 1306784 | 2021-05-11 | Dale | Alabama | 1045 | 4838 | 111 |
1308978 | 1308978 | 2021-05-11 | Stephens | Oklahoma | 40137 | 4838 | 101 |
1309928 | 1309928 | 2021-05-11 | Douglas | Wisconsin | 55031 | 4838 | 54 |
1304077 | 1304077 | 2021-05-10 | Bingham | Idaho | 16011 | 4838 | 74 |
1305732 | 1305732 | 2021-05-10 | Stephens | Oklahoma | 40137 | 4838 | 101 |
1302486 | 1302486 | 2021-05-09 | Stephens | Oklahoma | 40137 | 4838 | 101 |
1299238 | 1299238 | 2021-05-08 | Stephens | Oklahoma | 40137 | 4838 | 101 |
1295992 | 1295992 | 2021-05-07 | Stephens | Oklahoma | 40137 | 4838 | 101 |
1292746 | 1292746 | 2021-05-06 | Stephens | Oklahoma | 40137 | 4838 | 101 |
1289500 | 1289500 | 2021-05-05 | Stephens | Oklahoma | 40137 | 4838 | 101 |
1280594 | 1280594 | 2021-05-02 | Washington | Virginia | 51191 | 4838 | 106 |
1220104 | 1220104 | 2021-04-14 | Boyd | Kentucky | 21019 | 4838 | 72 |
1198053 | 1198053 | 2021-04-07 | Dodge | Nebraska | 31053 | 4838 | 58 |
1199445 | 1199445 | 2021-04-07 | Skagit | Washington | 53057 | 4838 | 67 |
1119302 | 1119302 | 2021-03-14 | Sioux | Iowa | 19167 | 4838 | 69 |
1116983 | 1116983 | 2021-03-13 | Salem | New Jersey | 34033 | 4838 | 166 |
1103486 | 1103486 | 2021-03-09 | Marquette | Michigan | 26103 | 4838 | 57 |
1105329 | 1105329 | 2021-03-09 | Raleigh | West Virginia | 54081 | 4838 | 60 |
1088059 | 1088059 | 2021-03-04 | Huron | Ohio | 39077 | 4838 | 107 |
1040162 | 1040162 | 2021-02-17 | Iron | Utah | 49021 | 4838 | 28 |
1032125 | 1032125 | 2021-02-15 | Chisago | Minnesota | 27025 | 4838 | 44 |
984055 | 984055 | 2021-01-31 | Lee | North Carolina | 37105 | 4838 | 56 |
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);