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

Provider network only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
PRVPRV-227712026-07-13T17:40:43ZMARIANA····JOHNSON··1997-03-21UHC-60276-16N/AN/A·mariana.johnson61@hotmail.com—NULL-—-CORE-HMO
PRVPRV-274402026-10-01T06:37:54ZPerry··—Virginia1997-09-27UHC-18439-67—913.758.6693virginia.perry@hotmail.com7873 MARKET STREETPlanoTX75047NULL—
PRVPRV-291752026-07-16T23:18:53ZDeennisENelson1961-03-27UHC-29756-86•••-••-0977UNKNOWNdennis.nelson33@proton.me4709 RIDGE ROADTampaFLUNKNOWN—-
PRV PRV-209332026-07-02T03:16:12ZTEREESA—WANNG1/9/1980——9655429232—1451 Spring StLos AngelesCA90051—null··
PRVPRV-211352026-09-09T06:11:03ZBrenda—Dominguez1938-09-27--(977) 437-3997BRENDA.DOMINGUEZ@OUTLOOK.COM2854 Maple AvenueMiamiFL33120—-
PRVPRV-276922026-09-10T11:45:19ZGrace—Contreras··1974-01-01nullnull4026898098UNKNOWNUNKNOWN—NULL—N/A—
PRVPRV-25839 2026-05-08T03:48:12ZEric—LewisSep 26, 1979UHC-91782-76null5127804389ERIC.LEWIS29@OUTLOOK.COM1644 Cedar LnOrlando··FL··32864—UNKNOWN
PRVPRV-210222026-03-06T17:14:16ZEWDARDNPORTER1999-07-28UHC2668320•••-••-4890—edward.porter69@gmail.com226 BroadwayHOUSTON··TX77018NULL—
PRVPRV-218792026-06-13T04:25:46ZPetars, Jean——1980-07-14—UNKNOWN444.491.5682jean.peters@aol.com·5944 Apache BlvdMiamiFL33119—null
PRVPRV-264512026-07-09T09:46:46ZEmily—Ross5/12/1951UHC-34434-38UNKNOWN(754) 443-1760NULL··8776 Main StTampaFL33684——
PRVPRV-269972026-07-23T10:01:26ZJanetGMedina1969-11-27UHC-08466-39··(825) 630-2595JANET.MEDINA@PROTON.ME9565 LAKE VIEW ROADScottsdaleAZ85226N/AUNKNOWN
PRVPRV-263422026-01-15T08:47:51Zjoe—stewart1953-02-11UHC-21317-80null+1 526 234 6068—286 Sage CourtLOS ANGELESCA90063UNKNOWNN/A
PRVPRV-245322026-09-14T17:08:13ZJason—Nelson5/7/1940-—2235692840—563 Church StreetSacramento··CA95840-9004—UNKNOWN
PRVPRV-267572026-01-21T05:26:35ZRachel—Daniels07/18/1951null-201.785.5360null6715 Cedar LnGlendaleAZ85312-1400N/AN/A
PRVPRV-233592026-10-04T14:00:35Z Rice, Wayne——1999-12-05NULL-380-239-1706—103 SUNSET BLVDFRESNOCA93729-6470-—
PRVPRV-253442026-01-23T18:37:23ZLARRY—BLACK··2002-04-26·-—2269049011larry.black@proton.meNULL-——-·-
PRVPRV-267162026-09-16T18:04:30ZBobbyR·Simpson1980-03-27UHC-39775-45—16924850062·N/A4772 Highland Avenue··TempeAZ85220NULL—
PRVPRV-207532026-01-10T03:32:18ZNicholas··C.Dominguez1943-05-08··UHC-92617-68•••-••-4696972-733-3142N/A6743 Baseline RdHoustonTX77071null-
PRVPRV-251582026-03-19T17:10:34ZJose·QAustin·8/18/1965-N/A(702) 870-8983UNKNOWN7293 Camelback RoadPlanoTX75065-7443N/A—
PRVPRV-263742026-08-25T09:06:53ZLarry··Mejia10/26/2008UNKNOWNN/ANULLnull9043 BAYSHORE DR·FresnoCA93712-9060—null
PRVPRV-213252026-04-05T19:57:29Z Kyle—Williamson1988-10-24-—9493935064—5641 MEADOW LN··Gilbert··AZ85226-—
PRVPRV-287152026-08-25T10:50:51ZSAMUEL··—RODRIGUEZ1969-03-03nullUNKNOWN··2075511467—3532 Sage Ct··SacramentoCA95843nullselect-epo
PRVPRV-253372026-06-28T12:26:38ZColeman, CarolynD—1985-08-11-•••-••-8054(440) 760-5969carolyn.coleman@outlook.com6924 Bayshore DriveJACKSONVILLE·FL32225·UNKNOWN—
PRVPRV-200452026-04-19T03:56:46ZWilson, Julie··——·12/07/65UHC-58931-70—·(351) 314-6084julie.wilson@icloud.com766 Washington StAustinTX78745—null
PRV PRV-265842026-06-15T06:37:47Z Arnold, Omar——Apr 22, 1976UHC-09544-10—260-480-1165····1974 Baseline RdJacksonvilleFL32254··-N/A
PRVPRV-262792026-04-26T10:37:04Z Anthony—Parker19870126··UHC-91210-46—3628895UNKNOWN6120 River RdDenver··CO80262NULL—
PRVPRV-209732026-04-09T09:21:47ZKevinJ.Cunningham2002-07-11UHC1100476•••-••-05798328555721NULL7149 Park PlaceLos AngelesCA90083··N/Anull
PRVPRV-222822026-09-05T20:35:41ZLuis—·Carroll1979-11-15—•••-••-224118144802323—2872 Lincoln WayDenverCO80262··—N/A
PRVPRV-210412026-09-11T04:48:38ZBilly—Weber1/2/1989··UHC-14482-44——N/A3418 Indian School RdLos AngelesCA90086-0682N/AUNKNOWN
PRVPRV-267402026-01-24T21:27:33ZCARLOS—DANIELS06-11-1974null—NULLUNKNOWN4075 Maple AveDENVERCON/AnullN/A
PRVPRV-276022026-02-13T21:38:53ZAHMED—NICHOLS09-12-1966—•••-••-5068-—nullnullUNKNOWN—UNKNOWN—
PRVPRV-229142026-03-27T20:09:03ZRonald··Perez17-01-1992UHC-32632-12null(402) 924-1356NULL8671 Pine Drive #693AustinTX78765-··null
PRVPRV-244322026-04-15T23:34:21ZDanielKReid1939-01-23—-477-524-0045DANIEL.REID@AOL.COM8395 CAMELBACK RDColumbusOhio43209UNKNOWN··—
PRVPRV-29356 2026-03-15T22:27:55ZYUKIRHUNT1998-12-09N/ANULL582-441-6214yuki.hunt@hotmail.com5754 MAIN ST #170TucsonAZ85780NULLNULL
PRVPRV-211382026-07-17T16:06:16Z KATHRYN—BOWMAN01/08/49UNKNOWN•••-••-8224·9587770732NULL-N/AUNKNOWN—NULLCORE-HMO
PRVPRV-225532026-01-07T18:38:16ZTimothy—Yang1954-04-02—NULL204.813.4736··UNKNOWN5445 Forest AvePhoenixArizona··85093N/A-
PRVPRV-294412026-02-20T03:56:30ZAndrea··—Evans2002-01-12—N/A—··6496 SPRING STREETSacramentoCA95847-OPTIONS-PPO··
PRVPRV-221942026-09-20T21:27:47ZJohnFLee1959-06-19UHC-08697-40··-UNKNOWNNULL6819 Pine Drive Apt 16MesaAZ85251··——
PRVPRV-252022026-03-10T18:21:33ZHEEN—THOMAS1941-02-13——440-519-7634helen.thomas@outlook.com3663 Sage Ct··TempeArizona85295-··—
PRVPRV-249952026-09-28T10:51:06ZJacob—Little1974-07-12——6986938137JACOB.LITTLE@GMAIL.COM2649 Indian School Road·HoustonTX77023··N/AOPTIONS-PPO
PRVPRV-286752026-10-01T12:19:26ZRichard—Carpenter1973-01-14—-7212280784richard.carpenter@gmail.com1751 Elm StreetFresnoCalifornia93766—medicare-adv-a
PRVPRV-226372026-07-18T10:34:27ZBrandonG··Jacobs··1955-08-05UHC-10592-72··•••-••-7332851-973-8549BRANDON.JACOBS@YAHOO.COM9500 GRAND AVE Apt 1ORLANDOFL32825-8058-MEDICARE-ADV-A
PRVPRV-258062026-01-24T15:08:59ZJORDAN—·CARPENTER17-03-1977NULL—NULL··-7257 Mesa DrivePhoenixAZ85088null—
PRVPRV-215112026-09-10T21:55:41Zryan—warren1981-09-17—•••-••-5014(891) 274-3852N/A8565 Desert Sky BoulevardLas VegasNV89165—N/A
PRVPRV-212042026-09-21T03:49:40ZBRUCE—NICHOLS1943-10-11UHC-21925-74—(471) 722-7129BRUCE.NICHOLS70@ICLOUD.COM7296 INDIAN SCHOOL RDSan AntonioTX78234UNKNOWNnull
PRVPRV-279462026-07-20T14:30:05ZSeanAGordon1948-09-19··UHC-57083-46—626-954-0392SEAN.GORDON@OUTLOOK.COM··9787 CANYON ROADMESAAZ85272··-
PRVPRV-251792026-09-23T14:37:20ZBrittanyM.Kennedy1981-03-19UHC-32345-17-6388178975brittany.kennedy3@icloud.com7007 RIVER RDNASHVILLETN37259·nullNULL
PRVPRV-209842026-08-08T15:13:22ZEthanO.Arnold20050201UHC-72887-01—617-687-4926NULL1015 Oak StGilbertArizona85286——
PRVPRV-203152026-06-14T18:17:41ZKENNETH—WUNG1994-06-21null——-6751 Central AvenueChandlerAZ85250-5495—null··
PRVPRV-260472026-01-05T20:46:55ZAhmedQMuurray2003-08-15UHC-96357-86—+1 761 571 1929UNKNOWN5856 SUNSET BLVDEden Prairie·MN55339—UNKNOWN
9,596 rows, page 117 of 192PreviousNext

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