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
PRV PRV-237472026-06-14T04:24:15ZMelissa—Gonzalez1975-01-07uhc-79439-98•••-••-2325+1 440 695 8139—4070 Union StJACKSONVILLEFL32256-7653NULLN/A
PRVPRV-291712026-04-23T22:09:49ZKyle—Cook2001-09-07UHC-25023-44NULL—KYLE.COOK@HOTMAIL.COM9327 BROADWAYScottsdaleAZ85241-3124null—
PRVPRV-233492026-10-07T12:26:58ZLAWRENCE·KWEAVER1964-02-04UNKNOWNnull929-212-0024null3519 Church StTempe··AZ85219-1899nullN/A
PRVPRV-219472026-09-24T12:27:58ZJoyceP.Perry1972-09-08——··—9746 Ridge RdTucsonAZ85720nullN/A
PRVPRV-215032026-04-29T06:31:50ZDYLANBNUNEZ1999-04-17UHC-40902-19NULL18162583903dylan.nunez@gmail.com—N/A—--NULL
PRVPRV-245532026-09-04T22:16:14ZAaron—Fisher1993-10-26UHC-39898-77null+1 573 665 8265—··NULLnullN/AN/Amedicare-adv-a··
PRVPRV-248592026-02-18T15:31:59ZVincent—Ruiz1948-10-12·UHC2793126UNKNOWNN/A—3608 Cedar LaneAtlantaGA—NULL—
PRVPRV-267092026-07-20T08:15:08ZPriceJPriya19910909uhc-86266-54—(330) 857-3968·UNKNOWN7229 Harbor BoulevardDallasTX75289—-
PRVPRV-269262026-01-21T18:47:09ZHarper, Peter····—1957-04-15N/A•••-••-02572522107241PETER.HARPER@OUTLOOK.COM·4191 Grand AvenueColumbus·OH43284—CORE-HMO··
PRVPRV-226202026-04-22T12:59:21ZSRAH—HENDERSON16-04-1972UHC2413393•••-••-0811571-690-0431—8426 Cedar LnMesaAZ85238—NAVIGATE-HMO
PRVPRV-204922026-05-23T05:35:23ZKIMMRAMIREZ7/26/1979UHC-27862-28—545-572-7362KIMBERLY.RAMIREZ16@GMAIL.COM5718 SPRING STDenverCO80298—NULL··
PRVPRV-275172026-10-15T20:03:25ZRuth—Rose1997-12-20null•••-••-77429529317242ruth.rose30@outlook.com5846 WASHINGTON ST·MiamiFL33143NULLCHOICE-PLUS-PPO
PRVPRV-246932026-06-17T06:56:30ZSimmns, KaylaE—1946-05-05——4779048063null·5269 Ridge Rd #318GilbertAZ85223—NULL
PRVPRV-223482026-09-22T23:46:24Z Bryan··Ryan06/11/83—•••-••-02159684781122NULL—-——N/ANULL
PRVPRV-271512026-04-08T16:16:53ZCharlesPMurray1952-01-15—UNKNOWN—charles.murray@icloud.com8544 Apache BlvdNashvilleTN37208N/ACHOICE-PLUS-PPO
PRV PRV-221862026-09-09T19:14:34ZFoxKAhmed23-08-1977UHC-86795-06•••-••-3496+1 431 537 6219—NULLUNKNOWN·NULL——null
PRVPRV-275902026-04-23T23:16:07ZAlexander—Waltter1973-02-12UHC-88465-66——WALTER.ALEXANDER@YAHOO.COM7153 Lincoln Way··GilbertAZ85245N/A—
PRVPRV-249992026-07-15T21:27:09Z·Julia—Carpenter19390916—NULL8972660610UNKNOWN997 Baseline RdMESAAZNULL—NULL
PRVPRV-25398 2026-10-08T10:24:06ZTerryAMedina1965-00-28N/A··NULL(518) 433-0047—9633 Sage CtEDEN PRAIRIEMN55316-UNKNOWN
PRVPRV-257012026-10-11T02:37:38ZNANCY—DIXON19460313UHC1859321UNKNOWNnullnull9305 Ridge RdCharlotteNC28215··-
PRVPRV-226452026-05-06T01:24:55ZCHARLOTTE O.—·PETERSON1963-07-15UHC-11340-18··NULL658-862-6908charlotte.peterson@outlook.com·833 Central AveTempeArizona85243NULL-
PRVPRV-228612026-07-05T08:28:45ZfrancesDgraham··1971-04-22N/A—UNKNOWNUNKNOWN1867 Ocean AveNashvilleTNN/AUNKNOWNN/A
PRVPRV-26818 2026-06-02T04:18:57ZKARENY·WARREN1996-05-10UHC-86315-08•••-••-7462879-849-8790N/A4669 Church StHoustontx77071nullNULL
PRVPRV-229282026-04-19T11:56:47ZBOB··—HUNTER12/10/1967UHC-35728-26—(944) 845-7328ROBERT.HUNTER7@AOL.COM—··N/A····-MEDICARE-ADV-A
PRVPRV-216552026-02-08T07:09:42ZFranklin, Rebecca····—01/09/08UHC-18936-06—823-414-7070rebecca.franklin16@yahoo.com-nullN/A····UNKNOWN-
PRVPRV-287992026-10-01T08:05:26ZDenise··Pena19980810UNKNOWNNULL974.797.5952—8859 Lake View RdTucsonAZ85711——
PRVPRV-235232026-02-24T09:11:55ZElizabeth—Young1979-01-13UHC-34103-14—898-644-7921null6703 Sage Court Apt 14MiamiFL·33133—UNKNOWN
PRVPRV-263812026-03-10T02:59:59ZGeraldGLucas1969-11-12UNKNOWNnull(566) 414-3598gerald.lucas55@proton.me9328 Ocean AvenueColumbus··OH43234UNKNOWNUNKNOWN
PRVPRV-252192026-09-09T06:53:44ZArthur—Gibson1982-09-25UNKNOWN—293-305-6159·arthur.gibson98@aol.com6998 CEDAR LNAUSTINTXUNKNOWN-—
PRVPRV-280622026-09-10T12:24:27ZDOUGLASTHAWKINS19491014UHC-29754-96UNKNOWN6948184DOUGLAS.HAWKINS@HOTMAIL.COM9435 Harbor BoulevardNASHVILLETennessee37274N/Anull
PRVPRV-270982026-10-15T21:36:01ZOwens, Jean····—1956-07-14NULL··—934-283-6189null·4511 Cedar LaneSan DiegoCAUNKNOWNN/AN/A
PRVPRV-230922026-07-31T21:50:21ZHannah··—Watson1995-07-27UHC-44586-69··null7182887677UNKNOWN9895 Bayshore DriveSan AntonioTX78224-choice-plus-ppo
PRVPRV-235132026-05-03T21:05:22ZLawrence—Garza1959-02-09UNKNOWNNULL·226-702-1806lawrence.garza13@icloud.com6718 Park PlaceLAS VEGASNV89176NULLN/A
PRVPRV-269922026-02-16T10:45:38ZjuulieJgomez6/7/1941··UHC-08457-10—(750) 806-2634UNKNOWN5130 Bayshore Dr #696GilbertAZ85241-4015N/ANULL
PRVPRV-273702026-09-26T00:49:23ZLaurenZValdez7/9/1958—UNKNOWN2958685888—UNKNOWN—NULL··NULL····—
PRVPRV-238312026-04-16T17:43:52ZKarenKBarnes19930822N/A—(493) 540-2982-8434 Elm StreetDenverCO80299—N/A··
PRVPRV-295272026-02-21T05:29:29ZGeorgeY··Ramos1962-03-15———UNKNOWN2114 Willow CourtSeattleWA—NULL—
PRVPRV-257252026-01-14T11:52:35ZMariana—Munoz19710424UHC-53160-14NULL2672304254MARIANA.MUNOZ@PROTON.ME8127 DESERT SKY BLVDLos AngelesCA90086nullNULL
PRVPRV-202022026-01-17T18:40:06ZASHLEY—BROWN24-06-1940UNKNOWN—+1 669 679 9132NULL1274 RIDGE RDNashville·TN37257—NULL
PRVPRV-200442026-04-22T13:43:16ZSusan··—Guzman··1959-04-03UHC-20174-31•••-••-8726-NULL4331 Canyon RoadMesaAZ85287—OPTIONS-PPO
PRVPRV-226262026-02-26T14:56:10ZMARIANA—·MASON·19651217null-457.246.7847UNKNOWN7478 Mountain View DrJACKSONVILLEFL32270—N/A
PRVPRV-221692026-10-08T12:58:27ZRachel··—Watson1942-90-23UHC-77213-11—13512869184-1928 Camelback RdSAN DIEGOCA92132—UNKNOWN
PRVPRV-254992026-05-25T20:02:00ZRYAN—HERNANDEZ1959-01-19UHC-51810-13—(572) 709-4583RYAN.HERNANDEZ@ICLOUD.COM6988 SAGE CTCharlotteNC28205N/A-··
PRVPRV-250602026-08-17T22:43:29ZGraceY.Romero01/21/2000uhc-22850-73UNKNOWN15705514475null2205 Grand AveGlendale··AZ85300-—
PRV PRV-264202026-02-06T07:35:52ZValentinaRJacksonJan 20, 1965UNKNOWN•••-••-0208539-747-2494valentina.jackson@proton.me462 Lake View RoadEden PrairieMN·55367-8644—null
PRVPRV-272962026-01-04T11:45:23ZElizabeth—Meyer19610614N/A•••-••-3854—elizabeth.meyer86@proton.me——N/A··———
PRVPRV-253562026-01-26T13:47:13ZJames—Sanders2000-11-24—UNKNOWN(697) 677-5359UNKNOWN2275 SAGE COURTMinneapolisMN—-CORE-HMO
PRVPRV-215172026-06-20T05:54:55ZKATHERINE—SOTO1956-09-18·N/A—-—1461 Ridge RoadMesaAZ85235NULLnull
PRVPRV-200722026-02-23T22:47:16Z———08-11-1953—•••-••-9222(769) 420-5801larry.wilson@icloud.com9437 Valley View DriveDenverCO80280—N/A
PRV PRV-286592026-03-15T07:03:05ZBETTY—MURRAY1986-04-20··UHC-79482-59—+1 594 291 5107NULL6683 Market StColumbusOH43273—N/A
9,596 rows, page 104 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:49.127Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty