sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_joined

fields: - mode: NULLABLE name: submission_date type: DATE - mode: NULLABLE name: sample_id type: INTEGER - mode: NULLABLE name: client_id type: STRING - mode: NULLABLE name: first_seen_date type: DATE - mode: NULLABLE name: second_seen_date type: DATE - mode: NULLABLE name: days_seen_bits type: INTEGER - mode: NULLABLE name: days_visited_1_uri_bits type: INTEGER - mode: NULLABLE name: days_visited_5_uri_bits type: INTEGER - mode: NULLABLE name: days_visited_10_uri_bits type: INTEGER - mode: NULLABLE name: days_had_8_active_ticks_bits type: INTEGER - mode: NULLABLE name: days_opened_dev_tools_bits type: INTEGER - mode: NULLABLE name: days_interacted_bits type: INTEGER - mode: NULLABLE name: days_visited_1_uri_normal_mode_bits type: INTEGER - mode: NULLABLE name: days_visited_1_uri_private_mode_bits type: INTEGER - mode: NULLABLE name: days_created_profile_bits type: INTEGER - fields: - mode: NULLABLE name: experiment type: STRING - mode: NULLABLE name: branch type: STRING - mode: NULLABLE name: bits type: INTEGER mode: REPEATED name: days_seen_in_experiment type: RECORD - mode: NULLABLE name: aborts_content_sum type: INTEGER - mode: NULLABLE name: aborts_gmplugin_sum type: INTEGER - mode: NULLABLE name: aborts_plugin_sum type: INTEGER - mode: NULLABLE name: active_addons_count_mean type: FLOAT - fields: - mode: NULLABLE name: addon_id type: STRING - mode: NULLABLE name: blocklisted type: BOOLEAN - mode: NULLABLE name: name type: STRING - mode: NULLABLE name: user_disabled type: BOOLEAN - mode: NULLABLE name: app_disabled type: BOOLEAN - mode: NULLABLE name: version type: STRING - mode: NULLABLE name: scope type: INTEGER - mode: NULLABLE name: type type: STRING - mode: NULLABLE name: foreign_install type: BOOLEAN - mode: NULLABLE name: has_binary_components type: BOOLEAN - mode: NULLABLE name: install_day type: INTEGER - mode: NULLABLE name: update_day type: INTEGER - mode: NULLABLE name: signed_state type: INTEGER - mode: NULLABLE name: is_system type: BOOLEAN - mode: NULLABLE name: is_web_extension type: BOOLEAN - mode: NULLABLE name: multiprocess_compatible type: BOOLEAN mode: REPEATED name: active_addons type: RECORD - mode: NULLABLE name: active_experiment_branch type: STRING - mode: NULLABLE name: active_experiment_id type: STRING - mode: NULLABLE name: active_hours_sum type: FLOAT - mode: NULLABLE name: addon_compatibility_check_enabled type: BOOLEAN - mode: NULLABLE name: app_build_id type: STRING - mode: NULLABLE name: app_display_version type: STRING - mode: NULLABLE name: app_name type: STRING - mode: NULLABLE name: app_version type: STRING - fields: - mode: NULLABLE name: source type: STRING - mode: NULLABLE name: medium type: STRING - mode: NULLABLE name: campaign type: STRING - mode: NULLABLE name: content type: STRING - mode: NULLABLE name: experiment type: STRING - mode: NULLABLE name: variation type: STRING - mode: NULLABLE name: dltoken type: STRING - mode: NULLABLE name: dlsource type: STRING - mode: NULLABLE name: ua type: STRING mode: NULLABLE name: attribution type: RECORD - mode: NULLABLE name: blocklist_enabled type: BOOLEAN - mode: NULLABLE name: channel type: STRING - mode: NULLABLE name: client_clock_skew_mean type: FLOAT - mode: NULLABLE name: client_submission_latency_mean type: FLOAT - mode: NULLABLE name: cpu_cores type: INTEGER - mode: NULLABLE name: cpu_count type: INTEGER - mode: NULLABLE name: cpu_family type: INTEGER - mode: NULLABLE name: cpu_l2_cache_kb type: INTEGER - mode: NULLABLE name: cpu_l3_cache_kb type: INTEGER - mode: NULLABLE name: cpu_model type: INTEGER - mode: NULLABLE name: cpu_speed_mhz type: INTEGER - mode: NULLABLE name: cpu_stepping type: INTEGER - mode: NULLABLE name: cpu_vendor type: STRING - mode: NULLABLE name: crashes_detected_content_sum type: INTEGER - mode: NULLABLE name: crashes_detected_gmplugin_sum type: INTEGER - mode: NULLABLE name: crashes_detected_plugin_sum type: INTEGER - mode: NULLABLE name: crash_submit_attempt_content_sum type: INTEGER - mode: NULLABLE name: crash_submit_attempt_main_sum type: INTEGER - mode: NULLABLE name: crash_submit_attempt_plugin_sum type: INTEGER - mode: NULLABLE name: crash_submit_success_content_sum type: INTEGER - mode: NULLABLE name: crash_submit_success_main_sum type: INTEGER - mode: NULLABLE name: crash_submit_success_plugin_sum type: INTEGER - mode: NULLABLE name: default_search_engine type: STRING - mode: NULLABLE name: default_search_engine_data_load_path type: STRING - mode: NULLABLE name: default_search_engine_data_name type: STRING - mode: NULLABLE name: default_search_engine_data_origin type: STRING - mode: NULLABLE name: default_search_engine_data_submission_url type: STRING - mode: NULLABLE name: devtools_toolbox_opened_count_sum type: INTEGER - mode: NULLABLE name: distribution_id type: STRING - mode: NULLABLE name: e10s_enabled type: BOOLEAN - mode: NULLABLE name: env_build_arch type: STRING - mode: NULLABLE name: env_build_id type: STRING - mode: NULLABLE name: env_build_version type: STRING - mode: REPEATED name: environment_settings_intl_accept_languages type: STRING - mode: REPEATED name: environment_settings_intl_app_locales type: STRING - mode: REPEATED name: environment_settings_intl_available_locales type: STRING - mode: REPEATED name: environment_settings_intl_requested_locales type: STRING - mode: REPEATED name: environment_settings_intl_system_locales type: STRING - mode: REPEATED name: environment_settings_intl_regional_prefs_locales type: STRING - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: STRING mode: REPEATED name: experiments type: RECORD - mode: NULLABLE name: first_paint_mean type: FLOAT - mode: NULLABLE name: flash_version type: STRING - mode: NULLABLE name: country type: STRING - mode: NULLABLE name: city type: STRING - mode: NULLABLE name: geo_subdivision1 type: STRING - mode: NULLABLE name: geo_subdivision2 type: STRING - mode: NULLABLE name: isp_name type: STRING - mode: NULLABLE name: isp_organization type: STRING - mode: NULLABLE name: gfx_features_advanced_layers_status type: STRING - mode: NULLABLE name: gfx_features_d2d_status type: STRING - mode: NULLABLE name: gfx_features_d3d11_status type: STRING - mode: NULLABLE name: gfx_features_gpu_process_status type: STRING - mode: NULLABLE name: histogram_parent_devtools_aboutdebugging_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_animationinspector_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_browserconsole_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_canvasdebugger_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_computedview_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_custom_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_developertoolbar_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_dom_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_eyedropper_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_fontinspector_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_inspector_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_jsbrowserdebugger_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_jsdebugger_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_jsprofiler_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_layoutview_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_memory_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_menu_eyedropper_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_netmonitor_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_options_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_paintflashing_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_picker_eyedropper_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_responsive_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_ruleview_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_scratchpad_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_scratchpad_window_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_shadereditor_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_storage_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_styleeditor_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_webaudioeditor_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_webconsole_opened_count_sum type: INTEGER - mode: NULLABLE name: histogram_parent_devtools_webide_opened_count_sum type: INTEGER - mode: NULLABLE name: install_year type: INTEGER - mode: NULLABLE name: is_default_browser type: BOOLEAN - mode: NULLABLE name: is_wow64 type: BOOLEAN - mode: NULLABLE name: locale type: STRING - mode: NULLABLE name: memory_mb type: INTEGER - mode: NULLABLE name: normalized_channel type: STRING - mode: NULLABLE name: normalized_os_version type: STRING - mode: NULLABLE name: os type: STRING - mode: NULLABLE name: os_service_pack_major type: INTEGER - mode: NULLABLE name: os_service_pack_minor type: INTEGER - mode: NULLABLE name: os_version type: STRING - mode: NULLABLE name: pings_aggregated_by_this_row type: INTEGER - mode: NULLABLE name: places_bookmarks_count_mean type: FLOAT - mode: NULLABLE name: places_pages_count_mean type: FLOAT - mode: NULLABLE name: plugin_hangs_sum type: INTEGER - mode: NULLABLE name: plugins_infobar_allow_sum type: INTEGER - mode: NULLABLE name: plugins_infobar_block_sum type: INTEGER - mode: NULLABLE name: plugins_infobar_shown_sum type: INTEGER - mode: NULLABLE name: plugins_notification_shown_sum type: INTEGER - mode: NULLABLE name: previous_build_id type: STRING - mode: NULLABLE name: profile_age_in_days type: INTEGER - mode: NULLABLE name: profile_creation_date type: STRING - mode: NULLABLE name: push_api_notify_sum type: INTEGER - mode: NULLABLE name: sandbox_effective_content_process_level type: INTEGER - mode: NULLABLE name: scalar_combined_webrtc_nicer_stun_retransmits_sum type: INTEGER - mode: NULLABLE name: scalar_combined_webrtc_nicer_turn_401s_sum type: INTEGER - mode: NULLABLE name: scalar_combined_webrtc_nicer_turn_403s_sum type: INTEGER - mode: NULLABLE name: scalar_combined_webrtc_nicer_turn_438s_sum type: INTEGER - mode: NULLABLE name: scalar_content_navigator_storage_estimate_count_sum type: INTEGER - mode: NULLABLE name: scalar_content_navigator_storage_persist_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_aushelper_websense_reg_version type: STRING - mode: NULLABLE name: scalar_parent_browser_engagement_max_concurrent_tab_count_max type: INTEGER - mode: NULLABLE name: scalar_parent_browser_engagement_max_concurrent_window_count_max type: INTEGER - mode: NULLABLE name: scalar_parent_browser_engagement_tab_open_event_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_browser_engagement_total_uri_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_browser_engagement_unfiltered_uri_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_browser_engagement_unique_domains_count_max type: INTEGER - mode: NULLABLE name: scalar_parent_browser_engagement_unique_domains_count_mean type: FLOAT - mode: NULLABLE name: scalar_parent_browser_engagement_window_open_event_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_devtools_accessibility_node_inspected_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_devtools_accessibility_opened_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_devtools_accessibility_picker_used_count_sum type: INTEGER - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_devtools_accessibility_select_accessible_for_node_sum type: RECORD - mode: NULLABLE name: scalar_parent_devtools_accessibility_service_enabled_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_devtools_copy_full_css_selector_opened_sum type: INTEGER - mode: NULLABLE name: scalar_parent_devtools_copy_unique_css_selector_opened_sum type: INTEGER - mode: NULLABLE name: scalar_parent_devtools_toolbar_eyedropper_opened_sum type: INTEGER - mode: NULLABLE name: scalar_parent_dom_contentprocess_troubled_due_to_memory_sum type: INTEGER - mode: NULLABLE name: scalar_parent_navigator_storage_estimate_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_navigator_storage_persist_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_storage_sync_api_usage_extensions_using_sum type: INTEGER - mode: NULLABLE name: search_cohort type: STRING - mode: NULLABLE name: search_count_abouthome type: INTEGER - mode: NULLABLE name: search_count_contextmenu type: INTEGER - mode: NULLABLE name: search_count_newtab type: INTEGER - mode: NULLABLE name: search_count_searchbar type: INTEGER - mode: NULLABLE name: search_count_system type: INTEGER - mode: NULLABLE name: search_count_urlbar type: INTEGER - mode: NULLABLE name: search_count_all type: INTEGER - mode: NULLABLE name: search_count_tagged_sap type: INTEGER - mode: NULLABLE name: search_count_tagged_follow_on type: INTEGER - mode: NULLABLE name: search_count_organic type: INTEGER - mode: NULLABLE name: search_count_urlbar_handoff type: INTEGER - mode: NULLABLE name: search_count_urlbar_persisted type: INTEGER - mode: NULLABLE name: session_restored_mean type: FLOAT - mode: NULLABLE name: sessions_started_on_this_day type: INTEGER - mode: NULLABLE name: shutdown_kill_sum type: INTEGER - mode: NULLABLE name: subsession_hours_sum type: NUMERIC - mode: NULLABLE name: ssl_handshake_result_failure_sum type: INTEGER - mode: NULLABLE name: ssl_handshake_result_success_sum type: INTEGER - mode: NULLABLE name: sync_configured type: BOOLEAN - mode: NULLABLE name: sync_count_desktop_mean type: FLOAT - mode: NULLABLE name: sync_count_mobile_mean type: FLOAT - mode: NULLABLE name: sync_count_desktop_sum type: INTEGER - mode: NULLABLE name: sync_count_mobile_sum type: INTEGER - mode: NULLABLE name: telemetry_enabled type: BOOLEAN - mode: NULLABLE name: timezone_offset type: INTEGER - mode: NULLABLE name: total_hours_sum type: NUMERIC - mode: NULLABLE name: update_auto_download type: BOOLEAN - mode: NULLABLE name: update_channel type: STRING - mode: NULLABLE name: update_enabled type: BOOLEAN - mode: NULLABLE name: vendor type: STRING - mode: NULLABLE name: web_notification_shown_sum type: INTEGER - mode: NULLABLE name: windows_build_number type: INTEGER - mode: NULLABLE name: windows_ubr type: INTEGER - mode: NULLABLE name: fxa_configured type: BOOLEAN - mode: NULLABLE name: trackers_blocked_sum type: INTEGER - mode: NULLABLE name: submission_timestamp_min type: TIMESTAMP - mode: NULLABLE name: ad_clicks_count_all type: INTEGER - mode: NULLABLE name: search_with_ads_count_all type: INTEGER - mode: NULLABLE name: scalar_parent_urlbar_impression_autofill_about_sum type: INTEGER - mode: NULLABLE name: scalar_parent_urlbar_impression_autofill_adaptive_sum type: INTEGER - mode: NULLABLE name: scalar_parent_urlbar_impression_autofill_origin_sum type: INTEGER - mode: NULLABLE name: scalar_parent_urlbar_impression_autofill_other_sum type: INTEGER - mode: NULLABLE name: scalar_parent_urlbar_impression_autofill_preloaded_sum type: INTEGER - mode: NULLABLE name: scalar_parent_urlbar_impression_autofill_url_sum type: INTEGER - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_telemetry_event_counts_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_content_telemetry_event_counts_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_bookmarkmenu_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_handoff_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_keywordoffer_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_oneoff_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_other_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_shortcut_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_tabmenu_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_tabtosearch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_tabtosearch_onboard_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_topsites_newtab_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_topsites_urlbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_touchbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_searchmode_typed_sum type: RECORD - mode: NULLABLE name: scalar_parent_os_environment_is_taskbar_pinned type: BOOLEAN - mode: NULLABLE name: scalar_parent_os_environment_launched_via_desktop type: BOOLEAN - mode: NULLABLE name: scalar_parent_os_environment_launched_via_taskbar type: BOOLEAN - mode: NULLABLE name: scalar_parent_os_environment_launched_via_other type: BOOLEAN - mode: NULLABLE name: scalar_parent_os_environment_launched_via_start_menu type: BOOLEAN - mode: NULLABLE name: scalar_parent_os_environment_launched_via_other_shortcut type: BOOLEAN - mode: NULLABLE name: days_logged_event_bits type: INTEGER - mode: NULLABLE name: days_used_pictureinpicture_bits type: INTEGER - mode: NULLABLE name: days_viewed_protection_report_bits type: INTEGER - mode: NULLABLE name: n_logged_event type: INTEGER - mode: NULLABLE name: n_created_pictureinpicture type: INTEGER - mode: NULLABLE name: n_viewed_protection_report type: INTEGER - mode: NULLABLE name: search_count_webextension type: INTEGER - mode: NULLABLE name: search_count_alias type: INTEGER - mode: NULLABLE name: search_count_urlbar_searchmode type: INTEGER - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_browser_ui_interaction_preferences_pane_home_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_autofill_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_autofill_about_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_autofill_adaptive_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_autofill_origin_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_autofill_other_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_autofill_preloaded_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_autofill_url_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_bookmark_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_dynamic_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_extension_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_formhistory_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_history_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_keyword_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_remotetab_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_searchengine_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_searchsuggestion_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_switchtab_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_tabtosearch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_tip_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_topsite_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_unknown_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_urlbar_picked_visiturl_sum type: RECORD - mode: NULLABLE name: default_private_search_engine type: STRING - mode: NULLABLE name: default_private_search_engine_data_load_path type: STRING - mode: NULLABLE name: default_private_search_engine_data_name type: STRING - mode: NULLABLE name: default_private_search_engine_data_origin type: STRING - mode: NULLABLE name: default_private_search_engine_data_submission_url type: STRING - fields: - mode: NULLABLE name: engine type: STRING - mode: NULLABLE name: source type: STRING - mode: NULLABLE name: count type: INTEGER mode: REPEATED name: search_counts type: RECORD - mode: NULLABLE name: user_pref_browser_search_region type: STRING - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_with_ads type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: ad_clicks type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_urlbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_urlbar_handoff_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_urlbar_persisted_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_urlbar_searchmode_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_contextmenu_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_about_home_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_about_newtab_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_searchbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_system_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_webextension_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_tabhistory_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_reload_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_content_unknown_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_urlbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_urlbar_handoff_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_urlbar_persisted_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_urlbar_searchmode_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_contextmenu_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_about_home_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_about_newtab_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_searchbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_system_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_webextension_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_tabhistory_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_reload_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_withads_unknown_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_urlbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_urlbar_handoff_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_urlbar_persisted_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_urlbar_searchmode_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_contextmenu_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_about_home_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_about_newtab_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_searchbar_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_system_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_webextension_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_tabhistory_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_reload_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: search_adclicks_unknown_sum type: RECORD - mode: NULLABLE name: update_background type: BOOLEAN - mode: NULLABLE name: user_pref_browser_search_suggest_enabled type: STRING - mode: NULLABLE name: user_pref_browser_widget_in_navbar type: STRING - mode: NULLABLE name: user_pref_browser_urlbar_suggest_searches type: STRING - mode: NULLABLE name: user_pref_browser_urlbar_show_search_suggestions_first type: STRING - mode: NULLABLE name: user_pref_browser_urlbar_suggest_quicksuggest type: STRING - mode: NULLABLE name: user_pref_browser_urlbar_suggest_quicksuggest_sponsored type: STRING - mode: NULLABLE name: user_pref_browser_urlbar_quicksuggest_onboarding_dialog_choice type: STRING - mode: NULLABLE name: scalar_parent_browser_engagement_total_uri_count_normal_and_private_mode_sum type: INTEGER - mode: NULLABLE name: user_pref_browser_newtabpage_enabled type: STRING - mode: NULLABLE name: user_pref_app_shield_optoutstudies_enabled type: STRING - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_click_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_impression_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_help_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_topsites_click_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_topsites_impression_sum type: RECORD - mode: NULLABLE name: user_pref_browser_urlbar_suggest_quicksuggest_nonsponsored type: STRING - mode: NULLABLE name: user_pref_browser_urlbar_quicksuggest_data_collection_enabled type: STRING - mode: NULLABLE name: scalar_a11y_hcm_foreground type: INTEGER - mode: NULLABLE name: scalar_a11y_hcm_background type: INTEGER - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: BOOLEAN mode: REPEATED name: a11y_theme type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_help_nonsponsored_bestmatch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_help_sponsored_bestmatch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_block_nonsponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_block_sponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_block_sponsored_bestmatch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_block_nonsponsored_bestmatch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_click_sponsored_bestmatch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_click_nonsponsored_bestmatch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_impression_sponsored_bestmatch_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_impression_nonsponsored_bestmatch_sum type: RECORD - mode: NULLABLE name: user_pref_browser_urlbar_suggest_bestmatch type: STRING - mode: NULLABLE name: scalar_parent_browser_ui_interaction_textrecognition_error_sum type: INTEGER - mode: NULLABLE name: text_recognition_interaction_timing_sum type: INTEGER - mode: NULLABLE name: text_recognition_interaction_timing_count_sum type: INTEGER - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_browser_ui_interaction_content_context_sum type: RECORD - mode: NULLABLE name: text_recognition_api_performance_sum type: INTEGER - mode: NULLABLE name: text_recognition_api_performance_count_sum type: INTEGER - mode: NULLABLE name: text_recognition_text_length_sum type: INTEGER - mode: NULLABLE name: text_recognition_text_length_count_sum type: INTEGER - mode: NULLABLE name: places_searchbar_cumulative_searches_sum type: INTEGER - mode: NULLABLE name: places_searchbar_cumulative_filter_count_sum type: INTEGER - mode: NULLABLE name: scalar_parent_os_environment_launched_via_taskbar_private type: BOOLEAN - mode: NULLABLE name: dom_parentprocess_private_window_used type: BOOLEAN - mode: NULLABLE name: os_environment_is_taskbar_pinned_any type: BOOLEAN - mode: NULLABLE name: os_environment_is_taskbar_pinned_private_any type: BOOLEAN - mode: NULLABLE name: os_environment_is_taskbar_pinned_private type: BOOLEAN - mode: NULLABLE name: bookmark_migrations_quantity_chrome type: INTEGER - mode: NULLABLE name: bookmark_migrations_quantity_edge type: INTEGER - mode: NULLABLE name: bookmark_migrations_quantity_safari type: INTEGER - mode: NULLABLE name: bookmark_migrations_quantity_all type: INTEGER - mode: NULLABLE name: history_migrations_quantity_chrome type: INTEGER - mode: NULLABLE name: history_migrations_quantity_edge type: INTEGER - mode: NULLABLE name: history_migrations_quantity_safari type: INTEGER - mode: NULLABLE name: history_migrations_quantity_all type: INTEGER - mode: NULLABLE name: logins_migrations_quantity_chrome type: INTEGER - mode: NULLABLE name: logins_migrations_quantity_edge type: INTEGER - mode: NULLABLE name: logins_migrations_quantity_safari type: INTEGER - mode: NULLABLE name: logins_migrations_quantity_all type: INTEGER - mode: NULLABLE name: media_play_time_ms_audio_sum type: INTEGER - mode: NULLABLE name: media_play_time_ms_video_sum type: INTEGER - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_block_dynamic_wikipedia_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_block_weather_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_click_dynamic_wikipedia_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_click_nonsponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_click_sponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_click_weather_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_help_dynamic_wikipedia_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_help_nonsponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_help_sponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_help_weather_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_impression_dynamic_wikipedia_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_impression_nonsponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_impression_sponsored_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: contextual_services_quicksuggest_impression_weather_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_sidebar_opened_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_sidebar_search_sum type: RECORD - fields: - mode: NULLABLE name: key type: STRING - mode: NULLABLE name: value type: INTEGER mode: REPEATED name: scalar_parent_sidebar_link_sum type: RECORD - name: places_previousday_visits_mean type: FLOAT mode: NULLABLE - name: places_library_cumulative_bookmark_searches_sum type: INTEGER mode: NULLABLE - name: places_library_cumulative_history_searches_sum type: INTEGER mode: NULLABLE - name: places_bookmarks_searchbar_cumulative_searches_sum type: INTEGER mode: NULLABLE - name: scalar_parent_library_link_sum type: RECORD mode: REPEATED fields: - name: key type: STRING mode: NULLABLE - name: value type: INTEGER mode: NULLABLE - name: scalar_parent_library_opened_sum type: RECORD mode: REPEATED fields: - name: key type: STRING mode: NULLABLE - name: value type: INTEGER mode: NULLABLE - name: scalar_parent_library_search_sum type: RECORD mode: REPEATED fields: - name: key type: STRING mode: NULLABLE - name: value type: INTEGER mode: NULLABLE - name: startup_profile_selection_reason_first type: STRING mode: NULLABLE - name: startup_profile_selection_first_ping_only type: STRING mode: NULLABLE - name: first_document_id type: STRING mode: NULLABLE - name: partner_id type: STRING mode: NULLABLE - name: distribution_version type: STRING mode: NULLABLE - name: distributor type: STRING mode: NULLABLE - name: distributor_channel type: STRING mode: NULLABLE - name: env_build_platform_version type: STRING mode: NULLABLE - name: env_build_xpcom_abi type: STRING mode: NULLABLE - name: geo_db_version type: STRING mode: NULLABLE - name: apple_model_id type: STRING mode: NULLABLE - name: max_subsession_counter type: INTEGER mode: NULLABLE - name: min_subsession_counter type: INTEGER mode: NULLABLE - name: profile_group_id type: STRING mode: NULLABLE

sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_joined_v1/schema.yaml (2,151 lines of code) (raw):