Data Dictionary

Column Type Label Description
PARID text Parcel Identification Number

A 16 character unique identifier for the parcel.

PROPERTYHOUSENUM numeric Property Location House Number

House Number for the physical location of property; may be zero or blank.

PROPERTYFRACTION text Property Location House Number Fraction

Continued House Number information for the physical location of property; such as 1/2, the house number ending range, or a letter.

PROPERTYADDRESS text Property Location Street Name

Street name for the physical location of the property, including directional indicators and suffixes.

PROPERTYCITY text Property Location City Name

City where the property is physically located.

PROPERTYSTATE text Property Location State Name

State where the property is physically located.

PROPERTYUNIT text Property Location Unit Number

Unit numbers for the property, such as condo units (e.g. 1, 3C, 115A, B13, etc….).

PROPERTYZIP numeric Property Location Zip code, first 5 digits

Zip Code where the property is physically located.

MUNICODE numeric Municipality Code (Tax District)

Municipality number associated with specified parcel.

MUNIDESC text Municipality Name

Municipality name associated with specified parcel.

SCHOOLCODE text School District Code

School district number associated with specified parcel.

SCHOOLDESC text School District Name

School district name associated with specified parcel.

LEGAL1 text Legal Description 1

Line 1 of parcel legal description from the Deed.

LEGAL2 text Legal Description 2

Line 2 continuation of parcel legal description from the Deed.

LEGAL3 text Legal Description 3

Line 3 continuation of parcel legal description from the Deed.

NEIGHCODE text Neighborhood Number

The ID number for the valuation neighborhood containing this parcel. Valuation neighborhoods were delineated as part of the 2013 reassessment. A valuation neighborhood is a geographic area exhibiting a high degree of homogeneity in economic amenities, land use, economic trends, and property characteristics such as quality, age, and condition.

NEIGHDESC text Neighborhood Name

The name associated with the valuation neighborhood number, if a name exists.

TAXCODE text Tax Status

Tax Status indicates whether or not real estate taxes apply to a parcel's assessment. Parcels may be Taxable (must pay local taxes), Exempt (pay no taxes), or PURTA [Public Utility Realty Tax Act (if taxes are paid, they are paid into a state fund rather than to local taxing bodies)]. Values: 'E' , 'T' or 'P' .

TAXDESC text Tax Status Description

Description for Tax Status codes: '10 - Exempt', '20 - Taxable' or '12 - Public Utility Realty Tax - PURTA'.

TAXSUBCODE text Tax Sub Code (applies to PURTA only)

Tax Sub Code applies only to parcels having the PURTA tax status. Public Utilities may not have to pay taxes (E-Exempt) or they may have to pay taxes into a state fund (T-Taxable).

TAXSUBCODE_DESC text Tax Sub Code Description

Values: E - 'PURTA - Exempt', T - 'PURTA -Taxable' or null.

OWNERCODE numeric Owner Type Code 1

Numeric code categorizes owner as individuals ('REGULAR' ) vs corporations ('CORPORATION').

OWNERDESC text Owner Description

Descriptions for numeric owner codes. [e.g. individuals ('REGULAR' ) vs corporations ('CORPORATION')]

CLASS text

Broad self-explanatory categories for describing the general use of a parcel. Categories: R - RESIDENTIAL, U - UTILITIES, I - INDUSTRIAL, C - COMMERCIAL, O - OTHER, G - GOVERNMENT, F - AGRICULTURAL.

CLASSDESC text Class Description

Broad self-explanatory categories for describing the general use of a parcel. Categories: R - RESIDENTIAL, U - UTILITIES, I - INDUSTRIAL, C - COMMERCIAL, O - OTHER, G - GOVERNMENT, F - AGRICULTURAL.

USECODE text Land Use Code

More detailed than class, these categories further describe the primary use of the parcel. There are about 200 self-explanatory categories.

USEDESC text Land Use Code Description

More detailed than class, these categories further describe the primary use of the parcel. There are about 200 self-explanatory categories.

LOTAREA numeric Sum of Area of Land

Total square footage of land.

HOMESTEADFLAG text Homestead Flag

A property owner may apply for a homestead reduction on their primary residence. If granted (indicated by 'HOM') the owner will receive a standard reduction on their assessment for County taxes under Act 50. They may also receive a variable reduction on their School taxes under Act 1.

FARMSTEADFLAG text Farmstead Flag

A property owner may apply for a farmstead reduction if their primary residence is a farm with at least 10 contiguous acres. If granted (indicated by 'FRM') the owner will receive a standard reduction on their assessment for County taxes under Act 50.

CLEANGREEN text Clean and Green Flag

This field indicates that a parcel is receiving a reduction in their assessment due to the state’s Clean and Green preferential assessment program.

ABATEMENTFLAG text Abatement Flag

This field indicates that a parcel is receiving a reduction in their County assessment due to a County-approved incentive program. Specific programs and amounts vary according to the County resolutions and ordinances in effect at the time. Consult the Office of Property Assessments web page to see the current types of Abatements. Abatements have been available to residential property owners as incentives for new construction and for building improvements. Abatements for commercial properties have been available for local economic revitalization programs. Values: 'Y' or null.

RECORDDATE text Record Date

Date the sale was recorded in the Department of Real Estate (mm/dd/yyyy).

SALEDATE text Sale Date

Date the sale occurred (mm/dd/yyyy).

SALEPRICE numeric Sale Price

Amount paid for the sale (also called the consideration).

SALECODE text Sale Validity Code

A subjective categorization (code) as to whether or not the sale price was representative of current market value. These categorizations are subject to change as sales are reviewed by the Office of Property Assessments or during a reassessment. See further details in the Sale Validation Codes Details tab of the "Property Sale Transaction Data Dictionary".

SALEDESC text Sale Validity Code Description

A subjective categorization (description) as to whether or not the sale price was representative of current market value. These categorizations are subject to change as sales are reviewed by the Office of Property Assessments or during a reassessment. See further details in the Sale Validation Codes Details tab of the "Property Sale Transaction Data Dictionary".

DEEDBOOK text Book Number

Cross-reference to the physical book number where the deed is on file in the Department of Real Estate.

DEEDPAGE text Page Number

Page within the specified deed book corresponding to the first page of this physical deed.

PREVSALEDATE text Previous Sale Date

Date the previous sale occurred (mm/dd/yyyy).

PREVSALEPRICE numeric Previous Sale Price

Amount paid for the previous sale.

PREVSALEDATE2 text Previous Sale Date 2

Date the 2nd previous sale occurred (mm/dd/yyyy).

PREVSALEPRICE2 numeric Previous Sale Price 2

Amount paid for the 2nd previous sale.

CHANGENOTICEADDRESS1 text Change Notice Full Address 1

Address of owner of the property.

CHANGENOTICEADDRESS2 text Change Notice Full Address 2

Address of owner of the property.

CHANGENOTICEADDRESS3 text Change Notice Full Address 3

Address of owner of the property.

CHANGENOTICEADDRESS4 text Change Notice Full Address 4

Address of owner of the property.

COUNTYBUILDING numeric County Assessed Value for Building

The assessed property value of the building for county tax purposes. This amount reflects the remaining assessment after any preferential assessments (such as clean & green) or county reductions (such as homesteads or other abatements) have been deducted from the base year market values.

COUNTYLAND numeric County Assessed Value for Land

The assessed property value of the land for county tax purposes. This amount reflects the remaining assessment after any preferential assessments (such as clean & green) or county reductions (such as homesteads or other abatements) have been deducted from the base year market values.

COUNTYTOTAL numeric County Assessed Value Total

The assessed property value (land and building together) for county tax purposes. This amount reflects the remaining assessment after any preferential assessments (such as clean & green) or county reductions (such as homesteads or other abatements) have been deducted from the base year market values.

COUNTYEXEMPTBLDG numeric County Exempt Building Amount

The amount of assessment reduction granted on a building by the County (for county taxes only) under incentive programs for new construction, building improvements or local economic revitalization.

LOCALBUILDING numeric Local Assessed Value for Building

The assessed property value of the building for local tax purposes (for schools and municipalities). This amount reflects the remaining assessment after preferential assessments (such as clean & green) have been deducted from the base year market values. This value is often higher than the county assessed value since county-only incentives (such as homesteads) have not been deducted.

LOCALLAND numeric Local Assessed Value for Land

The assessed property value of the land for local tax purposes (for schools and municipalities). This amount reflects the remaining assessment after preferential assessments (such as clean & green) have been deducted from the base year market values. This value is often higher than the county assessed value since county-only incentives (such as homesteads) have not been deducted.

LOCALTOTAL numeric Local Assessed Value Total

The assessed property value (land and building together) for local tax purposes (for schools and municipalities). This amount reflects the remaining assessment after preferential assessments (such as clean & green) have been deducted from the base year market values. This value is often higher than the county assessed value since county-only incentives (such as homesteads) have not been deducted.

FAIRMARKETBUILDING numeric Fair Market Building Value

The base year appraised fair market value of the building. This value has had no reductions, not even Clean and Green preferential assessment reduction. Allegheny County currently uses a base year of 2012.

FAIRMARKETLAND numeric Fair Market Land Value

The base year appraised fair market value of the land. This value has had no reductions, not even Clean and Green preferential assessment reduction. Allegheny County currently uses a base year of 2012.

FAIRMARKETTOTAL numeric Fair Market Total Value

The base year appraised fair market value of land and building together. This value has had no reductions, not even Clean and Green preferential assessment reduction. Allegheny County currently uses a base year of 2012.

STYLE text Dwelling - Architectural Style

The building style.

STYLEDESC text Dwelling - Architectural Style Description

Description for building style.

STORIES numeric Dwelling - Number of Stories

Refers to the story height of the main dwelling. Attics are not included. A fractional story height (e.g. 1.5) denotes an upper story where part of the living space is less than full height due to a sloped roof or dormers.

YEARBLT numeric Dwelling - Year Built

The original date of construction.

EXTERIORFINISH numeric Dwelling - Exterior Wall code

The exterior wall type.

EXTFINISH_DESC text Dwelling - Exterior Wall Description

Description of building material used for exterior walls.

ROOF numeric Dwelling - Roof

The roofing material type.

ROOFDESC text Dwelling - Roof Description

Description of roofing material.

BASEMENT numeric Dwelling - Basement

This code describes the basement under the main part of the dwelling, and categorizes its size in relation to the main dwelling. 1. NONE - there is no basement. 2. SLAB/PIERS -indicates slab or pier construction. 3. CRAWL - indicates crawl space to 1/4 basement area. 4. PART - indicates basement is between 1/4 and 3/4 of the main dwelling area. 5. FULL - indicates 3/4 to full basement area.

BASEMENTDESC text Dwelling - Basement Description

Description of basement type, if one exists.

GRADE text Dwelling - Grade

Grade refers to quality of construction: A, X, XX - have superior materials and workmanship and are typically custom designed or historic homes. B - construction has above average construction and may exceed code. C - is the standard, construction meets code, and is typical of current materials and methods. D - construction is adequate, but below average with minimal features. E - construction lacks some basics and may be a "camp" or seasonal structure. Pluses and minuses may be used.

GRADEDESC text Dwelling - Grade Description

Grade refers to quality of construction: A, X, XX - Very Good and Excellent - have superior materials and workmanship and are typically custom designed or historic homes. B - Good - construction has above average construction and may exceed code. C - Average - is the standard, construction meets code, and is typical of current materials and methods. D - Below Average - construction is adequate, but below average with minimal features. E - Poor - construction lacks some basics and may be a "camp" or seasonal structure. Pluses and minuses may be used.

CONDITION numeric Dwelling - Condition

Code for the overall physical condition or state of repair of a structure, relative to its age. Indicated by number and description: 1- Excellent - outstanding maintenance. 7- Very good - high degree of upkeep. 2- Good - above ordinary maintenance. 3- Average - ordinary maintenance, shows normal wear and tear. 4- Fair - sound but with noticeable deferred maintenance. 5- Poor - structural deterioration caused by significant and chronic deferred maintenance. 8- Very poor - barely livable. 6- Unsound - not suitable for habitation.

CONDITIONDESC text Dwelling - Condition Description

Description for the overall physical condition or state of repair of a structure, relative to its age. Indicated by number and description: 1- Excellent - outstanding maintenance. 7- Very good - high degree of upkeep. 2- Good - above ordinary maintenance. 3- Average - ordinary maintenance, shows normal wear and tear. 4- Fair - sound but with noticeable deferred maintenance. 5- Poor - structural deterioration caused by significant and chronic deferred maintenance. 8- Very poor - barely livable. 6- Unsound - not suitable for habitation.

CDU text Dwelling - CDU

CDU is a composite rating for structures measuring: Condition (physical condition relative to age), Desirability (location, style), and Utility (functional obsolescence of layout or design). Proper neighborhood delineation compensates for most Desirability and Utility issues, leaving Physical Condition the most influential factor in CDU. CDU will be null for vacant land. Excellent - Perfect condition, very attractive and highly desirable. Very good - Slight deterioration, but still quite attractive and desirable. Good - Minor visible deterioration, slightly less attractive and desirable, but still useful. Average - Normal wear and tear, average utility and desirability. Fair - Usable but marked deterioration. Somewhat unattractive and undesirable. Poor - Obvious deterioration, definitely undesirable. Very poor - Extremely undesirable and barely usable. Unsound - Unfit for use.

CDUDESC text Dwelling - CDU Description

CDU is a composite rating for structures measuring: Condition (physical condition relative to age), Desirability (location, style), and Utility (functional obsolescence of layout or design). Proper neighborhood delineation compensates for most Desirability and Utility issues, leaving Physical Condition the most influential factor in CDU. CDU will be null for vacant land. Excellent - Perfect condition, very attractive and highly desirable. Very good - Slight deterioration, but still quite attractive and desirable. Good - Minor visible deterioration, slightly less attractive and desirable, but still useful. Average - Normal wear and tear, average utility and desirability. Fair - Usable but marked deterioration. Somewhat unattractive and undesirable. Poor - Obvious deterioration, definitely undesirable. Very poor - Extremely undesirable and barely usable. Unsound - Unfit for use.

TOTALROOMS numeric Dwelling - Total Rooms

Total number of rooms in the main dwelling. This includes Rec-rooms and FBLA (Finished Basement Living Area). This count is for descriptive purposes only and does not affect assessed value.

BEDROOMS numeric Dwelling - Bedrooms

The total number of separate rooms designed to be used as bedrooms. If a room was designed to be a bedroom, but is being utilized for some other purpose - such as a den, it is to be included in this count. This is for descriptive purposes only and does not affect value.

FULLBATHS numeric Dwelling - Full Baths

A full bath has a toilet, sink and bathing facility (shower or tub).

HALFBATHS numeric Dwelling - Half Baths

A half bath has a toilet and sink only.

HEATINGCOOLING text Dwelling - Heating Cooling

Code for the type of Heating / Cooling system.

HEATINGCOOLINGDESC text Dwelling - Heating Cooling Description

Description for the type Heating / Cooling system.

FIREPLACES numeric Dwelling - Number of Wood burning Fireplaces Stacks

The number of wood-burning fireplace chimneys/vents. This need not equal the number of working fireplaces in the dwelling. This number excludes roof stacks built for bathroom venting, natural gas outlets, etc.

BSMTGARAGE numeric Dwelling - Integral Basement Garage (Number of Cars)

The number of vehicle spaces available in a garage that is basement level and comprises a portion of the main dwelling’s basement. This does not include detached or attached above-grade garages.

FINISHEDLIVINGAREA numeric Finished living area, as measured from the outside of the structure.

Dwelling - Total Square Feet of Living Area

CARDNUMBER numeric Dwelling - Building (card) Number

For parcels having more than one building only one building is shown. This field contains the number of the building being shown (which is usually the main dwelling).

ALT_ID text Alternate Parcel Identification Number

In tax year 2007, parcel ID numbers within certain municipalities were converted to conform to Allegheny County's standard naming convention for parcel ID's. For affected parcels, this field shows the old parcel ID that was in use for tax years 2006 and prior.

TAXYEAR numeric The current certified tax year

The applicable year for which real estate taxes would apply for the parcel. Allegheny County currently assesses value based on how the parcel stood as of Jan 1 of that year. This need not correspond to a calendar year.

ASOFDATE text

The run date of this file

Additional Information

Field Value
Data last updated November 2, 2024
Metadata last updated November 2, 2024
Created November 2, 2017
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Hashe79869c6c1d4606b7dbec6669e47102c
Idf2b8d575-e256-4718-94ad-1e12239ddb92
Mimetypetext/csv
Package id2b3df818-601e-4f06-b150-643557229491
Position0
Size413.6 MiB
Stateactive
Url typeupload