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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-502132026-04-23T03:46:13ZJUDITH—GONZALES1995-04-21N/A•••-••-1240(963) 528-1129—144 Canyon RoadSeattleWA98195GRP-6932choice-plus-ppo
TPATPA-636302026-05-17T00:31:38ZJULIA—REYES·1890-12-18—NULL—N/A4574 Harbor BoulevardSAN ANTONIOTexas78214GRP-2309··N/A
TPATPA-527522026-03-25T00:13:32ZGloriaYCarroll15-06-1962-—13744425197—731 WASHINGTON STREET··DenverCO80227·NULLCHOICE-PLUS-PPO
TPATPA-575112026-03-19T11:51:33Zbilly····reed19460519UHC-86512-71UNKNOWN214-715-0120—6977 Apache Boulevard #530San DiegoCA92183N/ANAVIGATE-HMO
TPATPA-589262026-04-25T23:20:37ZSophia—Russell02-02-1999NULLUNKNOWN—N/A7724 APACHE BOULEVARDPHOENIX·AZ85020GRP-9709NULL··
TPATPA-551322026-05-29T17:33:30Z·Donna—Warren1939-02-19UNKNOWNUNKNOWN····null5205 Valley View DrJacksonvilleFL32217····—
TPATPA-642212026-07-18T05:23:11Z Grace—Gilbert2005-04-17—•••-••-0757—null··821 Cedar LnDenverCO80242GRP-9877—
TPATPA-601182026-06-17T04:26:09ZLINDA—BISHOP1982-07-25UHC-08118-73··-—linda.bishop28@proton.me8313 Canyon RdScottsdaleAZ85238GRP-4031-
TPATPA-535902026-06-01T23:47:45ZAustin—Tucker2003-03-02—•••-••-35668785571233AUSTIN.TUCKER16@AOL.COM6741 CEDAR LNTampaFloridaN/AGRP-0785SELECT-EPO
TPATPA-637882026-10-06T03:36:33ZScott—Stone1986-06-26UHC-07176-62——··—NULL—UNKNOWN··CORE-HMO
TPA TPA-564022026-09-16T04:51:35Zpatricia—peters2000-10-03UHC-65406-11•••-••-2001N/APATRICIA.PETERS@YAHOO.COMnullnull——GRP-7153—
TPATPA-600032026-01-24T15:18:42ZMICHELLE—BURNS03-06-1938-•••-••-0000—michelle.burns@hotmail.com4095 PARK PLDALLASTX75205—UNKNOWN
TPATPA-528222026-01-27T07:29:40ZNychols, Logan——1955-08-13-N/A—nullUNKNOWNN/AnullnullUNKNOWNCHOICE-PLUS-PPO
TPATPA-555542026-10-13T09:48:20ZOLIVIA—SANCHEZ1947-09-04·UHC-66069-07•••-••-4357UNKNOWNN/A94 Cedar Ln #421ATLANTAGA30374GRP-0938N/A
TPATPA-541872026-07-22T12:04:24ZBRADLEY—LYNCH1963-05-22NULL··null—NULL563 WILLOW CTPlanoTX75001··null-
TPATPA-548492026-04-20T10:50:17ZScott—Brown19930207NULL—830-842-1400—5537 MAIN STREET·MiamiFL33123·GRP-6177-
TPATPA-555242026-08-17T04:18:57Zsean—freeman1966-03-08NULLN/A··360-613-8729—-N/A——·-—
TPATPA-637732026-01-19T11:09:55ZADAMSK.ZACHARY1959-02-12UHC-77933-88··•••-••-7755+1 808 315 2134—5796 BROADWAYOrlandofl32841——
TPATPA-626982026-04-01T05:39:53ZJulie··—Henry2003-09-22UHC-63032-05NULL731-268-0113NULL4006 Valley View DriveAtlantaGA·30310GRP-8124N/A
TPATPA-539482026-10-06T01:05:04ZANTHONY—JACKSON1943-11-05—-(921) 951-7579null561 Main StreetLos AngelesCA90035GRP-9986CORE-HMO
TPATPA-562382026-08-18T09:57:56ZANAAWILLIS1954-03-06—•••-••-1826+1 959 604 5540N/A7807 Apache BoulevardCHANDLERaz85210—medicare-adv-b
TPATPA-633902026-01-17T03:20:20Z CHARRLES X····BUTLER·1963-10-19——NULL—7058 Central AveMiamiFlorida33187nullUNKNOWN··
TPATPA-563112026-01-11T10:47:51ZSarah—Tucker3/6/1998·UHC-97286-29•••-••-9043836.955.0609NULL3680 Central AvePhoenixArizona85036····—
TPATPA-643752026-09-28T14:44:05ZSims, Chris——1992-06-03UHC-77833-63-·--··UNKNOWN———NULL—
TPA TPA-507992026-10-09T23:57:14ZAnthony—Hernandez2003-01-03nullnullnullUNKNOWN··9167 Main StCharlotteNC28204—-
TPATPA-571522026-06-30T21:44:53ZDiana—Owens1973-10-06null•••-••-2348UNKNOWNdiana.owens72@hotmail.com8103 WILLOW COURTMinneapolisMN55493—OPTIONS-PPO
TPATPA-618662026-09-10T13:00:55ZAARON—SCOTT1982-12-27NULL•••-••-8445NULL—N/A—-—GRP-8781··-
TPATPA-539722026-09-22T08:24:34ZEmma—Carteer02/15/1943-•••-••-4986—UNKNOWN2898 Church StAUSTINTX·78758·GRP-4936MEDICARE-ADV-A
TPATPA-569452026-05-27T13:26:37ZDiana—Fields1990-09-26UHC-61484-50·NULL404-321-1488diana.fields@aol.com1618 Jefferson AvenueChandlerAZ85205-null
TPATPA-596952026-01-23T13:40:30ZkimberlyGhoffman1949-03-15····—NULLUNKNOWN3254 Jefferson AvenueSAN DIEGOCalifornianull--
TPATPA-500012026-08-08T14:43:42ZMark—Palmer04/05/03UHC-34757-79—(811) 766-8647—·6814 Baseline RoadDALLASTX-GRP-6632·UNKNOWN
TPATPA-546092026-07-25T23:29:18Z—··—2004-04-13—NULL(628) 804-7841N/A5051 Market StreetPlanoTX75043GRP-0934CORE-HMO
TPATPA-618832026-04-03T11:32:48ZPatrick—Walker1997-07-01UHC-86582-20nullUNKNOWN—9298 WASHINGTON STAtlantaGeorgia··30362——
TPATPA-578682026-06-08T07:43:18ZVirginia—Hart1980-05-04NULL•••-••-0573-UNKNOWN2284 CENTRAL AVEGlendaleAZ··85315N/Anull
TPATPA-573592026-04-26T02:29:50ZKayla—RileyJul 20, 2002·UNKNOWN—·UNKNOWNUNKNOWN3510 Washington StPhoenixAZ85011nullUNKNOWN
TPATPA-561712026-01-16T10:02:21ZrachelWmarquezUNKNOWNUNKNOWN—N/A··rachel.marquez1@yahoo.com4606 Valley View DriveMiamiFL33185—UNKNOWN
TPATPA-555212026-05-24T20:10:38ZKaren—Wagner1995-02-07--——3199 Market StreetNashvilleTN37213null—
TPA TPA-529532026-06-13T04:32:31ZSARAH—JAMES1984-12-20NULL•••-••-39033792469344NULLNULLN/A·null··GRP-4143NAVIGATE-HMO
TPATPA-528962026-01-10T09:06:20ZEugene—Cox2/14/1983null—920-585-1897-28 Spring StreetMiamiFL33105GRP-8477null
TPATPA-574022026-06-21T02:49:31ZElijah—Tucker10/28/1958——(982) 364-5918····6906 Harbor BlvdPlanoTexas75055GRP-2087OPTIONS-PPO
TPATPA-517042026-08-13T14:58:34ZTony····Jenesn1983-08-12UNKNOWN•••-••-2890UNKNOWN—4054 CHURCH STTampaFlorida33636-UNKNOWN
TPATPA-529762026-04-26T23:25:41ZAlexanedr··—Hunt2003-02-22UNKNOWN——NULL2344 Church StMiamiFL··33166··null—
TPATPA-634022026-03-25T02:39:16ZMriana—Garrett15-11-2003UHC3914072•••-••-8819+1 829 735 6353-·6949 SUNSET BLVDMesaAZ85258-7510··—NULL
TPATPA-524842026-10-06T00:38:23ZMASON—MORALES···2/27/1942N/A··—UNKNOWN··9675 INDIAN SCHOOL RDTempeAZ85270——
TPATPA-604992026-07-20T08:25:43ZSTTONE—RONALD1948-08-28UNKNOWNUNKNOWN3537611389N/A643 Forest Avenue··Glendale··AZ85359NULLnull
TPATPA-51658 2026-04-19T08:12:33Z·KellyYCarroll1991-12-06—NULL—·N/AN/ANULLNULL—·GRP-1671-
TPATPA-567382026-08-03T10:20:16ZBrian··Carter1941-08-02—UNKNOWNNULLbrian.carter@hotmail.com4200 Valley View Drive #372LOS ANGELESCalifornia90014GRP-2313-
TPATPA-643962026-04-01T16:23:08ZHiroshi—Peterosn08/28/1947UHC-47694-32UNKNOWNUNKNOWN—6875 Apache Blvd #572GILBERTAZ85234GRP-3311·N/A
TPATPA-589112026-05-20T06:50:01ZJean—Carroll1993-10-12-—8595980652null1545 Canyon RoadMinneapolisMN··55433GRP-8016··UNKNOWN
TPATPA-525782026-02-21T04:37:02ZFields, Mary——1988-03-05UHC-83147-55···UNKNOWNNULL—·-N/A····—NULLSELECT-EPO
14,474 rows, page 87 of 290PreviousNext

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:40.639Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty