Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1099092026-09-13T11:43:09ZBell—Melissa19520808uhc-91197-58•••-••-2219(580) 440-4043melissa.bell60@hotmail.com··4418 Canyon Road #223LAS VEGASNV89170GRP-3258MEDICARE-ADV-B
ENRENR-1225792026-06-29T05:37:32ZChristyan···MWeaver2005-10-28UHC-43774-91—(369) 633-4816CHRISTIAN.WEAVER14@HOTMAIL.COM8503 BROADWAYJacksonvilleFlorida32291GRP-5969SELECT-EPO
ENRENR-1018672026-05-06T06:44:53ZSamuelEHayes7/12/1995UHC-36765-49—3629297240samuel.hayes@icloud.com2104 Ocean AveJacksonvilleFlorida32245GRP-8132CHOICE-PLUS-PPO
ENRENR-1375572026-08-21T14:41:53ZAndrea—Harvey1976-03-08UHC4558006•••-••-30789193260838andrea.harvey@proton.me7038 Valley View DrivePHOENIX·AZ85075GRP-3059options-ppo
ENRENR-1109352026-07-14T03:21:02ZBryan—Herrera11/28/2003·UHC-94727-57—+1 837 442 4852bryan.herrera28@outlook.com·7399 Palm DriveGlendaleAZ85386GRP-1121MEDICARE-ADV-A
ENRENR-1219732026-06-20T02:33:45Z juenTrichards1968-07-12UHC-31607-39•••-••-319512722861777JUAN.RICHARDS68@AOL.COM5895 Church StreetGlendale·AZ85384GRP-2409MEDICARE-ADV-A
ENRENR-1120062026-03-27T02:02:00Z SAMANTHAPPERKINS20001103UHC-00009-71•••-••-74685703479836samantha.perkins19@aol.com3601 Apache BoulevardMinneapolisMN55404GRP-8306CHOICE-PLUS-PPO
ENRENR-1324112026-10-11T07:32:19ZJaunBCarroll··04-09-1973UHC-99840-10•••-••-0285(581) 791-8030·juan.carroll78@proton.me2647 SAGE CTSacramentoCalifornia·95870GRP-5735SELECT-EPO
ENRENR-1147102026-06-27T08:38:12ZKellyWOBrien4/21/1988UHC8190321•••-••-858918092781764kelly.obrien31@yahoo.com··3449 Camelback RdColumbusOH43266GRP-5182MEDICARE-ADV-A
ENRENR-1326512026-09-02T14:43:58ZGreen, NatalieV—02/08/1946UHC-05349-79··•••-••-4792(707) 373-0259·natalie.green60@proton.me4312 Apache BoulevardGlendaleAZ85378GRP-9905CHOICE-PLUS-PPO
ENRENR-1191222026-03-23T19:46:50ZBRYANC.ANDERSON1956-03-03UHC-91573-67•••-••-52512096502196bryan.anderson51@proton.me2161 Meadow LnORLANDOFL32842GRP-4611NAVIGATE-HMO
ENRENR-1068712026-08-11T06:30:28ZHIROSHIPBROWN1975-12-15·UHC-42657-99•••-••-4641·538-315-1912NULL4342 Oak StTEMPEAZ85296GRP-8856MEDICARE-ADV-A
ENRENR-1211732026-05-25T06:57:22ZJesse·U.Porter1942-02-21UHC-37542-18•••-••-256215076570861JESSE.PORTER98@AOL.COMNULLNULL——GRP-2636SELECT-EPO
ENRENR-1182782026-02-20T04:43:41ZRyan—Hunt1986-03-21UHC-48459-73•••-••-4646·5488772611NULL6165 Ridge Rd Apt 8TEMPEAZ85234GRP-6122··CORE-HMO
ENRENR-1107092026-08-01T08:37:17ZEMMAU.SCOTT1979-11-19UHC-89043-10—433-846-4340emma.scott@icloud.com3917 Lake View RoadTampaFL33607GRP-1969OPTIONS-PPO
ENRENR-1097482026-02-14T09:45:03ZpatriciaR.hayes2000-07-03UHC-59679-50•••-••-9727—patricia.hayes@gmail.com5615 GRAND AVENUEJACKSONVILLEFlorida··32275GRP-1026MEDICARE-ADV-A
ENRENR-1248942026-03-28T10:14:17ZWILLIE O.—·CRUZ·07/16/71UHC9416361•••-••-2033323-603-9794—N/A··——NULLGRP-5573SELECT-EPO
ENRENR-1419312026-08-31T01:47:29ZMICHAELCKIM1981-01-82··UHC0268618•••-••-2139900-970-1989UNKNOWN351 Union StreetAustinTX78787GRP-3885NAVIGATE-HMO
ENR ENR-1346422026-02-18T12:58:07ZWEBER····AMANDA09/08/39UHC-56145-05•••-••-4840914-276-4637·amanda.weber4@yahoo.com4921 DESERT SKY BOULEVARDSCOTTSDALEAZ85283GRP-7537NAVIGATE-HMO
ENRENR-1344272026-09-17T08:37:31ZJUDITHDVALDEZ1996-03-09UHC-53800-49··•••-••-1859383.615.9533UNKNOWN6196 Baseline Road Apt 16San Diego··CA92157GRP-6662NAVIGATE-HMO
ENRENR-1228222026-06-10T21:47:02ZERICUDANIELS07/24/1979UHC-60880-20•••-••-1421(956) 735-2427—5333 Indian School RoadPlanoTexas75088GRP-1709OPTIONS-PPO
ENRENR-1412862026-03-26T14:25:19ZBENJAMIN—PARKER1988-03-13UHC8417873NULL(370) 625-5922benjamin.parker@outlook.com8088 Maple Ave·OrlandoFlorida32861GRP-1809CORE-HMO
ENRENR-1030822026-09-29T21:46:02ZSANTIAGOLGREEN-UHC-37513-76N/A(839) 294-1285null7039 Church StreetLOS ANGELESCA—GRP-6224NAVIGATE-HMO
ENRENR-112211 2026-06-21T03:10:41ZBRIANUBAILEY1953-03-26UHC-51571-55UNKNOWN18239601059brian.bailey@gmail.com4358 Indian School Road #401Los AngelesCA90033GRP-6234CORE-HMO
ENRENR-1063992026-10-02T01:58:13ZSOFAIR.PHILLIPS1978-12-26UHC-88188-92•••-••-667317139869065SOFIA.PHILLIPS68@OUTLOOK.COM6707 Camelback RoadChandlerAZN/AGRP-6195CORE-HMO
ENRENR-1171112026-05-03T12:20:55ZKellyQEvans1964-05-28UHC-76873-84—(665) 385-1133kelly.evans@yahoo.com7134 Main StreetAustinTX78772GRP-7537MEDICARE-ADV-B
ENRENR-1053872026-03-24T03:07:45ZRaymond····Wood·1977-12-17UHC-43430-18•••-••-49474136458907RAYMOND.WOOD61@PROTON.ME409 CEDAR LNLas VegasNevada89148GRP-5840MEDICARE-ADV-B
ENRENR-1161462026-04-20T01:01:11ZDAVIDV.MOORENO09/22/73··UHC-59966-46•••-••-174616943679303-8006 VALLEY VIEW DRIVEAtlantaGA30348GRP-0422MEDICARE-ADV-B
ENRENR-1017872026-08-07T04:01:30ZDouglas—Carlson1/28/1939UHC-97519-33•••-••-54787647861630-3127 Washington StreetAustin·TX78718GRP-7892MEDICARE-ADV-A
ENRENR-1393312026-08-29T15:57:10Z KYLE—POWELL1962-10-08UHC-76181-30•••-••-6241524-919-2176kyle.powell@outlook.com7491 BROADWAYMesaAZ85255GRP-1427MEDICARE-ADV-A
ENRENR-1402992026-02-20T01:23:08ZAUSTINEPOWELLJul 26, 1998uhc-82867-57•••-••-47717554915489austin.powell@hotmail.com1772 Elm StreetJacksonvilleFL32206GRP-9217SELECT-EPO
ENRENR-1046762026-08-29T16:38:03ZdanielNdean1950-10-04UHC-74973-41•••-••-4122935-758-5014daniel.dean@outlook.com3184 SPRING STREETAustintx78776GRP-2523··CORE-HMO
ENRENR-1067882026-08-16T20:10:10ZJACQUELINE—WILLIAMS1962-04-22UHC-76657-21•••-••-9414(374) 673-0146JACQUELINE.WILLIAMS44@YAHOO.COM949 LAKE VIEW RDTampa·FL·33659GRP-5668··SELECT-EPO
ENRENR-138462 2026-08-17T03:53:30ZCarolyn R··OrtegaJun 15, 1998UHC-89704-73NULL12495826222CAROLYN.ORTEGA@YAHOO.COM8513 SAGE COURTCharlotte·NC28218GRP-3677·MEDICARE-ADV-B
ENRENR-1416092026-04-22T12:49:40ZCatherineISanchez·05-07-1993·UHC-57995-64•••-••-0208734-228-6549catherine.sanchez85@gmail.com3195 Valley View DrCharlotteNC··28257GRP-1238SELECT-EPO
ENRENR-1181312026-01-16T00:44:21ZKimberlyQJordan1594-03-13UHC-39395-07•••-••-0997(584) 738-5899KIMBERLY.JORDAN@ICLOUD.COM··6477 Palm DriveCharlotte··NC28207GRP-7913SELECT-EPO
ENRENR-1329992026-07-18T22:33:23ZMorales, BrittanyP.—2003-09-13UHC-09344-34•••-••-7112-brittany.morales@aol.com1731 PARK PLACEChandlerAZ85233-6675GRP-1646select-epo
ENRENR-1293692026-03-26T20:54:32ZTheresaXCooper17-05-2008UHC-66094-45•••-••-76668441646—9674 Jefferson AvenueSan DiegoCA92127GRP-8837CORE-HMO
ENRENR-1159612026-04-14T15:44:01ZEllis, SamelJ—19461102UHC-35009-37•••-••-3191(810) 432-7908N/A4689 Apache BlvdTempeAZ85258GRP-5453··CORE-HMO··
ENRENR-1151012026-05-07T23:26:27ZLUIS—ORTYZ28-11-1951UHC-74768-48—12976755315·luis.ortiz15@outlook.com2900 Oak StMESA·AZ85281GRP-2678MEDICARE-ADV-A
ENRENR-1341532026-07-16T10:44:11Z KEITH—FIELDS2000-03-03uhc-63733-07—12177099246keith.fields60@gmail.com9699 SUNSET BLVDSan AntonioTX78250·GRP-5181MEDICARE-ADV-B
ENRENR-1155752026-09-05T16:38:25ZDouglas—JacksonApr 4, 2007UHC-53621-80•••-••-5548—null9299 Indian School Road·ScottsdaleAZ85252GRP-3943MEDICARE-ADV-A
ENRENR-1078762026-06-03T01:52:29ZIsabellaMSanders5/19/1986UHC-72276-68•••-••-2579(564) 910-4794isabella.sanders56@outlook.com8404 Desert Sky Boulevard·San AntonioTexas···78221GRP-0456MEDICARE-ADV-A
ENRENR-1237442026-09-20T07:44:53ZBRITANYWNUNEZ2006-06-06UHC-13686-89•••-••-5418(574) 807-9358brittany.nunez9@gmail.com2966 CEDAR LANESeattleWA98195GRP-8023MEDICARE-ADV-A
ENRENR-1015262026-03-10T02:14:05Z DANIEL—·BANKS12/24/1991UHC-92105-05•••-••-66432725177889-8012 Palm DriveHoustonTX77061GRP-9068NAVIGATE-HMO
ENRENR-1206642026-08-31T10:33:22ZSullivan, JeffreyG····12/17/01UHC-01818-10•••-••-8895(441) 732-2071jeffrey.sullivan@icloud.com8471 Elm St··HoustonTX77054GRP-3647MEDICARE-ADV-A··
ENRENR-1258922026-06-29T22:43:56ZEdwardSBradley1966-09-03UHC-46461-64•••-••-7275270-934-8793EDWARD.BRADLEY66@HOTMAIL.COM5113 MAIN STREETSan AntonioTexas78243GRP-5453NAVIGATE-HMO
ENRENR-1219042026-01-04T12:21:44ZDorothyWWagner1999-11-07UHC-27472-49•••-••-0738UNKNOWNdorothy.wagner@icloud.com1607 Forest Avenue #301··TUCSONArizona85733GRP-6638SELECT-EPO
ENRENR-1186412026-08-01T20:41:29ZchrisUmorrison1993-11-19UHC-26057-22null494-847-2455CHRISTOPHER.MORRISON@OUTLOOK.COM4755 BroadwayMiamiFL33136GRP-9645CHOICE-PLUS-PPO
ENRENR-1292762026-01-09T23:47:17Z JOHNXGORDON1958-01-22UHC-85825-63•••-••-8367·(373) 399-3592—5838 Ridge RdMINNEAPOLISMN55403GRP-4905CORE-HMO
43,101 rows, page 124 of 863PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:37.765Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty