text:
Ben Emmerson QC
Call: 1986 | Silk: 2000
seniorclerkingteam@monckton.com
"A seasoned silk who is at the forefront of human rights law." - Legal 500 2020
Which sections would you like to include in your PDF download?
Recent case news
Ben Emmerson QC has an international practice, with 30 years' experience representing individual and corporate clients before international courts and tribunals. He is a versatile litigator and has appeared at the highest appellate levels, in numerous leading cases, across a range of disciplines including public international law, public and administrative law, commercial litigation, arbitration and human rights law. He is also a recognised expert in domestic and international criminal law. A seasoned courtroom advocate, with renowned tactical expertise, he has been described by Chambers and Partners Guide to the UK Bar as "one of the ten best silks in the country".
In his international practice, Ben represents foreign governments in inter-State litigation, as well as current and former Heads of State and other political figures. His clients have included the Governments of Croatia, Cyprus, Georgia, Kosovo, and Ukraine, as well as the former Presidents of the Maldives and Catalonia, and the former Prime Ministers of Kosovo and Ukraine. He also provides advice to a number of States in Africa and the Middle East. He regularly acts in investment treaty arbitration and other international commercial arbitration disputes. He is currently leading four inter-State cases against Russia at the European Court of Human Rights, arising out the invasions of South Ossetia and Abkhazia, the annexation of Crimea and the war in Eastern Ukraine.
Within the UK, Ben advises and represents corporate clients on a range of issues relating to ethics, good governance and regulation. He is a specialist in the emerging field of business and human rights, and regularly advises multinational companies and their boards on the application of international law to their operations or supply chains. His clients in this field have included leading international oil and gas companies, communications companies and social media giants (including Facebook and Google). He also advises and represents corporate clients on a range of regulatory matters, as well as acting in alleged criminal cartel prosecutions, bribery and corruption investigations, and cases involving alleged insider dealing and market manipulation.
Ben has a strong track record of successfully representing corporate media clients in freedom of expression cases. He was adviser to the BBC, and its Director General Mark Thompson on the investigative journalism aspects of the Leveson Inquiry, and is a former Special Adviser to the House of Commons Committee on Standards and Privileges in connection with the News International Phone Hacking Inquiry.
He has appeared in more than 30 cases before the European Court of Human Rights, acting both for and against the government of the United Kingdom and other Council of Europe Member States, in cases covering a wide range of international law issues including diplomatic and state immunity, parliamentary privilege, judicial independence, and discipline within the armed forces. Ben was leading counsel for Marina Litvinenko in the public inquiry into the murder of her husband, Alexander Litvinenko, by agents of the Russian FSB. He previously represented Wikileaks founder, Julian Assange in connection with his proposed extradition to Sweden; and GCHQ whistle-blower, Katherine Gunn, who was prosecuted under the Official Secrets Acts after revealing US attempts to manipulate the UN Security Council into authorising the 2003 invasion of Iraq. He recently acted for tennis star Boris Becker, and previously represented Pakistani fast bowler Mohammad Amir on match-fixing allegations.
The current edition of Chambers and Partners identifies Ben as a "starred individual", and a "masterful silk" who is "famed for his involvement in some of the most high-profile cases of recent years". He is described as having "an outstanding reputation" and "an esteemed international practice". The Legal 500 also lists him as a leading silk across several fields of law, describing him as a "highly skilled, knowledgeable and much-respected counsel" who is "strategic, nuanced and practical" whilst being "robust and willing to commit to an opinion". In 2016, he was awarded the Lawyer Magazine's Barrister of the Year Award, and has been described by the Prime Minister as "one of the UK's most distinguished lawyers in the field of national and international human rights law".
In addition to his career at the Bar, Ben also sits part time as an Appeals Judge of the UN Mechanism for the International Criminal Tribunals for Rwanda and the Former Yugoslavia, and was (until 2017) the UN Special Rapporteur on Counter Terrorism and Human Rights. In that capacity, he reported to the UN General Assembly and the UN Human Rights Council, as well as to relevant entities of the UN Security Council. In addition to numerous thematic reports, he conducted country missions to Chile, Pakistan, Saudi Arabia, Tunisia, Sri Lanka and Burkina Faso. He was previously Special Adviser to the Prosecutor of the International Criminal Court, and a former Special Adviser to the Appeals Chamber of the UN-backed Khymer Rouge Tribunal in Cambodia.
In this country, Ben is a deputy High Court Judge, a Master of the Bench of Middle Temple, a Visiting Professor of International Law and Security at the University of Oxford, and an Honorary Fellow of Mansfield College, Oxford. He also holds an honorary PhD from the University of Bristol. Ben is a former editor of the European Human Rights Law Review, and co-author of the leading text Human Rights and Criminal Justice (3rd Edition).
The Litvinenko Inquiry [2016]. Ben represented the family of former FSB officer Alexander Litvinenko, at the public inquiry into his murder in London in 2006 by agents of the Russian FSB through by poisoning with the radioactive isotope Polonium 210.
R (Marina Litvinenko) v Secretary of State for the Home Department, [2014] EWHC 194 (Admin). Successful judicial review of the Home Secretary's refusal to set up a public inquiry to examine Russian State responsibility for the murder of Alexander Litvinenko.
Prosecutor v Ramush Haradinaj, IT-04-84bis-T, Judgment 29 November 2012. Successful defence of the former Prime Minister of Kosovo on charges of war crimes and crimes against humanity (following a trial process lasting 7 years).
Austin and others v UK, [2012] ECHR 459. The ECHR Grand Chamber judgment concerning the use of controversial "kettling" tactics by police during a May Day demonstration in 2001.
Georgia v Russia (Admissibility decision, 12 December 2011, Application No. 38263/08). Emmerson acts as lead counsel before the ECHR for the Government of Georgia in its inter-state claim in the European Court of Human Rights against Russia, arising out of the invasion in August 2008 of the autonomous regions of South Ossetia and Abkhazia. The application, which raises controversial issues of international law was declared admissible and is currently in the merits phase of the Court's deliberations.
A and Others v UK [2009] ECHR 301. The ECHR held that the UK derogation from the ECHR to enable indefinite detention of foreign terrorist suspects without trial under Part 4 of the Anti-Terrorism, Crime and Security Act 2001 ("the Belmarsh case") was in violation of the derogation provisions of Article 15. The ECHR also held that the right to a fair trial required that the person affected should be entitled to know, and respond to, the essential factual allegations made against them in closed proceedings.
Gillan and others v UK [2009] ECHR 28 (12 January 2010). Ben represented the complainants who had been detained and searched whilst handing out anti-war leaflets outside an arms fair in London. The ECHR held that the use of random stop and search powers (under sections 44 to 47 of the Terrorism Act 2000) against peaceful protestors was a violation of the right to privacy under Article 8 ECHR.
Kafkaris v Cyprus [2008] ECHR 21906/04. Ben successfully represented the Government of Cyprus in the ECHR against a challenge to the imposition of a whole life sentence on a man convicted of a terrorist murder in which a number of innocent people (including children) were killed or injured.
SSHD v JJ and ors [2008] 1 AC 385; SSHD v E and anor [2008] 1 AC 499 (Articles 5 and 6: permissible limits on the imposition of terrorist control orders).
R (Laporte) v Chief Constable of Gloucestershire [2007] 2 WLR 46. Ben represented a group of peace campaigners protesting at Fairford Air Force base which was then being used by the USAF to launch B52 bombing raids on Iraq. The House of Lords held that the police strategy of detaining them en route to the demonstration (on the ground that the demonstration was a threatened breach of the peace), turning away their coaches and escorting them back to London, amounted to a violation of the freedom of expression under Article 10 ECHR and the rights of peaceful assembly and association under Article 11 ECHR and was unlawful.
A and others v Secretary of State for the Home Department (No. 2) [2006] 2 AC 221 (Article 6 ECHR, Article 15 UNCAT: admissibility in SIAC proceedings of evidence obtained through the use of torture by a foreign state).
R (O) v Crown Court at Harrow Governor of HMP Wormwood Scrubbs [2006] 3 WLR 195: Ben successfully defended the DPP and the Home Office against a challenge to legislation restricting the power of a criminal court to grant bail in a rape case to a defendant with a previous conviction for rape.
A and others v Secretary of State for the Home Department [2005] 2 AC 68 (Articles 5 and 15: compatibility with Article 15 of the UK's derogation from Article 5 to authorise indefinite detention of foreign terrorist suspects without trial).
R v Bentham [2005] UKHL 18 (meaning of possession of an imitation firearm for the purposes of section 17(2) of the Firearmsa Act 1968).
Kyprianou v Cyprus, Application No. 73797/01, Grand Chamber, Judgment 15 December 2005 (summary domestic process for "contempt in the face of the court" incompartible with Article 6).
R v H and C [2004] 2 AC 134 (Article 6: fair trial, requirement for special advocate to represent the interests of the accused in ex parte public interest immunity proceedings in the Crown Court and the Court of Appeal).
Edwards and Lewis v UK (2005) 40 EHRR 24. The applicant alleged a violation of the right to a fair trial under Article 6 ECHR in a criminal case in which the judge had rejected his claim to entrapment on the basis of evidence which the judge had been shown during an ex parte public interest immunity application. This decision led to the introduction of the "special advocate" procedure in criminal cases, to safeguard the rights of the accused during ex parte public interest immunity hearings.
R (Middleton) v HM Coroner for Western Somerset [2004] 2 AC 182 (Article 2: state's duty to investigate allegations of state responsibility for deaths in custody, leading to the introduction of narrative verdicts at inquests where state involvement in the death, through act or omission, is in issue).
Attorney General's Reference No. 2 of 2001, Re J (Unreasonable Delay), [2004] 2 AC 72 (Article 6: right to trial within a reasonable time, remedies for unreasonable delay in criminal proceedings).
A v UK (2003) 36 EHRR 51: Ben appeared for the UK Government in Strasbourg in two cases challenging the principles of Parliamentary privilege which prevent MPs being sued for libel for words spoken on the floor of the House. In Zollman v UK he was instructed by the Cabinet Office after Peter Hain, then a Labour Minister, used a speech in the Commons to "name and shame" two Dutch diamond dealers whom he alleged to have been dealing in blood diamonds from Angola. The Government succeeded in both cases.
Pearce v Mayfield Secondary School Governing Body [2003] UKHL 34. Ben represented a lesbian teacher who alleged in the House of Lords that a school's failure to protect her against harassment on grounds of her sexual orientation amounted to discrimination under the Sex Discrimination Act 1975. This case was followed by the Employment Equality (Sexual Orientation) Regulations 2003 which prohibit employment discrimination on grounds of sexual orientation.
R v Lyons and others [2003] 1 AC 976 (Article 41: domestic implementation of a judgment of the ECHR in conflict with binding provisions of domestic law).
Fogarty v UK (2002) 24 EHRR 12. Ben appeared in the ECHR for a former employee of the US Embassy in London who had lost a claim to sex discrimination and victimisation when the Embassy claimed diplomatic and state immunity. The case turned on the compatibility of the law governing claims to state immunity with the access to court requirements of Article 6.
R v Kansal (Yash Pal) (Change of Law) [2002] AC 69 (Article 6: retrospective application of the Human Rights Act to cases decided before the Act came into force).
Z v UK (2002) 34 EHRR 3. Ben was instructed by the Official Solicitor on behalf of four children who suffered appalling neglect in their family home, but were not removed into care despite the local authority being fully aware of the conditions in which they were forced to live. The ECHR held that the conditions in the family home amounted to inhuman and degrading treatment in breach of Article 3 ECHR, and that the local authority, as the responsible institution of state, was under a positive obligation to take steps to remove them. The children (whose claim had been excluded in the House of Lords on public policy grounds) succeeded and received six figure compensation awards.
R v. Central Criminal Court, ex parte the Guardian, the Observer and Martin Bright [2001] 2 All ER 244. Ben successfully represented the Observer newspaper and its political editor Martin Bright in a landmark challenge under Article 6 and 10 to an order for the production of documents relating to Shayler's allegations.
Attorney General's Reference No. 3 of 2000, Re G (Entrapment), [2001] 1 WLR 2060(Article 6: permissible limits of police entrapment and state-created crime).
Khan v UK (2001) 21 EHRR 1016. The placing of a covert listening device in the applicant's home without primary legislation authorising its use was a violation of the right to privacy in Article 8 ECHR, but the admission of the evidence obtained through the use of the device during the applicant's criminal trial did not violate the right to a fair trial under Article 6 ECHR since the Convention does not recognise a US-style "fruit of the poisoned tree" doctrine. This case led to the introduction of the Regulation of Investigatory Powers Act.
Condron v UK (2001) 31 EHRR 1. The compatibility of legislation permitting inferences to be drawn where a suspect in a criminal investigation exercises the right to remain silent in the face of police questioning. The applicants, who had been advised by their solicitor not to answer questions, were held to have been victims of a violation of the right to a fair trial under Article 6 ECHR.
ADT v UK (2001) 31 EHRR 3. Ben successfully argued in the ECHR that the criminal prosecution and conviction of the applicant for taking part in consensual group homosexual activity in private constituted a violation of the right to privacy in Article 8 ECHR and the protection against discrimination in Article 14 ECHR.
Foxley v UK (2001) 31 EHRR 25. Interception of legally privileged correspondence found to violate the right to a fair trial under Article 6 ECHR and the right to privacy under Article 8 ECHR.
NHS Trust A v MNHA Trust B v H [2000] AII ER (D) 1522: Emmerson appeared for the official solicitor in the first case under the Human Rights Act to determine whether the withdrawal of life support (artificial nutrition and hydration) to insensate patients in a permanent vegetative state is compatible with the right to life in Article 2.
McGonnell v UK (2000) 30 EHRR 289. The case concerned the concentration of judicial, legislative and executive functions performed by the Bailiff of Guernsey in breach of the constitutional separation of powers, but led in part to the separation of the functions formerly concentrated in the Lord Chancellor, and the establishment of the Ministry of Justice.
Smith and Grady v UK (2000) 29 EHRR 493. Ben appeared in the ECHR for two gay service personnel challenging the exclusion of homosexual servicemen and women from the armed forces, and the adequacy of judicial review on established Wednesbury principles. This successful challenge led the MOD to abandon its policy of excluding homosexuals from all three armed forces.
Osman v UK (2000) 30 EHRR 245. The seminal ECHR decision stablishing for the first time the state's positive operational obligation to protect the right to life under Article 2 ECHR.
P v S and Cornwall County Council, Case C-13/94 [1996] IRLR 347. The leading case in the European Court of Justice in Luxembourg holding that Council Directive 76/207/EEC on the implementation of the principle of equal treatment for men and women as regards access to employment ("the Equal Treatment Directive") prohibited dismissal of a person with gender identity disorder who, whilst employed, underwent male to female gender re-assignment treatment.
Benham v UK (1996) 22 EHRR 293. Liability of the State to pay compensation in cases of wrongful imprisonment for non-payment of local authority taxation.
Welch v UK (1995) 20 EHRR 247. Retrospectivity of drug trafficking confiscation order. The first successful case in the ECHR under Article 7.
Administrative & Public Law: "Ben is well recognised for his major role in civil liberties and human rights matters." "He's very well known and highly regarded in terms of his ability." – Chambers UK, 2020
Crime: International Criminal Law: "He is one of the outstanding people in this area and is truly a go-to person for international criminal law." "He is very experienced, has a top-drawer intellect and is effective as an advocate." – Chambers UK, 2020
Civil Liberties and Human Rights: "Ben is well recognised for his major role in civil liberties and human rights matters." "He's very well known and highly regarded in terms of his ability." – Chambers UK, 2020
Administrative & Public Law: "Well-known for international issues." – Legal 500, 2020
International Crime and Extradition: "Highly experienced in representing foreign governments in inter-state litigation." – Legal 500, 2020
Civil Liberties and Human Rights: "A seasoned silk who is at the forefront of human rights law." – Legal 500, 2020
Administrative & Public Law: "As well as providing invaluable strategic oversight, his direct and on the ball representation is consistently impressive and reliable" – Chambers UK, 2019
Civil Liberties and Human Rights: "He is truly outstanding and a real champion for human rights. He's hard-working, determined and always goes the extra mile." – Chambers UK, 2019
Crime: International Criminal Law: "His direct and to-the-point advice is consistently impressive and reliable. He offers those that instruct him invaluable strategic oversight." – Chambers UK, 2019
Crime: "Always goes the extra mile, which takes hard work, determination and courage." – Chambers UK, 2019
Administrative & Public Law: "I have been consistently impressed with his quality." – Legal 500, 2018
International Crime and Extradition: "Clever, robust and willing to commit to an opinion." – Legal 500, 2018
Civil Liberties and Human Rights: "A highly skilled, knowledgeable and much respected counsel." – Legal 500, 2018
Inquest and Inquires: "He sees the bigger picture and his advice is always strategic, nuanced and practical." – Legal 500, 2018
Administrative & Public Law: "His advocacy has been stellar. And his ability to highlight winning points at an early stage of a case is also exceptional. " – Chambers UK, 2018
Civil Liberties and Human Rights: "He is really impressive on his feet, and he can turn an argument into something elegant and critical. He is amazing to watch." "Ben is very bright. He has intellectual vigour and he goes in and takes no prisoners."– Chambers UK, 2018
Crime: "Ben is extraordinary advocate and a real lawyer's lawyer. He can also really articulate matters to a client." – Chambers UK, 2018
Inquest and Public Inquires:"He is an astonishingly good advocate." – Chambers UK, 2018
Administrative & Public Law: "An excellent public lawyer and a strong advocate." – Legal 500, 2017
Civil Liberties and Human Rights: "A powerful advocate." – Legal 500, 2017
Inquest and Inquires: "A fine legal mind." – Legal 500, 2017
International Crime and Extradition: "He has an enviable instant recall of the law and he ability to communicate it succinctly." – Legal 500, 2017
Administrative & Public Law: "He is a heavyweight and his reputation is first-rate." "He is terrific, he has strong public profile and makes great choices in cases." – Chambers UK, 2016
Civil Liberties and Human Rights: "His work in Litvinenko is no mean feat – forcing a public inquiry is down to the sheer force of his personality." – Chambers UK, 2016
Crime: "He is a fantastic advocate who brings theatricality to the dry cases, particularly where being in the public eye is wanted. He is not fussed by unpopular causes or having the media breathing down his neck." – Chambers UK, 2016
Crime: International Law: "He is universally regarded as being phenomenal because he is very bright, very hard-working and very effective." "His preparation and presentation are second to none." – Chambers UK, 2016
Inquest and Public Inquires: "Always formidable." "He is terrific, he has strong public profile and makes great choices in cases." – Chambers UK, 2016
Administrative & Public Law: "An excellent public lawyer and strong advocate; a real star." – Legal 500, 2016
Civil Liberties and Human Rights: "One of he best in the area of civil liberties and human rights." – Legal 500, 2016
Inquest and Inquires: "He is a real driving force." – Legal 500, 2016
Civil Liberties and Human Rights: "An advocate of the highest calibre." – Legal 500, 2015
Crime: "A fine barrister." – Legal 500, 2015
Inquest and Inquires: "His name speaks for itself." – Legal 500, 2015
United Nations special rapporteur Ben Emmerson QC is a "superb lawyer, who is extremely intelligent". He has "market-leading tactical expertise" and is "massively in demand" for human rights cases. Commentators note that he has "the ability to put together fantastic packages of ideas" and "is able to work minor miracles" with the cases before him. Many of his matters are international in nature and he has vast experience of handling cases in the European Court of Human Rights. – Chambers & Partners, 2012
In the field of human rights, he is "one of the best in terms of courtroom performance. Extremely lucid, clear and forceful, he sweeps the judges along with him". He is "one of the ten best silks in the country". – Chambers & Partners, 2011
"When it comes to international human rights law, his vast knowledge and experience place him at the top of the tree. He is the man to plump for if you have a criminal law case with a strong human rights angle to it". – Chambers & Partners, 2011
Ben Emmerson QC is a "formidable opponent due to his mastery of the issues", and is "pre-eminent in his field and impossible not to look up to". As a criminal lawyer he is "exceptionally gifted, with a wonderfully analytical, first-class brain". – Chambers & Partners, 2009
"Absolutely at the top of his game," Ben Emmerson QC elicits rave reviews from all corners. Sources marvel at his "ability to read the court and harness his leviathan intellect to tackle the facts of a case." Ben Emmerson QC enjoys a stupendous reputation. Brilliant on civil liberties and public law issues, he possesses a "first-rate knowledge of the law and prepares arguments well." – Chambers & Partners, 2008
Recommended in Human Rights and Civil Liberties, Ben Emmerson QC is "beyond praise" and takes "an intellectual approach to cases". – Legal 500, 2008
Ben Emmerson QC is "the first person to call on" and "a beneficiary of enormous respect" in public and administrative law. He is "a leading presence in the field of human rights". – Chambers and Partners, 2007
Ben Emmerson QC is "outstanding". He is "clearly a real leader" in the human rights field and has a "massive reputation". – Chambers & Partners, 2006
Ben Emmerson QC has "a reputation founded on an astonishing series of cases" before the ECHR. He can "turn his hand to anything, deploying beautifully constructed arguments". In the field of human rights law, he has "a pedigree that doesn't need endorsement". A combination of "incredible determination" and "encyclopaedic knowledge" makes him a force in European human rights law. – Chambers & Partners, 2005
Ben Emmerson QC is "head, shoulders and everything else" above the rest for European human rights law. – Chambers & Partners, 2003
Bristol University


Busted out and back at Barnstaple - thank goodness!
I would have donated more if it would have guaranteed your permanent incarceration!!
A very good cause (both the Hospice and locking Chris up).
This payment is to keep you locked up! Great effort Chris. Well done!
We need Chris back in the business! Nothing is happening without him here.
Good luck in making your escape!


DAVID Miliband was the first out of the traps in the race to replace Gordon Brown as Labour leader.
And he won the immediate backing of Valerie Vaz – the new Labour MP for Walsall South.
The former foreign secretary announced yesterday that he would be standing for the Labour leadership, saying the task for the party was to present itself again as "an alternative government".
Surrounded by Ms Vaz and other supporters on the steps of the Houses of Parliament, said: "We now have a contest to succeed Gordon as leader of the Labour Party.
The leading Blairite has always left little doubt of his ambition, though some insiders have questioned whether he has the personal steel and the breadth of support in the party needed to seize the crown.
Mr Miliband, aged 44, was a close ally of Tony Blair from the earliest days of New Labour, working for him in opposition from 1994 and heading the Number 10 policy unit during his first term in power.
Even before he became an MP, he was a key figure in reshaping the party's agenda, nicknamed "Brains" by Alastair Campbell for his powerful intellect and mastery of policy detail.
Parachuted into the safe seat of South Shields shortly before the 2001 election, he was a minister within a year and joined the Cabinet in 2005, rising to become Environment Secretary, where he put the issue of climate change firmly on the agenda for the first time.
Setting out his stall for what will be a heated contest, Mr Miliband said the party had to be ready to return to power.
Other candidates have yet to throw their hat into the ring.
But possible contenders include Ed Balls, the schools secretary, Mr Miliband's brother Ed, the former energy and climate change secretary, and Jon Cruddas, who stood for the deputy leadership won by current acting party leader Harriet Harman in 2007.
Jack Straw and Andy Burnham may also put their names forward.
Great BarrGreat Barr stabbing: Boy, 12, arrested on suspicion of robbery after boy knifed in headThe 12-year-old victim is currently recovering from his injuries which are described as "not serious."


text:
Q: Eloquent 2 left join query I would like to execute the following query using Laravel's eloquent query builder:
SELECT a.*, b.day, c.sex FROM hours as a
left join reserves as b
on a.id = b.hour_id and b.day = '2015-12-12'
left join doctors as c
on a.doctor_id = c.id
where a.doctor_id = 1;

I have tried the following:
Hour::leftJoin('reserves', function($join) {
    $join->on('hours.id' , '=' , 'reserves.hour_id')
        ->where('reserves.day' , '=' , '2015-12-12');
})
->leftJoin('doctors', function($join) {
    $join->on('hours.doctor_id', '=', 'doctors.id');
})
->where('hours.doctor_id', '=', $doctorId)
->get();

Unfortunately, I am not getting the same results.

A: Everything looks fine, however you miss selecting columns, after Hour:: you should add:
select('hours.*'.'reserves.day','doctors.sex')->

You could also make second join simpler and use aliases, so the final code could look like this:
Hour::select('hours.*'.'reserves.day','doctors.sex')
     ->from('hours AS a')
     ->leftJoin('reserves AS b', function($join) {
         $join->on('a.id' , '=' , 'b.hour_id')
        ->where('b.day' , '2015-12-12');
     })
    ->leftJoin('doctors AS c', 'a.doctor_id', '=', 'c.id')
    ->where('a.doctor_id', $doctorId)
    ->get();

Of course as $doctorId you should set 1 to get exact same result

A: you can use DB::raw :
Hour::select(DB::raw('hours.*'),reserves.day, c.doctors)
->leftJoin('reserves',DB::raw("hours.id = reserves.hour_id AND reserves.day='2015-12-12'")  ,DB::raw(''), DB::raw(''))
->leftJoin('doctors','hours.doctor_id', '=', 'doctors.id')
->where('hours.doctor_id', '=', $doctorId)
->get()

the 2 empty DB::raw is because leftJoin expect 4 arguments(table,columnA,operator,columnB)

redpajama_set_name: RedPajamaStackExchange


Which tapes is 12mm black on white please?
The versatile Brother PT-1005BTS handheld labelling machine delivers durable labels for all-around use in the house or office. Whether it's fabric labels for PE kits or long-lasting labels for frozen food, the Brother PT-1005BTS labeller can deliver it. This battery-powered labelling machine uses an ABC keypad as opposed to the usual QWERTY keypad.
The handheld Brother PT-1005BTS printer comes in silver and sky blue. It has a manual cutter on its upper-right corner and a large LCD display on top. Below the display are function buttons, a numeric keypad and ABC characters. Tapes and batteries go at the back of the Brother PT1005BTS label machine. It features 83 symbols and 292 characters and offers 8 print styles, 6 font, sizes, and 5 frames.
The P Touch 1005BTS label maker comes with standard 6 AAA batteries but the AC adapter isn't offered as standard and is an additional cost. It would be better if the PT 1005BTS labeller was fitted with a QWERTY keypad.


I would like to tell you how extremely happy I am with the service provided by Tee, she is extremely skilled and has given me the exact look I desired. A true professional and I will ensure to recommend the clinic to all my friends and family.
Dr Peter - Thank you for taking the time to listen . I have always been conscious in face to face situations but immediately I had amazing results and my confidence has been completely renewed. I am only sorry I did not find you sooner.
Please pass my thanks to Dr Peter - excellent service, very patient. I will definitely come back for more treatments.
Dr Peter genuinely cares for patients as individuals and you feel as if you have been listened to and understood. Regardless of your skin condition I would highly recommend this clinic!
I had my treatment with Tee yesterday - she was fab and I love the results.
I've been going to Melior Clinics for years – everything you'd want and expect.
Dr Peter – you are the Botox king!
I would like to give a big thank to Dr Tim - you were so supportive. Your great effort and efficient work improved and lifted up my facial appearance.
Without fail Melior has made me feel so welcome, comfortable and at complete ease. Dr Peter is an absolute gentleman and his professionalism is of the highest standards. I can only say he works miracles! As for the first time in years I can look in the mirror and like the reflection, I never believed this would be possible.
Tee - just wanted to say I'm chuffed to bits with my Botox and filler results. So happy with how much my frown line has disappeared and how quickly the Botox worked. By day 3 my lines had disappeared. So thank you.
I'm absolutely thrilled with the results - the transformation is incredible. I just wish I'd had this done ages ago. Fantastic!
Thank you! Such fantastic customer service.
I would just like to say a very big thank you to you for making my experience at Melior an extremely comfortable and positive one.
I am really excited that a clinic has opened in Sevenoaks for Botox and other facial aesthetics. Previously, I had thought I needed to go up to Harley Street for reassurance but Dr Tim is an expert in the field and I'm completely happy to visit him here. He is experienced and interesting to talk to about creative uses of botox - such as for migraine - and completely trustworthy for the traditional forehead lines and wrinkles too. I feel total confidence and I'm looking forward to visiting again.
I'm currently having laser hair removal with Daniel and so happy about just going for it. Daniel is the best person I could have met with regards to getting this done; really puts you at ease.
I was very impressed by the service, efficiency, treatment and care.
I'm very happy to say that I found Dr Peter to be most professional and knowledgeable, which was very reassuring. I had some Botox treatment done, which has worked very well. I am sure that I will, in future, be making appointments with Melior clinics for any further treatments.
Dr Peter really was first class. He explained everything from start to finish. Huge thank you to him and his team. Will definitely be back for more treatment. Thank you.
Dan really is a lovely gentleman. Tim must be privileged to have him on your team.
You guys are extraordinary. And thanks for the smile you have put on my face.
Hyperhidrosis made a complete and total difference! Great customer service.
I am so pleased with the hyperhidrosis treatment I have had at your Reading clinic - it really has made a complete and total difference, allowing me to wear what clothes I want now with confidence and no embarrassing sweat marks. 100% improvement. Also great customer service. Many thanks.
A couple of months ago I had Botox treatment for the prevention of migraines, and I'm extremely thankful to Dr Timothy Beazleigh who carried out the procedure as I have felt so well since.
I would like to thank to Dr Tim for the excellent care as he provided me for dermal fillers. Looks amazing. A big thank you.
Thank you for the efficient and caring way that you respond to your clients, it is much appreciated by me.
I'm very happy with the treatment and all the info Therese sent me. She's amazing and very passionate about her work. I'm so glad to have found this company.
...thanks to all the staff and Dr Tim for an exceptional experience today. I arrived with fear of the unknown and somewhat anxious, but I need not have worried. I was immediately put at ease, seen swiftly and treated with honesty and care. I came out feeling a million dollars even without the treatment effect having taken place yet.
I want to thank you for such a great customer service.
I just wanted to thank you again Tee for the treatment I received. I am well chuffed with the result, it has made me feel a lot better - I look more like myself again.
I just wanted to say a big thank you to Therese for what you have done. Not only that how comfortable you made me feel and instantly trusting you. It has been a pleasure.
Dr. Peter is an excellent doctor.
Dr. Peter is an excellent doctor. Please pass my thanks to him.
I could not be any more pleased with the results. It's absolutely amazing!!
I first came to see Dr Tim Beazleigh in January 2013 to discuss a Botox treatment for the chronic migraines I suffered with. For the last 18 months I had been taking three Propranolol tablets per day as a form of treatment for my migraines and (when needed) a Rizatriptan tablet. On average, I would get between 2-4 migraine attacks per month.
After the consultation with Dr Beazleigh, I decided to try Botox as a form of treatment and stop taking the Propranolol. I am extremely pleased to say that it has completely stopped any form of migraines and has overwhelmingly changed my life.
I would (and do) recommend to anyone I meet that suffers with migraines to go and see Dr Beazleigh to discuss Botox treatment. I could not be any more pleased with the results. It's absolutely amazing!!
Just wanted to say thank you very much!!
I love the shape of my face.
The Botox has taken its shape and the result is fab! Thank you.
Just a note to say how delighted I was with the treatment I had at Sevenoaks by Dr.Beazleigh. Having been pretty nervous beforehand I was pleasantly surprised how comfortable it was. I look really refreshed and my face has a much nicer shape and less lines. Thank you so much and hopefully I can visit again in the future.
I just wanted to thank Tim for the treatment I had yesterday. I'm very pleased with the results!
I love the results. There is no heaviness in the eye-lid region and my eyes actually look more even now than ever before, so whatever you did there was brilliant. I will definitely be looking at having a complete re treatment with you again. My 41st birthday was last week and I still look 22!
I wanted to thank you for making all the treatment sessions a comfortable experience for me. I'm very self concious about the sweating problem but you put me completely at ease, so much so I almost forgot you're repeatedly jabbing needles in my arm.
I'm thrilled... that I was able to catch up with you for a second appointment in London... I'm feeling like a new woman! You're great at what you do and I hope to manage a visit to you again in the future.
Can you thank Tim for me, I'm delighted with the results. Just the right amount! Looks really natural.
I had Botox the other day with Tee in Peterborough - she is amazing! Wonderful experience and I will certainly return when I need to.
I am so happy with the treatment I received at Melior Clinics in Huntingdon. Therese made me feel so comfortable from the onset and answered all my questions thoroughly and honestly. I had Botox somewhere else before and I was very unhappy with the results, so I would suggest that anybody considering having any treatment to go to Melior Clinics. It's now been two weeks and four days later and I have had friends tell me how fresh I look and a few work colleagues who I have not told, said that I was looking really great and young!!!!
I am already saving for my next visit.
Just to let you know that the Botox for hyperhidrosis is amazing!! It's changed my life. So thanks for that.
Just back from tour and wanted to let you and Therese know the job was done brilliantly. Tee was just lovely and really put me at ease. I am far more confident in myself now! Thanks!
I received your Company's recent follow-up e-mail, thanks, and just wanted to say thanks to Tim - I'm thrilled with the results so far. The change to my mouth in particular is amazing, no more miserable down tilt! So... one very happy and satisfied customer!
I looked at myself and my life closely last year as I was coming up to 50, I was not impressed with myself, I looked snappy, too thin, scrawny and tired looking.
I went on to have 'Sculptra' I had 3 sessions a month apart. The treatment comprised of injections that stimulate the collagen, tighten and lift the whole face. The effects last 2 to 3 years. It expensive but absolutely worth it. At the moment and for the next few years this treatment has taken away any thoughts of having a facelift.
I hope this magic will last!
As you know, I had three consecutive treatments during the last half of 2006 and, as a result, truly feel that I have got my face back. I am writing to let you know how pleased I am with the results I have had with Sculptra™, over the last few months.
After my mid thirties, following childbirth and ensuing weight loss, I noticed a gradual, yet noticeable, loss of shape to my face. My cheeks sank and my skin began to fold, casting unattractive shadows across my face, which was exaggerated by certain types of light, day or night.
Now, following Sculptra™ treatment in my mid forties, I have a more rounded and youthful appearance to my face and when I look in the mirror, I believe that the person I am is the one that still smiles back.
I have had two treatments and am eagerly awaiting the third.
After two Sculptra™ treatments, the change is particularly noticeable around my chin area where I had deep lines - they are still there but not as deep as they were. I have people saying to me that my skin looks fresher and someone had the cheek to ask if I had had anything done as I looked younger! I can also feel the difference on my face.
I think that because the treatment takes a while to really stimulate the collagen, the difference is more subtle and all of a sudden you realise that it is fairly noticeable, rather like a reverse ageing process. When I looked at the 'before' photos I realised just how much of an improvement the Sculptra™ has made. We get used to our faces but I definitely feel more confident about my looks since the Sculptra treatment.
I was so delighted with the results of my course of treatments with Sculptra™ I felt compelled to write to tell you.
I am 51 years old and had quite a lot of wrinkles, three courses of Sculptra™ have transformed my face, it now looks plumper and younger, whilst the lines are still there they are considerably reduced giving an extremely natural youthful look to my face. Many people have remarked on my 'well being' but as it was a gradual process no-one has any idea I have had help!
Thank you for your wonderful product.
I have suffered from underarm hyperhydrosis for about 11 years, during this time I have searched in desperation for some relief from this condition, trying everything from aluminium chloride deodorants and ionotophoresis to surgery. I also suffered an extremely painful and ineffective treatment of botox from what was obviously an inappropriately trained practitioner. After having exhausted all available treatments I resided myself to living with this condition.
The Melior clinic was introduced to me purely by chance and after having the opportunity to discuss at length my previous botox treatment and learn that the discomfort and results I experienced were not normal, I went ahead with a further treatment.
The results have changed my life! I am now able to enjoy life without the constant embarrassment and anxiety this condition brings. I am free to wear the clothes I want to rather than those that disguise the problem and as a result I have developed a new hobby – clothes shopping!
Without the support, compassion and extreme patience of Dr Beazleigh I may never have given this treatment a second chance!
Some years ago I fell down a hole, resulting in hitting my face on a rock. After a number of years my face became unsymmetrical. I started to look for non-surgical treatments. One day, I was passing Melior Clinics and decided to go in.
I saw a consultant called Tim. He was very honest about what I should expect from all the different treatments. After a long discussion we decided on Sculptra. Having had several treatments I am delighted with the results. My overall appearance has improved beyond my expectation. I now have a symmetrical face.
Thanks for all the help and encouragement from all the staff, especially Tim. I found Melior Clinics to be very professional and friendly. I am very happy with the advice that was given and have experienced top class treatment.
I can definitely recommend Melior Clinics.
I have just received the most amazing treatment at the Melior Clinic in Huntingdon. The patience and care and the time taken to explain everything was absolutely wonderful.
I am delighted with the result of my treatment – it's even better than I dared to hope for.
It was all done really quickly and so gently I was hardly aware of what was happening and the result is, for me, a miracle!
Although I was aware that my face and skin needed a freshen up, cosmetic surgery was a step too far for me and one I was reluctant to take. I approached Melior Clinics who arranged a free consultation where I was able to discuss concerns about my appearance, the treatments available, and the possible side effects.
Their specialist, Therese Ward, was able to reassure me at every level and she recommended a personal treatment programme for me including Botox.
I can genuinely say I am delighted with the results of the treatment - it's made all the difference and my skin and smile really reflect who I am and how I feel. The whole experience was really positive, especially as Melior stayed in contact after treatment to see how I was getting on.
By the way, the lady I saw [Dr Jouli Chamoun] was wonderful and made me feel very secure that my decision to move from my usual clinic was a good one!
During the treatment you made me as comfortable as possible. At times I even totally forgot about the fact you were using needles! It just did not hurt as much as I expected. It was all done with minimum discomfort. I have to say I came away looking totally natural.
You provided me with an excellent service. The whole process was like a breeze. This I why I came back. I've got my moneys worth. Just need you to know you have forever made me a loyal patient to you. I will not look elsewhere. Keep up the wonderful effort.


text:
Include journalists, temple servitors for Covid vaccination: Odisha govt
March 17, 2021 Government
Bhubaneswar: The Odisha government on Wednesday requested the Centre to include journalists, servitors of Jagannath and Lingaraj temples, employees working at airports, railways and seaports and others engaged in maintenance of essential services as front line workers for Covid-19 vaccination.
Additional chief secretary (Health) P.K. Mohapatra wrote a letter to the Union health and family welfare secretary in this regard.
Mohapatra informed that many categories of persons who are at risk of exposure to infection due to the nature of their work have not been included as frontline workers.

redpajama_set_name: RedPajamaCommonCrawl


The NFL will continue to see healthy ad revenues despite some obstacles in its path, Kantar Media predicts.
As the NFL season gets set to kick off, Kantar Media Chief Research Officer Jon Swallen is expecting another banner year in terms of TV ad revenue despite last year's ratings declines in prime time and lingering concerns about everything from oversaturation to player conduct and concussions.
Last year, ratings dipped significantly in prime time, though the late-afternoon games on Sundays managed single-digit increases over 2015 levels. "Even with that ratings correction, it's one of the largest and most reliable pieces of programming out there, so I expect that NFL revenue will increase," Swallen told FierceBroadcasting.
According to Kantar, total media spending on the NFL reached $4.22 billion in 2016, up 22% from $3.45 billion in 2014. Swallen declined to project an exact number for 2017, but said the pattern for the league is falling in line with the upfront ad market for broadcast networks, which has shown increases despite overall ratings erosion.
That disconnect is "part of the perversity of broadcast television," he said. "People wonder, if ratings are getting smaller, how can ad revenues rise? It seems illogical. But the fact is that audiences are shrinking across the board. So advertisers are attracted to the NFL because of its consistency." The male skew, with regular season games drawing an audience that is 60% male, also offers a predictable platform.
A host of theories have emerged to explain the recent dips in football viewership. They range from public dismay at players kneeling during the national anthem to players' off-field misconduct to heightened awareness of concussions to the rise of rival hard-hitting sports like the UFC.
Far more serious than any of those, Swallen says, is "the land-grab that the NFL has attempted by continually trying to expand their distribution." The league has launched a regular Twitter show and will stream Thursday night games on Amazon. It also has focused on building out the Thursday Night Football franchise over protests that the games are of questionable quality and simply add one more dish to an already overstuffed buffet table. "It's a smart business move," Swallen says. "But there's an argument that it leads to oversaturation and leads to viewers thinking the NFL is something less special, even grating. They think, 'Ugh, more football?!'"
Swallen dismisses concerns about the ad market generally, which has seen turbulence this month as media buyers reexamine their mix of digital and linear TV investment. Some, including consumer-products giant Procter & Gamble, are pulling back from ads in general and seeing no ill effects at retail.
"You have to consider the composition of advertisers attracted to football," he says. "P&G doesn't spend money there." Three main verticals—automotive, telecom and financial services—account for roughly half of all football spending and show no signs of retreat.


Hanstel again, and some intrigue!
Well it does look like Gretel tried to do something to distract herself while waiting, but it also seems that her brother wasn't pleased.
Still, it makes me wonder if Hanstel meant Velvy and his abilities and maybe find a way to temporarily neutralize it. Maybe they can help Velvy ?
Maybe Dr. Muffet figured something out to help Velvy ?
I curious as of what Hansel thinks of Dr. Muffett and his genius ?
I also wonder who the final member of this team is ?
I find it interesting that Hanstel considers, at least in part, Gretel and himself to be the same person.
Also, Gretel draws smiley faces, and letters. And seems to know how to get her way, at least a little.
Gretel can draw about as good as a 4- or 5-year-old, which is kinda above her mental capacity, but sometimes I think she feeds off Hansel's smarts.


Wishing you were here . . .
Lincoln, Rachel and Prairie take time to pose in mock-glare before they pulled our well. They are a bit . . . glum, that Sidney is not home to share their well-pulling woes.
They remember all too clearly, the hard labors of pulling the well 3 years ago . . .


text:
Meet CHR's
Quarab Mare, Riddle
While in the profession of working with animals, there is always the somewhat unexpected risk of falling head over heels in love for (at least) one of the creatures. Horse trainers are absolutely not omitted from that rule. If anything, we fall into its extremities! One mare in particular has wriggled her way into my heart. Even though she started out as a challenging case, working with Riddle has proven to be a wholly rewarding and special experience. Today, I am extraordinarily excited to get the chance to share this story of CHR's stunning Quarab mare, as well as her continuously amazing progress in training.
Colorado Horse Rescue was able to save Riddle through an auction intercept. Meaning, that even though her owners had intentions of bringing her to the local livestock auction, we were able to intervene before she ever set foot onto that property. Based on the background we were given, we believed that she would be a confident riding candidate. Yet, during the evaluation process, her personality showed a mare with countless insecurities over human beings, both on the ground and in the saddle. She came in as a distraught horse in need of high levels of support in order for her to feel safe in her environment. When support was lacking, she would become nearly uncontrollable as she turned frantic and frenzied. If flight wasn't working, in some cases she would often times resort to shutting down, becoming seemingly quiet though very far away mentally. It was heartbreaking to watch her go through this self-made coping mechanism as she tried to distance herself from us in any way that she could manage.
When it was time to bring Riddle up for consistent schooling, I decided that the best course of action was to restart her and see where her training was lacking. With hopes of building up her confidence, I could start from the beginning and fill in any holes in her education as we worked literally from the ground up. The first several sessions with her were difficult.
Riddle's first reaction was to run around in a frenzy and call out, looking for someone to save her. Unlike many of the other horses that I've worked with at CHR, it was extremely hard to help her feel comfortable enough to even accept food from me – so positive reinforcement was a no-go during these first stages. I had to rely almost solely on pressure and release for communication, giving rewards only when she would accept them. It was only after a few weeks of exclusive groundwork that I began to see a shift in Riddle's temperament. Her outbursts of anxiety were becoming less frequent as she was seeming to look towards me more and more for support. I was slowly able to build a thorough system of communication, both completely loose and on the halter. With her confidence in me growing, I soon felt that she was ready to move on to the next step: riding! I have found so much joy in my work helping Riddle become a reliable and self-assured horse. While she evidently had been ridden a great deal before she reached us, it was clear she still had many insecurities. For example, accepting steering as well as moving forward into larger gaits was extremely difficult for her.
With each and every ride she has shown huge improvements. Even though she still shows signs of anxiety now and again, with a handler that is confident she is quickly turning into a willing partner. Stay tuned into Riddle's story! CHR has high hopes for this mare and her journey. In the future we plan on taking her out on field trips to expose her more to the world and hopefully prepare her for a successful riding career.
Learn more about Riddle here.
A Holiday Homecoming for the Unbranded Horses, JR and Bam Bam!
JR and Bam Bam, once wild BLM Mustangs, were stars in the movie Unbranded where they made an epic 3,000 mile journey border to border from Mexico to Canada through our public lands.
Valiente's Training Environment
Here is another installment from the Colorado Safari Properties blog about our handsome Valiente!


When I am creating a link to a file, the link only works properly if the filename contains no spaces (usually create this link by dragging the file from Finder/Path Finder). That is all the characters up to the first space are turned into a hyperlink, the rest is ignored.
You need to precede the space in a filePath with a backslash.
Jesse's last note on this was, I believe, the one below, but it may refer to work in progress rather than the current build.
Brilliant, I've got that hooked up to a Keyboard Maestro hotkey now. Thanks muchly!
yeah, thank you works great!
A Keyboard Maestro version for copying the encoded url(s) of the selected file(s) in Finder or CocoaTech PathFinder.
This occurs whether I copy the link into TaskPaper or type the link inside TaskPaper.
I think I just found the bug. Right now it only works if you escape one space… but if the path has more then one space it won't open the file and you'll see that dialog. I've just fixed for the next release.


Barclay Cleo Single Basin Undermount Bathroom Sink Bisque 4 715BQ $182.79 Barclay Undercounter Sink. Cleo Collection. Vitreous China. Round Bottom. Rectangular. 201/4 Width x 141/4 Depth. Basin Interior: 177/8 x 121/4. Basin Depth: 61/4. Back of Basin to Center of Drain: 43/4. Mounting Clips Required (Not Included). Drain Not Included.
Tuscany All in One Dual Mount 1 Stainless Steel Single Bowl Bar Prep Sink.
Single faucet hole. 0 Starting at 0.
Barclay Undercounter Basin 1 x 1 ID.
Kraus Elavo White Ceramic Small Rectangular Undermount Bathroom Sink w Overflow. Add to Cart. 00 JSG Oceana Glass Undermount Lavatory. Kohler K 10 Starting at. Ronbow Square Tapered Ceramic Drop in Bathroom Sink in White 00 0 1.
Browse the widest variety of Barclay and select a new look to your home.
00 Wash Basin 1 Barclay Wash Basin Kohler 5 Ft Acrylic Bathtub W Tile Flange And Drain Almond K 1123 La 47.
Brand Barclay Jayden Wall Hung Basin White Wall Mount Bathroom Sinks.


text:
Q: How Do I Calculate This Improper Integral? i need some inspiration for this integral. The question:
Calculate for an n element N this improper R-Integral
$$
 \int \frac {1} {\prod_{i=1}^n (1+x_{i}^2)} d(x_1,...x_n)
$$
I am sitting here for 4 hours and i have no idea what to do. Thanks for your help!

A: Assuming you want
$$
\int_0^\infty \frac {1} {\prod_{i=1}^n (1+x_{i}^2)} d(x_1,...x_n),
$$
because the function is a product function, this is simply the product of the iterated interals: namely,
$$
\int_A\int_Bf(x)g(y)\,dy\,dx=\left(\int_Af(x)\,dx\right)\left(\int_Bg(y)\,dy\right).
$$
So
$$
\int_0^\infty \frac {1} {\prod_{i=1}^n (1+x_{i}^2)} d(x_1,...x_n)=\prod_{j=1}^n\int_0^\infty\frac1{1+x^2}\,dx
=\prod_{j=1}^n \frac\pi2=\left(\frac\pi2\right)^n.
$$


text:
service-download (1)
Mineral resources (9)
Mines (6)
Ores (5)
Geochemistry (5)
Boreholes (4)
Mineral resource maps (4)
Quarrying (4)
Mineral economics (3)
British Geological Survey (38)
University of Exeter (3)
University of Manchester (2)
University of Lancaster (1)
University of Leeds (1)
Edge Hill University (1)
Universidad Santo Tomás (1)
BGS (38)
DIGITAL - Digital format (2)
Digital Map (2)
ESRI Shapefile (2)
ESRI shapefiles (2)
GIS polygon data. (ESRI, MapInfo, others available by request) (3)
Geographic Information System (2)
Geographic Information Systems (2)
PAPER - Copies will be produced by the most appropriate methods available. (2)
Paper Map (2)
image/png (2)
Vector (11)
Irregular (13)
Not planned (7)
notEntered (1)
BGS World Mineral Statistics service (WFS)
This service provides access to the World Mineral Statistics database data.
Zeta potential measurements of the fluorcarbonate mineral parisite (NERC grant NE/M011429/1)
Zeta potential measurements of the fluorcarbonate mineral parisite-(Ce), under water, supernatant and collector conditions. Zeta potential measurements can be used to indicate the surface behaviour of a mineral under different reagent conditions. Mineral surface behaviour is important in processing and extracting minerals from their host ore, which can be energy intensive. Parisite-(Ce) is a fluorcarbonate mineral which contains rare earth elements. Rare earth elements are important in a wide range of products from iPhones to wind turbines.
Crushed Rock Inter-Regional Flows
Derived from data collated from the 2005 Aggregate Minerals Survey, carried out by BGS for the Department for Communities and Local Government (CLG) which provide an in-depth and up-to-date understanding of regional and national sales, inter-regional flows, transportation, consumption and permitted reserves of primary aggregates for England and Wales. The information is used to monitor and develop policies for the supply of aggregates. This data set depicts the flow of crushed rock aggregate between the regions of England and Wales. The data originator also has similar data for sand and gravel and also the same data derived from the 1997 and 2001 Aggregate Minerals Surveys.
Mineral Veins Of The Southern Pennine Orefield
3200 mineral veins (i.e. lead, fluorspar) of the Southern Pennine Orefield within the Peak District National Park captured as a single dataset in 1983 from BGS 1:10 560 published maps with additional veins from referenced literature. The data covers a small, very limited area. Also includes several pipe and flat deposits. Also includes mapped faults. The dataset is approximately 99.5% complete. Uses for the data include economic geology, mineral resources, mine hazards. Veins are numbered but not named.
Metal Speciation And Bioavailability For Risk Assessment And Remediation.
The full title of this project is" Studies into metal speciation and bioavailability to assist risk assessment and remediation of brownfield sites in urban areas" and is funded by NERC under the URGENT thematic programme form 1998-2001. The project is being undertaken by a consortium of workers from the Imperial College, University of Nottingham, and the British Geological Survey. Innovative collaborative and multi-disciplinary research will be applied to the interpretation of urban geochemical maps and associated meta-datasets to assist decision making by local authorities in the redevelopment of brownfield sites. Source apportionment, speciation and bioavailability of potentially toxic heavy metals will be studied at representative conurbations in the UK Midlands region. Scanning electron microscopy, chemical extractions and soil solution and vegetable analysis, will be integrated with high precision isotopic analyses of Pb and other potential toxic metals in this study. The results will be available as maps in GIS format to provide a generic decision support system for quantitative health risk assessment.
Dines Metalliferous Mineral File.
Detailed mining information for mining in Devon and Cornwall gathered by George Dines (former BGS Geologist) for a period around 1921. Maps, plans and accompanying notes and documents provide detailed information on the metal mining ( mainly tin,copper,lead) at that time. A synthesis of this information was published in "The metalliferous mining region of south-west England" 3rd impression 1988.
BGS World Mineral Statistics service (WMS)
This web service shows the centroids for countries for which there are minerals statistics data (Imports, Exports, Production) in the World Mineral Statistics database. A GetFeatureInfo request can retrieve some of the data for the country queried, but to get all data you should used the associate WFS.
BGS Mineral Resources Wales version 2
This dataset provides digital spatial information on the location of mineral resources in Wales at a scale of 1:50 000. The term 'mineral resources' has a definition under international standards that includes both an economic and geological dimension. These data are based primarily on mapped geology with limited assessment of economics. Therefore, the term 'mineral resources' is used here in a broad sense. The dataset allows users to visualise the extent and distribution of mineral resources and to relate them to other forms of land-use (such as urban areas or designated environmentally sensitive areas) or to other factors (such as transport infrastructure and conservation information). The British Geological Survey (BGS) was awarded a grant from the Welsh Assembly Government Aggregates Levy Fund in 2009 to provide a comprehensive, relevant and accessible information base to enhance the sustainability of mineral resources for Wales. BGS co-funded this project through its Sustainable Mineral Solutions project. This work was completed in 2010. This dataset comprises the digital GIS files which were produced through this project. The major elements of minerals information presented on the maps are; the geological distribution of all onshore mineral resources in Wales, the location of mineral extraction sites, the recorded occurrences of metallic minerals, the recorded location of former slate quarries and significant areas of slate waste and the recorded location of historic building stone quarries. In 2020 minor revisions to geometry and attributes were made in in response to minor corrections that were required. The paper maps were not re-released with these data updates. Point data for mineral occurrence and mine site data has not been included in this revision as these data are superseded by other BGS datasets, such as the BGS BritPits database of mines and quarries. The BGS Mineral Resource data does not determine mineral reserves and therefore does not denote potential areas of extraction. Only onshore, mainland mineral resources are included in the dataset. This dataset has been produced by the collation and interpretation of mineral resource data principally held by the British Geological Survey. The mineral resource data presented are based on the best available information, but are not comprehensive and their quality is variable. The dataset should only be used to show a broad distribution of those mineral resources which may be of current or potential economic interest.
Mining hazard (not including coal) in Great Britain
The dataset indicates the potential for hazard in Great Britain as a result of mineral extraction. It excludes areas of Coal mining as these are covered by the Coal Authority. It is based on a simple A-E rating scale indicating the increasing likelihood of an underground mining hazard. The data was created using expert knowledge, detailed literature searches, local knowledge and a series of rule based geological constraints applied to the DigMapGB50k (Digital Geological Map of Great Britain) data.
Mineral Occurrences Database
Dataset of mineral occurrences in the UK including locations of known mines, mineral showings and localities, including sites where minerals of economic interest have been identified in panned concentrates. Data is normally taken from published sources or from internal BGS records, such as field sheets, rock and stream sediment collection cards. Data compilation started ca. 1994.


text:
Javed Iqbal Umayr, conocido por el alias de "El monstruo de Lahore" (1956 – 8 de octubre de 2001) fue un pederasta y asesino serial pakistaní, que violó y asesinó a 100 niños varones y adolescentes.

Fue condenado a justicia retributiva, en pocas palabras, fue condenado a ser estrangulado, desmembrado y luego disuelto en ácido, tal como hizo con sus víctimas; y a pesar de que este castigo había sido bien recibido por la población general, el ministro interior pakistaní, Moinuddin Haider, se negó totalmente a que fuera castigado, por lo que declaró que no lo permitiría.

Primeros años
Iqbal se sabe era el sexto de 8 hijos de su padre, el cual era un empresario. Asistía a Government Islamia College, era conocido como un estudiante promedio. Cuando aún era estudiante, en 1978, abrió un negocio dedicado a la remodelación de acero. También se sabe que vivía en una villa que su padre le compró en Shadbagh, donde vivía junto a sus demás hermanos.

Asesinatos
En diciembre de 1999, Iqbal envió una carta a la policía y al director de noticias de un periódico de Lahore, Khawar Naeem Hashmi, donde confesó la violación y el asesinato de 100 niños fugitivos, todos de entre 6 y 16 años. En la misma carta, afirmó haber estrangulado y desmembrado a los niños. Víctimas, en su mayoría fugitivos y huérfanos que viven en las calles de Lahore. Confesaba también que se deshacía de los cuerpos disolviéndolos en ácido, arrojando los restos que quedaban a un río.

Dentro de la casa de Iqbal, la policía y los reporteros encontraron manchas de sangre en las paredes y el piso, junto con la cadena con la que Iqbal afirmó haber estrangulado a sus víctimas y fotografías de muchas de sus víctimas en bolsas plásticas. Estos artículos estaban cuidadosamente etiquetados con panfletos escritos a mano. También se dejaron a la intemperie dos cubas de ácido con restos humanos parcialmente disueltos para que la policía los encontrara, con una nota que afirmaba que los cuerpos de la casa no habían sido desechados deliberadamente para que las autoridades los encontraran.

Iqbal confesó en su carta que planeaba ahogarse en el río Ravi luego de sus crímenes, pero después de arrastrar sin éxito el río con redes, la policía lanzó la persecución más grande en la historia de Pakistán. Cuatro cómplices, adolescentes que habían compartido el piso de tres habitaciones de Iqbal, fueron arrestados en Sohawa . A los pocos días, uno de ellos murió bajo custodia policial, y una autopsia sugirió que se había utilizado la fuerza en su contra; supuestamente, saltó desde una ventana.

El motivo de Iqbal para cometer sus asesinatos fue su enfado por una injusticia percibida a manos de la policía de Lahore, que lo arrestó por cargos relacionados con un acto de sodomía contra un joven fugitivo en la década de 1990. No se presentaron cargos en relación con este delito. Su madre había sido "Obligada a ver su decadencia" antes de sufrir un infarto fatal. Por lo tanto, había decidido hacer llorar a 100 madres por sus hijos, como su madre se había visto obligada a hacer por él antes de su muerte.

Condena
Pasó un mes antes de que Iqbal se entregara en las oficinas del Daily Jang el 30 de diciembre de 1999. Posteriormente fue arrestado. Afirmó que se había rendido al periódico porque temía por su vida y le preocupaba que la policía lo matara.

Iqbal fue condenado a muerte; el juez dictó sentencia diciendo: "Serás estrangulado hasta la muerte delante de los padres cuyos hijos mataste, tu cuerpo será cortado en 100 pedazos y puesto en ácido, de la misma manera que mataste a los niños". El ministro del Interior, Moinuddin Haider, contradijo la sentencia al afirmar que Pakistán es signatario de la Comisión de Derechos Humanos, por lo que "tales castigos no están permitidos".

Iqbal se ahorcó en su celda el 8 de octubre de 2001, antes de que pudiera llevarse a cabo la ejecución, y otro "cómplice" fue ahorcado en una celda cercana esa misma noche.

Véase también

 Asesino en serie
 Lista de asesinos seriales por número de víctimas
 Lista de asesinos en serie por países
 Abuso sexual infantil
 Psicopatía
 Luis Alfredo Garavito

Referencias

Suicidios en 2001
Asesinos en serie condenados a cadena perpetua
Pakistaníes del siglo XX

redpajama_set_name: RedPajamaWikipedia


Chennai: After a hiatus of six years, Tamil Nadu government on Friday hiked the fares of buses under state run transport corporations and private entities approximately by 20 to 54.54 percent, saying it was inevitable.
Significantly, the government also announced a fund for accident compensation and prevention, besides a panel to go into restructuring of bus fares in future.
Effective from tomorrow, the fare has been hiked for buses across categories viz moffusil, city, ordinary, express, deluxe, bypass-non-stop, ultra deluxe, air-conditioned and Volvo modes, an official release said.
While the minimum hike is in moffusil ordinary category, where the fare of Rs 5 for 10 km would now be Rs 6 (20 percent hike), the highest is in Volvo buses, where the fare of Rs 33 for 30 km will now go up to Rs 51 (54.54 percent hike).
In town buses the fare has been hiked from a minimum of Rs 3 to Rs 5 and the maximum from Rs 12 to Rs 19.
The government cited a host of factors for the hike, including increase in fuel price and maintenance, annual increment in salaries, pension and purchase of new buses to increase efficiency.
Defending the hike, it said the last time fares were increased was on 18 November, 2011 when diesel cost Rs 43.10, whereas the price now was Rs 65.83.
The government also cited data to claim that the fares, despite the increase, was lesser than in neighbouring states, including Andhra Pradesh.
A recent interim direction of the Madras High Court in a transport related petition was also cited to support the decision to effect a hike in fares.
The government quoted the interim order as saying, "data furnished in the supporting affidavit shows that the present bus fare is inadequate to meet,even the operational cost."
The court had also said "with the existing funds and resources, maintenance cost, debt, loss and such other economic factors ...the need to revise bus fare, appears to be inevitable, though it may cause inconvenience."
The government said that since 2000 till date, Karnataka had hiked the fare 16 times, while Andhra Pradesh and Kerala had done so eight times.
In the past seven years, the Tamil Nadu government gave Rs 12,059.17 crore subsidy to State-run transport corporations to help them tackle the fund crunch.
These corporations have so far incurred a recurring loss of Rs 20,488 crore, the government said.
"Though the increase in fare was avoided so far,it is now inevitable so as to tackle the fund cruch and to continue to give the people a good transport service," the release said.
In a significant step, the government said an integrated 'Accident prevention, compensation and toll fee fund' would be set up, under which speed governors would be installed in long distance express buses as part of accident prevention efforts.
Private transport entities will be permitted to establish similar funds.
Unlike neighbouring states, the fare in Tamil Nadu presently does not cover insurance and toll fee components.
Henceforth, the fare will cover an integrated component of accident insurance and toll fee as well, it said.
From a minimum of Rs 1 (upto Rs 25 fare) a maximum of Rs 10 will be levied (for fares above Rs 501) for this purpose.
Defending its decision, the government said since timely compensation for accidents was not provided, as many as 652 State-run transport corporation buses were under court attachment proceedings. Also, the state transport corporations spent an average of Rs 12 crore per month towards toll fee.
A new accident compensation fund will ensure that victims (or their kin in case of death) would be provided compensation ranging between Rs 2.5 to Rs five lakh immediately, it said.
For those injured, it would be between Rs 10,000 to Rs two lakh depending upon the nature of injuries and duration of hospitalisation. For those who suffer permanent disability or head injury, the compensation will be Rs five lakh, it said.
The government said restructuring of fares in future would be done by a committee of senior government officials based on computation involving indices covering fuel price hike,changes in maintenance and repair cost and increment in salaries.
There are eight State run transport corporations in Tamil Nadu with 22,509 buses, employing 1,40,615 personnel.
Workers of Tamil Nadu State Transport Corporation (TNSTC) owing allegiance to 17 trade unions,including those affiliated to DMK and Left parties, had gone strike on January 4 after failure of talks with the government on wage revision.
While unions wanted a 2.57 times hike, the government offered only 2.44, resulting in a stalemate.
The strike severely crippled public sector bus services, causing immense hardship to public, including office-goers in cities though the government tried to maintain services by roping in temporary drivers and private buses.
The AIADMK backed union, besides some others, had not participated in the protests.the unions had called off the strike on 11 January after the Madras High Court appointed an arbitrator to settle their wage dispute with the government.


MAREEBA State High School's Gifted and Talented Program has been a major component of the school's sustained academic success since its inception in 2006, and it now has a fresh face at the helm.
Stefanie Prizmic is this year's Gifted and Talented Coordinator, taking over the role from the highly respected Christina Ellacott who retired last year.
Mrs Prizmic began her teaching career in 2008 at Cairns State High School and was there until 2014, before taking time off for family commitments.
Mrs Prizmic returned to teaching last year in a part-time capacity at MSHS, and it was then she noticed the enormous impact the Gifted and Talented Program has on the school's students.
"I saw what Christina did in the role and it was something I was confident I would really enjoy," she said.
"I was a business and maths teacher during my time at Cairns High, so to be in a completely different role that will challenge me is exciting.
Mrs Prizmic noted that a high bar has been set by her predecessor.
"Christina Ellacott was in this position for more than a decade, and I definitely have big shoes to fill," she said.
Mrs Prizmic said she would like to recognise the school's Deputy Principals Mandy Lindsay and Lesa Pershouse, Principal Scott Whybird and Rita Tessaro and Lucy Daly for providing her with such a wonderful support network at the school.
Caption: MSHS welcomed their new Gifted and Talented Coordinator, Stefanie Prizmic, who has taken over the role from the well-respected Christina Ellacott who retired last year.


text:
Man United made an offer for another Dortmund player but failed
It has been revealed that English Premier League outfit Man United made an attempt to snap up another Borussia Dortmund player Nico Schulz on the transfer deadline day but failed.
The report, according to ESPN claims that the German international left-back was also considered and a loan deal was proposed by the Red Devils worth £1 million but the Bundesliga outfit rejected the move.
ESPM claims that the German Bundesliga outfit were left baffled and questioned the Red Devils 'recruitment and scouting team's credentials, especially in their approach to doing deals.
Another transfer blow for Man United on cards
EPL: Man United in for another summer transfer shock
Man United transfer activities could still continue
It is no longer news that the Red Devils made an attempt to snap up the signature of England international winger Jadon Sancho in the summer transfer window but failed to meet with the £108 million demand by the German side.
Jadon Sancho was the top priority for manager Ole Gunnar Solskjaer but for the impact of the coronavirus pandemic on the club, they could not meet up financially and the deal was called off.
It is claimed that the Red Devils will return for the signature of the Man City academy product but they are unlikely not to face competition as other clubs have been mentioned to be interested in the deal
Meanwhile, Jadon Sanho is reportedly interested in a move to Man United but he has to respect his contract with the club.


text:
Yahoo Finance Canada
Ontario unveils rebate program for businesses, industry group says it's not enough
Alicja Siekierska
The Ontario government has unveiled a new rebate program for businesses impacted by capacity restrictions, but the Canadian Federation of Independent Business says the support program falls short of what companies need.
The province announced on Wednesday that it will introduce an Ontario Business Cost Rebate Program for businesses that have had to reduce capacity to 50 per cent. Eligible businesses will receive rebate payments equal to 50 per cent of the property tax and energy costs incurred while under capacity limit rules. Applications to the program will open in mid-January.
The government also said it will allow businesses to delay payments for most provincially administered taxes in a bid to help companies "free up cash flow during these challenging times."
"We recognize that these necessary capacity limits to reduce the transmission of the virus will impact businesses, and that's why we are introducing these new supports, which will put money directly into the hands of business and free up their cash flows during this critical time," Finance Minister Peter Bethlenfalvy said in a statement.
But CFIB president Dan Kelly says the new support measures are not enough. The group had pushed provincial governments across the country to announce a fresh round of provincial business grants.
"It's as if the Ontario government doesn't recognize the emergency it has created for small business," Kelly said in a statement on Twitter shortly after Ontario unveiled details of its new support program.
"No new grants, only a thin rebate program to start in January and the promise to defer some bills while creating more debt for small business owners."
Chief executive of the Ontario Chamber of Commerce, Rocco Rossi, said in a statement Wednesday that the organization is concerned whether the supports will be sufficient to prevent a wave of business closures.
"Applications for the Ontario Business Cost Rebate Program will not open until mid-January. This delay – along with the limited eligibility of the rebate to energy and property taxes – may not be enough for many small businesses to keep their doors open," he said.
"Newly imposed restrictions intended to control the spread of the Omicron variant should always be met with immediate, commensurate and targeted relief, particularly for small businesses who are struggling to stay afloat at this time."
The new Ontario program comes on the same day that the federal government expanded financial relief programs for workers and businesses in response to new restrictions prompted by the Omicron variant. Ottawa will expand the Local Lockdown Program to include businesses subject to capacity restrictions of 50 per cent or more, and the Canada Worker Lockdown Benefit (CWLB) to include workers in regions where provincial or territorial governments have introduced capacity restrictions of 50 per cent or more.
With files from Jessy Bains
Alicja Siekierska is a senior reporter at Yahoo Finance Canada. Follow her on Twitter @alicjawithaj.
Download the Yahoo Finance app, available for Apple and Android.


Lion fight which has become one of the leading promoters in the United States will put on another world class event in fight capital Las Vegas. Promoter Scott Kent has done it again, with some of the best muaythai athletes from around the world.
The fight card will be headed by a female title fight with Caley Reece vs Tiffany Van Soest. Both ladies need no introduction.
Caley Reece is a multiple World Champion, winning the IFMA world championship, WMC world title, Silver Medallist at the World Combat Games, and won the Prime Minister's trophy supported by the Thailand Prime Minister on the launch of muaythai towards International Olympic committee.
Tiffany Van Soest has been unbeaten and stopping the UK champion Lucy Payne in sensational style in the first round. This fight will be a fantastic promotion for female muaythai.
Further on the card is LA based and former WMC champion Kevin Ross vs Matt Embree. In the rematch against Matt Embree, Kevin Ross is trying to set the record straight.
There are many more fights on the card…..


text:
2,000 millionaires move to Dubai, rest of UAE in one year, says new 2019 wealth report
Business Personal Finance
Latest report shows which countries luring most number of super-rich individuals
Published: April 18, 2019 09:33 Cleofe Maceda, Senior Web Reporter
Residences in Dubai Marina. The world's millionaires are streaming into Dubai and the rest of the UAE. Image Credit: Supplied
Revealed: 7 UAE billionaires among world's richest in 2019; Majid Al Futtaim wealthiest in UAE
From 8 dollars to billions: How this Indian expat became a billionaire in UAE
Dubai: The world's wealthiest are streaming into Dubai and the rest of the United Arab Emirates (UAE).
The UAE remains the destination of choice for millionaires, a new report shows, with the world's mega-rich lured by the country's safety, business-friendly environment and quality infrastructure.
Approximately 2,000 high-net-worth individuals (HNWIs), each with at least $1 million (Dh3.6 million) worth of net assets, including property, cash, equities and business interests, streamed into the UAE in 2018, delivering a much-needed investment boost to the local economy. The majority of them, estimated to be more than 1,000, settled in Dubai.
The number of affluent migrants in the UAE has risen by two per cent in 2018, compared to the previous year, according to the Global Wealth Migration Review of AfrAsia Bank and New World Wealth that tracks global fortunes and wealth migration trends over the past ten years.
The UAE emerged in the top five list of destinations that lured the biggest wealth inflows last year, ranking fifth, just behind Switzerland.
Millionaires around the world are moving into new places and in 2018 alone, approximately 108,000 of them migrated, up from 95,000 in 2017.
The movement of wealthy individuals – where they're setting up a new home or which places they are leaving – are being tracked regularly, as wealth migration figures are a very important gauge of the health of an economy.
If a country or city is seeing a large number of millionaires leaving, for example, it could indicate some serious underlying problems in the country. It could be that there's lack of business opportunities, the crime rate is high or there are other issues that discourage people to stay.
"Conversely, countries that attract HNWIs tend to be very healthy and normally have low crime rates, good schools and good business opportunities," said the report.
The country that lured the biggest number of millionaire migrants is Australia, with HNWI net inflows reaching 12,000 in 2018, followed by the United States in the second place and Canada in the third position.
Countries with highest millionaire inflows, 2018
Australia: 12,000
United States: 10,000
Canada: 4,000
Switzerland: 3,000
United Arab Emirates: 2,000
Caribbean: 2,000
New Zealand: 1,000
Singapore: 1,000
Portugal: 1,000
Greece: 1,000
Spain: 1,000
The report also noted that among the cities worldwide, Dubai is one of the top destinations attracting very large millionaire inflows, reaching more than 1,000 in the past year. Also recording significant influx of millionaires are Los Angeles, Melbourne, Miami, New York City, San Francisco Bay Area and Sydney.
"Dubai is the top financial centre in the Middle East. It is also one of the safest cities in the region and a popular destination for migrating HNWIs and wealthy expats," the report noted.
With hundreds of millionaires streaming into Dubai every year, the value of the total private wealth in the city is set to grow further.
"The strong wealth growth in Dubai going forward should be fueled by strong growth in the local financial services and professional services sector (banks, fund managers, wealth managers, law firms), strong growth in the local healthcare and IT sectors, inward HNWI migration, Dubai's growing dominance as the top financial center in the Middle East [and] ease of doing business in the country," Andrew Amoils, head of research at New World Wealth, told Gulf News.
There are approximately 14,000,000 individuals worth at least $1 million in net assets, another 560,000 people with net assets of $10 million or more and 25,000 others with net assets of $10 million or more. Billionaires, each with net assets of at least $1 billion, account for 2,140 individuals.
Less is more: 5 ways to save money in the UAE
8 tips to maximise your retirement savings
Jobs: How much can you earn in UAE in 2020?
Money: Are you born saver or spender?
'Cash please, no bounced cheques', say UAE businesses


South Brooklyn Fencing ("SBF") is a fencing academy that aims to bridge the gap between the elite sport of fencing and the urban environment of Brooklyn. Situated in Southernmost area of Park Slope between 4th Avenue and 5th Avenue on 21st street, this institute serves New York City's residents.
A unique aspect about South Brooklyn Fencing is that it will only provide lessons in the Olympic weapon Foil, rather than all three weapons. By having an environment that only caters to foil, children and adults of all ages will be able to hone in and focus their talent without any distractions. Our members are comprised of beginner, intermediate, and national level fencers who compete on the U.S. fencing circuit.
The Head Coach Anibal Alvear, grew up fencing in Chile and was an active member of Chile's National Team for 12 years. Since moving to New York City in 2013, he has continued his dedication to the elite sport. His focal point is to ensure self-confidence, focus, and precision while simultaneously instilling admiration, respect, and sportsmanship within his students.
Damaris M. gave this class 5 out of 5 CourseHorse stars.


Half Acre, duplex zoned property on sewer close to village center. Large enough to subdivide into panhandle as is or 3 lot strata subdivision. This property is also excellent if you are looking to build a workshop for home based business or a cottage for a vacation rental property in the back yard. House is is good condition with 2 bedrooms suite on main floor and 1 bedroom suite down. Perfect for a couple sharing or extended family. Laundry on each floor and separate entrances. Lots of parking. Location is excellent, close to schools, village and bus. Excellent investment or holding property.


text:
[![NPM Version][npm-version-image]][npm-url]
[![NPM Downloads][npm-downloads-image]][npm-url]
[![Node.js Version][node-image]][node-url]
[![Build Status][travis-image]][travis-url]
[![Coverage Status][coveralls-image]][coveralls-url]

This is a database of all mime types.
It consistents of a single, public JSON file and does not include any logic,
allowing it to remain as unopinionated as possible with an API.
It aggregates data from the following sources:

- http://www.iana.org/assignments/media-types/media-types.xhtml
- http://svn.apache.org/repos/asf/httpd/httpd/trunk/docs/conf/mime.types

## Usage

```bash
npm i mime-db
```

```js
var db = require('mime-db');

// grab data on .js files
var data = db['application/javascript'];
```

If you're crazy enough to use this in the browser,
you can just grab the JSON file:

```
https://cdn.rawgit.com/jshttp/mime-db/master/db.json
```

## Data Structure

The JSON file is a map lookup for lowercased mime types.
Each mime type has the following properties:

- `.source` - where the mime type is defined.
    If not set, it's probably a custom media type.
    - `apache` - [Apache common media types](http://svn.apache.org/repos/asf/httpd/httpd/trunk/docs/conf/mime.types)
    - `iana` - [IANA-defined media types](http://www.iana.org/assignments/media-types/media-types.xhtml)
- `.extensions[]` - known extensions associated with this mime type.
- `.compressible` - whether a file of this type is can be gzipped.
- `.charset` - the default charset associated with this type, if any.

If unknown, every property could be `undefined`.

## Repository Structure

- `scripts` - these are scripts to run to build the database
- `src/` - this is a folder of files created from remote sources like Apache and IANA
- `lib/` - this is a folder of our own custom sources and db, which will be merged into `db.json`
- `db.json` - the final built JSON file for end-user usage

## Contributing

To edit the database, only make PRs against files in the `lib/` folder.
To update the build, run `npm run update`.

[npm-version-image]: https://img.shields.io/npm/v/mime-db.svg?style=flat
[npm-downloads-image]: https://img.shields.io/npm/dm/mime-db.svg?style=flat
[npm-url]: https://npmjs.org/package/mime-db
[travis-image]: https://img.shields.io/travis/jshttp/mime-db.svg?style=flat
[travis-url]: https://travis-ci.org/jshttp/mime-db
[coveralls-image]: https://img.shields.io/coveralls/jshttp/mime-db.svg?style=flat
[coveralls-url]: https://coveralls.io/r/jshttp/mime-db?branch=master
[node-image]: http://img.shields.io/badge/node.js->=_0.6-brightgreen.svg?style=flat
[node-url]: http://nodejs.org/download/

redpajama_set_name: RedPajamaGithub


Have an idea? We can custom create patterns according to your design ideas too!
SASS member #9198 "Slapout" (Jim Connor) started making holsters in the garage of his Southern California home in 1992.
Many years of practice and experimenting with different methods of dyeing, lacing, hand-stamping and hand sewing each piece to fit his customer's need, have enabled him to produce well made, period correct western holsters for shooters of every level.
"Slapout's holsters and gun leather products are reasonably priced and meet SASS regulations."


An original letter of correspondence between brothers and business partners Joshua Coffin Chase and Sydney Octavius Chase. Topics discussed in the letter include matters with the Lancaster-Rankley family and Joshua's recommendation to hire Carl Haas to manage property at Isleworth Grove should A. Q. Lancaster resign.
Original letter from Joshua Coffin Chase to Sydney Octavius Chase, February 18, 1911: box 49, folder 20.84, Chase Collection (MS 14), Special and Area Studies Collections, George A. Smathers Libraries, University of Florida, Gainesville, Florida.
Digital reproduction of original letter from Joshua Coffin Chase to Sydney Octavius Chase, February 18, 1911.
ISLEWORTH. This will acknowledge yours of Feb 17th. Let me hope you will be able to adjust matters with the Lancaster-Rankley family and hold them in line on a satisfactory basis. Very likely Lancaster did not care to file his reasons in writing but you may be able to secure a statement, which you are entitled to, as the arrangement within him was for a year dating from May 1st. After hearing all Lancaster has to say and talking matters over with Eubank if you do not feel safe to leave the property in his charge there is only one things to do and, that is, to get rid of Eubank and place some one else on the property in whom you have confidence.
In my yesterday's letter I suggested Carl Haas. He is intelligent, honest, reliable and economical, and has proven faithful to our interests. He must know something about grove work and the proper kind of fertilizers to use or he would never have advised Barnett to throw his sulphate of ammonia and use potash. It might be possible to arrange with Haas to have his wife operate the house as Mrs hoard did. We can hardly spare Haas from the business now as we need him badly in the Homestead territory but could release him on or about July 1st, - perhaps sooner, if necessary.
It strikes me that the grove has gotten along to a point where a good careful man as Superintendent, who will carry out any of your instructions, will be better than an uncertain quantity, (no matterhow energetic) or with any other man with a dissatisfied and discontented wife.
If Lancaster decides to remain he will regard it in the nature of a favor to you and will feel justified in taking offense and quitting if anything happens he doesnot like.
Chase, Joshua Coffin. "Letter from Joshua Coffin Chase to Sydney Octavius Chase (February 18, 1911)." RICHES of Central Florida accessed April 21, 2019, https://richesmi.cah.ucf.edu/omeka/items/show/2713.


text:
Q: Issues with implementing grouped percentage with ALLEXCEPT in PowerBI I wanted to get a grouped Percentage as a New Column or New Measure (which is recommended from what I have read in the forum). I have a data where user would use Slicers to get various Percentages. However, at the moment my query is keep failing. I have visited the forum and I can't seem to figure out how to Group By and get the percentage of the group. Furthermore, I can't use the Group By tool in the Query Editor because my data is quite large. So, I have to rely on DAX which I don't have lot of knowledge about.
Here is the measure I created which doesn't work since when I slice data for quarter 1, the percentage doesn't add up to 1.0 but it shows it does in the Total row:
Percent Values = CALCULATE (
    SUM (question[Count Values] ),
    ALLEXCEPT ( question, question[Date].[Quarter], question[Date].[Year],question[Processing Type],question[Gender], question[Race] )
)
    / CALCULATE (
        SUM ( question[Count Values] ),
        allselected()   )

Please find the excel data file here:
https://github.com/TestingGround00/powerbi_question/blob/main/input_data_table.xlsx
I was expecting to get a result like this:

Any help is immensely appreciated. Thank you.
Comma delimited data:
Race,Gender,visa_type,Count Values,visa_country,Processing Type,Date
White,Female,C,1,Canada,Custodial,2/14/2014 0:00
Other,Male,M,5,Mexico,Express,1/20/2014 0:00
Hispanic,Male,R,6,Russia,Refugee,2/18/2014 0:00
White,Female,B,4,Brazil,Asylum,3/7/2014 0:00
Hispanic,Male,C,1,Canada,Refugee,4/11/2014 0:00
White,Female,R,7,Russia,Custodial,4/23/2014 0:00
White,Male,M,9,Mexico,Express,4/1/2014 0:00
Hispanic,Male,B,3,Brazil,Refugee,4/13/2014 0:00
White,Female,R,1,Russia,Express,7/31/2014 0:00
White,Male,C,7,Canada,Asylum,9/6/2014 0:00
White,Female,M,2,Mexico,Express,7/22/2014 0:00
Black,Female,B,5,Brazil,Custodial,8/13/2014 0:00
White,Male,R,1,Russia,Asylum,12/9/2014 0:00
White,Female,M,4,Mexico,Asylum,12/6/2014 0:00
Black,Female,B,6,Brazil,Express,12/13/2014 0:00
White,Male,C,7,Canada,Refugee,10/26/2014 0:00

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Edit:
Thank you @Phil Leh for helping out.
Unfortunately the results are still a bit off. Please see the picture below:

Essentially I am trying add Event Processing to 100% each quarter. However it's off after making some adjustments to your query.

A: You were really close. Try to rewrite your measure to the following (more verbose for explanation):
Percent Values =
-- calculation of the numerator
VAR num =
    SUM ( question[Count Values] )  -- numerator

-- calculation of the denominator
VAR denom =
    CALCULATE (
        SUM ( question[Count Values] ),
        -- usage auf ALLSELECTED() clear filter context from table visual,
        -- but keeps the filter values from slicers
        ALLSELECTED ()
    )
RETURN
    DIVIDE (
        nom,
        denom
    )

The problem for you getting a "wrong" result was the calculation of your numerator.
Here you used ALLEXCEPT(), but didn't include the fields 'question'[Count Values] and 'question'[visa_country].
Under the hood for the table Power BI generates a cross-join for all field combinations.
Below image  demonstrates the filtered output of this table by year and quarter (same as in your slicer) and hopefully makes it clearer:

The highlighted lines are the one you for example see, because they will generate a value for VAR num. Image output was created with DAX Studio
Update/Extension
To tackle the task in your edit it get a little more complicated, especially with the rollups/totals
Here is a possible DAX measure. It is mainly extended from the previous one:
Percent Values =
VAR num =
    SUM ( question[Count Values] )

-- this one is new
VAR f =
    FILTER (
        -- clear all filter from our table
        ALL ( question ),
        -- and keep only the values matching the
        -- filter context's current quarter and year
        question[Date].[Quarter]
            = MAX ( question[Date].[Quarter] )
            && question[Date].[Year]
                = MAX ( question[Date].[Year] )
    )
VAR denom =
    IF (
        -- checking if Quarter is in current filter context
        ISINSCOPE ( question[Date].[Quarter] ),
        -- if yes, use the filter f (calculate denom for this quarter
        CALCULATE (
            SUM ( question[Count Values] ),
            ALLSELECTED (),
            f
        ),
        -- else, calculate the denom for all values
        -- this could also be BLANK() or some other calculation
        CALCULATE (
            SUM ( question[Count Values] ),
            ALLSELECTED ()
        )
    )
RETURN
    DIVIDE (
        num,
        denom
    )

In a matrix visual the result will be

Small tip: if you want to display you measure as percentage, click it and in the top ribbon you can format the measure as percentage


At North Dallas Family Church we have a growing young adult ministry. We welcome college students, young professionals, and all adult singles to join us for fellowship. Our goal is to create a space for growing in God's word and learning to become agents of change for Christ. We connect on Sunday mornings at 9:30 AM for bible study and fellowship.