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-258772026-02-27T22:35:14ZMurray, Jack——1958-06-16UHC-23811-56·-9144912283JACK.MURRAY@PROTON.ME3124 SUNSET BLVD Apt 19·HoustonTX77011NULLnull
PRVPRV-28323 2026-07-05T21:24:09ZSarah—Lewis2001-04-11UNKNOWN—584-227-1463sarah.lewis@hotmail.com2010 SUNSET BOULEVARDDallasTX75240N/A··NULL
PRVPRV-221972026-05-31T03:50:11ZGloria—Fowler1964-09-07—UNKNOWN—··6908 SAGE CTTucsonAZ85753—OPTIONS-PPO
PRVPRV-20059 2026-06-16T03:30:40ZLAURA—WOOD2002-09-06—•••-••-2174719-607-3533NULL··2088 Union StSeattleWA98145····MEDICARE-ADV-A
PRVPRV-284252026-07-12T20:52:04ZJordan····Wood05/05/2004-•••-••-3299(403) 642-7703N/A7709 Park Pl··DallasTX75285UNKNOWN—
PRVPRV-22237 2026-08-08T09:56:27ZDaniel—Wong1981-07-10UHC-33833-96—·19673669916NULL4430 Meadow LnJacksonvilleFL32235-CORE-HMO
PRVPRV-263872026-07-25T06:39:03ZMendez, Patrick——1963-09-16··NULL-··7300077··-··6528 Church StreetPlanoTX75099NULL—
PRVPRV-225422026-06-01T07:16:23Zmei—hicksJun 5, 1988——2482948291null8342 LAKE VIEW RDChandlerAZ85284nullnull
PRV PRV-245602026-09-07T18:43:45ZPadilla, MadisonT.—11/07/1968nullnull4164693978—6184 RIDGE RDMiamiFL33178—-
PRVPRV-288232026-09-24T02:58:26ZZACHARY—HARVEY1982-02-22--9485635188null9098 Oak Street Apt 16DALLASTX···75260-5081null—
PRVPRV-241052026-02-25T19:34:45Z ·Danielle—Andrews1952-11-02UHC-05813-34null3413261209—247 Camelback RoadEDEN PRAIRIE··MN55393—-
PRVPRV-229852026-09-19T11:55:15ZweiN.berry1983-09-09UHC-57906-75•••-••-48957145231338—1615 INDIAN SCHOOL RDEden Prairie··MN55342N/ANAVIGATE-HMO
PRVPRV-246872026-01-16T23:39:46ZAustin—Simmos1962-05-06UHC8427059NULL(302) 274-1832·-—-————
PRVPRV-234692026-09-18T23:27:37ZBRRITTANY—DIAZ1974-03-08—UNKNOWN3276912675UNKNOWNNULLNULLN/A—UNKNOWN-
PRVPRV-213232026-03-15T23:53:30ZKenneth—Jordan9163-09-22null··N/A8552864UNKNOWN——nullN/A··NULL
PRVPRV-211522026-03-23T14:53:27ZRyan—Jimenez1955-06-10UHC-81271-92N/A·2765095753···2708 FOREST AVE Apt 1Denver·CO80294—-
PRVPRV-287172026-02-14T13:56:09ZSandraGHart1957-12-16UHC-88610-44N/A+1 950 839 7903SANDRA.HART@HOTMAIL.COM9810 Jefferson AveSan DiegoCA92119N/A-
PRVPRV-274662026-10-10T19:25:02ZJEAN—LONG1952-07-08null•••-••-9887+1 222 875 6796null6765 SPRING ST·MesaAZ85238--
PRVPRV-203332026-09-29T07:17:28Z Stephanie—Hayes20-10-2007··UHC-72841-28—UNKNOWNstephanie.hayes@outlook.com403 WASHINGTON STHoustonTexasNULL··—
PRVPRV-230712026-06-02T13:19:30ZMendoza, Lucia S——1978-09-11UNKNOWN····7059742980--null—--NULL
PRVPRV-259582026-09-24T08:31:40ZMadisonCFlores0179-19-75··UHC-58663-08•••-••-06624069253912MADISON.FLORES50@HOTMAIL.COM4481 MOUNTAIN VIEW DRIVEGilbert·AZ85252-·UNKNOWN
PRVPRV-216542026-04-05T22:13:59ZDorothy—Herrera04/24/1952——·5718948DOROTHY.HERRERA@ICLOUD.COM6298 BroadwayFresnoCA93767-0198null··
PRVPRV-216892026-03-17T06:57:17ZJack—AndersonApr 4, 1952NULL—(714) 720-4119UNKNOWN339 Broadway·Las VegasNV89117··-—
PRVPRV-221592026-04-10T18:59:02ZMeyer, Christina——09/22/1958UHC-53968-37•••-••-70547853766672christina.meyer7@hotmail.com9661 MAPLE AVENUESacramentoCA95861nullMEDICARE-ADV-B
PRVPRV-223062026-07-14T03:34:24Z sandra—yang10/20/61UHC-18320-22•••-••-9273379-499-7151—4320 Ridge RdTAMPAFL33693—N/A
PRVPRV-209262026-02-09T23:02:58ZGray, Philip——10/06/1948UHC-41519-25—(857) 417-0224—9035 Willow CtSeattleWashington98164··NULL—
PRVPRV-233322026-05-09T05:06:09ZJOE·GPRICE10-11-2002UNKNOWN-5697032602joseph.price49@proton.meNULLUNKNOWNN/AUNKNOWNUNKNOWN—
PRVPRV-280092026-08-19T08:14:47ZTheresa—King1961-07-13UHC-01570-93—440-410-2326—8709 MAIN STREETAtlantaGA30319—MEDICARE-ADV-A
PRVPRV-214042026-01-22T06:26:52ZBRENDA—JOHNSTON19960124—-878-425-8724brenda.johnston56@outlook.com1490 River RdTampaFL33656nullSELECT-EPO
PRVPRV-233102026-02-16T01:03:29ZJERRY L—RILEY10/02/1941—N/A19317839840null··4607 Pine DrCharlotteNorth Carolina28214—-
PRVPRV-213002026-03-20T06:34:42ZTIMOTHY—TRAN1958-04-25NULLUNKNOWN465-764-5355··-5906 APACHE BOULEVARD #357GlendaleAZ85384——
PRVPRV-224622026-02-07T14:22:59Zjanet—holems2001-05-05N/A····7608132571··-5096 River RoadLas VegasNV89148—NULL
PRVPRV-233882026-10-03T22:51:37ZRaymond—Patterson09/28/38UHC-88717-54N/A··(222) 799-5434UNKNOWN8662 Sage Ct #505ChandlerAZ85251——
PRVPRV-273572026-01-25T19:38:41ZRALPH—MORRIS1971-12-28null·-471-973-9793ralph.morris71@aol.com2055 Forest Ave··Austin··TX·UNKNOWN—null
PRVPRV-260282026-02-13T08:13:22Zsean··young07/27/2007UHC-50316-40NULL—UNKNOWN3421 Indian School RoadPhoenixAZ85060nullMEDICARE-ADV-B
PRVPRV-202132026-03-03T07:23:48ZAbby—Simmons·06/10/53—-801-362-9545—749 Canyon RoadJacksonvilleFL32209nullNULL
PRVPRV-205482026-04-15T22:27:28ZRYAN—PALMER1964-12-15null•••-••-2077+1 442 568 0312null452 Union StSeattleWashingtonUNKNOWNNULLNULL
PRVPRV-212512026-01-09T02:42:41ZJOYCED··RAMOSJan 6, 1952nullNULL567-760-9145·joyce.ramos@proton.me471 SPRING STLas Vegasnv89109—N/A
PRVPRV-281162026-02-27T13:23:46ZCharlotteZSilva··01/27/2007UHC-82786-43null·2937090294CHARLOTTE.SILVA51@AOL.COM822 Lake View RoadFRESNOCA93739UNKNOWN—
PRVPRV-223522026-01-26T00:38:53ZAngelaXCook1991-02-93UHC-77530-85N/A(442) 519-2779null5523 FOREST AVENUETucsonAZ85721-5115···--
PRVPRV-263892026-02-28T00:42:34ZArjun—Lynch19670085UHC-91859-94NULL(896) 286-6870····1503 SPRING STDenverColorado80249··NULLNAVIGATE-HMO
PRVPRV-284792026-05-01T05:46:01Zjanice····garrettFeb 15, 1959UNKNOWN•••-••-7800352-450-7434UNKNOWN2391 River RdPlanoTX75045—medicare-adv-b
PRVPRV-289602026-08-26T17:53:00Z·BARBARA—STEVENSAug 17, 1977—•••-••-7276(250) 299-0466—720 Main StLas VegasNV89150—OPTIONS-PPO
PRVPRV-235312026-05-19T06:09:08ZArmstrong, Russell··U—4/21/1968UHC-31168-68··-19105869820—7959 Sunset BlvdCOLUMBUSOH43203-OPTIONS-PPO
PRVPRV-278822026-08-03T01:11:14ZSteven—Foster12/16/76N/AN/A(922) 816-4470STEVEN.FOSTER@YAHOO.COM2034 BROADWAYJacksonvilleFL32297——
PRVPRV-267192026-02-15T14:50:28ZTerry··West1982-11-25NULL-8299365UNKNOWNN/A——N/AN/AN/A
PRVPRV-265642026-03-10T10:59:08ZSchultz, Hiroshi——1978-07-23NULL—(987) 390-4263··hiroshi.schultz46@aol.com2330 Palm DrivePhoenixAZ85079-UNKNOWN
PRVPRV-276362026-08-16T03:58:38Z kathryn—warren1959-03-12N/Anull3167136460—6289 Jefferson AvenueLos AngelesCA90013-5007N/AUNKNOWN
PRVPRV-230032026-04-03T13:34:59ZBrooks, Elijah——1974-10-23UHC-94363-43•••-••-3319(444) 758-4070—2057 Grand AvenueScottsdale·AZ85240——
PRVPRV-258602026-02-10T19:27:11ZMarcus—Bruns09/19/66UHC-37882-51•••-••-264514782927645NULL2113 Washington StColumbusOH43279——
9,596 rows, page 108 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:52.216Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty