Building History Databases: What’s Overkill?

Building History Databases: What’s Overkill?

  • Looking at travelers between Mexico and US pre 1846
    • Passenger manifests used after 1920, which is helpful
      • Organizing with excel with criteria
  • How do you organize this information?
    • Do you want to simply organize your data or do you want to share it?
      • Washington Post used Google Sheets to track popular votes
      • Access vs. Filemaker Pro vs. Excel
        • Google sheets makes it easier to communicate information with other people and it can be exported as an Excel sheet
        • Excel can also be used in social network analysis, GEPHI (plugin called Geo Layout) for visualization
  • How you construct the database dictates what kind of questions you can answer
      • Think about building in the right way to see patterns
      • Is simple data ok for answering these types of patterning questions?
        • Visualization tools can be super helpful
          • But perhaps use separate spread sheets?
  • What is a database?
    • Data dump?
    • Organized Data dump, which can be used to see relationships?
  • hueristnetwork.org
    • Very robust resource
    • Allows you to organize your date and export as CSV
    • Nonprofit open source program
  • Sequel
    • Allows you to create separate tables for specific criteria and combines them
  • OpenRefine
    • Cleans up your messy data, like spelling differences
  • Carto.org
    • Mapping tools, allows you to mess with CSS
    • Gives you a sense of changing patterns over time
  • Node Excel
    • Social Networking Analysis
    • Also, Palladio from Stanford for a less intense analysis
  • introtodh2016.web.unc.edu/workshops/mapping
    • For comparative mappings
  • Omeka and Neatline
    • More web-publishing than researching

 

Categories: Uncategorized |
Profile photo of Hope Gillespie

About Hope Gillespie

I am a Junior Archaeology major at GW and have just returned from 6 months overseas backipacking and studying at the University of Glasgow.