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-529272026-01-30T11:36:41ZRonald—Collins08-05-1949UNKNOWN—NULLronald.collins48@aol.com4782 MOUNTAIN VIEW DRLos Angeles··CA90002··-—
TPATPA-579342026-04-04T12:41:36Z·Ann—SimsDec 20, 1973——(936) 782-9933NULL3815 PALM DR··PhoenixAZ85050-0650GRP-3920—
TPATPA-524592026-02-25T06:16:38ZBrittany—Simpson1979-05-16null—250-741-8190—1635 Spring StreetSan DiegoCaliforniaUNKNOWN——
TPATPA-589702026-01-07T01:40:12Zgloria—tran1945-05-04nullUNKNOWN517-677-8499N/A—N/A—N/A··——
TPATPA-525452026-06-05T13:33:12ZMATEO—RYAN05/21/44UNKNOWNnull—null5949 MEADOW LN··DallasTexas75201-0170-OPTIONS-PPO
TPATPA-534922026-08-24T00:36:55ZBryan··Ryan06/11/83—N/A·NULLUNKNOWN1607 Desert Sky BlvdSACRAMENTOCalifornia95858——
TPATPA-556012026-09-12T07:40:09ZEric—Nunez1974-11-03null•••-••-1071N/AN/A—UNKNOWN··-——
TPATPA-535472026-02-20T16:14:21ZSAMUEL—WHEELER09/23/1960——NULL—9508 Ridge RoadFresnoCAUNKNOWNN/AN/A
TPATPA-581942026-01-04T16:26:43ZLi, GeorgeZ—1955-11-01··——N/A—-N/A-—-N/A
TPATPA-634922026-10-01T06:23:22ZKathleen—Spencer1986-11-25-•••-••-4729——8175 Broadway··CharlotteNC28201····N/A
TPATPA-558142026-04-27T21:56:51ZEmma··—·Washington1985-07-26UHC-86378-61UNKNOWN——6403 PARK PLACEMIAMIFL33143N/A—
TPATPA-512732026-05-19T05:03:41ZKAYLA G—ROMERO6/11/1997nullN/AN/Anull18 Central AvenueGlendaleAZ85309N/AN/A
TPATPA-510542026-03-25T17:41:42ZKAREN—SIMPSON1987-05-19·null-UNKNOWN··7760 Apache BlvdSan AntonioTX78249N/AMEDICARE-ADV-A
TPATPA-559312026-06-21T18:14:14ZArthur—Torres··2005-05-12—--—3615 Valley View Dr·DenverCO80265-—
TPATPA-630872026-06-27T02:06:37ZHelen—Diaz2000-05-28UNKNOWNN/A—UNKNOWN5905 CAMELBACK RD·ColumbusOH··NULL—NULL
TPATPA-627842026-09-09T01:43:10ZAndrea—Griffin1985-06-07——982-656-2855andrea.griffin37@proton.me5822 Bayshore DriveCharlotteNC28203GRP-9477-
TPATPA-529442026-09-27T08:39:26ZBARBARA····VALDEZ1962-04-05UHC-84229-95-(449) 235-2839-2787 CHURCH STHoustonTX77031GRP-6661SELECT-EPO
TPATPA-536522026-01-22T10:13:11ZJOYCE··MUNOZ1970-02-05·--nulljoyce.munoz@gmail.com97 Grand AvenueMINNEAPOLISMN55466GRP-8927CHOICE-PLUS-PPO
TPATPA-554472026-09-18T09:02:11ZBOBBYA.SCHULTZ18-07-1958nullUNKNOWN3073168NULL1371 MAPLE AVENUE···SeattleWashington98198UNKNOWNOPTIONS-PPO
TPATPA-644452026-04-20T13:54:03Z Joan—Wbeer1973-06-08UHC-20455-78N/A—joan.weber12@icloud.com9509 Park PlaceSan Diegoca92153·-—
TPATPA-592112026-01-21T05:37:39ZDenise—White1963-07-19··UNKNOWNnullUNKNOWN—1157 Washington StreetColumbusOH·43283null—
TPATPA-622022026-01-07T20:18:30ZReynolds, Paul——1967-03-18——(404) 670-4966-1055 Mesa Dr·TempeAZ85244NULLOPTIONS-PPO
TPATPA-625942026-08-26T00:42:48ZSnyder, Helen——25-06-1967NULL·UNKNOWN—helen.snyder@icloud.com4492 Ridge RdAtlantaGA30333GRP-6394—
TPATPA-574832026-07-21T15:28:31ZSmith, Jacob——1974-05-08null•••-••-7969—NULL4760 CANYON RDAtlantaga30361N/ACHOICE-PLUS-PPO
TPATPA-557912026-06-12T16:07:50ZAlice··OFishher1970-09-28UHC-66476-36•••-••-8087·UNKNOWNUNKNOWN8729 Park PlaceHoustonTX77078N/A—
TPATPA-640172026-03-13T06:45:45ZHeather—Carpenter21-04-1995NULLnullnullUNKNOWN7891 Forest Avenue·San DiegoCalifornia———
TPATPA-627952026-02-22T13:33:24ZLori—Miller19420211UNKNOWN•••-••-9796N/A—138 Harbor BlvdNASHVILLETennessee37242GRP-7297—
TPATPA-608632026-09-05T17:08:06ZEstrada—William1978-11-07UNKNOWNUNKNOWN487-543-4438—1710 Highland AveTAMPAFL33659UNKNOWNNULL
TPATPA-580922026-05-15T12:22:22ZGARYHHART1984-01-04———N/A··5166 Ridge RoadMesaAZ85272GRP-1572UNKNOWN
TPATPA-632392026-09-10T22:09:48ZChristian—Morris10/22/48—UNKNOWN—CHRISTIAN.MORRIS@OUTLOOK.COM1364 BASELINE ROADChandlerAZ85264··NULL··NULL
TPATPA-511752026-05-14T16:34:25ZCHRISTOPHER—FOX1950-04-28NULLNULL—null3691 HILLCREST RDATLANTAGANULLGRP-4425—
TPATPA-534832026-05-01T08:43:15ZTeresa—Gutierrez2000-03-21null-8406553103—6977 Hillcrest RdMiamiFL33170NULLNULL
TPATPA-500642026-06-04T11:51:51ZJennifer—Cole19621012——6396572717—5396 ELM STREETCharlotteNC28231GRP-9334··
TPATPA-501962026-10-07T04:07:58ZSantiago, Janice·C.—08/07/40—N/A409-302-8714··—210 HIGHLAND AVETucsonArizona85789—UNKNOWN
TPA TPA-601622026-06-09T00:59:12Zscott—shaw·1980-08-26—-(904) 744-2603·scott.shaw33@proton.me6262 Highland Avenue·AtlantaGA30393-4530—N/A
TPATPA-587132026-02-08T01:04:50Z·Mei—Moreno09/16/1945··-6666398-4287 Mountain View DriveDenverColorado80286null—
TPATPA-579262026-03-11T03:50:53ZJoseph—Romero01/14/89NULL—(458) 541-7086null390 Mesa DriveMiamiFL33121GRP-6076—
TPATPA-557752026-03-06T14:46:08ZJonathanQRuizOct 10, 1954nullNULLN/Ajonathan.ruiz78@gmail.com5460 BroadwayPlanoTX75096-··-
TPATPA-617512026-06-03T22:59:20ZRALPH—MARTINEZ·19650328null•••-••-6170—ralph.martinez97@aol.com9712 Main StreetATLANTAGA··30336GRP-0137OPTIONS-PPO
TPATPA-535952026-08-27T00:04:25ZLINDA—MUNOZ1988-01-13—•••-••-7363763.504.1072—8437 Church StreetTampaFL33627NULL—
TPATPA-590952026-05-02T00:10:38ZPark, Santiago——Aug 20, 1941N/A•••-••-0697·7307465276santiago.park@hotmail.com8358 RIVER ROADSan AntonioTX78278GRP-0541MEDICARE-ADV-B
TPATPA-540282026-07-25T12:28:31ZDANILE—PENA06/28/78·NULL•••-••-0912N/ADANIEL.PENA93@PROTON.ME9596 MEADOW LANELos AngelesCA90035··GRP-5166null
TPATPA-533192026-09-14T23:53:11ZAHMED—SANDERS04/11/50—•••-••-4482UNKNOWN———null—NULLMEDICARE-ADV-A
TPATPA-642542026-06-24T14:02:46Z·yuki—jacobs1940-04-28——654.259.7164null—··UNKNOWNUNKNOWNUNKNOWNNULL
TPATPA-601272026-03-27T20:08:26ZAmy—Andrews1944-02-27N/AN/A+1 543 688 2075··amy.andrews@gmail.com3903 Bayshore DriveJacksonvilleFL32265UNKNOWNSELECT-EPO
TPATPA-518562026-07-06T12:31:26ZMelissa—Thomppson10-02-1976UNKNOWN•••-••-3610—NULL7633 WASHINGTON STREETScottsdaleAZ85205GRP-8403UNKNOWN
TPATPA-624062026-07-17T19:22:28Z KAYLA—JENSEN05/06/92-—UNKNOWNkayla.jensen@yahoo.com3522 PARK PLPHOENIX·AZ85045—NULL
TPA TPA-535112026-06-23T07:25:06ZJudy—Lawrence2008-01-26UHC-33684-39•••-••-1832——UNKNOWN-—····——
TPATPA-506192026-04-17T20:25:53ZBian—Cox4/19/1980UHC-39816-02UNKNOWNN/A—4972 Washington StEDEN PRAIRIEMN55352-··CORE-HMO
TPATPA-571322026-07-13T08:24:37ZCarlQWang4/5/1944null•••-••-7744N/A··UNKNOWN8827 RIVER ROADOrlandoFL32800-1381-CORE-HMO
14,474 rows, page 172 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:52.237Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty