ETW Data
From Totalwar.org
At the heart of any game beats a spreadsheet (the cleverer ones hide this fact well). For complex games, there are several.
Thanks to the excellent Pack File Manager by LtChambers, we can now look at (many of) the data files for Empire: Total War.
When the Steam client caches the game on your system, it tucks the data files into %ProgramFiles%\Steam\SteamApps\common\empire total war\data, as a collection of .pack files. These are archives that contain other files, much like .zip or .cab files.
There are several .pack files: the following sub-sections contain a quick look at some of the interesting things revealed.
main.pack
This is the Big Cahuna, the key to most of the non-"eye candy" aspects of the game. As of version 1.11, the Pack File Manager does not decode all the contained files. But many that it can understand are quite useful.
Rather than just present them in alphabetical order, we've grouped each file in main.pack into (hopefully useful) categories:
Geography
regions_continents
This is simply a list of valid continent identifiers, as referenced elsewhere.
| Continent ID |
|---|
| cont_africa_south |
| cont_america_latin |
| cont_america_north |
| cont_europe |
| cont_impassable |
| cont_india |
| cont_middle_east |
| cont_se_asia |
regions
This describes the regions on each continent.
| Region ID | Continent ID |
|---|---|
| acadia | cont_america_north |
| afghanistan | cont_middle_east |
| ahmadnagar | cont_india |
| algiers | cont_middle_east |
| algonquin_territory | cont_america_north |
| alsace | cont_europe |
| amazonas | cont_impassable |
| anatolia | cont_middle_east |
| arabia | cont_impassable |
| arkhangelsk | cont_europe |
| armenia | cont_europe |
| astrakhan | cont_europe |
| austria | cont_europe |
| azerbaijan | cont_middle_east |
| bahamas | cont_america_north |
| baluchistan | cont_middle_east |
| bashkira | cont_europe |
| bavaria | cont_europe |
| belarus | cont_europe |
| bengal | cont_india |
| berar | cont_india |
| bijapur | cont_india |
| bohemia | cont_europe |
| bosnia | cont_europe |
| bulgaria | cont_europe |
| carnatica | cont_india |
| carolinas | cont_america_north |
| central_africa | cont_impassable |
| ceylon | cont_india |
| chechenya-dagestan | cont_europe |
| cherokee_territory | cont_america_north |
| china | cont_impassable |
| congo_impassable | cont_impassable |
| corsica | cont_europe |
| courland | cont_europe |
| crimea | cont_europe |
| croatia | cont_europe |
| cuba | cont_america_latin |
| curacao | cont_america_latin |
| denmark | cont_europe |
| don_voisko | cont_europe |
| dutch_guyana | cont_america_latin |
| east_africa | cont_impassable |
| egypt | cont_middle_east |
| england | cont_europe |
| estonia_and_livonia | cont_europe |
| finland | cont_europe |
| flanders | cont_europe |
| florida | cont_america_north |
| france | cont_europe |
| french_guyana | cont_america_latin |
| galicia | cont_europe |
| genoa | cont_europe |
| georgia | cont_europe |
| georgia_usa | cont_america_north |
| gibraltar | cont_europe |
| great_plains | cont_america_north |
| greece | cont_europe |
| greenland | cont_impassable |
| guatemala | cont_america_latin |
| gujarat | cont_india |
| hannover | cont_europe |
| hausa | cont_impassable |
| himalayas | cont_impassable |
| hindukush | cont_impassable |
| hindustan | cont_india |
| hispaniola | cont_america_latin |
| hungary | cont_europe |
| huron_territory | cont_america_north |
| hyderabad | cont_india |
| iceland | cont_europe |
| indochina | cont_impassable |
| ingria | cont_europe |
| ireland | cont_europe |
| iroquois_territory | cont_america_north |
| ivory_coast | cont_impassable |
| jamaica | cont_america_latin |
| kaintuck_territory | cont_america_north |
| kalahari | cont_impassable |
| karelia | cont_europe |
| kashmir | cont_india |
| komi | cont_europe |
| labrador | cont_america_north |
| leeward_islands | cont_america_latin |
| lithuania | cont_europe |
| lower_louisiana | cont_america_north |
| maine | cont_america_north |
| malabar | cont_india |
| malta | cont_europe |
| malwa | cont_india |
| maryland | cont_america_north |
| mesopotamia | cont_middle_east |
| michigan_territory | cont_america_north |
| milan | cont_europe |
| moldavia | cont_europe |
| morea | cont_europe |
| morocco | cont_middle_east |
| muscovy | cont_europe |
| mysore | cont_india |
| naples | cont_europe |
| netherlands | cont_europe |
| new_andalusia | cont_america_latin |
| new_england | cont_america_north |
| new_france | cont_america_north |
| new_grenada | cont_america_latin |
| new_mexico | cont_america_north |
| new_spain | cont_america_latin |
| new_york | cont_america_north |
| newfoundland | cont_america_north |
| northwest_territories | cont_america_north |
| northwest_territorys | cont_impassable |
| norway | cont_europe |
| ontario | cont_america_north |
| orissa | cont_india |
| palestine | cont_middle_east |
| panama | cont_america_latin |
| pennsylvania | cont_america_north |
| persia | cont_middle_east |
| poland | cont_europe |
| portugal | cont_europe |
| prussia | cont_europe |
| punjab | cont_india |
| rajpootana | cont_india |
| rhineland | cont_europe |
| rift_valley | cont_impassable |
| rumelia | cont_europe |
| ruperts_land | cont_america_north |
| sahara | cont_impassable |
| sardinia | cont_europe |
| savoy | cont_europe |
| saxony | cont_europe |
| scotland | cont_europe |
| serbia | cont_europe |
| siberia | cont_impassable |
| silesia | cont_europe |
| sindh | cont_india |
| south_africa | cont_impassable |
| spain | cont_europe |
| sweden | cont_europe |
| syria | cont_middle_east |
| tatariya | cont_europe |
| tejas | cont_america_north |
| the_papal_states | cont_europe |
| transylvania | cont_europe |
| trinidad_tobago | cont_america_latin |
| tripoli | cont_middle_east |
| tunis | cont_middle_east |
| turkoman | cont_impassable |
| ukraine | cont_europe |
| unexplorable | cont_impassable |
| upper_louisiana | cont_america_north |
| venice | cont_europe |
| virginia | cont_america_north |
| west_pommerania | cont_europe |
| west_prussia | cont_europe |
| western_plain | cont_impassable |
| windward_islands | cont_america_latin |
| wurttemberg | cont_europe |
campaign_map_settlements
This describes all the regions on the strategic map.
| ID | Region | Capital | Unknown |
|---|---|---|---|
| settlement:acadia:fort_nashwaak | acadia | Fort Nashwaak | 1 |
| settlement:acadia:louisbourg_ep3 | acadia | Louisbourg | 1 |
| settlement:afghanistan:kabul | afghanistan | Kabul | 1 |
| settlement:ahmadnagar:ahmadnagar | ahmadnagar | Ahmadnagar | 1 |
| settlement:algiers:algiers | algiers | Algiers | 1 |
| settlement:algonquin_territory:niagara | algonquin_territory | Niagara | 1 |
| settlement:alsace:strasbourg | alsace | Strasbourg | 1 |
| settlement:anatolia:angora | anatolia | Ankara | 4 |
| settlement:arkhangelsk:arkhangelsk | arkhangelsk | Arkhangelsk | 1 |
| settlement:armenia:yerevan | armenia | Yerevan | 1 |
| settlement:astrakhan:astrakhan | astrakhan | Astrakhan | 1 |
| settlement:austria:vienna | austria | Vienna | 5 |
| settlement:azerbaijan:ardabil | azerbaijan | Ardabil | 1 |
| settlement:bahamas:nassau | bahamas | Nassau | 1 |
| settlement:baluchistan:zahedan | baluchistan | Zahedan | 1 |
| settlement:bashkira:ufa | bashkira | Ufa | 1 |
| settlement:bavaria:munich | bavaria | Munich | 4 |
| settlement:belarus:minsk | belarus | Minsk | 1 |
| settlement:bengal:calcutta | bengal | Calcutta | 4 |
| settlement:berar:nagpur | berar | Nagpur | 1 |
| settlement:bijapur:satara | bijapur | Satara | 5 |
| settlement:bohemia:prague | bohemia | Prague | 4 |
| settlement:bosnia:sarajevo | bosnia | Sarajevo | 1 |
| settlement:bulgaria:sofia | bulgaria | Sofia | 1 |
| settlement:carnatica:arcot | carnatica | Arcot | 1 |
| settlement:carolinas:charleston | carolinas | Charleston | 1 |
| settlement:ceylon:trincomalee | ceylon | Trincomalee | 4 |
| settlement:chechenya-dagestan:tarki | chechenya-dagestan | Tarki | 1 |
| settlement:cherokee_territory:tellico | cherokee_territory | Tellico | 1 |
| settlement:corsica:bastia | corsica | Bastia | 1 |
| settlement:courland:jelgava | courland | Jelgava | 1 |
| settlement:crimea:bakhchisaray | crimea | Bakhchisaray | 1 |
| settlement:croatia:zagreb | croatia | Zagreb | 1 |
| settlement:cuba:la_habana | cuba | La Habana | 1 |
| settlement:curacao:punda | curacao | Punda | 1 |
| settlement:denmark:copenhagen | denmark | Copenhagen | 4 |
| settlement:don_voisko:cherkassk | don_voisko | Cherkassk | 1 |
| settlement:dutch_guyana:paramaribo | dutch_guyana | Paramaribo | 1 |
| settlement:egypt:cairo | egypt | Cairo | 4 |
| settlement:england:london | england | London | 5 |
| settlement:estonia_and_livonia:riga | estonia_and_livonia | Riga | 1 |
| settlement:finland:aabo | finland | Åbo | 1 |
| settlement:flanders:brussels | flanders | Brussels | 1 |
| settlement:florida:st_augustine | florida | St. Augustine | 1 |
| settlement:france:paris | france | Paris | 5 |
| settlement:french_guyana:cayenne | french_guyana | Cayenne | 1 |
| settlement:galicia:lwow | galicia | Lwów | 1 |
| settlement:genoa:genoa | genoa | Genoa | 1 |
| settlement:georgia:tbilisi | georgia | Tbilisi | 1 |
| settlement:georgia_usa:savannah | georgia_usa | Savannah | 1 |
| settlement:gibraltar:gibraltar | gibraltar | Gibraltar | 1 |
| settlement:great_plains:knife_river_village | great_plains | Knife River Village | 1 |
| settlement:greece:athens | greece | Athens | 4 |
| settlement:guatemala:antigua_guatemala | guatemala | Antigua Guatemala | 1 |
| settlement:gujarat:ahmedabad | gujarat | Ahmedabad | 4 |
| settlement:hannover:hannover | hannover | Hannover | 1 |
| settlement:hindustan:agra | hindustan | Agra | 4 |
| settlement:hispaniola:santo_domingo | hispaniola | Santo Domingo | 1 |
| settlement:hungary:pressburg | hungary | Preßburg | 1 |
| settlement:huron_territory:fort_sault_ste-marie | huron_territory | Fort Sault Ste. Marie | 1 |
| settlement:hyderabad:hyderabad | hyderabad | Hyderabad | 4 |
| settlement:iceland:reykjavik | iceland | Reykjavík | 1 |
| settlement:ingria:st_petersburg | ingria | St. Petersburg | 5 |
| settlement:ireland:dublin | ireland | Dublin | 1 |
| settlement:iroquois_territory:cayuga | iroquois_territory | Cayuga | 1 |
| settlement:jamaica:port_royal | jamaica | Port Royal | 1 |
| settlement:kaintuck_territory:tanase | kaintuck_territory | Tanase | 1 |
| settlement:karelia:petrovskaya_sloboda | karelia | Petrovskaya Sloboda | 1 |
| settlement:kashmir:srinagar | kashmir | Srinagar | 1 |
| settlement:komi:ust_sysolsk | komi | Ust-Sysolsk | 1 |
| settlement:labrador:agvituk | labrador | Agvituk | 1 |
| settlement:leeward_islands:antigua | leeward_islands | Antigua | 1 |
| settlement:lithuania:vilnius | lithuania | Vilnius | 4 |
| settlement:lower_louisiana:new_orleans | lower_louisiana | New Orleans | 1 |
| settlement:maine:falmouth | maine | Falmouth | 1 |
| settlement:malabar:goa | malabar | Goa | 1 |
| settlement:malta:valletta | malta | Valletta | 1 |
| settlement:malwa:ujjain | malwa | Ujjain | 1 |
| settlement:maryland:annapolis | maryland | Annapolis | 1 |
| settlement:mesopotamia:baghdad | mesopotamia | Baghdad | 4 |
| settlement:michigan_territory:detroit | michigan_territory | Fort Pontchartrain du Detroit | 1 |
| settlement:milan:milano | milan | Milan | 1 |
| settlement:moldavia:iasi | moldavia | Iasi | 1 |
| settlement:morea:patras | morea | Patras | 1 |
| settlement:morocco:tangier | morocco | Tangier | 4 |
| settlement:muscovy:moscow | muscovy | Moscow | 5 |
| settlement:mysore:mysore | mysore | Mysore | 4 |
| settlement:naples:naples | naples | Naples | 1 |
| settlement:netherlands:amsterdam | netherlands | Amsterdam | 5 |
| settlement:new_andalusia:caracas | new_andalusia | Caracas | 4 |
| settlement:new_england:boston | new_england | Boston | 4 |
| settlement:new_england:boston_ep2 | new_england | Boston | 1 |
| settlement:new_france:quebec | new_france | Québec | 4 |
| settlement:new_france:quebec_ep2 | new_france | Québec | 1 |
| settlement:new_grenada:bogota | new_grenada | Bogotá | 1 |
| settlement:new_mexico:santa_fe | new_mexico | Santa Fe | 1 |
| settlement:new_spain:mexico | new_spain | México | 4 |
| settlement:new_york:albany | new_york | Albany | 1 |
| settlement:newfoundland:plaissance | newfoundland | Plaissance | 1 |
| settlement:northwest_territories:york_factory | northwest_territories | York Factory | 1 |
| settlement:norway:christiania | norway | Christiania | 1 |
| settlement:ontario:montreal | ontario | Montréal | 1 |
| settlement:orissa:cuttack | orissa | Cuttack | 1 |
| settlement:palestine:jerusalem | palestine | Jerusalem | 4 |
| settlement:panama:panama | panama | Panama | 1 |
| settlement:pennsylvania:ep_1_philadelphia | pennsylvania | Philadelphia | 1 |
| settlement:pennsylvania:philadelphia | pennsylvania | Philadelphia | 5 |
| settlement:persia:isfahan | persia | Isfahan | 4 |
| settlement:poland:warsaw | poland | Warsaw | 5 |
| settlement:portugal:lisbon | portugal | Lisbon | 5 |
| settlement:prussia:konigsberg | prussia | Königsberg | 5 |
| settlement:punjab:lahore | punjab | Lahore | 4 |
| settlement:rajpootana:udaipur | rajpootana | Udaipur | 1 |
| settlement:rhineland:koln | rhineland | Cologne | 1 |
| settlement:rumelia:constantinople | rumelia | Istanbul | 5 |
| settlement:ruperts_land:moose_factory | ruperts_land | Moose Factory | 1 |
| settlement:sardinia:caligari | sardinia | Cagliari | 1 |
| settlement:savoy:turin | savoy | Turin | 1 |
| settlement:saxony:dresden | saxony | Dresden | 4 |
| settlement:scotland:edinburgh | scotland | Edinburgh | 4 |
| settlement:serbia:belgrade | serbia | Belgrade | 1 |
| settlement:silesia:breslau | silesia | Breslau | 1 |
| settlement:sindh:neroon_kot | sindh | Neroon Kot | 1 |
| settlement:spain:madrid | spain | Madrid | 5 |
| settlement:sweden:stockholm | sweden | Stockholm | 5 |
| settlement:syria:damascus | syria | Damascus | 4 |
| settlement:tatariya:kazan | tatariya | Kazan | 1 |
| settlement:tejas:villa_de_bexar | tejas | Villa de Bexar | 1 |
| settlement:the_papal_states:rome | the_papal_states | Rome | 4 |
| settlement:transylvania:kolozsvar | transylvania | Klausenburg | 1 |
| settlement:trinidad_tobago:san_jose_de_oruna | trinidad_tobago | San José de Oruña | 1 |
| settlement:tripoli:tripoli | tripoli | Tripoli | 1 |
| settlement:tunis:tunis | tunis | Tunis | 4 |
| settlement:ukraine:kiev | ukraine | Kiev | 4 |
| settlement:upper_louisiana:fort_chartres | upper_louisiana | Fort de Chartres | 1 |
| settlement:venice:venice | venice | Venice | 5 |
| settlement:virginia:williamsburg | virginia | Williamsburg | 1 |
| settlement:west_pommerania:berlin | west_pommerania | Berlin | 4 |
| settlement:west_prussia:gdansk | west_prussia | Gdansk | 1 |
| settlement:windward_islands:martinique | windward_islands | Martinique | 1 |
| settlement:wurttemberg:stuttgart | wurttemberg | Stuttgart | 1 |
One interesting entry is "settlement:acadia:louisbourg_ep3", which is the name of the settlement for lesson (episode) 3 of the Road To Independence tutorial. In the regular campaign, the name of the same settlement is Fort Nashwaak.
campaign_map_towns_and_ports
This describes the small towns and ports for regions on the strategic map.
Buildings & their Effects
building_levels
This describes the buildings and improvements to them that can be built at a settlement.
building_effects_junction
This is a join table of buildings and their effects.
building_factionwide_effects_junction
This is a join table of buildings and the global effects they have faction-wide (instead of using a "global" flag in building_effects_junction).
building_units_allowed
This describes what units can be built at which buildings.
Factions & their Units
factions
This describes the major & minor factions.
units
This describes the available units. There are lots of statistics, this table is a subset.
unit_required_technology_junction
This is a join table describing which techs are required before being able to build certain units.
units_to_exclusive_faction_permissions
Despite the long-winded name, this just describes which factions can build which units.
Note that the "episodic" units are for the Road To Independence tutorial lessons (episodes).
--MikeV 7 April 2009
