Home      Introduction      How to Search      Search the Database      Miscellaneous Searches    
View Original Documents      Downloads      Statistical Calculations      About      Feedback


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

For Unix/Linux:
  • 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.

For Windows:

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

For Macintosh:

  • Open up the .dbf file in FileMaker Pro.