Skip to content

Instantly share code, notes, and snippets.

@IslamBesto
Last active August 29, 2015 14:12
Show Gist options
  • Save IslamBesto/f33b39fdd51149d0ec8f to your computer and use it in GitHub Desktop.
Save IslamBesto/f33b39fdd51149d0ec8f to your computer and use it in GitHub Desktop.
Tweet Object
{
"created_at":"Thu Dec 25 22:12:02 +0000 2014",
"entities":{
"hashtags":[
{
"text":"Messi",
"indices":[
0,
6
]
}
],
"urls":[
{
"display_url":"amp.twimg.com/v/14a1e1c1-694…",
"expanded_url":"https://amp.twimg.com/v/14a1e1c1-694c-4af5-9a16-50f46a961025",
"url":"https://t.co/UGd4QONIOI",
"indices":[
38,
61
]
}
],
"user_mentions":[
]
},
"favorite_count":681,
"id_str":"548239774838829056",
"user":{
"created_at":"Thu Jan 03 17:48:26 +0000 2013",
"url":"http://t.co/uiDdMl6hAy",
"description":"The official twitter account of Team Messi - a global fan movement founded by adidas to celebrate everything Messi.",
"entities":{
"description":{
"urls":[
]
},
"url":{
"urls":[
{
"display_url":"facebook.com/TeamMessi",
"expanded_url":"http://facebook.com/TeamMessi",
"url":"http://t.co/uiDdMl6hAy",
"indices":[
0,
22
]
}
]
}
},
"time_zone":"Casablanca",
"screen_name":"TeamMessi",
"profile_text_color":"333333",
"profile_sidebar_fill_color":"EFEFEF",
"profile_sidebar_border_color":"EEEEEE",
"id_str":"1058376110",
"profile_link_color":"009999",
"lang":"en",
"profile_image_url_https":"https://pbs.twimg.com/profile_images/537885861451276288/0OYX4Z65_normal.jpeg",
"location":"",
"name":"Team Messi",
"profile_background_color":"131516",
"profile_background_image_url":"http://abs.twimg.com/images/themes/theme14/bg.gif",
"profile_background_image_url_https":"https://abs.twimg.com/images/themes/theme14/bg.gif",
"profile_image_url":"http://pbs.twimg.com/profile_images/537885861451276288/0OYX4Z65_normal.jpeg",
"profile_banner_url":"https://pbs.twimg.com/profile_banners/1058376110/1417892485",
"id":1058376110,
"listed_count":1615,
"is_translator":false,
"profile_background_tile":true,
"geo_enabled":true,
"friends_count":63,
"profile_use_background_image":true,
"protected":false,
"followers_count":925033,
"show_all_inline_media":false,
"follow_request_sent":false,
"statuses_count":17123,
"favourites_count":753,
"default_profile_image":false,
"utc_offset":0,
"verified":true,
"default_profile":false,
"contributors_enabled":false
},
"text":"#Messi: ¡Feliz Navidad para todos! :)\nhttps://t.co/UGd4QONIOI",
"lang":"es",
"source":"\u003ca href\u003d\"http://twitter.com\" rel\u003d\"nofollow\"\u003eTwitter Web Client\u003c/a\u003e",
"retweeted":false,
"id":548239774838829056,
"in_reply_to_status_id":0,
"in_reply_to_user_id":0,
"truncated":false,
"possibly_sensitive":false,
"withheld_copyright":false,
"retweet_count":501,
"favorited":false
}
@tamsler
Copy link

tamsler commented Dec 27, 2014

What I usually do is to extract the information from JSON that I need to query on and then store the rest of the JSON as a string in the DB

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment