search

PublicI / fec-loader

Loads raw FEC filings into a database
MIT License
21 stars 9 forks source link

Date/Time field value out of range #41

Closed cimar closed 6 years ago

cimar commented 6 years ago

error inserting 996567: { SequelizeDatabaseError: date/time field value out of range: "2 1028" at Query.formatError (/Users/rosie/Documents/fec-model/node_modules/sequelize/lib/dialects/postgres/query.js:357:14) at Query. (/Users/rosie/Documents/fec-model/node_modules/sequelize/lib/dialects/postgres/query.js:88:19) at Query.emit (events.js:180:13) at Query.handleError (/Users/rosie/Documents/fec-model/node_modules/pg/lib/query.js:125:8) at Connection. (/Users/rosie/Documents/fec-model/node_modules/pg/lib/client.js:171:26) at Connection.emit (events.js:180:13) at Socket. (/Users/rosie/Documents/fec-model/node_modules/pg/lib/connection.js:109:12) at Socket.emit (events.js:180:13) at addChunk (_stream_readable.js:269:12) at readableAddChunk (_stream_readable.js:256:11) at Socket.Readable.push (_stream_readable.js:213:10) at TCP.onread (net.js:578:20) name: 'SequelizeDatabaseError', message: 'date/time field value out of range: "2 1028"', parent: { error: date/time field value out of range: "2 1028" at Connection.parseE (/Users/rosie/Documents/fec-model/node_modules/pg/lib/connection.js:539:11) at Connection.parseMessage (/Users/rosie/Documents/fec-model/node_modules/pg/lib/connection.js:366:17) at Socket. (/Users/rosie/Documents/fec-model/node_modules/pg/lib/connection.js:105:22) at Socket.emit (events.js:180:13) at addChunk (_stream_readable.js:269:12) at readableAddChunk (_stream_readable.js:256:11) at Socket.Readable.push (_stream_readable.js:213:10) at TCP.onread (net.js:578:20) name: 'error', length: 170, severity: 'ERROR', code: '22008', detail: undefined, hint: 'Perhaps you need a different "datestyle" setting.', position: '10361', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'datetime.c', line: '3887', routine: 'DateTimeParseError', sql: 'INSERT INTO "fec_paper_contributions" ("id","filing_id","form_type","filer_committee_id_number","contributor_organization_name","contributor_last_name","contributor_first_name","contributor_middle_name","contributor_prefix","contributor_suffix","contributor_street_1","contributor_street_2","contributor_city","contributor_state","contributor_zip_code","election_code","election_other_description","contribution_date","contribution_amount","contribution_aggregate","contributor_employer","contributor_occupation","donor_committee_fec_id","memo_text_description","image_number") VALUES (DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUATE\',\'RHODA\',NULL,NULL,NULL,\'3170 CHICAGO ST\',NULL,\'SAN DIEGO\',\'CA\',\'921176114\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 35.00\',\' 453.00\',\'AONIX\',\'SOFTWARE ENGINEER\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311367\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 35.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311367\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUATTROCCHI\',\'ADA\',NULL,NULL,NULL,\'7200 CONNECTICUT AVE\',NULL,\'CHEVY CHASE\',\'MD\',\'208154932\',NULL,NULL,\'2014-10-19 04:00:00.000 +00:00\',\' 50.00\',\' 310.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311368\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-20 04:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311368\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUATTROCCHI\',\'ADA\',NULL,NULL,NULL,\'7200 CONNECTICUT AVE\',NULL,\'CHEVY CHASE\',\'MD\',\'208154932\',NULL,NULL,\'2014-10-25 04:00:00.000 +00:00\',\' 50.00\',\' 310.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311368\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-27 04:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311369\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUATTROCCHI\',\'ADA\',NULL,NULL,NULL,\'7200 CONNECTICUT AVE\',NULL,\'CHEVY CHASE\',\'MD\',\'208154932\',NULL,NULL,\'2014-11-01 04:00:00.000 +00:00\',\' 50.00\',\' 310.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311369\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311369\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUATTROCCHI\',\'VINCENT\',NULL,NULL,NULL,\'610 OHIO AVE\',NULL,\'LONG BEACH\',\'CA\',\'908141231\',NULL,NULL,\'2014-10-20 04:00:00.000 +00:00\',\' 50.00\',\' 260.00\',\'SELF\',\'REAL ESTATE\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311370\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-22 04:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311370\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUBAIN\',\'BASHAR\',NULL,NULL,NULL,\'680 FOREST RD\',NULL,\'WAYNE\',\'PA\',\'190872324\',NULL,NULL,\'2014-11-01 04:00:00.000 +00:00\',\' 80.00\',\' 230.00\',\'GEOSTRUCTURES, INC.\',\'GEOTECHNICAL ENGINEER\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311370\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 80.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311371\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUIGLEY\',\'MARTHA\',\'QUIGLEY\',NULL,NULL,\'342 CORNELL AVE\',NULL,\'HAZARD\',\'KY\',\'41701\',NULL,NULL,\'2014-10-21 04:00:00.000 +00:00\',\' 15.00\',\' 210.00\',\'CITY OF HAZARD\',\'MUSEUM DIRECTOR\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311371\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-22 04:00:00.000 +00:00\',\' 15.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311371\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUIGLEY\',\'MARTHA\',\'QUIGLEY\',NULL,NULL,\'342 CORNELL AVE\',NULL,\'HAZARD\',\'KY\',\'41701\',NULL,NULL,\'2014-10-27 04:00:00.000 +00:00\',\' 20.00\',\' 210.00\',\'CITY OF HAZARD\',\'MUSEUM DIRECTOR\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311372\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 20.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311372\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUIGLEY\',\'MARTHA\',\'QUIGLEY\',NULL,NULL,\'342 CORNELL AVE\',NULL,\'HAZARD\',\'KY\',\'41701\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 15.00\',\' 210.00\',\'CITY OF HAZARD\',\'MUSEUM DIRECTOR\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311372\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-29 04:00:00.000 +00:00\',\' 15.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311373\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUIGLEY\',\'MARTHA\',\'QUIGLEY\',NULL,NULL,\'342 CORNELL AVE\',NULL,\'HAZARD\',\'KY\',\'41701\',NULL,NULL,\'2014-10-31 04:00:00.000 +00:00\',\' 15.00\',\' 210.00\',\'CITY OF HAZARD\',\'MUSEUM DIRECTOR\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311373\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-31 04:00:00.000 +00:00\',\' 15.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311373\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUIGLEY\',\'MARTHA\',\'QUIGLEY\',NULL,NULL,\'342 CORNELL AVE\',NULL,\'HAZARD\',\'KY\',\'41701\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 15.00\',\' 210.00\',\'CITY OF HAZARD\',\'MUSEUM DIRECTOR\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311374\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-05 05:00:00.000 +00:00\',\' 15.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311374\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUIGLEY\',\'MARTHA\',\'QUIGLEY\',NULL,NULL,\'342 CORNELL AVE\',NULL,\'HAZARD\',\'KY\',\'41701\',NULL,NULL,\'2014-11-21 05:00:00.000 +00:00\',\' 15.00\',\' 210.00\',\'CITY OF HAZARD\',\'MUSEUM DIRECTOR\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311374\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-24 05:00:00.000 +00:00\',\' 15.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311375\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUILL\',\'CYNTHIA\',NULL,NULL,NULL,\'563 W GENESEE STREET RD\',NULL,\'CAYUGA\',\'NY\',\'130343179\',NULL,NULL,\'2014-10-17 04:00:00.000 +00:00\',\' 80.00\',\' 230.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311375\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-20 04:00:00.000 +00:00\',\' 80.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311375\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'BARBARA\',NULL,NULL,NULL,\'16276 OAKFORD TRL\',NULL,\'FISHERS\',\'IN\',\'460377389\',NULL,NULL,\'2014-11-11 05:00:00.000 +00:00\',\' 8.00\',\' 208.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311376\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-12 05:00:00.000 +00:00\',\' 8.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311376\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'CATHERINE\',NULL,NULL,NULL,\'N3W31717 TWIN OAKS DR\',NULL,\'DELAFIELD\',\'WI\',\'530182859\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 15.00\',\' 285.00\',\'SELF\',\'ART THERAPIST\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311376\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-29 04:00:00.000 +00:00\',\' 15.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311377\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'CATHERINE\',NULL,NULL,NULL,\'N3W31717 TWIN OAKS DR\',NULL,\'DELAFIELD\',\'WI\',\'530182859\',NULL,NULL,\'2 1028\',\' 25.00\',\' 285.00\',\'SELF\',\'ART THERAPIST\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311377\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-29 04:00:00.000 +00:00\',\' 25.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311377\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'CATHERINE\',NULL,NULL,NULL,\'N3W31717 TWIN OAKS DR\',NULL,\'DELAFIELD\',\'WI\',\'530182859\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 5.00\',\' 285.00\',\'SELF\',\'ART THERAPIST\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311378\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-05 05:00:00.000 +00:00\',\' 5.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311378\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'CATHERINE\',NULL,NULL,NULL,\'N3W31717 TWIN OAKS DR\',NULL,\'DELAFIELD\',\'WI\',\'530182859\',NULL,NULL,\'2014-11-13 05:00:00.000 +00:00\',\' 25.00\',\' 285.00\',\'SELF\',\'ART THERAPIST\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311378\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-14 05:00:00.000 +00:00\',\' 25.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311379\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'FRANK\',NULL,NULL,NULL,\'215 ZELLS MILL RD\',NULL,\'NEWPORT\',\'VA\',\'241284126\',NULL,NULL,\'2014-10-22 04:00:00.000 +00:00\',\' 100.00\',\' 250.00\',\'VIRGINIA TECH\',\'PROFESSOR\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311379\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-24 04:00:00.000 +00:00\',\' 100.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311379\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'JOSEPH\',NULL,NULL,NULL,\'1029 N JACKSON ST\',NULL,\'MILWAUKEE\',\'WI\',\'53202\',NULL,NULL,\'2014-10-21 04:00:00.000 +00:00\',\' 10.00\',\' 275.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311380\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-22 04:00:00.000 +00:00\',\' 10.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311380\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'JOSEPH\',NULL,NULL,NULL,\'1029 N JACKSON ST\',NULL,\'MILWAUKEE\',\'WI\',\'53202\',NULL,NULL,\'2014-10-24 04:00:00.000 +00:00\',\' 35.00\',\' 275.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311380\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-27 04:00:00.000 +00:00\',\' 35.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311381\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'JOSEPH\',NULL,NULL,NULL,\'1029 N JACKSON ST\',NULL,\'MILWAUKEE\',\'WI\',\'53202\',NULL,NULL,\'2014-10-27 04:00:00.000 +00:00\',\' 50.00\',\' 275.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311381\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311381\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'JOSEPH\',NULL,NULL,NULL,\'1029 N JACKSON ST\',NULL,\'MILWAUKEE\',\'WI\',\'53202\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 10.00\',\' 275.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311382\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-29 04:00:00.000 +00:00\',\' 10.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311382\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'JOSEPH\',NULL,NULL,NULL,\'1029 N JACKSON ST\',NULL,\'MILWAUKEE\',\'WI\',\'53202\',NULL,NULL,\'2014-10-31 04:00:00.000 +00:00\',\' 35.00\',\' 275.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311382\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-31 04:00:00.000 +00:00\',\' 35.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311383\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'JOSEPH\',NULL,NULL,NULL,\'1029 N JACKSON ST\',NULL,\'MILWAUKEE\',\'WI\',\'53202\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 10.00\',\' 275.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311383\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-05 05:00:00.000 +00:00\',\' 10.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311383\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'MARK\',NULL,NULL,NULL,\'1819 ADAMS ST\',NULL,\'MADISON\',\'WI\',\'53711\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 50.00\',\' 535.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311384\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-29 04:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311384\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'MARK\',NULL,NULL,NULL,\'1819 ADAMS ST\',NULL,\'MADISON\',\'WI\',\'53711\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 50.00\',\' 535.00\',\'NONE\',\'RETIRED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311384\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311385\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINN\',\'WILLIAM\',\'D\',NULL,NULL,\'8305 FOUNTAIN RIDGE DR\',NULL,\'PLANO\',\'TX\',\'750253933\',NULL,NULL,\'2014-11-01 04:00:00.000 +00:00\',\' 50.00\',\' 835.00\',\'P3 GROUP\',\'ELECTRICAL ENGINEER\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311385\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 50.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311385\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINONES\',\'RICK\',NULL,NULL,NULL,\'136 SOUTH ST\',NULL,\'FREEHOLD\',\'NJ\',\'077282040\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 10.00\',\' 204.00\',\'KOMPASS NORTH AMERICA\',\'CONSULTANT\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311386\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 10.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311386\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINONES\',\'RICK\',NULL,NULL,NULL,\'136 SOUTH ST\',NULL,\'FREEHOLD\',\'NJ\',\'077282040\',NULL,NULL,\'2014-11-09 05:00:00.000 +00:00\',\' 15.00\',\' 204.00\',\'KOMPASS NORTH AMERICA\',\'CONSULTANT\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311386\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-10 05:00:00.000 +00:00\',\' 15.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311387\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'BURR\',\'LINDA\',\'QUINTON\',NULL,NULL,\'3006 INDIAN HILLS DR\',NULL,\'PROVO\',\'UT\',\'84604\',NULL,NULL,\'2014-10-21 04:00:00.000 +00:00\',\' 200.00\',\' 665.00\',\'SELF\',\'ATTORNEY\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311387\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-22 04:00:00.000 +00:00\',\' 200.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311387\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'BURR\',\'LINDA\',\'QUINTON\',NULL,NULL,\'3006 INDIAN HILLS DR\',NULL,\'PROVO\',\'UT\',\'84604\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 100.00\',\' 665.00\',\'SELF\',\'ATTORNEY\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311388\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-29 04:00:00.000 +00:00\',\' 100.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311388\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'BURR\',\'LINDA\',\'QUINTON\',NULL,NULL,\'3006 INDIAN HILLS DR\',NULL,\'PROVO\',\'UT\',\'84604\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 100.00\',\' 665.00\',\'SELF\',\'ATTORNEY\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311388\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-05 05:00:00.000 +00:00\',\' 100.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311389\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINTON\',\'ELTON\',NULL,NULL,NULL,\'3079 E MARTINSBURG FIRE RD\',NULL,\'PALMYRA\',\'IN\',\'471646925\',NULL,NULL,\'2014-10-23 04:00:00.000 +00:00\',\' 5.00\',\' 342.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311389\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-24 04:00:00.000 +00:00\',\' 5.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311389\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINTON\',\'ELTON\',NULL,NULL,NULL,\'3079 E MARTINSBURG FIRE RD\',NULL,\'PALMYRA\',\'IN\',\'471646925\',NULL,NULL,\'2014-10-25 04:00:00.000 +00:00\',\' 5.00\',\' 342.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311390\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-27 04:00:00.000 +00:00\',\' 5.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311390\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINTON\',\'ELTON\',NULL,NULL,NULL,\'3079 E MARTINSBURG FIRE RD\',NULL,\'PALMYRA\',\'IN\',\'471646925\',NULL,NULL,\'2014-10-27 04:00:00.000 +00:00\',\' 5.00\',\' 342.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311390\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-10-28 04:00:00.000 +00:00\',\' 5.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311391\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINTON\',\'ELTON\',NULL,NULL,NULL,\'3079 E MARTINSBURG FIRE RD\',NULL,\'PALMYRA\',\'IN\',\'471646925\',NULL,NULL,\'2014-11-01 04:00:00.000 +00:00\',\' 5.00\',\' 342.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311391\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 5.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311391\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',NULL,\'QUINTON\',\'ELTON\',NULL,NULL,NULL,\'3079 E MARTINSBURG FIRE RD\',NULL,\'PALMYRA\',\'IN\',\'471646925\',NULL,NULL,\'2014-11-03 05:00:00.000 +00:00\',\' 5.00\',\' 342.00\',\'NONE\',\'NOT EMPLOYED\',NULL,\' EARMARKED CONTRIBUTION: SEE BELOW\',\'14021311392\'),(DEFAULT,\'996567\',\'SA11A1\',\'C00042366\',\'ACTBLUE PAC\',NULL,NULL,NULL,NULL,NULL,\'PO BOX 441146\',NULL,\'WEST SOMERVILLE\',\'MA\',\'021440031\',NULL,NULL,\'2014-11-04 05:00:00.000 +00:00\',\' 5.00\',\' 5446563.87\',NULL,\'CONDUIT TOTAL LISTED IN AGG. FIELD\',\'C00401224\',\'[MEMO ITEM] NOTE: ABOVE CONTRIBUTION EARMARKED THROUGH THIS ORGANIZATION\',\'14021311392\');' }

chriszs commented 6 years ago

closed as duplicate of #29