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-295102026-07-03T12:57:07ZSandraMScott1974-11-01N/A-+1 411 580 8782sandra.scott@gmail.com3389 Harbor BoulevardLas VegasNevada89158N/AUNKNOWN
PRVPRV-224532026-04-20T07:53:38Z Deborha—Alvarado2006-02-04null——deborah.alvarado@proton.me5707 OAK STNashvilleTN37245——
PRVPRV-250722026-02-13T10:42:39ZJensen, Alan——19781009UNKNOWN—8496178801··alan.jensen@gmail.com2617 Oak StSeattleWA98171——
PRVPRV-200562026-02-28T10:13:20ZTERESA—FRANKLIN2006-09-27UHC-79947-46•••-••-9827496.505.6080UNKNOWN4892 BROADWAYOrlandoFL32896N/Anull
PRVPRV-276322026-07-30T14:03:28Z·Eric—Robertson2008-07-10UHC-01745-78··—218-627-1767null3096 Union StreetFresnoCalifornia93766N/A—
PRVPRV-270492026-02-14T03:28:16ZSandra··—Santiago1951-04-21UHC-18065-04——sandra.santiago81@gmail.com94 Maple AveLas VegasNV89172N/A-
PRVPRV-277592026-03-27T16:37:26ZBrittany—Walsh1984-05-09·UHC-72666-02—(966) 401-3822—6263 Forest AveDenverCO80220N/AUNKNOWN
PRVPRV-238812026-06-09T07:02:21ZBrandon—Rojas1940-05-16UHC-05735-97•••-••-2861335-319-4071brandon.rojas@yahoo.com5141 UNION STREET #419SEATTLEWashington98127nullNAVIGATE-HMO
PRVPRV-276752026-09-30T20:39:44Z———1969-05-14··-··UNKNOWN+1 748 800 0987CARLOS.ESTRADA85@HOTMAIL.COM4195 OCEAN AVENUEDENVER··CO80281-—
PRVPRV-288982026-09-10T06:53:34ZFrank—MartinFeb 26, 1985——·(977) 971-8332frank.martin@hotmail.com4732 Market Street·TampaFL33652—·null
PRVPRV-257442026-05-27T19:32:28ZValentina····King06/23/2007N/A—8446694586—5606 GRAND AVENUEColumbusOH·43291·-null
PRVPRV-283282026-06-06T07:02:25Z Kelley, Dennis——1978-04-18UHC-97854-14··(793) 222-0150NULL··3742 MEADOW LANEChandlerAZ85217—NULL
PRVPRV-283912026-10-14T08:33:24ZCarolyn—Santiao·1979-07-12UHC-60388-44UNKNOWN(258) 908-7250-495 Indian School RdDallasTX75282—··
PRVPRV-265172026-02-27T20:46:54ZMATTHEW—SCHMIDT1990-04-09UHC2129399—7876960213MATTHEW.SCHMIDT@OUTLOOK.COM··nullUNKNOWN·-——-
PRVPRV-227662026-09-02T10:38:13ZMARIANAJ.JIMENEZ1965-07-21nullUNKNOWN(901) 599-1310—4008 Church StMIAMIfl·33101——
PRVPRV-272402026-03-21T20:28:24ZJose F.—Ford0361-19-92nullN/A(893) 375-9581jose.ford@yahoo.com7094 Jefferson AveMESAArizona85212nullMEDICARE-ADV-A
PRVPRV-229872026-08-15T21:56:31ZKEITH—TORRES19551222N/AN/AUNKNOWNKEITH.TORRES60@PROTON.ME8102 MAIN STHoustonTX77018—NULL
PRVPRV-225272026-04-02T16:14:58ZSantiago—Fowler10-12-1946UHC-38032-37nullN/A—566 BroadwayLas VegasNV·89197nullN/A
PRVPRV-208812026-01-02T05:04:25Z·Shaw, Ralph——1955-09-18·····UNKNOWN5007335—6408 CENTRAL AVESAN ANTONIOTXN/A—CHOICE-PLUS-PPO
PRVPRV-290022026-07-05T14:53:18ZMARIA—SCHMIDT1957-04-28UHC-24260-23UNKNOWN19489914605UNKNOWN8387 Willow CourtColumbusOH43200·N/Anull
PRVPRV-261902026-02-26T01:02:15ZDonna—Woods1993-02-11·N/A—+1 349 614 1350donna.woods@proton.me4147 Cedar Lane·Miami·fl33143——
PRVPRV-276342026-08-21T07:02:44ZMARCUS—FOSTER1961-09-23-—683-872-2074UNKNOWN—NULLnull—UNKNOWNUNKNOWN
PRVPRV-250792026-08-26T00:42:42Z·Valentina—Wood20-02-1989UHC-77504-30—849-875-2268-··464 OAK STREET·GilbertAZ85297—N/A
PRVPRV-206762026-04-02T23:00:50ZOlivia—Hart10/26/1976-NULL—olivia.hart@gmail.com9622 Highland Avenue Apt 18HOUSTONTX77017-null
PRVPRV-213852026-10-06T04:46:39ZAlbert—Griffin1953-03-15N/A—·+1 937 818 0044N/A2971 Canyon RdMinneapolisMN55498—NULL
PRVPRV-264702026-04-10T22:22:58ZHarrison, Thomas··——1996-03-24·UHC-69538-36-388-212-2897··thomas.harrison@gmail.com9744 Ocean AveEden Prairiemn55304——
PRVPRV-230862026-04-15T05:02:22ZRobertson, Ahmed——1973-04-27NULLNULL—N/A9758 Valley View DriveSacramentoca··95848N/A-
PRVPRV-208112026-04-20T02:57:06ZLi—GeraldDec 24, 1954·UHC-76640-91N/A+1 791 321 3625gerald.li@icloud.com2913 Apache BlvdGilbertAZ85201-5019null—
PRVPRV-255682026-09-25T22:34:45ZAlice—Herrera1980-06-25NULLUNKNOWN—NULL7946 ELM STJacksonvillefl32268-7293N/A—
PRVPRV-206532026-03-30T07:03:23ZGary—Munoz··Oct 25, 1965UHC-01867-73•••-••-8179737.601.8815—8538 OCEAN AVENUENASHVILLETN37225-6491··——
PRVPRV-278102026-03-07T09:17:40ZTERESA—ELLIOTT11/27/39UHC-87593-18N/A·N/Anull621 GRAND AVEGilbertArizona85259UNKNOWNUNKNOWN
PRVPRV-261662026-07-02T18:03:58ZSofia—Riley1998-07-26NULL—388-864-0892sofia.riley@icloud.com··6118 Central Avenue··FresnoCA··null—null
PRVPRV-244202026-05-25T23:13:51Z DANIELLE—RAMIREZ1966-02-11UHC-72750-13-—danielle.ramirez47@icloud.com8031 SPRING STREETMiami·Florida33107——
PRVPRV-226962026-08-05T22:40:38ZAnna—Hall2001-04-04UNKNOWNnull··981.632.8969—·1680 Jefferson AveMiamiFL33114-0269—SELECT-EPO
PRVPRV-256062026-09-16T06:53:51ZAmandaUKingJul 4, 1986—N/A(329) 923-0443amanda.king@outlook.com1813 MAPLE AVENUEMesaAZ·85208-SELECT-EPO
PRVPRV-200602026-02-22T16:25:56ZRussellD··Matthews1998-06-27UHC7442181null3015054031RUSSELL.MATTHEWS@HOTMAIL.COM2003 Baseline RoadCHANDLERAZ85293NULLSELECT-EPO
PRVPRV-282352026-02-12T02:28:03ZMARGARETJJORDAN1966-06-21UHC-24141-95NULL+1 708 791 1723·UNKNOWN3038 Sage CourtTempeAZ85286··NULL·UNKNOWN
PRVPRV-241282026-06-03T07:46:30ZMatthew—Lewis08/11/1980—N/A738-674-2007MATTHEW.LEWIS86@PROTON.ME2427 Harbor BlvdTempeAZ85217··—CORE-HMO··
PRVPRV-204402026-06-25T08:17:21Zlarry—ortegaOct 10, 1970UHC-13292-28•••-••-4735310.221.6691—6320 BASELINE RDEden PrairieMinnesota55358··-UNKNOWN
PRVPRV-213282026-10-11T15:15:11ZLINDAEBURTONNov 6, 1988uhc-38270-36··212-968-2476-—-—null-MEDICARE-ADV-B
PRVPRV-242112026-02-07T17:07:49ZHarris, DianaI.—19670804UHC-73519-32—3265260649null4392 Broadway··Fresno··CA93786-1005UNKNOWN····
PRVPRV-206822026-03-12T01:30:22ZArthur··—Mills1986-10-20··UHC-01562-20-734-744-0962null9837 Jefferson AvenueAtlantaGA30303—····
PRVPRV-208782026-02-13T21:02:42ZDrew—Little05/10/58UHC-87409-19—(594) 667-3145—7294 Spring StreetCHANDLERAZ85257UNKNOWN-
PRVPRV-267812026-07-25T20:41:41ZDoris—Meija1971-01-16UNKNOWNUNKNOWN(302) 338-9122null5866 Maple AvenueAtlantaGA30315N/Anull
PRVPRV-23164 2026-09-11T06:29:00ZMariAVazquez·1980-02-04NULL—2478364773maria.vazquez33@outlook.com1782 BAYSHORE DRIVEPLANOTX75098——
PRVPRV-275942026-07-15T07:12:56ZGary—Kelly1970-12-25-N/Anullnull9565 Valley View DrSAN ANTONIOTX78237null·NULL
PRVPRV-295402026-02-27T02:37:29ZSena—Peters10/05/01—N/A340-415-8757sean.peters98@outlook.com—-UNKNOWNNULLnullN/A
PRVPRV-202962026-07-03T03:44:31ZPETERUCARTERFeb 24, 1999UHC-21483-29—(598) 254-7530PETER.CARTER@AOL.COM8215 Market StreetFresnoCA93755-0065N/A·-
PRVPRV-280772026-03-11T19:00:52ZWILLIAM—HUNT1993-07-18N/ANULL307-437-0892··william.hunt@icloud.com670 WILLOW CTOrlandoFL··32837-6819··null
PRVPRV-286682026-07-13T15:06:09ZAustinI.Parker··7/3/1952UHC-47167-07····326-806-6971austin.parker6@yahoo.com3166 Spring StreetMiamiFL33123NULL·-
9,596 rows, page 32 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.466Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty