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-245112026-05-03T05:23:09ZlawrenceSnichols1941-03-26UHC-23434-16—598.597.0939—2895 Canyon RdLas Vegasnv89183-3195-—
PRVPRV-208992026-02-02T10:24:16ZAustin··—Hughes2000-60-04··UHC8154049N/A4454953335···null138 Meadow LnEden PrairieMN55308—MEDICARE-ADV-A
PRVPRV-217612026-04-21T11:19:42ZGerald—Richardson1957-04-11NULLnullnullGERALD.RICHARDSON@PROTON.ME1747 SAGE CTGilbertaz85254-—
PRVPRV-212952026-09-23T17:58:53Zjose—jackson1981-11-23N/Anull(758) 654-1092-2459 Ridge Road #269DALLASTX75244-1612—null
PRVPRV-240702026-07-11T12:09:18Z Jimmy—Yaang04/07/59—-nullN/A··1173 CANYON RDScottsdaleAZ85243··—CORE-HMO
PRVPRV-222502026-02-09T06:38:35ZJason—Cole··10/28/93UHC-29923-13•••-••-610813298091591—7591 Market StreetEden PrairieMN55381····MEDICARE-ADV-A
PRVPRV-254612026-02-17T23:01:55ZBARBARAFJAMES·1988-06-23UHC-77875-98-UNKNOWNbarbara.james34@gmail.com2480 Ocean Avenue #741MiamiFL33103N/AUNKNOWN
PRVPRV-205092026-02-11T22:53:33ZMarthaD.·Harrison1980-03-26UHC-15211-78•••-••-8648—martha.harrison12@icloud.com7138 Lincoln WayDenver··co80288nullSELECT-EPO
PRVPRV-215542026-02-25T21:24:35ZMendoza, Ana—··2004-10-14-N/A302-977-2758·null7371 MARKET STREETHoustonTX77080NULL—
PRVPRV-236952026-09-30T06:13:18ZRALPH—·JENKINS12/18/2001··UHC-92101-65··—·522-288-3803—525 Sage Court #882Fresno··CA93709N/Anull
PRVPRV-205242026-08-10T20:43:39ZDylan—Kim2007-06-24UHC-93308-26—8946694364-7800 Elm StDallastx··75249UNKNOWNnull
PRV PRV-232592026-09-30T17:33:45ZKennedy, Patricia——17-09-1991---PATRICIA.KENNEDY19@ICLOUD.COM6142 Harbor BoulevardLos AngelesCA90015NULLCHOICE-PLUS-PPO
PRVPRV-245832026-01-21T05:45:40ZDebra··Stone··1984-04-14N/A—(343) 384-6337null··1874 Maple AveAtlantaGeorgia30385—UNKNOWN
PRVPRV-224262026-05-15T20:47:05ZNatalie—Medina1972-05-23UHC-72744-31UNKNOWN397.290.0505NATALIE.MEDINA@PROTON.MENULL————N/A
PRVPRV-276222026-08-31T21:24:07ZScott—Duncan06-06-1970——201-442-1258SCOTT.DUNCAN35@GMAIL.COM71 Bayshore DrLOS ANGELES···CA90071-—
PRV PRV-247682026-08-23T15:00:55ZSANDRA··OCAMPBELL1965-04-91—NULL5726450816—8853 Hillcrest RdTampaFL33678——
PRVPRV-292642026-10-15T12:24:51ZChristine··Wallace1961-08-25UHC-56875-41NULL2527295340UNKNOWN··8665 Camelback RoadEden PrairieMN55309UNKNOWNN/A
PRVPRV-258182026-09-11T01:12:03ZDavid—Hoffman1974-11-01UHC-56897-78—7686178513·UNKNOWN9643 Camelback Road Apt 33··NashvilleTN37298—NULL
PRVPRV-24161 2026-07-23T04:58:56ZBRYAN··GRAHAM4/8/1952—•••-••-7202773-355-9998null238 Jefferson AveSan AntonioTX78204NULL—
PRVPRV-230502026-05-28T04:03:15Z Ronald—Dominguez··1989-05-26UNKNOWN-243-745-3045ronald.dominguez@aol.com4274 Desert Sky BoulevardSAN ANTONIOTX78200—N/A
PRVPRV-204532026-10-04T18:18:18ZHannah—Patterson1981-05-01UHC-91930-09null(436) 516-8470null801 Hillcrest RoadLos AngelesCA90072—SELECT-EPO
PRVPRV-221902026-04-10T08:06:28ZGreg—Phillips7/5/1981—•••-••-9923—GREGORY.PHILLIPS@YAHOO.COM7908 Forest AveAtlantaGAnullnull—
PRVPRV-222762026-05-01T18:43:21ZMark—Robertson1956-05-14UHC-79068-41null781-849-0952UNKNOWN3376 Indian School RoadPhoenix···AZ85053—null
PRVPRV-255252026-03-24T21:41:49ZAnna—Edwards2001-12-09UHC-19151-80—8842739842null3858 Willow CtSeattleWA98135-2156—UNKNOWN
PRVPRV-276042026-01-26T10:14:58ZDONNAASILVA10/06/1989-N/AUNKNOWNdonna.silva97@gmail.comNULLnull—-NULLnull
PRVPRV-290732026-06-19T22:58:48ZbrittanyWtaylor05/07/41UHC-11983-40null940.329.9157UNKNOWN3835 Ridge RdTempeArizona··85298—null
PRVPRV-252922026-01-07T22:59:28ZKimberlyROrtega··—-•••-••-76786494069936—·7148 Sage CourtJACKSONVILLEFL-N/Anull
PRVPRV-235172026-06-04T17:02:29ZHiroshi··Martinez8/27/1946N/AUNKNOWN(374) 214-9810hiroshi.martinez@outlook.com4432 Spring St #758Las VegasNV89182UNKNOWNN/A
PRV PRV-279302026-06-11T08:42:16ZCatherine—Wheeler1952-10-07UHC4838089—·8033194021NULL3516 HARBOR BLVDTampaFL33696NULLnull
PRVPRV-257822026-01-13T12:51:40ZLarry—Baks1946-05-21UHC-47014-15N/AN/A-7288 Mesa DriveSacramentoCA95840·N/ACHOICE-PLUS-PPO··
PRVPRV-236032026-01-31T13:48:55ZBeverlyY·Hunt·5/6/1984UHC-39169-49··UNKNOWN+1 337 333 6093BEVERLY.HUNT84@PROTON.ME1902 Maple AveGilbertAZ85246··NULLN/A
PRVPRV-239052026-01-24T21:08:01ZRUSSELLSBAILEY1987-04-01·UHC-87909-52—14224240293null4758 Maple AveChandlerAZ85276--
PRVPRV-276472026-02-01T11:40:17Zamnada—johnson1946-07-03UHC-06364-64N/A862-465-6105—3153 MOUNTAIN VIEW DR Apt 39Los AngelesCA90094-N/A
PRVPRV-233972026-08-25T02:51:25ZNATALIE—FERNANDEZ09/17/1950-··—415-203-0125natalie.fernandez17@aol.com9177 Hillcrest Rd··HoustonTX··77033-6897····—
PRVPRV-277002026-02-26T15:48:09Zabigail—tranApr 13, 2004——-ABIGAIL.TRAN98@OUTLOOK.COM-—UNKNOWN-—NULL
PRVPRV-253232026-02-26T06:02:37ZEUGENE··N.GREENE1979-09-16UHC-12315-94•••-••-8994958-978-7303—·7677 Highland AveTampaFL33615-NULL
PRVPRV-201642026-06-01T05:33:08ZAnthony—Riley1961-09-02·N/ANULL(340) 844-8924NULL4452 Harbor Blvd··SAN DIEGOCalifornia·92151NULLMEDICARE-ADV-A
PRVPRV-291672026-05-06T18:23:48ZCarl—Sims··1964-06-26uhc-22625-51—(896) 738-6776carl.sims@icloud.com3056 INDIAN SCHOOL ROAD··TUCSONAZNULL—N/A
PRVPRV-236062026-05-27T10:12:43ZKyle—Hall1971-12-28UHC-40356-45null··(498) 716-4866N/A3425 River RoadEden PrairieMN55396-5726—MEDICARE-ADV-B
PRVPRV-287772026-08-24T01:31:51ZJuliaALarson01/23/1969UHC2750234•••-••-5997582-973-4161julia.larson80@aol.com6838 Maple Ave··Houston·TX77091·nullMEDICARE-ADV-B
PRVPRV-222462026-05-28T19:31:22ZASHLEY··BROOKSMar 10, 1991UNKNOWNN/A17187793598ashley.brooks44@yahoo.com1256 Canyon RdPhoenixAZ85069N/ASELECT-EPO
PRVPRV-294262026-09-15T13:16:42ZJason—Wells1979-06-12UHC0271963•••-••-20108826052732jason.wells@yahoo.com7236 Valley View DriveSAN ANTONIO·TX78296null—
PRVPRV-216132026-08-03T21:29:09ZAlbert—Mason19540314·UHC-72233-68··769.593.6039NULL2440 Desert Sky Boulevard··Glendaleaz85355—·null
PRVPRV-206052026-07-14T11:27:08ZWalter—Ortega·1960-11-18·UHC-32319-15NULL(758) 986-4166UNKNOWN3191 ELM STSan AntonioTexas78296——
PRVPRV-241532026-01-26T19:56:48ZBRADLEY··ARNOLD1/14/1957-nullUNKNOWN-525 Lake View RoadGilbertAZ··NULL—N/A
PRVPRV-223902026-04-17T13:12:44Z SARAH····MARSHALL1941-06-20UNKNOWNUNKNOWN7891031—4580 RIVER ROADTucson··Arizona85708——
PRVPRV-225772026-08-10T06:15:45ZGary—Stone··03/24/39UHC-26978-96N/AUNKNOWNgary.stone@proton.me7116 CAMELBACK RDNashvilleTN37294nullNULL
PRVPRV-239132026-02-15T11:07:10ZIsabella—NelsonApr 21, 1992UHC-35456-26•••-••-5926(520) 333-5188isabella.nelson@outlook.com2964 Grand AveAustinTX78797——
PRVPRV-210212026-01-01T09:29:53ZAshley—·Vargas1998-11-05UHC-01359-34NULL(513) 366-3166-6649 Valley View DrSan DiegoCA92186null····
PRVPRV-291142026-01-16T11:31:31ZTimothy—Bishop1978-10-26··UHC-78355-49—762.503.4555—2293 Washington StJacksonvilleFlorida32252-null··
9,596 rows, page 21 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:37.726Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty