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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1364502026-02-25T02:46:00ZdebraQsingh1993-07-11UHC4308948•••-••-8800424.236.0970null1303 Maple Avenue·MesaAZ85264GRP-5872··OPTIONS-PPO
ENRENR-1244502026-03-25T13:56:56ZGLORIATBERRY08/04/08UHC9155458•••-••-67767644499555UNKNOWN5979 Sage CourtMESAArizona85216GRP-4121SELECT-EPO
ENRENR-1035752026-07-02T14:44:45ZJacob·EMyers19910711UHC-18643-77•••-••-2206·790.292.3811—3061 LINCOLN WAYTampaFL33637··GRP-5025NAVIGATE-HMO
ENRENR-1052812026-09-23T17:33:22ZRamos, FrankV.—2007-03-20·UHC-88144-65•••-••-47144088893··FRANK.RAMOS@PROTON.ME8047 Indian School RdCharlotte··NC·28232GRP-7288··choice-plus-ppo
ENRENR-1167542026-09-01T19:46:19ZLuis··—NelsonJun 21, 2007UHC-86108-83•••-••-1722(959) 854-6768luis.nelson@hotmail.com5017 Sunset BoulevardSeattleWA98115GRP-9775CORE-HMO
ENRENR-1099452026-07-21T16:36:58ZAusstinL.Nguyen1992-08-09UHC-43885-20•••-••-0400(231) 867-0843····5199 Church StreetLas VegasNV89131GRP-2061CHOICE-PLUS-PPO
ENRENR-1228632026-02-03T14:13:27ZSeanFPrice1952-05-18UHC8606888•••-••-99726433590619NULL—UNKNOWN—UNKNOWNGRP-0978CHOICE-PLUS-PPO
ENRENR-1386452026-01-21T16:19:21ZRichardQWheeler19450902UHC-39801-46UNKNOWN(867) 954-0304richard.wheeler@aol.com4484 VALLEY VIEW DRIVECharlotte··North Carolina28216GRP-8921OPTIONS-PPO
ENRENR-1115272026-09-23T21:38:52ZCAROLYN—BRYANT06/16/1990UHC-09342-45•••-••-56527735473261CAROLYN.BRYANT89@HOTMAIL.COM9240 Park Place Apt 17San DiegoCA-GRP-4025NAVIGATE-HMO
ENR ENR-1279062026-04-20T16:24:25ZShirley··LMorris1985-03-17UHC-89888-33•••-••-1258(218) 286-2611··SHIRLEY.MORRIS@ICLOUD.COM7543 Canyon RoadAtlanta··GA30375GRP-7022SELECT-EPO
ENRENR-1295792026-09-15T18:47:48ZscottVlewis1987-08-28UHC-16885-62•••-••-9970334-675-2722scott.lewis9@aol.com6351 Park PlacePlanoTX·75034GRP-9400MEDICARE-ADV-B
ENRENR-1118862026-06-08T08:10:39ZCarlosE··Black07/05/84UHC-87243-22•••-••-9466·(454) 664-6146carlos.black@aol.com1501 WILLOW CTHoustonTXN/AGRP-5950·OPTIONS-PPO
ENRENR-1356642026-05-16T06:51:55Zgloria—yang2008-06-20·UHC-77975-62•••-••-75243764328088GLORIA.YANG@YAHOO.COM4313 Main StPhoenixAZ85071GRP-8361··CHOICE-PLUS-PPO
ENRENR-1365582026-09-03T06:35:57ZCole, Maria——1946-12-12·UHC-57827-95•••-••-8565(611) 352-5955maria.cole@outlook.com··7219 APACHE BOULEVARD·PhoenixAZ··85014GRP-4812··CORE-HMO··
ENRENR-1080112026-06-01T12:42:06ZPHILIPPWHITE1962-09-19UHC-62738-03•••-••-5976·+1 755 767 6011PHILIP.WHITE@HOTMAIL.COM9889 Canyon RoadChandlerAZ85247GRP-3253SELECT-EPO
ENRENR-1426902026-09-11T16:59:36ZBRANDONO.GRAHAM02/12/38UHC-05149-71•••-••-87532692926029·brandon.graham71@outlook.com8834 MESA DRIVESan Antonio··TX78253GRP-5381CHOICE-PLUS-PPO
ENRENR-1195072026-08-25T04:36:07ZChristina—Ortega1971-07-03UHC-06273-61•••-••-5031(472) 747-8991··christina.ortega@hotmail.com2874 River RoadTucsonArizona85765-4911GRP-5497NAVIGATE-HMO
ENRENR-108321 2026-05-03T01:40:19ZBruceR.Jacobs04/21/1950UHC-94100-19•••-••-5834(210) 989-4072bruce.jacobs@gmail.com6148 Sunset BlvdTucsonAZ85723GRP-9840NAVIGATE-HMO
ENRENR-1083592026-05-23T16:28:11ZMeganZSantiago05/15/1948uhc-27734-09NULL8463227078UNKNOWN4521 Ridge RoadGlendale··AZ85384GRP-7968CHOICE-PLUS-PPO
ENRENR-1133512026-03-08T19:11:45ZNicoleZPorter1973-01-24—•••-••-4718360-456-4633nicole.porter@gmail.com8253 RIVER ROADSeattle·WA98181GRP-6171SELECT-EPO
ENRENR-1229072026-05-03T16:55:40ZSEANJ.ALLEN02/02/45UHC-01959-63•••-••-0889—sean.allen@icloud.com9540 LAKE VIEW ROADDenverCO80293GRP-8974MEDICARE-ADV-B
ENRENR-1318002026-09-09T00:35:02ZStevenJ.Boyd·2007-08-18UHC-41446-64•••-••-61766519404964STEVEN.BOYD82@YAHOO.COM283 Spring St··PlanoTX75094··GRP-7630CHOICE-PLUS-PPO
ENRENR-1355382026-06-17T13:18:36ZMary—·Gray1950-03-11UHC-62508-27•••-••-2604UNKNOWNUNKNOWN91 Elm StMIAMIFL33169GRP-0386CHOICE-PLUS-PPO
ENRENR-1384232026-03-17T01:10:58ZVINCENT—RAMIREZ1944-02-21UHC-41583-48•••-••-5137568-681-2784VINCENT.RAMIREZ84@OUTLOOK.COM8003 SUNSET BOULEVARDCHARLOTTENC28266··GRP-7774MEDICARE-ADV-A
ENRENR-1122682026-03-12T11:28:46ZRyan··—Reynolds1936-06-06UHC-66475-43•••-••-0345226-495-8632ryan.reynolds@outlook.com7232 PALM DRIVE #489PlanoTX75088-7085GRP-2387OPTIONS-PPO
ENR ENR-1399272026-02-19T09:45:17ZVezquez, David——·20-07-1991UHC-60007-82•••-••-947516243644386null5431 Mesa DriveAtlantaGA30391GRP-7146MEDICARE-ADV-B
ENRENR-1044222026-02-28T14:34:29ZKatherine—·Marshall·1944-08-16UHC-61716-65•••-••-0166571-988-6069UNKNOWN6981 GRAND AVEFresnoCA93735-8165·GRP-2747NAVIGATE-HMO
ENRENR-1032842026-06-23T03:12:08ZkarenTjohnston·12/24/1998·UHC-95810-35•••-••-3354(899) 972-7622KAREN.JOHNSTON@ICLOUD.COM5990 Palm DriveMiamiFL33168GRP-9593··OPTIONS-PPO··
ENRENR-1144242026-07-19T04:47:12ZRichard—·Chavez1966-90-25UHC-51485-87•••-••-6497272-316-0076·····5509 BASELINE RDNashvilleTN37261GRP-8772CORE-HMO
ENRENR-1373232026-07-23T06:11:33ZLISAY··RIOS1979-12-05UHC-40257-27•••-••-4580931-530-8307lisa.rios@icloud.com·9497 HARBOR BLVDSEATTLEWA98134GRP-8293CORE-HMO
ENRENR-136667 2026-03-30T08:04:49ZJean—Simpson1968-03-04UHC-80371-38•••-••-3082(827) 819-8386JEAN.SIMPSON@GMAIL.COM3582 LINCOLN WAYGlendaleAZ85318GRP-7831CHOICE-PLUS-PPO
ENR ENR-1167022026-07-30T22:19:25ZAmy·····Hawkins1967-04-16UHC-23477-69—707-747-2918amy.hawkins85@proton.me1162 Grand Avenue·MinneapolisMN—GRP-2383CHOICE-PLUS-PPO
ENRENR-1389062026-01-07T19:39:31ZCARL—·LAWSON1971-05-06UHC-41329-95•••-••-79383943276196CARL.LAWSON@PROTON.ME6547 Palm DriveDallasTX75247GRP-3496NAVIGATE-HMO
ENRENR-1398392026-08-09T13:31:52Zelizabteh—pena1972-08-11UHC-73696-38•••-••-69245644732575null8280 Apache BlvdHoustonTX77028GRP-7384OPTIONS-PPO
ENRENR-1308152026-03-05T02:43:31ZTHERESAI.MALDONADO1962-05-11UHC-54915-05•••-••-7206(283) 717-9402theresa.maldonado81@gmail.com351 Ocean AvenueMinneapolisMN55422GRP-5423options-ppo
ENRENR-1348142026-07-06T18:06:13ZLOGANKEVANS2004-03-05UHC-70285-69•••-••-1593UNKNOWNlogan.evans@gmail.com·8348 Broadway·Mesa·AZ85215GRP-0276MEDICARE-ADV-B
ENRENR-1089712026-03-01T08:34:01ZRachelXMurphy1971-03-11UHC-45733-41•••-••-3488(543) 870-8911rachel.murphy@icloud.com7004 PALM DRScottsdaleAZ85265GRP-6661MEDICARE-ADV-A
ENRENR-135366 2026-02-26T23:48:33ZVega, Peter——2002-04-06UHC-80214-61•••-••-4843792.591.1289null··3312 Ridge RoadFRESNOCA93788GRP-0926MEDICARE-ADV-A··
ENRENR-1063282026-10-03T05:54:06ZMarcusRJimenezMay 18, 1982UHC-07817-62•••-••-264714206398686-7349 APACHE BOULEVARD·FresnoCA93796GRP-4763OPTIONS-PPO
ENRENR-1089212026-06-11T19:07:37ZJean··MyersFeb 4, 1977UHC8968188—·(428) 733-8255NULL—N/AN/A··GRP-6614NAVIGATE-HMO
ENRENR-1066642026-03-21T01:00:52ZISABELLA··FERNANDEZ04-08-1945UHC1010543—7767252944ISABELLA.FERNANDEZ7@ICLOUD.COM1477 Ridge RdLas VegasNV89131GRP-4837OPTIONS-PPO
ENRENR-1395422026-04-09T11:41:08ZJoe—Rojas19820106UHC-25331-20•••-••-3226(851) 420-2582·joe.rojas66@proton.me7841 Sage CtPHOENIX··AZ85047GRP-7759SELECT-EPO
ENRENR-1073562026-03-20T22:51:48ZSandraB.Smith1977-06-05UHC-19366-24•••-••-6489—sandra.smith49@outlook.com2383 Park PlaceChandlerAZN/AGRP-2306SELECT-EPO
ENRENR-1152912026-04-22T10:07:49ZPatrickDWalsh1998-03-25UHC-25721-65•••-••-1455220-399-8995patrick.walsh@proton.me··1391 BAYSHORE DRIVE··DenverCO·80246-4932GRP-5855CHOICE-PLUS-PPO
ENRENR-1363942026-03-28T07:27:35ZNANCY—MYERS19990615UHC-26902-60•••-••-3112+1 781 582 4969—1604 Sunset BlvdAustinTX··78771GRP-3212MEDICARE-ADV-A
ENRENR-1351132026-05-16T09:37:56ZBeverly—Jackson1986-03-23UHC-04410-23•••-••-11257016324921BEVERLY.JACKSON@HOTMAIL.COM7204 Jefferson AvenueGilbertAZN/AGRP-8534MEDICARE-ADV-A
ENRENR-1232362026-05-02T07:59:37ZNANCYTWILLIAMSSep 13, 1983UHC-38414-77··•••-••-6118348-798-3527nancy.williams@hotmail.com4029 Harbor BlvdDallasTX75225GRP-3603OPTIONS-PPO
ENRENR-1423812026-06-22T02:32:51Z AMANDA—BENNETT1946-06-10UHC-24206-61•••-••-569615557163494amanda.bennett9@proton.me5321 Spring StTampaFL33637-0515GRP-1898CHOICE-PLUS-PPO
ENRENR-1285612026-03-06T07:04:19ZrachelU.jones1940-12-07UHC-87030-93•••-••-2535+1 553 817 4766N/A2314 Elm StreetScottsdaleAZ85222GRP-2377SELECT-EPO
ENRENR-1208402026-03-09T17:41:05ZRalph—Edwards6/19/1969UHC-36979-92··—796-502-6519ralph.edwards72@hotmail.com5468 BAYSHORE DRIVEChandlerAZ··85240GRP-0856OPTIONS-PPO
43,101 rows, page 272 of 863PreviousNext

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