ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where county = "Comanche", deaths = 11 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
513928 | 513928 | 2020-09-08 | Comanche | Oklahoma | 40031 | 1304 | 11 |
510695 | 510695 | 2020-09-07 | Comanche | Oklahoma | 40031 | 1295 | 11 |
507462 | 507462 | 2020-09-06 | Comanche | Oklahoma | 40031 | 1293 | 11 |
504230 | 504230 | 2020-09-05 | Comanche | Oklahoma | 40031 | 1293 | 11 |
500996 | 500996 | 2020-09-04 | Comanche | Oklahoma | 40031 | 1286 | 11 |
497762 | 497762 | 2020-09-03 | Comanche | Oklahoma | 40031 | 1283 | 11 |
494529 | 494529 | 2020-09-02 | Comanche | Oklahoma | 40031 | 1280 | 11 |
491295 | 491295 | 2020-09-01 | Comanche | Oklahoma | 40031 | 1261 | 11 |
488062 | 488062 | 2020-08-31 | Comanche | Oklahoma | 40031 | 1251 | 11 |
484829 | 484829 | 2020-08-30 | Comanche | Oklahoma | 40031 | 1225 | 11 |
481594 | 481594 | 2020-08-29 | Comanche | Oklahoma | 40031 | 1218 | 11 |
478360 | 478360 | 2020-08-28 | Comanche | Oklahoma | 40031 | 1212 | 11 |
475127 | 475127 | 2020-08-27 | Comanche | Oklahoma | 40031 | 1209 | 11 |
471893 | 471893 | 2020-08-26 | Comanche | Oklahoma | 40031 | 1203 | 11 |
468661 | 468661 | 2020-08-25 | Comanche | Oklahoma | 40031 | 1181 | 11 |
465433 | 465433 | 2020-08-24 | Comanche | Oklahoma | 40031 | 1151 | 11 |
462204 | 462204 | 2020-08-23 | Comanche | Oklahoma | 40031 | 1149 | 11 |
458976 | 458976 | 2020-08-22 | Comanche | Oklahoma | 40031 | 999 | 11 |
455748 | 455748 | 2020-08-21 | Comanche | Oklahoma | 40031 | 987 | 11 |
452520 | 452520 | 2020-08-20 | Comanche | Oklahoma | 40031 | 923 | 11 |
449292 | 449292 | 2020-08-19 | Comanche | Oklahoma | 40031 | 905 | 11 |
446064 | 446064 | 2020-08-18 | Comanche | Oklahoma | 40031 | 892 | 11 |
442838 | 442838 | 2020-08-17 | Comanche | Oklahoma | 40031 | 884 | 11 |
439611 | 439611 | 2020-08-16 | Comanche | Oklahoma | 40031 | 884 | 11 |
436386 | 436386 | 2020-08-15 | Comanche | Oklahoma | 40031 | 884 | 11 |
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);