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-1179872026-01-28T07:05:27ZSusanCGardner1968-04-27UHC-08142-93•••-••-5792(918) 968-6080susan.gardner@aol.com5508 Pine Drive #675CharlotteNC28231-4000GRP-7143OPTIONS-PPO
ENRENR-1053712026-07-03T18:18:35ZDiane··Alvarado09/08/63UHC-11604-87UNKNOWN521-401-1544—649 Bayshore Dr··PhoenixAZ85030-2976GRP-5019··CORE-HMO
ENRENR-1402652026-04-23T07:28:20ZGaryM.Willis05/06/86UHC-32252-95•••-••-9027(975) 334-7724—4272 River RoadMiami·Florida33195GRP-6435MEDICARE-ADV-B
ENRENR-1019052026-03-28T00:21:18ZOLIVIASCARROLL1979-07-19UHC5931082•••-••-83499138838310null3195 HARBOR BOULEVARDNashvilleTN··37255GRP-8782··CHOICE-PLUS-PPO
ENRENR-1047642026-06-06T14:03:55ZJOE—BISHOP1987-04-18UHC-19037-06•••-••-16877062877314JOE.BISHOP60@OUTLOOK.COM69 Highland AvenueTampaFL33678·GRP-8230·NAVIGATE-HMO
ENRENR-1293792026-01-13T02:48:32ZJoseph—Carter15-12-1979UHC-97279-29•••-••-7475253-738-3919JOSEPH.CARTER44@GMAIL.COM3938 DESERT SKY BLVDChandlerAZ85231GRP-6717OPTIONS-PPO
ENRENR-1147072026-10-02T13:49:45ZKEITHBJONES1/16/1956UHC8447819•••-••-2151NULLUNKNOWN4325 Church StGilbertAZ85296GRP-7605NAVIGATE-HMO··
ENRENR-1145692026-09-05T23:02:48Zhenry—peters4/15/1946UHC-24087-69•••-••-0606290.877.9119—7036 Central AvenueTempeAZ85230GRP-3012CHOICE-PLUS-PPO
ENRENR-1272912026-09-19T13:53:53ZMaarkQ·Chen1961-09-23UHC-64993-34null—N/A5207 Maple Avenue Apt 12Dallas··TX·75204GRP-3546CORE-HMO
ENRENR-1069432026-09-13T05:25:42ZjuanFthomas··1951-05-14UHC-16020-03•••-••-1043(640) 423-2827juan.thomas77@yahoo.com2865 Sunset Boulevard Apt 12·HoustonTX77066GRP-7560MEDICARE-ADV-A
ENRENR-1214872026-01-24T02:25:53ZVALENTINA—HARVEY19790411UHC-55797-03•••-••-9425262.369.6114··valentina.harvey18@yahoo.com3650 RIVER RDAustinTX78759GRP-2178MEDICARE-ADV-A
ENR ENR-1149742026-04-09T17:48:59ZCharlesCBryant06-02-1969UHC-01319-03•••-••-9978421.614.0249CHARLES.BRYANT@HOTMAIL.COM5690 LINCOLN WAY Apt 26SACRAMENTOca—GRP-4007MEDICARE-ADV-B
ENRENR-1398342026-01-30T01:19:44ZWayne—Bryant1973-10-07UHC9283808•••-••-5925(275) 323-8938WAYNE.BRYANT98@ICLOUD.COM·3838 Hillcrest RoadMesaaz85255-3415GRP-8452SELECT-EPO
ENR ENR-1356962026-09-17T20:24:40Z·EDWARD—HENRYApr 14, 2005UHC-72922-81•••-••-6708+1 663 682 5496edward.henry40@aol.com4759 Ridge RoadNASHVILLETN37238GRP-4407MEDICARE-ADV-B
ENRENR-1361632026-09-14T14:08:06ZSalazar, AlexisA—2003-10-05UHC-58806-09•••-••-7767—ALEXIS.SALAZAR@GMAIL.COM———nullGRP-6593NAVIGATE-HMO
ENRENR-1156402026-07-25T05:22:01ZJESSEHMARTIN1958-10-04UHC-46287-43•••-••-68343535740530—2119 Pine DriveLas VegasNV89193-3299GRP-4131OPTIONS-PPO
ENRENR-1359702026-01-04T21:51:40ZGary—·Carpenter05/20/2001UHC-56195-73•••-••-3079(561) 285-9176gary.carpenter47@aol.com··9370 Main StreetSACRAMENTOCA95842GRP-5432SELECT-EPO
ENRENR-1108362026-03-15T00:37:50ZSarah—Spencer20010611UHC-56619-38•••-••-0834+1 729 682 2004sarah.spencer7@outlook.com1763 RIDGE ROADEden PrairieMN55316GRP-1156MEDICARE-ADV-A
ENRENR-1420802026-06-12T16:23:17ZFoster, Edward——1959-01-26UHC-59926-49•••-••-48294526056··—9708 Cedar LnMESAAZ85247-6933GRP-4418NAVIGATE-HMO
ENR ENR-1218172026-06-24T17:01:43ZEuugeneMSingh1945-07-21··UHC-27220-84•••-••-8027288.379.4777eugene.singh@proton.me806 MESA DRNASHVILLE·TN37275GRP-3555NAVIGATE-HMO
ENRENR-1420252026-05-19T10:55:15ZJordanHKing1988-12-18UHC-47443-28•••-••-8141453-707-5331jordan.king@hotmail.com·4951 PALM DRIVE #526·Tampafl33609GRP-1864NAVIGATE-HMO
ENR ENR-1369212026-09-15T17:51:43ZBruce··—Garrett1950-06-24UHC-17603-90•••-••-2246415.554.8487—9636 Bayshore DriveColumbusOH43299GRP-0331MEDICARE-ADV-B
ENR ENR-1292452026-10-01T03:19:46ZKAYLA—WALSH19670310UHC-98490-89•••-••-374316857711358KAYLA.WALSH@GMAIL.COM·8522 Lake View RdTucsonAZ85705GRP-1474CHOICE-PLUS-PPO
ENRENR-1168432026-03-26T04:40:15ZteresaGreynolds1957-06-02·UHC-27736-33•••-••-21912096971136N/A6445 PARK PLACEPlanoTX75029-7816GRP-0429NAVIGATE-HMO
ENRENR-1360102026-02-04T15:19:18Z·VIRGINIA—CHAVEZ22-09-1973UHC-84832-35•••-••-64072923942388virginia.chavez70@aol.com4032 Meadow LaneMiamiFL33150-2740··GRP-7176MEDICARE-ADV-B
ENRENR-1101402026-05-30T10:26:29ZWillie··—Campbell1977-11-04··UHC-14885-76•••-••-9419+1 331 275 0266willie.campbell10@hotmail.com9601 Palm DrivePlanoTexas75060GRP-5768NAVIGATE-HMO
ENR ENR-1187452026-10-09T21:01:16ZMARTHA·GSHAW1950-08-16UHC7406429•••-••-6501(867) 775-8560martha.shaw41@yahoo.com2741 SAGE CTTempe·AZ85226GRP-6356CORE-HMO
ENRENR-1089172026-03-18T18:56:36ZGraceCKelly06/04/92uhc-21222-79•••-••-2246766.506.0494grace.kelly@yahoo.com5725 Maple AveSan DiegoCA—GRP-2745SELECT-EPO··
ENRENR-1404692026-08-06T11:40:50ZJacquelineLDean02-03-1986··UHC0830588•••-••-4101(627) 272-6910JACQUELINE.DEAN58@OUTLOOK.COM346 Apache BlvdSAN DIEGOCA92107-4554GRP-1955OPTIONS-PPO
ENRENR-1293022026-10-13T08:29:02ZPETER··O.BUTLER·06/14/39UHC-81724-28•••-••-8130—N/A7119 Canyon RdLos AngelesCA90038GRP-0557OPTIONS-PPO
ENRENR-1354542026-06-14T10:21:56ZBENJAMINFJONES2000-11-10UHC-29222-43—417.628.5515N/A3705 HILLCREST ROADGilbertAZ85291-2751GRP-5587CORE-HMO
ENRENR-1233032026-05-16T13:44:30ZTimothy—Gordon19670304UHC-69308-48—14993464992UNKNOWN3260 Union StPhoenixAZ85005GRP-5024CHOICE-PLUS-PPO
ENRENR-1145462026-08-20T16:38:44ZBetty··Q.Bryant19790310UHC-90755-54•••-••-7510338.827.1251betty.bryant@outlook.com6889 Desert Sky BoulevardLAS VEGASNVN/AGRP-1635·NAVIGATE-HMO
ENRENR-1382642026-06-26T22:31:11ZMelissa···GVega·19731025UHC-29326-02•••-••-8175649-795-8231·melissa.vega@yahoo.com5150 Park Pl Apt 1TempeAZ·85295GRP-2354OPTIONS-PPO
ENRENR-1189112026-06-12T23:16:13ZDiego—Ross06/23/1944UHC-73403-26•••-••-71973308562850diego.ross59@hotmail.com7329 GRAND AVENUELos AngelesCA··90026GRP-2728··MEDICARE-ADV-A
ENRENR-1317132026-03-31T20:18:10ZSHIRLEYV.··FERNANDEZ·1976-10-21UHC-32823-27•••-••-1686+1 755 297 5952shirley.fernandez94@aol.com9656 Camelback RdJacksonvilleFL32211GRP-2344MEDICARE-ADV-A
ENRENR-1147372026-10-14T12:40:11Znancy··wheeler1992-07-20UHC-66994-16•••-••-9636283-864-3586—3917 FOREST AVENUE #365··MiamiFL33171GRP-3043SELECT-EPO
ENRENR-1191502026-10-09T19:57:58ZKENNETHOKELLY1986-08-06uhc-11634-34•••-••-8730+1 533 464 0680KENNETH.KELLY51@YAHOO.COM3483 HILLCREST ROADJacksonvilleFL32291GRP-4109MEDICARE-ADV-A
ENRENR-115125 2026-08-08T19:50:58ZJEFFRYYVALDEZ··02/08/1998··UHC-15233-48-905-594-6021jeffrey.valdez@icloud.com5176 Baseline RdAtlantaGeorgia30310GRP-3738OPTIONS-PPO
ENRENR-1099802026-08-06T12:32:44ZEugene—Mills··1940-05-17UHC-64625-24•••-••-16493792134526eugene.mills@proton.me3118 BroadwayGLENDALEAZ85393GRP-2993CHOICE-PLUS-PPO
ENRENR-1007952026-07-05T19:22:40ZBRNADON··RBRYANT12/13/1980UHC-78047-95•••-••-9574+1 953 340 0231—2086 MAPLE AVENUEAtlantaga30342GRP-5831MEDICARE-ADV-B
ENRENR-1140692026-08-27T09:45:51ZCHARLOTTE··RUIZ1955-09-20·UHC-93692-65•••-••-4186·8838923998CHARLOTTE.RUIZ80@PROTON.ME6948 BROADWAYSCOTTSDALEAZ85217GRP-0350CHOICE-PLUS-PPO
ENRENR-1050532026-07-05T08:47:08ZAronU.Guzman1981-05-22··UHC-47230-13•••-••-456114519170178aaron.guzman14@gmail.com7203 Lincoln WaySacramentoCA95870GRP-8821MEDICARE-ADV-B
ENRENR-1233362026-04-16T01:07:33ZRYAN—MORRISON06/28/1997UHC-42344-63•••-••-1787·6144678272RYAN.MORRISON@HOTMAIL.COM8872 SAGE CTAtlantaGA30321-0006GRP-8331CHOICE-PLUS-PPO
ENRENR-1063842026-07-28T18:30:35ZTheresaP.Jimenez2008-02-25UHC-35046-12•••-••-04653247485554theresa.jimenez64@yahoo.com1240 Market StGlendale·az85322GRP-4142SELECT-EPO
ENRENR-115765 2026-03-14T00:53:04ZJESSE—CONTRERAS1998-12-20UHC-26604-40•••-••-33574163750386JESSE.CONTRERAS@OUTLOOK.COM1322 Mountain View DrColumbus·Ohio43232GRP-3770SELECT-EPO
ENRENR-1030552026-07-29T02:03:53Zchristian—bowman2001-05-27UHC-29041-37•••-••-97194977788880christian.bowman@outlook.com4084 Mountain View DriveChandlerAZ·N/AGRP-2873·NAVIGATE-HMO
ENRENR-1177082026-10-18T03:37:18Zcynthia—ellis04/02/76··UHC9533090•••-••-6968UNKNOWNcynthia.ellis@gmail.com2224 CHURCH STREETPlanoTX75078·GRP-1092OPTIONS-PPO
ENRENR-1258832026-09-04T00:16:42ZJenW.RussellMar 3, 2003UHC-52480-15•••-••-6919(214) 757-6362JENNIFER.RUSSELL63@AOL.COM8600 RIDGE RDCHANDLERAZ85287GRP-5388CORE-HMO
ENRENR-1178712026-03-13T02:47:28ZSantiago—McCoyMay 15, 1992UHC7985264•••-••-8230·+1 467 616 6561santiago.mccoy43@icloud.com1401 CANYON ROADMesaAZ85212GRP-4115NAVIGATE-HMO
43,101 rows, page 274 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.430Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty