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
ENRENR-1216462026-08-05T20:19:43Z Black, MarthaC—02-03-1995UHC-64249-21•••-••-6968886-607-7238MARTHA.BLACK@YAHOO.COM2104 Lake View RoadMesa·AZ85247-1130GRP-3131·CHOICE-PLUS-PPO
ENRENR-1426142026-03-08T04:18:44ZJason—James1957-02-14UHC-94506-04•••-••-9064+1 741 328 4041JASON.JAMES70@PROTON.ME9716 Mountain View Dr #769··GLENDALEAZ85352-6879GRP-6036CORE-HMO
ENRENR-1427472026-10-17T05:45:31ZMARKVVAZQUEZ09/24/89UHC-24042-15•••-••-4032—MARK.VAZQUEZ@OUTLOOK.COM1533 Mesa DriveAtlantaGA30358GRP-6555OPTIONS-PPO
TPATPA-63036 2026-10-07T23:56:43ZCAROL—TURNER06/04/1988—··8674376699null834 Highland AveEden PrairieMN55325-3798··N/ASELECT-EPO
ENRENR-1218582026-10-05T05:33:22Z·Johnston, Marcus——1957-01-12··UHC-13149-50•••-••-2632(423) 430-5655·MARCUS.JOHNSTON44@HOTMAIL.COM7914 Meadow LaneLas VegasNevada89167GRP-8869NAVIGATE-HMO
ENRENR-1316492026-04-30T05:55:17ZanthonyC.harper11/23/06··UHC-93669-60•••-••-17417815273432UNKNOWN2237 Harbor BlvdORLANDOFL32845GRP-2027MEDICARE-ADV-B
CLMCLM-4283612026-04-01T18:25:55Zbradley—warren23-07-2005UNKNOWN—5883727120null93 Valley View DriveATLANTA··GA30385N/A-
ENRENR-1142612026-07-20T05:37:49ZPriya—Jimenez1962-12-10UHC-55791-82•••-••-6130—PRIYA.JIMENEZ16@HOTMAIL.COM1209 Central AvenueDallasTX75242··GRP-2144MEDICARE-ADV-A
CLMCLM-4295492026-04-15T04:23:28ZZachary—Stevens1983-11-03UHC-41271-59NULL—-6105 Park PlaceChandler·AZ85270GRP-6095CORE-HMO
CLMCLM-4305622026-05-19T18:17:48ZElizabeth—Riley1963-05-28UHC-76809-17•••-••-2580—NULL4203 RIDGE ROADSAN DIEGOCA··92120··UNKNOWN—
TPATPA-643562026-01-02T08:27:33ZGEORGENCOLEMAN19390505-—2869210112N/A7711 Valley View Dr Apt 34SacramentoCA95896—N/A
CLMCLM-4044172026-03-11T09:37:14ZHIROSHI—MILLS05/01/62UHC-42502-08UNKNOWN2497153941-1782 HIGHLAND AVENUE #310Las VegasNV89162GRP-5618—
ENRENR-1181352026-03-10T06:21:23ZBettyPMyersMay 22, 1966UHC-98128-03•••-••-8303(270) 300-0583BETTY.MYERS@GMAIL.COM1206 Grand AvenueSacramentoCA95813GRP-7850MEDICARE-ADV-A
ENRENR-1386662026-07-18T06:32:51ZluciaH.leSep 8, 1959UHC-53838-39NULL5104709211lucia.le@yahoo.com7725 Pine Drive·Las VegasNevada89168GRP-1132CHOICE-PLUS-PPO
CLMCLM-4161282026-03-02T16:20:08ZGeorge·E.Fisher03/23/61··UNKNOWN8336986277UNKNOWN——N/AnullGRP-4420medicare-adv-a
CLMCLM-4195572026-04-08T01:53:57ZHiroshi—Henry1961-11-02UHC-37515-64—+1 914 204 8113-9552 Washington StMinneapolisMN55407UNKNOWNnull
TPATPA-576202026-07-01T04:36:36Z·Price, NaohU.—19691108UHC-27165-52•••-••-2727+1 555 253 2220noah.price@icloud.com4559 Market StreetPLANOTX75026null·null
ENRENR-1115912026-09-18T17:58:25ZHoffman, JacobD—1997-03-25UHC-51039-01•••-••-6653684-764-9540JACOB.HOFFMAN20@ICLOUD.COM6402 WILLOW CTChandlerAZ85236-7923GRP-0837SELECT-EPO
ENRENR-1390642026-08-23T23:44:10ZDNEISEPEDWARDS1978-08-20UHC-19277-26•••-••-1563+1 918 562 4750denise.edwards@icloud.com6836 PINE DRMinneapolis··MN55480GRP-6736CORE-HMO
CLMCLM-4305732026-02-03T06:39:25Z RUTH—SANCHEZ··1996-05-14—N/ANULLUNKNOWN2653 Elm StColumbusOH43298-9454GRP-1203CORE-HMO
ENRENR-1393472026-08-29T16:08:46Z·diegoWchavez12/14/1982UHC-14045-39•••-••-7936(490) 714-3270diego.chavez@hotmail.com5581 Desert Sky Boulevard··Las VegasNV89163GRP-1886MEDICARE-ADV-B
ENRENR-1152372026-04-25T22:21:46ZLUISU·BURTONMar 23, 1967UHC-35481-18•••-••-2163N/Aluis.burton@gmail.com5724 Central AvenueMinneapolisMN55403GRP-7615CHOICE-PLUS-PPO
CLMCLM-4172482026-04-23T20:09:24ZGuerrero, Russell——09/04/1975·null-3544674783—675 Mountain View DrTUCSONAZ85702-4769null··—
CLMCLM-4206952026-03-11T17:41:45ZKARENY.PEREZ·19550703N/A•••-••-1052498.343.3474·NULL2263 Palm DriveNashvilleTN·37250GRP-9131UNKNOWN
ENRENR-1151582026-08-02T17:04:20ZAARON—WBEB1964-02-02UHC-01857-64•••-••-05053242847345aaron.webb95@yahoo.com8555 Apache BlvdSan AntonioTX78290GRP-4835MEDICARE-ADV-B
CLMCLM-4115562026-02-05T10:48:04Zalexander—schultz1967-11-05UHC-44327-61UNKNOWN12416952655UNKNOWN·7629 Desert Sky BlvdTUCSONAZ85748··NULL
CLMCLM-4083852026-05-02T00:50:53ZDenise—Olson05/11/51UHC-65886-44UNKNOWN237-453-3779·UNKNOWN-NULLUNKNOWNNULL—N/A··
TPA TPA-554022026-07-26T14:52:48Z THERESA—MURPHY1949-04-01—UNKNOWN16405667718N/A·NULLNULLN/A-GRP-7247NULL
ENRENR-1262572026-07-02T16:47:11ZSofiaQMitchell1977-09-28UHC-13416-69•••-••-7348(807) 493-4978—4159 Baseline RoadMesaAZ85289GRP-9936CORE-HMO
CLMCLM-4161092026-03-22T02:16:24Z RUTH—CONTRERAS07/24/46—null+1 449 425 9697UNKNOWN--UNKNOWN—·GRP-8705—
PRVPRV-248272026-01-10T10:11:37Zbeverly—sanchez10-11-1980UHC-76900-91—553-770-0961-—-—UNKNOWNNULLOPTIONS-PPO
ENRENR-1405842026-03-15T13:22:40Z Valentina—ReidApr 6, 1965UHC-92970-85•••-••-6233(677) 909-6548valentina.reid8@aol.com4462 Lake View RdPHOENIX··AZ85029-1086GRP-8788OPTIONS-PPO
ENRENR-1085912026-07-01T06:41:00ZMichael—Jordan2000-11-24UHC-94325-83N/A212-512-5878michael.jordan@aol.com1678 Oak Street Apt 21·SAN ANTONIOTX78293GRP-1936NAVIGATE-HMO
CLMCLM-4301832026-07-18T12:37:07ZCatherine—Riley1999-11-09UHC-20404-24··nullNULLN/Anullnull—nullGRP-5636—
CLMCLM-4071552026-08-30T22:13:42ZCarlN.George11/11/1993UHC-01033-11•••-••-28237775911976—5349 Jefferson AvenueLos AngelesCA90028GRP-6837—
ENRENR-1062652026-03-13T19:10:50ZMATEO—MORENO1978-11-16·UHC-39345-31•••-••-2226880-302-1053mateo.moreno22@proton.me2119 Jefferson Avenue Apt 27OrlandoFL32884GRP-4159OPTIONS-PPO
ENRENR-1188752026-03-23T01:00:08ZMARKABUTLER26-09-1981UHC-68693-91··•••-••-7298474.493.4354mark.butler9@outlook.com1096 Camelback RoadGILBERTAZ85206·GRP-5487CORE-HMO
ENRENR-1353452026-08-14T19:20:53ZStephanieT.Bradley19880212UHC-07574-71•••-••-11639696899450UNKNOWN8890 Willow CtMinneapolisMN55479GRP-0158OPTIONS-PPO
ENRENR-1334782026-03-14T01:32:31ZHAROLDJPETERSON1963-10-29UHC-37208-63•••-••-5583NULLHAROLD.PETERSON26@YAHOO.COM··5963 Lake View RoadMesaAZ85239GRP-5438SELECT-EPO
PRVPRV-284342026-06-23T10:10:41ZRebeccaWRiley19680503··UNKNOWNnull2593428950—NULLnull—--—
TPATPA-643622026-10-02T19:55:17ZWangJCharles06/14/1970UHC-77837-25nullnull—8724 Camelback RdCharlotteNC28249GRP-2523—
TPATPA-641352026-08-24T15:09:07ZSantiago—Burton1998-05-26UHC-39291-32—·nullN/A3029 Willow CtORLANDOFL32897GRP-5142MEDICARE-ADV-B
CLMCLM-4093922026-07-18T13:35:24ZAbigailKHolmes19940316UHC-14169-27-4083596951NULL·6461 Main StreetDenverColorado80200GRP-8488OPTIONS-PPO
PRVPRV-207832026-02-19T05:39:07ZJarry—Haart··1992-09-03UHC0098927-(474) 943-0716UNKNOWN2072 PINE DRLos AngelesCA90053UNKNOWNmedicare-adv-a
ENRENR-1354042026-02-08T18:12:51ZmariaHlucas19940324UHC-40744-44•••-••-57854903087052maria.lucas@aol.com2408 Jefferson AvenueColumbusOH43265GRP-4279MEDICARE-ADV-B
ENRENR-1310572026-06-17T11:28:26ZMarianaQGardner24-01-2001UHC-13906-61•••-••-60423017992114—7580 WILLOW COURTMIAMIFL33169GRP-7401OPTIONS-PPO
TPATPA-638242026-07-04T22:56:18ZJenkins, Brittany——10/02/48-UNKNOWN··+1 845 573 9459N/A4783 Ocean AveCharlotteNC28273-1742GRP-9508—
CLMCLM-4287252026-09-11T08:18:30ZJoyce··—Johnson8/4/1994UHC-57438-80•••-••-41702222822911null1785 Ridge RdScottsdaleAZ85209N/AMEDICARE-ADV-B
ENRENR-1391832026-07-18T12:54:05ZVALENTINA—PERY1958-07-19UHC-68447-74•••-••-97836945792409—4222 Maple AvenueNASHVILLETN—GRP-3759MEDICARE-ADV-A
CLMCLM-4000492026-03-10T10:35:12ZDorisF.Garza1957-12-18UHC-03918-71—N/AUNKNOWN5194 Desert Sky BlvdLos AngelesCA90000-4188NULLNULL
100,000 rows, page 224 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:37.733Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty