Een export in NDJSON-formaat vanuit de Zeeschuimer-extensie voor een browser kan omgezet worden naar een tabel met:
select *
from ndjsontable
( passing file 'c:\temp\zeeschuimer-export-twitter.com-2025-10-09T125248.ndjson'
columns id int64 path 'id'
, nav_index varchar2 path 'nav_index'
, item_id varchar2 path 'item_id'
, timestamp_collected number path 'timestamp_collected'
, source_platform varchar2 path 'source_platform'
, source_platform_url varchar2 path 'source_platform_url'
, source_url varchar2 path 'source_url'
, user_agent varchar2 path 'user_agent'
, data_typename varchar2 path 'data.__typename'
, data_id varchar2 path 'data.id'
, data_views_count varchar2 path 'data.views.count'
, data_views_state varchar2 path 'data.views.state'
, data_promoted boolean path 'data.promoted'
, data_rest_id varchar2 path 'data.rest_id'
, data_post_video_description varchar2 path 'data.post_video_description'
, data_unmention_data_json varchar2 path 'data.unmention_data'
, data_is_translatable boolean path 'data.is_translatable'
, data_source varchar2 path 'data.source'
, data_edit_control_edits_remaining int32 path 'data.edit_control.edits_remaining'
, data_edit_control_is_edit_eligible boolean path 'data.edit_control.is_edit_eligible'
, data_edit_control_editable_until_msec varchar2 path 'data.edit_control.editable_until_msec'
, data_edit_tweet_ids1 varchar2 path 'data.edit_control.edit_tweet_ids[0]'
, data_quick_promote_eligibility varchar2 path 'data.quick_promote_eligibility.eligibility'
, data_grok_analysis_button boolean path 'data.grok_analysis_button'
, data_core_result_typename varchar2 path 'data.core.user_results.result.__typename'
, data_core_result_id varchar2 path 'data.core.user_results.result.id'
, data_core_result_rest_id varchar2 path 'data.core.user_results.result.rest_id'
, data_core_result_affiliates_highlighted_json varchar2 path 'data.core.user_results.result.affiliates_highlighted_label'
, data_core_result_avatar_image_url varchar2 path 'data.core.user_results.result.avatar.image_url'
, data_core_result_core_created_at_c varchar2 path 'data.core.user_results.result.core.created_at'
, data_core_result_core_name varchar2 path 'data.core.user_results.result.core.name'
, data_core_result_core_screen_name varchar2 path 'data.core.user_results.result.core.screen_name'
, data_core_result_dm_permissions_can_dm boolean path 'data.core.user_results.result.dm_permissions.can_dm'
, data_core_result_dm_permissions_can_dm_on_xchat boolean path 'data.core.user_results.result.dm_permissions.can_dm_on_xchat'
, data_core_result_has_graduated_access boolean path 'data.core.user_results.result.has_graduated_access'
, data_core_result_is_blue_verified boolean path 'data.core.user_results.result.is_blue_verified'
, data_core_result_legacy_default_profile boolean path 'data.core.user_results.result.legacy.default_profile'
, data_core_result_legacy_default_profile_image boolean path 'data.core.user_results.result.legacy.default_profile_image'
, data_core_result_legacy_description varchar2 path 'data.core.user_results.result.legacy.description'
, data_core_result_legacy_description_url1 varchar2 path 'data.core.user_results.result.legacy.entities.description.urls[0]'
, data_core_result_legacy_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].url'
, data_core_result_legacy_display_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].display_url'
, data_core_result_legacy_expanded_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].expanded_url'
, data_core_result_legacy_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].url'
, data_core_result_legacy_fast_followers_count int64 path 'data.core.user_results.result.legacy.fast_followers_count'
, data_core_result_legacy_favourites_count int64 path 'data.core.user_results.result.legacy.favourites_count'
, data_core_result_legacy_followers_count int64 path 'data.core.user_results.result.legacy.followers_count'
, data_core_result_legacy_friends_count int64 path 'data.core.user_results.result.legacy.friends_count'
, data_core_result_legacy_custom_timelines varchar2 path 'data.core.user_results.result.legacy.has_custom_timelines'
, data_core_result_legacy_is_translator varchar2 path 'data.core.user_results.result.legacy.is_translator'
, data_core_result_legacy_listed_count int64 path 'data.core.user_results.result.legacy.listed_count'
, data_core_result_legacy_media_count int64 path 'data.core.user_results.result.legacy.media_count'
, data_core_result_legacy_normal_followers_count int64 path 'data.core.user_results.result.legacy.normal_followers_count'
, data_core_result_legacy_possibly_sensitive varchar2 path 'data.core.user_results.result.legacy.possibly_sensitive'
, data_core_result_legacy_profile_banner_url varchar2 path 'data.core.user_results.result.legacy.profile_banner_url'
, data_core_result_legacy_profile_interstitial_type varchar2 path 'data.core.user_results.result.legacy.profile_interstitial_type'
, data_core_result_legacy_pinned_tweet_id1 int64 path 'data.core.user_results.result.legacy.pinned_tweet_ids_str[0]'
, data_core_result_legacy_pinned_tweet_id2 int64 path 'data.core.user_results.result.legacy.pinned_tweet_ids_str[1]'
, data_core_result_legacy_pinned_tweet_id3 int64 path 'data.core.user_results.result.legacy.pinned_tweet_ids_str[2]'
, data_core_result_legacy_statuses_count int64 path 'data.core.user_results.result.legacy.statuses_count'
, data_core_result_legacy_translator_type varchar2 path 'data.core.user_results.result.legacy.translator_type'
, data_core_result_legacy_url varchar2 path 'data.core.user_results.result.legacy.url'
, data_core_result_legacy_want_retweets varchar2 path 'data.core.user_results.result.legacy.want_retweets'
, data_core_result_legacy_withheld_country1 varchar2 path 'data.core.user_results.result.legacy.withheld_in_countries[0]'
, data_core_result_legacy_withheld_country2 varchar2 path 'data.core.user_results.result.legacy.withheld_in_countries[1]'
, data_core_result_legacy_withheld_country3 varchar2 path 'data.core.user_results.result.legacy.withheld_in_countries[2]'
, data_core_result_location varchar2 path 'data.core.user_results.result.location.location'
, data_core_result_can_media_tag varchar2 path 'data.core.user_results.result.media_permissions.can_media_tag'
, data_core_result_parody_commentary_fan_label varchar2 path 'data.core.user_results.result.parody_commentary_fan_label'
, data_core_result_profile_image_shape varchar2 path 'data.core.user_results.result.profile_image_shape'
, data_core_result_privacy_protected varchar2 path 'data.core.user_results.result.privacy.protected'
, data_core_result_relationship_perspectives_fllwng varchar2 path 'data.core.user_results.result.relationship_perspectives.following'
, data_core_result_tipjar_settings_json varchar2 path 'data.core.user_results.result.tipjar_settings'
, data_core_result_verified varchar2 path 'data.core.user_results.result.verification.verified'
, data_legacy_bookmark_count int64 path 'data.legacy.bookmark_count'
, data_legacy_bookmarked boolean path 'data.legacy.bookmarked'
, data_legacy_display_text_range1 int64 path 'data.legacy.display_text_range[0]'
, data_legacy_display_text_range2 int64 path 'data.legacy.display_text_range[1]'
, data_legacy_created_at varchar2 path 'data.legacy.created_at'
, data_legacy_conversation_id_str varchar2 path 'data.legacy.conversation_id_str'
, data_legacy_id_str varchar2 path 'data.legacy.id_str'
, data_legacy_user_id_str varchar2 path 'data.legacy.user_id_str'
, data_legacy_retweeted varchar2 path 'data.legacy.retweeted'
, data_legacy_retweet_count int64 path 'data.legacy.retweet_count'
, data_legacy_reply_count int64 path 'data.legacy.reply_count'
, data_legacy_quote_count int64 path 'data.legacy.quote_count'
, data_legacy_possible_sensitive_editable varchar2 path 'data.legacy.possibly_sensitive_editable'
, data_legacy_possibly_sensitive varchar2 path 'data.legacy.possibly_sensitive'
, data_legacy_lang varchar2 path 'data.legacy.lang'
, data_legacy_is_quote_status boolean path 'data.legacy.is_quote_status'
, data_legacy_full_text varchar2 path 'data.legacy.full_text'
, data_legacy_favorited varchar2 path 'data.legacy.favorited'
, data_legacy_favorite_count int64 path 'data.legacy.favorite_count'
, data_legacy_entities_hashtags_json varchar2 path 'data.legacy.entities.hashtags'
, data_legacy_entities_symbols_json varchar2 path 'data.legacy.entities.symbols'
, data_legacy_entities_timestamps_json varchar2 path 'data.legacy.entities.timestamps'
, data_legacy_entities_urls_json varchar2 path 'data.legacy.entities.urls'
, data_legacy_entities_mention_user1_id varchar2 path 'data.legacy.entities.user_mentions[0].id_str'
, data_legacy_entities_mention_user1_name varchar2 path 'data.legacy.entities.user_mentions[0].name'
, data_legacy_entities_mention_user1_screen_name varchar2 path 'data.legacy.entities.user_mentions[0].screen_name'
, data_legacy_entities_mention_user2_id varchar2 path 'data.legacy.entities.user_mentions[1].id_str'
, data_legacy_entities_mention_user2_name varchar2 path 'data.legacy.entities.user_mentions[1].name'
, data_legacy_entities_mention_user2_screen_name varchar2 path 'data.legacy.entities.user_mentions[1].screen_name'
, data_legacy_entities_mention_user3_id varchar2 path 'data.legacy.entities.user_mentions[2].id_str'
, data_legacy_entities_mention_user3_name varchar2 path 'data.legacy.entities.user_mentions[2].name'
, data_legacy_entities_mention_user3_screen_name varchar2 path 'data.legacy.entities.user_mentions[2].screen_name'
, data_core_result_typename varchar2 path 'data.core.user_results.result.__typename'
, data_core_result_id varchar2 path 'data.core.user_results.result.id'
, data_core_result_rest_id varchar2 path 'data.core.user_results.result.rest_id'
, data_core_result_affiliates_highlighted_json varchar2 path 'data.core.user_results.result.affiliates_highlighted_label'
, data_core_result_avatar_image_url varchar2 path 'data.core.user_results.result.avatar.image_url'
, data_core_result_core_created_at_c varchar2 path 'data.core.user_results.result.core.created_at'
, data_core_result_core_name varchar2 path 'data.core.user_results.result.core.name'
, data_core_result_core_screen_name varchar2 path 'data.core.user_results.result.core.screen_name'
, data_core_result_dm_permissions_can_dm boolean path 'data.core.user_results.result.dm_permissions.can_dm'
, data_core_result_dm_permissions_can_dm_on_xchat boolean path 'data.core.user_results.result.dm_permissions.can_dm_on_xchat'
, data_core_result_has_graduated_access boolean path 'data.core.user_results.result.has_graduated_access'
, data_core_result_is_blue_verified boolean path 'data.core.user_results.result.is_blue_verified'
, data_core_result_legacy_default_profile boolean path 'data.core.user_results.result.legacy.default_profile'
, data_core_result_legacy_default_profile_image boolean path 'data.core.user_results.result.legacy.default_profile_image'
, data_core_result_legacy_description varchar2 path 'data.core.user_results.result.legacy.description'
, data_core_result_legacy_description_url1 varchar2 path 'data.core.user_results.result.legacy.entities.description.urls[0]'
, data_core_result_legacy_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].url'
, data_core_result_legacy_display_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].display_url'
, data_core_result_legacy_expanded_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].expanded_url'
, data_core_result_legacy_url1 varchar2 path 'data.core.user_results.result.legacy.entities.url.urls[0].url'
, data_core_result_legacy_fast_followers_count int64 path 'data.core.user_results.result.legacy.fast_followers_count'
, data_core_result_legacy_favourites_count int64 path 'data.core.user_results.result.legacy.favourites_count'
, data_core_result_legacy_followers_count int64 path 'data.core.user_results.result.legacy.followers_count'
, data_core_result_legacy_friends_count int64 path 'data.core.user_results.result.legacy.friends_count'
, data_core_result_legacy_custom_timelines varchar2 path 'data.core.user_results.result.legacy.has_custom_timelines'
, data_core_result_legacy_is_translator varchar2 path 'data.core.user_results.result.legacy.is_translator'
, data_core_result_legacy_listed_count int64 path 'data.core.user_results.result.legacy.listed_count'
, data_core_result_legacy_media_count int64 path 'data.core.user_results.result.legacy.media_count'
, data_core_result_legacy_normal_followers_count int64 path 'data.core.user_results.result.legacy.normal_followers_count'
, data_core_result_legacy_possibly_sensitive varchar2 path 'data.core.user_results.result.legacy.possibly_sensitive'
, data_core_result_legacy_profile_banner_url varchar2 path 'data.core.user_results.result.legacy.profile_banner_url'
, data_core_result_legacy_profile_interstitial_type varchar2 path 'data.core.user_results.result.legacy.profile_interstitial_type'
, data_core_result_legacy_pinned_tweet_id1 int64 path 'data.core.user_results.result.legacy.pinned_tweet_ids_str[0]'
, data_core_result_legacy_pinned_tweet_id2 int64 path 'data.core.user_results.result.legacy.pinned_tweet_ids_str[1]'
, data_core_result_legacy_pinned_tweet_id3 int64 path 'data.core.user_results.result.legacy.pinned_tweet_ids_str[2]'
, data_legacy_retweet_typename varchar2 path 'data.legacy.retweeted_status_result.result.__typename'
, data_legacy_retweet_rest_id varchar2 path 'data.legacy.retweeted_status_result.result.rest_id'
, data_legacy_retweet_source varchar2 path 'data.legacy.retweeted_status_result.result.source'
, data_legacy_retweet_grok_analysis_button varchar2 path 'data.legacy.retweeted_status_result.result.grok_analysis_button'
, data_legacy_retweet_is_translatable varchar2 path 'data.legacy.retweeted_status_result.result.is_translatable'
, data_legacy_retweet_views_count int64 path 'data.legacy.retweeted_status_result.result.views.count'
, data_legacy_retweet_views_state varchar2 path 'data.legacy.retweeted_status_result.result.views.state'
, data_legacy_retweet_note_is_expandable varchar2 path 'data.legacy.retweeted_status_result.result.note_tweet.is_expandable'
, data_legacy_retweet_note_id varchar2 path 'data.legacy.retweeted_status_result.result.note_tweet.note_tweet_results.result.id'
, data_legacy_retweet_note_text varchar2 path 'data.legacy.retweeted_status_result.result.note_tweet.note_tweet_results.result.text'
, data_legacy_retweet_bookmark_count int64 path 'data.legacy.retweeted_status_result.result.legacy.bookmark_count'
, data_legacy_retweet_bookmarked boolean path 'data.legacy.retweeted_status_result.result.legacy.bookmarked'
, data_legacy_retweet_display_text_range1 int64 path 'data.legacy.retweeted_status_result.result.legacy.display_text_range[0]'
, data_legacy_retweet_display_text_range2 int64 path 'data.legacy.retweeted_status_result.result.legacy.display_text_range[1]'
, data_legacy_retweet_created_at varchar2 path 'data.legacy.retweeted_status_result.result.legacy.created_at'
, data_legacy_retweet_conversation_id_str varchar2 path 'data.legacy.retweeted_status_result.result.legacy.conversation_id_str'
, data_legacy_retweet_id_str varchar2 path 'data.legacy.retweeted_status_result.result.legacy.id_str'
, data_legacy_retweet_user_id_str varchar2 path 'data.legacy.retweeted_status_result.result.legacy.user_id_str'
, data_legacy_retweet_retweeted varchar2 path 'data.legacy.retweeted_status_result.result.legacy.retweeted'
, data_legacy_retweet_retweet_count int64 path 'data.legacy.retweeted_status_result.result.legacy.retweet_count'
, data_legacy_retweet_reply_count int64 path 'data.legacy.retweeted_status_result.result.legacy.reply_count'
, data_legacy_retweet_quote_count int64 path 'data.legacy.retweeted_status_result.result.legacy.quote_count'
, data_legacy_retweet_possible_sensitive_editable varchar2 path 'data.legacy.retweeted_status_result.result.legacy.possibly_sensitive_editable'
, data_legacy_retweet_possibly_sensitive varchar2 path 'data.legacy.retweeted_status_result.result.legacy.possibly_sensitive'
, data_legacy_retweet_lang varchar2 path 'data.legacy.retweeted_status_result.result.legacy.lang'
, data_legacy_retweet_is_quote_status boolean path 'data.legacy.retweeted_status_result.result.legacy.is_quote_status'
, data_legacy_retweet_full_text varchar2 path 'data.legacy.retweeted_status_result.result.legacy.full_text'
, data_legacy_retweet_favorited varchar2 path 'data.legacy.retweeted_status_result.result.legacy.favorited'
, data_legacy_retweet_favorite_count int64 path 'data.legacy.retweeted_status_result.result.legacy.favorite_count'
, data_legacy_retweet_entities_hashtags_json varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.hashtags'
, data_legacy_retweet_entities_symbols_json varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.symbols'
, data_legacy_retweet_entities_timestamps_json varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.timestamps'
, data_legacy_retweet_entities_urls_json varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.urls'
, data_legacy_retweet_entities_mention_user1_id varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[0].id_str'
, data_legacy_retweet_entities_mention_user1_name varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[0].name'
, data_legacy_retweet_entities_mention_user1_screen_name varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[0].screen_name'
, data_legacy_retweet_entities_mention_user2_id varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[1].id_str'
, data_legacy_retweet_entities_mention_user2_name varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[1].name'
, data_legacy_retweet_entities_mention_user2_screen_name varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[1].screen_name'
, data_legacy_retweet_entities_mention_user3_id varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[2].id_str'
, data_legacy_retweet_entities_mention_user3_name varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[2].name'
, data_legacy_retweet_entities_mention_user3_screen_name varchar2 path 'data.legacy.retweeted_status_result.result.legacy.entities.user_mentions[2].screen_name'
)
Voeg for csv toe om er een CSV van te maken.
Let op: sommige velden kunnen regelovergangen bevatten. In de CSV-representatie komt dat er uit als:
"regel 1
regel 2
regel 3
"
Een CSV-parser moet hiermee om kunnen gaan zoals beschreven in RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) Files sectie 2, regel 6 en 7.