List of Transmission shops in Columbia

[
  {
    "name": "Big O Tires",
    "address": "23**********",
    "phone": "********3707",
    "email": "st*********@bi**********",
    "lat": 38.963288,
    "lng": -92.304664,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.3,
    "rating_count": 498,
    "category_name": "Tire shops,Auto air conditioning services,Garages,Car battery stores,Truck repair shops,Transmission shops,Brake shops,Auto electrical services,Auto repair shops,Car repair and maintenance services,Car Service Stations,Car repair and maintenances"
  },
  {
    "name": "Big O Tires",
    "address": "39**********",
    "phone": "********5267",
    "email": "st*********@bi**********",
    "lat": 38.9062096,
    "lng": -92.3364857,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.2,
    "rating_count": 315,
    "category_name": "Tire shops,Truck repair shops,Car battery stores,Auto electrical services,Brake shops,Transmission shops,Garages,Car Service Stations,Car repair and maintenances,Car repair and maintenance services,Auto repair shops,Auto air conditioning services"
  },
  {
    "name": "Plaza Tire Service",
    "address": "43**********",
    "phone": "********9112",
    "email": "",
    "lat": 38.9517354,
    "lng": -92.3993293,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.8,
    "rating_count": 346,
    "category_name": "Auto repair shops,Vehicle examination offices,Car Service Stations,Car repair and maintenances,Mechanics,Tire shops,Auto air conditioning services,Garages,Oil change services,Brake shops,Transmission shops,Car inspection stations,Auto tune up services,Vehicle inspections,Auto radiator repair services"
  },
  {
    "name": "Dobbs Tire & Auto Centers",
    "address": "80**********",
    "phone": "********2250",
    "email": "",
    "lat": 38.9697375,
    "lng": -92.3267801,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.8,
    "rating_count": 453,
    "category_name": "Garages,Car Service Stations,Auto tune up services,Wheel alignment services,Car battery stores,Auto repair shops,Vehicle inspection services,Car repair and maintenances,Tire shops,Muffler shops,Oil change services,Brake shops,Transmission shops"
  },
  {
    "name": "Inland Truck Parts & Service",
    "address": "36**********",
    "phone": "********9400",
    "email": "",
    "lat": 38.9862708,
    "lng": -92.2877052,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 3.7,
    "rating_count": 34,
    "category_name": "Trailer repair shops,Truck repair shops,Hydraulic repair services,Truck accessories stores,RV repair shops,Truck parts suppliers,Transmission shops,Diesel engine repair services"
  },
  {
    "name": "Lee's Tire Company",
    "address": "14**********",
    "phone": "********3600",
    "email": "",
    "lat": 38.9643898,
    "lng": -92.3196325,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.5,
    "rating_count": 328,
    "category_name": "Garages,Car Service Stations,Car repair and maintenances,Wheel alignment services,Auto radiator repair services,Transmission shops,Oil change services,Auto repair shops,Tire shops"
  },
  {
    "name": "Toyota Service - Joe Machens Service Center",
    "address": "11**********",
    "phone": "********4553",
    "email": "",
    "lat": 38.9701538,
    "lng": -92.3227844,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 3.7,
    "rating_count": 49,
    "category_name": "Vehicle examination offices,Car repair and maintenance services,Car battery stores,Truck repair shops,Oil change services,Brake shops,Transmission shops,Car inspection stations,Auto air conditioning services,Tire shops,Vehicle inspections"
  },
  {
    "name": "Hyundai Service Department",
    "address": "13**********",
    "phone": "********0515",
    "email": "",
    "lat": 38.9710159,
    "lng": -92.3204579,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 3.8,
    "rating_count": 10,
    "category_name": "Auto repair shops,Car repair and maintenance services,Car Service Stations,Car repair and maintenances,Garages,Oil change services,Brake shops,Transmission shops,Tire shops,Car battery stores,Auto air conditioning services,Auto electrical services"
  },
  {
    "name": "Plaza Tire Service",
    "address": "41**********",
    "phone": "********3896",
    "email": "",
    "lat": 38.9519624,
    "lng": -92.3322342,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.7,
    "rating_count": 1311,
    "category_name": "Mechanics,Tire shops,Vehicle examination offices,Auto repair shops,Vehicle inspections,Auto radiator repair services,Auto tune up services,Oil change services,Brake shops,Transmission shops,Car inspection stations,Car Service Stations,Car repair and maintenances,Auto air conditioning services,Garages"
  },
  {
    "name": "Plaza Tire Service",
    "address": "80**********",
    "phone": "********8000",
    "email": "",
    "lat": 38.9928891,
    "lng": -92.3267799,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.6,
    "rating_count": 1602,
    "category_name": "Mechanics,Tire shops,Vehicle examination offices,Auto repair shops,Auto air conditioning services,Car Service Stations,Car repair and maintenances,Oil change services,Brake shops,Transmission shops,Car inspection stations,Garages,Vehicle inspections,Auto tune up services,Auto radiator repair services"
  }
]