March 9, 2011, San Yisdro border crossing, California, USA_Border Patrol Agent Rodolfo Zuniga watches through the fence adjacent to the Mexico to U.S. pedestrian crossing on the east side of the San Ysidro border crossing. Photo Credit: CHARLIE NEUMAN/San Diego Union-Tribune/ZUMA Press

Also see Border boost spiked corruption cases

A new database by Texas Tribune and Reveal News compiles 140 corruption cases at U.S. Customs and Border Protection , many of which involved bribes and the smuggling of immigrants.

Of the 140 cases, 30 were identified as from California, and 19 were from San Diego.

Those with San Diego connections:

Oscar Antonio Ortiz

Served: 2 years

Prison sentence: 5 years

In 2006, Border Patrol Agent Oscar Ortiz admitted to a smuggling scheme. He, along with agent Eric Balderas, transported undocumented immigrants illegally.

Jorge A. Camarillo

Served: 5 years

Prison sentence: none

Conducted unauthorized government database checks on members of the a drug trafficking organization. He pleaded guilty in August 2008.

Marcos Gerardo Manzano Jr.

Served: 3 years

Prison sentence: None

Manzano was found guilty of harboring his twice-deported father in his San Diego home, alongside another undocumented immigrant. He pleaded guilty in July 2011.

Jason O’Neal

Served: 7 years

Prison sentence: none

O’Neal improperly used the Treasury Enforcement Communication System more than 100 times to monitor his girlfriend’s crossings into Mexico. He was arrested in February 2008 after lying to investigators about misusing the system.

Alonso Vasquez

Served: 29 years

Prison sentence: none

Vasquez was arrested in 2008 after retiring from CBP, for accepting bribes from those seeking entry into the country. He pleaded guilty to aiding and abetting the entry of an illegal alien, records show.

Juan Paul Yanez-Camacho

Served: 5 years

Prision: None

Yanez-Camacho misused the Treasury Enforcement Communications System at the Otay Mesa point of entry to track the status of people he knew in Juarez, Mexico. He was sentenced in 2009.

Lorne Leslie Jones

Served: 16 years

Prison sentence: 2 years, 5 months

Jones helped smuggle more than 66,000 pounds of marijuana into the country starting from 2000.

Luis Alarid

Served: 1 year

Prision sentence: 7 years

Alaird smuggled more than 100 kilograms of marijuana and took more than $200,000 in bribes. Alarid started working at the Mesa Point of Entry in October 2007, and was arrested by the San Diego Border Corruption Task Force in May 2008.

Fidel Villarreal

An image from a video of Border Patrol agent Fidel Villarreal shows him apparently finding and then disconnecting a camera hidden on the bumper of his vehicle.

Served: 8 years

Prison sentence: 30

Fidel Villarreal and his brother, Raul, helped smuggle more than 1,000 undocumented immigrants to the U.S. from Mexico and took up to $1 million in bribes.

6/06/2012: Border Patrol agent Raul Villarreal walks past a poster of citizens' right with the statue of liberty carrying a "Most Wanted" poster at the Imperial Beach headquarters. The US Border Patrol has increased their signage along the border and in their offices to alert migrants to possibly dangerous people they might encounter as they try to cross into the US. Peggy Peattie photo

Raul Villarreal

Served: 11 years

Prison sentence: 35 years

Raul helped his brother Fidel smuggle immigrants to the U.S. Oddly, Raul had been a spokesperson for the agency.

Eric Balderas

Served: 6 years

Prison: 2 years

Balderas conspired with a colleague to smuggle undocumented immigrants into the country. He pleaded guilty in December 2005.

Hector Rodriguez

Served: 4 years

Prison: 6 years, 6 months

Between 2010 and 2012, Rodriguez helped smuggle in immigrants, taking in hundreds of thousands of dollars of bribes and taking luxury vehicles and watches.

Michael Gilliland

Served: 16 years

Prison: 5 years

Using coded language, he guided some undocumented immigrants into the country after accepting payouts of anywhere from $70,000 to $120,000. He was sentenced in February 2007.

Thomas P. Silva

Served: 10 years

Prison: 8 months

Pleading guilty in 2012, Silva helped his fugitive brother-in-law evade arrest.

Jose Olivas

Served: 10 years

Prison: 3 years

Olivas worked as a scout for undocumented immigrants at the San Clemente Border Patrol checkpoint. He was sentenced in January 2008.

Martin Duran

Served: unknown

Prison: N/a

Duran used his job to wage a vendetta against a man who threatened a relative accused of sex crimes. He would create false alerts to prevent the individual from crossing the border.

Richard Elizalda

Served: 10 years

Prison: 4 years, 2 months

Elizalda fell in love with a smuggler and began accepting bribes to allow undocumented immigrants into the country in order to win her heart.

Armando Gonzalez

Served: unknown

Prison: 1 year, 9 months

He placed a video camera in the women's restroom in the patrol station, and tried to cover it up. He was found with images of nude women on the camera. He pleaded guilty in May 2015.

March 9, 2011, San Ysidro border crossing, California, USA_Border Patrol Agent Rodolfo Zuniga walks along the secondary fence just east of the San Ysidro border crossing. Photo Credit: CHARLIE NEUMAN/San Diego Union-Tribune/ZUMA Press

Rodolfo Zuniga

Served: 9 years

Prison: 3 years, 1 month

Zuniga worked with the youth program Border Patrol Explorers and made several illegal purchases of night-vision goggles. A probe into the Chinese national who was selling the goggles revealed that Zuniga had child pornography on his computer. He plead guilty in October 2012.