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-1030112026-08-29T22:45:41Z·FRANCESIPORTER19490113UHC-23993-16•••-••-6463+1 607 697 7962frances.porter22@gmail.com·173 BROADWAYTempe·AZ85230GRP-5620MEDICARE-ADV-A
ENRENR-1206112026-06-24T15:18:30ZSandraMGarcia2004-02-16UHC-27633-77•••-••-4819501-515-1031sandra.garcia18@gmail.com679 Pine DrAustin·Texas78788GRP-4824NAVIGATE-HMO
ENRENR-119550 2026-05-31T13:05:10ZPatriciaUStephens1994-12-03UHC-32471-69•••-••-846013032561563··UNKNOWN166 PARK PLOrlandoFL32889GRP-6526SELECT-EPO
ENRENR-1281052026-01-13T03:38:34Zsamantha—ray09/03/1990UHC-10409-87NULL—samantha.ray45@outlook.com464 Jefferson Avenue··DenverCO80269-2916GRP-7976CHOICE-PLUS-PPO
ENRENR-1157702026-01-14T03:50:18Zelijah F—murphy1975-12-10UHC-90176-56•••-••-3772375-238-3028ELIJAH.MURPHY50@OUTLOOK.COM616 Palm Dr·SacramentoCA95832GRP-9021··SELECT-EPO
ENRENR-1087372026-05-10T14:12:37ZJudithKDaniels13-03-1941UHC-61314-90•••-••-8504541-656-2075judith.daniels68@aol.com862 SUNSET BOULEVARDPhoenixAZ85015-7370GRP-7727NAVIGATE-HMO
ENRENR-1420412026-04-09T18:36:14Z HENRY—·KING2406-91-53··UHC-09665-72•••-••-4307—HENRY.KING9@ICLOUD.COM7813 Park PlScottsdaleAZ85289GRP-8141CORE-HMO
ENR ENR-1144582026-07-11T15:03:54Z·BruceMRamos1996-10-20UHC-19662-94•••-••-8950NULLBRUCE.RAMOS@PROTON.ME3462 APACHE BOULEVARD··ChandlerArizona·85258GRP-7671CORE-HMO
ENRENR-130459 2026-09-14T08:04:41ZRichardK··Boyd·19600103UHC-17428-14··•••-••-66212893718455RICHARD.BOYD65@PROTON.ME3990 Oak StTucsonAZ·85789GRP-6762NAVIGATE-HMO
ENRENR-1156572026-02-23T04:16:43ZJesseURomero1993-03-15UHC-23773-98•••-••-2760(288) 467-2518JESSE.ROMERO@YAHOO.COM1355 CHURCH STCharlotteNC28269GRP-7734NAVIGATE-HMO··
ENRENR-1035562026-05-23T16:19:15ZFrankK.Ramirez1947-10-18UHC-29023-35•••-••-03828285237923N/A3119 Camelback RoadTampaFL33645GRP-0471NAVIGATE-HMO
ENRENR-1309912026-09-22T14:30:56ZKATHLEEN—DAY23-02-1982UHC-81831-31··•••-••-6932(748) 835-5174kathleen.day16@gmail.com5003 OCEAN AVENUE·GLENDALEAZ85390GRP-4552NAVIGATE-HMO
ENRENR-1279232026-07-19T16:18:59ZDONALD—MOORE04-05-1991UHC-35863-38··null3944287776donald.moore@proton.me9889 INDIAN SCHOOL ROADAustinTX78761GRP-7014MEDICARE-ADV-A
ENRENR-1227672026-03-15T17:31:54Zchristina··Dsanchez06/01/2006UHC-05882-67•••-••-653814455399844CHRISTINA.SANCHEZ37@ICLOUD.COM28 Sunset BoulevardHoustonTX77052-1253GRP-7044MEDICARE-ADV-A··
ENRENR-1257552026-10-07T18:28:11ZLogan—SchmidtMay 1, 1940··UHC-14333-36•••-••-3848nullLOGAN.SCHMIDT@OUTLOOK.COM1699 Desert Sky BoulevardMESAAZ85237GRP-3387CORE-HMO
ENRENR-1322372026-04-20T03:33:20Z·randyU.fox10/24/41UHC-87702-57—14125287256randy.fox46@outlook.com8737 VALLEY VIEW DRIVEMinneapolisMN-GRP-3049NAVIGATE-HMO
ENRENR-1194082026-09-21T12:57:12ZNANCY—LYNCH1968-04-17UHC-28387-21•••-••-978416423217506··nancy.lynch56@proton.me6292 Ocean Avenue··GLENDALE·AZnullGRP-9615SELECT-EPO
ENRENR-1162442026-08-28T04:52:46Z·VLENTINA O.—·DANIELS1994-04-20UHC-13186-78•••-••-0237(453) 584-9433valentina.daniels@yahoo.com8688 Palm Dr·SeattleWA98108GRP-5198OPTIONS-PPO
ENRENR-1282152026-07-28T12:59:15ZVIRGINIAN.SCHMIDT1967-09-09UHC-83823-87•••-••-3601+1 893 319 8397virginia.schmidt@yahoo.com9250 FOREST AVESeattleWA98146GRP-8795CHOICE-PLUS-PPO
ENRENR-1353432026-09-21T17:38:19ZBILLYC··MILLS1946-11-11UHC1268016•••-••-05589603095488UNKNOWN8661 Indian School RoadPlanoTX75097GRP-1468CHOICE-PLUS-PPO
ENRENR-1270592026-01-10T18:35:36ZLUCIA—VEGA02/03/62UHC-18096-62•••-••-7447320-344-9877lucia.vega77@gmail.com5744 Spring Street #598Las VegasNV89168GRP-9561SELECT-EPO
ENRENR-1102642026-02-02T01:21:47ZSAMANTHA·BMORRIS1/25/1995··UHC-43300-11•••-••-7081245-770-0021samantha.morris@gmail.com921 CHURCH STTucsonAZ85776GRP-0137CORE-HMO
ENRENR-1140542026-08-05T20:50:32Z·mason P—carternullUHC-49290-17•••-••-9820·(480) 612-3680mason.carter9@icloud.com4253 Mountain View DriveHoustonTX·77095GRP-7196··OPTIONS-PPO
ENRENR-1386782026-06-27T01:54:08ZVICTORIA··KSILVA1992-09-04·UHC-51469-71•••-••-7199456-427-7489victoria.silva59@gmail.com6605 Meadow LnHoustonTX—GRP-5502CORE-HMO
ENRENR-1262582026-03-25T07:40:17ZLindaRDaniels1986-12-24UHC-45701-16•••-••-0716(247) 247-3421··linda.daniels19@icloud.com2200 Sunset BlvdEDEN PRAIRIEMN55327GRP-9734NAVIGATE-HMO
ENRENR-1049942026-04-11T22:55:01Z Elijah—ClarkJul 2, 1940UHC-78663-31··•••-••-349819029400104elijah.clark@gmail.com40 Oak StOrlandoFL····GRP-9791NAVIGATE-HMO
ENRENR-1039942026-03-11T22:38:18ZFrankWBlack1939-12-05UHC-94925-96•••-••-187717715317162frank.black@yahoo.com457 Meadow LaneLOS ANGELESCA90076GRP-8002MEDICARE-ADV-B
ENRENR-112316 2026-05-06T10:24:40ZPAMELA—DOMINGUEZ1957-08-13UHC-15089-82•••-••-42873599504426PAMELA.DOMINGUEZ@ICLOUD.COM6080 VALLEY VIEW DRPlanoTX75024GRP-8462MEDICARE-ADV-A
ENRENR-133231 2026-08-26T02:32:01Zgrace—marquez1969-01-26UHC-69215-77··N/Agrace.marquez2@yahoo.com1400 Mesa DriveHoustonTX77092GRP-9552CORE-HMO
ENRENR-1122252026-07-04T10:38:18ZTERESARMENDOA1942-11-28UHC-68025-52•••-••-0122870.974.0460TERESA.MENDOZA17@PROTON.ME6045 Oak StreetGlendale··AZ85363GRP-2794CHOICE-PLUS-PPO
ENRENR-1193862026-07-30T10:54:47ZAlbert—Marquez·12-09-2003UHC-18573-78•••-••-51476699833albert.marquez@outlook.com9035 Pine Drive #233·FresnoCA93765-6159GRP-9220medicare-adv-b
ENRENR-1111702026-01-02T00:41:07ZJimenez, MarkH.—1996-07-02UHC-70056-67•••-••-58432785996487·mark.jimenez6@proton.me·7732 CAMELBACK ROADJACKSONVILLEFL32226GRP-2710CORE-HMO
ENRENR-1022342026-08-01T02:26:33ZjacquelineOtaylor··Oct 27, 1976UHC-96049-80—(762) 728-9069-2794 OAK STHoustonTX77014GRP-6789CHOICE-PLUS-PPO
ENRENR-1343912026-08-20T05:05:29Zmark·Zvazquez1992-11-10UHC5482707•••-••-54865148555400-2171 HILLCREST ROAD #959MinneapolisMN55476GRP-7853OPTIONS-PPO
ENRENR-1239152026-05-15T07:29:42ZMagaretQ.Bishop1958-08-09UHC-17308-48null—margaret.bishop23@aol.com153 Main StMesaArizona85235··GRP-3426CHOICE-PLUS-PPO
ENRENR-1306852026-07-02T07:45:06ZHEATHERG.WATKINS7/19/1969··UHC-51360-06—+1 907 532 2814heather.watkins1@yahoo.com1054 LINCOLN WAYMesa·AZ85235GRP-8029options-ppo
ENRENR-1134232026-03-16T18:46:07ZDANIELLEZ.BELLDec 8, 1959UHC-71115-60•••-••-3275(369) 529-3503N/A7586 Spring StOrlandoFL32807GRP-2091NAVIGATE-HMO··
ENRENR-1246132026-10-18T02:31:22ZPalAMartinezMar 19, 1953UHC-85993-86•••-••-9028831-517-5723PAUL.MARTINEZ@AOL.COM2801 Grand AveFresnoca93739GRP-5783MEDICARE-ADV-B
ENRENR-110216 2026-01-13T05:10:34ZKATHERINE—ELLISN/Auhc-68175-77•••-••-1142UNKNOWNkatherine.ellis8@gmail.com8308 Meadow LnChandlerAZ85246GRP-2201··NAVIGATE-HMO
ENRENR-1399902026-02-01T17:52:02ZJERRYR.·COLE2005-03-11UHC-88493-81-720.252.4167—8103 Main StTampaFL33600GRP-6711SELECT-EPO
ENRENR-1200892026-02-17T09:00:40ZGERALD—HOWELL··14-12-1948UHC-19205-15•••-••-0126(436) 273-4873GERALD.HOWELL@GMAIL.COM3597 Baseline Rd··San AntonioTX—GRP-8602CHOICE-PLUS-PPO
ENRENR-1027732026-01-27T10:54:36ZHamilton, SaraH—·1977-01-11UHC-62889-75•••-••-2907(506) 601-4372sara.hamilton@gmail.com··1559 Broadway #898SEATTLEWA98113GRP-4611MEDICARE-ADV-A
ENRENR-1165822026-05-04T05:45:44ZLuis—Kelly01/27/47UHC-99509-08•••-••-4943+1 216 603 0304luis.kelly@proton.me7567 Highland AvenueGlendaleAZ85317GRP-9041NAVIGATE-HMO
ENRENR-1385352026-06-14T20:43:47ZRogerVTaylor1996-10-18UHC-26029-98•••-••-3373(687) 734-6758—4847 Church StreetDallasTX75292GRP-9477core-hmo
ENRENR-1146722026-10-04T06:36:21ZRebeccaW.George·19770207UHC-12353-35•••-••-58918895679413—7053 MAPLE AVEEden PrairieMN55377GRP-8631CORE-HMO
ENRENR-1068742026-02-14T11:27:09ZSnyder, StephanieI.—19860809UHC-11789-17•••-••-8092434-635-7606stephanie.snyder@outlook.com5871 MESA DRSeattleWA98149GRP-1674NAVIGATE-HMO
ENRENR-101947 2026-02-27T08:17:10ZJOYCEB.KING1963-04-17UHC-26582-63•••-••-2710(825) 333-8009UNKNOWN4978 Hillcrest RdMesaArizona85290GRP-7951MEDICARE-ADV-A
ENRENR-1016962026-06-05T16:48:43ZMEI—LONG1947-08-24NULL•••-••-9495406-957-2418mei.long@hotmail.com3847 Forest Ave·DallasTX75236GRP-5466CHOICE-PLUS-PPO
ENRENR-1195732026-07-20T12:34:13Zlogan—lawson1941-11-21UHC-25158-41•••-••-6952608.877.4393NULL3174 Lincoln WayJacksonvillefl32204··GRP-8160MEDICARE-ADV-B
ENR ENR-1306452026-01-11T18:03:42ZBRITTANY—HENDERSON1993-01-25UHC-53888-91•••-••-00035749071503brittany.henderson@outlook.com799 ELM STREETEDEN PRAIRIEMN55340-6484GRP-6874·OPTIONS-PPO
43,101 rows, page 228 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:40.608Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty