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-268752026-03-29T00:15:31ZStone, RobertH—1972-01-08UHC-11766-70—13274236988—4545 Cedar LnEden PrairieMN··55319-3895·NULLSELECT-EPO
PRVPRV-288172026-04-29T11:31:41ZCamilaE.LiN/AUHC-40969-55—NULL·NULL·4919 HARBOR BOULEVARDGilbertAZ85258UNKNOWNMEDICARE-ADV-B
PRVPRV-219322026-03-18T02:01:45ZHeather—Hawkins04-09-1940—NULL7528600942NULL4643 Apache BoulevardTempeaz85234null-
PRVPRV-234262026-07-15T09:22:37ZHENRYHCHAPMANSep 18, 2003··UHC-23775-12N/A382-618-7785-1764 Canyon RdGlendale··AZ85371——
PRVPRV-245332026-05-23T20:55:34ZAlbert—·Carter1973-12-23null—5159976758albert.carter@hotmail.com9426 Baseline RoadTempeAZ85201NULLMEDICARE-ADV-A
PRVPRV-203742026-04-27T13:12:57ZCarolynLBell1969-03-05··UHC-32776-84—4494201473—2347 Mesa Dr·CharlotteNC-—null
PRVPRV-259872026-01-18T18:16:33ZAlexis····Armstrong1996-08-18uhc-63561-95NULL601-586-8888null1658 Canyon RdAustintx78733——
PRVPRV-293302026-06-02T23:05:13Z Isabella—Rose1991-01-19UHC-86613-44N/A17732423168N/A··23 BAYSHORE DRSan DiegoCA92113——
PRVPRV-222332026-08-06T03:03:50ZMelissa—Valdez1954-02-10NULLnullUNKNOWNmelissa.valdez@aol.com962 Valley View Drive··Dallas·TX75228—N/A
PRVPRV-225722026-07-19T23:07:01ZMATTHEWPJAMES1951-01-26UHC-98968-13··NULLMATTHEW.JAMES@HOTMAIL.COM2831 Canyon RdNashvilleTN37249·NULLMEDICARE-ADV-A
PRVPRV-234462026-07-28T06:03:03ZJANET—SULLIVAN··11/13/1964··——13934903035NULL1756 Lake View RoadPhoenix·Arizona85039—NULL
PRVPRV-229172026-01-21T02:21:07ZChristinaG.Howell1939-09-22UHC-20356-10•••-••-5354(763) 775-8869null·6124 Mesa DrTempeAZ85271—NULL
PRVPRV-268142026-06-23T03:55:05ZPHILIP—FOX1993-12-25——(812) 445-5250null9588 Highland AveTucsonArizona85711N/A—
PRVPRV-250042026-02-22T08:21:48ZAdam—JimenezFeb 17, 1978UNKNOWNN/AN/A·UNKNOWN263 Lincoln WayOrlandoFL·NULL——
PRVPRV-287322026-05-29T00:34:55Z·Madison—Cook1952-12-22··UHC-03108-13•••-••-1497674-809-8021madison.cook@yahoo.com2377 Mesa DrGlendaleAZ85393nullNULL
PRVPRV-253032026-07-30T13:53:09ZCHARLIE····MITCHELL2008-12-26UHC-47452-54—+1 894 241 9102·charles.mitchell@outlook.com4323 OAK STREETTEMPEAZ-NULLN/A
PRVPRV-201872026-01-26T02:57:24ZDIANE—HART2/4/2008—N/A--7848 Ridge RoadMiamiFL—UNKNOWNNULL
PRVPRV-259622026-03-10T00:58:46ZCarl—Mruphy1955-08-03UHC-75191-41null5993423243CARL.MURPHY66@OUTLOOK.COM3504 Harbor Boulevard Apt 27TucsonArizonaUNKNOWN--
PRVPRV-255532026-03-24T14:22:59ZBrittany····HillAug 16, 2008N/A—NULLbrittany.hill26@aol.com9432 Elm StreetOrlandoFL32875-null
PRVPRV-200342026-08-06T16:13:10ZAnna—McDonald03/16/1972UHC-61383-31-(783) 759-4369UNKNOWN5798 Union StLos AngelesCA90015····UNKNOWN
PRVPRV-203752026-07-11T16:08:36ZPamela—Diaz1967-12-02UHC-10177-33NULL668-695-0098—9808 Elm StAtlantaGA30358N/AMEDICARE-ADV-A
PRVPRV-280692026-10-04T04:59:08ZVirgginiaE.Wheeler1965-06-02N/A—9404923172null3426 Main StDenverCO80277—N/A
PRVPRV-29268 2026-07-07T19:57:59ZLawrence··—McDonald07/03/1941UHC-88707-71•••-••-7965UNKNOWNLAWRENCE.MCDONALD@ICLOUD.COM970 Main StreetFresnoCAN/AUNKNOWN···NULL
PRVPRV-270992026-08-31T18:47:53ZEdward—·George17-06-1983UHC-36356-27-6549706UNKNOWN3180 ELM STAUSTINTX78742··—
PRVPRV-262672026-07-19T11:22:12Znatalie—contrerasMar 21, 1994UHC-72727-37—-null2007 Highland AvenueLas VegasNV89196-UNKNOWN··
PRVPRV-252012026-03-20T13:38:50ZJacob—Fields1996-01-20N/ANULLUNKNOWNUNKNOWN4079 Pine DriveEDEN PRAIRIEMN55338nullNULL
PRVPRV-235852026-02-10T11:04:24Zcatherine—tucker09-02-1967NULLN/A·9256588008-··7520 Ridge RdAUSTINTX78746—null
PRVPRV-280892026-02-18T21:09:47ZMASON····REYES05/28/1943—-613.210.7472mason.reyes@outlook.com··--UNKNOWNN/A——
PRVPRV-219012026-08-06T18:43:29ZLOGAN—POWELL1961-06-22UHC-51488-43-—LOGAN.POWELL@AOL.COM9821 Cedar LnSACRAMENTOCA95845··—NULL
PRVPRV-225942026-02-24T23:29:51Z Patricia—Gomez1024-19-04UHC-71807-52··(292) 841-8674—3964 HIGHLAND AVEScottsdaleAZ··85299N/A-
PRVPRV-221842026-08-14T18:57:04ZPalmer, EricL—1964-11-24UHC-87376-84—(742) 322-5171N/AnullNULL····--—
PRVPRV-242272026-01-31T13:27:38ZSara F—Murphy2008-01-24UHC-77515-85—(366) 901-0347sara.murphy@outlook.com7201 CEDAR LANELas VegasNV89184UNKNOWNN/A
PRVPRV-200912026-05-28T05:20:37ZKenneth—Rivera01/14/65··UNKNOWNNULL220-360-0906KENNETH.RIVERA@OUTLOOK.COM6922 Park PlFresnoCA93706UNKNOWN—
PRVPRV-288182026-07-14T21:45:11ZEmilyKSanders1986-01-07UHC-00963-32··N/A885.381.2859···261 PARK PLPLANOTX75086-CHOICE-PLUS-PPO··
PRVPRV-273602026-08-21T05:32:56ZMoore, Ashley——·1966-04-16nullNULL(273) 903-5923ashley.moore@gmail.com-UNKNOWNnull——CHOICE-PLUS-PPO
PRVPRV-236162026-02-21T22:01:43ZHenry—Nguyen19750718——14925628011—3106 Palm DrColumbusOH43272-9228····UNKNOWN
PRVPRV-257922026-10-16T04:16:54ZMariaMBanks1962-11-18UHC-03666-24UNKNOWN··343-999-6331·-·UNKNOWNnull—NULL—N/A
PRVPRV-234962026-01-28T08:30:45ZvalentinaU.wagner1950-07-17—•••-••-7549620-654-3920—6600 Harbor BlvdSacramento·CA95844—····
PRVPRV-201412026-09-02T01:35:05ZJoanY.Bryant12/01/1958UHC-19390-36null(525) 388-7592—6477 Spring StMesa·AZUNKNOWN——
PRVPRV-26543 2026-08-30T20:54:04ZPATRICIAESANCHEZ07/20/42UHC-39394-07-(838) 655-5550-——UNKNOWN-UNKNOWNCHOICE-PLUS-PPO
PRVPRV-240192026-06-05T19:08:35ZMason, Omar——1987-04-02UHC-04768-23null5855453290UNKNOWN8246 UNION STMinneapolisMN55445-CORE-HMO
PRVPRV-206652026-03-04T11:39:33ZNancy—Bennett1940-03-16UHC2866492•••-••-6142NULL—7655 Bayshore DrDENVERCO80244——
PRVPRV-248792026-03-12T23:41:27Zjonathan····mason1958-03-06UHC-16686-90null12557387009JONATHAN.MASON58@GMAIL.COM8561 Mesa DriveMinneapolisMN55467··UNKNOWNUNKNOWN
PRVPRV-202442026-09-17T03:07:27Z LindaABishop19740125null—(350) 656-9452linda.bishop@outlook.com2829 Pine DriveTampaFL33684·····null
PRVPRV-253732026-06-29T02:11:54ZLOGAN··RICHARDSON11/11/1981UHC-44547-13—3566552589··—2481 Apache BlvdLas Vegasnv·89167-1942··—
PRVPRV-225782026-02-23T11:04:11ZNATHANWBENNETT1952-12-41——9715566125UNKNOWNN/ANULL··N/A—null
PRVPRV-271952026-06-02T15:53:25ZRuiz, RalphA.—1950-05-14NULL-(817) 960-5979N/A5738 VALLEY VIEW DRIVEMesa·az85298-MEDICARE-ADV-B
PRVPRV-263112026-09-29T20:10:12ZTimothy—Santiago5/10/1997UHC-53349-30—6475266timothy.santiago@aol.com720 Church StTampaFL33634N/A—
PRVPRV-25423 2026-06-23T05:11:54ZHughes, Jon——1980-00-19UHC-60893-02•••-••-1877475-941-5575-1879 Union StreetFresnoCA93779—CHOICE-PLUS-PPO··
PRVPRV-225932026-08-12T12:04:45ZPATRICIAO·GOMEZ24-10-1940NULL—N/Apatricia.gomez38@yahoo.com3964 HIGHLAND AVENUEScottsdaleAZ··85299null—
9,596 rows, page 87 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.101Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty