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-237482026-02-06T12:50:58ZJENNIFERE.WATSON2004-05-07null—(890) 714-0389N/A9725 Harbor BlvdTucsonAZ85783NULLN/A
PRVPRV-247612026-08-09T13:11:52Z CHRISTIAN—EDWARDS19770319·····null+1 445 857 7107NULL———UNKNOWN—UNKNOWN
PRVPRV-279052026-04-10T16:57:54ZAndrea—Harper1989-01-06UHC-76420-19——andrea.harper67@hotmail.com8990 Spring StreetFRESNOCA93771N/AN/A··
PRVPRV-286152026-03-29T19:01:36ZChristian—Lane1977-09-16UHC-80877-08—374-201-1782-4761 OCEAN AVEScottsdaleAZ85270—·UNKNOWN
PRVPRV-203342026-05-26T00:06:34ZKenneth··NParker2/16/2001UHC-71358-38——KENNETH.PARKER63@PROTON.ME6628 BASELINE ROADCharlotteNC28215·NULLNULL
PRVPRV-211092026-04-21T21:56:10ZHIROSHI—DEAN1990-01-21UHC-65896-87N/A(413) 798-3234hiroshi.dean79@gmail.com·8478 Lincoln WayAUSTINTX78784—MEDICARE-ADV-B
PRVPRV-248072026-04-19T01:15:36ZAnthonyH.Rodriguez·2002-10-08UHC-83511-59—nullN/A1004 PALM DRIVEMINNEAPOLISMN55457NULL-
PRVPRV-249502026-08-18T15:38:35ZLISAI··YANG18-12-1963nullNULL(272) 256-7161lisa.yang71@outlook.com6761 Oak StreetScottsdaleAZ85229—null
PRVPRV-256042026-01-01T14:47:24ZROY—MARTINEZ1954-12-03UHC-35367-39··—5233003240roy.martinez90@yahoo.com985 Union StreetGlendaleAZ85377null—
PRVPRV-275272026-06-05T02:05:30ZNichols, CharlotteV—19-05-1970UHC-53965-50•••-••-7308814-824-4059charlotte.nichols@hotmail.com3495 Market St #722ColumbusOHUNKNOWNUNKNOWNMEDICARE-ADV-A
PRVPRV-237092026-02-06T21:14:13ZABBY—JOHNSON1969-11-17NULL··NULL·(716) 791-9653N/A··658 Elm StreetCHARLOTTENCnullN/A—
PRVPRV-251162026-06-15T05:33:43ZELIJAH—SMITH1982-08-13UHC-57936-14•••-••-73099618841968ELIJAH.SMITH89@AOL.COM518 Desert Sky BoulevardSeattleWA98134UNKNOWNCHOICE-PLUS-PPO
PRVPRV-282182026-06-14T23:45:27ZJACOB—GRAHAM1996-10-18UHC-88516-21—2734426145—8551 MEADOW LNMesaAZ85249—·NULL
PRVPRV-272982026-01-03T20:39:32ZJulie—Butler1976-09-06UHC-18149-70—284-795-5261julie.butler60@yahoo.com3540 Apache BoulevardLOS ANGELES··CA90080NULL····
PRVPRV-272232026-07-06T15:25:44ZKeith—Vargas3/5/1955NULLN/A6193209775KEITH.VARGAS@AOL.COMUNKNOWN-UNKNOWN—UNKNOWN—
PRVPRV-250952026-01-30T09:19:09ZTorres, Carlos——1970-09-14—•••-••-1175—null————·-—
PRVPRV-26726 2026-06-29T01:50:28ZGeorge—Santiago08/04/46UHC-43199-85null970-493-7058george.santiago@gmail.com——-—N/A-
PRVPRV-221582026-04-05T10:01:08ZMASNO—GRAHAM1983-02-26·UHC-31696-70•••-••-9503(785) 825-7532——N/AN/AN/AN/A—
PRVPRV-272702026-01-14T16:42:44Z·JOAN—WEBER1940-06-07—null862-619-8648-·2151 Canyon RoadLos AngelesCA90083-—
PRVPRV-244612026-04-21T10:00:40ZJean·J.Carpenter02/01/1966UHC-69541-09NULL(777) 991-6915JEAN.CARPENTER73@GMAIL.COM3025 BAYSHORE DRIVE Apt 23TempeAZ85287NULL-
PRVPRV-216062026-04-23T06:10:13Z·brian—martin1955-12-12··N/A•••-••-7959292-975-5523brian.martin57@aol.com··8828 Cedar LnSeattleWA98113—null··
PRVPRV-256072026-09-19T19:43:27ZDorothy—Garrett08/11/41UHC-53784-33NULLUNKNOWNDOROTHY.GARRETT90@YAHOO.COM6322 Ridge RdScottsdaleAZnull——
PRVPRV-271142026-05-01T03:45:53ZDot C.—Rivera1958-07-18nullN/A248-946-3431N/A7881 PINE DRIVENashvilleTN·37223—SELECT-EPO
PRVPRV-212712026-02-12T13:24:20ZGeorge—Moreno··1975-07-02UHC-65364-35··5858632110george.moreno12@icloud.com9621 CEDAR LANEPhoenixAZ·····N/A-
PRVPRV-265622026-06-05T19:23:09ZLarry—LawrenceAug 16, 1962NULLnull(205) 811-3418-891 INDIAN SCHOOL ROADGLENDALEArizona-N/Anull
PRVPRV-276882026-08-02T18:11:20ZEvelynFAlvarado24-10-1979UNKNOWN•••-••-5487(306) 521-7185NULL6542 Mesa DriveSAN ANTONIOTX78232UNKNOWNNULL
PRVPRV-228872026-03-11T20:02:52ZNUNEZ—ALAN08/05/2003UNKNOWN•••-••-4498+1 943 330 5822N/A6551 MAPLE AVETAMPAFL·33644—-
PRVPRV-247902026-09-21T18:36:24ZHarold—Greene1994-12-16—NULL(959) 543-9891harold.greene12@icloud.com7545 Ocean AvenueSeattleWA—NULLnull
PRVPRV-267122026-07-19T19:14:47ZArmstrong, Patrick——06/07/1974··UHC-97021-81UNKNOWN489-392-3571—9026 Willow CtGlendaleAZ85376····SELECT-EPO
PRVPRV-23969 2026-02-26T18:08:22ZMary—Marquez1981-01-20····N/A6229091859UNKNOWN9126 UNION STATLANTAGA30314-2455—UNKNOWN
PRVPRV-271782026-03-28T15:35:48ZGERALD····SULLIVAN2000-01-05UHC-47738-27—2464994450null7655 Desert Sky BoulevardTucsonAZ85772UNKNOWN··
PRVPRV-274242026-09-04T12:52:27ZMICHAELV.COLE1958-07-12UHC-18134-27•••-••-0352(528) 599-8440michael.cole76@outlook.com--—null—OPTIONS-PPO
PRVPRV-285762026-06-01T07:18:58ZALAN—MCDONALD1978-06-07UNKNOWN—7688792119N/A775 Jefferson AvenueOrlandoFL32814——
PRVPRV-258822026-02-28T06:53:33ZChavez, Margaret··G—16-11-1972UHC-76634-70null928.203.8691—27 SAGE CTSeattleWA98131N/A—
PRVPRV-219702026-03-22T13:13:53ZBRYAN—ESPINOZA1994-09-02UHC-68207-89—2272574323N/A1947 LINCOLN WAYChandlerAZ85275NULL—
PRVPRV-259462026-10-18T16:55:59ZDot—Weaver1941-10-26UNKNOWN•••-••-3293327.937.0475—916 Jefferson AveSeattleWashington98185——
PRVPRV-266652026-04-24T11:41:40ZCarl····Brns··1967-04-08-null(554) 324-1443NULL8720 HIGHLAND AVEGlendaleAZ85393null—
PRVPRV-201332026-06-10T15:11:31ZSarah—Patterson·2000-04-06UHC-49912-64·UNKNOWN(609) 753-6003NULL··N/A——-—N/A··
PRVPRV-246102026-06-20T15:45:03ZRuiz, Steven——19500710UHC-52473-73····7272466796null6429 SAGE COURTCHANDLERAZ85280·UNKNOWN·null
PRVPRV-235842026-06-26T21:23:56Z———1940-05-12————298 Sunset BoulevardPhoenixAZ85012-—
PRVPRV-218142026-07-13T10:08:44ZKathryn W—Perkins1957-12-14---—4850 Park PlColumbusOH43281··NULL
PRVPRV-262472026-03-26T05:07:21ZRANDY—CARLSON··1/28/1948UHC-66217-85•••-••-8110(311) 460-0537—9624 Baseline RdDallasTX75207null—
PRVPRV-200372026-03-18T17:25:10ZJames—Banks1963-11-24UHC-81378-63UNKNOWN15129607936null2639 Sunset BlvdHoustonTX77060——
PRVPRV-253842026-06-21T20:36:49ZChristopheer—Cunningham1990-03-02NULLNULL·+1 877 587 2086-9136 Apache Boulevard #867SeattleWA98120—-
PRVPRV-228582026-07-17T06:39:00ZPRIYA—ROBERTS1949-04-22UHC-42307-61—(575) 538-8631-7499 Market St #608·Las VegasNV89101-NAVIGATE-HMO
PRVPRV-295572026-05-08T04:13:17ZJANNY—KING1997-10-25UHC-93242-21•••-••-8297(760) 270-6297null2291 Forest Avenue #402San AntonioTX78224···null
PRVPRV-265972026-01-08T08:20:45ZLarry, Marshall——1971-07-04—UNKNOWN528-420-9087—1466 GRAND AVENUE Apt 21MINNEAPOLISMN55410··—NULL
PRVPRV-239142026-07-06T05:36:01ZJoseph—·Tran01/21/1948UHC-70624-20—758.358.8954joseph.tran26@aol.com5524 Oak StreetLOS ANGELESCA90094NULLN/A
PRVPRV-240782026-07-28T19:56:50ZElijahKHudson1967-07-17—UNKNOWN2080370—4748 Apache BoulevardNASHVILLETN37226—-
PRVPRV-273582026-07-26T13:19:53ZMrakO.Johnson1989-09-14UNKNOWN-888-702-3078··MARK.JOHNSON@OUTLOOK.COM3957 Willow Court #625ScottsdaleAZ85265—null
9,596 rows, page 66 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:43.452Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty