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-4282402026-03-23T21:25:40ZLuis—Torres1984-02-24·UHC-13129-49—978-383-5591UNKNOWN5075 River RdMIAMIFL33138—N/A
TPATPA-570732026-09-21T14:05:29Z ·Evelyn····Elliott1949-01-12null•••-••-7524null-5279 Pine DrHoustonTX77046·GRP-4086MEDICARE-ADV-B
TPATPA-64305 2026-02-26T18:37:03ZTERESAA··ROBERTS19551112N/ANULL5032847223-7920 Main StreetGlendale··AZ85321GRP-2391-
TPATPA-567252026-09-17T13:51:16ZAmy—Lawrence·2003-09-23UNKNOWNUNKNOWNNULL·UNKNOWN2012 MOUNTAIN VIEW DRIVE Apt 20DenverCO80247-1537GRP-6488CORE-HMO
ENRENR-1137612026-07-09T18:00:03ZDebraSAlvarez1979-06-25UHC-54280-04—8698753debra.alvarez@yahoo.com2061 Broadway··Eden Prairie·MN55376GRP-5995NAVIGATE-HMO
CLMCLM-4110122026-07-17T14:09:48ZGLORIA—GODON09/04/1952UHC-34684-56•••-••-735113825752341-9544 CAMELBACK ROADOrlandoFlorida32849GRP-2682CHOICE-PLUS-PPO
ENRENR-126540 2026-03-04T00:26:57ZSCOTTPHUGHES··1958-01-10UHC-53716-26N/A821.748.5157SCOTT.HUGHES1@GMAIL.COM5069 Lincoln Way #614OrlandoFL32854-1643GRP-8068OPTIONS-PPO
PRVPRV-262902026-07-26T00:02:26Zabbby—cunningham1938-09-28UNKNOWN•••-••-6999(877) 295-3074—4046 Oak StreetTAMPAFL33663—null··
ENRENR-1300392026-06-27T11:33:02ZMei—Scott1958-03-16UHC-55509-56•••-••-1205·687.532.7152mei.scott@outlook.com3062 Forest AveFresnoCA93708GRP-4727MEDICARE-ADV-A
PRVPRV-204622026-05-12T02:42:07ZNatalieJSimpson1940-11-11UHC-12051-83··UNKNOWN4947090529NATALIE.SIMPSON40@YAHOO.COM4332 MAPLE AVEJacksonvilleFLUNKNOWN—NULL
TPATPA-641412026-01-30T06:22:35ZJackie····Mitchell1952-08-19—•••-••-24079025108443null4556 Grand AvenueATLANTAGA30384—-
ENRENR-1267202026-03-23T14:32:50Zjoyce··li1940-05-15UHC-63707-36•••-••-1742·4346759024null6266 River RoadATLANTAGA30365GRP-5557CHOICE-PLUS-PPO
ENRENR-1198322026-04-30T20:38:24ZDIANASRUSSELL1941-12-27UHC-00530-80•••-••-54108985095934diana.russell@hotmail.com··6622 Mesa DriveLas VegasNV89164··GRP-3581CORE-HMO
PRVPRV-232802026-07-02T00:09:33Z·CharlesCBryant1969-02-06·UHC-01319-03N/A4216140249NULL5690 Lincoln WaySACRAMENTOCA95838-7081-N/A
TPATPA-584782026-07-09T04:37:52ZLane, Jeffrey——1941-09-24null-—UNKNOWN3740 Mesa DriveTUCSONaz85791N/A—
ENRENR-1308612026-03-13T11:44:04ZEric—Clark·1981-10-28UHC-57722-74··•••-••-5745466-751-0817NULL·4753 Highland AvenueSan AntonioTX78213GRP-1689MEDICARE-ADV-A
ENRENR-1204782026-07-28T00:01:44ZKathrynT.Dunn2003-01-17UHC-91234-39•••-••-2054758-932-5966KATHRYN.DUNN@GMAIL.COM6922 Park PlDenverCO80261GRP-7919options-ppo
CLMCLM-4124522026-05-07T12:05:08ZBenjamin—·Robinson2006-11-02UHC-34560-42•••-••-8985+1 286 618 5207—5706 Church StScottsdaleAZ85295N/ANULL
TPATPA-617832026-02-14T22:10:31ZBenjaminC.—1969-07-01-—4645659812·UNKNOWN8814 PARK PLACENashvilletn·N/A—UNKNOWN··
ENR ENR-1171512026-05-29T09:23:02ZPATRICK—PEREZ05/24/75UHC-74189-68•••-••-0456(487) 557-1896N/A6266 CEDAR LNGilbertAZNULLGRP-0468OPTIONS-PPO··
CLMCLM-4103172026-01-03T14:50:53ZKimberlyH.Dixon·1998-09-20UHC-91029-41—14928315701-7851 Oak StreetScottsdaleAZ85254UNKNOWNCHOICE-PLUS-PPO
ENRENR-1300472026-08-25T18:59:26ZFisher, KathyJ—1940-06-22UHC7626513··•••-••-21664052561273KATHLEEN.FISHER@GMAIL.COM8461 HARBOR BLVDSan DiegoCalifornia··92108GRP-0660CORE-HMO
TPATPA-590292026-06-27T03:58:13ZFRANK—BURTON1964-11-25NULL•••-••-2651582-691-0621—7178 Indian School RoadMinneapolisMN55493—UNKNOWN
CLMCLM-4215262026-03-26T13:18:29ZHelen··—Reid28-11-2005uhc-88997-72•••-••-3950(759) 740-1091—463 CEDAR LANE··MesaAZ85254-CORE-HMO
CLMCLM-4141052026-04-21T11:16:26ZISABELLA—LYNCH1998-01-28UNKNOWNnull—UNKNOWN—null·nullNULL··GRP-1014MEDICARE-ADV-B
ENRENR-1400962026-09-18T02:24:07ZRicard—Stevens1990-10-09—•••-••-0940+1 810 577 5724richard.stevens@outlook.com526 Apache BoulevardColumbusOH43274··GRP-4419SELECT-EPO
ENRENR-1076162026-04-15T11:11:46ZNathanKMoore2000-08-01UHC-49058-08•••-••-5828(827) 231-8244nathan.moore@hotmail.comnullUNKNOWN——GRP-6645MEDICARE-ADV-A
CLMCLM-4095742026-07-06T00:02:38Z·HeatherTWelch04/06/1979-—(208) 201-9606—4656 Pine DrFresno··CA93790GRP-0795MEDICARE-ADV-B
CLMCLM-413257 2026-08-06T13:11:33Zjames—owens1980-03-02UHC4611034•••-••-0729NULL····6467 Camelback RoadPlanoTexas75086GRP-3418OPTIONS-PPO
ENRENR-1021052026-08-30T18:31:27ZAndrew··XWillis1947-09-04UHC-40816-30•••-••-3461·201.529.1568ANDREW.WILLIS84@HOTMAIL.COM777 Willow CtEDEN PRAIRIEMN55337GRP-2988NAVIGATE-HMO
CLMCLM-4103972026-08-08T05:47:42ZPhilipA··Wood1946-02-19··UHC-74863-07N/A8772941398UNKNOWN3849 Highland AveMESA·AZUNKNOWNUNKNOWNN/A··
PRVPRV-235482026-06-18T21:13:07ZSharonZDavis1962-12-16nullUNKNOWN—sharon.davis@proton.me5576 Highland AvenueFresnoCA93750UNKNOWNN/A
CLMCLM-4250172026-02-12T00:32:37ZJulia—Wright15-05-1995UHC-22171-70———5217 Main StreetDallas··TX75241——
CLMCLM-4136922026-01-01T13:22:54ZDianeH.West··1996-07-02UHC-87387-07NULLNULL—9757 Ridge RoadCharlotteNC28285GRP-4511MEDICARE-ADV-A
TPATPA-546802026-09-29T12:03:04ZKing, Carolyn——19570713——893-626-5186N/A2064 Park PlaceSan AntonioTX··78271N/ANULL
TPATPA-579372026-05-24T18:32:47ZCamila—Ryan1986-10-28——5473255537···UNKNOWN····UNKNOWN—UNKNOWNNULL
ENRENR-1155612026-09-20T00:41:13ZMorales, VicotriaW—1951-10-05UHC-18505-75•••-••-77428644412460victoria.morales37@icloud.com7253 Spring StreetSacramentoCA95897GRP-1103SELECT-EPO
CLMCLM-4055122026-05-19T04:21:00Zkathryn—lawson1941-09-02—•••-••-9284—N/A6143 Washington St·San AntonioTX78274GRP-9399NULL
CLMCLM-4154322026-07-04T22:54:47Zelizabeth—brown1971-01-24UHC-66461-69•••-••-1952·N/AN/A2433 Lincoln WayOrlandoFL32884GRP-5854NULL
CLMCLM-4029762026-03-18T23:16:30ZPhilip—Le1983-04-22UHC-39834-94•••-••-8011(753) 486-3035—3707 Union Street··JacksonvilleFL32202-6437null-
CLMCLM-4237952026-05-20T18:24:14ZSamantha—Reid·1977-02-22UHC-39955-17null6452977729N/A2709 HARBOR BOULEVARDOrlando··FL32874GRP-8276··—
CLMCLM-4327872026-01-17T12:51:51ZDEBORAH N—ROSE02/05/1955—•••-••-9086null—9124 BASELINE RDSan DiegoCalifornia92136GRP-3191MEDICARE-ADV-B··
PRVPRV-209102026-05-18T20:10:59ZChristian—Lawson1975-02-12——null-3874 Jefferson AvenueCHANDLERAZ85235··NULL
CLMCLM-4068512026-08-12T15:35:43Z·DiegoHGonzales1982-30-26UHC-87150-98•••-••-2343——3904 Market StMinneapolisMN55408GRP-7605—
TPATPA-607242026-01-20T13:46:44ZReed, Amber——08-04-1938—NULL——715 Valley View DriveMiamiFL33183—CORE-HMO
PRVPRV-294932026-02-16T23:36:53ZNunez, Sara··—1940-06-09UHC-01441-42-891.719.8125sara.nunez@proton.me··3337 MARKET STREETLos AngelesCA·90049null—
CLMCLM-4117532026-02-19T20:48:57ZEMILYBTHOMPSON02/27/1964uhc-60492-22N/Anull—7291 Mesa DrCharlotteNC··28216GRP-0562SELECT-EPO
PRVPRV-219502026-07-26T12:12:38ZCollins, Danielle—··Oct 27, 1983nullUNKNOWN482-488-4280N/A2407 Park Pl·TampaFlorida33610UNKNOWNCHOICE-PLUS-PPO
ENRENR-1145922026-01-11T10:30:15ZdorothyY.wang1947-05-08UHC-35536-05•••-••-5631634.948.9563dorothy.wang@hotmail.com2326 Grand AvenueMesaArizona85220GRP-7025CHOICE-PLUS-PPO
ENRENR-1354672026-04-26T19:35:05ZBRIAN··ZHARRISON1988-07-14··UHC-75575-46•••-••-0229463-415-2441brian.harrison@proton.me7055 Canyon RdSan DiegoCA92144GRP-6698NAVIGATE-HMO
100,000 rows, page 234 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:37.739Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty