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-284812026-08-14T17:35:24ZDanielle··Diaz1947-03-24UHC-42957-15——UNKNOWN2992 Jefferson AveMiamiFL33121NULL··UNKNOWN
PRVPRV-271792026-06-26T19:50:56ZBILLYMBURNS1994-09-28UHC-06095-01•••-••-720716327330132N/A1909 RIVER ROAD·ColumbusOhio43251NULLnull
PRVPRV-218332026-02-04T17:56:25ZJASON—MORALES19471111UNKNOWNUNKNOWN(702) 997-8960N/A3993 Desert Sky Blvd·CharlotteNC28246-8371··—
PRVPRV-284082026-08-16T19:08:18ZDianaB.·Mills1972-11-19UHC-74388-14—8517641826—7835 BROADWAYAtlantaGA30342N/AUNKNOWN
PRVPRV-267582026-07-02T02:32:21ZRACHEL··XDANIELS1952-07-18null—201-785-5360NULL6715 Cedar LaneGlendaleAZ85312·UNKNOWN—
PRVPRV-212702026-01-13T17:15:41Z·CHARLOTTE—DAY1981-10-02···UHC-46549-70—UNKNOWNcharlotte.day29@aol.com···948 Valley View DrGlendaleAZ85303——
PRVPRV-201672026-06-15T23:42:12ZFrances—Wilson1940-10-21UHC-38544-97-3555813364null9472 WILLOW COURTMesaAZ85227—UNKNOWN
PRVPRV-254652026-04-04T02:07:46ZAARON····BELL04-07-1965nullnull+1 599 625 4481—5517 Desert Sky BlvdMiamiFL33162·nullN/A
PRVPRV-279912026-01-11T11:23:45ZwillieKherrera1938-05-16N/A—7809096523N/A6978 MOUNTAIN VIEW DRHoustonTX77029—N/A
PRVPRV-200252026-10-04T02:12:08ZMARI—ORTIZ1999-11-28UHC-72125-46-2369092219NULL5555 HARBOR BLVDJACKSONVILLEFL32241——
PRVPRV-264612026-03-07T13:04:09ZRYAN—GARRETT4/5/2005UHC-63270-32•••-••-9956UNKNOWN-7441 Market St·MINNEAPOLISMN55455N/A-
PRVPRV-224172026-05-02T23:58:20ZMichaelU.Wallace1939-08-27UNKNOWN•••-••-7523380-619-2914—1586 Cedar LnLOS ANGELESCA90049NULL—
PRVPRV-272542026-06-11T09:51:17ZSandra··OBrien1975-11-28null—4458089307·-6992 Jefferson AvenueFresnoCalifornia93777-NULL
PRVPRV-272922026-02-17T14:33:10ZFrances—Phillips10/25/1964null•••-••-4561935-898-2434—128 Union StreetFresnoCA93735UNKNOWNN/A
PRVPRV-258572026-01-23T04:54:14ZJoshua—Walker1948-12-24··null··NULL7144119642—1765 Lincoln WayORLANDOFL32806-4940—····
PRVPRV-257932026-02-10T17:48:48Z Laura—Evans1969-02-08UHC-98868-67—N/AN/A2369 Bayshore Drive·DALLASTX75253—··
PRVPRV-25829 2026-01-15T09:05:16Zsarah—nelson1981-10-23———SARAH.NELSON@HOTMAIL.COM2553 Canyon Rd Apt 25EDEN PRAIRIEMN55345UNKNOWN—
PRVPRV-208462026-07-08T00:10:20ZHannah—Young2001-02-22NULL•••-••-57933338285049N/A3496 Cedar LaneMinneapolisMN55481N/Anull
PRVPRV-215062026-02-21T22:59:28ZWILLIE··—LUCAS0204-19-18UHC4285165NULL14033989050WILLIE.LUCAS@PROTON.ME3884 PALM DRJacksonvilleFL32294——
PRVPRV-217242026-07-01T07:47:03Zdorothy····wagner1953-08-05—NULL242-497-5538—4345 MARKET STColumbusOH43207-8088-—
PRVPRV-266762026-03-30T05:38:14Ztommy—day19440221—null·+1 782 912 5892—1025 Mesa Dr Apt 24MIAMIFL33171NULLNAVIGATE-HMO
PRVPRV-290762026-01-18T09:51:59ZCAROLYN—MENDEZ27-06-1962—•••-••-3342932-294-4875NULL··———NULLnull—
PRVPRV-219982026-03-18T16:24:49ZWillie—·Books1964-08-16-—N/AWILLIE.BROOKS@ICLOUD.COM1402 Indian School RdLAS VEGASNevada89178NULLnull
PRVPRV-230662026-04-26T00:31:01ZPaul··Burke1956-05-24-•••-••-6273+1 940 535 5052NULL7574 APACHE BLVDEden PrairieMNnullNULLNAVIGATE-HMO
PRVPRV-238912026-01-25T06:28:49ZETHAN—COOK2003-03-18UHC-76119-12null16497947571—9366 Mesa Drive #982TucsonAZ85736UNKNOWNN/A
PRV PRV-213192026-08-26T12:05:49Z RussellRElliott·2002-09-26UHC-72403-52UNKNOWN7635165615-8498 Camelback RoadSan DiegoCA———
PRVPRV-215002026-05-08T07:14:48ZBILLY—MORGAN··1977-10-28UHC-03233-84—18478182485·BILLY.MORGAN@AOL.COM2010 Union StreetDenverCO80224··—UNKNOWN
PRV PRV-293362026-07-12T10:23:10ZralphWwood—UHC-68877-11NULL+1 290 829 9688ralph.wood84@proton.me5440 Lake View RdCharlotteNC28250-null
PRVPRV-25666 2026-10-13T20:36:43ZGERALD—LITTLENov 14, 1996UHC-94042-51•••-••-66886915941652GERALD.LITTLE@OUTLOOK.COM3476 Ocean AvenueColumbusOH43297NULLUNKNOWN
PRVPRV-233712026-05-15T12:30:58ZCheryl S.—Lee11/25/57null•••-••-7339779.565.4448CHERYL.LEE59@HOTMAIL.COM6438 Baseline RdDallasTX75245··—·OPTIONS-PPO
PRVPRV-265772026-04-20T11:31:53Z Abigail—Gilbert19890404N/A•••-••-8825(648) 253-7887NULL937 Canyon RdOrlandoFL32841N/A—
PRVPRV-200962026-08-19T02:20:14ZPhilip··Cole1991-03-27·N/A—4138016940—4966 FOREST AVENUE·DenverCO80283-—
PRVPRV-282672026-08-26T12:35:46ZOBrien, AdamX.—19820402NULL····nullNULL··4314 SUNSET BOULEVARDCHANDLERAZ85208-··N/A
PRVPRV-264312026-03-16T13:25:26ZTeresaDSimpsonApr 18, 1957—•••-••-76279591430····1259 MOUNTAIN VIEW DRIVEOrlandoFL32820UNKNOWN··CORE-HMO
PRVPRV-276492026-04-18T20:49:33ZDeigo—Turner1988-02-28-—(976) 730-2887—8225 Union Street Apt 32TampaFL···33644UNKNOWNNULL
PRVPRV-23673 2026-06-08T11:27:32ZAndrea··T·Collins1946-06-16UHC-15673-23-9066617904ANDREA.COLLINS@OUTLOOK.COM1925 Forest AvenueChandlerAZ85211-6114··—N/A
PRVPRV-290852026-10-03T09:18:13ZKAYLA—HOFFFMAN05/06/1944N/A··—534-345-9050-8332 Camelback RoadHOUSTONTX77010—NAVIGATE-HMO
PRVPRV-23476 2026-05-24T18:20:23ZGreene, Rebecca——2006-05-05UHC-66153-41--REBECCA.GREENE@GMAIL.COM3070 Palm DrTampa·FL33694——
PRVPRV-216162026-07-26T21:15:05Z Lawrence—Sullivan2001-12-01UHC-85120-50UNKNOWN(767) 352-0462lawrence.sullivan55@aol.com8018 Elm StHoustonTexas77033nullMEDICARE-ADV-A
PRVPRV-294312026-09-30T10:19:31ZChristian··QWheeler1976-08-08—•••-••-84652552216963—6628 Lincoln WayTAMPAFL33620UNKNOWN—
PRVPRV-269002026-03-25T20:27:53ZHIROSHIA.GREENEMar 25, 1999N/AN/A759-852-1273hiroshi.greene78@gmail.com2623 Maple AveLAS VEGASNevada89176—NULL
PRVPRV-258902026-09-10T12:24:34Zadam—hughes··1974-04-05NULL—·+1 757 225 3575UNKNOWN4667 Sunset BlvdSacramentoCA95821-4408UNKNOWN-
PRVPRV-272612026-03-24T04:55:53ZWilliam—Rivera1971-03-13UHC-47674-88—(512) 281-0729—————NULL—
PRVPRV-217642026-07-06T12:50:29ZEmmily—Wong1977-02-10NULL—527-868-7953—3028 Maple AveTampa··FL33624··——
PRVPRV-27126 2026-04-16T05:17:14ZAISHA—HARVEY··02/02/1979UHC-39601-09—229.298.8233AISHA.HARVEY@YAHOO.COM4208 Main StDallasTX75211-2361··—NAVIGATE-HMO
PRVPRV-219562026-02-10T13:01:56ZSofia—Greene19760520UHC-16642-19•••-••-44096953071UNKNOWN6125 Apache BoulevardDENVERCO80239-SELECT-EPO
PRVPRV-255792026-01-07T22:16:02Zcheryl—silva··1960-05-07—UNKNOWN3079752556—7117 Central AveGilbert··AZ··85287UNKNOWNCHOICE-PLUS-PPO
PRVPRV-276182026-09-10T18:23:11ZMatt—Morrison1950-04-22UHC1168947-4068912755null9655 Sunset BlvdEden PrairieMNNULLNULLNULL
PRVPRV-249182026-08-08T11:59:11ZStephen—Harper0029-19-62null•••-••-40767394339917N/A4259 PINE DRIVESeattleWANULLNULL—
PRVPRV-279802026-08-08T03:46:03ZNicholasHLe19770515null-(857) 739-6860—4494 SPRING STOrlandoFL32812NULLCORE-HMO
9,596 rows, page 85 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:46.087Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty