Skip to content

Instantly share code, notes, and snippets.

@Salinger
Created May 12, 2015 06:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Salinger/ef39b81ad2c48516b596 to your computer and use it in GitHub Desktop.
Save Salinger/ef39b81ad2c48516b596 to your computer and use it in GitHub Desktop.
bq_tweet.json
[
{
"name": "log_time",
"type": "INTEGER"
},
{
"name": "created_at",
"type": "STRING"
},
{
"name": "id",
"type": "INTEGER"
},
{
"name": "id_str",
"type": "STRING"
},
{
"name": "text",
"type": "STRING"
},
{
"name": "source",
"type": "STRING"
},
{
"name": "truncated",
"type": "BOOLEAN"
},
{
"name": "in_reply_to_status_id",
"type": "INTEGER"
},
{
"name": "in_reply_to_status_id_str",
"type": "STRING"
},
{
"name": "in_reply_to_user_id",
"type": "INTEGER"
},
{
"name": "in_reply_to_user_id_str",
"type": "STRING"
},
{
"name": "in_reply_to_screen_name",
"type": "STRING"
},
{
"name": "user",
"type": "RECORD",
"fields": [
{
"name": "id",
"type": "INTEGER"
},
{
"name": "id_str",
"type": "STRING"
},
{
"name": "name",
"type": "STRING"
},
{
"name": "screen_name",
"type": "STRING"
},
{
"name": "location",
"type": "STRING"
},
{
"name": "url",
"type": "STRING"
},
{
"name": "description",
"type": "STRING"
},
{
"name": "protected",
"type": "BOOLEAN"
},
{
"name": "verified",
"type": "BOOLEAN"
},
{
"name": "followers_count",
"type": "INTEGER"
},
{
"name": "friends_count",
"type": "INTEGER"
},
{
"name": "listed_count",
"type": "INTEGER"
},
{
"name": "favourites_count",
"type": "INTEGER"
},
{
"name": "statuses_count",
"type": "INTEGER"
},
{
"name": "created_at",
"type": "STRING"
},
{
"name": "utc_offset",
"type": "INTEGER"
},
{
"name": "time_zone",
"type": "STRING"
},
{
"name": "geo_enabled",
"type": "BOOLEAN"
},
{
"name": "lang",
"type": "STRING"
},
{
"name": "contributors_enabled",
"type": "BOOLEAN"
},
{
"name": "is_translator",
"type": "BOOLEAN"
},
{
"name": "profile_background_color",
"type": "STRING"
},
{
"name": "profile_background_image_url",
"type": "STRING"
},
{
"name": "profile_background_image_url_https",
"type": "STRING"
},
{
"name": "profile_background_tile",
"type": "BOOLEAN"
},
{
"name": "profile_link_color",
"type": "STRING"
},
{
"name": "profile_sidebar_border_color",
"type": "STRING"
},
{
"name": "profile_sidebar_fill_color",
"type": "STRING"
},
{
"name": "profile_text_color",
"type": "STRING"
},
{
"name": "profile_use_background_image",
"type": "BOOLEAN"
},
{
"name": "profile_image_url_https",
"type": "STRING"
},
{
"name": "profile_banner_url",
"type": "STRING"
},
{
"name": "default_profile",
"type": "BOOLEAN"
},
{
"name": "default_profile_image",
"type": "BOOLEAN"
},
{
"name": "following",
"type": "BOOLEAN"
},
{
"name": "follow_request_sent",
"type": "BOOLEAN"
},
{
"name": "notifications",
"type": "BOOLEAN"
},
{
"name": "entities",
"type": "RECORD",
"fields": [
{
"name": "urls",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "url",
"type": "STRING"
},
{
"name": "expanded_url",
"type": "STRING"
},
{
"name": "indices",
"type": "INTEGER",
"mode": "REPEATED"
}
]
},
{
"name": "description",
"type": "RECORD",
"fields": [
{
"name": "urls",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "url",
"type": "STRING"
},
{
"name": "expanded_url",
"type": "STRING"
},
{
"name": "indices",
"type": "INTEGER",
"mode": "REPEATED"
}
]
}
]
}
]
}
]
},
{
"name": "geo",
"type": "STRING"
},
{
"name": "coordinates",
"type": "RECORD",
"fields": [
{
"name": "coordinates",
"type": "FLOAT",
"mode": "REPEATED"
},
{
"name": "type",
"type": "STRING"
}
]
},
{
"name": "place",
"type": "RECORD",
"fields": [
{
"name": "attributes",
"type": "RECORD",
"fields": [
{
"name": "street_adress",
"type": "STRING"
},
{
"name": "locality",
"type": "STRING"
},
{
"name": "region",
"type": "STRING"
},
{
"name": "iso3",
"type": "STRING"
},
{
"name": "postal_code",
"type": "STRING"
},
{
"name": "phone",
"type": "STRING"
},
{
"name": "twitter",
"type": "STRING"
},
{
"name": "url",
"type": "STRING"
}
]
},
{
"name": "bounding_box",
"type": "RECORD",
"fields": [
{
"name": "coordinates",
"mode": "REPEATED",
"type": "STRING"
},
{
"name": "type",
"type": "STRING"
}
]
},
{
"name": "country",
"type": "STRING"
},
{
"name": "country_code",
"type": "STRING"
},
{
"name": "full_name",
"type": "STRING"
},
{
"name": "id",
"type": "STRING"
},
{
"name": "name",
"type": "STRING"
},
{
"name": "place_type",
"type": "STRING"
},
{
"name": "url",
"type": "STRING"
}
]
},
{
"name": "contributors",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "id",
"type": "INTEGER"
},
{
"name": "id_str",
"type": "STRING"
},
{
"name": "screen_name",
"type": "STRING"
}
]
},
{
"name": "retweet_count",
"type": "INTEGER"
},
{
"name": "favorite_count",
"type": "INTEGER"
},
{
"name": "entities",
"type": "RECORD",
"fields": [
{
"name": "hashtags",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "indices",
"type": "INTEGER",
"mode": "REPEATED"
},
{
"name": "text",
"type": "STRING"
}
]
},
{
"name": "urls",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "display_url",
"type": "STRING"
},
{
"name": "expanded_url",
"type": "STRING"
},
{
"name": "indices",
"type": "INTEGER",
"mode": "REPEATED"
},
{
"name": "url",
"type": "STRING"
}
]
},
{
"name": "user_mentions",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "screen_name",
"type": "STRING"
},
{
"name": "name",
"type": "STRING"
},
{
"name": "id",
"type": "INTEGER"
},
{
"name": "id_str",
"type": "STRING"
},
{
"name": "indices",
"type": "INTEGER",
"mode": "REPEATED"
}
]
}
]
},
{
"name": "favorited",
"type": "BOOLEAN"
},
{
"name": "retweeted",
"type": "BOOLEAN"
},
{
"name": "possibly_sensitive",
"type": "BOOLEAN"
},
{
"name": "filter_level",
"type": "STRING"
},
{
"name": "lang",
"type": "STRING"
},
{
"name": "timestamp_ms",
"type": "STRING"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment