home / legislators / executives

Menu
  • GraphQL API

executives

Table actions Table actions
  • GraphQL API for executives

2 rows where name contains "Bush"

Clear filters
View and edit SQL

Export data

executives

Filtered rows where name contains "Bush"

TSV All 2 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 2 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 2 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 2 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 2 rows
    One JSON object per line
    View Download
  • JSON object All 2 rows
    Rows keyed by their primary key
    View Download

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                    
Table schema
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);
Powered by Datasette · How this site works · Code of conduct