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
TPATPA-644192026-06-15T10:48:59Zroger—knight1977-11-15UNKNOWNNULL—null6386 RIVER RDChandlerAZNULL··GRP-8539—
ENRENR-1058692026-02-27T00:53:54ZBowman, BenjaminC—05/21/92·UHC-41086-49-(476) 524-0260—8468 Willow CtColumbusOH43269GRP-5892CHOICE-PLUS-PPO
CLMCLM-4315352026-07-23T04:08:21ZAmanda—Li1968-03-22N/A—--8177 Ridge Road·GilbertAZ85282—·NAVIGATE-HMO
CLMCLM-4120542026-05-10T11:41:47ZStephen··Espinoza08/17/1979UHC-47877-57··•••-••-8648+1 598 332 0920—3946 Pine DrTucsonAZ85748GRP-6276null
CLMCLM-431354 2026-03-20T16:31:00ZSchmidt, Pamela——1948-08-12UHC-00388-35•••-••-4472··-2097 Lake View RoadTampaFL33670GRP-0312MEDICARE-ADV-B
PRVPRV-275262026-09-02T07:43:06ZNacy—Daniels1976-11-12UHC-96138-11··•••-••-4382·(649) 638-7234UNKNOWN8662 CEDAR LANEOrlandoFL32823UNKNOWNN/A
ENRENR-1109972026-09-10T18:27:06ZMateoUGonzales··1978-04-10··UHC-83490-21•••-••-2748—mateo.gonzales@icloud.com7746 Ocean AveTempeAZ85292GRP-0833··SELECT-EPO
CLM CLM-4127402026-10-15T00:55:40ZHaroldP··Patterson03/26/40UHC-04603-36•••-••-8241375-407-5325NULL——NULLN/A—null
PRVPRV-236962026-02-23T11:47:42ZRobert—Simmons1947-10-08UHC-52762-25•••-••-14855082913918robert.simmons73@yahoo.com1818 MAPLE AVESan DiegoCA92157——
ENRENR-1081122026-06-26T09:16:41ZHarrison, Nick——1986-01-22··UHC-96747-20•••-••-8189577-908-4010nicholas.harrison71@yahoo.com8587 MAPLE AVENUEDallasTX75262GRP-7418MEDICARE-ADV-B··
TPATPA-546382026-08-12T13:36:16Zteresa····wong1980-10-10—NULL14522791791-3782 Valley View Drive·AustinTX78794NULLnull
PRVPRV-229892026-10-15T06:58:15ZCHARLES—GARZA1956-06-28N/A—(462) 968-3657CHARLES.GARZA94@PROTON.ME4858 INDIAN SCHOOL RDSan Diego··CA··92125-8155NULLNULL
PRVPRV-215972026-09-23T21:46:18ZMariana····Sanders1991-09-09UNKNOWN•••-••-9212(811) 722-3521NULL2727 WILLOW COURTTempe·AZ85244-core-hmo
ENR ENR-1343412026-06-19T01:46:50ZVicky··—Burke··2005-01-09UHC-45293-46•••-••-2474(250) 513-5981victoria.burke@yahoo.com336 Palm DrPLANOTX75029·GRP-0104MEDICARE-ADV-A
TPATPA-599032026-07-06T07:56:23ZLori—Wang19730424—•••-••-9875N/AN/A··NULLUNKNOWN——UNKNOWNUNKNOWN
PRVPRV-200922026-02-19T06:51:26ZCharyl—Howard1946-08-24UHC-29543-47UNKNOWN431-836-6154—5314 APACHE BOULEVARDLas VegasNV89176—NULL
ENRENR-1245832026-02-16T07:54:37ZJeffrey—Moore1985-05-28UHC-66663-74UNKNOWN8929436jeffrey.moore70@aol.com7212 Oak StMiamiFL33171-0172GRP-8707SELECT-EPO··
PRVPRV-246482026-09-08T20:13:35ZGeoorge··VWeaver1982-06-25NULL—(438) 437-8463null1304 BAYSHORE DRIVENASHVILLETN37281··N/Anull
TPATPA-555812026-08-10T03:12:01ZMaria—Schmidt2002-05-17—-—null4327 River RoadLos AngelesCA·90070GRP-8087—
CLMCLM-4300402026-05-30T15:20:56ZADAM—·BURNS1964-04-28UHC6543992•••-••-6422698.226.9928-7744 Willow CourtAtlantaGA30395GRP-4434··NAVIGATE-HMO
ENRENR-1343622026-02-08T19:35:35ZKIMBERLYJ.FREAMAN1982-10-24UHC-01779-32•••-••-8238745-882-7748kimberly.freeman56@aol.com·4854 Bayshore Dr·MiamiFL33156GRP-9115CORE-HMO
TPATPA-531232026-10-10T11:43:53ZBRENDA—MILLS1991-04-18—N/Anullbrenda.mills29@icloud.com——UNKNOWNNULLGRP-8609—
PRVPRV-220422026-03-06T19:04:56ZKAITH—DUNCAN19430228UNKNOWNNULL·(651) 284-1016UNKNOWN1784 Sage CourtOrlandoFL32826N/A····
CLMCLM-4249722026-05-03T18:59:16ZLuis··Cole1976-05-18UHC-54865-68•••-••-2515N/Anull1216 Grand AveCharlotteNorth CarolinaUNKNOWNGRP-1594CHOICE-PLUS-PPO
CLMCLM-4065802026-07-19T10:47:12ZPerkins, Denise——2003-07-02·UHC-99174-55UNKNOWN··—NULL6478 Meadow LaneJacksonvilleFL32291GRP-3199—
CLMCLM-4130932026-06-18T06:18:26ZCYNTHIA—MEJIAUNKNOWNUHC-80006-11•••-••-9073NULLcynthia.mejia15@icloud.com8021 Spring StreetAustin··TX78792—UNKNOWN
ENRENR-1161992026-10-05T19:44:26ZPadilla, Mdaison——7/1/1963UHC-08831-32•••-••-8819(545) 840-5782N/A409 Bayshore DriveFRESNOCA·93733GRP-4009CORE-HMO
TPATPA-539252026-02-14T17:00:36ZJOYCE—WATKINS02/16/1994———UNKNOWN8082 APACHE BOULEVARDHoustonTX77092-CORE-HMO
TPATPA-505032026-09-02T04:50:42ZmarkC.johnson19820203NULL•••-••-5297576-560-6988mark.johnson6@proton.me4650 Market StreetLas VegasNV89145GRP-5880NULL
CLM CLM-4008352026-02-12T17:57:03ZJulie—Webb1951-02-14N/A•••-••-6160844-915-3139NULLnull———GRP-8922··N/A
CLMCLM-4090842026-07-11T10:18:52Z Kathryn—Knight1952-12-09UHC-61419-84UNKNOWN(609) 965-0648—8540 LAKE VIEW ROADDallasTX75238—UNKNOWN
ENRENR-1409272026-01-27T08:26:04ZTimothyV.Bishop1978-10-26UHC-78355-49•••-••-9151762-503-4555timothy.bishop@gmail.com2293 WASHINGTON STREETJacksonvilleFL32252GRP-0908SELECT-EPO
ENRENR-135760 2026-08-02T07:01:37ZMADISON—ADAMS04/24/77UHC-85490-31•••-••-46736136132644madison.adams@proton.me7892 Maple Avenue··MesaAZ85280GRP-6598MEDICARE-ADV-B
TPATPA-633312026-08-28T22:48:48ZChristian··ISimmons1990-69-04————8494 CENTRAL AVENUEPhoenix·az85092—··
ENRENR-1380182026-02-02T14:15:17Z ·JESSICAE.PETERSON2006-07-07UHC-90927-74•••-••-1939·845.706.1133JESSICA.PETERSON@ICLOUD.COM8905 INDIAN SCHOOL RD··ScottsdaleAZ85296GRP-1189MEDICARE-ADV-B
ENRENR-1074902026-06-20T04:58:45ZDanielle—Daniels1968-04-03UHC-37838-16-246.783.0755danielle.daniels73@aol.com7616 Market StreetCharlotteNC28280GRP-6901··MEDICARE-ADV-A··
ENRENR-1009802026-07-09T00:01:48ZMADISON····GREENE1961-05-12UHC-54535-71··—879.494.6671null9018 Sunset BoulevardNashvilleTN·37257GRP-5407MEDICARE-ADV-B
PRVPRV-238732026-09-26T21:57:39ZSmith, Keith——05/06/1997·UHC-42383-68—(413) 484-5736keith.smith@icloud.com8139 Washington StreetJacksonvilleFL32275N/Anull
CLMCLM-4201652026-04-19T01:02:02Zchris—jimenez··08/25/00UHC-90658-11•••-••-5684N/A—·-——nullGRP-2075MEDICARE-ADV-A
PRVPRV-274282026-04-12T11:13:29ZETHANSSIMS5/8/1969UHC-64045-26—6139380739—6288 Elm StPlanoTX75005—·-
ENRENR-1066662026-09-27T18:43:18ZDONNA—TORRES1978-02-11UHC2287014•••-••-5338766-455-3844donna.torres@yahoo.com5372 BAYSHORE DR Apt 18Los AngelesCA90045GRP-2831MEDICARE-ADV-A
CLMCLM-4325872026-06-24T00:38:54ZJoseZ··Walker19670902UHC-06820-75•••-••-4869UNKNOWN—3288 Apache BlvdDallasTX75287GRP-6531UNKNOWN
PRVPRV-277842026-09-05T15:17:17ZMARK—HOLMES1985-06-05NULL·NULL(657) 699-0025null9633 River RdHOUSTONTX····UNKNOWN··
CLMCLM-4025872026-03-12T23:33:23ZJennifer—Oliver06/16/72—N/A(660) 692-0658NULL9553 Highland AvenueSeattle··wa98153GRP-8813OPTIONS-PPO
ENRENR-1385452026-03-01T23:47:35ZSARA—LITTLE1987-08-14UHC-83330-48•••-••-0201(247) 901-2868sara.little59@yahoo.com7101 MAIN STChandlerAZ-GRP-5334SELECT-EPO
TPATPA-644202026-08-07T00:37:10ZAmy—Graham2004-10-25—UNKNOWNNULLamy.graham@aol.com-····UNKNOWNNULLnullN/A
CLMCLM-4219762026-03-28T18:27:53ZWheeler, Thomas——1951-03-02·UNKNOWN•••-••-3831627.238.2541N/A5073 MARKET STREETCHANDLER··AZ85280—null
PRVPRV-229262026-06-18T02:15:05Z Sarah—Campbell··1945-02-09UHC-65576-41——N/A671 Canyon RoadCHARLOTTENC28223——
CLMCLM-4269952026-05-28T16:04:10ZHarold—Matthews1967-11-23UHC-47451-76NULL·null—·1371 Elm StNashvilleTN··37212-1094GRP-1782CORE-HMO
ENRENR-1151002026-09-08T02:53:50Z Michelle—RileyMar 18, 1939UHC-95909-02•••-••-68593256413894····888 Cedar LnTucsonAZ85741GRP-7446SELECT-EPO
100,000 rows, page 63 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:34.787Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty