HawkLaw, P.A.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333549,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://www.hawklawfirm.com/cities/columbia/",
      "title": "HawkLaw, P.A.",
      "description": "HawkLaw, P.A. is a prominent South Carolina personal injury law firm dedicated to securing the compensation clients deserve. Specializing in car accidents, medical malpractice, and workers' compensation, HawkLaw has handled over 7,500 cases and recovered more than $200 million for clients. Founded by John D. Hawkins, the firm emphasizes client care and legal expertise, ensuring each case is handled with diligence and professionalism.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84324,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20245,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 2215,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95fb5d03-4d56-11ef-8344-b66e99367f32",
      "subdate": "Jul 29, 2024",
      "subcategory": "Legal",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Car Accident Lawyer",
      "service2": "Truck Accident Lawyer",
      "service3": "Motorcycle Accident Lawyer",
      "service4": "Rideshare Accident Lawyer",
      "service5": "Personal Injury Lawyer",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-29 02:59:35"
   },
   "location": {
      "uuid": "95fb5d03-4d56-11ef-8344-b66e99367f32",
      "link_id": 333549,
      "account_id": 84324,
      "company": "",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20245",
      "zip": "29210",
      "address": "140 Stoneridge Dr Suite 430",
      "phone": "(803) 887-2492",
      "fax": null,
      "email": "hawklawpafirm@burst-email.com",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.0128775",
      "lon": "-81.0696883",
      "cityname": "Columbia",
      "statename": "South Carolina"
   },
   "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": ""
}