text:
Cancer Screenings, Diagnoses Plunge in First COVID Surge
In one of the first studies to examine the impact of the COVID-19 pandemic on cancer diagnoses, researchers at Dana-Farber/Brigham and Women's Cancer Center document a substantial decline in cancer and precancer diagnoses at the Northeast's largest health care system during the first peak of the pandemic because of a drop in the number of cancer screening tests performed.
The findings, which confirm concerns that COVID-related restrictions may have delayed the detection and treatment of many cancers, were moderated somewhat by data showing that cancer screenings and diagnoses at the healthcare system largely rebounded to pre-pandemic levels in the months following the initial peak. The study, published online by JAMA Oncology, provides added impetus for people who missed or postponed a cancer screening test early in the ptandemic to contact their healthcare provider to discuss the potential need to re-schedule one, the study authors say.
"It's widely thought that fewer people were screened for cancer and precancerous lesions during the first surge of the pandemic, because of limitations on non-urgent medical procedures, restrictions on patient volume, and patients' concerns about the spread of the virus and the need for social distancing," says Ziad Bakouny, MD, MSc, of Dana-Farber Cancer Institute, a co-first author of the study. "For this study, we wanted to document the extent of this decline, and its impact on cancer diagnoses, at a major U.S. health care system."
The investigators drew on a registry of patient data at Massachusetts General Brigham, a system of hospitals, community health centers, and physician practices in Massachusetts. They tracked how many people underwent cancer screening tests – mammograms, colonoscopies, Papanicolaou ("Pap") tests for cervical cancer, prostate-specific antigen (PSA) tests, and low-dose computer tomography (CT) – and how many were diagnosed with cancer. The data covered four three-month periods: March 2 to June 2, 2020, the first peak of the pandemic; the previous three months; the subsequent three months; and the same three months in 2019.
The statistics reveal a significant decline in cancer screening during the peak period. A total of 15,453 patients underwent screening exams in the March-June time frame, compared to 64,269 in the previous three months and 60,344 in the same three months of 2019. Encouragingly, screening levels largely recovered in the three-month post-peak period, to 51,944.
The decrease in screening tests was accompanied by decreases in diagnoses of the cancers detected by those tests. The researchers calculated that had the same number of people been screened during the peak period as in the previous three months, approximately 1,925 additional cancers and precancerous growths would have been diagnosed.
The falloff in diagnoses, though temporary, is a source of concern because cancers detected at an early stage are often easier to treat than those that aren't discovered until they've had time to grow and spread, Bakouny remarks. "It's reassuring, though, to see that in the three-month post-peak period, the number of screening tests and diagnoses resulting from those tests returned to a near-normal level."
Another silver lining is that researchers might have expected the decrease in diagnoses to be higher than the 1,925 their analysis estimated. They found that the percentage of screening tests resulting in a cancer or precancer diagnosis was higher during the height of the pandemic than at other times. This may be because, at a time of limited screening availability, physicians recommended screening primarily for patients at highest risk of having cancer.
"This investigation is especially timely given that we are currently dealing with a second, and potentially worse wave of the pandemic," says co-senior author Quoc-Dien Trinh, MD, of Brigham and Women's Hospital (BWH). "We have learned to leverage a redesigned patient flow, increased use of telehealth, and made other accommodations to allow our patients to continue receiving standard of care cancer screening and diagnosis in the safest possible environment."
While the study focused on a single, large health care system in one part of the country, emerging data suggests its findings have relevance for other regions as well, Bakouny remarks.
The co-first authors of the study with Bakouny are Andrew Schmidt, MD, of Dana-Farber and Marco Paciotti, MD, of BWH and Humanitas Clinical and Research Center IRCCS, Rozzano, Italy. The co-senior author with Trinh is Toni K. Choueiri, MD, of Dana-Farber and BWH. Co-author is Stuart Lipsitz, ScD, of BWH.
Study Finds Lung Cancer Screening Drops, Malignancy Rates Rise During Spring COVID-19 Surge
The current surge in coronavirus disease 2019 (COVID-19) cases...
New Research Shows Effects of COVID-19 on Breast Cancer Screening, Treatment
During the COVID-19 pandemic, many countries paused their breast...
Screening mammography reduces risk of breast cancer death in 10 years by 60%
Diagnosing breast cancer in its earliest stages makes curative...
Improving screening mammography: Perspective of a community radiologist
The United States Preventative Services Task Force (USPSTF)...
Cancer Screenings, Diagnoses Plunge in First COVID Surge. Appl Radiol.
By News Release| January 14, 2021
Categories: Section|Imaging Modalities|Digital Portals


Little Bangkok has vast menu of Thai dishes from curries to crab rangoon, served in an airy, colorful space. They are conveniently located at 603 N Campbell Station Rd, Knoxville. Stop by and dine today!
This is a Little Bangkok public information page.


CFG File Extension – What is wesnoth markup language file?
Cfg file extension has Wesnoth Markup Language file type, developed by The Battle for Wesnoth, which is associated with the "game files" category.
Commonly used by The Battle for Wesnoth, the file stores source code, which has been written in the Wesnoth Markup Language (WML). Users can easily edit CFG files via a text editor.


Sometimes a Hasmonee soldier chooses to follow the path of learning divineinformation, instead of intensive field duty he chooses to become an Abir meaning knight or brave one. The defense forces have a special program to facilitate their needs. They will become much more learned and later can upgrade to an Abir gadol (grand brave), which practices the Abir-Qesheth warrior tradition professionally.
Special Notes: This unit can detoxicate adjacent allied units, including itself, at the beginning of a turn. It inspires the ivrim units around him, making them protect the civilian weak, old, women, children of the people and the eco-environment of the land with a saintly zeal. It is weaker than leadership.


One of the greatest coaches of all time, John Wooden, passed away this past year and it was great to see the number of people who came forward to honor him. The impact this man had on the lives of players, coaches, and the public was very evident in the numerous memorials they played in the days following his passing.
The first year I started coaching I was introduced to John Wooden by a mentor of mine. Since that first book I read I've fallen in love with the philosophy and wisdom that he shared with us. Never in my wildest dreams would I have the opportunity to sit down with a legendary coach like John Wooden and pick his brain, and this is the value of reading. We get to know the inner thoughts and mentality of great men and women throughout history.
The nuggets of wisdom found in this book are incredible, and timeless. Even though Coach Wooden was a basketball coach there is so much that we can take away from him and apply to our profession. This book was such an easy read too. It's set up with several short chapters covering the entire life lessons that he collected along the way. It can be used as a resource or an opportunity to get to know the inner workings of a great leader. It would take too much time for me to cover all of the great things in this book, but I definitely thought it would be worth while to mentione some key things that I've lived to adapt to my own life.
Probably best known for his Pyramid of Success John Wooden's whole concept was built on preparation. When asked what he missed most about coaching it was never the 10 NCAA National Championships, or the 88 consecutive wins, but Coach Wooden was regularly quoted saying he missed the practices and the players. The preparation, the journey, is what he missed most, not the outcome of that preparation. If his team did their best to prepare for the opponent that week they were focusing on the factors that they could control. No one can control outside factors like the other team, officials, or the environment at the arena. His teams put their energy focusing on the parts of the game they could control; their preparation, attention to detail, and their intensity.
This is a philosophy I've tried to teach my teams and instill into them. Players who have confidence in their preparation play the game with less stress and enjoy the competition. A great principle to take away from this great coach.
I encourage everyone to read this book, it's a great resource for any coach, or person who wants to succeed at life. Would love to hear things you've applied in your coaching philosophy that you've learned from John Wooden.


Assist in gathering KPI, statistics and others analysis reports for the management.
Participate in monthly sales reports and assist in forecasting and budgeting.
Generate business data and statistical reports for relevant department.
Prepare letters and reports for the top management and circulate copies to designated personnel and external parties when needed.
Responsible for financial planning, analytical and management reports.
Arranging and organizing with the director and other top managements for any functions and events.
Minimum Diploma in Business Administration or equivalent.
At least 2-3 years of relevant experience in preparing reports.
Meticulous, attentive to details, careful with numbers and statistical reports.
Good team player / able to work independently in the fast paced environment.
Candidates who communicate in Japanese will be an added advantage.


Okay I was reading my Nursing assistant text book and found these definations...and of course my odd brain started working and I read more into the definations than my text book said..so here is the text book definations.. and what I would call the "common" usage of them. *grin* Enjoy!
This other handsome male is Spitfire. He grew to be 12lb in size and was a very onery, yet lovable cat. Together Spitfire and Uncle Bear ruled the house. I will be devoting an entire page to U.Bear, Spitfire, and the rest of the gang later, but for now I will just add these fellows to my main page.


text:
News/Noticias
California Bishops' Statements
Public Policy Insights
Because We Are Catholic
Reverence For Life
Caring for Survivors of Crime
Aiding the Incarcerated
Restorative Justice in Schools
Chaplaincy Information and Support
Faith In The Public Square
Care for Our Common Home
CST Reflections
Participation in Public Life
Parish Advocacy Guide
Español FAQ
End of Life Teaching
Catholic Household Blessings
Resources and Surveys
Protecting Our Children
California Missions / Saint Junipero Serra
Officers, Staff and Location
Diocesan Contacts
Catechetical Ministry Directors
Catholic Schools Superintendents
Communication Directors
Respect Life Directors
Restorative Justice Directors
Social Action Directors
Map of California Dioceses
Tweets by @CACatholicConf
COVID-19 State Policy Update 07.17.20
Today, Friday, July 17, 2020, Governor Newsom provided an update on the COVID-19 pandemic and addressed one of the most important issues—opening schools. He began by noting there are more than 1,000 individual school districts in California and within those districts, there are 6.5 million students and 625,000 educators and support staff. The Governor stated there are foundational principles that guide the decisions regarding whether and when schools open. The Guidance for Schools is published on the Department of Public Health website (read more here). Governor Newsom went through the principles using a PowerPoint presentation—the content of his presentation is spelled out in a news release addressing the opening of schools (read more here).
He began this part of the presentation noting, "Learning is non-negotiable. Schools must provide meaningful instruction during the pandemic whether they are physically open or closed. Students, parents, teachers, and staff prefer in-classroom instruction, but only if it can be done safely, which is determined by the local public health data." The Governor has stated on numerous occasions that all decisions are based on the science and data.
Pandemic Plan for Schools
Safe in-person school based on local health data.
Schools may open if they have not been on the Monitoring List or when they have been off of the Monitoring List for 14 consecutive days.
Schools that do not meet this requirement, must begin the academic year with distance learning.
Masks are required to all staff, educators, and students grade three and above.
For students in grades K-2, masks or face shields are strongly encouraged. The Governor noted younger children are sometimes intimidated and recoil when they are faced with adults wearing masks, as he has also witnessed this in his youngest child.
Staff must maintain 6' distance between each other and with students.
School must begin each day with symptom checks, including temperature.
School must have hand washing stations.
School must conduct sanitization and disinfection.
School must have and follow quarantine protocols.
Staff must be tested regularly.
Contact tracing will be used to help mitigate the spread of the virus using isolation and quarantine. The state's contact tracing workforce of 10,000 will be used to assist with this task.
Schools must address equity and digital divide issues.
Access to devices and connectivity for all students.
Daily live interaction with teachers and other students.
Must provide challenging assignments equivalent to in-person classes.
Adapt lessons for English learners and special education student needs. This also applies to helping homeless students and those in the Foster Care system.
Physical distancing and other adaptations.
Regular testing of educators and staff, and dedicated contact tracing.
Rigorous distance learning.
The Governor noted there is $5.3 billion dollars in the state budget to fund special education needs and for schools to purchase technology and improve connectivity. Closing the digital divide and provide equity in technology for all students is a priority for the funding, as well as addressing learning loss, which most experts have noted is significant (from the sudden shutdown earlier this year). These needs, the Governor noted are the minimum requirements.
"Everyone should strive to do more. We know in-class learning is more effective; however, it may not be possible, given the circumstances we find ourselves in at this moment."
When Should a Class, School or District Move to Distance Learning?
Schools should consult with their local public health official first.
A classroom cohort goes home when there is a confirmed COVID-19 case.
A school should go home when multiple cohorts are positive or more than 5% of the school population tests positive for COVID-19.
A district should have students go home if 25% of their schools are closed within a 14-day period.
The Governor noted that the California Department of Public Health and the California Department of Education have issued guidance for schools. It must be acknowledged that schools, as is the case with counties, are all different depending on where they are located in the state. Some may experience the need to move from in-class learning to distance-learning, if their case numbers grow; however, it is possible that a neighboring district in another county is experiencing a few cases and can therefore continue with in-person learning.
The Governor reiterated many experts, including Linda Darling-Hammond, Professor of Education Emeritus from Stanford University and Chair of the State Board of Education, and Dr. Mark Ghaly, Secretary of Health and Human Services, have had input in designing the guidance for schools during this challenging time. One of the key points in their work is recognizing the differences around the stat that allows some schools to open with in-class learning, while some other schools may not be able to start with in-class, in-person learning.
He told the audience a lot has been done to support the education system, including issuing two months of PPE to the schools, including face shields in various sizes. Putting more money in the state budget to help improve distance learning, closing the digital divide, and improving connectivity. He reminded the audience large companies, such as Google, Amazon, and Verizon have made significant contributions to improve connectivity and close the digital divide by getting 70,000 tablets to students in need. The California Public Utilities Commission (CPUC) is doing targeted mapping where connectivity is not optimal and provided $25 million to help improve connectivity by cutting the cost in half.
Governor Newsom closed his presentation by updating the COVID-19 data and reminding the audience, that he understands how much everyone wants children to be in the classroom to learn, but stated, "the only people who can really have an impact on that desire, are the teachers, staff, parents, and community—and that is by wearing a mask, washing hands often, disinfecting surfaces, and avoiding mixing with people outside of your immediate family. The single most important non-pharmaceutical thing you can do to help get students back in the classroom is to practice behaviors that limit the spread of the virus and that starts with wearing a mask. If everyone wore a mask, within weeks we will see the curve bend back downward. We have the power to help small businesses stay in business and get students back in the classroom by simply wearing a mask."
He closed by reminding everyone to read the guidance for schools, which is published on the California Department of Public Health website (read more here).
The first three questions from the media focused on whether the Governor believed the schools are ready to open, as early as August 17, given the fact that 32 counties are on the state Monitoring list. And whether the Governor believed students would receive a high-quality education if they are forced to spend most of the school year in a distance learning environment. The Governor noted that while the schools were thrown into distance learning with little notice (last March) and thought it might only be for two weeks, they did their best to accommodate student learning needs, given the situation. Now, he noted they have had time to prepare for these situations with a number of resources, including training for online and distance learning. He also reminded the reporter of the $5.3 billion in the budget to help address other needs and concerns.
The next questions focused on whether there is enough support for parents, especially those with children on the autism spectrum who have reported there are not enough resources and in the distance learning environment these students regress significantly. The Governor asked Linda Darling-Hammond to address these questions. Dr. Darling-Hammond told the audience a lot has been done to support educators and help them prepare for a range of student needs. She described how Zoom could be used for small group activities and even one-one-one interactions with students, if needed.
The next two questions focused on the Trump administration and the President's declaration that he will cut funding to states that do not open their schools for in-person learning and if the economy had opened more slowly in May, is it possible schools might be in a better position to open for in-person learning? The Governor responded that he will not play coulda, woulda, shoulda, or speculate on what might have happened under other circumstances. Nor would he politicize this issue. The focus is on providing a safe environment for students to learn—if that can be achieved, the schools may open for in-person learning. Every decision is based on current conditions and data.
The final question was about the guidance developed for schools and the requirements the Governor presented today—the reporter asked if these are recommendations or requirements, and do they apply to both public and private schools and what about universities and community colleges? The Governor responded that they are working with the UC and CSUs regarding requirements and guidance for their institutions. Yes, he noted, the guidance and instructions he provided today apply to both private and public schools and with their adoption by the Legislature, they are a mandate and must be followed.
The Governor closed his press conference by once again reminding everyone to do the right thing and wear a mask, wash their hands often, and avoid over-mixing with other people.
Current State Orders
As of today, July 17, there are 32 counties on the state's Monitoring List. As a consequence of the increasing positivity rate, the hospitalization and ICU
increases, new conditions were released on July 13. (read more here).
Restaurants, wineries and tasting rooms (find guidance docs here). Restaurants and eateries are encouraged to expand their outdoor operations (read more here).
Places of worship, (read more here).
Zoos and museums, (read more here).
Family entertainment centers, such as bowling, theaters, and video game centers, (read more here).
Card rooms, (read more here).
All bars, brewpubs, breweries and pubs must shutdown—no indoor or outdoor operations (read more here).
This order applies to ALL counties, not only those on the Monitoring List. State officials are encouraging these sectors to develop and expand outdoor activity, as that is allowed under the order if the facility is able to maintain appropriate physical distancing, masks are required, and appropriate sanitization steps are taken, as required in the published guidelines for each sector. Below under Navigating the COVID-19 Site, you will find links to updated guidance for each sector.
New orders for counties on the Monitoring List
For the 32 counties on the Monitoring list, the following sectors must close all indoor and outdoor operations, while the county is on the Monitoring List.
Fitness Centers and gyms (read more here)
Worship services (read more here)
Offices for non-critical staff (read more here)
Personal services, including salons, barber shops, and nail salons (read more here)
Indoor protests
Indoor shopping malls (read more here)
The Latest on the Monitoring List
After three consecutive days on the Monitoring List, counties are subject to the new order (for at least three weeks), which includes ceasing all indoor dining in restaurants, closing bars, and no alcoholic beverages may be sold without an accompanying meal (read more about monitored counties here); (find the Monitoring List here).
Wildfire evacuation protocols
New protocols and plans to keep fire crews and the public safe from COVID-19 during wildfire season and community evacuations (Read more here).
Navigating the COVID-19 Dashboard
The Governor is encouraging Californians to follow their county's progress via the State's Dashboard, which provides COVID-19 data updates daily (find statewide and county data here). Once in a Dashboard report, you may click on individual counties (on the right column) to see county-specific testing and outcome data or hospitalization rates in each county (click here for case statistics); (click herefor hospitalization and ICU data).
Key milestones – COVID-19 numbers – as of today (7.17.20)
The Governor noted the most important measures of the trajectory of the virus are the Positivity rate and the 7-day average; in some cases, only the 14-day average is available.
7,475 deaths, up by 130 overnight or +1.8%; 14-day total 1,212 up 19.4%
366,164 positive cases - up by 9,986 or +2.8%; 14-day total 117,929 up by 47.5%.
The state's positivity rate continues to increase; the 7-day positivity rate is 7.1%; the 14-day positivity rate is also 7.4%.
6,044,099 tests conducted; 1-day total 128,159; 14-day up 1,595,923 or 35.9%.
Latinos continue to have the highest percentage of positive cases at 55%; Caucasians 18%; Asians 6%, and Blacks 4%.
Hospitalizations for COVID positive is 6,808 down by 31 or 0.5%; 14-day rolling average is 6,266. Suspected patients with COVID-19 is 1,642, up by 56 or + 3.5%; 14-day rolling average is 1,549.
The majority of hospitalizations are in LA County 2,188; followed by Orange County 682; San Bernardino 600; Riverside 535; San Diego 388; Kern 245; Fresno 242; Stanislaus 200; San Joaquin 193; Sacramento 185; Alameda 164; Santa Clara 147; Ventura 104.
ICU – COVID positive patients in ICU is 1,941 up by 44 or 2.3%; the 14-day rolling average is 1,800. Number of suspected COVID-19 in ICU is 212 down by 11 or 4.9%. Available beds statewide is 3,802.
Governor Focuses on Schools During State Update
Today, Friday, August 14, 2020, Governor Newsom provided a live update on the COVID-19 pandemic. The Governor focused on education and preparing schools for distance learning and in-person learning, once it is safe to do so.
Bishops Join Legal Action to Prevent States from Taking CARES Act Funding from Non-Public School Students
The California Catholic Conference of Bishops has joined an amicus brief in a case aimed at ensuring that funding earmarked for non-public schools in the CARES Act be used by the states to help all students impacted by the COVID-19 pandemic. California and other states have sought to withhold most funding from non-public schools.
Renewing our Commitment to Catholic Elementary and Secondary Schools in the Third Millenium, (Copyright 2005, United States Conference of Catholic Bishops, Inc.)
National Catholic Education Association (NCEA) website
The California Association of Private School Organizations (CAPSO) has information of interest to California's private school parents, students and teachers.
Information about Catholic colleges in the United States is available from the National Catholic College Admission Assocation. The site contains information for prospective students, parents and high school counselors.
1119 K Street 2nd Floor, Sacramento, CA 95814
916 313-4000 leginfo@cacatholic.org
Archdiocese

redpajama_set_name: RedPajamaCommonCrawl


text:
URS is fast and cheap, but…
by Andrew Allemann — March 31, 2017 Policy & Law 2 Comments
You might not win if the respondent puts up a fight.
On the face of it, it seems that the Uniform Rapid Suspension (URS) system was tailor made for cases like this: virgin-atlantic.cloud.
But that doesn't mean you can just phone it in.
A National Arbitration Forum panelist has ruled against Virgin Enterprises in its URS against this domain name.
The registrant says he registered the domain "to publish an English translation of a novel that he is planning to write, titled "vergine atlantica" which would be about trafficking of virgins to the new world."
Hmm. On a .cloud domain?
Here's what panelist Richard W. Hill wrote about the issue of bad faith:
Complainant alleges that, bearing in mind the reputation of its VIRGIN brand, and the fact that Respondent asked it to bid for the domain name when it approached Respondent, it is difficult to find reason to believe that the domain was registered for any reason other than to sell it to Complainant for an amount in excess of out of pocket costs.
Complainant does not provide any evidence to support this allegation. Respondent denies the allegation. The Examiner finds that Complainant has failed to satisfy its burden of providing clear and convincing evidence.
Similarly, the Examiner finds that Complainant has failed to satisfy its burden of providing clear and convincing evidence to support its allegations to the effect that Respondent registered the domain name primarily for the purpose of disrupting the business of a competitor (as required by URS Procedure 1.2.6.3.c), or that Respondent has engaged in a pattern of registering domain names in order to prevent the trademark holder or service mark from reflecting the mark in a corresponding domain name (as required by URS Procedure 1.2.6.3.b).
Complainant alleges that Respondent, by using the registered domain name, has intentionally attempted to attract increased traffic to the web site which the domain resolves to, and that Respondent is profiting from this.
But Complainant provides evidence to show that the registered domain name is not being used, and Respondent states that the registered domain name is not being used. Consequently, the Examiner finds that Respondent has not intentionally attempted to attract, for commercial gain, Internet users to his web site.
Complainant cites previous URS determinations in its favor. But those previous determinations must be distinguished from the present case. In case no. FA1507001627578 Respondent did not explain for what purpose he has registered a domain name equivalent to the Complainant's mark, whereas Respondent has provided an explanation in the present case. In cases nos. FA1603001667148 and FA1608001691854 there was no Response, whereas there was a Response in the present case.
There are two takeaways:
1. Don't make a boilerplate assertion that isn't true. Virgin stated that the the respondent was trying to attract traffic to the domain's website, but even it submitted evidence showing it's not in use.
2. Just responding to a URS is a great first step.
Virgin can always escalate this to a UDRP.
IBM wins first new top level domain URS case
Uniform Rapid Suspension by the numbers
URS Panelist: "Complainant's business may be worldwide but it is not out of this world"
2 Comments Tags: National Arbitration Forum, uniform rapid suspension
JohnUK says
LOL, I love it, BUT unless the Complainant/Panelist can reach inside the brain of the Registrant how can they prove otherwise ?.They can't. Anyway he better get writing his book.
Russ Smith says
It seem Richard Hill didn't like my explanations…
https://forum.icann.org/lists/comments-igo-ingo-crp-access-initial-20jan17/msg00027.html


text:
Q: How to materialize data in spark I have the following method which needs to return me a transformed dataframe. df.sparkSession.sql("SELECT * FROM X") returns empty DF. How do I materialize data of df8 so that unpersist doesn't remove all the previous data from dataframes? I am not using Hive so can't use .saveTableAs.
def doSomething(df: DataFrame): DataFrame ={
val df1: DataFrame = method1(df).persist(StorageLevel.MEMORY_AND_DISK)

val df2: DataFrame = method2(df1, df)

val df3: DataFrame =
  method3(df2).persist(StorageLevel.MEMORY_AND_DISK)

 val df4 = method4(df2,
   df3)

val df5: DataFrame = method5(df4)
  .persist(StorageLevel.MEMORY_AND_DISK)

val df6: DataFrame = method6(df4,
  df5)

val df7: DataFrame = method7(df6)
  .persist(StorageLevel.MEMORY_AND_DISK)

val df8: DataFrame = method8(df6,
 df7)

df1.unpersist()
df3.unpersist()
df5.unpersist()
df7.unpersist()

 df8.createOrReplaceTempView("X")
df.sparkSession.sql("SELECT * FROM X")
}

redpajama_set_name: RedPajamaStackExchange


The Susan B. Anthony Lecture is the keynote to SBAI's annual International Graduate Student Research Conference. This year the keynote will feature Tavia Nyong'o, Professor of African American Studies, American Studies, and Theater Studies at Yale University.
Code-switching has historically been central to African-American culture. In the wake of the post-racial era (an idea recently disavowed by President Obama in his farewell address) what is the future of code-switching and double-consciousness as oppositional performative strategies? The recent phenomena of Black Twitter (and more generally, of digitally-encoded assemblages of intersectional black feminism) has been countered by the rise of an anti-Black Twitter, which has claimed many targets for harassment and helped elect a president. Is online activism fated to be drowned out by this "white noise"? Or will code-switching be reinvented for a digitally networked and increasingly post-literate age? This talk will investigate these questions in dialogue with recent queer and black feminist theories of hacking, coding, and entanglement.


text:
The Explorer is a one-of-a-kind search engine that showcases profitable climate solutions from all over the world which are part of an ever-growing, curated, and publicly-accessible database. Select your profile, your needs and climate goals to discover the solutions that fit best with your situation.
Explore Learn more
The Solutions Explorer lets you shortlist your favorite solutions in Project(s) you've created. You can create multiple projects.
Your Project will show up here.
Sign in to create project and save solutions.
Save to project
Your Search Alerts
The Solutions Explorer lets you create alerts that match your needs. You can create several alerts and you will receive a notification each time a new Solar Impulse Efficient Solutions is labeled and matches your filters.
Your Search Alerts will show up here.
Sign in to create alerts for your filters and search terms.
Save Search Alerts
Contact the Solution's Provider
You can contact each Solution's Provider through the « Solutions Explorer » contact form. The team will also follow up to make sure you'll have an answer to your request.
Your contact form will show up here.
Sign in to contact the Solution's Provider
Industry & Consumer Goods
Manufacturing and construction processes
AirShaper
Online platform to optimize the aerodynamics of 3d models
AirShaper provides an automated online platform to analyze & optimize the aerodynamics of products & vehicles.
AirShaper is an online tool for optimizing the aerodynamics of products & vehicles. It can be used to reduce fuel consumption of vehicles, increase the range of UAVs, increase the performance of sporting equipment and reduce wind loads on solar panels. It aims at solving the typical barriers encountered with aerodynamics simulations. Indeed, to operate this Solution no expert knowledge is required, no capex cost are needed for hardware or software. AirShaper is a cloud Solution which delivers results in a matter of days, not weeks. Lastly, the price is fixed per simulation and has no monthly fees.
BusinessManufacturingAutomotives & Road Vehicles
Label Date April 2020
By AirShaper
From Belgium
Maturity stage Small scale commercialization
Looking For Strengthen visibility/communications; Partnerships; New clients
Sectors - Value chain - Application
Design, Power & Produce
Package & Distribute
Use & Efficiency
Valorize & Restore
Value Chain Steps
The environmental benefits
•Cut CO2 emissions by reducing aerodynamic drag of ground, water & air vehicles
•Assess & optimize wind loads on & performance of renewable energy systems
•Fully automated workflow capable of working with any 3D model
•Making a coach bus 20% more efficient will cut fuel consumption by 10%.
•A single optimized truck can reduce its C02 emissions as much as 15 tons per year.
The Financial benefits
•Vehicles: a 20% cut in aerodynamic drag results in roughly a 15% reduction in fuel consumption for road vehicles
•Renewable energy: reducing wind loads increases the number of suitable/profitable locations for solar and mapping wind patterns helps to optimize wind energy performance
Activity Region
Andorra, Albania, Austria, Åland, Bosnia and Herzegovina, Belgium, Bulgaria, Belarus, Switzerland, Czechia, Germany, Denmark, Estonia, Spain, Finland, Faroe Islands, France, United Kingdom, Guernsey, Gibraltar, Greece, Croatia, Hungary, Ireland, Isle of Man, Iceland, Italy, Jersey, Liechtenstein, Lithuania, Luxembourg, Latvia, Monaco, Republic of Moldova, Montenegro, Republic of Macedonia, Malta, Netherlands, Norway, Poland, Portugal, Romania, Serbia, Russia, Sweden, Slovenia, Svalbard and Jan Mayen, Slovakia, San Marino, Ukraine, Vatican City, Kosovo,
United Arab Emirates, Afghanistan, Armenia, Azerbaijan, Bangladesh, Bahrain, Brunei Darussalam, Bhutan, China (Mainland), Cyprus, Georgia, Hong Kong SAR, Indonesia, Israel, India, Iraq, Iran, Jordan, Japan, Kyrgyzstan, Cambodia, North Korea, South Korea, Kuwait, Kazakhstan, Laos, Lebanon, Sri Lanka, Myanmar [Burma], Mongolia, Macao SAR, Maldives, Malaysia, Nepal, Oman, Philippines, Pakistan, State of Palestine, Qatar, Saudi Arabia, Singapore, Syria, Thailand, Tajikistan, East Timor, Turkmenistan, Turkey, Taiwan, Uzbekistan, Vietnam, Yemen,
Angola, Burkina Faso, Burundi, Benin, Botswana, Democratic Republic of the Congo, Central African Republic, Republic of the Congo, Ivory Coast, Cameroon, Cape Verde, Djibouti, Algeria, Egypt, Western Sahara, Eritrea, Ethiopia, Gabon, Ghana, Gambia, Guinea, Equatorial Guinea, Guinea-Bissau, British Indian Ocean Territory, Kenya, Comoros, Liberia, Lesotho, Libya, Morocco, Madagascar, Mali, Mauritania, Mauritius, Malawi, Mozambique, Namibia, Niger, Nigeria, R̩union, Rwanda, Seychelles, Sudan, Saint Helena, Sierra Leone, Senegal, Somalia, South Sudan, Ṣo Tom̩ and Pr?_ncipe, Swaziland, Chad, French Southern Territories, Togo, Tunisia, Tanzania, Uganda, Mayotte, South Africa, Zambia, Zimbabwe,
Antigua and Barbuda, Anguilla, Aruba, Barbados, Saint Barth̩lemy, Bermuda, Bonaire, Sint Eustatius and Saba, Bahamas, Belize, Canada, Costa Rica, Cuba, Curacao, Dominica, Dominican Republic, Grenada, Greenland, Guadeloupe, Guatemala, Honduras, Haiti, Jamaica, Saint Kitts and Nevis, Cayman Islands, Saint Lucia, Saint Martin, Martinique, Montserrat, Mexico, Nicaragua, Panama, Saint Pierre and Miquelon, Puerto Rico, El Salvador, Sint Maarten, Turks and Caicos Islands, Trinidad and Tobago, United States, Saint Vincent and the Grenadines, British Virgin Islands, U.S. Virgin Islands,
Argentina, Bolivia, Brazil, Bouvet Island, Chile, Colombia, Ecuador, Falkland Islands, French Guiana, South Georgia and the South Sandwich Islands, Guyana, Peru, Paraguay, Suriname, Uruguay, Venezuela,
American Samoa, Australia, Cocos [Keeling] Islands, Cook Islands, Christmas Island, Fiji, Micronesia, Guam, Heard Island and McDonald Islands, Kiribati, Marshall Islands, Northern Mariana Islands, New Caledonia, Norfolk Island, Nauru, Niue, New Zealand, French Polynesia, Papua New Guinea, Pitcairn Islands, Palau, Solomon Islands, Tokelau, Tonga, Tuvalu, U.S. Minor Outlying Islands, Vanuatu, Wallis and Futuna, Samoa,
AirShaper is a Belgian startup offering automated online aerodynamics simulations.
Headquarters 2000 Antwerp, Belgium
Complementary solutions
Claranor
Pulsed light packaging sterilization equipment for bioindustries
A machine to chemically recycle plastic waste back into oil
Aluminium recycling system
An aluminium melting and recycling furnace powered by renewable biomass briquettes
Nexelia
Iron melting by supersonic oxygen injection into shaft furnaces for the metal industry
Contact the Solution Provider Save to Project
The information set out above, is solely for the purposes of information and the Solar Impulse Foundation does not provide any guarantee as to its authenticity, completeness or accuracy. This information does not constitute investment advice or a recommendation to buy into, transact or to enter into any agreement with any of the parties or persons mentioned above. Potential investors or interested parties are solely responsible for their investment or business decisions and for performing any due diligence required by the circumstances.


text:
Fossils We Want to Find
There's a list of fossils I'd really like you to go out and find. Good luck.
By Darren Naish on July 21, 2017
Credit: Darren Naish
We're all used to the idea that amazing fossil discoveries – sometimes wholly unexpected and totally out of left field – are found on a regular basis, and if anything's clear about the fossil record it's that a hell of a lot of stuff remains to be discovered. If we think about the fossils that will be discovered in the future, many will be completely new. But others will be better examples of known species, or will represent the sort of species that we've actually already predicted to exist. In this article I'm going to provide a 'wish list' of fossils that I'd really like to see discovered. If any of them do exist or are findable, they're going to be very rare, and indeed some are so rare – because they represent animals that were surely geologically short-lived or unlikely to have ever been preserved – that they may well never be discovered. But what the hell.
Caveats: seeing as this blog is called Tetrapod Zoology, the fossils are all tetrapods. Furthermore, my wish list is populated by creatures specific to my own idiosyncratic interests and other workers would surely come up with a very different one. This whole line of discussion was inspired by a question posed by a colleague; so thanks to him for providing the inspiration. It might be fun for other bloggers to come up with similar lists of their own, or discuss their own 'wish list' fossils in the comments section (he says, optimistically).
A cladogram of stem-mammals: the enormous tetrapod group known properly as Synapsida. Credit: Darren Naish
An early synapsid with extensive soft tissue preservation. At the risk of seeming like someone obsessed with soft tissues and life appearance (read on and you'll get what I'm saying), high on my list is the discovery of an early synapsid – a stem-mammal – that provides us with good information on integument. It looks likely at the moment that hair, whiskers and so on evolved in cynodonts prior to the origin of mammals (or mammaliaforms if you prefer), but were these features present any earlier than this? Did gorgonopsians and dicynodonts and so on possess whiskers or body hairs? Did these animals have a smooth skin with sebaceous glands? Or were they still scaly?
I added fur to my Dinogorgon illustration - because surely fossil integument will reveal it to be so, right? Err, maybe not. Homage to Bakker and Paul. Credit: Darren Naish
Yes, there are supposed to be a few fossils that help answer these questions (that oft-mentioned patch of skin of Estemmenosuchus, for example), but they're not sufficiently satisfying. A nice fossil – an articulated dinocephalian or anomodont perhaps, with extensive, well preserved areas of skin and associated tissue (throw in pigment traces and musculature too) – would make many palaeontologists very happy.
A little pterosaur in amber. The idea that we might discover intact Mesozoic animals preserved in amber once seemed like a pipe dream. But no more: we now have large numbers of Cretaceous lizards in amber, a partial tail from a small non-bird theropod, and assorted archaic birds, including the better part of a baby enantiornithine.
Jeholopterus: a Chinese anurognathid pterosaur with pycnofibers, wing membranes and other soft tissues preserved. Nice. Now imagine a version preserved in amber. Credit: Elgin et al. Wikimedia (CC BY 2.0)
But there's so much more that we need, and high on my list is a tiny pterosaur (thrush-sized or smaller) either representing a very small adult or a juvenile of one of the bigger species. Thanks to fossils that come from places of exceptional preservation (like Liaoning Province in China and Karatau in Kazakhstan), we already have a reasonable handle on the life appearance of small pterosaurs (Unwin & Bakhurina 1994, Kellner et al. 2009, Witton 2013). BUT they're always squashed flat and ambiguous on various of the details. A complete, 3D little pterosaur in amber would give us a far better understanding of whatever's going in with integument (the distribution of ramphotheca, pycnofibers and scales, if present), the precise form and anatomy of the wing membranes, and such things as nostril and ear position and size.
The mummified face of a non-bird dinosaur. As you'll know, debate continues over the facial soft tissues of Mesozoic dinosaurs: this is one of the things dinosaur specialists talk about the most… sauropodomorphs, theropods and ornithischians all remain the subject of extensive argument, disagreement and uncertainty. How extensive was beak tissue in those taxa that had it? What's the deal with 'lips', 'cheeks' and other extra-oral tissues around the jaw margins? How exposed were the teeth, if at all? Were structures similar to the facial receptors of modern crocodylians present in some groups? Were there whiskers, filaments or other integumentary structures on the snout and elsewhere?
A griffon vulture was entombed in an Italian pyroclastic deposit, and is preserved as a space in the block. Iurino et al. (2014) scanned the block and were able to reconstruct the animal in 3D. There is, in principle, no reason why the same couldn't happen with a Mesozoic animal preserved in the same way. Credit: Iurino et al. 2014
As is clear from recent publications relevant to this issue (Hieronymus et al. 2009, Barker et al. 2017, Carr et al. 2017), we likely aren't going to get unambiguous answers on these issues from skeletal fossils alone. I put it that we either need an immaculate, mummified face (Stephen and Sylvia Czerkas said similar things back in 1990, specifically in connection with information on the sauropod nasal region), or the complete impression of a face, preserved in a substrate like fine-grained volcanic ash. The idea that such a thing might one day be discovered is not beyond the realms of possibility. I say this not only because we have Mesozoic dinosaur fossils that come from deposits where fine-grained volcanic ash surrounds their remains but also because we know of cases from recent history where animals have left impressions of their soft tissues preserved in the same way (Iurino et al. 2014). This idea is not original to me: I took it from my colleague Andrea Cau who blogged about it here.
Everybody wants more Therizinosaurus. The longest of those unguals ('claw bones') are about 70 cm long. Credit: Woudloper Wikimedia (CC BY-SA 3.0)
The complete skeleton of Therizinosaurus. It seems trite to wish for the complete skeleton of a dinosaur known only from partial remains – after all, for years we were wish wish wishing that one day, one day, good material of Deinocheirus would turn up. Now it has, and we've moved on. But, whatever. Therizinosaurus – currently known from forelimb and a bit of hindlimb material only – is the biggest of the therizinosaurs and an argument can be made that we know enough about the members of the group anyway to already have a good idea as goes what it was like. But Therizinosaurus is a giant, potentially one of the biggest theropods of all. Not only would it be really, really cool to know exactly what it looked like (I guarantee it isn't just going to be a super-sized version of Nothronychus or whatever), it will potentially show how members of the maniraptoran lineage evolved to cope with giant size. And this could actually have all kinds of interesting and important ramifications. Yes, I'm thinking of the poultry industry again.
There have been several speculative efforts to reconstruct 'protobats' - these are the excellent illustrations by Fiona A. Reid (from Graham 2002). But... where are the fossils? Will we ever find them? Credit: Graham 2002
A complete protobat. Even today, there is no 'Archaeopteryx for bats': there are archaic, geologically ancient fossil bats that possess primitive features not present in later bats (Onychonycteris from the Eocene of Wyoming retains a full complement of wing claws and has wing and hindlimb proportions quite different from those of later bats), but they still have fully-formed wings and were evidently fully flight-capable. The lack of a compelling fossil protobat means that we lack data on what bat ancestors looked like and on the sorts of transformations their evolution involved: there are competing ideas on how bats originated, on the specific sort of locomotion that led to the evolution of bat wings and flight style, and on exactly where bats fit within the placental mammal radiation. People have had a few attempts already at guessing what protobats might have looked like, a topic I've covered here on a few occasions. The discovery of a complete fossil protobat – represented by a whole skeleton, not just by some little chunks of jaw or a few teeth – would help answer all of these questions and be an astonishing find.
You don't have to be an expert on fossil primates to be aware of Gigantopithecus. This ilustration of a lower jaw is from Simons & Ettel's (1970) magazine article. Credit: Simons & Ettel 1970
A complete Gigantopithecus. The famous Asian fossil hominid Gigantopithecus is – as everyone knows – represented solely by teeth and partial lower jaws. Fossils of this sort have been known to science since 1935 when Ralph von Koenigswald discovered the first examples in an apothecary shop in China; later finds were made in India. We're not entirely sure what kind of hominid it is (though general thinking is that it's a pongine), how big it was (extrapolations that make it super-sized may well not be valid), or what it looked like. There are three species, all equally poorly known [UPDATE: I forgot that two of those have recently been moved to the new genus Indopithecus, leaving only G. blacki as the real Gigantopithecus. Thanks, Cameron].
We will keep searching! Credit: Darren Naish
So, it would be really nice to know: finding a good Gigantopithecus skeleton would effectively end more than 80 years of speculation and extrapolation and resolve one of palaeoprimatology's longest-standing mysteries. Ok, so Gigantopithecus might just turn out to be an especially robust, highly terrestrial relative of orangutans and other pongines. But it might also surprise us: good skeletal remains would allow us to either shoot down or, just possibly, endorse those proposals that it was hominin-like as argued by those who've linked it with their ideas about yetis and bigfoots.
And we'll end it there for now. Believe me, I have other 'wish list' fossils too and maybe I'll come back to this topic in the future. Many of the issues touched on in this article have been covered on Tet Zoo before. See…
Ceratopsian dinosaurs: cheeky or beaky?
PROTOBATS: visualising the earliest stages of bat evolution
Books of the TetZooniverse: of Palaeoart, Bats, Primates and Crocodylians
The Stem-Mammals--a Brief Primer
The Sensitive Face of a Big Predatory Dinosaur
Refs - -
Barker, C. T., Naish, D., Newham, E., Katsamenis, O. L. & Dyke, G. 2017. Complex neuroanatomy in the rostrum of the Isle of Wight theropod Neovenator salerii. Scientific Reports 7, 3749.
Carr, T. D., Varricchio, D. J., Sedlmayr, J. C., Roberts, E. M. & Moore, J. R. 2017. A new tyrannosaur with evidence with evidence for anagenesis and crocodile-like facial sensory system. Scientific Reports 7, 44942.
Graham, G. L. 2002. Bats of the World. St. Martin's Press, New York.
Hieronymus, T. L., Witmer, L. M., Tanke, D. H. & Currie, P. J. 2009. The facial integument of centrosaurine ceratopsids: morphological and histological correlates of novel skin structures. Anatomical Record 292, 1370-1396.
Iurino, D. A., Bellucci, L., Schreve, D. & Sardella, R. 2014. Exceptional soft tissue fossilization of a Pleistocene vulture (Gyps fulvus): new evidence for emplacement temperatures of pyroclastic flow deposits. Quaternary Science Reviews 96, 180-187.
Kellner, A. W. A., Wang, X., Tischlinger, H., Campos, D. de A., Hone, D. W. E. & Meng, X. 2009. The soft tissue of Jeholopterus (Pterosauria, Anurognathidae, Batrachognathinae) and the structure of the pterosaur wing membrane. Proceedings of the Royal Society B: Biological Sciences 277, 321-329.
Simons, E. L. & Ettel, P. C. 1970. Gigantopithecus. Scientific American 222 (1), 77-84.
Unwin, D. M. & Bakhurina, N. N. 1994. Sordes pilosus and the nature of the pterosaur flight apparatus. Nature 371, 62-64.
Witton, W. P. 2013. Pterosaurs. Princeton University Press, Princeton & London.
Darren Naish is a science writer, technical editor and palaeozoologist (affiliated with the University of Southampton, UK). He mostly works on Cretaceous dinosaurs and pterosaurs but has an avid interest in all things tetrapod. His publications can be downloaded at darrennaish.wordpress.com. He has been blogging at Tetrapod Zoology since 2006. Check out the Tet Zoo podcast at tetzoo.com!
The End of Tetrapod Zoology, ver 3
Dinosaurs in the Wild: An Inside View
Speculative Zoology, a Discussion
The Supracranial Sinus of the Horned Dinosaur Skull
J.Lo and Other Araripemydid Pleurodires


Instead it created her an environment of refinement to get where she is today; happy and living each day with high expectations for her life and loved ones. She loves and takes pride in her family. She enjoys meeting new people, new places and being a part of changing circumstances for the greater good.
Linda has witnessed life's toughest lessons for people through the eyes of the judicial system. Her experience in the Courts of over twenty years have given her an insight in the minds of some pretty misguided souls. As a Courtroom Clerk for the Superior Court of California, San Joaquin County she has gotten to see how unhealthy choices can lead one into some very dark places.
"It's okay to let people be "not okay" if they choose. But we have to make sure that we come to the realization that we have an obligation to ourselves and them not to get absorbed into those misguided choices and even in the way of them suffering the consequences. Let go and trust that life and it's lessons is sometimes the best thing you can do for them. Also protect the innocent that may have suffered under the consequences of their choices.
The free will is a powerful influence set in our mind. It is what separates us from all other living creatures and when lined with "Good Orderly Direction" it can take us to a life of purpose and fulfillment. It's in that process of being not okay that we make a decision to make a choice to change our circumstances. We must be ready, we must be tired of being tired- Then make a change. Do something different to that of what has not been working. " One of my favorite quotes: The definition of insanity is "Doing the same thing over and over again and expecting different results".
Linda is currently retired and now giving her full attention to building the A-Song4Wellness website and learning new things and taking on new tasks as they arise. She is currently living in Nashville, Tennessee with her husband Troy Luccketta.


text:
Jammu and Kashmir: Mehbooba Mufti's luxury paid by taxpayers
Times Now has gained exclusive information regarding the former Chief Minister of Jammu and Kashmir and Peoples Democratic Party politician, Mehbooba Mufti's luxury expenditures. An RTI copy has been accessed by Times Now where her expenses have been disclosed. It can be seen that the CM spent a good amount of the taxpayers' money for her own benefits, using up a huge sum for basic essentials. Cutlery and bedsheets have been billed for 49 lakhs and 17 lakhs respectively according to the RTI report, clearly showing how the money of the people is being misused by the politicians for their own gains. Watch the full video to find out more.
Indians Googled 'How to Make Covid-19 Vaccine at Home' as Historic Vaccination Drive Started
On January 16, almost a year since India reported its first coronavirus infection, the country launched the world's biggest vaccination drive.


A "security freeze" blocks access to your credit unless you have given your permission. This can prevent an identity thief from opening a new account or getting credit in your name. All consumers can get a free security freeze online, by phone or by mail. A security freeze, also known as a credit or a file freeze, can be lifted (or "thawed") temporarily when you are applying for credit, or removed permanently.
Parents and guardians can also shield their children's credit report with a special Protected Consumer security freeze. These freezes can also be used to safeguard incapacitated adults.
Once you've placed a security freeze on your credit, a creditor who asks to see your file will see a message that your file is frozen. The creditor will not see your credit score, and may treat your application as incomplete but not rejected.


text:
Q: How to Set Type in Expression.Property for JObject I am trying to generate an Expression Tree. I have JSON Data which i have taken into JOject.
This is how my firstRecord looks like:-
{
  "Name": "JOHN",
  "Code": "112631.1"

}

CODE:-
   var reportArr = (JArray)(data["reportData"]);
   var firstRecord=reportArr.FirstOrDefault();//sample data given above
   Type classType = firstRecord.GetType();// Type is Of JObejct.
   ParameterExpression parameter = Expression.Parameter(classType, "lambdaKey");
   var fun = Expression.GetFuncType(classType, typeof(object));
   var menuProperty = Expression.Property(parameter, "Name");//Throwing error

Error Message is :-
 Instance property 'Name' is not defined for type 'Newtonsoft.Json.Linq.JObject'

How can i get MemberExpression from Expression.Property with JOject.

A: JObject is a dynamic type and does not provide typed properties like regular types.
As usual with expressions, you can start from writing a compile time expression:
Expression<Func<JObject, object>> expr = item => ((JValue)item.Property("Name").Value).Value;

and examine what's inside using the debugger Locals/Watch window.
In this case, it would be something like this
var item = Expression.Parameter(typeof(JObject), "item");
var body = Expression.Property(
    Expression.Convert(
        Expression.Property(
            Expression.Call(item, "Property", null, Expression.Constant("Name"))
            , "Value")
        , typeof(JValue))
    , "Value");
var expr = Expression.Lambda<Func<JObject, object>>(body, item);


Ahhh, warm, sunny and breezy weather always puts me in a great mood and so does a flowy dress. I bought this dress in Hawaii a few weeks ago and knew exactly what I wanted to pair it with - the 'cody' button. It's definitely sheer so I wore some navy shorts underneath, you can't really see them but they're there. :) I wore this outfit that night to dinner with my lover.


Thirty kilometres from the entrance of the Nxai Pan National Park Baines' Baobabs are a must-see highlight for any visitor travelling this area of Botswana.
Seven huge, gnarled baobab trees, named after the 19th-century explorer Thomas Baines, artist, naturalist and cartographer are s sited on a promontory overlooking and surrounded by the white, crusty Kudiakam Pan.
Baines' diaries, sketches, drawings and paintings provide us with fascinating first-hand documentation decisive in the history of Southern Africa.


text:
Q: Only append rows from matching columns I have tried different things using merge/concat/append, but I don't get the result I want.
Table1

id
colB
colC

1
X
hello

2
Y
hello

3
Z
hello

4
W
hello

Table2

id
colB
colD

12
L
bye

13
M
bye

14
N
bye

15
O
bye

Admired result after append:

id
colB
colC

1
X
hello

2
Y
hello

3
Z
hello

4
W
hello

12
L
NaN

13
M
NaN

14
N
NaN

15
O
NaN

I want to expand Table1 with the rows from Table2, but without also taking the colD-column from Table2.

A: you can first concat and then select columns from df1 (Table1)
new_df = pd.concat((df1,df2),sort=False).loc[:,df1.columns]

Or with reindex:
new_df = pd.concat((df1,df2),sort=False).reindex(columns=df1.columns)

A: You could concatenate two dataframes and drop a column you do not need:
result = pd.concat([df1, df2]).drop(df2.columns.difference(df1.columns), axis=1)\
                              .reset_index(drop=True)

print(result)

    id  colB     colC
0    1     X    hello
1    2     Y    hello
2    3     Z    hello
3    4     W    hello
4   12     L      NaN
5   13     M      NaN
6   14     N      NaN
7   15     O      NaN

We dropped all columns which are different, without specifying a certain name.

A: Try this:
pd.concat([df, df1]).drop(columns='colD')

Output:
    id  colB    colC
0   1   X   hello
1   2   Y   hello
2   3   Z   hello
3   4   W   hello
0   12  L   NaN
1   13  M   NaN
2   14  N   NaN
3   15  O   NaN


MARMON-Betty. (nee Lewis) Of East Hampton, NY, on June 22, 1998. Beloved wife of Bradley S. Marmon. Devoted mother of Stephen J. Marmon of Bethesda, Md; Nan Sabel of Waltham, Mass.; and Elise Raymond of East Hampton. Adored grandmother of Matthew and Zachary Sabel; Elizabeth Marmon and Annabelle Raymond. Cherished twin sister of Grace Griffenberg of Riverdale, NY. Dear mother-in-law of Betty J. Marmon of Bethesda, Md. Loving aunt of Susan Trovati and Stuart Griffen. Funeral services at 1 p.m. Wednesday, June 24, at the Jewish Center of the Hamptons. Memorial contributions may be made to the Education Building of the Jewish Center, 44 Woods Lane, East Hampton, NY 11937.


text:
NWTF Raising Local Awareness of Ongoing Expansion Efforts
By Edgefield Advertiser on January 23, 2015 Comments Off on NWTF Raising Local Awareness of Ongoing Expansion Efforts
The National Wild Turkey Federation spoke to two different groups this week in order to raise awareness of their Hunting Heritage Center and Palmetto Shooting Complex projects. Below are two reports from the meetings, the first from The Edgefield County Alliance meeting held Tuesday, January 20th, and the second from a presentation to local officials, and community leaders held at NWTF headquarters, Thursday, January 22.
"Our Vision Becoming a Reality"
George Thornton on NWTF Project
One gentleman entering the County Council Chambers in Edgefield on Tuesday morning explained his tardiness as having "gone to the wrong meeting place." A retort came quickly: "Hard to do in Edgefield (implying too few meeting places)." This was a perfect entry for the information that followed: Edgefield through the NWTF will have many more meeting places to offer as pointed out by their CEO George Thornton in his remarks before the Edgefield County Alliance Tuesday morning.
National Wild Turkey Federation is driving much curiosity about the program they are projecting – not just projecting, but is well underway – and it is driving hopes for economic growth in this area. And the area includes three towns noted by CEO Thornton in his remarks: They are Edgefield, Johnston and Ridge Spring.
It was former Mayor Andy Livingston who proposed that leaders draw some kind of name for a triangulation of these three towns, something like the Golden Triangle of cities of North Carolina. Thornton mentioned them as destinations for visitors spilling over from NWTF's Palmetto Shooting Complex Project .
CEO Thornton gave a full Powerpoint presentation of numbers, statistics, and maps to confirm the growth expected. (These numbers have been published in this newspaper in an edition last year.) This program has multiple avenues for training, teaching and convening around the Hunt and the Habitats, using conservation as a base for its drive
There are 700 acres now mapped out for these training and teaching events, to reach not only adults but children and women, specifically. Thornton says many more women are joining in the shooting and the hunt than ever before. And "shooting" is not just with guns; archery probably holds more numbers of shooters than guns. And learning to shoot can be done at the multiple clay-shooting areas on this huge campus.
Already, for the next 24 months, 27 events have been planned, each bringing in hundreds to thousands of visitors, who may have wives or partners who need their own "entertainment" during this time. Thornton points out that there is a need for new restaurants ("at least two good ones") and hotel/motel rooms as well as catering businesses and skilled cleaners to help in the housing and feeding of those on the campus.
Thus new jobs are in order. Already NWTF has hired 6 new employees, with the potential for ten more being hired.
Also there will be many RV hook-ups, possibly not enough. They will need their own steaks for cooking for themselves (purchasing of food in the communities).
During Question and Answer time, it was noted by one attendee that entrepreneurs are in order here — folks who know how to build a catering or cleaning business. He asked if the schools taught entrepreneurship. One PTC employee was there to answer, Yes, for the College. Not sure about the high schools in the county.
In the area of Habitats, Thornton noted that there would be demonstrations given at the campus on restoration of habitats and management of hunting areas. This led into the loss of habitats over the years, one being the long leaf pine forest. He noted that at the time of America's beginning, there were 88 million acres of the long leaf pine virgin forest. Now there are 3000. But much is being done to recreate these virginal forests with the planting of long leaf pine which provide a great habitat for animals and certain plants.
NWTF has joined with governmental organizations (Forestry and DNR) as well as other conservation groups (Ducks, Pheasants) to organize and bring about these efforts mentioned above. A huge lobbying group, one would say.
Among the many new buildings going up on this 18 million dollar campus is one inspired by a building at Fort Benning where Thornton attended a conference. The Ft. Benning building is now under National Preservation Registry as it was a hunting lodge for Gen. Patton and where he invited many colleagues (Eisenhower among them) to hunt and enjoy their company. This building is called the Roundhouse and will soon be under construction. Not only will its 6400 square feet be available for NWTF interests, but it will be available for public and private gatherings. (No more "hard to find in Edgefield" comments.)
His words were that they (NWTF) needed to "walk the talk" and so was born the Palmetto Shooting Complex – "Our Vision Becoming a Reality." According to Thornton it has been developed as "a national [attraction]."
And the attendees were invited to come see the campus in progress.
NWTF Building a Conservation Legacy
At a recent meeting of local county and city officials, National Wild Turkey Federation (NWTF) CEO George Thornton shared the vision for the organization's Hunting Heritage Center. The world-class center being built on the 700-acre NWTF property in Edgefield is the combined site of the Palmetto Shooting Complex and the Outdoor Education Center.
"Hunters and recreational shooters play a vital role in this country accounting for 80 percent of the funding for habitat and wildlife conservation projects through hunting license purchases and excise taxes on firearms and ammunition," said George Thornton, NWTF CEO. "The Hunting Heritage Center will serve to preserve our hunting heritage and foster the next generation of shooting sports enthusiasts; our habitat and wildlife depend on it."
Meeting attendees learned about more than the vision. They were informed of the influx of tourists and the economic impact the Hunting Heritage Center would make on the region. Attendance projections number nearly 50,000 annually just for shooting and education events. Normal daily traffic would drive the projections even higher.
Some phases of the Hunting Heritage Center are still in development but that has not slowed the buzz surrounding the complex. Several large events have been scheduled for Palmetto Shooting Complex this year. The South Carolina Department of Natural Resources (SCDNR) sporting clays youth open is scheduled for mid-April. The South Carolina 4H program has two shoots scheduled for June.
The NWTF also has scheduled events for the Palmetto Shooting Complex; its annual Turkey Shoot, one of the nation's largest sanctioned sporting clays shoots, as well as the Still Target World Championships.
The monumental project embodying both habitat conservation and hunting preservation is being funded solely through NWTF partner contributions and direct donations. The South Carolina Department of Natural Resources already has contributed $2 million to the project through Pittman-Robertson funding. Money raised by the NWTF's grassroots members, banquet committee and chapter leaders will continue to fund Save the Habitat. Save the Hunt. projects across the country.
NWTF Raising Local Awareness of Ongoing Expansion Efforts added by Edgefield Advertiser on January 23, 2015


Triple Falls, in the upper part of Oneonta Gorge, fall 130 feet through a lush, beautiful temperate rainforest. Triple Falls Photo.
Triple Falls, in the upper part of Oneonta Gorge, fall 130 feet through a lush, beautiful temperate rainforest. Triple Falls Picture.
Triple Falls, a trio of falls dropping 130 feet in the upper part of Oneonta Gorge. Stock Photography of Triple Falls.
Triple Falls, in the upper part of Oneonta Gorge, fall 130 feet through a lush, beautiful temperate rainforest. Photograph of Triple Falls.


Some Personal Chapel Tours are available by appointment. Call 404.222.0722 to get on the tour schedule.
We designed A Perfect Wedding Chapel plus Photo &Video to include a completely decorated chapel area, faux wedding cake for pictures, bridal prep room, cathedral arches, plus 10 photo area settings for wedding pictures. We are located in the historical district of Avondale Estates, GA. We also offer optional items like more photographs, wedding albums, a videographer, reception site recommendations and optional professional photo sessions on location at nearby parks and lakes for outdoor picture memories. Our engagements photography sessions and custom designed engagement albums are very popular.
Stress-Free and Debt-Free Weddings are a Phone Call Away!
Our experienced officiants have performed, authenticated, solemized and witnessed many wedding ceremonies. They are certified professionals by the state of Georgia.They are completely flexible on the type of service and vows that you want. It's your wedding. Have it your way!
A Perfect Chapel wedding is a real bargain when compared to the thousands you would had spent for an expensive church wedding. Your Pictures will look great and you will feel great. Use the money you save to pay a bill, pay for college, buy a car, a house or have a party. Call (404) 222-0722 to get started.
We can accommodate from 2-50 persons. There is plenty of parking with a front and rear entrance. Weddings are held Everyday! Call (404) 222-0722 at anytime to make a reservation.Click Here for Our Affordable Packages and Prices!


Our day at the beach got off to a slightly rocky start when half the team met at the physical jetty structure, and the other half met in the Jetty Hotel. Pro tip – When organising a footup at the beach, it helps to choose a better meeting place than just "The Jetty". After the more sun burnt of the two groups finally caught up with the more inebriated party, we decided that lunch was in order. After a decent lunch at the hotel was satisfyingly completed, the original Jetty Hotel group were starting to look a bit tiddly, so we decided to do a bit of dancing. Henceforth trotted back to the actual Jetty to strut our stuff for a large group of adoring fans.
It was a nice sunny day and Glenelg beach was packed with its usual cohort of interesting characters, which included a drunk guy in a dinosaur onesie, who started inexplicably rolling around on the ground at the back of the set. We were also joined in our dancing efforts, by an X-Factor wannabe, complete with afro and pointless sunglasses, two separate wedding parties, and what appeared to be a woman at a hens night that either got started early, or perhaps never finished from the night before.
Even our attempts to have a quiet drink in the nearby pub attracted attention from a football team and cheerleaders, who were obviously celebrating their lack of grand finals attendance. Overall it was a fairly eventful and quite enjoyable experience, conducted in the correct spirit of Adelaide's sunny beach atmosphere.


I played, I laughed, I jumped, I hoped, I learned and I grew magically in nurturing lap of Mother Nature.
Students of Grades Nursery and Prep of Presidium Gurgaon 57 recently were taken out for a nature walk to 'The Leisure Valley Park' to give them a break from the monotonous classroom routine. Little children appreciated the beauty and wonder of nature and delighted to experience the tender of flowers, the softness of grass and breathe in fresh air. Besides all the goodies, interesting 'puppet show and magic show' was organized which was a wonderful kids-captivating program rendered them asking for more. This visit to a natural surrounding offered students to create beautiful memories to cherish forever. Indeed, it was an experience that children will never forget!


If you are ERNEST FRANKLIN, please click here now to create your login!
Ernest Franklin Jones has not joined the site yet. Do you know where Ernest Franklin Jones is? If so, please click here to invite Ernest Franklin to join our site!


text:
The Future of Europe: A Norwegian Perspective
Created on 22 September 2011
On September 22, 2011, The Honorable Christian Syse, Deputy Secretary General of the Norwegian Ministry of Foreign Affairs addressed Norway's unique role within the transatlantic alliance, as a founding member of NATO and as an important partner of the European Union. Just shy of EU membership, Norway's active role is by no means limited to its' engagement in the European Free Trade Association and the European Economic Area, as witnessed by the nation's consistent efforts to further greater social and economic cohesion in Central and Eastern Europe. Mr. Syse also offered insights into the future of Norway's relationship with the European Union, and the considerable challenges facing both Europe and the United States.
Norway Atrocities Raise Challenges About Europe's Far-Right (7/29)
Category: July 2011
Created on 29 July 2011
Last week's atrocities in Norway were an act of far-right violence on a scale unknown in Western Europe in the post-World War II era, and they have scalded European politics with sudden fear about the possible extreme consequences of anti-Muslim populist rhetoric.
RISING SUCCESS OF POPULIST PARTIES ROILS POLITICS ACROSS EUROPE
Category: EA July 2011
This European Affairs article, written and going to press before last week's tragic events in
Norway, has been given a topical introduction to provide some context (without any prediction)
about the growth of populist parties in Europe.
Russia in a Multipolar World: Implications for Russia-EU-U.S. Relations
On July 12, 2011, The European Institute held a special meeting of the Transatlantic Roundtable on EU-U.S.-Russia Triangular Relations, with His Excellency Sergey Lavrov, Foreign Minister of the Russian Federation, organized in cooperation with the Embassy of the Russian Federation and the Center for Strategic and International Studies.
Minister Lavrov offered his perspective on Russia's foreign policy within the framework of euro-atlantic relations, focusing on a wide range of key issues including, proposed missile defense systems in Europe; implications of the Arab awakening, with particular emphasis on Libya and Syria; progress of the Middle East Quartet's efforts to restart the peace process; Russia accession to the WTO, as well as his nation's push to diversify and modernize its economy.
Click here to read the full text of Minister Lavrov's remarks.
EU Financial Regulatory Reform: A View from the Hungarian Presidency
On July 7, 2011, The Honorable András Kármán, Hungarian State Secretary for Tax and Financial Regulation at the Ministry of National Economy, who personally coordinated the negotiations between EU Member States and the European Parliament during Hungary's Presidency of the European Council, on a number of key legislative initiatives, including the reform of the Stability and Growth Pact, offered his insight into what was accomplished and the challenges that still lay ahead in the European Union's push for sustainable financial and economic stability.


text:
R&B Singer Layton Greene Talks Going Viral With Kodak Black Remix, Making Her Billboard Chart Debut & New Music
1/25/2018 by Rachel George
Divie Moss
Layton Greene
Nineteen-year-old Layton Greene became a viral sensation after uploading a video of her singing a cover of Kodak Black's "Roll in Peace." The short clip has received more than 250,000 views (and counting) on Instagram and more than 8,000 retweets on Twitter. She recorded a longer version and uploaded it to SoundCloud, receiving 3.5 million-plus views in the first month.
Produced by G-Styles, the song quickly shot up to the No. 12 spot on the Hot R&B Songs chart. She quit her job at a local food spot and put everything on the line to pursue her music career
"I wasn't expecting that at all," Greene told Billboard. "I didn't even think it was that good, just because I wasn't really showcasing my vocals. It went viral, and I just started getting followers out of nowhere. It was crazy to me. It's still crazy to me," she laughed.
The song is composed of the original version mixed with some original lyrics written by Greene and a softer R&B "Lovers and Friends" vibe.
Born in East St. Louis, Illinois, Greene remixes lyrics from today's rap songs with an old-school R&B twist and original lyrics about her life struggles. In addition to her inviting lyrics, fans are mesmerized by her raspy voice and her sweet vocalizations.
Next month, Layton Greene plans to release her first official single with original music and lyrics. Billboard sat down with the viral sensation to discuss how she copes with her life struggles, her newfound success and her new music.
How did you start doing music?
I've been singing my whole life -- since I've been talking, basically. I didn't start taking music seriously until last year. I posted a video and it just went viral. That's basically it. I didn't have the motivation or the drive to take it seriously. I was just working and going through stuff. I was in a position to where I had to work so I couldn't focus on what I really wanted to do. It was hard, but I always knew I would get back to it, some way. I just had to do what I had to do at that time.
But when that happened [going viral], I was like, "I'm 'bout to quit my job." So I quit my job. I just put everything on the line
You dropped "Roll in Peace Remix." How did that song come about?
Just hearing what Kodak was saying, he saying some real stuff. I was just thinking, "How would I do it if I was to sing it?" I did the song and I put the video on Snapchat. That's really where I do most of my singing at, because that's where I get the most feedback. I never posted on Instagram at all. My Instagram was dead. I posted it on Twitter and it went viral, and then I posted it on Instagram and I just started getting followers out of nowhere.
The song charted on Billboard, peaking at No. 12 on the Hot R&B Songs chart. What was that moment like for you?
I was lying down and my producer/manger G-Stylez, he reads all my emails. We get a lot of emails. He just said, "This dude from Billboard hit you up." He didn't really say anything about what he was trying to do, so I didn't freak out yet. But after we talked to him, I didn't believe it until I actually seen it, that my song was on Billboard. At home working on music during the time, seeing my name up there with people that's like big, seeing my name next to Chris Brown, people that I've been looking up to all my life.
What's the craziest response you got from a fan about the song?
Actually, I get a lot of hate. Kodak fans be coming for me, saying I'm stealing his song. I just oversee the hate, because the love is also real. I get a lot of love too, and that's the best feeling in the world to me. That's really why I'm doing what I'm doing and why I'll continue what I'm doing, you know?
Fans tell me how I'm their inspiration and how when they go through hard times and they just listen to my voice and that's everything to me, for real.
How does it make you feel to know that you're a role model and that your music heavily impacts others?
It's crazy that I'm a lot of people's inspiration. I didn't think I would ever become that. I didn't even think I had that in me. The feeling is just crazy. I really can't explain it, I really can't. I've cried a few times thinking about it. I'm just blessed.
So you write all of your own music. Where do you draw inspiration from and what's your favorite part about the process?
My favorite part is listening to the beat. I think about how the beat makes me feel, happy, sad. With every beat, you just feel something. The beat just talks to me. Writing is also my favorite part. It takes me a long time, but that's because I'm my own biggest critic. I haven't always written because of what I've been through in my life, but I've got a lot to write about. I've got a story to tell. Music really helps me cope with what I'm going through. It puts me in a better place, in a better mood.
In your latest single, "Fed Up Remix," you talked about being broke, sleeping on the floor and watching your mom fight. Is there any personal truth to those lyrics?
Yes, it's all true, even though the pre-chorus, which is Derez Dehson's lyrics. I heard that song and I was like, "He's going through what I went through so that's why I picked that song. I've been in situations where I couldn't live with my mama, where I had to sleep on the floor because there was no room in the bed. There were times when my mama couldn't pay the bills. For two weeks we didn't have no lights, I couldn't make that stuff up.
How do you stay motivated with all of your life and family struggles?
The music is really helping me cope with my problems myself. My fans really help me a lot too, because especially when they say I've helped them get through certain things in their life, so that's really all that I'm doing this for. If I can help one person going through maybe what im going through, its humbling.
There's so much pain and soulfulness in your voice and in your lyrics. Being a new artist, what do you think about the R&B industry today?
In the industry today, I really like how they take old hits, sample them and re-create it. I feel like there's a lot of sampling going on today. Back then, they didn't have inspiration and resources like we do now. We can go look up any and everything that was ever recorded and pull inspiration from that but still make it dope.
Who are some of your biggest musical influences?
I grew up listening to that old stuff, old R&B, like Aaliyah. I really love Keyshia Cole, though, her old music. She's actually my biggest inspiration. Growing up, every time somebody would ask me to sing, I was singing something by Keyshia Cole. Chris Brown too; he's the best to me. His vocals, his dancing. His music reaches everybody, and I want my music to reach everyone too.
You opened for Kash Doll last month in Knoxville. What was it like hitting the stage for the first time?
I performed "Roll in Peace Remix" and "Fed Up Remix." I didn't think people would react the way they did. It was a great turnout. Just to see people's reactions knowing word for word, the parts that I wrote. They weren't just singing Kodak's part. They were singing my original lyrics too, so that just made me feel good.
What do you hope to bring to the industry?
I hope to bring the game some new music, some integrity. I feel like the one thing a lot of artists lack is integrity. I feel like they're not honest with themselves. We don't get a real sense of who they are through their music.
I'm excited about my album this summer. It's all about me and what I've been through; so anything you want to know, just listen to it.


text:
Golf: Henrik Stenson makes history with double win
Posted by Jason Stepford on November 17, 2013
Henrik Stenson became the first man to win The Race to Dubai and FedEx Cup in the same season following his comprehensive six-shot victory in the DP World Tour Championship in Dubai.
The 37-year-old Swede sealed the FedEx Cup on the US PGA Tour courtesy of his Tour Championship win in September and he then set about looking to finish top of the money list to become the European number one this side of the Atlantic.
A win at the season-ending DP World Tour Championship at Jumeirah Golf Estates was required to achieve Stenson's aim, while Graeme McDowell, Justin Rose and Ian Poulter were hoping for him to slip up so they could pounce for top spot.
However, after taking a one-shot lead into Sunday's final round, Stenson never looked back as he finished in style with a tap-in eagle at the 18th to card an impressive closing 64 for a tournament total of 25 under par.
Stenson told the European Tour website: "It has been an incredible summer for me, the fall (autumn) in America was great and now this. It has been a dream season.
"I played so well this week. I knew the guys would try to catch me, especially Ian who never gives up. I wanted to stay ahead of him and I managed to do that.
"I don't know how I am going to be able to top this next year but I am going to give my best in the Majors and that (to win one) would be the icing on the cake."
Poulter pushed Stenson all the way as he took second following a final-round 66, while France's Victor Dubuisson was two shots further back in third. Dutchman Joost Luiten finished fourth and former world number ones Luke Donald, Rory McIlroy and Lee Westwood shared fifth.
Topics: Bet on Golf, Golf Betting, Golf Odds
International Friendly: Ballack belittles Three Lions
International Friendly: England ready for Germany – Hodgson


On Dec. 31, the Sportsman Channel is launching a reality TV show to fight the so-called "Nature Deficit Disorder" epidemic that's plaguing technology-consumed Americans. "Wyoming's Call of the Wild," presented by the Wyoming Game and Fish Department (WGFD), will immerse kids from all over the country in the woods and waters of Wyoming, according to KGWN-TV. Hunting and fishing are vital for wildlife management, but have become less popular pastimes over the years. WGFD officials are hoping this 13-episode series will motivate kids and their families to start hunting and fishing -- or at the very least "pick a wildflower," said WGFD's Hilda Sexauer in the show's trailer. The show is hosted by author, lecturer and award-winning teacher Craig Conrad, who won the Governor's Award for Excellence in Teaching from former Colorado Gov. Roy Romer.


text:
Q: sql database: table with 2 column (id name) and 2 primary key Third Normal Form Boyce-Codd Normal Form Imagine the following table. In my case, I am completely sure that name needs to be unique and not null [unique+not null = primary key]. Therefore name is a primary key. For some reasons (probably by habit), I have naturally created a primary key id column of type int.
Other assumptions: I absolutely need to keep name in my table and I am absolutely sure that name (of type varchar)  will never exceed 20 characters.
Now my first question is [probably close question with yes or no expected]: do I respect BCNF Boyce-Codd Normal Form if I create such a table?
Second optional question [probably open question]: is it good practice to create column id in this case?
  CREATE TABLE Y (
    id int,
    name varchar(20),
    PRIMARY KEY(id, name)
    );

A: Although relations comprising only two attributes are always in BCNF, your question is a bit difficult to answer as the text does not correspond with the table design.
If I take your table design as base for answering the first question: You create a table Y comprising two attributes id and name, which are the only attributes of Yand which together form the only key, then it is always in BCNF.
When I take your textual description, where you state that name is unique (in terms of the relational model a key), then one has to think of the meaning of the surrogate attribute (or key?) id:
a. If id is a key, too, then FDs are id->name; name->id, where id
    is a key and name is a key, such that every FD has a key on his
    left hand side. BCNF is therefore fulfilled.
b. If idis not key on its own, but name->id holds, then it is still
    in BCNF (because the only FD has a key on his LHS). Though I would
    then not understand why you have an additional attribute id at
    all.
The main thing is, however, that your database scheme does simply not adhere to the rules stated in the text: The sole key with (id, name) is simply wrong expressed, because you should have id as primary key and name as unique constraint (i.e. an alternative key) or vice versa. Then it would be clearly in BCNF, and would correspond to option (a) mentioned above.
So it is not a question of BCNF or not, but a question of "scheme correct expressed or not".

A: If each column is unique, you probably want either
CREATE TABLE Y (
  id int primary key,
  name varchar(20) not null unique,
);

or
CREATE TABLE Y (
  id int not null unique,
  name varchar(20) not null unique
);

The FDs here are id->name and name->id.
Informally, you satisfy BCNF when every arrow in your FDs is an arrow out of a candidate key. So this satisfies BCNF.
It's not a good thing to create a surrogate id column out of habit. Think first, and make yourself aware of the tradeoffs and side effects.


text:
Q: show a larger version of thumbnail image with jquery I am trying to get my (JQuery) code to show a larger version of my thumbnail image.
At this moment I have this code, which only shows the thumbnail in "full size":
$(".gallerythumbnail").click(function() {
    $(".showimagelightdown, .showimagecontainer, .closeimage").fadeIn(300);
    var img = $('', { src : this.src });
    $('.showimagecontainer').html(img).show();
});

I have tried different approaches, including the following:
$(".gallerythumbnail").click(function() {
    $(".showimagelightdown, .showimagecontainer, .closeimage").fadeIn(300);
    var img = $('', { src : 'f'+this.src });
    $('.showimagecontainer').html(img).show();
});

Above I tried to add an "f" to the image path, which would be the full version of the thumbnail, but without luck.
So, is it possible to add something to the path of the clicked image? Or is there a smarter way for doing this?
As for the html, I have a loop (PHP) running throught all images in a folder an printing them out as follows:
print "	";

A: You are adding the 'f' at the beginning of your fullpath, instead of the beginning of the filename.
So if you have the following path:
http://mydomain.com/galleries/gallery2/4886193_460s.jpg

you are doing this:
fhttp://mydomain.com/galleries/gallery2/4886193_460s.jpg

Try this:
$(".gallerythumbnail").click(function() {
        $(".showimagelightdown, .showimagecontainer, .closeimage").fadeIn(300);
        var path = this.src.replace(/[^\/]*$/,'');
        var filename = this.src.replace(/^.*[\\\/]/, '')

        var img = $('', { src : path + 'f' + filename});
        $('.showimagecontainer').html(img).show();
    });

This will create the src like this:
http://mydomain.com/galleries/gallery2/f4886193_460s.jpg


The synergy was wonderful: so many members of our community, young, middle and old, all working together! We felt it's so good for so many kids to be able to be in one place, and, for the most part not running around frantic, crazy, but engaged in constructive, fun activity. The parent support that came in so many ways was deeply appreciated. The Spooky Trail put together by the Elementary kids was especially well done this year - thanks to the Upper Elementary for seeing that everyone got through without being overly spooked! And while icing their own cupcakes at the end of the event was certainly popular with the kids, it was also satisfying to know that almost 100 apples in the apple spooning event were retrieved by the children and eaten during our time together.
Now it's on to gathering all the UNICEF boxes and counting the money collected for the benefit of other children less fortunate than our own.