{ "sample": { "is_sample": "TRUE", "limit_total": 200 }, "api": { "title": "City Guide", "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/city_guide/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/city_guide/by_table/restaurant_1_x_restaurant_2/?app=json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/city_guide/by_table/restaurant_1_x_restaurant_2/2/?app=json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 30, "limit_total": 200, "time": 0.17083999999999999186428567554685287177562713623046875 }, "stats": { "raw_rows": 30, "rows": 30, "rows_total": 91369, "pages_total": 3046 }, "struct": { "stem": [ "restaurant_1_x_restaurant_2", "restaurant_1", "restaurant_2" ], "leaf": "restaurant_1_x_restaurant_2.id", "leaf_stem": [], "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "restaurant_1_x_restaurant_2.id": 1, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 1, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "1800 Mexican Grill", "restaurant_2.address": "515 Wyoming Blvd NE Ste A, Albuquerque, NM 87123", "restaurant_2.phone": "505-268-2559", "restaurant_2.website": "", "restaurant_2.miles": "19.7 mi" }, "2": { "restaurant_1_x_restaurant_2.id": 2, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 2, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "2000 Millenium Restaurant", "restaurant_2.address": "601 San Mateo Blvd SE, Albuquerque, NM 87108", "restaurant_2.phone": "505-232-0900", "restaurant_2.website": "", "restaurant_2.miles": "16.9 mi" }, "3": { "restaurant_1_x_restaurant_2.id": 3, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 3, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "328 Chinese Cuisine", "restaurant_2.address": "5617 Menaul Blvd NE Ste A, Albuquerque, NM 87110", "restaurant_2.phone": "505-881-4468", "restaurant_2.website": "", "restaurant_2.miles": "18.6 mi" }, "4": { "restaurant_1_x_restaurant_2.id": 4, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 4, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "5 Star Abq", "restaurant_2.address": "5901 Wyoming Blvd NE, Albuquerque, NM 87109", "restaurant_2.phone": "505-821-1909", "restaurant_2.website": "", "restaurant_2.miles": "20.8 mi" }, "5": { "restaurant_1_x_restaurant_2.id": 5, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 5, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "66 Diner", "restaurant_2.address": "1405 Central Ave NE, Albuquerque, NM 87106", "restaurant_2.phone": "505-247-1421", "restaurant_2.website": "www.66diner.com", "restaurant_2.miles": "" }, "6": { "restaurant_1_x_restaurant_2.id": 6, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 6, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "A A Buffet & Grill", "restaurant_2.address": "880 Juan Tabo Blvd NE, Albuquerque, NM 87123", "restaurant_2.phone": "505-299-1191", "restaurant_2.website": "www.aabuffet.com", "restaurant_2.miles": "21.0 mi" }, "7": { "restaurant_1_x_restaurant_2.id": 7, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 7, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "A B C Chinese Restaurant", "restaurant_2.address": "8720 Menaul Blvd NE, Albuquerque, NM 87112", "restaurant_2.phone": "505-292-8788", "restaurant_2.website": "", "restaurant_2.miles": "19.9 mi" }, "8": { "restaurant_1_x_restaurant_2.id": 8, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 8, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "A-Ri-Rang Oriental Market", "restaurant_2.address": "1826 Eubank Blvd NE, Albuquerque, NM 87112", "restaurant_2.phone": "505-255-9634", "restaurant_2.website": "", "restaurant_2.miles": "21.2 mi" }, "9": { "restaurant_1_x_restaurant_2.id": 9, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 9, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "AAAA Cafe", "restaurant_2.address": "3112 W Meadow Dr SW, Albuquerque, NM 87121", "restaurant_2.phone": "505-503-7205", "restaurant_2.website": "", "restaurant_2.miles": "8.7 mi" }, "10": { "restaurant_1_x_restaurant_2.id": 10, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 10, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "Aarons Sandwich Time", "restaurant_2.address": "5659 Jefferson St NE Ste F, Albuquerque, NM 87109", "restaurant_2.phone": "505-433-5353", "restaurant_2.website": "", "restaurant_2.miles": "18.3 mi" }, "11": { "restaurant_1_x_restaurant_2.id": 11, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 11, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "Abq Brew Pub", "restaurant_2.address": "6601 Uptown Blvd NE Ste B, Albuquerque, NM 87110", "restaurant_2.phone": "505-884-1116", "restaurant_2.website": "www.abqbrewpub.com", "restaurant_2.miles": "18.6 mi" }, "12": { "restaurant_1_x_restaurant_2.id": 12, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 12, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "Abuelita's New Mexican Kitchen", "restaurant_2.address": "6083 Isleta Blvd SW, Albuquerque, NM 87105", "restaurant_2.phone": "505-877-5700", "restaurant_2.website": "", "restaurant_2.miles": "11.9 mi" }, "13": { "restaurant_1_x_restaurant_2.id": 13, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 13, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "Acapulco Tacos & Burritos", "restaurant_2.address": "840 San Mateo Blvd SE, Albuquerque, NM 87108", "restaurant_2.phone": "505-268-9865", "restaurant_2.website": "", "restaurant_2.miles": "16.9 mi" }, "14": { "restaurant_1_x_restaurant_2.id": 14, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 14, "restaurant_2.ts": "2017-12-05 22:43:21", "restaurant_2.title": "Acapulco Tacos & Burros", "restaurant_2.address": "2617 Wyoming Blvd NE, Albuquerque, NM 87112", "restaurant_2.phone": "505-237-8044", "restaurant_2.website": "", "restaurant_2.miles": "20.1 mi" }, "592": { "restaurant_1_x_restaurant_2.id": 592, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 592, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Ajiaco Columbian Bistro", "restaurant_2.address": "3216 Silver Ave SE, Albuquerque, NM 87106", "restaurant_2.phone": "505-266-2305", "restaurant_2.website": "", "restaurant_2.miles": "15.6 mi" }, "593": { "restaurant_1_x_restaurant_2.id": 593, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 593, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Albuquerque City Limits Restaurant", "restaurant_2.address": "3231 Coors Blvd SW, Albuquerque, NM 87121", "restaurant_2.phone": "505-873-8959", "restaurant_2.website": "", "restaurant_2.miles": "10.0 mi" }, "594": { "restaurant_1_x_restaurant_2.id": 594, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 594, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Albuquerque Grill", "restaurant_2.address": "1015 Rio Grande Blvd NW, Albuquerque, NM 87104", "restaurant_2.phone": "505-217-1619", "restaurant_2.website": "", "restaurant_2.miles": "13.3 mi" }, "595": { "restaurant_1_x_restaurant_2.id": 595, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 595, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Alibertos Mexican Food", "restaurant_2.address": "8801 Central Ave NE, Albuquerque, NM 87123", "restaurant_2.phone": "505-291-6078", "restaurant_2.website": "", "restaurant_2.miles": "19.6 mi" }, "596": { "restaurant_1_x_restaurant_2.id": 596, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 596, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "All American Sliders & Tenders", "restaurant_2.address": "11004 Montgomery Blvd NE, Albuquerque, NM 87111", "restaurant_2.phone": "505-888-7002", "restaurant_2.website": "", "restaurant_2.miles": "21.6 mi" }, "597": { "restaurant_1_x_restaurant_2.id": 597, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 597, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "AM Spices of India LLC", "restaurant_2.address": "317 Central Ave NW, Albuquerque, NM 87102", "restaurant_2.phone": "505-247-1490", "restaurant_2.website": "www.amspicesofindia.com", "restaurant_2.miles": "14.3 mi" }, "598": { "restaurant_1_x_restaurant_2.id": 598, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 598, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Amadeo's Pizza", "restaurant_2.address": "5003 Lomas Blvd NE, Albuquerque, NM 87110", "restaurant_2.phone": "505-255-8888", "restaurant_2.website": "amadeospizza.com", "restaurant_2.miles": "17.1 mi" }, "599": { "restaurant_1_x_restaurant_2.id": 599, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 599, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Amadeo's Pizza & Subs", "restaurant_2.address": "3109 Coors Blvd SW, Albuquerque, NM 87121", "restaurant_2.phone": "505-873-2035", "restaurant_2.website": "www.amadeospizza.com", "restaurant_2.miles": "10.0 mi" }, "600": { "restaurant_1_x_restaurant_2.id": 600, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 600, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Amadeo's Pizza & Subs", "restaurant_2.address": "809 98th St SW, Albuquerque, NM 87121", "restaurant_2.phone": "505-831-9339", "restaurant_2.website": "www.amadeospizza.com", "restaurant_2.miles": "8.7 mi" }, "601": { "restaurant_1_x_restaurant_2.id": 601, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 601, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Amerasia -Sumo Sushi", "restaurant_2.address": "800 3rd St NW, Albuquerque, NM 87102", "restaurant_2.phone": "505-246-1615", "restaurant_2.website": "", "restaurant_2.miles": "14.4 mi" }, "602": { "restaurant_1_x_restaurant_2.id": 602, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 602, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Ana's Kitchen", "restaurant_2.address": "5918 Edith Blvd NE, Albuquerque, NM 87107", "restaurant_2.phone": "505-341-0055", "restaurant_2.website": "", "restaurant_2.miles": "16.7 mi" }, "603": { "restaurant_1_x_restaurant_2.id": 603, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 603, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Anatolia Doner Kebab", "restaurant_2.address": "521 Central Ave NW, Albuquerque, NM 87102", "restaurant_2.phone": "505-242-6718", "restaurant_2.website": "", "restaurant_2.miles": "" }, "604": { "restaurant_1_x_restaurant_2.id": 604, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 604, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Annapurna Cafe", "restaurant_2.address": "5939 4th St NW, Albuquerque, NM 87107", "restaurant_2.phone": "505-254-2424", "restaurant_2.website": "", "restaurant_2.miles": "15.5 mi" }, "605": { "restaurant_1_x_restaurant_2.id": 605, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 605, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Annapurna's Cafe", "restaurant_2.address": "2201 Silver Ave SE, Albuquerque, NM 87106", "restaurant_2.phone": "505-262-2424", "restaurant_2.website": "", "restaurant_2.miles": "15.6 mi" }, "606": { "restaurant_1_x_restaurant_2.id": 606, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 606, "restaurant_2.ts": "2017-12-06 01:33:53", "restaurant_2.title": "Annie's Soup Kitchen", "restaurant_2.address": "3107 Eubank Blvd NE, Albuquerque, NM 87111", "restaurant_2.phone": "505-296-8601", "restaurant_2.website": "", "restaurant_2.miles": "21.4 mi" }, "607": { "restaurant_1_x_restaurant_2.id": 607, "restaurant_1.id": 1, "restaurant_1.ts": "2017-12-06 01:44:58", "restaurant_1.title": "Albuquerque Restaurants", "restaurant_2.id": 607, "restaurant_2.ts": "2017-12-06 01:34:57", "restaurant_2.title": "Antiquity Restaurant", "restaurant_2.address": "112 Romero St NW, Albuquerque, NM 87104", "restaurant_2.phone": "505-247-3545", "restaurant_2.website": "", "restaurant_2.miles": "13.1 mi" } } } }