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-264932026-05-07T19:54:10Z Philip—Olson9149-06-10NULL-7279844001··philip.olson30@yahoo.com3574 LAKE VIEW ROAD·CHANDLERAZ85210—-
PRVPRV-233912026-08-02T04:51:22ZKimberlyY··Vazquez1959-02-18UHC-98212-72··—903.552.7908kimberly.vazquez7@icloud.com7007 CHURCH STMesaArizona85246-2816NULLN/A
PRVPRV-254682026-03-25T14:34:05ZMARTHAJGONZALES1950-02-07UHC-87872-07—363-817-4099NULL·8970 Spring StreetSACRAMENTOCA95806UNKNOWN—
PRVPRV-284872026-03-21T08:29:04Z—V.—2008-07-06UHC-92465-76-5184484802N/A7467 Bayshore Dr #804DallasTX75292—-··
PRVPRV-237782026-07-22T19:04:59ZJESSICA—SNYDER7/6/1964UHC-92417-51-209-537-1111-7170 DESERT SKY BOULEVARDSacramentoCA95866nullN/A
PRVPRV-208552026-02-15T21:17:05ZPaul··Fiser1946-10-26UHC-29098-94—6037062710—4494 LAKE VIEW ROADMinneapolisMN55458NULL—
PRVPRV-283142026-01-29T17:43:41ZJORDAN—GEORGE1960-06-18UHC-08759-60null8976160146—6040 Bayshore DriveScottsdaleAZ85268NULLNULL
PRVPRV-248192026-03-07T06:32:24ZDebra—Ray1978-06-08UHC-45020-13·UNKNOWN271-376-2726—5864 Sage CtMinneapolisMNUNKNOWN—NULL
PRVPRV-201942026-03-30T01:28:35ZDebraMOrtiz1977-11-15N/AUNKNOWN(246) 673-2668debra.ortiz@gmail.com2295 Highland AveSAN ANTONIOTX78205—·N/A
PRVPRV-288502026-05-31T20:41:04ZEvelyn····Kim·18-05-1991UHC-97183-17•••-••-3126+1 862 711 0973—3615 Palm DriveSeattleWA98117····UNKNOWN
PRVPRV-220072026-08-03T15:47:44ZPhilip—Woods2001-02-24—N/A987-717-7326UNKNOWN8935 Valley View DrEden PrairieMinnesota55320nullN/A
PRVPRV-238932026-03-12T19:19:56ZLauren—Shaw1997-08-15UHC-70188-66—(601) 416-9084-2823 Spring StreetLOS ANGELESCA·90095-3515-····
PRVPRV-254012026-09-01T18:53:45Z———5/18/1965——254-788-0228—·1428 Maple AvenueOrlando··Floridanull—OPTIONS-PPO
PRVPRV-200812026-10-17T21:14:56ZBrian—Guerrero1957-04-21UHC-34537-90•••-••-1010958-614-8168··8900 Sunset BlvdLos AngelesCA90067-UNKNOWN
PRVPRV-203262026-03-16T06:18:59ZFRANCES—WILLIAMSON1987-05-23NULL•••-••-13425116349753·null128 Desert Sky BoulevardMiamiFL33180-6565N/ANAVIGATE-HMO
PRVPRV-284152026-08-31T11:57:59Zfrances—carlsonFeb 26, 1966UHC-63471-05··—512.897.1480N/A6154 GRAND AVENUETampa·FL33608—NULL
PRVPRV-286252026-08-22T23:59:00ZAmberCBishop1950-04-19UHC-03362-75•••-••-26862052293003UNKNOWN5736 Sage CtDallasTX75236··—N/A
PRVPRV-277692026-02-01T00:48:45ZChristian·JJenkins1986-08-22null•••-••-4075933-783-6522christian.jenkins@outlook.com5840 BROADWAYMesaAZ-——
PRVPRV-287252026-09-25T09:36:50Zjesse—lewis1976-02-19UHC-25390-99-780-454-2217JESSE.LEWIS30@OUTLOOK.COM2263 Oak StGilbertAZ85233—-
PRVPRV-238142026-03-18T08:45:09ZSamuelQLnych12/12/81·UHC-18157-27UNKNOWN(730) 634-4799samuel.lynch7@hotmail.com689 Market StPLANOTX75095-5845——
PRVPRV-235402026-04-18T04:59:53Zdiego—fox1994-05-06··NULL-778-955-3363—51 Washington StSan Diegoca92115—null
PRVPRV-210062026-02-02T21:35:18Zpriya—larson12/13/1975UHC-56071-01—(443) 760-3942UNKNOWN··9198 Pine Dr··NashvilleTN37232—SELECT-EPO
PRVPRV-244372026-09-12T18:17:57ZRalph—Oliver1995-03-26NULL———1949 SPRING STREETLos AngelesCA90061-0735—-
PRVPRV-277512026-01-01T18:18:33ZHENRY—JIMENEZOct 23, 1985UHC-49218-90UNKNOWN9019579852—2837 Maple AveSan AntonioTX78242NULL-
PRVPRV-25128 2026-02-28T02:21:28ZALEXIS—WALKER19620715UHC-81179-53•••-••-5550(371) 567-9556—2604 Highland AvenuePHOENIXAZ85013NULLCORE-HMO··
PRVPRV-285622026-08-30T01:27:29ZLisa—Taylor1983-09-14UHC-20686-86-2418473837null1069 BASELINE ROADEden PrairieMN55389-—
PRVPRV-257282026-08-17T13:00:36ZJosephODelgado·May 26, 1980UHC9305758··(516) 380-7761N/A7648 JEFFERSON AVESan DiegoCA92159····null
PRVPRV-290522026-06-14T14:34:46ZJonathan—Simmons1988-05-11UHC-03464-95•••-••-2480791-515-0208UNKNOWN4316 Mesa DrNashvilleTN··37252——
PRVPRV-252762026-08-14T19:04:57Zjordan—mitchell··1999-01-13UHC-41287-90•••-••-2341(913) 883-8022JORDAN.MITCHELL@YAHOO.COM882 Lake View RoadDallasTX75281—-
PRVPRV-287412026-03-28T15:42:25ZVALENTINA—PERRY7/19/1958null•••-••-97836945792409NULL4222 MAPLE AVENASHVILLETN37234-MEDICARE-ADV-A
PRVPRV-283582026-07-18T05:28:44ZMatthew··PRodriguez1955-09-11null······(683) 875-4255—9408 Bayshore DrMinneapolismn55447—null
PRVPRV-230992026-05-18T06:13:57ZGREGORYQHUDSON1954-02-04N/A··535-636-8820—8058 MAIN STREETNashvilleTennessee37262-1164UNKNOWNMEDICARE-ADV-B
PRV PRV-238752026-07-24T02:57:10Z FrancesBCarpenter1989-07-13—····12789370578NULL1399 MOUNTAIN VIEW DR·Planotx75046——
PRVPRV-206252026-09-16T08:12:50ZBruce··Johnston1957-08-10UHC-32734-85NULL12452831145—3273 Harbor BlvdDallas·TexasN/A—null
PRVPRV-217892026-09-14T09:36:41ZJake—Kim—UHC-20478-93N/A617-664-3822NULL·9324 Indian School RdCharlotteNorth Carolina——NULL
PRVPRV-225662026-06-02T20:59:42ZMARIANA—MORRISON··1960-07-32UHC-48094-21N/A18743343898NULL8632 MESA DRIVEChandlerAZ85261N/Anull
PRVPRV-23848 2026-08-06T23:25:26ZJoan—HamitlonSep 16, 2005—-N/AUNKNOWN9063 Central AveColumbusOH··43210nullNULL
PRVPRV-248052026-02-22T23:34:34Z Carlos—Ryan1989-06-02N/A·NULL3289946—814 Meadow LaneMESAAZ··85290UNKNOWNMEDICARE-ADV-A
PRVPRV-26063 2026-05-14T23:19:21Z·GLORIA—JOHNSON1987-03-02——(696) 521-4868gloria.johnson@proton.me3218 Hillcrest RdOrlandoFL32826UNKNOWNN/A
PRVPRV-268652026-10-08T14:38:29ZMark··—Larson1950-01-25——17448255384mark.larson2@outlook.com4811 Pine DrSEATTLEWA98125NULL—
PRVPRV-241032026-09-05T23:17:46ZWalterFFlorse1966-11-05nullnull460-477-2449walter.flores43@gmail.com4465 JEFFERSON AVENUEHoustonTX77058——
PRVPRV-240752026-10-06T15:05:15ZDAVIDI.HERNANDEZ6/28/1987UHC-79977-02UNKNOWN··3086821david.hernandez@aol.com8201 CAMELBACK RD·OrlandoFL··-UNKNOWNNAVIGATE-HMO
PRVPRV-232272026-05-07T13:13:39ZGreen, Mark——10-09-1981—•••-••-807514616697548—1449 MAPLE AVENUELos AngelesCA90008—·CHOICE-PLUS-PPO
PRVPRV-271242026-03-05T06:14:18Zteresa—murphy19671009UHC-72939-67•••-••-4548—null--—N/A——
PRVPRV-245952026-05-17T15:06:26Z Gregory—Howard1941-03-20N/A··—820-243-9409gregory.howard@yahoo.com101 MAIN STREETTucson·AZ85777UNKNOWNnull
PRVPRV-232992026-04-05T10:30:46ZAnthony—Guerrero··Nov 10, 1972NULLN/A12622920400anthony.guerrero@proton.me—·nullNULL—-—
PRVPRV-235602026-03-20T07:19:13ZJustinCGonzales9/12/1962UHC-43830-36•••-••-01435762342993JUSTIN.GONZALES15@PROTON.ME2916 Broadway··SEATTLEWA98115UNKNOWN—
PRVPRV-231762026-09-25T08:57:48ZGABRIEL—FERGUSON1942-03-27UHC-41111-77—N/AUNKNOWN8354 RIVER RDPlanoTX75087NULLN/A··
PRVPRV-249192026-01-30T14:13:02ZDeeborah—Price··1940-11-15UHC2730407-3907276725deborah.price@hotmail.com6605 Highland AvenuePHOENIXAZ85095null-
PRVPRV-262942026-04-01T21:37:34ZVirginia—Clark1956-11-05UHC-07844-60UNKNOWN3832297394NULL8280 FOREST AVENUEPhoenix·AZ85031-4371UNKNOWN····
9,596 rows, page 131 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:53.727Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty