CSV contents

Document summarizing what each csv file contains

Core.csv

General Information

Field	Explanation
BN	Business Number
FPE	Some date field
Program #1 Code	Code for their programs
Program # 1 %	percentage of allocation of budget to this program?
Program # 1 Desc (Eng)	Description of the program
Program # 1 Desc (Fr)	Description of the program, in french
1510	A bunch of boolean values
1510 BN	no idea...
1510 - Name	no idea...I saw amnesty international in there

There is program 2 and program 3 as well...but only 3

Country.csv

Activities outside Canada - countries where program was carried

Field	Explanation
BN	The business number
FPE	Some sort of date field
#	An index on countries for each charity
Country	2 letter country code
Country Name (Eng)	country name in english
Country Name (Fre)	country name in French

Dir.csv

Charities Businesses Directors/Officers

Field	Explanation
BN	The business number
FPE	Some sort of date field
#	An index of execs for each charity; number 1 seems to be highest rank (eg president), 10 is an administrator
Last Name	Last name
First Name	First name
Initials	Initials
Position	Position of the person (strangely, not in both french and english...)
At Arm's Length	Boolean value
Start Date	Presume this is the start date of that persons term
End Date	Presumably the end date of term, if applicable

Donee.csv

Qualified Donees

Field	Explanation
BN	The business number
FPE	Some sort of date field
#	index on 1st BN to the 2nd BN
BN	Same column number...no idea what this BN is
Name	Name of the donee?
Associate	Boolean value
City	City
Province	Province
Total Gifts	total amount of gifts, presumbaly in dollars, not a sum of nexts two columns
Gifts in Kind
Designated Gifts

Fin.csv

Financial Data

Field	Explanation
BN	The business number
FPE	Some sort of date field
Form Used	6, D, probably more values
4020	A, C
4050	boolean value?

Other columns are presumably dollar amounts... along with some descriptions. there are too many of them to list all here

Ident.csv

Identification

Field	Explanation
BN	The business number
FPE	Some sort of date field
DDesignation	C
Legal Name	Legal name of the charity
Account Name	Name of the account?
Address and contact info are also provided, including website information!

Pgm.csv

Charitable Programs

Field	Explanation
BN	The business number
FPE	Some sort of date field
Type	OP, NA
Description