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-4037562026-01-10T17:03:18ZAmyKAlvarado1976-08-13—N/A622.493.9984null4689 SPRING STLas VegasNV·89132—-
CLMCLM-4229622026-10-11T21:56:22ZDebra—Hoffman20-03-1983N/A•••-••-8723577-267-0292-7106 Apache BoulevardTAMPAFL33631GRP-5315·null
CLMCLM-4137892026-07-03T04:01:15ZAlice··—Baker·1952-04-16UHC-01066-48•••-••-0987—ALICE.BAKER@HOTMAIL.COM2666 CHURCH STREETGilbert·AZ—·GRP-5877SELECT-EPO
CLMCLM-4287942026-08-22T08:56:02Z Ralph—Bradley27-07-1980UHC-94420-89N/A—RALPH.BRADLEY@PROTON.MEUNKNOWN····null—GRP-1796NULL
CLMCLM-4005452026-08-02T23:10:18ZTYLER—MORENO11/12/1994UHC-79913-58—NULLNULL1312 Ridge RoadSEATTLEWA··98120GRP-7084—
CLMCLM-4240442026-10-18T16:16:25ZRobertson, Alexander——01-05-1986UHC2083208UNKNOWN(556) 686-5045—-nullnull·NULLGRP-1960N/A
CLMCLM-4052202026-01-02T20:20:41ZDixon, NathanX—2/20/1966UHC-50338-25•••-••-1232697-213-8335-··———null—CORE-HMO
CLM CLM-4099912026-01-02T19:28:21ZWashington, Mark——1964-09-02UNKNOWN-(912) 251-5141·UNKNOWN4833 Grand AvePhoenix··AZ85062NULLSELECT-EPO
CLMCLM-4001932026-01-21T00:37:44Z sharonC.patelSep 8, 1955UHC-61755-29·-NULLnull400 WASHINGTON STREETChandlerAZ85207NULLNAVIGATE-HMO
CLMCLM-4007082026-03-14T00:31:50Z KarenTRojas··1996-05-21UHC-95344-65•••-••-0393+1 903 838 4737—6039 SAGE CTMiamiFL33184-0200GRP-2673UNKNOWN
CLMCLM-4307132026-03-01T12:29:39ZBrittany—Banks1948-07-03UHC-86957-86•••-••-308019155051099null493 CAMELBACK ROADOrlandoFL32858N/A—
CLMCLM-4276222026-07-27T20:52:06ZJoes—Bradley·2004-11-02—•••-••-4894nullUNKNOWN2268 Ocean AveMinneapolisMN—GRP-7052CORE-HMO
CLMCLM-4138232026-10-16T14:57:04ZMadison—Jenkins05-01-1983-UNKNOWN4434743157N/Anull—NULL··—·GRP-9272·MEDICARE-ADV-B
CLMCLM-4130532026-01-22T14:32:48ZDeborahO.Godron1941-05-26·UHC-25069-01•••-••-26823398306272·DEBORAH.GORDON91@PROTON.ME6829 RIDGE RDHoustonTexas77007GRP-0932CORE-HMO
CLMCLM-4179612026-06-18T21:09:52ZJean—Bell1964-07-22UHC-53803-37UNKNOWNnull-—NULL——··null
CLMCLM-4297142026-09-24T23:53:15ZGloria—Martin1989-09-15UHC-38570-43--—6216 Canyon RdMiamiFL33155GRP-6616MEDICARE-ADV-B
CLMCLM-4250952026-08-14T15:21:53Z PaulGLuna·1974-05-11UHC-71549-96•••-••-73029529945118UNKNOWN——N/AUNKNOWNN/A—
CLMCLM-4309282026-03-25T11:41:41Zjason—meyer·20021220UNKNOWNUNKNOWN3083924589—N/ANULL········null··N/A
CLM CLM-4167742026-06-26T13:39:11ZMelissa—Guzman1940-11-15—-16897151731NULL·998 BROADWAYMinneapolis··MN55459—MEDICARE-ADV-B
CLMCLM-4002922026-10-04T09:56:46ZEmma—Hill1974-02-09··UHC-72136-54•••-••-218319835648155-5231 Central Ave·TempeAZ85242-4088GRP-4024MEDICARE-ADV-A
CLMCLM-4063532026-01-07T03:09:20ZJanice—·Hunt1974-12-06··UHC-70664-95•••-••-9721544-815-4823N/A3006 Pine DriveCHANDLERAZ85247null··SELECT-EPO
CLMCLM-4245382026-01-05T03:53:58ZScott, MarkE—1987-01-02—N/A(743) 839-7420··4446 WASHINGTON STREET··TucsonAZ85792GRP-6868MEDICARE-ADV-A
CLMCLM-4180002026-09-14T03:54:58Z·Hiroshi—Little19730728UNKNOWN•••-••-24292134738946null1360 RIVER RDAtlantaGA··30305—NULL
CLM CLM-4058092026-08-28T01:59:14Z·NANCY—DELGADO06/14/53UHC-60245-45——·N/A452 Harbor BlvdNashvilleTN37208·-OPTIONS-PPO
CLMCLM-4039982026-05-26T12:14:34Z·AMBER—RICHARDS07/21/78UHC-43880-34UNKNOWNNULLNULLnullN/A—NULLGRP-2553N/A
CLMCLM-4098622026-07-26T05:33:40ZABIGAIL—VARGAS2005-06-26null-NULLabigail.vargas56@gmail.com3980 Willow CourtCharlotte·North Carolina28296·GRP-6919—
CLMCLM-4106852026-09-15T15:57:39ZTHOMAS—MYERS1988-01-26·UHC-75619-36•••-••-7674798-444-6750thomas.myers27@aol.com4476 Desert Sky BlvdATLANTAGA30353GRP-8160—
CLM CLM-4025102026-08-15T11:34:19ZOlivia—Hunt1987-09-16—UNKNOWN5355722990-4796 Hillcrest RdAtlantaGA—·GRP-9019CORE-HMO
CLM CLM-4292862026-10-11T22:28:48Z bobby··—wilson1994-01-12—UNKNOWN··NULL-UNKNOWNN/A-nullGRP-7897UNKNOWN
CLMCLM-4027372026-07-02T14:24:36ZSteven—Ortiz08/10/1954UHC-99424-41——-7834 Camelback RdJacksonvilleFL32224·N/A·MEDICARE-ADV-A
CLMCLM-4235752026-03-09T20:56:03ZDouglas—·Daniels1957-01-06UHC-43682-30·UNKNOWNN/ANULL3223 Washington StreetDenverCO—GRP-2849NULL
CLMCLM-4180532026-10-12T11:15:07Zkaren—anderson1974-08-20UHC4886586•••-••-6666(317) 501-9423null3300 Mountain View DrLos AngelesCA90049GRP-3758CORE-HMO
CLM CLM-4107152026-05-25T13:58:12ZHarold··Nelson9/18/1971-—3195965425—918 ELM STREETAUSTINTX78796GRP-0183SELECT-EPO
CLMCLM-4106942026-08-20T05:38:45ZDavid····Woods12/12/07··—UNKNOWN+1 571 675 3261NULL9773 Washington St Apt 24San AntonioTX78283-3457·GRP-5030SELECT-EPO
CLMCLM-4093992026-04-10T23:01:21ZFowler, StephenM—2001-09-27·UHC-96013-13•••-••-1021600-797-8481null—NULL——GRP-6067SELECT-EPO
CLMCLM-4089482026-09-14T21:46:28ZStephens, Seean——12/23/1961UHC-73604-61NULL(970) 800-2977null8270 Desert Sky BlvdMesaaz85282-—
CLMCLM-4258182026-09-08T22:30:15ZWagner, Christine——·2/28/1989N/A-(746) 680-6351N/A8466 JEFFERSON AVETucsonAZ—GRP-7795N/A
CLMCLM-4059202026-07-03T23:07:31ZJAMES—·HAMILTON09/27/1994--—null2485 Mountain View DriveLos AngelesCA··90040nullN/A
CLMCLM-4199402026-02-18T13:06:47Z GloriaSLee05-09-1988null—15609335158··2438 Sunset BlvdLOS ANGELESCA90068··N/A—
CLMCLM-4300212026-02-18T23:46:09Z·Mason—Santaigo19891206UHC4496259•••-••-6002UNKNOWNnullNULLUNKNOWNN/AnullGRP-4856MEDICARE-ADV-A
CLMCLM-4290652026-06-08T22:07:27ZLauren—Silva—UHC-22401-06—+1 248 749 8456lauren.silva70@aol.com7322 Ocean AvePhoenixAZ85099-7915··—UNKNOWN
CLMCLM-4290722026-08-15T08:46:32ZSEAN··—PAYNE··Oct 8, 1996UHC-09440-80null(703) 786-3702—5135 Sage CtTempeAZ85211—MEDICARE-ADV-A
CLMCLM-4101382026-05-08T02:56:39ZSamuel··Tucker1993-06-19UHC-53744-28—2689716961SAMUEL.TUCKER@GMAIL.COM·5881 Apache BoulevardChandlerArizona··85224GRP-7322—
CLMCLM-4322212026-05-30T07:31:17ZJerry—Chapman1997-09-24UNKNOWNUNKNOWN(921) 982-5498UNKNOWN5719 Lake View RoadMiamiFL·33199GRP-5070··N/A
CLMCLM-427386 2026-07-14T10:11:55ZMeiVVasquez1958-03-22N/A··UNKNOWN-mei.vasquez@aol.com—null—·N/AGRP-8142····
CLMCLM-4267752026-01-12T20:57:23ZBradley—Weber1991-06-17UHC-33663-44N/A722-482-9611—6986 PINE DRIVEMiamiFL33102GRP-6741NULL
CLMCLM-4227302026-07-03T23:49:12ZFuller, Benjamin——1964-03-15····-+1 216 273 9017null4702 Spring StNashvilleTN·37237GRP-7658MEDICARE-ADV-A
CLMCLM-4117072026-01-26T17:34:01ZAdnrea—Guerrero·Sep 12, 1953N/A-+1 408 450 0877··UNKNOWN345 Hillcrest Rd Apt 22JacksonvilleFL32217-NULL
CLMCLM-4309742026-03-10T12:48:51Zdiane—olson11-07-1981—•••-••-1304··null4637 Lake View Road #174JacksonvilleFL32257GRP-3112CHOICE-PLUS-PPO
CLMCLM-4152632026-07-24T06:20:49ZPamela—Vargas01/23/1976-•••-••-9974UNKNOWNN/AN/A—UNKNOWNN/A·GRP-6109UNKNOWN
32,829 rows, page 24 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:34.793Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty