# Visitors Table

The Visitors Table stores comprehensive information about individuals who have visited a website with the Untitled ID tag installed. B2B, B2C, and PTE records are consolidated in this table view. See table structure below.&#x20;

## Table Structure

| Column                              | Description                                                                                                                                                                                                                               |
| ----------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| tag\_id                             | Unique ID for a singular Untitled Identity tag                                                                                                                                                                                            |
| hem                                 | Hashed email (SHA256) associated with a tag fire                                                                                                                                                                                          |
| first\_name                         | First name of matched record                                                                                                                                                                                                              |
| last\_name                          | Last name of matched record                                                                                                                                                                                                               |
| business\_email                     | Business email associated with the record                                                                                                                                                                                                 |
| mobile\_phone                       | Mobile number associated with the record                                                                                                                                                                                                  |
| linkedin\_url                       | LinkedIn URL for the record                                                                                                                                                                                                               |
| personal\_address                   | Personal address associated with the record                                                                                                                                                                                               |
| personal\_address2                  | Personal address 2 associated with the record                                                                                                                                                                                             |
| personal\_city                      | Personal address city                                                                                                                                                                                                                     |
| personal\_state                     | Personal address state                                                                                                                                                                                                                    |
| personal\_zip                       | Personal address zip                                                                                                                                                                                                                      |
| personal\_zip4                      | Plus 4 extension of personal\_zip (does not include personal\_zip)                                                                                                                                                                        |
| personal\_email                     | The most observed personal email and match for the record                                                                                                                                                                                 |
| gender                              | Gender of record (M/F/U)                                                                                                                                                                                                                  |
| age\_range                          | [Age range](#age-range-values) of record (18-24, 25-34, 35-44, 45-54, 55-64, 65 and older)                                                                                                                                                |
| married                             | Determination if the record is married (Y/N)                                                                                                                                                                                              |
| income\_range                       | [Income range](#age-range-values-1) of record                                                                                                                                                                                             |
| net\_worth                          | Estimate of a households [total financial assets](#net-worth-values) minus liabilities. Assets include financial holdings such as deposit accounts, investments and home value. Liabilities include loans, mortgages and credit card debt |
| homeowner                           | Probabilistic and deterministic data set to capture home ownership (Y/N)                                                                                                                                                                  |
| job\_title                          | Job title associated with the record                                                                                                                                                                                                      |
| seniority\_level                    | Modeled [seniority](#seniority-level-values) based on job title                                                                                                                                                                           |
| department                          | Modeled [department](#department-values) based on job title                                                                                                                                                                               |
| professional\_address               | Business address                                                                                                                                                                                                                          |
| professional\_address2              | Business address 2                                                                                                                                                                                                                        |
| professional\_city                  | Business address city                                                                                                                                                                                                                     |
| professional\_state                 | Business address state                                                                                                                                                                                                                    |
| professional\_zip                   | Business zip                                                                                                                                                                                                                              |
| professional\_zip4                  | Plus 4 extension of professional\_zip (does not include professional\_zip)                                                                                                                                                                |
| company\_name                       | Company name associated with job title                                                                                                                                                                                                    |
| company\_domain                     | Company domain associated with company name and business email                                                                                                                                                                            |
| company\_phone                      | Comma separated array of phone numbers associated with the company                                                                                                                                                                        |
| company\_sic                        | Semicolon separated array of SIC codes associated with the company                                                                                                                                                                        |
| company\_naics                      | Comma separated array of NAICS codes                                                                                                                                                                                                      |
| company\_address                    | Company address                                                                                                                                                                                                                           |
| company\_city                       | Company address city                                                                                                                                                                                                                      |
| company\_state                      | Company address state                                                                                                                                                                                                                     |
| company\_zip                        | Company address zip                                                                                                                                                                                                                       |
| company\_linkedin\_url              | Corporate LinkedIn URL                                                                                                                                                                                                                    |
| company\_revenue                    | [Revenue range](#company-revenue-values) of the company                                                                                                                                                                                   |
| company\_employee\_count            | [Range of employees](#company-employee-count-values) based on observed employees                                                                                                                                                          |
| primary\_industry                   | [Primary industry](#primary-industry-values) associated with the company mapped to LinkedIn industries                                                                                                                                    |
| business\_email\_validation\_status | Valid is included if the email has been validated by an email service provider or null if validation is unavailable                                                                                                                       |
| business\_email\_last\_seen         | Unix timestamp of the last activity signal                                                                                                                                                                                                |
| personal\_email\_validation\_status | Valid is included if the email has been validated by an email service provider or null if validation is unavailable                                                                                                                       |
| personal\_email\_last\_seen         | Unix timestamp of the last activity signal                                                                                                                                                                                                |
| last\_updated                       | Unix timestamp of when the record was last updated                                                                                                                                                                                        |
| ip                                  | IP address associated with the tag fire                                                                                                                                                                                                   |
| un\_processed\_timestamp            | Unix timestamp of when the record was processed                                                                                                                                                                                           |
| un\_updated\_timestamp              | Unix timestamp of when the record was last updated                                                                                                                                                                                        |
| record\_uuid                        | A uuid for each record in the table                                                                                                                                                                                                       |

### Age Range Values <a href="#age-range-values" id="age-range-values"></a>

| 18-24        |
| ------------ |
| 25-34        |
| 35-44        |
| 45-54        |
| 55-64        |
| 65 and older |

### Income Range Values <a href="#age-range-values" id="age-range-values"></a>

| Less than $20,000    |
| -------------------- |
| $20,000 to $44,999   |
| $45,000 to $59,999   |
| $60,000 to $74,999   |
| $75,000 to $89,999   |
| $90,000 to $119,999  |
| $120,000 to $149,999 |
| $150,000 to $199,999 |
| $200,000 to $249,999 |
| $250,000+            |

### Net Worth Values

| Less than -$20,000   |
| -------------------- |
| -$20,000 to -$2,500  |
| -$2,499 to $2,499    |
| $2,500 to $24,999    |
| $25,000 to $49,999   |
| $50,000 to $74,999   |
| $75,000 to $99,999   |
| $100,000 to $149,999 |
| $150,000 to $249,999 |
| $250,000 to $374,999 |
| $375,000 to $499,999 |
| $500,000 to $749,999 |
| $750,000 to $999,999 |
| More than $1,000,000 |

### Seniority Level Values

| CXO      |
| -------- |
| VP       |
| Director |
| Manager  |
| Staff    |

### Department Values

| Administrative                   |
| -------------------------------- |
| Community And Social Services    |
| Education                        |
| Engineering                      |
| Executive                        |
| Finance                          |
| Government                       |
| Health Services                  |
| Human Resources                  |
| Information Technology           |
| Legal                            |
| Marketing                        |
| Media And Communications         |
| Military And Protective Services |
| Operations                       |
| Product Management               |
| Real Estate                      |
| Sales                            |

### Company Revenue Values

| 0                          |
| -------------------------- |
| Under 1 Million            |
| 1 Million to 5 Million     |
| 5 Million to 10 Million    |
| 10 Million to 25 Million   |
| 25 Million to 50 Million   |
| 50 Million to 100 Million  |
| 100 Million to 250 Million |
| 250 Million to 500 Million |
| 500 Million to 1 Billion   |
| 1 Billion and Over         |

### Company Employee Count Values

| 0             |
| ------------- |
| 1 to 10       |
| 11 to 25      |
| 26 to 50      |
| 51 to 100     |
| 101 to 250    |
| 251 to 500    |
| 501 to 1000   |
| 1001 to 5000  |
| 5001 to 10000 |
| 10000+        |

### Primary Industry Values

| Accounting                                             |
| ------------------------------------------------------ |
| Advertising Services, Marketing Services               |
| Airlines And Aviation                                  |
| Alternative Dispute Resolution                         |
| Alternative Medicine                                   |
| Animation                                              |
| Appliances, Electrical, And Electronics  Manufacturing |
| Architecture And Planning                              |
| Armed Forces                                           |
| Artists And Writers                                    |
| Automation Machinery Manufacturing                     |
| Automotive                                             |
| Aviation And Aerospace Component  Manufacturing        |
| Banking                                                |
| Beverage Manufacturing                                 |
| Biotechnology                                          |
| Book And Periodical Publishing                         |
| Broadcast Media Production And  Distribution           |
| Building Construction                                  |
| Business Consulting And Services                       |
| Capital Markets                                        |
| Chemical Manufacturing                                 |
| Civic And Social Organizations                         |
| Civil Engineering                                      |
| Commercial Real Estate                                 |
| Computer And Network Security                          |
| Computer Games                                         |
| Computer Hardware Manufacturing                        |
| Computer Networking                                    |
| Computer Networking Products                           |
| Computers And Electronics Manufacturing                |
| Consumer Electronics                                   |
| Consumer Goods                                         |
| Consumer Services                                      |
| Cosmetics                                              |
| Dairy Product Manufacturing                            |
| Defense And Space Manufacturing                        |
| Design Services                                        |
| Education Administration Programs                      |
| E-Learning                                             |
| Entertainment Providers                                |
| Environmental Services                                 |
| Events Services                                        |
| Executive Offices                                      |
| Facilities Services                                    |
| Farming                                                |
| Financial Services                                     |
| Fine Art                                               |
| Fisheries                                              |
| Food And Beverage Manufacturing                        |
| Food And Beverage Services                             |
| Freight And Package Transportation                     |
| Fundraising                                            |
| Furniture And Home Furnishings  Manufacturing          |
| Gambling Facilities And Casinos                        |
| Glass, Ceramics And Concrete  Manufacturing            |
| Government Administration                              |
| Government Relations Services                          |
| Health, Wellness And Fitness                           |
| Higher Education                                       |
| Hospitality                                            |
| Hospitals And Health Care                              |
| Human Resources Services                               |
| Individual And Family Services                         |
| Industrial Machinery Manufacturing                     |
| Insurance                                              |
| International Affairs                                  |
| International Trade And Development                    |
| Internet                                               |
| Investment Banking                                     |
| Investment Management                                  |
| It Services And It Consulting                          |
| Judiciary                                              |
| Law Enforcement                                        |
| Law Practice                                           |
| Leasing Non-Residential Real Estate                    |
| Legal Services                                         |
| Legislative Offices                                    |
| Libraries                                              |
| Logistics And Supply Chain                             |
| Machinery                                              |
| Machinery Manufacturing                                |
| Manufacturing                                          |
| Maritime Transportation                                |
| Market Research                                        |
| Mechanical Or Industrial Engineering                   |
| Medical Equipment Manufacturing                        |
| Medical Practices                                      |
| Mental Health Care                                     |
| Military                                               |
| Mining                                                 |
| Motion Pictures And Film                               |
| Motor Vehicle Manufacturing                            |
| Movies, Videos, And Sound                              |
| Museums, Historical Sites, And Zoos                    |
| Musicians                                              |
| Nanotechnology Research                                |
| Newspaper Publishing                                   |
| Newspapers                                             |
| Nonprofit Organization Management                      |
| Non-Profit Organizations                               |
| Oil And Gas                                            |
| Online Audio And Video Media                           |
| Outsourcing And Offshoring Consulting                  |
| Packaging And Containers Manufacturing                 |
| Paper And Forest Product Manufacturing                 |
| Personal Care Product Manufacturing                    |
| Pharmaceutical Manufacturing                           |
| Philanthropic Fundraising Services                     |
| Photography                                            |
| Plastics Manufacturing                                 |
| Political Organizations                                |
| Primary And Secondary Education                        |
| Printing Services                                      |
| Professional Training And Coaching                     |
| Program Development                                    |
| Public Policy Offices                                  |
| Public Relations And Communications  Services          |
| Public Safety                                          |
| Railroad Equipment Manufacturing                       |
| Ranching                                               |
| Real Estate                                            |
| Recreational Facilities                                |
| Religious Institutions                                 |
| Renewable Energy Semiconductor  Manufacturing          |
| Renewables & Environment                               |
| Research                                               |
| Restaurants                                            |
| Retail                                                 |
| Retail Apparel And Fashion                             |
| Retail Art Supplies                                    |
| Retail Groceries                                       |
| Retail Luxury Goods And Jewelry                        |
| Retail Office Equipment                                |
| Security And Investigations                            |
| Semiconductor Manufacturing                            |
| Shipbuilding                                           |
| Software Development                                   |
| Spectator Sports                                       |
| Sporting Goods Manufacturing                           |
| Sports                                                 |
| Strategic Management Services                          |
| Supermarkets                                           |
| Technology And Information                             |
| Telecommunications                                     |
| Textile Manufacturing                                  |
| Think Tanks                                            |
| Tobacco Manufacturing                                  |
| Translation And Localization                           |
| Transportation, Logistics, Supply Chain  And Storage   |
| Transportation/Trucking/Railroad                       |
| Travel Arrangements                                    |
| Truck Transportation                                   |
| Utilities                                              |
| Venture Capital And Private Equity  Principals         |
| Veterinary Services                                    |
| Warehousing And Storage                                |
| Wellness And Fitness Services                          |
| Wholesale                                              |
| Wholesale Building Materials                           |
| Wholesale Import And Export                            |
| Wine And Spirits                                       |
| Wireless Services                                      |
| Writing And Editing                                    |

\
\
\
\
\
\
\ <br>
