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-605782026-03-15T05:27:38Zpamela—sanders06/11/60N/A-N/AN/A5409 Washington StreetNashvilleTN37230UNKNOWNnull
TPATPA-612342026-01-10T04:56:01Z·Laura—OBrien2000-08-16—N/AN/A—3657 Desert Sky BoulevardLos AngelesCA90029NULLNULL
TPATPA-515432026-07-25T14:18:05Zgreegory—elliott1961-08-16····•••-••-2129nullgregory.elliott57@gmail.com1131 CENTRAL AVENUEATLANTAGANULL·GRP-3310OPTIONS-PPO
TPATPA-626322026-07-05T19:28:49ZBNEJAMIN—HICKS1968-09-17UHC9694510UNKNOWNnullN/A3782 JEFFERSON AVENUETucsonAZ85701GRP-7265UNKNOWN
TPATPA-508852026-04-04T14:32:23ZAustin—Cox1972-03-17UNKNOWNN/ANULLN/AUNKNOWN—-UNKNOWNnull—
TPATPA-623062026-06-18T22:55:11ZAmanda—Foord1946-05-22UNKNOWNnull667-810-5602NULL5380 Indian School RdCharlotteNC28233—NULL
TPATPA-503782026-07-08T03:27:19Z·kathleen—soto10/26/1939NULLNULL—null7986 Oak StreetSan AntonioTX78293··—
TPATPA-564622026-09-18T20:24:08ZJacob—·Watkins1948-01-23··nullN/A9825231742—1221 Church St··FresnoCalifornia93719-7849null—
TPATPA-578612026-10-12T08:08:03ZGregory—Smith1980-08-27NULLUNKNOWNN/A—9597 Sage CourtCharlotteNorth Carolina28267UNKNOWNSELECT-EPO
TPATPA-580812026-03-07T20:45:54ZJANET····MORRISON1993-11-28——2848247814·N/A9399 Cedar LaneSan Antonio·TX78206GRP-9829—
TPA TPA-583962026-01-18T01:04:17ZBurns, Judith——1978-04-16—nullnull—8847 PINE DRIVE··NASHVILLETN37258··N/ACHOICE-PLUS-PPO
TPATPA-552272026-05-02T22:57:26ZNathan—Olson09-12-1993UHC-91260-88NULL—null7076 Washington StGilbertAZ85286-CORE-HMO
TPATPA-530662026-09-27T10:05:03Zamanda—simmons1964-04-10—N/A··N/AAMANDA.SIMMONS37@YAHOO.COM9164 CAMELBACK ROADMesaArizona85207··GRP-5702—
TPATPA-552682026-02-26T13:47:44ZAbigail—Taylor1942-07-02nullUNKNOWN-N/A··7514 Market StreetDallasTXNULLGRP-0204NULL··
TPATPA-597752026-08-28T15:52:51ZHerrera, Cynthia——2004-05-23—NULL814-612-7656—9088 MOUNTAIN VIEW DRATLANTAGeorgiaN/AGRP-1416NAVIGATE-HMO
TPATPA-615812026-04-12T20:32:23ZBETTY····CARLSON07/15/1976UNKNOWN—586-355-9281—5900 Meadow Lane·CHARLOTTENC28210—OPTIONS-PPO
TPATPA-532502026-01-04T02:05:55ZBobby—Alexander2003-03-28NULL•••-••-1036—···711 Mountain View DriveTEMPEAZ85242--
TPATPA-518662026-05-04T11:57:41ZADAMF·CLARK12/9/1994-•••-••-35072088420531null4456 Park PlDenver··CO80201UNKNOWN-
TPATPA-562462026-04-14T03:58:14ZEvans, Stephen Q··—07/16/1941—•••-••-7707+1 566 783 2046—539 INDIAN SCHOOL RDHouston··TX77016-N/A
TPATPA-540482026-04-04T07:51:57Zlauren··K.sullivan09-10-1986——(883) 638-5689lauren.sullivan99@icloud.com381 Park Place··TampaFL33697-5965-CHOICE-PLUS-PPO
TPATPA-625452026-06-11T18:24:57ZGEORGE—MUNOZ19551202UHC-50698-43-(989) 877-2542N/A5175 Indian School RoadATLANTAGA30385····MEDICARE-ADV-B
TPATPA-555602026-09-26T20:43:44ZTerry—Alvarado2003-01-24UNKNOWN—-NULL——nullNULL··—NULL
TPATPA-544042026-10-17T13:41:22ZYuki—·Meyer19500601-·NULL-·null7772 HARBOR BOULEVARDSeattleWA·98122UNKNOWNCHOICE-PLUS-PPO
TPATPA-531482026-08-28T08:09:52Zana—price1949-12-07-··•••-••-7138—-605 BroadwayJacksonvilleFLNULLUNKNOWN··null
TPATPA-551012026-07-19T14:22:08ZJack····Carter1997-04-23—•••-••-765416939400690NULLN/A——UNKNOWNGRP-7654null
TPATPA-592872026-06-09T19:46:48ZEric—Castillo1/3/1941UNKNOWN—NULLnull3675 BROADWAYAustinTXNULLGRP-7501—
TPATPA-559022026-09-24T00:53:16ZMartinez, Linda——1949-11-21—•••-••-4727UNKNOWN—9175 ELM ST Apt 28SeattleWA98172GRP-9556CORE-HMO
TPATPA-606212026-05-25T20:20:49ZDORIS—POWELL··10/28/75NULL—18973165951—1164 Grand AvenueLas VegasNevadaN/AnullMEDICARE-ADV-B
TPATPA-608162026-04-05T10:38:08ZPAMELA—ARMSTRONG10/10/1974UHC-77233-16UNKNOWNNULL····2114 JEFFERSON AVEPlanoTX75041N/A-
TPATPA-643572026-03-26T17:39:15ZGEORGENCOLEMAN1939-05-05UHC-22944-32•••-••-2565—··7711 Valley View DrSacramentoCA95896UNKNOWN··UNKNOWN
TPATPA-507142026-04-29T13:10:25ZJudy—Schultz1971-11-05UNKNOWN———4311 SAGE COURT #928··Mesaaz85235NULL—
TPATPA-534462026-05-13T14:51:50Zwayne····johnston1957-08-18-UNKNOWNnullnull4906 Central AvenueDenver··CO80276UNKNOWN—
TPATPA-549462026-09-02T15:58:57ZJESSE—MEJIA16-02-2002N/A—NULL-null—--GRP-9583··—
TPA TPA-502272026-04-16T18:34:33ZCatherineSGomez12/26/1944-•••-••-6743UNKNOWNnull790 MEADOW LNSacramentoCA95805N/Anull
TPATPA-526562026-01-03T15:30:06ZARJUNUANDERSON02-10-1939··-—291.933.7865UNKNOWN6456 Meadow Ln #395Los AngelesCA90004—NULL
TPATPA-611232026-05-02T12:15:13Z·Sofiia—Guerrero1958-11-24N/A•••-••-3571(743) 657-9225sofia.guerrero8@yahoo.com748 CEDAR LNEden PrairieMN55381——
TPATPA-644372026-09-21T02:45:26ZCarlos—Gardner1963-10-26NULL-N/A—503 Elm Street··ColumbusOH43241GRP-9155—
TPATPA-54344 2026-01-29T16:55:46ZStephen··—·Harrison1963-08-13NULL—N/A——NULLnullN/AGRP-6756NULL
TPATPA-601222026-08-15T05:28:54ZCarolyn—Chavez11/10/1951UHC-58483-37•••-••-5372--·3210 BroadwaySan Antoniotx78271—·null
TPATPA-565152026-08-06T08:13:41ZJulia—Weber11/10/1984—•••-••-6795--··—null——-
TPATPA-546412026-06-07T00:20:52Zmichelle··—nunez1986-06-15nullnull(214) 994-6909michelle.nunez@gmail.com·8853 Union StTampaFL33678—MEDICARE-ADV-B
TPATPA-644232026-03-06T18:36:52ZKayla—Chavez··1991-06-09-—365-547-0683NULL117 Harbor BlvdFRESNOCA93760NULL—
TPATPA-628082026-06-26T18:49:38ZHELEN—BISHOP1992-01-16—UNKNOWNUNKNOWN—1149 FOREST AVENUEChandlerAZ85253GRP-6482null
TPA TPA-503182026-09-15T06:20:25ZDIEGO—HOLMES1965-05-21··—NULLNULLUNKNOWN5512 Sage CourtScottsdaleAZ85238-6327-NULL
TPATPA-579092026-02-19T22:13:02ZSarah—WilsonJul 19, 1976UHC-82292-39•••-••-1051—N/A5348 Park PlaceMesaAZ85292—NULL
TPATPA-541732026-08-08T09:00:52ZBrian····Thomas1993-09-01—-··——983 OAK STCharlotteNC28205·-—
TPATPA-588952026-07-15T19:21:13ZHEATHER—FREEMAN1961-09-08-•••-••-35352063831906HEATHER.FREEMAN46@PROTON.ME2537 GRAND AVEOrlandoFL32846—UNKNOWN
TPATPA-580482026-04-08T19:16:09ZSingh, Jean——03/25/1951——NULLNULL6624 Hillcrest RoadPhoenixAZ85054nullNULL
TPA TPA-612682026-07-16T13:56:59ZVega, Nancy····—Feb 12, 2000UHC-73844-71•••-••-79446715120415N/A3291 MESA DRGlendaleAZ85321—-
TPATPA-616792026-06-12T03:05:34ZRANDY—CLARK1989-05-14———randy.clark@icloud.com4099 Camelback RdMiami··FL—GRP-3332NULL
14,474 rows, page 93 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:43.429Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty