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
ENRENR-1039422026-02-01T05:56:35ZLawrence, MasonR—Mar 4, 1980UHC-24473-72•••-••-6084—MASON.LAWRENCE19@AOL.COM7666 Baseline RdScottsdaleAZ85206GRP-5566CHOICE-PLUS-PPO··
ENR ENR-1318662026-02-18T22:28:12Z·Richard N—Chapman11/01/1999UHC-28200-70•••-••-7598·+1 831 458 1341RICHARD.CHAPMAN@OUTLOOK.COM5513 Desert Sky BoulevardPLANOTX75012-2089GRP-1016MEDICARE-ADV-B
TPATPA-565402026-03-09T02:50:47ZOLIVIA—LONG15-07-1997—-824-274-2158olivia.long66@gmail.com1779 Jefferson AveMiamiFL33125GRP-1363N/A
CLMCLM-4235542026-05-01T07:40:23Zsarah··—franklin19-02-1979UHC-19757-48•••-••-9779N/AN/Anull——N/A-CORE-HMO
TPATPA-580112026-07-25T13:03:13ZGuzman, Walter——1980-07-20——(926) 884-3798NULL9478 WASHINGTON STTucsonAZ85787N/AOPTIONS-PPO
PRVPRV-20604 2026-08-27T14:16:43ZChristinaFPerez20-01-2000UHC-96033-78N/A(455) 754-4897—9108 Meadow LaneGilbertAZ85255—UNKNOWN
ENRENR-1256142026-03-04T03:17:42ZJozeph—Daniels05/08/1958UHC-62760-29•••-••-59145485384603—4754 Cedar Lane·AustinTexas78779GRP-0329·NAVIGATE-HMO
CLMCLM-4025482026-09-04T09:30:42ZHernandez, DianaA.—11/2/1968UNKNOWN-··929.867.5262null2531 Indian School RoadTucsonAZ··85707-··OPTIONS-PPO
CLMCLM-4212412026-09-15T00:28:56ZWEBERKFRANCES02/15/63··UHC-72878-47nullnullnull4716 Camelback Rd Apt 35Los AngelesCalifornia90013UNKNOWNcore-hmo
TPATPA-57072 2026-09-29T00:04:48ZCHARLES—MARSHALL19670101-——····8778 Valley View DriveSan AntonioTX78208UNKNOWN-
ENRENR-1350602026-03-18T03:29:05ZDebra—Oliveer12/13/38UHC-76154-45•••-••-4878413-439-6828DEBRA.OLIVER@ICLOUD.COM8029 Maple AvePHOENIXAZ85043GRP-6796CHOICE-PLUS-PPO
CLM CLM-4011952026-07-24T21:56:50ZWast, Noah——12/14/2008UHC-54131-68N/A(395) 624-8427UNKNOWN5602 CENTRAL AVENUEDenverCO80264GRP-2799—
ENR ENR-1301232026-10-01T19:34:05ZPeterson, HiroshiR—Sep 4, 1968UHC-61159-02•••-••-6809(467) 518-3509—2708 Oak StreetMiamifl·33131GRP-4004MEDICARE-ADV-B
TPATPA-528722026-07-21T22:50:17Z·Carl—Pnea07/21/53N/AN/AN/A—6299 CENTRAL AVENUETEMPEAZ85283-7107NULL·-
TPATPA-637202026-04-19T00:55:53ZSoophia····Wang1950-01-28UNKNOWN•••-••-6007(620) 351-9167-6636 Spring StreetJacksonvilleFLNULLGRP-0115N/A
ENR ENR-1292632026-01-06T03:05:48ZWilliam·KHernandez2001-09-12·UHC-46931-84•••-••-18695142381081william.hernandez@hotmail.com7899 Cedar LnDallasTexas75231GRP-8800SELECT-EPO
ENRENR-1277062026-09-07T10:35:39ZDennis J.—Holmes1981-01-15UHC-23663-34•••-••-27499044237368dennis.holmes@aol.com8792 ELM STMiamiFL33153GRP-1143MEDICARE-ADV-A
CLM CLM-4292952026-04-08T06:59:44ZVALENTINA···SINGH1955-11-26NULLNULLNULLNULL4496 UNION STREETDallasTX75295GRP-8093CORE-HMO
ENRENR-1091742026-04-01T12:02:54Zanna··—burton1951-06-22UHC-34712-64•••-••-5725NULLANNA.BURTON@ICLOUD.COM3373 Valley View DriveAtlantaGA30362·GRP-3720CORE-HMO
PRVPRV-291522026-01-15T02:04:39ZJoshua—Guerrero1963-09-04UHC-94844-47-624-376-3251NULL7674 Baseline RdDallasTX·75246—MEDICARE-ADV-A
CLMCLM-4047972026-09-02T09:31:37Z Alice—Perry0424-14-93UHC-53984-35•••-••-8976209-671-4901·null9138 HARBOR BLVD··DenverCO80219GRP-5494OPTIONS-PPO
CLM CLM-4212032026-05-06T02:10:10Z Kathleen—Santiago11-10-1943—-15027555551-UNKNOWNNULL——GRP-9707CHOICE-PLUS-PPO
CLMCLM-4135432026-08-10T18:10:15ZJaanet—Valdez1943-04-01··UHC-35323-58····4779931—7016 Ridge Rd··CHANDLERAZ85226N/Anull
CLMCLM-411314 2026-10-10T05:44:51ZJuy—Rivera1960-05-09UHC-37285-52•••-••-9002-··—6789 Main StreetCharlotteNC28209GRP-8564SELECT-EPO··
ENRENR-1214122026-02-23T01:01:32ZCarolH.Waton1977-08-21UHC-45598-14UNKNOWN9294422414carol.watson89@outlook.com1921 Bayshore Dr·CHARLOTTENorth Carolina··28256GRP-7866··SELECT-EPO
TPATPA-530562026-07-11T13:24:09ZMatthew—Boyyd07/07/1958NULL•••-••-6144N/A—3756 Oak StCHARLOTTENC·28222NULLUNKNOWN
CLMCLM-4136342026-09-14T06:55:04Zjoshua··bell1951-09-15-UNKNOWNN/Ajoshua.bell83@outlook.comUNKNOWNNULL——GRP-6874—
CLMCLM-4268762026-08-26T03:41:27ZPhilip—Johnston7026-19-66UHC-61230-27•••-••-4955-philip.johnston71@yahoo.com9556 River RoadTUCSONAZ85789GRP-9569·MEDICARE-ADV-B
ENRENR-1296922026-05-25T18:15:00ZCollins, Dennis——20010715UHC-50198-73•••-••-519812689359813DENNIS.COLLINS@OUTLOOK.COM4690 Ocean AvenueDallasTX75280GRP-5304SELECT-EPO
ENRENR-1178792026-06-14T18:08:18ZJerry—Phillips1959-10-23UHC9831608•••-••-8680841-997-6554—5337 FOREST AVENUEMiamiFL33159GRP-4457CHOICE-PLUS-PPO
CLMCLM-4148082026-06-10T21:45:38ZCynthia—JensenMay 28, 1959UHC-82520-15nullN/AN/A454 APACHE BOULEVARDColumbusOH43277··GRP-8939CORE-HMO··
ENRENR-1146792026-03-19T19:34:35ZRONALDEJENKINS24-10-1959UHC-45399-14NULL—ronald.jenkins@proton.me9848 Hillcrest RoadSeattleWA··98173GRP-8879CHOICE-PLUS-PPO
CLM CLM-4290012026-01-18T15:33:39ZGeorge—Berry1987-02-04··UHC-94256-16—9482191848—4676 Ocean Avenue·ChandlerAZ85299GRP-4306—
ENRENR-1131282026-09-05T14:16:31ZHICKS——03/26/1974UHC-68928-73•••-••-30842157592648aaron.hicks@gmail.com·6607 DESERT SKY BLVDEden PrairieMN55313GRP-9454CHOICE-PLUS-PPO
ENRENR-1199492026-05-09T15:52:44ZAaronF.Evans1944-06-16UHC-51560-75•••-••-8884(693) 536-5422aaron.evans83@outlook.com2320 Central AveAustinTX78753·GRP-7508MEDICARE-ADV-A··
ENRENR-1093522026-07-29T20:06:38Z MATEO—TAYLORFeb 24, 1978UHC-48830-68•••-••-3601(867) 332-4034MATEO.TAYLOR@PROTON.ME4707 Church StDenverCO80203GRP-6957·CHOICE-PLUS-PPO
CLMCLM-4232972026-08-13T13:39:00ZMADISONRBROOKS1973-11-20··UHC6686528··-9136669109null4130 Desert Sky BoulevardAtlantaGeorgia30398UNKNOWNCHOICE-PLUS-PPO
PRVPRV-261192026-02-21T17:14:12ZMary—Nunez1967-06-23N/A•••-••-97054078082756null326 Willow CourtHoustonTX77049N/AN/A
TPATPA-626902026-05-26T02:16:22ZKIMBERLY··SPENCER19821211·NULL—+1 808 537 3682NULLNULL—N/A—GRP-1290··CORE-HMO
CLMCLM-4283392026-10-02T11:06:03ZArjunWRiosMay 7, 1946UHC-87030-13•••-••-129716252517938—5830 Desert Sky BoulevardPhoenixAZ85019GRP-7136NAVIGATE-HMO
CLMCLM-4067652026-09-20T16:16:35ZCamila—MillerFeb 11, 1961·UHC-19495-23NULL—-7163 Main StPlanoTX··75021··CHOICE-PLUS-PPO
CLMCLM-4284452026-04-11T23:57:43Z·Mike—Holmes·5/15/1999NULL•••-••-4471(472) 628-6045-6651 BroadwayDallasTX75263NULLUNKNOWN
TPATPA-614412026-07-15T09:14:30ZLINDAISTEWART1976-03-11—--··3321 Valley View Drive·MinneapolisMN55411GRP-5544CORE-HMO
ENRENR-1138062026-08-31T21:36:20ZLuciaHWatson1976-09-28UHC-44470-52•••-••-6288532.676.3495··lucia.watson@outlook.com2545 Oak StTempeAZ85265GRP-6683CHOICE-PLUS-PPO
ENRENR-1228862026-05-15T06:18:15ZJESSICA··—MENDEZ1990-96-28null•••-••-7965943-347-6409—4733 Mountain View DriveMiamiFlorida33137GRP-6390MEDICARE-ADV-A
TPATPA-548452026-10-09T00:06:26ZAlexanderTParker1977-02-05—•••-••-4453-—5802 PALM DRIVENashvilleTennessee37282GRP-4591UNKNOWN
ENRENR-1131192026-09-01T23:49:40ZRussell—Weber1966-05-02UHC2131172•••-••-8942+1 368 335 3793—3471 River Rd·ATLANTAGA30353GRP-0174OPTIONS-PPO
ENRENR-1395732026-03-27T19:55:59ZLuciaPReyes1967-05-26UHC-11974-20•••-••-0684(988) 734-6573lucia.reyes52@outlook.com8769 MESA DRIVEGLENDALE·AZ85310GRP-7868MEDICARE-ADV-B
ENRENR-129561 2026-08-04T15:13:28ZTHERESAU.HICKS02/09/1969UHC-01574-14•••-••-66528065654780null1799 Highland AvenueJacksonvilleFL32208-0668GRP-0590MEDICARE-ADV-A
ENR ENR-1254662026-01-23T04:51:05ZPriya—Murray1978-02-02UHC-60074-18•••-••-9784475.387.9267priya.murray@gmail.com·995 WASHINGTON STREETMiamiFL33156GRP-0112MEDICARE-ADV-A
100,000 rows, page 260 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.754Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty