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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4234892026-09-13T19:46:25ZDOROTHHY—HOWARD08-06-1963·UHC-03790-63—(485) 514-6828—8082 Willow CtEden PrairieMN55345GRP-5516OPTIONS-PPO
CLMCLM-4242392026-07-15T00:21:11Z———1985-12-02UHC-44550-43•••-••-471815239443816-2515 Palm DriveTucson··AZ85767UNKNOWNN/A
CLMCLM-4160852026-05-04T13:57:44ZChristine—Edwards1969-05-22UHC-19900-65•••-••-4482429-479-4897N/A2240 Desert Sky BlvdColumbusOH43262GRP-9531····
CLMCLM-4005762026-02-27T01:28:09ZNathan—Crawford1989-03-21UHC5301967—·9413427409N/A9154 Forest AveGilbertAZ85230NULLOPTIONS-PPO
CLMCLM-4038122026-06-09T11:58:47ZDEBORAH····BISHOPApr 21, 1961·N/AN/ANULL—7177 Baseline RdPHOENIX··AZ85079——
CLMCLM-4287712026-04-21T12:16:30ZSandra—Bradley1970-05-25UHC-59697-99NULL7829315135—216 LAKE VIEW ROADDenverCO—GRP-8460NULL
CLMCLM-4267202026-06-02T11:33:22ZBRADLEY—HOWARD1992-12-01UHC-85451-99•••-••-4779(274) 618-4074bradley.howard@gmail.com··—NULL-N/AGRP-7961···null
CLMCLM-4230172026-06-25T19:29:29Z JENNIFER—COOPER28-07-1983N/A··null—-8673 Elm StDenverCO80270GRP-6082—
CLMCLM-4327602026-08-17T18:39:03ZJesseA··Hunter1943-06-08-nullUNKNOWNN/Anull——-·GRP-5954core-hmo
CLMCLM-4128402026-10-08T19:17:13ZRyan—Grant9/27/1989—•••-••-4542NULLN/A6174 Valley View Drive #604TucsonAZ85708NULLCHOICE-PLUS-PPO
CLMCLM-4249352026-01-21T19:32:28ZJeffrey··Jenkins1105-19-92UHC-38887-29•••-••-8891839-989-8724-413 Baseline RdHoustonTX77084·GRP-4612N/A
CLMCLM-4181962026-04-22T04:25:23ZJAKE—LITTLE1952-04-05UHC-83659-74NULL+1 337 539 2416NULL6539 BROADWAYPhoenixAZUNKNOWN—NAVIGATE-HMO
CLMCLM-4009662026-09-01T16:44:49ZMary—Willis1939-06-26UHC3926651N/A(336) 358-9981nullNULL—nullNULLGRP-1982—
CLMCLM-4291102026-02-20T07:27:00Zchristopher····stevens19920921-•••-••-7154—N/A6186 ELM STREETPlano··TX75006nullMEDICARE-ADV-B··
CLMCLM-4195022026-10-17T08:58:52ZLarry—Banks·May 21, 1947UHC-47014-15null—N/A7288 MESA DR Apt 29·SacramentoCA95840GRP-5849MEDICARE-ADV-B
CLMCLM-4187092026-07-03T14:53:23ZAna··—Burton·3/20/1972UHC-36574-30——N/A3854 Spring StreetChandlerAZ85266N/ANULL
CLMCLM-4059882026-05-16T15:27:56ZDiegoJBaker1956-09-07UNKNOWN—543-998-4934N/A8180 Elm StAtlantaGA30317GRP-3331-
CLMCLM-4234562026-09-21T06:37:43ZJordan—HicksFeb 4, 1995UHC-45387-89N/A·NULLN/A2656 Mesa DriveSan AntonioTX78247·GRP-6648NAVIGATE-HMO
CLMCLM-4076482026-06-02T06:49:28ZkimberlyJroberts1965-01-21UHC-22451-24-(678) 597-3841UNKNOWN8007 BROADWAYGilbertAZ85287N/AMEDICARE-ADV-B
CLMCLM-4306602026-02-13T21:09:37ZSchultz, JudithC—1988-10-24null—UNKNOWN—1867 Pine Dr·HOUSTONTX77077GRP-4712MEDICARE-ADV-B
CLM CLM-4088662026-07-15T02:20:32ZMari—Diaz2/22/1952UHC-71461-93•••-••-8744·-nullN/A—UNKNOWN-GRP-6943····
CLMCLM-4260722026-04-14T03:41:28Z·Emily, WardN.—1981-03-05UHC-88538-10——····—······N/A·NULLN/A
CLMCLM-4198922026-03-21T23:58:05Z·LuciaDThompson1985-12-14UHC-83698-89•••-••-5123243-416-6660-19 Pine DriveSan AntonioTX78223GRP-5711null
CLMCLM-4094672026-03-16T01:08:37ZSaraEBoyd1944-07-08UHC-17819-97•••-••-0701N/ASARA.BOYD@ICLOUD.COM6365 Sage Ct #465ScottsdaleAZ85281GRP-4026··—
CLMCLM-4096792026-04-19T19:12:29Z·Roy—Hall1952-10-16——953-514-0397NULL6334 Apache BoulevardSan Antonio·TX78254-6623GRP-4432NAVIGATE-HMO
CLMCLM-4080052026-01-06T16:07:55ZAMY····FRANKLIN1995-06-08—•••-••-2478null—2923 Washington StMesaAZ—GRP-2124null
CLMCLM-4002432026-01-18T20:52:47Z Gonzalez, Pamela——12/18/1996UHC-32865-94—+1 829 874 1320UNKNOWN2138 Highland AveSan DiegoCA92148··GRP-6898UNKNOWN
CLMCLM-4024992026-03-25T19:14:16Zbrandon—jenkins1994-08-01NULL•••-••-7631-—1660 Palm DrScottsdaleAZ85209GRP-8564OPTIONS-PPO
CLMCLM-4099182026-05-09T09:31:38Z Cllins, Gerald——May 28, 2008NULL•••-••-5410466-335-8492N/A4668 Oak StreetGlendaleArizona85381-CORE-HMO
CLMCLM-4142582026-07-13T13:26:06ZROY—ROMERO1969-09-17UHC-60685-91——-31 MEADOW LANEDenverCO···80253—CHOICE-PLUS-PPO
CLMCLM-411933 2026-05-29T22:07:34ZAna··—Mejia2/18/1990UHC3565903N/ANULLNULL8489 River RoadSAN DIEGO··CA92143-MEDICARE-ADV-A
CLMCLM-4060182026-07-22T16:31:17ZKayla—Bell1982-09-18-NULL—kayla.bell@proton.meNULL-null-GRP-9363NULL
CLMCLM-4229592026-04-02T04:08:39Z·SARA—MORGNA1/19/1993UHC-83917-94•••-••-5685(449) 281-4899—-N/AUNKNOWNUNKNOWN—N/A
CLMCLM-4065332026-07-19T17:19:22ZAlbert—Banks1998-02-12·UHC-93683-76•••-••-4071UNKNOWNUNKNOWN-null—··GRP-0583—
CLMCLM-4046412026-01-14T09:01:04ZDEBRAHMARQUEZ1996-03-18N/A··—UNKNOWNUNKNOWN6543 Lincoln Way Apt 16MesaAZ85274GRP-1484SELECT-EPO
CLMCLM-4072832026-05-03T11:17:37ZDylan—Rojas1974-10-07NULL··UNKNOWN8122884690NULL4391 Camelback RoadAUSTINTexas78762·GRP-0970·UNKNOWN
CLMCLM-4214432026-03-04T16:17:52Z AUSTIN—BURTON1983-12-17UHC-94455-39null+1 392 447 9475—UNKNOWNUNKNOWNNULL—N/AMEDICARE-ADV-A
CLMCLM-4109802026-06-13T09:47:42Z Lauren—Perez6/6/1949UHC-37524-53N/A(915) 433-5664—7080 Main StreetFRESNOCA93700GRP-9929-··
CLMCLM-4042912026-04-25T22:38:36ZGray, Carlos——1941-08-12UHC-64484-73•••-••-69377286315196NULL8227 Grand AveSan DiegoCalifornia92146-1611UNKNOWNN/A
CLMCLM-4173612026-02-08T18:48:30ZEmily—Harris··NULLUHC-11654-18•••-••-0697+1 985 476 8765UNKNOWN·5568 Apache BoulevardOrlandoFL32860GRP-1238—
CLMCLM-4198602026-09-03T14:39:39ZJulieYMaldonado2003-02-09UHC-32095-94•••-••-6649UNKNOWNNULL······NULLnullGRP-4452—
CLMCLM-4001562026-06-26T14:40:53ZHarold—Bursn12/10/74—•••-••-7669-—8011 OCEAN AVEMiamiFlorida·33150GRP-9449SELECT-EPO
CLMCLM-4047292026-07-12T20:23:42ZJESSE—HERNANDEZ··1989-02-19··-———·2786 SPRING STREETFresnoCA93736—MEDICARE-ADV-A
CLMCLM-4278912026-03-04T04:51:47ZEMILY—PALMER1961-07-18UHC-80821-83•••-••-6235NULL—2418 Oak StreetChandlerAZ85247GRP-9863MEDICARE-ADV-B
CLMCLM-4121932026-03-13T17:53:56ZDylan—Knight1984-08-05UHC-43988-05•••-••-9893—null7595 Highland AvePlano··TX·75016·GRP-0934NAVIGATE-HMO
CLMCLM-4238412026-09-19T00:26:31ZNOAH··ORTIZ·6/4/1988UHC-65429-19•••-••-27473427028··—3793 Park PlMINNEAPOLISMN55435GRP-1825-
CLMCLM-4171902026-03-12T19:21:42ZWilliam—Jimenez1982-03-19UHC-21086-40•••-••-0315(699) 909-5822N/A—N/A——N/A—
CLMCLM-4026542026-02-07T04:36:50ZAMY—MURRAYMar 15, 1952UHC-24519-12•••-••-1959·4239153null5657 Central AvenueSan DiegoCA92144GRP-0270UNKNOWN
CLMCLM-4073972026-05-21T10:36:57ZArthur····Lucas1954-04-24UHC-21109-17NULL651.741.3344arthur.lucas75@outlook.com9504 RIVER ROADAtlantaGA30300N/A-
CLMCLM-4145712026-01-09T22:20:50ZLUIS—MUNOZ01/25/97UHC-45111-01•••-••-8939565-723-8308NULL—··N/A·UNKNOWN—OPTIONS-PPO
32,829 rows, page 31 of 657PreviousNext

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