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-229072026-06-18T21:26:13ZTimothy—Lucas26-02-1939UHC-65767-08··NULL7953580222-6117 Grand AveLas VegasNV89171—UNKNOWN
PRVPRV-217532026-06-14T00:39:28ZHEATHER·QTAYLOR1945-07-23UHC-41950-84•••-••-2510530-883-6062heather.taylor@proton.me753 Camelback RdMesaArizona85209-2006UNKNOWNNULL
PRVPRV-218182026-03-04T00:26:46ZTimothy—Flores·1980-10-14UHC5333002N/A577.299.7854UNKNOWN6476 Washington StEden PrairieMinnesota55389-—
PRVPRV-244862026-01-01T14:52:31ZLawrenceQRice1963-11-14null-252-489-5991N/A··7553 Harbor BlvdTampaFL-—SELECT-EPO
PRVPRV-212962026-09-05T16:42:22ZBrian··Payne1975-03-02·UHC-79800-32—(516) 269-6689—·7007 Valley View DriveMESAAZ·85235—-
PRVPRV-209562026-01-16T21:58:56Z·ANN—DOMINGUEZ1959-12-03UHC-89013-57—(551) 205-4811UNKNOWN2671 Grand AveLos Angeles·CA90042-3708N/ANULL
PRVPRV-251192026-06-26T18:52:31ZRobert—Jacobs1957-03-14-—5642961872N/A6001 Canyon RdJACKSONVILLEFlorida32224——
PRVPRV-258272026-02-20T11:23:29ZNICOLE—WOODS02/02/80··UHC-75934-69NULL8952114696nicole.woods57@hotmail.com6428 Mesa DrChandler·az·85222NULLN/A
PRVPRV-289142026-08-02T16:36:05ZALAN—LOPEZ04/13/1983UHC-37303-83—6327122alan.lopez15@outlook.com6719 Union StGilbertArizonaNULLNULLnull
PRVPRV-293082026-08-14T08:58:34Z RUTH—HUDSON2/12/1966··NULL—7039478015ruth.hudson19@aol.com6660 Market StreetEden PrairieMN55384--
PRV PRV-223582026-07-12T22:10:00ZNathan—Hayes1951-10-28UHC-76338-71-(950) 436-7991—null-·---—
PRVPRV-252492026-03-28T17:00:18ZMARIANA—RYAN——N/A17873258829-2596 Valley View DrivePlanoTexas75082NULLnull
PRVPRV-285792026-02-21T21:13:02Zmaria—diaz1983-06-20··——null··UNKNOWN5160 Valley View Dr··San AntonioTX78208UNKNOWNnull
PRVPRV-279102026-07-26T04:24:52ZTheresa—·Washington04/11/57··UHC-57051-33•••-••-8144NULLnull3875 Washington StreetScottsdaleAZ85265NULLUNKNOWN
PRVPRV-276052026-09-19T03:17:16ZDonna—Silva19891006UHC-90917-79•••-••-2230····—9374 Sage Court #789Las VegasNV89168—NULL
PRVPRV-229622026-07-18T10:46:01ZELIJAH—GUTIERREZ1994-08-15null•••-••-286519659307377UNKNOWN2882 SPRING STREET Apt 27Los AngelesCA90052nullN/A
PRVPRV-289522026-05-26T12:49:23ZSims, WillieI.······1959-05-14UHC-08712-31—(383) 549-5239-3094 HILLCREST RDPlano··TX75032-7319-··N/A
PRVPRV-218082026-02-08T07:43:37ZGabriel—Brown··1995-05-27——+1 938 791 9979—3573 FOREST AVENUETAMPAFL33681····UNKNOWN
PRVPRV-215262026-04-20T14:09:06ZJudith··M.Harrsi1938-09-18N/A—(697) 263-2982—1921 Park PlTucsonAZ85723-—
PRVPRV-290262026-01-06T23:55:09Z Jerry—Banks1945-09-20····—625-440-4110-249 Oak StCOLUMBUSOH43202N/Anull
PRVPRV-242042026-04-02T06:02:22ZKayla—Knight··02/22/1945UHC-65232-63—476-834-9187UNKNOWN3353 Highland Ave·MesaAZ85246NULLNAVIGATE-HMO
PRVPRV-240732026-03-05T12:11:06ZDAVID—HERNANDEZ1987-06-28null•••-••-5115+1 691 308 6821·david.hernandez@aol.com1326 WASHINGTON STDenverCO80226-NULL
PRVPRV-251502026-05-24T11:32:41ZEmily—Harris1967-10-25N/A—985-476-8765—5568 Apache BlvdOrlandoFL32860—NAVIGATE-HMO
PRVPRV-294942026-07-13T03:59:24ZKimberlyO.Gutierrez1944-05-12N/ANULL524-555-7201null·8251 Sage CtTucsonAZ85796-1127NULL—
PRVPRV-227432026-07-18T16:46:10ZDANIELLE—ANDERSON08/09/85NULL•••-••-9812·+1 427 727 2430danielle.anderson@gmail.com8155 Church StCHARLOTTENC28284—NULL
PRVPRV-243112026-09-19T09:52:48ZALEXANDERCWASHINGTON19590709N/AN/A·261.424.9268—5736 River RoadSan AntonioTX78247NULL-
PRVPRV-240882026-05-22T12:45:41ZMICHAEL—LUCAS1965-08-11UNKNOWN-(858) 573-2125—1524 Highland Ave #175EDEN PRAIRIEMN55329UNKNOWN·CORE-HMO
PRVPRV-233822026-03-12T12:54:38ZWagner, Jeffrey——1981-04-19·-•••-••-2487+1 767 657 0707jeffrey.wagner@outlook.com8796 River RdNashvilleTN37299—UNKNOWN
PRVPRV-263982026-04-04T23:48:14ZArnold, Frank——1969-03-10UHC-80971-82•••-••-1691(681) 342-1805UNKNOWN2031 CENTRAL AVESan AntonioTX78298-9901UNKNOWN-
PRVPRV-28519 2026-07-01T04:27:50ZHenry, Carol······03-11-1999··UHC6457707—480-572-7690N/A··2837 BROADWAYOrlando··FL32847-8222-N/A
PRVPRV-230512026-08-05T01:30:37ZStephen—Singh·1957-03-12—•••-••-1067(641) 995-6674stephen.singh@icloud.com3712 Grand Avenue··ATLANTAGA30350—null
PRVPRV-21889 2026-06-29T19:49:35ZKENNTH—ROBERTS01/07/76N/A•••-••-0739null—2936 HILLCREST RDChandlerAZ85268NULL-
PRVPRV-280062026-01-20T23:20:28ZLynch, Olivia——18-07-1992UHC-54864-68—15082543013olivia.lynch83@hotmail.com2929 UNION STLos AngelesCA90062-5056·null—
PRVPRV-267002026-07-22T16:58:12ZLoriPHamilton1961-09-04—•••-••-5632849.351.9558LORI.HAMILTON36@HOTMAIL.COM5330 MAIN STREETColumbusOH43205—MEDICARE-ADV-B··
PRVPRV-284542026-02-06T07:46:26ZGeorge—Hicks19980723·UHC-48027-95—N/A-2519 FOREST AVESacramentoCA95868N/A··—
PRVPRV-279772026-02-15T13:12:36ZALEXANDER—HUDSON1964-03-17UHC6758264—412.639.4110—965 Hillcrest RdGilbertArizona··85290—NULL
PRVPRV-282372026-08-08T01:01:50ZBruce····Harvey3/21/2004null—6897592283—9486 INDIAN SCHOOL ROADOrlandoFL32876—NULL
PRVPRV-249082026-01-05T05:34:01ZAisha—Rogers1957-09-18null•••-••-48369487764138—3115 Mountain View DrSACRAMENTOCA95801-8052NULLNAVIGATE-HMO
PRVPRV-292382026-04-25T23:53:36Z·Michelle—Gonzales12/03/73UHC-28818-28UNKNOWN(619) 934-2340NULL··6915 Church Street #661SacramentoCA95887—null··
PRVPRV-286612026-05-07T13:09:04ZLUIS—NICHOLS1975-08-02UHC-08596-50—793.890.7819NULL—UNKNOWNnullN/A-—
PRVPRV-225062026-09-01T04:21:11ZMARK—GONZALEZ09/04/1967—UNKNOWN(507) 220-0436mark.gonzalez75@gmail.comUNKNOWNN/A——UNKNOWN—
PRV PRV-270532026-06-14T17:25:21ZSandra—VasquezAug 10, 1987UHC-92007-17null847-587-7055—1056 MESA DRNashvilleTN37296N/AN/A
PRVPRV-264002026-05-23T02:23:58ZPhilipQSchmidt2000-12-08UHC-62139-96UNKNOWN400-665-6162—5704 Bayshore DrJacksonville··FL32280null—
PRVPRV-205872026-03-13T11:39:10ZMARIA—JAMES2001-11-10N/ANULL·NULLmaria.james@yahoo.com9109 BROADWAYOrlandoFL32841-—
PRVPRV-235112026-02-21T02:12:31Zdonald··—griffin·10/7/1953UHC-86624-42N/A642-523-5502UNKNOWN2979 Maple AveDallas·TX75258UNKNOWN—
PRVPRV-225092026-01-05T15:43:12Z·Priya—Ray1985-09-26UHC-69452-31··•••-••-7757+1 564 419 6221-727 CANYON RDDenverCO80252—UNKNOWN
PRVPRV-226772026-02-12T07:44:02ZJoe—Freeman17-11-2007UNKNOWN•••-••-334517794698530joe.freeman99@icloud.com3030 Park PlaceCharlotteNC28248——
PRVPRV-228162026-01-26T09:38:27ZBaker, Aisha——1944-03-19UHC-54571-05UNKNOWN225-803-1079aisha.baker@outlook.com5994 Indian School RoadCharlotteNC28210—··
PRVPRV-285092026-04-16T07:44:02ZIsabella··—Schmidt1970-02-22NULL•••-••-60846229878960NULL8440 RIDGE ROADGLENDALEAZ85369null—
PRVPRV-272562026-02-10T20:05:49ZAndrew—Vargas1942-06-24null—797-981-8086N/A8072 Mountain View DriveSAN DIEGOCA92104—options-ppo
9,596 rows, page 88 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.417Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty