ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 6797 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Georgia 8
- Indiana 4
- Arkansas 3
- Maryland 2
- Tennessee 2
- West Virginia 2
- Wisconsin 2
- California 1
- Florida 1
- Illinois 1
- Iowa 1
- Kentucky 1
- Michigan 1
- Missouri 1
- New York 1
- North Carolina 1
- North Dakota 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Texas 1
- Utah 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496181 | 2496181 | 2022-05-11 | Hancock | West Virginia | 54029 | 6797 | 142 |
2466105 | 2466105 | 2022-05-02 | Corozal | Puerto Rico | 72047 | 6797 | |
2324310 | 2324310 | 2022-03-20 | Sumter | Georgia | 13261 | 6797 | 163 |
2321056 | 2321056 | 2022-03-19 | Sumter | Georgia | 13261 | 6797 | 163 |
2317802 | 2317802 | 2022-03-18 | Sumter | Georgia | 13261 | 6797 | 163 |
2314549 | 2314549 | 2022-03-17 | Sumter | Georgia | 13261 | 6797 | 163 |
2311296 | 2311296 | 2022-03-16 | Sumter | Georgia | 13261 | 6797 | 163 |
2268915 | 2268915 | 2022-03-03 | Chattahoochee | Georgia | 13053 | 6797 | 21 |
2246455 | 2246455 | 2022-02-24 | Clay | Indiana | 18021 | 6797 | 85 |
2248895 | 2248895 | 2022-02-24 | Wyoming | West Virginia | 54109 | 6797 | 93 |
2213758 | 2213758 | 2022-02-14 | Toombs | Georgia | 13279 | 6797 | 184 |
2160601 | 2160601 | 2022-01-28 | Cooke | Texas | 48097 | 6797 | 118 |
2128555 | 2128555 | 2022-01-18 | Clark | Wisconsin | 55019 | 6797 | 110 |
2102574 | 2102574 | 2022-01-10 | Oneida | Wisconsin | 55085 | 6797 | 116 |
2088604 | 2088604 | 2022-01-06 | Coos | Oregon | 41011 | 6797 | 123 |
2031228 | 2031228 | 2021-12-20 | Boone | Arkansas | 5009 | 6797 | 134 |
1844674 | 1844674 | 2021-10-23 | Auglaize | Ohio | 39011 | 6797 | 99 |
1832195 | 1832195 | 2021-10-19 | Marshall | Tennessee | 47117 | 6797 | 84 |
1789422 | 1789422 | 2021-10-06 | Stark | North Dakota | 38089 | 6797 | 55 |
1786663 | 1786663 | 2021-10-05 | Cheatham | Tennessee | 47021 | 6797 | 65 |
1671167 | 1671167 | 2021-08-31 | Marshall | Indiana | 18099 | 6797 | 122 |
1466571 | 1466571 | 2021-06-29 | Morgan | Indiana | 18109 | 6797 | 146 |
1356526 | 1356526 | 2021-05-26 | Laurel | Kentucky | 21125 | 6797 | 74 |
1168982 | 1168982 | 2021-03-29 | Chemung | New York | 36015 | 6797 | 131 |
1140802 | 1140802 | 2021-03-20 | Tooele | Utah | 49045 | 6797 | 39 |
1135922 | 1135922 | 2021-03-19 | Eaton | Michigan | 26045 | 6797 | 159 |
1123988 | 1123988 | 2021-03-15 | Somerset | Pennsylvania | 42111 | 6797 | 186 |
1101388 | 1101388 | 2021-03-08 | Kershaw | South Carolina | 45055 | 6797 | 128 |
1095433 | 1095433 | 2021-03-06 | Hanover | Virginia | 51085 | 6797 | 138 |
1087187 | 1087187 | 2021-03-04 | Wicomico | Maryland | 24045 | 6797 | 143 |
1047741 | 1047741 | 2021-02-20 | Grant | Indiana | 18053 | 6797 | 162 |
998513 | 998513 | 2021-02-05 | White | Arkansas | 5145 | 6797 | 96 |
935366 | 935366 | 2021-01-16 | Henderson | North Carolina | 37089 | 6797 | 98 |
897958 | 897958 | 2021-01-05 | Sutter | California | 6101 | 6797 | 62 |
884882 | 884882 | 2021-01-01 | Jefferson | Arkansas | 5069 | 6797 | 129 |
842949 | 842949 | 2020-12-19 | Bartow | Georgia | 13015 | 6797 | 113 |
801006 | 801006 | 2020-12-06 | LaSalle | Illinois | 17099 | 6797 | 153 |
733418 | 733418 | 2020-11-15 | Howard | Maryland | 24027 | 6797 | 132 |
697325 | 697325 | 2020-11-04 | Black Hawk | Iowa | 19013 | 6797 | 106 |
548967 | 548967 | 2020-09-19 | St. Louis city | Missouri | 29510 | 6797 | 197 |
453924 | 453924 | 2020-08-21 | Brevard | Florida | 12009 | 6797 | 194 |
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);