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-536562026-01-05T21:08:43ZTHOMAS—RICHARDSON1/21/1996N/A—·nullthomas.richardson@aol.com8105 Bayshore DriveTucsonAZ85775GRP-5783null
TPATPA-586962026-01-23T13:15:01ZJESSE—PENA07/12/1982null•••-••-2620(701) 975-0620—9522 Oak StreetLas Vegasnv89171N/ASELECT-EPO··
TPATPA-514922026-08-29T17:52:54Zanthony—salazar··2004-01-25—NULL—null3940 Hillcrest RoadPLANOTX75007GRP-6882··UNKNOWN
TPATPA-587912026-07-28T15:21:47ZRaymond—Ortiz·04-04-1965——····—9314 Hillcrest RdFresno··ca93776UNKNOWN-
TPATPA-505662026-09-17T19:48:51ZMei—Long9147-08-24N/A•••-••-9495nullmei.long@hotmail.com·3847 Forest Avenue·DallasTX75236·nullSELECT-EPO
TPATPA-520462026-06-15T21:31:07ZJulia—Pena1937-11-13——5027762N/A8514 Indian School RdPhoenix··AZ85074··—null
TPATPA-560802026-08-30T05:32:57ZKATHRYN Y.··—HART1950-12-28-•••-••-0556(706) 600-7087—nullnullNULLnullGRP-3678MEDICARE-ADV-A
TPATPA-565702026-06-01T03:44:03ZGloria··NguyenDec 13, 1948—•••-••-2692(578) 481-2748gloria.nguyen@aol.com242 Desert Sky BoulevardDenverCO80223GRP-2108UNKNOWN
TPA TPA-554992026-10-11T05:37:03ZKimberly—Santiago1984-11-27UHC-16774-11—7462057795NULL··3655 Mountain View DrDenver··Colorado80211-—
TPATPA-562512026-10-02T21:07:10ZhenryPfosterFeb 24, 1990N/A—2919267600-—NULL—NULLGRP-8069null
TPATPA-63930 2026-02-07T02:23:26ZStone, MasonQ—1983-10-10··————5591 PARK PLGlendale··AZ85392——
TPATPA-63823 2026-06-29T00:40:05Z·MEGEN—CARLSON19870917-•••-••-3330+1 804 944 2516—6904 Elm StPlanoTX75072N/A··—
TPATPA-566882026-02-23T16:14:54ZKyle—Harrison1967-05-15··NULLnullUNKNOWN··UNKNOWN2106 Mountain View DriveGilbertAZ85217—UNKNOWN
TPATPA-616882026-01-03T15:50:42Zevelyn—palmer4/3/1997nullNULL6092390924NULL8011 CHURCH ST Apt 11TucsonArizona85758·GRP-8990N/A
TPATPA-639702026-01-12T14:35:26ZTerry—Hansen91951011null—8696771414——··——-·N/A
TPATPA-587772026-07-11T12:41:22Zjacob—riosSep 28, 2001NULL•••-••-2557—JACOB.RIOS@PROTON.ME——UNKNOWN—GRP-4826—
TPATPA-602892026-06-20T16:10:19ZCruz, Jacob——·06/27/64N/A-(973) 299-1035NULL9286 DESERT SKY BLVDDenverCO····-CORE-HMO
TPATPA-614642026-05-27T10:10:50ZAhmed—Grza19400410UHC-76720-29NULL649-231-6062N/A4490 Elm StScottsdaleAZ-NULL·options-ppo
TPATPA-588022026-03-12T14:38:53ZJessica—Jimenez1945-03-14—•••-••-8693nullUNKNOWN2654 Lake View RdPlanoTX75003nullN/A
TPATPA-52279 2026-07-13T19:23:31Zjoseph····kennedy1956-12-21null•••-••-0862-NULL2817 Harbor BoulevardTucsonArizona85763—·N/A
TPATPA-558182026-05-15T21:14:26ZFrances··—Fields19521104UNKNOWNNULL4146613290frances.fields@aol.com565 MAIN STREET··TempeArizona85239GRP-6416MEDICARE-ADV-A
TPATPA-541922026-08-11T14:01:56ZEdward—Matthews1984-03-21null———3053 BASELINE ROAD··OrlandoFL32839—N/A
TPATPA-631252026-10-07T16:02:19ZDenny—Burton2000-73-10··UHC-59639-21•••-••-7183·861-599-3246·DENNIS.BURTON@ICLOUD.COM9222 MAPLE AVENUEDenverCO80209GRP-1964NAVIGATE-HMO
TPATPA-615842026-04-25T00:31:23ZHEATHER—RIOS1690-07-24UHC-67463-23NULL6472954779HEATHER.RIOS@YAHOO.COM6475 Desert Sky Boulevard #668SacramentoCA95827GRP-0771UNKNOWN
TPATPA-603662026-04-03T13:14:18ZSEANN.DAVIS01-06-1949·UHC-58231-30N/A··7534079181null1123 INDIAN SCHOOL RDDallastx75292—N/A
TPATPA-627152026-02-21T23:06:43ZJacqueline—Schultz1979-10-11N/AN/A-—2368 River RoadColumbusOH43256—null
TPATPA-599162026-04-08T05:17:24Zptrick—reyes1964-02-17UHC-07772-72---6425 BroadwayAustinTX78733—····
TPATPA-643112026-07-31T02:40:02ZCooper, Christina——1958-05-08——-—6821 Sage CtMiamiFL33179-3700——
TPATPA-606372026-07-05T20:59:32ZFatima··Fisher··1971-07-19—·-848-324-2784—740 Cedar LaneTucsonAZ85783UNKNOWN··—
TPATPA-587622026-09-27T20:57:53ZJulie—Maldonado··2030-02-09UHC-32095-94-3676613460null2499 Cedar Lane #572TampaFL33655·GRP-4452CORE-HMO
TPATPA-506752026-04-05T13:49:56ZSamuel—Mejia7/13/2003N/A•••-••-7332nullUNKNOWNN/AUNKNOWNN/A—GRP-8910SELECT-EPO
TPATPA-559272026-09-26T07:08:54ZMELISSA—PALMER1959-06-18UNKNOWN•••-••-3317——1888 CEDAR LANE·DenverCO80267-8040GRP-1418—
TPATPA-588972026-08-20T14:29:53Z MATEOF.ALVAREZJun 14, 1994—UNKNOWNN/Amateo.alvarez89@outlook.com8301 Lake View RoadDenverCO80212—UNKNOWN
TPATPA-568062026-01-07T04:34:24ZArjun—Martinez1938-06-17—N/AN/A-210 UNION STMinneapolisMN·55436-··CORE-HMO
TPATPA-638392026-03-13T01:40:23ZTYLER—ORTIZ1976-09-09-··•••-••-8748—TYLER.ORTIZ1@GMAIL.COM9412 HIGHLAND AVENUE Apt 29SAN ANTONIOtx··78265—UNKNOWN
TPATPA-577512026-06-18T14:16:09Z HART—SANDRA1950-09-18UHC-51984-99NULLNULLsandra.hart@gmail.comUNKNOWNUNKNOWNnull-N/Anull··
TPATPA-612512026-03-25T19:33:03ZHowll, Joe——1964-08-20UHC-75983-70•••-••-5792-—nullnull·N/A—NULLNAVIGATE-HMO
TPA TPA-632222026-09-14T10:22:28Zjerry—dean1977-11-14UNKNOWNUNKNOWN-NULL5719 Lincoln WayCharlotteNC28268—NULL··
TPATPA-514692026-02-14T23:48:35ZDeba, Green——2003-11-26—N/A—-————null-
TPATPA-517132026-02-17T22:49:05ZDeb—Olson02-09-1938N/A—12346743406··—-N/A··nullOPTIONS-PPO
TPATPA-640552026-02-01T04:15:13ZMason, Donna——20020414N/A····19678261186-1781 Forest AveSan AntonioTX78245GRP-9868null
TPATPA-643532026-08-29T04:06:45ZAndrwePBarnes19711207·N/A•••-••-6119UNKNOWNNULL-——UNKNOWN-MEDICARE-ADV-A
TPATPA-589872026-05-13T19:40:13ZCook, Noah——04/09/1982—•••-••-00826506429202-496 MARKET STREET··TempeAZ85263N/ANULL
TPATPA-504112026-08-05T02:16:17ZEmilyOHudson1963-09-10NULL·NULLNULLnull7372 Grand AvenueFresnoCAUNKNOWN-—
TPA TPA-635492026-07-29T20:01:16ZKENNTEH—LONG1959-02-25UNKNOWN—·null—8425 River RdPlanoTX75009—UNKNOWN
TPATPA-575622026-06-08T09:31:00Zdorothy—sanders1947-07-13nullNULL(878) 431-9401—5954 Bayshore DrOrlandoFLNULLN/AN/A
TPATPA-569552026-01-16T17:36:44ZAmber—Jones1998-10-18UHC-67006-65null—amber.jones49@aol.com8598 Sage CourtNashvilletn37223null—
TPATPA-506392026-04-24T15:44:05ZWang, DylanS—3/6/1941UNKNOWNUNKNOWNnullUNKNOWN7317 Sage CourtMesaAZ85221——
TPATPA-637352026-04-14T08:15:51ZDianaV··Dixon1999-02-21nullN/ANULL-6630 WASHINGTON STREETSan AntonioTX78246GRP-7018null
TPATPA-576472026-05-17T23:48:25Z·Kimberly—Gardner1968-11-23N/A····504.208.2557N/A1126 Washington StColumbusOH43247GRP-8956MEDICARE-ADV-B
14,474 rows, page 163 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:52.203Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty