Dataro Reference Schema

Dataro ingests fundraising data from hundreds of organizations and dozens of different fundraising systems. These data sets are transformed to our own internal structure -- the reference schema -- for use in the models and platform.

The tables below document the structure of the reference schema.

N.b. it is not necessary or required that we have all fields with complete data. It is quite common for some data to not be available (i.e. full contact details) and in other cases to be incomplete (i.e. only a subset of the records have a birth_date). Furthermore, there can be good reasons why certain tables may not be present at all, i.e. if an organization has no recurring giving program, then we do not expect to have any data for commitments.