ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where cases = 4487 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Oklahoma 16
- Georgia 13
- Texas 11
- Virginia 8
- Louisiana 7
- Wisconsin 7
- Kentucky 6
- Pennsylvania 6
- Mississippi 5
- Illinois 4
- Colorado 3
- Puerto Rico 3
- Alabama 2
- Minnesota 2
- Missouri 2
- North Carolina 2
- Ohio 2
- South Carolina 2
- Tennessee 2
- Washington 2
- California 1
- Delaware 1
- Idaho 1
- Indiana 1
- Iowa 1
- Michigan 1
- Nevada 1
- New Jersey 1
- New Mexico 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500064 | 2500064 | 2022-05-13 | Meriwether | Georgia | 13199 | 4487 | 145 |
2496806 | 2496806 | 2022-05-12 | Meriwether | Georgia | 13199 | 4487 | 145 |
2493548 | 2493548 | 2022-05-11 | Meriwether | Georgia | 13199 | 4487 | 145 |
2474909 | 2474909 | 2022-05-05 | Roseau | Minnesota | 27135 | 4487 | 44 |
2470900 | 2470900 | 2022-05-04 | Johnson | Illinois | 17087 | 4487 | 46 |
2316392 | 2316392 | 2022-03-17 | Fajardo | Puerto Rico | 72053 | 4487 | |
2265438 | 2265438 | 2022-03-02 | Colusa | California | 6011 | 4487 | 21 |
2245701 | 2245701 | 2022-02-23 | Sawyer | Wisconsin | 55113 | 4487 | 58 |
2241435 | 2241435 | 2022-02-22 | Marshall | Oklahoma | 40095 | 4487 | 36 |
2242450 | 2242450 | 2022-02-22 | Sawyer | Wisconsin | 55113 | 4487 | 57 |
2238184 | 2238184 | 2022-02-21 | Marshall | Oklahoma | 40095 | 4487 | 36 |
2239199 | 2239199 | 2022-02-21 | Sawyer | Wisconsin | 55113 | 4487 | 57 |
2234933 | 2234933 | 2022-02-20 | Marshall | Oklahoma | 40095 | 4487 | 36 |
2231682 | 2231682 | 2022-02-19 | Marshall | Oklahoma | 40095 | 4487 | 36 |
2228431 | 2228431 | 2022-02-18 | Marshall | Oklahoma | 40095 | 4487 | 36 |
2225180 | 2225180 | 2022-02-17 | Marshall | Oklahoma | 40095 | 4487 | 36 |
2225807 | 2225807 | 2022-02-17 | Robertson | Texas | 48395 | 4487 | 73 |
2221929 | 2221929 | 2022-02-16 | Marshall | Oklahoma | 40095 | 4487 | 36 |
2187646 | 2187646 | 2022-02-06 | Elbert | Georgia | 13105 | 4487 | 98 |
2184393 | 2184393 | 2022-02-05 | Elbert | Georgia | 13105 | 4487 | 98 |
2181141 | 2181141 | 2022-02-04 | Elbert | Georgia | 13105 | 4487 | 98 |
2159495 | 2159495 | 2022-01-28 | New Madrid | Missouri | 29143 | 4487 | 71 |
2121860 | 2121860 | 2022-01-16 | Fredericksburg city | Virginia | 51630 | 4487 | 28 |
2118608 | 2118608 | 2022-01-15 | Fredericksburg city | Virginia | 51630 | 4487 | 28 |
2115356 | 2115356 | 2022-01-14 | Fredericksburg city | Virginia | 51630 | 4487 | 28 |
2108257 | 2108257 | 2022-01-12 | Manati | Puerto Rico | 72091 | 4487 | |
2104811 | 2104811 | 2022-01-11 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2101560 | 2101560 | 2022-01-10 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2098309 | 2098309 | 2022-01-09 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2095057 | 2095057 | 2022-01-08 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2091805 | 2091805 | 2022-01-07 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2088553 | 2088553 | 2022-01-06 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2085302 | 2085302 | 2022-01-05 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2082608 | 2082608 | 2022-01-04 | Hutchinson | Texas | 48233 | 4487 | 110 |
2077301 | 2077301 | 2022-01-03 | Shelby | Illinois | 17173 | 4487 | 60 |
2008055 | 2008055 | 2021-12-12 | Carroll | Virginia | 51035 | 4487 | 105 |
2004804 | 2004804 | 2021-12-11 | Carroll | Virginia | 51035 | 4487 | 105 |
2001553 | 2001553 | 2021-12-10 | Carroll | Virginia | 51035 | 4487 | 105 |
1989295 | 1989295 | 2021-12-07 | Emanuel | Georgia | 13107 | 4487 | 142 |
1991882 | 1991882 | 2021-12-07 | Pulaski | Virginia | 51155 | 4487 | 97 |
1986045 | 1986045 | 2021-12-06 | Emanuel | Georgia | 13107 | 4487 | 142 |
1945903 | 1945903 | 2021-11-23 | Grainger | Tennessee | 47057 | 4487 | 68 |
1922721 | 1922721 | 2021-11-16 | Pike | Ohio | 39131 | 4487 | 75 |
1905501 | 1905501 | 2021-11-11 | Morehouse | Louisiana | 22067 | 4487 | 116 |
1902251 | 1902251 | 2021-11-10 | Morehouse | Louisiana | 22067 | 4487 | 116 |
1879845 | 1879845 | 2021-11-03 | Yazoo | Mississippi | 28163 | 4487 | 90 |
1881337 | 1881337 | 2021-11-03 | Isle of Wight | Virginia | 51093 | 4487 | 89 |
1874508 | 1874508 | 2021-11-01 | Cass | Texas | 48067 | 4487 | 147 |
1871259 | 1871259 | 2021-10-31 | Cass | Texas | 48067 | 4487 | 147 |
1868010 | 1868010 | 2021-10-30 | Cass | Texas | 48067 | 4487 | 147 |
1859994 | 1859994 | 2021-10-28 | East Feliciana | Louisiana | 22037 | 4487 | 144 |
1854679 | 1854679 | 2021-10-26 | Tioga | Pennsylvania | 42117 | 4487 | 129 |
1850537 | 1850537 | 2021-10-25 | Copiah | Mississippi | 28029 | 4487 | 92 |
1834636 | 1834636 | 2021-10-20 | Nye | Nevada | 32023 | 4487 | 152 |
1799438 | 1799438 | 2021-10-09 | Snyder | Pennsylvania | 42109 | 4487 | 95 |
1771039 | 1771039 | 2021-09-30 | Clark | Wisconsin | 55019 | 4487 | 73 |
1755186 | 1755186 | 2021-09-26 | Summit | Colorado | 8117 | 4487 | 10 |
1751938 | 1751938 | 2021-09-25 | Summit | Colorado | 8117 | 4487 | 10 |
1748689 | 1748689 | 2021-09-24 | Summit | Colorado | 8117 | 4487 | 10 |
1747538 | 1747538 | 2021-09-23 | Trujillo Alto | Puerto Rico | 72139 | 4487 | |
1654830 | 1654830 | 2021-08-26 | Logan | Illinois | 17107 | 4487 | 81 |
1650111 | 1650111 | 2021-08-24 | Colleton | South Carolina | 45029 | 4487 | 142 |
1650491 | 1650491 | 2021-08-24 | Polk | Texas | 48373 | 4487 | 135 |
1647242 | 1647242 | 2021-08-23 | Polk | Texas | 48373 | 4487 | 132 |
1608585 | 1608585 | 2021-08-11 | Ohio | West Virginia | 54069 | 4487 | 87 |
1587076 | 1587076 | 2021-08-05 | Whitley | Kentucky | 21235 | 4487 | 62 |
1584171 | 1584171 | 2021-08-04 | Neshoba | Mississippi | 28099 | 4487 | 181 |
1585806 | 1585806 | 2021-08-04 | Whitman | Washington | 53075 | 4487 | 52 |
1582556 | 1582556 | 2021-08-03 | Whitman | Washington | 53075 | 4487 | 52 |
1532251 | 1532251 | 2021-07-19 | Butler | Missouri | 29023 | 4487 | 51 |
1459739 | 1459739 | 2021-06-27 | Chattahoochee | Georgia | 13053 | 4487 | 17 |
1456494 | 1456494 | 2021-06-26 | Chattahoochee | Georgia | 13053 | 4487 | 17 |
1453249 | 1453249 | 2021-06-25 | Chattahoochee | Georgia | 13053 | 4487 | 17 |
1450003 | 1450003 | 2021-06-24 | Chattahoochee | Georgia | 13053 | 4487 | 17 |
1446758 | 1446758 | 2021-06-23 | Chattahoochee | Georgia | 13053 | 4487 | 17 |
1408398 | 1408398 | 2021-06-11 | Barren | Kentucky | 21009 | 4487 | 101 |
1405152 | 1405152 | 2021-06-10 | Barren | Kentucky | 21009 | 4487 | 101 |
1406094 | 1406094 | 2021-06-10 | Haywood | North Carolina | 37087 | 4487 | 96 |
1401907 | 1401907 | 2021-06-09 | Barren | Kentucky | 21009 | 4487 | 100 |
1398662 | 1398662 | 2021-06-08 | Barren | Kentucky | 21009 | 4487 | 100 |
1352875 | 1352875 | 2021-05-25 | Marion | Illinois | 17121 | 4487 | 121 |
1349028 | 1349028 | 2021-05-24 | Russell | Alabama | 1113 | 4487 | 39 |
1283332 | 1283332 | 2021-05-03 | Cocke | Tennessee | 47029 | 4487 | 98 |
1267352 | 1267352 | 2021-04-28 | Nacogdoches | Texas | 48347 | 4487 | 168 |
1182767 | 1182767 | 2021-04-02 | Burnet | Texas | 48053 | 4487 | 62 |
1171428 | 1171428 | 2021-03-30 | Henderson | Kentucky | 21101 | 4487 | 71 |
1171548 | 1171548 | 2021-03-30 | St. Mary | Louisiana | 22101 | 4487 | 129 |
1150843 | 1150843 | 2021-03-23 | Pierce | Wisconsin | 55093 | 4487 | 41 |
1147596 | 1147596 | 2021-03-22 | Pierce | Wisconsin | 55093 | 4487 | 41 |
1046489 | 1046489 | 2021-02-19 | Harrison | Texas | 48203 | 4487 | 90 |
963797 | 963797 | 2021-01-25 | St. Martin | Louisiana | 22099 | 4487 | 101 |
931991 | 931991 | 2021-01-15 | Curry | New Mexico | 35009 | 4487 | 53 |
925064 | 925064 | 2021-01-13 | Otter Tail | Minnesota | 27111 | 4487 | 60 |
925841 | 925841 | 2021-01-13 | Cherokee | Oklahoma | 40021 | 4487 | 24 |
912856 | 912856 | 2021-01-09 | Bryan | Oklahoma | 40013 | 4487 | 39 |
902260 | 902260 | 2021-01-06 | Marquette | Michigan | 26103 | 4487 | 52 |
895966 | 895966 | 2021-01-04 | Washington | Mississippi | 28151 | 4487 | 117 |
847249 | 847249 | 2020-12-20 | Lauderdale | Mississippi | 28075 | 4487 | 164 |
838019 | 838019 | 2020-12-17 | Lincoln | North Carolina | 37109 | 4487 | 20 |
809303 | 809303 | 2020-12-08 | Sumter | South Carolina | 45085 | 4487 | 103 |
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);