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-629382026-04-04T06:49:31ZHarold—Butler1939-08-28-—738-426-8489null151 Valley View DriveSeattleWA98145GRP-1721CORE-HMO··
TPATPA-508472026-02-25T23:13:01ZCharlotte··Alexander07-07-2001UNKNOWNUNKNOWN770-344-6462··NULL903 Meadow LaneHoustonTXNULLGRP-1772MEDICARE-ADV-B
TPATPA-597902026-07-06T21:08:36ZWaston, Heather——1998-02-19N/A•••-••-6891nullheather.watson5@yahoo.com310 MAIN STPLANOTX··N/AGRP-6962··CHOICE-PLUS-PPO
TPA TPA-562772026-06-04T09:45:23ZPhilip—ValdezMar 2, 1996null•••-••-2145719.893.6030null713 Camelback RoadDenverCO·80234-SELECT-EPO
TPA TPA-594062026-03-07T00:10:50ZCharles—Evans1976-10-02—NULL··—2088 BroadwayGlendaleAZ85375NULLCORE-HMO
TPATPA-582782026-01-08T03:42:10ZRANDY····WOODS1976-04-09N/A•••-••-2595+1 394 704 2040—1919 MARKET STREETPHOENIXAZ85057-4975——
TPATPA-606932026-05-21T11:50:03ZNunez, Sharon—····1953-04-24—null--7758 Willow CourtLas VegasNV89184NULL·N/A
TPATPA-566372026-04-09T22:59:06ZMARTHHA—ROGERS09-10-1942UHC-97687-25····704.821.2313null7733 Jefferson AveSan AntonioTX78213···SELECT-EPO
TPATPA-525392026-02-16T07:22:39ZValentina—Thomas1972-06-05-—UNKNOWN—8837 Hillcrest RdGILBERTAZ85228—UNKNOWN··
TPATPA-613992026-07-19T17:34:30Zmarcus—thompson1996-04-15UNKNOWN•••-••-5009——4858 Apache BlvdATLANTAGA30307GRP-3685null
TPA TPA-572962026-04-19T13:08:11ZShirley—Rogers1971-12-14··null(230) 426-9274shirley.rogers@aol.com5718 Lake View RdColumbusOhio43203UNKNOWN—
TPATPA-584032026-10-11T09:55:42ZWhite, Sandra——1941-03-24NULL—UNKNOWNUNKNOWN498 MAIN STREETSan AntonioTX78253—N/A
TPATPA-584762026-08-29T15:54:54ZSofia—Weber14-11-1987NULL•••-••-1290N/ASOFIA.WEBER29@GMAIL.COM—N/A—N/A··CORE-HMO
TPATPA-569732026-06-22T14:52:43Zcharles—ray09/17/1951-··•••-••-5853UNKNOWN····8897 Ridge RoadNashvilleTN37227N/A—
TPATPA-597142026-08-03T16:24:13ZDylan—Ellis1967-03-09-—(211) 241-9749-1179 Main StTucson··AZ85771GRP-0726··UNKNOWN
TPATPA-509742026-07-26T03:29:11ZRichard—Herrera1961-06-17NULL•••-••-3525NULLrichard.herrera@gmail.comNULLN/A—N/AGRP-8959N/A
TPATPA-544612026-05-17T09:54:01ZDylan—Simpson1996-12-09UNKNOWN··--N/A4745 Lake View RdMinneapolisMN55475NULLNULL
TPATPA-600522026-05-09T09:26:00ZScott—Maldonado6/23/1988N/A——UNKNOWNNULLN/A-·UNKNOWNGRP-0473··—
TPATPA-526952026-06-09T13:35:32ZJulie··—Vasquez04/09/70UHC-46484-67•••-••-6425—JULIE.VASQUEZ14@OUTLOOK.COM3365 Willow CourtSacramentoca··95816GRP-5006SELECT-EPO
TPA TPA-532532026-05-24T14:21:32ZPAMELA—MATTHEWS1990-07-12-•••-••-5282—null7195 Sage CtHoustonTX77026—NULL
TPATPA-536112026-10-04T17:57:03Z ISABELLA—FERNANDEZ19720711NULLUNKNOWNUNKNOWNisabella.fernandez@icloud.com4521 Jefferson AveOrlandoFL32843—MEDICARE-ADV-A
TPATPA-622652026-01-23T13:24:36ZValntinaIElliott05/17/1954UNKNOWN—(232) 689-5943—7142 CANYON RDSan Diego··CA92149GRP-4561NULL
TPATPA-550472026-06-13T19:50:05ZArnold, TerryN.—·1952-02-27N/A•••-••-5838N/A-·5298 Elm StreetSacramentoCA—-—
TPATPA-597802026-08-03T23:25:14Z Luis····Tucker1953-09-13UHC-25918-17•••-••-7803nullluis.tucker30@yahoo.com·4409 Hillcrest RoadAtlantaGA30307GRP-6928—
TPATPA-638802026-02-08T13:09:51ZWelch, Susan··—1/10/1983N/A··nullN/A6930 Cedar LnMinneapolisMN55464··UNKNOWN·NAVIGATE-HMO
TPATPA-522252026-03-28T22:37:28ZBrian—LittleFeb 9, 1946UHC-65114-56•••-••-0853N/AN/AnullUNKNOWNN/A-GRP-4042-
TPATPA-640492026-08-20T03:07:16ZJulie—EvansOct 16, 1978·UHC5113508NULL——847 Sage CtTUCSONAZUNKNOWNGRP-7869—
TPATPA-631862026-08-30T21:43:18Z·Patrick—Gutierrez17-10-1991UHC-55935-35—(631) 559-2738patrick.gutierrez99@aol.com9066 CEDAR LNEden PrairieMN··55390N/ANULL
TPATPA-560292026-05-11T21:01:59Z·KAREN—LUNA1990-04-10—-UNKNOWN—4710 Sage CourtLos AngelesCA90031GRP-4076null
TPATPA-583262026-02-21T09:20:02ZMelissa—Moreno1988-04-02—•••-••-0325———N/ANULLNULL—null
TPATPA-626462026-09-02T16:17:06ZShirley—ReyesMay 17, 1939UHC-10284-93NULL··shirley.reyes87@yahoo.comN/A——N/AGRP-8096····
TPATPA-575862026-09-27T20:05:53ZLucas, Hannh——1986-12-09UHC5495170•••-••-7797(714) 565-5361NULL—null—··—MEDICARE-ADV-B
TPATPA-56603 2026-03-21T21:57:21ZEugene—Kennedy04-02-1955NULL—nulleugene.kennedy@aol.com·4602 GRAND AVENUEFresnoCA93727GRP-3376—
TPATPA-621142026-05-05T22:24:40ZSCOTT—·MITCHELL2/20/1975—null773-549-2511-·9701 MAIN STScottsdaleAZUNKNOWN—NULL
TPATPA-633542026-02-17T23:34:55ZFernandez, BradleyZ—1973-05-28-•••-••-2392—UNKNOWN6847 Harbor Blvd··MiamiFL33180GRP-8291CHOICE-PLUS-PPO
TPATPA-572122026-05-19T03:56:45ZNicholas—Sullivan2004-02-02—N/A-UNKNOWN6528 River Road·ScottsdaleAZ85259-··SELECT-EPO
TPATPA-597662026-07-27T23:51:17ZHiroshiUSchultz··23-07-1978—NULL987.390.4263NULLnullNULLnull·UNKNOWNN/AN/A··
TPATPA-544002026-01-23T18:17:59ZMARCUS—TUCKER1964-12-03-UNKNOWN—-2769 Sage CourtSAN ANTONIOtx78264—UNKNOWN
TPATPA-511582026-05-04T09:39:31ZLUIS—SANDOVAL02/12/86UNKNOWN•••-••-0385770.904.7669LUIS.SANDOVAL@OUTLOOK.COM2264 Harbor BoulevardCharlotteNC28276··UNKNOWNnull
TPATPA-592362026-07-28T13:02:11ZNICOE—SNYDER1988-07-06null—UNKNOWN—6336 Spring StSAN ANTONIOTX78237····—
TPATPA-535442026-06-18T13:07:30ZRaymond—Rivera··1998-11-02UHC-09573-41—·(469) 938-0078—9199 Sage CourtSEATTLEWA98120--
TPATPA-518792026-02-11T07:11:14ZPatrick, Willis——03-07-1966——(411) 440-4827PATRICK.WILLIS15@YAHOO.COM1850 Cedar LaneDenverCO80233—CHOICE-PLUS-PPO
TPATPA-555042026-09-02T19:10:01ZDonna——12-08-1975NULL—833-933-5733—8277 Camelback RoadTEMPEAZ85237GRP-5780N/A
TPA TPA-606562026-02-15T07:18:00ZValentina—Harvey19430328··-•••-••-6139UNKNOWNN/A7433 BROADWAYScottsdale··AZ85261——
TPATPA-642932026-07-26T17:44:30ZWALTER—SANTOS1946-09-15NULLNULL+1 671 591 0608-8694 Baseline RdNashvilleTN37234-N/A
TPATPA-522662026-03-26T18:17:46ZTerry··Williams1974-12-27—····+1 241 650 4018terry.williams17@yahoo.comNULL-UNKNOWNUNKNOWN—NULL
TPATPA-644602026-09-14T23:15:29ZPATRICIA—YANGOct 21, 1991-UNKNOWN··—3279 Cedar Ln··TucsonAZ85792GRP-4245—
TPATPA-582392026-09-09T17:34:13ZPeter—Gray1964-10-26-··•••-••-9434337.607.9810—3465 CHURCH STGLENDALEAZ85332GRP-0579····
TPATPA-612352026-01-20T10:21:47ZPamela—Bailey2008-05-18—•••-••-2468—NULL··N/A——·-—UNKNOWN
TPATPA-606082026-01-30T18:19:19Z Alice—Gonzales··Feb 5, 2004—•••-••-7138322-953-1258·N/Anull····nullN/ANULLCORE-HMO
14,474 rows, page 60 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:40.307Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty