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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
PRVPRV-221802026-05-13T18:17:33ZDANIELMGARCIA06/10/1961NULLUNKNOWN(413) 614-2747—7755 Washington StreetMESAArizona85270UNKNOWN-
TPATPA-635532026-08-31T09:19:48ZJOSE··HARVEY26-03-1970UHC-69584-36—-N/A8072 Oak StreetHoustonTexas77063N/A-
TPATPA-509372026-02-06T03:27:27ZZachary—Rios1954-01-02N/ANULL3345041391zachary.rios28@aol.com5006 Baseline RoadGilbert··AZ85225NULLOPTIONS-PPO
PRVPRV-235352026-08-24T08:35:11Z·MelssaIYaang1987-12-10UHC-44188-65null(585) 879-9368·melissa.yang71@outlook.com·5216 Bayshore DrOrlandoFlorida32897——
ENRENR-1124822026-06-01T02:36:23ZOMARV.WASHINGTON1945-02-25UHC-08708-89•••-••-3754N/AUNKNOWN2801 Union StTempeaz85263GRP-3300MEDICARE-ADV-B
ENRENR-1355542026-03-29T06:31:09ZJustinY··Nichols··08/23/1978UHC-84031-32•••-••-5660+1 280 793 7863JUSTIN.NICHOLS@HOTMAIL.COM7207 Highland AvenuePLANOTX75083·GRP-9859MEDICARE-ADV-A··
PRVPRV-252812026-01-20T04:36:06ZRalph—Gibson21-03-1987UHC-51268-55NULL569-844-7571—2194 Baseline RoadMiamiFL33143-6193UNKNOWNMEDICARE-ADV-B
CLMCLM-4058362026-07-19T20:38:00ZvincentN.·diaz11/18/1982—•••-••-4920-null8142 Oak Street #687·FRESNOCA·93735-5560GRP-1735-
ENRENR-1007342026-06-20T05:13:42ZSCOTT—STEPHENS1938-05-09-•••-••-531016525772506SCOTT.STEPHENS@GMAIL.COM9849 Sunset BlvdFresno··CA·93701-7436·GRP-5316MEDICARE-ADV-B
ENRENR-1177372026-05-17T23:24:50ZEugeneTHanson06/03/55UHC-51392-83•••-••-7016799.435.6982-·4699 Washington StreetAtlantaGA30324GRP-1358MEDICARE-ADV-B
TPATPA-525612026-01-20T19:04:52ZDORIS—ROBERTSON··1951-03-03N/A-——1581 Canyon RoadHoustonTX77097-1740—N/A
TPATPA-594892026-02-26T04:11:51Z·Terry, Li··—1965-05-07——462-337-7466-8628 Oak StreetSan AntonioTX78245—·NAVIGATE-HMO
CLMCLM-4208992026-05-13T19:03:46ZElizabeth—SchultzDec 24, 1967UHC-01992-56•••-••-3184—elizabeth.schultz@outlook.com9384 Pine Drive Apt 34FresnoCA93758GRP-2040CORE-HMO
ENRENR-1163802026-08-27T13:22:46ZMariana—Peters2002-11-02UHC-16391-22•••-••-58106002226952UNKNOWN5763 Bayshore DriveLos AngelesCA90074·GRP-9209CORE-HMO
ENRENR-1134142026-01-28T15:48:10ZEstrada, Nicholas····—1979-07-19UHC5774842•••-••-9127(732) 683-5696nicholas.estrada@icloud.com5564 Desert Sky BlvdSEATTLEwa98137GRP-7074CHOICE-PLUS-PPO
TPATPA-582152026-05-31T22:01:09ZDEBORAH—SIMPSON1939-04-23NULL·NULL—N/A5622 Forest AveNashvilleTN—UNKNOWNMEDICARE-ADV-B
ENRENR-1147282026-05-29T18:43:38ZDorothyJSpencer6/17/1945UHC-83167-50•••-••-5800458-736-3297NULL8053 Meadow Ln·ATLANTAGAUNKNOWNGRP-7610·NAVIGATE-HMO
CLMCLM-4208032026-07-22T06:12:39ZJuliaZ.Garza—UHC-69609-77·NULL—-nullUNKNOWN—nullUNKNOWN·SELECT-EPO
ENRENR-1285492026-02-08T22:37:09ZVINCENTWPADILLA1986-01-12UHC-44861-15•••-••-96268579745210—·1843 CENTRAL AVESan DiegoCA—GRP-9361CORE-HMO
CLMCLM-4208852026-07-15T01:33:46Zbrtitany—guerrero24-10-1991UHC-24257-81—944-293-7989UNKNOWN6190 Spring Street·DallasTX75282GRP-0928OPTIONS-PPO
CLMCLM-4050952026-03-25T20:32:24ZVALENTINA—ALVARADO06/20/1953UNKNOWN•••-••-5447+1 249 460 3363-2353 Palm DrOrlando·FL32831—OPTIONS-PPO
ENR ENR-1044742026-01-17T12:19:51ZKATHLEEN—BAKER1943-04-12UHC-40436-49UNKNOWN7135346339kathleen.baker9@yahoo.com9748 Washington StreetAtlantaGA30329GRP-6455·MEDICARE-ADV-A
CLMCLM-4174932026-03-20T12:24:57ZAliceWBryant19670803UHC-87888-26UNKNOWNnull—7231 Palm DrChandler·AZ85265GRP-8488NULL
CLMCLM-4255142026-05-23T06:09:29ZWalter—Morrsi1945-08-18UNKNOWN··•••-••-5360752-855-2367NULL9310 FOREST AVENUELAS VEGASNevada89124null—
ENRENR-1172422026-01-26T23:14:34ZMORAESK.HELEN1959-10-23··UHC-42089-79•••-••-60873252917069·helen.morales9@hotmail.com3155 APACHE BOULEVARDLos AngelesCA90026GRP-1276OPTIONS-PPO
CLMCLM-4164692026-07-25T21:59:05ZRAYMONDCSANTOS1959-02-12UHC-31261-86—NULL—1830 SPRING STATLANTAGeorgia30311GRP-4600·MEDICARE-ADV-A
CLMCLM-4029142026-07-28T07:54:27Z DENNIS—GUTIERREZ1984-04-08UHC4152439•••-••-5892—-———N/Anull—
ENRENR-1232132026-03-22T16:42:58ZAUSTINQ.THOMPSON09/22/2004UHC-86839-81•••-••-5050(872) 385-6009austin.thompson@outlook.com9183 DESERT SKY BLVDGilbertaz85265GRP-4401MEDICARE-ADV-A
TPATPA-590252026-01-07T17:29:53ZDIEGO—JIMENEZ2005-03-07-UNKNOWN-·diego.jimenez@hotmail.com6107 Palm DrHoustonTX77097GRP-1007UNKNOWN
CLMCLM-4074842026-07-15T22:07:21ZABIGAILN.HICKS20010405UHC-46842-79NULL19654116494NULL··251 HILLCREST RDSEATTLE·WA98176GRP-2410-
CLMCLM-4053392026-05-13T17:23:00ZLuis—Hill1942-10-27UHC-27600-40•••-••-7985UNKNOWNUNKNOWN7828 Meadow LnGILBERT·AZ·85271-N/A
ENRENR-1280452026-04-30T23:53:11Z Tyler·F.Hudson1972-02-12UHC-96277-14•••-••-8138·699-638-2378tyler.hudson@yahoo.com7391 Elm StreetMinneapolisMN55417GRP-7730MEDICARE-ADV-A
ENRENR-1202382026-07-23T05:44:52ZJASON—NELSON1940-05-07UHC-92901-05•••-••-7815(223) 569-2840jason.nelson21@aol.com563 Church StreetSacramentoCA95840GRP-6771MEDICARE-ADV-B
ENRENR-1330912026-04-29T18:56:39ZParker, PatrickS—1986-09-01··UHC-14708-32··-—patrick.parker17@icloud.com5982 Bayshore DriveTempeAZ··nullGRP-9749···core-hmo
CLMCLM-4150922026-02-26T01:59:16ZDANIEL—REID·1939-01-23—•••-••-6348477.524.0045null8395 Camelback RoadColumbusOH43209··GRP-1246N/A··
CLMCLM-4108272026-03-13T14:07:04ZDorothy—Garcia1949-05-15·UHC-92624-48•••-••-7755—DOROTHY.GARCIA37@OUTLOOK.COM6761 Sunset BlvdDenver·CO80299UNKNOWN··N/A
ENRENR-1379282026-07-16T22:29:43ZEspinoza, Gloria——04/17/77UHC1939367•••-••-6655(434) 535-3258gloria.espinoza@proton.me2480 Canyon RdDENVER··CO80237GRP-9658CHOICE-PLUS-PPO
ENRENR-1285882026-01-29T01:04:35ZEthanL.Turner4/18/1980UHC4161689•••-••-9806(722) 666-9340ethan.turner82@gmail.com2619 Highland AvenueSACRAMENTO··CA95874GRP-3938MEDICARE-ADV-B··
ENRENR-1220092026-04-30T08:32:32ZEmma—Turrner02/08/1944UHC7291116NULL·8713525971—6871 MOUNTAIN VIEW DRIVEGilbertaz85242GRP-1778·SELECT-EPO
ENRENR-1263242026-10-01T13:35:09ZDorotyhJ.Alvarado3/14/1954uhc-59713-55•••-••-0292891-723-4380DOROTHY.ALVARADO56@GMAIL.COM··6812 Park PlaceJacksonvilleFL32212GRP-4029MEDICARE-ADV-B
TPATPA-570042026-08-23T12:29:34ZJohnston, Alexander——2006-02-24—-·NULLnullUNKNOWNN/A—-GRP-4198medicare-adv-b
CLM CLM-4224162026-10-06T00:17:56ZGary—Espinoza1941-02-25UHC-09582-44•••-••-5991423-466-5072N/A1967 Union StreetSCOTTSDALEAZ85237GRP-3386UNKNOWN
CLMCLM-4179932026-06-27T12:32:39Z ·katherine—holmes10-04-1985UHC-14243-68··N/A——3359 Jefferson AveHoustonTX77016GRP-1495MEDICARE-ADV-A
PRVPRV-290712026-09-03T21:36:57Zjanice—marshall02/22/85—··905-866-4819janice.marshall@aol.com5578 Bayshore Dr #980SacramentoCA95824nullSELECT-EPO
ENRENR-1134432026-01-01T19:39:40ZGaryRWest1940-04-16UHC-94532-50•••-••-5376N/ANULL5456 Cedar LaneEden PrairieMN55398GRP-9733·CHOICE-PLUS-PPO
CLMCLM-4026452026-09-29T05:12:19ZRoy—Payne1987-01-02N/AN/AnullNULL·NULLnullUNKNOWNnullnull·NAVIGATE-HMO
ENRENR-1234772026-03-26T20:47:24ZJohnBHernandez2001-09-16UHC-50279-61•••-••-1588·9772230676john.hernandez@proton.me·5504 DESERT SKY BLVDDenverCO80203GRP-8983CORE-HMO
TPATPA-578932026-05-31T21:59:10ZLuucas, Paul——1946-06-15—··UNKNOWNpaul.lucas@aol.com3616 CAMELBACK ROADJacksonvilleFL32262—N/A
TPATPA-616092026-07-15T13:26:17ZVINCENT—WILLIS10/01/2004UHC-89971-40UNKNOWN5769051599·vincent.willis46@gmail.com1003 BAYSHORE DRPlanoTX75006··NULLnull
TPATPA-583532026-04-05T18:52:13Zmartha—boyd20-06-1977N/A•••-••-4618NULLmartha.boyd@proton.me-—··—GRP-8109N/A
100,000 rows, page 22 of 2,000PreviousNext

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.762Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty