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
PRVPRV-290732026-06-19T22:58:48ZbrittanyWtaylor05/07/41UHC-11983-40null940.329.9157UNKNOWN3835 Ridge RdTempeArizona··85298—null
CLM CLM-4198222026-09-01T22:39:06ZCastro, Ryan——08/28/1963UHC-23084-63—648-595-5250—4342 Apache BoulevardMinneapolisMN··55481··UNKNOWN—
ENRENR-1077922026-02-26T03:29:43ZJacob—Warren1988-08-12UNKNOWN—979.434.1797··JACOB.WARREN85@HOTMAIL.COM860 Market StreetDallasTX75236-9152GRP-7264OPTIONS-PPO
ENRENR-1112822026-01-09T03:22:01ZANGELA—VALDEZ12/28/1994UHC-70844-46•••-••-68699305551834angela.valdez@proton.me6996 Jefferson AveMINNEAPOLISMN55494GRP-3953choice-plus-ppo
CLMCLM-4156402026-06-11T23:03:59ZRonald—Fuller1939-02-12·UNKNOWNnullN/ARONALD.FULLER@GMAIL.COM7629 Hillcrest RoadPlano·TX75086·GRP-6030SELECT-EPO
CLMCLM-4017442026-04-26T21:55:08ZBRADLEY—RICE3/12/1983UNKNOWN•••-••-0054280-738-1003UNKNOWN4855 Bayshore DriveAtlantaGA·30350GRP-8433NAVIGATE-HMO
ENRENR-1249432026-06-05T22:30:28ZThompson, Theresa——1998-04-21·UHC-43516-11—(306) 537-2127··THERESA.THOMPSON65@PROTON.ME7858 Palm DrivePlanoTX75016GRP-3889select-epo
CLMCLM-4224982026-07-19T22:38:11ZLORI—PORTER1946-02-14UHC-02218-88NULLN/Alori.porter72@hotmail.com8225 Grand AvePlanoTX75062GRP-4329SELECT-EPO
CLMCLM-4088912026-05-01T00:26:40ZKATHRYN—BAILEY1952-03-04UHC-55375-25—388.662.0737UNKNOWN4062 Baseline RdTAMPAFL33627GRP-1663—
PRVPRV-252922026-01-07T22:59:28ZKimberlyROrtega··—-•••-••-76786494069936—·7148 Sage CourtJACKSONVILLEFL-N/Anull
ENRENR-1282062026-08-01T05:34:45ZFrancesLRuiz3/16/1994UHC-53327-52•••-••-00103817942729-··9212 MAIN STREET Apt 2AtlantaGA30353GRP-6383MEDICARE-ADV-B
PRVPRV-235172026-06-04T17:02:29ZHiroshi··Martinez8/27/1946N/AUNKNOWN(374) 214-9810hiroshi.martinez@outlook.com4432 Spring St #758Las VegasNV89182UNKNOWNN/A
CLMCLM-4177712026-01-22T07:07:28ZAmyNLarson2005-06-02NULL—NULL—1811 CANYON ROADScottsdaleAZ85207GRP-5135—
CLMCLM-4037462026-08-06T15:05:25Z·Cynthia—Castro10/16/88UHC-17557-30—·855-699-0149CYNTHIA.CASTRO@AOL.COMnullN/A—NULL-NULL
ENRENR-1372742026-01-29T00:46:35ZNICHOLAS—SANTOSMay 25, 1973··UHC-65934-13•••-••-4728+1 641 917 1258nicholas.santos@aol.com6211 Main StreetMESA···AZ85237GRP-3756MEDICARE-ADV-A
ENRENR-1339472026-04-10T14:15:52ZGrace—WongOct 21, 1974UHC-64071-61•••-••-7243895-358-0520grace.wong83@icloud.com6636 MARKET STSACRAMENTO··CA95806GRP-5328navigate-hmo
CLMCLM-4060332026-03-10T21:20:39ZWei··RJimneez1995-10-22UHC-80888-58•••-••-2096—null—·nullUNKNOWNnull·GRP-0876·NAVIGATE-HMO
ENRENR-1330132026-01-10T14:59:34ZHiroshi··—Munoz·1997-10-12UHC-53870-78•••-••-64897589484106hiroshi.munoz91@gmail.com5815 Mountain View Drive·FresnoCAN/AGRP-1811·CHOICE-PLUS-PPO
PRV PRV-279302026-06-11T08:42:16ZCatherine—Wheeler1952-10-07UHC4838089—·8033194021NULL3516 HARBOR BLVDTampaFL33696NULLnull
CLMCLM-414422 2026-10-07T10:59:38ZNicole, Banks——Dec 26, 1996UHC-03903-87•••-••-3194551-404-5899UNKNOWN2517 Mountain View DriveMesaAZ85200··GRP-5995NAVIGATE-HMO
TPATPA-629472026-06-02T08:32:22ZAMBER—FOWLER19780217N/A-+1 556 511 5934—355 Maple AveColumbusOH··43264NULLMEDICARE-ADV-A
ENRENR-1055292026-07-15T16:41:59ZISABELLAXGONZALES09/26/1970··UHC-66316-78•••-••-1375772-378-7258—1721 Washington StreetHoustonTX77075GRP-7041MEDICARE-ADV-B
CLMCLM-4241262026-02-01T13:43:31ZPhilip—Guzman1/5/1996UHC-22868-86N/A·UNKNOWNnull8571 Main StOrlandoFL··32886GRP-8180OPTIONS-PPO
CLMCLM-4134072026-08-17T11:15:32ZLinda—Martinez11/21/1949UHC-20270-48•••-••-4727—null9175 Elm StSEATTLEWA·98172UNKNOWNCORE-HMO
ENRENR-1207862026-03-11T12:24:57ZAlbertX···Daaniels1952-03-03UHC2762755•••-••-6035788-222-8939albert.daniels@hotmail.com8304 Grand AvenueSacramento··CA95860GRP-9823OPTIONS-PPO
ENRENR-1187932026-10-08T14:34:00ZDennis··—Gordon2008-08-26UHC-06284-88-6497961926··dennis.gordon48@proton.me1278 Canyon RoadScottsdaleAZ··85271GRP-3626NAVIGATE-HMO
ENRENR-1108262026-09-14T15:57:30ZBilly—Olson9174-06-21UHC8727266•••-••-2053—billy.olson@yahoo.com8096 River RoadMesaAZ85259GRP-6840SELECT-EPO
ENRENR-1113762026-04-22T15:00:31Z·Helen—Padilla-UHC-77953-98•••-••-75904198398627·NULL5997 BAYSHORE DRTempeAZ85285GRP-8947MEDICARE-ADV-A
CLMCLM-4073262026-01-31T22:46:53ZAnaZ.Burns1/27/1979UHC-41549-61UNKNOWN(825) 596-9663UNKNOWN226 Ocean Ave·OrlandoFL32861GRP-2544—
CLMCLM-4056052026-05-30T23:45:17ZADAM—VASQUEZ1978-12-15UHC-91157-09•••-••-4951(397) 428-7745UNKNOWN9625 Hillcrest RdCHARLOTTENC28263·GRP-0117-··
TPATPA-614712026-09-16T07:43:55Z·Ethan—Sanchez1971-12-04UHC-35179-03—N/AUNKNOWN1217 OAK STSan Antoniotx78252GRP-1709-
TPATPA-576082026-06-29T00:17:23ZBarbara····Garza1980-86-23NULLnull·null—3720 MESA DRDallasTX75268GRP-3315CORE-HMO
ENRENR-1429222026-05-27T11:03:59ZrogerI.garza19610312UHC-70965-65•••-••-3749794-719-7749ROGER.GARZA@HOTMAIL.COM8262 MARKET STPhoenixAZ—GRP-5989CORE-HMO
CLMCLM-4002412026-05-03T10:36:07ZRyan—Morris1952-04-13UHC-89195-88-(807) 882-1678—2497 Church StAtlantaGA30350—SELECT-EPO
ENRENR-1369342026-02-15T17:16:53ZSaraCMoreno1942-09-22UHC-58120-86•••-••-937713826822296—4844 Cedar LnMinneapolisMN55489GRP-1317CHOICE-PLUS-PPO
ENRENR-1176192026-09-18T08:14:05ZMarshall, Linda··——1998-10-09UHC-40406-99•••-••-0340548-306-7867linda.marshall@icloud.com··4299 Jefferson AvenueSacramentoCA··95868·GRP-8566MEDICARE-ADV-B
CLMCLM-4229682026-08-23T12:55:31ZBrooks, Barbara——1996-11-13UHC-35893-48•••-••-0481UNKNOWNNULLN/A——··—NAVIGATE-HMO··
ENRENR-1232112026-09-24T08:50:47ZRNOALD—BOWMAN1944-07-20UHC-10475-40•••-••-5880+1 867 613 4681·UNKNOWN9323 Willow CtTampaFL33628GRP-4691MEDICARE-ADV-B
PRVPRV-257822026-01-13T12:51:40ZLarry—Baks1946-05-21UHC-47014-15N/AN/A-7288 Mesa DriveSacramentoCA95840·N/ACHOICE-PLUS-PPO··
CLMCLM-4020552026-02-10T21:31:31ZWalter—Oretga11/18/60UHC-32319-15•••-••-7402—walter.ortega@icloud.com·3191 Elm StSAN ANTONIOTX78296nullNULL
ENRENR-1082642026-04-30T10:19:35ZRONALD····OLSON2002-07-09·UHC-08070-86•••-••-35798556989012RONALD.OLSON@ICLOUD.COM1492 Union StreetMiamiFL33142GRP-4826OPTIONS-PPO
ENRENR-105651 2026-01-28T04:09:26ZSUSANBSANCHEZ1984-01-12UHC-49183-97•••-••-5261755-711-6008··NULL8249 Desert Sky BlvdTampaFL33657·GRP-1474NAVIGATE-HMO
ENRENR-1126592026-09-13T02:05:00ZBRYANUROJAS1953-05-19UHC-03515-12•••-••-056415964123625NULL1089 Washington StEden PrairieMN55332GRP-9062SELECT-EPO
TPATPA-587082026-02-20T00:35:17Zcamila··maldonado1945-12-01UNKNOWN—710-889-4874nullUNKNOWNN/AnullN/ANULLMEDICARE-ADV-B
CLMCLM-4239522026-01-17T13:53:13ZReed, Ann——1969-04-14UHC-75559-79NULL····NULL—N/A····GRP-8125-
ENRENR-1104492026-05-22T19:30:04ZJOYCE—SANDERS07/12/54UHC-76833-52•••-••-847219186999314joyce.sanders@aol.com1135 Harbor Boulevard Apt 16SAN ANTONIOTX78272GRP-6504MEDICARE-ADV-A
PRVPRV-236032026-01-31T13:48:55ZBeverlyY·Hunt·5/6/1984UHC-39169-49··UNKNOWN+1 337 333 6093BEVERLY.HUNT84@PROTON.ME1902 Maple AveGilbertAZ85246··NULLN/A
TPATPA-527822026-05-23T03:15:30ZJASONZ.MORALES··1947-11-11NULL•••-••-722817029978960—3993 Desert Sky BlvdCharlotteNC28246-··—
TPATPA-519512026-02-22T16:17:21Z·Boyd, Willie——·10/16/04UHC-34280-19•••-••-5586—null2977 River RdGilbertAZ·85261UNKNOWN····
PRVPRV-239052026-01-24T21:08:01ZRUSSELLSBAILEY1987-04-01·UHC-87909-52—14224240293null4758 Maple AveChandlerAZ85276--
100,000 rows, page 215 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:37.728Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty