# The name of the mapping that would become the foreign_id of the collection
- csv_url: http://assets.data.occrp.org/tools/aleph/fixtures/md_companies/companies.csv
# Entity definition section.
# This is an arbitrary entity name that will be used throughout this query
# section of the mapping.
# Entity schema type from Follow the Money model.
# List of columns that are used as unique identifiers for each record.
# Could also be viewed as record aggregation when there are several
# records for the same company that differ only in, for example, address
# field. In this case the resulting entity will contain address values
# merged from different source data records.
# A set of properties that describe the chosen schema type.
# For each property one or several columns can be used to get value from.
# A literal string value could be given instead of a column value,
# e.g. for a country code.
- csv_url: http://assets.data.occrp.org/tools/aleph/fixtures/md_companies/directors.csv
# With this query Director records are loaded and the Directorship
# relation is defined between Directors and Companies.
# Again a Company entity is constructed using the same set of keys
# as in the query above in order to be referred to in the Directorship
# To only include records that have a non-empty `Director` column.
# To avoid key collision between directors and directorships an additional
# literal string value is given with `key_literal`.
# Linking together directors and companies, where the director and
# organization properties of the Directorship interval contain references
# to the director and company entities that were constructed previously.
# Similar to directors, in order to link founders to companies through
# an ownership event th company and founder entities have to be declared
# again in each query sectio.
- csv_url: http://assets.data.occrp.org/tools/aleph/fixtures/md_companies/founders.csv
# In case there're extra tables with data that has to be linked companies,
# the the same set of keys is repeated and the relevant properties
- csv_url: http://assets.data.occrp.org/tools/aleph/fixtures/md_companies/licensed.csv
- csv_url: http://assets.data.occrp.org/tools/aleph/fixtures/md_companies/unlicensed.csv