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-200622026-01-22T22:33:07ZJohn—Cunningham1945-02-12——NULL—1099 Palm DriveTempeAZ85296NULL—
PRVPRV-258502026-07-06T14:52:50ZChapman, Virginia·M—1962-03-20UHC-48124-81-7904542493····5683 Forest AvenueMIAMIFL33147nullN/A
PRVPRV-280222026-06-26T10:57:09ZDaniel—Nunez1954-01-09··•••-••-2746+1 217 621 7578null580 Church StreetGlendaleAZ85333—UNKNOWN
PRVPRV-295042026-09-06T07:08:18ZSophia—Reid11/27/1987NULL•••-••-3464(928) 313-8042UNKNOWN4481 Bayshore Drive Apt 28Las VegasNV89121-—
PRVPRV-217212026-08-17T08:41:52ZDEBORAH—BAKER1994-06-22—-5715185709null·3889 CANYON ROADPlanoTX-UNKNOWNNULL
PRVPRV-253892026-10-10T02:32:44ZSean—YangJan 27, 1966——·8445415132N/A9465 Palm DrSan DiegoCA92191——
PRVPRV-272312026-01-05T11:45:12ZBRUCE—BURKE08/05/79·UHC-27034-47····—NULL8889 CANYON RDTucson·AZ85730nullNAVIGATE-HMO
PRVPRV-283632026-07-29T18:40:04ZNicole—Nunez19910812——4878063447N/A1464 Cedar LaneAustinTX78747—UNKNOWN
PRVPRV-247992026-06-06T11:19:28Z·MARIA—CASTRO1973-08-17NULL-758-705-3617··maria.castro97@hotmail.com571 Maple AveDenverCO80249nullNULL
PRVPRV-233652026-09-28T23:35:25ZJULIE—JOHNSON12/09/71UNKNOWNNULLN/AN/A4699 Sunset BoulevardHoustonTX77023nullnull
PRVPRV-256522026-06-25T17:23:29ZAnn—Martinez9/21/2006UHC-19690-85NULL+1 203 908 2871N/A3769 Highland AvenueHoustonTexas··77030—NULL
PRVPRV-280832026-07-25T07:06:07Z·SANIAGO—WILLIS7/22/2005UNKNOWN—(345) 976-9221SANTIAGO.WILLIS40@PROTON.ME6570 MESA DRScottsdaleAZ85293NULL-
PRVPRV-255622026-05-17T17:57:01ZRandy—Fisher1984-01-26··null—840.554.7906UNKNOWN772 Harbor Boulevard #834ATLANTAGA··30393UNKNOWN—
PRVPRV-26701 2026-03-10T09:42:43ZEMILY····HARPER1972-02-15-NULL(572) 456-3674emily.harper@aol.com5798 Valley View DriveSan DiegoCA92124—null
PRVPRV-206672026-06-13T12:27:08ZLAWRENCE—MONTGOMERY1986-11-18——(598) 585-1297—201 Church Street··PhoenixAZ85043—CHOICE-PLUS-PPO
PRVPRV-251902026-09-06T12:59:17ZElizabeth—Fisher1955-03-03NULLUNKNOWN+1 340 681 8983ELIZABETH.FISHER@GMAIL.COM8427 MAIN STJacksonvilleFL32260·N/A—
PRVPRV-232722026-10-12T20:20:54ZMARIAW.GRAY12/02/1994UNKNOWN•••-••-2843329-500-2298···NULL7226 LINCOLN WAYCHARLOTTENC28208—N/A
PRVPRV-219732026-08-12T22:32:40ZMadison····Hamilton2/9/1990·N/A•••-••-6211221-790-2733MADISON.HAMILTON@GMAIL.COM2720 Forest AvenueScottsdaleAZ85288-4418NULL—
PRVPRV-218462026-04-13T19:52:03ZSARA—CARTER··08-03-1945NULL—UNKNOWNsara.carter43@outlook.com4145 Lake View RdPhoenixAZ·85097-—
PRVPRV-289172026-07-17T19:56:40ZLUCIA—WELCH1987-03-03UHC-60974-69—501-451-4426··-7565 Maple AvePLANOTX75030——
PRVPRV-235792026-01-31T02:15:02ZHenry—Gomez1957-07-16·UHC-44840-46null5165932301··henry.gomez@proton.me·8724 BAYSHORE DRScottsdaleAZ85211NULL—
PRVPRV-206612026-04-08T14:24:31ZHIROSHIDBAKER·1984-01-19UHC-28647-99—439-899-6615hiroshi.baker13@gmail.com6310 Indian School RdGlendaleAZ85357—NULL
PRVPRV-241802026-01-04T04:05:47ZMeganI··Andrews1974-07-14NULL—4377103717N/A9086 Palm Dr Apt 11ColumbusOH43274-UNKNOWN
PRVPRV-207012026-10-16T15:29:58ZDEBRA—BENNETT11/07/90UHC-53451-24-920-831-3051UNKNOWN6161 Union StSacramentoCA95838-6148UNKNOWNNULL
PRVPRV-255572026-03-16T12:32:26ZTheresaCHamilton07/17/78—-274-999-0981····412 Central AveTampaFL33602N/A—
PRVPRV-285772026-06-21T06:16:51Z·natalieOrios12/13/62-•••-••-5701(423) 811-2457-8638 BROADWAY··TUCSONAZ85787N/A-
PRVPRV-281412026-08-19T09:49:40ZAbigail—DanielsMay 18, 1969UNKNOWNUNKNOWN3617580033—6875 Indian School Road #625Los AngelesCA90059——
PRVPRV-27119 2026-10-14T04:29:43Zrandy—maldonado1963-10-24UHC-17028-42•••-••-51695507664265-8563 Apache Blvd Apt 11GlendaleAZ-·N/Anull
PRVPRV-289342026-02-16T18:23:01ZSandraQ.White2005-05-03UHC-13421-40—(948) 544-9274—2142 Indian School RdAtlantaGA30380——
PRVPRV-266452026-10-08T17:16:37ZKevin····Marshall1997-04-04UNKNOWNUNKNOWN+1 771 469 0933kevin.marshall@hotmail.com105 HARBOR BLVDDallas·TX75263——
PRVPRV-284922026-01-26T04:52:17ZShirley I—·WebbFeb 11, 1995UHC-31639-64—+1 286 298 4785·NULL9083 Hillcrest RoadTempeArizona85264-6327——
PRVPRV-250752026-07-30T03:51:36Z·Diego—Wood05/03/98nullnull767-634-3463DIEGO.WOOD@ICLOUD.COMNULL-UNKNOWN-NULLN/A
PRVPRV-292442026-05-31T13:17:33ZKathleen—Duncan11/23/1977-N/A·9808533434N/ANULL·nullNULLNULL——
PRVPRV-228382026-05-05T19:43:45Zdebbie—berry··1940-01-16UHC-77773-42··N/A586-785-0565deborah.berry7@aol.comN/AUNKNOWN··—-··—N/A
PRVPRV-270342026-05-29T19:45:17Z Fowler, Kevvin····—1963-10-01uhc-05853-80-874-572-2321NULL5151 Valley View DrChandler··AZ85203——
PRVPRV-290972026-06-09T19:05:45ZDAVID—ARMSTRONG2003-07-06——963-308-9533david.armstrong74@outlook.com6241 HILLCREST RDGLENDALEAZ85369-UNKNOWN
PRVPRV-219212026-09-13T23:46:57ZCHARLOTTEL.WALLACE1991-01-04N/AUNKNOWNnull—8740 Highland AveMesaAZ85202N/A—
PRVPRV-248722026-05-01T11:40:57Z·Logan—Kelly1978-06-24·UHC3591653•••-••-7640896-510-4633—6858 Central AvenueNashvilleTN37221——
PRVPRV-218382026-06-28T15:23:21ZKatherine—Gray·1953-09-10UHC-59420-18-6783926456—7566 BAYSHORE DRGilbertAZ85299——
PRVPRV-258882026-09-08T18:08:22ZSANTIAGO—OBRIEN1991-08-09-•••-••-5597+1 477 586 2551··—9425 MAPLE AVENUEScottsdaleAZ85237—-··
PRVPRV-217272026-05-31T04:10:34Zkathryn—harvey1999-12-05null-nullKATHRYN.HARVEY25@PROTON.ME1314 Main StreetMesaaz85254null-
PRVPRV-274872026-08-06T06:47:43ZRiick—Jenkins09/25/53-•••-••-2140(400) 979-3863··—1374 FOREST AVEAustin·TX78715UNKNOWN-
PRVPRV-263642026-07-24T10:38:01Z·jacob—ramirez1979-06-01—null(207) 207-0968jacob.ramirez@aol.com6959 Willow CourtTempeAZ85296——
PRVPRV-256672026-01-31T11:55:56ZCATHERINE—FULLER19610227UHC-08698-57—·(904) 652-0459UNKNOWN3944 Oak St Apt 37DenverCO80224N/AUNKNOWN
PRVPRV-273422026-02-21T14:39:22ZSofia··Smith··5/13/1988uhc-24303-04•••-••-4374+1 382 938 2876UNKNOWN6410 Oak StreetTempeAZ85257null·NULL
PRVPRV-224662026-10-16T15:57:41Z·Ahmed··Spencer1994-06-20UHC-74337-10null+1 492 524 5904—317 Park PlaceMesaAZ85244—NULL
PRVPRV-256422026-07-12T08:20:31ZDanielle—Wheeler1997-09-09UHC-34384-77NULL(676) 211-4890-3755 CHURCH STHoustonTX77002-0314——
PRVPRV-295172026-07-01T00:04:10ZWilliePReyes1967-07-18UHC2207799····+1 662 814 0514willie.reyes22@aol.com—UNKNOWNNULLNULLnullNULL
PRVPRV-281782026-08-30T04:00:17ZHerrera, Mary——03/20/1973-—(829) 918-9312UNKNOWN7943 PALM DRIVEHoustonTexas··77040NULLNULL
PRVPRV-255562026-07-21T09:34:31ZSchultz, Wei——9/3/1995—NULL614-361-8318—552 INDIAN SCHOOL RDEden PrairieMN··55383-0879——
9,596 rows, page 28 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:37.768Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty