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-643342026-07-29T00:06:25ZISABELLA—GORDON2007-08-42-———752 Mountain View DrLos AngelesCA90062N/AMEDICARE-ADV-B
TPATPA-546462026-09-01T21:22:29ZROEGRXJOHNSTON3/6/1996UNKNOWNUNKNOWNN/A·NULL1206 Desert Sky Blvd #822MiamiFL33120NULLoptions-ppo
TPATPA-503212026-03-28T18:31:16ZMatthew—Johnston07-08-1986NULL·null—-··5468 Market StreetCOLUMBUS··OH43268—UNKNOWN
TPATPA-509582026-03-02T21:55:25ZKimberly—West1987-09-24NULLNULL—-1188 PINE DRIVELos AngelesCA··90005GRP-3035—
TPA TPA-576962026-02-09T00:03:36ZCAMILA D.—DIXON1963-06-04-•••-••-1363UNKNOWN-5403 MESA DRIVEHouston·TX77093-—
TPATPA-506452026-07-26T13:38:29ZRobert—Alexander1959-03-08-—null-814 CAMELBACK RDOrlandoFL32866-1485N/A····
TPATPA-574722026-10-16T19:29:23ZRALPHQ··MONTGOMERY1992-12-15UHC-35654-55null—RALPH.MONTGOMERY65@ICLOUD.COM4474 Sage CourtMesaAZ85254UNKNOWNN/A
TPATPA-560832026-09-13T07:36:12ZCruz, Cheryl——May 1, 1952NULLN/A-nullnullN/A—-UNKNOWNnull
TPATPA-541462026-09-01T05:17:54ZMaria—Park04/01/1979—-UNKNOWN—1510 Grand AvePhoenixAZ85034GRP-3895SELECT-EPO
TPATPA-521302026-08-24T00:20:45Zalan—castillo1954-06-12UNKNOWN•••-••-0426(244) 718-8600—36 Hillcrest RoadMesaAZNULLGRP-3555null
TPATPA-566822026-06-02T03:18:40ZJoshua, Gordon——25-12-1958N/A•••-••-3503null—4104 Union StreetJacksonvilleFL32286UNKNOWN—
TPATPA-547322026-08-25T05:48:14ZStone, Julie····—1/11/1998—•••-••-74386165079321UNKNOWN1065 Meadow LnPhoenixAZ85080nullnull
TPATPA-599362026-06-20T06:22:35ZTHOMAS—DAY1944-02-21··N/ANULL——1025 MESA DRIVEMiamiFlorida33171UNKNOWNUNKNOWN··
TPATPA-544732026-03-17T08:59:15ZJenniferJNunez1981-07-17—UNKNOWN——2821 Grand AveEden PrairieMN55347··—OPTIONS-PPO
TPATPA-512982026-09-03T04:14:55Zbrittany—kim12/16/58—•••-••-2714·(351) 470-6707—-—N/ANULL··N/A
TPATPA-558242026-01-03T14:41:11ZLynch, DavidP.—1959-02-27·-NULL902.990.3252david.lynch80@yahoo.com6485 Harbor BoulevardDallasTX75292N/A-
TPATPA-609982026-10-03T18:16:05ZKevin—Wallace1941-08-01null—212-878-0265—1250 DESERT SKY BLVDHoustonTX77022nullSELECT-EPO
TPATPA-611972026-05-01T01:22:25Z·EDWARDS—AARON1998-02-07UHC-34450-15··—null6545 Pine DriveNashvilleTN37254GRP-0914NULL
TPATPA-544392026-07-08T14:32:23ZTom—Reid1998-06-09UHC-15942-46UNKNOWNUNKNOWN—5700 BROADWAYJacksonvilleFL32274···-
TPATPA-509272026-08-17T18:07:47ZBRADLEY—ANDERSON19760724N/Anull4063021271N/A5819 FOREST AVELAS VEGASNV89120—··
TPATPA-563102026-07-16T05:10:57ZSophiaGVargsJun 5, 1962-•••-••-8964—NULL8577 APACHE BOULEVARDHoustonTX77012NULLnull
TPA TPA-609432026-03-03T20:55:37ZElizabethO.Nunez2008-08-01UNKNOWN··NULL-··NULL5625 Washington StreetSacramentoCA95832UNKNOWNnull
TPATPA-625372026-07-26T09:10:06ZDENNIS—KELLEY1978-04-18null··N/A7932220150NULL——····—GRP-9448-
TPATPA-526292026-08-28T12:15:02ZAlice, Carroll—··1/23/1942—•••-••-7724UNKNOWNUNKNOWN7653 Bayshore DrScottsdaleAZ85205NULL-
TPATPA-573342026-06-27T07:11:42ZBenjaminYYang10/04/44UHC-43975-07··—nullUNKNOWN5389 Desert Sky BlvdMesaAZ·85265GRP-7756····
TPATPA-553182026-06-23T11:19:09ZElizabethHMunoz1946-03-11N/AN/A··-elizabeth.munoz@outlook.com4796 SPRING STColumbusOH43205-4087N/A—
TPATPA-613762026-08-22T15:39:27ZEric—Sanders08/27/59nullnull···(954) 557-9690-2321 GRAND AVENUEOrlandoFL32817GRP-5655CORE-HMO
TPATPA-526312026-07-18T03:34:19ZSTEVE—ORTEGA1941-03-27N/A——steven.ortega83@yahoo.com1456 Jefferson Ave··TempeArizona85239N/AUNKNOWN
TPA TPA-553432026-01-25T16:02:20Zruth—rose2006-07-19uhc-77128-20•••-••-8862670-856-1056-4493 Main StMINNEAPOLISMN55492-CORE-HMO
TPATPA-575592026-08-30T13:20:13Z DanielleQPeterson1949-01-25—UNKNOWN258-484-6687—1519 Jefferson AveMESAAZ·85265NULLnavigate-hmo
TPATPA-605312026-07-28T21:56:04ZKevn—McDonald1940-02-20···NULL·UNKNOWNN/A··—2674 Highland AvenueMinneapolisMN55446·UNKNOWNNAVIGATE-HMO
TPATPA-576922026-09-09T15:16:50ZAhmed—·Hudosn19630404UHC8940289··UNKNOWN····—UNKNOWNN/A-N/A—SELECT-EPO
TPATPA-582912026-05-31T16:42:17ZALIKE—HERRERAJun 25, 1980—N/A—N/A4802 Camelback RoadTucsonAZ85783··GRP-9953MEDICARE-ADV-B
TPATPA-574972026-06-12T07:05:41ZRuthP.Ross19730603UNKNOWNUNKNOWN——4968 Lincoln WayChandler··AZ85285N/A—
TPATPA-610582026-10-17T15:16:44ZAshley—Oliver1973-04-06N/A—N/A—229 BAYSHORE DRIVE··GilbertAZ·85201GRP-8599—
TPATPA-534802026-07-14T01:38:23ZScott····Santos1961-03-20-··—NULL3753 Pine DrORLANDOfl32864GRP-7926—
TPATPA-530102026-06-24T04:29:46ZRoger—Fuller07/09/1975-NULLNULL—1014 MOUNTAIN VIEW DRCharlotteNC28231GRP-6893null
TPATPA-525192026-06-19T13:36:37ZWelch, Abigali——1998-11-24·UHC-47178-19—N/AN/A1621 Union StreetNashville·TN37207-2443nullNULL
TPATPA-619412026-07-29T10:44:03ZChristina—Lynch1942-03-08N/A-542.448.1134null8964 Maple AvenueCharlotteNC·28230GRP-8236OPTIONS-PPO
TPATPA-564252026-08-22T14:30:58ZAMY—·ROMERO19530425··—UNKNOWN730-719-8142amy.romero@hotmail.com5444 UNION STREET Apt 7PhoenixAZ85061GRP-3516OPTIONS-PPO
TPATPA-539442026-02-01T22:59:32ZFRANCES—SCHMIDT1966-09-23-—nullNULL1285 Bayshore DriveMiamiFL33113GRP-7363N/A
TPATPA-565642026-08-11T03:33:38ZJoseph··EChavez1996-10-02UNKNOWN•••-••-6446-JOSEPH.CHAVEZ@PROTON.ME5116 MAIN STTampaFL33670-6514GRP-0185-
TPATPA-538652026-07-22T22:05:44ZTheresa—Wheeller1953-07-08—•••-••-9790(328) 354-2633theresa.wheeler91@yahoo.com8531 Camelback RdSan DiegoCA92187N/A·NULL
TPATPA-585932026-08-18T07:22:24ZJENNIFER····FISHERNov 23, 1993—-—JENNIFER.FISHER@AOL.COM3366 Palm DriveJacksonvillefl·32292-5684UNKNOWNOPTIONS-PPO
TPATPA-558762026-01-17T07:31:34ZLOGANY·GONZALES1986-07-13-•••-••-6064-null--—N/AGRP-9814CORE-HMO··
TPATPA-552632026-02-12T15:51:30ZELIJAHT.WOOD1989-07-06NULL•••-••-8404--2755 Sage CtGlendale·AZ85330GRP-3674—
TPA TPA-526932026-01-02T21:00:17ZSara—Burotn1938-03-28N/A-NULLUNKNOWN2589 Canyon RoadAtlantaGA30328GRP-0305CHOICE-PLUS-PPO
TPATPA-533622026-03-02T09:44:17ZMichelle··—Kelley1996-03-02··null··•••-••-5399(695) 492-0437michelle.kelley8@icloud.com3767 Forest AveTucsonAZ85730NULLNULL
TPATPA-635722026-10-18T12:26:20Z Logan—Carr1978-06-08—•••-••-8420nullN/A5888 Valley View DrATLANTAGA·30393-—
TPATPA-614592026-03-10T07:30:21ZNATHAN—TURNER1976-03-05-•••-••-2686nullUNKNOWNUNKNOWN-··—N/ANULL-
14,474 rows, page 278 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:43:03.725Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty