Qipudata
San Francisco · v0.7.1
qipu data›San Francisco›Datasets›events

Events

eventsrelease v0.7.1CC0 1.0

About

Events (v0.3: the 1906 earthquake and fire, with its burn-zone footprint).

How far to trust it
The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority. Details
Licence
CC0 1.0: use it for anything, no permission needed. The scans and other sources keep their own rights.
Version
v0.7.1, published 21 October 2026. A published release is never changed; corrections come as a new release.
Technical details
Table
events
Rows
1 (San Francisco 1)
Columns
8
Parquet
events.parquet, < 0.1 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Method and accuracy

No accuracy measure for this table yet.

The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority.

Methodology · Accuracy

Columns 8

ColumnTypeCan be emptyPrivacyPublic copyDescription
event_idVARCHARnononeas isqipu:<city>/event/<slug>.
Values qipu:sf/event/1906-earthquake-and-fire
Can be empty no · Privacy none · Public copy as is
cityVARCHARnononeas issf.
Values sf
Can be empty no · Privacy none · Public copy as is
labelVARCHARyesnoneas isReadable name.
Values The 1906 earthquake and fire
Can be empty yes · Privacy none · Public copy as is
event_typeVARCHARyesnoneas isdisaster.
Values disaster
Can be empty yes · Privacy none · Public copy as is
t_fromVARCHARyesnoneas isStart date (YYYY-MM-DD).
Values 1906-04-18
Can be empty yes · Privacy none · Public copy as is
t_toVARCHARyesnoneas isEnd date (YYYY-MM-DD).
Values 1906-04-21
Can be empty yes · Privacy none · Public copy as is
footprint_place_idVARCHARnononeas isThe place covering the area it hit (see places).
Values qipu:sf/place/burn-zone/1906
Can be empty no · Privacy none · Public copy as is
wikidataVARCHARyesnoneas isWikidata id.
Values Q211386
Can be empty yes · Privacy none · Public copy as is

Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.

Preview

event_idcitylabelevent_typet_fromt_tofootprint_place_idwikidata
event/1906-ea…uake-and-firesfThe 1906 earthquake and firedisaster1906-04-181906-04-21place/burn-zone/1906Q211386

Eight rows sampled at build time. Hover a shortened value for all of it.

Download

FormatFileSize
Parquetevents.parquet ↗< 0.1 MB
SQLite (all tables)qipu_sf.db ↗6.44 GB

SQL

SELECT * FROM events LIMIT 100

Run in the SQL console (DuckDB in the browser, over the Parquet file).

Python

import duckdb duckdb.sql("SELECT * FROM 'https://tiles.qipu.org/data/releases/v0.7.1/parquet/events.parquet' LIMIT 5").show()