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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4197252026-05-04T16:29:57ZJoshua—Walker1948-12-24UHC-45586-72•••-••-0668714-411-9642—1765 Lincoln WayOrlandoFL32806nullnull
CLMCLM-4153912026-05-23T02:11:54Z MARIAAN—VALEZ1982-11-22UHC-75813-69•••-••-6987——1961 Apache BoulevardDallasTX75267GRP-8742MEDICARE-ADV-A
CLMCLM-4325432026-08-01T03:47:21ZPaulPKelly1989-01-13UHC-35201-48•••-••-2037UNKNOWNUNKNOWN7184 Apache BlvdSeattle··WA98118NULL—
CLMCLM-4052352026-07-07T07:26:59ZJESSICCA—MONTGOMERY19-07-1977UHC-28580-22nullnull—·-—UNKNOWNnull—OPTIONS-PPO
CLMCLM-4210382026-05-18T13:51:36ZGray, Evelyn··——09/15/1968··UNKNOWN··•••-••-3378null—5902 Canyon RdDenverCO80284GRP-8921N/A
CLMCLM-4245282026-05-02T09:19:54ZElijah—Clark1945-08-06UHC-88160-82——N/A3415 BroadwayEden PrairieMN55375GRP-4244CORE-HMO
CLMCLM-418896 2026-07-29T18:21:03ZGraceVHall·2000-05-09UHC2096519•••-••-4908NULL··—2262 BAYSHORE DRTempeAZ85213·GRP-1722CORE-HMO
CLMCLM-4039382026-03-22T21:01:18ZVasquez, Jerry——2000-12-19UHC-81842-70····null-3137 Willow Court·FresnoCA93701··—
CLMCLM-4037612026-03-04T11:32:58ZCheryl—Sott07/23/71—•••-••-2474—NULL9254 Union StMiamiFL33196UNKNOWNSELECT-EPO
CLMCLM-4108292026-07-26T07:03:47Zjustin—estrada1999-10-01··UHC-08400-52—UNKNOWN-N/Anullnull—GRP-4204OPTIONS-PPO
CLM CLM-4326812026-09-08T08:25:18Z Helen—Nguyen11/19/1992·UHC3246591NULL4198476611helen.nguyen66@aol.com9835 Meadow LnNASHVILLETN37205GRP-3434—
CLMCLM-4296272026-07-01T15:28:56ZRUTHHCARPENTER1944-07-27UNKNOWN•••-••-1900901-554-5220null7473 MEADOW LNDALLASTX····-SELECT-EPO
CLMCLM-4198462026-05-18T17:30:24ZAustin—Torrres1941-04-06UHC-31919-33NULLUNKNOWN—5369 Bayshore DrTUCSONAZ—GRP-7007CORE-HMO
CLMCLM-4033412026-02-03T12:36:30Z Rachel—Gonzalez1973-10-17UHC-89828-42UNKNOWN(344) 409-4592·--··UNKNOWN—-UNKNOWNCHOICE-PLUS-PPO
CLM CLM-4244912026-02-08T13:34:54ZFatima—Stephens07/04/95UHC-06221-64-UNKNOWNfatima.stephens@outlook.com1103 Main StSacramentoCA95862N/Anull
CLMCLM-4011042026-06-15T17:57:16ZKathryn—Li2001-05-09UNKNOWN•••-••-2382-—5526 Central AvenueLos AngelesCA90072GRP-3805null
CLMCLM-4327862026-01-01T18:45:21ZTYLER—RAMIREZ·1985-08-04UHC-12321-25UNKNOWN8174637516··135 CHURCH STREETSan DiegoCA92111GRP-7403—
CLMCLM-4283002026-02-01T13:49:14Ztheresa—simpson1985-02-21UHC-13034-08—556-585-0121—2552 Maple AveJacksonvilleFL32230—null
CLMCLM-4283612026-04-01T18:25:55Zbradley—warren23-07-2005UNKNOWN—5883727120null93 Valley View DriveATLANTA··GA30385N/A-
CLMCLM-4295492026-04-15T04:23:28ZZachary—Stevens1983-11-03UHC-41271-59NULL—-6105 Park PlaceChandler·AZ85270GRP-6095CORE-HMO
CLMCLM-4305622026-05-19T18:17:48ZElizabeth—Riley1963-05-28UHC-76809-17•••-••-2580—NULL4203 RIDGE ROADSAN DIEGOCA··92120··UNKNOWN—
CLMCLM-4044172026-03-11T09:37:14ZHIROSHI—MILLS05/01/62UHC-42502-08UNKNOWN2497153941-1782 HIGHLAND AVENUE #310Las VegasNV89162GRP-5618—
CLMCLM-4161282026-03-02T16:20:08ZGeorge·E.Fisher03/23/61··UNKNOWN8336986277UNKNOWN——N/AnullGRP-4420medicare-adv-a
CLMCLM-4195572026-04-08T01:53:57ZHiroshi—Henry1961-11-02UHC-37515-64—+1 914 204 8113-9552 Washington StMinneapolisMN55407UNKNOWNnull
CLMCLM-4305732026-02-03T06:39:25Z RUTH—SANCHEZ··1996-05-14—N/ANULLUNKNOWN2653 Elm StColumbusOH43298-9454GRP-1203CORE-HMO
CLMCLM-4172482026-04-23T20:09:24ZGuerrero, Russell——09/04/1975·null-3544674783—675 Mountain View DrTUCSONAZ85702-4769null··—
CLMCLM-4206952026-03-11T17:41:45ZKARENY.PEREZ·19550703N/A•••-••-1052498.343.3474·NULL2263 Palm DriveNashvilleTN·37250GRP-9131UNKNOWN
CLMCLM-4115562026-02-05T10:48:04Zalexander—schultz1967-11-05UHC-44327-61UNKNOWN12416952655UNKNOWN·7629 Desert Sky BlvdTUCSONAZ85748··NULL
CLMCLM-4083852026-05-02T00:50:53ZDenise—Olson05/11/51UHC-65886-44UNKNOWN237-453-3779·UNKNOWN-NULLUNKNOWNNULL—N/A··
CLMCLM-4161092026-03-22T02:16:24Z RUTH—CONTRERAS07/24/46—null+1 449 425 9697UNKNOWN--UNKNOWN—·GRP-8705—
CLMCLM-4301832026-07-18T12:37:07ZCatherine—Riley1999-11-09UHC-20404-24··nullNULLN/Anullnull—nullGRP-5636—
CLMCLM-4071552026-08-30T22:13:42ZCarlN.George11/11/1993UHC-01033-11•••-••-28237775911976—5349 Jefferson AvenueLos AngelesCA90028GRP-6837—
CLMCLM-4093922026-07-18T13:35:24ZAbigailKHolmes19940316UHC-14169-27-4083596951NULL·6461 Main StreetDenverColorado80200GRP-8488OPTIONS-PPO
CLMCLM-4287252026-09-11T08:18:30ZJoyce··—Johnson8/4/1994UHC-57438-80•••-••-41702222822911null1785 Ridge RdScottsdaleAZ85209N/AMEDICARE-ADV-B
CLMCLM-4000492026-03-10T10:35:12ZDorisF.Garza1957-12-18UHC-03918-71—N/AUNKNOWN5194 Desert Sky BlvdLos AngelesCA90000-4188NULLNULL
CLMCLM-4284392026-07-22T04:42:31ZTyler—Meyer1964-04-20N/A-UNKNOWN—2469 Harbor BoulevardMesaAZ85268··GRP-3800N/A
CLMCLM-4202902026-09-14T12:28:08ZSARAH—ADAMS09-06-2006UHC5710630•••-••-1491NULL—2699 Canyon Road #140FresnoCA93784—UNKNOWN
CLMCLM-4223402026-07-22T00:44:25ZDnun, Jack····—06/26/1944UHC-52947-29··nullUNKNOWN5132 Oak StPlanoTX75084—null
CLMCLM-4061422026-01-24T07:32:33ZTyler—Knight2002-04-27uhc-41760-41NULL905-510-0879NULL6690 Elm StDallasTX75215-8654··UNKNOWN
CLMCLM-4313152026-08-18T17:34:05ZEdward····Bruton2004-01-20UHC-96686-35null833-908-9193—1763 Palm DriveMesaAZ85244GRP-2247MEDICARE-ADV-B
CLMCLM-4318002026-01-25T10:14:58Z JUDY—BANKSOct 25, 1995—-——6291 Canyon RdTempeAZ85204··GRP-4708null
CLMCLM-4182772026-06-18T07:26:29ZCharlotte—Fisher1984-08-28UHC-47722-90····974-990-1508null··7926 Spring StreetCHANDLERAZ85287GRP-8079·N/A
CLMCLM-4307342026-02-18T02:03:27ZJESSE—BRYANT7/25/1948UHC-24474-58-(571) 428-2738—9551 Sunset BoulevardLos AngelesCA90089GRP-3212SELECT-EPO
CLMCLM-4169002026-09-20T03:08:46ZDOUGLAS—TUCKER11/13/71UNKNOWNUNKNOWN··N/Adouglas.tucker12@proton.me7086 Cedar Lane·San AntonioTexas78281-4281N/A····
CLMCLM-4071782026-10-18T13:45:04ZAhmed—Wallace1970-70-11UHC-37460-16——·-4100 Cedar LaneScottsdaleAZ85220GRP-3527N/A
CLMCLM-4128362026-05-21T10:30:10Z Arjun—Marshall1990-03-22N/A—UNKNOWNUNKNOWN8882 MEADOW LN Apt 21Austin·TX78727····null
CLMCLM-4094362026-01-07T15:05:23Zevelyn—owens10/17/1967UHC-31790-37null(747) 820-4284null9133 River RdGilbert·Arizona85224GRP-7873CHOICE-PLUS-PPO··
CLMCLM-4218672026-04-27T21:32:39ZNoah—·Griiffin1967-08-20null•••-••-4088(584) 383-4338UNKNOWN6453 JEFFERSON AVEPLANOtx75054GRP-4886N/A
CLMCLM-4141232026-09-03T03:42:00Z Henry—Reynolds2002-08-03UHC-89188-18—(976) 488-8719—698 MOUNTAIN VIEW DRDallasTX75273GRP-4166—
CLMCLM-4228232026-01-11T14:10:54ZBenjemin—Brooks2008-12-09····—nullbenjamin.brooks94@outlook.com9416 DESERT SKY BOULEVARDSan DiegoCA92148··—SELECT-EPO
32,829 rows, page 73 of 657PreviousNext

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