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-560372026-08-26T04:14:27ZMARCUS—BURKE1950-03-16-—18654517550··———UNKNOWNnullGRP-6574NULL
TPATPA-590172026-03-10T15:41:22ZSOPHIA—LE2000-04-12nullN/A·N/ANULL3641 FOREST AVENUEDallasTX75221—NAVIGATE-HMO
TPATPA-545312026-01-21T10:14:30Z·EdwardOPeterson1969-01-12UHC-42460-12·-9752701716edward.peterson38@yahoo.com4454 Harbor BoulevardHOUSTONTX·77072N/ASELECT-EPO
TPATPA-578192026-06-27T21:44:38ZADAM····REYES··2000-06-15———adam.reyes@icloud.com4390 CHURCH ST··MinneapolisMNNULL—UNKNOWN
TPATPA-595552026-09-02T22:28:30ZGrace—Bishop19831215null•••-••-4916—null3120 Cedar LaneMinneapolisMN55450-5787——
TPATPA-602062026-04-15T20:53:46ZPhilipJ.MorrisonMar 5, 1945N/A•••-••-8450-—4733 Meadow LaneLas VegasNV89102-2293GRP-6919·UNKNOWN
TPATPA-623582026-04-25T05:04:22ZABIGAIL—RIOS1979-05-26-NULL-abigail.rios62@outlook.com5815 BAYSHORE DRSan AntonioTX··NULL—SELECT-EPO··
TPATPA-591212026-05-21T12:38:02Z·Jacobs, Edward——1954-03-15-•••-••-0797——·UNKNOWN—nullN/AGRP-8751null
TPATPA-559322026-08-21T01:56:59Z cynthia—sandoval·2002-04-06-•••-••-4776—UNKNOWN9753 Lake View Road··AustinTX·78787—··
TPATPA-517352026-03-06T21:15:52ZcarlXpowell27-04-1984NULLN/ANULLcarl.powell17@outlook.com1327 Lincoln WayFresnoCA93762-—
TPATPA-561362026-01-24T12:13:32ZWILLIAM—THOMES1963-02-12NULLNULLnull··—6444 Ridge Road #541ScottsdaleAZ85280—-
TPATPA-586432026-07-06T06:21:00ZDennis··Bowman2001-08-12UHC-53395-80N/A··8766362245dennis.bowman@outlook.com4292 MARKET STREET Apt 8CHARLOTTENorth Carolina28258—N/A
TPATPA-537322026-10-03T08:15:30Z Patel, Stephen——1961-07-20—•••-••-1402—null8076 HIGHLAND AVE··ColumbusOH43290-3066—CHOICE-PLUS-PPO
TPATPA-599732026-09-08T23:35:32ZHoffman, LuisS.—·1975-12-13UHC-08461-37-NULLnull1769 MAIN STREETNashvilleTN37258GRP-1266CORE-HMO
TPATPA-614792026-09-27T20:29:20Zarjun—fernandez19500422-—··null3885 PARK PLACEMINNEAPOLISmn55436—UNKNOWN
TPATPA-590692026-03-05T02:17:24ZDaniels, Elizabeth——1976-05-23NULLNULLnull-605 LINCOLN WAYAustinTX78751··SELECT-EPO
TPATPA-545202026-02-23T13:14:31ZEvelyn—McDonald1960-11-01UHC6231926——UNKNOWN1973 Sage CourtChandlerAZ85242null·UNKNOWN
TPATPA-549092026-06-08T13:05:28ZAlan—Hoffman1983-06-23UHC-11329-12N/A··alan.hoffman81@gmail.com·3527 BAYSHORE DR Apt 5Fresno··CA93778NULLUNKNOWN
TPATPA-553262026-09-07T18:59:52ZKIMBERLY—CARTER1953-02-19——·6129542047NULLUNKNOWN—null—UNKNOWNNULL
TPATPA-502232026-08-29T22:26:30Zisabella—harrisun1986-09-12NULLnull·(933) 341-2719UNKNOWN——-——NULL
TPATPA-594422026-08-29T01:09:00ZJun—Kelly1946-10-24—•••-••-2604—NULL2386 Central Avenue Apt 34··PHOENIXAZ85057GRP-7143MEDICARE-ADV-A
TPATPA-563642026-03-18T08:17:21Z ·Patterson, LindaN—9151-10-26··--UNKNOWN—9882 Oak StreetSAN ANTONIOTX78260GRP-6759UNKNOWN
TPATPA-62132 2026-09-08T06:56:41ZJACK—DANIESDec 8, 1952NULL—676-478-4172JACK.DANIELS@PROTON.ME6951 Church StATLANTAGA30313-9276GRP-9298UNKNOWN
TPATPA-582652026-08-22T00:33:50ZDanniel—Chavez1944-07-20UHC-08743-28—5519881782—·629 Maple AvenueLos Angelesca90080-UNKNOWN
TPATPA-594472026-05-17T22:45:53ZRALPH··ARMSTRONG1981-07-21NULL—UNKNOWNNULL8223 Pine Drive··Los AngelesCA90077GRP-3916—
TPA TPA-523662026-05-07T19:02:08ZAndrew—Burke19890128·null•••-••-3451(371) 894-1853·andrew.burke88@yahoo.com7038 Bayshore Drive·Austin·TX78708N/AMEDICARE-ADV-A
TPATPA-641252026-02-13T02:20:44ZJose—CarpenterApr 7, 1943UNKNOWNNULL······4048 Willow CourtPlanoTX···75049-9704UNKNOWNMEDICARE-ADV-B
TPATPA-620812026-04-22T15:48:18ZMary—Carroll··2002-08-18—•••-••-0257—-2762 Maple Avenue·OrlandoFL32886GRP-8626NULL
TPATPA-625082026-05-17T09:13:44ZMjia, Isabella——1963-12-17—•••-••-2519—-··9832 Washington StreetPhoenixAZ85075·NULLnull
TPATPA-507832026-07-28T18:54:18ZHIROSHI—COLEMAN1985-04-06UHC-24824-94NULL5788361392N/A3352 CENTRAL AVENUESAN ANTONIOTexas··78242GRP-4840—
TPATPA-540142026-03-19T14:29:03ZFRANCEST.SIMPSON2006-12-03—•••-••-17523447894435—4657 Forest AvenuePlanoTX75084NULL—
TPATPA-641962026-01-26T21:15:02ZROGER····WANG1950-02-04—N/A5287310709NULL5745 Jefferson AvenueCharlotteNorth Carolina28271nullMEDICARE-ADV-A
TPATPA-584202026-04-04T00:13:32ZCOLLINS—JECOB·19750804—NULLnull—NULL-N/Anull——
TPATPA-587862026-06-24T05:51:59Z·Morrison, Kimberly····—1991-05-06UHC-31666-52—911.229.2031—6635 PALM DRIVEGilbertaz85239··NULLoptions-ppo
TPATPA-635922026-01-19T06:30:01ZRichard—Rodriguez19461214··•••-••-7256N/A—9317 BAYSHORE DRIVEChandlerAZ85233GRP-1371-
TPATPA-625352026-03-10T04:26:38Z Yagn, Daniel——1950-03-26—UNKNOWN—daniel.yang@hotmail.com8826 VALLEY VIEW DRTucson·AZ85735NULLCHOICE-PLUS-PPO
TPATPA-608442026-03-31T11:32:19Z Stone, CarolB.—Sep 17, 1953UHC-11495-79UNKNOWN(604) 287-5545null1957 Lake View RoadLos AngelesCA90011——
TPATPA-547472026-02-13T13:15:34ZSamuel—Marshall2008-01-11-UNKNOWN910-702-5386NULL185 Union StreetCOLUMBUSOH··43242··GRP-1951···-
TPA TPA-548932026-10-05T20:58:19ZPatrick—Alexander1969-08-09—UNKNOWNN/A·PATRICK.ALEXANDER@YAHOO.COM1326 RIVER RDAustinTX78721-4126·nulloptions-ppo
TPATPA-632922026-09-01T02:54:10Zjonathan—parkerNov 23, 1980UHC-32181-76N/A-NULL9061 Pine Dr··OrlandoFlorida32891-NAVIGATE-HMO
TPATPA-560862026-06-08T01:05:43ZCarlN.Cooper11/02/1961UNKNOWN•••-••-0317N/A—7817 Maple AvenueDenverCO80294N/A—
TPATPA-609862026-10-14T00:14:07Z Diane—George1953-11-21—•••-••-4785+1 355 848 9536diane.george@aol.com900 River RoadScottsdaleAZ85239····—
TPATPA-502972026-01-29T06:17:03ZCHRIISTINE—COOK··1958-02-12··—-UNKNOWN—2663 Union StColumbusOH43298null-
TPATPA-511022026-01-24T05:27:43ZLAWRENCE—LONG1978-02-09UHC-47581-55——lawrence.long40@outlook.com2494 Palm Drive··Denver··CO80253NULLUNKNOWN
TPATPA-63588 2026-08-11T06:35:51ZMARI··SCHMIDT1957-04-28—null··NULL8387 Willow CtCOLUMBUS·OH43200GRP-0549—
TPATPA-601562026-06-20T04:07:09ZRAYMOND—COLLINS1971-03-26null-——6254 FOREST AVESEATTLEWA98140GRP-7630MEDICARE-ADV-A
TPATPA-598932026-06-09T01:00:16Zhelen—williams1978-04-25null—381-427-1921null1803 Bayshore DriveSan AntonioTX78208GRP-6565—
TPATPA-559572026-05-14T22:21:14Zjesse—pierce1947-07-27—UNKNOWN(914) 422-8848null———-GRP-0244·null
TPATPA-506422026-06-18T06:30:11ZROGERAORTIZ02/12/1945N/A··—N/A—·7876 FOREST AVENUE #812Orlandofl32897GRP-3536—
TPATPA-533842026-09-23T21:24:41ZEmma—Sims19631128···nullUNKNOWNUNKNOWNnull7059 Sage CtGilbertAZ85222-0290NULLNULL
14,474 rows, page 269 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:43:03.422Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty