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-514352026-06-09T21:02:51ZGREG—ROMERO11/23/1958—UNKNOWN2668921gregory.romero@gmail.comNULL-UNKNOWN-—NULL
TPATPA-575062026-03-02T20:00:14ZRoger—Robinson1941-10-09N/A--roger.robinson@gmail.com825 Harbor BlvdEDEN PRAIRIEMN55394-CORE-HMO
TPATPA-528412026-05-31T00:10:37ZBrian—Guerrero2003-07-22UHC-77891-89NULL(776) 824-8278null··1517 APACHE BLVDHoustontx77038N/AN/A
TPATPA-633712026-08-25T09:03:15Z Helen—Ellis2008-02-12N/A—·638-970-3302N/A·2899 BroadwayDenverCO80259—·NAVIGATE-HMO
TPATPA-544262026-03-16T08:40:17ZWallace, Eugene T.——1967-02-06—null13775827333null804 Grand AvenueCharlotteNC28291——
TPA TPA-520622026-05-02T13:04:44ZASHLEY—BLACK1941-07-20·null-—ashley.black@hotmail.com4377 Camelback RoadEden PrairieMN·55386GRP-4825UNKNOWN
TPA TPA-637282026-10-10T11:53:52Z ·ANGALA—HUGHES09/03/1940UNKNOWN-(252) 577-8024—7322 Church StreetHoustonTX77075N/ANULL
TPATPA-619062026-09-22T10:21:26ZAhmed—Vega1953-09-25UNKNOWN—(977) 360-0860null5743 BAYSHORE DRIVE #530ScottsdaleAZ85245GRP-8683—
TPATPA-613722026-07-26T01:29:32ZGeorge—Walker1972-09-24-·UNKNOWN—N/Anull—··—UNKNOWNnavigate-hmo
TPATPA-600162026-07-30T06:28:13Z·Ferguson, Natalie——1942-05-16N/A··—null—8350 HILLCREST ROADTempeAZ85206GRP-6708select-epo
TPATPA-618002026-01-23T09:41:09ZEmma—Rios2004-03-22UHC-29326-42··UNKNOWNNULL-124 Ridge RoadSAN DIEGO·CA92177-6923GRP-3967NULL
TPATPA-565902026-07-06T08:28:52ZBrenda—Reed02/24/1974NULL····——3928 HILLCREST ROADEden PrairieMN55320GRP-9981null
TPATPA-633402026-02-25T14:02:55ZJudith—Delgado1972-05-25··null-··—UNKNOWNUNKNOWNnullUNKNOWNN/AGRP-2358·SELECT-EPO
TPATPA-577892026-01-21T18:09:10ZWayne—CarterJan 27, 1991····—-WAYNE.CARTER@OUTLOOK.COM473 FOREST AVENUEPlanoTexas75038—UNKNOWN
TPATPA-554432026-07-23T00:50:31ZAnn—Morales1982-03-06···-··—ann.morales55@aol.com3142 Park PlaceAustinTX78773····—
TPATPA-504642026-09-27T04:08:58ZJanet—Gibson8/4/1966-•••-••-7430—janet.gibson@gmail.com8053 MESA DRJacksonvilleFloridaN/AGRP-2761··
TPATPA-589212026-05-14T20:35:27Z·Susan, Jackson—··10-02-1985—•••-••-7588574.899.3895—1342 Mountain View Drive··MESAAZ85280GRP-4996N/A
TPATPA-593542026-09-09T04:21:53ZRANDYL.LAWRENCE1020-15-92——null··9077 Oak StLas VegasNV89131-4486—N/A
TPATPA-634012026-02-28T00:31:47ZJUAN····BURKE1960-06-11UNKNOWN····nullN/A2760 Spring StMIAMI·FL33106—CORE-HMO
TPATPA-534542026-03-24T07:15:39ZVega, Ahmed——May 16, 1991-N/A·null—1975 JEFFERSON AVE #484San DiegoCA92114-8745GRP-5712-
TPATPA-513292026-09-25T10:14:03ZNicholas—Mejia2003-02-11-N/A878-337-6786nicholas.mejia14@gmail.com····-—-GRP-3664-
TPATPA-635062026-05-26T13:32:11ZCHRISTIAN—HANSEN1941-01-12UHC-24650-36•••-••-4667·7973150547-5586 CHURCH STREETGLENDALEAZ85367··-UNKNOWN
TPATPA-502682026-06-22T03:30:19ZLisa—Fernandez1994-08-02—UNKNOWN(439) 764-4733lisa.fernandez85@outlook.com6537 Lake View RoadNashville··TN37219-7868GRP-6151—
TPATPA-520092026-04-16T08:41:29Zandrew—arnold1988-09-26NULL-NULLANDREW.ARNOLD38@PROTON.ME3704 Spring StreetTampaFL33606nullnull··
TPA TPA-586862026-02-08T00:02:49ZLori—Murray19260119—-—-183 Harbor BoulevardSan AntonioTX—GRP-4789N/A
TPATPA-533292026-04-30T00:55:42Z Beverly—HarrisMar 3, 2002··N/A•••-••-2331291-975-4979null··1868 FOREST AVEMiamiFL33199nullchoice-plus-ppo
TPATPA-588572026-02-01T16:31:18ZReynolds, Kimberly——10-06-1996N/AN/A-kimberly.reynolds@proton.me5724 ELM ST·AustinTX78741N/A··OPTIONS-PPO
TPATPA-538462026-05-01T05:08:26Zkenneth—evans1972-06-04—•••-••-5446N/A··7384 HARBOR BLVDHoustontx77045—NAVIGATE-HMO
TPATPA-563832026-06-29T18:25:29ZDavid—Simmons1959-08-06UNKNOWN•••-••-1300(615) 211-7638david.simmons90@aol.com1491 LAKE VIEW RD #546FresnoCA·93713NULLN/A··
TPATPA-540192026-08-16T11:33:01ZDouglas—Harris1941-12-09-•••-••-2372906.993.7845DOUGLAS.HARRIS@ICLOUD.COM5994 Church StFresnoCA93781-1054GRP-9796··—
TPATPA-594572026-09-09T22:52:48ZMEGAN—BEERRY1943-10-26—UNKNOWNnull····6422 Highland AveSacramento··CANULLUNKNOWNCHOICE-PLUS-PPO
TPATPA-560522026-08-15T17:11:58Z·Estrada, CatherineB—03-11-1985UHC-58863-99•••-••-5652N/A—2694 Canyon RdLos AngelesCA90063—N/A
TPATPA-639132026-07-07T21:31:15ZBrianO.Fox05/21/1940-•••-••-81105779045222null4990 Highland AveDenverCO80230N/A—
TPATPA-539462026-07-18T22:10:08ZALAN····ORTIZ2008-07-18UNKNOWN——UNKNOWN—nullUNKNOWNnullGRP-1874NAVIGATE-HMO
TPATPA-574942026-05-17T18:16:12ZROY—EDWARDS··11/25/44UNKNOWN•••-••-6550533-332-1153—9892 Apache BoulevardAtlantaGA30308UNKNOWNnull
TPATPA-640462026-03-14T13:16:52ZEdwadr—Santos10/27/1980NULL•••-••-4173+1 879 511 6092—7324 River RoadCharlotteNC28249NULLNULL
TPATPA-620762026-02-16T19:19:20ZLopez, Karen——01/05/1992—NULLN/Anull··—NULLN/A-—-
TPATPA-563772026-01-02T20:38:20ZMattX.Kelly1941-12-05·nullUNKNOWN367-569-1046———NULLNULL—CHOICE-PLUS-PPO
TPATPA-617712026-10-09T04:37:58Zkayla—gomez28-10-2007UHC-51906-01—9705218394NULL··UNKNOWNN/A——GRP-1809UNKNOWN
TPATPA-578532026-07-26T05:44:10Zaaron—jenssen1969-05-08N/A•••-••-2069—aaron.jensen11@gmail.com5197 Baseline RoadSCOTTSDALEAZ85227-OPTIONS-PPO
TPATPA-596742026-08-18T16:50:15ZJuan—Morrison06/03/42NULLUNKNOWN(882) 393-7301juan.morrison43@aol.com917 Cedar Ln··JacksonvilleFL32263GRP-7984MEDICARE-ADV-A
TPATPA-52526 2026-03-11T18:16:56ZChristine—Elliott03/08/56-—UNKNOWNchristine.elliott@gmail.com2209 HILLCREST RDCharlotteNC—UNKNOWN-
TPATPA-567562026-09-21T12:39:29ZBobby—Chapman1998-07-14NULL•••-••-4809619-908-3428BOBBY.CHAPMAN12@GMAIL.COM3244 Central AveSan DiegoCA92182GRP-1118SELECT-EPO
TPATPA-634642026-03-29T04:05:12ZEric—Harris1989-03-15NULL—903-772-0571eric.harris88@proton.me·2516 Ridge RoadLos AngelesCA90064GRP-3746UNKNOWN
TPATPA-568352026-08-08T06:09:54ZRuth—Hall9/24/1968—UNKNOWN272-295-7547null470 APACHE BLVDColumbusOhio43290GRP-3148—
TPATPA-624212026-04-11T11:03:14ZJAMESVHUNT25-06-1968————9300 BroadwayEden Prairie··MN55394N/A—
TPATPA-526742026-08-02T08:11:31Z Donald—Luna1955-01-09N/A-—UNKNOWN8713 Main StScottsdaleAZ85205-9410—N/A
TPATPA-578942026-04-18T05:01:08ZRyan—Wright20-03-1953··NULLNULL-—NULLnullN/Anull—CHOICE-PLUS-PPO
TPATPA-527742026-03-09T01:56:33ZNancy—Hoffman06/23/1945·UHC-67490-98•••-••-8498-—·4284 Grand AvenuePhoenixAZ85062-9977NULLN/A
TPATPA-520492026-06-30T13:15:23ZASHLEY··—GORDON1983-11-11—null5797996732··—3599 Park PlaceGLENDALEArizona85364—N/A
14,474 rows, page 46 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.458Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty