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
TPA TPA-592632026-10-18T10:35:40ZJuan—Wells···1963-12-02—•••-••-479417514299935NULL943 Lincoln WayDALLASTX75235NULL—
TPA TPA-590162026-09-28T22:37:36ZGeorge, Nicole——2006-06-12NULLNULLNULL-5730 Sunset Blvd #529AustinTX78750····NULL
TPATPA-603252026-04-29T00:12:19ZAmberU.Willis1990-08-08——UNKNOWNamber.willis70@outlook.com9561 Mountain View DriveSacramentoCA··95848NULL—
TPA TPA-627702026-08-28T07:30:57ZKaren—MoralesMay 21, 1943NULLUNKNOWN—N/A6903 Willow CourtLos AngelesCAN/A—null
TPATPA-568532026-10-07T09:34:02ZHannah—Dunn1973-09-11—•••-••-4508null-9272 Mountain View DriveDallasTX75217-0089GRP-5028—
TPATPA-608362026-01-08T04:18:52ZKimberly—Austin1982-01-28—UNKNOWN·-kimberly.austin14@aol.com1515 Maple AveNASHVILLETN37291null····
TPATPA-567212026-08-07T11:19:13Z Kathryn—Contreras04/19/1952—null—N/A6059 Ridge RoadColumbusOH43252—null
TPATPA-571682026-07-22T18:14:38ZaliceIsanders2002-07-10-NULL—alice.sanders@outlook.com1418 Forest AvenuePlanoTX—··null
TPATPA-569762026-05-24T22:50:46ZJohn··—Ramos03/16/1941UNKNOWN—nullN/A·8029 PARK PL #157San AntonioTXN/A—NULL··
TPATPA-575532026-09-14T15:31:25ZtheresaR—5/11/1994—N/AN/ATHERESA.CASTILLO@ICLOUD.COM9544 ELM STREETTEMPEAZ85247UNKNOWN—
TPATPA-632852026-02-09T12:47:37ZValenitna—·Owens1974-11-25--940-320-6101valentina.owens38@proton.me8420 JEFFERSON AVENUENASHVILLETN37232NULLCORE-HMO
TPATPA-587292026-10-08T22:44:16ZJUSTINYELLIOTT08/16/2007—•••-••-0905——797 MOUNTAIN VIEW DRIVEPhoenixAZ85043GRP-3248null
TPATPA-591182026-04-08T21:03:47ZChristina—Nicols1961-07-23null•••-••-23376816737010—749 Forest Ave·FresnoCA93749-··
TPATPA-603932026-02-11T19:44:37Zsteve—hunt8/22/1959-NULLUNKNOWNUNKNOWN2211 Willow CtCharlotteNC28208N/A—
TPATPA-617152026-02-04T01:17:39ZBRYAN—PENAAug 26, 1961·UHC-12094-45—(485) 980-1555—6885 Market StHoustonTX·77041-0399——
TPATPA-637192026-06-27T17:54:52ZWang—Sophia1950-01-28—-·3519167-6636 Spring StreetJacksonvilleFL32277——
TPATPA-502902026-04-25T13:42:56ZLogan—Ramirez1944-05-18UHC-91651-40··N/A-·666 Hillcrest RdLos AngelesCA90093GRP-4948—
TPATPA-587882026-04-29T11:05:20ZRuthFStone1994-03-21——nullruth.stone@proton.me8778 Sunset BlvdNashvilleTN37266—N/A
TPATPA-548812026-03-31T11:18:16ZCynthia—Chapman19918222UHC-71505-92—UNKNOWN-5035 Camelback RoadGlendaleAZ85341GRP-6382NULL
TPATPA-518762026-06-15T23:42:53ZScott—Garrett1953-01-20NULL—+1 230 487 1097UNKNOWN9209 DESERT SKY BOULEVARDLas VegasNV89191—SELECT-EPO
TPATPA-630392026-06-27T03:17:32Z Gloria—·Lopez12/10/1942—•••-••-7883663-411-3864UNKNOWN1893 CENTRAL AVENUETEMPEAZ85223GRP-9543—
TPA TPA-616352026-07-06T22:28:20ZWeaver, Omar··—·20020228—•••-••-5482(703) 979-9708null4595 Sage CourtFresnoCA93782N/ANULL
TPATPA-581172026-08-23T05:50:13Z·DiegoT.Snyder1949-08-27N/A-NULLUNKNOWN8410 Valley View DriveColumbusOHN/A——
TPA TPA-642962026-08-17T04:55:24ZJustin—·Crawford1961-04-08—•••-••-7576486-550-4187-5349 Washington StreetScottsdaleAZ85297-CORE-HMO
TPATPA-503062026-10-04T19:38:24Zmarai—bell04/04/08UNKNOWN•••-••-3765-null7470 SPRING STREETDallasTX75232GRP-0366NULL
TPATPA-578802026-06-24T19:36:41ZRoger—Black1992-07-21—•••-••-6399—ROGER.BLACK4@PROTON.ME929 Harbor BlvdDallas··TX75217··GRP-7634UNKNOWN
TPATPA-505902026-05-26T14:24:58ZDeborah—Stephens1998-04-13N/Anull--2776 Mesa DriveChandlerAZ85203NULLCORE-HMO
TPATPA-58288 2026-04-15T05:34:31ZKATHRYN—MILLS2008-02-24N/A—-null··2641 Ocean Avenue··MiamiFL33111GRP-9577UNKNOWN
TPATPA-549432026-02-05T10:54:47ZEvelyn—Castro12-08-1965··—null-null1347 Ocean AveColumbusOH43286UNKNOWNNULL
TPATPA-639352026-04-22T01:48:18ZMARK··TURNER1980-05-22UHC-78211-24NULL—N/A8779 Church StEden Prairiemn55319-—
TPATPA-505952026-10-17T00:14:50Z CYNTHIA—HENSEN·22-01-1971—null··null-3524 Ridge Rd #711JACKSONVILLEFlorida32222—null··
TPATPA-506702026-05-26T13:35:06Zwayne—mitchell1969-03-13null•••-••-9677N/AUNKNOWN6633 CENTRAL AVEFRESNOCA93789null—
TPATPA-581742026-06-15T23:10:59ZKimberly—Pierce·1978-12-17UNKNOWN-(787) 514-1647N/A·8849 Valley View Dr·ColumbusOH43253N/AN/A··
TPATPA-564552026-02-10T16:27:53ZDeniseBSanchez19941102——376-938-8256denise.sanchez@yahoo.com8771 Market StSCOTTSDALEAZ85293NULL-
TPATPA-620302026-06-24T15:10:25ZPatrick—Murray6/13/1980—····null-3503 Hillcrest RdTEMPEAZ85211UNKNOWN-
TPATPA-559292026-07-29T23:36:17ZNoah···Moreno1950-01-19NULL····623-774-6058NULL2347 Bayshore DrCharlottenc28283-8438GRP-1802-
TPATPA-605622026-05-30T04:09:16Z Margaret—Roberts1939-12-16—•••-••-4875N/Anull5221 Cedar LaneHOUSTONTX77017——
TPATPA-501752026-08-04T22:26:12ZMADISON—WRIGHT··1971-11-10NULL•••-••-3741--1261 Harbor BoulevardCHANDLERAZ85264GRP-6275SELECT-EPO
TPATPA-538762026-09-23T05:16:59ZALAN—COLE1977-06-25NULL•••-••-3138(912) 483-9337··ALAN.COLE89@GMAIL.COM4335 Ocean AvenueMesaaz·85295·NULLCORE-HMO
TPATPA-517722026-03-02T05:33:25ZJeremy—Richards··1990-07-11NULLUNKNOWNN/A·UNKNOWN·9885 UNION STAtlantaGA30394-4458—null
TPATPA-537992026-09-15T13:06:11ZChen, Victoria—··1947-02-23UNKNOWN—·+1 692 425 9533N/A925 RIDGE ROADOrlandoFL32808··null
TPATPA-556522026-02-18T17:45:17ZFrancesZLarson09/28/40-UNKNOWN··463-940-4800—2245 Highland AveTempeArizona85291UNKNOWNN/A
TPA TPA-56638 2026-01-03T20:39:42ZGABRIEL—HOWELL1946-12-15N/Anull··8199638881GABRIEL.HOWELL7@ICLOUD.COMnull—NULL—GRP-7534CHOICE-PLUS-PPO
TPATPA-551242026-02-13T06:09:17ZAmanda—Allen1954-10-20null--—4736 Lake View RoadSan DiegoCA92196NULLNAVIGATE-HMO··
TPATPA-526722026-06-27T01:51:13ZRoberts, Janice——1981-08-28UNKNOWN····900-579-3777JANICE.ROBERTS@YAHOO.COM1097 MOUNTAIN VIEW DR··EDEN PRAIRIEMNN/A····MEDICARE-ADV-B
TPATPA-505682026-07-09T04:11:44ZAhmed—Schultz09/27/05··UHC-98286-73N/Anull-6157 HILLCREST ROADLas VegasNV89173——
TPATPA-582632026-07-18T06:24:42ZMartha—Warren11/19/54····N/A—N/A3383 Lake View RoadScottsdaleAZ85239UNKNOWNMEDICARE-ADV-B
TPATPA-530532026-07-13T10:13:20ZBrian—Contreras2005-20-15—NULL7293588512—UNKNOWN—UNKNOWN——NULL
TPATPA-601862026-09-10T17:31:02Zkelly—lucas1947-12-15UHC-15635-05-nullkelly.lucas87@outlook.com——NULL—·-UNKNOWN
TPATPA-581882026-04-06T20:15:43ZLUISUADAMS06/10/83····UNKNOWN(724) 233-7381N/A6541 PALM DRPhoenixAZ85078-6309NULLNAVIGATE-HMO
14,474 rows, page 97 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:43.442Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty