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-514992026-06-29T00:11:27ZEthan—·Arnold2005-02-01——16176874926—1015 Oak Street Apt 21Gilbert··AZ85286-null
TPA TPA-544702026-08-18T11:31:16Z Brian—Luna1995-05-26NULL•••-••-8965-··BRIAN.LUNA@PROTON.ME40 MAPLE AVETempeAZ85259····N/A
TPATPA-528652026-02-04T11:44:00ZJordanV.Garcia4/26/1983—·null598-990-9297N/A8139 Harbor BlvdChandleraz·85267NULLnull
TPATPA-617462026-07-10T04:15:55ZBRADLEYBPADILLA1961-04-03UHC1243931NULL-—2055 Mesa Dr···TempeAZ85206-··CORE-HMO
TPATPA-533122026-09-15T21:21:11ZBruce—Sanchez1966-12-13uhc-67947-39-UNKNOWNUNKNOWN9891 Highland Ave #771TempeAZ85216-··
TPATPA-559732026-02-19T13:34:35ZSTEVE—HANSEN1985-08-18——(519) 445-7155stephen.hansen@aol.com3118 Sunset BlvdNashvilleTennessee37256-—
TPATPA-508142026-08-10T07:33:53ZGary—Walker1999-02-04N/ANULL(785) 304-5209N/A6703 Cedar Ln Apt 19··San DiegoCalifornia92189UNKNOWNUNKNOWN
TPATPA-541112026-07-15T00:56:58ZJimenez, Mariana——1965-07-21null•••-••-7503——4008 Church StMIAMIFLnullGRP-9717-
TPATPA-591172026-06-25T21:42:40ZChristina—Nichols0273-19-61·-•••-••-2337——749 FOREST AVENUE··FresnoCA93749-6008GRP-6126choice-plus-ppo
TPATPA-506012026-04-03T10:40:00ZMASON—GUZMAN1965-07-26·NULL•••-••-0428—-9687 Oak StreetMiamiFL33166—·null
TPATPA-536272026-07-26T23:00:11ZJerry—King09/23/83-·N/A—N/A2993 Ocean AvenueTampaFL33632null—
TPATPA-588622026-04-29T06:09:51ZAshley—Park19840325nullN/A—ashley.park@icloud.com5422 MEADOW LNMiamiFL33129—NULL
TPATPA-639182026-03-08T17:48:05ZBRITTANY··——1/8/1968N/A··—N/AUNKNOWNnullUNKNOWN——CHOICE-PLUS-PPO
TPATPA-565862026-09-16T15:47:11ZAndrewY·Carlson1979-02-07··N/A•••-••-3530UNKNOWN—·1592 Ridge RoadLos Angeles·CA90074——
TPATPA-578842026-09-09T03:55:10ZRaymond—Palmer1983-06-22—nullNULL—4428 Church StreetFresnoCA93775—MEDICARE-ADV-A
TPATPA-626632026-07-19T08:28:58ZAustinWAllen1993-03-24-NULL+1 399 360 4770N/A2083 Cedar LnPhoenixArizona85079UNKNOWN—
TPA TPA-624522026-07-24T18:38:34ZDeniseL.Hughes1997-09-03—NULLnullNULL8318 CENTRAL AVE··DENVERColorado80219GRP-2245NULL
TPATPA-633802026-09-03T09:42:24ZPamela····WallaceMar 20, 1988—•••-••-1069—-8337 Bayshore DriveTEMPEAZ85298GRP-7275··—
TPATPA-562392026-02-26T04:31:15ZAna—WillisMar 6, 1954N/Anull——7807 APACHE BOULEVARD··ChandlerAZ85210N/A—
TPATPA-547732026-05-12T08:26:43Z Reid, Danielle——1999-03-23NULL•••-••-19015329108310—1276 BASELINE ROADSeattleWAnullUNKNOWNnull
TPATPA-522212026-03-16T05:56:42ZJOYCE—RIEC1943-05-25UNKNOWN-NULL—2028 Baseline RoadMesaAZ85273··NULL-
TPATPA-596132026-08-20T13:22:47ZPaul—Welch6/6/1951-•••-••-8294··UNKNOWN1850 Park PlacePhoenixAZ85071GRP-4623NULL
TPATPA-536842026-03-02T07:41:10ZJackie—Grant12/02/78UHC-43018-83—UNKNOWN-925 Indian School RoadMinneapolis··MN55418UNKNOWNUNKNOWN
TPA TPA-551202026-04-20T14:04:22ZlawrencceE.mejia9164-12-23nullnullUNKNOWNNULL8170 CHURCH STTucsonAZ85727N/AOPTIONS-PPO
TPATPA-507482026-09-14T23:33:32ZJacob—Diaz··1951-10-15N/A—2629357695NULL37 Camelback RdGlendaleArizona··85327UNKNOWNN/A
TPATPA-582512026-04-17T23:14:35ZCHRISTIAN—JAMES1977-10-08UHC-82723-91•••-••-7666N/AUNKNOWN··9378 Oak StTempeAZ85242-4156-NULL
TPATPA-607732026-01-24T18:55:18Zangela····wells1985-07-25NULLN/AUNKNOWN-2563 PINE DRIVE Apt 6FresnoCA93715NULLNAVIGATE-HMO
TPATPA-547672026-02-16T14:22:32ZWatkins, Dennis··——Mar 20, 1951null•••-••-1435NULLdennis.watkins@yahoo.com7949 JEFFERSON AVENUESan Diego··California92197——
TPATPA-644532026-09-27T18:54:08Zryan—stephens1975-11-12nullNULLN/ANULL——UNKNOWN·NULL—NULL
TPATPA-635902026-08-28T19:59:00ZSEAN—NGUYENJun 6, 1944—NULLNULL—6330 OAK ST Apt 33DALLAS··TX75262-UNKNOWN
TPATPA-570582026-07-03T08:42:10Z Reed, Frances——1990-02-14N/A•••-••-1390NULL——NULL--GRP-6253CORE-HMO
TPATPA-574442026-02-21T15:00:10ZMatthew—Green1993-09-16——nullnull1531 Oak StGilbertAZNULLN/A·CORE-HMO
TPATPA-517212026-01-31T16:18:30ZBryan—·Moreno1978-07-28UNKNOWNUNKNOWNN/Anull212 WASHINGTON STSan DiegoCA92115UNKNOWNSELECT-EPO
TPATPA-539052026-06-14T08:58:14ZHall, Melissa——09/23/1949null•••-••-8404-melissa.hall@aol.com3608 MAPLE AVENUEMiamiflUNKNOWNGRP-0924OPTIONS-PPO
TPATPA-635122026-10-09T01:19:04ZSUSAN—LARSON24-04-1966UHC-58072-95•••-••-1891940-783-8231—8213 Indian School Road·OrlandoFL32859N/AN/A
TPATPA-599862026-04-13T16:11:53ZTerry—West1982-11-25UNKNOWN•••-••-46697538299365·terry.west53@yahoo.com4900 Church StLOS ANGELESCA90086UNKNOWNMEDICARE-ADV-B
TPATPA-606462026-08-26T21:00:40ZWalker—Cmaila1941-01-22UHC-86910-95··———·7503 Elm StSan Antonio··TX78266nullMEDICARE-ADV-B
TPA TPA-605152026-05-02T14:12:33ZStephenZ.Ellis1973-08-25UNKNOWN··•••-••-0016568-240-6552STEPHEN.ELLIS51@OUTLOOK.COM157 Harbor BlvdLos AngelesCA90083—null
TPATPA-565252026-06-03T17:37:01ZJohn—Henry··1944-01-19—•••-••-8813—NULL-NULLN/A··UNKNOWN——
TPATPA-540652026-07-19T11:06:06ZKATHRYN—NICHOLS1961-11-13NULL•••-••-6474(851) 704-2478··—9702 Main St #228TAMPAFlorida33604NULL····
TPATPA-573822026-07-14T08:46:25ZAisha—Bailey·1993-03-09—•••-••-4405N/AN/A2687 Camelback RoadTampaFL33615GRP-5125—
TPA TPA-516282026-01-27T12:39:50ZWiillieW.·Phillips1991-11-15———--—N/AnullGRP-2445NULL··
TPATPA-632002026-08-24T19:13:59ZRandyI.Matthews1981-08-02UHC-28402-87NULL—NULL6547 Willow CtEden Prairie··MN55319-4173—N/A
TPA TPA-61443 2026-08-27T00:42:56ZDiana··CasttroSep 25, 1971—--diana.castro@icloud.com2883 Market StreetTampaFL33628-3955·GRP-3477null
TPATPA-612882026-04-24T04:02:55ZPAUL—RICHARDS0141-19-67··UHC-65191-83UNKNOWN—paul.richards@outlook.com5432 PINE DRLas VegasNV89141nullMEDICARE-ADV-A
TPATPA-591372026-08-07T03:30:49ZSeanN.Chapman14-02-2002UHC-35561-40——null6702 Church StMinneapolis··MN55483GRP-0949—
TPATPA-625432026-07-17T17:38:33ZAthur—Rivea·1966-04-15UNKNOWN-··(974) 946-6383arthur.rivera45@proton.meNULLNULL——GRP-0177—
TPATPA-543772026-03-09T23:43:46ZCYNTHIAO—1978-03-06NULL—(786) 777-4387—·4353 WASHINGTON STREETPhoenixAZ85043—-
TPATPA-608392026-08-15T21:25:04ZCynthia—BowmanMar 14, 1956N/A•••-••-68846612601445cynthia.bowman32@proton.me5228 MARKET STSan DiegoCA92123——
TPATPA-560212026-06-21T01:56:34ZPRIYA—WILLIAMS2001-04-12—NULL——7123 OCEAN AVENUEGlendaleAZ85372UNKNOWN—
14,474 rows, page 203 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:53.739Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty