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-1072642026-09-27T09:49:13ZRammos, BruceS—1948-03-06UHC-52527-15··•••-••-63083794985571bruce.ramos@yahoo.com6296 Main StreetGlendaleAZNULLGRP-8055core-hmo
ENRENR-1368492026-06-07T20:32:17ZGERALDIGARRETTDec 26, 1961UHC-81526-78•••-••-68906474021351GERALD.GARRETT@ICLOUD.COM7543 Bayshore DrDallasTX75247·GRP-6990OPTIONS-PPO
ENRENR-1030832026-06-23T10:22:04ZANTHONY—BROOKS02/12/92UHC-38979-10•••-••-5564(825) 910-2437UNKNOWN9264 INDIAN SCHOOL ROADTempeAZ85265GRP-5797CORE-HMO··
ENRENR-1126582026-03-02T19:13:02ZVirginiaD.Marrtin05/18/53UHC8228741··•••-••-0283718-252-0263N/A··5201 Apache Boulevard·ORLANDOFL32875GRP-3311MEDICARE-ADV-A
ENRENR-1077512026-10-06T16:59:36ZWagner, Dorothy——1953-08-05UHC-38841-83•••-••-4737242-497-5538dorothy.wagner@aol.com4345 Market StreetColumbusOH—GRP-0279MEDICARE-ADV-A
ENRENR-1201322026-01-02T20:59:52ZMEGAN—GEORGE1978-08-01UHC-26913-97•••-••-3787+1 882 233 5553megan.george@outlook.com3656 MEADOW LANELas VegasNV89162GRP-5477OPTIONS-PPO
ENRENR-1272762026-03-02T11:59:11ZDenise—Lynch07/08/78UHC-65111-68•••-••-6777+1 635 643 2277—9283 JEFFERSON AVENUESacramentoCA95871GRP-6500CHOICE-PLUS-PPO
ENRENR-1129242026-02-28T15:01:24Zharris—gary1963-01-09UHC-49016-60•••-••-7792+1 362 983 5825GARY.HARRIS18@YAHOO.COM9603 RIDGE ROADHoustonTX77062GRP-4695OPTIONS-PPO
ENRENR-1276792026-10-17T01:33:29ZJoyceR.Olson10/10/1996UHC-61535-21•••-••-960219624118270joyce.olson@icloud.com4027 Mountain View Drive··HoustonTX77042GRP-5014MEDICARE-ADV-A
ENRENR-1205082026-09-22T07:36:47ZROY—COLE1939-01-05UHC3263541•••-••-3707449.456.1521—3108 Central AveSacramentoCA95897GRP-9677SELECT-EPO
ENRENR-1006302026-07-29T00:56:08Z·davidR.coleman1949-03-23UHC-62709-80··•••-••-1814(744) 446-5866david.coleman@yahoo.com2925 Main StScottsdaleAZ85286GRP-7046MEDICARE-ADV-A
ENRENR-1052772026-03-26T19:42:34ZChristina—Jackson1962-06-02UHC-91939-27•••-••-6551—christina.jackson@aol.com7008 SUNSET BLVD Apt 28DenverCO80297GRP-9387MEDICARE-ADV-B
ENRENR-1340232026-07-21T19:37:59Zcamila—herrera01/08/1946UHC-53583-98•••-••-6591(476) 541-1019·CAMILA.HERRERA15@AOL.COM6176 PARK PLACEGlendaleAZ85380-4322GRP-1970MEDICARE-ADV-B
ENRENR-1278232026-03-28T16:22:56ZJesse—KnightUNKNOWNUHC-10453-53•••-••-1804-jesse.knight@gmail.com5064 Desert Sky BoulevardFresnoCA93716GRP-4036MEDICARE-ADV-B
ENRENR-1139982026-08-10T18:09:03ZWilliam··—Carter19-12-1942·UHC-32278-12•••-••-354812973731963—6526 Forest AvenueEden PrairieMN55348GRP-9558··MEDICARE-ADV-B
ENRENR-1016502026-08-25T23:53:48ZJuan·F.Anderson1957-10-08UHC-85707-30•••-••-17419518898379JUAN.ANDERSON@ICLOUD.COM4092 Camelback RoadNashvilleTN37261GRP-6754··OPTIONS-PPO
ENRENR-1263062026-07-16T10:47:15ZJUDYU.WARD1978-11-40UHC-61206-39•••-••-3618(232) 394-1431judy.ward20@gmail.com931 Sunset BoulevardSAN ANTONIO·TX78219GRP-6707NAVIGATE-HMO
ENRENR-1139942026-08-08T18:26:16ZLISA—SINGH···1947-03-16UHC-06275-32•••-••-21342475589397—8393 Cedar Lane Apt 32GlendaleArizona85360GRP-0834CORE-HMO
ENRENR-1278822026-06-29T13:02:14ZsteveI.alvarez2/25/2007UHC-39225-34•••-••-011417799760516STEVEN.ALVAREZ@PROTON.ME6594 Spring StSan AntonioTX78212GRP-1190MEDICARE-ADV-B··
ENRENR-1391862026-08-07T19:48:26Zjulie—aguilar1960-04-02UHC-30259-35•••-••-4993623.446.5131julie.aguilar77@aol.com626 Cedar LnSan DiegoCA92148-2566GRP-5207SELECT-EPO
ENRENR-1216942026-06-30T05:32:44ZBRITTANY—GILBERT2/15/2002UHC-09613-64•••-••-6810(366) 772-5534brittany.gilbert19@hotmail.com··4053 RIDGE RDAtlantaGA30382-7077GRP-5128MEDICARE-ADV-A
ENRENR-1118432026-06-20T18:48:23ZSEAN—STEPHENS12/23/61UHC-73604-61•••-••-0953nullsean.stephens76@yahoo.com4224 Elm StTempeAZ85241·GRP-7899NAVIGATE-HMO
ENRENR-1231222026-03-03T01:30:48Zsandra—hart19500918UHC-51984-99•••-••-2727846.426.4777sandra.hart@gmail.com9811 MAPLE AVE #555OrlandoFL32892GRP-1092OPTIONS-PPO
ENRENR-1120702026-02-10T09:15:28ZMaria·KCastillo1949-05-11uhc-29981-05•••-••-695217092147452—696 Indian School RoadTucsonAZ85711GRP-6618CHOICE-PLUS-PPO
ENRENR-1411462026-01-24T07:01:49ZBRIAN—FOX20-01-1969UHC-56910-92•••-••-71474308839brian.fox@hotmail.com3889 Spring StreetChandlerAZ85204-0381GRP-3405NAVIGATE-HMO
ENRENR-1138902026-05-09T09:11:54ZCunninghamWTerry1966-10-11UHC-72436-57•••-••-4968661-842-1003—1040 BASELINE ROADAustinTX78784GRP-3925MEDICARE-ADV-B
ENRENR-1291422026-07-04T01:45:20ZMateo, GreeneM.—Sep 22, 1952UHC9556864—240-464-9446mateo.greene18@aol.com6079 Mesa DriveOrlandoFL·32887GRP-2648CHOICE-PLUS-PPO
ENRENR-142368 2026-03-25T06:52:03ZLaurenK.··Willis···1968-03-04UHC-50537-87—-lauren.willis9@aol.com3496 RIDGE RD·SeattleWashingtonNULLGRP-8020CORE-HMO
ENRENR-1240152026-01-31T12:56:06Zjonathan—·george1973-05-09UHC-90734-76··•••-••-2935255-707-1892NULL9653 Elm StCHARLOTTENC28278GRP-0509OPTIONS-PPO
ENRENR-1308942026-06-05T16:45:51ZBryan····Franklin19811217··UHC-08186-77•••-••-9396(898) 260-8770bryan.franklin@gmail.com325 Valley View DrScottsdaleAZ85200-8940GRP-6988NAVIGATE-HMO
ENRENR-1401272026-02-11T01:31:26Z LoriWLewis02/04/1982UHC-97739-09UNKNOWN(450) 914-2015lori.lewis@gmail.com7050 Willow CourtGlendaleArizona··GRP-5702MEDICARE-ADV-A
ENRENR-1411712026-02-25T13:41:59ZDORISD··TUCKER18-04-1951uhc-44970-38•••-••-8951745-336-8473DORIS.TUCKER@GMAIL.COM8068 BroadwayMiamiFL33128-4935GRP-1062MEDICARE-ADV-A
ENRENR-1038462026-03-16T17:55:00ZPatriciaYDelgado·11/05/1969UHC-18037-73•••-••-27804593335689—4110 HILLCREST ROADTampaFL··33667GRP-4400MEDICARE-ADV-A
ENRENR-1115712026-03-28T13:57:53ZVINCENTRSHAW·1984-04-27UHC-60140-35•••-••-7552NULL—3323 Church StreetEden PrairieMinnesota55394··GRP-0542··NAVIGATE-HMO
ENRENR-1197542026-02-15T17:24:32ZalexanderD··welch··1/5/1986UHC6731769NULL766-630-0088—2046 Palm DriveFresno·CA93727GRP-7102SELECT-EPO
ENRENR-1267352026-09-07T18:54:12ZRadnyRHernandez19820903UHC-12377-86•••-••-6976407-694-0357randy.hernandez@hotmail.com5210 Canyon RdAtlantaGA30333-3031GRP-4739NAVIGATE-HMO··
ENRENR-100812 2026-08-04T23:49:12ZLISAS··FERNANDEZ1994-08-02UHC-32791-08•••-••-60594397644733··6537 LAKE VIEW RDNashvilleTN37219GRP-6151CORE-HMO
ENRENR-1346172026-08-24T18:14:26Zarrthur—holmes1979-10-16UHC-61995-62•••-••-4418+1 400 583 4862NULL6471 Meadow LaneAustinTX78734GRP-2308CORE-HMO
ENRENR-1247572026-05-29T02:36:01Zfatima—li1958-06-26·UHC-16752-79•••-••-5859(563) 907-7971FATIMA.LI69@AOL.COM9838 Cedar LanePlanoTX75039··GRP-0820MEDICARE-ADV-B
ENRENR-1316532026-01-13T12:01:42Z Arnold, PamelaR—1958-02-13UHC-73899-09•••-••-5317(806) 446-3919pamela.arnold53@icloud.com1866 OAK STREETFRESNOCA93763GRP-2838OPTIONS-PPO
ENRENR-136765 2026-06-22T13:37:28ZdanielN.vargas1964-04-22UHC-13090-50•••-••-0793(509) 638-5027daniel.vargas@aol.com2461 Mesa DrChandlerAZ··85294GRP-1519CHOICE-PLUS-PPO
ENRENR-1409692026-02-14T06:39:01ZKYLEOBURKE··1940-10-17UHC-42148-38•••-••-28618335014847KYLE.BURKE11@PROTON.ME226 Willow CourtLos Angeles·CA90068GRP-4859CORE-HMO
ENRENR-1003722026-04-01T20:40:04ZMARK—MURRAY2004-08-02UHC-37188-55•••-••-8005+1 894 900 0722—1185 BroadwayCHANDLERAZ85288GRP-1109MEDICARE-ADV-B··
ENRENR-1337202026-08-24T15:35:29ZEliah—StewartNov 12, 1990UHC-25778-41—339-516-8853—8858 Pine DriveFresnoCA93715GRP-2086CHOICE-PLUS-PPO
ENRENR-1020402026-06-12T22:31:22ZMeganD··Peters1991-08-14··UHC-36325-47•••-••-7925(312) 856-8242megan.peters@yahoo.com3173 LAKE VIEW RDSacramentoCalifornia·95821GRP-1156OPTIONS-PPO
ENRENR-1237382026-03-17T05:43:08ZKYLEKHART1974-07-16UHC-55243-67•••-••-7748(912) 216-6414kyle.hart23@aol.com7193 Sage CourtColumbus··OH43240GRP-9101CHOICE-PLUS-PPO··
ENRENR-1303462026-05-18T17:38:35ZRachelKGarza1951-02-09UHC-60032-54—2363283587RACHEL.GARZA@ICLOUD.COM4470 PARK PLACEFresnoCA93732GRP-4963SELECT-EPO
ENRENR-1119692026-03-08T07:37:00ZDanielle—Ward20030925UHC-81974-47•••-••-4052(877) 839-5229danielle.ward@icloud.com8315 Central AvenueSCOTTSDALEAZ85262-0134GRP-4331CORE-HMO
ENRENR-1361602026-09-11T15:49:03ZALANIMURPHY1943-01-24UHC-18244-36•••-••-17953319896490alan.murphy48@icloud.com5809 Valley View Dr·PlanoTXN/AGRP-0891CHOICE-PLUS-PPO
ENRENR-1357712026-07-10T07:24:12ZRonald—Tran9/13/2007UHC-51631-71•••-••-2423(975) 508-0090ronald.tran@proton.me9300 Broadway Apt 22Las VegasNevada·89195GRP-2256OPTIONS-PPO··
43,101 rows, page 170 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:38.499Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty