text:
What a second Trump term could mean for LGBTQ people
LGBTQ people would likely see their rights further chipped away.
By Katelyn Burns Updated Oct 15, 2020, 8:20pm EDT
Share All sharing options for: What a second Trump term could mean for LGBTQ people
Trump supporter Nestor Moto Jr. attends a counterprotest in Costa Mesa, California, on December 12, 2016.
Jeff Gritchen/Digital First Media/Orange County Register via Getty Images
Part of A Trump second term
While President Trump doesn't often comment publicly on queer or transgender issues, his administration has been anything but LGBTQ-friendly. Vice President Mike Pence has a long record of anti-LGBTQ lawmaking and rhetoric, and LGBTQ advocates have already called the Republican Party platform — a holdover from 2016, as the GOP did not write one for 2020 — one of the most anti-LGBTQ in the party's history. A second Trump term could further turn the clock back for LGBTQ people.
Trans people have been a target of the Trump administration from the get-go. Almost immediately after Trump took office in 2017, the administration rolled back an Obama-era memo directing schools to protect trans students from discrimination. That July, Trump announced his decision to ban trans people from serving in the military. In May 2018, the administration went after trans prisoners, too, deciding that, in most cases, trans people should be housed according to their assigned sex at birth. This summer, the Department of Housing and Urban Development proposed a rule that would allow homeless shelters that receive federal funding to house trans people according to their birth-assigned sex.
Queer people have also been under attack. Though marriage equality is the law of the land, the White House has taken steps to limit or undo gay rights in several key policy areas such as lobbying to give religious adoption agencies the right to refuse same-sex couples. Most critical, perhaps, was the administration's attack on the Affordable Care Act's LGBTQ nondiscrimination protections in a rule released on June 12. Though it has been put on hold due to a federal court stay, the rule would allow doctors and insurance companies to refuse care to LGBTQ people.
Meanwhile, Trump has nominated three conservative Supreme Court justices during his presidency, but in a surprising turn of events, a recent major LGBTQ victory threw the administration for a loop: The Supreme Court decided in June that LGBTQ people are protected on the basis of sex under Title VII of the 1964 Civil Rights Act. The decision in Bostock v. Clayton County means that queer and trans people cannot be fired for being LGBTQ, and the ruling could end up as precedent for expanding rights into other issue areas such as education and health care.
Still, this likely won't stop conservatives from trying to whittle away and build in carveouts to the legal protections LGBTQ people currently have. It would be similar to the approach taken by religious conservatives with regard to Roe v. Wade — passing anti-abortion legislation at the state level in the hope that related cases work their way back to the Supreme Court, especially now that it looks like Trump pick Amy Coney Barrett is about to be confirmed.
According to activists, conservatives will likely try to attack across three different fronts in their efforts to chip away at LGBTQ rights: by continuing to reshape the courts, by attacking health care access, and by continuing to limit immigration and asylum by LGBTQ people fleeing violence in other countries.
The courts are key to queer and trans rights
If elected president, former Vice President Joe Biden has promised to immediately reverse the military ban and reissue an Obama-era guideline allowing trans students to use the correct bathroom. This would effectively end litigation in the military ban cases and change the complexion of the bathroom cases.
However, a second Trump term would mean more anti-LGBTQ federal judges appointed, a Supreme Court justice (maybe even two), and an escalation in the legal arguments against trans rights, legal advocates say.
The bulk of Trump's anti-LGBTQ actions have come through administrative rules, most of which have been challenged in federal court. Because of this, Trump's control over federal policy has been solidified by appointing conservative judges. As of July, 194 of the 792 active federal judges were appointed by Trump — that's a quarter of the federal judiciary — according to Pew Research data. Many of them were either previously anti-LGBTQ activists or who openly express anti-LGBTQ sentiments.
Several have already had an impact on pending legal battles. Earlier this year, Fifth Circuit Judge Kyle Duncan infamously ruled that it is necessary for a court to misgender a trans plaintiff whose case he was overseeing, a decision not in line with precedents in other federal courts.
And right now, there are several legal cases snaking their way through the federal court system that could end badly for LGBTQ people if put in front of a Trump-appointed judge. These include several lawsuits against the transgender military ban, student suits seeking access to school bathrooms according to their gender identity, and California v. Texas, which is set to decide whether religious entities can legally deny adoption services to gay parents. It will be heard by the court on November 4, just a day after Election Day.
These cases could eventually land in front of the Supreme Court, which is its own issue, now that Republicans in the Senate are all but set to confirm conservative Judge Amy Coney Barrett to the Court upon Justice Ruth Bader Ginsburg's death.
"Certainly, at least one more Supreme Court appointment would inflict devastating damage on the transgender community that would last for decades to come," Shannon Minter, an attorney at the National Center for Lesbian Rights, told Vox in August. "It would be something close to closing the courtroom doors on our foreseeable future."
One way for conservatives to somewhat relitigate and chip away at even landmark decisions is through a change in legal strategy. Throughout its first term, the Trump administration argued in court that trans people are not and should not be protected under current sex discrimination laws. This was the basis for several administrative rules rolling back the rights of trans people in health care, in homeless shelters, and in education. However, Bostock turned that argument on its head.
According to Chase Strangio, an attorney at the American Civil Liberties Union, the administration has now begun to argue more explicitly that federal sex discrimination law protects cis people from sharing spaces with trans people. It's a similar tack to the fringe argument that anti-LGBTQ legal groups have long tried — that cis people have a constitutional right not to share locker rooms, bathrooms, and other gendered spaces with trans people.
For example, in a statement to the court in a case challenging Connecticut's school sports transgender inclusion policy earlier this year, the administration argued that trans people are not protected under Title IX, which protects people on the basis of sex in education. In a more recent post-Bostock filing in a nearly identical case challenging Idaho's ban on trans girls participating in girls' school sports, the administration took a different angle, arguing that Title IX entitles cisgender people protection from sharing spaces and activities with trans people. That policy shift, Strangio told Vox, would be a scary portent for a second Trump term.
Because everything is interconnected, the key to making Trump's strategy work, say Minter and Strangio, would be more Trump appointees to the already Trump-stacked federal judiciary. The lower court judges would have significant power to shape LGBTQ cases as they move through the federal court system.
"My greatest fear is for a judicial action that locates [anti-trans] rights in the Constitution that we couldn't undo with a new president in the future," said Strangio. "You get some horrible constitutional ruling that then authorizes discrimination in a host of contexts because trans people are so abhorrent that you have a constitutional right not to share space with them."
Health care is likely the next big fight for LGBTQ people
Even before the pandemic, health care was going to loom large over this election cycle. Republicans in Congress have repeatedly tried to repeal the Affordable Care Act during Trump's term. The administration even submitted a brief to the Supreme Court recently arguing that the law should be thrown out.
The ACA was a landmark piece of health care legislation for Americans — particularly so for LGBTQ people. Under an HHS rule established by the Obama administration in 2016, the bill banned health care discrimination against LGBTQ people, but just as key for queer communities were protections for coverage of preexisting conditions. Before the law was passed, anyone diagnosed with gender dysphoria or HIV/AIDS could legally be excluded from health insurance coverage, and transition care could be legally excluded from any insurance plans.
"I can't think of a more important issue for transgender people than access to health care, because if we're not able to access transition-related care, it's just impossible to have a meaningful, authentic life," said Minter.
Should the administration succeed at the Supreme Court in California v. Texas, slated to be heard this fall, people could again be subject to wholesale exclusion from insurance coverage. But even if the law is preserved in some form, the administration has already worked to limit LGBTQ access to health care.
In mid-June, just days before the Bostock decision came down, the administration finalized a rule clarifying that LGBTQ people are not entitled to sex-based protections under the ACA, effectively rolling back the Obama-era rule saying the opposite. The rule, as written, would allow insurance companies to once again have blanket exclusions on coverage of transition-related procedures and they could once again deny coverage of health care that doesn't comport to a person's legal gender, meaning a trans man could be denied coverage for gynecological care.
The rule would also have had a significant impact on lesbian, gay, and bisexual cisgender people in the US by allowing doctors, health care providers, and insurance companies to deny care or coverage to cis queer people.
"We know LGBTQ people face discrimination in health care," David Stacy, who leads the federal policy team at the Human Rights Campaign, told Vox. "It can be overt discrimination, but it can also be more subtle discrimination."
In August, however, a federal judge issued a stay on the rule's implementation while the case is litigated, saying that the rule likely violates Bostock and that HHS failed to reconsider this after the Supreme Court's decision.
But despite the stay, there are still potential avenues a second-term Trump administration could take to attack trans health care access in particular. Minter suggested that, depending on the makeup of Congress, the administration could take steps to ban transition-related care from Medicaid coverage, try to reinstate a Medicare exclusion that existed prior to 2016, or even try to institute a Food and Drug Administration ban on puberty blockers for trans adolescents. The administration could also use executive action to end transition care offered through Veterans Affairs.
"They'll try to cut off access to health care for trans people any way they can," said Minter. "They can do a lot of damage on the health care front. It would be, in my opinion, probably the single most devastating impact on the trans community."
Immigration rights are a life-and-death issue for LGBTQ people
LGBTQ issues like health care and the military ban frequently take center stage when discussing the administration's record, but perhaps nothing is as life and death for queer and trans people as immigration and asylum policies.
In late 2018, 31-year-old trans woman Camila Díaz Córdova fled her native El Salvador, fearing for her life. She reportedly made her way to the US with a migrant caravan and attempted to apply for asylum, only to be denied and deported back to her home country. In late January 2019, she was murdered by three police officers.
It's a problem that will likely only worsen in a Trump second term. "The rules of asylum are completely changing," Bamby Salcedo, founder of the Trans Latina Coalition, told Vox. "Through that process, a lot of people are being excluded. This is something that will definitely impact trans women."
Over the last three and a half years, the Trump administration has made it increasingly difficult for those fleeing gender-based violence to obtain asylum in the United States. In November 2018, Trump tightened immigration rules which restricted asylum to anyone who first passed through Mexico to arrive at the US southern border. And this June, the Department of Homeland Security proposed a new rule that would allow immigration officials to dismiss asylum seekers' applications as "frivolous" without a hearing.
As explained by Vox's Nicole Narea, the proposed rule is part of a larger election-year push against immigration in general. Using the pandemic as an excuse, Trump has closed the border with Mexico, started quickly deporting asylum seekers who show up at the southern border, and issued a temporary ban on issuing new green cards.
All of these restrictions come at a real cost for trans people, especially trans women, in Central America. There is an epidemic of violence against trans women of color throughout the Americas, but it is acutely felt in Central America. According to a report by Trans Murder Monitoring, at least 258 trans or gender-diverse people were murdered in Latin America between October 2018 and September 2019.
"The new asylum regulations that Trump has already proposed, if they were finalized, it will be devastating for LGBT asylum seekers. And they'll effectively just shut the door to asylum," said Minter.
The public comment period ended on July 15 and the rule could be finalized before Election Day. However, should Democrats retake the Senate and White House, they'll be able to override any administration rules issued within 60 legislative days of the new Congress taking office via the Congressional Review Act.
Salcedo said that the possibility that Biden could win the presidency gives her hope — not just for the immigration and asylum system, but that other trans-related policies could improve in short order. "I am hopeful that, you know, the new administration will revert all of those policies that have attempted to come into effect," she said. "I'm hopeful that there's tangible and institutional changes that are going to happen. And I firmly believe that that could become a reality."
New goal: 25,000
In the spring, we launched a program asking readers for financial contributions to help keep Vox free for everyone, and last week, we set a goal of reaching 20,000 contributors. Well, you helped us blow past that. Today, we are extending that goal to 25,000. Millions turn to Vox each month to understand an increasingly chaotic world — from what is happening with the USPS to the coronavirus crisis to what is, quite possibly, the most consequential presidential election of our lifetimes. Even when the economy and the news advertising market recovers, your support will be a critical part of sustaining our resource-intensive work — and helping everyone make sense of an increasingly chaotic world. Contribute today from as little as $3.
A Trump second term
How a second term could cement Trump's restrictionist immigration agenda
What would Trump actually want to do on health care in a second term?
What Trump's second-term foreign policy might look like
Lock them up: The danger of political prosecutions in a second Trump term
A second Trump term would mean severe and irreversible changes in the climate


text:
MARK FORBES
Consumer Haze
Time Machines
© 2019 Mark Forbes.
F is for Fukushima
This is a much abridged version of the full story - including many more images and interview transcript translations - which can be seen here.
In February 2017 I visited Fukushima, Japan. It was a few weeks prior to the 5 year anniversary of the Tōhoku earthquake, the resulting catastrophic tsunami and corresponding nuclear melt down.
I wanted to visit the Fukushima area to enable to residents, who were just being permitted to move back to their houses, an opportunity to tell their stories of the day and the period since. Some of the locals were keen to move back as soon as they were allowed, while others explained that they could now never return.
The interviews were at times harrowing and painful, but at other times full of hopes for the future and happiness at what is still to come. The candid responses of the interviewees regarding their memory of and their feelings about the events surrounding the earthquake, tsunami, nuclear melt down and forced evacuation of their homes was truly remarkable. Their lives and those of their families were each changed by the traumatic events beginning on March 11 2011.
Telling the stories also involved visiting the very tightly controlled "no-go" zone. Which involved the use of chemical suits, masks and geiger counters. The experience was surreal and haunting.
Tōhoku earthquake, tsunami & Fukushima Daiichi nuclear disaster
[italics sourced mainly from Wikipedia] On the 11 March 2011 14:46 JST, the 9.0 magnitude Tōhoku earthquake struck approximately 70km east of the Japanese coast. It was the most powerful earthquake ever recorded to have hit Japan, and the fourth most powerful earthquake in the world since recordings began in 1900. The earthquake occurring at an underwater depth of approximately 30km triggered a massive tsunami that reached heights of up to 40.5m, travelling inland up to 10 km at it's furthest point. In the area of Naraha (focus of this documentary), a wave of height ~15 m arrived approximately 1hr after the earthquake and travelled a distance of between 1-2 km inland - depending on local elevation. The tsunami wave also resulted in the Fukushima Daiichi nuclear disaster at the Nuclear Power Plant - which was caused by equipment failures resulting in three nuclear meltdowns and the release of radioactive material beginning 12 March 2011. The tsunami wave impacting at the site of the Nuclear Power Plant at a height of 13m, overwhelmed the plants 10m high seawall. On 10 March 2015, a Japanese National Police Agency report confirmed 15,894 deaths, 6,152 injured and 2,562 people missing across twenty prefectures, as well as 228,863 people living away from their home in either temporary housing or due to permanent relocation. A 10 February 2014 agency report listed 127,290 buildings totally collapsed, with a further 272,788 buildings 'half collapsed', and another 747,989 buildings partially damaged.

redpajama_set_name: RedPajamaCommonCrawl


This course aims to develop students' understanding of the keys principles of macroeconomics and microeconomics in order to make effective business decisions. The course provides a theoretical framework to analyse the markets, government policies, firm's behaviour and macroeconomic policies.
Garnett, A.M., Lewis, P., Hubbard, R.G. and O'Brien, A.P. (2012) Essentials of Economics, 2nd Edition, Pearson, Sydney.
Nb. The 1st edition of the textbook may suffice for diligent students, but be warned that the content may not line up exactly with what is assigned in the course from the 2nd edition textbook.
McTaggart, D., Findlay, C. and Parkin, M. (2010), Economics 6th edition, Pearson, Sydney.
The course makes extensive use of MyUni for the posting of lecture notes, lecture recordings, tutorial exercises, assignments, and important announcements. It is expected that all students will regularly check the MyUni course website, and regularly check their university email accounts.
Lecture recorders are typically made available online. There may be occasions when the recording fails for technical reasons.
The various sources of information available in this course are meant to complement one another. The lectures refer to topics covered by the text. The lectures provide either an insight into what the text will try to convey or reinforce the concepts that you have already read. Again, one complements the other. The tutorials address the material covered in lectures more practically, through problem solving. In addition to a weekly assessment, students are encouraged to engage in discussion in tutorials.
An integral part of this course is the group assignment. Students will be asked to form themselves in groups of between 1 and 5 students. Each group will be presented with a current event or relevant social issue. Groups will be faced with a series of questions which are to be discussed and ultimately analyzed using the various tools studied in class. The purpose of the exercise is to discover the uses of and necessary limits of the economists' toolkit as well as give students the forum to practically apply economic theory. Although, group work is encouraged, students are allowed the option to complete the assignment as an individual.
A 1500 word group assignment will be due prior to the mid-semester break. Groups may be comprised of 1, 2, 3, 4 or 5 people. Assignment details can be found on MyUni.
Students will be asked to submit written answers to the indicated questions on the weekly tutorial exercises, which will be available to download from MyUni on a weekly basis. Only the best 8 weekly tutorial assignments will contribute to the grade for this component of assessment, which in total will be 20% of assessment. Instructions on the submission and return of these weekly assignments will be provided on MyUni.
Students are expected to participate in an online learning activity each week by answering quiz questions online. If you complete a quiz within the weekly time period, you will get 1 point. There will be 12 online learning weeks (starting in week 2), so if you complete 10 weeks you will get 10/10%. Completing all 12 weeks is recommended for your learning but is not required for this portion of your mark.
Further details on the quizzes will be provided on MyUni.
Students are asked to form in groups of between one and five. Each group is given a news article and asked a series of questions relating the news event to its impact on the economy.
The final exam will be a 3-hour exam, plus 10 minutes reading time. This exam may assess all topics covered in the course. Details regarding the structure will be posted on MyUni. A past semester's exam is available on MyUni. Please note that this is a closed book exam. Dictionaries of any type will not be allowed in the exam. Calculators will be allowed in the exam, but calculators that can store text, are programmable, or have wireless functions will not be permitted. This means graphics calculators are not permitted, and some particular scientific calculators may not be permitted.


text:
Home / About / Offices and Services / Office of Neighborhood, Community and Government Relations / Lower School Construction Project
On April 25, the Lipscomb Academy community gathered to celebrate the next exciting initiative on the horizon.
A special ground-breaking ceremony for the forthcoming Brewer Campus expansion, the first phase of an expected $25 million project to bring 21st century learning facilities to the lower school campus at Granny White Pike and Harding Place.During the first week of June, work on the project officially began as a fence securing the construction site was erected, and some of the homes in the footprint of the projects were demolished. In the next few days as you drive by the campus or drop your students off at Lipscomb's Summer Experience, you will begin to see activity on the site and the area starting to transform. As always but especially during this time, we want to assure you that the safety and security of our students and everyone in the area of the construction project is of utmost importance to us. Therefore, we have a number of safety measures in place to ensure that only those who are permitted on the job site have access. Fences, signage, extra monitoring and security personnel, as well as relocated equipment and activities, are among the measures in place to ensure the safety of our community members during the project, which is expected to be completed in August 2020.
Lower School Renderings
Aerial view rendering of the Lower School expansion at completion.
At grade front view rendering of the Lower School expansion at completion.
Blueprint Rendering showing Phase 1 of the Lower School expansion.
Blueprint showing Lower School expansion phasing plan.
The first phase of expansion which is now underway will include marquee spaces such as a new student dining hall and kitchen and the state-of-the-art learning commons, with an innovative collaborative hub that offers students technology-rich research stations, flexible furnishings, collaborative instructional spaces, inviting reading areas, access to library materials and creative makerspace materials among other features. The first phase includes 22,000 square feet of new construction and 1,500 square feet of renovated space.
One of the initiatives we are particularly excited about is that these new facilities will allow us to expand the reach of Lipscomb Academy as we launch a new special needs program. Lipscomb Academy's Solly School will include designated learning and therapy space for a new program that provides education and support services for students with special needs. The school is named after 4-year-old Solomon "Solly" James Rodan, the grandson of Pam and Jim Griffith, a board of trustees member and grandparent to several Lipscomb students.
With the heavy rains we have experienced in Nashville the last couple of weeks, our construction progress has been delayed a bit but we are working hard to try to keep on schedule as much as possible. Site demolition is complete and construction crews are currently working on grading the property to prepare it for the beginnings of the building process.
You have likely noticed that the green screening is up along the construction fences. We hope those will be a good buffer to minimize the view of the construction during the project.
Daily Construction Schedule:
As a reminder, the daily construction schedule is:
Monday - Friday • 7 a.m. - approximately 5:30 p.m.
Saturday • 7 a.m. - approximately 5:30 p.m.
Saturdays will be used primarily to make up for inclement weather during the week, but will follow this time schedule when construction takes place on these days.
This schedule is subject to change due to unforeseen inclement weather or other environmental issues, but is the general plan for the duration of the project.
The Brewer Campus Expansion Project first phase is scheduled to be completed in approximately 13.5 months, barring an abundance of inclement weather or other unforeseen circumstances.
Grading of the property will continue for about the next four to six weeks. Soon, hammering and excavation work will begin as crews grade and install utilities to the site. This work should last approximately two to three months. Also in early July, they are scheduled to start laying concrete foundations.
Scope of the Project
This project at Lipscomb Academy is the first phase to expand the Brewer Campus, which houses the school's 2-year-old through fourth grades currently. This first phase of expansion will include marquee spaces such as a new student dining hall and kitchen and the state-of-the-art learning commons, with an innovative collaborative hub that offers students technology-rich research stations, flexible furnishings, collaborative instructional spaces, inviting reading areas, access to library materials and creative makerspace materials among other features. The first phase includes 22,000 square feet of new construction and 1,500 square feet of renovated space. This is in preparation for the fifth grade to move to the lower school once this first phase of construction is completed.
One of the initiatives we are particularly excited about is that these new facilities will allow us to expand the reach of Lipscomb Academy as we launch a new special needs program. Lipscomb Academy's Solly School will include designated learning and therapy space for a new program that provides education and support services for students with special needs.


text:
Q: SQL Sumar valor de una fila en las demás filas agrupado con distintos campos Tengo el siguiente resultado de una consulta muy extensa, colocaré solo los campos relevantes.
SERVICIO                                           TIPO                                               CANTIDAD    TOTAL
-------------------------------------------------- -------------------------------------------------- ----------- -----------
                                                   LABORAL Y PREVISIONAL                              2           6
                                                   MENSUALES PREVISIONALES PARA INFORME.              2           6
Transporte Hormigón (General Velasquez)            LABORAL Y PREVISIONAL                              13          24
Transporte Hormigón (General Velasquez)            MENSUALES PREVISIONALES PARA INFORME.              13          24
Transporte Hormigón (San Bernardo)                 LABORAL Y PREVISIONAL                              16          24
Transporte Hormigón (San Bernardo)                 MENSUALES PREVISIONALES PARA INFORME.              16          24

Resulta que como se puede ver hay dos servicios en blanco con una cantidad y un total, esos valores son generales, lo que quiere decir es que deben sumarse en cada fila que tenga el mismo tipo quedando un resultado así:
    SERVICIO                                           TIPO                                               CANTIDAD    TOTAL
-------------------------------------------------- -------------------------------------------------- ----------- -----------
Transporte Hormigón (General Velasquez)            LABORAL Y PREVISIONAL                              15          30
Transporte Hormigón (General Velasquez)            MENSUALES PREVISIONALES PARA INFORME.              15          30
Transporte Hormigón (San Bernardo)                 LABORAL Y PREVISIONAL                              18          30
Transporte Hormigón (San Bernardo)                 MENSUALES PREVISIONALES PARA INFORME.              18          30

Me podrían ayudar a resolverlo? Ahora da la casualidad que los números son parecido, en datos reales va a variar mucho el resultado.

A: Realmente sólo tenías que corregir el JOIN de la solución de tu pregunta anterior.
WITH CTE(SERVICIO, TIPO, CANTIDAD, TOTAL) AS(
    SELECT NULL                                     , 'LABORAL Y PREVISIONAL                ', 2 , 6  UNION ALL
    SELECT NULL                                     , 'MENSUALES PREVISIONALES PARA INFORME.', 2 , 6  UNION ALL
    SELECT 'Transporte Hormigón (General Velasquez)', 'LABORAL Y PREVISIONAL                ', 13, 24 UNION ALL
    SELECT 'Transporte Hormigón (General Velasquez)', 'MENSUALES PREVISIONALES PARA INFORME.', 13, 24 UNION ALL
    SELECT 'Transporte Hormigón (San Bernardo)     ', 'LABORAL Y PREVISIONAL                ', 16, 24 UNION ALL
    SELECT 'Transporte Hormigón (San Bernardo)     ', 'MENSUALES PREVISIONALES PARA INFORME.', 16, 24
)
SELECT c.SERVICIO,
    c.TIPO,
    c.CANTIDAD + ct.CANTIDAD AS CANTIDAD,
    c.TOTAL + ct.TOTAL AS TOTAL
FROM CTE c
JOIN CTE ct ON c.TIPO = ct.TIPO
WHERE c.SERVICIO IS NOT NULL
AND ct.SERVICIO IS NULL

A: Puedes valerte de un CTE para realizar el cálculo, en caso que haya más de una fila por cada tipo.
Luego, hacer un left join con el CTE, por aquello que hubiese algún tipo que no tenga un valor general. Para ese caso, he utilizado la función coalesce para evitar que el cálculo devuelva null en caso que no haya un valor general para esa fila.
with
Datos as (
          select 'Transporte Hormigón (General Velasquez)' Servicio, 'LABORAL Y PREVISIONAL' Tipo, 13 Cantidad, 24 Total
union all select 'Transporte Hormigón (General Velasquez)', 'MENSUALES PREVISIONALES PARA INFORME.', 13, 24
union all select 'Transporte Hormigón (San Bernardo)', 'LABORAL Y PREVISIONAL', 16, 24
union all select 'Transporte Hormigón (San Bernardo)', 'MENSUALES PREVISIONALES PARA INFORME.', 16, 24
union all select null, 'LABORAL Y PREVISIONAL', 2, 6
union all select null, 'MENSUALES PREVISIONALES PARA INFORME.', 2, 6
)
,
ValorGeneral as (
select Tipo, sum(Cantidad) Cantidad, sum(Total) Total
  from Datos
 where Servicio is null
 group by Tipo
)
select   a.Servicio
       , a.Tipo
       , a.Cantidad + coalesce(b.Cantidad, 0) Cantidad
       , a.Total + coalesce(b.Total, 0) Total
  from Datos a
       left join ValorGeneral b on b.Tipo = a.Tipo
 where a.Servicio is not null;

redpajama_set_name: RedPajamaStackExchange


A set of 3 ceramic egg cups each inspired by a different architectural style. Have breakfast in a different city every morning, with Eastern, Classical and Russian styled buildings. The best part is that your boiled egg completes the dome on top of each building so you get to play Godzilla while you're waking up!
Ceramic, microwave & dishwasher safe.
In a box, 21.5 x 7.5 x 6.5 cm.


"Yesterday's Gone" is the title of a hit single by Chad & Jeremy which was released in 1963.
The song was written in 1962 by Chad Stuart, who comprised Chad & Jeremy with Jeremy Clyde; it is the first song Stuart ever wrote. Stuart shares the song's writing credit with Wendy Kidd, the manager of a band Stuart belonged to at the time of the song's writing; according to Stuart, Kidd was given the songwriting credit in return for allowing him to compose "Yesterday's Gone" on her piano. Kidd also facilitated Stuart's being hired as a staff writer at Rogers Music, which published "Yesterday's Gone", although the song remained unrecorded until Stuart and Clyde began performing as a duo, eventually recording "Yesterday's Gone" in July 1963 in a session at Abbey Road Studios produced and arranged by John Barry, who'd discovered Chad & Jeremy at a London club and signed them to Ember Records, a newly formed independent label in which Barry was a partner. According to Chad Stuart, John Barry was unhappy with the duo's first attempts to record their vocal for "Yesterday's Gone": "he told us...we sounded like a locker room full of football players...in the end in desperation he said: 'Whisper it', so we kind of backed off a bit and so that sort of slightly sotto voce sound came about".
Democrats must impeach Trump, but not for the reason you think.


text:
Business and Industry (Remove)
Objects and Artifacts (Remove)
Type of Material (Remove)
Thematic Time Period -- Civil War, 1861 - 1865 (Remove)
Kansas Relief Committee, newspaper article
Smith, I. N.
This article, published in the Haverhill, Massachusetts Tri-Weekly Publisher, lists the contributions collected by their local Kansas Relief Committee. A number of different churches in the area donated cash, and the committee also sent varied articles of clothing (listed in the article) to General S.C. Pomeroy of Atchison.
William Addison Phillips
Portrait of William Addison Phillips, an author, lawyer, journalist and politician. In 1857, Phillips attended the Constitution Convention at Topeka and the Free State Conventions at Centropolis, Lawrence, and Grasshopper Falls. He founded the town of Salina in April, 1858. In that same month and year, Phillips was nominated at the Topeka Free-State Convention under the Leavenworth Constitution to serve as a supreme court judge. He attended the Convention at Osawatomie and the Republican State Convention at Lawrence in 1859. Phillips served in the Kansas Volunteer Regiments and rose to the rank of colonel. From March 4, 1873 to March 3, 1875 Phillips was an at large representative to the United States Congress and from March 4, 1875 to March 3, 1879 he represented the First District.
Leigh R. Webber to Miss Brown
Webber, L. R.
A letter written by Leigh R. Webber from "Steamer Robert Campbell Jr. near Liberty Mo.," is addressed to Miss Brown, a daughter of John Stillman Brown, a Unitarian minister who lived west of Lawrence, Kansas. Webber describes how his fellow troops have become more experienced soldiers "who fight for liberty and law." He discusses the march from Fort Riley to Fort Leavenworth and conditions on the boat that was taking them further south. He also mentiones William Brown's new law position with former Kansas Territory governor Wilson Shannon.
Media/Communications
Occupations/Professions
Objects and Artifacts
Communication Artifacts
Unpublished documents
Courtship and marriage
Reform and Protest
Territorial Government
Forts and military installations
Town development
Bleeding Kansas, 1854 - 1861
Immigration and Settlement, 1854 - 1890
http://www.kshs.org/km/facets/view/facets:137,1308,1253,2685,4060,890,1288,1309,711,1252,1182


In it's database, there is a record for each image. Hence it's the database storage limit which comes into play, and since we're using MySQL as the database, the limit is very large. A number of factors determine the maximum number, but the worse case would be in the millions.
The first storage limiting factor most customer come across with DBGallery is performance beyond some number of images. This is dependent on the processor, disk and network speed. For example, on a fast 2017 computer (I7 8th generation, 16 GB ram) on the same kind of server, performance degradates at as you head towards 1 million images.


text:
What is mathematics?
This question is rarely asked, but it seems students are uneasy not to have some kind of answer! They know that mathematics has many applications, and that this is a good reason for studying it. But that leaves open the question of:
what is it about mathematics that allows so many applications?
Here is a quick answer which I believe gives a flavour of the subject and a lead into further development of this description. Mathematics gives a language for rigorous expression of intuitions so as to allow
description,
deduction,
explanation,
proof, verification and falsification,
analogy,
a methodology for developing all of these!
Often we want to know not only that something is true but why it is true. This search for understanding is basic to the progress of mathematics. The search for understanding often leads to the development of new worlds of mathematics, whose applications then ring down the centuries.
Note that engineering and physics depend on the mathematical basis of the calculations in those subjects.
The capacity of mathematics for description is shown by one example: the mathematics of quantum mechanics describes the real world in a way inaccessible to common sense and common language.
The use of abstraction and symbolic representation to show appropriate information ansd structure is well known, as in the famous map of the London Underground, which is held up as an example of good design. Of course the use of appropriate notation is a key to the success of mathematics. An early example is the introduction of the equals sign, =, by Robert Recorde in 1557.
The use of mathematics for analogy is suprisingly neglected in the teaching of mathematics. See our exposition on knots for the analogy between prime knots and prime numbers. To obtain such analogies, the use of abstraction is an essential part. It is abstraction by which we compare structures. See an article on category theory as a basis for analogy and comparison (pdf).
I gave a presentation on knots to schools in Leicester in the 1980s, and a teacher afterwards came up to me and said that was the first time he had heard the word `analogy' used in relation to mathematics! Of course analogies are not between things but between the relations between things, and it is the power of abstraction to allow far reaching analogies.
Our knot exhibition also uses the theme of knots to illustrate some basic methods of mathematics:
classification,
breaking a complex structure into smaller parts,
laws,
Thus the applications come after the previous necessary developments.
Mathematics has developed a range of new structures and of new worlds, suggesting the relevance of a quotation on the role of the poet.
The great geneticist Dobzhansky has written: `Nothing in biology is comprehensible except in the context of evolution'. How then can we explain mathematics in this context? Perhaps the idea of structure gives a clue. Organisms must make some model of the environment to survive, and these models or maps reveal, and simplify considerably, the structure of the environment, to be efficient. The model, or map, has to be smaller than the original! So the organism has some idea of the landscape in which it lives. This model also has to record how the landscape behaves, it has to give the landscape structure.
So in mathematics we get the developing notion of `mathematical structure'. There was an emphasis on this in the great advances in exposition by Bourbaki, but which still tried to reduce mathematics to logic and set theory. We now know, through Godel and others, that this project was doomed, but that also that the attempt was valuable. (See Yuri Manin's `Georg Cantor and His Heritage': ) There seem to great advantages in following the categorical approach: certainly the literature on category theory shows a strong interest in discussing the aims of the subject, and of mathematics!
For further discussion, see the article The methodology of mathematics, R. Brown and T. Porter. In that article we quote some views of the famous physicist E. Wigner, of which a sample is:
"Mathematics is the science of skilful operations with concepts and rules invented just for this purpose. [this purpose being the skilful operation ....]
"The principal emphasis is on the invention of concepts.
"The depth of thought which goes into the formation of mathematical concepts is later justified by the skill with which these concepts are used. "
The paper on Making a Mathematical Exhibition also discusses these issues, since we needed to decide what we were trying to say about mathematics in order to structure the exhibition. The exhibition illustrates how applications come after various basic procedures which are esentially moving towards understanding are carried out. This is the basic case for abstract mathematics.
See also my small article on the links of Bangor with the great master of the invention of new mathematical concepts and language, Alexander Grothendieck.
In 1964 I met Sam Ulam at a conference in Syracuse, Sicily ,(my first international conference). He remarked that young people may think that the most ambitious aim would be to solve a famous conjecture. He urged that pursuing that aim might distract them from developing the mathematics most appropriate to them. I found it interesting that someone as good as Ulam should urge this view! See also a discussion on famous problems.
Finally, Jan Abas has urged that I should state strongly that a part of the attraction of mathematics is the notion of beauty. This is a quality he conveys with his web site on Islamic Art. This link with beauty and imagination is also the motivation behind the web site of the Center for the Popularisation of Mathematics.
Here is a link in French developing some of these ideas.
See also the site of the juggler Colin Wright for views on the nature of mathematics.
Download Yu L. Manin's articles on Mathematical knowledge: internal, social and cultural aspects, Truth as value and duty: lessons of mathematics.
Here is a link to a set of my articles on popularisation and teaching, including one on quality assurance, and another on category theory as a basis for analogy and comparison (pdf), and on Promoting Mathematics . See also the mathoetic mode.
See also Games and Mathematics, by David Wells, (CUP, 2012).
Ronnie Brown
revised slightly May 28, 2008; December 29, 30, 2008; September 10, 2009; January 23, 2010; August 14, 2014.


text:
Last Post For The Day….
December 1, 2016 / Visionkeeper
Cosmic Weather Report
Come Out, Come Out, Wherever You Are
By Soul Level Astrologer Mark Borax
Putney Mountain, Vermont
By Mat Szulik
December starts with a burst of energy from Mars-trine-Jupiter on the 1st, as well as a sextile from Mars to Saturn on the 3rd, and a sextile from Mars to Uranus on the 6th. These three positive Mars hook-ups supply a much-needed energy that's recently been lacking in many people's lives.
The power of Mars energizes us to open the stuck gates of change. This month the red planet amps up the adventurer within us to push back against the closing walls of narrow, obsolete thought that clamp down on creative freedom and independence. With that Mars supercharge we can break out of old energies and stories that confine us into the wide-open territory of change and transformation.
Near the end of the month Jupiter opposes Uranus on the 26th and Uranus goes direct on the 29th, two Uranian activations that further the cause of liberation and breakthrough because Uranus is the planet of revolution (that was discovered at the time of the French and American Revolutions.) The energies that Mars raises on a personal level at the beginning of the month, Uranus raises on a collective level at the end of the month — lifting the consciousness of a species that's gotten depressed and stalled in its progressive evolution.
By Vanesa Martinelli
Three of these five astrological movements occur in Degree Frequency 21, which raises the issue of who you've been trained to be versus who you really are. This is the breakthrough issue of our time, because when human beings awaken to realize how much power they have to change themselves in a way that changes the world, we tip the balance away from fear and bigotry toward the unity that results from realizing that our similarities are much stronger than our differences.
Lacking that breakthrough awakening, we sleepwalk through life activating a mere fraction of the creative dynamo we contain inside. This Trance of Normalcy set in as a reaction to the 1960s Revolution in Consciousness that flooded the gates of change so powerfully it scared the daylights out of conservative forces that yanked back hard in the other direction. A numbness set in that we can eradicate by fanning the flames of change through music, politics, art and inspiration.
From The Goddess Diaries
Once again, as occurred in the 1960s, forces of intolerance and suppression are being trumped up on the world stage. With the fiery drive supplied by Mars at the beginning of December, and the amplified consciousness supplied by Uranus around the potent time of Winter Solstice, we're being summoned to energize the creative core inside that recharges us to bust out of the machine and claim our fuller destiny in an act of liberation that becomes instantly contagious, calling like-minded soul to come out, come out, wherever you are.
Love Your Life Out~
Mark Borax
Who Are You Really? What Are You Here For?
How Much Longer Are You Willing to Wait?
Master Soul Level Astrologer Mark Borax
Mark Borax is a teacher, astrologer, songwriter and bestselling author who lives in Vermont and writes the monthly Cosmic Weather Report email newsletter. He offers readings over the telephone and in-person, and classes that catalyze individual evolution. His books
2012 and the Cosmic Weather Report can be ordered from bookstores and Amazon. www.markborax.com
← A Message For Christmas…
Where Are We ? →


I am a bit struggling with more advanced pyro stuff, I have to make a very tall and hi res smoke plume from a relatively large flat source.
Now I did make it a cluster from the shelf and that works fine on the orizontal plane, but in order to maintain the containers hi res I was wandering if and how, I could cluster them also vertically along the y axes in orther to avoid a number of thin but supertall containers which would as well lose resolution and solve slower.
Yes sure you can. If is just one source you can use the shelf tool container tools -> distribute container you can then go to the /out context and set here the slice divisions in the y axis. X and Z need to be at least 1.


text:
namespace blink {

TrustedHTML::TrustedHTML(String html) : html_(std::move(html)) {}

const String& TrustedHTML::toString() const {
  return html_;
}

}  // namespace blink

redpajama_set_name: RedPajamaGithub


text:
Square of Violence
Set in Italy, the story takes place in this very country, during WW2, where German occupation army ruled everything, just before the allied forces came, in 1944. Crawford plays here…
30,25 min
Supercar was a children's TV show produced by Gerry Anderson and Arthur Provis's AP Films for ATV and ITC Entertainment. 39 episodes were produced between 1961 and 1962, and it…
The Defenders is an American courtroom drama series . It starred E. G. Marshall and Robert Reed as father-and-son defense attorneys who specialized in legally complex cases, with defendants such…
Operation Bottleneck
WWII Burma…Six paratroopers undertake an extremely dangerous mission against the Japanese. It will ultimately cost them their lives, except for one "lucky" survivor.
The Wonders of Aladdin
Young Aladdin (Donald O'Connor) has a series of wild adventures after he discovers a magic lamp containing a genie (Vittorio De Sica).
Wilbur Post and his wife Carol move into a beautiful new home. When Wilbur takes a look in his new barn, he finds that the former owner left his horse…
The Fat and the Lean
A small and thin barefoot slave (played by Polanski) plays a flute and beats a drum to entertain his large master who rocks in a rocking chair in front of…
Voyage to the Bottom of the Sea is a 1960s American science fiction television
Genre: Action & Adventure, Drama, Sci-Fi & Fantasy
The Greengage Summer
Sensitive story of a British girl's awakening from childhood into life and love on vacation in France.
Invasion Quartet
This British men-on-a-mission spoof set during World War II finds intrepid officer Bill Travers leading three colorful compatriots into Nazi-occupied France to destroy an obnoxiously large, loud, and destructive enemy…
One Hundred and One Dalmatians
When a litter of dalmatian puppies are abducted by the minions of Cruella De Vil, the parents must find them before she uses them for a diabolical fashion statement. In…
Three on a Spree
A young man will inherit a huge fortune–8 million pounds–but to qualify, he must spend a million pounds in just two months. Easy to do? That's what you think!
Chad Gates has just been discharged from the Army, and is happy to be back in Hawaii with his surf-board, his beach buddies and his girlfriend.
Epic account of the thief Barabbas, who was spared crucifixion when Pilate manipulated the crowd into pardoning him, rather than Jesus. Struggling with his spirituality, Barabbas goes through many ordeals…
Genre: Adventure, Drama, History
A man who served prison time for intent to molest a child tries to build a new life with the help of a sympathetic psychiatrist.
Viva l'Italia!
The film shows how Italy's historic national hero Giuseppe Garibaldi (embodied by Renzo Ricci) leads a military campaign known as Expedition of the Thousand in 1860 and conquers Sicily and…
Genre: Drama, History
All roads lead to magical, merry Toyland as Mary Contrary and Tom Piper prepare for their wedding! But villainous Barnaby wants Mary for himself, so he kidnaps Tom, setting off…
Genre: Comedy, Family, Fantasy, Music
Cash on Demand
A charming but ruthless criminal holds the family of a bank manager hostage as part of a cold-blooded plan to steal 97,000 pounds.
All in a Night's Work
Dean Martin and Shirley MacLaine star in this sweet 1961 comedy about Tony Ryder (Martin), who takes over the duties of magazine publisher when his uncle dies suddenly, supposedly while…
The Curse of the Werewolf
A child conceived after a demented beggar rapes a mute servant girl is raised by a wealthy but kindly bachelor gentleman and his woman servant who learn, years later, that…
Dr.Decker comes back from Africa after a year, presumed dead. During that year, he came across a way of growing plants and animals to an enormous size. He brings back…
Genre: Horror, Romance, Science Fiction
Erik the Conqueror
In the 9th Century, two Viking children, separated since their early childhood with one raised by the British and the other by Vikings, meet after nearly 20 years as rivals…
Brendan O'Malley arrives at the Mexican home of old flame Belle Breckenridge to find her married to a drunkard getting ready for a cattle drive to Texas. Hot on O'Malley's…
Werewolf in a Girls' Dormitory
The new science teacher Dr. Julian Olcott with a mysterious past arrives in an institutional boarding school for troublemaker girls. Along the night, the intern Mary Smith, who is blackmailing…
Genre: Horror, Mystery
Mr. Sardonicus
A search for a winning lottery ticket in his dead father's grave causes Sardonicus' face to freeze in a horrible grimace, until he forces a doctor to treat his affliction–with…
Shipwreck survivors are found on a presumably uninhabited and irradiated island called Infant Island. A joint expedition of Roliscan and Japanese scientists explore the island and discover the Shobijin, the…
Genre: Fantasy, Mystery, Science Fiction, Thriller
Summer and Smoke
In a small Mississippi town in 1916, an eccentric spinster battles her romantic yearnings for the randy boy next door. A 1961 film, adapted from a Tennessee Williams play, starring…
The Strange Countess
Strange fortune hunters are behind a girl's murder in this Edgar Wallace tale.
Genre: Adventure, Crime
The Terror of the Tongs
In 1910, Hong Kong, under the rule of the British Empire, is a prosperous and bustling city, but, hidden in the shadows of its many narrow streets, the hideous members…
Genre: Crime, Mystery
In the slums of the upper West Side of Manhattan, New York, a gang of Polish-American teenagers called the Jets compete with a rival gang of recently immigrated Puerto Ricans,…
Genre: Crime, Drama, Romance
Two Rode Together
Two tough westerners bring home a group of settlers who have spent years as Comanche hostages.
In early 1960s London, barrister Melville Farr is on the path to success. With his practice winning cases and a loving marriage to his wife, Farr's career and personal life…
When an undersea volcano sends tremors throughout the Atlantic, aquatic creatures come out of hiding. Merchant seamen Joe Ryan and partner Sam Slade harness the most unusual of the lot,…
The Man with a Shotgun
Ryoji, a wanderer, arrives in a remote mountain town, carrying a shotgun and claiming to be a hunter. He quickly becomes embroiled in a web of trouble surrounding the town's…
Tokyo Knights
A college student takes over the family business in the field of organised crime.
Reptilicus
A portion of the tail of a prehistoric reptile is discovered in Denmark. It regenerates into the entire reptile, which proceeds to destroy buildings and property and generally make a…
Mother Joan of the Angels
Set in the 17th century. A convent in a small town is being visited by high-ranking Catholic official trying to exorcise the nun supposedly possessed by demons. A local priest…
The Counterfeiters of Paris
"Le Dabe" retired many years ago and now he lives in the Tropics where he owns stables and horses. He is a very rich man. He was the king of…
A Story of Water
With the full-force fury of the French New Wave film movement behind them Truffaut and Godard were just beginning to feel their oats when they co-directed this small gem. With…
Genre: Adventure, Comedy, Romance
Kipling's Women
Nudie-cutie suggested, as the title lets on, by a Kipling poem. Whoda thunk?
Powered By purimovies


Hi, I'm using Gallery version 1.2.1, and I recently discovered the layout gets all messed up in Internet Explorer. It does not center, nor does the nav bar function properly as well. Any help in the matter would be greatly appreciated.


text:
SubscribeSearch
Dimensions and Outlook festivals move to Šibenik-Knin county from 2020
Time Out contributors
Wednesday 9 October 2019
Two of the most popular dance music festivals held on the Croatian coast have today announced their new home. Both Outlook and Dimensions festivals, previously held in Pula, will take up residence in Šibenik-Knin county from 2020.
The festivals are more than 10 years old and, since they began, have been partly responsible for promoting the city of Pula to become the third most popular Croatian destination searched for on Google (after Zagreb and Dubrovnik). The move will see the festivals use The Garden festival site in Tisno, sharing the same infrastructure and outdoor nightclub, Barbarellas in Pirovac, as events like Love International (pictured), Defected Croatia, Hospitality On The Beach, Suncebeat and Dekmantel Selectors. At least one (if not both) of the new additions will also use St Michael's Fortress in Šibenik for their famous opening concerts. The opening concerts had previously been held in Pula amphitheatre.
At the beginning of 2019, both festivals announced that this summer would be their last using Fort Punta Christo and Pula amphitheatre, although no information was given regarding where they would be moving to or even if they would continue. In recent years, both festivals had suffered bad luck with the weather. Scheduled to take place right at the end of summer, storms had marred some days completely and the festival site had been struck with power blackouts.
After news broke of the festivals' departure from Pula, some locals wondered if the city had done enough to keep the festivals; it is understood assistance was sought by the festivals in attempts to prevent any further power outages, but no solution had been forthcoming. With its operators having more than a decade of experience on the site at Tisno, attendees at festivals taking place at The Garden, Tisno do not experience such setbacks. The festivals' move to Šibenik-Knin county will also allow them to take place earlier in the season, hopefully circumnavigating the more unpredictable, late summer weather.
Outlook, now renamed Outlook Origins in reference to the back-to-basics approach the festival will take in its new home, will take place from July 30 to August 4, while Dimensions will take place from August 13 to August 18. Fans of the festivals will have to be super quick in order to secure tickets for the events as their relocation to Tisno demands a significant reduction in attendee numbers. The Garden site in Tisno usually caters to a maximum capacity of around 5000 festival-goers. The former site in Pula was capable of handling 15, 000, meaning each festival will be losing two-thirds of its capacity.
Time Out Croatia


Ben is a business attorney with more than 18 years of experience. He is licensed to practice law in Indiana and holds a Juris Doctor degree in law, which he obtained from the Indiana University Robert H. McKinney School of Law. Magneto specializes in a wide range of corporate legal practice areas, including commercial contracts, labor and employment law, and business formation. He has been an attorney at Outsourced General Counsel since November 2017.
"Great job, very personable and thorough!"
Why use UpCounsel to hire a Neenah Copyright Attorney?
Our Neenah copyright attorneys & lawyers can help you register a copyright for your original work of authorship. This will ensure that you have documented proof of your copyright ownership. Because, if you don't file it, you can't sue if someone uses your work.
Once registered, the copyright lawyer you chose can also assist you with the development of licensing and/or distribution agreements so you can collect royalties on your original work of authorship. The copyright attorneys & lawyers on UpCounsel represent entrepreneurs, musicians, actors, artists, TV producers, and authors. Our Neenah copyright attorneys can also assist you with fighting copyright infringement in the case a party infringes on any of your copyrights, as they'll seek to prevent it and seek damages from any and all infringers. Many attorneys also have expertise in defending clients against claims of infringement.
Improve Your Legal ROI with Affordable Copyright Attorneys that service Neenah, WI.
Want to Connect with Top Neenah Copyright Attorneys & Lawyers?


Aalto Fintech Seminar continues in October-November 2019.
rapidly changing global landscape: Fintech startups and large tech companies are challenging traditional banks and financial institutions. According to PwC report 2017, financial services could lose as much as 40% of revenue to Fintech firms.
The seminar provides a holistic view on how these factors are powerfully reshaping and redefining the financial industry. The outcome is unknown.
Several topical subjects will be presented by Finnish top experts in Fintech, representing both incumbents and start-up companies. The seminar is free and open to everyone. The language is English. WELCOME!
Please find more instructions on page 'Passing the course'.
The course is graded passed/failed. There are no prerequisites.
The course can be included in the Minor in Financial Engineering, 20-25 cr.
The seminar takes place weekly in September-October 2018 at Aalto Otaniemi campus, Lecture Hall TU2, TUAS building. Maarintie 8. All five seminars are free-of-charge and open to the public.
Digital transformation in the financial industry: what's good for the society?


CHICAGO -- A Chicago man has been charged in a deadly hit-and-run crash on the West Side, police said Friday.
Investigators said Jesse Gather, 48, was driving in the 1300-block of South Kedzie Avenue on Wednesday when he struck the victim as she crossed the street.
He drove away from the scene and was caught a short time later, police said.
The victim is a 35-year-old woman. Authorities have not released her identity.
Gather has been charged with felony counts of reckless homicide/motor vehicle and leaving the scene of an accident involving injury death and a misdemeanor count of reckless driving. He is scheduled to appear in bond court on Saturday.


text:
Home / news / 193 almajiria test positive for COVID-19 in Kano state
193 almajiria test positive for COVID-19 in Kano state
by nkechiarioleblog on 09:32 in news
A total of 193 Almajiris in Kano State have so far tested positive to COVID 19, according to the Kano state government.
Speaking at the COVID-19 press briefing held, Thursday, July 2, Kano State Commissioner of Education, Sanusi Mohammed Kiru disclosed that a total of 1860 persons were quarantined in three locations in the state, out of which 193 of them tested positive.
Sanusi who is also the head of the state government's committee on the rehabilitation of almajiris, explained that 86 of them tested positive at Gabasawa Quarantine camp, 68 tested positive in Karaye while 38 tested positive in Kiru.
He expressed happiness at the initiative to isolate the almajiris in the state, adding that state efforts at tackling the dreaded disease would have been worse off if they were allowed to continue to spread the disease in these communities.
He recalled that so far the state has repatriated a total of 1183 Almajirs to the rest of the states in the region such as Jigawa, Kaduna, Katsina, Gombe, Bauchi, Kebbi, and Zamfara States in line with the decision of the Northern Governors forum to end street begging in the region.
He further disclosed that the state government had established three almajiri boarding schools for the immediate admission of the Almajiris of Kano State orIgin, saying that these schools are located in Bunkure, Bagwai and Madobi Local Government Areas.
Tags # news


Your ultimate weapon in the war on shine. Smooth it on before your favorite foundation for a fresh, flawless, marvelously matte look that lasts and lasts. Wear it solo too for a naturally shine-free look.
For most recent ingredient list, please refer to packaging. Dimethicone Crosspolymer, Dimethicone, Cyclopentasiloxane, Isododecane, Isononyl Isononanoate, Trimethylsiloxysilicate, Silica Dimethyl Silylate, Phenoxyethanol, Caprylyl Glycol.


Designed for immediate gratification, this kit is made for office or at-home printing. Simply unzip the file, drop your preferred 11×17" paper into the tray, and hit 'print at scale.'. Once you have your sheets, simply follow the template to cut out each placard and place them on your desired surface.
A neighborhood diagnostic to explore community resources and need.
An events scenario to gauge audience interest and engagement levels.
We've even included extra questions and suggestions for mixing and matching! For those that love it and want to keep putting it to use, we suggest laminating your placards to extend their use.
After purchase, you will receive an email a protected link for downloads within 24 hours. To ensure proper delivery, confirm your email before purchasing. Each order includes a single download.
Please note: Set-up is scaled for a 3×4' corkboard, but can easily be sized to match your desired or available dimensions. Check out our FAQ section for more information on how to customize Community Census for your context.
– Local groups hosting a community meeting.
– Non-profits conducting outreach at street fairs or conferences.
– Community organizations researching new programming.
– Anyone holding a single event or simply interested in testing the concept out!


*Many of our products are sold via authorized dealers. If your local tack store doesn't carry our trademark TrailMax™ or Outfitters Supply™ products, ask them why.
If you are interested in becoming an authorized Outfitters Supply dealer, please read our terms and conditions.
FARM & RANCH FEED STORE, LLC.


text:
Kent's 10 worst crimes: Horrifying stories behind the cases which shook the county
Some cases will forever be etched into the history of the communities they affected
Andy RobinsonSenior Reporter
Kent's 10 worst crimes
All crime has a victim and it is impossible to quantify the unimaginable damage of its impact.
But some crimes can shock communities in ways only the most seriously depraved acts can.
They can leave towns fragile and in mourning for some time afterwards as the aftermath is repaired to normality.
Kent has witnessed its fair share of major crime over the years but some stick in the memory longer than others.
Even more recent convictions of the likes of Ben Lacomba, Andrew Griggs and Samantha Ford will be spoken of for years to come within the communities affected.
Here are 10 crimes that shook the county of Kent and the criminals who have gone down in history among the worst of the worst.
Michael Stone and the Chillenden murders
Michael Stone shouts as he departs from a court in September 2005 (Image: Getty)
The brutal killing of a mother and daughter in Chillenden shook the entire country and is arguably one of Kent's most notorious crimes.
They were bludgeoned to death with a hammer in a country lane near Canterbury more than 20 years ago.
On July 9, 1996, Lin Russell, 45, and her daughters Megan, six, and Josie, nine, were walking home with their dog down a quiet country lane after a school swimming competition.
They were then set upon by an attacker who tied them up, blindfolded them and launched a savage beating.
Lin Russell, who died in the vicious attack, pictured in 1989 with her daughter Josie who somehow pulled through (Image: PA Archive/PA Images)
Lin, Megan and the dog all died, while Josie miraculously survived despite suffering horrendous injuries.
In July 1997, police arrested and charged Michael Stone, who was 37 at the time, with the crimes.
He pleaded not guilty at his first trial in 1998 but was convicted after a witness claimed Stone had confessed to the murders while in prison.
Stone, who was living in Gillingham, was sentenced to life imprisonment in 2001 for two counts of murder and one for attempted murder.
Megan Russell (right), who was killed, with her sister Josie (left) (Image: PA Archive/PA Images)
Stone's original conviction was actually overturned on appeal but he was found guilty in his second trial, based on the evidence of another inmate.
He also appealed in 2004 but it failed.
On December 21, 2006, a High Court judge ruled that Stone must spend at least 25 years in prison before being considered for parole.
He is serving three life sentences and is likely to remain in prison until at least 2023, when he will be 63.
Michael Stone was sentenced to life in prison in 2001
Stone has always protested his innocence, claiming he was not responsible for the deaths of Lin and Megan Russell.
In 2017, his legal team launched an appeal with evidence of a "full confession" by Bellfield, the killer of schoolgirl Milly Dowler.
However, this has already been denied an Appeal Court hearing subject to a final ruling on December 2.
Patrick Mackay and Anthony Crean
Patrick Mackay (Image: PA – Mediadrum/JohnLucas/Penand)
Patrick Mackay is thought to be the UK's longest serving prisoner and one of the country's most notorious serial killers.
He was born in Dartford and committed his last killing in nearby village Shorne.
At the age of 22, Mackay split Father Anthony Crean's skull open with an axe and repeatedly stabbed him to death in 1975.
The killer was at the priest's home when he committed the horrific attack.
They had become friends but fell out after Mackay was caught stealing an £80 cheque from Father Crean.
On March 21, 1975, Mackay returned to Father Crean's Shorne home and struck him through the head with an axe.
The Nazi-obsessed beast dumped the 63-year-old's body in a bath and started the taps running while watching him die.
Mackay was arrested shortly afterwards.
Father Anthony Joseph Crean, a Roman Catholic priest from Shorne, was one of the victims of murderer Patrick David Mackay (Image: PA Archive/PA Images)
Website Crime + Investigation explains: "Mackay lets himself into Father Crean's cottage in his absence, and when the Father returns they fight in the hallway of the house.
"Crean manages to break free and locks himself in the bathroom but Mackay finds an axe and uses it to break through the door.
"He then stabs the old man repeatedly in a frenzied attack, finally killing him by striking in the head with the axe.
"Later that evening a nun, who is concerned about the whereabouts of Father Crean, makes a horrific discovery.
"She finds him, floating in a bath full of bloody water."
The worst crime in Kent
Knife crime which shocked Kent
Brutal M25 murder
Criminals applying to be teachers
Horrific Canterbury murder
Baby-faced criminals
Most dangerous streets in Thanet
'When we found out Molly was murdered'
Baby abuser beaten in prison
Mackay was found by police in Stockwell in South London on March 23, 1975, two days after he had killed Father Crean.
That November he was handed a life sentence in prison with a minimum term of 20 years.
Mackay was also convicted of two previous killings but admitted to eight more unsolved murders before retracting his confessions.
The Tonbridge Securitas robbery
The gang as they made their way into the depot
The biggest ever cash robbery in British history happened right here in Kent.
This time 13 years ago, a ruthless gang conspired to carry out not only one of the country's most shocking criminal operations ever – but the second largest scale cash raid in world history.
At around 6.30pm on February 21, 2006, the manager of the Securitas cash depot in Vale Road, Tonbridge was abducted while driving his silver Nissan Almera on the A249 in Stockbury.
Police work in the grounds of Elderden Farm in Staplehurst on March 2, 2006 (Image: MAX NASH/AFP/Getty Images)
Colin Dixon had been kidnapped and was taken to a farm in Staplehurst, where his wife and eight-year-old son were also taken.
Held at gunpoint, the men told Colin that failure to cooperate could put him and his family in danger.
They were all then taken to the Securitas depot in Tonbridge in a white van at around 1am, now on February 22, while still being held at gunpoint.
Armed with AK-47s, shotguns, handguns, a Škorpion and wearing balaclavas, 14 members of staff at the depot were bound by the robbers.
14 members of staff were held hostage at gunpoint at the Securitas depot in Tonbridge during the biggest robbery in British history
After a terrifying two hours, the robbery finally came to an end and the assailants fled at around 2.45am, leaving the staff, Colin, his wife and their son locked in cash cages.
Fortunately, one member of staff had a key to unlock the cage she was trapped in and was then able to free the others once out.
It took half an hour to raise the alarm but thankfully no one was hurt.
£53,116,760 in bank notes was stolen from the cash depot.
The Bank of England, which owned the money at the Securitas depot, was reimbursed £25 million by Securitas the same day of the robbery.
The only more lucrative cash robbery worldwide was when $1 billion was stolen from the Central Bank of Iraq after the United States started bombing Baghdad in March 2003.
The Securitas depot robbery is the biggest in Britain's history
Stuart Royle, Roger Coutts, Lea Rusha and Jetmir Bucpapa were all jailed for life for their part in the Securitas depot robbery.
Emir Hysenaj was sent down for 20 years, while former mixed martial arts fighter Lee Murray was later sentenced to 25 years in prison for his role in the heist.
At least 36 arrests were made during the extensive police investigation before a trial began for Royle, Coutts, Rusha, Bucpapa and Hysenaj on June 26, 2007.
On January 28, 2008, a guilty verdict was returned by the jury for those five.
Murray wasn't jailed until June 1, 2010 in Morocco – his initial sentence was just 10 years but it was later increased to 25 years.
Peter Tobin and the bodies buried in Margate
Peter Tobin (Image: PA)
It has been more than a decade since the bodies of two girls were discovered bound, gagged and murdered in a Margate garden.
They had been victims of notorious Scottish serial killer Peter Tobin, who is currently serving three life sentences.
Tobin had been sentenced to 21 years in prison in May 2007 for the rape and murder of Polish student Angelika Kluk.
In November of that year, police started digging in the garden of his Irvine Drive home in Margate.
The 1991 murders of the two teenage girls remained unsolved until 2007 (Image: Peter Macdiarmin/Getty Images)
Officers were investigating the murder of Dinah McNicol, an 18-year-old girl from Essex who went missing in August 1991.
Forensic teams then made the shocking discovery of not just young Dinah's body but also that of 15-year-old Vicky Hamilton.
The Scottish teenager had gone missing just months before Dinah - in February 1991.
She had last been seen in Bathgate, lost and asking people for directions, as she made her way home after spending the weekend with her sister.
Peter Tobin is one of the UK's most notorious serial killers (Image: Peter Kelly/ The Sun)
But the mystery of her disappearance became clear when forensic teams who had been digging came across two bin bags containing her body.
The youngster had been abducted from her West Lothian hometown and later raped and murdered.
Just a few feet away from her body, they also found that of Dinah, who had been bound and gagged.
Dinah, who had just finished her A-Levels when she was murdered, had last been seen in August 1991 hitchhiking home with a male companion she met at a music festival in Hampshire.
Police found 15-year-old Vicky Hamilton's body while searching for that of 18-year-old Dinah McNicol (Image: Cate Gillon/Getty Images)
The pair had been picked up by a man who promised to take her to Brentwood and after her companion was dropped off on the M25, she was never seen again.
Both bodies had been covered by a thin layer of cement before being re-covered with soil.
Tobin had initially moved to the Irvine Drive address when he took part in a house swap with a Margate couple in March 1991 - five weeks after Vicky had gone missing and five months before Dinah disappeared.
David Martin, who lived next door to the serial killer, remarked how normal he had seemed and how he and his wife had advised their teenage daughter to go to Tobin's house if they were not home.
Forensics experts found the two bodies buried in bin bags under thin layers of concrete (Image: Edmond Terakopian/Getty Images)
Tobin had once told the unsuspecting Mr Martin that he was creating a sandpit for his son - he was actually digging the graves.
On December 2, 2008, Tobin was convicted of Vicky's murder and on December 16, 2009, he was found guilty of kidnapping, drugging, raping and murdering Dinah.
In Dinah's case, it took the jury just 13 minutes to find him guilty.
Tobin currently resides in HM Prison Edinburgh where he will spend the rest of his life. He was diagnosed with cancer in January and reportedly "on the verge of death".
Anthony Imelia - the M25 rapist
The M25 rapist who never showed remorse for any of his crimes died in prison while making a bid to be freed from behind bars.
Sex beast Antoni Imiela who lived in Appledore was given his name as the M25 rapist after he targeted women and young girls near the London orbital motorway.
The 63-year-old had spent less than 14 years in jail before he died of heart problems in March last year at Wakefield Prison.
Imiela was behind bars for raping nine women and girls between 1987 and 2002, with the youngest victim being 10.
Former railway worker Imiela would grab his victims, often beating them or threatening them with a knife.
The German national moved to England in 1961.
His first attack dated back to 1987 when he raped a woman on Christmas Day. The last was in 2002 when he indecently assaulted and attempted to rape a girl of 10 in Birmingham.
Serious crime in Kent
Missing mum murder investigation
Wife and lover's plot to murder husband
Teenage girls describe hammer attack
Drug dealers locked up
Det Supt Colin Murray, who led the investigation, called him "without exception, the worst criminal I have ever dealt with".
Imiela rang the mother of one victim, aged 25, after an attack and said: "You know your daughter? I've just sh*gged her. You'll hear about it later."
The beast was sentenced at Maidstone crown court in March 2004.
Although he was given seven life terms the judge ruled he should serve a minimum of only eight years.
Fearing he could be freed, prosecutors later pursued another rape case from 1987 and in 2012 he was convicted and sentenced to a further 12 years.
Imiela never admitted a sex offence.
Delyth Andrews: The 3 brothers who carried out a 7 hour WWE attack and killed her
Scott, Adam and Joshua Knight (Image: Kent Police)
On November 16, 2015, Scott, Adam and Joshua Knight viciously attacked 54-year-old Delyth Andrews in one of the most brutal attacks in recent years.
The trio beat the woman in her Ramsgate home for at least six hours, kicking and jumping on her and practicing wrestling moves on her.
Ms Andrews was left with a broken back, as well as broken ribs and bruising, and died seven weeks later.
Both Adam and Joshua Knight were teenagers at the time of the attack.
Scott Knight told police that he and his brothers had smoked the drug Spice before the assault on Ms Andrews.
Their victim had originally taken in the brothers' homeless mother rent-free in early 2015 and they also moved in within weeks, at which point they began bullying her.
They were all convicted of murder on July 14, 2016 and were sentenced to life with a minimum of 23 years.
Tunbridge Wells bedsit murders
Wendy Knell was found dead 31 years ago (Image: Kent Live)
It has been more than 30 years since two young women were discovered dead in bedsits in Tunbridge Wells.
Wendy Knell's body was discovered dead in her bedsit in Guildford Road on June 23, 1987 and Caroline Pierce, 20, who lived in a bedsit in Grosvenor Park, was murdered five months later.
The circumstances were remarkably similar, and both cases stunned the nation. As yet, no killer has been brought to justice.
Both cases were connected by police due to their similarities and dubbed 'The Bedsit Murders' by the public, but despite significant advances in forensic science and DNA analysis, the killer has still not been brought to justice.
Police believe the murderer broke into Wendy Knell's bedsit via a back window which was insecure because it could not be locked as the latch was painted over.
But when investigating the 25-year-old's room, officers said there were no clear signs of forced entry and no one had heard anything from the flat.
The worst crimes in Kent's history
Teacher sex assaults in Canterbury
Son woke up to find his mum was killed
Gripping crime documentaries about Kent
Story of man behind Chillenden murders
The previous day Wendy had left her job at SupaSnaps on Camden Road at about 5pm and went home after going to the bank.
Later she went to her boyfriend's house, where she spent the evening with him and his mother watching television.
At about 11pm, he dropped her off at her ground floor bedsit. He kissed her goodbye on the doorstep but never saw her again.
She was wearing black cords, a black leather jacket and carrying a crash helmet.
The investigation also established that Wendy's keys with a distinctive keyring and diary were missing and have never been found.
Some time that night Wendy was sexually assaulted, beaten and strangled. She was left naked on her bed, covered by a duvet. Police believe her attacker got into the flat through the faulty window.
While almost three decades have passed since Wendy's death, Kent Police retains a full DNA profile of the prime suspect and detectives remain committed to identifying her killer and bringing them to justice.
What about Caroline Pierce?
Caroline Pierce was found dead five months after Wendy Knell
The second bedsit murder in Tunbridge Wells of Caroline Pierce on November 24, 1987, remains formally linked by Kent Police and under review by cold case detectives from the Kent and Essex Serious Crime Directorate.
Caroline was last seen at about midnight when she was dropped off by a taxi at her home after a night out with friends.
She was wearing a long black skirt and a red jumper. Caroline was attacked outside her home and was not seen alive again. Several neighbours reported hearing screams.
Caroline's keys, with the Buster Browns restaurant fob where she worked, have never been found
Her naked body was found 40 miles away by a farm worker in a dyke in a remote field near St Mary in the Marsh on Romney Marsh three weeks later.
She had also been sexually assaulted, beaten and strangled.
Kenneth Noye - the M25 killer
Kenneth Noye is one of Britain's most recognisable underworld figures (Image: Kent Police/PA Wire)
Kenneth Noye had been in prison for more than two decades before his release in June.
Following a minor collision on the Swanley slip road of the M25 in 1996, he killed a young man in a fit of road rage.
He stabbed 21-year-old Stephen Cameron, fled the scene and left him for dead at the side of the road.
His fiance, Danielle Cable, 17, had been driving his Bedford Rascal van on a trip to London to buy bagels.
Not used to driving his vehicle, they were involved in a minor collision with Noye's Land Rover.
Stephen Cameron was stabbed to death in Swanley in 1996
But rather than walking away, the killer pulled a knife out, walked back to the young couple and stabbed Stephen, who was unarmed.
His parents Ken and Toni Cameron received a devastating knock on the door but when they arrived at hospital it was too late, Stephen was dead.
Noye immediately fled the country and the police search to find him became an international hunt.
Early police appeals said officers were looking for an Anthony Francis.
But by December 1996, it was revealed this had been a false identity.
Police had traced the dark green L-plate Land Rover Discovery described as belonging to the man who killed Stephen, which had left the scene.
They found it had been unloaded in Kyrenia in Cyprus in July that year and discovered the killer's real name was known gangster Kenneth Noye, who was on licence.
Kent Police outside the home of Kenneth Noye in 1998
His criminal career took many paths, including his part in a huge money laundering of stolen gold bullion taken during the Brink-Mat robbery by six armed men in November 1983.
While he was being investigated for his involvement, Noye fatally stabbed Detective Constable John Fordham, who had been part of the police surveillance of his home.
Incredibly, Noye was acquitted of murder on the grounds of self-defence.
Instead he was jailed in 1986 after being found guilty for handling some of the stolen gold and conspiracy to evade VAT.
Despite his attempts to melt the stolen gold, which were worth £26 million in total, police found 11 gold bars hidden in Noye's home.
He was sentenced to 14 years before being released in 1994.
Kenneth Noye was released from prison on June 6, 2019 (Image: The Daily Mirror)
Noye was still on licence for this crime when he fatally stabbed Stephen on the M25.
Following the attack Noye arranged for the Land Rover he was driving to be scrapped and an identical vehicle placed on the drive of his £400,000 home.
He fled to France using a helicopter and then used a private jet to reach the Spanish capital Madrid.
Noye travelled on to the Canaries and the Ivory Coast before going into hiding under an assumed named near Cadiz on the Costa del crime.
The M25 road rage killer was spotted carrying a bag of shopping (Image: The Daily Mirror)
By 1998 he had a Spanish girlfriend and was posing as "Mickey the Builder".
When police eventually traced him, Miss Cable was taken to a restaurant in Spain where Noye was eating. "That's the man who killed Stephen," she whispered.
The next day Noye was arrested. He was tried at the Old Bailey.
Noye had been serving time at Standford Hill open prison on the Isle of Sheppey but was released from prison in June.
Deal barracks bombing - IRA kill 11 Marine bandsmen
Tributes at the Headquarters of the Royal Marines School of Music, South Barracks (Image: Mirrorpix)
At 8.22am on September 22, 1989, the clock stopped ticking at the Royal Marine Depot in Deal.
11 Royal Marine bandsmen were killed in an explosion which also injured a further 21 marines.
The bandsmen were not combat-trained. Other than being musicians, their role was to occasionally give medical help such as first aid.
A timebomb containing 15lb of explosives tore through the base of the Royal Marines School of Music building, home to the world's most respected military band.
Firemen and Royal Marines search through the rubble of their bomb barracks (Image: Mirrorpix)
It was planted by an IRA team who sneaked in after spying on the base for days.
But the bombers behind the IRA's attack on the barracks remain at large.
Despite one of the most extensive investigations in Kent Police history, there was insufficient evidence to prosecute anyone.
Detectives continue to appeal for new information in the case.
Claire Tiltman and the killer who attended his victim's funeral
Claire Tiltman was just 16 when she was stabbed to death in 1993 (Image: PA Archive/PA Images)
The brutal stabbing of an innocent teenager who was on her way to her see a friend stunned Kent.
It took 21 years to bring Claire Tiltman's killer to justice after officers spoke to more than 1,500 witnesses.
The brazen killer Colin Ash-Smith even phoned police the day after the attack to admit he was at the scene.
Claire was just 16 when she was attacked completely unprovoked on her way to meet a friend near her home in Greenhithe, near Dartford, on January 18, 1993.
The Dartford Grammar School for Girls pupil, who was in Year 11 at the time, cut through an alleyway on her journey, but about 100 steps away from a busy main road, she was attacked.
Colin Ash-Smith turned up at the funeral of Claire Tiltman in the same jacket he was wearing when he murdered her (Image: Kent Police)
Claire was stabbed 40 times in what was described as a "frenzied and remorseless" attack, four days after her 16th birthday.
Several witnesses saw Ash-Smith hurrying away from the alley moments after the stabbing, and gave detailed descriptions of him to the police.
Just over a month later Ash-Smith, from Swanscombe, had the gall to attend his victim's funeral, surrounded by her grieving friends and family.
Unbelievably he showed up to the sad occasion on February 25 wearing the same beige jacket he had on when he stabbed her to death.
Detective Superintendent Owen Taylor led the murder hunt in Greenhithe of victim Claire Tiltman, a 16-year-old schoolgirl stabbed to death in a frenzied and apparently motiveless attack (Image: PA Archive/PA Images)
The former milkman was even interviewed again by police on the same day, having been quizzed by them a month before.
Ash-Smith was interviewed on two other occasions in the weeks after the murder and kept changing his story.
At that time, he was already known as a violent offender but they failed to find enough evidence to charge him with Claire's murder and he continued to deny having anything to do with the killing.
Friends of 16-year-old schoolgirl and murder victim Claire Tiltman, look at flowers that marked the spot at Greenhithe Kent, where she was stabbed (Image: PA Archive/PA Images)
In 2003 the case was reopened after a change in the law meant jurors were allowed to hear about a defendant's bad character during their trial, including any previous convictions.
It was not until a cold case review launched 20 years after the murder that police interviewed Ash-Smith's associates from prison.
He was already serving a prison sentence in Wakefield prison for attacking two other women.
When they spoke to one of his pals Stefen Dubois, real name Molliere, he told the officers that Ash-Smith had described seeing a girl on a zebra crossing, 'snapping' and stabbing her multiple times.
Cliff and Linda Tiltman, parents of 16-year-old murder victim Claire, during the a news conference at Maidstone Police HQ (Image: PA Archive/PA Images)
Dubois thought he was talking about his attack on Charlotte Barnard, but that stabbing did not take place near a pedestrian crossing.
Officers realised that Ash-Smith must have been talking about Claire's murder, which happened yards away from a zebra crossing.
Police finally had enough evidence to charge Ash-Smith with murder in February 2014, 21 years after Claire died.
He was charged on the day he was due to be considered for release by the parole board, having already served 18 years of a life sentence for his two previous attacks on women.
But he was told on that day he would spend a minimum of 21 years behind bars.
Ash-Smith is currently imprisoned at HMP Durham.
Burglars leave teenager needing hospital treatment after brutal attack in Folkestone
Tonbridge man, 24, arrested after teenager raped in Maidstone's Brenchley Gardens
KentLive has crime covered
KentLive brings you in-depth coverage of crime news from across the entire county.
Read about the latest stories from magistrates' and crown court here.
You can also take a look at some of the most tragic cases in Kent which have shocked and gripped us all through history up until today.
Horrifying cases include the mum who drowned her baby twins, the paedophile who repeatedly raped his girlfriend's younger brother and husband who murdered his wife on Christmas Day, as well as dozens of unsolved murders.
Heinous crimes take place in our county and KentLive is there when the offenders are locked up.


text:
Q: What does the word "undermine" mean in this sentence? I came across a YouTube video (The Problem with Cancel Culture)  and this curious sentence right at the beginning.
https://www.youtube.com/watch?v=N3ZjTg1OpIE

"We should not undermine how quickly people can change their ideas."

(The description is We undermine how easy it is for us to become the people that we dislike.)
I have always understood the word undermine to mean to make something or someone become gradually less effective, confident, or successful or to deliberately say or do things that make someone appear less impressive or less important.
However, in this particular case, undermine doesn't seem to fit of these definitions.
Can you clarify what it means?

A: I can't be sure without context, but it is possible that the person meant "undermine" in the sense of sabotage: we should not impede people who are in the process of changing their ideas, work against them, or make their task more difficult.
If so, "undermine how quickly" sounds odd to me.  I might say, "We should not undermine people as they are changing their ideas," or "We should not undermine the task of changing their ideas."

A: The speaker seems to be confused between 'undermine' (which makes no sense in this context) and 'underestimate' (which makes perfect sense).
It's been noticed by people making comments under the video.

A: "Undermine" does make sense here. Let's change the sentence to

"We should not undermine the speed at which people can change their ideas."

which seems a bit clearer IMO.
People collectively change their ideas by communicating with each other. So the sentence is roughly equivalent to "We should not undermine people's channels of communication."
There is a well established word for an effective way to do that which has existed for millennia - namely "censorship".
Of course this chain of deductions might be too hard for to some viewers of the video to construct, but IMO sociologists are well known for speaking in riddles.

A: Your second definition

to deliberately say or do things that make someone appear less impressive or less important

fits the sentence, I would say. It's making "someone", in this case the personification of "[the speed of] how quickly people can change" appear less important, effectively playing down the level of threat posed by it.
So they may know that the threat is high, but they are playing it down by pretending it's not high. It's different from "underestimate" where they really think that the threat is lower than it should be.


text:
Q: Как узнать индекс первого символа второго элемента списка,если я не знаю его значение Hужно узнать индекс элемента списка, но я не знаю заранее что в списке, т.к юзер вводит данные, я знаю что первый символ первого элемента это list[0]. Kак мне узнать первый символ второго элемента не зная его длину?

A: Чтобы разделить входную строку на слова - элементы списка, можно использовать split
words = input("Введите предложение: ").split()
if len(words) > 1:
     d = words[1][0]


Banbury Disco Hire | Mobile Discos | DJ | Disco Equipement Hire Banbury Disco Hire Supplying Professional Discos and Equipment Hire at competitive prices. All occasions and age groups catered for.
"Active Discos, 97 Springfield Avenue, Banbury, OX16 9JF. Discos & Live Music in South East England"


text:
Q: Searching entire computer for specified file Is there a way to search the entire computer and get the full file path of specified file, given a filename to match against?
If you enter for example "file.dat" in textbox it show you full file path if it exist?

A: Look into the Directory class in System.IO.
Whichever solution you use, avoid using GetFiles() instead use EnumerateFiles() since  EnumerateFiles() is recommended for large arrays. (In your case the entire C drive)
As per the MSDN documentation:

Enumerable collections provide better performance than arrays when you work with large collections of directories and files.

A: Try this:
Sub Main()
    Dim filesFound = FindAllFiles("*.exe")
    For Each item In filesFound
        Console.WriteLine(item)
    Next
End Sub

Private Function FindAllFiles(filename As String) As List(Of String)
    Dim retVal As New List(Of String)
    For Each item In IO.DriveInfo.GetDrives()
        FindInDirectory(New IO.DirectoryInfo(item.Name), filename, retVal)
    Next
    Return retVal
End Function

Private Sub FindInDirectory(directory As IO.DirectoryInfo, filename As String, filesFound As List(Of String))
    Try
        For Each item In directory.EnumerateFiles(filename)
            filesFound.Add(item.FullName)
        Next
        For Each item In directory.EnumerateDirectories()
            FindInDirectory(item, filename, filesFound)
        Next

    Catch ex As System.IO.IOException
        'Device not ready, most likely a DVD Drive with no media
    Catch ex As System.UnauthorizedAccessException
        ' Directory is not accessable
    End Try
End Sub

Be aware this is quite slow. You might want to give your user some indication which directory you currently searching (modify the FindInDirectory-Function for this).
Edit: Changed Get-Functions to Enumerate-Functions, as for alstonp suggestion.

A: Try this:
Dim files() As String = System.IO.Directory.GetFiles("C:\", "file.dat")


Umpire Ummar Babary won the TDCA 2018 Umpire of the Year Award at the TDCA Award Presentation night held on January 2019.
Umpire Rohan Shah demonstrated high level of consistency in decision-making and officiating skills to win the Toronto Cricket Umpires and Scorers Association's 2018 Umpire of the Year Award at the TCU&SA Award Presentation night held on November 2018.
Umpire Rohan Shah demonstrated high level of consistency in decision-making and officiating skills to win the Toronto Cricket Umpires and Scorers Association 2018 Umpire of the Year Award at the TCU&SA Award Presentation night held on November 2018.


text:
HD 221287 — звезда в созвездии Тукана на расстоянии около 172 световых лет от нас. Вокруг звезды обращается, как минимум, одна планета.

Характеристики
HD 221287 относится к звёздам главной последовательности. По массе она превосходит Солнце приблизительно на 25 %. Температура поверхности звезды составляет около 6304 кельвинов, что значительно выше солнечной. Возраст HD 221287 оценивается в 1,3 миллиарда лет.

Планетная система
В 2007 году командой астрономов, работающих в рамках программы по поиску планет с помощью спектрографа HARPS, было объявлено об открытии планеты HD 221287 b в системе. Это газовый гигант с массой, равной 3,1 массы Юпитера. Планета обращается на расстоянии около 1,25 а.е. от родительской звезды. Открытие было совершено методом Доплера.

Примечания

Ссылки
 HD 221287 на сайте Планетные системы
 HD 221287 в энциклопедии экстрасолнечных планет

Планетные системы
221287

redpajama_set_name: RedPajamaWikipedia