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-4052772026-02-03T21:35:57ZSophia····Rojas1998-07-08UHC-02551-98•••-••-9035+1 863 544 0636····2983 Canyon RoadColumbusOH43274-—
CLMCLM-4069422026-01-11T08:01:13ZNatalie—Riley1951-12-26-•••-••-8516-null9343 RIDGE RDSeattleWA··—·N/A
CLMCLM-4044552026-07-13T02:06:00ZLARRYFMARTIN01/13/01UHC-92470-78null874.345.3111N/A4620 Valley View DrSan AntonioTX78256GRP-9683·N/A
CLMCLM-4219362026-07-22T15:30:16ZWeiPFields1959-12-24—•••-••-6719218-678-4775··5344 Church StreetLos AngelesCA··90051GRP-4190MEDICARE-ADV-B
CLMCLM-4077912026-05-05T01:45:05ZJonathanOMaldonado2002-06-14—null+1 920 313 0265—7897 Highland AveScottsdaleAZ85221GRP-0956··—
CLMCLM-4276022026-05-07T02:07:52ZTimothy—Rios1981-09-26UHC-27057-19—-··2391 Desert Sky BlvdFresnoCA93766GRP-7410—
CLMCLM-4167812026-01-30T11:42:25ZKaren—Meyer09-12-1970UHC-87829-83—6386826572-211 Ridge RdAtlantaGA30338-1854GRP-8996SELECT-EPO
CLMCLM-403197 2026-02-06T02:11:01ZAlice—Ruiz2004-04-27UHC-37375-91··N/AN/AN/A··UNKNOWN-—GRP-8786MEDICARE-ADV-B
CLMCLM-4237282026-09-29T11:23:04ZGRACE—HICKS1993-10-19—nullNULLnull5443 MESA DRFresnoCA93756—-
CLMCLM-4050992026-07-27T17:12:01ZMARILYN—ROMERO·1954-08-02uhc-22595-40—N/A··—2973 Main Street #195Eden PrairieMN55338GRP-8296null
CLMCLM-4111972026-07-13T09:52:08ZROY—OLSON12/13/1956UHC-80127-17•••-••-998912272189033—1270 Sunset BlvdSacramento·CA95897—N/A
CLM CLM-4037182026-07-25T09:31:50ZMATTEHW··—SNYDER2004-11-13····—-UNKNOWN7898 Sage CourtMiamiFL·33143GRP-7621—
CLMCLM-4076852026-01-08T13:30:54Z VIRGINIA—BRYANT1985-11-05UHC4346744··—459-460-9924VIRGINIA.BRYANT@GMAIL.COM9360 Apache BlvdAtlantaGeorgia30356UNKNOWN—
CLMCLM-4195492026-03-07T15:00:28ZBryan—Walker·10-11-1962UHC-62381-32-·8027789037N/A385 OAK STREETMiamiFL33144-MEDICARE-ADV-A
CLMCLM-4066812026-07-26T13:52:34ZJohnny—Little1968-05-02UHC-51193-40null·NULLUNKNOWN·1768 Maple AvenueGilbertAZ-·GRP-1747—
CLMCLM-4287002026-08-26T19:31:30ZSUSAN C—HAMILTON1983-12-09·UHC-49973-47——N/A4288 Church StSacramentoCA95810GRP-7961—
CLM CLM-4028422026-06-20T15:36:46ZMason—Welch1962-03-01··UHC-98549-20•••-••-6828UNKNOWNmason.welch46@proton.me2807 CANYON RDJacksonvilleFL32276GRP-8144····
CLMCLM-4003852026-04-21T21:07:38ZAlice··Hall2/9/1966NULL····451-322-7980··—N/A—N/AnullGRP-1224OPTIONS-PPO
CLMCLM-4320592026-03-06T15:13:00ZkevinPhughes07/02/1944uhc-58283-90N/A—null7328 Bayshore Drive #332GlendaleArizona85319-null
CLMCLM-4129392026-07-20T19:21:43ZMARIANA—SULLIVANJan 4, 2006N/A··—nullNULLN/A——nullGRP-9972NAVIGATE-HMO
CLMCLM-4097542026-04-10T23:20:06ZPatriciia—Phillips1963-07-20UHC-92486-54··-(856) 884-7797————-GRP-6759navigate-hmo
CLMCLM-4043112026-08-19T02:36:37Zmegan—fox·1971-06-23·UHC-06501-28—+1 398 256 1019megan.fox@outlook.com7489 Union StGlendaleAZ85320GRP-3314MEDICARE-ADV-B
CLMCLM-4299892026-02-26T01:12:45ZRYAN—WILLIS1951-07-07UHC-67623-04•••-••-4066·220-257-8544—5630 MAPLE AVEJacksonville·FL32249—-
CLMCLM-4319462026-06-06T07:49:35ZDIANE—GONZALEZ4/13/1939UHC-47195-70•••-••-9946666-998-7737NULL1437 RIVER ROADMiamiFL33156·-NULL
CLMCLM-416779 2026-02-01T09:36:43ZADAM····LI1945-01-18UHC-03793-43•••-••-8984378-254-6894NULL51 Oak Street #934HoustonTX77050NULLMEDICARE-ADV-A
CLMCLM-4233542026-01-12T17:39:11ZCynthiaALuna1962-05-06UHC-52161-93NULL9673933823—8928 Oak StreetGILBERTAZ85267GRP-3423—
CLM CLM-4275492026-05-23T22:06:55ZDorothy—George·03/04/55UHC-73922-65--·NULL2036 Camelback RoadDenverCO80219—-
CLMCLM-4246702026-04-15T02:45:40ZMarcus—Parker1940-09-01UHC-00441-29•••-••-7856426.624.1266······N/A-UNKNOWNnull——
CLMCLM-4042172026-01-16T16:51:38ZLAWRENCE—HARRIS2008-04-03UHC-52485-42N/A+1 414 417 2685··lawrence.harris25@outlook.com2714 Elm StreetMESAAZ85275GRP-1290MEDICARE-ADV-A
CLMCLM-4264882026-01-11T12:54:15ZSean—Jones05/03/47—•••-••-5871320-777-8085-··8932 Hillcrest RoadMESAAZ85286N/A··NULL
CLMCLM-4056862026-09-15T12:32:25ZJerry····Lynch12/27/78UHC-81730-62NULLNULLN/A·5218 Broadway Apt 32MiamiFL33112-7550GRP-8966·SELECT-EPO
CLMCLM-4231062026-05-28T21:42:01ZjudyGwelch1968-06-08·UHC-74292-52•••-••-8948null······5041 Palm DrivePhoenixAZ85055—UNKNOWN
CLMCLM-4325142026-08-18T14:09:38ZRonaldFHanson1971-03-24UHC-39935-64•••-••-6726nullRONALD.HANSON@YAHOO.COMnullnullN/A·-GRP-7246·MEDICARE-ADV-A
CLMCLM-4086332026-02-19T19:46:29ZVALENTINA—MITCHELL1995-06-21··uhc-63873-04•••-••-2504758-601-0060-9613 Lincoln WayMiamiFL33130—-
CLMCLM-4324122026-08-27T14:47:12ZJudy—Henry·19870503nullnull·4822949035UNKNOWN1612 Forest Ave #114TempeAZ··85263N/A—
CLMCLM-4155172026-01-02T10:44:31ZJason—Rios2008-12-12UHC-15718-04null··—JASON.RIOS69@OUTLOOK.COM3062 GRAND AVECHANDLERArizona85216GRP-0607—
CLMCLM-4169812026-07-12T09:48:47ZSarah—Banks1980-10-22—NULL592.992.2729sarah.banks82@proton.me3771 LINCOLN WAY·HoustonTX77001GRP-6042—
CLMCLM-4293812026-10-10T14:49:55ZMargaretCMorgan1939-09-25UHC-97317-10nullnullN/A··4818 Church StreetJacksonvilleFL32274nullNAVIGATE-HMO
CLMCLM-4325292026-07-04T20:44:12ZrobertNlewis12-06-1938UHC-97618-20··nullnullN/A1524 OAK STSACRAMENTOCA95858——
CLMCLM-4193482026-05-04T04:01:51ZDYLANF.OBRIEN1981-08-09UHC-90466-34··N/Adylan.obrien@icloud.com4022 Meadow LaneFresnoCA93761GRP-5228CORE-HMO
CLMCLM-4227582026-04-02T08:30:05ZLUCIA····WASHINGTON··06/19/1972UHC-13607-07null—lucia.washington@yahoo.comN/ANULLnullN/AGRP-9046N/A
CLMCLM-4299152026-09-09T11:18:23ZSoto, Melissa——1979-06-25null·NULL—NULL—N/ANULL——SELECT-EPO
CLMCLM-4105792026-03-11T10:04:19ZJack—Henderson06/16/1954UHC-16606-32-nulljack.henderson@proton.me5249 Union StFresnoCalifornia93775GRP-7837N/A
CLMCLM-4046582026-01-02T03:43:52Zolivia—padilla1998-05-26—NULL·644-401-4155N/A9203 River RdSan DiegoCA92139GRP-1191—
CLMCLM-4062602026-02-08T13:31:17ZSophia—Lynch1967-10-21NULLN/A7369644069NULL2211 HARBOR BLVDMESAAZ85279·GRP-9630—
CLMCLM-4053522026-10-08T04:46:19ZSantiago—Gardner1988-07-05—•••-••-1400—-628 Oak StreetSan AntonioTexasnullN/AOPTIONS-PPO
CLMCLM-4129722026-04-21T04:33:07Z ·KathleenL.Morgan·1960-02-04·UHC-81508-93NULL(487) 320-9652—2706 Elm StreetDenver·CO80284GRP-4371CORE-HMO
CLMCLM-4179652026-08-08T01:48:18ZSofia—Ramirez1976-11-13—NULL482.661.5372N/A8190 Camelback Rd #946JACKSONVILLE··Florida—NULLMEDICARE-ADV-A
CLMCLM-4110302026-01-17T01:30:10ZDebraV.Vargas1992-12-13··UHC-32301-47NULL7427833185NULL7717 Hillcrest RdTEMPE·AZ85269UNKNOWNUNKNOWN
CLMCLM-4323002026-07-15T17:49:51ZLara—Dunn··1946-12-16UHC-26938-12•••-••-9013UNKNOWN—8726 Apache BoulevardPlanoTX75092GRP-1591-
32,829 rows, page 148 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.333Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty