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-1368762026-06-12T21:10:46ZRoyUAlexander1975-11-15UHC-29043-03•••-••-00813126321—2232 Harbor Blvd Apt 32Plano·Texas75060-4327GRP-3742CORE-HMO
ENR ENR-1204872026-09-02T22:37:32ZKenneth—Morgan05/17/1969UHC-50444-71•••-••-765518816254260kenneth.morgan92@proton.me4960 Bayshore DrDenverCO80278-6470·GRP-1004MEDICARE-ADV-B
ENRENR-1358872026-05-19T20:21:07ZCHRISTINEWGARRETT1969-08-10UHC-76492-95•••-••-3948952-305-6690·christine.garrett29@gmail.com4209 Mountain View DriveSacramentoCA95853GRP-7187CORE-HMO
ENRENR-1015102026-03-18T06:59:42ZYukiWRiley19140523UHC-96554-32•••-••-2782(391) 981-9502yuki.riley87@hotmail.com2940 Oak St Apt 23Eden PrairieMN·55332-2388GRP-5598MEDICARE-ADV-B
ENRENR-1020112026-03-10T22:35:34ZDONNAB·MYERS·1972-10-07UHC-84044-07•••-••-4656739.434.3558—6906 Desert Sky BoulevardHoustonTX77020GRP-6574NAVIGATE-HMO
ENRENR-1225642026-02-10T02:56:55ZValentina—Wood02/20/89UHC-77504-30•••-••-2901849-875-2268VALENTINA.WOOD@HOTMAIL.COM464 OAK STREETGilbertAZNULL·GRP-6909CHOICE-PLUS-PPO
ENRENR-1387412026-04-09T21:54:16ZBruce—Black13-05-1996UHC0998064•••-••-14315085030697bruce.black@aol.com1170 Cedar LnSeattleWA98165GRP-0542MEDICARE-ADV-B
ENRENR-113697 2026-02-21T15:51:00ZAlexis—Jensen11/16/1957UHC-14285-46•••-••-3395·17613710994UNKNOWN6234 CAMELBACK ROADTAMPAFL—GRP-8812··CORE-HMO
ENRENR-1173472026-06-10T23:09:46Z Ann··XFields1946-01-03UHC-32591-81•••-••-5486280-282-4556ANN.FIELDS@YAHOO.COM···5259 Valley View Drive Apt 22TempeAZ·85241-0735GRP-8426CHOICE-PLUS-PPO
ENRENR-1191152026-01-20T00:36:24ZMARIANA—WALKER1961-05-06UHC-44172-99•••-••-8570(700) 969-0386N/A9604 River RoadCHARLOTTENC28243GRP-3217MEDICARE-ADV-A
ENRENR-1207972026-08-09T22:50:00ZMichelleX··Schultz1971-05-14UHC-74086-57•••-••-6608745-315-1463michelle.schultz@icloud.com4881 Lincoln WayScottsdaleAZ85245GRP-5103NAVIGATE-HMO
ENRENR-1187882026-02-27T17:07:56Z·VirginiaG·Delgado1938-11-13UHC5104762•••-••-9206(401) 687-9568—3315 River RdGLENDALE·AZ85367·GRP-1495OPTIONS-PPO
ENRENR-1208612026-01-03T19:35:14ZoliviaH.padilla1995-12-15UHC-47897-98•••-••-264315552423144OLIVIA.PADILLA22@AOL.COM6726 Harbor Blvd··MesaAZ85229GRP-1200NAVIGATE-HMO
ENRENR-1388972026-05-04T15:10:11ZAUSTIINOGORDON1964-09-27UHC-50210-62NULL··(387) 591-0563AUSTIN.GORDON83@AOL.COM9313 Highland Ave #115JACKSONVILLEFL32240GRP-0594CHOICE-PLUS-PPO
ENRENR-1066432026-01-31T22:56:27ZTIMOTHY—LOPEZ1/15/1946UHC-58975-81•••-••-5496513-672-6619—9308 Meadow LaneNASHVILLEtn37271GRP-8535CHOICE-PLUS-PPO
ENRENR-1365342026-10-03T06:04:51Z Shirley—Peters11-02-1944UHC-75203-23•••-••-4321209-405-3323shirley.peters@outlook.com3271 HARBOR BLVDPhoenixAZ85076GRP-5207OPTIONS-PPO
ENRENR-1385232026-01-27T11:41:37ZSANNDRA—HOWELLAug 19, 1940··UHC-73536-31•••-••-0743—sandra.howell78@hotmail.com6709 Desert Sky BlvdFresnoCalifornia93797GRP-0837SELECT-EPO
ENR ENR-1289662026-03-09T11:57:02ZDoris—Bryant19430304UHC-72776-91•••-••-4136679-628-2594null8905 Mountain View DriveOrlandoFL32863GRP-1153·CORE-HMO
ENRENR-1286582026-04-12T05:22:53ZMichelle——·1987-05-23UHC-91927-63•••-••-70412016381151michelle.martinez@gmail.com272 Meadow LaneOrlando··FL32800GRP-9181··NAVIGATE-HMO
ENRENR-1375422026-10-16T06:25:39ZDylan·O.Payne11/11/1958UHC-58863-01—·561.658.8443—3721 Sunset BoulevardLos AngelesCA··90098GRP-2170CORE-HMO
ENRENR-1240412026-03-12T20:16:45ZRoger—Wright1976-12-50UHC-73325-10•••-••-68883656015148··roger.wright@outlook.com3969 Desert Sky Boulevard··ColumbusOH43258GRP-4454SELECT-EPO
ENRENR-1078462026-09-11T08:06:57ZDIEGOFLAWRENCE1973-07-13UHC-54929-35•••-••-184114054655253UNKNOWN7690 Park PlaceColumbusOhio43263··GRP-7992CHOICE-PLUS-PPO
ENRENR-1278172026-08-27T18:18:22ZKathleenSSantiago1943-10-11N/A•••-••-26335027555551··kathleen.santiago@aol.com3108 Apache BlvdLas VegasNV89163-2074GRP-9707CHOICE-PLUS-PPO
ENRENR-1360812026-08-24T16:17:59ZEmmaXDiaz1979-08-04UHC-52882-72•••-••-7697——3374 Spring StFresnoCA··93773GRP-2348NAVIGATE-HMO
ENRENR-1295552026-01-26T14:46:04ZAnrdewH.Burton1970-08-05UHC8840612•••-••-8518474-214-5016andrew.burton@proton.me4315 Camelback Road··TampaFL33642·GRP-5141MEDICARE-ADV-A
ENRENR-1330542026-10-13T07:56:26ZDONNA—SCOTT··19861211UHC-62612-35•••-••-8348-donna.scott36@aol.com1923 Ocean AveNashvilleTN37221-0471GRP-5370MEDICARE-ADV-A
ENRENR-1088352026-08-20T11:30:25ZJessica—·Reynolds9/28/1996UHC-43535-05•••-••-7982—jessica.reynolds77@gmail.com6963 Bayshore DrEden PrairieMN—GRP-1603CHOICE-PLUS-PPO
ENRENR-1237552026-08-07T12:54:45ZdeniseDpadilla-UHC-91088-69•••-••-1590906-568-5160··3946 Union StreetSAN ANTONIOTX78296GRP-8270CHOICE-PLUS-PPO
ENRENR-1363832026-10-16T15:38:31ZValdez, Mark····—·1980-03-27UHC-55520-85•••-••-1068695-814-4014-9126 Main StreetOrlandoFL32880·GRP-1587CORE-HMO
ENRENR-1091052026-03-15T11:26:36Z AUSTIN—WALSH10/21/2006UHC-77688-70··-(691) 485-5247··—8506 Bayshore Dr Apt 16CharlotteNC28227GRP-3910CHOICE-PLUS-PPO
ENRENR-1199882026-04-26T09:10:18ZLisaD.Shaw06-08-1989UHC-91238-33—(745) 258-8793lisa.shaw@aol.com3486 Elm St Apt 6SAN DIEGOCA92141GRP-6791MEDICARE-ADV-A
ENRENR-1314552026-06-08T02:27:02ZPatriciaQ.Ross05/22/49UHC-68744-18•••-••-2117+1 775 851 1395patricia.ross@aol.com52 DESERT SKY BLVD #609·GlendaleAZ85394···GRP-6642CORE-HMO
ENRENR-1227792026-02-12T03:42:56ZpattersonDsusan1965-07-08UHC-88196-46•••-••-6941(254) 237-8376null·3112 Valley View DrPHOENIXAZ85051···GRP-0238·MEDICARE-ADV-B
ENRENR-1057112026-05-14T11:05:08ZMarianaSDelgado1989-10-06UHC-41386-07•••-••-2654882-658-8091mariana.delgado@icloud.com516 Maple AvenueORLANDOFL32818GRP-1743SELECT-EPO
ENRENR-1041412026-04-24T09:56:36ZJeryrNWashington01-08-2001UHC-80565-05•••-••-9819866-794-6715JERRY.WASHINGTON@PROTON.ME9241 Church StreetCHARLOTTENorth Carolina28264GRP-5772NAVIGATE-HMO··
ENRENR-1258892026-02-18T05:14:18ZSamuelNFields2/1/1973UHC-70900-77•••-••-0357690-822-9153UNKNOWN2094 DESERT SKY BLVDFresnoCAnull··GRP-0117MEDICARE-ADV-A
ENRENR-1201432026-01-22T21:40:58ZZACHARY··IARMSTRONG23-07-1981UHC-82590-28•••-••-0260(592) 816-8777N/A3933 Market StMiamiFL33141GRP-0735CORE-HMO
ENRENR-1199182026-02-21T23:56:09ZSCOTT—MARSHALL2006-04-02UHC-64439-72•••-••-7494+1 549 886 4722scott.marshall@gmail.com728 Grand AvenueChandlerAZ85223··GRP-5472CORE-HMO
ENRENR-1362862026-01-04T20:35:28ZWLLIEDNGUYEN11/23/1987UHC-05114-92•••-••-6145+1 832 299 2306····9795 Highland AveSan DiegoCA92196-3205GRP-0362NAVIGATE-HMO
ENRENR-1138412026-02-26T09:57:02ZYUKI—POWELL1971-05-24·UHC-46195-87•••-••-4585·+1 851 223 7099YUKI.POWELL91@ICLOUD.COM·402 LINCOLN WAYGlendaleAZ85390GRP-1049CORE-HMO
ENRENR-1087192026-09-21T14:08:05ZRAYMOND—RODRIGUEZ1980-09-11uhc-81501-18•••-••-3220——6125 Meadow LnDenverCO80288GRP-1700CHOICE-PLUS-PPO
ENRENR-1184122026-06-04T19:34:13ZDonaldK.Kennedy1971-11-23UHC-11082-55•••-••-02228536735200DONALD.KENNEDY@PROTON.ME340 Meadow Ln Apt 28GilbertAZ85232GRP-8150select-epo
ENRENR-1305372026-09-04T23:57:10ZBILLYXFISHER1981-08-20UHC-80053-21•••-••-6154935-435-1554billy.fisher@icloud.com696 Union StNashvilleTN37259-8234GRP-2072CORE-HMO
ENRENR-1095142026-10-12T15:06:18Z·Julia—George1959-01-27UHC9164503•••-••-2430469-498-1212null2430 Valley View DriveCHARLOTTENC28221GRP-6506MEDICARE-ADV-A
ENRENR-1113842026-03-08T08:46:52ZEmma—Woods1944-02-10UHC-82950-72•••-••-1375213-644-5034emma.woods97@icloud.com3686 Washington StDenver··CO80255GRP-5336MEDICARE-ADV-A
ENRENR-1231912026-10-14T11:34:34ZANNNRODRIGUEZ1989-03-16UNKNOWN···9863070956NULL3104 Willow CtSeattleWA98165GRP-8814OPTIONS-PPO
ENRENR-1112472026-05-27T11:40:58ZHanson, BobbyO—2001-03-07·UHC-43003-27•••-••-0328+1 989 479 1841··bobby.hanson@icloud.com5986 FOREST AVEHOUSTONTXnullGRP-5493CHOICE-PLUS-PPO
ENRENR-1073382026-07-04T11:26:08ZGeorge, Arthur——1979-07-14UHC-27469-48•••-••-81165108137191arthur.george18@hotmail.com6880 CENTRAL AVESan AntonioTX78239GRP-1143CHOICE-PLUS-PPO
ENRENR-1135792026-01-23T01:07:56Z·Hanson, Fatima——1988-07-20UHC-50584-60•••-••-3150942-808-6270fatima.hanson@outlook.com·1122 Lincoln WaySan AntonioTX·78290GRP-0812·OPTIONS-PPO
ENRENR-1045542026-08-04T16:52:18ZCooper, AngelaH—1989-03-23UHC-93181-59•••-••-26292496975163angela.cooper@hotmail.com1514 VALLEY VIEW DR #369HoustonTX77057··GRP-1483CORE-HMO
43,101 rows, page 116 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.756Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty