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-598622026-10-03T14:38:30ZedwardZsims02/01/93··N/AUNKNOWN··—1338 Hillcrest RdHoustontx77051-7127null—
TPATPA-581982026-10-08T04:33:36ZKelly—Bishop1958-01-12UNKNOWN•••-••-1448—UNKNOWN3102 Highland AveChandlerArizona85249-4442-null
TPA TPA-513472026-07-07T14:40:44ZNoah—Wilson··1942-07-12NULL•••-••-84484819840815—1183 Spring StreetNASHVILLETN37275——
TPATPA-618812026-05-20T01:51:06Z Gregory—LawsonDec 27, 1948—UNKNOWNUNKNOWNgregory.lawson@yahoo.com2487 JEFFERSON AVENUEPhoenixArizona85023null—
TPATPA-511312026-05-27T20:07:04Zcarl—rivera1970-04-01UHC-56976-80•••-••-7387—carl.rivera@outlook.com2998 Canyon Rd #815CHARLOTTENorth Carolina··28212UNKNOWN—
TPATPA-638102026-07-01T19:33:20Z Justin—Porter2007-06-14NULLN/AUNKNOWN—8304 Jefferson Ave··LOS ANGELESCA90014—MEDICARE-ADV-B
TPATPA-513492026-07-28T02:29:29ZEdward—King1959-11-13UHC-04608-19N/A(648) 570-5403edward.king92@gmail.com183 Grand AveSACRAMENTOCA95860UNKNOWNNAVIGATE-HMO
TPATPA-541612026-05-21T01:11:01ZAndrew—Bennett1959-07-03null—3412037316andrew.bennett6@hotmail.com————-UNKNOWN
TPATPA-528842026-06-10T21:54:29ZJAMES—GORDON1988-04-11uhc-45160-16•••-••-4126NULL—9822 Highland AvenueTEMPEArizona85243NULL-
TPATPA-563352026-02-06T08:04:07ZBECKYBLEWIS1967-03-26UNKNOWN··•••-••-8923—UNKNOWN6545 Maple AveNashvilleTN37215GRP-3385null
TPATPA-562682026-01-24T12:18:15ZJessica····Pena1967-12-17··—•••-••-1731N/A······6112 Washington StFresnoCA··93746UNKNOWN··CORE-HMO
TPATPA-503882026-02-13T21:36:29ZAlexis—Carlson1947-08-07-—(538) 414-6927alexis.carlson63@yahoo.com9327 Camelback Rd·Eden PrairieMN55328··nullNULL
TPATPA-521542026-09-28T23:17:44ZJASON—DELGADO1978-09-17-null500-498-4982NULL3835 Spring Street··JacksonvilleFL32294null—
TPATPA-604472026-06-10T16:06:51ZMunoz, Brenda——1979-05-11-··—3998985380—6309 PARK PL·SAN ANTONIO·TXN/AUNKNOWNN/A
TPATPA-587032026-06-14T19:47:23ZHarold—Peterson2004-06-22UNKNOWN··—null7323 Harbor BlvdLas VegasNV89191-2029GRP-5851N/A
TPATPA-586532026-01-31T07:40:22ZRay, Debra——16-06-1970—•••-••-6002—null9349 Meadow LaneSan DiegoCA··92106-6321NULLUNKNOWN
TPATPA-520192026-10-04T03:01:42ZGeorge··Kim06/06/1946··null•••-••-6832UNKNOWNGEORGE.KIM@YAHOO.COM4350 Church StDenverCO··80236N/A-
TPATPA-509962026-08-22T05:17:09ZFRANCES—PORTERJan 13, 1949·UHC-23993-16·NULL——-nullN/AN/AGRP-5620NULL
TPATPA-510812026-02-08T19:18:06ZLarry—Powell19470803UNKNOWN··null—1524 SAGE COURTColumbusOH43236——
TPATPA-503352026-08-14T19:52:35Z Ana—Ward—-———5148 BROADWAY·AustinTX78724-SELECT-EPO
TPATPA-547482026-05-18T14:12:01ZSamuel—Marshall2008-01-11UNKNOWN•••-••-6394—N/A185 UNION STColumbusOH43242—UNKNOWN
TPATPA-599452026-05-08T09:01:27Z WILLIAM··—MILLER1998-08-23—NULL406.291.1484-UNKNOWNNULL——··UNKNOWN
TPATPA-587462026-04-03T15:42:48ZSantiago—OBrien08/09/1991NULLnullN/ANULL9425 Maple AvenueSCOTTSDALEAZ85237GRP-4414CORE-HMO
TPATPA-577462026-05-20T11:53:30Z·DENISE—RIVERA1984-07-19-—·-UNKNOWN8656 Ocean AveDenverCO80297-6980—CORE-HMO
TPATPA-589612026-02-18T21:54:37ZBrooks, Paul——1952-12-01null—NULLnull5911 Lake View RdTUCSONArizona85762GRP-4922UNKNOWN
TPATPA-503712026-07-06T07:00:18ZLauraASullivan11/11/74—•••-••-6333656-717-9083—1021 HIGHLAND AVENUEAtlantaGeorgia30378··—UNKNOWN
TPATPA-573062026-02-15T01:01:18ZNOAH—TURNER03/28/1949UNKNOWN-·UNKNOWN—441 Palm DrChandlerAZ85287·UNKNOWN····
TPATPA-625072026-06-18T05:05:38Zaliice··—collins1986-05-23UHC4064326UNKNOWNNULL-··2282 Jefferson AvenueSan AntonioTX78219—MEDICARE-ADV-B
TPATPA-509402026-03-31T07:14:40ZKIMBERLYQ.·MORRIS-UHC-70976-57··-+1 508 729 9329UNKNOWN3790 River RoadTucsonAZ85792UNKNOWNUNKNOWN
TPATPA-561602026-09-02T01:43:01ZMariana—Wbeb1981-01-23—UNKNOWN3263601603—4877 Mountain View Dr·SeattleWA98119N/A··NULL
TPATPA-523212026-10-09T23:05:31Zkathryn—garkia1978-03-16UHC-36279-13UNKNOWNnull·UNKNOWN6454 Indian School RdColumbusOH—·null··
TPATPA-540582026-05-26T17:02:51ZrussellD.bryant··1960-11-27—N/AN/Arussell.bryant@icloud.com2305 Willow CourtChandlerAZ85202··-
TPATPA-632802026-01-12T13:30:09ZAndrea—Lee1994-12-25-•••-••-03005646999730-7227 Jefferson AveSan Diegoca92103NULLnull
TPATPA-596862026-08-07T05:06:49ZSnyder, Alexander·E····1992-07-21null··——alexander.snyder@outlook.com9767 Union StATLANTAGA30313GRP-1626null
TPATPA-628242026-03-30T05:53:59ZVicky—Flores··1982-11-16N/A•••-••-8680(252) 494-2716null3576 Harbor BlvdLas Vegas·NV89182—·N/A
TPATPA-526042026-06-30T04:55:54Z Singh, Emily··—1991-07-23UHC-65155-15•••-••-9508NULL—·4040 JEFFERSON AVENUEColumbusOH43230N/Acore-hmo
TPATPA-627782026-06-15T04:22:02ZEmma··M.Rodriguez19771028UNKNOWNN/Anullnull8610 Church StreetTempeAZ85221-3192··——
TPATPA-546072026-05-31T09:32:39ZSamuel—Martinez1964-04-01NULL•••-••-6049-samuel.martinez@yahoo.com6530 Cedar Ln··GlendaleAZ85303nullSELECT-EPO
TPATPA-630142026-05-28T17:39:14Zjack—smith1974-06-11———-742 BAYSHORE DRIVE·Las VegasNVUNKNOWNnullNULL
TPATPA-547452026-07-02T18:25:59ZJustin—Estrada1999-10-01·nullUNKNOWN··NULLUNKNOWN6120 Maple Ave #470JacksonvilleFL32262—N/A
TPATPA-616602026-02-01T11:55:57ZALAN·····PRICEOct 17, 1973-•••-••-0761——1978 Cedar LnScottsdaleAZUNKNOWN··—
TPATPA-554822026-02-17T22:59:28ZElizabeth—Shaw1951-01-16—N/A3456900956N/A4539 Oak StreetGilbertAZ85281-0711——
TPATPA-569132026-08-17T12:05:04Z Black, Noah——1999-05-15null—4604694—9551 Baseline RoadSCOTTSDALEaz85239UNKNOWN-
TPATPA-501512026-03-15T14:10:37ZERIC—SIMS1947-06-04N/AUNKNOWN(253) 577-2240—4759 Oak StreetTAMPAFL33682NULL-
TPA TPA-642552026-08-24T21:00:06ZKenneth—Simmons26-06-1960UHC-43798-01—+1 386 507 4812UNKNOWN—N/AN/AN/AGRP-2375—
TPATPA-601042026-03-07T07:58:12ZBETTYGGOMEZ1977-06-09-UNKNOWNnull-————GRP-5576NULL··
TPA TPA-561272026-04-07T08:27:25Z·PriyaOGonzales1946-02-20—null6446722901-8243 Hillcrest RoadNashvilleTN37281——
TPATPA-562312026-07-25T15:07:39Z Michelle··Woong1995-11-14UNKNOWN•••-••-7861null-9654 Central Avenue··CHANDLERaz85215··NULL—
TPATPA-543562026-01-31T11:58:31ZPeter—Wong·1965-05-19UNKNOWNUNKNOWN(379) 865-7689—1640 Ocean AvenueSEATTLEWA98130—NULL
TPATPA-516812026-07-10T05:12:34ZAndrea—Brown1977-01-22—UNKNOWN-·NULL2828 Desert Sky BoulevardSAN DIEGOCalifornia··92105GRP-7520null
14,474 rows, page 51 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:38.475Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty