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" }, "prev": { "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/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.0016700000000000000434374758384592496440745890140533447265625 }, "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": { "101": { "city.id": 101, "city.ts": "2022-10-19 10:49:17", "city.city": "Tolleson", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "102": { "city.id": 102, "city.ts": "2022-10-19 10:49:17", "city.city": "Tucson", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arizona", "city.title": "" }, "105": { "city.id": 105, "city.ts": "2022-10-19 10:49:19", "city.city": "Arkadelphia", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "106": { "city.id": 106, "city.ts": "2022-10-19 10:49:19", "city.city": "Ashdown", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "107": { "city.id": 107, "city.ts": "2022-10-19 10:49:19", "city.city": "Benton", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "108": { "city.id": 108, "city.ts": "2022-10-19 10:49:19", "city.city": "Chidester", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "109": { "city.id": 109, "city.ts": "2022-10-19 10:49:19", "city.city": "Crossett", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "110": { "city.id": 110, "city.ts": "2022-10-19 10:49:19", "city.city": "El Dorado", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "111": { "city.id": 111, "city.ts": "2022-10-19 10:49:19", "city.city": "Fort Smith", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "112": { "city.id": 112, "city.ts": "2022-10-19 10:49:19", "city.city": "Harrisburg", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "113": { "city.id": 113, "city.ts": "2022-10-19 10:49:19", "city.city": "Hot Springs", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "114": { "city.id": 114, "city.ts": "2022-10-19 10:49:19", "city.city": "Lake Village", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "115": { "city.id": 115, "city.ts": "2022-10-19 10:49:19", "city.city": "Little Rock", "city.total": 10, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "116": { "city.id": 116, "city.ts": "2022-10-19 10:49:19", "city.city": "Malvern", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "117": { "city.id": 117, "city.ts": "2022-10-19 10:49:19", "city.city": "Marvell", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "118": { "city.id": 118, "city.ts": "2022-10-19 10:49:19", "city.city": "Mineral Springs", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "119": { "city.id": 119, "city.ts": "2022-10-19 10:49:19", "city.city": "Monticello", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "120": { "city.id": 120, "city.ts": "2022-10-19 10:49:19", "city.city": "N Little Rock", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "121": { "city.id": 121, "city.ts": "2022-10-19 10:49:19", "city.city": "Pine Bluff", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "122": { "city.id": 122, "city.ts": "2022-10-19 10:49:19", "city.city": "Prescott", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "123": { "city.id": 123, "city.ts": "2022-10-19 10:49:19", "city.city": "Redfield", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "124": { "city.id": 124, "city.ts": "2022-10-19 10:49:19", "city.city": "Rison", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "125": { "city.id": 125, "city.ts": "2022-10-19 10:49:19", "city.city": "Sheridan", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "126": { "city.id": 126, "city.ts": "2022-10-19 10:49:19", "city.city": "Waldo", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "127": { "city.id": 127, "city.ts": "2022-10-19 10:49:19", "city.city": "Wilmar", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "Arkansas", "city.title": "" }, "130": { "city.id": 130, "city.ts": "2022-10-19 10:49:23", "city.city": "Alameda", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "131": { "city.id": 131, "city.ts": "2022-10-19 10:49:23", "city.city": "Albany", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "132": { "city.id": 132, "city.ts": "2022-10-19 10:49:23", "city.city": "Alpine", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "133": { "city.id": 133, "city.ts": "2022-10-19 10:49:23", "city.city": "American Canyon", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "134": { "city.id": 134, "city.ts": "2022-10-19 10:49:23", "city.city": "Anaheim", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "135": { "city.id": 135, "city.ts": "2022-10-19 10:49:23", "city.city": "Antelope", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "136": { "city.id": 136, "city.ts": "2022-10-19 10:49:23", "city.city": "Auburn", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "137": { "city.id": 137, "city.ts": "2022-10-19 10:49:23", "city.city": "Barstow", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "138": { "city.id": 138, "city.ts": "2022-10-19 10:49:23", "city.city": "Bay Point", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "139": { "city.id": 139, "city.ts": "2022-10-19 10:49:23", "city.city": "Benicia", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "140": { "city.id": 140, "city.ts": "2022-10-19 10:49:23", "city.city": "Berkeley", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "141": { "city.id": 141, "city.ts": "2022-10-19 10:49:23", "city.city": "Bonita", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "142": { "city.id": 142, "city.ts": "2022-10-19 10:49:23", "city.city": "Burlingame", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "143": { "city.id": 143, "city.ts": "2022-10-19 10:49:23", "city.city": "Camarillo", "city.total": 8, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "144": { "city.id": 144, "city.ts": "2022-10-19 10:49:23", "city.city": "Campbell", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "145": { "city.id": 145, "city.ts": "2022-10-19 10:49:23", "city.city": "Canoga Park", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "146": { "city.id": 146, "city.ts": "2022-10-19 10:49:23", "city.city": "Cardiff", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "147": { "city.id": 147, "city.ts": "2022-10-19 10:49:23", "city.city": "Carlsbad", "city.total": 6, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "148": { "city.id": 148, "city.ts": "2022-10-19 10:49:23", "city.city": "Carmichael", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "149": { "city.id": 149, "city.ts": "2022-10-19 10:49:23", "city.city": "Castro Valley", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "150": { "city.id": 150, "city.ts": "2022-10-19 10:49:23", "city.city": "Chico", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "151": { "city.id": 151, "city.ts": "2022-10-19 10:49:23", "city.city": "Chula Vista", "city.total": 20, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "152": { "city.id": 152, "city.ts": "2022-10-19 10:49:23", "city.city": "Concord", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "153": { "city.id": 153, "city.ts": "2022-10-19 10:49:23", "city.city": "Corona", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "154": { "city.id": 154, "city.ts": "2022-10-19 10:49:23", "city.city": "Corte Madera", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "155": { "city.id": 155, "city.ts": "2022-10-19 10:49:23", "city.city": "Daly City", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "156": { "city.id": 156, "city.ts": "2022-10-19 10:49:23", "city.city": "Delano", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "157": { "city.id": 157, "city.ts": "2022-10-19 10:49:23", "city.city": "Dublin", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "158": { "city.id": 158, "city.ts": "2022-10-19 10:49:23", "city.city": "East Palo Alto", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "159": { "city.id": 159, "city.ts": "2022-10-19 10:49:23", "city.city": "El Cajon", "city.total": 14, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "160": { "city.id": 160, "city.ts": "2022-10-19 10:49:23", "city.city": "El Centro", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "161": { "city.id": 161, "city.ts": "2022-10-19 10:49:23", "city.city": "Elk Grove", "city.total": 7, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "162": { "city.id": 162, "city.ts": "2022-10-19 10:49:23", "city.city": "Encinitas", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "163": { "city.id": 163, "city.ts": "2022-10-19 10:49:23", "city.city": "Escondido", "city.total": 9, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "164": { "city.id": 164, "city.ts": "2022-10-19 10:49:23", "city.city": "Fair Oaks", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "165": { "city.id": 165, "city.ts": "2022-10-19 10:49:23", "city.city": "Fairfield", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "166": { "city.id": 166, "city.ts": "2022-10-19 10:49:23", "city.city": "Fillmore", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "167": { "city.id": 167, "city.ts": "2022-10-19 10:49:23", "city.city": "Folsom", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "168": { "city.id": 168, "city.ts": "2022-10-19 10:49:23", "city.city": "Fontana", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "169": { "city.id": 169, "city.ts": "2022-10-19 10:49:23", "city.city": "Foster City", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "170": { "city.id": 170, "city.ts": "2022-10-19 10:49:23", "city.city": "Fremont", "city.total": 11, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "171": { "city.id": 171, "city.ts": "2022-10-19 10:49:23", "city.city": "Gilroy", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "172": { "city.id": 172, "city.ts": "2022-10-19 10:49:23", "city.city": "Hayward", "city.total": 10, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "173": { "city.id": 173, "city.ts": "2022-10-19 10:49:23", "city.city": "Hercules", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "174": { "city.id": 174, "city.ts": "2022-10-19 10:49:23", "city.city": "Hollister", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "175": { "city.id": 175, "city.ts": "2022-10-19 10:49:23", "city.city": "Imperial Beach", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "176": { "city.id": 176, "city.ts": "2022-10-19 10:49:23", "city.city": "Inglewood", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "177": { "city.id": 177, "city.ts": "2022-10-19 10:49:23", "city.city": "La Habra", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "178": { "city.id": 178, "city.ts": "2022-10-19 10:49:23", "city.city": "La Jolla", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "179": { "city.id": 179, "city.ts": "2022-10-19 10:49:23", "city.city": "La Mesa", "city.total": 4, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "180": { "city.id": 180, "city.ts": "2022-10-19 10:49:23", "city.city": "Lakeside", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "181": { "city.id": 181, "city.ts": "2022-10-19 10:49:23", "city.city": "Lemon Grove", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "182": { "city.id": 182, "city.ts": "2022-10-19 10:49:23", "city.city": "Littlerock", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "183": { "city.id": 183, "city.ts": "2022-10-19 10:49:23", "city.city": "Long Beach", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "184": { "city.id": 184, "city.ts": "2022-10-19 10:49:23", "city.city": "Los Angeles", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "185": { "city.id": 185, "city.ts": "2022-10-19 10:49:23", "city.city": "Los Gatos", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "186": { "city.id": 186, "city.ts": "2022-10-19 10:49:23", "city.city": "Madera", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "187": { "city.id": 187, "city.ts": "2022-10-19 10:49:23", "city.city": "Merced", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "188": { "city.id": 188, "city.ts": "2022-10-19 10:49:23", "city.city": "Milpitas", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "189": { "city.id": 189, "city.ts": "2022-10-19 10:49:23", "city.city": "Moorpark", "city.total": 6, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "190": { "city.id": 190, "city.ts": "2022-10-19 10:49:23", "city.city": "Moreno Valley", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "191": { "city.id": 191, "city.ts": "2022-10-19 10:49:23", "city.city": "Morgan Hill", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "192": { "city.id": 192, "city.ts": "2022-10-19 10:49:23", "city.city": "Mountain View", "city.total": 5, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "193": { "city.id": 193, "city.ts": "2022-10-19 10:49:23", "city.city": "Murrieta", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "194": { "city.id": 194, "city.ts": "2022-10-19 10:49:23", "city.city": "National City", "city.total": 7, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "195": { "city.id": 195, "city.ts": "2022-10-19 10:49:23", "city.city": "Newark", "city.total": 2, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "196": { "city.id": 196, "city.ts": "2022-10-19 10:49:23", "city.city": "Newbury Park", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "197": { "city.id": 197, "city.ts": "2022-10-19 10:49:23", "city.city": "North Highlands", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "198": { "city.id": 198, "city.ts": "2022-10-19 10:49:23", "city.city": "Novato", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "199": { "city.id": 199, "city.ts": "2022-10-19 10:49:23", "city.city": "Oak View", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "200": { "city.id": 200, "city.ts": "2022-10-19 10:49:23", "city.city": "Oakland", "city.total": 21, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "201": { "city.id": 201, "city.ts": "2022-10-19 10:49:23", "city.city": "Oceanside", "city.total": 8, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "202": { "city.id": 202, "city.ts": "2022-10-19 10:49:23", "city.city": "Ojai", "city.total": 3, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "203": { "city.id": 203, "city.ts": "2022-10-19 10:49:23", "city.city": "Orangevale", "city.total": 1, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" }, "204": { "city.id": 204, "city.ts": "2022-10-19 10:49:23", "city.city": "Oxnard", "city.total": 15, "city.denomination": "African Methodist Episcopal", "city.state": "California", "city.title": "" } } } }