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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1392982026-09-24T02:33:05Z JACOB··M.JORDAN09/08/1958UHC-33868-33—(421) 675-9993jacob.jordan@aol.com5985 LAKE VIEW RDMIAMIFL33131GRP-3068MEDICARE-ADV-B
ENRENR-1304902026-07-04T11:36:19Z ChristopherF.Guzman19850201UHC-36360-94•••-••-3995(358) 421-6614christopher.guzman95@proton.me4117 River RoadMiamiFL33169GRP-8430CHOICE-PLUS-PPO
CLMCLM-4016132026-05-27T05:44:50ZANA—ROBERTS1973-01-18UHC-57213-03N/A757.267.8141—9756 Lincoln WayMesaArizona85221GRP-9417CHOICE-PLUS-PPO
ENRENR-1038022026-07-27T17:42:38ZKim—JacobsJan 28, 1969UHC-81813-82•••-••-8744865.301.1418kimberly.jacobs1@hotmail.com184 Jefferson Ave Apt 26··TempeAZ85241GRP-1426OPTIONS-PPO
CLMCLM-432237 2026-04-13T12:37:44ZCARL—WEST·1992-01-06-UNKNOWNnull—3663 GRAND AVE Apt 38GlendaleAZ85353GRP-1270NULL
ENRENR-1065682026-07-07T05:43:08ZMarthaVWillis19660720UHC-62076-92•••-••-1825866.912.6245martha.willis60@outlook.com3212 BAYSHORE DRIVEGLENDALEArizona85351GRP-1686MEDICARE-ADV-B
ENRENR-1091562026-06-19T03:12:47ZJUAN—BURTON1964-08-28UHC-41210-57•••-••-0507304.930.6488JUAN.BURTON86@GMAIL.COM7543 RIDGE ROADLos Angeles·CA90005GRP-5985CHOICE-PLUS-PPO
TPATPA-550632026-09-15T02:15:27Z·lucia—bailey1938-08-26UNKNOWN-—LUCIA.BAILEY@AOL.COM··5146 MEADOW LNPlanoTexas75054GRP-4492—
ENRENR-1090762026-01-07T16:24:10ZDOROTHYS.NUNEZ16-01-1975UHC2758332•••-••-25637503396160dorothy.nunez@icloud.com5049 SPRING STREET Apt 28MinneapolisMN—·GRP-2968CHOICE-PLUS-PPO
CLMCLM-4318012026-09-11T00:12:37ZAnn—Alvarado1984-07-11—nullN/ANULL4414 HARBOR BOULEVARDSan DiegoCA92123GRP-8856··N/A
TPATPA-582112026-10-04T01:52:26ZDebra—Ortega1998-11-09NULL——UNKNOWN——nullUNKNOWN——
CLMCLM-4261462026-07-25T17:07:27ZDianaRMills1989-02-06UHC-78735-87UNKNOWNnullnull5029 Union StreetLos AngelesCA90053NULLMEDICARE-ADV-B
ENRENR-1046282026-09-07T04:28:09ZMARILYNZ.ELLIOTTMay 15, 2008UHC-08946-09•••-••-0178+1 212 878 3719MARILYN.ELLIOTT@ICLOUD.COM1704 UNION STREETAtlantaGeorgia30342GRP-6960MEDICARE-ADV-B
CLMCLM-4103882026-04-21T01:46:23Z JEREMY··—COOK1948-08-19N/A•••-••-6215NULL-null····-NULLGRP-7088null
ENRENR-1417792026-03-25T05:49:26Z SARA—MCCOY1938-02-24UHC-49462-80•••-••-1513825-556-2765UNKNOWN7050 Forest Avenue Apt 25CharlotteNC··28281GRP-9853OPTIONS-PPO
ENRENR-1100722026-04-01T15:44:12ZJustinC.Aguilar1963-01-19UHC-83597-02•••-••-3965(362) 873-2648justin.aguilar45@yahoo.com1260 Canyon RoadLas VegasNV89131GRP-5158MEDICARE-ADV-A
CLMCLM-4240612026-03-28T14:55:04ZJones, Luis——1984-04-14UNKNOWN··•••-••-8577331.547.3919N/A2214 Washington StATLANTAGA··30344—UNKNOWN
ENRENR-1336952026-07-06T02:37:28Z GeorgePWalker09/24/72UHC-24290-02•••-••-9042502-313-5191GEORGE.WALKER81@GMAIL.COM6940 Valley View DriveScottsdaleAZ··85207GRP-9446NAVIGATE-HMO
CLMCLM-4189532026-09-06T01:50:06ZOAR—HUNT1938-05-20UHC-97434-51··•••-••-3893454.362.9865—9314 BAYSHORE DRIVELos AngelesCAN/A—NAVIGATE-HMO··
ENRENR-1404572026-02-15T18:50:43ZMelissa—Patterson1982-09-23UHC-00168-06•••-••-6711537-799-7633melissa.patterson71@aol.com6288 HARBOR BOULEVARDAustinTexas78721GRP-1062MEDICARE-ADV-A
ENRENR-1063592026-08-20T06:24:32Z·MARCUSU·HART1981-31-13UHC-36017-42•••-••-8036437-352-6442N/A3873 LINCOLN WAYGilbertAZ85279GRP-2733CORE-HMO··
CLMCLM-4142052026-07-26T12:21:36Z·Heather—Simpson—UHC-44129-07•••-••-817217052744371null4087 APACHE BOULEVARDPlanoTX75005GRP-3464CORE-HMO··
ENRENR-1116812026-08-14T13:27:06ZSophia—Morrison17-10-1992·UHC-12669-51•••-••-3746761-615-3445sophia.morrison89@yahoo.com1780 Bayshore Dr·TampaFL33663GRP-1538MEDICARE-ADV-A
CLMCLM-4229372026-05-09T05:25:28ZCooper, Kathryn··U—21-09-1979UHC-84332-55——KATHRYN.COOPER18@OUTLOOK.COM2370 RIDGE ROADMesaAZ85215GRP-2309MEDICARE-ADV-B··
CLMCLM-413004 2026-02-11T09:33:20ZMateoEBarnes··1954-02-13—null759-849-8133··null—·UNKNOWN-NULLGRP-5709UNKNOWN
PRVPRV-202862026-04-25T02:10:24ZCarlWSandoval01-04-1998nullUNKNOWN···895-907-3972CARL.SANDOVAL@ICLOUD.COM1075 Elm StreetPlanoTX75032-0735-null
CLMCLM-4316612026-06-09T04:38:19Z·JAMES—PORTER1948-06-18UHC-83196-09-(793) 383-5208JAMES.PORTER@OUTLOOK.COM8111 Ocean AveAtlantaGA30316GRP-4066MEDICARE-ADV-A
ENRENR-1301422026-01-23T17:09:06ZMASONLESSPINOZA1994-02-10uhc-05793-04··•••-••-0483—mason.espinoza19@hotmail.com8800 SAGE COURTEDEN PRAIRIEMinnesota55358GRP-3269MEDICARE-ADV-A
TPATPA-605102026-05-21T13:21:07ZMason—Ros1980-07-07null—705-245-7259-8660 Central AveHoustonTX77095-MEDICARE-ADV-B
ENRENR-1248542026-10-02T21:33:22Z·Mitchell, EthanT—Aug 17, 1954uhc-64818-21•••-••-5636293-852-4806ethan.mitchell@gmail.com4533 VALLEY VIEW DR··Atlanta·GA30372-6106GRP-4191CORE-HMO
ENRENR-1364922026-04-05T15:23:15ZCATHERINEKJONES2003-04-07UHC-34408-38•••-••-22087004956362catherine.jones@icloud.com311 Willow CourtJacksonvilleFL32259GRP-6984CORE-HMO
ENRENR-1308672026-08-03T12:45:42ZRebeccaTRodriguez1996-06-08UHC7212301•••-••-64284757714074rebecca.rodriguez59@gmail.com1058 Lake View Rd #652DenverCO80214GRP-8141MEDICARE-ADV-A
CLMCLM-4279492026-09-27T12:38:47ZLauren—Howard2005-04-18-null(782) 435-3526····9045 HARBOR BLVDMinneapolisMN55437GRP-1520··UNKNOWN
CLMCLM-4296252026-01-07T12:27:04ZSusan—Williams2000-06-23-•••-••-92123679071705—4391 Lincoln WayDALLASTX75284GRP-2127SELECT-EPO
CLMCLM-4218762026-07-31T21:40:07ZmariaHsimpson·12/22/2008·UHC-29411-66•••-••-8653nullNULL2468 Union StreetHoustonTexas77056—MEDICARE-ADV-B
ENRENR-1058612026-03-20T16:07:35ZAUSTIN··Y·FRANKLIN1986-06-21UHC-79654-26•••-••-4138225.564.8574austin.franklin78@yahoo.comnull—nullUNKNOWNGRP-0619OPTIONS-PPO
PRVPRV-293792026-07-21T19:16:45ZJONATHEN—BISHOP··1998-06-24UHC-27890-40NULL(725) 300-8403JONATHAN.BISHOP@HOTMAIL.COM5797 Desert Sky BlvdMesaAZ85215——
ENRENR-1235692026-03-04T02:56:55ZBRADLEY—HERRERA20060210UHC-52427-22•••-••-44717925801384-··3645 Mountain View DrScottsdale··az85286GRP-0273OPTIONS-PPO
ENRENR-1217532026-06-21T05:45:01ZMeiT.Le07/21/42UHC-19059-48•••-••-2456584-543-9885N/A1892 FOREST AVESacramentoCA95827GRP-4800MEDICARE-ADV-A
ENRENR-1294702026-03-26T23:17:50Z·KEVINM.GORODN1971-10-03UHC-08655-80•••-••-1055(356) 646-0420-1100 UNION STREETChandler·AZ85281GRP-0574MEDICARE-ADV-A··
CLMCLM-4097482026-05-17T18:24:12Z Jeremy—Kim1942-09-06UHC-94680-42UNKNOWN··NULL—6877 Apache BoulevardFresnoCA93792GRP-0575OPTIONS-PPO··
ENRENR-1131562026-07-26T19:26:20ZTimothyBBennett1999-12-06UHC-36770-15·null—·timothy.bennett19@proton.me·8571 BAYSHORE DRIVESan DiegoCA92178GRP-6664SELECT-EPO
ENRENR-1162952026-09-16T00:07:42ZDiegoM.Montgomery1959-10-22UHC-93543-76•••-••-12993663529557·diego.montgomery@gmail.com5307 JEFFERSON AVENUEFresnoCA93719GRP-6940CHOICE-PLUS-PPO
CLMCLM-4275342026-06-17T07:29:03ZChristian—Meyer2007-04-25··-N/A—christian.meyer63@yahoo.com2940 INDIAN SCHOOL RDDALLASTX··75216UNKNOWNNULL
CLMCLM-4102672026-08-04T04:14:02ZMichael B—Evans2006-09-04N/A··•••-••-8105+1 914 583 7414N/A8354 Maple AvenueORLANDO·FL32856GRP-6224-
CLMCLM-4046372026-10-18T16:12:32ZSophia—Howell28-04-1997UHC-51733-01NULL-··N/A2377 APACHE BOULEVARDSAN DIEGOCA92144GRP-3482—
TPATPA-546942026-04-04T17:47:08Z·BrandonQArmstrong1959-11-13—•••-••-4269N/A—2641 Apache BlvdDenverCO80281nullNULL
ENRENR-1317992026-05-01T05:29:59ZSophia, ScottF—1949-03-16UHC-50442-67•••-••-6121(343) 629-7675—3828 Palm DrCharlotteNC28283GRP-7933SELECT-EPO
TPATPA-581542026-05-31T04:24:40Zjonathan—phillips1973-02-12N/AUNKNOWN922-548-4648-984 Union StreetTempeAZ85206GRP-6734CHOICE-PLUS-PPO
PRVPRV-215792026-06-18T07:39:42ZCHARLOTTEHBERRY1943-02-28UNKNOWN•••-••-3833——-UNKNOWN—N/AUNKNOWN·UNKNOWN
100,000 rows, page 87 of 2,000PreviousNext

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:34.799Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty