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-409025 2026-05-31T08:51:35ZLaura—Gomez3/17/1964·N/A•••-••-5402N/ANULL8549 DESERT SKY BOULEVARD Apt 5CHARLOTTENC28241GRP-7271MEDICARE-ADV-B
CLMCLM-4040582026-01-29T23:07:07Z Harold—West1994-04-02UHC-75390-74UNKNOWNUNKNOWN—4445 Sage CourtSeattleWA98162—UNKNOWN
CLMCLM-4318852026-01-20T04:08:52ZHarris, Russell——3/11/1995UHC-43669-93null—RUSSELL.HARRIS64@ICLOUD.COM6007 Bayshore DriveColumbusoh43286GRP-2136OPTIONS-PPO
CLMCLM-4262282026-10-08T01:04:32Zsam—morris2004-09-22UHC7287202•••-••-914518475354994—NULL—UNKNOWNUNKNOWN·GRP-6780OPTIONS-PPO··
CLMCLM-4202002026-06-23T11:25:39ZMateo—Alvarez1994-06-14-null256-398-9739N/A8301 Lake View RdDENVERCO80212·GRP-7870null
CLMCLM-4247062026-01-18T14:42:41Z ·Yang, NathanE—1957-05-21UHC-79738-91UNKNOWN(494) 927-1401···nathan.yang@aol.com4848 HILLCREST ROADLos AngelesCA90002—·-
CLMCLM-4232232026-02-09T19:22:39ZJerry—Hoffman1942-07-21UHC-04371-18····——9164 MARKET STREETMesaArizona85254GRP-4387CORE-HMO
CLMCLM-4213022026-07-03T07:27:52Z Amy—Hamilton1957-11-14-•••-••-5746—····6489 River RdGilbertAZ85229-4853GRP-5897NULL
CLMCLM-4317962026-05-06T06:32:48ZCATHERIINE—CARROLLSep 27, 1972UHC-22691-20N/A4293087050·null1286 BroadwayCHANDLERAZ85236NULL-
CLMCLM-406355 2026-01-19T21:17:21ZAlexis··Robinson1959-01-05NULLnull970-833-1418N/A8248 Cedar LaneMinneapolis··mn55433··GRP-1027null
CLMCLM-4306032026-07-10T21:53:46ZNatalieCVega1940-08-09UHC-56961-29•••-••-2069+1 598 363 2600NATALIE.VEGA32@ICLOUD.COM4147 Mountain View DriveGilbert·AZ85226·GRP-0355—
CLMCLM-4108932026-07-10T12:01:18ZMunoz—Hiroshi1976-06-14-null—UNKNOWN7710 Elm StreetTAMPAFL—GRP-9924CHOICE-PLUS-PPO
CLMCLM-4310882026-03-09T02:48:52ZDiana··—Dixoon21-02-1999UHC-36805-24——DIANA.DIXON55@PROTON.ME··6630 Washington StSan AntonioTX78246GRP-7018—
CLM CLM-4125452026-08-05T16:10:41ZRyan, Shirley C——1986-10-27—UNKNOWN-N/A4300 Grand AveTEMPEAZ85243-1305GRP-4791CHOICE-PLUS-PPO
CLMCLM-4152572026-04-07T00:25:00ZReynolds, JanetY—12/05/1948———janet.reynolds@icloud.com2594 Cedar Ln #778NashvilleTN37225GRP-1929CORE-HMO
CLMCLM-4199142026-04-19T14:15:03ZMendez, John——1971-06-11UHC-77811-84NULLnull-9735 Church StreetTempeAZ85276·GRP-8653SELECT-EPO
CLMCLM-4157182026-05-09T02:36:42ZAisha—·Harrison19870408UHC-04953-40—(955) 615-8426N/A8464 Washington StreetMinneapolisMN55478GRP-5809NAVIGATE-HMO
CLMCLM-4157642026-02-01T13:50:30ZMark—Valdez1963-01-27UHC-15559-11NULL784-881-4410—8847 Mesa Dr·NASHVILLETN37269··GRP-6353null
CLM CLM-4102662026-06-18T23:12:16ZMichael—Evans9/4/2006UHC-53781-65•••-••-8105NULLN/A2201 Elm StreetNashvilleTN37245GRP-6224·CORE-HMO
CLMCLM-4160362026-06-06T07:52:20ZPriya—EdwardsJun 3, 1939UHC2580096—-—3809 Grand AvenueSeattlewa98135GRP-5101CORE-HMO
CLMCLM-4058202026-10-02T03:15:59ZBENJAMIN··—HARVEY1949-06-01UHC-69892-51•••-••-29356196052892——N/AN/ANULL·GRP-1196MEDICARE-ADV-B
CLMCLM-4056632026-09-29T09:12:39ZPhilip—LawsonFeb 3, 1950UHC-99396-10—NULL··null5458 Ocean AveCharlotteNC28296——
CLMCLM-4226872026-04-04T20:02:17ZheatherPcook01/10/73-N/A—UNKNOWN6040 Mountain View DrTampaFlorida··33672·GRP-0268CORE-HMO
CLMCLM-4010172026-09-12T04:08:50ZMELISSAMMORENO9/17/2000UNKNOWN•••-••-16425749501526N/A7186 Lake View Rd #207Chandler·Arizona85207GRP-2118OPTIONS-PPO
CLMCLM-4187322026-10-08T17:23:22ZSTEPHEN—ALEXANDERMay 25, 1977··UHC-53417-56•••-••-06699165636371—1435 INDIAN SCHOOL ROADAustinTX··78701N/A—
CLMCLM-4153562026-04-04T15:29:26ZWilliam·H.ThomasOct 27, 1950UHC-66305-24•••-••-1153UNKNOWN-8887 Palm Drive·Miamifl33102··N/A··
CLMCLM-4172312026-08-19T18:17:38ZVazquez, Hiroshi··—1939-07-09UHC3677570—N/Anull1689 GRAND AVEDallasTX75258-4219GRP-0895-
CLMCLM-4030152026-10-13T22:04:57Z·Lauren—Alexander1908-09-18—•••-••-5350767.820.7593null1352 Grand AvenueDenverCO··80297GRP-5675NAVIGATE-HMO
CLMCLM-4255462026-03-07T04:34:03ZTheresa—Nunez07/19/92UHC-41718-56N/A6948729574THERESA.NUNEZ@ICLOUD.COM5585 Harbor BlvdTucsonAZ··85734—N/A
CLMCLM-4147542026-05-03T02:36:10ZDavisBAndrea·1979-07-08UNKNOWN—-andrea.davis3@proton.me5797 Spring StreetDENVERCO80205GRP-0380MEDICARE-ADV-A
CLMCLM-4158592026-09-22T23:29:11ZJANET—VEGA1962-07-19UHC-43454-73•••-••-524613475113017NULLnullN/A··—nullN/A—
CLMCLM-4113112026-01-19T08:30:45ZAlexanderY·Reynolds08/03/1990N/ANULL··699-304-2577N/A7344 Cedar Ln Apt 7GlendaleAZ85333-·MEDICARE-ADV-B
CLMCLM-4116712026-01-24T20:23:47ZDONNA·ISTEPHENS1984-03-07—N/A5458276708N/A1758 Mountain View DrivePlanoTX75067GRP-7778CHOICE-PLUS-PPO
CLMCLM-4235192026-06-13T11:46:48ZAdam—Morgan1970-12-26·UHC-73274-64NULL(300) 767-6926N/A7848 Bayshore DrChandlerAZ85268GRP-7583CHOICE-PLUS-PPO
CLMCLM-4009562026-09-08T02:05:45ZCamila··Santos1951-11-20UHC3128637—+1 682 313 6559null4386 LAKE VIEW ROAD Apt 25SEATTLEWA98115GRP-9298OPTIONS-PPO
CLMCLM-4285472026-03-15T19:02:35ZJosephA.Pena·01/07/45UHC3584637•••-••-9184—--—N/A—GRP-0595—
CLMCLM-4300782026-06-25T01:23:44ZJOYCE—HUGHES·1/28/1975·UHC-03319-12NULL——4430 PARK PLAtlantaga30309··NULLUNKNOWN
CLMCLM-4064442026-02-08T13:47:57ZAbigail—Vazquez1966-07-01UHC-43328-08—-abigail.vazquez67@outlook.com····————null
CLMCLM-4244962026-04-27T13:47:39ZCarol··Peterson1988-03-27··UHC-20697-04—904-778-4461·-7116 CENTRAL AVENUEColumbusOH43230UNKNOWNN/A
CLMCLM-4043342026-01-24T21:11:34ZSharonK.Miller03/24/1960UHC-41797-44•••-••-7382—-··-—-—GRP-3002···OPTIONS-PPO
CLMCLM-4253232026-01-07T02:13:46Zana—fernandez1968-02-05UHC-14297-96NULL——5819 Hillcrest RoadFresnoCA93789GRP-3011UNKNOWN
CLMCLM-4094852026-02-04T07:24:55ZMARGARET··STONE1979-11-12UHC-82032-35—null—5524 Pine DrivePlanoTX75014null-
CLMCLM-4161392026-07-11T21:03:23ZRaandyIHunt1990-04-04UHC-06808-42•••-••-7568UNKNOWNRANDY.HUNT@AOL.COM5547 BASELINE ROADHoustonTX77024GRP-6816··NAVIGATE-HMO
CLMCLM-4003362026-07-17T22:12:29ZSusan—Myers1986-07-03UHC-25021-80•••-••-5347—-2325 Harbor BlvdSan AntonioTX78218GRP-6264MEDICARE-ADV-B··
CLMCLM-4006882026-07-07T06:58:13ZLAUREN—FREEMAN1958-04-09UHC-00648-13—NULL—2778 Bayshore DriveEden PrairieMN55388N/ACORE-HMO
CLM CLM-4306522026-07-22T12:03:32ZGeorge—Hughes1957-09-12UHC-74485-63NULL(583) 720-5436··—2144 Hillcrest RdSan DiegoCA·92144GRP-8549OPTIONS-PPO
CLMCLM-4182852026-07-28T02:39:36ZRAY—RAY12/26/1945-———····-—nullGRP-6567null
CLM CLM-4275192026-01-17T11:08:36ZEMMA—DIAZ1979-08-04UHC-52882-72•••-••-7697-·null3374 Spring Street··Fresnoca·93773GRP-2348NAVIGATE-HMO
CLMCLM-4280372026-04-21T19:31:10ZDorisL.Rogers12/28/08UHC-47330-63•••-••-3757(719) 823-8952doris.rogers@yahoo.com7281 Meadow LnGLENDALEAZ85324—MEDICARE-ADV-B
CLM CLM-4150662026-06-15T05:19:28ZJustin··A.Cox1998-05-03N/A··NULL—null—N/Anull—GRP-1683options-ppo··
32,829 rows, page 175 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.609Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty