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
TPATPA-580242026-05-08T22:40:58ZGerald—Henderson1955-08-11—•••-••-9396—null7915 FOREST AVENUEGilbertAZ85218—SELECT-EPO
ENRENR-1171402026-01-06T22:49:27ZJOHK.STONE1977-08-07UHC-36434-33null741.529.3754joshua.stone@outlook.com9296 Jefferson AvenuePlanoTX75096·GRP-8398CHOICE-PLUS-PPO
CLMCLM-4320152026-06-13T05:46:51ZRoy—Stewart1964-06-18nullNULL—nullUNKNOWN—UNKNOWN-GRP-8942null
ENRENR-1226502026-03-10T09:18:25ZAmber··Harvey1998-10-18··UHC-45573-36null(726) 625-6662amber.harvey89@icloud.com6154 Main StreetDallasTX75275GRP-3706CHOICE-PLUS-PPO
ENR ENR-1332042026-03-24T05:27:54Zhelne··ramos1943-01-10·UHC-91611-30•••-••-5270—HELEN.RAMOS11@PROTON.ME6117 WILLOW CT·San AntonioTX78206GRP-0198MEDICARE-ADV-A
ENRENR-1013232026-08-31T06:34:38ZLuisB··Fernandez2003-04-11uhc-36488-55•••-••-6637566.468.8349luis.fernandez77@proton.me604 Lake View RoadScottsdaleAZUNKNOWNGRP-3587NAVIGATE-HMO
TPATPA-616212026-09-04T04:37:27ZGerald—Harrison1965-08-14UNKNOWNN/A——6815 Market StMIAMIFlorida33190GRP-8194MEDICARE-ADV-B
CLMCLM-4279012026-09-07T00:27:32ZLarson—Keith1994-01-19-—2916371340null6408 Lincoln WayLos AngelesCA90046NULLMEDICARE-ADV-A
PRVPRV-235152026-03-12T15:37:46ZBRYAN—FLORES1970-04-28UHC-43147-53•••-••-5719+1 846 451 8193N/A8493 Market StSan AntonioTX78273N/Anull
ENRENR-1309232026-06-20T03:54:38Z·CAROL—FRANKLIN1938-04-22UHC-98866-30•••-••-8820224.530.7140CAROL.FRANKLIN@AOL.COM··8103 UNION STTempeAZ85292GRP-9650NAVIGATE-HMO
PRVPRV-221472026-03-28T00:29:13Zbob—garrett1963-04-16—nullN/A·-6221 Canyon RdMesaAZ85219N/A—
ENRENR-1293842026-01-13T18:09:39ZAlexander—Collins1980-05-24UHC-69267-58•••-••-4139(825) 393-6353ALEXANDER.COLLINS91@HOTMAIL.COM6735 Hillcrest RdJacksonvilleFL32263GRP-2393MEDICARE-ADV-A
ENRENR-1360852026-09-29T05:18:31ZMARGARETUBUTLER1944-11-25UHC-48996-47•••-••-9179491-202-8951margaret.butler@aol.com741 Canyon Rd·MinneapolisMinnesota·55427GRP-6140MEDICARE-ADV-B
CLMCLM-4031882026-04-30T10:53:06Zhannah—sms6/23/1982UHC-67968-01nullnullhannah.sims@yahoo.comUNKNOWN—nullNULLGRP-6476N/A
CLMCLM-4135192026-03-10T00:43:57ZRichardR.Boyd2001-08-07—•••-••-67529136960693—1939 Willow CtAustinTX78742-4793GRP-1434NULL
TPATPA-620902026-01-30T04:27:41ZLuriI·Armstrong1939-08-17—null(240) 225-1345··lori.armstrong39@hotmail.com319 River RoadCharlotteNC28225null·null
CLM CLM-4156022026-06-29T06:34:06ZJACQUELINEZGONZALES··1997-03-13UHC-44443-96nullNULLjacqueline.gonzales@outlook.com5010 Cedar LnMesaaz85226-OPTIONS-PPO
CLMCLM-4126032026-05-10T17:31:12ZLORI—CMAPBELL19800113UHC-28401-72null(554) 439-7034-231 BROADWAY·FRESNOCA93734N/AUNKNOWN
CLMCLM-4137262026-01-31T22:19:31ZALEXIIS—STEPHENS1946-11-14UHC-11918-64··——N/A7276 Harbor BoulevardDenverCO··80295··UNKNOWN··OPTIONS-PPO
ENRENR-1046462026-03-04T18:39:48ZdennisH···larson1965-09-05uhc-54035-72•••-••-38105948665211DENNIS.LARSON24@GMAIL.COM290 Camelback RoadCharlotteNC28272GRP-9820SELECT-EPO
CLMCLM-4135792026-09-15T14:41:27ZChristine····Elliott2/25/1998UHC-73005-64UNKNOWN—NULL——nullNULL—-
ENRENR-1087382026-06-25T06:50:08Zbarbara····valdez1962-04-05UHC-84229-95•••-••-14514492352839barbara.valdez@yahoo.com2787 Church StHoustonTX77031·GRP-6661SELECT-EPO
ENR ENR-126767 2026-05-11T01:37:01ZDONNA—GREENE1989-01-17UHC-31782-23•••-••-16408568609815—5500 Hillcrest RoadSan DiegoCA92179GRP-7933·MEDICARE-ADV-A
CLMCLM-4134392026-03-10T18:32:38ZBruce—Garza1971-02-23UHC-63823-65—-NULL2756 Ocean AvenueMIAMI··FL33113GRP-7187UNKNOWN
ENRENR-1297662026-05-27T07:11:00ZRay, Mateo——2006-10-13UHC-28724-21•••-••-28897469574791mateo.ray26@hotmail.com3661 Indian School RdLas VegasNV89156·GRP-1185MEDICARE-ADV-B
ENRENR-1284582026-03-22T17:00:58ZPhilip—Andrews1970-08-06UHC-75817-58•••-••-3885+1 980 389 8782philip.andrews@yahoo.com5061 Elm StNashvilleTN37274GRP-7036CHOICE-PLUS-PPO
CLMCLM-4297882026-03-10T16:36:12ZNanycQMarshallMar 10, 1961UHC9172928··null2635545355—9776 Main StreetPHOENIXAZ·85073··N/A
ENR ENR-1383842026-06-07T11:54:01ZEllis, LuciaP—1973-09-15UHC-81593-46•••-••-2636929-780-6190lucia.ellis62@aol.com1316 Sage Court·Chandleraz85252GRP-0260SELECT-EPO
ENRENR-1406932026-01-24T05:39:42ZLane, CatherineB.—2007-10-27UHC-93377-92•••-••-0169(589) 583-1856catherine.lane@hotmail.com3738 APACHE BOULEVARD··SacramentoCA··95896GRP-7980CHOICE-PLUS-PPO
ENRENR-1214042026-09-04T22:56:27ZBishop, Lisa—··1946-04-25UHC-70027-59•••-••-0671455-571-3543—5476 MESA DRIVEFresnoca—GRP-8808··MEDICARE-ADV-B
TPATPA-539752026-03-03T23:01:19Zsarah—ward1954-02-01null•••-••-5180230-651-8673sarah.ward46@yahoo.com9079 Cedar LnGilbert·AZ85291UNKNOWNUNKNOWN
CLMCLM-4141212026-01-13T02:46:45ZHenry—Reynolds08/03/02UHC-89188-18NULL—-N/A—-—nullMEDICARE-ADV-B
PRVPRV-294472026-01-07T20:48:35ZCHRISTIAN—MORANO17-05-1939-null4474812422christian.moreno6@gmail.com··9892 Lake View RdSCOTTSDALEAZN/A··-—
TPATPA-60174 2026-07-28T17:16:25ZJeremyAWong1939-09-08UHC-88270-98N/A··——4708 Grand Ave Apt 26SeattleWashington98141nullSELECT-EPO··
TPATPA-541252026-02-27T06:42:48ZCampbell, Becky—····1953-05-09—-+1 762 396 4285—-——N/A—CHOICE-PLUS-PPO
ENRENR-1393762026-02-18T11:39:34Z·keith—rogers1963-04-17UHC-85512-04•••-••-4879901-618-8778KEITH.ROGERS87@GMAIL.COM4996 Palm Dr #138JACKSONVILLEFL32283GRP-7924CORE-HMO
CLMCLM-4120992026-07-31T07:18:48ZAbigail—Scott1979-12-18UHC-38723-32—N/AN/A··943 HARBOR BLVDOrlandoFL32833··GRP-5016—
ENRENR-1349922026-07-11T17:40:29ZLisaVStevens1996-02-06UHC-86214-26•••-••-1096400-662-5324lisa.stevens96@gmail.com·3580 Park PlaceSAN ANTONIOTX·78238GRP-5033NAVIGATE-HMO
TPATPA-629802026-07-16T13:40:02Z·Anna—Miller1948-02-12—-9639456—5134 Spring Street Apt 10Glendale·Arizona85366——
CLMCLM-4136252026-07-24T18:24:28ZSullivan, Eric——1963-09-08NULLNULL+1 449 500 5274N/A—NULLUNKNOWNN/Anullnull
CLMCLM-4314972026-07-31T19:07:20Zadams··W.rebecca2/17/1965·UHC-04443-52•••-••-6897632-662-6814N/A7683 MEADOW LN··TempeAZ85213UNKNOWNNAVIGATE-HMO
CLMCLM-4062802026-07-18T18:19:55ZCAROL—WILLIS19780414UHC-44523-10··•••-••-7448nullNULL3797 Palm DriveLos AngelesCA90057GRP-1261UNKNOWN
CLMCLM-4308392026-02-15T13:30:51ZJUSTIN—ROJAS19901221UHC-58364-37—·NULL-3565 Highland AveTampaFlorida33662N/AUNKNOWN
CLMCLM-4172162026-09-29T02:53:49ZWillie—·Elliott01/20/1943UHC-22957-69—4236107302N/A··9782 Ridge RoadTempeAZ··85289GRP-3253MEDICARE-ADV-A
PRVPRV-212202026-08-24T08:07:51ZNathanRGreene1974-10-10UHC-57579-63—8039060134-277 Cedar LnColumbusOH43236—NULL
ENRENR-1140222026-04-07T10:18:39ZMATEO··—DAY01/04/1999UHC-63036-06•••-••-38484265048898—4576 Sunset BlvdAtlantaGA·30354GRP-3580NAVIGATE-HMO
ENRENR-1206782026-01-11T16:15:02ZElijah··—Gordon1978-11-12UHC-65029-14•••-••-7299856-930-1356UNKNOWN2459 BAYSHORE DRIVEAtlantaGeorgia30359··GRP-6142CORE-HMO
ENRENR-1225812026-09-01T07:29:58ZThomasKFields08-10-1949UHC-92660-62•••-••-50628223916695··thomas.fields@proton.me5303 SUNSET BOULEVARDJacksonville··FL—·GRP-2078MEDICARE-ADV-A
CLMCLM-4190352026-09-14T15:16:29ZGERALD—LYNCH1951-07-10UHC-68982-25—(982) 416-0671—4618 MAIN STREETSacramento·CA95885GRP-3134-
TPATPA-553632026-01-15T16:20:35Z·EMMA—SIMMONS2001-06-02NULL··—NULL1515 CEDAR LNAUSTINTX78781·UNKNOWN··
100,000 rows, page 18 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:34.760Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty