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": "Rite Aid Stores in the United Sates", "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_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/by_table/rite_aid_store_x_immunization/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/by_table/rite_aid_store_x_immunization/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 30, "limit_total": 200, "time": 0.0017999999999999999507338532822586785187013447284698486328125 }, "stats": { "raw_rows": 30, "rows": 30, "rows_total": 23545, "pages_total": 785 }, "struct": { "stem": { "0": "rite_aid_store_x_immunization", "1": "rite_aid_store", "2": "immunization" }, "leaf": "rite_aid_store_x_immunization.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "rite_aid_store_x_immunization.id": 1, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "2": { "rite_aid_store_x_immunization.id": 2, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "3": { "rite_aid_store_x_immunization.id": 3, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "4": { "rite_aid_store_x_immunization.id": 4, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "5": { "rite_aid_store_x_immunization.id": 5, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "6": { "rite_aid_store_x_immunization.id": 6, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "7": { "rite_aid_store_x_immunization.id": 7, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "8": { "rite_aid_store_x_immunization.id": 8, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "9": { "rite_aid_store_x_immunization.id": 9, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "10": { "rite_aid_store_x_immunization.id": 10, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "11": { "rite_aid_store_x_immunization.id": 11, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "12": { "rite_aid_store_x_immunization.id": 12, "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" }, "13": { "rite_aid_store_x_immunization.id": 13, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "14": { "rite_aid_store_x_immunization.id": 14, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "15": { "rite_aid_store_x_immunization.id": 15, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "16": { "rite_aid_store_x_immunization.id": 16, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "17": { "rite_aid_store_x_immunization.id": 17, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "18": { "rite_aid_store_x_immunization.id": 18, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" }, "19": { "rite_aid_store_x_immunization.id": 19, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 7, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Diptheria" }, "20": { "rite_aid_store_x_immunization.id": 20, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 8, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Varicella (Chickenpox)" }, "21": { "rite_aid_store_x_immunization.id": 21, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 9, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Influenza (Flu)" }, "22": { "rite_aid_store_x_immunization.id": 22, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 10, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis A" }, "23": { "rite_aid_store_x_immunization.id": 23, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 11, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Hepatitis B" }, "24": { "rite_aid_store_x_immunization.id": 24, "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375, "immunization.id": 12, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Human Papillomavirus (HPV)" }, "25": { "rite_aid_store_x_immunization.id": 25, "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125, "immunization.id": 1, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Tetanus (Lockjaw)" }, "26": { "rite_aid_store_x_immunization.id": 26, "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125, "immunization.id": 2, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pertussis (Whooping Cough)" }, "27": { "rite_aid_store_x_immunization.id": 27, "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125, "immunization.id": 3, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Pneumococcal Disease" }, "28": { "rite_aid_store_x_immunization.id": 28, "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125, "immunization.id": 4, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "MMR (Measles, Mumps, Rubella)" }, "29": { "rite_aid_store_x_immunization.id": 29, "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125, "immunization.id": 5, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Shingles (Herpes Zoster)" }, "30": { "rite_aid_store_x_immunization.id": 30, "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125, "immunization.id": 6, "immunization.ts": "2018-01-11 03:41:14", "immunization.value": "Meningococcal Disease" } } } }