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-588812026-08-31T04:41:14ZJessicaG.Marquez02/23/95—•••-••-5506-jessica.marquez@aol.com2107 Sunset BoulevardGilbertAZ85212——
TPATPA-611902026-06-29T22:36:09ZLUCIA—WILLIAMS1996-04-13null-N/Alucia.williams86@hotmail.comnull-—null—null
TPATPA-579452026-01-20T21:30:00ZAustin—Tohmas28-05-2004··UHC-15598-86—-austin.thomas78@hotmail.com315 Valley View DrSacramentoCA95821··GRP-9525N/A
TPATPA-603222026-02-18T15:11:13ZTricia—Cooper1938-05-02——UNKNOWNpatricia.cooper@hotmail.com3209 Baseline RoadFresnoCA93792·GRP-5148—
TPA TPA-601012026-10-03T13:00:53Z·Terry—Weaver1940-10-16UNKNOWN··-N/Aterry.weaver@icloud.com3798 CAMELBACK RDTempeAZ85205-NULL
TPATPA-528072026-02-19T00:14:39Zbilly—bennett19530125—•••-••-5452NULL—1043 SAGE CTSeattleWA98127GRP-4164MEDICARE-ADV-B
TPATPA-524772026-06-18T20:08:15ZWillie L.····Shmidt1978-04-21UHC-26025-53•••-••-0470477-953-0898—5446 Forest AveCharlotteNC28201GRP-8600null
TPATPA-545162026-10-01T06:00:59ZAnela—Moreno1984-07-14————5944 Park PlaceHouston··TX77001—OPTIONS-PPO
TPATPA-573002026-09-21T04:14:29ZBailey, Logan··——Oct 7, 2001N/A—(218) 681-2804null4259 Indian School RdMinneapolis··MN55413GRP-8027—
TPATPA-614722026-03-01T13:56:37ZIsabellaRFerguson1995-12-16-———2535 PARK PLACEGilbertAZ85279null··—
TPATPA-501632026-08-14T14:40:42ZDaniel—HowellSep 20, 2008··——UNKNOWNdaniel.howell45@aol.com3838 Central AvenueTucsonAZ85760-8804NULLCHOICE-PLUS-PPO
TPATPA-612092026-07-06T11:25:25Zisabella—rede09/07/60UNKNOWN··UNKNOWN—·UNKNOWN7712 JEFFERSON AVENUETempeAZ85212N/A-
TPATPA-542202026-03-02T04:37:05ZSamanthaUPatterson1973-10-20-—-null··1608 Sage CourtSCOTTSDALEAZ·85290nullMEDICARE-ADV-A
TPATPA-501432026-03-11T14:53:29ZRussell—Delgado1987-05-25N/AN/A(942) 996-4485-6154 Church StNASHVILLETN37221—UNKNOWN
TPATPA-531172026-06-15T19:08:40ZChristian··—Yang8/1/1945UNKNOWNN/A2477102NULL8005 Willow CourtAustinTX78785N/AUNKNOWN
TPATPA-581092026-06-20T15:10:07Zhelen—oliver26-08-1978-··•••-••-8802(744) 667-7328helen.oliver63@outlook.com7301 CHURCH STREET··ColumbusOH43250—OPTIONS-PPO
TPATPA-572312026-05-05T04:11:05ZOLYVIA—MALDONADO02-04-1959-———N/Anull——null—
TPATPA-53397 2026-02-07T17:21:26ZPETER—ORTIZ1975-01-03nullnull(943) 505-9428—5318 Park PlaceMinneapolisMN55465GRP-9875·NULL
TPATPA-623262026-01-30T16:47:10Zkeith—larson1994-01-19——(291) 637-1340—4843 OAK STDallas·tx75229—NULL
TPATPA-574222026-02-16T11:39:14ZKATHLEEN····HOWARD1986-01-21UHC-39187-01·-UNKNOWN——·UNKNOWNUNKNOWNN/ANULLNAVIGATE-HMO
TPATPA-572632026-01-04T00:19:54ZNicholasVMiller1959-05-12UHC-78923-11NULLnull·null5983 SPRING STREETTampaFL33697-8192GRP-4349OPTIONS-PPO
TPATPA-622732026-07-09T22:46:04ZWei—LittleJul 25, 1973UHC-16840-90nullN/A—3110 Jefferson Avenue·PhoenixAZ85084-9331-—
TPATPA-571072026-04-19T20:12:36ZLinda··Little1986-10-25—-null—7194 Main StreetDenverCO80220NULL—
TPATPA-528352026-07-11T20:55:16Z Kenneth—Roberts19770107UHC-87369-79NULL6313018862-·2936 Hillcrest RoadChandlerArizona85268—N/A
TPATPA-569672026-01-08T04:36:17ZScott····Reed1984-08-28—·NULL(794) 605-5652scott.reed87@outlook.com9220 Union St Apt 36TempeAZ85299-8816UNKNOWNMEDICARE-ADV-B
TPATPA-609472026-01-04T13:47:39ZOliver, Amy——1964-04-19··——742-558-5921UNKNOWN6412 Meadow LnColumbusOH43278··-·UNKNOWN
TPATPA-532422026-09-09T19:45:46ZHAVEY—JEREMY·1965-06-25nullNULL··+1 314 282 5643—3677 Pine DrHouston··tx77046-N/A
TPATPA-570892026-04-08T14:36:10Zarjun—·torres04/21/86—NULL(797) 826-8816······4920 Cedar LaneOrlandoFL32805··N/A—
TPATPA-630132026-02-20T05:21:58ZJUSTINY.JACKSON1995-01-02—•••-••-2478·3712903668justin.jackson91@yahoo.com4662 Apache BlvdDENVERCO80254null-
TPATPA-631672026-02-12T23:16:20ZNncy—Porter··1940-07-15——(873) 781-0252nancy.porter@hotmail.com6331 Ocean AveDALLASTX75291null··N/A
TPATPA-546592026-06-20T14:42:27Zstephanie—porter2001-02-18····--—3225 Forest AvenueDenverCO80200GRP-2971CORE-HMO
TPATPA-612472026-01-17T19:50:49Z Kathleen··—Jordan19930520-•••-••-3930456.265.3540KATHLEEN.JORDAN4@AOL.COM5168 RIVER ROADHOUSTON·TX77026NULLMEDICARE-ADV-B
TPATPA-629202026-02-27T10:52:07ZTim—Andrews2004-10-24N/A-(629) 586-6091null8479 Market StreetGilbertAZ85293··null
TPATPA-595902026-08-06T19:36:36ZLarry—Hnson1959-07-28—•••-••-8870UNKNOWN—·5391 MOUNTAIN VIEW DRSEATTLEWA98133GRP-2378·null
TPA TPA-603122026-05-24T14:04:52ZLarry—·Salazar11-01-1959NULLnullnullUNKNOWN3354 Park PlaceGilbertAZ85257-9923UNKNOWN·CORE-HMO
TPATPA-524882026-03-04T21:34:29ZGrace····SinghAug 17, 1980··•••-••-63335928829805UNKNOWN3869 Central AvenueMIAMIFL33192N/A—
TPATPA-643312026-08-12T19:22:28ZPamela—AlvaraoJan 4, 2003····——-144 Mountain View Drive #461Eden Prairie·mn55355GRP-8286—
TPATPA-566262026-09-24T12:36:22Z Cynthia····Sandars1982-11-05-•••-••-2604—·N/A3725 Central AveTempeAZ85213GRP-4043·CORE-HMO
TPATPA-563252026-05-22T23:47:05ZLUIS—MILLER1998-03-25-—376.486.2465luis.miller@outlook.com6417 APACHE BOULEVARDFresnoCA··93795——
TPATPA-603592026-05-26T22:33:27ZANN—LAWRENCE1991-32-14——null·-8405 Apache BoulevardMIAMIFL33125GRP-4223-
TPATPA-50389 2026-08-20T16:22:50ZMarcus—Wallace0208-19-19—UNKNOWN-—7455 PALM DRIVEPlanoTX75030NULLN/A
TPATPA-632142026-02-08T01:20:47ZJanet—Olson19510304—N/A——3349 Palm DrATLANTAGeorgia30378GRP-8636OPTIONS-PPO
TPATPA-54955 2026-05-21T16:02:11ZDiego·S.George19620715—•••-••-5509——251 Apache BoulevardTucsonAZ···85792GRP-9440MEDICARE-ADV-B
TPATPA-610372026-09-06T23:46:31ZJohnson, Mark··········09/14/89UNKNOWN•••-••-9441——3957 WILLOW COURTScottsdaleAZ85265GRP-5056—
TPATPA-602262026-01-02T22:45:07ZCynthiaHJenkins1950-04-28UHC-09930-93•••-••-14538026603486cynthia.jenkins23@hotmail.com1893 Ridge RoadSAN ANTONIOTX78275··—MEDICARE-ADV-A
TPATPA-536692026-03-17T04:21:13ZMASON··—MALDONADO··1982-10-08N/AN/Anull—N/AUNKNOWN—N/A—SELECT-EPO
TPATPA-638742026-01-26T12:32:12ZChristina—Silva·1989-01-20—•••-••-0032(552) 493-2005··UNKNOWN4021 MAPLE AVELas VegasNV89161—NULL
TPATPA-632672026-07-23T20:48:13ZRoger—Marquez22-12-1964-·-——5303 Elm Street Apt 14MinneapolisMN55407—core-hmo
TPATPA-540172026-05-15T06:39:27ZJuan—Kim9/28/1965·NULLnullNULL—8159 River Rd Apt 23NashvilleTN37259GRP-3819—
TPATPA-568642026-02-23T09:02:22ZPETER·VBAKER2001-04-28—•••-••-6222nullUNKNOWN9241 SUNSET BLVDFresno·CA93757-NULL
14,474 rows, page 257 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:43:00.526Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty