cityofnewyork-us/nyc-parks-events-listing-event-listing-fudw-fgrp

  • activities
  • events
  • outdoor
  • parks

NYC Parks Events Listing – Event Listing

NYC Parks Events Listing – Event Listing

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 <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
titletitletitleText
end_timeend_timeend_timeText
event_idevent_idevent_idNumber
snippetsnippetsnippetText
location_descriptionlocation_descriptionlocation_descriptionText
start_timestart_timestart_timeText
must_seemust_seemust_seeNumber
phonephonephoneText
descriptiondescriptiondescriptionText
noticenoticenoticeNumber
urlurlurlText
emailemailemailText
datedatedateCalendar date
cost_freecost_freecost_freeNumber
cost_descriptioncost_descriptioncost_descriptionText

Upstream Metadata