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": 400 }, "api": { "title": "Drug by Category_1", "point": { "title": "By Table", "desc": "Each API function returns data from 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/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.004579999999999999869826350362700395635329186916351318359375 }, "stats": { "raw_rows": 72, "rows": 72, "rows_total": 72, "pages_total": 1 }, "struct": { "stem": { "0": "category_2", "1": "category_1" }, "leaf": "category_2.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "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" }, "2": { "category_2.id": 2, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Blankets", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "3": { "category_2.id": 3, "category_2.ts": "2017-12-19 03:48:20", "category_2.title": "Clothing", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "4": { "category_2.id": 4, "category_2.ts": "2017-12-19 03:48:21", "category_2.title": "Diapers and Wipes", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "5": { "category_2.id": 5, "category_2.ts": "2017-12-19 03:48:25", "category_2.title": "Feeding and Nursing", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "6": { "category_2.id": 6, "category_2.ts": "2017-12-19 03:48:39", "category_2.title": "Health Care", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "7": { "category_2.id": 7, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Miscellaneous", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "8": { "category_2.id": 8, "category_2.ts": "2017-12-19 03:48:41", "category_2.title": "Pregnancy", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "9": { "category_2.id": 9, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Safety", "category_1.id": 1, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Children" }, "10": { "category_2.id": 10, "category_2.ts": "2017-12-19 03:48:44", "category_2.title": "Face Makeup", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "11": { "category_2.id": 11, "category_2.ts": "2017-12-19 03:48:47", "category_2.title": "Hair Care", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "12": { "category_2.id": 12, "category_2.ts": "2017-12-19 03:48:50", "category_2.title": "Lips", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "13": { "category_2.id": 13, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Makeup Applicators", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "14": { "category_2.id": 14, "category_2.ts": "2017-12-19 03:48:53", "category_2.title": "Makeup Remover", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "15": { "category_2.id": 15, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Mens Fragrance", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "16": { "category_2.id": 16, "category_2.ts": "2017-12-19 03:48:57", "category_2.title": "Nails", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "17": { "category_2.id": 17, "category_2.ts": "2017-12-19 03:48:58", "category_2.title": "Womens Fragrance", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "18": { "category_2.id": 18, "category_2.ts": "2017-12-19 03:49:02", "category_2.title": "Beauty Tools", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "19": { "category_2.id": 19, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Cosmetic Cases", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "20": { "category_2.id": 20, "category_2.ts": "2017-12-19 03:49:04", "category_2.title": "Eye Makeup", "category_1.id": 2, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Beauty" }, "21": { "category_2.id": 21, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Health Monitors", "category_1.id": 3, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Nutrition" }, "22": { "category_2.id": 22, "category_2.ts": "2017-12-19 01:02:07", "category_2.title": "Nutrition Food and Drink", "category_1.id": 3, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Nutrition" }, "23": { "category_2.id": 23, "category_2.ts": "2017-12-19 05:40:07", "category_2.title": "Vitamins & Supplements", "category_1.id": 3, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Nutrition" }, "24": { "category_2.id": 24, "category_2.ts": "2017-12-19 05:40:10", "category_2.title": "Weight Loss", "category_1.id": 3, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Nutrition" }, "25": { "category_2.id": 25, "category_2.ts": "2017-12-19 05:40:26", "category_2.title": "Allergy Asthma and Sinus", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "26": { "category_2.id": 26, "category_2.ts": "2017-12-19 05:40:31", "category_2.title": "Bug and Insect", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "27": { "category_2.id": 27, "category_2.ts": "2017-12-19 05:40:43", "category_2.title": "Cough Cold and Flu", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "28": { "category_2.id": 28, "category_2.ts": "2017-12-19 05:40:55", "category_2.title": "Diabetes Care", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "29": { "category_2.id": 29, "category_2.ts": "2017-12-19 05:41:07", "category_2.title": "Digestive Health", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "30": { "category_2.id": 30, "category_2.ts": "2017-12-19 05:41:16", "category_2.title": "Fever", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "31": { "category_2.id": 31, "category_2.ts": "2017-12-19 05:41:32", "category_2.title": "First Aid", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "32": { "category_2.id": 32, "category_2.ts": "2017-12-19 05:41:47", "category_2.title": "Foot and Leg Care", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "33": { "category_2.id": 33, "category_2.ts": "2017-12-19 05:41:54", "category_2.title": "Hemorroidal Relief", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "34": { "category_2.id": 34, "category_2.ts": "2017-12-19 05:42:10", "category_2.title": "Itch and Rash", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "35": { "category_2.id": 35, "category_2.ts": "2017-12-19 05:42:23", "category_2.title": "Oral Care", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "36": { "category_2.id": 36, "category_2.ts": "2017-12-19 05:42:40", "category_2.title": "Pain Relief", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "37": { "category_2.id": 37, "category_2.ts": "2017-12-19 05:42:48", "category_2.title": "Home Tests", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "38": { "category_2.id": 38, "category_2.ts": "2017-12-19 05:42:52", "category_2.title": "Motion Sickness & Nausea", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "39": { "category_2.id": 39, "category_2.ts": "2017-12-19 05:42:58", "category_2.title": "Stop Smoking", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "40": { "category_2.id": 40, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Wart Remover", "category_1.id": 4, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Health" }, "41": { "category_2.id": 41, "category_2.ts": "2017-12-19 05:43:11", "category_2.title": "Antiperspirants & Deoderants", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "42": { "category_2.id": 42, "category_2.ts": "2017-12-19 05:43:17", "category_2.title": "Apparel and Accessories", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "43": { "category_2.id": 43, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Body Powders", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "44": { "category_2.id": 44, "category_2.ts": "2017-12-19 05:43:26", "category_2.title": "Ear Care", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "45": { "category_2.id": 45, "category_2.ts": "2017-12-19 05:43:32", "category_2.title": "Essential Oils", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "46": { "category_2.id": 46, "category_2.ts": "2017-12-19 05:43:49", "category_2.title": "Eye Health", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "47": { "category_2.id": 47, "category_2.ts": "2017-12-19 05:44:05", "category_2.title": "Feminine Care", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "48": { "category_2.id": 48, "category_2.ts": "2017-12-19 05:44:11", "category_2.title": "Hand and Nail", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "49": { "category_2.id": 49, "category_2.ts": "2017-12-19 05:44:24", "category_2.title": "Incontinence", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "50": { "category_2.id": 50, "category_2.ts": "2017-12-19 05:44:31", "category_2.title": "Lip Care", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "51": { "category_2.id": 51, "category_2.ts": "2017-12-19 05:44:44", "category_2.title": "Mens Hygiene", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "52": { "category_2.id": 52, "category_2.ts": "2017-12-19 05:44:59", "category_2.title": "Sexual Health", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "53": { "category_2.id": 53, "category_2.ts": "2017-12-19 05:45:20", "category_2.title": "Shaving and Hair Removal", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "54": { "category_2.id": 54, "category_2.ts": "2017-12-19 05:45:34", "category_2.title": "Skin Care", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "55": { "category_2.id": 55, "category_2.ts": "2017-12-19 05:45:48", "category_2.title": "Sun Care", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "56": { "category_2.id": 56, "category_2.ts": "2017-12-19 05:45:53", "category_2.title": "Tissue and Cotton Swabs", "category_1.id": 5, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Personal Care" }, "57": { "category_2.id": 57, "category_2.ts": "2017-12-19 05:45:59", "category_2.title": "Air Fresheners and Candles", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "58": { "category_2.id": 58, "category_2.ts": "2017-12-19 05:46:14", "category_2.title": "Arts & Crafts", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "59": { "category_2.id": 59, "category_2.ts": "2017-12-19 05:46:21", "category_2.title": "Bath Accessories", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "60": { "category_2.id": 60, "category_2.ts": "2017-12-19 05:46:28", "category_2.title": "Batteries", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "61": { "category_2.id": 61, "category_2.ts": "2017-12-19 05:46:34", "category_2.title": "Bedroom", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "62": { "category_2.id": 62, "category_2.ts": "2017-12-19 05:46:44", "category_2.title": "Cleaning Supplies", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "63": { "category_2.id": 63, "category_2.ts": "2017-12-19 05:46:48", "category_2.title": "Decor", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "64": { "category_2.id": 64, "category_2.ts": "2017-12-19 05:46:59", "category_2.title": "Hardware", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "65": { "category_2.id": 65, "category_2.ts": "2017-12-19 05:47:13", "category_2.title": "Home Office", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "66": { "category_2.id": 66, "category_2.ts": "2017-12-19 05:47:26", "category_2.title": "Kitchen", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "67": { "category_2.id": 67, "category_2.ts": "2017-12-19 05:47:31", "category_2.title": "Nostalgic", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "68": { "category_2.id": 68, "category_2.ts": "2017-12-19 01:00:47", "category_2.title": "Outdoor Decor", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "69": { "category_2.id": 69, "category_2.ts": "2017-12-19 05:47:44", "category_2.title": "Party Supply", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "70": { "category_2.id": 70, "category_2.ts": "2017-12-19 05:47:52", "category_2.title": "Pets", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "71": { "category_2.id": 71, "category_2.ts": "2017-12-19 05:48:03", "category_2.title": "Snacks", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" }, "72": { "category_2.id": 72, "category_2.ts": "2017-12-19 01:06:51", "category_2.title": "Storage", "category_1.id": 6, "category_1.ts": "2017-12-19 01:00:47", "category_1.title": "Household & Pets" } } } }