This project will expand the analytical capabilities on the Embassy Database.
1. Standardize the Embassy Codes so that the years after 1983 are in the same format as those before 1983. Find the conversions in the attached files.
2. Details option. When we are checking the data from the 'COUNTRIES REPORT' we need to figure out the specific relationship between countries in a specific year. For Example: we see that 'Jersey' has a diplomatic mission in 1992, but we know that this should not be. We need the ability to check this relationship so we can determine what we should correct.
3. Create 'Location' Filter
Option to select specific countries
Option to exclude all relationships where the Importing Country is equal to 'Location'
Option to include all relationships where the Importing Country is equal to the 'Location'
4. Expanded filtering and display capabilities:
In filter, create button to automatically select all codes that are "Inside Country", "Outside Country" or "Unreciprocated".
Create a longitudinal display and edit option
Add filter for GENERATE EXCEL
5. Expanded editing capabilities.
Global find and replace codes for certain countries, codes, or years.
6. Clean up
Filter Form (possible matrix format)
Countries Report (hide columns instead of just data). Export to excel.
7. Add COW codes
From Input file (see attached list). This list will change, so we should be able to update it.
8. Final outputs
List of all dyadic relationships, sortable