search

rkiddy / open_calaccess_data_perl

Information about the data made available by the California Secretary of State about campaign finances and lobbying in the state. Not the data itself, just info about it.
0 stars 0 forks source link

S497 entry missing an amount, causes exception in pdfgen #7

Open rkiddy opened 10 years ago

rkiddy commented 10 years ago

This throws an exception:

http://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=598118&amendid=0

And this is what the data file shows:

$ ./scripts/dumpRows -interval 2264 2264 S497_CD.TSV upper: 2264, lower: 2264

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "598118" AMEND_ID: "0" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "2969" ENTITY_CD: "" ENTY_NAML: "" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "" ENTY_ST: "" ENTY_ZIP4: "" CTRIB_EMP: "1000" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "2/25/2000 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "743794" CAND_NAML: "" CAND_NAMF: "" CAND_NAMT: "" CAND_NAMS: "" OFFICE_CD: "" OFFIC_DSCR: "" JURIS_CD: "" JURIS_DSCR: "" DIST_NO: "" OFF_S_H_CD: "" BAL_NAME: "" BAL_NUM: "" BAL_JURIS: "" MEMO_CODE: "" MEMO_REFNO: "" BAL_ID: "" CAND_ID: "" SUP_OFF_CD: "" SUP_OPP_CD: ""

rkiddy commented 10 years ago

Also these. The values below the ones shown are blank.

upper: 2264, lower: 2264

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "598118" AMEND_ID: "0" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "2969" ENTITY_CD: "" ENTY_NAML: "" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "" ENTY_ST: "" ENTY_ZIP4: "" CTRIB_EMP: "1000" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "2/25/2000 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "743794"

upper: 2599, lower: 2599

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "595589" AMEND_ID: "0" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "1521" ENTITY_CD: "" ENTY_NAML: "GOLDMAN" ENTY_NAMF: "TYLER J" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "NEWPORT BEACH" ENTY_ST: "CA" ENTY_ZIP4: "92663" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "2/22/2000 12:00:00 AM"

upper: 4593, lower: 4593

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "602650" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "5449" ENTITY_CD: "OTH"

upper: 6640, lower: 6640

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "609732" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "6015" ENTITY_CD: "COM"

upper: 50641, lower: 50641

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "865731" AMEND_ID: "0" LINE_ITEM: "6" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "CI51" ENTITY_CD: "" ENTY_NAML: "" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "" ENTY_ST: "" ENTY_ZIP4: "" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "11/5/2002 12:00:00 AM"

upper: 59476, lower: 59476

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "875265" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "735496" ENTITY_CD: "0"

upper: 63983, lower: 63983

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "883285" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "CI67" ENTITY_CD: "" ENTY_NAML: "" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "" ENTY_ST: "" ENTY_ZIP4: "" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "" DATE_THRU: "" AMOUNT: "" CMTE_ID: "" CAND_NAML: "INADVERTENTLY REPORTED AS AN INDEPENDENT EXPENDITURE ON 10/23/2002"

upper: 63985, lower: 63985

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "883292" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "CI66" ENTITY_CD: "" ENTY_NAML: "" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "" ENTY_ST: "" ENTY_ZIP4: "" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "" DATE_THRU: "" AMOUNT: "" CMTE_ID: "" CAND_NAML: "INADVERTENTLY REPORTED AS AN INDEPENDENT EXPENDIUTRE ON 10/23/2002"

upper: 66963, lower: 66963

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "883334" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "CI2298" ENTITY_CD: "" ENTY_NAML: "" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "" ENTY_ST: "" ENTY_ZIP4: "" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "" DATE_THRU: "" AMOUNT: "" CMTE_ID: "" CAND_NAML: "INADVERTENTLY REPORTED AS AN INDEPENDENT EXPENDITURE ON 10/23/2002"

upper: 67505, lower: 67505

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "886576" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "CI2298"

upper: 69216, lower: 69216

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "888826" AMEND_ID: "0" LINE_ITEM: "7" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "202564" ENTITY_CD: "IND" ENTY_NAML: "Shen" ENTY_NAMF: "George" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Monterey Park" ENTY_ST: "Ca" ENTY_ZIP4: "91754" CTRIB_EMP: "I"

upper: 70130, lower: 70130

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "888826" AMEND_ID: "0" LINE_ITEM: "11" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "927342" ENTITY_CD: "IND" ENTY_NAML: "Shen" ENTY_NAMF: "George" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Monte"

upper: 94570, lower: 94570

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "997711" AMEND_ID: "0" LINE_ITEM: "3" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "CI232" ENTITY_CD: "" ENTY_NAML: "In-Kind Contribution to Linda Soubirous on 2/18/2004 for $3124.00 was orginally reported on 2/19/2004 as an Independent Expenditure"

upper: 115611, lower: 115611

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1052229" AMEND_ID: "0" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "414876" ENTITY_CD: "0"

upper: 115855, lower: 115855

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1053019" AMEND_ID: "0" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "547242" ENTITY_CD: "0" ENTY_NAML: "Handy" ENTY_NAMF: "Robert" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Santa Barbara" ENTY_ST: "CA" ENTY_ZIP4: "93108" CTRIB_EMP: "Retired" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "10/18/2004 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "" CAND_NAML: "Masry" CAND_NAMF: "Ferial" CAND_NAMT: "" CAND_NAMS: "" OFFICE_CD: "ASM" OFFIC_DSCR: "" JURIS_CD: "ASM" JURIS_DSCR: "" DIST_NO: "037" OFF_S_H_CD: "s"

upper: 161473, lower: 161473

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1172167" AMEND_ID: "0" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "F497P1-1997"

upper: 229987, lower: 229987

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1325453" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "C56" ENTITY_CD: "" ENTY_NAML: "Please reference Form 497 filed for contributions received 4-14-08"

upper: 251824, lower: 251824

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1338006" AMEND_ID: "0" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "580636" ENTITY_CD: "0"

upper: 350343, lower: 350343

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1493927" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP5683" ENTITY_CD: "COM" ENTY_NAML: "California Real Estate Independent Expenditure Committee (CREIEC)" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Sacramento" ENTY_ST: "CA" ENTY_ZIP4: "95814" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "6/2/2010 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "963026" CAND_NAML: "California Real Estate Independent Expenditure Committee (CREIEC)"

upper: 350344, lower: 350344

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP5682" ENTITY_CD: "COM" ENTY_NAML: "California Real Estate Independent Expenditure Committee (CREIEC)" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Sacramento" ENTY_ST: "CA" ENTY_ZIP4: "95814" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "5/27/2010 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "963026" CAND_NAML: "California Real Estate Independent Expenditure Committee (CREIEC)"

upper: 350345, lower: 350345

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC3054" ENTITY_CD: "OTH" ENTY_NAML: "RE/MAX United" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "San Diego" ENTY_ST: "CA" ENTY_ZIP4: "92131" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "2/12/2010 12:00:00 AM"

upper: 350346, lower: 350346

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "3" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC3095" ENTITY_CD: "OTH" ENTY_NAML: "RE/MAX United" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "San Diego" ENTY_ST: "CA" ENTY_ZIP4: "92131" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "2/12/2010 12:00:00 AM"

upper: 350347, lower: 350347

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "4" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC3101" ENTITY_CD: "OTH" ENTY_NAML: "RE/MAX United" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "San Diego" ENTY_ST: "CA" ENTY_ZIP4: "92131" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "2/12/2010 12:00:00 AM"

upper: 350348, lower: 350348

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "5" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC5615" ENTITY_CD: "OTH" ENTY_NAML: "Keller Williams SD Metro" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "San Diego" ENTY_ST: "CA" ENTY_ZIP4: "92103" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "5/4/2010 12:00:00 AM"

upper: 350349, lower: 350349

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "6" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC5617" ENTITY_CD: "OTH" ENTY_NAML: "Keller Williams SD Metro" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "San Diego" ENTY_ST: "CA" ENTY_ZIP4: "92103" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "5/4/2010 12:00:00 AM"

upper: 350350, lower: 350350

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "7" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC5620" ENTITY_CD: "OTH" ENTY_NAML: "Keller Williams SD Metro" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "San Diego" ENTY_ST: "CA" ENTY_ZIP4: "92103" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "5/4/2010 12:00:00 AM"

upper: 350351, lower: 350351

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1492613" AMEND_ID: "1" LINE_ITEM: "8" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC5625" ENTITY_CD: "OTH" ENTY_NAML: "RE/MAX United" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "San Diego" ENTY_ST: "CA" ENTY_ZIP4: "92131" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "5/4/2010 12:00:00 AM"

upper: 351298, lower: 351298

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1489395" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP4482" ENTITY_CD: "COM" ENTY_NAML: "Alejo for Assembly 2010" ENTY_NAMF: "Luis" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Watsonville" ENTY_ST: "CA" ENTY_ZIP4: "95076" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "5/24/2010 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "1318679" CAND_NAML: "Luis Alejo" CAND_NAMF: "" CAND_NAMT: "" CAND_NAMS: "" OFFICE_CD: "ASM" OFFIC_DSCR: "" JURIS_CD: "ASM" JURIS_DSCR: "" DIST_NO: "28"

upper: 351302, lower: 351302

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1489392" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP4483" ENTITY_CD: "COM" ENTY_NAML: "Caballero for Senate 2010" ENTY_NAMF: "Anna" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Sacramento" ENTY_ST: "CA" ENTY_ZIP4: "95865" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "5/24/2010 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "1317482" CAND_NAML: "Anna Caballero" CAND_NAMF: "" CAND_NAMT: "" CAND_NAMS: "" OFFICE_CD: "SEN" OFFIC_DSCR: "" JURIS_CD: "SEN" JURIS_DSCR: "" DIST_NO: "12"

upper: 354242, lower: 354242

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1493220" AMEND_ID: "2" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC733" ENTITY_CD: "COM" ENTY_NAML: "California Assoc of Highway Patrolmen" ENTY_NAMF: "" ENTY_NAMT: "" ENTY_NAMS: "" ENTY_CITY: "Sacramento" ENTY_ST: "CA" ENTY_ZIP4: "95818" CTRIB_EMP: "" CTRIB_OCC: "" CTRIB_SELF: "" ELEC_DATE: "" CTRIB_DATE: "6/1/2010 12:00:00 AM" DATE_THRU: "" AMOUNT: "" CMTE_ID: "802001"

upper: 354738, lower: 354738

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1491553" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP586" ENTITY_CD: "COM"

upper: 354739, lower: 354739

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1491553" AMEND_ID: "1" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP585" ENTITY_CD: "COM"

upper: 369945, lower: 369945

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1512809" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP917" ENTITY_CD: "COM"

upper: 369962, lower: 369962

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1519002" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "NON133" ENTITY_CD: "COM"

upper: 369963, lower: 369963

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1519003" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "NON64" ENTITY_CD: "COM"

upper: 376924, lower: 376924

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1520065" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC56"

upper: 378318, lower: 378318

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1520210" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "IDT2"

upper: 382626, lower: 382626

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1529449" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC93"

upper: 394999, lower: 394999

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1573894" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP2879"

upper: 401845, lower: 401845

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1536058" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC174"

upper: 404551, lower: 404551

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1619997" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP180"

upper: 405479, lower: 405479

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1627101" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP746"

upper: 411465, lower: 411465

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1652365" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC94"

upper: 418557, lower: 418557

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1667299" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC769"

upper: 421459, lower: 421459

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1667414" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "C89"

upper: 422039, lower: 422039

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1665496" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "NON216"

upper: 423828, lower: 423828

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1663346" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP107" ENTITY_CD: "COM"

upper: 423829, lower: 423829

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1664657" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP103" ENTITY_CD: "COM"

upper: 423830, lower: 423830

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1664657" AMEND_ID: "1" LINE_ITEM: "2" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP104" ENTITY_CD: "COM"

upper: 423831, lower: 423831

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1664657" AMEND_ID: "1" LINE_ITEM: "3" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP105" ENTITY_CD: "COM"

upper: 424194, lower: 424194

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1660754" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP721"

upper: 425015, lower: 425015

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1667745" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC962"

upper: 443191, lower: 443191

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1696450" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "PDT821" ENTITY_CD: "COM"

upper: 445247, lower: 445247

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1693005" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP4449"

upper: 447772, lower: 447772

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1693015" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P1" TRAN_ID: "INC386"

upper: 449834, lower: 449834

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1712189" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP99066"

upper: 452369, lower: 452369

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1749845" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP4052"

upper: 452955, lower: 452955

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1706927" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "e12"

upper: 454628, lower: 454628

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1705591" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "PDT864"

upper: 459972, lower: 459972

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1755276" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP1566" ENTITY_CD: "COM"

upper: 461720, lower: 461720

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1768369" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP940" ENTITY_CD: "COM"

upper: 464082, lower: 464082

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1774700" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP21"

upper: 464100, lower: 464100

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1774699" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP1817"

upper: 465038, lower: 465038

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1760891" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP1576"

upper: 465918, lower: 465918

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1757738" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP1144" ENTITY_CD: "COM"

upper: 466172, lower: 466172

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1775191" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP557" ENTITY_CD: "COM"

upper: 466953, lower: 466953

/Users/ray/Projects/OpenCalAccessData/S497_CD.TSV:

FILING_ID: "1792404" AMEND_ID: "1" LINE_ITEM: "1" REC_TYPE: "S497" FORM_TYPE: "F497P2" TRAN_ID: "EXP17751"