text:
10 Shows and Movies To Watch If You Like Gilmore Girls
Who wouldn't fall in love with the mother-daughter relationship of Rory and Lorelei a.k.a the Gilmore Girls? This tv show moved everyone's hearts because of the bond between the lead characters. Not only that it showcases real-life struggles, but it also promotes good family relationship and that you should stick together despite hardship.
Although the show had ended more than a decade ago, we really can't get enough of Gilmore Girls. If you find yourself in a similar situation, here are some of the best movies and tv shows like Gilmore Girls you should check out.
1. Parenthood
4. The Mindy Project
5. The Fosters
6. The Bunheads
7. Veronica Mars
8. The OC
9. Revenge
10. Pretty Little Liars
Like Gilmore Girls, Parenthood is also starred by Lauren Graham. This show is another hit because of the realistic scenarios that everyone can relate to. The hardship that a family goes through and how they stick together during troubled times make viewers realize the importance of family. Though Amber may have a huge difference from Lorelei, the audience would definitely be moved by how Sarah shows her undying support and unconditional love. A tear-jerker at times, but also has its own share of humor in it.
Mom, the sitcom, follows a dysfunctional single mother-daughter duo that's both inspiring and remarkably entertaining the same time. The unorthodox exchange of dialogues makes it an interesting sitcom to watch, given that the storyline, the characters, and the scripts are very much like a common everyday scenario of an average family. Just like Gilmore Girls, the mom-daughter pair in Mom — Bonnie and Christy also share the same rough relationship with each other. Full of sarcasm and humor, this show is addicting!
There are many similarities between the two shows. Similar to Gilmore Girls, Jane The Virgin also features themes like mother-daughter relationship, an unexpected pregnancy, and they've also got a grandmother with a strong personality. You'll be amused by the hilarious scenes and heartwarming scenarios that are all twined up by a unique twist of being pregnant despite being a virgin! It has an interesting plot that will make you curious about what will happen next.
Watch Jane The Virgin trailer on Youtube:-
The storyline is a bit different, but what makes The Mindy Project similar to Gilmore Girls is the constant approach to life by the main character, Mindy. Her comical ambition in life, relationships, and the hiccups that come with it make her an interesting and amusing character that everyone can relate to. Mindy's transition from one phase of her life to the next shows her growth to become more mature despite her shortcomings.
Another story about family, but this time an untraditional one. The Fosters features a lesbian couple who took in children as their own. The show depicts the unorthodox issues that most of us don't encounter every day, but we all know that it happens in the real world. What's beautiful about this show is that it explores the bond between parents and their children, giving emphasis that a family is not all about being related by blood. A very interesting story with its own share of angst, drama and unique twists of challenges.
Some say that this show is like a remake of Gilmore Girls. Aside from having Kelly Bishops on board (that's Emily Gilmore of Gilmore Girls), the main character, Michelle, is very much like Lorelei. A strong, independent woman who is very witty in the way she talks! That fast-paced speech, it's so Lorelei like! On the other hand, Sasha is like a more troubled version of Rory at the start. But towards the end, everyone we'll see her soft spot and how she somehow creates this amazing connection with Michelle. You'll surely be both amused and touched by this tv series!
Coming from the same network as Gilmore Girls, both shows follow another strong parent-daughter bond. A slight twist though, this time it's a father-daughter thing, but still with the same amount of compassion and warmth towards each other. Both shows also feature smart women with strong, distinct personalities. Not only that, the same witty and sarcastic exchange of dialogue is also present amongst the characters.
Watch Veronica Mars season 1 trailer on Youtube:-
The OC is a teen drama television series about Ryan Atwood, a gifted teenager with a dark and depressing background, who gets adopted by the wealthy Cohen family. The story revolves around Ryan and his foster brother as they try to live alongside wealthy high schoolers in Newport Beach. While the storyline might evoke a teenage feel to it, the writing in this series is so remarkable that you'll be hooked even before you know it! The series shows both good and bad parenting that ensures you will get a feel for the characters. It has a nice reverse-cinderella story for romance that feels fresh and wholesome to watch.
In Hamptons, the world revolves around wealth and status. Emily Thorne, a woman fueled by revenge for her father who was framed for a crime. It caused them to separate and never to see each other again. She then rents a beach home in Hamptons to destroy the lives of the people who wronged her father. This series blends in both the "monster of the week" and "overarching storyline" so well that you will be at the edge of your seat rooting for Emily. The show packs a faced-paced story with a big finale for its first season. It proves that hell really hath no fury as a woman scorned.
The series follows Spencer, Alison, Haria, Hanna and Emily, five high school girls from the town of Rosewood, Pennsylvania. During a stayover at Spencer's family barn, the girls wake up only to find out that Alison is missing. The group tried to find her but to no avail. Missing the leader of the pack, the group slowly drifts apart until a year later, they began receiving mysterious messages from someone named "A". "A" threatens to torture the girls and to tell secrets that only Alison would have known. While initially thinking Alison was behind the phone, they came to a shock when Alison has been found dead. The mystery in this series will challenge your thoughts and problem-solving skills as you try to unearth each answer and piece them together as the season progresses.
What is your favorite show like Gilmore Girls?
Yes, we know this list gives you a lot of reasons to bury yourself in your couch. Just a piece of advice, you might want to choose a perfect day to run a marathon for each of them. This way, it won't affect your everyday tasks and you'd get to appreciate all the episodes. Pick that one day of the week, get popcorn, pizza, ice cream, or just everything within your reach, then start clicking that remote control!
Bonus Gilmore Girls Content
Other Shows to Check Out
10 Shows To Watch If You Like The Office
8 Shows To Watch If You Like Family Guy
10 Shows & Movies To Watch If You Like Altered Carbon
9 Shows to Watch If You Like Silicon Valley
10 Shows to Watch If You Like Gilmore Girls (This Article)
5 Games To Play If You Like Cards Against Humanity (CAH)
9 Cheetah Facts You May Not Know About


text:
Q: Insert record from list if not exists in table cHandler = myDB.cursor()
cHandler.execute('select UserId,C1,LogDate from DeviceLogs_12_2019') // data from remote sql server database

curs = connection.cursor()
curs.execute("""select * from biometric""")  //data from my database table

lst = []
result= cHandler.fetchall()
for row in result:
    lst.append(row)

lst2 = []
result2= curs.fetchall()
for row in result2:
    lst2.append(row)

t = []
r = [elem for elem in lst if not elem in lst2]
for i in r:
    print(i)
    t.append(i)

for i in t:
    frappe.db.sql("""Insert into biometric(UserId,C1,LogDate) select '%s','%s','%s'  where not exists(select * from biometric where UserID='%s' and LogDate='%s')""",(i[0],i[1],i[2],i[0],i[2]),as_dict=1)

I am trying above code to insert data into my table if record not exists but getting error :

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1111'',''in'',''2019-12-03 06:37:15'' where not exists(select * from biometric ' at line 1")

Is there anything I am doing wrong or any other way to achieve this?

A: It appears you have potentially four problems:

*

*There is a from clause missing between select and where not exists.

*When using a prepared statement you do not enclose your placeholder arguments, %s, within quotes. Your SQL should be:

*Your loop:

Loop:
t = []
r = [elem for elem in lst if not elem in lst2]
for i in r:
    print(i)
    t.append(i)

If you are trying to only include rows from the remote site that will not be duplicates, then you should explicitly check the two fields that matter, i.e. UserId and LogDate. But what is the point since your SQL is taking care of making sure that you are excluding these duplicate rows? Also, what is the point of copying everything form r to t?
SQL:
Insert into biometric(UserId,C1,LogDate) select %s,%s,%s from DUAL where not exists(select * from biometric where UserID=%s and LogDate=%s

But here is the problem even with the above SQL:
If the not exists clause is false, then the select %s,%s,%s from DUAL ... returns no columns and the column count will not match the number of columns you are trying to insert, namely three.
If your concern is getting an error due to duplicate keys because (UserId, LogDate) is either a UNIQUE or PRIMARY KEY, then add the IGNORE keyword on the INSERT statement and then if a row with the key already exists, the insertion will be ignored. But there is no way of knowing since you have not provided this information:
for i in t:
    frappe.db.sql("Insert IGNORE into biometric(UserId,C1,LogDate) values(%s,%s,%s)",(i[0],i[1],i[2]))

If you do not want multiple rows with the same (UserId, LogDate) combination, then you should define a UNIQUE KEY on these two columns and then the above SQL should be sufficient. There is also an ON DUPLICATE KEY SET ... variation of the INSERT statement where if the key exists you can do an update instead (look this up).
If you don't have a UNIQUE KEY defined on these two columns or you need to print out those rows which are being updated, then you do need to test for the presence of the existing keys. But this would be the way to do it:
cHandler = myDB.cursor()
cHandler.execute('select UserId,C1,LogDate from DeviceLogs_12_2019') // data from remote sql server database
rows = cHandler.fetchall()
curs = connection.cursor()
for row in rows:
    curs.execute("select UserId from biometric where UserId=%s and LogDate=%s", (ros[0], row[2])) # row already in biometric table?
    biometric_row = curs.fetchone()
    if biometric_row is None: # no, it is not
        print(row)
        frappe.db.sql("Insert into biometric(UserId,C1,LogDate) values(%s, %s, %s)", (row[0],row[1],row[2]))

redpajama_set_name: RedPajamaStackExchange


text:
Former Crewe Alex loanee Uche Ikpeazu on coming through the football wilderness
The 23-year-old had three separate loan spells over two seasons at Gresty Road and has had a journeyman career before earning a move to Scottish Premiership side Hearts
John McDougall
Uche Ikpeazu in action for Crewe Alex in 2014.
Former Crewe Alex loanee Uche Ikpeazu may still only be just 23 years of age - but he has already had his fair share of experiences and overcome disappointment to reach the biggest stage of his career so far.
He had no fewer than three loan spells at Gresty Road under former Railwaymen boss Steve Davis between 2014 and 2015.
He scored four goals in 15 appearances during the second half of the 2013-14 campaign after moving to the League One side on loan from Watford, where he had been signed by Gianfranco Zola from Reading.
A further two spells followed in the following campaign, but the forward only managed two more goals in 17 games in a Crewe shirt.
Since leaving Gresty Road, Ikpeazu's career has taken him onto further loan spells with Doncaster Rovers, Port Vale and Blackpool.
He refound his form during a two year spell at League Two side Cambridge United, before departing over the summer with a move to Scottish Premiership side Hearts.
Hearts' Uche Ikpeazu (front left) and Rangers Joe Worrall battle for the ball during the Ladbrokes Scottish Premiership match at Ibrox Stadium, Glasgow. (Image: Jeff Holmes/PA Wire)
"I have been in adversity," he told the Daily Mail . "But I am a happy guy. I love where I am now.
"I have been in positions where I haven't being getting paid, where I haven't had a club. I have been rock bottom. So the only way was up.
"I should have stayed at Reading. I say this without regret. What is past is past. But I was in the youth team at Reading and then went to train with the first team at Watford. I wasn't ready.
"There were some great things that I still carry with me, though. Gianfranco helped me a lot and I was pushing to get a game when he was sacked.
"He would point out things that I didn't understand until later in my career. He told me: 'You have the ability to do well. But you need to read books, watch a lot of football and watch what you eat'."
After leaving Gresty Road, Ikpeazu was farmed out to the Keepmoat Stadium, Vale Park and Bloomfield Road as he escaped what was turning out to be a lonely time at Vicarage Road.
He was training on his own, took a pay cut and found out he was being released by the club when he was watching Sky Sports News.
Crewe Alex: David Artell admits he thinks about the need to sell players 'regularly'
"Football is brutal. I was proper sad and angry. I was thinking: 'Where do I go from here?," he said.
"It was the lowest point in my life. I was in the car with my agent on my way to Stevenage. No league club seemed to want me. Then the phone rang and we did a U-turn."
The man on the phone turned out to be then Cambridge United boss Shaun Derry, who offered Ikpeazu a lifeline after remembering his time with the Alex.
He said: "God bless that guy. He gave me a chance. He said he had been impressed with me when I played against him when I was at Crewe. I went to Cambridge, did well, scored goals. Everything clicked.
"I proved myself at Cambridge over two seasons. I had no choice but to work hard. I didn't see it as a contract. I saw it as a career lifeline.
"I told myself: 'This is your last chance. Buckle up and go for it'. I had been about senior teams since I was 18, so I was experienced. I was tough mentally. I had to be.'
"You know what it is to be loved? Shaun Derry showed me that but so did Craig Levein. He wanted me here. There were other clubs interested but Hearts really wanted me.
Crewe Alex opinion: Home fans' groans told the story at Gresty Road
"He showed me clips of how he could improve me. It kind of touched me.
"I prayed on it and it felt right. The lesson for me is that going through adversity doesn't mean anything much because you can always bounce back. I want to test myself further."
chesterchroniclesport
Chester FCHow Danny Elliott became a Chester FC player and how important he could beBlues bosses got a deal over the line when it had looked unlikely at one stage
Crewe AlexandraOlly Lancashire on the potential of being Crewe Alex captainThe defender says he is just focused on his job

redpajama_set_name: RedPajamaCommonCrawl


It's gone one am and I'm not asleep yet.
I'm at my third AuPair family's house. I haven't been here in 8 or 9 years, and it is amazing how much has happened since then, yet how recent my time here seems.
It doesn't feel strained or tense or foreign, it's more like I've been away for a couple of months than several years. We've all changed a bit, but stayed the same a lot – things still fit, and we didn't have to go through the awkward small talk at the beginning, we just took up where we'd left off. We have reminisced, and compared memories, and tried to catch up a bit, but one evening /overnight stay isn't nearly long enough to cover everything that's happened since I lived here.
I'm going to make an effort to see them more often than once a decade from now on.
Right now I need to get some sleep!
That speaks loads about you, as a person. To have spent time living in a home with a family, not of your own, and taking care of their child/children many years past. To be welcomed into their home again for an overnight stay. A night rich with memories and fondness, not the tense and uncomfortable conversations of strangers, you played a significant role in their lives many years ago and are loved to this day. Not many people can lay claim to that kind of love and support.


Futurehealth WinterBrain 20 minute plenary presentation by Jay Gunkelman. The functioning of the mind and brain imply memory function, and this short talk will focus on a mechanism for "memory"... from storage and retrieval, to short term and long term memory. The neurophysiological underpinnings of memory contain within the cognitive neuroscience some direct implications regarding a mechanism for archetypal memory. This talk will attempt to communicate some of the mystery and awe that are inherent to real neuroscience.
Recent neurofeedback studies by Simon Hanselmayr showing improvement of memory with the re-tuning of the alpha frequencies is powerful evidence of a causal link between the alpha frequencies and semantic memory performance. These findings have important implications for brain brightening in the ever aging population, especially in light of the correlation between slower alpha frequencies and aging, and the associated memory decline.
The phase locking of alpha and theta, and the interaction of these two separate systems is thought to be at the neurophysiological basis of the event related potential (ERP), and is one of the basic tennents of the model of consciousness being taught currently.
Underlying all this memory processing is the basis of the memory storage. Sensory information has been shown to be encoded as a Gabor function using indwelling microelectrode recordings. This points directly to an "interference pattern" based encoding and retrieval system, or the "holographic" nature to memory storage.
There are implications for superconductivity and/or superfluidity being required for our memory's proper function, and within this there are implications for a neurophysiological basis to exist underlying archetypal memory, and the mechanisms for communication at an archetypal level.


text:
Q: Dijit Combobox text align not working in IE8 I am new to using dijit and dojo. I am currently using dijit 1.6.0 and have a ComboBox defined as so:
this.comboBox = new dijit.form.ComboBox({
    style : "margin-left: 10px; text-align: left",
    store : this.comboBoxData,
    searchAttr : "label",
    selectOnClick : true,
    value : "All",
    onChange : dojo.hitch(this, this.onObjectiveChanged)
});

When the value within the combo box is changed and if the text is too large for the width of the combo box, the text appears right aligned instead of left aligned. I have read that this might be a bug in IE8 where the focus of the cursor is at the last character of the text, in which case this might not be a css issue. I am not entirely sure how to get the cursor within the combobox to focus on the first character of text.

A: I managed to get the combo box to display the beginning of the text rather than the end by calling this.comboBox.focus() whenever a value is either changed or selected within the comboBox


text:
Title: War Surgery and Medicine
Author: Stout, T. Duncan M.
War Surgery and Medicine
REVIEW OF POSITION AT END OF WAR
The position as regards the treatment of war wounds at the end of the war may be summarised as follows:
The technique of surgical cleansing1 was by no means an excision of the wound. Little or no skin was removed, and then only if ingrained with dirt and devitalised. The same held true with regard to the subcutaneous tissue and fascial layers, but fatty tissue was more freely excised. The nerves and vessels were left intact except when smaller vessels were implicated in the removal of muscle. All dirty and devitalised muscle was removed, leaving only bleeding and fresh coloured muscle. If muscle groups were seriously devitalised and any evidence of anaerobic infection existed, then whole muscle groups were removed. Bone was not removed unless it was dirty and lying quite separate, and not of sufficient size to render non-union or marked weakness of the bone structure probable. The wound was freely enlarged longitudinally to the limb and the fascia opened up to expose the whole depth of the wound, and divided transversely if any tension was present. If necessary counter incisions were made. The wound now being wide open and cleansed of all foreign and devitalised tissue, penicillin powder was dusted over the whole inner surface of the
1 The words 'surgical cleansing' have been deliberately chosen because of the obscurity of meaning attached to the name excision, and, to a lesser extent, to the French word ébridement.
page 37 wound and gauze placed over it and used also to keep the surfaces lightly apart. The gauze was either plain or vaselined, or tulle gras could be utilised. The limb, unless the wound was of minor degree, was then encased in a padded plaster which was split after application so as to ensure no interference with the vascularity of the limb during evacuation. Parenteral penicillin was then given four-hourly for a minimum of forty-eight hours, and in all large wounds and fractures for a longer period. Blood transfusion was given to all seriously wounded men according to blood loss and shock. Serum was generally given as well in the proportion of one pint of serum to two of blood. In cases of burns blood serum alone was given, and frequently several pints were necessary to combat the haemo-concentration present.
Appropriate splinting was applied to all fracture cases, plaster being used in all fractures except those of the femur, when a Thomas splint with plaster strengthening was utilised. The casualty was then evacuated to a General Hospital either by ambulance train, hospital ship, or by air, and given a short period of rest. On about the fourth day, and frequently earlier, the patient was taken to the operating theatre, no dressing having been attemDted since the original operation in the forward areas, the plaster and dressing removed, and, unless definite infection had occurred, the wound was again dusted with penicillin powder and sutured, either by simple salmon gut stitches, taking a deep bite of the tissues, or by figure-of-eight silk stitches. Parenteral intramuscular penicillin was then given for a few days after suture in all severe wounds. No dressings were carried out for from a week to ten days, when at dressing the stitches were removed. Splints were applied to all severe wounds as at the original operation. By this technique about 80–90 per cent of all wounds healed satisfactorily.
If infection of any severity occurred the wound was opened, penicillin tubes inserted, penicillin instilled twice daily, and parenteral penicillin continued. In the rare septic case further blood transfusions were given to combat the associated secondary anaemia which usually developed in these cases. When fractures were present the same routine was carried out, but the penicillin was continued longer, for at least a week after suture of the wound. If sepsis arose, drainage of the wound was often carried out. For those cases in which sepsis contra-indicated delayed primary suture, parenteral and local penicillin was continued till the wound became healthy and allowed of secondary suture, and at times other measures such as the instillation of the hypochlorites were utilised in the penicillin-resistant infections. In the forward areas primary suture of the wound was not attempted, except in page 38 certain parts such as the scalp and face. The performance of delayed primary suture was simple and efficient, and, besides being safer, it brought about a satisfactory distribution of the operative work between the forward and base units. The ideal of primary suture seemed hardly justifiable under the conditions of active warfare, partly because the transportation of the patient would naturally militate against the healing of the wound.
If any loss of tissue had occurred, and especially in burns on the hands, skin grafting was carried out at the very earliest period, and that meant at the time when delayed primary suture was done. If gas gangrene eventuated, radical removal of muscle was called for and a full course of penicillin parenterally. Amputation was necessary only if actual gangrene of the limb itself set in. Diphtheritic infection of wounds, by no means uncommon, was combated by the institution of serum. As a wound application the sulphonamides, except as a medium for the administration of penicillin, had faded from the picture though sulphonamides given by the mouth were still utilised in head cases and in penicillin-resistant infection.
The story of the treatment of war wounds during the 1939–45 War is one of great interest, showing as it does the gradual development of ideas and knowledge till a selected and trained medical personnel was able to devise a technique, with the aid of new antiseptics and antibiotics, that was both simple and very efficient.
The development from the closed plaster technique to the use of the sulphonamides, and finally to the employment of penicillin, and the very early complete closure of the wound, was a triumph for British surgery in which our New Zealand Medical Corps was honoured to be able to participate. The great lesson that was learnt was that no stereotyped method, however hailed as a panacea, should blind one to the truth that there is no finality in medicine, and that we cannot be content till we reach as near perfection as possible.
The closed plaster technique was accepted too readily by out younger surgeons at the beginning of the war, when it really was producing poorer results in many ways than were being obtained at the end of the First World War. Sulphonamides again were expected to do too much to assist the surgeon, and it was not till the dramatic discovery of the remarkable bacteriostatic effects of penicillin on wound organisms that surgeons would turn their attention to the early closure of wounds, and thus approach, and finally improve on, the results actually attained in the First World War. The principles of the removal of soiled and devitalised tissue from the wound, the relief of tension, the provision of page 39 rest to the tissues and the individual, the replacement of lost fluid and blood, the protection of the wound from contamination and finally its complete closure to prevent that contamination and allow of early restoration of function, were not new or strange. They were relearnt slowly, and sometimes laboriously, by a new generation of surgeons. They will have to be learnt again possibly by another generation of surgeons who may have more powerful bacteriostatics and possibly improved techniques in other ways, but the cardinal principles will remain. We can but hope that eventually it will be possible to close wounds completely and safely at the original operation shortly after the wound has been sustained, and thus save subsequent dressing and subsequent infection with so much relief to the patient, and with much lower mortality and morbidity. The severity of the injury may at any time cause death, but if we can ensure the rapid and aseptic healing of the wounds themselves we will save some lives. Undoubtedly many lives were saved in the 1939–45 War by the determined and persistent progress of wound treatment in the British Army, of which we were proud to be an intimate part.
Invalids Evacuated to New Zealand or Discharged in United Kingdom
Wounds in Action
2 NZEF 1940–451 1 NZEF May 1916– Dec 1918
Head 276 440
Eye 216 172
Chest 297 616
Abdomen 202 268
Amputations, leg 307 195
Amputations, arm 80 159
Spine 53 91
Nerve lesions 622
Knee joint 85
Shoulder joint 45
Burns 24
Vascular 55
Fractured feet 245
Fractured jaw 86
Fractured femur 346
Fractured tibia and fibula 481
Fractured humerus 350
Fractured forearm 360
Ear 120
Pelvis and hip 100
Other 259 364
Other wounds of back 174
Perineum 50
Other wounds of arm 2300
Other wounds of leg 2683
Multiple wounds 79
TOTAL 4609 7591
Total wounded for period 16,456 36,516
Also wounded taken PW 1,326
1 2 NZEF (IP) not included.


Brave Hearts prides itself in knowing it provides a well-rounded care plan for each child and youth under its support. To ensure a bright future for those under our program we implement our services in a strategic manner from all aspects of life.
Our holistic care model specifically aims to reduce vulnerability in order to ensure that factors that place the child at risk are eliminated. Brave Hearts not only supports the child but also ensures the environment around the child is safe, healthy and sustainable to allow the child to blossom and excel.
Brave Hearts applies risk assessment tools to weed out any factors that affect the child negatively such as an unhealthy environment, inaccessible facilities, dysfunctional care provisions, and inadequate basic services.
Apart from support on basic needs, we provide much needed counseling and psychosocial support to the child or youth and his or her guardians. This model provides us with a high success rate at rehabilitating the child and his/her environment to a healthy surrounding where s/he can thrive.


text:
What happens when we see ourselves as separate from or as a part of nature?
Apart or Together?
By Courtney Wise
290 total words
I think when we as humans see ourselves and our species separate from nature, we tend t view ourselves as higher up or superior to nature. As if we have the power over nature and we can control it. Or at least do what we want with it. That is where I think we still have the power to keep destroying it, but every now and then nature reminds us that it has the power, forces beyond what we as humans can deal with and mother nature hands us our behinds to remind us now and then. Now on the other hand, when we see ourselves as a part of nature it is a bit different. We feel connected and feel the beauty and the power that it has. We can feel the energy, ours and nature, working together. However, I think this is where we as humans tend to veer off the path with nature and try to overpower it. Take over it. We get carried away with the power, beauty, and riches of nature that we try to strip it of itself for our benefit. We find the beauty and strength in nature, then we feel the need to cut it down for our benefit. Or, at least our supposed benefit. We will rip through mother nature and dig through her to fill our pockets and our homes. We want to bask in the serene of nature and feel it all around us, connected. We feel the forces of nature and yet we still try to push our limits. There will always be an effect from each thing we wipe out, whether big or small. It is almost like a love-hate relationship between humans and nature.
Related Responses
Charles Eisenstein
It's Wrongheaded to Protect Nature with Human-Style Rights
Anna Grear
Finding Our Way Home
Weston Pew


text:
package com.stratio.sparta.plugin.cube.operator.mean

import com.stratio.sparta.sdk.pipeline.aggregation.operator.Operator
import org.apache.spark.sql.Row
import org.apache.spark.sql.types.{IntegerType, StructField, StructType}
import org.junit.runner.RunWith
import org.scalatest.junit.JUnitRunner
import org.scalatest.{Matchers, WordSpec}

@RunWith(classOf[JUnitRunner])
class MeanAssociativeOperatorTest extends WordSpec with Matchers {

  "Mean operator" should {

    val initSchema = StructType(Seq(
      StructField("field1", IntegerType, false),
      StructField("field2", IntegerType, false),
      StructField("field3", IntegerType, false)
    ))

    val initSchemaFail = StructType(Seq(
      StructField("field2", IntegerType, false)
    ))

    "processMap must be " in {
      val inputField = new MeanAssociativeOperator("avg", initSchema, Map())
      inputField.processMap(Row(1, 2)) should be(None)

      val inputFields2 = new MeanAssociativeOperator("avg", initSchemaFail, Map("inputField" -> "field1"))
      inputFields2.processMap(Row(1, 2)) should be(None)

      val inputFields3 = new MeanAssociativeOperator("avg", initSchema, Map("inputField" -> "field1"))
      inputFields3.processMap(Row(1, 2)) should be(Some(1))

      val inputFields4 = new MeanAssociativeOperator("avg", initSchema, Map("inputField" -> "field1"))
      inputFields4.processMap(Row("1", 2)) should be(Some(1))

      val inputFields6 = new MeanAssociativeOperator("avg", initSchema, Map("inputField" -> "field1"))
      inputFields6.processMap(Row(1.5, 2)) should be(Some(1.5))

      val inputFields7 = new MeanAssociativeOperator("avg", initSchema, Map("inputField" -> "field1"))
      inputFields7.processMap(Row(5L, 2)) should be(Some(5L))

      val inputFields8 = new MeanAssociativeOperator("avg", initSchema,
        Map("inputField" -> "field1", "filters" -> "[{\"field\":\"field1\", \"type\": \"<\", \"value\":2}]"))
      inputFields8.processMap(Row(1, 2)) should be(Some(1L))

      val inputFields9 = new MeanAssociativeOperator("avg", initSchema,
        Map("inputField" -> "field1", "filters" -> "[{\"field\":\"field1\", \"type\": \">\", \"value\":\"2\"}]"))
      inputFields9.processMap(Row(1, 2)) should be(None)

      val inputFields10 = new MeanAssociativeOperator("avg", initSchema,
        Map("inputField" -> "field1", "filters" -> {
          "[{\"field\":\"field1\", \"type\": \"<\", \"value\":\"2\"}," +
            "{\"field\":\"field2\", \"type\": \"<\", \"value\":\"2\"}]"
        }))
      inputFields10.processMap(Row(1, 2)) should be(None)
    }

    "processReduce must be " in {
      val inputFields = new MeanAssociativeOperator("avg", initSchema, Map())
      inputFields.processReduce(Seq()) should be(Some(List()))

      val inputFields2 = new MeanAssociativeOperator("avg", initSchema, Map())
      inputFields2.processReduce(Seq(Some(1), Some(1), None)) should be (Some(List(1.0, 1.0)))

      val inputFields3 = new MeanAssociativeOperator("avg", initSchema, Map())
      inputFields3.processReduce(Seq(Some(1), Some(2), Some(3), None)) should be(Some(List(1.0, 2.0, 3.0)))

      val inputFields4 = new MeanAssociativeOperator("avg", initSchema, Map())
      inputFields4.processReduce(Seq(None)) should be(Some(List()))
    }

    "processReduce distinct must be " in {
      val inputFields = new MeanAssociativeOperator("avg", initSchema, Map("distinct" -> "true"))
      inputFields.processReduce(Seq()) should be(Some(List()))

      val inputFields2 = new MeanAssociativeOperator("avg", initSchema, Map("distinct" -> "true"))
      inputFields2.processReduce(Seq(Some(1), Some(1), None)) should be(Some(List(1.0)))

      val inputFields3 = new MeanAssociativeOperator("avg", initSchema, Map("distinct" -> "true"))
      inputFields3.processReduce(Seq(Some(1), Some(3), Some(1), None)) should be(Some(List(1.0, 3.0)))

      val inputFields4 = new MeanAssociativeOperator("avg", initSchema, Map("distinct" -> "true"))
      inputFields4.processReduce(Seq(None)) should be(Some(List()))
    }

    "associative process must be " in {
      val inputFields = new MeanAssociativeOperator("avg", initSchema, Map())
      val resultInput =
        Seq((Operator.OldValuesKey, Some(Map("count" -> 1d, "sum" -> 2d, "mean" -> 2d))), (Operator.NewValuesKey, None))
      inputFields.associativity(resultInput) should be(Some(Map("count" -> 1.0, "sum" -> 2.0, "mean" -> 2.0)))

      val inputFields2 = new MeanAssociativeOperator("avg", initSchema, Map())
      val resultInput2 = Seq((Operator.OldValuesKey, Some(Map("count" -> 1d, "sum" -> 2d, "mean" -> 2d))),
        (Operator.NewValuesKey, Some(Seq(1d))))
      inputFields2.associativity(resultInput2) should be(Some(Map("sum" -> 3.0, "count" -> 2.0, "mean" -> 1.5)))
    }
  }
}

redpajama_set_name: RedPajamaGithub


text:
using AppBrix.Tests;
using Xunit;

namespace AppBrix.Permissions.Tests;

public sealed class CachedPermissionsServiceTests : PermissionsServiceTestsBase
{
    #region Setup and cleanup
    public CachedPermissionsServiceTests()
    {
        this.app.ConfigService.GetPermissionsConfig().EnableCaching = true;
        this.app.Start();
    }
    #endregion

    #region Tests
    [Fact, Trait(TestCategories.Category, TestCategories.Performance)]
    public void TestPerformanceHasPermission()
    {
        var service = this.app.GetPermissionsService();
        service.Allow("a", "p");
        service.AddParent("a", "a1");
        service.Allow("a1", "p1");
        service.AddParent("a", "a2");
        service.Deny("a2", "p1");
        service.Allow("a2", "p2");
        service.AddParent("a2", "a21");
        service.Allow("a21", "p21");
        service.AddParent("a2", "a22");
        service.Allow("a22", "p22");

        TestUtils.AssertPerformance(this.TestPerformanceHasPermissionInternal);
    }

    [Fact, Trait(TestCategories.Category, TestCategories.Performance)]
    public void TestPerformanceAddPermission()
    {
        var service = this.app.GetPermissionsService();
        service.Allow("a", "p");
        service.AddParent("a", "a1");
        service.Allow("a1", "p1");
        service.AddParent("a", "a2");
        service.Deny("a2", "p1");
        service.Allow("a2", "p2");
        service.AddParent("a2", "a21");
        service.Allow("a21", "p21");
        service.AddParent("a2", "a22");
        service.Allow("a22", "p22");

        TestUtils.AssertPerformance(this.TestPerformanceAddPermissionInternal);
    }
    #endregion

    #region Private methods
    private void TestPerformanceHasPermissionInternal()
    {
        var service = this.app.GetPermissionsService();
        for (var i = 0; i < 120000; i++)
        {
            service.HasPermission("a", "p");
            service.HasPermission("a", "p1");
            service.HasPermission("a", "p22");
        }
    }

    private void TestPerformanceAddPermissionInternal()
    {
        var service = this.app.GetPermissionsService();
        for (var i = 0; i < 2000; i++)
        {
            var item = (i % 20).ToString();
            service.Allow("a", item);
            service.Deny("a1", item);
            service.Allow("a22", item);
        }
    }
    #endregion
}


Holly Knitlightly: Peppermint Patty Day!
YUM. I love love LOOOOOVE peppermint patties! And I found an extremely easy recipe to make them -- awesome! (I love tastespotting.com, ha! One search for "peppermint" has me craving SO many different types of dessert I never even knew existed. Ahh... I just bookmarked so many recipes!) I also found a recipe for peppermint patty brownies! Yum! I like brownies (maybe like, half of a piece of a brownie) once in a while (as long as it doesn't have any nuts on it!) but I think if someone offered me one of these I would have a hard time saying no!
Delish! So, today I went out to the farm that my dad's friend works at... I saw a TON of cows, including two newborn twin calves! They were just born on Tuesday, so cute. I also saw a ton of goats (hilarious. And remember my post a little while ago where I mentioned that goats have rectangular pupils? Totally true!) and a pot-bellied pig named... HOLLY. hahaha! Hopefully I'll have some photos to share with you guys tomorrow! And, don't forget what tomorrow is... PANCAKE DAY! Be sure to make some for breakfast!
Yum! I never liked peppermint or the peppermint-chocolate combo when I was growing up, but now I think it's kind of a refreshing flavor. While still being chocolate. Which means it's awesome.
I want to see Holly the pot-bellied pig! Awww. I used to work at a barn for horseback-riding and there was an entire petting zoo of animals; we had a goat named Wilbur, I believe, that was actually leash trained. When one of us didn't have to work we'd take him out on the leash and just walk around. He was so sweet.
Okay, I've been craving pancakes so now I have an excuse! Yay!


This post has been viewed 916 times.
In her book, He Restores My Soul, author Jennifer Kennedy Dean focuses a week of devotions on rejoicing. I've been going over the truths that I highlighted and writing them. I want them to be as real to me as my first name. I want to daily embrace JOY.
Here are 9 truths about joy we can ask God to sew into the fabric of our souls. The quotes are from He Restores My Soul and the rest is me processing it out loud with you.
"True joy is so Christ-centered that earthly success can neither add to it or diminish it." My earthly success may ebb and flow. But Jesus cemented my heavenly success. In God's kingdom, I am clean, and whole. We have access to the Father and His unlimited love, power and resources.
"Joy marks the life of a person whose heart belongs exclusively to the Father." If I lack joy, my heart is clinging to something other than God.
"The joy that Spirit-led Christians experience is the very joy of the indwelling Christ being expressed through their souls." The fruit of the spirit is joy. So, Christ is joy and He is one with God, so God is joy too. He is Immanuel, God who is joy, with me. If my soul is not expressing joy, then my eyes and heart must be fixed on something other than God.
In John 17:13, Jesus said, "Father let My followers be filled to the brim and overflowing with the joy that I possess. I will be in them pouring my own joy in their hearts." (According to Jennifer Kennedy Dean, this is how the verse reads with nuances of the original Greek.) Jesus, who lived in total agreement with His Father's will, prayed that I would be filled and overflowing with joy – His joy. He prayed it for you too.
Jesus asked, therefore, I have it and you do too.
To help me understand this concept, God gave me a vision of the bayou near my mom's house. The bayou often gets cluttered with kudzu vine. This vine takes over, creeping out over the water until even a canoe would have trouble passing through. On a recent visit home, mom pointed out that the neighbors cleared the kudzu and the bayou was once again a beautiful body of water.
When I keep my eyes on things of this earth – what is wrong, what is missing, and the what-ifs, I choke out the river of joy that is waiting to flow through me. When I apply the real truth – the reality of God's kingdom reign in my life, His generous love for me, His abundance to meet all my needs – I the river of joy is free to flow through me.
How do you combat the blues and intentionally pursue the joy of Jesus?
We were created for a world ruled by God. We do not physically live there — yet. So we should expect longings for more. We need to trust that it will come and rely on God's Spirit of perseverance to enable us to wait for that day. Until then, we fight the battle against our sinful natures to be vessels of joy – unhindered by the desires of our flesh.
Can you see yourself there at the river with Jesus? Can you see the river teeming with life? It is packed with the life that resurrects, the life that restores, the life that fills in the gaps for our weaknesses.
God is indestructible. God is joy. So joy is indestructible.
Father, we praise You, the river of life and the indwelling source of our joy. We praise You for the gift of Jesus who gives us free and undeserved access to You through His righteousness.
Please show us Your joy. Please reveal Yourself to us as joyful.
Are there lies from the devil blocking our vision of Your joy and abundant life for us? Please save us from them! Deliver us from the kingdom of darkness into Your light.
We surrender our sadness and desolate places to You in faith that You have so much more for us.
Help us to nail our fleshly desires to the cross. We want to live with our hearts set on You and Your generous affections and provisions for us.
Lead us to lives of joy. Teach us to deny ourselves of anything that stands in our way of reflecting Your joy to those we influence.


Midwest Renewable Energy Association (MREA) is seeking qualified solar installation firms to submit proposals for the design, procurement, and installation of new, residential and small commercial, direct-owned photovoltaic systems at a per-watt price lower than the typical, single solar electric installation.
The group buy is being led by Midwest Renewable Energy Association. The goal of the group buy is to increase solar education and installations in McLean County through a group purchase involving free information sessions and a competitive selection process.
The group buy is offered with the support of the Ecology Action Center (EAC) with high visibility in the area. MREA and EAC will coordinate and deliver a minimum of 20 free, public Solar Power Hour information sessions and market them widely with physical posters, email blasts, paid social media promotion, yard signs, and in the press.
Please define "commercial" participant in the context of this RFP.
In the context of this RFP, the term commercial means any non-residential solar array, including solar arrays for non-profit organizations.
The Ecology Action Center will be presenting Solar Power Hours on MREA's behalf.
The schedule and venue list has not yet been established. We expect to host 20 Solar Power Hours.
Please more specifically define the term "Flush mount systems" in Exhibit C.
The term flush-mounted in Exhibit C refers to roof-mounted PV arrays that are mechanically integrated to minimize diversion from the roof plane.
Please do not submit proposals with pricing exclusively for a specific set of system sizes, i.e. a "one-size-fits-all" or "ready-made" approach. We expect pricing to reflect the custom, site-specific nature of solar installation.
Finally, are the sponsors aware that an IL administrative judge last week decided that co-op & muni utilities will NOT be allowed to participate in the higher-value 15-Year Adjusted Block Program but only the lower-value 1-Year Spot SREC program? While this decision is currently under appeal, are the sponsors planning any adjustments to the RFP or their program goals in light if this decision should it come to stand?
How does MREA want bidders to address any possible mounting and balance of system cost increases that will likely result from a potential steel and aluminum tariff implemented near or after the bid submission deadline?
Any proposed increases will be reviewed by MREA and, if required, the Advisory Committee, if US trade policies or other market forces cause widespread price increases that cannot be quantified at the time of the proposal.


text:
HomeNon-ProfitsCommunity OrganizationsLowell Women's Club Names Woman of the Year, Hands Out $10K in Scholarships
Lowell Women's Club Names Woman of the Year, Hands Out $10K in Scholarships
05/14/2019 Maryalene LaPonsie Community Organizations, Non-Profits 0
The Lowell Women's Club wrapped up its 2018-2019 year with a memorable meeting last week. There was the usual luncheon and pie raffle, but the Wednesday event was also a celebration of the achievements of the club and its members.
In addition to naming a Woman of the Year, the club honored its student members who are all high school seniors. They were given parting gifts and scholarships. The Lowell Women's Club also installed its 2019-2020 leadership team and made plans for the summer break. Special guests included returning student members who shared where life has taken them since leaving the Lowell Women's Club.
Mary McAlary is the 2019 Lowell Woman of the Year
Mary McAlary (l) with her daughters.
The first order of business was to announce the 2019 Lowell Woman of the Year. The honor goes to a woman who has been an active part of the Lowell Women's Club, a committed member of the community and an inspiration to all she meets.
This year, the honor went to Mary McAlary. A member of the Lowell Women's Club since 2009, McAlary can be seen each month in her ruffled apron selling raffle tickets for pies. However, McAlary does much more than dole out sweet treats.
Growing up, she wanted to follow in the footsteps of selfless women such as Clara Barton, Florence Nightingale and Mother Teresa. She became a licensed practical nurse at the Sparrow School of Nursing in Lansing and went on to work in geriatrics. "To nobody's surprise, everybody loved her," noted Diane Sherlock in presenting the Woman of the Year Award.
McAlary would eventually move to the Lowell area where she's volunteered for LowellArts, FROM and the Riverwalk Festival, among other activities. She is a member of her local library board and something of a card shark when it comes to Bridge. Her two daughters were on hand to help her accept the honor of being named the 2019 Lowell Woman of the Year.
"I am shocked," McAlary said in response to the standing ovation she received from club members," but it is such as a privilege to work with all of you."
End-of-the-Year Community Gifts and Scholarships
Student member Halaina Bladey shares her plans for after graduation while sponsor Teresa Hoffman looks on.
Throughout the year, the Lowell Women's Club raises money through a number of fundraisers, from manning a booth at the Fallasburg Arts Festival to selling donuts at the Lowell Expo. The lion's share of that money is set aside for scholarships for student members, but the club also gives $200 gifts to ten community organizations.
Each year, these financial gifts are given to designated organizations such as FROM, Lowell Senior Neighbors and Lowell's Open Table among others. This year, it was decided that two additional gifts would be awarded. As a result, Lowell Girl Scouts and the Kent County Youth Fair will each get $200 from the Lowell Women's Club.
That left $9,750 for scholarships to be shared among the club's nine student members. After graduation, these girls plan to study diverse interests that range from automotive service technology to fashion to special needs physical therapy. To help them pursue their dreams, the Lowell Women's Club gave each student a scholarship that was based on five factors: GPA, community service, Lowell Women's Club participation, college selection and family need.
Jan Thompson is Next Club President
For the 2019-2020 year, a familiar face will be at the helm of the Lowell Women's Club. Jan Thompson was installed as the president for the upcoming year. Thompson has served as president several times in the past and is a previous Woman of the Year recipient.
"We do more for this town that any other organization I've been associated with," Thompson said in her remarks as the new president. Board members will meet with Thompson over the summer to plan the upcoming year.
The next regular meeting of the Lowell Women's Club will be held on September 11, 2019 at 11:45am at the Lowell First Congregational Church. All women of the community are eligible to join the organization.
Lowell Women's Club
Scenes from Lowell: LowellArts Myths – See Us, Hear Us Edition
Lowell Showboat Pieces Available for Purchase
Chris Parks is the 2018 Woman of the Year
Lowell Women's Club Kicks Off New Year in New Location
Jan Thompson is the 2017 Lowell Woman of the Year


text:
Q: is there a function to add a unique id to all users in Firebase Firestore? I have a database (Firebase - Cloud Firestore) with the following structure.
users
     |
     unique id (list of unique ids for each user)

data structure
I would like to assign each user a new field with another unique id that would be used to identify the user. The problem is I don't know-how.
Here are the current fields of each user.
current fields
I've tried to make a function in javascript that would allow me to do it using the Firebase API but to no avail.
async function updateAllUsers(){
   firebase.firestore().collection("users").get()
   .then((users) => {
     users.forEach((user) => {
       writeUserData(user.id)
      // console.log(user.id)
     })
   })

}

async function writeUserData(uid){
  const userRef = firestore.doc(`users/${uid}`);
  const snapShot = await userRef.get();
  console.log(uid) --> we get here
  console.log(snapShot.exists) --> we get here, prints true
  if(snapShot.exits){ --> we do not get here
    const userId = uid
    console.log("true if"); --> we do not get here
    try {
      console.log("we updated the id"); --> we do not get here
      await userRef.update({
        userId,
      });
    } catch (error) {
      console.log("error updating user id", error.message);
    }
  }
}

Here is the console log of the above function working.
console logs
Any help or point to a direction would certainly help.
Here is the documentation that I've looked over but can't seem to find a solution or a point to a good direction.
edit
Typo in code found by @Renaud Tarnec
should be snapShot.exists not snapShot.exits


Microsoft has published a set of some basic tips and tricks for Windows Phone 7 which will help users get used to this new operating system. Check 'em out!
Speed dial: Need to call someone back straight away? From Start, press Phone, then press the Call icon next to an entry in call history.
Skipping letters: In People, press a block letter for a menu that lets you instantly skip to any letter of the alphabet. Perfect for a crowded contact list.
Bulk delete: Do you need to delete multiple emails? Press next to any message in your inbox to reveal a row of check boxes.
Picture this: Turn your phone's screen lock into a portable picture frame. Press Settings > Lock & wallpaper > Change wallpaper, then choose a favourite photo.
In Music + Videos, press the Play icon to randomly play your entire music collection.
Spot editing: Typo troubles? Press and hold a text box until the large cursor appears, then drag it to the problem spot.
Pop-up punctuation: Press and hold the full-stop key to see a pop-up menu with other popular punctuation marks.
Quick fix: Press a misspelled word to see suggestions from the built-in dictionary. Press a suggestion to swap it in.
Press a pin: Press a pin in Maps to see things such as what's nearby and customer reviews for a restaurant or shop.
Facebook inundation: Reduce the number of Facebook friends in your contact list by pressing Settings > Applications > People, then look for the Facebook option.
Press & hold: Do you want to know the real secret to Windows Phone? Press and hold. Use it to expose hidden menus, rearrange Tiles, pin stuff to Start and much more.
More tips, tricks, help and how-to here at Microsoft.
How to Create your own Run Command ?
How Safe is Your Computers ?


text:
Category: Copyright Royalty Board
You are no doubt aware that the Copyright Royalty Judges handed down a final rule adopting the settlement covering streaming mechanicals reached by the major publishers and the richest and most dominant corporations in the history of Planet Earth: Apple, Amazon, Google, Pandora and Spotify. There are many who are dissatisfied with the negotiated rate, no doubt. There are many who are disappointed that the Judges perpetuated the mind-numbing complexity of the royalty calculation methodology (which probably costs more to account on a per-stream basis than the payable royalty).
That's all true, but is a byproduct of the discriminatory practices frozen in time at the CRB, a libertarian hell-scape preserved in amber. As if taking a trip to Jurassic World (or at least 2009) wasn't bad enough, the Judges refused even to place a toe onto the arc of the moral universe as they just did in the Subpart B rate setting in the same proceeding (i.e., the Phonorecords IV rates that abandoned the frozen mechanical and adopted an annual cost of living adjustment for physical and permanent download configurations).
I discuss this in more detail in a post on MusicTechPolicy in which I question whether a hidebound adoption of rates that fail to apply a COLA equally and treat likes alike in the same proceeding is lawful, much less good policy. While the Judges focus on giving the negotiating parties, aka the rich people, what they want and ignore the notorious unfairness of the Copyright Royalty Board whose rulings apply to all songwriters in the world who ever lived or may ever live regardless of representation, I argue that applying the same COLA calculation to streaming as to Subpart B configurations solves the problem. This post will lay out a simple method of implementing a COLA for streaming.
The policy goal would be to apply the COLA formula to streaming. Because the streaming formula is so unduly complex, it's easy to understand the resistance to adding still another step. Remember that the greater than/lesser of monthly calculation is a series of steps that gets to a per-play rate of sorts. All of the greater of/lesser than calculations have been fought and salivated over by dozens of lawyers (literally) so changing any one of them is probably not productive and in my mind is not necessary to give effect to the COLA. Remember that in the history of the government's mechanical rate, the COLA was applied to a rate as an uplift, not as a way to calculate a rate. The point of a COLA is always to preserve the value of the government's rate and recognizes that the songwriter will not have a chance to revisit the rate for five year tranches and a lot can happen in five years.
The easiest way to apply a COLA to streaming is to derive the per-play rate given the current formula and then uplift it with a COLA. The Judges already have a COLA based on CPI-U . The Judges need only apply the COLA as a legal modification to the streaming mechanical and accept the base line rates in the negotiated settlement. Otherwise, the exact same songs with the exact same songwriters for the exact same recording in the exact same proceeding will have a COLA when exploited by record companies and none when exploited by the rich people. This result just seems arbitrary. The labels having shown the way to a fair result should be followed by the DSPs.
We raised this approach in a Phonorecords IV comment I filed for David Lowery, Helienne Lindvall and Blake Morgan:
Applying the COLA to Section 115 may actually have a simple solution. The Judges already have a COLA formula. That formula can simply be applied as a step (5) in 37 CFR §385.21(b). This way the negotiated settlement terms are not re- opened.
Adding a COLA uplift to the applicable royalty calculation is simple. First, determine the applicable payable royalty for the accounting period concerned under the negotiated rates. Then apply the COLA formula derived by the Judges as an uplift to the payable royalties as a last step in the royalty calculation. The COLA could be calculated either annually or monthly although monthly seems more appropriate and accurate.
The uplifted amount (after any uplifted overtime adjustment to plays) would then be reflected on the applicable Copyright Owner's royalty statement as the payable royalty for that accounting period.
This seems like a simple solution that brings the streaming mechanical out of Jurassic World and into the Era of the Songwriter.
By Chris Castlein Copyright Office, Copyright Royalty Board, Phonorecords IV January 2, 2023 758 WordsLeave a comment
Emmanuel Legrand prepared an excellent and important study for the European Grouping of Societies of Authors and Composers (GESAC) that identifies crucial effects of streaming on culture, creatives and especially songwriters. The study highlights the cultural effects of streaming on the European markets, but it would be easy to extend these harms globally as Emmanuel observes.
For example, consider the core pitch of streaming services that started long ago with the commercial Napster 2.0 pitch of "Own Nothing, Have Everything". This call-to-serfdom slogan may sound good but having infinite shelf space with no cutouts or localized offering creates its own cultural imperative. And that's even if you accept the premise the algorithmically programed enterprise playlists on streaming services should not be subject to the same cultural protections for performers and songwriters as broadcast radio–its main competitor.
[This] massive availability of content on [streaming] platforms is overshadowed by the fact that these services are under no positive obligations to ensure visibility and discoverability of more diverse repertoires, particularly European works….[plus] the initial individual subscription fee of 9.99 (in Euros, US dollars, or British pound) set in 2006, has never increased, despite the exponential growth in the quality, amount of songs, and user-friendliness of music streaming services.
Artists working new recordings, especially in a language other than English, are forced to fight for "shelf space" and "mindshare"–that is, recognition–against every recording ever released. While this was always true theoretically; you never had that same fight the same way at Tower Records.
This is not theoretically true on streaming platforms–it is actually true because these tens of millions of historical recordings are the competition on streaming services. When you look at the global 100 charts for streaming services, almost all of the titles are in English and are largely Anglo-American releases. Yes, we know–Bad Bunny. But this year's exception proves the rule.
And then Emmanuel notes that it is the back room algorithms–the terribly modern version of the $50 handshake–that support various payola schemes:
The use of algorithms, as well as bottleneck represented by the most popular playlists, exacerbates this. Furthermore, long-standing flaws in the operations of music streaming platforms, such as "streaming fraud", "ghost/fake artists", "payola schemes", "royalty free content" and other coercive practices [not to mention YouTube withholding access to Content ID] worsen the impact on many professional creators….
This report suggests solutions to bring greater transparency in the use of algorithms and invites stakeholders to undertake a review of the economic models of streaming services and evaluate how they currently affect cultural diversity which should be promoted in its various forms — music genres, languages, origin of performers and songwriters, in particular through policy actions.
MTS readers will recall my extensive dives into the hyperefficient market share distribution of streaming royalties known as the "big pool" compared to my "ethical pool" proposal and the "user centric" alternative. As Emmanuel points out, the big pool royalty model belies a cultural imperative–if you are counting streams on a market share basis that results in the rich getting richer based on "stream share" that same stream share almost guarantees that Anglo American repertoire will dominate in every market the big streamers operate.
Emmanuel uses French-Canadian repertoire as an example (a subject I know a fair amount about since I performed and recorded with many vedettes before Quebecoise was cool).
A lot of research has been made in Canada with regards to discoverability, in particular in the context of French-Canadian music, which is subject to quotas for over the air broadcasters which however do not apply to music streaming services. The research shows that while the lists of new releases from Québec studied are present in a large proportion on streaming platforms, they are "not very visible and very little recommended."
It further shows that the situation is even worse when it is not about new releases, including hit music, when the presence of titles "drops radically." It is not very difficult to imagine that if we were to swap Québec in the above sentence with the name of any country from the European Union [or any non-Anglo American country], and even with music from the European Union as a whole, we could find similar results.
In other words, there may be aggregators with repertoire in languages other than English that deliver tracks to streamers in their countries, but–absent localized airplay rules–a Spotify user might never know the tracks were there unless the user already knew about the recording, artist or songwriter. (Speaking of Canada, check the MAPL system.)
This is a prime example of why Professor Feijoo and I proposed streaming remuneration in our WIPO study to allow performers to capture the uncompensated capital markets value to the enterprise driven by these performers. Because of the market share royalty system, revenues and royalties do not compensate all performers, particularly regional or non-featured performers (i.e., session players and singers) who essentially get zero compensation for streaming.
Emmanuel also comments on the imbalance in song royalty payments and invites a re-look at how the streaming system biases against songwriters. I would encourage everyone to stop thinking of a pie to be shared or that Johnny has more apples–when the services refuse to raise prices in order to tell a growth story to Wall Street or The City, measuring royalties by a share of some mythical royalty pie is not ever going to get it done. It will just perpetuate a discriminatory system that fails to value the very people on whose backs it was built be they songwriters or session players.
We must think outside the pie.
By Chris Castlein Copyright Royalty Board, Digital Services: Amazon, Digital Services: Apple Music, Digital Services: Facebook, Digital Services: Google, Digital Services: Pandora, Digital Services: Spotify, Digital Services: YouTube, Streaming vs Physical October 6, 2022 October 7, 2022 934 WordsLeave a comment
All Economic Indicators Are Flashing Red at the Copyright Royalty Board on Frozen Mechanicals
All of the economic indicators are telling us that inflation is going to be around for a while–so songwriters should expect some cost of living adjustment based on the Consumer Price Index when the Copyright Royalty Board sets mechanical royalty rates, especially for the frozen mechanical rate on physical phonorecords. Why do I say that?
The U.S. Consumer Price Index closed 2021 at 7%. That is the highest inflation level since 1982–and remember in 1982 the U.S. had already had a solid two to three years of Federal Reserve Chairman Paul Volker's anti-inflationary surge after the malaise of the 1970s.
The Producer Price Index for 2021 was measured at 9.7% by the Bureau of Labor Statistics, the largest calendar year increase since 2010. The PPI is a leading indicator of inflation as measured by the CPI because it measures a large basket of raw inputs and future price increases that will affect the CPI in weeks or months.
The University of Michigan survey of consumer sentiment fell to 68.8%, its second lowest level in a decade (the lowest being in November 2021). The survey also measured "confidence in government economic policies is at its lowest level since 2014." The consumer sentiment survey indicates that consumers expect bad times ahead, or at least expensive times. This can have a pronounced effect on consumer inflation expectations.
Consumer inflation expectations remained unchanged after rising strongly over the last year, particularly the one-year outlook. Inflation expectations can be a self-fulfilling driver of inflation for a number of reasons such as FOMO pricing on homes and cars as well as wages–if you expect inflation to rise x% in the next 12 months, today you will seek wage increases of at least x% (if not more).
All of this tells us that the entire idea of extending the freeze on statutory mechanical royalties gets more absurd by the day. It's entirely reasonable to "index" statutory mechanical royalties during the current rate setting period of 2023-2027 as we'll all be very lucky to get through that period without suffering crippling inflation that will further erode the 2006 rates the CRB has used for the past 15 years.
By Chris Castlein Copyright Office, Copyright Royalty Board, Frozen Mechanicals January 18, 2022 January 18, 2022 350 WordsLeave a comment
Real Mechanical Rates Have Declined with Inflation Increases Due to #FrozenMechanicals
If you follow economics, you probably have heard the expressions "real wages" or "nominal wages" or "real" versus "nominal" wages. This isn't a Cartesian metaphysical discussion–it's about the effect of inflation on what they tell you you're getting paid. Nowhere is this truer than with the statutory mechanical royalty rate. The rate will inevitably decline over time due to the rot and decay of inflation. Inflation is like having a cavity in your tooth that you don't fix. It doesn't go away. It may not hurt yet but it's going to.
The effects of inflation are hardly a secret. Because of the effect of inflation on interest rates set by the Federal Reserve (who is charged with keeping inflation under control), vast numbers of people around the world keep watch on U.S. inflation rates as well as inflation rates in other countries.
US Inflation Rate Over Past 5 Years
For example, an hourly worker might be paid $12 an hour by her employer. That's her "nominal wage" or "money wage." But the issue is not what the worker is told they are getting paid, it's what the worker can buy with her wages. What her nominal wage buys her is her "real wage" or her nominal wage adjusted by inflation during the same time period. Real wages are always less than nominal wages. This is why workers commonly get annual cost of living adjustments to nominal wages that increase their nominal wages based on inflation in addition to nominal performance-based increases. The same is true of entitlement payments like Social Security which just announced its biggest inflation adjustment in many years.
This is particularly important when understanding nominal and real statutory mechanical rates set by the government's Copyright Royalty Board every five years. With a nominal wage (as opposed to a government rate freeze like a price control), there are a number of different countermeasures you can take in response to a wage freeze and take quickly. You can always try to negotiate a higher hourly or annual wage if you are falling short of inflation. You can also try to quit and find another job that pays more money. Perhaps even get an annual raise built into your salary.
However, with the statutory mechanical royalty, there is no escape. Songwriters are at the mercy of both the government (in the form of the Copyright Royalty Board) and the people who are supposed to be negotiating for them who seem to have decided that millions of songwriters don't need a cost of living adjustment. Without "indexing" the statutory mechanical to inflation (meaning a CRB ruling requiring automatic cost of living increases based on increases of inflation), songwriters' buying power actually decreases over time. That's the difference between the nominal mechanical royalty and the real rate, i.e., the inflation adjusted rate.
Nowhere is this more apparent than with the "frozen mechanical" that you've probably heard a lot about if you're a regular reader. It's called "frozen" because the rate for physical and vinyl was set by the CRB in 2006 and has not been raised since–apparently at the request or acquiescence of those negotiating in the songwriters' interest. Think about that–remember what happened in 2008 (just a couple years after the rate was frozen)? The Great Recession aka The Big Short.
It may not be obvious to you but most of the laws in the US are not passed in Congress and they are not signed by the President. The overwhelming majority of these laws are created by administrative agencies, often located in the Executive Branch, but not always. When it comes to songwriters there is a federal agency that has almost total control over certain aspects of your life.
That agency is the Copyright Royalty Board which has three "judges" that are appointed by the Librarian of Congress (therefore are in the Legislative Branch of government along with Congress). While these members of the Copyright Royalty Board are styled "judges" they are not "all purpose" judges appointed by the President and confirmed by the Senate (under Article III of the Constitution for those reading along at home). (This CRB appointment issue is a matter of some debate but we will talk about the appointment issue some other time (attention Justice Kavanaugh).)
Whether you know it or not or like it or not you have delegated your personal agency to the CRB and you have also delegated your agency to the people who can afford to appear before the CRB. This is the classic case of the merger of the little intellectual elite in a far-distant capitol who think they can plan your life better than you can. If you have no idea about the CRB, there's an easy answer–you're very unlikely to ever wander into a CRB hearing because the hearings take place in the Library of Congress which is not someplace that songwriters typically are found. Even so, you have delegated your authority whether you know it or not and whether you like it or not to certain representatives of the music publishing community who act on your behalf and probably without your direct authorization. There's plenty of blame to go around. To paraphrase Lord Byron, if you want a friend in Washington get a dog. Preferably a big one with teeth.
Here's an example. According to government data, 9.1¢ in 2006 is worth approximately 13¢ today, or approximately a 33% inflation rate. That means that the frozen 9.1¢ rate in 2006 has the buying power of approximately 6¢ in 2021. In other words, the real mechanical rate has actually declined although the nominal rate has stayed the same. Why? Because like King Canute commanding the ocean, the nominal rate was not increased to at least stay even with inflation and inflation rotted it from the inside out.
So you can see that when you're considering the mechanical rate that is set every five years by Copyright Royalty Board, the rate that matters is the real rate. However, the CRB only set a nominal rate for songwriters in 2006 even though they could have increased that nominal rate based on increases in the consumer price index. They could also have increased the rate in Phonorecords II or Phonorecords III but did not.
And now 15 years later, the frozen mechanicals crisis has been engaged by a revolt of the songwriters in Phonorecords IV, currently before the CRB. The struggle is all about real vs. nominal mechanical rates.
By Chris Castlein Copyright Office, Copyright Royalty Board, Frozen Mechanicals November 29, 2021 November 29, 2021 1,073 Words1 Comment
Evidence Mounts for Inflation Indexing for Songwriters
No one needs to be told that inflation is on the rise. We all see the evidence everywhere we go: gasoline prices, groceries, rent, health care, you name it. Inflation may not have increased prices to the point that large numbers of consumers are substituting away from particular goods because they can't afford to buy, but it's getting there.
This is important for songwriters who are paid on a statutory rate set by the government's Copyright Royalty Board that tries to approximate what a willing songwriter would charge a willing music user in five year tranches. It is this five year bet that causes heartburn–one solution that the CRB recently applied to webcasting is to index their government royalty to inflation so that the royalty actually retains its value and increases as inflation increases, called "indexing".
For whatever reason, the rates for physical configurations and downloads has not contain inflation indexing since it was put in place in 2006 and still does not in the current proposed settlement. Songwriters across the board are resisting this and demanding indexing as part of the "frozen mechanicals" debate as part of the current Copyright Royalty Board rate setting proceeding (styled as "Phonorecords IV").
Unfortunately for all of us, a statistic released today suggests that inflation continues apace. The Personal Consumption Expenditures Price Index prepared by the U.S. Bureau of Economic Analysis continued its upward trend indicating that consumers are spending more which suggests inflation is the reason not an increase in wealth. As Trading Economics summarizes:
Personal spending in the US increased 0.6% mom in September, following an upwardly revised 1% rise in August and above market forecasts of 0.5%. Spending on health care, food services and accommodations, foods and beverages, pharmaceutical products and gasoline offset lower sales of motor vehicles. Personal income on the other hand fell 1%, the first decline in 4 months and much more than expectations of a 0.2% drop.
Even if you don't go as far as Twitter CEO Jack Dorsey's assessment that "hyperinflation" is coming soon, it's pretty easy to see that if the Copyright Royalty Judges fail to add indexing to the mechanical rate (frozen or not) as they had so many times in the past, songwriters will find their government royalty eaten away by inflation. ("Hyperinflation" is a rise in prices of 50% a month.)
It's also becoming clear that inflationary pressures will continue well into 2022 and 2023–the rate set in Phonorecords IV is theoretically to begin in 2022.
Indexing is crucial.
By Chris Castlein Copyright Office, Copyright Royalty Board, Frozen Mechanicals October 29, 2021 October 29, 2021 409 WordsLeave a comment


text:
celine
======

ray tracer written in clojure


text:
Go to navigation | Skip to content
Meet Randy Foreman '17
When Randy Foreman '17 thinks about his Calvin experience, two intersecting themes emerge: opportunity and challenge.
With each passing semester, Randy says he's moved a little closer toward understanding himself and the beautiful, yet broken, world in which we live.
"It's been difficult and eye-opening," says Randy, a religion major with a minor in ministry leadership. "Each semester, each year, brought more and more of this eye opening for me."
An important part of his journey: confronting stereotypes and learning to reach toward peace. "Being a black man has really influenced my experience here," he says. "It really forced me to look at myself and realize, when I look in the mirror, I see one thing, but when other people look at me, it might be something different they're seeing. And how can I love the me that I see in the mirror while taking into account that it may not be exactly what other people are seeing?"
He says he came to a realization: "I've been released from that stress of worrying about what other people are thinking. Part of that really comes from a security in Jesus and the way he's made me."
Randy's mentor
One person Randy says has been a big part of his growth is Austin Brown, resident director of Boer-Bennink Hall.
"She has played a great role in the development that I've been going through as a black man on campus," he says. "I've never really had a role model who is a person of color who has worked to help me navigate the hardships of being a minority in a majority culture in college.
"She's really helped me to look at the different behaviors that I have made habitual and question me, but also to encourage me and say, 'You know you don't have to do that,' or 'You know you can do that. This part of the world is open to you, too; this aspect of faith is open to you, too.'
"She's been incredibly helpful and just worked to show me that there's so much more to life and to faith than I had realized," he says.
Randy's advice
Based on his own experience, Randy offers this advice to incoming students: "Do something uncomfortable often," he says. "It is—especially for majority students—easy to only put yourself in situations and environments where you don't need to feel deeply or look out on the world or work to empathize."
He thinks Calvin is a place where that empathy can grow. "I would most certainly encourage anyone to come here, because there are a lot of opportunities to learn about people who are unlike you."
Find a mentor at Calvin
Learn more about Randy's dorm
RANDY'S CALVIN EXPERIENCE
• Barnabas Team—Served as the spiritual facilitator for students in my dorm
• Resident Assistant—Helped students in my dorm navigate college life
• Jubilee Fellow—Gained real-world ministry experience
• Off Campus Programs—Traveled to Kenya and Uganda during the 2015 interim
WHY HE CHOSE CALVIN
• Thriving faith community
• Small student body, so I knew I wouldn't feel lost in the crowd
• Competitive soccer team
• Perfect driving distance from home (three hours from Evanston, Ill.)
• During my first visit, a moving chapel service filled me with deep confidence that this was the place for me.
VERGE: spring 2016
How you spend your time in college is probably going to look a little different from how you spent it in high school (goodbye study hall!) Check out these schedules from real freshmen to get a feel for how your day might look at Calvin.
Rachel House »
Minor:
Peterborough, Canada and Lithia, Florida
Eliezer Yeong »
Chiang Mai, Thailand; Toronto, Canada
Kurt Delos-Trino »
We'd like to introduce to some pretty cool people. They're doing some pretty great things, both at Calvin and beyond.
Professor Faculty Profile: Roman Williams »
Professor Debra Bossenbroek & Suzan Couzens, nursing »
Professor Professor Larry Louters, chemistry »
When you choose Calvin, you choose Grand Rapids, too. Thankfully, GR is the kind of place you won't mind spending four years, with more new restaurants, shops and events opening all the time!
There's 4 Years of FUN Here
There's 4 Years of INTERNSHIPS Here
Majors + Programs
Scholarships + Aid
Admissions & Financial Aid Office
VERGE – the edge, rim or margin; the brink. A place where you're finally able to see everything ahead of you.


This page provides information and resources on the use of animals in research, to be considered when applying for funding from BBSRC.
Whilst we endeavour to keep this page 'live' and up-to-date, please be aware that legislation and guidance does change and it is your responsibly to ensure you are compliant with this.
Our grants guide provides detailed information on how to approach the use of animals in research in your application and where to include this information in Je-S.
These two NC3Rs resources are available on the('Template-Link-Basic', getFileLink(filename='links/nc3rs-peer-review-and-advice-service'))[/MURA] hub that also contains background information on the review process and tips for applicants whose proposal will be reviewed by the NC3Rs.
If the research involves the use of specific animals (rodents; rabbits; sheep; goats; pigs; cattle; Xenopus) overseas rather than in the UK, please also complete the Additional questions that can be found at NC3RS: Use of animals overseas The completed forms are required to be attached as a letter of support in Je-S.
Details are provided to indicate where the animal research will take place and through which funder the resources are being sought.
Please note, these additional documents are not required for applications that only involve animal research being carried out in the UK.
Further information on animal use can be found on our Animals in bioscience research page.


text:
US woman who killed teen biker Harry Dunn wouldn't face prosecution in America, lawyer claims
By Sharon Braithwaite and Jonny Hallam, CNN
Updated 2:37 PM ET, Tue March 9, 2021
Harry Dunn was killed in 2019.
(CNN) Anne Sacoolas, the American woman who fled the UK after killing motorcyclist Harry Dunn in a traffic accident in 2019, is willing to do community service in the US and "make a contribution" in the teenager's memory her lawyer said Tuesday.
But Sacoolas is still refusing to return to the UK to face prosecution and her lawyer Amy Jeffress is now arguing that her client would not be criminally prosecuted in the US for a similar accident.
Sacoolas admits she was driving on the wrong side of the road when she hit Dunn in August 2019.
But Jeffress argued that would not be enough for prosecution in the United States.
"This kind of an accident had it occurred in the United States would not be prosecuted criminally. So in the United States these cases are only prosecuted where there is evidence of recklessness that rises to the level of close to intent, so drunk driving, distracted driving or a hit-and-run situation or excessive speeding. But there was none of that here," Jeffress told BBC Radio.
CNN Legal Analyst Paul Callan disputed the lawyer's assertion.
UK announces deal to change diplomatic immunity rules after Harry Dunn death
"I do not believe that attorney Amy Jeffress statement accurately describes US law. Driving on the wrong side of the road and killing someone in the process could be a criminal offense in the United States," Callan, a former New York City homicide prosecutor, told CNN Tuesday.
"In recent years, a number of US states have enacted criminal statutes referring to 'vehicular homicide.' These statutes make it possible to prosecute for negligent driving in particularly egregious circumstances. Driving on the wrong side of the road might fit that category under some of the statutes," Callan said.
Sacoolas has been charged in the UK with causing 19-year-old Dunn's death by dangerous driving, but the US State Department has refused a UK request to extradite her.
"We have actually been making efforts to resolve this case, short of her return. We understand that community service is a typical sentence for offenses like this, and we have offered ever since, over a year ago now, that she would be willing to serve that kind of a sentence and to make a contribution in Harry's memory, to take other steps to try to bring some peace to the family," Jeffress added.
Dunn's mother, Charlotte Charles, rejected the offer.
"I made a promise to Harry the night he died that I would get him justice. There are no circumstances in which I am going to break that promise. You do not get to kill someone and walk away. This campaign has been all about accountability and ensuring that no one is above the law," she said Tuesday in a statement.
Robert Buckland, the UK's Secretary of State for Justice, told BBC Radio's Today program that the current situation had resulted in justice being denied.
"The current situation is a denial of justice. Rather than talking about the sentence that would be appropriate, let's actually deal with the question of liability first," he said Tuesday.
Case against American woman accused of killing a UK teenager can go ahead in the US, judge rules
"It is good to see Mrs. Jeffress, who I respect enormously, finally reaching out to the British public," Dunn family spokesman Radd Seiger said Tuesday in a statement.
"However, I would encourage her to enter into dialogue with the Crown Prosecution Service in order to ensure that Mrs. Sacoolas faces the UK justice system. It is not for either of us to try this case in public. We have one of the fairest legal systems in the world and it is vitally important that justice is not only done for Harry, but be seen to be done."
Seiger added: "Mrs. Sacoolas must give a full account of what happened under oath in Court and the matter must then be left in the hands of the judge and jury."


Jumbo Playing Cards are just like normal playing cards only bigger.
They are popular for both older people and small children for their size.
These jumbo cards are plastic coated and they are 12.5cm x 9cm.


Number 28 Burnside Road is on the ground floor of a modern development in Dyce.
It offers two bedrooms, not to mention a stylish and modern interior.
You'll be eager to show off the trendy lounge which is always bright thanks to the floor to ceiling windows, while neutral decor makes the room seem even bigger.
Whether you're unwinding after a day at work or hosting friends, this room is the perfect blend of relaxation and style.
You're not limited on where to host your guests however, thanks to the fabulous dining kitchen.
Custom built and designed with a monochrome theme, there is extensive work unit space and plenty of storage.
There is ample room for dining furniture meaning you can chat to friends as you cook, and integrated appliances mean there's no excuse not to put together a tasty spread.
The master bedroom goes further to demonstrate the high standard of living on offer.
A statement pendant lightshade and simple decor complement the room – there is no need for distraction when quality is on offer.
The second bedroom is also bright and of a good size, perfect for guests to stay the night.
Completing the accommodation is the main bathroom which has been fitted to a high standard with a white three-piece suite.
There are no worries about getting parked as the apartment has its own parking space with plenty of extra spaces for visitors.
Dyce is about six miles north of Aberdeen city centre and is conveniently placed for access to the airport and several business parks.
The area also offers a host of other amenities including shops, bars and schools while transport links to the city are good with both train and bus services nearby.
Number 28 Burnside Road is available to lease on a furnished basis from around £650 per month.
Contact Aberdein Considine on 01224 723737.


text:
Romney, Bain & Abortion
It is difficult to know how the story about Bain Capital's investments in Stericycle will turn out. Stericycle is a company that deals with medical waste which, in an Orwellian twist, is understood to include the remains of children who have been aborted. Bain invested $75 million in the company in 1999 but when the issue was raised earlier this year, the company stated that Mr. Romney had left to rescue the Olympics by the time the investment was made. New documents unearthed by Mother Jones indicate that Mr. Romney's involvement with Bain continued for some time. This is important not only because of the issue of Stericycle, but because calculations of outsourced jobs at companies Bain purchased are affected too.
Yet, at the website LifeNews, which monitors all issues related to the pro-life cause, they are playing the denial game on behalf of Gov. Romney. They do not rebut the charge so much as ignore it.
Two things are interesting here. First, LifeNews does not raise the most obvious defense of Mr. Romney's alleged involvement in a company that profits directly from its participation in the abortion industry, namely, that in 1999 Mr. Romney was still proudly pro-choice. To me, this is exculpatory: If you believe that Mr. Romney's conversion to the pro-life cause was sincere, you have no business challenging his actions before his conversion. Of course, Mr. Romney signed a health care overhaul AFTER his "conversion," that explicitly provided for taxpayer funded abortion, something President Obama did not do, but the right has swallowed this fact too.
The other interesting thing is what this tells us about the nature of venture capitalists. Let's not kid ourselves. If Krugerrands were still a viable investment, and still controlled by an apartheid government, we should not be surprised if Bain threw some money that way. Nor should we be surprised that the particular form of vulture capitalism practised by Bain guaranteed that they got their money, even if they had to shutter factories, lay-off thousands, export jobs not products, etc. The world of high finance is an amoral and immoral world. But, no one among the apologists for capitalism within the Christian and Catholic right want to talk about that.
What to do about Pakistan?
Of Blinders and Binders
LGBT Groups: "Utterly Betrayed"?
The Dems Debate in New Hampshire
Anti-immigrant is pro-life?


text:
Q: Python Pandas GroupBy and Size - Read Values Sorry all I'm new to this. Hopefully my question is ok.
I'm trying to use pandas to work with the output of a SQL query.
This is my code:
data = pandas.read_sql(sql_query, cnxn)

alarmcount = data.groupby(['Module', 'Attribute']).size()
print(alarmcount)

The print statement shows the following, which is perfect and exactly what I want.
Module      Attribute
TEST_ALM    ALARM1       23
            ALARM2        9
TEST_ALM_1  ALARM1       17
TEST_ALM_2  ALARM1       13

But, for the life of me I cannot figure out how to read the data of all three of these columns into my code as strings and integers so I can further process them as required?
I've been at it for a while and have partial success.
The two print statements below:
print(alarmcount.tolist())
print(type(alarmcount))

The tolist() function returns the last column which is great, but I still cannot access the data from the first two columns as strings.
[23, 9, 17, 13]
<class 'pandas.core.series.Series'>

A: After groupby.size output is Series with MultiIndex.
One idea is create DataFrame by Series.reset_index and select by columns:
 df = data.groupby(['Module', 'Attribute']).size().reset_index(name='vals')

 print (df['Vals'].tolist())
 print (df['Module'].tolist())

Or if need select level in MultiIndex use Index.get_level_values:
alarmcount = data.groupby(['Module', 'Attribute']).size()

print(alarmcount.index.get_level_values('Module').tolist())


text:
Germany joins ELIXIR - News blog
News blog/
Germany joins ELIXIR
About this News blog About this News blog
This news blog provides news about the e-IRG and related e-Infrastructure topics.
News Blog News Blog
Published Date 30/08/16 15:36
Germany has become the latest country to join ELIXIR, following the ratification of the ELIXIR Consortium Agreement by the Federal Ministry for Education and Research (BMBF).
By joining ELIXIR, the BMBF will increase the visibility and competitiveness of German research. Moreover, Germany will be able to take part and contribute to ELIXIR's governance and operations. "Better exploitation of Big Data in the life sciences is essential in strengthening our health system for the future. We can speed up the development of new medicines and treatments for diseases by improving the smart integration of data from biomedical research", stated Federal Research Minister, Professor Johanna Wanka.
The ELIXIR Node in Germany will be run by de.NBI, the German Network for Bioinformatics Infrastructure, which has been established to coordinate bioinformatics service provision across Germany. It brings together expertise and resources through dedicated service centres in areas such as microbes, integrative bioinformatics, data management, crop bioinformatics, human genomics and proteomics. de.NBI is coordinated from Bielefeld University and includes over twenty partner institutes across Germany.
In 2015, ELIXIR and de.NBI agreed a joint collaboration strategy to lead towards full Membership in ELIXIR and work together on topics of common interest including training, ontologies and service registries. ELIXIR will now work closely with de.NBI to ensure Germany is fully integrated into its activities and connected effectively to other ELIXIR Nodes.
Dr. Niklas Blomberg, Director of ELIXIR stated: "I am thrilled that Germany can now join its national bioinformatics infrastructure with the developments taking place in other European countries through ELIXIR. Germany has a strong and well known bioinformatics research tradition and through de.NBI it will play an important role in shaping the international standards and research practices that data-intensive life science now needs. I see German Membership of ELIXIR as a way of facilitating this and look forward to deepening the collaboration with de.NBI in the coming years."
Professor Alfred Pühler, Coordinator of de.NBI, stated: "I am delighted that Germany has become a Member of ELIXIR. This allows us to build on initial collaboration between de.NBI and ELIXIR in the area of registries and expand it to other areas of interest for Germany such as training, research clouds, proteomics, crop sciences and industrial biotechnology."
ELIXIR's Membership now stands at 20 - 19 European countries and EMBL as an intergovernmental organisation. Germany is the fifth country to join ELIXIR in 2016, following Italy, Slovenia, Ireland and Luxembourg.
By Leslie Versweyveld
5391 Views,


Did you misplace your keys at home? Did your car key break when you were trying to start your car?Are you planning on re-keying the locks in your office because of missing important documents?It's really a tad traumatic once you are aware that your own home or company is not safe by any means.Fortunately, our firm that provides locksmith services in Brisbane, CA exists to assist you with your home, small business and car lock-out among relevant locking mechanism problems Round the clock, Seven days a week, in a year. Night time, weekends and holiday break assistance are given without having extra fees. We certainly have proficient fully bonded, trained and licensed support technicians which may perform the job prompt and effectively.
Call on our company whenever you are in a pinch and have the assistance of an efficient locksmith as soon as possible. Any problem you may be experiencing, even if it just involves being locked out of a house, an office or a car, we will come to assist you. Rain or shine, we are ready to come and offer our services.
Twenty-four hours a day, you can rely on our help. Our residential services include the re-keying of locks, duplicating keys, and the installation, replacement and repair of locks. Whenever you have some problems with your automobiles, we can provide fixes such as repairing or installing car keys, programming transponder keys, precision key cutting, lockout services and duplicating car keys. In addition to those stated above, we offer commercial services like card access control devices, change and re-key installation of security cylinder, keyless entry devices, CCTV installation and electronic keypad.
In order to fix your problem concerning your locks and keys can easily be resolved by giving us a call, just dial (888) 907-2215. Waiting has no room for you, experience exceptionally good services in just one phone call.Whether you are at home, office or in the middle of nowhere, we can arrive at your location anytime.So you should never be helpless as we are always available to save you from lock and key difficulty. Do not think twice calling our company.