Read-only Back to SQLite3 Guide
Northwind › Employees › 6
Michael Suyama

Employees row where EmployeeID = 6. Blue values are foreign keys: click one to jump to the row it points at.

Record
See the SQL ›
EmployeeIDPK
6
LastName
Suyama
FirstName
Michael
Title
Sales Representative
TitleOfCourtesy
Mr.
BirthDate
1963-07-02
HireDate
1993-10-17
Address
Coventry House
Miner Rd.
City
London
Region
NULL
PostalCode
EC2 7JR
Country
UK
HomePhone
(71) 555-7773
Extension
428
Photo
Photo of Michael SuyamaBLOB, 21626 bytes. The image is a Windows bitmap behind a 78-byte OLE header that Microsoft Access added; it is shown here converted to PNG.
Notes
Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in Japanese and can read and write French, Portuguese, and Spanish.
ReportsToFK
5
PhotoPath
http://accweb/emmployees/davolio.bmp
Employees via ReportsTo
0 rows
No Employees rows point at this employees row.
Orders via EmployeeID
67 rows · showing 50 · see all
OrderIDCustomerIDEmployeeIDOrderDateRequiredDateShippedDateShipViaFreightShipNameShipAddressShipCityShipRegionShipPostalCodeShipCountry
10249 TOMSP 6 1996-07-05 1996-08-16 1996-07-10 1 11.61 Toms Spezialitäten Luisenstr. 48 Münster NULL 44087 Germany
10264 FOLKO 6 1996-07-24 1996-08-21 1996-08-23 3 3.67 Folk och fä HB Åkergatan 24 Bräcke NULL S-844 67 Sweden
10271 SPLIR 6 1996-08-01 1996-08-29 1996-08-30 2 4.54 Split Rail Beer & Ale P.O. Box 555 Lander WY 82520 USA
10272 RATTC 6 1996-08-02 1996-08-30 1996-08-06 2 98.03 Rattlesnake Canyon Grocery 2817 Milton Dr. Albuquerque NM 87110 USA
10274 VINET 6 1996-08-06 1996-09-03 1996-08-16 1 6.01 Vins et alcools Chevalier 59 rue de l'Abbaye Reims NULL 51100 France
10291 QUEDE 6 1996-08-27 1996-09-24 1996-09-04 2 6.4 Que Delícia Rua da Panificadora, 12 Rio de Janeiro RJ 02389-673 Brazil
10296 LILAS 6 1996-09-03 1996-10-01 1996-09-11 1 0.12 LILA-Supermercado Carrera 52 con Ave. Bolívar #65-98 Llano Largo Barquisimeto Lara 3508 Venezuela
10298 HUNGO 6 1996-09-05 1996-10-03 1996-09-11 2 168.22 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10317 LONEP 6 1996-09-30 1996-10-28 1996-10-10 1 12.69 Lonesome Pine Restaurant 89 Chiaroscuro Rd. Portland OR 97219 USA
10350 LAMAI 6 1996-11-11 1996-12-09 1996-12-03 2 64.19 La maison d'Asie 1 rue Alsace-Lorraine Toulouse NULL 31000 France
10355 AROUT 6 1996-11-15 1996-12-13 1996-11-20 1 41.95 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK
10356 WANDK 6 1996-11-18 1996-12-16 1996-11-27 2 36.71 Die Wandernde Kuh Adenauerallee 900 Stuttgart NULL 70563 Germany
10370 CHOPS 6 1996-12-03 1996-12-31 1996-12-27 2 1.17 Chop-suey Chinese Hauptstr. 31 Bern NULL 3012 Switzerland
10390 ERNSH 6 1996-12-23 1997-01-20 1996-12-26 1 126.38 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10395 HILAA 6 1996-12-26 1997-01-23 1997-01-03 1 184.41 HILARION-Abastos Carrera 22 con Ave. Carlos Soublette #8-35 San Cristóbal Táchira 5022 Venezuela
10423 GOURL 6 1997-01-23 1997-02-06 1997-02-24 3 24.5 Gourmet Lanchonetes Av. Brasil, 442 Campinas SP 04876-786 Brazil
10425 LAMAI 6 1997-01-24 1997-02-21 1997-02-14 2 7.93 La maison d'Asie 1 rue Alsace-Lorraine Toulouse NULL 31000 France
10439 MEREP 6 1997-02-07 1997-03-07 1997-02-10 3 4.07 Mère Paillarde 43 rue St. Laurent Montréal Québec H1J 1C3 Canada
10446 TOMSP 6 1997-02-14 1997-03-14 1997-02-19 1 14.68 Toms Spezialitäten Luisenstr. 48 Münster NULL 44087 Germany
10480 FOLIG 6 1997-03-20 1997-04-17 1997-03-24 2 1.35 Folies gourmandes 184, chaussée de Tournai Lille NULL 59000 France
10489 PICCO 6 1997-03-28 1997-04-25 1997-04-09 2 5.29 Piccolo und mehr Geislweg 14 Salzburg NULL 5020 Austria
10500 LAMAI 6 1997-04-09 1997-05-07 1997-04-17 1 42.68 La maison d'Asie 1 rue Alsace-Lorraine Toulouse NULL 31000 France
10503 HUNGO 6 1997-04-11 1997-05-09 1997-04-16 2 16.74 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10510 SAVEA 6 1997-04-18 1997-05-16 1997-04-28 3 367.63 Save-a-lot Markets 187 Suffolk Ln. Boise ID 83720 USA
10519 CHOPS 6 1997-04-28 1997-05-26 1997-05-01 3 91.76 Chop-suey Chinese Hauptstr. 31 Bern NULL 3012 Switzerland
10528 GREAL 6 1997-05-06 1997-05-20 1997-05-09 2 3.35 Great Lakes Food Market 2732 Baker Blvd. Eugene OR 97403 USA
10539 BSBEV 6 1997-05-16 1997-06-13 1997-05-23 3 12.36 B's Beverages Fauntleroy Circus London NULL EC2 5NT UK
10555 SAVEA 6 1997-06-02 1997-06-30 1997-06-04 3 252.49 Save-a-lot Markets 187 Suffolk Ln. Boise ID 83720 USA
10559 BLONP 6 1997-06-05 1997-07-03 1997-06-13 1 8.05 Blondel père et fils 24, place Kléber Strasbourg NULL 67000 France
10599 BSBEV 6 1997-07-15 1997-08-26 1997-07-21 3 29.98 B's Beverages Fauntleroy Circus London NULL EC2 5NT UK
10611 WOLZA 6 1997-07-25 1997-08-22 1997-08-01 2 80.65 Wolski Zajazd ul. Filtrowa 68 Warszawa NULL 01-012 Poland
10637 QUEEN 6 1997-08-19 1997-09-16 1997-08-26 1 201.29 Queen Cozinha Alameda dos Canàrios, 891 Sao Paulo SP 05487-020 Brazil
10643 ALFKI 6 1997-08-25 1997-09-22 1997-09-02 1 29.46 Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany
10656 GREAL 6 1997-09-04 1997-10-02 1997-09-10 1 57.15 Great Lakes Food Market 2732 Baker Blvd. Eugene OR 97403 USA
10701 HUNGO 6 1997-10-13 1997-10-27 1997-10-15 3 220.31 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10703 FOLKO 6 1997-10-14 1997-11-11 1997-10-20 2 152.3 Folk och fä HB Åkergatan 24 Bräcke NULL S-844 67 Sweden
10704 QUEEN 6 1997-10-14 1997-11-11 1997-11-07 1 4.78 Queen Cozinha Alameda dos Canàrios, 891 Sao Paulo SP 05487-020 Brazil
10708 THEBI 6 1997-10-17 1997-11-28 1997-11-05 2 2.96 The Big Cheese 89 Jefferson Way Suite 2 Portland OR 97201 USA
10735 LETSS 6 1997-11-10 1997-12-08 1997-11-21 2 45.97 Let's Stop N Shop 87 Polk St. Suite 5 San Francisco CA 94117 USA
10744 VAFFE 6 1997-11-17 1997-12-15 1997-11-24 1 69.19 Vaffeljernet Smagsloget 45 Århus NULL 8200 Denmark
10747 PICCO 6 1997-11-19 1997-12-17 1997-11-26 1 117.33 Piccolo und mehr Geislweg 14 Salzburg NULL 5020 Austria
10754 MAGAA 6 1997-11-25 1997-12-23 1997-11-27 3 2.38 Magazzini Alimentari Riuniti Via Ludovico il Moro 22 Bergamo NULL 24100 Italy
10757 SAVEA 6 1997-11-27 1997-12-25 1997-12-15 1 8.19 Save-a-lot Markets 187 Suffolk Ln. Boise ID 83720 USA
10764 ERNSH 6 1997-12-03 1997-12-31 1997-12-08 3 145.45 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10790 GOURL 6 1997-12-22 1998-01-19 1997-12-26 1 28.23 Gourmet Lanchonetes Av. Brasil, 442 Campinas SP 04876-786 Brazil
10791 FRANK 6 1997-12-23 1998-01-20 1998-01-01 2 16.85 Frankenversand Berliner Platz 43 München NULL 80805 Germany
10794 QUEDE 6 1997-12-24 1998-01-21 1998-01-02 1 21.49 Que Delícia Rua da Panificadora, 12 Rio de Janeiro RJ 02389-673 Brazil
10804 SEVES 6 1997-12-30 1998-01-27 1998-01-07 2 27.33 Seven Seas Imports 90 Wadhurst Rd. London NULL OX15 4NB UK
10822 TRAIH 6 1998-01-08 1998-02-05 1998-01-16 3 7.0 Trail's Head Gourmet Provisioners 722 DaVinci Blvd. Kirkland WA 98034 USA
10826 BLONP 6 1998-01-12 1998-02-09 1998-02-06 1 7.09 Blondel père et fils 24, place Kléber Strasbourg NULL 67000 France
EmployeeTerritories via EmployeeID
5 rows
row EmployeeIDTerritoryID
open › 6 85014
open › 6 85251
open › 6 98004
open › 6 98052
open › 6 98104