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
ENR ENR-1305702026-07-07T04:13:50ZPorter, TerryS—1985-12-08····—(673) 562-0045TERRY.PORTER@PROTON.ME6723 Indian School RdTucsonAZ85768-6347GRP-7059SELECT-EPO
ENRENR-1255292026-06-21T00:11:03ZAlbert··—Ellis—UHC-85432-06•••-••-22049452836060ALBERT.ELLIS6@YAHOO.COM·860 Ocean AveHOUSTONTX77050GRP-0344navigate-hmo··
ENRENR-1074922026-07-21T21:18:28Z·SCOTTTMARTIN24-02-1968-•••-••-7555—SCOTT.MARTIN23@HOTMAIL.COM9285 Washington StLas VegasNV89108GRP-2575CORE-HMO
ENRENR-1117112026-03-30T01:42:03ZBradley··IBaker1997-02-18UHC-79476-20null··268-791-6853BRADLEY.BAKER66@YAHOO.COM·5704 Broadway #750SacramentoCA95852GRP-1436NAVIGATE-HMO
ENRENR-1417682026-02-15T07:37:38ZMaria—Hart6/22/1957UHC-81705-80•••-••-1876+1 883 416 9940maria.hart@hotmail.com6164 Oak StreetTempeAZ85263GRP-8325CORE-HMO
ENRENR-1079882026-04-26T09:53:11ZJOSEPHF.HENDERSON07/25/1940··UHC-18059-43•••-••-6740986-745-4693··null3798 Market StAtlantaGA30310GRP-1499SELECT-EPO
ENR ENR-1149962026-05-24T12:13:42ZTimothy—Howeell1969-12-13··UHC-99708-59•••-••-360115867772438N/A831 Washington StSacramento··CA95835-7467GRP-7270OPTIONS-PPO
ENRENR-1128922026-07-27T14:52:14ZHernandez, Joseph——1973-03-03UHC-40659-34•••-••-0579nullNULL4451 Canyon RoadSan DiegoCalifornia92169GRP-0601MEDICARE-ADV-A
ENRENR-1384032026-03-07T21:54:51ZKELLY—ESTRADA19380412UHC-02997-73•••-••-4051(926) 435-4007kelly.estrada22@icloud.com··4645 Baseline RdLos AngelesCA90088GRP-0282CORE-HMO
ENRENR-1009592026-08-06T06:30:16ZJanet—Pena1944-10-07UHC-61706-54··•••-••-27548356548050JANET.PENA@ICLOUD.COM3537 Valley View Dr Apt 3MinneapolisMN55462GRP-3762OPTIONS-PPO··
ENRENR-1315932026-10-04T21:40:51ZGregoryXPrice0724-19-91·UHC-11694-58•••-••-73166752818221gregory.price64@proton.me3676 HARBOR BOULEVARDTampaFL33699GRP-5557CORE-HMO
ENRENR-1018872026-06-05T16:11:06ZKeithM.Payne2/13/1997UHC-82936-46NULL8374687938····8137 Cedar LnOrlando··FL32808GRP-9970options-ppo··
ENRENR-1301582026-04-05T16:56:28ZdeniseGsantos1941-05-09·UHC-13629-11null3186096823—5275 MAPLE AVENUEAtlantaGA30372GRP-3765MEDICARE-ADV-A
ENRENR-1186952026-05-16T21:03:29ZLoriIAustin2003-07-23UHC-45897-76•••-••-73986905672213UNKNOWN··3574 CEDAR LANEFresnoCA93760GRP-2336MEDICARE-ADV-A
ENRENR-1221362026-09-15T20:29:22ZNohaEMorgan1976-03-20UHC-82203-05•••-••-4716(408) 309-2344NOAH.MORGAN29@HOTMAIL.COM5058 Palm DrNashvilleTN37274GRP-5781·CORE-HMO
ENRENR-1084692026-01-31T12:18:18Z JoanX.Bryant01/01/1976··UHC-90182-19•••-••-8070347-778-1633joan.bryant@icloud.com7618 MEADOW LANETucsonAZ85726GRP-6040OPTIONS-PPO
ENRENR-1145492026-05-22T11:48:47ZJosshuaBWillias20080312UHC-99131-33—(550) 472-9057joshua.williams@hotmail.com8376 Union StDallasTexas75220GRP-6366NAVIGATE-HMO
ENRENR-1112662026-09-18T15:23:12ZRonaldB··Lawrence5/22/1981UHC-29293-43•••-••-4885NULL-3578 Central Avenue Apt 6ScottsdaleAZ··85283GRP-4484CORE-HMO
ENRENR-1271772026-09-02T13:23:10ZTeresa····Simpson1942-02-26UHC-93574-65•••-••-770312669241937··teresa.simpson@aol.com5990 Highland AvenuePHOENIXAZ85050GRP-1387SELECT-EPO
ENRENR-110085 2026-09-29T08:23:49ZMeganZ.··Carr1962-08-16UHC-74416-41•••-••-85598856608089N/A2579 Meadow LnLos Angeles·ca90003·GRP-3562CHOICE-PLUS-PPO
ENRENR-1087722026-05-05T15:02:23ZSARAHGJAMES20-12-1984UHC-76376-81•••-••-3903379-246-9344sarah.james@outlook.com··3221 Spring StreetATLANTA··GA30381GRP-4143NAVIGATE-HMO
ENRENR-1237112026-01-09T18:22:47ZMARIANAOHENDERSON1975-11-21UHC-66782-51•••-••-3439+1 245 787 2277—3178 Church StreetGilbertAZ85281··GRP-2021NAVIGATE-HMO
ENRENR-1162872026-05-12T14:13:38ZMariana—Wagner··1966-02-27UHC-61747-82•••-••-6948N/A··mariana.wagner@hotmail.com··2487 Oak StreetLos Angeles·CA90001GRP-7086CHOICE-PLUS-PPO
ENRENR-1357032026-09-30T10:14:57Z·CharlieJ.·WarrenNov 7, 1977··UHC-92700-93•••-••-2248+1 904 425 0565charles.warren57@hotmail.com2998 Meadow LnSan DiegoCA92154·GRP-3517CHOICE-PLUS-PPO
ENRENR-140327 2026-09-28T19:39:42ZAMANDA—RILEY1944-02-03UHC-25526-24•••-••-9292(984) 424-2836AMANDA.RILEY@OUTLOOK.COM3827 OCEAN AVEPLANOTX-GRP-1356··MEDICARE-ADV-B
ENRENR-1002792026-06-29T03:41:23ZFlores, AnnN—10/19/78UHC-43456-24•••-••-8550UNKNOWNann.flores@icloud.com5599 BroadwayNashvilleTN37234GRP-5764·MEDICARE-ADV-B
ENRENR-1386912026-09-14T12:09:42Zpat—wilson1962-09-25UHC-11066-40•••-••-0096-patricia.wilson@aol.com7558 Mesa DrColumbusOH43220-4688GRP-6763NAVIGATE-HMO
ENRENR-1349952026-02-24T07:31:51ZISABELLAQFULLER06/26/2002·UHC-89963-39•••-••-2015—isabella.fuller@aol.com6088 PINE DRNashville·TN37284GRP-9655CHOICE-PLUS-PPO
ENRENR-1132412026-02-26T13:48:48Z Murphy, KarenE.—1960-01-28UHC-64792-24··•••-••-5560·375-469-5202KAREN.MURPHY@AOL.COM8224 Willow CourtSeattleWA98116·GRP-9652SELECT-EPO
ENRENR-1266432026-10-05T03:34:00ZHanson, Dorothy——1997-02-23UHC-77636-60NULL(568) 947-5987—·4663 Harbor BoulevardSacramentoCA95814·GRP-3205MEDICARE-ADV-B
ENRENR-1088232026-05-17T08:10:28ZSophiaAMoreno1956-07-12UHC-86550-84•••-••-4392206.449.2736sophia.moreno78@gmail.com1282 Highland AvenueSan AntonioTX78218GRP-9461SELECT-EPO··
ENRENR-1417202026-01-08T18:56:57ZJudyYBanks10/25/1995UHC-08571-74•••-••-2447979.598.7629NULL6291 Canyon RoadTEMPEAZ85204··GRP-4708MEDICARE-ADV-B
ENRENR-1166022026-03-27T11:27:17ZSanders, AndreaT—3/15/1976UHC-23556-43•••-••-1663875-661-3660ANDREA.SANDERS@GMAIL.COM6103 Market StreetColumbusOHnullGRP-4130CORE-HMO
ENRENR-1368622026-06-28T01:56:19ZBRIANELOPEZ2005-07-12··UHC-17499-77•••-••-573413882757688··N/A2763 Broadway·San AntonioTX78230GRP-5489CHOICE-PLUS-PPO
ENRENR-1295312026-08-12T16:27:44Z MARI—LOPEZ4/8/1945UHC-24953-26•••-••-35865884467083—3303 Forest AveJACKSONVILLEFL32243GRP-6800NAVIGATE-HMO
ENRENR-1402052026-09-10T08:17:07Z—J··—1977-08-17UHC-77280-77—12502990466barbara.stevens71@gmail.com720 Main Street Apt 36Las VegasNVUNKNOWN·GRP-2370OPTIONS-PPO
ENRENR-1113242026-09-09T12:35:57Z·DENNISK.ALVAREZ2004-04-22UHC-68394-96•••-••-33345332054449dennis.alvarez57@icloud.com·8893 Maple AveTEMPEaz-GRP-4055CORE-HMO
ENRENR-121500 2026-05-16T10:18:35ZJesse—Greene·1958-03-12UHC-31276-72—(565) 900-7605JESSE.GREENE19@AOL.COM9216 HILLCREST RDLos AngelesCA90033GRP-6277SELECT-EPO
ENRENR-1399002026-09-18T09:18:06ZRuthYHowell08-04-1993UHC-92035-70•••-••-38338133701157RUTH.HOWELL35@YAHOO.COM4721 UNION STMiamiFL33104GRP-1683CORE-HMO
ENR ENR-1382072026-09-26T10:49:44ZFatimaZPayne1984-11-02UHC-28122-89—N/AFATIMA.PAYNE95@PROTON.ME5792 FOREST AVECharlottenc28231GRP-7225CHOICE-PLUS-PPO
ENRENR-1339732026-04-18T19:47:43ZROBERT—HILL-UHC-09753-41•••-••-73412396511620robert.hill57@outlook.com1360 Mountain View DriveSan DiegoCANULLGRP-5716MEDICARE-ADV-B
ENRENR-1149682026-03-05T10:06:02ZSufiaU.Moore12/14/61UHC-86635-12··•••-••-27833172149SOFIA.MOORE@YAHOO.COM··5368 Ridge RdCOLUMBUSOH43203GRP-4033NAVIGATE-HMO
ENRENR-1025982026-04-10T05:02:14Z GeorgeKLawrence2008-06-13UHC-88302-44•••-••-52864616707620george.lawrence@proton.me3807 Market StreetDenverCO80287GRP-4472MEDICARE-ADV-B
ENRENR-1301382026-01-14T03:01:51ZKyleKSmith1983-12-42UHC-64566-52•••-••-44936344357057KYLE.SMITH@AOL.COM1315 PARK PL·SAN DIEGOCA—GRP-3205SELECT-EPO
ENRENR-1100942026-02-10T00:04:05ZArthur D.—Espinoza2003-07-16UHC-87366-53•••-••-546814533570846ARTHUR.ESPINOZA@HOTMAIL.COM9292 INDIAN SCHOOL RDTampaFL33690GRP-7153core-hmo
ENRENR-1396042026-01-31T00:01:07ZNANCYB.GIBLERT1976-03-20UHC-28256-04•••-••-3546899.795.4621··—4914 FOREST AVENUESan AntonioTX78206GRP-3492CHOICE-PLUS-PPO
ENRENR-1367722026-04-13T07:28:56ZAustinB·Santos1978-06-09UHC-34443-43•••-••-517417883371383austin.santos@proton.me457 Oak StCHANDLERAZ85237GRP-7570CORE-HMO
ENRENR-1193252026-06-18T22:17:41ZEvelyn—Burns1991-10-17UHC-64453-70•••-••-7600728-471-9453evelyn.burns@aol.com4461 Spring StTampaFL33671GRP-1619OPTIONS-PPO
ENRENR-1256822026-08-15T23:03:13ZMason—Bowman1979-05-22UHC0706633•••-••-8270441-748-6036mason.bowman15@aol.com5011 Spring StFresnoCA93724GRP-1210NAVIGATE-HMO
ENRENR-1213002026-05-24T08:14:07ZsaraJbrooks4/4/2002UHC0787318•••-••-2697(377) 330-2252sara.brooks13@icloud.com9616 CAMELBACK RDSacramentoCA95805-4149GRP-1980MEDICARE-ADV-A
43,101 rows, page 59 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.691Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty