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-1253332026-04-19T23:21:12Z WalterYRichards1971-02-20uhc-22540-61•••-••-6309(567) 615-4464WALTER.RICHARDS@OUTLOOK.COM1942 Highland AvenueChandlerAZ85251GRP-2533NAVIGATE-HMO
ENRENR-1417362026-06-21T22:45:53ZBeverlyC.Warren1949-07-15UHC-50109-81•••-••-7514(680) 719-5317BEVERLY.WARREN@PROTON.ME3744 River RoadTucson·AZUNKNOWN··GRP-4783MEDICARE-ADV-B
ENRENR-1179552026-02-12T14:29:28ZBRITTANYZMUNOZ1959-04-02UHC-87830-57•••-••-5683+1 802 574 0413—8564 MEADOW LANEORLANDOFL32831GRP-3220CHOICE-PLUS-PPO
ENRENR-1056892026-05-16T03:05:16ZTucker, RandyB.—15-03-1981uhc-72020-56•••-••-321212363621547randy.tucker@yahoo.com9264 Mesa Drive Apt 32ORLANDOFL32840GRP-6656OPTIONS-PPO
ENRENR-1044592026-02-07T20:23:22ZRachelW·Maldonado1940-03-05UHC-51088-81•••-••-1858300.423.0351rachel.maldonado@icloud.com··1474 Ridge RoadSacramentoCA95818·GRP-5554OPTIONS-PPO
ENRENR-1284792026-10-07T05:05:38ZSean—Luna1987-06-11UHC-74869-89•••-••-0026—sean.luna@hotmail.com7233 Washington StreetEden PrairieMN55326GRP-2002SELECT-EPO
ENRENR-1217492026-07-13T14:00:24Z ·Ronald—Rojas··1943-10-01UHC-59380-90•••-••-5331-RONALD.ROJAS85@ICLOUD.COM6395 Valley View DriveMiamiFL33199GRP-0179OPTIONS-PPO
ENR ENR-1094502026-08-28T07:03:02ZSEANXBOWMAN1957-05-18UHC-27509-22•••-••-1522(543) 794-1543sean.bowman4@hotmail.com4985 CANYON RDAustinTX78724-7288GRP-5315SELECT-EPO
ENRENR-1226872026-08-02T05:36:28ZMadisonC.·Brooks1958-05-25UHC-26016-39•••-••-90403125237752—3536 PALM DRIVESan DiegoCA92133GRP-0921MEDICARE-ADV-B
ENRENR-1274462026-04-26T07:03:01ZBrittany—Guerrero1992-10-24UHC-24257-81•••-••-24829442937989BRITTANY.GUERRERO47@ICLOUD.COM6190 Spring St··DallasTX75282GRP-0928OPTIONS-PPO
ENRENR-1104382026-03-17T02:55:14ZRussell—Lee·21-07-1938UHC-29805-84•••-••-759816637112755·RUSSELL.LEE@GMAIL.COM9517 Canyon RdEDEN PRAIRIEMN55366GRP-7894NAVIGATE-HMO
ENRENR-1087782026-03-30T21:33:10ZBrendaDDay1975-08-25UHC-90446-52•••-••-79529707146699NULL32 Grand Ave Apt 38DenverCO80246GRP-7807OPTIONS-PPO
ENRENR-1313472026-04-03T04:32:12ZHeather—Hunter1998-07-26UHC-55779-17··•••-••-06906748867967HEATHER.HUNTER4@HOTMAIL.COM4904 MOUNTAIN VIEW DRIVE·AUSTINTX78738GRP-2356SELECT-EPO
ENRENR-1407782026-06-15T13:05:30ZLori··VWhite03/14/1953UHC-67164-56•••-••-9206+1 655 331 3066lori.white@outlook.com3149 Desert Sky BoulevardSacramentoCA95844GRP-5921CORE-HMO
ENRENR-1157012026-08-31T03:00:34ZDorothy—Williason10/05/1958UHC-38531-14•••-••-82162228594dorothy.williamson70@yahoo.com6047 LINCOLN WAYDallasTX75210GRP-2039CORE-HMO
ENRENR-1356422026-09-28T08:45:55ZJacobJPatterson1994-09-20UHC-78868-43•••-••-63499098406jacob.patterson@yahoo.com3426 MAPLE AVEDallasTXUNKNOWNGRP-6264··CORE-HMO··
ENRENR-1300182026-07-17T13:42:40ZSantiago—Gibson2000-04-19UHC-15032-49•••-••-44614796051313UNKNOWN9582 WILLOW COURT #618Houstontx77050GRP-3822NAVIGATE-HMO
ENRENR-111251 2026-08-26T23:06:15ZMatthews, Kathy——1998-02-01UHC-70356-45•••-••-78105295022379kathleen.matthews@icloud.com5746 Church St #868FresnoCA93731GRP-0196SELECT-EPO
ENRENR-1244962026-05-21T05:14:56Z CHARLESG··HOLMES1977-03-17UHC-85650-99··•••-••-8035·13167800992CHARLES.HOLMES@HOTMAIL.COM1149 Desert Sky Boulevard··NASHVILLETennessee··37229··GRP-6202CHOICE-PLUS-PPO
ENRENR-1340572026-10-10T03:24:50Zjustin··rojas1949-01-27UHC-93944-47•••-••-90574103007271JUSTIN.ROJAS@OUTLOOK.COM2150 HIGHLAND AVENUE·AtlantaGA30332GRP-9889NAVIGATE-HMO
ENRENR-1384892026-01-29T03:18:32ZSean··M·Delgado05/22/07UHC-78051-06nullnullsean.delgado96@gmail.com8367 CEDAR LANEORLANDO·FL·32827GRP-7282CHOICE-PLUS-PPO
ENRENR-1108022026-06-10T20:41:15Z SusanWGuzman06-06-1995UHC-59512-53•••-••-6178—susan.guzman84@yahoo.com8769 OCEAN AVE··Houston·TX77037GRP-9063NAVIGATE-HMO
ENRENR-1002892026-07-21T05:04:02ZBobbyQJenkins1948-04-28UHC-46816-23•••-••-7694720.827.4033robert.jenkins@aol.com3732 LAKE VIEW RDGlendaleArizona85357·GRP-2722MEDICARE-ADV-A
ENRENR-1058712026-08-22T04:17:13ZGeraldJMitchell1951-04-24UHC-05369-83•••-••-3612(447) 731-4017··gerald.mitchell61@outlook.com551 PARK PLSan DiegoCA92117GRP-6168SELECT-EPO
ENR ENR-1365442026-03-13T12:37:50ZMariaZPalmer1972-00-69·UHC-45838-69•••-••-85418828788837maria.palmer@gmail.com9185 Highland AveLas Vegasnv89166GRP-7991··SELECT-EPO
ENRENR-1088762026-06-15T11:44:59ZJulie—Pena02-12-1989UHC-02461-38•••-••-0880·294-850-5111julie.pena@yahoo.com59 Mountain View DrTUCSONArizona85739GRP-9199MEDICARE-ADV-A
ENRENR-1418902026-03-09T18:19:40ZETHAN—GORDONOct 17, 1945UHC-40444-84•••-••-9967+1 562 354 3872ethan.gordon@yahoo.com706 Lincoln WayDallasTX75288GRP-8647NAVIGATE-HMO
ENRENR-1228672026-10-04T07:22:35ZWoods, Paul I—··—·UHC-41066-57•••-••-7614-paul.woods@outlook.com8824 Spring StScottsdaleArizona85296GRP-8751MEDICARE-ADV-B
ENRENR-1109942026-02-20T09:18:06Z·JAMESFGORDON12/05/1946UHC-90387-42··•••-••-3367203-536-5136james.gordon76@outlook.com-N/A··-UNKNOWNGRP-8087·SELECT-EPO
ENRENR-1243312026-07-07T18:03:35Zjonathan—perkins1986-04-19UHC-78805-35•••-••-4925(930) 381-5648—8744 Park PlTampaFlorida33664GRP-7340MEDICARE-ADV-A
ENRENR-1326152026-07-09T14:42:33ZWard, CarolD.—7/14/1967UHC-25200-11•••-••-09073118217243UNKNOWN·8635 Palm DriveLas Vegasnv89159··GRP-7244OPTIONS-PPO
ENRENR-1125232026-02-16T00:24:26ZLuna, CynthiiaN—1970-06-09UHC-76246-70NULL(858) 787-5628cynthia.luna12@aol.com5505 Washington StAtlantaGA·30301GRP-3609MEDICARE-ADV-B
ENRENR-1350382026-02-02T14:35:25ZTeresa D—Cunningham0201-39-74UHC-56407-99•••-••-3495589-716-5184teresa.cunningham@gmail.com981 Willow CourtSan DiegoCA92163GRP-8851SELECT-EPO
ENRENR-1112462026-01-10T09:34:59Z·VictoriaB.Hunnt2004-02-03UHC-29204-61•••-••-7243(349) 257-9670—8527 Harbor BlvdSan AntonioTX78248GRP-7359··MEDICARE-ADV-B
ENRENR-1331462026-03-27T05:20:27ZAHMEDM·MCDONALD06/08/1956UHC-73330-87•••-••-8026472.600.9833ahmed.mcdonald80@aol.com3492 UNION STATLANTAGA30364GRP-0346MEDICARE-ADV-B
ENRENR-1043022026-04-26T14:14:18Z ·RalphE.Jensen6/25/1990UHC-96837-12•••-••-6361689-428-0014ralph.jensen37@gmail.com2850 CENTRAL AVENUEPhoenixAZ85068GRP-8088MEDICARE-ADV-A
ENRENR-1383402026-06-08T14:53:19ZHIROSHI—HOLMS1973-11-23UHC-68961-71•••-••-2516(245) 331-5281hiroshi.holmes@hotmail.com1266 Lincoln WayPhoenixAZ85051GRP-1438SELECT-EPO
ENRENR-1007702026-04-26T16:32:29ZVirginiaKHillSep 15, 1962UHC-08541-98•••-••-51479404428—5020 RIDGE RD #349Tampafl33666··GRP-5281NAVIGATE-HMO
ENRENR-1152342026-05-13T15:19:46ZCHRISTIAN—PRICE1993-12-24UHC-23261-68•••-••-13607333050581christian.price47@yahoo.com8885 Hillcrest RdTucson··AZNULLGRP-4967MEDICARE-ADV-B
ENRENR-1258122026-05-14T15:27:43ZEmma—Rodriguez2006-11-25UHC-89972-01•••-••-8409+1 810 839 5035N/A894 River RdPhoenixAZ85000GRP-2536SELECT-EPO
ENRENR-105646 2026-01-02T12:56:23ZCastro, Amy——1973-10-09UHC-78909-25•••-••-91687684397308-6738 Harbor BlvdScottsdaleArizona85241GRP-4856SELECT-EPO
ENRENR-1084452026-06-05T22:18:32ZMichael—Salazar1939-09-21UHC-82901-93•••-••-7055N/Amichael.salazar12@outlook.com3502 GRAND AVELos AngelesCA90062GRP-2334MEDICARE-ADV-B
ENRENR-1087602026-04-06T20:32:18ZLogan·GEstrada1953-06-13UHC-62739-96null(283) 593-9448LOGAN.ESTRADA@OUTLOOK.COM1806 CEDAR LNSacramentoCA95871GRP-6753OPTIONS-PPO
ENRENR-1189642026-08-29T06:35:56ZOLIVIA—BERRY12/10/1987UHC-49255-57•••-••-02583446201978·N/A6516 Spring StJACKSONVILLEFL32218·GRP-3623CORE-HMO
ENRENR-1401932026-07-22T01:32:50ZHelen··—Ryan1998-10-21UHC-52155-31•••-••-069716305830091NULL··3533 Pine DrAtlantaGA30366GRP-8518SELECT-EPO
ENRENR-1427742026-05-07T11:22:33ZARTTHURX.·HOWELLSep 28, 1960UHC-88241-33—3118058N/A·2865 INDIAN SCHOOL RDGlendaleAZ—GRP-8091MEDICARE-ADV-A
ENR ENR-1226792026-02-21T07:07:30ZWillieC.Elliott1943-01-20UHC-22957-69—14236107302willie.elliott@yahoo.com9782 RIDGE ROAD·TempeArizona85289GRP-3253OPTIONS-PPO
ENRENR-1089872026-04-17T09:50:57ZRoyJDunn22-06-2005UHC-64037-81•••-••-2649468-780-3368roy.dunn43@yahoo.com4764 Ocean AvenueGlendaleAZNULLGRP-7400OPTIONS-PPO
ENRENR-1250182026-02-09T20:41:23ZFreeman, Emma——1989-05-26UHC-84914-51•••-••-81603165246282UNKNOWN6464 Desert Sky BlvdSan AntonioTX78238GRP-2120CORE-HMO··
ENRENR-1329852026-04-07T19:48:29ZDIANAZHAMILTON19930728··UHC-94152-91•••-••-0791·(833) 588-5447diana.hamilton81@icloud.com2769 Church Street·Los AngelesCA90084GRP-8442OPTIONS-PPO
43,101 rows, page 159 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.487Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty