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-4243892026-04-22T22:21:18ZSofiaKMontogmery11/5/1943—•••-••-0309327-545-1987—9440 Canyon RdGLENDALE·AZ85329—CORE-HMO
CLMCLM-4041052026-05-07T18:36:55ZZACHAY—CARPENTER1946-09-12null·NULL—zachary.carpenter14@hotmail.com4234 Central AvePHOENIXAZ85025GRP-7191—
CLMCLM-4105492026-09-19T17:42:25ZYUKI—POWELL1971-05-24·UHC-46195-87•••-••-4585(851) 223-7099-402 LINCOLN WAY··GlendaleAZ··85390····UNKNOWN
CLMCLM-4013132026-08-16T10:55:42ZAhmed—·Schultz09/27/05—NULL607-960-7108··-6157 Hillcrest RdLAS VEGASNV89173GRP-4865·NULL
CLMCLM-4191622026-07-04T06:57:37ZGomez—Benjamin7/21/2002UHC-32991-98NULL··-4511 Mesa DrLas Vegas··NV·89152null-
CLMCLM-4094702026-07-04T04:28:13ZEMILY—BURNS·1967-05-03UHC-65846-64•••-••-8725289-339-6858·-3055 Desert Sky BoulevardCharlotteNC28265-0587GRP-6280OPTIONS-PPO
CLMCLM-4086262026-10-10T10:43:29Zbetty—le1953-07-25UHC-26618-68—NULLN/A9800 Mesa DrHouston··TX-GRP-0565SELECT-EPO
CLMCLM-4262682026-05-28T22:21:10ZBRYANYBRADLEY05/12/87——(212) 609-3209BRYAN.BRADLEY23@ICLOUD.COM5040 Oak Street Apt 38MIAMIFL33161····NAVIGATE-HMO··
CLMCLM-4115792026-06-08T08:52:43Zelijah—weber09/16/1993UNKNOWN•••-••-777118218912138NULL6572 Washington Street·FresnoCA93780—-
CLMCLM-4318102026-10-07T07:59:41ZSAMUEL—RICHARDSFeb 14, 1984N/AN/A(264) 545-3770—2173 MOUNTAIN VIEW DRIVEPhoenix··AZ85006-6953—null
CLMCLM-4149692026-05-29T13:52:42ZBarbara—Palmer1974-10-15··uhc-58152-86N/A—UNKNOWNN/A——NULLnull-
CLMCLM-4268132026-01-12T11:54:45Z Baker, Sara—··05-12-1979·uhc-35017-70•••-••-3883NULL———N/A-—MEDICARE-ADV-B
CLMCLM-4186922026-07-23T08:49:02ZMARTHA—WARREN··9154-11-19UHC-61710-65NULLnullN/A3383 Lake View RdScottsdaleAZ85239-9408GRP-0565SELECT-EPO
CLMCLM-4099812026-06-05T01:11:50Zwei—bradley·1962-09-24UHC-76357-55—null—2524 BASELINE ROAD·COLUMBUSoh43297-1034GRP-7259NULL
CLMCLM-4103682026-02-19T23:33:08ZAaronMLarson1995-06-15UHC2552572N/A4393493046—7090 Union St·MinneapolisMinnesota55418GRP-0415NULL
CLMCLM-4037652026-02-08T11:41:32ZRobinson, Alice——19551226UHC-97366-44NULLNULL··8625 Spring StEden Prairie·MN55365GRP-3417OPTIONS-PPO
CLMCLM-4160662026-10-03T14:49:24ZJEFFREY—COOPER1969-05-25null··N/A289-967-4606NULL4452 ELM STREET·San Antonio·TX78210GRP-3557CHOICE-PLUS-PPO
CLMCLM-4155152026-03-09T01:27:01Z Keyth—Walker06/22/1996-··•••-••-3634·+1 446 333 7236UNKNOWN8898 Apache BlvdDALLASTX75278GRP-4159CORE-HMO
CLMCLM-4281562026-07-30T22:06:44Z KIMBERLY··—HENDERSON10/18/1942UHC-39645-38··765.730.7466NULL4544 MOUNTAIN VIEW DREden PrairieMinnesota55377GRP-7087-
CLMCLM-4261142026-05-12T04:35:55ZJames—Bishop1953-11-23null•••-••-8470(899) 921-9614—NULLnullN/A-GRP-1182UNKNOWN
CLMCLM-4308152026-01-08T13:16:29ZDiego—Montgomery06/08/50——·····N/A2865 Main StreetColumbusOhio··43211·GRP-1756MEDICARE-ADV-A
CLMCLM-4112102026-01-23T08:59:25Z Eric—Rios1966-11-03-UNKNOWN——UNKNOWNUNKNOWNnull——MEDICARE-ADV-B
CLMCLM-4282372026-06-07T00:10:24ZBruceG.Evans1965-11-07—•••-••-5988+1 459 271 0513bruce.evans@outlook.com6479 River Rd·DENVERCO80250GRP-4606NULL··
CLMCLM-4044782026-01-27T21:00:42Zalan—soto1995-10-12UHC-84799-55—7157709265-887 River RdGlendaleAZ85348···GRP-6080—
CLMCLM-4265922026-10-04T06:33:52ZGary—Fields8/24/1988UHC-65382-80•••-••-8130—gary.fields@hotmail.com8600 Willow CtFresnoCA93736GRP-7846OPTIONS-PPO
CLMCLM-4005012026-09-02T22:31:28Zmartha—parker19810215UHC-19603-97··N/A(602) 644-4202—9366 Maple AvenueEden PrairieMN55321·GRP-9206NULL··
CLMCLM-4223142026-09-11T10:59:46ZLISA—FERGUSON1965-10-13uhc-46337-12nullUNKNOWN—4972 Cedar LnEden PrairieMN55370——
CLMCLM-4020872026-04-21T07:28:56Z·Mateo—·Olson19570604UHC-93325-81-894-221-6360··NULL7391 BROADWAYMesaAZ··85251-select-epo··
CLMCLM-4122552026-06-29T11:22:25Z·Michelle—Morales··1967-07-07UHC-22339-48-(686) 938-3019michelle.morales@aol.com1321 Washington StCHANDLERAZ85278N/A-
CLMCLM-4296792026-05-25T05:00:33Zjulie—patel1978-02-18—•••-••-7540772-763-2573—2174 Highland AveTucsonAZ85760-MEDICARE-ADV-A
CLMCLM-4078302026-06-11T16:28:25ZEMILY—SIMPSON20060820UHC-45607-98—NULL-7381 Canyon RdJacksonvilleFL32293GRP-6663····
CLMCLM-4124402026-03-21T14:26:43ZTimotthy—Walsh1/6/1990UHC6878122•••-••-2196—timothy.walsh37@gmail.com1204 Maple AveCHARLOTTENC28211N/ACHOICE-PLUS-PPO
CLMCLM-4206892026-02-06T13:08:12ZWILLIE··—ROBERTSON1987-06-12UHC-05897-83NULLN/Awillie.robertson9@aol.com7625 Union St··FresnoCA93760·UNKNOWNCORE-HMO
CLMCLM-4231632026-02-21T08:55:34ZCAROLYN—WOOD1988-03-10UHC-07649-64—6736242975··900 Union Street Apt 21CHARLOTTENorth CarolinaNULLnull—
CLMCLM-4127662026-07-02T11:06:55ZRyan—Jackson1942-11-15UHC-99047-36—4297627401-·7371 WASHINGTON STREETATLANTAga30381GRP-8565SELECT-EPO
CLMCLM-4038032026-09-19T23:12:02ZRyan—Graham1975-11-27N/A—-—9138 Mountain View Dr··MiamiFL33138N/ACORE-HMO
CLMCLM-4212772026-01-06T22:26:52ZSantiago, Elizabeth——1974-02-24UHC-79914-44null—null1713 RIDGE ROADMesaAZ85274GRP-5017OPTIONS-PPO
CLMCLM-4172912026-10-02T02:10:07ZJACOB—RUSSELLMar 27, 1961··——·3635020664—2233 BroadwayDallasTX75284——
CLMCLM-4222342026-08-01T13:08:50ZMARILYNTWEST··1980-07-28··NULLN/A—UNKNOWN4394 Apache BoulevardGlendaleAZ85329NULLMEDICARE-ADV-B
CLMCLM-4195652026-08-01T20:18:11Zandrea—russellAug 16, 1944UHC-54510-32•••-••-7349NULLandrea.russell28@yahoo.com8847 Apache Boulevard #841PLANOTX75059-—
CLMCLM-4193792026-01-19T04:36:28Zalbert··ellis2001-08-08UNKNOWNnull—NULL860 Ocean AvenueHoustonTexas77050-2304GRP-0344null
CLMCLM-4020712026-06-22T22:59:52ZBENJAMIN—·JOHNSTON1948-02-17UHC-90631-95•••-••-5715497-614-5415NULL··5939 Cedar LnOrlandoFL32857N/A·UNKNOWN
CLMCLM-4108712026-08-19T07:55:20ZGerald—Bennett8/7/1978UHC-84632-41—5108065193NULL4382 Canyon RoadColumbusOH43234—NAVIGATE-HMO
CLMCLM-4305242026-03-15T02:34:27Z·StephanieEBailey1989-06-25UHC-57013-20-·N/AN/A366 Market StTucsonAZ85701GRP-2613N/A··
CLMCLM-4107982026-07-06T23:53:41ZDanielle··—Clarrk8/14/1984UHC-04851-37•••-••-1626—·danielle.clark85@icloud.com8705 PALM DRScottsdaleAZ85223—null
CLMCLM-424149 2026-01-09T01:43:13ZANGELA—WUODS1978-01-03····•••-••-2477——6025 OAK STREETMinneapolis···MN55407-6695NULLCHOICE-PLUS-PPO
CLMCLM-4150282026-05-12T09:31:12ZLori··—Campbell1985-03-01—nullNULL····3207 VALLEY VIEW DROrlandoFL32890GRP-8925UNKNOWN
CLMCLM-4245202026-09-21T10:51:04ZTheresa—Knight1975-05-06NULLN/A—null7122 Mountain View DriveTampa··FL33697UNKNOWNMEDICARE-ADV-B
CLMCLM-4017062026-07-12T12:04:20ZLinda—Weaver09/12/1977—•••-••-4279-UNKNOWN4204 Washington StreetTempeAZ85227nullSELECT-EPO
CLMCLM-4194602026-03-11T01:52:13ZDiego—Ramirez1975-02-21UHC-57245-41-null—5394 Grand AvenueJacksonvilleFL32247nullnull
32,829 rows, page 88 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.760Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty