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-4046872026-05-05T02:24:42ZAshley—Bowman··Jun 17, 1978UHC-45993-85•••-••-3365(549) 371-3290UNKNOWN1097 Oak StTEMPEArizona85271GRP-9699··null
CLMCLM-4235772026-04-04T04:33:29Z PeterYHernandez-—•••-••-9194889-460-0573-7574 BASELINE ROADGILBERTAZ85204NULLMEDICARE-ADV-A
CLMCLM-4288842026-07-29T08:54:56ZGarcia, Austin——1972-07-16UHC-61676-05—null—8689 MEADOW LANESACRAMENTO··CA95863GRP-1300—
CLMCLM-4274762026-09-29T06:51:18ZMARGARET—GONZALES1981-02-10UHC-59119-32UNKNOWN·831-731-1167UNKNOWN6102 VALLEY VIEW DRORLANDOFL32807-MEDICARE-ADV-A
CLMCLM-4131122026-03-09T19:50:30ZCarolG.Fowler04/09/1995UHC-12538-47NULL+1 227 516 8933··—7684 Lincoln WaySacramentoCA95821nullMEDICARE-ADV-A
CLMCLM-4169282026-06-11T16:54:12ZALEXANDERHGRAYMay 1, 1940UHC-74703-60··UNKNOWN—alexander.gray@yahoo.com2104 Apache BlvdNASHVILLETN37207GRP-3053null
CLMCLM-4138422026-03-08T10:13:08ZJonathan··—Nguyen1955-06-07N/AUNKNOWNN/ANULL—UNKNOWN····——N/A
CLMCLM-4278552026-05-18T07:22:12ZSara—Hawkins02/02/86-•••-••-4742+1 926 290 1022UNKNOWN1415 Ocean AveAtlanta·ga30337GRP-0717NULL
CLMCLM-4297872026-01-15T16:31:15Zheather—·ramirez1984-02-13UHC-38315-81N/A·NULL··7274 HILLCREST RD··NashvilleTN37213NULLNAVIGATE-HMO
CLMCLM-4029892026-07-18T18:35:32ZGaryH···Cook1969-06-01——15615335122NULL6769 CENTRAL AVELas VegasNV89148GRP-2375—
CLMCLM-4261942026-01-05T10:55:41ZJudy—Day1976-03-09··UNKNOWNUNKNOWN7418337789—N/A····——GRP-2100·N/A
CLMCLM-4104962026-02-20T21:40:25ZDaniel—Hawkins··2006-06-15··UHC-93697-01•••-••-4435N/AN/A·6882 Harbor Boulevard·GilbertAZ85221GRP-6477CHOICE-PLUS-PPO
CLMCLM-4325562026-10-16T18:02:04ZSANDRAMSCOTT1974-11-01UHC-00116-94•••-••-9878(411) 580-8782N/A3389 Harbor BlvdLas VegasNV·89158-9670UNKNOWNnull··
CLMCLM-4264162026-02-02T15:41:38ZARTHR—HOLMES1979-10-16uhc-61995-62NULL(400) 583-4862-6471 MEADOW LANEAustinTX··78734—MEDICARE-ADV-B
CLMCLM-4251422026-02-12T00:30:09ZGerald—Watson1959-09-14N/A-N/A··gerald.watson@icloud.com9473 Palm DrChandlerAZ··—-NAVIGATE-HMO
CLM CLM-4089422026-01-02T08:57:16ZSusan—Garrett1939-08-02uhc-86282-68··•••-••-7369+1 679 559 3135N/A4507 Ridge RdDenverco80256NULLCHOICE-PLUS-PPO
CLMCLM-430442 2026-01-16T10:46:37ZGERALD··—ANDERSON8/3/1999···UHC-60914-75N/A(780) 908-5422gerald.anderson18@icloud.com·6481 Lake View RoadMesaAZ85283GRP-3457—
CLMCLM-416640 2026-07-18T20:59:00Z·Ruiz, RalphQ—1954-06-03NULLnull368-826-4206null·777 Lake View RdFRESNOCA93760····MEDICARE-ADV-B
CLMCLM-4322052026-01-08T16:51:23ZMarcVAllen1984-07-06—•••-••-3252787-212-4274NULL474 Harbor Boulevard Apt 5Eden PrairieMN55391—OPTIONS-PPO
CLMCLM-4289032026-05-23T01:06:02ZWilliam·····Carpenter1948-06-03···NULL•••-••-6281—UNKNOWN9388 MARKET ST··TempeAZ85270GRP-5732CHOICE-PLUS-PPO
CLMCLM-4033162026-06-05T21:38:05ZSCOTT—BARNES1999-01-19—•••-••-2041687-739-6692-8037 Forest AvenueChandlerAZ85280UNKNOWN—
CLM CLM-4162692026-02-22T01:30:14ZMariaEChenOct 9, 2006UHC0660737—N/A··N/A5649 Elm StreetEden PrairieMinnesota55345GRP-9912MEDICARE-ADV-A
CLMCLM-4219212026-05-02T02:49:03ZTHERESA—HENRY12/11/1991UHC-34912-88nullnulltheresa.henry21@icloud.com8184 Meadow LnSAN DIEGOCA92175GRP-1724··SELECT-EPO
CLMCLM-4165842026-07-18T16:51:53ZLARWENCE—MORGAN9187-06-08UHC-20131-53—+1 824 549 4912——-NULL—GRP-8876—
CLMCLM-4248252026-02-05T20:10:31ZDENNIS··THOMPSON1955-10-11UNKNOWN··•••-••-7935(468) 758-6380—8585 GRAND AVENUEDenverCO80212GRP-6742core-hmo
CLM CLM-4299842026-04-04T09:31:05ZMcDonaldWTheresa1967-09-28UHC-35139-46•••-••-0479805-865-6923null—N/A·nullUNKNOWNGRP-2756—
CLMCLM-4314522026-10-02T22:48:03ZJensen, JoseS.—1953-01-13UHC-42670-96N/A425-274-4181····2719 OCEAN AVENUENashvilleTN37260-4320GRP-6226UNKNOWN
CLM CLM-4224632026-09-08T21:57:23ZDiana—Cooper1993-02-21UHC-93659-24•••-••-3498(820) 616-7600····855 Pine DrivePhoenixAZ85047-2073GRP-9380CHOICE-PLUS-PPO
CLMCLM-4064732026-10-04T01:11:25ZLaura—Ryan1993-01-22UNKNOWN•••-••-787513507482025—9430 SUNSET BLVDCharlotteNC28259GRP-0997null
CLMCLM-4183212026-08-13T00:52:13ZPamela—Bryant3/17/1960UHC-85849-44——-609 Lake View RdLos AngelesCA90019-5047GRP-2604N/A
CLMCLM-4217272026-03-26T03:32:27ZMASONS.GARRETT2005-06-06N/A—8725199267NULL6530 Bayshore DriveNashvilleTN37281-7282NULL—
CLMCLM-4129842026-08-26T20:58:44ZKathyGDixon1989-07-28———NULL9088 Union StreetSan DiegoCA92189-7297GRP-1423·SELECT-EPO
CLMCLM-4050482026-04-27T20:10:33ZLopez, Tim——1946-01-15UHC-58975-81··—NULLUNKNOWN·9308 Meadow Ln #186NashvilleTennessee37271GRP-8535—
CLMCLM-4168072026-02-03T13:50:43ZJANET—CRUZ1955-06-17N/A-UNKNOWN———····N/Anull··—
CLMCLM-4205342026-04-02T09:09:07ZFRANCES—·HARRIS2008-05-17··UHC-24775-06N/A——1203 Church St Apt 36TAMPAFL·33691GRP-2003—
CLMCLM-428492 2026-01-19T13:02:50ZARTHUR—WONG07/15/75UHC-99527-30nullnull—nullnullNULL-····null
CLMCLM-4131412026-01-04T23:50:06ZSERAH—OLSON10/06/2002uhc-21778-67-(756) 401-9099NULL6116 Willow CourtFRESNOCalifornia93786··GRP-0721UNKNOWN
CLMCLM-4272162026-02-20T16:02:49Zashley—bowman1954-07-27UHC-55178-78•••-••-3065-—5161 MEADOW LNSan AntonioTX78219GRP-6238··NAVIGATE-HMO··
CLMCLM-4314382026-02-05T16:29:23ZAnn—Hoffman2008-02-22UHC-86939-73——null1273 Ocean AvenueMINNEAPOLISMN55468NULLSELECT-EPO
CLM CLM-4272082026-01-19T17:33:05ZJulie—Franklin09/25/1967N/A•••-••-4067NULLNULL6590 HILLCREST ROADHoustonTX77018UNKNOWN·MEDICARE-ADV-A
CLMCLM-4275552026-01-25T15:50:27ZKymberly—Wood10/3/1984—•••-••-6862UNKNOWNnull6099 Cedar LaneTucsonAZ85708-6673GRP-3677NULL
CLMCLM-4147552026-07-10T21:08:32ZsandraSsimmons··1967-02-27null•••-••-3796508.229.1918-469 ELM STSeattleWA98181GRP-6629NAVIGATE-HMO
CLMCLM-4258712026-09-29T05:34:51ZEthan··Contreras1974-12-03UHC-16890-61···9493395462N/AUNKNOWN—UNKNOWN—UNKNOWN—
CLMCLM-428345 2026-05-17T22:40:49Zyuki—willis1985-12-25··UHC-15526-71··•••-••-3738·--5308 MEADOW LANEMIAMIFL33177-2077GRP-0506··—
CLMCLM-4233812026-09-24T15:25:10ZLAURRAVALVARADO1967-03-02UHC-14487-86•••-••-58634777190704—8940 Church StreetHoustonTX77084GRP-1293UNKNOWN
CLMCLM-4022362026-05-27T19:52:19ZDenise—Lewis1966-09-27UHC-57967-56•••-••-6500—·null427 VALLEY VIEW DRIVELos AngelesCA90097NULLMEDICARE-ADV-A
CLM CLM-4072302026-05-30T21:15:13ZDavidBWelch1949-12-20UHC-36888-34•••-••-6046632.852.1600··null5546 CAMELBACK ROADAtlantaGA30331—UNKNOWN
CLMCLM-4158952026-09-29T21:26:37ZVIRGINIIA—MEJIA1986-09-13UHC-32892-06—212.871.7470—6665 Lake View RoadAustinTX78706GRP-6352SELECT-EPO
CLMCLM-4142922026-05-08T02:24:44ZRobertson··—Kevin1939-09-25UHC-47428-12NULL(488) 722-4349null3764 Sage CourtEden Prairiemn55337—OPTIONS-PPO
CLMCLM-4300952026-10-05T04:52:47ZNelson, JeanO—1987-09-12UHC-20738-64nullUNKNOWN··5776 Ridge RoadCHARLOTTE·North Carolina28236GRP-3021UNKNOWN
32,829 rows, page 46 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:36.695Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty