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-4173202026-03-20T15:53:09ZALEXIS—WALKER1962-07-15····-N/AUNKNOWN2604 HIGHLAND AVEPhoenixAZNULLGRP-2072CORE-HMO
CLMCLM-414866 2026-01-21T04:15:55ZJEREMY····WILLIAMSON1975-07-08UHC-70103-18•••-••-7435UNKNOWN—nullnullnull—·GRP-7947-
CLMCLM-418923 2026-07-05T12:27:06ZMary····Miller···11/17/1940UHC-95565-83•••-••-9365—NULL9265 SUNSET BOULEVARDMinneapolisMN···55476GRP-4373NAVIGATE-HMO
CLMCLM-4128302026-06-22T07:58:16ZDanielle—Jordan12/5/1998UHC-52043-50nullUNKNOWNNULL5513 Market StPhoenixAZ85087GRP-0783—
CLMCLM-402702 2026-05-17T17:43:30ZJUDY—TURNER1957-08-03UHC-54618-59-—N/A5845 Central AvenueDenverColorado··80296··UNKNOWNMEDICARE-ADV-B
CLMCLM-4197922026-09-12T21:59:49ZRonald—Fowler04/05/2001UHC-11532-40N/ANULL-N/ANULL—UNKNOWNGRP-8572SELECT-EPO
CLMCLM-4010072026-04-08T11:15:58Zbeverly—dominguez1963-06-01-•••-••-57599233500104nullNULL—null—GRP-7759NULL
CLMCLM-4238182026-03-18T09:48:13ZYUKI··JOHNSON1960-07-06·NULL—256-802-8066··null—UNKNOWN—null····
CLM CLM-4304212026-07-25T11:32:55ZDENNIS—NELSON19920902N/A•••-••-1692NULL—8076 VALLEY VIEW DRIVEScottsdaleAZ··85218GRP-1540CORE-HMO
CLMCLM-4031962026-09-09T02:08:02ZDENNIS—HUNT1993-03-07UHC-89275-42—702-204-7001·UNKNOWN9777 Mountain View DrCOLUMBUSOH43245GRP-7338medicare-adv-b
CLMCLM-4037872026-04-21T09:54:20ZMATEO—MYERSJul 16, 1976uhc-90347-43•••-••-46916369344236—·5802 RIDGE RDGlendaleAZ85308-4677—NAVIGATE-HMO
CLMCLM-4221682026-03-18T13:41:01ZVirginia—Hawkins1945-06-12————5939 MARKET STREETSeattleWA··98169-NAVIGATE-HMO
CLMCLM-4159662026-04-05T00:55:45ZJean—Yang1955-02-15UHC-55015-07UNKNOWN·768-308-9428—5899 Main StreetAtlantaGeorgia30303-3253GRP-0120SELECT-EPO
CLMCLM-4064172026-03-30T01:06:00ZHeather—Singh1984-01-09UHC-61064-10•••-••-31064244339075UNKNOWN6811 Elm StreetPlanoTX75098··nullCHOICE-PLUS-PPO
CLMCLM-4130382026-03-01T19:06:49ZJESICA—SNYDERJul 6, 1964UHC-92417-51-209.537.1111·UNKNOWN7170 Desert Sky BlvdSacramentoCA95866—select-epo
CLMCLM-4113832026-06-10T07:21:24ZVazquez, Brandon——1956-10-03·UHC2270162•••-••-1986-brandon.vazquez@icloud.com·2328 Elm StAustinTexas78789GRP-4945NULL
CLM CLM-4301122026-07-04T22:00:52ZWILLIAME.RAYOct 22, 1943uhc-70885-47•••-••-0490N/A—-UNKNOWN—··GRP-9614UNKNOWN
CLMCLM-4073942026-04-18T17:06:54ZMadson—Morneo1/4/1969-•••-••-7960578-963-1746NULL4876 BroadwayLAS VEGASNV89140UNKNOWNNULL
CLMCLM-4154272026-02-28T21:36:16ZWalker, CherylQ.—1944-07-15UHC-28401-80•••-••-2587(736) 208-1269NULL7688 Valley View DrSan AntonioTX78256—-
CLMCLM-4245062026-01-08T05:48:54ZJOEY—OWENS1949-05-26UHC-88512-73•••-••-23339951077-nullnull—nullnullOPTIONS-PPO
CLMCLM-4138902026-05-23T22:37:27Z Tony—Davis1950-09-01··——+1 515 697 4317NULL6352 Bayshore DrGILBERTaz85292·GRP-8219UNKNOWN
CLMCLM-4102312026-08-09T08:57:35ZPalY.Bryant1941-11-16-—12903752486null—UNKNOWNnull—GRP-8039—
CLM CLM-4114292026-03-12T20:11:20Zjeremy—holmesNov 21, 1969-•••-••-8040null—818 Central AvenueSAN DIEGOCA92195nullCORE-HMO
CLMCLM-4265992026-04-29T04:23:23ZDylan—Padilla1974-09-27UHC6499166·N/A+1 605 930 7896null8669 Meadow LnPlanoTX75018NULLMEDICARE-ADV-A
CLMCLM-4171042026-09-14T17:03:15ZWest—Jacqueline11/06/01···UHC-85592-57··null—6379 Cedar LaneOrlandoFL32838·GRP-1436UNKNOWN
CLMCLM-4280002026-09-09T16:59:57ZGilbert, DanielE—1938-08-24—•••-••-0983(265) 844-1156null·9403 Market StreetTampafl33624——
CLMCLM-4077182026-06-02T23:34:54ZNatalie—Wallace19400815-nullUNKNOWNNULL406 Church StreetSacramentoCA95856nullSELECT-EPO
CLMCLM-4034472026-02-22T18:08:51ZMateo—Johnson·09/05/1986UHC-24566-34null9848169043null—UNKNOWN·N/AUNKNOWNGRP-5824NULL
CLMCLM-4271742026-05-29T01:55:48ZJeffrey—Lawrence1977-08-09UHC-33727-01•••-••-2734802.712.7733jeffrey.lawrence@outlook.com2828 Highland AveDallasTX75212——
CLMCLM-4319062026-02-24T12:56:53Zmelissa—hudson2007-09-06UHC-49229-90····N/Anull1746 Grand AveGILBERTArizona85210··GRP-7518NAVIGATE-HMO
CLMCLM-4266302026-03-20T08:57:12ZBARBARAICOOPER1993-09-17N/A·NULL4927428526N/A——-—null··—
CLMCLM-4266882026-05-28T22:32:19ZFRANCES—ROSS1987-12-11UHC-49985-38UNKNOWNnull—nullNULL—UNKNOWNN/AMEDICARE-ADV-A
CLMCLM-4179982026-07-22T10:11:31ZJOAN—JACKOSN2000-02-17UHC-61315-20null—-null········GRP-8570—
CLMCLM-4222732026-04-11T18:58:33ZJAMES—HANSONNov 23, 1984UHC-90765-54•••-••-26916222528462james.hanson@outlook.com6778 OCEAN AVEMiamiFL33117NULL··
CLMCLM-4234442026-01-06T16:36:13ZLarryNSalazar1/11/1959UHC-88293-04NULL617-397-5906NULL3354 Park PlGilbertArizona85257N/A····
CLMCLM-4133932026-06-28T14:24:53Zalexis··—rodriguez1984-05-12UHC-34207-12—16487817696—N/AN/AUNKNOWNN/AGRP-8397UNKNOWN
CLMCLM-4220302026-05-31T15:30:17ZJulie····Flores2005-12-02UHC-88438-07UNKNOWN7857529815N/A··354 Lake View Road·OrlandoFL32818UNKNOWNN/A
CLMCLM-409646 2026-01-29T20:17:52ZAISHA—SEPHENS17-04-1996·nullN/A-··—8800 Grand AvenueDallasTX75255null-
CLMCLM-4298922026-09-11T13:25:44ZLogan—·Payne1986-04-08UHC-81447-44N/AN/Anull279 Apache BoulevardOrlandoFL32830··N/A
CLMCLM-4199462026-07-25T20:28:52ZBRADLEY D—ARMSTRONG1948-12-15UHC-69711-57·UNKNOWN———-nullUNKNOWNGRP-6187NULL
CLMCLM-4142692026-09-09T10:13:55ZBetty—Pena·10/3/1953UHC-15755-28•••-••-5550588-666-3083betty.pena37@hotmail.com8194 MAPLE AVENUE Apt 5Nashville·TN37272·GRP-5716null
CLMCLM-4058442026-04-08T11:32:41ZRandy—Reid·Jul 28, 1953NULL—-null8551 WASHINGTON STREETLas VegasNV89101·GRP-6501CORE-HMO
CLMCLM-4299852026-07-07T15:53:09ZTheresa—McDonaldSep 28, 1967UHC-35139-46··•••-••-0479N/A—3477 JEFFERSON AVEMESAAZ85242··GRP-2756MEDICARE-ADV-B
CLMCLM-4235442026-09-12T10:55:37ZTYLERZ.LI1950-08-22·-null——nullN/ANULL—-null
CLMCLM-4118132026-01-17T08:05:38ZLauren·IJohnston01-03-1940UHC-02841-38•••-••-25624098863695··—5827 WILLOW CTHouston·TX77080UNKNOWN—
CLMCLM-4157272026-01-12T17:45:13ZRANDY—MARSHALL2007-12-17UHC-21917-14—-—1355 HARBOR BLVDLos AngelesCA90048-4081GRP-2202MEDICARE-ADV-B
CLMCLM-4278952026-09-03T12:22:51ZAARON—KNIGHT1983-07-13UHC-95721-09-——8293 SPRING STREETNashvilleTN37219GRP-2556—
CLM CLM-4111612026-09-05T20:30:24ZBRITTANY—MUNOZ19480417UHC-17677-75•••-••-4368null—1220 Desert Sky BoulevardHOUSTONTX77015N/A··OPTIONS-PPO
CLMCLM-4018222026-08-04T06:56:23ZANDREA—BISHOP19750720··UHC-70074-36•••-••-8821NULL····7664 SUNSET BLVDEDEN PRAIRIEMN·55350GRP-0354null
CLM CLM-4170502026-06-26T18:04:27ZANDREA—BELL1940-01-26UHC-37247-96··—(517) 999-1466null9349 Lake View RdGilbertAZ85250··N/AMEDICARE-ADV-A
32,829 rows, page 42 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:36.690Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty