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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-60821 2026-07-22T12:57:40ZClark····Elijah1945-08-06—•••-••-3887nullUNKNOWN1361 DESERT SKY BLVDEDEN PRAIRIEMinnesota55362GRP-4244CORE-HMO
TPATPA-507502026-07-19T03:18:15ZChristian—Robinson1950-02-06··•••-••-2609——4202 GRAND AVE··DenverCO80293GRP-7085UNKNOWN
TPATPA-629372026-02-12T08:48:03ZAustinU.··JensenAug 6, 1945—N/AUNKNOWNUNKNOWN6006 Church StreetSAN DIEGO·CA92179—NAVIGATE-HMO
TPATPA-546032026-04-28T19:30:39ZDANYEL—HAWKINNS15-06-2006····null—NULL6882 Harbor BoulevardGilbertAZ85221··——
TPA TPA-631442026-03-31T07:30:45ZEric—Burke06/20/1976null•••-••-0080(969) 792-7617ERIC.BURKE@YAHOO.COM5360 Valley View DriveSan Diegoca92194—NULL
TPATPA-521742026-08-18T21:05:55ZJack—Marshall1963-06-13UHC-15423-91—-jack.marshall32@icloud.com-NULL————
TPA TPA-515282026-04-28T18:02:38ZamyT.ryan2000-09-03UNKNOWN-—null7338 Elm Street·Charlotte·NC28204-6785—UNKNOWN
TPATPA-541342026-01-10T01:31:24ZJENNIFER—LARSON1989-06-21-•••-••-2353265.533.0194N/A4725 Elm St··PhoenixAZ85048-SELECT-EPO
TPATPA-627362026-10-03T23:06:50ZSANDRABSTEWART1956-07-25NULL•••-••-2267825-755-7553—7198 HARBOR BLVDSeattleWA98140null····
TPATPA-513912026-01-18T07:55:19ZEspinoza, Watler——1973-10-15null•••-••-0792·(895) 844-3276NULL7825 Cedar LnOrlandoFL·32851N/Anull
TPATPA-507712026-01-30T04:12:30ZKatherine—Russell11/1/1954nullNULLnull—2576 HILLCREST RDHOUSTONTX77017—N/A
TPATPA-504632026-03-23T14:13:34ZKelly—Larson1965-12-05nullN/A··N/AUNKNOWN3092 Washington StreetChandlerAZ85221NULL—
TPATPA-644392026-07-16T07:09:34ZJUAN—HALL1938-04-27UNKNOWN•••-••-3234—UNKNOWN3867 HILLCREST RDHoustonTX77020GRP-3680N/A
TPATPA-522912026-10-10T03:01:15Z·CarlVStephens2003-10-16N/A-8019346763N/A·6387 FOREST AVENUEJacksonvilleFLNULL——
TPATPA-594092026-05-06T23:10:31ZSANTIAGO—GREEN1998-04-02N/A··nullN/A6800 Canyon RoadColumbusOH43216—CORE-HMO
TPATPA-517742026-09-30T01:37:14ZAlexanderFBerry05/21/67—--—806 Apache BlvdLos AngelesCA···90048GRP-7065NAVIGATE-HMO
TPATPA-572542026-01-29T18:04:02ZNICHOLAS—·ARMSTRONG1968-08-14NULL•••-••-8398··N/A3483 Willow CtTucsonAZ85719—null··
TPA TPA-541012026-04-13T19:16:37ZWEI—MENDOZA··07/18/1965—nullNULLN/A69 Mountain View DrTampaFL33679-9940-··OPTIONS-PPO
TPATPA-550422026-02-13T19:28:35ZMATEO—HARRISON1960-10-10——NULL-7955 MAPLE AVEScottsdaleAZ85231··——
TPATPA-566332026-07-06T16:51:55ZRamirez, Danielle——1966-02-11—·N/A17599178217UNKNOWN·8031 Spring StreetMIAMI·FL33107GRP-4294-
TPATPA-635422026-07-04T06:18:22ZRANDY—PETERSON1959-11-26NULLNULL387-935-7982UNKNOWN1573 Pine DrivePLANOTX75001—UNKNOWN
TPATPA-508722026-04-15T23:16:06ZJanice··TAdams10/20/1960—null—UNKNOWN6917 Forest Ave··GilbertAZ85242UNKNOWN—
TPATPA-581502026-02-11T23:44:33Zbruce—·sanchez19580321UHC-55488-72•••-••-0043(724) 493-1820N/A2162 Hillcrest RoadSacramentoCA95843·NULLMEDICARE-ADV-A
TPATPA-503652026-07-26T05:36:22ZCharlotte—Pierce1954-07-02NULL•••-••-5809473.386.8810null8633 RIDGE RD··Eden PrairieMN55358GRP-3909UNKNOWN
TPATPA-520552026-10-15T20:07:27ZRobison, Aisha——1990-08-11··N/A-—9227 Canyon RdChandlerAZ··85251nullUNKNOWN
TPATPA-526062026-03-07T14:43:26ZPamela—Jones12/10/1975N/A—UNKNOWNUNKNOWN2254 SPRING STREETFresno·CA93792—UNKNOWN
TPA TPA-515462026-03-30T03:13:15Z Wilson, Teresa——1977-09-18uhc-45385-63N/A——456 Canyon RdTucsonArizona85775·GRP-2720CORE-HMO
TPATPA-62819 2026-02-15T06:29:57ZGardner, Jennifer——Mar 25, 1998—•••-••-5599—JENNIFER.GARDNER16@GMAIL.COM410 BASELINE ROAD··PhoenixAZ85037····N/A··
TPATPA-537382026-05-11T19:29:38ZJoeS.Matthews1945-05-09—•••-••-2066null-··1238 Willow CtLAS VEGASNV89183GRP-1415NULL
TPATPA-590872026-06-30T11:57:51ZDennisTTorres19890728UNKNOWN•••-••-27635144265239—-—N/AUNKNOWNGRP-5981NULL··
TPATPA-524482026-07-16T19:23:40ZGABRIEL—SALAZAR1943-02-04UNKNOWN—····-4562 UNION STGilbertAZ··85235—N/A
TPATPA-559942026-06-13T17:11:23ZANNA··—ANDRREWS02/22/1989null•••-••-4191——5660 Meadow LnGilbertAZ85235UNKNOWNUNKNOWN
TPATPA-596212026-05-29T18:49:14Zstephanie—campblel·1952-03-26—•••-••-5264665-374-2124—6703 RIVER RD Apt 29·DenverCO-NULLnull
TPATPA-623212026-02-13T11:18:42ZRADNY—VAZQUEZ·Jun 15, 1960——(636) 577-8967null--————
TPATPA-586022026-05-06T00:49:41Zgabriel—perkins··1945-04-18UNKNOWNnullUNKNOWN·-1327 Valley View Dr #658Scottsdale·azN/A··UNKNOWN-
TPATPA-580762026-04-23T00:22:33ZTERESA—·YANG17-01-2006UHC-39400-12NULL—nullN/A—-null—NULL
TPATPA-506952026-06-04T11:59:40Z RUSSELL—AGUILAR2004-04-06UNKNOWN--NULL226 Union StHoustonTX77038—UNKNOWN
TPATPA-514872026-05-14T09:12:42ZJOSHUA—WOOD14-11-1948—•••-••-0977·707-623-3476joshua.wood@outlook.com1039 JEFFERSON AVENUEMiamiFL33151null····
TPATPA-557922026-05-13T23:29:26ZSteven—Carlson1961-09-04--N/AUNKNOWN4558 HARBOR BLVDHOUSTONTX77065GRP-2959SELECT-EPO
TPATPA-630122026-05-05T00:56:26Z lucya—greene1952-04-08NULL•••-••-4544nullUNKNOWN·····-N/A-N/AUNKNOWN
TPATPA-609592026-08-05T07:30:23ZOlivia··Nunez·1941-10-20null—(764) 294-5244olivia.nunez@aol.comN/A····—-——
TPATPA-53400 2026-03-20T21:29:24ZHUNT—LAURA01-07-1988—•••-••-0420NULL-8070 MARKET STREETTAMPAFLNULLNULLUNKNOWN
TPATPA-547992026-02-04T23:43:36ZJoshua—Ryan1977-04-05——837-432-7389-1919 Ridge RdScottsdaleAZ85261GRP-7946null
TPATPA-504032026-03-17T18:43:11ZBRANDON—MUNOZ··1965-08-06NULL—(419) 903-4858N/A466 Desert Sky BoulevardJacksonvilleFL32253-N/A
TPATPA-633682026-06-24T02:26:17ZCarpenter, Janet······—19450316—•••-••-5330—-3704 Canyon RdAustinTX78710-·UNKNOWN
TPATPA-568372026-09-07T03:33:01ZRONALD—HOFFMAN1958-08-16nullnull9892199266UNKNOWN8607 OCEAN AVENUETUCSONAZ85715GRP-7685UNKNOWN
TPATPA-504232026-07-09T16:41:31Zbetty—howard1954-08-28N/A•••-••-31383852793684betty.howard51@aol.com7809 Sage CtCHANDLERAZ85237NULLMEDICARE-ADV-B
TPATPA-50086 2026-04-12T01:09:33ZSharon—Patel1955-09-08—•••-••-6638435.453.8479—400 Washington StCHANDLERAZ85207nullNAVIGATE-HMO··
TPATPA-534232026-06-20T23:54:33ZSandra—Yang1961-10-20nullN/AN/ASANDRA.YANG54@YAHOO.COM——·nullUNKNOWNN/A—
TPATPA-639682026-06-03T17:59:43ZDouglas—Alexander15-09-2006UNKNOWN•••-••-5322—NULL2798 Harbor BlvdEden PrairieMN··55388GRP-6995·UNKNOWN
14,474 rows, page 113 of 290PreviousNext

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:43.629Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty