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
ENRENR-1288812026-02-03T17:34:37ZSANDRA—GUERRERO1970-08-18UHC-39611-40•••-••-1139+1 915 885 1119—4202 Spring St·GlendaleAZ···85326GRP-3134options-ppo
CLMCLM-4004282026-04-09T15:22:08ZJEREMY—MITCHELL1946-04-04····•••-••-4757UNKNOWN—null-—-UNKNOWN··—
CLMCLM-4053562026-03-14T15:18:50ZSHIRLEY··BMORRIS1942-12-21UHC-34000-41•••-••-7130(258) 886-5895··4454 Camelback RdSacramentoCA95880GRP-4516null
ENRENR-1365082026-02-24T06:37:37ZSean—Mason1981-04-12UHC-64161-60•••-••-50678115006873sean.mason87@hotmail.com·9549 Harbor BlvdChandleraz85230GRP-4277CHOICE-PLUS-PPO
TPATPA-566132026-02-20T18:23:45ZStone, Laura··——17-02-1995null—861.409.8541NULL9078 CANYON ROADTampafl33658N/ANAVIGATE-HMO··
ENRENR-1152072026-02-13T23:52:08ZKelly—Watson01/01/1987UHC-99406-56•••-••-55018166214642kelly.watson@gmail.com8772 Desert Sky BlvdPhoenixAZ·85015GRP-1741NAVIGATE-HMO
ENRENR-1193542026-03-26T15:25:55ZTyler—Jones··1946-40-21·UHC3179333•••-••-1738(460) 250-8316TYLER.JONES@OUTLOOK.COM4500 Indian School RdPhoenixAZ85069GRP-6429OPTIONS-PPO
CLMCLM-4226922026-04-14T05:08:30ZRichard—Santiago·05/09/86UHC-26774-18•••-••-9830660-745-1570—9782 Bayshore Dr··Austin··TX78722GRP-3077··UNKNOWN
CLMCLM-4141442026-05-13T16:06:46ZDENNIS—·CONTRERASAug 27, 1998UHC-23357-72··N/A-·NULL1344 Mountain View DriveORLANDOFL32830——
ENRENR-1070522026-02-18T06:17:38ZCunningham, Wayen——1948-05-12uhc-85486-78•••-••-1397716-419-8484null6837 CEDAR LNSan AntoniotxnullGRP-0739CORE-HMO
ENRENR-1125182026-10-18T14:41:25Z ASHLEYP.SCOTT1998-04-22UHC-15919-77•••-••-0610444-443-2041··ashley.scott5@outlook.com5892 HIGHLAND AVEHoustonTX··77016GRP-0967MEDICARE-ADV-B
TPATPA-640372026-01-07T05:41:12ZLogan—Lnch08/25/67UNKNOWN——UNKNOWN6009 PALM DRIVEFresnoCA93755-3731nullnull
CLMCLM-4311432026-01-21T19:59:07ZVICTORIA····WATSON04/28/65UHC-16748-13•••-••-7716(615) 294-5436—·5576 Sunset BoulevardGlendale·Arizona85367UNKNOWNCORE-HMO
CLMCLM-4060152026-08-18T07:59:32Zdonald—luna1955-01-09UHC-18639-83N/A—NULL8713 Main StreetScottsdaleAZ85205GRP-3194MEDICARE-ADV-B
CLMCLM-429478 2026-01-27T11:44:47ZTheresa—Rogers·1966-02-03UHC-93439-83·····7816874581—5959 FOREST AVEMesaAZNULLGRP-1814-
ENRENR-1016212026-09-26T11:53:08Zhiroshi—wang19660210UHC-08450-66•••-••-9413757.549.4570HIROSHI.WANG53@GMAIL.COM4121 Valley View DriveHouston··TX77043-5841GRP-9932MEDICARE-ADV-A··
TPATPA-644712026-09-25T10:24:24ZMargaret—·Patel06/28/91——+1 259 551 6968-6042 HILLCREST ROADAustinTX78791-1829—OPTIONS-PPO
ENRENR-1140272026-10-06T04:58:35ZZachary—Franklin1940-06-32··UHC-52223-19NULL16803819537zachary.franklin71@icloud.com4538 Ocean AveDallasTX75289-9279GRP-9154SELECT-EPO
CLMCLM-4053462026-09-28T12:18:08ZBruce—Porter15-04-2005·null·UNKNOWN(975) 299-4052BRUCE.PORTER70@ICLOUD.COM1886 Maple AvenueTempeAZ85247GRP-7182SELECT-EPO
TPATPA-502922026-09-05T16:26:37ZYuki··E.·Berry01/02/1953N/A--—5752 LINCOLN WAYAtlantaGeorgia30354N/ACHOICE-PLUS-PPO
ENRENR-1029012026-02-28T14:35:03ZAdam—Collins19791223UHC-52575-77•••-••-1686UNKNOWNadam.collins17@proton.me4869 WILLOW CTColumbusOH·43290GRP-2809OPTIONS-PPO
PRVPRV-275002026-04-14T20:36:19ZMEGAN····FERGUSONAug 10, 1988N/A•••-••-2713+1 709 677 6678—3570 Grand AveSeattleWA98152NULL—
ENRENR-1128592026-06-12T00:17:41ZPaulBWalker1959-08-20UHC4415241•••-••-2996309-399-1169paul.walker8@hotmail.com6157 MEADOW LNNashvilletn37216GRP-3408CORE-HMO
CLMCLM-4244222026-01-12T22:47:36ZDorothy—Harvey2002-08-24—null(313) 604-0690dorothy.harvey@proton.me4150 Apache BoulevardGlendaleAZ85322GRP-7078NAVIGATE-HMO
ENRENR-1196002026-08-09T01:28:50ZRichard—Sanchez1953-12-23UHC-22704-81•••-••-7061(850) 609-4050richard.sanchez@icloud.com349 Spring StMinneapolisMinnesota55448-4910GRP-8199CORE-HMO
TPATPA-570482026-07-20T20:08:30Zyuki—marquez11/13/1975NULL--—5165 Mountain View DriveHoustonTX—null—
PRVPRV-235122026-03-01T01:42:47ZFATIMA—ROBERTSON1941-11-02UHC-98227-66NULL(804) 870-5194····null——NULLnullnull
CLMCLM-4098902026-01-24T13:22:28ZJosephCLawson19-02-1981UHC-26174-27•••-••-9324+1 245 419 2338UNKNOWN—N/A-·nullGRP-7780MEDICARE-ADV-B
ENRENR-1400542026-10-11T20:38:45ZCAROL··—CARTER1974-11-05UHC-97175-90•••-••-203716402523155carol.carter@outlook.com6492 Washington StChandlerAZ85261GRP-0152CORE-HMO
CLM CLM-4105232026-09-27T05:11:40ZPatel, CharlotteY—2008-08-11UHC-45528-19—UNKNOWN—2247 Mountain View Drive·Los AngelesCA90024GRP-5158NAVIGATE-HMO
TPATPA-555592026-09-02T18:30:40ZOmar—Baker1982-12-17NULL•••-••-2095——5030 Desert Sky BoulevardOrlandoFL32808GRP-6402MEDICARE-ADV-A
CLMCLM-4150902026-01-24T12:56:04ZDANIELK.··REID23-01-1939UHC-18514-12NULL—N/A8395 Camelback RoadColumbusOH43209-7426-choice-plus-ppo
ENRENR-1309512026-06-03T07:29:07ZEugene—Franklin06/01/99UHC-34876-67•••-••-697219537519462eugene.franklin@yahoo.com4137 Mountain View DriveMiamiFL33145-4097GRP-0855··NAVIGATE-HMO
TPATPA-527332026-08-14T09:07:53ZLUIS—NGUYEN1977-04-15UNKNOWN—-N/A7453 Market StOrlandofl32833—UNKNOWN
ENRENR-1316362026-03-26T22:52:45ZBenjaminUMiller1945-10-25UHC-39246-17•••-••-0645(824) 586-4651BENJAMIN.MILLER92@AOL.COM2990 Sage CtSacramentoCA95849GRP-5782CHOICE-PLUS-PPO
CLM CLM-4298642026-04-16T12:43:29ZAisha—Salazar19531110·NULL-NULLN/A2129 Jefferson Ave··NashvilleTN37292-—
ENRENR-1338452026-01-10T22:12:05ZHaroldQLittle1988-09-28UHC-98462-25•••-••-0112734-619-3867·HAROLD.LITTLE@AOL.COM9630 UNION STREETCharlotteNC28286GRP-4853MEDICARE-ADV-B
ENRENR-1343952026-02-02T17:37:26Z·KEVINI.BROOKS1995-12-17UHC-23257-02•••-••-0137(700) 401-9902—7454 Valley View Dr··ColumbusOH43205GRP-6148OPTIONS-PPO
TPATPA-554382026-06-02T22:37:54ZRalphZLunaDec 5, 1978————·3844 Forest AveHoustonTX77070—CHOICE-PLUS-PPO
PRVPRV-254412026-10-05T14:09:10Z·steven—west1968-04-02UHC-27799-40··—null16 MESA DRIVEGilbertAZ85268——
ENRENR-1114642026-09-28T20:36:17ZGARYKSTONE1958-03-14UHC-84473-40··•••-••-3295NULLGARY.STONE42@HOTMAIL.COM9048 Church StSAN ANTONIOTX78241GRP-1030SELECT-EPO
CLMCLM-4289422026-06-08T14:00:18ZLARRY—BURTON1965-02-07UHC-16584-63•••-••-38668966346266null782 Pine DrChandlerAZ85271GRP-5532CHOICE-PLUS-PPO
CLMCLM-4236572026-08-15T12:25:50ZNATALIEH.DUNCAN19720322UHC-88287-19··——N/A930 Meadow LaneLAS VEGASNV89125GRP-1379OPTIONS-PPO
CLMCLM-4147272026-05-23T06:39:59ZJudy····Castro1984-02-12UHC-14119-09—(253) 861-8240··8470 Church St Apt 13PLANOTexas75003UNKNOWNNULL
ENRENR-1306642026-07-17T12:06:58ZDEGOZCUNNINGHAMJan 24, 1995UHC-87978-96•••-••-034918898050217DIEGO.CUNNINGHAM38@ICLOUD.COM·2574 BroadwaySan DiegoCA92134GRP-2622NAVIGATE-HMO
CLM CLM-4180302026-06-10T15:32:23Zkyle—hill12/22/2005—-14137661012N/A4264 Market StCharlotteNC28268UNKNOWNnull
CLMCLM-4025082026-05-29T02:30:54ZWILLIAM—SIMMONSJun 17, 1972UHC-76744-15null4213430868N/A3955 Oak StreetMiamiFL33134-7184NULL-
CLMCLM-409875 2026-05-14T16:15:10ZJason—Guerrero1949-07-19UHC-14738-35—-—1164 Indian School RdSEATTLEWA98130GRP-3440OPTIONS-PPO
CLMCLM-4179042026-01-11T00:05:18ZGEORGE··—SLVA09/06/1972UHC4378468•••-••-8286UNKNOWN-9064 Camelback RdGlendaleAZ85322NULLUNKNOWN
ENRENR-1271652026-06-20T02:24:00Z·melissaFhansenMar 18, 1996UHC-30457-37•••-••-1199·-MELISSA.HANSEN71@OUTLOOK.COM5176 Lincoln WayLas VegasNV89109GRP-0912NAVIGATE-HMO
100,000 rows, page 45 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.775Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty