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-640442026-07-15T00:17:15ZRyanOAguilar1966-07-24—---1354 Baseline Road·Las VegasNV89118UNKNOWNSELECT-EPO
TPATPA-558952026-03-26T17:03:47ZLauernH.Shaw19970815·NULL—(601) 416-9084····2823 SPRING STREETLos AngelesCA90095NULL··
TPATPA-620312026-02-08T02:43:24ZLe, Danielle——1938-06-03——324-595-8047-4074 MAIN STTEMPEAZ85299N/AUNKNOWN··
TPATPA-583072026-09-22T21:30:36ZGRY—VAGA1996-03-01—•••-••-0253(955) 363-1305UNKNOWNN/A··UNKNOWN—-GRP-9858CORE-HMO
TPATPA-568822026-01-12T16:07:21ZJENNIFER—·CARLSON1959-12-01··N/A897-989-8499NULL-—null··UNKNOWNCORE-HMO
TPATPA-511992026-08-17T14:09:20ZLopez, Elijah——1963-03-01-—-null9012 Lake View RdColumbusOH43245··—N/A
TPATPA-577482026-09-22T10:32:26ZDonald—Butler1947-12-10UNKNOWN··•••-••-5416NULL—172 Baseline RdHoustonTX77089··——
TPATPA-605962026-02-04T04:08:20Z·NICHOLAS—ROBERTSON1948-05-21NULL•••-••-0263484.763.9215··nicholas.robertson80@proton.me8153 JEFFERSON AVENUEGlendaleAZ85311—NULL
TPATPA-55947 2026-10-06T04:07:07ZNoah—Padilla··1984-09-20NULL·NULL(412) 883-1061NULL5201 Highland AveAustinTX78774GRP-0456N/A
TPATPA-502242026-05-25T19:48:31ZRodriguez, Evelyn——1946-12-04null—N/A-3046 SPRING STREETNASHVILLETennessee37258NULLUNKNOWN
TPATPA-639022026-10-06T13:43:50ZJoan—Jimenez1944-02-22··UNKNOWN--—3952 VALLEY VIEW DRSan Diego·CA92160N/ASELECT-EPO
TPATPA-525102026-02-22T10:28:48ZLYNCH—JERRY··1978-12-27—NULLnull·jerry.lynch6@hotmail.com5218 BroadwayMiamifl33112—SELECT-EPO
TPATPA-545412026-07-25T01:57:23ZElijah··—Washington··9/7/1979UHC-16414-38··nullNULL959 Mesa DrAustinTX78748··GRP-1253OPTIONS-PPO
TPATPA-582162026-03-11T02:20:27Zcarl—lucas1946-09-27·null•••-••-91258847640819UNKNOWN8483 Sage CourtAustinTX78748nullcore-hmo
TPATPA-544502026-04-24T06:33:14Zhoffman J··patrick1960-11-21null—-NULLNULLN/AUNKNOWNnullGRP-4261··—
TPATPA-627492026-04-20T09:48:26ZJeremy—·Maldonado19661002—N/AUNKNOWN—629 Oak StLOS ANGELESCA90026GRP-8747··—
TPATPA-550162026-05-17T08:53:26ZMarianaSHartOct 9, 1950N/A——-4835 Pine DriveScottsdaleazNULLNULLNULL
TPATPA-634242026-03-27T05:34:12ZVincent—Meyer1984-12-22-NULL3678386470null237 SAGE COURTPlanoTX·75014GRP-0104NAVIGATE-HMO
TPATPA-619532026-02-01T06:26:08ZBrittany—Watson04/25/71NULLUNKNOWN—-3073 Market St Apt 7SacramentoCA95874NULLUNKNOWN
TPATPA-565962026-07-10T23:53:17ZCHERYL—CASTRO1905-02-04-•••-••-3039NULL-570 Broadway··PhoenixAZ85002··nullnull
TPATPA-603352026-08-15T08:41:50ZRLPH—BAILEY19680110UNKNOWN•••-••-97653035306—9827 Elm StreetHoustontx·77097-5639—NULL
TPATPA-544822026-05-03T14:21:02ZEDWARD··ROBINSON··06/06/99null•••-••-9310(215) 881-6779NULL3550 Maple AveMiamiFL33136UNKNOWN—
TPATPA-542242026-02-14T04:23:30ZGeorge····Baker1944-02-06—··NULL—4291 Hillcrest Rd #202San DiegoCA·92122GRP-7267-
TPATPA-588002026-04-15T05:15:44ZDouglas—Luna11/25/1990UHC-38556-96•••-••-9924—·douglas.luna@outlook.com8652 Willow Court #507AtlantaGA30367··GRP-9804MEDICARE-ADV-B
TPATPA-624712026-06-09T10:21:21ZKenneth—Medina1967-10-03UHC-58954-97··•••-••-0037825-642-2353··kenneth.medina@yahoo.com··817 HILLCREST RDHoustonTX77090-1814··N/A-
TPATPA-610942026-09-09T03:09:44ZELIZABETHWRICHARDSON1994-01-12—NULLNULLUNKNOWN7983 Park PlSacramentoCA·95858UNKNOWNNULL
TPATPA-559812026-08-24T12:11:10ZKevin—Price1988-06-23—·NULL(572) 775-8697null8595 BROADWAYAustinTX78786N/A—
TPATPA-55849 2026-09-28T11:22:05ZBRIAN··—FORD··1998-09-28-•••-••-8679····UNKNOWN3178 Harbor BoulevardHOUSTONTexas77071GRP-5554null
TPATPA-551172026-06-18T18:55:29ZSamuel—Williamson1960-08-28—•••-••-1982UNKNOWN—1245 Sage Court·OrlandoFlorida32837GRP-9790MEDICARE-ADV-A
TPATPA-555082026-10-04T11:13:13ZemilyUford19440525NULL—(779) 950-6879emily.ford32@hotmail.com8358 Valley View DriveMesaAZ85204—NAVIGATE-HMO··
TPA TPA-55048 2026-05-23T03:45:51ZCARL—MONTGOMERY1963-08-11UHC-57349-54··N/Anullnull1278 Lake View RoadSeattleWA-—UNKNOWN
TPATPA-561502026-03-30T21:10:52ZBruce—Banks1983-06-21UNKNOWNUNKNOWN—UNKNOWN5040 Harbor BlvdAtlantaGAnullUNKNOWNMEDICARE-ADV-B
TPATPA-523002026-03-22T09:32:19ZKEITH—HERNANDEZ11/21/98··—N/AN/A1394 Apache BoulevardSCOTTSDALEAZ··85239—UNKNOWN
TPATPA-543242026-08-22T18:14:19ZWilliam·····Banks1961-03-01UNKNOWN·UNKNOWN····NULL6816 SPRING STREETLOS ANGELESCA90031—CORE-HMO
TPATPA-558942026-02-04T09:55:55ZSamuel—OBrien20001008-—600.370.5917UNKNOWN8778 Oak StTampaFL···33693GRP-1802··-
TPATPA-518452026-10-01T19:05:17ZDonna—Williams1984-06-25—•••-••-5858425-231-4592donna.williams39@aol.com5938 RIDGE ROADGlendaleAZ85390—MEDICARE-ADV-B
TPATPA-549992026-09-26T03:33:09ZBRADLEY—MEYER1978-02-03NULL—805-783-9731··bradley.meyer@yahoo.com2160 CENTRAL AVEJacksonvillefl32236·NULLOPTIONS-PPO··
TPATPA-511202026-06-19T12:52:56ZMELISSA—WELCH1987-07-15N/A•••-••-80979893419033··———————
TPATPA-602912026-05-15T16:06:24ZEugeneC.Padilla2007-06-27UNKNOWNUNKNOWN(537) 863-3073—1804 RIDGE ROADChandler·AZ85299GRP-1341UNKNOWN
TPATPA-506992026-01-21T21:28:05ZMelissa—Willis1939-06-04UHC-08965-17N/A···+1 496 958 1419—·8088 LINCOLN WAYChandleraz——CORE-HMO
TPATPA-620672026-03-04T05:20:31ZMontgomery, Mark····—05/01/1969····•••-••-4584362-427-8460—5341 Canyon RdMiamiFL33105NULLNULL
TPATPA-523702026-09-11T23:04:33Zrebecca··Z.austin03/26/1983—UNKNOWN-··rebecca.austin@icloud.com2519 Spring StAtlantaGA30354—SELECT-EPO
TPATPA-559142026-03-15T16:17:34ZSteve—Dixon1996-11-03·N/AUNKNOWNnullnull8339 Meadow LaneDallasTX75222GRP-9512UNKNOWN
TPATPA-543972026-09-01T01:26:43ZJoshua—Schmidt1973-02-14—•••-••-2314667-431-0594NULLNULL—·NULLN/AGRP-4045—
TPATPA-612922026-08-17T18:58:06ZBARBARA··JOHNSTON1990-12-20NULL··•••-••-2538257.393.1456-·6135 RIDGE ROAD #327GlendaleAZ85389-8277——
TPATPA-555202026-09-06T20:54:44ZJACQUELINE—WEST1959-07-12UHC-81934-17UNKNOWNN/Ajacqueline.west50@icloud.comUNKNOWN—-UNKNOWN—-
TPATPA-588432026-07-30T17:31:39Z·ISABELLA····WALLACE1955-09-12—•••-••-0383475-475-1113—6211 Jefferson AvenueMiamiFL33141GRP-5362OPTIONS-PPO
TPATPA-602822026-06-08T16:04:21ZEmma—Sullivan1967-11-11UNKNOWNN/A·744-613-1602—6436 CEDAR LANELAS VEGAS··Nevada—GRP-3875NULL
TPATPA-53680 2026-08-12T08:57:39ZArjun—Chavez1958-07-21N/AN/AN/A—3309 Elm StCharlotteNC28276nullMEDICARE-ADV-B
TPATPA-60018 2026-09-10T01:27:07ZKyle—Butler1991-11-28UNKNOWNnullNULL-1483 CANYON RDCharlotteNC28268—UNKNOWN
14,474 rows, page 239 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:00.212Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty