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-546402026-09-14T21:24:40ZSara—Ortiz1979-04-07-•••-••-66253052494046null6585 Lake View RoadMinneapolisMinnesota55411UNKNOWN—
TPATPA-528772026-03-12T05:48:58ZMASON··—TORRES15-07-1982··nullNULL3144807127NULL6111 Church StOrlandoFL32875-null
TPATPA-541282026-03-10T02:30:14ZEvans, Adam——1989-10-10—N/A8297865093··NULLnullN/A—UNKNOWN—SELECT-EPO
TPATPA-640612026-05-04T02:28:28ZMichael—McDonaldJul 5, 1982-··—2312030340UNKNOWN6489 Camelback RdGilbertAZ85245GRP-6146CORE-HMO
TPATPA-502952026-04-16T13:43:55ZThomas—Arnold21-02-2006null•••-••-0498202-740-8513NULL1279 FOREST AVE #301MIAMIFL33181··NULL-
TPATPA-536432026-06-30T09:10:00ZCamila—Williams19560724UHC-48033-98•••-••-3653—NULL9110 Mesa Dr Apt 3SacramentoCA95847GRP-2592OPTIONS-PPO
TPATPA-588042026-03-23T02:57:53ZFrankDSimmons1950-01-23··NULL-—UNKNOWN1973 Harbor BoulevardGlendaleAZ85385·GRP-7262null
TPATPA-510652026-05-08T19:59:10Z·RICHARD—LAWSON1947-05-12UHC-60766-62-UNKNOWN—560 MAPLE AVENUE Apt 23DALLASTexas75294-7210GRP-7711SELECT-EPO
TPA TPA-566042026-01-21T12:06:37ZKELLY—TUCKER2409-17-91———null—UNKNOWNN/A—-—
TPATPA-599262026-03-06T11:53:12ZBruce—·Clark1990-05-02—UNKNOWNN/A—·N/AnullN/A———
TPATPA-557422026-10-17T14:56:01Zhannah—simmons1981-12-04—-··+1 595 791 1275-N/A———null··
TPATPA-510292026-05-10T03:21:39Zjames—chen1961-02-13··——-UNKNOWN2201 River RdTucsonAZ85704·null—
TPATPA-591042026-03-17T01:39:17Z·Jacob—Maldonado26-07-1996—UNKNOWNNULL-nullUNKNOWN——GRP-3576SELECT-EPO
TPATPA-630662026-10-01T15:12:11ZOlivia—Gutierrez·Jun 2, 1971UNKNOWN—UNKNOWNUNKNOWN2108 OCEAN AVENUEDENVERColorado80237UNKNOWNNAVIGATE-HMO
TPATPA-550052026-07-04T10:45:42ZBurns, Pamela——19440511·-null——6099 Mesa DrMiamiFL·33140—OPTIONS-PPO
TPATPA-537642026-08-13T06:10:22ZKenneth—Pena2007-04-09UHC-19981-86UNKNOWNN/A·NULL8856 Main StMESAAZnull—NULL
TPATPA-580322026-04-19T05:53:43Zwilliam—weaver7/6/1971—•••-••-3267N/A—2512 Church StHoustonTX·77015-··NAVIGATE-HMO
TPATPA-520382026-10-05T05:09:18ZShirley—Gomez1997-05-20··—14435665971··shirley.gomez21@hotmail.com4826 Bayshore DrGLENDALEAZ85383nullmedicare-adv-b
TPATPA-566972026-03-12T22:59:49Zlucia—holmes04-02-2007····———8617 Highland AvenueGlendaleArizona85314GRP-6266CHOICE-PLUS-PPO
TPATPA-568002026-05-12T02:24:46Z BETTY—BROOKS1952-05-01UHC-46475-01NULL-—UNKNOWNUNKNOWN-null-null
TPATPA-576172026-07-17T10:10:45ZNANCY—HUGHES1997-02-05—-—NULL7424 CEDAR LANELas VegasNV89131GRP-8831UNKNOWN
TPATPA-528572026-07-01T22:08:37ZMateo—Vazquez05-10-1964UHC-94454-99—··-5141 Church St #719OrlandoFL·32800——
TPATPA-559482026-09-23T02:23:43Znoah—padilla1984-09-20UNKNOWN•••-••-7658—·N/A5201 Highland AveAustinTexas78774GRP-0456null··
TPATPA-510782026-07-20T13:15:11Z·DUNCAN—ALEXIS1974-05-28—•••-••-48718952710364alexis.duncan32@icloud.com2572 Union StSan DiegoCalifornia92170···UNKNOWNMEDICARE-ADV-B··
TPATPA-571062026-01-31T21:49:09ZLinda—Little1986-10-25—UNKNOWN3698256935—7194 Main StDENVERCO80220N/AMEDICARE-ADV-B
TPATPA-58835 2026-02-13T04:51:35ZMARK····LEEWIS06/14/95UHC-34718-55—nullUNKNOWN1859 INDIAN SCHOOL RDAustinTX78766GRP-1050—
TPATPA-574452026-09-10T20:53:50ZMATTHEW—·GREEN19930916NULL—NULL—1531 OAK STGilbert··AZ··85291NULL·-
TPATPA-632732026-03-12T11:40:13Z·CHRISTINE··PHILLIPS1989-02-18———N/A·-——-··SELECT-EPO
TPATPA-563872026-08-10T05:32:11ZLittle, George——03/14/2001null··•••-••-7622——9260 CEDAR LANEOrlandoFL32841·GRP-7540null
TPATPA-502712026-03-04T07:29:31ZKENNETH—DUNN1950-03-15——NULL··kenneth.dunn50@hotmail.com345 HARBOR BLVDATLANTAGA30390GRP-4581-
TPATPA-631652026-05-22T07:24:58ZChapman, Donald—··08/09/03——4353948718UNKNOWN58 PALM DRIVELas VegasNV89145GRP-1216UNKNOWN
TPATPA-545402026-02-27T04:07:50ZJeremy—Cook1948-08-19UNKNOWNNULL505-571-5690··jeremy.cook@proton.me7234 Indian School RoadCOLUMBUSOhio·43239NULLCORE-HMO
TPATPA-541622026-02-24T00:34:56ZJESSICA····BEENNETT1991-05-02N/A····—-5439 Camelback RoadDenverCO80206··GRP-1083—
TPATPA-63710 2026-05-28T14:17:46ZDENIEL—MEJIA1965-07-17·UHC1815342null876.642.0344-7763 Ocean Ave #518ColumbusOH43222——
TPATPA-565032026-05-12T00:31:22ZSimmons, Michael——10-03-2001—-(772) 862-9963NULL4812 Canyon RoadLas VegasNV89194nullUNKNOWN
TPATPA-535532026-09-27T07:43:03ZCHRISTOPHER··HENDERSON1952-06-11N/A—NULLCHRISTOPHER.HENDERSON28@PROTON.ME1971 Meadow LnLos AngelesCA90052-9718—SELECT-EPO
TPATPA-579962026-04-17T13:26:29ZMark—Miller03-10-1956UNKNOWNUNKNOWN—-9082 Hillcrest RdPhoenixAZ85045··UNKNOWNnull
TPATPA-573802026-06-25T09:39:41ZMarkY.Sandoval··2006-03-22NULLN/A—MARK.SANDOVAL10@ICLOUD.COM6181 Mountain View DrHoustonTX77048N/ASELECT-EPO
TPATPA-583482026-04-07T12:36:35ZJack—Boyd1950-58-01··-—-—1043 Washington StreetColumbusOH··43269—-
TPATPA-564052026-03-05T23:29:02Zmateo··—perez20030114—•••-••-6138—N/A2630 Maple AveTampaFL33636GRP-7687—
TPATPA-533252026-01-20T11:37:53ZJUDITH—BOYD1968-05-15UHC-46308-61—NULL··—9713 DESERT SKY BLVDCHARLOTTEnc28258UNKNOWNN/A
TPATPA-535942026-03-08T09:03:05ZAna—Richards2001-02-07-NULLUNKNOWN—6758 GRAND AVENUE #689SeattleWA98131-MEDICARE-ADV-A
TPATPA-587162026-05-14T13:34:44ZEthan—Kelley2005-07-03N/A—null—NULLUNKNOWNnull—GRP-8380N/A
TPATPA-510902026-04-05T05:12:17ZAmanda—McDonald1959-05-10——nullAMANDA.MCDONALD@GMAIL.COM2036 Indian School RdSeattle··WA98106-OPTIONS-PPO
TPATPA-596302026-04-12T07:29:12ZSandra—Stevens1963-08-22····—null—··UNKNOWNNULL—null·CHOICE-PLUS-PPO
TPATPA-570122026-09-06T13:28:08ZChristian—Carter19640617—•••-••-7360N/AN/A2175 SPRING STREETTUCSONAZ85720·GRP-1161null
TPATPA-616832026-03-19T03:16:12Z·CarolDKingDec 6, 1980NULLUNKNOWN622-656-3870CAROL.KING43@PROTON.ME4013 Union StreetNashvilleTN37285—-
TPATPA-569942026-05-28T15:50:08Z·DIANEA.HUNTER01/01/63—UNKNOWN898-377-4826diane.hunter@icloud.com8372 Lake View RoadPlanoTX75012··-OPTIONS-PPO
TPATPA-531592026-05-27T22:42:07ZBOBBY—ROSE2003-06-22UHC-53186-56-573-639-6353bobby.rose@yahoo.com3038 INDIAN SCHOOL ROADSeattleWashington98146nullnull··
TPATPA-559162026-02-18T14:57:14ZHelen—Luna1977-05-07nullN/ANULLhelen.luna@outlook.com—UNKNOWN——NULLN/A
14,474 rows, page 79 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:40.610Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty