Supplement to Statistics Canada’s Generic Privacy Impact Assessment related to the acquisition of child welfare data from child welfare agencies

Date: March 2021

Program manager: Director, Centre for Social Data Integration and Development

Director General, Social Insights, Integration and Innovation Branch

Reference to Personal Information Bank (PIB):

In accordance with the Privacy Act, Statistics Canada is submitting a new institutional personal information bank (PIB) to describe any personal information obtained from child welfare agencies, and provincial and territorial ministries, for the purposes of the Statistics Act. The following PIB is proposed for review and registration.

Canadian Child Welfare Information System (CCWIS)

Description: This bank describes information on child maltreatment, and family services obtained from child welfare agencies in Canada, including provincial and territorial ministries responsible for family services, Indigenous and other child welfare agencies. Personal information on children and caregivers may include first and last names, date of birth, gender, Indigenous and ethnic status, language, addresses and family demographics, as well as information related to their cases (reports made to the authorities, maltreatment types, level of substantiation, case assessments and outcomes, service provision, need for protection, placements, adoption or reunification).

Note: All direct personal identifiers such as names, addresses and data provider IDs are removed and replaced with a Statistics Canada record identifier. The personal identifiers are stored in a separate file with highly restricted access. Only the Statistics Canada identifier is kept with the information used for the database, to allow linkage between statistical files.

Class of Individuals: Children and caregivers (parents and guardians) accessing services or involved in child maltreatment cases reported to child welfare agencies in Canada.

Purpose: The personal information is used to create national statistical data on child maltreatment, and to enable statistical analyses of interactions with the system and of passage through the system, including referral to services, placement in foster care, connections to family, and reunification. Personal information is collected pursuant to the Statistics Act (Sections 3, 7, 8, 13, 22).

Consistent Uses: Subject to Statistics Canada's Directive on Microdata Linkage, information on child maltreatment may be combined with surveys or other administrative data sources for approved statistical purposes and longitudinal analysis. These data are used to: produce standardized national, provincial and territorial estimates; conduct retrospective, prospective, and life-course analyses; better understand protective and risk factors, and transfers between jurisdictions.

Retention and Disposal Standards: Information is retained until it is no longer required for statistical purposes and then it is destroyed.

RDA Number: 2007/001

Related Record Number: StatCan SSD 040

TBS Registration: To be assigned by TBS

Bank Number: StatCan PPU 813

Description of statistical activity:

With the collaboration of child welfare agencies, provincial and territorial ministries and Indigenous organizations and governments, Statistics Canada intends to acquire administrative data on child welfare in order to develop the Canadian Child Welfare Information System (CCWIS) on behalf of the Public Health Agency of Canada (PHAC). The CCWIS is a national public health information system on child welfare, and its purpose is to support nationally standardized analyses and reporting on child maltreatment; investigations and outcomes; the number of children in need of protection; and passage through the child welfare system, including referral to services, placement in foster care, connections to family, reunification, and other requests for family services. These data may be linked to other data held by Statistics Canada to better understand the family context, risk factors for child maltreatment, and long-term education, health and other outcomes for children.  Such linkages could inform policies, laws, programs and family support services to improve the lives of children and their families. Moreover, as Indigenous children are overrepresented in the child welfare system, quality national data on child welfare, including standardized provincial and territorial data, can be of particular benefit to programs and services aimed at ensuring the well-being of First Nations, Inuit and Métis communities.

Reason for supplement:

Statistics Canada's Generic Privacy Impact Assessment (PIA) presents and addresses the privacy principles and levels of potential security risks related to its statistical activities. Existing safeguards have been assessed as sufficient to address the potential privacy risks associated with the CCWIS. This project will follow standard Statistics Canada data stewardship practices to ensure the privacy of any data collected.

The purpose of this PIA supplement is to clearly illustrate the need for this personal information to achieve Statistics Canada's statistical mandate, and to demonstrate the public benefit that will be derived from the CCWIS data.

Necessity and Proportionality

The collection of personal information for the Canadian Child Welfare Information System was assessed against the four-part test proposed by the Office of the Privacy Commissioner of Canada, and aligns with Statistics Canada's Necessity and Proportionality Framework:

  1. Necessity:
    The CCWIS will fill a gap in annual national statistics, including provincial and territorial statistics, on the reporting, assessment, progression, and outcomes of children reported to child welfare authorities in Canada. Currently, there is no framework or comprehensive data source allowing for the production of national data on child maltreatment-related and other family involvement in child welfare by age, sex, Indigenous identity and ethnic status by province or territory. There are urgent calls for Canada-wide data on these issues to inform regional and national child welfare prevention and protection policies and practices. Data-informed child welfare is crucial to protect and improve the lives of many Canadian children and their families. The Truth and Reconciliation Commission of Canada and the National Inquiry into Missing and Murdered Indigenous Women and Girls, among others, are calling for data that include, but are not limited to, foster care involvement and risk factors for child placements, the need for which will be addressed by the CCWIS. The information to be contained in the CCWIS is being discussed through extensive engagement sessions aimed at identifying the needs of a broad range of stakeholders and subject matter experts in child welfare, including academics, researchers, service providers, provincial and territorial governments, Indigenous governments and organizations, the Public Health Agency of Canada and other federal partners.
  2. Effectiveness (Working assumptions):
    The high quality, timely and relevant data produced by the CCWIS will support the development of evidence-based policies and programs to improve the child welfare system. The collection of personal identifiers will help ensure high data quality by removing duplicate information and identifying repeat reporting. It will also provide opportunities to identify risk factors for child maltreatment and long-term outcomes by reviewing trends over time and outcomes of children into adulthood. Reliance on administrative data sources, as opposed to a survey approach, will reduce the burden on limited child welfare workers' resources.
  3. Proportionality:
    The CCWIS will have clear public benefits as the findings it will generate are expected to inform policies, laws, programs and family support services to ensure:
    • that children whose situations are such that they are going to need to be 'in care' for a long period of time are quickly identified and placed into stable care situations;
    • that this group of children is small, because effective supports are available within communities in need of such supports; and
    • that only children who need to be placed into care for their safety are, while children who do not need this are not wrongly placed into care.
    Future data linkage activities involving the CCWIS will need to satisfy stringent and independent approval mechanisms prior to initiation. Proportionality has been considered based on the following elements – sensitivity, ethics and design elements:
    • Sensitivity: The data collected for CCWIS is of a sensitive nature due to the elements being measured and the fact that most of the data collected concern children and child maltreatment. In addition, a significant proportion of the data to be collected will come from Indigenous children in a context where Indigenous communities are increasingly seeking greater decision-making powers in terms of the control of information on members of their communities. Moreover, the option of linking child maltreatment data with other data sources held at Statistics Canada to expand the informational value of the CCWIS, could potentially increase the sensitivity of the project. To reduce the risk of sensitive information being disclosed, the data will be processed according to current Statistics Canada best practices and in accordance with all relevant directives and policies. In particular, personal identifier variables (e.g., name, address, etc.) will be stored in a file separate from the child maltreatment data and accessible to only a limited number of employees on a need-to-know basis. Further, any proposition to link CCWIS data to other Statistics Canada data holdings will be required to undergo a stringent justification and review process in accordance with the Directive on Microdata Linkage before moving forward. Only the file with the personal identifier variables with no child maltreatment data is required for the linkage. The resulting linked data file keys are subsequently used to link the child maltreatment data with other data files – no direct identifiers are involved at this stage.
    • Ethics: Statistics Canada has engaged, and will continue to engage, with all provinces and territories, as well as with Indigenous stakeholders. Experts in the field of child maltreatment, from both PHAC and from the broader research community, have been consulted in order to ensure that any collection of data for CCWIS will be done ethically. In addition, we are adhering to transparency practices by documenting, on Statistics Canada's website, our intensions to obtain information on child maltreatment.
    • Flexibility of design elements: There are dozens of child welfare agencies in Canada, and each is under the jurisdiction of its respective province or territory. There is no national standard for collecting and storing data related to child welfare. Consequently, some jurisdictions have centralized systems, while others do not, and the data vary among provinces and territories in terms of both content and format. During a series of consultations with various stakeholders in the child welfare sector, child welfare service providers clearly advised that it would be far too burdensome for them if Statistics Canada were to request that they respond to a survey to describe a random sample of their cases. Previous methodological investigations by Statistics Canada to evaluate the sampling requirements for producing high quality estimates from a survey-based approach for the collection of data on child welfare also revealed that a high number of child welfare agencies would need to be selected for collection and that this exercise would need to be repeated throughout the 12 month reference period. Instead, it was deemed more practical for each of the jurisdictions to provide data files containing the relevant variables for every case they manage.
      Therefore, the estimated quality at the province/territory level should be sufficient to meet the policy needs.
      In terms of the content of the data acquired, Statistics Canada will request only those variables necessary to determine the national child maltreatment indicators that have been created in consultation with PHAC and other experts in the field of child welfare. Any additional variables that may be provided to Statistics Canada will be destroyed.
      The risk mitigations and the potential public benefits of this project have been deemed as proportional to the privacy considerations.
  4. Alternatives:
    A feasibility study was conducted with a broad range of child welfare stakeholders to identify an appropriate data collection approach for the CCWIS.  Through discussions with PHAC, it was determined that some child maltreatment data are being collected through the Canadian Incidence Study of Reported Child Abuse and Neglect/First Nations Incidence Study of Reported Child Abuse and Neglect (CIS/FNIS) funded by PHAC and managed by the Assembly of First Nations (AFN). While this last survey has provided great insight into child welfare, it is completed by child protection workers and there is concern about response burden. In addition, stakeholders' data needs have evolved to include the need to capture repeated interactions with the child welfare system. For example, a one-time assessment visit to a family from a child welfare worker due to a transitory situation or a mistaken concern has very different meaning than repeated visits due to chronic problems. The chronicity of child welfare involvement cannot be adequately captured by aggregate data. The need to understand trends over time, repeated interactions, and children's outcomes into adulthood requires the collection of individual level data. Potential data providers advised Statistics Canada that they would not participate in the CCWIS should the project proceed with a survey-based approach dependent on child welfare workers' participation, due to limited resources and the existing burden on these professionals. Moreover, surveying parents, guardians and children involved in child welfare investigations would not be appropriate for ethical reasons as it may harm those involved in welfare investigations or accessing services. This last approach would also encounter methodological challenges.

Conclusion:

This assessment concludes that, with the existing Statistics Canada safeguards, the agency is prepared to accept and manage any remaining risks.

Formal approval:

This Supplementary Privacy Impact Assessment has been reviewed and recommended for approval by Statistics Canada's Chief Privacy Officer, Director General for Modern Statistical Methods and Data Science, and Assistant Chief Statistician, Social, Health and Labour Statistics Field.

Pierre Desrochers
Chief Privacy Officer
Date: March 23, 2021

Eric Rancourt
Director General,
Modern Statistical Methods and Data Science
Date: March 30, 2021

Lynn Barr-Telford
Assistant Chief Statistician,
Social, Health and Labour Statistics
Date: April 15, 2021

The Chief Statistician of Canada has the authority for section 10 of the Privacy Act for Statistics Canada, and is responsible for the Agency's operations, including the program area mentioned in this Privacy Impact Assessment. This Supplement to the Generic Privacy Impact Assessment is approved by the Chief Statistician of Canada.

Anil Arora
Chief Statistician of Canada

Integrated Business Statistics Program (IBSP)

Reporting Guide

This guide is designed to assist you as you complete the 2021 Annual Civil Aviation Survey - Level I. If you need more information, please call the Statistics Canada Help Line at the number below.

Help Line: 1-877-949-9492

Your answers are confidential.

Statistics Canada is prohibited by law from releasing any information it collects which could identify any person, business, or organization, unless consent has been given by the respondent or as permitted by the Statistics Act.

Statistics Canada will use information from this survey for statistical purposes.

Table of contents

Business or organization and contact information

This section verifies or requests basic identifying information of the business or organization such as legal name, operating name (if applicable), contact information of the designated contact person, current operational status, and main activity(ies).

1. Legal name and Operating name

Legal Name
The legal name is one recognized by law, thus it is the name liable for pursuit or for debts incurred by the business or organization. In the case of a corporation, it is the legal name as fixed by its charter or the statute by which the corporation was created.

Modifications to the legal name should only be done to correct a spelling error or typo.

To indicate a legal name of another legal entity you should instead indicate it in question 3 by selecting 'Not currently operational' and then choosing the applicable reason and providing the legal name of this other entity along with any other requested information.

Operating Name
The operating name is a name the business or organization is commonly known as if different from its legal name. The operating name is synonymous with trade name.

2. Designated contact person

Verify or provide the requested contact information of the designated business or organization contact person. The designated contact person is the person who should receive this questionnaire. The designated contact person may not always be the one who actually completes the questionnaire. If different than the designated contact person, the contact information of the person completing the questionnaire can be indicated later in the questionnaire.

3. Current operational status

Verify or provide the current operational status of the business or organization identified by the legal and operating name in question 1. If indicating the operational status of the business or organization is 'Not currently operational' then indicate an applicable reason and provide the requested information.

4. Main activity

This question verifies the business or organization's current main activity as classified by the North American Industry Classification System (NAICS). The North American Industry Classification System (NAICS) is an industry classification system developed by the statistical agencies of Canada, Mexico and the United States. Created against the background of the North American Free Trade Agreement, it is designed to provide common definitions of the industrial structure of the three countries and a common statistical framework to facilitate the analysis of the three economies. NAICS is based on supply-side or production-oriented principles, to ensure that industrial data, classified to NAICS , are suitable for the analysis of production-related issues such as industrial performance.

The target entity for which NAICS is designed are businesses and other organizations engaged in the production of goods and services. They include farms, incorporated and unincorporated businesses and government business enterprises. They also include government institutions and agencies engaged in the production of marketed and non-marketed services, as well as organizations such as professional associations and unions and charitable or non-profit organizations and the employees of households.

The associated NAICS should reflect those activities conducted by the business or organizational units targeted by this questionnaire only, as identified in the 'Answering this questionnaire' section and which can be identified by the specified legal and operating name. The main activity is the activity which most defines the targeted business or organization's main purpose or reason for existence. For a business or organization that is for-profit, it is normally the activity that generates the majority of the revenue for the entity.

The NAICS classification contains a limited number of activity classifications; the associated classification might be applicable for this business or organization even if it is not exactly how you would describe this business or organization's main activity.

Please note that any modifications to the main activity through your response to this question might not necessarily be reflected prior to the transmitting of subsequent questionnaires and as a result they may not contain this updated information.

If the current NAICS associated with this business or organizations is not correct, please provide a brief description of the main activity and provide any additional information as requested.

Balance Sheet, Annual - Statement 20 (I)

Financial assets

Current assets

Include:

  • cash, bank balances (including deposits in transit, special deposits for the payments of debts, and so on) and short-term investments due within one year from the date of the balance sheet;
  • current accounts and notes receivable as well as other current assets such as inventories, charges to subscribers on transportation contracts, interests and dividends receivable, and so on.

All other financial assets – (Include investments and special funds.)

Include investments in associated companies, other investments such as investments in stocks, bonds, and so on, and special funds such as equipment purchase funds, funds set aside for such special purposes as contractual deposits, pension funds, self-insurance funds, and so on.

Property and equipment

Operating - flight equipment – (Include capital leases.)

Include:

  • flight equipment owned and/or under capital leases;
  • the cost of aircraft (airframes), aircraft engines, propellers, components (aircraft communication and navigational equipment) and spare parts that have been purchased outright. Flight equipment under capital leases includes the cost of flight equipment acquired under a capital or finance lease, in other words, a lease for a period considered to be the whole or nearly the whole life of the aircraft.

Accumulated depreciation and amortization - flight equipment

Include:

  • accumulated depreciation and amortization of flight equipment owned and/or under capital leases;
  • accrued charges representing losses, not replaced by current repairs, occurring in physical property and suffered through current lessening of service value due to wear and tear from use and the action of time and the elements; and losses occurring through obsolescence, supersession, new technological developments, changes in popular demand and the requirements of public authority.

Operating - ground property and equipment – (Include capital leases.)

Include:

  • ground property and equipment owned and/or under capital leases;
  • the cost of non-airborne communication and meteorological equipment, ramp equipment, maintenance and engineering equipment, surface transport vehicles and equipment, furniture, fixtures and office equipment, buildings and land as well as miscellaneous ground equipment such as medical equipment, airport and lighting equipment, passenger service equipment, hotel, restaurant and food service equipment, storage and distribution equipment. Ground property and equipment under capital leases includes the cost of ground property and equipment under a capital or finance lease, in other words, a lease for a period considered to be the whole or nearly the whole life of the property or equipment.

Accumulated depreciation and amortization - ground property and equipment

Include:

  • accumulated depreciation and amortization of ground property and equipment owned and/or under capital leases;
  • accrued charges representing losses, not replaced by current repairs, occurring in physical property and suffered through current lessening of service value due to wear and tear from use and the action of time and the elements; and losses occurring through obsolescence, supersession, new technological developments, changes in popular demand and the requirements of public authority.

Non-operating property and equipment – (Include capital leases.)

Include the cost of all non-operating property and equipment, in other words, all property and equipment not included in the "operating" categories above.

Accumulated depreciation and amortization - non-operating property and equipment

Include accumulated depreciation and amortization of the non-operating property and equipment.

All other assets

Include long-term prepayments, developmental and pre-operating costs such as the cost of extraordinary training, unamortized discounts and expenses on the issue of long-term debt securities, property acquisition adjustments, other intangibles such as payments made for patents, copyrights, and so on, and other deferred charges.

Total assets

The sum of the assets above less the accumulated depreciation and amortization.

Liabilities and capital

Current liabilities

Include:

  • current accounts and traffic balances payable, including balances subject to current settlement and payable to associated companies and/or shareholders, and notes payable on demand or within one year from the date of the balance sheet; current accounts and traffic balances payable, including balances subject to current settlement and payable to associated companies and/or shareholders, and notes payable on demand or within one year from the date of the balance sheet;
  • the current portion of long-term debt and the current obligations under capital leases;
  • air traffic liabilities (unearned transportation revenue), which includes the value of passenger tickets sold but not used or refunded as of the date of the balance sheet, and pre-paid amounts for the transportation of baggage, freight and mail for which the transportation has not occurred as of the date of the balance sheet;
  • salaries and wages accrued and unpaid, taxes accrued and unpaid, dividends payable, deposits by subscribers on transportation contracts (air travel plan liabilities, in other words, deposits received under air travel plan contracts) and other current and accrued liabilities.

Advances from associated companies and/or shareholders

Include the net amount from associated companies and/or shareholders for notes, loans or advances which are not currently settled.

Long-term debt and other non-current liabilities – (Include capital leases.)

Include:

  • the face value or principal amount of debt securities (for example, bonds, trust certificates, debentures, notes) issued and assumed by the air carrier and in the hands of others, which is not payable within twelve months of the balance sheet date;
  • long-term obligations under capital leases, which refers to the present value of unexpired contracts for the acquisition of aircraft under such lease arrangements.

Deferred income taxes

Include taxes that will be owed on income, but that have not yet been assessed.

All other liabilities

Include:

  • deferred credits which correspond to unamortized premiums on all classes of long-term debt, and other deferred credits such as securities issued or assumed by the air carrier, and other unadjusted accounts that cannot be cleared as of the date of the balance sheet;
  • provisions for major overhauls such as for flight equipment (in other words, liabilities of uncertain value or timing associated with the complete disassembly and inspection or repair of an aircraft, engine or other component of an aircraft) and other provisions such as liabilities of uncertain value or timing.

Shareholders' equity

Capital stock

Include the equity capital invested in a business through the purchase of various classes of common and preferred shares.

Retained earnings

Include the portion of after-tax profits left over, after dividends have been paid to shareholders, for reinvestment into the company. If this account is negative, then the amount indicated for this item should be shown with a negative (-) sign.

All other items

Include other paid-in capital and reserves. Other paid-in capital or contributed surplus includes the premiums or discounts that have resulted from selling stock, and stock received from donations. Reserves include any reserve fund such as reserve for self-insurance, reserve for pension, reserves against potential future losses, and so on. Also, include proprietorship or partnership accounts (balance year-end).

Total liabilities and capital

The sum of liabilities and capital plus the sum of shareholders' equity which should equal total assets.

Statement of Revenues and Expenses, Annual - Statement 21 (I, II)

Scheduled services

Transportation of passengers or goods, or both, by an aircraft provided by an air carrier that operates the air service and that, directly or indirectly, sells some or all of its seats or part or all of its cargo space to the public on a price per seat, price per unit of mass or price per volume of cargo basis.

Charter services

Transportation of passengers or goods, or both, by aircraft pursuant to a contract under which a person, other than the air carrier that operates the air service, or its agent, reserves a block of seats or part of the cargo space of an aircraft for the person's use or for resale to the public.

Include air ambulance service and the movement of people and goods to logging or heli-logging sites.

Exclude firefighting and heli-logging activities and the movement of people and goods to a firefighting site. (The former Transport Canada TP 8880 document "Starting a Commercial Air Service" outlining a list of activities which are specialty has been replaced with a new document TP 4711 "Air Operator Certification Manual" as of December 2020. A PDF version of volumes of this manual can be requested at: Air Operator Certification Manual – TP 4711)

Passenger revenue

Refers to the revenue earned from the transportation of passengers on scheduled and charter services. Include revenue from all surcharges (baggage, fuel, seat selection, changing or cancelling flights, and so on) that are retained by the air carrier. Exclude amounts such as taxes, navigation fees, security fees, and so on that are collected but passed on to other entities.

Goods revenue

Refers to the revenue earned from the transportation of goods on scheduled and charter services. Exclude taxes such as the Goods and Services Tax (GST), Harmonized Sales Tax (HST) or Provincial Sales Tax (PST).

All other flight-related revenue

Refers to the revenue earned from air transport activities not included in passenger revenue or goods revenue. Include revenue from other flying services such as flying training, recreational flying and other specialty flying.

All other revenue

Include subsidies and revenue earned from all other sources (including contra revenue, revenue of a corporate nature (leasing revenue, third party ground-handling, and so on), ancillary passenger revenue not easily allocated by operating flight (customs brokerage, and so on), revenue from in-flight sales (beverages, food, entertainment and wireless Internet access, and so on)).

Total operating revenue

The sum of passenger revenue, goods revenue, other flight-related revenue and revenue from all other sources.

Operating expenses - Ground property and equipment maintenance

Employee wages, salaries and benefits

Direct labour costs (wages and salaries) expended on the maintenance of ground property and equipment.

Include benefits such as employer contributions to pensions, medical benefits, insurance, and so on.

All other maintenance - ground property and equipment expenses

Expenses, both direct and indirect, incurred in the repair and upkeep of ground property and equipment.

Include materials and supplies, purchased repair services and all other related expenses.

Total maintenance - ground property and equipment expenses

The sum of the previous two expense items.

Operating expenses - Aircraft operations

Flight crew wages, salaries and benefits

Include the wages, salaries and benefits for flight crews (pilot, co-pilot, navigator, and so on).

Include benefits such as employer contributions to pensions, medical benefits, insurance, and so on and layover expenses such as hotels and meals.

Aircraft fuel and oil

Expenses for turbo fuel, gasoline and all other fuel and oil consumed such as turbine oil and piston oil.

Include throughput charges, non-refundable duties and taxes.

Landing fees

Include airport landing fees paid both in Canada and outside of Canada.

Navigation fees

Charges remitted to NAV CANADA or other international suppliers for the provision of air navigation services. Air navigation services include aeronautical communication services, aeronautical information services, aeronautical radio navigation services, air traffic control services, aviation weather services, emergency assistance services and flight information services.

Aircraft insurance

Expenses for insurance against accidental damage to flight equipment while in flight or on the ground and for insurance against liability occurring from the operation of aircraft or, in the case of non-insurance, the resulting expenses for which the carrier is liable.

Aircraft rental

Expenses incurred for the rental of aircraft (and crew) from other carriers, such as in chartering, interchange and operating or lease agreements.

All other aircraft operation expenses

Expenses incurred directly for the in-flight operation and related standby time of aircraft which are not elsewhere classified.

Total aircraft operations expenses

The sum of the previous seven expense items.

Operating expenses - Flight equipment maintenance

Employee wages, salaries and benefits

Direct labour costs (wages and salaries) expended on the maintenance of flight equipment.

Include benefits such as employer contributions to pensions, medical benefits, insurance, and so on.

Materials and supplies

Expenses on materials and supplies for the maintenance of flight equipment.

Purchased repair services

Expenses for repair services for the maintenance of flight equipment purchased from outside suppliers.

All other maintenance - flight equipment expenses

Expenses, both direct and indirect, incurred in the repair and upkeep of flight equipment.

Total maintenance - flight equipment expenses

The sum of the previous four expense items.

Operating expenses - In-flight services

Employee wages, salaries and benefits

Include:

  • the wages, salaries and benefits paid to cabin crews (flight attendants, and so on);
  • benefits such as employer contributions to pensions, medical benefits, insurance, and so on, and layover expenses such as hotels and meals.

Passenger food and supplies

Include expenses for in-flight meals, complimentary drinks, and so on, and the cost of supplies and personal services furnished to passengers.

Passenger liability insurance

Include the premiums for passenger liability and accident insurance paid by the carrier.

All other in-flight service expenses

Include passenger-related expenses incurred due to interrupted flights, including hotels, meals, taxi fares and other expense items, the cost of other services provided to passengers, such as pay, allowances and the cost of passenger service personnel, and all other services provided for the comfort of passengers in transit.

Total in-flight service expenses

The sum of the previous four expense items.

Operating expenses - Aircraft and traffic servicing

Employee wages, salaries and benefits

Include:

  • the wages, salaries and benefits paid to ground personnel;
  • benefits such as employer contributions to pensions, medical benefits, insurance, and so on.

Purchased services

Expenses for aircraft and traffic servicing purchased from outside suppliers.

All other aircraft and traffic servicing expenses

Include expenses incurred on the ground for scheduling or preparing aircraft for arrival and takeoff, expenses incurred in enplaning and deplaning passenger and cargo traffic, and expenses involved in servicing and handling individual aircraft and traffic on the ground, in preparing aircraft crews for flight assignment, in controlling the in-flight movements of aircraft and the in-flight expenses of handling all traffic including baggage.

Total aircraft and traffic servicing expenses

The sum of the previous three expense items.

Operating expenses - Promotion and sales

Employee wages, salaries and benefits

Include:

  • the wages, salaries and benefits paid to all staff engaged in reservations, ticketing, sales and promotional activities;
  • benefits such as employer contributions to pensions, medical benefits, insurance, and so on.

All other promotion and sales expenses

Include:

  • passenger and cargo commission expenses;
  • the net commission payable to others for the sale of transportation on the reporting carrier's service less the commission receivable from the reporting carrier's sale of transportation on other carriers' services, advertising and publicity expenses and any related expenses, accommodation costs, agency fees for outside services, expenses associated with reservations, city ticket offices and other sales expenses.

Total promotion and sales expenses

The sum of the previous two expense items.

Operating expenses - Depreciation

Depreciation - flight equipment

Include:

  • provisions for the depreciation of flight equipment only;
  • all charges incurred in normal wear and tear on flight equipment which have not been replaced by current year repair, as well as losses in service ability.

All other depreciation

Include:

  • provisions for the depreciation of all non-flight ground and property equipment;
  • all charges incurred in normal wear and tear which have not been replaced by current year repair, as well as losses in service ability;
  • charges for the amortization of capitalized development and other intangible assets.

Total depreciation

The sum of the previous two expense items.

Operating expenses - All other expenses

Include general administration.

Employee wages, salaries and benefits

Include:

  • the wages, salaries and benefits paid to all employees performing the general and administrative functions of the air carrier;
  • benefits such as employer contributions to pensions, medical benefits, insurance, and so on.

Exclude all amounts reported in the previous six wages, salaries and benefits categories.

All other expenses

Include:

  • all operating expenses and general administration expenses not reported elsewhere;
  • expenses for general financial accounting activities, supplementary labour income, property taxes, building rentals, communications purchased, purchasing activities, representation at law, and all other operational administration expenses not directly applicable to a particular function that are not included in the previous operating expenses categories;
  • expenses such as incidental air transport-related expenses associated with revenue reported as "all other revenue";
  • all miscellaneous operating expenses not covered elsewhere;
  • staff reduction expenses.

Total other expenses

The sum of the previous two expense items.

Total operating expenses

The sum of the eight expenses sub-totals, in other words, Total maintenance - ground property and equipment expenses, Total aircraft operations expenses, and so on.

Operating income

Net operating income (a loss should be a negative number)

Total operating revenue less total operating expenses – calculated from the previous questions.

Non-operating income/expenses

Interest and discount income

Include interest income from all sources and cash discounts on the purchase of materials and supplies.

Interest expenses

Include interest on unpaid taxes and all classes of debt including premiums, discounts and expenses on short-term obligations, amortization of premiums, discounts and expenses on short-term and long-term obligations.

All other net non-operating income (enter a negative number for a loss)

Include:

  • capital gains (or losses) from retiring operating property and equipment, aircraft equipment, expendable parts, miscellaneous materials and supplies and other assets, when they are sold or otherwise retired from service as part of a general program and not as incidental sales performed as a service to others;
  • gains or losses made on investments in securities;
  • net miscellaneous non-operating income or loss, which refers to revenue and expenses attributable to financing or other activities that are not an integral part of the air transportation activities undertaken by the carrier, or its incidental services. These could include dividend income, the balance of all income or losses from affiliated companies reimbursed to the carrier, foreign exchange adjustments and special items, such as restructuring expenses, which do not occur on a regular basis.

Exclude staff reduction expenses which should be included under all other expenses.

Net non-operating income (a loss should be a negative number)

The sum of the previous three income or expense items.

Provision for income taxes

Include the provision for taxes payable on net income for the accounting period and adjustments of income taxes relating to previous years, including provisions for deferred income taxes resulting from differences between accounting income and taxable income that arise when the time of including items of revenue and expense in the computation of accounting income and taxable income do not coincide. If the net amount is negative, then the amount indicated for this item should be shown with a negative (-) sign.

Net income (a loss should be a negative number)

Net operating income plus net non-operating income less the provision for income taxes.

Fuel and oil consumed

Turbo fuel consumed

Include fuel used in both turboprop and jet aircraft.

Provide the quantity and expenses for turbo fuel consumed. Turbo fuel includes the turbine fuel uplifted for all aircraft in the carrier's fleet. Fuel uplift can be determined based on delivery notes or invoices, aircraft onboard measurement systems or, if the fuel was supplied by a customer, estimated based on hours flown. Report the quantity of turbo fuel consumed in litres.

Include turbo fuel consumed for all scheduled and/or charter operations, regardless of where purchased. The expenses for turbo fuel consumed should be reported in Canadian dollars, regardless of where purchased. Include throughput charges, non-refundable duties and taxes. If the fuel was supplied by a customer, an approximate value may be provided based on prevailing market rates.

Conversion factor

To convert gallons (imperial) into litres (l), multiply by 4.546092.

All other fuel and oil consumed

Provide the quantity and expenses for all non-turbo fuel and oil consumed. Report the quantity of all other fuel and oil consumed in litres.

The quantity should include gasoline, turbine oil, piston oil and all other types of fuel and oil consumed for all scheduled and/or charter operations, regardless of where purchased. The expenses for all other fuel and oil consumed should be reported in Canadian dollars, regardless of where purchased. Include throughput charges, non-refundable duties and taxes.

Conversion factor

To convert gallons (imperial) into litres (l), multiply by 4.546092.

Total fuel and oil consumed

The sum of the quantities and expenses reported in the previous two items.

Employment

Average number of employees

Refer to the average number of people employed for each of the six categories of personnel.

Include all employees, temporary or permanent, on the payroll of the air carrier during the reporting period. Include part-time employees, prorated to the amount of time worked when compared to full-time employees (for example, two part-time employees working half-time are equivalent to one full-time employee).

Wages and salaries expenses

Include a breakdown of the wages and salaries paid for each of the six categories of personnel.

Exclude all benefits, in other words, employer contributions to pensions, medical benefits, insurance, and so on or layover expenses, such as hotels and meals, for flight and cabin crews.

Employment category

Include:

  • Pilots and co-pilots. Self-explanatory;
  • Other flight personnel. Flight crew (including flight engineers, navigators, and so on) and cabin crew (including flight attendants, and so on);
  • General management and administration employees (including the personnel performing the general and administrative functions such as administrative personnel at headquarters, comptrollers and assistants, directors and assistants (operations, passenger service, public relations, sales), and so on);
  • Maintenance personnel (including the personnel performing the ground property and equipment maintenance such as the carpenters, cleaners, and so on and including the personnel performing the flight equipment maintenance such as the aircraft maintenance engineers and the inspectors of flight equipment);
  • Aircraft and traffic servicing personnel (including supervisory personnel, assigned to ground activities, engaged directly in protecting and controlling aircraft in flight (flight dispatch personnel, flight planning staff), in scheduling and preparing flight crews for flight assignment, in parking and servicing aircraft incidental to line operations and including baggage handlers, aircraft fuelers, and so on);
  • All other employees (including air ambulance attendants, accountants, economists, statisticians, lawyers, purchasing personnel, publicity representatives, and so on).

Total employees

The sum of the number and the wages and salaries expenses for the six categories of personnel.

Revenue or expenses by area of operation

Passenger revenue

Include a breakdown of the revenue earned from the transportation of passengers for each province, territory and outside of Canada based on where the transportation service was provided. Total passenger revenue should equal the sum of passenger revenue from scheduled services and charter services previously reported.

Goods revenue

Include a breakdown of the revenue earned from the transportation of goods for each province, territory and outside of Canada based on where the transportation service was provided. Total goods revenue should equal the sum of goods revenue from scheduled services and charter services previously reported.

Employee wages and salaries

Include a breakdown of employee wages and salaries for each province, territory and outside of Canada based on where the employees are located. Total employee wages and salaries should equal the total wages and salaries expenses reported in the "Employment" section above.

Data Engineering in Rust

By: Scott Syms, Shared Services Canada

The breadth of the Python ecosystem is invaluable to the data science community. Python's selection of tools allows its users to access expressive environments to explore data, train machine learning models and display results in a self-documenting format. It's even been suggested that Jupyter Notebooks, a popular Python data exploration environment, replace the traditional scientific paper.Footnote 1

However, Python has its issues. The very elements that make it accessible and usable, such as dynamic typing, reference counting, and the global interpreter lock, can prevent programs from making full use of available computing resources. This is most apparent when processing large datasets or computational intensive workloads.

Typically, there are two approaches to large computing workloads in Python. C

For data scientists working with big data or heavy computational workloads, Python provides some work-arounds. Computational accelerators such as Numba,Footnote 2 PyPyFootnote 3 and PystonFootnote 4 use leverage coding optimizations to add speed to single machine development environments. When it's combined with Python's concurrency support,Footnote 5 these libraries can boost the processing capacity of a single machine.

Another approach employs libraries such as DaskFootnote 6 and PySparkFootnote 7 to distribute processing over several machines. There's nothing stopping you from doing both – optimize in place and distribute the load.

Ultimately, the tools you use are defined by implementation constraints. For data scientists with access to managed cloud environments, the ability to spawn hundreds of machines to quickly chew through data is an obvious way to address the computing problem. For users with more modest resources, however, the scalability options may be limited. AI at the edge of the network may not have the same compute capacity available as with cloud environments.

Near the end of 2020, the science publication Nature suggested an alternative to some of the traditional approaches to science data computation.Footnote 8 The author proposed writing scientific software in Rust, an emerging and highly-performant new language.

The Rust programming language made its debut in 2009 as a side project for Mozilla programmer, Graydon Hoare. It offers similar performance to C++, but provides better safeguards around memory use and concurrency. Like C++ and Python, it can be used across a range of platforms – from microcontroller programming, to high capacity asynchronous web applications. Rust applications can be compiled to WebAssembly,Footnote 9 allowing them to run in the browser at near-native speeds.

The combination of speed, safety and interoperability is an ideal mix of features when dealing with a big data engineering problem that comes from the analysis of global ship positional data.

Automatic Identification System

By international agreement, ocean-going vessels must transmit voyage data messages using the Automatic Identification System (AIS).Footnote 10 These messages can be collected from space, aggregated into a global picture of shipping activity and sold to commercial and government organizations. The article Building a Maritime Picture in the Era of Big Data: The Development of the Geospatial Communication Interface+, describes the challenges with collecting vessel position data for global surveillance.Footnote 11

The Canadian Space Agency (CSA) manages Government of Canada contracts for space-sourced global maritime tracking data. On any given day, they distribute millions of positional messages to maritime stakeholders across the government. Over the past decade, the CSA has collected well over 50 billion messages.

National Marine Electronics Association (NMEA) maintains the global AIS standard. A sample of AIS data is provided below.


1569890647\s:VENDOR,q:u,c:1569890555*5F\!AIVDM,1,1,,A,13KG9?10031jQUNRI72jM5?40>@<,0*5C
1569890647\s:VENDOR,q:u,c:1569890555*5F\!AIVDM,1,1,,B,13aEPIPP00PE33dMdJNaegw4R>@<,0*77
1569890647\g:1-2-6056,s:VENDOR,c:1569890555*3A\!AIVDM,2,1,6,A,56:GTg0!03408aHj221<QDr1UD4r3?F22222221A:`>966PW0:TBC`6R3mH8,0*0E
1569890647\g:2-2-6056*58\!AIVDM,2,2,6,A,88888888880,2*22

Each sentence above contains metadata about the position report. They include:

  • the time the observation was made by the sensor,
  • the source of the detection,
  • the time the report was relayed from satellite to a ground station, and
  • whether the sentence is a fragment of a group of messages.

Although some of the message is human-readable, important data about ship identity and movement is wrapped in a six-bit ASCII payload near the end of the sentence. Eric Raymond's AIVDM/AIVDO protocol decoding websiteFootnote 12 presents a detailed guide on how ship data is packed within the string.

Decoding AIS with a Rust Application

The goal set for this Rust application is to convert an archive of raw AIS data into a JSON equivalent that can be used for data analysis. The output should preserve the original data for reprocessing, if needed. Reformatting the data as JSON is a valuable step in the data engineering pipeline as it allows the data to be loaded into a DataFrame, a database, or converted into a read-optimized format, such as Apache Parquet.

Below is the desired output when using JSON to packet and preserve original data alongside derived elements.


{
"sentence":"1569888002\\s:VENDOR,q:u,c:1569884202*4F\\!AIVDM,1,1,,B,1:kJS6001UJgA`mV1sFrGHAP0@L;,0*56",
"landfall_time":"1569888002",
"group":"",
"satellite_acquisition_time":"1569884202",
"source":"VENDOR",
"channel":"B",
"raw_payload":"1:kJS6001UJgA`mV1sFrGHAP0@L;",
"message_type":1,
"message_class":"singleline",
"mmsi":"725000984",
"latitude":-45.385661666666664,
"longitude":-73.55857,
"call_sign":"CQ4F3",
"destination":"HALIFAX",
"name":"SS MINNOW",
"ship_type":"23",
"eta":"",
"draught":"",
"imo":"",
"course_over_ground":"86950448",
"position_accuracy":"0",
"speed_over_ground":"101",
"navigation_status":"0"
}

Walking through the RUST program

To extract data from AIS data, each character in the payload must be converted from six-bit ASCII to its binary equivalent and the entire sentence is merged into a long binary string. Pieces of string are converted back into human readable numbers and text.

Figure 1: Extracting data from the payload requires it to be converted to binary.

Figure 1: Extracting data from the payload requires it to be converted to binary
Figure 1: Extracting data from the payload requires it to be converted to binary. The payload is being converted to binary before the data can be extracted. The process is described in the following section. Image in text: kJS6001UJgA'mV1sFrGHAP0@L; 110010111101101001000101111010101001010101001010100101000101010010101001010101001010 SS MINNOW

To help squeeze all the computing possible from the host machine, Rust offers "fearless concurrency". The workload can be easily distributed across all available computer cores with message-passing channels relaying the data between threads.

The process is divided into three pools. The first is a single-threaded process that reads a source file of AIS data, inserting each line into a struct field, and passes the struct to a pool of threads that does the initial parsing through a channel.

The receiving thread parses the single line position messages, and forwards the results to a file writer as a JSON packet. Multiline sentences are passed to a second pool of threads that cache and reassemble sentence fragments. Again, these results are forwarded to the file writer as a JSON string.

Given that processing is handed off to competing concurrent threads, there are no order guarantees in output. Queuing delays and differences in processing time can ensure the output for each report will not be the same order as the input.

Program highlights

Figure 2: Program process

Figure 2: Program process
Figure 2: Program process This program process begins at the Main Thread and the Output File. The Read Source File box is adjacent to it. From there, a Source Channel arrow points to the next step, which is the Thread Pools Parse Single Line Data via the Multiline Reports Channel. From this point, the process can either loop back to the Main Thread again as a Parsed Single Line Channel or down to the Thread Pools Cache and Parse Multiline Data process. From there, it loops back to the Main Thread via the Parsed Multiline Channel. The option is to either continue in the process or via JSON Serialization, it creates the Output File.

Regular expression can be used to extract human-readable data in the AIS sentence, but additional work has to be done to convert the data from the six-bit payload to a binary string, take slices of the result and convert these slices back to text, floats and integers.

Cargo and version pinning

Rust makes use of a well-thought build system where package dependencies and build directives can be specified in a definition file.


[package]
name = "rustaise"
version = "0.1.0"
edition = "2021"

[dependencies]
crossbeam-channel = "0.5.2"
threadpool = "1.8.1"
num_cpus  = "1.13.1"
hashbrown = "0.12.0"
clap = "3.0.7"
regex = "1.5.4"
bitvec = "1.0.0"
serde = { version = "1.0.136", features = ["derive"] }
serde_json = "1.0.78"

[profile.release]
lto = true

Dependencies called "Crates" can be listed with a specific version. Upgrading to a different release of the crate has to be explicitly done, mitigating errors from moving to different library versions.

The iron fist of variable scoping

One of the methods Rust uses to maintain memory safety, is to tightly control variable scope.


// Let's assign 21 to x
let x = 21;
	{
	// Now let's assign 12 to x
	let x =12;
	}
// Since the scope has ended for the previous assignment
// the value of x is still 21
println!("{}", x);

The code snippet above would print the number "21" because the assignment "x = 12" is only valid between the braces.

This is a powerful way to keep your memory in order, but it can be counter-intuitive. For example, the following doesn't work because the variable -x is descoped at the end of the jf block brace pair.


if y == 1 {
    let x = 21;
} else {
    let x = 0;
}
println!("{}", x);

}

One way to deal with this is to create an anonymous function where the output of the function is assigned to the variable. Variable assignments with nested if and match evaluations are used throughout the program.


let y = 1;
let x = 21;
let x: i8 ={
    if y == 1 {
         67
    }
    else {
        0
    }
};

println!("{}", x);

The rigid control of variable lifetimes and ownership changes the way you structure your program.

Resistance is futile

The compiler is very chatty and will refuse to compile code that transgresses Rust's guard rails.

error[E0308]: mismatched types
 --> src/main.rs:8:10
  |
8 |          67.0
  |          ^^^^ expected `i8`, found floating-point number

For more information about this error, try `rustc --explain E0308`.
error: could not compile `playground` due to previous error

While sometimes frustrating, the compiler's messages are helpful in determining the cause of the error. The mantra "work with the compiler" is often seen in online comments.

The software begins by defining a struct that will hold the raw sentences and extracted data as it passes through the workflow.


#[derive(Serialize, Default, Clone, Debug)]
struct PositionReport {
    pub sentence: String,
    pub landfall_time: String,
    pub group: String,
    pub satellite_acquisition_time: String,
    pub source: String,
    pub channel: String,
    pub raw_payload: String,
    pub message_type: u64,
    pub message_class: String,
    pub mmsi: String,
    pub latitude: f64,
    pub longitude: f64,
    pub call_sign: String,
    pub destination: String,
    pub name: String,
    pub ship_type: String,
    pub eta: String,
    pub draught: String,
    pub imo: String,
    pub course_over_ground: String,
    pub position_accuracy: String,
    pub speed_over_ground: String,
    pub navigation_status: String,
} // end of struct PositionReport

Note the #Derive keyword preceding the struct definition. Although Rust is not an object-oriented language like Java, it allows methods to be shared across structures using a feature called Traits in a way that emulates inheritance.

In the declaration above, the Serialize, Default, Clone and Debug traits are being added to the struct.

Thread Pools

Defining thread pools are quite simple in Rust. The program finds the number of available cores and declares the number of workers for each thread.

For loops are used to launch individual threads.


    // Workers are the number of CPUs.
    let n_workers = num_cpus::get();

    let reading_thread = ThreadPool::new(1);
    let extraction_pool = ThreadPool::new(n_workers);
    let multiline_assembly_thread = ThreadPool::new(n_workers);

    for _a..n_workers: {
        multiline_assembly.execute(move || {
            // Do stuff
        }
    }

    for _b..n_workers: {
        extraction_pool.execute(move || {
            // Do stuff
        }
    }

    reading_thread.execute(move || {
        // Do stuff
    }

For loops control the number of threads launched, while the move keyword passes the current variables to the thread.

Channel Definitions and Flow Control

The relay channels between the threads are defined with a limit to prevent the producing threads from overfilling the channel and exhausting memory. By default, the program sets the upper bound to 500,000 elements, but it can be changed from the command line to best fit the available memory.

Each declaration defines a sending and receiving channel, and the data types that will be running across the message bus.


let (raw_file_tx, raw_file_rx): (Sender<PositionReport>, Receiver<PositionReport>) = bounded(flow_limit);
let (multiline_handling_tx, multiline_handling_rx): ( Sender<PositionReport>, Receiver<PositionReport>) = bounded(flow_limit);
let (ready_for_output_tx, ready_for_output_rx): (Sender<String>, Receiver<String>) =
bounded(flow_limit);

Because of Rust's rules on variable reuse, the channel data type has to be cloned in each thread, but each clone actually refers to the original instance of the message bus.


     extraction_pool.execute(move || {
        let raw_file_rx = raw_file_rx.clone().clone();
        let extract_ready_for_output_tx = extract_ready_for_output_tx.clone();
        let multiline_handling_tx = multiline_handling_tx.clone();
     }

Matching messages

AIS message types determine how ship information is stored in the six-bit payload, so any parsing task has to begin with carving out the type of the current sentence and casting it as an unsigned INT in the appropriate struct field.


line.message_type = pick_u64(&payload, 0, 6);

From there, the message type can be matched against parsing templates and other fields in the struct populated.


match line.message_type {
1 | 2 | 3 => {
// If the message is class A kinetic.
line.mmsi = format!("{}", pick_u64(&payload, 8, 30));
line.latitude = pick_i64(&payload, 89, 27) as f64 / 600_000.0;
line.longitude = pick_i64(&payload, 61, 28) as f64 / 600_000.0;
...
}
5 => {
// If the message is class A static.
line.mmsi = format!("{}", pick_u64(&payload, 8, 30));
line.call_sign = pick_string(&payload, 70, 42);
line.name = pick_string(&payload, 112, 120);
...
}

Arc Mutexes and Hash maps

Assembling multiline messages in multiple threads requires caching sentence fragments in a way that can be shared. This program uses a shared hash-map wrapped in a mutex to hold sentence fragments.


// Initiate Hashmaps for multisentence AIS messages
// These are wrapped by ARC and Mutexes for use under multithreading.
let mut payload_cache: Arc<Mutex<HashMap<String, String>>> =
Arc::new(Mutex::new(HashMap::new()));
let mut source_cache: Arc<Mutex<HashMap<String, String>>> =
Arc::new(Mutex::new(HashMap::new()));
let mut sat_time_cache: Arc<Mutex<HashMap<String, String>>> =
Arc::new(Mutex::new(HashMap::new()));

Like the interprocess channels, the hash-maps must be cloned in each thread instance.


// Initiate Hashmaps for multisentence AIS messages
let payload_cache = Arc::clone(&mut payload_cache);
let source_cache = Arc::clone(&mut source_cache);
let sat_time_cache = Arc::clone(&mut sat_time_cache);

Each hash-map needs a lock defined in each thread to deconflict the reads and delete from multiple threads.


    let mut payload_lock = payload_cache.lock().unwrap();
    let mut source_lock = source_cache.lock().unwrap();
    let mut sat_time_lock = sat_time_cache.lock().unwrap();

    // insert into time cache if struct field is not empty
    if line.satellite_acquisition_time.len() > 0 {
        sat_time_lock.insert(line.group.clone(), line.satellite_acquisition_time);
        }

JSON serialization

The SERDE crate offers a convenient way to serialize a struct to a JSON string. At the end of the parsing cycle, each thread converts the populated struct to JSON for writing to file.


ready_for_output_tx.send(serde_json::to_string(&line).unwrap());

The output of the program can be loaded in Pandas with the following command:


import pandas as pd
df=pd.read_json("output.json", lines=True)

It can also be converted to a compressed Parquet file using use Dominik Moritz's json2parquet program.


json2parquet -c brotli norway.json norway.parquet

Running the program

Executing the program without parameters will output the following:


error: The following required arguments were not provided:
		<INPUT>
		<OUTPUT>

    USAGE:
		rustaise <INPUT> <OUTPUT> [FLOW_LIMIT]
	For more information try --help
	With the --help flag.

    AIS parsing program 1.0
	Scott Syms <ezrapound1967@gmail.com>
	Does selective parsing of a raw AIS stream

	USAGE:
	rustaise <INPUT> <OUTPUT> [ARGS]
	ARGS:
		<INPUT>                Sets the input file to use
		<OUTPUT>               Sets a custom output file
		<FLOW_LIMIT>           Sets a limit on the number of objects in memory at one time (default: 500000)
		<PARSE_THREADS>        Sets the number of threads to use for parsing (default: number of CPUs)
		<MULTILINE_THREADS>    Sets the number of threads to use for multiline parsing (default: number of CPUs)
  	OPTIONS:
		-h, --help       Print help information
		-V, --version    Print version information

Uncompressing the norway.7z program and running the following will generate a JSON file with parsed contents.


rustaise norway.nmea norway.json

The FLOW LIMIT parameter allows you to limit the data held in the message channels. In some memory constrained systems, capping in-flight messages prevents out-of-memory issues. The PARSE_THREADS and MULTILINE_THREADS are optional parameters that provide control over the number of threads created for the single and multiple line parsing threads.

Speed results

Rust lives up to its reputation as a blazingly fast language.

The execution results in the timing table below are obtained from a MacBook 2.3 GHz 8-Core Intel i9 with 32Gb of memory. In the timing table, the row indicates the number of lines in the input file. The first column shows the processing time required to process the sample, and the final column forecasts how much data could be processed in a day at the sample rate.

Figure 3: Timing table - Sample Size, Processing time and Forecasted Volume/Day
Sample Size Timing Forecasted Volume per Day
1 million 7s 12,342,857,142
25 million 65s 33,230,769,230
174 million 435s 34,560,000,000

These figures suggest that the software would be able to process a 50-billion row AIS archive in just under two days, on a single laptop.

Last thoughts

This is my first attempt to do serious programming in Rust and even from a novice's vantage point, there's room for improvement.

  • First, because I have imperfect knowledge of the language, the solution may not be idiomatic, i.e. making the best use of what Rust offers to solve the problem.
  • The program largely ignores Rust's error handling framework. Initializing the struct with default values may unnecessarily consume memory. Leveraging struct methods and custom traits may offer some advantages.
  • Refactoring the code into Rust's library and module format would be a step toward code readability.
  • Finally, Rust offers unit-testing framework that would make the code more maintainable.

Generally, the "juice is worth the squeeze" here. Even with the code's drawbacks, Rust works as advertised and the effort in learning the language is worthwhile in situations where the code will be reused or where execution time is a concern.

Alternatively, developers who want to take advantage of Rust's performance while staying in the
Python ecosystem could use the PyO3Footnote 13 project to create native Python extensions in Rust.

Getting the code

All code is available at Github - ScottSyms/RustAISe.

Please feel free to use it and I'd appreciate any feedback you might have.

Licenses

The software is made available under an Apache 2.0 license.

The archive includes a 7zip compressed sample of AIS data from the government of Norway. It's made available under the Norwegian License for Open Government Data (NLOD) 2.0.Footnote 14

Some of the bitvec manipulation code is taken from Timo Saarinen's nmea-parser packageFootnote 15 which is provided under an Apache 2.0 license.

Scott Syms is a Technical Advisor with Data Science and Artificial Intelligence, a part of SSC's Chief Technology Officer Branch.

Date modified:

Integrated Business Statistics Program (IBSP)

Reporting Guide

This guide is designed to assist you as you complete the 2021 Annual Civil Aviation Survey - Level IV. If you need more information, please call the Statistics Canada Help Line at the number below.

Help Line: 1-877-949-9492

Your answers are confidential.

Statistics Canada is prohibited by law from releasing any information it collects which could identify any person, business, or organization, unless consent has been given by the respondent or as permitted by the Statistics Act.

Statistics Canada will use information from this survey for statistical purposes.

Table of contents

Business or organization and contact information

This section verifies or requests basic identifying information of the business or organization such as legal name, operating name (if applicable), contact information of the designated contact person, current operational status, and main activity(ies).

1. Legal name and Operating name

Legal Name

The legal name is one recognized by law, thus it is the name liable for pursuit or for debts incurred by the business or organization. In the case of a corporation, it is the legal name as fixed by its charter or the statute by which the corporation was created.

Modifications to the legal name should only be done to correct a spelling error or typo.

To indicate a legal name of another legal entity you should instead indicate it in question 3 by selecting 'Not currently operational' and then choosing the applicable reason and providing the legal name of this other entity along with any other requested information.

Operating Name

The operating name is a name the business or organization is commonly known as if different from its legal name. The operating name is synonymous with trade name.

2. Designated contact person

Verify or provide the requested contact information of the designated business or organization contact person. The designated contact person is the person who should receive this questionnaire. The designated contact person may not always be the one who actually completes the questionnaire. If different than the designated contact person, the contact information of the person completing the questionnaire can be indicated later in the questionnaire.

3. Current operational status

Verify or provide the current operational status of the business or organization identified by the legal and operating name in question 1. If indicating the operational status of the business or organization is 'Not currently operational' then indicate an applicable reason and provide the requested information.

4. Main activity

This question verifies the business or organization's current main activity as classified by the North American Industry Classification System (NAICS). The North American Industry Classification System (NAICS) is an industry classification system developed by the statistical agencies of Canada, Mexico and the United States. Created against the background of the North American Free Trade Agreement, it is designed to provide common definitions of the industrial structure of the three countries and a common statistical framework to facilitate the analysis of the three economies. NAICS is based on supply-side or production-oriented principles, to ensure that industrial data, classified to NAICS , are suitable for the analysis of production-related issues such as industrial performance.

The target entity for which NAICS is designed are businesses and other organizations engaged in the production of goods and services. They include farms, incorporated and unincorporated businesses and government business enterprises. They also include government institutions and agencies engaged in the production of marketed and non-marketed services, as well as organizations such as professional associations and unions and charitable or non-profit organizations and the employees of households.

The associated NAICS should reflect those activities conducted by the business or organizational units targeted by this questionnaire only, as identified in the 'Answering this questionnaire' section and which can be identified by the specified legal and operating name. The main activity is the activity which most defines the targeted business or organization's main purpose or reason for existence. For a business or organization that is for-profit, it is normally the activity that generates the majority of the revenue for the entity.

The NAICS classification contains a limited number of activity classifications; the associated classification might be applicable for this business or organization even if it is not exactly how you would describe this business or organization's main activity.

Please note that any modifications to the main activity through your response to this question might not necessarily be reflected prior to the transmitting of subsequent questionnaires and as a result they may not contain this updated information.

If the current NAICS associated with this business or organizations is not correct, please provide a brief description of the main activity and provide any additional information as requested.

Statement of Revenues, Annual - Statement 21 (IV)

Scheduled services

Transportation of passengers or goods, or both, by an aircraft provided by an air carrier that operates the air service and that, directly or indirectly, sells some or all of its seats or part or all of its cargo space to the public on a price per seat, price per unit of mass or price per volume of cargo basis.

Charter services

Transportation of passengers or goods, or both, by aircraft pursuant to a contract under which a person, other than the air carrier that operates the air service, or its agent, reserves a block of seats or part of the cargo space of an aircraft for the person's use or for resale to the public.

Include air ambulance service and the movement of people and goods to logging or heli-logging sites.

Exclude firefighting and heli-logging activities and the movement of people and goods to a firefighting site. (The former Transport Canada TP 8880 document "Starting a Commercial Air Service" outlining a list of activities which are specialty has been replaced with a new document TP 4711 "Air Operator Certification Manual" as of December 2020. A PDF version of volumes of this manual can be requested at: Air Operator Certification Manual – TP 4711)

Fixed wing

Means a power-driven, heavier-than-air aircraft, deriving its lift in flight chiefly from aerodynamic reactions on surfaces which remain fixed. An aircraft having wings fixed to the airplane fuselage and outspread in flight – that is non-rotating wings.

Helicopter

Means a rotary wing, heavier-than-air aircraft, supported in flight chiefly by the reactions of the air on one or more power-driven rotors on substantially vertical axes. A helicopter does not have conventional fixed wings, nor is it provided with a conventional propeller for forward thrust.

Total operating revenue

Include revenue from air transportation services (for example, transportation of passengers, transportation of goods and other flight-related revenue [such as flying training, recreational flying and other specialty flying]) and all other sources.

Updates to the Canadian Housing Statistics Program (46220002)

The Canadian Housing Statistics Program (CHSP) is an innovative data project that provides Canadians with wide-ranging housing statistics by leveraging existing data sources. Key indicators from the CHSP include characteristics of residential properties (assessment value, property type, period of construction, living area) and of their owners (income, age, residency, and immigration status). This webinar will cover updates to the CHSP, including new information on home buyers and expanded geographies.

English webinar:

French webinar:

Wholesale Trade Survey (monthly): CVs for total sales by geography - February 2022

Wholesale Trade Survey (monthly): CVs for total sales by geography - February 2022
Geography Month
202102 202103 202104 202105 202106 202107 202108 202109 202110 202111 202112 202201 202202
percentage
Canada 0.7 0.6 0.7 0.9 0.8 0.6 0.6 0.7 0.6 0.6 1.0 0.8 0.7
Newfoundland and Labrador 0.5 0.2 1.2 2.3 0.3 0.3 0.4 0.4 0.3 0.4 0.4 1.0 0.6
Prince Edward Island 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Nova Scotia 1.7 2.6 4.8 8.1 3.0 2.3 2.5 3.1 2.3 2.2 5.8 2.9 1.7
New Brunswick 2.6 1.1 1.1 1.9 3.4 2.1 1.9 2.4 2.1 4.0 1.4 3.1 0.7
Quebec 1.8 1.9 1.8 3.1 2.9 1.6 1.7 1.6 1.7 1.7 1.9 2.2 1.4
Ontario 1.1 0.9 1.1 1.2 0.9 0.8 1.0 1.0 1.0 0.9 1.7 1.3 1.2
Manitoba 2.4 1.8 2.8 5.3 1.7 0.8 1.1 1.6 1.7 1.3 1.5 1.7 1.5
Saskatchewan 1.6 1.2 0.8 0.7 0.8 0.5 1.3 1.7 1.0 0.8 2.1 0.9 0.3
Alberta 1.2 1.1 1.2 1.4 1.2 1.5 1.1 1.0 1.4 2.1 1.0 1.8 1.6
British Columbia 1.4 1.5 1.3 1.4 1.4 1.5 1.4 1.9 1.2 1.7 1.2 1.5 2.1
Yukon Territory 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Northwest Territories 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Nunavut 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Disaggregated data standards

The Disaggregated Data Action Plan (DDAP) supports intersectional data and representative data collection efforts. Its guiding principles indicate that data and analysis should be at the lowest level of population detail possible and that Statistics Canada approved standards should be used for disaggregation across all platforms. Disaggregated data standards are distinguished by employment equity groups, also known as essential disaggregation groups, and by additional disaggregation priorities.

Employment Equity group standards

Disability status

Standard unchanged/not requiring updates

Standard in developmentFootnote 2

  • Disability type of person with a disability
  • Severity of disability of person with a disability

Ethnocultural diversity

Standard updated for Census 2021

New standard developed for Census 20211

Gender

Standard updated for Census 2021

New standard developed for Census 20211

Indigenous peoples

Standard updated for Census 2021

New standard developed for Census 20211

Standard unchanged/not requiring updates

Additional standards

Business ownership

Standard in developmentFootnote 2

  • Business majority ownership

Children

Standard updated for Census 2021

Standard unchanged/not requiring updates

No specific definition as a standard but classified under 'age of person'

Geography

Standard updated for Census 2021

Immigration

Standard updated for Census 2021

Standard unchanged/not requiring updates

New standard developed for Census 20211

Standard in developmentFootnote 2

  • Non-permanent resident type of non-permanent resident

Low-income

Standard updated for Census 2021

Standard unchanged/not requiring updates

New standard developed for Census 20211

Official languages

Standard updated for Census 2021

New standard developed for Census 20211

Seniors

Standard updated for Census 2021

Standard unchanged/not requiring updates

No specific definition as a standard but classified under 'age of person'

Sexual orientation

New standard developedFootnote

Standard in development2

  • 2SLGBTQ+ status of person

Veterans

New standard developed for Census 20211

Integrated Business Statistics Program (IBSP)

Reporting Guide

This guide is designed to assist you as you complete the 2021 Annual Civil Aviation Survey - Level III. If you need more information, please call the Statistics Canada Help Line at the number below.

Help Line: 1-877-949-9492

Your answers are confidential.

Statistics Canada is prohibited by law from releasing any information it collects which could identify any person, business, or organization, unless consent has been given by the respondent or as permitted by the Statistics Act.

Statistics Canada will use information from this survey for statistical purposes.

Table of contents

Business or organization and contact information

This section verifies or requests basic identifying information of the business or organization such as legal name, operating name (if applicable), contact information of the designated contact person, current operational status, and main activity(ies).

1. Legal name and Operating name

Legal Name

The legal name is one recognized by law, thus it is the name liable for pursuit or for debts incurred by the business or organization. In the case of a corporation, it is the legal name as fixed by its charter or the statute by which the corporation was created.

Modifications to the legal name should only be done to correct a spelling error or typo.

To indicate a legal name of another legal entity you should instead indicate it in question 3 by selecting 'Not currently operational' and then choosing the applicable reason and providing the legal name of this other entity along with any other requested information.

Operating Name

The operating name is a name the business or organization is commonly known as if different from its legal name. The operating name is synonymous with trade name.

2. Designated contact person

Verify or provide the requested contact information of the designated business or organization contact person. The designated contact person is the person who should receive this questionnaire. The designated contact person may not always be the one who actually completes the questionnaire. If different than the designated contact person, the contact information of the person completing the questionnaire can be indicated later in the questionnaire.

3. Current operational status

Verify or provide the current operational status of the business or organization identified by the legal and operating name in question 1. If indicating the operational status of the business or organization is 'Not currently operational' then indicate an applicable reason and provide the requested information.

4. Main activity

This question verifies the business or organization's current main activity as classified by the North American Industry Classification System (NAICS). The North American Industry Classification System (NAICS) is an industry classification system developed by the statistical agencies of Canada, Mexico and the United States. Created against the background of the North American Free Trade Agreement, it is designed to provide common definitions of the industrial structure of the three countries and a common statistical framework to facilitate the analysis of the three economies. NAICS is based on supply-side or production-oriented principles, to ensure that industrial data, classified to NAICS , are suitable for the analysis of production-related issues such as industrial performance.

The target entity for which NAICS is designed are businesses and other organizations engaged in the production of goods and services. They include farms, incorporated and unincorporated businesses and government business enterprises. They also include government institutions and agencies engaged in the production of marketed and non-marketed services, as well as organizations such as professional associations and unions and charitable or non-profit organizations and the employees of households.

The associated NAICS should reflect those activities conducted by the business or organizational units targeted by this questionnaire only, as identified in the 'Answering this questionnaire' section and which can be identified by the specified legal and operating name. The main activity is the activity which most defines the targeted business or organization's main purpose or reason for existence. For a business or organization that is for-profit, it is normally the activity that generates the majority of the revenue for the entity.

The NAICS classification contains a limited number of activity classifications; the associated classification might be applicable for this business or organization even if it is not exactly how you would describe this business or organization's main activity.

Please note that any modifications to the main activity through your response to this question might not necessarily be reflected prior to the transmitting of subsequent questionnaires and as a result they may not contain this updated information.

If the current NAICS associated with this business or organizations is not correct, please provide a brief description of the main activity and provide any additional information as requested.

Balance Sheet, Annual - Statement 20 (II, III)

Financial assets

Current assets

Include:

  • cash, bank balances (including deposits in transit, special deposits for the payments of debts, and so on) and short-term investments due within one year from the date of the balance sheet;
  • current accounts and notes receivable as well as other current assets such as inventories, charges to subscribers on transportation contracts, interests and dividends receivable, and so on.

All other financial assets – (Include investments and special funds.)

Include investments in associated companies, other investments such as investments in stocks, bonds, and so on, and special funds such as equipment purchase funds, funds set aside for such special purposes as contractual deposits, pension funds, self-insurance funds, and so on.

Property and equipment

Operating - property and equipment – (Include capital leases.)

Include:

  • ground property and equipment (including flight equipment) owned and/or under capital leases;
  • the cost of aircraft (airframes), aircraft engines, propellers, components (aircraft communication and navigational equipment) and spare parts that have been purchased outright;
  • the cost of non-airborne communication and meteorological equipment, ramp equipment, maintenance and engineering equipment, surface transport vehicles and equipment, furniture, fixtures and office equipment, buildings and land as well as miscellaneous ground equipment such as medical equipment, airport and lighting equipment, passenger service equipment, hotel, restaurant and food service equipment, storage and distribution equipment. Property and equipment under capital leases includes the cost of property and equipment under a capital or finance lease, in other words, a lease for a period considered to be the whole or nearly the whole life of the property or equipment.

Accumulated depreciation and amortization - property and equipment

Include:

  • accumulated depreciation and amortization of ground property and equipment (including flight equipment) owned and/or under capital leases;
  • accrued charges representing losses, not replaced by current repairs, occurring in physical property and suffered through current lessening of service value due to wear and tear from use and the action of time and the elements; and losses occurring through obsolescence, supersession, new technological developments, changes in popular demand and the requirements of public authority.

Non-operating property and equipment – (Include capital leases.)

Include the cost of all non-operating property and equipment, in other words, all property and equipment not included in the "operating" category above.

Accumulated depreciation and amortization - non-operating property and equipment

Include accumulated depreciation and amortization of the non-operating property and equipment.

All other assets

Include long-term prepayments, developmental and pre-operating costs such as the cost of extraordinary training, unamortized discounts and expenses on the issue of long-term debt securities, property acquisition adjustments, other intangibles such as payments made for patents, copyrights, and so on, and other deferred charges.

Total assets

The sum of the assets above less the accumulated depreciation and amortization.

Liabilities and capital

Current liabilities

Include:

  • current accounts and traffic balances payable, including balances subject to current settlement and payable to associated companies and/or shareholders, and notes payable on demand or within one year from the date of the balance sheet;
  • the current portion of long-term debt and the current obligations under capital leases;
  • air traffic liabilities (unearned transportation revenue), which includes the value of passenger tickets sold but not used or refunded as of the date of the balance sheet, and pre-paid amounts for the transportation of baggage, freight and mail for which the transportation has not occurred as of the date of the balance sheet;
  • salaries and wages accrued and unpaid, taxes accrued and unpaid, dividends payable, deposits by subscribers on transportation contracts (air travel plan liabilities, in other words, deposits received under air travel plan contracts) and other current and accrued liabilities.

Advances from associated companies and/or shareholders

Include the net amount from associated companies and/or shareholders for notes, loans or advances which are not currently settled.

Long-term debt and other non-current liabilities – (Include capital leases.)

Include:

  • the face value or principal amount of debt securities (for example, bonds, trust certificates, debentures, notes) issued and assumed by the air carrier and in the hands of others, which is not payable within twelve months of the balance sheet date;
  • long-term obligations under capital leases, which refers to the present value of unexpired contracts for the acquisition of aircraft under such lease arrangements.

Deferred income taxes

Include taxes that will be owed on income, but that have not yet been assessed.

All other liabilities

Include:

  • deferred credits which correspond to unamortized premiums on all classes of long-term debt, and other deferred credits such as securities issued or assumed by the air carrier, and other unadjusted accounts that cannot be cleared as of the date of the balance sheet;
  • provisions for major overhauls such as for flight equipment (in other words, liabilities of uncertain value or timing associated with the complete disassembly and inspection or repair of an aircraft, engine or other component of an aircraft) and other provisions such as liabilities of uncertain value or timing.

Shareholders' equity

Capital stock

Include the equity capital invested in a business through the purchase of various classes of common and preferred shares.

Retained earnings

Include the portion of after-tax profits left over, after dividends have been paid to shareholders, for reinvestment into the company. If this account is negative, then the amount indicated for this item should be shown with a negative (-) sign.

All other items

Include other paid-in capital and reserves. Other paid-in capital or contributed surplus includes the premiums or discounts that have resulted from selling stock, and stock received from donations. Reserves include any reserve fund such as reserve for self-insurance, reserve for pension, reserves against potential future losses, and so on. Also, include proprietorship or partnership accounts (balance year-end).

Total liabilities and capital

The sum of liabilities and capital plus the sum of shareholders' equity which should equal total assets.

Statement of Revenues and Expenses, Annual - Statement 21 (III)

Operating revenue

Scheduled services

Transportation of passengers or goods, or both, by an aircraft provided by an air carrier that operates the air service and that, directly or indirectly, sells some or all of its seats or part or all of its cargo space to the public on a price per seat, price per unit of mass or price per volume of cargo basis.

Charter services

Transportation of passengers or goods, or both, by aircraft pursuant to a contract under which a person, other than the air carrier that operates the air service, or its agent, reserves a block of seats or part of the cargo space of an aircraft for the person's use or for resale to the public.

Include air ambulance service and the movement of people and goods to logging or heli-logging sites.

Exclude firefighting and heli-logging activities and the movement of people and goods to a firefighting site. (The former Transport Canada TP 8880 document "Starting a Commercial Air Service" outlining a list of activities which are specialty has been replaced with a new document TP 4711 "Air Operator Certification Manual" as of December 2020. A PDF version of volumes of this manual can be requested at: Air Operator Certification Manual – TP 4711)

Passenger revenue

Refers to the revenue earned from the transportation of passengers on scheduled and charter services. Include revenue from all surcharges (baggage, fuel, seat selection, changing or cancelling flights, and so on) that are retained by the air carrier. Exclude amounts such as taxes, navigation fees, security fees, and so on that are collected but passed on to other entities.

Goods revenue

Refers to the revenue earned from the transportation of goods on scheduled and charter services. Exclude taxes such as the Goods and Services Tax (GST), Harmonized Sales Tax (HST) or Provincial Sales Tax (PST).

All other flight - related revenue

Refers to the revenue earned from air transport activities not included in passenger revenue or goods revenue. Include revenue from other flying services such as flying training, recreational flying and other specialty flying.

All other revenue

Include subsidies and revenue earned from all other sources (including contra revenue, revenue of a corporate nature (leasing revenue, third party ground-handling, and so on), ancillary passenger revenue not easily allocated by operating flight (customs brokerage, and so on), revenue from in-flight sales (beverages, food, entertainment and wireless Internet access, and so on)).

Total operating revenue

The sum of passenger revenue, goods revenue, other flight-related revenue and revenue from all other sources.

Operating expenses

Maintenance - ground property and equipment

Expenses incurred in the repair and upkeep of ground property and equipment. Include employee wages, salaries and benefits (including employer contributions to pensions, medical benefits, insurance, and so on), expenses for materials and supplies, purchased repair services and all other related expenses.

Aircraft operations

Expenses incurred directly for the in-flight operation of aircraft or in the holding of aircraft and aircraft personnel in readiness for assignment to an in-flight status.

Include:

  • the wages, salaries and benefits (including employer contributions to pensions, medical benefits, insurance, and so on and layover expenses such as hotels and meals) for flight crews (pilot, co-pilot, navigator, and so on);
  • expenses for turbo fuel, gasoline and all other fuel and oil consumed such as turbine oil and piston oil (including throughput charges, non-refundable duties and taxes);
  • airport landing fees paid both in Canada and outside of Canada;
  • navigation fees remitted to NAV CANADA or other international suppliers for the provision of air navigation services (air navigation services include aeronautical communication services, aeronautical information services, aeronautical radio navigation services, air traffic control services, aviation weather services, emergency assistance services and flight information services);
  • expenses for insurance against accidental damage to flight equipment while in flight or on the ground and for insurance against liability occurring from the operation of aircraft or, in the case of non-insurance, the resulting expenses for which the carrier is liable;
  • expenses incurred for the rental of aircraft (and crew) from other carriers, such as in chartering, interchange and operating or lease agreements;
  • all other aircraft operation expenses incurred directly for the in-flight operation and related standby time of aircraft.

Maintenance - flight equipment

Expenses incurred in the repair and upkeep of flight equipment. Include employee wages, salaries and benefits (including employer contributions to pensions, medical benefits, insurance, and so on), expenses for materials and supplies, purchased repair services and all other related expenses.

General administration

Expenses incurred for in-flight service, aircraft and traffic servicing, promotion and sales and general administration.

Include:

  • the wages, salaries and benefits (including employer contributions to pensions, medical benefits, insurance, and so on and layover expenses such as hotels and meals) paid to cabin crews (flight attendants, and so on), ground personnel, staff engaged in reservations, ticketing, sales and promotional activities and all other employees (including the personnel performing the general and administrative functions of the air carrier);
  • expenses for in-flight service such as passenger food and supplies (in-flight meals, complimentary drinks, and so on and the cost of supplies and personal services furnished to passengers), passenger liability insurance (premiums for passenger liability and accident insurance) and all other in-flight service expenses (including passenger-related expenses incurred due to interrupted flights, including hotels, meals, taxi fares and other expense items, the cost of other services provided to passengers, such as pay, allowances and the cost of passenger service personnel, and all other services provided for the comfort of passengers in transit);
  • expenses for aircraft and traffic servicing purchased from outside suppliers, expenses incurred on the ground for scheduling or preparing aircraft for arrival and takeoff, expenses incurred in enplaning and deplaning passenger and cargo traffic, and expenses involved in servicing and handling individual aircraft and traffic on the ground, in preparing aircraft crews for flight assignment, in controlling the in-flight movements of aircraft and the in-flight expenses of handling all traffic including baggage;
  • all promotion and sales expenses such as passenger and cargo commission expenses (the net commission payable to others for the sale of transportation on the reporting carrier's service less the commission receivable from the reporting carrier's sale of transportation on other carriers' services), advertising and publicity expenses and any related expenses, accommodation costs, agency fees for outside services, expenses associated with reservations, city ticket offices and other sales expenses;
  • general administration expenses such as those for financial accounting activities, supplementary labour income, property taxes, building rentals, communications purchased, purchasing activities, representation at law, and all other operational administration expenses not directly applicable to a particular function that are not included in the previous operating expenses categories;
  • expenses such as incidental air transport-related expenses associated with revenue reported as "all other revenue";
  • staff reduction expenses.

Depreciation

Include:

  • provisions for the depreciation of ground property and equipment (including flight equipment);
  • all charges incurred in normal wear and tear on property and equipment which have not been replaced by current year repair, as well as losses in service ability;
  • charges for the amortization of capitalized development and other intangible assets.

All other expenses

Include any and all miscellaneous operating expenses not reported elsewhere.

Total operating expenses

The sum of the previous six expense items.

Operating income

Net operating income (a loss should be a negative number)

Total operating revenue less total operating expenses – calculated from the previous questions.

Non-operating income/expenses

Interest and discount income

Include interest income from all sources and cash discounts on the purchase of materials and supplies.

Interest expenses

Include interest on unpaid taxes and all classes of debt including premiums, discounts and expenses on short-term obligations, amortization of premiums, discounts and expenses on short-term and long-term obligations.

All other net non-operating income (enter a negative number for a loss)

Include:

  • capital gains (or losses) from retiring operating property and equipment, aircraft equipment, expendable parts, miscellaneous materials and supplies and other assets, when they are sold or otherwise retired from service as part of a general program and not as incidental sales performed as a service to others;
  • gains or losses made on investments in securities;
  • net miscellaneous non-operating income or loss, which refers to revenue and expenses attributable to financing or other activities that are not an integral part of the air transportation activities undertaken by the carrier, or its incidental services. These could include dividend income, the balance of all income or losses from affiliated companies reimbursed to the carrier, foreign exchange adjustments and special items, such as restructuring expenses, which do not occur on a regular basis.

Exclude staff reduction expenses which should be included under all other expenses.

Net non-operating income (a loss should be a negative number)

The sum of the previous three income or expense items.

Provision for income taxes

Include the provision for taxes payable on net income for the accounting period and adjustments of income taxes relating to previous years, including provisions for deferred income taxes resulting from differences between accounting income and taxable income that arise when the time of including items of revenue and expense in the computation of accounting income and taxable income do not coincide. . If the net amount is negative, then the amount indicated for this item should be shown with a negative (-) sign.

Net income (a loss should be a negative number)

Net operating income plus net non-operating income less the provision for income taxes.

Fuel and oil consumed

Turbo fuel consumed

Include fuel used in both turboprop and jet aircraft.

Provide the quantity and expenses for turbo fuel consumed. Turbo fuel includes the turbine fuel uplifted for all aircraft in the carrier's fleet. Fuel uplift can be determined based on delivery notes or invoices, aircraft onboard measurement systems or, if the fuel was supplied by a customer, estimated based on hours flown. Report the quantity of turbo fuel consumed in litres.

Include turbo fuel consumed for all scheduled and/or charter operations, regardless of where purchased. The expenses for turbo fuel consumed should be reported in Canadian dollars, regardless of where purchased. Include throughput charges, non-refundable duties and taxes. If the fuel was supplied by a customer, an approximate value may be provided based on prevailing market rates.

Conversion factor

To convert gallons (imperial) into litres (l), multiply by 4.546092.

Gasoline consumed

Provide the quantity and expenses for gasoline consumed. If the gasoline was supplied by a customer, it may be estimated based on hours flown. Report the quantity of gasoline consumed in litres.

Include gasoline consumed for all scheduled and/or charter operations, regardless of where purchased. The expenses for gasoline consumed should be reported in Canadian dollars, regardless of where purchased. Include throughput charges, non-refundable duties and taxes. If the gasoline was supplied by a customer, an approximate value may be provided based on prevailing market rates.

Conversion factor

To convert gallons (imperial) into litres (l), multiply by 4.546092.

All other fuel and oil consumed

Provide the quantity and expenses for all other fuel and oil consumed. Report the quantity of all other fuel and oil consumed in litres.

The quantity should include turbine oil, piston oil and all other types of fuel and oil consumed for all scheduled and/or charter operations, regardless of where purchased. The expenses for all other fuel and oil consumed should be reported in Canadian dollars, regardless of where purchased. Include throughput charges, non-refundable duties and taxes.

Conversion factor

To convert gallons (imperial) into litres (l), multiply by 4.546092.

Total fuel and oil consumed

The sum of the quantities and expenses reported in the previous three items.

Employment

Average number of employees

Refers to the average number of people employed for each of the six categories of personnel.

Include all employees, temporary or permanent, on the payroll of the air carrier during the reporting period. Include part-time employees, prorated to the amount of time worked when compared to full-time employees (for example, two part-time employees working half-time are equivalent to one full-time employee).

Wages and salaries expenses

Include a breakdown of the wages and salaries paid for each of the six categories of personnel.

Exclude all benefits, in other words, employer contributions to pensions, medical benefits, insurance, and so on or layover expenses, such as hotels and meals, for flight and cabin crews.

Employment category

Include:

  • Pilots and co-pilots. Self-explanatory;
  • Other flight personnel. Flight crew (including flight engineers, navigators, and so on) and cabin crew (including flight attendants, and so on);
  • General management and administration employees (including the personnel performing the general and administrative functions such as administrative personnel at headquarters, comptrollers and assistants, directors and assistants (operations, passenger service, public relations, sales), and so on);
  • Maintenance personnel (including the personnel performing the ground property and equipment maintenance such as the carpenters, cleaners, and so on and including the personnel performing the flight equipment maintenance such as the aircraft maintenance engineers and the inspectors of flight equipment);
  • Aircraft and traffic servicing personnel (including supervisory personnel, assigned to ground activities, engaged directly in protecting and controlling aircraft in flight (flight dispatch personnel, flight planning staff), in scheduling and preparing flight crews for flight assignment, in parking and servicing aircraft incidental to line operations and including baggage handlers, aircraft fuelers, and so on);
  • All other employees (including air ambulance attendants, accountants, economists, statisticians, lawyers, purchasing personnel, publicity representatives, and so on).

Total employees

The sum of the number and the wages and salaries expenses for the six categories of personnel.

Revenue and expenses by area of operation

Passenger revenue

Include a breakdown of the revenue earned from the transportation of passengers for each province, territory and outside of Canada based on where the transportation service was provided. Total passenger revenue should equal the sum of passenger revenue from scheduled services and charter services previously reported.

Goods revenue

Include a breakdown of the revenue earned from the transportation of goods for each province, territory and outside of Canada based on where the transportation service was provided. Total goods revenue should equal the sum of goods revenue from scheduled services and charter services previously reported.

Employee wages and salaries

Include a breakdown of employee wages and salaries for each province, territory and outside of Canada based on where the employees are located. Total employee wages and salaries should equal the total wages and salaries expenses reported in the "Employment" section above.

Scheduled Services, Revenue Operating Statistics, Annual - Statement 10 (III)

Scheduled services - operating statistics

Include fixed wing and helicopter services.

Sector of operation

Refers to the regions where carriers provide transportation services. There are three breakdowns – domestic, transborder (Canada-US) and other international.

Domestic

Includes operations between points in Canada.

Transborder (Canada-US)

Includes operations between points in Canada and points in the United States (including Alaska, Hawaii and Puerto Rico).

Other international

Includes all other operations (including between points outside of Canada).

Data reported must include both fixed wing and helicopter services, where:

Fixed wing

Means a power-driven, heavier-than-air aircraft, deriving its lift in flight chiefly from aerodynamic reactions on surfaces which remain fixed. An aircraft having wings fixed to the airplane fuselage and outspread in flight – that is non-rotating wings.

Helicopter

Means a rotary wing, heavier-than-air aircraft, supported in flight chiefly by the reactions of the air on one or more power-driven rotors on substantially vertical axes. A helicopter does not have conventional fixed wings, nor is it provided with a conventional propeller for forward thrust.

Scheduled services

Transportation of passengers or goods, or both, by an aircraft provided by an air carrier that operates the air service and that, directly or indirectly, sells some or all of its seats or part or all of its cargo space to the public on a price per seat, price per unit of mass or price per volume of cargo basis.

Enplaned passengers

Refers to revenue passengers1 who board aircraft and surrender one or more flight coupons or other documents good for transportation over the itinerary specified in these coupons or documents.

1Revenue passengers correspond to passengers for which an air carrier receives remuneration and who are travelling with tickets purchased (a) under a publicly available promotional offer; (b) through a loyalty program or through the redemption of loyalty points or miles; (c) with a corporate discount or at a preferential fare; or obtained (d) as compensation for denied boarding. It excludes (a) passengers travelling for free, at a fare available only to persons who are employees or agents of an air carrier or are travelling on the business of an air carrier; and (b) persons, such as infants, who do not occupy seats.

Passenger-kilometres

Represents the carriage of one revenue passenger on each flight stage multiplied by the number of kilometres flown on that stage. Passenger-kilometres are obtained by totalling the number of kilometres flown by all passengers.

Let's take an example with two flight stages, where:

Flight stage A to B
Number of passengers = 5
Distance between points (km) = 161
Passenger-kilometres = 805

Flight stage B to C
Number of passengers = 4
Distance between points (km) = 322
Passenger-kilometres = 1,288

The total number of passenger-kilometres for the flights covering A to B and B to C is 2,093.

Conversion factor

To convert nautical miles (6 080 feet) into kilometres (km), multiply by 1.852.

To convert statute miles (5 280 feet) into kilometres (km), multiply by 1.609344.

Hours flown

Represents the block hours, in other words, the number of hours which elapsed between the time the aircraft started to move to commence a flight and the time the aircraft came to its final stop after the conclusion of a flight. Report the total number of block hours flown to the nearest hour.

Enplaned goods

Refers to all types of non-passenger traffic. It includes priority freight, freight, mail and excess baggage for which revenue is obtained. Enplaned goods should be reported to the nearest kilogram.

Conversion factor

To convert pounds (lbs.) into kilograms (kg), multiply by 0.453592.

Goods tonne-kilometres

Represents the carriage of one tonne of goods on each flight stage multiplied by the number of kilometres flown on that stage. Goods tonne-kilometres are obtained by totalling the number of kilometres flown with all tonnes of goods.

Let's take an example with two flight stages, where:

Flight stage A to B
Tonnes of goods = 5
Distance between points (km) = 161
Goods tonne-kilometres = 805

Flight stage B to C
Tonnes of goods = 4
Distance between points (km) = 322
Goods tonne-kilometres = 1,288

The total number of goods tonne-kilometres for the flights covering A to B and B to C is 2,093.

Conversion factor

To convert nautical miles (6 080 feet) into kilometres (km), multiply by 1.852.

To convert statute miles (5 280 feet) into kilometres (km), multiply by 1.609344.

Scheduled services - revenue

Include fixed wing and helicopter services.

Passenger revenue

Refers to the revenue earned from the transportation of passengers on scheduled services. Include revenue from all surcharges (baggage, fuel, seat selection, and so on) that are retained by the air carrier. Exclude amounts such as taxes, navigation fees, security fees, and so on that are collected but passed on to other entities.

Goods revenue

Refers to the revenue earned from the transportation of goods on scheduled services. Exclude taxes such as the Goods and Services Tax (GST), Harmonized Sales Tax (HST) or Provincial Sales Tax (PST).

Charter Services, Revenue Operating Statistics, Annual - Statement 12 (III)

Charter services - operating statistics

Include fixed wing and helicopter services.

Sector of operation

Refers to the regions where carriers provide transportation services. There are three breakdowns – domestic, transborder (Canada-US) and other international.

Domestic

Includes operations between points in Canada.

Transborder (Canada-US)

Includes operations between points in Canada and points in the United States (including Alaska, Hawaii and Puerto Rico).

Other international

Includes all other operations (including between points outside of Canada).

Data reported must include both fixed wing and helicopter services, where:

Fixed wing

Means a power-driven, heavier-than-air aircraft, deriving its lift in flight chiefly from aerodynamic reactions on surfaces which remain fixed. An aircraft having wings fixed to the airplane fuselage and outspread in flight – that is non-rotating wings.

Helicopter

Means a rotary wing, heavier-than-air aircraft, supported in flight chiefly by the reactions of the air on one or more power-driven rotors on substantially vertical axes. A helicopter does not have conventional fixed wings, nor is it provided with a conventional propeller for forward thrust.

Charter services

Transportation of passengers or goods, or both, by aircraft pursuant to a contract under which a person, other than the air carrier that operates the air service, or its agent, reserves a block of seats or part of the cargo space of an aircraft for the person's use or for resale to the public.

Include air ambulance service and the movement of people and goods to logging or heli-logging sites.

Exclude firefighting and heli-logging activities and the movement of people and goods to a firefighting site. (The former Transport Canada TP 8880 document "Starting a Commercial Air Service" outlining a list of activities which are specialty has been replaced with a new document TP 4711 "Air Operator Certification Manual" as of December 2020. A PDF version of volumes of this manual can be requested at: Air Operator Certification Manual – TP 4711)

Enplaned passengers

Refers to revenue passengers1 who board aircraft and surrender one or more flight coupons or other documents good for transportation over the itinerary specified in these coupons or documents.

1Revenue passengers correspond to passengers for which an air carrier receives remuneration and who are travelling with tickets purchased (a) under a publicly available promotional offer; (b) through a loyalty program or through the redemption of loyalty points or miles; (c) with a corporate discount or at a preferential fare; or obtained (d) as compensation for denied boarding. It excludes (a) passengers travelling for free, at a fare available only to persons who are employees or agents of an air carrier or are travelling on the business of an air carrier; and (b) persons, such as infants, who do not occupy seats.

Passenger-kilometres

Represents the carriage of one revenue passenger on each flight stage multiplied by the number of kilometres flown on that stage. Passenger-kilometres are obtained by totalling the number of kilometres flown by all passengers.

Let's take an example with two flight stages, where:

Flight stage A to B
Number of passengers = 5
Distance between points (km) = 161
Passenger-kilometres = 805

Flight stage B to C
Number of passengers = 4
Distance between points (km) = 322
Passenger-kilometres = 1,288

The total number of passenger-kilometres for the flights covering A to B and B to C is 2,093.

Conversion factor

To convert nautical miles (6 080 feet) into kilometres (km), multiply by 1.852.

To convert statute miles (5 280 feet) into kilometres (km), multiply by 1.609344.

Hours flown

Represents the block hours, in other words, the number of hours which elapsed between the time the aircraft started to move to commence a flight and the time the aircraft came to its final stop after the conclusion of a flight. Report the total number of block hours flown to the nearest hour.

Enplaned goods

Refers to all types of non-passenger traffic. It includes priority freight, freight, mail and excess baggage for which revenue is obtained. Enplaned goods should be reported to the nearest kilogram.

Conversion factor

To convert pounds (lbs.) into kilograms (kg), multiply by 0.453592.

Goods tonne-kilometres

Represents the carriage of one tonne of goods on each flight stage multiplied by the number of kilometres flown on that stage. Goods tonne-kilometres are obtained by totalling the number of kilometres flown with all tonnes of goods.

Let's take an example with two flight stages, where:

Flight stage A to B
Tonnes of goods = 5
Distance between points (km) = 161
Goods tonne-kilometres = 805

Flight stage B to C
Tonnes of goods = 4
Distance between points (km) = 322
Goods tonne-kilometres = 1,288

The total number of goods tonne-kilometres for the flights covering A to B and B to C is 2,093.

Conversion factor

To convert nautical miles (6 080 feet) into kilometres (km), multiply by 1.852.

To convert statute miles (5 280 feet) into kilometres (km), multiply by 1.609344.

Charter services - revenue

Include fixed wing and helicopter services.

Passenger revenue

Refers to the revenue earned from the transportation of passengers on charter services. Include revenue from all surcharges (baggage, fuel, seat selection, and so on) that are retained by the air carrier. Exclude amounts such as taxes, navigation fees, security fees, and so on that are collected but passed on to other entities.

Goods revenue

Refers to the revenue earned from the transportation of goods on charter services. Exclude taxes such as the Goods and Services Tax (GST), Harmonized Sales Tax (HST) or Provincial Sales Tax (PST).

2022 submissions

Canadian Perinatal Health Surveillance (001-2022)

Canadian Perinatal Health Surveillance (001-2022)

Purpose: The purpose of this study is to report on Canadian maternal and infant health indicators and their determinants, with a focus on the social determinants of health. Specific research questions include the following:

  • What are the rates of infant/fetal outcomes such as stillbirth, preterm birth and neonatal mortality for various sociodemographic subgroups (e.g., income quintiles, maternal educational attainment, immigrant status) and by birthweight?
  • What are the rates and causes of death among women who have given birth (live or stillbirth) in the 12 months prior to their death? How do these rates compare to conventional maternal mortality statistics?
  • How do the underlying cause of death in vital statistics compare to the diagnoses and interventions recorded in hospital discharge data for pregnancy-related deaths?
  • What are the underlying cause(s) of death for infants in the neonatal and post-neonatal periods, and how do these compare over time?

Output: Only aggregate data that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. Analytical datasets will be placed in the Research Data Centres (RDCs) and access will be granted following the standard RDC approval process. The source datasets will be anonymized and will respect variable restrictions in effect for the source datasets (e.g., hospital, vital statistics, and tax files). Major findings will be used to create research papers for publication in peer-reviewed journals and presentations at workshops and conferences.

Addition of the Canadian Patent Research Database (CPRD) to the Linkable File Environment (LFE) of Statistics Canada (002-2022)

Addition of the Canadian Patent Research Database (CPRD) to the Linkable File Environment (LFE) of Statistics Canada (002-2022)

Purpose: The proposed activity would link the enterprises in the Linkable File Environment (LFE) of the Centre for Special Business Projects (CSBP) to the Canadian Patent Research Database (CPRD) of Economic Analysis Division (EAD).

The initial usage of the linkage of the CPRD and the LFE is a part of the Business Innovation and Growth Support project between the Treasury Board Secretariat of Canada (TBS) and Statistics Canada. BIGS requires the linkage of the CPRD to the LFE so that TBS can evaluate whether government programs and expenditures are efficiently meeting their goals of increasing Canadian innovation, patents, inventions, research and development, and employment in research and development.

Output: : Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside Statistics Canada.

Access to the linked microdata will be restricted to Statistics Canada employees and Statistics Canada deemed employees whose assigned work duties require such access. Deemed employees may access the microdata in short-term projects following the standard approval process for access via Statistics Canada's Federal Research Data Centre (FRDC).

Outputs will include data tables which provide more detailed descriptive statistics regarding the types of enterprises participating in patent applications, and potentially data models to better understand all the determinants of intellectual property development. TBS, Innovation, Science and Economic Development Canada, and other government bodies and researchers will utilize these data products to build more tailored policies, programs and tools to help Canadian enterprises innovate and improve their intellectual property and R&D, with the ultimate goal of boosting Canada's innovation economy and productivity.

Microdata Linkage for the Canadian Fishing Fleet Cost and Earnings Study - phase 3 (003-2022)

Microdata Linkage for the Canadian Fishing Fleet Cost and Earnings Study - phase 3 (003-2022)

Purpose: This study is carried out on a cost-recovery basis by Statistics Canada for Fisheries and Oceans Canada. Its purpose is to develop a methodological framework that will allow Fisheries and Oceans Canada to evaluate the financial performance of a subset of fishing fleets across Canada in a more efficient and cost-effective manner and to test it by preparing aggregate-level statistical tables.

Output: Statistical tables will be prepared at the aggregate level while meeting the confidentiality provisions of the Statistics Act. Only statistics such as averages, standard deviations, etc., will be provided to the client. The linkage will be performed at Statistics Canada by Statistics Canada staff, and the linked files will be kept on a secure, password-protected server.

Analysis of the profile of recipients of a Guaranteed Income Supplement (GIS) mail-out and the determinants of their response through record linkage with Census and T1FF data. (004-2022)

Analysis of the profile of recipients of a Guaranteed Income Supplement (GIS) mail-out and the determinants of their response through record linkage with Census and T1FF data. (004-2022)

Purpose: The main objective of this study is to develop a profile of key socio-demographic characteristics of respondents and non-respondents to the GIS mail-out. The proposed study will link the records of mailing recipient list to their background and survey information from the 2016 Census and income data from the T1 Family File (T1FF). The linkage results will allow us to conduct a comparative analysis of the profiles of the two groups and uncover relevant differences between them. It will also allow us to assess the importance of recipients' personal characteristics and attributes for response to the mail-out and the determinants of response probability.

Output: All access to the linked microdata file will be restricted to Statistics Canada employees (including Statistics Canada deemed employees) whose work activities require access. Only aggregate data that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. The linked outcome files will be made available in Statistics Canada’s Research Data Centre, with access limited to authorized analysts from ESDC Chief Data Office. The results of linked data analyses will be used to inform ESDC senior management, relevant program areas and internal stakeholders on the topic, as well as to advise on outreach activities related to the Reaching All Canadians initiative. Key highlights, high-level findings, and aggregate summary statistics of the data may also be shared with the Office of the Auditor General of Canada upon request.

Exploring the Demographic and Socio-Economic Characteristics Associated with Repeated Convictions among Individuals who have been Supervised by a Correctional Program (005-2022)

Exploring the Demographic and Socio-Economic Characteristics Associated with Repeated Convictions among Individuals who have been Supervised by a Correctional Program (005-2022)

Purpose: The purpose of this microdata linkage project is to explore the extent and nature of new criminal convictions among individuals who have been supervised by a correctional program. This project will also explore the demographic and socio-economic factors associated with repeated convictions, including employment, education, household composition, health, and use of social services. Previous research has shown that a small group of individuals is responsible for a disproportionate amount of crime, and that these individuals are more likely to be economically marginalized, have higher mortality rates, and be hospitalized more frequently. Therefore, understanding the characteristics associated with repeated convictions is important for criminal justice policy, programs, and initiatives aimed at preventing and reducing crime. Furthermore, the current project will inform the development of integrated, multi-agency interventions to improve socio-economic outcomes for at-risk populations.

Output: Analytical files will be used by Statistics Canada to produce non-confidential aggregate statistical tables and analytical reports, such as reports for Statistics Canada's flagship justice and public safety publication, Juristat. Anonymous justice data will also be placed in Statistics Canada's Research Data Centres, along with key files allowing integration with other Statistics Canada files, to facilitate research on the demographic and socioeconomic factors associated with repeated convictions within a secure research environment. Researchers must become deemed employees of Statistics Canada in order to access the files in the Research Data Centres. Additionally, access will only be granted once a research proposal has been approved.

Microdata linkage for community-level analysis of fishing incomes and communities (006-2022)

Microdata linkage for community-level analysis of fishing incomes and communities (006-2022)

Purpose: This study is being carried out on a cost-recovery basis by Statistics Canada for Fisheries and Oceans Canada (DFO). Its purpose is to improve the geographic accuracy of tax files by combining them with census location data at the municipal level to allow DFO to better assess the situation of fishing communities in Canada in order to support policy development and decision making. The outputs will be aggregate-level statistical tables that will allow DFO to evaluate the fishing reliance of communities in British Columbia as a pilot to see if this type of linkage can improve the geographic accuracy of tax data by appending census geographic information.

Output: Statistical tables will be prepared in conjunction with the International Cooperation and Methodology Innovation Centre at the aggregate level while meeting the confidentiality provisions of the Statistics Act. Only aggregate statistics such as counts, percentages and sums will be provided to the client and only after appropriate suppression has been applied. A total of three tables will be provided to the client, one for each tax year of interest, giving information at the community level for all communities in British Columbia for which data can be published. A short report on the methodology and results will also be delivered to the client.

Addition of the Canadian Census of Population to the Linkable File Environment (LFE) of Statistics Canada (007-2022)

Addition of the Canadian Census of Population to the Linkable File Environment (LFE) of Statistics Canada (007-2022)

Purpose: The proposed activity would link the enterprises in the Linkable File Environment (LFE) of the Centre for Special Business Projects (CSBP) to the Census of Population. The initial usage of the linkage of the Census and the LFE is a part of the Business Innovation and Growth Support (BIGS) project between the Treasury Board Secretariat of Canada (TBS) and Statistics Canada. BIGS requires the linkage of the Census to the LFE so that TBS can evaluate whether the federal government support programs to businesses are efficient, equitable, diversified and inclusive for specific population groups, such as women, Indigenous peoples, racialized populations, people with disabilities, single parents and members of official language minority communities.

Output: Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside Statistics Canada. Access to the linked microdata will be restricted to Statistics Canada employees and Statistics Canada deemed employees whose assigned work duties require such access. Deemed employees may access the microdata in short-term projects following the standard approval process for access via Statistics Canada’s Federal Research Data Centre (FRDC).

Outputs will include data tables which provide more detailed descriptive statistics regarding the types of entrepreneurs and workforce of Canadian enterprises for specific population groups benefiting from federal government support. TBS, Innovation, Science and Economic Development Canada, and other government bodies and researchers will utilize these outputs to build and enhance policies, programs and tools that promote fairness, equity and inclusion across the diversity of entrepreneurs and employees, with the ultimate goal of boosting Canada’s economic health, sustainability and productivity.

Assessing the impact of the COVID-19 pandemic and financial support programs on social inequalities in mental health in Canada (008-2022)

Assessing the impact of the COVID-19 pandemic and financial support programs on social inequalities in mental health in Canada (008-2022)

Purpose: The purpose of the project is to establish a national database of Canadian adults experiencing the COVID-19 pandemic, containing detailed information on demographic and socioeconomic characteristics and their pre- and post-pandemic mental health, and receipt of the pandemic related financial programs.

The objective of this proposal is to examine the impacts of the COVID-19 pandemic and associated policy responses on mental health and substance use in the Canadian population. More specifically, using linkages of the annual Canadian Community Health Survey (CCHS) data to administrative health databases, we will assemble a pan-Canadian open cohort of roughly 306,000 adults followed for mental health and substance use outcomes over the study period from 2015-2021, as well as receipt of COVID-19 financial benefits from tax files. External data on burden of the COVID-19 infection (e.g., number of cases, hospitalizations) and response measures (e.g., social distancing rules) at local level will be linked in order to assess their impacts on mental health and substance use in the cohort.

Output: Only aggregate data that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. Analytical datasets will be placed in the Research Data Centres (RDCs) and access will be granted following the standard RDC approval process. The source datasets will be anonymized and will respect variable restrictions in effect for the source datasets (e.g., hospital, vital statistics, and tax files). Major findings will be used to create research papers for publication in peer-reviewed journals and presentations at workshops and conferences.

Evaluation of the Future Skills Cohort Pilots in Canada (010-2022)

Evaluation of the Future Skills Cohort Pilots in Canada (010-2022)

Purpose: This research is conducted by Blueprint organisation for Employment and Social Development Canada (ESDC). The purpose of this linkage project is to better identify which pilots best prepare Canadians for the future of work. The pilots, which vary in design and target population, began in 2019 across the country and many additional pilots will begin at different times until 2024. Some programs will have multiple cohorts that begin programming at different times.

Output: The final product will be comprised of a series of linked outcome files which will reside within Statistics Canada secured access points The linked data will later become available to Statistics Canada deemed employees with approved projects to use in a Research Data Center (RDC). Only non-confidential aggregate statistics that adhere to the confidentiality provisions of the Statistics Act and any applicable requirements of the Privacy Act will be released outside of the RDC, following pre-defined confidentiality vetting rules.

Custom data request: University of Waterloo Bachelor Student Database linked to the Longitudinal Immigration Database (IMDB) and T1 Family Files (T1FF ) (011-2022)

Custom data request: University of Waterloo Bachelor Student Database linked to the Longitudinal Immigration Database (IMDB) and T1 Family Files (T1FF ) (011-2022)

Purpose: The purpose of this project is to create an integrated analytical dataset consisting of undergraduate student administrative data from the University of Waterloo (UoW) from 2005 to 2021, tax data (using the T1 Family File) of the corresponding years and the Longitudinal Immigration Database (IMDB).

Using the University of Waterloo as a case study, this data linkage aims to reveal the roles that international students’ pre-landing experiences play in their status change to permanent residents (PRs) and their subsequent labour market earnings, particularly in comparison with their domestic counterparts graduating from similar academic programs. By doing so, this activity will be of great policy significance, as it will provide direct and robust evidence on how successful immigration policy changes have been over the past years. Such evidence is crucial for evaluating how effective recent immigration policy changes, such as the implementation of the Express Entry System, have been.

Output: Access to the integrated analytical dataset will be made available only to the Univeristy of Waterloo, the client for this project, in the Statistics Canada Research Data Centre (RDC) located within the University of Waterloo campus.

Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside Statistics Canada.

Immigration, Refugees, and Citizenship Canada (IRCC) will receive an analytical report focusing on the impacts of recent immigration policies changes on international students’ transition into the permanent residency and their subsequent labour market performances from the University of Waterloo.

Elections Canada Data Quality Confirmation Study of the National Register of Electors (012-2022)

Elections Canada Data Quality Confirmation Study of the National Register of Electors (012-2022)

Purpose: The purpose of the project is to evaluate the coverage, accuracy and currency of the National Register of Electors (the Register) maintained by Elections Canada. Certain data elements from the Register will be linked to Canadian Vital Statistics – Death records, Immigration records, Visitors records, Labour Force Survey and Census of population 2021 respondent records to conduct the evaluation and produce estimates at a variety of geographic levels (Canada, province/territory, electoral district). The results of the study will inform Elections Canada on the quality of the Register.

Output: Only non-confidential aggregated data and an analytical report that conform to the confidentiality provisions of the Statistics Act and any applicable requirements of the Privacy Act will be released outside of Statistics Canada to Elections Canada.

Edmonton Psychoactive Substance Use Initiative: Linking Edmonton Police Service data with census, health, income, tax, immigration, criminal courts and corrections data. (013-2022)

Edmonton Psychoactive Substance Use Initiative: Linking Edmonton Police Service data with census, health, income, tax, immigration, criminal courts and corrections data. (013-2022)

Purpose: The purpose of this project is to identify common characteristics among individuals accused of psychoactive drug offences, as well as investigate the intersection between those involved in drug-related crime and those who use illicit substances. It will create a better understanding of the characteristics of those individuals at the heart of the illicit drug crisis, to determine possible points of prevention and/or intervention. This work is being conducted for the Edmonton Police Service to assist them to develop a set of concrete recommendations that will improve effectiveness and efficiency in creating a coordinated response to the drug crisis with respect to drug offences and overdoses, as well as deriving a typology for the classification of incidents and individuals at risk of substance overdose. These insights will help inform the development of evidence-based intervention and prevention measures, as well as supports, aimed at reducing future drug overdoses and potentially saving lives.

Output: Only non-confidential aggregate statistics and analyses that will not result in the identification of an individual person, business or organization will be released outside of Statistics Canada. Exact outputs and products are still to be determined, but will be based on the partner's needs to address key research questions. It is anticipated that high-level findings may be shared with the Edmonton Police Service in the form of reports, presentations, data tables, and data visualization dashboards. It is possible that high-level findings may also be published for public use through reports, web tables, data dashboards or other means. In addition, an analytical file without identifiers will be accessed by the Edmonton Police Service, and its research affiliates, via Statistics Canada secure access points.

Integration of parent and child records from the National Longitudinal Survey of Children and Youth (NLSCY) to data from the T1 Family File (T1FF). (014-2021)

Integration of parent and child records from the National Longitudinal Survey of Children and Youth (NLSCY) to data from the T1 Family File (T1FF). (014-2021)

Purpose: The purpose of this project is to answer numerous questions related to parents and children and their outcomes over time, including those that require a long period of observation. These answers can help to improve government program design (for example, parental leave programs) and identify where intervention or solutions could be beneficial (for example, in relation to acceptable levels of air pollution). The NLSCY is Canada's best source of information on children. Linking the NLSCY to the T1FF information of the children and youth and their parents will make it possible to better understand what helps and does not help children over the life course which can benefit the society. Children that are born now will not enter the labour market for another 15 to 30 years, while those of the NLSCY are entering the labour market as we speak.

Output: Dissemination plans may include research papers, data tables, workshops or conferences, media (various forms). Only non-confidential statistical aggregates will be disseminated outside of Statistics Canada.

Intellectual Property Indicators to Measure Innovation (015-2022)

Intellectual Property Indicators to Measure Innovation (015-2022)

Purpose: The proposed activity would link enterprises in the Linkable File Environment (LFE) of the Centre for Special Business Projects (CSBP) to Canadian businesses from the Australian Bureau of Statistics' TM-Link open database of trademarks.

The initial usage of the linkage of the TM-Link and the LFE is a part of the Business Innovation and Growth Support project between the Treasury Board Secretariat of Canada (TBS) and Statistics Canada. BIGS requires the linkage of the TM-Link to the LFE so that TBS can evaluate whether government programs and expenditures are efficiently meeting their goals of optimizing Canadian innovation, trademarks, patents, inventions, research and development, and employment in research and development.

Output: Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside Statistics Canada. Access to the linked microdata will be restricted to Statistics Canada employees and Statistics Canada deemed employees whose assigned work duties require such access.

Outputs will include data tables providing descriptive statistics of enterprises related to intellectual property, and potentially data models to better understand determinants of intellectual property development. TBS will utilize these data products to tailor policies, programs and tools to help Canadian enterprises innovate and improve their intellectual property and R&D, with the ultimate goal of boosting Canada’s innovation economy and productivity.

The impact of the Highly Affected Sector Credit Availability Program on business survival and growth during the COVID-19 pandemic (016-2022)

The impact of the Highly Affected Sector Credit Availability Program on business survival and growth during the COVID-19 pandemic (016-2022)

Purpose: This project will enable an analysis of businesses that participated in the Highly Affected Sector Credit Availability Program (HASCAP). It relies on the linkage of the HASCAP data to Statistics Canada’s Business Register, monthly business openings and closures data and the National Accounts Longitudinal Microdata File. Using monthly data, the linkage will allow researchers to examine business survival and employment growth among businesses that participated in the HASCAP, while taking into account financial characteristics of these businesses. The analysis will also take into account the effect of other government support programs, such as the Canada Emergency Wage Subsidy, the Canada Emergency Business Account and the Canada Emergency Commercial Rent Assistance.

Output: Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. The information will be presented in the form of tables of regression results and summary statistics. The anonymized analytical file, will be accessed by Statistics Canada deemed employees at the Statistics Canada Business Data Access Centre (BDAC).

Linkage of the Annual Survey of Manufacturers to the General Index of Financial Information (017-2022)

Linkage of the Annual Survey of Manufacturers to the General Index of Financial Information (017-2022)

Purpose: This study will analyse the impact of interprovincial trade agreements on firms' productivities. It will also measure the productivity differences of firms that trade internationally and/or interprovincially from those that only trade within a province or territory. The findings will help determine which of the interprovincial trade policies has achieved its desired goals, which will guide current/future policies to be amended/created.

Output: Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. The information will be presented in the form of tables of regression results and summary statistics related to the project’s goal.

The anonymized analytical file, will be made available via Statistics Canada Secure Access Points (such as RDCs), and access will be granted to Statistics Canada deemed employees following the standard approval process.

2021 Census of Agriculture to 2021 Census of Population Data (018-2022)

2021 Census of Agriculture to 2021 Census of Population Data (018-2022)

Purpose: Linking selected 2021 Census of Population variables to the 2021 Census of Agriculture will provide a great depth of socio-economic information on farm operators, their families and their households, without increasing respondent burden.

Output: The linkage of 2021 Census of Agriculture to the 2021 Census of Population will be used to produce estimates for dissemination as part of the product line from the 2021 Census of Agriculture. Only aggregate statistical estimates that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. Outputs will include Common Output Database Repository (CODR) tabulations to be released on the Statistics Canada website, ad-hoc data requests from clients on demand, as well as other analytical, research or technical articles that may be released.

The Canadian Agricultural Financial Statistics Section of the Agriculture Division will use the aggregated data from this linkage to calculate the income-in-kind estimate for the Net Farm Income as part of the requirements for the Statistics Canada’s System of National Accounts.

Addition of the Longitudinal Immigration Database (IMDB) to the Linkable File Environment (LFE) (019-2022)

Addition of the Longitudinal Immigration Database (IMDB) to the Linkable File Environment (LFE) (019-2022)

Purpose: This linkage will support governmental and societal efforts to address inequities and promote fairness and inclusion in decision making, through the comparison of enterprises that have received government support to those that have not. Enterprise-level derived indicators will be developed to generate statistics on the characteristics and success of enterprises over time, that have received government supports versus those that have not, assessing the extent to which government support programs have aided immigrant employees and immigrant enterprise owners integrate into the Canadian economy.

Output: Only non-confidential aggregate statistical outputs and analysis that conform to the confidentiality provisions of the Statistics Act will be released outside Statistics Canada. The linked analysis file will be made available for access by Statistics Canada deemed employees via the standard approved process of Statistics Canada’s Business Data Access Centre.

The Business-Employee Analytical Microdata (BEAM) Initiative (020-2022)

The Business-Employee Analytical Microdata (BEAM) Initiative (020-2022)

Purpose: The purpose of this project is to create a standard extraction of matched employer-employee data and make it available in Statistics Canada’s Research Data Centres (RDCs) across Canada. The new extraction, built from the Canadian Employer-Employee Dynamics Database (CEEDD), can reduce costs and barriers to data access and make such data available to a much wider research community; improve efficiency in StatsCan’s service delivery; and accommodate standard research needs, supporting more research using disaggregated data on the Canadian economy and labour market to help Canadians make evidence-based and informed decisions.

Output: The outputs of the BEAM extraction include a set of files at the individual and business-enterprise level that covers the population of individual and business tax filers. The full coverage of individual and business tax filers, instead of being a random sample, is necessary to generate sufficiently large sample in order to produce information for finely disaggregated groups. Having information on the characteristics of individuals and businesses, the BEAM can support Statcan’s Disaggregated Data Action Plan by allowing more researchers greater access to disaggregated data and more opportunities to conduct research using disaggregated data so as to shed more light on inequality and inclusion in Canadian society and economy.

The data linkage and extraction will be preformed by Statistics Canada employees only. All personal and business identifiers will be removed and replaced by synthetic identifiers. Other direct identifiable information of individuals and businesses such as names, addresses etc. will be removed. The final outputs will be made available in the RDC secured access points. Data access, for researchers as Statistics Canada deemed employees, will need to have an approved research proposal that justifies why they need to use the data in the BEAM, following the standard data access approval process. Only non-confidential aggregate statistics and analysis conforming to the confidentiality provisions of the Statistics Act will be released outside of RDCs.

The Business-Employee Analytical Microdata (BEAM) Initiative (020-2022)

The impact of increasing education through the Future to Discover Project on Canadians’ Health Outcomes and their Contact with the Judicial System (021-2022)

Purpose: In this extension of the Future to Discover (FTD) project, we seek to link data to support long-term analysis of whether the FTD group who received more education as a result of better information about career choices, as a result of a promise of financial incentives, or as a result of receiving both, compared to the control group (who received neither) have different health outcomes and contact with the judicial system at age 30 and older. This study seeks to contribute to the literature on the social determinants of health and crime.

This study would attempt to fully explore the impact of programs incentivizing finishing high school and attending postsecondary education on health outcomes and contacts with criminal courts. 

The unique structure of the FTD experiment would allow this study to greatly contribute to understanding of the relationship between education—often-cited as a key social determinant of health and crime—and health outcomes and contacts with criminal courts, which are very rarely informed by genuinely experimental data sources.

Output: Only aggregate data that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. Analytical datasets will be placed in the Research Data Centres (RDCs) and access will be granted following the standard RDC approval process. The source datasets will be anonymized and will respect variable restrictions in effect for the source datasets (e.g., hospital, vital statistics, and tax files). Major findings will be used to create research papers for publication in peer-reviewed journals and presentations at workshops and conferences.

The Impact of Export Development Canada Client Services on Firm Performance (022-2022)

The Impact of Export Development Canada Client Services on Firm Performance (022-2022)

Purpose: : Export Development Canada (EDC) offers insurance and financing services to help Canadian exporters grow and compete. This study will provide a better understanding of the effectiveness of the EDC’s services in helping Canadian businesses increase exports, employment, profits and other measures of economic performance.

Output: Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. The information will be presented in the form of tables of regression results and summary statistics related to the project’s goal of evaluation EDC’s client services. Summary reports on the quality of the record linkage and on the results of the analysis will also be produced for EDC. A researcher employed at EDC will access the anonymized linked data at a Federal Research Data Centre (FRDA), as a Statistics Canada deemed employee under the Statistics Act, and following the required approval procedures for accessing Statistics Canada’s secure access points.

Linkage of the 2017 & 2021 Farm Management Survey (FMS), 2016 & 2021 Census of Agriculture (CEAG) and 2016 - 2020 Agriculture Taxation Data Program (ATDP) (023-2022)

Linkage of the 2017 & 2021 Farm Management Survey (FMS), 2016 & 2021 Census of Agriculture (CEAG) and 2016 - 2020 Agriculture Taxation Data Program (ATDP) (023-2022)

Purpose: The main objective of this project is to identify and quantify agricultural best management practices (BMPs), and to analyze key characteristics and trends of farms adopting them and those that do not. The linkage between the FMS, the CEAG and the ATDP will enable a detailed assessment of BMPs and farm financial performance, a topic of interest at Statistics Canada and for several external partners. The public benefit of this linkage is that it will contribute to targeting policy intervention aiming at reducing greenhouse gas emissions and increase carbon storage capacity through agricultural practices. Furthermore, the publication of a short report online will help inform the public on trends relating to agricultural BMPs.

Output: Only non-confidential aggregate statistical outputs and analysis that conform to the confidentiality provisions of the Statistics Act will be released outside Statistics Canada. The output will be custom tables and analysis comparing agricultural BMPs adopters and non-adopters, including a summary of key technical and socio-economic statistics and other important information, along an analysis profiling BMPs adopters and non-adopters. This linkage will also provide a convenient way for further research on the BMPs using the product of this linkage.

Canadian Advanced Technology Sector Dynamics Database (CATSDD) (024-2022)

Canadian Advanced Technology Sector Dynamics Database (CATSDD) (024-2022)

Purpose: The purpose of the project is to map, profile and evaluate the contribution and performance of technological innovation ecosystems in Canada and monitor how the high-tech sector is growing and affecting non-high-tech sector and employment structure in Canada.

In the initial usage of this linkage Statistics Canada's Investment, Science and Technology Division will analyze the concentration-in-enterprise of Science, Technology, Engineering and Mathematics (STEM) workers, venture capital investment and intellectual property assets and establish thresholds differentiating between high-tech and non-high-tech enterprises. This will allow Statistics Canada to analyse the structural changes to Canadian industries and labour skills resulting from technological changes, inform about the rural-urban divide, the labour participation of employment equity groups and improve Science, Technology and Innovation surveys precision and quality, therefore, reducing respondent burden and related costs for Canadians.

Output: Only non-confidential aggregate statistical outputs and analysis that conform to the confidentiality provisions of the Statistics Act will be released outside Statistics Canada.

These outputs will include aggregate statistical tabulations showing aggregates of revenue and employment, research and development, employment of STEM and non-STEM, share of employment equity group in total employment, venture capital investment, and patents for high-tech and non-high-tech sectors.

Pilot project: National Housing Strategy linkage to administrative tax and immigration, Census and Canadian Housing Survey (025-2022)

Pilot project: National Housing Strategy linkage to administrative tax and immigration, Census and Canadian Housing Survey (025-2022)

Purpose: CMHC has developed a research plan to better understand the characteristics of persons and households living in housing receiving support from the National Housing Strategy (NHS) initiatives, as well as the impact(s) that these initiatives have on the inhabitants. As part of this plan, a linkage between the NHS program files to multiple data sources held by Statistics Canada will be performed. Combining information from several sources (tax, employment, immigration, housing and the Census), a resulting linkable dataset will enable analyses of the characteristics, housing needs and outcomes of households and persons living in housing constructed or renovated under NHS initiatives. This is a pilot project which will inform the feasibility of using similar methodology for NHS program evaluation in future years, as well as the extent to which the output dataset supports other analytical projects related to social and affordable housing. Analytical work in this domain is expected to help researchers, the general public and government to understand and to improve housing policies or programs.

Output: The analytical file, once personal identifiers removed, along with anonymized linkage keys will be placed in the Research Data Centres for access by Statistics Canada personnel and deemed employees whose work activities require access. Only non-confidential, aggregated data tables and model outputs, conforming to the confidentiality provisions of the Statistics Act and any applicable requirements of the Privacy Act, will be released.

Profiles of Victims of Gang Violence: Analysis of a BC Cohort (026-2022)

Profiles of Victims of Gang Violence: Analysis of a BC Cohort (026-2022)

Purpose: The objective of the project is to identify key risk factors associated with the likelihood of becoming a victim of gang-related violence by linking records found in administrative data sources. Analysis of data that spans the life course of the victims will allow for a better understanding of the characteristics of those individuals who become involved with gangs, and in identifying these, key intervention points along the life calendar might be identified.

Output: The findings of this project will be delivered to the CFSEU-BC in the form of an analytical report. This report may also be published in a publicly available academic article in Statistics Canada’s Juristat publication. Analytical datasets will be placed in Statistics Canada’s Research Data Centres (RDCs) and access will be granted following the standard RDC approval process. No analytical datafile will be released. Only non-confidential aggregate statistics and analyses that will not result in the identification of an individual person, business or organization will be released outside of Statistics Canada.

Linkage of the Canadian Employer Employee Dynamics Database to the Canadian Survey on Disability (027-2022)

Linkage of the Canadian Employer Employee Dynamics Database to the Canadian Survey on Disability (027-2022)

Purpose: The project will fill data gaps related to the economic outcomes of persons with disabilities. Specifically, it will allow the production of novel nationally-representative statistics that can be used to measure and monitor the economic outcomes of persons with disabilities.

Output: The anonymized analytical file will only be available to Statistics Canada employees whose work duties require access. Only non-confidential aggregate statistical outputs and analyses that conform to the confidentiality provisions of the Statistics Act will be released outside of Statistics Canada. All information will be presented in the forms of tables or figures of regression results or summary statistics related to the project’s goal.