Tweets from the 2014 Jacathon of Aragón Open DataTweets en el Jacathon 2014 de Aragón Open Data
Tweets en el Jacathon 2014 de Aragón Open DataTweets from the 2014 Jacathon of Aragón Open Data
This dataset collects tweets generated before and after the Jacathon Aragón Open Data event, held in Jaca. Tweets were gathered by monitoring a set of hashtags related to the event, including jacathon, maddata, medialab, jacaton, datathon, aragonopendata, hackathon, hackaton, opendata, and jaca. It is published by the Government of Aragón (Gobierno de Aragón) as part of its open data initiative, documenting social media activity and public engagement surrounding this technology and data-focused hackathon event.Este fichero recoge los tweets generados antes y después del Jacathon Aragón Open Data. La recogida de tweets se ha generado en base a la escucha de un determinado número de hashtags relacionados con el Jacathon, en concreto se ha escuchado los términos jacathon, maddata, medialab, jacaton, datathon, aragonopendata, hackathon, hackaton, opendata, jaca.
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (27 fields)
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| created_atCreated at | text | Timestamp when the tweet was created, in Twitter's original text format.Timestamp when the tweet was created, in Twitter's original text format. |
| id | int | Unique numeric identifier of the tweet.Unique numeric identifier of the tweet. |
| id_strId str | text | Unique tweet identifier as a text string.Unique tweet identifier as a text string. |
| text | text | Full text content of the tweet.Full text content of the tweet. |
| source | text | HTML markup indicating the application used to post the tweet.HTML markup indicating the application used to post the tweet. |
| truncated | boolean | Indicates whether the tweet text was truncated.Indicates whether the tweet text was truncated. |
| in_reply_to_status_idIn reply to status id | int | Numeric ID of the tweet this one replies to, if any.Numeric ID of the tweet this one replies to, if any. |
| in_reply_to_status_id_strIn reply to status id str | text | ID as text of the tweet this one replies to, if any.ID as text of the tweet this one replies to, if any. |
| in_reply_to_user_idIn reply to user id | int | Numeric ID of the user being replied to, if any.Numeric ID of the user being replied to, if any. |
| in_reply_to_user_id_strIn reply to user id str | text | ID as text of the user being replied to, if any.ID as text of the user being replied to, if any. |
| in_reply_to_screen_nameIn reply to screen name | text | Screen name of the user being replied to, if any.Screen name of the user being replied to, if any. |
| user | object | Object containing details of the Twitter account that posted the tweet.Object containing details of the Twitter account that posted the tweet. |
| geoTerritory | text | Deprecated geolocation data associated with the tweet.Deprecated geolocation data associated with the tweet. |
| coordinates | text | Geographic coordinates where the tweet was posted, if available.Geographic coordinates where the tweet was posted, if available. |
| place | text | Place information associated with the tweet, if available.Place information associated with the tweet, if available. |
| contributors | text | Contributors associated with the tweet, if any.Contributors associated with the tweet, if any. |
| retweet_countRetweet count | int | Number of times the tweet has been retweeted.Number of times the tweet has been retweeted. |
| favorite_countFavorite count | int | Number of times the tweet has been marked as favorite.Number of times the tweet has been marked as favorite. |
| entities | object | Object listing hashtags, URLs, mentions and media found in the tweet.Object listing hashtags, URLs, mentions and media found in the tweet. |
| favorited | boolean | Indicates whether the tweet has been favorited.Indicates whether the tweet has been favorited. |
| retweeted | boolean | Indicates whether the tweet has been retweeted.Indicates whether the tweet has been retweeted. |
| possibly_sensitivePossibly sensitive | boolean | Indicates whether the tweet may contain sensitive content.Indicates whether the tweet may contain sensitive content. |
| filter_levelFilter level | text | Level of filtering applied by Twitter's streaming API to the tweet.Level of filtering applied by Twitter's streaming API to the tweet. |
| lang | text | Language code detected for the tweet text.Language code detected for the tweet text. |
| timestamp_msTimestamp ms | text | Tweet creation time in Unix milliseconds.Tweet creation time in Unix milliseconds. |
| retweeted_statusRetweeted status | object | Object with the original tweet data if this tweet is a retweet.Object with the original tweet data if this tweet is a retweet. |
| extended_entitiesExtended entities | object | Extended object with additional media details attached to the tweet.Extended object with additional media details attached to the tweet. |
Schema captured from ckan 7 days ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
Sample data (5 records)
Record 1id: 516601949920034800 · geo: —
{
"id": 516601949920034800,
"geo": null,
"lang": "en",
"text": "Hackathon http://t.co/ipL2VjqOLl",
"user": {
"id": 397916393,
"url": null,
"lang": "de",
"name": "Entwickler",
"id_str": "397916393",
"location": "Germany",
"verified": false,
"following": null,
"protected": false,
"time_zone": "Berlin",
"created_at": "Tue Oct 25 10:01:45 +0000 2011",
"utc_offset": 7200,
"description": "Developer, Developer, Developer",
"geo_enabled": false,
"screen_name": "entwick1er",
"listed_count": 0,
"friends_count": 15,
"is_translator": false,
"notifications": null,
"statuses_count": 3613,
"default_profile": false,
"followers_count": 17,
"favourites_count": 0,
"profile_image_url": "http://pbs.twimg.com/profile_images/1652138593/test_normal.png",
"profile_link_color": "5A79B1",
"profile_text_color": "333333",
"follow_request_sent": null,
"contributors_enabled": false,
"default_profile_image": false,
"profile_background_tile": false,
"profile_image_url_https": "https://pbs.twimg.com/profile_images/1652138593/test_normal.png",
"profile_background_color": "FFFFFF",
"profile_sidebar_fill_color": "F2F8FA",
"profile_background_image_url": "http://abs.twimg.com/images/themes/theme1/bg.png",
"profile_sidebar_border_color": "5A79B1",
"profile_use_background_image": false,
"profile_background_image_url_https": "https://abs.twimg.com/images/themes/theme1/bg.png"
},
"place": null,
"id_str": "516601949920034818",
"source": "<a href=\"http://dlvr.it\" rel=\"nofollow\">dlvr.it</a>",
"entities": {
"urls": [
{
"url": "http://t.co/ipL2VjqOLl",
"indices": [
10,
32
],
"display_url": "bit.ly/1pChkEK",
"expanded_url": "http://bit.ly/1pChkEK"
}
],
"trends": [],
"symbols": [],
"hashtags": [],
"user_mentions": []
},
"favorited": false,
"retweeted": false,
"truncated": false,
"created_at": "Mon Sep 29 14:54:37 +0000 2014",
"coordinates": null,
"contributors": null,
"filter_level": "medium",
"timestamp_ms": "1412002477524",
"retweet_count": 0,
"favorite_count": 0,
"possibly_sensitive": false,
"in_reply_to_user_id": null,
"in_reply_to_status_id": null,
"in_reply_to_screen_name": null,
"in_reply_to_user_id_str": null,
"in_reply_to_status_id_str": null
}Record 2id: 516602189775896600 · geo: —
{
"id": 516602189775896600,
"geo": null,
"lang": "en",
"text": "RT @OKFN: A #DataRevolution that works for All of Us http://t.co/GrLUGTvGp8 - new post on @OKFN blog by our founder @rufuspollock #OpenData",
"user": {
"id": 2329418378,
"url": "http://www.iadb.org/es/temas/gobierno",
"lang": "en",
"name": "GobernArte",
"id_str": "2329418378",
"location": "América Latina y el Caribe",
"verified": false,
"following": null,
"protected": false,
"time_zone": null,
"created_at": "Wed Feb 05 22:09:03 +0000 2014",
"utc_offset": null,
"description": "Gestión pública para los ciudadanos. Desde el BID promovemos gobiernos efectivos, eficientes y abiertos.",
"geo_enabled": false,
"screen_name": "BID_GobernArte",
"listed_count": 59,
"friends_count": 168,
"is_translator": false,
"notifications": null,
"statuses_count": 1928,
"default_profile": false,
"followers_count": 1071,
"favourites_count": 533,
"profile_image_url": "http://pbs.twimg.com/profile_images/491257113725792256/fHlNsZhi_normal.jpeg",
"profile_banner_url": "https://pbs.twimg.com/profile_banners/2329418378/1405960438",
"profile_link_color": "0084B4",
"profile_text_color": "333333",
"follow_request_sent": null,
"contributors_enabled": false,
"default_profile_image": false,
"profile_background_tile": true,
"profile_image_url_https": "https://pbs.twimg.com/profile_images/491257113725792256/fHlNsZhi_normal.jpeg",
"profile_background_color": "C0DEED",
"profile_sidebar_fill_color": "DDEEF6",
"profile_background_image_url": "http://pbs.twimg.com/profile_background_images/491258574710919168/nEk-xrg5.jpeg",
"profile_sidebar_border_color": "000000",
"profile_use_background_image": true,
"profile_background_image_url_https": "https://pbs.twimg.com/profile_background_images/491258574710919168/nEk-xrg5.jpeg"
},
"place": null,
"id_str": "516602189775896579",
"source": "<a href=\"http://twitter.com\" rel=\"nofollow\">Twitter Web Client</a>",
"entities": {
"urls": [
{
"url": "http://t.co/GrLUGTvGp8",
"indices": [
53,
75
],
"display_url": "blog.okfn.org/2014/09/24/a-d…",
"expanded_url": "http://blog.okfn.org/2014/09/24/a-data-revolution-that-works-for-all-of-us/"
}
],
"trends": [],
"symbols": [],
"hashtags": [
{
"text": "DataRevolution",
"indices": [
12,
27
]
},
{
"text": "OpenData",
"indices": [
130,
139
]
}
],
"user_mentions": [
{
"id": 16143105,
"name": "Open Knowledge",
"id_str": "16143105",
"indices": [
3,
8
],
"screen_name": "OKFN"
},
{
"id": 16143105,
"name": "Open Knowledge",
"id_str": "16143105",
"indices": [
90,
95
],
"screen_name": "OKFN"
},
{
"id": 107722135,
"name": "Rufus Pollock",
"id_str": "107722135",
"indices": [
116,
129
],
"screen_name": "rufuspollock"
}
]
},
"favorited": false,
"retweeted": false,
"truncated": false,
"created_at": "Mon Sep 29 14:55:34 +0000 2014",
"coordinates": null,
"contributors": null,
"filter_level": "medium",
"timestamp_ms": "1412002534760",
"retweet_count": 0,
"favorite_count": 0,
"retweeted_status": "[large value omitted]",
"possibly_sensitive": false,
"in_reply_to_user_id": null,
"in_reply_to_status_id": null,
"in_reply_to_screen_name": null,
"in_reply_to_user_id_str": null,
"in_reply_to_status_id_str": null
}Record 3id: 516602293811417100 · geo: —
{
"id": 516602293811417100,
"geo": null,
"lang": "fr",
"text": "La phase pré #opendata repose sur les spécialistes des divers domaines",
"user": {
"id": 378017822,
"url": null,
"lang": "fr",
"name": "Khadija EL BOUCHIKHI",
"id_str": "378017822",
"location": "France",
"verified": false,
"following": null,
"protected": false,
"time_zone": "Amsterdam",
"created_at": "Thu Sep 22 14:14:39 +0000 2011",
"utc_offset": 7200,
"description": "Dr en sciences de l'information et de la communication",
"geo_enabled": false,
"screen_name": "KelKhadija",
"listed_count": 2,
"friends_count": 56,
"is_translator": false,
"notifications": null,
"statuses_count": 1991,
"default_profile": true,
"followers_count": 120,
"favourites_count": 3,
"profile_image_url": "http://pbs.twimg.com/profile_images/1557768456/Picture0014_normal.jpg",
"profile_banner_url": "https://pbs.twimg.com/profile_banners/378017822/1401920978",
"profile_link_color": "0084B4",
"profile_text_color": "333333",
"follow_request_sent": null,
"contributors_enabled": false,
"default_profile_image": false,
"profile_background_tile": false,
"profile_image_url_https": "https://pbs.twimg.com/profile_images/1557768456/Picture0014_normal.jpg",
"profile_background_color": "C0DEED",
"profile_sidebar_fill_color": "DDEEF6",
"profile_background_image_url": "http://abs.twimg.com/images/themes/theme1/bg.png",
"profile_sidebar_border_color": "C0DEED",
"profile_use_background_image": true,
"profile_background_image_url_https": "https://abs.twimg.com/images/themes/theme1/bg.png"
},
"place": null,
"id_str": "516602293811417088",
"source": "<a href=\"http://twitter.com\" rel=\"nofollow\">Twitter Web Client</a>",
"entities": {
"urls": [],
"trends": [],
"symbols": [],
"hashtags": [
{
"text": "opendata",
"indices": [
13,
22
]
}
],
"user_mentions": []
},
"favorited": false,
"retweeted": false,
"truncated": false,
"created_at": "Mon Sep 29 14:55:59 +0000 2014",
"coordinates": null,
"contributors": null,
"filter_level": "medium",
"timestamp_ms": "1412002559513",
"retweet_count": 0,
"favorite_count": 0,
"possibly_sensitive": false,
"in_reply_to_user_id": null,
"in_reply_to_status_id": null,
"in_reply_to_screen_name": null,
"in_reply_to_user_id_str": null,
"in_reply_to_status_id_str": null
}Record 4id: 516602318150594560 · geo: —
{
"id": 516602318150594560,
"geo": null,
"lang": "sv",
"text": "Hackaton Program.Ar en la UNNE http://t.co/nkbKLXNRwY",
"user": {
"id": 356914965,
"url": "http://about.me/diarioellitoral",
"lang": "es",
"name": "Diario El Litoral",
"id_str": "356914965",
"location": "Corrientes",
"verified": false,
"following": null,
"protected": false,
"time_zone": "Buenos Aires",
"created_at": "Wed Aug 17 15:22:38 +0000 2011",
"utc_offset": -10800,
"description": "Periodismo real, en tiempo real. #Corrientes. Subí tus fotos, videos y noticias a http://www.ellitoral.com.ar/MiNoticia",
"geo_enabled": true,
"screen_name": "DiarioElLitoral",
"listed_count": 101,
"friends_count": 2555,
"is_translator": false,
"notifications": null,
"statuses_count": 75795,
"default_profile": false,
"followers_count": 13296,
"favourites_count": 2806,
"profile_image_url": "http://pbs.twimg.com/profile_images/459898310422048768/yihQXide_normal.jpeg",
"profile_banner_url": "https://pbs.twimg.com/profile_banners/356914965/1398720521",
"profile_link_color": "0084B4",
"profile_text_color": "333333",
"follow_request_sent": null,
"contributors_enabled": false,
"default_profile_image": false,
"profile_background_tile": false,
"profile_image_url_https": "https://pbs.twimg.com/profile_images/459898310422048768/yihQXide_normal.jpeg",
"profile_background_color": "022330",
"profile_sidebar_fill_color": "C0DFEC",
"profile_background_image_url": "http://pbs.twimg.com/profile_background_images/459898079500447744/UEd_54-Q.jpeg",
"profile_sidebar_border_color": "FFFFFF",
"profile_use_background_image": true,
"profile_background_image_url_https": "https://pbs.twimg.com/profile_background_images/459898079500447744/UEd_54-Q.jpeg"
},
"place": null,
"id_str": "516602318150594560",
"source": "<a href=\"http://twitterfeed.com\" rel=\"nofollow\">twitterfeed</a>",
"entities": {
"urls": [
{
"url": "http://t.co/nkbKLXNRwY",
"indices": [
31,
53
],
"display_url": "litor.al/YGpqpl",
"expanded_url": "http://litor.al/YGpqpl"
}
],
"trends": [],
"symbols": [],
"hashtags": [],
"user_mentions": []
},
"favorited": false,
"retweeted": false,
"truncated": false,
"created_at": "Mon Sep 29 14:56:05 +0000 2014",
"coordinates": null,
"contributors": null,
"filter_level": "medium",
"timestamp_ms": "1412002565315",
"retweet_count": 0,
"favorite_count": 0,
"possibly_sensitive": false,
"in_reply_to_user_id": null,
"in_reply_to_status_id": null,
"in_reply_to_screen_name": null,
"in_reply_to_user_id_str": null,
"in_reply_to_status_id_str": null
}Record 5id: 516602361335533600 · geo: —
{
"id": 516602361335533600,
"geo": null,
"lang": "en",
"text": "RT @OpenNotion: Always great to see the growth of @opencorporates Doing the \"dirty\" work since 2011. #opendata in action! @CountCulture #PD…",
"user": {
"id": 45013,
"url": "http://techpresident.com/blogs/antonella-napolitano",
"lang": "it",
"name": "Antonella Napolitano",
"id_str": "45013",
"location": "Milano, Italy",
"verified": false,
"following": null,
"protected": false,
"time_zone": "Rome",
"created_at": "Wed Dec 06 10:07:42 +0000 2006",
"utc_offset": 7200,
"description": "@PdF_Europe Editor. Communications Director at @dirittodisapere.\r\nCoworker @coworkingcowo. \r\nStudying the impact of technology on society.",
"geo_enabled": true,
"screen_name": "svaroschi",
"listed_count": 270,
"friends_count": 3634,
"is_translator": false,
"notifications": null,
"statuses_count": 19223,
"default_profile": false,
"followers_count": 6276,
"favourites_count": 2326,
"profile_image_url": "http://pbs.twimg.com/profile_images/2629615568/e723ff7ed6f5e2875f0aeb5aa428a201_normal.jpeg",
"profile_banner_url": "https://pbs.twimg.com/profile_banners/45013/1404581710",
"profile_link_color": "0000FF",
"profile_text_color": "000000",
"follow_request_sent": null,
"contributors_enabled": false,
"default_profile_image": false,
"profile_background_tile": true,
"profile_image_url_https": "https://pbs.twimg.com/profile_images/2629615568/e723ff7ed6f5e2875f0aeb5aa428a201_normal.jpeg",
"profile_background_color": "9AE4E8",
"profile_sidebar_fill_color": "E0FF92",
"profile_background_image_url": "http://pbs.twimg.com/profile_background_images/485477251845083139/0EXoQ1UM.jpeg",
"profile_sidebar_border_color": "FFFFFF",
"profile_use_background_image": true,
"profile_background_image_url_https": "https://pbs.twimg.com/profile_background_images/485477251845083139/0EXoQ1UM.jpeg"
},
"place": null,
"id_str": "516602361335533568",
"source": "<a href=\"http://twitter.com/#!/download/ipad\" rel=\"nofollow\">Twitter for iPad</a>",
"entities": {
"urls": [],
"trends": [],
"symbols": [],
"hashtags": [
{
"text": "opendata",
"indices": [
101,
110
]
},
{
"text": "PDFItaly",
"indices": [
136,
140
]
}
],
"user_mentions": [
{
"id": 380516847,
"name": "the Sam S. Lee",
"id_str": "380516847",
"indices": [
3,
14
],
"screen_name": "OpenNotion"
},
{
"id": 216027858,
"name": "opencorporates",
"id_str": "216027858",
"indices": [
50,
65
],
"screen_name": "opencorporates"
},
{
"id": 54181373,
"name": "Chris Taggart",
"id_str": "54181373",
"indices": [
122,
135
],
"screen_name": "CountCulture"
}
]
},
"favorited": false,
"retweeted": false,
"truncated": false,
"created_at": "Mon Sep 29 14:56:15 +0000 2014",
"coordinates": null,
"contributors": null,
"filter_level": "medium",
"timestamp_ms": "1412002575629",
"retweet_count": 0,
"favorite_count": 0,
"retweeted_status": "[large value omitted]",
"possibly_sensitive": false,
"in_reply_to_user_id": null,
"in_reply_to_status_id": null,
"in_reply_to_screen_name": null,
"in_reply_to_user_id_str": null,
"in_reply_to_status_id_str": null
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Query examples
curl -s 'https://opendata.aragon.es//ckan/api/3/action/package_show?id=tweets-en-el-jacathon-2014-de-aragon-open-data' -H 'Accept: application/json'Full CKAN dataset record: resources, licence, organization, freshness.
Dataset
Volume & freshness
Coverage
- First published
- 2025-03-13
License
- ✓ Redistributable
- ✓ Attribution required
- Category: cc
Themes
Distributions (1)
Tweets en el Jacathon 2014 Aragón Open Data
https://opendata.aragon.es/datos/catalogo/dataset/d0c48395-9c58-4214-aa40-a443c62663de/recurso/73771542-4752-413c-8ccd-edfd1015fd10/descarga/jacathon-tweets.jsonSource: ckan · Open original page