{ "cells": [ { "cell_type": "markdown", "metadata": { "id": "7LKLhQBzJMOz" }, "source": [ "## Access premium data from CARTO's Data Observatory.\n", "\n", "This notebook shows how to use CARTOframes for discovering and downloading **premium** datasets from CARTO's [Data Observatory](https://carto.com/spatial-data-catalog/).\n", "\n", "In particular, we will download touristic [POI's from Pitney Bowes](https://carto.com/spatial-data-catalog/browser/?category=points_of_interest&provider=pitney_bowes) within a specific bounding box.\n", "\n", "The notebook is organized in the following sections:\n", " - [Check your subscriptions to premium datasets](#section1)\n", " - [Download a small sample of a dataset applying spatial filtering to explore it further](#section2)\n", " - [Download dataset filtering by column value and bounding box](#section3)\n", " - [Upload filtered dataset to your CARTO account](#section4)\n", " \n", " \n", "**Note** for this notebook we are using the premium [dataset of Pitney Bowes POI's in Spain](https://carto.com/spatial-data-catalog/browser/dataset/pb_points_of_i_94bda91b/)." ] }, { "cell_type": "markdown", "metadata": { "id": "V4-0hJjiVsen" }, "source": [ "### Setup" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Import packages" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "id": "6vLRH4fEEkms" }, "outputs": [], "source": [ "import geopandas as gpd\n", "import pandas as pd\n", "pd.set_option('display.max_columns', None)\n", "\n", "from cartoframes import to_carto\n", "from cartoframes.auth import set_default_credentials\n", "from cartoframes.data.observatory import *\n", "from cartoframes.viz import *\n", "from shapely.geometry import box" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Set CARTO default credentials" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "In order to be able to use the Data Observatory via CARTOframes, you need to set your CARTO account credentials first.\n", "\n", "Please, visit the [Authentication guide](https://carto.com/developers/cartoframes/guides/Authentication/) for further detail." ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "from cartoframes.auth import set_default_credentials\n", "\n", "set_default_credentials('creds.json')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**Note about credentials**\n", "\n", "For security reasons, we recommend storing your credentials in an external file to prevent publishing them by accident when sharing your notebooks. You can get more information in the section _Setting your credentials_ of the [Authentication guide](https://carto.com/developers/cartoframes/guides/Authentication/)." ] }, { "cell_type": "markdown", "metadata": { "id": "zo5IKlj36qFF" }, "source": [ "### Download a premium dataset\n", "\n", "When working with very large datasets, you might need to explore the dataset in detail to decide if you need the whole data or just part of it. In order to speed up your time to identifying the exact data, it might be very helpful to download just a small sample of your data, to later decide what you need. In this section, we will show how to identify toutistic POI's from a dataset we are already subscribed to." ] }, { "cell_type": "markdown", "metadata": { "id": "opOc5utoCGpx" }, "source": [ "\n", "#### Check your subscriptions to premium datasets\n", "\n", "First, we check we're already subscribed to the dataset we want to use for our analysis. In this case, we would like to use [Pitney Bowes POI's in Spain](https://carto.com/spatial-data-catalog/browser/dataset/pb_points_of_i_94bda91b/). The dataset is `pb_points_of_i_94bda91b`.\n", "\n", "You can subscribe to this premium [dataset](https://carto.com/spatial-data-catalog/browser/dataset/pb_points_of_i_94bda91b/) on your [CARTO dashboard](https://carto.com/help/working-with-data/subscribe_datasets_do/) or contacting CARTO." ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 52 }, "id": "XeLjV_0cCFIz", "outputId": "5fd18729-5b09-4626-c548-7b65a0ee6e8f" }, "outputs": [ { "data": { "text/html": [ "
\n", " | slug | \n", "name | \n", "description | \n", "category_id | \n", "country_id | \n", "data_source_id | \n", "provider_id | \n", "geography_name | \n", "geography_description | \n", "temporal_aggregation | \n", "time_coverage | \n", "update_frequency | \n", "is_public_data | \n", "lang | \n", "version | \n", "category_name | \n", "provider_name | \n", "geography_id | \n", "id | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "ags_sociodemogr_a7e14220 | \n", "Sociodemographics - United States of America (... | \n", "Census and ACS sociodemographic data estimated... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "ags | \n", "Census Block Group - United States of America | \n", "None | \n", "yearly | \n", "None | \n", "yearly | \n", "False | \n", "eng | \n", "2020 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do.ags.geography_usa_blockgroup_2015 | \n", "carto-do.ags.demographics_sociodemographics_us... | \n", "
1 | \n", "ags_retailpoten_aaf25a8c | \n", "Retail Potential - United States of America (C... | \n", "The retail potential database consists of aver... | \n", "demographics | \n", "usa | \n", "retailpotential | \n", "ags | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "yearly | \n", "[2018-01-01, 2019-01-01) | \n", "yearly | \n", "False | \n", "eng | \n", "2019 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.ags.demographics_retailpotential_usa_... | \n", "
2 | \n", "pb_consumer_po_62cddc04 | \n", "Points Of Interest - Consumer - United States ... | \n", "Consumer Point of interest database per catego... | \n", "points_of_interest | \n", "usa | \n", "consumer_points_of_interest | \n", "pitney_bowes | \n", "Latitude/Longitude - United States of America | \n", "Location of Points of Interest | \n", "monthly | \n", "None | \n", "monthly | \n", "False | \n", "eng | \n", "v1 | \n", "Points of Interest | \n", "Pitney Bowes | \n", "carto-do.pitney_bowes.geography_usa_latlon_v1 | \n", "carto-do.pitney_bowes.pointsofinterest_consume... | \n", "
3 | \n", "ags_sociodemogr_f510a947 | \n", "Sociodemographics - United States of America (... | \n", "Census and ACS sociodemographic data estimated... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "ags | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "yearly | \n", "[2019-01-01, 2020-01-01) | \n", "yearly | \n", "False | \n", "eng | \n", "2019 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.ags.demographics_sociodemographics_us... | \n", "
4 | \n", "ags_consumer_sp_dbabddfb | \n", "Consumer Spending - United States of America (... | \n", "The Consumer Expenditure database consists of ... | \n", "demographics | \n", "usa | \n", "consumer_spending | \n", "ags | \n", "Census Block Group - United States of America | \n", "None | \n", "yearly | \n", "None | \n", "yearly | \n", "False | \n", "eng | \n", "2020 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do.ags.geography_usa_blockgroup_2015 | \n", "carto-do.ags.demographics_consumerspending_usa... | \n", "
5 | \n", "spa_geosocial_s_d5dc42ae | \n", "Geosocial Segments - United States of America ... | \n", "By analysing feeds from Twitter, Instagram, Me... | \n", "behavioral | \n", "usa | \n", "geosocial_segments | \n", "spatial_ai | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "quarterly | \n", "[2020-01-01, 2020-04-01) | \n", "quarterly | \n", "False | \n", "eng | \n", "v1 | \n", "Behavioral | \n", "Spatial.ai | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.spatial_ai.behavioral_geosocialsegmen... | \n", "
6 | \n", "mc_geographic__7980c5c3 | \n", "Geographic Insights - United States of America... | \n", "Geographic Insights validate, evaluate and ben... | \n", "financial | \n", "usa | \n", "geographic_insights | \n", "mastercard | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "monthly | \n", "[2019-01-01, 2020-01-01) | \n", "monthly | \n", "False | \n", "eng | \n", "v1 | \n", "Financial | \n", "Mastercard | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.mastercard.financial_geographicinsigh... | \n", "
7 | \n", "pb_points_of_i_94bda91b | \n", "Points Of Interest - Spain (Latitude/Longitude) | \n", "Point of interest database per categories | \n", "points_of_interest | \n", "esp | \n", "points_of_interest | \n", "pitney_bowes | \n", "Latitude/Longitude - Spain | \n", "Location of Points of Interest | \n", "monthly | \n", "None | \n", "monthly | \n", "False | \n", "eng | \n", "v1 | \n", "Points of Interest | \n", "Pitney Bowes | \n", "carto-do.pitney_bowes.geography_esp_latlon_v1 | \n", "carto-do.pitney_bowes.pointsofinterest_pointso... | \n", "
\n", " | HTTP | \n", "ISO3 | \n", "NAME | \n", "SIC1 | \n", "SIC2 | \n", "SIC8 | \n", "CLASS | \n", "GROUP | \n", "PB_ID | \n", "STABB | \n", "geoid | \n", "FAXNUM | \n", "MICODE | \n", "TEL_NUM | \n", "do_date | \n", "LATITUDE | \n", "OPEN_24H | \n", "POSTCODE | \n", "do_label | \n", "AREANAME1 | \n", "AREANAME2 | \n", "AREANAME3 | \n", "AREANAME4 | \n", "BRANDNAME | \n", "GEORESULT | \n", "LONGITUDE | \n", "SUB_CLASS | \n", "AGENT_CODE | \n", "TRADE_NAME | \n", "YEAR_START | \n", "STATUS_CODE | \n", "BUSINESS_LINE | \n", "CURRENCY_CODE | \n", "EMPLOYEE_HERE | \n", "EXCHANGE_NAME | \n", "TICKER_SYMBOL | \n", "EMPLOYEE_COUNT | \n", "FAMILY_MEMBERS | \n", "FRANCHISE_NAME | \n", "HIERARCHY_CODE | \n", "PARENT_ADDRESS | \n", "PARENT_COUNTRY | \n", "TRADE_DIVISION | \n", "ADDRESSLASTLINE | \n", "CONFIDENCE_CODE | \n", "MAINADDRESSLINE | \n", "PARENT_POSTCODE | \n", "FORMATTEDADDRESS | \n", "PARENT_AREANAME1 | \n", "PARENT_AREANAME3 | \n", "SIC8_DESCRIPTION | \n", "ALT_INDUSTRY_CODE | \n", "LEGAL_STATUS_CODE | \n", "SALES_VOLUME_LOCAL | \n", "COUNTRY_ACCESS_CODE | \n", "PARENT_BUSINESS_NAME | \n", "SUBSIDIARY_INDICATOR | \n", "PARENT_STREET_ADDRESS | \n", "GLOBAL_ULTIMATE_ADDRESS | \n", "GLOBAL_ULTIMATE_COUNTRY | \n", "SALES_VOLUME_US_DOLLARS | \n", "GLOBAL_ULTIMATE_POSTCODE | \n", "DOMESTIC_ULTIMATE_ADDRESS | \n", "GLOBAL_ULTIMATE_AREANAME1 | \n", "GLOBAL_ULTIMATE_AREANAME3 | \n", "GLOBAL_ULTIMATE_INDICATOR | \n", "DOMESTIC_ULTIMATE_POSTCODE | \n", "DOMESTIC_ULTIMATE_AREANAME1 | \n", "DOMESTIC_ULTIMATE_AREANAME3 | \n", "GLOBAL_ULTIMATE_BUSINESS_NAME | \n", "GLOBAL_ULTIMATE_STREET_ADDRESS | \n", "DOMESTIC_ULTIMATE_BUSINESS_NAME | \n", "DOMESTIC_ULTIMATE_STREET_ADDRESS | \n", "|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "None | \n", "ESP | \n", "EL SANTO | \n", "None | \n", "6552 | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "SHOPPING | \n", "1173764019 | \n", "EX | \n", "2107476034#1.1064478#41.1567659 | \n", "None | \n", "10010314 | \n", "936 58 74 13 | \n", "2020-11-01 | \n", "43.267950 | \n", "None | \n", "AD700 | \n", "BBV PRIVANZA INTERNATIONAL | \n", "MADRID | \n", "VIZCAYA | \n", "VILADECANS | \n", "None | \n", "None | \n", "T20 | \n", "2.164250 | \n", "DEPARTMENT STORES | \n", "None | \n", "BRICOR | \n", "1994.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "10869, TORRECILLA DE LOS ANGELES, CÁCERES | \n", "LOW | \n", "None | \n", "None | \n", "None | \n", "MALAGA | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "NaN | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "CARRETERA DE CADIZ 206 | \n", "
1 | \n", "None | \n", "ESP | \n", "LA FUENTE | \n", "None | \n", "6552 | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "SHOPPING | \n", "1432760662 | \n", "MD | \n", "2227609955#-6.378907#39.470747 | \n", "None | \n", "10010314 | \n", "935 48 09 27 | \n", "2020-11-01 | \n", "43.323898 | \n", "None | \n", "GX11 1AA | \n", "SPRINGFIELD BANK AND TRUST | \n", "MADRID | \n", "BIZKAIA | \n", "BARCELONA | \n", "None | \n", "None | \n", "S8HPNTSCZA | \n", "-1.639469 | \n", "DEPARTMENT STORES | \n", "None | \n", "None | \n", "2018.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "28911, LEGANES, MADRID | \n", "LOW | \n", "None | \n", "None | \n", "None | \n", "GUIPUZCOA | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "NaN | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "PASEO DE MIRAMON 185 | \n", "
2 | \n", "None | \n", "ESP | \n", "SANT FRANCESC XAVIER | \n", "None | \n", "6541 | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "SHOPPING | \n", "1170864171 | \n", "CT | \n", "2226191863#-8.5258399#42.8889816 | \n", "None | \n", "10010314 | \n", "938 14 89 43 | \n", "2020-11-01 | \n", "43.322003 | \n", "None | \n", "AD700 | \n", "I D T FINANCIAL SERVICES | \n", "BARCELONA | \n", "VIZCAYA | \n", "SANT PERE DE RIBES | \n", "None | \n", "None | \n", "T18 | \n", "-3.686817 | \n", "DEPARTMENT STORES | \n", "None | \n", "EL CORTE INGLÉS | \n", "2008.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "08301, MATARO, BARCELONA | \n", "MEDIUM | \n", "None | \n", "None | \n", "None | \n", "MADRID | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "NaN | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "PASEO CASTELLANA, 120 - IZ BJ | \n", "
3 | \n", "None | \n", "ESP | \n", "RUFINO BLANCO | \n", "None | \n", "6552 | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "SHOPPING | \n", "1171185920 | \n", "MC | \n", "2225636588#0.629133#41.6186896 | \n", "None | \n", "10010314 | \n", "946 53 35 12 | \n", "2020-11-01 | \n", "42.507879 | \n", "None | \n", "GX11 1AA | \n", "JYSKE BANK MANAGEMENT | \n", "MADRID | \n", "VIZCAYA | \n", "GETXO | \n", "None | \n", "None | \n", "T19 | \n", "-3.692750 | \n", "DEPARTMENT STORES | \n", "None | \n", "HIPERCOR | \n", "2006.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "30009, MURCIA, MURCIA | \n", "HIGH | \n", "None | \n", "None | \n", "None | \n", "MALAGA | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "NaN | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "AVENIDA DEL CARMEN (ED EL FARO), BL 3 LOC | \n", "
4 | \n", "None | \n", "ESP | \n", "CASA CONVALESCÈNCIA | \n", "None | \n", "None | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "SHOPPING | \n", "1173842007 | \n", "AR | \n", "2219538595#-8.4077351#43.3661062 | \n", "None | \n", "10010314 | \n", "661 78 11 33 | \n", "2020-11-01 | \n", "43.318963 | \n", "None | \n", "AD400 | \n", "OFFSEC SERVICES | \n", "TENERIFE | \n", "GIPUZKOA | \n", "SAN BARTOLOMÉ | \n", "None | \n", "None | \n", "T20 | \n", "-3.656440 | \n", "DEPARTMENT STORES | \n", "None | \n", "EL CORTE INGLÉS | \n", "1988.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "50180, UTEBO, ZARAGOZA | \n", "LOW | \n", "None | \n", "None | \n", "None | \n", "LERIDA | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "NaN | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "CARRETERA PALAU (KM 1) | \n", "
5 | \n", "None | \n", "ESP | \n", "ROSALÍA DE CASTRO | \n", "None | \n", "None | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "PERSONAL SERVICES | \n", "1505524737 | \n", "AN | \n", "2226659530#-5.6530505#43.5359533 | \n", "None | \n", "10010314 | \n", "922 04 90 67 | \n", "2020-11-01 | \n", "43.323258 | \n", "None | \n", "AD500 | \n", "SOIAM | \n", "LERIDA | \n", "VIZCAYA | \n", "PEDREGUER | \n", "None | \n", "None | \n", "T17 | \n", "-3.806100 | \n", "DEPARTMENT STORES | \n", "None | \n", "EL CORTE INGLÉS | \n", "2020.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "21006, HUELVA, HUELVA | \n", "HIGH | \n", "None | \n", "None | \n", "None | \n", "SEVILLA | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "59118.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "CALLE MIGUEL VAZQUEZ DELGADO 71 | \n", "
6 | \n", "None | \n", "ESP | \n", "CENTRO DE FORMACIÓN Y EMPLEO | \n", "None | \n", "None | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "PERSONAL SERVICES | \n", "1173898606 | \n", "CT | \n", "2225995739#-0.883421#41.647102 | \n", "None | \n", "10010314 | \n", "968 70 11 50 | \n", "2020-11-01 | \n", "43.265980 | \n", "None | \n", "GX11 1AA | \n", "LAB | \n", "MADRID | \n", "BIZKAIA | \n", "CARAVACA DE LA CRUZ | \n", "None | \n", "None | \n", "T19 | \n", "-2.669666 | \n", "DEPARTMENT STORES | \n", "None | \n", "None | \n", "NaN | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "08026, BARCELONA, BARCELONA | \n", "MEDIUM | \n", "None | \n", "None | \n", "None | \n", "BARCELONA | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "60384.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "CALLE ANTIC CAMI DE XIMELIS 19 | \n", "
7 | \n", "None | \n", "ESP | \n", "EFA EL SOTO | \n", "None | \n", "None | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "PERSONAL SERVICES | \n", "1293842742 | \n", "CT | \n", "2222921452#-2.79984#36.7689 | \n", "None | \n", "10010314 | \n", "914 04 99 28 | \n", "2020-11-01 | \n", "43.253290 | \n", "None | \n", "AD500 | \n", "F.I.T.A | \n", "MADRID | \n", "VIZCAYA | \n", "MADRID | \n", "None | \n", "None | \n", "T16 | \n", "2.127009 | \n", "DEPARTMENT STORES | \n", "None | \n", "None | \n", "2016.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00000 | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "08030, BARCELONA, BARCELONA | \n", "LOW | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "61505.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "AVENIDA GENERAL PERON (ED MASTER'S I), 38 - PI... | \n", "
8 | \n", "None | \n", "ESP | \n", "O CASTIÑEIRO | \n", "None | \n", "None | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "PERSONAL SERVICES | \n", "1172241073 | \n", "AN | \n", "2152151101#-8.644829#42.4307343 | \n", "944 46 13 47 | \n", "10010314 | \n", "943 61 95 40 | \n", "2020-11-01 | \n", "42.851396 | \n", "None | \n", "AD500 | \n", "P & C APARTAMENTS | \n", "CASTILLA Y LEÓN | \n", "ANDORRA | \n", "IRUN | \n", "None | \n", "None | \n", "T16 | \n", "-3.689160 | \n", "DEPARTMENT STORES | \n", "None | \n", "EL CORTE INGLÉS | \n", "2000.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "29014, MALAGA, MÁLAGA | \n", "HIGH | \n", "None | \n", "None | \n", "None | \n", "BARCELONA | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "67464.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "CALLE BRUC DEL MIG 8 | \n", "
9 | \n", "None | \n", "ESP | \n", "CPEB DE CABAÑAQUINTA | \n", "None | \n", "None | \n", "50440000 | \n", "DRINKING PLACES | \n", "None | \n", "PERSONAL SERVICES | \n", "1171203786 | \n", "AN | \n", "2221998958#-7.3611215#43.6618237 | \n", "None | \n", "10010314 | \n", "953 58 03 67 | \n", "2020-11-01 | \n", "43.247379 | \n", "None | \n", "AD400 | \n", "ME VACANCES | \n", "PAÍS VASCO | \n", "BIZKAIA | \n", "ALCALÁ LA REAL | \n", "None | \n", "None | \n", "T20 | \n", "2.127009 | \n", "DEPARTMENT STORES | \n", "None | \n", "None | \n", "1999.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "00 | \n", "None | \n", "None | \n", "DIVISION I. - SERVICES | \n", "41020, SEVILLA, SEVILLA | \n", "LOW | \n", "None | \n", "None | \n", "None | \n", "ALBACETE | \n", "None | \n", "FRUIT AND VEGETABLE MARKETS | \n", "None | \n", "None | \n", "60587.0 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "CALLE MAYOR, 32 - 1 A | \n", "
\n", " | NAME | \n", "geoid | \n", "do_date | \n", "BRANDNAME | \n", "PB_ID | \n", "TRADE_NAME | \n", "FRANCHISE_NAME | \n", "ISO3 | \n", "AREANAME4 | \n", "AREANAME3 | \n", "AREANAME2 | \n", "AREANAME1 | \n", "STABB | \n", "POSTCODE | \n", "FORMATTEDADDRESS | \n", "MAINADDRESSLINE | \n", "ADDRESSLASTLINE | \n", "LONGITUDE | \n", "LATITUDE | \n", "GEORESULT | \n", "CONFIDENCE_CODE | \n", "COUNTRY_ACCESS_CODE | \n", "TEL_NUM | \n", "FAXNUM | \n", "HTTP | \n", "OPEN_24H | \n", "BUSINESS_LINE | \n", "SIC1 | \n", "SIC2 | \n", "SIC8 | \n", "SIC8_DESCRIPTION | \n", "ALT_INDUSTRY_CODE | \n", "MICODE | \n", "TRADE_DIVISION | \n", "GROUP | \n", "CLASS | \n", "SUB_CLASS | \n", "EMPLOYEE_HERE | \n", "EMPLOYEE_COUNT | \n", "YEAR_START | \n", "SALES_VOLUME_LOCAL | \n", "SALES_VOLUME_US_DOLLARS | \n", "CURRENCY_CODE | \n", "AGENT_CODE | \n", "LEGAL_STATUS_CODE | \n", "STATUS_CODE | \n", "SUBSIDIARY_INDICATOR | \n", "PARENT_BUSINESS_NAME | \n", "PARENT_ADDRESS | \n", "PARENT_STREET_ADDRESS | \n", "PARENT_AREANAME3 | \n", "PARENT_AREANAME1 | \n", "PARENT_COUNTRY | \n", "PARENT_POSTCODE | \n", "DOMESTIC_ULTIMATE_BUSINESS_NAME | \n", "DOMESTIC_ULTIMATE_ADDRESS | \n", "DOMESTIC_ULTIMATE_STREET_ADDRESS | \n", "DOMESTIC_ULTIMATE_AREANAME3 | \n", "DOMESTIC_ULTIMATE_AREANAME1 | \n", "DOMESTIC_ULTIMATE_POSTCODE | \n", "GLOBAL_ULTIMATE_INDICATOR | \n", "GLOBAL_ULTIMATE_BUSINESS_NAME | \n", "GLOBAL_ULTIMATE_ADDRESS | \n", "GLOBAL_ULTIMATE_STREET_ADDRESS | \n", "GLOBAL_ULTIMATE_AREANAME3 | \n", "GLOBAL_ULTIMATE_AREANAME1 | \n", "GLOBAL_ULTIMATE_COUNTRY | \n", "GLOBAL_ULTIMATE_POSTCODE | \n", "FAMILY_MEMBERS | \n", "HIERARCHY_CODE | \n", "TICKER_SYMBOL | \n", "EXCHANGE_NAME | \n", "geom | \n", "|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "100 MONTADITOS | \n", "2173220473#-3.70582#40.416 | \n", "2019-12-01 | \n", "NaN | \n", "2173220473 | \n", "100 MONTADITOS | \n", "NaN | \n", "ESP | \n", "NaN | \n", "MADRID | \n", "MADRID | \n", "COMUNIDAD DE MADRID | \n", "MD | \n", "28012.0 | \n", "CALLE POSTAS 12, 28012, MADRID, MADRID | \n", "CALLE POSTAS 12 | \n", "28012, MADRID, MADRID | \n", "-3.705820 | \n", "40.416000 | \n", "S8HPNTSCZA | \n", "HIGH | \n", "NaN | \n", "915 23 11 40 | \n", "913 51 90 03 | \n", "ATTCLIENTE@GRUPORESTALIA.COM | \n", "SPAIN.100MONTADITOS.COM | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "TAPAS RESTAURANTS | \n", "NaN | \n", "10021076 | \n", "DIVISION G. - RETAIL TRADE | \n", "EATING AND DRINKING PLACES | \n", "EATING PLACES/RESTAURANTS | \n", "EATING PLACES/RESTAURANTS | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-3.70582 40.41600) | \n", "
1 | \n", "1005 DISTRIBUCION SL | \n", "1277167953#-3.7055463461631111#40.420295192309013 | \n", "2019-12-01 | \n", "NaN | \n", "1277167953 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "NaN | \n", "MADRID | \n", "MADRID | \n", "MADRID | \n", "MD | \n", "28013.0 | \n", "CALLE GRAN VIA, 28013, MADRID, MADRID | \n", "CALLE GRAN VIA | \n", "28013, MADRID, MADRID | \n", "-3.705546 | \n", "40.420295 | \n", "S4-PNTSCZA | \n", "MEDIUM | \n", "34.0 | \n", "915 22 16 12 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "METALS SERVICE CENTERS AND OFFICES | \n", "5051.0 | \n", "NaN | \n", "50510000.0 | \n", "METALS SERVICE CENTERS AND OFFICES | \n", "350.0 | \n", "10035051 | \n", "DIVISION F. - WHOLESALE TRADE | \n", "WHOLESALE TRADE - DURABLE GOODS | \n", "METALS AND MINERALS, EXCEPT PETROLEUM | \n", "METALS SERVICE CENTERS AND OFFICES | \n", "1.0 | \n", "1.0 | \n", "2004.0 | \n", "149127.0 | \n", "170724.0 | \n", "5080.0 | \n", "G | \n", "3.0 | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "POINT (-3.70555 40.42030) | \n", "
2 | \n", "15K ANGELS AND INVESTORS SL. | \n", "1369422585#-3.70587#40.42048 | \n", "2019-12-01 | \n", "NaN | \n", "1369422585 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "MADRID | \n", "MADRID | \n", "MADRID | \n", "MADRID | \n", "MD | \n", "28013.0 | \n", "CALLE GRAN VIA 46, 28013, MADRID, MADRID | \n", "CALLE GRAN VIA 46 | \n", "28013, MADRID, MADRID | \n", "-3.705870 | \n", "40.420480 | \n", "S8HPNTSCZA | \n", "HIGH | \n", "34.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "WWW.15KANGELS.COM | \n", "NaN | \n", "SECURITY AND COMMODITY SERVICES, NEC, NSK | \n", "6289.0 | \n", "NaN | \n", "62890000.0 | \n", "SECURITY AND COMMODITY SERVICE | \n", "350.0 | \n", "10010324 | \n", "DIVISION H. - FINANCE, INSURANCE, AND REAL ESTATE | \n", "SECURITY AND COMMODITY BROKERS, DEALERS, EXCHA... | \n", "SERVICES ALLIED WITH THE EXCHANGE OF SECURITIE... | \n", "SECURITY AND COMMODITY SERVICE | \n", "2.0 | \n", "2.0 | \n", "2017.0 | \n", "54756.0 | \n", "61000.0 | \n", "5080.0 | \n", "G | \n", "3.0 | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "POINT (-3.70587 40.42048) | \n", "
3 | \n", "1610 PLAZA DEL CARMEN 5 SL. | \n", "1289731188#-3.7028#40.41892 | \n", "2019-12-01 | \n", "NaN | \n", "1289731188 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "MADRID | \n", "MADRID | \n", "MADRID | \n", "MADRID | \n", "MD | \n", "28013.0 | \n", "PLAZA CARMEN 5, 28013, MADRID, MADRID | \n", "PLAZA CARMEN 5 | \n", "28013, MADRID, MADRID | \n", "-3.702800 | \n", "40.418920 | \n", "S8HPNTSCZA | \n", "HIGH | \n", "34.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "EATING PLACES | \n", "5812.0 | \n", "NaN | \n", "58120000.0 | \n", "EATING PLACES | \n", "350.0 | \n", "10020100 | \n", "DIVISION G. - RETAIL TRADE | \n", "EATING AND DRINKING PLACES | \n", "EATING PLACES/RESTAURANTS | \n", "EATING PLACES/RESTAURANTS - UNSPECIFIED | \n", "35.0 | \n", "35.0 | \n", "2016.0 | \n", "2766588.0 | \n", "3167262.0 | \n", "5080.0 | \n", "G | \n", "3.0 | \n", "0.0 | \n", "0.0 | \n", "PUZZLE DE RESTAURANTES SL. | \n", "CALLE BALLESTA, 32 - LOC DR, 28004, MADRID, MA... | \n", "CALLE BALLESTA, 32 - LOC DR | \n", "MADRID | \n", "MADRID | \n", "SPAIN | \n", "28004 | \n", "PUZZLE DE RESTAURANTES SL. | \n", "CALLE BALLESTA, 32 - LOC DR, 28004, MADRID, MA... | \n", "CALLE BALLESTA, 32 - LOC DR | \n", "MADRID | \n", "MADRID | \n", "28004.0 | \n", "N | \n", "PUZZLE DE RESTAURANTES SL. | \n", "CALLE BALLESTA, 32 - LOC DR, 28004, MADRID, MA... | \n", "CALLE BALLESTA, 32 - LOC DR | \n", "MADRID | \n", "MADRID | \n", "SPAIN | \n", "28004 | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "NaN | \n", "POINT (-3.70280 40.41892) | \n", "
4 | \n", "1ST WANDA SERVICE SERVICIOS INTEGRADOS DE CONT... | \n", "1277282874#-3.70641#40.41956 | \n", "2019-12-01 | \n", "NaN | \n", "1277282874 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "MADRID | \n", "MADRID | \n", "MADRID | \n", "MADRID | \n", "MD | \n", "28013.0 | \n", "CALLE PRECIADOS, 29 - 5 A, 28013, MADRID, MADRID | \n", "CALLE PRECIADOS, 29 - 5 A | \n", "28013, MADRID, MADRID | \n", "-3.706410 | \n", "40.419560 | \n", "S8HPNTSCZA | \n", "HIGH | \n", "34.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "BUSINESS SERVICES, NEC, NSK | \n", "7389.0 | \n", "NaN | \n", "73890900.0 | \n", "FINANCIAL SERVICES | \n", "350.0 | \n", "10905900 | \n", "DIVISION I. - SERVICES | \n", "BUSINESS SERVICES | \n", "MISCELLANEOUS BUSINESS SERVICES | \n", "BUSINESS SERVICES, NEC | \n", "0.0 | \n", "1.0 | \n", "2003.0 | \n", "58097.0 | \n", "68508.0 | \n", "5080.0 | \n", "G | \n", "3.0 | \n", "1.0 | \n", "0.0 | \n", "1ST WANDA SERVICE SERVICIOS INTEGRADOS DE CONT... | \n", "CALLE PRECIADOS, 29 - 5 A, 28013, MADRID, MADR... | \n", "CALLE PRECIADOS, 29 - 5 A | \n", "MADRID | \n", "MADRID | \n", "SPAIN | \n", "28013 | \n", "1ST WANDA SERVICE SERVICIOS INTEGRADOS DE CONT... | \n", "CALLE PRECIADOS, 29 - 5 A, 28013, MADRID, MADRID | \n", "CALLE PRECIADOS, 29 - 5 A | \n", "MADRID | \n", "MADRID | \n", "28013.0 | \n", "Y | \n", "1ST WANDA SERVICE SERVICIOS INTEGRADOS DE CONT... | \n", "CALLE PRECIADOS, 29 - 5 A, 28013, MADRID, MADR... | \n", "CALLE PRECIADOS, 29 - 5 A | \n", "MADRID | \n", "MADRID | \n", "SPAIN | \n", "28013 | \n", "2.0 | \n", "1.0 | \n", "NaN | \n", "NaN | \n", "POINT (-3.70641 40.41956) | \n", "
\n", " | NAME | \n", "geoid | \n", "do_date | \n", "BRANDNAME | \n", "PB_ID | \n", "TRADE_NAME | \n", "FRANCHISE_NAME | \n", "ISO3 | \n", "AREANAME4 | \n", "AREANAME3 | \n", "AREANAME2 | \n", "AREANAME1 | \n", "STABB | \n", "POSTCODE | \n", "FORMATTEDADDRESS | \n", "MAINADDRESSLINE | \n", "ADDRESSLASTLINE | \n", "LONGITUDE | \n", "LATITUDE | \n", "GEORESULT | \n", "CONFIDENCE_CODE | \n", "COUNTRY_ACCESS_CODE | \n", "TEL_NUM | \n", "FAXNUM | \n", "HTTP | \n", "OPEN_24H | \n", "BUSINESS_LINE | \n", "SIC1 | \n", "SIC2 | \n", "SIC8 | \n", "SIC8_DESCRIPTION | \n", "ALT_INDUSTRY_CODE | \n", "MICODE | \n", "TRADE_DIVISION | \n", "GROUP | \n", "CLASS | \n", "SUB_CLASS | \n", "EMPLOYEE_HERE | \n", "EMPLOYEE_COUNT | \n", "YEAR_START | \n", "SALES_VOLUME_LOCAL | \n", "SALES_VOLUME_US_DOLLARS | \n", "CURRENCY_CODE | \n", "AGENT_CODE | \n", "LEGAL_STATUS_CODE | \n", "STATUS_CODE | \n", "SUBSIDIARY_INDICATOR | \n", "PARENT_BUSINESS_NAME | \n", "PARENT_ADDRESS | \n", "PARENT_STREET_ADDRESS | \n", "PARENT_AREANAME3 | \n", "PARENT_AREANAME1 | \n", "PARENT_COUNTRY | \n", "PARENT_POSTCODE | \n", "DOMESTIC_ULTIMATE_BUSINESS_NAME | \n", "DOMESTIC_ULTIMATE_ADDRESS | \n", "DOMESTIC_ULTIMATE_STREET_ADDRESS | \n", "DOMESTIC_ULTIMATE_AREANAME3 | \n", "DOMESTIC_ULTIMATE_AREANAME1 | \n", "DOMESTIC_ULTIMATE_POSTCODE | \n", "GLOBAL_ULTIMATE_INDICATOR | \n", "GLOBAL_ULTIMATE_BUSINESS_NAME | \n", "GLOBAL_ULTIMATE_ADDRESS | \n", "GLOBAL_ULTIMATE_STREET_ADDRESS | \n", "GLOBAL_ULTIMATE_AREANAME3 | \n", "GLOBAL_ULTIMATE_AREANAME1 | \n", "GLOBAL_ULTIMATE_COUNTRY | \n", "GLOBAL_ULTIMATE_POSTCODE | \n", "FAMILY_MEMBERS | \n", "HIERARCHY_CODE | \n", "TICKER_SYMBOL | \n", "EXCHANGE_NAME | \n", "geom | \n", "|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "ARCO DE CUCHILLEROS | \n", "2033946578#-3.708101#40.4147983 | \n", "2019-12-01 | \n", "NaN | \n", "2033946578 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "NaN | \n", "MADRID | \n", "MADRID | \n", "COMUNIDAD DE MADRID | \n", "MD | \n", "28012.0 | \n", "CALLE DE LOS CUCHILLEROS, 28012, MADRID, MADRID | \n", "CALLE DE LOS CUCHILLEROS | \n", "28012, MADRID, MADRID | \n", "-3.708101 | \n", "40.414798 | \n", "T20 | \n", "LOW | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "ARCH | \n", "NaN | \n", "10110112 | \n", "DIVISION L. - TOURISM | \n", "TOURISM | \n", "IMPORTANT TOURIST ATTRACTION | \n", "ARCH | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-3.70810 40.41480) | \n", "
1 | \n", "ATENEO DE MADRID | \n", "2033838561#-3.6982188#40.4150308 | \n", "2019-12-01 | \n", "NaN | \n", "2033838561 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "NaN | \n", "MADRID | \n", "MADRID | \n", "COMUNIDAD DE MADRID | \n", "MD | \n", "28014.0 | \n", "CALLE DEL PRADO, 28014, MADRID, MADRID | \n", "CALLE DEL PRADO | \n", "28014, MADRID, MADRID | \n", "-3.698219 | \n", "40.415031 | \n", "T20 | \n", "LOW | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "TOURIST BUILDING | \n", "NaN | \n", "10110200 | \n", "DIVISION L. - TOURISM | \n", "TOURISM | \n", "IMPORTANT TOURIST ATTRACTION | \n", "TOURIST BUILDING | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-3.69822 40.41503) | \n", "
2 | \n", "BANCO DE ESPAÑA | \n", "2022507776#-3.6939777#40.4189737 | \n", "2019-12-01 | \n", "NaN | \n", "2022507776 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "NaN | \n", "MADRID | \n", "MADRID | \n", "COMUNIDAD DE MADRID | \n", "MD | \n", "NaN | \n", "MADRID, MADRID | \n", "NaN | \n", "MADRID, MADRID | \n", "-3.693978 | \n", "40.418974 | \n", "T1 | \n", "HIGH | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "TOURIST BUILDING | \n", "NaN | \n", "10110200 | \n", "DIVISION L. - TOURISM | \n", "TOURISM | \n", "IMPORTANT TOURIST ATTRACTION | \n", "TOURIST BUILDING | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-3.69398 40.41897) | \n", "
3 | \n", "BASÍLICA DE NUESTRO PADRE JESÚS DE MEDINACELI | \n", "2033893910#-3.6957089#40.4141956 | \n", "2019-12-01 | \n", "NaN | \n", "2033893910 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "NaN | \n", "MADRID | \n", "MADRID | \n", "COMUNIDAD DE MADRID | \n", "MD | \n", "28014.0 | \n", "PLAZA DE JESÚS, 28014, MADRID, MADRID | \n", "PLAZA DE JESÚS | \n", "28014, MADRID, MADRID | \n", "-3.695709 | \n", "40.414196 | \n", "T20 | \n", "LOW | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "TOURIST BUILDING | \n", "NaN | \n", "10110200 | \n", "DIVISION L. - TOURISM | \n", "TOURISM | \n", "IMPORTANT TOURIST ATTRACTION | \n", "TOURIST BUILDING | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-3.69571 40.41420) | \n", "
4 | \n", "BIBLIOTECA NACIONAL DE ESPAÑA | \n", "2033804926#-3.6906236#40.4238526 | \n", "2019-12-01 | \n", "NaN | \n", "2033804926 | \n", "NaN | \n", "NaN | \n", "ESP | \n", "NaN | \n", "MADRID | \n", "MADRID | \n", "COMUNIDAD DE MADRID | \n", "MD | \n", "28001.0 | \n", "PASEO DE RECOLETOS, 28001, MADRID, MADRID | \n", "PASEO DE RECOLETOS | \n", "28001, MADRID, MADRID | \n", "-3.690624 | \n", "40.423853 | \n", "T20 | \n", "LOW | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "TOURIST BUILDING | \n", "NaN | \n", "10110200 | \n", "DIVISION L. - TOURISM | \n", "TOURISM | \n", "IMPORTANT TOURIST ATTRACTION | \n", "TOURIST BUILDING | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-3.69062 40.42385) | \n", "