Skip to content

What raw data do we need to download in bulk from WhoWasInCommand.com?

Tom Longley edited this page Oct 18, 2018 · 4 revisions

Basic rules for downloads

  • Downloads are of the full, most up to date dataset on WWIC.
  • Downloads won't have sources attached unless this is simple to do. In this case, sources will be included in semi-colon separated specific to each substantive datapoint.
  • Downloads are on a country-specific basis.
  • All downloads are available as in .csv format.
  • Downloads that include location information will also be available in .GeoJson or .kml formats.

Proposed slices

Organizations: Basic information

Organization division_id

Organization:classification

Organization:Name

Organization:other_names

Organization:date_first_cited

start date of Organization? Y/N

Organization:date_last_cited

Organization:open_ended? Y/N/E

Organization: Notes

Organizations: Parentage

Organization division_id

Organization:classification

Organization:Name

Organization:other_names

Organization:date_first_cited

start date of Organization? Y/N

Organization:date_last_cited

Organization:open_ended? Y/N/E

OrganizationOrganization:parent_id

OrganizationOrganization:classification

OrganizationOrganization:date_first_cited

Start date of OrganizationOrganization Y/N?

OrganizationOrganization:date_last_cited

OrganizationOrganization:open_ended

Organization: Notes

Organizations: Memberships

Organization division_id

Organization:classification

Organization:Name

Organization:other_names

Organization:date_first_cited

start date of Organization? Y/N

Organization:date_last_cited

Organization:open_ended? Y/N/E

OrganizationMembership:member_id

Date of first citation for OrganizationMembership:member_id

start date of OrganizationMembership? Y/N

Date of last citation for OrganizationMembership:member_id

end date of OrganizationMembership? Y/N

Organization: Notes

Organizations: Sites

Organization division_id

Organization:classification

Organization:Name

Organization:other_names

Organization:date_first_cited

start date of Organization? Y/N

Organization:date_last_cited

Organization:open_ended? Y/N/E

Organization: Headquarters (Barracks, Base, Physical Asset)

Site: Exact Location - Longitude or OSM Node Name

Site: Exact Location - Latitude or OSM Node ID

Site:geonames_name

Site:geonames_id

Site:admin_level_1_geonames_name

Site:admin_level_1_geonames_id

Site:division_id

OrganizationSite:date_first_cited

OrganizationSite:date_last_cited

OrganizationSite:open_ended (Y/N/E)

Organization: Notes

Organization: Area of Operations

Organization division_id

Organization:classification

Organization:Name

Organization:other_names

Organization:date_first_cited

start date of Organization? Y/N

Organization:date_last_cited

Organization:open_ended? Y/N/E

Area of Operations Geoname

Area of Operations GeonameID

Area of Operations division_id

Date of first citation for area of operations

start date of area of operation? Y/N

Date of last citation for area of operations

Assume Area of Operations to Current Date? (Y/N/E)

Organization: Notes

Organizations: Personnel

Organization division_id

Organization:classification

Organization:Name

Organization:other_names

Organization:date_first_cited

start date of Organization? Y/N

Organization:date_last_cited

Organization:open_ended? Y/N/E

Person: Aliases or alternative spellings (semi-colon separated)

Person: division_id

Person: Organization

Person: Role

Person: Title (official title)

Person: Rank

Person: First citation

Person: first_month

Person: first_day

Person: first_year

Person: Start date? (Y/N)

Person: Context for start date

Person: Last citation

Person: last_month

Person: last_day

Person: last_year

Person: End date? (Y/N)

Person: Context for end date

Person: Notes

Person: full career histories

Note A persons' postings will be grouped per the SFM structure, with distinct rows for rank, role, title and organization (and I think, if organization is duplicated, the posting date range)

Person: Name

Person: Aliases or alternative spellings (semi-colon separated)

Person: division_id

Person: Organization

Person: Role

Person: Title (official title)

Person: Rank

Person: First citation

Person: first_month

Person: first_day

Person: first_year

Person: Start date? (Y/N)

Person: Context for start date

Person: Last citation

Person: last_month

Person: last_day

Person: last_year

Person: End date? (Y/N)

Person: Context for end date

Person: Notes

Person: Gender

Person: Date of Birth

Person: Death Date

Person: Biography

Person: Facebook Page

Person: Twitter Account

Person: Headshot

Person: Wikipedia Page

Person: Notes

All sources

Source: UUID

Source: Access Point UUID

Source: Title

Source: Publication date

Source: Access date

Source: pages

Source: URL

Source: Srchive URL

Source: Publication

Source: Publication Country

Source: Publication UUID