You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 200 }, "api": { "title": "Instrument for Sale_2", "point": { "title": "By Table", "desc": "Each API function returns data by a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/instrument_for_sale_2/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/instrument_for_sale_2/by_table/instrument_x_instrument_specification/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/instrument_for_sale_2/by_table/instrument_x_instrument_specification/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/instrument_for_sale_2/by_table/instrument_x_instrument_specification/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 30, "limit_total": 200, "time": 0.00137999999999999993331722958345153529080562293529510498046875 }, "stats": { "raw_rows": 30, "rows": 30, "rows_total": 3377, "pages_total": 113 }, "struct": { "stem": { "0": "instrument_x_instrument_specification", "1": "instrument", "2": "instrument_specification" }, "leaf": "instrument_x_instrument_specification.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "52": { "instrument_x_instrument_specification.id": 52, "instrument.id": 49, "instrument.ts": "2018-01-02 03:32:04", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62 Piccolo; Grenadilla Body", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,215.00", "instrument.price_without_tax": "$2,272.99", "instrument.sku": "YAM-BO-YPC-62", "instrument.upc": "086792503059", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "This has long been a favorite of professional musicians and can be found in many top orchestras. Characterized by excellent intonation and playability. It features a headjoint and body of carefully seasoned grenadilla for a warm full tone.", "instrument_specification.id": 52, "instrument_specification.ts": "2018-01-02 03:32:04", "instrument_specification.key": "Body Material", "instrument_specification.value": "Grenadilla Wood" }, "53": { "instrument_x_instrument_specification.id": 53, "instrument.id": 49, "instrument.ts": "2018-01-02 03:32:04", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62 Piccolo; Grenadilla Body", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,215.00", "instrument.price_without_tax": "$2,272.99", "instrument.sku": "YAM-BO-YPC-62", "instrument.upc": "086792503059", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "This has long been a favorite of professional musicians and can be found in many top orchestras. Characterized by excellent intonation and playability. It features a headjoint and body of carefully seasoned grenadilla for a warm full tone.", "instrument_specification.id": 53, "instrument_specification.ts": "2018-01-02 03:32:04", "instrument_specification.key": "Headjoint", "instrument_specification.value": "Grenadilla Wood; Conical Bore" }, "56": { "instrument_x_instrument_specification.id": 56, "instrument.id": 49, "instrument.ts": "2018-01-02 03:32:04", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62 Piccolo; Grenadilla Body", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,215.00", "instrument.price_without_tax": "$2,272.99", "instrument.sku": "YAM-BO-YPC-62", "instrument.upc": "086792503059", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "This has long been a favorite of professional musicians and can be found in many top orchestras. Characterized by excellent intonation and playability. It features a headjoint and body of carefully seasoned grenadilla for a warm full tone.", "instrument_specification.id": 56, "instrument_specification.ts": "2018-01-02 03:32:04", "instrument_specification.key": "Plating", "instrument_specification.value": "Silver (keys and posts)" }, "65": { "instrument_x_instrument_specification.id": 65, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 35, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key of", "instrument_specification.value": "C" }, "66": { "instrument_x_instrument_specification.id": 66, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 36, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Body Style", "instrument_specification.value": "Standard" }, "69": { "instrument_x_instrument_specification.id": 69, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 39, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key Material", "instrument_specification.value": "Nickel Silver" }, "70": { "instrument_x_instrument_specification.id": 70, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 40, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Footjoint", "instrument_specification.value": "N/A" }, "72": { "instrument_x_instrument_specification.id": 72, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 42, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Tone Holes", "instrument_specification.value": "Undercut" }, "73": { "instrument_x_instrument_specification.id": 73, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 43, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key System", "instrument_specification.value": "N/A" }, "74": { "instrument_x_instrument_specification.id": 74, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 44, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key Types", "instrument_specification.value": "Concave contoured with ribbed key post" }, "75": { "instrument_x_instrument_specification.id": 75, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 45, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key Mechanism", "instrument_specification.value": "Split E" }, "76": { "instrument_x_instrument_specification.id": 76, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 46, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Spring Type", "instrument_specification.value": "Stainless Steel" }, "77": { "instrument_x_instrument_specification.id": 77, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 47, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Screw Type", "instrument_specification.value": "Straight" }, "78": { "instrument_x_instrument_specification.id": 78, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 48, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Bumper Type", "instrument_specification.value": "Neoprene" }, "64": { "instrument_x_instrument_specification.id": 64, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 49, "instrument_specification.ts": "2018-01-02 03:32:04", "instrument_specification.key": "Level", "instrument_specification.value": "Professional" }, "67": { "instrument_x_instrument_specification.id": 67, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 52, "instrument_specification.ts": "2018-01-02 03:32:04", "instrument_specification.key": "Body Material", "instrument_specification.value": "Grenadilla Wood" }, "71": { "instrument_x_instrument_specification.id": 71, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 56, "instrument_specification.ts": "2018-01-02 03:32:04", "instrument_specification.key": "Plating", "instrument_specification.value": "Silver (keys and posts)" }, "68": { "instrument_x_instrument_specification.id": 68, "instrument.id": 50, "instrument.ts": "2018-01-02 03:32:10", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-62R Piccolo; Wave Cut Headjoint", "instrument.brand": "Yamaha", "instrument.price_rrp": "$3,735.00", "instrument.price_without_tax": "$2,563.99", "instrument.sku": "YAM-BO-YPC-62R", "instrument.upc": "086792958286", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma", "instrument_specification.id": 68, "instrument_specification.ts": "2018-01-02 03:32:10", "instrument_specification.key": "Headjoint", "instrument_specification.value": "" }, "80": { "instrument_x_instrument_specification.id": 80, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 35, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key of", "instrument_specification.value": "C" }, "81": { "instrument_x_instrument_specification.id": 81, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 36, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Body Style", "instrument_specification.value": "Standard" }, "84": { "instrument_x_instrument_specification.id": 84, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 39, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key Material", "instrument_specification.value": "Nickel Silver" }, "85": { "instrument_x_instrument_specification.id": 85, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 40, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Footjoint", "instrument_specification.value": "N/A" }, "87": { "instrument_x_instrument_specification.id": 87, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 42, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Tone Holes", "instrument_specification.value": "Undercut" }, "88": { "instrument_x_instrument_specification.id": 88, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 43, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key System", "instrument_specification.value": "N/A" }, "89": { "instrument_x_instrument_specification.id": 89, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 44, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key Types", "instrument_specification.value": "Concave contoured with ribbed key post" }, "90": { "instrument_x_instrument_specification.id": 90, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 45, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Key Mechanism", "instrument_specification.value": "Split E" }, "91": { "instrument_x_instrument_specification.id": 91, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 46, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Spring Type", "instrument_specification.value": "Stainless Steel" }, "92": { "instrument_x_instrument_specification.id": 92, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 47, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Screw Type", "instrument_specification.value": "Straight" }, "93": { "instrument_x_instrument_specification.id": 93, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 48, "instrument_specification.ts": "2018-01-02 03:31:59", "instrument_specification.key": "Bumper Type", "instrument_specification.value": "Neoprene" }, "82": { "instrument_x_instrument_specification.id": 82, "instrument.id": 51, "instrument.ts": "2018-01-02 03:32:21", "instrument.title": "Yamaha", "instrument.card_title": "Yamaha YPC-81 Handcrafted Piccolo", "instrument.brand": "Yamaha", "instrument.price_rrp": "$4,590.00", "instrument.price_without_tax": "$3,275.99", "instrument.sku": "YAM-BO-YPC-81", "instrument.upc": "086792503066", "instrument.availability": "Usually ships in 4-5 business days.", "instrument.condition": "New", "instrument.feature_1": "Professional", "instrument.feature_2": "Key of C", "instrument.feature_4": "", "instrument.detail_1": "With Case", "instrument.product_description": "", "instrument.features": "", "instrument.specifications_content": "", "instrument.description": "These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.", "instrument_specification.id": 52, "instrument_specification.ts": "2018-01-02 03:32:04", "instrument_specification.key": "Body Material", "instrument_specification.value": "Grenadilla Wood" } } } }