Copy of Data Dictionary (Phase I)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDFGHIJKLMNOPQRSTUVWXYZAAAB
1
Field NameRequiredWho to CompleteDefinitionContains Multiple Values? - CHECK AGAINST ACTUAL DATADeliminator - CHECK against actual data to see which fields use whatDH Press Data Type (for Mote Configuration)Create DH Press Mote?If value unknown or empty usePossible LegendFormatExample
2
how to handle spanish metadata?should each have a separate english/spanish entry? that is, duplicate entries for each attribute?Spanish, English
3
4
csv_post_titleYDILrequired for DHP import; unique title which corresponds to URLn/an/aavoid special characters (', ~)Andres Jimenez Before the Road
5
csv_post_typeYDILrequired for DHP import; all values are the samen/an/adhp-markers
6
project_idYDILrequired for DHP import; all values identical; corresponds to DHP valuen/an/ainteger pulled directly from DHP site
7
intervieweeYDILname of person interviewed (Accents will need to be restored after import)textYes - bulk edit req.First Name (or nickname?) Last NameMaestro Andres
8
interviewee_display_nameYDILname of person interviewed without accents (Use for legend)yescommatextY Y
9
excerpt_description_legendYDILan attempt at excerpting descriptions using a controlled vocab.yescommatextprobably not
10
interviewerYDILname of primary person conducting the interviewyescommatextYY (but not sure it's useful)First Name Last NameRenee Alexander Craft
11
secondary_interviewerNDILname of additional interviewertextYFirst Name Last Name
12
interview_dateYDILdate of interviewtextYunknownYYYY/MM/DD (as much as is known)
13
interview_locationNDILlocation of original interviewtextYunknownCity, State/Country
14
transcriberYDILName of transcriberyescommatextYFirst Name Last Name
15
translatorYDILName of translator(s); may contain multiple namescommatextYFirst Name Last NameOronike Odeley, Gustavo Esquina
16
ethnoracial_identityYReneeRacial category and ethnic identity of thing being discussed by intervieweeyescommatextYN/AYmust be in Unicode (UTF-8)Afrodescendiente
17
cultural_identityYReneeRelates to the cultural practice of the thing being described by intervieweeyescommatextYN/AYmust be in Unicode (UTF-8)Cimmarron
18
locationYReneePlaces mentioned in the oral historiesyessemicolontextYN/AYmust be in Unicode (UTF-8)
19
Congo_spacesYReneeSpaces related to Congo traditions and practicesyescommatextYN/AYmust be in Unicode (UTF-8)
20
Congo_charactersYReneeCharacters associated with Congo traditionsyescommatextYN/AYmust be in Unicode (UTF-8)
21
Congo_traditionYReneeThings associated with the Congo TraditionyescommatextYN/Anomust be in Unicode (UTF-8)
22
Congo_tradition_displayYReneelegend for Congo TraditionyescommatextYY
23
cultural_organizationYReneeActive Congo-related organizations in PortobeloyescommatextYN/Amust be in Unicode (UTF-8)
24
themesYReneeOverarching theme of the oral history segmentyescommatextYN/Amust be in Unicode (UTF-8)
25
theme_displayYReneeControlled vocabulary for themes -- for legendyescommatextYY
26
cultural_festivalsYReneeCultural festivals related to and including CongoyescommatextYN/Amust be in Unicode (UTF-8)
27
people_mentionedYReneePeople mentioned in the interview by the intervieweeyescommatextYN/Amust be in Unicode (UTF-8)
28
time_period_displayYDILControlled vocabulary for themes -- for legendyescommatextYY
29
time_periodsYReneePre-determined episodes on Portobelo historyyescommatextYN/AYmust be in Unicode (UTF-8)
30
specific_dateYReneeactual date, coded for the purposes of producing a timelineyescommatextYmay be emptyYYYY/MM/DD (as much as is known)1964 [or 1964/01 or 1964/01/31]
31
URL for more infoNReneeURL for more information; DIL will add html tagsyescommatextY
32
timestampYReneecorresponding start/end time in transcript that this data point refers totextYHH:MM:SS-HH:MM:SS00:01:03-00:05:02
33
lat_longYDILcorresponding lat/long for each data point to be "pinned" to the maplat_longYlatitute/longitude
34
audio_video_urlYDIL/Reneeaudio must be in URLfile / url / audio urlYnaming convention required
35
video_urlNDILfor youtube videos but not implementing in this phase of project--no
36
transcript_english_urlYDILURL for English version of transcript (pre-loaded into DH Press)file / url / transcript urlYsee transcript workflow for naming convention
37
transcript_spanish_urlYDILURL for Spanish version of transcript (pre-loaded into DH Press)file / url / transcript urlYsee transcript workflow for naming convention
38
BiographyYReneetextY
39
csv_post_postNReneeany sort of narrative context, interpretation, etc. textY <may be empty>must be in Unicode (UTF-8)
40
Excerpt_descriptionYReneeexcerpt of the segment of oral history inteview featured in the data pointtextY
41
More_Info_LinkYDILa link from each individual post back to full audionotextY - bulk edit may be required after importempty column didn't import. bulk update to add for each
42
43
44
blue=interview metadata
45
orange=conceptual/scholarly information
46
rose=DH Press required data
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
Loading...
 
 
 
Sheet1