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-4307432026-04-24T20:54:49ZLARRY—HANSEN19990813NULLnullN/A—N/AUNKNOWN—-GRP-3847CORE-HMO
CLMCLM-4260112026-10-02T12:39:33ZBrendaDLee1955-11-20UHC-79610-84UNKNOWN····brenda.lee68@hotmail.com1869 CEDAR LNHOUSTONTX77051GRP-4541MEDICARE-ADV-A
CLM CLM-4203602026-09-04T22:28:32ZDONNA—GREENE1989-01-17UHC-31782-23•••-••-1640nullnull5500 Hillcrest RoadSan DiegoCA92179··N/AMEDICARE-ADV-A
PRVPRV-279422026-03-23T00:47:35ZAisha··Cunningham02-12-1996··UHC-04872-68•••-••-1468··—764 Valley View DrTAMPAFL33683——
ENRENR-104193 2026-01-07T13:37:58Z·JoshJ.Nunez1946-06-23UHC-94654-81•••-••-3760721-662-3691NULL9303 Sunset BlvdMinneapolis··MN55431GRP-5689·OPTIONS-PPO
TPATPA-529882026-01-04T08:43:52ZJacob—KyngMar 14, 1970NULL—523-679-6588jacob.king64@yahoo.com7963 LAKE VIEW RDTempeAZ—NULLN/A
ENRENR-1298412026-05-08T11:02:22ZWilliamVPierce1971-02-24UHC-54866-35··•••-••-6820628-268-5089··4291 PINE DRSan AntonioTX78228GRP-0332MEDICARE-ADV-B··
CLMCLM-4099202026-09-10T04:32:24Z larryI.black03/15/61UHC-17622-95•••-••-69683864735026··5388 Jefferson AveDenver·CO80277GRP-6853··CHOICE-PLUS-PPO
TPATPA-540832026-09-23T02:43:58ZRobertB.··Edwards07/11/2004··UNKNOWN•••-••-6337UNKNOWN-3734 Desert Sky BoulevardAustinTX78732—NAVIGATE-HMO
ENRENR-1068202026-07-21T07:06:12ZCHARLOTTEC.DELGADO1981-08-19UHC-38844-27null943-705-6172—·8620 BASELINE RDAtlantaGA·30317·GRP-7258MEDICARE-ADV-A
CLMCLM-4279292026-07-02T13:36:33ZGuerrero—Kevin1956-03-23UHC-55296-65•••-••-9830—N/A4927 RIVER RDFresnoCA··93783GRP-5331select-epo
ENRENR-1278082026-08-18T01:07:15ZSaraZWood1953-02-26UHC-63850-64•••-••-9061(377) 266-0464UNKNOWN89 Pine DrOrlandoFloridaN/AGRP-3757SELECT-EPO
ENRENR-1391022026-08-10T15:42:28Z jerryFsilva1992-04-01UHC-95309-73•••-••-106319523877745JERRY.SILVA19@ICLOUD.COM5244 Ocean AvenueChandlerAZ85212GRP-3835MEDICARE-ADV-A
TPATPA-588502026-09-28T19:47:02Zandrea—kim04/05/45UHC-46800-07-424.268.7065-—N/AN/ANULLN/A-
CLMCLM-4182582026-03-23T07:50:00ZMariana··—Fowler1986-11-05UHC-92162-53····null—6958 MOUNTAIN VIEW DRIVEScottsdaleAZ85292GRP-8570····
ENRENR-1017762026-06-23T19:50:07ZNicholas—Perry1972-02-16UHC-33463-19•••-••-3394303.549.0621nicholas.perry@gmail.com3968 Sunset BlvdSan AntonioTX78221GRP-8409CHOICE-PLUS-PPO
ENRENR-1067072026-06-10T14:41:02ZDORISUDIAZ1942-02-19UHC-30771-40•••-••-29467727867759null9094 Desert Sky Blvd #290AustinTX78724GRP-5198··MEDICARE-ADV-A
CLMCLM-4160502026-04-07T08:13:07ZEugeneX.Bailey1968-02-11UHC-60178-10•••-••-9386null—5402 Church StTempe··AZ85252-options-ppo
ENRENR-1071512026-09-07T01:33:10ZDianaGHanson1989-01-07UHC-23006-28•••-••-6345668-489-1550diana.hanson@icloud.com2739 HILLCREST ROAD··FRESNOCA93730GRP-6143CORE-HMO
ENRENR-1183782026-07-08T21:13:33ZSAMUEL··GARCIA1939-05-05·UHC-53945-79•••-••-3266870-777-1596samuel.garcia@icloud.com··8620 MEADOW LNSeattlewa98137GRP-6570CHOICE-PLUS-PPO··
TPATPA-557352026-09-21T00:28:15ZBrandon····Kim··0604-16-92·UNKNOWN•••-••-2049UNKNOWNbrandon.kim14@gmail.com—N/AN/ANULL···NULL
ENRENR-1196792026-03-15T11:45:17ZDENNYJDUNNAug 27, 1984UHC-10436-45•••-••-7171204-582-0357dennis.dunn@hotmail.com8612 Central AveFresnoCA·93783GRP-7273MEDICARE-ADV-B
CLMCLM-413754 2026-08-05T01:24:33ZAadm—Snyder1946-09-27UHC-25891-48•••-••-9530NULL—9660 Market StreetDenverCO80265——
PRVPRV-286332026-07-06T12:33:41ZDIEGO—HARVEEY1956-20-03····-+1 682 410 0692nullNULL——NULL—OPTIONS-PPO
CLMCLM-4292062026-07-06T01:54:27ZEric—MartinAug 28, 1956UHC2765665—955-444-0435NULL2962 Jefferson AveMiamiFL33197GRP-4913·null
ENRENR-1415052026-07-02T17:46:21ZSusan—Scott1990-06-06UHC-56182-63•••-••-0286(903) 709-3785susan.scott39@yahoo.com·3405 Spring StreetMiamifl33116-5704GRP-7949MEDICARE-ADV-A
ENR ENR-1038652026-04-15T15:56:55Z·patriciaY.schultz1946-04-18UHC-50932-99•••-••-2520(646) 205-9255patricia.schultz@yahoo.com4426 Park PlaceGLENDALEAZ85392-7299GRP-4763CHOICE-PLUS-PPO
ENRENR-137018 2026-08-07T06:57:02ZAUSTINNWELCH1963-04-23UHC-09700-72•••-••-695917728276325austin.welch69@aol.com278 Palm Drive Apt 13GilbertAZ85277GRP-7966SELECT-EPO
TPATPA-559622026-03-12T10:48:15ZRACHEL—LEE11/02/1939·N/AN/A-null3132 Meadow LnLas VegasNV89139·N/ACORE-HMO
ENRENR-1312092026-03-15T08:55:08ZNICOLE—KING10-03-1969UHC-75840-72•••-••-5504(884) 889-1767nicole.king@aol.com··6954 Pine DrivePHOENIXAZ·85091-1134GRP-7737MEDICARE-ADV-B
ENRENR-1090732026-02-10T23:57:33ZFrances··—·SimpsonNov 22, 1938UHC-34144-24•••-••-9968(720) 960-5772··frances.simpson76@icloud.com8235 Pine DrPHOENIX·AZ85066GRP-9987MEDICARE-ADV-A
ENRENR-1312582026-09-11T08:45:46ZAhmed H····Jordan1957-09-07UHC8031248•••-••-66974343134073—3570 Indian School RoadHoustonTX77073GRP-2646·NAVIGATE-HMO
CLM CLM-4068832026-03-20T00:19:48Z keith—dixon2004-09-02UHC-86166-19•••-••-3408UNKNOWNUNKNOWN·UNKNOWN-NULL—GRP-9351null
ENRENR-1246892026-05-04T23:25:54Z GARYXVEGA1996-03-01UHC-43920-25•••-••-0253955-363-1305—6269 CANYON ROADDenverCO80277GRP-9858CORE-HMO
TPATPA-608322026-03-31T04:52:20ZCARLOS—HOFFMANAug 1, 1963——N/Anull559 MESA DRAUSTINTX78768——
PRVPRV-225832026-03-24T06:33:25ZRonaldU··AlvarezMar 19, 1994UHC-65432-23—748.342.1406—1061 Spring StFresnoCA93709-6714UNKNOWN·CHOICE-PLUS-PPO
CLMCLM-4221092026-06-07T07:15:13ZEIMLYC.BENNETT02/04/81NULL•••-••-0952(398) 664-2803NULL5579 LAKE VIEW RDFRESNOCA93723GRP-5277OPTIONS-PPO
ENRENR-1258312026-05-07T21:06:04ZMichaelJMitchell1971-01-19UHC-29759-87•••-••-4114·206.884.1797NULL6284 Washington St·NASHVILLE·TN37288GRP-6561·NAVIGATE-HMO
ENRENR-1267712026-07-06T02:31:10Z cynthia Z.—silva19570620UHC-94337-87•••-••-35237168928634·cynthia.silva@outlook.com·434 Highland AveNashvilleTN37233GRP-3249SELECT-EPO
ENR ENR-1401072026-07-25T16:05:18Z·ALEXISA.SPENCER1981-06-28UHC-95602-95—+1 384 981 9028alexis.spencer1@gmail.com·191 Sunset BoulevardOrlandoFL32886GRP-9652SELECT-EPO
ENRENR-1382612026-03-08T11:02:30ZbruceQ.wilson09/09/2007·UHC-69395-77-17449154205NULL2098 Baseline Rd··TampaFL33668GRP-1641NAVIGATE-HMO
CLMCLM-4150672026-02-15T21:32:50ZDENISEJRICHARDSON2002-10-07UHC-40221-43—·(593) 381-1522UNKNOWN—UNKNOWN-··GRP-2041UNKNOWN
CLMCLM-4128632026-05-21T20:28:14ZAmber—Riley12/12/1998uhc-46144-77•••-••-4503539-814-0665—3250 Forest AveJacksonvilleFlorida——SELECT-EPO
ENRENR-1148122026-06-01T00:25:49Z·LARUAYCOLEMAN10/16/77UHC-16193-22•••-••-1033+1 727 742 6152null8086 Washington StHoustonTX77027GRP-6052NAVIGATE-HMO
CLMCLM-4134852026-03-14T22:10:13ZArthur—Torres2005-05-12UHC-83889-10N/A330-541-6365-3615 VALLEY VIEW DRDENVERCO80265·-—
CLMCLM-4314712026-06-18T19:27:33Z·Rebecca—Jones1967-05-27UHC-46908-53N/A753-583-3803—7642 Lincoln Way Apt 8SeattleWAN/AGRP-0894··—
ENRENR-1377212026-05-14T08:48:59Z DebraDHanson1990-94-20UHC5334645•••-••-7704····DEBRA.HANSON83@GMAIL.COM9897 Bayshore DrDallasTX75269GRP-5411CORE-HMO
PRVPRV-247582026-06-11T14:49:02ZMARCUS—TUCKER11/21/2000UHC-60936-79•••-••-6719NULLMARCUS.TUCKER@YAHOO.COM·6343 Palm DrAustinTX78799-NULL
TPATPA-589422026-07-30T13:44:55ZMelissa··Ramos06/10/02UNKNOWN····+1 876 376 9108··-7751 Bayshore DrChandlerAZ85233nullSELECT-EPO
ENRENR-1133752026-09-23T03:14:26ZcarolSkim2007-10-18UHC-04642-40•••-••-1904·362.791.8851CAROL.KIM@HOTMAIL.COM565 MEADOW LN #962TucsonAZ85728GRP-8021CHOICE-PLUS-PPO
100,000 rows, page 259 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.754Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty