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-595812026-09-09T18:10:08ZHIROSHI—FLORES10/20/1966N/A•••-••-1250—-··N/AN/AUNKNOWN——SELECT-EPO
TPATPA-535282026-08-11T08:34:40ZWang, Arjun——Nov 20, 2008N/ANULL13436525362—8548 Cedar LnNashvilleTennessee37274NULL—
TPATPA-557312026-07-14T06:34:32ZJudy··I.Stevens1962-08-11··—•••-••-3696··—3652 Palm DrLOS ANGELESCA—-NULL
TPATPA-606902026-02-28T08:12:49Zbeverly—butler10/6/1993UHC-36916-85—3688040538-8572 Ocean AvenueHoustonTX77078GRP-7828—
TPATPA-641732026-05-06T21:44:53Z Jack—Adams1981-01-10N/ANULLNULLN/A5831 Ridge RdGlendaleAZ85300GRP-3263-
TPATPA-552482026-09-01T10:08:45ZBarbara—Marshall9014-19-63UNKNOWNNULLUNKNOWNbarbara.marshall@yahoo.com4996 Central AveJACKSONVILLEFL32201null—
TPATPA-625402026-04-12T05:54:33ZJeremy—Mason1962-12-28—-(815) 398-1570UNKNOWN··4853 Apache BlvdJacksonvilleFL32253—-
TPATPA-600652026-10-14T19:26:01ZElijah—Rodriguez1943-10-08NULL—888-931-3453·null·5994 Union StCharlotteNC··28280GRP-2166-
TPATPA-573872026-01-13T19:29:45ZZachary—Kennedy1/5/2001N/A•••-••-5643NULLzachary.kennedy@proton.me505 Oak StMesa··Arizona85297—N/A
TPATPA-606802026-01-04T16:12:03ZMyers, Rebecca——1985-12-02—null15239443816-2515 Palm DriveTucson··AZ··85767NULLcore-hmo
TPATPA-567012026-03-01T20:48:29ZDonald—Fowler2005-03-25UHC-20542-52•••-••-6234+1 226 400 9481NULL8557 CENTRAL AVE Apt 23Eden PrairieMN55369GRP-3022OPTIONS-PPO
TPATPA-604062026-05-20T19:13:01Z·jerry—ramosUNKNOWNnullN/AN/AJERRY.RAMOS@PROTON.ME4035 Sage CourtChandlerAZ85249—null
TPATPA-555532026-07-20T05:07:25ZMark—Cllark1939-01-17--3398161429null5557 MEADOW LNSACRAMENTOCA95837GRP-3149—
TPATPA-539222026-03-26T02:35:00ZANDREWS—JOHN1960-09-20N/A··•••-••-8157N/AUNKNOWN8168 Lincoln Way #782DallasTX75234GRP-6883NAVIGATE-HMO
TPATPA-643252026-04-29T16:22:30ZCarter, Rachel——1953-11-18NULLNULLnull··UNKNOWN6729 Grand AveSan DiegoCA92164nullNAVIGATE-HMO
TPATPA-518962026-07-01T03:18:11ZCastro, Randy··——18-09-1969—•••-••-3331+1 289 544 6528—8169 Oak StreetLAS VEGASNV89161nullUNKNOWN
TPATPA-597202026-07-07T18:42:52ZRalph—Espinoza1983-11-01N/AUNKNOWN(452) 200-5935N/A—--——UNKNOWN
TPATPA-529962026-07-20T15:44:47Z Amy—Andrrews8/10/1986null··—nullamy.andrews36@outlook.com6269 MARKET STREETMinneapolisMN55430—NULL
TPATPA-560552026-09-25T15:36:31ZRobertson, CatherineT.—07/02/1941—N/A··UNKNOWN··catherine.robertson@hotmail.com4634 Desert Sky BlvdFresnoCA·93766N/AMEDICARE-ADV-B
TPATPA-565412026-01-28T20:44:37ZMARYCCLARK··2004-05-11UNKNOWN•••-••-0913+1 371 895 4354—343 BroadwayLos AngelesCA90035null—
TPA TPA-56891 2026-09-04T08:44:09ZTERESA—VAZQUEZMar 18, 2003null•••-••-8870-teresa.vazquez3@hotmail.com6244 Union StPLANOTX75087—NULL
TPATPA-524982026-03-14T20:12:03ZEMMA—LAWSON19550521—nullnullUNKNOWN3954 Central AveJacksonville·FL32248UNKNOWNMEDICARE-ADV-B
TPA TPA-545712026-05-16T04:15:08Zmargaret··Lowens02-07-1976—-nullN/A549 Oak StTampaFL·33638·GRP-5350MEDICARE-ADV-B
TPATPA-522142026-01-11T03:41:30ZalanMaguilar·19411105N/Anull·(594) 360-6724—7777 Hillcrest RoadMIAMI··FL33170UNKNOWNOPTIONS-PPO
TPATPA-619852026-04-27T10:27:17ZSantiago—SandovalOct 12, 1958—·-—null8497 Camelback RoadSan AntonioTX78213-medicare-adv-a
TPATPA-634592026-06-02T16:14:26ZLe, Diane··——9/26/1952null•••-••-1083——NULL—NULLUNKNOWNN/A·N/A
TPATPA-622542026-08-03T19:11:46ZtomYmoore1980-09-27N/A··•••-••-8543null··-8891 ELM STMiamifl33194-8825GRP-7345null
TPATPA-639562026-02-15T19:46:30ZMARY—HUDSON01/14/1995N/A——UNKNOWN9385 MESA DRIVE··San DiegoCA92171-0650GRP-4563CHOICE-PLUS-PPO
TPATPA-526772026-08-11T13:07:39ZJOHN—RICHARDS1960-01-18UNKNOWN—·+1 934 737 8156john.richards30@yahoo.com9467 Valley View DrSan AntonioTX··78229·-MEDICARE-ADV-B
TPATPA-559672026-05-09T11:11:34ZLindaIWang1979-05-24··—•••-••-8878·NULL—528 SAGE COURTSeattle··WA98117UNKNOWNNULL
TPATPA-558892026-09-29T12:03:39ZCHARLES—BRADLEYAug 19, 1988null·-474-302-5278—1556 WILLOW COURTDENVERCON/AGRP-1655CHOICE-PLUS-PPO
TPATPA-52376 2026-02-13T09:15:53ZLawrence—Martin1943-05-06-NULL922-349-1588NULL204 Union StMiamiFL33191·GRP-0509N/A
TPATPA-524192026-09-09T10:03:59ZGrace—Ramos10/27/89UHC-17338-10—N/A-8508 Maple AvenueMinneapolismn55492-NULL
TPATPA-543432026-07-26T01:22:48ZSteveAHarrison·1963-08-13N/A·-829-400-7719—5551 Grand AveSeattleWA98188——
TPATPA-599792026-04-26T10:20:35ZFRANK—BANKS1981-05-15—N/A5343609093-—-UNKNOWN···null——
TPATPA-628312026-02-21T15:55:43ZEMILY—NICHOLS1955-03-08UHC4239085null(962) 202-2755—9636 Union StreetScottsdaleAZ85257-9585—SELECT-EPO
TPATPA-521252026-08-27T02:18:47ZKayla—·Williamson2008-07-14—•••-••-1974UNKNOWNkayla.williamson@outlook.com9478 Jefferson AveColumbus··OH43221N/AN/A
TPATPA-591842026-02-08T13:43:49ZDennis—Rivera06/18/96—·-—UNKNOWN—NULLUNKNOWNnullN/A··—
TPATPA-612492026-10-18T01:09:24ZGonzales, Theresa——2007-09-28N/A——UNKNOWN3488 Lake View Road Apt 33·NashvilleTN37222GRP-4757UNKNOWN
TPATPA-547492026-09-04T06:09:10ZLarry—Fuller3/7/1978-N/A+1 920 531 0869larry.fuller17@gmail.com9464 Forest AvenueAustinTX78713UNKNOWNOPTIONS-PPO
TPATPA-611642026-04-07T04:20:33Zeric····perry1951-06-01·null•••-••-4596N/A—9175 Elm StreetDALLASTX75208——
TPATPA-515822026-06-23T02:24:54ZEVELYN—RAY1941-10-09NULL-nullNULL1967 CAMELBACK ROADEDEN PRAIRIEMN55330GRP-1586UNKNOWN
TPATPA-61829 2026-09-01T21:40:50ZBRADLEY—WEBER··06/17/1991—•••-••-85807224829611—6986 Pine DriveMIAMIFL33102GRP-6741null
TPATPA-520912026-04-29T22:31:45ZRobert—Gray2002-09-01—UNKNOWN——3886 Mesa DriveSan DiegoCA92165—CORE-HMO
TPATPA-638182026-01-31T15:05:14Zhannah—ramos19520918UHC-51097-46——UNKNOWN8140 BROADWAYTEMPEAZ85258nullnavigate-hmo
TPATPA-519002026-08-23T10:47:26ZGeorge, BradleyW.—1978-09-01null•••-••-9450NULLgeorge.bradley43@hotmail.com114 HIGHLAND AVEDenverColorado80226··UNKNOWNcore-hmo
TPATPA-530712026-04-19T00:25:51ZARTHR—HERNANDEZ2003-08-06UNKNOWNUNKNOWN-—9506 WASHINGTON STREETMESAAZ85298UNKNOWNNAVIGATE-HMO
TPATPA-61835 2026-09-14T12:16:03Z·Susan—Ward1976-10-13NULL-——1262 Canyon Road··ColumbusOH··43220GRP-0434CORE-HMO
TPATPA-573892026-02-10T00:53:05ZAdam—Li1945-01-18——————null—-UNKNOWN
TPATPA-525002026-07-21T04:06:39ZSharon—Lynch1977-12-04null•••-••-3705—sharon.lynch@aol.com8452 DESERT SKY BOULEVARDMIAMIFL33157GRP-4071UNKNOWN
14,474 rows, page 119 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:46.057Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty