datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

dataset

size

Cafés, libraries, parks, clinics and shops in Portland, Oregon, mapped by OpenStreetMap volunteers.

969 places2 tablesOct 2026

what to watch for

Tricky rows

Places with no name tag140 rows
Places with no opening_hours597 rows
Opening hours in OSM’s own syntax (e.g. "Mo-Fr 07:00-18:00; Sa 08:00-14:00"), not timestamps372 rows
Places whose addr_city is missing or not exactly "Portland"335 rows

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

places969 rows · 20 columns · CSV

One mapped place. Buildings and areas are reduced to their centre point.

In your code: data/places.csv

osm_typetextkey
How OpenStreetMap stores it: node (a point), way (an outline) or relation (a group)
osm_idintegerkey
OpenStreetMap ID within its type
categorytext
amenity, shop or leisure
kindtext
The value of that tag: cafe, library, park, …
latitudedecimal
Latitude
longitudedecimal
Longitude
nametext · can be empty
Name
cuisinetext · can be empty
Cuisine(s), ";"-separated
opening_hourstext · can be empty
Opening hours in OpenStreetMap’s format, e.g. Mo-Fr 08:00-17:00
websitetext · can be empty
Website
phonetext · can be empty
Phone number (business)
wheelchairtext · can be empty
yes, limited, no
outdoor_seatingtext · can be empty
yes or no
brandtext · can be empty
Chain or brand
operatortext · can be empty
Who runs it
addr_housenumbertext · can be empty
House number
addr_streettext · can be empty
Street
addr_postcodetext · can be empty
ZIP code
addr_citytext · can be empty
City
tag_countinteger
How many tags the place has

tags9,735 rows · 4 columns · CSV

One tag (key = value) on one place: every place’s tags, one per row.

In your code: data/tags.csv

osm_typetextkey
How OpenStreetMap stores it: node (a point), way (an outline) or relation (a group)
osm_idintegerkey
Place ID
keytextkey
Tag key
valuetext
Tag value

data/places.geojson969 records · GeoJSON

One mapped place. Buildings and areas are reduced to their centre point.

In your code: data/places.geojson

data/overpass.json969 records · JSON

One mapped place. Buildings and areas are reduced to their centre point.

In your code: data/overpass.json