Retail Store Location Scraping.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "3439450d",
   "metadata": {},
   "source": [
    "# Retail Store Location Scrapper"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "223dc528",
   "metadata": {},
   "source": [
    "## Cafe Coffee Day locations - delhi"
   ]
  },
  {
   "attachments": {
    "download.jpg": {
     "image/jpeg": "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAoHCBUVFBcUFRQYFxcXGRcXGhcXGRoXGBoZFxcaGRcaFxoaISwjGh0pHhcZJDYkKS0vMzMzGiI4PjgyPSwyMy8BCwsLDw4PHRISHTIpICIyMjIvNDIyMjIyMi8yNDIyMjIyMzIyMjIyLzIvMjIyMjIyMjIyMjIyNDIyMjIyMjIyMv/AABEIAI0BZQMBIgACEQEDEQH/xAAcAAABBQEBAQAAAAAAAAAAAAAEAAECAwUGBwj/xABFEAACAQIDBQUFBQYEBAcBAAABAgMAEQQSIQUTMUFRBmFxgZEHIjKh8EJSscHRFCNicuHxFYKSskNjg6IWJTNTdLPCNP/EABkBAAMBAQEAAAAAAAAAAAAAAAABAgMEBf/EACoRAAICAgIABQMEAwAAAAAAAAABAhEDEiExBBNBUXEigZEyYeHwFCPB/9oADAMBAAIRAxEAPwDx+i9n4zdk9DQdSUUAuzVn2jmFhWc6VLMLVEzd1It16kHW1Qpy16amZv8AY0sJhSwBJsKPjhsalhmBRSOFhVWOxARe8kWHhxqTWzWVdKHxiDLfpQ+G2mpAudaG2hjriy1NDtFTuKBxIq+FC2pqWIhAF6oTM+pAVCpA1RnEQGtEB2tYMfWqFNHxAWpGiQGEINVuaLxPCg6ETLgVKmpUyAnDPY1c8utAg05elRVkpXuarpUqZLYqkpqNKgEy4i9WKzDTMbeNRwxowgEUjVcmc9K1Sk41AmgToY1OEa1CisJFehkrsJjcaCtLAICSay5o7cKlgcWUbXhQWdDloDEx3NhTvtJAL3oLDY0O7A6X4eVSkNyRGfBniDr0rJfjrXTGucxLAuxHAk1SIkQQXqe7qsGrFl7qBJoOwuKKacqWO2jnXKOfGhEe9VPagp9EKVKnpmY1KnpUANT01KgB6alSoAVKlSoAuinZRZSRVbuSbk3NMDTE0Db4LIBratEYTStPYPYrHTkOmHZE/wDclO6S3UZtWHeAa7GDsCBbfYyMdVijaT/uJUfKonJR7ZpCLfR5wswU2OlU4nE3Fga9SPYTZ17yS4l7cRmiQegQtbzq4dj9lDTdynv37fktZ+fjXbL8rI+keN0q9jPYjZTiwWZO9ZtR/qQih5/ZZhXH7rFTIeW8RJB/2FTTWfG+mQ8E12jyWrEnIruNpeyzGJcwvFiByCNu3P8AkksPQmuMx+z5YHyTRPG/3XUodOYvxHeK1TT6I5iVSSXFVU9OENMXLI0qsERqRhpWGrKaVSZLU1MVDUqlkNMRQFDUqcCpZDQFMUb2qxsQariS7AZS1yBlX4jc8F0Op4DQ1ftKFY5pI42zIkkiIxsSyqxCkkaG4A4Uh20T2XHG8yLK2VGNmYnKOBsC1jlBNgWtoDflRz4aN45hu445YFWQNFIZEdC6RsrHeOuYbxWBU/ZYEG4tmYbBvJfKPdFszsQqLfhmY6L5nXlRUsqpGY4jmz23kliMwUhgiA6hMwBJNixVdBbVhyzNq/DTZTVJFNQLo0nxSkcbmpphb61mRtYg1uRSC1SzWLsysWhXShxRW0Hu1CU0Zy7CDiXtbMbVRT3p4oyxsASbE2AubKCzHTkACT3A0wbIUqV6VAh6VNSoAVKlT2oAalSpUAWtEbXqutBvgoGQa0ky5RIUqVKmQKnCkgkAkDiQNB4mvT/Zv7PVnRcXjAd2dYoj7u8A+2/PJ0HPjw4+yYbCRxoI40REAsERQqgdABpagKPmTsz2dmx0u6hUaavI2iRr1Y/gBqfWvVdlbDweAA3UYnnFr4iQA2b/AJSahOeo17zXX7UhjiUrHGke9OaTIoTMbBQWy2ueHkDWFHhDnyjXqT3/AImvP8V4mUZaR+53eGwRa2kC4jEzym7Fjz1vbyHAVWuElP2SefOuwwmDVbADXrSmzsr5BfLdbAe94j9Kx8iVXJ8/k389LiK4ORGFIGth3c6m+GK2zBhfhcEXrof2GGRQqsUkH373JHUHjr0ozDSyZt3LGrLwDrqLgX94HgdKI+Hvt99VyvuEs9dL5/gEw2xlEYZhra9hU0wJKXUADq2n5ca1XBAsqsR0GUf7jWXPGZDlyMOrM+YDyGlbZMUYVS/kwjllLtmHK5BPHjbXXgeIq5sTHMm6xEazIfsSC5HercVPeK0ptlXXQg/K/nc2rExWFKciDrfX0rk/2Y3a4OlaZVRw/bLsGIEOKwhZ8Pf30bWSG/U/aT+LiOdxcjilir3/AGTLrlYBlf3HUi4ZX90gjprXivaTAjC4ufDj4Y5Cq345CAyX6nKy16WDL5kbfaOHLDy5V6GZkp8tLeCmMldBmM0NQEFWbylnoAW6FVtDVm8py9AFaxCiYMEGBdjljWwLWuSxvlRBcZmNieIAAJPIGneV0EOFJihIQOFjEgTgJJsRinhjDdVCxJfru7aXvQBlxwkLmAEKG43jEtK/JhHoCeJF1CryZhVG8jT4Ig5H2pTccOUakKPBi9EYzErvGv8AvWBsZHOhy6e4i2CppopuLW0HCruzOEjxGMiilNo5HysR7ur3VLWta8jINOtAGRisS72zuSF+FdAi/wAiLZV4cgKHrouyGDH+JYeGVFYb7dSRuoZSVuGVlYWIuKGj7OzyKHQL74xDRJms8iYc/vSigW01sCQTka17UCMF6jW12h2QuHGHs+ff4aLEHS2UyFrqOo93TnV47H4vOIwqFt5umXOoMb7rfFXvbggYki4GRhxsCEvk56prIRwNbKdmJywUGP3sMcYGLEKYVDXa5GhGVtDbhQm0NmSYd4g+X97HHMjL7yskmqmxHcRYjlTJ5M8mkK7Ltp2dYYzEvAkYjGKTDrHHZcryJmjULYKAbHgdDxtWenZDEb2KIbstLLLApznKJYSA6McvK/EXB60Do54ij9j7R3DSNkzmSCaEa2y76MxluHIMdOdHYbsvPI0SpuzvhMY2z+6ThwTKpNtGAF+hzCxqgdnZygey7owtiN7mOQRq2Q30vmz+5lte5HLWgGjuvZ1hIocOcXLIkcQVzI2ha2d0ydczKtkRdfedr3yA+cbVxQlnmlVcgklkkCfdDuWC6dAbVqt2SxAMgbIm6lihbMx+KcXiZbA5lYWNxyI0rPk2c8c0kLreSJmRkGt3V8mUEcRc3uOIBoEZ96Va7OFR1YqxynMABkQ2IUAAWzZiOHf0uc0Yd8m8yNu82TPlOTPbNlzcM1tbcbUBQ0cd6Ui2ozDc6rmW5qbNdeASlSkGtKqMw/EpY25VS6Xq7GOC2lRiFI0A2QikUNjWxhsKGOtaIwa2sQKViUD253yKqLoqKqqBwsFAHyrgtr9uMVgceysd7h3WN921gygrlbdvxBzKTY3HhxrrcDiN5h4ZObRqD/Moyt81NcR7R8EGSKa3wkxt4N7yfMN60xJc0eotImKw8WIS5R0VxfQ5XAIuBwIoRUyst/hH0L1T7MMRn2Zh/wCASJ/okdR8gK38RgAdVNv4eXlXHmwbS2XZvjy6rVlUcoA106Hl51VKrBsymx7uB/mH5iqGV0OoIHS1x5U8Mw7x5gr/AE8qTna1fBSjXKJTRbwHMACLa9PPmKJiddACWNgNDYm1It0v5AfmRUczdT6f1ppU7JbtUXtEPu27y1OEstraUNu2PEt5e7+Zq/UixNh43+ZrRO/Qlr9yhR72nQ3/ACoTbMKlQTy56UeZANFFz0GtA4iMMc0rWA4IDc1lki5R1Stv8I0hLWVvhIG2RhbHOfhWzE2tw1UfhXiHtAxWbaWKbq4HoiL+Ve6SYnNZVGVBwUfn1r537Sy58ZiX6zS+gcgfIV0YcKxxr1McuVzlYAJKlnqmnrWjNSLd5S3lVUqKDYu3tNvappUUGxcZa6LZ+0nTChiFCKzxLIC28DZkxEdlAIukgLqWIDB5F6leXJro80UcbPEQ8T5ElhkkW781ZQpDK6m5DAe77wIymzsVhmGiw8mClnaM50kkQyl2BzPEGhJRTlzNJmFrWC35gtWFhMZuznX4wyFSQbDK2e+jDXMqHyqEu0G3ZhiLpEzZmTOWzn3bZ7BQ2XKLDLpqedbXZjsHjccpeJFSPgJJSUVjzCWBLeIFu+lQ1II/x+AbVGPVHEW9E7JlXPmK3cAZspu5Yg351dge1UUf7K5VzJhExkaABckn7QHyFjmumXeNcWN8otxNjcX7JMeisY5MPKyjWNJGD+AzqB6kVx0Wy5meSPIVeFHeUP7m7RLZy4OosSBbiSQADegfAbtza6TfsjRhlfD4eGFgwGUvCzEMpB1U5hoQOdFYnbGDlxz4uaKRkkLOY7KckhjIH2hvVEljY5bga8bUBiezuJjVndAFSSONiHVrNKueI6HVGU3DcOV76VFuz+ICZygy5I5PiFxFKxSOQjiEZha/epIAYEgcG7/4pg9wkS3XZsmAPup8b58rg5/g/eDTiLc6x+0G1o5zhcgdRDhYcO+ZRq0ea7JZtVObS9jpVWL7OYmNsrRXcS/s5RWV33uUMECqSTcG4IuKBxeCkjkMTxukgIUoykNc8Bl463Fut6AOv2n2pwk7YjPHKY58bDiSllUmKNCkiFg/uuc2lvUVpdm9twS4rAwRK67vGzyKCiqu7lHuKArHKVC2I163r0kbPwsEWD2TLEsizxypYgavEiu79xJLNmGoNrV88bRw7YfESxqzAxSSR5gbE7tyt7jwpiO77IbTR5sLhUV7QjaMjswAuZYXsq2J0CrxNrluGmuXh+1EYwi4HI+6/ZniMmVc4lbEftAbLmsYwbKRe+pPKx5BMQ4NwzAnmCQdepFdF2Y2DNjH3cMeZrZmZjZEB5u3K54DUnWwNjSKVMvw23gIXWRpZJHnwsodgp9zDAqQSWuDY+6OAAtesvbO0c+LxOIjU5J3lYCQWYLI+axyto3K4PWup2/2Lmwaq8hjdGbJmjYsA9icrAgEHQ+lZCYRNLrpztxtzsaVj1TMJMJNIoyx2S/ugWVSRocuY3c8Re5PKi9q495BDE0e7XDRiER62DgkyuVIGV3cktpfQC+ldRtLF4cSb2ONEAy5AY2llULogTO27jygC1rgW4NXL7YxrTSvM/xORfW+iqEW5PxHKoueZuedOxKNGeg10oySCwoOM2YX61pySAigZjyrrSqyYa0qAL0g61ekdqlenD1JpQVhntRZmAFZgemd70go9L9nu1Vlilw9/eibOv8AJJxt4OD/AKxWltrACWKSJtA6kX+63FW8mANeW9ndpnCYmOcXKi6yKPtRto48Row71FezYlAwDqQysAysOBUi4I7iKoymqZmexqR1wk0Dizw4iRSOmZVP+4NXod65Dsph1SeZxoZUjLDkTEWUN4lXAP8AKK629MkTNQ0kEZ4oPLT8KvY1TK4AJOgAJJ7hxqWk+xptdFZRB1HgapedBzb5Vjf+LcE3Cb1jlX8VqibtFhD/AMdPn+lRUGbPFmXcX+DZfaKDkx8wPyqhtq9Ix5kmuebtDhiwQSgliFFlci5NhrlsK0KuMYvozmpx/Umgt8fI2l8o6Lp+FU3qsVMVpRmWK4W7HgoJPgNa+cJJCzFjxYlj4k3P41732lxG7weJe9iIpAD0LKVX5sK8BoYmKlSqQFIErGpqc016AaFSp6VAUdHsHtfJhYjCMPhJkJJtiIc5GbiAQykjuN+NU7A7N4naErLholAuSzarFGGNwCxubcgNWsOdiaB2Fst8ViIsMmjSuFvxAHFmI5hVBPlXt3bPakexNnx4bBgLLJdIyQCwsBvJn+8+qgX0uw0sLUAZOwfY4I5kfFTpKim7RKjAMRwBYn4b8dNbW51pdv8AE7SlUYfZsY3CgB5IJIs5sLbtVVsyIO4XPDQccntxtGTZ+yoMFnY4nFKWnkZizkGzTZnOpJZggJ+yprx+CZkYNGzIw4MhKsPAjWgDu+yfYraEeJjxMqthIomEks8jqlkUguONzcAjXTXWh9p9qYZMXtJxcRYuJoo3ym4Me73bsOIVt3qLXGYaaWrk8ZtSaUASzSyAagSSO4B7gxNCUBZ2eI7VxnfRBWaJsHh8NGT7rGXChN1MwvpZg5t0IvzqnaPabO0bxuY82Hgw80eQe8YityGsfcIRWFjmvpa2p5KlegLPUuwUkeL7QS4lLlP386ZgQRmsguOoEho3bsJxeP2TI4G8bEYmJzb4kweLOUH/ACg+prJ9hY/8xl/+LJ/9sNdjLhhHtbZsBIzpJtXEEDkmIeV4vkLf5aBmzthN5trAi+mHw+KnPhJlh18yPSvJNl9j8TtWfEYmLKkLzSvvZLhTndmsgAux114Ada9Z7aAxb2RDafGJh9nw9QXklLOLaiwlZv8ApjrRu1ezwOEhwEP7vD3RZWBKncJ70i3FvekICk9Hcm+oIB4Dt/slisHiI8NIgZ5SBE0ZzLISQoCkgG+YgWIHEciDXru0SmwtkZUIOIksuccWmce8/D4UUG1/uqDxobYu0U2ntsyprh8DEwiPJpGbLnA6G7W7kU1Dtfh1x21RHM2XBbOiEs7H4cz2kyE88yhBbjZXtrQNHObZxRg2Rgo5L7zEzPiiDq27s1mY9W3iNr1NYEWIBHGo9rdttjsU85GWMAJEh+xGt8oPQm5Y97W4AV6D2J7DYePDpi8apdpQGjh96wDC6AouskjDXLwHS4vU1Zp0uTzrEvcUA6XrufaTsmHDHD7tFjklEzui8FUuDGCAbAqGKXGhy91cOXpFKnyDvh6gYm60VmqJNA9UUlDzF6VWE09UKgPd0hHRgh76cRd4rPcrUD3dOUovc99PufrSlsGoFkr032a7ezp+xSH3lBaEn7S6lo/FdSO6/wB2vPzCelWwF0ZXQlWUhlYaEEaginuDhZ7vs5MkynqCvqLj5gV0gNcJ2U7RJjEF7LPHYunANb7afwnmOR8ie3je4Bq07MGqfJI0Ljv/AEpP5H/2miiaHxAurDqpHqKBw/UeT4LCQNhA7CMPd1Z3d1ZTdN3kRQVk90tcd3EVLH4XAqJWRw1kjCBXLfvGMmYgB7kWCcza/DWjOz5l/ZYikkakSOoEhkUAMLtmyuA3d7txyN6q2xtSaIxMREc6oy5QSAqpYjla7OT5VzpKrPdk5ubim/yA7R3JxWHSEhgrRqWUhgQJRlGhOoF73sTeu5tXAYPHPPioC9vdcAWFueYk9+leg2rbFzbPP8dFx1T7S+RCpgUwFSFbHnnOe0CXLgXXnI8SejZz8kryjdd1el+0R7rDGOryHyAVf9zVwpw56GufJL6qOjHH6TNMfdTbs1qbjuqLwGo3NNTN3Z+hTbutAwfWtNuD0p7BqAbunMRo8QHvqQw56GluGpLs1tNsJio8SqBzGTdTpdWUowB5HKxsetdditqJtbbGDKo6xKUGSTLf92XmkuFJFjlC8eArj/2c113sugA2ihPKOQjxy2/AmqjPmiJR4sB9rU5k2nIp4RRxRjwKCU/OU1xW7ruvaThiNp4gng26YeG5jX8VNcs2GH9qHPkcY/SjMK04S9HPBYXrV2v2TxeEVXniKKxsrBkcZrE5TkY2NgT5G16ewahnYDs1HiHlxOJB/ZsKhdx99gpYJ/KFUk/5Rzrd2J2xGMmTBYnCYdcJMd2iIhVoi2kWVr2JvYXAUgm4ta1a3ZvDiPs9iSNGkXElu8m8Qv5KK4nsZsx5Mdh1UaJIkrHkqRMHYnXQaAeLCq2qiKu79DqfZhss4Xa2LgJvu4pEDcyoljKk95Uqas2PK0naaZmJ9wSqvcqRqgA6DUnxJre7E4rCzY7GTxszzyEkm1kSJHEaBSfiLhFckXsCBoQb19lpIBtbGoI2M7NI5kbLkWNTEAia3LMzXJIHwjjaqXoQ+38FHaOOefbuDjVS8WGRJmtoqZ2cM7E8/cQAcdNOdR9s22Z4oY8PH7seIEgkcfEQmT92DyDBjfqBbhe/Ne1OV/8AEJFV3VWhiRwrFVce8wDgGzDXnROC7cRy4dMPtHC/tIjtlcFWY5QQrOGtZrGxYHW50pOa5Q1B8Mn7DI3EuKbIchWNc9vdDKzHJfrZr2/UVne1zbrNiZMEi7uNGSSXLYGaVkQqzkcQqZAAencttPs/25vtCFFRcPgvehSFAFRS/wAMj2ABYuFHRQx7yQvbFsorjFny+5NGozf8yO6keOTJ6HpS24DX6uTzNo9K9awntShjiVzh5ZMQqKiqcqxRhVAIVrlveIzEhbnQcFFebLhSeAvfQDiSTwAHOvV9kdkMNhNlzS46CNpGV5PeUbyO6hY40f4lYm3A/E9uVEZWOaXqeTbb2rNi5nnnfM791lVR8KIOSjp5m5JNAZKNWA9aRw5pbl6gJWkRRTw91LcmjYVAmWlRJj7qVPYVGsIBS3NaIw38X1eonCjX3vz/ACrm3OjUz9wO6m3QrUTCjkSfK34mpDD/AMI82/SluPQyxD9cKtTDnn+Nq0DD3geY/rTiMHmDS3GolGHdo2V43KOpuGB1B/Txr13sZts4mJi4AdCFbLwJtcMByv08a8tENuJXxOv411/s8fJLLHe4dA3Cwujfo9Xin9VGeXHcb9j0Y1W1OGpmNdZxnj/abYjYaVvdvGzHduOFib5CeTDhbna/hLZi4GRQJt5HIBYnMSjd4Njl8Dwr1B8JHlZcoKv8St7wPcQeVcztDsdhnJKh4ifuNp6MCB5Vj5bTtHrx8fGcFGbaa9V/0E2VsnBh95CwkZOYkz5bgi5AOnPjW4KC2VsaPDKyoWJYgszWubcBoALC59aPtW0FSPNzT3m3ba9GxqkKVqqxEojRnP2VLegvVGXZxnaqTeYg21EaiPzFy3zYjyrEEH1/Siy5JJZrlrk8tTrckVYY/EeI/pavNlkt2elHHSSAhhvCothh1FaiYbqfly+dTOG7/wAKncNTFOHUDr86rfDH60rcEA6keQ/GkuDHX0P6CnuGpgbg0QMLpqfT+taxwQ6n68qcYUDj+Bo8wNTFMJHK9a/ZjFDD4qKZtFVrN3K6lGPfYNfyqZwq/V6RwqihZK5E4WqOo9puxS5TFoMy5Qj21AAJKNpyOYi/8teeNhuo+Vd5sbtM+HXdOolitYIfiVSNQCQQV/hPyoof4PIcxR4yfsjeAeQQkDyrVyjPlOvkxipQVNX8HBbL2G+JmSFFN3Op+6n23PQAfOw516R7VJ1GGigGrPIGA5hY1Nz6so8zSHanA4RCuEhLE9BkBI++7+8fQ1w+1tpvipWlksSRYDiqqOCr3annqSabmoxaTtsFGU5JtUkafZbb0EeElwWKD7uTMQ6+8QHAzKeY1FwbHielD7W2xCkTYbAQmKNx+8dv/VkH3STchePE63tYC9898IUORxlIANiCpFwCNDw0IPnR/wDgUm4/aMo3dxZr30Zit7X6i3mKnzJVXsX5cU79zX9kkBE07WsN2g9WP6Ud2YT/AM6xjW4rKL/9SIflRHs0w+U4g9d2OFvvmodlwBtPEknVjOB470G3opNu6tYy+lfJjJfVL4OW9pcN8fIdfgj6/dripFtx+vWvQfaR/wD1ORxCIOutr6jwIrgodqBSVkAHJlYHKe8aaHyse43NTJvZ0XGlFWCPCSLhWI65Tbz0r0Hs92/ikhGE2nFvUAAEuXeaD4d6vEsPvrcnpe5PKROMwZJMsdr3uMyn7oOobzvb8YbSmVuEYBP2ioD6D4jzHcOPWlHI06obxqStno+E21sLCHe4dM7jUZY5XcH+FptEPmK5Ltf2qlxxCn93CpusYN7nk0h+0e7gL8+Nc/hsHIVzbuS3NshsPlRYTS97+A/tTlk9CYQj32ALCKcw0Y0dzp08DTnDAcj6mo2NaM5ou4VWYe+tFovrT8zVbRW5ed6rYmgHc/XGlRJjWlRYqNURDp9X9KcJr/QVLOPrSmzL3VjZsTRPD0vVgUacPICqwR96/p+lWKt9QR56UiiQYHl8h+dNnHcbeHlzpOORt/fy41SyXOlIYSNTx8OFaewZxFiYm5Fsp6Wf3eXjfyrJjVh9EVU7Ob6/Mn00oi6doJRtUe0q1ItXMdlu0QmQRyHLMo1U6bwD/iJ1vzHI91iehMleimmrR5kouLpidqElerneg5XqkSQdx0pi46VS71AvViLmk6Vi9osWFjy31kOXyHvH8LedX4/aUcS5pHCjhcm2vQdT3Vw+P2kcRJnIIjUEIOBseLEcr2GnQCsssqg/3NcUW5p+wWi3sb6elXWI6E9+vyqnDIOVxRiYfqT52ry2j0rFBPfiBp5D+lFPGvy5EVGOADgR4VYsfU+lAiG7BHr0qto+Wny8qIWNevypnhH3vw+dSFlDJ9X+VQAAGn+7SrSnePkamIDyP5fgKoAax5el78KiUbrb68KLSO3FvLX9KgbH7J87W/ClYwQA63P4fpUilhpZSfvaflU+JtZR+Pp0p90CePiL6elMCGGhVpEDkqlxmZQGIHOwy/XfV+Pw0buzxJkTQKt76C2pJvqbXIH9aiuGTS/pYVfvFUcx5GnfFCfdh+LxUL7QExW8ZZL5l0sEVCWBHAEfKs6HHOiPCpYxvxUgkaMCCvQ6WJ5+lDyyKTxGvl+NQZL+HjY03Nv++5Kgl/fY3ezu3Thi4yZg9r6lTdQba27zyrOWV1lMyNlkLs4sL5czE2vzGpGtAIpOlreJHzsTVojsbk/9316Ubukr6HpG2/co2vM0jM8hJc6ktwuen1YVzmJizkKQf8wBA8LD9a6qdkIsSDbzrExGHFzbh3CxvVwYnxx6GabRKcrXbiBly+Nje49Khs0SSnOQMo+za4sOZJ+vxqc2H15kc+da+x8aIw6OumUlNLe8FNlNhz0/099XK4xtcsxyStUlx7GhFiXjjzRwx/DnDnNqv2ioBAuO/wAaCLMxzsRckG9reQyi39qnsjFyRrksGjvfI2lieJQ8VOvh3VexUacrcrm3n1rFcSfH3JwYtLVfcFkhHnfW17H51Ui2Oo9T/Sr0YWta3hpe/O1uHnQ5ax/uePU/1qzYUlv70MYxyt0vV515fpVbL4eg/WqQinIPq5pVIm/An0/pSpgEAHqPIAUiLcbel/SmWInn9etMbg2vz8KgoluhxAUHrlAq9YyOnoRUI1AtoPn+tWW0HDw15+dJlIk8Wmpv43p4UsOgPfVjKFNh040wPP65VHZfRBkA0zfj+NWxIPrX0tUC1uX5VegPXXXXX9aTGD4jDA2PvXGoIJBBHAqwFwe/StHCdo8VEMuZZlHASXD937xePmCe+oqNOJqsKDyqoZJR6M5QjLtGnhu2h4TQMh+9Gd4tu8GzDyBq1+1uHPB384pR/wDmslYLtbT08utO2BX6FbLxMjGXh4+gVL2si+znbuEbD/cAKy8Z2qlbSKLLf7Uh1/0rx9ajLhgKg2HHDyq/8mTEvDxRmS7yVs8shZuXILf7oGg/GrYRl56d+tG/swI/pUkwoI4mspZG+zWMUuiEUo5X06fXCjoZCeWnXQUKYgLm50tz491SRSDfMetZMs1AgOtj+dTRegb0obDyE6+ff60dGufifzqaFZHIevHloPlU1Xqp+u+9TOHUcvoVBjppp4cOXKigsqkh10HhfS3z4VIIeeX1FIjQ1ZFEDrw8KQWQGF5/lUo0H3SP8uvpc1JiRzv9A/nTqL8e+qFZXuudvDQDj5VBkPQ+F/61fbl9aXpwuhP1wqR2ZzrbmwB/ie3lqbVQ9wTla44mxJt+Na41vegpY78+o/CnY0wE35i/fr87AVOL+VvW9vJvyp5MMQdG9Rf86iy5QCDTKLCl+RHiDz8DVgjFuZ9VH9qGeQ6EHnqON/DpU8Ni8wJtY3txvy8O+lTAsCk63AXu08Remnwwbx5XN/DQmmM3LX18+lFJqPyp3RJkvgrjlcaaGox4ADU/XzrYVtfLxtrVTJm1J4fPWq2YtUCiO11VQdONhp6VU0YHEfI2+dFMbmw0AubcedvKhpIhy4dDrQAO2ug89NPIjWnYKOWvcf63qZjAA/t9cKi/1e5/OqEDTEdR6iqrdDfzB/tRIYngcvz/ABqmXvJPE6mqRIywtrYemX8xSqWQdKVAj//Z"
    }
   },
   "cell_type": "markdown",
   "id": "9c2e2ad9",
   "metadata": {},
   "source": [
    "![download.jpg](attachment:download.jpg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "026da00e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# import libraries\n",
    "import requests\n",
    "import json\n",
    "from bs4 import BeautifulSoup \n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import folium\n",
    "from folium.plugins import HeatMap,FastMarkerCluster\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "8825d2a9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "200\n",
      "CCD outlets/restaurants in Delhi - Café Coffee Day\n",
      "{\"locationTitle\":\"Delhi\",\"locations\":[{\"val\":\"12403\",\"name\":\"Caf\\u00e9 Coffee Day - Rajouri Garden\",\"address1\":\"Building No 13\\/57, J Block\\r\\n Rajouri Garden\\r\\n\",\"latitude\":\"28.6397488\",\"longitude\":\"77.1181652\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110027\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi-4\",\"near\":\"0\",\"veg\":\"\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00\",\"close_time\":\"9:30\"},{\"val\":\"12401\",\"name\":\"Caf\\u00e9 Coffee Day - Vishal Enclave\",\"address1\":\"24\\r\\n Block A, Vishal Enclave, Rajouri Garden\\r\\n\",\"latitude\":\"28.6489842\",\"longitude\":\"77.12184\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110027\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi-3\",\"near\":\"0\",\"veg\":\"\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00\",\"close_time\":\"09:30\"},{\"val\":\"12396\",\"name\":\"Caf\\u00e9 Coffee Day - Janakpuri\",\"address1\":\"Block B 2B\\/14, Janakpuri\\r\\n \",\"latitude\":\"28.63344\",\"longitude\":\"77.94284\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110058\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi-2\",\"near\":\"0\",\"veg\":\"\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"09:00\",\"close_time\":\"11:00\"},{\"val\":\"12394\",\"name\":\"Caf\\u00e9 Coffee Day - Mandi House\",\"address1\":\"Shop No 49, Plot 7, Block 205 C, Tansen Marg\\r\\n Next to Annakoot, Mandi House\\r\\n\\r\\n\",\"latitude\":\"28.6294921\",\"longitude\":\"77.232787\",\"city\":\"New delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/new-delhi-0\",\"near\":\"0\",\"veg\":\"\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00\",\"close_time\":\"10:00\"},{\"val\":\"12390\",\"name\":\"Caf\\u00e9 Coffee Day - Lajpath Nagar\",\"address1\":\"A-10, Lajpath Nagar Part-2 \",\"latitude\":\"28.569843\",\"longitude\":\"77.238611\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110024\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi-1\",\"near\":\"0\",\"veg\":\"\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00\",\"close_time\":\"23:00\"},{\"val\":\"12388\",\"name\":\"Caf\\u00e9 Coffee Day - New Friends Colony\",\"address1\":\"14, Community Center, Ground Floor\\r\\n New Friends Colony\\r\\n\",\"latitude\":\"28.562661\",\"longitude\":\"77.2689677\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110065\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi-0\",\"near\":\"0\",\"veg\":\"\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00\",\"close_time\":\"11:30\"},{\"val\":\"12318\",\"name\":\"Caf\\u00e9 Coffee Day - Janakpuri\",\"address1\":\"C3-78, Major P Srikumar Marg\\r\\n Block C3A, Block C3, Janakpuri\",\"latitude\":\"28.615781\",\"longitude\":\"77.879554\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110058\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/janakpuri\\/janakpuri-0\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"12306\",\"name\":\" Caf\\u00e9 Coffee Day - Janak Cinema\",\"address1\":\"C Block, Janakpuri, Near Mata Chandan Devi Hospital C Block, Janakpuri, Near Mata Chandan Devi Hospital\",\"latitude\":\"28.610926\",\"longitude\":\"77.0916334\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110059\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/janak-cinema\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"0\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"12301\",\"name\":\"Caf\\u00e9 Coffee Day - Dlf Sarojini Nagar Delhi\",\"address1\":\"Dlf Sarojini Nagar Delhi Dlf Sarojini Nagar Delhi\",\"latitude\":\"28.5763\",\"longitude\":\"77.1951\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110023\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/dlf-sarojini-nagar-delhi\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"000\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"12300\",\"name\":\"Caf\\u00e9 Coffee Day - Bengali Market Delhi\",\"address1\":\"Bengali Market Delhi Bengali Market Delhi\",\"latitude\":\"28.6295\",\"longitude\":\"77.2322\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/bengali-market-delhi\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"12244\",\"name\":\"Caf\\u00e9 Coffee Day - Shopper Stop Rohini\",\"address1\":\"FFF Crown Plaza, Plot Number 3B1\\r\\n Bhagawan Mahavir Marg, Sector 10, Rohini\\r\\n\\r\\n\",\"latitude\":\"28.719748\",\"longitude\":\"77.19988\",\"city\":\"New delhi\",\"state\":\"Delhi\",\"pincode\":\"110085\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/new-delhi\\/shopper-stop-rohini\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"11:00 AM\",\"close_time\":\"9:30 PM\"},{\"val\":\"12288\",\"name\":\"Caf\\u00e9 Coffee Day - Kamlanagar Building No 26b1 & 27 A1 Del\",\"address1\":\"Building No 26B\\/1 & 27 A\\/1\\r\\n Jawahar Nagar, Kamla Nagar\",\"latitude\":\"28.679952\",\"longitude\":\"77.28535\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110010\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/kamlanagar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"9:30PM\"},{\"val\":\"12270\",\"name\":\"Caf\\u00e9 Coffee Day - Pod Food Court Dhaula Kuan Metro Stn\",\"address1\":\"Pod Food Court Dhaula Kuan Metro Stn \",\"latitude\":\"49.29\",\"longitude\":\"84\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110007\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/pod-food-court\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"11:00 AM\",\"close_time\":\"1:00 AM\"},{\"val\":\"12141\",\"name\":\"Caf\\u00e9 Coffee Day - Pinnacle Mall\",\"address1\":\"Atrium, Pinnacle Mall Sector 10, Dwarka\",\"latitude\":\"28.57946205\",\"longitude\":\"77.05601501\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110075\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/dwarka\\/dwarka-0\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"12080\",\"name\":\"Caf\\u00e9 Coffee Day - PSRI Hospital\",\"address1\":\"PSRI Hospital, Ground Floor\\r\\n Sheikh Sarai\\r\\n\",\"latitude\":\"28.533991\",\"longitude\":\"77.225599\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/sheikh-sarai\\/sheikh-sarai\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"12081\",\"name\":\"Caf\\u00e9 Coffee Day - Parsvanath Mall\",\"address1\":\"Shop No G 08 & G 09\\r\\n Parsvanath Mall, Akshardham Metro Station\\r\\n\",\"latitude\":\"28.6178687\",\"longitude\":\"77.279468\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110092\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/akshardham\\/akshardham\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"12079\",\"name\":\"Caf\\u00e9 Coffee Day - East Of Kailash\",\"address1\":\"Building No.19 East Of Kailash Comunity Center\",\"latitude\":\"28.5584685\",\"longitude\":\"77.2454778\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110065\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/east-kailash\\/east-kailash-0\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11993\",\"name\":\"Caf\\u00e9 Coffee Day - Vasant Square Mall\",\"address1\":\"Vasant square Mall Plot No A Community Center Sector-B, Vasant Kunj\",\"latitude\":\"28.52564\",\"longitude\":\"77.156792\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110070\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/vasant-kunj\\/vasant-square-mall\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11806\",\"name\":\"Caf\\u00e9 Coffee Day - Sarita Vihar\",\"address1\":\"Cross Shop no 14, DDA Market Sarita Vihar \",\"latitude\":\"28.5336627\",\"longitude\":\"77.225945\",\"city\":\"New delhi\",\"state\":\"Delhi\",\"pincode\":\"110076\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/new-delhi\\/sarita-vihar\\/sarita-vihar-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11913\",\"name\":\"Caf\\u00e9 Coffee Day - Star City Mall\",\"address1\":\"33 Ground Floor, Star City Mall\\r\\n Mayur Place, Mayur Vihar I\",\"latitude\":\"28.592657\",\"longitude\":\"77.2964362\",\"city\":\"New delhi\",\"state\":\"Delhi\",\"pincode\":\"110091\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/new-delhi\\/mayur-vihar\\/star-city-mall\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11807\",\"name\":\"Caf\\u00e9 Coffee Day - Sarita Vihar\",\"address1\":\"Inside Indraprastha Apollo Hospital Mathura Road, Sarita Vihar\",\"latitude\":\"28.5409\",\"longitude\":\"77.282456\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110076\",\"phone\":\"7428235992\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/sarita-vihar\\/sarita-vihar-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"1\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"12:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"11902\",\"name\":\"Caf\\u00e9 Coffee Day - Splendor Forum\",\"address1\":\"G-18, Splendor Forum, Jasola \",\"latitude\":\"28.539228\",\"longitude\":\"77.284486\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110044\",\"phone\":\"9312877018\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/jasola\\/splendor-forum\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11948\",\"name\":\"Caf\\u00e9 Coffee Day - The Mall Road\",\"address1\":\"Plot No. 61, Mall Road, Kingsway Camp \",\"latitude\":\"28.697905\",\"longitude\":\"77.206579\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110009\",\"phone\":\"9313307343\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/mall-road\\/mall-road\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11974\",\"name\":\"Caf\\u00e9 Coffee Day - Unitech Amusement Park\",\"address1\":\"Unitech Amusement Park, Rohini Near Rithala Metro Station\",\"latitude\":\"28.727433\",\"longitude\":\"77.116135\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9213022186\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rohini\\/unitech-amusement-park\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"12033\",\"name\":\"Caf\\u00e9 Coffee Day - West Patel Nagar\",\"address1\":\"Plot No. 8,  Block No. 42, West Patel Nagar \",\"latitude\":\"28.65087375\",\"longitude\":\"77.15971291\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110008\",\"phone\":\"011 32213990\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/west-patel-nagar\\/west-patel-nagar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11813\",\"name\":\"Caf\\u00e9 Coffee Day - Satya Niketan\",\"address1\":\"283 Satya Niketan, Main Market Opposite Venketeshwara College\",\"latitude\":\"28.58767811\",\"longitude\":\"77.1671752\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110021\",\"phone\":\"9350767550\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/satya-niketan\\/satya-niketan\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11820\",\"name\":\"Caf\\u00e9 Coffee Day - Sector 10\",\"address1\":\"Crown Plaza, Plot Number 3B1, Sector 10 Bhagawan Mahavir Marg, Rohini\",\"latitude\":\"28.7196608\",\"longitude\":\"77.10912644\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"160010\",\"phone\":\"9213023168\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rohini\\/sector-10-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11865\",\"name\":\"Caf\\u00e9 Coffee Day - Shivaji Marg\",\"address1\":\"Plot No. 29, Shivaji Marg, Najafgarh Road Industrial Area \",\"latitude\":\"28.66098497\",\"longitude\":\"77.14859121\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110015\",\"phone\":\"011 32213946\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/shivaji-marg\\/shivaji-marg\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11869\",\"name\":\"Caf\\u00e9 Coffee Day - Shivalik\",\"address1\":\"A-6, Shivalik, Near Malviya Nagar \",\"latitude\":\"28.535208\",\"longitude\":\"77.208552\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"011 65157046\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/shivalik\\/shivalik\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11899\",\"name\":\"Caf\\u00e9 Coffee Day - South Extension 2\",\"address1\":\"Ring Road, South Extension Ii \",\"latitude\":\"28.568657\",\"longitude\":\"77.218487\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110049\",\"phone\":\"011 64638601\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/south-extension-ii\\/south-extension-2\",\"near\":\"0\",\"veg\":\"2\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11981\",\"name\":\"Caf\\u00e9 Coffee Day - V3S East Centre\",\"address1\":\"Plot No. 12, V3S East Centre, Laxmi Nagar \",\"latitude\":\"28.637318\",\"longitude\":\"77.286632\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"9312099260\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/laxmi-nagar\\/v3s-east-centre\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11764\",\"name\":\"Caf\\u00e9 Coffee Day - Rohini City Center\",\"address1\":\"Plot No-1B3, Twin District Center\\r\\n Sector 10, Rohini,\\r\\n\",\"latitude\":\"28.7169595\",\"longitude\":\"77.114614\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110085\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rohini\\/rohini-city-center\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"11:00 AM\",\"close_time\":\"9:30 PM\"},{\"val\":\"11664\",\"name\":\"Caf\\u00e9 Coffee Day - Prashanth Vihar\",\"address1\":\"36 & 37, Opposite CRPF Public School, Sector 14 Prashant Vihar\\r\\n\",\"latitude\":\"28.7193\",\"longitude\":\"77.13396\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110085\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rohini\\/prashanth-vihar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"11:00 AM\",\"close_time\":\"09:30 PM\"},{\"val\":\"11634\",\"name\":\"Caf\\u00e9 Coffee Day - Paschim Vihar\",\"address1\":\"A3\\/320, Jwala Heri Market, Paschim Vihar\\r\\n \",\"latitude\":\"28.67448\",\"longitude\":\"77.126372\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110063\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/paschim-vihar\\/paschim-vihar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"11:00 AM\",\"close_time\":\"9:30 PM\"},{\"val\":\"11601\",\"name\":\"Caf\\u00e9 Coffee Day - Old Rajendra Nagar\",\"address1\":\"5\\/54, Ground Floor, Old Rajendra Nagar\\r\\n Shankar Road\",\"latitude\":\"28.638523\",\"longitude\":\"77.18376\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110060\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/old-rajendra-nagar\\/old-rajendra-nagar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11710\",\"name\":\"Caf\\u00e9 Coffee Day - Rajiv Chowk Metro Station\",\"address1\":\"RCK 02\\r\\n Rajiv Chowk Metro Station\\r\\n\",\"latitude\":\"28.63294887\",\"longitude\":\"77.21915968\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajiv-chowk\\/rajiv-chowk-metro-station-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11740\",\"name\":\"Caf\\u00e9 Coffee Day - Regal Building\",\"address1\":\"Ground Floor, Regal Building Connaught Place\\r\\n\",\"latitude\":\"28.63175146\",\"longitude\":\"77.21681942\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/regal-building\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"09:00 PM\"},{\"val\":\"11720\",\"name\":\"Caf\\u00e9 Coffee Day - Ramakrishna Ashram Marg\",\"address1\":\"U22 Agn, Ramakrishna Ashram Marg \",\"latitude\":\"28.6395408\",\"longitude\":\"77.2085157\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110055\",\"phone\":\"9312874178\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/ramakrishna-ashram-marg\\/ramakrishna-ashram-marg\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11673\",\"name\":\"Caf\\u00e9 Coffee Day - Punjabi Bagh\",\"address1\":\"Shop No 6, Club Road, Punjabi Bagh \",\"latitude\":\"28.665707\",\"longitude\":\"77.125873\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110026\",\"phone\":\"011 32931770\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/punjabi-bagh\\/punjabi-bagh\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11638\",\"name\":\"Caf\\u00e9 Coffee Day - Patpargunj\",\"address1\":\"Max Hospital, I P Extension, Patpargunj \",\"latitude\":\"28.634015\",\"longitude\":\"77.309819\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"9350934679\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/patpargunj\\/patpargunj\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"1\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"12:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"11706\",\"name\":\"Caf\\u00e9 Coffee Day - Rajendra Place Metro Station\",\"address1\":\"Rajendra Place Metro Station, Rp U22 Cgn Rajendra Place\",\"latitude\":\"28.64241107\",\"longitude\":\"77.17822593\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110008\",\"phone\":\"9310146480\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajendra-place\\/rajendra-place-metro-station\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11684\",\"name\":\"Caf\\u00e9 Coffee Day - Pvr Naraina\",\"address1\":\"Pvr, Industrial Area, Community Centre, Naraina Naraina Industrial Area Phase I\",\"latitude\":\"28.633573\",\"longitude\":\"77.139135\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110028\",\"phone\":\"9312066583\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/naraina\\/pvr-naraina\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11687\",\"name\":\"Caf\\u00e9 Coffee Day - Qutub Minar\",\"address1\":\"Villa Haven, Ten Style Mile, Near Qutub Minar Mehrauli\",\"latitude\":\"28.52550014\",\"longitude\":\"77.18534549\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110030\",\"phone\":\"9312873664\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/mehrauli\\/qutub-minar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11674\",\"name\":\"Caf\\u00e9 Coffee Day - Pusa Road\",\"address1\":\"Karol Bagh Metro Station, Pusa Road \",\"latitude\":\"28.643437\",\"longitude\":\"77.188495\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110005\",\"phone\":\"9313483850\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/pusa-road\\/pusa-road\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"9:00 PM\"},{\"val\":\"11711\",\"name\":\"Caf\\u00e9 Coffee Day - Rajiv Chowk Metro Station\",\"address1\":\"Rajiv Chowk Metro Station D Block 4 Toms\",\"latitude\":\"28.633899\",\"longitude\":\"77.219285\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajiv-chowk\\/rajiv-chowk-metro-station-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"12:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"11708\",\"name\":\"Caf\\u00e9 Coffee Day - Rajiv Chowk\",\"address1\":\"Rck 06, Rajiv Chowk \",\"latitude\":\"28.631524\",\"longitude\":\"77.219324\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9312875408\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajiv-chowk\\/rajiv-chowk-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11709\",\"name\":\"Caf\\u00e9 Coffee Day - Rajiv Chowk Metro F Block\",\"address1\":\"F Block 4 Toms Rajiv Chowk Metro Station\",\"latitude\":\"28.631481\",\"longitude\":\"77.219504\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajiv-chowk\\/rajiv-chowk-metro-f-block\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11712\",\"name\":\"Caf\\u00e9 Coffee Day - Rajiv Chowk Metro Station A-Block\",\"address1\":\"A Blk 4 Toms Rajiv Chowk Metro Station \",\"latitude\":\"28.633967\",\"longitude\":\"77.218567\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajiv-chowk\\/rajiv-chowk-metro-station-block\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11713\",\"name\":\"Caf\\u00e9 Coffee Day - Rajiv Chowk Metro Station Rck 05\",\"address1\":\"RCK 05, Rajiv Chowk Metro Station, Connaught Place \",\"latitude\":\"28.63265\",\"longitude\":\"77.219421\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9350294925\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/rajiv-chowk-metro-station-rck-05\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11707\",\"name\":\"Caf\\u00e9 Coffee Day - Rajiv Chowk\",\"address1\":\"Dmrc, Rajiv Chowk \",\"latitude\":\"28.631524\",\"longitude\":\"77.219324\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9312874924\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajiv-chowk\\/rajiv-chowk-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11763\",\"name\":\"Caf\\u00e9 Coffee Day - Rockland Hospital\",\"address1\":\"Rockland Hospital, B-33 & 34, Qutab Institutional Area Tara Crescent, Block A\",\"latitude\":\"28.53732794\",\"longitude\":\"77.18103287\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110016\",\"phone\":\"9350233558\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/tara-crescent\\/rockland-hospital\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"8:00 PM\"},{\"val\":\"11765\",\"name\":\"Caf\\u00e9 Coffee Day - Rohini Sector 7\",\"address1\":\"Plot No. 23 , Pocket No. 9, Sector 7 , Rohini \",\"latitude\":\"28.70955738\",\"longitude\":\"77.12269574\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110085\",\"phone\":\"011 64000083\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rohini\\/rohini-sector-7\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11779\",\"name\":\"Caf\\u00e9 Coffee Day - Safdarjung Enclave\",\"address1\":\"Nauroji Nagar Marg, Safdarjung Enclave Near Kamal Cinema\",\"latitude\":\"28.565347\",\"longitude\":\"77.199393\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110029\",\"phone\":\"011 64638611\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/safdarjung-enclave\\/safdarjung-enclave-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11778\",\"name\":\"Caf\\u00e9 Coffee Day - Safdarjung Enclave\",\"address1\":\"Safdarjung Enclave \",\"latitude\":\"28.564245\",\"longitude\":\"77.189305\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110066\",\"phone\":\"9311954997\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/safdarjung-enclave\\/safdarjung-enclave-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11698\",\"name\":\"Caf\\u00e9 Coffee Day - Raja Garden\",\"address1\":\"Atrium Of The Building, No 11 Raja Garden, Shivaji Place\",\"latitude\":\"28.65064897\",\"longitude\":\"77.12038096\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110027\",\"phone\":\"011 32991352\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/raja-garden\\/raja-garden\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11450\",\"name\":\"Caf\\u00e9 Coffee Day - Mansarovar Garden\",\"address1\":\"B -158, Mansarovar Garden\\r\\n Kirti Nagar\\r\\n\",\"latitude\":\"28.6417242\",\"longitude\":\"77.1358821\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110015\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/kirti-nagar\\/mansarovar-garden\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10 :00 AM\",\"close_time\":\"9:30PM\"},{\"val\":\"11477\",\"name\":\"Caf\\u00e9 Coffee Day - MBD House\",\"address1\":\"Mbd House, Gulab Bhavan 6 Bhadurshah Zafar Marg\",\"latitude\":\"28.63228\",\"longitude\":\"77.24133\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110002\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/bahadurshah-zafar-marg\\/mbd-house\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11389\",\"name\":\"Caf\\u00e9 Coffee Day - Lajpat Nagar\",\"address1\":\"Lajpat Nagar \",\"latitude\":\"28.56929\",\"longitude\":\"77.242481\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110024\",\"phone\":\"011 32227997\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/lajpat-nagar\\/lajpat-nagar-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11544\",\"name\":\"Caf\\u00e9 Coffee Day - Najafgarh Road\",\"address1\":\"Plot No. 5, Najafgarh Road, Ramesh Nagar \",\"latitude\":\"28.652299\",\"longitude\":\"77.130547\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110015\",\"phone\":\"9312657671\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/ramesh-nagar\\/najafgarh-road\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11482\",\"name\":\"Caf\\u00e9 Coffee Day - Meher Chand Market\",\"address1\":\"Meher Chand Market, Lodhi Colony \",\"latitude\":\"28.58566\",\"longitude\":\"77.224778\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110003\",\"phone\":\"011 32212130\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/lodhi-colony\\/meher-chand-market\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11439\",\"name\":\"Caf\\u00e9 Coffee Day - Malviya Nagar\",\"address1\":\"New Malviya Nagar Market Malviya Nagar\",\"latitude\":\"28.536314\",\"longitude\":\"77.211076\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9310834187\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/malviya-nagar\\/malviya-nagar-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11475\",\"name\":\"Caf\\u00e9 Coffee Day - Mayur Vihar\",\"address1\":\"Shikka Plaza, Mayur Vihar \",\"latitude\":\"28.60624\",\"longitude\":\"77.287772\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110092\",\"phone\":\"9212802833\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/mayur-vihar\\/mayur-vihar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11488\",\"name\":\"Caf\\u00e9 Coffee Day - Mgf Metropolitian Mall\",\"address1\":\"Inside Mgf Metropolitian Mall, A-2,Press Enclave Marg District Centre, Saket\",\"latitude\":\"28.53021849\",\"longitude\":\"77.220186\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"9313275653\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/saket\\/mgf-metropolitian-mall\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11521\",\"name\":\"Caf\\u00e9 Coffee Day - Moolchand Metro Station\",\"address1\":\"Moolchand Metro Station, Lala Lajpat Rai Marg  Vikram Vihar, Lajpat Nagar 4\",\"latitude\":\"28.56434914\",\"longitude\":\"77.23446166\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110004\",\"phone\":\"9312261027\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/lajpat-nagar\\/moolchand-metro-station\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11520\",\"name\":\"Caf\\u00e9 Coffee Day - Moolchand\",\"address1\":\"Bpcl, Moolchand, Josip Broz Tito Marg, Block D Panchsheel Enclave\",\"latitude\":\"28.563229\",\"longitude\":\"77.232501\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110049\",\"phone\":\"9213020026\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/panchsheel-enclave\\/moolchand\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"3:00 AM\"},{\"val\":\"11531\",\"name\":\"Caf\\u00e9 Coffee Day - Mukherjee Nagar\",\"address1\":\"1604, Outram Lane, Mukherjee Nagar \",\"latitude\":\"28.698235\",\"longitude\":\"77.206619\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110009\",\"phone\":\"011 64638613\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/mukherjee-nagar\\/mukherjee-nagar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11565\",\"name\":\"Caf\\u00e9 Coffee Day - Nehru Place\",\"address1\":\"Tdi, Nehru Place Metro Station, Nehru Place \",\"latitude\":\"28.55062877\",\"longitude\":\"77.25185224\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110019\",\"phone\":\"011 64638619\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/nehru-place\\/nehru-place-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11564\",\"name\":\"Caf\\u00e9 Coffee Day - Nehru Place\",\"address1\":\"70, The Great Eastern Centre, Nehru Place \",\"latitude\":\"28.63448183\",\"longitude\":\"77.29094803\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110019\",\"phone\":\"011 65157044\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/nehru-place\\/nehru-place-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"9:00 PM\"},{\"val\":\"11567\",\"name\":\"Caf\\u00e9 Coffee Day - Netaji Subhash Place\",\"address1\":\"C # 1, 2,3  Pp Tower, Netaji Subhash Place Pitampura\",\"latitude\":\"28.690927\",\"longitude\":\"77.152975\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110034\",\"phone\":\"9350183363\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/pitampura\\/netaji-subhash-place\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"11469\",\"name\":\"Caf\\u00e9 Coffee Day - Max Hospital\",\"address1\":\"Max Hospital, Press Enclave Marg, Saket \",\"latitude\":\"28.527928\",\"longitude\":\"77.211276\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110048\",\"phone\":\"9312876358\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/saket\\/max-hospital-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"1\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"12:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"11468\",\"name\":\"Caf\\u00e9 Coffee Day - Max Healthcare\",\"address1\":\"2, Max Hospital, Press Enclave Road, Saket \",\"latitude\":\"28.527798\",\"longitude\":\"77.211396\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110048\",\"phone\":\"7428629635\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/saket\\/max-healthcare\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"1\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"12:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"11440\",\"name\":\"Caf\\u00e9 Coffee Day - Malviya Nagar\",\"address1\":\"C 64, Shivalik Colony, Malviya Nagar \",\"latitude\":\"28.535208\",\"longitude\":\"77.208552\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110075\",\"phone\":\"9310975823\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/malviya-nagar\\/malviya-nagar-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11279\",\"name\":\"The Square - Janpath\",\"address1\":\"44, Ground Floor, Tolstoy Road\\r\\n Janpath, Connaught Place\\r\\n\",\"latitude\":\"28.626719\",\"longitude\":\"77.219643\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/janpath\\/janpath-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"00\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"The Square\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11275\",\"name\":\"Caf\\u00e9 Coffee Day - Janakpuri District Centre\",\"address1\":\"Shivaji Marg, Janakpuri District Center, Janakpuri \",\"latitude\":\"28.63023013\",\"longitude\":\"77.07977101\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110054\",\"phone\":\"9312016861\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/janakpuri\\/janakpuri-district-centre\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11273\",\"name\":\"Caf\\u00e9 Coffee Day - Janakpuri\",\"address1\":\"B-2\\/84, Janakpuri \",\"latitude\":\"28.62923425\",\"longitude\":\"77.08604874\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110058\",\"phone\":\"9213021227\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/janakpuri\\/janakpuri\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"11274\",\"name\":\"Caf\\u00e9 Coffee Day - Janakpuri B Block\",\"address1\":\"Community Center, B 30, B Block, Janakpuri \",\"latitude\":\"28.6293179\",\"longitude\":\"77.0913541\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110058\",\"phone\":\"9213020157\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/janakpuri\\/janakpuri-b-block\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11277\",\"name\":\"Caf\\u00e9 Coffee Day - Janpath \",\"address1\":\"Mansion (Scindia House), Connaught, Atma Ram \",\"latitude\":\"28.54870594\",\"longitude\":\"77.12112665\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9313844129\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/janpath\\/janpath\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11312\",\"name\":\"Caf\\u00e9 Coffee Day - Kalkaji\",\"address1\":\"H1B, Kalkaji Main Road, Block H, Kalkaji \",\"latitude\":\"28.54010113\",\"longitude\":\"77.25806951\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110019\",\"phone\":\"9350185379\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/kalkaji\\/kalkaji-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11349\",\"name\":\"Caf\\u00e9 Coffee Day - Kingsway Camp\",\"address1\":\"Kingsway Camp, Near Gtb Nagar Metro Station Outram Lines, Mukherjee Nagar\",\"latitude\":\"28.698399\",\"longitude\":\"77.206771\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110009\",\"phone\":\"9312031280\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/outram-lines\\/kingsway-camp\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11350\",\"name\":\"Caf\\u00e9 Coffee Day - Kirti Nagar Metro Station\",\"address1\":\"Kirti Nagar Metro Station, Block J, Kirti Nagar \",\"latitude\":\"28.65561771\",\"longitude\":\"77.15099702\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110015\",\"phone\":\"9310090453\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/kirti-nagar\\/kirti-nagar-metro-station\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11331\",\"name\":\"Caf\\u00e9 Coffee Day - Karol Bagh Metro\",\"address1\":\"Shop No. 422D, Karol Bagh Metro Station \",\"latitude\":\"28.643297\",\"longitude\":\"77.188605\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110005\",\"phone\":\"011 32967482\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/karol-bagh\\/karol-bagh-metro\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11297\",\"name\":\"Caf\\u00e9 Coffee Day - Jhandewalan\",\"address1\":\"Block E, Jhandewalan \",\"latitude\":\"28.644687\",\"longitude\":\"77.199643\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110055\",\"phone\":\"011 32227995\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/jhandewalan\\/jhandewalan\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11245\",\"name\":\"Caf\\u00e9 Coffee Day - Inside Tdi Paragon Mall\",\"address1\":\"Tdi Paragon Mall, Shivaji Place, Vishal Enclave Rajouri Garden\",\"latitude\":\"28.65064897\",\"longitude\":\"77.12038096\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110027\",\"phone\":\"9312874574\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajouri-garden\\/inside-tdi-paragon-mall\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11198\",\"name\":\"Caf\\u00e9 Coffee Day - Inside Max Hospital\",\"address1\":\"Inside Max Hospital , Fc - 50, C & D Block Shalimar Bagh\",\"latitude\":\"28.72753109\",\"longitude\":\"77.15268016\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110088\",\"phone\":\"9312021712\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/shalimar-bagh\\/inside-max-hospital-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"7:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11032\",\"name\":\"Caf\\u00e9 Coffee Day - Hotel Chorus, New Delhi\",\"address1\":\"Hotel Chorus, First Floor, B Block, Inner Circle, Connaught Place\",\"latitude\":\"28.633839\",\"longitude\":\"77.218884\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110011\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/hotel-chorus-new-delhi\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"9:00 PM\"},{\"val\":\"10988\",\"name\":\"Caf\\u00e9 Coffee Day - Green Park Main\",\"address1\":\"S-34, Green Park Main Market\\r\\n \",\"latitude\":\"28.556233\",\"longitude\":\"77.2261\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110016\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/green-park\\/green-park-main\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11168\",\"name\":\"Caf\\u00e9 Coffee Day - IIT Delhi\",\"address1\":\"Exhibition Hall\\r\\n IIT Delhi\",\"latitude\":\"28.547767\",\"longitude\":\"77.1953276\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110016\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/indian-institute-technology\\/inside-iit-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11037\",\"name\":\"Caf\\u00e9 Coffee Day - Hotel Le Cadre\",\"address1\":\"E23, Ground Floor, Hotel Le Cadre\\r\\n Block E, East Of Kailash\\r\\n\",\"latitude\":\"28.5551178\",\"longitude\":\"77.2424188\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110065\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/east-kailash\\/hotel-le-cadre\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:30PM\"},{\"val\":\"11132\",\"name\":\"Caf\\u00e9 Coffee Day - Inside Cross River Mall\",\"address1\":\"Central Business Cross River Mall,\\r\\n Plot No. 9b & 9c\",\"latitude\":\"28.6571129\",\"longitude\":\"77.32259\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110032\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/shahdara\\/inside-cross-river-mall\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"10987\",\"name\":\"Caf\\u00e9 Coffee Day - Green Park\",\"address1\":\"Green Park \",\"latitude\":\"28.555483\",\"longitude\":\"77.202735\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110016\",\"phone\":\"9311609581\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/green-park\\/green-park\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11004\",\"name\":\"Caf\\u00e9 Coffee Day - Gymkhana Club\",\"address1\":\"Safdarjurng Road \",\"latitude\":\"28.597939\",\"longitude\":\"77.206145\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110029\",\"phone\":\"011 64000081\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/safdarjurng-road\\/gymkhana-club\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"11014\",\"name\":\"Caf\\u00e9 Coffee Day - Hauz Khas\",\"address1\":\"GF 26 Hauz Khas Village\",\"latitude\":\"28.554464\",\"longitude\":\"77.194033\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110016\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/hauz-khas\\/hauz-khas-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"12PM\"},{\"val\":\"11141\",\"name\":\"Caf\\u00e9 Coffee Day - Inside D Mall\",\"address1\":\"Inside D Mall, Netaji Subash Place, Ring Road, Wazirpur \",\"latitude\":\"28.69267391\",\"longitude\":\"77.15274835\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110034\",\"phone\":\"7428376172\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/wazirpur\\/inside-d-mall\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11002\",\"name\":\"Caf\\u00e9 Coffee Day - Gurunanak Pura\",\"address1\":\"A-47, Gurunanak Pura, Laxmi Nagar \",\"latitude\":\"28.63772812\",\"longitude\":\"77.2846797\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110092\",\"phone\":\"011 64592486\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/laxmi-nagar\\/gurunanak-pura\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"11038\",\"name\":\"Caf\\u00e9 Coffee Day - Hpcl, Green Park\",\"address1\":\"Hpcl Petrol Pump, Green Park \",\"latitude\":\"28.556823\",\"longitude\":\"77.206817\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110016\",\"phone\":\"9312876431\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/green-park\\/hpcl-green-park\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10828\",\"name\":\"The Square - Connaught Place\",\"address1\":\"Atma Ram House\\r\\n C 14, First Floor, C Block, Connaught Place\",\"latitude\":\"28.6342255\",\"longitude\":\"77.224981\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/connaught-place-4\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"000\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"The Square\",\"wifi\":\"1\",\"open_time\":\"11:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10937\",\"name\":\"Caf\\u00e9 Coffee Day - Fortis Hospital\",\"address1\":\"Ground Floor, Fortis Hospital, Shalimar Bagh\\r\\n near Khela Godown\\r\\n\",\"latitude\":\"28.71011043\",\"longitude\":\"77.16983902\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110088\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/shalimar-bagh\\/fortis-hospital\",\"near\":\"0\",\"veg\":\"2\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10898\",\"name\":\"Caf\\u00e9 Coffee Day - Dwarka\",\"address1\":\"Aggarwal Shopping Centre Golak Dham Market\\r\\n Sector 10 Dwarka, Dwarka\\r\\n\",\"latitude\":\"28.586663\",\"longitude\":\"77.56622\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110075\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/dwarka\\/dwarka\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"9:30PM\"},{\"val\":\"10978\",\"name\":\"Caf\\u00e9 Coffee Day - Gopinath Bazaar\",\"address1\":\"1B , Ground Floor, Gopinath Bazaar\\r\\n Shastri Bazaar, Delhi Cantt\\r\\n\",\"latitude\":\"28.597999\",\"longitude\":\"77.1325887\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110010\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/delhi-cantonment\\/gopinath-bazaar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10854\",\"name\":\"Caf\\u00e9 Coffee Day - Dda Market\",\"address1\":\"Ground Floor, DDA Market\\r\\n Shanti Niketan\\r\\n\",\"latitude\":\"28.5772737\",\"longitude\":\"77.1685243\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110044\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/moti-bagh\\/dda-market\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10902\",\"name\":\"Caf\\u00e9 Coffee Day - East Patel Nagar\",\"address1\":\"1\\/1E, East Patel Nagar \",\"latitude\":\"28.6456566\",\"longitude\":\"77.17020341\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110008\",\"phone\":\"9310146480\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/east-patel-nagar\\/east-patel-nagar-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10838\",\"name\":\"Caf\\u00e9 Coffee Day - CR Park\",\"address1\":\"K1\\/14, Main Road C R Park\",\"latitude\":\"28.5392\",\"longitude\":\"77.253047\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110019\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/cr-park\\/cr-park\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10884\",\"name\":\"Caf\\u00e9 Coffee Day - Dmrc Vishwavidyalaya \",\"address1\":\"Dmrc Vishwavidyalaya 2 Toms Vishwavidyalaya, 2 Toms\",\"latitude\":\"28.695427\",\"longitude\":\"77.214824\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110007\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/vishwavidyalaya\\/dmrc-vishwavidyalaya\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10882\",\"name\":\"Caf\\u00e9 Coffee Day - Dmrc Kashmere Gate\",\"address1\":\"Dmrc Kashmere Gate 3 Toms (Scr Site)\",\"latitude\":\"28.667704\",\"longitude\":\"77.227778\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110006\",\"phone\":\"9350319018\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/kashmere-gate\\/dmrc-kashmere-gate\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10879\",\"name\":\"Caf\\u00e9 Coffee Day - Dlf Shalimar Bagh\",\"address1\":\"Ap Block, Dlf City Centre, Shaheed Udham Singh Marg Poorvi Shalimar Bagh\",\"latitude\":\"28.702953\",\"longitude\":\"77.157347\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110052\",\"phone\":\"9310523021\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/shaheed-udham-singh-marg\\/dlf-shalimar-bagh\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10900\",\"name\":\"Caf\\u00e9 Coffee Day - East Of Kailash\",\"address1\":\"East Of Kailash, Ground Floor, North Side \",\"latitude\":\"28.559479\",\"longitude\":\"77.246513\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110065\",\"phone\":\"7428753518\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/east-kailash\\/east-kailash\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"10919\",\"name\":\"Caf\\u00e9 Coffee Day - Escorts Okhla\",\"address1\":\"1St Floor, Escorts Heart Institute, New Friends Colony Okhla Road\",\"latitude\":\"28.560788\",\"longitude\":\"77.273414\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110025\",\"phone\":\"9311222063\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/new-friends-colony\\/escorts-okhla\",\"near\":\"0\",\"veg\":\"2\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"1\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"12:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"10967\",\"name\":\"Caf\\u00e9 Coffee Day - Gk 2 M Block\",\"address1\":\"M 66, M Block, Greater Kailash Part 2 \",\"latitude\":\"28.54975087\",\"longitude\":\"77.23615595\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110048\",\"phone\":\"9310375757\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/greater-kailash-2\\/gk-2-m-block-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"10965\",\"name\":\"Caf\\u00e9 Coffee Day - Gk2\",\"address1\":\"Greater Kailash Ii, Main Market \",\"latitude\":\"28.533916\",\"longitude\":\"77.24488\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110048\",\"phone\":\"9312876799\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/greater-kailash-2\\/gk2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10832\",\"name\":\"Caf\\u00e9 Coffee Day - Cp Radial Road\",\"address1\":\"B Block, Radial Road, Connaught Place \",\"latitude\":\"28.633825\",\"longitude\":\"77.217885\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"011 65157045\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/cp-radial-road\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10903\",\"name\":\"Caf\\u00e9 Coffee Day - E Block Cp\",\"address1\":\"E-11, Mezzanine Floor, E Block, Connaught Place \",\"latitude\":\"28.63238569\",\"longitude\":\"77.22173346\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9213023594\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/e-block-cp\\/e-block-cp\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10874\",\"name\":\"Caf\\u00e9 Coffee Day - Dlf Jasola\",\"address1\":\"Dlf Tower A, Plot No. 10 Jasola\",\"latitude\":\"28.53848175\",\"longitude\":\"77.28979476\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110020\",\"phone\":\"9312750823\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/jasola\\/dlf-jasola\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"10883\",\"name\":\"Caf\\u00e9 Coffee Day - Dmrc Malviyanagar\",\"address1\":\"Malviyanagar 2 Tom'S (New)\",\"latitude\":\"28.528583\",\"longitude\":\"77.203228\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/malviyanagar\\/dmrc-malviyanagar\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10924\",\"name\":\"Caf\\u00e9 Coffee Day - Express Line\",\"address1\":\"Airport Metro Express Line \",\"latitude\":\"28.54870594\",\"longitude\":\"77.12112665\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110006\",\"phone\":\"9213022608\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/airport-metro-express-line\\/express-line\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10867\",\"name\":\"Caf\\u00e9 Coffee Day - Dinar Bhavan-Delhi\",\"address1\":\"1St Floor, Plot No 44, Dinar Bhavan Nehru Place\",\"latitude\":\"28.55016\",\"longitude\":\"77.252284\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110019\",\"phone\":\"011 64720012\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/nehru-place\\/dinar-bhavan-delhi\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10850\",\"name\":\"Caf\\u00e9 Coffee Day - Daryaganj\",\"address1\":\"3631, Hameed Manzil, Netaji Subhash Marg, Daryaganj Near?Golcha Cinema\",\"latitude\":\"28.647164\",\"longitude\":\"77.239924\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110002\",\"phone\":\"9312750438\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/daryaganj\\/daryaganj\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"10:00 PM\"},{\"val\":\"10827\",\"name\":\"Caf\\u00e9 Coffee Day - Connaught Place\",\"address1\":\"L 12, Connaught Place, Delhi Outer Circle \",\"latitude\":\"28.634462\",\"longitude\":\"77.22227\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"011 64580767\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/connaught-place-3\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10826\",\"name\":\"Caf\\u00e9 Coffee Day - Connaught Place\",\"address1\":\"M Block, Connaught Circus, Connaught \",\"latitude\":\"28.632678\",\"longitude\":\"77.222933\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9310181017\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/connaught-place-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10901\",\"name\":\"Caf\\u00e9 Coffee Day - East Patel Nagar\",\"address1\":\"11\\/15, East Patel Nagar \",\"latitude\":\"28.645059\",\"longitude\":\"77.169957\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110008\",\"phone\":\"9312875764\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/east-patel-nagar\\/east-patel-nagar-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10812\",\"name\":\"Caf\\u00e9 Coffee Day - City Square Mall\",\"address1\":\"Inside City Square, Najafgarh Road Raja Garden, Rajouri Garden\",\"latitude\":\"28.649925\",\"longitude\":\"77.123993\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110027\",\"phone\":\"9311136867\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/rajouri-garden\\/city-square-mall\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10824\",\"name\":\"Caf\\u00e9 Coffee Day - Computer Mart\",\"address1\":\"12, Computer Mart, Regal Building Connaught Place\",\"latitude\":\"28.631048\",\"longitude\":\"77.217015\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"7428653585\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/computer-mart\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10652\",\"name\":\"Caf\\u00e9 Coffee Day - Ashirwad Chowk\",\"address1\":\"Shop No. 11, Sector 5 Road\\r\\n Ashirwad Chowk, Dwarka\\r\\n\",\"latitude\":\"28.596558\",\"longitude\":\"77.5641\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110075\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/dwarka\\/ashirwad-chowk-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"10:00 AM\",\"close_time\":\"9:30 PM\"},{\"val\":\"10665\",\"name\":\"Caf\\u00e9 Coffee Day - Awwa Complex\",\"address1\":\"Pallavi Awwa Complex Opposite Taj Palace Hotel\\r\\n Chanakyapuri\\r\\n\",\"latitude\":\"28.595247\",\"longitude\":\"77.171954\",\"city\":\"New delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/new-delhi\\/chanakya-puri\\/awwa-complex\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"12:00 AM\"},{\"val\":\"10716\",\"name\":\"Caf\\u00e9 Coffee Day - B Block Cp\",\"address1\":\"B-28, Upper Ground Floor Inner Circle, B Block, Connaught Place\\r\\n\",\"latitude\":\"28.6342685\",\"longitude\":\"77.2194239\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"1800 102 5093\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/b-block-cp\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10595\",\"name\":\"Caf\\u00e9 Coffee Day - Adhchini\",\"address1\":\"97\\/1, Sri Aurobindo Marg, Adhchini \",\"latitude\":\"28.53868523\",\"longitude\":\"77.19872048\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"9313792371\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/adhchini\\/adhchini\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10602\",\"name\":\"Caf\\u00e9 Coffee Day - Alaknanda\",\"address1\":\"Nilgiri Apartments, Alaknanda Entrance Gate Alaknanda Don Bosco Road\",\"latitude\":\"28.52554\",\"longitude\":\"77.25148\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110017\",\"phone\":\"9310860243\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/alaknanda\\/alaknanda\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10609\",\"name\":\"Caf\\u00e9 Coffee Day - Amar Colony\",\"address1\":\"E\\/129, Amar Colony, Block E Lajpat Nagar\",\"latitude\":\"28.56043962\",\"longitude\":\"77.24047472\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110024\",\"phone\":\"011 32933806\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/lajpat-nagar\\/amar-colony-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10608\",\"name\":\"Caf\\u00e9 Coffee Day - Amar Colony\",\"address1\":\"Shop No 6, Main Market, Amar Colony Lajpat Nagar\",\"latitude\":\"28.560204\",\"longitude\":\"77.240346\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110024\",\"phone\":\"9350386473\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/lajpat-nagar\\/amar-colony-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10658\",\"name\":\"Caf\\u00e9 Coffee Day - Ashok Vihar Ii\",\"address1\":\"Community Centre, Dda Market, Ashok Vihar Ii, Phase 2 Ashok Vihar\",\"latitude\":\"28.69415459\",\"longitude\":\"77.17282087\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110052\",\"phone\":\"9311756722\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/ashok-vihar\\/ashok-vihar-ii\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10701\",\"name\":\"Caf\\u00e9 Coffee Day - Barakhamba Road \",\"address1\":\"Dcm Building, Barakhamba Road, Connaught Place \",\"latitude\":\"28.62971455\",\"longitude\":\"77.22564429\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9350389040\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/barakhamba-road\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10700\",\"name\":\"Caf\\u00e9 Coffee Day - Barakhamba Road\",\"address1\":\"Delhi House, Barakhamba Road \",\"latitude\":\"28.62560862\",\"longitude\":\"77.23296136\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9312007328\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/barakhamba-road\\/barakhamba-road\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10778\",\"name\":\"Caf\\u00e9 Coffee Day - Central Market\",\"address1\":\"55 - 56, Central Market, Lajpat Nagar Ii, Lajpat Nagar \",\"latitude\":\"28.56929\",\"longitude\":\"77.242481\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110024\",\"phone\":\"011 32310689\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/lajpat-nagar\\/central-market\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10753\",\"name\":\"Caf\\u00e9 Coffee Day - Bpcl Chanakya Puri\",\"address1\":\"Bpcl, Chanakya Puri \",\"latitude\":\"28.583407\",\"longitude\":\"77.191349\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110021\",\"phone\":\"7428072545\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/chanakya-puri\\/bpcl-chanakya-puri\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"0\",\"open_time\":\"8:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10709\",\"name\":\"Caf\\u00e9 Coffee Day - Basant Lok\",\"address1\":\"14A , Main Market, Basant Lok, Vasant Vihar \",\"latitude\":\"28.558793\",\"longitude\":\"77.163189\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110057\",\"phone\":\"7428367856\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/vasant-vihar\\/basant-lok\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10591\",\"name\":\"Caf\\u00e9 Coffee Day - Connaught Place\",\"address1\":\"A 21, A Block, Radial Road, Connaught Place \",\"latitude\":\"28.633195\",\"longitude\":\"77.218525\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110001\",\"phone\":\"9311810481\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/connaught-place\\/block-connaught-place\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10651\",\"name\":\"Caf\\u00e9 Coffee Day - Ashirwad Chowk\",\"address1\":\"Ashirwad Chowk, Dwarka \",\"latitude\":\"28.595649\",\"longitude\":\"77.048927\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110075\",\"phone\":\"011 32228030\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/dwarka\\/ashirwad-chowk-1\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"9:00 AM\",\"close_time\":\"11:00 PM\"},{\"val\":\"10657\",\"name\":\"Caf\\u00e9 Coffee Day - Ashok Nagar\",\"address1\":\"30 \\/3A Ds, Ashok Nagar Near Tilak Nagar Metro Station\",\"latitude\":\"28.63644749\",\"longitude\":\"77.09656834\",\"city\":\"Delhi\",\"state\":\"Delhi\",\"pincode\":\"110018\",\"phone\":\"9312877331\",\"storeUrl\":\"https:\\/\\/www.cafecoffeeday.com\\/store-locator\\/delhi\\/delhi\\/ashok-nagar\\/ashok-nagar-2\",\"near\":\"0\",\"veg\":\"3\",\"city_area\":\"\",\"highway\":\"0\",\"two4\":\"0\",\"type\":\"Cafe Coffee Day\",\"wifi\":\"1\",\"open_time\":\"10:00 AM\",\"close_time\":\"11:00 PM\"}]}\n"
     ]
    }
   ],
   "source": [
    "# Location Scrapper\n",
    "# url of the website where store locations data will be scrape\n",
    "# here i have cafe coffee day as my favourite retail brand in india\n",
    "url = 'https://www.cafecoffeeday.com/store-locator/delhi/'\n",
    "\n",
    "# requesting http and storing the response in a variable 'r'\n",
    "r = requests.get(url)\n",
    "\n",
    "# checking the status for the response object (200 is ok, 404 is not found)\n",
    "print(r.status_code)\n",
    "\n",
    "# parse the html content of the response using BeautifulSoup and storing the resulting object in a variable 'soup'\n",
    "soup = BeautifulSoup(r.content,'html.parser')\n",
    "\n",
    "# checking if we getting the write html content\n",
    "print(soup.title.text)\n",
    "\n",
    "# The data we need is in script element that contains scripting statements \n",
    "# and the data is in JSON (objects literals contains key/value pairs) \n",
    "script = soup.find_all('script')[11].text.strip()[30:-277]\n",
    "\n",
    "# print the key value pairs data\n",
    "print(script)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "7f7e293b",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = json.loads(script)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c55cbcdb",
   "metadata": {},
   "outputs": [],
   "source": [
    "# we don't need the first element from data (locationTitle)\n",
    "ccd = data['locations']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "85debf57",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'val': '12403', 'name': 'Café Coffee Day - Rajouri Garden', 'address1': 'Building No 13/57, J Block\\r\\n Rajouri Garden\\r\\n', 'latitude': '28.6397488', 'longitude': '77.1181652', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110027', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi-4', 'near': '0', 'veg': '', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00', 'close_time': '9:30'}, {'val': '12401', 'name': 'Café Coffee Day - Vishal Enclave', 'address1': '24\\r\\n Block A, Vishal Enclave, Rajouri Garden\\r\\n', 'latitude': '28.6489842', 'longitude': '77.12184', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110027', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi-3', 'near': '0', 'veg': '', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00', 'close_time': '09:30'}, {'val': '12396', 'name': 'Café Coffee Day - Janakpuri', 'address1': 'Block B 2B/14, Janakpuri\\r\\n ', 'latitude': '28.63344', 'longitude': '77.94284', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110058', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi-2', 'near': '0', 'veg': '', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '09:00', 'close_time': '11:00'}, {'val': '12394', 'name': 'Café Coffee Day - Mandi House', 'address1': 'Shop No 49, Plot 7, Block 205 C, Tansen Marg\\r\\n Next to Annakoot, Mandi House\\r\\n\\r\\n', 'latitude': '28.6294921', 'longitude': '77.232787', 'city': 'New delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/new-delhi-0', 'near': '0', 'veg': '', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00', 'close_time': '10:00'}, {'val': '12390', 'name': 'Café Coffee Day - Lajpath Nagar', 'address1': 'A-10, Lajpath Nagar Part-2 ', 'latitude': '28.569843', 'longitude': '77.238611', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110024', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi-1', 'near': '0', 'veg': '', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00', 'close_time': '23:00'}, {'val': '12388', 'name': 'Café Coffee Day - New Friends Colony', 'address1': '14, Community Center, Ground Floor\\r\\n New Friends Colony\\r\\n', 'latitude': '28.562661', 'longitude': '77.2689677', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110065', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi-0', 'near': '0', 'veg': '', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00', 'close_time': '11:30'}, {'val': '12318', 'name': 'Café Coffee Day - Janakpuri', 'address1': 'C3-78, Major P Srikumar Marg\\r\\n Block C3A, Block C3, Janakpuri', 'latitude': '28.615781', 'longitude': '77.879554', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110058', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/janakpuri/janakpuri-0', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '12306', 'name': ' Café Coffee Day - Janak Cinema', 'address1': 'C Block, Janakpuri, Near Mata Chandan Devi Hospital C Block, Janakpuri, Near Mata Chandan Devi Hospital', 'latitude': '28.610926', 'longitude': '77.0916334', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110059', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/janak-cinema', 'near': '0', 'veg': '3', 'city_area': '0', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '12301', 'name': 'Café Coffee Day - Dlf Sarojini Nagar Delhi', 'address1': 'Dlf Sarojini Nagar Delhi Dlf Sarojini Nagar Delhi', 'latitude': '28.5763', 'longitude': '77.1951', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110023', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/dlf-sarojini-nagar-delhi', 'near': '0', 'veg': '3', 'city_area': '000', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '12300', 'name': 'Café Coffee Day - Bengali Market Delhi', 'address1': 'Bengali Market Delhi Bengali Market Delhi', 'latitude': '28.6295', 'longitude': '77.2322', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/bengali-market-delhi', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '12244', 'name': 'Café Coffee Day - Shopper Stop Rohini', 'address1': 'FFF Crown Plaza, Plot Number 3B1\\r\\n Bhagawan Mahavir Marg, Sector 10, Rohini\\r\\n\\r\\n', 'latitude': '28.719748', 'longitude': '77.19988', 'city': 'New delhi', 'state': 'Delhi', 'pincode': '110085', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/new-delhi/shopper-stop-rohini', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '11:00 AM', 'close_time': '9:30 PM'}, {'val': '12288', 'name': 'Café Coffee Day - Kamlanagar Building No 26b1 & 27 A1 Del', 'address1': 'Building No 26B/1 & 27 A/1\\r\\n Jawahar Nagar, Kamla Nagar', 'latitude': '28.679952', 'longitude': '77.28535', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110010', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/kamlanagar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '9:30PM'}, {'val': '12270', 'name': 'Café Coffee Day - Pod Food Court Dhaula Kuan Metro Stn', 'address1': 'Pod Food Court Dhaula Kuan Metro Stn ', 'latitude': '49.29', 'longitude': '84', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110007', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/pod-food-court', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '11:00 AM', 'close_time': '1:00 AM'}, {'val': '12141', 'name': 'Café Coffee Day - Pinnacle Mall', 'address1': 'Atrium, Pinnacle Mall Sector 10, Dwarka', 'latitude': '28.57946205', 'longitude': '77.05601501', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110075', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/dwarka/dwarka-0', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '12080', 'name': 'Café Coffee Day - PSRI Hospital', 'address1': 'PSRI Hospital, Ground Floor\\r\\n Sheikh Sarai\\r\\n', 'latitude': '28.533991', 'longitude': '77.225599', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/sheikh-sarai/sheikh-sarai', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '10:00 PM'}, {'val': '12081', 'name': 'Café Coffee Day - Parsvanath Mall', 'address1': 'Shop No G 08 & G 09\\r\\n Parsvanath Mall, Akshardham Metro Station\\r\\n', 'latitude': '28.6178687', 'longitude': '77.279468', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110092', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/akshardham/akshardham', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '10:00 PM'}, {'val': '12079', 'name': 'Café Coffee Day - East Of Kailash', 'address1': 'Building No.19 East Of Kailash Comunity Center', 'latitude': '28.5584685', 'longitude': '77.2454778', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110065', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/east-kailash/east-kailash-0', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11993', 'name': 'Café Coffee Day - Vasant Square Mall', 'address1': 'Vasant square Mall Plot No A Community Center Sector-B, Vasant Kunj', 'latitude': '28.52564', 'longitude': '77.156792', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110070', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/vasant-kunj/vasant-square-mall', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11806', 'name': 'Café Coffee Day - Sarita Vihar', 'address1': 'Cross Shop no 14, DDA Market Sarita Vihar ', 'latitude': '28.5336627', 'longitude': '77.225945', 'city': 'New delhi', 'state': 'Delhi', 'pincode': '110076', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/new-delhi/sarita-vihar/sarita-vihar-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11913', 'name': 'Café Coffee Day - Star City Mall', 'address1': '33 Ground Floor, Star City Mall\\r\\n Mayur Place, Mayur Vihar I', 'latitude': '28.592657', 'longitude': '77.2964362', 'city': 'New delhi', 'state': 'Delhi', 'pincode': '110091', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/new-delhi/mayur-vihar/star-city-mall', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11807', 'name': 'Café Coffee Day - Sarita Vihar', 'address1': 'Inside Indraprastha Apollo Hospital Mathura Road, Sarita Vihar', 'latitude': '28.5409', 'longitude': '77.282456', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110076', 'phone': '7428235992', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/sarita-vihar/sarita-vihar-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '1', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '12:00 AM', 'close_time': '12:00 AM'}, {'val': '11902', 'name': 'Café Coffee Day - Splendor Forum', 'address1': 'G-18, Splendor Forum, Jasola ', 'latitude': '28.539228', 'longitude': '77.284486', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110044', 'phone': '9312877018', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/jasola/splendor-forum', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '10:00 PM'}, {'val': '11948', 'name': 'Café Coffee Day - The Mall Road', 'address1': 'Plot No. 61, Mall Road, Kingsway Camp ', 'latitude': '28.697905', 'longitude': '77.206579', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110009', 'phone': '9313307343', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/mall-road/mall-road', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '11974', 'name': 'Café Coffee Day - Unitech Amusement Park', 'address1': 'Unitech Amusement Park, Rohini Near Rithala Metro Station', 'latitude': '28.727433', 'longitude': '77.116135', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9213022186', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rohini/unitech-amusement-park', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '12033', 'name': 'Café Coffee Day - West Patel Nagar', 'address1': 'Plot No. 8,  Block No. 42, West Patel Nagar ', 'latitude': '28.65087375', 'longitude': '77.15971291', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110008', 'phone': '011 32213990', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/west-patel-nagar/west-patel-nagar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11813', 'name': 'Café Coffee Day - Satya Niketan', 'address1': '283 Satya Niketan, Main Market Opposite Venketeshwara College', 'latitude': '28.58767811', 'longitude': '77.1671752', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110021', 'phone': '9350767550', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/satya-niketan/satya-niketan', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11820', 'name': 'Café Coffee Day - Sector 10', 'address1': 'Crown Plaza, Plot Number 3B1, Sector 10 Bhagawan Mahavir Marg, Rohini', 'latitude': '28.7196608', 'longitude': '77.10912644', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '160010', 'phone': '9213023168', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rohini/sector-10-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '11865', 'name': 'Café Coffee Day - Shivaji Marg', 'address1': 'Plot No. 29, Shivaji Marg, Najafgarh Road Industrial Area ', 'latitude': '28.66098497', 'longitude': '77.14859121', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110015', 'phone': '011 32213946', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/shivaji-marg/shivaji-marg', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11869', 'name': 'Café Coffee Day - Shivalik', 'address1': 'A-6, Shivalik, Near Malviya Nagar ', 'latitude': '28.535208', 'longitude': '77.208552', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '011 65157046', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/shivalik/shivalik', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11899', 'name': 'Café Coffee Day - South Extension 2', 'address1': 'Ring Road, South Extension Ii ', 'latitude': '28.568657', 'longitude': '77.218487', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110049', 'phone': '011 64638601', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/south-extension-ii/south-extension-2', 'near': '0', 'veg': '2', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11981', 'name': 'Café Coffee Day - V3S East Centre', 'address1': 'Plot No. 12, V3S East Centre, Laxmi Nagar ', 'latitude': '28.637318', 'longitude': '77.286632', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '9312099260', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/laxmi-nagar/v3s-east-centre', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '11764', 'name': 'Café Coffee Day - Rohini City Center', 'address1': 'Plot No-1B3, Twin District Center\\r\\n Sector 10, Rohini,\\r\\n', 'latitude': '28.7169595', 'longitude': '77.114614', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110085', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rohini/rohini-city-center', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '11:00 AM', 'close_time': '9:30 PM'}, {'val': '11664', 'name': 'Café Coffee Day - Prashanth Vihar', 'address1': '36 & 37, Opposite CRPF Public School, Sector 14 Prashant Vihar\\r\\n', 'latitude': '28.7193', 'longitude': '77.13396', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110085', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rohini/prashanth-vihar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '11:00 AM', 'close_time': '09:30 PM'}, {'val': '11634', 'name': 'Café Coffee Day - Paschim Vihar', 'address1': 'A3/320, Jwala Heri Market, Paschim Vihar\\r\\n ', 'latitude': '28.67448', 'longitude': '77.126372', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110063', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/paschim-vihar/paschim-vihar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '11:00 AM', 'close_time': '9:30 PM'}, {'val': '11601', 'name': 'Café Coffee Day - Old Rajendra Nagar', 'address1': '5/54, Ground Floor, Old Rajendra Nagar\\r\\n Shankar Road', 'latitude': '28.638523', 'longitude': '77.18376', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110060', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/old-rajendra-nagar/old-rajendra-nagar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11710', 'name': 'Café Coffee Day - Rajiv Chowk Metro Station', 'address1': 'RCK 02\\r\\n Rajiv Chowk Metro Station\\r\\n', 'latitude': '28.63294887', 'longitude': '77.21915968', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajiv-chowk/rajiv-chowk-metro-station-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11740', 'name': 'Café Coffee Day - Regal Building', 'address1': 'Ground Floor, Regal Building Connaught Place\\r\\n', 'latitude': '28.63175146', 'longitude': '77.21681942', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/regal-building', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '09:00 PM'}, {'val': '11720', 'name': 'Café Coffee Day - Ramakrishna Ashram Marg', 'address1': 'U22 Agn, Ramakrishna Ashram Marg ', 'latitude': '28.6395408', 'longitude': '77.2085157', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110055', 'phone': '9312874178', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/ramakrishna-ashram-marg/ramakrishna-ashram-marg', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11673', 'name': 'Café Coffee Day - Punjabi Bagh', 'address1': 'Shop No 6, Club Road, Punjabi Bagh ', 'latitude': '28.665707', 'longitude': '77.125873', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110026', 'phone': '011 32931770', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/punjabi-bagh/punjabi-bagh', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11638', 'name': 'Café Coffee Day - Patpargunj', 'address1': 'Max Hospital, I P Extension, Patpargunj ', 'latitude': '28.634015', 'longitude': '77.309819', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '9350934679', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/patpargunj/patpargunj', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '1', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '12:00 AM', 'close_time': '12:00 AM'}, {'val': '11706', 'name': 'Café Coffee Day - Rajendra Place Metro Station', 'address1': 'Rajendra Place Metro Station, Rp U22 Cgn Rajendra Place', 'latitude': '28.64241107', 'longitude': '77.17822593', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110008', 'phone': '9310146480', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajendra-place/rajendra-place-metro-station', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11684', 'name': 'Café Coffee Day - Pvr Naraina', 'address1': 'Pvr, Industrial Area, Community Centre, Naraina Naraina Industrial Area Phase I', 'latitude': '28.633573', 'longitude': '77.139135', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110028', 'phone': '9312066583', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/naraina/pvr-naraina', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '11687', 'name': 'Café Coffee Day - Qutub Minar', 'address1': 'Villa Haven, Ten Style Mile, Near Qutub Minar Mehrauli', 'latitude': '28.52550014', 'longitude': '77.18534549', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110030', 'phone': '9312873664', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/mehrauli/qutub-minar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11674', 'name': 'Café Coffee Day - Pusa Road', 'address1': 'Karol Bagh Metro Station, Pusa Road ', 'latitude': '28.643437', 'longitude': '77.188495', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110005', 'phone': '9313483850', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/pusa-road/pusa-road', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '9:00 PM'}, {'val': '11711', 'name': 'Café Coffee Day - Rajiv Chowk Metro Station', 'address1': 'Rajiv Chowk Metro Station D Block 4 Toms', 'latitude': '28.633899', 'longitude': '77.219285', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajiv-chowk/rajiv-chowk-metro-station-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '12:00 AM', 'close_time': '12:00 AM'}, {'val': '11708', 'name': 'Café Coffee Day - Rajiv Chowk', 'address1': 'Rck 06, Rajiv Chowk ', 'latitude': '28.631524', 'longitude': '77.219324', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9312875408', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajiv-chowk/rajiv-chowk-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11709', 'name': 'Café Coffee Day - Rajiv Chowk Metro F Block', 'address1': 'F Block 4 Toms Rajiv Chowk Metro Station', 'latitude': '28.631481', 'longitude': '77.219504', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajiv-chowk/rajiv-chowk-metro-f-block', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '10:00 PM'}, {'val': '11712', 'name': 'Café Coffee Day - Rajiv Chowk Metro Station A-Block', 'address1': 'A Blk 4 Toms Rajiv Chowk Metro Station ', 'latitude': '28.633967', 'longitude': '77.218567', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajiv-chowk/rajiv-chowk-metro-station-block', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '10:00 PM'}, {'val': '11713', 'name': 'Café Coffee Day - Rajiv Chowk Metro Station Rck 05', 'address1': 'RCK 05, Rajiv Chowk Metro Station, Connaught Place ', 'latitude': '28.63265', 'longitude': '77.219421', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9350294925', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/rajiv-chowk-metro-station-rck-05', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11707', 'name': 'Café Coffee Day - Rajiv Chowk', 'address1': 'Dmrc, Rajiv Chowk ', 'latitude': '28.631524', 'longitude': '77.219324', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9312874924', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajiv-chowk/rajiv-chowk-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11763', 'name': 'Café Coffee Day - Rockland Hospital', 'address1': 'Rockland Hospital, B-33 & 34, Qutab Institutional Area Tara Crescent, Block A', 'latitude': '28.53732794', 'longitude': '77.18103287', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110016', 'phone': '9350233558', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/tara-crescent/rockland-hospital', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '8:00 PM'}, {'val': '11765', 'name': 'Café Coffee Day - Rohini Sector 7', 'address1': 'Plot No. 23 , Pocket No. 9, Sector 7 , Rohini ', 'latitude': '28.70955738', 'longitude': '77.12269574', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110085', 'phone': '011 64000083', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rohini/rohini-sector-7', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11779', 'name': 'Café Coffee Day - Safdarjung Enclave', 'address1': 'Nauroji Nagar Marg, Safdarjung Enclave Near Kamal Cinema', 'latitude': '28.565347', 'longitude': '77.199393', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110029', 'phone': '011 64638611', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/safdarjung-enclave/safdarjung-enclave-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11778', 'name': 'Café Coffee Day - Safdarjung Enclave', 'address1': 'Safdarjung Enclave ', 'latitude': '28.564245', 'longitude': '77.189305', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110066', 'phone': '9311954997', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/safdarjung-enclave/safdarjung-enclave-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '11698', 'name': 'Café Coffee Day - Raja Garden', 'address1': 'Atrium Of The Building, No 11 Raja Garden, Shivaji Place', 'latitude': '28.65064897', 'longitude': '77.12038096', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110027', 'phone': '011 32991352', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/raja-garden/raja-garden', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11450', 'name': 'Café Coffee Day - Mansarovar Garden', 'address1': 'B -158, Mansarovar Garden\\r\\n Kirti Nagar\\r\\n', 'latitude': '28.6417242', 'longitude': '77.1358821', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110015', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/kirti-nagar/mansarovar-garden', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10 :00 AM', 'close_time': '9:30PM'}, {'val': '11477', 'name': 'Café Coffee Day - MBD House', 'address1': 'Mbd House, Gulab Bhavan 6 Bhadurshah Zafar Marg', 'latitude': '28.63228', 'longitude': '77.24133', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110002', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/bahadurshah-zafar-marg/mbd-house', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11389', 'name': 'Café Coffee Day - Lajpat Nagar', 'address1': 'Lajpat Nagar ', 'latitude': '28.56929', 'longitude': '77.242481', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110024', 'phone': '011 32227997', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/lajpat-nagar/lajpat-nagar-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11544', 'name': 'Café Coffee Day - Najafgarh Road', 'address1': 'Plot No. 5, Najafgarh Road, Ramesh Nagar ', 'latitude': '28.652299', 'longitude': '77.130547', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110015', 'phone': '9312657671', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/ramesh-nagar/najafgarh-road', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '10:00 PM'}, {'val': '11482', 'name': 'Café Coffee Day - Meher Chand Market', 'address1': 'Meher Chand Market, Lodhi Colony ', 'latitude': '28.58566', 'longitude': '77.224778', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110003', 'phone': '011 32212130', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/lodhi-colony/meher-chand-market', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11439', 'name': 'Café Coffee Day - Malviya Nagar', 'address1': 'New Malviya Nagar Market Malviya Nagar', 'latitude': '28.536314', 'longitude': '77.211076', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9310834187', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/malviya-nagar/malviya-nagar-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11475', 'name': 'Café Coffee Day - Mayur Vihar', 'address1': 'Shikka Plaza, Mayur Vihar ', 'latitude': '28.60624', 'longitude': '77.287772', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110092', 'phone': '9212802833', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/mayur-vihar/mayur-vihar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '11488', 'name': 'Café Coffee Day - Mgf Metropolitian Mall', 'address1': 'Inside Mgf Metropolitian Mall, A-2,Press Enclave Marg District Centre, Saket', 'latitude': '28.53021849', 'longitude': '77.220186', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '9313275653', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/saket/mgf-metropolitian-mall', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11521', 'name': 'Café Coffee Day - Moolchand Metro Station', 'address1': 'Moolchand Metro Station, Lala Lajpat Rai Marg  Vikram Vihar, Lajpat Nagar 4', 'latitude': '28.56434914', 'longitude': '77.23446166', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110004', 'phone': '9312261027', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/lajpat-nagar/moolchand-metro-station', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11520', 'name': 'Café Coffee Day - Moolchand', 'address1': 'Bpcl, Moolchand, Josip Broz Tito Marg, Block D Panchsheel Enclave', 'latitude': '28.563229', 'longitude': '77.232501', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110049', 'phone': '9213020026', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/panchsheel-enclave/moolchand', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '3:00 AM'}, {'val': '11531', 'name': 'Café Coffee Day - Mukherjee Nagar', 'address1': '1604, Outram Lane, Mukherjee Nagar ', 'latitude': '28.698235', 'longitude': '77.206619', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110009', 'phone': '011 64638613', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/mukherjee-nagar/mukherjee-nagar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '11565', 'name': 'Café Coffee Day - Nehru Place', 'address1': 'Tdi, Nehru Place Metro Station, Nehru Place ', 'latitude': '28.55062877', 'longitude': '77.25185224', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110019', 'phone': '011 64638619', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/nehru-place/nehru-place-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '11564', 'name': 'Café Coffee Day - Nehru Place', 'address1': '70, The Great Eastern Centre, Nehru Place ', 'latitude': '28.63448183', 'longitude': '77.29094803', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110019', 'phone': '011 65157044', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/nehru-place/nehru-place-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '9:00 PM'}, {'val': '11567', 'name': 'Café Coffee Day - Netaji Subhash Place', 'address1': 'C # 1, 2,3  Pp Tower, Netaji Subhash Place Pitampura', 'latitude': '28.690927', 'longitude': '77.152975', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110034', 'phone': '9350183363', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/pitampura/netaji-subhash-place', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '12:00 AM'}, {'val': '11469', 'name': 'Café Coffee Day - Max Hospital', 'address1': 'Max Hospital, Press Enclave Marg, Saket ', 'latitude': '28.527928', 'longitude': '77.211276', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110048', 'phone': '9312876358', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/saket/max-hospital-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '1', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '12:00 AM', 'close_time': '12:00 AM'}, {'val': '11468', 'name': 'Café Coffee Day - Max Healthcare', 'address1': '2, Max Hospital, Press Enclave Road, Saket ', 'latitude': '28.527798', 'longitude': '77.211396', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110048', 'phone': '7428629635', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/saket/max-healthcare', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '1', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '12:00 AM', 'close_time': '12:00 AM'}, {'val': '11440', 'name': 'Café Coffee Day - Malviya Nagar', 'address1': 'C 64, Shivalik Colony, Malviya Nagar ', 'latitude': '28.535208', 'longitude': '77.208552', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110075', 'phone': '9310975823', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/malviya-nagar/malviya-nagar-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11279', 'name': 'The Square - Janpath', 'address1': '44, Ground Floor, Tolstoy Road\\r\\n Janpath, Connaught Place\\r\\n', 'latitude': '28.626719', 'longitude': '77.219643', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/janpath/janpath-2', 'near': '0', 'veg': '3', 'city_area': '00', 'highway': '0', 'two4': '0', 'type': 'The Square', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11275', 'name': 'Café Coffee Day - Janakpuri District Centre', 'address1': 'Shivaji Marg, Janakpuri District Center, Janakpuri ', 'latitude': '28.63023013', 'longitude': '77.07977101', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110054', 'phone': '9312016861', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/janakpuri/janakpuri-district-centre', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11273', 'name': 'Café Coffee Day - Janakpuri', 'address1': 'B-2/84, Janakpuri ', 'latitude': '28.62923425', 'longitude': '77.08604874', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110058', 'phone': '9213021227', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/janakpuri/janakpuri', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '12:00 AM'}, {'val': '11274', 'name': 'Café Coffee Day - Janakpuri B Block', 'address1': 'Community Center, B 30, B Block, Janakpuri ', 'latitude': '28.6293179', 'longitude': '77.0913541', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110058', 'phone': '9213020157', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/janakpuri/janakpuri-b-block', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11277', 'name': 'Café Coffee Day - Janpath ', 'address1': 'Mansion (Scindia House), Connaught, Atma Ram ', 'latitude': '28.54870594', 'longitude': '77.12112665', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9313844129', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/janpath/janpath', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11312', 'name': 'Café Coffee Day - Kalkaji', 'address1': 'H1B, Kalkaji Main Road, Block H, Kalkaji ', 'latitude': '28.54010113', 'longitude': '77.25806951', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110019', 'phone': '9350185379', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/kalkaji/kalkaji-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11349', 'name': 'Café Coffee Day - Kingsway Camp', 'address1': 'Kingsway Camp, Near Gtb Nagar Metro Station Outram Lines, Mukherjee Nagar', 'latitude': '28.698399', 'longitude': '77.206771', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110009', 'phone': '9312031280', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/outram-lines/kingsway-camp', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '11350', 'name': 'Café Coffee Day - Kirti Nagar Metro Station', 'address1': 'Kirti Nagar Metro Station, Block J, Kirti Nagar ', 'latitude': '28.65561771', 'longitude': '77.15099702', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110015', 'phone': '9310090453', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/kirti-nagar/kirti-nagar-metro-station', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11331', 'name': 'Café Coffee Day - Karol Bagh Metro', 'address1': 'Shop No. 422D, Karol Bagh Metro Station ', 'latitude': '28.643297', 'longitude': '77.188605', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110005', 'phone': '011 32967482', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/karol-bagh/karol-bagh-metro', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11297', 'name': 'Café Coffee Day - Jhandewalan', 'address1': 'Block E, Jhandewalan ', 'latitude': '28.644687', 'longitude': '77.199643', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110055', 'phone': '011 32227995', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/jhandewalan/jhandewalan', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11245', 'name': 'Café Coffee Day - Inside Tdi Paragon Mall', 'address1': 'Tdi Paragon Mall, Shivaji Place, Vishal Enclave Rajouri Garden', 'latitude': '28.65064897', 'longitude': '77.12038096', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110027', 'phone': '9312874574', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajouri-garden/inside-tdi-paragon-mall', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '11198', 'name': 'Café Coffee Day - Inside Max Hospital', 'address1': 'Inside Max Hospital , Fc - 50, C & D Block Shalimar Bagh', 'latitude': '28.72753109', 'longitude': '77.15268016', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110088', 'phone': '9312021712', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/shalimar-bagh/inside-max-hospital-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '7:00 AM', 'close_time': '11:00 PM'}, {'val': '11032', 'name': 'Café Coffee Day - Hotel Chorus, New Delhi', 'address1': 'Hotel Chorus, First Floor, B Block, Inner Circle, Connaught Place', 'latitude': '28.633839', 'longitude': '77.218884', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110011', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/hotel-chorus-new-delhi', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '9:00 PM'}, {'val': '10988', 'name': 'Café Coffee Day - Green Park Main', 'address1': 'S-34, Green Park Main Market\\r\\n ', 'latitude': '28.556233', 'longitude': '77.2261', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110016', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/green-park/green-park-main', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11168', 'name': 'Café Coffee Day - IIT Delhi', 'address1': 'Exhibition Hall\\r\\n IIT Delhi', 'latitude': '28.547767', 'longitude': '77.1953276', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110016', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/indian-institute-technology/inside-iit-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11037', 'name': 'Café Coffee Day - Hotel Le Cadre', 'address1': 'E23, Ground Floor, Hotel Le Cadre\\r\\n Block E, East Of Kailash\\r\\n', 'latitude': '28.5551178', 'longitude': '77.2424188', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110065', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/east-kailash/hotel-le-cadre', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:30PM'}, {'val': '11132', 'name': 'Café Coffee Day - Inside Cross River Mall', 'address1': 'Central Business Cross River Mall,\\r\\n Plot No. 9b & 9c', 'latitude': '28.6571129', 'longitude': '77.32259', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110032', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/shahdara/inside-cross-river-mall', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '10:00 PM'}, {'val': '10987', 'name': 'Café Coffee Day - Green Park', 'address1': 'Green Park ', 'latitude': '28.555483', 'longitude': '77.202735', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110016', 'phone': '9311609581', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/green-park/green-park', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '11004', 'name': 'Café Coffee Day - Gymkhana Club', 'address1': 'Safdarjurng Road ', 'latitude': '28.597939', 'longitude': '77.206145', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110029', 'phone': '011 64000081', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/safdarjurng-road/gymkhana-club', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '10:00 PM'}, {'val': '11014', 'name': 'Café Coffee Day - Hauz Khas', 'address1': 'GF 26 Hauz Khas Village', 'latitude': '28.554464', 'longitude': '77.194033', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110016', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/hauz-khas/hauz-khas-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '12PM'}, {'val': '11141', 'name': 'Café Coffee Day - Inside D Mall', 'address1': 'Inside D Mall, Netaji Subash Place, Ring Road, Wazirpur ', 'latitude': '28.69267391', 'longitude': '77.15274835', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110034', 'phone': '7428376172', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/wazirpur/inside-d-mall', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11002', 'name': 'Café Coffee Day - Gurunanak Pura', 'address1': 'A-47, Gurunanak Pura, Laxmi Nagar ', 'latitude': '28.63772812', 'longitude': '77.2846797', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110092', 'phone': '011 64592486', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/laxmi-nagar/gurunanak-pura', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '11038', 'name': 'Café Coffee Day - Hpcl, Green Park', 'address1': 'Hpcl Petrol Pump, Green Park ', 'latitude': '28.556823', 'longitude': '77.206817', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110016', 'phone': '9312876431', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/green-park/hpcl-green-park', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10828', 'name': 'The Square - Connaught Place', 'address1': 'Atma Ram House\\r\\n C 14, First Floor, C Block, Connaught Place', 'latitude': '28.6342255', 'longitude': '77.224981', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/connaught-place-4', 'near': '0', 'veg': '3', 'city_area': '000', 'highway': '0', 'two4': '0', 'type': 'The Square', 'wifi': '1', 'open_time': '11:00 AM', 'close_time': '11:00 PM'}, {'val': '10937', 'name': 'Café Coffee Day - Fortis Hospital', 'address1': 'Ground Floor, Fortis Hospital, Shalimar Bagh\\r\\n near Khela Godown\\r\\n', 'latitude': '28.71011043', 'longitude': '77.16983902', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110088', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/shalimar-bagh/fortis-hospital', 'near': '0', 'veg': '2', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10898', 'name': 'Café Coffee Day - Dwarka', 'address1': 'Aggarwal Shopping Centre Golak Dham Market\\r\\n Sector 10 Dwarka, Dwarka\\r\\n', 'latitude': '28.586663', 'longitude': '77.56622', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110075', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/dwarka/dwarka', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '9:30PM'}, {'val': '10978', 'name': 'Café Coffee Day - Gopinath Bazaar', 'address1': '1B , Ground Floor, Gopinath Bazaar\\r\\n Shastri Bazaar, Delhi Cantt\\r\\n', 'latitude': '28.597999', 'longitude': '77.1325887', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110010', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/delhi-cantonment/gopinath-bazaar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10854', 'name': 'Café Coffee Day - Dda Market', 'address1': 'Ground Floor, DDA Market\\r\\n Shanti Niketan\\r\\n', 'latitude': '28.5772737', 'longitude': '77.1685243', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110044', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/moti-bagh/dda-market', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10902', 'name': 'Café Coffee Day - East Patel Nagar', 'address1': '1/1E, East Patel Nagar ', 'latitude': '28.6456566', 'longitude': '77.17020341', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110008', 'phone': '9310146480', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/east-patel-nagar/east-patel-nagar-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '10838', 'name': 'Café Coffee Day - CR Park', 'address1': 'K1/14, Main Road C R Park', 'latitude': '28.5392', 'longitude': '77.253047', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110019', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/cr-park/cr-park', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10884', 'name': 'Café Coffee Day - Dmrc Vishwavidyalaya ', 'address1': 'Dmrc Vishwavidyalaya 2 Toms Vishwavidyalaya, 2 Toms', 'latitude': '28.695427', 'longitude': '77.214824', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110007', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/vishwavidyalaya/dmrc-vishwavidyalaya', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '10882', 'name': 'Café Coffee Day - Dmrc Kashmere Gate', 'address1': 'Dmrc Kashmere Gate 3 Toms (Scr Site)', 'latitude': '28.667704', 'longitude': '77.227778', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110006', 'phone': '9350319018', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/kashmere-gate/dmrc-kashmere-gate', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10879', 'name': 'Café Coffee Day - Dlf Shalimar Bagh', 'address1': 'Ap Block, Dlf City Centre, Shaheed Udham Singh Marg Poorvi Shalimar Bagh', 'latitude': '28.702953', 'longitude': '77.157347', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110052', 'phone': '9310523021', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/shaheed-udham-singh-marg/dlf-shalimar-bagh', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10900', 'name': 'Café Coffee Day - East Of Kailash', 'address1': 'East Of Kailash, Ground Floor, North Side ', 'latitude': '28.559479', 'longitude': '77.246513', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110065', 'phone': '7428753518', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/east-kailash/east-kailash', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '10:00 PM'}, {'val': '10919', 'name': 'Café Coffee Day - Escorts Okhla', 'address1': '1St Floor, Escorts Heart Institute, New Friends Colony Okhla Road', 'latitude': '28.560788', 'longitude': '77.273414', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110025', 'phone': '9311222063', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/new-friends-colony/escorts-okhla', 'near': '0', 'veg': '2', 'city_area': '', 'highway': '0', 'two4': '1', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '12:00 AM', 'close_time': '12:00 AM'}, {'val': '10967', 'name': 'Café Coffee Day - Gk 2 M Block', 'address1': 'M 66, M Block, Greater Kailash Part 2 ', 'latitude': '28.54975087', 'longitude': '77.23615595', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110048', 'phone': '9310375757', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/greater-kailash-2/gk-2-m-block-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '12:00 AM'}, {'val': '10965', 'name': 'Café Coffee Day - Gk2', 'address1': 'Greater Kailash Ii, Main Market ', 'latitude': '28.533916', 'longitude': '77.24488', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110048', 'phone': '9312876799', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/greater-kailash-2/gk2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10832', 'name': 'Café Coffee Day - Cp Radial Road', 'address1': 'B Block, Radial Road, Connaught Place ', 'latitude': '28.633825', 'longitude': '77.217885', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '011 65157045', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/cp-radial-road', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10903', 'name': 'Café Coffee Day - E Block Cp', 'address1': 'E-11, Mezzanine Floor, E Block, Connaught Place ', 'latitude': '28.63238569', 'longitude': '77.22173346', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9213023594', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/e-block-cp/e-block-cp', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10874', 'name': 'Café Coffee Day - Dlf Jasola', 'address1': 'Dlf Tower A, Plot No. 10 Jasola', 'latitude': '28.53848175', 'longitude': '77.28979476', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110020', 'phone': '9312750823', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/jasola/dlf-jasola', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '10:00 PM'}, {'val': '10883', 'name': 'Café Coffee Day - Dmrc Malviyanagar', 'address1': \"Malviyanagar 2 Tom'S (New)\", 'latitude': '28.528583', 'longitude': '77.203228', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/malviyanagar/dmrc-malviyanagar', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10924', 'name': 'Café Coffee Day - Express Line', 'address1': 'Airport Metro Express Line ', 'latitude': '28.54870594', 'longitude': '77.12112665', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110006', 'phone': '9213022608', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/airport-metro-express-line/express-line', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10867', 'name': 'Café Coffee Day - Dinar Bhavan-Delhi', 'address1': '1St Floor, Plot No 44, Dinar Bhavan Nehru Place', 'latitude': '28.55016', 'longitude': '77.252284', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110019', 'phone': '011 64720012', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/nehru-place/dinar-bhavan-delhi', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '10850', 'name': 'Café Coffee Day - Daryaganj', 'address1': '3631, Hameed Manzil, Netaji Subhash Marg, Daryaganj Near?Golcha Cinema', 'latitude': '28.647164', 'longitude': '77.239924', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110002', 'phone': '9312750438', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/daryaganj/daryaganj', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '10:00 PM'}, {'val': '10827', 'name': 'Café Coffee Day - Connaught Place', 'address1': 'L 12, Connaught Place, Delhi Outer Circle ', 'latitude': '28.634462', 'longitude': '77.22227', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '011 64580767', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/connaught-place-3', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10826', 'name': 'Café Coffee Day - Connaught Place', 'address1': 'M Block, Connaught Circus, Connaught ', 'latitude': '28.632678', 'longitude': '77.222933', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9310181017', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/connaught-place-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10901', 'name': 'Café Coffee Day - East Patel Nagar', 'address1': '11/15, East Patel Nagar ', 'latitude': '28.645059', 'longitude': '77.169957', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110008', 'phone': '9312875764', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/east-patel-nagar/east-patel-nagar-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '10812', 'name': 'Café Coffee Day - City Square Mall', 'address1': 'Inside City Square, Najafgarh Road Raja Garden, Rajouri Garden', 'latitude': '28.649925', 'longitude': '77.123993', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110027', 'phone': '9311136867', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/rajouri-garden/city-square-mall', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}, {'val': '10824', 'name': 'Café Coffee Day - Computer Mart', 'address1': '12, Computer Mart, Regal Building Connaught Place', 'latitude': '28.631048', 'longitude': '77.217015', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '7428653585', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/computer-mart', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10652', 'name': 'Café Coffee Day - Ashirwad Chowk', 'address1': 'Shop No. 11, Sector 5 Road\\r\\n Ashirwad Chowk, Dwarka\\r\\n', 'latitude': '28.596558', 'longitude': '77.5641', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110075', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/dwarka/ashirwad-chowk-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '10:00 AM', 'close_time': '9:30 PM'}, {'val': '10665', 'name': 'Café Coffee Day - Awwa Complex', 'address1': 'Pallavi Awwa Complex Opposite Taj Palace Hotel\\r\\n Chanakyapuri\\r\\n', 'latitude': '28.595247', 'longitude': '77.171954', 'city': 'New delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/new-delhi/chanakya-puri/awwa-complex', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '12:00 AM'}, {'val': '10716', 'name': 'Café Coffee Day - B Block Cp', 'address1': 'B-28, Upper Ground Floor Inner Circle, B Block, Connaught Place\\r\\n', 'latitude': '28.6342685', 'longitude': '77.2194239', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '1800 102 5093', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/b-block-cp', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10595', 'name': 'Café Coffee Day - Adhchini', 'address1': '97/1, Sri Aurobindo Marg, Adhchini ', 'latitude': '28.53868523', 'longitude': '77.19872048', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '9313792371', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/adhchini/adhchini', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10602', 'name': 'Café Coffee Day - Alaknanda', 'address1': 'Nilgiri Apartments, Alaknanda Entrance Gate Alaknanda Don Bosco Road', 'latitude': '28.52554', 'longitude': '77.25148', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110017', 'phone': '9310860243', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/alaknanda/alaknanda', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10609', 'name': 'Café Coffee Day - Amar Colony', 'address1': 'E/129, Amar Colony, Block E Lajpat Nagar', 'latitude': '28.56043962', 'longitude': '77.24047472', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110024', 'phone': '011 32933806', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/lajpat-nagar/amar-colony-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10608', 'name': 'Café Coffee Day - Amar Colony', 'address1': 'Shop No 6, Main Market, Amar Colony Lajpat Nagar', 'latitude': '28.560204', 'longitude': '77.240346', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110024', 'phone': '9350386473', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/lajpat-nagar/amar-colony-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10658', 'name': 'Café Coffee Day - Ashok Vihar Ii', 'address1': 'Community Centre, Dda Market, Ashok Vihar Ii, Phase 2 Ashok Vihar', 'latitude': '28.69415459', 'longitude': '77.17282087', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110052', 'phone': '9311756722', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/ashok-vihar/ashok-vihar-ii', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '10701', 'name': 'Café Coffee Day - Barakhamba Road ', 'address1': 'Dcm Building, Barakhamba Road, Connaught Place ', 'latitude': '28.62971455', 'longitude': '77.22564429', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9350389040', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/barakhamba-road', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10700', 'name': 'Café Coffee Day - Barakhamba Road', 'address1': 'Delhi House, Barakhamba Road ', 'latitude': '28.62560862', 'longitude': '77.23296136', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9312007328', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/barakhamba-road/barakhamba-road', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10778', 'name': 'Café Coffee Day - Central Market', 'address1': '55 - 56, Central Market, Lajpat Nagar Ii, Lajpat Nagar ', 'latitude': '28.56929', 'longitude': '77.242481', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110024', 'phone': '011 32310689', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/lajpat-nagar/central-market', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10753', 'name': 'Café Coffee Day - Bpcl Chanakya Puri', 'address1': 'Bpcl, Chanakya Puri ', 'latitude': '28.583407', 'longitude': '77.191349', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110021', 'phone': '7428072545', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/chanakya-puri/bpcl-chanakya-puri', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '0', 'open_time': '8:00 AM', 'close_time': '11:00 PM'}, {'val': '10709', 'name': 'Café Coffee Day - Basant Lok', 'address1': '14A , Main Market, Basant Lok, Vasant Vihar ', 'latitude': '28.558793', 'longitude': '77.163189', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110057', 'phone': '7428367856', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/vasant-vihar/basant-lok', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10591', 'name': 'Café Coffee Day - Connaught Place', 'address1': 'A 21, A Block, Radial Road, Connaught Place ', 'latitude': '28.633195', 'longitude': '77.218525', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110001', 'phone': '9311810481', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/connaught-place/block-connaught-place', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10651', 'name': 'Café Coffee Day - Ashirwad Chowk', 'address1': 'Ashirwad Chowk, Dwarka ', 'latitude': '28.595649', 'longitude': '77.048927', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110075', 'phone': '011 32228030', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/dwarka/ashirwad-chowk-1', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '9:00 AM', 'close_time': '11:00 PM'}, {'val': '10657', 'name': 'Café Coffee Day - Ashok Nagar', 'address1': '30 /3A Ds, Ashok Nagar Near Tilak Nagar Metro Station', 'latitude': '28.63644749', 'longitude': '77.09656834', 'city': 'Delhi', 'state': 'Delhi', 'pincode': '110018', 'phone': '9312877331', 'storeUrl': 'https://www.cafecoffeeday.com/store-locator/delhi/delhi/ashok-nagar/ashok-nagar-2', 'near': '0', 'veg': '3', 'city_area': '', 'highway': '0', 'two4': '0', 'type': 'Cafe Coffee Day', 'wifi': '1', 'open_time': '10:00 AM', 'close_time': '11:00 PM'}]\n"
     ]
    }
   ],
   "source": [
    "print(ccd)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "27a56674",
   "metadata": {},
   "outputs": [],
   "source": [
    "# converting ccd into dataframe , so we can perform data cleaning and dave it in a csv format\n",
    "\n",
    "ccd = pd.DataFrame(ccd)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "eeee1327",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>val</th>\n",
       "      <th>name</th>\n",
       "      <th>address1</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>pincode</th>\n",
       "      <th>phone</th>\n",
       "      <th>storeUrl</th>\n",
       "      <th>near</th>\n",
       "      <th>veg</th>\n",
       "      <th>city_area</th>\n",
       "      <th>highway</th>\n",
       "      <th>two4</th>\n",
       "      <th>type</th>\n",
       "      <th>wifi</th>\n",
       "      <th>open_time</th>\n",
       "      <th>close_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12403</td>\n",
       "      <td>Café Coffee Day - Rajouri Garden</td>\n",
       "      <td>Building No 13/57, J Block\\r\\n Rajouri Garden\\r\\n</td>\n",
       "      <td>28.6397488</td>\n",
       "      <td>77.1181652</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110027</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Cafe Coffee Day</td>\n",
       "      <td>1</td>\n",
       "      <td>9:00</td>\n",
       "      <td>9:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12401</td>\n",
       "      <td>Café Coffee Day - Vishal Enclave</td>\n",
       "      <td>24\\r\\n Block A, Vishal Enclave, Rajouri Garden...</td>\n",
       "      <td>28.6489842</td>\n",
       "      <td>77.12184</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110027</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Cafe Coffee Day</td>\n",
       "      <td>1</td>\n",
       "      <td>10:00</td>\n",
       "      <td>09:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12396</td>\n",
       "      <td>Café Coffee Day - Janakpuri</td>\n",
       "      <td>Block B 2B/14, Janakpuri\\r\\n</td>\n",
       "      <td>28.63344</td>\n",
       "      <td>77.94284</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110058</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Cafe Coffee Day</td>\n",
       "      <td>1</td>\n",
       "      <td>09:00</td>\n",
       "      <td>11:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12394</td>\n",
       "      <td>Café Coffee Day - Mandi House</td>\n",
       "      <td>Shop No 49, Plot 7, Block 205 C, Tansen Marg\\r...</td>\n",
       "      <td>28.6294921</td>\n",
       "      <td>77.232787</td>\n",
       "      <td>New delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110001</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Cafe Coffee Day</td>\n",
       "      <td>1</td>\n",
       "      <td>9:00</td>\n",
       "      <td>10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12390</td>\n",
       "      <td>Café Coffee Day - Lajpath Nagar</td>\n",
       "      <td>A-10, Lajpath Nagar Part-2</td>\n",
       "      <td>28.569843</td>\n",
       "      <td>77.238611</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110024</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Cafe Coffee Day</td>\n",
       "      <td>1</td>\n",
       "      <td>9:00</td>\n",
       "      <td>23:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     val                              name  \\\n",
       "0  12403  Café Coffee Day - Rajouri Garden   \n",
       "1  12401  Café Coffee Day - Vishal Enclave   \n",
       "2  12396       Café Coffee Day - Janakpuri   \n",
       "3  12394     Café Coffee Day - Mandi House   \n",
       "4  12390   Café Coffee Day - Lajpath Nagar   \n",
       "\n",
       "                                            address1    latitude   longitude  \\\n",
       "0  Building No 13/57, J Block\\r\\n Rajouri Garden\\r\\n  28.6397488  77.1181652   \n",
       "1  24\\r\\n Block A, Vishal Enclave, Rajouri Garden...  28.6489842    77.12184   \n",
       "2                      Block B 2B/14, Janakpuri\\r\\n     28.63344    77.94284   \n",
       "3  Shop No 49, Plot 7, Block 205 C, Tansen Marg\\r...  28.6294921   77.232787   \n",
       "4                        A-10, Lajpath Nagar Part-2    28.569843   77.238611   \n",
       "\n",
       "        city  state pincode          phone  \\\n",
       "0      Delhi  Delhi  110027  1800 102 5093   \n",
       "1      Delhi  Delhi  110027  1800 102 5093   \n",
       "2      Delhi  Delhi  110058  1800 102 5093   \n",
       "3  New delhi  Delhi  110001  1800 102 5093   \n",
       "4      Delhi  Delhi  110024  1800 102 5093   \n",
       "\n",
       "                                            storeUrl near veg city_area  \\\n",
       "0  https://www.cafecoffeeday.com/store-locator/de...    0                 \n",
       "1  https://www.cafecoffeeday.com/store-locator/de...    0                 \n",
       "2  https://www.cafecoffeeday.com/store-locator/de...    0                 \n",
       "3  https://www.cafecoffeeday.com/store-locator/de...    0                 \n",
       "4  https://www.cafecoffeeday.com/store-locator/de...    0                 \n",
       "\n",
       "  highway two4             type wifi open_time close_time  \n",
       "0       0    0  Cafe Coffee Day    1      9:00       9:30  \n",
       "1       0    0  Cafe Coffee Day    1     10:00      09:30  \n",
       "2       0    0  Cafe Coffee Day    1     09:00      11:00  \n",
       "3       0    0  Cafe Coffee Day    1      9:00      10:00  \n",
       "4       0    0  Cafe Coffee Day    1      9:00      23:00  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ccd.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "4825c37b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# data cleaning \n",
    "# removing unwanted columns \n",
    "ccd.drop(['near','veg','city_area','highway','two4','type','wifi'],inplace=True,axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "dc13023b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# cleaning the open time and close time column\n",
    "def handle_time(value):\n",
    "    if('PM' in value or 'AM' in value):\n",
    "        value = value.replace('PM','')\n",
    "        value = value.replace('AM','')\n",
    "        return value\n",
    "    else:\n",
    "        return value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "806fa94b",
   "metadata": {},
   "outputs": [],
   "source": [
    "ccd['open_time'] = ccd['open_time'].apply(handle_time)\n",
    "ccd['close_time'] = ccd['close_time'].apply(handle_time)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f21fce60",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['9:00', '10:00', '09:00', '9:00 ', '10:00 ', '11:00 ', '8:00 ',\n",
       "       '12:00 ', '10 :00 ', '7:00 '], dtype=object)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ccd['open_time'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "08aa9cec",
   "metadata": {},
   "outputs": [],
   "source": [
    "ccd['open_time'] = ccd['open_time'].replace('10 :00 ','10:00')\n",
    "ccd['open_time'] = ccd['open_time'].replace('10:00 ','10:00')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "149922f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# fixing the format for open_time and close_time time \n",
    "ccd['open_time'] = ccd['open_time'].apply(lambda x: datetime.strptime(x.strip(),'%I:%M').time())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "47328ada",
   "metadata": {},
   "outputs": [],
   "source": [
    "ccd['close_time'] = ccd['close_time'].replace('23:00','11:00')\n",
    "ccd['close_time'] = ccd['close_time'].replace('12','12:00')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7d9b2e30",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "ccd['close_time'] = ccd['close_time'].apply(lambda x: datetime.strptime(x.strip(),'%I:%M').time())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "4b93711f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# changing column name\n",
    "ccd.rename(columns={'open_time':'open_time(AM)','close_time':'close_time(PM)'},inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "36940a94",
   "metadata": {},
   "outputs": [],
   "source": [
    "# changing latitude and longitude data type for further analysis\n",
    "ccd[['latitude','longitude']] = ccd[['latitude','longitude']].apply(pd.to_numeric)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "38d87235",
   "metadata": {},
   "outputs": [],
   "source": [
    "# saving the extracted data \n",
    "ccd.to_csv('ccd_locations.csv',header=True,index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "782dcbc9",
   "metadata": {},
   "outputs": [],
   "source": [
    "# geo analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f4a19662",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('ccd_locations.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "fb978bbf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>val</th>\n",
       "      <th>name</th>\n",
       "      <th>address1</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>pincode</th>\n",
       "      <th>phone</th>\n",
       "      <th>storeUrl</th>\n",
       "      <th>open_time(AM)</th>\n",
       "      <th>close_time(PM)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12403</td>\n",
       "      <td>Café Coffee Day - Rajouri Garden</td>\n",
       "      <td>Building No 13/57, J Block\\r\\n Rajouri Garden\\r\\n</td>\n",
       "      <td>28.639749</td>\n",
       "      <td>77.118165</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110027</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>09:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12401</td>\n",
       "      <td>Café Coffee Day - Vishal Enclave</td>\n",
       "      <td>24\\r\\n Block A, Vishal Enclave, Rajouri Garden...</td>\n",
       "      <td>28.648984</td>\n",
       "      <td>77.121840</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110027</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>10:00:00</td>\n",
       "      <td>09:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12396</td>\n",
       "      <td>Café Coffee Day - Janakpuri</td>\n",
       "      <td>Block B 2B/14, Janakpuri\\r\\n</td>\n",
       "      <td>28.633440</td>\n",
       "      <td>77.942840</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110058</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12394</td>\n",
       "      <td>Café Coffee Day - Mandi House</td>\n",
       "      <td>Shop No 49, Plot 7, Block 205 C, Tansen Marg\\r...</td>\n",
       "      <td>28.629492</td>\n",
       "      <td>77.232787</td>\n",
       "      <td>New delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110001</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12390</td>\n",
       "      <td>Café Coffee Day - Lajpath Nagar</td>\n",
       "      <td>A-10, Lajpath Nagar Part-2</td>\n",
       "      <td>28.569843</td>\n",
       "      <td>77.238611</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>110024</td>\n",
       "      <td>1800 102 5093</td>\n",
       "      <td>https://www.cafecoffeeday.com/store-locator/de...</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>11:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     val                              name  \\\n",
       "0  12403  Café Coffee Day - Rajouri Garden   \n",
       "1  12401  Café Coffee Day - Vishal Enclave   \n",
       "2  12396       Café Coffee Day - Janakpuri   \n",
       "3  12394     Café Coffee Day - Mandi House   \n",
       "4  12390   Café Coffee Day - Lajpath Nagar   \n",
       "\n",
       "                                            address1   latitude  longitude  \\\n",
       "0  Building No 13/57, J Block\\r\\n Rajouri Garden\\r\\n  28.639749  77.118165   \n",
       "1  24\\r\\n Block A, Vishal Enclave, Rajouri Garden...  28.648984  77.121840   \n",
       "2                      Block B 2B/14, Janakpuri\\r\\n   28.633440  77.942840   \n",
       "3  Shop No 49, Plot 7, Block 205 C, Tansen Marg\\r...  28.629492  77.232787   \n",
       "4                        A-10, Lajpath Nagar Part-2   28.569843  77.238611   \n",
       "\n",
       "        city  state  pincode          phone  \\\n",
       "0      Delhi  Delhi   110027  1800 102 5093   \n",
       "1      Delhi  Delhi   110027  1800 102 5093   \n",
       "2      Delhi  Delhi   110058  1800 102 5093   \n",
       "3  New delhi  Delhi   110001  1800 102 5093   \n",
       "4      Delhi  Delhi   110024  1800 102 5093   \n",
       "\n",
       "                                            storeUrl open_time(AM)  \\\n",
       "0  https://www.cafecoffeeday.com/store-locator/de...      09:00:00   \n",
       "1  https://www.cafecoffeeday.com/store-locator/de...      10:00:00   \n",
       "2  https://www.cafecoffeeday.com/store-locator/de...      09:00:00   \n",
       "3  https://www.cafecoffeeday.com/store-locator/de...      09:00:00   \n",
       "4  https://www.cafecoffeeday.com/store-locator/de...      09:00:00   \n",
       "\n",
       "  close_time(PM)  \n",
       "0       09:30:00  \n",
       "1       09:30:00  \n",
       "2       11:00:00  \n",
       "3       10:00:00  \n",
       "4       11:00:00  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "dff35d7e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 137 entries, 0 to 136\n",
      "Data columns (total 12 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   val             137 non-null    int64  \n",
      " 1   name            137 non-null    object \n",
      " 2   address1        137 non-null    object \n",
      " 3   latitude        137 non-null    float64\n",
      " 4   longitude       137 non-null    float64\n",
      " 5   city            137 non-null    object \n",
      " 6   state           137 non-null    object \n",
      " 7   pincode         137 non-null    int64  \n",
      " 8   phone           123 non-null    object \n",
      " 9   storeUrl        137 non-null    object \n",
      " 10  open_time(AM)   137 non-null    object \n",
      " 11  close_time(PM)  137 non-null    object \n",
      "dtypes: float64(2), int64(2), object(8)\n",
      "memory usage: 13.0+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "54d983e0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
       "&lt;html&gt;\n",
       "&lt;head&gt;\n",
       "    \n",
       "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
       "    \n",
       "        &lt;script&gt;\n",
       "            L_NO_TOUCH = false;\n",
       "            L_DISABLE_3D = false;\n",
       "        &lt;/script&gt;\n",
       "    \n",
       "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
       "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
       "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
       "    \n",
       "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
       "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
       "            &lt;style&gt;\n",
       "                #map_88b1e1abc40debf2bcdee7aef516dabe {\n",
       "                    position: relative;\n",
       "                    width: 100.0%;\n",
       "                    height: 100.0%;\n",
       "                    left: 0.0%;\n",
       "                    top: 0.0%;\n",
       "                }\n",
       "                .leaflet-container { font-size: 1rem; }\n",
       "            &lt;/style&gt;\n",
       "        \n",
       "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/1.1.0/leaflet.markercluster.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/1.1.0/MarkerCluster.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/1.1.0/MarkerCluster.Default.css&quot;/&gt;\n",
       "&lt;/head&gt;\n",
       "&lt;body&gt;\n",
       "    \n",
       "    \n",
       "            &lt;div class=&quot;folium-map&quot; id=&quot;map_88b1e1abc40debf2bcdee7aef516dabe&quot; &gt;&lt;/div&gt;\n",
       "        \n",
       "&lt;/body&gt;\n",
       "&lt;script&gt;\n",
       "    \n",
       "    \n",
       "            var map_88b1e1abc40debf2bcdee7aef516dabe = L.map(\n",
       "                &quot;map_88b1e1abc40debf2bcdee7aef516dabe&quot;,\n",
       "                {\n",
       "                    center: [28.706448340540305, 77.22501642474144],\n",
       "                    crs: L.CRS.EPSG3857,\n",
       "                    zoom: 10,\n",
       "                    zoomControl: true,\n",
       "                    preferCanvas: false,\n",
       "                }\n",
       "            );\n",
       "\n",
       "            \n",
       "\n",
       "        \n",
       "    \n",
       "            var tile_layer_d42d1446a89ba5d4368ffe1c9afe60fd = L.tileLayer(\n",
       "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
       "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
       "            ).addTo(map_88b1e1abc40debf2bcdee7aef516dabe);\n",
       "        \n",
       "    \n",
       "            var fast_marker_cluster_b97faaaa7101fd654c76d231c190370e = (function(){\n",
       "                \n",
       "                var callback = function (row) {\n",
       "                    var icon = L.AwesomeMarkers.icon();\n",
       "                    var marker = L.marker(new L.LatLng(row[0], row[1]));\n",
       "                    marker.setIcon(icon);\n",
       "                    return marker;\n",
       "                };\n",
       "\n",
       "                var data = [[28.6397488, 77.1181652], [28.6489842, 77.12184], [28.63344, 77.94284], [28.6294921, 77.232787], [28.569843, 77.238611], [28.562661, 77.2689677], [28.615781, 77.879554], [28.610926, 77.0916334], [28.5763, 77.1951], [28.6295, 77.2322], [28.719748, 77.19988], [28.679952, 77.28535], [49.29, 84.0], [28.57946205, 77.05601501], [28.533991, 77.225599], [28.6178687, 77.279468], [28.5584685, 77.2454778], [28.52564, 77.156792], [28.5336627, 77.225945], [28.592657, 77.2964362], [28.5409, 77.282456], [28.539228, 77.284486], [28.697905, 77.206579], [28.727433, 77.116135], [28.65087375, 77.15971291], [28.58767811, 77.1671752], [28.7196608, 77.10912644], [28.66098497, 77.14859121], [28.535208, 77.208552], [28.568657, 77.218487], [28.637318, 77.286632], [28.7169595, 77.114614], [28.7193, 77.13396], [28.67448, 77.126372], [28.638523, 77.18376], [28.63294887, 77.21915968], [28.63175146, 77.21681942], [28.6395408, 77.2085157], [28.665707, 77.125873], [28.634015, 77.309819], [28.64241107, 77.17822593], [28.633573, 77.139135], [28.52550014, 77.18534549], [28.643437, 77.188495], [28.633899, 77.219285], [28.631524, 77.219324], [28.631481, 77.219504], [28.633967, 77.218567], [28.63265, 77.219421], [28.631524, 77.219324], [28.53732794, 77.18103287], [28.70955738, 77.12269574], [28.565347, 77.199393], [28.564245, 77.189305], [28.65064897, 77.12038096], [28.6417242, 77.1358821], [28.63228, 77.24133], [28.56929, 77.242481], [28.652299, 77.130547], [28.58566, 77.224778], [28.536314, 77.211076], [28.60624, 77.287772], [28.53021849, 77.220186], [28.56434914, 77.23446166], [28.563229, 77.232501], [28.698235, 77.206619], [28.55062877, 77.25185224], [28.63448183, 77.29094803], [28.690927, 77.152975], [28.527928, 77.211276], [28.527798, 77.211396], [28.535208, 77.208552], [28.626719, 77.219643], [28.63023013, 77.07977101], [28.62923425, 77.08604874], [28.6293179, 77.0913541], [28.54870594, 77.12112665], [28.54010113, 77.25806951], [28.698399, 77.206771], [28.65561771, 77.15099702], [28.643297, 77.188605], [28.644687, 77.199643], [28.65064897, 77.12038096], [28.72753109, 77.15268016], [28.633839, 77.218884], [28.556233, 77.2261], [28.547767, 77.1953276], [28.5551178, 77.2424188], [28.6571129, 77.32259], [28.555483, 77.202735], [28.597939, 77.206145], [28.554464, 77.194033], [28.69267391, 77.15274835], [28.63772812, 77.2846797], [28.556823, 77.206817], [28.6342255, 77.224981], [28.71011043, 77.16983902], [28.586663, 77.56622], [28.597999, 77.1325887], [28.5772737, 77.1685243], [28.6456566, 77.17020341], [28.5392, 77.253047], [28.695427, 77.214824], [28.667704, 77.227778], [28.702953, 77.157347], [28.559479, 77.246513], [28.560788, 77.273414], [28.54975087, 77.23615595], [28.533916, 77.24488], [28.633825, 77.217885], [28.63238569, 77.22173346], [28.53848175, 77.28979476], [28.528583, 77.203228], [28.54870594, 77.12112665], [28.55016, 77.252284], [28.647164, 77.239924], [28.634462, 77.22227], [28.632678, 77.222933], [28.645059, 77.169957], [28.649925, 77.123993], [28.631048, 77.217015], [28.596558, 77.5641], [28.595247, 77.171954], [28.6342685, 77.2194239], [28.53868523, 77.19872048], [28.52554, 77.25148], [28.56043962, 77.24047472], [28.560204, 77.240346], [28.69415459, 77.17282087], [28.62971455, 77.22564429], [28.62560862, 77.23296136], [28.56929, 77.242481], [28.583407, 77.191349], [28.558793, 77.163189], [28.633195, 77.218525], [28.595649, 77.048927], [28.63644749, 77.09656834]];\n",
       "                var cluster = L.markerClusterGroup({});\n",
       "\n",
       "                for (var i = 0; i &lt; data.length; i++) {\n",
       "                    var row = data[i];\n",
       "                    var marker = callback(row);\n",
       "                    marker.addTo(cluster);\n",
       "                }\n",
       "\n",
       "                cluster.addTo(map_88b1e1abc40debf2bcdee7aef516dabe);\n",
       "                return cluster;\n",
       "            })();\n",
       "        \n",
       "&lt;/script&gt;\n",
       "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x15a0e00d760>"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# creating list for latitude and longitude of store/outlet location \n",
    "locations = list(zip(df['latitude'].values,df['longitude'].values))\n",
    "\n",
    "# creating a map using folium\n",
    "map_delhi = folium.Map(location=[28.706448340540305,77.22501642474144],zoom_start=10)\n",
    "\n",
    "# creating marker clusters\n",
    "FastMarkerCluster(data=locations).add_to(map_delhi)\n",
    "map_delhi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fa9dae13",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}