Read-only Back to SQLite3 Guide
Northwind › Employees › 4
Margaret Peacock

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

Record
See the SQL ›
EmployeeIDPK
4
LastName
Peacock
FirstName
Margaret
Title
Sales Representative
TitleOfCourtesy
Mrs.
BirthDate
1937-09-19
HireDate
1993-05-03
Address
4110 Old Redmond Rd.
City
Redmond
Region
WA
PostalCode
98052
Country
USA
HomePhone
(206) 555-8122
Extension
5176
Photo
Photo of Margaret PeacockBLOB, 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
Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.
ReportsToFK
2
PhotoPath
http://accweb/emmployees/peacock.bmp
Employees via ReportsTo
0 rows
No Employees rows point at this employees row.
Orders via EmployeeID
156 rows · showing 50 · see all
OrderIDCustomerIDEmployeeIDOrderDateRequiredDateShippedDateShipViaFreightShipNameShipAddressShipCityShipRegionShipPostalCodeShipCountry
10250 HANAR 4 1996-07-08 1996-08-05 1996-07-12 2 65.83 Hanari Carnes Rua do Paço, 67 Rio de Janeiro RJ 05454-876 Brazil
10252 SUPRD 4 1996-07-09 1996-08-06 1996-07-11 2 51.3 Suprêmes délices Boulevard Tirou, 255 Charleroi NULL B-6000 Belgium
10257 HILAA 4 1996-07-16 1996-08-13 1996-07-22 3 81.91 HILARION-Abastos Carrera 22 con Ave. Carlos Soublette #8-35 San Cristóbal Táchira 5022 Venezuela
10259 CENTC 4 1996-07-18 1996-08-15 1996-07-25 3 3.25 Centro comercial Moctezuma Sierras de Granada 9993 México D.F. NULL 05022 Mexico
10260 OTTIK 4 1996-07-19 1996-08-16 1996-07-29 1 55.09 Ottilies Käseladen Mehrheimerstr. 369 Köln NULL 50739 Germany
10261 QUEDE 4 1996-07-19 1996-08-16 1996-07-30 2 3.05 Que Delícia Rua da Panificadora, 12 Rio de Janeiro RJ 02389-673 Brazil
10267 FRANK 4 1996-07-29 1996-08-26 1996-08-06 1 208.58 Frankenversand Berliner Platz 43 München NULL 80805 Germany
10281 ROMEY 4 1996-08-14 1996-08-28 1996-08-21 1 2.94 Romero y tomillo Gran Vía, 1 Madrid NULL 28001 Spain
10282 ROMEY 4 1996-08-15 1996-09-12 1996-08-21 1 12.69 Romero y tomillo Gran Vía, 1 Madrid NULL 28001 Spain
10284 LEHMS 4 1996-08-19 1996-09-16 1996-08-27 1 76.56 Lehmanns Marktstand Magazinweg 7 Frankfurt a.M. NULL 60528 Germany
10288 REGGC 4 1996-08-23 1996-09-20 1996-09-03 1 7.45 Reggiani Caseifici Strada Provinciale 124 Reggio Emilia NULL 42100 Italy
10294 RATTC 4 1996-08-30 1996-09-27 1996-09-05 2 147.26 Rattlesnake Canyon Grocery 2817 Milton Dr. Albuquerque NM 87110 USA
10299 RICAR 4 1996-09-06 1996-10-04 1996-09-13 2 29.76 Ricardo Adocicados Av. Copacabana, 267 Rio de Janeiro RJ 02389-890 Brazil
10302 SUPRD 4 1996-09-10 1996-10-08 1996-10-09 2 6.27 Suprêmes délices Boulevard Tirou, 255 Charleroi NULL B-6000 Belgium
10315 ISLAT 4 1996-09-26 1996-10-24 1996-10-03 2 41.76 Island Trading Garden House Crowther Way Cowes Isle of Wight PO31 7PJ UK
10323 KOENE 4 1996-10-07 1996-11-04 1996-10-14 1 4.88 Königlich Essen Maubelstr. 90 Brandenburg NULL 14776 Germany
10326 BOLID 4 1996-10-10 1996-11-07 1996-10-14 2 77.92 Bólido Comidas preparadas C/ Araquil, 67 Madrid NULL 28023 Spain
10328 FURIB 4 1996-10-14 1996-11-11 1996-10-17 3 87.03 Furia Bacalhau e Frutos do Mar Jardim das rosas n. 32 Lisboa NULL 1675 Portugal
10329 SPLIR 4 1996-10-15 1996-11-26 1996-10-23 2 191.67 Split Rail Beer & Ale P.O. Box 555 Lander WY 82520 USA
10337 FRANK 4 1996-10-24 1996-11-21 1996-10-29 3 108.26 Frankenversand Berliner Platz 43 München NULL 80805 Germany
10338 OLDWO 4 1996-10-25 1996-11-22 1996-10-29 3 84.21 Old World Delicatessen 2743 Bering St. Anchorage AK 99508 USA
10342 FRANK 4 1996-10-30 1996-11-13 1996-11-04 2 54.83 Frankenversand Berliner Platz 43 München NULL 80805 Germany
10343 LEHMS 4 1996-10-31 1996-11-28 1996-11-06 1 110.37 Lehmanns Marktstand Magazinweg 7 Frankfurt a.M. NULL 60528 Germany
10344 WHITC 4 1996-11-01 1996-11-29 1996-11-05 2 23.29 White Clover Markets 1029 - 12th Ave. S. Seattle WA 98124 USA
10347 FAMIA 4 1996-11-06 1996-12-04 1996-11-08 3 3.1 Familia Arquibaldo Rua Orós, 92 Sao Paulo SP 05442-030 Brazil
10348 WANDK 4 1996-11-07 1996-12-05 1996-11-15 2 0.78 Die Wandernde Kuh Adenauerallee 900 Stuttgart NULL 70563 Germany
10360 BLONP 4 1996-11-22 1996-12-20 1996-12-02 3 131.7 Blondel père et fils 24, place Kléber Strasbourg NULL 67000 France
10363 DRACD 4 1996-11-26 1996-12-24 1996-12-04 3 30.54 Drachenblut Delikatessen Walserweg 21 Aachen NULL 52066 Germany
10373 HUNGO 4 1996-12-05 1997-01-02 1996-12-11 3 124.12 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10382 ERNSH 4 1996-12-13 1997-01-10 1996-12-16 1 94.77 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10389 BOTTM 4 1996-12-20 1997-01-17 1996-12-24 2 47.42 Bottom-Dollar Markets 23 Tsawassen Blvd. Tsawassen BC T2F 8M4 Canada
10403 ERNSH 4 1997-01-03 1997-01-31 1997-01-09 3 73.79 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10417 SIMOB 4 1997-01-16 1997-02-13 1997-01-28 3 70.29 Simons bistro Vinbæltet 34 Kobenhavn NULL 1734 Denmark
10418 QUICK 4 1997-01-17 1997-02-14 1997-01-24 1 17.55 QUICK-Stop Taucherstraße 10 Cunewalde NULL 01307 Germany
10419 RICSU 4 1997-01-20 1997-02-17 1997-01-30 2 137.35 Richter Supermarkt Starenweg 5 Genève NULL 1204 Switzerland
10426 GALED 4 1997-01-27 1997-02-24 1997-02-06 1 18.69 Galería del gastronómo Rambla de Cataluña, 23 Barcelona NULL 8022 Spain
10427 PICCO 4 1997-01-27 1997-02-24 1997-03-03 2 31.29 Piccolo und mehr Geislweg 14 Salzburg NULL 5020 Austria
10430 ERNSH 4 1997-01-30 1997-02-13 1997-02-03 1 458.78 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10431 BOTTM 4 1997-01-30 1997-02-13 1997-02-07 2 44.17 Bottom-Dollar Markets 23 Tsawassen Blvd. Tsawassen BC T2F 8M4 Canada
10440 SAVEA 4 1997-02-10 1997-03-10 1997-02-28 2 86.53 Save-a-lot Markets 187 Suffolk Ln. Boise ID 83720 USA
10447 RICAR 4 1997-02-14 1997-03-14 1997-03-07 2 68.66 Ricardo Adocicados Av. Copacabana, 267 Rio de Janeiro RJ 02389-890 Brazil
10448 RANCH 4 1997-02-17 1997-03-17 1997-02-24 2 38.82 Rancho grande Av. del Libertador 900 Buenos Aires NULL 1010 Argentina
10451 QUICK 4 1997-02-19 1997-03-05 1997-03-12 3 189.09 QUICK-Stop Taucherstraße 10 Cunewalde NULL 01307 Germany
10454 LAMAI 4 1997-02-21 1997-03-21 1997-02-25 3 2.74 La maison d'Asie 1 rue Alsace-Lorraine Toulouse NULL 31000 France
10459 VICTE 4 1997-02-27 1997-03-27 1997-02-28 2 25.09 Victuailles en stock 2, rue du Commerce Lyon NULL 69004 France
10464 FURIB 4 1997-03-04 1997-04-01 1997-03-14 2 89.0 Furia Bacalhau e Frutos do Mar Jardim das rosas n. 32 Lisboa NULL 1675 Portugal
10466 COMMI 4 1997-03-06 1997-04-03 1997-03-13 1 11.93 Comércio Mineiro Av. dos Lusíadas, 23 Sao Paulo SP 05432-043 Brazil
10470 BONAP 4 1997-03-11 1997-04-08 1997-03-14 2 64.56 Bon app' 12, rue des Bouchers Marseille NULL 13008 France
10485 LINOD 4 1997-03-25 1997-04-08 1997-03-31 2 64.45 LINO-Delicateses Ave. 5 de Mayo Porlamar I. de Margarita Nueva Esparta 4980 Venezuela
10493 LAMAI 4 1997-04-02 1997-04-30 1997-04-10 3 10.64 La maison d'Asie 1 rue Alsace-Lorraine Toulouse NULL 31000 France
EmployeeTerritories via EmployeeID
3 rows
row EmployeeIDTerritoryID
open › 4 20852
open › 4 27403
open › 4 27511