Data Explorer
The user-friendly interface to Pacific data
Last updated
The user-friendly interface to Pacific data
Last updated
For an introduction on how to use the Data Explorer see this video :
PDH.stat Data Explorer is directly accessible via the following URL:
https://stats.pacificdata.org/
The application is also accessible in several ways from the Data Catalogue:
A link is available from the "Tools" menu:
PDH Data Catalogue entries have a link to visualize the data in the Data Explorer as a source:
From the welcome page of the Data Explorer data can be searched using predefined topics or using textual search.
Textual search will not only return datasets mentionning serch text in their name or description but also datasets containing occurence of the text in code labels or comments used in the data.
The research results page implements what is called a "faceted search" allowing search criteria to be refined in a second step using a filtering panel on the left side of the screen.
PDH.stat data is registered in the Data Catalogue and can also be found using its various different functionnalities. For more information see dedicated section on the use of the Data Catalogue.
Datasets are first displayed according to a predefined default view.
Filters applied to the default view are visible in the filtering panel on the left side of the screen,
A maximum number of observations will be displayed in the Data Explorer to prevserve user experience. If this limit is exceeded the dataset will be trucated and a warning message will be displayed at the top of the table.
Filters can be managed from the filtering panel on the left of the data table.
The upper side of the panel shows applied filters and allow to easilty clear filters (remove one category, remove all categories selected for a given dimension, clear all filters)
The lower side of the panel shows available filters and allows defining filters (add or remove individual categories for each dimension)
To remove a category click on the cross next to the category
To remove all selected categories for a given dimension click on the cross next to the dimension label
To clear all filters appalied to the dataset click on the cross next to the dimension label
To define filters the lower part of the filtering panel can be used to add or remove categoires from the data selection for each dimension.
Selectect categories are highlighted,
Clicking on an unselected category ads it to the selection
Clikcing on a selected category removes it from the selection
When no catgory is selected for a dimension all categories are part of the selection
The presence of a chevron to the right of the category label indicates that subcategories are available, clicking on the chevron symbol will display sub-categories
The numbers in the green rectangle next to dimension labels inidicate how many categories are selected from the total number of categories available for the dimension
In the Data Explorer dimensions may be displayed as row section, row or column.
Table layout can be customized using the "customize" functionnality available by clicking the appropriate item on ribbon above the data table.
Dimensions can be dragged between columns, row sections and rows.
The new table view is applied once the "apply layout" button is clicked.
At least one dimension must set for rows.
When multiple dimensions are set as columns, row section or row the order in which they are mentionned is significant and corresponds to the order in which they will be nested in the table view. Dimensions can be re-ordred using drag and drop.
A share functionnality allows sending a link to the data currenlty displayed in the Data Explorer per e-mail.
To access this functionnality the "Share" item from the top menu must be clicked.
Data can be shared in 2 ways :
As a snapshot of data meaning that data will not change even if updated on the site
As a view of latest data available meaning that latest available data will always be shown when the shared link is clicked
The email address to which a link will be sent must be provided. The first time an email is sent the address must be validated by clicking the "valide email link" in the message received from the Data Explorer.
Data can be downloaded as Excel or as CSV, for CSV files it is possible to export only data currently dispalyed considering filters applied or to export the entire dataset whithout any filtering.
When a metadata document is available it will be accessible from the "Download" menu by clicking the "Metadata" link next to a blue "i" icon.
Metadata documents comprise a first section with reference metadata (data description, data source, processing, coverage, ...) and a second section with information on the data structure (columns and codelists).
API queries corresponding to the data view currentlty displayed in the Data Explorer can be accessed using the "More" menu.
Separate API queries are provided for data and for structural metadata.
For more information see dedicated section on the use of the API.