Ohio White Pages Database v.1.0.4
5,045,420 Ohio Residents
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.4.
Data dictionary
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 5,045,420 | 100% | int(11) | Unique Identifier |
| con_first_name | 5,045,420 | 100% | varchar(30) | Contact Person - First Name |
| con_last_name | 5,045,109 | 100% | varchar(40) | Contact Person - Last Name |
| con_full_name | 5,045,420 | 100% | varchar(100) | Contact Person - Full Name |
| con_gender | 5,045,420 | 100% | enum('U','M','F') | Gender - Unknown, Male, Female |
| con_age | 4,877,303 | 97% | varchar(50) | Age Bracket |
| con_res_type | 5,045,420 | 100% | varchar(100) | Residence Type |
| con_home_age | 2,772,312 | 55% | varchar(100) | Age of Home |
| con_res_length | 5,045,420 | 100% | varchar(100) | Length of Residence |
| con_interests | 1,535,063 | 30% | varchar(100) | Flags - Internet, Dogs, Cats, Stocks, Pools |
| e_address | 4,819,478 | 96% | varchar(100) | Physical Address |
| e_city | 5,045,420 | 100% | varchar(50) | Physical Address City |
| e_state | 5,045,420 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 4,819,479 | 96% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 4,819,479 | 96% | varchar(10) | Zip +4 for US Physical Addresses |
| e_carrier | 4,885,279 | 97% | varchar(20) | Address Carrier Route |
| biz_phone | 3,132,336 | 62% | varchar(20) | Home Phone Number |
| e_country | 5,045,420 | 100% | varchar(20) | Physical Address Country |
| loc_county | 4,819,479 | 96% | varchar(40) | Physical Address County |
| loc_area_code | 4,801,455 | 95% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 4,801,455 | 95% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 2,037,367 | 40% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 1,901,525 | 38% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 4,801,455 | 95% | varchar(6) | Location Time Zone |
| loc_DST | 5,045,420 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 4,801,455 | 95% | varchar(15) | Latitude (Centroid Based) |
| loc_LONG_centroid | 4,801,455 | 95% | varchar(15) | Longitude (Centroid Based) |
| est_home_value | 2,772,394 | 55% | varchar(100) | Estimated Home Value |
| est_income | 5,045,420 | 100% | varchar(20) | Estimated Household Income |
| flag_owned | 5,045,420 | 100% | varchar(20) | Home Ownership - Owner, Renter, Unknown |
| mtg_age | 1,992,536 | 39% | varchar(100) | Mortgage Age |
| mtg_count | 1,992,536 | 39% | varchar(50) | Mortgage Count |
| mtg_fin_type | 1,992,536 | 39% | varchar(100) | Mortgage Finance Type |
| mtg_ltv | 1,992,536 | 39% | varchar(100) | Mortgage Loan to Value |
| mtg_loan_tp | 4,046,822 | 80% | varchar(100) | Mortgage Loan Type |
| Ohio Residents Records Information | ||
|---|---|---|
| Adams County | 13,139 | Ohio Residents |
| Allen County | 39,449 | Ohio Residents |
| Ashland County | 19,847 | Ohio Residents |
| Ashtabula County | 43,149 | Ohio Residents |
| Athens County | 27,550 | Ohio Residents |
| Auglaize County | 22,498 | Ohio Residents |
| Belmont County | 28,961 | Ohio Residents |
| Brown County | 15,882 | Ohio Residents |
| Butler County | 131,640 | Ohio Residents |
| Carroll County | 8,997 | Ohio Residents |
| Champaign County | 15,308 | Ohio Residents |
| Clark County | 60,676 | Ohio Residents |
| Clermont County | 78,104 | Ohio Residents |
| Clinton County | 18,134 | Ohio Residents |
| Columbiana County | 46,109 | Ohio Residents |
| Coshocton County | 13,084 | Ohio Residents |
| Crawford County | 18,579 | Ohio Residents |
| Cuyahoga County | 598,685 | Ohio Residents |
| Darke County | 20,621 | Ohio Residents |
| Defiance County | 15,862 | Ohio Residents |
| Delaware County | 55,051 | Ohio Residents |
| Erie County | 36,273 | Ohio Residents |
| Fairfield County | 48,886 | Ohio Residents |
| Fayette County | 10,418 | Ohio Residents |
| Franklin County | 510,990 | Ohio Residents |
| Fulton County | 19,357 | Ohio Residents |
| Gallia County | 13,261 | Ohio Residents |
| Geauga County | 32,983 | Ohio Residents |
| Greene County | 57,104 | Ohio Residents |
| Guernsey County | 17,571 | Ohio Residents |
| Hamilton County | 372,063 | Ohio Residents |
| Hancock County | 27,249 | Ohio Residents |
| Hardin County | 12,696 | Ohio Residents |
| Harrison County | 7,814 | Ohio Residents |
| Henry County | 11,299 | Ohio Residents |
| Highland County | 16,489 | Ohio Residents |
| Hocking County | 11,511 | Ohio Residents |
| Holmes County | 8,116 | Ohio Residents |
| Huron County | 29,459 | Ohio Residents |
| Jackson County | 13,500 | Ohio Residents |
| Jefferson County | 33,891 | Ohio Residents |
| Knox County | 22,710 | Ohio Residents |
| Lake County | 98,203 | Ohio Residents |
| Lawrence County | 24,808 | Ohio Residents |
| Licking County | 56,127 | Ohio Residents |
| Logan County | 19,165 | Ohio Residents |
| Lorain County | 112,334 | Ohio Residents |
| Lucas County | 196,507 | Ohio Residents |
| Madison County | 17,145 | Ohio Residents |
| Mahoning County | 108,610 | Ohio Residents |
| Marion County | 26,588 | Ohio Residents |
| Medina County | 62,019 | Ohio Residents |
| Meigs County | 8,341 | Ohio Residents |
| Mercer County | 16,545 | Ohio Residents |
| Miami County | 42,339 | Ohio Residents |
| Monroe County | 5,561 | Ohio Residents |
| Montgomery County | 262,031 | Ohio Residents |
| Morgan County | 5,249 | Ohio Residents |
| Morrow County | 8,820 | Ohio Residents |
| Muskingum County | 37,687 | Ohio Residents |
| Noble County | 3,731 | Ohio Residents |
| Ottawa County | 23,010 | Ohio Residents |
| Paulding County | 7,684 | Ohio Residents |
| Perry County | 15,255 | Ohio Residents |
| Pickaway County | 18,267 | Ohio Residents |
| Pike County | 10,607 | Ohio Residents |
| Portage County | 66,209 | Ohio Residents |
| Preble County | 16,988 | Ohio Residents |
| Putnam County | 14,129 | Ohio Residents |
| Richland County | 49,474 | Ohio Residents |
| Ross County | 27,893 | Ohio Residents |
| Sandusky County | 22,705 | Ohio Residents |
| Scioto County | 31,978 | Ohio Residents |
| Seneca County | 25,618 | Ohio Residents |
| Shelby County | 18,045 | Ohio Residents |
| Stark County | 165,165 | Ohio Residents |
| Summit County | 226,530 | Ohio Residents |
| Trumbull County | 88,139 | Ohio Residents |
| Tuscarawas County | 36,705 | Ohio Residents |
| Union County | 14,578 | Ohio Residents |
| Van Wert County | 10,208 | Ohio Residents |
| Vinton County | 4,726 | Ohio Residents |
| Warren County | 64,848 | Ohio Residents |
| Washington County | 24,370 | Ohio Residents |
| Wayne County | 42,756 | Ohio Residents |
| Williams County | 15,825 | Ohio Residents |
| Wood County | 51,201 | Ohio Residents |
| Wyandot County | 9,791 | Ohio Residents |
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.