JSON/q

A JSON-based data access specification

Product database

[
    {
        "productId": 1,
        "productName": "Chai",
        "category": "Beverages",
        "unitPrice": 18.00,
        "unitsInStock": 39
    },
    {
        "productId": 2,
        "productName": "Chang",
        "category": "Beverages",
        "unitPrice": 19.00,
        "unitsInStock": 17
    },
    {
        "productId": 3,
        "productName": "Aniseed Syrup",
        "category": "Condiments",
        "unitPrice": 10.00,
        "unitsInStock": 13
    },
    {
        "productId": 4,
        "productName": "Chef Anton's Cajun Seasoning",
        "category": "Condiments",
        "unitPrice": 22.00,
        "unitsInStock": 53
    },
    {
        "productId": 5,
        "productName": "Chef Anton's Gumbo Mix",
        "category": "Condiments",
        "unitPrice": 21.35,
        "unitsInStock": 0
    },
    {
        "productId": 6,
        "productName": "Grandma's Boysenberry Spread",
        "category": "Condiments",
        "unitPrice": 25.00,
        "unitsInStock": 120
    },
    {
        "productId": 7,
        "productName": "Uncle Bob's Organic Dried Pears",
        "category": "Produce",
        "unitPrice": 30.00,
        "unitsInStock": 15
    },
    {
        "productId": 8,
        "productName": "Northwoods Cranberry Sauce",
        "category": "Condiments",
        "unitPrice": 40.00,
        "unitsInStock": 6
    },
    {
        "productId": 9,
        "productName": "Mishi Kobe Niku",
        "category": "Meat/Poultry",
        "unitPrice": 97.00,
        "unitsInStock": 29
    },
    {
        "productId": 10,
        "productName": "Ikura",
        "category": "Seafood",
        "unitPrice": 31.00,
        "unitsInStock": 31
    },
    {
        "productId": 11,
        "productName": "Queso Cabrales",
        "category": "Dairy Products",
        "unitPrice": 21.00,
        "unitsInStock": 22
    },
    {
        "productId": 12,
        "productName": "Queso Manchego La Pastora",
        "category": "Dairy Products",
        "unitPrice": 38.00,
        "unitsInStock": 86
    },
    {
        "productId": 13,
        "productName": "Konbu",
        "category": "Seafood",
        "unitPrice": 6.00,
        "unitsInStock": 24
    },
    {
        "productId": 14,
        "productName": "Tofu",
        "category": "Produce",
        "unitPrice": 23.25,
        "unitsInStock": 35
    },
    {
        "productId": 15,
        "productName": "Genen Shouyu",
        "category": "Condiments",
        "unitPrice": 15.50,
        "unitsInStock": 39
    },
    {
        "productId": 16,
        "productName": "Pavlova",
        "category": "Confections",
        "unitPrice": 17.45,
        "unitsInStock": 29
    },
    {
        "productId": 17,
        "productName": "Alice Mutton",
        "category": "Meat/Poultry",
        "unitPrice": 39.00,
        "unitsInStock": 0
    },
    {
        "productId": 18,
        "productName": "Carnarvon Tigers",
        "category": "Seafood",
        "unitPrice": 62.50,
        "unitsInStock": 42
    },
    {
        "productId": 19,
        "productName": "Teatime Chocolate Biscuits",
        "category": "Confections",
        "unitPrice": 9.20,
        "unitsInStock": 25
    },
    {
        "productId": 20,
        "productName": "Sir Rodney's Marmalade",
        "category": "Confections",
        "unitPrice": 81.00,
        "unitsInStock": 40
    },
    {
        "productId": 21,
        "productName": "Sir Rodney's Scones",
        "category": "Confections",
        "unitPrice": 10.00,
        "unitsInStock": 3
    },
    {
        "productId": 22,
        "productName": "Gustaf's Knäckebröd",
        "category": "Grains/Cereals",
        "unitPrice": 21.00,
        "unitsInStock": 104
    },
    {
        "productId": 23,
        "productName": "Tunnbröd",
        "category": "Grains/Cereals",
        "unitPrice": 9.00,
        "unitsInStock": 61
    },
    {
        "productId": 24,
        "productName": "Guaraná Fantástica",
        "category": "Beverages",
        "unitPrice": 4.50,
        "unitsInStock": 20
    },
    {
        "productId": 25,
        "productName": "NuNuCa Nuß-Nougat-Creme",
        "category": "Confections",
        "unitPrice": 14.00,
        "unitsInStock": 76
    },
    {
        "productId": 26,
        "productName": "Gumbär Gummibärchen",
        "category": "Confections",
        "unitPrice": 31.23,
        "unitsInStock": 15
    },
    {
        "productId": 27,
        "productName": "Schoggi Schokolade",
        "category": "Confections",
        "unitPrice": 43.90,
        "unitsInStock": 49
    },
    {
        "productId": 28,
        "productName": "Rössle Sauerkraut",
        "category": "Produce",
        "unitPrice": 45.60,
        "unitsInStock": 26
    },
    {
        "productId": 29,
        "productName": "Thüringer Rostbratwurst",
        "category": "Meat/Poultry",
        "unitPrice": 123.79,
        "unitsInStock": 0
    },
    {
        "productId": 30,
        "productName": "Nord-Ost Matjeshering",
        "category": "Seafood",
        "unitPrice": 25.89,
        "unitsInStock": 10
    },
    {
        "productId": 31,
        "productName": "Gorgonzola Telino",
        "category": "Dairy Products",
        "unitPrice": 12.50,
        "unitsInStock": 0
    },
    {
        "productId": 32,
        "productName": "Mascarpone Fabioli",
        "category": "Dairy Products",
        "unitPrice": 32.00,
        "unitsInStock": 9
    },
    {
        "productId": 33,
        "productName": "Geitost",
        "category": "Dairy Products",
        "unitPrice": 2.50,
        "unitsInStock": 112
    },
    {
        "productId": 34,
        "productName": "Sasquatch Ale",
        "category": "Beverages",
        "unitPrice": 14.00,
        "unitsInStock": 111
    },
    {
        "productId": 35,
        "productName": "Steeleye Stout",
        "category": "Beverages",
        "unitPrice": 18.00,
        "unitsInStock": 20
    },
    {
        "productId": 36,
        "productName": "Inlagd Sill",
        "category": "Seafood",
        "unitPrice": 19.00,
        "unitsInStock": 112
    },
    {
        "productId": 37,
        "productName": "Gravad lax",
        "category": "Seafood",
        "unitPrice": 26.00,
        "unitsInStock": 11
    },
    {
        "productId": 38,
        "productName": "Côte de Blaye",
        "category": "Beverages",
        "unitPrice": 263.50,
        "unitsInStock": 17
    },
    {
        "productId": 39,
        "productName": "Chartreuse verte",
        "category": "Beverages",
        "unitPrice": 18.00,
        "unitsInStock": 69
    },
    {
        "productId": 40,
        "productName": "Boston Crab Meat",
        "category": "Seafood",
        "unitPrice": 18.40,
        "unitsInStock": 123
    },
    {
        "productId": 41,
        "productName": "Jack's New England Clam Chowder",
        "category": "Seafood",
        "unitPrice": 9.65,
        "unitsInStock": 85
    },
    {
        "productId": 42,
        "productName": "Singaporean Hokkien Fried Mee",
        "category": "Grains/Cereals",
        "unitPrice": 14.00,
        "unitsInStock": 26
    },
    {
        "productId": 43,
        "productName": "Ipoh Coffee",
        "category": "Beverages",
        "unitPrice": 46.00,
        "unitsInStock": 17
    },
    {
        "productId": 44,
        "productName": "Gula Malacca",
        "category": "Condiments",
        "unitPrice": 19.45,
        "unitsInStock": 27
    },
    {
        "productId": 45,
        "productName": "Rogede sild",
        "category": "Seafood",
        "unitPrice": 9.50,
        "unitsInStock": 5
    },
    {
        "productId": 46,
        "productName": "Spegesild",
        "category": "Seafood",
        "unitPrice": 12.00,
        "unitsInStock": 95
    },
    {
        "productId": 47,
        "productName": "Zaanse koeken",
        "category": "Confections",
        "unitPrice": 9.50,
        "unitsInStock": 36
    },
    {
        "productId": 48,
        "productName": "Chocolade",
        "category": "Confections",
        "unitPrice": 12.75,
        "unitsInStock": 15
    },
    {
        "productId": 49,
        "productName": "Maxilaku",
        "category": "Confections",
        "unitPrice": 20.00,
        "unitsInStock": 10
    },
    {
        "productId": 50,
        "productName": "Valkoinen suklaa",
        "category": "Confections",
        "unitPrice": 16.25,
        "unitsInStock": 65
    },
    {
        "productId": 51,
        "productName": "Manjimup Dried Apples",
        "category": "Produce",
        "unitPrice": 53.00,
        "unitsInStock": 20
    },
    {
        "productId": 52,
        "productName": "Filo Mix",
        "category": "Grains/Cereals",
        "unitPrice": 7.00,
        "unitsInStock": 38
    },
    {
        "productId": 53,
        "productName": "Perth Pasties",
        "category": "Meat/Poultry",
        "unitPrice": 32.80,
        "unitsInStock": 0
    },
    {
        "productId": 54,
        "productName": "Tourtière",
        "category": "Meat/Poultry",
        "unitPrice": 7.45,
        "unitsInStock": 21
    },
    {
        "productId": 55,
        "productName": "Pâté chinois",
        "category": "Meat/Poultry",
        "unitPrice": 24.00,
        "unitsInStock": 115
    },
    {
        "productId": 56,
        "productName": "Gnocchi di nonna Alice",
        "category": "Grains/Cereals",
        "unitPrice": 38.00,
        "unitsInStock": 21
    },
    {
        "productId": 57,
        "productName": "Ravioli Angelo",
        "category": "Grains/Cereals",
        "unitPrice": 19.50,
        "unitsInStock": 36
    },
    {
        "productId": 58,
        "productName": "Escargots de Bourgogne",
        "category": "Seafood",
        "unitPrice": 13.25,
        "unitsInStock": 62
    },
    {
        "productId": 59,
        "productName": "Raclette Courdavault",
        "category": "Dairy Products",
        "unitPrice": 55.00,
        "unitsInStock": 79
    },
    {
        "productId": 60,
        "productName": "Camembert Pierrot",
        "category": "Dairy Products",
        "unitPrice": 34.00,
        "unitsInStock": 19
    },
    {
        "productId": 61,
        "productName": "Sirop d'érable",
        "category": "Condiments",
        "unitPrice": 28.50,
        "unitsInStock": 113
    },
    {
        "productId": 62,
        "productName": "Tarte au sucre",
        "category": "Confections",
        "unitPrice": 49.30,
        "unitsInStock": 17
    },
    {
        "productId": 63,
        "productName": "Vegie-spread",
        "category": "Condiments",
        "unitPrice": 43.90,
        "unitsInStock": 24
    },
    {
        "productId": 64,
        "productName": "Wimmers gute Semmelknödel",
        "category": "Grains/Cereals",
        "unitPrice": 33.25,
        "unitsInStock": 22
    },
    {
        "productId": 65,
        "productName": "Louisiana Fiery Hot Pepper Sauce",
        "category": "Condiments",
        "unitPrice": 21.05,
        "unitsInStock": 76
    },
    {
        "productId": 66,
        "productName": "Louisiana Hot Spiced Okra",
        "category": "Condiments",
        "unitPrice": 17.00,
        "unitsInStock": 4
    },
    {
        "productId": 67,
        "productName": "Laughing Lumberjack Lager",
        "category": "Beverages",
        "unitPrice": 14.00,
        "unitsInStock": 52
    },
    {
        "productId": 68,
        "productName": "Scottish Longbreads",
        "category": "Confections",
        "unitPrice": 12.50,
        "unitsInStock": 6
    },
    {
        "productId": 69,
        "productName": "Gudbrandsdalsost",
        "category": "Dairy Products",
        "unitPrice": 36.00,
        "unitsInStock": 26
    },
    {
        "productId": 70,
        "productName": "Outback Lager",
        "category": "Beverages",
        "unitPrice": 15.00,
        "unitsInStock": 15
    },
    {
        "productId": 71,
        "productName": "Flotemysost",
        "category": "Dairy Products",
        "unitPrice": 21.50,
        "unitsInStock": 26
    },
    {
        "productId": 72,
        "productName": "Mozzarella di Giovanni",
        "category": "Dairy Products",
        "unitPrice": 34.80,
        "unitsInStock": 14
    },
    {
        "productId": 73,
        "productName": "Röd Kaviar",
        "category": "Seafood",
        "unitPrice": 15.00,
        "unitsInStock": 101
    },
    {
        "productId": 74,
        "productName": "Longlife Tofu",
        "category": "Produce",
        "unitPrice": 10.00,
        "unitsInStock": 4
    },
    {
        "productId": 75,
        "productName": "Rhönbräu Klosterbier",
        "category": "Beverages",
        "unitPrice": 7.75,
        "unitsInStock": 125
    },
    {
        "productId": 76,
        "productName": "Lakkalikööri",
        "category": "Beverages",
        "unitPrice": 18.00,
        "unitsInStock": 57
    },
    {
        "productId": 77,
        "productName": "Original Frankfurter grüne Soße",
        "category": "Condiments",
        "unitPrice": 13.00,
        "unitsInStock": 32
    }
]