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-541132026-07-02T18:29:02ZKyle—Li1946-05-20NULL•••-••-4316-—1871 Ocean AvenueCharlotteNC28217GRP-1937UNKNOWN
TPATPA-528302026-01-07T19:25:55ZBrian—Flores2001-06-10·NULL—N/Abrian.flores@gmail.com438 Baseline Rd··TucsonAZNULL—·N/A
TPATPA-554692026-09-08T02:31:46Z·Andrew, Foster——19551012—•••-••-65216394265330NULL6503 Cedar LnLas VegasNV89173-3909nullnull··
TPATPA-562602026-08-22T02:34:45ZNancyS.Price07-11-1979null····(781) 794-5399nancy.price18@aol.com9716 PARK PLCharlotteNC28205GRP-4517CHOICE-PLUS-PPO
TPATPA-560632026-01-29T11:58:12ZALEXANDER—WILLIAMSON05/24/1968NULL——NULL5393 Ridge RdLas Vegas··NV89146NULLCORE-HMO
TPATPA-506212026-01-24T11:32:46ZSophia—Watkins··1974-02-03NULL•••-••-8646NULL—UNKNOWNN/Anull———
TPATPA-637582026-01-14T18:28:57Zarun—wst1942-08-06-NULL·505.851.6365NULL·7968 Main StJACKSONVILLEFL32215—UNKNOWN
TPATPA-637462026-03-28T20:46:19ZAdam—Alexander1994-02-24—•••-••-04324056762359-1034 Harbor BlvdEden PrairieMinnesotanull··NULL
TPATPA-567662026-08-25T02:35:26ZWilliamson, Keith——1976-03-27null•••-••-25723008777832—1299 VALLEY VIEW DRIVEPhoenixAZN/AGRP-2330null
TPATPA-525832026-08-15T18:26:06ZBrianCWeber1975-06-13UHC-56118-72•••-••-359914158864973NULL732 Bayshore DrJacksonvilleFL32203N/A-
TPATPA-524542026-05-28T22:11:51Z·Nicole—Duncan1958-08-01NULLNULL-NULL—····-····—CHOICE-PLUS-PPO
TPATPA-513862026-05-29T06:14:27ZCarolyn··—King··6/22/1997—-—carolyn.king36@hotmail.com6321 HIGHLAND AVEFresnoCA93768GRP-5286-
TPATPA-640682026-09-05T01:26:09ZCynthia—LeSep 14, 1945UNKNOWN—NULLN/A3532 PINE DRIVEChandlerArizona85275—CHOICE-PLUS-PPO··
TPATPA-629032026-01-21T21:45:46Z·Ashley—Hall7/24/1959UHC-37221-22•••-••-7065—null4977 Maple AvenueLos Angelesca90038··UNKNOWN··—
TPATPA-522892026-04-16T12:38:01Zthomas—boyd1984-09-28—•••-••-7171N/AN/A7546 Sunset BoulevardSacramentoCA95883NULLN/A
TPATPA-550112026-10-09T17:42:58ZJULIETORTEGA1964-09-26nullN/A·-N/A1649 Mountain View DriveFresnoCA93764GRP-9219—
TPATPA-551742026-01-12T06:10:27ZChristopher—Hoffman05/04/1946null··—·christopher.hoffman@proton.me6080 BASELINE ROAD··HoustonTX77022NULLMEDICARE-ADV-A
TPATPA-612482026-01-19T00:55:00Zgregory—tuckrN/A—UNKNOWNnullUNKNOWN5215 Mountain View DrColumbusOH43294GRP-0401—
TPATPA-629002026-02-18T18:23:47ZCarter, LindaV—2002-07-16UNKNOWN•••-••-5739N/AUNKNOWN·1257 JEFFERSON AVEGilbertAZ·85294—UNKNOWN
TPATPA-639282026-01-16T00:56:32ZAhmed····Young1946-04-02—·UNKNOWNNULL—1525 PINE DRSCOTTSDALEAZ85226UNKNOWNN/A
TPATPA-558662026-08-22T06:40:54ZWAYNE—TORRESJun 26, 1994—•••-••-4806+1 424 865 5306null5701 Willow CtJacksonvilleFL··32236UNKNOWNUNKNOWN
TPATPA-638732026-03-27T21:58:44ZGARY··—MATTHEWS·1945-11-13—·N/A-NULL3179 Indian School RdLos AngelesCAN/A—UNKNOWN
TPATPA-560172026-01-27T01:04:49ZNICHOLAS—POWELL1970-19-05UHC-23532-82UNKNOWN221-300-6935nicholas.powell@gmail.com8378 Church StreetMiamiFL33153UNKNOWN—
TPATPA-575792026-02-16T18:27:19ZJudith—Cole04-02-1994—•••-••-6598537.434.0268—4995 Mountain View DrDenverColorado··80241NULL—
TPATPA-534512026-01-06T09:53:33ZCAROL—CRUZ10/21/05-UNKNOWN—CAROL.CRUZ22@ICLOUD.COM4813 WASHINGTON STHoustonTX77065-3476GRP-4297-
TPATPA-608142026-05-12T09:31:36Z·TheresaKKnight1975-05-06N/A-N/ATHERESA.KNIGHT42@ICLOUD.COM7122 MOUNTAIN VIEW DRTampaFL—GRP-3118UNKNOWN··
TPATPA-563782026-09-03T14:03:49ZASHLEY—REED09/19/2002—UNKNOWN604-602-8141UNKNOWN··418 RIDGE ROADCharlotteNC28289NULL—
TPATPA-501462026-06-26T19:20:21ZDianaHFields1967-06-06null•••-••-3098NULLDIANA.FIELDS@YAHOO.COM8127 Spring StreetMiamiFL33179-0755·UNKNOWNNULL
TPATPA-558972026-05-07T11:52:16ZAlexander, Amber——19600526—null(230) 638-4043null——UNKNOWN—GRP-7857N/A
TPATPA-519852026-09-17T10:09:04ZSusan—Rojas··15-10-1992UHC-20787-07—NULL—8825 SAGE CTTampaFL33614··GRP-0355OPTIONS-PPO
TPATPA-59729 2026-04-27T20:59:55ZPatriciaESanchez1942-07-20·null•••-••-3552nullNULL8616 Bayshore DriveChandlerAZ85240——
TPATPA-611182026-06-17T16:57:43ZCheryl—Munoz1971-07-19-UNKNOWN—null———--—
TPATPA-614802026-09-29T11:09:15Z ARJUN—FERNADEZ1950-04-22NULL—+1 901 307 5807—3885 Park PlMinneapolisMN55436—N/A
TPATPA-619122026-01-31T15:26:47Z Donald—AndersonMay 15, 1955NULLNULLNULL—860 Sage CourtSCOTTSDALEAZ85291null··N/A
TPATPA-541542026-08-23T09:31:55ZRoy—Crawford··1991-07-27UHC-84794-41—N/Aroy.crawford@yahoo.com6673 Oak St·SeattleWA98175-7453—OPTIONS-PPO
TPATPA-534712026-04-23T05:12:48ZEmma—Richards3/20/1964UHC-83085-09•••-••-7706-NULL——··UNKNOWNN/AN/A
TPATPA-618172026-02-20T00:57:29ZBradley—Bishop2002-09-22UHC-02311-67nullUNKNOWN····3761 Oak St·CHANDLERAZ85221-····
TPATPA-522722026-03-20T19:12:56ZJeremy—Garrett··1996-11-08N/ANULL-—2455 Pine DriveNashvilleTN37279UNKNOWN··MEDICARE-ADV-A
TPATPA-506972026-08-22T13:43:30ZWayne—Santiago1999-03-04N/ANULLnull·NULL1288 Highland AvenueCharlotteNC28253-SELECT-EPO
TPATPA-565102026-04-28T09:37:25ZCrwaford, EugeneI—1980-09-21UHC-23406-39NULLnullEUGENE.CRAWFORD59@PROTON.ME—nullnullnullGRP-2163·null
TPATPA-542192026-03-09T22:34:52ZSamantha—Patterson1974-10-20UHC-44506-47•••-••-1893(919) 860-2559N/A——NULL—GRP-3986·N/A
TPATPA-575232026-05-19T05:48:18Z Rios, Yuki——1979-11-21UHC-04431-12UNKNOWN··-—2827 Central Ave Apt 10OrlandoFL32883——
TPATPA-537782026-07-10T12:08:10ZWaye—Ferguson19690612N/AUNKNOWN7397781136——N/A—····——
TPATPA-630052026-01-04T00:35:15ZMARTHA—CARPENTER2001-04-23—UNKNOWN—MARTHA.CARPENTER90@ICLOUD.COM8661 Valley View DriveSEATTLEWA98122-4173GRP-9724SELECT-EPO
TPATPA-523162026-09-20T18:45:17ZANA—WHITE1980-04-08N/A··•••-••-3297-—7235 Lake View RdNASHVILLE···TN37290NULLCORE-HMO
TPATPA-628762026-05-24T10:06:44Zdiego—li1992-02-05N/AnullUNKNOWN—181 Meadow LaneJacksonvilleFLnullnull-
TPATPA-559332026-01-12T02:51:29ZCynthia—·Sandoval2002-04-06null•••-••-4776N/Acynthia.sandoval46@proton.me9753 Lake View RoadAustinTX78787GRP-0371UNKNOWN
TPATPA-557192026-03-13T22:37:44ZKELLY—·JIMENEZ·19600509nullnull(867) 235-7828NULL9175 FOREST AVENUEDallasTXUNKNOWNNULLCHOICE-PLUS-PPO
TPATPA-553652026-01-09T17:40:55Z Evelyn—Gonzales19620220——null—942 Valley View DriveSan AntonioTX78274null—
TPATPA-557162026-01-04T06:44:05ZLuca··Young11/09/1942UHC-46362-85-N/A—nullUNKNOWNUNKNOWN-GRP-8761NULL
14,474 rows, page 9 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-19T19:54:25.429Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty