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-265452026-08-26T15:55:39Z SandraZAlexander19500413N/A•••-••-6477776-301-9396··SANDRA.ALEXANDER42@AOL.COM8420 Forest AvenueFRESNOCalifornia93709——
PRVPRV-253332026-08-26T19:25:19Z·Sandoval, Luis—····19710704··UHC-78529-45•••-••-99196944229068··6877 MOUNTAIN VIEW DRIVEJACKSONVILLEFL32234UNKNOWN—
PRVPRV-224462026-06-22T22:57:32ZBRYAN—HERRERA11/28/2003—UNKNOWN18374424852BRYAN.HERRERA28@OUTLOOK.COM7399 Palm DriveGlendaleAZ85386-—
PRVPRV-292332026-05-27T06:26:56ZRios, Wayne——01-10-1985NULL··5787018798-·4228 Market StreetSAN ANTONIOTX78253··N/A··—
PRVPRV-222712026-01-31T04:53:06Zjanet—fox07/05/1996UHC6996818-··4845099574janet.fox10@aol.com9667 MESA DRIVEColumbusOH——UNKNOWN
PRVPRV-284982026-07-23T20:43:08ZKATHRYYN—COOPRE20000727UHC-35430-35-(275) 704-3925—2987 Spring StSan Antonio··TX··—null
PRVPRV-245972026-05-15T13:43:19ZLORI—ROBERTS1999-01-04—UNKNOWN13614702211—9741 CANYON RDHoustonTX77071null—
PRVPRV-213632026-07-12T23:34:45ZseanOturnerFeb 11, 1965——6704865899sean.turner@yahoo.com2219 Bayshore DrTAMPAFL33618—OPTIONS-PPO··
PRVPRV-248382026-07-05T15:59:55ZWalter—Phillips10/01/1998UHC-08695-23—6074994751UNKNOWN3291 Broadway #181FresnoCA93755N/A··N/A
PRVPRV-260152026-03-16T21:22:10ZTyler—LiFeb 8, 1939uhc-35505-93•••-••-3302507-569-4556·UNKNOWN3573 GRAND AVELas VegasNV89111-7603nullMEDICARE-ADV-A··
PRVPRV-222112026-08-23T04:18:12ZStven··Ellis1944-12-28UHC-97673-76null14918030432—6255 PARK PLJacksonvilleFL32272——
PRVPRV-257742026-06-27T05:34:34ZWEI—WOODS2003-02-07——(602) 288-7750—4294 Valley View DrSAN DIEGOCA92162-6769·--
PRVPRV-293882026-04-24T02:39:13ZMargaretMStone19391220UHC8260239UNKNOWN(974) 929-3907—854 RIVER ROADPhoenix··AZ····—MEDICARE-ADV-A
PRVPRV-286342026-10-06T01:27:39Zjordan····carr1973-07-06·UHC-39558-60—+1 368 223 8387JORDAN.CARR62@YAHOO.COM··205 Spring StGilbertAZ85242-null
PRVPRV-287832026-01-10T09:01:07ZBilly—·Hayes1974-05-19-··•••-••-5474206.776.9094NULL3862 Apache BlvdTUCSONAZ85765N/AUNKNOWN
PRVPRV-287942026-05-13T06:48:27ZChristine—Marquez01/03/1941UNKNOWNN/A(972) 442-9407·UNKNOWN—-—N/AUNKNOWNNULL
PRVPRV-286992026-01-21T14:08:37ZSamanthaHArmstrong1954-05-07-N/A+1 422 632 4549NULL6687 Elm StDenverCO80297-N/A
PRVPRV-278882026-02-01T20:19:32ZLoriR.Guzman0141-19-57··UHC-40801-21NULL·9249716506lori.guzman26@yahoo.com8493 WASHINGTON STREETSan DiegoCA·92122-·UNKNOWN
PRVPRV-25452 2026-07-04T21:10:40ZKarenA.Arnold1955-08-18··UHC-28271-38—17296739082karen.arnold65@proton.me3188 Washington Street #792Phoenix·AZ85027—N/A
PRVPRV-275672026-09-29T08:19:26Z RogerE.Ortiz1980-03-26null•••-••-0041510.733.4364roger.ortiz@proton.me3575 Baseline RdAustin··TX··78786UNKNOWN—
PRVPRV-244002026-01-06T16:25:43Z Nancy—Lane1959-10-12——16283874434—8901 Market StCharlotteNC28269nullN/A
PRVPRV-262782026-06-11T14:48:17ZMichelle—Clark1987-06-28··UNKNOWN—(718) 627-5243michelle.clark92@yahoo.com4196 Union StMiamiFL33116null—
PRVPRV-233662026-02-22T12:39:16Zralph—arnold1951-08-10—•••-••-7036(741) 968-4318ralph.arnold@hotmail.com1384 CANYON RDPlanoTX75089UNKNOWN—
PRVPRV-218152026-01-16T15:47:17ZJessica—Mendez19581124UHC-94335-21NULL2742227518—1455 Meadow Lane·PhoenixAZ85016NULLNULL
PRVPRV-252112026-05-24T20:00:53ZJames—Mejia·1976-04-10NULL—(567) 686-4892james.mejia27@hotmail.com1966 Palm DriveColumbusOhio43262UNKNOWN-
PRVPRV-226442026-08-01T12:02:30ZHelenKFreeman20000391UHC-18574-51—NULLHELEN.FREEMAN22@YAHOO.COM712 Main StreetSan AntonioTX—null—
PRVPRV-284012026-09-11T21:32:53ZDIEOH··FORD19451027NULLN/A··770-526-2408—3131 APACHE BLVDTempeAZ-NULL—
PRVPRV-206792026-02-06T05:56:48Zbruce—fisher··10/14/91UHC0746766—9866068988—1939 Pine DrCharlotteNC28268NULL··MEDICARE-ADV-B
PRVPRV-27276 2026-01-30T01:41:56ZRachel—Daniels··1994-12-06UHC-53886-76N/A(930) 516-2541N/A1557 Cedar LaneSan AntonioTexas78225NULL····
PRVPRV-286232026-03-08T21:26:33ZBranndon—Davis1984-01-06UHC-42245-62--—1491 Jefferson AveGLENDALEArizona85371UNKNOWNCHOICE-PLUS-PPO··
PRVPRV-270412026-09-13T20:26:18ZMontgomery, Judy——14-02-1962UHC-91198-73N/A700-387-5748judy.montgomery50@aol.com6221 Central AvenueEden PrairieMN55388—·N/A
PRVPRV-224772026-05-15T09:46:47ZEvelyn—Oliver1968-04-04—null(541) 272-2182·evelyn.oliver@yahoo.com4670 Maple AveCHANDLERaz85289N/ANULL
PRVPRV-264182026-06-06T09:26:54Zperez—jose4/25/1980—•••-••-71056265567316UNKNOWN4123 Central AvenueGilbertAZ85257··—N/A
PRVPRV-224882026-01-19T16:54:04ZSophia—Wright1999-04-21UHC-97117-15•••-••-54017807082sophia.wright@outlook.com6459 Palm DrAtlantaGA30341···nullNULL
PRVPRV-288602026-07-28T22:30:00ZMitchell, Mariana····—1972-03-12UHC-47406-20—·771-738-1941mariana.mitchell@gmail.com762 Sage CtTempeAZ85203NULLN/A
PRVPRV-278582026-10-10T00:20:34ZDEBRA—LEE1995-07-27N/ANULL433-334-2670null·8651 JEFFERSON AVENUEEden PrairieMN55330—CORE-HMO
PRVPRV-228642026-08-06T16:29:02ZRAYMOND····PAYNE06/01/67UHC-06240-95-+1 380 847 8937null7626 BroadwayDENVER···Colorado80272N/ANULL
PRVPRV-259952026-03-14T15:08:52ZPadilla, Andrea········07-05-2008UHC-09343-48•••-••-35912644460null501 Harbor BlvdCharlotteNC··28227N/ANULL
PRVPRV-222782026-06-28T18:49:33ZHENRY····PALMER2001-07-28UHC-86219-27-UNKNOWNhenry.palmer67@hotmail.com6770 Sage Court Apt 28TUCSONAZ85721-3370NULL—
PRVPRV-283932026-07-31T05:59:01ZHAROLD—SANDOVAL2006-12-28UHC-13759-35N/A(873) 987-2211—3094 Mountain View Dr·JacksonvilleFLN/AN/A—
PRVPRV-283892026-01-05T16:44:03ZJoshuaS··Castro1939-02-12UHC-23978-17—4599778642·null2052 River RoadTucsonAZ85787NULLOPTIONS-PPO
PRVPRV-279942026-03-08T09:33:56ZLAWRENCE—FULLER0200-12-09-N/A978.360.4569N/A·-UNKNOWNUNKNOWNnull··nullUNKNOWN
PRVPRV-262422026-02-24T12:28:28ZCAROLYNZ.··JAMES1987-01-25N/ANULLnull-—UNKNOWNNULLnull—null
PRVPRV-259812026-06-15T14:08:11ZJose—Griffin1973-12-16UHC-35738-01NULL940-486-0601NULL4251 Mountain View DriveAtlantaGA30303-2477—null
PRVPRV-233842026-01-30T08:10:13ZDENISEHROSS10-07-1975UHC-51808-48—(305) 646-9510NULL9734 Apache Blvd··ColumbusOH43223UNKNOWN—
PRVPRV-247512026-09-30T23:53:53ZCAROL—GARZA1977-02-06—•••-••-26766003746310·-—null--N/A·NULL
PRVPRV-246842026-06-05T22:21:23ZSARAR··LITTLE1981-10-12UHC-34139-98•••-••-8153720-936-1742sara.little55@proton.meN/A—NULL-·-—
PRVPRV-268252026-05-30T20:12:37ZRAYMOND—COLLINS·1971-03-26UHC-04176-72•••-••-2280NULL·raymond.collins@gmail.com6254 Forest AvenueSeattleWA98140NULL—
PRVPRV-265882026-08-09T15:05:05ZvincentHthomas10/15/04N/A•••-••-1852·6622624vincent.thomas@yahoo.com·4712 WILLOW CTNashvilleTN37264NULL—
PRVPRV-206942026-02-14T22:38:38ZLawrence, Hioshi——2005-09-10null-19075599530HIROSHI.LAWRENCE14@HOTMAIL.COM8338 CEDAR LANE #163···TucsonAZ85797-MEDICARE-ADV-B
9,596 rows, page 42 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:40.325Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty