Read-only Back to SQLite3 Guide
Northwind › Employees › 7
Robert King

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

EmployeeIDPK
7
LastName
King
FirstName
Robert
Title
Sales Representative
TitleOfCourtesy
Mr.
BirthDate
1960-05-29
HireDate
1994-01-02
Address
Edgeham Hollow
Winchester Way
City
London
Region
NULL
PostalCode
RG1 9SP
Country
UK
HomePhone
(71) 555-5598
Extension
465
Photo
Photo of Robert KingBLOB, 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
Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled "Selling in Europe," he was transferred to the London office in March 1993.
ReportsToFK
5
PhotoPath
http://accweb/emmployees/davolio.bmp
Employees via ReportsTo
0 rows
No Employees rows point at this employees row.
Orders via EmployeeID
72 rows · showing 50 · see all
OrderIDCustomerIDEmployeeIDOrderDateRequiredDateShippedDateShipViaFreightShipNameShipAddressShipCityShipRegionShipPostalCodeShipCountry
10289 BSBEV 7 1996-08-26 1996-09-23 1996-08-28 3 22.77 B's Beverages Fauntleroy Circus London NULL EC2 5NT UK
10303 GODOS 7 1996-09-11 1996-10-09 1996-09-18 2 107.83 Godos Cocina Típica C/ Romero, 33 Sevilla NULL 41101 Spain
10308 ANATR 7 1996-09-18 1996-10-16 1996-09-24 3 1.61 Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico
10319 TORTU 7 1996-10-02 1996-10-30 1996-10-11 3 64.5 Tortuga Restaurante Avda. Azteca 123 México D.F. NULL 05033 Mexico
10322 PERIC 7 1996-10-04 1996-11-01 1996-10-23 3 0.4 Pericles Comidas clásicas Calle Dr. Jorge Cash 321 México D.F. NULL 05033 Mexico
10335 HUNGO 7 1996-10-22 1996-11-19 1996-10-24 2 42.11 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10336 PRINI 7 1996-10-23 1996-11-20 1996-10-25 2 15.51 Princesa Isabel Vinhos Estrada da saúde n. 58 Lisboa NULL 1756 Portugal
10341 SIMOB 7 1996-10-29 1996-11-26 1996-11-05 3 26.78 Simons bistro Vinbæltet 34 Kobenhavn NULL 1734 Denmark
10349 SPLIR 7 1996-11-08 1996-12-06 1996-11-15 1 8.63 Split Rail Beer & Ale P.O. Box 555 Lander WY 82520 USA
10353 PICCO 7 1996-11-13 1996-12-11 1996-11-25 3 360.63 Piccolo und mehr Geislweg 14 Salzburg NULL 5020 Austria
10367 VAFFE 7 1996-11-28 1996-12-26 1996-12-02 3 13.55 Vaffeljernet Smagsloget 45 Århus NULL 8200 Denmark
10406 QUEEN 7 1997-01-07 1997-02-18 1997-01-13 1 108.04 Queen Cozinha Alameda dos Canàrios, 891 Sao Paulo SP 05487-020 Brazil
10424 MEREP 7 1997-01-23 1997-02-20 1997-01-27 2 370.61 Mère Paillarde 43 rue St. Laurent Montréal Québec H1J 1C3 Canada
10428 REGGC 7 1997-01-28 1997-02-25 1997-02-04 1 11.09 Reggiani Caseifici Strada Provinciale 124 Reggio Emilia NULL 42100 Italy
10458 SUPRD 7 1997-02-26 1997-03-26 1997-03-04 3 147.06 Suprêmes délices Boulevard Tirou, 255 Charleroi NULL B-6000 Belgium
10483 WHITC 7 1997-03-24 1997-04-21 1997-04-25 2 15.28 White Clover Markets 1029 - 12th Ave. S. Seattle WA 98124 USA
10490 HILAA 7 1997-03-31 1997-04-28 1997-04-03 2 210.19 HILARION-Abastos Carrera 22 con Ave. Carlos Soublette #8-35 San Cristóbal Táchira 5022 Venezuela
10496 TRADH 7 1997-04-04 1997-05-02 1997-04-07 2 46.77 Tradiçao Hipermercados Av. Inês de Castro, 414 Sao Paulo SP 05634-030 Brazil
10497 LEHMS 7 1997-04-04 1997-05-02 1997-04-07 1 36.21 Lehmanns Marktstand Magazinweg 7 Frankfurt a.M. NULL 60528 Germany
10507 ANTON 7 1997-04-15 1997-05-13 1997-04-22 1 47.45 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10512 FAMIA 7 1997-04-21 1997-05-19 1997-04-24 2 3.53 Familia Arquibaldo Rua Orós, 92 Sao Paulo SP 05442-030 Brazil
10513 WANDK 7 1997-04-22 1997-06-03 1997-04-28 1 105.65 Die Wandernde Kuh Adenauerallee 900 Stuttgart NULL 70563 Germany
10520 SANTG 7 1997-04-29 1997-05-27 1997-05-01 1 13.37 Santé Gourmet Erling Skakkes gate 78 Stavern NULL 4110 Norway
10523 SEVES 7 1997-05-01 1997-05-29 1997-05-30 2 77.63 Seven Seas Imports 90 Wadhurst Rd. London NULL OX15 4NB UK
10527 QUICK 7 1997-05-05 1997-06-02 1997-05-07 1 41.9 QUICK-Stop Taucherstraße 10 Cunewalde NULL 01307 Germany
10531 OCEAN 7 1997-05-08 1997-06-05 1997-05-19 1 8.12 Océano Atlántico Ltda. Ing. Gustavo Moncada 8585 Piso 20-A Buenos Aires NULL 1010 Argentina
10532 EASTC 7 1997-05-09 1997-06-06 1997-05-12 3 74.46 Eastern Connection 35 King George London NULL WX3 6FW UK
10550 GODOS 7 1997-05-28 1997-06-25 1997-06-06 3 4.32 Godos Cocina Típica C/ Romero, 33 Sevilla NULL 41101 Spain
10573 ANTON 7 1997-06-19 1997-07-17 1997-06-20 3 84.84 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10585 WELLI 7 1997-07-01 1997-07-29 1997-07-10 1 13.41 Wellington Importadora Rua do Mercado, 12 Resende SP 08737-363 Brazil
10593 LEHMS 7 1997-07-09 1997-08-06 1997-08-13 2 174.2 Lehmanns Marktstand Magazinweg 7 Frankfurt a.M. NULL 60528 Germany
10597 PICCO 7 1997-07-11 1997-08-08 1997-07-18 3 35.12 Piccolo und mehr Geislweg 14 Salzburg NULL 5020 Austria
10601 HILAA 7 1997-07-16 1997-08-27 1997-07-22 1 58.3 HILARION-Abastos Carrera 22 con Ave. Carlos Soublette #8-35 San Cristóbal Táchira 5022 Venezuela
10609 DUMON 7 1997-07-24 1997-08-21 1997-07-30 2 1.85 Du monde entier 67, rue des Cinquante Otages Nantes NULL 44000 France
10633 ERNSH 7 1997-08-15 1997-09-12 1997-08-18 3 477.9 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10639 SANTG 7 1997-08-20 1997-09-17 1997-08-27 3 38.64 Santé Gourmet Erling Skakkes gate 78 Stavern NULL 4110 Norway
10642 SIMOB 7 1997-08-22 1997-09-19 1997-09-05 3 41.89 Simons bistro Vinbæltet 34 Kobenhavn NULL 1734 Denmark
10659 QUEEN 7 1997-09-05 1997-10-03 1997-09-10 2 105.81 Queen Cozinha Alameda dos Canàrios, 891 Sao Paulo SP 05487-020 Brazil
10661 HUNGO 7 1997-09-09 1997-10-07 1997-09-15 3 17.55 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10666 RICSU 7 1997-09-12 1997-10-10 1997-09-22 2 232.42 Richter Supermarkt Starenweg 5 Genève NULL 1204 Switzerland
10667 ERNSH 7 1997-09-12 1997-10-10 1997-09-19 1 78.09 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10678 SAVEA 7 1997-09-23 1997-10-21 1997-10-16 3 388.98 Save-a-lot Markets 187 Suffolk Ln. Boise ID 83720 USA
10695 WILMK 7 1997-10-07 1997-11-18 1997-10-14 1 16.72 Wilman Kala Keskuskatu 45 Helsinki NULL 21240 Finland
10731 CHOPS 7 1997-11-06 1997-12-04 1997-11-14 1 96.65 Chop-suey Chinese Hauptstr. 31 Bern NULL 3012 Switzerland
10775 THECR 7 1997-12-12 1998-01-09 1997-12-26 1 20.25 The Cracker Box 55 Grizzly Peak Rd. Butte MT 59801 USA
10777 GOURL 7 1997-12-15 1997-12-29 1998-01-21 2 3.01 Gourmet Lanchonetes Av. Brasil, 442 Campinas SP 04876-786 Brazil
10797 DRACD 7 1997-12-25 1998-01-22 1998-01-05 2 33.35 Drachenblut Delikatessen Walserweg 21 Aachen NULL 52066 Germany
10809 WELLI 7 1998-01-01 1998-01-29 1998-01-07 1 4.87 Wellington Importadora Rua do Mercado, 12 Resende SP 08737-363 Brazil
10818 MAGAA 7 1998-01-07 1998-02-04 1998-01-12 3 65.48 Magazzini Alimentari Riuniti Via Ludovico il Moro 22 Bergamo NULL 24100 Italy
10836 ERNSH 7 1998-01-16 1998-02-13 1998-01-21 1 411.88 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
EmployeeTerritories via EmployeeID
10 rows