DUI Law Firm Aurora

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321030,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://duilawfirmdenver.com/",
      "title": "DUI Law Firm Aurora",
      "description": "The DUI Law Firm Aurora brings a unique combination of knowledge, skills, and experience to the table. Law, science, winning strategies, and understanding what you're facing are all part of what we know.\r\n\r\nEmilio De Simone, a former engineer turned DUI lawyer, combines his expertise in forensic science and criminal law to help clients win their cases.\r\n\r\nDUI Law Firm Aurora utilizes its deep understanding of the criminal justice system and long-standing relationships with key justice community members to aggressively seek the optimal outcome in your DUI case.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72222,
      "approve_dt": "2021-08-11T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-07-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 462,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2712,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 2186,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9582cea4-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 16, 2021",
      "subcategory": "Dui Law",
      "request_types": "",
      "visitcount": 649
   },
   "visits": {
      "storefront": 649,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "The DUI Law Firm Aurora brings a unique combination of knowledge, skills, and experience to the table. Law, science, winning strategies, and understanding what you're facing are all part of what we know.\r
\r
Emilio De Simone, a former engineer turned DUI lawyer, combines his expertise in forensic science and criminal law to help clients win their cases.\r
\r
DUI Law Firm Aurora utilizes its deep understanding of the criminal justice system and long-standing relationships with key justice community members to aggressively seek the optimal outcome in your DUI case.",
      "service1": "DUI Defense",
      "service2": " DUI Laws",
      "service3": " DWAI",
      "service4": " DUR",
      "service5": " DMV Hearing",
      "service6": " License Reinstatement",
      "service7": "",
      "submit_dt": "2021-07-16 00:40:00"
   },
   "location": {
      "uuid": "9582cea4-56da-11ed-b77c-b66e99367f32",
      "link_id": 321030,
      "account_id": 72222,
      "company": "DUI Law Firm Aurora",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2712",
      "zip": "80014",
      "address": "2675 S. Abilene Street, Suite 235",
      "phone": "303-404-7492",
      "fax": null,
      "email": "aurora@duilawfirmdenver.com",
      "name": "DUI Law Firm Aurora",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.6687677",
      "lon": "-104.8288176",
      "cityname": "Aurora",
      "statename": "Colorado"
   },
   "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": ""
}