Verizon Customer Data
Service: VerizonDescription: The database contains extensive details of Verizon customers.
Total Rows: 7.5 million
Data Fields:
- First Dataset:
- HASHED_LEGCAN
- FRST_NM (First Name)
- CONTRACT_STATUS
- PON_TYPE
- MOCA_ENABLED
- BILLED_SPEED
- PROVISIONED_SPEED
- NBR_DEVICES (Number of Devices)
- AVG_NBR_DEV_90_DAYS_RANGE (Average Number of Devices Over 90 Days)
- AVG_GB_DN_90_DAYS_RANGE (Average GB Download Over 90 Days)
- GIG_ELIGIBLE
- BASIC_INTERNET
- STREAMERS
- GAMERS
- ROUTER_TYPE
- ROUTER_OWNERSHIP
- ROUTER_RENTAL_FEE
- NETWORK_EXTENDER
- CONTRACT_RENEWAL_DATE
- REPORTED_SPEED_ISSUES
- REPORTED_ROUTER_ISSUES
- MODEL_LIFESTAGE
- MDU_FLAG
- RECOMMENDED_SPEED
- Second Dataset:
- CUST_HASH_LOWER
- NM_FIRST (First Name)
- DEVICE_TYPE
- BASE_TARGETING_MESSAGE_CD
- AUTO_PAY_MESSAGE_CD
- THOSE_WHO_SERVE_MESSAGE_CD
- MOBILE_HOME_REWARDS_DISCOUNT_AMT_MESSAGE_CD
- VZ_RWD_BAL_AMT (Verizon Rewards Balance Amount)
- DEVICE_DOLLAR_BAL_AMT (Device Dollar Balance Amount)
- VZUP_REWARDS_CLAIMED (Verizon Up Rewards Claimed)
- VZ_CLOUD_USAGE_2021
- APPLE_ARCADE_ENROLLED_MESSAGE_CD
- GOOGLE_PLAY_PASS_ENROLLED_MESSAGE_CD
- DISCOVERY_PLUS_ENROLLED_MESSAGE_CD
- APPLE_MUSIC_ENROLLED_MESSAGE_CD
- DISNEY_PLUS_ENROLLED_MESSAGE_CD
- DISNEY_BUNDLED_ENROLLED_MESSAGE_CD
- YOUTUBE_TV_MESSAGE_CD
- VZ_CLOUD_UNLIMITED_CUSTOMER_MESSAGE_CD
- VZ_CLOUD_2TB_CUSTOMER_MESSAGE_CD
- VZ_CLOUD_TB_OR_LESS_CUSTOMER_MESSAGE_CD
- DEVICE_PROTECT_CUSTOMER_MESSAGE_CD
- VZ_CALL_FILTER_ENROLLED_MESSAGE_CD
- DIGITAL_SECURE_MESSAGE_CD
- S5GH_CUSTOMER_MESSAGE_CD
- LTE_CUSTOMER_MESSAGE_CD
- ROADSIDE_ASSISTANCE_CUSTOMER_MESSAGE_CD
- HUM_CUSTOMER_MESSAGE_CD
- TRAVELPASS_CUSTOMER_MESSAGE_CD
Example Records:
- First Dataset Record:
- HASHED_LEGCAN: 00594416b31f6f777230e0752bd38017f2df3db1ce4ab48298e66d4e1822c4a7
- First Name: Ilsuk
- Contract Status: CONTRACT
- PON Type: GPON
- MoCA Enabled: MOCA
- Billed Speed: 100
- Provisioned Speed: 100
- Number of Devices: 3
- Average Number of Devices Over 90 Days: LOW
- Average GB Download Over 90 Days: POWER USER
- Gig Eligible: Y
- Basic Internet: Y
- Streamers: 80
- Gamers: 64
- Router Type: BHR4
- Router Ownership: R
- Router Rental Fee: Y
- Network Extender: N
- Contract Renewal Date: 10/18/2021
- Reported Speed Issues: N
- Reported Router Issues: N
- Model LifeStage: M1
- MDU Flag: Y
- Recommended Speed: GIG
- Second Dataset Record:
- Customer Hash: ^05cc32d4766a8d3b332f6b8d3aaf6fd3f2f5bd3a88ac35754d44cafbd072d9b0^
- First Name: ^Rita^
- Device Type: ^Android^
- Base Targeting Message Code: ^PRD_PLAN_START_MORE_UNL_A^
- Verizon Cloud Usage 2021: ^57^
- PRD Plan Start More Unlimited A: ^PRD_PLAN_START_MORE_UNL_A^