# Export Snake Case Twitter Data for Warehouses

**Use case:** 

Collect NASA posts in rich, flat, snake-case fields ready for data warehouses, SQL pipelines, Python analysis, and agent tools.

## Input

```json
{
  "mode": "legacy",
  "outputVariant": "rich",
  "fieldStyle": "snake_case",
  "outputPreset": "flat",
  "startUrls": [
    {
      "url": "https://x.com/elonmusk"
    },
    {
      "url": "https://x.com/search?q=AI"
    }
  ],
  "twitterHandles": [
    "elonmusk",
    "@nasa"
  ],
  "usernames": [
    "elonmusk",
    "@nasa"
  ],
  "listIds": [
    "1748648376080666720"
  ],
  "tweetIds": [
    "1846987139428634858"
  ],
  "twitterContent": "web scraping OR #datascience",
  "searchTerms": [
    "from:nasa moon"
  ],
  "maxItems": 100,
  "includeRaw": false,
  "includeArticles": false,
  "includeUnavailableFields": false,
  "includeOriginalTweet": false,
  "respectProfileSubpages": false,
  "includeSearchTerms": false,
  "queryType": "Latest",
  "lang": "en",
  "within": "10km",
  "geocode": "37.7749,-122.4194,10km",
  "filter:blue_verified": false,
  "filter:nativeretweets": false,
  "include:nativeretweets": false,
  "filter:replies": false,
  "filter:quote": false,
  "filter:has_engagement": false,
  "filter:media": false,
  "filter:twimg": false,
  "filter:images": false,
  "filter:videos": false,
  "filter:native_video": false,
  "filter:vine": false,
  "filter:consumer_video": false,
  "filter:pro_video": false,
  "filter:spaces": false,
  "filter:links": false,
  "filter:mentions": false,
  "filter:news": false,
  "filter:safe": false,
  "filter:hashtags": false,
  "min_retweets": 0,
  "min_faves": 0,
  "min_replies": 0,
  "-min_retweets": 0,
  "-min_faves": 0,
  "-min_replies": 0
}
```

## Output

```json
{
  "result_type": {
    "label": "Result Type (snake_case)",
    "format": "string"
  },
  "status": {
    "label": "Status",
    "format": "string"
  },
  "message": {
    "label": "Message",
    "format": "string"
  },
  "source_tweet_id": {
    "label": "Source Tweet ID (snake_case)",
    "format": "string"
  },
  "source_target": {
    "label": "Source Target (snake_case)",
    "format": "string"
  },
  "search_term": {
    "label": "Search Term (snake_case)",
    "format": "string"
  },
  "engagement_mode": {
    "label": "Engagement Mode (snake_case)",
    "format": "string"
  },
  "id": {
    "label": "Tweet ID",
    "format": "string"
  },
  "text": {
    "label": "Text",
    "format": "string"
  },
  "created_at": {
    "label": "Created At (snake_case)",
    "format": "string"
  },
  "lang": {
    "label": "Language",
    "format": "string"
  },
  "author_username": {
    "label": "Author Username (snake_case)",
    "format": "string"
  },
  "author": {
    "label": "Author",
    "format": "object"
  },
  "like_count": {
    "label": "Likes (snake_case)",
    "format": "integer"
  },
  "reply_count": {
    "label": "Replies (snake_case)",
    "format": "integer"
  },
  "retweet_count": {
    "label": "Retweets (snake_case)",
    "format": "integer"
  },
  "quote_count": {
    "label": "Quotes (snake_case)",
    "format": "integer"
  },
  "view_count": {
    "label": "Views (snake_case)",
    "format": "integer"
  },
  "bookmark_count": {
    "label": "Bookmarks (snake_case)",
    "format": "integer"
  },
  "media_urls": {
    "label": "Media URLs (snake_case)",
    "format": "array"
  },
  "url": {
    "label": "Tweet URL",
    "format": "string"
  }
}
```

## About this Actor

This example demonstrates how to use [X Tweet Scraper | $0.15/1K Tweets | Pay-Per Result](https://apify.com/xquik/x-tweet-scraper) with a specific input configuration. Visit the [Actor detail page](https://apify.com/xquik/x-tweet-scraper) to learn more, explore other use cases, and run it yourself.