Dataset research report
World Cities Geo research report
A reproducible data report with schema notes, generated chart evidence, suggested follow-up questions, and export-ready Helix queries.
Executive Summary
Dataset containing city, country, region, and continents alongside their longitude and latitude co-ordinates. Cartesian coordinates are provided in x, y, z features.
Research Context
World Cities Geo: 500 rows by 9 columns. These exploratory charts are generated automatically from the data - open the dataset in Helix to ask your own questions.
Data Profile
Chart Evidence
These views are generated from the dataset profile. Each chart is paired with a Helix query so it can be opened, adjusted, and exported.
Correlation of numeric columns
Pearson correlation between numeric columns.
Open and export this chartFollow-Up Queries
Preview Rows
| # | citytext | countrytext | regiontext | continenttext | latitudefloat | longitudefloat | xfloat | yfloat |
|---|---|---|---|---|---|---|---|---|
| 1 | Kabul | Afghanistan | Southern Asia | Asia | 34.52 | 69.18 | 1866 | 4907 |
| 2 | Kandahar | Afghanistan | Southern Asia | Asia | 31.61 | 65.7 | 2233 | 4945 |
| 3 | Mazar-e Sharif | Afghanistan | Southern Asia | Asia | 36.71 | 67.11 | 1987 | 4706 |
| 4 | Herat | Afghanistan | Southern Asia | Asia | 34.34 | 62.19 | 2454 | 4653 |
| 5 | Jalalabad | Afghanistan | Southern Asia | Asia | 34.42 | 70.45 | 1759 | 4953 |
| 6 | Konduz | Afghanistan | Southern Asia | Asia | 36.72 | 68.86 | 1842 | 4763 |
Data Dictionary
- city text
- country categorical
- region categorical
- continent categorical
- latitude numeric
- longitude numeric
- x numeric
- y numeric
- z numeric
Method And Limits
- Load the catalog entry and preview rows from the processed dataset file.
- Infer numeric, categorical, time, and location fields from real columns.
- Generate a small set of defensive Plotly chart specifications from that profile.
- Expose each chart idea as a query link so the report can be rerun or exported in Helix.
This report is intentionally reproducible. It uses the local catalog metadata and generated chart specifications rather than claiming external conclusions beyond the dataset.