- Slave Database: Slave.zip (18.03 MB)- records of the Lousiana slaves
- Slave.dbf (Dbase)
- Slave.mdb (Microsoft Access)
- Slave.mdx (dBASE IV multiple index)
- Slave.sav (SPSS)
- jnlslave.sps (SPSS)
- Slave_DB_Codes.txt (Text to interpret codes without SPSS)
- Free Database: Free.zip (1.28 MB)- records of the Louisiana free blacks
Please note that the code files (Slave_DB_Codes.txt and Free_DB_Codes.txt)
contain the data types and translations for each attribute. Without these
translations, the data will be numerically coded. For example, under
birthplace (BIRTHPL), 590 represents Angola; the word 'Angola' will not
appear, but '590' will instead.
The .sps file is for SPSS which is the Statistical Package for the Social Sciences.
The SPSS software allows users to make complex calculations and graphs.
This file can be altered to customize the databases and recode fields if
the scholar does not agree with some of the assumptions and interpretations which
went into the database.
The .sav file used with SPSS Windows version 9.0 or higher
automatically converts digits in the fields into words and contains
a significant number of useful, recoded fields.
The .mdx file are dbase production files which must be included
to get full access to dBase files.
How to Use
The database files do not come with an interface; an understanding of the
SQL syntax allows users to view the data efficiently. First you must unzip the
file with the appropriate software (Winzip, Aladdin Expander, unzip, etc).
- You may unzip the .dbf file in a directory accessible through the web and
execute queries through a scripting language. Perl's
dbase module tutorial or PHP's
use of dbase functions shows one how to access dbase with a front-end.
- You may export the .dbf file to a tab or colon delimited text (.txt) file
using the dbfdump
command. The text file then can be read in line-by-line from this text
file and inserted to another a DBMS of your choice.
- Open up the .dbf file in Visual FoxPro.
- Open up the .mdb file in Microsoft Access.
- Open up the .sav file in SPSS. The .sps syntax file is included for running SPSS commands.
- Open up the .dbf file in FileMaker Pro.