Wikidata

Wikidata:WikiProject Open Government Data

The goal of this WikiProject is to add notable data published by governmental organizations to the Wikidata ecosystem.

There are many open data sets describing the condition and development of cities, regions (e.g., Swiss cantons, German states, Spanish provinces and autonomous communities) and countries. Take as an example the city of Zurich (with 352 data sets) and the canton of Zurich (with 564 data sets).

In the context of this WikiProject we would like to:

  • discuss the motivations that OGD (Open Government Data) organizations have to bring their data into Wikidata
  • identify needs of OGD organizations
  • discuss with the Wikidata community the relevance of available OGD data
  • design and implement reusable solutions (e.g. methodologies, templates or software tools) to import data into Wikidata
  • encourage citizens to edit (either manually via the wiki, or with the help of tools) item pages about the place they live and the area they know best
  • propose new properties that might be necessary to add data to Wikidata
  • build standalone Wikibase instances for specific data sets that may be not suitable for Wikidata
  • document the progress, share lessons learned and generate HowTo-s that OGD organizations could use to implement similar approaches.

We will mainly focus on Wikidata, but due to the connectivity of Wikidata with other Wikimedia projects, we also foresee edits in Wikimedia Commons, Wikipedia and Wikivoyage. Moreover, we are also open to extend the action plan to civic initiatives generating data about cities.


Participants edit

The participants listed below can be notified using the following template in discussions:
{{Ping project|Open Government Data}}

Data Modelling edit

Relevant Properties edit

We now have open data portal (P8402) - Salgo60 (talk) 12:18, 4 July 2020 (UTC)[reply]

Canada edit

  • Government agencies such as Statistics Canada provide access to datasets virtually and per request.
 Datasets can be looked at by subject on the StatsCan website https://www.statcan.gc.ca/eng/start.Lisa Long


Within each subtopic in this subject, there is the option to view data, analysis and reference materials for the sub-topic. One of the subtopics available for Indigenous statistics are:

Datasets are provided here that provide information on those accused of various crimes, crime rates broken down by type of crime, and admission rates and numbers for correctional facilities. Reference material for this subtopic is provided in the form of an article that discusses the methodology used to collect the data for these datasets (https://www150.statcan.gc.ca/n1/en/catalogue/85-564-X). Lisa Long


In this subtopic, datasets are provided that look at the educational level of Indigenous populations that live either on or off the reservation. interestingly though there is a subtopic for Labour force and a subtopic for Indigenous children statistics analysis and datasets in this subtopic also cover these areas by providing datasets on indigenous po[pulations within the labour force as well as analysis of data on the early motherhood rates within indigenous communities. Lisa Long


In this subtopic datasets that deal with the Aboriginal Household Survey can be found amongst other datasets. This survey has been proven to be problematic in its data collection. M. Morris[1] in his 2016 article discusses how this survey fails to provide data on specific regions but rather lumps communities together under the umbrella of being indigenous. Another point Morris (2016) brings forward is that this survey as well as the National Household survey in Canada, does not include data on those whole reside in collective dwellings such as prisons, where a disproportionate number of the indigenous populations resides. Morris( 2016) draws attention to many other issues within statistics Canada and their data collection and presentation with regards to the indigenous population, however, one of the more interesting points he makes is with regards to access to this information. Morris ( 2016) points out that access to the data produced by these surveys and in-depth understanding of the analysis often requires specialized training and typically is most accessible through a university. meaning that without the required training and available technology, Indigenous peoples will be unable to access, interpret or use data that is supposed to represent them. This is something that is not openly addressed within the Statistics Canada website. Lisa Long


  • It should also be noted that while many of these datasets are openly available within the Statistics Canada website. Some content such as the NHS Aboriginal Population Profile from 2011 has been archived and others such as the Aboriginal Peoples Survey from 2017 can be ordered by filling out a form. Some of these orders require payment however those that are considered "Microdata" do not. There is no fee to ship within Canada but international delivery does require a charge. Lisa Long


  1. ↑ 1

Morris, M. (2016). Statistics Canada data collection on Inuit: The importance of consultation and context. Aboriginal Policy Studies, 5(2), 136-148. https://ejournals.library.ualberta.ca/index.php/aps/article/view/25452

( Section on Indigenous Statistics by Lisa Long


Information Types include data tables, analyses, articles and reports, and surveys and statistical programs as well as notices and consultations. Information can be further subdivided by geography (Canada, or Province or Territory), or by current Statistical Surveys or Programs. Results can be sorted by data, relevance or title. The Government related data is divided into six (6) sub-categories:

Examples of Surveys or Program samples include Bank of Canada; Canadian government ginance statistics; consolidated government financial assets and liabilities. Note that some content has been archived, and is not current but provides useful historical context. Some current content provides data related to federal, provincial and municipal budgets, operations and spending and liabilities, and several data tables provide longitudinal information that is helpful for further analysis of Open Government principles. Data tables are current to June 2020.Laurelle LeVert

Examples of Surveys or Programs include labour force surveys, public sector employment data, and pubic service employee survey. Data in this section is largely archived, with the most recent data table from 2013. Laurelle LeVert

Examples of Surveys or Programs (some overlapping with the Balance Sheets sub-category) include: Bank of Canada; Canadian government financial statistics; control and sale of alcoholic beverages; finances of government business enterprises; national balance sheet accounts; and national GDP by income. Interesting data examples include per capita sales of alcoholic beverages and related revenue data; financial statistics by industry; and historical financial data on government business enterprises back to 1926. Data in this section is partially archived, and data tables are current to June 2020. Laurelle LeVert

Examples of Surveys or Programs (some overlapping with the Balance Sheets sub-category) include: Bank of Canada; financial flow accounts; national balance sheet accounts; and national tourism indicators (specifically data on exchange rates). Many data sets provide longitudinal data covering several years. Interesting data examples include daily average foreign exchange rates, consumer credit data, residential mortgages, bonds. Data in this section is partially archived, and data tables are current to June 2020. Laurelle LeVert

Examples of Surveys or Programs include: federal science expenditures; provincial and territorial gross GDP; scientific activities of provincial research organizations; national tourism indicators; and survey of federal government expenditures on culture. Many data sets provide longitudinal data covering several years. Interesting data examples include government revenue attributable to tourism (2011); Canadian classification of functions of government; government spending on environmental protection; and Canadian government finance statistics for colleges and universities. Data in this section is partially archived, and data tables are current to June 2020. Laurelle LeVert

As a holding place for other categories of government related data, data in this section overlaps or intersects partially with other sections. It also includes conceptual material such as Statistics Canada Data Strategy; survey data on voter turnout; stakeholder consultation data; and data on waste management industries. Data in this section is partially archived, and data tables are current to June 2020. Laurelle LeVert

In this subject, 6 subtopics are listed, each of them has powerful navigation features such as different filters for information seekers. Users can filter data based on the type of results (data tables, analysis, and references), geography (federal or provincial), survey or statistical program and content.

In this subtopic, the majority of datasets derived from the travel survey of residents of Canada, and data are collected from various perspectives such as trip purposes, average domestic fares, type of expenditures, number of provinces visited, number of census metropolitan areas visited, and mode of transportation. Several datasets are aggregated and displayed in different time periods. References are the main sources of reports and one interesting example is the travel attitude and motivation study, which collects domestic travelers' psycholinguistic phenomena. All the analytical reports are out-of-date and have already been archived. Yifan Liu

In this subtopic, datasets are provided based on two main groups, one is non-resident travelers and another is Canadian residents. Some trip characteristics include the length of stay, type of transportation, country of residents, and province of entry. All the data will be updated on a regular basis. There also have a dashboard to visualize the travel condition during the Covid-19 and travel-related cases will be highly monitored. Examples of survey and statistical programs include frontier counts, national tourism indicators, visitor travel survey. Yifan Liu

Only 3 datasets are provided in this section, they mainly describe the current employment situation in the tourism market such as the number of jobs generated by the local tourism, labor compensation per job, and the provincial and territorial GDP affected by the tourism industry and other related measures. The Provincial and Territorial Tourism Satellite Account (PTTSA) is a great data visualization to reveal the importance of tourism in terms of expenditure, GDP, and employment (https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2018011-eng.htm). Most reports are explored from the human resource module of the annual tourism satellite account and no reference materials are available currently. Yifan Liu

Among the given datasets, a bunch of indicators is mentioned, and some examples such as tourism demand both in constant prices and current prices, supply of tourism commodities in constant and current prices, tourism share of GDP, and government revenue attribute to the tourism are used as the measurements to analyze the Canadian tourism industry. One great reference is the National Tourism Indicators (NTI), which is a reliable and official document and provides timely information about tourism activities. Yifan Liu

In this part, most data are collected via the Canadian Travel Survey and travelers' traveling habits are mainly analyzed. Some of the measurements are listed: type of trip, length of stay; type of transportation; the purpose of trips; accommodation used; places visited; expenditure by categories. In addition, data collected in different time periods can be applied for the comparison and show a tendency or change in the tourism industry during the last 10 years. Except for the data, some analytical reports are provided as supplementary materials such as the leading indicators of international air travel and benefits from pleasure travel. Yifan Liu

Multiple relevant topics are generated in this section. It includes accommodation services as well as the traveller accommodation services price index (TASPI), traffic volume ranked by city-pair, and travel arrangement services. Another great message is that some researchers have contributed to the study of tourism and explored some relations between tourism and other industries such as agriculture and the spread of local culture. One nice reference is about the study of Canadian adventure travel sector including its operations, which is an emerging category of tourism. Yifan Liu


  • Statistics Canada also offers Crime and Justice statistics

https://www.statcan.gc.ca/eng/subjects-start/crime_and_justice

  • Within each subtopic in this subject, there is the option to view data, analysis and reference materials for the sub-topic. There are four subtopics available for Crime and Justice are:

Information provided in this subtopic includes adult and youth correctional services. Examples of surveys and programs include Canadian Correctional Services Survey, Youth Custody and Community Services, and Corrections Key Indicator Report for Adults and Youth. Examples of datasets include youth admissions to and releases from correctional services; average counts of young persons in provincial and territorial correctional services; and operating expenditures for adult correctional services. A useful data visualized tool provided is the correctional services statistics interactive dashboard. The dashboard provides and overview of adult and youth corrections in Canada. Information can be filtered by average daily counts and community and custodial admissions. Datasets for both adult and youth correctional services are relatively current to November, 2019. Alison Hurd

This subtopic contains information related to adult criminal courts, youth courts, civil courts, and legal aid. Examples of surveys and programs include Adult Correctional Services, Civil Court Survey, and Courts Resources, Expenditures and Personnel Survey. Examples of datasets included under this subtopic include court workload indicators, adult criminal courts, by caseload and age of cases; civil court cases, by level of court and type of case, Canada and selected provinces and territories; and youth courts guilty cases by most serious sentence. Alison Hurd

Crimes and offences includes crime rates, crime severity index, hate crimes, homicides and sexual assaults. Examples of Crimes and offences surveys and programs include Adult Correctional Services, Canadian Correctional Services Survey, and Homicide Survey. An interesting data example is the Canadian Community Crime Tracker (CCCT) which is a data visualization tool that is easily interpretable by presenting key indicators from crime based on police-reported data. Data can be filtered by national, provincial, territorial and municipal levels allowing for comparison of location, crime and population. Data tables are current to June 2020 with a largely archived database. Alison Hurd

The victimization subtopic includes family violence, transition home, victim services, victimization of children and youth, seniors, and women. Examples of victimization surveys and programs include Canadian Survey on Disability, Canadian Victim Services Indicators, Victim Services Survey and Violence against Women Survey. Data examples include victims of police-reported violent crime and traffic violation causing bodily harm or death by type of violation either by age and/or sex of victim; number of victims of solved homicides, by type of accused-victim-relationship; and number of victims of spousal homicide. Data tables are current to June 2020 with a largely archived database. Alison Hurd

Found within this category, there are 6 subcategories found within that provide the option to view data, analysis and reference materials for the subcategory.

  • Care and Social Support

https://www150.statcan.gc.ca/n1/en/subjects/seniors_and_aging/care_and_social_support

This subcategory has data broken down into 17 tables or public use microdata from the General Social Survey Cycle 16: Aging and Social Support (2002). Data can be segregated nationally or by province. The statistical programs or surveys used to collect data were were:

* Annual Demographic Estimates: Canada, Provinces and Territories * Canadian Community Health Survey – Healthy Aging * General Social Survey – Caregiving and Care Receiving * Vital Statistics – Death Database James MacKinnon

  • Elder Abuse and Victimization

https://www150.statcan.gc.ca/n1/en/subjects/seniors_and_aging/elder_abuse_and_victimization

The data in this subcategory is derived from 11 articles and reports. The three most recent are: Family Violence in Canada: A Statistical Profile (2018), Victimization of older canadians (2009) and Seniors as victims of crimes (2007). The data here can only be viewed nationally. The surveys or statistical programs used where:

* General Social Survey – Victimization * Homicide Survey * Survey of Safety in Public and Private Spaces * Uniform Crime Reporting Survey James MacKinnon

  • Health and Disability Among Seniors

https://www150.statcan.gc.ca/n1/en/subjects/seniors_and_aging/health_and_disability_among_seniors

The data here broken down in three tables: Healthy Aging Indicators, 2007 General Social Survey: Care Tables and 2002 General Social Survey Cycle 16: Aging and Social Support. As well, it takes its public use microdata from the Canadian Community Health Survey – Healthy Aging; Public use Microdata file.

The analysis of this data is extensive, coming from over 50 articles and reports. The three most recent articles are: Nutritional risk, hospitalization and mortality among community-dwelling Canadians aged 65 and older, Research Highlights on Health and Aging and Understanding Seniors Risk of Falling and Their Perception of Risk.

The Survey or Statistical Programs used to collect the data are:

* Canadian Community Health Survey – Annual Component * Canadian Community Health Survey – Healthy Aging * Canadian Health Measures Survey * Canadian Survey on Disability * General Social Survey – Caregiving and Care Receiving * General Social Survey – Time Use * National Population Health Survey: Health Institutions Component, Longitudinal * National Population Health Survey: Household Component, Longitudinal * Program for the International Assessment of Adult Competencies * Survey of Household Spending * Vital Statistics – Death Database James MacKinnon

  • Housing and Family and Household Characteristics of Seniors

https://www150.statcan.gc.ca/n1/en/subjects/seniors_and_aging/housing_and_family_and_household_characteristics_of_seniors

The data in this subcategory is provided in 11 tables. The 2 most recent are: Senior Census families by family type and age of older partner, parent or individual, Tax fillers and dependants in senior census families by family type, sex and age.

Here data can be grouped nationally, by province or territory by census metropolitan area, census agglomeration, census metropolitan area part, census agglomeration part.

The survey or statistical program used to collect the data are:

* Annual Income Estimates for Census Families and Individuals * Canadian Community Health Survey – Annual Component * Canadian Community Health Survey – Healthy Aging * Census of Population * General Social Survey – Caregiving and Care Receiving * General Social Survey – Family * National Household Survey * Survey of Labour and Income Dynamics James MacKinnon


  • Income, Pensions and Wealth

https://www150.statcan.gc.ca/n1/en/subjects/seniors_and_aging/income_pensions_and_wealth

The data in this subcategory are presented in 7 tables. The three most recent are: Tax Filers and Dependants, Seniors with Income by Source of Income and Age, Sources of income of senior census families by family type and age of older partner, parent or individual, and Old age security pension and guaranteed income supplement income for adults with disabilities.

The data is also presented in 41 Articles and Reports. The three most recent are: Results from the 2016 Census: Examining the effect of public pension benefits on the low income of senior immigrants, Debt and assets among senior Canadian families, and Market Behaviour Versus Tax Planning Responses to Changes in Marginal Income Tax Rates Among Older Couples.

Here data can be grouped nationally, by province or territory by census metropolitan area, census agglomeration, census metropolitan area part, census agglomeration part.

The survey or statistical program used to collect the data were:

* Annual Income Estimates for Census Families and Individuals * Canadian Survey on Disability * Census of Population * Consumer Price Index * General Social Survey – Caregiving and Care Receiving * Longitudinal Administrative Databank * Longitudinal and International Study of Adults- * Pension Plans in Canada * Retirement Savings Data * Survey of Consumer Finances * Survey of Financial Security * Survey of Household Spending * Survey of Labour and Income Dynamics * Workplace and Employee Survey James MacKinnon

  • Work and Retirement

https://www150.statcan.gc.ca/n1/en/subjects/seniors_and_aging/work_and_retirement

The data in this subcategory is presented in the table: the Retirement age by class of worker, annual. There is also microdata that can be accessed, they are: Survey of Older Workers: Public Use Microdata File, General Social Survey, Cycle 21: Family, Social Support and Retirement ( 2007): Public Use Microdata File, Documentation and User's Guide, and 3. General Social Survey, Cycle 16: Aging and Social Support (2002): Public Use Microdata File and Documentation, 2002.

There are also 42 articles and reports that provide analysis of this data. The three most recent are: Results from the 2016 Census: Occupations with older workers, Reasons for working at 60 and beyond, and An Overview of the Working Lives of Older Baby Boomers.

Data can be broken provided nationally or by province or territory.

The survey or statistical program used to collect the data were: 

   * Canadian Community Health Survey - Annual Component

* Canadian Community Health Survey - Healthy Aging * Canadian Financial Capability Survey * Canadian Survey on Disability * Census of Population * Employment Insurance Coverage Survey * General Social Survey - Caregiving and Care Receiving * General Social Survey - Time Use * Labour Force Survey * Labour Market Activity Survey * Longitudinal Administrative Databank * National Population Health Survey: Household Component, Cross-sectional * National Population Health Survey: Household Component, Longitudinal * Pension Plans in Canada * Survey of Consumer Finances * Survey of Family Expenditures * Survey of Household Spending * Survey of Labour and Income Dynamics * Survey of Older Workers * Survey of Union Membership James MacKinnon


Results edit

Tools edit

Data sets edit

Main articles edit

Other articles edit

Subpages edit

See also edit

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Open_Government_Data&oldid=1605913184"