db_public
google_activity
id, created_at, updated_at, deleted_at, header, title, title_url, type, time
15 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_segments
id, created_at, updated_at, deleted_at, activity_type, confidence, distance, duration_end_timestamp_ms, duration_start_timestamp_ms...
15 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_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_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_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
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_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
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_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_audience_and_advertiser_records
id, created_at, updated_at, deleted_at, personalization_record_id, num_audiences
0 rows
twitter_direct_message_reactions
id, created_at, updated_at, deleted_at, direct_message_id, sender_id, key, event_id, created
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_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_screen_name_changes
id, created_at, updated_at, deleted_at, account_id, changed_at, changed_from, changed_to
1 row
twitter_targeting_criteria
id, created_at, updated_at, deleted_at, targeting_type, targeting_value
20 rows
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
Download SQLite DB: db_public.db 1.3 MB