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": "Drug by Category_1", "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/drug_by_category_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/drug_by_category_1/by_table/category_2_x_drug/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/drug_by_category_1/by_table/category_2_x_drug/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/drug_by_category_1/by_table/category_2_x_drug/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 30, "limit_total": 200, "time": 0.0012899999999999999140964934696285126847214996814727783203125 }, "stats": { "raw_rows": 30, "rows": 30, "rows_total": 5181, "pages_total": 173 }, "struct": { "stem": { "0": "category_2_x_drug", "1": "category_2", "2": "category_1", "3": "drug" }, "leaf": "category_2_x_drug.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1678": { "category_2_x_drug.id": 1678, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1678, "drug.ts": "2017-12-19 21:46:44", "drug.title": "$4.36", "drug.sku": 2449148, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Vaseline Petroleum Jelly Cream Deep Moisture - 4.5 ozTemporarily protects minor: Cuts. Scrapes. Burns. Temporarily protects and helps relieve chapped or cracked skin. Helps protect from the drying effects of wind and cold weather. As effective as 100% pur", "drug.current_stock": "" }, "1680": { "category_2_x_drug.id": 1680, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1680, "drug.ts": "2017-12-19 21:46:46", "drug.title": "$10.72", "drug.sku": 1368695, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "NO-AD Kids Continuous Spray SPF 50 - 10 ozHelps prevent sunburn. If used as directed with other sun protection measures (see directions), decreases the risk of skin cancer and early skin aging caused by the sun. Designed for children's active lifestyle. T", "drug.current_stock": "" }, "1681": { "category_2_x_drug.id": 1681, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1681, "drug.ts": "2017-12-19 21:46:49", "drug.title": "$7.06", "drug.sku": 1723501, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Johnson & Johnson Baby Oil - 20 ozOur pure mineral oil creates a silky, protective moisturizing barrier on the skin. It locks in up to 10 times more moisture on wet skin than an ordinary lotion can on dry skin.Directions: Gently massage onto damp skin aft", "drug.current_stock": "" }, "1682": { "category_2_x_drug.id": 1682, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1682, "drug.ts": "2017-12-19 21:46:52", "drug.title": "$3.75", "drug.sku": 3446200, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "ConvaTec Aloe Vesta Protective Ointment - 2 ozTemporarily protects minor: cuts, scrapes, bruises. Temporarily protects and helps relieve chapped or cracked skin and lips. Helps treat and prevent diaper rash. Protects minor skin irritation associated with ", "drug.current_stock": "" }, "1684": { "category_2_x_drug.id": 1684, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1684, "drug.ts": "2017-12-19 21:46:55", "drug.title": "$5.77", "drug.sku": 3499795, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Aveeno Baby Soothing Relief Moisture Cream - 5 ozThis product contains natural colloidal oatmeal and rich emollients and is clinically proven to moisturize for 24 hours and soothe dry skin, even dry skin associated with eczema. This exclusive soothing cre", "drug.current_stock": "" }, "1685": { "category_2_x_drug.id": 1685, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1685, "drug.ts": "2017-12-19 21:46:58", "drug.title": "$4.80", "drug.sku": 2262053, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "L'Oreal Kids Tangle Tamer Spray All Hair - 9 ozL'Oreal Kids Tangle tamer detangles hair in a flash! Conditioning formula tackles the snarliest hair and tames bed head, leaving it shinier and feeling clean all day. L'Oreal Kids Tangle Tamer is so gentle, i", "drug.current_stock": "" }, "1688": { "category_2_x_drug.id": 1688, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1688, "drug.ts": "2017-12-19 21:47:00", "drug.title": "$5.81", "drug.sku": 1301142, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Johnson & Johnson Baby Shampoo Original - 15 ozAs gentle to eyes as pure water. Clinically proven mild, it cleanses gently and rinses easily, leaving hair looking beautifully shiny and smelling baby fresh. Now with hypoallergenic fragrance, it's also 100%", "drug.current_stock": "" }, "1690": { "category_2_x_drug.id": 1690, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1690, "drug.ts": "2017-12-19 21:47:04", "drug.title": "$6.59", "drug.sku": 1374461, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Neutrogena Body Lotion, Light Sesame Formula, 8.5 fl ozFeel the difference. The sheer, part-lotion, part-sesame oil formula of this product silkens your skin while it moisturizes. It's so sheer, it absorbs instantly to allow your skin to breathe. It glide", "drug.current_stock": "" }, "1691": { "category_2_x_drug.id": 1691, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1691, "drug.ts": "2017-12-19 21:47:05", "drug.title": "$5.13", "drug.sku": 3622412, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Anti Monkey Butt Diaper Rash Cream - 3 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps seal out wetness.Directions: Change wet and soiled diapers promptly. Cleanse the diaper area. Allow to dry. Apply cream liberal", "drug.current_stock": "" }, "1692": { "category_2_x_drug.id": 1692, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1692, "drug.ts": "2017-12-19 21:47:07", "drug.title": "$17.87", "drug.sku": 3964335, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Triple Paste Medicated Ointment for Diaper Rash - 8 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps protect from wetness. Triple Paste is recommended by thousands of pediatricians and dermatologists for distressing", "drug.current_stock": "" }, "1693": { "category_2_x_drug.id": 1693, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1693, "drug.ts": "2017-12-19 21:47:10", "drug.title": "$4.23", "drug.sku": 2439198, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Desitin Rapid Relief Diaper Rash Cream - 2 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps seal out wetness. This cream instantly forms a protective layer on your baby's skin to soothe and relieve rash discomfort, ", "drug.current_stock": "" }, "1694": { "category_2_x_drug.id": 1694, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1694, "drug.ts": "2017-12-19 21:47:11", "drug.title": "$4.59", "drug.sku": 3489630, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Balmex Diaper Rash Cream - 4 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps seal out wetness. Reduces redness in 1 diaper change. Protects against all 3 leading causes of diaper rash to help keep your baby comfort", "drug.current_stock": "" }, "1696": { "category_2_x_drug.id": 1696, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1696, "drug.ts": "2017-12-19 21:47:13", "drug.title": "$5.81", "drug.sku": 1192251, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Johnson & Johnson Head-To-Toe Baby Wash - 15 ozThis wash is gentle enough to cleanse sensitive baby skin without drying. Now with hypoallergenic fragrance, it's dermatologist tested, dye-free, soap-free and hypoallergenic.Directions: Wet baby's hair and b", "drug.current_stock": "" }, "1697": { "category_2_x_drug.id": 1697, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1697, "drug.ts": "2017-12-19 21:47:15", "drug.title": "$7.06", "drug.sku": 1737345, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Flanders Buttocks Ointment - 4 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps protect from wetness. Widely recommended by doctors and pharmacists as a preventative measure and treatment of diaper rash. With Peruvi", "drug.current_stock": "" }, "1698": { "category_2_x_drug.id": 1698, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1698, "drug.ts": "2017-12-19 21:47:18", "drug.title": "$3.27", "drug.sku": 3545357, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "A+D Zinc Oxide Cream Diaper Rash Cream - 1.5 ozHelps treat and prevent diaper rash. Protects chafed skin or minor skin irritation due to diaper rash and helps seal out wetness.Directions: Change wet and soiled diapers promptly. Cleanse the diaper area, an", "drug.current_stock": "" }, "1699": { "category_2_x_drug.id": 1699, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1699, "drug.ts": "2017-12-19 21:47:19", "drug.title": "$6.98", "drug.sku": 1667575, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Boudreaux's Butt Paste Diaper Rash Ointment Original - 4 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps seal out wetness. Goes on and cleans off easily. Pleasant scent. Specially formulated by a pharmacist with di", "drug.current_stock": "" }, "1700": { "category_2_x_drug.id": 1700, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1700, "drug.ts": "2017-12-19 21:47:21", "drug.title": "$4.80", "drug.sku": 1384460, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "L'Oreal Kids 2-in-1 Shampoo Strawberry Smoothie - 9 ozNo knots can resist this 2-in-1 formula. For all hair types, it helps prevent split ends and conditions hair, leaving hair soft and manageable. Safe and fun to use. This shampoo smells great and makes ", "drug.current_stock": "" }, "1701": { "category_2_x_drug.id": 1701, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1701, "drug.ts": "2017-12-19 21:47:23", "drug.title": "$5.81", "drug.sku": 1301068, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Johnson & Johnson Baby Oil - 14 ozThis pure mineral oil creates a silky, protective barrier on the skin. It locks in up to 10 times more moisture on wet skin than an ordinary lotion can on dry skin.Directions: Gently massage onto damp skin after stepping ", "drug.current_stock": "" }, "1702": { "category_2_x_drug.id": 1702, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1702, "drug.ts": "2017-12-19 21:47:27", "drug.title": "$3.25", "drug.sku": 3550167, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "A&D First Aid Ointment - 1.5 ozTemporarily protects minor: cuts, scrapes, burns. Temporarily protects and helps relieve chafed, chapped or cracked skin and lips. Helps protect from the drying effects of wind and cold weather. Great for the whole family. H", "drug.current_stock": "" }, "1703": { "category_2_x_drug.id": 1703, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1703, "drug.ts": "2017-12-19 21:47:28", "drug.title": "$7.15", "drug.sku": 1181387, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Aquaphor Baby Healing Ointment - 3 ozTemporarily protects minor: cuts, scrapes, burns. Temporarily protects and helps relive chapped or cracked skin and lips. Helps protect from the drying effects of wind and cold weather. Helps treat and prevent diaper r", "drug.current_stock": "" }, "1704": { "category_2_x_drug.id": 1704, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1704, "drug.ts": "2017-12-19 21:47:29", "drug.title": "$16.65", "drug.sku": 1324441, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Desitin Maximum Strength Original Paste - 16 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps seal out wetness. This rich, thick formula contains the maximum level of zinc oxide to immediately form a protective barr", "drug.current_stock": "" }, "1705": { "category_2_x_drug.id": 1705, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1705, "drug.ts": "2017-12-19 21:47:31", "drug.title": "$5.79", "drug.sku": 2475721, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Johnson's No More Tangles Spray - 10 ozThis spray goes to work instantly to unlock knots and tangles in dry or wet hair. Dermatologist tested and hypoallergenic so it is gentle enough to use every day. Styles while unlocking stubborn tangles. Paraben-free", "drug.current_stock": "" }, "1706": { "category_2_x_drug.id": 1706, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1706, "drug.ts": "2017-12-19 21:47:34", "drug.title": "$4.03", "drug.sku": 1676055, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Suave Kids 2 in 1 Smoothers Shampoo and Conditioner, Strawberry- 12 ozGently combines shampoo and conditioner in one sure and speedy step. Dermatologist tested formula is tear-free and easy on eyes. Creamy formula with gentle conditioners reduces split en", "drug.current_stock": "" }, "1707": { "category_2_x_drug.id": 1707, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1707, "drug.ts": "2017-12-19 21:47:35", "drug.title": "$7.95", "drug.sku": "3664760B-2", "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Caldesene Protecting Powder - 5 oz, Pack of 2Treats and prevents diaper rash. Protects minor skin irritation. Zinc oxide/talc for babies and adults. Two way action. Seals out wetness. Protects chafed skin. Fresh scent.Directions: For diaper rash: Change w", "drug.current_stock": "" }, "1709": { "category_2_x_drug.id": 1709, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1709, "drug.ts": "2017-12-19 21:47:38", "drug.title": "$4.45", "drug.sku": 1982867, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Sunmark Multi-Purpose Cotton Squares - 200 ctPure, white, absorbent. For beauty, baby, first aid, crafts and hobbies. Beauty: Provides greater absorbency for all your beauty needs. Ideal for the application and removal of makeup, cleansers, astringents an", "drug.current_stock": "" }, "1710": { "category_2_x_drug.id": 1710, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1710, "drug.ts": "2017-12-19 21:47:39", "drug.title": "$4.45", "drug.sku": 1680875, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Boudreaux's Butt Paste Diaper Rash Ointment Original - 2 ozHelps treat and prevent diaper rash. Protects chafed skin due to diaper rash and helps seal out wetness. Goes on and cleans off easily. Pleasant scent. Pediatrician recommended.Directions: Change ", "drug.current_stock": "" }, "1713": { "category_2_x_drug.id": 1713, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1713, "drug.ts": "2017-12-19 21:47:42", "drug.title": "$10.13", "drug.sku": "1374461B-2", "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Neutrogena Body Lotion - 8.5 ozFeel the difference. The sheer, part-lotion, part-sesame oil formula of this product silkens your skin while it moisturizes. It's so sheer, it absorbs instantly to allow your skin to breathe. It glides on easily and leaves s", "drug.current_stock": "" }, "1714": { "category_2_x_drug.id": 1714, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1714, "drug.ts": "2017-12-19 21:47:45", "drug.title": "$4.06", "drug.sku": 3542297, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "No Rinse Body Bath - 8 ozAbsolutely no rinsing necessary. Quick, easy and convenient alternative to traditional bathing. Whenever lack of facilities, physical limitation, discomfort or fear of bathing occur, this product offers the solution. Leaves skin c", "drug.current_stock": "" }, "1715": { "category_2_x_drug.id": 1715, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1715, "drug.ts": "2017-12-19 21:47:48", "drug.title": "$9.10", "drug.sku": 3430071, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Dr. Smith's Rash + Skin Ointment - 3 ozTemporarily protects minor cuts, scrapes, and burns. Temporarily protects and helps relieve chapped, chafed, or cracked skin. Helps protect from the drying effects of wind and cold weather. Helps treat and prevent ra", "drug.current_stock": "" }, "1716": { "category_2_x_drug.id": 1716, "category_2.id": 1, "category_2.ts": "2017-12-19 03:48:17", "category_2.title": "Bath and Skin Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children", "drug.id": 1716, "drug.ts": "2017-12-19 21:47:50", "drug.title": "$5.81", "drug.sku": 1685452, "drug.shipping": "Usually Ships in 1 Business Day", "drug.description": "Johnson & Johnson Baby Oil Aloe Plus Vitamin E - 14 ozAnd we understand how to moisturize baby soft skin to help protect it from dryness. That's why our pure mineral oil, enriched with Aloe Vera & Vitamin E, locks in up to 10 times more moisture on wet sk", "drug.current_stock": "" } } } }