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
- Passenger manifests used after 1920, which is helpful
- 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
- IE: t.co/idasYmtWJq ( Quantifying Kissenger)
- Do you want to simply organize your data or do you want to share it?
- 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?
- Visualization tools can be super helpful
- 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
