Static Data Export

Currently a placeholder for a page I'm working on

How to use the fuzzwork dumps

The fuzzwork dumps, also knows as the SDE, are very useful for many 3rd party applications. They can be found at www.fuzzwork.co.uk under SDE, then under latest, or more directly at www.fuzzwork.co.uk/dump/latest. This article will go into detail on what each part is for, and how to access it.

Opening a file from the SDE

Directly quoted from the site: "To open bz2 files, use bunzip2 in linux, or something like 7zip in windows" Each file come in two flavors, CSV and SQL. For the purpose of this guide I won't go into opening SQL files, and rather assume that you will be using CSV files.

What each file does

File name	What it does
ramActivities.csv.bz2	Describe what each R.A.M. does. See Manufacturing
invGroups.csv.bz2	Contains information on inventory groups, such as groupID, categoryID, and other metadata
agtAgents.csv.bz2	Contains information regarding agents such as location, corporation, type, level, and locator (boolean)
ramAssemblyLineTypeDetailPerCategory.csv.bz2	Example
dgmExpressions.csv.bz2	Example
dgmEffects.csv.bz2	Example
warCombatZones.csv.bz2	Example
staOperationServices.csv.bz2	Example
invMetaGroups.csv.bz2	Example
industryActivitySkills.csv.bz2	Example
chrBloodlines.csv.bz2	Example
skinShip.csv.bz2	Example
crpNPCCorporationTrades.csv.bz2	Example
mapUniverse.csv.bz2	Example
invItems.csv.bz2	Example
staStations.csv.bz2	Example
mapLocationWormholeClasses.csv.bz2	Example
invCategories.csv.bz2	Example
eveGraphics.csv.bz2	Example
mapDenormalize.csv.bz2	Example
crpActivities.csv.bz2	Example
chrRaces.csv.bz2	Example
chrFactions.csv.bz2	Example
invNames.csv.bz2	Example
invMetaTypes.csv.bz2	Example
dgmTypeEffects.csv.bz2	Example
crpNPCDivisions.csv.bz2	Example
crpNPCCorporationResearchFields.csv.bz2	Example
certMasteries.csv.bz2	Example
translationTables.csv.bz2	Example
planetSchematics.csv.bz2	Example
mapConstellations.csv.bz2	Example
dgmTypeAttributes.csv.bz2	Example
dgmAttributeCategories.csv.bz2	Example
crpNPCCorporationDivisions.csv.bz2	Example
skinLicense.csv.bz2	Example
invPositions.csv.bz2	Example
certSkills.csv.bz2	Example
staStationTypes.csv.bz2	Example
mapSolarSystems.csv.bz2	Example
invTraits.csv.bz2	Example
invControlTowerResourcePurposes.csv.bz2	Example
invContrabandTypes.csv.bz2	Example
mapLandmarks.csv.bz2	Example
invFlags.csv.bz2	Example
industryActivityMaterials.csv.bz2	Example
warCombatZoneSystems.csv.bz2	Example
staServices.csv.bz2	Example
mapConstellationJumps.csv.bz2	Example
mapCelestialStatistics.csv.bz2	Example
trnTranslations.csv.bz2	Example
mapSolarSystemJumps.csv.bz2	Example
dgmAttributeTypes.csv.bz2	Example
agtResearchAgents.csv.bz2	Example
ramAssemblyLineTypeDetailPerGroup.csv.bz2	Example
invTypeMaterials.csv.bz2	Example
mapJumps.csv.bz2	Example
invControlTowerResources.csv.bz2	Example
industryBlueprints.csv.bz2	Example
industryActivity.csv.bz2	Example
certCerts.csv.bz2	Example
invTypes.csv.bz2	Example
mapLocationScenes.csv.bz2	Example
chrAncestries.csv.bz2	Example
invUniqueNames.csv.bz2	Example
trnTranslationLanguages.csv.bz2	Example
trnTranslationColumns.csv.bz2	Example
skins.csv.bz2	Example
ramInstallationTypeContents.csv.bz2	Example
planetSchematicsTypeMap.csv.bz2	Example
mapRegions.csv.bz2	Example
invTypeReactions.csv.bz2	Example
industryActivityRaces.csv.bz2	Example
eveUnits.csv.bz2	Example
eveIcons.csv.bz2	Example
agtAgentTypes.csv.bz2	Example
staOperations.csv.bz2	Example
skinMaterials.csv.bz2	Example
ramAssemblyLineTypes.csv.bz2	Example
ramAssemblyLineStations.csv.bz2	Example
planetSchematicsPinMap.csv.bz2	Example
mapRegionJumps.csv.bz2	Example
invVolumes.csv.bz2	Example
invMarketGroups.csv.bz2	Example
industryActivityProducts.csv.bz2	Example
industryActivityProbabilities.csv.bz2	Example
crpNPCCorporations.csv.bz2	Example
chrAttributes.csv.bz2	Example