text:
Compulsory cat microchipping gains international momentum
UK considers requiring owners to register felines; Japan adopts new law
November 4, 2019 (published)
By Ross Kelly
!This story has an important update
Dr. Cat Henstridge 288
Photo courtesy of Dr. Cat Henstridge
Dr. Cat Henstridge believes that requiring cats to be microchipped would not only increase the chances of found cats being reunited with their owners or rehomed but also boost responsible pet ownership.
Veterinarians and animal-welfare charities are embracing a move by the United Kingdom toward mandatory microchipping of pet cats, a sign that the identification system could become as widespread globally for cats as it is for dogs.
Britain's ruling conservative government this fall issued a "call for evidence," inviting submissions from the public to help lawmakers understand the consequences of compulsory cat microchipping. The deadline for comments to Britain's Department for Environment, Food and Rural Affairs is Jan. 4.
"I think it's a fabulous idea," enthused Dr. Cat Henstridge, a veterinarian at Dore and Totley Vets in Sheffield. Henstridge works closely with Britain's Royal Society for the Prevention of Cruelty to Animals (RSPCA) to treat stray and injured cats.
Like most proponents of required cat microchipping, Henstridge said it would increase the chance of lost pets being reunited with their owners or given a new home, thereby improving animal welfare.
She believes that compulsory microchipping would have a further, perhaps even bigger, benefit of compelling more cat owners to establish a relationship with a veterinarian and therefore raise the likelihood of kittens being neutered.
"We've got a massive overpopulation problem with stray cats in the U.K., and microchipping is quite possibly the door to getting them neutered and stopping a lot of those strays being born," Henstridge said in an interview.
The British Veterinary Association does not yet have a formal position on compulsory cat microchipping, although it "strongly encourages" the voluntary practice, president Dr. Daniella Dos Santos told the VIN News Service.
"Microchipping is safe and effective and provides pets with a form of identification that lasts a lifetime, encouraging responsible ownership and enabling reunification of strays with their owners," Dos Santos said in an emailed statement. The BVA's policy team, she added, will be considering its position on compulsory cat microchipping this year.
Alice Potter, a cat welfare expert at the RSPCA, hopes stricter rules will save overstretched groups like hers precious time. "Most charities will keep unchipped cats for at least a week and often longer, and will make significant efforts to find an owner," Potter said. "This uses lots of valuable resources and can mean cats are kept in confinement for longer periods, which is often stressful for them."
About the size of a grain of rice, a microchip is inserted with a syringe under the skin between an animal's shoulder blades, in a process similar to vaccination. Each chip has a unique number that is communicated by a radio signal detectable by a microchip scanner. An animal's microchip number must be registered in order to be linked to its owner.
Compulsory microchipping around the world
At the moment, compulsory microchipping is much more common for dogs than cats.
In the U.K., for example, about 90% of the country's roughly 10 million pet dogs are microchipped, according to the government. The identification system became mandatory for canines there in April 2016. By comparison, an estimated 65% of Britain's roughly 11 million pet cats are chipped.
Microchipping of dogs is required in another 21 of the European Union's 28 member states, including in France, Italy, Spain and Sweden, according to the EU Dog & Cat Alliance, a collective of animal welfare advocacy groups. Outside Europe, microchipping of dogs is compulsory in countries including Israel and New Zealand, and in some Australian states.
On the cat side, compulsory microchipping has been introduced in France, Belgium, Greece and some parts of Spain and Australia. The practice appears to be spreading.
In June, Japan's parliament passed a bill requiring breeders to microchip all dogs and cats. Under the new law, dog and cat owners also will be obliged to notify authorities of changes in ownership, a spokesperson for the Japan Animal Welfare Society told VIN News.
The legislation will be enforced in five years' time; during the interval, procedures for registration and management will be discussed and finalized by the Japan Ministry of Environment, the spokesperson said.
The U.S. remains a holdout for mandatory microchipping, even for dogs. Competing business interests there have created a confusing market structure that would be harder to regulate.
One problem in the U.S. is that different types of chips with differing radio frequencies are used, and they cannot necessarily be read by every scanner. Also, owner data is not always freely accessible across competing registries.
By contrast, most countries in Europe use a uniform 15-digit microchip approved by the International Organization for Standardization, or ISO, that is widely considered to be the world standard. The countries also have single national databases or, as in the U.K., allow open access to different databases that are officially recognized and regulated by the government.
The case for cats versus dogs
The RSPCA's Potter suggested that dogs are more typically the object of mandatory microchipping because they are viewed as potentially more dangerous than cats as strays — dangerous both to humans and other dogs.
Further, the market for pedigreed dogs is much bigger than that for cats, and dogs are seen as particularly gregarious animals more capable of bonding with people. Consequently, she said, dogs may be considered to be more valuable financially and for companionship.
To be sure, dogs are far less likely than cats to roam freely from their owners. According to a recent report by the British animal welfare organization People's Dispensary for Sick Animals, known as PDSA, 71% of cats in the U.K. have access to the outdoors, where they are apt to be unsupervised and potentially run into trouble, whether fighting with other animals or falling under the wheels of a moving car.
In Sheffield, Henstridge said she sees at least one cat every week that has been killed or injured by a vehicle. Intact tomcats, she said, are particularly prone to problems because they often go roaming for mates, get into fights and can end up as roadkill. Local government workers regularly use microchip scanners to try to identify animals found dead on the road but many are found without microchips, Henstridge said.
"If they're not [chipped], you can't exactly put a picture of a mangled cat on Facebook and ask if anyone recognizes this animal," she said. "It's sad when a cat goes missing but to get that final answer of, 'Unfortunately Fluffy is no longer with us' — that's much nicer for the family."
Dr. Jeremy Campbell 288
Photo courtesy of London Cat Clinic
Dr. Jeremy Campbell, clinical director of the London Cat Clinic, says microchipping is a good idea even for house cats because there's always a chance an animal will escape outdoors and go missing.
Dr. Jeremy Campbell, clinical director of the London Cat Clinic, located in the heart of Britain's capital, also is a big fan of compulsory microchipping, even for an urban practice like his, where more than 95% of patients are house-bound.
"Some indoor cats still go for walks, some go to parks or the country, and an increasing number, thankfully, are going to the vet," he said. "The trip by car, taxi, bus or train is a potential exit opportunity for that determined feline with escape on their mind, especially if a carrier isn't up to the job — which isn't infrequent."
For outdoor cats, Campbell said, the case for compulsory microchipping is "obvious," whether it's bringing home animals that have gone walkabout, or finding the owners of feline accident victims. "The ability to more quickly inform these owners of their cat's whereabouts is huge," he said.
Henstridge noted that of the last 20 stray cats brought into her practice (some injured), just two were microchipped — indicating that government estimates of a 65% chip rate might not tell the complete story.
The discrepancy, she said, could be related to the fact that a lot of cats brought to charities or veterinarians were born as strays or neglected by owners. She recalls, for example, an incident a few weeks ago when the RSPCA pulled 40 kittens out of a single dilapidated home.
"There's a huge subpopulation of cats that won't show up in any survey until they end up being knocked down and injured," she said. "They are never microchipped and often have kept having kittens."
Pitfalls and possible solutions
One of the biggest challenges associated with microchipping is ensuring that owners regularly update their personal details on microchip registries. Unlike pet identification tags, the chips themselves do not contain owner information. Instead, they contain a number that is linked to a person's contact information housed in a registry.
In the U.K., dog owners found to have not microchipped their pets or updated their contact information face a fine of up to £500 (US$643) and risk of criminal prosecution.
While the threat of sanctions has not made the system foolproof, it appears to be largely effective. In the PDSA report, which is released annually and this year provides results of a survey of 5,036 pet owners, 92% of dog owners claimed their dog had been microchipped, and 86% said their contact details were up-to-date on a database.
Five percent stated that they had failed to update changes to their personal information. A further 6% indicated that they believed that their veterinary practice would have updated their details for them, while 3% were not sure if their details on the database were up-to-date.
Henstridge can attest to the success of Britain's canine microchip requirement: She can't remember the last time she has seen a puppy without a microchip. "Even the really bad breeders are doing it now," she said.
As for British cat owners who have voluntarily microchipped their pet, the PDSA reported that about 8% said they had not updated their registry information — something Potter at the RSPCA considers a big problem.
"We strongly propose that, as with dogs, new legislation on compulsory microchipping for cats must include a requirement for contact details to be kept up-to-date," she said.
Dealing with questions of ownership
The RSPCA also would like to see measures introduced that protect charities when chip registration information is outdated so that they can assume ownership of the cats quickly and rehome them, Potter said.
Determining who takes on ultimate responsibility for a found cat or dog often is tricky, even if the animal has been microchipped and the original owner's details are accurate. That's partly because there is no strict concept of what's known as "lawful attachment" in the U.K., which would force a previous owner to take responsibility for a cat or a dog.
However, the presence of a registered microchip can help build a case for animal abandonment or mistreatment because it can prove who was responsible for the animal at one time, according to Dominic Sullivan, director of legal services at the charity Cats Protection.
"It would be a matter of evidence in each case as to whether or not a cat had been abandoned," Sullivan said. "If the evidence shows that a cat had been abandoned, the owner could say, 'That's not my cat anymore.' But they may, nevertheless, have committed an offense by failing to ensure that its welfare needs are met and [they] could not, subsequently, claim ownership or demand the return of the cat."
Britain's Abandonment of Animals Act prohibits abandoning an animal "in circumstances that may cause it any unnecessary suffering."
As for finders of microchipped pets, Sullivan said, generally they do not acquire ownership rights. "They have a legal duty under common law to look after the cat or dog and to take reasonable steps to locate the owner and return it on demand," he said.
That legal duty varies by jurisdiction. For example, in Scotland, the law is slightly different such that finders may, subject to various conditions, acquire ownership. In fact, Sullivan said, "A finder may have a better claim to ownership than someone who has abandoned a cat."
The RSPCA's Potter said that in many cases, people whose name is linked with microchipped cats do claim the pet is no longer theirs, and they therefore have nothing to do with the animal. "We would like to see microchipping being tied more closely to ownership and the responsibilities that conveys," she said.
Although microchipping isn't fail-safe, Henstridge nevertheless believes that requiring it for cats is a good idea. "People won't always update data and sometimes people won't want their cat back," she said. "But the bottom line is that we still get more cats back to their families, while encouraging owners to be more responsible for their pets."
This story has been changed from the original to correct the U.S. dollar value of the British fine for failure to microchip dogs and keep chip-registry information up-to-date.
Update: On Dec. 4, 2021, the U.K. government announced that cat microchipping will become mandatory for cats age 20 weeks and older. Owners found to have not microchipped their cat will have 21 days to comply or face a fine of up to £500 (US$664). The government said the rule will be implemented once a review of the regulations on dog microchipping is completed, without giving a specific date. That review will consider whether improvements can be made to microchipping database systems.
Britain: 94 percent of dogs now microchipped - February 8, 2017
New entrants to pet microchip market draw critics - July 29, 2015
Entrepreneur finds pet microchip problem unsolvable - July 16, 2015
Facial-recognition apps scout lost pets - April 15, 2015
Comprehensive pet microchip registry data elusive - September 8, 2014
When microchips muddle pet ownership status - December 13, 2012
New microchip search tool debuts - September 22, 2009
New company aspires to clean up pet microchip mess - August 26, 2009
Internet tool aims to simplify search for pet microchip registry information - August 19, 2009
Microchips dump legal, ethical baggage on veterinarians - January 7, 2009


Beyond the index type, you must also identify the syntax type. The syntax describes what sort of data the index will contain, and it is mostly used to determine how indexed values are compared. There are a large number of syntax types available to you, such as substring, boolean, or date.
See Specifying Index Strategies for a complete list of syntax types available to you.


text:
About Terri L. Quinton
New Author
I am the CEO and President of Q2 Marketing Group LLC, an award-winning, full-service marketing firm primarily focused on the business development and growth of small and mid-sized companies. We work to assist with messaging and in connecting to prime target markets in the most economical and efficient method. A serial entrepreneur, I am also co-founder and Managing Principal of the Alliance of Diversity Printers LLC (ADP-LLC), a printing, warehousing and fulfillment firm with a national footprint that is strategically aligned with printers around the country.
I began my career in management positions at Southwestern Bell Telephone. I had a fast-track career which included stints in the data center, on the 12-person comptroller's staff, product management, new products/services development and marketing and sales. I left SWBT as the highest ranking African-American manager out of 70,000 employees to pursue a partnership in an entrepreneurial telecommunications company.
Throughout my career, I have always been an avid writer and reader. I believe my ability to readily understand complex concepts, convert them into everyday English and present them to a target audience as a significant reason for my success in corporate America and as an entrepreneur.
"I love to write. It is what completes me. Several years ago, I started a book to honor my mother. She was a strong influence on who I am. I started writing and interviewing my friends but had a hard time figuring out why anyone else might want to read something I wrote.
The original title for this book was Mothers and the Lessons They Taught Us. But with so many books about mothers, I couldn't quite get a grip on the direction to take. I just wasn't sure what these women and their mothers were trying to tell me. Finally, I realized people are always looking for principles that have helped us live our lives. And these women had such amazing stories of strength, courage and hope to tell. Plus, my friend Margo J. Posey, commanded me to just go do it! It was the push I needed to move forward.
I consider myself more than an entrepreneur and writer. I am committed to efforts to help women of color and young entrepreneurs grow their businesses and willingly lend my talents and time to organizations empowering minority and women entrepreneurs.
"I would like our school systems and organizations associated with young people to encourage them to create jobs, not just get one. Innovation often comes from striking out on your own and not being afraid to fail. Perhaps the most exciting thing to me right now is that a niece and nephew who have been around me, are working on building their own businesses. I am delighted that the entrepreneurial spirit is rubbing off!
I serve as a member of the board of directors for the National Minority Supplier Development Council (NMSDC). I was the first female elected to chair the NMSDC Minority Business Enterprises Input Committee (MBEIC), representing over 17,000 minority owned businesses and 1,000,000 employees nationwide. I served in this volunteer position for six years and represented minority-owned businesses as the sole voice on the senior-level Executive Committee and Board of Directors of NMSDC. I am also part of the executive committee and board of directors of the Dallas/Fort Worth Minority Supplier Diversity Council and a board member of the Women's Business Council – Southwest. I enjoy volunteering with WINGS (Dallas-based YWCA) to assist young women entrepreneurs in the area of marketing their businesses. In addition, I stay active in several initiatives dedicated to encouraging more women and minorities to enter fields related to science, technology, engineering and mathematics (STEM).
I have been honored to be recognized with numerous awards for my work and commitment to diversity and inclusion. I was inducted into the Women's Business Enterprise Hall of Fame in 2016 based upon my business achievements and dedication to furthering the growth and development of women entrepreneurs.
I hold a Bachelor of Science degree in computer science from Kansas State University and an MBA from Southern Illinois University-Edwardsville. I have also had the pleasure of graduating from the executive business management programs at Kellogg School of Business at Northwestern University and Tuck School of Business at Dartmouth. I currently chair the alumni group of the NMSDC Kellogg Advance Management Executive Program.
I am an avid sports fan (especially football), mystery and historical fiction reader, red wine lover and traveler (especially beach fronts).
I was born and raised in Topeka, Kansas but now make my home in Dallas, Texas. I am blessed to be surrounded by a mosaic of friends, business associates, a niece and grand nieces and nephews in Dallas and brothers and their families in Kansas, Kentucky, Texas and Florida.
People are always looking for principles that have helped us live our lives. And these women had such amazing stories of strength, courage and hope to tell.
Meet Terri
THE ASHTON DEPOT
1501 Jones St
Fort Worth , TX 76102
Prime Women Pop Up • Fort Worth, TX
Terri will be appearing and autographing books at the Prime Women Fort Worth Living Well event at the historic Ashton Depot in Fort Worth. Mayor Betsy Price, Fort Worth native, will welcome about 200 PRiME Women to the city. Mayor Price embodies "living well", and after winning her fifth reelection, is serving in her prime as the longest seated Mayor of Fort Worth.
Watch for Registration Open Soon
Coming in November 2018
Book Reading & Signing • Houston, TX
Stay tuned for date and location. Terri is headed to Houston, TX to conduct a Book Reading and Signing.
Coming in December 2018
Book Reading & Signing • Topeka, KS
Just in time for Holiday shopping, Terri returns to her hometown to participate in a relaxing and fun Book Reading and Signing. Watch for date and details.
Schedule Terri to Speak
Schedule an Event
info@givemegrits.com
Order Your Book Today!
Buy Book Here
terri@givemegrits.com
Join the G.R.I.T.S. Daughters Blog.
While finishing of this book, I found myself listening to women tell me stories about their mothers -- in the airport, at a happy hour, at church, in a classroom, over the phone... There are thousands of stories about how mothers have influenced women to be successful. While these stories came too late to included in my book, we have stared a blog to share the stories. Join and post your story.

redpajama_set_name: RedPajamaCommonCrawl


text:
Our Resources Gro's CEO, Sara Menker, Joins the U.S. Agency for International Development's Advisory Committee
Gro's CEO, Sara Menker, Joins the U.S. Agency for International Development's Advisory Committee
BlogClimatePress & InterviewsReleases and UpdatesFood Security
Gro's CEO, Sara Menker, has joined the U.S. Agency for International Development's re-established external advisory committee, the Advisory Committee on Voluntary Foreign Aid.
As a ACVFA member, Ms. Menker will work alongside USAID officials and private and public sector representatives to strengthen the response "to development challenges overseas including climate change, the global food crisis, autocratization and corruption."
The ACVFA's membership represents a range of diverse leaders, brought together in their commitment to support the USAID's efforts towards international development and humanitarian assistance.
The Committee was appointed by the 19th Administrator of the USAID, Samantha Power, and will be chaired by Nisha Biswal, Senior Vice President for International Strategy and Global Initiatives at the U.S. Chamber of Commerce.
Tackling Climate Change and Food Security
Climate change and food security remain two of our world's biggest threats. As governments, humanitarian organizations, and businesses across the agricultural supply chain try to adapt to these current realities, they need timely and transparent data from trusted sources.
Gro is committed to providing this data to help organizations see around the corner, enabling better, faster, and more informed decisions and coordinated emergency responses.
At her briefing of the United Nations Security Council on May 19, 2022, Ms. Menker said that "there is no version of the world where every country has all the natural resources it needs to survive and thrive. One key takeaway from our data is how often we see repeated examples of cause and effect, highlighting surprising connections and interdependencies."
About the U.S. Agency for International Development
Following World War II, the ACVFA was established to serve as a bridge between the private sector and the U.S. Government to strengthen communication and solidarity in the provision of foreign aid.
On a global scale, it provides humanitarian response and disaster relief by bringing together experts from the private sector, universities, international nongovernmental organizations, and USAID officials.
The leading experts joining Ms. Menker as newly appointed Committee members are:
Adriana Beltrán, Executive Director, Seattle International Foundation
Asma Lateef, Policy and Advocacy Lead for Agriculture, SDG2 Advocacy Hub
C.D. Glin, Global Head of Philanthropy, PepsiCo Inc. and Vice President, PepsiCo Foundation
Dan Twining, President, International Republican Institute
Derek Mitchell, President, National Democratic Institute
Eileen Donahoe, Executive Director, Global Digital Policy Incubator, Stanford University
Eka Tkeshelashvili, Director, Support to Anti-Corruption Champion Institutions (SACCI), MSI a Tetra Tech Company
Enock Chikava, Interim Director, Agricultural Development, Bill & Melinda Gates Foundation
Hibak Kalfan, Executive Director, NEAR Network
Levon Esters, Professor and Associate Dean for Diversity, Equity & Inclusion and Faculty Affairs, Purdue Polytechnic Institute
Hindou Oumarou Ibrahim, President, Association for Indigenous Women and Peoples of Chad (AFPAT)
Jeremy Weinstein, Professor of Political Science, Fisher Family Director of Stanford Global Studies, Stanford University
Johan Swinnen, Global Director of Systems Transformation at CGIAR, and Director General of the International Food Policy Research Institute (IFPRI)
Julie Dorf, Co-Chair, Council for Global Equality
Katherine Marshall, Professor of the Practice of Development, Conflict, and Religion in the Walsh School of Foreign Service, Georgetown University
Kennedy Odede, CEO, Shining Hope for Communities
Kristin Lord, President and CEO, IREX
Liz Schrayer, President and CEO, US Global Leadership Coalition
Manuel Pulgar-Vidal, Global Leader of Climate and Energy, World Wildlife Fund
Nadia Murad, Founder and Chairwoman, Nadia's Initiative
Nisha Biswal, Senior Vice President, International Strategy and Global Initiatives, U.S. Chamber of Commerce
Olga Wall, CEO, Avallon Consulting LLC
Paul Weisenfield, Executive Vice President for International Development, RTI International
Rachel Kyte, Dean, Fletcher School at Tufts University
Saad Mohseni, Chairman and CEO, MOBY Group
Sanjay Pradhan, CEO, Open Government Partnerships
Teresa Barger, Co-Founder and CEO, Cartica
Reach out to us at intel@gro-intelligence.com to speak to a member of our team.
From Davos: Gro's CEO Discusses Food Security and the Food System Transition


text:
class InvitationPresenter < SimpleDelegator

  def initialize(presentable, view_context)
    @presentable = presentable
    @view_context = view_context

    super @presentable
  end

  def message
    super.presence || self.message = default_message
  end

  private

  def default_message
    h.t 'presenters.invitation_presenter.message', locale: 'de'
  end

  def h
    @view_context
  end
end

redpajama_set_name: RedPajamaGithub


Hope you are still around. How do you bake bobotie and yellow rice in a rammiken? Does the rice have to be cooked, partially cooked or raw? Will this work?
How do I do individual "mounds" of rice and decorate it attractively on a plate. Can I use ramekins? Do I spray them first with spray and cook? I am afraid that when I invert the ramekins it will be like building sandcastles and the mounds will come tumbling down! Any suggestions I would like to serve yellow rice with the bobotie. By the way the Sage chicken was out of this world did it last night for dinner.
Thanks G. Do I then fill the ramekins and place them in the fridge to "set" and when ready to serve do as above?
You can remove from the moulds straight away, no need to cool. When it has loosened from the mould, remove the mould slowly. Cheers for now.
Thanks for the tip on the Spekko Rice. They were handling out samples at the Good Food and Wine Show and it is good. I just add my own lentils or whatever and it does have a good nutty taste. How the potjie recipes going?
I have added fried fish fingers, boiled egg and tomotoe, and it's yummy!


Jonathan Cohen must have been coming off a high after being a runner-up in last year's CFDA/Vogue Fashion Fund competition. For fall, he staged his first ever runway show, sending out one celebratory look after the next, all boasting the sort of eclectic pattern play and color story that have gained him recognition. Maybe it was seeing the clothes in motion for the first time, or the fact that his theme was a personal one full of nostalgic emotion, that filled the collection with life. In any case, it's clear that Cohen has hit his stride.
Throughout the fashion fund, Cohen had to think hard about his design sensibility and where his love of prints and color comes from, always returning to his childhood visiting family and markets in Mexico City. He brought back a mix of carpets and rugs from a recent trip there with a goal to reimagine the patterns into something new. He did that and more with his signature touch of quirky and sophisticated subversion.
He rendered various patterns into a stellar scarf-tie patchwork dress with great movement, utilizing the tie concept throughout with more subtlety, both as decorative embellishments or to hold together the seams of a simple yet standout yellow gown. A patchwork print was cut into a dress for a similar illusion, topped off by newly introduced vegan leather.
Artisanal elements elevated the range and included petals pieced together on a striped baby-doll dress and strips of 22 colors of Swarovski crystals applied by hand onto evening dresses playful and formal. There was personality in his ubiquitous slash skirt cut into varying iterations, including a flouncy mini version and a prim cotton day dress with floral embroidery.


text:
Q: Merge rows in table My table consists of availability status data for each day of the month where a row represents a given month and each column is a day.  I stores statuses like 'Available', 'Unavailable', etc.
This works great until I want to display data by week.  The issue I run into is when I get to a week that crosses into the next month.  Right now I'm using a query that looks like:
$query = "SELECT pilots.id AS pid, "
       . "pilots.last_name AS last_name, "
       . "pilots.first_name AS first_name, "
       . "rt.* FROM pilots "
       . "LEFT JOIN ("
       . "SELECT * FROM availability "
       . "WHERE date ='"
       . $first_date_of_month->format("Y-m-d")
       . $next_month_str . "')rt "
       . "ON pilots.id = rt.pilot_id "
       . "ORDER BY pilots.last_name, pilots.first_name, pid";

Which looks like:
SELECT p.id pid
     , p.last_name
     , p.first_name
     , rt.*
  FROM pilots p
  LEFT
  JOIN
     ( SELECT *
         FROM availability
        WHERE date ='2017-06-01'
         OR date = '2017-07-01'
     )rt
    ON p.id = rt.pilot_id
 ORDER
    BY p.last_name
     , p.first_name
     , pid

The problem with this is let's say I have 1 user and 2 months of data.  It returns 2 rows.  I really only want 1 row where the data is merged using columns from the end of one month and beginning of another month.
For example:
//Pilots
-------------------------
| id|first_name|last_name|
-------------------------
| 1 | "myTest" |"myTest" |
-------------------------

// Months
----------------------------------------------------------------------
| id|pilot_id|  date  |   1_status  |   2_status  |....|  30_status  |
|--------------------------------------------------------------------|
| 1 |   1    |3/1/2017| "Available" |"Unavailable"|....| "Available" |
|--------------------------------------------------------------------|
| 2 |   1    |4/1/2017|"Unavailable"|"Unavailable"|....|"Unavailable"|
----------------------------------------------------------------------

In the first example (not within 7 days of the end of the month), it's simple: I will have 1 record because I know I do not need the next month.  Let's say it's "3/21/2017"; I just output the statuses for "3/21/2017", "3/22/2017", and so on.
However, let's say the week I want to display starts at "3/28/2017".  I need the data from March and for April.  In this case, it generates 2 rows of data for pilot_id 1.  But I really only need 28_status, 29_status, 30_status, 31_status, and THEN need 1_status, 2_status (all from April).
Attached $next_month_str below:
            $next_month_str = "";
            if (!is_last_day_of_month($sunday_date))
            {
                $next_month = get_next_month($monday_date);
                $next_month_str = "' OR date = '";
                $next_month_str = $next_month_str . $next_month->format("Y-m-d");
                $next_month_str = $next_month_str;
            }

$query_inner = "SELECT pilot_id, 26_status, 27_status, 28_status, 29_status, 30_status FROM availability WHERE date = '2017-06-01'";
$query = "SELECT availability.pilot_id AS pid, rt.26_status, rt.27_status, rt.28_status, rt.29_status, rt.30_status, availability.1_status, availability.2_status FROM availability INNER JOIN (" . $query_inner . ")rt ON rt.pilot_id = pid WHERE date = '2017-07-01'";

There are two queries I came up with.  Separate they work fine, and they work fine when I test them out using a SQL checker and they do exactly what I want.  However, when I run it in my site, they give me a error querying the database.

A: Based on your question, you need to use GROUP BY, HAVING and possibly GROUP_CONCAT() to essentially "flatten" your results set. Here are some resources so you may learn how and then apply that knowledge.

*

*GROUP_CONCAT()

*GROUP BY, HAVING
The above resources have a sandbox for you try play around with the SQL statements.

A: Solved it.
I can build the query string programatically, but using JOINs I was able to solve it.  Does exactly what I want it to.  Here is an example of a string:
SELECT availability.pilot_id, rt.26_status, rt.27_status, rt.28_status, rt.29_status, rt.30_status, availability.1_status, availability.2_status FROM availability INNER JOIN (SELECT pilot_id, 26_status, 27_status, 28_status, 29_status, 30_status FROM availability WHERE date = '2017-06-01')rt ON rt.pilot_id = availability.pilot_id WHERE date = '2017-07-01'

EDIT:  Although I was able to solve the question using this, ultimately it was a design issue that forced this.  I decided to refactor and use a table like availability {id, pilot_id, date, status}.

redpajama_set_name: RedPajamaStackExchange


text:
package org.apache.deltaspike.test.testcontrol.uc003;

import org.apache.deltaspike.test.category.SeCategory;
import org.apache.deltaspike.testcontrol.api.junit.CdiTestSuiteRunner;
import org.junit.AfterClass;
import org.junit.BeforeClass;
import org.junit.experimental.categories.Category;
import org.junit.runner.RunWith;
import org.junit.runners.Suite;
import org.apache.deltaspike.test.testcontrol.shared.ApplicationScopedBean;

//Usually NOT needed! Currently only needed due to our arquillian-setup
@Category(SeCategory.class)

@RunWith(CdiTestSuiteRunner.class) //starts container once (for the whole suite)
@Suite.SuiteClasses({
        RequestAndSessionScopePerTestMethodTest.class,
        SessionScopePerTestClassTest.class
})
public class TestSuite
{
    @BeforeClass
    public static void resetSharedState()
    {
        ApplicationScopedBean.resetInstanceCount();
    }

    @AfterClass
    public static void finalCheckAndCleanup()
    {
        if (ApplicationScopedBean.getInstanceCount() != 1)
        {
            throw new IllegalStateException("unexpected count");
        }
        ApplicationScopedBean.resetInstanceCount();
    }
}


text:
> News > In the News > Flight attendants face significant amount of sexual harassment on the job
Search the press releases archive
2021 Multimedia
Faculty Stories
Faculty News, Notes, and Accolades
Student News, Notes, and Accolades
Explore Research by Topic
Flight attendants face significant amount of sexual harassment on the job
Sexual harassment appears to be a significant and underreported problem among both female and male flight attendants, according to a new study from Harvard T.H. Chan School of Public Health.
The study, which was published August 17, 2020 in the International Journal of Aerospace Psychology, looked at data from 8,700 flight attendants from North America (U.S. and Canada) and 1,887 from the United Kingdom who took part in the Flight Attendant Health Study. The participants were asked about their experience with sexual harassment and behaviors over the previous 12 months.
The researchers found that 26% of North American attendants and 11% of U.K. flight attendants reported being sexually harassed on the job by passengers, pilots, and coworkers. They also found that 61% of U.K. flight attendants experienced unwanted sexual behaviors while working, but didn't necessarily perceive those behaviors as sexual harassment—which implies that sexual harassment may be underreported.
The researchers recommended that airlines establish policies and training to address sexual harassment and encourage flight attendants to report unwanted sexual attention.
Co-authors were all members of the Sustainability and Health Initiative for NetPositive Enterprise (SHINE) team. They included research scientist Dorota Weziak-Białowolska, research associate Piotr Białowolski, research associate Irina Mordukhovich, and Eileen McNeely, founder and executive director of SHINE.
Read the study: Work, Gender, and Sexual Harassment on the Frontlines of Commercial Travel: A Cross-Sectional Study of Flight Crew Well-Being
Read a SHINE blog about the study: New Paper on Work, Gender, and Sexual Harassment in Commercial Air Travel
Share this:FacebookTwitterLinkedInReddit
The COVID-19 Update
Our researchers are on the front lines of the global response to the COVID-19 pandemic. Sign up here to receive our weekly newsletter highlighting their efforts.
A primer on the 'encyclopedia of carcinogens'
Bolstering workers' well-being amid pandemic disruptions
What the U.S. did wrong with COVID-19
Explore HSPH research by topic
Harvard Chan School News on Twitter
A new study led by Harvard Chan School's Jun Li says diets that promote higher levels of inflammation are associate… https://t.co/aF6x1Jwyuw
Harvard Chan School's @vishplus says Small Business Administration loans to anti-vaccine advocacy organizations are… https://t.co/zkNHCmkRFN
On 1/27 @HarvardChanDean Michelle Williams and @NAMICommunicate present Mental Health in the Time of COVID-19, co-h… https://t.co/cpj48HwgHI
Today, the @Harvard community reflects on the life and legacy of Dr. Martin Luther King. https://t.co/MTJCjI6viv https://t.co/XfhW5w8TC9
This Friday, join @ForumHSPH for a discussion about the COVID-19 vaccine rollout, which will cover concerns regardi… https://t.co/DIEC6cH56k
Harvard Chan's @mlipsitch and Meira Levinson of @hgse look at the consequences of a "lost year" of education during… https://t.co/L1pSnHu6fF


This entry was posted on Friday, February 4th, 2011 at 7:11 pm	and tagged with essenes, good samaritan, gospels, herodians, historical jesus, jewish temple, josephus, Judaism, masada, n.t. wright, pharisees, philo, qumran, religious right, religious world of jesus, sadducees, samaritans, second-temple judaism, sicarii, the jewish religious world of jesus, zealots and posted in Christianity, Christology, Church, Historical Jesus, Religion & Spirituality, Theology.	You can follow any responses to this entry through the RSS 2.0 feed.
Were the Sadducees theologically liberal? They denied the resurrection. Most of the "religious right" today are theologically conservative.
Hey Kurt, that's a great question!
The Sadducees would have been considered theologically conservative in their own day.
You have to remember that those ideas which were extensively developed during the intertestamental period 586 BC-4 BC (e.g. resurrection, eternal life & punishment; death, angels, demons, etc.), would have been considered progressive theology and beyond the time-honored traditions of Moses. The Sadducees would have seen this as "liberal," maybe even heretical.
The Sadducees would have seen all of this as a "liberal" movement in their own world. However, the Pharisees were open to progressive revelation as time had passed under several empires and they had reflected upon the Scriptures.
I suppose that the synagogue life (communal biblical interpretation), which grew up during the exile, and where Pharisees spent much of their time, aided these ideas during that period, as well as outside influences that God may have used to broaden their understanding and perspective of previous interpretations.
As I said in the article, the Pharisees, I believe have been in many ways misunderstood and misrepresented.
I think that when we try to make application to our own situation today, the Religious Right and most "conservatives" are carrying on mostly like Sadducees with a pinch of the Pharisaical spirit displayed in their close-mindedness and arrogant attitudes.
I grew up among the Religious Right and conservative evangelicalism. I guess it was fitting that they often spoke terribly about Pharisees, never believing they were one of them. They may have been right. In truth, they act like their opponents, the Sadducees.
Excellent survey brother! Love your concluding thoughts about Jesus' non-affiliation with any religious or political group! May we do likewise as we live by His life in the body of Christ!
As always, thanks for reading, John!
Great article, David. Very informative.
I would disagree with you that the Sadducees are the "religious right" and Pharisees as "liberals". The religious right have a strict adherence to many "new" things such as KJV, being politically conservative, anti-abortion, gun rights. That is what the Pharisees did. They had a strict adherence to more laws that guarded them from coming close to the most important law – the torah.
The Sadducees were the "liberals" of the day. Liberals deny any laws they find uncomfortable. Theological liberals today cut out any doctrines that they disagree with and so they become the ultimate authority. Angels were evident in the Torah, but they still denied them. The resurrection was evident in the Torah, but they still denied it. That is the mark of a liberal.
The religious right – the Pharisees disregard God and his laws because they add their own laws.
The religious liberal – the Sadducees disregard God and his laws because they are their own lawmakers.
Thanks, Jeff. I disagree. The parallels are not the quite the same. See my comment above. Thanks for reading.
I thought this was a very good and concise summary of the different sects in Jesus' day. I must say I always thought of the Sadducees as the liberals since they did not accept major portions of Scripture and the Pharisees as conservatives since they accepted all of the Old Testament as canonical and at least claimed to strictly observe it. But then I am not so sure that our idea of liberal and conservative are good parallels. For in our own understanding of conservative/liberal they would both be liberals because both sects as a whole rejected Jesus Christ as Savior and Lord.
Would Jesus be part of a denomination? I am sure that Jesus would NOT be part of a denomination. Jesus' physical and earthly presence is the end of all "valid" denominations. Things become simple: whoever agrees with Jesus is sound and whoever disagrees becomes a heretic. Today we have the Holy Spirit. I could say more on this. But for now I will simply say the Holy Spirit brings unity. Obviously there will be disagreement in certain areas. Even so, authentic believers will unify and rally around Jesus Christ and His gospel for He is supreme and central. Enjoyed the post.
Thanks, Jared. Yeah, as I wrote in a previous comment, I don't think the parallels are quite the same. Thinking that the Sadducees were "liberal" is a bit anachronistic.
However, if we consider these two groups theologically, and their view of the Torah, then the attitudes of the Sadducees were more like many conservatives today–in the way modern day conservatives argue for inerrancy, are often opposed to progressive revelation from the Old to New Testament (i.e. prefer Moses over Jesus), support imperial violence to secure their status, and are unwilling to budge on their traditional interpretations that threaten their theological paradigms.
As it pertains to Scripture, the Pharisees were definitely "progressive" in their views of the canon and biblical revelation. Again, I think that's why we have a few Pharisees that are able to accept Jesus–they are not near as closed off to new revelation as the Sadducees. I think if we look a bit closer and are mindful of the first-century, we will see that Jesus agreed with many ideas that the Pharisees embraced (e.g. love of the Law, resurrection of the dead, demonology, biblical canon, etc.).
As the Gospels record, we only have one real run-in with Sadducees and a Samaritan woman, and none with Zealots or Essenes. I think that's sayin' something. It says, the religious group that Jesus resonated with the most, he chided in private and rebuked in public.
Jesus actually agrees more with the Pharisees than the Sadducees. Sure, he disagreed with many of their interpretations, and of course their extra-biblical traditions, but he did affirm the biblical developments of the last couple hundred years. That would not be a "conservative" idea in the first-century Jewish religious world.
So, I think if we want to use the terms "liberal" and "conservative" (or even "progressive") then we must let the first-century context define those terms.
I had a question about your view of revelation. It seems from what you said you do not believe in inerracancy. What is your view of the Bible? What do you mean by the following statement especially the part about the progressive revelation?
–in the way modern day conservatives argue for inerrancy, are often opposed to progressive revelation from the Old to New Testament (i.e. prefer Moses over Jesus), support imperial violence to secure their status, and are unwilling to budge on their traditional interpretations that threaten their theological paradigms.
Hey Jeff, that's a valid question.
I think the "inerrancy" debate is actually a ridiculous distraction. I do not mean this disrespectfully, but holding to "inerrancy" (i.e. no errors in the original manuscripts) is a moot issue and irrelevant when coming to the Bible as human literature brought about over time by the inspiration of God.
1. We have none of the original manuscripts, so claiming that all the i's were dotted and all the t's were crossed in the original manuscripts doesn't raise the level of inspiration or do anything for the case of biblical authority. The idea that the existence of grammatical errors (or copyist mistakes) demeans the inspiration and authority of Scripture should be discarded. The "inerrancy" argument is actually more reflective of an Islamic view of the Quran–an angel gave Muhammed the exact words of God on golden tablets. The unique significance of biblical inspiration and authority is found in God using fallible men to pen His message (WORD)–which is infallible.
2. I am a student of languages, and I am particularly a student of Greek and textual criticism. It is undeniable that there are currently grammatical errors and copyist mistakes in the transmission of the New Testament. I know that to many conservatives and their hyper-sensibilities, it would be rather alarming for them to know how many things are uncertain about the original documents. If they really knew what has transpired over time and the great task before translators, they would cease to argue for "inerrancy" and instead rightfully argue for the "infallibility" of the Scriptures alone, admiring the careful treatment of the biblical text by scholars through the centuries.
Regardless of human error in the transmission of the Scripture, there is a unity of the message and a harmony that is a clear mark of divine inspiration. We can trust what the Scripture tells us about Christ. "Inerrancy" is not needed, and holding to it, I believe, only shows us as ignorant, arrogant, and close-minded.
I recommend reading "Scripture & the Authority of God: How to Read the Bible Today" (2011) by N.T. Wright & "The Human Faces of God: What Scripture Reveals When It Gets God Wrong (and Why Inerrancy Tries to Hide It)" (2010) by Thom Stark. Wright's book was just released. It is a revised and expanded version of his "Last Word" (2006).
As "revelation" is concerned, I believe Christ is the final revelation of God. Any revelations given to human beings today is a spiritual revelation of Christ and the Kingdom we have come to know in the Gospels of the New Testament. I believe the canon of Scripture to be closed, but I do not deny that folks are able to have further "revelations" of Jesus of Nazareth in order to comprehend the Christ of the NT.
So, I would assume you believe this as well. I don't know of anyone personally who believes what you portrayed in your response. Plus, you put me in the awkward position of arguing for my own humility, open-mindedness, and understanding ☺. I'm not going to do that.
Now, you said conservatives and inerrantists are opposed to progressive revelation, often taking Moses over Jesus and are not willing to budge on traditional interpretations which threaten their paradigm. This is a broad brush stroke. Many are merely concerned with what you are concerned with, understanding the meaning of the text. Furthermore, this could be said of any system of thought.
Not knowing anyone personally that believes what I have stated may just have something to do with the crowd you're around.
So how then do you define "infallible" as it pertains to Scripture? Do you think these two words are synonymous? I would say what you have listed above is descriptive of "infallible." My experience is that most fundamentals/conservatives in the pew (and many in the pulpit) think they are synonymous terms. Therefore, when someone questions "inerrancy" (concerning transmission of the NT & the original manuscripts), that person is tagged a liberal headed for hell. I have seen and I am seeing it used in different ways.
Mainline inerrantists hold to the definition I gave you. Stanley Grenz and Millard Erickson would both affirm the definition I posted (Grenz, Pocket Dictionary; Erickson, Concise Theological Dictionary). I don't have them available right now or I would quote them.
By the way, I am the most humble man to ever walk the face of the earth. Wow. Try writing that about yourself some time. It feels like you are about to be struck by ligh…….
Well, you apparently know one person that believes it. So then, what is "infallibility" and how is it different?
"The characteristic of being incapable of failing to accomplish a predetermined purpose. In Protestant theology infallibility is usually associated with Scripture. The Bible will not fail in its ultimate purpose of revealing God and the way of salvation to humans" (Grenz, Pocket Dictionary, 66).
"the Bible is unfailing in its purpose" (Erickson, Concise Dictionary, 100).
"The idea that Scripture is completely free from error. It is generally agreed by all theologians who use the term that inerrancy at least refers to the trustworthy and authoritative nature of Scripture as God's Word, which informs humankind of the need for and the way to salvation. Some theologians, however, affirm that the Bible is also completely accurate in whatever it teaches about other subjects, such as science and history" (Grenz, 66).
"the Bible is free from error." (Erickson, 100). Also: DOCTRINE OF INERRANCY says, "The Bible contains no error in that which it affirms" (Erickson, 100).
🙂 I wanted to know how you defined them.
So, do you not see overlap in these terms and that they are often used synonymously?
Regardless of what the theology books say, it's the way people are using these terms "on the street" that I am engaging with.


90, Business Plan Template, 13 30 60 90, Plan Example - Right here i will be discussing the simple steps concerned in writing a business plan: executive summary: step one involved in writing a business plan is the government summary&#forty six right here&#forty four encompass the entirety that you might cover in a five minute interview&#forty six. While you take a seat down to compile all the factors of your marketing strategy&#forty four make certain you've got each segment able to stand on its own deserves&#forty six this means you ought to not reference other sections sending the reader (your potential investor&#forty one from side to side among sections..
Never neglect to discover the next photograph album, which also carries the 90 day marketing strategy template new thirteen 30 60 ninety day plan instance image showed above. If you have any thoughts, questions or simply need to say howdy to different people, please do now not hestitate to publish your opinion/ideas thru the subsequent comment shape. Your phone earrings, it's miles the manager telling you that they're extending you a proposal! Consist of a demo consisting of a screencast, a link to running software, or images. What day of the week? In community principle complexity is the product of richness within the connections among additives of a machine,  and defined by way of a totally unequal distribution of sure measures some elements being particularly connected and some very few, see complicated community.
This approach implementation workout helps you to reveal every person what strategy success looks as if. This slide can be inspirational, a bigger imaginative and prescient of what the corporation should do if those modern-day plans are found out, or a rehash of the summary slide. Right here is an example of a resume for an access-stage control function with work experience and related coursework, and suggestions on the way to write one. Proportion and down load loose powerpoint templates, presentation slides and ppt templates. It's one of the maximum powerful equipment you can convey to the very last degrees of the employment interview manner. ?? 30 days of religious detox ★ garcinia cambogia zt and inexperienced coffee zt garcinia cambogia with detox capsules 30 days of non secular detox what's the best mg of garcinia cambogia garcinia cambogia zt and inexperienced coffee zt a involving humans trying to shed pounds the use of a food regimen software have struggled to shop for a software the developing system rely to.


Future betting takes place on an event that is set to occur in the upcoming weeks or even months. As the date gets closer, oddsmakers alter the online sports betting lines on the basis of ongoing results for the teams. Future bets do not feature point spreads, as the most common scenario features a concrete result. The most frequently used types of future bets involve the potential winners of the different sports leagues. Such titles as the Super Bowl 50 champion in the NFL and the championship of the English Premier League typically bring in big bets from bettors all around the globe. However, there are other types of future bets in addition to league titles. You can bet how many games a team will win in a season, which team will win a conference or division title, which teams will be promoted, and which teams will go through relegation. Just about every sport features future betting of some type, so online oddsmakers should carry the action that you want.


text:
A Running List of Programs and Resources the Trump Administration Plans to Cut Down, Eliminate or Privatize
2:45pm PST
Although the Trump administration is still in its infancy, the gears are already turning rapidly to defund, severely limit, or privatize — and ultimately incapacitate — significant parts of the US government as it currently functions. The first reports of "dramatic cuts" came before the inauguration, suggesting that the Trump team was taking their cue from the Heritage Foundation, a conservative think tank. Trump's team is proposing very significant cuts or full elimination of organizations and programs that have been a mainstay of recent American government and culture. Ostensibly, this is being done to cut down on government spending, although some of these decisions seem like they may end up financially benefiting members of the Trump team as private individuals, and others won't have much impact on government spending at all but will seriously impact the actual function of government. Right now these cuts are only proposed, but of course soon the administration will have the power to execute them. Here we'll try to document these cuts, program eliminations and profiteering scams to the extent we're able, and update as these stories continue to develop.
For the sake of clarity, an asterisk* denotes proposed cuts; a lack of asterisk indicates that the cut has been put into place.
Federal Funding for Sanctuary Cities
Trump followed through on his promise to cut federal funding to cities that defy his order and remain "sanctuary cities," refusing to assist the federal government in identifying and deporting undocumented immigrants. The denial of federal funding's only exemption is for grants to law enforcement, which means that the programs now without federal funding include "healthcare, housing, infrastructure, [and] disaster preparedness." East Bay Express notes that in Oakland, the programs affected include Head Start, lead safety, homeless shelters, and housing for low-income seniors. San Francisco is suing in response.
EPA's Staff and Budget*
Myron Ebell, former head of Trump's transition team at the EPA, said that "Trump is likely to seek significant reductions to the agency's workforce — currently about 15,000 employees nationwide." Confusingly, EPA staffers also received an internal memo that was linked to Motherboard that seems to guardedly tell employees not to believe this news, leaving it unclear what the real plan is.
An internal memo—first leaked to Motherboard by an EPA employee and later confirmed by the agency—sent to EPA staff by a senior White House advisor today indicates that Ebell's claims are causing unrest within the agency. The memo doesn't mention Ebell by name or say that the agency won't see major staff cuts, but notes that much of what's being reported in the news is not accurate, and that "no final decisions have been made with regard to the EPA."
A Lot of Federal Regulations
A new executive order requires that government agencies "revoke two regulations for every new rule they want to issue." This is on top of the regulatory freeze that Trump's team has already put in place on new regulations, which requires that any new regulations that were already in the works when Trump came into office have their effective dates postponed by 60 days. Lisa Gilbert of Public Citizen's Congress Watch was quoted as saying, "There's a lack of understanding of what rules do to keep our environment safe and protect our financial system." One effect of the freeze may be that an important mortgage disclosure rule, TRID, may not be decided upon, leaving parts of the housing industry in limbo.
Significant Amount of Funding for Air Travel*
The Heritage Foundation blueprint "calls for stopping all federal grants to airports and eliminating "wasteful subsidies" to the Essential Air Service program that serves rural areas."
CDC's Summit on Climate Change
Abruptly canceled after the inauguration, although it has since been put back on the table personally by Al Gore.
News of a revived conference comes days after the Centers for Disease Control and Prevention abruptly canceled its long-planned Climate and Health Summit in the lead-up to the change in White House administrations. Benjamin called the move a "strategic retreat" given the climate skepticism of the incoming administration.
Emails sent to participants and scheduled speakers did not explain the reason behind CDC's decision. Nor did the agency offer an explanation in response to a request for comment from The Washington Post, saying only that it was exploring the possibility of holding the event later in the year.
National Public Lands*
It's to be given away out of the government's possession, so it will no longer be public land or federally owned, and made salable to private entities — many areas may be profitable for mining, fracking, oil extraction and more. As it stands, national public lands are the US's second-largest source of income after taxes.
Department of Commerce*
"…major reductions in funding, with programs under their jurisdiction either being eliminated or transferred to other agencies." Cuts will include the Minority Business Development Agency.
Department of Energy*
"…major reductions in funding, with programs under their jurisdiction either being eliminated or transferred to other agencies."
Department of Transportation*
"Significant cuts and program eliminations."
Department of Justice*
"Significant cuts and program eliminations." Cuts are rumored to include the Office on Violence Against Women grant program, which provides funding to support victims of sexual assault and more, and the Legal Services Corporation, a nonprofit which helps provide civic aid to low-income Americans.
Department of State*
Corporation for Public Broadcasting*
To be privatized. The CPC, combined with the National Endowment for the Arts and the National Endowment for the Humanities, currently comprises 0.02% of the federal budget.
National Endowment for the Arts*
Completely eliminated. The National Endowment for the Arts, combined with the CPC and the National Endowment for the Humanities, currently comprises 0.02% of the federal budget.
National Endowment for the Humanities*
Completely eliminated. The National Endowment for the Humanities, combined with the CPC and the National Endowment for the Arts, currently comprises 0.02% of the federal budget.
Related:donald trumpLists/Top 10srepublicans
Trump Says He Won't Overturn LGBT Protections, But His Administration Will Still Discriminate Against Us
Rebel Girls: 33 Badass Women Leading the Resistance (On Twitter)
AHHHHJHHHHHHHHHHHHHHHHHHsdfgiojshdflgsd
Priscila T
The Department of State will presumably be enlarged. They're charged with administration under the Guano Islands Act, at least, so presumably best equipped to deal with Trump's bullshit.
Liam Invincible 67
Not sure it's the biggest thing (there's so much serious stuff which will happen) but I've already noticed the lack of art. Compare this inauguration to Obama's first one for example. The cuts are just more of this.
To be fair though at least he can't use arts for propaganda purposes as much if he's cutting them.
I'm British but I'm a poet, hence my interest in that sort of thing.
PartoftheResistance
The NEA is less than .02% of the budget. One microscopic fraction of the budget. So many arts programs, museums, public venues, and creative spaces will struggle to stay afloat if this is cut. I fear for a generation of children growing up without access to the arts, which is sadly the case for a lot of kids already. Without art, what do we have left?
Music that will be forced to meet a certain standard?
I should maybe not comment until I've got all my thoughts in order and then comment everything I think. Anyway these are my long-winded thoughts.
In a Utopian society, art funding would come from a state that didn't meddle with the arts themselves, simply funded them, and at a level that the programs needed. But I don't trust Trump to do that.
It's scary that kids might not grow up with art galleries, museums, ways and places to express themselves and to develop a love for the arts. I hope that either the funding doesn't get cut (as it looks like it will) or that people will be able to fundraise enough to keep places afloat, especially for poorer children who'll be unable to access the works otherwise (I can't imagine the museums simply closing rather than going for private or charity models so I hope it's the sort of charity one which allows everyone to access these things)
However my image of a Trump-run nightmare of a states art project might not include the sorts of things people get out of art which are good things to get. I was imagining a lot of censorship and propaganda – I want kids and others to be exposed to both the experience of being able to express themselves wholly and to have a wide-range of artists, both in terms of style and identity, which lets them know that art is for everyone and benefit from it. My image of a Trump-run arts project was a lot more propagandistic and censorship-led than that and if the alternative to that was run by arts volunteers who were more willing to bring kids what they needed then the third sector option would be better.
What I meant with saying that there's scarier things is that there really are. I think that under Trump both America and the world are going to be a scary place. It's a government of war-mongering, homophobic racists and he scares me almost as much as the people around him do. It's the physical stuff that might happen to people (including death) that's the scariest thing about this new government, in my eyes. Not to say that cutting the arts is a good thing, it really isn't. But it's not the scariest thing he can do.
I think individual art will (ironically) flourish under Trump. Simply because, unless he does get into the censorship side of things, artistic expression tends to do so under bad times. This is true both with the more obvious protest art and also the more subtle things. Art is about pushing against something.
I own my privilege in that I've never needed these sorts of programs, to me a trip to an art gallery is just a nice thing to have. I realise that some people who have less money or otherwise less access to the arts will be disadvantaged in ways which go beyond this simple lack of a nice day out or having to pay for a hobby which would otherwise be free.
Sorry if my thoughts are too long-winded. I'm aspie and have social anxiety and part of that is that I find it hard to express myself in a way which is both short and acually says what I mean so the other person 'gets it', in prose form especially.
Sorry this is so long winded, I find it really hard to be brief. I shouldn't have posted without being more clear though.
I agree that the ideal world would have a government which funded the arts at a level which was adequate. I then think they should leave it to museum curators, artists, teachers etc to make the actual decisions of when and how to teach it, make it and show it.
However, my nightmarish vision for what it might look like under Trump wasn't like that. I was imagining either him running it as a state-run propaganda department (in which Trump's particular view of the world was funnelled out to the public in the form of art which might actually be technically good and therefore persuasive to apolitical types) or cutting it (which is what he is doing).
The lack of funding for museums, art galleries and other public spaces is scary. I really hope that either the third sector step in and manage to run these things through properly trained volunteers (or simply interested people with the right 'sensibilities' for the arts, such as open-mindedness and creativity) or that Trump changes his mind with this and it goes into my ideal. I can't imagine that ideal under Trump, though.
Ironically I think that individual art will flourish under Trump. That doesn't make it good that he's president, obviously, but it's at the worst times that artists are often at their most inspired – both in the creation of things which are obvious protest art and in the creation of other things which, looking back, don't seem to be as direct. A lot of my favourite art was produced in the 80s, for example. As long as the censorship doesn't take hold.
There are a lot scarier things which might happen under Trump, though. He's a racist, misogynist who seems to be all up for a war. He's surrounded by more of the same and some very homophobic types. Lives are on the line.
I realise that I'm commenting from a position of privilege and I would probably not comment like this if I were poorer or otherwise unable to access art except that funded by the government. What to me probably looks just like a day out at a museum I managed to get into for free probably looks like a lot more to someone who isn't actually able to pay and who is in actual need of the experience.
Sorry if I'm being long-winded or not making sense. I'm aspie and have social anxiety and it's my first online comments in four years because I'm scared of saying something wrong. I need to be long-winded if I want to make sense to the other person in a prose format.
Sorry I seem to have actually posted my comments twice and they say basically the same thing. Not used to site yet!
Aparna Vengakkad
It's okay! What you said makes sense.
I work for a major non profit (theatre) arts organization that – and I imagine this is the case for many of similar status – gets the majority of its funding from memberships, box office sales, and private donors/philanthropists. We get only a tiny tiny fraction of our income from the NEA already, which is sad but it means thankfully we are protected from this kind of circumstance. Arts organizations will be depending even more on rich folks who dig the arts. Our philanthropists need to step it up. Unfortunately this also means that $$$ in the organizations needs to be funneled into a robust development department to recruit said donors and less $$$ goes to the art itself and those creating it.
No National Endowment for the Arts will make America great again
Kristana
Just to make you feel even better, the Trump administration has also removed all references to Climate Change on Whitehouse.gov, and also this:
It's only been 25 min and the Dept. of Labor's report on Advancing LGBT Workplace Rights has been taken down. https://t.co/KzBp8VZweD pic.twitter.com/UhnWqWZvPC
— Jay Franzone (@JayFranzone) January 20, 2017
In case it didn't come out, here's the link. "It's only been 25 min and the Dept. of Labor's report on Advancing LGBT Workplace Rights has been taken down."
https://twitter.com/JayFranzone/status/822495562138316801/photo/1
The resource page regarding for persons with disabilities is also gone!
I fully expected to see "elimination of the non-white non-heterosexual human race" somewhere in this. Oh well, baby steps.
VAWA…what else do you expect from an admitted sexual predator?
This one is bloody terrifying. So is the fact an admitted rapist is (even allowed to be) president :(
NancyP
We need a lot of people objecting to land giveaways. Write your representatives, Senators, and Trump.
Oh, and outdoor recreation at National Parks is a classic Trump voter, middle income voter, rural voter, white voter vacation.
(I do expect that the existing NPS outreach attempts to attract urban and suburban POC to the parks will be cut).
The National parks thing is one of the things I'm honestly more worried about. Literally crying thinking about oil derricks in Yellowstone or Yosemite.
Yeah that's one of the things that's hitting me hardest too. Many of these things can be salvaged or reinstated with a regime change. There is no (easy) way to get that land back after it's sold, or undo much of damage done by mining, fracking, or oil drilling.
Excellent resource; thank you.
When operating within an economy using a non convertible fiat money there is little to no financial constraint on federal spending. taxes don't finance spending. The spending choices represent pure political will and nothing more.
History has seen this all before. Each time someone like him and his rise, we and ours suffer and then we WIN.
Maybe this is the human condition……..the price of freedom, etc.
Because apparently I'm a masochist, I actually read the Heritage Foundation proposed budget a few weeks back, and I have to say, the worldview behind is both bizarrely selfish, yet also weirdly Panglossian and naive. Their basic outlook seems to be "Well, if people *really* wanted [social service], someone would've already been providing it via the free market." Unless it's abortion or LGBT equality, because God. And, also, climate change isn't real, because we said it isn't.
(The last bit *really* gets me. How come these people get to nakedly ignore physical reality, and yet if I were to try do that, I'd get laughed out of the room? I mean, if I were to say, well, I really hate getting sick, so I'm just going to decide that cold viruses don't really exist, people would think I was a fool)
82 Queer TV Shows to Stream on Netflix
Top 11 Times This Year Pop Culture Reminded Us Kids Are Queer and Trans Too
15 Funny Things Rachel Said Recently


text:
« www airg dating com
Hook up uk fuck
If I were like, Hey, I just wanna bone, very few people would want to meet up with you …"Do you think this culture is misogynistic?" he asks lightly.'I call it the Dating Apocalypse," says a woman in New York, aged 29.There's always something better." "If you had a reservation somewhere and then a table at Per Se opened up, you'd want to go there," Alex offers."Guys view everything as a competition," he elaborates with his deep, reassuring voice. " With these dating apps, he says, "you're always sort of prowling.You could talk to two or three girls at a bar and pick the best one, or you can swipe a couple hundred people a day—the sample size is so much larger. Crew; senior at Parsons; junior at Pace; works in finance …In fact, it's estimated that only 12% of swipes on Tinder actually result in a match.
"There have been two major transitions" in heterosexual mating "in the last four million years," he says.It's setting up two or three Tinder dates a week and, chances are, sleeping with all of them, so you could rack up 100 girls you've slept with in a year."He says that he himself has slept with five different women he met on Tinder—"Tinderellas," the guys call them—in the last eight days. ""We don't know what the girls are like," Marty says."And they don't know us," says Alex.Dan and Marty, also Alex's roommates in a shiny high-rise apartment building near Wall Street, can vouch for that. "She works at—" He says the name of a high-end art auction house. And yet a lack of an intimate knowledge of his potential sex partners never presents him with an obstacle to physical intimacy, Alex says.Everyone is drinking, peering into their screens and swiping on the faces of strangers they may have sex with later that evening. "Ew, this guy has Dad bod," a young woman says of a potential match, swiping left.
Her friends smirk, not looking up."Tinder sucks," they say. At a booth in the back, three handsome twentysomething guys in button-downs are having beers.
In fact, they can remember whom Alex has slept with in the past week more readily than he can."Brittany, Morgan, Amber," Marty says, counting on his fingers. Alex, his friends agree, is a Tinder King, a young man of such deft "text game"—"That's the ability to actually convince someone to do something over text," Marty explains—that he is able to entice young women into his bed on the basis of a few text exchanges, while letting them know up front he is not interested in having a relationship."How does he "But Marty, who prefers Hinge to Tinder ("Hinge is my thing"), is no slouch at "racking up girls." He says he's slept with 30 to 40 women in the last year: "I sort of play that I could be a boyfriend kind of guy," in order to win them over, "but then they start wanting me to more …
dating older guy bad
Noreg married chatr cam
Chat with arab women webcam
Cam4 es ginevra com
Live sex cam of man woman
How to have random cam sex
Dating for special needs
Asian chat live client chat
Dating an overly jealous person
2 waysex cam chat room
Sex vedio without having to register
Dating site find rich men


text:
BREAKING NEWS: Cleveland Murder Suspect Steve Stephens Kills…
Steve Stephens, the Cleveland murder suspect accused of posting video of the slaying on Facebook, shot and killed himself Tuesday…
LOCAL NEWS: Steve Stephens Placed On FBI's 10…
The search for Steve Stephens is now a national manhunt. Law enforcement officials across the country are continuing to look…
LOCAL NEWS: 'A Good Man': Family Members Mourn…
news5: Police have named the victim shot and killed in Cleveland by a man who live-streamed the homicide on Facebook. He's identified…
LOCAL NEWS: Police Received Hundreds Of Tips, But…
Local and federal law enforcement agencies across northeast Ohio and surrounding states remain on the lookout Monday morning. The Facebook Live…
Dylann Roof Pleads Guilty To State Murder Charges…
Charleston shooter Dylann Roof has pleaded guilty to state charges avoiding the possibility of a second death sentence. The 23-year-old…
LOCAL NEWS: One Person Injured After Shooting Outside…
One person was injured after shots were fired at Beachwood Place mall on Thursday night. According to Beachwood police, the incident occurred…
LOCAL NEWS: 2 More Officers Disciplined In Connection…
Nearly two-and-a-half years after the shooting of Tamir Rice, Cleveland Police Chief Calvin Williams just disciplined two city workers for their…
Pregnant, Suicidal Woman Slain By Washington Cops During…
Renee Davis, a mother to three children, aged two, three and five, sent a text to friends and family earlier…
TYSON GAY: OLYMPIC TRACK STAR'S DAUGHTER (TRINITY) KILLED…
Here's a sad and tragic story we have to report. Olympic sprinter Tyson Gay's 15-year-old daughter, Trinity Gay, was shot…
Multiple people were injured and a shooting suspect was taken down by police after he they opened fire at a…
Tulsa Officer Betty Shelby Booked, Released On Bond
Tulsa police officer Betty Shelby was booked at the local county jail early Friday and released shortly after on $50,000…
Person Shot, Officers Injured During Violent Uptown Charlotte…
One person is in critical condition, two others were hospitalized and seven police officers were taken to the hospital after…
Terence Crutcher's Family Seeks Criminal Charges: 'His Life…
The U.S. Department of Justice has opened an investigation into the police killing of 40-year-old Terence Crutcher in Tulsa, Oklahoma,…
Tulsa Shooting: Video Shows Unarmed Terence Crutcher Being…
A video shows an unarmed black man, by the name of Terence Crutcher, with is hands raised being shot by…
Video Shows Tulsa Man Shot And Killed By…
In Tulsa police helicopter footage that was among several clips released Monday showing the shooting of 40-year-old Terence Crutcher and…
13-Year-Old Boy Fatally Shot By Police After Pulling…
wbns-tv: A 13-year-old boy has died after an officer-involved shooting in east Columbus. Police responded to a report of an…
Two Men Arrested For Murder Of Dwyane Wade's…
Two men … in fact two brothers – Darwin Sorrells Jr., 26, and Derren Sorrells, 22 – have been charged…
KORRYN GAINES: SON RECALLS SHOOTING FROM HOSPITAL BED
getty/instagram An "unprecedented number of threats" have been made against the Baltimore County Police Department since the fatal police shooting…
Husband, Wife Dead In Murder-Suicide Outside Church
A 39-year-old man fatally shot his wife, then killed himself Sunday afternoon outside a church in the city's Austin neighborhood,…
Former Miss Alabama Admits She Shouldn't Have Called…
GETTY IMAGE: The first black woman crowned Miss Alabama is standing by a controversial video in which she called the Dallas gunman a "martyr,"…
Alton Sterling's Son Pleads For Unity In America:…
ABC: Kyle Bridges // EEW Magazine News Cameron Sterling, the 15-year-old son of Alton Sterling, a black man who was…
Diamond Reynolds Says She Recorded Dying Philando Castile…
getty images: Article By Angela Walker // EEW Magazine News Millions have viewed the chilling video of the moments following…
Dallas Cop Killer Micah Johnson's Parents Speak On…
The parents of gunman responsible for the killing of five Dallas police officers, Micah Xavier Johnson, have broken their silence…
Diamond Reynolds Speaks Out On 'Good Morning America,'…
During an interview with George Stephanopoulos on Good Morning America, Diamond Reynoldsdisplayed the same level of composure she held while she…


If you were a Super Hero Toe, what would your super power be? The power to make everyone dance like everyone's watching (because let's face it, it's more fun to dance for an audience than dancing all alone!).
Guilty Pleasure? I feel no guilt from pleasure.
Who would you invite to be an honorary Toe (living or dead)? I'm so glad that Ms. Antoinette K-Doe was able to join us as Queen Toe before she passed. She embodies everything I hope to represent.
Favorite Toe Moment? The year after Katrina I did not march but high tailed it to New Orleans in time to catch the lovely Toes marching toward me on St. Charles avenue. Getting welcomed back to the city by a sea of beautiful Toes (truly, within 30 minutes after my arrival back in the city) was the sweetest homecoming imaginable.
What is your idea of perfect happiness? Tequila, sequins, glitter and a brass band.
What is your "Toe" Motto? When in doubt, drop it like you mean it.


text:
Q: Sharing unit testing fixtures I'm writing unit tests for a project (written in PHP, using PHPUnit) that have its entire environment (loaded components, events, configuration, cache, per-environment singletons, etc) held in an object which all the components use to interact with each other (using a mediator pattern).
In order to make the unit tests run faster, I'm sharing the environment object and some other objects (for example, in my test case for view object [as in the V of MVC], the view manager object [which acts as a factory for view objects and responsible for the actual rendering]) among tests in the same test case (using PHPUnit's setUpBeforeClass() and static properties).
Even though, to the best of my knowledge, the objects I share shouldn't effect the integrity of the tests (in the views case, for example, the environment and view manager object are shared, but a separate view object is created for every test - which is the object that's actually being tested by the test case), it just feels increasingly wrong to me.
I would prefer it if each test used a completely isolated environment and couldn't effect other tests in the same test case in any way. However, that would make the tests run much slower and it feels like a big price for something that I can't really pinpoint the downside of and mainly just "feels wrong".
What do you think? Can you pinpoint any downsides so I can convince myself its worth the longer execution time? Or am I just over reacting and its completely fine?

A: I share your feelings so maybe i just state my goals and my solution when i faced that issue:

*

*Devs should have a test suite that runs very very fast

*At least single test cases should execute in less than a second

*I really want to be sure i don't have interdependencies in my test cases

I'm going to assume you have a Continuous Integration Server running. If not a cronjob might do but consider setting up jenkins, it's really really easy.

For normal usage:
Just share as much fixtures as you need to get the speed you need. It might not be pretty and there might be better solutions along the way but if you have something that is expensive to create just do it once.
I'd suggest helper methods getFoo() { if(!self::$foo) .... create ... return $foo;} over setUpBeforeClass because it can make sharing easier but mainly because of the following point.
Once a night:
Run your test suite with --process-isolation and in that bootstrap recreate your complete database and everything.
It might run 6 hours (disable code coverage for that!) but how cares. Your fixtures will be recreated for every single test case since it's a new php process and the static vars don't exist.

Using this way you can be sure that you don't have created dependent once a day. Thats good enough to remember what you did (and you can run with --filter and --process-isolation if you need to fix something).

A: Like writing "normal" code, when you write test cases, it's fine to rely on knowledge of how fixture objects work.
If a given factory method is documented as generating new instances every time, then I see only downside in creating the factory method anew each time, especially if the factory creation is itself expensive.
It helps to keep in mind a key goal around writing unit tests. You want to know within 5-10 minutes whether you broke the build. That way you can go out to lunch, go to a meeting, go home, etc. after you get the "all clear". If you know that some part of the fixture is reusable without creating interactions, then you should use that knowledge to make your tests even more comprehensive within that 5-10 minute window. I understand the purist impulse here, but it buys you nothing in terms of test independence, and it unnecessarily limits what your test suite will accomplish for you.

A: Perhaps this is blasphemous, but if you can still manage a significant threshold of code coverage and you can also guarantee that no state pollution can exist (and that is your real issue -- are you making sure that each test will not be effected by the data left over from the test before), I see no problem with leaving things the way they are.
Let the tests run quickly, and when a bug is found (which is inevitable in integration testing) then you have reason to invest the time in localizing one particular test or set of tests. If you have a toolkit which works for the general case, however, I would leave it as is.