THE
Pullman Car Construction Record Database
Copyright 2001 – 2010 Thomas C. Madden
Last updated 4/13/10
This is the second “official” version of the on-line
For those who have altered the V1 database and want to update it to V2
rather than download the new version, all modifications and corrections to V1,
formerly listed on the Updates page, can be found here.
Included are 17 new corrections not previously listed on the Updates page.
A new field, <Record #>, has been added to permit sorting the database back to its original order if necessary.
The database contains over 13,400 records. All heavyweight
The database aligns with Wayner’s THE COMPLETE ROSTER OF
HEAVYWEIGHT
Disposition information in the database refers to
The information in the spreadsheets is geared to the modeler rather than
to the pure historian and is restricted to mechanical equipment and appearance
items. More information can be found
on the original
Data in the spreadsheet is taken from original
When entries are ambiguous, they are entered just as they appear on the original documents. CCRs were intended to reflect a car’s status and not its history. Changes were usually dated and earlier entries lightly lined out, but many entries are undated, and much information is lost because earlier entries are completely blacked out, or covered with a paper overlay. The information cannot be considered 100% complete, particularly concerning post-1948 painting information, but for the fields in the database, everything on the CCRs, CSCs and DLUs has been included.
DATA FORMAT
The database, compressed to save space, contains three data files: the
Main Database; an alphabetical index of all car names in the database; and an
index of all numbered Tourist cars in the database. The Car name and Tourist
car Indexes are also indexes to the locations of the original Car Construction
Records (CCRs) at the Newberry Library in
The Database and Car Name Indexes are available in three formats:
EXCEL2003, comma-delimited, and SYLK. Click on the links below to download the
ZIPped files in the desired format. (The database and both name indexes will
download.) The database is sorted first by Builder (in descending order), then
by Lot Number and
NOTE: THIS INFORMATION IS MOST USEFUL WHEN LOADED IN A SPREADSHEET OR DATABASE PROGRAM THAT WILL LET YOU FILTER OR SORT THE DATA. FILTERING IS MUCH MORE USEFUL THAN SORTING, AND THE USER IS ADVISED TO BECOME FAMILIAR WITH THE FILTERING FUNCTION OF YOUR SPREADSHEET OR DATABASE PROGRAM. VIEWING THE DATA AS TEXT IS NOT RECOMMENDED.
Comments and corrections are appreciated.
(1.98mb) |
(661kb) |
(990kb) |
|
Tom Madden
pullmanboss (at) yahoo (dot) com