In [1]:
%load_ext sql
In [2]:
from django.conf import settings
connection_string = 'postgresql+psycopg2://{USER}:{PASSWORD}@{HOST}:{PORT}/{NAME}'.format(
**settings.DATABASES['default']
)
%sql $connection_string
Out[2]:
u'Connected: ccdc@calaccess_website'
Every campaign finance disclosure filing has a cover sheet, and the top-level information from these cover sheets ends up in the CVR_CAMPAIGN_DISCLOSURE_CD. This is an important table because it links because it links the dollar amount totals from the SMRY_CD table to a name fields and a unique identifier of the filer.
The forms of the filings that end up in CVR_CAMPAIGN_DISCLOSURE_CD are all the ones that include financial disclosures of campaigns as opposed to statements of intention and organization.
No, which is good because we can easily sort records linked to the FILING_ID and AMEND_ID combinations.
In [3]:
%%sql
SELECT cvr."FILING_ID", COUNT(DISTINCT cvr."FORM_TYPE")
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" cvr
JOIN "FILER_FILINGS_CD" ff
ON cvr."FILING_ID" = ff."FILING_ID"
AND cvr."AMEND_ID" = ff."FILING_SEQUENCE"
GROUP BY 1
HAVING COUNT(DISTINCT cvr."FORM_TYPE") > 1;
0 rows affected.
Out[3]:
FILING_ID
count
No, which is good because we should then be able to sort out who filed which filings.
In [4]:
%%sql
SELECT "FILING_ID", COUNT(DISTINCT "FILER_ID")
FROM "CVR_CAMPAIGN_DISCLOSURE_CD"
GROUP BY 1
HAVING COUNT(DISTINCT "FILER_ID") > 1
ORDER BY COUNT(DISTINCT "FILER_ID") DESC;
0 rows affected.
Out[4]:
FILING_ID
count
The FILER_FILINGS_CD has additional information about each filing, including the filing period in which the filing files.
There are also lot of fields that seem to be redundant with fields on CVR_CAMPAIGN_DISCLOSURE_CD, specifically:
CVR_CAMPAIGN_DISCLOSURE_CD.FORM_TYPE and FILER_FILINGS_CD.FORM_IDCVR_CAMPAIGN_DISCLOSURE_CD.FILER_ID and FILER_FILINGS_CD.FILER_IDCVR_CAMPAIGN_DISCLOSURE_CD.STMT_TYPE and FILER_FILINGS_CD.STMNT_TYPECVR_CAMPAIGN_DISCLOSURE_CD.RPT_DATE and FILER_FILINGS_CD.FILING_DATECVR_CAMPAIGN_DISCLOSURE_CD.FROM_START and FILER_FILINGS_CD.RPT_STARTCVR_CAMPAIGN_DISCLOSURE_CD.THRU_DATE and FILER_FILINGS_CD.RPT_ENDCVR_CAMPAIGN_DISCLOSURE_CD.RPT_DATE and FILER_FILINGS_CD.RPT_DATEMight be worth checking if values in each pair of fields ever conflict.
Almost. And among records left on the FILER_FILINGS_CD table, many of the fields or blank of have values that suggest they are only for testing purposes.
In [5]:
%%sql
SELECT cvr."FORM_TYPE", cvr."FILING_ID", cvr."AMEND_ID", cvr."FILER_ID", cvr."FILER_NAML", cvr."RPT_DATE", *
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" cvr
LEFT JOIN "FILER_FILINGS_CD" ff
ON cvr."FILING_ID" = ff."FILING_ID"
AND cvr."AMEND_ID" = ff."FILING_SEQUENCE"
WHERE ff."FILING_ID" IS NULL or ff."FILING_SEQUENCE" IS NULL;
37 rows affected.
Out[5]:
FORM_TYPE
FILING_ID
AMEND_ID
FILER_ID
FILER_NAML
RPT_DATE
id
AMEND_ID_1
AMENDEXP_1
AMENDEXP_2
AMENDEXP_3
ASSOC_CB
ASSOC_INT
BAL_ID
BAL_JURIS
BAL_NAME
BAL_NUM
BRDBASE_YN
BUS_CITY
BUS_INTER
BUS_NAME
BUS_ST
BUS_ZIP4
BUSACT_CB
BUSACTVITY
CAND_CITY
CAND_EMAIL
CAND_FAX
CAND_ID
CAND_NAMF
CAND_NAML
CAND_NAMS
CAND_NAMT
CAND_PHON
CAND_ST
CAND_ZIP4
CMTTE_ID
CMTTE_TYPE
CONTROL_YN
DIST_NO
ELECT_DATE
EMPLBUS_CB
EMPLOYER
ENTITY_CD
FILE_EMAIL
FILER_CITY
FILER_FAX
FILER_ID_1
FILER_NAMF
FILER_NAML_1
FILER_NAMS
FILER_NAMT
FILER_PHON
FILER_ST
FILER_ZIP4
FILING_ID_1
FORM_TYPE_1
FROM_DATE
JURIS_CD
JURIS_DSCR
LATE_RPTNO
MAIL_CITY
MAIL_ST
MAIL_ZIP4
OCCUPATION
OFF_S_H_CD
OFFIC_DSCR
OFFICE_CD
OTHER_CB
OTHER_INT
PRIMFRM_YN
REC_TYPE
REPORT_NUM
REPORTNAME
RPT_ATT_CB
RPT_DATE_1
RPTFROMDT
RPTTHRUDT
SELFEMP_CB
SPONSOR_YN
STMT_TYPE
SUP_OPP_CD
THRU_DATE
TRES_CITY
TRES_EMAIL
TRES_FAX
TRES_NAMF
TRES_NAML
TRES_NAMS
TRES_NAMT
TRES_PHON
TRES_ST
TRES_ZIP4
id_1
FILER_ID_2
FILING_ID_2
PERIOD_ID
FORM_ID
FILING_SEQUENCE
FILING_DATE
STMNT_TYPE
STMNT_STATUS
SESSION_ID
USER_ID
SPECIAL_AUDIT
FINE_AUDIT
RPT_START
RPT_END
RPT_DATE_2
FILING_TYPE
F460
591533
1
992218
Damian Jones for Assembly
2000-07-30
36565446
1
Additional information received after filing.
N
Pasadena
Damian
Jones
626/398-4993
CA
91107
C
0
44
2000-03-07
CTL
Pasadena
992218
Damian Jones for Assembly
626/449-3346
CA
91107
591533
F460
2000-01-23
ASM
Pasadena
CA
911020445
ASM
N
CVR
001
2000-07-30
None
None
0
PE
2000-02-19
Elk Grove
Vona
Copp
916/686-1815
CA
95624
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F497
595429
0
990168
X
2000-02-24
36558679
0
None
None
990168
X
595429
F497
None
000551
CVR
000
2000-02-24
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F497
598450
0
990168
x
2000-02-28
36560440
0
None
None
990168
x
598450
F497
None
002251
CVR
000
2000-02-28
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F497
601406
0
990168
X
2000-02-29
36563181
0
None
None
990168
X
601406
F497
None
002371
CVR
000
2000-02-29
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F497
602607
0
990168
X
2000-03-01
36559676
0
None
None
990168
X
602607
F497
None
003120
CVR
000
2000-03-01
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F460
602619
1
931704
United Teachers Los Angeles-Political Action Council of Educators(PACE)Issues
2000-02-24
36561125
1
The amount of $1071.95 and $1063.67 were included in Schedule E but not included in Schedule D
Y
G
0
2000-03-07
RCP
Los Angeles
931704
United Teachers Los Angeles-Political Action Council of Educators(PACE)Issues
213-487-5560
CA
90010
602619
F460
2000-01-01
N
CVR
001
2000-02-24
None
None
1
PE
2000-02-19
Los Angeles
Patricia
Stanyo
213-487-5560
CA
90010
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F460
670063
1
950027
Carl Washington For CA St Assembly 52nd District
2000-10-26
36567613
1
Schedule F See Attached
N
Paramount
Carl
Washington
CA
90723
C
0
52
2000-11-07
CAO
Paramount
950027
-
Carl Washington For CA St Assembly 52nd District
CA
90723
670063
F460
2000-07-01
ASM
State of California
Paramount
CA
90723-0000
H
Assemblymember
ASM
N
CVR
1
2000-10-26
None
None
0
PE
S
2000-09-30
Los Angeles
Pam
Goodwin
(310) 223-0759
CA
90037
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F497
682833
0
972148
SHELLEY FOR ASSEMBLY
2000-10-28
36569265
0
SAN FRANCISCO
095173
KEVIN
SHELLEY
4155572312
CA
941310000
1
12
None
CTL
SACRAMENTO
972148
SHELLEY FOR ASSEMBLY
4156939300
CA
958140000
682833
F497
None
ASM
CVR
0
2000-10-28
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
763288
1
479259
SHEA HOMES AND AFFILIATED ENTITIES
2001-07-03
36574597
1
N
X
HOME BUILDER
0
None
MDI
WALNUT
479259
SHEA HOMES AND AFFILIATED ENTITIES
(415) 389-6800
CA
91788
763288
F461
2001-01-01
WALNUT
CA
91789
N
CVR
001
2001-07-03
None
None
0
2001-03-31
JASON D. KAUNE ATTY./AGENT FOR FILER
(415) 389-6800
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F460
786716
1
782408
Ernst & Young LLP - Los Angeles Political Action Committee
2001-10-10
36577279
1
Correction to Treasurer's Name
Y
G
0
None
RCP
Los Angeles
782408
Ernst & Young LLP - Los Angeles Political Action Committee
213-977-3393
CA
90017
786716
F460
2001-07-01
N
CVR
001
2001-10-10
None
None
0
QT
2001-09-30
Los Angeles
Andrew D.
Ross
Mr.
213-977-3026
CA
90017
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F496
983029
0
1258927
VENDOR V
2004-01-16
36614770
0
John
Doe
None
None
1258927
VENDOR V
CA
983029
F496
None
STW
578546
S
GOV
CVR
000
2004-01-16
None
None
None
S
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F460
983030
0
1258927
John Doe for Senate
2003-10-01
36614771
0
Sacramento
John
Doe
916-653-6224
CA
95814
C
1
002
2004-01-01
CTL
johndoe@email.com
Sacramento
916-653-0000
1258927
John Doe for Senate
916-653-6224
CA
95814
983030
F460
2004-01-01
SEN
test1
Sacramento
CA
95812
S
SEN
CVR
000
2003-10-01
None
None
0
PE
S
2004-01-01
Sacramento
jhopkins@ss.ca.gov
John
Hopkins
916-653-8225
CA
95814
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1005638
3
1256142
VENDOR IV
2004-04-06
36620378
3
TO REMOVE VALUES FROM TEST DATA DISPLAYED ON WEB
None
None
ONLINEFILINGHELP@SS.CA.GOV
SACRAMENTO
9166535045
1256142
VENDOR IV
9166536224
CA
95814
1005638
F461
2004-01-01
CVR
003
2004-04-06
None
None
None
2004-03-09
TESTING
ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1005638
2
1256142
VENDOR IV
2004-04-06
36620377
2
TO REMOVE VALUES FROM TEST DATA DISPLAYED ON WEB
None
None
ONLINEFILINGHELP@SS.CA.GOV
SACRAMENTO
9166535045
1256142
VENDOR IV
9166536224
CA
95814
1005638
F461
2004-01-01
CVR
002
2004-04-06
None
None
None
2004-03-09
TESTING
ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1005638
1
1256142
VENDOR IV
2004-04-06
36620376
1
TO REMOVE VALUES FROM TEST DATA DISPLAYED ON WEB
None
None
ONLINEFILINGHELP@SS.CA.GOV
SACRAMENTO
9166535045
1256142
VENDOR IV
9166536224
CA
95814
1005638
F461
2004-01-01
CVR
001
2004-04-06
None
None
None
2004-03-09
TESTING
ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1005638
0
1256142
VENDOR IV
2004-03-09
36619931
0
None
None
ONLINEFILINGHELP@SS.CA.GOV
SACRAMENTO
9166535045
1256142
VENDOR IV
9166536224
CA
95814
1005638
F461
2004-01-01
CVR
000
2004-03-09
None
None
None
2004-03-09
TESTING
ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1010138
0
1256142
VENDOR IV
2004-04-21
36620803
0
SACRAMENTO
ONLY TESTING
TESTING
CA
95814
None
None
X
ONLINEFILINGHELP@SS.CA.GOV
SACRAMENTO
9166535045
1256142
VENDOR IV
9166536224
CA
95814
1010138
F461
2003-01-01
X
NONE
CVR
000
2004-04-21
None
None
None
2003-12-30
TESTING
ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1011026
0
1256142
VENDOR IV
2004-04-26
36619683
0
None
None
ONLINEFILINGHELP@SS.CA.GOV
SACRAMENTO
9166535045
1256142
VENDOR IV
9166536224
CA
95814
1011026
F461
2001-01-01
CVR
000
2004-04-26
None
None
None
2001-12-17
TESTING
ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1018321
1
1256142
VENDOR IV
2004-05-20
36620134
1
DATE CHANGE FOR TEST PURPOSES ONLY
None
None
SAC
1256142
VENDOR IV
9165551212
CA
95814
1018321
F461
1999-01-01
CVR
001
2004-05-20
None
None
None
1999-01-06
TEST
MATERIAL ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1018321
0
1256142
VENDOR IV
2004-05-20
36620133
0
None
None
SAC
1256142
VENDOR IV
9165551212
CA
95814
1018321
F461
1999-01-01
CVR
000
2004-05-20
None
None
None
1999-01-05
TEST
MATERIAL ONLY
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F511
1058941
1
1258927
VENDOR V
2004-11-01
36634921
1
test data only
None
None
1258927
VENDOR V
CA
1058941
F511
None
CVR
001
2004-11-01
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F511
1058941
0
1258927
VENDOR V
2004-11-01
36634920
0
None
None
1258927
VENDOR V
CA
1058941
F511
None
CVR
000
2004-11-01
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1081522
0
1273757
Triad Communities, LP
2005-01-31
36637684
0
X
Real Estate Development
None
None
MDI
Vacaville
1273757
-
Triad Communities, LP
(707) 446-9000
CA
95688
1081522
F461
2004-07-01
Vacaville
CA
95688
CVR
000
2005-01-31
None
None
None
2004-12-31
Frederick
Grimm
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F460
1643669
0
1345401
TEST EFS 2012 CAMPAIGN 460
2010-01-16
36783334
0
G
0
None
RCP
Sacramento
916-442-7759
1345401
TEST EFS 2012 CAMPAIGN 460
916-442-7757
CA
95814
1643669
F460
2005-07-01
Sacramento
CA
95814
N
CVR
000
2010-01-16
None
None
0
SA
2005-12-31
Sacramento
Thomas W.
Jones
Mr.
916-442-7757
CA
95814
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F496
1643671
0
1345401
TEST EFS 460 FILING
2010-06-01
36780147
0
ELAINE
ALQUIST
None
2
None
RCP
SAN DIEGO
7602317134
1345401
TEST EFS 460 FILING
7602317134
CA
92122
1643671
F496
None
SEN
06-01-10 - IEa
S
SEN
CVR
000
2010-06-01
None
None
None
S
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1643687
0
1345405
TEST - MAJOR DONOR - MARCH 2012
2012-03-03
36783335
0
Rancho Cucamonga
Company
WLC Architect Inc
CA
91730
X
Business
None
2011-06-03
X
MDI
SACRAMENTO
9166535045
1345405
TEST - MAJOR DONOR - MARCH 2012
9166536224
CA
95814
1643687
F461
2011-07-01
CVR
000
2012-03-03
None
None
None
2011-12-31
George
Wiens
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F498
1643691
1
1345402
TEST - SLATE MAILER ORGANIZATIONS - 2012
2012-03-03
36785145
1
Missing Information
None
None
SMO
1345402
TEST - SLATE MAILER ORGANIZATIONS - 2012
1643691
F498
None
002
CVR
001
2012-03-03
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F498
1643691
0
1345402
TEST SLATE MAILER 498
2010-06-02
36784782
0
None
None
SMO
Burbank
1345402
TEST SLATE MAILER 498
(818) 260-0669
CA
91502
1643691
F498
None
002
CVR
000
2010-06-02
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F460
1643696
0
1345410
TEST EFS 2012 460 CTL CMTT
2010-01-16
36783336
0
G
1
None
RCP
Sacramento
916-442-7759
1345410
TEST EFS 2012 460 CTL CMTT
916-442-7757
CA
95814
1643696
F460
2005-07-01
Sacramento
CA
95814
N
CVR
000
2010-01-16
None
None
0
SA
2005-12-31
Sacramento
Thomas W.
Jones
Mr.
916-442-7757
CA
95814
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F496
1643698
0
1345410
TEST CTRLD CMTT - 496 FILING
2010-06-01
36783337
0
Debra
Bowen
None
33
None
RCP
DIEGO
7602300034
1345410
TEST CTRLD CMTT - 496 FILING
7600017134
CA
92122
1643698
F496
None
ASM
496-06-01-10(b)
S
ASM
CVR
000
2010-06-01
None
None
None
S
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1643699
0
1345405
TEST - MAJOR DONOR - MARCH 2012
2012-03-03
36782628
0
X
agribusiness
None
None
MDI
SACRAMENTO
9166535045
1345405
TEST - MAJOR DONOR - MARCH 2012
9166536224
CA
95814
1643699
F461
2009-01-01
CVR
000
2012-03-03
None
None
None
2009-12-31
test
test
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F498
1643708
0
1345402
TEST - SLATE MAILER ORGANIZATIONS - 2012
2012-03-03
36784299
0
None
None
SMO
1345402
TEST - SLATE MAILER ORGANIZATIONS - 2012
1643708
F498
None
2877
CVR
000
2012-03-03
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F497
1643713
0
1345401
TEST - RECIPIENT COMMITTEE - MARCH 2012
2012-03-03
36784300
0
None
None
RCP
1345401
TEST - RECIPIENT COMMITTEE - MARCH 2012
1643713
F497
None
1
CVR
000
2012-03-03
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F450
1643732
0
1345401
TEST - RECIPIENT COMMITTEE - MARCH 2012
2012-03-03
36784301
0
G
0
None
RCP
1345401
TEST - RECIPIENT COMMITTEE - MARCH 2012
1643732
F450
2011-01-01
CVR
000
2012-03-03
None
None
0
SA
2011-06-30
RANCHO CORDOVA
ED
MURRAY
9167476987
CA
95742
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1643733
0
1345405
MAJOR DONOR TEST 461
2010-01-27
36785527
0
X
Lumber Manufacturer
None
2010-06-08
MDI
KAS@Jon.COM
FAIRFIELD
7073992363
1345405
MAJOR DONOR TEST 461
7074282800
CA
94003
1643733
F461
2009-07-01
CVR
000
2010-01-27
None
None
None
2009-12-31
Mister
Test
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F461
1643733
1
1345405
MAJOR DONOR TEST 461
2012-03-03
36784302
1
Changing contribution amount
X
Lumber Manufacturer
None
2010-06-08
MDI
KAS@Jon.COM
FAIRFIELD
7073992363
1345405
MAJOR DONOR TEST 461
7074282800
CA
94003
1643733
F461
2009-07-01
CVR
001
2012-03-03
None
None
None
2009-12-31
Mister
Test
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
F497
1643734
0
1345405
MAJOR DONOR TEST 497 RECPT
2010-06-05
36785144
0
None
None
RCP
RIALTO
1345405
MAJOR DONOR TEST 497 RECPT
9098204406
CA
92377
1643734
F497
None
220
CVR
000
2010-06-05
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
They do, but not a lot. And there is a pretty clear pattern with CVR_CAMPAIGN_DISCLOSURE_CD.FORM_TYPE saying F497 and FILER_FILINGS_CD.FORM_ID saying F496.
In [6]:
%%sql
SELECT cvr."FORM_TYPE", ff."FORM_ID", cvr."FILING_ID", cvr."AMEND_ID", cvr."RPT_DATE", *
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" cvr
JOIN "FILER_FILINGS_CD" ff
ON cvr."FILING_ID" = ff."FILING_ID"
AND cvr."AMEND_ID" = ff."FILING_SEQUENCE"
WHERE UPPER(cvr."FORM_TYPE") <> UPPER(ff."FORM_ID")
ORDER BY cvr."RPT_DATE" DESC, cvr."FILING_ID" DESC, cvr."AMEND_ID" DESC;
113 rows affected.
Out[6]:
FORM_TYPE
FORM_ID
FILING_ID
AMEND_ID
RPT_DATE
id
AMEND_ID_1
AMENDEXP_1
AMENDEXP_2
AMENDEXP_3
ASSOC_CB
ASSOC_INT
BAL_ID
BAL_JURIS
BAL_NAME
BAL_NUM
BRDBASE_YN
BUS_CITY
BUS_INTER
BUS_NAME
BUS_ST
BUS_ZIP4
BUSACT_CB
BUSACTVITY
CAND_CITY
CAND_EMAIL
CAND_FAX
CAND_ID
CAND_NAMF
CAND_NAML
CAND_NAMS
CAND_NAMT
CAND_PHON
CAND_ST
CAND_ZIP4
CMTTE_ID
CMTTE_TYPE
CONTROL_YN
DIST_NO
ELECT_DATE
EMPLBUS_CB
EMPLOYER
ENTITY_CD
FILE_EMAIL
FILER_CITY
FILER_FAX
FILER_ID
FILER_NAMF
FILER_NAML
FILER_NAMS
FILER_NAMT
FILER_PHON
FILER_ST
FILER_ZIP4
FILING_ID_1
FORM_TYPE_1
FROM_DATE
JURIS_CD
JURIS_DSCR
LATE_RPTNO
MAIL_CITY
MAIL_ST
MAIL_ZIP4
OCCUPATION
OFF_S_H_CD
OFFIC_DSCR
OFFICE_CD
OTHER_CB
OTHER_INT
PRIMFRM_YN
REC_TYPE
REPORT_NUM
REPORTNAME
RPT_ATT_CB
RPT_DATE_1
RPTFROMDT
RPTTHRUDT
SELFEMP_CB
SPONSOR_YN
STMT_TYPE
SUP_OPP_CD
THRU_DATE
TRES_CITY
TRES_EMAIL
TRES_FAX
TRES_NAMF
TRES_NAML
TRES_NAMS
TRES_NAMT
TRES_PHON
TRES_ST
TRES_ZIP4
id_1
FILER_ID_1
FILING_ID_2
PERIOD_ID
FORM_ID_1
FILING_SEQUENCE
FILING_DATE
STMNT_TYPE
STMNT_STATUS
SESSION_ID
USER_ID
SPECIAL_AUDIT
FINE_AUDIT
RPT_START
RPT_END
RPT_DATE_2
FILING_TYPE
F497
F496
687938
0
2000-11-07
36572102
0
ANTIOCH
095057
TOM
TORLAKSON
5103727990
CA
945090000
None
07
None
RCP
SAN FRANCISCO
741504
STANDING COMMITTEE ON POLITICAL EDUCATION OF THE CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
687938
F497
None
S
SEN
CVR
0
2000-11-07
None
None
None
S
None
190863376
1018355
687938
None
F496
0
2000-11-07
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-07
None
F497
F496
687359
0
2000-11-07
36571720
0
ETIWANDA
089034
JAMES L.
BRULTE
9094669096
CA
917390000
None
31
None
RCP
LOS ANGELES
741666
DEMOCRATIC STATE CENTRAL COMMITTEE OF CALIFORNIA
2132561968
CA
900410000
687359
F497
None
S
SEN
CVR
0
2000-11-07
None
None
None
O
None
190352214
1018392
687359
None
F496
0
2000-11-07
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-07
None
F497
F496
687358
0
2000-11-07
36571430
0
ANTIOCH
095057
TOM
TORLAKSON
5103727990
CA
945090000
None
07
None
RCP
SAN FRANCISCO
741504
STANDING COMMITTEE ON POLITICAL EDUCATION OF THE CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
687358
F497
None
S
SEN
CVR
0
2000-11-07
None
None
None
S
None
190352213
1018355
687358
None
F496
0
2000-11-07
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-07
None
F497
F496
687347
0
2000-11-07
36571429
0
SARATOGA
099065
REBECCA
COHN
4088680249
CA
950700000
None
24
None
RCP
OAKLAND
747285
HEALTH CARE WORKERS UNION, SEIU LOCAL 250 POLITICAL ACTION COMMITTEE
4085577613
CA
946120000
687347
F497
None
ASM
S
ASM
CVR
0
2000-11-07
None
None
None
S
None
190352205
1020788
687347
None
F496
0
2000-11-07
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-11-07
None
F497
F496
687346
0
2000-11-07
36571428
0
SALINAS
099033
SIMON
SALINAS
8317586276
CA
939050000
None
28
None
RCP
OAKLAND
747285
HEALTH CARE WORKERS UNION, SEIU LOCAL 250 POLITICAL ACTION COMMITTEE
4085577613
CA
946120000
687346
F497
None
S
ASM
CVR
0
2000-11-07
None
None
None
S
None
190352204
1020788
687346
None
F496
0
2000-11-07
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-11-07
None
F497
F496
687345
0
2000-11-07
36571427
0
ALAMEDA
099069
WILMA
CHAN
5102726693
CA
945010000
None
16
None
RCP
OAKLAND
747285
HEALTH CARE WORKERS UNION, SEIU LOCAL 250 POLITICAL ACTION COMMITTEE
4085577613
CA
946120000
687345
F497
None
ASM
S
ASM
CVR
0
2000-11-07
None
None
None
S
None
190447505
1020788
687345
None
F496
0
2000-11-07
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-11-07
None
F497
F496
687216
0
2000-11-07
36572062
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
BMC
LOS ANGELES
931704
UNITED TEACHERS LOS ANGELES-POLITICAL ACTION COUNCIL OF EDUCATORS (PACE) ISSUES
2134875560
CA
900100000
687216
F497
None
S
CVR
0
2000-11-07
None
None
None
O
None
190349423
1060144
687216
None
F496
0
2000-11-07
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-11-07
None
F497
F496
687109
0
2000-11-07
36571683
0
ALAMEDA
099069
WILMA
CHAN
5102726693
CA
945010000
None
16
None
RCP
LOS ANGELES
983392
BLACK LEADERSHIP POLITICAL ACTION COMMITTEE
2134894792
CA
900712300
687109
F497
None
S
ASM
CVR
0
2000-11-07
None
None
None
S
None
190347861
1075441
687109
None
F496
0
2000-11-07
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-07
None
F497
F496
687281
0
2000-11-06
36571003
0
VETERANS' BOND ACT OF 2000
32
None
None
RCP
LOS ANGELES
741666
DEMOCRATIC STATE CENTRAL COMMITTEE OF CALIFORNIA
2132561968
CA
900410000
687281
F497
None
S
CVR
0
2000-11-06
None
None
None
S
None
190350999
1018392
687281
None
F496
0
2000-11-06
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-06
None
F497
F496
686558
0
2000-11-06
36571218
0
LONG BEACH
098167
ALAN
LOWENTHAL
5624954766
CA
908030000
None
54
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686558
F497
None
ASM
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867529
1074372
686558
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686555
0
2000-11-06
36571215
0
WEST COVINA
099062
RICHARD
MELENDEZ
6269165095
CA
917920000
None
29
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686555
F497
None
SEN
S
SEN
CVR
0
2000-11-06
None
None
None
S
None
190867526
1074372
686555
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686546
0
2000-11-06
36570942
0
CHINO
097071
GLORIA NEGRETE
MC LEOD
9096281051
CA
917100000
None
61
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686546
F497
None
ASM
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867522
1074372
686546
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686521
0
2000-11-06
36572093
0
CAMARILLO
092165
ROZ
MC GRATH
8054824960
CA
930100000
None
37
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686521
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867481
1074372
686521
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686518
0
2000-11-06
36572091
0
SAN DIEGO
095062
HOWARD
WAYNE
6192347878
CA
921100000
None
78
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686518
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867478
1074372
686518
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686516
1
2000-11-06
36571444
1
ANTIOCH
TOM
TORLAKSON
5103727990
CA
945090000
None
07
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686516
F497
None
S
SEN
CVR
0
2000-11-06
None
None
None
S
None
190864601
1074372
686516
0
F496
1
2000-11-10
10002
11001
1999
PBANFORD
11003
11003
None
None
2000-11-06
None
F497
F496
686516
0
2000-11-06
36572089
0
ANTIOCH
095057
TOM
TORLAKSON
5103727990
CA
945090000
None
07
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686516
F497
None
S
SEN
CVR
0
2000-11-06
None
None
None
S
None
190867475
1074372
686516
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686515
0
2000-11-06
36572087
0
SALINAS
099033
SIMON
SALINAS
8317586276
CA
939050000
None
28
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686515
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867180
1074372
686515
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686512
0
2000-11-06
36572086
0
SAN DIEGO
090475
DEDE
ALPERT
6194575775
CA
921380000
None
39
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686512
F497
None
S
SEN
CVR
0
2000-11-06
None
None
None
S
None
190867179
1074372
686512
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686511
0
2000-11-06
36572084
0
LOS ANGELES
099147
DARIO J.
FROMMER
2136239704
CA
900170000
None
43
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686511
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867177
1074372
686511
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686505
0
2000-11-06
36572082
0
COVINA
099206
MELINE DOLORES
HALL
6269158892
CA
917230000
None
59
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686505
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867174
1074372
686505
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686503
0
2000-11-06
36571719
0
CERRITOS
095099
SALLY M.
HAVICE
9164456047
CA
907030000
None
56
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686503
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867166
1074372
686503
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686500
0
2000-11-06
36571718
0
SAN DIEGO
099028
CHRISTINE
KEHOE
6192366633
CA
921160000
None
76
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686500
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867165
1074372
686500
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686499
0
2000-11-06
36571716
0
LA CANADA FLINTRIDGE
099064
CAROL
LIU
8189520486
CA
910110000
None
44
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686499
F497
None
S
ASM
CVR
0
2000-11-06
None
None
None
S
None
190867163
1074372
686499
None
F496
0
2000-11-06
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-06
None
F497
F496
686100
0
2000-11-05
36571926
0
VETERANS' BOND ACT OF 2000
32
None
None
RCP
LOS ANGELES
741666
DEMOCRATIC STATE CENTRAL COMMITTEE OF CALIFORNIA
2132561968
CA
900410000
686100
F497
None
S
CVR
0
2000-11-05
None
None
None
S
None
190864521
1018392
686100
None
F496
0
2000-11-05
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-05
None
F497
F496
686553
0
2000-11-04
36570943
0
VETERANS' BOND ACT OF 2000
32
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686553
F497
None
S
CVR
0
2000-11-04
None
None
None
S
None
190867523
1074372
686553
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686550
0
2000-11-04
36570941
0
LEGISLATURE. PARTICIPATION IN PUBLIC EMPLOYEES' RETIREMENT SYSTEM. INITIATIVE CONSTITUTIONAL AMENDMENT.
33
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686550
F497
None
S
CVR
0
2000-11-04
None
None
None
S
None
190867520
1074372
686550
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686549
0
2000-11-04
36570940
0
CAMPAIGN CONTRIBUTIONS AND SPENDING. LIMITS. DISCLOSURE. LEGISLATIVE INITIATIVE AMENDMENT.
34
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686549
F497
None
S
CVR
0
2000-11-04
None
None
None
S
None
190867519
1074372
686549
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686548
0
2000-11-04
36570938
0
PUBLIC WORKS PROJECTS. USE OF PRIVATE CONTRACTORS FOR ENGINEERING AND ARCHITECTURAL SERVICES. INITIATIVE CONSTITUTIONAL AMEND
35
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686548
F497
None
S
CVR
0
2000-11-04
None
None
None
O
None
190867516
1074372
686548
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686547
0
2000-11-04
36570937
0
DRUGS. PROBATION AND TREATMENT PROGRAM. INITIATIVE STATUTE.
36
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686547
F497
None
S
CVR
0
2000-11-04
None
None
None
S
None
190867515
1074372
686547
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686545
0
2000-11-04
36570936
0
FEES. VOTE REQUIREMENTS. TAXES. INITIATIVE CONSTITUTIONAL AMENDMENT.
37
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686545
F497
None
S
CVR
0
2000-11-04
None
None
None
O
None
190867513
1074372
686545
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686543
0
2000-11-04
36570935
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686543
F497
None
S
CVR
0
2000-11-04
None
None
None
O
None
190867512
1074372
686543
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686541
0
2000-11-04
36570933
0
SCHOOL FACILITIES. 55% LOCAL VOTE. BONDS, TAXES. ACCOUNTABILITY REQUIREMENTS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE.
39
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686541
F497
None
S
CVR
0
2000-11-04
None
None
None
S
None
190867509
1074372
686541
None
F496
0
2000-11-04
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-04
None
F497
F496
686586
0
2000-11-03
36571245
0
YUCAIPA
098307
RAY R.
QUINTO
9097974396
CA
923990000
None
65
None
RCP
SEBASTOPOL
780657
CALIFORNIA NURSES ASSOCIATION PAC (CNA-PAC)
7078742771
CA
954720000
686586
F497
None
S
ASM
CVR
0
2000-11-03
None
None
None
S
None
190857448
1023815
686586
None
F496
0
2000-11-03
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-03
None
F497
F496
686433
0
2000-11-03
36572338
0
LOS ANGELES
099147
DARIO J.
FROMMER
2136239704
CA
900170000
None
43
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686433
F497
None
ASM
S
ASM
CVR
0
2000-11-03
None
None
None
S
None
190447091
1074372
686433
None
F496
0
2000-11-03
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-03
None
F497
F496
686430
0
2000-11-03
36572334
0
ANTIOCH
095057
TOM
TORLAKSON
5103727990
CA
945090000
None
07
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686430
F497
None
SEN
S
SEN
CVR
0
2000-11-03
None
None
None
S
None
190447087
1074372
686430
None
F496
0
2000-11-03
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-03
None
F497
F496
686428
0
2000-11-03
36572332
0
CAMARILLO
092165
ROZ
MC GRATH
8054824960
CA
930100000
None
37
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686428
F497
None
ASM
S
ASM
CVR
0
2000-11-03
None
None
None
S
None
190447084
1074372
686428
None
F496
0
2000-11-03
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-03
None
F497
F496
686418
0
2000-11-03
36572331
0
CHINO
097071
GLORIA NEGRETE
MC LEOD
9096281051
CA
917100000
None
61
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
686418
F497
None
ASM
S
ASM
CVR
0
2000-11-03
None
None
None
S
None
190447082
1074372
686418
None
F496
0
2000-11-03
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-03
None
F497
F496
685779
0
2000-11-03
36570574
0
ANAHEIM
095205
LOU
CORREA
7142850355
CA
928151107
None
69
None
RCP
SANTA ANA
1229802
LABOR COMMUNITY POLITICAL ACTION COMMITTEE
8182600669
CA
92701
685779
F497
None
S
ASM
CVR
0
2000-11-03
None
None
None
S
None
190326084
1229802
685779
None
F496
0
2000-11-04
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-11-03
None
F497
F496
685776
0
2000-11-03
36570573
0
ANAHEIM
095205
LOU
CORREA
7142850355
CA
928151107
None
69
None
RCP
BURBANK
1229857
ORANGE COUNDY FEDERATION OF LABOR COMMITTEE ON POLITICAL EDUCATION
8182600669
CA
91502
685776
F497
None
S
ASM
CVR
0
2000-11-03
None
None
None
S
None
191510915
1229755
685776
None
F496
0
2000-11-04
10001
11001
1999
DMCCASTL
11003
11003
None
None
2000-11-03
None
F497
F496
685340
0
2000-11-03
36569706
0
SCHOOL FACILITIES. 55% LOCAL VOTE. BONDS, TAXES. ACCOUNTABILITY REQUIREMENTS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE.
39
None
None
RCP
PALOS VERDES ESTATES
981414
PALOS VERDES PENINSULA COUNCIL OF PARENT-TEACHER ASSOCIATIONS
3103755281
CA
902740000
685340
F497
None
S
CVR
0
2000-11-03
None
None
None
S
None
190862897
1073479
685340
None
F496
0
2000-11-03
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-03
None
F497
F496
685339
0
2000-11-03
36569705
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
RCP
PALOS VERDES ESTATES
981414
PALOS VERDES PENINSULA COUNCIL OF PARENT-TEACHER ASSOCIATIONS
3103755281
CA
902740000
685339
F497
None
S
CVR
0
2000-11-03
None
None
None
O
None
190862896
1073479
685339
None
F496
0
2000-11-03
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-03
None
F497
F496
685108
0
2000-11-02
36570105
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
BMC
LOS ANGELES
931704
UNITED TEACHERS LOS ANGELES-POLITICAL ACTION COUNCIL OF EDUCATORS (PACE) ISSUES
2134875560
CA
900100000
685108
F497
None
S
CVR
0
2000-11-02
None
None
None
O
None
190865633
1060144
685108
None
F496
0
2000-11-02
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-02
None
F497
F496
684673
0
2000-11-02
36569077
0
CHINO
097071
GLORIA NEGRETE
MC LEOD
9096281051
CA
917100000
None
61
None
RCP
SAN FRANCISCO
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684673
F497
None
S
ASM
CVR
0
2000-11-02
None
None
None
S
None
190866709
1074372
684673
None
F496
0
2000-11-01
10001
11001
1999
BSMITH
11003
11003
None
None
2000-11-02
None
F497
F496
684669
0
2000-11-02
36569075
0
LINDEN
092139
MICHAEL J.
MACHADO
9163192017
CA
952360000
None
05
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684669
F497
None
SEN
S
SEN
CVR
0
2000-11-02
None
None
None
S
None
190866707
1074372
684669
None
F496
0
2000-11-01
10001
11001
1999
BSMITH
11003
11003
None
None
2000-11-02
None
F497
F496
684517
0
2000-11-02
36569033
0
ALAMEDA
099069
WILMA
CHAN
5102726693
CA
945010000
None
16
None
RCP
LOS ANGELES
983392
BLACK LEADERSHIP POLITICAL ACTION COMMITTEE
2134894792
CA
900712300
684517
F497
None
S
ASM
CVR
0
2000-11-02
None
None
None
S
None
190863780
1075441
684517
None
F496
0
2000-11-02
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-02
None
F497
F496
684626
0
2000-11-01
36570516
0
SALINAS
099033
SIMON
SALINAS
8317586276
CA
939050000
None
28
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684626
F497
None
S
ASM
CVR
0
2000-11-01
None
None
None
S
None
190865564
1074372
684626
None
F496
0
2000-11-01
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-01
None
F497
F496
684615
0
2000-11-01
36570502
0
ANTIOCH
095057
TOM
TORLAKSON
5103727990
CA
945090000
None
07
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684615
F497
None
S
SEN
CVR
0
2000-11-01
None
None
None
S
None
190865546
1074372
684615
None
F496
0
2000-11-01
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-01
None
F497
F496
684567
0
2000-11-01
36569541
0
WEST COVINA
099062
RICHARD
MELENDEZ
6269165095
CA
917920000
None
29
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684567
F497
None
S
SEN
CVR
0
2000-11-01
None
None
None
S
None
190864102
1074372
684567
None
F496
0
2000-11-01
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-11-01
None
F497
F496
684554
0
2000-11-01
36569528
0
TRACY
099031
BARBARA
MATTHEWS
2096102253
CA
953760000
None
17
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684554
F497
None
S
ASM
CVR
0
2000-11-01
None
None
None
S
None
190864086
1074372
684554
None
F496
0
2000-11-01
10001
11001
1999
GKURIMOT
11003
11003
None
None
2000-11-01
None
F497
F496
684553
0
2000-11-01
36569059
0
ELK GROVE
098163
DEBRA
GRAVERT
9163192055
CA
957590324
None
10
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684553
F497
None
S
ASM
CVR
0
2000-11-01
None
None
None
S
None
190864082
1074372
684553
None
F496
0
2000-11-01
10001
11001
1999
GKURIMOT
11003
11003
None
None
2000-11-01
None
F497
F496
684549
0
2000-11-01
36569057
0
CAMARILLO
092165
ROZ
MC GRATH
8054824960
CA
930100000
None
37
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
684549
F497
None
S
ASM
CVR
0
2000-11-01
None
None
None
S
None
190864080
1074372
684549
None
F496
0
2000-11-01
10001
11001
1999
GKURIMOT
11003
11003
None
None
2000-11-01
None
F497
F496
684024
0
2000-11-01
36570401
0
DRUGS. PROBATION AND TREATMENT PROGRAM. INITIATIVE STATUTE.
36
None
None
MDI
IRVINE
489015
CROSBY, WILLIAM M.
7145531411
CA
927140000
684024
F497
None
S
CVR
0
2000-11-01
None
None
None
S
None
190868033
1011460
684024
None
F496
0
2000-11-01
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-11-01
None
F497
F496
683845
0
2000-11-01
36569881
0
DRUGS. PROBATION AND TREATMENT PROGRAM. INITIATIVE STATUTE.
36
None
None
MDI
IRVINE
489015
CROSBY, WILLIAM M.
7145531411
CA
927140000
683845
F497
None
S
CVR
0
2000-11-01
None
None
None
S
None
190868245
1011460
683845
None
F496
0
2000-11-01
10001
11001
1999
PBANFORD
11003
11003
None
None
2000-11-01
None
F497
F496
684645
0
2000-10-31
36570522
0
ANAHEIM
095205
LOU
CORREA
7142850355
CA
928151107
None
69
None
RCP
BURBANK
1229802
LABOR COMMUNITY POLITICAL ACTION COMMITTEE
8482600669
CA
91502
684645
F497
None
S
ASM
CVR
0
2000-10-31
None
None
None
S
None
190865571
1229802
684645
None
F496
0
2000-11-01
10001
11001
1999
BSMITH
11003
11003
None
None
2000-10-31
None
F497
F496
683949
0
2000-10-31
36569404
0
1229767
GEORGE
SWENSON
None
24
None
RCP
NAPA
791910
CALIFORNIA RIGHT TO LIFE POLITICAL ACTION COMMITTEE
7072588483
CA
94558
683949
F497
None
S
ASM
CVR
0
2000-10-31
None
None
None
S
None
190322286
1027761
683949
None
F496
0
2000-10-31
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-31
None
F497
F496
683760
0
2000-10-31
36569363
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
BMC
LOS ANGELES
931704
UNITED TEACHERS LOS ANGELES-POLITICAL ACTION COUNCIL OF EDUCATORS (PACE) ISSUES
2134875560
CA
900100000
683760
F497
None
S
CVR
0
2000-10-31
None
None
None
O
None
190866415
1060144
683760
None
F496
0
2000-10-31
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-31
None
F497
F496
682786
1
2000-10-31
36571141
1
VETERANS' BOND ACT OF 2000
32
None
None
RCP
LOS ANGELES
741666
DEMOCRATIC STATE CENTRAL COMMITTEE OF CALIFORNIA
2132561968
CA
900410000
682786
F497
None
S
CVR
0
2000-10-31
None
None
None
S
None
190863079
1018392
682786
0
F496
1
2000-11-05
10002
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-31
None
F497
F496
682786
0
2000-10-31
36570732
0
VETERANS' BOND ACT OF 2000
32
None
None
RCP
LOS ANGELES
741666
DEMOCRATIC STATE CENTRAL COMMITTEE OF CALIFORNIA
2132561968
CA
900410000
682786
F497
None
S
CVR
0
2000-10-31
None
None
None
S
None
190863631
1018392
682786
None
F496
0
2000-10-31
10001
11001
1999
GKURIMOT
11003
11003
None
None
2000-10-31
None
F497
F496
682731
0
2000-10-31
36570730
0
ALAMEDA
099069
WILMA
CHAN
5102726693
CA
945010000
None
16
None
RCP
LOS ANGELES
983392
BLACK LEADERSHIP POLITICAL ACTION COMMITTEE
2134894792
CA
900712300
682731
F497
None
S
ASM
CVR
0
2000-10-31
None
None
None
S
None
190863624
1075441
682731
None
F496
0
2000-10-31
10001
11001
1999
GKURIMOT
11003
11003
None
None
2000-10-31
None
F497
F496
682663
0
2000-10-31
36570229
0
ALTADENA
095231
JACK
SCOTT
6265779944
CA
910010000
None
21
None
RCP
LOS ANGELES
971616
PLANNED PARENTHOOD ADVOCACY PROJECT ACTION FUND
2137407922
CA
900330000
682663
F497
None
S
SEN
CVR
0
2000-10-31
None
None
None
S
None
190867964
1071446
682663
None
F496
0
2000-10-31
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-31
None
F497
F496
682253
0
2000-10-31
36568572
0
FEES. VOTE REQUIREMENTS. TAXES. INITIATIVE CONSTITUTIONAL AMENDMENT.
37
None
None
RCP
PALO ALTO
951348
SANTA CLARA COUNTY LEAGUE OF CONSERVATION VOTERS
4153213627
CA
943010000
682253
F497
None
S
CVR
0
2000-10-31
None
None
None
O
None
190860424
1065855
682253
None
F496
0
2000-10-31
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-31
None
F497
F496
682206
0
2000-10-31
36568547
0
VETERANS' BOND ACT OF 2000
32
None
None
RCP
SACRAMENTO
960895
CALIFORNIA STATE COUNCIL OF SERVICE EMPLOYEES POLITICAL ACTION ISSUES, DEFENSE & ADVOCACY
9164423838
CA
958143407
682206
F497
None
S
CVR
0
2000-10-31
None
None
None
S
None
190859716
1067655
682206
None
F496
0
2000-10-31
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-31
None
F497
F496
682201
0
2000-10-31
36568695
0
LOS ANGELES
098306
GLORIA
ROMERO
3232254999
CA
900320000
None
49
None
RCP
LOS ANGELES
744682
LOS ANGELES COUNTY FEDERATION OF LABOR, AFL-CIO
2133815611
CA
900060000
682201
F497
None
S
ASM
CVR
0
2000-10-31
None
None
None
S
None
190859713
1019160
682201
None
F496
0
2000-10-31
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-31
None
F497
F496
682821
0
2000-10-28
36570743
0
FEES. VOTE REQUIREMENTS. TAXES. INITIATIVE CONSTITUTIONAL AMENDMENT.
37
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682821
F497
None
S
CVR
0
2000-10-28
None
None
None
O
None
190863665
1074372
682821
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682810
0
2000-10-28
36570740
0
CAMPAIGN CONTRIBUTIONS AND SPENDING. LIMITS. DISCLOSURE. LEGISLATIVE INITIATIVE AMENDMENT.
34
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682810
F497
None
S
CVR
0
2000-10-28
None
None
None
S
None
190863657
1074372
682810
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682806
0
2000-10-28
36570737
0
LEGISLATURE. PARTICIPATION IN PUBLIC EMPLOYEES' RETIREMENT SYSTEM. INITIATIVE CONSTITUTIONAL AMENDMENT.
33
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682806
F497
None
S
CVR
0
2000-10-28
None
None
None
S
None
190863646
1074372
682806
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682799
0
2000-10-28
36570734
0
VETERANS' BOND ACT OF 2000
32
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682799
F497
None
S
CVR
0
2000-10-28
None
None
None
S
None
190863640
1074372
682799
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682697
0
2000-10-28
36570721
0
DRUGS. PROBATION AND TREATMENT PROGRAM. INITIATIVE STATUTE.
36
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682697
F497
None
S
CVR
0
2000-10-28
None
None
None
S
None
190868012
1074372
682697
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682689
0
2000-10-28
36570247
0
PUBLIC WORKS PROJECTS. USE OF PRIVATE CONTRACTORS FOR ENGINEERING AND ARCHITECTURAL SERVICES. INITIATIVE CONSTITUTIONAL AMEND
35
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682689
F497
None
S
CVR
0
2000-10-28
None
None
None
O
None
190867994
1074372
682689
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682671
0
2000-10-28
36570242
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682671
F497
None
S
CVR
0
2000-10-28
None
None
None
O
None
190867985
1074372
682671
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682650
0
2000-10-28
36569769
0
SAN DIEGO
099028
CHRISTINE
KEHOE
6192366633
CA
921160000
None
76
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682650
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190867655
1074372
682650
None
F496
0
2000-10-28
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-10-28
None
F497
F496
682637
0
2000-10-28
36569761
0
SAN DIEGO
095062
HOWARD
WAYNE
6192347878
CA
921100000
None
78
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682637
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861935
1074372
682637
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682620
0
2000-10-28
36569753
0
SAN DIEGO
090475
DEDE
ALPERT
6194575775
CA
921380000
None
39
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682620
F497
None
S
SEN
CVR
0
2000-10-28
None
None
None
S
None
190861920
1074372
682620
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682606
0
2000-10-28
36569745
0
CERRITOS
095099
SALLY M.
HAVICE
9164456047
CA
907030000
None
56
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682606
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861901
1074372
682606
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682600
0
2000-10-28
36569262
0
LONG BEACH
098167
ALAN
LOWENTHAL
5624954766
CA
908030000
None
54
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682600
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861889
1074372
682600
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682593
0
2000-10-28
36569260
0
LA CANADA FLINTRIDGE
099064
CAROL
LIU
8189520486
CA
910110000
None
44
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682593
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861882
1074372
682593
None
F496
0
2000-10-28
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-28
None
F497
F496
682586
0
2000-10-28
36569256
0
LOS ANGELES
099147
DARIO J.
FROMMER
2136239704
CA
900170000
None
43
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682586
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861875
1074372
682586
None
F496
0
2000-10-28
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-10-28
None
F497
F496
682529
0
2000-10-28
36569233
0
WEST COVINA
099062
RICHARD
MELENDEZ
6269165095
CA
917920000
None
29
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682529
F497
None
S
SEN
CVR
0
2000-10-28
None
None
None
S
None
190861179
1074372
682529
None
F496
0
2000-10-28
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-10-28
None
F497
F496
682526
0
2000-10-28
36567350
0
SARATOGA
099065
REBECCA
COHN
4088680249
CA
950700000
None
24
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682526
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861177
1074372
682526
None
F496
0
2000-10-28
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-10-28
None
F497
F496
682524
0
2000-10-28
36567348
0
COVINA
099206
MELINE DOLORES
HALL
6269158892
CA
917230000
None
59
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682524
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861174
1074372
682524
None
F496
0
2000-10-28
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-28
None
F497
F496
682517
0
2000-10-28
36567346
0
ANTIOCH
095057
TOM
TORLAKSON
5103727990
CA
945090000
None
07
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682517
F497
None
S
SEN
CVR
0
2000-10-28
None
None
None
S
None
190861169
1074372
682517
None
F496
0
2000-10-28
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-10-28
None
F497
F496
682512
0
2000-10-28
36567344
0
SALINAS
099033
SIMON
SALINAS
8317586276
CA
939050000
None
28
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682512
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861166
1074372
682512
None
F496
0
2000-10-28
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-28
None
F497
F496
682509
0
2000-10-28
36567340
0
CAMARILLO
092165
ROZ
MC GRATH
8054824960
CA
930100000
None
37
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682509
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861160
1074372
682509
None
F496
0
2000-10-28
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-28
None
F497
F496
682504
0
2000-10-28
36567338
0
SAN FRANCISCO
087039
JOHN L.
BURTON
4155571300
CA
941040000
None
03
None
RCP
SAN FRANCISCO
941562
SAN FRANCISCO LABOR COUNCIL LABOR AND NEIGHBOR
4154404809
CA
941090000
682504
F497
None
S
SEN
CVR
0
2000-10-28
None
None
None
S
None
190861154
1062246
682504
None
F496
0
2000-10-28
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-28
None
F497
F496
682503
0
2000-10-28
36567337
0
LINDEN
092139
MICHAEL J.
MACHADO
9163192017
CA
952360000
None
05
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682503
F497
None
S
SEN
CVR
0
2000-10-28
None
None
None
S
None
190861152
1074372
682503
None
F496
0
2000-10-28
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-10-28
None
F497
F496
682501
0
2000-10-28
36567336
0
SAN FRANCISCO
097006
CAROLE
MIGDEN
4155573000
CA
941090000
None
13
None
RCP
SAN FRANCISCO
941562
SAN FRANCISCO LABOR COUNCIL LABOR AND NEIGHBOR
4154404809
CA
941090000
682501
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861149
1062246
682501
None
F496
0
2000-10-28
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-28
None
F497
F496
682499
0
2000-10-28
36567334
0
TRACY
099031
BARBARA
MATTHEWS
2096102253
CA
953760000
None
17
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682499
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861145
1074372
682499
None
F496
0
2000-10-28
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-28
None
F497
F496
682498
0
2000-10-28
36567333
0
SAN FRANCISCO
095173
KEVIN
SHELLEY
4155572312
CA
941310000
None
12
None
RCP
SAN FRANCISCO
941562
SAN FRANCISCO LABOR COUNCIL LABOR AND NEIGHBOR
4154404809
CA
941090000
682498
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861144
1062246
682498
None
F496
0
2000-10-28
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-28
None
F497
F496
682494
0
2000-10-28
36567332
0
ELK GROVE
098163
DEBRA
GRAVERT
9163192055
CA
957590324
None
10
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682494
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861142
1074372
682494
None
F496
0
2000-10-28
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-28
None
F497
F496
682493
0
2000-10-28
36567331
0
SCHOOL FACILITIES. 55% LOCAL VOTE. BONDS, TAXES. ACCOUNTABILITY REQUIREMENTS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE.
39
None
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682493
F497
None
S
CVR
0
2000-10-28
None
None
None
S
None
190861141
1074372
682493
None
F496
0
2000-10-28
10001
11001
1999
GGILMORE
11003
11001
None
None
2000-10-28
None
F497
F496
682481
0
2000-10-28
36567327
0
CHINO
097071
GLORIA NEGRETE
MC LEOD
9096281051
CA
917100000
None
61
None
RCP
SAN FRANCISCO
982314
LABOR 2000 - CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
682481
F497
None
S
ASM
CVR
0
2000-10-28
None
None
None
S
None
190861136
1074372
682481
None
F496
0
2000-10-28
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-28
None
F497
F496
679551
0
2000-10-28
36567841
0
VETERANS' BOND ACT OF 2000
32
None
None
RCP
SACRAMENTO
960895
CALIFORNIA STATE COUNCIL OF SERVICE EMPLOYEES POLITICAL ACTION ISSUES, DEFENSE & ADVOCACY
9164423838
CA
958143407
679551
F497
None
S
CVR
0
2000-10-28
None
None
None
S
None
190851151
1067655
679551
None
F496
0
2000-10-28
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-28
None
F497
F496
684044
0
2000-10-27
36570867
0
CAMPAIGN CONTRIBUTIONS AND SPENDING. LIMITS. DISCLOSURE. LEGISLATIVE INITIATIVE AMENDMENT.
34
None
None
MDI
NEWPORT BEACH
489386
BRYN MAWR INC
7147598091
CA
926580000
684044
F497
None
S
CVR
0
2000-10-27
None
None
None
S
None
190862521
1011752
684044
None
F496
0
2000-10-27
10001
11001
1999
DHULSE
11003
11003
None
None
2000-10-27
None
F497
F496
680832
1
2000-10-27
36571034
1
LINDEN
MICHAEL J.
MACHADO
9163192017
CA
952360000
None
05
None
RCP
SAN FRANCISCO
960376
CALIFORNIA ABORTION AND REPRODUCTIVE RIGHTS ACTION LEAGUE (CARAL)-NORTH CHOICE PAC
4153341502
CA
941310000
680832
F497
None
S
SEN
CVR
0
2000-10-27
None
None
None
S
None
190864582
1067137
680832
0
F496
1
2000-11-06
10002
11001
1999
PBANFORD
11003
11003
None
None
2000-10-27
None
F497
F496
680832
0
2000-10-27
36567501
0
LINDEN
092139
MICHAEL J.
MACHADO
9163192017
CA
952360000
None
05
None
RCP
SAN FRANCISCO
960376
CALIFORNIA ABORTION AND REPRODUCTIVE RIGHTS ACTION LEAGUE (CARAL)-NORTH CHOICE PAC
4153341502
CA
941310000
680832
F497
None
S
SEN
CVR
0
2000-10-27
None
None
None
S
None
190857634
1067137
680832
None
F496
0
2000-10-27
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-27
None
F497
F496
680777
1
2000-10-27
36571036
1
TRACY
BARBARA
MATTHEWS
2096102253
CA
953760000
None
17
None
RCP
SAN FRANCISCO
960376
CALIFORNIA ABORTION AND REPRODUCTIVE RIGHTS ACTION LEAGUE (CARAL)-NORTH CHOICE PAC
4153341502
CA
941310000
680777
F497
None
S
ASM
CVR
0
2000-10-27
None
None
None
S
None
190864583
1067137
680777
0
F496
1
2000-11-06
10002
11001
1999
PBANFORD
11003
11003
None
None
2000-10-27
None
F497
F496
680777
0
2000-10-27
36568754
0
TRACY
099031
BARBARA
MATTHEWS
2096102253
CA
953760000
None
17
None
RCP
SAN FRANCISCO
960376
CALIFORNIA ABORTION AND REPRODUCTIVE RIGHTS ACTION LEAGUE (CARAL)-NORTH CHOICE PAC
4153341502
CA
941310000
680777
F497
None
S
ASM
CVR
0
2000-10-27
None
None
None
S
None
190862003
1067137
680777
None
F496
0
2000-10-27
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-27
None
F497
F496
679546
0
2000-10-27
36567836
0
LONG BEACH
098167
ALAN
LOWENTHAL
5624954766
CA
908030000
None
54
None
RCP
LOS ANGELES
971616
PLANNED PARENTHOOD ADVOCACY PROJECT ACTION FUND
2137407922
CA
900330000
679546
F497
None
S
ASM
CVR
0
2000-10-27
None
None
None
S
None
190851145
1071446
679546
None
F496
0
2000-10-27
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-27
None
F497
F496
679545
0
2000-10-27
36567835
0
WEST COVINA
099062
RICHARD
MELENDEZ
6269165095
CA
917920000
None
29
None
RCP
LOS ANGELES
971616
PLANNED PARENTHOOD ADVOCACY PROJECT ACTION FUND
2137407922
CA
900330000
679545
F497
None
S
SEN
CVR
0
2000-10-27
None
None
None
S
None
190851144
1071446
679545
None
F496
0
2000-10-27
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-27
None
F497
F496
679543
0
2000-10-27
36567833
0
LOS ANGELES
099147
DARIO J.
FROMMER
2136239704
CA
900170000
None
43
None
RCP
LOS ANGELES
971616
PLANNED PARENTHOOD ADVOCACY PROJECT ACTION FUND
2137407922
CA
900330000
679543
F497
None
S
ASM
CVR
0
2000-10-27
None
None
None
S
None
190851142
1071446
679543
None
F496
0
2000-10-27
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-27
None
F497
F496
679539
0
2000-10-27
36568290
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
BMC
LOS ANGELES
931704
UNITED TEACHERS LOS ANGELES-POLITICAL ACTION COUNCIL OF EDUCATORS (PACE) ISSUES
2134875560
CA
900100000
679539
F497
None
S
CVR
0
2000-10-27
None
None
None
O
None
190851440
1060144
679539
None
F496
0
2000-10-27
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-27
None
F497
F496
679517
0
2000-10-27
36567394
0
ETIWANDA
089034
JAMES L.
BRULTE
9094669096
CA
917390000
None
31
None
RCP
LOS ANGELES
741666
DEMOCRATIC STATE CENTRAL COMMITTEE OF CALIFORNIA
2132561968
CA
900410000
679517
F497
None
S
SEN
CVR
0
2000-10-27
None
None
None
O
None
190862185
1018392
679517
None
F496
0
2000-10-27
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-27
None
F497
F496
679301
0
2000-10-26
36567685
0
SCHOOL VOUCHER STATE FUNDED PRIVATE AND RELIGIOUS EDUCATION PUBLIC SCHOOL FUNDING
38
None
None
MDI
OAKLAND
497034
APPLIED RESEARCH CENTER
5104659577
CA
946120000
679301
F497
None
S
CVR
0
2000-10-26
None
None
None
S
None
190860359
1013994
679301
None
F496
0
2000-10-27
10001
11001
1999
DMCCASTL
11003
11003
None
None
2000-10-26
None
F497
F496
679168
0
2000-10-26
36567670
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
BMC
LOS ANGELES
931704
UNITED TEACHERS LOS ANGELES-POLITICAL ACTION COUNCIL OF EDUCATORS (PACE) ISSUES
2134875560
CA
900100000
679168
F497
None
S
CVR
0
2000-10-26
None
None
None
O
None
190857737
1060144
679168
None
F496
0
2000-10-26
10001
11001
1999
SARRIAGA
11003
11003
None
None
2000-10-26
None
F497
F496
677804
0
2000-10-26
36567999
0
PROP 38 SCHOOL VOUCHERS
38
None
None
RCP
SAN FRANCISCO
741504
STANDING COMMITTEE ON POLITICAL EDUCATION OF THE CALIFORNIA LABOR FEDERATION, AFL-CIO
4159863585
CA
941040000
677804
F497
None
S
CVR
0
2000-10-26
None
None
None
O
None
190860311
1018355
677804
None
F496
0
2000-10-26
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-26
None
F497
F496
677809
0
2000-10-25
36568003
0
CAMPAIGN CONTRIBUTIONS AND SPENDING. LIMITS. DISCLOSURE. LEGISLATIVE INITIATIVE AMENDMENT.
34
None
None
MDI
IRVINE
499503
CALIFORNIA COASTAL COMMUNITIES, INC. AND SUBSIDIARIES
9492507783
CA
926140000
677809
F497
None
S
CVR
0
2000-10-25
None
None
None
S
None
190860315
1015941
677809
None
F496
0
2000-10-26
10001
11001
1999
GPEREZ
11003
11003
None
None
2000-10-25
None
F497
F496
677712
0
2000-10-25
36567513
0
ETIWANDA
089034
JAMES L.
BRULTE
9094669096
CA
917390000
None
31
None
RCP
SACRAMENTO
743501
STATE BUILDING & CONSTRUCTION TRADES COUNCIL OF CALIFORNIA
9164433302
CA
958140000
677712
F497
None
S
SEN
CVR
0
2000-10-25
None
None
None
O
None
190858846
1018846
677712
None
F496
0
2000-10-25
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-25
None
F497
F496
677646
0
2000-10-25
36568046
0
DRUGS. PROBATION AND TREATMENT PROGRAM. INITIATIVE STATUTE.
36
None
None
MDI
COLORADO SPRINGS
1221947
FOCUS ON THE FAMILY
7195313400
CO
80920
677646
F497
None
S
CVR
0
2000-10-25
None
None
None
O
None
190857361
1221947
677646
None
F496
0
2000-10-26
10001
11001
1999
NJACKSON
11003
11003
None
None
2000-10-25
None
F497
F496
677633
0
2000-10-25
36568040
0
SCHOOL VOUCHERS. STATE-FUNDED PRIVATE AND RELIGIOUS EDUCATION. PUBLIC SCHOOL FUNDING. INITIATIVE CONSTITUTIONAL AMENDMENT.
38
None
None
MDI
COLORADO SPRINGS
1221947
FOCUS ON THE FAMILY
7195313400
CO
80920
677633
F497
None
S
CVR
0
2000-10-25
None
None
None
S
None
190857354
1221947
677633
None
F496
0
2000-10-25
10001
11001
1999
NJACKSON
11003
11003
None
None
2000-10-25
None
F497
F496
677463
0
2000-10-25
36568841
0
PROPOSITION 39 SCHOOL FACILITIES
39
None
None
MDI
IRVINE
499503
CALIFORNIA COASTAL COMMUNITIES, INC. AND SUBSIDIARIES
9492507783
CA
926140000
677463
F497
None
S
CVR
0
2000-10-25
None
None
None
S
None
190859540
1015941
677463
None
F496
0
2000-10-25
10001
11001
1999
DHULSE
11003
11003
None
None
2000-10-25
None
F497
F496
677450
0
2000-10-25
36568837
0
PROPOSITION 32 VETERANS' BOND ACT OF 2000
32
None
None
RCP
SACRAMENTO
911908
PEACE OFFICERS RESEARCH ASSOCIATION OF CALIFORNIA POLITICAL ISSUES COMMITTEE (PORAC PAC)
9169210660
CA
958330000
677450
F497
None
S
CVR
0
2000-10-25
None
None
None
S
None
190859532
1054918
677450
None
F496
0
2000-10-25
10001
11001
1999
CFLAGG
11003
11003
None
None
2000-10-25
None
F497
F496
676403
0
2000-10-25
36565785
0
ANAHEIM
095205
LOU
CORREA
7142850355
CA
928151107
None
69
None
RCP
TUSTIN
950925
ORANGE COUNTY PROFESIONAL FIREFIGHTERS ASSOCIATION 3631 PAC
7142583636
CA
926500000
676403
F497
None
S
ASM
CVR
0
2000-10-25
None
None
None
S
None
190859961
1065432
676403
None
F496
0
2000-10-25
10001
11001
1999
PBANFORD
11003
11003
None
None
2000-10-25
None
F497
F496
676385
0
2000-10-25
36565783
0
ANAHEIM
095205
LOU
CORREA
7142850355
CA
928151107
None
69
None
RCP
TUSTIN
950925
ORANGE COUNTY PROFESIONAL FIREFIGHTERS ASSOCIATION 3631 PAC
7142583636
CA
926500000
676385
F497
None
S
ASM
CVR
0
2000-10-25
None
None
None
S
None
190859956
1065432
676385
None
F496
0
2000-10-25
10001
11001
1999
PBANFORD
11003
11003
None
None
2000-10-25
None
Yes, this happens about a third of the time.
In [7]:
%%sql
SELECT COUNT(*)::float / (
SELECT COUNT(*)
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" CVR
JOIN "FILER_FILINGS_CD" FF
ON CVR."FILING_ID" = FF."FILING_ID"
AND CVR."AMEND_ID" = FF."FILING_SEQUENCE"
) as pct_conflict
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" CVR
JOIN "FILER_FILINGS_CD" FF
ON CVR."FILING_ID" = FF."FILING_ID"
AND CVR."AMEND_ID" = FF."FILING_SEQUENCE"
WHERE CVR."FILER_ID" <> FF."FILER_ID"::VARCHAR;
1 rows affected.
Out[7]:
pct_conflict
0.357836331069
But one thing to note is that these FILER_ID fields are too different data types: char on CVR_CAMPAIGN_DISCLOSURE_CD and int on FILER_FILINGS_CD. We previously discovered that the FILER_XREF_CD table is a translator from seemingly old string filer_ids to numeric filer_ids.
No. Here are the missing filer_ids, which are also not found in either the FILERNAME_CD or FILERS_CD tables.
In [8]:
%%sql
SELECT
cvr."FILER_ID" as cvr_filer_id,
fn."FILER_ID" as filername_filer_id,
f."FILER_ID" as filer_filer_id
FROM (
SELECT DISTINCT cvr."FILER_ID"
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" cvr
LEFT JOIN "FILER_XREF_CD" x
ON cvr."FILER_ID" = x."XREF_ID"
WHERE x."XREF_ID" IS NULL
) cvr
LEFT JOIN "FILERNAME_CD" fn
ON cvr."FILER_ID" = fn."FILER_ID"::varchar
LEFT JOIN "FILERS_CD" f
ON cvr."FILER_ID" = f."FILER_ID"::varchar
ORDER BY cvr."FILER_ID"::VARCHAR DESC;
45 rows affected.
Out[8]:
cvr_filer_id
filername_filer_id
filer_filer_id
990168
None
None
600230
None
None
499258
None
None
496280
None
None
489049
None
None
486187
None
None
482185
None
None
478533
None
None
1373290
None
None
1372926
None
None
1371922
None
None
1371599
None
None
1365125
None
None
1359309
None
None
1357692
None
None
1354374
None
None
1353036
None
None
1352598
None
None
1345410
None
None
1345405
None
None
1345402
None
None
1345401
None
None
1335759
None
None
1319580
None
None
1313228
None
None
1286496
None
None
1281446
None
None
1281078
None
None
1273757
None
None
1273587
None
None
1273518
None
None
1271579
None
None
1262407
None
None
1258927
None
None
1258401
None
None
1256142
None
None
1255645
None
None
1252593
None
None
1246958
None
None
1245799
None
None
1229857
None
None
1221990
None
None
1221935
None
None
1221920
None
None
None
None
Should probably look more into these later, but this might have something to do with conflicting filer_ids on CVR_CAMPAIGN_DISCLOSURE_CD and FILER_FILINGS_CD.
Yes, but less than 1 percent of the time.
In [9]:
%%sql
SELECT COUNT(*)::float / (
SELECT COUNT(*)
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" CVR
JOIN "FILER_FILINGS_CD" FF
ON CVR."FILING_ID" = FF."FILING_ID"
AND CVR."AMEND_ID" = FF."FILING_SEQUENCE"
) as pct_conflict
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" CVR
JOIN "FILER_FILINGS_CD" FF
ON CVR."FILING_ID" = FF."FILING_ID"
AND CVR."AMEND_ID" = FF."FILING_SEQUENCE"
JOIN "FILER_XREF_CD" X
ON CVR."FILER_ID" = X."XREF_ID"
WHERE X."FILER_ID" <> FF."FILER_ID";
1 rows affected.
Out[9]:
pct_conflict
0.0034393581278
Mostly this seems to be a problem for Form 497 filings.
In [10]:
%%sql
SELECT cvr."FORM_TYPE", COUNT(*)
FROM "CVR_CAMPAIGN_DISCLOSURE_CD" CVR
JOIN "FILER_FILINGS_CD" FF
ON CVR."FILING_ID" = FF."FILING_ID"
AND CVR."AMEND_ID" = FF."FILING_SEQUENCE"
JOIN "FILER_XREF_CD" X
ON CVR."FILER_ID" = X."XREF_ID"
WHERE X."FILER_ID" <> FF."FILER_ID"
GROUP BY 1;
2 rows affected.
Out[10]:
FORM_TYPE
count
F461
7
F497
1291
I guess there always has to be at least one.
In [11]:
%%sql
SELECT "FILING_ID", COUNT(DISTINCT "FORM_ID")
FROM "FILER_FILINGS_CD"
WHERE "FORM_ID" IN (
SELECT DISTINCT "FORM_TYPE"
FROM "CVR_CAMPAIGN_DISCLOSURE_CD"
)
GROUP BY 1
HAVING COUNT(DISTINCT "FORM_ID") > 1
ORDER BY 1 DESC;
1 rows affected.
Out[11]:
FILING_ID
count
826532
2
In [12]:
%%sql
SELECT *
FROM "FILER_FILINGS_CD"
WHERE "FILING_ID" = 826532;
2 rows affected.
Out[12]:
id
FILER_ID
FILING_ID
PERIOD_ID
FORM_ID
FILING_SEQUENCE
FILING_DATE
STMNT_TYPE
STMNT_STATUS
SESSION_ID
USER_ID
SPECIAL_AUDIT
FINE_AUDIT
RPT_START
RPT_END
RPT_DATE
FILING_TYPE
190960875
1076525
826532
None
F461
1
2000-02-29
10006
11003
2001
DBARRICK
11003
11003
2000-01-23
2000-02-19
None
None
190960874
1076525
826532
None
F460
0
2001-02-23
10005
11003
2001
DBARRICK
11003
11003
2000-01-23
2000-02-19
None
None
But there aren't any CVR_CAMPAIGN_DISCLOSURE_CD or SMRY_CD records for this filing_id, so maybe it isn't real.
In [13]:
%%sql
SELECT *
FROM "CVR_CAMPAIGN_DISCLOSURE_CD"
WHERE "FILING_ID" = 826532;
SELECT *
FROM "SMRY_CD"
WHERE "FILING_ID" = 826532;
0 rows affected.
0 rows affected.
Out[13]:
id
FILING_ID
AMEND_ID
LINE_ITEM
REC_TYPE
FORM_TYPE
AMOUNT_A
AMOUNT_B
AMOUNT_C
ELEC_DT
Even when we narrow to only the campaign finance-related forms, the answer is "yes".
In [18]:
%%sql
SELECT "FILING_ID", COUNT(DISTINCT "FILING_SEQUENCE"), COUNT(DISTINCT "FILER_ID")
FROM "FILER_FILINGS_CD"
WHERE "FORM_ID" IN (
SELECT DISTINCT "FORM_TYPE"
FROM "CVR_CAMPAIGN_DISCLOSURE_CD"
)
GROUP BY 1
HAVING COUNT(DISTINCT "FILER_ID") > 1
ORDER BY 1 DESC;
1274 rows affected.
Out[18]:
FILING_ID
count
count_1
688996
1
2
688995
1
2
688400
1
2
688397
1
2
688395
1
2
688393
1
2
688375
1
2
688374
1
2
688373
1
2
688371
1
2
688369
1
2
688368
1
2
688367
1
2
688366
1
2
688365
1
2
688364
1
2
688362
1
2
688172
1
2
688170
1
2
687947
1
2
687946
1
2
687944
1
2
687941
1
2
687940
1
2
687939
1
2
687376
1
2
687373
1
2
687372
1
2
687369
1
2
687368
1
2
687366
1
2
687365
1
2
687364
1
2
687363
1
2
687343
1
2
687342
1
2
687340
1
2
687339
1
2
687338
1
2
687334
1
2
687333
1
2
687332
1
2
687331
1
2
687330
1
2
687328
1
2
687327
1
2
687325
1
2
687324
1
2
687323
1
2
687322
1
2
687321
1
2
687320
1
2
687319
1
2
687318
1
2
687317
1
2
687316
1
2
687315
1
2
687313
1
2
687297
1
2
687278
1
2
687277
1
2
687276
1
2
687275
1
2
687274
1
2
687273
1
2
687272
1
2
687271
1
2
687269
1
2
687267
1
2
687266
1
2
687265
1
2
687264
1
2
687261
1
2
687259
1
2
687257
1
2
687256
1
2
687255
1
2
687254
1
2
687252
1
2
687251
1
2
687250
1
2
687240
1
2
687237
1
2
687232
1
2
687207
1
2
687200
1
2
687189
1
2
687161
1
2
687160
1
2
687159
1
2
687158
1
2
687144
1
2
687133
1
2
687126
1
2
686635
1
2
686633
1
2
686631
1
2
686623
1
2
686620
1
2
686618
1
2
686616
1
2
686612
1
2
686609
1
2
686602
1
2
686601
1
2
686599
1
2
686587
1
2
686584
1
2
686582
1
2
686581
1
2
686580
1
2
686579
1
2
686578
1
2
686577
1
2
686567
1
2
686566
1
2
686565
3
2
686564
1
2
686563
1
2
686561
1
2
686560
2
2
686559
1
2
686554
2
2
686551
1
2
686542
1
2
686538
1
2
686536
1
2
686535
1
2
686533
1
2
686530
1
2
686527
1
2
686523
1
2
686522
1
2
686519
1
2
686514
1
2
686510
1
2
686509
1
2
686507
1
2
686496
1
2
686495
1
2
686494
1
2
686492
1
2
686491
1
2
686490
1
2
686489
1
2
686488
1
2
686487
1
2
686485
1
2
686484
1
2
686483
1
2
686481
1
2
686480
1
2
686476
1
2
686472
1
2
686469
1
2
686467
3
2
686460
1
2
686457
1
2
686452
1
2
686442
1
2
686440
1
2
686427
1
2
686426
1
2
686425
1
2
686424
1
2
686422
1
2
686421
1
2
686420
1
2
686419
1
2
686417
1
2
686414
1
2
686413
1
2
686409
1
2
686408
1
2
686406
1
2
686404
1
2
686402
1
2
686395
1
2
686394
1
2
686393
1
2
686385
1
2
686374
1
2
686369
1
2
686361
1
2
686359
1
2
686342
1
2
686341
1
2
686336
1
2
686333
1
2
686322
1
2
686321
1
2
686318
1
2
686317
1
2
686314
1
2
686311
1
2
686310
1
2
686121
1
2
686101
1
2
686099
1
2
686098
1
2
686097
1
2
686096
1
2
686095
1
2
686094
1
2
686072
1
2
686070
1
2
686064
1
2
686059
1
2
686055
1
2
686052
1
2
686050
1
2
686049
1
2
686024
1
2
686023
1
2
686022
1
2
686021
1
2
685937
1
2
685936
2
2
685902
1
2
685901
1
2
685900
1
2
685898
1
2
685890
1
2
685889
1
2
685888
1
2
685887
1
2
685886
1
2
685884
1
2
685883
1
2
685882
1
2
685881
1
2
685880
1
2
685879
1
2
685878
2
2
685877
1
2
685876
1
2
685875
1
2
685874
1
2
685872
1
2
685871
1
2
685869
1
2
685868
2
2
685866
1
2
685865
1
2
685864
1
2
685863
1
2
685862
1
2
685861
1
2
685860
1
2
685859
1
2
685858
1
2
685854
1
2
685852
1
2
685851
1
2
685838
1
2
685836
1
2
685835
1
2
685833
1
2
685829
1
2
685827
1
2
685813
1
2
685811
1
2
685810
1
2
685808
1
2
685807
1
2
685803
1
2
685802
1
2
685801
1
2
685800
1
2
685798
1
2
685796
1
2
685795
2
2
685792
1
2
685790
1
2
685789
1
2
685788
1
2
685787
1
2
685777
1
2
685774
1
2
685773
1
2
685701
1
2
685700
1
2
685696
1
2
685685
1
2
685684
1
2
685683
1
2
685682
1
2
685678
1
2
685677
1
2
685676
1
2
685675
1
2
685674
1
2
685668
1
2
685667
1
2
685662
1
2
685661
1
2
685660
1
2
685659
1
2
685657
1
2
685656
1
2
685655
1
2
685654
1
2
685653
1
2
685652
1
2
685650
1
2
685648
1
2
685647
1
2
685645
1
2
685644
1
2
685642
1
2
685641
1
2
685638
1
2
685636
1
2
685635
1
2
685633
1
2
685632
1
2
685631
1
2
685630
1
2
685628
1
2
685627
1
2
685626
1
2
685625
1
2
685623
1
2
685616
1
2
685613
1
2
685607
1
2
685606
1
2
685605
2
2
685604
1
2
685603
1
2
685599
1
2
685596
1
2
685593
1
2
685591
1
2
685590
1
2
685584
1
2
685558
1
2
685440
1
2
685422
1
2
685420
1
2
685418
1
2
685416
1
2
685415
1
2
685414
1
2
685411
1
2
685409
1
2
685408
1
2
685406
1
2
685404
1
2
685398
1
2
685390
1
2
685385
1
2
685382
1
2
685380
1
2
685377
1
2
685374
2
2
685373
1
2
685372
1
2
685370
1
2
685369
1
2
685368
1
2
685361
1
2
685360
1
2
685358
1
2
685355
1
2
685353
1
2
685335
1
2
685329
1
2
685325
1
2
685323
1
2
685321
1
2
685320
1
2
685319
1
2
685302
1
2
685300
1
2
685299
1
2
685298
1
2
685296
1
2
685286
1
2
685283
1
2
685282
1
2
685279
1
2
685278
1
2
685273
1
2
685271
1
2
685270
1
2
685267
1
2
685255
1
2
685254
1
2
685253
1
2
685245
1
2
685235
1
2
685230
1
2
685223
2
2
685215
1
2
685211
1
2
685194
1
2
685190
1
2
685184
1
2
685183
1
2
685175
1
2
685174
1
2
685164
1
2
685160
1
2
685155
1
2
685154
1
2
685148
1
2
685143
1
2
685142
1
2
685126
1
2
685125
1
2
685124
1
2
685121
1
2
685119
1
2
685117
1
2
685115
1
2
685110
1
2
685109
1
2
685107
1
2
685106
1
2
685103
1
2
685102
1
2
685096
1
2
685093
1
2
685092
1
2
685091
1
2
685082
1
2
685080
1
2
685077
1
2
685071
1
2
685058
1
2
685052
1
2
685051
1
2
685048
1
2
685037
1
2
685017
1
2
685012
1
2
685000
1
2
684997
2
2
684987
1
2
684985
1
2
684983
1
2
684979
1
2
684977
1
2
684976
1
2
684975
1
2
684971
1
2
684954
1
2
684704
1
2
684701
1
2
684698
1
2
684697
1
2
684695
1
2
684694
1
2
684684
1
2
684682
1
2
684674
1
2
684668
1
2
684667
1
2
684666
1
2
684664
2
2
684663
1
2
684662
1
2
684661
1
2
684660
1
2
684659
1
2
684658
1
2
684656
1
2
684655
1
2
684652
1
2
684650
1
2
684648
1
2
684647
1
2
684637
1
2
684631
1
2
684630
1
2
684624
1
2
684606
1
2
684603
1
2
684602
1
2
684598
1
2
684594
1
2
684592
1
2
684588
1
2
684581
1
2
684577
1
2
684574
1
2
684573
2
2
684569
2
2
684564
1
2
684560
1
2
684558
1
2
684551
1
2
684548
1
2
684542
1
2
684535
1
2
684534
1
2
684531
1
2
684525
1
2
684523
1
2
684521
1
2
684516
1
2
684508
1
2
684497
1
2
684485
1
2
684477
1
2
684473
1
2
684469
1
2
684461
1
2
684452
1
2
684444
1
2
684443
1
2
684435
1
2
684422
2
2
684417
1
2
684415
1
2
684414
1
2
684403
1
2
684399
1
2
684397
1
2
684389
1
2
684387
1
2
684382
1
2
684380
1
2
684377
1
2
684367
1
2
684365
1
2
684360
1
2
684358
1
2
684356
1
2
684344
1
2
684339
1
2
684334
1
2
684329
1
2
684323
1
2
684322
1
2
684319
1
2
684316
1
2
684315
1
2
684312
1
2
684310
1
2
684308
1
2
684306
1
2
684305
1
2
684303
1
2
684299
1
2
684289
1
2
684286
1
2
684040
1
2
684039
1
2
684031
2
2
684018
1
2
684017
1
2
684012
1
2
684011
1
2
684010
1
2
684008
1
2
684004
1
2
683995
1
2
683993
1
2
683991
2
2
683990
1
2
683988
1
2
683986
1
2
683985
1
2
683981
1
2
683980
1
2
683979
1
2
683977
1
2
683976
1
2
683967
1
2
683966
1
2
683961
1
2
683959
1
2
683956
1
2
683950
1
2
683942
1
2
683941
1
2
683934
1
2
683933
1
2
683932
1
2
683915
1
2
683907
1
2
683903
1
2
683900
1
2
683899
1
2
683894
1
2
683892
1
2
683889
1
2
683888
1
2
683886
1
2
683883
1
2
683879
1
2
683870
1
2
683861
2
2
683852
1
2
683847
1
2
683844
1
2
683843
1
2
683841
1
2
683838
1
2
683836
1
2
683830
1
2
683827
1
2
683821
1
2
683794
1
2
683777
1
2
683762
1
2
683746
1
2
683703
1
2
683700
1
2
683694
1
2
683692
1
2
683681
1
2
683676
1
2
683671
1
2
683649
1
2
683643
1
2
683641
1
2
683640
1
2
683638
1
2
683636
1
2
683634
1
2
683633
1
2
683629
1
2
683620
1
2
683607
1
2
683597
1
2
683593
1
2
683537
1
2
683516
2
2
683503
1
2
683494
1
2
683488
1
2
683398
1
2
683397
1
2
683392
1
2
683384
1
2
683380
1
2
683377
1
2
683376
1
2
683371
1
2
683370
2
2
683367
1
2
683027
1
2
682988
1
2
682984
1
2
682978
1
2
682969
1
2
682965
1
2
682961
1
2
682957
1
2
682954
1
2
682951
1
2
682913
1
2
682910
1
2
682909
1
2
682908
1
2
682907
1
2
682903
1
2
682900
1
2
682896
1
2
682894
1
2
682888
1
2
682886
1
2
682882
1
2
682863
1
2
682857
1
2
682856
1
2
682854
1
2
682848
1
2
682845
1
2
682842
1
2
682832
1
2
682811
1
2
682802
1
2
682796
1
2
682790
1
2
682762
1
2
682735
1
2
682704
1
2
682700
1
2
682698
1
2
682693
1
2
682692
1
2
682691
1
2
682687
1
2
682677
1
2
682672
1
2
682667
1
2
682664
1
2
682660
1
2
682658
1
2
682656
1
2
682655
1
2
682654
1
2
682647
1
2
682640
1
2
682639
1
2
682627
1
2
682625
1
2
682616
1
2
682609
1
2
682603
1
2
682597
1
2
682591
1
2
682587
1
2
682566
1
2
682536
1
2
682520
1
2
682516
1
2
682496
1
2
682485
1
2
682479
1
2
682461
1
2
682458
1
2
682450
1
2
682448
1
2
682445
1
2
682438
1
2
682431
1
2
682419
1
2
682401
1
2
682385
1
2
682345
1
2
682330
1
2
682325
1
2
682321
1
2
682320
1
2
682317
1
2
682316
1
2
682300
1
2
682293
1
2
682285
1
2
682263
1
2
682245
1
2
682235
1
2
682222
1
2
682221
1
2
682218
1
2
682211
1
2
682210
1
2
682207
1
2
682133
1
2
682122
1
2
682118
1
2
682108
1
2
682093
1
2
682080
1
2
682078
1
2
682077
1
2
682054
1
2
682040
1
2
682039
1
2
682012
1
2
682006
1
2
681998
1
2
681997
1
2
681996
1
2
681995
1
2
681969
1
2
681872
1
2
681867
1
2
681849
1
2
681847
1
2
681844
1
2
681838
1
2
681837
1
2
681833
1
2
681242
1
2
681224
1
2
681223
1
2
681222
1
2
681219
1
2
681215
1
2
681214
1
2
681209
1
2
681207
2
2
681206
1
2
681200
1
2
681194
1
2
681188
2
2
681184
1
2
681183
1
2
681178
1
2
681162
1
2
681160
1
2
681158
1
2
681153
1
2
681132
1
2
681114
1
2
681113
1
2
681110
1
2
681103
2
2
681101
1
2
681091
1
2
681028
1
2
680928
1
2
680911
1
2
680897
1
2
680895
1
2
680894
1
2
680892
1
2
680890
1
2
680879
1
2
680873
1
2
680869
1
2
680868
1
2
680859
1
2
680855
2
2
680849
1
2
680846
1
2
680809
1
2
680799
1
2
680788
1
2
680778
1
2
680686
1
2
680679
1
2
680658
1
2
680655
1
2
680654
1
2
680650
1
2
680648
1
2
680645
1
2
680643
1
2
680642
1
2
680638
1
2
680637
1
2
680636
1
2
680635
1
2
680634
1
2
680633
1
2
680632
1
2
680626
1
2
680624
1
2
680621
1
2
680620
1
2
680609
1
2
680599
1
2
680597
1
2
680588
1
2
680586
1
2
680580
1
2
680579
1
2
680578
1
2
680576
1
2
680574
1
2
680570
1
2
680569
2
2
680568
1
2
680566
1
2
680564
1
2
680559
1
2
680558
1
2
680557
1
2
679814
1
2
679810
1
2
679804
1
2
679801
1
2
679795
1
2
679793
1
2
679790
1
2
679789
1
2
679788
1
2
679787
1
2
679785
1
2
679783
1
2
679777
1
2
679775
1
2
679772
1
2
679762
1
2
679756
1
2
679755
1
2
679751
1
2
679732
1
2
679727
1
2
679724
1
2
679723
1
2
679720
1
2
679709
1
2
679704
1
2
679703
1
2
679681
1
2
679678
1
2
679677
1
2
679676
1
2
679672
1
2
679668
1
2
679667
1
2
679665
1
2
679663
1
2
679660
1
2
679658
1
2
679657
1
2
679655
1
2
679653
1
2
679652
1
2
679651
1
2
679647
1
2
679646
1
2
679645
1
2
679644
1
2
679643
1
2
679640
1
2
679636
1
2
679635
1
2
679614
1
2
679611
1
2
679595
1
2
679580
1
2
679577
1
2
679574
1
2
679570
1
2
679568
1
2
679566
1
2
679562
1
2
679559
1
2
679555
1
2
679553
1
2
679541
1
2
679537
1
2
679536
1
2
679535
1
2
679534
1
2
679533
1
2
679532
1
2
679531
1
2
679527
1
2
679525
1
2
679523
1
2
679522
1
2
679520
1
2
679519
1
2
679518
1
2
679516
1
2
679504
1
2
679500
1
2
679358
1
2
679342
1
2
679340
1
2
679336
2
2
679335
1
2
679331
1
2
679324
1
2
679318
1
2
679316
1
2
679314
1
2
679312
1
2
679310
1
2
679308
1
2
679306
1
2
679302
1
2
679295
1
2
679292
1
2
679280
2
2
679277
1
2
679276
1
2
679275
1
2
679274
1
2
679271
1
2
679265
1
2
679263
1
2
679256
1
2
679252
1
2
679248
1
2
679246
1
2
679243
1
2
679241
1
2
679240
1
2
679236
1
2
679234
1
2
679215
1
2
679207
1
2
679187
1
2
679184
1
2
679181
1
2
679179
1
2
679177
1
2
679174
1
2
679169
1
2
679162
1
2
679160
1
2
679157
1
2
679156
1
2
679155
1
2
679154
1
2
679152
3
2
679149
2
2
679142
1
2
679134
1
2
679132
1
2
679130
1
2
679118
1
2
679115
1
2
679111
1
2
679110
1
2
679106
1
2
679103
1
2
679102
1
2
679100
1
2
1274 rows, truncated to displaylimit of 1000
Content source: california-civic-data-coalition/python-calaccess-notebooks
Similar notebooks: