ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 6859 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Georgia 9
- Indiana 9
- Virginia 9
- North Carolina 6
- Texas 4
- Arkansas 3
- Louisiana 3
- Ohio 3
- Wyoming 3
- Illinois 2
- Missouri 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Maryland 1
- Mississippi 1
- Nebraska 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499761 | 2499761 | 2022-05-13 | Yell | Arkansas | 5149 | 6859 | 106 |
2496503 | 2496503 | 2022-05-12 | Yell | Arkansas | 5149 | 6859 | 106 |
2443327 | 2443327 | 2022-04-25 | Isabela | Puerto Rico | 72071 | 6859 | |
2417609 | 2417609 | 2022-04-17 | Fannin | Texas | 48147 | 6859 | 184 |
2414353 | 2414353 | 2022-04-16 | Fannin | Texas | 48147 | 6859 | 184 |
2411097 | 2411097 | 2022-04-15 | Fannin | Texas | 48147 | 6859 | 184 |
2407841 | 2407841 | 2022-04-14 | Fannin | Texas | 48147 | 6859 | 184 |
2383145 | 2383145 | 2022-04-07 | White | Indiana | 18181 | 6859 | 95 |
2379890 | 2379890 | 2022-04-06 | White | Indiana | 18181 | 6859 | 95 |
2313798 | 2313798 | 2022-03-16 | Orange | Virginia | 51137 | 6859 | 85 |
2291990 | 2291990 | 2022-03-10 | Fayette | Indiana | 18041 | 6859 | 145 |
2239766 | 2239766 | 2022-02-22 | Toombs | Georgia | 13279 | 6859 | 188 |
2214378 | 2214378 | 2022-02-14 | Jefferson Davis | Louisiana | 22053 | 6859 | 143 |
2208778 | 2208778 | 2022-02-12 | Stutsman | North Dakota | 38093 | 6859 | 95 |
2194374 | 2194374 | 2022-02-08 | McDonough | Illinois | 17109 | 6859 | 93 |
2187925 | 2187925 | 2022-02-06 | Decatur | Indiana | 18031 | 6859 | 136 |
2184672 | 2184672 | 2022-02-05 | Decatur | Indiana | 18031 | 6859 | 136 |
2181420 | 2181420 | 2022-02-04 | Decatur | Indiana | 18031 | 6859 | 136 |
2131672 | 2131672 | 2022-01-19 | Prince George | Virginia | 51149 | 6859 | 54 |
2079236 | 2079236 | 2022-01-03 | Weakley | Tennessee | 47183 | 6859 | 107 |
2050727 | 2050727 | 2021-12-26 | Boone | Arkansas | 5009 | 6859 | 135 |
2013190 | 2013190 | 2021-12-14 | Platte | Missouri | 29165 | 6859 | 71 |
1985579 | 1985579 | 2021-12-05 | Albany | Wyoming | 56001 | 6859 | 39 |
1982329 | 1982329 | 2021-12-04 | Albany | Wyoming | 56001 | 6859 | 39 |
1979079 | 1979079 | 2021-12-03 | Albany | Wyoming | 56001 | 6859 | 39 |
1966849 | 1966849 | 2021-11-30 | Knox | Indiana | 18083 | 6859 | 117 |
1827526 | 1827526 | 2021-10-18 | St. Bernard | Louisiana | 22087 | 6859 | 98 |
1826102 | 1826102 | 2021-10-17 | James City | Virginia | 51095 | 6859 | 92 |
1822853 | 1822853 | 2021-10-16 | James City | Virginia | 51095 | 6859 | 92 |
1819604 | 1819604 | 2021-10-15 | James City | Virginia | 51095 | 6859 | 92 |
1804357 | 1804357 | 2021-10-11 | Jackson | Indiana | 18071 | 6859 | 88 |
1763058 | 1763058 | 2021-09-28 | Buffalo | Nebraska | 31019 | 6859 | 57 |
1719598 | 1719598 | 2021-09-15 | Habersham | Georgia | 13137 | 6859 | 171 |
1711345 | 1711345 | 2021-09-12 | Halifax | North Carolina | 37083 | 6859 | 122 |
1712326 | 1712326 | 2021-09-12 | Albemarle | Virginia | 51003 | 6859 | 87 |
1708098 | 1708098 | 2021-09-11 | Halifax | North Carolina | 37083 | 6859 | 122 |
1709079 | 1709079 | 2021-09-11 | Albemarle | Virginia | 51003 | 6859 | 87 |
1704851 | 1704851 | 2021-09-10 | Halifax | North Carolina | 37083 | 6859 | 122 |
1705832 | 1705832 | 2021-09-10 | Albemarle | Virginia | 51003 | 6859 | 87 |
1623649 | 1623649 | 2021-08-16 | Lenoir | North Carolina | 37107 | 6859 | 129 |
1580623 | 1580623 | 2021-08-03 | St. Charles | Louisiana | 22089 | 6859 | 100 |
1466219 | 1466219 | 2021-06-29 | Bulloch | Georgia | 13031 | 6859 | 121 |
1462974 | 1462974 | 2021-06-28 | Bulloch | Georgia | 13031 | 6859 | 121 |
1461409 | 1461409 | 2021-06-27 | Geauga | Ohio | 39055 | 6859 | 151 |
1385081 | 1385081 | 2021-06-04 | Bulloch | Georgia | 13031 | 6859 | 120 |
1381835 | 1381835 | 2021-06-03 | Bulloch | Georgia | 13031 | 6859 | 120 |
1365911 | 1365911 | 2021-05-29 | Boone | Indiana | 18011 | 6859 | 107 |
1352253 | 1352253 | 2021-05-25 | Jackson | Alabama | 1071 | 6859 | 112 |
1273141 | 1273141 | 2021-04-30 | Hancock | Ohio | 39063 | 6859 | 126 |
1225687 | 1225687 | 2021-04-16 | Gila | Arizona | 4007 | 6859 | 227 |
1146715 | 1146715 | 2021-03-22 | Somerset | Pennsylvania | 42111 | 6859 | 185 |
1130147 | 1130147 | 2021-03-17 | Rutherford | North Carolina | 37161 | 6859 | 201 |
1112467 | 1112467 | 2021-03-12 | Walker | Georgia | 13295 | 6859 | 80 |
1109910 | 1109910 | 2021-03-11 | Wicomico | Maryland | 24045 | 6859 | 145 |
1056503 | 1056503 | 2021-02-22 | Lynchburg city | Virginia | 51680 | 6859 | 96 |
1033986 | 1033986 | 2021-02-15 | Portage | Wisconsin | 55097 | 6859 | 66 |
1030740 | 1030740 | 2021-02-14 | Portage | Wisconsin | 55097 | 6859 | 66 |
899253 | 899253 | 2021-01-05 | Franklin | Missouri | 29071 | 6859 | 115 |
869971 | 869971 | 2020-12-27 | Madison | Mississippi | 28089 | 6859 | 129 |
844551 | 844551 | 2020-12-19 | Wayne | North Carolina | 37191 | 6859 | 131 |
807330 | 807330 | 2020-12-08 | Lowndes | Georgia | 13185 | 6859 | 129 |
687213 | 687213 | 2020-11-01 | Clarke | Georgia | 13059 | 6859 | 50 |
526815 | 526815 | 2020-09-12 | Lucas | Ohio | 39095 | 6859 | 350 |
215953 | 215953 | 2020-06-07 | Kane | Illinois | 17089 | 6859 | 215 |
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);