Data Dictionary

Column Type Label Description
issue text Issue

Individual 311 issue. All 311 issues are contained by a category.

public_access_level text Public access level

This field is used to set the geo_accuracy field in the 3-1-1 requests data tables, which is in turn used to describe whether to obfuscate the geocoordinates.

category text Category

Category of 311 issue. All 311 issues appear in a category. Categories are used to group similar requests by type.

department text Department

Department receiving the 311 issue. All issues appearing in the Web reporting form have been assigned to a City of Pittsburgh Department or partner.

codebook_version numeric Codebook version

Distinguishes between issue types dating from the "2015" Codebook (used for the original data table) and those newly added in the 2024 revision.

request_type_id numeric Request type ID

Identifier for the request type, used in the 2024-vintage version of the 311 table.

count_as_of_mid2024 numeric Count (as of mid-2024)

The total number of requests of this type at the time of the 2024 revision of the Codebook. This is useful for showing a) the popularity of request types but also b) how some request types are not used at all.

definition text Definition

If an issue is not self-descriptive, the definition field contains additional detail.

Additional Information

Field Value
Data last updated September 19, 2024
Metadata last updated September 19, 2024
Created September 19, 2024
Format CSV
License Creative Commons Attribution
Datastore activeTrue
Has viewsTrue
Hashfd136e3c532d2c184df374d8b96571d7
Id6a2c9de6-9cb8-4da6-bd78-0a913cc5790c
Mimetypetext/csv
Package ida8f7a1c2-7d4d-4daa-bc30-b866855f0419
Position2
PreviewTrue
Preview rows403
Size29.1 KiB
Stateactive
Total record count403
Url typeupload