def _get_field_map(cls):
"""
Return metadata for each field defined on this model, to aid in serializing
and exporing data.
"""
return OrderedDict([
('org_id', {
'sql': 'organization.uuid',
'label': 'unit:id:admin',
'serializer': cls.serializers['string'],
}),
('name', {
'sql': 'organization.name',
'label': Organization.get_spreadsheet_field_name('name'),
'serializer': cls.serializers['identity'],
}),
('name_confidence', {
'sql':
'organization.name_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name('name'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('division_id', {
'sql': 'organization.division_id',
'label':
Organization.get_spreadsheet_field_name('division_id'),
'serializer': cls.serializers['division_id'],
}),
('division_id_confidence', {
'sql':
'organization.division_id_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'division_id'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('classifications', {
'sql': 'organization.classifications',
'label':
Organization.get_spreadsheet_field_name('classification'),
'serializer': cls.serializers['list'],
}),
('classifications_confidence', {
'sql':
'organization.classifications_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'classification'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('aliases', {
'sql': 'organization.aliases',
'label': Organization.get_spreadsheet_field_name('aliases'),
'serializer': cls.serializers['list'],
}),
('aliases_confidence', {
'sql':
'organization.aliases_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name('aliases'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('firstciteddate', {
'sql': 'organization.first_cited_date',
'label':
Organization.get_spreadsheet_field_name('firstciteddate'),
'serializer': cls.serializers['identity'],
}),
('firstciteddate_confidence', {
'sql':
'organization.first_cited_date_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'firstciteddate'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('lastciteddate', {
'sql': 'organization.last_cited_date',
'label':
Organization.get_spreadsheet_field_name('lastciteddate'),
'serializer': cls.serializers['identity'],
}),
('lastciteddate_confidence', {
'sql':
'organization.last_cited_date_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'lastciteddate'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('realstart', {
'sql': 'organization.real_start',
'label': Organization.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('realstart_confidence', {
'sql':
'organization.real_start_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'realstart'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('open_ended', {
'sql': 'organization.open_ended',
'label': Organization.get_spreadsheet_field_name('open_ended'),
'serializer': cls.serializers['identity'],
}),
('open_ended_confidence', {
'sql':
'organization.open_ended_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'open_ended'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
])
def _get_field_map(cls):
"""
Return metadata for each field defined on this model, to aid in serializing
and exporing data.
"""
return OrderedDict([
('org_id', {
'sql': 'organization.uuid',
'label': 'unit:id:admin',
'serializer': cls.serializers['string'],
}),
('name', {
'sql': 'organization.name',
'label': Organization.get_spreadsheet_field_name('name'),
'serializer': cls.serializers['identity'],
}),
('name_confidence', {
'sql': 'organization.name_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('name'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('division_id', {
'sql': 'organization.division_id',
'label': Organization.get_spreadsheet_field_name('division_id'),
'serializer': cls.serializers['division_id'],
}),
('division_id_confidence', {
'sql': 'organization.division_id_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('division_id'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('classifications', {
'sql': 'organization.classifications',
'label': Organization.get_spreadsheet_field_name('classification'),
'serializer': cls.serializers['list'],
}),
('classifications_confidence', {
'sql': 'organization.classifications_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('classification'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('aliases', {
'sql': 'organization.aliases',
'label': Organization.get_spreadsheet_field_name('aliases'),
'serializer': cls.serializers['list'],
}),
('aliases_confidence', {
'sql': 'organization.aliases_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('aliases'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('firstciteddate', {
'sql': 'organization.first_cited_date',
'label': Organization.get_spreadsheet_field_name('firstciteddate'),
'serializer': cls.serializers['identity'],
}),
('firstciteddate_confidence', {
'sql': 'organization.first_cited_date_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('firstciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('lastciteddate', {
'sql': 'organization.last_cited_date',
'label': Organization.get_spreadsheet_field_name('lastciteddate'),
'serializer': cls.serializers['identity'],
}),
('lastciteddate_confidence', {
'sql': 'organization.last_cited_date_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('lastciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('realstart', {
'sql': 'organization.real_start',
'label': Organization.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('realstart_confidence', {
'sql': 'organization.real_start_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('realstart'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('open_ended', {
'sql': 'organization.open_ended',
'label': Organization.get_spreadsheet_field_name('open_ended'),
'serializer': cls.serializers['identity'],
}),
('open_ended_confidence', {
'sql': 'organization.open_ended_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('open_ended'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('site_id', {
'sql': 'location.id',
'label': 'unit:site_exact_location_id_latitude',
'serializer': cls.serializers['identity'],
}),
('site_id_confidence', {
'sql': 'emplacement.site_confidence',
'label': 'unit:site_exact_location:confidence',
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('site_name', {
'sql': 'location.name',
'label': 'unit:site_exact_location_name_longitude',
'serializer': cls.serializers['identity'],
}),
('site_division_id', {
'sql': 'location.division_id',
'label': 'unit:site_country',
'serializer': cls.serializers['division_id'],
}),
('site_feature_type', {
'sql': 'location.feature_type',
'sql': 'location.feature_type',
'label': 'unit:site_feature_type',
'serializer': cls.serializers['identity'],
}),
('site_admin_level', {
'sql': 'location.admin_level',
'label': 'unit:site_admin_level',
'serializer': cls.serializers['identity'],
}),
('site_admin_level_1_id', {
'sql': 'location.admin_level_1_id',
'label': 'unit:site_nearest_settlement_id',
'serializer': cls.serializers['identity'],
}),
('site_admin_level_1_name', {
'sql': 'location.admin_level_1_name',
'label': 'unit:site_nearest_settlement_name',
'serializer': cls.serializers['identity'],
}),
('site_admin_level_2_id', {
'sql': 'location.admin_level_2_id',
'label': 'unit:site_first_admin_area_id',
'serializer': cls.serializers['identity'],
}),
('site_admin_level_2_name', {
'sql': 'location.admin_level_2_name',
'label': 'unit:site_first_admin_area_name',
'serializer': cls.serializers['identity'],
}),
])
def _get_field_map(cls):
"""
Return metadata for each field defined on this model, to aid in serializing
and exporing data.
"""
return OrderedDict([
('child_unit_id', {
'sql': 'child.uuid',
'label': 'unit:id:admin',
'serializer': cls.serializers['string'],
}),
('name', {
'sql': 'child.name',
'label': Organization.get_spreadsheet_field_name('name'),
'serializer': cls.serializers['identity'],
}),
('name_confidence', {
'sql':
'child.name_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name('name'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('division_id', {
'sql': 'child.division_id',
'label':
Organization.get_spreadsheet_field_name('division_id'),
'serializer': cls.serializers['division_id'],
}),
('division_id_confidence', {
'sql':
'child.division_id_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'division_id'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('classifications', {
'sql': 'child.classifications',
'label':
Organization.get_spreadsheet_field_name('classification'),
'serializer': cls.serializers['list'],
}),
('classifications_confidence', {
'sql':
'child.classifications_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'classification'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('aliases', {
'sql': 'child.aliases',
'label': Organization.get_spreadsheet_field_name('aliases'),
'serializer': cls.serializers['list'],
}),
('aliases_confidence', {
'sql':
'child.aliases_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name('aliases'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('firstciteddate', {
'sql': 'child.first_cited_date',
'label':
Organization.get_spreadsheet_field_name('firstciteddate'),
'serializer': cls.serializers['identity'],
}),
('firstciteddate_confidence', {
'sql':
'child.first_cited_date_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'firstciteddate'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('lastciteddate', {
'sql': 'child.last_cited_date',
'label':
Organization.get_spreadsheet_field_name('lastciteddate'),
'serializer': cls.serializers['identity'],
}),
('lastciteddate_confidence', {
'sql':
'child.last_cited_date_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'lastciteddate'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('realstart', {
'sql': 'child.real_start',
'label': Organization.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('realstart_confidence', {
'sql':
'child.real_start_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'realstart'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('open_ended', {
'sql': 'child.open_ended',
'label': Organization.get_spreadsheet_field_name('open_ended'),
'serializer': cls.serializers['identity'],
}),
('open_ended_confidence', {
'sql':
'child.open_ended_confidence',
'label':
Organization.get_spreadsheet_confidence_field_name(
'open_ended'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('related_id', {
'sql': 'parent.uuid',
'label': Composition.get_spreadsheet_field_name('parent'),
'serializer': cls.serializers['string'],
}),
('related_id_confidence', {
'sql':
"composition_parent_metadata.confidence",
'label':
Composition.get_spreadsheet_confidence_field_name('parent'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('related_name', {
'sql': 'parent.name',
'label':
Composition.get_spreadsheet_field_name('parent') + ':name',
'serializer': cls.serializers['identity'],
}),
('related_name_confidence', {
'sql': 'parent.name_confidence',
'label': Composition.get_spreadsheet_field_name('parent') +
':name:confidence',
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('related_division_id', {
'sql': 'parent.division_id',
'label':
Composition.get_spreadsheet_field_name('parent') + ':country',
'serializer': cls.serializers['division_id'],
}),
('related_division_id_confidence', {
'sql': 'parent.division_id_confidence',
'label': Composition.get_spreadsheet_field_name('parent') +
':country:confidence',
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('related_classifications', {
'sql': 'composition.classifications',
'label':
Composition.get_spreadsheet_field_name('classification'),
'serializer': cls.serializers['list'],
}),
('related_classifications_confidence', {
'sql':
'composition.classifications_confidence',
'label':
Composition.get_spreadsheet_confidence_field_name(
'classification'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('related_firstciteddate', {
'sql': 'composition.first_cited_date',
'label': Composition.get_spreadsheet_field_name('startdate'),
'serializer': cls.serializers['identity'],
}),
('related_firstciteddate_confidence', {
'sql':
'composition.first_cited_date_confidence',
'label':
Composition.get_spreadsheet_confidence_field_name('startdate'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('related_realstart', {
'sql': 'composition.real_start',
'label': Composition.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('related_realstart_confidence', {
'sql':
'composition.real_start_confidence',
'label':
Composition.get_spreadsheet_confidence_field_name('realstart'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('related_lastciteddate', {
'sql': 'composition.last_cited_date',
'label': Composition.get_spreadsheet_field_name('enddate'),
'serializer': cls.serializers['identity'],
}),
('related_lastciteddate_confidence', {
'sql':
'composition.last_cited_date_confidence',
'label':
Composition.get_spreadsheet_confidence_field_name('enddate'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
('related_open_ended', {
'sql': 'composition.open_ended',
'label': Composition.get_spreadsheet_field_name('open_ended'),
'serializer': cls.serializers['identity'],
}),
('related_open_ended_confidence', {
'sql':
'composition.open_ended_confidence',
'label':
Composition.get_spreadsheet_confidence_field_name(
'open_ended'),
'confidence':
True,
'serializer':
cls.serializers['identity'],
}),
])
def _get_field_map(cls):
"""
Return metadata for each field defined on this model, to aid in serializing
and exporing data.
"""
return OrderedDict([
('org_id', {
'sql': 'organization.uuid',
'label': 'unit:id:admin',
'serializer': cls.serializers['string'],
}),
('name', {
'sql': 'organization.name',
'label': Organization.get_spreadsheet_field_name('name'),
'serializer': cls.serializers['identity'],
}),
('name_confidence', {
'sql': 'organization.name_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('name'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('division_id', {
'sql': 'organization.division_id',
'label': Organization.get_spreadsheet_field_name('division_id'),
'serializer': cls.serializers['division_id'],
}),
('division_id_confidence', {
'sql': 'organization.division_id_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('division_id'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('classifications', {
'sql': 'organization.classifications',
'label': Organization.get_spreadsheet_field_name('classification'),
'serializer': cls.serializers['list'],
}),
('classifications_confidence', {
'sql': 'organization.classifications_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('classification'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('aliases', {
'sql': 'organization.aliases',
'label': Organization.get_spreadsheet_field_name('aliases'),
'serializer': cls.serializers['list'],
}),
('aliases_confidence', {
'sql': 'organization.aliases_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('aliases'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('firstciteddate', {
'sql': 'organization.first_cited_date',
'label': Organization.get_spreadsheet_field_name('firstciteddate'),
'serializer': cls.serializers['identity'],
}),
('firstciteddate_confidence', {
'sql': 'organization.first_cited_date_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('firstciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('lastciteddate', {
'sql': 'organization.last_cited_date',
'label': Organization.get_spreadsheet_field_name('lastciteddate'),
'serializer': cls.serializers['identity'],
}),
('lastciteddate_confidence', {
'sql': 'organization.last_cited_date_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('lastciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('realstart', {
'sql': 'organization.real_start',
'label': Organization.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('realstart_confidence', {
'sql': 'organization.real_start_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('realstart'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('open_ended', {
'sql': 'organization.open_ended',
'label': Organization.get_spreadsheet_field_name('open_ended'),
'serializer': cls.serializers['identity'],
}),
('open_ended_confidence', {
'sql': 'organization.open_ended_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('open_ended'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_id', {
'sql': 'person.uuid',
'label': 'person:admin:id',
'serializer': cls.serializers['string'],
}),
('person_id_confidence', {
'sql': 'membership.person_id_confidence',
'label': 'person:posting:confidence',
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_name', {
'sql': 'person.name',
'label': Person.get_spreadsheet_field_name('name'),
'serializer': cls.serializers['identity'],
}),
('person_name_confidence', {
'sql': 'person.name_confidence',
'label': Person.get_spreadsheet_confidence_field_name('name'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_aliases', {
'sql': 'person.aliases',
'label': Person.get_spreadsheet_field_name('aliases'),
'serializer': cls.serializers['list'],
}),
('person_aliases_confidence', {
'sql': 'person.aliases_confidence',
'label': Person.get_spreadsheet_confidence_field_name('aliases'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_division_id', {
'sql': 'person.division_id',
'label': Person.get_spreadsheet_field_name('division_id'),
'serializer': cls.serializers['division_id'],
}),
('person_division_id_confidence', {
'sql': 'person.division_id_confidence',
'label': Person.get_spreadsheet_confidence_field_name('division_id'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_date_of_birth', {
'sql': 'person.date_of_birth',
'label': PersonBiography.get_spreadsheet_field_name('date_of_birth'),
'serializer': cls.serializers['list'],
}),
('person_date_of_birth_confidence', {
'sql': 'person.date_of_birth_confidence',
'label': PersonBiography.get_spreadsheet_confidence_field_name('date_of_birth'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_date_of_death', {
'sql': 'person.date_of_death',
'label': PersonBiography.get_spreadsheet_field_name('date_of_death'),
'serializer': cls.serializers['list'],
}),
('person_date_of_death_confidence', {
'sql': 'person.date_of_death_confidence',
'label': PersonBiography.get_spreadsheet_confidence_field_name('date_of_death'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_deceased', {
'sql': 'person.deceased',
'label': PersonBiography.get_spreadsheet_field_name('deceased'),
'serializer': cls.serializers['list'],
}),
('person_deceased_confidence', {
'sql': 'person.deceased_confidence',
'label': PersonBiography.get_spreadsheet_confidence_field_name('deceased'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_account_types', {
'sql': 'person.account_types',
'label': PersonExtra.get_spreadsheet_field_name('account_type'),
'serializer': cls.serializers['list'],
}),
('person_account_types_confidence', {
'sql': 'person.account_types_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('account_type'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_accounts', {
'sql': 'person.accounts',
'label': PersonExtra.get_spreadsheet_field_name('account'),
'serializer': cls.serializers['list'],
}),
('person_accounts_confidence', {
'sql': 'person.accounts_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('account'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_external_link_descriptions', {
'sql': 'person.external_link_descriptions',
'label': PersonExtra.get_spreadsheet_field_name('external_link_description'),
'serializer': cls.serializers['list'],
}),
('person_external_link_descriptions_confidence', {
'sql': 'person.external_link_descriptions_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('external_link_description'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_media_descriptions', {
'sql': 'person.media_descriptions',
'label': PersonExtra.get_spreadsheet_field_name('media_description'),
'serializer': cls.serializers['list'],
}),
('person_media_descriptions_confidence', {
'sql': 'person.media_descriptions_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('media_description'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_notes', {
'sql': 'person.notes',
'label': PersonExtra.get_spreadsheet_field_name('notes'),
'serializer': cls.serializers['list'],
}),
('person_notes_confidence', {
'sql': 'person.notes_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('notes'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_role', {
'sql': 'membership.role',
'label': MembershipPerson.get_spreadsheet_field_name('role'),
'serializer': cls.serializers['identity'],
}),
('person_role_confidence', {
'sql': 'membership.role_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('role'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_rank', {
'sql': 'membership.rank',
'label': MembershipPerson.get_spreadsheet_field_name('rank'),
'serializer': cls.serializers['identity'],
}),
('person_rank_confidence', {
'sql': 'membership.rank_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('rank'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_title', {
'sql': 'membership.title',
'label': MembershipPerson.get_spreadsheet_field_name('title'),
'serializer': cls.serializers['identity'],
}),
('person_title_confidence', {
'sql': 'membership.title_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('title'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate', {
'sql': 'membership.first_cited_date',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate'),
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_year', {
'sql': 'membership.first_cited_date_year',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate') + ':year',
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_month', {
'sql': 'membership.first_cited_date_month',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate') + ':month',
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_day', {
'sql': 'membership.first_cited_date_day',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate') + ':day',
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_confidence', {
'sql': 'membership.first_cited_date_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('firstciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_realstart', {
'sql': 'membership.real_start',
'label': MembershipPerson.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('person_realstart_confidence', {
'sql': 'membership.real_start_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('realstart'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_startcontext', {
'sql': 'membership.start_context',
'label': MembershipPerson.get_spreadsheet_field_name('startcontext'),
'serializer': cls.serializers['identity'],
}),
('person_startcontext_confidence', {
'sql': 'membership.start_context_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('startcontext'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate', {
'sql': 'membership.last_cited_date',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate'),
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_year', {
'sql': 'membership.last_cited_date_year',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate') + ':year',
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_month', {
'sql': 'membership.last_cited_date_month',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate') + ':month',
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_day', {
'sql': 'membership.last_cited_date_day',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate') + ':day',
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_confidence', {
'sql': 'membership.last_cited_date_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('lastciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_realend', {
'sql': 'membership.real_end',
'label': MembershipPerson.get_spreadsheet_field_name('realend'),
'serializer': cls.serializers['identity'],
}),
('person_realend_confidence', {
'sql': 'membership.real_end_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('realend'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_endcontext', {
'sql': 'membership.end_context',
'label': MembershipPerson.get_spreadsheet_field_name('endcontext'),
'serializer': cls.serializers['identity'],
}),
('person_endcontext_confidence', {
'sql': 'membership.end_context_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('endcontext'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
])
