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-507332026-04-23T09:43:00ZCARL—KING1958-02-06UHC5637801NULLNULL—6441 Mesa DrHoustonTX··77050-null
TPATPA-511462026-04-03T07:27:53ZEMMAJROMERO1974-01-25-NULL——1356 Jefferson AvenueMinneapolisMN55486N/ACORE-HMO
TPATPA-596632026-01-04T14:36:31Zgary—hill19550323—null6713363gary.hill47@icloud.com1930 Apache BlvdSEATTLEWA98148—N/A
TPATPA-515872026-04-22T02:12:58Z Olivia—Cox1/6/1964UHC-84543-81—UNKNOWN··-4346 WASHINGTON STREETJACKSONVILLEFL··32201GRP-1731N/A
TPATPA-500612026-09-12T13:46:53ZMichael—Franklin01/11/1940UNKNOWNUNKNOWN—UNKNOWN8021 Park PlaceFresnoCA·93753NULL-
TPATPA-504422026-07-01T22:04:33Z·Mary—Willis1939-06-26UNKNOWNNULL—·mary.willis63@outlook.com1470 Apache BlvdAustinTX78705—····
TPATPA-545082026-10-02T16:02:07Zvincent····wilson1948-08-22N/A•••-••-7617N/A—UNKNOWN—-—GRP-7800—
TPATPA-563372026-05-23T03:08:52ZANA····WONG1980-05-28NULLUNKNOWN··(395) 595-9376—4229 Pine DrScottsdaleAZ··85277null—
TPATPA-555512026-02-17T16:16:01ZWelch, Pat——1952-01-17UHC-32323-36—UNKNOWN—8468 Indian School RdTampaFL··33691——
TPATPA-515752026-01-15T17:10:04ZBetty—Johnson1/24/1991-—439-793-3926-··-—UNKNOWNN/AGRP-0606MEDICARE-ADV-A··
TPATPA-598742026-01-15T20:28:46Z·Bobby—Wilson12/8/1980·UHC-65025-01UNKNOWN—bobby.wilson@outlook.com2048 Lake View RdSAN ANTONIOTX—GRP-1788—
TPATPA-50103 2026-02-13T18:30:21ZPamela—Gonzalez1996-12-18UNKNOWNUNKNOWN(829) 874-1320————NULLUNKNOWNMEDICARE-ADV-B
TPATPA-576652026-10-14T19:47:43ZSean—PryceMay 18, 1952—N/A—SEAN.PRICE10@OUTLOOK.COM469 Apache BlvdCHANDLERArizona85296N/ANAVIGATE-HMO
TPA TPA-540852026-01-20T15:31:01ZLuis—Richards··08/21/69N/A··•••-••-72949204617339NULLnullUNKNOWNN/A—UNKNOWN·MEDICARE-ADV-B
TPATPA-585282026-10-05T12:55:48ZTheresa—Carroll2008-02-25null··—·630-326-9239UNKNOWN7403 BASELINE ROADSCOTTSDALEAZ85273GRP-6398CORE-HMO
TPATPA-500882026-03-21T06:21:03ZRogerXOrtiz1970-12-19N/A•••-••-6698-N/A7441 Bayshore DriveMinneapolisMinnesota55411·UNKNOWNN/A
TPATPA-615222026-07-03T04:52:50Z Douglas··—WoodsJan 7, 1940—NULL——NULL—null—null·select-epo
TPATPA-601902026-01-30T07:53:56ZJean··Lawrence1974-03-03—··NULLUNKNOWN661 Lincoln WayPhoenixAZ85005—-
TPATPA-617742026-02-21T15:46:40ZFatima—James08/22/59N/AN/A—UNKNOWN751 RIDGE RDAtlantaGA30356GRP-4923NULL
TPATPA-560002026-08-17T02:03:14ZBOBBY—WATSON1949-06-19-N/A5296779979—6761 Oak Street··PHOENIXAZ85053N/A··UNKNOWN
TPATPA-549532026-02-10T09:00:18ZNichols, JudyJ—03/04/77—NULLnullN/A···468 Spring St Apt 17PhoenixAZ85003—N/A
TPATPA-527412026-02-01T12:58:02ZFrank—Austin2000-07-18UHC-13200-56—null—null——NULLNULL·MEDICARE-ADV-A
TPATPA-565722026-09-22T17:01:25ZEMMA—WEAVER·1980-80-25—•••-••-5927-UNKNOWN5025 LINCOLN WAYJACKSONVILLEFL32265GRP-4644··UNKNOWN
TPA TPA-50288 2026-10-12T15:43:48ZMattheew—Vega08/17/98—UNKNOWN(483) 430-4551—4884 DESERT SKY BOULEVARDTUCSONAZ85722GRP-3174····
TPA TPA-528172026-06-24T04:24:23ZContreras, Jack——1981-12-13null•••-••-5351(270) 295-2794··jack.contreras@proton.me3703 Pine DriveAtlantaGeorgia30314···UNKNOWNNULL
TPATPA-566412026-05-18T16:53:06Z ELIZABETHNRAY08/26/1992--NULL-3693 Main StreetScottsdaleAZ85288—UNKNOWN··
TPA TPA-599472026-08-23T11:34:25ZJUAN··BANKS1967-11-12——null·-9425 MESA DRFresnoCalifornia93762GRP-6782N/A
TPATPA-569962026-07-06T23:24:51Z·Christine—·HarveyMar 9, 1997—•••-••-0673379.326.1896N/A141 Apache BoulevardTUCSONAZ·85753GRP-2866UNKNOWN··
TPATPA-577082026-03-19T14:43:24ZSHAW—BRANDON1960-11-07—····6321396brandon.shaw@proton.me7007 Oak StreetDenverCO80237nullnull
TPATPA-614062026-05-30T07:07:38ZDiego—Snyder1944-01-08—•••-••-0148398.934.1877N/A2917 Washington StSEATTLEWA98101-6282N/ANULL
TPATPA-616152026-03-24T03:44:13ZHerrera, MarcX—1956-12-27—•••-••-8298NULL-··9213 Cedar LnDenverCO80209GRP-5131MEDICARE-ADV-B
TPATPA-625842026-08-22T01:08:55ZTERESA—ROBERTS1968-09-01-•••-••-7686-—1856 Sage CtSacramentoCA—GRP-1662OPTIONS-PPO
TPATPA-567762026-04-16T17:01:48Zjesse—schultz·1973-12-12UNKNOWNUNKNOWN··—-1059 SAGE CTSan AntonioTX78274—N/A
TPATPA-606882026-02-07T13:15:17ZWALTER—CARTER1998-01-14UNKNOWN··•••-••-81583804759540—6131 LINCOLN WAYPhoenixAZ·85076GRP-5103—
TPATPA-521522026-04-04T11:39:49ZVincent—·Howard1993-07-20—nullNULL—1898 Meadow LnFresnoCA93715nullNAVIGATE-HMO
TPATPA-573762026-07-30T00:26:55ZHudson, Amber——1994-05-20-NULL—amber.hudson42@gmail.com---——N/A
TPATPA-579662026-07-24T20:34:34ZJennifer—Santos1944-02-16—•••-••-9889N/AUNKNOWN4465 Hillcrest RoadSeattlewa98130-8522NULLSELECT-EPO
TPATPA-621082026-01-22T11:55:35ZWilliam—Coleman1969-02-20UNKNOWNnull531.786.7752william.coleman@aol.com8040 Baseline RdHoustonTX77056GRP-8923OPTIONS-PPO
TPATPA-559952026-10-03T16:41:37ZFox, SantiagoH.—1950-11-04UNKNOWNUNKNOWN———UNKNOWNUNKNOWN—·N/Anull
TPA TPA-517092026-04-27T10:19:23Zbobby—cooper·1998-12-01N/A··•••-••-8190488.283.1996—379 CHURCH STREET··ChandlerArizona85278·GRP-2736NULL
TPATPA-512052026-03-23T04:24:59ZJack—Reed1963-04-03N/A-UNKNOWNnull9195 River Rd #142··CharlotteNC28255GRP-3456UNKNOWN
TPATPA-50072 2026-05-17T12:09:47ZSean—Cook1984-03-16NULLUNKNOWN335-270-3469sean.cook@outlook.com9409 Valley View Drive·JacksonvilleFL32210GRP-4499CORE-HMO
TPATPA-513442026-08-17T13:05:22ZMARGARET—JAMES1943-09-04·null—-·margaret.james@proton.me831 GRAND AVENUE #328TempeAZ85240--
TPATPA-643812026-08-26T15:39:35Zjoyce—carter1958-01-15—•••-••-3648·····N/A6250 Maple AvenueSan DiegoCA92130··CHOICE-PLUS-PPO
TPATPA-509092026-05-02T03:21:16ZThomas—Morales1965-01-26UHC-74441-71UNKNOWN7658409003—5241 JEFFERSON AVENUEDenverCO80274GRP-0617··
TPATPA-504922026-03-31T21:27:20Z———05/09/2001UHC-12085-61NULL·UNKNOWN-5526 Central AveLOS ANGELESCA90072null—
TPATPA-613742026-06-25T22:45:13ZJOAN—SOTO1981-05-17nullnull—joan.soto20@gmail.com1004 Apache Boulevard Apt 14Los AngelesCA90000—MEDICARE-ADV-B··
TPATPA-52066 2026-01-14T15:55:37ZJOSHUA··—BROWN1993-10-09——(320) 712-1797N/Anull—····-NULLUNKNOWN
TPATPA-541042026-10-07T23:41:25ZTimothy—·PerezJan 24, 1940NULL—-timothy.perez36@gmail.com3824 Oak StreetMiamiFL33197—select-epo
TPATPA-631412026-03-19T20:44:01ZBETTYM··BURKE··08-02-1966NULLnullN/AN/A·4250 Mountain View DrivePHOENIXAZ85086—NAVIGATE-HMO
14,474 rows, page 158 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:49.125Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty