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-4056512026-01-10T00:43:33ZMaria—Griffin06/25/89UNKNOWNNULL—null··nullUNKNOWN·UNKNOWNNULLNULL-
CLMCLM-4276852026-07-09T21:10:44ZJESSE—PETERSON·1963-11-24—N/A8226045jesse.peterson61@outlook.com3424 MAPLE AVELos AngelesCA90098GRP-4256-
CLMCLM-4045882026-02-08T16:26:23ZAnna··Sanchez1977-11-26NULL--···UNKNOWN————GRP-2760OPTIONS-PPO
CLMCLM-4044662026-10-06T14:05:38ZDan—Carroll09/22/08UHC-28665-19•••-••-2636-UNKNOWN4534 HIGHLAND AVECharlotte·NC28286GRP-2081NULL
CLMCLM-4043422026-02-15T12:11:00ZEMILY—·BELL2008-06-26·UHC-21783-69•••-••-4816——1694 Harbor BoulevardNashvilleTN··37238-5552GRP-1892—
CLMCLM-4202952026-10-01T20:44:06ZSUSAN—JACKSON1985-02-10—•••-••-7588574-899-3895—1342 Mountain View Dr #681MesaAZ85280-—
CLMCLM-4146912026-05-21T06:58:14ZMEGAN—BURKE1980-12-16UHC-39787-28UNKNOWN2963527592NULL7111 OCEAN AVE Apt 35SeattleWA98128——
CLMCLM-4322352026-09-26T09:30:14Zaisha—gardner1969-09-06UHC-26182-08-··7864618—8538 Hillcrest RdSACRAMENTOCA95884GRP-8332NAVIGATE-HMO
CLMCLM-4160292026-05-29T22:17:21ZLuri—Gibson08/15/60N/ANULL(817) 425-9575UNKNOWN8161 Ridge Road··AustinTX78715—CHOICE-PLUS-PPO
CLMCLM-4236782026-01-28T02:46:13ZAdamBGriffin1984-03-08—•••-••-3218205.831.5730-nullnullUNKNOWN··NULL··—navigate-hmo
CLMCLM-4095462026-02-25T09:14:39Z Tucker, Douglas——08/22/1992UHC-89410-87UNKNOWNUNKNOWN-5520 Desert Sky BoulevardGlendaleAZ85372NULL—
CLMCLM-4267252026-07-29T03:27:40ZJanice—Duncan2003-08-22UHC-43398-21•••-••-9042212-571-4493—1469 Central AvenueLos AngelesCA90099N/A—
CLMCLM-4201532026-09-26T15:42:46ZRoy—Marquez2003-02-27UHC-81106-25•••-••-55147443027218-UNKNOWNNULLnullNULLNULLUNKNOWN
CLMCLM-4242572026-09-06T06:48:46ZKimberly··Jimenez1952-12-05UHC-97816-87•••-••-1658N/A-9412 OCEAN AVENUEDenverCO80249GRP-6598NAVIGATE-HMO
CLMCLM-4079892026-02-16T07:51:34Z·camila—sims1950-08-25-•••-••-8324null-6419 CEDAR LANEDENVERCO80222UNKNOWNSELECT-EPO
CLMCLM-4027032026-07-07T20:48:10ZDONNA··—RUSSELL1941-05-01—N/AN/Anull1862 Mesa DriveMIAMIFL33125-—
CLMCLM-4010442026-01-09T11:44:21ZCarolyn—Collins2001-07-24UHC8796121•••-••-1358892-903-8071N/A·null—NULL··GRP-0660····
CLMCLM-4313632026-01-19T23:37:21ZNicole—Gonzales1941-02-13UHC-80545-64•••-••-85748182614739NICOLE.GONZALES68@YAHOO.COM4175 Forest AvenueORLANDOFL32880nullMEDICARE-ADV-B
CLMCLM-4187352026-06-13T12:24:56ZRandy—Fisher26-01-1984··UHC-09845-24•••-••-1818840-554-7906NULL772 HARBOR BLVDAtlantaGA30393GRP-6206UNKNOWN
CLMCLM-4071402026-10-04T12:27:51ZAliceNSpencer03/01/67··—N/A5442120508null4684 Mountain View DrHOUSTONTexas77017N/AMEDICARE-ADV-B
CLMCLM-4194762026-05-08T20:37:46Zolivia—dunn09/23/1956··—•••-••-6701(250) 511-1244—7987 Central Ave #306ColumbusOhio43235GRP-7109—
CLMCLM-4115802026-04-10T04:56:55ZSAMUEL—WILLIAMSON1960-08-28—-UNKNOWNSAMUEL.WILLIAMSON@YAHOO.COM1245 Sage CtOrlandoFL32837GRP-9790MEDICARE-ADV-A
CLMCLM-4319432026-09-11T17:48:55ZWilson, Madison··—··1946-10-13UHC-30657-32N/A476.594.7630—1800 Lake View RdATLANTAGA30366··—MEDICARE-ADV-B
CLMCLM-4015612026-09-19T02:21:45ZElllis, Jessica——1963-07-27UNKNOWNN/A8886321549—2220 CENTRAL AVENUEFresnoCA93781GRP-6053UNKNOWN
CLMCLM-4184882026-09-13T16:03:16Z ·JULIA—PERKINS1945-03-26··N/A•••-••-1691-NULL··5328 Washington StreetTempeAZ85269··nullUNKNOWN
CLMCLM-4237562026-10-16T18:04:43ZBradley—Hughes5/25/1996null—6623825604—6130 LINCOLN WAYSan AntonioTX78234N/AMEDICARE-ADV-A
CLMCLM-4167492026-09-01T07:59:10ZLAUREN—RILEY01/08/1952UHC-01311-77•••-••-1921-null1156 Hillcrest RoadMinneapolisMNnullGRP-6480—
CLMCLM-408745 2026-04-18T17:54:21ZNoah—Carrlol11/02/1986UHC-13848-99•••-••-8968N/AN/A-NULL——N/AN/A
CLMCLM-4115502026-01-11T21:47:40ZGbarielTNguyen1949-04-25UHC-08946-13—UNKNOWNgabriel.nguyen47@aol.com··5009 Jefferson Ave Apt 29CHANDLER··Arizona85212GRP-7818N/A
CLMCLM-4055192026-06-14T10:55:48ZMICHAEL····FOX1970-80-04UHC-12651-41-3778292601—7268 Highland AveOrlandoFL·32893GRP-7924MEDICARE-ADV-A
CLMCLM-4062312026-06-26T03:53:48ZSchmidt, VictoriaZ—06/12/88UHC-00189-24—5377627244—4939 CHURCH STGilbertAZ85276N/A-
CLMCLM-402199 2026-10-01T12:36:15Z·BECKY—SANDOVAL1971-06-04UHC-77395-37NULL——7321 Pine DrEden PrairieMN55362GRP-0487CHOICE-PLUS-PPO
CLMCLM-4158802026-09-27T01:03:56ZStephanieRMontgomery1969-01-03UHC-27825-15nullnullN/A·8179 HARBOR BOULEVARDSan DiegoCA92173GRP-3482MEDICARE-ADV-A
CLMCLM-410345 2026-04-22T10:44:51ZGeorge··King19430406UHC-42827-67UNKNOWN18584800379—3734 Grand AveDenverCO80218N/Anull
CLMCLM-4028842026-02-21T00:14:07ZEmily—Robertson08/02/1947UHC-80611-21•••-••-1665504-297-8872N/A5836 Union StMinneapolisMN55491·NULL—
CLMCLM-4147762026-01-13T09:19:04ZPeters, Carol——1985-03-27UHC-96890-16•••-••-2371N/Acarol.peters@yahoo.com9826 Baseline RdSan Antonio·TX78215N/Anull
CLMCLM-4047322026-02-12T05:27:00ZANNRCOOK2002-01-18—•••-••-5665·UNKNOWN—6761 PARK PLFresnoCA93746··MEDICARE-ADV-A
CLMCLM-4243752026-01-18T08:59:12Zmari—bowman1966-12-13····—nullNULL6396 Indian School RoadEDEN PRAIRIEMN55375-8315·nullMEDICARE-ADV-B
CLMCLM-4129462026-08-21T19:00:14ZKyle—·Phillips1999-01-04—•••-••-4086—null····-·null—N/AUNKNOWN
CLMCLM-4094172026-06-23T03:50:07Zanna—hicks7/28/2000UHC-76951-41····——4474 Valley View Dr··MinneapolisMN55404GRP-8812NULL
CLMCLM-4180782026-07-21T01:10:21ZANA—MORGAN11-12-1970··UHC-89767-67•••-••-8889NULLNULL8899 BroadwayScottsdaleAZ85296GRP-7550CHOICE-PLUS-PPO
CLMCLM-4253712026-04-08T21:51:50ZLINDAHWILLIS1996-05-06UHC-42566-34•••-••-3995··null4422 UNION STREETDenverCO········MEDICARE-ADV-A
CLMCLM-4191722026-02-09T09:30:21ZFrank—Ramos1962-04-07—-nullUNKNOWN8980 RIDGE ROADLos AngelesCA90072GRP-4204CHOICE-PLUS-PPO
CLMCLM-4037332026-01-07T05:19:59Z KathrynSWang01/19/2007—•••-••-2472—kathryn.wang93@icloud.com7432 MOUNTAIN VIEW DRChandlerAZ85216-5595GRP-7276—
CLMCLM-4089252026-02-13T09:41:04ZBarbara—·Austin1954-11-01UHC-00126-43UNKNOWNnull-·7031 Market StOrlandoFL··32887-4269null-
CLMCLM-4078812026-01-23T18:06:31ZJooseph—·Gardner2002-05-07UHC-79742-33—N/AN/A520 Ocean AvenueSan Diego··CA92120—CORE-HMO
CLMCLM-4044022026-07-26T20:21:19Zliisa—campbell10/22/1965N/ANULL673-271-7388lisa.campbell@icloud.com1629 PINE DR·DenverCO80275—UNKNOWN··
CLMCLM-4057052026-02-24T07:26:51ZDorothy·X.Stone2007-02-01UHC-43891-11UNKNOWN··—·UNKNOWN1753 Sage CtMiamiFL33122··GRP-1045MEDICARE-ADV-A
CLMCLM-430354 2026-04-07T02:55:45ZDaniel—·Castillo05/16/1949UHC-74193-54N/A—null—NULL-—GRP-0812SELECT-EPO
CLMCLM-4274802026-05-27T11:21:05ZWayne X—Castillo03/05/57·UHC-95042-59—7266870—-nullNULLnullGRP-0218MEDICARE-ADV-A
32,829 rows, page 2 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-19T19:54:25.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty