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-1340532026-04-09T10:59:45ZAguilar, LawrenceA.—10/12/2007UHC-50675-34•••-••-87536642726698LAWRENCE.AGUILAR62@HOTMAIL.COM1029 LAKE VIEW RDFresnoCA93764GRP-7353NAVIGATE-HMO
ENRENR-1238402026-03-14T19:13:43ZMarc—Hansen1940-03-12UHC1868864•••-••-53534696992761MARCUS.HANSEN79@GMAIL.COM·8183 Ocean AvePHOENIXAZ85012GRP-0174CHOICE-PLUS-PPO
ENRENR-104343 2026-07-27T15:26:44ZFord, MarkN··—02-04-1967UHC-58600-22•••-••-71573808446—8320 Willow CtORLANDOFL32879GRP-7624CHOICE-PLUS-PPO
ENRENR-1026362026-01-08T18:17:11ZBARBARA··R·JACOBS1984-08-03UHC-84370-28··•••-••-3417+1 534 369 5383barbara.jacobs54@aol.com2168 Harbor Boulevard·ScottsdaleArizona85245GRP-3536CORE-HMO
ENRENR-1349552026-04-06T21:50:34ZAustin, GloriaH—8/22/1954UHC-94923-09··UNKNOWN800-659-8478gloria.austin69@yahoo.com5801 Harbor Boulevard··FRESNO···CA93702-0322GRP-5591OPTIONS-PPO··
ENR ENR-1280652026-06-10T08:52:53ZNicole—Hansen2007-07-26UHC-66560-42•••-••-368718679179787nicole.hansen@outlook.com··8627 Elm St #742ScottsdaleAZ85221GRP-1574MEDICARE-ADV-B
ENRENR-1110232026-03-28T15:49:33ZMills, JoyceB—1971-03-28UHC-61487-56•••-••-5495(817) 374-7109joyce.mills22@outlook.com··8718 Valley View Drive #754AustinTexas78736GRP-3282OPTIONS-PPO
ENRENR-1000852026-05-01T14:54:03Z SaraRMoore19511204UHC-46190-75•••-••-6111·13209663925—2308 Park Place #539PhoenixAZ85023···GRP-2285CHOICE-PLUS-PPO
ENRENR-1162372026-04-14T10:14:21ZJanice—Young12/16/2008UHC-35860-60•••-••-049214743172599null7204 Sage Court·Los AngelesCA··90002GRP-7289CHOICE-PLUS-PPO
ENRENR-1304832026-06-16T01:47:17ZSaraKRoberts19500819UHC5236788•••-••-12515388898222SARA.ROBERTS@PROTON.ME7982 Maple AvenueFresnoCA93799GRP-3776NAVIGATE-HMO
ENRENR-1303212026-02-06T06:38:15ZMei—SanchezSep 11, 1988UHC-00404-61•••-••-2099+1 553 845 5145MEI.SANCHEZ5@HOTMAIL.COM···4230 Lincoln Way Apt 10JacksonvilleFL32225GRP-1108·NAVIGATE-HMO
ENRENR-1108042026-02-05T03:43:16ZSUSANWGUZMAN19950606UHC5951253··•••-••-6178+1 612 870 2140susan.guzman84@yahoo.com8769 Ocean AveHOUSTONTX77037GRP-9063SELECT-EPO
ENRENR-1372222026-04-13T19:45:59Z Ronald—Cole2/22/1952UHC0146769•••-••-0627382-376-7927ronald.cole@icloud.com1549 Union StreetMiamiFL—GRP-1139OPTIONS-PPO
ENRENR-1011372026-02-19T01:09:53ZAaron—Payne2611-19-69UHC-50453-48•••-••-4055(908) 954-3112null9763 Indian School RdGlendaleAZ85375GRP-8880NAVIGATE-HMO
ENRENR-1137932026-10-02T07:14:10ZMADISONFNGUYEN2002-02-01UHC2301352•••-••-6646·(868) 629-1615null4257 Ocean AveChandlerAZ85207GRP-6090MEDICARE-ADV-A
ENRENR-1395962026-05-10T22:09:14ZRobert A—Brooks2008-09-06UHC-09505-91•••-••-2221914-795-1971—7051 RIDGE ROADNASHVILLE·TN37212GRP-5008·NAVIGATE-HMO
ENRENR-1333782026-06-01T16:48:20Z———1981-06-26UHC-89323-18—3000499carlos.anderson@gmail.com1295 BROADWAYMinneapolisMN55492GRP-4481··NAVIGATE-HMO
ENRENR-1356912026-01-14T07:41:56ZCARLOS—LANE2005-05-06UHC-39751-43•••-••-4786664-509-0104CARLOS.LANE@PROTON.ME8291 Desert Sky Boulevard #828NashvilleTN37244GRP-9925SELECT-EPO
ENRENR-1390272026-04-15T21:20:50ZRICHARD····OLSON9/12/1957UHC-22683-75•••-••-55143594673RICHARD.OLSON29@YAHOO.COM9564 Pine Drive Apt 8·AustinTX78723GRP-2428core-hmo
ENRENR-1125242026-05-30T02:10:19ZBeverlyATorres19750427UHC-83323-48UNKNOWN3243824478··beverly.torres6@outlook.com279 River RoadNASHVILLETN—GRP-1606··MEDICARE-ADV-A
ENRENR-1001382026-09-10T14:44:46ZTheresa—·Foser1989-04-04UHC-69477-73——UNKNOWN507 Lake View RdHouston·TX77056·GRP-0925NAVIGATE-HMO
ENRENR-1054222026-08-07T17:28:46ZHelenDHicks1962-07-12UHC-81077-42•••-••-04917554680846helen.hicks5@aol.com6150 Cedar LaneDallas·TX75280GRP-8939OPTIONS-PPO
ENRENR-1179782026-01-09T08:44:19ZTYLERRHAREY1939-12-07UHC-67393-47•••-••-3970N/Atyler.harvey50@hotmail.com1491 CHURCH STGilbertAZ·85212GRP-1510CORE-HMO
ENRENR-1295652026-09-07T09:30:05ZRYAN—HARRISON16-11-1958UHC-72506-79•••-••-43235703612668ryan.harrison@proton.me··NULL·-N/AGRP-3110MEDICARE-ADV-B
ENRENR-1103672026-02-17T02:13:30ZNICHOLAS—OLIVER1954-11-23UHC-24004-12•••-••-1765(318) 551-4214nicholas.oliver@proton.me270 Palm DrAustinTX78719-4722GRP-9551OPTIONS-PPO
ENRENR-1049162026-05-11T17:08:43ZCynthiaMMorales1963-04-10UHC-22342-15•••-••-02454942071346cynthia.morales98@proton.me1807 Canyon RdEden PrairieMN55398GRP-4779NAVIGATE-HMO
ENRENR-1331512026-03-11T18:47:49Z·larry—li2001-07-08UHC-08701-85•••-••-6607-larry.li42@aol.com3403 Willow Court #558MiamiFL33161GRP-3456CORE-HMO
ENRENR-1429772026-03-14T19:33:48ZJuliaH.··Lawrence1969-01-26UHC-09675-16•••-••-1008(426) 242-4515julia.lawrence@aol.com1808 Sage Ct Apt 6MesaAZ85218GRP-3742OPTIONS-PPO
ENRENR-1386372026-04-28T10:35:06ZMyers, BillyV.··1989-05-09UHC-86282-87•••-••-0742+1 939 250 8107billy.myers@gmail.com6003 Oak StCHARLOTTENC28225GRP-9045CORE-HMO
ENRENR-140519 2026-03-08T13:43:55ZPadilla, MichaelA—Mar 20, 1982UHC-55203-13•••-••-33319507622111—8386 Pine DriveMiamiFL33136GRP-1199·SELECT-EPO
ENRENR-1206042026-01-07T12:44:59ZCHARLES—MATTHEWS1952-05-12UHC-71368-12•••-••-2025462-311-8794CHARLES.MATTHEWS89@ICLOUD.COM8323 Market StLos AngelesCA90080GRP-0705CHOICE-PLUS-PPO
ENRENR-1210022026-06-05T03:19:20ZJohnson, Richard——1989-11-10UHC-34667-30•••-••-0387(760) 364-3693richard.johnson@aol.com7344 Willow CourtDallasTX·75227GRP-9066OPTIONS-PPO
ENRENR-1360572026-10-12T08:30:16ZBeverlyGSatosMar 21, 1984UHC-19689-95•••-••-9950745-827-5991··BEVERLY.SANTOS21@GMAIL.COM··7505 Ocean AveFRESNOCA93736GRP-8593core-hmo
ENRENR-1344822026-01-07T16:03:48Z RUUTHU.GARCIA1950-03-07·UHC-31706-77UNKNOWN(234) 777-5141·-7453 FOREST AVE #135MesaAZ85280GRP-1418MEDICARE-ADV-B
ENRENR-1201402026-04-25T13:50:42ZFRANKUPRICE1939-07-26UHC-85448-95•••-••-6866890-672-7350frank.price27@gmail.com2566 Jefferson AvenueDenverCO··80200GRP-2051CORE-HMO
ENRENR-1389542026-07-05T05:23:35ZDebra—Wod1946-09-21·UHC-63319-04N/A·920-406-8446DEBRA.WOOD38@HOTMAIL.COM3612 Sunset BlvdHoustonTX77029GRP-9217MEDICARE-ADV-A
ENRENR-1402222026-03-02T07:43:47ZJACKN.TORRES1949-02-10UHC-14810-26•••-••-4705355-899-5888-110 Spring St··Nashville··TN37271GRP-2611MEDICARE-ADV-A
ENRENR-1262382026-04-21T05:27:12ZKimberly—Morrizon1991-05-06UHC-31666-52··—19112292031kimberly.morrison@proton.me2587 Lincoln WayDallasTX75212GRP-5658OPTIONS-PPO
ENRENR-1080512026-06-01T15:59:24ZDONALD—MEYER1987-07-10UHC-63332-29•••-••-66898529518013donald.meyer22@proton.me5980 Washington Street #386ColumbusOH43211GRP-1433medicare-adv-a
ENRENR-1406372026-07-23T03:59:50Zjeremy—sanchez1976-11-23UHC-25412-94•••-••-6632918-851-3549jeremy.sanchez@icloud.com188 Mountain View Dr·OrlandoFL·32858-8226GRP-8930CHOICE-PLUS-PPO
ENRENR-1282952026-06-07T11:54:39ZPETERZ.FORD19911023UHC-45344-03•••-••-03944835706550PETER.FORD42@YAHOO.COM3506 Central Avenue Apt 35COLUMBUSOH·43249GRP-1614choice-plus-ppo
ENRENR-1251952026-05-01T02:34:28ZJonULe-UHC-34946-14•••-••-6693·(808) 978-3259jonathan.le94@outlook.com4386 Market StreetDenverCO80254GRP-3406MEDICARE-ADV-B
ENRENR-1035532026-07-09T09:23:30ZKATHLEENUMADINA8/15/1942··UHC-06034-54•••-••-3038(820) 288-7015UNKNOWN1063 Desert Sky BlvdGlendaleaz85349GRP-7654SELECT-EPO
ENRENR-1254812026-08-28T07:41:46ZPhilip—Bradley·1959-11-21UHC-70449-36•••-••-4556(406) 891-1868PHILIP.BRADLEY43@GMAIL.COM411 SUNSET BLVDMESAArizona85242GRP-1030MEDICARE-ADV-B
ENRENR-1045102026-08-25T17:03:01ZPierce, Kathryn——1939-02-21UHC-95401-16•••-••-8786533-525-7449—9528 Washington StTAMPA··FL33628GRP-8811CORE-HMO
ENRENR-1303122026-09-05T01:44:21ZCarolynT··Wood03/10/1988UHC-07649-64•••-••-66256736242975carolyn.wood@proton.me··900 Union StreetCharlotte··NC28250-7183GRP-9810NAVIGATE-HMO
ENRENR-1280492026-10-15T14:50:17ZStephenKJimenez09/27/06UHC-39923-61-5100958STEPHEN.JIMENEZ@HOTMAIL.COM3249 Bayshore DriveDenverCO80254GRP-4656MEDICARE-ADV-B
ENRENR-1308412026-02-09T11:21:12ZButler, CherylH.—14-11-1945UHC-34460-27•••-••-05706763001291cheryl.butler13@yahoo.com6585 Bayshore DrPLANOTX75038GRP-8081·MEDICARE-ADV-A
ENRENR-1360232026-08-20T14:15:23Zsandra—murraay12/18/78UHC-66640-84•••-••-7429(413) 919-4752SANDRA.MURRAY@ICLOUD.COM··6299 Cedar LaneHoustonTX77007GRP-0259CORE-HMO
ENRENR-1294712026-07-14T08:18:02ZChristian—Peterson06/14/69UHC-46520-71•••-••-7049(476) 514-9395christian.peterson@outlook.com2683 Indian School RdEden PrairieMN55358GRP-4386NAVIGATE-HMO
43,101 rows, page 120 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:37.760Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty