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-558162026-07-21T20:24:09ZKathryn—Braley·1997-02-02null•••-••-4002(578) 583-0736—·1751 OAK STREETJacksonvilleFL32239GRP-2270MEDICARE-ADV-A
TPATPA-532342026-07-20T12:15:07ZEric—Palmer1964-11-24-—NULL-7424 PALM DR Apt 22Los AngelesCA90025N/A—
TPATPA-605672026-02-19T01:38:40ZDeborah—Ball19390425null-7785080638—8886 Spring StAustinTX78735-6528··NAVIGATE-HMO
TPATPA-546442026-05-03T10:49:54Zkimberly—burns08-05-1964UHC-66985-61····(240) 742-4572—577 Harbor BlvdMiamiFL33142GRP-6040UNKNOWN
TPATPA-617172026-06-22T05:29:04ZJoyce—Soto1946-12-01—-13538403056NULL——N/AN/AGRP-9952····
TPATPA-605372026-05-08T15:05:48Z·GERALD—FOSTER1993-02-26null•••-••-7887(534) 920-8325—8689 Jefferson AvenueTucsonArizona85762GRP-1453CORE-HMO
TPATPA-538512026-06-20T11:50:36ZBRADLEY—PIERCE1994-09-12nullN/A--2723 DESERT SKY BLVDGILBERT··AZ85266nullOPTIONS-PPO
TPATPA-547512026-07-09T12:40:22ZDYLAN—LARSONNULLUNKNOWN•••-••-8130UNKNOWNdylan.larson@outlook.comUNKNOWN··nullNULLNULLnullnull
TPATPA-565832026-09-26T00:19:03ZjosePpadilla··1955-01-14null··(578) 533-1507JOSE.PADILLA55@PROTON.ME—····-nullN/AMEDICARE-ADV-A
TPATPA-518672026-08-05T23:51:59ZAndrea—MedinaAug 16, 1987N/Anull612-224-1128null4090 CHURCH STTucsonAZ85757UNKNOWNCORE-HMO
TPATPA-643992026-05-21T20:05:56ZCrawford, AyshaI.—1997-04-11UHC-96544-64•••-••-0028NULLN/A5164 Meadow LnFRESNOCA93771GRP-4112null
TPA TPA-602982026-02-02T04:49:20ZKathy—Edwards1955-08-04null··964-825-9461null6159 Lake View Rd Apt 14NashvilleTN37203UNKNOWNNULL
TPATPA-571752026-06-29T02:01:34Zyuki—bryant1999-06-25null•••-••-0598——·-——null·N/A····
TPATPA-551622026-08-19T12:26:09Z DANIELLEKROMERO04-12-1957——601-766-9330———N/A—GRP-5288N/A
TPATPA-614152026-06-07T08:50:07ZNATALIE—REID10/19/1987-•••-••-6341UNKNOWNNULL·2154 MEADOW LANEMinneapolisMN55455·GRP-2145null
TPATPA-584982026-09-04T09:46:28ZJoseph—·Moore1990-05-26UHC-14260-60—N/Ajoseph.moore16@gmail.com5602 Mesa DriveTucsonAZ85740····—
TPATPA-623862026-01-16T19:28:34Z·KAREN—CLARK1956-01-28UHC-04799-83•••-••-9192——7273 Mesa Drive·ORLANDOFL32814—N/A
TPATPA-586302026-03-24T22:07:40Z Lisa—Diaz2007-11-27null—N/AUNKNOWN8963 MAPLE AVE··HoustonTX77092—MEDICARE-ADV-B
TPATPA-601612026-03-01T06:08:39ZCole, Amanda——10/28/2005UHC-20244-98NULL—-—NULL—-GRP-6476UNKNOWN
TPATPA-513622026-08-08T20:09:09ZRyan—Tran19900627nullnull—UNKNOWN5180 APACHE BLVDFRESNOCA93796N/A—
TPATPA-590352026-08-11T12:07:24ZFRANCESNGUERRERO1961-08-23N/A··null513-394-3035null3108 Pine Drive·San DiegoCA92123UNKNOWNMEDICARE-ADV-B
TPATPA-629622026-01-04T05:00:09ZVALENTINA—STEVENS1943-01-26-——UNKNOWN5643 Meadow LaneEden PrairieMN55358··—
TPATPA-531222026-05-05T23:20:09Zalbert—castillo1989-12-26—·UNKNOWN557-566-3500albert.castillo31@yahoo.com205 Church StreetSan AntonioTX78228-N/A
TPATPA-565142026-08-06T15:05:33Z Julia—Weber1984-11-10N/A•••-••-6795NULLjulia.weber@icloud.com7153 Lake View RdLas VegasNV89124—N/A
TPATPA-505972026-08-24T09:24:32ZMaria—BradleyNov 21, 1976—null—maria.bradley@yahoo.com7106 RIDGE ROADAustinTX78770··-MEDICARE-ADV-A
TPATPA-547232026-05-25T02:51:09ZGuzman, Rachel——1992-09-27—UNKNOWN(865) 275-2749—2817 SUNSET BLVD #161Houstontx77035—null
TPATPA-629962026-05-11T20:49:45ZALICE—·LYNCH07/03/89UHC-35217-75—(894) 251-2439alice.lynch@gmail.com6986 Baseline RdMesaAZ85276—null
TPATPA-593102026-03-15T11:06:32Z·Alexander—·LarsonNov 23, 2005NULL•••-••-83868012903415··8136 ELM STSEATTLEWAnullUNKNOWN-
TPATPA-500162026-09-12T11:27:22ZLee, Diane——1970-01-11·-•••-••-4463——UNKNOWN···NULLUNKNOWN·NULL—
TPATPA-617572026-05-18T00:35:31ZElizabeth—Rodriguez1963-12-06—-UNKNOWN-7374 Sage Ct···TampaFL33602GRP-9105—
TPATPA-585762026-03-20T23:39:45ZSHARON—SANCHEZ03/09/96UNKNOWN—NULL-6949 CANYON RD #643·TempeAZ··85271N/ANULL
TPATPA-530542026-09-03T13:54:47ZRios, Dorothy—····1993-07-17UHC8207307—NULLNULL963 Canyon RdMESAAZ··85236——
TPATPA-514122026-03-24T14:24:05ZKeithEJimenez1948-01-27nullnullN/A—49 CANYON ROADSan AntonioTX78225N/A-
TPATPA-510522026-03-11T17:04:14Zjuith—lopez05/25/78null-945-574-3892N/A2945 GRAND AVENUEEden PrairieMN55389GRP-4120—
TPATPA-501152026-02-07T06:12:01ZvirginiaBmccoy1966-01-24—N/A-null6472 Sage CourtChandleraz85239-9441-MEDICARE-ADV-A
TPATPA-585872026-01-16T08:17:32ZRandy—Long1990-01-25UNKNOWN——-3698 RIVER RDSan DiegoCAnullnullSELECT-EPO··
TPATPA-516572026-06-11T02:59:35ZAlvarez, Jesse——Apr 7, 1939NULL—N/AUNKNOWN8496 Harbor BlvdScottsdaleAZ85271GRP-2368—
TPATPA-524862026-01-08T21:48:07ZBrandon—Snyder1968-12-04·UNKNOWN—+1 581 970 1183NULL—UNKNOWN—nullUNKNOWNNAVIGATE-HMO
TPATPA-616752026-06-25T16:33:11ZHIROSHI··GREENE1997-09-26nullUNKNOWNUNKNOWN—7106 MARKET STSACRAMENTOCA95896N/A—
TPATPA-590822026-09-10T12:02:01ZLAUREN—GUTIERREZ1942-10-10NULL—(440) 908-3769N/A5474 Indian School RoadCHANDLERArizona85220··UNKNOWN-
TPATPA-633832026-02-28T09:19:33ZETHAN··P.···WEBER1980-12-18·-—·---·NULL—UNKNOWN——
TPATPA-550322026-06-28T06:21:50ZAngela—King1988-12-23NULL-UNKNOWN··—6442 Main StreetMesaAZ85269GRP-1700MEDICARE-ADV-B
TPATPA-550622026-06-28T02:49:18ZJoe—Adms05/04/2008—•••-••-4903NULLJOE.ADAMS39@GMAIL.COM··2370 Canyon RdAtlantaGA··30326GRP-4495CHOICE-PLUS-PPO
TPATPA-509892026-02-22T01:26:56Z Madison—Gibson1973-11-10UHC-74643-76UNKNOWN····madison.gibson10@gmail.com——NULL—N/A—
TPATPA-624152026-04-11T05:40:00ZFox, DeborahY.—·1982-06-04—•••-••-4983UNKNOWN—3808 Highland Avenue Apt 9Houstontx77059NULL-
TPATPA-569372026-09-24T16:10:01ZPamlea—Lawrence1964-11-16—nullUNKNOWNUNKNOWN··NULLNULL-NULL·UNKNOWN
TPATPA-579612026-08-03T13:30:43ZCole, Bruce——03/11/1952NULL•••-••-4559339-217-8100—7356 Harbor BoulevardLos AngelesCA90000-—
TPATPA-590282026-01-18T06:11:17ZJACK—HILL·1984-01-05UNKNOWN·UNKNOWN—john.hill22@outlook.com4035 Ocean AvenueDenver··CO80238GRP-9454null
TPATPA-587182026-09-12T09:17:17ZPriya—Foster1959-09-06UNKNOWN•••-••-4294UNKNOWN—5159 Highland Ave Apt 38Fresnoca93792N/A-
TPATPA-577162026-07-03T22:58:22Z·kathleen—morgan1994-04-23·UHC-44662-69•••-••-5785N/A—5250 Spring StFRESNOCalifornia93754-8551GRP-2637medicare-adv-a
14,474 rows, page 124 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:46.073Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty