Oregon White Pages Database v.1.0.0
1,574,533 Oregon Consumers
AccountWelcome, guestSign in / Register

USAGE
Import, modify, combine and analyze within one organization, including work by supervised contractors.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Usage License
Choose this package abovePUBLICATION
All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Publication License
Choose this package aboveMASTER
All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Master License
Choose this package aboveRelease structure
Review the published tables, record coverage, and field names included with release 1.0.0.
Data dictionary
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 1,574,533 | 100% | int(11) | Unique Identifier |
| con_first_name | 1,574,532 | 100% | varchar(30) | Contact Person - First Name |
| con_last_name | 1,574,494 | 100% | varchar(40) | Contact Person - Last Name |
| con_full_name | 1,574,533 | 100% | varchar(100) | Contact Person - Full Name |
| con_gender | 1,574,533 | 100% | enum('U','M','F') | Gender - Unknown, Male, Female |
| con_age | 1,356,833 | 86% | varchar(50) | Age Bracket |
| con_res_type | 1,574,533 | 100% | varchar(100) | Residence Type |
| con_home_age | 595,366 | 38% | varchar(100) | Age of Home |
| con_res_length | 1,574,533 | 100% | varchar(100) | Length of Residence |
| con_interests | 479,860 | 30% | varchar(100) | Flags - Internet, Dogs, Cats, Stocks, Pools |
| e_address | 1,267,746 | 81% | varchar(100) | Physical Address |
| e_city | 1,574,533 | 100% | varchar(50) | Physical Address City |
| e_state | 1,574,533 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 1,267,746 | 81% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 1,267,746 | 81% | varchar(10) | Zip +4 for US Physical Addresses |
| e_carrier | 1,291,244 | 82% | varchar(20) | Address Carrier Route |
| biz_phone | 920,709 | 58% | varchar(20) | Home Phone Number |
| e_country | 1,574,533 | 100% | varchar(20) | Physical Address Country |
| loc_county | 1,267,746 | 81% | varchar(40) | Physical Address County |
| loc_area_code | 1,267,540 | 81% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 1,267,540 | 81% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 231,823 | 15% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 720,729 | 46% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 1,267,540 | 81% | varchar(6) | Location Time Zone |
| loc_DST | 1,574,533 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 1,267,540 | 81% | varchar(15) | Latitude (Centroid Based) |
| loc_LONG_centroid | 1,267,540 | 81% | varchar(15) | Longitude (Centroid Based) |
| est_home_value | 595,405 | 38% | varchar(100) | Estimated Home Value |
| est_income | 1,574,533 | 100% | varchar(20) | Estimated Household Income |
| flag_owned | 1,574,533 | 100% | varchar(20) | Home Ownership - Owner, Renter, Unknown |
| mtg_age | 504,657 | 32% | varchar(100) | Mortgage Age |
| mtg_count | 504,657 | 32% | varchar(50) | Mortgage Count |
| mtg_fin_type | 504,657 | 32% | varchar(100) | Mortgage Finance Type |
| mtg_ltv | 504,657 | 32% | varchar(100) | Mortgage Loan to Value |
| mtg_loan_tp | 1,319,651 | 84% | varchar(100) | Mortgage Loan Type |
| Oregon Consumers Records Information | ||
|---|---|---|
| Baker County | 5,765 | Oregon Consumers |
| Benton County | 27,342 | Oregon Consumers |
| Clackamas County | 120,270 | Oregon Consumers |
| Clatsop County | 12,154 | Oregon Consumers |
| Columbia County | 13,740 | Oregon Consumers |
| Coos County | 21,252 | Oregon Consumers |
| Crook County | 6,448 | Oregon Consumers |
| Curry County | 7,900 | Oregon Consumers |
| Deschutes County | 48,359 | Oregon Consumers |
| Douglas County | 33,277 | Oregon Consumers |
| Gilliam County | 302 | Oregon Consumers |
| Grant County | 1,841 | Oregon Consumers |
| Harney County | 1,736 | Oregon Consumers |
| Hood River County | 5,891 | Oregon Consumers |
| Jackson County | 70,383 | Oregon Consumers |
| Jefferson County | 6,294 | Oregon Consumers |
| Josephine County | 28,253 | Oregon Consumers |
| Klamath County | 21,283 | Oregon Consumers |
| Lake County | 2,276 | Oregon Consumers |
| Lane County | 134,416 | Oregon Consumers |
| Lincoln County | 16,354 | Oregon Consumers |
| Linn County | 37,304 | Oregon Consumers |
| Malheur County | 9,001 | Oregon Consumers |
| Marion County | 103,929 | Oregon Consumers |
| Morrow County | 2,047 | Oregon Consumers |
| Multnomah County | 263,195 | Oregon Consumers |
| Polk County | 21,394 | Oregon Consumers |
| Sherman County | 314 | Oregon Consumers |
| Tillamook County | 8,442 | Oregon Consumers |
| Umatilla County | 20,293 | Oregon Consumers |
| Union County | 8,601 | Oregon Consumers |
| Wallowa County | 2,456 | Oregon Consumers |
| Wasco County | 6,690 | Oregon Consumers |
| Washington County | 171,434 | Oregon Consumers |
| Wheeler County | 335 | Oregon Consumers |
| Yamhill County | 26,775 | Oregon Consumers |
Need a closer fit?
A clear path from download to project
Understand the files, check the sample coverage, and choose the license that fits your use.