NYC Parks Events Listing – Event Links

ridc-7qqgCity Government3 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

B89.5 / 100

From a 500-row sample across 3 columns.

completeness100/ 25% weight

consistency83/ 20% weight

accuracy96/ 20% weight

timeliness78/ 15% weight

usability85/ 20% weight

· No obvious temporal column — limits time-series joins

Related datasets

NYC Parks Events Listing – Event Organizers0.81
joins onevent_id
NYC Parks Events Listing – Event Categories0.81
joins onevent_id
NYC Parks Events Listing – Event Images0.80
joins onevent_id
NYC Parks Events Listing – Event YouTube Links0.79
joins onevent_id
NYC Parks Events Listing – Event Locations0.71
joins onevent_id
NYC Parks Events Listing – Event Listing

Sample rows

event_id	link_url	link_name
100073	http://naturalareasnyc.org/	Natural Areas Conservancy
100158	http://www.prospectpark.org/calendar/event/shape-up-nyc-cardio-toning	Shape Up NYC: Cardio Toning
100159	http://www.prospectpark.org/calendar/event/shape-up-nyc-cardio-toning	Shape Up NYC: Cardio Toning
100160	http://www.prospectpark.org/calendar/event/shape-up-nyc-cardio-toning	Shape Up NYC: Cardio Toning
100161	http://www.prospectpark.org/calendar/event/shape-up-nyc-cardio-toning	Shape Up NYC: Cardio Toning

Columns

3 queryable · 3 profiled

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

Field	Type	Description	Null	Values
`event_id`	text	—	0%	`127131127130127129`
`link_url`	url	—	0%	`http://itsmypark.orghttp://www.centralparkny…http://www.bryantpark.or…`
`link_name`	text	—	0%	`Partnerships for ParksCentral Park Conservancy…Central Park Conservancy…`

Query this from your own app

GET /api/datasets/ridc-7qqg
GET /api/datasets/ridc-7qqg/quality
GET /api/datasets/ridc-7qqg/related
GET /api/columns?dataset=ridc-7qqg