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-4081092026-02-15T23:41:27ZRalph··Lewis1950-07-23UHC-43255-16•••-••-0760·538-486-0436N/A8899 MOUNTAIN VIEW DRIVEFRESNOCA93752NULLnull
CLMCLM-4124052026-07-20T21:35:19ZKATHLEEEN····RYAN1941-07-27uhc-93566-19null577.346.1486N/A5311 Washington StLas VegasNV··89102GRP-2673CORE-HMO
CLMCLM-4082062026-02-27T08:25:42ZBrena—Murphy1945-08-12UHC-42123-95null-—8362 River RdFresnoCA93776GRP-3362null
CLMCLM-4127532026-02-16T18:45:05ZPRIYA—SPENCER20070127UHC-46670-64•••-••-3510(965) 377-5496—252 Apache BoulevardHoustonTX··77015GRP-0589SELECT-EPO
CLMCLM-4230132026-07-19T06:42:32ZHIROSHI—PETERSON1968-09-04UHC-61159-02—N/A—2708 Oak StMiamiFL···33131nullnull
CLMCLM-4325652026-10-11T02:46:35ZCheryl—Carr1981-12-11UHC-85484-89-N/AN/A-——nullNULL·OPTIONS-PPO
CLMCLM-4075812026-05-02T03:29:51ZAlice—Murphy28-09-1967UHC-19582-46N/A(351) 885-4451NULL——NULLNULLGRP-0770navigate-hmo
CLMCLM-4070072026-03-20T07:47:53ZEmily···Silva12/22/1976··UHC-43687-71•••-••-5895····null4265 UNION STREETLOS ANGELESCA90067UNKNOWN-
CLMCLM-4200312026-03-03T20:32:13ZWALTER—VAZQUEZ0905-02-05—•••-••-9537-walter.vazquez19@outlook.com—null—UNKNOWNGRP-1162-
CLMCLM-4172972026-08-20T12:50:49ZLawrence··—Chapman1975-10-20··null—LAWRENCE.CHAPMAN22@YAHOO.COM3172 Ocean AveAustintx78770-0133null—
CLM CLM-4022102026-02-23T21:24:55ZAlexis—Shaw2006-03-21null•••-••-9173UNKNOWN—7789 Union StreetLOS ANGELESCA··90090null—
CLMCLM-4014622026-01-18T10:35:09ZAmanda—Barnes07/20/68··UHC-91250-79-————-—-options-ppo··
CLMCLM-4163082026-03-19T10:20:18ZNICOLE—LTITLE·1984-04-07UHC-13450-33-(207) 256-3145····4572 Grand AvenueHouston··TX77011GRP-0775UNKNOWN
CLMCLM-4065522026-09-14T07:32:21Z MARTHA—STONE2000-11-11—UNKNOWNUNKNOWN—1311 Hillcrest RdGlendaleAZ85387GRP-9429NAVIGATE-HMO··
CLMCLM-4112232026-01-08T06:20:42Z·Donald—Russell22-02-1974—•••-••-6302—UNKNOWN5913 Maple AveHouston··TX77046GRP-6847-
CLMCLM-4076492026-05-04T15:09:47ZAustin—Stone1957-12-23—nullN/A-5773 Cedar LnMiamiFL33104GRP-7147—
CLMCLM-4268062026-01-20T20:18:10ZJessica—Williamson19630919····•••-••-8168442-933-8171UNKNOWN832 Canyon RdJACKSONVILLEFL32255-0806GRP-2153N/A
CLMCLM-4071672026-10-03T06:13:45ZRoger—Jackson·1949-04-16UHC-80282-80-2054284245UNKNOWN-——NULLGRP-5135····
CLMCLM-4020732026-05-16T01:12:50ZJACK—SANCHEZ1979-09-16UHC-62801-89—(673) 981-7625-—-UNKNOWNN/A··GRP-8445CORE-HMO
CLMCLM-4013342026-08-22T06:20:37ZANDREW—FIELDS23-03-1995UHC-34165-43•••-••-1926NULLN/A3129 Main StJacksonville·FL32261GRP-4317··CORE-HMO
CLMCLM-4277752026-03-24T00:34:54ZCHRIS—VALDEZ1969-03-12UHC-20572-11null857-399-1733null———··-—
CLMCLM-4120522026-03-19T10:18:09ZLarryS.Carlson1968-09-07UHC-21900-73•••-••-7442null—9728 Camelback RdSAN DIEGOCA92144UNKNOWN····
CLMCLM-4021532026-09-22T05:28:56ZMary—Hansen11/20/1961-•••-••-7354988.505.1853—263 Lincoln WayORLANDOFL32884GRP-7001—
CLMCLM-415767 2026-08-03T06:26:50ZCastro, Mazon——9/28/1957UHC-01653-72NULL764-403-9675··null4926 Main StreetAustinTX78768GRP-6170CORE-HMO
CLMCLM-4087112026-08-13T23:09:53ZvirginiaJ.le1/16/1958N/A•••-••-4982—virginia.le78@hotmail.com4073 Forest AveSCOTTSDALEAZ85218GRP-9138MEDICARE-ADV-B
CLMCLM-4044062026-06-29T16:59:48ZAliceX.··Morris19950609UHC-55977-01•••-••-4439680-960-2952null9349 Ocean Avenue··ChandlerAZ··—NULLUNKNOWN
CLMCLM-4144672026-02-09T10:09:08ZAllen, Bill——1953-06-12UHC-46233-87•••-••-8473-null430 Highland AvenueDallasTX75267—UNKNOWN
CLMCLM-4203722026-10-11T06:07:21Zsantiago—johnston1947-06-08··UHC-07734-93N/A691-498-0202NULL8790 PALM DRIVEGilbertAZ85246·GRP-6959CORE-HMO
CLMCLM-4152872026-05-17T15:18:00ZKnight, Albert····—1994-08-07··UHC-52355-58•••-••-24564567633737—6424 Mesa Dr·TempeAZ85229GRP-7233UNKNOWN
CLMCLM-407216 2026-07-05T14:01:23ZTheresa—Espinoza20-02-1979UHC-67186-14•••-••-1047+1 387 910 1465—8697 MOUNTAIN VIEW DROrlandoFL32873··——
CLMCLM-4299812026-08-15T12:17:36ZWilliamson, SusanH—2008-12-09-—886-728-4774—2677 Hillcrest RoadSacramentoCA95846GRP-4811null
CLMCLM-4113572026-10-01T15:38:17ZTheresa—Ferguson2000-05-07UHC-58580-76··•••-••-1188nullN/A·9633 PALM DRIVETucsonAZ85712—OPTIONS-PPO
CLMCLM-4104822026-09-08T21:08:49ZBishop, Sean——1972-02-13null——UNKNOWN-··NULL—GRP-6098—
CLMCLM-4176112026-08-01T01:33:22ZMeiXFlores2007-05-08null•••-••-8379(793) 797-0176—129 Union StFresnoCA93787GRP-8277NULL
CLMCLM-4111802026-04-17T03:19:07Zkeith—jones1956-01-16UHC-84478-19NULL—N/A4325 Church StreetGilbertAZ85296GRP-7605·N/A
CLMCLM-4216812026-03-06T20:35:55ZabigailDtorres1988-06-24NULL•••-••-1329(702) 376-7456UNKNOWN4342 Washington St··SEATTLEWA98183GRP-3002OPTIONS-PPO
CLMCLM-4218312026-10-08T10:16:41ZCarl—Santos19880304—null309-274-7997—967 Valley View DriveTempeAZ85227UNKNOWN··MEDICARE-ADV-B
CLMCLM-4046822026-07-17T09:34:44ZElizabeth—Johnson1983-02-26UHC-01763-99—NULLN/A1899 BROADWAYNashvilleTN—GRP-6860MEDICARE-ADV-A··
CLMCLM-4194372026-04-16T03:27:53ZAdam—Henry1946-11-28UHC-90187-32UNKNOWNN/AN/A580 MOUNTAIN VIEW DRTEMPEAZ85231GRP-2360N/A
CLMCLM-4037132026-07-05T22:02:22ZDiana—Meeyer2004-60-16UHC-82280-75•••-••-4566907-519-8026UNKNOWN5374 Sunset BlvdTucsonAZ—GRP-5407NULL··
CLMCLM-4165212026-02-20T06:46:28ZFisher, GraceV.—1971-03-01UHC4438991•••-••-7505331-373-6736-—N/AUNKNOWN—GRP-2346CHOICE-PLUS-PPO
CLMCLM-4011572026-02-04T04:26:59Zalexander—porterJun 8, 1991UHC-74328-83—·9092633495—6276 Mesa DrMesaAZ85264——
CLMCLM-4287972026-03-26T22:59:04ZWeaver, Russell——1962-04-14UHC-60979-31•••-••-594018425905281—3160 Pine Dr #798PhoenixAZ85016GRP-2916—
CLMCLM-4282182026-03-22T03:41:46ZFox, Keith—····1975-03-08UHC-46336-96N/A403-622-7000—3150 Willow CtColumbusOH··43284GRP-8050SELECT-EPO
CLMCLM-4064312026-05-27T12:31:34ZGrant—Kyle··19970608··NULLN/AN/A-9500 Ridge Rd··NashvilleTN37211GRP-2282MEDICARE-ADV-B··
CLM CLM-4111632026-01-13T23:27:58ZKellly—SmithMar 27, 1992UHC-61111-64·-766-913-3363NULL3349 Sage CourtORLANDO··FL32889N/ACORE-HMO
CLMCLM-4226072026-09-08T21:27:47ZMEGAN—CARTERSep 14, 1953UHC-16129-53—NULLUNKNOWN2354 CANYON ROADTucsonaz85771GRP-0695CORE-HMO
CLMCLM-4163572026-06-09T22:22:04ZBrittanyNSandoval09/12/86··UHC-58967-66—(569) 304-9470null··7061 Bayshore DrChandlerAZ—GRP-6511-
CLMCLM-4090332026-04-05T06:42:59ZCatherine—Gordon91951123UHC-95390-20—·579.567.4765UNKNOWN8861 River RdAustin·TX78780—MEDICARE-ADV-B
CLMCLM-4206972026-07-16T18:42:56ZSARAH—HILL1954-06-20UHC-70738-77•••-••-66347535001484N/A9678 MARKET STREET··CHARLOTTENC28281-NULL
32,829 rows, page 120 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:38.488Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty