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

78 rows where "date" is on date 2020-09-07 and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths

state 1

  • Oklahoma · 78 ✖
Link rowid date ▲ county state fips cases deaths
510680 510680 2020-09-07 Adair Oklahoma 40001 504 10
510681 510681 2020-09-07 Alfalfa Oklahoma 40003 19 0
510682 510682 2020-09-07 Atoka Oklahoma 40005 168 1
510683 510683 2020-09-07 Beaver Oklahoma 40007 44 0
510684 510684 2020-09-07 Beckham Oklahoma 40009 135 1
510685 510685 2020-09-07 Blaine Oklahoma 40011 87 1
510686 510686 2020-09-07 Bryan Oklahoma 40013 656 3
510687 510687 2020-09-07 Caddo Oklahoma 40015 598 20
510688 510688 2020-09-07 Canadian Oklahoma 40017 1634 13
510689 510689 2020-09-07 Carter Oklahoma 40019 429 7
510690 510690 2020-09-07 Cherokee Oklahoma 40021 783 7
510691 510691 2020-09-07 Choctaw Oklahoma 40023 258 2
510692 510692 2020-09-07 Cimarron Oklahoma 40025 14 0
510693 510693 2020-09-07 Cleveland Oklahoma 40027 4511 66
510694 510694 2020-09-07 Coal Oklahoma 40029 63 0
510695 510695 2020-09-07 Comanche Oklahoma 40031 1295 11
510696 510696 2020-09-07 Cotton Oklahoma 40033 50 2
510697 510697 2020-09-07 Craig Oklahoma 40035 169 1
510698 510698 2020-09-07 Creek Oklahoma 40037 890 22
510699 510699 2020-09-07 Custer Oklahoma 40039 355 0
510700 510700 2020-09-07 Delaware Oklahoma 40041 590 22
510701 510701 2020-09-07 Dewey Oklahoma 40043 24 1
510702 510702 2020-09-07 Ellis Oklahoma 40045 6 0
510703 510703 2020-09-07 Garfield Oklahoma 40047 1165 14
510704 510704 2020-09-07 Garvin Oklahoma 40049 279 4
510705 510705 2020-09-07 Grady Oklahoma 40051 568 7
510706 510706 2020-09-07 Grant Oklahoma 40053 27 0
510707 510707 2020-09-07 Greer Oklahoma 40055 91 8
510708 510708 2020-09-07 Harmon Oklahoma 40057 40 0
510709 510709 2020-09-07 Harper Oklahoma 40059 21 0
510710 510710 2020-09-07 Haskell Oklahoma 40061 181 4
510711 510711 2020-09-07 Hughes Oklahoma 40063 236 4
510712 510712 2020-09-07 Jackson Oklahoma 40065 623 9
510713 510713 2020-09-07 Jefferson Oklahoma 40067 37 0
510714 510714 2020-09-07 Johnston Oklahoma 40069 117 2
510715 510715 2020-09-07 Kay Oklahoma 40071 365 12
510716 510716 2020-09-07 Kingfisher Oklahoma 40073 286 2
510717 510717 2020-09-07 Kiowa Oklahoma 40075 52 1
510718 510718 2020-09-07 Latimer Oklahoma 40077 117 2
510719 510719 2020-09-07 Le Flore Oklahoma 40079 749 10
510720 510720 2020-09-07 Lincoln Oklahoma 40081 328 9
510721 510721 2020-09-07 Logan Oklahoma 40083 328 1
510722 510722 2020-09-07 Love Oklahoma 40085 128 1
510723 510723 2020-09-07 Major Oklahoma 40093 57 1
510724 510724 2020-09-07 Marshall Oklahoma 40095 138 1
510725 510725 2020-09-07 Mayes Oklahoma 40097 467 10
510726 510726 2020-09-07 McClain Oklahoma 40087 627 4
510727 510727 2020-09-07 McCurtain Oklahoma 40089 1099 31
510728 510728 2020-09-07 McIntosh Oklahoma 40091 249 4
510729 510729 2020-09-07 Murray Oklahoma 40099 95 1
510730 510730 2020-09-07 Muskogee Oklahoma 40101 1465 17
510731 510731 2020-09-07 Noble Oklahoma 40103 118 2
510732 510732 2020-09-07 Nowata Oklahoma 40105 115 1
510733 510733 2020-09-07 Okfuskee Oklahoma 40107 109 3
510734 510734 2020-09-07 Oklahoma Oklahoma 40109 14272 168
510735 510735 2020-09-07 Okmulgee Oklahoma 40111 673 5
510736 510736 2020-09-07 Osage Oklahoma 40113 704 12
510737 510737 2020-09-07 Ottawa Oklahoma 40115 623 4
510738 510738 2020-09-07 Pawnee Oklahoma 40117 229 3
510739 510739 2020-09-07 Payne Oklahoma 40119 1533 5
510740 510740 2020-09-07 Pittsburg Oklahoma 40121 646 18
510741 510741 2020-09-07 Pontotoc Oklahoma 40123 264 3
510742 510742 2020-09-07 Pottawatomie Oklahoma 40125 959 9
510743 510743 2020-09-07 Pushmataha Oklahoma 40127 131 1
510744 510744 2020-09-07 Roger Mills Oklahoma 40129 14 1
510745 510745 2020-09-07 Rogers Oklahoma 40131 1436 42
510746 510746 2020-09-07 Seminole Oklahoma 40133 347 5
510747 510747 2020-09-07 Sequoyah Oklahoma 40135 632 8
510748 510748 2020-09-07 Stephens Oklahoma 40137 269 4
510749 510749 2020-09-07 Texas Oklahoma 40139 1236 7
510750 510750 2020-09-07 Tillman Oklahoma 40141 72 1
510751 510751 2020-09-07 Tulsa Oklahoma 40143 14271 139
510752 510752 2020-09-07 Unknown Oklahoma   40 0
510753 510753 2020-09-07 Wagoner Oklahoma 40145 1228 23
510754 510754 2020-09-07 Washington Oklahoma 40147 886 40
510755 510755 2020-09-07 Washita Oklahoma 40149 43 0
510756 510756 2020-09-07 Woods Oklahoma 40151 30 0
510757 510757 2020-09-07 Woodward Oklahoma 40153 123 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);