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-210522026-05-10T22:58:21ZJessica—Berry1982-06-25UHC-02004-26N/A2193622562··JESSICA.BERRY@GMAIL.COM··8958 Bayshore DriveOrlandoFL··32826UNKNOWNnull
PRVPRV-229832026-04-17T16:07:15ZEmmma—Campbell1971-11-15UHC-47039-85NULL·-emma.campbell74@hotmail.com4875 CENTRAL AVEMESAAZ85268-—
PRVPRV-205592026-07-11T22:56:47ZRuiz, Terry——1973-02-25UHC-41911-95NULL17406985487UNKNOWN·1220 Camelback RdLOS ANGELES··CA90053nullnull
PRVPRV-204252026-03-31T19:09:06ZARJUN—GARDNER1987-08-28NULL—487-830-3467·UNKNOWN7270 Bayshore DrDenverCO80286UNKNOWN··
PRVPRV-263202026-08-03T17:30:57ZKEITH—SCHULTZ1940-01-23UHC-59799-84•••-••-16118369687185—3791 Sunset BoulevardSeattleWashington98127-UNKNOWN
PRVPRV-200712026-06-28T22:30:00ZDaniel—Wang09/13/72UHC6480114NULL+1 943 535 9067NULL-NULL—-NULLUNKNOWN
PRVPRV-245272026-01-19T04:40:34Zisabella··harrison1979-10-28··—null——4121 River RdColumbusOH43234N/A··UNKNOWN
PRVPRV-201102026-10-02T09:38:20ZDAVID····PADILLA19521113UHC-51025-47UNKNOWN5289081998-5065 HILLCREST RDTampaFL·33633NULL—
PRV PRV-231582026-09-03T15:47:55ZJOYCEAHERRERA1942-06-21UHC-61035-88null··(575) 740-3081joyce.herrera47@aol.com·2531 RIDGE RDDallasTX75219——
PRVPRV-271322026-03-22T07:59:30ZPETTERO.WELLS1946-05-19·nullnull13055104175UNKNOWN2917 Mesa DriveMIAMIFL33128-2744··null—
PRVPRV-263822026-09-05T23:46:36ZRobert—Walsh1790-02-25UHC-24675-76··9523490553·ROBERT.WALSH@ICLOUD.COM984 Forest AveSacramentoCA95812NULLSELECT-EPO
PRVPRV-235972026-05-14T23:12:56Z peter—bradley19930225UHC-24216-20—+1 453 594 3419NULL··9274 Sunset Blvd··TampaFL33695UNKNOWNMEDICARE-ADV-B
PRVPRV-259772026-02-19T01:47:09ZScottP.Hughes10-01-1958·UHC-53716-26N/A··821-748-5157NULL5069 LINCOLN WAY Apt 6OrlandoFL32854-··N/A
PRVPRV-243932026-08-12T11:14:04ZKeith—Jones02/19/1987-•••-••-29932474192342—5349 Palm DriveOrlandoFL32884N/AMEDICARE-ADV-A
PRVPRV-269572026-05-10T03:47:21ZBryanSFranklin1981-12-17UHC-08186-77null898.260.8770·N/A325 Valley View DriveSCOTTSDALEAZ85200—UNKNOWN
PRVPRV-291802026-04-19T15:14:17ZvincentE·herrera19541126nullN/A12224323252null6704 Lincoln WayCHARLOTTENC28229—NAVIGATE-HMO··
PRVPRV-285812026-04-25T06:22:19ZAustinU.Jensen1945-08-06null•••-••-5263380-506-3147UNKNOWN6006 CHURCH ST··San DiegoCA92179—null
PRVPRV-262872026-01-24T10:16:50ZGerald—Hansen9/21/1948UHC-73980-75N/A16723413545—4824 Maple AvenueDenverCO80266-NAVIGATE-HMO
PRVPRV-247002026-08-18T18:23:22ZJennifer—Wong1988-03-02··null7235624918NULL2502 SUNSET BLVD #313San Antonio··TX78258UNKNOWN-
PRVPRV-257752026-08-17T02:10:41ZMari—Perkins2001-09-19··UHC-59431-05•••-••-3307942-770-8233··maria.perkins@icloud.com7167 MOUNTAIN VIEW DRTucsonAZ85738——
PRVPRV-222312026-01-27T02:31:37ZJOSHUA—TURNER20050827UHC-57288-86—(408) 669-6990—7345 CEDAR LNEden PrairieMN55377null—
PRVPRV-269342026-08-13T12:43:07ZEUGENE—HARPER1/4/1961NULLnull7052485267—null-NULL—NULL·CORE-HMO
PRVPRV-275212026-02-11T09:52:23ZfatimaOsmith1941-12-12NULL—7519301597null1716 Spring StreetCharlotteNC28267null—
PRV PRV-220762026-03-26T21:28:01ZSOFIAJ·KIM2007-02-04UHC-90210-54UNKNOWN5972403708sofia.kim@gmail.com2261 Ocean AvenueJacksonvilleFL·NULLUNKNOWNCORE-HMO
PRVPRV-216482026-05-24T02:44:06ZCHRISTOPHERFPAYNE5/20/2000UHC-95023-02UNKNOWN6947650155—6425 Desert Sky BoulevardMiamiFL33151——
PRVPRV-269122026-09-05T00:31:50ZMEEGAN—SNYDER1964-08-06UHC-93058-54null7374686179——-··N/A—N/AN/A
PRVPRV-200182026-04-20T03:49:00ZWayne—Hamilton1947-06-25nullnull6065891337wayne.hamilton@outlook.com4635 Forest AvenueTUCSONAZ85703——
PRV PRV-249142026-05-11T17:10:38ZJAK—BOWMAN1940-04-17—N/A(306) 290-9753JACK.BOWMAN67@GMAIL.COM8293 WASHINGTON STGILBERTAZ85205nullnull
PRVPRV-221712026-06-29T18:15:57Zdorothy—medina1967-10-19UHC-55197-73null7334986N/A1837 Pine Dr··HoustonTexas··77041-7252N/Anull
PRVPRV-259762026-08-21T04:26:17Zvalentina—nguyen1947-05-01UNKNOWNN/A242-970-8424N/A8410 SUNSET BOULEVARDColumbusOH43270-7266null·null
PRVPRV-228932026-07-27T10:27:11Z Evelyn—Gardner08/14/81UHC-86706-87NULL735-562-5257evelyn.gardner@gmail.com7508 Highland AveLos AngelesCalifornia90020——
PRVPRV-295632026-09-20T12:05:23ZSusen—Weber1960-12-03UHC-37047-32—476.490.1768···NULLUNKNOWN-UNKNOWNN/A-NULL
PRVPRV-268602026-02-25T09:15:30ZAhmed··—Ortiz1974-12-11UHC-30129-78•••-••-18085692420152UNKNOWN··8727 BroadwayPlanoTX75064UNKNOWN··—
PRVPRV-255432026-01-23T19:01:37ZAlexis··JimenezSep 20, 1971N/A•••-••-2894(492) 412-8214alexis.jimenez13@yahoo.com1687 Desert Sky BoulevardMIAMIFlorida33106—-
PRVPRV-271962026-05-20T18:55:16ZVICTORIA·K.RICESep 15, 1998--·668-390-0220N/A4405 Palm DriveGLENDALEArizona85355nullUNKNOWN
PRVPRV-213452026-04-22T17:45:48Z·ROGER—PAYNE2005-04-06UHC8709474-·12286699152ROGER.PAYNE34@AOL.COM2210 Ridge RdChandler··AZ85210—null
PRVPRV-265292026-09-19T01:51:57ZEric—Hudson2008-12-03UHC-87974-59•••-••-0035730-520-4618—8745 CHURCH STMinneapolisMN55422-9793-N/A
PRVPRV-225122026-01-30T04:22:02ZMadison—Patel01/10/00UHC-54352-44·null(845) 734-5964N/A4495 UNION STREETGlendaleAZ85390—MEDICARE-ADV-A
PRV PRV-202552026-08-09T04:01:24ZDanielle—Soto··11/1/1989UNKNOWNNULL7109818547danielle.soto54@hotmail.com8873 Sunset BlvdAustinTX78719—N/A
PRVPRV-205832026-04-18T09:09:51ZCatherine—Robinson1945-09-28··-—4729579668··—1847 Willow CtSan DiegoCA—NULL—
PRVPRV-283112026-01-07T23:59:39ZDeborah—Bishop2007-03-07—nullNULL-8057 Willow CtScottsdaleAZ85213N/A—
PRV PRV-239922026-01-24T10:55:42ZHenryQ.Dan1970-09-10·UHC9143857—(677) 881-4211henry.dean67@proton.me2175 Jefferson Avenue··GlendaleArizona85347—NULL
PRVPRV-277032026-01-03T13:55:36ZThompson, Patricia——1945-12-24UHC1857072—·643-866-8849-··2201 DESERT SKY BOULEVARDJacksonvilleFL32245—NAVIGATE-HMO
PRVPRV-25856 2026-04-21T16:02:52ZRios, Mason——11/04/1939UHC-42367-40•••-••-8521--2850 Valley View Dr·TampaFL33690-6352NULLN/A
PRVPRV-206362026-01-04T12:00:42ZAhmed—Gutierrez5/12/1938UHC-99150-74····—····6178 Forest AvenueColumbusOH43204—null
PRVPRV-260132026-10-15T21:48:06ZEvelyn··—Vega1982-12-09—-800-895-5882null9814 RIVER ROADScottsdaleAZ85234-7128—OPTIONS-PPO
PRVPRV-265032026-02-13T10:06:39ZSean—Tucker02/27/42UHC-15420-32—676-987-4210null4803 Canyon RoadMINNEAPOLISMN55433NULLCORE-HMO
PRV PRV-268042026-08-18T12:11:33ZKathleen··Hughes19491220UHC-40860-30NULL696-840-8950··kathleen.hughes@hotmail.com5289 Oak StreetPHOENIXAZ85065··—
PRVPRV-255282026-08-29T14:02:01ZClark, Steven—··2006-02-12UHC-49567-83—716-943-5065··UNKNOWN5715 JEFFERSON AVENUEGlendale··AZ85358nullnull
PRVPRV-239062026-04-27T22:44:56ZCHRISTINE—JAMES2/26/1957UHC-90879-93NULL(630) 223-6362—7804 Apache BlvdChandlerAZ85264NULLNULL
9,596 rows, page 84 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:46.081Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty