twitter

Data source: swyx's twitter data

Tables

following

followed_id, follower_id, first_seen

0 rows

id, id_str, indices, media_url, media_url_https, url, display_url, expanded_url, type, sizes, video_info, additional_media_info, source_status_id, source_status_id_str, source_user_id, source_user_id_str

718 rows

media_tweets

media_id, tweets_id

742 rows

migrations

name, applied

1 row

places

id, url, place_type, name, full_name, country_code, country, contained_within, bounding_box, attributes

Many rows

since_id_types

id, name

4 rows

since_ids

type, key, since_id

1 row

sources

id, name, url

27 rows

tweets

id, user, created_at, full_text, retweeted_status, quoted_status, place, source, truncated, display_text_range, in_reply_to_status_id, in_reply_to_user_id, in_reply_to_screen_name, geo, coordinates, contributors, is_quote_status, retweet_count, favorite_count, favorited, retweeted, possibly_sensitive, lang, scopes

Many rows

users

id, screen_name, name, description, location, url, protected, followers_count, friends_count, listed_count, created_at, favourites_count, utc_offset, time_zone, geo_enabled, verified, statuses_count, lang, contributors_enabled, is_translator, is_translation_enabled, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_background_tile, profile_image_url, profile_image_url_https, profile_banner_url, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, has_extended_profile, default_profile, default_profile_image, following, follow_request_sent, notifications, translator_type, withheld_in_countries, suspended, needs_phone_verification

369 rows

... and 10 hidden tables