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-4180762026-03-16T18:12:52Zsalazar··—niccole23-06-1999UHC-15589-83•••-••-3476-nicole.salazar21@hotmail.com2170 Harbor BlvdSacramentoCA95838-3348GRP-7659NAVIGATE-HMO
ENRENR-1371042026-07-16T08:31:50ZDickZ.··Bailey1970-05-08··UHC-89724-56•••-••-43568244678316richard.bailey@yahoo.com735 Jefferson AveMiamiFL33100GRP-0998OPTIONS-PPO
CLMCLM-4055602026-07-31T03:47:14ZIsabella—Pena1962-12-23—N/A·(627) 607-1743·isabella.pena@hotmail.com——····UNKNOWNGRP-6844NULL
TPATPA-536572026-10-17T10:39:07ZJESSICA—VGEA1967-09-05—·N/A(768) 876-0369jessica.vega37@hotmail.com··8510 Ridge RdDallas·TX75225——
ENRENR-1093902026-03-18T18:06:22ZjuanNholmes6/3/1970··UHC-80034-40NULL··263-956-7921juan.holmes95@proton.me·8161 Harbor Blvd Apt 32MESAAZ85275GRP-0160MEDICARE-ADV-A
ENRENR-122017 2026-01-05T14:21:09ZJOSHUAWSHAW1977-03-20uhc-83625-46•••-••-7797913-789-7645joshua.shaw34@outlook.com6188 Hillcrest RdDallasTexas75228GRP-1458SELECT-EPO
CLMCLM-4040492026-07-13T23:35:12ZSophia—Dixon2005-06-24—UNKNOWN——6679 Main StreetGlendaleAZ85349GRP-7580MEDICARE-ADV-B
CLMCLM-4286182026-05-25T20:32:28ZJACK—YANG1943-06-04-—3408163035-··2958 CAMELBACK RDLas VegasNV89194GRP-8339NAVIGATE-HMO
TPATPA-612062026-08-04T10:33:41ZJASON—HANSEN19911227··nullnull(591) 254-3812N/A4417 Sage Ct Apt 33Eden PrairieMN55345nullnull
ENRENR-1388042026-05-15T23:49:46ZEdwards, Roy·W—1991-09-12UHC-95393-02•••-••-4246231.661.0302—6782 Harbor BlvdSEATTLEWA98114GRP-4996CORE-HMO
ENRENR-1293062026-06-30T13:32:42ZAronE.Vazquez·01/16/69uhc-12265-62•••-••-92603916780884aaron.vazquez62@icloud.com3443 River RoadSacramentoCA95803-3692GRP-5614SELECT-EPO
PRVPRV-252312026-05-16T18:03:41ZCARLOSSMCCOY1981-10-23····•••-••-873112367526035CARLOS.MCCOY55@YAHOO.COM4191 Grand AvenuePLANOTexas75061—NULL
ENRENR-1396212026-07-30T21:28:24ZHannah—FloresJul 12, 1954UHC-13128-47N/A(597) 716-0199hannah.flores@outlook.com7702 Main StMinneapolismn55432GRP-3543NAVIGATE-HMO
TPATPA-591632026-04-01T09:21:55ZNOAH—HALL02-05-1967N/A—-—8762 Desert Sky BlvdTAMPAFL33644GRP-4915null
TPATPA-522622026-03-24T04:17:32ZGeorge—Farnklin1964-06-09-—587-368-4956NULL-UNKNOWNN/AUNKNOWN——
PRVPRV-218202026-09-19T10:09:38Z·Timothy O.—Flores··1980-10-14UNKNOWN•••-••-4130UNKNOWN-2143 APACHE BLVDGlendaleAZ85350——
TPATPA-631892026-03-06T15:34:45ZLOGAN—PAYNE08-04-1986-N/A—null279 Apache Blvd·OrlandoFL32830GRP-0549NAVIGATE-HMO
CLMCLM-4276982026-09-02T20:02:50Z·SHARON—ROJAS1965-08-23—•••-••-5110NULL—9578 MESA DR·Denverco·80279GRP-0393CORE-HMO
ENRENR-1089502026-04-23T06:10:53ZAbbyTMason2003-07-27UHC-12071-84•••-••-9370262-742-3699abigail.mason52@yahoo.com851 Baseline RdCharlotteNC28284-4100GRP-2266CHOICE-PLUS-PPO
CLMCLM-4227662026-06-02T08:48:26ZAndrea—Gomez19871027··UHC-49598-70NULL——9419 Sunset BlvdTucsonArizona85762——
ENRENR-1244032026-05-13T01:41:28ZRuthIMaldonado·7/3/1989UHC1629148•••-••-0571+1 489 659 4682RUTH.MALDONADO@HOTMAIL.COM1565 Lake View RoadPlanoTX··75097GRP-7677NAVIGATE-HMO··
TPATPA-608822026-05-01T02:59:55ZJOYCE—COLEMAN·1971-05-08—-·(735) 547-1842joyce.coleman85@gmail.com5607 MEADOW LN #325Los AngelesCA90068—null
ENRENR-1078662026-04-30T10:32:25ZLARRYZ.BOWMAN1973-10-22uhc-91270-07•••-••-30017917114383larry.bowman45@icloud.com1972 VALLEY VIEW DRSAN DIEGOCA92102GRP-0259CHOICE-PLUS-PPO
ENRENR-1375902026-08-02T23:39:41ZWILLIAMT.WOONG05/15/80UHC-15878-72•••-••-3819420-745-5743william.wong78@yahoo.com7700 PALM DRIVE Apt 8ScottsdaleAZ85254GRP-0989NAVIGATE-HMO
CLMCLM-4190502026-08-15T05:11:38ZJesse—Wood1995-03-01UNKNOWN—2524971008—·UNKNOWN—NULLN/AGRP-6771null
CLMCLM-4094352026-01-27T01:34:47ZEvelyn—Owens10/17/1967—•••-••-1512747-820-4284evelyn.owens60@aol.com9133 River RoadGilbertAZ85224GRP-7873CHOICE-PLUS-PPO
CLMCLM-4092862026-04-30T09:01:28ZKyle··Webb22-06-1991·UHC-73310-75-N/AUNKNOWN3288 LAKE VIEW RDMesaArizona85270null··
PRVPRV-245472026-01-17T18:46:56ZCarolyn—Jordan10/12/1952·NULL-9293703365NULL3878 Market StCHARLOTTENCN/A·UNKNOWNN/A
CLMCLM-4121512026-05-09T13:49:30ZLewis, Nancy——·1984-11-14·UHC-97623-93•••-••-9718·NULLnancy.lewis@gmail.com6223 Valley View DrAustin··TX78732GRP-0800-
CLM CLM-4254472026-03-09T13:22:51ZSarah—Bailey1971-09-27UHC-07917-53•••-••-3417-sarah.bailey26@icloud.com5551 WASHINGTON ST #479DALLASTX75228-6913—·MEDICARE-ADV-A
ENRENR-1220512026-09-05T11:39:21ZDYLANKHOWARD11/09/2007UHC-80052-68•••-••-5566(895) 567-6415dylan.howard@gmail.com196 Church StreetPlanoTX75006GRP-2382MEDICARE-ADV-B
TPATPA-562412026-08-01T00:54:52Z JessicaJ.·Barnes1985-08-04null•••-••-7174-nullnull-null———
ENRENR-1302632026-05-10T11:12:09ZKELLYMJONES2006-12-04UHC-56875-75•••-••-9907(281) 617-9399kelly.jones@aol.com5026 MEADOW LNMesa··AZ85207GRP-0607CORE-HMO
TPATPA-574952026-10-11T12:11:33Zross—ruth1973-06-03—NULLUNKNOWN—4968 LINCOLN WAYCHANDLERaz85285NULL-
TPATPA-503252026-05-23T13:47:10ZSTEPHENC.MURPHY1955-10-14UHC-00291-43N/A·6837202601null9309 Ridge RoadNashvilleTennessee37202··N/Anull
CLMCLM-4240272026-05-20T06:37:39ZYuki—Evans08-12-1984null•••-••-4335NULL—8031 BroadwaySan AntonioTX··—GRP-3116SELECT-EPO
ENRENR-1070932026-06-03T01:55:33ZTERRYB.WOOD1984-09-13UHC-71510-58•••-••-1245-·····9043 Lincoln WayLas VegasNV89135GRP-1853CORE-HMO
ENRENR-1261682026-05-01T13:15:55ZJUANIROGERSUNKNOWNUHC-81488-38•••-••-6468932.728.3550—2839 Main StreetLos AngelesCA90050GRP-6779CHOICE-PLUS-PPO
PRVPRV-276152026-09-21T12:56:24ZGRACE—ORTIZSep 27, 1939—•••-••-8730418-687-9812-7871 Spring StORLANDOFlorida32872-9833N/A—
CLMCLM-4019462026-08-13T19:33:31ZChristina—Nguyen2003-04-20UHC-52000-64•••-••-0719—null9150 HARBOR BLVDSan DiegoCA··92182——
CLMCLM-4081632026-05-26T17:42:12ZPHILIPWBLACK1955-02-06—•••-••-4806818-343-1032—UNKNOWNUNKNOWN—N/AUNKNOWNSELECT-EPO
ENRENR-1369092026-01-05T06:13:49ZJimenez, Joseph———UHC-63252-08•••-••-99263127609582·UNKNOWN9058 CAMELBACK RDTempeAZ85244GRP-9382CORE-HMO
ENRENR-1308932026-10-07T23:58:32Zsteven—hunt1959-80-22UHC-31698-06•••-••-1799—steven.hunt@yahoo.com2211 Willow CourtCharlotteNC28208GRP-5976CHOICE-PLUS-PPO
CLMCLM-4272362026-04-11T18:32:58ZJoseph····Turner06/14/1957UHC-12535-13nullnull-··4916 Camelback RdTAMPAFL33682GRP-0928null
CLMCLM-4030952026-07-27T20:41:36ZAdams, Ann——1964-03-09uhc-49487-89•••-••-9781—····4774 BROADWAYScottsdaleAZ85244-2866GRP-9801CORE-HMO
ENRENR-1159022026-02-28T03:48:38ZAndrews, AnaW····7/20/1952UHC-89158-54•••-••-5291+1 327 202 2270ana.andrews62@gmail.com2817 APACHE BLVDDENVERco80201GRP-5546NAVIGATE-HMO
CLMCLM-4317682026-01-31T07:56:27ZhiroshiBday1998-11-02—--NULL9870 APACHE BLVD Apt 30MesaAZ85278-0610GRP-7800UNKNOWN
PRVPRV-263802026-06-20T03:38:50ZBobby··R.TurnerDec 25, 1943UHC-32889-50null2087869270bobby.turner77@icloud.com484 Washington StHoustonTX-N/A··—
CLMCLM-4132282026-10-05T14:40:08ZDOT—WALKERJan 28, 1980·UHC-09439-74N/A——3726 Canyon RdChandlerAZ85226—SELECT-EPO
PRVPRV-287192026-07-08T15:09:13ZCarolyyn—BennettFeb 8, 1940UHC-56432-79null2295118147··—·8185 LINCOLN WAYHoustonTX··77073nullN/A
100,000 rows, page 66 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.789Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty