Parcel Data Descriptions
#
NAME
ALIAS
TYPE
WIDTH
DEC
DEFINITION
1
FIPS CODE
FIPS_CODE
A
5
Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.
2
UNFORMATTED APN
UNFRM_APN
A
45
Assessor’s Parcel Number in an unformatted form. This is most often used by the county and others as a unique key (e.g.,10132021A)
3
APN SEQUENCE NBR
APN_SEQ_NO
999
3
This internal sequence number is used to ensure “unique-ness” of the Assessor’s Parcel Number (e.g., 10132021A seq 001)
4
FORMATTED APN
FRM_APN
A
60
Assessor’s Parcel Number in a formatted form. Dashes and decimals are commonly used to break an APN down into logical components (e.g., 101-32-021.A).
5
ORIGINAL APN
ORIG_APN
A
45
Assessor’s Parcel Number exactly as received by source (e.g., 10132-021A00000).
6
ACCOUNT NUMBER
ACCT_NO
A
15
The county or source number used primary for billing. Note: this number is typically not unique to a parcel, but rather to a tax bill (multiple parcels can be combined on 1 bill).
7
THOMAS BROS (new/old) MAP NUMB
TH_BRO_MAP
A
11
The current map page and grid number used by Thomas Bros. Maps company.
8
MAP REFERENCE 1
MAP_REF1
A
60
A CoreLogic unique key to link record to the CoreLogic CD Map product. This is typically built from components of the APN that are relevant to the Assessor Maps (e.g., 101-32, represent Map Book and Map Page numbers).
9
MAP REFERENCE 2
MAP_REF2
A
60
A secondary CoreLogic unique key to link property records to the CoreLogic CD Map product. See MAP REFERENCE 1 above.
10
CENSUS TRACT
CENSUS_TR
A
10
Comprised of Census Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce (Bureau Of The Census).
11
BLOCK NUMBER
BLOCK_NBR
A
5
Subdivision or County Map Block Number
12
LOT NUMBER
LOT_NBR
A
5
Subdivision or County Map Lot Number
13
RANGE
RANGE
A
3
The “range” portion of geographical coordinates based on local surveys. Ranges typically run east or west of pre-determined “meridian” in six mile intervals.
14
TOWNSHIP
TOWNSHIP
A
3
The “township” portion of geographical coordinates based on local surveys. Townships typically run north or south of pre-determined “meridian” in six mile intervals.
15
SECTION
SECTION
A
3
The “section” portion of geographical coordinates based on local surveys. Sections are 1 square mile and there are 36 sections within the intersection of a Range / Township.
16
QUARTER SECTION
QRT_SECT
A
3
A section that has been divided into four “sub” sections (e.g., NE, NW, SE, SW).
17
LAND USE
LAND_USE
A
10
A CoreLogic established Land Use code converted from various county Land Use codes to aid in search and extract functions. See “LUSE” Table for descriptions
18
MOBILE HOME INDICATOR
M_HOME_IND
A
1
This field is populated with a “Y” if a Mobile Home is present on the parcel.
19
ZONING
ZONING
A
15
The data contained in this field is based upon County and/or Local established Zoning Codes and are not converted by CoreLogic
20
PROPERTY INDICATOR
PROP_IND
A
3
A CoreLogic general code used to easily recognize specific property types (e.g, Residential, Condominium, Commercial). See “PROPIND” Table for descriptions
21
SUBDIVISION TRACT NUMBER
SUB_TR_NUM
A
10
The unique number assigned to a specific subdivision by the county. Often this is used in lieu of an actual subdivision name.
22
SUBDIVISION PLAT BOOK
SUB_PLT_BK
A
10
The first component of a recording system used by some counties to catalog subdivision / condo plans (e.g., Book 123 Page 55A).
23
SUBDIVISION PLAT PAGE
SUB_PLT_PG
A
10
The second component of a recording system used by some counties to catalog subdivision / condo plans (e.g., Book 123 Page 55A).
24
SUBDIVISION NAME
SUB_NAME
A
60
The name of the Subdivision or Condominium where the parcel is located (e.g., Highland Mills Estates, Crystal Towers Condo).
25
OWNER CORPORATE INDICATOR
OWN_CP_IND
A
1
The Name of the property owner has been recognized as a corporation or business. See “CORPIND” Table for descriptions
26
OWNER 1 LAST NAME
OWN1_LAST
A
60
The name of the property owner.
27
OWNER 1 FIRST NAME & M I
OWN1_FIRST
A
45
Additional owner names if more than one person owns the property.
28
OWNER 2 LAST NAME
OWN2_LAST
A
60
Non parsed owner name.
29
OWNER 2 FIRST NAME & M I
OWN2_FIRST
A
45
Additional owner names if more than one person owns the property – non parsed.
30
MAIL HOUSE NUMBER PREFIX
MAIL_NBRPX
A
5
The digits found to the left of a traditional house number (e.g., A123 MAIN ST) portion of a mailing address.
31
MAIL HOUSE NUMBER
MAIL_NBR
A
10
The digits found to the immediate right of the Mail House Number Prefix and to the left of a traditional street name (e.g., A123 MAIN ST).
32
MAIL HOUSE NUMBER #2
MAIL_NBR2
A
10
The digits found to the immediate right of the Mail House Number in rare circumstances such as 123-125 MAIN ST
33
MAIL HOUSE NUMBER SUFFIX
MAIL_NBRSX
A
10
The digits found to the right of a traditional house number often representing a multiple or range of entries to a building (e.g., 202B JONES RD, 202-220 JONES RD).
34
MAIL DIRECTION
MAIL_DIR
A
2
This field represents the direction found to the left of the street name (e.g., 9340 N DUNHILL DR / 340 NW 70TH AVE). AKA Directional Abbreviations, Pre-Directional.
35
MAIL STREET NAME
MAIL_STR
A
30
The name or number of the street where a parcel is located (e.g., 9340 N DUNHILL DR / 340 NW 70TH AVE / RR BOX 202, 12 BOX CREEK RD).
36
MAIL MODE
MAIL_MODE
A
5
The Mode or Type of street found to the right of the street name (e.g.., 9340 N DUNHILL DR). AKA Street Designators / Street Suffixes.
37
MAIL QUADRANT
MAIL_QDRT
A
2
The quadrant field is found to the right of Mail Mode (e.g., 100 TEMPLE ST NW, 2040 NW 100 ST SW). AKA Post-Directional.
38
MAIL UNIT NUMBER
MAIL_UNIT
A
10
The unit or suite number of the mailing address (e.g., 649 LAKE SHORE DR #1400).
39
MAIL CITY
MAIL_CITY
A
40
The city associated with the mailing address (e.g., CHICAGO, ATLANTA, DENVER).
40
MAIL STATE
MAIL_STATE
A
2
The two-letter USPS postal abbreviation associated with the state / protectorants / commonwealth (e.g., CA, VI, PR).
41
MAIL ZIP CODE
MAIL_ZIP
A
9
The nine digit (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and non-proprietary processes (e.g., 954630042).
42
MAIL CARRIER CODE
MAIL_CC
A
4
This is the four digit code used by the local mail carrier to identify the delivery path.
43
MAILING OPT-OUT CODE
MAIL_OPT
A
1
A “Y” represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by mail for solicitation. Please see “MAILOPTIND” table for code descriptions.
44
TOTAL VALUE CALCULATED
TOT_VAL
99999999999
11
The “TOTAL” (i.e., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities.
45
LAND VALUE CALCULATED
LAN_VAL
99999999999
11
The “LAND” Value closest to current market value used for assessment by county or local taxing authorities.
46
IMPROVEMENT VALUE CALCULATED
IMP_VAL
99999999999
11
The “IMPROVEMENT” Value closest to current market value used for assessment by county or local taxing authorities.
47
TOTAL VALUE CALCULATED IND
TOT_VAL_CD
A
1
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the TOTAL VALUE CALCULATED field. Please see “VALTY” table for code descriptions.
48
LAND VALUE CALCULATED IND
LAN_VAL_CD
A
1
The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the LAND VALUE CALCULATED field. Please see “VALTY” table for code descriptions.
49
ASSD TOTAL VALUE
ASSD_VAL
99999999999
11
The Total Assessed Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.
50
ASSD LAND VALUE
ASSD_LAN
99999999999
11
The Assessed Land Values as provided by the county or local taxing/assessment authority.
51
ASSD IMPROVEMENT VALUE
ASSD_IMP
99999999999
11
The Assessed Improvement Values as provided by the county or local taxing/assessment authority.
52
MKT TOTAL VALUE
MKT_VAL
99999999999
11
The Total Market Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.
53
MKT LAND VALUE
MKT_LAN
99999999999
11
The Market Land Values as provided by the county or local taxing/assessment authority.
54
MKT IMPROVEMENT VALUE
MKT_IMP
99999999999
11
The Market Improvement Values as provided by the county or local taxing/assessment authority.
55
APPR TOTAL VALUE
APPR_VAL
99999999999
11
The Total Appraised Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.
56
APPR LAND VALUE
APPR_LAN
99999999999
11
The Appraised Land Values as provided by the county or local taxing/assessment authority.
57
APPR IMPROVEMENT VALUE
APPR_IMP
99999999999
11
The Appraised Improvement Values as provided by the county or local taxing/assessment authority.
58
TAX AMOUNT
TAX_AMT
99999999999.99
13
2
The Total Tax amount provided by the county or local taxing/assessment authority.
59
TAX YEAR
TAX_YR
YYYY
4
The tax year for which the taxes were billed.
60
ASSESSED YEAR
ASSD_YR
YYYY
4
The assessment year for which the taxes were billed.
61
TAX CODE AREA
TAX_AREA
A
10
This is a county specific code that represent the tax entity(s) for which a parcel is taxed (e.g., Park Hosp Dist, Hall Sch Dist,).
62
DOCUMENT NO
DOC_NBR
A
12
The document number used by some counties to record sales transactions (e.g., 000012345678).
63
BOOK & PAGE
SALE_BK_PG
A
12
The Book and Page number used by some counties to catalog their sales recordings (e.g., 001234005678).
64
DOCUMENT TYPE
DOC_TYP
A
6
The type of deed used to record the sales transaction (e.g., Grant, Quit, Foreclosure). Please see “DEEDC” table for code descriptions.
65
RECORDING DATE
REC_DT
YYYYMMDD
8
The date the sales transaction was recorded at the county (e.g., 19621028)
66
SALE DATE
SALE_DT
YYYYMMDD
8
The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).
67
SALE PRICE
SALE_PRICE
99999999999.99
13
2
Price of the sale as depicted on the recorded sales transaction.
68
SALE CODE
SALE_TYP
A
4
This field indicates what the financial consideration is.
Please see “SALECD” table for code descriptions
69
SELLER NAME
SELL_NAME
A
60
The seller’s name as it appears on the recorded sales transaction.
70
TRANSACTION TYPE
TRAN_TYPE
A
3
This identifies situations associated with the sale (e.g., Resale, Construction Loan, Seller Carryback). Please see “TRNTP” table for code descriptions.
71
TITLE COMPANY CODE
TITL_CO_CD
A
5
This is a CoreLogic internal code used to identify the Title Company that was associated with the sales transaction.
72
TITLE COMPANY NAME
TITL_CO_NM
A
60
This is the Title Company associated with the sales transaction
73
RESIDENTIAL MODEL INDICATOR
RES_MOD_CD
A
1
A code to indicate whether the property is residential based on individual zipcodes and values. “Y” = yes, “N” or blank = no
74
1st MORTAGE AMOUNT
MTG_AMT
99999999999.99
13
2
The amount of the first mortgage as depicted on the recorded document.
75
MORTGAGE DATE
MTG_DT
YYYYMMDD
8
The date the mortgage was initiated.
76
MORTGAGE LOAN TYPE CODE
MTG_LOAN
A
5
Type of loan secured (e.g., Conventional, FHA, VA). Please see “MTGTP” table for code descriptions.
77
MORTGAGE DEED TYPE
MTG_DEED
A
6
Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed). Please see “DETDOCTYP” descriptions.
78
MORTGAGE TERM CODE
MTG_TRM_CD
A
4
This code is used to identify whether the number stored in the MORTGAGE TERM field is in Days, Months or Years. Please see “MTGTC” table for code descriptions.
79
MORTGAGE TERM
MTG_TRM
99999
5
The length of time before the mortgage matures (e.g., 15yrs, 30 yrs, 45dys).
80
MORTGAGE DUE DATE
MTG_DUE_DT
YYYYMMDD
8
The date the mortgage amount becomes due.
81
MORTGAGE ASSUMPTION AMOUNT
MTG_ASSUM
99999999999
11
The assumption amount related to an existing mortgage.
82
LENDER CODE
MTG_LEN_CD
A
10
This is a CoreLogic internal code used to identify the Lending Company that was associated with the sales transaction.
83
LENDER NAME
MTG_LEN_NM
A
60
This is the name of the lender on the original recorded document.
84
2nd MORGAGE AMOUNT
MTG2_AMT
99999999999.99
13
2
This is the amount associated with the 2nd mortgage.
85
2nd MORTGAGE LOAN TYPE CODE
MTG2_LOAN
A
5
Type of loan secured as part of the 2nd mortgage (e.g., Conventional, FHA, VA). Please see “MTGTP” table for code descriptions
86
2nd DEED TYPE
MTG2_DEED
A
6
Type of deed used for recording the 2nd mortgage (e.g., Agreement of Sale, Assumption, Correction Deed). Please see “DETDOCTYP” table for code descriptions
87
FRONT FOOTAGE
FRONT_FT
9999999.9999
11
4
The linear feet across the front of the lot – facing the street.
88
DEPTH FOOTAGE
DEPTH_FT
9999999.9999
11
4
The linear feet between the front and back of the lot.
89
ACRES
LAND_ACRES
999999999.9999
13
4
Total land mass in Acres.
90
LAND SQUARE FOOTAGE
LAND_SQ_FT
999999999
9
Total land mass is Square Feet.
91
LOT AREA (ALPHA)
LOT_AREA
A
20
A textual description of the lot area, which may include size and unique attributes of the lot (e.g., irregular lot size).
92
UNIVERSAL BUILDING SQUARE FEET
UBLD_SQ_FT
999999999
9
The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted, Gross).
93
BUILDING SQUARE FEET IND
BLD_SQ_IND
A
1
The codes appearing in this field indicates the source used to populate the UNIVERSAL BUILDING SQUARE FEET field (e.g., Living, Adjusted, Gross). Please see “BLDSF” table for code descriptions.
94
BUILDING SQUARE FEET
BLD_SQ_FT
999999999
9
The size of the building in Square Feet. This field is most commonly populated as a cumulative total when a county does not differentiate between Living and Non-living areas.
95
LIVING SQUARE FEET
LIV_SQ_FT
9999999.99
9
2
This is the area of a building that is used for general living. This is typically the area of a building that is heated or air conditioned and generally does not include Garage, Porch or Unfinished Basement Square Footage values.
96
GROUND FLOOR SQUARE FEET
GF_SQ_FT
9999999.99
9
2
Square footage of the part of the building which is level with the ground (typically the front of the building). This is generally above the basement(s) and below the second floor.
97
GROSS SQUARE FEET
GR_SQ_FT
9999999.99
9
2
This is the square footage for the entire building. Typically this represents all square feet under the roof.
98
ADJUSTED GROSS SQUARE FEET
ADJ_SQ_FT
9999999.99
9
2
This is the square footage used by the county or local taxing / assessment authority to determine Improvement Value. This figure is typically 100% of the living area, plus lower percentage of non-living area.
99
BASEMENT SQUARE FEET
BSMT_SQ_FT
9999999.99
9
2
This is total square footage associated with Basement portion of a building. This would include both finished and unfinished areas.
100
GARAGE/PARKING SQUARE FEET
PKG_SQ_FT
9999999.99
9
2
This is the total square footage of the primary garage or parking area (i.e., commercial). This includes both finished and unfinished areas.
101
YEAR BUILT
YR_BLT
YYYY
4
This is the construction year of the original building.
102
EFFECTIVE YEAR BUILT
EFF_YR_BLT
YYYY
4
This is the first year the building was assessed with its current components (e.g., a building is originally constructed in 1960 and a bedroom and bath was added to the building in 1974. The Year Built would be 1960 and the Effective Year Built would be 1974.
103
BEDROOMS
BEDROOMS
99999
5
Total number of bedroom contained in the primary building.
104
TOTAL ROOMS
ROOMS
99999
5
Total number of rooms contained in the primary building.
105
TOTAL BATHS CALCULATED
BATHS_CAL
99999.99
7
2
Total number of Bathrooms in whole numbers (e.g., a home containing 2 1/2 baths would have the number 3 stored in this field as, three actual rooms have been designated for this purpose).
106
TOTAL BATHS
BATHS
99999.99
7
2
Total number of Bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75).
107
FULL BATHS
FULL_BATHS
99999
5
Total number of Full Baths (typically comprised of a sink, toilet, and bathtub / shower stall). A home containing 2 1/2 baths would have the number 2 stored in this field.
108
HALF BATHS
HALF_BATHS
99999
5
Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 2 stored in this field.
109
1QTR BATHS
QTR1_BATHS
99999
5
Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms).
110
3QTR BATHS
QTR3_BATHS
99999
5
Total number of 3 Quarter Baths (typically comprised of a sink, toilet & shower stall).
111
BATH FIXTURES
BATH_FIX
99999
5
The total number of bathroom fixtures (typically a Full Bath would have 4 fixtures – 1 = sink, 1 = toilet, 1 = bathtub, 1 = shower head).
112
AIR CONDITIONING
AIR_COND
A
3
The type of air conditioning method used to cool the building (e.g., Central, Wall Unit, Evaporative). Please see “ANCHO” table for code descriptions.
113
BASEMENT FINISH
BSMT_FNSH
A
3
The type of basement found in the building (e.g., Finished, Half, Crawl). Please see “BSMTF” table for code descriptions.
114
BLDG CODE
BLD_CODE
A
3
The primary building type (e.g., Bowling Alley, Supermarket). Please see “BISCO” table for code descriptions.
115
BLDG IMPV CODE
BLD_IMP_CD
A
3
The primary improvement type (e.g., Grain Silo, Hanger, Marina). Please see “BISCO” table for code descriptions.
116
CONDITION
CONDITION
A
3
This represent the physical condition of the mail improvement (e.g., Good, Fair, Under Construction). Please see “COND” table for code descriptions.
117
CONSTRUCTION TYPE
CONSTR_TYP
A
3
The primary method of construction (e.g., Steel / Glass, Concrete Block, Log). Please see “CNSTR” table for code descriptions.
118
EXTERIOR WALLS
EXT_WALLS
A
3
The type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer, Frame / Stone). Please see “EXTNW” table for code descriptions.
119
FIREPLACE IND
FRPLCE_IND
A
1
This field is populated with a “Y” if a fireplace is located within the building.
120
FIREPLACE NUMBER
FRPLCE_NBR
999
3
This represent the number of fireplace openings located within the building
121
FIREPLACE TYPE
FRPLCE_TYP
A
3
The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story Brick). Please see “FIREP” table for code descriptions.
122
FOUNDATION
FOUNDATION
A
3
The type of foundation (e.g., Continuous Footing, Pier, Mud Sill). Please see “FOUND” table for code descriptions.
123
FLOOR
FLOOR
A
3
The type of floor construction (e.g., Concrete, Plywood). Please see “FLRCO” table for code descriptions.
124
FRAME
FRAME
A
3
The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore). Please see “RFCO” table for code descriptions.
125
GARAGE
GARAGE
A
3
Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage). Please see “GNPCO” table for code descriptions.
126
HEATING
HEATING
A
3
Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant). Please see “ANHCO” table for code descriptions.
127
PARKING SPACES
PKG_SPACES
99999
5
This represent the total number of Parking Spaces or Car Capacity associated with the Garage or Parking type.
128
PARKING TYPE
PKG_TYP
A
3
Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature. Please see “GNPCO” table for code descriptions.
129
POOL
POOL
A
1
This field is populated with a “Y” if a Pool is present on the parcel
130
POOL CODE
POOL_CD
A
3
Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated). Please see “POOL” table for code descriptions.
131
QUALITY
QUALITY
A
3
Type of construction quality of building (e.g., excellent, economical). Please see “QUAL” table for code descriptions.
132
ROOF COVER
ROOF_COVER
A
3
Type of roof covering (e.g., Clay Tile, Aluminum, Shake). Please see “RFCO” table for code descriptions.
133
ROOF TYPE
ROOF_TYP
A
3
Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard). Please see “RFCO” table for code descriptions.
134
STORIES CODE
STORY_CD
A
3
Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story). Please see “STORY” table for code descriptions.
135
STORIES NUMBER
STORY_NBR
999.99
5
2
Number of stories associated with the building (e.g., 2, 1.5).
136
VIEW
BLD_VIEW
A
3
View from building (e.g., Gulf, Mountains, Pool). Please see “LIVS” table for code descriptions.
137
LOCATION INFLUENCE
LOC_INF
A
3
Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plane, airport). Please see “LIVS” table for code descriptions.
138
NUMBER OF UNITS
BLD_UNITS
999
3
Total number of buildings on the parcel.
139
UNITS NUMBER
UNITS_NBR
99999
5
Number of Residential, Apartment or Business Units.
140
ELECTRIC/ENERGY
ENERGY_USE
A
3
Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source). Please see “ELEC” table for code descriptions. See also “UTIL” table
141
FUEL
FUEL
A
3
Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil). Please see “FUEL” table for code descriptions. See also “UTIL” table
142
SEWER
SEWER
A
3
Type of sewer system on the parcel (e.g., Public, Septic, Commercial). Please see “SEWER” table for code descriptions. See also “UTIL” table
143
WATER
WATER
A
3
Type of water service on the parcel (e.g., Public, Well, Cistern). Please see “WATER” table for code descriptions. See also “UTIL” table
144
LEGAL
LEGAL1
A
250
First 250 bytes of the total 750 byte legal description.
145
LEGAL
LEGAL2
A
250
Second 250 bytes of the total 750 byte legal description.
146
LEGAL
LEGAL3
A
250
Third 250 bytes of the total 750 byte legal description.