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-627132026-08-20T04:19:46Zgabriel—sanders2006-05-23··UNKNOWN•••-••-10199645939670—1842 Broadway··JacksonvilleFL32249—N/A
TPATPA-598802026-03-30T10:00:07Zlori—porterFeb 14, 1946UHC-02218-88•••-••-42772658648981null8225 Grand AvenuePlanoTX75062nullSELECT-EPO··
TPATPA-544952026-05-17T23:28:49ZMICHAEL—EVANS2006-09-04-UNKNOWNUNKNOWNN/A·2201 Elm StreetNashvilleTennessee37245GRP-6224N/A
TPATPA-621032026-10-03T14:56:07Z·Jeremy—Daniels05/05/1986UHC-66664-57UNKNOWNNULL—1579 Palm DriveSACRAMENTOca95830··UNKNOWN-
TPATPA-548992026-05-09T20:47:26ZRussell—AndrewsN/ANULL··N/A·-N/A2725 Pine DriveChandlerAZnullN/A—
TPATPA-579352026-04-04T00:17:42ZHudson, Debra——1999-06-22—null—NULL8828 Union Street Apt 14Atlanta··GA30327GRP-7969·OPTIONS-PPO
TPATPA-544022026-04-21T13:37:02ZEmma—Medina1946-10-22—•••-••-86817182319918N/A···N/ANULL—GRP-6610N/A
TPATPA-54618 2026-07-18T07:08:06Zfrank——04/08/83N/AN/A··UNKNOWN····8890 LINCOLN WAYChandlerAZ85223N/A—
TPATPA-641612026-05-07T04:01:52ZIsabella—Dominguez2001-11-14··—NULLNULLNULL3224 Union StreetOrlandoFL32850—NULL
TPATPA-623512026-05-31T17:28:57ZCHRISTINE—YOUNG04-10-1978UHC-29927-75UNKNOWN-christine.young@aol.com6594 Sunset BlvdOrlandoFL32870—N/A
TPATPA-563272026-07-24T08:18:03Zluis—riley06/19/71NULL··•••-••-6227—NULL8644 Apache BoulevardLos AngelesCA·N/A·N/AOPTIONS-PPO
TPATPA-621332026-03-31T19:50:40ZDonna—Graham·1976-06-12UHC-00728-71null7767305430donna.graham84@aol.com1770 Oak St··MiamiFL33104·-—
TPATPA-601352026-02-22T15:17:48ZHannah—·Santos1999-07-04N/A·UNKNOWN6293963219—UNKNOWNN/Anull—GRP-5276N/A
TPATPA-501842026-07-29T11:37:16ZEmma—Cox1996-05-09nullnullN/A—4137 Canyon RoadJacksonville··FL··—NULLnull
TPATPA-610402026-10-07T16:08:29ZMARK—HUGHESMar 17, 1941—•••-••-2385NULLNULLN/AnullN/ANULL—-
TPATPA-637652026-03-03T01:27:54ZCarter—LarryOct 14, 1981—-UNKNOWNN/A1439 Maple AvenueScottsdaleAZ85256NULLCHOICE-PLUS-PPO
TPATPA-532842026-06-08T14:41:44ZTimothy··—Nichols1989-07-13UNKNOWN-··NULLNULL8409 Bayshore DrSan AntonioTX78268-UNKNOWN
TPATPA-529882026-01-04T08:43:52ZJacob—KyngMar 14, 1970NULL—523-679-6588jacob.king64@yahoo.com7963 LAKE VIEW RDTempeAZ—NULLN/A
TPATPA-540832026-09-23T02:43:58ZRobertB.··Edwards07/11/2004··UNKNOWN•••-••-6337UNKNOWN-3734 Desert Sky BoulevardAustinTX78732—NAVIGATE-HMO
TPATPA-588502026-09-28T19:47:02Zandrea—kim04/05/45UHC-46800-07-424.268.7065-—N/AN/ANULLN/A-
TPATPA-557352026-09-21T00:28:15ZBrandon····Kim··0604-16-92·UNKNOWN•••-••-2049UNKNOWNbrandon.kim14@gmail.com—N/AN/ANULL···NULL
TPATPA-559622026-03-12T10:48:15ZRACHEL—LEE11/02/1939·N/AN/A-null3132 Meadow LnLas VegasNV89139·N/ACORE-HMO
TPATPA-608322026-03-31T04:52:20ZCARLOS—HOFFMANAug 1, 1963——N/Anull559 MESA DRAUSTINTX78768——
TPATPA-589422026-07-30T13:44:55ZMelissa··Ramos06/10/02UNKNOWN····+1 876 376 9108··-7751 Bayshore DrChandlerAZ85233nullSELECT-EPO
TPATPA-565402026-03-09T02:50:47ZOLIVIA—LONG15-07-1997—-824-274-2158olivia.long66@gmail.com1779 Jefferson AveMiamiFL33125GRP-1363N/A
TPATPA-580112026-07-25T13:03:13ZGuzman, Walter——1980-07-20——(926) 884-3798NULL9478 WASHINGTON STTucsonAZ85787N/AOPTIONS-PPO
TPATPA-57072 2026-09-29T00:04:48ZCHARLES—MARSHALL19670101-——····8778 Valley View DriveSan AntonioTX78208UNKNOWN-
TPATPA-528722026-07-21T22:50:17Z·Carl—Pnea07/21/53N/AN/AN/A—6299 CENTRAL AVENUETEMPEAZ85283-7107NULL·-
TPATPA-637202026-04-19T00:55:53ZSoophia····Wang1950-01-28UNKNOWN•••-••-6007(620) 351-9167-6636 Spring StreetJacksonvilleFLNULLGRP-0115N/A
TPATPA-530562026-07-11T13:24:09ZMatthew—Boyyd07/07/1958NULL•••-••-6144N/A—3756 Oak StCHARLOTTENC·28222NULLUNKNOWN
TPATPA-626902026-05-26T02:16:22ZKIMBERLY··SPENCER19821211·NULL—+1 808 537 3682NULLNULL—N/A—GRP-1290··CORE-HMO
TPATPA-614412026-07-15T09:14:30ZLINDAISTEWART1976-03-11—--··3321 Valley View Drive·MinneapolisMN55411GRP-5544CORE-HMO
TPATPA-548452026-10-09T00:06:26ZAlexanderTParker1977-02-05—•••-••-4453-—5802 PALM DRIVENashvilleTennessee37282GRP-4591UNKNOWN
TPATPA-579032026-09-15T10:43:26ZGEORGE—SILVA1972-09-06-•••-••-8286·NULLN/A———····-··NULL
TPATPA-633852026-08-13T22:22:25ZBRYAN—WEBER1945-07-26UHC-47291-99N/AUNKNOWN··5198 Willow CtFresnoCalifornia—NULLN/A
TPATPA-633452026-08-23T01:58:39ZnicholasR.wright1948-05-06UNKNOWN··•••-••-0895N/AUNKNOWN9424 Park PlColumbusOhio43204UNKNOWNNULL
TPATPA-637132026-06-13T01:35:09ZJeremy—Dominguez1972-02-12—•••-••-9835(968) 913-5832—8548 HILLCREST ROADMesaaz85287-NULL
TPATPA-607682026-03-28T08:07:26ZDORIS—BURKEApr 27, 1962—N/A—DORIS.BURKE@HOTMAIL.COM3850 Bayshore DriveDallasTX75270-1551UNKNOWNNULL
TPATPA-555342026-01-29T11:14:31ZKATHLEEN——2001-01-26—•••-••-9444494.972.5027KATHLEEN.LANE@YAHOO.COM7643 Highland AveMIAMIFL33193··GRP-3939—
TPATPA-57848 2026-03-26T13:26:58ZRoger—Nelson·14-06-1989UHC-31937-38•••-••-2695——1103 Desert Sky BlvdTucson··AZ85733-9756—··
TPATPA-598722026-02-13T21:01:34ZFox, Teresa—··1981-12-23—•••-••-1276—null4557 PALM DROrlandoFlorida··32865·N/ANULL
TPATPA-619652026-09-18T05:18:44ZTIMOTHY—WANGJun 10, 1948UHC-63226-44—(642) 887-7182—9121 Willow CourtHoustonTX77031——
TPATPA-629752026-02-01T17:03:50ZEstrada, Angela——1999-03-05nullUNKNOWN(808) 512-2748—5971 Camelback RdSan DiegoCA92156—NAVIGATE-HMO
TPATPA-631662026-07-17T00:55:21ZRuiz, Yukki——3/21/1972-•••-••-2902-UNKNOWN6056 Ridge RoadNashvilleTN37257GRP-5255NULL
TPATPA-508232026-01-13T14:04:43ZDick····Medina1981-07-21NULLN/A-richard.medina@hotmail.com1406 LINCOLN WAYTucsonAZ85787GRP-8694·NULL
TPATPA-54550 2026-07-18T10:44:49ZBARBARA—PETERS1945-08-28—-UNKNOWNN/A5311 Union StreetFresnoCA·93769GRP-2900—
TPATPA-616652026-10-12T03:06:56ZChryl··—Alvarez1938-01-25UNKNOWNN/A—NULL9105 Baseline RoadORLANDOFL32875GRP-9676MEDICARE-ADV-B
TPATPA-630972026-04-13T00:51:07ZWalter—Nelson·1983-03-25—•••-••-8188N/ANULL··3472 Cedar LnJacksonvilleFL··32264GRP-9073NULL
TPATPA-622822026-03-06T23:53:01ZMichelle—Harper1952-04-17UHC-59426-45•••-••-9647—··3693 Union StPlanoTX75080—MEDICARE-ADV-B
TPATPA-523462026-08-13T06:08:57ZNunez, Arjun——1967-01-13UNKNOWNnull5899143537—1279 BAYSHORE DRNashvilleTennessee37214nullNAVIGATE-HMO
14,474 rows, page 38 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.753Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty