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-1186652026-03-31T03:05:33ZMaryKGonzales1974-06-02UHC-08721-40•••-••-7567(803) 580-4897mary.gonzales@aol.com164 Main StreetMINNEAPOLISMN55467GRP-0293CHOICE-PLUS-PPO
ENRENR-1245122026-09-27T22:13:50Z·ShirleyW·Miller1971-04-22UHC-18949-27•••-••-1674274-538-7623UNKNOWN7511 PINE DRIVEFRESNOCA·93791GRP-6288navigate-hmo
ENRENR-1332612026-09-17T23:12:08ZEmilyGGibson··1986-01-08UHC-40847-14··—695.730.7328NULL1442 Grand AveMesaArizona-GRP-3727SELECT-EPO
ENRENR-1400822026-01-30T17:56:08ZEVELYN··TESPINOZA1952-10-01··UHC-30331-27•••-••-5796381-525-0704evelyn.espinoza25@gmail.com·1743 Church StreetTempeAZ85297GRP-9807··SELECT-EPO
ENRENR-1136782026-05-27T06:55:22ZSusan—Young—·UHC-38795-15•••-••-1190698-328-4700susan.young@yahoo.com8550 Valley View Drive·ColumbusOH43295GRP-3352SELECT-EPO
ENRENR-1228382026-04-02T13:31:38ZJudyZ.Pierce1991-02-15UHC-76830-07•••-••-2968(710) 641-0167judy.pierce@hotmail.com2875 Maple Ave #757San AntonioTX78239GRP-1592OPTIONS-PPO
ENRENR-1307792026-06-16T13:07:00ZBrittanyH.Lucas09/03/1994··UHC-07347-22•••-••-1923426-462-2616brittany.lucas97@icloud.com1018 Spring StreetLas VegasNV89108GRP-9690MEDICARE-ADV-A
ENRENR-119167 2026-02-06T17:00:38Z·AshleyQHarris06/21/43UHC-26122-25•••-••-86279619622NULL·9314 Mountain View DrCHARLOTTENC28222GRP-5160CORE-HMO
ENRENR-1122892026-10-07T06:51:58ZARTHUR—RYAN1946-06-09UHC-65502-89•••-••-8848——8034 SPRING STREET Apt 40PLANO·TX75097GRP-0558CORE-HMO
ENRENR-1018662026-10-03T20:13:50ZREBECCA—·JACOBS·1993-02-24·UHC2759954•••-••-96869668486900rebecca.jacobs96@hotmail.com7259 Highland AvenueJacksonvilleFL32237GRP-0317NAVIGATE-HMO
ENRENR-1173072026-07-04T13:17:18ZROYPSMITH07-01-1945UHC-64287-90•••-••-679914653773812roy.smith@hotmail.com·5453 MARKET STScottsdaleAZ85283GRP-7075··CHOICE-PLUS-PPO
ENRENR-1387262026-10-02T23:31:39ZjuliaBlucas1981-07-20UHC-72844-78•••-••-3030321-559-2607··504 Sunset Boulevard·MinneapolisMN55447-8213··GRP-5818CHOICE-PLUS-PPO
ENRENR-1381262026-01-08T03:17:52Z·DIANAE.HUNTER8/4/1979UHC-94261-15•••-••-9223(355) 293-8225UNKNOWN5523 Central AvenueTampaFL33646GRP-7135CHOICE-PLUS-PPO
ENRENR-1224192026-05-27T04:13:00ZOLIVIAKBRADLEY1950-11-05UHC2184225•••-••-3975(505) 806-7939olivia.bradley@aol.com293 Grand AveSacramentoCA95873GRP-5659medicare-adv-b
ENRENR-1383012026-03-09T11:55:34ZBarnes, Sandra——19411111uhc-80935-12•••-••-51778986438361SANDRA.BARNES49@OUTLOOK.COM7153 Bayshore DriveHoustonTX··77031GRP-2499CORE-HMO
ENRENR-1281012026-08-23T19:05:25ZRoonald····Guerrero1953-09-22UHC-63884-96·N/A814-994-9320ronald.guerrero2@hotmail.com8347 Market StreetScottsdaleAZ85262-9527GRP-0201OPTIONS-PPO
ENR ENR-1369352026-08-22T09:26:32ZLarson, LoganJ.—4/19/1945UHC-56916-28•••-••-5682986-688-7457LOGAN.LARSON50@YAHOO.COM6157 Forest AvenuePhoenixAZ85053GRP-1264OPTIONS-PPO
ENRENR-1263802026-04-09T15:56:09ZJuan··EPadillaOct 21, 2003·UHC-00148-63—(724) 413-5479juan.padilla49@icloud.com2287 Cedar LnSan AntonioTX78260GRP-3055MEDICARE-ADV-B
ENRENR-1019822026-02-20T20:56:37ZChristine—Snyder08/27/89UHC-44691-78—5494319437N/A4544 Park PlMinneapolisMN55485GRP-7002CHOICE-PLUS-PPO
ENRENR-1326992026-10-18T08:11:32ZAlan—FergusonMar 1, 1942UHC-70793-11··•••-••-2711(716) 242-6654··—8978 Grand AveEden PrairieMN55362GRP-1573SELECT-EPO
ENRENR-1089192026-07-22T10:35:50ZMARIAGSANDERS1986-12-25UHC-61145-08•••-••-9080814-783-6511maria.sanders@icloud.com6348 Oak StNashville··tn37213-6406GRP-1761CORE-HMO
ENRENR-1140842026-10-16T02:21:57ZParker, WalterD—1996-06-10UHC-95006-08•••-••-6919233-784-0073walter.parker@hotmail.com1424 MEADOW LANEOrlandoFL32829-4198GRP-0903MEDICARE-ADV-A
ENRENR-1294942026-09-29T03:51:36ZRobertNMarquaz1905-08-05UHC-09983-43•••-••-8017450-993-3499·ROBERT.MARQUEZ@ICLOUD.COM590 PALM DRIVEScottsdaleAZ85200··GRP-2960MEDICARE-ADV-A
ENRENR-1186202026-04-09T22:38:55ZCarroll, Yuki··—1984-02-14uhc-32478-05•••-••-7581-null1033 Sunset BoulevardLos Angeles··CA90090GRP-3452SELECT-EPO
ENRENR-1204512026-10-04T22:38:51ZCarol—NguyenNov 7, 1938UHC-68465-42•••-••-5519nullcarol.nguyen@icloud.com5202 MESA DRGilbertAZ85230GRP-4622OPTIONS-PPO
ENRENR-1385932026-09-06T07:23:44ZTYLERXCOOPER1978-07-28UHC-33489-43•••-••-03253384025265·NULL2837 Meadow LnSeattle··WA98145GRP-2401OPTIONS-PPO
ENRENR-1104602026-02-20T12:54:43ZNoah—Rios1948-12-27UHC-35984-76•••-••-1333773.253.7701noah.rios@proton.me3981 Camelback RdSacramentoCalifornia95842GRP-2291CORE-HMO
ENRENR-1114162026-07-01T16:18:32Z·Mary····George1953-01-20UHC-99908-37··•••-••-3771(487) 372-6314·MARY.GEORGE@GMAIL.COM1674 SAGE CTDenverCO80255GRP-5498··SELECT-EPO
ENRENR-1323472026-03-20T12:28:57ZBobby····Dominguez19411003UHC-88594-28•••-••-267316393923334NULL7266 JEFFERSON AVELos AngelesCA90069GRP-8340CORE-HMO
ENRENR-108458 2026-03-25T02:03:08Z·Kelley, AaronF—1972-04-19UHC-36205-79—·NULL-909 Forest AveGLENDALEAZN/AGRP-6123NAVIGATE-HMO
ENRENR-1096132026-07-18T03:32:30ZMICHAELJBISHOP1994-10-07UHC-91419-82•••-••-2131828-667-2415michael.bishop17@yahoo.com8711 Apache Boulevard #216Los AngelesCA90058GRP-7123CORE-HMO
ENRENR-1157632026-03-15T06:39:48ZSofia—Dominguez19900428··UHC-08240-73•••-••-6429—sofia.dominguez88@icloud.com3643 Spring StreetSeattle·WA98183GRP-2844SELECT-EPO
ENRENR-1034722026-06-22T03:40:43ZCharlotte—Vega1998-05-09UHC-89390-17•••-••-60617429017713charlotte.vega@icloud.com4803 Ridge RdSAN ANTONIOTX78259GRP-4831CHOICE-PLUS-PPO
ENRENR-1089182026-02-13T05:39:59ZCamilaIBurke2008-01-17··UHC-01880-25··•••-••-7135886-324-6004—3340 Market Street Apt 22Minneapolis·MN55483GRP-4474CORE-HMO
ENRENR-1269552026-02-22T21:27:37ZCHRISTINA—ARMSTRONG1977-06-05UHC-85233-33UNKNOWN6675606643christina.armstrong@hotmail.com7060 Park Place #181Las VegasNV89113GRP-2735options-ppo
ENRENR-1386152026-03-12T05:59:07ZMASON—TAYLOR2001-07-19UHC-83381-43•••-••-0984276-740-8425··MASON.TAYLOR@GMAIL.COM1473 BAYSHORE DR··Phoenixaz85093-3216GRP-4804NAVIGATE-HMO
ENRENR-1241392026-02-18T21:03:31ZHanson, Russell··F—1997-11-13UHC-68963-83•••-••-27856919514431—3692 CEDAR LNHoustonTX··77004-8843·GRP-1145MEDICARE-ADV-B
ENRENR-1002762026-08-01T23:33:35ZDANIELELCGORDON10/25/1993UHC-68096-32•••-••-3237(876) 602-4887null1327 Hillcrest RdAustinTX78725GRP-5871OPTIONS-PPO··
ENRENR-1034482026-02-16T18:33:23Zterry—elliott1980-07-19·UHC-19456-25•••-••-1302+1 681 269 6009terry.elliott63@gmail.com5002 Palm DriveFRESNO·CA·93752GRP-6104CORE-HMO
ENRENR-1113342026-09-01T07:15:01ZTYLER—MCDONALD22-11-1947UHC4757441•••-••-2051(755) 436-2224—2865 BroadwaySan AntonioTX··78223GRP-5950SELECT-EPO
ENRENR-1014662026-04-26T10:03:23ZCHRISTOPHERUMONTGOMERY20020421UHC-85412-78··•••-••-7475nullchristopher.montgomery22@outlook.com3292 APACHE BLVDTampaFL33623·GRP-5759CORE-HMO
ENRENR-1341082026-10-05T03:18:42ZAmber··—Morris1978-06-06UHC-84590-84—657-534-6125amber.morris@proton.me6085 BROADWAYCHARLOTTENC28271GRP-4686SELECT-EPO
ENRENR-1246332026-03-30T23:54:00ZJohn—Henderson1977-06-20UHC-90386-33····4096066200john.henderson76@aol.com5437 MEADOW LANEMesaAZ85215GRP-9223navigate-hmo
ENRENR-1019912026-07-05T18:21:55ZMelissa—CollinsJun 14, 1975UHC-84977-60•••-••-4259+1 713 885 5434melissa.collins13@yahoo.com5013 Hillcrest RoadGlendaleAZ85354GRP-8622SELECT-EPO
ENRENR-1116992026-10-18T01:20:50ZSUSANFRAMOS1956-05-03UHC7505704•••-••-70289329504277susan.ramos@hotmail.com7939 Forest AvenueMESA·AZ85276GRP-3630SELECT-EPO
ENRENR-1377512026-05-11T06:15:22ZANNA—BOWMAN2007-03-24UHC-89187-82•••-••-1275(529) 576-2468anna.bowman@yahoo.com3232 SPRING ST Apt 23··ORLANDOFL32810··GRP-0406CORE-HMO
ENRENR-1295802026-03-31T05:39:26ZDAVIDSJENKINSJul 15, 1989··UHC-74186-15•••-••-8528383.841.3658david.jenkins30@outlook.com2280 Union StreetLos Angeles·California90094GRP-9622CHOICE-PLUS-PPO
ENRENR-1321902026-02-21T16:25:51ZCARLOSMKELLEY1953-04-04·uhc-04610-58—(964) 327-8543carlos.kelley@outlook.com3081 Pine DriveHouston·TX77077GRP-2263medicare-adv-a
ENRENR-1243512026-08-01T17:57:34ZRoger—Boyd27-11-2007UHC-05609-11•••-••-4758+1 215 421 6642roger.boyd86@outlook.com··5693 CENTRAL AVESCOTTSDALEArizona85295GRP-4735CORE-HMO
ENRENR-1333742026-06-10T10:06:34ZBveerly—Sandoval1987-01-04UHC7169315•••-••-3193(609) 822-4981BEVERLY.SANDOVAL42@OUTLOOK.COM2141 Meadow LaneGLENDALEAZ85312GRP-5074SELECT-EPO
43,101 rows, page 213 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:40.355Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty