JSON data in Canada: sources and checks

What the source records show

The selected country export contains 243,437 listed format declarations across 89 publishers.

JSON accounts for 0.5% of that declaration total.

A resource record describes a file or a service. Several records can belong to one dataset.

The export retains up to 20 format labels per publisher. It excludes some small publishers and empty format labels.

Choose a source

The largest matching entry is Government and Municipalities of Québec.

It contributes 883 matching resource records, or 71.9% of this format sample.

The next entry contributes 112 matching records.

A large count indicates more catalogue records. It does not establish accuracy, completeness, or public access.

1. Open a source record from the examples below.
2. Confirm the geographic area and observation period on the source page.
3. Read the licence for the selected dataset.
4. Select the required file or service from the source page.

Inspect the format

JSON stores objects, arrays, and values. A JSON file can contain nested records.

1. Inspect the top-level object or array.
2. Identify the array that contains the data records.
3. Keep absent fields separate from explicit null values.
4. Check whether the source supplies pagination links.
5. Preserve identifier strings when you flatten nested objects.

Check the result

A format label does not verify the file contents. A source can change its files after the catalogue export.

A metadata modification date can describe a catalogue edit. It does not necessarily describe the latest observation.

1. Record the source URL, access date, and dataset title.
2. Check the units and the definitions of the fields.
3. Compare a small sample with the source documentation.
4. Retain an original copy before any conversion.
5. State any missing periods, regions, or values in the result.

How this comparison works

The calculation sums listed format declarations from the publisher export.

It groups equivalent format labels and retains separate counts for XLS, XLSX, TIFF, and GeoTIFF.

Compound labels can remain outside the selected format group. The source files retain the original labels.

The source records can include several versions of the same data. The totals do not count unique observations.

The examples are selections from stored catalogue samples. They do not list every matching dataset.