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-1328952026-09-28T11:53:09Z Amber—Lawson1989-08-81UHC-33070-43•••-••-0273320-515-4896amber.lawson@aol.com6226 INDIAN SCHOOL ROADOrlandoFL32872GRP-7005MEDICARE-ADV-A
ENRENR-1110582026-03-22T12:55:35ZElizabeth—·Morris1966-08-03UHC-38598-92•••-••-8728875-963-2202ELIZABETH.MORRIS@GMAIL.COM9750 Sage CtNashvilleTN37259··GRP-7658CORE-HMO
ENRENR-1406192026-02-17T17:59:41Zpatrica—king06/23/1967UHC-26700-94•••-••-22794872781868patricia.king89@hotmail.com5936 Willow CourtDallasTX75246GRP-0624MEDICARE-ADV-B
ENR ENR-1334582026-06-07T10:02:48ZAngela—VargasAug 24, 1950UHC-08809-52•••-••-4067+1 858 995 1572··UNKNOWN1565 Ridge RdSEATTLEWA98121GRP-7748CHOICE-PLUS-PPO
ENRENR-1102122026-06-05T21:49:02ZJones, StevenN—1987-01-21·UHC-14206-13•••-••-40722745150052steven.jones@yahoo.com8824 MAIN STTempeArizona85261GRP-6723MEDICARE-ADV-B
ENRENR-1236622026-02-19T17:54:48ZSCOTT··—SCOTT1943-01-14UHC-61124-09N/A13095821368null3841 Central AvePhoenixAZ85040GRP-1188MEDICARE-ADV-A
ENRENR-1419102026-03-03T20:55:33ZPatrick····Jenkins··Apr 22, 1987UHC-24809-52•••-••-8571(385) 676-1430·patrick.jenkins@proton.me975 Valley View DrJacksonvilleFL32234GRP-8889CORE-HMO
ENRENR-1253392026-04-20T20:51:12ZAdamGRoberts02/27/76UHC-76557-89•••-••-5186454-870-0372—5241 Lincoln WayMinneapolisMN55413GRP-2039·OPTIONS-PPO
ENRENR-1253112026-05-23T07:53:29ZAlexisIWelch1944-05-17UHC-53543-47—208-631-8175—7502 Palm DriveSAN DIEGOCA92102GRP-9188MEDICARE-ADV-A
ENRENR-1342492026-02-07T22:28:08ZTERRY—BURNS1948-12-24UHC-74179-83•••-••-1912(891) 382-6248terry.burns61@gmail.com3680 Ridge Rd··DALLASTX75211GRP-9213CHOICE-PLUS-PPO
ENRENR-1411182026-07-12T03:05:49ZJOE····THOMAS2007-03-01UHC-54570-05•••-••-0606763-953-3045joe.thomas@icloud.com8252 MAIN STREETPLANOTX75033GRP-7276SELECT-EPO
ENRENR-1183362026-06-26T17:39:05ZBradley—Freeman19990111UHC-36302-01NULL547.208.1684bradley.freeman@yahoo.com8611 MAIN ST·PlanoTX75087GRP-7941MEDICARE-ADV-A
ENRENR-135561 2026-01-28T14:00:34ZKimberlyZHart11/22/1940UHC-56159-56UNKNOWN8026141085kimberly.hart@hotmail.com1388 Spring StreetSan DiegoCA··92145GRP-9346CORE-HMO
ENRENR-1271602026-03-30T17:57:54ZMegan—Matinez1946-12-18UHC-41347-10•••-••-7499(531) 767-2438MEGAN.MARTINEZ14@YAHOO.COMNULL—-—GRP-1214OPTIONS-PPO
ENRENR-1044082026-10-01T22:36:06ZBrianCCastillo1966-06-21UHC-33506-03•••-••-8887350.782.4371-5969 WILLOW COURTAUSTINTX78750GRP-8988OPTIONS-PPO
ENRENR-1148722026-08-27T09:27:04ZHicks, Mark G——1970-05-20UHC-81141-15•••-••-2876+1 706 771 7139mark.hicks@outlook.com3440 OCEAN AVENUETUCSONAZ85766GRP-0582CHOICE-PLUS-PPO
ENRENR-1197952026-05-02T16:37:40ZHIROSHIE.KELLY1949-11-19UHC-22344-41•••-••-032316789453215hiroshi.kelly73@aol.com5959 CAMELBACK ROADSan AntonioTX-GRP-6019CORE-HMO
ENRENR-1395072026-09-04T12:04:02Z MarcusHCrawford1960-09-25UHC-03736-13•••-••-2500(779) 965-3280NULL9138 Sunset BoulevardSan DiegoCA92154GRP-0436MEDICARE-ADV-B
ENRENR-1079582026-03-21T03:43:53ZJulia—Wallace19621220UHC-97794-26•••-••-61317905243052julia.wallace@icloud.com9305 Central AvenuePlanoTX75073·GRP-8470core-hmo
ENRENR-1264182026-10-07T07:46:01ZJUDITHDROJAS1992-03-05UHC-32413-72•••-••-28566366599017-7964 MARKET ST Apt 25TempeAZ85263GRP-9355MEDICARE-ADV-B
ENRENR-1362672026-04-29T18:13:24ZPamelaU.Harvey11/17/1953·UHC-71603-21•••-••-7929(418) 793-5480PAMELA.HARVEY23@ICLOUD.COM5210 RIVER RD Apt 20··San AntonioTX78252GRP-7581MEDICARE-ADV-A
ENRENR-1082532026-09-19T04:23:29ZWILLIE—SHAW1978-12-02UHC-91895-73•••-••-3600583.393.0070willie.shaw@outlook.com7789 CANYON ROADMINNEAPOLISMNNULLGRP-6614CHOICE-PLUS-PPO
ENRENR-1004432026-09-17T22:12:07Z·AMBERR.WOUD1956-10-12UHC-92867-74•••-••-9207407-748-6352UNKNOWN·2818 Ocean AvenueHoustonTX77066GRP-3135MEDICARE-ADV-B··
ENRENR-1075402026-07-28T01:17:14ZBeverlyHHughes6/28/1987UHC-84048-28•••-••-1537(794) 701-4104—4067 Mountain View DriveHoustonTX77044GRP-8923CHOICE-PLUS-PPO
ENRENR-1276382026-09-10T13:14:12ZJimenez, DanielR—18-02-1956UHC-92103-63•••-••-995216512437620null4505 Hillcrest RdSacramentoCA95817-1154GRP-1145CHOICE-PLUS-PPO
ENRENR-1075602026-08-29T16:49:27Z—O—19-05-1991—•••-••-1347335-466-8249ELIJAH.SIMS@ICLOUD.COM2636 Highland AvenueSacramentoCA95889GRP-1544MEDICARE-ADV-A
ENRENR-1056802026-07-28T08:23:04ZJAMESHSHAW·Dec 17, 1976-•••-••-4036721.351.7372··james.shaw34@hotmail.com168 Mesa DriveCharlotteNC·28223GRP-0233SELECT-EPO
ENRENR-1002952026-03-09T02:13:55ZFernandez, IsabellaN.—1959-07-24UHC-84816-78•••-••-63672749908588isabella.fernandez82@yahoo.com9875 Forest Ave··Eden PrairieMinnesota55304GRP-4599·SELECT-EPO
ENRENR-1168462026-02-06T18:48:02ZJasonY.Bailey1956-08-22UHC-37471-86•••-••-8402(377) 245-4021jason.bailey95@gmail.com8553 Maple AveTempeAZ85286GRP-4084MEDICARE-ADV-A
ENRENR-1360602026-01-29T00:53:19ZLawrenceW·Hayes1966-03-25UHC-29287-75··-736.997.6447LAWRENCE.HAYES@PROTON.ME6554 Indian School Rd #444AtlantaGA30349··GRP-6216··MEDICARE-ADV-B
ENR ENR-1390912026-03-31T00:06:09ZSOFIAG.WANG1966-06-02·UHC-63739-70•••-••-534615476445634—6898 Indian School RoadSeattleWA98188GRP-0276MEDICARE-ADV-B
ENRENR-1231282026-02-12T09:38:46ZJESSE—WALSH1944-08-24·UHC0654856•••-••-7513nullNULL5398 Willow CourtSeattleWashington··98151·GRP-9399SELECT-EPO
ENRENR-1373952026-08-25T14:26:26ZbryanQespinoza05/17/07UHC-24021-41•••-••-7044(676) 946-7110—5562 GRAND AVE #643ScottsdaleArizona85231GRP-4023OPTIONS-PPO
ENRENR-1264652026-06-08T06:44:27ZJoan·SSantiago1977-08-08UHC-33288-69•••-••-8394805-999-1878JOAN.SANTIAGO92@OUTLOOK.COM2356 JEFFERSON AVESacramento··CA95854GRP-5493·SELECT-EPO
ENRENR-136231 2026-01-11T15:17:47ZLogan—BrooksApr 19, 1952UHC-63454-26•••-••-7142(260) 300-3266logan.brooks81@yahoo.com3578 Forest Ave·Eden PrairieMinnesota55389GRP-1326MEDICARE-ADV-B
ENR ENR-141440 2026-05-24T10:00:07ZGeorge—Jordan2007-12-15··UHC-51226-22—(738) 326-6349UNKNOWN9029 MOUNTAIN VIEW DR #994MesaAZ85201GRP-9922options-ppo
ENRENR-1161792026-06-22T13:20:59ZEvans, JacobL—02-12-1966UHC-47768-24null+1 900 688 0173—7447 Baseline RdFresnoCA93759-8280GRP-3724MEDICARE-ADV-B
ENRENR-1064882026-02-13T09:18:25ZElliott, BryanN—1966-07-01UHC-17957-06•••-••-9942(622) 358-1893bryan.elliott69@proton.me8813 GRAND AVESan AntonioTX78260GRP-8794SELECT-EPO
ENRENR-138116 2026-05-11T01:10:18ZRoy—Price1994-12-19UHC-00128-03•••-••-2505208-342-6549N/A819 CANYON ROADCharlotteNC28232·GRP-4610MEDICARE-ADV-B
ENRENR-1076602026-05-11T03:00:43ZSara—Carr1982-05-24UHC-76869-45•••-••-34674134100117SARA.CARR4@OUTLOOK.COM3915 Washington Street··Nashville·TN37293GRP-1863NAVIGATE-HMO
ENRENR-1351942026-01-07T16:10:56ZBillyMRobertson2004-11-07·UHC-17775-68•••-••-564817932812018billy.robertson@icloud.com·1554 GRAND AVENUEPhoenix·Arizona85023GRP-1686NAVIGATE-HMO
ENRENR-1229602026-03-12T21:43:23ZJuan—Chen1982-01-27uhc-72089-26null5304633juan.chen@hotmail.com9807 Church StNashvilleTN37266GRP-0217core-hmo
ENRENR-1019532026-08-12T06:21:50Z·judy··nguyen1972-11-15UHC-34093-90•••-••-6181(777) 977-4847UNKNOWN5497 MAIN STColumbusOH43277GRP-2542OPTIONS-PPO
ENRENR-1167652026-05-07T15:04:30ZHawkins, EdwardJ··1963-12-26UHC-02967-39•••-••-10162252646439··edward.hawkins@aol.com9094 Sage CtTucsonAZ85703GRP-1029NAVIGATE-HMO
ENRENR-1260582026-05-16T07:18:57ZGutierrez, Kevin——1957-07-08UHC-24241-23-461-380-1851kevin.gutierrez@aol.com315 Harbor BoulevardMinneapolisMN55408GRP-0138NAVIGATE-HMO
ENRENR-1353202026-10-05T15:24:40ZJanet—Delgado19480409UHC-52346-94•••-••-1817551-718-4342janet.delgado@aol.com2312 Harbor BlvdAtlantaGA30349GRP-7630MEDICARE-ADV-B
ENRENR-1320012026-07-24T02:29:00ZBobby—Dixon1984-11-06UHC-90314-80UNKNOWN(947) 533-4176BOBBY.DIXON@HOTMAIL.COM9367 Grand Avenue···Las VegasNV89112GRP-3165CORE-HMO
ENRENR-1333352026-09-10T20:30:56ZColeman, CarlN—1970-03-15UHC-95130-07•••-••-93269847669139NULL3129 Church StreetSan AntonioTX78288GRP-2535··NAVIGATE-HMO
ENRENR-1117502026-08-29T17:06:13ZAisha—Robinson1961-10-19UHC-79685-78•••-••-5839N/Aaisha.robinson61@hotmail.com1393 SPRING STREET·SAN ANTONIOtx78206GRP-9621·CORE-HMO
ENRENR-1394052026-08-30T22:43:35Zgary—chapman02/12/81UHC-89611-35•••-••-88116247951058—8674 Lake View RoadSan Diego··CA92145GRP-6913CHOICE-PLUS-PPO
43,101 rows, page 169 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:38.498Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty