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-563072026-02-26T21:24:53ZVIRGINIAGDELGADO··1938-11-13-N/A·(401) 687-9568—3315 River RdGLENDALEAZ85367GRP-1495·N/A
TPATPA-539192026-01-10T11:41:59ZSAMUEL—JYMENEZ1953-04-02UHC-67719-04······N/AN/ANULL——UNKNOWNGRP-4066-
TPATPA-538112026-07-19T06:31:07Zlori—butler1981-02-20N/A··•••-••-2487430-665-5702null405 Indian School Road #185·NashvilleTN·37270N/ASELECT-EPO
TPATPA-616312026-06-17T02:55:52ZBRITTANY—WALSH19840509UHC-72666-02UNKNOWN—UNKNOWN6263 Forest AvenueDenverColorado80220UNKNOWNNAVIGATE-HMO
TPATPA-520792026-01-06T08:03:47ZKnight, Katherine——03/26/2001—-NULLnull—·NULL——NULLUNKNOWN
TPATPA-594612026-10-06T15:38:37ZAliceD··Silva2/20/1958UHC-48217-20•••-••-9797——3033 Valley View Dr··TampaFL33625NULLMEDICARE-ADV-A
TPATPA-527722026-02-06T19:53:16Z Jeffrey—·Hrerera1989-08-07UHC-15185-87N/A2334420455—6053 ELM STREETCharlotteNC28276NULL—
TPATPA-540722026-01-18T09:05:21ZARJUN—SULLIVAN19671102——17098308941N/A5726 BroadwayJACKSONVILLEFL32202-2408null····
TPATPA-542122026-02-02T06:14:44ZGRAG—POWELL08/02/94UHC-53306-54UNKNOWN480-406-7880null3034 FOREST AVETucsonAZ85795—MEDICARE-ADV-A
TPATPA-500002026-01-27T16:24:11ZBilly—Woods19661216-NULLNULL—9218 PALM DRIVELos AngelesCA·90065GRP-1707MEDICARE-ADV-B
TPATPA-632062026-02-25T16:22:03ZBarbara—Peters··10-04-1951UNKNOWNN/A+1 622 392 8410NULL4436 MAPLE AVETampaFL33650nullNULL
TPATPA-580002026-09-08T15:38:37ZArthur··—Oliver1995-04-22N/Anull——8600 Union StreetHoustonTX··77051GRP-7769·UNKNOWN
TPATPA-537432026-07-29T11:27:56ZBobby—·Dominguez2005-12-21NULLN/Anull—1263 Canyon RoadDallasTX75265N/AOPTIONS-PPO
TPATPA-623682026-10-02T09:27:22ZDebra····Franklin1981-09-06—NULLnull—1835 Baseline RdJacksonvilleFL32238NULLNULL
TPATPA-575762026-04-24T14:26:55ZJimenez, William——19-03-1982NULL—UNKNOWNnull210 VALLEY VIEW DRLos AngelesCA90041GRP-0634·UNKNOWN
TPATPA-510872026-01-14T13:33:56ZBryan··—Carpenter01/10/53——nullbryan.carpenter@yahoo.com3793 Harbor Boulevard·Los AngelesCA90075-1063N/AMEDICARE-ADV-B
TPATPA-576862026-09-25T16:16:40ZLOGAN—HANSON1963-03-14—•••-••-72322544081290—UNKNOWNN/A-UNKNOWN—SELECT-EPO
TPATPA-519792026-01-20T11:54:53ZAhmed—Hill1939-10-14N/A—·-··6465 SPRING STTempeAZ85249—null··
TPATPA-530942026-06-07T13:22:10ZLewis, Santiago··—11/2/1973-N/A—·-1083 SAGE COURTFresnoCA93776-7422UNKNOWNOPTIONS-PPO
TPATPA-611402026-03-01T11:57:32ZCatherine—Day1943-07-04UNKNOWN--··5538 Grand AvenuePLANOTexasnullGRP-7016—
TPATPA-616942026-02-10T07:27:20ZMICHAEL—SCHMIDT2004-10-28····—··—7258 Harbor BoulevardDALLASTX75268—·NAVIGATE-HMO
TPATPA-636832026-07-25T05:37:48Zdaniel—oliver1591-10-17UHC-84619-89N/A(588) 586-7122N/A—··—NULL—NULL
TPATPA-508432026-04-26T17:53:34Z CHRISTINA—NGUYEN04/20/03null•••-••-0719——9150 HARBOR BLVDSan DiegoCA92182··——
TPATPA-548072026-08-26T05:55:59ZSims, Melissa—····19490802-N/Anull··——-——NULLnull
TPATPA-638972026-03-15T16:51:24Z HEATHER····KIM1/4/2006—•••-••-9125—N/A4203 Harbor Boulevard #558TempeAZ85255GRP-3229null
TPATPA-628302026-08-29T09:03:22ZSharon—Ruiz2/26/1996nullUNKNOWN6668856260—2788 WASHINGTON STTampaFlorida33609-9986UNKNOWN-
TPATPA-559462026-03-25T14:31:10ZCynthia—Martin1956-04-18—UNKNOWNnullnull1627 Cedar LaneGilbertAZ85298NULLN/A
TPA TPA-519212026-06-08T07:13:36ZJENSEN—GREGORY·2005-08-16———-··3096 Pine DrScottsdaleazUNKNOWNNULLN/A
TPATPA-634552026-09-18T19:15:21ZEvelyn—Richardson1/7/1945··—·N/A—5570 Maple AveOrlandoFL32877GRP-5305NULL
TPATPA-621832026-02-16T03:44:04ZDeborah—Nichols·1990-01-21UNKNOWN··UNKNOWN2984751728UNKNOWN7500 BroadwayTampaFlorida33601GRP-7176MEDICARE-ADV-B··
TPATPA-544182026-01-13T23:22:02ZAISHA—CHENOct 3, 1944UHC-11222-74—UNKNOWNnull8555 Main StPlanoTX75076N/A—
TPA TPA-53810 2026-08-07T20:01:39ZSHIRLEY—HUNTSep 1, 1958—nullnullnull1390 Indian School Road #884FresnoCANULLGRP-3638—
TPATPA-581052026-05-24T13:08:22ZJoshua—Contreras17-04-1959N/A•••-••-40809428256NULL8975 Ocean Ave·DenverCO80271NULLSELECT-EPO
TPATPA-532902026-02-20T20:01:07ZMichelle····Anderson1945-08-13UNKNOWN•••-••-6094—-··3733 Ocean AvenueLos AngelesCA90028GRP-2807-
TPATPA-529702026-01-21T13:08:00ZKIMBERLY—SALAZAR19720419NULL-+1 656 718 8969··KIMBERLY.SALAZAR39@OUTLOOK.COMnullN/A—NULLN/Anull
TPATPA-531992026-09-14T19:42:38ZSctot—Simmons19760109—·UNKNOWN876-893-2158··NULL2254 LAKE VIEW RDMesaAZ--NULL
TPATPA-505672026-07-09T04:11:44ZAhmed—Schultz09/27/05··UHC-98286-73N/Anull-6157 HILLCREST ROADLas VegasNV89173——
TPATPA-534742026-09-16T02:19:27ZJENNIFER—MOORE1994-12-06null—416-390-1772—3483 Church StreetSan Diego·California92152-UNKNOWN
TPATPA-524402026-02-21T00:39:56Zlawrennce—warren··1961-05-03——NULL··—7599 Indian School RoadMiamiFL33150——
TPATPA-602662026-01-04T13:48:56ZOmar—Ortiz1956-02-23··N/A-—2029 Ridge RoadNashvilleTN37239—N/A
TPATPA-584492026-05-14T00:52:13ZSalazar, Samuel——1980-09-13N/A•••-••-7559-—8284 HARBOR BOULEVARDSacramentoCA95851N/Anull
TPATPA-56999 2026-10-12T13:05:29ZJOSEPH—COE1986-04-16·-nullnull—427 Pine DrSan Antonio·Texas78238GRP-6473CORE-HMO
TPATPA-56631 2026-02-05T18:29:34ZYuki··Russell1942-02-14·null•••-••-5975483.990.4752UNKNOWN4736 Ridge Rd··MesaAZ—····-
TPATPA-582432026-06-29T17:30:04ZMaria—Gonzales19460421UHC-62081-02•••-••-1501(483) 338-1608—6725 Bayshore DriveGlendaleAZ85330GRP-1024····
TPATPA-635622026-09-24T09:02:44ZLe, Alexander——·Nov 18, 2005UHC-62633-54—932-950-6105N/A5252 LAKE VIEW ROADPlanoTexas75032··NULLnull
TPATPA-567192026-10-01T02:38:21Zteresa—alvarado1974-07-25UNKNOWNnull315-669-9436NULL·5002 Union StreetEden PrairieMN·55339GRP-5111··—
TPATPA-522412026-08-30T05:10:08Z·Santiago—Kelly06/14/03-null3477558957··UNKNOWN1154 Desert Sky BlvdMiamiFL33145N/A—
TPATPA-525872026-07-30T09:35:38Zlinda—washington1995-04-16—•••-••-3376+1 446 694 0620—1249 Union StScottsdaleAZ85267—NULL
TPATPA-530032026-06-30T19:10:18ZDEBBIE··GOMEZ1947-08-07NULLNULLNULL—7243 Lincoln WayLAS VEGASNV89129-NULL
TPATPA-573832026-10-01T02:15:53ZRalph—Sullivan1944-12-18NULL•••-••-7126·NULLralph.sullivan5@gmail.com19 Washington StreetORLANDOFL32867GRP-9150··OPTIONS-PPO
14,474 rows, page 226 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:56.307Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty