NYC Parks Events Listing – Event Locations

cpcm-i88gCity Government14 columns

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database: 1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.) 2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.) 3. Events_Images (Each record is an image related to an event. One event can have more than one image.) 4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.) 5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.) 6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.) 7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.) The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow This Link

View on NYC Open Data

Quality

B84.1 / 100

From a 500-row sample across 9 columns.

completeness83/ 25% weight

consistency72/ 20% weight

accuracy97/ 20% weight

timeliness78/ 15% weight

usability90/ 20% weight

· No obvious temporal column — limits time-series joins
· Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

2020 Census Tracts0.33
NYC Zoning Tax Lot Database0.32
Parks Concessions0.32
NYC Parks Districts0.31
joins onborough
2020 Neighborhood Tabulation Areas (NTAs)0.30
DSNY Monthly Tonnage Data0.30
joins onborough
Parks Zones0.30

Geography

Mappable — coordinate pair `lat` / `long`.

Open on the map →

Sample rows

event_id	name	park_id	lat	long	borough	address	zip	accessible
100073	Audubon Center at the Boathouse	B073	40.66170120239258	-73.9708023071289	B	—	—	—
100074	Wolfes Pond Park at Hylan Blvd	R031	40.521690368652344	-74.19256591796875	R	—	—

Columns

9 queryable · 9 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`event_id`	text	—	0%	`782257822678224`
`name`	text	—	0%	`Poe Park Visitor CenterQueens Botanical GardenConference House Park Vi…`
`park_id`	text	—	13%	`X040M010M008`
`lat`	float	—	0%	`40.865001678466840.7514991760253940.502257029653`
`long`	float

Query this from your own app

GET /api/datasets/cpcm-i88g
GET /api/datasets/cpcm-i88g/quality
GET /api/datasets/cpcm-i88g/related
GET /api/columns?dataset=cpcm-i88g