For those who have been interested in the gun posts, and my attempt to wrap my head around firearms, I’ve uploaded my database to Google Drive. It is still a work in progress, with many empty fields to be filled (I maintain a massive commercial real estate database at work, so believe me, empty fields are a hateful thing to me).
The database is not a collection of every firearm that has ever existed – I’ve mostly focused on firearms from the “great powers” with a few other interesting specimens thrown in for good measure. It also doesn’t attempt to categorize every variation on these firearms – I’m using it for a game, so I don’t need to be that thorough.
A few explanations:
Nation might refer to the nation or origin or the nation most associated with the weapon – it’s a mishmash at the moment
Era is broken down into Pre-Modern (i.e. before the main scope of the game), Victorian (1860-1901), Pulp (1910’s to 1950’s), Cold War (1960’s to 1980’s) and Modern (1990’s to present).
Type is the general classification of the weapon. At the moment, I’m classifying anti-materiel weapons as sniper rifles.
Caliber is in inches.
Muzzle velocity is in feet/second. When italicized, it is a value I found for the ammunition, not the weapon – beggars can’t be choosers.
Bullet weight is in grains; originally, I was using place holders here originally, so some of the values might be off for the type of ammunition indicated. I’ll clean this up later.
TKOF is a calculated field – The Knock Out Factor – a useful abstraction for coming up with damage ranges.
Rate of fire is in rounds per minute.
Range is in yards, and (hopefully) represents the weapon’s effective range, not maximum, though data sources are not always clear.
Ammo refers to the weapon’s ammunition loading mechanism (or whatever the heck you want to call it).
Damage is a calculated field (essentially dividing TKOF by 20). For now, the damage values I’m going to use, based on the Modern SRD and different from previous posts, are as follows:
0 = 2d4
1 = 2d6
2 = 2d8
3 = 2d10
4 = 2d12
5 and beyond, I’m not sure yet, but 0-4 should take in most of the personal firearms, which is what I’m primarily interested in at the moment.
Cost is in dollars at the time the weapon was introduced – and this column is about 99% blank at this point. Ultimately, costs in the game are going to relate to how effective the weapon is – I just wanted a little info here on which to base my later calculations.
Rate of Fire – a calculated field showing rounds per 10-second round.
Ammunition is the type of ammunition used in some of the other fields (bullet weight, etc.). Many of these are blank because I didn’t initially keep track of this data, so I’ll need to go back through and fill these in.
Notes are just what you would think – notes.
The second Year column was just a convenience for me, so I could organize the weapons either alphabetically or by year introduced.
Since this isn’t my only copy of the database, I’m going to open it to the public for editing. Be gentle with it. My one request – if you add or change data, please highlight the cell that you changed, as well as the cell containing the weapon’s name, in yellow. It will make it easier for me to track down new information and put it into my other copy of the database. Please only make changes if you have a reliable source of data to work with, and please make a note of that source of data in the Notes field.
You can access the file HERE