ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 8704 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Georgia 4
- South Carolina 4
- Pennsylvania 3
- Indiana 2
- Mississippi 2
- Missouri 2
- Montana 2
- Tennessee 2
- Texas 2
- Alabama 1
- Guam 1
- Maryland 1
- North Carolina 1
- Ohio 1
- South Dakota 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442182 | 2442182 | 2022-04-25 | Worcester | Maryland | 24047 | 8704 | 159 |
2427375 | 2427375 | 2022-04-20 | Erath | Texas | 48143 | 8704 | 123 |
2305062 | 2305062 | 2022-03-14 | Wabash | Indiana | 18169 | 8704 | 152 |
2192742 | 2192742 | 2022-02-07 | Clinton | Pennsylvania | 42035 | 8704 | 117 |
2102417 | 2102417 | 2022-01-10 | Shenandoah | Virginia | 51171 | 8704 | 189 |
2005611 | 2005611 | 2021-12-12 | Polk | Georgia | 13233 | 8704 | 164 |
2002360 | 2002360 | 2021-12-11 | Polk | Georgia | 13233 | 8704 | 164 |
1999110 | 1999110 | 2021-12-10 | Polk | Georgia | 13233 | 8704 | 164 |
1981249 | 1981249 | 2021-12-04 | Washington | Ohio | 39167 | 8704 | 159 |
1940815 | 1940815 | 2021-11-22 | Dearborn | Indiana | 18029 | 8704 | 105 |
1905796 | 1905796 | 2021-11-11 | Lafayette | Mississippi | 28071 | 8704 | 141 |
1902547 | 1902547 | 2021-11-10 | Lafayette | Mississippi | 28071 | 8704 | 141 |
1850656 | 1850656 | 2021-10-25 | Joplin | Missouri | 8704 | 150 | |
1766183 | 1766183 | 2021-09-29 | Lincoln | Missouri | 29113 | 8704 | 61 |
1767157 | 1767157 | 2021-09-29 | Bedford | Tennessee | 47003 | 8704 | 148 |
1740276 | 1740276 | 2021-09-21 | Lewis and Clark | Montana | 30049 | 8704 | 98 |
1607437 | 1607437 | 2021-08-11 | Sampson | North Carolina | 37163 | 8704 | 115 |
1599465 | 1599465 | 2021-08-09 | Rockdale | Georgia | 13247 | 8704 | 182 |
1552659 | 1552659 | 2021-07-25 | Darlington | South Carolina | 45031 | 8704 | 183 |
1549412 | 1549412 | 2021-07-24 | Darlington | South Carolina | 45031 | 8704 | 183 |
1546165 | 1546165 | 2021-07-23 | Darlington | South Carolina | 45031 | 8704 | 183 |
1475161 | 1475161 | 2021-07-01 | Walker | Texas | 48471 | 8704 | 133 |
1357964 | 1357964 | 2021-05-26 | Lincoln | South Dakota | 46083 | 8704 | 77 |
1223961 | 1223961 | 2021-04-15 | Cascade | Montana | 30013 | 8704 | 167 |
1183389 | 1183389 | 2021-04-03 | DeKalb | Alabama | 1049 | 8704 | 181 |
1130614 | 1130614 | 2021-03-17 | Oconee | South Carolina | 45073 | 8704 | 132 |
1070283 | 1070283 | 2021-02-27 | Unknown | Guam | 8704 | 131 | |
925970 | 925970 | 2021-01-13 | Fayette | Pennsylvania | 42051 | 8704 | 160 |
877605 | 877605 | 2020-12-29 | Sevier | Tennessee | 47155 | 8704 | 67 |
569066 | 569066 | 2020-09-25 | Bucks | Pennsylvania | 42017 | 8704 | 607 |
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);