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-285922026-09-23T15:20:56Zchristine—hughes1964-05-10--311-284-0799CHRISTINE.HUGHES@PROTON.ME3921 Bayshore DriveOrlandoFL32893N/AUNKNOWN
PRVPRV-262662026-03-11T00:29:40ZJordan··—Carroll1963-04-26UHC3480976—8036358972-7063 Sage CourtTucson·az85714—N/A
PRVPRV-249682026-03-29T06:49:02ZThompson, Chris——09/01/1939UNKNOWN-12637976993UNKNOWN9639 BroadwayMESAAZ85258-N/A
PRVPRV-217152026-06-07T16:49:25ZLOGAN—RYANSep 4, 1969null—7106752319NULL4749 FOREST AVENUETampaFL33657UNKNOWN—
PRVPRV-236992026-08-30T14:02:11ZHernandez, Brtitany——1/22/1972UHC-97157-40•••-••-2258960-347-1351—8092 Washington StMiamiFL33152—SELECT-EPO
PRVPRV-260772026-01-13T04:44:48ZmariaWromero1964-03-15·UHC-35666-67UNKNOWN(895) 456-0231maria.romero5@outlook.com4347 Willow Ct Apt 31··DALLASTX75275-5746NULLNAVIGATE-HMO
PRVPRV-234652026-10-04T13:16:19ZHannah·M.Flores11/18/1941UHC-63078-53—-—NULL—N/AN/AUNKNOWNNULL
PRVPRV-25900 2026-10-09T19:47:34ZRandy—Foster2006-08-09UHC-60554-67•••-••-9259(414) 587-4994———-——NULL
PRVPRV-275612026-10-10T11:31:44Z·Arjun—JensenMar 2, 1978NULLNULL·320-415-1379N/A7875 River RoadLas VegasNV89115——
PRVPRV-293132026-10-08T06:23:48ZAustin—Williamson2/11/1965—UNKNOWN(732) 393-7837—1133 Mesa Dr··CharlotteNC·28242—NULL
PRVPRV-294692026-05-02T23:47:48ZMichelle Z····AlvarezUNKNOWNN/ANULL19882735027null9370 Hillcrest RdTempeAZ85235—-
PRVPRV-259432026-05-22T06:11:57ZMeiRBarnes1960-11-03UNKNOWN—9202742273-··2888 Mountain View DriveNASHVILLETN37277NULL—
PRVPRV-281142026-07-16T05:17:38Zmargaret—yang1987-12-28UHC-98394-52N/A9723820513N/A45 PARK PLTucsonAZ85717N/A—
PRVPRV-235732026-01-02T16:54:13ZNatalieTTurner1989-06-07UHC-95921-01—403-424-4528null-NULL-UNKNOWNnull—
PRVPRV-218352026-04-02T18:27:41ZWILLIAMMGIBSON1955-09-23—-(947) 723-5664william.gibson@gmail.com9176 CHURCH STNashvilleTN37264null—
PRVPRV-254622026-06-29T00:52:05ZBarbara··FJames23-06-1988——658-950-4207UNKNOWN2480 OCEAN AVENUEMiami··FL33103··—NULL
PRVPRV-202372026-03-19T22:53:13ZMATTHEW—BROWN·10/21/1973UHC-42622-26•••-••-6800464-462-4267matthew.brown@gmail.com9216 Desert Sky BlvdChandler··AZ85285nullnull
PRVPRV-264432026-07-24T20:59:44ZJOSE—WEBER1983-03-07—UNKNOWN·(529) 639-9108jose.weber66@aol.com7632 Mesa DrTempeAZ85255-7528UNKNOWNSELECT-EPO
PRVPRV-288142026-08-29T01:54:25ZRoy—Young11/17/1986UHC-28229-59—2155262311—967 Oak StGilbertAZ85202nullN/A
PRVPRV-269332026-08-13T12:43:07ZEUGENE—HARPER1/4/1961NULLnull7052485267—null-NULL—NULL·CORE-HMO
PRVPRV-284102026-04-01T12:51:57ZGabriel—Riley1973-07-26UHC-30685-65-788.618.9483—7975 Washington StreetMIAMIFL33140—N/A
PRVPRV-266412026-07-13T01:34:22ZHAAMILTON—JOSEPH12/24/1978··—•••-••-6250nulljoseph.hamilton@aol.com6887 HILLCREST RDPlanoTX··75052—·NULL
PRVPRV-294542026-01-24T05:55:29ZCarl··Johnston10/17/2000UNKNOWNnull429-764-4549null8398 DESERT SKY BLVDMinneapolisMN55473—N/A
PRV PRV-243942026-07-08T00:23:13ZGREG—GARZA1941-12-23-nullUNKNOWNgregory.garza@icloud.com6168 Broadway··JacksonvilleFL32258—MEDICARE-ADV-B
PRVPRV-293352026-02-07T14:53:44ZLogan—·Flores1967-12-06UHC4186547null(611) 698-8988—7165 SUNSET BLVDSACRAMENTOCA·95876nullN/A
PRVPRV-217912026-06-25T17:18:23Zarthur—thompson1945-05-20UHC-52821-02null6882082359····2767 Forest AveCHANDLER··AZ··85233-CORE-HMO
PRVPRV-262982026-08-13T06:00:37Zalexis—hill02/12/1952N/A-614-390-4329NULL4089 River RoadTucsonAZ85788NULLUNKNOWN
PRVPRV-221542026-03-01T06:17:25ZGreen, Amber——1981-11-20UHC-91347-12NULL5451443NULL6965 BASELINE ROADCHARLOTTENC28269-6466NULLN/A
PRVPRV-264942026-03-06T12:36:37ZPhilip—Olson1949-06-10UHC-04127-27—+1 727 984 4001-3574 Lake View RoadChandlerAZ85210null··
PRVPRV-250932026-03-30T22:17:00ZAustin—Hayes1955-04-20UHC-88677-05—727.245.5654··—nullN/A····——
PRVPRV-26234 2026-06-21T04:07:27ZFrancas—Diaz19721119·UHC6072275—16888686172··FRANCES.DIAZ51@ICLOUD.COM5477 HILLCREST ROADHoustonTX··—··—
PRVPRV-241712026-04-11T19:58:05Z ChristianXKennedy1938-09-22UHC-25677-82—UNKNOWNCHRISTIAN.KENNEDY@ICLOUD.COM4685 River RoadCharlotteNCNULL-—
PRVPRV-205602026-10-04T06:49:58ZJohnston, Evelyn——12/09/40·····NULL566-380-3555evelyn.johnston@aol.com5408 Willow Court #165PlanoTX—N/A—
PRVPRV-259312026-09-30T13:48:16ZJeremy—Roberts1994-12-02UHC-19875-43N/A(531) 871-5301—9863 SAGE COURTColumbusOH43260—CORE-HMO
PRVPRV-293872026-03-19T08:47:45ZColeman, Jesse——1983-02-04—N/A3459386945——N/A-N/AUNKNOWN—
PRV PRV-241212026-01-15T10:09:57Z EvelynN··Anderson2001-02-11NULLnull362.616.2639null1535 OCEAN AVENUEFresnoca93714——
PRVPRV-257082026-08-12T03:13:12ZCARLOS—WALLACE·7/27/2003UHC-05396-18—4155518949N/A1063 Washington StreetAustinTXnull-null
PRVPRV-253932026-07-18T11:15:50Zdeborah···estrada1991-03-10UNKNOWNUNKNOWN(731) 852-7594N/A5054 Park PlSAN ANTONIOTX78210UNKNOWN-
PRVPRV-254482026-04-12T00:39:19ZGloria—Johnston1996-01-21··nullNULL·907-368-1399gloria.johnston56@outlook.com··6547 Union StreetMinneapolisMN55449··-OPTIONS-PPO
PRVPRV-204072026-04-10T17:18:29ZFrank—Nunez1989-05-05-N/A4359110null2828 VALLEY VIEW DR #229San AntonioTexas78230—UNKNOWN
PRVPRV-292572026-05-20T12:18:23ZRoger··Luna1960-10-11NULLnull(830) 805-3037—2436 Indian School RdMIAMIFlorida33148—-
PRVPRV-226082026-01-06T07:44:04ZBARBARA T—AUSTIN·7/2/1980UHC-09800-59—(234) 301-1820-··4185 Bayshore Drive··TampaFL—NULL·NULL
PRVPRV-228802026-10-15T20:12:43ZJESSICA—FOX1991-05-08UHC-31731-49null+1 493 229 1787JESSICA.FOX77@ICLOUD.COM2148 APACHE BLVDJacksonvilleFL32241-—
PRVPRV-265702026-09-30T21:11:32Z amber—hamilton19880926UHC-84817-87··364.445.7321amber.hamilton60@hotmail.com3555 FOREST AVENUEMesaAZ···85274NULLN/A
PRVPRV-233722026-02-14T14:51:16ZMATEO··AKING1951-02-19UHC-58436-86•••-••-16476123188216NULL4459 HILLCREST ROADTempeAZ85203N/Achoice-plus-ppo
PRVPRV-253092026-04-26T01:46:57ZValentina·MHayes19520428UHC8612056UNKNOWN2417407827··VALENTINA.HAYES@PROTON.ME6380 Washington StSCOTTSDALEAZ··85229NULL—
PRVPRV-294402026-05-28T14:15:36Z·AndreaY.Evans2002-01-12—NULL(976) 410-7105andrea.evans@aol.com6496 SPRING STREETSacramentoCA95847··-—
PRVPRV-269452026-09-30T20:54:52ZDanielleFLopez1962-01-20UHC-62752-94•••-••-5342+1 658 963 1962N/A497 Union StAtlantaGA30354—MEDICARE-ADV-B
PRV PRV-254592026-07-20T05:12:37ZJOSEPH—VARGASMar 8, 1967—-·17969068393joseph.vargas96@aol.com8941 BASELINE RDTEMPE·AZ-null—
PRVPRV-234942026-02-18T18:38:37ZEVELYN—GARDNERSep 28, 1992UHC-73149-18N/A(932) 635-0746-3445 MOUNTAIN VIEW DR Apt 14MESAAZ85250UNKNOWNUNKNOWN
9,596 rows, page 165 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:43:00.498Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty