ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

38 rows where date = "2020-03-27" and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases, deaths, date (date)

state 1

  • Oklahoma · 38 ✖
Link rowid date ▲ county state fips cases deaths
15256 15256 2020-03-27 Adair Oklahoma 40001 3 0
15257 15257 2020-03-27 Bryan Oklahoma 40013 1 0
15258 15258 2020-03-27 Caddo Oklahoma 40015 1 0
15259 15259 2020-03-27 Canadian Oklahoma 40017 11 0
15260 15260 2020-03-27 Carter Oklahoma 40019 1 0
15261 15261 2020-03-27 Cherokee Oklahoma 40021 1 0
15262 15262 2020-03-27 Choctaw Oklahoma 40023 1 0
15263 15263 2020-03-27 Cleveland Oklahoma 40027 39 3
15264 15264 2020-03-27 Comanche Oklahoma 40031 6 0
15265 15265 2020-03-27 Craig Oklahoma 40035 1 0
15266 15266 2020-03-27 Creek Oklahoma 40037 14 1
15267 15267 2020-03-27 Custer Oklahoma 40039 3 0
15268 15268 2020-03-27 Delaware Oklahoma 40041 2 0
15269 15269 2020-03-27 Garvin Oklahoma 40049 2 0
15270 15270 2020-03-27 Grady Oklahoma 40051 2 0
15271 15271 2020-03-27 Jackson Oklahoma 40065 1 0
15272 15272 2020-03-27 Kay Oklahoma 40071 17 0
15273 15273 2020-03-27 Latimer Oklahoma 40077 1 0
15274 15274 2020-03-27 Lincoln Oklahoma 40081 3 0
15275 15275 2020-03-27 Logan Oklahoma 40083 3 0
15276 15276 2020-03-27 Mayes Oklahoma 40097 2 0
15277 15277 2020-03-27 McClain Oklahoma 40087 2 0
15278 15278 2020-03-27 Muskogee Oklahoma 40101 5 0
15279 15279 2020-03-27 Noble Oklahoma 40103 3 0
15280 15280 2020-03-27 Oklahoma Oklahoma 40109 94 2
15281 15281 2020-03-27 Okmulgee Oklahoma 40111 2 0
15282 15282 2020-03-27 Osage Oklahoma 40113 5 0
15283 15283 2020-03-27 Ottawa Oklahoma 40115 1 0
15284 15284 2020-03-27 Pawnee Oklahoma 40117 14 1
15285 15285 2020-03-27 Payne Oklahoma 40119 7 0
15286 15286 2020-03-27 Pittsburg Oklahoma 40121 2 0
15287 15287 2020-03-27 Pontotoc Oklahoma 40123 2 0
15288 15288 2020-03-27 Pottawatomie Oklahoma 40125 2 0
15289 15289 2020-03-27 Sequoyah Oklahoma 40135 1 0
15290 15290 2020-03-27 Stephens Oklahoma 40137 1 0
15291 15291 2020-03-27 Tulsa Oklahoma 40143 49 1
15292 15292 2020-03-27 Wagoner Oklahoma 40145 8 0
15293 15293 2020-03-27 Washington Oklahoma 40147 9 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);