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-1353032026-05-14T00:08:48ZOMAR—LI··06/27/52UHC-33271-88•••-••-8350—UNKNOWN·2889 Central AvenueMesaAZ85299GRP-0949CORE-HMO
ENRENR-1139402026-03-03T18:16:11ZRonald—OlsonOct 4, 1939UHC-08656-71•••-••-7809(694) 920-7624ronald.olson@hotmail.com9584 Maple AvenueDallasTX75248GRP-6017CHOICE-PLUS-PPO
ENRENR-1064842026-04-29T05:59:56Z·Owens, GabrielJ—1992-12-11UHC-29998-65•••-••-4763+1 366 665 4353—5073 Desert Sky BoulevardHoustonTX77041-0533GRP-5205NAVIGATE-HMO
ENRENR-1269212026-08-04T15:05:15ZCharles—Griffin1995-05-22—•••-••-6831370-224-6790charles.griffin25@proton.me3407 Camelback RdHoustonTX77086GRP-2137NAVIGATE-HMO
ENRENR-105856 2026-09-10T00:00:08ZMoreno, ScottO—1984-10-06UHC-00221-37•••-••-2750(809) 852-3632·SCOTT.MORENO@YAHOO.COM3320 Cedar LaneDallasTX75245GRP-2260NAVIGATE-HMO
ENRENR-1213342026-07-29T18:53:57ZGERALD—·YANG1963-07-07UHC-53274-69•••-••-20732459276170gerald.yang@gmail.com··533 BASELINE ROADColumbusOH··43261GRP-8035MEDICARE-ADV-A
ENRENR-1334572026-09-01T04:44:21ZARJUN··ROBERTSON1958-02-08UHC-02402-18•••-••-0259(712) 316-9065null4366 Lake View RdDallasTX·75266GRP-3584OPTIONS-PPO
ENRENR-1356002026-07-23T11:38:42ZMarilynR.Sullivan05/20/1952·UHC-59465-80•••-••-0207274-851-9508··null5246 Desert Sky BlvdMiamiFL··33143-9647GRP-3876CORE-HMO
ENRENR-1175722026-03-08T13:11:29ZHicks, Sara—····1993-01-17··UHC-61863-88•••-••-99288347243767sara.hicks@aol.com9732 Forest AveMinneapolisMN55485-6686GRP-4548SELECT-EPO
ENRENR-1337952026-01-14T13:56:17ZLUIS—WILLIS1981-11-19UHC-03152-84•••-••-02574072630254··LUIS.WILLIS@AOL.COM8903 Desert Sky Boulevard Apt 17DenverCO80210GRP-4230··MEDICARE-ADV-B
ENRENR-1091912026-09-07T04:45:24Zjoyce—chen1986-05-01-—(638) 252-9071joyce.chen27@outlook.com9200 BASELINE ROADDenverCO80215GRP-8791MEDICARE-ADV-B
ENRENR-1171032026-05-06T22:35:14ZMichaelUGeorgeDec 10, 1997UHC9953598•••-••-4738(696) 921-8894michael.george@icloud.com499 Sunset BlvdLos AngelesCA·90091·GRP-3989CORE-HMO
ENRENR-1238392026-10-14T23:34:07ZJacobs, AbigailU····1955-11-22UHC-00074-37··•••-••-3804·+1 648 892 9693null670 Harbor BlvdMiamiFL33196GRP-0561MEDICARE-ADV-B
ENRENR-1239982026-08-03T11:58:00ZTylerAOliver1951-05-20·UHC-51920-31-5600494tyler.oliver@aol.com7954 Market Street··SeattleWashington98173GRP-9512CHOICE-PLUS-PPO
ENRENR-1385762026-01-27T15:09:26ZEmily—RobertsJul 11, 1955UHC-42496-47N/AN/AN/A6341 Meadow Lane··TucsonAZ85745GRP-4765OPTIONS-PPO
ENRENR-1202542026-01-07T17:41:13ZWilliam—·Ruiz12-01-1993UHC-14301-66UNKNOWN8393335773william.ruiz@outlook.com··8250 HIGHLAND AVEMinneapolisMN55478GRP-2005MEDICARE-ADV-B
ENRENR-1314362026-09-09T09:40:43ZFox, Ruth··Z.—01-01-1997UHC-51091-44null·454.246.6460ruth.fox86@proton.me339 BASELINE ROADAUSTINTX78765GRP-8765MEDICARE-ADV-A
ENRENR-1145232026-08-20T18:33:19Zsandra—morgan·May 20, 1939·UHC-28897-69•••-••-8518+1 567 319 1559null1706 Palm DrDenverCO80287GRP-5035NAVIGATE-HMO··
ENRENR-1405322026-04-04T21:59:42ZDANIELLE A—WELLCH1978-03-10UHC-57613-39•••-••-8223(778) 245-3061—2220 Willow CtTempeAZ85215GRP-3416OPTIONS-PPO
ENR ENR-1411112026-09-01T04:10:55ZRonaldNMejia··1982-05-13UHC-76212-96•••-••-5447274.565.6463·RONALD.MEJIA@AOL.COM2707 Church St·San DiegoCA92103··GRP-7397NAVIGATE-HMO
ENR ENR-1138072026-09-11T06:57:55ZLUCIAH··WATSON1976-09-28UHC-44470-52null(532) 676-3495lucia.watson@outlook.com2545 Oak StreetTempeArizona85265GRP-6683CHOICE-PLUS-PPO
ENRENR-1314172026-08-16T07:22:31ZJuliaQFields1997-05-09UHC-96692-70•••-••-9083939-784-3698·julia.fields44@aol.com3238 Hillcrest RoadSAN DIEGOCA92130GRP-5361CHOICE-PLUS-PPO
ENRENR-1010682026-03-21T05:26:19ZStevenUArmstrongSep 3, 1947UHC-37944-44•••-••-03148308514947steven.armstrong64@hotmail.com2077 Grand AvePlanoTX75051GRP-7342CHOICE-PLUS-PPO
ENRENR-1110302026-01-19T16:31:21ZAlbertAHerrera1979-02-01UHC-78925-85•••-••-4996267.264.4878·N/A5972 Baseline RoadCharlotteNC28221-0875GRP-6426MEDICARE-ADV-A
ENRENR-1154812026-09-29T08:47:08ZRAYMONDNPATTERSON·1938-09-28UHC-88717-54··•••-••-4808222-799-5434raymond.patterson@icloud.com8662 Sage CtCHANDLERAZ85251GRP-0146·OPTIONS-PPO
ENRENR-1188112026-09-10T21:21:55ZVICTORIAJHARVEY·2002-10-06UHC-56992-35•••-••-2362401-264-9252victoria.harvey27@aol.com3235 Bayshore DrGlendaleAZ85359GRP-4862MEDICARE-ADV-B
ENRENR-133133 2026-05-16T09:56:00ZCynthiaPMoore1943-06-06UHC-70365-62—(808) 201-5226cynthia.moore75@aol.com88 CHURCH STREETLos Angeles·CA90028GRP-3311options-ppo
ENRENR-1387912026-08-25T11:18:46Z Christtopher—Wilson1946-12-07UHC-54608-62•••-••-5020+1 679 595 6001CHRISTOPHER.WILSON81@OUTLOOK.COM5634 WASHINGTON STREETTucsonAZ85776GRP-7179·NAVIGATE-HMO
ENRENR-1247962026-08-11T01:58:09ZJack—Howard9/14/1952UHC-70080-35•••-••-9547669-703-5497N/A3222 Indian School RdOrlando··FL32851GRP-4156OPTIONS-PPO
ENRENR-1415652026-01-11T20:25:04ZPATRICKM.·WELCH-UHC-89309-03•••-••-35936146469836PATRICK.WELCH59@GMAIL.COM4756 Mesa Drive·MesaAZ85289GRP-9346MEDICARE-ADV-A
ENRENR-1200902026-09-03T07:51:03ZSamuel—Robinson03/26/1966UHC-35425-74•••-••-9026256-217-9642samuel.robinson@proton.me944 HILLCREST RDLos AngelesCA90080GRP-9388MEDICARE-ADV-A
ENRENR-1274972026-05-19T12:19:50ZAnnDNguyen1987-01-03UHC-02107-04•••-••-5715+1 356 620 2158ANN.NGUYEN@ICLOUD.COM5519 WASHINGTON STChandlerAZ·85258GRP-4096select-epo
ENRENR-1268582026-04-03T03:28:44ZTerry—Singh01-11-1977UHC-38201-98•••-••-15144094278879terry.singh76@hotmail.com7403 Sage CtGilbertAZ85235GRP-0735OPTIONS-PPO
ENRENR-1129452026-02-11T02:11:26ZOlivia—Tran1980-03-18UHC-76853-38•••-••-7812·null·OLIVIA.TRAN19@HOTMAIL.COM3305 Indian School RoadMesaArizona85293GRP-5994choice-plus-ppo
ENRENR-1140522026-04-13T06:59:03ZESPINOZAPDYLAN1955-06-26UHC-01683-02•••-••-7240(273) 914-7317N/A2999 Lincoln WayDENVERColorado···80210GRP-9254SELECT-EPO
ENRENR-1396452026-06-08T18:41:49ZJuliaR··Hanson5/1/2007UHC-74657-99•••-••-0438·327-753-9320JULIA.HANSON@OUTLOOK.COM6216 Lincoln Way·MinneapolisMN55479-0616GRP-9300·SELECT-EPO
ENRENR-1270822026-05-23T18:13:09Znancy—jaames1946-09-07UHC-05876-17•••-••-9360(460) 960-0973nancy.james11@proton.me6049 Bayshore DrHoustonTX77031·GRP-0431MEDICARE-ADV-B
ENRENR-1123262026-05-11T23:34:04ZTIM·CCRAWFORD08/17/70UHC-33870-20•••-••-8908(273) 892-2197timothy.crawford@icloud.com2957 CEDAR LANEGlendaleAZ85395··GRP-8938CHOICE-PLUS-PPO
ENRENR-1125042026-02-28T06:26:21ZSharon P.—Mendez1974-04-01··UHC-87920-25•••-••-9861218.674.8802·····6167 Ocean AvenuePhoenixArizona85080GRP-0152NAVIGATE-HMO
ENRENR-1124022026-06-11T08:53:55ZAnnaWHicks2000-07-28UHC-76951-41•••-••-239612747125621··-4474 VALLEY VIEW DRIVEMINNEAPOLISMinnesota55404GRP-8812SELECT-EPO
ENRENR-1008992026-06-22T21:53:23ZAlbertTMorales1949-06-03UHC-72455-23•••-••-9561509-635-3282ALBERT.MORALES@AOL.COM4504 Lake View RdGilbertAZ·85215-2388GRP-2779MEDICARE-ADV-A··
ENRENR-1426722026-01-22T14:07:00ZHaroldI.Pierce1958-09-17UHC-59853-76•••-••-8668(357) 805-7058harold.pierce@icloud.com5371 Park PlaceGlendaleAZ85370GRP-4266CORE-HMO··
ENRENR-1191022026-09-17T23:04:17ZERIC—DAVIS1993-07-03UHC-71634-23•••-••-831817304239708UNKNOWN6609 Elm StreetLAS VEGASNV89134GRP-3950MEDICARE-ADV-B
ENRENR-1202292026-03-01T17:55:29ZGeorge····Hall2007-02-17UHC-02411-55•••-••-5646—george.hall39@yahoo.com6086 MAPLE AVENUEDallasTX75269GRP-8338MEDICARE-ADV-B
ENRENR-1126682026-03-26T14:23:27ZChristinaMHayes03/27/1942UHC-01179-85•••-••-86848254618220christian.hayes89@aol.com2588 Cedar Ln Apt 34Las VegasNVN/AGRP-8119MEDICARE-ADV-B··
ENRENR-1029442026-04-24T20:37:42Z Fatima——·1980-12-19UHC-32664-63-214-566-4632—8974 Spring StreetLos AngelesCA··90048GRP-8557OPTIONS-PPO
ENRENR-1064852026-02-23T18:12:38ZCHRISTIAN—RAMOS1940-02-26UHC-13877-93N/A9416975669christian.ramos@hotmail.com6760 PINE DRIVESan AntonioTX78230GRP-1092MEDICARE-ADV-A
ENR ENR-1366362026-01-19T23:16:09ZDONNAYYOOUNG1983-02-14UHC-28182-85•••-••-3442214.560.9349DONNA.YOUNG36@GMAIL.COM9517 Park PlScottsdaleaz85270GRP-2087SELECT-EPO··
ENRENR-1064132026-07-14T06:42:54ZWallace, KathleenR—20000314UHC-39042-54•••-••-0293UNKNOWNkathleen.wallace@gmail.com2363 FOREST AVE·ChandlerAZ85242GRP-6643medicare-adv-b
ENRENR-1284392026-04-28T16:46:25ZJaniceFWalsh1970-01-22UHC-75179-24•••-••-4876+1 738 741 8338-6840 CEDAR LN··AtlantaGA30339GRP-2853MEDICARE-ADV-A
43,101 rows, page 87 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:36.721Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty