{
	"auto_complete":
	{
		"selected_items":
		[
			[
				"sfpo",
				"sfPopulateTableFromFile"
			],
			[
				"sfPopula",
				"sfPopulateTable"
			],
			[
				"null",
				"NULL_IF"
			],
			[
				"Spoti",
				"Spotify_Metadata_2016"
			],
			[
				"amazon",
				"amazon_gross_usd"
			],
			[
				"orchard",
				"orchard_gross_ocurr"
			],
			[
				"Ac",
				"activity_month"
			],
			[
				"role",
				"role_to_permission"
			],
			[
				".sf_Gr",
				".sf_grant_permissions_on_schema"
			],
			[
				"numer",
				"number_of_streams"
			],
			[
				"label",
				"labelid"
			],
			[
				"DT.tr",
				"DT.trk"
			],
			[
				"dim_",
				"dim_release"
			],
			[
				"prodc",
				"production.dim_track_clean"
			],
			[
				"production.",
				"production.dim_track_clean"
			],
			[
				"partn",
				"bi.PARENT_UPC_VIEW"
			],
			[
				"album",
				"album_code"
			],
			[
				"upc",
				"upcs_using"
			],
			[
				"producti",
				"production.dim_track"
			],
			[
				"intera",
				"interactive	{base}"
			],
			[
				"DT.",
				"DT.uris_in"
			],
			[
				"glob",
				"globalenv	{base}"
			],
			[
				"parsed",
				"parsed_json"
			],
			[
				"PLAY",
				"playlist_id"
			],
			[
				"api",
				"api_timestamp"
			],
			[
				"schem",
				"schema.out"
			],
			[
				"PRO.",
				"prod.spot_metadata.all_playlist_uris"
			],
			[
				"timest",
				"timestamp_tz"
			],
			[
				"paly",
				"playlist_id"
			],
			[
				"playl",
				"playlist_uri"
			],
			[
				"playlis",
				"playlist_id"
			],
			[
				"playlist",
				"playlist_uri"
			],
			[
				"DT.t",
				"DT.playlist_metadata"
			],
			[
				"play",
				"playlist_id"
			],
			[
				"snap",
				"snapshot_id"
			],
			[
				"as.PO",
				"as.POSIXct	{base}"
			],
			[
				"usri",
				"userids_prefixs"
			],
			[
				"break",
				"breaks_userids"
			],
			[
				"intTo",
				"intToUtf8	{base}"
			],
			[
				"user",
				"userids"
			],
			[
				"ll.",
				"ll.DTs"
			],
			[
				"sche",
				"schema.out"
			],
			[
				"error",
				"errors"
			],
			[
				"err",
				"error"
			],
			[
				"ext",
				"extractFilesFromFolder"
			],
			[
				"get_p",
				"get_basic_playlist_metadata_from_uri"
			],
			[
				"examp",
				"example_uris"
			],
			[
				"envir",
				"envir"
			],
			[
				"verbo",
				"verbose"
			],
			[
				"verbose",
				"verbose.fetching"
			],
			[
				"colum",
				"column_order"
			],
			[
				"missing",
				"missing_cols"
			],
			[
				"missin",
				"missing_cols"
			],
			[
				"tot",
				"total_track_count"
			],
			[
				"follo",
				"followers_count"
			],
			[
				"is_",
				"is_public"
			],
			[
				"owner",
				"owner_id"
			],
			[
				"expeo",
				"expected_owner_subfields"
			],
			[
				"parse",
				"parsed_josn"
			],
			[
				"expec",
				"expected_subfields"
			],
			[
				"expe",
				"expected_owner_fields"
			],
			[
				"Spo",
				"Spotify_Metadata_2016"
			],
			[
				"spot",
				"spot_metadata"
			],
			[
				"number",
				"number_of_streams"
			],
			[
				"user_",
				"user_id"
			],
			[
				"USER",
				"userid"
			],
			[
				"melt",
				"melted"
			],
			[
				"idcol.c",
				"idCol.candidates.ll"
			],
			[
				"trace",
				"traceback"
			],
			[
				"addDate",
				"addDateCols.periodid_"
			],
			[
				"artist",
				"artistid"
			],
			[
				"prod",
				"product.info"
			],
			[
				"downlo",
				"download_activity_date"
			],
			[
				"labl",
				"label"
			],
			[
				"get_la",
				"get_label_id"
			],
			[
				"TRE",
				"TRUE"
			],
			[
				"country",
				"countryid"
			],
			[
				"ower",
				"ownerid"
			],
			[
				"pla",
				"playlists.all"
			],
			[
				"is.char",
				"is.character"
			],
			[
				"isrc_",
				"isrc_expected"
			],
			[
				"exter",
				"external_ids"
			],
			[
				"pasre",
				"parsed_json"
			],
			[
				"parse_",
				"parsed_json"
			],
			[
				"as.data.",
				"as.data.table"
			],
			[
				"avail",
				"available_markets"
			],
			[
				"known",
				"get_all_known_users"
			],
			[
				"json",
				"jsonlite"
			],
			[
				"ischar",
				"is.char_of_length1"
			],
			[
				"DT",
				"DT.usermeta"
			],
			[
				"get_all",
				"get_all_known_users"
			],
			[
				"DT.test",
				"DT.test2"
			],
			[
				"inte",
				"integer"
			],
			[
				"files_",
				"files_all_2"
			],
			[
				"minD",
				"minDate_string"
			],
			[
				"filesn",
				"filenames"
			],
			[
				"fil.p",
				"file.process_tracking"
			],
			[
				"base.file",
				"base.file.name"
			],
			[
				"down",
				"download_date"
			],
			[
				"soure",
				"source_uri"
			],
			[
				"DT.top",
				"DT.top_playlists"
			],
			[
				"write",
				"writeLines"
			],
			[
				"join",
				"joinCols.rec"
			],
			[
				"pagin",
				"pagination"
			],
			[
				"DT.user",
				"DT.usermeta"
			],
			[
				"Value",
				"valueIfErrOrNull"
			],
			[
				"nume",
				"number_of_tracks"
			],
			[
				"single",
				"single_col_elements"
			],
			[
				"extus",
				"external_urls"
			],
			[
				"start",
				"startCols"
			],
			[
				"inter",
				"intersect"
			],
			[
				"wh.e",
				"wh.unexpected"
			],
			[
				"identi",
				"identical"
			],
			[
				"own",
				"owner_parts_using"
			],
			[
				"expecte",
				"expected_fields"
			],
			[
				"user_s",
				"user_access"
			],
			[
				"singl",
				"single_col_elements"
			],
			[
				"follow",
				"followers.total"
			],
			[
				"sup",
				"suppressWarnings"
			],
			[
				"get_t",
				"get_featured_playlists"
			],
			[
				"get_js",
				"get_json_from_spotify_url_NEW"
			],
			[
				"plau",
				"playlist.uri"
			],
			[
				"playlist.ur",
				"playlist.uri"
			],
			[
				"playlist.ow",
				"playlist.owner.id"
			],
			[
				"pal",
				"playlist"
			],
			[
				"playist.alb",
				"playlist.track.album.type"
			],
			[
				"colClas",
				"colClasses"
			],
			[
				"uri",
				"uris"
			]
		]
	},
	"buffers":
	[
		{
			"file": "/Users/rsaporta/git/orch/src/PerformanceRights/manually load PRS society data from CSV files.r",
			"settings":
			{
				"buffer_size": 3907,
				"line_ending": "Unix"
			}
		}
	],
	"build_system": "Packages/SendTextPlus/R - Source File.sublime-build",
	"build_system_choices":
	[
		[
			[
				[
					"Packages/SendTextPlus/R - Source File.sublime-build",
					""
				],
				[
					"Packages/SublimeREPL/sublimerepl_build_system_hack.sublime-build",
					""
				]
			],
			[
				"Packages/SendTextPlus/R - Source File.sublime-build",
				""
			]
		]
	],
	"build_varint": "",
	"command_palette":
	{
		"height": 87.0,
		"last_filter": "minim",
		"selected_items":
		[
			[
				"minim",
				"View: Toggle Minimap"
			],
			[
				"qui",
				"Git: Quick Commit Current File"
			],
			[
				"addc",
				"Git: Add Current File"
			],
			[
				"ren",
				"File: Rename"
			],
			[
				"install",
				"Package Control: Install Package"
			],
			[
				"rext",
				"Set Syntax: R Extended"
			],
			[
				"path",
				"File: Copy Path"
			],
			[
				"reve",
				"File: Reveal"
			],
			[
				"push",
				"Git: Push"
			],
			[
				"puh",
				"Git: Push"
			],
			[
				"pull",
				"Git: Pull"
			],
			[
				"nam",
				"File: Copy Name"
			],
			[
				"rena",
				"File: Rename"
			],
			[
				"sql",
				"Set Syntax: SQL"
			],
			[
				"git diff",
				"Git: Diff Current File"
			],
			[
				"quic",
				"Git: Quick Add"
			],
			[
				"git statu",
				"Git: Status"
			],
			[
				"dele",
				"File: Delete"
			],
			[
				"re",
				"Set Syntax: R Extended"
			],
			[
				"git push",
				"Git: Push"
			],
			[
				"move",
				"File: Move"
			],
			[
				"mini",
				"View: Toggle Minimap"
			],
			[
				"qu",
				"Git: Quick Commit Current File"
			],
			[
				"edit proj",
				"Project: Edit Project"
			],
			[
				"update",
				"Package Control: Upgrade/Overwrite All Packages"
			],
			[
				"wor",
				"Word Wrap: Toggle"
			],
			[
				"min",
				"View: Toggle Minimap"
			],
			[
				"rex",
				"Set Syntax: R Extended"
			],
			[
				"rxt",
				"Set Syntax: R Extended"
			],
			[
				"word",
				"Word Wrap: Toggle"
			],
			[
				"pu",
				"Git: Pull"
			],
			[
				"quick",
				"Git: Quick Commit Current File"
			],
			[
				"rx",
				"R-Box: Choose Program"
			],
			[
				"wo",
				"Word Wrap: Toggle"
			],
			[
				"pus",
				"Git: Push"
			],
			[
				"git pull",
				"Git: Pull"
			],
			[
				"disa",
				"Package Control: Disable Package"
			],
			[
				"qcur",
				"Git: Quick Commit Current File"
			],
			[
				"enab",
				"Package Control: Enable Package"
			],
			[
				"name",
				"File: Copy Name"
			],
			[
				"rev",
				"File: Reveal"
			],
			[
				"ena",
				"Package Control: Enable Package"
			],
			[
				"dis",
				"Package Control: Disable Package"
			],
			[
				"disab",
				"Package Control: Disable Package"
			],
			[
				"enabl",
				"Package Control: Enable Package"
			],
			[
				"rbox",
				"R-Box: Choose Program"
			],
			[
				"shel",
				"SublimeREPL: Shell"
			],
			[
				"pul",
				"Git: Pull"
			],
			[
				"renam",
				"File: Rename"
			],
			[
				"sq",
				"Set Syntax: SQL"
			],
			[
				"cop",
				"File: Copy Path"
			],
			[
				"ord",
				"Word Wrap: Toggle"
			],
			[
				"qi",
				"Git: Quick Commit"
			],
			[
				"rb",
				"R-Box: Choose Program"
			],
			[
				"instal",
				"Package Control: Install Package"
			],
			[
				"rap",
				"Package Control: Remove Package"
			],
			[
				"wrod",
				"Word Wrap: Toggle"
			],
			[
				"revea",
				"File: Reveal"
			],
			[
				"html",
				"HTML: Encode Special Characters"
			],
			[
				"upgrad",
				"Package Control: Upgrade Package"
			],
			[
				"file name",
				"File: Copy Name"
			],
			[
				"bro",
				"SFTP: Browse Server…"
			],
			[
				"brow",
				"SFTP: Browse Server…"
			],
			[
				"edit",
				"SFTP: Edit Server…"
			],
			[
				"open file",
				"View: Toggle Open Files in Side Bar"
			],
			[
				"server",
				"SFTP: Setup Server…"
			],
			[
				"br",
				"SFTP: Browse Server…"
			],
			[
				"disabl",
				"Package Control: Disable Package"
			],
			[
				"edit serv",
				"SFTP: Edit Server…"
			],
			[
				"brow ser",
				"SFTP: Browse Server…"
			],
			[
				"enh",
				"Set Syntax: Enhanced-R"
			],
			[
				"comm",
				"Git: Commit"
			],
			[
				"ra",
				"R Application Switch"
			],
			[
				"copy",
				"File: Copy Path"
			],
			[
				"q",
				"Git: Quick Commit"
			],
			[
				"en",
				"Set Syntax: Enhanced-R"
			],
			[
				"git pu",
				"Git: Pull"
			],
			[
				"del",
				"File: Delete"
			],
			[
				"wro",
				"Word Wrap: Toggle"
			],
			[
				"upda",
				"Package Control: Upgrade Package"
			],
			[
				"text",
				"Set Syntax: Plain Text"
			],
			[
				"r",
				"R Application Switch"
			],
			[
				"d",
				"File: Delete"
			],
			[
				"comcur",
				"Git: Quick Commit Current File"
			],
			[
				"w",
				"Word Wrap: Toggle"
			],
			[
				"add cu",
				"Git: Add Current File"
			],
			[
				"enha",
				"Set Syntax: Enhanced-R"
			],
			[
				"git chec",
				"Git: Checkout"
			],
			[
				"git check",
				"Git: Checkout"
			],
			[
				"syn shel",
				"Set Syntax: Shell Script (Bash)"
			],
			[
				"synt she",
				"Set Syntax: Shell Script (Bash)"
			],
			[
				"git ch",
				"Git: Checkout"
			],
			[
				"git stas",
				"Git: Pop Stash"
			],
			[
				"git sta",
				"Git: Stash"
			],
			[
				"add",
				"Git: Add Current File"
			],
			[
				"rapp",
				"R Application Switch"
			],
			[
				"git cur",
				"Git: Quick Commit Current File"
			],
			[
				"pat",
				"File: Copy Path"
			],
			[
				"quci",
				"Git: Quick Commit Current File"
			],
			[
				"ush",
				"SublimeREPL: Shell"
			],
			[
				"psuh",
				"Git: Push"
			],
			[
				"disable pack",
				"Package Control: Disable Package"
			],
			[
				"check",
				"Git: Checkout New Branch"
			],
			[
				"git com cur",
				"Git: Quick Commit Current File"
			],
			[
				"curr",
				"Git: Add Current File"
			],
			[
				"git comcu",
				"Git: Quick Commit Current File"
			],
			[
				"qucur",
				"Git: Quick Commit Current File"
			],
			[
				"com cu",
				"Git: Quick Commit Current File"
			],
			[
				"addcu",
				"Git: Add Current File"
			],
			[
				"quicad",
				"Git: Quick Add"
			],
			[
				"PAT",
				"File: Copy Path"
			],
			[
				"git comm",
				"Git: Commit"
			],
			[
				"synshe",
				"Set Syntax: Shell Script (Bash)"
			],
			[
				"fil",
				"File: Copy Name"
			],
			[
				"nh",
				"Set Syntax: HTML"
			],
			[
				"fin",
				"File: Copy Name"
			],
			[
				"checkou",
				"Git: Checkout New Branch"
			],
			[
				"filena",
				"File: Copy Name"
			],
			[
				"com file",
				"Git: Quick Commit Current File"
			],
			[
				"quc",
				"Git: Quick Commit Current File"
			],
			[
				"qucomf",
				"Git: Quick Commit Current File"
			],
			[
				"comf",
				"Git: Quick Commit Current File"
			],
			[
				"qucf",
				"Git: Quick Commit Current File"
			],
			[
				"commfil",
				"Git: Quick Commit Current File"
			],
			[
				"filen",
				"File: Copy Name"
			],
			[
				"branch",
				"Git: Checkout New Branch"
			],
			[
				"new br",
				"Git: Checkout New Branch"
			],
			[
				"branc",
				"Git: Checkout New Branch"
			]
		],
		"width": 521.0
	},
	"console":
	{
		"height": 126.0,
		"history":
		[
			"view.encoding()",
			"sublime.log_input()",
			"sublime.log_input(flag)",
			"view.settings().get('font_face')",
			"subprocess.Popen([Rscript, '-e', 'args(' + 'as.data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + func + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\"'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\" --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=\"data.table,ggplot2\"'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen(args + '', stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen(args + \"\", stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]",
			"args = [Rscript, '-e', 'args(' + func + ')']",
			"args",
			"subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]",
			"args =[Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2']",
			"subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + 'data.frame' + ')'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]",
			"subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]",
			"import subprocess",
			"subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]",
			"args",
			"args = [Rscript, '-e', 'args(' + func + ')']",
			"args <- [Rscript, '-e', 'args(' + func + ')']",
			"[Rscript, '-e', 'args(' + func + ')']",
			"output",
			"output = mycheck_output([Rscript, '-e', 'args(' + func + ')'])",
			"plat = sublime.platform()",
			"Rscript = \"Rscript\"",
			"Rscript = get(plat, \"Rscript\", \"Rscript\")",
			"plat",
			"help",
			"?",
			"{",
			"def get_Rscript():",
			"Rscript = get_Rscript()",
			"print(func in container)",
			"func",
			"func = m.group(1)",
			"print(func in container)",
			"m.group(1)",
			"m.group",
			"view.set_status(\"Enhanced-R\", \"\")",
			"not m",
			"if not m: return",
			"m",
			"m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)",
			"import re",
			"m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)",
			"contentb = view.substr(sublime.Region(view.line(point).begin(), point))",
			"contentb",
			"contentb = view.substr(sublime.Region(view.line(point).begin(), point))",
			"point",
			"point = view.sel()[0].end() if view.sel() else 0",
			"        point = view.sel()[0].end() if view.sel() else 0",
			"point",
			"contentb",
			"contentb = view.substr(sublime.Region(view.line(point).begin(), point))",
			"sel[0].begin() != sel[0].end()",
			"len(sel)",
			"if len(sel)!=1: return",
			"sel = view.sel()",
			"this_row = view.rowcol(point)[0]",
			"sel[0].end()",
			"sel[0].begin()",
			"sel[0]",
			"len(sel)",
			"sel",
			"sel'",
			"sel = view.sel()",
			"this_row",
			"this_row = view.rowcol(point)[0]",
			"not view.score_selector(point, \"source.r\")",
			"view.score_selector(point, \"source.r\")",
			"point",
			"point = view.sel()[0].end() if view.sel() else 0",
			"import urllib.request,os; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler()) ); open(os.path.join(ipp, pf), 'wb').write(urllib.request.urlopen( 'http://sublime.wbond.net/' + pf.replace(' ','%20')).read())"
		]
	},
	"distraction_free":
	{
		"menu_visible": true,
		"show_minimap": false,
		"show_open_files": false,
		"show_tabs": false,
		"side_bar_visible": false,
		"status_bar_visible": false
	},
	"expanded_folders":
	[
		"/Users/rsaporta/git/orch/src/PerformanceRights",
		"/Users/rsaporta/git/orch/notes/PerformanceRights",
		"/Users/rsaporta/git/orch/plots/PerformanceRights",
		"/Users/rsaporta/git/orch/out/PerformanceRights"
	],
	"file_history":
	[
		"/Users/rsaporta/git/misc/rscripts/utils/convert_encoding_linux.r",
		"/Users/rsaporta/git/orch/ingest/PerformanceRights/GVL/GVL-ClaimsAgainstOtherDistributors_ISRC_2016-03-30.csv",
		"/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils - Table Creations.r",
		"/Users/rsaporta/git/misc/rscripts/utils/makeSQLtable.r",
		"/Users/rsaporta/git/orch/ingest/PerformanceRights/abramus/abramus 20160414 - ioda_arq1_2_3_4.csv",
		"/Users/rsaporta/git/misc/rscripts/utils/idcol.r",
		"/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils.R",
		"/Users/rsaporta/git/orch/out/PricingModelForDB/snowflake.wh_usage_in_credits.tsv",
		"/Users/rsaporta/git/orch/out/PricingModelForDB/snowflake.storage_in_TBs.tsv",
		"/Users/rsaporta/git/orch/src/PricingModelForDB/Snowflake vs Vertica.r",
		"/Users/rsaporta/git/orch/out/PricingModelForDB/snowflake.wh_usage.tsv",
		"/Users/rsaporta/git/orch/out/PricingModelForDB/snowflake.storage.tsv",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/checkingNumbers.r",
		"/Users/rsaporta/development/datalytics/SQL Queries/MarketshareJoins/amazon_prime_view.sql",
		"/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/label_view_snowflake.sql",
		"/Users/rsaporta/git/orch/src/DeNormalizing/QCing Tables/confirming no fantouts in track_view to label_view.sql",
		"/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/spotify.sos_from_raw_with_joins_view.sql",
		"/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/spotify.sos_from_raw_view.sql",
		"/Users/rsaporta/development/datalytics/Looker Aesthetics/Colors - Streams vs Downloads by Country.txt",
		"/Users/rsaporta/development/datalytics/Looker Aesthetics/Colors - Gross USD by Country.txt",
		"/Users/rsaporta/development/datalytics/Looker Aesthetics/Colors -- Marketshare by Country.r",
		"/Users/rsaporta/git/orch/src/DeNormalizing/snowflake_permissioning_update.r",
		"/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Grant_Permissions.r",
		"/Users/rsaporta/development/datalytics/SQL Queries/MarketshareJoins/amazon_prime_view using statements_db.sql",
		"/Users/rsaporta/development/datalytics/SQL Queries/MarketshareJoins/Amazon Marketshare with Streams.sql",
		"/Users/rsaporta/git/orch/src/Looker/supportFns/make_looker_colors.r",
		"/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/spotify.sos_from_raw_with_metadata_view.sql",
		"/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/findDupRowsInSQLtable.r",
		"/Users/rsaporta/git/.gitignore",
		"/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_with_metadata_view.sql",
		"/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/applemusic.sos_from_raw_view.sql",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/get_basic_playlist_metadata_from_uri.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/confirm_expected_rows.r",
		"/Users/rsaporta/git/misc/rscripts/utilsRS.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/table creations.sql",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/create table spot_metadata.playlist_metadata.sql",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/get_json_from_spotify_url_NEW.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/view creations.sql",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/parse_items.tracks.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/url_conversions_for_spotify_API.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/get_playlist_data.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/web api tokens.r",
		"/Users/rsaporta/git/orch/src/Discover_Weekly/sample ISRC table creation.sql",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/Notes.txt",
		"/Users/rsaporta/git/orch/notes/Spotify_Metadata_2016/Created SymLink for outDir.sh",
		"/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_sample_isrcs.r",
		"/Users/rsaporta/git/StackExchange/chromosoms.R",
		"/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/get_url_for_spotify_API.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/parse_subjson.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/expected_fields.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/get_url_type_from_url.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/supportFns/pre_2016_supportFns/misc_support_functions_for_parsing.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_subjson.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/web api tokens.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/url_conversions_for_spotify_API.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_items.tracks.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/misc_support_functions_for_parsing.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_url_type_from_url.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_url_for_spotify_API.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_playlist_data.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/expected_fields.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/confirm_expected_rows.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/01 something.r",
		"/Users/rsaporta/git/orch/notes/Spotify_Metadata_2016/Outline of Spotify SoS Metadata Retrievel Process.txt",
		"/Users/rsaporta/git/misc/rscripts/utils/confirm_expected_subfields.r",
		"/Users/rsaporta/git/orch/src/Spotify_Metadata_2016/0000 File Cleanup Needed.R",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading I - create DT.playlist_metadata.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/00 Featured Playlist Setup.r",
		"/Users/rsaporta/git/orch/sublws/Spotify Playlist Webscrape/Spotify Playlist Webscrape+KickOff.sublime-project",
		"/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/yr_wk_to_date.r",
		"/Users/rsaporta/git/orch/src/Looker/supportFns/birngAndCopyLookerFiles.r",
		"/Users/rsaporta/git/misc/rscripts/utils/console_utils.R",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/create Sample SoS Table (for quicker querrying).r",
		"/Users/rsaporta/Desktop/acceleration methods.r",
		"/Users/rsaporta/Desktop/acceleration support functinos.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Kick Off Files/kick off files.sublime-workspace",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Kick Off Files/kick off files.sublime-project",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/daily_playlist_scrape.r",
		"/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_dim_x.r",
		"/Users/rsaporta/git/misc/rscripts/utils/addColsFrom and addMeta.r",
		"/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/id Conversions.r",
		"/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/artist_view.sql",
		"/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/getReleaseInfo.r",
		"/Users/rsaporta/Dropbox/The Orchard/Looker/email to Jason re Trial Licenses.txt",
		"/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_meta.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/colClasses and empty DTs.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_user_data.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_items.playlists.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_items.tracks_old.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/get_track_data.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/download_playlist_data.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/_latestBackups.r",
		"/Users/rsaporta/git/misc/rscripts/utils/quickUrlEncode.R",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Kick Off Files/Kick Off for ALL PLAYLISTS in our system.R",
		"/Users/rsaporta/git/orch/log/Spotify Playlist Webscrape/Chunked_Webscrape_Fwd_20150619_2120.logr",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_json_from_spotify_url_NEW.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get jsonfiles from disk.r",
		"/Users/rsaporta/git/orch/log/Spotify Playlist WebscrapeChunked_Webscrape_Fwd_20150619_0034.logr",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/2015-06-04 errors to check.R",
		"/Users/rsaporta/git/orch/src/Spotify_Stream_Count/playlist_to_collection_conversion.r",
		"/Users/rsaporta/git/orch/notes/Spotify Playlist Webscrape/popularity  -- integer.txt",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/developer API endpoints exploration.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_featured_playlists.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_known_users.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/zArchive/get_json_from_spotify_url_OLD.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/after download supportFns.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading II.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading III.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/streams_per_playlist.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/to_ts_string.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/playlist analyis for marketing team.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/write_which_playlists_were_processed_on_date.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/download_featured_playlists.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/process featured playlists files - part 01.r",
		"/Users/rsaporta/git/misc/rscripts/utils/writeDT.r",
		"/Users/rsaporta/git/misc/rscripts/utils/notify/notify.r",
		"/Users/rsaporta/git/misc/rscripts/utils/workspace.R",
		"/Users/rsaporta/Dropbox/The Orchard/EU Summit/Ricks Graphs/questions",
		"/Users/rsaporta/git/orch/src/Spotify_Stream_Count/Spotify_Stream_Count_by_label.r",
		"/Users/rsaporta/Dropbox/The Orchard/EU Summit/Ricks Graphs/tracks_on_playlist.csv",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After I Downloading and Processing - create DT.flat.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading and Processing - create DT.flat.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Bart Wirtz.r",
		"/Users/rsaporta/git/misc/rscripts/utils/dict functions.r",
		"/Users/rsaporta/git/misc/rscripts/utils/NA and NULL handlers.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_owner_subjson.r",
		"/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/processed/playlists_processed_rev.txt"
	],
	"find":
	{
		"height": 35.0
	},
	"find_in_files":
	{
		"height": 93.0,
		"where_history":
		[
			""
		]
	},
	"find_state":
	{
		"case_sensitive": false,
		"find_history":
		[
			"abramus",
			"\nfile.abramus_utf8 <- gsub(\"\\\\.csv$\", \".utf8.csv\", file.abramus)\nif (!exists(file.abramus_utf8))\n  convert_encoding_linux(from.file=file.abramus, to.file=file.abramus_utf8, from.encoding=\"WINDOWS-1252\", to.encoding=\"UTF-8\", ignore_errors=TRUE)\n",
			"get_pat_ok_sql_col_names",
			"create_and_populate_table_form_csv",
			"sfPopulateTableFromFile",
			"get_pat_ok_sql_col_names",
			"create_and_populate_table_form_csv",
			"some column names",
			"encoding_for_fread",
			"encoding",
			"encoding = ",
			"create_and_populate_table_form_csv",
			"datetime_type",
			"sfPopulateTable",
			"detectIDColumns",
			"grepl(pat",
			"create_and_populate_table_form_csv",
			"escape_string",
			"sfCreateFileFormat.CSV",
			"file.GVL_ArtistTrack",
			"ggLinegraph",
			"gg",
			"vertica",
			"DT.snowflake.wh_usage",
			",",
			"checkingNumbers",
			"id.som_livre",
			".sf_grant_permissions_on_dbname",
			"Orchard Gross USD",
			"Amazon Gross USD",
			"orchard_gross_ocurr",
			"Stream",
			"Download",
			"GB",
			"US ",
			"z_",
			"z_min",
			"y_",
			"y_min",
			"x_",
			"x_min",
			"'",
			"x",
			"staging_raw_spotify_v2",
			"staging_raw_spotify_v2.",
			"staging_raw_spotify_v2",
			"bi_release_with_metadata_view.",
			"rsaporta@[rbox]: ~$",
			"playlist_id",
			"album_code",
			"source",
			"C.",
			"L.",
			"T.",
			"C.",
			"T.*",
			"LABEL",
			"L.",
			",",
			"staging_raw_spotify_v2",
			".",
			"upc",
			"concat",
			"isrc",
			"175759089397",
			"cohab.",
			"choab.",
			"cohab",
			"from",
			"'",
			"release",
			"album_code",
			"(tmstamp)",
			"div",
			"</div>",
			"<div ",
			"merge",
			"wh",
			"is.Err",
			"merge",
			" ",
			"  ",
			"did not parse correctly",
			"CONFIRMED",
			"snapshot_id",
			"names",
			"all_playlist_uris",
			"playlist_metadata",
			"table playlist_metadata",
			"playlist_metadata",
			"playlist_metdata",
			",",
			"over (",
			"create or replace",
			"get_json_from_spotify_url",
			"parse_error_message_from_json",
			"400",
			"404",
			"get_basic_playlist_metadata_from_list_of_uris <- ",
			"_unique",
			"browser(",
			"check for",
			"check for parsed id",
			"parent.frame",
			"envir=parent.frame",
			"get_spotify_API_token",
			"envir",
			"is_expired_spotify_token",
			"confirm_spotify_token",
			"token",
			"check for parsed",
			"parsed",
			"quickUrlEncode",
			"quickUrlEncode(url, cs=FALSE)",
			"quickURL",
			"get_json_from_spotify_url <- ",
			"get_json_from_spotify_url",
			"get_basic_playlist_metadata_from_uri",
			"get_basic_playlist_metadata_from_list_of_uris",
			"move",
			"rlike",
			"unique",
			"colstopull",
			"followers",
			"get_Sample",
			"all_playlist_uris",
			"DT.uris_in",
			"comment.playlist_metadata"
		],
		"highlight": true,
		"in_selection": true,
		"preserve_case": false,
		"regex": false,
		"replace_history":
		[
			"GVL_ArtistTrack",
			"GVL_ISRC",
			"file.abramus",
			"file.GVL_ArtistTrack",
			"Marketshare (by Streams)",
			"Marketshare",
			" \"",
			"Orchard Gross USD",
			"UK",
			"USA ",
			"v_",
			"s_",
			"h_",
			"y",
			"spotify_sos_from_raw_view",
			"S.",
			"staging_raw_spotify_v2.",
			"rel.",
			"rel",
			"> ",
			"182750077855",
			"",
			"(activity_datetime)",
			"</p>",
			"<p ",
			"ll.uris",
			"ll.uri",
			"",
			"pj_simple",
			"expected_subfields",
			"_10",
			" 10",
			"spotify_sample_sos",
			"cumulative_velocity",
			"periodidTodate",
			"artist",
			"setnames_addPreface",
			"length(items$track$name) >= 1",
			"ei",
			"id",
			"track",
			"get_json_from_spotify_url",
			"track.is_orchard_dist",
			"track.is_orchard_or_d3",
			";",
			"get_all_playlists_downloaded_to_outDir",
			"get_all_playlists_uris_downloaded_to_outDir",
			"if (missing(using) && length(wh.unexpected",
			"if (length(wh.unexpected",
			"joinCols.rec",
			"TRUE  ",
			"FALSE  ",
			"playist_associatedto_user",
			"playist_belonging_to_user",
			"parsed_json",
			"  ## OLD: DT.external_urls <- expand_sub_group(parsed_json[\"external_urls\"]) %>% as.data.table\n  DT.external_urls <- parse_external_url_subjson(parsed_json, recursive=TRUE)",
			"external_url",
			"parse_items.playlists",
			"setdiff(names(parsed_json), not_using)",
			"setdiff(parsed_json, not_using)",
			"parsed_json",
			"artist",
			"not_using",
			"nms",
			"parse_items.list_of_playlists",
			"user",
			".id",
			"## confirm all are exactly of length 1 and not a list, except for 'description'",
			"## confirm all are exactly of length 1 and not a list",
			"DT.pl",
			"DT.playlist_metadata",
			"\\",
			"files_chunked",
			"files",
			"files_all",
			"playlists.existing_in_outDir",
			"playlists.existing",
			"filenames",
			"initialize_file_for_process_tracking",
			"initiate_file_for_process_tracking",
			"playlists.marketing",
			"playlists.cat",
			"cleanid",
			"what.confirming",
			"FULLROW",
			"streams",
			"wh_opt",
			"wh_opts$",
			"DT_interactions",
			"byCols",
			"byColsFull",
			"attr",
			"NJ",
			"colsToBring",
			"82",
			"Args_for_url",
			"Args_pasting",
			"Args_pasted",
			"_",
			"splat",
			"NJCrashData",
			"20150413_STREAMS_per_users_per_release_country",
			"STREAMS_per_users_per_release_country",
			"label",
			"stream_customer_counts_by_label",
			"getSubProj",
			"subProj",
			"\\v",
			"AcctBIandProd_are_synced",
			"validate",
			"qry.rowcounts.fact",
			"unique_bucket",
			"activity_date",
			"accounting_month",
			"exportXLS.usingXLConnect",
			"store_name_short",
			"dict",
			"period_view",
			"dimCols",
			"dimensionCols",
			"fa.manual <- runQry(\"\nSELECT   download_activity_date AS date, storeid, transactiontypeid AS transac_typeid, false AS from_errors_table\n       , SUM(units) as units \nFROM  production.fact_analytics  \nWHERE storeid = 1 and download_activity_date >= '2014-10-01'\nGROUP By 1, 2, 3, 4\n  \")\n",
			"schema",
			"period_view",
			"accounting_period_view",
			"skip.select.in_Denormalizing",
			"skip.select.indenormalizing",
			"out.right",
			"out.left"
		],
		"reverse": false,
		"show_context": false,
		"use_buffer2": true,
		"whole_word": false,
		"wrap": true
	},
	"groups":
	[
		{
			"selected": 0,
			"sheets":
			[
				{
					"buffer": 0,
					"file": "/Users/rsaporta/git/orch/src/PerformanceRights/manually load PRS society data from CSV files.r",
					"semi_transient": false,
					"settings":
					{
						"buffer_size": 3907,
						"regions":
						{
						},
						"selection":
						[
							[
								2156,
								2156
							]
						],
						"settings":
						{
							"BracketHighlighterBusy": false,
							"bh_regions":
							[
								"bh_default",
								"bh_default_center",
								"bh_default_open",
								"bh_default_close",
								"bh_default_content",
								"bh_round",
								"bh_round_center",
								"bh_round_open",
								"bh_round_close",
								"bh_round_content",
								"bh_square",
								"bh_square_center",
								"bh_square_open",
								"bh_square_close",
								"bh_square_content",
								"bh_unmatched",
								"bh_unmatched_center",
								"bh_unmatched_open",
								"bh_unmatched_close",
								"bh_unmatched_content",
								"bh_c_define",
								"bh_c_define_center",
								"bh_c_define_open",
								"bh_c_define_close",
								"bh_c_define_content",
								"bh_curly",
								"bh_curly_center",
								"bh_curly_open",
								"bh_curly_close",
								"bh_curly_content",
								"bh_angle",
								"bh_angle_center",
								"bh_angle_open",
								"bh_angle_close",
								"bh_angle_content",
								"bh_tag",
								"bh_tag_center",
								"bh_tag_open",
								"bh_tag_close",
								"bh_tag_content",
								"bh_single_quote",
								"bh_single_quote_center",
								"bh_single_quote_open",
								"bh_single_quote_close",
								"bh_single_quote_content",
								"bh_double_quote",
								"bh_double_quote_center",
								"bh_double_quote_open",
								"bh_double_quote_close",
								"bh_double_quote_content",
								"bh_regex",
								"bh_regex_center",
								"bh_regex_open",
								"bh_regex_close",
								"bh_regex_content"
							],
							"encoding_helper_encoding": "UTF-8",
							"encoding_thread_running": true,
							"incomplete_sync": null,
							"origin_encoding": "ASCII",
							"r_box_status": false,
							"remote_loading": false,
							"synced": false,
							"syntax": "Packages/R-Box/syntax/R Extended.sublime-syntax",
							"syntax_mgr_loaded": true,
							"tab_size": 2,
							"translate_tabs_to_spaces": true,
							"word_wrap": false
						},
						"translation.x": 0.0,
						"translation.y": 147.0,
						"zoom_level": 1.0
					},
					"stack_index": 0,
					"type": "text"
				}
			]
		}
	],
	"incremental_find":
	{
		"height": 23.0
	},
	"input":
	{
		"height": 31.0
	},
	"layout":
	{
		"cells":
		[
			[
				0,
				0,
				1,
				1
			]
		],
		"cols":
		[
			0.0,
			1.0
		],
		"rows":
		[
			0.0,
			1.0
		]
	},
	"menu_visible": true,
	"output.find_results":
	{
		"height": 256.0
	},
	"output.git-commit":
	{
		"height": 100.0
	},
	"output.sftp":
	{
		"height": 0.0
	},
	"pinned_build_system": "",
	"project": "PerformanceRights.sublime-project",
	"replace":
	{
		"height": 64.0
	},
	"save_all_on_build": true,
	"select_file":
	{
		"height": 0.0,
		"last_filter": "",
		"selected_items":
		[
			[
				"ath",
				"[notesDir] Spotify_Metadata_2016/Created SymLink for outDir.sh"
			],
			[
				"ush",
				"All Queries To Refresh Spotify Flat Tables.r"
			],
			[
				"r",
				"Run For Rick Please.txt"
			],
			[
				"mk",
				"supportFns/mkForecast.r"
			],
			[
				"push",
				"DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r"
			],
			[
				"jesusfordata_forecasting",
				"supportFns/jesusForData_Forecasting.r"
			],
			[
				"permeat",
				"supportFns/permeate.r"
			],
			[
				"dict.",
				"supportFns/dict.rev_summary_colnames.r"
			],
			[
				"dict",
				"supportFns/dict.GL_colnames.r"
			],
			[
				"manl_cr",
				"GL_pt3_a Create DT.manl_crop.r"
			],
			[
				"mkforecast",
				"supportFns/mkForecast.r"
			],
			[
				"ull",
				"supportFns/calculateSplitPercentages.r"
			],
			[
				"us",
				"supportFns/calculateSplitPercentages.r"
			]
		],
		"width": 0.0
	},
	"select_project":
	{
		"height": 0.0,
		"last_filter": "",
		"selected_items":
		[
		],
		"width": 0.0
	},
	"select_symbol":
	{
		"height": 392.0,
		"last_filter": "",
		"selected_items":
		[
		],
		"width": 392.0
	},
	"selected_group": 0,
	"settings":
	{
	},
	"show_minimap": false,
	"show_open_files": true,
	"show_tabs": true,
	"side_bar_visible": false,
	"side_bar_width": 225.0,
	"status_bar_visible": true,
	"template_settings":
	{
	}
}