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-515192026-08-05T16:44:48ZJoshua··Murphy19581218NULL•••-••-5718-····5303 BASELINE RD··CHANDLERAZ85280GRP-4824—
TPATPA-595832026-06-27T18:34:53ZLarry—Morales··6/9/1941UNKNOWN•••-••-876316054619166-··3047 Main St·NashvilleTN·37222UNKNOWNnull
TPATPA-621502026-01-10T05:16:12Z·Beverly—Santos1984-03-21-—+1 745 827 5991beverly.santos21@gmail.com7505 Ocean AvenueFresnoCA93736NULL·NULL
TPATPA-630442026-09-08T02:55:55ZWayne—Payne1975-03-16·-N/A12405843306·UNKNOWN4120 RIVER ROADJACKSONVILLEFL32230—····
TPATPA-641402026-01-10T13:36:19Zdina—harris03/11/92UNKNOWN——NULL6494 Mesa DrMIAMIFL33154NULLNULL
TPA TPA-635362026-06-26T17:55:02ZLisaY.Larson··1984-07-02null····6553473—6402 Sage CtOrlandoFL··32890GRP-3521NULL
TPATPA-502172026-04-12T14:05:15ZDOT·X.REYES07/24/94—null—NULL·8886 LAKE VIEW RDOrlandoFL·32868NULLOPTIONS-PPO
TPATPA-63888 2026-05-20T07:14:40ZNatalie—Moore1963-05-18—•••-••-7218+1 273 249 8869-1524 VALLEY VIEW DRIVEAUSTINTX78776-CHOICE-PLUS-PPO
TPATPA-566652026-02-26T10:37:48ZJeremy—Lng2005-07-23UNKNOWNUNKNOWN(756) 785-0188N/A—··UNKNOWNUNKNOWNUNKNOWN··N/A
TPATPA-634862026-09-14T13:57:43ZJanet—Hawkins1947-06-21UNKNOWNUNKNOWN+1 783 455 4394-2446 Indian School RdSeattleWA98147-5849GRP-1317UNKNOWN
TPATPA-529932026-03-05T02:02:00ZGloria—Owens1949-08-02N/A——gloria.owens@yahoo.com4276 Spring StMiamiFL33151N/AUNKNOWN
TPATPA-633552026-07-04T08:15:45ZAARON—MURPHY1990-05-14UHC-37198-49-892-619-6294UNKNOWN8259 Pine DrPhoenixAZ85042····UNKNOWN
TPA TPA-58502 2026-08-05T04:35:51ZWei—Hamilton1938-05-27————-—UNKNOWNnull—null
TPATPA-601332026-10-06T05:27:32ZbenCbarnes1943-11-28UHC-74392-69-—N/A-··null—-—null
TPATPA-536442026-02-14T23:42:31ZMark—Crawford9/21/2007··UHC-01977-37—(769) 232-1087NULL2051 Grand AveLas VegasNV89118NULL—
TPATPA-618952026-09-04T09:38:26ZElijah—Campbell·1959-10-22UNKNOWN•••-••-47219678447NULL—————CORE-HMO
TPATPA-518882026-03-24T19:02:18ZCatherine—Richardson1988-01-10UHC-00641-21UNKNOWN4248223146—4471 ELM STSeattleWA98189null··null
TPATPA-545792026-04-20T05:10:07Z JACK—BLACK1940-05-11—null—JACK.BLACK@GMAIL.COMnullUNKNOWN—N/AGRP-7409-··
TPATPA-609542026-03-28T02:06:36ZDOROTHY—LAWRENCE19761202NULL•••-••-6538nulldorothy.lawrence@icloud.com28 Ocean AvenueTUCSON·AZ85790UNKNOWNN/A
TPATPA-528512026-09-27T14:09:22ZRALPH—SCHULTZ··1980-08-17--—-6360 Ridge RdMinneapolisMNNULLUNKNOWN—
TPATPA-590222026-03-12T10:11:24ZDavid—Schultz1995-05-21··N/A-(439) 349-8359null·9059 LAKE VIEW ROADAtlantaGA·30343····NULL
TPATPA-507952026-02-11T13:57:28Zlawrence—·young1953-09-03—N/A—N/A3964 Oak StreetTucsonArizona85772—null
TPATPA-567752026-06-14T19:48:50ZLAWRENCE·····RICHARDS1964-11-21—NULLUNKNOWNlawrence.richards26@outlook.com6040 MAIN STColumbusOHnullGRP-6573-
TPATPA-506412026-06-15T12:23:48ZASUTIN—·STEVENS1992-06-12NULLnull17376688370N/A9145 Canyon RoadCOLUMBUSOH43281N/AMEDICARE-ADV-B
TPATPA-631832026-05-01T20:45:40ZJasonV.Ortega1996-12-07··NULL•••-••-6066nullJASON.ORTEGA8@PROTON.ME7545 Apache BlvdSan Antonio··tx78249UNKNOWNOPTIONS-PPO
TPA TPA-545702026-10-03T09:49:31Zmargaret—owens07/02/76————549 Oak StTampaFlorida33638—NULL
TPATPA-511272026-01-23T05:19:47ZGREGORY—RICHARDSON1960-04-11UHC-32697-71NULL——·1687 Palm DriveDallasTX75271GRP-3090UNKNOWN
TPATPA-599702026-08-10T00:34:52ZanaJ.riec19670527—•••-••-8415303-611-3499·null2102 GRAND AVEChandlerAZ85232UNKNOWN·CORE-HMO
TPA TPA-623172026-02-24T06:11:34Z·STEVEN—GUERRERO02-03-1959null··•••-••-44766586229403UNKNOWN7513 MOUNTAIN VIEW DRDenverColorado80281——
TPATPA-514952026-07-28T06:54:36ZMATEO—JOHNSON19860905—-—null9534 Spring Street·San DiegoCA92184··N/ACHOICE-PLUS-PPO
TPATPA-577102026-05-12T12:29:25Zcharlotte—duncan11/08/89——NULL—9268 Valley View DriveColumbus··OH43264-8677N/ANULL
TPATPA-641882026-02-02T11:02:45ZLogan——1960-07-15nullNULL····-6603 JEFFERSON AVENUE #113MiamiFL33191-7930GRP-5020N/A
TPATPA-517792026-10-16T21:21:00ZBEVERLY··FULLER1940-08-02NULL·NULL(260) 609-1194··NULL··1857 WILLOW CTMinneapolisMNUNKNOWNGRP-6501—
TPATPA-565302026-07-30T06:43:55ZPriya··—Edwards19990714NULL··null—priya.edwards71@yahoo.com2881 BAYSHORE DRIVE #677San AntonioTX78280GRP-8461null
TPA TPA-527162026-05-16T20:51:56ZHiroshi—Murphy1978-01-07——17885264797—1230 Lincoln WayEden PrairieMN55340N/ACHOICE-PLUS-PPO
TPATPA-636292026-02-04T16:03:37Z·Victoria—Santos1943-12-21—•••-••-4663—null3593 Main StreetScottsdaleAZ85286GRP-9442··NULL
TPA TPA-590312026-06-15T20:14:42ZJuan—Thompson1991-10-12N/AUNKNOWNNULL——nullnullN/AGRP-9308SELECT-EPO
TPATPA-553092026-03-16T02:28:31ZAmy—Dunn1946-10-02UHC-41815-99··UNKNOWN—2622 CAMELBACK ROADChandlerAZN/A——
TPA TPA-60761 2026-09-27T22:48:26Z·Gilbert, Roy····—1957-01-25··N/A··UNKNOWNUNKNOWNUNKNOWN5220 MARKET STSan AntonioTX78221-3408NULLCHOICE-PLUS-PPO
TPATPA-56392 2026-05-02T00:46:50ZDorothy—Taylor1989-04-01———NULL3562 Meadow LnGilbertAZ——NAVIGATE-HMO
TPATPA-550082026-03-13T00:32:17ZLORI—JORDAN19850524UNKNOWN•••-••-9778N/Alori.jordan95@yahoo.com3367 Ocean AvenueMesaAZ85209N/AOPTIONS-PPO
TPATPA-580942026-02-21T16:25:00ZTheresa—·Cooper21-01-1955nullUNKNOWN405-536-7414theresa.cooper@icloud.com5258 Lake View Road Apt 21·TempeAZ85221GRP-6608NULL
TPATPA-569612026-05-25T17:18:51ZJose—Black1963-09-14——(583) 621-7686—4276 Cedar LaneFresnoCA93707NULL-··
TPATPA-588012026-02-10T09:51:22ZWagner, Gregory··——1968-04-22N/A····——3175 Mesa DriveScottsdaleAZ85228-···UNKNOWN
TPATPA-506722026-02-14T19:55:23Zchristian—hicks1961-12-20-•••-••-66186385243268—444 Grand AveLos AngelesCA90018GRP-8086··
TPATPA-626222026-08-12T19:37:41ZSamuel····Medina1943-08-15—UNKNOWN873-471-8945··UNKNOWN1746 GRAND AVENUE #589SacramentoCA··95807UNKNOWNnavigate-hmo
TPATPA-60094 2026-03-20T20:56:16ZAnna—Wong2007-03-16—NULLN/A—9280 Valley View DrJacksonvilleFL32203-7070—UNKNOWN
TPATPA-509142026-10-09T17:27:11ZArnold, Jack··—10/23/1950—····UNKNOWNnull6818 Spring Street··COLUMBUSOH43276-8552-null
TPATPA-521072026-02-08T16:05:32Z·laura—tucker·1991-02-16null—null—7137 Lincoln WayMINNEAPOLIS·MN55412—NAVIGATE-HMO
TPATPA-505452026-05-20T18:49:52ZMartinez, Karen······1972-11-01NULLUNKNOWNN/A—UNKNOWNN/A·NULLN/A—CHOICE-PLUS-PPO
14,474 rows, page 103 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:43.464Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty