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-621462026-08-12T08:56:09Z Brittany··Murray1994-03-07NULLUNKNOWNN/AN/A6221 Oak StHoustonTX··77007-SELECT-EPO
TPATPA-624112026-07-14T23:48:26ZJohn—Santiago1976-12-27NULL—·NULL—535 Canyon Road··Glendale··az85361UNKNOWNcore-hmo
TPA TPA-515162026-09-18T21:31:34Z·Welch, Sarah——09/22/1949·NULL—-·sarah.welch4@outlook.com8987 Sage CourtPhoenixaz85072N/ASELECT-EPO
TPATPA-604082026-06-29T18:29:34Zvirginia—buton09/10/1994N/AN/A(206) 741-0784—9443 MAPLE AVE··MiamiFL33144·NULLNULL
TPATPA-590062026-06-26T07:36:22Z ·Diane··Jones02/18/45UNKNOWNUNKNOWN(848) 292-3302—8790 BroadwayTempeAZ85229-NAVIGATE-HMO
TPATPA-584652026-06-25T09:09:31Z Tyler, Simpson——19581213UNKNOWN•••-••-5034UNKNOWNtyler.simpson@gmail.com8568 CEDAR LANEDENVERCO80272N/A—
TPATPA-550792026-05-07T22:16:27ZBarbara—BrooksNov 18, 1954—·NULL(668) 426-8957barbara.brooks@gmail.com7623 BAYSHORE DRLos AngelesCAnull—null
TPATPA-631292026-04-30T21:33:43ZShirley—Cunningham10-12-1973—•••-••-9431-shirley.cunningham60@icloud.com3784 Central AvenueSeattleWA·98167GRP-2692UNKNOWN
TPATPA-505122026-05-15T10:02:07Zjerry—·west09/21/2005-—N/A—·5719 Willow CourtChandlerAZ85278GRP-4022··MEDICARE-ADV-B
TPATPA-578212026-07-10T15:39:39Z BRENDA—·SANTIAGO01/10/1995null-(563) 732-7961NULL7882 WASHINGTON STGLENDALEaz85377UNKNOWNUNKNOWN
TPATPA-560342026-08-08T15:38:56ZBryan····Ferguson1977-11-06-UNKNOWN2685940852UNKNOWN323 Lincoln WayTampaFL33643UNKNOWNCHOICE-PLUS-PPO
TPATPA-556662026-06-04T23:05:52ZRoger—Simmons1991-07-04—null——856 Apache BlvdHoustontx77051——
TPATPA-561482026-05-05T02:00:42ZMASON··RIOS09/14/1950—•••-••-88572208220528—8770 WASHINGTON STREETGlendaleAZ85340——
TPATPA-580862026-06-15T17:54:10ZJamesNJacobs19380316N/Anullnull··NULL3229 Park PlaceSeattleWA98131-NAVIGATE-HMO
TPATPA-640742026-01-04T18:44:26Z MarianaM.Little·9143-09-05-•••-••-9748NULL··—4453 Market StChandlerAZ85286·GRP-7316····
TPATPA-53779 2026-04-26T07:35:36ZHAROLD—BAILEY19800805null—NULL····2892 Maple AveTUCSONAZ85756GRP-9203—
TPATPA-521222026-09-09T01:11:31ZArthur—Harris1984-02-13———N/A6027 CHURCH STREETSCOTTSDALEAZ85262··--
TPATPA-549362026-01-01T21:22:21ZLAWRENCE—RAY1790-19-85null•••-••-68613703101959-8789 Sunset BoulevardMiamiFL33159GRP-7242··
TPATPA-625242026-01-20T08:52:34ZSCOTT··KELLEY07/25/1995N/A•••-••-2550——9189 Canyon RdSeattle··WA98100-·N/A
TPATPA-612332026-01-17T08:34:09ZMatthew—Cook1984-12-20—-NULLmatthew.cook93@outlook.com7819 Main StreetColumbusOH43278GRP-5138null
TPATPA-573722026-07-02T02:06:17ZBraynHWood1953-06-28·N/A—NULL-8221 Willow Ct #383MesaAZnullNULLN/A
TPATPA-566452026-02-09T15:03:56ZDaniel—Jackson1951-11-21UNKNOWN•••-••-5084881-734-3579·N/A9136 Baseline RoadDenverCO·80242-3413GRP-7919NULL
TPA TPA-620232026-07-07T10:52:02Z·Weber, Santiago——1961-05-14··—·-13207846909··—1914 Forest Avenue··AustinTexas78703N/AUNKNOWN
TPATPA-609062026-08-16T00:43:42ZPaul—Gordon1954-05-19—nullnull—9470 Camelback RdMiamifl33165—OPTIONS-PPO
TPATPA-599712026-04-25T19:56:38ZAnaJ.Rice19670527UNKNOWNNULL(303) 611-3499N/A2102 Grand AveCHANDLERAZ85232GRP-4682CORE-HMO
TPATPA-512592026-06-04T17:44:16ZJIM—REID2008-10-13—•••-••-1458··null5685 Sage CourtSCOTTSDALE··az85269UNKNOWNN/A
TPATPA-584992026-03-26T21:07:18ZVincent—Reyes2006-10-23UHC-96719-08•••-••-7112—UNKNOWN8555 PARK PLACEPLANOTX75016nullUNKNOWN
TPATPA-527542026-04-19T10:15:41ZAlexisLRodriguez1965-01-09—•••-••-9422NULL··NULL8359 Camelback Rd·SeattleWA98199-5612null—
TPATPA-613302026-07-11T17:42:27ZLauren—Gordon1958-10-27-UNKNOWNnullnull2676 Mesa Dr Apt 24MIAMIfl33182GRP-6526SELECT-EPO
TPATPA-608432026-10-16T07:44:16ZEugene····Nichols11-03-1980-UNKNOWN12044201408eugene.nichols@gmail.com·1911 PALM DRIVEPhoenixAZ—GRP-4279NAVIGATE-HMO
TPATPA-527602026-01-07T01:52:48ZJessica—Mendez·Nov 24, 1958N/A•••-••-3692NULL—1455 MEADOW LANEPhoenixAZ85016-1152NULL—
TPATPA-622862026-06-26T06:10:03ZCAROL—STEVENS1947-08-14N/A—(781) 395-8341N/A5527 HIGHLAND AVEEden PrairieMN55321N/ACHOICE-PLUS-PPO
TPATPA-501872026-06-28T14:03:35Z ·LINDA—WONG19470211—UNKNOWN·816.505.9028N/A··6511 Canyon RoadDENVERCO80243-null
TPATPA-571612026-01-27T07:18:21ZSANDRA—ORTEGA1980-12-26UNKNOWN··N/A——-NULL-nullGRP-4532MEDICARE-ADV-B··
TPATPA-507782026-06-02T21:25:03ZAnn—Reyes1967-04-16-UNKNOWN919-929-3513ANN.REYES@ICLOUD.COM5760 Oak StreetGilbertAZ85281UNKNOWNUNKNOWN
TPATPA-521232026-05-24T07:46:53ZRonald—Sims04/26/1980—-nullUNKNOWN6616 JEFFERSON AVENUEEden PrairieMN55372UNKNOWNnull
TPATPA-51576 2026-04-29T21:22:03ZNICOLE····WOOD·2002-05-07UHC-81471-19—UNKNOWNnicole.wood@hotmail.com3460 Sage CtSan AntonioTX78286-9396NULLCHOICE-PLUS-PPO
TPATPA-621902026-08-09T07:59:07ZSANTIAGO··—MORENO1987-05-16—•••-••-5636(825) 759-1822N/A4391 BroadwaySACRAMENTOCA··95863NULLN/A
TPATPA-521362026-08-28T18:56:38ZZachary—Simpson1941-12-20—null(220) 605-7706null7880 Ocean Ave··Denver··CON/A··—NULL
TPATPA-539612026-09-15T02:27:38ZKathryn—Morris1945-11-03N/AN/A423-956-4422—2221 Forest AveJacksonville·FL32234GRP-2986CHOICE-PLUS-PPO
TPATPA-560622026-02-21T01:56:01ZSARA—BUTLER1957-12-03——228-339-3807···sara.butler2@icloud.com7267 GRAND AVENUECOLUMBUSOH43206GRP-1757UNKNOWN
TPATPA-640022026-07-16T00:55:40ZLinda—White1948-03-14-··—N/ANULL——NULL-NULL··null
TPATPA-54465 2026-09-10T14:11:29ZMATEOX.AUSTIN1976-03-24—UNKNOWNnull-6217 INDIAN SCHOOL RDGilbertAZ·85282··UNKNOWN
TPATPA-583972026-07-20T00:07:24ZTheresa—Thompson1998-04-21—-306-537-2127NULL··7858 Palm DrivePlanoTX—GRP-3889—
TPATPA-592232026-09-24T16:15:03ZDOROTHY—ROSS1994-12-28··-—+1 316 879 7479dorothy.ross90@proton.me9034 Cedar LnEden PrairieMN55380NULLOPTIONS-PPO
TPATPA-584472026-05-29T09:22:22Zroger—palmer1996-09-07—•••-••-7376——8924 Sage Court·NASHVILLETN37251GRP-1804CORE-HMO
TPATPA-582602026-05-25T16:20:12ZSam—Oliver3/1/1968NULL—-nullUNKNOWNUNKNOWNnull····GRP-7258CORE-HMO
TPATPA-587892026-03-08T06:51:41ZWAYNE—DAVIS1956-05-25—··244.841.5214NULL··4681 Oak StreetEden PrairieMN55309-9341GRP-2216CHOICE-PLUS-PPO
TPATPA-556802026-07-01T01:56:00Z·Robert—Bradley07/08/1977UHC-63686-35·UNKNOWN(577) 208-1093ROBERT.BRADLEY36@YAHOO.COM———NULLNULL—
TPATPA-553712026-06-12T07:18:53ZStephanie···Ruiz1999-01-26····null(430) 668-5495stephanie.ruiz@gmail.com1752 MAIN STEden PrairieMN55329——
14,474 rows, page 104 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.598Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty