Download the San Francisco Bay Area past events CSV. It contains this site's own approved events that have ended, oldest first, with a header row. UTF-8, comma-separated, CRLF line endings, quoted where needed.
Any text value that begins with =, +, -, @, a tab or a carriage return is prefixed with an apostrophe so spreadsheet programs do not run it as a formula.
| Column | Meaning |
|---|---|
occurrence_id | Stable 404localhost occurrence id |
dataset | real or demo (demo rows are fictional fixtures) |
date_time | Displayed date/time label |
start_local | Start, local wall-clock time (YYYY-MM-DDTHH:MM, or YYYY-MM-DD when only the date is known) |
end_local | End, local wall-clock time; empty when unknown |
timezone | IANA timezone of the local times |
title | Event title |
event_status | scheduled, cancelled, postponed or rescheduled |
venue | Venue and city as listed (restricted addresses are never exported) |
subregion | sf, east-bay, peninsula, south-bay or north-bay |
tags | Event type, topics and audience |
context | Reviewed 'what to expect' line; empty when none was approved |
cost_access | Cost, access requirement, age limit, availability and participant application as displayed |
price_kind | free, paid, donation or unknown |
access_kind | open, rsvp, application, invite, members or unknown |
organizers | Organizer names separated by semicolons |
registration_url | Primary external event or registration page |
other_urls | Secondary links separated by spaces |
source_urls | Where the record was found, separated by spaces |
verified_at | UTC time an editor or adapter last verified the record |
updated_at | UTC time the record last changed |