Northwind › Tables
Orders table
One row per order: who bought, which employee sold it, which shipper carried it. 830 rows.
| OrderIDPK | CustomerIDFK | EmployeeIDFK | OrderDate | RequiredDate | ShippedDate | ShipViaFK | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10273 | QUICK | 3 | 1996-08-05 | 1996-09-02 | 1996-08-12 | 3 | 76.07 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 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 |
| 10275 | MAGAA | 1 | 1996-08-07 | 1996-09-04 | 1996-08-09 | 1 | 26.93 | Magazzini Alimentari Riuniti | Via Ludovico il Moro 22 | Bergamo | NULL | 24100 | Italy |
| 10276 | TORTU | 8 | 1996-08-08 | 1996-08-22 | 1996-08-14 | 3 | 13.84 | Tortuga Restaurante | Avda. Azteca 123 | México D.F. | NULL | 05033 | Mexico |
| 10277 | MORGK | 2 | 1996-08-09 | 1996-09-06 | 1996-08-13 | 3 | 125.77 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | NULL | 04179 | Germany |
| 10278 | BERGS | 8 | 1996-08-12 | 1996-09-09 | 1996-08-16 | 2 | 92.69 | Berglunds snabbköp | Berguvsvägen 8 | Luleå | NULL | S-958 22 | Sweden |
| 10279 | LEHMS | 8 | 1996-08-13 | 1996-09-10 | 1996-08-16 | 2 | 25.83 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10280 | BERGS | 2 | 1996-08-14 | 1996-09-11 | 1996-09-12 | 1 | 8.98 | Berglunds snabbköp | Berguvsvägen 8 | Luleå | NULL | S-958 22 | Sweden |
| 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 |
| 10283 | LILAS | 3 | 1996-08-16 | 1996-09-13 | 1996-08-23 | 3 | 84.81 | LILA-Supermercado | Carrera 52 con Ave. Bolívar #65-98 Llano Largo | Barquisimeto | Lara | 3508 | Venezuela |
| 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 |
| 10285 | QUICK | 1 | 1996-08-20 | 1996-09-17 | 1996-08-26 | 2 | 76.83 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10286 | QUICK | 8 | 1996-08-21 | 1996-09-18 | 1996-08-30 | 3 | 229.24 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10287 | RICAR | 8 | 1996-08-22 | 1996-09-19 | 1996-08-28 | 3 | 12.76 | Ricardo Adocicados | Av. Copacabana, 267 | Rio de Janeiro | RJ | 02389-890 | Brazil |
| 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 |
| 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 |
| 10290 | COMMI | 8 | 1996-08-27 | 1996-09-24 | 1996-09-03 | 1 | 79.7 | Comércio Mineiro | Av. dos Lusíadas, 23 | Sao Paulo | SP | 05432-043 | Brazil |
| 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 |
| 10292 | TRADH | 1 | 1996-08-28 | 1996-09-25 | 1996-09-02 | 2 | 1.35 | Tradiçao Hipermercados | Av. Inês de Castro, 414 | Sao Paulo | SP | 05634-030 | Brazil |
| 10293 | TORTU | 1 | 1996-08-29 | 1996-09-26 | 1996-09-11 | 3 | 21.18 | Tortuga Restaurante | Avda. Azteca 123 | México D.F. | NULL | 05033 | Mexico |
| 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 |
| 10295 | VINET | 2 | 1996-09-02 | 1996-09-30 | 1996-09-10 | 2 | 1.15 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 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 |
| 10297 | BLONP | 5 | 1996-09-04 | 1996-10-16 | 1996-09-10 | 2 | 5.74 | Blondel père et fils | 24, place Kléber | Strasbourg | NULL | 67000 | France |