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-606122026-01-05T13:25:41ZSOFIA—BARNES9168-02-28N/A—4165047234N/A2982 Highland Avenue Apt 36Eden PrairieMN55346GRP-2190NULL
TPATPA-597852026-06-07T23:53:27ZMorgan, Janet——1968-04-24UHC-17766-52•••-••-3601—janet.morgan@aol.com2596 Sunset Blvd··ChandlerAZ85228N/Anull
TPATPA-521312026-03-04T19:12:49ZAlanICastilloJun 12, 1954··UHC-85083-26null2447188600alan.castillo@icloud.com36 Hillcrest RdMesaaz85246N/A—
TPATPA-528052026-01-06T15:15:58ZWei—Mejia1960-05-08—•••-••-8235UNKNOWNUNKNOWN7400 APACHE BOULEVARD Apt 19Los Angelesca·90035-6759-·MEDICARE-ADV-B
TPATPA-616122026-03-09T08:55:05ZRonald—Li1962-02-02N/A-657-773-6336RONALD.LI41@HOTMAIL.COM7230 Lake View RdHoustonTX77031UNKNOWNSELECT-EPO
TPATPA-577632026-05-04T10:18:21ZHNRY—GRAHAM1969-04-04UHC-16030-05NULL-—46 GRAND AVEPlano··TX··75023GRP-0300NULL
TPATPA-540332026-10-13T23:48:24Z·Lori—Ellis2005-08-15——(888) 763-3981LORI.ELLIS2@YAHOO.COM5821 Union StOrlandoFlorida32879nullnull
TPATPA-613922026-08-17T20:27:48ZluciaV.··weaver·20000824—•••-••-4164—-4920 Lake View RoadColumbusOH43296—UNKNOWN
TPATPA-622612026-01-28T04:08:10ZMARK—LOPEZ1954-09-19N/A——null··810 MESA DRSACRAMENTOCA———
TPATPA-518292026-06-25T08:43:14ZMARY···WARREN1985-03-25··--(482) 448-6459MARY.WARREN55@AOL.COM··272 CHURCH STPHOENIXAZ85073—null
TPATPA-618322026-09-10T15:38:26ZLinda—Marquez1953-09-16UNKNOWN•••-••-4837——7510 Grand AveDenverCO80299GRP-1836—
TPATPA-622942026-05-05T12:48:45ZCarolGBaker10/28/56UNKNOWN•••-••-0885—N/A3917 Maple AveHoustonTX77006-7344-OPTIONS-PPO
TPATPA-563222026-10-08T20:46:29ZHeather··—Nelson11/11/50NULL·N/A3584197871null7856 JEFFERSON AVENUEHoustonTX77033NULLUNKNOWN
TPATPA-518622026-05-24T18:56:14ZJoyce····Scott1985-06-16null-—null4524 Mesa DrMinneapolisMN55468-9623—CHOICE-PLUS-PPO
TPATPA-607792026-03-20T20:53:01ZAmyYSimpson05-12-1940UNKNOWN•••-••-5915587-685-3456NULL7977 BAYSHORE DRIVEJacksonvilleFL32260GRP-7858UNKNOWN
TPATPA-509472026-03-10T15:12:09Z·Heather·U.Valdez1966-03-06UHC9304786•••-••-4980——2610 MAIN STREETTucsonAZ85756NULLSELECT-EPO
TPATPA-531472026-05-10T22:34:27ZKEREN—·HOWARD1980-09-03—•••-••-7871—-9621 Broadway·San AntonioTX78225—CORE-HMO
TPATPA-607382026-03-17T07:17:16ZCooper, JordanD—2/7/1948····UNKNOWNNULL—1981 MOUNTAIN VIEW DRIVEColumbusOH43235UNKNOWNCHOICE-PLUS-PPO
TPATPA-611092026-05-16T11:05:14ZJean—Gonzales1941-09-26UHC-86751-24—+1 358 475 7496—6416 CANYON RDSan AntonioTX··78277GRP-1815-
TPATPA-633772026-01-31T21:54:27ZDANIELLE—ARMSTRONG1950-05-04N/A•••-••-9350NULLnull··821 Central AveScottsdaleAZ85227NULL—
TPATPA-515882026-05-10T13:13:41ZDonna—·Myers1946-06-08UHC-96895-18-949.255.5228—6536 LAKE VIEW ROADCharlotteNC28209GRP-6659—
TPATPA-590122026-10-11T08:40:35ZWALTER—PATTERSON0525-91-86—•••-••-1361UNKNOWNwalter.patterson65@aol.com3166 MOUNTAIN VIEW DRLAS VEGASNV——MEDICARE-ADV-A
TPATPA-620972026-01-21T22:01:11ZDonna—Reynolds·22-10-1941NULL··—UNKNOWNDONNA.REYNOLDS@AOL.COM6169 Elm StreetChandlerAZN/Anull·OPTIONS-PPO
TPATPA-556942026-01-06T12:46:32ZDiaz, Rachel——1999-12-10—-null·UNKNOWN9301 HIGHLAND AVENUENashvilletn37232——
TPATPA-566162026-04-08T06:54:07Z ·JUDITH—OWENS09/17/69—NULLnull·judith.owens@outlook.com8433 Lincoln WayMiamiFL33151GRP-6669OPTIONS-PPO
TPATPA-512772026-08-13T03:57:09ZRonald··—2003-05-26UHC-91719-11—NULL—373 Oak StEden PrairieMN—GRP-5092MEDICARE-ADV-A
TPATPA-626162026-08-01T06:11:02ZHenryFHunter09/13/1946——·(973) 749-7858null1756 Indian School RoadLas VegasNV89103N/A—
TPATPA-580752026-02-17T14:58:30ZBrandon—Jenkins25-09-1992-——UNKNOWN617 INDIAN SCHOOL ROADTucsonAZ85753—NAVIGATE-HMO
TPATPA-629592026-02-13T14:50:05ZBetty—·Wright·1996-05-07UNKNOWN—-—6345 DESERT SKY BOULEVARDMiamiFL33102——
TPATPA-537702026-06-09T05:41:54ZJanetV.Carroll1/11/1980UNKNOWN•••-••-6754····-·4277 Elm StTucsonAZ·UNKNOWN——
TPATPA-643642026-04-15T21:44:02ZMariana—Henderson02-11-1986—null··-—8672 HIGHLAND AVENUE··OrlandoFL32884GRP-0785-
TPATPA-521432026-01-08T17:58:51ZGERRALD—COX1971-10-05UNKNOWN•••-••-4262—NULL5111 Canyon Rd·PlanoTX75044GRP-6143MEDICARE-ADV-B
TPATPA-500812026-08-30T23:46:36ZAlbeertZ.Montgomery02/03/1971-NULL····—7534 Cedar LaneGLENDALEAZ85384—null
TPATPA-540012026-03-06T22:08:29ZBRYAN··—ORTIZJul 6, 1965—-··null—3376 Market StreetChandlerArizona85230··NULLMEDICARE-ADV-B
TPATPA-618672026-05-30T22:59:27ZVALENTINA—HENY1977-05-07null-N/AN/A7281 Hillcrest RdScottsdaleAZ85255N/A—
TPATPA-617922026-01-12T17:15:59ZRichardson, Kelly—····19570309—nullNULL—--UNKNOWN-NULLN/A
TPATPA-530512026-02-15T21:28:03ZNICOLE—DANIELS2008-04-24——····—null——UNKNOWNUNKNOWNCORE-HMO
TPATPA-527922026-07-24T17:16:47Zpaul—cruuzOct 14, 1994-N/A734-727-2116-9258 Pine Dr··DallasTX75235N/A-
TPATPA-523302026-03-20T04:07:06ZCHRISTINE··—HICKSOct 24, 1996nullnull13089776609UNKNOWN4361 Canyon RoadScottsdaleAZ85277-3476-UNKNOWN
TPATPA-572572026-08-16T06:25:59ZYuki—Ward23-12-1948UHC-49692-58NULL377.710.8627—4400 Central AveMiamiFL33132N/A—
TPATPA-579102026-02-19T22:13:02ZSarah—WilsonJul 19, 1976UHC-82292-39•••-••-1051—N/A5348 Park PlaceMesaAZ85292—NULL
TPATPA-53338 2026-05-05T17:21:22ZKEITHOHUNTER··1991-09-08UNKNOWN··———·8517 Mountain View DrTucson·az85731····N/A
TPATPA-637542026-05-27T07:58:32Z·PHILIP—DAY1968-03-15NULL··-+1 728 881 4564UNKNOWN6956 WASHINGTON STMiamiFL33119··—NAVIGATE-HMO
TPATPA-566592026-05-22T15:19:13Z·Kyle—PayneAug 12, 1959—•••-••-7274N/AUNKNOWN6422 Forest Avenue··GILBERTAZnullGRP-4875-
TPATPA-571452026-06-30T18:26:45ZCarlos—Kennedy1976-02-05—•••-••-8923····carlos.kennedy@hotmail.com4777 Palm Dr #721OrlandoFL32867-0117UNKNOWN—
TPATPA-625752026-09-04T06:58:44ZMEGAN—EDWARDS2006-06-04NULL—NULL—nullN/A—N/AGRP-2440UNKNOWN
TPATPA-543132026-07-05T06:03:50ZBruce—Alvarez1981-05-04UNKNOWNUNKNOWNnull··8112 MAIN STREET··DallasTX75291-—
TPATPA-562732026-08-02T13:59:26ZWilliam—Shaw1996-04-14·N/A—NULLwilliam.shaw12@proton.me6955 Park PlLos AngelesCalifornia90062NULL—
TPATPA-535642026-08-10T09:24:29ZJUDITH—PETERS1972-01-24null——-1591 Canyon RoadDallasTX75219··null
TPATPA-609362026-07-05T23:09:40ZAMY—MENNDOZA1961-09-18UNKNOWN•••-••-422617684464749amy.mendoza@proton.meNULL—nullUNKNOWNGRP-9806—
14,474 rows, page 254 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:43:00.512Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty