NOTES / METHODS / IDEAS

Wiki_

A small repository backed field guide for working with open data.

Choose a chart

Use a line for meaningful time series, bars for categories, and scatter for two quantitative measures. A box plot summarizes a distribution. Use a map when geography communicates the question well.

In the Query chart tab, choose MAP, a country column, and a numeric value. A country_iso_alpha3 column is the preferred map key. If you select a country name and the result also has country_iso_alpha3, the code supplies the map key. Otherwise, only exact Natural Earth country labels can match; unmatched labels are reported. The map uses the reviewed Natural Earth 1:110m Admin 0 Countries geometry ↗. It is a low-resolution visual reference, so some small areas are absent and boundaries follow Natural Earth's de facto depiction.

If the query returns multiple values for a country, select SUM, AVG, MIN, MAX, or COUNT explicitly, or use the time slider to select one period. No aggregation is applied silently. When a year or date column is returned, the slider can focus the chart on a period. For a line whose X axis is time, the slider shows all observations through the chosen period; for other marks it shows only the chosen period.

The SUMMARY tab profiles the rows returned by the SQL query. It shows row and field counts, missing values, and per-field statistics for integer, numeric, text, date, boolean, mixed, or empty fields. Statistics describe the query result, so a SQL LIMIT or filter also limits the profile.