Custom SQL query

google_activity

id, created_at, updated_at, deleted_at, header, title, title_url, type, time

15 rows

google_activity_details

id, created_at, updated_at, deleted_at, action_id, name

8 rows

google_activity_location_infos

id, created_at, updated_at, deleted_at, action_id, name, url, source, source_url

3 rows

google_activity_path_points

id, created_at, updated_at, deleted_at, activity_segment_id, accuracy_meters, lat_e7, lng_e7, time

22 rows

google_activity_products

id, created_at, updated_at, deleted_at, name

25 rows

google_activity_products_assoc

action_id, product_id

15 rows

google_activity_segments

id, created_at, updated_at, deleted_at, activity_type, confidence, distance, duration_end_timestamp_ms, duration_start_timestamp_ms...

15 rows

google_activity_subtitles

id, created_at, updated_at, deleted_at, action_id, name, url

3 rows

google_activity_type_candidates

id, created_at, updated_at, deleted_at, activity_segment_id, activity_type, probability

225 rows

google_candidate_locations

id, created_at, updated_at, deleted_at, place_visit_id, latitude_e7, location_confidence, longitude_e7, place_id

9 rows

google_location_activity

id, created_at, updated_at, deleted_at, location_history_item_id, time

0 rows

google_location_activity_type_candidates

id, created_at, updated_at, deleted_at, location_activity_id, confidence, type

0 rows

google_location_history

id, created_at, updated_at, deleted_at, accuracy, altitude, heading, latitude_e7, longitude_e7...

50 rows

google_place_path_points

id, created_at, updated_at, deleted_at, place_visit_id, accuracy_meters, lat_e7, lng_e7, time

0 rows

google_place_visits

id, created_at, updated_at, deleted_at, center_lat_e7, center_lng_e7, duration_end_timestamp_ms, duration_start_timestamp_ms, edit_confirmation_status...

1 row

google_transit_stops

id, created_at, updated_at, deleted_at, activity_segment_id, latitude_e7, longitude_e7, name, place_id

16 rows

google_waypoints

id, created_at, updated_at, deleted_at, activity_segment_id, lat_e7, lng_e7

26 rows

health_activity_summaries

id, created_at, updated_at, deleted_at, date, active_energy_burned, active_energy_burned_goal, active_energy_burned_unit, apple_move_time...

15 rows

health_beats_per_minutes

id, created_at, updated_at, deleted_at, entry_id, bpm, time

112 rows

health_data_exports

id, created_at, updated_at, deleted_at, locale, export_date

1 row

health_devices

id, created_at, updated_at, deleted_at, name, manufacturer, model, hardware, software

30 rows

health_entries

id, created_at, updated_at, deleted_at, type, source_name, source_version, unit, creation_date...

72 rows

health_entry_metadata

id, created_at, updated_at, deleted_at, entry_id, key, value

18 rows

health_me_records

id, created_at, updated_at, deleted_at, data_export_id, date_of_birth, biological_sex, blood_type, fitzpatrick_skin_type...

1 row

health_metadata_entries

id, created_at, updated_at, deleted_at, parent_id, parent_type, key, value

0 rows

health_workout_events

id, created_at, updated_at, deleted_at, workout_id, type, date, duration, duration_unit

102 rows

health_workout_metadata

id, created_at, updated_at, deleted_at, workout_id, key, value

53 rows

health_workout_route_metadata

id, created_at, updated_at, deleted_at, workout_route_id, key, value

22 rows

health_workout_route_track_points

id, created_at, updated_at, deleted_at, workout_route_id, lon, lat, ele, time...

50 rows

health_workout_routes

id, created_at, updated_at, deleted_at, workout_id, source_name, source_version, creation_date, start_date...

11 rows

health_workouts

id, created_at, updated_at, deleted_at, activity_type, duration, duration_unit, total_distance, total_distance_unit...

15 rows

imports

id, created_at, updated_at, deleted_at, provider

57 rows

instagram_account_history

id, created_at, updated_at, deleted_at, action, cookie_name, ip_address, language_code, timestamp...

1 row

instagram_comment_hashtag_mentions

id, created_at, updated_at, deleted_at, comment_id, hashtag_id, from_idx, to_idx

0 rows

instagram_comment_user_mentions

id, created_at, updated_at, deleted_at, comment_id, user_id, from_idx, to_idx

4 rows

instagram_comments

id, created_at, updated_at, deleted_at, target, user_id, text, timestamp

5 rows

instagram_hashtags

id, created_at, updated_at, deleted_at, text

0 rows

instagram_likes

id, created_at, updated_at, deleted_at, target, user_id, timestamp

2 rows

instagram_media

id, created_at, updated_at, deleted_at, type, caption, taken_at, location, path

0 rows

instagram_media_hashtag_mentions

id, created_at, updated_at, deleted_at, media_id, hashtag_id, from_idx, to_idx

0 rows

instagram_media_user_mentions

id, created_at, updated_at, deleted_at, media_id, user_id, from_idx, to_idx

0 rows

instagram_profile_photos

id, created_at, updated_at, deleted_at, taken_at, is_active_profile, path

0 rows

instagram_registration_info

id, created_at, updated_at, deleted_at, registration_username, ip_address, registration_time, registration_email, registration_phone_number...

0 rows

instagram_stories_activities

id, created_at, updated_at, deleted_at, type, user_id, timestamp

0 rows

instagram_users

id, created_at, updated_at, deleted_at, username

2 rows

netflix_billing_history

id, created_at, updated_at, deleted_at, transaction_date, service_period_start_date, service_period_end_date, description, payment_type...

0 rows

netflix_clickstream

id, created_at, updated_at, deleted_at, profile_name, source, navigation_level, referrer_url, webpage_url...

15 rows

netflix_devices

id, created_at, updated_at, deleted_at, profile_name, esn, device_type, acct_first_playback_date, acct_last_playback_date...

0 rows

netflix_indicated_preferences

id, created_at, updated_at, deleted_at, profile_name, show, has_watched, is_interested, event_date

4 rows

netflix_interactive_titles

id, created_at, updated_at, deleted_at, profile_name, title_desc, selection_type, choice_segment_id, has_watched...

28 rows

netflix_ip_addresses

id, created_at, updated_at, deleted_at, esn, country, localized_device_description, device_description, ip...

0 rows

netflix_my_list

id, created_at, updated_at, deleted_at, profile_name, title_name, country, title_add_date

20 rows

netflix_playback_related_events

id, created_at, updated_at, deleted_at, profile_name, title_description, device, country, playback_start_time

15 rows

netflix_playtraces

id, created_at, updated_at, deleted_at, playback_related_event_id, event_type, session_offset_ms, media_offset_ms

179 rows

netflix_ratings

id, created_at, updated_at, deleted_at, profile_name, title_name, rating_type, star_value, thumbs_value...

8 rows

netflix_search_history

id, created_at, updated_at, deleted_at, profile_name, country_iso_code, device, is_kids, query_typed...

5 rows

netflix_subscription_history

id, created_at, updated_at, deleted_at, subscription_opened_time, is_free_trial, subscription_closed_time, is_customer_initiated_cancel, signup_plan_category...

4 rows

netflix_viewing_activity

id, created_at, updated_at, deleted_at, profile_name, start_time, duration, attributes, title...

15 rows

spotify_streaming_history

id, created_at, updated_at, deleted_at, end_time, artist_name, track_name, ms_played

15 rows

telegram_chats

id, created_at, updated_at, deleted_at, name, type

1 row

telegram_members

id, created_at, updated_at, deleted_at, message_id, name

0 rows

telegram_messages

id, created_at, updated_at, deleted_at, chat_id, action, actor, actor_id, address...

1 row

telegram_poll_answers

id, created_at, updated_at, deleted_at, message_id, chosen, text, voters

0 rows

telegram_text_attachments

id, created_at, updated_at, deleted_at, message_id, type, text, href

0 rows

twitter_accounts

id, created_at, updated_at, deleted_at, email, created_via, username, created, display_name

0 rows

twitter_ad_impressions

id, created_at, updated_at, deleted_at, device_info_id, display_location, promoted_tweet_id, advertiser_id, impression_time

4 rows

twitter_ad_impressions_matched_targeting_criteria

ad_impression_id, targeting_criterion_id

0 rows

twitter_advertisers

id, created_at, updated_at, deleted_at, name, lookalike

1 row

twitter_age_info_records

id, created_at, updated_at, deleted_at, age, birth_date

0 rows

twitter_audience_and_advertiser_records

id, created_at, updated_at, deleted_at, personalization_record_id, num_audiences

0 rows

twitter_audience_and_advertisers

audience_and_advertiser_record_id, advertiser_id

0 rows

twitter_audience_and_lookalike_advertisers

audience_and_advertiser_record_id, advertiser_id

0 rows

twitter_conversations

id, created_at, updated_at, deleted_at

0 rows

twitter_device_infos

id, created_at, updated_at, deleted_at, identifier, type, os_type

1 row

twitter_direct_message_reactions

id, created_at, updated_at, deleted_at, direct_message_id, sender_id, key, event_id, created

0 rows

twitter_direct_message_urls

direct_message_id, url_id

0 rows

twitter_direct_messages

id, created_at, updated_at, deleted_at, conversation_id, recipient_id, text, media_urls, sender_id...

0 rows

twitter_email_address_changes

id, created_at, updated_at, deleted_at, account_id, changed_at, changed_from, changed_to

0 rows

twitter_gender_info

id, created_at, updated_at, deleted_at, gender

1 row

twitter_hashtags

id, created_at, updated_at, deleted_at, text

11 rows

twitter_inferred_age_info_records

id, created_at, updated_at, deleted_at, personalization_record_id, age, birth_date

1 row

twitter_interest_records

id, created_at, updated_at, deleted_at, personalization_record_id, name, is_disabled

5 rows

twitter_language_records

id, created_at, updated_at, deleted_at, personalization_record_id, language, is_disabled

3 rows

twitter_likes

id, created_at, updated_at, deleted_at, tweet_id, full_text, expanded_url

2 rows

twitter_locations

id, created_at, updated_at, deleted_at, name

3 rows

twitter_login_ips

id, created_at, updated_at, deleted_at, account_id, ip, created

0 rows

twitter_personalization_locations

personalization_record_id, location_id

3 rows

twitter_personalization_records

id, created_at, updated_at, deleted_at, gender_info_id

1 row

twitter_personalization_shows

personalization_record_id, show_id

2 rows

twitter_screen_name_changes

id, created_at, updated_at, deleted_at, account_id, changed_at, changed_from, changed_to

1 row

twitter_shows

id, created_at, updated_at, deleted_at, name

2 rows

twitter_targeting_criteria

id, created_at, updated_at, deleted_at, targeting_type, targeting_value

20 rows

twitter_tweet_entities

id, created_at, updated_at, deleted_at, tweet_id

1 row

twitter_tweet_hashtags

id, created_at, updated_at, deleted_at, tweet_entities_id, hashtag_id, from_idx, to_idx

0 rows

twitter_tweet_media

id, created_at, updated_at, deleted_at, tweet_entities_id, expanded_url, from_idx, to_idx, url...

0 rows

twitter_tweet_urls

id, created_at, updated_at, deleted_at, tweet_entities_id, url_id, from_idx, to_idx

0 rows

twitter_tweet_user_mentions

id, created_at, updated_at, deleted_at, tweet_entities_id, user_id, from_idx, to_idx

0 rows

twitter_tweets

id, created_at, updated_at, deleted_at, author_id, retweeted, source, display_text_from_idx, display_text_to_idx...

1 row

twitter_urls

id, created_at, updated_at, deleted_at, url, expanded, display

0 rows

twitter_users

id, created_at, updated_at, deleted_at, name, screen_name

1 row

Download SQLite DB: db_public.db 1.3 MB