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-1205102026-03-01T00:12:46Zsean—harper1969-03-14UHC-05308-05•••-••-8636-sean.harper13@yahoo.com4042 INDIAN SCHOOL RDOrlandoFlorida32882GRP-8615CHOICE-PLUS-PPO
ENRENR-1203672026-08-27T05:53:37Z Benjamin—Martin1972-10-06··UHC-18662-43—2083237231benjamin.martin9@yahoo.com7558 Sage CtTucsonAZ85787GRP-9438CHOICE-PLUS-PPO
ENRENR-1328602026-01-28T06:13:06ZRoseFBrittany2003-08-03UHC-64681-45•••-••-9933245-903-8367··brittany.rose71@icloud.com8817 CANYON RDTucsonAZnullGRP-4698CORE-HMO
ENR ENR-118568 2026-02-04T02:36:16ZBrandon—Fowler1938-06-25UHC-57396-57•••-••-164615496745470—820 Mesa DrMINNEAPOLISMN55444GRP-2650CORE-HMO
ENRENR-1103002026-04-06T09:32:30ZSharon—Meyer08/06/01—•••-••-424216815811823sharon.meyer55@icloud.com1240 FOREST AVENUESeattleWA··98119GRP-5969MEDICARE-ADV-A
ENRENR-1366342026-04-01T18:54:53Zisabella—robertson1988-01-02UHC-25638-63N/A(344) 778-4951ISABELLA.ROBERTSON@GMAIL.COM·4127 Lake View Rd #279San DiegoCANULLGRP-2136medicare-adv-a
ENRENR-1408612026-02-14T05:17:28Z sandraI··patel·1950-08-26UHC-95354-02•••-••-9934590-921-9151sandra.patel40@proton.me1517 Park PlNashvilleTN—GRP-2650OPTIONS-PPO
ENRENR-1170972026-02-08T13:25:59ZNatalieE.Carpenter1993-02-24UHC-94569-81•••-••-7977415.484.7911natalie.carpenter94@proton.me1689 Highland Ave Apt 30·SACRAMENTOCA95892GRP-5688CORE-HMO
ENRENR-1047382026-03-07T08:27:18ZRuth—Estrada1975-00-14UHC-89288-72—869.411.9128N/A5219 Hillcrest RoadAtlanta··GA30386GRP-7532···SELECT-EPO
ENRENR-1426172026-09-28T15:30:10ZDonnaSCampbell1994-06-27UHC-02076-99•••-••-2365506-227-0218·NULL5628 Ocean AveLos AngelesCA90007GRP-3574NAVIGATE-HMO··
ENRENR-1273392026-07-15T10:51:00ZAaronYPierce1942-09-19UHC9172052•••-••-7827348.285.2030aaron.pierce@hotmail.com7423 Park PlaceHOUSTONTX77063GRP-1173NAVIGATE-HMO
ENRENR-1294532026-05-10T03:01:59ZAlexis—Ross04/24/01UHC-76669-06—+1 874 380 8836alexis.ross66@gmail.com2335 Baseline Road Apt 19·AtlantaGA30386GRP-9434··OPTIONS-PPO
ENRENR-1397742026-09-05T09:22:22ZAlex··Snyder1955-03-26UHC-61149-15•••-••-35498058653225—6314 CENTRAL AVENUEPlanoTX75057·GRP-2778CHOICE-PLUS-PPO
ENRENR-1316952026-07-30T18:41:31ZLinda—Crawford1986-10-22UHC-64300-87•••-••-3986868.307.4012N/A2959 Harbor Blvd··AustinTX78746GRP-2081NAVIGATE-HMO
ENRENR-1428202026-02-05T10:37:08Z Simmosn, Richard——25-12-1950UHC6065095•••-••-4376(860) 372-7016richard.simmons80@aol.com286 Central AveSan DiegoCA92116GRP-1623CORE-HMO
ENRENR-1142392026-02-18T03:24:56Zsusan—burke02/25/1985UHC7046311•••-••-2208·2824228292—nullN/A—NULLGRP-7184MEDICARE-ADV-A
ENRENR-1186092026-06-14T07:17:02ZWAYNE—FLORES1985-04-24UHC-28530-33··•••-••-2695+1 607 902 0059wayne.flores@gmail.com5782 Jefferson AvenueTampaFlorida33631GRP-1938NAVIGATE-HMO
ENRENR-1263092026-03-04T12:42:07Z·FRANKDSIMMONS19500123UHC-98453-38•••-••-27443107475012-1973 HARBOR BLVDGlendaleAZ85385GRP-7262CHOICE-PLUS-PPO
ENR ENR-1418452026-02-09T16:44:22ZWayneV.Dean1988-12-23UHC-74792-22··•••-••-7123(939) 436-6445WAYNE.DEAN77@ICLOUD.COM5386 CHURCH STREETPLANOTX75056GRP-6591MEDICARE-ADV-B
ENRENR-1217822026-04-11T06:01:45Z Debra—Wagner0621-19-76UHC-54439-28UNKNOWN—debra.wagner45@hotmail.com4557 Canyon RdSan AntonioTX78240GRP-1718MEDICARE-ADV-B
ENRENR-1221542026-03-05T06:51:50ZAngela—Garrett1948-05-06null•••-••-5267(327) 778-6956angela.garrett@yahoo.com6579 Desert Sky BoulevardEden PrairieMN55302GRP-2762NAVIGATE-HMO
ENRENR-1155892026-02-28T00:44:03ZLuis—Freeman1971-07-10··UHC-37508-05-3224943—1083 Main StLos AngelesCA90007GRP-3864··SELECT-EPO
ENRENR-1358212026-07-14T18:20:06ZJORDANJ.BOYD19620603UHC-82021-98•••-••-0724533-965-4881····5668 Union Street Apt 1MinneapolisMN55466-9642·GRP-7351NAVIGATE-HMO
ENRENR-1220262026-04-30T21:25:55ZGray, Adam········1986-09-23UHC-01432-91•••-••-4034927-830-2313ADAM.GRAY@YAHOO.COM6378 Hillcrest Road Apt 22PlanoTX75077-7051GRP-5568NAVIGATE-HMO
ENRENR-1097262026-07-31T18:53:13Z·RachelO.Munoz··2004-03-17UHC-15937-04•••-••-3375898-508-4666rachel.munoz60@aol.com··7646 BAYSHORE DREDEN PRAIRIE··MN55307GRP-5816CHOICE-PLUS-PPO
ENRENR-1200402026-09-07T16:21:00ZJudithHHoward2000-09-60UHC-27142-46··N/A3322736253judith.howard99@hotmail.com9141 Harbor BoulevardGlendaleAZ85361GRP-1825SELECT-EPO
ENRENR-1304712026-05-06T18:50:46ZJUANRGRAHAM1954-01-27UHC-74875-35•••-••-21188209215158juan.graham@hotmail.com2411 Ridge Rd Apt 24PLANO·TX75066GRP-3596·CHOICE-PLUS-PPO
ENRENR-1406682026-09-12T20:36:20ZJONATHAN—·SIMMONSMay 11, 1988·UHC-03464-95•••-••-2480·17915150208—8022 Jefferson Avenue #194LAS VEGASNV89194GRP-6793CORE-HMO
ENRENR-1250872026-07-26T04:25:26ZJOSHUA·····JONES1987-10-01null•••-••-24826183721729joshua.jones@icloud.com7229 Mountain View DriveAustinTX78788GRP-1285MEDICARE-ADV-A
ENRENR-1296542026-08-19T11:05:29ZNathanFEvvansSep 22, 1984UHC-12147-26•••-••-51027446414461nathan.evans@icloud.com——NULL—·GRP-8675SELECT-EPO
ENR ENR-1367062026-04-19T10:48:38ZLynch··Jose2006-03-07·UHC-55336-60•••-••-1993254-570-5945jose.lynch32@yahoo.com7189 Mesa Dr···PhoenixAZ85040GRP-4859options-ppo
ENRENR-1156002026-07-07T16:16:39Zrger X—montgomeryNULLUHC-06433-89•••-••-8296383-211-4196—8238 Sunset BlvdMiamiFLN/AGRP-8101NAVIGATE-HMO
ENRENR-1022482026-05-19T05:27:27ZHill, Jan——1973-11-18UHC-37787-33—765-718-4208—5687 Washington StreetPhoenixAZ85004GRP-2350SELECT-EPO
ENRENR-1154462026-09-03T09:56:44Z·HELENA··ARNOLD·1986-06-28UHC-85929-14•••-••-9695(336) 370-7321N/A··2624 Meadow LnDallasTX75218GRP-3117NAVIGATE-HMO
ENRENR-1003832026-05-04T08:39:28ZCynthiaDReid1978-11-14··UHC-56937-09null15884430620cynthia.reid@aol.com7385 Church Street·OrlandoFL32888GRP-4940CORE-HMO
ENRENR-1418792026-02-21T15:37:28ZFernandez, MargaretF.—Sep 28, 1938UHC-38371-52•••-••-9062·435-782-5488MARGARET.FERNANDEZ45@GMAIL.COM1878 Ocean AveATLANTAGA30309GRP-3636·SELECT-EPO
ENRENR-1429002026-06-07T15:42:04ZScott J—Mills1973-04-03UHC-95658-73•••-••-3290+1 400 544 2645UNKNOWN··5136 Desert Sky BlvdTampaFlorida33671GRP-6926OPTIONS-PPO
ENRENR-1118072026-04-28T17:49:37ZJustinWBradley11/10/2005·uhc-61388-76•••-••-33407337887129justin.bradley30@outlook.com7735 Elm StreetScottsdaleAZ85225·GRP-0910NAVIGATE-HMO
ENRENR-1132762026-06-09T03:27:07ZAlvarado, Barbara——24-05-1944·uhc-81114-79—(898) 732-7085BARBARA.ALVARADO@YAHOO.COM5105 Lake View RoadTempeAZ85233GRP-2318MEDICARE-ADV-B
ENRENR-1367102026-03-12T06:56:38ZMaia—Chapman·6/24/2006UHC-44612-64•••-••-36386096887691—8540 Elm St Apt 10San DiegoCA92173GRP-4210SELECT-EPO
ENRENR-1177872026-08-19T18:56:24ZSTEPHEN—HANSEN18-08-1985UHC-90531-96•••-••-2084+1 519 445 7155··—3118 Sunset Blvd #178NashvilleTN37256GRP-7862OPTIONS-PPO
ENRENR-1401112026-10-08T11:24:39ZalexanderJlawrence19740307UHC-18319-88•••-••-57977286552—·4292 Grand AvenueJacksonvilleFL32279GRP-4318MEDICARE-ADV-A
ENRENR-1103812026-02-26T22:59:28ZMOOREAJENNIFER·1994-12-06UHC-97321-05N/A4163901772··jennifer.moore@yahoo.com3483 Church StreetSan Diego··CA·92152GRP-1044MEDICARE-ADV-B
ENRENR-1273942026-07-06T16:56:58Z·Jean·NEspinozaMay 24, 1942UHC1725337•••-••-1829489-314-1789JEAN.ESPINOZA@PROTON.ME3118 Jefferson AvenueJacksonville·FL32261·GRP-4864SELECT-EPO
ENRENR-1160322026-07-27T17:17:36ZkyleQhenryFeb 17, 1990UHC-48067-07•••-••-75905553431166·kyle.henry92@yahoo.com7259 Ocean AveSEATTLEWA98176GRP-7106MEDICARE-ADV-A
ENRENR-1422862026-08-03T01:58:51ZMeganUPteers12/07/57UHC-78395-46•••-••-5486555.659.7564megan.peters74@outlook.com5477 Church St Apt 1JacksonvilleFL32298GRP-3565select-epo··
ENRENR-1216712026-06-19T12:41:56ZAlice—Larson1979-03-07UHC-47376-36•••-••-730118753120016ALICE.LARSON@HOTMAIL.COM··5606 Palm DrAustin··TX78736GRP-1258CHOICE-PLUS-PPO
ENRENR-1190722026-04-16T17:42:48ZDIEGO··—BOYD2002-09-23UHC9095804null+1 743 754 0518diego.boyd95@proton.me6612 WASHINGTON STREETColumbusOH43294GRP-0118OPTIONS-PPO
ENRENR-1159392026-08-26T04:43:03ZJANICERJACOBS1965-04-10UHC-01211-45•••-••-9146(623) 587-3971·janice.jacobs69@proton.me631 Forest AvenueMESAAZ·85270GRP-4477NAVIGATE-HMO
ENRENR-1085132026-04-20T03:09:12Z·Logan—Powell1961-06-22UHC-51488-43•••-••-4629—logan.powell@aol.com9821 Cedar LaneSacramentoCA95845GRP-8400MEDICARE-ADV-A
43,101 rows, page 135 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.458Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty