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-603672026-06-01T03:18:18ZDAVID—BROOKS1939-05-06—NULLnull—5972 Jefferson AveJacksonvilleFL32262-5310···-choice-plus-ppo
TPATPA-586742026-02-21T17:43:49ZLisaIVarges1939-02-28NULLNULL—····-nullUNKNOWN—UNKNOWNUNKNOWN
TPATPA-590682026-09-02T19:22:57ZScott··Thomas1970-07-24—•••-••-99317134747562-2385 PARK PLACEEDEN PRAIRIEMN·55374nullCORE-HMO
TPATPA-623122026-05-28T10:03:26Zsusan—perez1958-01-06—N/A(685) 456-8255UNKNOWN434 River RdColumbusOH43274NULL-
TPATPA-601162026-04-17T05:57:28ZSANTIAGO—ALLEN09/04/1975-•••-••-6666—santiago.allen57@hotmail.com2932 Ocean AveNashvilleTN37213-8193nullSELECT-EPO··
TPATPA-520812026-06-01T05:51:33ZFRANK—PORTERDec 27, 1982··null•••-••-2819332-961-1101—8330 WILLOW COURT··CHARLOTTENC28200—MEDICARE-ADV-B
TPATPA-617002026-07-10T20:48:27ZJordan—Greene1982-01-72—•••-••-0418(232) 920-2495··2298 CAMELBACK ROAD #808ScottsdaleAZ85255····N/A
TPATPA-615922026-05-16T18:19:30Zwiill····price1983-07-02NULLN/A——1117 OAK STScottsdaleAZ85223——
TPATPA-554892026-07-15T18:09:49ZWatkins, Alexis——19461008UHC-25813-01··-··N/AUNKNOWN———N/AN/A—
TPATPA-604492026-09-23T10:40:23ZWEI—POWELL1941-11-23—•••-••-2857(715) 428-7219wei.powell22@gmail.com4263 Cedar LnGlendale··AZ85343N/ASELECT-EPO
TPATPA-518732026-06-06T08:25:03Z sue—sanchez01/12/84NULLUNKNOWNN/A—8249 Desert Sky Boulevard··TampaFL33657—UNKNOWN
TPATPA-626522026-05-12T09:54:34ZDiana—Mills19-11-1972····-(851) 764-1826—7835 Broadway Apt 25ATLANTAGA30342N/Anull
TPA TPA-544762026-03-04T11:41:06Zphilip—georgeOct 3, 1973N/A—N/ANULL3287 MAIN STREET·PhoenixAZ85055—-
TPATPA-520802026-06-06T19:42:43ZRoebrt—Perkins1968-11-24UHC-38217-24UNKNOWN695-527-3693ROBERT.PERKINS@ICLOUD.COM7520 Ocean AvenueJacksonvilleFL32240NULL—
TPATPA-629532026-06-07T18:43:36ZBarbara—ReedDec 15, 2006-—+1 887 893 1641—878 Lake View RdSeattleWA98166NULL-
TPATPA-635862026-01-13T05:37:47ZBRANDON—EDWARDS1948-04-23UNKNOWNNULL-—3531 Church Street·Sacramentoca95850GRP-8035NAVIGATE-HMO
TPATPA-607062026-02-01T10:35:53ZBRENDA—CARPENTER·5/23/1953-NULL4432906-4125 Canyon Road··MinneapolisMN55419——
TPATPA-542062026-09-13T20:01:47ZJames—Aguilar1996-05-17-··-N/A··6531 Meadow LnGlendaleAZ85395N/A-
TPATPA-522802026-04-19T07:40:32ZLAWRENCE—WAGNR8/3/1952UNKNOWNNULL9752639074UNKNOWN2661 Indian School RoadPHOENIXAZ··85030——
TPATPA-568592026-09-26T22:19:22ZAUSTIN—JOHNSON2008-01-03UHC-23041-70N/A372.610.2415UNKNOWN517 MOUNTAIN VIEW DRMinneapolisMN55440—MEDICARE-ADV-A
TPATPA-610452026-09-03T23:41:57ZKYLE—MILLER1927-10-17N/ANULL12157418181—436 UNION STREETMinneapolisMN55458N/AUNKNOWN
TPATPA-558312026-02-18T23:30:51ZMendoza, Thomas——2007-04-23UHC-73410-84—UNKNOWNN/AN/A—NULLN/AUNKNOWN—
TPATPA-534982026-02-07T10:54:46ZKATHRYN—SIMS1958-10-08··UHC1801185-445.683.4980kathryn.sims8@yahoo.com8523 SAGE COURTCharlotteNC28271—UNKNOWN
TPATPA-636132026-09-02T02:05:15ZJacob—Rose01/02/1989—UNKNOWN····—933 Jefferson Ave··HoustonTX77057NULLUNKNOWN··
TPATPA-610252026-02-28T19:43:06ZJoyceB.Jaes1976-07-06—null—UNKNOWN6288 Lake View RoadTAMPAFL—NULLNULL
TPATPA-528472026-04-16T09:34:03Z·Evelyn—Simmons03/10/1972—-—UNKNOWN2801 Elm StChandlerAZ85215GRP-2015MEDICARE-ADV-B
TPATPA-560092026-05-11T19:25:48ZANTHONY·LPALMER1953-06-21UHC-35596-29·UNKNOWN(640) 743-5110—867 Elm StFresnoCalifornia93755GRP-2785CORE-HMO
TPATPA-631072026-07-23T16:56:22ZKEVIN—BURTON1974-02-28UHC4023103N/A(884) 608-1503UNKNOWNNULLnullNULL——NULL
TPATPA-556072026-03-25T21:56:54ZLUIS—NELSONJun 21, 2007UNKNOWN•••-••-1722N/ANULL5017 Sunset BoulevardSEATTLEWA98115——
TPATPA-505482026-05-04T19:19:40ZDANIELLE—WANG4/12/1982NULL——··5970 Elm StGLENDALEAZ85394—MEDICARE-ADV-A
TPATPA-630282026-01-28T22:12:20Zmegan—elliott1999-03-18—-··UNKNOWN2593 Harbor BlvdOrlandoFL32822-4097-MEDICARE-ADV-B
TPATPA-586222026-02-28T17:28:33Zmary—lewis1964-12-11null——MARY.LEWIS69@HOTMAIL.COM801 HIGHLAND AVENUEEden PrairieMN55315N/AUNKNOWN
TPATPA-511042026-07-13T21:12:06ZEricWWright1939-06-11NULL—--5338 MAIN STMesaAZ85239··SELECT-EPO
TPATPA-644482026-01-15T17:37:04ZAdam—Williamson1957-09-07····•••-••-1804+1 206 237 6599—6488 CENTRAL AVENUEFresnoCA··93772-2052——
TPATPA-551712026-07-14T17:28:55ZMELISSAJJORDANOct 21, 1981—•••-••-3123—melissa.jordan56@icloud.com1628 Central Avenue Apt 9MesaAZ85235-NULL
TPATPA-610632026-05-09T15:37:46ZBEVERLY—ALLEN1963-01-04UHC-37163-07•••-••-5444(770) 523-2843··N/A··2944 Willow CourtJacksonvilleFL32247-7464GRP-5888NULL
TPATPA-599482026-05-03T23:37:32ZPhilip—Vasquez··1/18/1942-•••-••-17706258985815NULL1135 Sage CourtJacksonvilleFlorida32237·UNKNOWNnavigate-hmo
TPATPA-639092026-03-22T13:30:00ZMYERS··—GEORGE1970-10-13null—12065219426·null2198 Sage CourtSCOTTSDALEAZ85218GRP-3497—
TPATPA-577582026-04-19T23:57:53ZMason—Espinoza1941-11-26—•••-••-2622NULL-9727 Canyon RoadScottsdaleAZ85256GRP-3777SELECT-EPO··
TPATPA-512992026-02-06T09:05:13ZEthanNKennedy1975-12-10—•••-••-2330———··null-—CORE-HMO
TPATPA-618682026-10-04T23:50:24ZLARRY—SINGHJul 15, 2004UHC-55360-97··•••-••-1069228-655-7941····3589 Main St·Los Angeles·CA90036N/A··NULL
TPATPA-595692026-09-08T14:26:50Z·Bradley—Mendoza1988-06-16UNKNOWNN/A--2384 Church StreetCHARLOTTEnc28245—·OPTIONS-PPO
TPATPA-637602026-09-16T12:19:22Z Munoz, Jordan——27-05-2007UHC-45378-23•••-••-3647—jordan.munoz58@gmail.com4852 MOUNTAIN VIEW DRIVEMesaAZ85211GRP-5134CORE-HMO
TPATPA-556082026-08-27T17:17:45ZPorter, JerryE—1980-01-22··—UNKNOWN—8480 FOREST AVETempeAZ-nullNULL
TPATPA-519822026-03-13T22:51:19ZTIMOTHY—TRAN1958-04-25UHC-04978-95N/A4657645355timothy.tran1@proton.me—N/A-··—GRP-2761··—
TPATPA-642332026-01-18T17:38:23ZDanielle—Simpson1995-03-09—--—5969 CHURCH STREET··ChandlerAZ85217-N/A
TPATPA-632152026-07-04T00:42:55ZFRANCES—HANSEN1958-11-10UHC-28727-85-UNKNOWN-8848 LINCOLN WAYSan DiegoCA··92179N/A-
TPATPA-528202026-02-27T23:52:54Zstephanie—burns19630707N/AN/A529-535-3964-2406 INDIAN SCHOOL ROADCharlotteNCN/AGRP-4320UNKNOWN
TPATPA-594492026-06-12T23:46:44ZWilliam—Kim2003-05-19UNKNOWN•••-••-5641458-872-9795william.kim92@proton.me9073 Cedar LnMesaaz85227NULL··NULL··
TPATPA-609482026-08-05T13:45:44ZChristopher—Contreras19-12-1951——nullnull····UNKNOWN-—UNKNOWNnull
14,474 rows, page 169 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:52.227Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty