Download tables in .csv format

• Tables 1 to 12
• Summary Tables
• Historical Tables

These downloadable tables are in comma-separated value (.csv) format. In other words, the fields are separated by a comma.

• For most tables, the actual data start at row 2, column 2.
  • However, for Tables 2 to Table 6, the actual data start at row 2, column 3.
• The first row is always the code for the heading of each field.
• The first column is always the code for each data row.
• The last column is always the group code.
• The meaning of the heading codes, group codes, and codes for the data rows can be found in the look-up files for each table.

Tables 1 to 12

Basic Table 1: General statement by province and territory of taxation
- Download TABLE1.CSV

• The first field -- PCODE -- is a province code. The corresponding provinces can be found in PROVINCE.CSV.
• The corresponding meaning of the first 10 fields (F1 to F10) can be found in TAB1_F1-F10.CSV.
• The last field (F11) can be found in TAB1_F11.CSV.

Basic Table 2: All returns by total income class, all Canada
- Download TABLE2.CSV

• t02nl.csv for Newfoundland and Labrador
• t02pe.csv for Prince Edward Island
• t02ns.csv for Nova Scotia
• t02nb.csv for New Brunswick
• t02qc.csv for Quebec
• t02on.csv for Ontario
• t02mb.csv for Manitoba
• t02sk.csv for Saskatchewan
• t02ab.csv for Alberta
• t02bc.csv for British Columbia
• t02yt.csv for Yukon
• t02nt.csv for Northwest Territories
• t02nu.csv for Nunavut
• t02nr.csv for Non resident

Basic Table 2A: Taxable returns by total income class, all Canada
- Download TABLE2A.CSV

• t02anl.csv for Newfoundland and Labrador
• t02ape.csv for Prince Edward Island
• t02ans.csv for Nova Scotia
• t02anb.csv for New Brunswick
• t02aqc.csv for Quebec
• t02aon.csv for Ontario
• t02amb.csv for Manitoba
• t02ask.csv for Saskatchewan
• t02aab.csv for Alberta
• t02abc.csv for British Columbia
• t02ayt.csv for Yukon
• t02ant.csv for Northwest Territories
• t02anu.csv for Nunavut
• t02anr.csv for Non resident

Basic Table 3: All returns by major source of income, all Canada
- Download TABLE3.CSV

• t03nl.csv for Newfoundland and Labrador
• t03pe.csv for Prince Edward Island
• t03ns.csv for Nova Scotia
• t03nb.csv for New Brunswick
• t03qc.csv for Quebec
• t03on.csv for Ontario
• t03mb.csv for Manitoba
• t03sk.csv for Saskatchewan
• t03ab.csv for Alberta
• t03bc.csv for British Columbia
• t03yt.csv for Yukon
• t03nt.csv for Northwest Territories
• t03nu.csv for Nunavut
• t03nr.csv for Non resident

Basic Table 3A: Taxable returns by major source of income, all Canada
- Download TABLE3A.CSV

• t03anl.csv for Newfoundland and Labrador
• t03ape.csv for Prince Edward Island
• t03ans.csv for Nova Scotia
• t03anb.csv for New Brunswick
• t03aqc.csv for Quebec
• t03aon.csv for Ontario
• t03amb.csv for Manitoba
• t03ask.csv for Saskatchewan
• t03aab.csv for Alberta
• t03abc.csv for British Columbia
• t03ayt.csv for Yukon
• t03ant.csv for Northwest Territories
• t03anu.csv for Nunavut
• t03anr.csv for Non resident

Basic Table 4: All returns by age and sex, all Canada
- Download TABLE4.CSV

• t04nl.csv for Newfoundland and Labrador
• t04pe.csv for Prince Edward Island
• t04ns.csv for Nova Scotia
• t04nb.csv for New Brunswick
• t04qc.csv for Quebec
• t04on.csv for Ontario
• t04mb.csv for Manitoba
• t04sk.csv for Saskatchewan
• t04ab.csv for Alberta
• t04bc.csv for British Columbia
• t04yt.csv for Yukon
• t04nt.csv for Northwest Territories
• t04nu.csv for Nunavut
• t04nr.csv for Non resident

Basic Table 4A: Taxable returns by age and sex, all Canada
- Download TABLE4A.CSV.

• t04anl.csv for Newfoundland and Labrador
• t04ape.csv for Prince Edward Island
• t04ans.csv for Nova Scotia
• t04anb.csv for New Brunswick
• t04aqc.csv for Quebec
• t04aon.csv for Ontario
• t04amb.csv for Manitoba
• t04ask.csv for Saskatchewan
• t04aab.csv for Alberta
• t04abc.csv for British Columbia
• t04ayt.csv for Yukon
• t04ant.csv for Northwest Territories
• t04anu.csv for Nunavut
• t04anr.csv for Non resident

Basic Table 5: All returns by province and territory
- Download TABLE5.CSV

Basic Table 5A: Taxable returns by province and territory
- Download TABLE5A.CSV

• For Tables 2 to 5A, the first field -- CODE1 -- is the code for the "Item" group. The corresponding items can be found in t2item.csv.
• For Tables 2 to 5A, the second field -- CODE2 -- is the code for the individual item. The corresponding items can be found in tab2-5.csv.
• For Tables 2 and 2A, Fields F1 to F6 are the total number of returns and amount for the income class (grouped by F7). Each of them has 58 rows, for a total of 8 groups (F7 from 1 to 8). The corresponding number of returns and amount for income classes can be found in TAB2_F1-F7.CSV.
• For Tables 3 and 3A, Fields F1 to F6 are the number of returns and amount for sources of major income. There are 4 groups (F7). The corresponding number of returns and amount can be found in TAB3_F1-F7.CSV.
• For Tables 4 and 4A, Fields F1 to F6 are the number of returns and amount for age groups. There are 14 groups (F7). The corresponding number of returns and amount by age group can be found in TAB4_F1-F7.CSV.
• For Tables 5 and 5A, Fields F1 to F6 are the number of returns and amount for provinces and territories. There are 5 groups (F7). The corresponding number of returns and amount by province or territory can be found in TAB5_F1-F7.CSV.

Basic Table 6: All and taxable returns by age, sex, total income class, and major source of income, all Canada
- Download TABLE6.CSV

• t06nl.csv for Newfoundland and Labrador
• t06pe.csv for Prince Edward Island
• t06ns.csv for Nova Scotia
• t06nb.csv for New Brunswick
• t06qc.csv for Quebec
• t06on.csv for Ontario
• t06mb.csv for Manitoba
• t06sk.csv for Saskatchewan
• t06ab.csv for Alberta
• t06bc.csv for British Columbia
• t06yt.csv for Yukon
• t06nt.csv for Northwest Territories
• t06nu.csv for Nunavut
• t06nr.csv for Non resident
  
  
• For table 6, the first field ICODE is the code for the total income class, the corresponding income class can be found in t6item.csv and the definitions of fields f1 to f6 can be found in tab6_f1t6.txt

Basic Table 7: Distribution of net self-employment income by province and territory
- Download TABLE7.CSV

• For table 7, the first field ICODE is the code for the self-employment income, the corresponding self-employment income can be found in t7item.csv and the definitions of fields f1 to f9 can be found in tab7_f1t9.txt

Basic Table 8: All and taxable returns with allowed child care expenses, all Canada
*Please note that columns 5 and 6 of table 8 only include paper filed returns.
- Download TABLE8.CSV

• t08nl.csv for Newfoundland and Labrador
• t08pe.csv for Prince Edward Island
• t08ns.csv for Nova Scotia
• t08nb.csv for New Brunswick
• t08qc.csv for Quebec
• t08on.csv for Ontario
• t08mb.csv for Manitoba
• t08sk.csv for Saskatchewan
• t08ab.csv for Alberta
• t08bc.csv for British Columbia
• t08yt.csv for Yukon
• t08nt.csv for Northwest Territories
• t08nu.csv for Nunavut
• t08nr.csv for Non resident
  
  
• For table 8, the first field ICODE is the code for the total income class, the corresponding income class can be found in t8item.csv and the definitions of fields f1 to f7 can be found in tab8_f1t7.txt

Basic Table 9: All returns with taxable capital gains by total income class and by major source of income, all Canada
- Download TABLE9.CSV

• t09nl.csv for Newfoundland and Labrador
• t09pe.csv for Prince Edward Island
• t09ns.csv for Nova Scotia
• t09nb.csv for New Brunswick
• t09qc.csv for Quebec
• t09on.csv for Ontario
• t09mb.csv for Manitoba
• t09sk.csv for Saskatchewan
• t09ab.csv for Alberta
• t09bc.csv for British Columbia
• t09yt.csv for Yukon
• t09nt.csv for Northwest Territories
• t09nu.csv for Nunavut
• t09nr.csv for Non resident
  
  
• For table 9, the first field ICODE is the code for the total income class, the corresponding income class can be found in t9item.csv and the definitions of fields f1 to f9 can be found in tab9_f1t9.txt

Basic Table 10: Selected items by total income, all Canada
- Download TABLE10.CSV

• t10nl.csv for Newfoundland and Labrador
• t10pe.csv for Prince Edward Island
• t10ns.csv for Nova Scotia
• t10nb.csv for New Brunswick
• t10qc.csv for Quebec
• t10on.csv for Ontario
• t10mb.csv for Manitoba
• t10sk.csv for Saskatchewan
• t10ab.csv for Alberta
• t10bc.csv for British Columbia
• t10yt.csv for Yukon
• t10nt.csv for Northwest Territories
• t10nu.csv for Nunavut
• t10nr.csv for Non resident
  
  
• For table 10, the first field ICODE is the code for the total income class, the corresponding income class can be found in t10item.csv and the definitions of fields f1 to f9 can be found in tab10_f1t9.txt

Basic Table 11A: All returns with pension adjustment amount by total income class, all Canada
- Download TABLE11A.CSV

• t11anl.csv for Newfoundland and Labrador
• t11ape.csv for Prince Edward Island
• t11ans.csv for Nova Scotia
• t11anb.csv for New Brunswick
• t11aqc.csv for Quebec
• t11aon.csv for Ontario
• t11amb.csv for Manitoba
• t11ask.csv for Saskatchewan
• t11aab.csv for Alberta
• t11abc.csv for British Columbia
• t11ayt.csv for Yukon
• t11ant.csv for Northwest Territories
• t11anu.csv for Nunavut
• t11anr.csv for Non resident
  
  
• For table 11 A, B, C and D, the first field ICODE is the code for the total income class, the corresponding income class can be found in t11item.csv and the definitions of fields f1 to f9 can be found in tab11_f1t9.txt

Basic Table 11B: All returns with RRSP contributions by total income class, all Canada
- Download TABLE11B.CSV

• t11bnl.csv for Newfoundland and Labrador
• t11bpe.csv for Prince Edward Island
• t11bns.csv for Nova Scotia
• t11bnb.csv for New Brunswick
• t11bqc.csv for Quebec
• t11bon.csv for Ontario
• t11bmb.csv for Manitoba
• t11bsk.csv for Saskatchewan
• t11bab.csv for Alberta
• t11bbc.csv for British Columbia
• t11byt.csv for Yukon
• t11bnt.csv for Northwest Territories
• t11bnu.csv for Nunavut
• t11bnr.csv for Non resident

Basic Table 11C: All returns with RRSP contributions and pension adjustment amount by total income class, all Canada
- Download TABLE11C.CSV

• t11cnl.csv for Newfoundland and Labrador
• t11cpe.csv for Prince Edward Island
• t11cns.csv for Nova Scotia
• t11cnb.csv for New Brunswick
• t11cqc.csv for Quebec
• t11con.csv for Ontario
• t11cmb.csv for Manitoba
• t11csk.csv for Saskatchewan
• t11cab.csv for Alberta
• t11cbc.csv for British Columbia
• t11cyt.csv for Yukon
• t11cnt.csv for Northwest Territories
• t11cnu.csv for Nunavut
• t11cnr.csv for Non resident

Basic Table 11D: All returns with RRSP contributions and pension adjustment amount by total income class, all Canada
- Download TABLE11D.CSV

• t11dnl.csv for Newfoundland and Labrador
• t11dpe.csv for Prince Edward Island
• t11dns.csv for Nova Scotia
• t11dnb.csv for New Brunswick
• t11dqc.csv for Quebec
• t11don.csv for Ontario
• t11dmb.csv for Manitoba
• t11dsk.csv for Saskatchewan
• t11dab.csv for Alberta
• t11dbc.csv for British Columbia
• t11dyt.csv for Yukon
• t11dnt.csv for Northwest Territories
• t11dnu.csv for Nunavut
• t11dnr.csv for Non resident

Basic Table 12: All Returns with RRSP contributions and/or pension adjustment amount by age, total income class, and sex, all Canada
- Download TABLE12.CSV

• t12nl.csv for Newfoundland and Labrador
• t12pe.csv for Prince Edward Island
• t12ns.csv for Nova Scotia
• t12nb.csv for New Brunswick
• t12qc.csv for Quebec
• t12on.csv for Ontario
• t12mb.csv for Manitoba
• t12sk.csv for Saskatchewan
• t12ab.csv for Alberta
• t12bc.csv for British Columbia
• t12yt.csv for Yukon
• t12nt.csv for Northwest Territories
• t12nu.csv for Nunavut
• t12nr.csv for Non resident
  
  
• For table 12, the first field ICODE is the code for the total income class, the corresponding income class can be found in t12item.csv and the definitions of fields f1 to f9 can be found in tab12_f1t9.txt

Summary Tables

Summary of Basic Table 2: All returns by total income class, all Canada
- Download ST2CA.CSV

• st2nl.csv for Newfoundland and Labrador
• st2pe.csv for Prince Edward Island
• st2ns.csv for Nova Scotia
• st2nb.csv for New Brunswick
• st2qc.csv for Quebec
• st2on.csv for Ontario
• st2mb.csv for Manitoba
• st2sk.csv for Saskatchewan
• st2ab.csv for Alberta
• st2bc.csv for British Columbia
• st2yt.csv for Yukon
• st2nt.csv for Northwest Territories
• st2nu.csv for Nunavut
• st2nr.csv for Non resident
  
  
• For Summary of Basic table 2, the first field ICODE is the code for the total income class, the corresponding income class can be found in sumtab2.csv and the definitions of fields f1 to f8 can be found in st2_f1t8.txt

Summary of Basic Table 4: All returns by age and sex, all Canada
- Download ST4CA.CSV

• st4nl.csv for Newfoundland and Labrador
• st4pe.csv for Prince Edward Island
• st4ns.csv for Nova Scotia
• st4nb.csv for New Brunswick
• st4qc.csv for Quebec
• st4on.csv for Ontario
• st4mb.csv for Manitoba
• st4sk.csv for Saskatchewan
• st4ab.csv for Alberta
• st4bc.csv for British Columbia
• st4yt.csv for Yukon
• st4nt.csv for Northwest Territories
• st4nu.csv for Nunavut
• st4nr.csv for Non resident
  
  
• For Summary of Basic table 4, the first field ICODE is the code for the age group, the corresponding age group can be found in sumtab4.csv and the definitions of fields f1 to f9 can be found in st4_f1t9.txt

Historical Tables

• Historical Table 1 - Number of Returns Filed for Selected Years – 1968 to 2006
• Historical Table 2 - Yearly Distribution of Taxable Returns by Total Income Class – 1968 to 2006
• Historical Table 3 - Yearly Distribution of Taxable Returns by Age and Sex – 1972 to 2006
• Historical Table 4 - Yearly Distribution of Taxable Returns by Province and Territory – 1968 to 2006
  
  
• For Historical table 1, the definitions of the fields can be found in htable1.txt
• For Historical table 2, the definitions of the fields can be found in htable2.txt
• For Historical table 3, the definitions of the fields can be found in htable3.txt
• For Historical table 4, the definitions of the fields can be found in htable4.txt

Date modified:

2015-03-27