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-4124492026-06-15T00:26:55ZKEVIN—LEWIS1972-06-28·UHC-47662-48•••-••-9052273-614-7265NULL8730 Sage CtSan DiegoCA92157GRP-6646UNKNOWN
CLMCLM-4045992026-06-01T18:35:11ZANDRWE—ARNOD1988-09-26nullN/A431.586.9218-3704 Spring StreetTampaFL33606nullCHOICE-PLUS-PPO
CLMCLM-4071092026-01-13T22:38:53ZEUGENE—PAYNE1980-01-28UHC-90395-97—2367729599eugene.payne@icloud.comNULLN/ANULLNULLUNKNOWN··SELECT-EPO
CLMCLM-4097182026-08-10T14:23:27ZAisha—Baker·19-03-1944UHC-54571-05-+1 225 803 1079UNKNOWN··5994 Indian School Road Apt 16CharlotteNC28210NULL—
CLMCLM-4122732026-01-08T01:04:09ZThomas—Richards2/21/1945—•••-••-4808-NULL4221 OAK STLAS VEGASNV89129GRP-0675OPTIONS-PPO
CLMCLM-4104942026-05-16T03:53:32ZKATHLEEN—BERRY18-08-1952UHC-82564-45•••-••-7935262-480-6532NULL5038 River RdPHOENIXAZ85046GRP-7860—
CLMCLM-4005772026-02-17T19:40:52ZRonalld—Hill01/11/1984N/A•••-••-0623+1 839 397 9984——-——GRP-9118OPTIONS-PPO
CLMCLM-4111982026-09-26T04:37:32ZRoyIOlsonDec 13, 1956UHC-80127-17—UNKNOWNN/A—N/AUNKNOWN-—NULL
CLMCLM-4058002026-09-26T02:56:45Z·McDonald, Julia——04-01-1999UHC-38336-75-9039003988null9310 Washington Street··HoustonTX77028GRP-8240·NULL
CLMCLM-4325022026-01-31T11:24:26ZLori—Roberts1948-04-24UNKNOWNN/A5453682258-3853 HILLCREST ROADTempeArizona85253GRP-6217NAVIGATE-HMO
CLMCLM-4234642026-02-07T14:39:20ZWillis, Amber——1990-08-08··UHC-07211-06—UNKNOWNN/A——NULL··GRP-1948select-epo
CLMCLM-4094262026-10-14T03:32:10ZBrandonMPena1938-08-08NULL····NULL—3328 Ridge RoadPlanoTX75069GRP-0384NAVIGATE-HMO
CLMCLM-4146572026-03-07T23:24:56Zelijah—murphy19780402UHC-76725-58NULLnull—409 Harbor BoulevardCharlotteNC28228nullN/A
CLMCLM-4012942026-08-30T19:17:04ZKevin—Ford··09/25/46UHC9019321N/A-··-3596 BROADWAYHoustonTX77069GRP-2136NAVIGATE-HMO
CLMCLM-4250382026-06-03T18:45:23ZKathryn—·Mejia19-02-1938—•••-••-6854———N/AnullN/A—NAVIGATE-HMO
CLMCLM-4188662026-01-14T01:33:59Z·amy—riley1957-03-05UHC-09465-38N/A(699) 559-0922N/A4668 Jefferson AveSeattleWashington98123UNKNOWNOPTIONS-PPO
CLMCLM-4046852026-03-03T20:33:38ZPAT—CASTILLO0101-19-98UHC-12275-94-8154560222-106 Ridge RdNashvilleTennesseenull-CORE-HMO
CLMCLM-4025902026-09-03T18:16:03ZBryan—Estrada19390212UHC-28517-49N/AN/A—2929 VALLEY VIEW DRColumbusOH·43238GRP-6377NULL
CLMCLM-4149052026-08-14T17:52:06ZAlbret—James1962-11-11—NULLnullN/A2638 Forest AvenueTempeAZ85266GRP-3919-
CLMCLM-4180432026-01-22T16:11:44ZJohnNBurns··1947-09-05UHC-60801-54•••-••-5177—-4753 Apache Boulevard·San Diegoca92197GRP-7325—
CLMCLM-4289062026-02-28T11:28:08ZJoyceQMendoza··1971-08-07UHC-05355-82•••-••-9366+1 719 904 0940NULL5218 Palm DrMesaAZ85241GRP-2046—
CLMCLM-4050002026-05-05T09:36:10ZKathleen—Wagner1960-06-06—N/A—N/A-—-—nullOPTIONS-PPO
CLMCLM-4234142026-04-15T00:22:34ZSamantha—·Washington1995-02-23UHC-17963-87—NULLUNKNOWN4213 Cedar LaneGlendaleAZ85331NULL·null
CLMCLM-4052682026-03-22T13:46:34ZRUSSELLF.·GIBSON1954-06-12UHC-03948-12null7956215806N/A··8245 OCEAN AVENUESan AntonioTexas78208··UNKNOWN
CLMCLM-404371 2026-05-11T14:36:14ZAnthony····Kennedy1982-05-09—•••-••-3657··ANTHONY.KENNEDY55@GMAIL.COM··621 Forest AveFresnoCA93749—MEDICARE-ADV-B
CLMCLM-4155492026-05-21T07:06:56ZKathleen—Crawford1999-06-01uhc-99013-43—307-823-5692UNKNOWNnull··—NULL-GRP-6836UNKNOWN
CLMCLM-4187952026-06-02T13:53:28ZDoonald····Burton02/10/1973··•••-••-5247825-246-7993NULL8911 Sunset BoulevardHoustonTX77089······SELECT-EPO
CLM CLM-4031382026-09-02T21:37:27ZMeiSBrooks1986-10-23—•••-••-74659869731343—2240 LAKE VIEW ROADSCOTTSDALEAZnull—SELECT-EPO
CLMCLM-401724 2026-03-20T22:21:36ZJoe·····Rivera19520718UHC-05846-87•••-••-7658—UNKNOWN6829 Harbor BoulevardGILBERTAZ85230—NAVIGATE-HMO
CLMCLM-4038962026-02-02T14:13:17ZJoyce—Sanchez1955-04-11··UHC-08012-65··(593) 666-3259N/A9217 Ocean Avenue #387AustinTX78749··nullCHOICE-PLUS-PPO
CLMCLM-4108772026-02-12T04:37:36ZDOROTHYH.ELLIOTT1963-04-10UHC-67017-31··•••-••-0421623.867.5387dorothy.elliott@hotmail.com6036 HIGHLAND AVENUEPlano··TX75048GRP-2509MEDICARE-ADV-A
CLM CLM-4251272026-06-21T18:15:43ZJOSH—GRAY1994-04-12UHC-40679-05——null1373 Lincoln Way #117SacramentoCA95872GRP-3636null
CLMCLM-4198512026-09-12T02:52:14ZDORIS—HOFFMAN1938-11-04UHC-67405-53-(764) 978-3433null8947 Willow CtEden PrairieMN55332UNKNOWNN/A··
CLMCLM-4256352026-07-30T18:25:52ZJoyce—Williams1955-08-15··UHC-83998-13NULL(409) 944-0757N/A7046 Oak StreetDallasTX75243GRP-5583CORE-HMO
CLMCLM-4201992026-09-06T12:08:52ZWells, Carlos——2000-05-14UHC-40662-02—8239587856NULL·null———GRP-1903OPTIONS-PPO
CLMCLM-4084902026-01-14T04:21:03ZGreg—·Martinez1950-05-21UHC-78137-30•••-••-3530(803) 337-7345-4284 JEFFERSON AVENUELas VegasNV89172nullCORE-HMO
CLMCLM-4231112026-09-27T22:01:12ZChrisine—James2004-08-08UHC-20756-55nullNULLnull264 Lake View RoadCharlotteNC28239GRP-2133-
CLMCLM-4108512026-07-27T20:42:15ZThompson, KaylaD.—1963-09-26UHC-24551-29—(711) 953-8739-89 Park PlaceMesaAZ85276-OPTIONS-PPO
CLMCLM-4003662026-07-17T20:13:57ZAISHA—MARTINEZ1982-02-27UHC7489952•••-••-8615(721) 246-4143N/A6467 BROADWAYORLANDOFL32886GRP-2753NULL
CLMCLM-4040472026-05-21T05:38:40ZAlanMDiazDec 10, 1979uhc-23825-89•••-••-0545—UNKNOWN9173 Sunset BoulevardLas VegasNevada89110GRP-6843SELECT-EPO
CLMCLM-4035932026-09-14T12:28:48ZMarilyn—Hart1953-09-01UNKNOWN•••-••-8786(713) 379-1846··689 Spring StreetDenverCO80212-1383null—
CLMCLM-4027142026-06-29T15:48:18Zsean—taylor08-11-1968UHC-43430-10N/A308.327.8017null8837 Willow CtPhoenixAZ85071GRP-4374OPTIONS-PPO
CLMCLM-4187852026-05-24T20:33:07ZKATHRYN—COLLINS12/27/73UHC-56200-39··•••-••-88463856457617—1909 CANYON ROADDenverCO80250GRP-9651NAVIGATE-HMO
CLMCLM-4149862026-09-30T07:35:30Zeric—cooper04/02/1969UHC-23594-28——NULLNULL—UNKNOWNnullGRP-6244—
CLMCLM-4182272026-03-01T22:30:13ZMedina, Terry——1965-02-08UHC-89474-97—(518) 433-0047TERRY.MEDINA99@OUTLOOK.COM9633 Sage Court Apt 4Eden PrairieMN55316GRP-9759··MEDICARE-ADV-A
CLMCLM-4272592026-06-07T18:40:16ZDebra—Campbell1985-06-08UHC-83937-54UNKNOWN709.682.3811UNKNOWNnullN/A—N/AGRP-3150CHOICE-PLUS-PPO
CLM CLM-4053162026-03-31T12:53:57ZSofia—·Ortiz1941-21-24UHC-21428-86·null(944) 460-3185NULL8551 MARKET STREETFresnoCA93776-6964GRP-2503MEDICARE-ADV-A
CLMCLM-4230842026-04-27T05:49:24ZANA—KNIGHT08/10/92UHC-00835-26null—NULL4791 Harbor BoulevardGlendaleArizona—·N/A—
CLMCLM-4325962026-08-24T05:32:30ZEMILYBHAMILTON2440-19-58——7927784735UNKNOWN1869 Apache BoulevardSan AntonioTexas·78278GRP-4428UNKNOWN··
CLMCLM-4101482026-03-10T02:09:55ZAlexisSBrooks1966-03-25null•••-••-7105—ALEXIS.BROOKS@OUTLOOK.COM741 RIDGE ROADSan AntonioTX78284——
32,829 rows, page 140 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.321Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty