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-1375162026-09-23T06:51:44ZSarahQMunoz1966-11-09UHC-67066-47null+1 318 665 0437N/A6749 Market Street Apt 13ScottsdaleAZ85256GRP-5589SELECT-EPO
ENRENR-1020602026-08-18T07:31:26ZHansen, Terry——1956-10-09UHC-59896-66null·479-889-8424·terry.hansen@aol.com9836 Camelback RdGilbertAZ85294GRP-6811OPTIONS-PPO
ENRENR-1318652026-04-07T21:00:33ZHeatherSBroooks1978-07-08UHC-62227-54•••-••-127818225878741heather.brooks@hotmail.com8233 INDIAN SCHOOL ROADPLANOTX75008GRP-7260NAVIGATE-HMO
ENRENR-1039982026-02-11T21:13:11ZKim—Parker2002-12-14UHC8789622•••-••-0955881-676-8176··—7164 ELM STCHANDLER··AZ85227GRP-9085OPTIONS-PPO
ENRENR-1289902026-01-18T09:03:58Z CHERL—GRAYJun 11, 1988UHC-43431-50•••-••-5201(247) 515-9521cheryl.gray86@outlook.com6466 Desert Sky Blvd··SEATTLEWA98172GRP-1786NAVIGATE-HMO
ENRENR-1251442026-02-04T16:32:00ZCHRISTINE····BANKS··1957-10-20·nullN/A246.249.9743christine.banks86@yahoo.com1950 Valley View Dr Apt 16Tempe·AZ85220GRP-1517NAVIGATE-HMO
ENRENR-1305612026-03-29T23:47:10ZDeborahM·Clark1985-04-10UHC-43310-10··•••-••-3533+1 233 414 5134deborah.clark@proton.me1310 RIVER ROAD Apt 38FRESNOCA93750GRP-5601OPTIONS-PPO
ENRENR-1109502026-05-14T18:03:36ZCox, Grace——3/19/1962UHC-73907-70•••-••-3340(835) 351-9760grace.cox10@gmail.com6003 Sunset BlvdGilbertAZ85254GRP-2201CORE-HMO
ENRENR-1153902026-01-01T23:45:50ZPATRICK—FLORES1988-01-24UHC-57340-93•••-••-92565786280882-6167 Oak StreetCharlotteNorth Carolina28236GRP-7040CORE-HMO
ENRENR-1272772026-08-04T15:02:36ZCheryl—Castro·2/18/1950UHC-49263-97null940-585-1023·cheryl.castro92@aol.com9227 Church St··OrlandoFL32896GRP-8321options-ppo
ENRENR-1402562026-06-30T01:43:43ZJudith—Schultz1988-10-24UHC-26690-16•••-••-59292745662670judith.schultz37@proton.me1867 Pine DriveHouston·TX77077GRP-4712MEDICARE-ADV-B
ENRENR-1009492026-05-22T16:53:29ZMATEO···QDUNCAN1972-01-23UHC-05875-18•••-••-8579(855) 473-1562MATEO.DUNCAN@OUTLOOK.COM709 Central AveChandlerAZ85283-2391GRP-5544CORE-HMO
ENRENR-1127002026-01-02T09:52:57ZNathanDLe1939-01-27UHC-46456-17•••-••-62894853381706NATHAN.LE@AOL.COM3318 CANYON ROADTampaFL33616GRP-5322·MEDICARE-ADV-A
ENRENR-1207132026-03-27T22:14:00ZWells, Brian——2001-07-16UHC7895131•••-••-1653343-352-6611··—7743 Market StTampaFLN/AGRP-8239OPTIONS-PPO
ENRENR-1333532026-04-30T16:44:29ZcarlosSwarren19920509UHC-59200-38•••-••-0356498-404-6008NULL7605 Grand AvenueLas VegasNV·89166GRP-0594MEDICARE-ADV-A
ENRENR-1100122026-01-28T00:54:55ZBruceQSanchez·0832-19-53UHC-82303-65•••-••-55734242703589bruce.sanchez31@icloud.com990 Palm DriveSan DiegoCA92179GRP-0210MEDICARE-ADV-A
ENRENR-103309 2026-06-07T23:17:46ZWEI··CLRAK2007-07-01UHC-60024-70•••-••-1149735-206-7863wei.clark@gmail.com··1609 Jefferson AveCHANDLERAZ85228GRP-2398NAVIGATE-HMO
ENR ENR-1229652026-05-25T07:17:45ZCHARLOTTE—DUNCAN19891108UHC-98897-59•••-••-6459454.918.3873CHARLOTTE.DUNCAN@YAHOO.COM9268 Valley View DrColumbusOH43264GRP-5933OPTIONS-PPO
ENRENR-1029362026-01-18T08:35:23ZVincentZ.Mendez1961-01-26UHC-37352-01•••-••-6424+1 344 671 4778vincent.mendez@yahoo.com721 Sunset BoulevardMesaArizona85220GRP-3808MEDICARE-ADV-A
ENRENR-1071332026-06-20T02:06:48ZElijahQ··Cox1986-06-28UHC-15378-08NULL+1 708 755 0164N/A5551 Main St #267JACKSONVILLEFLN/AGRP-6667options-ppo
ENRENR-1297062026-04-14T08:20:40ZFRANKYPATEL03/24/1973UHC-81497-86•••-••-3286278.605.2891-2646 Sunset Blvd #194San DiegoCA··92126GRP-6381CORE-HMO
ENRENR-1028022026-05-02T11:52:21ZCHARLES··WONG··02/01/1963UHC4610378•••-••-1611(545) 468-4159null2646 BROADWAYMiamiFL33116GRP-3834SELECT-EPO
ENRENR-1088472026-10-09T12:08:59ZCarlO.Owens1/10/2001UHC-24250-02•••-••-0995824-307-1686carl.owens57@proton.me1298 Forest AveMinneapolisMN55498GRP-5075SELECT-EPO
ENR ENR-128848 2026-02-06T23:14:01ZJESSEV.WEST11/25/46·UHC-82874-61•••-••-7776(941) 821-8477··JESSE.WEST@HOTMAIL.COM6026 Hillcrest RoadDenverCO··80256GRP-4251medicare-adv-a
ENRENR-1294332026-07-21T01:04:03ZCharlesQ·Medina5/16/1965UHC-94822-28•••-••-087216287550851NULL8165 Sunset BlvdHoustonTX77091GRP-3071SELECT-EPO
ENRENR-1295962026-06-16T09:30:06ZJeses—·Ortega18-08-2008UHC-92424-45•••-••-6905+1 228 391 4020jesse.ortega@icloud.com2245 Palm Dr·AtlantaGA30323GRP-6492MEDICARE-ADV-A
ENR ENR-1167372026-10-18T10:59:09ZHiroshiX.Dunn1991-12-08UHC-40843-84nullnullHIROSHI.DUNN78@AOL.COM3236 Market St·AtlantaGA30373-8764GRP-5775NAVIGATE-HMO
ENRENR-1418132026-08-31T16:46:10ZDaniels, NatalieK.—1951-11-18UHC6735443•••-••-1070(654) 304-9510natalie.daniels@yahoo.com1690 Pine DrEden PrairieMN55375GRP-8260SELECT-EPO
ENRENR-1062412026-02-15T01:33:05ZAmanda P—WardFeb 23, 1970UHC-44504-28··UNKNOWN3816714921UNKNOWN177 Park PlaceCOLUMBUSOH·43278GRP-6179SELECT-EPO
ENR ENR-1287112026-01-21T12:35:22ZDIANAAFOXApr 15, 2007UHC4134777——UNKNOWN6924 Church StreetTampaFL33606GRP-9024MEDICARE-ADV-B
ENRENR-1118472026-08-18T12:18:39ZArjunQRios1960-01-03UHC-79934-17•••-••-8214(457) 589-2079arjun.rios74@gmail.com5434 Union StreetChandlerAZ85290GRP-5468CHOICE-PLUS-PPO
ENRENR-1105872026-01-17T09:15:35ZSophia—Peters·0133-19-43UHC-41273-98•••-••-4309—N/A1565 Bayshore DrScottsdaleAZ85283GRP-6614CHOICE-PLUS-PPO
ENRENR-1429412026-01-01T07:07:59ZJACKW.KELLY1977-05-26UHC-23475-39•••-••-8717(918) 957-2815·JACK.KELLY91@ICLOUD.COM·6237 Harbor BoulevardSeattleWA98176GRP-0984MEDICARE-ADV-A
ENRENR-1238132026-10-03T13:14:40ZNancy····Silva08-02-1963UHC4758439····7956663061null——-··GRP-9636CORE-HMO
ENRENR-1258282026-07-01T06:06:12ZChristine—Clark02/23/1968UHC-92710-43•••-••-04424999413··christine.clark@yahoo.com··4908 ELM STLos AngelesCA90011GRP-1478MEDICARE-ADV-B
ENRENR-1196732026-09-20T13:42:37ZandreaVholmes11/07/1945UHC-14059-46N/A····andrea.holmes@hotmail.com4112 Sage Court·DALLASTX75221GRP-9584NAVIGATE-HMO
ENRENR-1114792026-03-02T12:51:56ZCharlotteQ.Howard1971-02-16UHC-13369-06•••-••-2329(755) 210-2737charlotte.howard62@outlook.com5047 Elm St··GlendaleAZ85366GRP-8684CHOICE-PLUS-PPO
ENRENR-1358262026-09-12T09:51:03ZMarkSMontgomeryMay 1, 1969UHC-77120-18•••-••-4584362-427-8460MARK.MONTGOMERY@YAHOO.COM5341 Canyon Road··MiamiFL33105GRP-8987··OPTIONS-PPO
ENRENR-1048062026-07-24T19:56:09ZparkYjonathan09-01-1983UHC-23547-97•••-••-425719109207532—457 SUNSET BLVDScottsdaleAZ85264GRP-9401navigate-hmo
ENRENR-1187062026-03-11T16:26:47ZBRIANIOLSON12/23/98UHC-06706-21•••-••-96945364276399brian.olson@icloud.com8779 Bayshore Dr··JacksonvilleFL32216GRP-7292OPTIONS-PPO
ENRENR-1086382026-07-10T23:15:43ZRACHEL—RIVERA24-02-1971UHC-18995-25•••-••-0722····—5236 OAK STREETCharlotte·ncNULLGRP-2809CHOICE-PLUS-PPO
ENRENR-140274 2026-02-23T08:44:04ZMATTHEW—BARNES·14-12-1970UHC-50903-12—(977) 514-3867matthew.barnes@hotmail.com2666 Indian School RdDallasTX75221GRP-1795MEDICARE-ADV-A
ENRENR-1087822026-01-18T16:00:58ZKatherineMJimenez27-01-1997UHC-63280-35•••-••-2431+1 611 869 3960··3414 Market StreetDENVERco80291GRP-3859SELECT-EPO
ENR ENR-1210362026-03-31T14:31:15ZSANTIAGOYOWENS1982-11-24UHC-49699-73•••-••-354614815453554N/A2544 Harbor BlvdOrlandoFL32862-4212GRP-9955SELECT-EPO
ENRENR-1294602026-10-03T04:11:57ZJESSICA·IREED1945-08-10UHC-81057-51•••-••-3515N/ANULL3048 Cedar LnMINNEAPOLISMN55466GRP-7730CORE-HMO
ENRENR-1139512026-07-27T16:14:54ZDOUGLAS··AOBRIEN9157-02-05UHC-06611-98N/A970-317-5716UNKNOWN8787 Central Avenue·ATLANTAGA30382GRP-9081SELECT-EPO
ENRENR-1353252026-02-21T13:46:27ZCarolyn—·Williamson1948-01-27UHC-33058-22•••-••-4688627-687-7752—1659 Hillcrest Road··Eden PrairieMinnesota55313··GRP-5328MEDICARE-ADV-A
ENRENR-1223082026-09-26T09:32:25ZWalterC·Robinson1690-09-03NULL•••-••-8602954-988-8327walter.robinson@aol.com9442 Jefferson AvenueTAMPAFL33652GRP-8477SELECT-EPO
ENRENR-1418602026-02-07T23:22:13ZDonaldHHill2002-06-09UHC-38228-20null-donald.hill10@proton.me··3153 Church StAtlantaGA—GRP-4657OPTIONS-PPO
ENRENR-1270122026-02-23T14:35:40ZSalazar, MarthaQ—6/10/1982UHC-04503-85•••-••-6779613-400-8412—8402 Pine DrPlanoTX··N/AGRP-4450CORE-HMO
43,101 rows, page 136 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:38.459Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty