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-251062026-06-29T11:43:47Zsophia—larson20-04-1987UHC-69834-51null(302) 901-2528UNKNOWN6801 Washington StreetTempe··AZ85263——
PRVPRV-214272026-06-29T11:18:43ZCARLOS—LAWRENCE1949-08-04UHC-29118-10———9012 Mesa Drive Apt 16PlanoTX75035——
PRVPRV-235672026-02-16T10:44:40Z·JANET—SANDERS04/02/63··nullUNKNOWN397.711.1586-———-··-NAVIGATE-HMO
PRVPRV-239402026-08-07T03:15:06ZDAVID—·SHAW1953-04-17—N/A(598) 385-9369—8652 Main StreetMiamiFL33165····-
PRVPRV-286402026-05-03T00:51:44ZMaria—Rose1968-09-16—N/A759-413-4013—1103 Sunset Boulevard·SEATTLEWA—null—
PRVPRV-286042026-04-06T22:35:18ZDON—BANKS1971-06-13-—474.235.5070-5222 CAMELBACK ROADAUSTINTX78730·-—
PRVPRV-216752026-05-08T02:20:36ZKathleen—Taylor·2004-01-06NULL•••-••-4575(341) 299-6523kathleen.taylor@gmail.com7201 Union StGilbertAZnullnull—
PRVPRV-208652026-08-26T22:19:11ZAaronIGilbert1981-09-11UHC-80916-38null15335187121aaron.gilbert95@outlook.com··1483 HILLCREST ROADNashvilleTN37287-7871UNKNOWN—
PRVPRV-223962026-09-25T17:09:04ZHelen···Austin9/10/2003UHC-03615-98··5828197153null9204 Ridge Road··GlendaleAZN/A——
PRVPRV-264082026-09-21T17:37:20ZcynthiaQortega19430204UHC-81402-27UNKNOWN4387570627cynthia.ortega24@icloud.com8531 Mountain View DriveATLANTAGA30311null-
PRVPRV-242832026-03-28T00:46:44ZSandra—Soto01-10-2001nullUNKNOWN212.971.4286null9307 Mesa DriveDenverCO··80280—MEDICARE-ADV-B
PRVPRV-294242026-01-17T00:11:36ZKyleQWells1988-04-04UNKNOWN—732-373-8105kyle.wells@outlook.com5026 Sage CtSacramentoCA95858—MEDICARE-ADV-A
PRVPRV-284222026-09-20T12:35:45ZAdamP·Hicks1979-05-03·UHC-61952-26—+1 471 653 2928ADAM.HICKS15@ICLOUD.COM5348 Mountain View DriveDenverCO80282——
PRVPRV-293752026-02-09T01:35:03ZWEI—ROGERS19910925—UNKNOWN·7742378258NULL9562 Elm StreetOrlandoFL32889-5655·nullN/A
PRVPRV-220322026-04-24T23:54:56Zgerald····davis07/13/59-null(791) 823-9090-7154 Pine DriveTEMPEAZ85215UNKNOWNUNKNOWN
PRVPRV-263752026-10-10T00:28:30Zmark—·bryant1993-06-04····-6974213297mark.bryant1@icloud.com190 HARBOR BLVDGlendaleAZ85310NULLUNKNOWN
PRVPRV-270822026-09-18T17:53:52ZJERRY—MARTIN1994-11-16—UNKNOWN3293310200jerry.martin89@gmail.com9420 Baseline RoadHoustonTX77025-null
PRVPRV-280672026-09-02T02:16:43Z·AISHA N.—MARTIN1972-02-24UHC-24039-32null8456994850-6550 Union StreetSeattleWA98184——
PRVPRV-228082026-08-08T05:36:29ZJordan·DSandoval1984-10-14uhc-19789-28NULLnullUNKNOWN1497 Bayshore Drive Apt 40TempeAZ85229—MEDICARE-ADV-B
PRVPRV-286822026-08-17T21:30:38ZMcCoy, Aisha——2004-08-22UHC-89978-22•••-••-0347(582) 414-6818—354 Market StSan DiegoCA92198UNKNOWNchoice-plus-ppo
PRVPRV-201202026-07-28T14:30:28ZCAMILA—BRYANT··1941-07-01UHC-78163-31UNKNOWN(409) 375-5405null517 Harbor BoulevardCOLUMBUSOH43259NULL··null
PRVPRV-253202026-01-13T15:24:25ZJanice—Greene19860815UHC-32981-06•••-••-7033·N/Anull3408 Spring StreetSacramentoCA95829-UNKNOWN
PRVPRV-205922026-01-07T14:24:01ZSantiago—BanksJun 22, 1956NULL—NULLSANTIAGO.BANKS@YAHOO.COM3079 HIGHLAND AVENUEScottsdaleAZ85224-·UNKNOWN
PRVPRV-235962026-03-27T10:54:49ZWILLIAM—ALVAREZ18-01-1944··—•••-••-4829N/A··—8942 Ridge RdPlanoTX75085-9379NULLUNKNOWN
PRVPRV-208832026-07-31T00:57:38ZDeborahLOrtaga1967-01-13—-746-213-6419NULL4916 Market StDallasTX75219UNKNOWN—
PRVPRV-227342026-02-15T06:49:12ZCharlotteG··Nuenz1991-06-08UHC-60651-71—UNKNOWNcharlotte.nunez@hotmail.com3202 Meadow LnPhoenixAZ85016-8950NULL—
PRVPRV-232122026-03-21T14:48:17ZPrice, Santiago——08-11-1940—UNKNOWN··+1 900 930 8202N/A3870 Sage CtDenverColorado80204—null
PRVPRV-284422026-01-04T04:57:55ZYang, LawrenceI··—11/07/62UNKNOWNUNKNOWN—-null·NULLnull··—-NULL
PRVPRV-243442026-02-23T06:28:05ZBADLEY—WEBER1989-10-06—UNKNOWN———UNKNOWNnullNULL—MEDICARE-ADV-B
PRVPRV-266772026-08-29T05:02:00ZDylanRRamos1961-07-22UNKNOWN———1058 Sunset BoulevardAtlantaGeorgia30336-N/A
PRVPRV-202742026-10-02T05:16:09ZMARY—PAYNE1948-01-25N/ANULL331.800.8869null2881 Apache BoulevardSeattleWA98120UNKNOWN—
PRVPRV-226432026-06-21T08:07:06ZPAUL—WARREN1989-02-11UHC-23202-90-655.898.6393-4438 WILLOW CTLos Angeles··CAN/Anull··MEDICARE-ADV-B
PRVPRV-247342026-09-17T18:33:10ZMadisonDBryant20060809··•••-••-18038817913094—2645 Union StreetDenverCO80298··null—
PRVPRV-263452026-05-27T15:50:47ZBRITTANY—SNYDER1940-04-21N/AUNKNOWN(954) 784-3216UNKNOWN1147 Forest AvenueLas VegasNVUNKNOWN—UNKNOWN
PRVPRV-251492026-05-24T11:32:41ZEmily—Harris1967-10-25N/A—985-476-8765—5568 Apache BlvdOrlandoFL32860—NAVIGATE-HMO
PRVPRV-257992026-02-01T07:08:49ZBILLYSPERRY2005-09-14—UNKNOWN16616504482·-———NULLUNKNOWN-
PRVPRV-279592026-08-05T13:34:16ZJordan·····Padilla2000-03-12··—(395) 469-4704JORDAN.PADILLA@GMAIL.COM1639 Baseline Rd Apt 29PhoenixAZ85032··—NAVIGATE-HMO
PRVPRV-270722026-04-30T23:39:31ZmariaV.vazquezJun 1, 1990UHC-44744-44—18449166831MARIA.VAZQUEZ@OUTLOOK.COM7929 Union Street··CharlotteNC28230N/AN/A
PRVPRV-286782026-03-07T02:41:15ZDiane—Snyder1952-05-14NULLN/A446-645-5108—2666 Spring St Apt 22··AustinTX78738-NAVIGATE-HMO
PRVPRV-208052026-03-10T15:46:51Z·MARK—RAY19470325N/ANULL7596828658mark.ray@outlook.com7803 VALLEY VIEW DRCHANDLERAZUNKNOWNNULLnull
PRVPRV-274822026-09-19T19:35:06ZJoan—Santos19780104-N/A15335437294N/A8108 Ridge RoadDALLASTX75208··N/ANULL
PRVPRV-218662026-05-12T00:15:23ZBARBARA—SIMPSON1949-07-18—UNKNOWN365-666-2571--nullnullNULL——
PRVPRV-264212026-06-23T00:57:13ZBARBTMARTNIEZ1961-08-20nullN/A13094428887barbara.martinez@outlook.com3302 Sunset BlvdFresnoCANULL--
PRVPRV-268372026-05-04T14:20:50ZMeganY.Thompson20070106NULLN/A745-377-7462megan.thompson20@outlook.com9786 Union StreetOrlandoFL32896—····
PRV PRV-203712026-10-14T22:02:25Zvictoria—hawkins··1977-02-12——+1 787 679 6539··N/A1995 SPRING STREET #774Las VegasNevada89155—-
PRVPRV-253382026-09-17T09:22:42ZAUSTIN—THOMAS2004-05-28UHC-15598-86—2043320144—9416 OCEAN AVENUESacramento··CA95859—UNKNOWN
PRVPRV-278382026-07-02T08:10:18Z·Roy··Powell1979-11-27NULLNULL503-257-1479-··482 BroadwayPlanoTX75010UNKNOWN·null
PRVPRV-210312026-09-03T14:23:14ZMartha—Bell1992-02-24UHC-89637-12-(640) 873-0598UNKNOWN3913 Main St··Las Vegas··NV89131—-
PRVPRV-287352026-07-01T06:01:41ZKaren—Hayes09/06/1944UHC-95889-23·null497-340-6912NULL6714 UNION STREETEDEN PRAIRIEMN55386—null
PRVPRV-219582026-07-09T20:45:42ZGabriel—Ross1982-07-27···UNKNOWNUNKNOWN(412) 374-7243··—5064 Mesa DrSacramentoCaliforniaNULL-····
9,596 rows, page 123 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:53.137Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty