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-4118662026-01-09T15:10:13Zhelen—west1953-01-90UHC-20637-25——NULL5497 Lincoln WayMesa·AZnull—null
CLMCLM-4282302026-01-10T22:07:00ZBRYAN····FOSTER20011201UHC-42145-76—4513496968—636 OCEAN AVEFresnoCA93709·NULL—
CLMCLM-4016392026-07-23T16:20:33ZCharles··—Marquez5/9/1991——5675652015N/AN/A·N/A—UNKNOWNGRP-6357choice-plus-ppo
CLMCLM-4228022026-02-21T09:29:47Z·SHARONTSIMS—UNKNOWNnull8218280N/A6678 CANYON RDATLANTAGeorgia30349GRP-0330NULL
CLMCLM-4289292026-10-03T23:14:27Z·Hannah—Valdez·1969-03-27—•••-••-5240UNKNOWN··nullN/A-····-—null
CLMCLM-4039272026-06-27T08:10:30ZHENRY—WAYNE9/6/1983NULL—(677) 428-0066null8107 Indian School Road·MesaAZ85268UNKNOWNSELECT-EPO
CLMCLM-4182672026-01-20T19:40:26ZLucia—Jensen9/25/1961—NULLNULLNULL··217 Park PlSan DiegoCA92124GRP-8229SELECT-EPO
CLMCLM-4302012026-03-14T14:48:01Z·PHILIP—OLSON09/07/07null——PHILIP.OLSON@OUTLOOK.COM—UNKNOWN——-MEDICARE-ADV-A
CLMCLM-4262132026-06-27T00:22:07ZNANCY—PETERS19961107UHC-86599-46··nullnull8113 Harbor Blvd··CHANDLERAZ·85237GRP-1573N/A
CLMCLM-4065732026-01-17T05:10:50ZKyle—Berry8/15/1981UHC-29527-44•••-••-8397361-312-8002··nullN/A········UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4279812026-03-10T10:42:23ZAbigailRRios05/26/1979UHC-06532-92•••-••-9314··NULL5815 Bayshore Dr #723San AntonioTexas78296N/ASELECT-EPO
CLMCLM-4243542026-07-22T19:34:01ZHenry—RuizFeb 13, 1992UNKNOWN•••-••-91629188487342UNKNOWNnullnullnull····NULL—
CLMCLM-415340 2026-01-10T00:32:57ZMARGARET—FOSTER1970-07-13UHC-64307-23•••-••-5068973.249.4998UNKNOWN3524 BROADWAYDallasTX75276GRP-4417—
CLM CLM-4215382026-07-10T10:35:30ZCharles—PayneOct 6, 1954UHC4457547•••-••-6906·(264) 687-3784—4594 Ocean Avenue Apt 3AtlantaGA30368GRP-9616—
CLMCLM-4062852026-08-30T05:08:42ZDouglas—Hill··1959-03-08UHC7502583nullNULLdouglas.hill13@icloud.com2821 Jefferson AveColumbusOH43254GRP-5502CORE-HMO
CLMCLM-4154672026-04-14T14:26:24ZZachary—Munoz6/21/1971N/A—NULL—6721 BROADWAYLos AngelesCalifornia90014GRP-4716null
CLMCLM-4152722026-09-21T15:06:09ZKimberly—MarquezMay 15, 1942UHC-94929-40•••-••-03882302544KIMBERLY.MARQUEZ@AOL.COM1432 VALLEY VIEW DRIVELas VegasNV89170GRP-3132—
CLMCLM-4020752026-07-11T02:08:35ZBuyd, MichaelZ—1992-07-23UHC-19257-78N/A(397) 543-1757-5328 Ridge RdSAN ANTONIO·TX78231GRP-7333·MEDICARE-ADV-A
CLMCLM-4129632026-02-19T10:49:12ZAmanda—Montgomery1969-03-19null•••-••-8990--6520 Harbor Boulevard·PlanoTX-·GRP-9857—
CLMCLM-4280242026-06-14T21:09:12Z BRUCE—PARKER2008-03-02UNKNOWN•••-••-3100545-568-5259NULLN/A—UNKNOWN··GRP-0707—
CLMCLM-4280292026-01-26T05:00:22Z·Kaern····Clark01/28/1956UHC-04799-83··•••-••-9192null—·7273 Mesa Drive·OrlandoFL32814-CHOICE-PLUS-PPO
CLMCLM-430365 2026-07-07T18:32:46ZAndrea—Ortiz1980-09-18N/ANULLN/A—662 Union StTUCSONAZ85792··GRP-9784-
CLMCLM-4035292026-09-19T14:08:16ZMARIA—CHAVEZ·05/25/1966UHC-22088-39•••-••-9169nullN/A9462 Mountain View Drive #944AtlantaGA30318GRP-1083MEDICARE-ADV-B
CLMCLM-4117022026-09-28T15:43:56ZRobinson, Wei——1985-07-06—•••-••-1739—WEI.ROBINSON@YAHOO.COM-—null—-MEDICARE-ADV-B
CLMCLM-4197702026-01-09T08:53:37ZHANNAH—SCHULTZ1980-07-03-N/ANULL·UNKNOWNnull—nullUNKNOWN··GRP-2256null
CLMCLM-4238762026-02-12T03:47:30ZJoshuaOBurke17-02-2005UHC-01003-36—442.879.1389······-N/AN/A—GRP-5195UNKNOWN
CLMCLM-409869 2026-05-29T18:01:45ZPaulONelson1938-02-01UHC-97618-19•••-••-3032NULLUNKNOWN—null——NULL—
CLMCLM-4066672026-04-25T14:45:55ZRandy··Lawrence1981-01-02UHC-90741-18•••-••-2866NULLrandy.lawrence@proton.me8287 Highland AveGlendale·AZ—GRP-2674MEDICARE-ADV-A
CLMCLM-4004522026-09-20T11:58:30ZMargaret—·Chavez·3/19/1951UHC-92419-11•••-••-6659875.661.0430—nullnull—NULLGRP-0692MEDICARE-ADV-B
CLMCLM-4116322026-05-22T14:26:49ZChris··Baker1978-06-18UHC-00876-55null(975) 880-6941··8288 Sunset BlvdFRESNOCA·93747—MEDICARE-ADV-A
CLMCLM-4260362026-01-04T15:21:47ZMELISSA—HICKS1954-01-18UHC-05893-60•••-••-229317853754493-8011 Central AveTempeAZ85266N/ANAVIGATE-HMO
CLMCLM-4289262026-10-16T04:52:04ZBell, Kimberly··—2003-09-01NULLnull597-903-3704—3424 Central AvenueTempeAZnullGRP-6745N/A
CLMCLM-4167842026-08-04T05:14:13ZCheryl—Butler··1997-02-05··UHC-37634-84N/ANULL·UNKNOWN5797 CEDAR LANEOrlandoFL32848GRP-4327··MEDICARE-ADV-B
CLMCLM-4159762026-01-03T04:57:39ZMegan··—Burton19-12-1962UHC-70543-77•••-••-4525··NULL———UNKNOWNGRP-1139OPTIONS-PPO
CLMCLM-4298562026-05-27T17:10:57ZAustin, Kyle··—1987-03-04·UHC-55692-22•••-••-7343UNKNOWNkyle.austin61@outlook.com·8976 Spring St Apt 11AtlantaGA··30387GRP-1921NULL
CLMCLM-4169772026-05-13T00:23:55ZMARK—·CONTRERAS6/5/1994uhc-18319-57—(365) 335-9957UNKNOWN7677 Indian School RdSACRAMENTOCA95831GRP-4070CORE-HMO
CLMCLM-4153942026-04-27T23:10:23ZStephens, Kathryn——1977-02-28UHC-35933-47•••-••-828517965411367NULL9830 SAGE COURT #552·SeattleWashington98147—MEDICARE-ADV-B
CLMCLM-4208522026-03-08T10:25:44ZJean—Espinoza1942-05-24——(489) 314-1789—3118 JEFFERSON AVEJacksonvilleFlorida32261··GRP-4864—
CLMCLM-4311082026-03-21T09:05:50ZJEAN—MCCOY1936-12-09-•••-••-449615507371454null343 Maple AvenueTampafl33600GRP-2063—
CLMCLM-4136762026-09-07T03:05:08ZWEI—COOPER10/26/1980UHC-59412-04-—UNKNOWN--————
CLMCLM-4006342026-04-25T20:26:00ZBrian—Cole··1960-09-26null•••-••-6165(824) 714-8547—8635 MARKET STMiamiFL33182GRP-6276options-ppo
CLMCLM-4111882026-07-25T07:57:29ZJOHNNY—GOMEZ1958-03-19UHC-49320-75UNKNOWN+1 535 463 0642john.gomez@gmail.com5201 Park PlOrlandoFL32873nullNULL
CLMCLM-4151342026-06-19T15:48:58ZMargaretMCox19950201UHC-24171-72null7206292101UNKNOWNUNKNOWN····N/AN/AGRP-2141UNKNOWN
CLMCLM-4205592026-07-28T04:32:20ZFerguson, Nancy··—19710410——19894813491null664 Grand AvenueAtlantaga30319UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4038082026-01-13T08:09:02ZVINCENT—ESPINOZA···1980-01-11uhc-29654-36•••-••-2767NULLNULL3999 Church St··Las VegasNV89101GRP-9531NAVIGATE-HMO··
CLMCLM-4303352026-02-28T01:02:34Z·DiegoH··Contreras23-02-1948UHC-46032-06UNKNOWN5944815555DIEGO.CONTRERAS@PROTON.ME2310 Forest AveEDEN PRAIRIEMN—-MEDICARE-ADV-A··
CLMCLM-4099602026-07-17T17:38:11ZTaylor, Kyle——2006-05-28UHC-63974-95—703.951.3758kyle.taylor73@aol.com·8390 MARKET STTampaFLUNKNOWN—null
CLMCLM-4323072026-01-15T11:11:18ZKayla—Valdez23-05-1938·····nullnull·NULL8475 LINCOLN WAYChandlerAZ85247N/Anull
CLMCLM-4261682026-06-04T03:02:23ZKayla—Yeng1952-06-07UHC-08889-57N/A——null——UNKNOWNGRP-6014—
CLMCLM-4056552026-04-10T01:12:08Zvictoria—evans1994-03-26——NULLNULL··9661 Forest AveHoustonTX77068-6642N/A··NAVIGATE-HMO
32,829 rows, page 33 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:36.677Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty