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
ENRENR-1226912026-07-19T08:25:56ZlawrenceZ.alexander1942-01-01UHC-22677-64•••-••-7172271.450.7162lawrence.alexander@outlook.com3342 CAMELBACK RDFresnoCA-GRP-6896select-epo
ENRENR-1047062026-07-26T07:32:35ZJACKM.KNIGHT10/20/55UHC-49193-58-(986) 868-5310jack.knight93@icloud.com252 SAGE COURTNashvilleTN37219GRP-1377MEDICARE-ADV-B
ENRENR-1183502026-05-28T04:49:06ZkeihtArios1962-08-24UHC-36163-12•••-••-1898804-752-6055keith.rios@outlook.com7688 Indian School RdSeattleWashington98151GRP-2841OPTIONS-PPO
ENRENR-1047102026-04-14T06:51:21Z MargaretYWalsh1939-12-26UHC-27596-24•••-••-2490475.466.5535-7355 SAGE COURTDenverCO80233GRP-6740CHOICE-PLUS-PPO
ENRENR-1095592026-07-26T02:09:47ZSara—Mitchell2007-05-01UHC-43055-25•••-••-0167-—9648 Oak StreetTAMPAFL33636GRP-1574CHOICE-PLUS-PPO
ENRENR-1358652026-02-13T16:26:43Z·Brittany—Henry2006-05-01UHC-69980-47•••-••-6158260-949-7641BRITTANY.HENRY5@PROTON.ME677 HIGHLAND AVE·AtlantaGA30387GRP-8904NAVIGATE-HMO
ENRENR-1061082026-08-11T08:12:26ZVirgniiaDPetersonNov 12, 2002UHC-94049-07··•••-••-8933775-325-1232null···4940 Lincoln WayOrlandoFL32888GRP-4395CORE-HMO
ENRENR-1163552026-01-05T21:11:01Zkimmberly··Nwheeler1943-01-21·UHC-50501-82•••-••-9246NULLkimberly.wheeler92@outlook.com8793 Mesa DriveDallas·TX75241·GRP-5589CORE-HMO
ENRENR-1279322026-06-28T09:23:46ZJORDANN.CARROLL1963-04-26UHC-34809-76•••-••-58328036358972·JORDAN.CARROLL@ICLOUD.COM7063 Sage CtTucsonAZ85714GRP-5945MEDICARE-ADV-A
ENRENR-1155922026-10-18T00:17:09Z vincent—jones1975-09-01UHC-15101-05•••-••-6738null··vincent.jones70@outlook.com3540 Jefferson Avenue Apt 25NashvilleTN37295GRP-7893NAVIGATE-HMO
ENRENR-1044902026-03-21T00:03:44ZAnnaE.Arnold1939-05-22UHC-72656-83•••-••-07739106083990—9675 MAPLE AVENUETucsonAZ85730GRP-5606··CORE-HMO
ENR ENR-1256442026-07-21T06:53:52ZJessica—Hunt··2001-05-01UHC-40668-92•••-••-8740(862) 786-0414NULL··6736 Baseline RdCharlotteNorth Carolina····GRP-8687MEDICARE-ADV-A
ENRENR-1301002026-07-04T08:14:37ZJoe—Williamson19761001UHC-73466-21•••-••-6081(222) 611-1932-7460 Palm DriveSACRAMENTOCA95825·GRP-0765SELECT-EPO
ENRENR-1299172026-01-25T11:57:02ZDanny—Garza1965-05-26UHC-65418-38•••-••-64858005596832daniel.garza@icloud.com3687 Elm StreetMesaAZ85213GRP-3301NAVIGATE-HMO
ENRENR-124296 2026-08-19T02:59:21ZweiW.garrett11/10/1986uhc-19525-85•••-••-51853399755NULL··2747 Harbor BoulevardSEATTLEWA—·GRP-1182CORE-HMO
ENRENR-1428092026-03-16T02:36:07ZStephanieQ.Patterzon19941107UHC-56178-98•••-••-4076946.634.8808-·9021 Highland AvenueHoustonTX77009··GRP-0498··OPTIONS-PPO··
ENRENR-1209452026-05-07T14:22:01ZMasonQGardner19790922UHC-51168-25•••-••-2603-mason.gardner54@yahoo.com1964 SUNSET BOULEVARD·CHANDLERAZ85267-6484GRP-1847MEDICARE-ADV-B
ENRENR-1086422026-04-16T01:49:03ZJacquelineHFieelds20010325UHC-73275-38•••-••-3813(259) 792-7854jacqueline.fields77@aol.com5732 Market St·JacksonvilleFL··32207GRP-2057CHOICE-PLUS-PPO
ENRENR-1402422026-02-21T00:42:42ZBETTY—HANSEN19550913UHC1805008N/A·(379) 860-3313NULL3269 Sunset BoulevardSan DiegoCA··92174GRP-4943CORE-HMO
ENRENR-1420242026-08-27T23:09:47ZCampbell, Adam——1987-03-08UHC-63932-48-·13722438342·adam.campbell23@aol.com1204 Cedar LaneJacksonvilleFL32247GRP-3213··CORE-HMO
ENRENR-1388262026-09-13T07:17:55ZChristine—Richardson1952-08-02UHC-18425-13null2306121604N/A2239 Maple AvenueSeattleWA-GRP-8585MEDICARE-ADV-A··
ENRENR-1411542026-06-23T17:23:22ZTylerYBoyd1962-12-16UHC-40388-88•••-••-7194(745) 640-3119TYLER.BOYD@YAHOO.COM4037 Valley View DriveOrlandoFlorida32847GRP-5487OPTIONS-PPO
ENR ENR-1425032026-06-28T07:18:25ZHiroshi—Hoffman15-06-1939UHC-55541-72•••-••-13214467600531hiroshi.hoffman22@yahoo.com353 Oak StTempeAZ85247GRP-1820SELECT-EPO
ENR ENR-1035142026-10-02T16:21:53ZLynch, Carl——Jun 17, 1955UHC-77776-94•••-••-5222(412) 632-0042carl.lynch77@yahoo.com2173 HIGHLAND AVE··CharlotteNC28298GRP-0992MEDICARE-ADV-B
ENRENR-1088672026-04-27T09:01:56ZjoyceSgomezMar 28, 1991UHC0942421•••-••-0139(388) 411-7607joyce.gomez@aol.com9674 Meadow LnORLANDOFL32802GRP-8729MEDICARE-ADV-B
ENRENR-1102392026-05-23T10:17:23ZKENNETH·····EVANS1946-10-04UHC-58101-51•••-••-54313806771675kenneth.evans@gmail.com1208 Union StMiamiFL33175GRP-0876MEDICARE-ADV-A
ENRENR-1188392026-02-13T08:34:55ZCarolyn—Harrison9/18/1998UHC-59431-11•••-••-5621566-368-8369carolyn.harrison3@outlook.com3144 Indian School RdEden PrairieMN55318GRP-4080SELECT-EPO
ENRENR-1229482026-06-07T11:38:13Z·Larson—Shirley··Mar 1, 2002UHC-40728-43•••-••-96063777893684shirley.larson22@outlook.com3209 Washington StreetColumbusOHN/AGRP-8968MEDICARE-ADV-B
ENRENR-1094872026-08-10T17:36:47ZMARYBSINGH12/27/2000UHC-97637-47•••-••-0639—UNKNOWN9083 Hillcrest RoadJacksonvilleFL32235-8234GRP-2818CORE-HMO
ENRENR-1342572026-09-01T01:05:57ZAlexanderSDaniels08/17/1957UHC-31734-73··•••-••-3869NULL-7936 Central AvenueFresnoCAN/AGRP-2791SELECT-EPO
ENRENR-1360062026-09-30T07:40:31ZSHARON—·WILLIAMSON1955-80-17UHC-81879-83•••-••-2968544-284-6180sharon.williamson91@hotmail.com938 CAMELBACK ROAD··Eden PrairieMN55304-7930GRP-4690MEDICARE-ADV-B
ENRENR-1000152026-09-27T12:02:01Z·BETTYLHALL1942-12-11UHC-11261-09•••-••-96746962864241-9814 LAKE VIEW ROADEDEN PRAIRIEMN55337GRP-4342CORE-HMO
ENRENR-1338782026-08-22T03:07:32ZStewart, LindaI—1976-03-11··UHC-40910-55•••-••-8886285-993-8775linda.stewart@icloud.com3321 Valley View DrMinneapolisMN55411GRP-5544CORE-HMO
ENRENR-1269282026-07-27T13:37:49ZJanet—Mendoza11/26/98UHC-13188-27•••-••-6873448-365-1439janet.mendoza@gmail.com5780 Mountain View DrSAN DIEGOCA92101··GRP-5796CORE-HMO
ENRENR-1121372026-09-07T06:57:27ZJacob—Ward1989-03-20UHC-58162-21•••-••-1006941-500-2414JACOB.WARD@AOL.COM·8456 Mountain View DrCharlotteNC28266-2413GRP-8684CHOICE-PLUS-PPO
ENRENR-1244212026-04-02T04:50:45ZPowell, Russell——22-10-1939UHC-73379-98•••-••-5979nullrussell.powell93@outlook.com8283 WILLOW COURTFresnoCA—GRP-1282CORE-HMO
ENRENR-1143272026-02-24T20:21:26ZChristine—Evans2001-12-17UHC-01717-89•••-••-8588+1 358 684 2432CHRISTINE.EVANS56@AOL.COM··1279 Baseline RoadSacramentoCA-GRP-6493CHOICE-PLUS-PPO
ENRENR-1349312026-10-18T08:20:47Z Barbara—Cooper1993-09-17UHC-62320-38•••-••-76564927428526barbara.cooper4@hotmail.com1440 FOREST AVENUE Apt 5TEMPEAZ85245GRP-1660MEDICARE-ADV-A
ENRENR-1270982026-10-12T23:18:46ZEvelynHMorrison1986-09-13UHC-65148-82•••-••-5114·2464249747N/A1846 Maple AvenueTampaFL33635GRP-9678··CORE-HMO
ENRENR-1245372026-02-04T20:23:30ZCynthiaDPerkins1954-01-11UHC-57488-40··•••-••-3320+1 788 288 5535cynthia.perkins6@gmail.com3711 MOUNTAIN VIEW DRPlanoTX75017GRP-6727CHOICE-PLUS-PPO
ENR ENR-1114522026-04-18T11:24:50ZAlvarez, Jcob·Y—1972-05-12UHC-93064-17•••-••-6109218-930-3366null6151 Union StAtlantaga30358GRP-0998SELECT-EPO
ENRENR-1378352026-04-30T11:16:32ZTorres, CamilaB—02/23/1939UHC-74623-75•••-••-9117884-213-6430CAMILA.TORRES@GMAIL.COM·4911 Cedar LaneScottsdaleAZ85278GRP-8289MEDICARE-ADV-B
ENRENR-1270942026-04-04T05:02:52ZKIMBERLYWGREEN1987-03-15UHC-58924-41•••-••-9278908-678-2047kimberly.green27@hotmail.com784 Harbor BoulevardGlendaleAZ85368GRP-8320MEDICARE-ADV-A
ENRENR-1122312026-01-24T16:47:40ZJOHNSTONB.SCOTTJun 1, 1991UHC-09585-03NULL··—scott.johnston@icloud.com8261 Pine DrSan DiegoCA92181-7284GRP-2116MEDICARE-ADV-A
ENRENR-1024552026-10-01T16:46:37ZSAMUEL—BRNS2001-12-03··UHC-39209-26N/A6133657225samuel.burns81@gmail.com3883 Canyon RdSeattleWA98162GRP-1891MEDICARE-ADV-A
ENRENR-1032772026-09-10T08:10:47Z AmandaK·McDonald1959-05-10UHC-18011-89•••-••-4930664.439.0605—2036 Indian School RdSeattleWA98106·GRP-7068OPTIONS-PPO
ENR ENR-1233612026-09-28T04:33:27ZJeremyF.·Carpenter1970-06-27UHC-28403-13•••-••-8261918.940.6072jeremy.carpenter17@icloud.com8741 Spring StSan AntonioTX78281GRP-5683SELECT-EPO
ENRENR-1310172026-09-02T17:30:48ZMEI··FARMSTRONG1993-06-21UHC-83413-64•••-••-9378(237) 782-0792mei.armstrong16@aol.com6233 Canyon RoadPLANOTexas75071GRP-3687OPTIONS-PPO
ENRENR-1278762026-09-15T02:46:07ZAMBERGMORENO0850-19-99UHC-25618-80•••-••-6561309-485-0791amber.moreno@proton.me4874 Camelback RoadAtlantaGeorgia··30317GRP-4950CHOICE-PLUS-PPO
ENRENR-1066102026-10-16T11:27:01Z·BruceYFuller1988-04-26UHC-98369-58•••-••-67307989699926bruce.fuller74@aol.com7507 MARKET ST··JacksonvilleFL32220GRP-7474MEDICARE-ADV-A
43,101 rows, page 77 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:36.711Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty