Statistical Uses of Administrative Data in Canada

1. Statistical Uses of Administrative Data in Canada Presentation to OG6 Canberra, Australia May 2011

2. What is administrative data? Applications of administrative data Sources Advantages and disadvantages Examples of use in the energy statistics program at Statistics Canada Overview of presentation

3. Records collected and maintained by other government agencies to meet legislative or regulatory requirements: To monitor activities related to the production and consumption of energy To enable regulatory or audit activities To assess outcomes of policies, programs, initiatives To register particular events (e.g. business incorporations, licensing) What is administrative data?

4. Statistical records: Are used to study dimensions, trends and relationships of groups of persons or entities Maintain the confidentiality of individual identifiable information Are used to produce aggregates, averages, measures This differs from statistical data

5. Direct collection of data Substitution for survey data (e.g. for non-response, for replacement of strata) Estimation, edits, imputation Creation and support of survey frames Data analysis, validation Improving timeliness Applications of administrative data

6. Other government departments and agencies responsible for regulation, audit, evaluation Can be national or sub-national Can be made available through: A file of individual records Aggregated data A survey or census of administrative agencies Sources of administrative data

7. Reduction in the overall costs of collection Reduction in burden placed on respondents Greater availability of small area data Possible reduction in errors due to census coverage Opportunities to link data to other admin sources Advances in technology make it easier, cheaper to manipulate and use large data files Useful in the development of survey frames Advantages of using admin data

8. Admin data are not primarily collected for statistical uses, which could lead to : Inconsistent concepts, variables, definitions Lack of follow-up, quality control Possible breaks in series with changes to regulations, legislation, policy Non-representative population Timeliness concerns Does the statistical agency have a legal right to access? (Statistics Act) Public concerns over confidentiality, intrusiveness? Disadvantages of using admin data

9. Using administrative data ... Examples from the energy statistics program at Statistics Canada

10. Where survey data do not exist Eg. Deregulation of the energy market created secondary distributors Data collected from natural gas distributors and transporters on sales to residential, commercial and industrial sectors A proxy for consumption data Eg. Import and export data from the National Energy Board From admin files on permits For direct collection

11. As a supplement for existing data Eg. For monthly crude oil and natural gas production, imports, exports, domestic deliveries and inventories, data are collected through both survey & admin data Producing provinces gather regulatory data For direct collection

12. Eg. Electric Utility Financial Report gathers an annual breakdown of a series of balance sheet and income statement items In 2008, negotiated with Ontario Energy Board to gather aggregate admin data for 85 municipal respondents Reduced costs, burden As a substitution for survey data

13. Where data are missing, incomplete, inconsistent with historical data Eg. Missing fuel consumption values are calculated using the change in fuel consumption by industry For estimation, edits, imputation

14. All energy surveys recently hooked up to the Statistics Canada Business Register A good source of information to establish and maintain survey frames Promotes harmonization across department To support survey frames

15. Energy statistics program uses other sources of information for quality control, outlier detection, confrontation Examples: Reports from industry associations Reports from other government departments For data analysis and validation

16. Program is working to accelerate the collection and reporting of key petroleum production data Using data from the Petroleum Registry of Alberta (PRA) as a starting point, to eliminate duplicate reporting PRA collects data for regulatory purposes The application may be extended to other producing provinces For improving timeliness

17. Other applications under investigation: Tax data, to replace financial reporting Public sector statistics, for data on electric utilities – operating revenues and expenditures, sales of electricity, using income statements and balance sheets Currently assessing survey data vs admin For the future...

18. Statistics Canada is relying more on admin data Driving factors: fiscal restraint, evolving technology, respondent burden Success based on legislative authority + ongoing collaboration Need to be aware of the constraints and challenges of using admin data Conclusion

19. Andy Kohut Director, Manufacturing & Energy Division Statistics Canada 11th Floor, Jean Talon Building, section B-8 Ottawa, Ontario CANADA K1A 0T6 613-951-5858 Andy.Kohut@statcan.gc.ca For more information