ETW Data

From Totalwar.org
Revision as of 03:47, 8 April 2009 by MikeV (talk) (Buildings & their Effects: moved content to new page)
Jump to: navigation, search

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 Kahuna, 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

The tables in these files describe elements of the strategic map.

Buildings & their Effects

Factions & their Units

factions

This describes the major & minor factions.

factions
Faction ID Category Group Abrev. Type Nation Nationality
afghanistan sc_mideast_islamic mughal_group Pe minor Afghanistan Afghan
american_rebels sc_european_america usa_group Us rebel - Rebel
amerind_rebels sc_tribal_american amerinds_group Us_trib rebel - Rebel
austria sc_european_west austria_group Ge playable Austria Austrian
austrian_rebels sc_european_west austria_group Ge rebel - Rebel
barbary_rebels sc_mideast_islamic barbary_group Ar rebel - Rebel
barbary_states sc_mideast_islamic barbary_group Ar minor Barbary States Barbary
bavaria sc_european_west prussia_group Ge minor Bavaria Bavarian
britain sc_european_west great_britain_group Uk playable Great Britain British
british_rebels sc_european_west great_britain_group Uk rebel - Rebel
british_settler_rebels sc_european_america great_britain_group Uk rebel - Rebel
chechenya_dagestan sc_mideast_islamic russia_poland_group Pe non-expansionist Dagestan Dagestani
cherokee sc_tribal_american amerinds_group Us_trib minor Cherokee Nations Cherokee
colombia sc_european_america spain_group Sp minor Gran Colombia Gran Colombian
cossack_rebels sc_european_east russia_poland_group Ru rebel - Rebel
courland sc_european_north russia_poland_group Ru non-expansionist Courland Courlander
crimean_khanate sc_mideast_islamic russia_poland_group Ru minor Crimean Khanate Crimean
denmark sc_european_west sweden_denmark_group Ge minor Denmark Danish
dutch_rebels sc_european_west united_provinces_group Du rebel - Rebel
european_settler_rebels sc_european_america great_britain_group Uk rebel - Rebel
france sc_european_west france_group Fr playable France French
french_rebels sc_european_west france_group Fr rebel - Rebel
french_settler_rebels sc_european_america france_group Fr rebel - Rebel
genoa sc_european_south venice_group It minor Genoa Genoese
georgia sc_european_south russia_poland_group Ru non-expansionist Georgia Georgian
greece sc_european_south venice_group Tu non-expansionist Greece Greek
greek_rebels sc_european_south venice_group Tu rebel - Rebel
hannover sc_european_west prussia_group Ge non-expansionist Hannover Hannoverian
hessen sc_european_west prussia_group Ge non-expansionist Hessen Hessian
holstein_gottorp sc_european_north prussia_group Ge non-expansionist Schleswig-Holstein Schleswig
hungary sc_european_east austria_group Ge minor Hungary Hungarian
huron sc_tribal_american amerinds_group Us_trib minor Huron Confederacy Huron
india_settler_rebels sc_indian_hindu maratha_group Hi rebel - Rebel
inuit sc_tribal_american amerinds_group Us_trib non-expansionist Inuit Nations Inuit
ireland sc_european_west great_britain_group Uk non-expansionist Ireland Irish
iroquoi sc_tribal_american amerinds_group Us_trib minor Iroquois Confederacy Iroquois
italian_rebels sc_european_south venice_group It rebel - Rebel
khanate_khiva sc_mideast_islamic mughal_group Ru non-expansionist Khanate of Khiva Khivan
knights_stjohn sc_european_south venice_group It non-expansionist Knights of St John Hospitaller
louisiana sc_european_west france_group Us minor Louisiana Louisianan
mamelukes sc_mideast_islamic ottoman_group Ar minor Mamelukes Mameluk
maratha sc_indian_hindu maratha_group Hi playable Maratha Confederacy Maratha
maratha_rebels sc_indian_hindu maratha_group Hi rebel - Rebel
mecklenburg sc_european_north prussia_group Ge non-expansionist Mecklenburg Mecklenburger
mexico sc_european_america spain_group Sp non-expansionist México Mexican
middle_east_settler_rebels sc_mideast_islamic ottoman_group Tu rebel - Rebel
morocco sc_mideast_islamic barbary_group Ar minor Morocco Moroccan
mughal sc_indian_islamic mughal_group Pe playable Mughal Empire Mughal
mughal_rebels sc_indian_islamic mughal_group Pe rebel - Rebel
mysore sc_indian_islamic mughal_group Hi minor Mysore Mysorean
naples_sicily sc_european_south venice_group It non-expansionist Naples & Sicily Sicilian
netherlands sc_european_west united_provinces_group Du playable United Provinces Dutch
new_spain sc_european_south spain_group Sp minor New Spain New Spanish
norway sc_european_north sweden_denmark_group Ge minor Norway Norwegian
ottoman_rebels sc_mideast_islamic ottoman_group Tu rebel - Rebel
ottomans sc_mideast_islamic ottoman_group Tu playable Ottoman Empire Ottoman
papal_states sc_european_south venice_group It non-expansionist Italian States Papal
persian_rebels sc_mideast_islamic mughal_group Pe rebel - Rebel
piedmont_savoy sc_european_south venice_group Fr minor Savoy Savoyard
pirates sc_european_america barbary_group Uk minor Pirates Pirate
plains sc_tribal_american amerinds_group Us_trib minor Plains Nations Plains
poland_lithuania sc_european_east russia_poland_group Pl playable Poland-Lithuania Polish
portugal sc_european_south spain_group Po minor Portugal Portuguese
portugese_rebels sc_european_south spain_group Po rebel - Rebel
powhatan sc_tribal_american amerinds_group Us_trib minor Powhatan Confederacy Powhatan
prussia sc_european_north prussia_group Ge playable Prussia Prussian
prussian_rebels sc_european_north prussia_group Ge rebel - Rebel
pueblo sc_tribal_american amerinds_group Us_trib minor Pueblo Nations Pueblo
punjab sc_indian_sikh maratha_group Hi minor Punjab Punjabi
quebec sc_european_america france_group Fr minor Québec Québécois
russia sc_european_east russia_poland_group Ru playable Russia Russian
safavids sc_mideast_islamic mughal_group Ar minor Persia Persian
saxony sc_european_west prussia_group Ge minor Saxony Saxon
scandinavian_rebels sc_european_north sweden_denmark_group Sw rebel - Rebel
scotland sc_european_north great_britain_group Uk minor Scotland Scottish
sikh_rebels sc_indian_sikh mughal_group Hi rebel - Rebel
slavic_rebels sc_european_east russia_poland_group Ru rebel - Rebel
spain sc_european_south spain_group Sp playable Spain Spanish
spanish_rebels sc_european_south spain_group Sp rebel - Rebel
spanish_settler_rebels sc_european_america spain_group Sp rebel - Rebel
sweden sc_european_north sweden_denmark_group Sw playable Sweden Swedish
swiss_confederation sc_european_west prussia_group Ge non-expansionist Swiss Confederation Swiss
thirteen_colonies sc_european_west great_britain_group Us minor Thirteen Colonies Thirteen Colonies
tuscany sc_european_south venice_group It non-expansionist Tuscany Tuscan
united_states sc_european_america usa_group Us playable United States American
venice sc_european_south venice_group It minor Venice Venetian
virginia sc_european_west great_britain_group Us playable British Colonials British Colonial
virginia_colonists sc_european_west great_britain_group Uk playable Virginia Colonists Virginia Colony
westphalia sc_european_west austria_group Ge non-expansionist Westphalia Westphalian
wurttemberg sc_european_west austria_group Ge non-expansionist Württemberg Württemberger

units

This describes the available units. There are lots of statistics, this table is a subset.

units
Unit ID Screen Name Category Class # Turns Cost Upkeep
12_lber_howitzer 12-lber Howitzer Foot Artillery artillery artillery_foot 1 640 250
12_lber_howitzer_colonial Colonial 12-lber Howitzer Battery artillery artillery_foot 1 640 250
12_lber_land_cannon 12-lber Foot Artillery artillery artillery_foot 1 580 230
12_lber_land_cannon_colonial Marine 12-lber Artillery Independent Company artillery artillery_foot 1 580 230
12_lber_land_cannon_indian 12-lber Foot Artillery artillery artillery_foot 1 580 230
12_lber_ship_fort_cannon 12-lber Garrison Artillery artillery artillery_fixed 1 470 180
18_lber_land_cannon 18-lber Foot Artillery artillery artillery_foot 1 600 240
18_lber_land_cannon_east 18-lber Foot Artillery artillery artillery_foot 1 600 240
18_lber_land_cannon_guard_galloper 18-lber Horse Guard Artillery artillery artillery_horse 2 760 300
18_lber_land_cannon_indian 18-lber Foot Artillery artillery artillery_foot 1 600 240
18_lber_ship_fort_cannon 18-lber Garrison Artillery artillery artillery_fixed 1 500 200
1st_rate First Rate Ship of the Line naval_line_of_battle naval_first_rate 4 2460 410
1st_rate_admiral Admiral's Flagship, 1st Rate naval_line_of_battle naval_admiral 4 2760 460
1st_rate_admiral_american Admiral's Flagship, 1st Rate naval_line_of_battle naval_admiral 4 2840 470
1st_rate_admiral_british Admiral's Flagship, 1st Rate naval_line_of_battle naval_admiral 4 2850 470
1st_rate_admiral_french Admiral's Flagship, 1st Rate naval_line_of_battle naval_admiral 4 2700 450
1st_rate_admiral_russian Admiral's Flagship, 1st Rate naval_line_of_battle naval_admiral 4 2760 460
1st_rate_admiral_spanish Admiral's Flagship, 1st Rate naval_line_of_battle naval_admiral 4 2760 460
1st_rate_american First Rate Ship of the Line naval_line_of_battle naval_first_rate 4 2520 420
1st_rate_british First Rate Ship of the Line naval_line_of_battle naval_first_rate 4 2560 420
1st_rate_french First Rate Ship of the Line naval_line_of_battle naval_first_rate 4 2460 410
1st_rate_russian First Rate Ship of the Line naval_line_of_battle naval_first_rate 4 2460 410
1st_rate_spanish First Rate Ship of the Line naval_line_of_battle naval_first_rate 4 2440 400
24_lber_howitzer 24-lber Howitzer Foot Artillery artillery artillery_foot 2 680 270
24_lber_howitzer_ottoman 24-lber Howitzer Foot Artillery artillery artillery_foot 2 680 270
24_lber_land_cannon 24-lber Foot Artillery artillery artillery_foot 2 620 240
24_lber_land_cannon_(demi_cannon) Demi-Cannons artillery artillery_fixed 2 480 190
24_lber_land_cannon_(demi_cannon)_east Demi-Cannons artillery artillery_fixed 2 500 200
24_lber_land_cannon_(demi_cannon)_indian Cannons artillery artillery_fixed 2 500 200
24_lber_land_cannon_east 24-lber Foot Artillery artillery artillery_foot 2 620 240
24_lber_land_cannon_guard 24-lber Guard Artillery artillery artillery_foot 3 700 280
24_lber_land_cannon_indian 24-lber Foot Artillery artillery artillery_foot 2 620 240
24_lber_ship_fort_cannon 24-lber Garrison Artillery artillery artillery_fixed 2 520 200
2nd_rate Second Rate Ship of the Line naval_line_of_battle naval_second_rate 3 2040 340
2nd_rate_american Second Rate Ship of the Line naval_line_of_battle naval_second_rate 3 2090 340
2nd_rate_british Second Rate Ship of the Line naval_line_of_battle naval_second_rate 3 2120 350
2nd_rate_french Second Rate Ship of the Line naval_line_of_battle naval_second_rate 3 1990 330
2nd_rate_spanish Second Rate Ship of the Line naval_line_of_battle naval_second_rate 3 2040 340
3_lber_land_cannon_galloper 3-lber Horse Artillery artillery artillery_horse 1 590 230
3rd_rate Third Rate Ship of the Line naval_line_of_battle naval_third_rate 3 1760 290
3rd_rate_admiral Admiral's Flagship, 3rd Rate naval_line_of_battle naval_admiral 3 2060 340
3rd_rate_admiral_american Admiral's Flagship, 3rd Rate naval_line_of_battle naval_admiral 3 2080 340
3rd_rate_admiral_british Admiral's Flagship, 3rd Rate naval_line_of_battle naval_admiral 3 2110 350
3rd_rate_admiral_french Admiral's Flagship, 3rd Rate naval_line_of_battle naval_admiral 3 2030 330
3rd_rate_admiral_russian Admiral's Flagship, 3rd Rate naval_line_of_battle naval_admiral 3 2060 340
3rd_rate_admiral_spanish Admiral's Flagship, 3rd Rate naval_line_of_battle naval_admiral 3 2050 340
3rd_rate_american Third Rate Ship of the Line naval_line_of_battle naval_third_rate 3 1760 290
3rd_rate_british Third Rate Ship of the Line naval_line_of_battle naval_third_rate 3 1820 300
3rd_rate_french Third Rate Ship of the Line naval_line_of_battle naval_third_rate 3 1790 290
3rd_rate_russian Third Rate Ship of the Line naval_line_of_battle naval_third_rate 3 1760 290
3rd_rate_spanish Third Rate Ship of the Line naval_line_of_battle naval_third_rate 3 1750 290
4_inch_mortar 4-inch Mortar Battery artillery artillery_fixed 1 460 180
4_inch_mortar_indian Mortars artillery artillery_fixed 1 460 180
4th_rate Fourth Rate Ship of the Line naval_line_of_battle naval_fourth_rate 3 1370 220
4th_rate_american Fourth Rate Ship of the Line naval_line_of_battle naval_fourth_rate 3 1430 230
4th_rate_british Fourth Rate Ship of the Line naval_line_of_battle naval_fourth_rate 3 1440 240
4th_rate_french Fourth Rate Ship of the Line naval_line_of_battle naval_fourth_rate 3 1330 220
4th_rate_frigate_standard Fourth Rate Frigate naval_frigate naval_fourth_rate 3 1390 230
4th_rate_spanish Fourth Rate Ship of the Line naval_line_of_battle naval_fourth_rate 3 1390 230
5th_rate Fifth Rate naval_frigate naval_fifth_rate 2 1060 170
5th_rate_admiral Admiral's Flagship, 5th Rate naval_frigate naval_admiral 2 1360 220
5th_rate_admiral_american Admiral's Flagship, 5th Rate naval_frigate naval_admiral 2 1370 220
5th_rate_admiral_british Admiral's Flagship, 5th Rate naval_frigate naval_admiral 2 1380 230
5th_rate_admiral_french Admiral's Flagship, 5th Rate naval_frigate naval_admiral 2 1360 220
5th_rate_admiral_russian Admiral's Flagship, 5th Rate naval_frigate naval_admiral 2 1360 220
5th_rate_admiral_spanish Admiral's Flagship, 5th Rate naval_frigate naval_admiral 2 1350 220
5th_rate_american Fifth Rate naval_frigate naval_fifth_rate 2 1050 170
5th_rate_british Fifth Rate naval_frigate naval_fifth_rate 2 1090 180
5th_rate_french Fifth Rate naval_frigate naval_fifth_rate 2 1160 190
5th_rate_russian Fifth Rate naval_frigate naval_fifth_rate 2 1110 180
5th_rate_spanish Fifth Rate naval_frigate naval_fifth_rate 2 1050 170
6_lber_land_cannon_galloper 6-lber Horse Artillery artillery artillery_horse 1 620 240
64_lber_fort_carronade 64-lber Garrison Carronades artillery artillery_fixed 3 580 230
64_lber_land_cannon_elephant 64-lber Great Gun artillery artillery_fixed 3 460 180
64_lber_siege_cannon 64-lber Heavy Artillery artillery artillery_fixed 3 460 180
6th_rate Sixth Rate naval_frigate naval_sixth_rate 2 800 130
6th_rate_american Sixth Rate naval_frigate naval_sixth_rate 2 780 130
6th_rate_british Sixth Rate naval_frigate naval_sixth_rate 2 830 130
6th_rate_british_tutorial Sixth Rate naval_frigate naval_sixth_rate 2 3950 650
6th_rate_french Sixth Rate naval_frigate naval_sixth_rate 2 910 150
6th_rate_russian Sixth Rate naval_frigate naval_sixth_rate 2 800 130
6th_rate_spanish Sixth Rate naval_frigate naval_sixth_rate 2 790 130
8_inch_mortar 8-inch Mortar Battery artillery artillery_fixed 1 510 200
8_inch_mortar_east Bombardment Mortars artillery artillery_fixed 1 510 200
8_inch_mortar_indian Large Mortars artillery artillery_fixed 1 510 200
9_lber_land_cannon_(saker) Sakers artillery artillery_fixed 2 430 170
9_lber_land_cannon_(saker)_east 9-lber Artillery artillery artillery_fixed 2 430 170
9_lber_land_cannon_(saker)_indian Guns artillery artillery_fixed 2 430 170
african_slaver_musketeers African Musketeers infantry infantry_militia 1 520 200
african_tribal_spearmen African Spearmen infantry infantry_melee 1 340 130
american_heavy_frigate 24-pounder Frigate naval_frigate naval_razee 2 1570 260
americas_dragoons Dragoons dragoons dragoons 1 590 230
americas_hessian_infantry Hessian Line Infantry infantry infantry_line 1 650 260
americas_line_infantry Line Infantry infantry infantry_line 1 720 280
americas_long_rifle_men Long Rifle Men infantry infantry_irregulars 2 540 210
americas_militia_infantry Militia Infantry infantry infantry_militia 1 580 230
americas_provincial_cavalry Provincial Cavalry cavalry cavalry_standard 1 590 230
americas_regiment_of_horse Regiment of Horse cavalry cavalry_standard 1 630 250
armed_citizenry_africa Armed Populace infantry infantry_mob 0 0 0
armed_citizenry_bows_native_american Armed Tribesmen infantry infantry_mob 0 0 0
armed_citizenry_europe Armed Citizenry infantry infantry_mob 0 0 0
armed_citizenry_india Armed Populace infantry infantry_mob 0 0 0
armed_citizenry_matchlocks_africa Firelock Armed Populace infantry infantry_mob 0 0 0
armed_citizenry_matchlocks_europe Firelock Armed Citizenry infantry infantry_mob 0 0 0
armed_citizenry_matchlocks_india Firelock Armed Populace infantry infantry_mob 0 0 0
armed_citizenry_matchlocks_middle_east Firelock Armed Populace infantry infantry_mob 0 0 0
armed_citizenry_middle_east Armed Populace infantry infantry_mob 0 0 0
armed_citizenry_native_american Armed Tribesmen infantry infantry_mob 0 0 0
armed_citizenry_pirates Pirate Mob infantry infantry_mob 0 0 0
armed_peasantry Armed Peasantry infantry infantry_mob 1 260 100
armed_peasantry_bhumiya Bhumiya Bowmen infantry infantry_mob 1 380 150
armed_peasantry_semenys Semenys infantry infantry_mob 1 260 100
armed_peasantry_tufangis Tufangis infantry infantry_mob 1 260 100
azzars Azzars infantry infantry_irregulars 1 370 140
barbary_xebec Xebec naval_frigate naval_xebec 2 840 140
bashibazouks Bashi-Bazouks infantry infantry_irregulars 1 340 130
bomb_ketch Bomb Ketch naval_specialist naval_bomb_ketch 1 620 100
bomb_ketch_american Bomb Ketch naval_specialist naval_bomb_ketch 1 620 100
bomb_ketch_british Bomb Ketch naval_specialist naval_bomb_ketch 1 660 110
bomb_ketch_french Bomb Ketch naval_specialist naval_bomb_ketch 1 680 110
bomb_ketch_spanish Bomb Ketch naval_specialist naval_bomb_ketch 1 620 100
brig Brig naval_auxiliary naval_brig 1 480 80
brig_american Brig naval_auxiliary naval_brig 1 460 70
brig_british Brig naval_auxiliary naval_brig 1 490 80
brig_french Brig naval_auxiliary naval_brig 1 530 80
brig_spanish Brig naval_auxiliary naval_brig 1 470 70
carronade_frigate Carronade Frigate naval_frigate naval_sixth_rate 2 920 150
carronade_frigate_american Carronade Frigate naval_frigate naval_sixth_rate 2 890 140
carronade_frigate_british Carronade Frigate naval_frigate naval_sixth_rate 2 950 150
carronade_frigate_french Carronade Frigate naval_frigate naval_sixth_rate 2 1020 170
carronade_frigate_spanish Carronade Frigate naval_frigate naval_sixth_rate 2 890 140
cazadores Cazadores infantry infantry_skirmishers 1 430 170
cossack_cavalry Cossacks cavalry cavalry_light 1 670 260
cossack_cavalry_hetman Cossack Ataman Cavalry cavalry cavalry_light 1 710 280
cossack_infantry Cossack Infantry infantry infantry_line 1 620 240
deli_scouts Deli Horsemen cavalry cavalry_irregular 1 620 240
desert_warriors Desert Warriors infantry infantry_militia 1 530 210
dhow Dhow (Trade Ship) naval_merchant naval_dhow 2 480 80
east_camel_gunners Shaturnal Camel Gunners cavalry cavalry_missile 1 510 200
east_desert_nomad_camelry Camel Nomads cavalry cavalry_camels 1 610 240
east_desert_nomads Nomads infantry infantry_militia 1 530 210
east_ethnic_hillmen_musketeers Hillmen infantry infantry_skirmishers 1 370 140
east_ethnic_hillmen_musketeers_afghan Afghan Hillmen infantry infantry_skirmishers 1 390 150
east_ethnic_hillmen_musketeers_kurdish Kurdish Hillmen infantry infantry_skirmishers 1 390 150
east_ethnic_musketeers_bargir Bargir Infantry infantry infantry_line 1 720 280
east_ethnic_musketmen Musketmen infantry infantry_line 1 670 260
east_ethnic_musketmen_fellahin_musketeers Fellahin Musketeers infantry infantry_militia 1 600 240
east_ethnic_musketmen_hindu_musketeers Hindu Musketeers infantry infantry_line 1 630 250
east_ethnic_musketmen_isarelys Isarelys infantry infantry_line 1 660 260
east_ethnic_musketmen_mughal_musketeers Qizilbashi Musketeers infantry infantry_line 1 640 250
east_ethnic_peasants_firelocks Firelock Peasantry infantry infantry_mob 1 470 180
east_ethnic_peasants_fodder Peasants infantry infantry_mob 1 280 110
east_ethnic_swordsmen Swordsmen infantry infantry_melee 1 580 230
east_ethnic_swordsmen_fellahin Fellahin infantry infantry_melee 1 570 220
east_ethnic_swordsmen_hindu_warriors Hindu Warriors infantry infantry_melee 1 510 200
east_ethnic_swordsmen_islamic_swordsmen Islamic Swordsmen infantry infantry_melee 1 570 220
east_ethnic_warriors Sword Warriors infantry infantry_melee 1 520 200
east_ethnic_warriors_barbary_pirates Barbary Pirates infantry infantry_melee 1 410 160
east_ethnic_warriors_dervishes Dervishes infantry infantry_melee 1 500 200
east_generals_bodyguard General's Bodyguard cavalry general 1 1270 150
east_grenade_launchers Janissary Hand Mortar Bölük infantry infantry_grenadiers 2 470 180
east_guard_cavalry_ahadis Ahadis cavalry cavalry_heavy 2 780 310
east_irregular_cavalry_pindari Pindari Horsemen cavalry cavalry_irregular 1 650 260
east_lancers Native Lancers cavalry cavalry_lancers 1 620 240
east_lancers_bargir Bargir Lancers cavalry cavalry_lancers 1 700 280
east_lancers_silladar Silladar Lancers cavalry cavalry_lancers 1 630 250
east_light_cavalry_qizilbashi Qizilbashi Cavalry cavalry cavalry_light 1 660 260
east_missile_cavalry_zamindari Zamindari Horsemen cavalry cavalry_missile 1 550 220
east_pikemen_zamindari Zamindari Pikemen infantry infantry_melee 1 450 180
east_sikh_infantry_musketeers Sikh Musketeers infantry infantry_line 1 780 310
east_sikh_warriors Sikh Warriors infantry infantry_melee 1 490 190
east_sipahi_cavalry Sipahis cavalry cavalry_heavy 1 740 290
east_sipahi_cavalry_colonial Native Indian Cavalry cavalry cavalry_standard 1 710 280
east_war_elephant_lancers_howdah War Elephants elephants elephants 3 1030 410
east_war_elephant_musketry_howdah Elephant Musketeers elephants elephants 3 1040 410
episodic_1_arquebusiers Colonial Militia infantry infantry_militia 1 560 60
episodic_1_native_american_archers Powhatan Bowmen infantry infantry_skirmishers 1 250 100
episodic_1_native_american_warriors Powhatan Warriors infantry infantry_melee 1 160 60
episodic_1_settlers Jamestown Settlers infantry infantry_militia 1 580 60
episodic_2_24_lber_land_cannon 24-lber Foot Artillery artillery artillery_foot 2 600 240
episodic_2_5th_rate Fifth Rate naval_frigate naval_fifth_rate 2 1060 170
episodic_2_armed_citizenry_matchlocks_natam Firelock Armed Tribesmen infantry infantry_mob 0 0 0
episodic_2_brig Brig naval_auxiliary naval_brig 1 480 80
episodic_2_colonial_militia Colonial Militia infantry infantry_skirmishers 1 510 200
episodic_2_french_marines Marines infantry infantry_line 1 600 240
episodic_2_light_cavalry_colonial Colonial Light Cavalry cavalry cavalry_light 1 400 160
episodic_2_line_infantry Line Infantry infantry infantry_line 1 710 280
episodic_2_natam_musketeers Native Musketeers infantry infantry_irregulars 1 520 200
episodic_2_native_american_musketeer_auxiliary Native American Musketeers infantry infantry_irregulars 1 520 200
episodic_2_rangers Rangers infantry infantry_skirmishers 1 430 170
episodic_2_sloop Sloop naval_auxiliary naval_sloop 1 260 60
episodic_arquebusiers Arquebusiers infantry infantry_militia 1 540 210
episodic_demi_cannon Board of Ordnance 24-lber Battery artillery artillery_fixed 1 860 340
episodic_john_smith John Smith's Band infantry infantry_militia 1 680 80
episodic_mounted_native_general Chief Cheeseekau cavalry general 1 530 210
episodic_musketeers Militia Musketeers infantry infantry_militia 1 1030 410
episodic_musketeers_vulnerable Militia Musketeers infantry infantry_militia 1 1100 440
episodic_native_american_archers Powhatan Warriors infantry infantry_skirmishers 1 940 370
episodic_native_american_archers_rubbish Powhatan Warriors infantry infantry_skirmishers 1 840 330
episodic_pikemen Militia Pikemen infantry infantry_melee 1 440 170
episodic_sakers Board of Ordnance 9-lber Battery artillery artillery_fixed 1 530 210
episodic_wahunsonacock Wahunsonacock's Warrior Band infantry infantry_melee 1 310 120
episodic_washington_old_infantry George Washington infantry infantry_line 1 150 60
episodic_washingtons_bodyguard_old General Washington's Staff cavalry general 1 1240 490
episodic_washingtons_bodyguard_young General Washington's Staff cavalry general 1 1270 500
episodics_armed_citizenry_europe Armed Citizenry infantry infantry_mob 0 0 0
episodics_armed_citizenry_matchlocks_europe Firelock Armed Citizenry infantry infantry_mob 0 0 0
episodics_armed_citizenry_native_american Armed Tribesmen infantry infantry_mob 0 0 0
euro_african_infantry African Native Infantry infantry infantry_line 1 580 230
euro_carabiniers Carabineers cavalry cavalry_missile 1 590 230
euro_company_cavalry Company Cavalry cavalry cavalry_standard 1 640 250
euro_company_cavalry_e_india_co East India Company Cavalry cavalry cavalry_standard 1 640 250
euro_company_cavalry_french_eic French East India Co. Cavalry cavalry cavalry_standard 1 640 250
euro_company_cavalry_voc V.O.C. Cavalry cavalry cavalry_standard 1 640 250
euro_company_infantry Company Infantry infantry infantry_line 1 700 280
euro_company_infantry_e_india_co East India Company Infantry infantry infantry_line 1 700 280
euro_company_infantry_french_eic French East India Co. Infantry infantry infantry_line 1 700 280
euro_company_infantry_voc_infantry V.O.C. Infantry infantry infantry_line 1 700 280
euro_cuirassiers Cuirassiers cavalry cavalry_heavy 1 750 300
euro_cuirassiers_austria Cuirassiers cavalry cavalry_heavy 1 750 300
euro_cuirassiers_france Cuirassiers cavalry cavalry_heavy 1 750 300
euro_dragoons Dragoons dragoons dragoons 1 570 220
euro_dragoons_austria Dragoons dragoons dragoons 1 570 220
euro_dragoons_colonial Colonial Dragoons dragoons dragoons 1 570 220
euro_dragoons_small Dragoons dragoons dragoons 1 570 220
euro_dragoons_sweden Dragoons dragoons dragoons 1 570 220
euro_elite_light_infantry Riflemen infantry infantry_light 2 500 200
euro_elite_light_infantry_croatian_grenzers Grenzers infantry infantry_light 2 560 220
euro_elite_light_infantry_green_jackets Green Jackets infantry infantry_light 2 510 200
euro_elite_light_infantry_prussian_jaegers Prussian Jaegers infantry infantry_light 1 500 200
euro_elite_light_infantry_tirailleurs Tirailleurs infantry infantry_light 2 500 200
euro_elite_light_infantry_windbuchse_jaegers Windbüchse Jaegers infantry infantry_light 2 680 270
euro_expat_infantry Expatriate Infantry infantry infantry_line 1 680 270
euro_expat_infantry_chasseurs_britannique Chasseurs Britanniques infantry infantry_light 1 460 180
euro_expat_infantry_irish_brigade Irish Brigade infantry infantry_line 1 710 280
euro_expat_infantry_regiments_etrangeres Régiments Étrangers infantry infantry_line 1 690 270
euro_generals_bodyguard General's Bodyguard cavalry general 1 1260 150
euro_grenade_launchers Hand Mortar Company infantry infantry_grenadiers 2 490 190
euro_grenadiers Grenadiers infantry infantry_grenadiers 1 550 220
euro_grenadiers_bearskin Grenadiers infantry infantry_grenadiers 1 550 220
euro_heavy_cavalry Heavy Cavalry cavalry cavalry_heavy 1 710 280
euro_heavy_cavalry_austria Heavy Cavalry cavalry cavalry_heavy 1 710 280
euro_heavy_cavalry_france Heavy Cavalry cavalry cavalry_heavy 1 710 280
euro_heavy_cavalry_sweden Heavy Cavalry cavalry cavalry_heavy 1 710 280
euro_highlanders Highland Infantry infantry infantry_elite 1 870 340
euro_highlanders_royal_ecossois Royal Ecossais infantry infantry_elite 1 870 340
euro_highlanders_scots Scots infantry infantry_elite 1 870 340
euro_hussars Hussars cavalry cavalry_light 1 630 250
euro_hussars_france Hussars cavalry cavalry_light 1 630 250
euro_hussars_hungarian_hussars Hungarian Hussars cavalry cavalry_light 1 630 250
euro_lancers Lancers cavalry cavalry_lancers 1 650 260
euro_lancers_chevau_legers Chevaux-légers cavalry cavalry_lancers 1 650 260
euro_lancers_east_india_company_lancers East India Company Lancers cavalry cavalry_lancers 1 650 260
euro_lancers_uhlans Uhlans cavalry cavalry_lancers 1 670 260
euro_lancers_uhlans_austria Uhlans cavalry cavalry_lancers 1 660 260
euro_late_riflemen Riflemen infantry infantry_light 2 530 210
euro_light_cavalry Light Cavalry cavalry cavalry_light 1 630 250
euro_light_cavalry_chasseurs_a_cheval Chasseurs à Cheval cavalry cavalry_missile 1 550 220
euro_light_cavalry_colonial Colonial Light Cavalry cavalry cavalry_light 1 630 250
euro_light_dragoons Light Dragoons dragoons dragoons 1 630 250
euro_light_dragoons_austria Light Dragoons dragoons dragoons 1 630 250
euro_light_dragoons_sweden Light Dragoons dragoons dragoons 1 630 250
euro_light_infantry Light Infantry infantry infantry_light 1 450 180
euro_light_infantry_barbets Barbets infantry infantry_irregulars 1 390 150
euro_light_infantry_chasseur_a_pied Chasseurs à Pied infantry infantry_light 1 450 180
euro_light_infantry_colonial Colonial Light Infantry infantry infantry_light 1 450 180
euro_light_infantry_jaegers Jaegers infantry infantry_light 1 460 180
euro_light_infantry_miquelets Miquelets infantry infantry_irregulars 1 380 150
euro_line_infantry Line Infantry infantry infantry_line 1 720 280
euro_line_infantry_austria Line Infantry infantry infantry_line 1 790 310
euro_line_infantry_britain Line Infantry infantry infantry_line 1 750 300
euro_line_infantry_colonial Colonial Line Infantry infantry infantry_line 1 700 280
euro_line_infantry_denmark Line Infantry infantry infantry_line 1 720 280
euro_line_infantry_france Line Infantry infantry infantry_line 1 740 290
euro_line_infantry_holland Line Infantry infantry infantry_line 1 720 280
euro_line_infantry_invalids Invalid Garrison Regiment infantry infantry_line 1 720 280
euro_line_infantry_poland Line Infantry infantry infantry_line 1 720 280
euro_line_infantry_prussia Line Infantry infantry infantry_line 1 750 300
euro_line_infantry_russia Line Infantry infantry infantry_line 1 700 280
euro_line_infantry_spain Line Infantry infantry infantry_line 1 720 280
euro_line_infantry_sweden Line Infantry infantry infantry_line 1 720 280
euro_line_infantry_venice Line Infantry infantry infantry_line 1 720 280
euro_militia_infantry Militia infantry infantry_militia 1 590 230
euro_militia_infantry_colonial_militia Colonial Militia infantry infantry_militia 1 580 230
euro_militia_infantry_colonial_tutorial_rubbish Colonial Militia infantry infantry_militia 1 530 210
euro_militia_infantry_minutemen Minutemen infantry infantry_militia 1 580 230
euro_militia_infantry_provincial_infantry Provincial Militia infantry infantry_militia 1 580 230
euro_pikemen Pikemen infantry infantry_melee 1 480 190
euro_pikemen_austria Pikemen infantry infantry_melee 1 520 200
euro_pikemen_colonial Colonial Pikemen infantry infantry_melee 1 480 190
euro_pikemen_prussian Pikemen infantry infantry_melee 1 500 200
euro_polish_winged_hussars Winged Hussars cavalry cavalry_heavy 2 840 330
euro_provincial_cavalry Provincial Cavalry cavalry cavalry_standard 1 590 230
euro_provincial_cavalry_gendarmerie Gendarmerie cavalry cavalry_standard 1 590 230
euro_provincial_cavalry_yeomanry Yeomanry cavalry cavalry_standard 1 590 230
euro_provincial_line_infantry Provincial Line Infantry infantry infantry_line 1 640 250
euro_rangers Rangers infantry infantry_skirmishers 1 450 180
euro_rangers_courers_de_bois Coureurs de Bois infantry infantry_skirmishers 1 450 180
euro_rangers_frontiersmen Frontiersmen infantry infantry_skirmishers 1 450 180
euro_rangers_siberian_hunters Siberian Hunters infantry infantry_skirmishers 1 460 180
euro_regiment_of_horse Regiment of Horse cavalry cavalry_standard 1 630 250
euro_regiment_of_horse_sweden Regiment of Horse cavalry cavalry_standard 1 630 250
euro_republican_conscript_infantry Conscripts infantry infantry_militia 1 530 210
euro_republican_guard Republican Guard infantry infantry_elite 2 890 350
euro_sepoys Sepoys infantry infantry_line 1 610 240
euro_superior_line_infantry Superior Line Infantry infantry infantry_elite 2 850 340
euro_superior_line_infantry_blackwatch The Black Watch infantry infantry_elite 2 880 350
euro_superior_line_infantry_coldstream Coldstream Guards infantry infantry_elite 2 880 350
euro_superior_line_infantry_petits_vieux Infanterie Petit-Vieux infantry infantry_elite 2 790 310
euro_superior_line_infantry_vieux Infanterie Vieux infantry infantry_elite 2 850 340
ferguson_riflemen Ferguson Riflemen infantry infantry_light 2 630 250
galleon Galleon naval_line_of_battle naval_galleon 3 1410 230
galleon_fluyt Fluyt naval_line_of_battle naval_galleon 2 870 140
galleon_race_built Race-Built Galleon naval_line_of_battle naval_galleon 2 490 80
garde_du_corps Garde du Corps cavalry cavalry_heavy 2 770 300
gorodskiye_streltsy Gorodskiye Streltsy infantry infantry_militia 1 390 150
guard_infantry Guards infantry infantry_elite 2 890 350
guerillas Guerillas infantry infantry_irregulars 1 390 150
hakkapeliitat Hakkapeliita cavalry cavalry_light 1 700 280
highland_clansmen Clansmen infantry infantry_melee 1 450 180
hms_shannon Sixth Rate naval_frigate naval_sixth_rate 2 1090 180
horse_grenadier_guards Horse Grenadier Guards dragoons dragoons 2 640 250
household_cavalry Household Cavalry cavalry cavalry_heavy 2 770 300
indiaman Indiaman (Trade Ship) naval_merchant naval_indiaman 2 800 130
indian_generals_bodyguard General's Bodyguard elephants general 1 1340 160
janissaries_beylik Beylik Janissaries infantry infantry_melee 1 550 220
janissaries_beylik_grenadiers Beylik Janissary Grenadiers infantry infantry_grenadiers 2 510 200
janissaries_beylik_musketeers Beylik Janissary Musketeers infantry infantry_elite 1 780 310
janissaries_cemaat Cemaat Janissaries infantry infantry_melee 1 440 170
janissaries_cemaat_grenadiers Cemaat Janissary Grenadiers infantry infantry_grenadiers 2 470 180
janissaries_sekban Sekban Janissaries infantry infantry_melee 1 440 170
landless_rabble Landless Rabble infantry infantry_mob 1 280 110
landless_rabble_bhumiya Bhumiya Levy infantry infantry_mob 1 280 110
life_guards Life Guards cavalry cavalry_heavy 2 770 300
light_galley/galliot/fusta Light Galley naval_galley naval_light_galley 1 240 40
lugger Civilian Lugger naval_merchant naval_lugger 2 440 70
maison_du_roi Maison du Roi infantry infantry_elite 2 890 350
mameluks Mamelukes cavalry cavalry_light 1 640 250
maroon_rebels Maroon Rebel Insurgents infantry infantry_melee 1 340 130
medium_galley Galley naval_galley naval_medium_galley 1 540 90
musellims Musellims infantry infantry_mob 1 280 110
native_american_archers Bowmen infantry infantry_skirmishers 1 220 150
native_american_archers_auxiliary Native Bowmen Auxiliary infantry infantry_skirmishers 1 570 220
native_american_artillery Native Artillery artillery artillery_fixed 2 160 110
native_american_elite Warrior Society infantry infantry_elite 2 240 160
native_american_generals_bodyguard Chief's Bodyguard cavalry general 1 550 60
native_american_medicine_men Medicine Men infantry infantry_elite 2 200 140
native_american_mounted_lancers Native American Lancers cavalry cavalry_lancers 1 250 170
native_american_mounted_musketeers Mounted Tribal Gunners cavalry cavalry_missile 1 200 140
native_american_mounted_musketeers_auxiliary Mounted Tribal Auxiliary cavalry cavalry_missile 1 520 200
native_american_musketeers Musketmen infantry infantry_irregulars 1 150 100
native_american_musketeers_auxiliary Native Musketmen Auxiliary infantry infantry_irregulars 1 390 150
native_american_tribesmen Native American Tribesmen infantry infantry_militia 1 120 80
native_american_tribesmen_auxiliary Native Tribesmen Auxiliary infantry infantry_militia 1 570 220
native_american_warriors Native American Warriors infantry infantry_melee 1 140 90
native_american_warriors_auxiliary Native Warrior Auxiliary infantry infantry_melee 1 330 130
nizam_I_cedit_infantry Nizam-I Cedit Infantry infantry infantry_line 1 740 290
nizam_I_cedit_light_infantry Nizam-I Cedit Light Infantry infantry infantry_light 1 460 180
nizam_I_cedit_rifles Nizam-I Cedit Rifles infantry infantry_light 2 510 200
norwegian_ski_troops Mountain Troops infantry infantry_skirmishers 1 430 170
ottoman_generals_bodyguard General's Bodyguard cavalry general 1 1260 150
ottoman_great_cannon Great Cannon artillery artillery_fixed 3 1030 410
ottoman_medium_galley Galley naval_galley naval_medium_galley 1 550 90
over_1st_rate Heavy First Rate naval_line_of_battle naval_over_first_rate 4 3150 520
over_1st_rate_american Heavy First Rate naval_line_of_battle naval_over_first_rate 4 3210 530
over_1st_rate_british Heavy First Rate naval_line_of_battle naval_over_first_rate 4 3230 530
over_1st_rate_french Heavy First Rate naval_line_of_battle naval_over_first_rate 4 3100 510
over_1st_rate_russian Heavy First Rate naval_line_of_battle naval_over_first_rate 4 3130 520
over_1st_rate_spanish Heavy First Rate naval_line_of_battle naval_over_first_rate 4 3150 520
pandours Pandours infantry infantry_irregulars 1 400 160
pirates Buccaneers infantry infantry_melee 1 460 180
pr_custom_pistol_unit Laurence is a pest infantry infantry_line 0 130 50
pr_custom_sword_unit Tully Must Die infantry infantry_melee 0 140 50
puckle_gun Puckle Guns artillery artillery_foot 1 680 270
rapparees Rapparees infantry infantry_irregulars 1 350 140
razee Razee naval_frigate naval_razee 2 1510 250
razee_british Razee naval_frigate naval_razee 2 1550 250
regiment_horse_light P/H Light Horse cavalry cavalry_light 1 630 250
revolutionary_guard Revolutionary Guard infantry infantry_elite 2 820 320
revolutionary_infantry Volunteer Revolutionary Infantry infantry infantry_militia 1 540 210
riskers_of_souls Riskers of Souls infantry infantry_berserker 1 470 180
rocket_ship Rocket Ship naval_specialist naval_rocket_ship 1 1020 170
rocket_ship_american Rocket Ship naval_specialist naval_rocket_ship 1 1020 170
rocket_ship_british Rocket Ship naval_specialist naval_rocket_ship 1 1080 180
rocket_ship_french Rocket Ship naval_specialist naval_rocket_ship 1 1060 170
rocket_ship_spanish Rocket Ship naval_specialist naval_rocket_ship 1 1020 170
rockets_camel Rocket Band artillery artillery_fixed 1 760 300
rockets_fixed Rocket Troop artillery artillery_fixed 1 760 300
sikh_musketeers Sikh Musketeers infantry infantry_line 1 630 250
sikh_warriors Sikh Warriors infantry infantry_melee 1 720 280
sloop Sloop naval_auxiliary naval_sloop 1 360 60
sloop_american Sloop naval_auxiliary naval_sloop 1 340 50
sloop_british Sloop naval_auxiliary naval_sloop 1 370 60
sloop_french Sloop naval_auxiliary naval_sloop 1 410 60
sloop_spanish Sloop naval_auxiliary naval_sloop 1 350 50
sp_ed_constitution USS Constitution naval_frigate naval_razee 0 2010 330
sp_ed_constitution_admiral USS Constitution naval_frigate naval_razee 0 2010 330
sp_ed_dahomey_amazon Dahomey Amazons infantry infantry_militia 1 620 240
sp_ed_deaths_head_hussar Deaths Head Hussars cavalry cavalry_standard 1 710 280
sp_ed_ghoorkas Ghoorkas infantry infantry_melee 1 650 260
sp_ed_guerillas 'Corso Terrestre' Guerillas infantry infantry_irregulars 1 440 170
sp_ed_hms_victory HMS Victory naval_line_of_battle naval_over_first_rate 4 2950 490
sp_ed_hms_victory_admiral HMS Victory naval_line_of_battle naval_admiral 4 2950 490
sp_ed_organ_gun Organ Gun artillery artillery_fixed 3 950 380
sp_ed_rogers_rangers Rogers' Rangers infantry infantry_skirmishers 1 490 190
sp_ed_wild_geese Bulkeley's Regiment infantry infantry_line 1 740 290
steam_ship Steamship naval_frigate naval_steam_ship 2 1420 230
steam_ship_american Steamship naval_frigate naval_steam_ship 2 1390 230
steam_ship_british Steamship naval_frigate naval_steam_ship 2 1470 240
steam_ship_french Steamship naval_frigate naval_steam_ship 2 1570 260
steam_ship_spanish Steamship naval_frigate naval_steam_ship 2 1430 230
steppe_cavalry Steppe Cavalry cavalry cavalry_missile 1 580 230
steppe_cavalry_kalmuks Kalmuks cavalry cavalry_missile 1 580 230
steppe_cavalry_tatars_crimean Tatars cavalry cavalry_missile 1 580 230
steppe_cavalry_tatars_ottoman Tatars cavalry cavalry_missile 1 580 230
uss_chesapeake Sixth Rate naval_frigate naval_sixth_rate 2 1040 170
viborniye_streltsy Viborniye Streltsy cavalry cavalry_standard 1 600 240
voltigeur Voltigeurs infantry infantry_light 1 460 180
xebec Xebec naval_frigate naval_xebec 2 900 150
z_andy_test Voltigeurs artillery artillery_fixed 1 480 160

unit_required_technology_junction

This is a join table describing which techs are required before being able to build certain units.

unit_required_technology_junction
Unit IDRef Technology IDRef
4_inch_mortar military_ordnance_explosive_shells
4_inch_mortar_indian military_ordnance_explosive_shells
8_inch_mortar military_ordnance_explosive_shells
8_inch_mortar_east military_ordnance_explosive_shells
8_inch_mortar_indian military_ordnance_explosive_shells
americas_dragoons military_army_carbines
bomb_ketch military_ordnance_explosive_shells
bomb_ketch_american military_ordnance_explosive_shells
bomb_ketch_british military_ordnance_explosive_shells
bomb_ketch_french military_ordnance_explosive_shells
bomb_ketch_spanish military_ordnance_explosive_shells
carronade_frigate military_navy_carronades
carronade_frigate_american military_navy_carronades
carronade_frigate_british military_navy_carronades
carronade_frigate_french military_navy_carronades
carronade_frigate_spanish military_navy_carronades
cazadores military_army_machined_rifling
cossack_cavalry military_army_carbines
deli_scouts military_army_carbines
east_irregular_cavalry_pindari military_army_carbines
east_light_cavalry_qizilbashi military_army_carbines
euro_carabiniers military_army_carbines
euro_dragoons military_army_carbines
euro_dragoons_austria military_army_carbines
euro_dragoons_colonial military_army_carbines
euro_dragoons_small military_army_carbines
euro_dragoons_sweden military_army_carbines
euro_elite_light_infantry military_army_machined_rifling
euro_elite_light_infantry_croatian_grenzers military_army_machined_rifling
euro_elite_light_infantry_green_jackets military_army_machined_rifling
euro_elite_light_infantry_prussian_jaegers military_army_machined_rifling
euro_elite_light_infantry_tirailleurs military_army_machined_rifling
euro_elite_light_infantry_windbuchse_jaegers military_army_airguns
euro_expat_infantry_chasseurs_britannique military_army_light_infantry_doctrine
euro_late_riflemen military_army_machined_rifling
euro_light_cavalry_chasseurs_a_cheval military_army_carbines
euro_light_dragoons military_army_carbines
euro_light_dragoons_austria military_army_carbines
euro_light_dragoons_sweden military_army_carbines
euro_light_infantry military_army_light_infantry_doctrine
euro_light_infantry_chasseur_a_pied military_army_light_infantry_doctrine
euro_light_infantry_colonial military_army_light_infantry_doctrine
euro_light_infantry_jaegers military_army_light_infantry_doctrine
ferguson_riflemen military_army_screw_breach
nizam_I_cedit_infantry military_army_european_doctrine
nizam_I_cedit_light_infantry military_army_european_doctrine
nizam_I_cedit_rifles military_army_european_doctrine
nizam_I_cedit_rifles military_army_machined_rifling
rocket_ship military_ordnance_explosive_rockets
rocket_ship_american military_ordnance_explosive_rockets
rocket_ship_british military_ordnance_explosive_rockets
rocket_ship_french military_ordnance_explosive_rockets
rocket_ship_spanish military_ordnance_explosive_rockets
rockets_camel military_ordnance_explosive_rockets
rockets_fixed military_ordnance_explosive_rockets

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).

units_to_exclusive_faction_permissions
Unit IDRef Faction IDRef
1st_rate britain
1st_rate france
1st_rate russia
1st_rate spain
1st_rate united_states
1st_rate_admiral britain
1st_rate_admiral france
1st_rate_admiral russia
1st_rate_admiral spain
1st_rate_admiral united_states
1st_rate_admiral_american united_states
1st_rate_admiral_british britain
1st_rate_admiral_french france
1st_rate_admiral_russian russia
1st_rate_admiral_spanish spain
1st_rate_american united_states
1st_rate_british britain
1st_rate_french france
1st_rate_spanish spain
2nd_rate britain
2nd_rate france
2nd_rate spain
2nd_rate united_states
2nd_rate_american united_states
2nd_rate_british britain
2nd_rate_french france
2nd_rate_spanish spain
3rd_rate britain
3rd_rate france
3rd_rate russia
galleon_fluyt netherlands
3rd_rate spain
3rd_rate united_states
3rd_rate_admiral britain
3rd_rate_admiral france
3rd_rate_admiral russia
3rd_rate_admiral spain
3rd_rate_admiral united_states
3rd_rate_admiral_american united_states
3rd_rate_admiral_british britain
3rd_rate_admiral_french france
3rd_rate_admiral_russian russia
3rd_rate_admiral_spanish spain
3rd_rate_american united_states
3rd_rate_british britain
3rd_rate_french france
3rd_rate_russian russia
3rd_rate_spanish spain
4th_rate britain
4th_rate france
4th_rate spain
4th_rate united_states
4th_rate_american united_states
4th_rate_british britain
4th_rate_french france
4th_rate_spanish spain
5th_rate britain
5th_rate france
5th_rate russia
5th_rate spain
5th_rate united_states
5th_rate_admiral britain
5th_rate_admiral france
5th_rate_admiral russia
5th_rate_admiral spain
5th_rate_admiral united_states
5th_rate_admiral_american united_states
5th_rate_admiral_british britain
5th_rate_admiral_french france
5th_rate_admiral_russian russia
5th_rate_admiral_spanish spain
5th_rate_american united_states
5th_rate_british britain
5th_rate_french france
5th_rate_russian russia
5th_rate_spanish spain
6th_rate britain
6th_rate france
6th_rate spain
6th_rate united_states
6th_rate_american united_states
6th_rate_british britain
6th_rate_french france
6th_rate_russian russia
6th_rate_spanish spain
american_heavy_frigate united_states
armed_citizenry_pirates pirates
barbary_xebec barbary_rebels
barbary_xebec pirates
bomb_ketch britain
bomb_ketch france
bomb_ketch spain
bomb_ketch_american united_states
bomb_ketch_british britain
bomb_ketch_french france
bomb_ketch_spanish spain
brig britain
brig france
brig pirates
brig spain
brig united_states
brig_american united_states
brig_british britain
brig_french france
brig_spanish spain
carronade_frigate britain
carronade_frigate france
carronade_frigate spain
carronade_frigate united_states
carronade_frigate_american united_states
carronade_frigate_british britain
carronade_frigate_french france
carronade_frigate_spanish spain
cossack_cavalry poland_lithuania
cossack_cavalry_hetman poland_lithuania
cossack_infantry poland_lithuania
east_grenade_launchers ottomans
episodic_1_arquebusiers virginia_colonists
episodic_1_native_american_archers powhatan
episodic_1_native_american_warriors powhatan
episodic_1_settlers virginia_colonists
episodic_2_24_lber_land_cannon britain
episodic_2_24_lber_land_cannon france
episodic_2_24_lber_land_cannon virginia
episodic_2_5th_rate britain
episodic_2_5th_rate france
episodic_2_5th_rate virginia
episodic_2_brig britain
episodic_2_brig france
episodic_2_brig virginia
episodic_2_colonial_militia britain
episodic_2_colonial_militia virginia
episodic_2_french_marines france
episodic_2_light_cavalry_colonial britain
episodic_2_light_cavalry_colonial france
episodic_2_light_cavalry_colonial virginia
episodic_2_line_infantry britain
episodic_2_line_infantry virginia
episodic_2_natam_musketeers cherokee
episodic_2_natam_musketeers huron
episodic_2_natam_musketeers iroquoi
episodic_2_native_american_musketeer_auxiliary britain
episodic_2_native_american_musketeer_auxiliary france
episodic_2_native_american_musketeer_auxiliary virginia
episodic_2_rangers britain
episodic_2_rangers virginia
episodic_2_sloop britain
episodic_2_sloop france
episodic_2_sloop virginia
euro_elite_light_infantry britain
euro_elite_light_infantry_green_jackets britain
euro_grenade_launchers russia
euro_grenadiers russia
euro_highlanders_royal_ecossois france
euro_lancers_uhlans poland_lithuania
euro_lancers_uhlans prussia
euro_light_dragoons sweden
euro_light_infantry_miquelets portugal
euro_light_infantry_miquelets spain
euro_line_infantry austria
euro_line_infantry bavaria
euro_line_infantry britain
euro_line_infantry denmark
euro_line_infantry france
euro_line_infantry hannover
euro_line_infantry hessen
euro_line_infantry netherlands
euro_line_infantry poland_lithuania
euro_line_infantry prussia
euro_line_infantry russia
euro_line_infantry saxony
euro_line_infantry spain
euro_line_infantry sweden
euro_line_infantry swiss_confederation
euro_line_infantry venice
euro_line_infantry_austria austria
euro_line_infantry_britain britain
euro_line_infantry_denmark denmark
euro_line_infantry_france france
euro_line_infantry_holland netherlands
euro_line_infantry_poland poland_lithuania
euro_line_infantry_prussia prussia
euro_line_infantry_russia russia
euro_line_infantry_spain spain
euro_line_infantry_sweden sweden
euro_line_infantry_venice venice
euro_militia_infantry russia
euro_militia_infantry_colonial_tutorial_rubbish france
euro_pikemen bavaria
euro_pikemen hannover
euro_pikemen hessen
euro_pikemen russia
euro_pikemen saxony
euro_pikemen swiss_confederation
euro_pikemen_prussian prussia
euro_polish_winged_hussars russia
euro_provincial_cavalry russia
euro_rangers_siberian_hunters russia
euro_superior_line_infantry_blackwatch britain
euro_superior_line_infantry_coldstream britain
galleon pirates
galleon_fluyt pirates
galleon_race_built pirates
gorodskiye_streltsy russia
highland_clansmen scotland
janissaries_beylik_grenadiers ottoman_rebels
janissaries_beylik_grenadiers ottomans
janissaries_beylik_musketeers ottoman_rebels
janissaries_beylik_musketeers ottomans
janissaries_cemaat ottoman_rebels
janissaries_cemaat ottomans
janissaries_cemaat_grenadiers ottoman_rebels
janissaries_cemaat_grenadiers ottomans
janissaries_sekban ottoman_rebels
janissaries_sekban ottomans
light_galley/galliot/fusta pirates
medium_galley pirates
norwegian_ski_troops norway
ottoman_great_cannon ottomans
over_1st_rate portugal
over_1st_rate_american united_states
over_1st_rate_british britain
over_1st_rate_french france
over_1st_rate_spanish spain
pirates pirates
razee portugal
razee_british britain
revolutionary_guard france
revolutionary_infantry france
rocket_ship portugal
rocket_ship_american united_states
rocket_ship_british britain
rocket_ship_french france
rocket_ship_spanish spain
sloop britain
sloop france
sloop pirates
sloop spain
sloop united_states
sloop virginia
sloop_american united_states
sloop_british britain
sloop_french france
sloop_spanish spain
sp_ed_constitution united_states
sp_ed_constitution_admiral united_states
sp_ed_deaths_head_hussar prussia
sp_ed_guerillas spain
sp_ed_hms_victory britain
sp_ed_hms_victory_admiral britain
sp_ed_organ_gun ottomans
sp_ed_rogers_rangers britain
sp_ed_wild_geese france
steam_ship portugal
steam_ship_american united_states
steam_ship_british britain
steam_ship_french france
steam_ship_spanish spain
steppe_cavalry_tatars_crimean crimean_khanate
viborniye_streltsy russia
6th_rate russia
6th_rate_russian poland_lithuania
1st_rate knights_stjohn
2nd_rate knights_stjohn
3rd_rate knights_stjohn
5th_rate knights_stjohn
brig knights_stjohn
sloop knights_stjohn
rocket_ship knights_stjohn
carronade_frigate knights_stjohn
bomb_ketch knights_stjohn
over_1st_rate knights_stjohn
12_lber_howitzer crimean_khanate
12_lber_land_cannon crimean_khanate
12_lber_ship_fort_cannon crimean_khanate
18_lber_ship_fort_cannon crimean_khanate
1st_rate crimean_khanate
1st_rate_admiral crimean_khanate
24_lber_howitzer crimean_khanate
24_lber_land_cannon crimean_khanate
24_lber_land_cannon_(demi_cannon) crimean_khanate
24_lber_ship_fort_cannon crimean_khanate
2nd_rate crimean_khanate
3_lber_land_cannon_galloper crimean_khanate
3rd_rate crimean_khanate
3rd_rate_admiral crimean_khanate
4_inch_mortar crimean_khanate
4th_rate crimean_khanate
5th_rate crimean_khanate
5th_rate_admiral crimean_khanate
6_lber_land_cannon_galloper crimean_khanate
6th_rate_russian crimean_khanate
9_lber_land_cannon_(saker) crimean_khanate
bomb_ketch crimean_khanate
brig crimean_khanate
carronade_frigate crimean_khanate
episodics_armed_citizenry_europe crimean_khanate
episodics_armed_citizenry_matchlocks_europe crimean_khanate
euro_african_infantry crimean_khanate
euro_dragoons crimean_khanate
euro_dragoons_colonial crimean_khanate
euro_elite_light_infantry crimean_khanate
euro_expat_infantry crimean_khanate
euro_generals_bodyguard crimean_khanate
euro_grenadiers crimean_khanate
euro_hussars crimean_khanate
euro_light_dragoons crimean_khanate
euro_light_infantry crimean_khanate
euro_light_infantry_colonial crimean_khanate
euro_line_infantry crimean_khanate
euro_line_infantry_colonial crimean_khanate
euro_militia_infantry crimean_khanate
euro_militia_infantry_colonial_militia crimean_khanate
euro_pikemen crimean_khanate
euro_polish_winged_hussars crimean_khanate
euro_provincial_cavalry crimean_khanate
euro_provincial_line_infantry crimean_khanate
euro_regiment_of_horse crimean_khanate
euro_republican_conscript_infantry crimean_khanate
euro_republican_guard crimean_khanate
euro_sepoys crimean_khanate
guard_infantry crimean_khanate
household_cavalry crimean_khanate
native_american_archers_auxiliary crimean_khanate
native_american_mounted_musketeers_auxiliary crimean_khanate
native_american_musketeers_auxiliary crimean_khanate
native_american_tribesmen_auxiliary crimean_khanate
native_american_warriors_auxiliary crimean_khanate
over_1st_rate_russian crimean_khanate
pandours crimean_khanate
puckle_gun crimean_khanate
razee crimean_khanate
rocket_ship crimean_khanate
rockets_fixed crimean_khanate
sloop crimean_khanate
sp_ed_dahomey_amazon crimean_khanate
sp_ed_ghoorkas crimean_khanate
steam_ship crimean_khanate
steppe_cavalry_tatars_ottoman crimean_khanate
6th_rate crimean_khanate
euro_company_cavalry crimean_khanate
euro_company_infantry crimean_khanate
armed_citizenry_matchlocks_europe crimean_khanate
armed_citizenry_matchlocks_middle_east crimean_khanate
armed_citizenry_middle_east crimean_khanate

--MikeV 7 April 2009