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-523282026-02-11T02:27:40ZHill, Diana——1999-04-05NULL·--···DIANA.HILL@PROTON.ME3644 Sunset BlvdAtlantaga30364-N/A
TPATPA-596622026-08-29T20:40:08ZAlice—Fisher01/16/71—null——null··—-UNKNOWN—OPTIONS-PPO
TPATPA-523232026-09-12T06:12:16ZSimmons, Raymond——1972-02-03UNKNOWN-(570) 404-7418-5242 Desert Sky BlvdNASHVILLE·Tennessee37204GRP-3841NULL
TPATPA-554362026-05-14T14:15:46ZKATHERINE—CARTER1963-12-21UHC-19218-47··•••-••-0208—-9532 Maple Ave·GILBERTaz85273——
TPATPA-608782026-06-21T02:33:41ZGABRIEL··—ROBERTSON10/12/82UNKNOWN•••-••-0845N/A—788 SAGE CTGilbertArizona85260-8473GRP-9823UNKNOWN··
TPATPA-528342026-04-10T02:36:37ZcathreineW.··nguyen09/22/98UNKNOWN—19423799253··4832 Main StreetSan AntonioTX78265——
TPATPA-586582026-05-18T10:42:17ZMunoz, Mei——1964-12-03UNKNOWN··-nullN/A··8580 Lake View RdTucsonAZ85716-SELECT-EPO
TPATPA-577262026-08-14T06:37:51Z·BOBBYTMENDEZ11/4/1987—··——5296 CENTRAL AVEAtlantaGA·30343null—
TPATPA-569112026-05-14T18:25:27ZJOSE—·JAMES26-09-1982-•••-••-2901-NULL—··nullNULLGRP-4797NULL
TPATPA-622312026-02-18T02:28:27ZWayne—Fernandez12/03/41NULL——N/A6873 CANYON ROADJacksonvilleFlorida32269—null
TPATPA-57650 2026-07-31T02:22:48ZMichaelRFlores2000-05-13N/A——-7802 Oak StCHARLOTTENC28271··—
TPATPA-555732026-07-19T17:04:30Z·Kimberly—Rooberts1944-04-27··—N/A6697220304-5474 INDIAN SCHOOL ROADAtlantaGA30369nullMEDICARE-ADV-B
TPATPA-593912026-07-15T13:43:49ZLogan—MyersAug 28, 1966nullnull(282) 781-9193NULL663 Bayshore DrChandlerArizona·85254UNKNOWN—
TPATPA-538892026-05-11T05:08:38ZJUANQPOWELL1975-01-22—····(451) 771-2270—N/A—-N/AGRP-7466null··
TPATPA-514902026-06-05T23:40:41ZCarlos—Hanson1971-09-03NULL•••-••-5447-carlos.hanson@icloud.com4864 INDIAN SCHOOL RDHoustonTX77037nullCORE-HMO
TPATPA-592682026-10-05T01:05:36ZRebecca—Carlson6/12/1983UHC-32126-56—UNKNOWNN/A3457 Bayshore DriveCHANDLERAZ85242-NULL
TPATPA-624742026-10-18T14:59:03ZMurray, Abby——1972-02-02UNKNOWNN/A549-756-6064abigail.murray@gmail.com3973 Union StreetJacksonvilleFL··32200GRP-2268—
TPATPA-644642026-02-06T01:13:57Zjennifer—cunningham1940-02-25UNKNOWN——-———N/Anull—
TPATPA-629852026-08-03T00:03:58ZBrandon—DavisJan 6, 1984UHC-42245-62UNKNOWN—UNKNOWN1491 Jefferson AvenueGlendaleAZ85371-1058UNKNOWN—
TPATPA-535202026-07-29T22:52:15ZRichard—Herrera1984-08-28—•••-••-4560—nullnullNULL-N/ANULLOPTIONS-PPO
TPATPA-550772026-09-06T00:14:46ZVirginia—Harvey2008-05-20·N/AUNKNOWN18587676921virginia.harvey63@icloud.com7773 MAIN STREETDALLASTX—-options-ppo
TPATPA-555502026-07-09T02:46:04ZAUSTIN—DEAN···06/23/70··nullUNKNOWN-4643 Church St #208SAN DIEGOCalifornia92176—OPTIONS-PPO··
TPATPA-589172026-07-16T09:38:46Z Adams, Sarah—····06/09/2006····--2699 Canyon RdFresnoCalifornia93784—-
TPATPA-580822026-06-30T06:45:52ZCAMILA—RAMOS05/01/52null•••-••-2396315.681.5432camila.ramos@hotmail.com8909 MARKET STREET··CharlotteNC28213NULL—
TPA TPA-575602026-08-26T23:12:01ZJesse—Dean1985-05-24—--UNKNOWN8179 Ridge RdChandlerAZ85206-0461——
TPATPA-636762026-04-11T10:57:27Z BRANDONH··FIELDS1969-09-11UHC-95171-29N/ANULLUNKNOWN2541 WILLOW CTDENVERCO80298UNKNOWNSELECT-EPO
TPATPA-61954 2026-09-26T21:48:52Z·Watson—Brittany1971-04-25N/A··•••-••-0431UNKNOWN—3073 Market StSACRAMENTOCA95874—OPTIONS-PPO··
TPATPA-590802026-08-26T03:18:55ZKAYLA—WATKINS2001-03-07N/A•••-••-562915038641126——UNKNOWN—-NULL—
TPATPA-604212026-08-08T03:00:09ZSantiago—Pice1978-05-09UNKNOWN—UNKNOWNSANTIAGO.PRICE@ICLOUD.COM·8949 Mesa DriveHoustonTX··77059N/A··—
TPA TPA-578222026-08-09T03:49:04ZJoseph··Wheeler1991-05-12—N/A—N/A3173 Willow CtSacramentoCalifornia95892GRP-3811UNKNOWN
TPATPA-532912026-10-15T03:46:13Z·EVELYN—LOPEZ04/27/1979UHC-68398-21null6677275853null8221 Meadow LnEden PrairieMN55347—N/A
TPATPA-550782026-09-06T00:14:46ZVirginia—Harvey2008-05-20·N/AUNKNOWN18587676921virginia.harvey63@icloud.com7773 MAIN STREETDALLASTX—-options-ppo
TPATPA-524932026-07-07T23:09:43ZJAMES····RIVERA1959-08-11NULL•••-••-4727N/AJAMES.RIVERA96@ICLOUD.COM1090 Spring StGlendaleAZ85375nullN/A
TPATPA-597972026-09-21T03:43:50ZValentina—Ramos·2004-07-21—NULL·(312) 269-6515VALENTINA.RAMOS@GMAIL.COM8972 Oak StreetFresnoCA93750—SELECT-EPO
TPATPA-536602026-04-26T02:11:34ZGary—West1998-01-17UNKNOWN·NULLN/Anull··6358 Ocean AvenueColumbusOH43278NULL—
TPA TPA-513422026-06-16T16:09:46ZRyan—Rios09/13/1988null··NULL(833) 546-0505-635 Union Street·TUCSONAZ85798nullOPTIONS-PPO
TPATPA-605992026-04-15T21:49:00ZLAURA··—NUNEZ1969-01-27··—+1 858 473 2755N/A3323 Harbor BoulevardFresnoCA93704GRP-0760CHOICE-PLUS-PPO
TPATPA-622132026-03-09T10:45:15Z TylerZSanders1994-01-19-•••-••-0918(649) 724-4073null1664 Forest AvenueMinneapolisMinnesota55456·nullCORE-HMO
TPATPA-604392026-03-21T10:05:53ZWillie—Griffin05/18/1973NULL—5478550900·null458 Sage Court·PhoenixArizona·85056N/ACORE-HMO
TPATPA-543912026-05-07T18:40:25ZAMBER··EHAMILTON09/16/1974-—·-—NULL—UNKNOWN·-GRP-6839—
TPATPA-551022026-08-10T11:56:56ZMaria··—Snyder27-05-1966--··+1 844 878 0896··NULL5805 Mountain View DriveDenverCO—UNKNOWN—
TPATPA-523392026-01-10T13:06:54ZDick—Jimenez1941-09-12—•••-••-6550NULLN/A792 Desert Sky BoulevardSacramentoCA95859GRP-2488N/A
TPA TPA-531692026-06-06T16:56:51ZPAMELA—LONG1972-04-14UNKNOWN—null—4895 Pine DrAtlantaGA30312nullnull
TPATPA-550242026-10-08T05:05:05ZDavid—Vega··10/25/2004nullNULL(774) 212-2321UNKNOWN8748 Grand AvenueMinneapolis··MN··55459-2208-NULL
TPATPA-506282026-10-08T18:26:37ZJanice—Rice1938-12-26—null··+1 267 396 2817N/A8888 PALM DRIVE Apt 4TucsonAZ85748——
TPATPA-589762026-04-19T05:50:58ZJOSE—GIBSON1990-06-22—N/A(379) 999-1748JOSE.GIBSON@GMAIL.COM253 Oak StreetSan DiegoCA92194GRP-0373UNKNOWN
TPATPA-578392026-02-06T04:14:27ZCarlos—Gibson1939-07-05-UNKNOWN——8326 Cedar LnTucsonAZ85772GRP-5464—
TPA TPA-609032026-01-24T13:05:24Zgabriel—phillips1980-01-03UHC-86029-01····NULLNULL5932 Sage CtSan AntonioTX78299NULLNAVIGATE-HMO
TPATPA-533332026-07-17T00:10:15ZWILLIE—ROBINSON4/1/1992NULL•••-••-8140·5023689952—UNKNOWN—-N/AGRP-7967—
TPATPA-505892026-02-05T23:36:32Z ·Vincent—RobertsMay 22, 1986UHC-46711-68-(414) 629-8403UNKNOWN4910 Mountain View DriveSacramento··California95852——
14,474 rows, page 215 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:56.153Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty