Project SF is an independent guide to San Francisco. Alongside the guides and the events calendar, we build datasets that answer questions nobody else answers in one place: how many businesses open for every one that closes, which parks are best kept, which places have closed although guides still list them. Every figure comes from a primary source (a city agency’s published data, or a venue’s or organizer’s own website) and every page says where, when and how.
- 9 downloadable datasets
- 692 rows
- 1 live closures tracker
- Latest data:
- CC BY 4.0
The Datasets
Tracker
39
Closed & Moved
places are not where the guides say. Every closure checked by address against the city register, dated and sourced.
What Is Inside Each Dataset
The fields every file carries and three sample rows, so you can see the shape of the data before you download it. Each JSON file has the same columns as its CSV, plus the dataset name, licence, source page and date. The Closed & Moved tracker is a live list rather than a file; every entry is on its page.
Openings & Closings Index
/data/sf-openings-closings-index.json · 41 rows · data as of
One row per city analysis neighborhood: business locations started and ended per year, from the Treasurer's register. Counts only, never names or addresses.
11 fields: neighborhood, started_2025, ended_2025, net_2025, started_per_ended_2025, food_drink_started_2025, food_drink_ended_2025, started_2024, ended_2024, started_2026_to_date, ended_2026_to_date
| neighborhood | started_2025 | ended_2025 | net_2025 | started_per_ended_2025 |
|---|---|---|---|---|
| Financial District/South Beach | 1710 | 1157 | 553 | 1.48 |
| Mission | 884 | 618 | 266 | 1.43 |
| South of Market | 586 | 391 | 195 | 1.5 |
Museum & Attraction Transparency Index
/data/sf-attraction-transparency-index.json · 40 rows · data as of
One row per museum or attraction: which of the five basics its own website publishes, with the evidence URL for each.
16 fields: venue, neighborhood, official_url, score_of_5, price_published, hours_published, accessibility_published, getting_there_published, children_published, price_evidence_url, hours_evidence_url, accessibility_evidence_url, getting_there_evidence_url, children_evidence_url, adult_price_as_published, check_date
| venue | score_of_5 | price_published | hours_published | check_date |
|---|---|---|---|---|
| 7D Ride Experience (PIER 39) | 5 | yes | yes | 2026-09-18 |
| Alcatraz Island (NPS + Alcatraz City Cruises) | 5 | yes | yes | 2026-09-18 |
| Aquarium of the Bay | 5 | yes | yes | 2026-09-18 |
Free Museum Days
/data/sf-free-museum-days.json · 40 rows · data as of
One row per venue: its free day as the venue publishes it, who qualifies, and whether you need to reserve.
9 fields: venue, free_day_as_published, who, reservation, ebt_medi_cal_discount, library_pass, adult_price_as_published, source_url, check_date
| venue | free_day_as_published | who | reservation | ebt_medi_cal_discount |
|---|---|---|---|---|
| Cable Car Museum | Always free | everyone | no | not stated |
| Fort Point National Historic Site | Always free | everyone | no | not stated |
| Museum of Performance + Design | Always free | — | yes for First Saturday hours ('*Reservations in advance are required'); not stated for Wed/Thu exhibition hours | not stated |
Day-Out Cost Calculator Prices
/data/sf-day-out-cost-calculator.json · 104 rows · data as of
One row per venue and age band: the admission price the venue publishes. A blank price means the venue does not publish one.
10 fields: venue, always_free, band, min_age, max_age, price_usd, resident_price, variable_pricing, price_url, check_date
| venue | band | min_age | max_age | price_usd |
|---|---|---|---|---|
| 7D Ride Experience (PIER 39) | Children 12 & under | 0 | 12 | 13.0 |
| 7D Ride Experience (PIER 39) | Per person | 13 | 120 | 15.0 |
| Alcatraz Island (NPS + Alcatraz City Cruises) | Children Under 5 | 0 | 4 | 0.0 |
Every SF Park, Compared
/data/sf-parks-compared.json · 221 rows · data as of
One row per Recreation and Park property: facilities from the city inventory and the city's own maintenance scores.
21 fields: park, type, neighborhood, supervisor_district, acres, address, playgrounds, restrooms, dog_play_areas, tennis_courts, pickleball_courts, basketball_courts, picnic_areas, rec_center, pool, skatepark, community_garden, score_fy2025, score_fy2024, latitude, longitude
| park | neighborhood | playgrounds | dog_play_areas | score_fy2025 |
|---|---|---|---|---|
| 10th Ave & Clement Park | Inner Richmond | 1 | 0 | 0.98 |
| 15th Avenue Steps | Inner Sunset | 0 | 0 | — |
| 24th & York Mini Park | Mission | 1 | 0 | 0.99 |
Street Fair Calendar
/data/sf-street-fair-calendar.json · 45 rows · data as of
One row per public event with an SFMTA street-closure permit: dates, streets closed and the organizer's page. Private events are never listed.
14 fields: event, category, first_permit_day, last_permit_day, permit_dates, closure_starts, closure_ends, streets, street_segments, organizer_url, price_on_organizer_page, organizer_dates_match_permit, sfmta_case_number, permit_data_as_of
| event | category | first_permit_day | last_permit_day | organizer_dates_match_permit |
|---|---|---|---|---|
| Folsom Street Fair 2026 | Street fair or festival | 2026-09-26 | 2026-09-28 | yes |
| Portola Music Festival 2026 | Music festival | 2026-09-26 | 2026-09-28 | yes |
| Castro Farmers' Market 2026 | Farmers market | 2026-09-30 | 2026-11-18 | yes |
SF Gallery Index
/data/sf-gallery-index.json · 84 rows · data as of
One row per contemporary art gallery: open, moved or closed, since when, the evidence, and what is on now.
16 fields: gallery, neighborhood, address, status, status_since, source_type, status_evidence_url, official_url, hours_published, admission, first_thursday, current_exhibition, exhibition_start, exhibition_end, exhibition_url, check_date
| gallery | neighborhood | status | status_since | check_date |
|---|---|---|---|---|
| 111 Minna Gallery | SoMa | open | — | 2026-10-01 |
| 5 Olive Gallery | Tenderloin | open | — | 2026-10-01 |
| 60Six | Dogpatch (Minnesota Street Project) | open | — | 2026-10-01 |
Halloween by the Numbers
/data/sf-halloween-by-the-numbers.json · 13 rows · data as of
One row per city analysis neighborhood: SFMTA-permitted residential street closures (trick-or-treat streets and Halloween block parties) on . Counts only; streets are never listed.
4 fields: analysis_neighborhood, residential_halloween_night_closures, street_segments_closed, permit_data_as_of
| analysis_neighborhood | residential_halloween_night_closures | street_segments_closed | permit_data_as_of |
|---|---|---|---|
| Sunset/Parkside | 6 | 6 | 2026-09-27 |
| Glen Park | 5 | 13 | 2026-09-27 |
| Bernal Heights | 3 | 11 | 2026-09-27 |
Events by Muni
/data/sf-events-muni-access.json · 104 rows · data as of
One row per upcoming event on the Project SF calendar: distance to the nearest Muni stop and BART station, and the Muni lines passing within 400 m. Facts only, no position on any transit measure.
15 fields: event, url, neighborhood, venue, start, end, nearest_muni_stop_m, muni_lines_within_400m, n_muni_lines_within_400m, metro_or_rapid_within_400m, nearest_bart, nearest_bart_m, ends_9pm_or_later, measured_at_spots, data_as_of
| event | neighborhood | nearest_muni_stop_m | n_muni_lines_within_400m | nearest_bart |
|---|---|---|---|---|
| Treasures of the Pharaohs | Golden Gate Park | 108 | 6 | 16th Street / Mission |
| Ferry Plaza Farmers Market | Financial District | 74 | 14 | Embarcadero |
| Heart of the City Farmers Market | Hayes Valley | 76 | 20 | Civic Center / UN Plaza |
Machine-readable: every dataset is served as CSV and as JSON at /data/<slug>.json (rows parsed from the CSV, CORS open, CC BY 4.0); the full index with dates and refresh cadence is in llms.txt. Markdown versions (no navigation): /data/index.md and /data/<slug>.md.
Data Changelog
The most recent changes across every dataset, newest first. Each page keeps its own full update log; the same list is available as JSON or RSS.
- : Getting to San Francisco Events on Muni: Stops, Lines and BART Near Every Event - Spread-out events (Fleet Week air show and Parade of Ships, Fleet Week ship tours, Fleet Fest, Italian Heritage Parade) are now measured at several spots instead of one, with a spot-by-spot table.
- : Getting to San Francisco Events on Muni: Stops, Lines and BART Near Every Event - Re-run: 103 of 104 upcoming events within 400 m of a Muni stop.
- : Getting to San Francisco Events on Muni: Stops, Lines and BART Near Every Event - Re-run: 104 of 105 upcoming events within 400 m of a Muni stop.
- : Free Museum Days in San Francisco: Every Free Day, Checked Against Each Museum’s Own Site - Monthly re-check: 39 of 40 venues re-checked on their own sites; reservation notes added for the Japanese Tea Garden and the Museum of Performance + Design's First Saturday; no free days added or dropped.
- : Getting to San Francisco Events on Muni: Stops, Lines and BART Near Every Event - First published: 107 of 108 upcoming events within 400 m of a Muni stop.
- : San Francisco Gallery Index 2026: Which Galleries Are Open, Moved or Closed - Fortnightly re-check: current shows updated from 68 galleries' own sites; no new closures or moves found.
- : San Francisco Street Fair and Festival Calendar 2026: Every Event With a City Street-Closure Permit - Weekly re-run: permits as of . Past events dropped; no new public events found. 29 events through December.
- : Halloween in San Francisco 2026, by the Numbers: Trick-or-Treat Street Closures and Family Events - First published: 27 residential Halloween-night closures in 13 neighborhoods, from permits as of .
- : San Francisco Street Fair and Festival Calendar 2026: Every Event With a City Street-Closure Permit - Weekly re-run: permits as of . Past events dropped; no new public events found. 35 events through December.
- : Every San Francisco Park, Compared: Maintenance Scores, Playgrounds, Restrooms and Dog Areas - First published. 221 parks; FY2025 and FY2024 scores; facility inventory as of .
How We Work
- Primary sources only. City open data (DataSF), agency pages, and venues’ and organizers’ own websites. Press is used only to corroborate, and says so.
- Nothing estimated. If a figure is not published, we say “not published”. We never model, infer or fill gaps.
- Dated and re-checked. Each page shows when its data was pulled and keeps an update log. Recurring datasets are re-run on a fixed schedule.
- Corrections in public. When a figure was wrong, we fix it on the page and date the correction.
- Privacy. Data derived from the business register is published as counts, or as business name, neighborhood and date only. Never owners’ names or home addresses.
- Free to reuse. Every dataset has a CSV download under CC BY 4.0. Please credit Project SF and link to the page.
Known Limits
- Published is not the same as offered. The transparency, free-days and price data record what a venue publishes on its own site. A venue may offer more than it says.
- The business register lags. Businesses that close without telling the city stay “open” in it, so the Openings & Closings Index is a floor. That is why closures are checked one by one in the tracker.
- A permit is not a program. The street fair calendar confirms a street is closed on those dates; hours, prices and line-ups come from the organizer and can change.
- Coverage is deliberate. Parks cover Recreation and Park properties only (not the Presidio, GGNRA or Port land); galleries cover contemporary art galleries inside city limits.
- Point in time. Each row carries the date it was checked. Re-download the file the week you use it.
Each dataset page lists its own limits under “What this data cannot tell you”.
Licence and Citation
These datasets are released under Creative Commons Attribution 4.0. You may copy, share and build on them, including commercially, as long as you credit Project SF and link to the dataset page.
Project SF. San Francisco, by the Numbers: Original Data and Tools. https://projectsf.com/data/
Questions, or found an error? Contact us. Read our editorial standards. Reporters and researchers: how to cite this data.