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-1400982026-07-27T00:22:17ZLauren—·Ryan13-01-2006UHC-80172-58•••-••-1354-NULL4827 Hillcrest RoadMesaaz85239GRP-6702MEDICARE-ADV-A
ENRENR-1006932026-05-11T05:32:28ZJean··RDiazFeb 4, 1977UHC8069117•••-••-894313412474979jean.diaz@hotmail.com838 BASELINE RDTampa·FL33676GRP-5971CHOICE-PLUS-PPO
ENRENR-1222872026-04-28T15:12:39ZEMMA—ALVAREZ1957-02-22UHC-06682-04•••-••-0730(821) 515-2481emma.alvarez@yahoo.com7288 Union StGilbertAZ85213GRP-1997NAVIGATE-HMO
ENRENR-1090742026-04-23T22:02:54ZMateo··—Lopez1978-04-21UHC-64208-95•••-••-4414+1 739 729 7859mateo.lopez13@hotmail.com2923 Desert Sky Boulevard··DallasTX75222-6245GRP-9089CHOICE-PLUS-PPO
ENRENR-1134442026-05-01T13:11:21ZDavid—Yang2008-01-27UHC-06564-81•••-••-66892063808058david.yang20@hotmail.com7936 Park PlAtlantaGeorgia30313GRP-0989·MEDICARE-ADV-B
ENRENR-1070462026-06-18T20:40:22ZSmith, EricA—1997-09-09··UHC-59513-92•••-••-326713888402273—5502 Valley View DriveSacramentoCA95847GRP-7781NAVIGATE-HMO
ENRENR-1412052026-03-21T00:43:27ZCAROLYN··PAYNE·6/9/1978UHC-43307-68•••-••-8883(766) 633-9374null5657 Bayshore DriveOrlandoFL32824·GRP-1658CHOICE-PLUS-PPO··
ENRENR-1357332026-09-26T02:53:10ZlawrenceW.flores2008-06-27UHC-58157-26•••-••-70629754369lawrence.flores84@outlook.com7822 OAK STLos AngelesCA90024··GRP-8223MEDICARE-ADV-A
ENRENR-1188412026-06-28T18:14:19ZNancy—Daniels1969-03-01UHC-33110-86•••-••-8041+1 369 751 4988nancy.daniels@hotmail.com7100 Highland AvenuePhoenixAZNULL··GRP-0884MEDICARE-ADV-B
ENRENR-1364792026-07-08T13:08:04ZSEAN—KELLY2003-08-08UHC2415974•••-••-6571(278) 482-6768—4766 Grand AvenueEden PrairieMN55307GRP-6924NAVIGATE-HMO
ENRENR-1315502026-09-24T20:35:33ZJuanTMorris10/17/08UHC-99012-31-(449) 580-1407juan.morris@hotmail.com2005 Church StLOS ANGELESCA90059GRP-4029MEDICARE-ADV-A
ENRENR-1152352026-08-08T09:26:38ZShirley—Jensen1957-03-15UHC-92914-52•••-••-7125448.926.8805N/A3189 PINE DRIVEGLENDALEAZ85375··GRP-1115CHOICE-PLUS-PPO
ENR ENR-1295342026-01-19T05:33:46ZJonathanF·Sanchez2003-11-10UHC-05896-07•••-••-0157+1 275 905 1953JONATHAN.SANCHEZ@AOL.COM·8622 Park PlLos AngelesCA90084GRP-6920MEDICARE-ADV-A
ENRENR-1071682026-01-20T13:14:10ZLAURA—YOUNG1963-02-11UHC-41482-56•••-••-91192606975LAURA.YOUNG@HOTMAIL.COM6955 Cedar LaneJacksonvilleFL32261GRP-5312NAVIGATE-HMO
ENRENR-1134722026-07-03T13:42:22ZSharon··Bryant1996-06-03UHC-82381-52—434-649-7131sharon.bryant96@yahoo.com316 MOUNTAIN VIEW DRIVEMIAMIFL33131GRP-3091NAVIGATE-HMO
ENRENR-1394932026-02-13T20:39:05ZjonathanDparker1980-11-23UHC-32181-76•••-••-42863164609757JONATHAN.PARKER63@GMAIL.COM9061 Pine Drive··OrlandoFL32891GRP-2259·NAVIGATE-HMO
ENRENR-1260542026-06-03T05:03:42ZJOYCE—SINGH1981-04-16UHC-91644-05•••-••-13159489880JOYCE.SINGH@PROTON.ME5268 Bayshore DriveAustintx78767GRP-4138MEDICARE-ADV-A
ENRENR-1160292026-08-18T14:10:46Z MARI—MATTHEWS1967-12-24UHC-24311-20•••-••-74659173203898maria.matthews46@icloud.com1610 Willow CtScottsdaleAZ85281GRP-7094MEDICARE-ADV-A
ENRENR-1412722026-01-28T00:15:34ZWAYNE··LOPEZ20011226UHC-76174-84•••-••-25826396090321WAYNE.LOPEZ@AOL.COM8070 HIGHLAND AVENUEDALLAS··TX75296GRP-8784NAVIGATE-HMO
ENRENR-120930 2026-04-19T03:24:36Zalan—mills2/18/1998UHC-85719-06•••-••-96293477457703ALAN.MILLS@HOTMAIL.COM6345 Church StEden PrairieMN55347GRP-6762MEDICARE-ADV-B
ENRENR-1229312026-03-20T00:19:54ZJack··—Hart03/07/2004UHC-04261-60•••-••-9418(662) 353-1282jack.hart28@icloud.com··—··N/ANULLGRP-3643··SELECT-EPO
ENRENR-1212632026-05-15T20:39:33ZPriya··—Welch1991-08-20UHC-03974-15··•••-••-2186899-593-6937priya.welch80@yahoo.com8413 Ocean AveNASHVILLETN37244GRP-4390CHOICE-PLUS-PPO
ENRENR-1398812026-09-13T17:42:37ZDorothyR.Reynolds1995-11-10UHC-94896-01•••-••-48648708948654dorothy.reynolds@hotmail.com·649 MESA DRIVEMiamiFL··33164GRP-4723MEDICARE-ADV-A
ENRENR-1343422026-08-26T17:11:58Zjean··franklin1965-09-24UHC-57754-37•••-••-3247396-704-3738null1586 Ridge RoadColumbusOH43237GRP-6170CHOICE-PLUS-PPO
ENRENR-1285392026-05-22T09:08:17Zelijah—collins20-06-1979UHC-12190-69•••-••-70702622537759elijah.collins89@yahoo.com1597 Central AvenueJACKSONVILLEFL32297GRP-3474·NAVIGATE-HMO
ENRENR-1420592026-07-05T18:24:22ZTimothyG··BennettNov 17, 1940UHC-58565-83•••-••-9718(374) 446-0647UNKNOWN1538 Harbor BoulevardTempeAZ85234GRP-8224·NAVIGATE-HMO
ENRENR-1383192026-04-14T01:51:57ZNoahKRice06/17/56··UHC-22017-22•••-••-2563—NOAH.RICE67@YAHOO.COM——NULL-GRP-2647CHOICE-PLUS-PPO
ENRENR-1136692026-09-10T11:09:48ZDEBORAHISMITH1955-02-11UHC-06521-05•••-••-94054476415070deborah.smith@yahoo.com805 Market StreetPlano··TX75081GRP-6888OPTIONS-PPO
ENRENR-1255352026-05-26T19:23:01ZSHIRLEY—GUTIERREZ1958-08-13UHC-95109-52•••-••-8381(360) 896-3553shirley.gutierrez@aol.com2473 Willow CtSAN ANTONIOTX78276GRP-0163MEDICARE-ADV-B
ENRENR-135705 2026-01-23T20:16:07ZKim—LuacsJun 1, 1954—•••-••-0584·(251) 245-0596kimberly.lucas@yahoo.com3323 BAYSHORE DR #545TucsonAZ85737GRP-7305CHOICE-PLUS-PPO
ENRENR-1339462026-07-09T18:11:21ZJONSON·Z.AMANDA19460703uhc-06364-64•••-••-220418624656105AMANDA.JOHNSON@GMAIL.COM9444 Cedar LnSacramentoCA—GRP-8411CORE-HMO
ENRENR-1131182026-09-14T22:35:38Z·LUCIATWOODS04/12/1967UHC-04770-46•••-••-2049773-979-1767LUCIA.WOODS25@YAHOO.COMN/AUNKNOWNnullNULLGRP-5150·MEDICARE-ADV-B
ENRENR-1109662026-09-30T03:28:51Z ABIGAILL··MARSHALL1943-09-25UHC-76851-39•••-••-59156475203297ABIGAIL.MARSHALL71@GMAIL.COM8253 Desert Sky Boulevard Apt 3DALLASTX75264GRP-2863SELECT-EPO
ENRENR-1060112026-07-25T06:36:31Z·jacobMgeorgeJul 15, 1965UHC5144605•••-••-4205879.333.0365jacob.george69@icloud.com4378 Market StMesaAZ85286-7749GRP-7071CHOICE-PLUS-PPO
ENRENR-1028742026-09-25T22:24:23ZCharlotte—Alvarez04/04/1978UHC-27907-28•••-••-9869246-380-6005charlotte.alvarez@icloud.com5621 Pine Dr··SacramentoCA·95827·GRP-2069CORE-HMO
ENR ENR-1117922026-10-03T04:15:02ZKeithZSanchez1943-07-08UHC-66808-16•••-••-5816678-932-5429NULL3594 Desert Sky BlvdAustinTX78738GRP-2379MEDICARE-ADV-B
ENRENR-1103422026-02-02T04:16:57ZkeithPwest2003-12-22UHC4597828•••-••-5905·3428078814keith.west44@yahoo.com··7579 Camelback Rd Apt 23OrlandoFL32860GRP-4466SELECT-EPO
ENRENR-1085652026-03-10T00:21:05Z DIEGOJTRAN1977-06-21UHC-63032-49•••-••-08619258975198diego.tran65@yahoo.com8046 GRAND AVENUEScottsdaleAZ85228··GRP-2763MEDICARE-ADV-A
ENRENR-1319332026-02-16T08:28:14ZADAMD.RIVERA··1945-11-13UHC-67662-14•••-••-8631--1591 Spring StLos AngelesCA90001GRP-6283SELECT-EPO
ENRENR-1294162026-04-22T19:20:11ZChristinaLDominguez19870317UHC-73710-24··•••-••-44835978094287NULL4892 UNION STREETMESAAZ85218GRP-5848CHOICE-PLUS-PPO
ENRENR-1038922026-07-13T02:07:07Z GabrielV.Wallace2006-10-22UHC-12749-22•••-••-0828(831) 268-6415gabriel.wallace56@yahoo.com1555 RIVER ROADLas VegasNV89167GRP-1184CORE-HMO
ENRENR-1123822026-03-31T05:23:28ZHAROLD—DANIELS2007-11-13·UHC-82658-55•••-••-2484+1 538 398 3418harold.daniels@yahoo.com3445 Canyon RdSan Antonio·TXN/AGRP-5788·SELECT-EPO
ENRENR-1353292026-01-01T12:29:05ZRYAN—DIXON03/03/07UHC-90343-37•••-••-67538795979163RYAN.DIXON@AOL.COM3550 Lake View Rd Apt 27San DiegoCA92195GRP-5879NAVIGATE-HMO
ENRENR-1018772026-06-05T03:30:54ZFrank—Soto1964-08-20UHC-49015-76•••-••-92605793489442·frank.soto@gmail.com4870 BAYSHORE DRDenverCO80298GRP-1892SELECT-EPO··
ENRENR-1105092026-05-10T21:53:40ZNelson, Priya——1961-02-03UHC-65947-09N/A+1 712 874 6994priya.nelson92@aol.com··9565 Ridge RoadSeattle··wa98154·GRP-8882SELECT-EPO
ENRENR-136467 2026-06-26T16:25:12ZSteven—George7/9/1984UHC-26902-16NULL698-692-3791UNKNOWN4931 LINCOLN WAYOrlandoFL32839GRP-8482···MEDICARE-ADV-B
ENRENR-1216462026-08-05T20:19:43Z Black, MarthaC—02-03-1995UHC-64249-21•••-••-6968886-607-7238MARTHA.BLACK@YAHOO.COM2104 Lake View RoadMesa·AZ85247-1130GRP-3131·CHOICE-PLUS-PPO
ENRENR-1426142026-03-08T04:18:44ZJason—James1957-02-14UHC-94506-04•••-••-9064+1 741 328 4041JASON.JAMES70@PROTON.ME9716 Mountain View Dr #769··GLENDALEAZ85352-6879GRP-6036CORE-HMO
ENRENR-1427472026-10-17T05:45:31ZMARKVVAZQUEZ09/24/89UHC-24042-15•••-••-4032—MARK.VAZQUEZ@OUTLOOK.COM1533 Mesa DriveAtlantaGA30358GRP-6555OPTIONS-PPO
ENRENR-1218582026-10-05T05:33:22Z·Johnston, Marcus——1957-01-12··UHC-13149-50•••-••-2632(423) 430-5655·MARCUS.JOHNSTON44@HOTMAIL.COM7914 Meadow LaneLas VegasNevada89167GRP-8869NAVIGATE-HMO
43,101 rows, page 97 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.732Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty