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-545622026-04-18T12:23:34ZANNAC··DUNN5/15/1979—null12574782374—N/A—NULL—nullN/A··
TPATPA-626812026-09-10T15:36:50ZJOE··—PERRY··1940-12-09-•••-••-9224NULLjoe.perry@icloud.com4480 Willow CourtDenverCOUNKNOWNN/ASELECT-EPO
TPATPA-563492026-10-09T16:06:49ZASHLEY—RIOS1/1/1975--—null4034 Ridge Rd #268San DiegoCalifornia92144GRP-1637CHOICE-PLUS-PPO
TPATPA-639082026-04-13T15:59:53ZDYLAN—CARLSNO1946-10-01-•••-••-4155—····1363 BASELINE RD Apt 40Atlanta··GAN/ANULLNULL
TPATPA-581662026-05-18T05:05:44ZBobby··—Franklin2008-09-04—NULLNULL-3777 Cedar LnMesaAZ85268——
TPATPA-602102026-10-10T14:18:42Z JudithQ.Hicks26-05-1972null······UNKNOWNN/A7709 Desert Sky Boulevard·SACRAMENTOCA95801-MEDICARE-ADV-B
TPA TPA-609902026-05-27T09:53:17ZDianeFFlores1957-03-20-•••-••-15859679281052UNKNOWN563 MARKET ST #928··PlanoTX75041··nullSELECT-EPO
TPATPA-529952026-07-14T15:19:56ZMelissa—Fox1979-01-22··—•••-••-2705UNKNOWNnull4095 Valley View DrHOUSTONTX77061NULLCORE-HMO
TPATPA-568222026-01-11T07:14:43ZRyan—Pena2001-06-09··N/ANULL(730) 856-9872N/A4274 Washington Street··Los Angeles·CA90057GRP-8316MEDICARE-ADV-B
TPATPA-534042026-06-12T03:34:45ZRONALD—MOORE19950108nullnull8289544ronald.moore@proton.me2050 PALM DRFresnoCA93799GRP-6517NAVIGATE-HMO
TPATPA-541382026-09-03T00:58:16ZAngela—Wang1967-03-01—•••-••-6590UNKNOWNangela.wang6@outlook.com8641 VALLEY VIEW DR··OrlandoFL32887··NULL··null
TPATPA-576052026-05-06T23:49:30ZmadisonCbrooks1958-05-25—•••-••-9040—UNKNOWN3536 Palm DriveSan DiegoCA92133UNKNOWNMEDICARE-ADV-B
TPATPA-620222026-02-13T14:07:22ZOLIVIA—MEDINA7/12/1968—-—N/A9683 Canyon RdOrlandoFL··32802N/A—
TPATPA-526862026-07-24T16:36:46ZEugene—Hendreson··1985-03-10null-(487) 583-3046-6761 RIDGE RDTucsonAZ85770NULL—
TPATPA-577902026-09-13T22:35:33ZDavis, Logan—····1977-12-22-•••-••-9097——6326 WASHINGTON STMESAAZ··85237-NULL
TPATPA-600122026-08-16T03:45:06ZDaniels, Carlos··—11/6/1974N/A•••-••-7245UNKNOWNUNKNOWN·4075 Maple AvenueDenverCO80206—N/A
TPATPA-62407 2026-08-25T15:32:33ZHeather····Herrera08/21/1969—N/A902-686-8882UNKNOWN9711 Indian School RdCharlotteNC28270GRP-4557MEDICARE-ADV-A
TPATPA-512812026-08-09T14:40:14ZJohnWYoung1955-02-28··—NULL673-520-1642N/A··4204 Ridge RoadColumbusOH·43204GRP-6165·MEDICARE-ADV-A
TPATPA-53516 2026-02-01T17:16:01ZBEVERLY—GONZALES1944-03-03—NULL··-beverly.gonzales@icloud.com7684 HARBOR BLVDColumbus··OH43247-1840GRP-9978-
TPATPA-564362026-10-15T06:05:07ZMichelle—Martin·1959-02-08—N/A—NULL7357 MAPLE AVENUEMinneapolisMN55426nullnull
TPATPA-636802026-03-28T15:56:29ZJACQUELINE—ROJAS1950-04-05N/A•••-••-0202NULL—4836 Main StreetSACRAMENTOCA95824UNKNOWNMEDICARE-ADV-B
TPATPA-525362026-04-29T15:14:56Z SARA—SANTOS1974-01-28N/A·-—N/A3763 BroadwayLos AngelesCA90091—-
TPATPA-614072026-04-15T19:35:40Znathan—·martinez1945-12-01··—·null3559719683null3649 Central Ave·Los AngelesCA90099GRP-9964OPTIONS-PPO
TPATPA-585682026-09-01T19:14:11ZNICOLEIBARNES1993-01-26nullNULL·-N/A480 Washington StreetNASHVILLE·TN·37288NULLCORE-HMO
TPATPA-599222026-01-28T14:33:54ZKaylaB.Contreras11/11/96NULL—····UNKNOWN1305 Sunset BlvdScottsdaleAZ85281N/A—
TPATPA-615522026-01-20T13:54:39ZKelly··Carlson1980-07-03—•••-••-2736(560) 947-6747kelly.carlson@aol.com·4379 PALM DRJacksonvilleFL32281GRP-1052NULL
TPATPA-556812026-05-15T13:09:56ZLucia—Brown1972-06-26-—(234) 745-0563-5327 MAPLE AVEHouston·TX77092GRP-9113MEDICARE-ADV-B
TPATPA-632692026-08-31T12:55:37Zdenise··pena··1998-08-10—•••-••-8320NULLNULL8859 Lake View RoadTucsonAZ85711-1527UNKNOWNN/A
TPATPA-602212026-03-30T07:02:28ZJuan··Milsl··1949-05-25null•••-••-0501(484) 319-6384-3084 Desert Sky BlvdGilbertAZ85247··GRP-9349SELECT-EPO
TPATPA-638522026-06-01T07:52:39ZCYNTHIA—MARTINEZ9/25/1996UNKNOWNN/A—cynthia.martinez36@gmail.com7315 BroadwayGilbertArizona85227——
TPATPA-548112026-06-09T17:53:46ZAnn—Black1966-05-27UHC-45653-98N/A—N/A4101 BroadwayCharlotteNC28209—NAVIGATE-HMO
TPA TPA-639712026-02-04T12:21:19ZSantiago—Hoffman··1988-20-13NULLNULL7245016599UNKNOWN2511 Harbor Boulevard··ORLANDOFL32877—CHOICE-PLUS-PPO
TPATPA-632262026-09-12T21:59:57ZASHLEY D—PARKER1968-02-15-——N/A277 Park PlTempeAZnullUNKNOWNNAVIGATE-HMO
TPATPA-561142026-04-16T06:48:33ZKathleen—Stavens1978-02-01··—5597005041·UNKNOWN6496 Maple AveSan AntonioTX78218—OPTIONS-PPO
TPATPA-582892026-05-08T10:29:31Z willie—walsh01-02-1986··UHC2044725null——408 Sage CtScottsdaleAZ85249—MEDICARE-ADV-A
TPATPA-608772026-05-07T07:56:14ZVincent——1973-06-20UHC-26763-55·N/A297.758.9648—8234 JEFFERSON AVESan AntonioTX78246GRP-6812NULL
TPA TPA-567932026-08-30T23:17:44Zcaterine····lawrence05/18/57N/A-—·null9836 Canyon Rd Apt 22ChandlerAZ85249—MEDICARE-ADV-B
TPATPA-521872026-04-26T17:30:09ZRaymond—Greene1961-03-25NULLNULL-·N/A3175 Sage CourtLos AngelesCA90059—null
TPATPA-624552026-02-26T05:26:25ZBilly—Woods28-12-2008··N/A—641.737.5470·billy.woods@icloud.com9638 SAGE CTATLANTAGA30338GRP-3851—
TPATPA-622282026-08-19T21:31:42Z AISHA—·BURNS1974-10-07N/A•••-••-9084—·AISHA.BURNS79@HOTMAIL.COM4453 FOREST AVENUEDallasTX75244-6646——
TPATPA-588832026-03-23T00:04:35ZArthur—Espinoza1991-10-23null•••-••-6875NULLUNKNOWN2783 Market StGilbertAZ85284GRP-8025—
TPATPA-594532026-02-02T14:23:10ZDanielle—Yang7/16/1982··•••-••-7130NULLUNKNOWN9457 Cedar LnGilbertAZ85256NULL—
TPATPA-564792026-06-27T23:24:32ZAnn—Schmidt1977-05-05—·-3878760394N/A9812 PALM DRIVESacramentoCA95888GRP-8548-
TPATPA-509752026-09-03T22:09:14ZCAROL—KING·2002-07-03·-•••-••-6129—UNKNOWN9307 APACHE BOULEVARDTucsonAZ··85724—·N/A
TPATPA-517592026-06-19T02:41:14ZSofia—Roers1988-01-11-•••-••-7501nullsofia.rogers@gmail.com··N/A—nullNULL—NULL
TPATPA-500742026-02-12T01:51:25ZKelley, Rick——1961-01-10N/A•••-••-6158UNKNOWNnull1539 Spring St #849ATLANTAGA30307GRP-9442-
TPATPA-639752026-10-08T14:00:11ZRoy—Cole1963-09-07—•••-••-1641——5514 Union StLAS VEGASNV—GRP-2179—
TPATPA-559172026-08-01T20:38:40ZhiroshiSblack1965-05-07—null——4931 Forest AveMesaAZ·85267GRP-2787null··
TPATPA-616762026-06-11T22:20:38ZHiroshiNGreeneSep 26, 1997UNKNOWN-null··HIROSHI.GREENE@ICLOUD.COM7106 MARKET STSACRAMENTO··CA95896GRP-0686UNKNOWN
TPATPA-569712026-04-05T15:23:21ZVIRGINIA—BENNETT7/9/2007NULL-—N/A3368 LINCOLN WAYSan Antonio·TX·78246null—
14,474 rows, page 176 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:52.252Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty