Example: Data Dictionary | 311 Service Requests, 2010 to Present
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Note: Hover over each column header for an explanation of each field.
2
OrderField NameLongform NameDescriptionGeocodedRequiredData TypeExpected/Allowed ValuesLast ModifiedNo Longer In UseNotes
3
1Unique KeyEach 311 service request is assigned a number that distinguishes it as a separate case incident. Each row of data has a different Unique Key, which is separate from the case number assigned within the NYC311 system.Number
4
2Created DateThe date and time that a Customer submits a Service Request.Date & TimeMM/DD/YYYY HH:MM:SS (AM/PM)
5
3Closed DateThe date and time that an Agency closes a Service Request.Date & Time
6
4AgencyAcronym of responding City Government Agency or Entity responding to 311 Service Request. Use this column to definitely identify which entities respond to which service requests.Plain TextSee User GuideNote that some agencies like New York City Housing Authority (NYCHA) and New York City Department of Corrections (DOC) do not use the 311 system and will not appear in this list.
7
5Agency NameFull agency name of responding city agency, or entity responding to 311 service request. Plain TextUse this column to supplement information found in the Agency column. In some cases, this field will spell out an acronym; in others this field will indicate a specific office within an agency or repeat the acronym.
8
6Complaint Type311 service requests are categorized by Complaint Type and Descriptor. Complaint Type broadly describes the topic of the incident or condition and are defined by the responding agencies. New Complaint Types may be added in response to changes in customer demand.Plain TextSee User Guide
9
7Descriptor311 service requests are categorized by Complaint Type and Descriptor. Descriptor provides further detail on the incident or condition. Descriptor values are dependent on the Complaint Type, and are not always required.Plain TextSee User Guide
10
8Location TypeService requests can be categorized into a type of location, such as a residence, business, or outdoor area. Plain TextSee User Guide
11
9Incident ZipZip code of incident address, provided by customer or geocoding. Number
12
10Incident AddressHouse number of incident address, provided by customerPlain Text
13
11Street NameStreet name of incident address, provided by customerPlain Text
14
12Cross Street 1If the service request pertains to a location in the middle of a block, cross street will be provided by geocoding.  For example, 725 Fifth Avenue in Manhattan is located between cross streets 56th Street and 57th Street.Plain Text
15
13Cross Street 2If the service request pertains to a location in the middle of a block, cross street will be provided by geocoding. For example, 725 Fifth Avenue in Manhattan is located between cross streets 56th Street and 57th Street. Plain Text
16
14
Intersection Street 1
If the service request pertains to a street corner, intersection will be provided by geocoding. For example, Gracie Mansion is located at the intersection of E 88th St and East End Avenue. Plain Text
17
15
Intersection Street 2
If the service request pertains to a street corner, intersection will be provided by geocoding. For example, Gracie Mansion is located at the intersection of E 88th St and East End Avenue. Plain Text
18
16Address TypeType of information available about the incident location. Plain Text{blank}, ADDRESS, BLOCKFACE, INTERSECTION, LATLONG, PLACENAME
19
17CityIn this dataset, City can refer to a borough or neighborhood. Historically, each borough was distinct, and many neighborhoods in Queens and the Bronx were also distinct places before merging with the City of New York.Plain TextMANHATTAN, BROOKLYN, BRONX, STATEN ISLAND, or in QUEENS, specifc neighborhood name
20
18LandmarkCan refer to any noteworthy location, including but not limited to, parks, hospitals, airports, sports facilities, performance spaces, etc.Plain Text
21
19Facility TypeData provided if the service request incident location is associated with a city facilityPlain Text{blank}, DSNY Garage, Precinct, School, School District, N/A
22
20StatusCurrent status of service request.Plain TextAssigned, Pending, Open, Closed
23
21Due DateDate when responding agency is expected to update the service request. This is based on the Complaint Type and internal Service Level Agreements (SLAs) between 311 and the responding Agency.
24
22
Resolution Description
Describes the last action taken on the service request by the responding agency. May describe next steps.
25
23
Resolution Action Updated Date
Date when responding agency last updated the service request.MM/DD/YYYY HH:MM:SS (AM/PM)
26
24Community BoardCommunity boards are local representative bodies. There are 59 community boards throughout the City, each representing a distinct geography.For more information on Community Boards: http://www.nyc.gov/html/cau/html/cb/about.shtml
27
25BBLBorough Block & LotParcel number that identifies the location of the building or property associated with the service request. The block is a subset of a borough. The lot is a subset of a block unique within a borough and block.Number
The borough number is:

1. Manhattan (New York County)
2. Bronx (Bronx County)
3. Brooklyn (Kings County)
4. Queens (Queens County)
5. Staten Island (Richmond County)
28
26BoroughProvided by the submitter and confirmed by geocoding.Plain TextBRONX, BROOKLYN, MANHATTAN, QUEENS, STATEN ISLAND
29
27
X Coordinate (State Plane)
X coordinate of the incident location. LocationFor more information about NY State Plane Coordinate Zones: http://gis.ny.gov/gisdata/metadata/nysogs.statepln.html?nysgis=
30
28
Y Coordinate (State Plane)
Y coordinate of the incident location. LocationFor more information about NY State Plane Coordinate Zones: http://gis.ny.gov/gisdata/metadata/nysogs.statepln.html?nysgis=
31
29
Open Data Channel Type
Indicates how the service request was submitted to 311.Plain TextMOBILE, ONLINE, OTHER, PHONE, UNKNOWN2018-05-01
32
30Park Facility NameData provided if service request pertains to a facility managed by NYC Parks (DPR)Plain Text
33
31Park BoroughData provided for service requests pertaining NYC Parks (DPR). Matches Borough column.Plain Text
34
32Vehicle TypeData provided if service request pertains to a vehicle managed by the Taxi and Limousine Commision (TLC)Plain TextAmbulette / Paratransit,
Car Service, Commuter Van, Green Taxi
35
33
Taxi Company Borough
Data provided if service request pertains to a vehicle managed by the Taxi and Limousine Commision (TLC).Plain Text
36
34
Taxi Pick Up Location
Data provided if service request pertains a vehicle managed by the Taxi and Limousine Commision (TLC)Plain Text
37
35
Bridge Highway Name
Service Requests pertaining to bridges or highways are categorized by Bridge Highway Name and subcategorized by Bridge Highway Direction, Road Ramp, and Bridge Highway Segment.Plain Text
38
36
Bridge Highway Direction
Service Requests pertaining to bridges or highways are categorized by Bridge Highway Name and subcategorized by Bridge Highway Direction, Road Ramp, and Bridge Highway Segment.Plain Text
39
37Road RampService Requests pertaining to bridges or highways are categorized by Bridge Highway Name and subcategorized by Bridge Highway Direction, Road Ramp, and Bridge Highway Segment.Plain Text
40
38
Bridge Highway Segment
Service Requests pertaining to bridges or highways are categorized by Bridge Highway Name and subcategorized by Bridge Highway Direction, Road Ramp, and Bridge Highway Segment.Plain Text
41
39LatitudeLatitude of the incident location in decimal degrees.Location
42
40LongitudeLongitude of the incident location in decimal degrees.Location
43
41LocationThe combined geo-based latitude & longitude of the incident location.Location
44
n/aSchool NameIf the incident location is a Dept of Education school, the name of the school will appear in this field. If the incident is a Parks Dept facility its name will appear here.Plain TextRemoved in 2018
45
n/aSchool NumberIf the incident location is a Dept of Education school, the Number of the school will appear in this field. This field is also used for Parks Dept Facilities.NumberRemoved in 2018
46
n/aSchool RegionIf the incident location is a Dept of Education School, the school region number will be appear in this field.Plain TextRemoved in 2018
47
n/aSchool CodeIf the incident location is a Dept of Education School, the school code number will be appear in this field.Plain TextRemoved in 2018
48
n/a
School Phone Number
If the facility = Dept for the Aging or Parks Dept, the phone number will appear here. (note - Dept of Education facilities do not display phone number)NumberRemoved in 2018
49
n/aSchool AddressAddress of facility of incident location, if the facility is associated with Dept of Education, Dept for the Aging or Parks DeptPlain TextRemoved in 2018
50
n/aSchool CityCity of facilities incident location, if the facility is associated with Dept of Education, Dept for the Aging or Parks DeptPlain TextRemoved in 2018
51
n/aSchool StateState of facility incident location, if the facility is associated with Dept of Education, Dept for the Aging or Parks DeptPlain TextRemoved in 2018
52
n/aSchool ZipZip of facility incident location, if the facility is associated with Dept of Education, Dept for the Aging or Parks DeptNumberRemoved in 2018
53
n/aSchool Not FoundY' in this field indicates the facility was not foundPlain TextRemoved in 2018
54
n/a
School or Citywide Complaint
If the incident is about a Dept of Education facility, this field will indicate if the complaint is about a particualr school or a citywide issue.Plain TextRemoved in 2018
Loading...
Main menu