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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1183782026-07-08T21:13:33ZSAMUEL··GARCIA1939-05-05·UHC-53945-79•••-••-3266870-777-1596samuel.garcia@icloud.com··8620 MEADOW LNSeattlewa98137GRP-6570CHOICE-PLUS-PPO··
ENRENR-1196792026-03-15T11:45:17ZDENNYJDUNNAug 27, 1984UHC-10436-45•••-••-7171204-582-0357dennis.dunn@hotmail.com8612 Central AveFresnoCA·93783GRP-7273MEDICARE-ADV-B
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
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
ENRENR-1246892026-05-04T23:25:54Z GARYXVEGA1996-03-01UHC-43920-25•••-••-0253955-363-1305—6269 CANYON ROADDenverCO80277GRP-9858CORE-HMO
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
ENRENR-1148122026-06-01T00:25:49Z·LARUAYCOLEMAN10/16/77UHC-16193-22•••-••-1033+1 727 742 6152null8086 Washington StHoustonTX77027GRP-6052NAVIGATE-HMO
ENRENR-1377212026-05-14T08:48:59Z DebraDHanson1990-94-20UHC5334645•••-••-7704····DEBRA.HANSON83@GMAIL.COM9897 Bayshore DrDallasTX75269GRP-5411CORE-HMO
ENRENR-1133752026-09-23T03:14:26ZcarolSkim2007-10-18UHC-04642-40•••-••-1904·362.791.8851CAROL.KIM@HOTMAIL.COM565 MEADOW LN #962TucsonAZ85728GRP-8021CHOICE-PLUS-PPO
ENRENR-1039422026-02-01T05:56:35ZLawrence, MasonR—Mar 4, 1980UHC-24473-72•••-••-6084—MASON.LAWRENCE19@AOL.COM7666 Baseline RdScottsdaleAZ85206GRP-5566CHOICE-PLUS-PPO··
ENR ENR-1318662026-02-18T22:28:12Z·Richard N—Chapman11/01/1999UHC-28200-70•••-••-7598·+1 831 458 1341RICHARD.CHAPMAN@OUTLOOK.COM5513 Desert Sky BoulevardPLANOTX75012-2089GRP-1016MEDICARE-ADV-B
ENRENR-1256142026-03-04T03:17:42ZJozeph—Daniels05/08/1958UHC-62760-29•••-••-59145485384603—4754 Cedar Lane·AustinTexas78779GRP-0329·NAVIGATE-HMO
ENRENR-1350602026-03-18T03:29:05ZDebra—Oliveer12/13/38UHC-76154-45•••-••-4878413-439-6828DEBRA.OLIVER@ICLOUD.COM8029 Maple AvePHOENIXAZ85043GRP-6796CHOICE-PLUS-PPO
ENR ENR-1301232026-10-01T19:34:05ZPeterson, HiroshiR—Sep 4, 1968UHC-61159-02•••-••-6809(467) 518-3509—2708 Oak StreetMiamifl·33131GRP-4004MEDICARE-ADV-B
ENR ENR-1292632026-01-06T03:05:48ZWilliam·KHernandez2001-09-12·UHC-46931-84•••-••-18695142381081william.hernandez@hotmail.com7899 Cedar LnDallasTexas75231GRP-8800SELECT-EPO
ENRENR-1277062026-09-07T10:35:39ZDennis J.—Holmes1981-01-15UHC-23663-34•••-••-27499044237368dennis.holmes@aol.com8792 ELM STMiamiFL33153GRP-1143MEDICARE-ADV-A
ENRENR-1091742026-04-01T12:02:54Zanna··—burton1951-06-22UHC-34712-64•••-••-5725NULLANNA.BURTON@ICLOUD.COM3373 Valley View DriveAtlantaGA30362·GRP-3720CORE-HMO
ENRENR-1214122026-02-23T01:01:32ZCarolH.Waton1977-08-21UHC-45598-14UNKNOWN9294422414carol.watson89@outlook.com1921 Bayshore Dr·CHARLOTTENorth Carolina··28256GRP-7866··SELECT-EPO
ENRENR-1296922026-05-25T18:15:00ZCollins, Dennis——20010715UHC-50198-73•••-••-519812689359813DENNIS.COLLINS@OUTLOOK.COM4690 Ocean AvenueDallasTX75280GRP-5304SELECT-EPO
ENRENR-1178792026-06-14T18:08:18ZJerry—Phillips1959-10-23UHC9831608•••-••-8680841-997-6554—5337 FOREST AVENUEMiamiFL33159GRP-4457CHOICE-PLUS-PPO
ENRENR-1146792026-03-19T19:34:35ZRONALDEJENKINS24-10-1959UHC-45399-14NULL—ronald.jenkins@proton.me9848 Hillcrest RoadSeattleWA··98173GRP-8879CHOICE-PLUS-PPO
ENRENR-1131282026-09-05T14:16:31ZHICKS——03/26/1974UHC-68928-73•••-••-30842157592648aaron.hicks@gmail.com·6607 DESERT SKY BLVDEden PrairieMN55313GRP-9454CHOICE-PLUS-PPO
ENRENR-1199492026-05-09T15:52:44ZAaronF.Evans1944-06-16UHC-51560-75•••-••-8884(693) 536-5422aaron.evans83@outlook.com2320 Central AveAustinTX78753·GRP-7508MEDICARE-ADV-A··
ENRENR-1093522026-07-29T20:06:38Z MATEO—TAYLORFeb 24, 1978UHC-48830-68•••-••-3601(867) 332-4034MATEO.TAYLOR@PROTON.ME4707 Church StDenverCO80203GRP-6957·CHOICE-PLUS-PPO
ENRENR-1138062026-08-31T21:36:20ZLuciaHWatson1976-09-28UHC-44470-52•••-••-6288532.676.3495··lucia.watson@outlook.com2545 Oak StTempeAZ85265GRP-6683CHOICE-PLUS-PPO
ENRENR-1228862026-05-15T06:18:15ZJESSICA··—MENDEZ1990-96-28null•••-••-7965943-347-6409—4733 Mountain View DriveMiamiFlorida33137GRP-6390MEDICARE-ADV-A
ENRENR-1131192026-09-01T23:49:40ZRussell—Weber1966-05-02UHC2131172•••-••-8942+1 368 335 3793—3471 River Rd·ATLANTAGA30353GRP-0174OPTIONS-PPO
ENRENR-1395732026-03-27T19:55:59ZLuciaPReyes1967-05-26UHC-11974-20•••-••-0684(988) 734-6573lucia.reyes52@outlook.com8769 MESA DRIVEGLENDALE·AZ85310GRP-7868MEDICARE-ADV-B
ENRENR-129561 2026-08-04T15:13:28ZTHERESAU.HICKS02/09/1969UHC-01574-14•••-••-66528065654780null1799 Highland AvenueJacksonvilleFL32208-0668GRP-0590MEDICARE-ADV-A
ENR ENR-1254662026-01-23T04:51:05ZPriya—Murray1978-02-02UHC-60074-18•••-••-9784475.387.9267priya.murray@gmail.com·995 WASHINGTON STREETMiamiFL33156GRP-0112MEDICARE-ADV-A
ENRENR-1113332026-08-09T10:18:35ZWALTERH··FULLREJul 1, 1957UHC-25159-18•••-••-9823+1 246 798 4713—1122 CAMELBACK ROADAtlantaGeorgia30360GRP-1076OPTIONS-PPO
ENRENR-1395702026-01-10T10:23:14ZRYAN—·CAMBPELL·11/08/1948UHC-41667-04•••-••-7225+1 296 461 9946RYAN.CAMPBELL@AOL.COM9271 HILLCREST RDATLANTAGA30302GRP-7779NAVIGATE-HMO
ENRENR-1372492026-03-06T10:27:35Zann—bowman06/15/70UHC5865788•••-••-7620450-844-4063-6414 Ridge RoadPhoenixArizona85023GRP-3809MEDICARE-ADV-A··
ENRENR-1392782026-09-05T07:11:56ZJANICEKSMITH1961-08-04UHC-63818-98•••-••-0122775-410-8884—7340 Desert Sky BoulevardTucsonAZ85721-6519GRP-2170MEDICARE-ADV-A
ENRENR-1019742026-05-16T10:48:46Z·Karen—Rogers·Jul 19, 1981UHC-25867-04··NULL3648920828karen.rogers79@proton.me7257 CENTRAL AVENUECharlotte··NC28283GRP-8233OPTIONS-PPO
ENRENR-1318552026-03-25T23:27:56ZLUCYA··—PETERS1947-02-01UHC6922768-989-414-8857lucia.peters@hotmail.com8035 Canyon RdHoustonTX77032GRP-2515NAVIGATE-HMO
ENRENR-1233632026-01-05T15:31:29Zchristina·Rhoward1958-07-15UHC-88448-16•••-••-01945656436864christina.howard@gmail.com5406 Main StColumbusOHNULLGRP-4819MEDICARE-ADV-A
ENRENR-1157192026-10-04T03:47:27Z GloriaTHolmes1985-08-04UHC-47269-70··•••-••-0259(887) 890-1218-606 JEFFERSON AVENUESeattleWA98123GRP-1692MEDICARE-ADV-A
ENRENR-1144432026-07-28T08:22:40Z Kennedy, Scott——1939-02-22UHC-52155-54•••-••-20526838169592SCOTT.KENNEDY@YAHOO.COM7062 MARKET STPLANOTX75099·GRP-6097SELECT-EPO
ENRENR-114560 2026-08-31T07:18:47ZSOPHIA—MILLER2004-08-07UNKNOWN•••-••-3051538-653-2881NULL9556 CANYON RDMiamiFL—GRP-2735CORE-HMO··
ENRENR-1102142026-05-17T06:23:03ZJennifer—JensenOct 17, 1977UHC-58585-41•••-••-7889—JENNIFER.JENSEN46@GMAIL.COM987 GRAND AVENUEJacksonville··FL—GRP-0409CHOICE-PLUS-PPO
ENRENR-1060092026-10-02T04:41:59Zjulie—fields1956-08-09UHC-68737-10•••-••-7526317-511-6525JULIE.FIELDS@GMAIL.COM6025 OAK STSan AntonioTexas78241GRP-0979medicare-adv-a
ENRENR-1271702026-04-18T16:26:27Z·LOGAN··WEST1958-12-16UHC-35846-32•••-••-6270771-853-9742logan.west@outlook.com9527 BroadwayORLANDOFL32882GRP-7489OPTIONS-PPO
43,101 rows, page 114 of 863PreviousNext

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