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

Provider network only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
PRVPRV-225562026-05-03T03:17:03ZBETTY—LE7/25/1953UHC-26618-68—6077473424—9800 Mesa DrHoustonTX77009—-
PRVPRV-257692026-07-30T16:22:22ZJENNIFER··—DEAN1954-01-02UHC6233689N/A6205421689··JENNIFER.DEAN@OUTLOOK.COM8007 INDIAN SCHOOL ROADJacksonvilleFL32204nullnull
PRVPRV-202602026-04-10T14:09:52ZMARCUS—WALLACE2/8/1991UHC-76142-96N/A7886452marcus.wallace@proton.me-UNKNOWNNULL-—N/A
PRVPRV-273182026-10-06T06:28:09ZROY—FULLER·1982-12-26UHC-84389-41•••-••-51565659510193-·3047 Main StMinneapolisMN55410·null··
PRVPRV-200062026-03-15T10:46:15ZMARGARETKBELL07/25/2006UHC3957466·-4893045null4859 Elm StreetTampa·FL33618UNKNOWNNAVIGATE-HMO
PRVPRV-224312026-03-02T23:33:03Z VincentVWood02-11-1955-•••-••-5302599-704-4390VINCENT.WOOD89@HOTMAIL.COM3500 CAMELBACK RDSan DiegoCA92162N/AOPTIONS-PPO
PRVPRV-239502026-02-03T04:54:53ZPamelaOSantiago19970714—-722-268-9749UNKNOWN6957 Apache BoulevardDallasTexas75214UNKNOWN-
PRVPRV-228862026-03-01T07:17:09ZChristine··—George2006-08-21··-null5859503220CHRISTINE.GEORGE@ICLOUD.COM2631 HIGHLAND AVEAustinTX78729—CHOICE-PLUS-PPO
PRVPRV-284682026-02-24T02:28:07ZVincentN.Knight07/24/84UHC-99113-10—308.234.9708UNKNOWN2594 Sunset Boulevard··Phoenixaz85002N/ANULL
PRVPRV-275802026-04-28T04:53:32ZAbby—Grant1953-02-13uhc-92965-83•••-••-7743222-828-1112-7908 Hillcrest RdTempeArizona85253N/AN/A
PRVPRV-263062026-06-16T14:33:43Zpaul—·harrisOct 8, 1943UHC-51958-95•••-••-3784-N/A881 Forest Avenue··TucsonAZ—nullNULL
PRVPRV-206232026-06-30T00:56:25Z LoriGMejia1595-11-11--··(480) 465-9925N/A8436 Palm Drive··TempeAZ··85251——
PRVPRV-234572026-07-10T05:02:49ZJESSES··KIM1974-05-20UHC-24310-96•••-••-9862409-805-6816JESSE.KIM83@AOL.COM2579 Harbor BoulevardDenverCO··80213—-··
PRVPRV-200382026-01-23T12:25:48ZBETTY—WEAVER··1960-38-01N/A··-+1 513 717 6082—662 PALM DRIVEGlendaleAZ85395NULLNAVIGATE-HMO··
PRVPRV-280332026-09-03T01:35:15ZAustin·····Herrera1951-06-11UHC-82062-87—937-594-6785AUSTIN.HERRERA30@HOTMAIL.COM6872 Highland AveOrlandoFL···32853—-
PRV PRV-217422026-07-23T20:16:43ZFrances—AndersonFeb 5, 1976—UNKNOWN3248346442N/A7806 Market StreetDallasTX-——
PRVPRV-287402026-08-17T03:40:11ZLUISYSTEVENS··2002-07-18——3082697885null7599 GRAND AVENUESacramentoCA95850··—null
PRVPRV-272062026-01-27T23:06:27ZSHARON—ALEXANDER04/27/1992·nullN/A4526842501UNKNOWN4450 Ocean AvenueDallas··TX75213-—
PRVPRV-240792026-10-15T07:37:58Zmason—le·4/12/1954NULL•••-••-0053(605) 753-1126-1454 Camelback RoadGlendaleAZ85361UNKNOWN—
PRVPRV-275192026-02-27T06:30:45ZWALTER··MORRIS08/18/1945NULL•••-••-5360(752) 855-2367··walter.morris@outlook.com9310 Forest Ave··Las VegasNV89124—N/A
PRVPRV-225732026-07-28T04:04:04ZLori—Butler1981-02-20··UHC-75436-96NULLUNKNOWNNULL405 Indian School RoadNashvilleTennessee37270-4958null·N/A
PRVPRV-222582026-01-23T13:23:26Zdiana····rian1945-09-14NULL—6742543948DIANA.RYAN@AOL.COM3336 Market Street·TucsonAZ··85736NULL-
PRVPRV-222222026-08-04T14:29:36Zjustin—little1966-06-17UHC-43700-15—null-—nullN/A—NULL—
PRVPRV-284462026-03-07T04:29:27ZGREGVLUNA1966-07-21UHC0665238··511.249.1982GREGORY.LUNA@ICLOUD.COM1761 Canyon RoadPhoenixAZ85020—N/A
PRVPRV-260072026-02-22T09:44:39ZArjun—Stone1987-03-17-—6575655180—NULLUNKNOWNNULLUNKNOWN—CHOICE-PLUS-PPO
PRVPRV-243142026-07-14T22:19:41ZELIZABETH—WANGDec 22, 1965——+1 629 550 6291NULL··287 Grand AvePlanoTX75066-—
PRV PRV-274692026-03-09T23:21:39Zisabella····lynch1973-11-09—-859-740-5922isabella.lynch@icloud.com7754 VALLEY VIEW DRIVE #446GILBERTAZ85235··-··—
PRVPRV-214522026-03-27T15:15:15ZRICHARDHMORGAN04/20/55NULLUNKNOWN4133936157NULL4555 Apache BlvdTucsonAZ··85770—null
PRVPRV-201472026-10-13T07:05:16ZArthur—Wright1943-12-18UHC-32304-69null—arthur.wright@icloud.com7348 Baseline RoadLas VegasNV89112-4857—OPTIONS-PPO
PRVPRV-245032026-08-05T13:50:35Z hiroshi—baker1982-11-19UHC-72853-63-nullUNKNOWN4990 Harbor BoulevardOrlandofl32847UNKNOWNUNKNOWN
PRVPRV-240212026-07-01T04:40:26ZAnna—Alvarez1944-08-10UHC-05857-44null3695226—4436 Willow CtEden Prairie·mn55347—NULL
PRVPRV-238352026-03-24T18:30:54ZFields, Frances——1951-11-04NULLUNKNOWN(414) 661-3290FRANCES.FIELDS@AOL.COM565 Main StreetTempeAZ·85239UNKNOWNN/A
PRVPRV-210832026-03-20T08:30:40Zgarry··—sandoval19460726UHC-80407-02null2448261734—UNKNOWNN/A—UNKNOWN-—
PRVPRV-278502026-08-23T17:23:02ZEricLLucas1942-07-13UHC-03105-72UNKNOWN··(803) 836-9163--UNKNOWNUNKNOWN—NULLUNKNOWN
PRVPRV-294982026-08-14T11:34:18ZHiroshi··Williams01/04/50-•••-••-6585820-222-2304hiroshi.williams@proton.me232 Mountain View DriveDenverCO80275—N/A
PRVPRV-281482026-04-25T08:54:12Z mark—lopez19-09-1954UHC-01657-31NULL(295) 957-4362··null810 Mesa Dr Apt 13SacramentoCalifornia··95812UNKNOWN—
PRV PRV-295192026-08-30T12:57:28ZStephen—West1942-02-06UHC-89184-93N/A+1 365 980 7490—1006 Market StreetHoustonTX77065—UNKNOWN
PRVPRV-215042026-07-09T03:13:53ZJanice—Robertson20070828UNKNOWN—15358439513UNKNOWN8290 BroadwayCharlotteNC28224N/Anull
PRVPRV-256932026-04-22T09:25:59ZdouglasYlynch02/10/1983UHC-36045-91-(609) 288-8751UNKNOWN365 Maple AveGILBERTAZ85275—UNKNOWN
PRVPRV-251852026-10-06T08:48:42ZMARK—LARSON—UHC-26773-88NULL14224014953-7442 Indian School RdScottsdaleAZ85223UNKNOWNN/A
PRVPRV-293172026-05-23T14:41:12ZLauren····Jackson2004-04-04····UNKNOWN·18903456751—7895 Harbor Boulevard·HoustonTX77066—-
PRVPRV-213712026-06-23T04:50:11ZLuis—Jimenez1980-12-13——19715252727null494 Harbor BoulevardPlanoTX··—UNKNOWN
PRVPRV-294382026-06-05T21:15:16ZWatson, JerryY—Apr 17, 1983nullNULL6833821024N/A7251 Grand AveSacramentoca95840NULL-
PRVPRV-274102026-05-10T04:55:33ZWatkins, Gloria—··1974-11-18UHC-01940-80—(571) 368-3133gloria.watkins63@yahoo.com7662 Church StreetSan Antonio··TX—NULL·N/A
PRVPRV-272822026-03-27T10:14:18ZKellyBWillis1971-12-19—•••-••-5524(303) 686-5245kelly.willis@icloud.com8540 Sage CourtLos AngelesCA90029UNKNOWNNULL
PRVPRV-251822026-02-07T16:09:01ZJudy··—Vega19960315-·UNKNOWN915-739-0906judy.vega@hotmail.com6161 Sage CtHoustonTX77009—UNKNOWN
PRVPRV-214192026-04-05T12:47:02ZOBrien, Mary——1951-01-03UNKNOWN-—MARY.OBRIEN61@YAHOO.COM6414 VALLEY VIEW DRIVEPlanoTX75074—-
PRVPRV-222662026-04-14T23:05:57ZDYLANJ··GUERRERO1944-04-17UHC-70949-33—15693645022NULL9202 Spring StLas Vegasnv89119UNKNOWNNULL
PRVPRV-221882026-07-28T17:58:32ZJooyce—VargasAug 24, 1953UNKNOWN•••-••-47669374552440JOYCE.VARGAS92@YAHOO.COM6679 Spring StreetNashvilleTN··37222UNKNOWN—
PRVPRV-253512026-05-18T02:48:26ZLinda—Lucas3/6/1951—•••-••-7169400.271.1136UNKNOWN·592 Jefferson AvenueTucsonAZ85761-UNKNOWN
9,596 rows, page 152 of 192PreviousNext

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