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-254252026-08-19T13:16:01Zmadison—george1973-08-01NULL··8604444992madison.george@aol.com2881 Church St·ORLANDOFL32867UNKNOWNN/A··
PRVPRV-201782026-02-07T08:22:44Z·Kelley, Anna—··01/02/2002—NULL18749851574··UNKNOWN——N/A-NULLSELECT-EPO
PRVPRV-217562026-01-25T03:03:44ZMEI—WHITE1981-03-25N/Anull·UNKNOWNMEI.WHITE@PROTON.ME8916 River RoadJacksonvilleFL32273—MEDICARE-ADV-A
PRVPRV-266442026-02-17T03:55:29ZHicks, Sofia··——1952-05-23UHC-80393-05—7066447—1685 Church StPhoenixaz85060-6406·UNKNOWNUNKNOWN
PRVPRV-28968 2026-09-13T14:57:20ZJAMES····LE·1983-01-17—null+1 409 688 4407james.le@proton.me5745 Mountain View DrPlanoTX75029—N/A
PRVPRV-273632026-08-08T17:36:35Z sharon—wilson1960-07-09-•••-••-2637(911) 547-9369sharon.wilson42@aol.com9327 Highland AveGlendaleAZ85346-UNKNOWN
PRVPRV-253552026-06-30T10:51:00ZWILLIAM—RYAN1991-12-16——(252) 427-4978UNKNOWN8692 Forest AvenueNashvilletn37202——
PRVPRV-261982026-05-14T12:21:30Zyoug—cheryl1984-10-20UHC-94928-50—4073171083UNKNOWN6311 Sage CtSan DiegoCA92150·N/A—
PRVPRV-205782026-10-09T04:35:44ZHill—Joyce1955-12-15····•••-••-3948(430) 408-0892joyce.hill@gmail.com4645 Park PlScottsdaleArizona85281null··
PRVPRV-234172026-08-27T11:25:18ZJusitn—Miller01/22/80NULLUNKNOWN(256) 312-6286justin.miller@hotmail.com7254 HARBOR BOULEVARDHoustonTX77097-—
PRVPRV-293742026-05-17T04:23:07ZDiego—Cook1992-07-26N/Anull8229578548N/A1513 Sunset BlvdSacramentoCA95891—NAVIGATE-HMO
PRVPRV-262222026-08-05T04:00:16ZLAURA—WHITE09/20/57-UNKNOWN(480) 353-9112—693 LINCOLN WAYHOUSTONTX77007N/A-
PRVPRV-201692026-06-21T21:39:10ZAmy—Husdon1994-02-15UHC-74527-15····808-727-8334UNKNOWN·8671 WILLOW CTDenverco-—CORE-HMO
PRVPRV-202202026-02-20T00:36:40ZLORIEMEYER1959-11-17-—3623758366lori.meyer@gmail.com9738 CANYON ROADCharlotteNC28282-NAVIGATE-HMO
PRVPRV-209042026-06-01T03:43:43Zalice—ruiz27-04-2004—N/A17886610687N/A—UNKNOWN··—····N/A
PRVPRV-249702026-04-06T15:58:17ZJanice—Medina1981-01-11UNKNOWN—610-451-7207janice.medina99@proton.me8146 Lincoln WayTucsonAZ85736-5624UNKNOWNMEDICARE-ADV-B
PRVPRV-286742026-07-22T07:00:28Z·MateoT.Riley1995-03-20·UHC-78610-28•••-••-5775643-833-8072mateo.riley78@aol.com231 CEDAR LNEden PrairieMN55313N/AN/A
PRVPRV-202342026-08-05T03:34:54ZVictoria—Greene1976-07-22UHC1246694null(370) 514-4850UNKNOWN7520 Church StreetSEATTLE·WA98185-medicare-adv-a
PRVPRV-283362026-01-29T11:46:03ZRUSSELL—FORD1949-11-02—NULL(257) 684-0382null5170 Apache BoulevardJacksonvilleFL32220—NULL
PRVPRV-217902026-09-22T15:01:04ZFRANK—MURRAY··2006-09-23UHC-51068-95N/A603-588-2037—6786 Mountain View DriveFresnoCA93779--
PRVPRV-242992026-03-24T01:24:42ZSANDRA··TAYLOR·2006-11-26-—(486) 278-1967NULL93 Church StAustinTX78750N/AUNKNOWN
PRV PRV-214322026-05-05T23:15:41ZLogan—Tucker25-03-1958··null670-931-3269—3731 BASELINE ROADScottsdale··AZ—NULL·null
PRVPRV-231332026-06-13T09:14:49ZBruceV.Little·07/05/1941—NULL751-260-8776—2833 Sunset BoulevardSAN DIEGO··CA··92115—-
PRVPRV-240762026-06-01T12:39:02ZAnn··Mendez1964-02-12UHC-31441-46-316-848-9959—4985 Park PlaceSan AntonioTexas78293—MEDICARE-ADV-B
PRVPRV-227822026-01-23T08:24:41Zcynthia·Nluna09-06-1970··UHC-76246-70—858-787-5628—5505 Washington StAtlantaGA30301—UNKNOWN
PRVPRV-254722026-03-26T14:14:06ZKayla—Brooks1954-09-14—-(599) 251-4981KAYLA.BROOKS@GMAIL.COM2690 Oak StLos Angeles·CA90007UNKNOWNNULL
PRVPRV-267702026-04-04T11:29:31ZRodriguez, Bradley——19560820N/ANULL442-287-5080—6966 CANYON ROADTampaFL33620null—
PRVPRV-21694 2026-07-14T15:10:52ZJulia—McDonald1/4/1999nullnull9039003988N/A9310 WASHINGTON STHoustonTX77028nullNULL
PRVPRV-276442026-01-29T08:29:44Zbrittany—wang1995-11-14—N/AnullNULL3355 River RdMiamiFL··33185——
PRVPRV-215472026-09-28T10:10:04ZPierce, Aaron——07/04/67—NULL(781) 806-0558null9338 SPRING ST #712ColumbusOH··43288··NULL··OPTIONS-PPO
PRVPRV-227982026-05-15T08:48:40ZALICE—WATSON19560402UHC-88399-93—··alice.watson21@icloud.com4795 GRAND AVESan AntonioTX78251——
PRVPRV-259592026-02-04T06:03:00Z BRYAN—KING11/11/60UHC-04101-99-4526498600null3073 Canyon Road·FRESNOCA——MEDICARE-ADV-B
PRVPRV-253272026-06-21T13:43:55ZAnn—SimsDec 20, 1973—·--··null3815 Palm Dr Apt 30PhoenixAZ85050··nullMEDICARE-ADV-B
PRVPRV-251012026-01-25T09:23:52ZWillieCElliott01/20/43UHC-22957-69•••-••-6820—willie.elliott@yahoo.com9782 RIDGE RD··TempeArizona85289—null
PRVPRV-282842026-03-10T16:41:01ZMorgan, Sophia——1989-01-15··——363-677-4936sophia.morgan97@gmail.com504 River RoadHouston··TX77048-7358NULL··—
PRVPRV-274632026-04-17T04:12:01ZALEXISMHAWKINS4/17/1977—-14004162527UNKNOWN8718 Bayshore DrJacksonvilleFL32242nullnull
PRVPRV-251552026-08-20T06:52:43ZAndrew—Ross2003-02-09—····8252584957—····N/Anull—N/A—
PRVPRV-216362026-04-04T14:14:06ZSchmidt, Willie——1978-04-21UHC-26025-53—477-953-0898WILLIE.SCHMIDT@GMAIL.COM··5446 FOREST AVECharlotte·NC28201N/Anull
PRVPRV-264192026-09-15T06:07:16ZLuis—McDonald07-06-1940·null—871.296.2148UNKNOWN4096 MAIN STREETGlendaleAZNULL-OPTIONS-PPO
PRVPRV-241012026-07-16T19:32:06ZDAVIDYGARCIA2002-10-28—NULL272-921-5703DAVID.GARCIA@YAHOO.COM4316 Church StSacramentoCalifornia95817UNKNOWNN/A
PRVPRV-236302026-08-15T06:11:13ZROYX.SANDERSJun 11, 1941UHC-81923-33··-—4426 Harbor BlvdFRESNOCalifornia93720N/A—
PRVPRV-287472026-03-08T15:07:42ZKevinO.Guzman1963-07-25UNKNOWNUNKNOWN278-880-8571—N/AUNKNOWNUNKNOWN-——
PRVPRV-295682026-02-05T09:38:44ZRebekca··—Salazar19440924UNKNOWN··•••-••-1747701-706-1648REBECCA.SALAZAR@ICLOUD.COM5115 GRAND AVEGlendaleAZ—NULL··null
PRVPRV-238892026-07-03T11:12:38ZTyler—Elliott1954-01-14—null6192587292-6868 Hillcrest RdPlanoTX75038UNKNOWNnull
PRVPRV-220232026-10-04T01:52:41ZSusan··—Edwards1977-01-25UHC-55663-33•••-••-5296210-922-0629UNKNOWN1215 Ridge Rd··ORLANDOFL32867-null
PRVPRV-284482026-04-21T00:36:09ZANTHONYAWRIGHTJun 16, 1957····-8565647937anthony.wright@proton.me4821 River RoadSCOTTSDALEAZ··85231NULLN/A
PRVPRV-222692026-02-04T01:31:44ZMICHELLEXKELLEY0201-39-96UHC1138260null··6954920437—2898 BASELINE ROADSAN ANTONIOTX·78244-NULL
PRVPRV-285572026-05-01T09:55:55ZWebb, Carlos——1949-12-20null•••-••-483218783040123·carlos.webb@icloud.com7922 Canyon RdTempeAZ85242——
PRVPRV-258202026-06-15T21:33:51ZCarlson, Nicole——1941-10-20nullNULL—-8802 PINE DRIVE Apt 3TampaFL33663N/ACORE-HMO
PRVPRV-244472026-02-23T14:54:15ZTimothy····Brooks1978-03-15UHC-96249-54•••-••-87866567818224UNKNOWN9727 MAPLE AVENUETempeAZ85257——
9,596 rows, page 31 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:38.461Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty