{"@odata.context":"https://demodata.mescius.jp/northwind/odata/v1/$metadata#Customers(Orders(OrderDetails(),Shipper()))","value":[{"CustomerId":"1    ","CompanyName":"\u55ab\u8336\u305f\u3044\u3080\u307e\u3057\u3093","ContactName":"\u6797 \u5343\u6625","ContactTitle":"\u5e97\u9577","Address":"\u4f50\u8cc0\u5e02\u9577\u702c\u753a 23-XX","City":"\u4f50\u8cc0\u5e02","Region":null,"PostalCode":"840-0853","Country":"\u4f50\u8cc0\u770c","Phone":"(0952)26-64XX","Fax":null,"Orders":[{"OrderId":484,"CustomerId":"1    ","EmployeeId":6,"OrderDate":"1995-04-20","RequiredDate":"1995-05-18","ShippedDate":"1995-04-18","ShipVia":2,"Freight":1.3500,"ShipName":"\u55ab\u8336\u305f\u3044\u3080\u307e\u3057\u3093","ShipAddress":"\u4f50\u8cc0\u5e02\u9577\u702c\u753a 23-XX","ShipCity":"\u4f50\u8cc0\u5e02","ShipRegion":null,"ShipPostalCode":"840-0853","ShipCountry":"\u4f50\u8cc0\u770c","OrderDetails":[{"OrderId":484,"ProductId":23,"UnitPrice":100.0000,"Quantity":10,"Discount":0.2},{"OrderId":484,"ProductId":28,"UnitPrice":5.0000,"Quantity":10,"Discount":0.1},{"OrderId":484,"ProductId":58,"UnitPrice":10.0000,"Quantity":50,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"\u30c8\u30de\u30c8","Phone":"(03) 3681-31xx"}},{"OrderId":504,"CustomerId":"1    ","EmployeeId":8,"OrderDate":"1995-05-10","RequiredDate":"1995-06-07","ShippedDate":"1995-05-11","ShipVia":1,"Freight":42.6800,"ShipName":"\u55ab\u8336\u305f\u3044\u3080\u307e\u3057\u3093","ShipAddress":"\u4f50\u8cc0\u5e02\u9577\u702c\u753a 23-XX","ShipCity":"\u4f50\u8cc0\u5e02","ShipRegion":null,"ShipPostalCode":"840-0853","ShipCountry":"\u4f50\u8cc0\u770c","OrderDetails":[{"OrderId":504,"ProductId":19,"UnitPrice":50.0000,"Quantity":10,"Discount":0},{"OrderId":504,"ProductId":70,"UnitPrice":60.0000,"Quantity":100,"Discount":0},{"OrderId":504,"ProductId":78,"UnitPrice":10.0000,"Quantity":50,"Discount":0.2}],"Shipper":{"ShipperId":1,"CompanyName":"\u30a2\u30ab\u30cd\u30b3","Phone":"(03) 3955-98xx"}},{"OrderId":510,"CustomerId":"1    ","EmployeeId":9,"OrderDate":"1995-05-16","RequiredDate":"1995-06-13","ShippedDate":"1995-05-03","ShipVia":2,"Freight":21.1900,"ShipName":"\u55ab\u8336\u305f\u3044\u3080\u307e\u3057\u3093","ShipAddress":"\u4f50\u8cc0\u5e02\u9577\u702c\u753a 23-XX","ShipCity":"\u4f50\u8cc0\u5e02","ShipRegion":null,"ShipPostalCode":"840-0853","ShipCountry":"\u4f50\u8cc0\u770c","OrderDetails":[{"OrderId":510,"ProductId":24,"UnitPrice":20.0000,"Quantity":50,"Discount":0},{"OrderId":510,"ProductId":29,"UnitPrice":100.0000,"Quantity":50,"Discount":0},{"OrderId":510,"ProductId":56,"UnitPrice":200.0000,"Quantity":50,"Discount":0.5},{"OrderId":510,"ProductId":58,"UnitPrice":50.0000,"Quantity":50,"Discount":0.1}],"Shipper":{"ShipperId":2,"CompanyName":"\u30c8\u30de\u30c8","Phone":"(03) 3681-31xx"}}]},{"CustomerId":"10   ","CompanyName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ContactName":"\u6cb3\u672c \u306a\u307f","ContactTitle":"\u6599\u7406\u9577","Address":"\u90a3\u8987\u5e02\u7e41\u591a\u5ddd 1-21-XX","City":"\u90a3\u8987\u5e02","Region":null,"PostalCode":"902-0071","Country":"\u6c96\u7e04\u770c","Phone":"(0988)55-87XX","Fax":"(0988)55-87XX","Orders":[{"OrderId":288,"CustomerId":"10   ","EmployeeId":3,"OrderDate":"1994-08-26","RequiredDate":"1994-10-07","ShippedDate":"1994-08-31","ShipVia":3,"Freight":25.7300,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7fd2\u5fd7\u91ce\u5e02\u6d25\u7530\u6cbc 2-6-XX","ShipCity":"\u7fd2\u5fd7\u91ce\u5e02","ShipRegion":"\u6d25\u7530\u6cbc","ShipPostalCode":"275-0016","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":288,"ProductId":20,"UnitPrice":50.0000,"Quantity":500,"Discount":0.5},{"OrderId":288,"ProductId":28,"UnitPrice":50.0000,"Quantity":110,"Discount":0},{"OrderId":288,"ProductId":46,"UnitPrice":50.0000,"Quantity":100,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"\u30da\u30f3\u30ae\u30f3","Phone":"(03) 3566-99xx"}},{"OrderId":322,"CustomerId":"10   ","EmployeeId":4,"OrderDate":"1994-10-11","RequiredDate":"1994-11-08","ShippedDate":"1994-10-19","ShipVia":2,"Freight":6.2700,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7fd2\u5fd7\u91ce\u5e02\u6d25\u7530\u6cbc 2-6-XX","ShipCity":"\u7fd2\u5fd7\u91ce\u5e02","ShipRegion":null,"ShipPostalCode":"275-0016","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":322,"ProductId":29,"UnitPrice":100.0000,"Quantity":4,"Discount":0},{"OrderId":322,"ProductId":35,"UnitPrice":110.0000,"Quantity":4,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"\u30c8\u30de\u30c8","Phone":"(03) 3681-31xx"}},{"OrderId":359,"CustomerId":"10   ","EmployeeId":5,"OrderDate":"1994-12-01","RequiredDate":"1994-12-29","ShippedDate":"1994-11-29","ShipVia":1,"Freight":110.3700,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7fd2\u5fd7\u91ce\u5e02\u6d25\u7530\u6cbc 2-6-XX","ShipCity":"\u7fd2\u5fd7\u91ce\u5e02","ShipRegion":null,"ShipPostalCode":"275-0016","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":359,"ProductId":58,"UnitPrice":50.0000,"Quantity":1,"Discount":0},{"OrderId":359,"ProductId":74,"UnitPrice":50.0000,"Quantity":1,"Discount":0},{"OrderId":359,"ProductId":79,"UnitPrice":50.0000,"Quantity":1,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"\u30a2\u30ab\u30cd\u30b3","Phone":"(03) 3955-98xx"}},{"OrderId":409,"CustomerId":"10   ","EmployeeId":6,"OrderDate":"1995-01-26","RequiredDate":"1995-02-23","ShippedDate":"1995-01-20","ShipVia":1,"Freight":184.4100,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7fd2\u5fd7\u91ce\u5e02\u6d25\u7530\u6cbc 2-6-XX","ShipCity":"\u7fd2\u5fd7\u91ce\u5e02","ShipRegion":null,"ShipPostalCode":"275-0016","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":409,"ProductId":8,"UnitPrice":450.0000,"Quantity":5,"Discount":0},{"OrderId":409,"ProductId":24,"UnitPrice":10.0000,"Quantity":5,"Discount":0},{"OrderId":409,"ProductId":73,"UnitPrice":10.0000,"Quantity":5,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"\u30a2\u30ab\u30cd\u30b3","Phone":"(03) 3955-98xx"}},{"OrderId":444,"CustomerId":"10   ","EmployeeId":3,"OrderDate":"1995-03-06","RequiredDate":"1995-04-03","ShippedDate":"1995-03-03","ShipVia":3,"Freight":73.8300,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7fd2\u5fd7\u91ce\u5e02\u6d25\u7530\u6cbc 2-6-XX","ShipCity":"\u7fd2\u5fd7\u91ce\u5e02","ShipRegion":null,"ShipPostalCode":"275-0016","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":444,"ProductId":5,"UnitPrice":100.0000,"Quantity":5,"Discount":0},{"OrderId":444,"ProductId":22,"UnitPrice":100.0000,"Quantity":5,"Discount":0},{"OrderId":444,"ProductId":47,"UnitPrice":120.0000,"Quantity":5,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"\u30da\u30f3\u30ae\u30f3","Phone":"(03) 3566-99xx"}},{"OrderId":477,"CustomerId":"10   ","EmployeeId":1,"OrderDate":"1995-04-13","RequiredDate":"1995-04-27","ShippedDate":"1995-04-03","ShipVia":3,"Freight":16.3700,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7fd2\u5fd7\u91ce\u5e02\u6d25\u7530\u6cbc 2-6-XX","ShipCity":"\u7fd2\u5fd7\u91ce\u5e02","ShipRegion":null,"ShipPostalCode":"275-0016","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":477,"ProductId":4,"UnitPrice":100.0000,"Quantity":1000,"Discount":0.2},{"OrderId":477,"ProductId":24,"UnitPrice":90.0000,"Quantity":1000,"Discount":0.1}],"Shipper":{"ShipperId":3,"CompanyName":"\u30da\u30f3\u30ae\u30f3","Phone":"(03) 3566-99xx"}},{"OrderId":517,"CustomerId":"10   ","EmployeeId":7,"OrderDate":"1995-05-23","RequiredDate":"1995-07-04","ShippedDate":"1995-05-12","ShipVia":1,"Freight":105.6500,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7fd2\u5fd7\u91ce\u5e02\u6d25\u7530\u6cbc 2-6-XX","ShipCity":"\u7fd2\u5fd7\u91ce\u5e02","ShipRegion":null,"ShipPostalCode":"275-0016","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":517,"ProductId":1,"UnitPrice":198.0000,"Quantity":50,"Discount":0},{"OrderId":517,"ProductId":2,"UnitPrice":198.0000,"Quantity":50,"Discount":0},{"OrderId":517,"ProductId":3,"UnitPrice":198.0000,"Quantity":50,"Discount":0},{"OrderId":517,"ProductId":4,"UnitPrice":198.0000,"Quantity":50,"Discount":0},{"OrderId":517,"ProductId":51,"UnitPrice":150.0000,"Quantity":5000,"Discount":0},{"OrderId":517,"ProductId":52,"UnitPrice":100.0000,"Quantity":5000,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"\u30a2\u30ab\u30cd\u30b3","Phone":"(03) 3955-98xx"}},{"OrderId":525,"CustomerId":"10   ","EmployeeId":4,"OrderDate":"1995-05-31","RequiredDate":"1995-06-28","ShippedDate":"1995-05-17","ShipVia":1,"Freight":45.3300,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u7c95\u5c4b\u90e1\u5fd7\u514d\u753a\u5fa1\u624b\u6d17 51-X","ShipCity":"\u7c95\u5c4b\u90e1","ShipRegion":null,"ShipPostalCode":"811-2206","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":525,"ProductId":33,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":525,"ProductId":37,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":525,"ProductId":40,"UnitPrice":0.0000,"Quantity":1,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"\u30a2\u30ab\u30cd\u30b3","Phone":"(03) 3955-98xx"}},{"OrderId":551,"CustomerId":"10   ","EmployeeId":2,"OrderDate":"1995-06-29","RequiredDate":"1995-07-27","ShippedDate":"1995-06-09","ShipVia":1,"Freight":83.2200,"ShipName":"\u6771\u6d77\u9053\u30b9\u30fc\u30d1\u30fc","ShipAddress":"\u672d\u5e4c\u5e02\u8c4a\u5e73\u533a\u4e2d\u306e\u5cf6\u4e00\u67612\u4e01\u76ee 4-XX","ShipCity":"\u672d\u5e4c\u5e02","ShipRegion":null,"ShipPostalCode":"062-0921","ShipCountry":"\u5343\u8449\u770c","OrderDetails":[{"OrderId":551,"ProductId":60,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":551,"ProductId":61,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":551,"ProductId":76,"UnitPrice":0.0000,"Quantity":1,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"\u30a2\u30ab\u30cd\u30b3","Phone":"(03) 3955-98xx"}}]},{"CustomerId":"11   ","CompanyName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ContactName":"\u5c71\u4e45 \u826f\u7f8e","ContactTitle":"\u6599\u7406\u9577","Address":"\u5bcc\u5c71\u5e02\u671d\u83dc\u753a 2-702-XX","City":"\u5bcc\u5c71\u5e02","Region":null,"PostalCode":"939-8066","Country":"\u5bcc\u5c71\u770c","Phone":"(0764)25-58XX","Fax":"(0764)25-58XX","Orders":[{"OrderId":299,"CustomerId":"11   ","EmployeeId":8,"OrderDate":"1994-09-12","RequiredDate":"1994-10-10","ShippedDate":"1994-09-13","ShipVia":2,"Freight":92.6900,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u5927\u9928\u5e02\u91c8\u8fe6\u5185\u5b57\u9928 30-XX","ShipCity":"\u5927\u9928\u5e02","ShipRegion":null,"ShipPostalCode":"017-0012","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":299,"ProductId":18,"UnitPrice":250.0000,"Quantity":400,"Discount":0},{"OrderId":299,"ProductId":19,"UnitPrice":100.0000,"Quantity":400,"Discount":0},{"OrderId":299,"ProductId":54,"UnitPrice":250.0000,"Quantity":700,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"\u30c8\u30de\u30c8","Phone":"(03) 3681-31xx"}},{"OrderId":335,"CustomerId":"11   ","EmployeeId":6,"OrderDate":"1994-10-31","RequiredDate":"1994-11-28","ShippedDate":"1994-11-04","ShipVia":1,"Freight":12.6900,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u5927\u9928\u5e02\u91c8\u8fe6\u5185\u5b57\u9928 30-XX","ShipCity":"\u5927\u9928\u5e02","ShipRegion":null,"ShipPostalCode":"017-0012","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":335,"ProductId":4,"UnitPrice":240.0000,"Quantity":100,"Discount":0},{"OrderId":335,"ProductId":29,"UnitPrice":100.0000,"Quantity":100,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"\u30a2\u30ab\u30cd\u30b3","Phone":"(03) 3955-98xx"}},{"OrderId":353,"CustomerId":"11   ","EmployeeId":7,"OrderDate":"1994-11-23","RequiredDate":"1994-12-21","ShippedDate":"1994-11-21","ShipVia":2,"Freight":15.5100,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u5927\u9928\u5e02\u91c8\u8fe6\u5185\u5b57\u9928 30-XX","ShipCity":"\u5927\u9928\u5e02","ShipRegion":null,"ShipPostalCode":"017-0012","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":353,"ProductId":26,"UnitPrice":110.0000,"Quantity":1,"Discount":0},{"OrderId":353,"ProductId":47,"UnitPrice":100.0000,"Quantity":1,"Discount":0},{"OrderId":353,"ProductId":59,"UnitPrice":240.0000,"Quantity":1,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"\u30c8\u30de\u30c8","Phone":"(03) 3681-31xx"}},{"OrderId":397,"CustomerId":"11   ","EmployeeId":8,"OrderDate":"1995-01-16","RequiredDate":"1995-02-13","ShippedDate":"1995-01-09","ShipVia":3,"Freight":34.2400,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u5927\u9928\u5e02\u91c8\u8fe6\u5185\u5b57\u9928 30-XX","ShipCity":"\u5927\u9928\u5e02","ShipRegion":null,"ShipPostalCode":"017-0012","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":397,"ProductId":25,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":397,"ProductId":29,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":397,"ProductId":51,"UnitPrice":0.0000,"Quantity":1,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"\u30da\u30f3\u30ae\u30f3","Phone":"(03) 3566-99xx"}},{"OrderId":482,"CustomerId":"11   ","EmployeeId":2,"OrderDate":"1995-04-18","RequiredDate":"1995-05-02","ShippedDate":"1995-04-03","ShipVia":3,"Freight":4.8100,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u5927\u9928\u5e02\u91c8\u8fe6\u5185\u5b57\u9928 30-XX","ShipCity":"\u5927\u9928\u5e02","ShipRegion":null,"ShipPostalCode":"017-0012","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":482,"ProductId":52,"UnitPrice":250.0000,"Quantity":10,"Discount":0},{"OrderId":482,"ProductId":55,"UnitPrice":300.0000,"Quantity":10,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"\u30da\u30f3\u30ae\u30f3","Phone":"(03) 3566-99xx"}},{"OrderId":495,"CustomerId":"11   ","EmployeeId":8,"OrderDate":"1995-05-01","RequiredDate":"1995-05-29","ShippedDate":"1995-04-21","ShipVia":3,"Freight":16.9600,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u5927\u9928\u5e02\u91c8\u8fe6\u5185\u5b57\u9928 30-XX","ShipCity":"\u5927\u9928\u5e02","ShipRegion":null,"ShipPostalCode":"017-0012","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":495,"ProductId":38,"UnitPrice":80.0000,"Quantity":200,"Discount":0},{"OrderId":495,"ProductId":40,"UnitPrice":100.0000,"Quantity":100,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"\u30da\u30f3\u30ae\u30f3","Phone":"(03) 3566-99xx"}},{"OrderId":512,"CustomerId":"11   ","EmployeeId":1,"OrderDate":"1995-05-17","RequiredDate":"1995-06-14","ShippedDate":"1995-05-04","ShipVia":2,"Freight":4.9900,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u5927\u9928\u5e02\u91c8\u8fe6\u5185\u5b57\u9928 30-XX","ShipCity":"\u5927\u9928\u5e02","ShipRegion":null,"ShipPostalCode":"017-0012","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":512,"ProductId":2,"UnitPrice":110.0000,"Quantity":1,"Discount":0},{"OrderId":512,"ProductId":4,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":512,"ProductId":69,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":512,"ProductId":70,"UnitPrice":0.0000,"Quantity":1,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"\u30c8\u30de\u30c8","Phone":"(03) 3681-31xx"}},{"OrderId":535,"CustomerId":"11   ","EmployeeId":3,"OrderDate":"1995-06-14","RequiredDate":"1995-07-12","ShippedDate":"1995-05-29","ShipVia":2,"Freight":58.8800,"ShipName":"\u5c0f\u753a\u30b9\u30c8\u30a2\u30fc","ShipAddress":"\u591a\u8cc0\u57ce\u5e02\u7b20\u795e 3-2-X","ShipCity":"\u591a\u8cc0\u57ce\u5e02","ShipRegion":null,"ShipPostalCode":"985-0831","ShipCountry":"\u79cb\u7530\u770c","OrderDetails":[{"OrderId":535,"ProductId":75,"UnitPrice":0.0000,"Quantity":1,"Discount":0},{"OrderId":535,"ProductId":76,"UnitPrice":0.0000,"Quantity":1,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"\u30c8\u30de\u30c8","Phone":"(03) 3681-31xx"}}]}]}