ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where cases = 4356 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Tennessee 9
- Texas 8
- Georgia 7
- California 6
- Louisiana 6
- Virginia 6
- Illinois 5
- Indiana 5
- Missouri 5
- West Virginia 5
- Mississippi 4
- Puerto Rico 4
- Wyoming 4
- Idaho 3
- Minnesota 3
- Nebraska 3
- New York 3
- North Carolina 3
- North Dakota 3
- Ohio 3
- Pennsylvania 3
- Utah 3
- Colorado 2
- Kansas 2
- Kentucky 2
- Nevada 1
- New Mexico 1
- South Carolina 1
- South Dakota 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502347 | 2502347 | 2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 |
2499089 | 2499089 | 2022-05-12 | Lamb | Texas | 48279 | 4356 | 122 |
2470859 | 2470859 | 2022-05-04 | Bond | Illinois | 17005 | 4356 | 37 |
2427564 | 2427564 | 2022-04-20 | Duchesne | Utah | 49013 | 4356 | 26 |
2424308 | 2424308 | 2022-04-19 | Duchesne | Utah | 49013 | 4356 | 26 |
2282051 | 2282051 | 2022-03-07 | Washington | Georgia | 13303 | 4356 | 132 |
2282185 | 2282185 | 2022-03-07 | Piatt | Illinois | 17147 | 4356 | 28 |
2281200 | 2281200 | 2022-03-06 | Bristol city | Virginia | 51520 | 4356 | 71 |
2277947 | 2277947 | 2022-03-05 | Bristol city | Virginia | 51520 | 4356 | 71 |
2274588 | 2274588 | 2022-03-04 | Shelby | Texas | 48419 | 4356 | 126 |
2274694 | 2274694 | 2022-03-04 | Bristol city | Virginia | 51520 | 4356 | 71 |
2263753 | 2263753 | 2022-03-01 | Unknown | Nebraska | 4356 | 454 | |
2218241 | 2218241 | 2022-02-15 | Washington | Nebraska | 31177 | 4356 | 33 |
2193559 | 2193559 | 2022-02-07 | Barbour | West Virginia | 54001 | 4356 | 63 |
2180678 | 2180678 | 2022-02-03 | Carbon | Wyoming | 56007 | 4356 | 50 |
2172549 | 2172549 | 2022-02-01 | Texas | Missouri | 29215 | 4356 | 80 |
2170662 | 2170662 | 2022-01-31 | Fluvanna | Virginia | 51065 | 4356 | 33 |
2145304 | 2145304 | 2022-01-24 | Appling | Georgia | 13001 | 4356 | 111 |
2142421 | 2142421 | 2022-01-23 | Orange | Indiana | 18117 | 4356 | 88 |
2139166 | 2139166 | 2022-01-22 | Orange | Indiana | 18117 | 4356 | 88 |
2135910 | 2135910 | 2022-01-21 | Orange | Indiana | 18117 | 4356 | 88 |
2101813 | 2101813 | 2022-01-10 | Fairfield | South Carolina | 45039 | 4356 | 96 |
2089122 | 2089122 | 2022-01-06 | Karnes | Texas | 48255 | 4356 | 58 |
2078201 | 2078201 | 2022-01-03 | Randolph | Missouri | 29175 | 4356 | 85 |
2079769 | 2079769 | 2022-01-03 | Wyoming | West Virginia | 54109 | 4356 | 76 |
2053221 | 2053221 | 2021-12-26 | Smith | Tennessee | 47159 | 4356 | 63 |
2049971 | 2049971 | 2021-12-25 | Smith | Tennessee | 47159 | 4356 | 63 |
2046721 | 2046721 | 2021-12-24 | Smith | Tennessee | 47159 | 4356 | 63 |
2043471 | 2043471 | 2021-12-23 | Smith | Tennessee | 47159 | 4356 | 63 |
2032217 | 2032217 | 2021-12-20 | Rowan | Kentucky | 21205 | 4356 | 46 |
2034095 | 2034095 | 2021-12-20 | Halifax | Virginia | 51083 | 4356 | 118 |
2009839 | 2009839 | 2021-12-13 | Sunflower | Mississippi | 28133 | 4356 | 106 |
2010123 | 2010123 | 2021-12-13 | Churchill | Nevada | 32001 | 4356 | 86 |
2000170 | 2000170 | 2021-12-10 | Miller | Missouri | 29131 | 4356 | 100 |
1959791 | 1959791 | 2021-11-28 | Calaveras | California | 6009 | 4356 | 85 |
1956540 | 1956540 | 2021-11-27 | Calaveras | California | 6009 | 4356 | 85 |
1953289 | 1953289 | 2021-11-26 | Calaveras | California | 6009 | 4356 | 85 |
1950038 | 1950038 | 2021-11-25 | Calaveras | California | 6009 | 4356 | 85 |
1946787 | 1946787 | 2021-11-24 | Calaveras | California | 6009 | 4356 | 85 |
1943536 | 1943536 | 2021-11-23 | Calaveras | California | 6009 | 4356 | 84 |
1943243 | 1943243 | 2021-11-22 | Upshur | West Virginia | 54097 | 4356 | 68 |
1874407 | 1874407 | 2021-11-01 | Grainger | Tennessee | 47057 | 4356 | 67 |
1871158 | 1871158 | 2021-10-31 | Grainger | Tennessee | 47057 | 4356 | 67 |
1867909 | 1867909 | 2021-10-30 | Grainger | Tennessee | 47057 | 4356 | 67 |
1864660 | 1864660 | 2021-10-29 | Grainger | Tennessee | 47057 | 4356 | 67 |
1835182 | 1835182 | 2021-10-20 | Tioga | Pennsylvania | 42117 | 4356 | 129 |
1823698 | 1823698 | 2021-10-17 | Latah | Idaho | 16057 | 4356 | 31 |
1824295 | 1824295 | 2021-10-17 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1820449 | 1820449 | 2021-10-16 | Latah | Idaho | 16057 | 4356 | 31 |
1821046 | 1821046 | 2021-10-16 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1817200 | 1817200 | 2021-10-15 | Latah | Idaho | 16057 | 4356 | 31 |
1817797 | 1817797 | 2021-10-15 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1814549 | 1814549 | 2021-10-14 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1814701 | 1814701 | 2021-10-14 | Carlton | Minnesota | 27017 | 4356 | 65 |
1808365 | 1808365 | 2021-10-12 | Yazoo | Mississippi | 28163 | 4356 | 86 |
1805518 | 1805518 | 2021-10-11 | Washington | New York | 36115 | 4356 | 65 |
1763784 | 1763784 | 2021-09-28 | Vega Baja | Puerto Rico | 72145 | 4356 | |
1759821 | 1759821 | 2021-09-27 | Dakota | Nebraska | 31043 | 4356 | 82 |
1760535 | 1760535 | 2021-09-27 | Vega Baja | Puerto Rico | 72145 | 4356 | |
1742169 | 1742169 | 2021-09-22 | Logan | Colorado | 8075 | 4356 | 72 |
1735279 | 1735279 | 2021-09-19 | Randolph | West Virginia | 54083 | 4356 | 28 |
1728507 | 1728507 | 2021-09-17 | Willacy | Texas | 48489 | 4356 | 101 |
1713786 | 1713786 | 2021-09-13 | East Feliciana | Louisiana | 22037 | 4356 | 134 |
1685812 | 1685812 | 2021-09-04 | Trujillo Alto | Puerto Rico | 72139 | 4356 | |
1667164 | 1667164 | 2021-08-29 | Teton | Wyoming | 56039 | 4356 | 11 |
1663916 | 1663916 | 2021-08-28 | Teton | Wyoming | 56039 | 4356 | 11 |
1660668 | 1660668 | 2021-08-27 | Teton | Wyoming | 56039 | 4356 | 11 |
1630652 | 1630652 | 2021-08-18 | Brookings | South Dakota | 46011 | 4356 | 37 |
1597288 | 1597288 | 2021-08-08 | Pulaski | Missouri | 29169 | 4356 | 59 |
1565206 | 1565206 | 2021-07-29 | Stokes | North Carolina | 37169 | 4356 | 81 |
1552314 | 1552314 | 2021-07-25 | Fulton | Ohio | 39051 | 4356 | 75 |
1527907 | 1527907 | 2021-07-18 | Camden | Georgia | 13039 | 4356 | 40 |
1524660 | 1524660 | 2021-07-17 | Camden | Georgia | 13039 | 4356 | 40 |
1521412 | 1521412 | 2021-07-16 | Camden | Georgia | 13039 | 4356 | 40 |
1451098 | 1451098 | 2021-06-24 | Camden | Missouri | 29029 | 4356 | 89 |
1451483 | 1451483 | 2021-06-24 | Tompkins | New York | 36109 | 4356 | 52 |
1424379 | 1424379 | 2021-06-16 | Montgomery | Indiana | 18107 | 4356 | 92 |
1373048 | 1373048 | 2021-05-31 | Isanti | Minnesota | 27059 | 4356 | 64 |
1369803 | 1369803 | 2021-05-30 | Isanti | Minnesota | 27059 | 4356 | 64 |
1320415 | 1320415 | 2021-05-15 | Monroe | Illinois | 17133 | 4356 | 93 |
1310674 | 1310674 | 2021-05-12 | Monroe | Illinois | 17133 | 4356 | 93 |
1304244 | 1304244 | 2021-05-10 | Gibson | Indiana | 18051 | 4356 | 95 |
1299129 | 1299129 | 2021-05-08 | Madison | Ohio | 39097 | 4356 | 61 |
1283748 | 1283748 | 2021-05-03 | Danville city | Virginia | 51590 | 4356 | 134 |
1276564 | 1276564 | 2021-05-01 | Bedford | Pennsylvania | 42009 | 4356 | 134 |
1268982 | 1268982 | 2021-04-29 | Washington | Louisiana | 22117 | 4356 | 129 |
1269263 | 1269263 | 2021-04-29 | Marshall | Mississippi | 28093 | 4356 | 103 |
1259932 | 1259932 | 2021-04-26 | Madison | New York | 36053 | 4356 | 88 |
1224340 | 1224340 | 2021-04-15 | Watauga | North Carolina | 37189 | 4356 | 30 |
1221964 | 1221964 | 2021-04-14 | Wilson | Texas | 48493 | 4356 | 66 |
1152360 | 1152360 | 2021-03-24 | Pearl River | Mississippi | 28109 | 4356 | 135 |
1134142 | 1134142 | 2021-03-18 | Hill | Texas | 48217 | 4356 | 103 |
1130894 | 1130894 | 2021-03-17 | Hill | Texas | 48217 | 4356 | 102 |
1123580 | 1123580 | 2021-03-15 | Beaufort | North Carolina | 37013 | 4356 | 84 |
1124806 | 1124806 | 2021-03-15 | Putnam | West Virginia | 54079 | 4356 | 84 |
1093089 | 1093089 | 2021-03-06 | Henry | Illinois | 17073 | 4356 | 87 |
1088863 | 1088863 | 2021-03-04 | Wasatch | Utah | 49051 | 4356 | 20 |
1077331 | 1077331 | 2021-03-01 | Shelby | Kentucky | 21211 | 4356 | 50 |
1059343 | 1059343 | 2021-02-23 | Obion | Tennessee | 47131 | 4356 | 94 |
1055866 | 1055866 | 2021-02-22 | Guaynabo | Puerto Rico | 72061 | 4356 |
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);