CSV data in Switzerland: sources and checks

What the source records show

The selected country export contains 95,372 listed format declarations across 81 publishers.

CSV accounts for 8.8% 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 City of Zurich.

It contributes 1,164 matching resource records, or 13.8% of this format sample.

The next entry contributes 880 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

CSV stores table rows as text. A delimiter separates the fields.

1. Confirm the delimiter and character encoding.
2. Import identifiers as text to preserve leading zeroes.
3. Compare the number of fields in each row.
4. Check decimal symbols and date formats before calculations.
5. Retain blank cells until the source defines their meaning.

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.