User:Tjoneslo/sandbox2

View JSON

[{"Name":"Regina","Hex":"1910","UWP":"A788899-C","PBG":"703","Zone":"","Bases":"NS","Allegiance":"ImDd","Stellar":"F7 V BD M3 V","SS":"C","Ix":"{ 4 }","Ex":"(D7E+5)","Cx":"[9C6D]","Nobility":"BcCeF","Worlds":8,"ResourceUnits":6370,"Subsector":2,"Quadrant":1,"Remarks":"Ri Pa Ph An Cp (Amindii)2 Varg0 Asla0 Sa","LegacyBaseCode":"A","Sector":"Spinward Marches","SubsectorName":"Regina","AllegianceName":"Third Imperium, Domain of Deneb"}]}

http://wiki.travellerrpg.com/index.php?title=Special:CargoExport&tables=StellarData%2CAllegianceCode%2CSubsectorData&join+on=AllegianceCode.code%3DStellarData.allegiance%2C+StellarData.subsector%3DSubsectorData.name&fields=StellarData.name%3DName%2Chex%3DHex%2Cuwp%3DUWP%2CCONCAT%28popmul%2C+belts%2C+giants%29%3DPBG%2Czone%3DZone%2Cbases%3DBases%2CStellarData.allegiance%3DAllegiance%2C%0A++REPLACE%28stars__full%2C+%27%2C%27%2C+%27+%27%29%3DStellar%2CSubsectorData.position%3DSS%2C%0A++ix%2C+ex%2C+cx%2C+nobility%3DNobility%2CStellarData.worlds%3DWorlds%2Cru%3DResourceUnits%2C%0A++REPLACE%28CONCAT%28codes__full%2CCOALESCE%28CONCAT%28%27%2C%27%2Cdetails__full%29%2C%27%27%29%2CCOALESCE%28CONCAT%28%27%2C%27%2Csophonts__full%29%2C%27%27%29%29%2C%27%2C%27%2C%27+%27%29%3DRemarks%2C+%0A++StellarData.sector%3DSector%2CStellarData.subsector%3DSubsectorName%2CAllegianceCode.description%3DAllegianceName&where=%60mw_cargo__StellarData%60.%60sector%60%3D%27Spinward+Marches%27+and+%60mw_cargo__StellarData%60.%60era%60%3D%27New+Era%27&order+by=%60mw_cargo__StellarData%60.%60hex%60&limit=100&format=json

http://wiki.travellerrpg.com/index.php?title=Special:CargoExport&tables=StellarData%2CAllegianceCode%2CSubsectorData&join+on=StellarData.allegiance%3DAllegianceCode.code%2CStellarData.subsector%3DSubsectorData.name&fields=name%3DName%2Chex%3DHex%2Cuwp%3DUWP%2CCONCAT%28popmul%2C+belts%2C+giants%29%3DPBG%2Czone%3DZone%2Cbases%3DBases%2Callegiance%3DAllegiance&where=sector%3D%27Spinward+Marches%27+and+era%3D%27New+Era%27&order+by=%60name%60&limit=1000&format=json