List of Pipe suppliers in California

[
  {
    "name": "Tri Star Industrial LLC (Columbia Specialty Company)",
    "address": "11**********",
    "phone": "********6768",
    "email": "sa***@tr**********",
    "lat": 37.3617539,
    "lng": -121.8785006,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Jose",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Cal-Sierra Pipe",
    "address": "30**********",
    "phone": "********0988",
    "email": "er**********@ca**********",
    "lat": 37.9296993,
    "lng": -121.2336501,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Stockton",
    "star_count": 4.4,
    "rating_count": 18,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Tork Systems, Inc.",
    "address": "29**********",
    "phone": "********9675",
    "email": "sa***@to**********",
    "lat": 37.7899703,
    "lng": -122.2897969,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Pipe suppliers,Industrial equipment suppliers,Marine supply stores,Hardware stores,Distribution services"
  },
  {
    "name": "Consumers Pipe & Supply Co",
    "address": "13**********",
    "phone": "********4828",
    "email": "in**@co**********",
    "lat": 34.0995074,
    "lng": -117.512305,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Bernardino",
    "star_count": 4.6,
    "rating_count": 22,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "JM Eagle Co",
    "address": "35**********",
    "phone": "********2286",
    "email": "co*******@jm*********",
    "lat": 38.6546554,
    "lng": -120.9651794,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Cameron Park",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Fresno Pipe & Supply Inc",
    "address": "46**********",
    "phone": "********0500",
    "email": "fr*********@fr**********",
    "lat": 36.6984928,
    "lng": -119.7414949,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Fresno",
    "star_count": 4.6,
    "rating_count": 60,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Christian Brothers Lining Co.",
    "address": "",
    "phone": "********4291",
    "email": "To*@cb**********",
    "lat": 37.2691675,
    "lng": -119.306607,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers,Service establishments,Companies"
  },
  {
    "name": "Hobas Pipe",
    "address": "30**********",
    "phone": "********2550",
    "email": "in**@ho**********",
    "lat": 33.6733133,
    "lng": -117.8780943,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Costa Mesa",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Stockton Pipe & Supply Inc",
    "address": "38**********",
    "phone": "********0500",
    "email": "st**********@st**********",
    "lat": 37.9959729,
    "lng": -121.2528935,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Stockton",
    "star_count": 4.3,
    "rating_count": 15,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Carpenter & Paterson, Inc.",
    "address": "44**********",
    "phone": "********1830",
    "email": "cp********@pi**********",
    "lat": 33.8932264,
    "lng": -117.5911217,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Corona",
    "star_count": 4.8,
    "rating_count": 9,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Energy Metals Inc.",
    "address": "59**********",
    "phone": "********8922",
    "email": "sa***@em**********",
    "lat": 34.0056037,
    "lng": -118.1426765,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 4.2,
    "rating_count": 5,
    "category_name": "Pipe suppliers,Distribution services"
  },
  {
    "name": "Tri Star Industrial LLC (Columbia Specialty Company)",
    "address": "58**********",
    "phone": "********6425",
    "email": "sa***@tr**********",
    "lat": 33.8622623,
    "lng": -118.1561067,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 4.4,
    "rating_count": 5,
    "category_name": "Machine shops,Welders,Metal fabricators,Pipe suppliers,Plumbing supply stores"
  },
  {
    "name": "Northern California Pipe",
    "address": "18**********",
    "phone": "********8921",
    "email": "tf*@nc********",
    "lat": 37.9712188,
    "lng": -122.0435295,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Concord",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Uchida Pipe & Industrial Products",
    "address": "40**********",
    "phone": "********6058",
    "email": "an****@uc**********",
    "lat": 33.6823831,
    "lng": -117.8089094,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Irvine",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "San Diego Pipe Inc",
    "address": "",
    "phone": "********5450",
    "email": "in**@sa**********",
    "lat": 34.169034,
    "lng": -117.7846934,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Metal suppliers,Steel stockholder and suppliers,Pipe suppliers,Steel distributors,Service establishments"
  },
  {
    "name": "Ceres Pipe & Metal",
    "address": "14**********",
    "phone": "********2690",
    "email": "in**@ce**********",
    "lat": 37.6108283,
    "lng": -120.9829101,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Modesto",
    "star_count": 4.4,
    "rating_count": 131,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "P & F Distributors",
    "address": "13**********",
    "phone": "********7800",
    "email": "Ro****@PF**********",
    "lat": 34.0777892,
    "lng": -117.2570174,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Bernardino",
    "star_count": 5,
    "rating_count": 13,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "California Pipe Fabricators",
    "address": "72**********",
    "phone": "********3069",
    "email": "in**@ca**********",
    "lat": 38.414202,
    "lng": -121.8886343,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Dixon",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "S F Tube",
    "address": "23**********",
    "phone": "********9148",
    "email": "cu**********@sf**********",
    "lat": 37.643763,
    "lng": -122.1300415,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 3.7,
    "rating_count": 3,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Tube Service Co",
    "address": "15**********",
    "phone": "********3011",
    "email": "jh*****@tu**********",
    "lat": 32.8162553,
    "lng": -116.9702411,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Diego",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Kern Pipe & Supply Inc",
    "address": "20**********",
    "phone": "********0500",
    "email": "ke*******@ke**********",
    "lat": 35.431042,
    "lng": -119.0640282,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Bakersfield",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Trio Ranch, LLC",
    "address": "34**********",
    "phone": "********1995",
    "email": "tr**********@gm*******",
    "lat": 34.5062731,
    "lng": -118.2161579,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Isco Industries",
    "address": "15**********",
    "phone": "********5451",
    "email": "sa***@is**********",
    "lat": 38.0145952,
    "lng": -121.8568449,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Antioch",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Pipe Trades JATC",
    "address": "78**********",
    "phone": "********5383",
    "email": "he***@pt******",
    "lat": 37.3653728,
    "lng": -121.8898118,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Jose",
    "star_count": 4.8,
    "rating_count": 8,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Pie Pipe & Supply, LLC",
    "address": "81**********",
    "phone": "********9306",
    "email": "jp*******@pi**********",
    "lat": 38.5359963,
    "lng": -121.40642,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Sacramento",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Arizona Pipeline Co",
    "address": "17**********",
    "phone": "********3100",
    "email": "in**@ar**********",
    "lat": 33.8805123,
    "lng": -117.5324458,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Corona",
    "star_count": 4,
    "rating_count": 20,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Petros Tubular Services Inc",
    "address": "30**********",
    "phone": "********8757",
    "email": "sc***@pe**********",
    "lat": 33.8133884,
    "lng": -118.172247,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 4.3,
    "rating_count": 6,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Mission Clay Products LLC",
    "address": "23**********",
    "phone": "********4600",
    "email": "nc**@nc******",
    "lat": 33.7736022,
    "lng": -117.490113,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": null,
    "star_count": 5,
    "rating_count": 6,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Crescent Pipe Tongs",
    "address": "18**********",
    "phone": "********3485",
    "email": "in**@pi**********",
    "lat": 33.7906456,
    "lng": -118.1526865,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Consumers Pipe & Supply Co.",
    "address": "13**********",
    "phone": "********4400",
    "email": "in**@co**********",
    "lat": 33.9405983,
    "lng": -118.0535737,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 3.9,
    "rating_count": 8,
    "category_name": "Pipe suppliers"
  }
]