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": "Country Postalcode", "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_4db7936df78dfe468fc2/country_postalcode/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/country_postalcode/by_table/state/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/country_postalcode/by_table/state/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.0012899999999999999140964934696285126847214996814727783203125 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 1331, "pages_total": 14 }, "struct": { "stem": { "0": "state", "1": "country" }, "leaf": "state.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "state.id": 1, "state.ts": "2018-02-22 00:32:35", "state.title": "Adrar", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "2": { "state.id": 2, "state.ts": "2018-02-22 00:32:35", "state.title": "Ain-Defla", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "3": { "state.id": 3, "state.ts": "2018-02-22 00:32:35", "state.title": "Ain-Temouchent", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "4": { "state.id": 4, "state.ts": "2018-02-22 00:32:35", "state.title": "Alger", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "5": { "state.id": 5, "state.ts": "2018-02-22 00:32:35", "state.title": "Annaba", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "6": { "state.id": 6, "state.ts": "2018-02-22 00:32:35", "state.title": "Batna", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "7": { "state.id": 7, "state.ts": "2018-02-22 00:32:35", "state.title": "Bechar", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "8": { "state.id": 8, "state.ts": "2018-02-22 00:32:35", "state.title": "Bejaia", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "9": { "state.id": 9, "state.ts": "2018-02-22 00:32:35", "state.title": "Biskra", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "10": { "state.id": 10, "state.ts": "2018-02-22 00:32:35", "state.title": "Blida", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "11": { "state.id": 11, "state.ts": "2018-02-22 00:32:35", "state.title": "Bordj-Bou-Arreridj", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "12": { "state.id": 12, "state.ts": "2018-02-22 00:32:35", "state.title": "Bouira", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "13": { "state.id": 13, "state.ts": "2018-02-22 00:32:35", "state.title": "Boumerdes", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "14": { "state.id": 14, "state.ts": "2018-02-22 00:32:35", "state.title": "Chlef", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "15": { "state.id": 15, "state.ts": "2018-02-22 00:32:35", "state.title": "Constantine", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "16": { "state.id": 16, "state.ts": "2018-02-22 00:32:35", "state.title": "Djelfa", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "17": { "state.id": 17, "state.ts": "2018-02-22 00:32:35", "state.title": "El-Bayadh", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "18": { "state.id": 18, "state.ts": "2018-02-22 00:32:35", "state.title": "El-Oued", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "19": { "state.id": 19, "state.ts": "2018-02-22 00:32:35", "state.title": "El-Taref", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "20": { "state.id": 20, "state.ts": "2018-02-22 00:32:35", "state.title": "Ghardaia", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "21": { "state.id": 21, "state.ts": "2018-02-22 00:32:35", "state.title": "Guelma", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "22": { "state.id": 22, "state.ts": "2018-02-22 00:32:35", "state.title": "Illizi", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "23": { "state.id": 23, "state.ts": "2018-02-22 00:32:35", "state.title": "Jijel", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "24": { "state.id": 24, "state.ts": "2018-02-22 00:32:35", "state.title": "Khenchela", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "25": { "state.id": 25, "state.ts": "2018-02-22 00:32:35", "state.title": "L.aghouat", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "26": { "state.id": 26, "state.ts": "2018-02-22 00:32:35", "state.title": "M'sila", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "27": { "state.id": 27, "state.ts": "2018-02-22 00:32:35", "state.title": "Mascara", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "28": { "state.id": 28, "state.ts": "2018-02-22 00:32:35", "state.title": "Medea", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "29": { "state.id": 29, "state.ts": "2018-02-22 00:32:35", "state.title": "Mila", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "30": { "state.id": 30, "state.ts": "2018-02-22 00:32:35", "state.title": "Mostaganem", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "31": { "state.id": 31, "state.ts": "2018-02-22 00:32:35", "state.title": "Naama", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "32": { "state.id": 32, "state.ts": "2018-02-22 00:32:35", "state.title": "Oran", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "33": { "state.id": 33, "state.ts": "2018-02-22 00:32:35", "state.title": "Ouargla", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "34": { "state.id": 34, "state.ts": "2018-02-22 00:32:35", "state.title": "Oum-El-Bouaghi", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "35": { "state.id": 35, "state.ts": "2018-02-22 00:32:35", "state.title": "Relizane", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "36": { "state.id": 36, "state.ts": "2018-02-22 00:32:35", "state.title": "Saida", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "37": { "state.id": 37, "state.ts": "2018-02-22 00:32:35", "state.title": "Setif", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "38": { "state.id": 38, "state.ts": "2018-02-22 00:32:35", "state.title": "Sidi-Bel-Abbes", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "39": { "state.id": 39, "state.ts": "2018-02-22 00:32:35", "state.title": "Skikda", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "40": { "state.id": 40, "state.ts": "2018-02-22 00:32:35", "state.title": "Souk-Ahras", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "41": { "state.id": 41, "state.ts": "2018-02-22 00:32:35", "state.title": "Tamanrasset", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "42": { "state.id": 42, "state.ts": "2018-02-22 00:32:35", "state.title": "Tebessa", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "43": { "state.id": 43, "state.ts": "2018-02-22 00:32:35", "state.title": "Tiaret", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "44": { "state.id": 44, "state.ts": "2018-02-22 00:32:35", "state.title": "Tindouf", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "45": { "state.id": 45, "state.ts": "2018-02-22 00:32:35", "state.title": "Tipaza", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "46": { "state.id": 46, "state.ts": "2018-02-22 00:32:35", "state.title": "Tissemsilt", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "47": { "state.id": 47, "state.ts": "2018-02-22 00:32:35", "state.title": "Tizi-Ouzou", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "48": { "state.id": 48, "state.ts": "2018-02-22 00:32:35", "state.title": "Tlemcen", "state.country": "Algeria", "country.id": 1, "country.ts": "2018-02-22 00:31:13", "country.title": "Algeria" }, "49": { "state.id": 49, "state.ts": "2018-02-22 00:32:42", "state.title": "As", "state.country": "American Samoa", "country.id": 2, "country.ts": "2018-02-22 00:31:13", "country.title": "American Samoa" }, "50": { "state.id": 50, "state.ts": "2018-02-22 00:32:56", "state.title": "Buenos Aires", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "51": { "state.id": 51, "state.ts": "2018-02-22 00:32:56", "state.title": "Catamarca", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "52": { "state.id": 52, "state.ts": "2018-02-22 00:32:56", "state.title": "Chaco", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "53": { "state.id": 53, "state.ts": "2018-02-22 00:32:56", "state.title": "Chubut", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "54": { "state.id": 54, "state.ts": "2018-02-22 00:32:56", "state.title": "Cordoba", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "55": { "state.id": 55, "state.ts": "2018-02-22 00:32:56", "state.title": "Corrientes", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "56": { "state.id": 56, "state.ts": "2018-02-22 00:32:56", "state.title": "Entre Rios", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "57": { "state.id": 57, "state.ts": "2018-02-22 00:32:56", "state.title": "Formosa", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "58": { "state.id": 58, "state.ts": "2018-02-22 00:32:56", "state.title": "Jujuy", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "59": { "state.id": 59, "state.ts": "2018-02-22 00:32:56", "state.title": "La Pampa", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "60": { "state.id": 60, "state.ts": "2018-02-22 00:32:56", "state.title": "La Rioja", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "61": { "state.id": 61, "state.ts": "2018-02-22 00:32:56", "state.title": "Mendoza", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "62": { "state.id": 62, "state.ts": "2018-02-22 00:32:56", "state.title": "Misiones", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "63": { "state.id": 63, "state.ts": "2018-02-22 00:32:56", "state.title": "Neuquen", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "64": { "state.id": 64, "state.ts": "2018-02-22 00:32:56", "state.title": "Rio Negro", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "65": { "state.id": 65, "state.ts": "2018-02-22 00:32:56", "state.title": "Salta", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "66": { "state.id": 66, "state.ts": "2018-02-22 00:32:56", "state.title": "San Juan", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "67": { "state.id": 67, "state.ts": "2018-02-22 00:32:56", "state.title": "San Luis", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "68": { "state.id": 68, "state.ts": "2018-02-22 00:32:56", "state.title": "Santa Cruz", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "69": { "state.id": 69, "state.ts": "2018-02-22 00:32:56", "state.title": "Santa Fe", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "70": { "state.id": 70, "state.ts": "2018-02-22 00:32:56", "state.title": "Santiago Del Estero", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "71": { "state.id": 71, "state.ts": "2018-02-22 00:32:56", "state.title": "Tierra Del Fuego", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "72": { "state.id": 72, "state.ts": "2018-02-22 00:32:56", "state.title": "Tucuman", "state.country": "Argentina", "country.id": 4, "country.ts": "2018-02-22 00:31:13", "country.title": "Argentina" }, "73": { "state.id": 73, "state.ts": "2018-02-22 00:33:05", "state.title": "Australian Capital Territory", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "74": { "state.id": 74, "state.ts": "2018-02-22 00:33:05", "state.title": "New South Wales", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "75": { "state.id": 75, "state.ts": "2018-02-22 00:33:05", "state.title": "Northern Territory", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "76": { "state.id": 76, "state.ts": "2018-02-22 00:33:05", "state.title": "Queensland", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "77": { "state.id": 77, "state.ts": "2018-02-22 00:33:05", "state.title": "South Australia", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "78": { "state.id": 78, "state.ts": "2018-02-22 00:33:05", "state.title": "Tasmania", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "79": { "state.id": 79, "state.ts": "2018-02-22 00:33:05", "state.title": "Victoria", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "80": { "state.id": 80, "state.ts": "2018-02-22 00:33:05", "state.title": "Western Australia", "state.country": "Australia", "country.id": 5, "country.ts": "2018-02-22 00:31:13", "country.title": "Australia" }, "81": { "state.id": 81, "state.ts": "2018-02-22 00:33:10", "state.title": "Burgenland", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "82": { "state.id": 82, "state.ts": "2018-02-22 00:33:10", "state.title": "Karnten", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "83": { "state.id": 83, "state.ts": "2018-02-22 00:33:10", "state.title": "Niederosterreich", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "84": { "state.id": 84, "state.ts": "2018-02-22 00:33:10", "state.title": "Oberosterreich", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "85": { "state.id": 85, "state.ts": "2018-02-22 00:33:10", "state.title": "Salzburg", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "86": { "state.id": 86, "state.ts": "2018-02-22 00:33:10", "state.title": "Steiermark", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "87": { "state.id": 87, "state.ts": "2018-02-22 00:33:10", "state.title": "Tirol", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "88": { "state.id": 88, "state.ts": "2018-02-22 00:33:10", "state.title": "Vorarlberg", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "89": { "state.id": 89, "state.ts": "2018-02-22 00:33:10", "state.title": "Wien", "state.country": "Austria", "country.id": 6, "country.ts": "2018-02-22 00:31:13", "country.title": "Austria" }, "90": { "state.id": 90, "state.ts": "2018-02-22 00:33:14", "state.title": "Barisal Division", "state.country": "Bangladesh", "country.id": 7, "country.ts": "2018-02-22 00:31:13", "country.title": "Bangladesh" }, "91": { "state.id": 91, "state.ts": "2018-02-22 00:33:14", "state.title": "Chittagong", "state.country": "Bangladesh", "country.id": 7, "country.ts": "2018-02-22 00:31:13", "country.title": "Bangladesh" }, "92": { "state.id": 92, "state.ts": "2018-02-22 00:33:14", "state.title": "Dhaka Division", "state.country": "Bangladesh", "country.id": 7, "country.ts": "2018-02-22 00:31:13", "country.title": "Bangladesh" }, "93": { "state.id": 93, "state.ts": "2018-02-22 00:33:14", "state.title": "Khulna Division", "state.country": "Bangladesh", "country.id": 7, "country.ts": "2018-02-22 00:31:13", "country.title": "Bangladesh" }, "94": { "state.id": 94, "state.ts": "2018-02-22 00:33:14", "state.title": "Rajshahi Division", "state.country": "Bangladesh", "country.id": 7, "country.ts": "2018-02-22 00:31:13", "country.title": "Bangladesh" }, "95": { "state.id": 95, "state.ts": "2018-02-22 00:33:14", "state.title": "Rangpur Division", "state.country": "Bangladesh", "country.id": 7, "country.ts": "2018-02-22 00:31:13", "country.title": "Bangladesh" }, "96": { "state.id": 96, "state.ts": "2018-02-22 00:33:14", "state.title": "Sylhet Division", "state.country": "Bangladesh", "country.id": 7, "country.ts": "2018-02-22 00:31:13", "country.title": "Bangladesh" }, "97": { "state.id": 97, "state.ts": "2018-02-22 00:33:23", "state.title": "Bruxelles-Capitale", "state.country": "Belgium", "country.id": 8, "country.ts": "2018-02-22 00:31:13", "country.title": "Belgium" }, "98": { "state.id": 98, "state.ts": "2018-02-22 00:33:23", "state.title": "Vlaanderen", "state.country": "Belgium", "country.id": 8, "country.ts": "2018-02-22 00:31:13", "country.title": "Belgium" }, "99": { "state.id": 99, "state.ts": "2018-02-22 00:33:23", "state.title": "Wallonie", "state.country": "Belgium", "country.id": 8, "country.ts": "2018-02-22 00:31:13", "country.title": "Belgium" }, "100": { "state.id": 100, "state.ts": "2018-02-22 00:33:30", "state.title": "Acre", "state.country": "Brazil", "country.id": 9, "country.ts": "2018-02-22 00:31:13", "country.title": "Brazil" } } } }