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
ENR ENR-1055862026-04-23T23:34:24ZJEREMYXGARRETT24-01-1978UHC-02447-65··•••-••-5494(659) 959-6810jeremy.garrett@aol.com2339 Park PlSAN DIEGOCA···92181GRP-0109MEDICARE-ADV-B
ENRENR-1207412026-01-30T11:46:25ZFuller, EmilyT—1975-06-24UHC-91168-07•••-••-67758832622974EMILY.FULLER@PROTON.ME5073 Sunset BoulevardMiamiFL33196GRP-7990CORE-HMO
ENRENR-1056622026-06-04T11:24:43ZAna U—Espinoza1996-11-19UHC-35329-82•••-••-9741909-335-5723ana.espinoza@icloud.com9821 Ridge RdPhoenix·AZ85045GRP-2413NAVIGATE-HMO
ENRENR-1180432026-03-26T23:15:25Z SarahIOliver1990-67-24UHC-32902-31•••-••-5292(228) 513-6446sarah.oliver@hotmail.com4779 UNION STREETMinneapolisMN55405GRP-1911CORE-HMO
ENR ENR-1141292026-03-04T20:13:04ZBrittanyQFwolerApr 11, 1948UHC-05869-27•••-••-3238(773) 831-1115brittany.fowler49@yahoo.com4303 Lake View RoadSan AntonioTX78274··GRP-7539·MEDICARE-ADV-B
ENRENR-1236572026-10-07T06:47:09ZNancy·OJohnston·1994-08-14UHC-13915-38•••-••-8305515.907.3098nancy.johnston@gmail.com3918 Bayshore DrPlanoTX75039GRP-9222MEDICARE-ADV-B
ENRENR-1118322026-10-17T06:02:41ZSusan—Garrett—UHC-86282-68—-··susan.garrett@outlook.com4507 Ridge RoadDenverCO80256GRP-2906OPTIONS-PPO
ENRENR-1337382026-09-21T05:57:01ZScott—Ward2005-02-15UHC-51264-75•••-••-2165922.499.8836SCOTT.WARD@HOTMAIL.COM6132 MESA DRIVESacramentoCalifornia95877GRP-3172CORE-HMO
ENRENR-1221692026-06-27T20:44:24ZisabellaT.weaver1948-01-03UHC6690885•••-••-3275+1 532 554 8845ISABELLA.WEAVER@GMAIL.COM511 Lake View RoadScottsdaleAZN/AGRP-2039SELECT-EPO··
ENRENR-1141082026-03-13T18:13:21ZhannahRrivera1967-09-15UHC-32282-46•••-••-2307—hannah.rivera82@aol.com·3233 Central AvenueAtlantaGA30309-2662GRP-0106CHOICE-PLUS-PPO
ENRENR-1227022026-08-07T13:03:53ZCHARLESS··BUTLER1971-12-12UHC-81045-69•••-••-4821·8295146067CHARLES.BUTLER26@PROTON.ME4407 HARBOR BLVDTucson··AZ85718-5668GRP-9536NAVIGATE-HMO
ENRENR-1414572026-05-23T20:31:47Z·KATEMGREENE·1968-09-02UHC-18898-91•••-••-3050·428-633-4759katherine.greene@yahoo.com2684 Union StJacksonville··FL32254·GRP-1099CORE-HMO
ENR ENR-1309022026-07-02T06:42:03ZBRUCE—WEBER02/03/75UHC9751916•••-••-2667(308) 302-9179bruce.weber72@icloud.com673 SUNSET BOULEVARDEden PrairieMN55311GRP-2626··SELECT-EPO
ENRENR-1360322026-07-04T00:07:28ZBurns, Matthew H.——1976-12-19UHC-41296-63•••-••-7855(945) 826-1763··N/A6941 Pine Dr #520Tucsonaz85753GRP-0323MEDICARE-ADV-A
ENRENR-1170882026-06-16T22:27:16Z·GRACE—FULLER1990-09-05UHC-69475-88•••-••-78102347623GRACE.FULLER51@OUTLOOK.COM523 BROADWAYSCOTTSDALEAZ··85243GRP-5047MEDICARE-ADV-B
ENRENR-1214322026-01-13T22:01:21Z·LuisBGonzalez·Apr 5, 1939UHC5303391•••-••-39519529602104luis.gonzalez82@aol.com5883 Harbor BoulevardMesaAZ85245GRP-9696MEDICARE-ADV-A
ENRENR-1248462026-09-18T16:27:05ZKarren—Phillips08/27/76UHC-16385-42•••-••-1491700.494.2434NULL6656 Washington StTempeAZ85282GRP-4162·NAVIGATE-HMO
ENRENR-1119002026-02-25T21:55:16ZFRANCES—SHMIDT23-09-1966UHC-14743-34•••-••-25193222932178frances.schmidt49@yahoo.com1285 BAYSHORE DRIVEMiamiFL33113GRP-7363MEDICARE-ADV-B
ENRENR-1102232026-05-26T02:11:05Zsamantha—carlson05/01/1974UHC-35190-77•••-••-3853699-551-9894-82 Sage CourtTAMPAFlorida33607GRP-8462·MEDICARE-ADV-B
ENRENR-1284302026-04-09T03:36:20ZJessU·Gutierrez19741027UHC-24342-90·null·(681) 786-2168jessica.gutierrez@aol.com1699 Valley View DriveLos AngelesCA90068··GRP-0136CHOICE-PLUS-PPO
ENRENR-1333812026-03-21T17:21:49Zandrea—salazar1956-08-17UHC-73205-86N/A··606.886.5263andrea.salazar@hotmail.com267 Lincoln WayTempeAZ85221GRP-5057OPTIONS-PPO
ENRENR-1332942026-01-02T13:37:46ZJEFFREYE.MYERSDec 10, 1943UHC5756928—789-814-8784··N/A2112 Forest AvenueTampaFL33669-4059GRP-6507MEDICARE-ADV-A
ENR ENR-1183102026-03-16T04:27:14ZRay·T.Gilbert1995-07-08UHC-47520-61•••-••-6377(415) 456-0807··—6778 Sage CourtPlano·TX75054··GRP-1400CHOICE-PLUS-PPO
ENRENR-1111252026-01-16T11:21:22ZKAYLA—ROBERTSONFeb 28, 1969UHC-92477-56•••-••-9319271-242-4414KAYLA.ROBERTSON@GMAIL.COM5922 Willow CourtTucsonAZ85713GRP-2109MEDICARE-ADV-A
ENRENR-1053002026-02-12T15:37:30ZLAWRENCEJELLIS1990-06-03·UHC-63165-77—·201-310-6145—2144 Washington Street···ChandlerAZ85248GRP-9427OPTIONS-PPO
ENRENR-1415182026-06-28T15:44:06ZDiegoMParkerApr 22, 2001UHC-76159-37•••-••-3262379-905-3947diego.parker68@outlook.com7998 CEDAR LNMiamiFlorida··—GRP-5616MEDICARE-ADV-B
ENRENR-1177232026-09-21T07:01:15ZADAMACARR1959-11-26UHC-44654-77····287-249-8884N/A9373 Jefferson AvenueLas VegasNV89159GRP-5054MEDICARE-ADV-B
ENRENR-1181632026-05-19T08:53:31ZJUAN—DUNN08/14/1983UHC-30571-66•••-••-25578202818606juan.dunn8@outlook.com1524 Ocean AvenueSeattle·WA98167GRP-6202NAVIGATE-HMO
ENR ENR-1076242026-07-31T02:14:18ZKEVINECARR1989-07-27UHC-04858-05•••-••-9447438.236.9200KEVIN.CARR@GMAIL.COM5062 Central AveDallasTX—GRP-1043CHOICE-PLUS-PPO
ENRENR-120687 2026-03-17T08:38:58ZTerry—Watson··1968-12-15··UHC9167764•••-••-283115534822391terry.watson62@hotmail.com9625 Market StreetSan Antonio··TX78262-1044GRP-5646options-ppo
ENRENR-1270322026-01-04T06:20:49ZOMAR··—LOPEZNov 17, 1969UHC-67709-81•••-••-974418007005328omar.lopez@outlook.com7192 Maple AveColumbusoh·43285GRP-0515OPTIONS-PPO
ENRENR-1155742026-03-23T19:36:54ZMARK—DUNCAN2007-12-02UHC-24000-64•••-••-95446412094193UNKNOWN8803 Sage CtEDEN PRAIRIEMN55375GRP-7149navigate-hmo
ENRENR-1176412026-10-11T21:02:13ZBlack, Hiroshi——05/07/1965UHC-45278-92•••-••-4714(459) 958-3599HIROSHI.BLACK99@AOL.COM4931 FOREST AVEMesaAZ85267GRP-2787SELECT-EPO
ENRENR-1291952026-01-18T19:19:10ZJAMES·EHANSON1984-11-23UHC-90765-54•••-••-26916222528462—6778 OCEAN AVEMiamiFL33117GRP-0887·MEDICARE-ADV-A
ENRENR-1006832026-08-31T18:24:57ZMariaDWheeler1968-08-13UHC-92131-92NULL943-501-5807-9013 Willow CourtTempeArizona85251GRP-6894SELECT-EPO
ENRENR-1303542026-06-05T16:42:25ZKathelenTLunaAug 22, 2003UHC-95919-91-5933020185kathleen.luna@proton.me7480 Main StreetAustinTX78740GRP-8978MEDICARE-ADV-A
ENRENR-1113602026-09-28T17:59:06ZAlice—Ellis1994-07-19·UHC-58431-90•••-••-7833N/Aalice.ellis@outlook.com7963 PARK PLACE·Charlottenc28299GRP-1513CHOICE-PLUS-PPO
ENRENR-1397842026-08-27T02:41:37ZGloria··C.Ferguson1971-01-27UNKNOWN•••-••-8313265.706.8945gloria.ferguson99@gmail.com2709 BroadwayMinneapolisMN·55427-3422GRP-3940OPTIONS-PPO
ENRENR-1339842026-09-18T00:12:46ZJordanYBlack·1968-06-13uhc-64391-75•••-••-3897(900) 946-1368jordan.black@hotmail.com3127 Desert Sky BlvdPlanoTX75063GRP-9623CHOICE-PLUS-PPO
ENRENR-1338102026-06-10T10:56:17ZPriya··EEstrada06/09/1960UHC-24843-71—(695) 606-9331UNKNOWN5612 CEDAR LNTampaFL·33673GRP-7467NAVIGATE-HMO··
ENRENR-1201232026-02-18T17:51:15ZBaker, AmyF—05/15/1967UHC-44725-60—693.992.1271UNKNOWN4115 Palm DriveCHANDLERAZ85223-8246GRP-8157navigate-hmo
ENRENR-1405082026-04-18T06:22:55Z Sophia—Kennedy1974-02-17UHC-66172-51•••-••-4143425-870-1258null7941 Cedar LaneLOS ANGELESCA90068···GRP-3970·CHOICE-PLUS-PPO
ENRENR-1110542026-08-12T05:31:02ZGloriaR.Ferguson1941-07-02UHC-59505-65•••-••-1685·-N/A362 Lake View RdCharlotteNC28233GRP-3640OPTIONS-PPO
ENRENR-1067012026-07-06T12:47:07ZJUSTIN—WONG10-01-1960UHC6679456•••-••-9684(558) 305-0718null4253 Forest AveTucsonAZ85741GRP-8685·navigate-hmo
ENRENR-1294082026-07-24T21:54:31ZMARTHA··IHAYES04/09/66UHC-66309-25•••-••-3467231-734-8464martha.hayes@gmail.com873 Bayshore Dr Apt 30PlanoTX75002GRP-0214select-epo
ENRENR-1284622026-05-27T14:46:52ZOrtega, CynthiaQ—1943-02-04UHC-81402-27•••-••-0044438-757-0627cynthia.ortega24@icloud.com8531 MOUNTAIN VIEW DRIVEAtlantaGA30311-5721GRP-1469NAVIGATE-HMO
ENRENR-1385102026-06-12T21:26:02Z·TerryQWalsh1988-02-28·UHC-20441-31•••-••-0600342-859-3118terry.walsh@icloud.com528 Willow CtSan DiegoCA92173·GRP-3945MEDICARE-ADV-B
ENRENR-1230722026-09-28T07:15:48ZAlan—Gibson2000-06-13uhc-40231-80•••-••-8177(344) 260-7218—6176 Mountain View Drive #875FresnoCalifornia93740GRP-9516OPTIONS-PPO
ENR ENR-1061102026-05-21T23:50:48ZARJUNFAUZTIN1962-11-21UHC-47172-58•••-••-1586797-478-7148arjun.austin@icloud.com1298 Union StCharlotteNC28274-5104GRP-3938OPTIONS-PPO
ENRENR-1384062026-06-27T05:33:14ZPRIYAERYAN1958-07-20UHC-22153-20•••-••-85506518353929priya.ryan@proton.me4212 WASHINGTON STREETPlano··TX75015GRP-1127MEDICARE-ADV-B
43,101 rows, page 264 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:43.419Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty