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'], }), ])