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
CLM CLM-4314242026-06-12T03:52:39ZMarcus—Cook1964-01-01—•••-••-7462N/A··—2570 Forest AveSAN DIEGOCA92163GRP-7666N/A
CLMCLM-4101822026-02-25T21:44:09Zcheryl—murray2004-09-04UHC-17856-63—-cheryl.murray42@icloud.com·8800 UNION STNASHVILLETennessee37293-CHOICE-PLUS-PPO
CLMCLM-4325092026-04-27T15:24:54Zkevin—·johnston1956-06-01NULL•••-••-4958388-537-9182kevin.johnston@aol.com8262 Maple Avenue #382FresnoCA93752GRP-4490SELECT-EPO
CLM CLM-4024772026-03-10T20:03:40ZBraandon—Rivera2006-08-16UHC-83841-16•••-••-2680N/AN/A—·NULLN/A-—N/A
CLMCLM-4048082026-04-28T14:59:42ZFowler, MichelleI.—09/08/1981UHC-63795-99NULLUNKNOWNmichelle.fowler@proton.me2988 CENTRAL AVENUE·PHOENIXArizona85015null··-
CLMCLM-4149772026-08-29T17:34:31ZBRENDA—REED1974-02-24UHC-39078-46UNKNOWN··(248) 414-2651—UNKNOWN-··nullN/AGRP-9981··NULL
CLMCLM-4168752026-03-28T04:33:47Zvega—ralph05/04/1993UHC-28916-39•••-••-8095UNKNOWN—627 Ridge RdPhoenixAZ85094—CHOICE-PLUS-PPO
CLMCLM-4182662026-05-03T18:01:07ZSoto, Brenda——11/18/1938UHC-22397-55•••-••-239216445396041—508 Forest AveMiamiFL33158-9471-·null
CLMCLM-4290322026-09-22T13:10:08ZMcDonald, Isabella··——1965-02-03UHC-42587-12··-NULLisabella.mcdonald72@gmail.com4192 Willow CourtOrlandoFL32816—N/A
CLMCLM-4043022026-10-08T19:47:46ZAmy····Marshall1994-10-07UHC-80245-87•••-••-1855273-216-9038N/A555 MAIN STEden PrairieMN55344nullnull
CLMCLM-4324482026-06-26T09:14:37ZCooper, Christina——05/08/1958UHC0866019•••-••-3830(794) 930-4045UNKNOWN6821 SAGE COURTMiamiFL33179GRP-0479MEDICARE-ADV-A
CLMCLM-4279992026-03-29T17:25:59ZDaniel—Gilbert08/24/1938·UHC-92037-28UNKNOWN-DANIEL.GILBERT@GMAIL.COM·9403 MARKET STREETTampaFL33624GRP-8721NAVIGATE-HMO
CLMCLM-4215242026-01-25T12:19:44ZDylanT·HansenJul 5, 1994··N/AUNKNOWNN/ANULL4500 River Rd·PlanoTX75054-CHOICE-PLUS-PPO
CLMCLM-4106602026-06-26T21:01:14ZJUDYUPARKER19560602UHC-51982-77UNKNOWN7354265980———N/ANULL··GRP-7069··-
CLMCLM-422737 2026-09-02T00:34:57ZTurner, TerryA.—1971-11-01UHC-21752-21-·(273) 779-8336··1967 Valley View DriveHOUSTONTX—GRP-1067MEDICARE-ADV-A
CLMCLM-4090732026-01-13T08:38:21ZTheresa—Cunningham2004-01-18—•••-••-8783-UNKNOWN8763 Washington StTempe··AZ85277··—CHOICE-PLUS-PPO
CLMCLM-4290042026-03-05T06:45:25Zvirginia—johnston···1978-09-20—•••-••-9281—N/A6385 Ridge Road·NashvilleTN37271-2936GRP-2811NULL
CLMCLM-4058172026-08-28T14:29:56ZDavid—Lewis04/09/81·UHC-05353-85N/ANULL—5645 APACHE BLVDEden Prairie··MN·55366GRP-8541NAVIGATE-HMO
CLM CLM-4132452026-10-12T02:50:07ZSullivan, Yuki——19411026UHC-25113-73•••-••-3638848-975-0296UNKNOWN··2742 Camelback RdLas VegasNV89125GRP-3656··OPTIONS-PPO
CLMCLM-4314542026-01-12T08:46:50ZjoseSjensen1953-01-13UHC-42670-96•••-••-0901NULL··2719 OCEAN AVENUE··NashvilleTN··UNKNOWNNULLN/A
CLMCLM-4078722026-08-25T16:28:46ZJenkins, Russell——1981-01-19UHC-53169-39—UNKNOWNN/A··N/Anull-nullCHOICE-PLUS-PPO
CLMCLM-4219922026-10-07T20:13:12ZALICEUMILLS1965-02-25UHC-67408-86NULL360-290-8120-8784 Ridge RdTucsonAZ85768—MEDICARE-ADV-A
CLMCLM-4196422026-10-05T14:10:09ZJacob—Herrera1962-03-22-•••-••-6293N/AUNKNOWN··8167 Highland AvenueNashvilleTennessee37298GRP-5541OPTIONS-PPO
CLMCLM-4111692026-08-01T06:54:17ZRussell··—Andrews1989-04-11-NULL+1 889 613 3226—2725 Pine Dr·ChandlerAZ85227GRP-4985CORE-HMO
CLMCLM-4327062026-01-15T23:57:57ZPATRICK—WELLS09/19/1969UHC-81827-11NULL—N/A8113 Church StNASHVILLETennessee37297··UNKNOWN—
CLMCLM-4203372026-09-27T22:11:02ZraymondNmills1957-50-17··UHC-11438-15N/A4986616054—5768 Forest AveEDEN PRAIRIEMN55355——
CLMCLM-4109012026-08-06T23:59:17ZEvelyn—Garrett11/19/42UHC-93545-01NULLNULLNULL2256 River RoadJACKSONVILLEFL32270GRP-1269NAVIGATE-HMO
CLMCLM-4097232026-02-14T11:52:58ZJONATHAN··—PATEL1961-12-21NULLnullUNKNOWNnull4336 DESERT SKY BOULEVARDGlendaleAZ85381·GRP-8528MEDICARE-ADV-B
CLMCLM-4309892026-02-06T06:48:05ZKelley, Dennis——5/23/2006··NULLN/A8796066295NULL1820 PINE DRIVELAS VEGASNV89138GRP-0999··—
CLMCLM-4216932026-08-27T16:41:44ZJUDY—HENDERSON23-01-1973UHC-53252-69—875.316.1429—4191 Ridge Road··Eden PrairieMN55354—NULL
CLMCLM-4220682026-05-30T07:59:00Z Fatima—Thomas25-03-1960uhc-12199-64•••-••-3626NULLNULL9534 Sage CourtScottsdaleAZ85229GRP-7771choice-plus-ppo
CLMCLM-4237512026-03-23T17:31:12ZHarris, Kelly··——1961-03-22UHC-15595-64—16919397031NULL3408 HILLCREST RD··MINNEAPOLISMN55490GRP-9731NAVIGATE-HMO
CLMCLM-4005862026-06-09T20:06:50ZHenry··—·Lane11-09-1940UHC-78055-45•••-••-4556UNKNOWN·null1172 LINCOLN WAYLos AngelesCA··90068-2030GRP-4035NAVIGATE-HMO
CLMCLM-4285622026-02-09T03:29:49ZJanet—Howell20050311UHC-27476-62·NULLUNKNOWN·NULL2155 BASELINE RDSacramentoCA95820··GRP-9322null
CLMCLM-432275 2026-05-25T10:11:35ZAlexanderW.Adams1944-06-04UHC-12301-91N/A3475076915alexander.adams45@proton.me3714 CHURCH STREET··TEMPEAZ85295NULL··SELECT-EPO
CLMCLM-4140442026-07-03T19:55:03ZSTEPHENLLAWSONSep 3, 1974UHC-40167-97null8942114802—5405 VALLEY VIEW DRIVE #813Denver··CO80244GRP-3882UNKNOWN
CLMCLM-4145832026-07-08T10:37:47ZLaura—Howard03/08/1997UHC-87745-99•••-••-8551—UNKNOWN1777 Maple Avenue·CharlotteNC28257GRP-5881NULL
CLMCLM-4038132026-05-29T22:07:03ZBradley····Schmidt1999-09-02UHC-76297-90•••-••-4536N/ANULL-—·N/AUNKNOWNGRP-4579CHOICE-PLUS-PPO
CLMCLM-4225242026-08-12T03:07:44ZSOFIAJ.··HICKS1952-05-23—•••-••-0118—sofia.hicks90@yahoo.comnull—N/AUNKNOWN-select-epo
CLMCLM-4328142026-03-08T16:11:49ZJanet—Ryan1975-11-19UHC-91920-53-689-276-7753—-NULL--GRP-0830null
CLMCLM-4138362026-05-07T14:49:23ZGardner, Tyler——1995-06-13UHC3631634N/A+1 688 928 9513NULL····N/AnullNULLnull-
CLMCLM-4047342026-01-22T17:24:44ZANNAIMASON19720102NULLUNKNOWNNULLN/A1783 Main StAUSTIN··TX78797GRP-7245CHOICE-PLUS-PPO
CLMCLM-4001502026-03-02T10:57:30ZKATHERINE—JAMES1979-08-09UHC-89876-40•••-••-2614·(855) 558-0302katherine.james88@gmail.com8854 Highland Avenue··TempeAZ85251—UNKNOWN
CLMCLM-4034652026-05-23T01:07:56ZETHAN—ARNOLD2005-02-01NULL-6176874926··null1015 Oak StreetGilbert·AZ85286GRP-8012··-
CLMCLM-4158642026-02-13T17:22:48ZSCOTTQCOX1940-09-18·UHC-67372-25•••-••-1212-····UNKNOWN--UNKNOWNGRP-5132UNKNOWN
CLMCLM-4099862026-07-18T12:43:55Znicole—hayes1939-04-16—•••-••-0142(717) 872-0107··695 Apache BlvdPLANOTX75090-5655GRP-1530-
CLMCLM-4080302026-07-23T07:17:00ZVirginia—HughesAug 27, 1964UHC-52299-91•••-••-7216(348) 911-0886virginia.hughes@proton.me8827 LINCOLN WAYDENVERCO80238nullOPTIONS-PPO
CLMCLM-4295502026-01-08T10:42:57ZOlivia—Gutierrez1971-06-02UHC-58273-14N/A·3309738213-———null—NAVIGATE-HMO
CLMCLM-426506 2026-06-18T20:35:02ZJordan—Walker·1988-02-19UHC-96381-04•••-••-11102524509237N/A3465 UNION STREET #959COLUMBUSOH43291GRP-8224—
CLMCLM-4027792026-03-27T18:58:31ZMyers, Jacob——1991-07-11UHC-18643-77•••-••-2206790-292-3811NULLN/A····—NULLGRP-5025UNKNOWN
32,829 rows, page 173 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.606Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty