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-4062822026-04-14T23:23:10Z·EricQReed·1967-11-15-•••-••-4973258-795-6415-6945 Ridge RdAtlantaga30358GRP-5594—
CLMCLM-4110962026-05-23T03:58:34ZBRITTANY—STEPHENS1/14/1945N/A•••-••-98019795777865—3384 OAK STREETColumbusOH43201GRP-5867·-
CLMCLM-4091632026-09-14T08:08:38ZNicole—Carter·1978-02-06UNKNOWNNULL—UNKNOWN··5698 GRAND AVENUEHouston··TX77048null—
CLMCLM-4107052026-04-24T09:46:54ZJacob—Johnston1989-01-28NULL··•••-••-45126762152256-8303 Park PlPlanoTX75027GRP-6298MEDICARE-ADV-B
CLMCLM-4284572026-02-11T17:40:24ZJuditth—Castillo1969-12-01-NULL·(245) 550-5351JUDITH.CASTILLO@GMAIL.COM7486 MAIN STNashvilleTN37235·-MEDICARE-ADV-B··
CLMCLM-4177482026-08-18T15:39:27ZJose——05/02/79UHC-23800-23•••-••-47847915452789null1716 Ridge RdNashvilleTN37283GRP-7917—
CLMCLM-4201472026-02-10T02:34:08ZSUE—YANG01/13/2000—null—null3414 CHURCH STJacksonvilleFL32295GRP-6365NULL
CLMCLM-4324022026-07-22T23:33:56ZPETER—MARSHALL··1968-10-23-•••-••-3508(341) 741-2237—6560 Camelback RdTAMPAFL·33646UNKNOWN—
CLMCLM-4178392026-04-28T07:11:57ZNATHAN—PRKER06/24/1951UHC1177961N/A··null2088 Desert Sky BoulevardChandlerAZ··85288NULLUNKNOWN
CLMCLM-4116082026-07-28T03:28:44ZWeaver, Lawrence······Feb 4, 1964UHC-26133-98•••-••-54729292120024—3519 Church St Apt 15TempeAZ85219—·MEDICARE-ADV-B
CLMCLM-4253862026-05-10T07:02:02ZBryan—Stevens1978-01-24UHC-54097-15•••-••-19555073447355NULL—-UNKNOWNUNKNOWNGRP-2849N/A
CLMCLM-4174922026-02-07T12:42:05ZAlice—Bryant1967-08-03UHC-87888-26-3116580398null7231 Palm DrChandlerAZ85265GRP-8488··—
CLMCLM-4159852026-04-17T04:19:49ZYuki··Porter1995-02-05UHC-93362-68NULL-—8028 Mesa Dr·FresnoCA—GRP-3009—
CLMCLM-4017662026-07-23T12:36:20Z JUAN—OLSON07/18/1972UHC-11468-94null4134918263—8046 SPRING STREETCharlotteNC28286GRP-4024CHOICE-PLUS-PPO
CLMCLM-4068822026-09-29T23:19:59ZARTHUR—BENNETT1999-10-06UHC-95087-14NULLNULL··—·9341 FOREST AVENUEDallasTX75241GRP-6987OPTIONS-PPO
CLMCLM-4212652026-08-29T23:59:18ZCHRISTIAN—HAYES3/14/1963UHC-86167-37N/A--957 CAMELBACK ROAD··TempeAZ85207·GRP-2288NAVIGATE-HMO
CLMCLM-4188702026-10-08T07:59:38ZKathryn—Duncan·1966-07-24—null8957558703UNKNOWN-nullN/A—GRP-8419UNKNOWN
CLMCLM-4304462026-10-07T21:18:16Zmariana—cook··1990-12-09··—UNKNOWN+1 507 545 4453—·7964 Bayshore DrColumbusOH43216··GRP-2733null
CLMCLM-4080082026-04-24T15:32:31ZJOEGCOLEMAN07/16/1952UHC-89912-98•••-••-6527—N/A5241 Cedar LnMesaAZ85208N/A—
CLMCLM-4041152026-03-25T04:27:12ZRAYMOND—WOOD1977-12-17UHC4343018null+1 413 645 8907N/AUNKNOWNUNKNOWNN/A—UNKNOWNMEDICARE-ADV-B
CLMCLM-4087752026-04-05T20:53:02ZGARY—JIMENEZ1976-03-26-•••-••-1838UNKNOWN··4951 Jefferson AvenueTampaFL-GRP-4120CHOICE-PLUS-PPO
CLMCLM-4277012026-08-04T04:48:11ZKatherine—West2001-01-25—•••-••-3139(670) 791-8648UNKNOWN798 Central AvenueDallasTX75213GRP-4302·N/A
CLMCLM-4284492026-05-19T15:21:43ZcamilaA·oriz19750325UNKNOWN•••-••-7249--2942 Lake View RoadColumbusOH43224null—
CLMCLM-4283532026-05-19T03:32:50ZThompson, Keith——1963-12-21null—·826.669.3309—6960 Indian School RdJacksonvilleFL32274-5440GRP-5198··UNKNOWN
CLMCLM-4321682026-06-09T18:31:46ZLoganMMorrisonNov 8, 1992UNKNOWN•••-••-9958——7541 Canyon RoadPhoenixAZ85043GRP-3171MEDICARE-ADV-B
CLMCLM-4008552026-09-10T23:12:32ZCROL—PORTER9145-05-28——(503) 834-8350—3041 Market StGlendaleAZ85302GRP-5076-
CLMCLM-4184482026-06-12T19:40:44ZScott—Alvrado21-09-1974UHC-03782-04N/A964.929.7388—5896 HILLCREST RDGlendaleAZ—NULLNULL
CLMCLM-4072082026-01-14T18:52:39ZRUSE—BRENDA1958-08-04UHC-21607-07—714.731.4899—6353 Apache BoulevardMiamiFL33144—OPTIONS-PPO
CLMCLM-4184082026-10-02T04:21:16ZAARON—JONES1992-10-01UHC-48188-28•••-••-2177nullUNKNOWN——-—NULLNAVIGATE-HMO
CLMCLM-4184472026-09-10T08:42:11ZMaria—Castillo10/06/55UHC-23443-73NULL3365926NULL3511 Ocean AveSEATTLE·WA98161—OPTIONS-PPO
CLMCLM-4083502026-06-21T18:54:06ZFields, Mariana——1960-11-22UHC-96749-28—(602) 228-5654-3511 Main StPhoenixAZ85023··GRP-1044—
CLMCLM-4025502026-09-23T12:25:24ZJORDAN—PORTER·1970-07-21UHC3527091—NULLUNKNOWN214 Washington StLos AngelesCA—GRP-1208null
CLMCLM-4286252026-08-14T19:24:34ZDouglas—Kelly·05/25/95UHC-63043-26—9644424332N/A9857 Washington StreetCharlotteNC28231GRP-6952N/A
CLMCLM-4044752026-01-07T15:38:21ZBilly····Barnes1995-06-25-——NULL3035 CHURCH STTampaFL33672GRP-6960N/A
CLMCLM-4209352026-04-26T19:10:07ZTimothy—VasquezAug 16, 1946UHC-40176-50•••-••-5279+1 897 227 1401null———-N/A-
CLMCLM-4202332026-01-18T21:10:31ZKARENQ.RUIZ08/01/43uhc-25421-25N/A19193230121UNKNOWN··5995 Sage CourtAustinTX78782GRP-6459—
CLMCLM-4108852026-08-17T06:49:46ZBruce—Perkins19970411UHC-22797-74—988-605-6822—2502 CHURCH STREETOrlandoFL32874·N/ANULL
CLMCLM-4092102026-10-08T08:00:16Z JEFFREYPCLRAK22-10-1962UHC-45965-92•••-••-3321·945-338-0672——UNKNOWNnull—UNKNOWN··UNKNOWN
CLMCLM-414681 2026-01-10T23:36:49ZJAMES—WANGMay 28, 1961N/A•••-••-19229628729254NULL39 GRAND AVESeattleWA98186GRP-9496CHOICE-PLUS-PPO
CLMCLM-4202442026-06-25T00:07:48ZETHAN—BOYD19901217··null··——nullUNKNOWN·N/ANULLNULLGRP-1165NULL
CLMCLM-4196182026-03-14T12:46:47ZAaron—·Berry3/4/1972·nullnull——3935 Market StreetChandlerAZ85286-null
CLMCLM-4066162026-01-23T09:53:00ZDeniseTHenderson19690406UNKNOWN•••-••-1067—denise.henderson@proton.me5931 JEFFERSON AVENUE Apt 30TampaFL33611GRP-3433OPTIONS-PPO
CLMCLM-4212252026-01-11T19:29:29ZJOEN—GONZALESOct 28, 1986UHC-02734-71nullUNKNOWN-4751 Cedar LaneDallasTX75285GRP-3596CORE-HMO
CLMCLM-4151512026-09-02T22:13:08ZLinda—McDonald··19870312uhc-89393-86-N/Anull4266 BROADWAYMiamiFlorida33192UNKNOWNMEDICARE-ADV-B
CLM CLM-4237582026-10-18T02:02:37Zraymond—washington1968-08-17UHC-78812-89—754-305-9283raymond.washington43@aol.com4238 BROADWAYMESAAZ·85246GRP-1487··
CLMCLM-4314852026-10-05T08:43:58ZPATRICIA—·ROBERTSON1972-02-10UHC-63151-88•••-••-1772834-267-6995-523 Desert Sky BoulevardEDEN PRAIRIEMN55365nullNULL
CLM CLM-4079992026-06-07T15:44:39ZWaatkins, Jean—····1990-03-21NULL•••-••-8233—NULL5101 Mountain View DrSeattle·WashingtonNULLGRP-4147MEDICARE-ADV-A
CLMCLM-4053002026-05-23T23:03:58ZAustin··Valdez1987-09-12N/A—593-381-6745—1588 Apache BlvdTempeAZ85290GRP-9432-
CLMCLM-424148 2026-09-10T14:06:53ZANGELA—WOODS1978-01-03null•••-••-2477UNKNOWN—-··nullN/A—N/ACHOICE-PLUS-PPO
CLMCLM-4002702026-10-18T09:20:24Zbrian—gonzalez1967-08-14UHC-11415-22——N/A7198 Mountain View DriveEden PrairieMN55365GRP-9894··SELECT-EPO
32,829 rows, page 47 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.696Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty