API Documentation

Notes

* Curley brackets ( { } ) indicate required field

Authentication: logging in a user

API Key

Pass your api_key with each request via url paramater
?api_key=your_key

Pagination

Default	100 records per page (25 with connected data)
Limit	1,000 records per page. 3,000 records per page if 'fields' are specified. 50 records per page with connected_data.
Custom	Set the number or records per return by adding the URL parameter: '?limit=num_records'
Specify Page	Specify which page of data to return with URL parameter: '?page=page_number'
Results	Information is included with each response in the meta object:
	meta: { pagination: { total_count: 100, total_pages: 1, current_page: 1, limit: 500 } },

Sorting

Default	Sort by ID field descending
Custom Sort Field	Add URL parameter: '?sort=sort_field'
Custom Sort Direction	Add URL parameter: '?direction=asc OR desc'

Specify Fields & Connected Data

Specify Fields

Default	All fields returned from base data
Custom Field List	Set the fields you need with URL parameter: '?fields=fields (add more by separating with a pipe \| )'
Custom Connected Data	Included connected models / data, such as language or country data for the primary language of the people group. '?connected_data=connected_data_name (add more by separating with a pipe \| )'
*NOTE	The fields option applies to connected_data also. The fields you specify will be evaluated for the original and each connected_data objects

Response Codes

HTTP Status Code	Reason
200	Success
401	To Many Login Attempts
404	No Data Found
403	Access Forbidden
403	Access Forbidden
406	Data Validation Error
500	Internal Server Error

Resouces

People Groups Unreached of the Day Countries Languages

quick links:

People Groups Unreached of the Day Countries Languages

People Groups Resource

GET - https://joshuaproject.net/api/v2/people_groups?api_key=yourkey

Sample

{"meta":{"pagination":{"total_count":17267,"total_pages":8634,"current_page":1,"limit":2}},"data":[{"PeopleID3ROG3":"18385CH","ROG3":"CH","Ctry":"China","CtryShort":"China","CtryLiteracyRate":97,"CtryLiteracySource":"Ethnologue","PeopleID3":18385,"PeopNameInCountry":"A Che","PeopNameAcrossCountries":"A Che","NaturalName":"A Che","NaturalPronunciation":"ah chay","PeopCtryConcatenation":"in","Population":42000,"PopulationRange":1,"ROG2":"ASI","Continent":"Asia","RegionCode":3,"RegionName":"Asia, Northeast","10_40Window":"Y","RLG3PrimaryCtry":7,"ReligionPrimaryCtry":"Non-Religious","LocationInCountry":"Approximately 35,000 A Che people predominantly live in Shuangbai (23,000) and Yimen (11,100) counties in the eastern part of Yunnan Province's Chuxiong Prefecture. Other A Che villages spill over into Lufeng and Eshan counties in Yuxi Prefecture. Most of the A Che in Shuangbai County are extremely isolated. In Yuxi Prefecture, on the other hand, some A Che villages are a mere five kilometers (three mi.) from Yimen City.","PeopleID1":23,"AffinityBloc":"Tibetan-Himalayan Peoples","PeopleID2":317,"PeopleCluster":"Tibeto-Burman, other","JPScalePC":4,"PopulationPGAC":42000,"JPScalePGAC":1,"JPScale":1,"JPScaleTemp":null,"LeastReached":"Y","Frontier":"Y","WorkersNeeded":1,"Subgroups":null,"ROP25":300001,"ROP25Name":"A Che","ROP3":113978,"ROL3":"yif","PrimaryLanguageName":"Ache","ROL4":0,"PrimaryLanguageDialect":null,"Written":"Y","BibleStatus":3,"NumberLanguagesSpoken":1,"RLG3":4,"PrimaryReligion":"Ethnic Religions","RLG4":null,"ReligionSubdivision":null,"PercentAdherents":0,"CountAdherents":0,"PercentEvangelical":0,"CountEvangelical":0,"PCBuddhism":0,"PCDblyProfessing":null,"PCEthnicReligions":98,"PCHinduism":0,"PCIslam":0,"PCNonReligious":2,"PCOtherSmall":0,"PCUnknown":0,"PCAnglican":null,"PCIndependent":null,"PCProtestant":null,"PCOrthodox":null,"PCOtherChristian":null,"PCRomanCatholic":null,"IndigenousCode":"Y","CasteClass":null,"LRofTheDayYear":null,"Photo":"Y","PhotoAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/photos\/p18385.jpg","PhotoGood":"N","PhotoCredits":"Operation China, Asia Harvest","PhotoCreditURL":"https:\/\/www.asiaharvest.org","PhotoCreativeCommons":"N","PhotoCCVersionText":null,"PhotoCCVersionURL":null,"PhotoCopyright":"Y","PhotoRepresentative":null,"Map":"Y","MapAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/maps\/m18385_ch.png","MapSource":"MR","MapCredits":"People Group location: IMB. Map geography: ESRI \/ GMI. Map design: Joshua Project.","MapCreditURL":null,"MapCopyright":"N","MapCCVersionText":null,"MapCCVersionURL":null,"AudioAddress":"a18385.mp3","HandoutAddress":"h18385_ch.pdf","GSEC":1,"JF":"Y","AudioRecordings":"Y","NTOnline":null,"GospelRadio":"N","PEID":6651,"Longitude":101.974209999999999354258761741220951080322265625,"Latitude":24.68310999999999921783455647528171539306640625},{"PeopleID3ROG3":"18399CH","ROG3":"CH","Ctry":"China","CtryShort":"China","CtryLiteracyRate":97,"CtryLiteracySource":"Ethnologue","PeopleID3":18399,"PeopNameInCountry":"A'ou","PeopNameAcrossCountries":"A'ou","NaturalName":"A'ou","NaturalPronunciation":"Ah-ow","PeopCtryConcatenation":"in","Population":2800,"PopulationRange":1,"ROG2":"ASI","Continent":"Asia","RegionCode":3,"RegionName":"Asia, Northeast","10_40Window":"Y","RLG3PrimaryCtry":7,"ReligionPrimaryCtry":"Non-Religious","LocationInCountry":"With a population of approximately 2,000 speakers, the A'ou ethnic group inhabits three counties in the north central part of Guizhou Province in southern China. They are concentrated in the Longjiazhai District of Zhijin County; in the Shawo, Lannigou, and Xinkaitian districts of Qianxi County; and in and around the town of Pudi in Dafang County.","PeopleID1":20,"AffinityBloc":"Southeast Asian Peoples","PeopleID2":295,"PeopleCluster":"Tai","JPScalePC":1,"PopulationPGAC":2800,"JPScalePGAC":1,"JPScale":1,"JPScaleTemp":null,"LeastReached":"Y","Frontier":"Y","WorkersNeeded":1,"Subgroups":null,"ROP25":300380,"ROP25Name":"A'ou","ROP3":113993,"ROL3":"cmn","PrimaryLanguageName":"Chinese, Mandarin","ROL4":0,"PrimaryLanguageDialect":null,"Written":"Y","BibleStatus":5,"NumberLanguagesSpoken":2,"RLG3":4,"PrimaryReligion":"Ethnic Religions","RLG4":null,"ReligionSubdivision":null,"PercentAdherents":0,"CountAdherents":0,"PercentEvangelical":0,"CountEvangelical":0,"PCBuddhism":5,"PCDblyProfessing":null,"PCEthnicReligions":80,"PCHinduism":0,"PCIslam":0,"PCNonReligious":15,"PCOtherSmall":0,"PCUnknown":0,"PCAnglican":null,"PCIndependent":null,"PCProtestant":null,"PCOrthodox":null,"PCOtherChristian":null,"PCRomanCatholic":null,"IndigenousCode":"Y","CasteClass":null,"LRofTheDayYear":null,"Photo":"Y","PhotoAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/photos\/p18399.jpg","PhotoGood":"N","PhotoCredits":"Operation China, Asia Harvest","PhotoCreditURL":"https:\/\/www.asiaharvest.org","PhotoCreativeCommons":"N","PhotoCCVersionText":null,"PhotoCCVersionURL":null,"PhotoCopyright":"Y","PhotoRepresentative":null,"Map":"Y","MapAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/maps\/m18399.png","MapSource":null,"MapCredits":"Joshua Project \/ Global Mapping International","MapCreditURL":null,"MapCopyright":"N","MapCCVersionText":null,"MapCCVersionURL":null,"AudioAddress":"","HandoutAddress":"","GSEC":1,"JF":"Y","AudioRecordings":"Y","NTOnline":"Y","GospelRadio":"N","PEID":22147,"Longitude":106.02223729121800488428561948239803314208984375,"Latitude":26.94064487815860076125318300910294055938720703125}],"status":{"message":"Success!","status_code":200}}

Connected Data

Include connected_data(s) by specifying "connected_data=" in your URL: ?connected_data=jplanguages...

Fields: If you specify fields to return (see below) this will apply to connected_data also. The fields you specify will be evaluated for the original and each connected_data objects

Value Description Response Notes

jplanguages Full language data for each people group's primary language Response: One object for each people group with language data for each people group.

jpaltnames Alternate names of people group Response: An object for each alternate name with 'PeopleID3' and 'AltPeopName'.

jpcountries Full country data for each people group Response: One object for each people group name with all fields from the jpcountries table.

jpvideos Full video data if a people group has a video Response: One object for each people group name with all fields from the jpvideos table.

Value	Description	Response Notes
jplanguages	Full language data for each people group's primary language	Response: One object for each people group with language data for each people group.
jpaltnames	Alternate names of people group	Response: An object for each alternate name with 'PeopleID3' and 'AltPeopName'.
jpcountries	Full country data for each people group	Response: One object for each people group name with all fields from the jpcountries table.
jpvideos	Full video data if a people group has a video	Response: One object for each people group name with all fields from the jpvideos table.

Fields

By default all fields returned. Set the fields you need with URL parameter: ?fields=fields (add more by separating with a pipe | )'

Query Parameters

Query by any field below. Check the 'Values' column for possible field values. To query by more than one value per field, separate values with a pipe | . For example: ?ROG3=BG|IN|BN

Custom Comparison Fields

Comparison Field Description

min_population Minimum population of the people group

max_population Max population of the people group

click to sort

Field Type Description Values (value description) Notes

PeopleID3ROG3 varchar(10) Unique Key - PeopleID3 and ROG3 Locate on people group profile

ROG3 varchar(2) FIPS-2 country code

Ctry varchar(50) Country name

CtryShort varchar(50) Short country name Locate on people group profile

CtryLiteracyRate int(11) Country literacy rate value Locate on people group profile

CtryLiteracySource varchar(50) Country literacy rate source Locate on people group profile

PeopleID3 int(11) People-Group-Across-Countries ID number Locate on people group profile

PeopNameInCountry varchar(75) Name of people group in this country Locate on people group profile

PeopNameAcrossCountries varchar(75) Name of people group across countries of residence Locate on people group profile

NaturalName varchar(255) Locate on people group profile

NaturalPronunciation varchar(255) Locate on people group profile

PeopCtryConcatenation varchar(15) Locate on people group profile

Population int(11) Population in this country Locate on people group profile

PopulationRange int(11) Locate on people group profile

ROG2 varchar(3) Registry of Geographic Places continent code

Continent varchar(50) Continent

RegionCode int(11) Region code for this country

RegionName varchar(50) Region name Locate on people group profile

10_40Window varchar(1) Y = in 10/40 Window
'Y' (yes)     'N' (no)

RLG3PrimaryCtry int(11) Locate on people group profile

ReligionPrimaryCtry varchar(255) Locate on people group profile

LocationInCountry longtext Location of people within the country Locate on people group profile

PeopleID1 int(11) Affinity Bloc code

AffinityBloc varchar(50) Affinity Bloc for this people group

PeopleID2 int(11) People cluster code

PeopleCluster varchar(50) People cluster

JPScalePC varchar(1) JPScale, people cluster
More Information

PopulationPGAC int(11) Population forthis PeopleGroup-Across-Countries Locate on people group profile

JPScalePGAC varchar(1) JPScale, People-Group-Across-Countries
More Information

JPScale int(11) See http://www.joshuaproject.net/definitions.php
More Information

JPScaleTemp int(11) Locate on people group profile

LeastReached varchar(1) Y = Least Reached / unreached. JPScale < 2.0
'Y' (yes)     'N' (no)

Frontier varchar(1) Frontier People Group Locate on people group profile

WorkersNeeded int(11) Estimated workers needed based on 1:50,000 Locate on people group profile

Subgroups int(11) Locate on people group profile

ROP25 int(11) Locate on people group profile

ROP25Name varchar(255) Locate on people group profile

ROP3 int(11) Registry of Peoples - People Group ID Locate on people group profile

ROL3 varchar(3) Ethnologue language code, 17th Edition Locate on people group profile

PrimaryLanguageName varchar(50) Primary language in this country Locate on people group profile

ROL4 int(11) Dialect code Locate on people group profile

PrimaryLanguageDialect varchar(75) Primary language dialect in this country Locate on people group profile

Written varchar(1) Y = language is written Locate on people group profile

BibleStatus int(11) Bible status Locate on people group profile

NumberLanguagesSpoken int(11) Number of languages spoken by this people group in this country Locate on people group profile

RLG3 int(11) Primary religion code Locate on people group profile

PrimaryReligion varchar(50) Primary religion in this country

RLG4 int(11) Religion subdivision code Locate on people group profile

ReligionSubdivision varchar(50) Subdivision of the primary religion Locate on people group profile

PercentAdherents decimal(6,3) % Christian Adherents for this people group Locate on people group profile

CountAdherents int(11) Locate on people group profile

PercentEvangelical decimal(6,3) % Evangelical for this people group Locate on people group profile

CountEvangelical int(11) Locate on people group profile

PCBuddhism double Percent Buddhist Locate on people group profile

PCDblyProfessing double Percent Doubly Professing Locate on people group profile

PCEthnicReligions double Percent Ethnic Religions Locate on people group profile

PCHinduism double Percent Hindu Locate on people group profile

PCIslam double Percent Muslim Locate on people group profile

PCNonReligious double Percent Non-religious Locate on people group profile

PCOtherSmall double Percent Other / Small Locate on people group profile

PCUnknown double Percent Unknown Locate on people group profile

PCAnglican double Percent Anglican Locate on people group profile

PCIndependent double Percent Independent Locate on people group profile

PCProtestant double Percent Protestant Locate on people group profile

PCOrthodox double Percent Orthodox Locate on people group profile

PCOtherChristian double Percent Other Christian Locate on people group profile

PCRomanCatholic double Percent Roman Catholic Locate on people group profile

IndigenousCode varchar(1) Is this group indigenous to this country
'Y' (yes)     'N' (no)

CasteClass varchar(25) Locate on people group profile

LRofTheDayYear int(11) Locate on people group profile

Photo varchar(1) Does photo exist Locate on people group profile

PhotoAddress varchar(25) Photo file name Locate on people group profile

PhotoGood varchar(1) High quality photo Locate on people group profile

PhotoCredits varchar(255) Photo source, text for credits display Locate on people group profile

PhotoCreditURL varchar(255) Photo source link, hyperlink for credits display Locate on people group profile

PhotoCreativeCommons varchar(1) Does photo have creative commons licensing
'Y' (yes)     'N' (no)

PhotoCCVersionText varchar(50) Locate on people group profile

PhotoCCVersionURL varchar(255) Locate on people group profile

PhotoCopyright varchar(1) Is photo copyrighted
'Y' (yes)     'N' (no)

PhotoRepresentative varchar(5) Locate on people group profile

Map varchar(1) Does map exist Locate on people group profile

MapAddress varchar(25) Map file name Locate on people group profile

MapSource varchar(255) Locate on people group profile

MapCredits varchar(255) Map source, text for credits display Locate on people group profile

MapCreditURL varchar(255) Map source link, hyperlink for credits display Locate on people group profile

MapCopyright varchar(1) Is map copyrighted
'Y' (yes)     'N' (no)

MapCCVersionText varchar(50) Locate on people group profile

MapCCVersionURL varchar(255) Locate on people group profile

AudioAddress varchar(255) Locate on people group profile

HandoutAddress varchar(255) Locate on people group profile

GSEC varchar(1) Global Status of Evangelical Christianity, see http://www.joshuaproject.net/definitions.php Locate on people group profile

JF varchar(1) Y = Jesus film exists in this language
'Y' (yes)     'N' (no)

AudioRecordings varchar(1) Y = gospel audio recordings exist in this language
'Y' (yes)     'N' (no)

NTOnline varchar(50) Y = Bible.is has online NT Locate on people group profile

GospelRadio varchar(1) Y = Gospel radio available in this language Locate on people group profile

PEID int(11) Locate on people group profile

Longitude double Longitude value of language polygon or highest density district centroid, for Google maps colored do Locate on people group profile

Latitude double Latitude value of language polygon or highest density district centroid, for Google maps colored dot Locate on people group profile

Unreached People of The Day Resource

GET - https://joshuaproject.net/api/v2/upgotd?api_key=yourkey

       ** Make sure to include paramater 'ROL3Profile' to request only the language you need

Sample

{"meta":{"pagination":{"total_count":3294,"total_pages":1647,"current_page":1,"limit":2}},"data":[{"ROL3Profile":"cmn","PeopleID3":10130,"ROG3":"TU","Ctry":"\u571f\u8033\u5176","LRofTheDayYear":2024,"LRofTheDayMonth":11,"LRofTheDayDay":25,"ROG2":"ASI","Continent":"\u4e9e\u6d32","RegionCode":5,"RegionName":"\u4e2d\u4e9a","10_40Window":"Y","PeopleID1":12,"AffinityBloc":"\u6b27\u4e9a\u7fa4\u4f53","PeopleID2":157,"PeopleCluster":"Caucasus","PeopNameAcrossCountries":"Abkhaz","PeopNameInCountry":"\u963f\u5e03\u54c8\u5179\u4eba","Pronunciation":"AHB-kahz","NaturalName":"Abkhaz","NaturalPronunciation":"AHB-kahz","Population":168000,"ROL3":"abk","PrimaryLanguageName":"Abkhaz","RLG3":6,"PrimaryReligion":"\u4f0a\u65af\u5170\u6559","LeastReached":"Y","JPScale":1,"PercentAdherents":0,"PercentEvangelical":0,"ChristFollowers":"\u5f88\u5c11\uff0c\u5c11\u4e8e2\uff05","WorldPopulation":190200,"CountOfCountries":6,"LRofTheDaySet":null,"ScriptureReference":"\u5f7c\u5f97\u524d\u4e66 1:3","ScripturePrayer":"\u79b1\u544a\u9019\u500b\u672a\u5f97\u4e4b\u6c11\u7fa4\u9ad4\u88e1\uff0c\u8a31\u591a\u4eba\u91cd\u751f\u4e26\u6210\u70ba\u795e\u7684\u5bb6\u5ead\u7684\u4e00\u4efd\u5b50\u3002 ","ScriptureNbr":330,"Latitude":41.178986841769301463500596582889556884765625,"Longitude":41.82068672571180201202878379262983798980712890625,"JF":"Y","AudioRecordings":"N","GospelRadio":"N","PhotoAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/photos\/p10130.jpg","PhotoCredits":"Apsuwara - Wikimedia","PhotoCopyright":"N","PhotoCreditURL":"https:\/\/commons.wikimedia.org\/wiki\/File:Apsua_Ladies_in_Flag_Clothes.jpg","PhotoCreativeCommons":"Y","PhotoCCVersionText":"CC BY-SA 3.0","PhotoCCVersionURL":"https:\/\/creativecommons.org\/licenses\/by-sa\/3.0\/","PhotoPermission":"N","PhotoRepresentative":null,"MapAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/maps\/m10130_tu.png","MapAddressExpanded":"m10130_tu.pdf","MapSource":"MR","MapCredits":"People Group location: BWPC. Map geography: ESRI \/ GMI. Map design: Joshua Project.","MapCreditURL":null,"MapCopyright":"N","MapCCVersionText":null,"MapCCVersionURL":null,"HandoutAddress":null,"AudioAddress":null,"Active":"Y","Progress":null},{"ROL3Profile":"deu","PeopleID3":10130,"ROG3":"TU","Ctry":"T\u00fcrkei","LRofTheDayYear":2024,"LRofTheDayMonth":11,"LRofTheDayDay":25,"ROG2":"ASI","Continent":"Asien","RegionCode":5,"RegionName":"Zentralasien","10_40Window":"Y","PeopleID1":12,"AffinityBloc":"Eurasische V\u00f6lker","PeopleID2":157,"PeopleCluster":"Kaukasus","PeopNameAcrossCountries":"Abchasier","PeopNameInCountry":"Abchasen","Pronunciation":"AHB-kahz","NaturalName":"Abkhaz","NaturalPronunciation":"AHB-kahz","Population":168000,"ROL3":"abk","PrimaryLanguageName":"Abchasisch","RLG3":6,"PrimaryReligion":"Islam","LeastReached":"Y","JPScale":1,"PercentAdherents":0,"PercentEvangelical":0,"ChristFollowers":"Wenige, weniger als 2%","WorldPopulation":190200,"CountOfCountries":6,"LRofTheDaySet":null,"ScriptureReference":"1 Petrus 1:3","ScripturePrayer":"Bete dass viele unter diesen Menschen wiedergeboren werden und Teil der Familie Gottes werden.","ScriptureNbr":330,"Latitude":41.178986841769301463500596582889556884765625,"Longitude":41.82068672571180201202878379262983798980712890625,"JF":"Y","AudioRecordings":"N","GospelRadio":"N","PhotoAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/photos\/p10130.jpg","PhotoCredits":"Apsuwara - Wikimedia","PhotoCopyright":"N","PhotoCreditURL":"https:\/\/commons.wikimedia.org\/wiki\/File:Apsua_Ladies_in_Flag_Clothes.jpg","PhotoCreativeCommons":"Y","PhotoCCVersionText":"CC BY-SA 3.0","PhotoCCVersionURL":"https:\/\/creativecommons.org\/licenses\/by-sa\/3.0\/","PhotoPermission":"N","PhotoRepresentative":null,"MapAddress":"https:\/\/joshuaproject.net\/assets\/media\/profiles\/maps\/m10130_tu.png","MapAddressExpanded":"m10130_tu.pdf","MapSource":"MR","MapCredits":"People Group location: BWPC. Map geography: ESRI \/ GMI. Map design: Joshua Project.","MapCreditURL":null,"MapCopyright":"N","MapCCVersionText":null,"MapCCVersionURL":null,"HandoutAddress":null,"AudioAddress":null,"Active":"Y","Progress":null}],"status":{"message":"Success!","status_code":200}}

Connected Data

Include connected_data(s) by specifying "connected_data=" in your URL: ?connected_data=jppeoples...

Fields: If you specify fields to return (see below) this will apply to connected_data also. The fields you specify will be evaluated for the original and each connected_data objects

Value Description Response Notes

jppeoples Full people group data each people Response: One object for each people group.

Fields

By default all fields returned. Set the fields you need with URL parameter: ?fields=fields (add more by separating with a pipe | )'

Query Parameters

Query by any field below. Check the 'Values' column for possible field values. To query by more than one value per field, separate values with a pipe | . For example: ?ROG3=BG|IN|BN

Custom Comparison Fields

Comparison Field Description

min_population Minimum population of the people group

max_population Max population of the people group

click to sort

Field Type Description Values (value description) Notes

ROL3Profile varchar(3)

PeopleID3 int(11) People-Group-Across-Countries ID number Locate on people group profile

ROG3 varchar(2) FIPS-2 country code

Ctry varchar(50) Country name

LRofTheDayYear int(11) Locate on people group profile

LRofTheDayMonth int(11) Unreached People of the Day month 1-12 Locate on people group profile

LRofTheDayDay int(11) Unreached People of the Day day 1-31 Locate on people group profile

ROG2 varchar(5) Registry of Geographic Places continent code

Continent varchar(50) Continent

RegionCode int(11) Region code for this country

RegionName varchar(75) Region name Locate on people group profile

10_40Window varchar(1) Y = in 10/40 Window
'Y' (yes)     'N' (no)

PeopleID1 int(11) Affinity Bloc code

AffinityBloc varchar(50) Affinity Bloc for this people group

PeopleID2 int(11) People cluster code

PeopleCluster varchar(50) People cluster

PeopNameAcrossCountries varchar(75) Name of people group across countries of residence Locate on people group profile

PeopNameInCountry varchar(75) Name of people group in this country Locate on people group profile

Pronunciation varchar(100) People name pronunciation Locate on people group profile

NaturalName varchar(255) Locate on people group profile

NaturalPronunciation varchar(100) Locate on people group profile

Population int(11) Population in this country Locate on people group profile

ROL3 varchar(3) Ethnologue language code, 17th Edition Locate on people group profile

PrimaryLanguageName varchar(50) Primary language in this country Locate on people group profile

RLG3 int(11) Primary religion code Locate on people group profile

PrimaryReligion varchar(50) Primary religion in this country

LeastReached varchar(1) Y = Least Reached / unreached. JPScale < 2.0
'Y' (yes)     'N' (no)

JPScale varchar(1) See http://www.joshuaproject.net/definitions.php
More Information

PercentAdherents double % Christian Adherents for this people group Locate on people group profile

PercentEvangelical double % Evangelical for this people group Locate on people group profile

ChristFollowers varchar(50) Locate on people group profile

WorldPopulation double Locate on people group profile

CountOfCountries int(11) Number of countries of residence Locate on people group profile

LRofTheDaySet int(11) Unreached People of the Day set 1 or 2 Locate on people group profile

ScriptureReference varchar(50) Locate on people group profile

ScripturePrayer longtext Locate on people group profile

ScriptureNbr int(11) Locate on people group profile

Latitude double Latitude value of language polygon or highest density district centroid, for Google maps colored dot Locate on people group profile

Longitude double Longitude value of language polygon or highest density district centroid, for Google maps colored do Locate on people group profile

JF varchar(1) Y = Jesus film exists in this language
'Y' (yes)     'N' (no)

AudioRecordings varchar(1) Y = gospel audio recordings exist in this language
'Y' (yes)     'N' (no)

GospelRadio varchar(1) Y = Gospel radio available in this language Locate on people group profile

PhotoAddress varchar(25) Photo file name Locate on people group profile

PhotoCredits varchar(100) Photo source, text for credits display Locate on people group profile

PhotoCopyright varchar(1) Is photo copyrighted
'Y' (yes)     'N' (no)

PhotoCreditURL varchar(150) Photo source link, hyperlink for credits display Locate on people group profile

PhotoCreativeCommons varchar(1) Does photo have creative commons licensing
'Y' (yes)     'N' (no)

PhotoCCVersionText varchar(255) Locate on people group profile

PhotoCCVersionURL varchar(255) Locate on people group profile

PhotoPermission varchar(1) Does Joshua Project have permission to use this photo
'Y' (yes)     'N' (no)

PhotoRepresentative varchar(5) Locate on people group profile

MapAddress varchar(25) Map file name Locate on people group profile

MapAddressExpanded varchar(25) Map file name for large version Locate on people group profile

MapSource varchar(100) Locate on people group profile

MapCredits varchar(150) Map source, text for credits display Locate on people group profile

MapCreditURL varchar(150) Map source link, hyperlink for credits display Locate on people group profile

MapCopyright varchar(1) Is map copyrighted
'Y' (yes)     'N' (no)

MapCCVersionText varchar(255) Locate on people group profile

MapCCVersionURL varchar(255) Locate on people group profile

HandoutAddress varchar(25) Locate on people group profile

AudioAddress varchar(25) Locate on people group profile

Active varchar(1) Locate on people group profile

Progress varchar(255) Locate on people group profile

Countries

GET - https://joshuaproject.net/api/v2/countries?api_key=yourkey

Sample

{"meta":{"pagination":{"total_count":238,"total_pages":119,"current_page":1,"limit":2}},"data":[{"ROG3":"AF","ISO3":"AFG","ISO2":"AF","OWCountryCode":"AFGH","ROG2":"ASI","Continent":"Asia","RegionCode":5,"RegionName":"Asia, Central","Ctry":"Afghanistan","CtryShort":"Afghanistan","Ctry_es":"Afganist\u00e1n","Ctry_de":"Afghanistan","Ctry_pt":"Afeganist\u00e3o","Ctry_fr":"Afghanistan","Ctry_id":"Afghanistan","Ctry_cn":"\u963f\u5bcc\u6c57","Ctry_ko":"\uc544\ud504\uac00\ub2c8\uc2a4\ud0c4","Population":43373000,"PopulationSource":"UN Country Population (2024)","PoplGrowthRate":2.394366197183099842504816479049623012542724609375,"10_40Window":"Y","ROL3OfficialLanguage":"pbt","OfficialLang":"Pashto, Southern","RLG3Primary":6,"ReligionPrimary":"Islam","RLG4Primary":null,"ReligionSubdivision":null,"EthnolinguisticMap":"http:\/\/www.lib.utexas.edu\/maps\/middle_east_and_asia\/afghanistan_ethnoling_97.jpg","PercentChristianity":0.0185163386035193007483901084242461365647614002227783203125,"PercentEvangelical":0.0156384830446119997560128211944174836389720439910888671875,"PercentBuddhism":0,"PercentEthnicReligions":0.0150464104995574991796569719326726044528186321258544921875,"PercentHinduism":0.01282238445101929920355576797419416834600269794464111328125,"PercentIslam":99.8314908756625953856200794689357280731201171875,"PercentNonReligious":0.0029574199665056599868606657111058666487224400043487548828125,"PercentOtherSmall":0.1191665708167529980077148366035544313490390777587890625,"PercentUnknown":0,"PercentAnglican":null,"PercentIndependent":null,"PercentProtestant":null,"PercentOrthodox":null,"PercentOther":null,"PercentRomanCatholic":null,"CntPeoples":70,"PoplPeoples":43206000,"CntPeoplesLR":68,"PoplPeoplesLR":43204000,"CntPeoplesFPG":61,"PoplPeoplesFPG":41886000,"JPScaleCtry":1,"JPScaleColor":"CC0000","EthnologueCountryCode":"AF","EthnologueMapExists":"N","UNMap":"https:\/\/un.org\/geospatial\/content\/afghanistan","PersecutionRankingODLink":"https:\/\/www.opendoors.org\/en-US\/persecution\/countries\/afghanistan","GodReportsURL":"http:\/\/blog.godreports.com\/country\/?countrycode=af&joshua=af","DataReportalURL":"https:\/\/datareportal.com\/reports\/digital-2024-afghanistan","VoiceOfMartyrsURL":"https:\/\/www.persecution.com\/globalprayerguide\/afghanistan\/","WorldFactbookURL":"https:\/\/www.cia.gov\/the-world-factbook\/countries\/afghanistan","BibleSocietyURL":null,"Pray1040URL":"https:\/\/pray1040.com\/pray-for-afghanistan\/","OWCountryPage":"afghanistan","WorkersNeeded":904,"Adm1Label":"Provinces","WaldnerGuide":"prayer-guide-af.pdf","CntPrimaryLanguages":53,"TranslationUnspecified":19,"TranslationNeeded":3,"TranslationStarted":1,"BiblePortions":10,"BibleNewTestament":3,"BibleComplete":17},{"ROG3":"AL","ISO3":"ALB","ISO2":"AL","OWCountryCode":"ALBA","ROG2":"EUR","Continent":"Europe","RegionCode":9,"RegionName":"Europe, Eastern and Eurasia","Ctry":"Albania","CtryShort":"Albania","Ctry_es":"Albania","Ctry_de":"Albanien","Ctry_pt":"Alb\u00e2nia","Ctry_fr":"Albanie","Ctry_id":"Albania","Ctry_cn":"\u963f\u5c14\u5df4\u5c3c\u4e9a","Ctry_ko":"\uc54c\ubc14\ub2c8\uc544","Population":2826000,"PopulationSource":"UN Country Population (2024)","PoplGrowthRate":0.2410468319559229966042579462737194262444972991943359375,"10_40Window":"Y","ROL3OfficialLanguage":"aln","OfficialLang":"Albanian, Gheg","RLG3Primary":6,"ReligionPrimary":"Islam","RLG4Primary":null,"ReligionSubdivision":null,"EthnolinguisticMap":null,"PercentChristianity":33.67735204150110206455792649649083614349365234375,"PercentEvangelical":0.61188996845870702312453204285702668130397796630859375,"PercentBuddhism":0,"PercentEthnicReligions":5.0548557787802699523861671426772090853773988783359527587890625e-5,"PercentHinduism":0,"PercentIslam":54.476169848021498864909517578780651092529296875,"PercentNonReligious":11.8457198821106004515968379564583301544189453125,"PercentOtherSmall":0.00070767980902923803727955220921330692362971603870391845703125,"PercentUnknown":0,"PercentAnglican":null,"PercentIndependent":null,"PercentProtestant":null,"PercentOrthodox":null,"PercentOther":null,"PercentRomanCatholic":null,"CntPeoples":15,"PoplPeoples":2794000,"CntPeoplesLR":3,"PoplPeoplesLR":39000,"CntPeoplesFPG":1,"PoplPeoplesFPG":1700,"JPScaleCtry":2,"JPScaleColor":"FF8C00","EthnologueCountryCode":"AL","EthnologueMapExists":"N","UNMap":"https:\/\/un.org\/geospatial\/content\/albania-1","PersecutionRankingODLink":null,"GodReportsURL":"http:\/\/blog.godreports.com\/country\/?countrycode=al&joshua=al","DataReportalURL":"https:\/\/datareportal.com\/reports\/digital-2024-albania","VoiceOfMartyrsURL":null,"WorldFactbookURL":"https:\/\/www.cia.gov\/the-world-factbook\/countries\/albania","BibleSocietyURL":"http:\/\/albanianbiblesociety.com\/","Pray1040URL":null,"OWCountryPage":"albania","WorkersNeeded":3,"Adm1Label":"Provinces","WaldnerGuide":"prayer-guide-al+mj.pdf","CntPrimaryLanguages":11,"TranslationUnspecified":0,"TranslationNeeded":1,"TranslationStarted":0,"BiblePortions":1,"BibleNewTestament":1,"BibleComplete":8}],"status":{"message":"Success!","status_code":200}}

Connected Data

Include connected_data(s) by specifying "connected_data=" in your URL: ?connected_data=jplanguages...

Fields: If you specify fields to return (see below) this will apply to connected_data also. The fields you specify will be evaluated for the original and each connected_data objects

Value Description Response Notes

jplanguages Full language data for country's primary language Response: One object for each country.

Fields

By default all fields returned. Set the fields you need with URL parameter: ?fields=fields (add more by separating with a pipe | )'

Query Parameters

Query by any field below. Check the 'Values' column for possible field values. To query by more than one value per field, separate values with a pipe | . For example: ?ROG3=BG|IN|BN

Custom Comparison Fields

Comparison Field Description

min_population Minimum population of the country

max_population Max population of the country

click to sort

Field Type Description Values (value description) Notes

ROG3 varchar(2) 2 digit FIPS code for country: FIPS PUB 10-4

ISO3 varchar(3) ISO 3 character code for country Locate on country profile

ISO2 varchar(2) ISO 2 character code for country Locate on country profile

OWCountryCode varchar(4) Operation World country code Locate on country profile

ROG2 varchar(3) Continent code

Continent varchar(50) Continent

RegionCode int(11) Ethne Regions

RegionName varchar(40) Region name Locate on country profile

Ctry varchar(50) Country name

CtryShort varchar(255) Short country name Locate on country profile

Ctry_es varchar(50) Country name Spanish Locate on country profile

Ctry_de varchar(50) Country name German Locate on country profile

Ctry_pt varchar(50) Country name Portuguese Locate on country profile

Ctry_fr varchar(50) Country name French Locate on country profile

Ctry_id varchar(50) Country name Indonesia Locate on country profile

Ctry_cn varchar(50) Country name Chinese Locate on country profile

Ctry_ko varchar(50) Country name Korean Locate on country profile

Population int(11) Populations mostly per latest UN Locate on country profile

PopulationSource varchar(35) Population Source Locate on country profile

PoplGrowthRate double Population Annual Growth Rate Locate on country profile

10_40Window varchar(1) Part of 10/40 Window according to Window International Network (WIN)
'Y' (yes)     'N' (no)

ROL3OfficialLanguage varchar(3) Code for official language for this country Locate on country profile

OfficialLang varchar(50) Official language name for this country Locate on country profile

RLG3Primary int(11) Code for primary Religion for this country Locate on country profile

ReligionPrimary varchar(50) Primary Religion for this country Locate on country profile

RLG4Primary int(11) Code for primary Religion sub-division for this country Locate on country profile

ReligionSubdivision varchar(50) Primary Religion sub-division for this country Locate on country profile

EthnolinguisticMap varchar(100) Link to Ethnolinguistic map exist at Univ of Texas map collection website Locate on country profile

PercentChristianity double Percent Christian Adherent from summing people group values Locate on country profile

PercentEvangelical double Percent Evangelical from summing people group values Locate on country profile

PercentBuddhism double Percent Buddhism from summing people group values Locate on country profile

PercentEthnicReligions double Percent Ethnic Religions from summing people group values Locate on country profile

PercentHinduism double Percent Hindu from summing people group values Locate on country profile

PercentIslam double Percent Islam from summing people group values Locate on country profile

PercentNonReligious double Percent Non-religious from summing people group values Locate on country profile

PercentOtherSmall double Percent Other / Small from summing people group values Locate on country profile

PercentUnknown double Percent Unknown from summing people group values Locate on country profile

PercentAnglican double Percent Anglican from summing people group values Locate on country profile

PercentIndependent double Percent Independent from summing people group values Locate on country profile

PercentProtestant double Percent Protestant from summing people group values Locate on country profile

PercentOrthodox double Percent Orthodox from summing people group values Locate on country profile

PercentOther double Percent Other from summing people group values Locate on country profile

PercentRomanCatholic double Percent Roman Catholic from summing people group values Locate on country profile

CntPeoples int(11) Count of people groups Locate on country profile

PoplPeoples double Population of people groups, should be very close to field Population Locate on country profile

CntPeoplesLR int(11) Count of people groups considered unreached Locate on country profile

PoplPeoplesLR double Population of people groups considered unreached Locate on country profile

CntPeoplesFPG int(11) Locate on country profile

PoplPeoplesFPG int(11) Locate on country profile

JPScaleCtry varchar(255) Joshua Project Progress Scale for overall country Locate on country profile

JPScaleColor varchar(10) Locate on country profile

EthnologueCountryCode varchar(2) Ethnologue code for country Locate on country profile

EthnologueMapExists varchar(1) Ethnologue language map exists for this country
'Y' (yes)     'N' (no)

UNMap varchar(200) Link to UN Political map in PDF format Locate on country profile

PersecutionRankingODLink varchar(255) Locate on country profile

GodReportsURL varchar(255) Locate on country profile

DataReportalURL varchar(255) Locate on country profile

VoiceOfMartyrsURL varchar(255) Locate on country profile

WorldFactbookURL varchar(255) Locate on country profile

BibleSocietyURL varchar(255) Locate on country profile

Pray1040URL varchar(255) Locate on country profile

OWCountryPage varchar(255) Locate on country profile

WorkersNeeded int(11) Estimated workers needed based on 1:50,000 Locate on country profile

Adm1Label varchar(255) Locate on country profile

WaldnerGuide varchar(255) Locate on country profile

CntPrimaryLanguages int(11) Locate on country profile

TranslationUnspecified int(11) Locate on country profile

TranslationNeeded int(11) Locate on country profile

TranslationStarted int(11) Locate on country profile

BiblePortions int(11) Locate on country profile

BibleNewTestament int(11) Locate on country profile

BibleComplete int(11) Locate on country profile

Languages

GET - https://joshuaproject.net/api/v2/languages?api_key=yourkey

Sample

{"meta":{"pagination":{"total_count":7129,"total_pages":3565,"current_page":1,"limit":2}},"data":[{"ROL3":"aou","Language":"A'ou","BibleStatus":0,"BibleYear":null,"NTYear":null,"PortionsYear":null,"JF":"N","JF_URL":null,"JF_ID":null,"Online":"N","GRN_URL":null,"AudioRecordings":"N","FourLaws":"N","FourLaws_URL":null,"YouVersion_ID":null,"YouVersion_URL":null,"JPScale":null,"PercentAdherents":null,"PercentEvangelical":null,"LeastReached":"N","JPPopulation":null,"RLG3":null,"PrimaryReligion":"","NbrPGICs":null,"NbrCountries":null},{"ROL3":"aiw","Language":"Aari","BibleStatus":5,"BibleYear":"2015-2017","NTYear":1997,"PortionsYear":"Yes","JF":"Y","JF_URL":"https:\/\/www.jesusfilm.org\/watch\/jesus.html\/aari.html","JF_ID":"aari","Online":"Y","GRN_URL":"https:\/\/globalrecordings.net\/en\/language\/aiw","AudioRecordings":"Y","FourLaws":"N","FourLaws_URL":null,"YouVersion_ID":null,"YouVersion_URL":null,"JPScale":5,"PercentAdherents":48,"PercentEvangelical":46.530000000000001136868377216160297393798828125,"LeastReached":"N","JPPopulation":535000,"RLG3":4,"PrimaryReligion":"Ethnic Religions","NbrPGICs":1,"NbrCountries":1}],"status":{"message":"Success!","status_code":200}}

Fields

By default all fields returned. Set the fields you need with URL parameter: ?fields=fields (add more by separating with a pipe | )'

Query Parameters

Query by any field below. Check the 'Values' column for possible field values. To query by more than one value per field, separate values with a pipe | . For example: ?ROG3=BG|IN|BN

Custom Comparison Fields

Comparison Field Description

min_population Minimum spearkers of language

max_population Max speakers of language

click to sort

Field Type Description Values (value description) Notes

ROL3 varchar(3) Language Code (ISO and Ethnologue) Locate on language profile

Language varchar(50) Language Name Locate on language profile

BibleStatus int(11) Bible translation status: 0=Questionable translation need; 1=None, definite need; 2=Portions: 3=NT; Locate on language profile

BibleYear varchar(50) Year of complete Bible translation (BibleStatus=4) Locate on language profile

NTYear varchar(50) Year of NT translation (BibleStatus=3) Locate on language profile

PortionsYear varchar(50) Year of portions translation (BibleStatus=2) Locate on language profile

JF varchar(1) Jesus Film available
'Y' (yes)     'N' (no)

JF_URL varchar(255) Jesus Film link Locate on language profile

JF_ID varchar(50) Jesus Film ID number Locate on language profile

Online varchar(3) Jesus Film available online Locate on language profile

GRN_URL varchar(255) Global Recordings Network link Locate on language profile

AudioRecordings varchar(1) Global Recordings Network available
'Y' (yes)     'N' (no)

FourLaws varchar(1) Locate on language profile

FourLaws_URL varchar(255) Locate on language profile

YouVersion_ID varchar(50) YouVersion Bible ID Locate on language profile

YouVersion_URL varchar(255) YouVersion Bible link Locate on language profile

JPScale varchar(1) Joshua Project Scale
More Information

PercentAdherents double Percent Christian Adherents estimate based on people group data Locate on language profile

PercentEvangelical double Percent Evangelicals estimate based on people group data Locate on language profile

LeastReached varchar(1) Considered Least-reached / unreached based on people group data
'Y' (yes)     'N' (no)

JPPopulation int(11) Population of groups speaking this as primary language Locate on language profile

RLG3 int(11) Largest religion code based on people groups primary religion Locate on language profile

PrimaryReligion varchar(50) Largest religion name based on people groups primary religion

NbrPGICs int(11) Number of people groups speaking this as primary language Locate on language profile

NbrCountries int(11) Number of countries this language is spoken in based on people group data Locate on language profile

Comparison Field	Description
min_population	Minimum population of the people group
max_population	Max population of the people group

Field	Type	Description	Values (value description)
click to sort
PeopleID3ROG3	varchar(10)	Unique Key - PeopleID3 and ROG3	Locate on people group profile
ROG3	varchar(2)	FIPS-2 country code
Ctry	varchar(50)	Country name
CtryShort	varchar(50)	Short country name	Locate on people group profile
CtryLiteracyRate	int(11)	Country literacy rate value	Locate on people group profile
CtryLiteracySource	varchar(50)	Country literacy rate source	Locate on people group profile
PeopleID3	int(11)	People-Group-Across-Countries ID number	Locate on people group profile
PeopNameInCountry	varchar(75)	Name of people group in this country	Locate on people group profile
PeopNameAcrossCountries	varchar(75)	Name of people group across countries of residence	Locate on people group profile
NaturalName	varchar(255)		Locate on people group profile
NaturalPronunciation	varchar(255)		Locate on people group profile
PeopCtryConcatenation	varchar(15)		Locate on people group profile
Population	int(11)	Population in this country	Locate on people group profile
PopulationRange	int(11)		Locate on people group profile
ROG2	varchar(3)	Registry of Geographic Places continent code
Continent	varchar(50)	Continent
RegionCode	int(11)	Region code for this country
RegionName	varchar(50)	Region name	Locate on people group profile
10_40Window	varchar(1)	Y = in 10/40 Window	'Y' (yes) 'N' (no)
RLG3PrimaryCtry	int(11)		Locate on people group profile
ReligionPrimaryCtry	varchar(255)		Locate on people group profile
LocationInCountry	longtext	Location of people within the country	Locate on people group profile
PeopleID1	int(11)	Affinity Bloc code
AffinityBloc	varchar(50)	Affinity Bloc for this people group
PeopleID2	int(11)	People cluster code
PeopleCluster	varchar(50)	People cluster
JPScalePC	varchar(1)	JPScale, people cluster	More Information
PopulationPGAC	int(11)	Population forthis PeopleGroup-Across-Countries	Locate on people group profile
JPScalePGAC	varchar(1)	JPScale, People-Group-Across-Countries	More Information
JPScale	int(11)	See http://www.joshuaproject.net/definitions.php	More Information
JPScaleTemp	int(11)		Locate on people group profile
LeastReached	varchar(1)	Y = Least Reached / unreached. JPScale < 2.0	'Y' (yes) 'N' (no)
Frontier	varchar(1)	Frontier People Group	Locate on people group profile
WorkersNeeded	int(11)	Estimated workers needed based on 1:50,000	Locate on people group profile
Subgroups	int(11)		Locate on people group profile
ROP25	int(11)		Locate on people group profile
ROP25Name	varchar(255)		Locate on people group profile
ROP3	int(11)	Registry of Peoples - People Group ID	Locate on people group profile
ROL3	varchar(3)	Ethnologue language code, 17th Edition	Locate on people group profile
PrimaryLanguageName	varchar(50)	Primary language in this country	Locate on people group profile
ROL4	int(11)	Dialect code	Locate on people group profile
PrimaryLanguageDialect	varchar(75)	Primary language dialect in this country	Locate on people group profile
Written	varchar(1)	Y = language is written	Locate on people group profile
BibleStatus	int(11)	Bible status	Locate on people group profile
NumberLanguagesSpoken	int(11)	Number of languages spoken by this people group in this country	Locate on people group profile
RLG3	int(11)	Primary religion code	Locate on people group profile
PrimaryReligion	varchar(50)	Primary religion in this country
RLG4	int(11)	Religion subdivision code	Locate on people group profile
ReligionSubdivision	varchar(50)	Subdivision of the primary religion	Locate on people group profile
PercentAdherents	decimal(6,3)	% Christian Adherents for this people group	Locate on people group profile
CountAdherents	int(11)		Locate on people group profile
PercentEvangelical	decimal(6,3)	% Evangelical for this people group	Locate on people group profile
CountEvangelical	int(11)		Locate on people group profile
PCBuddhism	double	Percent Buddhist	Locate on people group profile
PCDblyProfessing	double	Percent Doubly Professing	Locate on people group profile
PCEthnicReligions	double	Percent Ethnic Religions	Locate on people group profile
PCHinduism	double	Percent Hindu	Locate on people group profile
PCIslam	double	Percent Muslim	Locate on people group profile
PCNonReligious	double	Percent Non-religious	Locate on people group profile
PCOtherSmall	double	Percent Other / Small	Locate on people group profile
PCUnknown	double	Percent Unknown	Locate on people group profile
PCAnglican	double	Percent Anglican	Locate on people group profile
PCIndependent	double	Percent Independent	Locate on people group profile
PCProtestant	double	Percent Protestant	Locate on people group profile
PCOrthodox	double	Percent Orthodox	Locate on people group profile
PCOtherChristian	double	Percent Other Christian	Locate on people group profile
PCRomanCatholic	double	Percent Roman Catholic	Locate on people group profile
IndigenousCode	varchar(1)	Is this group indigenous to this country	'Y' (yes) 'N' (no)
CasteClass	varchar(25)		Locate on people group profile
LRofTheDayYear	int(11)		Locate on people group profile
Photo	varchar(1)	Does photo exist	Locate on people group profile
PhotoAddress	varchar(25)	Photo file name	Locate on people group profile
PhotoGood	varchar(1)	High quality photo	Locate on people group profile
PhotoCredits	varchar(255)	Photo source, text for credits display	Locate on people group profile
PhotoCreditURL	varchar(255)	Photo source link, hyperlink for credits display	Locate on people group profile
PhotoCreativeCommons	varchar(1)	Does photo have creative commons licensing	'Y' (yes) 'N' (no)
PhotoCCVersionText	varchar(50)		Locate on people group profile
PhotoCCVersionURL	varchar(255)		Locate on people group profile
PhotoCopyright	varchar(1)	Is photo copyrighted	'Y' (yes) 'N' (no)
PhotoRepresentative	varchar(5)		Locate on people group profile
Map	varchar(1)	Does map exist	Locate on people group profile
MapAddress	varchar(25)	Map file name	Locate on people group profile
MapSource	varchar(255)		Locate on people group profile
MapCredits	varchar(255)	Map source, text for credits display	Locate on people group profile
MapCreditURL	varchar(255)	Map source link, hyperlink for credits display	Locate on people group profile
MapCopyright	varchar(1)	Is map copyrighted	'Y' (yes) 'N' (no)
MapCCVersionText	varchar(50)		Locate on people group profile
MapCCVersionURL	varchar(255)		Locate on people group profile
AudioAddress	varchar(255)		Locate on people group profile
HandoutAddress	varchar(255)		Locate on people group profile
GSEC	varchar(1)	Global Status of Evangelical Christianity, see http://www.joshuaproject.net/definitions.php	Locate on people group profile
JF	varchar(1)	Y = Jesus film exists in this language	'Y' (yes) 'N' (no)
AudioRecordings	varchar(1)	Y = gospel audio recordings exist in this language	'Y' (yes) 'N' (no)
NTOnline	varchar(50)	Y = Bible.is has online NT	Locate on people group profile
GospelRadio	varchar(1)	Y = Gospel radio available in this language	Locate on people group profile
PEID	int(11)		Locate on people group profile
Longitude	double	Longitude value of language polygon or highest density district centroid, for Google maps colored do	Locate on people group profile
Latitude	double	Latitude value of language polygon or highest density district centroid, for Google maps colored dot	Locate on people group profile

Field	Type	Description	Values (value description)
click to sort
ROL3Profile	varchar(3)
PeopleID3	int(11)	People-Group-Across-Countries ID number	Locate on people group profile
ROG3	varchar(2)	FIPS-2 country code
Ctry	varchar(50)	Country name
LRofTheDayYear	int(11)		Locate on people group profile
LRofTheDayMonth	int(11)	Unreached People of the Day month 1-12	Locate on people group profile
LRofTheDayDay	int(11)	Unreached People of the Day day 1-31	Locate on people group profile
ROG2	varchar(5)	Registry of Geographic Places continent code
Continent	varchar(50)	Continent
RegionCode	int(11)	Region code for this country
RegionName	varchar(75)	Region name	Locate on people group profile
10_40Window	varchar(1)	Y = in 10/40 Window	'Y' (yes) 'N' (no)
PeopleID1	int(11)	Affinity Bloc code
AffinityBloc	varchar(50)	Affinity Bloc for this people group
PeopleID2	int(11)	People cluster code
PeopleCluster	varchar(50)	People cluster
PeopNameAcrossCountries	varchar(75)	Name of people group across countries of residence	Locate on people group profile
PeopNameInCountry	varchar(75)	Name of people group in this country	Locate on people group profile
Pronunciation	varchar(100)	People name pronunciation	Locate on people group profile
NaturalName	varchar(255)		Locate on people group profile
NaturalPronunciation	varchar(100)		Locate on people group profile
Population	int(11)	Population in this country	Locate on people group profile
ROL3	varchar(3)	Ethnologue language code, 17th Edition	Locate on people group profile
PrimaryLanguageName	varchar(50)	Primary language in this country	Locate on people group profile
RLG3	int(11)	Primary religion code	Locate on people group profile
PrimaryReligion	varchar(50)	Primary religion in this country
LeastReached	varchar(1)	Y = Least Reached / unreached. JPScale < 2.0	'Y' (yes) 'N' (no)
JPScale	varchar(1)	See http://www.joshuaproject.net/definitions.php	More Information
PercentAdherents	double	% Christian Adherents for this people group	Locate on people group profile
PercentEvangelical	double	% Evangelical for this people group	Locate on people group profile
ChristFollowers	varchar(50)		Locate on people group profile
WorldPopulation	double		Locate on people group profile
CountOfCountries	int(11)	Number of countries of residence	Locate on people group profile
LRofTheDaySet	int(11)	Unreached People of the Day set 1 or 2	Locate on people group profile
ScriptureReference	varchar(50)		Locate on people group profile
ScripturePrayer	longtext		Locate on people group profile
ScriptureNbr	int(11)		Locate on people group profile
Latitude	double	Latitude value of language polygon or highest density district centroid, for Google maps colored dot	Locate on people group profile
Longitude	double	Longitude value of language polygon or highest density district centroid, for Google maps colored do	Locate on people group profile
JF	varchar(1)	Y = Jesus film exists in this language	'Y' (yes) 'N' (no)
AudioRecordings	varchar(1)	Y = gospel audio recordings exist in this language	'Y' (yes) 'N' (no)
GospelRadio	varchar(1)	Y = Gospel radio available in this language	Locate on people group profile
PhotoAddress	varchar(25)	Photo file name	Locate on people group profile
PhotoCredits	varchar(100)	Photo source, text for credits display	Locate on people group profile
PhotoCopyright	varchar(1)	Is photo copyrighted	'Y' (yes) 'N' (no)
PhotoCreditURL	varchar(150)	Photo source link, hyperlink for credits display	Locate on people group profile
PhotoCreativeCommons	varchar(1)	Does photo have creative commons licensing	'Y' (yes) 'N' (no)
PhotoCCVersionText	varchar(255)		Locate on people group profile
PhotoCCVersionURL	varchar(255)		Locate on people group profile
PhotoPermission	varchar(1)	Does Joshua Project have permission to use this photo	'Y' (yes) 'N' (no)
PhotoRepresentative	varchar(5)		Locate on people group profile
MapAddress	varchar(25)	Map file name	Locate on people group profile
MapAddressExpanded	varchar(25)	Map file name for large version	Locate on people group profile
MapSource	varchar(100)		Locate on people group profile
MapCredits	varchar(150)	Map source, text for credits display	Locate on people group profile
MapCreditURL	varchar(150)	Map source link, hyperlink for credits display	Locate on people group profile
MapCopyright	varchar(1)	Is map copyrighted	'Y' (yes) 'N' (no)
MapCCVersionText	varchar(255)		Locate on people group profile
MapCCVersionURL	varchar(255)		Locate on people group profile
HandoutAddress	varchar(25)		Locate on people group profile
AudioAddress	varchar(25)		Locate on people group profile
Active	varchar(1)		Locate on people group profile
Progress	varchar(255)		Locate on people group profile

Comparison Field	Description
min_population	Minimum population of the country
max_population	Max population of the country

Comparison Field	Description
min_population	Minimum spearkers of language
max_population	Max speakers of language