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-1294072026-01-29T08:52:07ZMARTHAIHAYES1696-04-09UHC-66309-25•••-••-3467231-734-8464martha.hayes@gmail.com873 BAYSHORE DRPLANOTX75002GRP-0214SELECT-EPO
ENRENR-1101332026-02-24T19:52:47ZJason—Ford1955-10-21UHC-76473-51•••-••-1131+1 687 394 4189JASON.FORD31@HOTMAIL.COM8074 Maple AveGilbertAZ85252GRP-5651CHOICE-PLUS-PPO
ENRENR-1263112026-09-03T00:08:09Z emma—gardner19510819UHC-60192-48•••-••-5075749-954-9025emma.gardner12@hotmail.com6009 Maple AvenueMiamiFL33192GRP-0306SELECT-EPO
ENRENR-1178242026-04-28T17:39:44ZHananhCDayAug 23, 1991UHC-89666-89·-293-236-4050hannah.day@hotmail.com914 Indian School RoadMINNEAPOLISMN55469GRP-9981OPTIONS-PPO
ENRENR-1338592026-02-11T04:00:45ZJordan—Lawrence2002-09-13UHC-30417-68•••-••-4859—jordan.lawrence@proton.me—nullN/A-GRP-8530MEDICARE-ADV-A
ENRENR-1039812026-07-09T05:04:34ZJOSEMHOWELL1978-11-01UHC-12973-72•••-••-2192673-945-5433JOSE.HOWELL@PROTON.ME6267 Camelback Road·NashvilleTN37265GRP-4813CORE-HMO
ENRENR-1349642026-08-05T18:02:59ZMASONAREID1994-02-25UHC9467882•••-••-0357·18328805841MASON.REID@YAHOO.COM4264 Palm Dr #906··SEATTLE··WA··98165-3286GRP-5271NAVIGATE-HMO
ENRENR-1260162026-01-28T09:50:03ZBRITTANY—GILBERT1949-10-17UHC-17484-71•••-••-7210565.660.4575null·2276 Desert Sky BoulevardMesaAZ85200GRP-9790CORE-HMO
ENRENR-1353952026-08-14T07:13:51ZMARC—SULLIVAN·28-10-1979UHC-87623-30•••-••-3000(422) 443-6457marcus.sullivan@icloud.com3918 Main StreetFresno·CA93754GRP-8622··SELECT-EPO
ENRENR-1040092026-01-04T04:22:41ZGEORGE··FFIELDS07-08-1964UHC-41024-19•••-••-017018092568073george.fields98@gmail.com·6238 DESERT SKY BLVDSeattleWashington98175GRP-8989NAVIGATE-HMO
ENR ENR-138068 2026-01-27T23:51:09ZKYLE—HOOWELL1986-12-25UHC-63180-30•••-••-9587(325) 267-6589kyle.howell37@hotmail.com274 HIGHLAND AVENUEMIAMIFL33152GRP-3767CORE-HMO
ENRENR-1354892026-08-04T01:50:59ZMarcus—Ford1972-01-02UHC-07354-04•••-••-8599704-636-4739N/A4043 Washington StreetEden PrairieMinnesota55344-2106GRP-1020CHOICE-PLUS-PPO
ENRENR-1234252026-03-06T03:43:29ZKARENHBISHOP4210-19-39UHC6525019UNKNOWN575.540.3363karen.bishop@gmail.com1677 Lincoln WayAtlantaGA30360GRP-6079NAVIGATE-HMO
ENRENR-1013352026-06-30T21:38:37ZMargaretVPowell06/01/87UHC-01977-73•••-••-2368+1 846 658 7077UNKNOWN8250 Lincoln WayGilbertAZ85285-3892GRP-5448NAVIGATE-HMO
ENRENR-1261732026-02-15T19:38:55ZABIGAIL—ARNOLD1938-08-22UHC-02262-73UNKNOWN3066647272ABIGAIL.ARNOLD@ICLOUD.COM5646 Mesa DriveSacramentoCA95885·GRP-8958CHOICE-PLUS-PPO
ENRENR-1026152026-05-13T16:33:13ZJOYCE—FERNANDEZ1987-07-11UHC-59485-50•••-••-0280(311) 830-7909joyce.fernandez38@proton.me5478 OCEAN AVEPlano·TX75018GRP-3789CHOICE-PLUS-PPO
ENRENR-1051372026-07-26T22:23:03ZWayne—Hayes01/27/1955UHC-81566-25•••-••-2929nullWAYNE.HAYES@GMAIL.COM6294 HIGHLAND AVESan DiegoCalifornia92136GRP-0326SELECT-EPO··
ENRENR-1293272026-05-22T11:27:59Z·PAMELAKGRANT1961-09-13UHC-80809-65•••-••-133318833087580··null2444 Ocean AveScottsdaleArizona85251GRP-1735OPTIONS-PPO
ENRENR-1149822026-01-26T07:29:31Z ·ValentinaF.Perry19630305UHC6690034•••-••-61449664407054valentina.perry2@icloud.com7019 Mesa Dr··Orlandofl32882-8146GRP-9047CHOICE-PLUS-PPO
ENR ENR-1323602026-08-10T05:33:22ZFrank··W.Chavez08/10/1980UHC-85423-07•••-••-6531226-466-7906-9737 Bayshore DrJacksonvilleFL32293GRP-1594CHOICE-PLUS-PPO
ENRENR-1351482026-06-11T04:20:01ZPark, Ralph——19550707UHC-66680-80•••-••-9506(638) 441-8156-6166 Camelback RoadNashvilleTN37250GRP-0882NAVIGATE-HMO
ENRENR-1248622026-09-14T02:50:39ZAmandaM.Campbell1968-08-28UHC-76091-62•••-••-5992·+1 293 487 4031NULL5649 Camelback RoadMESAAZ85295GRP-6262MEDICARE-ADV-A
ENRENR-1398712026-03-23T04:20:16ZDorothy··DRobertsonFeb 6, 1971UHC-71835-97•••-••-7651(310) 972-8911·-7638 HARBOR BLVDTempeaz85220··GRP-9943CHOICE-PLUS-PPO
ENRENR-1244082026-05-01T13:24:30ZCarpenter, BeverlyZ—1983-06-13UHC-54880-54•••-••-1411340-996-0421UNKNOWN5989 WILLOW CTSan DiegoCA·92170GRP-5404··CHOICE-PLUS-PPO
ENRENR-1381722026-02-23T03:32:52ZYukki—Walker1939-08-08UHC-92170-03•••-••-71924015321593yuki.walker@outlook.com··3710 Willow CourtScottsdaleAZ85202-2668GRP-2631options-ppo
ENRENR-1224302026-10-06T22:09:55ZANGELAXCHAPMN12-03-1947UHC-99359-93•••-••-49494525714656angela.chapman@outlook.com8366 Bayshore DriveDenverCO80247GRP-4699MEDICARE-ADV-B
ENRENR-1209612026-08-30T17:06:55ZMarilynHFoster19830705UHC-25899-89•••-••-03356854729778-··8187 Harbor BlvdLos AngelesCA90086GRP-7066SELECT-EPO
ENRENR-1359492026-02-01T11:00:50ZGregory—Santos1984-11-21·UHC-93032-07•••-••-75654366624051—·8986 CAMELBACK RDOrlandoFL32816GRP-1593MEDICARE-ADV-A
ENRENR-1315512026-07-29T17:15:40ZKATHRYN—ROSS08/13/57UHC-29384-14•••-••-59947675614467kathryn.ross70@outlook.com6403 Mesa Drive Apt 4DallasTX75258GRP-1381··OPTIONS-PPO
ENR ENR-1426052026-01-09T03:07:57ZDennisLVasquez1994-10-20UHC-73619-83•••-••-6845·UNKNOWNDENNIS.VASQUEZ7@PROTON.ME1679 Apache BoulevardLas VegasNV89126-7618GRP-1602MEDICARE-ADV-A
ENRENR-1059112026-04-07T00:11:26ZBlack, Jesse——7/10/1982UHC-62534-65•••-••-3285UNKNOWNjesse.black@proton.me7388 MAPLE AVEDallasTX75247GRP-2293SELECT-EPO
ENRENR-1005522026-09-22T15:42:11ZHELENSROSS·1947-12-15UHC-24200-16•••-••-4745761.969.3583helen.ross@gmail.com6394 Park PlaceSACRAMENTOCA95878GRP-7161NAVIGATE-HMO
ENRENR-1041992026-07-21T17:54:12ZRoyK.Green1955-10-15UHC-60747-64•••-••-1792232-871-9993ROY.GREEN@HOTMAIL.COM8357 Palm DriveHoustonTX77031GRP-9545CORE-HMO
ENRENR-1397762026-02-23T10:45:35ZMARTINEZ—ANDREA5/17/1941··UHC-02997-04•••-••-40529124249-5480 BASELINE RDLos AngelesCA90047GRP-4634OPTIONS-PPO
ENRENR-1021762026-08-17T18:49:25ZLi, Frank——1974-10-04··uhc-11541-03•••-••-7260(334) 618-9898frank.li@outlook.com7401 INDIAN SCHOOL RD·Jacksonville·Florida—GRP-5441MEDICARE-ADV-A··
ENRENR-1363302026-05-18T15:34:19ZLoriX.Hayes1962-11-15UHC-45787-52•••-••-5489(935) 811-6096LORI.HAYES@GMAIL.COM··4548 Lincoln WaySacramentoCA95840GRP-7795navigate-hmo
ENRENR-1104372026-07-21T17:23:35Zandrea—marshall1967-04-12UHC-19707-52UNKNOWN(838) 507-2948null1561 CEDAR LN··SacramentoCA··95814GRP-0599MEDICARE-ADV-B
ENRENR-1307512026-02-07T23:09:07ZRoss, Roy—····6/23/1976·UHC-03594-93•••-••-35294512661roy.ross25@gmail.com2156 Main StSacramentoCA··95896GRP-4815SELECT-EPO
ENRENR-1163632026-09-30T09:20:29ZAlexisVYang1997-10-17uhc-66903-75•••-••-9042(307) 379-5334alexis.yang7@gmail.com5797 ELM STREETScottsdaleaz85278GRP-0199MEDICARE-ADV-B
ENRENR-1158842026-05-06T15:24:29ZlisaMsoto16-08-1980UHC-28518-82•••-••-6497(875) 544-4993UNKNOWN264 Elm StreetSacramentoCA··95876GRP-7817MEDICARE-ADV-A
ENRENR-1336282026-01-24T07:50:29ZVINCENT—HALL1957-06-06UHC-84712-81•••-••-1405(429) 537-7612vincent.hall@gmail.com2755 Mesa DrSeattleWA98136GRP-0136CHOICE-PLUS-PPO
ENRENR-1416552026-08-09T16:13:23ZMaryT·Willis1952-09-17uhc-05010-57•••-••-1558241.768.1188N/A7102 Cedar Ln Apt 30··Denver·CO80262GRP-6211MEDICARE-ADV-A··
ENRENR-1427202026-04-10T20:12:28ZCarlos··—Ruiz1986-04-23UHC-41194-02•••-••-3075UNKNOWNcarlos.ruiz60@hotmail.com4033 MAPLE AVENUEGLENDALEAZ85316GRP-1656OPTIONS-PPO
ENRENR-1030232026-06-27T22:18:35Z·Cheryl—Henry14-07-2000UHC-35872-51•••-••-9174587-725-9033cheryl.henry52@proton.me9407 Oak StreetFresnoCalifornia93788GRP-7381MEDICARE-ADV-A
ENR ENR-1348562026-08-18T16:53:27ZRALPH Q—KELLEY··1975-09-22UHC-28952-82•••-••-3584839-587-9904—·1320 PINE DRTempe·AZ85273GRP-7597CHOICE-PLUS-PPO
ENRENR-1379832026-10-05T01:19:25ZDebbie—Ortega1966-09-17UHC-05686-65•••-••-8399(507) 337-3848··deborah.ortega@icloud.com5164 Lincoln WayAtlantaGA30370-4594GRP-6466SELECT-EPO
ENRENR-1370752026-01-30T14:31:07ZRalphPWagner2001-06-05UHC-63442-26•••-••-91794884808342NULL1263 Spring Street··PlanoTexas75051GRP-7275MEDICARE-ADV-A
ENRENR-124483 2026-01-01T15:02:06ZRuth—Weber1940-05-24UHC-58634-65··•••-••-39526066165ruth.weber@hotmail.com9877 MARKET STREETGLENDALEAZ85334GRP-4319MEDICARE-ADV-A
ENRENR-1139202026-05-07T18:28:38ZBrian—·Alexander1991-10-08UHC-54534-29•••-••-8799--8475 Mesa Dr·NashvilleTN37277·GRP-6868SELECT-EPO
ENRENR-1170102026-10-01T11:10:17ZCarlosE··Howell8/10/1978UHC-32155-72•••-••-50558724481261carlos.howell96@gmail.com5139 Palm Drive #965OrlandoFL32811GRP-6271·MEDICARE-ADV-B
43,101 rows, page 78 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:36.712Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty