Rows of csv explained

999 		= no data
----------------------------------------------------------------------------------------------------------------
Likert.data

id		unique id no. from questionnaire database

age		age ranges: 	15-19	= 1
				20-24	= 2
				25-29	= 3
				30-34	= 4
				35-39	= 5
				40-44	= 6
				45-49	= 7
				50-54	= 8
				55-59	= 9
				60-64	= 10
				65-69	= 11
				70-74	= 12
				75-79	= 13
				80-84	= 14
				85-89	= 15
				90+	= 16

gend		gender:		1 = male, 2 = female, 3 = gender diverse

postcode	Auckland postcode

control		1= controls mammalian pests (rodents, mustelids, possums) at their property,
		2= controls non-mammalian pests (e.g. weeds, invertebrates)
		3= doesnt control pests but might
		4= doesnt & unlikely to
con_Y		control mammlain pests Y/N: see 'control' above
				1=	controls mammalian pests at their property
				0=	doesn't control mammalian pests at property (but might control non-mammalian pests)

env_Y		member of an environmental/conservation group Y/N
				1=	member
				0=	not a member

ncc_Y		member of a community group that isn't a conservation group (i.e. hobby, cultural, sports, religious, educational)
				1= 	member
				0= 	not a member
		
relig_Y		member of a religious group Y/N

spor_Y		member of a sports group Y/N

edu_Y		member of a educational group Y/N

hob_Y		member of a hobby group Y/N

cul_Y		member of a cultural group Y/N

non_Y		not a member of any group Y/N

tot_grp		total no. of communty group types (max 6)

home_grp	pro-environmental behavior:
				1= member of a conservation group & controls mammalian pests at their property
				2= member of a conservation group 
				3= controls mammalian pests at their property
				4= neither pro-env behavior

housing		housing type:	
				1= Standalone house
				2= Town house, unit/apartment or terrace house 
				3= Lifestyle block or farm homestead
				4= Retirement village
				5= Rest home

eth_types	ethnicity	1= NZ European
				2= Māori
				3= Pacific islander
				4= Asian
				5= Middle Eastern/Latin American/African (MELAA)

educat		education level:
				0 =	No qualification
				1 =	Level 1 certificate
				2 =	Level 2 certificate (think GCSE?)
				3 =	Level 3 certificate (think A level?)
				4 =	Level 4 certificate
				4 =	Overseas secondary school qualification
				5 =	Level 5 diploma
				6 =	Level 6 diploma
				7 =	Bachelor degree and Level 7 qualification
				8 =	Post-graduate and honours degree
				9 =	Masters degree
				10=	Doctorate degree

income		income level: 	Loss to 0 NZD		= 1
				0-39,999 NZD		= 2
				40k-79,999 NZD		= 3
				80k-149,999 NZD		= 4
				150k-249,999 NZD	= 5
				250,000+ NZD		= 6

words		used 'social capital' words in Q16 in the questionnaire Y/N
				1 = Yes (at least 1 word)
				0 = No
tot_wrd		total 'social capital' words used

num_sc_q	number of social capital statements answered /31	
tot_sc		total social capital score = num_sc_q * av_sc
av_sc		mean social capital score for the social capital statements answered

----------------------------------------------------------------------------------------------------------------------
sc_scores_box.data

group		group type: conservation, cultural, educational, hobby, religious, sports

av_sc		mean social capital score for the social capital statements answered (for each type of community group a participant self-selected as participating in i.e. a person who is part of a religious group & cultural group would have 2 entry for the same av_sc value)

----------------------------------------------------------------------------------------------------------------------
split_sc.csv

id		unique id no. from questionnaire database

Grp		pro-environmental behavior:
				1= member of a conservation group & controls mammalian pests at their property
				2= member of a conservation group 
				3= controls mammalian pests at their property
				4= neither pro-env behavior

num_sc_q	number of social capital statements answered /31

A		Participation in the Local Community
B		Social Agency, or Proactivity in a Social Context
C		Feelings ofTrust and Safety
D		Neighborhood Connections
E		Family and Friends Connections
F		Tolerance of Diversity
G		Value of Life