executives

2 rows where name contains "Bush"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bio_birthday (date)

id ▼ name id_bioguide id_govtrack id_icpsr_prez name_first name_last bio_birthday bio_gender id_icpsr name_suffix name_middle id_thomas name_nickname id_lis id_wikidata id_wikipedia id_cspan id_opensecrets id_votesmart id_fec id_google_entity_id id_ballotpedia id_house_history id_maplight name_official_full id_pictorial
70 George Bush B001166 402108 99908 George Bush 1924-06-12 M 11008   Herbert Walker                              
74 George Bush   412375   George Bush 1946-07-06 M     Walker       Q207 George W. Bush                    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "executives" (
   "id" INTEGER PRIMARY KEY,
   "name" TEXT,
   "id_bioguide" TEXT,
   "id_govtrack" INTEGER,
   "id_icpsr_prez" INTEGER,
   "name_first" TEXT,
   "name_last" TEXT,
   "bio_birthday" TEXT,
   "bio_gender" TEXT
, "id_icpsr" INTEGER, "name_suffix" TEXT, "name_middle" TEXT, "id_thomas" TEXT, "name_nickname" TEXT, "id_lis" TEXT, "id_wikidata" TEXT, "id_wikipedia" TEXT, "id_cspan" INTEGER, "id_opensecrets" TEXT, "id_votesmart" INTEGER, "id_fec" TEXT, "id_google_entity_id" TEXT, "id_ballotpedia" TEXT, "id_house_history" INTEGER, "id_maplight" INTEGER, "name_official_full" TEXT, "id_pictorial" INTEGER);