ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 9515 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Florida 7
- Oklahoma 7
- Georgia 4
- Indiana 2
- Maryland 2
- Michigan 2
- New Mexico 2
- New York 2
- Puerto Rico 2
- Alabama 1
- California 1
- Hawaii 1
- Kentucky 1
- Louisiana 1
- Missouri 1
- North Carolina 1
- Ohio 1
- Pennsylvania 1
- Texas 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2377706 | 2377706 | 2022-04-05 | Franklin | New York | 36033 | 9515 | 44 |
2356716 | 2356716 | 2022-03-30 | Baldwin | Georgia | 13009 | 9515 | 232 |
2287885 | 2287885 | 2022-03-08 | Logan | West Virginia | 54045 | 9515 | 173 |
2199370 | 2199370 | 2022-02-09 | Trujillo Alto | Puerto Rico | 72139 | 9515 | |
2131469 | 2131469 | 2022-01-19 | Rusk | Texas | 48401 | 9515 | 192 |
2103154 | 2103154 | 2022-01-11 | Tift | Georgia | 13277 | 9515 | 189 |
2081121 | 2081121 | 2022-01-04 | Branch | Michigan | 26023 | 9515 | 167 |
2077869 | 2077869 | 2022-01-03 | Branch | Michigan | 26023 | 9515 | 167 |
1899804 | 1899804 | 2021-11-09 | Lee | North Carolina | 37105 | 9515 | 110 |
1854203 | 1854203 | 2021-10-26 | Valencia | New Mexico | 35061 | 9515 | 139 |
1778181 | 1778181 | 2021-10-03 | Maui | Hawaii | 15009 | 9515 | 87 |
1726739 | 1726739 | 2021-09-17 | Pulaski | Kentucky | 21199 | 9515 | 157 |
1672627 | 1672627 | 2021-08-31 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1669379 | 1669379 | 2021-08-30 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1666132 | 1666132 | 2021-08-29 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1662884 | 1662884 | 2021-08-28 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1659636 | 1659636 | 2021-08-27 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1656387 | 1656387 | 2021-08-26 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1653140 | 1653140 | 2021-08-25 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1648413 | 1648413 | 2021-08-24 | Hancock | Indiana | 18059 | 9515 | 159 |
1581274 | 1581274 | 2021-08-03 | Chaves | New Mexico | 35005 | 9515 | 173 |
1472686 | 1472686 | 2021-07-01 | Sumter | Florida | 12119 | 9515 | 284 |
1469440 | 1469440 | 2021-06-30 | Sumter | Florida | 12119 | 9515 | 284 |
1466195 | 1466195 | 2021-06-29 | Sumter | Florida | 12119 | 9515 | 284 |
1462950 | 1462950 | 2021-06-28 | Sumter | Florida | 12119 | 9515 | 284 |
1459705 | 1459705 | 2021-06-27 | Sumter | Florida | 12119 | 9515 | 284 |
1456460 | 1456460 | 2021-06-26 | Sumter | Florida | 12119 | 9515 | 284 |
1453215 | 1453215 | 2021-06-25 | Sumter | Florida | 12119 | 9515 | 284 |
1415092 | 1415092 | 2021-06-13 | Carroll | Maryland | 24013 | 9515 | 253 |
1357007 | 1357007 | 2021-05-26 | Jasper | Missouri | 29097 | 9515 | 129 |
1183761 | 1183761 | 2021-04-03 | Barrow | Georgia | 13013 | 9515 | 127 |
1164348 | 1164348 | 2021-03-28 | Jackson | Georgia | 13157 | 9515 | 142 |
1095724 | 1095724 | 2021-03-07 | Elmore | Alabama | 1051 | 9515 | 190 |
995804 | 995804 | 2021-02-04 | Delaware | Indiana | 18035 | 9515 | 167 |
971455 | 971455 | 2021-01-27 | Bayamon | Puerto Rico | 72021 | 9515 | |
906501 | 906501 | 2021-01-07 | Franklin | Pennsylvania | 42055 | 9515 | 253 |
890095 | 890095 | 2021-01-02 | Medina | Ohio | 39103 | 9515 | 114 |
759328 | 759328 | 2020-11-23 | Ouachita | Louisiana | 22073 | 9515 | 203 |
732405 | 732405 | 2020-11-15 | Kings | California | 6031 | 9515 | 87 |
721098 | 721098 | 2020-11-11 | Monroe | New York | 36055 | 9515 | 264 |
545333 | 545333 | 2020-09-18 | Anne Arundel | Maryland | 24003 | 9515 | 242 |
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);