Name: raw_counterparty_contact
Creator: Forest Gregg
License: https://creativecommons.org/publicdomain/mark/1.0/

1,510 rows

descending

✎ View and edit SQL

Link	rptId	activity_id	city	name	po_box,_bldg,_room_no,_if_any	state	street	zip_code_+_4
1	721322	0
2	723454	0
3	723454	1
4	723454	2	Bellevue	. . Frank Doolittle Company		WA	11811 NE 1st Street, Suite A-209	98005
5	723454	3
6	723454	4
7	723454	5
8	723454	6
9	723454	7
10	723454	8
11	723454	9
12	723454	10
13	723454	11
14	723454	12
15	723454	13
16	725226	0	Raytown	Shirley Welsh	PO Box 18289	MO		64133
17	726093	0
18	726093	1
19	726093	2
20	726093	3
21	728027	0
22	728027	1
23	728027	2
24	728027	3
25	728027	4
26	728027	5
27	728027	6
28	728027	7
29	728027	8
30	728027	9
31	728027	10
32	729412	0
33	729412	1	Washington	Kristopher Anderson		DC	900 Seventh Street NW	20001
34	729412	2	Front Royal	Michael S. Baldwin		VA	917 Shenandoah Shores Road	22630
35	729412	3	Pittsburgh	Gregory Bernarding		PA	2201 Liberty Avenue	17222 - 4501
36	729412	4	Washington	William T. Bohne		DC	900 Seventh Street NW	20001
37	729412	5	Front Royal	Jerry C. Boles		VA	917 Shenandoah Shores Road	22630
38	729412	6	Pittsburgh	Jody Bonfini		PA	650 Ridge Road	15205
39	729412	7	Rockville	Stanley Boyd		MD	3 Research Place	20850
40	729412	8	Pittsburgh	Kenn Bradley		PA	986 Greentree Road	15220
41	729412	9	Front Royal	Johnathan D. Bragg		VA	917 Shenandoah Shores Road	22630
42	729412	10	North Olmsted	Jeffrey J. Brandow	Suite 340	OH	24950 Country Club Boulevard	44070 - 5333
43	729412	11	Pittsburgh	Kenneth J. Broadbent		PA	1517 Woodruff Street	15220 - 5317
44	729412	12	Cleveland	Rory R. Broyles		OH	4239 West 150th Street	44135
45	729412	13	Erie	Ron Celeski		PA	1414 Harscrabble Boulevard	16505
46	729412	14	Front Royal	Corey L. Claypool		VA	917 Shenandoah Shores Road	22630
47	729412	15	Rockville	Ellen Conboy		MD	3 Research Place	20850
48	729412	16	Youngwood	William Cononie	PO Box 325	PA	217 Ambrust Road	15697
49	729412	17	Canonsburg	Denny E. Cregut	Suite 2	PA	210 West Pike Street	15317 - 1177
50	729412	18	Youngwood	Timothy Custer	PO Box 325	PA	217 Ambrust Street	15697
51	729412	19	Pittsburgh	David D. Daquelente	Foster Plaza #9 Suite 615	PA	750 Holiday Drive	15220
52	729412	20	Pittsburgh	Rocco DiFilippo	PO Box 40128	PA	4701 Butler Street	15201
53	729412	21	North Olmsted	Matthew E. Dolin	Suite 340	OH	24950 Country Club Boulevard	44070 - 5333
54	729412	22	Cleveland	Larry Ed Dowell		OH	4329 West 150th Street	44135
55	729412	23	Uniontown	Vito Dragone, Jr.		PA	334 Park Street	15401
56	729412	24	Front Royal	Brandon E. Elvey		VA	917 Shenandoah Shores Road	22630
57	729412	25	North Olmsted	John R. England	Suite 340	OH	24950 Country Club Boulevard	44070 - 5333
58	729412	26	n/a	n/a n/a	n/a	00	n/a	17089
59	729412	27	Front Royal	James M. Finnegan		VA	917 Shenandoah Shores Road	22630
60	729412	28	Washington	Charles Fraley		DC	1750 New York Avenue NW	20006
61	729412	29	Pittsburgh	Keith Frank	PO Box 40128	PA	4701 Butler Street	15201 - 0128
62	729412	30	Pittsburgh	Charles M. Gaston	Rivertech Center, Suite 160	PA	3700 South Water Street	15203
63	729412	31	Pittsburgh	Robert Grawsick		PA	650 Ridge Road	15205
64	729412	32
65	729412	33
66	729412	34
67	729412	35	Pittsburgh	William Greer		PA	100 Kingston Drive	15235
68	729412	36	Pittsburgh	James A. Harding		PA	1517 Woodruff Street	15220 - 5317
69	729412	37
70	729412	38
71	729412	39
72	729412	40
73	729412	41	Rockville	Richard A. Johnson		MD	3 Research Place	20850
74	729412	42	Pittsburgh	Nick Kappas		PA	1517 Woodruff Street	15220 - 5317
75	729412	43	Pittsburgh	Richard G. King		PA	1517 Woodruff Street	15220 - 5317
76	729412	44	Pittsburgh	Joseph C. Kristian		PA	986 Greentree Road	15220
77	729412	45	Pittsburgh	Joseph M. Little		PA	1517 Woodruff Street	15220
78	729412	46	Canonsburg	Mark T. Mace		PA	210 West Pike Street	15317 - 1177
79	729412	47	Pittsburgh	John Mains		PA	100 Kingston Drive	15235
80	729412	48	Pittsburgh	Lee Manges		PA	650 Ridge Road	15205
81	729412	49	Kansas City	John Mansker		KS	753 State Avenue	66101
82	729412	50	Rockville	Arthur Maratea		MD	3 Research Place	20850
83	729412	51	Washington	Martin Marinack	United Union Building	DC	1750 New York Avenue NW	20006
84	729412	52	Plymouth Meeting	Ethel Marks		PA	3031-B Walton Rd	19462
85	729412	53	Front Royal	Joe L. Mattingly		VA	917 Shenandoah Shores Road	22630
86	729412	54	Pittsburgh	Robert J. McAuliffe		PA	60 Boulevard of the Allies	15222
87	729412	55	Cleveland	Francis Leo McCann		OH	4239 West 150th Street	44135
88	729412	56	Coraopolis	Joseph W. McGee		PA	1040 Montour W Industrial Park	15108 - 9407
89	729412	57	Pittsburgh	Thomas Melcher	Suite 400	PA	5 Hot Metal Street	15203 - 2351
90	729412	58	Washington	James E. Meyer		DC	900 Seventh Street, N.W.	20001
91	729412	59	Youngwood	Chad Morrison	PO Box 325	PA	217 Ambrust Street	15697
92	729412	60	New Castle	Mark Mrozek	Suite A	PA	351 Northgate Circle	16105
93	729412	61	Pittsburgh	Marty J. Noone		PA	1517 Woodruff Street	15220 - 5317
94	729412	62	Coraopolis	Martin O'Toole		PA	1040 Montour W Industrial Park	15108 - 9407
95	729412	63	Rockville	Allison Parker-Dillon		MD	3 Research Place	20850
96	729412	64
97	729412	65
98	729412	66
99	729412	67	North Olmsted	John Previsich	Suite 340	OH	24950 Country Club Boulevard	44070 - 5333
100	729412	68	Pittsburgh	Daniel J. Quinn		PA	1221 Banksville Rd	15216

Download this data

CSV · JSON

Table schema

CREATE TABLE "raw_counterparty_contact"(
"rptId" TEXT, "activity_id" TEXT, "order" TEXT, "city" TEXT,
 "name" TEXT, "po_box,_bldg,_room_no,_if_any" TEXT, "state" TEXT, "street" TEXT,
 "zip_code_+_4" TEXT);