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": "US & Canada Churches Data: Emails, Address, Denomination, Longitude and Latitude", "desc": "This is a churches database in the United States and Canada. Each record is comprised of address, zip code, denomination, state, city, phone number, email, website, lat, lng, etc.\n\nAll these churches are grouped into 94 denominations with total in each. \n\nThe whole US and Canada churches database has 5 tables.", "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/church_in_the_united_states_canada_4/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/church_in_the_united_states_canada_4/by_table/city/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/church_in_the_united_states_canada_4/by_table/city/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.001850000000000000081878948066105294856242835521697998046875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 147703, "pages_total": 1478 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city.id": 1, "city.ts": "2022-10-19 10:46:56", "city.city": "Lakeland", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "Florida", "city.title": "" }, "2": { "city.id": 2, "city.ts": "2022-10-19 10:48:44", "city.city": "Lewiston", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "Idaho", "city.title": "" }, "3": { "city.id": 3, "city.ts": "2022-10-19 10:48:46", "city.city": "Pacific", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "Missouri", "city.title": "" }, "4": { "city.id": 4, "city.ts": "2022-10-19 10:48:54", "city.city": "Garner", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "North Carolina", "city.title": "" }, "5": { "city.id": 5, "city.ts": "2022-10-19 10:48:54", "city.city": "Oak Ridge", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "North Carolina", "city.title": "" }, "6": { "city.id": 6, "city.ts": "2022-10-19 10:48:54", "city.city": "Wilmington", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "North Carolina", "city.title": "" }, "7": { "city.id": 7, "city.ts": "2022-10-19 10:48:57", "city.city": "Richwood", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "Ohio", "city.title": "" }, "8": { "city.id": 8, "city.ts": "2022-10-19 10:49:04", "city.city": "Madison", "city.total": 1, "city.denomination": "Advent Christian", "city.state": "Wisconsin", "city.title": "" }, "9": { "city.id": 9, "city.ts": "2022-10-19 10:49:12", "city.city": "Abbeville", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "10": { "city.id": 10, "city.ts": "2022-10-19 10:49:12", "city.city": "Adamsville", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "11": { "city.id": 11, "city.ts": "2022-10-19 10:49:12", "city.city": "Alberta", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "12": { "city.id": 12, "city.ts": "2022-10-19 10:49:12", "city.city": "Andalusia", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "13": { "city.id": 13, "city.ts": "2022-10-19 10:49:12", "city.city": "Anniston", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "14": { "city.id": 14, "city.ts": "2022-10-19 10:49:12", "city.city": "Atmore", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "15": { "city.id": 15, "city.ts": "2022-10-19 10:49:12", "city.city": "Auburn", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "16": { "city.id": 16, "city.ts": "2022-10-19 10:49:12", "city.city": "Bessemer", "city.total": 7, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "17": { "city.id": 17, "city.ts": "2022-10-19 10:49:12", "city.city": "Birmingham", "city.total": 30, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "18": { "city.id": 18, "city.ts": "2022-10-19 10:49:12", "city.city": "Brantley", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "19": { "city.id": 19, "city.ts": "2022-10-19 10:49:12", "city.city": "Brewton", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "20": { "city.id": 20, "city.ts": "2022-10-19 10:49:12", "city.city": "Brierfield", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "21": { "city.id": 21, "city.ts": "2022-10-19 10:49:12", "city.city": "Brundidge", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "22": { "city.id": 22, "city.ts": "2022-10-19 10:49:12", "city.city": "Butler", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "23": { "city.id": 23, "city.ts": "2022-10-19 10:49:12", "city.city": "Calera", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "24": { "city.id": 24, "city.ts": "2022-10-19 10:49:12", "city.city": "Clio", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "25": { "city.id": 25, "city.ts": "2022-10-19 10:49:12", "city.city": "Demopolis", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "26": { "city.id": 26, "city.ts": "2022-10-19 10:49:12", "city.city": "Dora", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "27": { "city.id": 27, "city.ts": "2022-10-19 10:49:12", "city.city": "Dothan", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "28": { "city.id": 28, "city.ts": "2022-10-19 10:49:12", "city.city": "Eight Mile", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "29": { "city.id": 29, "city.ts": "2022-10-19 10:49:12", "city.city": "Elba", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "30": { "city.id": 30, "city.ts": "2022-10-19 10:49:12", "city.city": "Elmore", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "31": { "city.id": 31, "city.ts": "2022-10-19 10:49:12", "city.city": "Enterprise", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "32": { "city.id": 32, "city.ts": "2022-10-19 10:49:12", "city.city": "Evergreen", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "33": { "city.id": 33, "city.ts": "2022-10-19 10:49:12", "city.city": "Fairhope", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "34": { "city.id": 34, "city.ts": "2022-10-19 10:49:12", "city.city": "Florence", "city.total": 5, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "35": { "city.id": 35, "city.ts": "2022-10-19 10:49:12", "city.city": "Franklin", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "36": { "city.id": 36, "city.ts": "2022-10-19 10:49:12", "city.city": "Gadsden", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "37": { "city.id": 37, "city.ts": "2022-10-19 10:49:12", "city.city": "Geneva", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "38": { "city.id": 38, "city.ts": "2022-10-19 10:49:12", "city.city": "Grand Bay", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "39": { "city.id": 39, "city.ts": "2022-10-19 10:49:12", "city.city": "Greensboro", "city.total": 6, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "40": { "city.id": 40, "city.ts": "2022-10-19 10:49:12", "city.city": "Greenville", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "41": { "city.id": 41, "city.ts": "2022-10-19 10:49:12", "city.city": "Guntersville", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "42": { "city.id": 42, "city.ts": "2022-10-19 10:49:12", "city.city": "Hayneville", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "43": { "city.id": 43, "city.ts": "2022-10-19 10:49:12", "city.city": "Headland", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "44": { "city.id": 44, "city.ts": "2022-10-19 10:49:12", "city.city": "Huntsville", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "45": { "city.id": 45, "city.ts": "2022-10-19 10:49:12", "city.city": "Irondale", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "46": { "city.id": 46, "city.ts": "2022-10-19 10:49:12", "city.city": "Jasper", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "47": { "city.id": 47, "city.ts": "2022-10-19 10:49:12", "city.city": "Madison", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "48": { "city.id": 48, "city.ts": "2022-10-19 10:49:12", "city.city": "Marion", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "49": { "city.id": 49, "city.ts": "2022-10-19 10:49:12", "city.city": "Millry", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "50": { "city.id": 50, "city.ts": "2022-10-19 10:49:12", "city.city": "Mobile", "city.total": 17, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "51": { "city.id": 51, "city.ts": "2022-10-19 10:49:12", "city.city": "Montevallo", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "52": { "city.id": 52, "city.ts": "2022-10-19 10:49:12", "city.city": "Montgomery", "city.total": 7, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "53": { "city.id": 53, "city.ts": "2022-10-19 10:49:12", "city.city": "New Brockton", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "54": { "city.id": 54, "city.ts": "2022-10-19 10:49:12", "city.city": "Northport", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "55": { "city.id": 55, "city.ts": "2022-10-19 10:49:12", "city.city": "Opelika", "city.total": 10, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "56": { "city.id": 56, "city.ts": "2022-10-19 10:49:12", "city.city": "Opp", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "57": { "city.id": 57, "city.ts": "2022-10-19 10:49:12", "city.city": "Ozark", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "58": { "city.id": 58, "city.ts": "2022-10-19 10:49:12", "city.city": "Panola", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "59": { "city.id": 59, "city.ts": "2022-10-19 10:49:12", "city.city": "Phenix City", "city.total": 7, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "60": { "city.id": 60, "city.ts": "2022-10-19 10:49:12", "city.city": "Pinson", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "61": { "city.id": 61, "city.ts": "2022-10-19 10:49:12", "city.city": "Pittsview", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "62": { "city.id": 62, "city.ts": "2022-10-19 10:49:12", "city.city": "Pleasant Grove", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "63": { "city.id": 63, "city.ts": "2022-10-19 10:49:12", "city.city": "Prattville", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "64": { "city.id": 64, "city.ts": "2022-10-19 10:49:12", "city.city": "Quinton", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "65": { "city.id": 65, "city.ts": "2022-10-19 10:49:12", "city.city": "Saraland", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "66": { "city.id": 66, "city.ts": "2022-10-19 10:49:12", "city.city": "Scottsboro", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "67": { "city.id": 67, "city.ts": "2022-10-19 10:49:12", "city.city": "Selma", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "68": { "city.id": 68, "city.ts": "2022-10-19 10:49:12", "city.city": "Semmes", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "69": { "city.id": 69, "city.ts": "2022-10-19 10:49:12", "city.city": "Sheffield", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "70": { "city.id": 70, "city.ts": "2022-10-19 10:49:12", "city.city": "Sweet Water", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "71": { "city.id": 71, "city.ts": "2022-10-19 10:49:12", "city.city": "Sylacauga", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "72": { "city.id": 72, "city.ts": "2022-10-19 10:49:12", "city.city": "Talladega", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "73": { "city.id": 73, "city.ts": "2022-10-19 10:49:12", "city.city": "Tallassee", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "74": { "city.id": 74, "city.ts": "2022-10-19 10:49:12", "city.city": "Theodore", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "75": { "city.id": 75, "city.ts": "2022-10-19 10:49:12", "city.city": "Thomaston", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "76": { "city.id": 76, "city.ts": "2022-10-19 10:49:12", "city.city": "Troy", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "77": { "city.id": 77, "city.ts": "2022-10-19 10:49:12", "city.city": "Trussville", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "78": { "city.id": 78, "city.ts": "2022-10-19 10:49:12", "city.city": "Tuscaloosa", "city.total": 6, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "79": { "city.id": 79, "city.ts": "2022-10-19 10:49:12", "city.city": "Union Springs", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "80": { "city.id": 80, "city.ts": "2022-10-19 10:49:12", "city.city": "Verbena", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "81": { "city.id": 81, "city.ts": "2022-10-19 10:49:12", "city.city": "Waverly", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "82": { "city.id": 82, "city.ts": "2022-10-19 10:49:12", "city.city": "Wetumpka", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "83": { "city.id": 83, "city.ts": "2022-10-19 10:49:12", "city.city": "", "city.total": "", "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "84": { "city.id": 84, "city.ts": "2022-10-19 10:49:12", "city.city": "", "city.total": "", "city.denomination": "African Methodist Episcopal", "city.state": "Alabama", "city.title": "" }, "85": { "city.id": 85, "city.ts": "2022-10-19 10:49:17", "city.city": "Anthem", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "86": { "city.id": 86, "city.ts": "2022-10-19 10:49:17", "city.city": "Avondale", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "87": { "city.id": 87, "city.ts": "2022-10-19 10:49:17", "city.city": "Chandler", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "88": { "city.id": 88, "city.ts": "2022-10-19 10:49:17", "city.city": "El Mirage", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "89": { "city.id": 89, "city.ts": "2022-10-19 10:49:17", "city.city": "Flagstaff", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "90": { "city.id": 90, "city.ts": "2022-10-19 10:49:17", "city.city": "Gilbert", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "91": { "city.id": 91, "city.ts": "2022-10-19 10:49:17", "city.city": "Glendale", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "92": { "city.id": 92, "city.ts": "2022-10-19 10:49:17", "city.city": "Maricopa", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "93": { "city.id": 93, "city.ts": "2022-10-19 10:49:17", "city.city": "Mesa", "city.total": 5, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "94": { "city.id": 94, "city.ts": "2022-10-19 10:49:17", "city.city": "Payson", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "95": { "city.id": 95, "city.ts": "2022-10-19 10:49:17", "city.city": "Peoria", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "96": { "city.id": 96, "city.ts": "2022-10-19 10:49:17", "city.city": "Phoenix", "city.total": 27, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "97": { "city.id": 97, "city.ts": "2022-10-19 10:49:17", "city.city": "Pine", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "98": { "city.id": 98, "city.ts": "2022-10-19 10:49:17", "city.city": "Scottsdale", "city.total": 5, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "99": { "city.id": 99, "city.ts": "2022-10-19 10:49:17", "city.city": "Surprise", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "100": { "city.id": 100, "city.ts": "2022-10-19 10:49:17", "city.city": "Tempe", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" } } } }