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-233362026-05-04T04:20:39ZAhmedIPatal·2005-02-09··-+1 612 397 0918ahmed.patel51@icloud.com7258 Apache BoulevardAustinTXUNKNOWN··UNKNOWN—
PRVPRV-286702026-04-13T23:10:18ZKEVIN··—PATEL1986-11-19UHC-81454-64—13803598482null6854 PARK PLSEATTLE··WA98140UNKNOWNUNKNOWN
PRVPRV-281512026-07-02T16:46:51ZAUSTIN—GIBSON1985-01-01NULLNULL(987) 451-1269····———-—null
PRVPRV-270262026-01-12T01:36:58ZBRANDON··ROBINSON1952-09-16·UHC-78201-84-13552868027UNKNOWN··5826 Jefferson AveTEMPEAZ85218-null
PRVPRV-235612026-01-04T20:02:45ZMcDonald, Keith··——1941-01-01UHC8212406N/A(416) 591-3789UNKNOWN1076 Apache BlvdSacramentoCA95814N/AMEDICARE-ADV-B
PRVPRV-236792026-08-24T21:58:51ZDick—Cook1966-07-15UHC1207907UNKNOWN+1 772 457 5059UNKNOWN3480 MOUNTAIN VIEW DRIVETampaFL33695NULLNULL
PRVPRV-25956 2026-03-14T17:53:06ZLaura—Cooper2007-11-04—N/A3596564023—1831 WILLOW CTSAN DIEGO·California92106—null
PRVPRV-251602026-08-14T10:22:56ZAMANDA—WEAVER2008-06-06··N/A•••-••-11606942664323AMANDA.WEAVER@YAHOO.COM7895 PARK PLACEPLANOTX75007NULL—
PRVPRV-250632026-08-20T16:43:26ZRuthT.Martin1995-04-11UNKNOWNUNKNOWN··7974100469RUTH.MARTIN38@ICLOUD.COM3526 Maple AvenueTUCSONAZ85762——
PRVPRV-222512026-04-14T20:01:34ZSchultz, Patricia——Nov 24, 1940UHC-79313-90N/A414-506-7073UNKNOWN8206 UNION STREETDenverCO80296nullUNKNOWN
PRVPRV-226752026-07-20T11:13:52Z JANICE····MARSHALL1952-09-07UNKNOWN—·16509203588N/A2157 HIGHLAND AVENUEScottsdaleaz85251N/ASELECT-EPO
PRVPRV-282572026-10-03T23:39:41Z Grace··—·PhillipsSep 14, 1971N/ANULL380-560-8428GRACE.PHILLIPS@AOL.COM··1782 VALLEY VIEW DRFresnoCalifornia93704NULLUNKNOWN
PRVPRV-216782026-09-12T07:09:01ZJoeA··Hamilton2003-10-17UHC-71097-95N/AUNKNOWN··null9027 Central AvenueSacramentoCANULL-null
PRVPRV-280882026-09-05T10:47:36ZChristian····Kennedy1989-04-16·-•••-••-2247——7388 Canyon RdSan DiegoCA92110N/AN/A
PRVPRV-292882026-05-07T11:05:54ZMei—Santiago··1972-08-04——865-579-2346null2981 SPRING ST··SacramentoCA··95857nullUNKNOWN
PRVPRV-282692026-06-30T04:56:55ZJesse····Bker01/05/85UHC-05897-89——UNKNOWN6412 LINCOLN WAYHOUSTONTX77033—null
PRVPRV-280902026-02-18T05:37:47ZSofiaG···Price08/23/70NULLnull728-803-8801sofia.price9@icloud.com2370 Spring StreetPhoenixAZ85001-—
PRVPRV-246202026-05-01T11:22:37ZBradleyXVazquez07/07/89UHC-39551-61null(397) 947-9721UNKNOWN1527 Cedar LnPlanoTexas75044UNKNOWN··null
PRVPRV-244642026-06-30T09:58:10ZEDWARD—GARCIA1942-12-09UHC-82255-21•••-••-5684481-860-2544—5691 Lincoln WayAustinTX··78786-0032UNKNOWN—
PRVPRV-288102026-05-07T02:13:26ZVALENTINA—WILLIAMS1982-09-21N/AN/A(928) 651-2546··valentina.williams@yahoo.com8185 Mesa DrColumbusOH43287null··NULL
PRVPRV-216932026-05-03T09:19:47ZAhmed—·Turner1971-09-27UHC-43070-49N/A686-824-2048—7916 Bayshore Dr··Mesaaz85211nullNULL
PRVPRV-288412026-04-04T04:12:11ZNicholas—Bishop2008-12-10—nullN/A—·7846 WASHINGTON STREETScottsdaleAZ·85281null··MEDICARE-ADV-A
PRV PRV-214152026-02-25T08:43:46ZDeaan, Catherine——19960717UHC-12425-81N/A(738) 994-2638catherine.dean36@outlook.com3457 Broadway·San AntonioTX78206—null
PRV PRV-259612026-02-28T12:28:53ZISABELLA—·BARNES11-03-2006null—+1 408 671 5531—1853 OAK STMesaAZ85252N/AMEDICARE-ADV-A··
PRVPRV-245982026-02-26T08:23:23ZLori—Roberts··1999-01-04UHC-78605-17N/A··NULLN/A9741 Canyon RoadHOUSTONTexas77071N/AN/A
PRVPRV-226282026-05-16T23:16:30ZMei—Johnston05-01-1938··UNKNOWNnull15093151717N/A3813 Sunset BoulevardCharlotteNC28243-6737—-
PRVPRV-241772026-08-09T22:21:53ZPaul··—Collins1958-04-25UHC-68079-95•••-••-8802770-546-5499··null2464 CENTRAL AVESan DiegoCA92124-4875N/AN/A
PRVPRV-270122026-09-30T07:11:47ZDennis—Alvarez1979-08-21-—N/Adennis.alvarez@hotmail.com3110 Desert Sky BlvdPLANOTexas75063UNKNOWN—
PRVPRV-252262026-03-09T20:53:54ZJACOB—WALKER1999-02-27UHC-50958-96UNKNOWN4869501794-2767 HIGHLAND AVENUEScottsdaleArizona85250UNKNOWNUNKNOWN
PRVPRV-251912026-09-05T23:07:57ZELIZABETHRFISHER0303-15-95··NULL—3406818983—8427 Main StJACKSONVILLEFL32260-MEDICARE-ADV-B
PRVPRV-247022026-05-01T19:23:02ZAaronTSimpson2005-05-22·UHC-21933-26•••-••-2495+1 643 981 7281aaron.simpson1@aol.com659 WASHINGTON STREETMIAMIFL33175NULL··UNKNOWN
PRVPRV-249592026-08-30T17:54:39ZKayla—·Riley2002-07-20UHC-81765-33—(415) 234-2567kayla.riley20@aol.comN/AN/A··NULLN/AMEDICARE-ADV-B
PRV PRV-258692026-05-05T17:30:11ZLAUREN··MCCOY1946-01-06——545.943.7491·null692 SPRING STCharlotte··NC··28248NULLnull
PRVPRV-225452026-05-28T03:54:14ZWALTERH.FULLER1957-07-01UHC-25159-18N/A246-798-4713walter.fuller@outlook.com1122 Camelback RoadATLANTAGA—UNKNOWN·N/A
PRVPRV-253882026-08-07T15:27:30Z·mariaPallen1981-07-03uhc-99806-87•••-••-6814UNKNOWN—5825 Mountain View DriveAustinTX78742N/A-
PRVPRV-249352026-05-04T17:15:32ZLARRYYGARZA1975-06-15UHC-05817-30—2948228165—3322 LINCOLN WAYLas VegasNV89127nullnull
PRVPRV-247812026-01-06T17:06:06ZRyan—Elliott··07/01/62null—18323083910NULL5526 Sunset BoulevardSan AntonioTX78260-—
PRVPRV-245642026-10-15T12:53:50ZJeffrey—Gardner1959-02-16UHC0804617•••-••-0269N/A—9517 Highland AveTampaFL33671-—
PRVPRV-283402026-10-10T04:44:32ZJessica··Q.GrahamJan 22, 1994NULL—+1 721 663 7331·jessica.graham@outlook.com·8488 Market StGlendaleAZ85307—UNKNOWN
PRVPRV-203922026-10-11T04:49:29ZShirley—Matthews6/25/1944null··—·689-600-6834SHIRLEY.MATTHEWS84@YAHOO.COM———N/AN/A··UNKNOWN
PRVPRV-228702026-03-03T19:27:43Zemma—·pena1947-04-06—-4212570652—8350 Oak Street·COLUMBUSOH43242——
PRVPRV-229932026-01-21T08:57:00ZOlson, Megan——19451028UHC-31741-46null6704101226—3348 Ridge RoadLos AngelesCA··90097UNKNOWNCORE-HMO
PRVPRV-277822026-09-11T09:29:21ZRachel—Kennedy1975-07-09·nullnull942.624.0881··—8703 Park Place··PhoenixAZ85029····—
PRVPRV-254972026-03-01T01:17:42ZRuthIMaldnoado1989-07-03·nullNULLUNKNOWNruth.maldonado@hotmail.com1565 LAKE VIEW ROAD·PlanoTX75097-N/A
PRVPRV-281042026-07-09T18:57:19ZRaymond—Phillips01/28/95UHC-34319-11N/A(403) 734-1297—1479 Baseline RoadGlendaleAZ85314nullN/A
PRVPRV-277042026-07-30T19:00:34ZGarza, Hiroshi——2005-11-05UHC-77416-36-8065786361··3626 INDIAN SCHOOL ROADPlanoTX75018·····null
PRVPRV-279412026-09-04T05:48:44ZMARILYN—GUERRERO1997-05-12UHC2979832··NULL931-566-3424—3267 Mesa DriveOrlandoFL32804—N/A
PRV PRV-238722026-03-02T15:01:40Zedward—holmes1960-12-14UHC-55851-37•••-••-443912157943393NULL1254 Jefferson AvenueGLENDALEAZ85360-OPTIONS-PPO
PRVPRV-250572026-03-07T09:46:52ZAmanda··—Campbell01-10-1940UHC-80536-94null(562) 265-2929UNKNOWN8762 Indian School Road Apt 27OrlandoFL32834—··
PRVPRV-246622026-07-09T07:55:03ZMARY—JAMES07/02/51—•••-••-0467839-951-1799null4017 Mountain View DriveSCOTTSDALEAZ85265—N/A
9,596 rows, page 171 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:43:00.536Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty