Skip to content

Instantly share code, notes, and snippets.

@LindsayYoung

LindsayYoung/gist:564a943f27269f6929ec

Last active August 29, 2015 14:08
Show Gist options
  • Save LindsayYoung/564a943f27269f6929ec to your computer and use it in GitHub Desktop.
Save LindsayYoung/564a943f27269f6929ec to your computer and use it in GitHub Desktop.
Download ZIP
Original_obama_api_output
Raw
gistfile1.json
[
{
"affiliated_committees": [],
"cand_id": "H0IL01087",
"cand_sk": 10076990,
"dimcandoffice": [
{
"cand_election_yr": 2000,
"dimoffice": {
"expire_date": null,
"load_date": "2014-09-03 11:27:22",
"office_district": "01",
"office_sk": 10000162,
"office_state": "IL",
"office_tp": "H",
"office_tp_desc": "House"
},
"dimparty": {
"expire_date": null,
"load_date": "2014-09-03 11:27:52",
"party_affiliation": "DEM",
"party_affiliation_desc": "Democratic Party",
"party_sk": 10000011
}
}
],
"dimcandproperties": [
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": null,
"cand_ici_desc": null,
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK H",
"cand_prefix": null,
"cand_sk": 10076990,
"cand_st": "IL",
"cand_st1": "5450-1 S EAST VIEW PARK",
"cand_st2": null,
"cand_status_cd": "C",
"cand_status_desc": "Statutory candidate",
"cand_suffix": null,
"cand_zip": "60615",
"candproperties_sk": 10182975,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 7959591,
"form_tp": "F2",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": null,
"cand_ici_desc": null,
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK H",
"cand_prefix": null,
"cand_sk": 10076990,
"cand_st": "IL",
"cand_st1": "5450-1 S EAST VIEW PARK",
"cand_st2": null,
"cand_status_cd": "P",
"cand_status_desc": "Statutory candidate in a prior cycle",
"cand_suffix": null,
"cand_zip": "60615",
"candproperties_sk": 10182976,
"expire_date": null,
"form_sk": 7959592,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
}
],
"dimcandstatusici": [],
"expire_date": null,
"form_sk": 7959591,
"form_tp": "F2",
"load_date": "2014-09-18 13:28:23",
"primary_committee": [
{
"cmte_id": "C00347583"
}
]
},
{
"affiliated_committees": [
{
"cmte_id": "C00431023"
},
{
"cmte_id": "C00431130"
},
{
"cmte_id": "C00431486"
},
{
"cmte_id": "C00434712"
},
{
"cmte_id": "C00448027"
},
{
"cmte_id": "C00448480"
},
{
"cmte_id": "C00450833"
},
{
"cmte_id": "C00451773"
},
{
"cmte_id": "C00452979"
},
{
"cmte_id": "C00455113"
},
{
"cmte_id": "C00434357"
},
{
"cmte_id": "C00443929"
},
{
"cmte_id": "C00446179"
},
{
"cmte_id": "C00446435"
},
{
"cmte_id": "C00454587"
},
{
"cmte_id": "C00455402"
},
{
"cmte_id": "C00455527"
},
{
"cmte_id": "C00455949"
},
{
"cmte_id": "C00452391"
},
{
"cmte_id": "C00455030"
},
{
"cmte_id": "C00450809"
},
{
"cmte_id": "C00434357"
},
{
"cmte_id": "C00446435"
},
{
"cmte_id": "C00450809"
},
{
"cmte_id": "C00455949"
},
{
"cmte_id": "C00462176"
},
{
"cmte_id": "C00496992"
},
{
"cmte_id": "C00519694"
},
{
"cmte_id": "C00528364"
},
{
"cmte_id": "C00529842"
}
],
"cand_id": "P80003338",
"cand_sk": 10079532,
"dimcandoffice": [
{
"cand_election_yr": 2012,
"dimoffice": {
"expire_date": null,
"load_date": "2014-09-03 11:27:10",
"office_district": null,
"office_sk": 10000000,
"office_state": "US",
"office_tp": "P",
"office_tp_desc": "President"
},
"dimparty": {
"expire_date": null,
"load_date": "2014-09-03 11:27:52",
"party_affiliation": "DEM",
"party_affiliation_desc": "Democratic Party",
"party_sk": 10000011
}
},
{
"cand_election_yr": 2008,
"dimoffice": {
"expire_date": null,
"load_date": "2014-09-03 11:27:10",
"office_district": null,
"office_sk": 10000000,
"office_state": "US",
"office_tp": "P",
"office_tp_desc": "President"
},
"dimparty": {
"expire_date": null,
"load_date": "2014-09-03 11:27:52",
"party_affiliation": "DEM",
"party_affiliation_desc": "Democratic Party",
"party_sk": 10000011
}
}
],
"dimcandproperties": [
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": null,
"cand_ici_desc": null,
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "5450 SOUTH EAST VIEW PARK",
"cand_st2": null,
"cand_status_cd": "N",
"cand_status_desc": "Not yet a statutory candidate",
"cand_suffix": null,
"cand_zip": "60615",
"candproperties_sk": 10254086,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8057067,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": null,
"cand_ici_desc": null,
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "233 NORTH MICHIGAN AVE STE 1720",
"cand_st2": null,
"cand_status_cd": "N",
"cand_status_desc": "Not yet a statutory candidate",
"cand_suffix": null,
"cand_zip": "60601",
"candproperties_sk": 10254087,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8057068,
"form_tp": "F2",
"gen_pers_funds_decl": 0.0,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": 0.0
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "O",
"cand_ici_desc": "Open (Open seat)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "233 NORTH MICHIGAN AVE STE 1720",
"cand_st2": null,
"cand_status_cd": "N",
"cand_status_desc": "Not yet a statutory candidate",
"cand_suffix": null,
"cand_zip": "60601",
"candproperties_sk": 10254088,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8057069,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "O",
"cand_ici_desc": "Open (Open seat)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "233 NORTH MICHIGAN AVE STE 1720",
"cand_st2": null,
"cand_status_cd": "C",
"cand_status_desc": "Statutory candidate",
"cand_suffix": null,
"cand_zip": "60601",
"candproperties_sk": 10254089,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8057070,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "O",
"cand_ici_desc": "Open (Open seat)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "PO BOX 8102",
"cand_st2": null,
"cand_status_cd": "C",
"cand_status_desc": "Statutory candidate",
"cand_suffix": null,
"cand_zip": "60680",
"candproperties_sk": 10254090,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8057071,
"form_tp": "F2",
"gen_pers_funds_decl": 0.0,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": 0.0
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": null,
"cand_ici_desc": null,
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "PO BOX 8102",
"cand_st2": null,
"cand_status_cd": "N",
"cand_status_desc": "Not yet a statutory candidate",
"cand_suffix": null,
"cand_zip": "60680",
"candproperties_sk": 10254091,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8057073,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "I",
"cand_ici_desc": "Incumbent (Current seat holder running for election)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "PO BOX 8102",
"cand_st2": null,
"cand_status_cd": "N",
"cand_status_desc": "Not yet a statutory candidate",
"cand_suffix": null,
"cand_zip": "60680",
"candproperties_sk": 10254092,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8057076,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "I",
"cand_ici_desc": "Incumbent (Current seat holder running for election)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10079532,
"cand_st": "IL",
"cand_st1": "PO BOX 8102",
"cand_st2": null,
"cand_status_cd": "C",
"cand_status_desc": "Statutory candidate",
"cand_suffix": null,
"cand_zip": "60680",
"candproperties_sk": 10254093,
"expire_date": null,
"form_sk": 8057077,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
}
],
"dimcandstatusici": [
{
"cand_inactive_flg": null,
"cand_sk": 10079532,
"cand_status": "P",
"candstatusici_sk": 7621871,
"election_yr": 2008.0,
"expire_date": null,
"ici_code": "O",
"load_date": "2014-09-18 13:28:39"
},
{
"cand_inactive_flg": null,
"cand_sk": 10079532,
"cand_status": "C",
"candstatusici_sk": 7621872,
"election_yr": 2012.0,
"expire_date": null,
"ici_code": "I",
"load_date": "2014-09-18 13:28:39"
}
],
"expire_date": null,
"form_sk": 8057066,
"form_tp": "F2Z",
"load_date": "2014-09-18 13:28:23",
"primary_committee": [
{
"cmte_id": "C00431445"
},
{
"cmte_id": "C00462176"
},
{
"cmte_id": "C00431445"
}
]
},
{
"affiliated_committees": [],
"cand_id": "S4IL00180",
"cand_sk": 10100585,
"dimcandoffice": [
{
"cand_election_yr": 2010,
"dimoffice": {
"expire_date": null,
"load_date": "2014-09-03 11:27:22",
"office_district": null,
"office_sk": 10000161,
"office_state": "IL",
"office_tp": "S",
"office_tp_desc": "Senate"
},
"dimparty": {
"expire_date": null,
"load_date": "2014-09-03 11:27:52",
"party_affiliation": "DEM",
"party_affiliation_desc": "Democratic Party",
"party_sk": 10000011
}
},
{
"cand_election_yr": 2004,
"dimoffice": {
"expire_date": null,
"load_date": "2014-09-03 11:27:22",
"office_district": null,
"office_sk": 10000161,
"office_state": "IL",
"office_tp": "S",
"office_tp_desc": "Senate"
},
"dimparty": {
"expire_date": null,
"load_date": "2014-09-03 11:27:52",
"party_affiliation": "DEM",
"party_affiliation_desc": "Democratic Party",
"party_sk": 10000011
}
}
],
"dimcandproperties": [
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": null,
"cand_ici_desc": null,
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10100585,
"cand_st": "IL",
"cand_st1": "5450-1 S EAST VIEW PARK",
"cand_st2": null,
"cand_status_cd": "F",
"cand_status_desc": "Statutory candidate for future election",
"cand_suffix": null,
"cand_zip": "60615",
"candproperties_sk": 10260797,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8066361,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "O",
"cand_ici_desc": "Open (Open seat)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10100585,
"cand_st": "IL",
"cand_st1": null,
"cand_st2": null,
"cand_status_cd": "N",
"cand_status_desc": "Not yet a statutory candidate",
"cand_suffix": null,
"cand_zip": null,
"candproperties_sk": 10260798,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8066362,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": null,
"cand_ici_desc": null,
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10100585,
"cand_st": "IL",
"cand_st1": "5450 S EAST VIEW PARK",
"cand_st2": null,
"cand_status_cd": "F",
"cand_status_desc": "Statutory candidate for future election",
"cand_suffix": null,
"cand_zip": "60615",
"candproperties_sk": 10260799,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8066364,
"form_tp": "F2",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "O",
"cand_ici_desc": "Open (Open seat)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10100585,
"cand_st": "IL",
"cand_st1": null,
"cand_st2": null,
"cand_status_cd": "C",
"cand_status_desc": "Statutory candidate",
"cand_suffix": null,
"cand_zip": null,
"candproperties_sk": 10260800,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8066366,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "I",
"cand_ici_desc": "Incumbent (Current seat holder running for election)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10100585,
"cand_st": "IL",
"cand_st1": null,
"cand_st2": null,
"cand_status_cd": "F",
"cand_status_desc": "Statutory candidate for future election",
"cand_suffix": null,
"cand_zip": null,
"candproperties_sk": 10260801,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8066367,
"form_tp": "F2Z",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "I",
"cand_ici_desc": "Incumbent (Current seat holder running for election)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10100585,
"cand_st": "IL",
"cand_st1": "5450 SOUTH EAST VIEW PARK",
"cand_st2": null,
"cand_status_cd": "F",
"cand_status_desc": "Statutory candidate for future election",
"cand_suffix": null,
"cand_zip": "60615",
"candproperties_sk": 10260802,
"expire_date": "2014-09-18 00:00:00",
"form_sk": 8066368,
"form_tp": "F2",
"gen_pers_funds_decl": 0.0,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": 0.0
},
{
"cand_city": "CHICAGO",
"cand_f_nm": null,
"cand_ici_cd": "I",
"cand_ici_desc": "Incumbent (Current seat holder running for election)",
"cand_l_nm": null,
"cand_m_nm": null,
"cand_nm": "OBAMA, BARACK",
"cand_prefix": null,
"cand_sk": 10100585,
"cand_st": "IL",
"cand_st1": "5450 SOUTH EAST VIEW PARK",
"cand_st2": null,
"cand_status_cd": "C",
"cand_status_desc": "Statutory candidate",
"cand_suffix": null,
"cand_zip": "60615",
"candproperties_sk": 10260803,
"expire_date": null,
"form_sk": 8066371,
"form_tp": "F2",
"gen_pers_funds_decl": null,
"load_date": "2014-09-18 13:16:58",
"prim_pers_funds_decl": null
}
],
"dimcandstatusici": [
{
"cand_inactive_flg": "Y",
"cand_sk": 10100585,
"cand_status": "C",
"candstatusici_sk": 7623194,
"election_yr": 2010.0,
"expire_date": null,
"ici_code": "I",
"load_date": "2014-09-18 13:28:39"
},
{
"cand_inactive_flg": null,
"cand_sk": 10100585,
"cand_status": "C",
"candstatusici_sk": 7634560,
"election_yr": 2004.0,
"expire_date": null,
"ici_code": null,
"load_date": "2014-09-18 13:28:39"
}
],
"expire_date": null,
"form_sk": 8066360,
"form_tp": "F2",
"load_date": "2014-09-18 13:28:23",
"primary_committee": [
{
"cmte_id": "C00381442"
},
{
"cmte_id": "C00381442"
},
{
"cmte_id": "C00402958"
},
{
"cmte_id": "C00405753"
},
{
"cmte_id": "C00402958"
},
{
"cmte_id": "C00405753"
},
{
"cmte_id": "C00381442"
},
{
"cmte_id": "C00411934"
}
]
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment