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-503922026-08-08T15:31:42ZAlbert—Henderson03-10-2008·UNKNOWN•••-••-3452——4658 Maple Ave·Scottsdale·AZ85240-—
TPATPA-528952026-01-22T00:44:31Zeugene—cox1983-02-14··null•••-••-0109UNKNOWN-28 Spring StMiamiFL33105GRP-8477choice-plus-ppo
TPATPA-516442026-08-08T00:58:27ZMei—Hansen1974-12-15N/A··NULL····null·4449 Indian School Road·SeattleWA98145GRP-8345CORE-HMO
TPATPA-502562026-04-24T18:48:36ZLauren—Simmons09/13/1949N/A•••-••-09769387382916LAUREN.SIMMONS@YAHOO.COMN/A·null——null—
TPA TPA-535732026-06-17T02:41:29ZKATHERINE—BURNS1964-03-26-—NULLUNKNOWN6722 Grand AveSeattleWA98103GRP-7709UNKNOWN
TPATPA-573912026-06-15T15:35:03ZNunez, Julie——·1944-02-08NULL•••-••-6650(325) 273-8996—4354 Camelback RoadNashvilleTennessee··37287—-
TPATPA-602312026-08-24T06:42:10ZMichelle—Mendez19671220N/A-null—1553 Hillcrest RdSacramentoCA95820-UNKNOWN
TPATPA-50424 2026-02-05T10:39:09ZPeter—Carter1999-02-24N/A-——8215 Market StreetFresnoCA93755—MEDICARE-ADV-A
TPATPA-531832026-04-01T07:15:20ZBRUCE—VEGA04/11/89NULL•••-••-89849093221346bruce.vega80@outlook.com···3482 Maple AveDenverCO80277GRP-8059··CORE-HMO
TPATPA-563342026-07-11T00:38:22Zwei—castillo1960-11-18UNKNOWN•••-••-7937····NULL··2397 Willow CourtEDEN PRAIRIEMN55392UNKNOWNUNKNOWN
TPA TPA-643542026-04-01T22:21:49Z ·Ahmed—Adams1986-11-16nullN/ANULLN/AN/AUNKNOWN-··NULL·GRP-4766CORE-HMO
TPATPA-519552026-08-06T02:53:05Z Maria····Fields2000-02-10—N/A··4563813806—9137 OCEAN AVENUESacramentoCA95838GRP-8893—
TPATPA-616632026-06-20T11:53:56Zjack—tayllor·2003-01-12NULL•••-••-253218352127439N/A5011 Palm DrMiamiFL33193nullCHOICE-PLUS-PPO
TPATPA-53185 2026-08-24T23:48:18ZABBY—STONE··2008-12-07N/A•••-••-1424709-628-9569—9054 Mesa DriveTampaFL33681UNKNOWN-
TPATPA-568952026-10-02T15:21:25ZMaria—PerryDec 23, 1998UHC-43223-30•••-••-0321-MARIA.PERRY64@PROTON.ME8434 UNION ST·San DiegoCA92151N/Anull··
TPATPA-503802026-02-01T10:10:01ZbrandonWrussell1945-07-24null—·NULLUNKNOWN7081 Main StreetJacksonvilleFL32262null-
TPATPA-518222026-04-03T10:30:41Z·George—Lewis2005-02-23-—+1 541 759 4227NULL2058 SAGE COURTHoustonTX77017UNKNOWN—
TPATPA-554632026-07-31T21:49:28ZWiliamson, Amy——19821120—•••-••-1001—N/A7943 Desert Sky BlvdJacksonvilleFlorida32201N/A—
TPATPA-532752026-06-15T20:57:04ZCHRISTIAN—REYNOLDS1969-04-15NULL———836 Bayshore Drive·PlanoTX75001N/A—
TPATPA-61110 2026-01-13T08:36:03ZBrian—Morgan19980316NULL•••-••-9921-··NULL9619 Maple AvenueLOS ANGELESCA90072-CORE-HMO··
TPATPA-504852026-02-17T16:48:55ZPARKZDONALD1995-07-25··—+1 893 669 7271—8179 Church Street·MiamiFL33175—NAVIGATE-HMO
TPATPA-630182026-06-03T09:09:31Z Hoffman, Jack··——1949-11-27nullnull787-665-3289—-nullNULL-GRP-8534—
TPATPA-642192026-10-01T08:20:00ZMCCOY—CARL1966-04-05UHC-91013-94•••-••-3940—UNKNOWN6685 Sunset BlvdAustinTX78784-5141null—
TPATPA-526232026-06-04T11:39:03ZBrittany—Hall1964-03-06UHC-67985-87N/A--6962 Desert Sky BlvdHoustonTexas77081N/Aselect-epo··
TPA TPA-557802026-10-03T16:45:38ZDixon, Diana——1963-04-18··null•••-••-86205818824163NULL·5701 UNION ST·NashvilleTN—null—
TPATPA-594792026-06-24T20:08:25ZRivera, Alexander——1958-07-12—N/ANULL—298 WASHINGTON STPhoenixAZ85087——
TPATPA-521462026-01-24T15:47:36ZAndrea—Berry1949-10-18NULL—nullandrea.berry@yahoo.com5291 Main StPhoenixAZ85010-7471GRP-7581NULL
TPATPA-569432026-03-04T15:29:25ZMasonQAustin1986-12-16—NULL(605) 347-7192—nullnull——NULLMEDICARE-ADV-A
TPATPA-626892026-04-14T01:01:31ZJoyceM.Hanson1963-01-25null-—-7610 Mountain View DrPlanoTX75019GRP-6601UNKNOWN
TPATPA-505002026-01-11T09:09:59Z·Omar—Burton1964-04-13UHC-87703-12nullnull—8162 Apache BlvdChandlerAZ85204-N/A
TPATPA-586652026-03-29T03:47:38ZArthur—Sanders1946-01-06N/A•••-••-7713—null·8522 Main St Apt 22OrlandoFL32809GRP-5725NULL
TPATPA-528492026-05-10T03:47:53ZCARLOS—WALSH4/23/1986——5678805850N/A1398 River RdFresnoCA··93741—select-epo
TPATPA-517772026-09-01T13:38:21ZBEVERLY—FULLER1941-08-02——NULLNULLUNKNOWN-——UNKNOWNMEDICARE-ADV-A
TPATPA-510272026-07-15T18:35:56ZMARGARET—FRANKLIN1941-10-02UNKNOWN—8007245347MARGARET.FRANKLIN@AOL.COM4443 Central AvenueGilbertAZ85274GRP-3508SELECT-EPO
TPATPA-630472026-05-23T13:09:39ZLnua, Cheryl—····12/26/1999UNKNOWN-943-851-5939null5148 Harbor BoulevardAtlantaGAN/A—CORE-HMO
TPATPA-544542026-07-10T16:31:33Z·BEVERLYPAUSTIN2007-40-20——··null9889 APACHE BLVDScottsdaleAZ85214—CORE-HMO
TPATPA-503412026-07-21T05:28:49ZSHIRLEY—BELL04-11-1971NULL—768-589-1733UNKNOWN8891 WASHINGTON ST··HoustonTX77050nullCORE-HMO
TPATPA-530242026-02-04T16:31:31Z Laura····Aguilar1943-08-17nullNULL——3684 BASELINE RDDenverCO80283GRP-6700UNKNOWN
TPATPA-568962026-09-20T22:26:30ZBRIAN—REED08-12-1964—UNKNOWNUNKNOWNbrian.reed89@hotmail.com586 Ocean Ave··DallasTX75209NULLUNKNOWN
TPATPA-548742026-01-19T06:13:24ZVincent—Larson1988-05-15··UHC-73026-62•••-••-7026NULL—2120 Church StreetDALLASTX··75240··—
TPATPA-625892026-10-15T08:27:30ZWalter—Knight2002-07-25—N/A-walter.knight@yahoo.com7563 Ocean AvenueFresnoCA··93785—CORE-HMO
TPATPA-532482026-06-01T06:02:35ZmarkR··rojas1975-02-01UNKNOWN—N/AUNKNOWN3472 Ridge RdAtlantaGA30381——
TPATPA-609962026-02-23T23:58:24ZWEI—CRUZ11/23/1943UHC-51966-63—8042896007—9317 Indian School RoadPlanoTX75014GRP-8567N/A
TPATPA-570662026-01-10T22:21:18ZMelissa—Henderson··1956-08-04UHC-06487-05····14466595844N/A3872 HIGHLAND AVENUE··Los AngelesCA90021GRP-1707-
TPATPA-598502026-07-26T02:59:24ZSARA····MATTHEWS7012-20-06—•••-••-4777N/A—N/A··—null—UNKNOWNMEDICARE-ADV-A
TPATPA-504172026-10-03T00:48:52Z·Barb—Ryen5/1/1964-nullnullnull··6299 Sunset BlvdSan DiegoCA92148UNKNOWNMEDICARE-ADV-B
TPATPA-625662026-07-29T22:31:05Z·Kelly—Pierce1975-11-01—N/A-UNKNOWN7028 Mesa DrivePlanoTX75002GRP-6022—
TPATPA-509122026-01-10T05:29:53ZDennis—Williams·03/15/80-—UNKNOWNdennis.williams@gmail.com6382 Sage CourtGilbertAZ85204—-
TPATPA-60105 2026-05-13T21:56:00ZDiana—Mills3/8/1954NULL—(418) 615-8499NULL··8309 CANYON ROADDenverCO80237-8736GRP-4459—
TPATPA-520062026-07-01T18:41:50ZAmber—Mejia1953-02-17—NULL4953626145··-5149 Mesa Drive·Gilbertaz85265—OPTIONS-PPO
14,474 rows, page 50 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:38.472Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty