List of Transmission shops in Columbia

[
  {
    "name": "Jimmy's Automatic Transmission",
    "address": "13**********",
    "phone": "********0389",
    "email": "",
    "lat": 34.0399265,
    "lng": -80.9964822,
    "url": "",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 3.8,
    "rating_count": 11,
    "category_name": "Transmission shops"
  },
  {
    "name": "Donahue's Auto & Transmissions",
    "address": "63**********",
    "phone": "********7010",
    "email": "",
    "lat": 34.0576376,
    "lng": -80.9706622,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4.7,
    "rating_count": 94,
    "category_name": "Transmission shops"
  },
  {
    "name": "Firestone Complete Auto Care",
    "address": "47**********",
    "phone": "********5946",
    "email": "",
    "lat": 34.0093442,
    "lng": -80.9335223,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4.6,
    "rating_count": 64,
    "category_name": "Oil change services,Brake shops,Transmission shops,Wheel alignment services,Auto repair shops,Garages,Car repair and maintenance services,Car battery stores,Car Service Stations,Car repair and maintenances,Mechanics,Tire shops,Auto air conditioning services"
  },
  {
    "name": "Firestone Complete Auto Care",
    "address": "20**********",
    "phone": "********9946",
    "email": "",
    "lat": 34.014304,
    "lng": -80.9860785,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 3.7,
    "rating_count": 174,
    "category_name": "Mechanics,Tire shops,Car Service Stations,Car repair and maintenances,Auto tune up services,Wheel alignment services,Oil change services,Brake shops,Transmission shops,Garages,Auto air conditioning services,Car repair and maintenance services,Auto repair shops,Car battery stores"
  },
  {
    "name": "Jasper Engines & Transmissions",
    "address": "70**********",
    "phone": "********7455",
    "email": "",
    "lat": 33.973529,
    "lng": -81.026941,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4.4,
    "rating_count": 24,
    "category_name": "Diesel engine dealers,Transmission shops,Diesel engine repair services,Engine Rebuilding Service Stations,Auto repair shops,Engine rebuilding services,Car Service Stations,Car repair and maintenances,Garages"
  },
  {
    "name": "Firestone Complete Auto Care",
    "address": "47**********",
    "phone": "********5946",
    "email": "",
    "lat": 34.0093442,
    "lng": -80.9335223,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4.5,
    "rating_count": 48,
    "category_name": "Auto tune up services,Transmission shops,Oil change services,Brake shops,Car battery stores,Garages,Auto air conditioning services,Car Service Stations,Car repair and maintenances,Tire shops,Auto repair shops"
  },
  {
    "name": "Cameron's Torque Converter Services",
    "address": "54**********",
    "phone": "********8139",
    "email": "",
    "lat": 34.0578632,
    "lng": -81.0262622,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4.8,
    "rating_count": 39,
    "category_name": "Auto parts stores,Transmission shops,Racing car parts stores"
  },
  {
    "name": "Godfrey's Auto Salvage & Dave's Repair, LLC.",
    "address": "26**********",
    "phone": "********3582",
    "email": "",
    "lat": 34.0815509,
    "lng": -80.92673,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4.1,
    "rating_count": 185,
    "category_name": "Car repair and maintenance services,Car Service Stations,Car repair and maintenances,Auto repair shops,Auto body parts suppliers,Salvage yards,Transmission shops,Towing services,Garages"
  },
  {
    "name": "Firestone Complete Auto Care",
    "address": "75**********",
    "phone": "********9971",
    "email": "",
    "lat": 33.9634602,
    "lng": -80.9428479,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4,
    "rating_count": 320,
    "category_name": "Auto repair shops,Car Service Stations,Car repair and maintenances,Mechanics,Tire shops,Auto air conditioning services,Car repair and maintenance services,Garages,Car battery stores,Transmission shops,Oil change services,Brake shops,Auto tune up services,Wheel alignment services"
  },
  {
    "name": "Firestone Complete Auto Care",
    "address": "17**********",
    "phone": "********2598",
    "email": "",
    "lat": 34.003589,
    "lng": -81.0243723,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 3.9,
    "rating_count": 286,
    "category_name": "Mechanics,Tire shops,Car Service Stations,Car repair and maintenances,Garages,Auto air conditioning services,Car repair and maintenance services,Auto repair shops,Car battery stores,Transmission shops,Oil change services,Brake shops,Wheel alignment services"
  }
]