Mobiliario urbano. Mesas - 300217-16-mobiliario-mesas-csv - Portal de datos abiertos del Ayuntamiento de Madrid

Back

Mobiliario urbano. Mesas. 2023 Download TSV JSON XML
Publication date	October 10, 2023
Format	CSV
MIME Type	text/csv
Size	349.1 KB
Downloads	724
Resource Type	data
URL	https://datos.madrid.es/en/en/dataset/300217-0-mobiliario-mesas/resource/300217-16-mobiliario-mesas-csv/download/300217-16-mobiliario-mesas-csv.csv
License	Creative Commons Attribution 4.0 International (CC BY 4.0)

Api Info. Api more info

Endpoints »

Data Api Access

Query	`https://datos.madrid.es/en/api/3/action/datastore_search`
Query (via SQL)	`https://datos.madrid.es/en/api/3/action/datastore_search_sql`

Querying »

Query example (first 5 results)

https://datos.madrid.es/en/api/3/action/datastore_search?resource_id=300217-16-mobiliario-mesas-csv&limit=5

Query example (results containing 'jones')

https://datos.madrid.es/en/api/3/action/datastore_search?resource_id=300217-16-mobiliario-mesas-csv&q=jones

Query example (via SQL statement)

Example: Javascript »

Filter by field value

A simple ajax (JSONP)

        var data = {
          resource_id: '300217-16-mobiliario-mesas-csv', // the resource id
          limit: 5, // get 5 results
          q: 'jones' // query for 'jones'
        };
        $.ajax({
          url: 'https://datos.madrid.es/en/api/3/action/datastore_search',
          data: data,
          dataType: 'jsonp',
          success: function(data) {
            alert('Total results found: ' + data.result.total)
          }
        });

Example: Python »

      import urllib
      url = 'https://datos.madrid.es/en/api/3/action/datastore_search?resource_id=300217-16-mobiliario-mesas-csv&limit=5&q=title:jones'  
      fileobj = urllib.urlopen(url)
      print fileobj.read()

Column	Type	Label	Description
MXASSETNUM,C,12	text
DESCRIPTIO,C,105	text
MINTDISTRI,C,20	text
NOMBRE_DIS,C,100	text
MINTBARRIO,C,10	text
NOMBRE_BAR,C,100	text
ESTADO,C,50	text
INSTALLDAT,D	text
MINTTIPOVI,C,15	text
MINTNOMBRE,C,254	text
MINTNUMERO,C,25	text
MINTNDP,C,20	text
MODELO,C,254	text

YOUR CITY, CLOSER

674

11.571

Mobiliario urbano. Mesas. 2023

2026 3

2025 3

2024 3

2023 3

2022 3

2021 3

2019 3

2018 2

Mobiliario urbano. Mesas. 2023