A Thru Tubing Specialists

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310816,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://spartansenergy.com/",
      "title": "A Thru Tubing Specialists",
      "description": "Spartan Thru Tubing Services, LLC, a Thru Tubing milling and fishing companywhich provides drilling / milling and \nfishing services used in conjunction with Coiled tubing, Snubbing, and work over Rigs.Spartan Flow Control Services,\nLLC, (began operations April 2011) a flow control company provides Frac Valves and \nFlowback equipment and qualified personnel",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 62051,
      "approve_dt": "2015-10-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-10-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 1319,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 18,
      "city_id": 9363,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://plus.google.com/109157217712099990720",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5006,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954f7e81-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 26, 2015",
      "subcategory": "Commercial Plumbing",
      "request_types": "",
      "visitcount": 1608
   },
   "visits": {
      "storefront": 1608,
      "articles": 0,
      "videos": 0,
      "reviews": 33,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Spartan Thru Tubing Services, LLC, a Thru Tubing milling and fishing company which provides drilling / milling & fishing services used in conjunction.\n\nSpartan Energy Services LLC, established in April of 2010 on a mission to provide our customers with a first class service in the oil and natural gas industry. Our commitment to our customers is delivering the highest quality of equipment and tools in the industry coupled with professional and safe personnel.\n\nWe administer a performance driven atmosphere with the utmost focus on health and well-being of our employees, in hand with environmental protection. The common goal of Spartan is to execute our experience, quality, and customer satisfaction to be superior at every location .",
      "service1": "Thru tubing",
      "service2": " Milling",
      "service3": " Finishing on coil tubing",
      "service4": " Snubbing units",
      "service5": " Barium scale milling",
      "service6": " Cement and sand milling",
      "service7": " Cast iron plug milling",
      "submit_dt": "2015-10-26 06:34:34"
   },
   "location": {
      "uuid": "954f7e81-56da-11ed-b77c-b66e99367f32",
      "link_id": 310816,
      "account_id": 62051,
      "company": "Spartan Energy Services",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 18,
      "city": "9363",
      "zip": "70583",
      "address": "123 Abigayleu2019s Row",
      "phone": "337-269-7300",
      "fax": "",
      "email": "spartanenergyservices10@gmail.com",
      "name": "A Thru Tubing Specialists",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "30.245597",
      "lon": "-92.097376",
      "cityname": "Scott",
      "statename": "Louisiana"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}