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": 100 }, "api": { "title": "High Schools in the United States, High Schools Public High Schools and Private High Schools List", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/high_schools_in_the_united_states/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/high_schools_in_the_united_states/main/list/?app=html-json" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/high_schools_in_the_united_states/main/list/3/?app=html-json" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/high_schools_in_the_united_states/main/list/5/?app=html-json" } }, "meta": { "query": { "page": 4, "limit": 20, "limit_total": 100, "time": 0.0023099999999999999873712130948888443526811897754669189453125 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 41372, "pages_total": 2069 }, "struct": { "stem": { "0": "high_school" }, "leaf": "high_school.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "61": { "high_school.id": 61, "high_school.ts": "2018-04-23 21:33:09", "high_school.title": "Clements High School", "high_school.address": "7730 Hwy 72 West Athens, AL 35611 Limestone County", "high_school.latitude": 34.80199999999999960209606797434389591217041015625, "high_school.longitude": -87.1838000000000050704329623840749263763427734375, "high_school.phone": "(256) 729-6564", "high_school.website": "Classmates.com®", "high_school.school_district": "Limestone County School District", "high_school.type": "Public School", "high_school.total_student": 628, "high_school.pupil_and_teacher_retio": "17:1", "high_school.full_time_teachers": 37.00999999999999801048033987171947956085205078125, "high_school.enrollment_rank_nationally": "8,918th out of 0", "high_school.enrollment_rank_in_state": "179th out of 0", "high_school.student_and_teacher_rank_in_state": "294th out of 0", "high_school.full_time_teacher_rank_in_state": "204th out of 0", "high_school.city_x_high_school_id": { "61": { "city_x_high_school.id": 61, "city.id": 21, "city.ts": "2018-04-23 01:57:35", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "62": { "high_school.id": 62, "high_school.ts": "2018-04-23 21:33:13", "high_school.title": "East Limestone High School", "high_school.address": "15641 East Limestone Rd Athens, AL 35613 Limestone County", "high_school.latitude": 34.7830000000000012505552149377763271331787109375, "high_school.longitude": -86.8333999999999974761522025801241397857666015625, "high_school.phone": "(256) 233-6660", "high_school.website": "Classmates.com®", "high_school.school_district": "Limestone County School District", "high_school.type": "Public School", "high_school.total_student": "1,279", "high_school.pupil_and_teacher_retio": "17.5:1", "high_school.full_time_teachers": 72.9899999999999948840923025272786617279052734375, "high_school.enrollment_rank_nationally": "4,234th out of 0", "high_school.enrollment_rank_in_state": "41st out of 0", "high_school.student_and_teacher_rank_in_state": "325th out of 0", "high_school.full_time_teacher_rank_in_state": "50th out of 0", "high_school.city_x_high_school_id": { "62": { "city_x_high_school.id": 62, "city.id": 21, "city.ts": "2018-04-23 01:57:35", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "63": { "high_school.id": 63, "high_school.ts": "2018-04-23 21:33:15", "high_school.title": "Limestone County Area Vocational Tech", "high_school.address": "505 East Sanderfer Rd Athens, AL 35611 Limestone County", "high_school.latitude": 34.7984000000000008867573342286050319671630859375, "high_school.longitude": -86.96559999999999490682967007160186767578125, "high_school.phone": "(256) 233-6463", "high_school.website": "", "high_school.school_district": "Limestone County School District", "high_school.type": "Public School", "high_school.total_student": "", "high_school.pupil_and_teacher_retio": "N/A", "high_school.full_time_teachers": "N/A", "high_school.enrollment_rank_nationally": "", "high_school.enrollment_rank_in_state": "Unranked", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "63": { "city_x_high_school.id": 63, "city.id": 21, "city.ts": "2018-04-23 01:57:35", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "64": { "high_school.id": 64, "high_school.ts": "2018-04-23 21:33:18", "high_school.title": "Lindsay Lane Christian Academy", "high_school.address": "1300 Lindsay Ln S Athens, AL 35613 Limestone County", "high_school.latitude": 34.78869999999999862438926356844604015350341796875, "high_school.longitude": -86.9303000000000025693225325085222721099853515625, "high_school.phone": "(256) 262-5323", "high_school.website": "", "high_school.school_district": "", "high_school.type": "Private School", "high_school.total_student": 316, "high_school.pupil_and_teacher_retio": "8:1", "high_school.full_time_teachers": 30, "high_school.enrollment_rank_nationally": "2,176th out of 0", "high_school.enrollment_rank_in_state": "50th out of 0", "high_school.student_and_teacher_rank_in_state": "48th out of 0", "high_school.full_time_teacher_rank_in_state": "38th out of 0", "high_school.city_x_high_school_id": { "64": { "city_x_high_school.id": 64, "city.id": 21, "city.ts": "2018-04-23 01:57:35", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "65": { "high_school.id": 65, "high_school.ts": "2018-04-23 21:33:22", "high_school.title": "Temple Christian Academy", "high_school.address": "25820 Nick Davis Rd Athens, AL 35613 Limestone County", "high_school.latitude": 34.80279999999999773763192933984100818634033203125, "high_school.longitude": -86.8619000000000056616045185364782810211181640625, "high_school.phone": "(256) 425-6468", "high_school.website": "", "high_school.school_district": "", "high_school.type": "Private School", "high_school.total_student": 7, "high_school.pupil_and_teacher_retio": "5:1", "high_school.full_time_teachers": 1, "high_school.enrollment_rank_nationally": "8,548th out of 0", "high_school.enrollment_rank_in_state": "182nd out of 0", "high_school.student_and_teacher_rank_in_state": "19th out of 0", "high_school.full_time_teacher_rank_in_state": "180th out of 0", "high_school.city_x_high_school_id": { "65": { "city_x_high_school.id": 65, "city.id": 21, "city.ts": "2018-04-23 01:57:35", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "66": { "high_school.id": 66, "high_school.ts": "2018-04-23 21:33:23", "high_school.title": "Atmore Christian School", "high_school.address": "245 Tennant Dr Atmore, AL 36502 Escambia County", "high_school.latitude": 31.022800000000000153477230924181640148162841796875, "high_school.longitude": -87.5065000000000026147972675971686840057373046875, "high_school.phone": "(251) 368-5499", "high_school.website": "Classmates.com®", "high_school.school_district": "", "high_school.type": "Private School", "high_school.total_student": 103, "high_school.pupil_and_teacher_retio": "9:1", "high_school.full_time_teachers": 9, "high_school.enrollment_rank_nationally": "4,563rd out of 0", "high_school.enrollment_rank_in_state": "119th out of 0", "high_school.student_and_teacher_rank_in_state": "62nd out of 0", "high_school.full_time_teacher_rank_in_state": "114th out of 0", "high_school.city_x_high_school_id": { "66": { "city_x_high_school.id": 66, "city.id": 22, "city.ts": "2018-04-23 01:57:35", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "67": { "high_school.id": 67, "high_school.ts": "2018-04-23 21:33:27", "high_school.title": "Compass School", "high_school.address": "100 Martin Luther King Ave Atmore, AL 36502 Escambia County", "high_school.latitude": 31.03170000000000072759576141834259033203125, "high_school.longitude": -87.47939999999999827196006663143634796142578125, "high_school.phone": "(334) 242-9700", "high_school.website": "", "high_school.school_district": "Compass School District", "high_school.type": "Public School", "high_school.total_student": "", "high_school.pupil_and_teacher_retio": "N/A", "high_school.full_time_teachers": "N/A", "high_school.enrollment_rank_nationally": "", "high_school.enrollment_rank_in_state": "Unranked", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "67": { "city_x_high_school.id": 67, "city.id": 22, "city.ts": "2018-04-23 01:57:35", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "68": { "high_school.id": 68, "high_school.ts": "2018-04-23 21:33:33", "high_school.title": "Escambia Academy", "high_school.address": "268 Cowpen Creek Rd Atmore, AL 36502 Escambia County", "high_school.latitude": 31.03020000000000067075234255753457546234130859375, "high_school.longitude": -87.407499999999998863131622783839702606201171875, "high_school.phone": "(251) 368-2080", "high_school.website": "Classmates.com®", "high_school.school_district": "", "high_school.type": "Private School", "high_school.total_student": 314, "high_school.pupil_and_teacher_retio": "14:1", "high_school.full_time_teachers": 20, "high_school.enrollment_rank_nationally": "2,198th out of 0", "high_school.enrollment_rank_in_state": "52nd out of 0", "high_school.student_and_teacher_rank_in_state": "150th out of 0", "high_school.full_time_teacher_rank_in_state": "58th out of 0", "high_school.city_x_high_school_id": { "68": { "city_x_high_school.id": 68, "city.id": 22, "city.ts": "2018-04-23 01:57:35", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "69": { "high_school.id": 69, "high_school.ts": "2018-04-23 21:33:36", "high_school.title": "Escambia County High School", "high_school.address": "1215 South Presley St Atmore, AL 36502 Escambia County", "high_school.latitude": 31.006499999999999062083588796667754650115966796875, "high_school.longitude": -87.4865999999999957026375341229140758514404296875, "high_school.phone": "(251) 368-9181", "high_school.website": "Classmates.com®", "high_school.school_district": "Escambia County School District", "high_school.type": "Public School", "high_school.total_student": 548, "high_school.pupil_and_teacher_retio": "13.9:1", "high_school.full_time_teachers": 39.5, "high_school.enrollment_rank_nationally": "9,932nd out of 0", "high_school.enrollment_rank_in_state": "211th out of 0", "high_school.student_and_teacher_rank_in_state": "93rd out of 0", "high_school.full_time_teacher_rank_in_state": "189th out of 0", "high_school.city_x_high_school_id": { "69": { "city_x_high_school.id": 69, "city.id": 22, "city.ts": "2018-04-23 01:57:35", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "70": { "high_school.id": 70, "high_school.ts": "2018-04-23 21:33:41", "high_school.title": "Escambia County Middle School", "high_school.address": "1565 Hwy 21 Atmore, AL 36502 Escambia County", "high_school.latitude": 31.045899999999999607780409860424697399139404296875, "high_school.longitude": -87.494699999999994588506524451076984405517578125, "high_school.phone": "(251) 368-9105", "high_school.website": "Classmates.com®", "high_school.school_district": "Escambia County School District", "high_school.type": "Public School", "high_school.total_student": 551, "high_school.pupil_and_teacher_retio": "14:1", "high_school.full_time_teachers": 39.25, "high_school.enrollment_rank_nationally": "Unranked", "high_school.enrollment_rank_in_state": "Unknown", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "70": { "city_x_high_school.id": 70, "city.id": 22, "city.ts": "2018-04-23 01:57:35", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "71": { "high_school.id": 71, "high_school.ts": "2018-04-23 21:33:45", "high_school.title": "Temple Christian Academy", "high_school.address": "1707 S Main St Atmore, AL 36502 Escambia County", "high_school.latitude": 31.00240000000000151203494169749319553375244140625, "high_school.longitude": -87.4904999999999972715158946812152862548828125, "high_school.phone": "(251) 368-8282", "high_school.website": "", "high_school.school_district": "", "high_school.type": "Private School", "high_school.total_student": 47, "high_school.pupil_and_teacher_retio": "10:1", "high_school.full_time_teachers": 4, "high_school.enrollment_rank_nationally": "6,173rd out of 0", "high_school.enrollment_rank_in_state": "147th out of 0", "high_school.student_and_teacher_rank_in_state": "83rd out of 0", "high_school.full_time_teacher_rank_in_state": "145th out of 0", "high_school.city_x_high_school_id": { "71": { "city_x_high_school.id": 71, "city.id": 22, "city.ts": "2018-04-23 01:57:35", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "72": { "high_school.id": 72, "high_school.ts": "2018-04-23 21:33:48", "high_school.title": "Career Technical Center", "high_school.address": "105 Burke Ave SE Attalla, AL 35954 Etowah County", "high_school.latitude": 33.99629999999999796500560478307306766510009765625, "high_school.longitude": -86.1049000000000006593836587853729724884033203125, "high_school.phone": "(256) 538-3312", "high_school.website": "", "high_school.school_district": "Etowah County School District", "high_school.type": "Public School", "high_school.total_student": "", "high_school.pupil_and_teacher_retio": "N/A", "high_school.full_time_teachers": "N/A", "high_school.enrollment_rank_nationally": "", "high_school.enrollment_rank_in_state": "Unranked", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "72": { "city_x_high_school.id": 72, "city.id": 23, "city.ts": "2018-04-23 01:57:35", "city.title": "Attalla", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "73": { "high_school.id": 73, "high_school.ts": "2018-04-23 21:33:53", "high_school.title": "Etowah High School", "high_school.address": "201 Case Ave Attalla, AL 35954 Etowah County", "high_school.latitude": 33.99539999999999650981408194638788700103759765625, "high_school.longitude": -86.113200000000006184563972055912017822265625, "high_school.phone": "(256) 538-8381", "high_school.website": "Classmates.com®", "high_school.school_district": "Attalla City School District", "high_school.type": "Public School", "high_school.total_student": 759, "high_school.pupil_and_teacher_retio": "16.1:1", "high_school.full_time_teachers": 47, "high_school.enrollment_rank_nationally": "7,627th out of 0", "high_school.enrollment_rank_in_state": "135th out of 0", "high_school.student_and_teacher_rank_in_state": "237th out of 0", "high_school.full_time_teacher_rank_in_state": "146th out of 0", "high_school.city_x_high_school_id": { "73": { "city_x_high_school.id": 73, "city.id": 23, "city.ts": "2018-04-23 01:57:35", "city.title": "Attalla", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "74": { "high_school.id": 74, "high_school.ts": "2018-04-23 21:33:58", "high_school.title": "Etowah Middle School", "high_school.address": "429 South 4th St Attalla, AL 35954 Etowah County", "high_school.latitude": 34.0174999999999982946974341757595539093017578125, "high_school.longitude": -86.0982999999999947249307297170162200927734375, "high_school.phone": "(256) 538-3236", "high_school.website": "Classmates.com®", "high_school.school_district": "Attalla City School District", "high_school.type": "Public School", "high_school.total_student": 452, "high_school.pupil_and_teacher_retio": "11.9:1", "high_school.full_time_teachers": 38, "high_school.enrollment_rank_nationally": "Unranked", "high_school.enrollment_rank_in_state": "Unknown", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "74": { "city_x_high_school.id": 74, "city.id": 23, "city.ts": "2018-04-23 01:57:35", "city.title": "Attalla", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "75": { "high_school.id": 75, "high_school.ts": "2018-04-23 21:34:02", "high_school.title": "Etowah County Alternative School", "high_school.address": "106 Burke Aves.e. Attlla, AL 35954 Etowah County", "high_school.latitude": 33.995800000000002683009370230138301849365234375, "high_school.longitude": -86.103800000000006775735528208315372467041015625, "high_school.phone": "(256) 538-8431", "high_school.website": "", "high_school.school_district": "Etowah County School District", "high_school.type": "Public School", "high_school.total_student": "", "high_school.pupil_and_teacher_retio": "N/A", "high_school.full_time_teachers": "N/A", "high_school.enrollment_rank_nationally": "", "high_school.enrollment_rank_in_state": "Unranked", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "75": { "city_x_high_school.id": 75, "city.id": 24, "city.ts": "2018-04-23 01:57:35", "city.title": "Attlla", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "76": { "high_school.id": 76, "high_school.ts": "2018-04-23 21:34:07", "high_school.title": "Auburn Farm Center", "high_school.address": "405 South Dean Rd Auburn, AL 36830 Lee County", "high_school.latitude": 32.59700000000000130739863379858434200286865234375, "high_school.longitude": -85.4633000000000038198777474462985992431640625, "high_school.phone": "(334) 887-2110", "high_school.website": "", "high_school.school_district": "Auburn City School District", "high_school.type": "Public School", "high_school.total_student": "", "high_school.pupil_and_teacher_retio": "N/A", "high_school.full_time_teachers": "N/A", "high_school.enrollment_rank_nationally": "", "high_school.enrollment_rank_in_state": "Unranked", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "76": { "city_x_high_school.id": 76, "city.id": 25, "city.ts": "2018-04-23 01:57:35", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "77": { "high_school.id": 77, "high_school.ts": "2018-04-23 21:34:12", "high_school.title": "Auburn High School", "high_school.address": "405 South Dean Rd Auburn, AL 36830 Lee County", "high_school.latitude": 32.59700000000000130739863379858434200286865234375, "high_school.longitude": -85.4633000000000038198777474462985992431640625, "high_school.phone": "(334) 887-4970", "high_school.website": "Classmates.com®", "high_school.school_district": "Auburn City School District", "high_school.type": "Public School", "high_school.total_student": "1,532", "high_school.pupil_and_teacher_retio": "16.7:1", "high_school.full_time_teachers": 91.5, "high_school.enrollment_rank_nationally": "3,083rd out of 0", "high_school.enrollment_rank_in_state": "22nd out of 0", "high_school.student_and_teacher_rank_in_state": "275th out of 0", "high_school.full_time_teacher_rank_in_state": "23rd out of 0", "high_school.city_x_high_school_id": { "77": { "city_x_high_school.id": 77, "city.id": 25, "city.ts": "2018-04-23 01:57:35", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "78": { "high_school.id": 78, "high_school.ts": "2018-04-23 21:34:14", "high_school.title": "Auburn Jr High School", "high_school.address": "332 Samford Ave Auburn, AL 36830 Lee County", "high_school.latitude": 32.5981000000000022964741219766438007354736328125, "high_school.longitude": -85.47669999999999390638549812138080596923828125, "high_school.phone": "(334) 887-1960", "high_school.website": "Classmates.com®", "high_school.school_district": "Auburn City School District", "high_school.type": "Public School", "high_school.total_student": "1,109", "high_school.pupil_and_teacher_retio": "16:1", "high_school.full_time_teachers": 69.5, "high_school.enrollment_rank_nationally": "5,202nd out of 0", "high_school.enrollment_rank_in_state": "57th out of 0", "high_school.student_and_teacher_rank_in_state": "231st out of 0", "high_school.full_time_teacher_rank_in_state": "57th out of 0", "high_school.city_x_high_school_id": { "78": { "city_x_high_school.id": 78, "city.id": 25, "city.ts": "2018-04-23 01:57:35", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "79": { "high_school.id": 79, "high_school.ts": "2018-04-23 21:34:19", "high_school.title": "Autaugaville School", "high_school.address": "2708 Dutch Bend St Autaugaville, AL 36003 Autauga County", "high_school.latitude": 32.43390000000000128466126625426113605499267578125, "high_school.longitude": -86.65940000000000509317032992839813232421875, "high_school.phone": "(334) 365-8329", "high_school.website": "", "high_school.school_district": "Autauga County School District", "high_school.type": "Public School", "high_school.total_student": 330, "high_school.pupil_and_teacher_retio": "12:1", "high_school.full_time_teachers": 27.5, "high_school.enrollment_rank_nationally": "13,844th out of 0", "high_school.enrollment_rank_in_state": "340th out of 0", "high_school.student_and_teacher_rank_in_state": "40th out of 0", "high_school.full_time_teacher_rank_in_state": "288th out of 0", "high_school.city_x_high_school_id": { "79": { "city_x_high_school.id": 79, "city.id": 26, "city.ts": "2018-04-23 01:57:35", "city.title": "Autaugaville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } }, "80": { "high_school.id": 80, "high_school.ts": "2018-04-23 21:34:21", "high_school.title": "Parkside Elementary School", "high_school.address": "12431 Al Hwy 69 North Baileyton, AL 35019 Cullman County", "high_school.latitude": 34.26809999999999689634933019988238811492919921875, "high_school.longitude": -86.610399999999998499333742074668407440185546875, "high_school.phone": "(256) 796-5568", "high_school.website": "Classmates.com®", "high_school.school_district": "Cullman County School District", "high_school.type": "Public School", "high_school.total_student": "", "high_school.pupil_and_teacher_retio": "N/A", "high_school.full_time_teachers": "N/A", "high_school.enrollment_rank_nationally": "", "high_school.enrollment_rank_in_state": "Unranked", "high_school.student_and_teacher_rank_in_state": "Unranked", "high_school.full_time_teacher_rank_in_state": "Unranked", "high_school.city_x_high_school_id": { "80": { "city_x_high_school.id": 80, "city.id": 27, "city.ts": "2018-04-23 01:57:35", "city.title": "Baileyton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-23 01:55:33", "state.title": "Alabama" } } } } } }