ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 7058 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Rhode Island 7
- Indiana 6
- Maryland 5
- Texas 5
- Kansas 3
- Ohio 3
- Virgin Islands 3
- Alabama 2
- Arkansas 2
- Idaho 2
- New York 2
- South Carolina 2
- Virginia 2
- Florida 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Minnesota 1
- Missouri 1
- Montana 1
- North Carolina 1
- Oregon 1
- Pennsylvania 1
- Tennessee 1
- Utah 1
- Washington 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468339 | 2468339 | 2022-05-03 | Cass | Minnesota | 27021 | 7058 | 80 |
2466619 | 2466619 | 2022-05-02 | Willacy | Texas | 48489 | 7058 | 130 |
2288191 | 2288191 | 2022-03-09 | St. Francis | Arkansas | 5123 | 7058 | 88 |
2260276 | 2260276 | 2022-02-28 | Dunklin | Missouri | 29069 | 7058 | 108 |
2258421 | 2258421 | 2022-02-27 | St. Thomas | Virgin Islands | 78030 | 7058 | 59 |
2255170 | 2255170 | 2022-02-26 | St. Thomas | Virgin Islands | 78030 | 7058 | 59 |
2251919 | 2251919 | 2022-02-25 | St. Thomas | Virgin Islands | 78030 | 7058 | 59 |
2141824 | 2141824 | 2022-01-23 | Poinsett | Arkansas | 5111 | 7058 | 108 |
2126161 | 2126161 | 2022-01-18 | Ripley | Indiana | 18137 | 7058 | 114 |
2128466 | 2128466 | 2022-01-18 | Island | Washington | 53029 | 7058 | 57 |
2078463 | 2078463 | 2022-01-03 | Allegany | New York | 36003 | 7058 | 138 |
2060016 | 2060016 | 2021-12-28 | Wasatch | Utah | 49051 | 7058 | 31 |
2051368 | 2051368 | 2021-12-26 | Miami | Indiana | 18103 | 7058 | 122 |
2048118 | 2048118 | 2021-12-25 | Miami | Indiana | 18103 | 7058 | 122 |
2044868 | 2044868 | 2021-12-24 | Miami | Indiana | 18103 | 7058 | 122 |
2041619 | 2041619 | 2021-12-23 | Miami | Indiana | 18103 | 7058 | 122 |
2037632 | 2037632 | 2021-12-22 | Covington | Alabama | 1039 | 7058 | 199 |
2038369 | 2038369 | 2021-12-22 | Miami | Indiana | 18103 | 7058 | 122 |
1997355 | 1997355 | 2021-12-09 | Watauga | North Carolina | 37189 | 7058 | 40 |
1990017 | 1990017 | 2021-12-07 | St. Bernard | Louisiana | 22087 | 7058 | 99 |
1975390 | 1975390 | 2021-12-02 | Medina | Texas | 48325 | 7058 | 170 |
1968191 | 1968191 | 2021-11-30 | Fulton | Ohio | 39051 | 7058 | 112 |
1856262 | 1856262 | 2021-10-27 | Macoupin | Illinois | 17117 | 7058 | 136 |
1809297 | 1809297 | 2021-10-12 | Chesterfield | South Carolina | 45025 | 7058 | 141 |
1789915 | 1789915 | 2021-10-06 | Cocke | Tennessee | 47029 | 7058 | 104 |
1790616 | 1790616 | 2021-10-06 | Sweetwater | Wyoming | 56037 | 7058 | 70 |
1786995 | 1786995 | 2021-10-05 | Wilson | Texas | 48493 | 7058 | 122 |
1783746 | 1783746 | 2021-10-04 | Wilson | Texas | 48493 | 7058 | 121 |
1594590 | 1594590 | 2021-08-07 | Scioto | Ohio | 39145 | 7058 | 109 |
1581871 | 1581871 | 2021-08-03 | Newport | Rhode Island | 44005 | 7058 | 43 |
1578622 | 1578622 | 2021-08-02 | Newport | Rhode Island | 44005 | 7058 | 43 |
1579245 | 1579245 | 2021-08-02 | Rockingham | Virginia | 51165 | 7058 | 113 |
1575374 | 1575374 | 2021-08-01 | Newport | Rhode Island | 44005 | 7058 | 43 |
1572126 | 1572126 | 2021-07-31 | Newport | Rhode Island | 44005 | 7058 | 43 |
1568878 | 1568878 | 2021-07-30 | Newport | Rhode Island | 44005 | 7058 | 43 |
1565310 | 1565310 | 2021-07-29 | Hancock | Ohio | 39063 | 7058 | 135 |
1565630 | 1565630 | 2021-07-29 | Newport | Rhode Island | 44005 | 7058 | 43 |
1562382 | 1562382 | 2021-07-28 | Newport | Rhode Island | 44005 | 7058 | 43 |
1489738 | 1489738 | 2021-07-06 | Allegany | Maryland | 24001 | 7058 | 212 |
1486491 | 1486491 | 2021-07-05 | Allegany | Maryland | 24001 | 7058 | 212 |
1483245 | 1483245 | 2021-07-04 | Allegany | Maryland | 24001 | 7058 | 212 |
1479999 | 1479999 | 2021-07-03 | Allegany | Maryland | 24001 | 7058 | 212 |
1476752 | 1476752 | 2021-07-02 | Allegany | Maryland | 24001 | 7058 | 212 |
1464205 | 1464205 | 2021-06-28 | Lewis and Clark | Montana | 30049 | 7058 | 92 |
1427891 | 1427891 | 2021-06-17 | Christian | Kentucky | 21047 | 7058 | 107 |
1339594 | 1339594 | 2021-05-21 | Monroe | Florida | 12087 | 7058 | 50 |
1202279 | 1202279 | 2021-04-08 | Coryell | Texas | 48099 | 7058 | 84 |
1198676 | 1198676 | 2021-04-07 | Somerset | Pennsylvania | 42111 | 7058 | 191 |
1173687 | 1173687 | 2021-03-31 | Walker | Alabama | 1127 | 7058 | 274 |
1176066 | 1176066 | 2021-03-31 | Kershaw | South Carolina | 45055 | 7058 | 133 |
1034934 | 1034934 | 2021-02-16 | Butler | Kansas | 20015 | 7058 | 52 |
1031688 | 1031688 | 2021-02-15 | Butler | Kansas | 20015 | 7058 | 52 |
1032637 | 1032637 | 2021-02-15 | Chautauqua | New York | 36013 | 7058 | 119 |
1034008 | 1034008 | 2021-02-15 | Wood | Wisconsin | 55141 | 7058 | 84 |
971371 | 971371 | 2021-01-27 | Umatilla | Oregon | 41059 | 7058 | 74 |
940467 | 940467 | 2021-01-18 | Bannock | Idaho | 16005 | 7058 | 78 |
937222 | 937222 | 2021-01-17 | Bannock | Idaho | 16005 | 7058 | 78 |
673524 | 673524 | 2020-10-27 | Chesterfield | Virginia | 51041 | 7058 | 106 |
454537 | 454537 | 2020-08-21 | Johnson | Kansas | 20091 | 7058 | 110 |
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);