ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where cases = 5232 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 13
- North Carolina 7
- Virginia 7
- West Virginia 7
- Mississippi 6
- Washington 6
- Kentucky 5
- Indiana 4
- New Mexico 4
- Wisconsin 4
- Michigan 3
- Alabama 2
- Illinois 2
- Kansas 2
- Maryland 2
- Missouri 2
- Nebraska 2
- New York 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Tennessee 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Florida 1
- Louisiana 1
- Minnesota 1
- Oklahoma 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474736 | 2474736 | 2022-05-05 | Somerset | Maryland | 24039 | 5232 | 74 |
2471479 | 2471479 | 2022-05-04 | Somerset | Maryland | 24039 | 5232 | 74 |
2461265 | 2461265 | 2022-05-01 | Spencer | Indiana | 18147 | 5232 | 61 |
2458009 | 2458009 | 2022-04-30 | Spencer | Indiana | 18147 | 5232 | 61 |
2454753 | 2454753 | 2022-04-29 | Spencer | Indiana | 18147 | 5232 | 61 |
2415339 | 2415339 | 2022-04-17 | Dodge | Georgia | 13091 | 5232 | 150 |
2412083 | 2412083 | 2022-04-16 | Dodge | Georgia | 13091 | 5232 | 150 |
2408827 | 2408827 | 2022-04-15 | Dodge | Georgia | 13091 | 5232 | 150 |
2405571 | 2405571 | 2022-04-14 | Dodge | Georgia | 13091 | 5232 | 150 |
2402316 | 2402316 | 2022-04-13 | Dodge | Georgia | 13091 | 5232 | 148 |
2375769 | 2375769 | 2022-04-04 | Iowa | Wisconsin | 55049 | 5232 | 28 |
2311212 | 2311212 | 2022-03-16 | Dodge | Georgia | 13091 | 5232 | 147 |
2301512 | 2301512 | 2022-03-13 | Mitchell | Georgia | 13205 | 5232 | 114 |
2298260 | 2298260 | 2022-03-12 | Mitchell | Georgia | 13205 | 5232 | 114 |
2295008 | 2295008 | 2022-03-11 | Mitchell | Georgia | 13205 | 5232 | 114 |
2277404 | 2277404 | 2022-03-05 | San Lorenzo | Puerto Rico | 72129 | 5232 | |
2257337 | 2257337 | 2022-02-27 | Taos | New Mexico | 35055 | 5232 | 87 |
2254086 | 2254086 | 2022-02-26 | Taos | New Mexico | 35055 | 5232 | 87 |
2250835 | 2250835 | 2022-02-25 | Taos | New Mexico | 35055 | 5232 | 87 |
2171445 | 2171445 | 2022-02-01 | Pierce | Georgia | 13229 | 5232 | 108 |
2100805 | 2100805 | 2022-01-10 | Coahoma | Mississippi | 28027 | 5232 | 114 |
2097218 | 2097218 | 2022-01-09 | Ohio | Kentucky | 21183 | 5232 | 91 |
2093966 | 2093966 | 2022-01-08 | Ohio | Kentucky | 21183 | 5232 | 91 |
2090714 | 2090714 | 2022-01-07 | Ohio | Kentucky | 21183 | 5232 | 91 |
2058068 | 2058068 | 2021-12-28 | Miami | Kansas | 20121 | 5232 | 73 |
2054819 | 2054819 | 2021-12-27 | Miami | Kansas | 20121 | 5232 | 73 |
2040742 | 2040742 | 2021-12-22 | Mingo | West Virginia | 54059 | 5232 | 97 |
2014630 | 2014630 | 2021-12-14 | Petersburg city | Virginia | 51730 | 5232 | 107 |
1997786 | 1997786 | 2021-12-09 | Clarendon | South Carolina | 45027 | 5232 | 136 |
1939872 | 1939872 | 2021-11-21 | Prince George | Virginia | 51149 | 5232 | 49 |
1936622 | 1936622 | 2021-11-20 | Prince George | Virginia | 51149 | 5232 | 49 |
1933372 | 1933372 | 2021-11-19 | Prince George | Virginia | 51149 | 5232 | 49 |
1918363 | 1918363 | 2021-11-15 | Calloway | Kentucky | 21035 | 5232 | 61 |
1920437 | 1920437 | 2021-11-15 | Stevens | Washington | 53065 | 5232 | 98 |
1906923 | 1906923 | 2021-11-11 | Lauderdale | Tennessee | 47097 | 5232 | 68 |
1903674 | 1903674 | 2021-11-10 | Lauderdale | Tennessee | 47097 | 5232 | 68 |
1899400 | 1899400 | 2021-11-09 | Lawrence | Missouri | 29109 | 5232 | 107 |
1884869 | 1884869 | 2021-11-05 | Dallas | Alabama | 1047 | 5232 | 207 |
1884794 | 1884794 | 2021-11-04 | Oneida | Wisconsin | 55085 | 5232 | 92 |
1807880 | 1807880 | 2021-10-12 | Boyle | Kentucky | 21021 | 5232 | 80 |
1759530 | 1759530 | 2021-09-27 | Steele | Minnesota | 27147 | 5232 | 21 |
1760003 | 1760003 | 2021-09-27 | Montgomery | New York | 36057 | 5232 | 134 |
1733596 | 1733596 | 2021-09-19 | Lincoln | Mississippi | 28085 | 5232 | 130 |
1734002 | 1734002 | 2021-09-19 | Fulton | New York | 36035 | 5232 | 97 |
1730346 | 1730346 | 2021-09-18 | Lincoln | Mississippi | 28085 | 5232 | 130 |
1727096 | 1727096 | 2021-09-17 | Lincoln | Mississippi | 28085 | 5232 | 130 |
1719638 | 1719638 | 2021-09-15 | Oconee | Georgia | 13219 | 5232 | 75 |
1722208 | 1722208 | 2021-09-15 | Douglas | Washington | 53017 | 5232 | 26 |
1696116 | 1696116 | 2021-09-07 | Danville city | Virginia | 51590 | 5232 | 155 |
1671039 | 1671039 | 2021-08-31 | Effingham | Illinois | 17049 | 5232 | 88 |
1646831 | 1646831 | 2021-08-23 | Toa Alta | Puerto Rico | 72135 | 5232 | |
1637988 | 1637988 | 2021-08-21 | Russell | Alabama | 1113 | 5232 | 51 |
1591994 | 1591994 | 2021-08-06 | Medina | Texas | 48325 | 5232 | 109 |
1537117 | 1537117 | 2021-07-20 | Mercer | West Virginia | 54055 | 5232 | 129 |
1448260 | 1448260 | 2021-06-23 | Carteret | North Carolina | 37031 | 5232 | 55 |
1445015 | 1445015 | 2021-06-22 | Carteret | North Carolina | 37031 | 5232 | 56 |
1438525 | 1438525 | 2021-06-20 | Carteret | North Carolina | 37031 | 5232 | 56 |
1435278 | 1435278 | 2021-06-19 | Carteret | North Carolina | 37031 | 5232 | 56 |
1432031 | 1432031 | 2021-06-18 | Carteret | North Carolina | 37031 | 5232 | 56 |
1397504 | 1397504 | 2021-06-07 | Walla Walla | Washington | 53071 | 5232 | 66 |
1394257 | 1394257 | 2021-06-06 | Walla Walla | Washington | 53071 | 5232 | 66 |
1391012 | 1391012 | 2021-06-05 | Walla Walla | Washington | 53071 | 5232 | 66 |
1387767 | 1387767 | 2021-06-04 | Walla Walla | Washington | 53071 | 5232 | 66 |
1348861 | 1348861 | 2021-05-23 | Putnam | West Virginia | 54079 | 5232 | 93 |
1345613 | 1345613 | 2021-05-22 | Putnam | West Virginia | 54079 | 5232 | 93 |
1342365 | 1342365 | 2021-05-21 | Putnam | West Virginia | 54079 | 5232 | 93 |
1228799 | 1228799 | 2021-04-16 | Shawano | Wisconsin | 55115 | 5232 | 81 |
1223946 | 1223946 | 2021-04-15 | Taney | Missouri | 29213 | 5232 | 92 |
1197651 | 1197651 | 2021-04-07 | Marquette | Michigan | 26103 | 5232 | 57 |
1158144 | 1158144 | 2021-03-26 | Noble | Indiana | 18113 | 5232 | 82 |
1154028 | 1154028 | 2021-03-24 | Raleigh | West Virginia | 54081 | 5232 | 67 |
1146076 | 1146076 | 2021-03-22 | Buffalo | Nebraska | 31019 | 5232 | 56 |
1132576 | 1132576 | 2021-03-18 | St. Charles | Louisiana | 22089 | 5232 | 90 |
1126214 | 1126214 | 2021-03-16 | Midland | Michigan | 26111 | 5232 | 66 |
1102824 | 1102824 | 2021-03-09 | Grundy | Illinois | 17063 | 5232 | 67 |
1093942 | 1093942 | 2021-03-06 | Washington | Mississippi | 28151 | 5232 | 130 |
1089630 | 1089630 | 2021-03-05 | Coffee | Georgia | 13069 | 5232 | 154 |
1092139 | 1092139 | 2021-03-05 | Augusta | Virginia | 51015 | 5232 | 66 |
1037376 | 1037376 | 2021-02-17 | Graham | Arizona | 4009 | 5232 | 70 |
1014971 | 1014971 | 2021-02-10 | Catoosa | Georgia | 13047 | 5232 | 55 |
1008408 | 1008408 | 2021-02-08 | Gadsden | Florida | 12039 | 5232 | 75 |
1009354 | 1009354 | 2021-02-08 | Lapeer | Michigan | 26087 | 5232 | 125 |
965833 | 965833 | 2021-01-25 | Sauk | Wisconsin | 55111 | 5232 | 41 |
887742 | 887742 | 2021-01-01 | Montgomery | Virginia | 51121 | 5232 | 42 |
882924 | 882924 | 2020-12-31 | Forrest | Mississippi | 28035 | 5232 | 101 |
884593 | 884593 | 2020-12-31 | Cabell | West Virginia | 54011 | 5232 | 101 |
855668 | 855668 | 2020-12-23 | Garland | Arkansas | 5051 | 5232 | 139 |
815046 | 815046 | 2020-12-10 | Hall | Nebraska | 31079 | 5232 | 85 |
796156 | 796156 | 2020-12-04 | Franklin | Pennsylvania | 42055 | 5232 | 128 |
760085 | 760085 | 2020-11-23 | Buncombe | North Carolina | 37021 | 5232 | 134 |
730788 | 730788 | 2020-11-14 | McKinley | New Mexico | 35031 | 5232 | 265 |
728145 | 728145 | 2020-11-13 | Dorchester | South Carolina | 45035 | 5232 | 107 |
663155 | 663155 | 2020-10-24 | Northampton | Pennsylvania | 42095 | 5232 | 311 |
610932 | 610932 | 2020-10-08 | Union | North Carolina | 37179 | 5232 | 59 |
541170 | 541170 | 2020-09-17 | Jefferson | Colorado | 8059 | 5232 | 247 |
539814 | 539814 | 2020-09-16 | Cleveland | Oklahoma | 40027 | 5232 | 68 |
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);