Static Data Export

This page should be updated due to game changes.
Reason: 2025-09-22: CCP has reworked the SDE (Reworking the SDE: a fresh start for static data). This rework is not backwards compatible.

CCP provides developers a series of static files, known as the Static Data Export(SDE), which contains static data from the Tranquility server. The SDE is currently exported as .yaml and .jsonl files, however, different and easier to use formats(mentioned below) are made by the community. The SDE can be found at the EVE developers Static Data page. All resources provided by CCP are subject to the developer license agreement.

Fuzzwork SDE Conversions

To aide fellow developers and players in consuming this data without having to extract or convert from YAML or JSON Lines format every time Steve Ronuken has hosted conversions in PostgreSQL, SQLite, MySQL, MSSQL, and CSV formats. They can be found at Fuzzwork under SDE or more directly at www.fuzzwork.co.uk/dump. Individual table data can be found in CSV and SQL (MySQL) formats here www.fuzzwork.co.uk/dump/latest.

Opening a file from Fuzzwork SDE Conversions

To extract data from compressed files, use tar for .tar.bz2 files or bunzip2 for .bz2 files in Linux, and something like 7-zip for either format in Windows. Once extracted the files can be opened in the appropriate application that supports the file format.

How does the ESI fit into all this?

The EVE Swagger Interface intends to have endpoints to account for all of the SDE; currently, it's not quite there yet, and the SDE is needed for many projects. The progress can be tracked on the SDE parity checklist at the ESI GitHub.

How to implement the original SDE into your application

Step 0: Preface

This is not a guide to Python or programming, if you don't know how to program, there are tons of resources to learn to code, there are a few of my favorites in the External links section.

Step 1: Opening the file

Firstly, find the file containing the data you need, for this example, I'm going to use fsd/blueprints.yaml. This file contains all the information required to build an industry cost predictor. Next, open the file using your desired programming language, I'm going to use python, so to open this I'll run with open("fsd/blueprints.yaml", "r") as f:. The file is open! To the next step!

Step 2: Reading the file

Step 2.1: Installing PyYAML

Assuming you're using pip, this should be as simple as pip install pyyaml. If you having issues have a look at Reading and Writing YAML to a File in Python on stackabuse.

Step 2.2: Interpreting the file

Now that PyYAML is installed, we need to use it to parse our file, we have already opened it, so it should just be a matter of parsing it with PyYAML, which can be done by blueprints = yaml.load(f, Loader=yaml.FullLoader), remember to have import yaml at the top of your .py file. Hopefully now if you print out the blueprints variable, your console will be filled with sweet, sweet data and the taste of success. The data will be a dictionary, and the rest from here should be relatively simple, it should just be navigating through the data as if it was a dictionary.

Step 3: Postface

I hope this short guide helped you somewhat get into the SDE.

Content of each table (version 2025-07-07)

Table name	Content
agtAgents.csv.bz2	Contains information regarding agents in NPC stations such as location, corporation, type, level, and locator (boolean) agentID - defined ID for this table divisionID - corporationID - the ID of the agent's NPC corporation. Corresponds to itemID in invNames locationID - the ID of the agent's NPC station. Corresponds to itemID in invNames level - agent's level (1-5) quality - not used agentTypeID - the ID of agent's type. Corresponds to agentTypeID in agtAgentTypes isLocator - 1 if the agent is a Locator agent, 0 otherwise
agtAgentsInSpace.csv.bz2	Contains information regarding agents in space agentID - defined ID for this table dungeonID - solarSystemID - the ID of the agent's solar system. Corresponds to solarSystemID in mapSolarSystems spawnPointID - typeID - the ID of the agent's ship. Corresponds to typeID in invTypes
agtAgentTypes.csv.bz2	Defines agent types agentTypeID - defined ID for this table agentType - defined agent type
agtResearchAgents.csv.bz2	Defines skills for each Research Agent agentID - the ID of the agent. Corresponds to itemID in invNames typeID - the ID of a skill of the agent. Corresponds to typeID in invTypes
certCerts.csv.bz2	Defines in-game certificates certID - defined ID for this table description - description of the certificate groupID - the ID of the skill group for the certificate. Corresponds to groupID in invGroups name - the name of the group the certificate applies to
certMasteries.csv.bz2	Defines the level of Mastery for flying ships typeID - the ID of the ship. Corresponds to typeID in invTypes masteryLevel - defines each mastery level certID - the ID of each certificate required for this mastery level. Corresponds to certID in certCerts
certSkills.csv.bz2	Defines skills and skill levels needed to receive certificates certID - the ID of the certificate. Corresponds to certID in certCerts skillID - the ID of the skill needed for the certificate. Corresponds to typeID in invTypes skillLevel - the level of the skill in skillID needed for the certificate certLevelText - the level of the certificate
charFactions.csv.bz2	Empty file
chrAttributes.csv.bz2	Defines character attributes attributeID - defined ID for this table attributeName - defines the names of the attributes description - the description of attributes iconID - the ID of the icon for the attribute. Corresponds to iconID in eveIcons
chrBloodlines.csv.bz2	Contains information on what race each bloodline belongs to, descriptions. bloodlineID - defined ID for this table bloodlineName - defines the name of the bloodline raceID - the ID of the race the bloodline belongs to. Corresponds to raceID in chrRaces description - the description of the bloodline maleDescription, femaleDescription, shipTypeID - not used in game corporationID - the ID of the default NPC corporation to join when not in player corporation. Corresponds to itemID in invNames perception, willpower, charisma, memory, intelligence - the initial values of character attributes on character creation iconID - the ID of the icon for the bloodline. Corresponds to iconID in eveIcons shortDescription, shortMaleDescription, shortFemaleDescription - not used in game
chrFactions.csv.bz2	Faction IDs, name, and description. Also what race each faction belongs to, and some other misc. information. factionID - defined ID for this table factionName - defines names of factions description - the description of factions raceID - the ID of the race the faction belongs to. Corresponds to raceID in chrRaces solarSystemID - the ID of the home solar system of factions. Corresponds to solarSystemID in mapSolarSystems corporationID - the ID of the military corporations of factions. Corresponds to itemID in invNames sizeFactor - stationCount, stationSystemCount - not used in game militiaCorporationID - the ID of the militia corporations of factions. Corresponds to itemID in invNames iconID - the ID of the icon for factions. Corresponds to iconID in eveIcons
chrRaces.csv.bz2	Description of Races raceID - defined ID for this table raceName - defines names of races description - the description of races iconID - the ID of the icon for races. Corresponds to iconID in eveIcons shortDescription - short description of races
crpActivities.csv.bz2	Description of activities of NPC corporations activityID - defined ID for this table activityName - defines names of activities description - not used
crpNPCCorporationDivisions.csv.bz2	Description of divisions of NPC corporations corporationID - ID of NPC corporations. Corresponds to itemID in invNames divisionID - size -
crpNPCCorporationResearchFields.csv.bz2	Skills available to Research Agents in NPC corporations skillID - the ID of skills. Corresponds to typeID in invTypes corporationID - ID of NPC corporations. Corresponds to itemID in invNames
crpNPCCorporations.csv.bz2	Describes NPC corporations corporationID - ID of NPC corporations. Corresponds to itemID in invNames size - extent - solarSystemID - the ID of the home solar system of corporations. Corresponds to solarSystemID in mapSolarSystems investorID1, investorShares1, investorID2, investorShares2, investorID3, investorShares3, investorID4, investorShares4 - not used in game friendID - ID of a friendly corporation. Corresponds to itemID in invNames enemyID - ID of an enemy corporation. Corresponds to itemID in invNames publicShares - not used in game initialPrice - minSecurity - scattered, fringe, corridor, hub, border - not used in game factionID - ID of the faction corporation belongs to. Corresponds to factionID in chrFactions sizeFactor, stationCount, stationSystemCount - not used in game description - description of corporations iconID - the ID of the icon for factions. Corresponds to iconID in eveIcons
crpNPCCorporationTrades.csv.bz2	Items sold by NPC corporations corporationID - ID of NPC corporations. Corresponds to itemID in invNames typeID - the ID of the traded items. Corresponds to typeID in invTypes
crpNPCDivisions.csv.bz2	Empty file
dgmAttributeCategories.csv.bz2	Categories of dogma attributes categoryID - defined ID for this table categoryName - defines names of dogma categories categoryDescription - description of dogma categories
dgmAttributeTypes.csv.bz2	Types of dogma attributes attributeID - defined ID for this table attributeName - defines names of dogma attribute types description - desciption of dogma attribute types iconID - the ID of the icon for attribute types. Corresponds to iconID in eveIcons defaultValue - the default value of attribute types published - Boolean flag for whether the attribute type was published and is available in game displayName - attribute name displayed in game unitID - the ID of units for attributes. Corresponds to unitID in eveUnits stackable - Boolean flag for whether the attribute can be stacked with other attributes highIsGood - Boolean flag for whether high value of the attribute is beneficial categoryID - the ID of the attribute category for the attribute type. Corresponds to categoryID in dgmAttributeCategories
dgmEffects.csv.bz2	The effects of dogma attributes effectID - defined ID for this table effectName - defines names of dogma effects effectCategory, preExpression, postExpression - not used in game description - desciption of dogma effects guid - qualified names of dogma effects iconID - the ID of icons for attribute effects. Corresponds to iconID in eveIcons isOffensive - Boolean flag for whether dogma effects are offensive isAssistance - Boolean flag for whether dogma effects are assistive durationAttributeID - the ID of attribute type for duration of the dogma effects. Corresponds to attributeID in dgmAttributeTypes trackingSpeedAttributeID - the ID of attribute type for tracking speed of the dogma effects. Corresponds to attributeID in dgmAttributeTypes dischargeAttributeID - the ID of attribute type for discharge of the dogma effects. Corresponds to attributeID in dgmAttributeTypes rangeAttributeID - the ID of attribute type for range of the dogma effects. Corresponds to attributeID in dgmAttributeTypes falloffAttributeID - the ID of attribute type for falloff of the dogma effects. Corresponds to attributeID in dgmAttributeTypes disallowAutoRepeat - Boolean flag for whether dogma effect autorepeat is disallowed published - Boolean flag for whether dogma effects are published and available in game displayName - the name of the dogma effect displayed in game isWarpSafe - Boolean flag for whether dogma effects disrupt warp rangeChance, electronicChance, propulsionChance, distribution, sfxName, npcUsageChanceAttributeID, npcActivationChanceAttributeID, fittingUsageChanceAttributeID - not used in game modifierInfo - information about application of modifiers
dgmExpressions.csv.bz2	Empty file
dgmTypeAttributes.csv.bz2	Assigns dogma attribute types to item type typeID - the ID of the item. Correponds to typeID in invTypes attributeID - the ID of the dogma attribute type. Corresponds to attributeID in dgmAttributeTypes valueInt - Integer value of the dogma attribute valueFloat - Floating point value of the dogma attribute
dgmTypeEffects.csv.bz2	Assigns dogma effects to item types typeID - the ID of the item. Corresponds to typeID in invTypes effectID - the ID of the dogma effect. Corresponds to effectID in dgmEffects isDefault - Boolean flag for whether the dogma effect is default for the item
eveGraphics.csv.bz2	Graphics resources graphicID - defined ID for this table sofFactionName - faction name for graphics graphicFile - file name of graphics sofHullName - hull name of graphics sofRaceName - race name of graphics description - description of graphics
eveIcons.csv.bz2	Icon resources iconID - defined ID for this table iconFile - file name of icon description - description of icon
eveUnits.csv.bz2	Describes units used in dogma and item properties unitID - defined ID for this table unitName - defines names of units displayName, description - not used in game
industryActivity.csv.bz2	Describes industrial activities possible for each blueprint typeID - the ID of the blueprint. Correponds to typeID in invTypes activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities time - base time in seconds for activities
industryActivityMaterials.csv.bz2	Describes materials required to perform each industrial activity for blueprints typeID - the ID of the blueprint. Correponds to typeID in invTypes activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities materialTypeID - the ID of the material. Correponds to typeID in invTypes quantity - the base required quantity of the material to perform industrial activities
industryActivityProbabilities.csv.bz2	Describes outcomes and probabilities of inventions typeID - the ID of the blueprint. Correponds to typeID in invTypes activityID - the ID if industrial activities for blueprints (activityID = 8 for Invention). Corresponds to activityID in ramActivities productTypeID - the ID of the outcome blueprint. Correponds to typeID in invTypes probability - the base probability of successful invention
industryActivityProducts.csv.bz2	Describes outcomes of industrial activities typeID - the ID of the blueprint. Correponds to typeID in invTypes activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities productTypeID - the ID of the outcome product. Correponds to typeID in invTypes quantity - the base quantity of product from industrial activities
industryActivityRaces.csv.bz2	Empty file
industryActivitySkills.csv.bz2	Describes skills required perform industrial activities typeID - the ID of the blueprint. Correponds to typeID in invTypes activityID - the ID if industrial activities for blueprints. Corresponds to activityID in ramActivities skillID - the ID of the skill required for activities. Correponds to typeID in invTypes level - minimum skill level required for activities
industryBlueprints.csv.bz2	Describes the base maximum number of BPC runs typeID - the ID of the blueprint. Correponds to typeID in invTypes maxProductionLimit - base maximum number of BPC runs
invCategories.csv.bz2	Item category IDs and names categoryID - defined ID for this table categoryName - defines names of categories iconID - the ID of icons for categories. Corresponds to iconID in eveIcons published - Boolean flag for whether categories are published and available in game
invContrabandTypes.csv.bz2	Describes items considered contraband for each faction factionID - the ID of factions. Corresponds to factionID in chrFactions typeID - the ID of cotraband items. Corresponds to typeID in invTypes standingLoss - the loss of standings when contraband is found confiscateMinSec - minimum time in seconds after which the contraband is confiscated fineByValue - multiplier of value for fine when contraband is found attackMinSec - minimum time in seconds before attack when contraband is found
invControlTowerResourcePurposes.csv.bz2	Empty file
invControlTowerResources.csv.bz2	Describes control tower properties controlTowerTypeID - the ID of control towers. Corresponds to typeID in invTypes resourceTypeID - the ID of resource required by control towers. Corresponds to typeID in invTypes purpose - quantity - required quantity of resource minSecurityLevel - minimum security level of the system in which control tower can be anchored factionID - the ID of faction of control tower
invFlags.csv.bz2	Flags describing various items flagID - defined ID for this table flagName - defines names of flags flagText - displayed text for flags orderID -
invGroups.csv.bz2	Describes inventory groups groupID - defined ID for this table categoryID - the ID of categories of inventory groups. Corresponds to categoryID in invCategories groupName - defines names of inventory groups iconID - the ID of icons for inventory groups. Corresponds to iconID in eveIcons useBasePrice - Boolean flag to use base item price instead of adjusted item price in job cost calculation anchored - Boolean flag to mark a permanently anchored items anchorable - Boolean flag to mark items that can be anchored fittableNonSingleton - Boolean flag to mark items that are fittable despite not being flagged as Singletons published - Boolean flag to mark inventory groups that are published and available in game
invItems.csv.bz2	Describes items that have defined owners itemID - defined ID for this table typeID - the ID of the item type. Corresponds to typeID in invTypes ownerID - the ID of items' owner. Corresponds to itemID in invNames locationID - the ID of items' location. Corresponds to itemID in invPositions flagID - the ID of items' flag. Corresponds to flagID in invFlags quantity - the items' quantity. Quantity = -1 means unlimited quantity
invMarketGroups.csv.bz2	Defines the market group hierarchy marketGroupID - defined ID for this table parentGroupID - the ID of the parent marketing group, if any. Corresponds to marketGroupID in invMarketGroups marketGroupName - defines names of marketing groups description - description of marketing groups iconID - the ID of icons for marketing groups. Corresponds to iconID in eveIcons hasTypes - Boolean flag to mark marketing groups that are also parent groups
invMetaGroups.csv.bz2	Description of meta groups metaGroupID - defined ID for this table metaGroupName - defines names of meta groups description - description of meta groups iconID - the ID of icons for meta groups. Corresponds to iconID in eveIcons
invMetaTypes.csv.bz2	Assigns item types to meta groups typeID - the ID of the item type. Corresponds to typeID in invTypes parentTypeID - the ID of the item type's parent, if any (the Tech I item for a Tech II item etc.). Corresponds to typeID in invTypes metaGroupID - the ID of the item type's meta group. Corresponds to metaGroupID in invMetaGroups
invNames.csv.bz2	Describes unique items itemID - defined ID for this table itemName - defines names of unique items
invPositions.csv.bz2	Describes position of unique items itemID - ID of unique items. Corresponds to itemID in invNames x, y, z - coordinates of unique items yaw, pitch, roll - orientation of unique items
invTraits.csv.bz2	Describes traites ("bonuses") of ships traitID - defined ID for this table typeID - the ID of the ship type. Corresponds to typeID in invTypes skillID - the ID of the skill required to fly the ship. Corresponds to typeID in invTypes bonus - the size of ship's bonus bonusText - description of ship's bonus unitID - the ID of the unit of the ship's bonus. Corresponds to unitID in eveUnits
invTypeMaterials.csv.bz2	Describes materials obtained from reprocessing of items typeID - the ID of the item to reprocess. Corresponds to typeID in invTypes materialTypeID - the ID of the material obtained from reprocessing. Corresponds to typeID in invTypes quantity - base quantity of material obtained from reprocessing
invTypeReactions.csv.bz2	Empty file
invTypes.csv.bz2	Defines item types typeID - defined ID for this table groupID - ID of inventory groups for items. Corresponds to groupID in invGroups typeName - defines names of items description - description of items mass - mass of items in kg volume - volume of items in m3 capacity - maximum volume of contained items in m3 portionSize - minimum number of items to reprocess raceID - ID of item's race. Corresponds to raceID in chrRaces basePrice - item's base price in ISK published - Boolean flag to mark items that are published and available in game marketGroupID - ID of item's market group. Corresponds to marketGroupID in invMarketGroups iconID - ID of item's icon. Corresponds to iconID in eveIcons soundID - ID if item's sound resource graphicID - ID of item's graphic resource. Corresponds to graphicID in eveGraphics
invTypes-nodescription.csv.bz2	Table invTypes excluding description
invUniqueNames.csv.bz2	Describes unique names itemID - defined ID for this table itemName - defines unique names groupID - ID of name's inventory group. Corresponds to groupID in invGroups
invVolumes.csv.bz2	Describes volumes of packaged ships typeID - the ID of the ship. Corresponds to typeID in invTypes volume - packaged ship volume in m3
mapCelestialGraphics.csv.bz2	Describes graphics settings of celestials celestialID - ID of celestials. Corresponds to celestialID in mapDenormalize heightMap1 - heightMap2 - shaderPreset - population -
mapCelestialStatistics.csv.bz2	Describes physical parameters of celestials celestialID - ID of celestials. Corresponds to celestialID in mapDenormalize temperature - celestial's temperature spectralClass - spectral class for stars, 0 otherwise luminosity - luminosity for stars, "None" otherwise age - age in seconds for stars, 0 otherwise life - remaining lifetime in seconds for stars, 0 otherwise orbitRadius - celestial's orbit radius in meters, "None" for stars eccentricity - celestial's orbit eccentricity in meters, "None" for stars, 0 for asteroid belts massDust - celestial's mass of dust in kg massGas - celestial's mass of gas in kg fragmented - Boolean flag to mark whether the celestial is fragmented. "None" for stars density - celestial's density in kg/m3. "None" for stars surfaceGravity - celestial's surface gravity in m/s2. "None" for stars escapeVelocity - celestial's escape velocity in m/s. "None" for stars orbitPeriod - celestial's orbital period in seconds. "None" for stars rotationRate - celestial's rotational rate in (?). "None" for stars locked - Boolean flag pressure - celestial's atmospheric pressure in atm (?). "None" for stars, 0 for asteroid belts radius - celestial's radius in m mass - not used in game
mapConstellationJumps.csv.bz2	Describes gate jumps between constellations fromRegionID - ID of the starting region. Corresponds to regionID in mapRegions fromConstellationID - ID of the starting constellation. Corresponds to constellationID in mapConstellations toConstellationID - ID of the ending constellation. Corresponds to constellationID in mapConstellations toRegionID - ID of the ending region. Corresponds to regionID in mapRegions
mapConstellations.csv.bz2	Describes constellations regionID - ID of the costellation's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize constellationID - - ID of the costellation region. Corresponds to itemID in mapDenormalize constellationName - defines names of constellations. Same as itemName in mapDenormalize x, y, z - coordinates of constellation's center in Universe coordinates, in meters xMin, xMax, yMin, yMax, zMin, zMax - coordinates of constellation's box in Universe coordinates, in meters factionID - ID of the faction owning the constellation. Corresponds to factionID in chrFactions radius - radius of sphere circumscribing constellation, in meters
mapDenormalize.csv.bz2	Describes celestials itemID - defined ID for this table typeID - the ID of the celestial type. Corresponds to typeID in invTypes groupID - the ID of the celestial's inventory group. Corresponds to groupID in invGroups solarSystemID - the ID of the celestial's solar system, if any. Corresponds to solarSystemID in mapSolarSystems. "None" otherwise constellationID - the ID of the celestial's constellation, if any. Corresponds to constellationID in mapConstellations. "None" otherwise regionID - the ID of the celestial's region, if any. Corresponds to regionID in mapRegions. "None" otherwise orbitID - the ID of the body the celestial orbits, if any. Corresponds to itemID in mapDenormalize. "None" otherwise x, y, z - coordinates of celestial's center in Universe coordinates, in meters radius - radius of sphere circumscribing celestial, in meters, if any. "None" otherwise itemName - defines names of celestials security - security level for solar systems, "None" otherwise celestialIndex - index of planet, or parent planet, orbiting sun, if any. "None" otherwise. celestialIndex = 2 for the 2nd planet around a star, 1st asteroid belt and 1st moon around the 2nd planet around a star orbitIndex - index of celestial orbiting parent planet, if any. "None" otherwise. orbitIndex = 1 for the 1st asteroid belt and 1st moon around a planet
mapJumps.csv.bz2	Describes gate jumps between solar systems stargateID - the ID of the starting solar system. Corresponds to solarSystemID in mapSolarSystems destinationID- the ID of the ending solar system. Corresponds to solarSystemID in mapSolarSystems
mapLandmarks.csv.bz2	Empty file
mapLocationWormholeClasses.csv.bz2	Each location's wormholeClassID locationID - ID of the location. Corresponds to itemID in mapDenormalize wormholeClassID -
mapRegionJumps.csv.bz2	Describes gate jumps between regions fromRegionID - the ID of the starting region. Corresponds to regionID in mapRegions toRegionID - the ID of the starting region. Corresponds to regionID in mapRegions
mapRegions.csv.bz2	Describes regions regionID - ID of the region. Corresponds to itemID in mapDenormalize regionName - defines names of regions. Same as itemName in mapDenormalize x, y, z - coordinates of region's center in Universe coordinates, in meters xMin, xMax, yMin, yMax, zMin, zMax - coordinates of region's box in Universe coordinates, in meters factionID - ID of the faction owning the constellation. Corresponds to factionID in chrFactions nebula - the ID of the graphics of nebulae in the region. Corresponds to graphicID in eveGraphics radius - not used in game
mapSolarSystemJumps.csv.bz2	Describes gate jumps between solar systems fromRegionID - ID of the starting region. Corresponds to regionID in mapRegions fromConstellationID - ID of the starting constellation. Corresponds to constellationID in mapConstellations fromSolarSystemID - ID of the starting solar system. Corresponds to regionID in mapSolarSystems toSolarSystemID - ID of the ending solar system. Corresponds to regionID in mapSolarSystems toConstellationID - ID of the ending constellation. Corresponds to constellationID in mapConstellations toRegionID - ID of the ending region. Corresponds to regionID in mapRegions
mapSolarSystems.csv.bz2	Describes solar systems regionID - ID of the solar system's region. Corresponds to regionID in mapRegions and itemID in mapDenormalize constellationID - ID of the solar system's constellation. Corresponds to constellationID in mapConstellations and itemID in mapDenormalize solarSystemID - ID of the solar system. Corresponds to itemID in mapDenormalize solarSystemName - defines names of solar systems. Same as itemName in mapDenormalize x, y, z - coordinates of solar systems's center in Universe coordinates, in meters xMin, xMax, yMin, yMax, zMin, zMax - coordinates of solar systems's box in Universe coordinates, in meters luminosity - star's luminoaity border - Boolean flag to mark whether the solar system is a border system fringe - corridor - hub - international - regional - constellation - not used in game security - solar system's security factionID - ID of the faction owning the solar system. Corresponds to factionID in chrFactions radius - solar system's radius in meters sunTypeID - ID of the sun type. Corresponds to itemType in invTypes securityClass - securyty class of the system
mapUniverse.csv.bz2	Defines the K- and J-space unverses universeID - ID of the universe. Corresponds to typeID in invTypes universeName - defines universe names x, y, z - coordinates of universe, in meters xMin, xMax, yMin, yMax, zMin, zMax - coordinates of universe box, in meters radius - universe radius in meters
planetSchematics.csv.bz2	Describes Planetary Industry schematics schematicID - defined ID for this table schematicName - defines schematic names cycleTime - schematic cycle time completion in seconds
planetSchematicsPinMap.csv.bz2	Associates pin types with schematics schematicID - ID of the schematic. Corresponds to schematicID in planetSchematics pinTypeID - ID of the pin. Corresponds to typeID in invTypes
planetSchematicsTypeMap.csv.bz2	Describes schematic productivity schematicID - ID of the schematic. Corresponds to schematicID in planetSchematics typeID - ID of the PI product. Corresponds to typeID in invTypes quantity - the size of a batch of PI isInput -
ramActivities.csv.bz2	Describes types of industrial activities activityID - defined ID for this table activityName - defines activity names iconNo - description - description of activities published - Boolean flag to mark industrial activities that are published and available in game
ramAssemblyLineStations.csv.bz2	Describes industry activities available at NPC stations stationID - ID of NPC stations. Corresponds to stationID in staStations assemblyLineTypeID - ID of assembly line type (station service type). Corresponds to assemblyLineTypeID in ramAssemblyLineTypes quantity - stationTypeID - ID of NPC station type. Corresponds to typeID in invTypes ownerID - ID of station owner. Corresponds to itemID in invUniqueNames solarSystemID - ID of solar system. Corresponds to solarSystemID in mapSolarSystems regionID - ID of region. Corresponds to regionID in mapRegions
ramAssemblyLineTypeDetailPerCategory.csv.bz2	Describes time, material, and cost bonuses at NPC station types for each inventory category assemblyLineTypeID - ID of assembly line type (station service type). Corresponds to assemblyLineTypeID in ramAssemblyLineTypes categoryID - ID of inventory categories. Corresponds to categoryID in invCategories timeMultiplier, materialMultiplier, costMultiplier - multipliers for time, material, and cost bonuses
ramAssemblyLineTypeDetailPerGroup.csv.bz2	Describes time, material, and cost bonuses at NPC station types for each inventory group assemblyLineTypeID - ID of assembly line type (station service type). Corresponds to assemblyLineTypeID in ramAssemblyLineTypes groupID - ID of inventory groups. Corresponds to groupID in invGroups timeMultiplier, materialMultiplier, costMultiplier - multipliers for time, material, and cost bonuses
ramAssemblyLineTypes.csv.bz2	Describes installation services assemblyLineTypeID - defined ID for this table assemblyLineTypeName - defines installation service names description - description of installation services baseTimeMultiplier - multiplier for job time for the service baseMaterialMultiplier - multiplier for material amount for the service baseCostMultiplier - multiplier for job cost for the service volume - not used in game activityID - ID of activity for the service. Corresponds to activityID in ramActivities minCostPerHour - minimum cost per hour for the service
ramInstallationTypeContents.csv.bz2	Assigns station services to installation types installationTypeID - ID of installation types. Corresponds to typeID in invTypes assemblyLineTypeID - ID of installatin service. Corresponds to assemblyLineTypeID in ramAssemblyLineTypes quantity -
skinLicense.csv.bz2	Assigns licence types to skin types licenseTypeID - ID of licence types. Corresponds to typeID in invTypes duration - duration of the license. -1 means a permanent licence skinID - ID of the skin. Corresponds to skinID in skins
skinMaterials.csv.bz2	skinMaterialID - displayNameID - materialSetID -
skins.csv.bz2	skinID - internalName - skinMaterialID -
skinShip.csv.bz2	Assigns skin types to ships skinID - ID of skins. Corresponds to skinID in skins typeID - ID of ship. Corresponds to typeID in invTypes
solarsystemprecise.csv.bz2	Empty file
staOperations.csv.bz2	activityID - operationID - operationName - description - fringe - corridor - hub - border - ratio - caldariStationTypeID, minmatarStationTypeID, amarrStationTypeID, gallenteStationTypeID, joveStationTypeID -
staOperationServices.csv.bz2	operationID - serviceID -
staServices.csv.bz2	Description of NPC station services serviceID - defined ID for this table serviceName - defines service names description - description of services
staStations.csv.bz2	Describes NPC stations stationID - ID of the station. Corresponds to itemID in mapDenormalize security - system security dockingCostPerVolume, maxShipVolumeDockable, officeRentalCost - not used in game operationID - stationTypeID - ID of station type. Corresponds to typeID in invTypes corporationID - solarSystemID - constellationID - regionID - stationName - x, y, z - reprocessingEfficiency - reprocessingStationsTake - reprocessingHangarFlag -
staStationTypes.csv.bz2	stationTypeID - dockEntryX - dockEntryY - dockEntryZ - dockOrientationX - dockOrientationY - dockOrientationZ - operationID - officeSlots - reprocessingEfficiency - conquerable -
translationTables.csv.bz2	Empty file
trnTranslationColumns.csv.bz2	tcGroupID - tcID - tableName - columnName - masterID -
trnTranslationLanguages.csv.bz2	numericLanguageID - languageID - languageName -
trnTranslations.csv.bz2
warCombatZones.csv.bz2	combatZoneID - combatZoneName - factionID - centerSystemID - description -
warCombatZoneSystems.csv.bz2	solarSystemID - combatZoneID -

External links

• CodeCademy
• Corey Schafer
• EVE Online Discord Dev Chat 3rd-party-dev-and-esi - I read most messages sent here, if you need help that StackOverflow can't provide, here is your best bet.