{ "id" : "qrgc-u7pk", "name" : "Registre d’Entitats Esportives", "assetType" : "dataset", "attribution" : "Departament d'Esports", "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/", "averageRating" : 0, "category" : "Esport", "createdAt" : 1594108865, "description" : "El Registre d'Entitats Esportives de la Generalitat de Catalunya té com a finalitat la inscripció d’entitats esportives que tinguin la seu a Catalunya.\nEn aquest registre també s’inscriuen, entre d’altres, els actes i dades següents: la modificació dels estatuts de les entitats esportives, el nomenament, la suspensió i el cessament dels membres electes de l’òrgan de govern de les entitats esportives i la dissolució de les entitats esportives.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 6446, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "SEE_TERMS_OF_USE", "locked" : false, "newBackend" : true, "numberOfComments" : 0, "oid" : 3122609, "provenance" : "official", "publicationAppendEnabled" : true, "publicationDate" : 1776673924, "publicationGroup" : 1195258, "publicationStage" : "published", "rowIdentifierColumnId" : 27308058, "rowsUpdatedAt" : 1778272446, "rowsUpdatedBy" : "a4b5-gx6v", "tableId" : 2101500, "totalTimesRated" : 0, "viewCount" : 39200, "viewLastModified" : 1778272446, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1594109930, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 1557409, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1594109930, "targetAudience" : "public", "workflowId" : 182, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "endedAt" : 1594109930, "failureCount" : 0, "startedAt" : 1594109930, "status" : "success" }, "submitter" : { "id" : "f79v-x7kr", "displayName" : "Dades obertes Presidència" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 27308058, "name" : "Número de registre", "dataTypeName" : "text", "description" : "Número que identifica la inscripció de l’entitat al registre", "fieldName" : "n_m_registre", "position" : 1, "renderTypeName" : "text", "tableColumnId" : 10027263, "cachedContents" : { "non_null" : "21396", "largest" : "A02190", "null" : "0", "top" : [ { "item" : "00002", "count" : "1" }, { "item" : "00003", "count" : "1" }, { "item" : "00004", "count" : "1" }, { "item" : "00005", "count" : "1" }, { "item" : "00006", "count" : "1" }, { "item" : "00007", "count" : "1" }, { "item" : "00008", "count" : "1" }, { "item" : "00009", "count" : "1" }, { "item" : "00010", "count" : "1" }, { "item" : "00011", "count" : "1" }, { "item" : "00012", "count" : "1" }, { "item" : "00014", "count" : "1" }, { "item" : "00015", "count" : "1" }, { "item" : "00016", "count" : "1" }, { "item" : "00017", "count" : "1" }, { "item" : "00018", "count" : "1" }, { "item" : "00019", "count" : "1" }, { "item" : "00020", "count" : "1" }, { "item" : "00021", "count" : "1" }, { "item" : "00001", "count" : "1" } ], "smallest" : "00001", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308059, "name" : "Nom entitat", "dataTypeName" : "text", "description" : "Nom que identifica l’entitat esportiva", "fieldName" : "nom_entitat", "position" : 2, "renderTypeName" : "text", "tableColumnId" : 10027262, "cachedContents" : { "non_null" : "21396", "largest" : "ZONA RECREATIVA BARCINOVA", "null" : "0", "top" : [ { "item" : "CASINO DE LA GARRIGA", "count" : "2" }, { "item" : "ASSOCIACIO DE PARES DALUMNES DEL COL·LEGI PUBLIC VERD", "count" : "2" }, { "item" : "226 LONG DISTANCE CLUB ESPORTIU", "count" : "1" }, { "item" : "24 HORES FUTBOL SALA BALAGUER CLUB", "count" : "1" }, { "item" : "2A SQUADRA EVENTS CLUB DEPORTIVO", "count" : "1" }, { "item" : "3DSKADI SL", "count" : "1" }, { "item" : "4T2 MOTOR CLUBCERDANYOLA", "count" : "1" }, { "item" : "8DBIKERS BTT CLUB", "count" : "1" }, { "item" : "4WD CATALUNYA CLUB ESPORTIU MOIA", "count" : "1" }, { "item" : "4 X 4 BAGES CLUB", "count" : "1" }, { "item" : "4X4 EL VENDRELL CLUB ESPORTIU", "count" : "1" }, { "item" : "4 X 4 PALLARS SOBIRA CLUB", "count" : "1" }, { "item" : "4 X 4 RODES CLUB", "count" : "1" }, { "item" : "5 OCEANS COMPAÑIA DE NAVEGACION SL", "count" : "1" }, { "item" : "7 DAVENTURA SL", "count" : "1" }, { "item" : "4000 PEUS ASSOCIACIO EXCURSIONISTA COLLBATO", "count" : "1" }, { "item" : "8 TEMPS CLUB DE BALL ESPORTIU DE RUBI", "count" : "1" }, { "item" : "AAVV 1993 BARRI CENTRE SANTA COLOMA GRAMENET", "count" : "1" }, { "item" : "AAVV BACHSBUFALA", "count" : "1" }, { "item" : "22 YARDS CRICKET CLUB", "count" : "1" } ], "smallest" : "12 PATOS CLUB ARQUERS", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308060, "name" : "Adreça", "dataTypeName" : "text", "description" : "Adreça física on s’ubica l’entitat esportiva", "fieldName" : "adre_a", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 10027261, "cachedContents" : { "non_null" : "21396", "largest" : "Zurbano, 85 Esc. C 6è. 3a.", "null" : "0", "top" : [ { "item" : "Major, 1", "count" : "36" }, { "item" : "Catalunya, s/n", "count" : "24" }, { "item" : "Afores, s/n", "count" : "22" }, { "item" : "Pau Casals, s/n", "count" : "22" }, { "item" : "de la Vila, 1", "count" : "19" }, { "item" : "Escoles, s/n", "count" : "17" }, { "item" : "Major, s/n", "count" : "16" }, { "item" : "Major, 4", "count" : "15" }, { "item" : "Països Catalans, s/n", "count" : "14" }, { "item" : "de les Escoles, s/n", "count" : "14" }, { "item" : "Major, 2", "count" : "13" }, { "item" : "Zona Esportiva Municipal, s/n", "count" : "12" }, { "item" : "de l'Esport, s/n", "count" : "12" }, { "item" : "Major, 5", "count" : "12" }, { "item" : "dels Esports, s/n", "count" : "12" }, { "item" : "Tarragona, s/n", "count" : "11" }, { "item" : "de l'Ajuntament, 1", "count" : "11" }, { "item" : "Calàbria, 66", "count" : "11" }, { "item" : "Ajuntament, 1", "count" : "10" }, { "item" : "Onze de setembre, s/n", "count" : "10" } ], "smallest" : ".", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308061, "name" : "Codi postal", "dataTypeName" : "text", "description" : "Codi postal de l’adreça on s’ubica l’entitat esportiva", "fieldName" : "cp", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 10027254, "cachedContents" : { "non_null" : "21388", "largest" : "97272", "null" : "8", "top" : [ { "item" : "08800", "count" : "171" }, { "item" : "08028", "count" : "161" }, { "item" : "08860", "count" : "156" }, { "item" : "08820", "count" : "143" }, { "item" : "08940", "count" : "142" }, { "item" : "08830", "count" : "142" }, { "item" : "08030", "count" : "137" }, { "item" : "08240", "count" : "135" }, { "item" : "08290", "count" : "134" }, { "item" : "08014", "count" : "133" }, { "item" : "08191", "count" : "133" }, { "item" : "17300", "count" : "129" }, { "item" : "08700", "count" : "129" }, { "item" : "08100", "count" : "121" }, { "item" : "08720", "count" : "115" }, { "item" : "08020", "count" : "115" }, { "item" : "08500", "count" : "113" }, { "item" : "08004", "count" : "112" }, { "item" : "08005", "count" : "111" }, { "item" : "17600", "count" : "110" } ], "smallest" : "01716", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308062, "name" : "Municipi", "dataTypeName" : "text", "description" : "Municipi on s’ubica l’entitat esportiva", "fieldName" : "municipi", "position" : 5, "renderTypeName" : "text", "tableColumnId" : 10027260, "cachedContents" : { "non_null" : "21396", "largest" : "Xerta", "null" : "0", "top" : [ { "item" : "Barcelona", "count" : "2919" }, { "item" : "Lleida", "count" : "446" }, { "item" : "Badalona", "count" : "414" }, { "item" : "Terrassa", "count" : "409" }, { "item" : "Hospitalet de Llobregat, l'", "count" : "396" }, { "item" : "Sabadell", "count" : "391" }, { "item" : "Tarragona", "count" : "352" }, { "item" : "Santa Coloma de Gramenet", "count" : "293" }, { "item" : "Girona", "count" : "265" }, { "item" : "Mataró", "count" : "259" }, { "item" : "Reus", "count" : "254" }, { "item" : "Sant Cugat del Vallès", "count" : "178" }, { "item" : "Manresa", "count" : "175" }, { "item" : "Vilanova i la Geltrú", "count" : "169" }, { "item" : "Castelldefels", "count" : "155" }, { "item" : "Cerdanyola del Vallès", "count" : "149" }, { "item" : "Sant Boi de Llobregat", "count" : "149" }, { "item" : "Granollers", "count" : "148" }, { "item" : "Prat de Llobregat, el", "count" : "143" }, { "item" : "Cornellà de Llobregat", "count" : "143" } ], "smallest" : "Abella de la Conca", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308063, "name" : "Comarca", "dataTypeName" : "text", "description" : "Comarca on s’ubica l’entitat esportiva", "fieldName" : "comarca", "position" : 6, "renderTypeName" : "text", "tableColumnId" : 10027259, "cachedContents" : { "non_null" : "21190", "largest" : "Vallès Oriental", "null" : "206", "top" : [ { "item" : "Barcelonès", "count" : "4125" }, { "item" : "Vallès Occidental", "count" : "2005" }, { "item" : "Baix Llobregat", "count" : "1816" }, { "item" : "Maresme", "count" : "1264" }, { "item" : "Vallès Oriental", "count" : "1158" }, { "item" : "Segrià", "count" : "876" }, { "item" : "Tarragonès", "count" : "730" }, { "item" : "Bages", "count" : "632" }, { "item" : "Selva", "count" : "616" }, { "item" : "Baix Camp", "count" : "615" }, { "item" : "Osona", "count" : "579" }, { "item" : "Gironès", "count" : "569" }, { "item" : "Alt Empordà", "count" : "509" }, { "item" : "Baix Empordà", "count" : "469" }, { "item" : "Anoia", "count" : "449" }, { "item" : "Garraf", "count" : "405" }, { "item" : "Alt Penedès", "count" : "369" }, { "item" : "Baix Ebre", "count" : "349" }, { "item" : "Baix Penedès", "count" : "312" }, { "item" : "Montsià", "count" : "286" } ], "smallest" : "Alta Ribagorça", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308064, "name" : "Mòbil / Telèfon", "dataTypeName" : "text", "description" : "Mòbil i Telèfon de contacte de l’entitat esportiva", "fieldName" : "tel_fon_fax", "position" : 7, "renderTypeName" : "text", "tableColumnId" : 10027258, "cachedContents" : { "non_null" : "18849", "largest" : "979708601", "null" : "2547", "top" : [ { "item" : "937183654", "count" : "12" }, { "item" : "932381042", "count" : "9" }, { "item" : "667747464", "count" : "9" }, { "item" : "972772951", "count" : "8" }, { "item" : "977820523", "count" : "8" }, { "item" : "972805384", "count" : "7" }, { "item" : "679083331", "count" : "7" }, { "item" : "977958646", "count" : "6" }, { "item" : "615599616", "count" : "6" }, { "item" : "680452472", "count" : "6" }, { "item" : "973791763", "count" : "5" }, { "item" : "933259200", "count" : "5" }, { "item" : "937523579", "count" : "4" }, { "item" : "937755351", "count" : "4" }, { "item" : "651786786", "count" : "4" }, { "item" : "936643102", "count" : "4" }, { "item" : "937870980", "count" : "4" }, { "item" : "934480400", "count" : "4" }, { "item" : "636987306", "count" : "4" }, { "item" : "638156416", "count" : "4" } ], "smallest" : "003768859", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308065, "name" : "Correu electrònic", "dataTypeName" : "text", "description" : "Correu electrònic de contacte de l’entitat esportiva", "fieldName" : "correu_electr_nic", "position" : 8, "renderTypeName" : "text", "tableColumnId" : 10027257, "cachedContents" : { "non_null" : "12805", "largest" : "zumbafels@gmail.com", "null" : "8591", "top" : [ { "item" : "ramonmayenchcots@gmail.com", "count" : "8" }, { "item" : "malus@once.es", "count" : "7" }, { "item" : "joseluisaccensi@hotmail.com", "count" : "5" }, { "item" : "nordicwalkingpirineus@gmail.com", "count" : "5" }, { "item" : "trikidss@gmail.com", "count" : "3" }, { "item" : "fenix22@hotmail.es", "count" : "3" }, { "item" : "esports@torredembarra.cat", "count" : "3" }, { "item" : "moicat977@gmail.com", "count" : "3" }, { "item" : "joan.casahuga@gmail.com", "count" : "3" }, { "item" : "naniescude@athc.cat", "count" : "3" }, { "item" : "clubpatinatgeartistic@gmail.com", "count" : "3" }, { "item" : "seccionesdeportivas@rcpolo.com", "count" : "3" }, { "item" : "fcsportinggava@gmail.com", "count" : "3" }, { "item" : "info@ahkgroup.es", "count" : "3" }, { "item" : "pescalleida@hotmail.com", "count" : "3" }, { "item" : "billarmasnou@gmail.com", "count" : "2" }, { "item" : "bergatennisclub@hotmail.com", "count" : "2" }, { "item" : "boxasantgervasi@gmail.com", "count" : "2" }, { "item" : "barcelonatrapclub@gmail.com", "count" : "2" }, { "item" : "bacusflagullastrell@gmail.com", "count" : "2" } ], "smallest" : "08042056@xtec.cat", "count" : "21396", "cardinality" : "21396" }, "format" : { "displayStyle" : "email" } }, { "id" : 27308066, "name" : "Tipus d’entitat", "dataTypeName" : "text", "description" : "Tipologia a la que correspon l’entitat", "fieldName" : "tipus_entitat", "position" : 9, "renderTypeName" : "text", "tableColumnId" : 10027256, "cachedContents" : { "non_null" : "21396", "largest" : "Universitats", "null" : "0", "top" : [ { "item" : "Clubs i Associacions Esportives", "count" : "18383" }, { "item" : "Associacions civils i culturals", "count" : "839" }, { "item" : "Seccions Esportives escolars", "count" : "654" }, { "item" : "Associacions Esportives Escolars", "count" : "631" }, { "item" : "AMPA", "count" : "501" }, { "item" : "Fundacions", "count" : "92" }, { "item" : "Federacions", "count" : "73" }, { "item" : "Clubs Universitaris", "count" : "48" }, { "item" : "Consells Esportius", "count" : "46" }, { "item" : "Entitats de caràcter lucratiu", "count" : "46" }, { "item" : "Institucions Religioses", "count" : "21" }, { "item" : "Societats Anònimes Esportives", "count" : "18" }, { "item" : "Agrupacions Esportives", "count" : "15" }, { "item" : "Unio esportiva de clubs", "count" : "12" }, { "item" : "Agrupació Esportiva Territorial", "count" : "8" }, { "item" : "Cooperatives", "count" : "6" }, { "item" : "Grups Esportius", "count" : "2" }, { "item" : "Universitats", "count" : "1" } ], "smallest" : "Agrupació Esportiva Territorial", "count" : "21396", "cardinality" : "21396" }, "format" : { } }, { "id" : 27308067, "name" : "Modalitats", "dataTypeName" : "text", "description" : "Modalitats esportives de l’entitat", "fieldName" : "modalitats", "position" : 10, "renderTypeName" : "text", "tableColumnId" : 10027255, "cachedContents" : { "non_null" : "21262", "largest" : "Wu-shu, Txikung (Qigong), Kung-fu, Tai txi", "null" : "134", "top" : [ { "item" : "Futbol", "count" : "2457" }, { "item" : "Futbol sala (Futbol cinc)", "count" : "959" }, { "item" : "Basquetbol", "count" : "890" }, { "item" : "Caça", "count" : "786" }, { "item" : "Petanca", "count" : "677" }, { "item" : "Ciclisme", "count" : "646" }, { "item" : "Escacs", "count" : "314" }, { "item" : "Activitats físico-esportives", "count" : "313" }, { "item" : "Handbol", "count" : "236" }, { "item" : "Atletisme", "count" : "235" }, { "item" : "Motociclisme", "count" : "234" }, { "item" : "Voleibol", "count" : "217" }, { "item" : "Pesca Esportiva", "count" : "216" }, { "item" : "Tennis taula", "count" : "212" }, { "item" : "Patinatge artístic", "count" : "205" }, { "item" : "Automobilisme", "count" : "194" }, { "item" : "Hípica", "count" : "190" }, { "item" : "Taekwon-do", "count" : "188" }, { "item" : "Tennis", "count" : "179" }, { "item" : "Excursionisme", "count" : "176" } ], "smallest" : "Acampada (excursionisme)", "count" : "21396", "cardinality" : "21396" }, "format" : { } } ], "grants" : [ { "inherited" : false, "type" : "viewer", "flags" : [ "public" ] } ], "license" : { "name" : "See Terms of Use" }, "metadata" : { "custom_fields" : { "Freqüència d'actualització" : { "Freqüència d'actualització" : "Setmanal" }, "Idioma" : { "Idioma" : "Català", "Dataset name (EN)" : "Registry of Sports Entities ", "Nombre del conjunto de datos (ES)" : "Registro de Entidades Deportivas" }, "Informació de gènere o sexe" : { "Informació de gènere o sexe" : "No aplicable" }, "Actors" : { "Departament" : "Esports", "Tipus actor" : "Generalitat de Catalunya" }, "Àmbit geogràfic" : { "Informació geogràfica" : "Codi d'element", "Àmbit geogràfic" : "Catalunya" } }, "rowIdentifier" : 27308058, "availableDisplayTypes" : [ "table", "fatrow", "page" ] }, "owner" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya", "profileImageUrlLarge" : "/api/users/a4b5-gx6v/profile_images/LARGE", "profileImageUrlMedium" : "/api/users/a4b5-gx6v/profile_images/THUMB", "profileImageUrlSmall" : "/api/users/a4b5-gx6v/profile_images/TINY", "screenName" : "Dades Obertes Catalunya", "type" : "interactive", "flags" : [ "acceptedEula" ] }, "query" : { }, "rights" : [ "read" ], "tableAuthor" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya", "profileImageUrlLarge" : "/api/users/a4b5-gx6v/profile_images/LARGE", "profileImageUrlMedium" : "/api/users/a4b5-gx6v/profile_images/THUMB", "profileImageUrlSmall" : "/api/users/a4b5-gx6v/profile_images/TINY", "screenName" : "Dades Obertes Catalunya", "type" : "interactive", "flags" : [ "acceptedEula" ] }, "tags" : [ "ree", "registre d'entitats esportives", "entitats", "esport", "ods16_pau justícies i institucions sòlides" ], "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ] }