Wikidata:Dataset Imports/Number of out-of-school children for countries and geographical regions
You may find these related resources helpful:
Guidelines for using this page[edit]
Documenting the import[edit]
- Guidelines on how to import a dataset into Wikidata are available at Wikidata:Data Import Guide.
- Please include notes on all steps of the process.
- Once a dataset has been imported into Wikidata please edit the page to change the progress status from in progress to complete.
- It is strongly recommended to use Visual Editor when making changes to this page, particularly for editing any of the tables.
Creating a Wikidata item for the dataset[edit]
- Please create a Wikidata item for the dataset, this will allow us to improve the coverage of datasets on Wikidata and understand what datasets are available on that topic and which of them have been added to Wikidata.
- If you are working with very large dataset you can break it into smaller Mix n' Match catalogues, but only create one Wikidata item.
- Link the dataset Wikidata item to this page using Wikidata Dataset Imports URL (P5195)
Getting help[edit]
- If your dataset import runs into issues please edit the page to change the progress status from in progress to help needed.
- You can ask for help on Wikidata:Project chat.
Overview[edit]
Dataset name[edit]
Number of out-of-school children for countries and geographical regions
Source[edit]
UNESCO Institute of Statistics
Link[edit]
http://data.uis.unesco.org/index.aspx?queryid=3372
Dataset description[edit]
Combined total number of out-of-school children, adolescents and youth of primary and secondary school age for most countries and geographic region. This import includes historical values going back to 1999, but some countries actually have data available as far back as 1970. Gender and age group breakdown also available but not used yet.
Additional information[edit]
To avoid cluttering up country items with very large numbers of date qualified statements, available data has only been imported from 1999 onward (available from 1970 for many countries and regions). For the same reason, data has not been added with any breakdown by gender or age group (this is available from the source). It is expected we will need to switch to using a Data Table on Wikimedia Commons in the future, as this would give access to all breakdown available and the full record of historical values. This has not been done at this stage because it is not yet possible to query Data Tables on Commons using the Wikidata Query Service.
Progress of import[edit]
The table below is used to track the progress of importing this dataset. The suggested column headings are most applicable to data being imported from a spreadsheet - you can change some column headings or add new columns as required to best describe the progress of this import.
| Wikidata item for the dataset | Import data into spreadsheet | Format the spreadsheet to import the data | Structure of data within Wikidata | Match the dataset to Wikidata | Importing data into Wikidata | Visualisations | Maintainance queries and expected results |
|---|---|---|---|---|---|---|---|
| UIS Number of out-of-school children dataset (Q63033235) |  Done (Link) | Done | Done | Done | Done (1999 - 2016) | Done |  Not done |
Edit history[edit]
Use the table below to list batches of edits that have been completed for this dataset. Ideally each entry should have all applicable columns filled out, but at a minimum please make to add a date and description to give an idea of what was added to Wikidata and when.
| Date | Description | Method | Properties | Qualifiers | References | Statements added | Statements removed | Link to import sheet |
|---|---|---|---|---|---|---|---|---|
| 31 Dec 2017 | Main import of data for both sexes combined for years 1999 - 2016 | QuickStatements | number of out-of-school children (P2573) | 1999 | 0 | QuickStatements Import sheet | ||
| 8 Jan 2018 | Fixed errors from incorrect matching, and added from new matches | QuickStatements | number of out-of-school children (P2573) | 73 | 39 | QuickStatements Import sheet |
Discussion of import[edit]
These headings are generally useful, please change this section to suit your needs.
Structure of data within Wikidata[edit]
| Field name | Wikidata property | Usage | Notes |
|---|---|---|---|
| Number of out-of-school children | number of out-of-school children (P2573) | Main statement | |
| Year of statistic | point in time (P585) (Qualifier) | Qualifier | |
| Method of recording statistic | determination method (P459) (Qualifier) | Qualifier | |
| URL of whole dataset | reference URL (P854) | Reference | Same reference used for all statements - http://data.uis.unesco.org/index.aspx?queryid=3372 |
| stated in (P248) = UNESCO Institute for Statistics (Q3152127) | Reference |
Important note: As yearly stats can really clutter up items, it is expected that we will move towards using Data Tables on commons for recording the yearly breakdown. This will need to wait until it's possible to query this data though. Once this is done we should remove the yearly breakdown for the main number of out-of-school children (P2573) property, and just store most recent values only.
Match the dataset to Wikidata[edit]
Only countries and geographic regions needed matching for this dataset (see matching sheet)
Import completion notes[edit]
Completed for years 1999 - 2016
Visualisations[edit]
- Main query for all countries/regions, including past years
- Line chart for all countries
- Line chart for whole planet
- Bar chart for Continents
- Bubble chart for countries in 2013
- Chart for individual countries/regions (US, UK and France in example)
Maintenance[edit]
Schedule of new data released[edit]
New data released annually