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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1086722026-03-07T11:15:47ZJeffreyCPorter1976-06-15UHC-09227-06UNKNOWNN/Ajeffrey.porter@aol.com7361 Lake View RoadMiamiFL33114GRP-2490MEDICARE-ADV-A
CLMCLM-4044652026-03-03T01:05:03ZBruceKStephens1938-03-04UHC-46738-13•••-••-65784106070075·UNKNOWN6482 UNION STOrlandoFL32844GRP-5481NAVIGATE-HMO
ENRENR-1067342026-10-11T14:05:06ZDavis, Carl··—1987-07-12UHC-93283-17•••-••-4475509-881-0468CARL.DAVIS@YAHOO.COM——null-GRP-7301··CORE-HMO
ENRENR-1274482026-09-27T12:32:16ZDianaK.Burns2006-11-17·UHC-40188-10NULL19317421158DIANA.BURNS7@OUTLOOK.COM2843 JEFFERSON AVEMiami··FL33120GRP-3530NAVIGATE-HMO
ENRENR-1424292026-09-27T16:08:41ZASHLEY—SILVA1993-05-16UHC-35129-23null3524334723·ashley.silva@aol.com7620 Sunset Blvd··ChandlerAZ85281GRP-2361CHOICE-PLUS-PPO
ENRENR-1369792026-08-21T09:14:04ZChristina—Hawkins03/20/1999UHC-88607-22•••-••-3189(448) 526-2978UNKNOWN4653 Lincoln WayLAS VEGASNevada89117·GRP-9100SELECT-EPO
ENRENR-1224492026-05-09T21:11:05ZTHOMASHCHEN08/09/04UHC-89520-20•••-••-064012769787965thomas.chen@gmail.com5392 Jefferson AvenueChandlerAZ··-GRP-0399MEDICARE-ADV-A
CLMCLM-4012012026-08-23T16:23:22ZSANDRAZGEORGEJul 26, 1939—UNKNOWN639-666-7723—7414 Cedar LaneCHANDLERAZ85287GRP-8840MEDICARE-ADV-A
TPATPA-620102026-08-12T00:45:05ZALICE—·PALMER07/18/1968—-602-256-7270—2542 Palm DriveMinneapolis·mn55402··GRP-0984—
PRV PRV-203222026-09-25T15:45:55ZHenry—Gray1950-12-21····-UNKNOWNUNKNOWN··119 Park PlaceGILBERTAZ85282null·NULL
PRVPRV-233642026-09-28T23:35:25ZJULIE—JOHNSON12/09/71UNKNOWNNULLN/AN/A4699 Sunset BoulevardHoustonTX77023nullnull
ENR ENR-112178 2026-08-05T13:23:32ZFrancesTSimpson·2006-12-03UHC-33828-41•••-••-1752(344) 789-4435frances.simpson@hotmail.com4657 Forest AvenuePlanoTX75084GRP-6641SELECT-EPO
CLMCLM-4138842026-01-17T10:15:00ZPATRICIA—PETEL1958-07-09NULLUNKNOWN703-372-4602-3400 Central AvenueNASHVILLETN37256-0808·GRP-2401UNKNOWN
CLMCLM-4090022026-05-11T21:43:59Z·ALICE—REID1950-07-06null—+1 250 701 2884—3716 Harbor BlvdOrlandoFL32861GRP-0161—
ENRENR-1273902026-06-20T21:05:31ZSOPHIAXFRANKLIN12/01/1938UHC4325464•••-••-0109774-817-5753UNKNOWN2156 OCEAN AVETampafl33622GRP-6347MEDICARE-ADV-A
ENRENR-1383132026-08-21T01:23:50ZHudson, Marcus——1977-06-02UHC-54432-48•••-••-7226717-734-1686marcus.hudson91@proton.me4570 Oak StreetMinneapolismn55467-4509GRP-7587OPTIONS-PPO
ENRENR-1367872026-06-22T23:12:32ZCHARLES—LYNCH1942-12-21UHC-82241-22•••-••-65385698153582·charles.lynch@outlook.com9784 Park PlTEMPEAZ85202GRP-4246MEDICARE-ADV-B
ENRENR-1195942026-10-09T05:44:49ZSandraGSinh10/23/1975UNKNOWN•••-••-956816847308043sandra.singh@proton.me··1491 JEFFERSON AVEGilbertAZ85269GRP-4823OPTIONS-PPO
CLM CLM-4036812026-02-02T13:31:08ZSARAHMALVARADO4/16/1963UHC-19247-27NULL(209) 558-1648··—6407 Grand Ave·OrlandoFL32893GRP-9632—
TPATPA-60885 2026-06-12T09:48:27ZJoyce····Sanchez1966-10-24UHC-16910-09UNKNOWN5079071539null2620 MARKET STREETLas VegasNV··——N/A
ENRENR-1053972026-02-15T03:44:15ZChristineOGarrett1981-04-04··UHC-81591-26•••-••-4770(575) 324-2411·christine.garrett68@outlook.com829 BASELINE ROADLas VegasNV89182GRP-1605medicare-adv-a
CLMCLM-4015182026-10-15T18:03:43Z·RONALD—GONZALES1951-05-19··—UNKNOWN—2738 CENTRAL AVEJACKSONVILLEFL·32239GRP-5774medicare-adv-b
CLMCLM-4171822026-06-08T08:38:04ZAlbert—Schultz19391206UHC7924771UNKNOWN918.693.0633null8850 Hillcrest RoadColumbusOH43219GRP-1889MEDICARE-ADV-B
CLMCLM-4312362026-09-03T00:39:18ZJoshuaMGonzales06-03-2001UHC-38587-47•••-••-7577NULL—4712 Sunset BoulevardPhoenixArizonaNULL—MEDICARE-ADV-A
CLMCLM-4147282026-08-09T16:48:42ZJanetY.Munoz1941-09-07—N/A4469016354JANET.MUNOZ96@YAHOO.COMnullnull-—GRP-8597—
ENRENR-1382912026-06-06T18:34:37ZLisaH.Taylor1983-09-14UHC2068686•••-••-6237241-847-3837LISA.TAYLOR@GMAIL.COM1069 BASELINE ROADEden PrairieMN55389GRP-4158OPTIONS-PPO
CLMCLM-4184742026-07-08T06:40:38Zjacqueline—mason19930708UHC-70522-46•••-••-6389——5140 Cedar LaneMINNEAPOLISMNUNKNOWNGRP-7795CHOICE-PLUS-PPO··
TPATPA-581332026-09-06T23:18:40ZPowell, Bradley——12/2/1988NULL•••-••-7783NULL—5426 Camelback RoadPLANOTexas75059N/A—
TPATPA-571112026-04-20T11:38:38ZMills, Lisa——·12-08-1942UHC-79129-20null——4582 Pine DrLas VegasNV·89107UNKNOWNCHOICE-PLUS-PPO
ENRENR-1414382026-03-25T23:34:53ZWayne—Rios1985-10-01UHC-02895-59•••-••-21017018798wayne.rios@proton.me134 Valley View DriveOrlandoFL32802GRP-8816SELECT-EPO
TPATPA-591582026-07-31T19:40:01ZHansen, Dennis——May 6, 1940··—•••-••-0228N/A··null9125 Jefferson Avenue··Phoenix··AZ85058-····
TPATPA-519662026-07-18T05:02:09Zjoey—lewis2005-04-10——NULL—1020 CEDAR LNScottsdaleAZ85227GRP-2287N/A
ENRENR-1289642026-01-17T13:27:04ZMegan—·Park04-12-1948·UHC-97248-72•••-••-97335642837294megan.park29@icloud.com3187 Maple AvenueSeattleWashington98184GRP-2902MEDICARE-ADV-B··
ENRENR-1294632026-01-04T00:58:38ZBrown, SamuelJ—2001-05-09UHC-22101-79•••-••-2553946.514.9159SAMUEL.BROWN17@ICLOUD.COM8733 MAIN ST #212Scottsdaleaz·85220GRP-5212MEDICARE-ADV-A
CLMCLM-4029742026-01-09T08:19:58ZFATIMA—WEBB20-11-1964UNKNOWN•••-••-1542——2690 Desert Sky BlvdLOS ANGELESCAUNKNOWNGRP-1858OPTIONS-PPO
ENRENR-1234342026-08-05T10:44:11ZLARRY—LYNCH1993-07-16UHC-37451-74•••-••-8177981-992-1687null4992 VALLEY VIEW DRSAN ANTONIOTX78275··GRP-6541NAVIGATE-HMO
CLMCLM-4148152026-01-21T23:59:35ZBruce··—Hansen··06-04-1995UNKNOWN·N/A-—3759 WILLOW CTAustinTX78735UNKNOWN—
ENRENR-1333052026-03-22T18:37:48ZANDREW—HARPER08-05-1981UHC-99041-25•••-••-08239468199420andrew.harper73@gmail.com5722 LINCOLN WAYTEMPEAZ85274GRP-0728MEDICARE-ADV-A
ENRENR-1100992026-01-10T10:02:28ZrobertUweber1982-03-12uhc-94741-69•••-••-1768(914) 816-7895··UNKNOWN5930 MAPLE AVEChandlerAZ85270GRP-7912CHOICE-PLUS-PPO
ENRENR-1336002026-06-30T13:57:20Zdaniel··AortizMar 5, 2005UHC-04338-14•••-••-5756+1 898 937 2565null6892 MESA DRGilbertArizona85208GRP-7928··OPTIONS-PPO
ENRENR-1214932026-01-27T21:12:46ZBETTY—SOTO1220-20-80UHC-28968-52•••-••-6594+1 499 592 5720betty.soto@gmail.com2184 Sage Ct·JACKSONVILLEFL32234GRP-6341CHOICE-PLUS-PPO
ENRENR-1240792026-02-04T00:14:50Z—B.—1960-09-08UHC-60111-50•••-••-1900(674) 752-0478ethan.kennedy79@aol.com3654 Washington StTampafl33609GRP-1893CORE-HMO
ENRENR-1067572026-06-03T18:33:25ZElijahXFlores1966-09-10UHC-89771-64•••-••-79115144282516elijah.flores@outlook.com2946 Washington Street·SacramentoCA95869GRP-9932··OPTIONS-PPO
CLMCLM-4221732026-01-12T00:11:12ZLORI··ROBINSON1955-05-14N/A—-null1793 Mountain View DriveTampaFL33627·nullMEDICARE-ADV-B
CLMCLM-4185402026-04-18T12:53:42ZAshleyEThompson22-11-1999UHC-62776-77nullN/A—8765 Central AveEden Prairie·MN55320UNKNOWNNULL
ENRENR-1266912026-08-08T14:20:08ZJOSHUAP.CHAPMANJun 23, 1963UHC-30766-82•••-••-1315+1 852 403 6049··JOSHUA.CHAPMAN@YAHOO.COM9353 Washington StMinneapolisMN55490·GRP-0604OPTIONS-PPO
CLMCLM-4190172026-04-25T04:39:55ZRICHARD—SNYDER06/12/42····NULL··N/A··2861 Main StChandlerAZ85246UNKNOWNCHOICE-PLUS-PPO
PRVPRV-224012026-08-24T23:16:34ZPaul—Padilla·Dec 6, 1957uhc-43955-02NULL6535784633paul.padilla24@proton.me3595 Meadow LnScottsdaleAZ85200—null··
ENRENR-1307932026-04-24T05:50:08ZANDREWWROGERS6/25/1961UHC-42345-38NULL(798) 885-7752andrew.rogers3@aol.com·2616 BAYSHORE DRIVEAustinTX78789··GRP-4299CHOICE-PLUS-PPO
ENRENR-1035872026-05-24T16:23:08ZWei—Carlson1949-12-04UHC-58954-87•••-••-5860672-900-8203WEI.CARLSON44@OUTLOOK.COM3604 Hillcrest RoadGlendaleAZ85302-6780GRP-8140OPTIONS-PPO
100,000 rows, page 242 of 2,000PreviousNext

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.744Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty