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-606662026-08-12T06:58:34ZDebra—·Howell1942-03-16null•••-••-6399UNKNOWNUNKNOWN9725 MESA DRIVEAUSTINTX78743—null
TPATPA-617682026-02-07T00:49:13ZNancy····Rikhards1948-06-12UNKNOWN•••-••-5878—-—N/Anull—GRP-6136—
TPATPA-590402026-04-20T15:27:13ZCal—Rivera1980-12-03N/A—UNKNOWN—5451 Grand AvenueEden PrairieMN55370N/A—
TPATPA-541842026-07-02T17:59:22ZJacob—Chavez1996-07-24UHC0631927—509-963-9131—·8356 Mesa DriveLas VegasNV89183UNKNOWNNULL
TPATPA-643422026-03-25T17:44:53ZAUSTIN··—GEORGE06/14/43·-—-UNKNOWN8288 Apache Boulevard #908Eden PrairieMN—GRP-9874-
TPATPA-540732026-05-30T18:21:46ZWALTER—MORRISON6/23/1994—NULL·516.564.0150——NULLnull——NULL
TPATPA-546852026-10-11T22:49:03ZELIZABETH—GARDNER22-03-1944——842-271-7716NULL——N/Anull—CHOICE-PLUS-PPO
TPATPA-625412026-06-22T03:52:35ZAARON—GONZALEZ1962-11-03··UNKNOWN•••-••-8066-—9680 MOUNTAIN VIEW DRSeattle··WA98103NULLNAVIGATE-HMO
TPATPA-591922026-10-17T04:42:57ZCHRISTOPHER—CASTRO2005-02-27N/A•••-••-1680(301) 432-5148christopher.castro@aol.com1841 MAPLE AVENUELAS VEGASNV89108—null
TPATPA-541232026-08-13T15:55:37ZJUSTIN—RUSSELL1972-06-26N/AnullNULLJUSTIN.RUSSELL68@OUTLOOK.COM2618 CHURCH STREETNASHVILLE·TN37221N/A····
TPATPA-541302026-02-12T18:52:32ZASHLEYPSCOTT19980422—•••-••-0610UNKNOWN—NULLNULL··nullN/AUNKNOWNN/A
TPATPA-559082026-03-19T05:53:37Z·JEREMY—OLIVER1975-08-04——UNKNOWN··6752 Palm Dr Apt 1ChandlerAZ85272GRP-4286··NAVIGATE-HMO
TPATPA-621392026-09-18T18:13:33ZVirginia—Chaevz19730922NULL•••-••-6407nullnull4032 Meadow LaneMiami··FL33150—N/A
TPATPA-547082026-10-04T03:28:41ZHenry—Mejia07/19/1952——(722) 237-9746null2554 UNION STREETJACKSONVILLEFL32237NULL—
TPATPA-500712026-07-06T21:10:43ZWASHINGTON—PAUL1978-03-11NULL—UNKNOWNUNKNOWN3488 Central AveSan DiegoCA92188—-
TPATPA-602342026-07-19T13:17:46ZKatherine—Carpenter22-08-1977—NULLUNKNOWN·NULL2630 HARBOR BOULEVARDTampaFL33659NULL—
TPATPA-546542026-08-06T16:54:34ZBilly—King1969-08-10UHC-12485-82•••-••-9482268-203-5948—7862 Highland AvenueChandlerAZ85280NULLUNKNOWN
TPATPA-551362026-08-01T07:25:21ZNANCY·····CLARK1938-12-27UNKNOWN•••-••-3291795.812.8966nancy.clark@gmail.com5468 Ocean AvenueSeattleWashington98114UNKNOWN—
TPATPA-529262026-09-07T17:01:47ZIsabella—·Flores·2000-06-04NULL—UNKNOWNNULL3163 Forest AvePlanoTX···75000——
TPATPA-573382026-02-02T17:20:54Z KEVINW.HARVEY10-06-1953—····——null—UNKNOWN—GRP-6160MEDICARE-ADV-A
TPATPA-531982026-06-19T14:23:30ZScott—Simmons01/09/76··—•••-••-4362(876) 893-2158—2254 Lake View Rd·MesaAZ85226-3737-·NULL
TPATPA-547982026-08-30T22:09:10ZDunn, WilileV····1968-09-07NULL····——7513 Jefferson AveMINNEAPOLISMN55476GRP-2288NULL
TPATPA-524142026-04-06T13:03:59ZAnn—Simpson19750113—•••-••-4610426.830.8851—63 Indian School RdTempeAZ85297-0333—-
TPATPA-631522026-08-20T02:21:15ZAshley—Coleman··9/15/1950NULL-(893) 861-6922null4299 WASHINGTON STREETLos AngelesCalifornia90057—·UNKNOWN
TPATPA-617122026-02-14T23:01:33Z Gary—Collns17-09-1978—•••-••-5373—gary.collins@proton.me3518 Mountain View DrLos AngelesCA90037UNKNOWN··
TPATPA-569122026-08-16T05:30:43ZISABELLA K.—MORRIS2006-07-20··--nullUNKNOWN··N/Anull—-
TPATPA-615722026-03-13T13:43:28ZMatthew··Sanchez19730751NULL-NULL—5256 Palm DriveScottsdaleAZ85242GRP-4941MEDICARE-ADV-A··
TPATPA-63528 2026-05-31T01:26:15ZAlice—Day2001-05-06·-null··696-978-8454alice.day@proton.me6309 UNION STREETDallas·TX75288··-·NAVIGATE-HMO
TPATPA-615362026-09-14T16:06:52ZChristopher—Harris11/20/48—N/A·8657013414—3241 Valley View DrTUCSON·AZ85782GRP-5226MEDICARE-ADV-A
TPATPA-606622026-06-14T05:48:33ZAlexysA·Washington1988-02-18nullN/A—-null——NULLNULLnull
TPATPA-524682026-06-01T18:23:19ZRAYMOND—GARDNER19480119········NULL1331 INDIAN SCHOOL RDScottsdale··Arizona85260UNKNOWNUNKNOWN
TPATPA-634112026-01-26T23:20:43ZMARI···GREENE3/10/1981—nullUNKNOWNnull2309 Market StLas VegasNV89167——
TPATPA-602402026-08-29T08:02:54ZDenise—Young11/18/1969—UNKNOWNnull—2167 Desert Sky Blvd·TempeArizona—nullN/A
TPA TPA-560132026-10-10T21:05:45Z·David—Luna1939-04-12nullN/A··david.luna81@proton.me6507 Sunset Boulevard Apt 37ORLANDOFLN/AN/A—
TPATPA-575442026-09-11T02:09:14Z LROI··MEYER05/01/1993····-UNKNOWN—8137 Highland AvenueScottsdaleAZnullGRP-3224NULL
TPATPA-581732026-04-11T08:38:40ZSUSAN—WANG2008-01-18-•••-••-4514—N/A4062 CENTRAL AVENUE #224OrlandoFL32847NULLCHOICE-PLUS-PPO
TPATPA-56075 2026-07-23T19:01:31ZTimothy—Gonzalez9/16/1941—·-nullTIMOTHY.GONZALEZ90@PROTON.ME9092 Willow CourtMinneapolisMN55494-7502UNKNOWNNAVIGATE-HMO
TPATPA-522642026-09-04T16:38:35ZRichard—Hudson1974-01-08N/A-701-740-0006-7415 SAGE COURTSeattleWashington98183NULL—
TPATPA-534552026-01-02T11:46:35ZLauren—SanchezApr 4, 2008N/A—nullUNKNOWN9759 Highland Ave··ColumbusOH43200GRP-4194CHOICE-PLUS-PPO
TPATPA-502672026-10-15T16:25:25ZCarolyn—·Dixon1973-10-21NULL··UNKNOWN-CAROLYN.DIXON80@ICLOUD.COM1496 CAMELBACK RDAustinTX78784GRP-4319NULL
TPATPA-601492026-07-07T10:35:29ZKaren—Green06/27/53N/A——NULL—-nullN/A-select-epo
TPATPA-56195 2026-09-04T00:52:33ZOMAR—WOODS19800905—•••-••-9675NULLN/A6776 Mountain View Dr Apt 20SAN DIEGOCA92146GRP-7165CORE-HMO
TPATPA-626972026-08-23T11:26:43ZHEATHER—GARDNER1996-07-12··-N/ANULLN/A3937 Elm StreetDenverCO··80212—·OPTIONS-PPO
TPATPA-635772026-04-23T11:37:07ZWest, Janice——Jul 13, 1955NULL•••-••-6384-—6528 MAIN STREETSCOTTSDALEArizona85235GRP-8361CHOICE-PLUS-PPO
TPATPA-506262026-03-07T21:53:01ZDANIEL—LEE··1956-02-05····nullUNKNOWNnull8813 Palm DrTempeAZ85224null—
TPATPA-57331 2026-04-03T03:57:00ZSamantha—Henderson1/13/1945————2943 CANYON RDJACKSONVILLEFL32266—MEDICARE-ADV-B
TPATPA-547662026-08-21T16:18:41ZJimenez, Priya······1962-12-10—•••-••-6130nullPRIYA.JIMENEZ16@HOTMAIL.COM1209 Central AvenueDallasTX75242—-
TPATPA-516232026-09-22T19:10:08ZBruce—Mills02-05-1956null—·--3929 Elm StScottsdaleAZ85217GRP-2599UNKNOWN
TPATPA-533522026-09-21T08:03:48ZMatthew—Contreras1942-06-17UHC-62984-58····—9655 Baseline RdLas VegasNV··89170GRP-1242-
TPATPA-537562026-09-20T19:34:05ZARJUN—SMITH1946-09-23—····——7371 Bayshore DriveMinneapolisMN55409··GRP-5951NULL
14,474 rows, page 143 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.453Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty