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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4098802026-05-13T15:18:54ZBRUCE—ALVAREZ1981-05-04UHC-31238-59N/A242-583-6681—····nullNULLN/AGRP-6343null
CLMCLM-4002322026-03-12T01:58:46ZAustin—Stone··1949-11-17—•••-••-5740·462.553.0574—4169 JEFFERSON AVENUEChandlerAZ85252——
CLMCLM-4019332026-06-06T05:05:35Zkyle—guzman1996-03-24UHC-29349-66•••-••-7159N/A—9740 Valley View DrDenverCO80268··GRP-9547—
CLMCLM-406898 2026-09-06T07:18:36ZBARBARA—HANSON1953-04-02UHC-41769-76···368-536-7118—4855 Willow CtAustinTX—GRP-1211—
TPATPA-518802026-07-22T07:56:22ZGARALD—ROBERTSON2008-01-73N/A•••-••-2732617-513-8326-4482 Grand Ave #370·San AntonioTX78251··CORE-HMO
CLMCLM-4247212026-05-08T04:53:38ZJoan—Weber1940-06-07UHC-41593-57null—joan.weber@outlook.com2151 Canyon RdLos AngelesCA90083GRP-5854····
TPATPA-567802026-01-20T11:31:09ZJose—Reyes1942-06-27UHC-54323-16•••-••-81137698933572···jose.reyes@outlook.com·5287 Valley View DriveCharlotteNC28250-7925null—
ENRENR-1088232026-05-17T08:10:28ZSophiaAMoreno1956-07-12UHC-86550-84•••-••-4392206.449.2736sophia.moreno78@gmail.com1282 Highland AvenueSan AntonioTX78218GRP-9461SELECT-EPO··
ENRENR-1417202026-01-08T18:56:57ZJudyYBanks10/25/1995UHC-08571-74•••-••-2447979.598.7629NULL6291 Canyon RoadTEMPEAZ85204··GRP-4708MEDICARE-ADV-B
ENRENR-1166022026-03-27T11:27:17ZSanders, AndreaT—3/15/1976UHC-23556-43•••-••-1663875-661-3660ANDREA.SANDERS@GMAIL.COM6103 Market StreetColumbusOHnullGRP-4130CORE-HMO
CLMCLM-4051612026-06-15T13:16:07ZGeorge—Franklin·06/09/64UHC-98768-47•••-••-7913587-368-4956—4658 Indian School RdSan DiegoCANULLnull—
ENRENR-1368622026-06-28T01:56:19ZBRIANELOPEZ2005-07-12··UHC-17499-77•••-••-573413882757688··N/A2763 Broadway·San AntonioTX78230GRP-5489CHOICE-PLUS-PPO
CLMCLM-4023792026-01-08T19:57:47Z julia—bailey1954-05-06UHC-66212-73——-9691 Church StreetCharlotteNC28251-1008N/Anull
PRVPRV-286602026-07-09T07:34:41ZSTEVENS—ZACHARY1983-11-03··——249-730-5113null6105 Park PlaceChandlerAZ85270··CORE-HMO
CLMCLM-4204202026-06-08T16:28:58ZBruce—Davis1963-02-04·UHC-59299-76—UNKNOWN·UNKNOWN7325 WILLOW COURTHoustonTX77081-6917nullN/A
ENRENR-1295312026-08-12T16:27:44Z MARI—LOPEZ4/8/1945UHC-24953-26•••-••-35865884467083—3303 Forest AveJACKSONVILLEFL32243GRP-6800NAVIGATE-HMO
CLMCLM-4016342026-07-10T03:47:43ZAUSTIN—TORRES1970-06-15—-(324) 360-2250————-GRP-8389N/A
ENRENR-1402052026-09-10T08:17:07Z—J··—1977-08-17UHC-77280-77—12502990466barbara.stevens71@gmail.com720 Main Street Apt 36Las VegasNVUNKNOWN·GRP-2370OPTIONS-PPO
ENRENR-1113242026-09-09T12:35:57Z·DENNISK.ALVAREZ2004-04-22UHC-68394-96•••-••-33345332054449dennis.alvarez57@icloud.com·8893 Maple AveTEMPEaz-GRP-4055CORE-HMO
CLMCLM-4237132026-09-27T01:21:31Z·Steven—Carroll1948-01-03uhc-89841-95—UNKNOWN—7881 HIGHLAND AVEHOUSTON··TX77080GRP-4014—
ENRENR-121500 2026-05-16T10:18:35ZJesse—Greene·1958-03-12UHC-31276-72—(565) 900-7605JESSE.GREENE19@AOL.COM9216 HILLCREST RDLos AngelesCA90033GRP-6277SELECT-EPO
TPATPA-502732026-04-29T01:35:29ZLawwrence, Jacqueline——2007-06-11-•••-••-3590(524) 800-2302null8326 Desert Sky BoulevardEden PrairieMN··55300UNKNOWNMEDICARE-ADV-A
ENRENR-1399002026-09-18T09:18:06ZRuthYHowell08-04-1993UHC-92035-70•••-••-38338133701157RUTH.HOWELL35@YAHOO.COM4721 UNION STMiamiFL33104GRP-1683CORE-HMO
ENR ENR-1382072026-09-26T10:49:44ZFatimaZPayne1984-11-02UHC-28122-89—N/AFATIMA.PAYNE95@PROTON.ME5792 FOREST AVECharlottenc28231GRP-7225CHOICE-PLUS-PPO
ENRENR-1339732026-04-18T19:47:43ZROBERT—HILL-UHC-09753-41•••-••-73412396511620robert.hill57@outlook.com1360 Mountain View DriveSan DiegoCANULLGRP-5716MEDICARE-ADV-B
CLMCLM-4030922026-08-24T18:51:41ZKimberly··—Tran1951-09-18··UHC-62232-76•••-••-9589543.779.3939null6364 BAYSHORE DRIVEEden PrairieMN55385N/A—
ENRENR-1149682026-03-05T10:06:02ZSufiaU.Moore12/14/61UHC-86635-12··•••-••-27833172149SOFIA.MOORE@YAHOO.COM··5368 Ridge RdCOLUMBUSOH43203GRP-4033NAVIGATE-HMO
PRVPRV-223452026-07-21T08:01:46ZJEREMY—REYES1793-02-03UHC8737254null(930) 513-1662jeremy.reyes55@yahoo.com—-——N/A—
ENRENR-1025982026-04-10T05:02:14Z GeorgeKLawrence2008-06-13UHC-88302-44•••-••-52864616707620george.lawrence@proton.me3807 Market StreetDenverCO80287GRP-4472MEDICARE-ADV-B
ENRENR-1301382026-01-14T03:01:51ZKyleKSmith1983-12-42UHC-64566-52•••-••-44936344357057KYLE.SMITH@AOL.COM1315 PARK PL·SAN DIEGOCA—GRP-3205SELECT-EPO
CLMCLM-4187772026-10-10T09:11:09Zrichard—hicks·15-02-1987NULLNULL——6440 River Road Apt 15Eden PrairieMN55321UNKNOWN—
CLMCLM-4167402026-03-28T05:42:47Z JASSE—SHAW1948-02-21NULL•••-••-8180·710.712.6433jesse.shaw@outlook.comUNKNOWN———-CHOICE-PLUS-PPO
TPATPA-603572026-08-26T20:44:44ZDIANE—PATEL19481001··N/AUNKNOWN-null8529 Mountain View DriveAustinTX78779——
CLMCLM-4133792026-10-15T09:22:55ZLUIS—PETERS2000-12-01UHC-99143-52NULL229.696.0258—4568 CEDAR LANEAustinTX78737-5938GRP-6989CHOICE-PLUS-PPO
CLMCLM-4176842026-06-25T12:29:29ZAmy····Evans1967-05-21N/A•••-••-3159——6124 Hillcrest RoadORLANDOFL·32885NULL—
ENRENR-1100942026-02-10T00:04:05ZArthur D.—Espinoza2003-07-16UHC-87366-53•••-••-546814533570846ARTHUR.ESPINOZA@HOTMAIL.COM9292 INDIAN SCHOOL RDTampaFL33690GRP-7153core-hmo
ENRENR-1396042026-01-31T00:01:07ZNANCYB.GIBLERT1976-03-20UHC-28256-04•••-••-3546899.795.4621··—4914 FOREST AVENUESan AntonioTX78206GRP-3492CHOICE-PLUS-PPO
PRVPRV-263262026-03-16T04:53:56ZCAROL···MASON1947-06-16uhc-05630-68•••-••-3752+1 415 860 4155NULL1548 Grand Avenue Apt 38Los AngelesCANULLnull—
ENRENR-1367722026-04-13T07:28:56ZAustinB·Santos1978-06-09UHC-34443-43•••-••-517417883371383austin.santos@proton.me457 Oak StCHANDLERAZ85237GRP-7570CORE-HMO
ENRENR-1193252026-06-18T22:17:41ZEvelyn—Burns1991-10-17UHC-64453-70•••-••-7600728-471-9453evelyn.burns@aol.com4461 Spring StTampaFL33671GRP-1619OPTIONS-PPO
ENRENR-1256822026-08-15T23:03:13ZMason—Bowman1979-05-22UHC0706633•••-••-8270441-748-6036mason.bowman15@aol.com5011 Spring StFresnoCA93724GRP-1210NAVIGATE-HMO
ENRENR-1213002026-05-24T08:14:07ZsaraJbrooks4/4/2002UHC0787318•••-••-2697(377) 330-2252sara.brooks13@icloud.com9616 CAMELBACK RDSacramentoCA95805-4149GRP-1980MEDICARE-ADV-A
PRVPRV-266032026-07-04T15:43:17Z·Matthew—Hoffman1995-04-23UHC-49069-01—290-373-3827··matthew.hoffman59@outlook.com3568 Church StGILBERTArizona85231N/AUNKNOWN
TPATPA-556122026-03-04T13:14:56ZSusanX.Cunningham05/03/1972····UNKNOWNN/Asusan.cunningham5@aol.com1351 Baseline RdGilbert·AZ85266····UNKNOWN
PRVPRV-227182026-03-17T07:25:00ZJuan—Hoffman2000-10-05UHC-66382-01•••-••-1699304-304-3551juan.hoffman31@aol.com2964 Desert Sky BoulevardDENVERCO80240NULLN/A
PRVPRV-293492026-08-18T17:02:38ZStephanie—Elliott1957-09-15NULL•••-••-84623688106511STEPHANIE.ELLIOTT@HOTMAIL.COM2713 BAYSHORE DRIVEGilbertAZ·85252-NULL
ENR ENR-1399312026-06-04T03:35:45ZKyleZLe20801024UHC-49171-75•••-••-1986UNKNOWN-3289 Church StreetEDEN PRAIRIE·MN55370-4112GRP-2950CHOICE-PLUS-PPO
CLMCLM-4111122026-08-16T15:52:47ZAlbert T—Burton1982-06-17UHC-66153-74null586-360-7460N/A9508 Mesa DrDenverCO80277·GRP-9191—
ENRENR-1387172026-03-10T15:35:21ZALEXANDERT.BELL··1997-08-11UHC-79353-51•••-••-6384·6796961131alexander.bell@gmail.com5591 LAKE VIEW ROADAUSTINTX78745GRP-1286CHOICE-PLUS-PPO
ENRENR-1403262026-05-17T09:05:08ZAhmedACooper3/8/1942UHC-91936-31•••-••-24497284113ahmed.cooper62@icloud.com8482 Valley View DrLos AngelesCA90028GRP-3768SELECT-EPO··
100,000 rows, page 134 of 2,000PreviousNext

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