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-4284762026-07-23T13:36:01Z Betty··—Shaw1991-09-25NULL•••-••-3401·17908192366N/A8709 Pine DriveScottsdaleAZ85289-NAVIGATE-HMO
CLMCLM-432403 2026-03-07T01:27:29ZROBERT—HENDERSON1946-08-15UHC-11747-70•••-••-8198·nullUNKNOWN———UNKNOWN—-
CLM CLM-4135642026-10-17T23:12:24ZRoberts, SophiaV.··—1977-02-18—•••-••-3058616-253-7893sophia.roberts@icloud.comUNKNOWN———GRP-3232CORE-HMO
CLMCLM-4259332026-08-24T03:07:56Z janet—wells1987-07-25UHC-54496-81•••-••-0357nullN/A4618 Ridge RoadLos Angelesca90055—MEDICARE-ADV-B
CLMCLM-4300812026-06-18T22:39:11ZAndrea—Lee1994-12-25UHC-63035-08•••-••-03006999730N/ANULL··—-nullGRP-6309OPTIONS-PPO
CLMCLM-4096262026-03-20T23:44:07ZANN·····KELLEY01/18/1967UHC-38082-71•••-••-4249NULLann.kelley@gmail.com2306 Union StreetScottsdaleAZ85236GRP-3329NAVIGATE-HMO
CLMCLM-4210582026-06-03T15:22:14ZSam—Benentt7/10/1946UHC-99610-72•••-••-5296—nullN/AnullUNKNOWN-GRP-5266-
CLMCLM-4270462026-10-04T04:59:13ZHiroshi—Martinz08/16/1993UHC-21659-34•••-••-2583899.271.4513null6792 Valley View DrFresno·CA93756··GRP-6003NULL
CLMCLM-4212002026-09-11T03:44:28ZGuzman, Madison——2008-05-25UHC-78690-13—N/A—9638 Park PlGLENDALEAZ85311-NAVIGATE-HMO
CLM CLM-4096552026-07-22T16:41:11ZDilan—BerrySep 18, 1983N/A--dylan.berry@aol.comnull--··nullSELECT-EPO
CLMCLM-4261492026-02-22T01:27:34ZBrandon—George10/7/1968UHC-49996-19•••-••-5170——UNKNOWNN/AN/AnullN/A—
CLMCLM-4113482026-01-11T08:30:11Zalexander—ray1996-05-06—N/A(668) 369-0258··5159 RIDGE RDTampaFL33639··GRP-8560null
CLMCLM-4218232026-05-01T07:19:26ZarjunPevans1979-02-19UHC-02954-72—291-357-4271--—N/AnullGRP-4127MEDICARE-ADV-B
CLMCLM-4210962026-02-23T18:15:00ZMichelle—Jacobs1956-04-06UHC-37499-83null(334) 449-0345michelle.jacobs55@outlook.com8321 Mountain View DriveChandlerAZ85209GRP-7866null
CLMCLM-4254982026-08-31T11:40:07ZHenry, Amber—··Jul 12, 1992UHC-75407-58•••-••-4285—NULL5490 Indian School Road··ChandlerAZ85206GRP-5465NULL
CLMCLM-4047352026-09-15T13:38:05ZAnna—Mason1972-01-02UHC-45165-10UNKNOWN··NULLANNA.MASON7@ICLOUD.COM1783 MAIN STAustinTexas78797GRP-7245CHOICE-PLUS-PPO
CLMCLM-4292172026-06-07T18:56:31ZNOAH—ROBERTS05/10/03·UHC-80842-50N/AN/A—·null--—GRP-7106—
CLMCLM-4020582026-05-08T08:17:04ZKaylaACook1984-01-02··UHC-36140-39•••-••-5061NULLnull6035 Washington StDallas··TX75288GRP-3536OPTIONS-PPO
CLMCLM-4048692026-02-07T16:08:45ZCatherine—Dean1996-07-17UHC-12425-81•••-••-7552+1 738 994 2638UNKNOWN3457 BroadwaySan AntonioTX78206GRP-7903N/A
CLMCLM-4263632026-08-09T13:49:47ZAndrew··Woods1983-08-22NULL•••-••-1018null—5260 Grand AveLAS VEGASNV89104GRP-3914MEDICARE-ADV-A
CLMCLM-4095312026-06-07T03:28:15ZKELLY—WAGNER1955-03-01UHC-43037-05null13002215476kelly.wagner49@proton.me4324 APACHE BOULEVARD #421EDEN PRAIRIEMN55352GRP-5659null
CLMCLM-4060032026-01-23T22:00:59ZRian—Le1979-11-28NULL•••-••-2456NULLnullN/AUNKNOWN—NULLGRP-7205CORE-HMO
CLMCLM-4004372026-02-19T08:23:16Zashley—thomas1966-01-12UHC-12215-03•••-••-6461——-UNKNOWN—UNKNOWN··GRP-2699CHOICE-PLUS-PPO
CLMCLM-4072402026-04-15T08:17:59Z·Grace—Patterson··1983-05-26N/A—417-764-6397N/A3189 Maple AveAUSTINTX78706N/AN/A
CLMCLM-4224462026-01-25T22:43:02ZElijah—Murphy1945-06-24UHC-06509-69··N/AN/AN/A8467 Union StPlanotx75041GRP-5711null
CLMCLM-4231442026-08-30T11:47:56ZRILEY—CYNTHIA01-06-1980UHC-89532-20•••-••-3764·UNKNOWN··-····N/A-GRP-4766—
CLMCLM-4327092026-07-14T17:10:55ZELIJAH—WOOD1990-06-06UHC-36510-96•••-••-96377923404379elijah.wood@hotmail.com2449 Meadow LnPLANOTX75045GRP-9992SELECT-EPO
CLMCLM-4194912026-02-06T09:03:01ZJEFFZEVANS··1962-04-10nullnullnullJEFFREY.EVANS55@AOL.COM207 Valley View DriveGilbertAZ85287nullCHOICE-PLUS-PPO
CLMCLM-4283142026-02-22T13:09:01ZDavid··Romero11-04-2006—•••-••-7114UNKNOWN—6332 Indian School RoadOrlandoFL32899-1285UNKNOWNN/A
CLMCLM-409636 2026-05-15T21:34:05ZDEBRAW.CAMPBELL1941-04-21UHC-20616-86UNKNOWN(232) 388-3425—2817 Ridge RoadLAS VEGASNV89175GRP-8923UNKNOWN
CLMCLM-4085952026-03-29T12:19:27Ztyler··mcdonald1947-11-22—NULL—N/A·2865 BroadwaySan Antoniotx78223-6989GRP-5950SELECT-EPO
CLMCLM-4159132026-08-09T11:07:04Z·HAROLD····LITTLE··20041004-•••-••-8669nullnull7239 Maple AvenueTampaFL33601GRP-5586null
CLMCLM-4242422026-08-03T11:30:32ZlawrenceZ.richards1941-01-24UNKNOWN——UNKNOWN·UNKNOWNNULLN/AUNKNOWNGRP-0709—
CLMCLM-4054442026-07-13T00:10:53ZMills, JasonS—·1948-12-08··•••-••-4154nulljason.mills65@gmail.com1493 Sage CourtColumbus·OH43203-2813····NAVIGATE-HMO
CLMCLM-4215362026-08-28T02:24:42Z·Christian—Mendez1983-12-11nullNULL——9346 Market StreetTucsonAZ85710-MEDICARE-ADV-A
CLMCLM-4125432026-02-22T06:19:20ZmelissaR.rivera1960-04-26UHC-44304-88—·(415) 930-7452—2772 Park PlaceAtlanta··GA·N/AGRP-4390—
CLMCLM-4184202026-09-21T17:43:34ZJoseph—Vargas1967-03-08NULL•••-••-9385NULLN/A8941 Baseline RoadTEMPE··AZ85247GRP-0797N/A
CLMCLM-4199322026-01-19T06:12:15ZKATHRYN—HARVEY1939-06-06UHC-96992-41•••-••-1378····KATHRYN.HARVEY35@ICLOUD.COM—-null—GRP-1806null
CLMCLM-4144092026-01-16T06:08:17Z PHILIP—RIVERA1993-06-03UHC8928529•••-••-9865772-957-4457null————GRP-8058-
CLMCLM-416135 2026-04-25T17:26:41ZEMMA—PARK9/22/1952UHC6793693N/A—null2157 Ridge RoadFresnoCA93791N/A-
CLMCLM-4240502026-02-12T18:57:43ZDorothy—Henderson18-08-1938-•••-••-1728nullNULL—nullnull—GRP-2061-
CLMCLM-4318632026-06-22T13:17:32ZJames—Holmes1983-12-16--·N/ANULL4498 Bayshore Drive #571GilbertAZ85282GRP-3439CORE-HMO
CLMCLM-4171282026-02-28T16:55:48Zmichelle—weaver1993-07-07uhc-67341-32NULL470-675-3897N/A—nullN/A—·GRP-4329—
CLMCLM-4155602026-08-19T08:18:54ZRyan··Pena06/09/01—nullNULL-··—··—N/A··GRP-8316MEDICARE-ADV-B
CLMCLM-4116692026-09-20T19:18:24ZCYNTHIA—MONTGOMERY1950-08-16UHC-56890-57•••-••-1446—null8486 Maple AvenueLOS ANGELESCalifornia·90029—SELECT-EPO
CLMCLM-4297352026-06-29T19:12:51ZJose—Lynch1976-07-03UHC-32183-59•••-••-6848330-501-2955null1938 Harbor BoulevardGlendaleAZ85330GRP-7759—
CLMCLM-4102062026-07-08T16:36:01ZMARIA—MYERS1949-11-10UHC-25623-45-UNKNOWNmaria.myers@aol.com2789 SAGE COURTGlendaleAZ85369GRP-3994NULL
CLMCLM-4164752026-02-06T08:57:17ZrogerZgutierrez19750225UHC-01201-48•••-••-5399UNKNOWN-5417 Sunset BlvdLos AngelesCA90080··medicare-adv-a
CLMCLM-4096992026-01-21T22:55:47ZLori—Crawford1975-11-02NULLUNKNOWN706.694.6978NULLN/A——UNKNOWNGRP-3802CORE-HMO
CLMCLM-4276582026-09-13T13:16:51ZPriya—Carroll1970-12-06UHC-18639-53•••-••-32082935803894—NULLNULL—NULL··GRP-5347MEDICARE-ADV-B
32,829 rows, page 205 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:43.425Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty