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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-405434 2026-06-22T03:30:57ZBenjamin—Olson5/25/2003UHC2254734•••-••-3891NULL-7725 Palm DrLas VegasNV89195GRP-9578-
CLMCLM-4308352026-10-16T18:50:33ZJULIE—WALSH··1908-09-08UHC-41401-24—null·julie.walsh@icloud.comNULL——N/A—MEDICARE-ADV-B
CLMCLM-4022192026-02-15T04:52:09ZNoahLWillis··17-08-1998UHC-64010-59UNKNOWN(763) 826-3661UNKNOWN916 Baseline RdCHARLOTTE·North Carolina28225nullN/A
CLMCLM-4272342026-06-01T12:38:20ZALEXANDER—KING02/01/74UHC-17995-02··274-945-2516—2968 MAIN STREETPhoenixAZ·85071nullnull
CLMCLM-4164352026-07-11T12:42:52ZLaurra—Black12/07/1958UHC-92939-08—3702006820—3594 Washington StHoustonTX77092GRP-8089NAVIGATE-HMO
CLMCLM-4067082026-03-12T13:27:33ZmarianaT··ortega07/03/99··•••-••-7961(737) 661-5042-119 Park PlEden PrairieMN55307GRP-8993CORE-HMO
CLMCLM-4080572026-08-07T08:00:53ZGABBRIELFBURNS1949-04-05UHC-23008-39····(940) 941-9965N/A5336 Apache BoulevardJacksonvilleFL32297—CHOICE-PLUS-PPO
CLMCLM-4327592026-08-26T13:55:10ZRANDY—·NUNEZ1967-12-19UNKNOWN•••-••-7705(459) 206-8764NULL—-NULL—GRP-2760-
CLMCLM-4007042026-07-20T16:41:30ZMATEO—DUNCAN1/23/1972UHC-05875-18•••-••-8579——709 Central AvenueChandlerAZ85283GRP-5544—
CLMCLM-4033012026-02-27T01:44:01ZDylan—Stone3/5/1961UHC-00232-43NULL433.272.1170—1977 Market St #466DenverCO80248-4726·GRP-1201null
CLMCLM-4266582026-09-09T11:56:10ZHANNAH—ORTIZ1957-10-10··UHC-87191-37NULL—hannah.ortiz77@gmail.com6790 Harbor Blvd··SAN DIEGOCA92126-0845NULLN/A
CLMCLM-4104992026-08-06T00:05:02ZISABELLA—RAMIREZJun 23, 2003NULL•••-••-2973670-652-6520—3355 Elm St Apt 36MinneapolisMN55479GRP-2809MEDICARE-ADV-B
CLMCLM-4212352026-06-23T11:16:55Zvirignia—ray1956-02-72UHC-17642-30N/A··(937) 257-1397-350 Union StPhoenix·AZ85045-9595GRP-5360OPTIONS-PPO
CLMCLM-4120232026-09-10T23:24:18ZRandyCSims10/01/83null——-7983 Church StAtlantaGA—GRP-9216·UNKNOWN
CLMCLM-4276972026-05-25T00:22:26ZBilly—Henderson1995-12-27·null—UNKNOWN—1253 Lake View RoadEden PrairieMN55342NULL·OPTIONS-PPO
CLMCLM-4086042026-09-03T17:50:45Z·Robert—Palmer04/05/1968—•••-••-2325——7598 MEADOW LANESeattleWA98162NULLMEDICARE-ADV-B
CLMCLM-418902 2026-07-06T12:27:24Z·Vazquez, Heather——19861105UHC-80866-77null(896) 372-2273--—-····GRP-4855MEDICARE-ADV-A
CLMCLM-404533 2026-08-23T02:47:36ZHiroshi—Kelley1950-10-21nullUNKNOWN·nullN/A2695 INDIAN SCHOOL ROAD Apt 9PhoenixAZ·85004GRP-7262—
CLMCLM-4198882026-05-16T15:33:38ZWalsh, Brian··—11/11/69··UHC-92358-31UNKNOWN833-588-3813—83 LINCOLN WAYHoustonTX77096··GRP-8240····
CLMCLM-4223802026-04-11T02:16:33ZKyle—CastilloDec 21, 1959UHC-18191-50N/A6406022389N/A4313 Grand AvenueTempe···AZ85299GRP-1199··CHOICE-PLUS-PPO
CLMCLM-4001272026-10-14T06:21:13ZOMAR—MCCOY1951-12-23UHC-42002-69—·-····1770 Indian School RoadSeattleWA98168—N/A
CLMCLM-4155292026-06-28T22:49:47ZRay—Martinez07/23/1964UHC-76339-68UNKNOWNN/A—·5764 Desert Sky BlvdScottsdaleAZ85244—SELECT-EPO
CLMCLM-4283322026-04-18T06:09:55ZJORDAN—GEORE1959-06-18NULL•••-••-6599UNKNOWNnull6040 BAYSHORE DRIVEScottsdaleAZ85268GRP-7166—
CLMCLM-4222552026-10-06T19:29:36ZBobby—Santos0238-19-65UHC-83369-97····N/A-7250 Apache BlvdDallasTX75217GRP-8950··SELECT-EPO
CLM CLM-4240102026-10-14T03:40:17Zjoan—duncan04-05-1993UHC-84887-28N/A··——1439 Park PlHoustonTX·77074GRP-6114-
CLMCLM-4151012026-03-13T17:11:56ZMICHELLE····LEESep 4, 1942————182 Canyon RoadLos AngelesCAnullGRP-8406N/A
CLMCLM-4054832026-04-27T23:07:19ZThomas—Powell1965-12-19--NULL··thomas.powell@aol.com1837 Palm DrAtlantaGA30397GRP-2922N/A
CLMCLM-4274772026-10-16T10:10:53Z·MARGARET—GONZALES02/10/1981UHC-59119-32•••-••-0145UNKNOWNN/AnullUNKNOWN——GRP-1635MEDICARE-ADV-A
CLMCLM-4251232026-02-13T16:18:28ZSAMANTHA—LAWRENCE1940-04-12UHC-39266-73•••-••-40903033327011null··7120 WASHINGTON STREETTucsonAZ85751GRP-0112NAVIGATE-HMO
CLMCLM-4272282026-07-14T06:00:02ZChristine··—Ortega1969-09-22uhc-41954-71•••-••-3608838-218-6598—3529 Market StreetSan DiegoCA92177·GRP-3842·null
CLMCLM-4237502026-04-30T03:11:46ZJulia··Myers3/8/2001UHC-12935-90null936-506-7662·-7917 Desert Sky BoulevardScottsdaleAZ—GRP-5091·CORE-HMO
CLMCLM-4172492026-03-15T07:26:33Zmartha—foster15-04-1963UHC-91764-99-(209) 499-1159N/A539 Church StNashvilleTN37292nullCORE-HMO
CLMCLM-4198442026-06-25T17:38:26ZPAUL··—LE1992-11-08UHC-35140-55•••-••-4463NULL———NULL—GRP-7103NULL
CLMCLM-4208152026-04-05T06:49:03ZAlexander—HarrisMay 11, 1999null··•••-••-8246—NULL7680 Apache BlvdScottsdale··AZ85247·UNKNOWN····
CLMCLM-4141542026-04-02T11:27:17ZDeniel—Bennett2008-08-12UHC-66829-88—····nullUNKNOWNUNKNOWNnullnullGRP-0753OPTIONS-PPO
CLMCLM-4125042026-03-19T17:57:25ZBailey, Jennifer——·2002-08-03UHC-38553-30UNKNOWN3067842481—8575 INDIAN SCHOOL ROADDALLASTX··—GRP-4125MEDICARE-ADV-B
CLMCLM-4171622026-09-18T17:04:06ZRayes, Jacob——1998-07-28UHC-39351-80•••-••-91036537723905—2180 River RoadTucsonAZ85764GRP-3899—
CLMCLM-4218972026-03-17T14:19:39ZMartha··—Watson1963-10-20nullNULL-NULL3899 Spring Street #106·SeattleWA··NULLCHOICE-PLUS-PPO
CLMCLM-4022492026-07-03T03:19:56ZCharlotte—Alvarez1978-04-04nullN/A——5621 PINE DRIVESacramentoCA95827UNKNOWNCORE-HMO
CLMCLM-4225912026-09-27T21:23:28ZJULIECRYAN26-03-2001—•••-••-6201UNKNOWN—9125 Bayshore DriveGilbertAZ·85295UNKNOWNSELECT-EPO
CLMCLM-4231862026-05-15T13:52:47ZStephen—Henry1987-04-03·UHC-31765-74•••-••-3490N/A—NULLnull—-··null—
CLMCLM-4144832026-05-21T19:56:34Zjoan—torers1963-04-07UNKNOWN-—joan.torres20@aol.com7239 Ridge RoadOrlandoFL32894GRP-5664SELECT-EPO
CLMCLM-4271452026-04-23T13:51:46ZPriyaDColeman19790222UHC-29997-83—-null8189 CANYON RDPhoenixArizona85027GRP-0405MEDICARE-ADV-B
CLMCLM-4085202026-05-26T09:25:47ZTyler—Thomas1948-08-01UHC-19916-14•••-••-9634723-723-8977N/A6416 Pine DriveSan AntonioTX78264GRP-5566·NAVIGATE-HMO
CLM CLM-4225212026-05-12T08:05:12ZRaymond—·RoobinsonJun 19, 1982UHC-26424-85NULL-raymond.robinson44@aol.com··7510 CHURCH STSan AntonioTX78238NULLN/A
CLMCLM-4114802026-01-24T13:15:53Z Margaret—Cruz2001-01-09—N/A-—null—N/ANULL·GRP-7146—
CLMCLM-4231362026-07-01T05:17:59ZGordon, Steven—··1941-01-06UHC-13949-67-(403) 465-9166—4531 BroadwaySeattleWA98187-NULL
CLMCLM-4114172026-07-13T06:28:20ZASHLEY—RYAN11/18/1968UHC-36732-55NULL5507050464—N/ANULLNULL-GRP-4464··choice-plus-ppo
CLMCLM-4199852026-06-28T07:22:47ZRichards, MeganG.—2007-12-04null•••-••-0641UNKNOWN-5739 Oak Street·TempeAZUNKNOWNNULL—
CLMCLM-4269402026-07-25T05:32:29ZAndrewMRay12-12-1959UHC-74730-74—NULL—1611 Jefferson AveTEMPEaz85278GRP-8093NAVIGATE-HMO
32,829 rows, page 165 of 657PreviousNext

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:40.593Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty