raw_counterparty_organization

148 rows

✎ View and edit SQL

Suggested facets: rptId, po_box,_bldg,_room_no,_if_any, state

rptId activity_id order city organization po_box,_bldg,_room_no,_if_any state street zip_code_+_4
730263 0 0 ROCHESTER LABORERS LOCAL UNION 435 20 NY FOURTH ST 14609
730263 1 0 ROCHESTER LABORERS LOCAL UNION 435 20 NY FOURTH ST 14609
730263 2 0 ROCHESTER LABORERS LOCAL UNION 435 20 NY FOURTH ST 14609
730263 3 0 ROCHESTER LABORERS LOCAL UNION 435 20 NY FOURTH ST 14609
730263 4 0 ROCHESTER LABORERS LOCAL UNION 435 20 NY FOURTH ST 14609
742638 0 0 Broken Arrow LRI Consulting Services, Inc.   OK 7850 South Elm Place, Suite E 74011
756458 0 0 ROCHESTER LABORERS LOCAL UNION 435 20 NY FOURTH ST 14609
809265 0 0 Las Vegas Quest Consulting P.O. Box 31549 NV   89173
824483 0 0 ROCHESTER LABORERS LOCAL 435 20 NY FOURTH STREET 14609
857009 0 0 Macedonia Cleveland Building Restoration   OH 8821 Freeway Dr 44056 - 1506
857044 0 0 Macedonia Cleveland Building Restoration   OH 8821 Freeway Dr 44056 - 1506
857044 1 0 Valley View Bricklayers & Allied Craftworkers Local Union 5 OH   OH 9525 Sweet Valley Drive 44125 - 4237
857044 2 0 Cleveland Cleveland Building & Construction Trades Council Suite 280 OH 3250 Euclid Ave 44115 - 2520
868546 0 0 ROCHESTER LABORERS LOCAL 435 20 NY FOURTH STREET 14609
868546 1 0 OLEAN LABORERS' LOCAL 621 1521 NY NORTH UNION STREET 14760
892912 0 0 Amherst BAC Local 23 OH-WV-KY   OH 8497 Leavitt Road 44001 - 2700
892912 1 0 Cleveland Cleveland Building & Construction Trades Council Suite 280 OH 3250 Euclid Ave 44115 - 2520
893164 0 0 ROCHESTER LABORERS LOCAL 435 20 NY FOURTH STREET 14609
915159 0 0 Opa Locka Florida Pipe Trades Council, Inc   FL 13185 NW 54 Avenue 33054
915159 1 0 Covina Teamsters Local 986 Charity Fund   CA 1430 E. Holt Ave 91724
915159 2 0 Meriden New England States Pipe Trade Assn   CT 1250 East Main Street 06450
915159 3 0 New York Building & Construction Trades Council of Greater   NY 350 W 31st ST Rm 700 10001
915159 4 0 Annandale Northern Virginia Labor Federation PO Box 565 VA   22003 - 0565
915159 5 0 Deer Park Joint Apprentice Committee of Local Union 211   TX 1301 W 13th Street, Suite B 77536
915159 6 0 St. Louis St. Louis Building & Construction Trades Council   MO 2300 Hampton Ave 63139
915159 7 0 Libertyville IBEW Local 150   IL 31290 N US Hwy 45, Unit B 60048
915159 8 0 Oklahoma City Plumbers & Pipefitters Local 344   OK 4335 SW 44th Street 73119
915159 9 0 Springfield Teamsters Joint Council Local 73   NJ 150 Morris Ave, Suite 204 07081
915159 10 0 Egg Harbor Township United Food & Com Workers Local 152   NJ 3120 Fire Road 08234
915159 11 0 Arlington International Union of Elevator Constructors L21   TX 1924 Bard Farm Rd, Suite 101 76006
915159 12 0 Denver Colorado Building and Construction Trades Council   CO 4740 Harlan Street, #220 80212
915159 13 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 14 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 15 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 16 0 Independence Int'l Assn of Sheet Metal, Air, Rail & Transporati   OH 6060 Rockside Wood Boulevard, N. 44131
915159 17 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 18 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 19 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 20 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 21 0 Independence Brotherhood of Locomotive Engineers and Trainmen   OH 7061 East Pleasant Valley Road 44131
915159 22 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 23 0 Cleveland American Train Dispatchers Association   OH 4239 W 150th Street 44135
915159 24 0 Cleveland American Train Dispatchers Association   OH 4239 West 150th Street 44135
915159 25 0 Independence Int'l Assn of Sheet Metal, Air, Rail and Transport   OH 6060 Rockside Woods Boulevard, N. 44131
915159 26 0 Independence Brotherhood of Locomotive Engineers and Trainmen   OH 7061 East Pleasant Valley Road 44131
915159 27 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 28 0 Rockville Transportation Communication Union/IAM   MD 3 Research Place 20850
915159 29 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 30 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 31 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 32 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 33 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915159 34 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 35 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915159 36 0 Cleveland American Train Dispatchers Association   OH 4239 West 150th Street 44135
915175 0 0 Opa Locka Florida Pipe Trades Council, Inc   FL 13185 NW 45th 33055
915175 1 0 Covina Teamsters LU No 986 Charity Fund Inc.   CA 1430 E Holt Avenue 91724
915175 2 0 Nashville UA of Journeymen & Apprentices of Plumbing & Pipe   TN 225 Ben Allen Road 37207
915175 3 0 Lexington Kentucky Pipe Trade Association   KY 701 Allenridge Point 40510
915175 4 0 Great Neck Local 817 IBT Thomas R. O'Donnell Scholarship Fund   NY 817 Old Cuttermill Road 11021 - 2924
915175 5 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915175 6 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915175 7 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915175 8 0 Independence International Association of Sheet Metal, Air, Rai   OH 6060 Rockside Woods Boulevard, N. 44131
915175 9 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 44131
915175 10 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915175 11 0 Independence Brotherhood of Locomotive Engineers and Trainmen   OH 7061 East Pleasant Valley Road 44131
915175 12 0 Cleveland American Train Dispatchers Association   OH 4239 West 150th Street 44135
915175 13 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915175 14 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915175 15 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915175 16 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
915175 17 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915175 18 0 Independence Brotherhood of Locomotive Engineers and Trainmen   OH 917 Shenandoah Shores Road 44131
915175 19 0 Cleveland American Train Dispatchers Association   OH 4239 West 150th Street 44135
915175 20 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
915175 21 0 Austin The Vindex Group Suite 502 TX 7421 Burnet Road 78757
917632 0 0 Amherst BAC Local 23 OH-WV-KY   OH 8497 Leavitt Road 44001 - 2700
917632 1 0 Amherst BAC Local 23 OH-WV-KY   OH 8497 Leavitt Road 44001 - 2700
917633 0 0 Amherst BAC Local 23 OH-WV-KY   OH 8497 Leavitt Road 44001 - 2700
918206 0 0 ROCHESTER LABORERS LOCAL 435 20 NY FOURTH STREET 14609
941995 0 0 Broken Arrow LRI Consulting Services, Inc.   OK P.O. Box 1529 74011
942135 0 0 AMHERST BAC LOCAL 23 OH-KY-WV   OH 8497 LEAVITT ROAD 44001
942136 0 0 AMHERST BAC LOCAL 23 OH-KY-WV   OH 8497 LEAVITT ROAD 44001 - 2700
942136 1 0 AMHERST BAC LOCAL 23 OH-KY-WV   OH 8497 LEAVITT ROAD 44001 - 2700
942136 2 0 Amherst BAC LOCAL 23 OH-KY-WV   OH 8497 Leavitt Road 44001 - 2700
942244 0 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
942244 1 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
942244 2 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
942244 3 0 Independence International Association of Sheet Metal, Air, Rai Suite 325 OH 6060 Rockside Woods Boulevard, N. 44131
942244 4 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
942244 5 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
942244 6 0 Independence Brotherhood of Locomotive Engineers and Trainmen   OH 7061 East Pleasant Valley Road 44131
942244 7 0 Cleveland American Train Dispatchers Association   OH 4239 West 150th Street 44135
942244 8 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
942244 9 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
942244 10 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
942244 11 0 Rockville Transportation Communications Union/IAM   MD 3 Research Place 20850
942244 12 0 Front Royal Brotherhood of Railroad Signalmen   VA 917 Shenandoah Shores Road 22630
942244 13 0 Independence Brotherhood of Locomotive Engineers and Trainmen   OH 7061 East Pleasant Valley Road 44131

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE raw_counterparty_organization(rptId BIGINT, activity_id BIGINT, "order" BIGINT, city VARCHAR, organization VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, "zip_code_+_4" VARCHAR);