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-1327802026-03-02T16:44:06Zwalter—fisherJan 10, 1978UHC-31315-20•••-••-89393272709538walter.fisher@yahoo.com·8228 RIVER RDTucsonAZ85749GRP-1686CHOICE-PLUS-PPO
ENRENR-1416042026-09-20T01:43:16ZArjunBMiller1987-05-08UHC-81052-83•••-••-6844——2069 Washington StreetGilbertAZ··85222GRP-9901SELECT-EPO··
ENRENR-1222512026-07-01T09:17:12ZSims, TunyN—1943-03-18UHC-91881-23•••-••-0763375-844-6222null4987 MAPLE AVENUEJacksonvilleFL32259GRP-1824OPTIONS-PPO
ENRENR-1163402026-10-05T08:15:23ZKen—George10/13/1945UHC-44938-15··•••-••-1006550-761-5240kenneth.george15@outlook.com8887 Pine DrTucsonAZ85749GRP-5899MEDICARE-ADV-A
ENRENR-1110872026-05-15T11:36:32Z Patricia··H.Chavez04/09/1998UHC-71200-93•••-••-6229351.509.7804patricia.chavez@aol.com3111 DESERT SKY BLVDDenverCO80237GRP-6401select-epo
ENRENR-1310712026-07-14T11:40:48ZAmberF.Hayes1960-03-15UHC-24192-40•••-••-6652828-883-4280amber.hayes19@proton.me·NULLN/AN/A—·GRP-7664SELECT-EPO··
ENRENR-1244802026-08-02T01:06:03ZCYNTHIA··—GRYA1986-06-08UHC-12777-98•••-••-3724451-413-2650cynthia.gray65@icloud.com7290 WASHINGTON STJacksonvilleFlorida··32214GRP-8709NAVIGATE-HMO
ENRENR-1277072026-01-21T11:05:29ZMADISON I—FISHER1940-11-14UHC-88122-62•••-••-1653-MADISON.FISHER@AOL.COM2191 River RoadTAMPAFL33675GRP-2307SELECT-EPO
ENRENR-1020742026-10-17T01:36:36ZLISA—STEWART19470124UHC-45005-81•••-••-7750(203) 253-7680lisa.stewart@gmail.com1205 APACHE BLVDMinneapolisMN55427-3983GRP-9572MEDICARE-ADV-A
ENRENR-1128522026-06-09T02:30:23Z Le, Christopher·X··1978-05-01UHC-08988-75•••-••-094615232402971christopher.le@gmail.com5276 MESA DRLos AngelesCA90055GRP-4576SELECT-EPO
ENRENR-1342772026-10-05T06:55:59ZJeremyE.Watkins1971-01-23UHC-96761-53•••-••-6900766-944-3001jeremy.watkins@outlook.com9745 JEFFERSON AVEScottsdaleAZ85234-5048GRP-4947NAVIGATE-HMO··
ENRENR-1372832026-03-09T23:40:11ZDennis—Morales··1978-12-26UHC5252309•••-••-6920+1 664 646 6107DENNIS.MORALES99@OUTLOOK.COM9796 Highland AveDallasTX75261GRP-3113OPTIONS-PPO
ENRENR-1165072026-09-02T07:03:48ZDebra······Powell1945-02-07·UHC-90874-75•••-••-4365(794) 810-1299debra.powell13@aol.com4358 Forest AveTAMPAFL33622-5145GRP-7169CORE-HMO
ENRENR-1009562026-08-18T02:32:12ZStephen—Mrphy10/14/1955uhc-00291-43•••-••-2125(683) 720-2601NULL9309 RIDGE RDNashville·TN37202GRP-2782OPTIONS-PPO
ENRENR-1255572026-03-28T01:14:43ZEdward··—Ward1954-05-07UHC3055603—257.501.3625—3932 Canyon RoadSacramentoCA95831GRP-4139SELECT-EPO
ENRENR-1061912026-07-20T14:13:15ZHarold—Montgomrey1991-04-16UHC-70008-95•••-••-80735556509492··HAROLD.MONTGOMERY@OUTLOOK.COM8521 River RdDenver··CO80269··GRP-6253NAVIGATE-HMO
ENRENR-1261202026-06-08T07:55:34ZMei Y··—WhiteAug 20, 1958UHC-19755-67•••-••-8968-MEI.WHITE@YAHOO.COM3997 CENTRAL AVENUE Apt 39··Eden PrairieMN55329GRP-3099OPTIONS-PPO
ENRENR-1179232026-10-14T15:30:10ZMaryF.Marquez2010-19-81UHC-65462-14•••-••-7903—mary.marquez42@outlook.com9126 UNION STAtlantaGAN/AGRP-9944CHOICE-PLUS-PPO
ENRENR-1284992026-05-30T00:49:33Z Allen, Henry——1971-08-01UHC-76663-03•••-••-70147768212HENRY.ALLEN@GMAIL.COM8503 Pine Dr··ColumbusOH—GRP-8478··SELECT-EPO
ENR ENR-1172442026-03-12T04:31:21ZSTEVEN—KELLY1988-03-01UHC-47460-74•••-••-6785313-802-1811steven.kelly@outlook.com1297 SPRING STScottsdaleAZ85209··GRP-4872CHOICE-PLUS-PPO
ENRENR-1166672026-06-11T18:46:00ZDennisMWalsh1974-02-22UHC-09808-11•••-••-7501—·DENNIS.WALSH37@GMAIL.COM7890 Desert Sky BlvdMinneapolisMN55425GRP-2404·CHOICE-PLUS-PPO
ENRENR-1415852026-04-01T20:15:32ZDrewQMarshall·-UHC9534043-(744) 308-6912andrew.marshall@outlook.com6828 Meadow LnSan DiegoCA92120GRP-5809SELECT-EPO
ENRENR-1185442026-04-17T14:06:16ZMARIANLITTLE08/17/1995UHC6563058•••-••-339917919203011MARIA.LITTLE@GMAIL.COM8543 Ridge Road···CharlotteNC28284GRP-1184NAVIGATE-HMO
ENR ENR-1281282026-06-28T21:14:01ZBETTY—·COOPER2000-08-23UHC-83087-08N/A(849) 867-2884betty.cooper70@aol.com2201 BROADWAY Apt 29Miami·FL33145GRP-2363CHOICE-PLUS-PPO
ENRENR-1103352026-03-31T10:07:41ZAelxander··Perry25-08-1975UHC-24848-99•••-••-144213988230383—2228 Valley View Dr Apt 6··EDEN PRAIRIEMN55396··GRP-0284MEDICARE-ADV-B
ENRENR-1002072026-10-06T08:48:47ZCHERYL··—MILLER12/23/1961UHC-60441-39•••-••-5436(774) 222-9884cheryl.miller@icloud.com4059 Harbor BoulevardDenverCO··80273GRP-4170·NAVIGATE-HMO
ENRENR-1146142026-08-01T17:39:32Z sandra··—ellys··1980-07-09UHC-93359-09-301-583-7640SANDRA.ELLIS9@HOTMAIL.COM8611 Oak StreetScottsdaleAZ85258GRP-4401MEDICARE-ADV-B
ENRENR-1209962026-09-23T05:26:58ZAlexanderEHikks1946-12-18··UNKNOWN·NULL(729) 239-4376alexander.hicks70@proton.me1076 Sunset BoulevardPhoenixAZ85027GRP-9426CHOICE-PLUS-PPO
ENRENR-126282 2026-03-23T01:51:55ZROBERTQ.PRICE04/12/1967UHC-60747-77•••-••-41912549092832-1156 Meadow LaneATLANTAga30313GRP-6023SELECT-EPO
ENRENR-1027742026-02-10T20:36:57ZAhmed—Gutierrez1930-85-12UHC-99150-74•••-••-1105(233) 672-1836ahmed.gutierrez@icloud.com6178 FOREST AVEColumbusOH43204GRP-7378CORE-HMO
ENRENR-1249642026-03-02T13:03:47Z SHIRLEY—·GILBERT11/20/1977UHC-22793-21•••-••-68923607114shirley.gilbert97@proton.me2554 Union StScottsdaleAZ85201GRP-2834MEDICARE-ADV-A
ENRENR-120590 2026-01-30T23:48:21ZDONNANWEAEVR1955-03-14UHC-45899-75•••-••-9029+1 648 878 5248donna.weaver@hotmail.com9791 Park PlaceAUSTIN·tx78756··GRP-5792NAVIGATE-HMO
ENRENR-1326142026-07-25T23:04:18ZJanetAHicks1953-06-15UHC-36211-77•••-••-4330·+1 381 293 5463janet.hicks3@yahoo.com40 Main StreetCOLUMBUSOhio43241GRP-0803SELECT-EPO
ENRENR-1409682026-04-09T09:14:12ZTIMOTHYJLONG2003-10-01··UHC-46380-98null2673602144timothy.long86@yahoo.com994 BroadwayGlendaleArizona85304GRP-0541OPTIONS-PPO
ENR ENR-1120862026-06-21T14:33:43ZEVELYN—AUSTIN04/15/1953UHC-82037-47•••-••-8995—UNKNOWN6261 Church StreetGilbertAZ85299·GRP-6566CORE-HMO
ENRENR-1303732026-06-25T21:08:57ZJOSED.COOK1954-04-10UHC-70225-01•••-••-89913235025275jose.cook@yahoo.com7755 Union StreetLas VegasNV89104-5967··GRP-1231··MEDICARE-ADV-A
ENRENR-1059552026-02-11T22:58:19ZTORRES—JANET1984-02-13uhc-48740-56····5929955683null4107 Bayshore DrivePhoenixAZ·85014GRP-8818OPTIONS-PPO
ENRENR-1124932026-06-06T13:32:40ZOmarF.Bell5/17/1998UHC-60474-16N/A(926) 891-2558UNKNOWN9649 Camelback RdSeattleWashington·98107GRP-5227OPTIONS-PPO
ENRENR-1164182026-08-30T22:56:06ZGraceGWelch··19390417UHC-28155-26•••-••-1080·5277738860·UNKNOWN1665 Desert Sky BoulevardAtlantaGA30390GRP-8626MEDICARE-ADV-B
ENRENR-1323822026-04-09T22:44:08ZTylerT.Weber1967-02-10UHC-32985-45•••-••-9263210-569-0851tyler.weber6@hotmail.com··5659 Main StreetLas VegasNV89166GRP-6169select-epo
ENRENR-1003922026-02-03T02:53:57ZSalazar, Lori——Aug 20, 1942UHC-58817-75•••-••-3021280-919-8463··lori.salazar@aol.com9236 APACHE BLVDDallasTX75233··GRP-1577CORE-HMO··
ENRENR-1199762026-02-16T16:00:50ZAmy—Ryan2004-12-02UHC-44975-74•••-••-4994409.766.9036···6868 Harbor BlvdSCOTTSDALEAZ85294GRP-2039CORE-HMO
ENRENR-1009852026-10-07T11:04:44ZDAVID—SULLIVAN1938-12-13··UHC-18996-19•••-••-9638753.355.7924UNKNOWN7502 Union StNashvilleTN37244GRP-9693OPTIONS-PPO
ENRENR-1297352026-05-11T16:29:38ZCarter, ArjunJ—20080204UHC-69028-60•••-••-90408855956045arjun.carter@proton.me2008 Market StreetCharlotteNC28246GRP-4070··MEDICARE-ADV-B
ENRENR-1131352026-05-07T16:47:23ZPhilip—Montgomery1947-11-16UHC-95197-13-19724550747philip.montgomery@outlook.com2672 Spring St·San Antoniotx78211·GRP-4618MEDICARE-ADV-B
ENRENR-1338172026-09-20T05:33:49ZAlbert—Fisher·1981-06-04N/Anull(305) 976-0699albert.fisher56@outlook.com9784 Harbor Boulevard #537GilbertAZ85212GRP-9049CORE-HMO
ENRENR-1027782026-05-23T08:45:55ZMARIAJPERKINS04/22/79UHC-18060-30•••-••-10029602218858maria.perkins33@yahoo.com5752 Central AvenueAtlanta··GA30396GRP-5428CORE-HMO
ENRENR-1292002026-03-21T15:13:16ZJanetH··Morgan··1968-04-24UHC-17766-52•••-••-3601+1 533 615 3995janet.morgan@aol.com2596 Sunset BlvdChandlerAZ85228GRP-6584MEDICARE-ADV-B
ENRENR-1344402026-02-25T16:00:37ZWEIZGREENE1997-03-09··uhc-56726-05•••-••-9166501-263-9404—8481 Mesa Drive···MinneapolisMN55409GRP-8323MEDICARE-ADV-B··
ENRENR-1290672026-09-05T04:45:59ZMelissaS.Kelly02/23/1967UHC-12381-10•••-••-3659(932) 329-2201melissa.kelly@outlook.com7347 Church StFresnoCA·93707GRP-6879navigate-hmo
43,101 rows, page 69 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.702Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty