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-521662026-02-07T16:22:39ZmarianaChawkins1960-03-08UHC-87456-54null220-350-9097—9230 Mountain View DrGilbertArizona85264nullnull
TPATPA-534962026-08-17T03:59:38ZEugene—Bailey4/4/1986—-7196359150—9334 Bayshore DriveAustinTX78765··NULL
TPATPA-528612026-02-03T14:28:04ZCyynthia—Price1941-10-01NULL—(869) 886-8327cynthia.price99@yahoo.com2275 MOUNTAIN VIEW DRLos AngelesCA90063GRP-1129null
TPA TPA-501932026-10-05T18:33:08ZMargaret—Chavez1951-03-19NULLNULLnullnull5663 Spring StMinneapolisMN55457-4690GRP-0692MEDICARE-ADV-B
TPATPA-594512026-05-10T17:03:07ZJESSEU.CUNNINGHAMJun 9, 1968--NULL·NULL7036 GRAND AVENUETampaFL33602——
TPATPA-566762026-06-20T20:35:45ZISABELLA—ROBERTSON1985-02-04·null····N/A-1814 Jefferson AvenueHoustonTX77058-2839UNKNOWN—
TPATPA-532862026-10-14T07:38:29ZMATEO—HENRY19700704UHC-87661-26N/A4738412596——--N/Anull····
TPATPA-603022026-10-05T15:52:20ZBryan—Hayes07/05/50UNKNOWNNULLnull—994 PARK PLACETempeAZ85225GRP-2264N/A
TPATPA-600212026-07-24T15:50:07Z·BRUCE··WELLS·1977-11-17nullNULL(545) 799-8325BRUCE.WELLS69@YAHOO.COM7373 Pine DriveCharlotteNCN/AGRP-1061null
TPATPA-535542026-05-29T20:42:52Z Kelly··Evans1967-07-23—•••-••-7237·3234903918kelly.evans@outlook.comN/AnullnullUNKNOWN··CHOICE-PLUS-PPO
TPA TPA-538282026-05-25T05:44:52ZKATHLEEN—HARRIS··1996-05-02UHC-29359-29•••-••-4917N/A—7651 OCEAN AVE Apt 28CHARLOTTENC28297N/ANAVIGATE-HMO··
TPATPA-578772026-07-18T08:42:08ZMatthew—Watkins1982-07-05N/A—N/A-·9357 Valley View DrMinneapolisMN55478UNKNOWNCORE-HMO
TPATPA-592322026-07-02T06:41:23ZJesse—Perkins1985-04-16UHC-20153-76—7329691671JESSE.PERKINS@ICLOUD.COMnullN/A-—GRP-0920··SELECT-EPO
TPATPA-602092026-09-25T10:55:28Z·Sarah—LongAug 16, 1977··NULL-6273911sarah.long@aol.com2128 OCEAN AVENashvilleTN-——
TPATPA-568612026-08-07T03:48:28ZAnna—Romero·1/16/1962—UNKNOWN307-806-8355—NULL—NULL—NULL··
TPATPA-606732026-02-24T21:13:15ZStephanie····Porter1974-01-20——N/ANULL3850 Jefferson AveLOS ANGELESCA90086GRP-5274-
TPATPA-530502026-09-22T01:47:00ZKeith—Hernandez1959-01-20N/A•••-••-9468UNKNOWN—1643 Bayshore DrGILBERTAZ85258GRP-3611—
TPATPA-570442026-05-13T04:46:19Z Daniel—Oliver05-10-1977UHC-94684-51-(381) 930-0006—3603 UNION STTampaFL33668—UNKNOWN
TPATPA-578062026-04-20T02:32:29Z Christopher—Johnson1938-01-19NULL-9517842787NULL8530 Cedar LaneMinneapolis··MN55412GRP-9548··UNKNOWN
TPATPA-607152026-06-09T07:42:19ZAbigail—Ellis6/23/1939NULL—nullUNKNOWN7316 BroadwayATLANTAGA30396NULL—
TPATPA-585832026-07-29T17:42:19ZKEVIN—WELCH10/21/1994UNKNOWNNULLUNKNOWNnull7059 Main StAustinTX78749GRP-1770—
TPATPA-598242026-02-15T08:49:08ZMarcus····Yang1959-05-24N/Anull——4981 LAKE VIEW RDCOLUMBUS···OH43250NULLN/A
TPATPA-584852026-04-21T02:27:12ZDANIEL—CUNNINGHAM1979-11-09NULL—(289) 433-4179-——null-—UNKNOWN
TPATPA-593752026-10-13T20:39:57Zemma··—hayes11/22/1947··UNKNOWN•••-••-7482-UNKNOWN7363 CEDAR LNCharlotteNC28215—SELECT-EPO
TPATPA-522132026-07-03T19:10:53ZDONNA··TORRES2/11/1978—··—N/A—····N/AN/A-—
TPATPA-522392026-10-17T02:24:01ZBILLY—DUNCAN1983-12-27UHC-74793-36UNKNOWNN/A-N/A-——····NULL
TPA TPA-589232026-05-05T06:49:14Z·Beverly—Chen1946-04-03—-····null3317 Park Place #825Las VegasNV89155UNKNOWN—
TPATPA-546142026-07-02T00:13:59ZMelissaPPatterson19640308N/A•••-••-0469——64 Elm StreetSacramentoCA95845——
TPATPA-596362026-06-24T02:22:49ZBEVRELY—VASQUEZ9180-01-13···UHC-14586-30•••-••-5735nullNULL—N/A—N/A··GRP-1181NULL
TPATPA-593452026-07-27T10:36:13Zmichael—simmons1978-04-13null··-—null7323 PARK PL #618DallasTX75206·N/Anull
TPATPA-628402026-06-12T03:59:36ZThomas—Cruz3/20/1998—UNKNOWN-·thomas.cruz@gmail.com5054 Main StreetPHOENIXAZ85085—N/A
TPATPA-615702026-08-25T09:37:58ZMorrison, Lcuia····—1949-08-08NULLN/A—UNKNOWN3272 Forest AvenueDallas·tx75243-2768GRP-1382MEDICARE-ADV-A
TPATPA-504912026-08-07T09:58:38ZJacqueline—KelleyJun 5, 1980N/AN/A··404-203-0074—4235 Highland AvenueHoustonTX77014GRP-3860UNKNOWN
TPATPA-631882026-05-07T03:02:55ZElizabeth····Robinson1969-10-07N/A———6194 Bayshore Drive··GILBERTAZ85237-null··
TPATPA-508552026-08-07T09:56:32ZTyler··—Guerrero25-03-1989—•••-••-5390+1 255 877 1204TYLER.GUERRERO@ICLOUD.COM3570 PARK PLACEPhoenixaz85026GRP-0120—
TPATPA-579632026-02-01T09:00:13ZJordan—Howell2/13/1965UHC-95053-20null793-642-9148—8510 MESA DRIVESan AntonioTX··78250NULLNULL
TPATPA-619702026-09-30T20:27:15ZArjunPMorrison2409-19-83NULL•••-••-34558665169842null2175 Camelback Road Apt 32AustinTX78735-3449nullCHOICE-PLUS-PPO
TPATPA-595352026-08-26T23:00:44ZJeffrey—BradleyUNKNOWNN/AUNKNOWN——3300 CEDAR LANE··Eden PrairieMN55321GRP-7171—
TPATPA-603802026-07-12T21:11:07ZTyler—West1971-07-18—•••-••-7266N/ANULLnullnull--GRP-0429null
TPATPA-642032026-08-09T15:35:44ZKelly—Gutierrez16-10-1990N/A-null—6693 Maple AveLas VegasNV89123GRP-0927CORE-HMO
TPATPA-573302026-04-06T20:42:06ZGerald··—Foster05/17/1992NULLNULL-—368 CHURCH STMesaArizona85244GRP-8675OPTIONS-PPO
TPATPA-512952026-02-16T15:43:54ZJustin—·Satos20040404nullUNKNOWNnull—8482 Apache BlvdORLANDOFL32831GRP-7172NAVIGATE-HMO
TPATPA-522372026-02-01T20:08:51ZMARY—MILLER1961-10-25-··•••-••-7510473-293-7664—870 Market StreetORLANDOFL32832-N/A
TPATPA-567322026-06-13T01:01:39ZSTEVENK.WELCH20-11-1999UHC-45711-80•••-••-6434UNKNOWNUNKNOWN259 BroadwayLOS ANGELES·CA90000GRP-6935CHOICE-PLUS-PPO
TPA TPA-644652026-05-25T23:27:25Z andrew—homes1963-06-61—NULL—null4855 Mountain View DriveGILBERTAZ85291··—null
TPATPA-636402026-05-22T09:11:27Z Young, Karen——1971-06-26———UNKNOWN2949 HILLCREST RDSan DiegoCA92164GRP-0288·UNKNOWN
TPA TPA-568162026-01-31T21:59:20ZChales—·Kelly7/14/2006UHC-86006-63•••-••-91857155902967—25 JEFFERSON AVENUESCOTTSDALEAZ85226UNKNOWN-
TPATPA-503112026-10-17T02:02:00ZBetsy—Bailey7/17/1992—UNKNOWN··null-2559 Main StDallasTX75202GRP-5173—
TPATPA-627732026-07-24T22:33:47ZKeith—Davis1989-08-12····NULL-UNKNOWN975 Bayshore DrSCOTTSDALEAZ85240nullNULL
TPATPA-549282026-05-11T17:27:20ZKevin—Mills1976-08-28UHC-48283-04null—-8930 Mesa DriveOrlandoFL32899··—MEDICARE-ADV-A··
14,474 rows, page 161 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:49.135Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty