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-551522026-07-04T19:19:10ZSUZAN—WARD1959-08-18——UNKNOWN—8521 Highland AveNashvilleTN37228GRP-2976—
TPATPA-534082026-04-27T12:41:56ZHarrison, Ronald····—22-05-2004UHC-33242-35•••-••-2480——8077 Maple AvenueDenverCO80267-9077-··UNKNOWN
TPATPA-624312026-08-14T19:20:36Z JACK—BISHOP1493-04-02UHC-95340-02······UNKNOWNN/A411 WASHINGTON STREETSAN ANTONIOTX78280-UNKNOWN
TPATPA-631812026-01-30T21:49:57ZSHYRLEY—BANKS1947-01-01··—•••-••-9924··-125 LAKE VIEW RDCharlotteNC28255-SELECT-EPO
TPATPA-615912026-08-20T12:29:15ZAndrson, Thomas——1943-05-21NULLN/A6514995572—1774 Willow CourtSeattleWA98110-5124-UNKNOWN
TPATPA-601932026-01-07T22:43:44ZJose—Arnold1973-03-20—-7735759385jose.arnold61@proton.me9748 Lake View RoadNashville·Tennessee37247UNKNOWNMEDICARE-ADV-A
TPATPA-578782026-04-22T10:58:34ZAdam—Rodriguez1997-06-16NULL—4485379656—7818 Oak StSan DiegoCA92131GRP-9831MEDICARE-ADV-A
TPATPA-622262026-05-27T14:55:25ZYoung, Russell··—May 14, 1950-NULLnullnull6989 MOUNTAIN VIEW DRIVETempeAZ85272-9571GRP-6836—
TPA TPA-517442026-07-14T19:17:00ZSamuel—Estrada1976-06-12—NULL·-—null··NULLUNKNOWNNULL—
TPATPA-567692026-04-12T11:42:41ZWalker, Cheryl··—1944-07-15-nullN/A—4512 Oak StreetTucsonAZ85733NULL-
TPATPA-583222026-02-23T04:22:51Z Larry—Chapman11/16/1981··null•••-••-1964—larry.chapman5@aol.com3349 Union StreetEDEN PRAIRIEMN55390N/A—
TPATPA-525622026-07-29T14:17:01ZRobertson, Doris——03/03/1951·N/A-626-817-3802··NULL1581 Canyon RdHoustonTexas77097GRP-9192MEDICARE-ADV-A
TPA TPA-550262026-08-02T09:35:05ZWEI—HANSON·20-02-1956null—+1 576 301 9804—7792 SPRING STREETNashvilleTN37238GRP-2321CORE-HMO
TPATPA-57301 2026-09-14T18:57:33Zamy—hudson1939-09-27NULL•••-••-6740N/Anull5584 Harbor BlvdTUCSONAZ85715··N/A
TPATPA-611912026-02-01T07:25:56ZRALPH—MITCHELL3/5/1977nullUNKNOWN+1 302 717 8580—9772 Camelback RoadTempeAZ85239-—
TPATPA-539472026-03-06T07:33:09ZSARA—SCHMIDT1983-10-15NULLUNKNOWN2524864766—6820 Willow Ct #596Nashville··TN37275N/A····
TPATPA-602442026-01-09T20:25:42Zkeith··—reid1955-08-15UHC-01857-96NULL(750) 659-7342NULL·4715 JEFFERSON AVENUE Apt 13LAS VEGASNV··89174GRP-2352—
TPATPA-627322026-02-02T20:25:10Z Keith··—Miller1959-07-13NULL··———355 Meadow Lane·MiamiFL33125UNKNOWNmedicare-adv-a
TPATPA-535672026-10-01T07:21:08ZJonathanOCarr2006-06-04UNKNOWN•••-••-9942(701) 694-7741NULLUNKNOWNnullN/A—·NULLUNKNOWN
TPATPA-603172026-01-08T16:31:44ZAMBERTWELLS1953-04-11—null——3814 PALM DRIVEEden PrairieMinnesota55386GRP-6435OPTIONS-PPO
TPATPA-547922026-07-29T10:30:13Zronald—patel1946-12-02·N/A•••-••-2336426-430-1569—795 Jefferson Ave #478DenverCOUNKNOWNGRP-4808MEDICARE-ADV-A
TPATPA-588462026-04-20T01:23:00ZKimberly—Clark1979-07-14·UHC-11805-38—889-626-2747-1289 Bayshore DriveMinneapolisMN55474-6013GRP-4258-··
TPATPA-545822026-05-07T18:41:11ZROYM.CRAWFORD2004-06-04UNKNOWNUNKNOWNnull—1696 Park PlaceMesaArizona·85297—null
TPATPA-544482026-05-23T15:54:52ZTHERESA—DIAZ··1940-08-20—UNKNOWNN/Anull1367 Highland Avenue·NASHVILLETN37215-1811—··
TPATPA-531612026-05-22T12:50:42ZGLORIA—ROGERSMar 18, 1984UHC-45329-47—4333501480·N/A5350 Desert Sky BoulevardAtlantaGA30347N/A-
TPATPA-523492026-06-12T19:06:29ZSOPHIA—HUGHES2006-11-23UNKNOWN—17506300514NULL2143 Bayshore DrTempeAZ85230NULLN/A
TPATPA-533442026-07-09T10:56:39ZBradley—Morales1961-10-24UHC-19703-38··—306-260-2819BRADLEY.MORALES8@GMAIL.COM4309 Canyon Rd Apt 30·ScottsdaleArizona85231N/A-
TPATPA-547902026-02-25T01:17:32ZTIMOTHYYWARD1976-11-04NULLN/Anull—2898 BroadwayAustin·TX78769-4892NULL—
TPATPA-622222026-08-23T03:14:19Z·Margaret—Jensen1954-12-27——·nullnull5804 Sunset BoulevardMinneapolisMN55494GRP-6456—
TPATPA-601582026-08-11T21:49:27ZNatthan··—Spencer1960-01-09—•••-••-3368—null3988 Sage CourtSan AntonioTX··78215·nullNAVIGATE-HMO
TPATPA-524632026-08-08T20:36:32ZDenny—Lawson1939-01-09-—(563) 340-1084DENNIS.LAWSON44@ICLOUD.COM7739 DESERT SKY BLVDGlendaleAZ85311—SELECT-EPO
TPATPA-534332026-09-11T02:41:21ZSCOTT—LONGJan 19, 2005-·nullN/A—333 PINE DRIVESAN DIEGOCA92132—-
TPATPA-590542026-08-21T14:48:05ZCarl····Santos19970313—•••-••-5756····null5306 Main StNashvilleTN37211UNKNOWNCORE-HMO
TPATPA-62519 2026-04-15T04:09:12ZFRANCES—BERRY··1968-02-08UHC-64195-37NULL204-703-3326-384 Highland AveMinneapolisMN55406UNKNOWNnull
TPATPA-527712026-05-16T23:37:55ZMICHELLE··—GARZA1964-01-08UHC-34895-65—7285666michelle.garza63@yahoo.com6394 Indian School Rd··TucsonAZ-·GRP-1252SELECT-EPO
TPATPA-62686 2026-06-08T21:53:53ZLORI—FRANKLIN1982-04-15null—-—3386 Washington StreetJacksonvilleFLN/A··null
TPATPA-572702026-01-29T01:11:40Zkeith··—ortiz·1947-05-06UNKNOWN—938-269-0989-··9658 Washington StreetTempeArizona85276——
TPATPA-564842026-08-17T19:45:35Zcharlotte··—smith06/03/08UHC0079761—19458913084N/A9825 Elm StEDEN PRAIRIEMN—-—
TPATPA-591692026-06-27T11:35:39Z·BARBARA—THOMPSON··28-10-1967-··—(627) 353-4245····UNKNOWN··nullN/A··—NULL
TPATPA-573442026-03-18T20:38:24ZFields, Amanda—··2006-11-23NULL——N/A··8596 Union StreetLos AngelesCA90015GRP-5669UNKNOWN
TPATPA-549082026-08-25T04:50:47ZKEITH—JONES1956-01-16——N/A—4325 CHURCH STGilbertAZ—GRP-7605NAVIGATE-HMO
TPATPA-500542026-07-28T09:39:04ZAaron···RMedina1978-11-05-NULLUNKNOWN-1917 SAGE COURTAustinTX··78739-7419GRP-2955CORE-HMO
TPATPA-535772026-01-20T18:27:38ZSOFIAIPORTER20020704————1396 APACHE BOULEVARDAUSTINTX78708GRP-8834choice-plus-ppo··
TPATPA-621822026-02-26T09:43:29ZDONALD—ADAMS1946-11-07—··UNKNOWNN/A9804 Sunset BoulevardPlanotx75003-MEDICARE-ADV-B
TPATPA-538572026-05-04T04:23:26ZEugene—Arnold1945-12-07NULLUNKNOWNnullEUGENE.ARNOLD@GMAIL.COM8379 Valley View DriveGILBERTAZ85204NULL····
TPATPA-508712026-06-02T15:22:38ZruthMmurray1938-05-13UHC-90896-58•••-••-9738289-311-6770—1962 LAKE VIEW ROAD Apt 5DALLASTX75259GRP-5012UNKNOWN
TPATPA-616382026-10-12T03:12:37ZMari—Jordan1979-04-01UHC-32080-45—UNKNOWNmaria.jordan@hotmail.com7536 Central AveAtlantaGeorgia30385GRP-5083—
TPATPA-583852026-03-13T05:11:22ZAustin—Bryant14-09-1970N/A-UNKNOWN—7242 Camelback Rd·Eden PrairieMN55312——
TPATPA-640052026-03-15T03:47:08ZTran, Mari—····06/18/82UHC-00957-09NULL··—maria.tran24@aol.com5726 Park PlPhoenixAZ85061—UNKNOWN
TPATPA-553642026-09-01T07:38:32ZEvelyn—Gonzales1962-02-20—null+1 703 410 6660UNKNOWN942 Valley View DriveSan AntonioTX78274-NULL
14,474 rows, page 99 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.451Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty