📥 Export to Excel (CSV) ⚙ Advanced filters

address

734 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: countryId, defaultFlag, residentialFlag, typeID

id ▼ accountId name city countryId defaultFlag locationGroupId addressName residentialFlag stateId address typeID zip
1 1   Sterling 2 _binary  1 Innofiber, LLC _binary 24 2 Spratt Technology Way 50 01564
4 7 Acclarent, Inc. Irvine 2 _binary    Main Address _binary 6 33 Technology Drive 50 92618
6 8 Agilent Technologies, Inc. Santa Clara 2 _binary    Main Address _binary 6 5301 Stevens Creek Blvd 50 95051
7 8 Agilent Technologies, Inc. Winooski 2 _binary    Vermont Ship to _binary 49 Vermont Manufacturing 100 Tigan St 10 05404
8 8 Agilent Technologies Colorado Springs 2 _binary    Main Bill to _binary 7 Financial Services Center P.O. Box 2995 20 80901-2995
9 9 CemasElettra S.r.l. Carmagnola 117 _binary    Main Address _binary 81 Strada degli Occhini, 23 50 10022
10 10 NeoChord St. Louis Park 2 _binary    Main Address _binary 26 5402 Parkdale Drive Suite 160 50 55416
11 10 NeoChord St. Louis Park 2 _binary   Ship to _binary 26 5402 Parkdale Drive Suite 160 10 55416
12 11 Rockwell Automation, Inc. Milwaukee 2 _binary    Main Address _binary 54 1201 South Second Street 50 53204
13 11 Rockwell Automation, Inc. Whitestown 2 _binary    Ship To: Whitestown _binary 17 Whitestown Distribution Center Rockwell Automation C/O Ryder 4255 S 500 E 10 46075
14 11 Rockwell Automation, Inc. Milwaukee 2 _binary    Main Bill to _binary 54 1201 South Second Street 20 53204
15 12 Pepperl+Fuchs America, Inc. Twinsburg 2 _binary    Main Address _binary 39 1600 Enterprise Parkway 50 44087
17 12 Pepperl+Fuchs Americas, Inc. Twinsburg 2 _binary    Billing _binary 39 8093 Darrow Road 20 44087
18 13 Lumitex, Inc. Brecksville 2 _binary    Main Address _binary 39 6611 W Snowville Rd 50 44141
19 13 Lumitex, LLC. Brecksville 2 _binary    Ship To _binary 39 6611 W Snowville Rd. 10 44141
20 14 Iridex Corporation Mountain View 2 _binary    Main Address _binary 6 1212 Terra Bella Avenue 50 94043-1824
21 15 Fiberoptic Systems, Inc. Simi Valley 2 _binary    Main Address _binary 6 60 Moreland Road Unit A 50 93065
22 16 Intuitive Surgical, Inc. Sunnyvale 2 _binary    Main Address _binary 6 1020 Kifer Road 50 94086
23 16 Intuitive Surgical Sunnyvale 2 _binary    Shipping #1 _binary 6 111 Uranium Drive Building 117 10 94086
24 16 Intuitive Surgical Sarl Aubonne 213 _binary   Bill to #1 _binary   1, Chemin des Muriers 20 CH-1170
25 17 Radwell International - US Willingboro 2 _binary    Main Address _binary 33 1 Millenium Dr 50 08046-1000
26 11 Rockwell Automation - FTZ1140E00 Champaign 2 _binary   Ship to: PRD Background _binary 16 2802 Bloomington Road 10 61822-9548
27 18 SICK Prod. Center Americas, LLC Bloomington 2 _binary    Main Address _binary 26 6900 West 110th Street 50 55438
28 18 SICK PCA Savage 2 _binary   Ship to: Savage _binary 26 Savage 8633 Eagle Creek Pkwy 10 55378-1284
29 18 Sick Optic-Electronic, Inc. Bloomington 2 _binary    Bill to _binary 26 2700 Lindau Ln 20 55425
30 19 Rockwell Automation Technologies, Inc. Santo Domingo 75 _binary    Main Address _binary   Dominican Republic Autopista Las Americas km. 22 Lot B-1 & B-2 50 10100
31 19 Rockwell Automation Technologies, Inc. Miami 2 _binary    Ship To: Dominican Republic _binary 11 C/O UPS SCS Door 18-19 Assembly 3400 N.W. 74th Avenue 10 33122
32 19 Rockwell Automation Technologies, Inc. Santo Domingo 75 _binary    Bill To: Dominican Republic _binary   Autopista Las Amerias km. 22 Lot B-1 & B-2 20 10100
33 20 Balluff, Inc. Florence 2 _binary    Main Address _binary 20 8125 Holton Drive 50 41042-0937
34 21 Fireye, Inc. Derry 2 _binary    Main Address _binary 32 3 Manchester Road Accounts Payable 50 03038
35 21 Fireye, Inc. Derry 2 _binary    Ship To: Derry _binary 32 3 Manchester Road 10 03038
36 22 WEINERT Fiber Optics, Inc. Williamsburg 2 _binary    Main Address _binary 50 209 Bulifants Blvd. 50 23188
37 22 WEINERT Fiber Optics, Inc. WIlliamsburg 2 _binary    Ship To: VA _binary 50 215D Bulifants Blvd. 10 23188
38 22 WEINERT Fiber Optics, Inc. Lightfoot 2 _binary    Billing _binary 50 P.O. Box 615 20 23090
39 23 Instrumental Machine & Dev. Warsaw 2 _binary    Main Address _binary 17 2098 N. Pound Dr. W. 50 46582
40 24 Weco Manufacturing Group Rochester 2 _binary    Main Address _binary 35 275 Commerce Drive 50 14623
41 25 Nikon Metrology, Inc. Brighton 2 _binary    Main Address _binary 25 12701 Grand River Avenue 50 48116
42 25 Nikon Metrology, Inc. Brighton 2 _binary    Address #2 _binary 25 12701 Grand River Avenue Attn: Accounts Payable 20 48116
43 26 Diamond Systems Flower Mound 2 _binary    Main Address _binary  47 P.O. Box 271567 50 75022-1567
44 26 Diamond Systems Flower Mound 2 _binary    Ship To #1 _binary 47 1537 Simmons Rd 10 75022
45 27 Kurdex Corporation Sunnyvale 2 _binary    Main Address _binary 6 343 Gibraltar Drive 50 94089
46 28 Wie Sic Machine, Inc. Lowell 2 _binary    Main Address _binary 24 48 Newhall St. 50 01852-4122
47 29 Pendar Technologies Cambridge 2 _binary    Main Address _binary 24 30 Spinelli Pl Suite 101 50 02138
48 30 Pantron Automation, Inc. Belmont 2 _binary    Main Address _binary 36 109 Hubbard St UPS: X67446 50 28012
49 30 Pantron Automation, Inc. Belmont 2 _binary    Bill To #1 _binary 36 P.O. Box Q 20  
50 30 Pantron Automation, Inc. Belmont 2 _binary    Ship To: Belmont _binary 36 109 Hubbard St. 10 28012
51 31 Matdan Aerospace Cincinnati 2 _binary    Main Address _binary 39 10845 Millington Court 50 45242
52 31 Matdan Aerospace Cincinnati 2 _binary    Ship To: Cincinnati _binary 39 10845 Millington Ct. 10 45242
53 32 Peregrine Surgical Ltd. New Britain 2 _binary    Main Address _binary 42 51 Britain Drive 50 18901
54 33 Inertia Dynamics, LLC New Hartford 2 _binary    Main Address _binary 8 31 Industrial Park Rd. 50 06057

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "address" (
 "id" INTEGERNOT NULL ,
 "accountId" INTEGERNOT NULL,
 "name" TEXT NOT NULL,
 "city" TEXT DEFAULT NULL,
 "countryId" INTEGERDEFAULT NULL,
 "defaultFlag" INTEGER NOT NULL,
 "locationGroupId" INTEGERDEFAULT NULL,
 "addressName" TEXT NOT NULL,
 "residentialFlag" INTEGER NOT NULL,
 "stateId" INTEGERDEFAULT NULL,
 "address" TEXT NOT NULL,
 "typeID" INTEGERNOT NULL,
 "zip" TEXT DEFAULT NULL,
 PRIMARY KEY ("id")
);