<commit_before>\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2016_to_2017.tsv';



\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_bot_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_bot_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_bot_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_bot_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_human_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_human_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_human_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_human_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_anon_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_anon_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_anon_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_anon_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_tool_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_tool_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_tool_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, (CASE WHEN male_item IS NOT NULL THEN male_item ELSE female_item END) as gender, NULL as coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND (male_item IS NOT NULL OR female_item IS NOT NULL)) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_item_tool_edits_may_2016_to_2017.tsv';



\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_bot_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_bot_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_bot_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_bot_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_human_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_human_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_human_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_human_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_anon_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_anon_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_anon_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit' AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_anon_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_tool_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_tool_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_tool_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period, NULL as gender, coordinate_location FROM revisions_with_interesting_subset_info_table_creation where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit') AND coordinate_location IS NOT NULL) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_coord_location_item_tool_edits_may_2016_to_2017.tsv';<commit_msg>Fixing<commit_after>\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'bot_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_bot_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'human_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_human_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND edit_type = 'anon_edit') TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_anon_edits_may_2016_to_2017.tsv';

\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '1' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20130500000000 and revision_timestamp < 20140500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2013_to_2014.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '2' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20140500000000 and revision_timestamp < 20150500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2014_to_2015.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '3' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20150500000000 and revision_timestamp < 20160500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2015_to_2016.tsv';
\copy (SELECT misalignment_matching_year, misalignment_matching_month, namespace, page_title, edit_type, page_views, revision_id, comment, revision_parent_id, '4' as period FROM revisions_all_automation_flags_and_usages where revision_timestamp >= 20160500000000 and revision_timestamp < 20170500000000 AND page_views IS NOT NULL AND namespace = 0 AND (edit_type != 'bot_edit' AND edit_type != 'human_edit' AND edit_type != 'anon_edit' AND edit_type != 'identity_blocked_edit')) TO '/export/scratch2/wmf/wbc_entity_usage/usage_results/wikidata_longitudinal_misalignment/used_tool_edits_may_2016_to_2017.tsv';
{'fraction_non_alphanumeric': 0.06174672269330448, 'fraction_numerical': 0.06280351256825101, 'mean_word_length': 9.09499618999238, 'pattern_counts': {'":': 0, '<': 67, '<?xml version=': 0, '>': 67, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 128, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4233722', 'n_tokens_mistral': 14240, 'n_tokens_neox': 11515, 'n_words': 3039}