HTML preprocessors can make writing HTML more powerful or convenient. For instance, Markdown is designed to be easier to write and read for text documents and you could write a loop in Pug.
In CodePen, whatever you write in the HTML editor is what goes within the <body>
tags in a basic HTML5 template. So you don't have access to higher-up elements like the <html>
tag. If you want to add classes there that can affect the whole document, this is the place to do it.
In CodePen, whatever you write in the HTML editor is what goes within the <body>
tags in a basic HTML5 template. If you need things in the <head>
of the document, put that code here.
The resource you are linking to is using the 'http' protocol, which may not work when the browser is using https.
CSS preprocessors help make authoring CSS easier. All of them offer things like variables and mixins to provide convenient abstractions.
It's a common practice to apply CSS to a page that styles elements such that they are consistent across all browsers. We offer two of the most popular choices: normalize.css and a reset. Or, choose Neither and nothing will be applied.
To get the best cross-browser support, it is a common practice to apply vendor prefixes to CSS properties and values that require them to work. For instance -webkit-
or -moz-
.
We offer two popular choices: Autoprefixer (which processes your CSS server-side) and -prefix-free (which applies prefixes via a script, client-side).
Any URLs added here will be added as <link>
s in order, and before the CSS in the editor. You can use the CSS from another Pen by using its URL and the proper URL extension.
You can apply CSS to your Pen from any stylesheet on the web. Just put a URL to it here and we'll apply it, in the order you have them, before the CSS in the Pen itself.
You can also link to another Pen here (use the .css
URL Extension) and we'll pull the CSS from that Pen and include it. If it's using a matching preprocessor, use the appropriate URL Extension and we'll combine the code before preprocessing, so you can use the linked Pen as a true dependency.
JavaScript preprocessors can help make authoring JavaScript easier and more convenient.
Babel includes JSX processing.
Any URL's added here will be added as <script>
s in order, and run before the JavaScript in the editor. You can use the URL of any other Pen and it will include the JavaScript from that Pen.
You can apply a script from anywhere on the web to your Pen. Just put a URL to it here and we'll add it, in the order you have them, before the JavaScript in the Pen itself.
If the script you link to has the file extension of a preprocessor, we'll attempt to process it before applying.
You can also link to another Pen here, and we'll pull the JavaScript from that Pen and include it. If it's using a matching preprocessor, we'll combine the code before preprocessing, so you can use the linked Pen as a true dependency.
Search for and use JavaScript packages from npm here. By selecting a package, an import
statement will be added to the top of the JavaScript editor for this package.
Using packages here is powered by esm.sh, which makes packages from npm not only available on a CDN, but prepares them for native JavaScript ESM usage.
All packages are different, so refer to their docs for how they work.
If you're using React / ReactDOM, make sure to turn on Babel for the JSX processing.
If active, Pens will autosave every 30 seconds after being saved once.
If enabled, the preview panel updates automatically as you code. If disabled, use the "Run" button to update.
If enabled, your code will be formatted when you actively save your Pen. Note: your code becomes un-folded during formatting.
Visit your global Editor Settings.
<link href="https://cdn.webdatarocks.com/latest/webdatarocks.min.css" rel="stylesheet"/>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.toolbar.min.js"></script>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.webdatarocks.com/latest/theme/teal/webdatarocks.min.css" />
<div id="wdr-component"></div>
#wdr-pivot-view a.wdr-ui-btn, #wdr-toolbar-wrapper a.wdr-ui-btn {
color: #fff !important;
}
#wdr-pivot-view a.wdr-ui-btn-light, #wdr-toolbar-wrapper {
color: #000000 !important;
}
#wdr-pivot-view a.wdr-ui-btn-light:hover, #wdr-toolbar-wrapper {
color: #000000 !important;
}
#wdr-pivot-view a.wdr-ui-btn:hover, #wdr-toolbar-wrapper a.wdr-ui-btn:hover {
color: #009688 !important;
}
#wdr-pivot-view a.wdr-ui-btn-light:hover, #wdr-toolbar-wrapper a.wdr-ui-btn-light:hover {
color: #000000 !important;
}
#wdr-pivot-view a.wdr-ui-btn-dark:hover, #wdr-toolbar-wrapper a.wdr-ui-btn-dark:hover {
color: #fff !important;
}
var pivot = new WebDataRocks({
container: "wdr-component",
width: "80%",
height: 770,
toolbar: true,
report: {
"dataSource": {
"data": getData()
},
"slice": {
"rows": [{
"uniqueName": "Location"
}],
"columns": [{
"uniqueName": "[Measures]"
},
{
"uniqueName": "Order Date"
}
],
"measures": [{
"uniqueName": "Sales",
"aggregation": "sum",
"format": "formatting"
}]
},
"conditions": [{
"formula": "#value <= 100000",
"measure": "Sales",
"format": {
"backgroundColor": "#FFFFFF",
"color": "#000000",
"fontFamily": "Tahoma",
"fontSize": "12px"
}
},
{
"formula": "AND(#value > 85000, #value < 60000)",
"measure": "Sales",
"format": {
"backgroundColor": "#FFFFFF",
"color": "#000000",
"fontFamily": "Tahoma",
"fontSize": "12px"
}
},
{
"formula": "AND(#value > 60000, #value < 145000)",
"measure": "Sales",
"format": {
"backgroundColor": "#9ddfd0",
"color": "#000000",
"fontFamily": "Tahoma",
"fontSize": "12px"
}
},
{
"formula": "AND(#value > 145000, #value < 230000)",
"measure": "Sales",
"format": {
"backgroundColor": "#F5E68B",
"color": "#000000",
"fontFamily": "Tahoma",
"fontSize": "12px"
}
},
{
"formula": "AND(#value > 230000, #value < 300001)",
"measure": "Sales",
"format": {
"backgroundColor": "#F5E68B",
"color": "#000000",
"fontFamily": "Tahoma",
"fontSize": "12px"
}
},
{
"formula": "AND(#value > 300000, #value < 500000)",
"measure": "Sales",
"format": {
"backgroundColor": "#6BB6A1",
"color": "#000000",
"fontFamily": "Tahoma",
"fontSize": "12px"
}
},
{
"formula": "#value >= 500000",
"measure": "Sales",
"format": {
"backgroundColor": "#6BB6A1",
"color": "#000000",
"fontFamily": "Tahoma",
"fontSize": "12px"
}
}
],
"formats": [{
"name": "formatting",
"thousandsSeparator": " ",
"decimalSeparator": ".",
"decimalPlaces": 2,
"currencySymbol": "",
"currencySymbolAlign": "left",
"nullValue": "",
"textAlign": "right",
"isPercent": false
}],
options: {
showDefaultSlice: false
}
}
});
function getData() {
return [{
"Quantity": {
"type": "number"
},
"Price": {
"type": "number"
},
"Order Line Number": {
"type": "number"
},
"Sales": {
"type": "number"
},
"Order Date": {
"type": "year/quarter/month/day"
},
"Status": {
"type": "string"
},
"Quarter ": {
"type": "number"
},
"Month": {
"type": "number"
},
"Year": {
"type": "number"
},
"Product Line": {
"type": "string"
},
"MSRP": {
"type": "number"
},
"Product Code": {
"type": "string"
},
"Customer Name": {
"type": "string"
},
"Phone": {
"type": "number"
},
"Address Line 1": {
"type": "level",
"hierarchy": "Location",
"parent": "City"
},
"Address Line 2": {
"type": "string"
},
"City": {
"type": "level",
"hierarchy": "Location",
"parent": "Country"
},
"State": {
"type": "string"
},
"Postal Code": {
"type": "level",
"hierarchy": "Location",
"parent": "Address Line 2"
},
"Country": {
"type": "level",
"hierarchy": "Location"
},
"Territory": {
"type": "level"
},
"Contact Last Name": {
"type": "string"
},
"Contact First Name": {
"type": "string"
},
"Deal Size": {
"type": "string"
}
},
{
"Order Number": 10413,
"Quantity": 49,
"Price": 100,
"Order Line Number": 5,
"Sales": 6896.75,
"Order Date": "5/5/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 143,
"Product Code": "S18_4027",
"Customer Name": "Gift Depot Inc.",
"Phone": 2035552570,
"Address Line 1": "25593 South Bay Ln.",
"Address Line 2": "",
"City": "Bridgewater",
"State": "CT",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10100,
"Quantity": 22,
"Price": 86.51,
"Order Line Number": 4,
"Sales": 1903.22,
"Order Date": "1/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Online Diecast Creations Co.",
"Phone": 6035558647,
"Address Line 1": "2304 Long Airport Avenue",
"Address Line 2": "",
"City": "Nashua",
"State": "NH",
"Postal Code": 62018,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Valarie",
"Deal Size": "Small"
}, {
"Order Number": 10107,
"Quantity": 30,
"Price": 95.7,
"Order Line Number": 2,
"Sales": 2871,
"Order Date": "2/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Small"
},
{
"Order Number": 10121,
"Quantity": 34,
"Price": 81.35,
"Order Line Number": 5,
"Sales": 2765.9,
"Order Date": "5/7/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Reims Collectables",
"Phone": "26.47.1555",
"Address Line 1": "59 rue de l'Abbaye",
"Address Line 2": "",
"City": "Reims",
"State": "",
"Postal Code": 51100,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Henriot",
"Contact First Name": "Paul",
"Deal Size": "Small"
},
{
"Order Number": 10134,
"Quantity": 41,
"Price": 94.74,
"Order Line Number": 2,
"Sales": 3884.34,
"Order Date": "7/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Lyon Souveniers",
"Phone": "+33 1 46 62 7555",
"Address Line 1": "27 rue du Colonel Pierre Avia",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75508,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Da Cunha",
"Contact First Name": "Daniel",
"Deal Size": "Medium"
},
{
"Order Number": 10145,
"Quantity": 45,
"Price": 83.26,
"Order Line Number": 6,
"Sales": 3746.7,
"Order Date": "8/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Toys4GrownUps.com",
"Phone": 6265557265,
"Address Line 1": "78934 Hillside Dr.",
"Address Line 2": "",
"City": "Pasadena",
"State": "CA",
"Postal Code": 90003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10159,
"Quantity": 49,
"Price": 100,
"Order Line Number": 14,
"Sales": 5205.27,
"Order Date": "10/10/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Corporate Gift Ideas Co.",
"Phone": 6505551386,
"Address Line 1": "7734 Strong St.",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10168,
"Quantity": 36,
"Price": 96.66,
"Order Line Number": 1,
"Sales": 3479.76,
"Order Date": "10/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Medium"
},
{
"Order Number": 10180,
"Quantity": 29,
"Price": 86.13,
"Order Line Number": 9,
"Sales": 2497.77,
"Order Date": "11/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Daedalus Designs Imports",
"Phone": "20.16.1555",
"Address Line 1": "184, chausse de Tournai",
"Address Line 2": "",
"City": "Lille",
"State": "",
"Postal Code": 59000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Rance",
"Contact First Name": "Martine",
"Deal Size": "Small"
},
{
"Order Number": 10188,
"Quantity": 48,
"Price": 100,
"Order Line Number": 1,
"Sales": 5512.32,
"Order Date": "11/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Herkku Gifts",
"Phone": "+47 2267 3215",
"Address Line 1": "Drammen 121, PR 744 Sentrum",
"Address Line 2": "",
"City": "Bergen",
"State": "",
"Postal Code": "N 5804",
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Oeztan",
"Contact First Name": "Veysel",
"Deal Size": "Medium"
},
{
"Order Number": 10201,
"Quantity": 22,
"Price": 98.57,
"Order Line Number": 2,
"Sales": 2168.54,
"Order Date": "12/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Mini Wheels Co.",
"Phone": 6505555787,
"Address Line 1": "5557 North Pendale Street",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Julie",
"Deal Size": "Small"
},
{
"Order Number": 10211,
"Quantity": 41,
"Price": 100,
"Order Line Number": 14,
"Sales": 4708.44,
"Order Date": "1/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Auto Canal Petit",
"Phone": "(1) 47.55.6555",
"Address Line 1": "25, rue Lauriston",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75016,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Perrier",
"Contact First Name": "Dominique",
"Deal Size": "Medium"
},
{
"Order Number": 10223,
"Quantity": 37,
"Price": 100,
"Order Line Number": 1,
"Sales": 3965.66,
"Order Date": "2/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Medium"
},
{
"Order Number": 10237,
"Quantity": 23,
"Price": 100,
"Order Line Number": 7,
"Sales": 2333.12,
"Order Date": "4/5/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Vitachrome Inc.",
"Phone": 2125551500,
"Address Line 1": "2678 Kingston Rd.",
"Address Line 2": "Suite 101",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Michael",
"Deal Size": "Small"
},
{
"Order Number": 10251,
"Quantity": 28,
"Price": 100,
"Order Line Number": 2,
"Sales": 3188.64,
"Order Date": "5/18/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Tekni Collectables Inc.",
"Phone": 2015559350,
"Address Line 1": "7476 Moss Rd.",
"Address Line 2": "",
"City": "Newark",
"State": "NJ",
"Postal Code": 94019,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "William",
"Deal Size": "Medium"
},
{
"Order Number": 10263,
"Quantity": 34,
"Price": 100,
"Order Line Number": 2,
"Sales": 3676.76,
"Order Date": "6/28/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Gift Depot Inc.",
"Phone": 2035552570,
"Address Line 1": "25593 South Bay Ln.",
"Address Line 2": "",
"City": "Bridgewater",
"State": "CT",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10275,
"Quantity": 45,
"Price": 92.83,
"Order Line Number": 1,
"Sales": 4177.35,
"Order Date": "7/23/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Medium"
},
{
"Order Number": 10285,
"Quantity": 36,
"Price": 100,
"Order Line Number": 6,
"Sales": 4099.68,
"Order Date": "8/27/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Marta's Replicas Co.",
"Phone": 6175558555,
"Address Line 1": "39323 Spinnaker Dr.",
"Address Line 2": "",
"City": "Cambridge",
"State": "MA",
"Postal Code": 51247,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Marta",
"Deal Size": "Medium"
},
{
"Order Number": 10299,
"Quantity": 23,
"Price": 100,
"Order Line Number": 9,
"Sales": 2597.39,
"Order Date": "9/30/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Toys of Finland, Co.",
"Phone": "90-224 8555",
"Address Line 1": "Keskuskatu 45",
"Address Line 2": "",
"City": "Helsinki",
"State": "",
"Postal Code": 21240,
"Country": "Finland",
"Territory": "EMEA",
"Contact Last Name": "Karttunen",
"Contact First Name": "Matti",
"Deal Size": "Small"
},
{
"Order Number": 10309,
"Quantity": 41,
"Price": 100,
"Order Line Number": 5,
"Sales": 4394.38,
"Order Date": "10/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Baane Mini Imports",
"Phone": "07-98 9555",
"Address Line 1": "Erling Skakkes gate 78",
"Address Line 2": "",
"City": "Stavern",
"State": "",
"Postal Code": 4110,
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Bergulfsen",
"Contact First Name": "Jonas",
"Deal Size": "Medium"
},
{
"Order Number": 10318,
"Quantity": 46,
"Price": 94.74,
"Order Line Number": 1,
"Sales": 4358.04,
"Order Date": "11/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Diecast Classics Inc.",
"Phone": 2155551555,
"Address Line 1": "7586 Pompton St.",
"Address Line 2": "",
"City": "Allentown",
"State": "PA",
"Postal Code": 70267,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kyung",
"Deal Size": "Medium"
},
{
"Order Number": 10329,
"Quantity": 42,
"Price": 100,
"Order Line Number": 1,
"Sales": 4396.14,
"Order Date": "11/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Medium"
},
{
"Order Number": 10341,
"Quantity": 41,
"Price": 100,
"Order Line Number": 9,
"Sales": 7737.93,
"Order Date": "11/24/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Salzburg Collectables",
"Phone": "6562-9555",
"Address Line 1": "Geislweg 14",
"Address Line 2": "",
"City": "Salzburg",
"State": "",
"Postal Code": 5020,
"Country": "Austria",
"Territory": "EMEA",
"Contact Last Name": "Pipps",
"Contact First Name": "Georg",
"Deal Size": "Large"
},
{
"Order Number": 10361,
"Quantity": 20,
"Price": 72.55,
"Order Line Number": 13,
"Sales": 1451,
"Order Date": "12/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Small"
},
{
"Order Number": 10375,
"Quantity": 21,
"Price": 34.91,
"Order Line Number": 12,
"Sales": 733.11,
"Order Date": "2/3/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Small"
},
{
"Order Number": 10388,
"Quantity": 42,
"Price": 76.36,
"Order Line Number": 4,
"Sales": 3207.12,
"Order Date": "3/3/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "FunGiftIdeas.com",
"Phone": 5085552555,
"Address Line 1": "1785 First Street",
"Address Line 2": "",
"City": "New Bedford",
"State": "MA",
"Postal Code": 50553,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Benitez",
"Contact First Name": "Violeta",
"Deal Size": "Medium"
},
{
"Order Number": 10403,
"Quantity": 24,
"Price": 100,
"Order Line Number": 7,
"Sales": 2434.56,
"Order Date": "4/8/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "UK Collectables, Ltd.",
"Phone": "(171) 555-2282",
"Address Line 1": "Berkeley Gardens 12 Brewery",
"Address Line 2": "",
"City": "Liverpool",
"State": "",
"Postal Code": "WX1 6LT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Devon",
"Contact First Name": "Elizabeth",
"Deal Size": "Small"
},
{
"Order Number": 10417,
"Quantity": 66,
"Price": 100,
"Order Line Number": 2,
"Sales": 7516.08,
"Order Date": "5/13/2018 0:00",
"Status": "Disputed",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 95,
"Product Code": "S10_1678",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Large"
},
{
"Order Number": 10103,
"Quantity": 26,
"Price": 100,
"Order Line Number": 11,
"Sales": 5404.62,
"Order Date": "1/29/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Baane Mini Imports",
"Phone": "07-98 9555",
"Address Line 1": "Erling Skakkes gate 78",
"Address Line 2": "",
"City": "Stavern",
"State": "",
"Postal Code": 4110,
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Bergulfsen",
"Contact First Name": "Jonas",
"Deal Size": "Medium"
},
{
"Order Number": 10112,
"Quantity": 29,
"Price": 100,
"Order Line Number": 1,
"Sales": 7209.11,
"Order Date": "3/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Volvo Model Replicas, Co",
"Phone": "0921-12 3555",
"Address Line 1": "Berguvsv�gen 8",
"Address Line 2": "",
"City": "Lule",
"State": "",
"Postal Code": "S-958 22",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Berglund",
"Contact First Name": "Christina",
"Deal Size": "Large"
},
{
"Order Number": 10126,
"Quantity": 38,
"Price": 100,
"Order Line Number": 11,
"Sales": 7329.06,
"Order Date": "5/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Corrida Auto Replicas, Ltd",
"Phone": "(91) 555 22 82",
"Address Line 1": "C/ Araquil, 67",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28023,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Sommer",
"Contact First Name": "Mart�n",
"Deal Size": "Large"
},
{
"Order Number": 10140,
"Quantity": 37,
"Price": 100,
"Order Line Number": 11,
"Sales": 7374.1,
"Order Date": "7/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Large"
},
{
"Order Number": 10150,
"Quantity": 45,
"Price": 100,
"Order Line Number": 8,
"Sales": 10993.5,
"Order Date": "9/19/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Dragon Souveniers, Ltd.",
"Phone": "+65 221 7555",
"Address Line 1": "Bronz Sok., Bronz Apt. 3/6 Tesvikiye",
"Address Line 2": "",
"City": "Singapore",
"State": "",
"Postal Code": 79903,
"Country": "Singapore",
"Territory": "Japan",
"Contact Last Name": "Natividad",
"Contact First Name": "Eric",
"Deal Size": "Large"
},
{
"Order Number": 10163,
"Quantity": 21,
"Price": 100,
"Order Line Number": 1,
"Sales": 4860.24,
"Order Date": "10/20/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Classic Legends Inc.",
"Phone": 2125558493,
"Address Line 1": "5905 Pompton St.",
"Address Line 2": "Suite 750",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Maria",
"Deal Size": "Medium"
},
{
"Order Number": 10174,
"Quantity": 34,
"Price": 100,
"Order Line Number": 4,
"Sales": 8014.82,
"Order Date": "11/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Australian Gift Network, Co",
"Phone": "61-7-3844-6555",
"Address Line 1": "31 Duncan St. West End",
"Address Line 2": "",
"City": "South Brisbane",
"State": "Queensland",
"Postal Code": 4101,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Calaghan",
"Contact First Name": "Tony",
"Deal Size": "Large"
},
{
"Order Number": 10183,
"Quantity": 23,
"Price": 100,
"Order Line Number": 8,
"Sales": 5372.57,
"Order Date": "11/13/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Classic Gift Ideas, Inc",
"Phone": 2155554695,
"Address Line 1": "782 First Street",
"Address Line 2": "",
"City": "Philadelphia",
"State": "PA",
"Postal Code": 71270,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Cervantes",
"Contact First Name": "Francisca",
"Deal Size": "Medium"
},
{
"Order Number": 10194,
"Quantity": 42,
"Price": 100,
"Order Line Number": 11,
"Sales": 7290.36,
"Order Date": "11/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Saveley & Henriot, Co.",
"Phone": "78.32.5555",
"Address Line 1": "2, rue du Commerce",
"Address Line 2": "",
"City": "Lyon",
"State": "",
"Postal Code": 69004,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Saveley",
"Contact First Name": "Mary",
"Deal Size": "Large"
},
{
"Order Number": 10206,
"Quantity": 47,
"Price": 100,
"Order Line Number": 6,
"Sales": 9064.89,
"Order Date": "12/5/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Canadian Gift Exchange Network",
"Phone": "(604) 555-3392",
"Address Line 1": "1900 Oak St.",
"Address Line 2": "",
"City": "Vancouver",
"State": "BC",
"Postal Code": "V3F 2K1",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Tannamuri",
"Contact First Name": "Yoshi",
"Deal Size": "Large"
},
{
"Order Number": 10215,
"Quantity": 35,
"Price": 100,
"Order Line Number": 3,
"Sales": 6075.3,
"Order Date": "1/29/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "West Coast Collectables Co.",
"Phone": 3105553722,
"Address Line 1": "3675 Furth Circle",
"Address Line 2": "",
"City": "Burbank",
"State": "CA",
"Postal Code": 94019,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Thompson",
"Contact First Name": "Steve",
"Deal Size": "Medium"
},
{
"Order Number": 10228,
"Quantity": 29,
"Price": 100,
"Order Line Number": 2,
"Sales": 6463.23,
"Order Date": "3/10/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Cambridge Collectables Co.",
"Phone": 6175555555,
"Address Line 1": "4658 Baden Av.",
"Address Line 2": "",
"City": "Cambridge",
"State": "MA",
"Postal Code": 51247,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Tseng",
"Contact First Name": "Kyung",
"Deal Size": "Medium"
},
{
"Order Number": 10245,
"Quantity": 34,
"Price": 100,
"Order Line Number": 9,
"Sales": 6120.34,
"Order Date": "5/4/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Super Scale Inc.",
"Phone": 2035559545,
"Address Line 1": "567 North Pendale Street",
"Address Line 2": "",
"City": "New Haven",
"State": "CT",
"Postal Code": 97823,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Leslie",
"Deal Size": "Medium"
},
{
"Order Number": 10258,
"Quantity": 32,
"Price": 100,
"Order Line Number": 6,
"Sales": 7680.64,
"Order Date": "6/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Tokyo Collectables, Ltd",
"Phone": "+81 3 3584 0555",
"Address Line 1": "2-2-8 Roppongi",
"Address Line 2": "",
"City": "Minato-ku",
"State": "Tokyo",
"Postal Code": "106-0032",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Shimamura",
"Contact First Name": "Akiko",
"Deal Size": "Large"
},
{
"Order Number": 10270,
"Quantity": 21,
"Price": 100,
"Order Line Number": 9,
"Sales": 4905.39,
"Order Date": "7/19/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Medium"
},
{
"Order Number": 10280,
"Quantity": 34,
"Price": 100,
"Order Line Number": 2,
"Sales": 8014.82,
"Order Date": "8/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Amica Models & Co.",
"Phone": "011-4988555",
"Address Line 1": "Via Monte Bianco 34",
"Address Line 2": "",
"City": "Torino",
"State": "",
"Postal Code": 10100,
"Country": "Italy",
"Territory": "EMEA",
"Contact Last Name": "Accorti",
"Contact First Name": "Paolo",
"Deal Size": "Large"
},
{
"Order Number": 10291,
"Quantity": 37,
"Price": 100,
"Order Line Number": 11,
"Sales": 7136.19,
"Order Date": "9/8/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Scandinavian Gift Ideas",
"Phone": "0695-34 6555",
"Address Line 1": "?kergatan 24",
"Address Line 2": "",
"City": "Boras",
"State": "",
"Postal Code": "S-844 67",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Larsson",
"Contact First Name": "Maria",
"Deal Size": "Large"
},
{
"Order Number": 10304,
"Quantity": 47,
"Price": 100,
"Order Line Number": 6,
"Sales": 10172.7,
"Order Date": "10/11/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Auto Assoc. & Cie.",
"Phone": "30.59.8555",
"Address Line 1": "67, avenue de l'Europe",
"Address Line 2": "",
"City": "Versailles",
"State": "",
"Postal Code": 78000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Tonini",
"Contact First Name": "Daniel",
"Deal Size": "Large"
},
{
"Order Number": 10312,
"Quantity": 48,
"Price": 100,
"Order Line Number": 3,
"Sales": 11623.7,
"Order Date": "10/21/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Large"
},
{
"Order Number": 10322,
"Quantity": 40,
"Price": 100,
"Order Line Number": 1,
"Sales": 6000.4,
"Order Date": "11/4/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Online Diecast Creations Co.",
"Phone": 6035558647,
"Address Line 1": "2304 Long Airport Avenue",
"Address Line 2": "",
"City": "Nashua",
"State": "NH",
"Postal Code": 62018,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10333,
"Quantity": 26,
"Price": 100,
"Order Line Number": 3,
"Sales": 3003,
"Order Date": "11/18/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Mini Wheels Co.",
"Phone": 6505555787,
"Address Line 1": "5557 North Pendale Street",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10347,
"Quantity": 30,
"Price": 100,
"Order Line Number": 1,
"Sales": 3944.7,
"Order Date": "11/29/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Medium"
},
{
"Order Number": 10357,
"Quantity": 32,
"Price": 100,
"Order Line Number": 10,
"Sales": 5691.84,
"Order Date": "12/10/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10369,
"Quantity": 41,
"Price": 100,
"Order Line Number": 2,
"Sales": 4514.92,
"Order Date": "1/20/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Collectables For Less Inc.",
"Phone": 6175558555,
"Address Line 1": "7825 Douglas Av.",
"Address Line 2": "",
"City": "Brickhaven",
"State": "MA",
"Postal Code": 58339,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Allen",
"Deal Size": "Medium"
},
{
"Order Number": 10381,
"Quantity": 36,
"Price": 100,
"Order Line Number": 3,
"Sales": 8254.8,
"Order Date": "2/17/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Corporate Gift Ideas Co.",
"Phone": 6505551386,
"Address Line 1": "7734 Strong St.",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "Julie",
"Deal Size": "Large"
},
{
"Order Number": 10391,
"Quantity": 24,
"Price": 100,
"Order Line Number": 4,
"Sales": 2416.56,
"Order Date": "3/9/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Small"
},
{
"Order Number": 10411,
"Quantity": 23,
"Price": 100,
"Order Line Number": 9,
"Sales": 4140.23,
"Order Date": "5/1/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Quebec Home Shopping Network",
"Phone": "(514) 555-8054",
"Address Line 1": "43 rue St. Laurent",
"Address Line 2": "",
"City": "Montreal",
"State": "Quebec",
"Postal Code": "H1J 1C3",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Fresnisre",
"Contact First Name": "Jean",
"Deal Size": "Medium"
},
{
"Order Number": 10424,
"Quantity": 50,
"Price": 100,
"Order Line Number": 6,
"Sales": 12001,
"Order Date": "5/31/2018 0:00",
"Status": "In Process",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 214,
"Product Code": "S10_1949",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Large"
},
{
"Order Number": 10107,
"Quantity": 39,
"Price": 99.91,
"Order Line Number": 5,
"Sales": 3896.49,
"Order Date": "2/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Medium"
},
{
"Order Number": 10120,
"Quantity": 29,
"Price": 96.34,
"Order Line Number": 3,
"Sales": 2793.86,
"Order Date": "4/29/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Small"
},
{
"Order Number": 10134,
"Quantity": 27,
"Price": 100,
"Order Line Number": 5,
"Sales": 3307.77,
"Order Date": "7/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Lyon Souveniers",
"Phone": "+33 1 46 62 7555",
"Address Line 1": "27 rue du Colonel Pierre Avia",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75508,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Da Cunha",
"Contact First Name": "Daniel",
"Deal Size": "Medium"
},
{
"Order Number": 10145,
"Quantity": 37,
"Price": 100,
"Order Line Number": 9,
"Sales": 5192.95,
"Order Date": "8/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Toys4GrownUps.com",
"Phone": 6265557265,
"Address Line 1": "78934 Hillside Dr.",
"Address Line 2": "",
"City": "Pasadena",
"State": "CA",
"Postal Code": 90003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10159,
"Quantity": 37,
"Price": 100,
"Order Line Number": 17,
"Sales": 5016.83,
"Order Date": "10/10/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Corporate Gift Ideas Co.",
"Phone": 6505551386,
"Address Line 1": "7734 Strong St.",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10168,
"Quantity": 27,
"Price": 100,
"Order Line Number": 4,
"Sales": 3660.93,
"Order Date": "10/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Medium"
},
{
"Order Number": 10180,
"Quantity": 42,
"Price": 100,
"Order Line Number": 12,
"Sales": 4695.6,
"Order Date": "11/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Daedalus Designs Imports",
"Phone": "20.16.1555",
"Address Line 1": "184, chausse de Tournai",
"Address Line 2": "",
"City": "Lille",
"State": "",
"Postal Code": 59000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Rance",
"Contact First Name": "Martine",
"Deal Size": "Medium"
},
{
"Order Number": 10188,
"Quantity": 38,
"Price": 96.34,
"Order Line Number": 4,
"Sales": 3660.92,
"Order Date": "11/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Herkku Gifts",
"Phone": "+47 2267 3215",
"Address Line 1": "Drammen 121, PR 744 Sentrum",
"Address Line 2": "",
"City": "Bergen",
"State": "",
"Postal Code": "N 5804",
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Oeztan",
"Contact First Name": "Veysel",
"Deal Size": "Medium"
},
{
"Order Number": 10201,
"Quantity": 24,
"Price": 100,
"Order Line Number": 5,
"Sales": 3025.92,
"Order Date": "12/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Mini Wheels Co.",
"Phone": 6505555787,
"Address Line 1": "5557 North Pendale Street",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10210,
"Quantity": 23,
"Price": 100,
"Order Line Number": 2,
"Sales": 3009.09,
"Order Date": "1/12/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Osaka Souveniers Co.",
"Phone": "+81 06 6342 5555",
"Address Line 1": "Dojima Avanza 4F, 1-6-20 Dojima, Kita-ku",
"Address Line 2": "",
"City": "Osaka",
"State": "Osaka",
"Postal Code": "530-0003",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Kentary",
"Contact First Name": "Mory",
"Deal Size": "Medium"
},
{
"Order Number": 10223,
"Quantity": 47,
"Price": 100,
"Order Line Number": 4,
"Sales": 5422.39,
"Order Date": "2/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Medium"
},
{
"Order Number": 10236,
"Quantity": 22,
"Price": 100,
"Order Line Number": 1,
"Sales": 2852.08,
"Order Date": "4/3/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Motor Mint Distributors Inc.",
"Phone": 2155559857,
"Address Line 1": "11328 Douglas Av.",
"Address Line 2": "",
"City": "Philadelphia",
"State": "PA",
"Postal Code": 71270,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Rosa",
"Deal Size": "Small"
},
{
"Order Number": 10251,
"Quantity": 44,
"Price": 100,
"Order Line Number": 5,
"Sales": 5756.52,
"Order Date": "5/18/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Tekni Collectables Inc.",
"Phone": 2015559350,
"Address Line 1": "7476 Moss Rd.",
"Address Line 2": "",
"City": "Newark",
"State": "NJ",
"Postal Code": 94019,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "William",
"Deal Size": "Medium"
},
{
"Order Number": 10263,
"Quantity": 40,
"Price": 100,
"Order Line Number": 5,
"Sales": 4472,
"Order Date": "6/28/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Gift Depot Inc.",
"Phone": 2035552570,
"Address Line 1": "25593 South Bay Ln.",
"Address Line 2": "",
"City": "Bridgewater",
"State": "CT",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10275,
"Quantity": 22,
"Price": 100,
"Order Line Number": 4,
"Sales": 2904.44,
"Order Date": "7/23/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Small"
},
{
"Order Number": 10285,
"Quantity": 47,
"Price": 100,
"Order Line Number": 9,
"Sales": 6484.59,
"Order Date": "8/27/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Marta's Replicas Co.",
"Phone": 6175558555,
"Address Line 1": "39323 Spinnaker Dr.",
"Address Line 2": "",
"City": "Cambridge",
"State": "MA",
"Postal Code": 51247,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Marta",
"Deal Size": "Medium"
},
{
"Order Number": 10298,
"Quantity": 39,
"Price": 96.34,
"Order Line Number": 1,
"Sales": 3757.26,
"Order Date": "9/27/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Atelier graphique",
"Phone": "40.32.2555",
"Address Line 1": "54, rue Royale",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Schmitt",
"Contact First Name": "Carine",
"Deal Size": "Medium"
},
{
"Order Number": 10308,
"Quantity": 34,
"Price": 100,
"Order Line Number": 2,
"Sales": 4043.96,
"Order Date": "10/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Mini Classics",
"Phone": 9145554562,
"Address Line 1": "3758 North Pendale Street",
"Address Line 2": "",
"City": "White Plains",
"State": "NY",
"Postal Code": 24067,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Steve",
"Deal Size": "Medium"
},
{
"Order Number": 10318,
"Quantity": 45,
"Price": 100,
"Order Line Number": 4,
"Sales": 5566.5,
"Order Date": "11/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Diecast Classics Inc.",
"Phone": 2155551555,
"Address Line 1": "7586 Pompton St.",
"Address Line 2": "",
"City": "Allentown",
"State": "PA",
"Postal Code": 70267,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kyung",
"Deal Size": "Medium"
},
{
"Order Number": 10329,
"Quantity": 20,
"Price": 100,
"Order Line Number": 2,
"Sales": 3176,
"Order Date": "11/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Medium"
},
{
"Order Number": 10339,
"Quantity": 40,
"Price": 68.92,
"Order Line Number": 4,
"Sales": 2756.8,
"Order Date": "11/23/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Tokyo Collectables, Ltd",
"Phone": "+81 3 3584 0555",
"Address Line 1": "2-2-8 Roppongi",
"Address Line 2": "",
"City": "Minato-ku",
"State": "Tokyo",
"Postal Code": "106-0032",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Shimamura",
"Contact First Name": "Akiko",
"Deal Size": "Small"
},
{
"Order Number": 10361,
"Quantity": 26,
"Price": 51.15,
"Order Line Number": 8,
"Sales": 1329.9,
"Order Date": "12/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Small"
},
{
"Order Number": 10374,
"Quantity": 39,
"Price": 100,
"Order Line Number": 5,
"Sales": 5288.01,
"Order Date": "2/2/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Australian Gift Network, Co",
"Phone": "61-7-3844-6555",
"Address Line 1": "31 Duncan St. West End",
"Address Line 2": "",
"City": "South Brisbane",
"State": "Queensland",
"Postal Code": 4101,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Calaghan",
"Contact First Name": "Tony",
"Deal Size": "Medium"
},
{
"Order Number": 10388,
"Quantity": 50,
"Price": 44.51,
"Order Line Number": 5,
"Sales": 2225.5,
"Order Date": "3/3/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "FunGiftIdeas.com",
"Phone": 5085552555,
"Address Line 1": "1785 First Street",
"Address Line 2": "",
"City": "New Bedford",
"State": "MA",
"Postal Code": 50553,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Benitez",
"Contact First Name": "Violeta",
"Deal Size": "Small"
},
{
"Order Number": 10402,
"Quantity": 45,
"Price": 100,
"Order Line Number": 1,
"Sales": 5833.8,
"Order Date": "4/7/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Auto Canal Petit",
"Phone": "(1) 47.55.6555",
"Address Line 1": "25, rue Lauriston",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75016,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Perrier",
"Contact First Name": "Dominique",
"Deal Size": "Medium"
},
{
"Order Number": 10417,
"Quantity": 45,
"Price": 100,
"Order Line Number": 5,
"Sales": 5887.35,
"Order Date": "5/13/2018 0:00",
"Status": "Disputed",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 118,
"Product Code": "S10_2016",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10107,
"Quantity": 27,
"Price": 100,
"Order Line Number": 4,
"Sales": 6065.55,
"Order Date": "2/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Medium"
},
{
"Order Number": 10120,
"Quantity": 46,
"Price": 100,
"Order Line Number": 2,
"Sales": 9264.86,
"Order Date": "4/29/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Large"
},
{
"Order Number": 10134,
"Quantity": 31,
"Price": 100,
"Order Line Number": 4,
"Sales": 7023.98,
"Order Date": "7/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Lyon Souveniers",
"Phone": "+33 1 46 62 7555",
"Address Line 1": "27 rue du Colonel Pierre Avia",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75508,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Da Cunha",
"Contact First Name": "Daniel",
"Deal Size": "Large"
},
{
"Order Number": 10145,
"Quantity": 33,
"Price": 100,
"Order Line Number": 8,
"Sales": 5176.38,
"Order Date": "8/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Toys4GrownUps.com",
"Phone": 6265557265,
"Address Line 1": "78934 Hillside Dr.",
"Address Line 2": "",
"City": "Pasadena",
"State": "CA",
"Postal Code": 90003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10159,
"Quantity": 22,
"Price": 100,
"Order Line Number": 16,
"Sales": 4132.7,
"Order Date": "10/10/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Corporate Gift Ideas Co.",
"Phone": 6505551386,
"Address Line 1": "7734 Strong St.",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10168,
"Quantity": 20,
"Price": 100,
"Order Line Number": 3,
"Sales": 4183,
"Order Date": "10/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Medium"
},
{
"Order Number": 10180,
"Quantity": 41,
"Price": 100,
"Order Line Number": 11,
"Sales": 8892.9,
"Order Date": "11/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Daedalus Designs Imports",
"Phone": "20.16.1555",
"Address Line 1": "184, chausse de Tournai",
"Address Line 2": "",
"City": "Lille",
"State": "",
"Postal Code": 59000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Rance",
"Contact First Name": "Martine",
"Deal Size": "Large"
},
{
"Order Number": 10188,
"Quantity": 45,
"Price": 100,
"Order Line Number": 3,
"Sales": 8714.7,
"Order Date": "11/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Herkku Gifts",
"Phone": "+47 2267 3215",
"Address Line 1": "Drammen 121, PR 744 Sentrum",
"Address Line 2": "",
"City": "Bergen",
"State": "",
"Postal Code": "N 5804",
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Oeztan",
"Contact First Name": "Veysel",
"Deal Size": "Large"
},
{
"Order Number": 10201,
"Quantity": 49,
"Price": 100,
"Order Line Number": 4,
"Sales": 8065.89,
"Order Date": "12/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Mini Wheels Co.",
"Phone": 6505555787,
"Address Line 1": "5557 North Pendale Street",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Julie",
"Deal Size": "Large"
},
{
"Order Number": 10210,
"Quantity": 34,
"Price": 100,
"Order Line Number": 1,
"Sales": 6123.4,
"Order Date": "1/12/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Osaka Souveniers Co.",
"Phone": "+81 06 6342 5555",
"Address Line 1": "Dojima Avanza 4F, 1-6-20 Dojima, Kita-ku",
"Address Line 2": "",
"City": "Osaka",
"State": "Osaka",
"Postal Code": "530-0003",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Kentary",
"Contact First Name": "Mory",
"Deal Size": "Medium"
},
{
"Order Number": 10223,
"Quantity": 49,
"Price": 100,
"Order Line Number": 3,
"Sales": 9774.03,
"Order Date": "2/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Large"
},
{
"Order Number": 10237,
"Quantity": 39,
"Price": 100,
"Order Line Number": 9,
"Sales": 7023.9,
"Order Date": "4/5/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Vitachrome Inc.",
"Phone": 2125551500,
"Address Line 1": "2678 Kingston Rd.",
"Address Line 2": "Suite 101",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Michael",
"Deal Size": "Large"
},
{
"Order Number": 10251,
"Quantity": 43,
"Price": 100,
"Order Line Number": 4,
"Sales": 7078.23,
"Order Date": "5/18/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Tekni Collectables Inc.",
"Phone": 2015559350,
"Address Line 1": "7476 Moss Rd.",
"Address Line 2": "",
"City": "Newark",
"State": "NJ",
"Postal Code": 94019,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "William",
"Deal Size": "Large"
},
{
"Order Number": 10263,
"Quantity": 41,
"Price": 100,
"Order Line Number": 4,
"Sales": 8336.94,
"Order Date": "6/28/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Gift Depot Inc.",
"Phone": 2035552570,
"Address Line 1": "25593 South Bay Ln.",
"Address Line 2": "",
"City": "Bridgewater",
"State": "CT",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Julie",
"Deal Size": "Large"
},
{
"Order Number": 10275,
"Quantity": 36,
"Price": 100,
"Order Line Number": 3,
"Sales": 6901.92,
"Order Date": "7/23/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Medium"
},
{
"Order Number": 10285,
"Quantity": 27,
"Price": 100,
"Order Line Number": 8,
"Sales": 5438.07,
"Order Date": "8/27/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Marta's Replicas Co.",
"Phone": 6175558555,
"Address Line 1": "39323 Spinnaker Dr.",
"Address Line 2": "",
"City": "Cambridge",
"State": "MA",
"Postal Code": 51247,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Marta",
"Deal Size": "Medium"
},
{
"Order Number": 10299,
"Quantity": 29,
"Price": 100,
"Order Line Number": 11,
"Sales": 6683.34,
"Order Date": "9/30/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Toys of Finland, Co.",
"Phone": "90-224 8555",
"Address Line 1": "Keskuskatu 45",
"Address Line 2": "",
"City": "Helsinki",
"State": "",
"Postal Code": 21240,
"Country": "Finland",
"Territory": "EMEA",
"Contact Last Name": "Karttunen",
"Contact First Name": "Matti",
"Deal Size": "Medium"
},
{
"Order Number": 10308,
"Quantity": 20,
"Price": 100,
"Order Line Number": 1,
"Sales": 4570.4,
"Order Date": "10/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Mini Classics",
"Phone": 9145554562,
"Address Line 1": "3758 North Pendale Street",
"Address Line 2": "",
"City": "White Plains",
"State": "NY",
"Postal Code": 24067,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Steve",
"Deal Size": "Medium"
},
{
"Order Number": 10318,
"Quantity": 37,
"Price": 100,
"Order Line Number": 3,
"Sales": 7667.14,
"Order Date": "11/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Diecast Classics Inc.",
"Phone": 2155551555,
"Address Line 1": "7586 Pompton St.",
"Address Line 2": "",
"City": "Allentown",
"State": "PA",
"Postal Code": 70267,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kyung",
"Deal Size": "Large"
},
{
"Order Number": 10329,
"Quantity": 26,
"Price": 100,
"Order Line Number": 3,
"Sales": 5868.2,
"Order Date": "11/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Medium"
},
{
"Order Number": 10339,
"Quantity": 39,
"Price": 76.67,
"Order Line Number": 3,
"Sales": 2990.13,
"Order Date": "11/23/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Tokyo Collectables, Ltd",
"Phone": "+81 3 3584 0555",
"Address Line 1": "2-2-8 Roppongi",
"Address Line 2": "",
"City": "Minato-ku",
"State": "Tokyo",
"Postal Code": "106-0032",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Shimamura",
"Contact First Name": "Akiko",
"Deal Size": "Small"
},
{
"Order Number": 10362,
"Quantity": 22,
"Price": 100,
"Order Line Number": 4,
"Sales": 3664.1,
"Order Date": "1/5/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Medium"
},
{
"Order Number": 10374,
"Quantity": 22,
"Price": 100,
"Order Line Number": 1,
"Sales": 3834.38,
"Order Date": "2/2/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Australian Gift Network, Co",
"Phone": "61-7-3844-6555",
"Address Line 1": "31 Duncan St. West End",
"Address Line 2": "",
"City": "South Brisbane",
"State": "Queensland",
"Postal Code": 4101,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Calaghan",
"Contact First Name": "Tony",
"Deal Size": "Medium"
},
{
"Order Number": 10388,
"Quantity": 21,
"Price": 86.77,
"Order Line Number": 7,
"Sales": 1822.17,
"Order Date": "3/3/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "FunGiftIdeas.com",
"Phone": 5085552555,
"Address Line 1": "1785 First Street",
"Address Line 2": "",
"City": "New Bedford",
"State": "MA",
"Postal Code": 50553,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Benitez",
"Contact First Name": "Violeta",
"Deal Size": "Small"
},
{
"Order Number": 10403,
"Quantity": 66,
"Price": 100,
"Order Line Number": 9,
"Sales": 11886.6,
"Order Date": "4/8/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "UK Collectables, Ltd.",
"Phone": "(171) 555-2282",
"Address Line 1": "Berkeley Gardens 12 Brewery",
"Address Line 2": "",
"City": "Liverpool",
"State": "",
"Postal Code": "WX1 6LT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Devon",
"Contact First Name": "Elizabeth",
"Deal Size": "Large"
},
{
"Order Number": 10417,
"Quantity": 56,
"Price": 100,
"Order Line Number": 4,
"Sales": 9218.16,
"Order Date": "5/13/2018 0:00",
"Status": "Disputed",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 193,
"Product Code": "S10_4698",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Large"
},
{
"Order Number": 10105,
"Quantity": 50,
"Price": 100,
"Order Line Number": 2,
"Sales": 7208,
"Order Date": "2/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Danish Wholesale Imports",
"Phone": "31 12 3555",
"Address Line 1": "Vinb'ltet 34",
"Address Line 2": "",
"City": "Kobenhavn",
"State": "",
"Postal Code": 1734,
"Country": "Denmark",
"Territory": "EMEA",
"Contact Last Name": "Petersen",
"Contact First Name": "Jytte",
"Deal Size": "Large"
},
{
"Order Number": 10119,
"Quantity": 46,
"Price": 100,
"Order Line Number": 11,
"Sales": 5004.8,
"Order Date": "4/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Salzburg Collectables",
"Phone": "6562-9555",
"Address Line 1": "Geislweg 14",
"Address Line 2": "",
"City": "Salzburg",
"State": "",
"Postal Code": 5020,
"Country": "Austria",
"Territory": "EMEA",
"Contact Last Name": "Pipps",
"Contact First Name": "Georg",
"Deal Size": "Medium"
},
{
"Order Number": 10129,
"Quantity": 33,
"Price": 100,
"Order Line Number": 2,
"Sales": 4398.24,
"Order Date": "6/12/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Stylish Desk Decors, Co.",
"Phone": "(171) 555-0297",
"Address Line 1": "35 King George",
"Address Line 2": "",
"City": "London",
"State": "",
"Postal Code": "WX3 6FW",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Brown",
"Contact First Name": "Ann",
"Deal Size": "Medium"
},
{
"Order Number": 10143,
"Quantity": 49,
"Price": 100,
"Order Line Number": 15,
"Sales": 5597.76,
"Order Date": "8/10/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Mini Creations Ltd.",
"Phone": 5085559555,
"Address Line 1": "4575 Hillside Dr.",
"Address Line 2": "",
"City": "New Bedford",
"State": "MA",
"Postal Code": 50553,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Tam",
"Contact First Name": "Wing C",
"Deal Size": "Medium"
},
{
"Order Number": 10155,
"Quantity": 32,
"Price": 100,
"Order Line Number": 13,
"Sales": 4526.08,
"Order Date": "10/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Toys of Finland, Co.",
"Phone": "90-224 8555",
"Address Line 1": "Keskuskatu 45",
"Address Line 2": "",
"City": "Helsinki",
"State": "",
"Postal Code": 21240,
"Country": "Finland",
"Territory": "EMEA",
"Contact Last Name": "Karttunen",
"Contact First Name": "Matti",
"Deal Size": "Medium"
},
{
"Order Number": 10167,
"Quantity": 44,
"Price": 100,
"Order Line Number": 9,
"Sales": 5924.16,
"Order Date": "10/23/2016 0:00",
"Status": "Cancelled",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Scandinavian Gift Ideas",
"Phone": "0695-34 6555",
"Address Line 1": "?kergatan 24",
"Address Line 2": "",
"City": "Boras",
"State": "",
"Postal Code": "S-844 67",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Larsson",
"Contact First Name": "Maria",
"Deal Size": "Medium"
},
{
"Order Number": 10178,
"Quantity": 24,
"Price": 100,
"Order Line Number": 12,
"Sales": 3492.48,
"Order Date": "11/8/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Alpha Cognac",
"Phone": "61.77.6555",
"Address Line 1": "1 rue Alsace-Lorraine",
"Address Line 2": "",
"City": "Toulouse",
"State": "",
"Postal Code": 31000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Roulet",
"Contact First Name": "Annette",
"Deal Size": "Medium"
},
{
"Order Number": 10186,
"Quantity": 26,
"Price": 100,
"Order Line Number": 9,
"Sales": 3854.24,
"Order Date": "11/14/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Double Decker Gift Stores, Ltd",
"Phone": "(171) 555-7555",
"Address Line 1": "120 Hanover Sq.",
"Address Line 2": "",
"City": "London",
"State": "",
"Postal Code": "WA1 1DP",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Hardy",
"Contact First Name": "Thomas",
"Deal Size": "Medium"
},
{
"Order Number": 10197,
"Quantity": 45,
"Price": 100,
"Order Line Number": 6,
"Sales": 5324.4,
"Order Date": "11/26/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Enaco Distributors",
"Phone": "(93) 203 4555",
"Address Line 1": "Rambla de Catalu�a, 23",
"Address Line 2": "",
"City": "Barcelona",
"State": "",
"Postal Code": 8022,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Saavedra",
"Contact First Name": "Eduardo",
"Deal Size": "Medium"
},
{
"Order Number": 10209,
"Quantity": 39,
"Price": 100,
"Order Line Number": 8,
"Sales": 5197.92,
"Order Date": "1/9/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Men 'R' US Retailers, Ltd.",
"Phone": 2155554369,
"Address Line 1": "6047 Douglas Av.",
"Address Line 2": "",
"City": "Los Angeles",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Chandler",
"Contact First Name": "Michael",
"Deal Size": "Medium"
},
{
"Order Number": 10222,
"Quantity": 49,
"Price": 100,
"Order Line Number": 12,
"Sales": 5997.6,
"Order Date": "2/19/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Collectable Mini Designs Co.",
"Phone": 7605558146,
"Address Line 1": "361 Furth Circle",
"Address Line 2": "",
"City": "San Diego",
"State": "CA",
"Postal Code": 91217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Thompson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10248,
"Quantity": 20,
"Price": 100,
"Order Line Number": 3,
"Sales": 2910.4,
"Order Date": "5/7/2017 0:00",
"Status": "Cancelled",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 136,
"Product Code": "S10_4757",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Small"
},
{
"Order Number": 10110,
"Quantity": 28,
"Price": 89.27,
"Order Line Number": 8,
"Sales": 2499.56,
"Order Date": "3/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Small"
},
{
"Order Number": 10124,
"Quantity": 36,
"Price": 85.59,
"Order Line Number": 7,
"Sales": 3081.24,
"Order Date": "5/21/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Signal Gift Stores",
"Phone": 7025551838,
"Address Line 1": "8489 Strong St.",
"Address Line 2": "",
"City": "Las Vegas",
"State": "NV",
"Postal Code": 83030,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Sue",
"Deal Size": "Medium"
},
{
"Order Number": 10148,
"Quantity": 34,
"Price": 100,
"Order Line Number": 1,
"Sales": 3598.22,
"Order Date": "9/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Medium"
},
{
"Order Number": 10162,
"Quantity": 39,
"Price": 100,
"Order Line Number": 10,
"Sales": 3912.09,
"Order Date": "10/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Corporate Gift Ideas Co.",
"Phone": 6505551386,
"Address Line 1": "7734 Strong St.",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10173,
"Quantity": 21,
"Price": 75.46,
"Order Line Number": 14,
"Sales": 1584.66,
"Order Date": "11/5/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Rovelli Gifts",
"Phone": "035-640555",
"Address Line 1": "Via Ludovico il Moro 22",
"Address Line 2": "",
"City": "Bergamo",
"State": "",
"Postal Code": 24100,
"Country": "Italy",
"Territory": "EMEA",
"Contact Last Name": "Rovelli",
"Contact First Name": "Giovanni",
"Deal Size": "Small"
},
{
"Order Number": 10182,
"Quantity": 36,
"Price": 100,
"Order Line Number": 11,
"Sales": 3942.72,
"Order Date": "11/12/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10193,
"Quantity": 24,
"Price": 97.55,
"Order Line Number": 15,
"Sales": 2341.2,
"Order Date": "11/21/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Australian Collectables, Ltd",
"Phone": "61-9-3844-6555",
"Address Line 1": "7 Allen Street",
"Address Line 2": "",
"City": "Glen Waverly",
"State": "Victoria",
"Postal Code": 3150,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Connery",
"Contact First Name": "Sean",
"Deal Size": "Small"
},
{
"Order Number": 10204,
"Quantity": 29,
"Price": 85.59,
"Order Line Number": 5,
"Sales": 2482.11,
"Order Date": "12/2/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Muscle Machine Inc",
"Phone": 2125557413,
"Address Line 1": "4092 Furth Circle",
"Address Line 2": "Suite 400",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Jeff",
"Deal Size": "Small"
},
{
"Order Number": 10213,
"Quantity": 38,
"Price": 94.79,
"Order Line Number": 1,
"Sales": 3602.02,
"Order Date": "1/22/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Double Decker Gift Stores, Ltd",
"Phone": "(171) 555-7555",
"Address Line 1": "120 Hanover Sq.",
"Address Line 2": "",
"City": "London",
"State": "",
"Postal Code": "WA1 1DP",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Hardy",
"Contact First Name": "Thomas",
"Deal Size": "Medium"
},
{
"Order Number": 10227,
"Quantity": 34,
"Price": 100,
"Order Line Number": 11,
"Sales": 3566.94,
"Order Date": "3/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Saveley & Henriot, Co.",
"Phone": "78.32.5555",
"Address Line 1": "2, rue du Commerce",
"Address Line 2": "",
"City": "Lyon",
"State": "",
"Postal Code": 69004,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Saveley",
"Contact First Name": "Mary",
"Deal Size": "Medium"
},
{
"Order Number": 10241,
"Quantity": 42,
"Price": 90.19,
"Order Line Number": 3,
"Sales": 3787.98,
"Order Date": "4/13/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Mini Caravy",
"Phone": "88.60.1555",
"Address Line 1": "24, place Kluber",
"Address Line 2": "",
"City": "Strasbourg",
"State": "",
"Postal Code": 67000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Citeaux",
"Contact First Name": "Frederique",
"Deal Size": "Medium"
},
{
"Order Number": 10280,
"Quantity": 35,
"Price": 100,
"Order Line Number": 17,
"Sales": 3704.05,
"Order Date": "8/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Amica Models & Co.",
"Phone": "011-4988555",
"Address Line 1": "Via Monte Bianco 34",
"Address Line 2": "",
"City": "Torino",
"State": "",
"Postal Code": 10100,
"Country": "Italy",
"Territory": "EMEA",
"Contact Last Name": "Accorti",
"Contact First Name": "Paolo",
"Deal Size": "Medium"
},
{
"Order Number": 10288,
"Quantity": 35,
"Price": 80.99,
"Order Line Number": 6,
"Sales": 2834.65,
"Order Date": "9/1/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Handji Gifts& Co",
"Phone": "+65 224 1555",
"Address Line 1": "Village Close - 106 Linden Road Sandown",
"Address Line 2": "2nd Floor",
"City": "Singapore",
"State": "",
"Postal Code": 69045,
"Country": "Singapore",
"Territory": "APAC",
"Contact Last Name": "Victorino",
"Contact First Name": "Wendy",
"Deal Size": "Small"
},
{
"Order Number": 10302,
"Quantity": 38,
"Price": 89.27,
"Order Line Number": 2,
"Sales": 3392.26,
"Order Date": "10/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "UK Collectables, Ltd.",
"Phone": "(171) 555-2282",
"Address Line 1": "Berkeley Gardens 12 Brewery",
"Address Line 2": "",
"City": "Liverpool",
"State": "",
"Postal Code": "WX1 6LT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Devon",
"Contact First Name": "Elizabeth",
"Deal Size": "Medium"
},
{
"Order Number": 10311,
"Quantity": 41,
"Price": 81.91,
"Order Line Number": 1,
"Sales": 3358.31,
"Order Date": "10/16/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10332,
"Quantity": 50,
"Price": 100,
"Order Line Number": 2,
"Sales": 7310,
"Order Date": "11/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Large"
},
{
"Order Number": 10344,
"Quantity": 21,
"Price": 100,
"Order Line Number": 4,
"Sales": 2203.11,
"Order Date": "11/25/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Marseille Mini Autos",
"Phone": "91.24.4555",
"Address Line 1": "12, rue des Bouchers",
"Address Line 2": "",
"City": "Marseille",
"State": "",
"Postal Code": 13008,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Lebihan",
"Contact First Name": "Laurence",
"Deal Size": "Small"
},
{
"Order Number": 10367,
"Quantity": 43,
"Price": 62.72,
"Order Line Number": 8,
"Sales": 2696.96,
"Order Date": "1/12/2018 0:00",
"Status": "Resolved",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Toys4GrownUps.com",
"Phone": 6265557265,
"Address Line 1": "78934 Hillside Dr.",
"Address Line 2": "",
"City": "Pasadena",
"State": "CA",
"Postal Code": 90003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Julie",
"Deal Size": "Small"
},
{
"Order Number": 10380,
"Quantity": 32,
"Price": 100,
"Order Line Number": 1,
"Sales": 3376.64,
"Order Date": "2/16/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10407,
"Quantity": 6,
"Price": 90.19,
"Order Line Number": 3,
"Sales": 541.14,
"Order Date": "4/22/2018 0:00",
"Status": "On Hold",
"Quarter ": 2,
"Month": 4,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "The Sharp Gifts Warehouse",
"Phone": 4085553659,
"Address Line 1": "3086 Ingle Ln.",
"Address Line 2": "",
"City": "San Jose",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Sue",
"Deal Size": "Small"
},
{
"Order Number": 10420,
"Quantity": 66,
"Price": 92.95,
"Order Line Number": 6,
"Sales": 6134.7,
"Order Date": "5/29/2018 0:00",
"Status": "In Process",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 92,
"Product Code": "S18_4409",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Medium"
},
{
"Order Number": 10105,
"Quantity": 41,
"Price": 82.5,
"Order Line Number": 10,
"Sales": 3382.5,
"Order Date": "2/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Danish Wholesale Imports",
"Phone": "31 12 3555",
"Address Line 1": "Vinb'ltet 34",
"Address Line 2": "",
"City": "Kobenhavn",
"State": "",
"Postal Code": 1734,
"Country": "Denmark",
"Territory": "EMEA",
"Contact Last Name": "Petersen",
"Contact First Name": "Jytte",
"Deal Size": "Medium"
},
{
"Order Number": 10117,
"Quantity": 23,
"Price": 97.42,
"Order Line Number": 4,
"Sales": 2240.66,
"Order Date": "4/16/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Dragon Souveniers, Ltd.",
"Phone": "+65 221 7555",
"Address Line 1": "Bronz Sok., Bronz Apt. 3/6 Tesvikiye",
"Address Line 2": "",
"City": "Singapore",
"State": "",
"Postal Code": 79903,
"Country": "Singapore",
"Territory": "Japan",
"Contact Last Name": "Natividad",
"Contact First Name": "Eric",
"Deal Size": "Small"
},
{
"Order Number": 10128,
"Quantity": 43,
"Price": 92.16,
"Order Line Number": 1,
"Sales": 3962.88,
"Order Date": "6/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10142,
"Quantity": 24,
"Price": 70.22,
"Order Line Number": 7,
"Sales": 1685.28,
"Order Date": "8/8/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10153,
"Quantity": 22,
"Price": 83.38,
"Order Line Number": 6,
"Sales": 1834.36,
"Order Date": "9/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10166,
"Quantity": 26,
"Price": 73.73,
"Order Line Number": 1,
"Sales": 1916.98,
"Order Date": "10/21/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "FunGiftIdeas.com",
"Phone": 5085552555,
"Address Line 1": "1785 First Street",
"Address Line 2": "",
"City": "New Bedford",
"State": "MA",
"Postal Code": 50553,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Benitez",
"Contact First Name": "Violeta",
"Deal Size": "Small"
},
{
"Order Number": 10177,
"Quantity": 35,
"Price": 74.6,
"Order Line Number": 8,
"Sales": 2611,
"Order Date": "11/7/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "CAF Imports",
"Phone": "+34 913 728 555",
"Address Line 1": "Merchants House, 27-30 Merchant's Quay",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28023,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Fernandez",
"Contact First Name": "Jesus",
"Deal Size": "Small"
},
{
"Order Number": 10185,
"Quantity": 47,
"Price": 77.24,
"Order Line Number": 8,
"Sales": 3630.28,
"Order Date": "11/14/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Mini Creations Ltd.",
"Phone": 5085559555,
"Address Line 1": "4575 Hillside Dr.",
"Address Line 2": "",
"City": "New Bedford",
"State": "MA",
"Postal Code": 50553,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Tam",
"Contact First Name": "Wing C",
"Deal Size": "Medium"
},
{
"Order Number": 10197,
"Quantity": 50,
"Price": 100,
"Order Line Number": 14,
"Sales": 5090.5,
"Order Date": "11/26/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Enaco Distributors",
"Phone": "(93) 203 4555",
"Address Line 1": "Rambla de Catalu�a, 23",
"Address Line 2": "",
"City": "Barcelona",
"State": "",
"Postal Code": 8022,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Saavedra",
"Contact First Name": "Eduardo",
"Deal Size": "Medium"
},
{
"Order Number": 10208,
"Quantity": 45,
"Price": 87.77,
"Order Line Number": 8,
"Sales": 3949.65,
"Order Date": "1/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Saveley & Henriot, Co.",
"Phone": "78.32.5555",
"Address Line 1": "2, rue du Commerce",
"Address Line 2": "",
"City": "Lyon",
"State": "",
"Postal Code": 69004,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Saveley",
"Contact First Name": "Mary",
"Deal Size": "Medium"
},
{
"Order Number": 10221,
"Quantity": 39,
"Price": 89.53,
"Order Line Number": 2,
"Sales": 3491.67,
"Order Date": "2/18/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Petit Auto",
"Phone": "(02) 5554 67",
"Address Line 1": "Rue Joseph-Bens 532",
"Address Line 2": "",
"City": "Bruxelles",
"State": "",
"Postal Code": "B-1180",
"Country": "Belgium",
"Territory": "EMEA",
"Contact Last Name": "Dewey",
"Contact First Name": "Catherine",
"Deal Size": "Medium"
},
{
"Order Number": 10232,
"Quantity": 23,
"Price": 89.53,
"Order Line Number": 5,
"Sales": 2059.19,
"Order Date": "3/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "giftsbymail.co.uk",
"Phone": "(198) 555-8888",
"Address Line 1": "Garden House Crowther Way",
"Address Line 2": "",
"City": "Cowes",
"State": "Isle of Wight",
"Postal Code": "PO31 7PJ",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Bennett",
"Contact First Name": "Helen",
"Deal Size": "Small"
},
{
"Order Number": 10248,
"Quantity": 42,
"Price": 75.48,
"Order Line Number": 11,
"Sales": 3170.16,
"Order Date": "5/7/2017 0:00",
"Status": "Cancelled",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Medium"
},
{
"Order Number": 10261,
"Quantity": 20,
"Price": 89.53,
"Order Line Number": 9,
"Sales": 1790.6,
"Order Date": "6/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Quebec Home Shopping Network",
"Phone": "(514) 555-8054",
"Address Line 1": "43 rue St. Laurent",
"Address Line 2": "",
"City": "Montreal",
"State": "Quebec",
"Postal Code": "H1J 1C3",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Fresnisre",
"Contact First Name": "Jean",
"Deal Size": "Small"
},
{
"Order Number": 10273,
"Quantity": 33,
"Price": 71.09,
"Order Line Number": 12,
"Sales": 2345.97,
"Order Date": "7/21/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Petit Auto",
"Phone": "(02) 5554 67",
"Address Line 1": "Rue Joseph-Bens 532",
"Address Line 2": "",
"City": "Bruxelles",
"State": "",
"Postal Code": "B-1180",
"Country": "Belgium",
"Territory": "EMEA",
"Contact Last Name": "Dewey",
"Contact First Name": "Catherine",
"Deal Size": "Small"
},
{
"Order Number": 10283,
"Quantity": 34,
"Price": 100,
"Order Line Number": 14,
"Sales": 3580.88,
"Order Date": "8/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Royal Canadian Collectables, Ltd.",
"Phone": "(604) 555-4555",
"Address Line 1": "23 Tsawassen Blvd.",
"Address Line 2": "",
"City": "Tsawassen",
"State": "BC",
"Postal Code": "T2F 8M4",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Lincoln",
"Contact First Name": "Elizabeth",
"Deal Size": "Medium"
},
{
"Order Number": 10293,
"Quantity": 49,
"Price": 100,
"Order Line Number": 3,
"Sales": 4946.06,
"Order Date": "9/9/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Amica Models & Co.",
"Phone": "011-4988555",
"Address Line 1": "Via Monte Bianco 34",
"Address Line 2": "",
"City": "Torino",
"State": "",
"Postal Code": 10100,
"Country": "Italy",
"Territory": "EMEA",
"Contact Last Name": "Accorti",
"Contact First Name": "Paolo",
"Deal Size": "Medium"
},
{
"Order Number": 10306,
"Quantity": 39,
"Price": 90.4,
"Order Line Number": 8,
"Sales": 3525.6,
"Order Date": "10/14/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Medium"
},
{
"Order Number": 10315,
"Quantity": 36,
"Price": 100,
"Order Line Number": 7,
"Sales": 3602.16,
"Order Date": "10/29/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Medium"
},
{
"Order Number": 10326,
"Quantity": 50,
"Price": 86.01,
"Order Line Number": 5,
"Sales": 4300.5,
"Order Date": "11/9/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Volvo Model Replicas, Co",
"Phone": "0921-12 3555",
"Address Line 1": "Berguvsv�gen 8",
"Address Line 2": "",
"City": "Lule",
"State": "",
"Postal Code": "S-958 22",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Berglund",
"Contact First Name": "Christina",
"Deal Size": "Medium"
},
{
"Order Number": 10337,
"Quantity": 29,
"Price": 100,
"Order Line Number": 2,
"Sales": 4498.19,
"Order Date": "11/21/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Classic Legends Inc.",
"Phone": 2125558493,
"Address Line 1": "5905 Pompton St.",
"Address Line 2": "Suite 750",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Maria",
"Deal Size": "Medium"
},
{
"Order Number": 10350,
"Quantity": 30,
"Price": 100,
"Order Line Number": 3,
"Sales": 3023.1,
"Order Date": "12/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10372,
"Quantity": 41,
"Price": 86.89,
"Order Line Number": 7,
"Sales": 3562.49,
"Order Date": "1/26/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Tokyo Collectables, Ltd",
"Phone": "+81 3 3584 0555",
"Address Line 1": "2-2-8 Roppongi",
"Address Line 2": "",
"City": "Minato-ku",
"State": "Tokyo",
"Postal Code": "106-0032",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Shimamura",
"Contact First Name": "Akiko",
"Deal Size": "Medium"
},
{
"Order Number": 10383,
"Quantity": 28,
"Price": 58.58,
"Order Line Number": 7,
"Sales": 1640.24,
"Order Date": "2/22/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10396,
"Quantity": 45,
"Price": 100,
"Order Line Number": 5,
"Sales": 4739.4,
"Order Date": "3/23/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10414,
"Quantity": 16,
"Price": 75.48,
"Order Line Number": 11,
"Sales": 1207.68,
"Order Date": "5/6/2018 0:00",
"Status": "On Hold",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 87,
"Product Code": "S18_4522",
"Customer Name": "Gifts4AllAges.com",
"Phone": 6175559555,
"Address Line 1": "8616 Spinnaker Dr.",
"Address Line 2": "",
"City": "Boston",
"State": "MA",
"Postal Code": 51003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yoshido",
"Contact First Name": "Juri",
"Deal Size": "Small"
},
{
"Order Number": 10103,
"Quantity": 36,
"Price": 100,
"Order Line Number": 5,
"Sales": 4228.2,
"Order Date": "1/29/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Baane Mini Imports",
"Phone": "07-98 9555",
"Address Line 1": "Erling Skakkes gate 78",
"Address Line 2": "",
"City": "Stavern",
"State": "",
"Postal Code": 4110,
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Bergulfsen",
"Contact First Name": "Jonas",
"Deal Size": "Medium"
},
{
"Order Number": 10114,
"Quantity": 41,
"Price": 100,
"Order Line Number": 9,
"Sales": 4815.45,
"Order Date": "4/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "La Corne D'abondance, Co.",
"Phone": "(1) 42.34.2555",
"Address Line 1": "265, boulevard Charonne",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75012,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Bertrand",
"Contact First Name": "Marie",
"Deal Size": "Medium"
},
{
"Order Number": 10126,
"Quantity": 50,
"Price": 100,
"Order Line Number": 5,
"Sales": 7083,
"Order Date": "5/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Corrida Auto Replicas, Ltd",
"Phone": "(91) 555 22 82",
"Address Line 1": "C/ Araquil, 67",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28023,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Sommer",
"Contact First Name": "Mart�n",
"Deal Size": "Large"
},
{
"Order Number": 10140,
"Quantity": 40,
"Price": 100,
"Order Line Number": 5,
"Sales": 4601.2,
"Order Date": "7/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Medium"
},
{
"Order Number": 10150,
"Quantity": 49,
"Price": 100,
"Order Line Number": 2,
"Sales": 6467.02,
"Order Date": "9/19/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Dragon Souveniers, Ltd.",
"Phone": "+65 221 7555",
"Address Line 1": "Bronz Sok., Bronz Apt. 3/6 Tesvikiye",
"Address Line 2": "",
"City": "Singapore",
"State": "",
"Postal Code": 79903,
"Country": "Singapore",
"Territory": "Japan",
"Contact Last Name": "Natividad",
"Contact First Name": "Eric",
"Deal Size": "Medium"
},
{
"Order Number": 10164,
"Quantity": 45,
"Price": 100,
"Order Line Number": 3,
"Sales": 5012.55,
"Order Date": "10/21/2016 0:00",
"Status": "Resolved",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Mini Auto Werke",
"Phone": "7675-3555",
"Address Line 1": "Kirchgasse 6",
"Address Line 2": "",
"City": "Graz",
"State": "",
"Postal Code": 8010,
"Country": "Austria",
"Territory": "EMEA",
"Contact Last Name": "Mendel",
"Contact First Name": "Roland",
"Deal Size": "Medium"
},
{
"Order Number": 10175,
"Quantity": 47,
"Price": 100,
"Order Line Number": 10,
"Sales": 5121.59,
"Order Date": "11/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Stylish Desk Decors, Co.",
"Phone": "(171) 555-0297",
"Address Line 1": "35 King George",
"Address Line 2": "",
"City": "London",
"State": "",
"Postal Code": "WX3 6FW",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Brown",
"Contact First Name": "Ann",
"Deal Size": "Medium"
},
{
"Order Number": 10183,
"Quantity": 21,
"Price": 100,
"Order Line Number": 2,
"Sales": 2441.04,
"Order Date": "11/13/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Classic Gift Ideas, Inc",
"Phone": 2155554695,
"Address Line 1": "782 First Street",
"Address Line 2": "",
"City": "Philadelphia",
"State": "PA",
"Postal Code": 71270,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Cervantes",
"Contact First Name": "Francisca",
"Deal Size": "Small"
},
{
"Order Number": 10194,
"Quantity": 32,
"Price": 100,
"Order Line Number": 5,
"Sales": 4262.08,
"Order Date": "11/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Saveley & Henriot, Co.",
"Phone": "78.32.5555",
"Address Line 1": "2, rue du Commerce",
"Address Line 2": "",
"City": "Lyon",
"State": "",
"Postal Code": 69004,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Saveley",
"Contact First Name": "Mary",
"Deal Size": "Medium"
},
{
"Order Number": 10207,
"Quantity": 47,
"Price": 100,
"Order Line Number": 16,
"Sales": 6658.02,
"Order Date": "12/9/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Diecast Collectables",
"Phone": 6175552555,
"Address Line 1": "6251 Ingle Ln.",
"Address Line 2": "",
"City": "Boston",
"State": "MA",
"Postal Code": 51003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Franco",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10217,
"Quantity": 38,
"Price": 100,
"Order Line Number": 5,
"Sales": 4509.08,
"Order Date": "2/4/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Handji Gifts& Co",
"Phone": "+65 224 1555",
"Address Line 1": "Village Close - 106 Linden Road Sandown",
"Address Line 2": "2nd Floor",
"City": "Singapore",
"State": "",
"Postal Code": 69045,
"Country": "Singapore",
"Territory": "APAC",
"Contact Last Name": "Victorino",
"Contact First Name": "Wendy",
"Deal Size": "Medium"
},
{
"Order Number": 10229,
"Quantity": 41,
"Price": 100,
"Order Line Number": 10,
"Sales": 4716.23,
"Order Date": "3/11/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10245,
"Quantity": 21,
"Price": 100,
"Order Line Number": 3,
"Sales": 2390.22,
"Order Date": "5/4/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Super Scale Inc.",
"Phone": 2035559545,
"Address Line 1": "567 North Pendale Street",
"Address Line 2": "",
"City": "New Haven",
"State": "CT",
"Postal Code": 97823,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Leslie",
"Deal Size": "Small"
},
{
"Order Number": 10259,
"Quantity": 41,
"Price": 100,
"Order Line Number": 13,
"Sales": 4666.62,
"Order Date": "6/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Handji Gifts& Co",
"Phone": "+65 224 1555",
"Address Line 1": "Village Close - 106 Linden Road Sandown",
"Address Line 2": "2nd Floor",
"City": "Singapore",
"State": "",
"Postal Code": 69045,
"Country": "Singapore",
"Territory": "APAC",
"Contact Last Name": "Victorino",
"Contact First Name": "Wendy",
"Deal Size": "Medium"
},
{
"Order Number": 10270,
"Quantity": 38,
"Price": 100,
"Order Line Number": 3,
"Sales": 5383.08,
"Order Date": "7/19/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Medium"
},
{
"Order Number": 10281,
"Quantity": 25,
"Price": 99.29,
"Order Line Number": 10,
"Sales": 2482.25,
"Order Date": "8/19/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Diecast Classics Inc.",
"Phone": 2155551555,
"Address Line 1": "7586 Pompton St.",
"Address Line 2": "",
"City": "Allentown",
"State": "PA",
"Postal Code": 70267,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kyung",
"Deal Size": "Small"
},
{
"Order Number": 10291,
"Quantity": 48,
"Price": 100,
"Order Line Number": 5,
"Sales": 5288.64,
"Order Date": "9/8/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Scandinavian Gift Ideas",
"Phone": "0695-34 6555",
"Address Line 1": "?kergatan 24",
"Address Line 2": "",
"City": "Boras",
"State": "",
"Postal Code": "S-844 67",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Larsson",
"Contact First Name": "Maria",
"Deal Size": "Medium"
},
{
"Order Number": 10305,
"Quantity": 22,
"Price": 99.29,
"Order Line Number": 14,
"Sales": 2184.38,
"Order Date": "10/13/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Marta's Replicas Co.",
"Phone": 6175558555,
"Address Line 1": "39323 Spinnaker Dr.",
"Address Line 2": "",
"City": "Cambridge",
"State": "MA",
"Postal Code": 51247,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Marta",
"Deal Size": "Small"
},
{
"Order Number": 10313,
"Quantity": 28,
"Price": 100,
"Order Line Number": 8,
"Sales": 2881.76,
"Order Date": "10/22/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Canadian Gift Exchange Network",
"Phone": "(604) 555-3392",
"Address Line 1": "1900 Oak St.",
"Address Line 2": "",
"City": "Vancouver",
"State": "BC",
"Postal Code": "V3F 2K1",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Tannamuri",
"Contact First Name": "Yoshi",
"Deal Size": "Small"
},
{
"Order Number": 10323,
"Quantity": 47,
"Price": 100,
"Order Line Number": 1,
"Sales": 6203.06,
"Order Date": "11/5/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Blauer See Auto, Co.",
"Phone": "+49 69 66 90 2555",
"Address Line 1": "Lyonerstr. 34",
"Address Line 2": "",
"City": "Frankfurt",
"State": "",
"Postal Code": 60528,
"Country": "Germany",
"Territory": "EMEA",
"Contact Last Name": "Keitel",
"Contact First Name": "Roland",
"Deal Size": "Medium"
},
{
"Order Number": 10334,
"Quantity": 49,
"Price": 100,
"Order Line Number": 4,
"Sales": 6763.47,
"Order Date": "11/19/2017 0:00",
"Status": "On Hold",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Volvo Model Replicas, Co",
"Phone": "0921-12 3555",
"Address Line 1": "Berguvsv�gen 8",
"Address Line 2": "",
"City": "Lule",
"State": "",
"Postal Code": "S-958 22",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Berglund",
"Contact First Name": "Christina",
"Deal Size": "Medium"
},
{
"Order Number": 10347,
"Quantity": 45,
"Price": 100,
"Order Line Number": 4,
"Sales": 5884.65,
"Order Date": "11/29/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Medium"
},
{
"Order Number": 10357,
"Quantity": 28,
"Price": 100,
"Order Line Number": 2,
"Sales": 3559.64,
"Order Date": "12/10/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10370,
"Quantity": 29,
"Price": 57.53,
"Order Line Number": 6,
"Sales": 1668.37,
"Order Date": "1/20/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Small"
},
{
"Order Number": 10382,
"Quantity": 39,
"Price": 100,
"Order Line Number": 1,
"Sales": 4890.6,
"Order Date": "2/17/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10411,
"Quantity": 46,
"Price": 100,
"Order Line Number": 3,
"Sales": 5235.72,
"Order Date": "5/1/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "Quebec Home Shopping Network",
"Phone": "(514) 555-8054",
"Address Line 1": "43 rue St. Laurent",
"Address Line 2": "",
"City": "Montreal",
"State": "Quebec",
"Postal Code": "H1J 1C3",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Fresnisre",
"Contact First Name": "Jean",
"Deal Size": "Medium"
},
{
"Order Number": 10425,
"Quantity": 38,
"Price": 100,
"Order Line Number": 13,
"Sales": 4325.16,
"Order Date": "5/31/2018 0:00",
"Status": "In Process",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Trucks and Buses",
"MSRP": 121,
"Product Code": "S18_4600",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Medium"
},
{
"Order Number": 10103,
"Quantity": 41,
"Price": 47.29,
"Order Line Number": 9,
"Sales": 1938.89,
"Order Date": "1/29/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Baane Mini Imports",
"Phone": "07-98 9555",
"Address Line 1": "Erling Skakkes gate 78",
"Address Line 2": "",
"City": "Stavern",
"State": "",
"Postal Code": 4110,
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Bergulfsen",
"Contact First Name": "Jonas",
"Deal Size": "Small"
},
{
"Order Number": 10113,
"Quantity": 50,
"Price": 49.81,
"Order Line Number": 3,
"Sales": 2490.5,
"Order Date": "3/26/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10126,
"Quantity": 43,
"Price": 53.83,
"Order Line Number": 9,
"Sales": 2314.69,
"Order Date": "5/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Corrida Auto Replicas, Ltd",
"Phone": "(91) 555 22 82",
"Address Line 1": "C/ Araquil, 67",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28023,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Sommer",
"Contact First Name": "Mart�n",
"Deal Size": "Small"
},
{
"Order Number": 10140,
"Quantity": 29,
"Price": 43.27,
"Order Line Number": 9,
"Sales": 1254.83,
"Order Date": "7/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Small"
},
{
"Order Number": 10150,
"Quantity": 30,
"Price": 42.76,
"Order Line Number": 6,
"Sales": 1282.8,
"Order Date": "9/19/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Dragon Souveniers, Ltd.",
"Phone": "+65 221 7555",
"Address Line 1": "Bronz Sok., Bronz Apt. 3/6 Tesvikiye",
"Address Line 2": "",
"City": "Singapore",
"State": "",
"Postal Code": 79903,
"Country": "Singapore",
"Territory": "Japan",
"Contact Last Name": "Natividad",
"Contact First Name": "Eric",
"Deal Size": "Small"
},
{
"Order Number": 10164,
"Quantity": 25,
"Price": 53.83,
"Order Line Number": 7,
"Sales": 1345.75,
"Order Date": "10/21/2016 0:00",
"Status": "Resolved",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Mini Auto Werke",
"Phone": "7675-3555",
"Address Line 1": "Kirchgasse 6",
"Address Line 2": "",
"City": "Graz",
"State": "",
"Postal Code": 8010,
"Country": "Austria",
"Territory": "EMEA",
"Contact Last Name": "Mendel",
"Contact First Name": "Roland",
"Deal Size": "Small"
},
{
"Order Number": 10174,
"Quantity": 49,
"Price": 44.78,
"Order Line Number": 2,
"Sales": 2194.22,
"Order Date": "11/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Australian Gift Network, Co",
"Phone": "61-7-3844-6555",
"Address Line 1": "31 Duncan St. West End",
"Address Line 2": "",
"City": "South Brisbane",
"State": "Queensland",
"Postal Code": 4101,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Calaghan",
"Contact First Name": "Tony",
"Deal Size": "Small"
},
{
"Order Number": 10183,
"Quantity": 40,
"Price": 49.3,
"Order Line Number": 6,
"Sales": 1972,
"Order Date": "11/13/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Classic Gift Ideas, Inc",
"Phone": 2155554695,
"Address Line 1": "782 First Street",
"Address Line 2": "",
"City": "Philadelphia",
"State": "PA",
"Postal Code": 71270,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Cervantes",
"Contact First Name": "Francisca",
"Deal Size": "Small"
},
{
"Order Number": 10194,
"Quantity": 41,
"Price": 44.78,
"Order Line Number": 9,
"Sales": 1835.98,
"Order Date": "11/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Saveley & Henriot, Co.",
"Phone": "78.32.5555",
"Address Line 1": "2, rue du Commerce",
"Address Line 2": "",
"City": "Lyon",
"State": "",
"Postal Code": 69004,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Saveley",
"Contact First Name": "Mary",
"Deal Size": "Small"
},
{
"Order Number": 10206,
"Quantity": 21,
"Price": 53.33,
"Order Line Number": 4,
"Sales": 1119.93,
"Order Date": "12/5/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Canadian Gift Exchange Network",
"Phone": "(604) 555-3392",
"Address Line 1": "1900 Oak St.",
"Address Line 2": "",
"City": "Vancouver",
"State": "BC",
"Postal Code": "V3F 2K1",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Tannamuri",
"Contact First Name": "Yoshi",
"Deal Size": "Small"
},
{
"Order Number": 10215,
"Quantity": 46,
"Price": 45.28,
"Order Line Number": 1,
"Sales": 2082.88,
"Order Date": "1/29/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "West Coast Collectables Co.",
"Phone": 3105553722,
"Address Line 1": "3675 Furth Circle",
"Address Line 2": "",
"City": "Burbank",
"State": "CA",
"Postal Code": 94019,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Thompson",
"Contact First Name": "Steve",
"Deal Size": "Small"
},
{
"Order Number": 10229,
"Quantity": 39,
"Price": 40.25,
"Order Line Number": 14,
"Sales": 1569.75,
"Order Date": "3/11/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10245,
"Quantity": 45,
"Price": 59.87,
"Order Line Number": 7,
"Sales": 2694.15,
"Order Date": "5/4/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Super Scale Inc.",
"Phone": 2035559545,
"Address Line 1": "567 North Pendale Street",
"Address Line 2": "",
"City": "New Haven",
"State": "CT",
"Postal Code": 97823,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Leslie",
"Deal Size": "Small"
},
{
"Order Number": 10258,
"Quantity": 21,
"Price": 59.87,
"Order Line Number": 4,
"Sales": 1257.27,
"Order Date": "6/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Tokyo Collectables, Ltd",
"Phone": "+81 3 3584 0555",
"Address Line 1": "2-2-8 Roppongi",
"Address Line 2": "",
"City": "Minato-ku",
"State": "Tokyo",
"Postal Code": "106-0032",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Shimamura",
"Contact First Name": "Akiko",
"Deal Size": "Small"
},
{
"Order Number": 10270,
"Quantity": 44,
"Price": 58.36,
"Order Line Number": 7,
"Sales": 2567.84,
"Order Date": "7/19/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Small"
},
{
"Order Number": 10281,
"Quantity": 44,
"Price": 59.87,
"Order Line Number": 14,
"Sales": 2634.28,
"Order Date": "8/19/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Diecast Classics Inc.",
"Phone": 2155551555,
"Address Line 1": "7586 Pompton St.",
"Address Line 2": "",
"City": "Allentown",
"State": "PA",
"Postal Code": 70267,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kyung",
"Deal Size": "Small"
},
{
"Order Number": 10291,
"Quantity": 29,
"Price": 51.82,
"Order Line Number": 9,
"Sales": 1502.78,
"Order Date": "9/8/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Scandinavian Gift Ideas",
"Phone": "0695-34 6555",
"Address Line 1": "?kergatan 24",
"Address Line 2": "",
"City": "Boras",
"State": "",
"Postal Code": "S-844 67",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Larsson",
"Contact First Name": "Maria",
"Deal Size": "Small"
},
{
"Order Number": 10304,
"Quantity": 34,
"Price": 49.3,
"Order Line Number": 4,
"Sales": 1676.2,
"Order Date": "10/11/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Auto Assoc. & Cie.",
"Phone": "30.59.8555",
"Address Line 1": "67, avenue de l'Europe",
"Address Line 2": "",
"City": "Versailles",
"State": "",
"Postal Code": 78000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Tonini",
"Contact First Name": "Daniel",
"Deal Size": "Small"
},
{
"Order Number": 10312,
"Quantity": 39,
"Price": 56.85,
"Order Line Number": 1,
"Sales": 2217.15,
"Order Date": "10/21/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10324,
"Quantity": 38,
"Price": 100,
"Order Line Number": 6,
"Sales": 6832.02,
"Order Date": "11/5/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Vitachrome Inc.",
"Phone": 2125551500,
"Address Line 1": "2678 Kingston Rd.",
"Address Line 2": "Suite 101",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Michael",
"Deal Size": "Medium"
},
{
"Order Number": 10333,
"Quantity": 24,
"Price": 79.86,
"Order Line Number": 8,
"Sales": 1916.64,
"Order Date": "11/18/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Mini Wheels Co.",
"Phone": 6505555787,
"Address Line 1": "5557 North Pendale Street",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Julie",
"Deal Size": "Small"
},
{
"Order Number": 10348,
"Quantity": 29,
"Price": 100,
"Order Line Number": 6,
"Sales": 7110.8,
"Order Date": "11/1/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Corrida Auto Replicas, Ltd",
"Phone": "(91) 555 22 82",
"Address Line 1": "C/ Araquil, 67",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28023,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Sommer",
"Contact First Name": "Mart�n",
"Deal Size": "Large"
},
{
"Order Number": 10358,
"Quantity": 30,
"Price": 100,
"Order Line Number": 8,
"Sales": 5302.8,
"Order Date": "12/10/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10370,
"Quantity": 20,
"Price": 100,
"Order Line Number": 2,
"Sales": 2730,
"Order Date": "1/20/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Small"
},
{
"Order Number": 10382,
"Quantity": 39,
"Price": 100,
"Order Line Number": 2,
"Sales": 7827.3,
"Order Date": "2/17/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Large"
},
{
"Order Number": 10411,
"Quantity": 35,
"Price": 59.87,
"Order Line Number": 7,
"Sales": 2095.45,
"Order Date": "5/1/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Quebec Home Shopping Network",
"Phone": "(514) 555-8054",
"Address Line 1": "43 rue St. Laurent",
"Address Line 2": "",
"City": "Montreal",
"State": "Quebec",
"Postal Code": "H1J 1C3",
"Country": "Canada",
"Territory": "NA",
"Contact Last Name": "Fresnisre",
"Contact First Name": "Jean",
"Deal Size": "Small"
},
{
"Order Number": 10424,
"Quantity": 26,
"Price": 59.87,
"Order Line Number": 4,
"Sales": 1556.62,
"Order Date": "5/31/2018 0:00",
"Status": "In Process",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Vintage Cars",
"MSRP": 50,
"Product Code": "S18_4668",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10108,
"Quantity": 44,
"Price": 100,
"Order Line Number": 11,
"Sales": 5565.12,
"Order Date": "3/3/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Cruz & Sons Co.",
"Phone": "+63 2 555 3587",
"Address Line 1": "15 McCallum Street - NatWest Center #13-03",
"Address Line 2": "",
"City": "Makati City",
"State": "",
"Postal Code": "1227 MM",
"Country": "Philippines",
"Territory": "Japan",
"Contact Last Name": "Cruz",
"Contact First Name": "Arnold",
"Deal Size": "Medium"
},
{
"Order Number": 10122,
"Quantity": 28,
"Price": 100,
"Order Line Number": 15,
"Sales": 3583.16,
"Order Date": "5/8/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Marseille Mini Autos",
"Phone": "91.24.4555",
"Address Line 1": "12, rue des Bouchers",
"Address Line 2": "",
"City": "Marseille",
"State": "",
"Postal Code": 13008,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Lebihan",
"Contact First Name": "Laurence",
"Deal Size": "Medium"
},
{
"Order Number": 10135,
"Quantity": 31,
"Price": 100,
"Order Line Number": 12,
"Sales": 4705.18,
"Order Date": "7/2/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10146,
"Quantity": 29,
"Price": 100,
"Order Line Number": 1,
"Sales": 4444.54,
"Order Date": "9/3/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Gift Ideas Corp.",
"Phone": 2035554407,
"Address Line 1": "2440 Pompton St.",
"Address Line 2": "",
"City": "Glendale",
"State": "CT",
"Postal Code": 97561,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Lewis",
"Contact First Name": "Dan",
"Deal Size": "Medium"
},
{
"Order Number": 10159,
"Quantity": 32,
"Price": 100,
"Order Line Number": 7,
"Sales": 4618.88,
"Order Date": "10/10/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Corporate Gift Ideas Co.",
"Phone": 6505551386,
"Address Line 1": "7734 Strong St.",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10169,
"Quantity": 33,
"Price": 100,
"Order Line Number": 7,
"Sales": 4910.4,
"Order Date": "11/4/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Medium"
},
{
"Order Number": 10180,
"Quantity": 44,
"Price": 100,
"Order Line Number": 2,
"Sales": 5565.12,
"Order Date": "11/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Daedalus Designs Imports",
"Phone": "20.16.1555",
"Address Line 1": "184, chausse de Tournai",
"Address Line 2": "",
"City": "Lille",
"State": "",
"Postal Code": 59000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Rance",
"Contact First Name": "Martine",
"Deal Size": "Medium"
},
{
"Order Number": 10191,
"Quantity": 32,
"Price": 100,
"Order Line Number": 8,
"Sales": 4237.76,
"Order Date": "11/20/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Toms Spezialitten, Ltd",
"Phone": "0221-5554327",
"Address Line 1": "Mehrheimerstr. 369",
"Address Line 2": "",
"City": "Koln",
"State": "",
"Postal Code": 50739,
"Country": "Germany",
"Territory": "EMEA",
"Contact Last Name": "Pfalzheim",
"Contact First Name": "Henriette",
"Deal Size": "Medium"
},
{
"Order Number": 10211,
"Quantity": 41,
"Price": 100,
"Order Line Number": 7,
"Sales": 5673.58,
"Order Date": "1/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Auto Canal Petit",
"Phone": "(1) 47.55.6555",
"Address Line 1": "25, rue Lauriston",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75016,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Perrier",
"Contact First Name": "Dominique",
"Deal Size": "Medium"
},
{
"Order Number": 10225,
"Quantity": 35,
"Price": 100,
"Order Line Number": 14,
"Sales": 5260.15,
"Order Date": "2/22/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Vida Sport, Ltd",
"Phone": "0897-034555",
"Address Line 1": "Grenzacherweg 237",
"Address Line 2": "",
"City": "Gensve",
"State": "",
"Postal Code": 1203,
"Country": "Switzerland",
"Territory": "EMEA",
"Contact Last Name": "Holz",
"Contact First Name": "Michael",
"Deal Size": "Medium"
},
{
"Order Number": 10238,
"Quantity": 44,
"Price": 100,
"Order Line Number": 8,
"Sales": 6350.96,
"Order Date": "4/9/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Danish Wholesale Imports",
"Phone": "31 12 3555",
"Address Line 1": "Vinb'ltet 34",
"Address Line 2": "",
"City": "Kobenhavn",
"State": "",
"Postal Code": 1734,
"Country": "Denmark",
"Territory": "EMEA",
"Contact Last Name": "Petersen",
"Contact First Name": "Jytte",
"Deal Size": "Medium"
},
{
"Order Number": 10252,
"Quantity": 26,
"Price": 100,
"Order Line Number": 4,
"Sales": 3559.4,
"Order Date": "5/26/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Auto Canal Petit",
"Phone": "(1) 47.55.6555",
"Address Line 1": "25, rue Lauriston",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75016,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Perrier",
"Contact First Name": "Dominique",
"Deal Size": "Medium"
},
{
"Order Number": 10264,
"Quantity": 20,
"Price": 100,
"Order Line Number": 2,
"Sales": 2410.6,
"Order Date": "6/30/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Gifts4AllAges.com",
"Phone": 6175559555,
"Address Line 1": "8616 Spinnaker Dr.",
"Address Line 2": "",
"City": "Boston",
"State": "MA",
"Postal Code": 51003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yoshido",
"Contact First Name": "Juri",
"Deal Size": "Small"
},
{
"Order Number": 10276,
"Quantity": 48,
"Price": 100,
"Order Line Number": 8,
"Sales": 5713.92,
"Order Date": "8/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Online Mini Collectables",
"Phone": 6175557555,
"Address Line 1": "7635 Spinnaker Dr.",
"Address Line 2": "",
"City": "Brickhaven",
"State": "MA",
"Postal Code": 58339,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Barajas",
"Contact First Name": "Miguel",
"Deal Size": "Medium"
},
{
"Order Number": 10287,
"Quantity": 34,
"Price": 100,
"Order Line Number": 17,
"Sales": 4300.32,
"Order Date": "8/30/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Vida Sport, Ltd",
"Phone": "0897-034555",
"Address Line 1": "Grenzacherweg 237",
"Address Line 2": "",
"City": "Gensve",
"State": "",
"Postal Code": 1203,
"Country": "Switzerland",
"Territory": "EMEA",
"Contact Last Name": "Holz",
"Contact First Name": "Michael",
"Deal Size": "Medium"
},
{
"Order Number": 10299,
"Quantity": 49,
"Price": 100,
"Order Line Number": 2,
"Sales": 7947.31,
"Order Date": "9/30/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Toys of Finland, Co.",
"Phone": "90-224 8555",
"Address Line 1": "Keskuskatu 45",
"Address Line 2": "",
"City": "Helsinki",
"State": "",
"Postal Code": 21240,
"Country": "Finland",
"Territory": "EMEA",
"Contact Last Name": "Karttunen",
"Contact First Name": "Matti",
"Deal Size": "Large"
},
{
"Order Number": 10310,
"Quantity": 40,
"Price": 100,
"Order Line Number": 15,
"Sales": 5356.8,
"Order Date": "10/16/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Toms Spezialitten, Ltd",
"Phone": "0221-5554327",
"Address Line 1": "Mehrheimerstr. 369",
"Address Line 2": "",
"City": "Koln",
"State": "",
"Postal Code": 50739,
"Country": "Germany",
"Territory": "EMEA",
"Contact Last Name": "Pfalzheim",
"Contact First Name": "Henriette",
"Deal Size": "Medium"
},
{
"Order Number": 10319,
"Quantity": 45,
"Price": 100,
"Order Line Number": 3,
"Sales": 7901.1,
"Order Date": "11/3/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Microscale Inc.",
"Phone": 2125551957,
"Address Line 1": "5290 North Pendale Street",
"Address Line 2": "Suite 200",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Kuo",
"Contact First Name": "Kee",
"Deal Size": "Large"
},
{
"Order Number": 10330,
"Quantity": 50,
"Price": 100,
"Order Line Number": 4,
"Sales": 6101,
"Order Date": "11/16/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Cruz & Sons Co.",
"Phone": "+63 2 555 3587",
"Address Line 1": "15 McCallum Street - NatWest Center #13-03",
"Address Line 2": "",
"City": "Makati City",
"State": "",
"Postal Code": "1227 MM",
"Country": "Philippines",
"Territory": "Japan",
"Contact Last Name": "Cruz",
"Contact First Name": "Arnold",
"Deal Size": "Medium"
},
{
"Order Number": 10342,
"Quantity": 38,
"Price": 100,
"Order Line Number": 11,
"Sales": 6276.46,
"Order Date": "11/24/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Medium"
},
{
"Order Number": 10355,
"Quantity": 25,
"Price": 100,
"Order Line Number": 2,
"Sales": 4203.5,
"Order Date": "12/7/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10363,
"Quantity": 28,
"Price": 58.18,
"Order Line Number": 13,
"Sales": 1629.04,
"Order Date": "1/6/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Suominen Souveniers",
"Phone": "+358 9 8045 555",
"Address Line 1": "Software Engineering Center, SEC Oy",
"Address Line 2": "",
"City": "Espoo",
"State": "",
"Postal Code": "FIN-02271",
"Country": "Finland",
"Territory": "EMEA",
"Contact Last Name": "Suominen",
"Contact First Name": "Kalle",
"Deal Size": "Small"
},
{
"Order Number": 10378,
"Quantity": 49,
"Price": 67.14,
"Order Line Number": 8,
"Sales": 3289.86,
"Order Date": "2/10/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10390,
"Quantity": 49,
"Price": 100,
"Order Line Number": 3,
"Sales": 6862.94,
"Order Date": "3/4/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 148,
"Product Code": "S18_4721",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10110,
"Quantity": 42,
"Price": 61.29,
"Order Line Number": 9,
"Sales": 2574.18,
"Order Date": "3/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Small"
},
{
"Order Number": 10124,
"Quantity": 23,
"Price": 57.73,
"Order Line Number": 8,
"Sales": 1327.79,
"Order Date": "5/21/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Signal Gift Stores",
"Phone": 7025551838,
"Address Line 1": "8489 Strong St.",
"Address Line 2": "",
"City": "Las Vegas",
"State": "NV",
"Postal Code": 83030,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Sue",
"Deal Size": "Small"
},
{
"Order Number": 10148,
"Quantity": 29,
"Price": 81.25,
"Order Line Number": 2,
"Sales": 2356.25,
"Order Date": "9/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Small"
},
{
"Order Number": 10161,
"Quantity": 25,
"Price": 80.54,
"Order Line Number": 1,
"Sales": 2013.5,
"Order Date": "10/17/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Heintze Collectables",
"Phone": "86 21 3555",
"Address Line 1": "Smagsloget 45",
"Address Line 2": "",
"City": "Aaarhus",
"State": "",
"Postal Code": 8200,
"Country": "Denmark",
"Territory": "EMEA",
"Contact Last Name": "Ibsen",
"Contact First Name": "Palle",
"Deal Size": "Small"
},
{
"Order Number": 10173,
"Quantity": 39,
"Price": 71.98,
"Order Line Number": 15,
"Sales": 2807.22,
"Order Date": "11/5/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Rovelli Gifts",
"Phone": "035-640555",
"Address Line 1": "Via Ludovico il Moro 22",
"Address Line 2": "",
"City": "Bergamo",
"State": "",
"Postal Code": 24100,
"Country": "Italy",
"Territory": "EMEA",
"Contact Last Name": "Rovelli",
"Contact First Name": "Giovanni",
"Deal Size": "Small"
},
{
"Order Number": 10182,
"Quantity": 44,
"Price": 69.84,
"Order Line Number": 12,
"Sales": 3072.96,
"Order Date": "11/12/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10193,
"Quantity": 25,
"Price": 76.26,
"Order Line Number": 16,
"Sales": 1906.5,
"Order Date": "11/21/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Australian Collectables, Ltd",
"Phone": "61-9-3844-6555",
"Address Line 1": "7 Allen Street",
"Address Line 2": "",
"City": "Glen Waverly",
"State": "Victoria",
"Postal Code": 3150,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Connery",
"Contact First Name": "Sean",
"Deal Size": "Small"
},
{
"Order Number": 10204,
"Quantity": 45,
"Price": 76.26,
"Order Line Number": 6,
"Sales": 3431.7,
"Order Date": "12/2/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Muscle Machine Inc",
"Phone": 2125557413,
"Address Line 1": "4092 Furth Circle",
"Address Line 2": "Suite 400",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Jeff",
"Deal Size": "Medium"
},
{
"Order Number": 10213,
"Quantity": 25,
"Price": 83.39,
"Order Line Number": 2,
"Sales": 2084.75,
"Order Date": "1/22/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Double Decker Gift Stores, Ltd",
"Phone": "(171) 555-7555",
"Address Line 1": "120 Hanover Sq.",
"Address Line 2": "",
"City": "London",
"State": "",
"Postal Code": "WA1 1DP",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Hardy",
"Contact First Name": "Thomas",
"Deal Size": "Small"
},
{
"Order Number": 10227,
"Quantity": 37,
"Price": 57.73,
"Order Line Number": 12,
"Sales": 2136.01,
"Order Date": "3/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Saveley & Henriot, Co.",
"Phone": "78.32.5555",
"Address Line 1": "2, rue du Commerce",
"Address Line 2": "",
"City": "Lyon",
"State": "",
"Postal Code": 69004,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Saveley",
"Contact First Name": "Mary",
"Deal Size": "Small"
},
{
"Order Number": 10241,
"Quantity": 30,
"Price": 66.99,
"Order Line Number": 4,
"Sales": 2009.7,
"Order Date": "4/13/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Mini Caravy",
"Phone": "88.60.1555",
"Address Line 1": "24, place Kluber",
"Address Line 2": "",
"City": "Strasbourg",
"State": "",
"Postal Code": 67000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Citeaux",
"Contact First Name": "Frederique",
"Deal Size": "Small"
},
{
"Order Number": 10267,
"Quantity": 36,
"Price": 75.55,
"Order Line Number": 1,
"Sales": 2719.8,
"Order Date": "7/7/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Muscle Machine Inc",
"Phone": 2125557413,
"Address Line 1": "4092 Furth Circle",
"Address Line 2": "Suite 400",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Jeff",
"Deal Size": "Small"
},
{
"Order Number": 10279,
"Quantity": 26,
"Price": 60.58,
"Order Line Number": 1,
"Sales": 1575.08,
"Order Date": "8/9/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10288,
"Quantity": 23,
"Price": 73.41,
"Order Line Number": 7,
"Sales": 1688.43,
"Order Date": "9/1/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Handji Gifts& Co",
"Phone": "+65 224 1555",
"Address Line 1": "Village Close - 106 Linden Road Sandown",
"Address Line 2": "2nd Floor",
"City": "Singapore",
"State": "",
"Postal Code": 69045,
"Country": "Singapore",
"Territory": "APAC",
"Contact Last Name": "Victorino",
"Contact First Name": "Wendy",
"Deal Size": "Small"
},
{
"Order Number": 10302,
"Quantity": 23,
"Price": 72.7,
"Order Line Number": 3,
"Sales": 1672.1,
"Order Date": "10/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "UK Collectables, Ltd.",
"Phone": "(171) 555-2282",
"Address Line 1": "Berkeley Gardens 12 Brewery",
"Address Line 2": "",
"City": "Liverpool",
"State": "",
"Postal Code": "WX1 6LT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Devon",
"Contact First Name": "Elizabeth",
"Deal Size": "Small"
},
{
"Order Number": 10311,
"Quantity": 25,
"Price": 66.99,
"Order Line Number": 2,
"Sales": 1674.75,
"Order Date": "10/16/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10332,
"Quantity": 21,
"Price": 100,
"Order Line Number": 3,
"Sales": 3472.98,
"Order Date": "11/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Medium"
},
{
"Order Number": 10344,
"Quantity": 26,
"Price": 63.43,
"Order Line Number": 5,
"Sales": 1649.18,
"Order Date": "11/25/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Marseille Mini Autos",
"Phone": "91.24.4555",
"Address Line 1": "12, rue des Bouchers",
"Address Line 2": "",
"City": "Marseille",
"State": "",
"Postal Code": 13008,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Lebihan",
"Contact First Name": "Laurence",
"Deal Size": "Small"
},
{
"Order Number": 10367,
"Quantity": 44,
"Price": 85.25,
"Order Line Number": 9,
"Sales": 3751,
"Order Date": "1/12/2018 0:00",
"Status": "Resolved",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Toys4GrownUps.com",
"Phone": 6265557265,
"Address Line 1": "78934 Hillside Dr.",
"Address Line 2": "",
"City": "Pasadena",
"State": "CA",
"Postal Code": 90003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10380,
"Quantity": 24,
"Price": 100,
"Order Line Number": 2,
"Sales": 4536,
"Order Date": "2/16/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10407,
"Quantity": 66,
"Price": 66.99,
"Order Line Number": 4,
"Sales": 4421.34,
"Order Date": "4/22/2018 0:00",
"Status": "On Hold",
"Quarter ": 2,
"Month": 4,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "The Sharp Gifts Warehouse",
"Phone": 4085553659,
"Address Line 1": "3086 Ingle Ln.",
"Address Line 2": "",
"City": "San Jose",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Sue",
"Deal Size": "Medium"
},
{
"Order Number": 10420,
"Quantity": 36,
"Price": 57.73,
"Order Line Number": 7,
"Sales": 2078.28,
"Order Date": "5/29/2018 0:00",
"Status": "In Process",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 71,
"Product Code": "S18_4933",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Small"
},
{
"Order Number": 10110,
"Quantity": 36,
"Price": 85.25,
"Order Line Number": 13,
"Sales": 3069,
"Order Date": "3/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Medium"
},
{
"Order Number": 10124,
"Quantity": 22,
"Price": 77.9,
"Order Line Number": 12,
"Sales": 1713.8,
"Order Date": "5/21/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Signal Gift Stores",
"Phone": 7025551838,
"Address Line 1": "8489 Strong St.",
"Address Line 2": "",
"City": "Las Vegas",
"State": "NV",
"Postal Code": 83030,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Sue",
"Deal Size": "Small"
},
{
"Order Number": 10148,
"Quantity": 25,
"Price": 60.26,
"Order Line Number": 6,
"Sales": 1506.5,
"Order Date": "9/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Small"
},
{
"Order Number": 10161,
"Quantity": 37,
"Price": 72.76,
"Order Line Number": 5,
"Sales": 2692.12,
"Order Date": "10/17/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Heintze Collectables",
"Phone": "86 21 3555",
"Address Line 1": "Smagsloget 45",
"Address Line 2": "",
"City": "Aaarhus",
"State": "",
"Postal Code": 8200,
"Country": "Denmark",
"Territory": "EMEA",
"Contact Last Name": "Ibsen",
"Contact First Name": "Palle",
"Deal Size": "Small"
},
{
"Order Number": 10172,
"Quantity": 32,
"Price": 75.69,
"Order Line Number": 3,
"Sales": 2422.08,
"Order Date": "11/5/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Gift Depot Inc.",
"Phone": 2035552570,
"Address Line 1": "25593 South Bay Ln.",
"Address Line 2": "",
"City": "Bridgewater",
"State": "CT",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Julie",
"Deal Size": "Small"
},
{
"Order Number": 10182,
"Quantity": 47,
"Price": 74.22,
"Order Line Number": 16,
"Sales": 3488.34,
"Order Date": "11/12/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Medium"
},
{
"Order Number": 10192,
"Quantity": 37,
"Price": 69.82,
"Order Line Number": 4,
"Sales": 2583.34,
"Order Date": "11/20/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Online Diecast Creations Co.",
"Phone": 6035558647,
"Address Line 1": "2304 Long Airport Avenue",
"Address Line 2": "",
"City": "Nashua",
"State": "NH",
"Postal Code": 62018,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10204,
"Quantity": 20,
"Price": 62.47,
"Order Line Number": 10,
"Sales": 1249.4,
"Order Date": "12/2/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Muscle Machine Inc",
"Phone": 2125557413,
"Address Line 1": "4092 Furth Circle",
"Address Line 2": "Suite 400",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Jeff",
"Deal Size": "Small"
},
{
"Order Number": 10212,
"Quantity": 41,
"Price": 82.31,
"Order Line Number": 3,
"Sales": 3374.71,
"Order Date": "1/16/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10226,
"Quantity": 21,
"Price": 60.26,
"Order Line Number": 1,
"Sales": 1265.46,
"Order Date": "2/26/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Collectable Mini Designs Co.",
"Phone": 7605558146,
"Address Line 1": "361 Furth Circle",
"Address Line 2": "",
"City": "San Diego",
"State": "CA",
"Postal Code": 91217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Thompson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10241,
"Quantity": 22,
"Price": 76.43,
"Order Line Number": 8,
"Sales": 1681.46,
"Order Date": "4/13/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Mini Caravy",
"Phone": "88.60.1555",
"Address Line 1": "24, place Kluber",
"Address Line 2": "",
"City": "Strasbourg",
"State": "",
"Postal Code": 67000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Citeaux",
"Contact First Name": "Frederique",
"Deal Size": "Small"
},
{
"Order Number": 10267,
"Quantity": 40,
"Price": 80.1,
"Order Line Number": 5,
"Sales": 3204,
"Order Date": "7/7/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Muscle Machine Inc",
"Phone": 2125557413,
"Address Line 1": "4092 Furth Circle",
"Address Line 2": "Suite 400",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Jeff",
"Deal Size": "Medium"
},
{
"Order Number": 10279,
"Quantity": 32,
"Price": 74.96,
"Order Line Number": 5,
"Sales": 2398.72,
"Order Date": "8/9/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10288,
"Quantity": 36,
"Price": 66.14,
"Order Line Number": 11,
"Sales": 2381.04,
"Order Date": "9/1/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Handji Gifts& Co",
"Phone": "+65 224 1555",
"Address Line 1": "Village Close - 106 Linden Road Sandown",
"Address Line 2": "2nd Floor",
"City": "Singapore",
"State": "",
"Postal Code": 69045,
"Country": "Singapore",
"Territory": "APAC",
"Contact Last Name": "Victorino",
"Contact First Name": "Wendy",
"Deal Size": "Small"
},
{
"Order Number": 10301,
"Quantity": 27,
"Price": 72.02,
"Order Line Number": 1,
"Sales": 1944.54,
"Order Date": "10/5/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Norway Gifts By Mail, Co.",
"Phone": "+47 2212 1555",
"Address Line 1": "Drammensveien 126 A, PB 744 Sentrum",
"Address Line 2": "",
"City": "Oslo",
"State": "",
"Postal Code": "N 0106",
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Klaeboe",
"Contact First Name": "Jan",
"Deal Size": "Small"
},
{
"Order Number": 10311,
"Quantity": 26,
"Price": 87.45,
"Order Line Number": 6,
"Sales": 2273.7,
"Order Date": "10/16/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10321,
"Quantity": 30,
"Price": 70.55,
"Order Line Number": 3,
"Sales": 2116.5,
"Order Date": "11/4/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "FunGiftIdeas.com",
"Phone": 5085552555,
"Address Line 1": "1785 First Street",
"Address Line 2": "",
"City": "New Bedford",
"State": "MA",
"Postal Code": 50553,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Benitez",
"Contact First Name": "Violeta",
"Deal Size": "Small"
},
{
"Order Number": 10332,
"Quantity": 23,
"Price": 56.84,
"Order Line Number": 4,
"Sales": 1307.32,
"Order Date": "11/17/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Small"
},
{
"Order Number": 10344,
"Quantity": 29,
"Price": 59.53,
"Order Line Number": 7,
"Sales": 1726.37,
"Order Date": "11/25/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Marseille Mini Autos",
"Phone": "91.24.4555",
"Address Line 1": "12, rue des Bouchers",
"Address Line 2": "",
"City": "Marseille",
"State": "",
"Postal Code": 13008,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Lebihan",
"Contact First Name": "Laurence",
"Deal Size": "Small"
},
{
"Order Number": 10367,
"Quantity": 21,
"Price": 60.37,
"Order Line Number": 10,
"Sales": 1267.77,
"Order Date": "1/12/2018 0:00",
"Status": "Resolved",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Toys4GrownUps.com",
"Phone": 6265557265,
"Address Line 1": "78934 Hillside Dr.",
"Address Line 2": "",
"City": "Pasadena",
"State": "CA",
"Postal Code": 90003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Julie",
"Deal Size": "Small"
},
{
"Order Number": 10380,
"Quantity": 34,
"Price": 100,
"Order Line Number": 3,
"Sales": 3441.82,
"Order Date": "2/16/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10407,
"Quantity": 26,
"Price": 76.43,
"Order Line Number": 8,
"Sales": 1987.18,
"Order Date": "4/22/2018 0:00",
"Status": "On Hold",
"Quarter ": 2,
"Month": 4,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "The Sharp Gifts Warehouse",
"Phone": 4085553659,
"Address Line 1": "3086 Ingle Ln.",
"Address Line 2": "",
"City": "San Jose",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Sue",
"Deal Size": "Small"
},
{
"Order Number": 10420,
"Quantity": 60,
"Price": 64.67,
"Order Line Number": 11,
"Sales": 3880.2,
"Order Date": "5/29/2018 0:00",
"Status": "In Process",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 73,
"Product Code": "S24_1046",
"Customer Name": "Souveniers And Things Co.",
"Phone": "+61 2 9495 8555",
"Address Line 1": "Monitor Money Building, 815 Pacific Hwy",
"Address Line 2": "Level 6",
"City": "Chatswood",
"State": "NSW",
"Postal Code": 2067,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Huxley",
"Contact First Name": "Adrian",
"Deal Size": "Medium"
},
{
"Order Number": 10104,
"Quantity": 35,
"Price": 55.49,
"Order Line Number": 6,
"Sales": 1942.15,
"Order Date": "1/31/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10115,
"Quantity": 47,
"Price": 69.36,
"Order Line Number": 2,
"Sales": 3259.92,
"Order Date": "4/4/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Classic Legends Inc.",
"Phone": 2125558493,
"Address Line 1": "5905 Pompton St.",
"Address Line 2": "Suite 750",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Maria",
"Deal Size": "Medium"
},
{
"Order Number": 10127,
"Quantity": 20,
"Price": 60.69,
"Order Line Number": 8,
"Sales": 1213.8,
"Order Date": "6/3/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Muscle Machine Inc",
"Phone": 2125557413,
"Address Line 1": "4092 Furth Circle",
"Address Line 2": "Suite 400",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Jeff",
"Deal Size": "Small"
},
{
"Order Number": 10141,
"Quantity": 20,
"Price": 54.33,
"Order Line Number": 2,
"Sales": 1086.6,
"Order Date": "8/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Suominen Souveniers",
"Phone": "+358 9 8045 555",
"Address Line 1": "Software Engineering Center, SEC Oy",
"Address Line 2": "",
"City": "Espoo",
"State": "",
"Postal Code": "FIN-02271",
"Country": "Finland",
"Territory": "EMEA",
"Contact Last Name": "Suominen",
"Contact First Name": "Kalle",
"Deal Size": "Small"
},
{
"Order Number": 10152,
"Quantity": 25,
"Price": 65.31,
"Order Line Number": 4,
"Sales": 1632.75,
"Order Date": "9/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Australian Gift Network, Co",
"Phone": "61-7-3844-6555",
"Address Line 1": "31 Duncan St. West End",
"Address Line 2": "",
"City": "South Brisbane",
"State": "Queensland",
"Postal Code": 4101,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Calaghan",
"Contact First Name": "Tony",
"Deal Size": "Small"
},
{
"Order Number": 10165,
"Quantity": 25,
"Price": 69.36,
"Order Line Number": 9,
"Sales": 1734,
"Order Date": "10/22/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Dragon Souveniers, Ltd.",
"Phone": "+65 221 7555",
"Address Line 1": "Bronz Sok., Bronz Apt. 3/6 Tesvikiye",
"Address Line 2": "",
"City": "Singapore",
"State": "",
"Postal Code": 79903,
"Country": "Singapore",
"Territory": "Japan",
"Contact Last Name": "Natividad",
"Contact First Name": "Eric",
"Deal Size": "Small"
},
{
"Order Number": 10176,
"Quantity": 27,
"Price": 68.78,
"Order Line Number": 8,
"Sales": 1857.06,
"Order Date": "11/6/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "L'ordine Souveniers",
"Phone": "0522-556555",
"Address Line 1": "Strada Provinciale 124",
"Address Line 2": "",
"City": "Reggio Emilia",
"State": "",
"Postal Code": 42100,
"Country": "Italy",
"Territory": "EMEA",
"Contact Last Name": "Moroni",
"Contact First Name": "Maurizio",
"Deal Size": "Small"
},
{
"Order Number": 10184,
"Quantity": 31,
"Price": 60.11,
"Order Line Number": 3,
"Sales": 1863.41,
"Order Date": "11/14/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Iberia Gift Imports, Corp.",
"Phone": "(95) 555 82 82",
"Address Line 1": "C/ Romero, 33",
"Address Line 2": "",
"City": "Sevilla",
"State": "",
"Postal Code": 41101,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Roel",
"Contact First Name": "Jose Pedro",
"Deal Size": "Small"
},
{
"Order Number": 10195,
"Quantity": 44,
"Price": 66.47,
"Order Line Number": 3,
"Sales": 2924.68,
"Order Date": "11/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Mini Classics",
"Phone": 9145554562,
"Address Line 1": "3758 North Pendale Street",
"Address Line 2": "",
"City": "White Plains",
"State": "NY",
"Postal Code": 24067,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Steve",
"Deal Size": "Small"
},
{
"Order Number": 10207,
"Quantity": 49,
"Price": 46.82,
"Order Line Number": 4,
"Sales": 2294.18,
"Order Date": "12/9/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Diecast Collectables",
"Phone": 6175552555,
"Address Line 1": "6251 Ingle Ln.",
"Address Line 2": "",
"City": "Boston",
"State": "MA",
"Postal Code": 51003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Franco",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10220,
"Quantity": 26,
"Price": 56.07,
"Order Line Number": 8,
"Sales": 1457.82,
"Order Date": "2/12/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Clover Collections, Co.",
"Phone": "+353 1862 1555",
"Address Line 1": "25 Maiden Lane",
"Address Line 2": "Floor No. 4",
"City": "Dublin",
"State": "",
"Postal Code": 2,
"Country": "Ireland",
"Territory": "EMEA",
"Contact Last Name": "Cassidy",
"Contact First Name": "Dean",
"Deal Size": "Small"
},
{
"Order Number": 10230,
"Quantity": 36,
"Price": 54.33,
"Order Line Number": 6,
"Sales": 1955.88,
"Order Date": "3/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Blauer See Auto, Co.",
"Phone": "+49 69 66 90 2555",
"Address Line 1": "Lyonerstr. 34",
"Address Line 2": "",
"City": "Frankfurt",
"State": "",
"Postal Code": 60528,
"Country": "Germany",
"Territory": "EMEA",
"Contact Last Name": "Keitel",
"Contact First Name": "Roland",
"Deal Size": "Small"
},
{
"Order Number": 10246,
"Quantity": 44,
"Price": 52.6,
"Order Line Number": 2,
"Sales": 2314.4,
"Order Date": "5/5/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10259,
"Quantity": 28,
"Price": 46.82,
"Order Line Number": 1,
"Sales": 1310.96,
"Order Date": "6/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Handji Gifts& Co",
"Phone": "+65 224 1555",
"Address Line 1": "Village Close - 106 Linden Road Sandown",
"Address Line 2": "2nd Floor",
"City": "Singapore",
"State": "",
"Postal Code": 69045,
"Country": "Singapore",
"Territory": "APAC",
"Contact Last Name": "Victorino",
"Contact First Name": "Wendy",
"Deal Size": "Small"
},
{
"Order Number": 10271,
"Quantity": 45,
"Price": 64.74,
"Order Line Number": 2,
"Sales": 2913.3,
"Order Date": "7/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10282,
"Quantity": 29,
"Price": 46.82,
"Order Line Number": 11,
"Sales": 1357.78,
"Order Date": "8/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10292,
"Quantity": 40,
"Price": 53.75,
"Order Line Number": 5,
"Sales": 2150,
"Order Date": "9/8/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Small"
},
{
"Order Number": 10305,
"Quantity": 45,
"Price": 61.85,
"Order Line Number": 2,
"Sales": 2783.25,
"Order Date": "10/13/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Marta's Replicas Co.",
"Phone": 6175558555,
"Address Line 1": "39323 Spinnaker Dr.",
"Address Line 2": "",
"City": "Cambridge",
"State": "MA",
"Postal Code": 51247,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Marta",
"Deal Size": "Small"
},
{
"Order Number": 10314,
"Quantity": 44,
"Price": 53.18,
"Order Line Number": 11,
"Sales": 2339.92,
"Order Date": "10/22/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Heintze Collectables",
"Phone": "86 21 3555",
"Address Line 1": "Smagsloget 45",
"Address Line 2": "",
"City": "Aaarhus",
"State": "",
"Postal Code": 8200,
"Country": "Denmark",
"Territory": "EMEA",
"Contact Last Name": "Ibsen",
"Contact First Name": "Palle",
"Deal Size": "Small"
},
{
"Order Number": 10324,
"Quantity": 25,
"Price": 69.16,
"Order Line Number": 14,
"Sales": 1729,
"Order Date": "11/5/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Vitachrome Inc.",
"Phone": 2125551500,
"Address Line 1": "2678 Kingston Rd.",
"Address Line 2": "Suite 101",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Michael",
"Deal Size": "Small"
},
{
"Order Number": 10336,
"Quantity": 45,
"Price": 100,
"Order Line Number": 4,
"Sales": 5972.4,
"Order Date": "11/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "La Corne D'abondance, Co.",
"Phone": "(1) 42.34.2555",
"Address Line 1": "265, boulevard Charonne",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75012,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Bertrand",
"Contact First Name": "Marie",
"Deal Size": "Medium"
},
{
"Order Number": 10349,
"Quantity": 48,
"Price": 47.4,
"Order Line Number": 4,
"Sales": 2275.2,
"Order Date": "12/1/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Muscle Machine Inc",
"Phone": 2125557413,
"Address Line 1": "4092 Furth Circle",
"Address Line 2": "Suite 400",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Jeff",
"Deal Size": "Small"
},
{
"Order Number": 10358,
"Quantity": 44,
"Price": 60.76,
"Order Line Number": 14,
"Sales": 2673.44,
"Order Date": "12/10/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2017,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10371,
"Quantity": 25,
"Price": 97.27,
"Order Line Number": 12,
"Sales": 2431.75,
"Order Date": "1/23/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Mini Gifts Distributors Ltd.",
"Phone": 4155551450,
"Address Line 1": "5677 Strong St.",
"Address Line 2": "",
"City": "San Rafael",
"State": "CA",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Nelson",
"Contact First Name": "Valarie",
"Deal Size": "Small"
},
{
"Order Number": 10383,
"Quantity": 22,
"Price": 91.76,
"Order Line Number": 2,
"Sales": 2018.72,
"Order Date": "2/22/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10394,
"Quantity": 31,
"Price": 50.29,
"Order Line Number": 2,
"Sales": 1558.99,
"Order Date": "3/15/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10412,
"Quantity": 21,
"Price": 52.6,
"Order Line Number": 2,
"Sales": 1104.6,
"Order Date": "5/3/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Small"
},
{
"Order Number": 10425,
"Quantity": 55,
"Price": 46.82,
"Order Line Number": 1,
"Sales": 2575.1,
"Order Date": "5/31/2018 0:00",
"Status": "In Process",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Classic Cars",
"MSRP": 57,
"Product Code": "S24_1444",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Small"
},
{
"Order Number": 10107,
"Quantity": 25,
"Price": 100,
"Order Line Number": 3,
"Sales": 2845.75,
"Order Date": "2/24/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Small"
},
{
"Order Number": 10120,
"Quantity": 35,
"Price": 98.05,
"Order Line Number": 1,
"Sales": 3431.75,
"Order Date": "4/29/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Medium"
},
{
"Order Number": 10134,
"Quantity": 35,
"Price": 93.54,
"Order Line Number": 3,
"Sales": 3273.9,
"Order Date": "7/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Lyon Souveniers",
"Phone": "+33 1 46 62 7555",
"Address Line 1": "27 rue du Colonel Pierre Avia",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75508,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Da Cunha",
"Contact First Name": "Daniel",
"Deal Size": "Medium"
},
{
"Order Number": 10145,
"Quantity": 43,
"Price": 95.8,
"Order Line Number": 7,
"Sales": 4119.4,
"Order Date": "8/25/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Toys4GrownUps.com",
"Phone": 6265557265,
"Address Line 1": "78934 Hillside Dr.",
"Address Line 2": "",
"City": "Pasadena",
"State": "CA",
"Postal Code": 90003,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Young",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10159,
"Quantity": 44,
"Price": 100,
"Order Line Number": 15,
"Sales": 5355.68,
"Order Date": "10/10/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Corporate Gift Ideas Co.",
"Phone": 6505551386,
"Address Line 1": "7734 Strong St.",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10168,
"Quantity": 50,
"Price": 100,
"Order Line Number": 2,
"Sales": 5747.5,
"Order Date": "10/28/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Medium"
},
{
"Order Number": 10180,
"Quantity": 48,
"Price": 100,
"Order Line Number": 10,
"Sales": 5355.36,
"Order Date": "11/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Daedalus Designs Imports",
"Phone": "20.16.1555",
"Address Line 1": "184, chausse de Tournai",
"Address Line 2": "",
"City": "Lille",
"State": "",
"Postal Code": 59000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Rance",
"Contact First Name": "Martine",
"Deal Size": "Medium"
},
{
"Order Number": 10188,
"Quantity": 25,
"Price": 100,
"Order Line Number": 2,
"Sales": 2535.75,
"Order Date": "11/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Herkku Gifts",
"Phone": "+47 2267 3215",
"Address Line 1": "Drammen 121, PR 744 Sentrum",
"Address Line 2": "",
"City": "Bergen",
"State": "",
"Postal Code": "N 5804",
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Oeztan",
"Contact First Name": "Veysel",
"Deal Size": "Small"
},
{
"Order Number": 10201,
"Quantity": 39,
"Price": 100,
"Order Line Number": 3,
"Sales": 4351.23,
"Order Date": "12/1/2016 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 12,
"Year": 2016,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Mini Wheels Co.",
"Phone": 6505555787,
"Address Line 1": "5557 North Pendale Street",
"Address Line 2": "",
"City": "San Francisco",
"State": "CA",
"Postal Code": "",
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Murphy",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10211,
"Quantity": 25,
"Price": 90.16,
"Order Line Number": 15,
"Sales": 2254,
"Order Date": "1/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Auto Canal Petit",
"Phone": "(1) 47.55.6555",
"Address Line 1": "25, rue Lauriston",
"Address Line 2": "",
"City": "Paris",
"State": "",
"Postal Code": 75016,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Perrier",
"Contact First Name": "Dominique",
"Deal Size": "Small"
},
{
"Order Number": 10223,
"Quantity": 32,
"Price": 91.29,
"Order Line Number": 2,
"Sales": 2921.28,
"Order Date": "2/20/2017 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Australian Collectors, Co.",
"Phone": "03 9520 4555",
"Address Line 1": "636 St Kilda Road",
"Address Line 2": "Level 3",
"City": "Melbourne",
"State": "Victoria",
"Postal Code": 3004,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Ferguson",
"Contact First Name": "Peter",
"Deal Size": "Small"
},
{
"Order Number": 10237,
"Quantity": 20,
"Price": 100,
"Order Line Number": 8,
"Sales": 2299,
"Order Date": "4/5/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Vitachrome Inc.",
"Phone": 2125551500,
"Address Line 1": "2678 Kingston Rd.",
"Address Line 2": "Suite 101",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Frick",
"Contact First Name": "Michael",
"Deal Size": "Small"
},
{
"Order Number": 10251,
"Quantity": 26,
"Price": 100,
"Order Line Number": 3,
"Sales": 2637.18,
"Order Date": "5/18/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Tekni Collectables Inc.",
"Phone": 2015559350,
"Address Line 1": "7476 Moss Rd.",
"Address Line 2": "",
"City": "Newark",
"State": "NJ",
"Postal Code": 94019,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Brown",
"Contact First Name": "William",
"Deal Size": "Small"
},
{
"Order Number": 10263,
"Quantity": 42,
"Price": 100,
"Order Line Number": 3,
"Sales": 4307.52,
"Order Date": "6/28/2017 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 6,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Gift Depot Inc.",
"Phone": 2035552570,
"Address Line 1": "25593 South Bay Ln.",
"Address Line 2": "",
"City": "Bridgewater",
"State": "CT",
"Postal Code": 97562,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "King",
"Contact First Name": "Julie",
"Deal Size": "Medium"
},
{
"Order Number": 10275,
"Quantity": 21,
"Price": 100,
"Order Line Number": 2,
"Sales": 2153.76,
"Order Date": "7/23/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "La Rochelle Gifts",
"Phone": "40.67.8555",
"Address Line 1": "67, rue des Cinquante Otages",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Labrune",
"Contact First Name": "Janine",
"Deal Size": "Small"
},
{
"Order Number": 10285,
"Quantity": 34,
"Price": 100,
"Order Line Number": 7,
"Sales": 3716.88,
"Order Date": "8/27/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 8,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Marta's Replicas Co.",
"Phone": 6175558555,
"Address Line 1": "39323 Spinnaker Dr.",
"Address Line 2": "",
"City": "Cambridge",
"State": "MA",
"Postal Code": 51247,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hernandez",
"Contact First Name": "Marta",
"Deal Size": "Medium"
},
{
"Order Number": 10299,
"Quantity": 47,
"Price": 100,
"Order Line Number": 10,
"Sales": 5455.76,
"Order Date": "9/30/2017 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Toys of Finland, Co.",
"Phone": "90-224 8555",
"Address Line 1": "Keskuskatu 45",
"Address Line 2": "",
"City": "Helsinki",
"State": "",
"Postal Code": 21240,
"Country": "Finland",
"Territory": "EMEA",
"Contact Last Name": "Karttunen",
"Contact First Name": "Matti",
"Deal Size": "Medium"
},
{
"Order Number": 10309,
"Quantity": 21,
"Price": 100,
"Order Line Number": 6,
"Sales": 2650.62,
"Order Date": "10/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 10,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Baane Mini Imports",
"Phone": "07-98 9555",
"Address Line 1": "Erling Skakkes gate 78",
"Address Line 2": "",
"City": "Stavern",
"State": "",
"Postal Code": 4110,
"Country": "Norway",
"Territory": "EMEA",
"Contact Last Name": "Bergulfsen",
"Contact First Name": "Jonas",
"Deal Size": "Small"
},
{
"Order Number": 10318,
"Quantity": 48,
"Price": 100,
"Order Line Number": 2,
"Sales": 6437.28,
"Order Date": "11/2/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Diecast Classics Inc.",
"Phone": 2155551555,
"Address Line 1": "7586 Pompton St.",
"Address Line 2": "",
"City": "Allentown",
"State": "PA",
"Postal Code": 70267,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kyung",
"Deal Size": "Medium"
},
{
"Order Number": 10329,
"Quantity": 30,
"Price": 87.78,
"Order Line Number": 7,
"Sales": 2633.4,
"Order Date": "11/15/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Land of Toys Inc.",
"Phone": 2125557818,
"Address Line 1": "897 Long Airport Avenue",
"Address Line 2": "",
"City": "NYC",
"State": "NY",
"Postal Code": 10022,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Yu",
"Contact First Name": "Kwai",
"Deal Size": "Small"
},
{
"Order Number": 10339,
"Quantity": 27,
"Price": 84.39,
"Order Line Number": 10,
"Sales": 2278.53,
"Order Date": "11/23/2017 0:00",
"Status": "Shipped",
"Quarter ": 4,
"Month": 11,
"Year": 2017,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Tokyo Collectables, Ltd",
"Phone": "+81 3 3584 0555",
"Address Line 1": "2-2-8 Roppongi",
"Address Line 2": "",
"City": "Minato-ku",
"State": "Tokyo",
"Postal Code": "106-0032",
"Country": "Japan",
"Territory": "Japan",
"Contact Last Name": "Shimamura",
"Contact First Name": "Akiko",
"Deal Size": "Small"
},
{
"Order Number": 10362,
"Quantity": 50,
"Price": 96.92,
"Order Line Number": 2,
"Sales": 4846,
"Order Date": "1/5/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 1,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Technics Stores Inc.",
"Phone": 6505556809,
"Address Line 1": "9408 Furth Circle",
"Address Line 2": "",
"City": "Burlingame",
"State": "CA",
"Postal Code": 94217,
"Country": "USA",
"Territory": "NA",
"Contact Last Name": "Hirano",
"Contact First Name": "Juri",
"Deal Size": "Medium"
},
{
"Order Number": 10374,
"Quantity": 38,
"Price": 100,
"Order Line Number": 6,
"Sales": 4197.1,
"Order Date": "2/2/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 2,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Australian Gift Network, Co",
"Phone": "61-7-3844-6555",
"Address Line 1": "31 Duncan St. West End",
"Address Line 2": "",
"City": "South Brisbane",
"State": "Queensland",
"Postal Code": 4101,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "Calaghan",
"Contact First Name": "Tony",
"Deal Size": "Medium"
},
{
"Order Number": 10389,
"Quantity": 45,
"Price": 100,
"Order Line Number": 1,
"Sales": 4597.65,
"Order Date": "3/3/2018 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Scandinavian Gift Ideas",
"Phone": "0695-34 6555",
"Address Line 1": "?kergatan 24",
"Address Line 2": "",
"City": "Boras",
"State": "",
"Postal Code": "S-844 67",
"Country": "Sweden",
"Territory": "EMEA",
"Contact Last Name": "Larsson",
"Contact First Name": "Maria",
"Deal Size": "Medium"
},
{
"Order Number": 10403,
"Quantity": 46,
"Price": 100,
"Order Line Number": 8,
"Sales": 5287.7,
"Order Date": "4/8/2018 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 4,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "UK Collectables, Ltd.",
"Phone": "(171) 555-2282",
"Address Line 1": "Berkeley Gardens 12 Brewery",
"Address Line 2": "",
"City": "Liverpool",
"State": "",
"Postal Code": "WX1 6LT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Devon",
"Contact First Name": "Elizabeth",
"Deal Size": "Medium"
},
{
"Order Number": 10417,
"Quantity": 35,
"Price": 100,
"Order Line Number": 3,
"Sales": 3550.05,
"Order Date": "5/13/2018 0:00",
"Status": "Disputed",
"Quarter ": 2,
"Month": 5,
"Year": 2018,
"Product Line": "Motorcycles",
"MSRP": 112,
"Product Code": "S24_1578",
"Customer Name": "Euro Shopping Channel",
"Phone": "(91) 555 94 44",
"Address Line 1": "C/ Moralzarzal, 86",
"Address Line 2": "",
"City": "Madrid",
"State": "",
"Postal Code": 28034,
"Country": "Spain",
"Territory": "EMEA",
"Contact Last Name": "Freyre",
"Contact First Name": "Diego",
"Deal Size": "Medium"
},
{
"Order Number": 10110,
"Quantity": 29,
"Price": 59.37,
"Order Line Number": 15,
"Sales": 1721.73,
"Order Date": "3/18/2016 0:00",
"Status": "Shipped",
"Quarter ": 1,
"Month": 3,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 50,
"Product Code": "S24_1628",
"Customer Name": "AV Stores, Co.",
"Phone": "(171) 555-1555",
"Address Line 1": "Fauntleroy Circus",
"Address Line 2": "",
"City": "Manchester",
"State": "",
"Postal Code": "EC2 5NT",
"Country": "UK",
"Territory": "EMEA",
"Contact Last Name": "Ashworth",
"Contact First Name": "Victoria",
"Deal Size": "Small"
},
{
"Order Number": 10123,
"Quantity": 50,
"Price": 59.87,
"Order Line Number": 1,
"Sales": 2993.5,
"Order Date": "5/20/2016 0:00",
"Status": "Shipped",
"Quarter ": 2,
"Month": 5,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 50,
"Product Code": "S24_1628",
"Customer Name": "Atelier graphique",
"Phone": "40.32.2555",
"Address Line 1": "54, rue Royale",
"Address Line 2": "",
"City": "Nantes",
"State": "",
"Postal Code": 44000,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Schmitt",
"Contact First Name": "Carine",
"Deal Size": "Small"
},
{
"Order Number": 10137,
"Quantity": 26,
"Price": 49.81,
"Order Line Number": 1,
"Sales": 1295.06,
"Order Date": "7/10/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 7,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 50,
"Product Code": "S24_1628",
"Customer Name": "Reims Collectables",
"Phone": "26.47.1555",
"Address Line 1": "59 rue de l'Abbaye",
"Address Line 2": "",
"City": "Reims",
"State": "",
"Postal Code": 51100,
"Country": "France",
"Territory": "EMEA",
"Contact Last Name": "Henriot",
"Contact First Name": "Paul",
"Deal Size": "Small"
},
{
"Order Number": 10148,
"Quantity": 47,
"Price": 56.85,
"Order Line Number": 8,
"Sales": 2671.95,
"Order Date": "9/11/2016 0:00",
"Status": "Shipped",
"Quarter ": 3,
"Month": 9,
"Year": 2016,
"Product Line": "Classic Cars",
"MSRP": 50,
"Product Code": "S24_1628",
"Customer Name": "Anna's Decorations, Ltd",
"Phone": "02 9936 8555",
"Address Line 1": "201 Miller Street",
"Address Line 2": "Level 15",
"City": "North Sydney",
"State": "NSW",
"Postal Code": 2060,
"Country": "Australia",
"Territory": "APAC",
"Contact Last Name": "O'Hara",
"Contact First Name": "Anna",
"Deal Size": "Small"
}
]
}
Also see: Tab Triggers