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-1033852026-03-14T20:07:07ZDiaz, Vicky——1957-01-10UHC-79441-31•••-••-841917335998370UNKNOWN5666 Lake View RoadScottsdaleAZ85241·GRP-6562MEDICARE-ADV-B
ENRENR-1203562026-09-15T00:33:20ZTomas—Wells1960-10-26UHC-10836-37•••-••-2924808-855-5493NULL323 Mountain View DriveSeattleWA98114GRP-6836NAVIGATE-HMO
ENRENR-1127772026-03-08T23:57:40ZjonathanMpatel19611221UHC-08496-08··•••-••-1305247.834.8380—4336 Desert Sky BoulevardGlendaleAZ85381-6891GRP-8528MEDICARE-ADV-B
ENRENR-1399552026-04-24T10:45:12ZJoan··Medina1968-02-10UHC-51846-88··•••-••-8635nulljoan.medina@hotmail.com4462 Oak StreetOrlandoFL32890GRP-1695MEDICARE-ADV-B
ENRENR-1402202026-07-08T10:55:34ZBurke, FrancesL····2000-04-23UHC-81574-06•••-••-79547667435344frances.burke7@gmail.com2627 Desert Sky BoulevardMesaAZ··85270GRP-3386CHOICE-PLUS-PPO
ENRENR-140069 2026-02-06T08:56:05ZEspinoza, Luri··—10/10/1971UHC-27604-26•••-••-2400334-463-5852UNKNOWN7801 Lincoln WayMesaaz85227GRP-1628CHOICE-PLUS-PPO
ENR ENR-1059972026-09-30T01:03:51ZRACHEL·PWHITE··1942-40-06··UHC-15447-80•••-••-0563695-305-6272rachel.white51@hotmail.com7519 BROADWAYCharlotteNC28223GRP-8230SELECT-EPO··
ENRENR-1298542026-08-12T08:44:12ZBRUCEWWELLS1978-11-17UHC-75374-68•••-••-5177545-799-8325bruce.wells69@yahoo.com7373 Pine Drive Apt 23CHARLOTTENC28233GRP-1061OPTIONS-PPO
ENRENR-1152562026-06-04T07:26:55ZWheeler, BrandonP—1981-12-18UHC-40767-81•••-••-5318-N/A·3670 Sunset Blvd Apt 30Los AngelesCA90072GRP-8438MEDICARE-ADV-B
ENRENR-1026842026-01-09T09:11:31ZJordan—Burton1954-08-28UHC-73034-90··•••-••-8484(978) 666-8728N/A8433 Washington StTempeAZ85288-7620GRP-3788··CORE-HMO
ENRENR-1396402026-07-03T16:50:36ZGARY—RYAN8/20/1965··UHC-78295-18•••-••-24059823933418GARY.RYAN@AOL.COM3177 Canyon RoadTucsonAZ85783GRP-6088OPTIONS-PPO
ENRENR-1364072026-10-17T23:07:30ZBARB—KIMNov 12, 2001UHC-55893-69•••-••-2265(973) 299-9256NULL1784 CENTRAL AVEMiamiFL33189GRP-1045MEDICARE-ADV-B
ENRENR-1395822026-04-24T14:30:21ZOliver, Samuel——1955-11-01UHC-84083-21•••-••-3638423-648-0086samuel.oliver@gmail.com9710 Meadow LaneAustinTX78763GRP-0936MEDICARE-ADV-A
ENRENR-1002162026-05-22T20:56:23ZKATELJAMES08/09/1979UHC-89876-40•••-••-2614855-558-0302NULL8854 Highland AveTempeAZ··85251GRP-4912MEDICARE-ADV-A
ENRENR-1344612026-05-09T12:06:27ZGeraldMPierce1971-05-06·UHC-42939-55•••-••-2510823.938.1658gerald.pierce@outlook.com7921 Canyon Rd·NASHVILLETN37254GRP-2008CORE-HMO
ENRENR-1103272026-03-30T11:36:59ZJANICE····SIMPSON1998-06-25UHC-35061-94•••-••-9629287-924-4771JANICE.SIMPSON68@HOTMAIL.COM1668 Harbor BlvdSan AntonioTX78254GRP-6532·NAVIGATE-HMO
ENRENR-1186602026-07-14T05:45:11ZTHERESA—GIBSONOct 28, 2003··UHC-34116-59•••-••-33538578897482theresa.gibson85@aol.com2229 OCEAN AVENUEAtlantaGA30322GRP-1242OPTIONS-PPO
ENRENR-1283132026-03-18T07:08:13ZmarilynRhawkinsAug 22, 2002UHC7003240•••-••-9641646-713-5533UNKNOWN7537 Pine DriveTempe··AZ··85255GRP-5992SELECT-EPO
ENRENR-1365802026-03-07T17:13:53ZWill—Patterson19530302UHC8703679—+1 624 519 9885william.patterson@aol.com9271 Oak StreetTempeArizona85291GRP-9650CHOICE-PLUS-PPO
ENRENR-1246532026-03-25T01:27:18Zjustin—martinez1958-09-07UHC-20070-18•••-••-8362NULL—2972 Jefferson AveNashvilleTN37229GRP-0475NAVIGATE-HMO
ENRENR-1034872026-03-30T09:33:51ZStone, IsabellaE—06/14/83UHC6298941•••-••-2811787-719-0635ISABELLA.STONE21@ICLOUD.COM··7196 Apache BoulevardScottsdaleAZ85245GRP-5252MEDICARE-ADV-A
ENRENR-1186862026-06-16T12:59:57ZMoore, ScottT—08/28/1998UHC-13818-41•••-••-1415486-220-8580SCOTT.MOORE65@HOTMAIL.COM4379 Valley View Dr··Mesa··AZ85225GRP-1879SELECT-EPO
ENRENR-1259552026-09-30T07:14:42ZMateoN.Ray1950-10-15UHC-92614-81•••-••-6615975-313-7911MATEO.RAY@PROTON.ME7044 Camelback RoadLas VegasNV89158GRP-7359MEDICARE-ADV-B··
ENR ENR-1232342026-04-01T20:36:18ZJones—Brian10/24/1959UHC-05308-73··•••-••-7270·(299) 473-4601UNKNOWN2328 Pine DriveSan AntonioTexas78267-5924GRP-9977SELECT-EPO
ENRENR-1218272026-08-13T19:39:30ZBeverlyDWodos1399-08-26UHC-61084-84NULL(420) 686-7407beverly.woods88@hotmail.com715 WILLOW CTChandlerArizona85277GRP-5122CORE-HMO
ENRENR-1073992026-04-07T18:43:59ZTimothy U····Garza08/01/1945··NULL•••-••-3075+1 827 481 8046timothy.garza13@hotmail.com2981 Union StColumbusOH43274GRP-6893MEDICARE-ADV-A
ENRENR-1351832026-07-26T19:13:15ZJoeC.Harvey03/07/70UHC2315220•••-••-5174605.402.3698N/A7400 Spring StreetOrlandoFL·32890GRP-8059OPTIONS-PPO
ENRENR-1291002026-06-11T22:35:35ZJoyce·KReynnolds1963-10-28UHC-87463-27•••-••-3723+1 422 208 1837JOYCE.REYNOLDS63@AOL.COM3813 Harbor BlvdSacramento·ca95891GRP-7577CHOICE-PLUS-PPO
ENRENR-1116512026-07-14T08:38:44ZSandra Q.··—Chapman1995-06-04UHC-73111-95•••-••-2575795-619-7401NULL2754 MEADOW LANESan Antonio··TexasnullGRP-0638··NAVIGATE-HMO
ENRENR-1367602026-07-12T23:00:46ZJake··—McDonald·Mar 22, 1976UHC-16655-87•••-••-3885720-490-8175··jacob.mcdonald@outlook.com730 CENTRAL AVESan AntonioTX78242GRP-0341SELECT-EPO
ENRENR-1079902026-07-11T21:11:56ZJulie—Vasquez09-04-1970UHC-46484-67•••-••-6425+1 921 449 1102JULIE.VASQUEZ14@OUTLOOK.COM··3365 Willow CtSacramentoCA95816GRP-5006··SELECT-EPO
ENRENR-1341562026-06-05T21:19:05ZAustinNAmy·06/06/1990UHC-02417-71null6523145799amy.austin@icloud.com·8232 Mountain View DrNashvilleTN37235GRP-9046MEDICARE-ADV-A
ENR ENR-1369312026-09-02T13:16:34ZANA··NCOOKNULLUHC-77205-44•••-••-2114+1 581 825 8142—8193 RIDGE RDTempeAZ85251GRP-6570CORE-HMO··
ENRENR-1354202026-02-08T12:35:21ZANDREATCUNNINGHAM1943-06-09UHC-36872-64•••-••-1068(733) 431-7270andrea.cunningham@icloud.com976 Bayshore DrAtlantaGeorgia30365GRP-7668MEDICARE-ADV-A
ENRENR-1288262026-03-01T23:31:37ZRuthZSandoval1984-05-06UHC-67569-41•••-••-9328+1 413 860 3758··RUTH.SANDOVAL93@YAHOO.COM1894 Mountain View DriveLas VegasNV89130GRP-3120CORE-HMO
ENRENR-1237292026-03-03T10:44:00ZJAMES··SANDERS2000-11-24UHC-81882-91•••-••-4327(697) 677-5359james.sanders41@yahoo.com2275 Sage Court··MinneapolisMN55472GRP-2932CORE-HMO
ENRENR-1160862026-05-06T13:44:32ZNatalieBMedina27-05-1987··UHC1343191•••-••-18815157806512natalie.medina26@icloud.com6608 Maple AvenueCharlotteNC28262GRP-9888NAVIGATE-HMO
ENRENR-1142062026-02-05T10:10:31ZWILLIAMM.HERRERA··6102-19-88UHC-27008-72•••-••-28489832620UNKNOWN1009 Church StMinneapolisMinnesota55447GRP-3972CORE-HMO
ENRENR-1183622026-04-18T13:44:57ZVictoriaZReyes·1942-11-19UHC-44741-92•••-••-7140716-395-6279—4114 Highland AveGILBERT··AZ85241GRP-9603NAVIGATE-HMO
ENRENR-1103992026-10-11T07:02:03ZVincentV.Palmer1969-09-01UHC-31592-87•••-••-39223394498328··VINCENT.PALMER@YAHOO.COM6694 Market StSeattleWA98173GRP-7173MEDICARE-ADV-A
ENRENR-1397212026-01-25T15:25:33ZDiane—King·19570801UHC-90667-34•••-••-9277(714) 906-1011diane.king92@hotmail.com··864 CHURCH STREETFresnoCA93762GRP-4762SELECT-EPO
ENRENR-1319722026-06-01T08:13:52ZMASON··O··KELLEY··1980-09-23UHC-70526-07—400.967.4880mason.kelley98@gmail.com176 Lake View RoadCharlotteNorth Carolina28224GRP-3716MEDICARE-ADV-B
ENRENR-1038962026-09-05T07:03:51ZJohnRFerguzon2/16/1940UHC-93817-92•••-••-2468(580) 618-1576·-3561 Ocean AveLos AngelesCA90042GRP-8223MEDICARE-ADV-A
ENRENR-1079672026-06-01T05:56:58ZGregory····Boyd1959-04-06UHC-93839-18•••-••-2484(760) 488-5676—9511 Harbor Blvd #259ScottsdaleAZ85203GRP-7931SELECT-EPO
ENRENR-1401512026-02-20T02:20:59ZCarpenter, NancyO.—1980-06-07UHC-82726-77•••-••-9817(659) 664-3853nancy.carpenter@gmail.com7629 OCEAN AVE·DallasTX75246GRP-8129CORE-HMO
ENRENR-1273492026-07-04T04:00:29ZmendozaVlaura2001-04-10UHC-72770-86•••-••-9120935-850-9932····5539 Ocean AvenueMESAAZ··85297GRP-6383SELECT-EPO
ENRENR-1425332026-01-01T19:53:49ZRonald—Cox1990-48-04·UHC-07390-48•••-••-922015279622987RONALD.COX@HOTMAIL.COM1782 Camelback RdScottsdaleArizona85231GRP-4509OPTIONS-PPO
ENRENR-1202042026-08-09T21:43:55ZBrinSCartter1941-08-02UHC-24566-93•••-••-5457·2693307044brian.carter@hotmail.com4200 VALLEY VIEW DRLos AngelesCalifornia90014··GRP-2313MEDICARE-ADV-A
ENRENR-1321572026-05-23T16:02:21ZGLORIAV.NELSON11/15/1954UHC-53720-31•••-••-4098(340) 613-6886—152 Sunset BlvdOrlandoFL32847-9125GRP-8750MEDICARE-ADV-B
ENRENR-1039992026-10-08T19:40:37ZJUDITH···BROWN05/09/2002UHC-51197-10•••-••-03069838068975JUDITH.BROWN89@HOTMAIL.COM3207 MAPLE AVENUE Apt 15ScottsdaleAZ85295GRP-1023CHOICE-PLUS-PPO
43,101 rows, page 305 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.597Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty