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-542102026-01-05T07:07:28ZGarza, Justin——19500524UHC-03693-68—N/A—3979 Park PlaceColumbusOH43216--
TPATPA-517532026-05-25T07:44:10ZSOPHIA—DIXON2005-06-24N/ANULL804-585-1953—6679 MAIN STREETGLENDALEAZ85349GRP-7580MEDICARE-ADV-B
TPATPA-626062026-01-12T23:06:47ZVictoria—Coleman1979-06-14-··•••-••-5615nullvictoria.coleman46@icloud.com——NULL—GRP-5141—
TPATPA-617452026-09-29T02:00:12ZVICTORIA—HILL19740505—•••-••-11164052098436victoria.hill34@outlook.com7117 Pine Drive Apt 11PhoenixAZ85036-3602··N/AOPTIONS-PPO
TPATPA-575572026-09-28T22:07:18Z TIMOTHY····WONG0808-19-56UNKNOWN•••-••-0126683.410.9706··N/A3169 Camelback RoadFresnoCA93793nullNULL
TPATPA-526052026-07-13T12:49:56ZANDREA—WASHINGTON1981-01-01—null—NULL912 PALM DRIVECharlotte··NC28285GRP-5022UNKNOWN
TPATPA-51836 2026-03-30T10:17:23ZJANET—ROSS2007-08-11NULL—null-4119 Bayshore DriveCharlotteNC28251GRP-5499N/A
TPATPA-576272026-09-03T19:04:55ZScott—Gonzales1994-01-25—•••-••-56104427706629-7746 Pine DriveTAMPAFL33642GRP-3992MEDICARE-ADV-A
TPATPA-576532026-02-11T20:46:05ZKEITHGFORD1947-04-21——null····6215 Central AvenueORLANDOFL32811-MEDICARE-ADV-A
TPATPA-558702026-07-20T10:29:27ZBRUCE—MURRAY19941011UHC-95825-79—+1 289 307 2986————N/A—null
TPATPA-596932026-04-20T14:19:49ZParker—Gerld··07/26/53UHC-73850-59NULL+1 549 796 1253gerald.parker@aol.com4446 Forest AvenueDallasTX75237N/AUNKNOWN
TPATPA-555932026-07-14T23:21:15ZSARAH—SALAZAR02/17/1955——(561) 464-3570—4834 BASELINE RDCharlotteNC28243—-
TPATPA-574642026-03-24T22:00:53ZANTHONY—GARCIA6/19/2008—N/A—UNKNOWN·1099 Baseline RdDenverCO80282GRP-9493MEDICARE-ADV-B
TPATPA-603292026-01-21T19:13:59ZDiego—Fields19580517·NULL•••-••-35378506646040DIEGO.FIELDS@HOTMAIL.COM7626 Union StLOS ANGELESCA90092NULLnull
TPATPA-582812026-01-21T10:29:52ZGarrett, Ann——1/19/1977-•••-••-8673N/A··6583 Oak StHoustonTX——NULL
TPATPA-553222026-08-06T01:03:54ZGrace—Sandoval1986-09-25N/AUNKNOWNUNKNOWN-9578 Camelback RoadColumbusOH43245—SELECT-EPO
TPATPA-578642026-06-27T18:14:09ZAMY—FERGUSON1944-01-22··—12068895002-NULL——UNKNOWNnull-··
TPATPA-537932026-05-11T06:23:12ZAmanda····Colle1965-07-03N/A—N/AUNKNOWN4164 BroadwaySacramentoCA95819GRP-2892MEDICARE-ADV-B
TPATPA-552512026-07-10T04:06:43Z·Kenneth—Kim12-06-1977NULL—·nullNULL—····-—UNKNOWN-
TPATPA-541632026-03-21T08:28:45Zjessica—bennett1991-05-02—•••-••-2361NULLJESSICA.BENNETT@AOL.COM5439 CAMELBACK RDDenverColorado80206UNKNOWN-
TPATPA-629142026-03-20T05:39:58Zmarcus—turner·1939-12-12··NULL—··8916 PALM DRIVE·San AntonioTX78257GRP-0980OPTIONS-PPO
TPATPA-626652026-03-12T09:07:22ZMargaret—Bradey1966-09-13-NULL——2445 Spring StreetGlendaleAZ85314GRP-0483··NULL
TPATPA-544712026-07-14T02:30:22ZDanielle—Bell1959-12-08N/A—UNKNOWNnull7586 Spring StreetOrlandoFL32807-8800GRP-2091—
TPATPA-535172026-03-08T18:20:22Z·Charles—Burton1975-07-25N/A•••-••-2710nullcharles.burton12@aol.com—-—·-GRP-2740MEDICARE-ADV-A
TPATPA-535452026-09-19T03:05:27ZMegan····Henry1944-01-14UNKNOWN—NULL—4325 Hillcrest RdLas VegasNevada··89153-2084null—
TPATPA-559562026-06-02T11:45:29ZJesse—Pierce1947-07-27-··•••-••-86059144228848—4125 CANYON ROADTucsonAZ85703—-
TPATPA-532022026-06-28T01:20:57Z PAUL—FOSTER1983-02-05-•••-••-7058+1 816 310 3032—4047 Washington St··SAN ANTONIOTX78240GRP-9067MEDICARE-ADV-B
TPATPA-51878 2026-06-18T22:53:41ZCAMILA—DALGADO6/5/1975N/A-889-625-1986··CAMILA.DELGADO@PROTON.ME4527 Desert Sky BlvdGlendale··AZ·85301—··
TPA TPA-500562026-04-02T01:07:20ZLaura—Chapman1985-07-01UNKNOWNN/ANULL··2392 River RdFresnoCA··93701—MEDICARE-ADV-A
TPATPA-585552026-01-04T04:26:20ZJULIA—LE1972-12-15null—(278) 940-4205·JULIA.LE70@PROTON.ME9364 Market St #125TucsonAZ85750—·UNKNOWN
TPATPA-582252026-02-11T13:04:49ZCYNTHIA—ALLEN1997-05-24—•••-••-3879(630) 211-1076N/A9695 SUNSET BOULEVARDEden PrairieMN··55397GRP-0972null
TPATPA-504692026-02-11T18:15:16ZGEORGE—HUNTMay 18, 2004UNKNOWN•••-••-9436N/A-567 Central AveSan DiegoCA92168N/ACHOICE-PLUS-PPO
TPATPA-52829 2026-09-06T09:52:24ZJessica—Andraws1975-11-03——-—8940 MEADOW LN Apt 11Las VegasNV··89107nullMEDICARE-ADV-B
TPA TPA-542222026-06-20T23:32:23ZDenise—Clark1980-09-13NULLUNKNOWN—-1767 Pine DrColumbusOH43288-1919NULLnull
TPATPA-622142026-04-19T02:35:09ZHiroshiAMoore19500908UNKNOWNNULLN/A-952 Union Street #246GlendaleAZ85388N/AMEDICARE-ADV-B
TPATPA-508312026-10-06T04:42:48ZSFOIAPJONS1996-10-20——12274115717UNKNOWN8631 SPRING STREETMiamiFL33139·GRP-6763—
TPATPA-631822026-09-24T11:02:35ZLauren—Sullivan08-07-1938N/AUNKNOWN—NULL1058 Spring St #265MiamiFL33158—MEDICARE-ADV-B
TPATPA-536752026-10-10T01:01:47ZRobnson, Joe——1941-10-27N/A•••-••-0419+1 263 410 6889NULL5475 Lake View RdJacksonvilleFL32290—-
TPATPA-58943 2026-04-21T23:10:11ZRachel—Palmer1964-11-16—•••-••-2767——6979 Lake View RdNashvilleTN·37204UNKNOWN—
TPATPA-641892026-06-06T05:34:15Z·DIANA—MENDEZ··1939-03-19-NULL(318) 301-3203diana.mendez@outlook.com4576 Canyon RoadSacramentoCA95815GRP-4666—
TPATPA-616732026-10-03T15:59:16ZRios, Kevin——19850320··null—248-201-6127—-NULL———NAVIGATE-HMO
TPATPA-50852 2026-05-25T02:10:37ZWALTER—PALMER19791215N/AUNKNOWN··799-749-6707····——NULLN/Anull—
TPATPA-548272026-07-05T10:17:22ZMatthew—Harper11/8/1987UHC-68492-17--—1568 Central AveGILBERTAZ85224GRP-8757···MEDICARE-ADV-A
TPATPA-540242026-10-18T21:14:15Z·Phillips, Joan——04/28/45··NULL—682-682-9052-1773 Mesa DrAustintx78782-8178—MEDICARE-ADV-A
TPATPA-593892026-02-09T03:14:55ZAlan—Lynch1993-06-03··N/A•••-••-3315·N/AN/A-NULL-null—NULL
TPATPA-601772026-06-22T22:41:17ZRYANU.SOTO··2002-11-11··UNKNOWN•••-••-8728-N/A8891 UNION STTempeAZ85233·GRP-0921null
TPATPA-505192026-05-30T12:08:40ZDaniel—Carroll1951-02-04null—279.542.4672null5784 Highland AvenueHOUSTONTX77002N/A-
TPATPA-611372026-07-05T08:59:15ZJohnston, Matthew——1963-11-09——NULL—N/A··NULLNULLNULLN/A····
TPATPA-54258 2026-02-12T05:05:00Zjustin—vargas2004-09-15UHC-10790-41•••-••-9180——N/AUNKNOWNN/A-····NULL
TPA TPA-514752026-03-18T07:21:19ZBrianP.Allen··1951-05-13UNKNOWN—2622348559UNKNOWN9215 LINCOLN WAYAUSTINTX78736GRP-7803MEDICARE-ADV-A
14,474 rows, page 5 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-19T19:54:25.420Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty