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-1330112026-01-13T03:10:55ZTylerV.·Mills1994-07-04·UHC1593161·-419-251-5318tyler.mills75@proton.me9120 MARKET STColumbusOH43272GRP-0582··CHOICE-PLUS-PPO
ENRENR-1262932026-08-23T06:06:49ZJoshuaFJenkins1989-04-19UHC-51257-13•••-••-755313484544578joshua.jenkins77@gmail.com7462 Maple AvenueGilbertAZ85241·GRP-9704NAVIGATE-HMO
ENRENR-1032112026-01-09T00:37:35ZLAURENL.NUNEZ1976-04-15UHC-81063-83•••-••-53325876623640lauren.nunez@icloud.com394 HARBOR BOULEVARD·TAMPAFL33654GRP-3138NAVIGATE-HMO
ENR ENR-1313032026-04-02T21:00:25ZGLORIAVBROWN2005-05-04UHC-21916-74•••-••-2311(839) 767-7849·GLORIA.BROWN@HOTMAIL.COM3815 Church StreetScottsdaleaz·85238GRP-9549CHOICE-PLUS-PPO
ENRENR-1076752026-09-24T07:26:28ZRUTHY.STEPHENS11/26/56UHC-49733-39•••-••-1177416-288-1086··ruth.stephens@icloud.com3218 GRAND AVEDenverCO80292GRP-1630SELECT-EPO
ENRENR-1307272026-01-31T09:35:08ZWALTERVCOLEMANAug 12, 1968UHC-12362-91•••-••-5573·null—2052 River Road··Los Angelesca—GRP-6193CORE-HMO
ENRENR-1169562026-02-22T04:06:56ZbarbaraY.boyd··1966-09-24UHC-51193-31•••-••-2733(633) 614-6338barbara.boyd64@gmail.com··9280 Valley View DrLas VegasNV·89118GRP-8141SELECT-EPO
ENRENR-1193112026-10-16T22:19:31ZFRANK Q.—WALKER1952-01-25UHC-33096-95•••-••-52177333134220frank.walker@aol.com9876 SPRING STMesaAZ85228GRP-7654medicare-adv-a
ENRENR-1426712026-01-22T05:20:46ZChristianRGreen1959-08-04UHC-20302-69•••-••-8562+1 699 835 4177··christian.green@gmail.com1612 Union StSeattleWA·98107GRP-7459NAVIGATE-HMO
ENRENR-1130732026-01-27T05:33:19ZGaryY.··Stewart19860802UHC-91173-07•••-••-6504(779) 940-8466gary.stewart@outlook.com4298 MAIN STREET Apt 27Columbus··oh43209GRP-7339MEDICARE-ADV-A
ENRENR-1239242026-05-03T16:23:49ZJUAN—SINGH1951-08-22UHC-53432-92•••-••-0809+1 750 746 8626juan.singh57@proton.me2491 OCEAN AVENUEEden PrairieMN55322GRP-1782NAVIGATE-HMO
ENRENR-1138452026-02-10T20:46:36ZVINCENT—DAY01/23/1994UHC-43106-96··•••-••-7046(538) 479-3763··815 Highland AveEDEN PRAIRIEMN55386GRP-1447MEDICARE-ADV-B
ENRENR-1318982026-08-16T14:13:08ZHAROLD—MALDONADO·2006-01-22UHC-69610-54•••-••-1043(469) 743-8061—3571 MARKET STREETEden PrairieMN55329··GRP-5236OPTIONS-PPO
ENRENR-1312822026-08-24T16:40:33Z HERNANDEZJ.KATHERINE1955-09-27UHC-08215-63•••-••-0634-—7590 Meadow LnJacksonville·Florida32240GRP-1292OPTIONS-PPO
ENRENR-1430262026-05-09T13:03:28ZMeyer, Duris——1960-12-20·UHC-45303-32•••-••-6427····doris.meyer@icloud.com··7944 Valley View DrivePlanoTX75036GRP-7648OPTIONS-PPO
ENRENR-1192772026-09-30T16:13:19ZSanchez, Denise··B—1994-11-02UHC-02390-99•••-••-9404+1 376 938 8256·DENISE.SANCHEZ@YAHOO.COM8771 Market StreetScottsdaleaz85293GRP-6468MEDICARE-ADV-A
ENRENR-1173742026-08-10T07:34:26ZROYN.HANSEN1940-68-14UHC-25734-43•••-••-3273(247) 390-1544roy.hansen@proton.me3041 Canyon RoadTampaFL33618GRP-8623core-hmo
ENRENR-1310662026-07-07T21:44:32ZMartha—Bradley1969-09-03UHC6604335•••-••-4647808.476.5256UNKNOWN385 Market StreetHoustonTX77051GRP-2526···MEDICARE-ADV-B
ENRENR-1092342026-06-06T16:29:37ZCharlotte·KAllen19710926UHC-30936-76•••-••-156714862235699CHARLOTTE.ALLEN@AOL.COM51 JEFFERSON AVENUEPhoenixAZ85025GRP-2865CORE-HMO
ENRENR-1282312026-10-10T03:58:44ZKeith—Stewart8/13/1996UHC-20256-95•••-••-4500N/Akeith.stewart67@proton.me6117 Canyon RdSacramentoCA95869GRP-0475MEDICARE-ADV-A
ENRENR-1207552026-09-28T10:48:33ZWILLIAMYCARLSON1991-12-18UHC0310832•••-••-430612307520205—4889 Willow CourtSeattleWA98148-3889GRP-8000SELECT-EPO
ENRENR-1188692026-01-15T15:17:23ZLUIS—HERRERA1981-09-07UHC-46756-89•••-••-5959·6313237828luis.herrera@outlook.com9475 MESA DRIVETucsonAZ85750GRP-5481CHOICE-PLUS-PPO
ENRENR-1303892026-03-28T19:27:04ZJACKIEXDAIZ12/28/1955UHC-15009-91•••-••-12614543731494··jacqueline.diaz40@hotmail.com5150 Central AveSan Antonio··TexasN/AGRP-2422·MEDICARE-ADV-B
ENRENR-1307432026-08-09T19:58:22ZEDWAARD—SPENCER02-03-1965UHC2163091•••-••-28427544692371edward.spencer@icloud.com2549 Apache BlvdMinneapolisMinnesota55426GRP-2868CORE-HMO
ENR ENR-1341822026-07-16T07:52:45Z·RALPH—POWELL1938-04-07UHC-62283-22•••-••-07324998154034ralph.powell@aol.comUNKNOWN—NULLN/AGRP-9342OPTIONS-PPO
ENRENR-1010562026-04-13T07:47:10ZJames—Thompson07/14/79·UHC-57559-48•••-••-6568null··james.thompson68@hotmail.com·5754 Bayshore DriveMinneapolisMN55499GRP-2654medicare-adv-a
ENR ENR-1410042026-04-21T09:33:39Z·BruceT.Garrett1962-07-12UHC-64079-01•••-••-003218223304412bruce.garrett72@hotmail.com383 CENTRAL AVENUEMiamiFL33114·GRP-9000OPTIONS-PPO
ENRENR-1156972026-07-01T23:13:14ZZachary—Knight1959-07-23UHC0356197•••-••-9022221-346-6053ZACHARY.KNIGHT23@OUTLOOK.COM6436 Grand AveCHARLOTTENC28290GRP-0791·CORE-HMO
ENRENR-1333862026-04-03T23:53:39ZYukiSBradley3/18/1968UHC-33277-67•••-••-8646441-952-6572UNKNOWN7211 Jefferson AveEden PrairieMN55360-4935GRP-9582MEDICARE-ADV-A
ENRENR-1388142026-01-30T22:05:38ZGraceU.Collins07/24/55UHC-00939-39··•••-••-63738474804969grace.collins33@gmail.com·2978 ELM STREETLos Angeles···California90040-6467GRP-4812CORE-HMO
ENRENR-1374802026-06-02T17:14:40Zcarolyn··santiago·12-07-1979UHC-60388-44•••-••-84692589087250—495 Indian School RoadDallasTX75282··GRP-1006CORE-HMO
ENRENR-1333562026-10-14T22:24:40ZJoe—Howell8/20/1964UHC-75983-70N/A(919) 601-7328joe.howell@outlook.com690 River RdPlanoTX75041GRP-2804NAVIGATE-HMO
ENRENR-1133482026-04-18T04:36:03Z—Q—19941106UHC-15235-11•••-••-2208+1 635 321 7120NULL4333 Spring StATLANTAGA·30351GRP-6280NAVIGATE-HMO
ENRENR-1173372026-08-12T21:24:59ZLuis—Rodriguez2003-04-28UHC-22104-96•••-••-1937·762-257-8773LUIS.RODRIGUEZ22@OUTLOOK.COM2126 Main StreetFresnoCA93734GRP-0206NAVIGATE-HMO
ENRENR-1119712026-04-01T17:44:52ZLawrence, JoanG··—1950-08-27UHC-41562-28•••-••-4701(732) 250-7464joan.lawrence11@gmail.com8673 Cedar LaneGILBERTAZ85271GRP-8550NAVIGATE-HMO
ENRENR-1273352026-07-01T12:41:47Zjordan—li20040113UHC-23024-76•••-••-43417958578230jordan.li@proton.me6736 Mesa DrOrlando·FL32894GRP-9184·MEDICARE-ADV-B
ENRENR-1353762026-07-09T04:48:06ZDebra—Moore··20010706—•••-••-4096231-750-8054·debra.moore@aol.com1132 Apache BlvdAtlantaGA—GRP-0695MEDICARE-ADV-B
ENRENR-1136582026-07-01T13:07:47ZMAASON—ROJAS·11/28/1947UHC-13780-94•••-••-3782·5383604408mason.rojas@outlook.com8427 Washington StreetGILBERTAZ85269GRP-6638NAVIGATE-HMO
ENRENR-1354512026-05-29T14:32:24ZMeganB.Grant01/22/1953UHC-51192-01•••-••-757216583575003·megan.grant47@proton.me9586 Forest AveGLENDALEAZ85306··GRP-0729NAVIGATE-HMO
ENRENR-1012562026-07-04T19:46:43ZCristianB··Knight—UHC-56122-73—--5667 BroadwaySAN ANTONIOTexasUNKNOWNGRP-6605NAVIGATE-HMO
ENRENR-1406252026-06-19T09:45:33ZALICE—RUSSELL1941-05-01UHC-24902-11•••-••-0181(595) 988-1793alice.russell14@hotmail.com2890 Central AveGILBERT·AZ85208GRP-8079OPTIONS-PPO
ENRENR-1061592026-02-20T01:07:02ZEmma—Morris·2007-11-25UHC-26345-16•••-••-6910401-734-7612emma.morris@icloud.com2595 Central Avenue··JacksonvilleFL32282GRP-6334medicare-adv-b
ENRENR-1256072026-04-01T21:10:04ZArjun—·Mejia03/04/1988UHC-51233-72··•••-••-0292338-878-8437arjun.mejia27@aol.com5346 MAPLE AVENUETucsonAZ85761-4590·GRP-5135navigate-hmo
ENRENR-1045732026-04-01T12:16:44ZKevin S.—Espinoza1957-12-15UHC-95455-88•••-••-65994133163222kevin.espinoza96@proton.me5811 Union StreetDenverColorado80216-3317GRP-2362·CHOICE-PLUS-PPO
ENRENR-1312712026-05-11T07:09:43Zdennis—hensen1978-01-28UHC-33795-98•••-••-5135(809) 616-0143—4616 HARBOR BLVDSacramentoCA95808GRP-0152NAVIGATE-HMO
ENRENR-1422202026-02-15T00:17:46ZFrankN·GonzalezMar 19, 1939UHC-31190-15•••-••-6773391.424.9461frank.gonzalez8@aol.com9280 HIGHLAND AVE·Chandleraz85217GRP-7902CORE-HMO
ENRENR-1308082026-07-27T09:23:00ZSCOTT—MARSHALL02/16/1985UHC-57608-82•••-••-2193+1 781 641 4872SCOTT.MARSHALL@AOL.COM—-——GRP-2018OPTIONS-PPO
ENRENR-1152502026-07-20T04:03:58ZAnthony—Reyes01/10/95UHC-11894-03•••-••-6137970-343-8330-6739 HILLCREST ROADColumbus··OH43239GRP-5271OPTIONS-PPO
ENRENR-1012342026-02-07T07:00:18Z LsaKCampbell1982-04-21UHC-60740-82•••-••-8037753.374.4759-4118 Highland AvenueNASHVILLETennessee37289GRP-7599CHOICE-PLUS-PPO
ENRENR-1163952026-02-18T16:46:11ZWAYNE—JIMENEZ1947-09-19uhc-99311-81•••-••-2545null··6566 Pine DrNASHVILLETennessee37257·GRP-7524CHOICE-PLUS-PPO
43,101 rows, page 333 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.629Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty