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-1115182026-08-18T08:06:00Z Yuki—Payne1981-03-02·UHC-49250-28•••-••-5277(478) 969-2520yuki.payne99@outlook.com348 Maple AvenueNashvilleTN37245GRP-8796MEDICARE-ADV-B
ENRENR-1232752026-05-12T20:54:56Z SANTIAGO—BANKS1990-09-21UHC-04409-41•••-••-5224·5467618163santiago.banks@icloud.com1347 Mesa DrColumbusOH43222GRP-9887NAVIGATE-HMO
ENRENR-1214032026-08-15T13:59:11ZChristianY.Castillo10/17/73UHC9789844•••-••-82446993727418CHRISTIAN.CASTILLO@PROTON.ME5226 Mountain View DriveSan DiegoCA92123-3124GRP-1516MEDICARE-ADV-B
ENRENR-1416282026-07-06T01:41:04ZChristineCGonzales1946-01-08NULL—220-720-2127CHRISTINE.GONZALES@HOTMAIL.COM5103 MOUNTAIN VIEW DRIVEAtlantaGA30303GRP-5204NAVIGATE-HMO
ENRENR-123517 2026-05-09T09:21:30Z———10/04/1988UHC9990477•••-••-2256(989) 212-3872—7873 Union StreetLas VegasNV·89162GRP-8926OPTIONS-PPO
ENRENR-1163422026-03-20T05:08:40ZShirleyEGarza02/24/1945·UHC-94800-43•••-••-3745+1 312 417 8699shirley.garza@yahoo.com3378 Maple AvenueSCOTTSDALEAZ··85265GRP-6227CORE-HMO
ENRENR-1236812026-02-13T23:41:27Z—Y.——UHC-57515-46•••-••-0042(579) 348-9459betty.martinez30@aol.com3912 Central AveLos AngelesCA·90010GRP-4271MEDICARE-ADV-B
ENRENR-1176752026-09-08T08:13:45ZEDWRAD—COOK19760325UHC-04537-80··•••-••-6867(504) 735-0885edward.cook48@hotmail.com39 Mesa Dr Apt 23Eden PrairieMN55302GRP-8365CORE-HMO
ENRENR-1259672026-06-08T09:00:02ZGuzamn, Mariana——06/03/54UHC-05958-12•••-••-252716577460469N/A·3575 HILLCREST RDColumbusOH43266GRP-5897MEDICARE-ADV-B
ENR ENR-1186612026-04-05T23:21:44ZWILLIAMQSHAWApr 14, 1996UHC-04735-42N/A+1 893 744 2699william.shaw12@proton.me·6955 Park PlaceLos AngelesCA90062GRP-7540CHOICE-PLUS-PPO
ENRENR-1359052026-01-05T09:54:10ZMAARGARET—DIAZ9152-10-15UHC-18648-63•••-••-4164616-209-6665margaret.diaz@outlook.com7146 Willow CtColumbusOH··—GRP-3813CORE-HMO
ENRENR-1078962026-01-15T16:53:16ZJOSHUABMARSHALL1942-02-26UHC-44961-96•••-••-0695321-938-2539-8078 Canyon RdMesaAZ85266·GRP-7852CORE-HMO
ENRENR-1063732026-06-26T11:13:55ZMargaretL.Little1946-07-05UHC-72661-22•••-••-147712825066976margaret.little@hotmail.com7966 Elm St Apt 13SACRAMENTOCA95895GRP-1928MEDICARE-ADV-B
ENRENR-1067912026-05-30T08:04:36Z ANNAGLUNA19-08-1999UHC3755129•••-••-7538nullN/A5012 Oak StreetJacksonvillefl32213GRP-9189MEDICARE-ADV-A
ENRENR-1178952026-09-02T09:01:42Z JOSH—YANG08/04/2006··UHC-41387-41•••-••-0246550-688-1599·UNKNOWN463 Palm DrivePLANOtx75040GRP-5297CORE-HMO
ENRENR-1405222026-04-29T07:49:22Zterry—arnoldApr 23, 1941UHC-90021-63•••-••-0920N/A·TERRY.ARNOLD@OUTLOOK.COM6184 Pine DriveSan Antonio··TX—·GRP-8966·MEDICARE-ADV-B
ENRENR-1400372026-04-17T17:36:00ZAna···Richards19740703UHC-16875-92•••-••-2153(682) 832-8923ana.richards32@gmail.com4238 MESA DRScottsdaleAZ85263GRP-4993NAVIGATE-HMO
ENRENR-1298152026-08-06T03:04:04ZERICY.ROJAS2005-01-24UHC-17335-35•••-••-6418—eric.rojas78@proton.me7821 CENTRAL AVEMiamiFL33123·GRP-5950OPTIONS-PPO
ENRENR-1087952026-06-18T09:44:11ZRichards, KellyB—1995-06-22··UHC-61615-48•••-••-22718652659128··7406 Pine Drive···OrlandoFL—·GRP-0149MEDICARE-ADV-B
ENRENR-1124652026-10-18T23:26:21ZAmberVCole1981-11-08UHC-83374-02——amber.cole69@yahoo.com1908 Bayshore Drive·Mesa·AZ85277-4007GRP-1270OPTIONS-PPO
ENRENR-1045982026-03-27T17:22:15ZCastillo, Diego——09-02-2007UHC-69309-44NULL8524490456diego.castillo50@gmail.com3312 Maple Avenue Apt 35HoustonTX77038GRP-7820CHOICE-PLUS-PPO
ENRENR-1307372026-03-25T09:08:59Ztyler—myers1947-06-12·UHC-67243-22•••-••-4378(759) 426-4749—7202 BROADWAYDenverCO80213GRP-8598MEDICARE-ADV-B
ENRENR-1385592026-07-24T20:15:41ZJenniferV.ParkerNov 9, 1977UHC-33407-88—494-659-4255jennifer.parker@yahoo.com241 Forest Avenue···AustinTX78716GRP-1715NAVIGATE-HMO
ENRENR-1399192026-06-14T14:54:24ZCynthiaR··Scott1941-05-20UHC-69323-06··•••-••-3639885-859-3158NULL875 Forest AveLas VegasNV89108GRP-3151CORE-HMO
ENRENR-1242512026-07-15T13:10:19ZKatherine—Wells06/09/60UHC-87823-78•••-••-0597754-548-4572katherine.wells@outlook.com2093 Hillcrest RdGilbertArizona85254GRP-9029SELECT-EPO
ENRENR-1429012026-06-07T15:42:04ZScott J—Mills1973-04-03UHC-95658-73•••-••-3290+1 400 544 2645UNKNOWN··5136 Desert Sky BlvdTampaFlorida33671GRP-6926OPTIONS-PPO
ENR ENR-1346882026-07-30T14:02:39ZLawrence, RoyA—1993-06-09UHC-96696-03•••-••-0098·374-964-3075UNKNOWN1251 Main StDallasTexasN/AGRP-4857SELECT-EPO
ENRENR-1292862026-01-09T13:18:25ZDeborah—Hill10/28/1941·UHC-93002-46•••-••-7883+1 402 227 3661N/A3555 Main StreetTucsonAZ85726··GRP-7157·SELECT-EPO
ENRENR-1230582026-04-03T17:29:46ZEMILY N—WILLIAMS1964-02-18UHC-97981-14•••-••-0277448-914-8549—9305 Cedar LaneAtlantaGeorgia30305·GRP-5258OPTIONS-PPO
ENRENR-1229872026-09-22T06:18:39Zbeth—ramirez1960-03-09·UHC-04023-61•••-••-5332·389-357-0823ELIZABETH.RAMIREZ78@HOTMAIL.COM9729 Market StHoustonTX77086GRP-3107NAVIGATE-HMO
ENRENR-1158762026-03-30T10:33:58ZPalmer, Daniel——19760103UHC-83334-25•••-••-3229null··DANIEL.PALMER24@OUTLOOK.COM5385 BroadwayEden PrairieMNUNKNOWNGRP-5839SELECT-EPO
ENRENR-1274742026-10-13T02:53:45Z RandyJGardner1958-06-08UHC-99224-74•••-••-8033633-291-2701randy.gardner68@aol.com·3483 PALM DRIVEChandlerAZ85291GRP-7545SELECT-EPO
ENRENR-1325182026-08-19T14:27:55ZKELLY—CARPENTER2004-07-26UHC6413181—(901) 559-7621-9304 Mountain View DrOrlandoFL32878GRP-0812SELECT-EPO
ENRENR-1081992026-08-17T06:48:28Z CHRISTOPHER—GEORGE08/04/1968UHC-66684-75•••-••-3818(959) 848-1439··christopher.george@gmail.com6132 CANYON RDPhoenixArizona85033GRP-3399··CORE-HMO
ENRENR-1034732026-04-11T18:51:11ZJENNIFER··NHENRY1968-06-10UHC-46109-60•••-••-9393296.584.9602—4536 Camelback RdOrlandoFL32843-9979GRP-9558··CHOICE-PLUS-PPO
ENRENR-1181042026-05-02T14:39:12ZCarlosRFields2005-11-05UHC-08061-71•••-••-5260UNKNOWNUNKNOWN9541 RIDGE ROADJacksonvilleFL32278-1115GRP-7938SELECT-EPO
ENRENR-1066892026-06-26T12:54:33ZJudith—Lopez05/16/02UHC-84948-25•••-••-096713307270584judith.lopez39@yahoo.com9047 BroadwayGlendaleAZ85316··GRP-1165options-ppo
ENRENR-1193292026-08-15T18:04:09ZCarlos—McDonald1/15/1967UHC-52759-39•••-••-9681(948) 398-4209—2056 Central AvePlanoTX75017GRP-4409SELECT-EPO
ENRENR-1219972026-08-03T20:49:15ZOmar—Hicks06/28/1994UHC-71644-16•••-••-4591968-202-3886omar.hicks@icloud.com1129 Indian School RdGlendaleAZ85347GRP-6450CHOICE-PLUS-PPO
ENRENR-1363412026-04-02T19:44:06ZJulieYBell1987-02-03UHC-17025-41•••-••-7534411-761-4121julie.bell86@proton.me8754 Indian School RdMesaaz85208GRP-0380NAVIGATE-HMO
ENRENR-1389432026-09-15T06:29:14ZJacob—Knight··1990-08-28UHC-87545-68•••-••-60117144005082JACOB.KNIGHT5@HOTMAIL.COM831 Oak StChandleraz85270GRP-9920OPTIONS-PPO
ENRENR-1292882026-06-25T16:23:09ZJessicaNDuncan2002-02-01UHC-72847-69•••-••-8335(596) 766-5166jessica.duncan99@gmail.com3920 Bayshore DriveOrlandoFL32874··GRP-9469OPTIONS-PPO
ENRENR-1360752026-04-27T12:07:45ZJULIA—RIVERA1971-04-24··UHC-90037-16•••-••-9506(755) 242-9720julia.rivera86@outlook.com6720 HARBOR BOULEVARDTUCSONAZ85702GRP-0713CHOICE-PLUS-PPO
ENRENR-1144342026-05-06T10:25:45ZANN—BLACK1966-05-27UHC-45653-98•••-••-7985nullANN.BLACK39@ICLOUD.COM4101 BroadwayCharlotteNC··28209GRP-8218NAVIGATE-HMO
ENRENR-1203952026-03-17T03:07:37ZPHILIPIPAYNE1950-02-15UHC-56576-45—-philip.payne@yahoo.com448 Grand AveTUCSONAZ85777GRP-6150OPTIONS-PPO··
ENRENR-1102512026-10-10T19:30:12ZJerry·YClark2007-01-04UHC-90096-08-3827912874··jerry.clark@icloud.com3732 SUNSET BLVDMIAMIFL33131GRP-6820··OPTIONS-PPO··
ENRENR-1278882026-04-16T00:15:13ZLISA—LI1999-09-23UHC-04073-64•••-••-424112314798466LISA.LI7@AOL.COM6577 Ridge RoadSan DiegoCalifornia92129·GRP-3281medicare-adv-a
ENRENR-1095892026-03-07T05:31:56ZDaniel—Garcia·Jun 10, 1961UHC-93269-80—4136142747DANIEL.GARCIA@YAHOO.COM7755 Washington St·MesaAZ··85270GRP-4462SELECT-EPO
ENRENR-1197922026-10-05T20:07:31ZMason, Kathy··C—1960-02-27UHC-94661-33•••-••-9341330-597-9501kathleen.mason41@icloud.com8572 VALLEY VIEW DRTAMPAFL33620GRP-2373CHOICE-PLUS-PPO
ENRENR-1045372026-06-06T04:29:28ZMelissaV.Pakrer11-05-1965UHC-94575-53•••-••-33148563266440melissa.parker81@yahoo.com4833 Desert Sky BlvdCharlotteNC··28272GRP-1606CORE-HMO
43,101 rows, page 15 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:34.768Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty