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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENR ENR-1288522026-04-15T18:34:58Z ·DOUGLASQPERRY1979-03-18UHC-12328-71•••-••-6166382-654-6399··NULL·1326 Apache Boulevard Apt 37AustinTX78772GRP-9796NAVIGATE-HMO
ENRENR-1018812026-07-24T17:58:37Z MARY··Z.··SANDOVAL··—UHC-46216-66•••-••-0780614-367-2410UNKNOWN6116 Pine DrMinneapolisMN·55400GRP-2815MEDICARE-ADV-B··
ENRENR-1370072026-08-05T08:27:53ZGonzalez, Beverly——1995-11-24UHC-10930-89•••-••-8387(432) 894-7915beverly.gonzalez@gmail.com6102 Camelback RoadSeattleWA—GRP-8741SELECT-EPO
ENRENR-1074882026-06-03T01:09:13ZSantiagoA.Mendoza10/25/1939UHC-87845-70··UNKNOWNSANTIAGO.MENDOZA@GMAIL.COM4106 Central Ave Apt 14San DiegoCA—GRP-2717CHOICE-PLUS-PPO
ENRENR-1294042026-07-13T06:51:37ZWEI—COLEMAN1968-02-02UHC-03076-19•••-••-73806507914166null5962 Valley View DriveGlendaleAZ··85397GRP-2663CHOICE-PLUS-PPO
ENRENR-1338272026-05-18T21:48:21ZPETER—SALAZAR1947-05-03UHC-64006-03··•••-••-835815023945347peter.salazar93@aol.com4304 Palm Dr Apt 26FRESNOCA93767GRP-6311OPTIONS-PPO
ENRENR-1254902026-10-07T16:18:59ZOMAR··GEORGE12-11-1980UHC-95287-38•••-••-7627929-588-2596NULL4930 Sunset BoulevardSeattle·WA98106GRP-4829MEDICARE-ADV-B
ENRENR-1138252026-05-16T19:32:52ZSusanNHarper1944-07-23UHC-75355-65•••-••-68368794202110susan.harper34@yahoo.com4040 Spring StSan AntonioTX78204GRP-9152NAVIGATE-HMO
ENRENR-1060082026-03-20T10:03:25ZADAMYCHEN19690418UHC-94323-70•••-••-66053277001adam.chen79@aol.com7978 Apache BlvdSan DiegoCA·92170GRP-7183MEDICARE-ADV-B··
ENRENR-1106312026-06-11T23:54:25ZChristopher—Henderson1952-06-11UHC-24246-34NULL233-461-6139christopher.henderson28@proton.me3883 HARBOR BOULEVARDNashvilletn37228GRP-1939·SELECT-EPO
ENRENR-1413682026-07-18T19:07:43ZREBECCAW.ADAMS17-02-1965UHC-04443-52•••-••-6897(632) 662-6814rebecca.adams@outlook.com7683 Meadow LnTempeAZ85213GRP-0573navigate-hmo
ENRENR-1011802026-09-24T14:01:31ZAmberC.Johnston08/06/46UHC-11140-30•••-••-6207(252) 312-6659amber.johnston@hotmail.com1914 Maple AvenueAtlantaGA··30303GRP-7833SELECT-EPO
ENRENR-1141212026-09-22T08:16:19ZchristinaEramos1963-02-12UHC-50875-92•••-••-8021—CHRISTINA.RAMOS32@GMAIL.COM7157 Market StLos AngelesCA90046GRP-8615OPTIONS-PPO
ENRENR-1112132026-01-19T00:50:33Z YukiILane1984-06-21UHC-54117-35•••-••-3227637.515.0574NULL5912 Baseline RoadFresnoCA93772GRP-3692CORE-HMO
ENRENR-1100592026-08-01T19:38:26ZPETER—FISHER1963-04-24UHC-16081-29•••-••-0684(557) 295-9028-9174 Lincoln WayNashvilleTN37215-7552GRP-3403CHOICE-PLUS-PPO
ENRENR-1383252026-07-06T09:59:25ZAshleyE.Wallace·1961-07-08UHC-63741-58•••-••-3117847.806.4359ashley.wallace31@outlook.com2406 Church St #727TucsonAZ85772GRP-4390core-hmo
ENR ENR-1292512026-01-05T05:11:25ZJanice—Schmidt1959-02-27UHC-64276-11•••-••-60628367053870janice.schmidt91@outlook.com658 Ocean AvenueGlendaleArizona85345-0903GRP-9113SELECT-EPO
ENRENR-124304 2026-01-31T02:08:47ZBETTY—GILBERT2008-10-14UHC-74971-33•••-••-7340N/A—9021 BroadwayPhoenixAZ85005GRP-2601NAVIGATE-HMO
ENRENR-1300172026-01-16T12:35:19ZKathrynUCooper1979-09-21UHC-84332-55null···633-485-3736KATHRYN.COOPER18@OUTLOOK.COM2370 Ridge RdMESA·az85215GRP-2309MEDICARE-ADV-B
ENRENR-1403542026-04-11T20:28:05ZLoganECarr1978-06-08UHC-66549-87•••-••-84208945437··LOGAN.CARR79@YAHOO.COM5888 Valley View DrATLANTAGA·30393-8871GRP-5435··SELECT-EPO
ENRENR-1354582026-09-23T07:27:02ZRichardLGonzales08-05-1974UHC-13350-17•••-••-6375722.327.2474N/A7292 Pine DrNASHVILLETN37268GRP-3882OPTIONS-PPO
ENRENR-1096772026-04-16T07:15:07ZPhilip—Dean1988-09-21UHC-52903-44—5782854philip.dean@yahoo.com1778 Ridge RoadOrlandoFL32803GRP-5919MEDICARE-ADV-A
ENRENR-1076762026-06-23T22:02:24ZmarinaX.vega12/03/52UHC1259574•••-••-5212465-325-1232MARIANA.VEGA88@YAHOO.COM5684 Church Street Apt 6TucsonAZ85749GRP-4931··MEDICARE-ADV-A
ENRENR-1036172026-02-28T21:59:48ZADAMXLYNCH01/24/1996UHC-95143-89•••-••-40722275445744—3179 Washington StreetJacksonville··FL··GRP-2612CHOICE-PLUS-PPO
ENRENR-1111952026-07-07T11:19:56ZmarthaNdean1983-08-15UHC-45430-60•••-••-5637926.634.1985···martha.dean@gmail.com2239 Washington StCHARLOTTENCUNKNOWNGRP-5825CHOICE-PLUS-PPO
ENRENR-1305162026-05-27T16:47:06ZGloria—Hart12/23/2008uhc-42892-41•••-••-6091(278) 413-4002GLORIA.HART@YAHOO.COM—UNKNOWN—N/AGRP-6439MEDICARE-ADV-A
ENRENR-1052232026-08-15T20:19:05Z Cristina·MJones1953-12-06UHC-23530-91•••-••-8506—-·515 PALM DRIVEPhoenixAZ85033GRP-7788NAVIGATE-HMO
ENRENR-1359952026-04-19T22:16:07ZJacobCEstrada2006-06-14UHC-26082-11•••-••-1023278-479-1100jacob.estrada55@yahoo.com2004 Park PlacePlanoTX—GRP-6765navigate-hmo
ENRENR-1042572026-09-27T13:49:47ZAdam··—Alexander1983-04-20UHC-65763-27UNKNOWN··+1 737 403 9684·ADAM.ALEXANDER67@PROTON.ME2795 INDIAN SCHOOL RDDenverCO80274GRP-1094options-ppo
ENRENR-1006042026-06-30T14:05:17ZAustinP.Fernandez2005-10-03UHC5648811•••-••-59207618706180——N/A——GRP-5473OPTIONS-PPO
ENRENR-1382682026-09-15T09:07:02ZBillyEElliottMay 12, 1982UHC-93838-09•••-••-62729554615398billy.elliott@gmail.com6024 HIGHLAND AVETAMPAFlorida33631GRP-4964SELECT-EPO
ENRENR-1078672026-08-04T23:02:19ZBrandonJSantos1959-05-16UHC2612801•••-••-0719(712) 804-4696BRANDON.SANTOS9@AOL.COM1857 Camelback RoadMesaAZ85281GRP-0733MEDICARE-ADV-A
ENRENR-1318882026-06-14T21:43:52ZMarcus—King07/26/80UHC-75675-84•••-••-65739921926UNKNOWN9461 Lincoln WayNASHVILLETN37205GRP-0134MEDICARE-ADV-B
ENRENR-1014252026-01-03T14:39:52ZJudithGMaldonado1966-12-02UHC-84739-37•••-••-7981·2697593112NULL6832 JEFFERSON AVENUE··AtlantaGeorgia30382GRP-0916CORE-HMO
ENRENR-1322392026-02-17T10:21:05ZJordan—Girffin08/13/1952UHC-29273-52··•••-••-1085+1 630 314 5311JORDAN.GRIFFIN@PROTON.ME3678 Forest AvenueScottsdaleAZ85298GRP-5094CHOICE-PLUS-PPO
ENRENR-1263692026-05-19T05:58:02ZMark—Lopez—·uhc-07607-29•••-••-5928625-300-5210··mark.lopez@icloud.com7194 Park PlaceSACRAMENTOCA95843GRP-9732··SELECT-EPO
ENRENR-1390102026-07-14T20:36:07ZKathrynVBurton1973-11-08··UHC-99290-35•••-••-1587(935) 399-6976kathryn.burton@gmail.com7243 Ocean AveHoustonTexas77046GRP-4367CHOICE-PLUS-PPO
ENRENR-1010592026-01-11T15:01:44Zalice···knight2016-19-58UHC-58125-21—470-826-2531—6465 Pine DriveORLANDOfl··32859GRP-2336MEDICARE-ADV-A
ENRENR-1257882026-05-21T22:20:20Zdylan·Orobinson··2007-07-15UHC-25806-40•••-••-560215043219582dylan.robinson72@gmail.com3396 MAPLE AVENUE Apt 14OrlandoFL32819GRP-0634MEDICARE-ADV-A
ENRENR-1222552026-08-13T03:56:04ZGray, AlexanderH—May 1, 1940UHC-74703-60—316-835-6891alexander.gray@yahoo.com9441 WILLOW CTMinneapolismn55455GRP-3053SELECT-EPO
ENRENR-1076662026-07-27T03:01:42ZMADISON—FOSTER1955-03-28UHC-63068-07•••-••-6995679.972.7683·MADISON.FOSTER23@OUTLOOK.COM-N/A—····GRP-2500SELECT-EPO··
ENRENR-1026112026-04-30T06:42:27ZKevinFRiceApr 6, 2008UHC-58251-63-7404264793KEVIN.RICE@OUTLOOK.COM1675 Palm DriveOrlandoFL32859GRP-0740SELECT-EPO
ENRENR-1289932026-04-12T01:46:03ZKaylaXLewis1978-06-27·uhc-29423-32•••-••-7031716-685-7720-8719 Ocean Ave·Gilbertaz85269GRP-4562OPTIONS-PPO
ENRENR-1138272026-01-27T15:27:36ZAUSTIN··VSANCHEZ3/23/1983UHC-48615-72•••-••-21203673377269··austin.sanchez@proton.me7007 Harbor BoulevardColumbusOH43285GRP-0717OPTIONS-PPO
ENRENR-1083842026-02-15T01:26:17ZAlbert—Oliver01/23/1979·UHC-73101-42•••-••-2449+1 711 496 3462albert.oliver@outlook.com5203 Maple AveTAMPAFL33662GRP-5280MEDICARE-ADV-A
ENRENR-1164552026-08-09T17:02:08Z BRANDON—WARD1985-08-15UHC-12510-99•••-••-61703788017184··BRANDON.WARD@OUTLOOK.COM2264 Sage CtCharlotteNC28230GRP-2275CORE-HMO
ENRENR-1301352026-04-09T02:57:43Zmateo—hawkins1968-02-21UHC-43519-55•••-••-1841(451) 485-7806UNKNOWN4235 Lake View RdPhoenixAZ85011GRP-0457NAVIGATE-HMO
ENRENR-1356462026-04-27T09:15:53ZPriya—Rodriguez1963-11-16UHC-00786-93•••-••-0896672.380.6149UNKNOWN7200 INDIAN SCHOOL RDLAS VEGAS··NV89154GRP-6164MEDICARE-ADV-B
ENRENR-132479 2026-04-25T23:15:03ZMartinez, Kmberly——1941-03-08UHC-26260-43•••-••-407012687677752kimberly.martinez79@yahoo.com4974 Camelback RdCOLUMBUS·OH43209GRP-9121·CHOICE-PLUS-PPO
ENRENR-1429752026-04-12T06:12:36ZamandaMarnold··1995-04-08UHC-03979-01•••-••-4553—null5631 Sage CtEden Prairie··MN55396-5507GRP-7837SELECT-EPO
43,101 rows, page 203 of 863PreviousNext

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