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-604592026-04-14T05:00:04Zamanda—martinez1962-06-21--530-517-5038UNKNOWN700 Church St Apt 38OrlandoFL32888-8211N/AUNKNOWN
TPATPA-637762026-05-17T14:24:33Z Stephen—Robertson26-04-1974UNKNOWNnullUNKNOWN—4568 CANYON RDFRESNOCA93735—-
TPATPA-556712026-08-18T02:35:50Z·LOGAN—CARPENTER··10/8/1977·null•••-••-4707+1 466 607 9054·UNKNOWN—null——GRP-0457—
TPATPA-621712026-07-15T17:36:58Zeric—·simmons2006-06-11—N/ANULL—8187 Mountain View DrFresnoCA93743—UNKNOWN
TPATPA-551122026-04-12T15:11:24ZJoseph—Robertson1987-04-11UHC-34162-05····N/A-··NULLNULL-—null—
TPATPA-591672026-06-21T10:24:07ZEVELYN—RIOSAug 16, 1993—•••-••-2995N/A—5133 Grand AvenueTucsonAZ85754UNKNOWN—
TPATPA-587822026-03-21T18:55:50ZAnthonyG·Hansen1963-05-16UHC-17160-06——NULL8380 ELM STREET·OrlandoFL32834—-
TPATPA-553482026-04-17T15:40:13Z ·EugeneBOrtiz1992-06-02UHC-22443-97•••-••-9905·+1 751 787 9983eugene.ortiz93@icloud.com8364 BroadwayTUCSONAZnullnull—
TPATPA-58429 2026-09-29T20:02:07ZWalter—Gilbert1963-05-27N/AUNKNOWNNULLUNKNOWN···2595 Maple Ave·ChandlerArizona85266—null
TPATPA-595332026-09-09T09:29:39ZTurner, Aisha········1998-07-10UNKNOWNnullnull—764 Forest AvenueAustinTX78764-null
TPATPA-613952026-01-27T05:39:26Z·JSSE—FIELDS1948-08-24NULL-NULL··2531 Mountain View DriveDenverCO80255null-
TPATPA-567512026-07-04T14:25:27Z BOBBY—GILBERT02/07/1980——N/A—N/A—UNKNOWNN/A··GRP-2636··
TPA TPA-539032026-02-01T05:36:25ZBrandonGJacobs1955-08-05UHC-10592-72•••-••-7332—brandon.jacobs@yahoo.comN/AN/A····UNKNOWN—-
TPATPA-547042026-09-23T06:56:06ZAmnada—Washington··1958-08-18—-7138030824—1751 Lake View Road··JacksonvilleFL32236··GRP-3286·NULL
TPATPA-545782026-03-02T13:55:44Zpatrick—sanchezApr 9, 1955—•••-••-5148····PATRICK.SANCHEZ@PROTON.ME8588 CHURCH STREETDallas·TX75215NULLMEDICARE-ADV-A
TPATPA-503382026-08-04T22:20:25ZPena, Margaret——1985-10-06-··NULL—978 MARKET STEden PrairieMN55319-null
TPATPA-630072026-09-15T23:19:14ZRussell, Dylan——1950-01-20NULL•••-••-2934null—875 Camelback RdFRESNOCA93795GRP-6337null
TPATPA-642802026-07-16T10:53:36Zlinda—payne12/6/1993UNKNOWN•••-••-9261—-··NULLUNKNOWNN/A-—-
TPATPA-503032026-04-08T22:41:55ZASHLEY—JOONESSep 11, 1969UHC-95558-79nullNULL··ASHLEY.JONES@GMAIL.COM1608 Desert Sky BoulevardTucsonaz85744-OPTIONS-PPO
TPATPA-585722026-09-06T05:02:07ZKELLY····HERNANDEZ1968-02-05NULL•••-••-3103364-445-4295-5878 Lake View RoadAtlanta··GA30356-9103GRP-5841UNKNOWN
TPATPA-59731 2026-07-30T11:09:22ZDavis, AmyL······Nov 28, 1987—•••-••-1320+1 665 872 1312NULL4547 Indian School RdPhoenixAZ85062N/Achoice-plus-ppo··
TPATPA-559452026-05-11T08:21:08ZMatthews, SaraN—1971-11-11——2528452367N/A6688 HIGHLAND AVENUENashvilleTN37275GRP-0893····
TPATPA-591992026-06-06T15:58:09Z·Nancy—Freeeman1991-07-03NULL-NULLnull-null--GRP-4610SELECT-EPO
TPATPA-615042026-09-23T21:41:31ZSARA—WILLIS11/05/52NULLN/A3104239968N/A3782 Valley View DrScottsdaleArizona85245-0283—NULL
TPATPA-520352026-03-25T21:09:25ZOLIVIA—PADILLA1998-05-26NULLN/A644-401-4155olivia.padilla@icloud.com9203 River RoadSan DiegoCA92139GRP-1191UNKNOWN
TPATPA-535802026-02-14T06:49:50Z·ChristianNTaylor1940-05-07—N/A—null5386 VALLEY VIEW DR·DallasTX75264UNKNOWNN/A··
TPATPA-571222026-01-08T15:08:01ZJACK··DHALL1999-09-13—-8925450884UNKNOWN5459 CANYON ROADSAN DIEGOca92191·-null
TPATPA-633142026-09-11T15:03:34ZLAWRENCE—BELL11/14/2006N/A•••-••-72042367741561··N/A3731 Central Ave·LOS ANGELESCA90065—UNKNOWN
TPATPA-633592026-03-24T07:11:16Z·Kyle—Sanders1963-06-19—•••-••-9647UNKNOWNnull4801 Washington StLos AngelesCA90094—SELECT-EPO
TPATPA-615442026-03-22T23:21:42ZRuth—Mendoza1961-05-11UHC-36365-03•••-••-34776194249710··-··N/Anull—GRP-6420SELECT-EPO
TPATPA-543072026-09-12T06:44:51ZGarza, Santiago——07/26/1994———····——-··NULL—N/A
TPATPA-636472026-06-24T23:30:26Zpriya—dunn·05-05-1959-UNKNOWN—N/A7821 OAK ST Apt 20Las VegasNV89148········
TPATPA-565822026-06-30T03:36:19ZANDREWS.BANKS07/22/1956—UNKNOWN·NULL—4132 Willow CtEden Prairie··MN55335—null
TPATPA-510882026-01-14T04:04:28ZBRYAN—CARPENTER10-01-1953——nullNULL3793 Harbor BoulevardLos Angeles···California90075N/AMEDICARE-ADV-B
TPATPA-544192026-04-16T01:46:29ZAISHA—CHEN10/3/1944N/A——-5831 Sage CtSacramento··CA95808N/A-
TPA TPA-514522026-08-13T19:31:45ZANA—·SANTOS1940-10-17UHC-93279-73•••-••-0070—NULL7064 Indian School Rd #292TucsonAZ85779GRP-7915OPTIONS-PPO
TPATPA-569402026-07-09T11:28:58ZPETER—EVANS1964-08-09null··null15842754486UNKNOWN··105 MOUNTAIN VIEW DRIVEPlanoTX75083—UNKNOWN
TPATPA-501292026-07-30T14:13:06ZMartha—Peters4/12/1975··—·364-673-6906martha.peters@proton.me9204 UNION STREETLas VegasNV89157——
TPATPA-614982026-09-02T18:19:25ZValentina—Welch1977-01-08—UNKNOWN——N/A—UNKNOWN-NULLMEDICARE-ADV-B
TPATPA-545522026-06-09T17:05:40Zkelly—miller1977-09-23—-774-876-7147N/A1236 Sage CourtGilbertAZ85263-3630—NULL
TPATPA-605132026-04-19T06:25:38Zdaniel—stephens1993-08-03—•••-••-9335(598) 503-2190-4109 Willow CtTempeArizona85244UNKNOWN-
TPATPA-571202026-05-19T02:11:46ZCharlotte—Green1946-08-06-null950-221-0414NULL··4490 Valley View DriveMinneapolisMN55449N/Anull··
TPATPA-635312026-02-21T23:36:54Zbeverly—davis·1975-07-12NULL•••-••-1560UNKNOWNNULL—N/AnullN/AN/A—
TPATPA-572802026-08-20T14:44:24ZJacob—Hal2001-06-06N/A•••-••-0347UNKNOWN····2618 Ridge RoadPhoenixaz85094—NAVIGATE-HMO
TPATPA-509382026-04-11T16:28:41ZKimberlyQ.Morris1946-08-16—-—nullUNKNOWN——N/AUNKNOWN—
TPATPA-538042026-05-18T03:33:55ZElijah—Vega1948-05-08UHC-68333-42——N/AnullNULL—-GRP-3794-
TPA TPA-590192026-05-06T03:04:23Z CharlotteYMurphy1944-06-28····—-charlotte.murphy@proton.me5478 Main StreetPhoenixAZ85035—MEDICARE-ADV-B
TPATPA-560162026-08-14T10:47:36ZKELLY—PEREZAug 15, 1990UNKNOWN•••-••-5904(227) 707-8162NULL1759 Mountain View DrLos AngelesCA90000-7325UNKNOWN—
TPATPA-592452026-06-15T17:15:28ZMariXRivera1989-09-25UNKNOWN--null6492 RIVER ROAD #541Glendaleaz85353GRP-7043select-epo
TPATPA-640242026-06-04T22:44:00ZMICHELLE—LE11/05/78NULL—8044317304-UNKNOWN——nullGRP-3458NULL
14,474 rows, page 217 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:56.161Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty