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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4209522026-08-21T04:28:45ZHiroshi····Montgomery1976-04-17UHC-28875-07-782-855-8376—1778 Ridge RoadMiami·FL33123-1721GRP-6813NULL
TPATPA-583772026-08-22T11:48:11Zamanda—campbellAug 28, 1968null•••-••-5992——5649 CAMELBACK ROADMESAArizona85295UNKNOWN-
TPATPA-553272026-06-27T22:23:41ZHanson, Hirohsi——12/11/39—N/A—HIROSHI.HANSON@ICLOUD.COM6791 BASELINE ROADMinneapolisMN55425—N/A
ENRENR-1084572026-09-21T06:49:53ZHicks, Samantha——1955-07-24UHC2755825•••-••-1445nullnull3610 Valley View Dr···EDEN PRAIRIEMN55346-4582GRP-2372MEDICARE-ADV-A
PRVPRV-252462026-08-11T01:01:15ZParker, AmyF—05/10/48UHC-80718-08•••-••-02577085473846NULL3601 Jefferson AvenueScottsdaleAZ85292UNKNOWN—
ENRENR-1139702026-04-24T03:07:09ZEvelynV··Coleman19821113·UHC-59991-62•••-••-470717553933108evelyn.coleman@yahoo.com5757 Main StTAMPAFL·33672GRP-1530OPTIONS-PPO
ENR ENR-1215172026-07-16T14:30:23ZMaryWJordan1992-10-08··UHC-43821-91•••-••-67376645600559MARY.JORDAN83@AOL.COM1326 BROADWAYTampaFL33692GRP-5351··NAVIGATE-HMO
ENRENR-1027072026-04-23T11:13:09ZAustin—CookJul 22, 1959UHC-55723-65•••-••-5435641-468-2455·austin.cook33@icloud.com4599 SUNSET BOULEVARDDenverCO80296GRP-8590MEDICARE-ADV-B
TPATPA-528542026-03-08T03:46:53ZCarlos—Santiago10/23/1977——15372772702UNKNOWN2768 Ocean AvenueEden PrairieMN55373NULLnull
TPATPA-524072026-02-11T18:33:04Z EILY—LOPEZ1943-12-14—NULL······-6843 Camelback RdChandlerAZ85280GRP-3410····
PRVPRV-262242026-02-12T08:50:48ZPowell, Michelle——1966-11-26N/A—8846791047null7546 OCEAN AVE··Chandler·Arizona85269-5146UNKNOWNUNKNOWN
CLMCLM-4325162026-08-10T11:31:20ZIsaeblla··Gordon2007-08-24UHC-44059-85··481-909-4118UNKNOWN752 Mountain View DriveLos AngelesCA90062·GRP-7921OPTIONS-PPO
ENR ENR-1007132026-02-25T20:27:32ZAmandaO.··Rice1982-08-02UHC-69443-51•••-••-4463(655) 535-7007AMANDA.RICE83@AOL.COM6243 Lake View RdMinneapolisMN55444GRP-1815CHOICE-PLUS-PPO
CLMCLM-4129202026-04-03T06:07:37Zgregory—washington1972-09-15UHC-30230-14NULL··4474142347nullUNKNOWN—nullNULLnullCORE-HMO
PRVPRV-234092026-06-01T07:12:23ZJuanC··Singh1968-07-02——4119668···null4657 Cedar LaneMiamiFL33155—SELECT-EPO
CLMCLM-4084692026-08-17T06:58:51ZJoan—Johnston18-03-2001·-•••-••-9608N/A—8718 Desert Sky BoulevardMIAMIFL33104—NAVIGATE-HMO
CLMCLM-4181302026-01-16T22:01:40ZPat—Hansen1971-02-26UHC-07157-79•••-••-6359UNKNOWNUNKNOWN9413 Washington StTempeAZ85297GRP-8544—
CLMCLM-4107782026-05-04T22:00:06ZWilliam··—Estrada1986-03-23—UNKNOWN863.344.8733nullnull—-NULL——
ENRENR-1194452026-07-05T23:20:41Z·ABIGAIL·GDAY1954-10-15UHC-60035-57•••-••-43635772110160ABIGAIL.DAY40@HOTMAIL.COM4013 Spring StreetMiamifl33127··GRP-4361NAVIGATE-HMO
ENRENR-1058902026-08-14T11:25:39ZJORDANTJACOBS1978-10-19·UHC6394859null3977859589jordan.jacobs@outlook.com4718 Desert Sky BlvdTempeAZ85211GRP-5857··NAVIGATE-HMO··
ENRENR-1073912026-05-17T01:54:49ZLaurenQ.HakinsUNKNOWNUHC-71458-08•••-••-37146494807881lauren.hawkins@outlook.com6596 Elm StreetDenverColorado80298GRP-8544MEDICARE-ADV-B
CLM CLM-4040342026-06-08T19:34:21Zlogan··burton6/7/1948UHC-40551-44•••-••-4386-—3861 LAKE VIEW RDSan DiegoCA92197-UNKNOWN
CLMCLM-4140792026-01-26T08:17:35ZKAYLA··—PATEL1964-09-08UHC-00656-58··•••-••-9405—NULL—N/A——GRP-8703CHOICE-PLUS-PPO
ENRENR-1381492026-05-27T18:10:57ZBrenda—Phillips1961-06-05UHC-75690-49null(804) 353-7023brenda.phillips@gmail.com··1876 CENTRAL AVEMiamiFL33110GRP-1910OPTIONS-PPO
ENRENR-1016622026-02-22T19:40:58ZFrankPNunez1989-00-55UHC-16151-75•••-••-5402—FRANK.NUNEZ15@HOTMAIL.COM8405 MAPLE AVENUE Apt 12TampaFlorida33658GRP-8379NAVIGATE-HMO
ENR ENR-1363472026-09-07T14:05:08ZDebraURiley1972-01-01UHC-50659-18NULL4483737672debra.riley@gmail.com6684 Broadway Apt 18HoustonTX77005GRP-3835CHOICE-PLUS-PPO
CLMCLM-4264532026-07-03T06:32:59ZMargaret··Weaver19890417NULL—(379) 211-2495NULLnullNULLnull——OPTIONS-PPO
ENRENR-1224232026-02-07T19:03:27ZWong, EricX—1985-04-05uhc-55149-77•••-••-1522561-513-7113eric.wong91@yahoo.com6146 Meadow LnOrlandoFL32878GRP-5332MEDICARE-ADV-A
ENRENR-1275292026-10-09T16:51:52Zvirginia··Mjordan06/18/74UHC-40489-77•••-••-03363566574341VIRGINIA.JORDAN@OUTLOOK.COM585 Ocean AvenueFresnoCalifornia·93792GRP-8554select-epo
PRVPRV-21663 2026-08-27T08:23:57ZWILLIAM—SIMPSON1999-12-22-·NULL679.946.4475—4472 Baseline RdScottsdaleAZ·85240UNKNOWN—
TPATPA-510242026-07-05T18:23:29ZEspinoza, Edward——1949-08-10—N/A2694871692edward.espinoza9@proton.me2750 Valley View DrSan AntonioTX78297—UNKNOWN
ENRENR-1387132026-06-19T22:13:37ZAndy—Lynch··1967-09-02UHC5220615•••-••-6080449.750.9769andrew.lynch@yahoo.com7076 Grand AveScottsdale··AZ·85279GRP-5303MEDICARE-ADV-B
CLM CLM-4221312026-02-13T17:47:16ZSamuel—Martinez1993-04-08UHC-56424-34•••-••-0835·UNKNOWN··8593 Jefferson AvenueEDEN PRAIRIE·Minnesota55338—N/A
CLMCLM-4157732026-09-16T06:42:27ZLucas, PamelaP.—·1941-05-22UHC-69961-09•••-••-0509553-878-3842NULL—null·-———
ENRENR-1301972026-04-06T16:37:56Zchristina—contreras06-07-1967UHC-62827-35··UNKNOWN9404286373null5299 Canyon RdTucson··AZ85796GRP-3510options-ppo
ENRENR-1358502026-10-11T23:25:29ZNathan—Gilbert2008-01-10UHC-54667-70•••-••-28175297456638nathan.gilbert89@aol.com9116 SUNSET BOULEVARDCHARLOTTENC28217GRP-3357NAVIGATE-HMO
TPATPA-613442026-04-03T15:58:24ZBETTY··—WILLIS7/17/1958UHC-87716-71—····N/A2735 CEDAR LANEHoustonTX··77086GRP-6346MEDICARE-ADV-B
ENRENR-1132512026-09-29T04:07:35ZWILLIEGESPINOZA19309922UHC-99098-64··•••-••-8462(394) 337-1897—6665 Harbor BoulevardChandlerAZ85275-7602GRP-5383NAVIGATE-HMO
ENRENR-1067292026-07-25T20:07:12ZKimberly—Harvey··—UHC-92279-14··•••-••-0128(850) 499-3068····8206 CEDAR LNFresno·CA93766GRP-0168medicare-adv-a
ENRENR-1278182026-06-07T12:50:58ZHelan—Morrison05/18/91··UHC-00390-60—nullhelen.morrison60@yahoo.com5356 Oak StreetDALLASTX·75217GRP-5997SELECT-EPO
ENRENR-1295492026-04-06T22:24:10ZPayne, BenjaminV.—1991-12-09UHC-66516-34•••-••-8846330-494-2626benjamin.payne82@gmail.com9168 Ocean AvenueAustin·TX78779GRP-8652medicare-adv-a
ENRENR-1136362026-09-14T17:12:45ZAARONMLARSON1995-06-15UHC-25525-72•••-••-68393493046AARON.LARSON62@HOTMAIL.COM··7090 Union StMinneapolisMN55418GRP-0415·MEDICARE-ADV-A
CLMCLM-4191562026-09-16T22:47:48ZHannahVJames04-07-2007UHC-64914-03··nullUNKNOWNhannah.james@yahoo.com3210 Oak St·PLANOTX75086GRP-7370select-epo
CLMCLM-4151352026-02-08T12:33:45ZDorisJWright1960-06-27UHC-04572-43NULL-UNKNOWN-—NULLN/AGRP-4527NULL
PRVPRV-276562026-08-11T06:46:38ZAARON—·MORALES21-04-1967N/A•••-••-6192·N/ANULL840 Main StAtlantaGA30315nullCHOICE-PLUS-PPO
ENRENR-1155322026-09-06T14:33:44Z NATALIEHMORRIS2000-10-13UHC-66123-66—9424300014NATALIE.MORRIS@AOL.COM8480 Desert Sky BoulevardSeattle·WA98125GRP-2324CORE-HMO
TPATPA-549942026-08-17T16:19:44ZMaria—Gray1994-12-02NULL··—·NULL7226 Lincoln WayCharlotteNC28208GRP-3657····
CLMCLM-415622 2026-09-16T18:39:50ZFATIMA—SCHMIDT1958-12-15UHC1880064•••-••-3924(549) 974-8899—N/AUNKNOWNN/A—GRP-1247—
ENRENR-1392752026-10-17T17:59:11ZBETTYQSANDOVAL1944-09-25UHC-13305-47UNKNOWN14354236348N/A1080 DESERT SKY BLVDDallasTX75227GRP-5419SELECT-EPO
ENRENR-1073652026-01-18T16:48:52ZMadison·E.Simmmons1970-06-11UHC-47808-51•••-••-3036611-380-2927··UNKNOWN1841 LAKE VIEW RDSacramentoCA95862GRP-9662·CHOICE-PLUS-PPO
100,000 rows, page 236 of 2,000PreviousNext

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:37.740Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty