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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-606352026-05-16T12:56:23ZLAURA—PATTERSON22-10-2006null•••-••-5988964.817.9466-nullUNKNOWNN/AnullnullNAVIGATE-HMO
TPATPA-527702026-03-17T22:12:39ZGrace—Gonzalez26-09-1947UNKNOWNN/AUNKNOWN-1884 Union StreetLas VegasNV89154—MEDICARE-ADV-B
TPATPA-603052026-08-25T02:25:17ZJULIIA—MEYER··1969-08-25UHC-95875-47null··9335474590UNKNOWN5564 Central Ave Apt 35MinneapolisMN55474GRP-7137·null
TPATPA-613872026-06-23T18:39:26ZDonald—Santiago08/02/2003——5392213150donald.santiago@icloud.com4272 Harbor BoulevardMiamiFLnullGRP-9504—
TPATPA-546082026-04-08T14:52:19ZTimothy—·Martin1985-02-15—•••-••-2894N/A—5826 Maple AveFresnoCAN/Anullnull
TPATPA-573222026-08-24T20:28:49ZChristianVBrooks1943-04-26UNKNOWN—447-975-2193christian.brooks39@gmail.com8683 Cedar LnTempeAZ85217—MEDICARE-ADV-A
TPATPA-501112026-05-24T04:07:58ZMADISON—BOYD1997-10-09-•••-••-3525——5761 Central AveNashvilleTN37230——
TPATPA-628592026-05-02T14:40:49ZBENJAMIN—THOMPSON·Jul 25, 1990null—··null6807 Canyon Rd Apt 39Denver··CO80218-6452NULLUNKNOWN··
TPATPA-541752026-02-05T21:21:02ZVictoria—Cruz··1988-11-01·nullUNKNOWN·nullN/A2669 Forest AvenueGLENDALE·AZ·85314N/A··UNKNOWN
TPATPA-550442026-07-13T22:15:01ZEthan—Vasquez19730611———-·9113 Washington StreetLas VegasNV89122GRP-9264—
TPATPA-613322026-04-17T11:32:02ZKennethY·Delgado1956-05-01···nullNULL834-296-8675N/A254 Palm DrDallasTX75268—medicare-adv-b··
TPATPA-506772026-07-17T13:25:36ZSam—Mejia07/13/2003—NULLN/A·N/A3601 Canyon Road #573SacramentoCA95847UNKNOWNnull
TPATPA-503502026-07-10T20:27:34ZJACK—GIBSON2005-03-14UHC-13560-01-—NULL595 Mountain View DrNashvilleTN37207-N/A
TPATPA-609302026-02-14T01:59:42ZMARCUS—GRIFFIN1955-02-22nullN/A482.587.9045NULL6506 SPRING STPHOENIXAZ85000GRP-6319—
TPATPA-642062026-06-28T14:36:33ZLinda—Reid09/26/41—•••-••-7951····—3931 Harbor BlvdSan DiegoCalifornia92104--
TPATPA-581522026-03-23T10:56:11ZJORDAN—GILBERT05/22/00N/Anull17614838387—1469 Indian School RoadColumbusOHnull-N/A
TPATPA-585302026-05-16T12:59:29ZRaymond, Ortega——1986-70-21---null6056 Valley View DriveChandlerAZ85263—null··
TPATPA-521962026-05-16T16:16:03ZWILLIE—COLE1985-09-21null•••-••-71775026621678NULLN/ANULL··—N/A——
TPATPA-549162026-07-05T11:26:20ZMADISONI.BOWMANAug 24, 1951UHC0262597UNKNOWN8338591309null6821 Camelback Rd··ScottsdaleAZ85251GRP-3670-
TPATPA-507982026-10-11T19:40:21ZYuki—Wheeler1983-06-06—•••-••-2105-NULL462 UNION STScottsdaleAZ85200GRP-2290—
TPATPA-573242026-10-10T20:41:54Z Madison—Lee1972-03-08NULL-NULLmadison.lee84@yahoo.com4679 Bayshore DriveChandlerAZNULL-—
TPATPA-615532026-04-07T19:44:12ZKelly—Carlson03-07-1980—null—NULLNULL—·-N/A—SELECT-EPO
TPATPA-617962026-09-25T07:57:54ZMILLS—SOPHIA1991-10-20N/A———1708 UNION STLos AngelesCalifornia90085-4129UNKNOWN··NULL
TPATPA-604862026-09-16T08:08:19ZMarcus—Coleman1946-04-27N/AUNKNOWN·619-519-1216—9477 HIGHLAND AVENUESacramentoCA95820NULLnull
TPATPA-552892026-03-17T10:49:27ZKaren—OBrien1951-02-28··NULL·N/AUNKNOWNNULL9506 HIGHLAND AVEATLANTAGAnull·GRP-6147N/A
TPATPA-52626 2026-07-20T08:33:57ZHiroshiC.Jekins1982-04-14null——null7748 Meadow LnSan AntonioTX78235GRP-5371CHOICE-PLUS-PPO
TPATPA-604092026-07-31T12:59:12ZHoffman, Elijah——1974-10-18-•••-••-98207838701525-1333 Spring StreetMinneapolismn55455GRP-0154—
TPATPA-517692026-06-05T00:24:45ZBlack—·JacquelineAug 17, 1989——(786) 854-9331·····3673 Apache BlvdTucson·AZ85721null—
TPATPA-629542026-09-29T04:03:55ZArthurD··—1975-09-02null•••-••-6824N/A—7230 Harbor BlvdNASHVILLETN37202GRP-5038null
TPATPA-590732026-10-16T20:59:46ZStephanie—Washiington·1945-01-03N/A•••-••-6279-·N/A1804 Mountain View DrDallasTexas75230—MEDICARE-ADV-A
TPATPA-55663 2026-01-30T17:49:23ZOrtega, Judy··——1963-10-09nullUNKNOWN9313430829judy.ortega91@outlook.comN/AUNKNOWNUNKNOWNUNKNOWN-UNKNOWN
TPATPA-515022026-03-30T07:39:57ZJustin—Fisher3/26/1939—UNKNOWN··NULL5138 Central AveMinneapolisMN55450GRP-0171NULL
TPATPA-547612026-07-02T05:47:14Zjacqueline····flores1939-12-16UHC0307053•••-••-82714285278069··NULL8553 Spring StTampaFL33668GRP-6920null
TPATPA-635932026-08-27T16:10:33ZBradley—Chen1983-05-06UHC-87280-46•••-••-7737nullBRADLEY.CHEN@AOL.COM—····N/AN/A—-
TPATPA-576382026-07-28T22:57:19ZBetty—Garcia1999-09-19—····(633) 733-4891UNKNOWN3070 Park PlSan Diego·CA——·null
TPATPA-52401 2026-01-10T14:51:36ZBETTY—REYNOLDS1952-11-20UNKNOWN•••-••-6005NULLnull1007 Desert Sky BlvdHoustonTX77090GRP-7091N/A
TPATPA-617382026-08-22T18:14:04ZNatalie—Woods09/01/1940UHC-23619-40null856-742-6616natalie.woods49@outlook.com8158 Oak StColumbusOH43281UNKNOWN··N/A
TPATPA-638832026-05-28T13:20:13ZPhilip—Perry19890423N/A•••-••-5746·N/A—6786 Spring StAustinTX78708N/AUNKNOWN
TPATPA-583062026-08-17T08:10:05ZBobby—·Berry1941-04-01UHC-07304-71-384.598.4149UNKNOWN6469 VALLEY VIEW DRIVE·GLENDALEAZ····—NULL
TPATPA-562932026-08-24T17:53:02ZGabriel—Hill··19960502N/A-9359605061—3390 MAIN STDallasTX75230·GRP-2523—
TPATPA-601002026-05-08T13:04:41ZSoto—Arthur3/10/1963-—null-··487 Maple AvenueAustintx·78796——
TPATPA-579462026-04-24T13:53:52ZchhristianIjenkins1987-10-28··UHC-59084-32—·UNKNOWN—4808 CEDAR LANE #403··NashvilleTN37270-—
TPATPA-529922026-01-16T18:22:03ZRoss, AngelaP.—19391223—•••-••-3743(542) 890-0259angela.ross@proton.me6160 Ridge RoadTUCSONAZ85722——
TPATPA-549702026-09-16T23:13:32ZLAURENYCOOK1991-09-16—-420-770-4301—5042 HIGHLAND AVESan AntonioTX78202—MEDICARE-ADV-B
TPATPA-624382026-01-28T21:15:24ZVirginia—Scott2005-05-02——947-239-3656—9105 Hillcrest RoadSEATTLEWA98194——
TPATPA-567502026-07-16T07:11:30ZAlbert····Carter··12/23/1973UHC-98644-66———9426 BASELINE ROAD·TempeAZ85201UNKNOWN·MEDICARE-ADV-A
TPATPA-564442026-01-09T20:19:00ZAdam—Williamson25-11-1963UHC-76610-04nullNULLadam.williamson7@aol.com4862 WASHINGTON STScottsdaleAZ85244GRP-0346NAVIGATE-HMO
TPATPA-590432026-01-30T05:12:34ZHudson, Gregory——8/14/1968—NULLUNKNOWNN/AUNKNOWN—null-GRP-4947··N/A
TPATPA-509952026-04-18T10:44:15ZJoyce·OCarlsonNov 25, 1979—•••-••-3392··joyce.carlson93@hotmail.com9366 INDIAN SCHOOL RDGLENDALEAZ··85300—·MEDICARE-ADV-B
TPATPA-597192026-05-14T00:36:51ZBruce—Little1939-07-09null•••-••-1740+1 779 505 4597UNKNOWN9067 Harbor BoulevardFresnoCA93797GRP-0526MEDICARE-ADV-A
14,474 rows, page 61 of 290PreviousNext

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.314Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty