mozilla / bigquery-backfill - File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

Overview

File Change Frequency Overall

There are 143 files with 13,656 lines of code.

0 files changed more than 100 times (0 lines of code)
0 files changed 51-100 times (0 lines of code)
0 files changed 21-50 times (0 lines of code)
6 files changed 6-20 times (592 lines of code)
137 files changed 1-5 times (13,064 lines of code)

Legend:

101+

51-100

21-50

6-20

1-5

explore: grouped by folders | grouped by update frequency | data

Contributors Count Frequency Overall

There are 143 files with 13,656 lines of code.

0 files changed by more than 25 contributors (0 lines of code)
0 files changed by 11-25 contributors (0 lines of code)
0 files changed by 6-10 contributors (0 lines of code)
121 files changed by 2-5 contributors (11,428 lines of code)
22 files changed by 1 contributor (2,228 lines of code)

Legend:

26+

11-25

6-10

2-5

explore: grouped by folders | grouped by contributors count | data

File Change Frequency per File Extension

sql, md, yaml, sh, py, txt, json, diff

File Change Frequency per Extension

The number of recorded file updates

101+

51-100

21-50

6-20

1-5

File Change Frequency per Logical Decomposition

primary

primary (file change frequency)

The number of recorded file updates

101+

51-100

21-50

6-20

1-5

Most Frequently Changed Files (Top 50)

See data for all files...

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
fenix_query.sql in backfill/2024-04-26-active_users_aggregates	122	-	2024-04-26	2024-07-11	9	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2024-04-26-active_users_aggregates	96	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
desktop_query.sql in backfill/2024-04-26-active_users_aggregates	100	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2024-04-26-active_users_aggregates	94	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
consolidate_all_sample_ids_kw.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	156	-	2024-05-02	2024-05-08	5	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
view.sql in backfill/2024-03-23-clients_last_seen/active_users	181	-	2024-03-25	2024-04-14	5	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322	26	-	2024-03-23	2024-04-09	4	2	alvargasa@gmail.com	alvargasa@gmail.com
consolidate_all_sample_ids.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	32	-	2024-05-01	2024-07-11	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
org_mozilla_fenix.sql in backfill/2022-01-27-sanitize-search-engines	146	-	2022-02-16	2022-03-09	4	2	jeff@klukas.net	jklukas@mozilla.com
backfill_clients_last_seen_v2.py in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	151	3	2024-03-27	2024-04-03	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
telemetry_derived_clients_first_seen_v2_query.sql in backfill/2023-09-26-initialize-clients_first_seen_v2	341	-	2023-09-26	2023-11-03	4	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
schema.yaml in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	2397	-	2024-03-23	2024-03-27	4	2	alvargasa@gmail.com	alvargasa@gmail.com
org_mozilla_fenix_nightly_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-04-09	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
fenix_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	42	-	2024-03-27	2024-04-03	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	76	-	2024-03-23	2024-03-26	3	2	alvargasa@gmail.com	alvargasa@gmail.com
focus_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2023-08-03-fenix_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	3	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
firefox_ios_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	162	-	2024-03-23	2024-03-26	3	2	alvargasa@gmail.com	alvargasa@gmail.com
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	19	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
firefox_ios.baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	20	-	2024-03-25	2024-04-09	2	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
backfill_backend_events.py in backfill/2024-04-29-fxa_events/backend	22	1	2024-05-14	2024-05-15	2	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	28	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...

Files With Most Contributors (Top 50)

Based on the number of unique email addresses found in commits.

See data for all files...

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
fenix_query.sql in backfill/2024-04-26-active_users_aggregates	122	-	2024-04-26	2024-07-11	9	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2024-04-26-active_users_aggregates	96	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
desktop_query.sql in backfill/2024-04-26-active_users_aggregates	100	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2024-04-26-active_users_aggregates	94	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
view.sql in backfill/2024-03-23-clients_last_seen/active_users	181	-	2024-03-25	2024-04-14	5	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
telemetry_derived_clients_first_seen_v2_query.sql in backfill/2023-09-26-initialize-clients_first_seen_v2	341	-	2023-09-26	2023-11-03	4	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322	26	-	2024-03-23	2024-04-09	4	2	alvargasa@gmail.com	alvargasa@gmail.com
consolidate_all_sample_ids.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	32	-	2024-05-01	2024-07-11	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
schema.yaml in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	2397	-	2024-03-23	2024-03-27	4	2	alvargasa@gmail.com	alvargasa@gmail.com
backfill_clients_last_seen_v2.py in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	151	3	2024-03-27	2024-04-03	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
org_mozilla_fenix.sql in backfill/2022-01-27-sanitize-search-engines	146	-	2022-02-16	2022-03-09	4	2	jeff@klukas.net	jklukas@mozilla.com
focus_android_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
fenix_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	42	-	2024-03-27	2024-04-03	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
org_mozilla_fenix_nightly_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-04-09	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	76	-	2024-03-23	2024-03-26	3	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	162	-	2024-03-23	2024-03-26	3	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2023-08-03-fenix_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	3	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
bigquery_etl_cli_query.py in backfill/2023-09-26-initialize-clients_first_seen_v2	1808	27	2023-09-26	2023-11-03	2	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2023-08-03-firefox_ios_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	2	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
checks.sql in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	80	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	56	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	19	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	28	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com

Files With Least Contributors (Top 50)

Based on the number of unique email addresses found in commits.

See data for all files...

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
query.sql in backfill/2024_10_10_kwindau_clients_first_seen_v2	564	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
dedupe_pings.sql in backfill/2024-05-07-telemetry-pings-os-distro	372	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
null_field_ratio.sql in backfill/2025-01-22-firefox-installer schema-error	317	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
schema.yaml in backfill/2024_10_10_kwindau_clients_first_seen_v2	190	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
consolidate_all_sample_ids_kw.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	156	-	2024-05-02	2024-05-08	5	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
final_insert.sql in backfill/2024-05-07-telemetry-pings-os-distro	96	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
insert_to_prod.py in backfill/2024-11-06-metrics-pings-metric-labels-over-max-length	78	4	2024-11-08	2024-11-08	1	1	anna@scholtzan.net	anna@scholtzan.net
backfill.py in backfill/2022-08-15-clients-first-seen	57	2	2022-08-15	2022-08-16	2	1	anna@scholtzan.net	anna@scholtzan.net
clients_last_seen_v2_days_active_bits.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	45	-	2024-05-15	2024-05-15	1	1	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	45	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
verify_activity_stream_events.sql in backfill/2020-03-30-gcs-error	41	-	2020-04-01	2020-04-01	1	1	amiyaguchi@mozilla.com	amiyaguchi@mozilla.com
append_to_prod.sql in backfill/2020-01-12-crash-ping	40	-	2020-01-16	2020-01-16	1	1	jeff@klukas.net	jeff@klukas.net
query.sql in backfill/2020-03-19-replay-payload-bytes-decoded	36	-	2020-03-26	2020-03-31	2	1	jeff@klukas.net	jeff@klukas.net
query.sql in backfill/2020-04-14-copy-dedupe-failure	36	-	2020-04-15	2020-04-15	1	1	jeff@klukas.net	jeff@klukas.net
duplicates2.sql in backfill/2025-01-22-firefox-installer schema-error	34	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
checks.sql in backfill/2024_10_10_kwindau_clients_first_seen_v2	26	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
generate_statements.py in backfill/2024-05-07-telemetry-pings-os-distro	24	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
crash_v4_with_missing_fields.sql in backfill/2020-02-24-crash-ping	21	-	2020-02-27	2020-02-27	1	1	wlachance@mozilla.com	wlachance@mozilla.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	20	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
schema.yaml in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	13	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
metadata.yaml in backfill/2024_10_10_kwindau_clients_first_seen_v2	9	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
duplicates1.sql in backfill/2025-01-22-firefox-installer schema-error	8	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
schema.yaml in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	2397	-	2024-03-23	2024-03-27	4	2	alvargasa@gmail.com	alvargasa@gmail.com
bigquery_etl_cli_query.py in backfill/2023-09-26-initialize-clients_first_seen_v2	1808	27	2023-09-26	2023-11-03	2	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
telemetry_derived_clients_first_seen_v2_query.sql in backfill/2023-09-26-initialize-clients_first_seen_v2	341	-	2023-09-26	2023-11-03	4	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-07-29-clients-first-seen-v3	255	-	2024-07-29	2024-07-30	2	2	mhirose@mozilla.com	92952117+marlene-m-hirose@u...
view.sql in backfill/2024-03-23-clients_last_seen/active_users	181	-	2024-03-25	2024-04-14	5	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
backfill_clients_last_seen_v2_in_BQproject_backfill_1.py in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	167	3	2024-04-17	2024-04-17	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	162	-	2024-03-23	2024-03-26	3	2	alvargasa@gmail.com	alvargasa@gmail.com
backfill_clients_last_seen_v2.py in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	151	3	2024-03-27	2024-04-03	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
org_mozilla_fenix.sql in backfill/2022-01-27-sanitize-search-engines	146	-	2022-02-16	2022-03-09	4	2	jeff@klukas.net	jklukas@mozilla.com
org_mozilla_firefox_incremental.sql in backfill/2022-01-27-sanitize-search-engines	143	-	2022-02-17	2022-03-09	2	2	jeff@klukas.net	jklukas@mozilla.com
query.sql in backfill/2023-08-03-firefox_desktop_active_users_aggregates_v1	123	-	2023-08-03	2023-09-26	2	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
fenix_query_before_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_query_after_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2024-04-26-active_users_aggregates	122	-	2024-04-26	2024-07-11	9	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
users_services_daily_v2.sql in backfill/2024-04-29-fxa_events/backend	117	-	2024-05-14	2024-05-14	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
query.sql in backfill/2023-08-03-firefox_ios_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	2	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
query.sql in backfill/2023-08-03-fenix_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	3	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
focus_android_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
desktop_query.sql in backfill/2024-04-26-active_users_aggregates	100	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2024-04-26-active_users_aggregates	96	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2024-04-26-active_users_aggregates	94	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
mobile_schema.yaml in backfill/2024-07-15-fenix_active_users_aggregates_v3	85	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...