ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where cases = 1003 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
state 1
- Oklahoma · 16 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1172589 | 1172589 | 2021-03-30 | Pushmataha | Oklahoma | 40127 | 1003 | 14 |
1169342 | 1169342 | 2021-03-29 | Pushmataha | Oklahoma | 40127 | 1003 | 14 |
1166094 | 1166094 | 2021-03-28 | Pushmataha | Oklahoma | 40127 | 1003 | 14 |
1162846 | 1162846 | 2021-03-27 | Pushmataha | Oklahoma | 40127 | 1003 | 14 |
1159597 | 1159597 | 2021-03-26 | Pushmataha | Oklahoma | 40127 | 1003 | 14 |
1156350 | 1156350 | 2021-03-25 | Pushmataha | Oklahoma | 40127 | 1003 | 14 |
1153103 | 1153103 | 2021-03-24 | Pushmataha | Oklahoma | 40127 | 1003 | 14 |
1094606 | 1094606 | 2021-03-06 | Blaine | Oklahoma | 40011 | 1003 | 8 |
1091360 | 1091360 | 2021-03-05 | Blaine | Oklahoma | 40011 | 1003 | 8 |
932322 | 932322 | 2021-01-15 | Alfalfa | Oklahoma | 40003 | 1003 | 5 |
614385 | 614385 | 2020-10-09 | Ottawa | Oklahoma | 40115 | 1003 | 8 |
611133 | 611133 | 2020-10-08 | McClain | Oklahoma | 40087 | 1003 | 7 |
601420 | 601420 | 2020-10-05 | Pittsburg | Oklahoma | 40121 | 1003 | 20 |
585158 | 585158 | 2020-09-30 | Bryan | Oklahoma | 40013 | 1003 | 5 |
452578 | 452578 | 2020-08-20 | Wagoner | Oklahoma | 40145 | 1003 | 23 |
298638 | 298638 | 2020-07-03 | Cleveland | Oklahoma | 40027 | 1003 | 40 |
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);