Read-only Back to SQLite3 Guide
Northwind › Employees › 9
Anne Dodsworth

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

Record
See the SQL ›
EmployeeIDPK
9
LastName
Dodsworth
FirstName
Anne
Title
Sales Representative
TitleOfCourtesy
Ms.
BirthDate
1966-01-27
HireDate
1994-11-15
Address
7 Houndstooth Rd.
City
London
Region
NULL
PostalCode
WG2 7LT
Country
UK
HomePhone
(71) 555-4444
Extension
452
Photo
Photo of Anne DodsworthBLOB, 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
Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.
ReportsToFK
5
PhotoPath
http://accweb/emmployees/davolio.bmp
Employees via ReportsTo
0 rows
No Employees rows point at this employees row.
Orders via EmployeeID
43 rows
OrderIDCustomerIDEmployeeIDOrderDateRequiredDateShippedDateShipViaFreightShipNameShipAddressShipCityShipRegionShipPostalCodeShipCountry
10255 RICSU 9 1996-07-12 1996-08-09 1996-07-15 3 148.33 Richter Supermarkt Starenweg 5 Genève NULL 1204 Switzerland
10263 ERNSH 9 1996-07-23 1996-08-20 1996-07-31 3 146.06 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10324 SAVEA 9 1996-10-08 1996-11-05 1996-10-10 1 214.27 Save-a-lot Markets 187 Suffolk Ln. Boise ID 83720 USA
10331 BONAP 9 1996-10-16 1996-11-27 1996-10-21 1 10.19 Bon app' 12, rue des Bouchers Marseille NULL 13008 France
10386 FAMIA 9 1996-12-18 1997-01-01 1996-12-25 3 13.99 Familia Arquibaldo Rua Orós, 92 Sao Paulo SP 05442-030 Brazil
10411 BOTTM 9 1997-01-10 1997-02-07 1997-01-21 3 23.65 Bottom-Dollar Markets 23 Tsawassen Blvd. Tsawassen BC T2F 8M4 Canada
10475 SUPRD 9 1997-03-14 1997-04-11 1997-04-04 1 68.52 Suprêmes délices Boulevard Tirou, 255 Charleroi NULL B-6000 Belgium
10501 BLAUS 9 1997-04-09 1997-05-07 1997-04-16 3 8.85 Blauer See Delikatessen Forsterstr. 57 Mannheim NULL 68306 Germany
10506 KOENE 9 1997-04-15 1997-05-13 1997-05-02 2 21.19 Königlich Essen Maubelstr. 90 Brandenburg NULL 14776 Germany
10538 BSBEV 9 1997-05-15 1997-06-12 1997-05-16 3 4.87 B's Beverages Fauntleroy Circus London NULL EC2 5NT UK
10557 LEHMS 9 1997-06-03 1997-06-17 1997-06-06 2 96.72 Lehmanns Marktstand Magazinweg 7 Frankfurt a.M. NULL 60528 Germany
10566 BLONP 9 1997-06-12 1997-07-10 1997-06-18 1 88.4 Blondel père et fils 24, place Kléber Strasbourg NULL 67000 France
10577 TRAIH 9 1997-06-23 1997-08-04 1997-06-30 2 25.41 Trail's Head Gourmet Provisioners 722 DaVinci Blvd. Kirkland WA 98034 USA
10586 REGGC 9 1997-07-02 1997-07-30 1997-07-09 1 0.48 Reggiani Caseifici Strada Provinciale 124 Reggio Emilia NULL 42100 Italy
10646 HUNGO 9 1997-08-27 1997-10-08 1997-09-03 3 142.33 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10672 BERGS 9 1997-09-17 1997-10-01 1997-09-26 2 95.75 Berglunds snabbköp Berguvsvägen 8 Luleå NULL S-958 22 Sweden
10687 HUNGO 9 1997-09-30 1997-10-28 1997-10-30 2 296.43 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10705 HILAA 9 1997-10-15 1997-11-12 1997-11-18 2 3.52 HILARION-Abastos Carrera 22 con Ave. Carlos Soublette #8-35 San Cristóbal Táchira 5022 Venezuela
10736 HUNGO 9 1997-11-11 1997-12-09 1997-11-21 2 44.1 Hungry Owl All-Night Grocers 8 Johnstown Road Cork Co. Cork NULL Ireland
10745 QUICK 9 1997-11-18 1997-12-16 1997-11-27 1 3.52 QUICK-Stop Taucherstraße 10 Cunewalde NULL 01307 Germany
10750 WARTH 9 1997-11-21 1997-12-19 1997-11-24 1 79.3 Wartian Herkku Torikatu 38 Oulu NULL 90110 Finland
10771 ERNSH 9 1997-12-10 1998-01-07 1998-01-02 2 11.19 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
10782 CACTU 9 1997-12-17 1998-01-14 1997-12-22 3 1.1 Cactus Comidas para llevar Cerrito 333 Buenos Aires NULL 1010 Argentina
10799 KOENE 9 1997-12-26 1998-02-06 1998-01-05 3 30.76 Königlich Essen Maubelstr. 90 Brandenburg NULL 14776 Germany
10828 RANCH 9 1998-01-13 1998-01-27 1998-02-04 1 90.85 Rancho grande Av. del Libertador 900 Buenos Aires NULL 1010 Argentina
10829 ISLAT 9 1998-01-13 1998-02-10 1998-01-23 1 154.72 Island Trading Garden House Crowther Way Cowes Isle of Wight PO31 7PJ UK
10837 BERGS 9 1998-01-16 1998-02-13 1998-01-23 3 13.32 Berglunds snabbköp Berguvsvägen 8 Luleå NULL S-958 22 Sweden
10849 KOENE 9 1998-01-23 1998-02-20 1998-01-30 2 0.56 Königlich Essen Maubelstr. 90 Brandenburg NULL 14776 Germany
10853 BLAUS 9 1998-01-27 1998-02-24 1998-02-03 2 53.83 Blauer See Delikatessen Forsterstr. 57 Mannheim NULL 68306 Germany
10871 BONAP 9 1998-02-05 1998-03-05 1998-02-10 2 112.27 Bon app' 12, rue des Bouchers Marseille NULL 13008 France
10889 RATTC 9 1998-02-16 1998-03-16 1998-02-23 3 280.61 Rattlesnake Canyon Grocery 2817 Milton Dr. Albuquerque NM 87110 USA
10893 KOENE 9 1998-02-18 1998-03-18 1998-02-20 2 77.78 Königlich Essen Maubelstr. 90 Brandenburg NULL 14776 Germany
10905 WELLI 9 1998-02-24 1998-03-24 1998-03-06 2 13.72 Wellington Importadora Rua do Mercado, 12 Resende SP 08737-363 Brazil
10942 REGGC 9 1998-03-11 1998-04-08 1998-03-18 3 17.95 Reggiani Caseifici Strada Provinciale 124 Reggio Emilia NULL 42100 Italy
10951 RICSU 9 1998-03-16 1998-04-27 1998-04-07 2 30.85 Richter Supermarkt Starenweg 5 Genève NULL 1204 Switzerland
10953 AROUT 9 1998-03-16 1998-03-30 1998-03-25 2 23.72 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK
10963 FURIB 9 1998-03-19 1998-04-16 1998-03-26 3 2.7 Furia Bacalhau e Frutos do Mar Jardim das rosas n. 32 Lisboa NULL 1675 Portugal
10970 BOLID 9 1998-03-24 1998-04-07 1998-04-24 1 16.16 Bólido Comidas preparadas C/ Araquil, 67 Madrid NULL 28023 Spain
10978 MAISD 9 1998-03-26 1998-04-23 1998-04-23 2 32.82 Maison Dewey Rue Joseph-Bens 532 Bruxelles NULL B-1180 Belgium
11016 AROUT 9 1998-04-10 1998-05-08 1998-04-13 2 33.8 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK
11017 ERNSH 9 1998-04-13 1998-05-11 1998-04-20 2 754.26 Ernst Handel Kirchgasse 6 Graz NULL 8010 Austria
11022 HANAR 9 1998-04-14 1998-05-12 1998-05-04 2 6.27 Hanari Carnes Rua do Paço, 67 Rio de Janeiro RJ 05454-876 Brazil
11058 BLAUS 9 1998-04-29 1998-05-27 NULL 3 31.14 Blauer See Delikatessen Forsterstr. 57 Mannheim NULL 68306 Germany
EmployeeTerritories via EmployeeID
7 rows
row EmployeeIDTerritoryID
open › 9 03049
open › 9 03801
open › 9 48075
open › 9 48084
open › 9 48304
open › 9 55113
open › 9 55439