Data Descriptions

Parcel Data Descriptions

Code Lookup by Table

	FIELD NAME	ALIAS	TYPE	WIDTH	DEC	FIELD DEFINITIONS
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 IND	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_FRST	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 & MI	OWN2_FRST	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 MORTGAGE 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 load 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" table for code 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	MORTAGE 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 MORTGAGE 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 load 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 Bath Rooms 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 1 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.

WordPress Tables