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-569002026-08-18T03:47:14ZKATHERINE—LEMay 21, 2004··——-··NULL9865 Market StTempeAZ··85224N/A··
TPATPA-511362026-05-11T13:59:26ZAmy—Murray1952-03-15——UNKNOWN————NULL—MEDICARE-ADV-B
TPATPA-591882026-06-18T20:32:36ZWillie—Paark1944-02-21UNKNOWNUNKNOWN(290) 947-3765NULL3730 ELM ST··DenverCO80249UNKNOWNUNKNOWN
TPATPA-581612026-08-07T16:30:59ZSIMPSON—KEITH·2007-11-19NULL-NULLNULL6732 Church StreetFresno·CA93776null—
TPATPA-532212026-02-20T15:18:28Zdaiel—garcia1961-06-10null··N/AN/A7755 Washington StMesaAZ85270······choice-plus-ppo
TPATPA-522872026-01-07T11:14:01ZTHOMAS—BOYD19840928N/A—N/AN/A7546 Sunset BoulevardSacramentoCA95883—N/A
TPATPA-598032026-10-17T14:38:05ZEdward—Reed19570520—•••-••-73746528564—1422 Lincoln WaySan AntonioTX·78207—UNKNOWN
TPATPA-509532026-01-25T11:31:16ZLAWRENCE—·MONTGOMERY1986-11-18UNKNOWNN/A—null201 Church StreetPhoenixAZ85043GRP-5129N/A
TPATPA-508172026-08-04T04:16:13ZCampbell, LuciaZ—1947-06-23··null•••-••-7303NULLN/A3984 Broadway··GlendaleAZ85382GRP-6153-
TPATPA-595662026-01-17T06:01:55ZWalsh, Brian——10/27/38-•••-••-2448(509) 896-0375brian.walsh23@proton.me8446 CENTRAL AVENUEEden PrairieMN55365NULLN/A
TPATPA-604022026-04-09T05:08:57ZAustin—Kelly10/18/78NULL——nullnull-null——N/A
TPATPA-626792026-08-18T22:07:14Z ·Russell—Bell——null-——N/A··nullnull—-
TPA TPA-631132026-06-10T21:52:30ZShirley—Rojas1966-01-02NULL•••-••-4385—·N/A4695 INDIAN SCHOOL ROADFresnoCA93760GRP-9951N/A
TPATPA-559282026-01-01T21:35:31ZMelissa····Palmer1959-06-18null-726.690.2587melissa.palmer@proton.me6404 Lincoln WayNashvilleTN37205nullNAVIGATE-HMO
TPATPA-535252026-01-27T11:44:14ZSAMANTHA—NUNEZ1990-02-28UHC-31120-14•••-••-377315365474717····3542 Hillcrest RdLos AngelesCA··N/AGRP-8102·-
TPATPA-564352026-08-22T17:01:03ZJonathan—Carter1981-09-14—UNKNOWN—NULL··8631 Apache BoulevardGlendaleAZ85317N/A—
TPATPA-550562026-06-03T06:19:34Z·Michelle—Riley1939-03-18··•••-••-6859—MICHELLE.RILEY42@AOL.COM888 Cedar LnTucsonAZ85741—null
TPATPA-636542026-03-31T11:41:20Zcharlotte·YjacobsJun 27, 1945--N/AN/A4117 Ridge RoadGilbertAZ85251N/ANAVIGATE-HMO
TPATPA-510282026-02-22T07:55:53ZMargaretDFranklinOct 2, 1941—-—margaret.franklin@aol.com4443 Central AveGILBERTAZ85274nullSELECT-EPO
TPATPA-553872026-08-16T11:13:20ZGordon, Adam····—07/18/08NULL•••-••-7488N/A—2367 MEADOW LNGLENDALEAZ··85331GRP-2664··null
TPATPA-526022026-02-07T15:23:39ZAnna—Gonzalez1985-04-25-UNKNOWNnullANNA.GONZALEZ9@HOTMAIL.COM425 Elm St·DenverCO80241—NULL
TPATPA-545072026-01-17T08:18:36ZSoto, JessicaM—19710414-nullnullUNKNOWN-———NULLnavigate-hmo
TPATPA-567282026-01-23T10:44:50ZBrandon····Rivera1991-04-07—NULL-UNKNOWN5041 JEFFERSON AVEGlendaleAZ85328N/Anull
TPATPA-582982026-07-21T03:33:21ZANTHONY—TAYLOR2004-02-11····•••-••-9906484-511-8648ANTHONY.TAYLOR32@HOTMAIL.COM1177 Sage Ct··San AntonioTX—NULLNULL
TPA TPA-550332026-04-10T13:57:19ZJennifer—Le11/26/1970—-—···5766 PARK PLACE·ORLANDOFL—GRP-0933N/A
TPATPA-589322026-10-15T17:09:10ZMariaN.George1948-01-05UNKNOWN•••-••-7879—MARIA.GEORGE@HOTMAIL.COM8471 Cedar LnGlendaleArizona85386nullN/A
TPATPA-523112026-10-07T14:43:30ZSantiago—Riley·1962-03-21—•••-••-246513517312151NULL59 Washington StTempe··AZ·85217——
TPATPA-553052026-08-24T18:43:36ZMargaret—·Harris03/16/71UHC7713248-··UNKNOWN-··471 RIVER RDNashvilleTN··37288NULL-
TPATPA-62678 2026-10-09T19:02:35ZMaria—PayneOct 3, 1975N/AN/A—maria.payne13@yahoo.com820 Canyon RoadSCOTTSDALEaz85270nullMEDICARE-ADV-A
TPATPA-521982026-07-19T16:13:16Z CHRISTOPHER—CUNNINGHAM··1946-04-04UHC-92637-64-295-663-0065christopher.cunningham@hotmail.comN/A—NULL—NULLUNKNOWN
TPATPA-563672026-09-30T19:14:51ZEvelyn—Munoz06-10-1972—•••-••-2263N/A—6463 Ocean AveGLENDALEAZ85333··NULLUNKNOWN
TPATPA-542252026-10-13T04:56:45ZSCOTT—HOWELL09/04/2004——NULL·scott.howell@outlook.com1885 Meadow LaneHoustonTX77071UNKNOWN-
TPATPA-635852026-02-04T08:38:31ZRandy—Woods1949-10-25NULL—····—8616 Camelback RdJacksonvilleFlorida32235NULL—
TPATPA-605222026-10-11T23:11:57ZJulie—Cunningham1995-02-07——7614043718N/A6792 Indian School RdNashvilleTN37204··GRP-8766UNKNOWN
TPATPA-637962026-07-26T19:08:37Zbetty—owens1990-04-28N/A•••-••-5701(450) 462-8112—5241 MAPLE AVENUENASHVILLETN··37264—null
TPA TPA-586722026-01-24T05:45:16ZCarolyn··—Carlson·1963-03-23NULL•••-••-4939—nullNULL··NULL—-CORE-HMO
TPATPA-631472026-08-04T11:38:53ZMICHAELSROMERO9144-04-01UNKNOWN•••-••-5019·(958) 694-8183·NULL118 WASHINGTON ST Apt 8Tucsonaz85772-4519—NAVIGATE-HMO
TPATPA-531152026-03-27T15:17:03ZVICTORIA····DAVIS22-02-1999-UNKNOWNN/A-159 Highland AvenueSeattleWA98190-2189NULL-
TPATPA-551732026-04-03T11:20:51ZMartinez, Kelly——1999-11-10null—UNKNOWN—2305 APACHE BLVDSeattleWA98160N/Anull··
TPATPA-552982026-07-25T05:13:02ZAlexanderJ··Watkins01/04/1951UHC-16468-60•••-••-6875(790) 506-5866UNKNOWN··4141 Meadow LaneColumbusOH43214UNKNOWNNULL
TPATPA-597392026-04-02T18:38:28ZRoyZ.Banks1983-10-20——2165182047——null———NULL··
TPATPA-619712026-03-30T03:02:40ZKyle—Taylor·1943-03-04·-——KYLE.TAYLOR84@GMAIL.COM8402 Grand AvenueEden Prairiemn55389N/AUNKNOWN
TPATPA-517312026-05-14T22:02:19ZJUSTIN—KNIGHT1998-02-03UNKNOWN—713.491.8314UNKNOWN8250 Willow CourtFresnoCA-nullMEDICARE-ADV-B
TPATPA-611322026-09-28T08:45:02ZBILLY—PETERSON03/22/1983—null·429.663.2093null5022 WILLOW COURTTampaFL33685-5869—N/A
TPATPA-635972026-03-27T01:03:37Zelizabeth—oliver1980-04-09—•••-••-6388—NULL———NULL-N/A
TPATPA-517682026-03-11T09:02:28ZAna—Fuller1978-10-18—·UNKNOWNNULL—·9872 SPRING STREETPhoenixAZ85042GRP-8602NULL··
TPATPA-564192026-01-03T01:08:13ZLe, Omar——1980-03-23UNKNOWN··—·····N/A9880 Canyon RoadCharlotteNC28206NULLMEDICARE-ADV-B
TPATPA-550362026-07-01T15:06:19ZRamos, Jean··——Apr 3, 1962N/AUNKNOWN-—2365 Jefferson AveSeattleWashington98157UNKNOWNMEDICARE-ADV-B
TPATPA-521122026-08-01T20:24:48ZBanks, DianeS.—1988-03-16null•••-••-8663—UNKNOWN8353 Ocean AvenueORLANDOFL32873UNKNOWNMEDICARE-ADV-A
TPATPA-547102026-07-06T18:52:27ZvalentinaR.james1958-11-14··UHC-20196-87NULL——384 Market Street #914Mesaaz85296--
14,474 rows, page 39 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:37.756Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty