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-4169872026-05-31T11:19:32ZDiane—Maldonado1965-07-17UHC-17511-15··---8807 BROADWAYMinneapolisMNnullGRP-2700UNKNOWN
CLMCLM-4258662026-05-20T09:29:32ZRoer—Gordon04/10/45N/A•••-••-7102—roger.gordon70@yahoo.com3536 Grand AveDenverCO80260N/A·-
CLMCLM-4149822026-06-10T15:46:29Zmark··—olsonNov 28, 1966UHC-48831-04•••-••-6288364-355-0082····——·N/AUNKNOWNGRP-8177OPTIONS-PPO
CLMCLM-4274252026-08-23T20:53:20ZBradley—Elliott03/20/81—N/A—-8883 MESA DRTucsonArizona85737GRP-4039UNKNOWN
CLMCLM-4145732026-10-10T02:49:10ZTyler··—Lawson24-04-1985UHC-01679-18•••-••-19585897583351-·8511 Lake View RdTempeAZ85213GRP-0637N/A
CLMCLM-4192782026-08-26T18:58:24Zmason—cunningham1994-06-09··UHC-61288-67-7495032429·MASON.CUNNINGHAM@AOL.COM5701 Apache BlvdSan DiegoCA———
CLMCLM-4125492026-01-30T05:35:05Zrachel—coleman10/19/49UHC-34040-77NULLNULLrachel.coleman@yahoo.com935 Meadow LnAtlantaGA30376GRP-3693OPTIONS-PPO
CLMCLM-4279452026-02-18T17:15:33ZNICHOLAS—GARCIA11/11/1964UNKNOWNnullnull--—····GRP-1861CHOICE-PLUS-PPO··
CLMCLM-4256052026-04-06T06:19:16ZLauren—Wang1963-08-19—•••-••-9640889.625.1698null6246 Park PlNashvilleTN37252GRP-3932—
CLMCLM-4043832026-02-07T15:54:56ZARTHUR—MEYER06-07-1985——-—1047 Mountain View DriveHoustonTX77050GRP-5859—
CLMCLM-4286302026-05-10T22:32:36ZEthan—Chavez1951-07-01UHC-43527-12•••-••-8957511-831-7688ethan.chavez46@yahoo.com2576 Central AvenueTempeAZNULLGRP-7313core-hmo
CLMCLM-4290352026-06-10T23:56:07ZEmily—Nichols1955-03-08UHC-42390-85N/A(962) 202-2755null·9636 UNION STScottsdaleAZ85257-··SELECT-EPO
CLMCLM-4045592026-01-11T08:43:44ZDavid—Daniels25-05-2001NULL-NULL—9352 Maple Avenue Apt 6HoustonTX77043—N/A
CLMCLM-4219092026-01-05T00:12:16ZTYLER—MORRIS1966-01-12UHC-22612-53—N/AUNKNOWN133 Washington St Apt 22··AtlantaGA30300·GRP-6533NAVIGATE-HMO
CLMCLM-4269052026-05-31T15:46:55ZDouglas—Gray08/04/1992UHC-82303-97•••-••-8063NULL··—UNKNOWNUNKNOWNUNKNOWNNULLGRP-4079medicare-adv-a
CLMCLM-4231002026-02-25T10:25:45ZARTHUR—JIMENEZ2001-02-01UHC-75581-43—4303301ARTHUR.JIMENEZ@ICLOUD.COM4586 Lake View RoadEden PrairieMN55342GRP-6662·NAVIGATE-HMO
CLMCLM-4076432026-03-08T18:07:47ZFrank—Tran1951-05-03UHC-06995-33N/A688-303-8399—null-——GRP-0565SELECT-EPO
CLMCLM-4097802026-05-19T14:01:41ZAshley—Lopez1944-08-15·UHC-75234-83NULL(693) 406-1650N/A—N/A··—·NULLMEDICARE-ADV-A
CLMCLM-4140832026-10-01T21:05:41ZPorter, Joseph······1960-06-27UHC-81468-86•••-••-0395237-551-0773—6037 Sage CtGilbertAZ85238NULLOPTIONS-PPO
CLMCLM-4259502026-07-12T07:18:10ZVirginia—DominguezDec 21, 1971UHC0883940-(565) 712-9087——NULL-nullNULL—
CLMCLM-4029572026-04-23T18:05:23ZGABRIEL—MCDONALD·1947-11-21UHC-21533-16N/A18713805476-8474 Desert Sky BoulevardPLANOTX75012nullnull
CLMCLM-4120282026-02-11T08:15:53Zgrace—hughes19630621UHC-49736-31UNKNOWNNULLN/A2697 Cedar LaneHoustonTX77036GRP-4105SELECT-EPO
CLMCLM-4198692026-02-02T21:30:23ZSoiaXKelely1956-01-22UHC1103493•••-••-3670—null7324 SAGE CTTampaFL33614GRP-4000—
CLMCLM-4091692026-01-04T07:18:23ZSOPHIA—PATTERSON1968-12-23UHC-89679-38·N/AUNKNOWNSOPHIA.PATTERSON13@ICLOUD.COM6635 Church St·JacksonvilleFL32284GRP-7047UNKNOWN
CLMCLM-430482 2026-03-30T11:49:48ZGeorgeSNelson1941-04-27UHC-72655-13··NULL+1 563 654 4348—9584 DESERT SKY BOULEVARDFresno·CA93700-0219GRP-2559N/A
CLMCLM-4146342026-04-11T03:43:21ZREBECCA—BENNNETT27-04-1948UHC2127489•••-••-8940829-741-8145-5990 CAMELBACK RDGilbertAZ85268GRP-3414OPTIONS-PPO
CLMCLM-4005172026-02-15T02:08:26Z·Evelyn—Rodriguz1946-12-04UHC-93535-65—(915) 651-1326NULL44 Palm DriveAUSTINTexas78767GRP-2226CORE-HMO
CLMCLM-4099012026-05-18T23:07:15ZSCOTTSHART1962-04-02UNKNOWN•••-••-90454126057459N/A7942 Oak StMIAMIFL··33100-6412-N/A
CLMCLM-4127802026-05-05T14:53:39ZBETTYCLEWIS1942-08-12UHC-43209-07—2479039522—N/AN/A-—-SELECT-EPO
CLMCLM-4164092026-08-10T20:36:24Z Arjun—Roertson1980-11-11UHC-87084-84UNKNOWN(411) 221-2069arjun.robertson@hotmail.com4498 Washington StreetJacksonvilleFL32242GRP-5962MEDICARE-ADV-A
CLMCLM-4011252026-07-19T05:58:45ZJORDAN—WELCH13-11-2001·UHC-43144-83N/Anull—2704 Maple Avenue #582Denver··CO80226-2567··GRP-2357CORE-HMO
CLMCLM-4033592026-07-30T23:41:47ZJose—Dixon1981-03-27NULL•••-••-0073(452) 778-3899jose.dixon54@gmail.com8241 Sage CtTampaFL33627GRP-4797MEDICARE-ADV-B
CLM CLM-4136892026-08-05T06:16:29ZAnthony—Palmer1953-06-21UNKNOWN•••-••-4670-—867 Elm StreetFresnoCA93755GRP-2785CORE-HMO
CLMCLM-4005832026-08-22T19:53:52ZISABELLA—HERRERA1994-01-06UHC-23502-35—8694120707ISABELLA.HERRERA@AOL.COM3105 Highland AveSAN ANTONIOTX78207UNKNOWNSELECT-EPO
CLMCLM-4285862026-05-17T18:30:23ZARJUN—GONZALEZ1947-02-08UHC-75702-24•••-••-4311N/A—3951 Park PlATLANTAGeorgia30369NULLNAVIGATE-HMO
CLMCLM-4033232026-01-14T10:03:38ZLUIS—LUCAS1984-02-03-UNKNOWNUNKNOWNNULL972 Maple Ave··SCOTTSDALEAZ85240GRP-8151UNKNOWN
CLMCLM-4102732026-05-01T00:08:29ZMark—Owens·UNKNOWNUHC-97198-67—862.757.8283—6488 Cedar LnFresnoca··93780-—
CLMCLM-4290692026-02-20T03:55:07ZcatherineI.sanchez··06/08/2004UHC-09685-12NULL13179904730··UNKNOWN9542 Mountain View DriveCharlotte·North Carolina28231GRP-1777··SELECT-EPO
CLMCLM-4222892026-08-19T22:29:15ZDanielle—Kennedy1951-09-09··UHC-96120-70•••-••-3821(715) 594-7020—3051 Camelback RoadTampaFL33601-8409UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4229652026-01-11T09:04:27ZEDWARD—SCHULTZ1981-08-11UHC-56577-84•••-••-4704N/A-NULL··UNKNOWNnullUNKNOWN—
CLMCLM-4242602026-07-11T07:55:36ZShaorn—Nunez··19530424-•••-••-0903null—7758 WILLOW COURT··Las Vegas··NV89184GRP-1894null
CLMCLM-4022592026-07-22T23:47:09ZAndrea—Gonzales1995-10-14N/Anull··17945796537ANDREA.GONZALES@ICLOUD.COM6530 Lake View Rd Apt 32San DiegoCA92149GRP-7602MEDICARE-ADV-A
CLMCLM-4280422026-01-09T13:02:48ZAUSTIN··SANTOS6/9/1978UNKNOWN—(788) 337-1383··—457 OAK STREETChandlerAZ85237N/ACORE-HMO··
CLMCLM-4101152026-02-26T14:16:34ZTHOMAS—ARNOLD1982-09-17UHC-19975-43·N/A(358) 710-8822N/A··6875 LAKE VIEW RDDenver·co80261GRP-9436UNKNOWN
CLMCLM-4123682026-06-01T09:16:13Zhenry—·gomez1957-07-16UHC-44840-46··516-593-2301··—8724 Bayshore Dr··ScottsdaleAZ85211-8380GRP-2668MEDICARE-ADV-A
CLMCLM-4310392026-08-02T03:12:00ZortegaNmadison08/14/2006—•••-••-0577608.708.8136N/A689 Lincoln WaySan AntonioTX·78232-7570GRP-1324MEDICARE-ADV-B
CLMCLM-4130962026-07-07T06:45:30ZJoe—Rjoas12/20/48UHC-74508-69—657-206-3343N/AN/A-———N/A
CLMCLM-4000842026-03-04T08:24:30ZNancy B—Morrison··May 15, 1972UHC-87778-78NULL+1 598 516 4419UNKNOWN6308 Palm DriveSEATTLEWA98144GRP-8495CHOICE-PLUS-PPO
CLM CLM-4171862026-02-11T10:38:21Z JULIA—JACKSON··Sep 26, 2004N/A—947.417.6512··N/AN/AN/ANULLGRP-1908N/A
CLMCLM-4231692026-05-25T22:14:08Z·BrandonB.Long11/17/63UHC4992734NULL··nullnull6600 Ocean AvenueTampaFL33649GRP-4692NAVIGATE-HMO
32,829 rows, page 146 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:40.330Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty