Updating sample files by palewire

ACRONYMS_CD.TSV

ACRONYM	STANDS_FOR	EFFECT_DT	A_DESC
(ACORN)		05/15/2008	
(CELL)	*	02/16/1995	LEGACY CAMPAIGN DATA
(D.I.E.T.)	*	12/01/1990	LEGACY CAMPAIGN DATA
(GEICO)	*	12/01/1990	LEGACY CAMPAIGN DATA
(H.O.P.E.) (P.G.)	*	02/06/1995	LEGACY CAMPAIGN DATA

ADDRESS_CD.TSV

ADRID	CITY	ST	ZIP4	PHON	FAX	EMAIL
1005261	POMONA	CA	917680000	9096201240		
1001841	SAN PEDRO	CA	907310000	2138689711		
1003147	POWAY	CA	920640000	6197487790		
1000843	SAN FRANCISCO	CA	941020000	4155573865		
1001914	LAGUNA BEACH	CA	926510000	7148343734

BALLOT_MEASURES_CD.TSV

ELECTION_DATE	FILER_ID	MEASURE_NO	MEASURE_NAME	MEASURE_SHORT_NAME	JURISDICTION
5/19/2009 12:00:00 AM	1316047	1B	PROPOSITION 001B - EDUCATION FUNDING. PAYMENT PLAN.	EDUCATION FUNDING	Statewide
5/19/2009 12:00:00 AM	1316048	1C	PROPOSITION 001C -  LOTTERY MODERNIZATION ACT.	LOTTERY MODERNIZATION ACT	Statewide
5/19/2009 12:00:00 AM	1316060	1D	PROPOSITION 001D - PROTECTS CHILDREN'S SERVICES FUNDING. HELPS BALANCE STATE BUDGET.	PROTECTS CHILDREN'S SERVICES FUNDING	Statewide
5/19/2009 12:00:00 AM	1316061	1E	PROPOSITION 001E - MENTAL HEALTH SERVICES FUNDING. TEMPORARY REALLOCATION. HELPS BALANCE STATE BUDGET.	MENTAL HEALTH SERVICES FUNDING	Statewide
5/19/2009 12:00:00 AM	1316062	1F	PROPOSITION 001F - ELECTED OFFICIALS' SALARIES. PREVENTS PAY INCREASES DURING BUDGET DEFICIT YEARS.	ELECTED OFFICIALS' SALARIES	Statewide

BallotMeasureContest.csv

id,name,division_id,election_id,description,requirement,classification,runoff_for_contest_id,created_at,updated_at,extras,locked_fields
ocd-contest/0ba0ecc5-5fb5-47a4-9750-4d6187b54f29,PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-12 SCHOOL AND COMMUNITY COLLEGE FACILITIES. INITIATIVE STATUTORY AMENDMENT.,ocd-division/country:us/state:ca,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,"",50% plus one vote,initiative,,2017-08-07 18:45:31.013965+00,2017-08-07 18:45:31.013986+00,{},{}
ocd-contest/3b396a06-3221-4332-a7f8-3fbf23e4f3e3,PROPOSITION 052 - STATE FEES ON HOSPITALS. FEDERAL MEDI-CAL MATCHING FUNDS. INITIATIVE STATUTORY AND CONSTITUTIONAL AMENDMENT.,ocd-division/country:us/state:ca,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,"",50% plus one vote,initiative,,2017-08-07 18:45:31.033359+00,2017-08-07 18:45:31.033379+00,{},{}
ocd-contest/51450ead-5fe9-4dd6-ae7b-0eb19ae04310,PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOTER APPROVAL. INITIATIVE CONSTITUTIONAL AMENDMENT.,ocd-division/country:us/state:ca,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,"",50% plus one vote,initiative,,2017-08-07 18:45:31.052222+00,2017-08-07 18:45:31.052242+00,{},{}
ocd-contest/060451b4-1550-475b-8b77-abf0d70f26f7,PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE.,ocd-division/country:us/state:ca,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,"",50% plus one vote,initiative,,2017-08-07 18:45:31.070226+00,2017-08-07 18:45:31.070247+00,{},{}
ocd-contest/c774456f-f2e7-4375-92b9-66e9d05d1f44,PROPOSITION 055 - TAX EXTENSION TO FUND EDUCATION AND HEALTHCARE. INITIATIVE CONSTITUTIONAL AMENDMENT.,ocd-division/country:us/state:ca,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,"",50% plus one vote,initiative,,2017-08-07 18:45:31.089918+00,2017-08-07 18:45:31.089939+00,{},{}

BallotMeasureContestIdentifier.csv

id,identifier,scheme,contest_id
36a5e9de-37ce-4c3d-a8a8-03a5b0bdafb3,1225295,calaccess_measure_id,ocd-contest/88fedf11-db1d-43ad-b582-151ecce2619b
cfb07710-e84d-4f49-8b7f-5d11818f16f5,1225298,calaccess_measure_id,ocd-contest/31671d0e-e2fb-485d-9c8f-bd7a218e414b
3cf57885-bffd-45c3-8ba4-b94525379c4b,1225301,calaccess_measure_id,ocd-contest/4f2f6c41-5353-4ed6-a5dd-b369356bf3cf
163e3d0c-8dee-4643-bace-cd00203beaae,1007621,calaccess_measure_id,ocd-contest/b6a2a961-d819-4315-bb76-b82140a28625
e9bc7af8-2ef1-45d4-93be-e12c2fb642d1,1221199,calaccess_measure_id,ocd-contest/314431bf-925a-482b-80b0-273591e7a1fa

BallotMeasureContestOption.csv

BallotMeasureContestSource.csv

id,note,url,contest_id
390bd91a-cda6-476f-9b60-c265c18eff28,Last scraped on 2017-08-07,http://cal-access.sos.ca.gov/Campaign/Measures/Detail.aspx?id=1225295&session=1999,ocd-contest/88fedf11-db1d-43ad-b582-151ecce2619b
1d93e1ce-f850-4547-bc55-87a86aa4f27a,Last scraped on 2017-08-07,http://cal-access.sos.ca.gov/Campaign/Measures/Detail.aspx?id=1225298&session=1999,ocd-contest/31671d0e-e2fb-485d-9c8f-bd7a218e414b
ec846da6-bdfa-4d1e-b788-6450a755cc19,Last scraped on 2017-08-07,http://cal-access.sos.ca.gov/Campaign/Measures/Detail.aspx?id=1225301&session=1999,ocd-contest/4f2f6c41-5353-4ed6-a5dd-b369356bf3cf
dc702f07-4075-485b-b6a6-a0a8f211ea26,Last scraped on 2017-08-07,http://cal-access.sos.ca.gov/Campaign/Measures/Detail.aspx?id=1007621&session=1999,ocd-contest/b6a2a961-d819-4315-bb76-b82140a28625
43e2c8da-c4af-497b-8a1d-f55d6c237937,Last scraped on 2017-08-07,http://cal-access.sos.ca.gov/Campaign/Measures/Detail.aspx?id=1221199&session=1999,ocd-contest/314431bf-925a-482b-80b0-273591e7a1fa

BallotMeasures.csv

name,classification,election_name,election_date,description,created_at,updated_at,ocd_contest_id,ocd_election_id,calaccess_measure_id
PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-12 SCHOOL AND COMMUNITY COLLEGE FACILITIES. INITIATIVE STATUTORY AMENDMENT.,initiative,2016 GENERAL,2016-11-08,"",2017-08-07 18:45:31.013965+00,2017-08-07 18:45:31.013986+00,ocd-contest/0ba0ecc5-5fb5-47a4-9750-4d6187b54f29,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,1376258
PROPOSITION 052 - STATE FEES ON HOSPITALS. FEDERAL MEDI-CAL MATCHING FUNDS. INITIATIVE STATUTORY AND CONSTITUTIONAL AMENDMENT.,initiative,2016 GENERAL,2016-11-08,"",2017-08-07 18:45:31.033359+00,2017-08-07 18:45:31.033379+00,ocd-contest/3b396a06-3221-4332-a7f8-3fbf23e4f3e3,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,1362198
PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOTER APPROVAL. INITIATIVE CONSTITUTIONAL AMENDMENT.,initiative,2016 GENERAL,2016-11-08,"",2017-08-07 18:45:31.052222+00,2017-08-07 18:45:31.052242+00,ocd-contest/51450ead-5fe9-4dd6-ae7b-0eb19ae04310,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,1376142
PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE.,initiative,2016 GENERAL,2016-11-08,"",2017-08-07 18:45:31.070226+00,2017-08-07 18:45:31.070247+00,ocd-contest/060451b4-1550-475b-8b77-abf0d70f26f7,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,1381642
PROPOSITION 055 - TAX EXTENSION TO FUND EDUCATION AND HEALTHCARE. INITIATIVE CONSTITUTIONAL AMENDMENT.,initiative,2016 GENERAL,2016-11-08,"",2017-08-07 18:45:31.089918+00,2017-08-07 18:45:31.089939+00,ocd-contest/c774456f-f2e7-4375-92b9-66e9d05d1f44,ocd-election/7c01ac66-b870-4c02-b705-18d83fd7c233,1382647

CVR2_CAMPAIGN_DISCLOSURE_CD.TSV

CVR2_LOBBY_DISCLOSURE_CD.TSV

CVR2_REGISTRATION_CD.TSV

CVR2_SO_CD.TSV

CVR3_VERIFICATION_INFO_CD.TSV

CVR_CAMPAIGN_DISCLOSURE_CD.TSV

CVR_E530_CD.TSV

CVR_LOBBY_DISCLOSURE_CD.TSV

CVR_REGISTRATION_CD.TSV

CVR_SO_CD.TSV

Candidacy.csv

CandidacySource.csv

CandidateContest.csv

CandidateContestPost.csv

CandidateContestSource.csv

Candidates.csv

DEBT_CD.TSV

Division.csv

EFS_FILING_LOG_CD.TSV

EXPN_CD.TSV

Election.csv

ElectionIdentifier.csv

ElectionSource.csv

F495P2_CD.TSV

F501_502_CD.TSV

F690P2_CD.TSV

FILERNAME_CD.TSV

FILERS_CD.TSV

FILER_ACRONYMS_CD.TSV

FILER_ADDRESS_CD.TSV

FILER_ETHICS_CLASS_CD.TSV

FILER_FILINGS_CD.TSV

FILER_INTERESTS_CD.TSV

FILER_LINKS_CD.TSV

FILER_STATUS_TYPES_CD.TSV

FILER_TO_FILER_TYPE_CD.TSV

FILER_TYPES_CD.TSV

FILER_XREF_CD.TSV

FILINGS_CD.TSV

FILING_PERIOD_CD.TSV

FlatBallotMeasureContest.csv

FlatCandidacy.csv

FlatRetentionContest.csv

GROUP_TYPES_CD.TSV

HDR_CD.TSV

HEADER_CD.TSV

IMAGE_LINKS_CD.TSV

LATT_CD.TSV

LCCM_CD.TSV

LEGISLATIVE_SESSIONS_CD.TSV

LEMP_CD.TSV

LEXP_CD.TSV

LOAN_CD.TSV

LOBBYING_CHG_LOG_CD.TSV

LOBBYIST_CONTRIBUTIONS1_CD.TSV

LOBBYIST_CONTRIBUTIONS2_CD.TSV

LOBBYIST_CONTRIBUTIONS3_CD.TSV

LOBBYIST_EMPLOYER1_CD.TSV

LOBBYIST_EMPLOYER2_CD.TSV

LOBBYIST_EMPLOYER3_CD.TSV

LOBBYIST_EMPLOYER_FIRMS1_CD.TSV

LOBBYIST_EMPLOYER_FIRMS2_CD.TSV

LOBBYIST_EMP_LOBBYIST1_CD.TSV

LOBBYIST_EMP_LOBBYIST2_CD.TSV

LOBBYIST_FIRM1_CD.TSV

LOBBYIST_FIRM2_CD.TSV

LOBBYIST_FIRM3_CD.TSV

LOBBYIST_FIRM_EMPLOYER1_CD.TSV

LOBBYIST_FIRM_EMPLOYER2_CD.TSV

LOBBYIST_FIRM_LOBBYIST1_CD.TSV

LOBBYIST_FIRM_LOBBYIST2_CD.TSV

LOBBY_AMENDMENTS_CD.TSV

LOOKUP_CODES_CD.TSV

LOTH_CD.TSV

LPAY_CD.TSV

Membership.csv

NAMES_CD.TSV

Organization.csv

OrganizationIdentifier.csv

OrganizationName.csv

Person.csv

PersonIdentifier.csv

PersonName.csv

Post.csv

RCPT_CD.TSV

RECEIVED_FILINGS_CD.TSV

REPORTS_CD.TSV

RecallMeasures.csv

RetentionContest.csv

RetentionContestIdentifier.csv

RetentionContestOption.csv

RetentionContestSource.csv

S401_CD.TSV

S496_CD.TSV

S497_CD.TSV

S498_CD.TSV

SMRY_CD.TSV

SPLT_CD.TSV

TEXT_MEMO_CD.TSV

acronyms_cd.csv

address_cd.csv

ballot_measures_cd.csv

cvr2_campaign_disclosure_cd.csv

cvr2_lobby_disclosure_cd.csv

cvr2_registration_cd.csv

cvr2_so_cd.csv

cvr3_verification_info_cd.csv

cvr_campaign_disclosure_cd.csv

cvr_e530_cd.csv

cvr_lobby_disclosure_cd.csv

cvr_registration_cd.csv

cvr_so_cd.csv

debt_cd.csv

efs_filing_log_cd.csv

expn_cd.csv

f495p2_cd.csv

f501_502_cd.csv

f690p2_cd.csv

filer_acronyms_cd.csv

filer_address_cd.csv

filer_ethics_class_cd.csv

filer_filings_cd.csv

filer_interests_cd.csv

filer_links_cd.csv

filer_status_types_cd.csv

filer_to_filer_type_cd.csv

filer_types_cd.csv

filer_xref_cd.csv

filername_cd.csv

filers_cd.csv

filing_period_cd.csv

filings_cd.csv

group_types_cd.csv

hdr_cd.csv

header_cd.csv

image_links_cd.csv

latt_cd.csv

lccm_cd.csv

legislative_sessions_cd.csv

lemp_cd.csv

lexp_cd.csv

loan_cd.csv

lobby_amendments_cd.csv

lobbying_chg_log_cd.csv

lobbyist_contributions1_cd.csv

lobbyist_contributions2_cd.csv

lobbyist_contributions3_cd.csv

lobbyist_emp_lobbyist1_cd.csv

lobbyist_emp_lobbyist2_cd.csv

lobbyist_employer1_cd.csv

lobbyist_employer2_cd.csv

lobbyist_employer3_cd.csv

lobbyist_employer_firms1_cd.csv

lobbyist_employer_firms2_cd.csv

lobbyist_firm1_cd.csv

lobbyist_firm2_cd.csv

lobbyist_firm3_cd.csv

lobbyist_firm_employer1_cd.csv

lobbyist_firm_employer2_cd.csv

lobbyist_firm_lobbyist1_cd.csv

lobbyist_firm_lobbyist2_cd.csv

lookup_codes_cd.csv

loth_cd.csv

lpay_cd.csv

names_cd.csv

rcpt_cd.csv

received_filings_cd.csv

reports_cd.csv

s401_cd.csv

s496_cd.csv

s497_cd.csv

s498_cd.csv

smry_cd.csv

splt_cd.csv

text_memo_cd.csv