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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4217302026-08-03T12:24:27ZKENNETH—GORDON1988-08-27UHC-87982-02——-9879 Union Street #283Atlanta··GA30361GRP-0773—
TPATPA-566702026-05-30T08:28:28ZAndrea—Murphy1945-01-11-NULL+1 536 665 4368NULL5040 Highland AveDenverCO80204NULLNULL
CLMCLM-4158722026-05-25T02:45:20ZJudyBWilliams1997-09-06UHC-14307-75•••-••-80454322595626—1930 Apache BlvdTampaFL·33683GRP-5942MEDICARE-ADV-A
ENRENR-1338782026-08-22T03:07:32ZStewart, LindaI—1976-03-11··UHC-40910-55•••-••-8886285-993-8775linda.stewart@icloud.com3321 Valley View DrMinneapolisMN55411GRP-5544CORE-HMO
ENRENR-1269282026-07-27T13:37:49ZJanet—Mendoza11/26/98UHC-13188-27•••-••-6873448-365-1439janet.mendoza@gmail.com5780 Mountain View DrSAN DIEGOCA92101··GRP-5796CORE-HMO
ENRENR-1121372026-09-07T06:57:27ZJacob—Ward1989-03-20UHC-58162-21•••-••-1006941-500-2414JACOB.WARD@AOL.COM·8456 Mountain View DrCharlotteNC28266-2413GRP-8684CHOICE-PLUS-PPO
PRVPRV-275422026-02-11T23:38:29ZAndreaS.McDonald19640703UNKNOWN····-andrea.mcdonald89@icloud.com323 MOUNTAIN VIEW DR #552COLUMBUS·OH43281—SELECT-EPO
ENRENR-1244212026-04-02T04:50:45ZPowell, Russell——22-10-1939UHC-73379-98•••-••-5979nullrussell.powell93@outlook.com8283 WILLOW COURTFresnoCA—GRP-1282CORE-HMO
ENRENR-1143272026-02-24T20:21:26ZChristine—Evans2001-12-17UHC-01717-89•••-••-8588+1 358 684 2432CHRISTINE.EVANS56@AOL.COM··1279 Baseline RoadSacramentoCA-GRP-6493CHOICE-PLUS-PPO
TPATPA-633672026-05-03T15:00:21ZSantiago—Aguilar··1979-04-18-——-··4797 Indian School RdCharlotteNCnullGRP-0753null
ENRENR-1349312026-10-18T08:20:47Z Barbara—Cooper1993-09-17UHC-62320-38•••-••-76564927428526barbara.cooper4@hotmail.com1440 FOREST AVENUE Apt 5TEMPEAZ85245GRP-1660MEDICARE-ADV-A
CLMCLM-4299172026-01-28T10:15:59Z Melissa—Soto1979-06-25UHC-47899-58•••-••-9251—NULL4356 Jefferson AvenueFresnoCalifornia93723—select-epo
ENRENR-1270982026-10-12T23:18:46ZEvelynHMorrison1986-09-13UHC-65148-82•••-••-5114·2464249747N/A1846 Maple AvenueTampaFL33635GRP-9678··CORE-HMO
ENRENR-1245372026-02-04T20:23:30ZCynthiaDPerkins1954-01-11UHC-57488-40··•••-••-3320+1 788 288 5535cynthia.perkins6@gmail.com3711 MOUNTAIN VIEW DRPlanoTX75017GRP-6727CHOICE-PLUS-PPO
TPATPA-588482026-09-23T00:26:22ZRobertsWHenry04/05/47UNKNOWN——HENRY.ROBERTS73@YAHOO.COM709 Camelback RoadPhoenixAZ85059GRP-1938··NAVIGATE-HMO
TPATPA-613822026-05-14T04:51:14ZEugene—Freeman1961-12-23—UNKNOWN8543837439-5162 LINCOLN WAYScottsdaleAZ85251GRP-8670MEDICARE-ADV-B
ENR ENR-1114522026-04-18T11:24:50ZAlvarez, Jcob·Y—1972-05-12UHC-93064-17•••-••-6109218-930-3366null6151 Union StAtlantaga30358GRP-0998SELECT-EPO
ENRENR-1378352026-04-30T11:16:32ZTorres, CamilaB—02/23/1939UHC-74623-75•••-••-9117884-213-6430CAMILA.TORRES@GMAIL.COM·4911 Cedar LaneScottsdaleAZ85278GRP-8289MEDICARE-ADV-B
CLMCLM-4222152026-06-06T23:10:07ZYUKI—SMITHFeb 28, 1995N/A•••-••-5034nullUNKNOWN8941 HIGHLAND AVENUEPhoenixAZ85056-0508—N/A
CLMCLM-4113492026-05-03T01:31:33ZAlexander—Ray1996-05-06-····—-5159 Ridge RoadTAMPAFlorida33639UNKNOWNCHOICE-PLUS-PPO
ENRENR-1270942026-04-04T05:02:52ZKIMBERLYWGREEN1987-03-15UHC-58924-41•••-••-9278908-678-2047kimberly.green27@hotmail.com784 Harbor BoulevardGlendaleAZ85368GRP-8320MEDICARE-ADV-A
ENRENR-1122312026-01-24T16:47:40ZJOHNSTONB.SCOTTJun 1, 1991UHC-09585-03NULL··—scott.johnston@icloud.com8261 Pine DrSan DiegoCA92181-7284GRP-2116MEDICARE-ADV-A
CLMCLM-4280282026-06-21T09:32:00ZBENJAMIN—SIMMONS6/14/1971N/A—····benjamin.simmons38@proton.me·8450 Camelback RdGilbertAZ85224GRP-5586MEDICARE-ADV-A
CLMCLM-4058672026-07-25T18:06:03ZKaren······Elliott1970-11-18null—NULLnull-N/AUNKNOWN—GRP-3499MEDICARE-ADV-A
ENRENR-1024552026-10-01T16:46:37ZSAMUEL—BRNS2001-12-03··UHC-39209-26N/A6133657225samuel.burns81@gmail.com3883 Canyon RdSeattleWA98162GRP-1891MEDICARE-ADV-A
CLMCLM-4217162026-03-31T21:49:12ZJESSICA·UGUTIERREZ1975-10-27null•••-••-719316817862168—1699 Valley View DriveLos AngelesCA90068GRP-0136NULL
ENRENR-1032772026-09-10T08:10:47Z AmandaK·McDonald1959-05-10UHC-18011-89•••-••-4930664.439.0605—2036 Indian School RdSeattleWA98106·GRP-7068OPTIONS-PPO
ENR ENR-1233612026-09-28T04:33:27ZJeremyF.·Carpenter1970-06-27UHC-28403-13•••-••-8261918.940.6072jeremy.carpenter17@icloud.com8741 Spring StSan AntonioTX78281GRP-5683SELECT-EPO
ENRENR-1310172026-09-02T17:30:48ZMEI··FARMSTRONG1993-06-21UHC-83413-64•••-••-9378(237) 782-0792mei.armstrong16@aol.com6233 Canyon RoadPLANOTexas75071GRP-3687OPTIONS-PPO
ENRENR-1278762026-09-15T02:46:07ZAMBERGMORENO0850-19-99UHC-25618-80•••-••-6561309-485-0791amber.moreno@proton.me4874 Camelback RoadAtlantaGeorgia··30317GRP-4950CHOICE-PLUS-PPO
ENRENR-1066102026-10-16T11:27:01Z·BruceYFuller1988-04-26UHC-98369-58•••-••-67307989699926bruce.fuller74@aol.com7507 MARKET ST··JacksonvilleFL32220GRP-7474MEDICARE-ADV-A
PRVPRV-286802026-10-05T16:17:15Zkenneth··cox1953-06-17UHC-45864-37——-3484 Maple AveGlendaleArizona85331——
ENRENR-1294072026-01-29T08:52:07ZMARTHAIHAYES1696-04-09UHC-66309-25•••-••-3467231-734-8464martha.hayes@gmail.com873 BAYSHORE DRPLANOTX75002GRP-0214SELECT-EPO
ENRENR-1101332026-02-24T19:52:47ZJason—Ford1955-10-21UHC-76473-51•••-••-1131+1 687 394 4189JASON.FORD31@HOTMAIL.COM8074 Maple AveGilbertAZ85252GRP-5651CHOICE-PLUS-PPO
ENRENR-1263112026-09-03T00:08:09Z emma—gardner19510819UHC-60192-48•••-••-5075749-954-9025emma.gardner12@hotmail.com6009 Maple AvenueMiamiFL33192GRP-0306SELECT-EPO
PRVPRV-264022026-01-17T07:33:30ZMariana—Auztin1967-10-15UHC-60247-95null(787) 539-2929MARIANA.AUSTIN10@OUTLOOK.COM·5576 Oak StreetDENVERColorado80282—MEDICARE-ADV-A
ENRENR-1178242026-04-28T17:39:44ZHananhCDayAug 23, 1991UHC-89666-89·-293-236-4050hannah.day@hotmail.com914 Indian School RoadMINNEAPOLISMN55469GRP-9981OPTIONS-PPO
ENRENR-1338592026-02-11T04:00:45ZJordan—Lawrence2002-09-13UHC-30417-68•••-••-4859—jordan.lawrence@proton.me—nullN/A-GRP-8530MEDICARE-ADV-A
ENRENR-1039812026-07-09T05:04:34ZJOSEMHOWELL1978-11-01UHC-12973-72•••-••-2192673-945-5433JOSE.HOWELL@PROTON.ME6267 Camelback Road·NashvilleTN37265GRP-4813CORE-HMO
PRVPRV-280642026-03-27T12:49:06ZBruce—Peteron1945-11-18UHC-86369-01-(394) 736-1826bruce.peterson89@outlook.com··6573 HARBOR BOULEVARDGilbertAZ85294N/AN/A
TPATPA-594112026-08-28T13:20:45ZDiego—Garza·1947-03-02N/A•••-••-4530—N/A—-NULL—UNKNOWNSELECT-EPO
CLMCLM-4286442026-03-16T23:20:09Zjacqueline—reid11/04/2004UHC-57895-23nullnull··JACQUELINE.REID@GMAIL.COMNULLNULL—N/A··N/A—
ENRENR-1349642026-08-05T18:02:59ZMASONAREID1994-02-25UHC9467882•••-••-0357·18328805841MASON.REID@YAHOO.COM4264 Palm Dr #906··SEATTLE··WA··98165-3286GRP-5271NAVIGATE-HMO
ENRENR-1260162026-01-28T09:50:03ZBRITTANY—GILBERT1949-10-17UHC-17484-71•••-••-7210565.660.4575null·2276 Desert Sky BoulevardMesaAZ85200GRP-9790CORE-HMO
ENRENR-1353952026-08-14T07:13:51ZMARC—SULLIVAN·28-10-1979UHC-87623-30•••-••-3000(422) 443-6457marcus.sullivan@icloud.com3918 Main StreetFresno·CA93754GRP-8622··SELECT-EPO
PRVPRV-265962026-09-02T00:21:29ZJessica—Duncan2003-02-01——5967665166jessica.duncan99@gmail.com8245 Oak Street Apt 34Mesaaz··85213····OPTIONS-PPO
TPATPA-597652026-01-22T02:06:09ZPatrick—Orteega··7/20/2001NULL—18212622405·NULL348 Cedar LaneAtlanta·GA30305-9682—·-
ENRENR-1040092026-01-04T04:22:41ZGEORGE··FFIELDS07-08-1964UHC-41024-19•••-••-017018092568073george.fields98@gmail.com·6238 DESERT SKY BLVDSeattleWashington98175GRP-8989NAVIGATE-HMO
CLMCLM-4075512026-09-07T07:45:59ZGreene, Samantha——19760902UHC-56755-08•••-••-68952279261166-1516 HIGHLAND AVE #290San Diego··CA92151··GRP-6529—
TPATPA-618772026-07-28T20:50:21ZPHILIP··—JOHNSTON1966-07-26UHC-61230-27UNKNOWN(684) 241-5710—-NULL··—·N/ANULL·N/A
100,000 rows, page 177 of 2,000PreviousNext

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:36.712Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty