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-628022026-06-17T05:54:13ZKnight, MeganZ.—1968-04-21UNKNOWN—-N/A··784 Palm Dr··FresnoCA93721null—
TPATPA-596262026-02-01T00:55:41ZBetty—Griffin1955-04-26—•••-••-0694N/A—8221 Bayshore DriveSacramento·California95861·GRP-7031N/A
TPATPA-610742026-05-18T02:49:55ZMarcusIWallace02/11/1954NULL•••-••-7655NULL··5894 Bayshore DriveMiamiFL33162-CHOICE-PLUS-PPO
TPATPA-509832026-04-20T08:35:17ZNoah—CoxAug 3, 1963UHC-36111-12-—null—null····-—-··
TPATPA-576562026-09-25T11:03:00ZJUDY—PIERCE1991-02-15null•••-••-2968nullUNKNOWN2875 Maple AveSan AntonioTexas78239—OPTIONS-PPO
TPATPA-54802 2026-03-17T04:27:22ZAngela—Vargas1955-09-02UNKNOWNUNKNOWN777-697-2854··—3465 FOREST AVENUE Apt 13ScottsdaleAZ85266——
TPATPA-543812026-08-01T17:47:48ZDebra—Rojas1942-07-15—nullUNKNOWNNULL8068 Meadow LaneTAMPAFLnull··NULL··
TPATPA-542992026-01-17T01:58:05Z eric—fisher1942-10-10—NULL-null··799 Lake View RdCHANDLERAZ85244GRP-9945-
TPATPA-571412026-09-04T14:42:38ZEMILY—BROWN1943-12-10··UHC-53245-33—····—UNKNOWNNULLN/AUNKNOWNUNKNOWNN/A
TPATPA-567522026-01-09T00:54:38ZSophiaUWilliamson1944-60-09N/Anull——7952 Grand AvenuePlanotx75077-—
TPATPA-614902026-10-06T20:27:18ZVALENTINA—·MORRIS2000-09-25NULLN/A-UNKNOWN1890 Mesa Drive·AUSTINTX78794—MEDICARE-ADV-A
TPATPA-64466 2026-05-17T13:12:28ZValentinaHJacobs08/06/74—UNKNOWNUNKNOWNvalentina.jacobs22@proton.me7801 Spring St Apt 36Las VegasNV89133N/Anull
TPATPA-563542026-01-10T01:50:09ZAARON—HARRIS1968-02-17uhc-65969-21null-AARON.HARRIS42@YAHOO.COM422 Park PlScottsdaleAZ85211N/A—
TPA TPA-557272026-09-23T14:21:49ZHenryRCampbell2001-08-15——UNKNOWNN/A5329 Camelback RdColumbusOH43298··null
TPATPA-643672026-09-09T13:36:34Zmadison—·ramos2002-07-03-——N/A5080 Bayshore DrLas VegasNV—GRP-6097UNKNOWN
TPA TPA-57154 2026-07-01T16:53:12ZSteven—Guzman1960-11-07UHC-93254-06——N/A1507 CENTRAL AVENUEHoustonTX77023NULL—
TPATPA-637952026-09-13T14:48:09ZZACHARY·I.ARMSTRONG1978-01-27nullnull—-9095 PINE DR #396NashvilleTN37228-SELECT-EPO
TPATPA-621792026-07-08T07:06:56ZGibson, Joshua——1987-11-05—-N/Ajoshua.gibson87@proton.me··4752 Washington StTempeAZ85232GRP-0648MEDICARE-ADV-A
TPATPA-566682026-08-02T21:57:58ZMorgan, Samuel——3/20/2008null—959.712.4132NULLnullUNKNOWNN/A—··UNKNOWN
TPATPA-508262026-05-09T18:30:33ZTIMOTHY—JENSEN1976-10-04··—-5595814675NULL1467 Harbor BoulevardCharlotteNC28280N/A—
TPATPA-529282026-08-27T17:34:22ZTerrryFKelly9181-02-01nullN/A17678597949terry.kelly@icloud.com2627 Highland AvenuePhoenixAZ85077——
TPATPA-641792026-01-27T12:58:05ZSAMUEL—CARTER1993-11-27———UNKNOWN4509 SAGE COURTSEATTLE·WA98190——
TPATPA-532332026-04-02T19:33:32ZMarilyn—WestSep 17, 1965UHC-51771-85•••-••-4471—UNKNOWN5435 Apache BoulevardSAN DIEGOCA92156—null
TPATPA-529142026-05-11T17:19:56ZKELLY··ORTIZ1972-07-07····•••-••-0862null··UNKNOWN311 Ridge RdPlanoTexas·75065UNKNOWNNULL
TPATPA-539892026-05-28T16:25:36ZKEVIN Z····TAYLOR1978-04-04—-NULLnull9498 Main StEden PrairieMN55326GRP-1932····
TPATPA-627852026-01-23T22:53:34Zvictoria····castro2006-07-13N/ANULL+1 367 566 0290·N/A2915 Central AveTUCSONArizona85797——
TPATPA-530732026-01-12T17:03:22Zbruce—espinoza1965-04-10—•••-••-4560UNKNOWN·BRUCE.ESPINOZA@OUTLOOK.COM2762 PARK PLCharlotteNC28237··—NAVIGATE-HMO
TPATPA-568742026-09-10T19:40:48ZMaosn—Wong1991-01-03-··null—null4234 Willow CtLos AngelesCalifornia-··GRP-6880N/A
TPATPA-520982026-01-24T16:35:44ZLarry····Reid·1955-09-02UHC-25768-96-534-611-9525N/A6846 Main St·CharlotteNC28259-9544GRP-2284—
TPATPA-635712026-09-26T23:46:18ZJudy··—Knight12/28/1961UHC-66791-46-NULLN/A1771 Ridge Rd Apt 24ScottsdaleArizona85284—SELECT-EPO
TPATPA-617272026-06-19T14:28:42ZrayV··carpenter·1968-04-14N/AN/A19809553635··null64 PALM DRIVE #587TucsonAZ85720N/A-
TPATPA-630862026-09-08T20:34:03ZHelen—·Diaz2000-05-28UNKNOWN•••-••-34046268903419helen.diaz@icloud.com5905 CAMELBACK RD #739ColumbusOH43202—NULL
TPATPA-61821 2026-05-04T22:50:16ZRamos, Anthony——1938-10-17··—•••-••-0972——null—null—N/AOPTIONS-PPO
TPA TPA-623052026-05-17T05:44:31ZAmandaKFord5/22/1946··null··(667) 810-5602-5380 Indian School RoadCharlotteNC·28233GRP-5844MEDICARE-ADV-B
TPATPA-547552026-02-09T23:53:04ZRice, AmandaA··—1940-05-10—•••-••-2522—-8763 Spring StFRESNOCA93709—null
TPATPA-581182026-08-23T05:50:13Z·DiegoT.Snyder1949-08-27N/A-NULLUNKNOWN8410 Valley View DriveColumbusOHN/A——
TPATPA-525302026-05-26T21:01:32ZChristopher A.—Austin1944-12-09null·--null8029 Highland AvenueAustin··TX78715··--
TPATPA-631322026-02-25T09:18:04ZMarcus—Luna19550312—null2348831994marcus.luna@icloud.com5242 Lake View RoadTampaFL33623N/A-
TPATPA-513942026-02-18T07:46:46ZMichael—Campbell2005-09-05-NULL—-1057 Maple AvenueAustinTX78731UNKNOWNnull
TPATPA-502222026-07-11T00:18:14ZISABELLA—HARRISON···1987-09-12—NULL933-341-2719isabella.harrison98@aol.com4153 Ridge RoadSACRAMENTOCalifornia··95883—UNKNOWN
TPATPA-596312026-05-29T19:33:26Z·Tran, Sara—··20-09-2003———sara.tran19@outlook.comUNKNOWNNULLUNKNOWN--NULL
TPATPA-533482026-02-06T13:56:13ZSofia—Castro·1999-02-28NULLnull8704668083—3317 LINCOLN WAY #418Las VegasNV89132N/A—
TPATPA-618702026-09-23T08:23:56ZKATHERINE··—SILVA18-01-1966UNKNOWN·null3847463014null3394 Palm Drive·TucsonAZ85792——
TPA TPA-51817 2026-09-22T20:03:51ZERIC····MORENO1942-10-23-——-8842 Sage CtLos AngelesCA··90094NULL—
TPATPA-538142026-05-25T15:53:22ZNathan····Bennett1952-12-14UHC-27614-09•••-••-5460N/ANULL2690 Lincoln WayDenverColorado80206NULLmedicare-adv-a
TPATPA-538232026-08-14T19:37:50ZParker, Billy——06/07/1973N/A-19594843069····1222 Baseline RdChandlerAZ85280—SELECT-EPO
TPATPA-529672026-04-10T09:05:19ZKelly—Cruz1993-11-26N/A-·····null1892 Valley View DrNashvilleTN37244——
TPATPA-551562026-01-30T22:42:31ZCAROLYN—FISHER19510524—•••-••-2522(515) 331-0641—7001 BASELINE ROADEden PrairieMN55378GRP-5002OPTIONS-PPO
TPATPA-521862026-06-17T18:33:00ZEMILY—WASHINGTON1996-10-21NULL•••-••-4178(866) 633-7447—N/A-N/A··——
TPATPA-614602026-04-17T22:36:12ZRoss, RuthZ.··1970-04-21UNKNOWN•••-••-2800539.256.7651—3071 Canyon RdPhoenixAZ85096nullnull
14,474 rows, page 204 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:53.743Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty