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-541442026-10-11T18:32:29ZChristian—Willis1953-12-09———-4660 Meadow LnMIAMIFL33160GRP-9365null
TPATPA-628342026-02-25T23:23:40ZSharon—Stone1949-09-05UNKNOWNN/AUNKNOWNsharon.stone@hotmail.com8449 River RdORLANDOFL32843··UNKNOWN-
TPATPA-562452026-06-29T10:29:39ZDIEGO··ELLIS1986-10-03NULLUNKNOWN··N/ANULLNULL——NULLN/A··UNKNOWN
TPATPA-553392026-08-17T09:50:49ZJean—Hamilton1965-02-08NULL—416-714-3383null4244 OAK STTEMPEAZ85258-3593····—
TPATPA-517072026-10-13T08:54:06ZBishop, Brian——19590102NULL•••-••-30792383251453NULL1478 Lincoln WayPlanoTX75057GRP-0173UNKNOWN
TPA TPA-561242026-07-12T13:04:36ZKEITH—ROSS1939-07-21UNKNOWN•••-••-6808·NULLN/A4892 BASELINE RDPHOENIXArizona85026GRP-4371OPTIONS-PPO
TPA TPA-512532026-03-26T23:29:08Z dianaWfisher19450317—•••-••-81042785830053DIANA.FISHER46@OUTLOOK.COM6134 Canyon RoadCharlotteNC28296UNKNOWN··—
TPATPA-604282026-04-03T20:15:38ZGrace··Williams1977-04-18NULL—223-237-4335NULL9067 Highland AvenueJacksonville·FL·32233GRP-5818—
TPATPA-501332026-10-13T21:42:36ZEDWARD—WILSON2006-07-10null—(721) 731-1026NULL8344 BAYSHORE DRIVEDENVERCO80215GRP-9673MEDICARE-ADV-A
TPATPA-615632026-07-22T21:54:47ZRebecca····Hoffman·1966-07-25UHC-89652-89-NULLrebecca.hoffman@yahoo.com218 APACHE BLVDLas VegasNV89176—select-epo
TPATPA-588532026-05-20T10:20:05ZLaura·PPerry02/09/80-•••-••-9689903-820-3639—5380 Ocean Avenue·GilbertArizona85289GRP-2360—
TPATPA-639912026-04-06T02:24:13ZDorothy—Russell1990-09-17UNKNOWNUNKNOWN(704) 923-1856—9373 SPRING STREET··MesaAZ85208GRP-9816OPTIONS-PPO
TPATPA-586572026-01-11T01:09:48ZDavid—Hoffman1974-11-01N/A—768-617-8513—9643 CAMELBACK RDNashvilleTN37298GRP-7232UNKNOWN
TPATPA-611932026-06-20T01:29:53ZNathan—Patterson1954-10-23——905-448-5241-5732 Harbor BlvdLOS ANGELESCA··90066GRP-2903N/A
TPATPA-552872026-09-11T05:27:27ZmarriaZhoffman2004-02-01——417-285-2297maria.hoffman@proton.me7344 Apache BlvdGilbertAZ85295—NAVIGATE-HMO
TPATPA-582472026-02-23T20:08:46ZJanice—Morris19781105—•••-••-3623280-762-0499UNKNOWNN/A·····-—GRP-8592medicare-adv-a
TPATPA-533992026-10-06T21:56:55ZEmma—Walsh24-09-2000——null··null1229 Park PlGLENDALEArizona85379N/ACORE-HMO
TPATPA-526242026-05-02T21:18:34ZBeverly—Burns1959-10-10——·NULL——-UNKNOWN—NULL-
TPATPA-573472026-10-14T15:51:04Zmatthew—munoz19990508—NULL—N/A··N/A—UNKNOWN—N/A
TPATPA-561792026-01-14T03:34:32ZNancy—MillsUNKNOWN—•••-••-670914706389323—7380 Oak StCharlotteNC28244GRP-2734null
TPATPA-509202026-05-05T21:50:49Z·JOE—NGUYEN10-12-1961UNKNOWN···NULL—·5618 Hillcrest RdPlanoTexas··75046GRP-4139NULL
TPATPA-561532026-07-23T15:18:00ZPamela—Chen11/6/1941—•••-••-7930null··—8718 Canyon RoadFRESNOCA93788····SELECT-EPO
TPATPA-576982026-08-25T04:00:51ZKYLE—LYNCH1947-10-15—•••-••-7473797-728-8722KYLE.LYNCH@OUTLOOK.COM—UNKNOWNUNKNOWN··N/A—medicare-adv-a
TPATPA-517032026-03-16T12:00:38ZTHOMAS··—WELCH2004-12-10··nullnullnull—·7503 BroadwayPlanoTX75050—N/A
TPATPA-594742026-01-02T16:17:45ZVega, Frances··X—03/18/2006UHC-07350-60•••-••-4881NULLnull2973 Elm StreetMIAMIFL33150·GRP-7817MEDICARE-ADV-B
TPATPA-593342026-08-31T21:50:48ZTheresa—Jimenez1982-01-13null-·(875) 690-7220UNKNOWN2263 Bayshore DriveEden PrairieMinnesota··UNKNOWNGRP-9302UNKNOWN
TPATPA-630772026-08-02T16:44:23Zcharlotte··brown1943-09-16——18034178320N/A7125 CENTRAL AVENUEEden PrairieMN55342—UNKNOWN
TPATPA-560942026-02-27T03:13:52ZJustin—Montgomery19810601N/A•••-••-6410nullnull·6366 Pine DriveSEATTLEWA98137N/AOPTIONS-PPO
TPATPA-516152026-06-01T22:17:37ZJESSICAGRIOS1950-07-04N/A———552 Spring StreetCharlotteNC28238N/A·CORE-HMO
TPATPA-552022026-09-20T12:14:34ZTILERAWARD1972-08-16N/A-837-876-8207tyler.ward@outlook.com———-—UNKNOWN
TPA TPA-606042026-08-14T11:53:35ZJoshua—Wagner1939-06-04UNKNOWN·NULL——6809 MARKET STREETSan DiegoCA92175nullNAVIGATE-HMO
TPATPA-542892026-01-17T01:40:01ZVickyPMitchell1982-05-08NULL···(471) 923-5847····4460 MOUNTAIN VIEW DRNashvilleTN·N/A-SELECT-EPO··
TPATPA-571762026-02-09T03:02:22ZDavidMMorgan··5/15/1943UHC-46726-85•••-••-0673N/Adavid.morgan37@hotmail.com3531 SPRING STREETAtlantaGA—GRP-0141·UNKNOWN
TPATPA-606862026-08-09T00:35:35ZMatthew—Long1973-02-26—null-——NULLnull—GRP-0320··NAVIGATE-HMO··
TPATPA-581042026-03-21T08:43:10ZJOSHUAXCONTRERAS1959-04-17null—NULL··-·8975 Ocean AveDENVERCO80271-0475····—
TPATPA-558432026-05-26T11:36:29ZCARL—PARK1963-01-14NULL•••-••-8906····UNKNOWN9297 OCEAN AVENUEFresnoCA93741N/AMEDICARE-ADV-B
TPATPA-518322026-04-05T10:17:50ZJANICE··CCLARKJun 25, 1988-N/A-N/A2719 River RoadOrlandoFL32817N/Anull
TPATPA-561852026-04-02T21:27:21Zglroia—sanchez1977-08-26N/A-nullN/A3874 CHURCH STREETCOLUMBUSOH··43288GRP-2028null
TPATPA-501642026-02-09T08:28:43ZDAVIDT.PADILLA13-11-1952UNKNOWN··—528-908-1998—5065 Hillcrest RoadTAMPAFL33633——
TPATPA-505292026-09-16T12:40:21ZDanielle—Young1954-06-21—-6733814339UNKNOWN3852 Market StreetScottsdaleAZnull··null
TPATPA-613572026-09-03T17:09:42ZAmber—Jordan1985-02-17—NULL-N/A1088 SUNSET BLVDSeattle··WA98186GRP-8941—
TPATPA-57150 2026-06-11T04:51:34ZKatharine—Schultz1955-09-26NULL··•••-••-2911NULLN/A2397 Pine DrPlanoTexas75066GRP-0406—
TPATPA-623242026-01-17T23:24:51ZHerrrera, Mary—····1973-03-20—•••-••-6708·UNKNOWN—7943 Palm DrHOUSTONTX77040GRP-9075OPTIONS-PPO
TPATPA-625212026-03-14T18:41:53ZKEITH—THOMPSON1963-12-21N/A-—UNKNOWN6960 INDIAN SCHOOL ROADJacksonvilleFL·32274—SELECT-EPO
TPATPA-604762026-02-23T10:00:44ZBRYAN—HAMILTON··2002-06-03UNKNOWNN/AUNKNOWN-2921 OCEAN AVEDenverCO80223··UNKNOWN
TPATPA-604842026-08-04T00:16:27ZArjun····Austin··3/4/1960UHC8491923•••-••-3964N/AUNKNOWN2454 HIGHLAND AVENUE··Tempe··AZ85211NULL—
TPATPA-642712026-04-07T05:44:00Z Jonathan—Schultz06/08/1945UNKNOWNN/AUNKNOWNNULL3118 PINE DRCharlotteNC28298N/A—
TPATPA-537162026-01-03T17:22:47ZBRENDA—GARRETT1984-09-28—•••-••-02287333168—N/A-nullN/A—N/A
TPATPA-608922026-06-26T02:40:18ZPatriciaLGibson1979-12-07—N/AN/ANULL··7601 Hillcrest RdAtlantaGeorgia30327—MEDICARE-ADV-A
TPATPA-587422026-05-02T18:55:48ZRICHARD—ELLIOTT1965-03-28nullNULLUNKNOWN-5139 RIDGE RDDallasTX75223nullUNKNOWN
14,474 rows, page 138 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:46.435Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty