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-1217312026-07-14T04:21:38ZEMMA—REYES20020802UHC-50136-05•••-••-4339nullemma.reyes@proton.me··1391 Ridge RoadGilbertAZUNKNOWN·GRP-2780MEDICARE-ADV-B
ENRENR-1221762026-05-04T04:57:00ZMATTHEW—GREEN1993-09-16UHC-02834-66•••-••-8816-NULL1531 Oak StGilbertArizona·85291GRP-6861CORE-HMO
ENR ENR-1222952026-10-08T22:08:19ZBryant, FrancesR.··04/02/1955UHC-39441-14•••-••-36365137105418frances.bryant99@yahoo.com3296 LAKE VIEW RDMinneapolis·MN55446-4500GRP-4510CHOICE-PLUS-PPO
ENRENR-1161912026-08-14T22:07:04ZIsabellaOBlack·19880902UHC-19050-02•••-••-7548+1 868 657 4633isabella.black@gmail.com521 Spring StreetSan DiegoCA-GRP-9725SELECT-EPO
ENRENR-1141332026-08-09T20:40:47ZedwardFscott1977-01-11UHC-52393-57•••-••-98978308687644·null6147 ELM STDallasTX75229GRP-9638OPTIONS-PPO
ENR ENR-1040332026-08-05T18:41:25ZGERALDCCUNNINGHAMJul 23, 1951UHC-47203-81•••-••-975017875677578GERALD.CUNNINGHAM8@PROTON.ME3051 WASHINGTON STREETScottsdaleArizona—GRP-8584NAVIGATE-HMO
ENRENR-1243462026-09-24T04:14:42ZWILLIE—GREENE3/23/2001UHC-80414-25•••-••-7052631-291-5495willie.greene@proton.me2632 INDIAN SCHOOL ROADJacksonvilleFLUNKNOWNGRP-9401MEDICARE-ADV-A··
ENRENR-1000262026-03-08T03:36:19ZNANCYOCAMPBELL20-05-1991UHC-10392-04•••-••-46057332381159NANCY.CAMPBELL16@GMAIL.COM3517 BASELINE RD #391JACKSONVILLEFL··32266-0702GRP-5012MEDICARE-ADV-B
ENRENR-1168932026-10-14T04:14:58Z MichaelV.Harrison19603709··UHC-04868-24•••-••-283319577426060·michael.harrison@aol.com7551 LAKE VIEW ROADLos Angeles··CA90095GRP-5271NAVIGATE-HMO
ENR ENR-1372202026-07-02T18:01:40ZBeverly—Andrews0601-49-68UHC-46632-04•••-••-1776930-267-8660beverly.andrews@outlook.com3754 Market StLas VegasNV89190GRP-4371OPTIONS-PPO
ENRENR-1238912026-02-03T10:35:06Z JULIAS···TRAN1973-07-16UHC-57015-51•••-••-01079165387193julia.tran52@icloud.com7521 MEADOW LANE Apt 5SacramentoCA—GRP-4934SELECT-EPO
ENRENR-1330502026-06-08T17:16:22ZPhilip—HuntDec 3, 1940uhc-75677-47•••-••-2944985-371-6230N/A3806 Forest Ave·DenverCO80280GRP-1192MEDICARE-ADV-B
ENR ENR-1238152026-05-12T09:51:34ZSTEVEN—HENRYApr 14, 2005UHC4973404•••-••-0520962-487-5932null2583 Elm StreetTEMPE··AZ85209GRP-6091CHOICE-PLUS-PPO
ENRENR-1121732026-08-10T06:50:31ZJoshuaT.·Roberts27-03-1963UHC-94013-86•••-••-58435431655JOSHUA.ROBERTS13@GMAIL.COM9038 Washington StreetColumbusOH43202GRP-1102MEDICARE-ADV-A
ENRENR-1303152026-09-14T07:48:57ZkatherineHrose1973-04-01UHC-31860-41··•••-••-4642734-537-3502katherine.rose@gmail.com2876 OAK STREETDenverco80221GRP-0259SELECT-EPO
ENRENR-1135642026-07-05T16:09:53ZCarlKPayne10/25/55UHC-04139-14•••-••-0025NULLcarl.payne10@icloud.com3575 WILLOW CT·Los Angelesca90052-7523GRP-3197NAVIGATE-HMO
ENR ENR-1079852026-03-28T01:14:00ZZachary—Hudson12/12/1952UHC-64556-29•••-••-2862(676) 219-7000—3391 Jefferson AvenueGILBERTAZ85288GRP-1265options-ppo
ENRENR-1005102026-02-24T18:59:34ZMADISON····GRAY·1939-01-06UHC-63832-03•••-••-4325358-862-5805—8799 BROADWAY··TempeAZ85296GRP-0472MEDICARE-ADV-B
ENRENR-1402132026-05-25T18:31:53ZSnyder, Ruth·V—08/13/2002UHC-67308-56•••-••-775119714512261RUTH.SNYDER56@AOL.COM8202 Highland AvenueNashvilleTN-GRP-5738·NAVIGATE-HMO
ENRENR-1267962026-03-10T12:20:47ZJoyceVMorrison—UHC-12150-71•••-••-14158293765765·joyce.morrison92@gmail.com1476 Forest AveJACKSONVILLE··FLnullGRP-0901SELECT-EPO
ENRENR-1008772026-01-16T20:08:50ZEUGENEJ.KIM20010802UHC-75568-78•••-••-444114325136961eugene.kim@yahoo.com8421 Mesa DriveLas VegasNV89139GRP-9699MEDICARE-ADV-B
ENRENR-1150252026-05-16T04:27:16ZANA I.—MENDOZA1996-01-08uhc-49984-10•••-••-9040918-820-6065NULL2269 Bayshore DrSeattleWashington·98162-1057GRP-9340NAVIGATE-HMO
ENRENR-1061532026-04-06T06:08:19ZAdamL··Freeman12/10/54UHC-15081-88—NULL—2392 Oak StSan AntonioTX78223GRP-5498CHOICE-PLUS-PPO
ENRENR-1227642026-09-12T21:37:43ZBaker, LoriP—1968-03-05UHC-81821-18•••-••-4390(712) 237-8569LORI.BAKER@AOL.COMUNKNOWN-—NULL·GRP-2723CHOICE-PLUS-PPO
ENRENR-1371042026-07-16T08:31:50ZDickZ.··Bailey1970-05-08··UHC-89724-56•••-••-43568244678316richard.bailey@yahoo.com735 Jefferson AveMiamiFL33100GRP-0998OPTIONS-PPO
ENRENR-1093902026-03-18T18:06:22ZjuanNholmes6/3/1970··UHC-80034-40NULL··263-956-7921juan.holmes95@proton.me·8161 Harbor Blvd Apt 32MESAAZ85275GRP-0160MEDICARE-ADV-A
ENRENR-122017 2026-01-05T14:21:09ZJOSHUAWSHAW1977-03-20uhc-83625-46•••-••-7797913-789-7645joshua.shaw34@outlook.com6188 Hillcrest RdDallasTexas75228GRP-1458SELECT-EPO
ENRENR-1388042026-05-15T23:49:46ZEdwards, Roy·W—1991-09-12UHC-95393-02•••-••-4246231.661.0302—6782 Harbor BlvdSEATTLEWA98114GRP-4996CORE-HMO
ENRENR-1293062026-06-30T13:32:42ZAronE.Vazquez·01/16/69uhc-12265-62•••-••-92603916780884aaron.vazquez62@icloud.com3443 River RoadSacramentoCA95803-3692GRP-5614SELECT-EPO
ENRENR-1396212026-07-30T21:28:24ZHannah—FloresJul 12, 1954UHC-13128-47N/A(597) 716-0199hannah.flores@outlook.com7702 Main StMinneapolismn55432GRP-3543NAVIGATE-HMO
ENRENR-1089502026-04-23T06:10:53ZAbbyTMason2003-07-27UHC-12071-84•••-••-9370262-742-3699abigail.mason52@yahoo.com851 Baseline RdCharlotteNC28284-4100GRP-2266CHOICE-PLUS-PPO
ENRENR-1244032026-05-13T01:41:28ZRuthIMaldonado·7/3/1989UHC1629148•••-••-0571+1 489 659 4682RUTH.MALDONADO@HOTMAIL.COM1565 Lake View RoadPlanoTX··75097GRP-7677NAVIGATE-HMO··
ENRENR-1078662026-04-30T10:32:25ZLARRYZ.BOWMAN1973-10-22uhc-91270-07•••-••-30017917114383larry.bowman45@icloud.com1972 VALLEY VIEW DRSAN DIEGOCA92102GRP-0259CHOICE-PLUS-PPO
ENRENR-1375902026-08-02T23:39:41ZWILLIAMT.WOONG05/15/80UHC-15878-72•••-••-3819420-745-5743william.wong78@yahoo.com7700 PALM DRIVE Apt 8ScottsdaleAZ85254GRP-0989NAVIGATE-HMO
ENRENR-1220512026-09-05T11:39:21ZDYLANKHOWARD11/09/2007UHC-80052-68•••-••-5566(895) 567-6415dylan.howard@gmail.com196 Church StreetPlanoTX75006GRP-2382MEDICARE-ADV-B
ENRENR-1302632026-05-10T11:12:09ZKELLYMJONES2006-12-04UHC-56875-75•••-••-9907(281) 617-9399kelly.jones@aol.com5026 MEADOW LNMesa··AZ85207GRP-0607CORE-HMO
ENRENR-1070932026-06-03T01:55:33ZTERRYB.WOOD1984-09-13UHC-71510-58•••-••-1245-·····9043 Lincoln WayLas VegasNV89135GRP-1853CORE-HMO
ENRENR-1261682026-05-01T13:15:55ZJUANIROGERSUNKNOWNUHC-81488-38•••-••-6468932.728.3550—2839 Main StreetLos AngelesCA90050GRP-6779CHOICE-PLUS-PPO
ENRENR-1369092026-01-05T06:13:49ZJimenez, Joseph———UHC-63252-08•••-••-99263127609582·UNKNOWN9058 CAMELBACK RDTempeAZ85244GRP-9382CORE-HMO
ENRENR-1308932026-10-07T23:58:32Zsteven—hunt1959-80-22UHC-31698-06•••-••-1799—steven.hunt@yahoo.com2211 Willow CourtCharlotteNC28208GRP-5976CHOICE-PLUS-PPO
ENRENR-1159022026-02-28T03:48:38ZAndrews, AnaW····7/20/1952UHC-89158-54•••-••-5291+1 327 202 2270ana.andrews62@gmail.com2817 APACHE BLVDDENVERco80201GRP-5546NAVIGATE-HMO
ENRENR-1012502026-09-09T00:04:18Z·JUSTIN—SHAW1971-02-13UHC-36800-97•••-••-8621·723-252-2359justin.shaw88@icloud.com9091 Baseline RoadEden PrairieMN55301GRP-6561CORE-HMO
ENRENR-1011532026-07-11T03:40:40Ztimothy—kelly1989-07-01uhc-36460-96•••-••-098414893100129-2193 Mountain View Drive·SeattleWashington-GRP-0924MEDICARE-ADV-B
ENRENR-1046832026-08-12T17:58:15ZPeterIRose04/16/1939UHC-46761-66····(749) 400-0201peter.rose48@yahoo.com7632 MAPLE AVESacramento··CA·95884GRP-3193MEDICARE-ADV-B
ENRENR-1390482026-03-30T12:56:03ZElizabeth—GrantAug 9, 1975·UHC-55669-57•••-••-6487·19776231497—7355 Palm DriveSACRAMENTOCalifornia95882GRP-3548MEDICARE-ADV-A
ENRENR-1287102026-02-16T04:17:10ZRYANWJORDAN1998-05-21UHC-77314-38•••-••-0569(858) 825-7642—3112 BroadwayORLANDOFlorida·32821GRP-1195MEDICARE-ADV-A
ENRENR-1014972026-03-30T20:35:36Z Jackson, Dorothy——11/10/2008UHC-09214-53•••-••-6988975-936-9494N/A6142 Lake View RdDenverCO80268-8216GRP-0969CORE-HMO
ENRENR-1403442026-04-23T07:01:15ZJUDITH··—MORGAN17-12-1942UHC8522749•••-••-5486449-367-4179—112 MEADOW LN··CHANDLERAZ—GRP-2808CORE-HMO
ENRENR-1307822026-02-11T08:38:33ZJERRYQMOORE1963-04-12UHC-01331-32•••-••-8834·8214662649-5838 Lincoln WayCOLUMBUSOhio····GRP-3651OPTIONS-PPO
ENRENR-1388592026-01-23T19:58:51ZRobertWJacobs19710114UHC6674829•••-••-3523·(593) 840-8570ROBERT.JACOBS69@AOL.COM7254 Central AvenueAtlantaGA30335-1343GRP-3719SELECT-EPO
43,101 rows, page 29 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:34.788Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty