Following the changes in working habits during the COVID pandemic, your local library has decided it is time to make the newspaper archives available online. They are not sure what the response will be so they are going to trial a new system on a small set of their data.
The library database has a table articles with a record of all articles published in the newspaper. However, the table will need some preparation before the library can use it in the new system. They would like to focus the initial trial on articles from 2014 and 2015 only, and for just one journalist whose ID in the database is 1754.
The final results should be sorted from earliest published date to the most recent published date.
Below are the requirements the library has given to you for the data they need.
| Requirements | Data Type | Column Alias |
|---|---|---|
| Unique ID of each article, where the first 4 digits represents the journalist ID. | TEXT | article_key |
| Category of the article, in uppercase. 'Food & Drink' and 'Wellness' should be collapsed into a 'Lifestyle' category. | TEXT | category |
| Headline of the article, without the subtitle that appears after the colon (:). For example, 'It Could Happen To You: A Story of SEC Overreach' becomes 'It Could Happen To You'. | TEXT | headline |
| Subtitles of the article, without the headline that appears before the colon (:). For example, 'It Could Happen to You: A Story of SEC Overreach' becomes 'A Story of SEC Overreach'. In cases where a headline does not have a subtitle, the missing value should read ‘None’. | TEXT | subtitle |
| Description of the article. The description should be reduced to the first sentence, up to and including the first period (.) from the short_description column. | TEXT | description |
| Keywords of the article. Multiple keywords will be seperated with a dash (-). If the keyword is missing, the value should read ‘Unknown’. | TEXT | keywords |
| Date the article was published. The data should be displayed in the format resembling the following: ‘Aug 13, 1995’. | TEXT | publish_date |
%%sql
postgresql:///articles
-- Execute your SQL commands here
UPDATE articles
SET category = 'LIFESTYLE'
WHERE CATEGORY IN ('FOOD & DRINK','WELLNESS');
SELECT
CAST(article_key AS Text),
CAST(category AS Text),
SPLIT_PART(headline, ':', 1) AS headline,
CASE WHEN SPLIT_PART(headline, ':', 2) = '' THEN 'None' ELSE SPLIT_PART(headline, ':', 2) END AS subtitle,
SUBSTRING(short_description,1,POSITION('. ' IN short_description || ' ')) AS description,
CAST(CASE WHEN keywords IS NULL THEN 'Unknown' ELSE keywords END AS Text) AS keywords,
TO_CHAR(TO_DATE(release_date, 'YYYY/MM/DD'),'Mon dd, yyyy') AS publish_date
FROM articles
WHERE release_date > '2013-12-31' AND release_date < '2016-01-01'
AND article_key LIKE '1754%'
ORDER BY release_date;
2079 rows affected. 188 rows affected.
| article_key | category | headline | subtitle | description | keywords | publish_date |
|---|---|---|---|---|---|---|
| 1754b3c4-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 21 Weird Foods You'll Serve In 2014 | None | Your dinner plate is going global in 2014. | Unknown | Jan 03, 2014 |
| 17545488-21f8-11ec-bdf6-acde48001122 | PARENTING | Life-Giving Parenting | None | I intend to converse with my children in a life-supporting fashion. | lifegiving-parenting | Jan 06, 2014 |
| 17549baa-21f8-11ec-bdf6-acde48001122 | PARENTING | Danielle Jonas | Medication Is Helping Me With Anxiety During My Pregnancy | Watch the full segment with Danielle Jonas on HuffPost Live. | danielle-jonas-anxiety-medication-pregnancy | Jan 08, 2014 |
| 175459ec-21f8-11ec-bdf6-acde48001122 | PARENTING | The Christmas I'll Carry | None | For me, it seems that to honor the holiday, I must honor the everyday. | the-christmas-ill-carry | Jan 10, 2014 |
| 175480de-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Jessica Metzger Lost 110 Pounds On The Quest To Become Her Best Self | None | I do not follow a specific meal plan, I do not eat 100 percent clean and I no longer track my calories. | i-lost-weight-jessica-metzger | Jan 10, 2014 |
| 17546f90-21f8-11ec-bdf6-acde48001122 | PARENTING | 6 Reasons Why Newborns Have Stuffy Noses | None | What many first-time parents don't realize is that newborns usually sound stuffy when they breathe. | why-newborns-have-stuffy-noses | Jan 16, 2014 |
| 175442ae-21f8-11ec-bdf6-acde48001122 | PARENTING | Flipping the Gridiron | Tackling My Son's Obsession With Football | When I met my husband 14 years ago, he turned me into a football fan. | flipping-the-gridiron-tackling-my-sons-obsession-with-football | Jan 17, 2014 |
| 17544d9e-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Time for Autism Speaks to Zip It? | None | time-for-autism-speaks-to | Jan 17, 2014 | |
| 175495ce-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Unexpected Results From an Unexpected Resolution | None | I usually don't go for New Year's resolutions, but I'm glad we did this one. | living-will | Jan 17, 2014 |
| 1754fb5e-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Blood Test Could Help Identify Pancreatic Cancer Early | None | Pancreatic cancer could be identified in its early stages with a test that looks for genetic material in the blood, according. | pancreatic-cancer-blood-test | Jan 21, 2014 |
| 175485a2-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Narcissists May Be More Likely To Be Leaders (But Not Necessarily Good Ones) | None | Indeed, a 2012 study Harms authored in the Journal of Applied Social Psychology showed that narcissists make better first. | narcissists-leaders | Jan 21, 2014 |
| 175479e0-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | How The Most Powerful People In The World Define Healthy Living | None | These leaders will also be focusing on their own health this week, using fitness trackers and being encouraged to make healthy. | how-the-most-powerful-peo | Jan 22, 2014 |
| 17544e70-21f8-11ec-bdf6-acde48001122 | BUSINESS | What Should HR Leaders Focus On in 2014? | None | The most important thing that HR should focus on in talent management is assessing the skills the organization needs to implement its strategy, and the plan for recruiting and managing that critical talent. | what-should-hr-leaders-fo | Jan 26, 2014 |
| 17549240-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Cure vs. Remission | Thoughts From a Crohn's Caregiver | Until researchers find a cure Crohn's disease and ulcerative colitis, I implore you -- please don't say these diseases can be cured when they can't. | personal-health | Jan 29, 2014 |
| 17549f60-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Can We Change Our Culture of Burnout? | None | I'm empathic to those caught in the burnout vortex. | can-we-change-our-culture | Jan 29, 2014 |
| 1754a3e8-21f8-11ec-bdf6-acde48001122 | PARENTING | Pick-Up Lines My 6-Year-Old Son Uses to Impress Much Older Waitresses | None | Did you know that I'm 6 years old. | pick-up-lines-my-6-year-old-son-uses-to-impress-much-older-waitresses | Jan 30, 2014 |
| 1754c562-21f8-11ec-bdf6-acde48001122 | BUSINESS | Countries Where Children Have the Best Opportunities | 24/7 Wall St. | Is America really the land of opportunity. | Unknown | Feb 02, 2014 |
| 17548930-21f8-11ec-bdf6-acde48001122 | BUSINESS | China Now Guzzles More Red Wine Than Any Other Country In The World | Quartz | Part of China’s growing appetite for red wine is the country’s taste for certain French varietals. | china-red-wine | Feb 02, 2014 |
| 1754eca4-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The Midwest Officially Has Some Of The Best Beers In The World | None | If you want the best English pale ale, go to England. | best-beers-midwest-ratebeer | Feb 06, 2014 |
| 17545b22-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 5 Surprising Ways Your Mattress Affects Your Sleep And Health | None | Not that we don't recognize the importance of a comfy mattress. | mattress-sleep-health | Feb 09, 2014 |
| 1754305c-21f8-11ec-bdf6-acde48001122 | PARENTING | The Importance of Modeling the Behavior You Want to See | None | Many parents turn to professionals thinking that when their teen hears about the dangers of drug use from someone else, they will be swayed, but the truth is that usually, it's the parents' behavior that have much more impact on a teen's behavior. | the-importance-of-modeling-the-behavior-you-want-to-see | Feb 11, 2014 |
| 1754977c-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The Most Romantic Restaurants in America | None | Your wooing efforts may fall flat if half of the dinner conversation revolves around the disappointing food. | the-most-romantic-restaur | Feb 12, 2014 |
| 17548f70-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The Essential Russell Stover's Valentine's Day Cheat Sheet | None | We can save you the heartache and pain of biting into random chocolates you don't like, thanks to our heart-shaped chocolate cheat sheet. | the-essential-russell-sto | Feb 13, 2014 |
| 1754b108-21f8-11ec-bdf6-acde48001122 | PARENTING | Son's Grades Slipping | Is it ADD? | The transition to middle school is a big one. | sons-grades-slipping-is-it-add | Feb 13, 2014 |
| 17546f54-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 13 Signs You Have Anxiety -- And Don't Know It | None | Just as some people feel depressed in the winter, some feel anxious. | Unknown | Feb 16, 2014 |
| 1754413c-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Why I'm Not Worried About Yoga Mat Chemicals in My Food | None | We have been eating fast food sandwiches made with azodicarbonamide for years. | azodicarbonamide-subway | Feb 19, 2014 |
| 175494a2-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The Long Winter of Grief | None | The process of grief is sometimes likened to a cold, dark period of gloom. | death-and-dying | Feb 21, 2014 |
| 175476f2-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Dare to Be 100 | An Important, Ugly and Rare Word | A minute's reflection reveals that such a relationship must be. | dare-to-be-100-an-importa | Feb 23, 2014 |
| 1754e6be-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Paula Deen Riding Things 2.0 | None | And she's back in the game. | Unknown | Feb 24, 2014 |
| 1754f280-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | FDA Approves Drug For Rare Body Fat Disorder | None | The drug, Myalept (metreleptin), is a form of leptin meant to reduce accumulation of fat in organs to better control blood. | leptin-hormone-deficiency-drug-rare-body-fat-disorder-treatment-fda | Feb 25, 2014 |
| 1754fbc2-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | How to Break Down A Butternut Squash | None | It's time to end the struggle. | how-to-break-down-a-butte | Feb 26, 2014 |
| 1754ca62-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Sadly, Tech Addicts Have Taken a Page From Drug Abusers | None | In essence, whenever intensely-pleasurable and arousing substances, like cocaine and crystal meth, or experiences, like shopping, video-gaming, gambling and sex, become more readily affordable and accessible, the potential for addiction rears its ugly head. | tech-addiction | Feb 26, 2014 |
| 1754ffc8-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Bake the Best Macaroni and Cheese | None | Glenn Harris, chef of The Smith in New York City, doesn't cut back on the butter in his iconic macaroni and cheese recipe. | bake-the-best-macaroni-an | Feb 27, 2014 |
| 175492fe-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | If Your Cat Is Fat, Try a High-Moisture Diet | None | Not All Canned Cat Food is Equally Nutritious If your budget can't accommodate human grade or even premium canned cat food. | if-your-cat-is-fat-try-a | Feb 27, 2014 |
| 175492c2-21f8-11ec-bdf6-acde48001122 | BUSINESS | Doing Business in the United Kingdom | Cross-Cultural Etiquette | When traveling abroad, it's important to learn about the people and culture you are doing business with, so as not to be misunderstood or appear rude. | doing-business-in-the-uni | Mar 01, 2014 |
| 1754c350-21f8-11ec-bdf6-acde48001122 | PARENTING | Kids React To Rotary Phones And Make You Feel Like The Dinosaur You Are | None | These smart kiddos know that the object in front of them is a phone because of history books and old-time movies. | kids-react-to-rotary-phon | Mar 03, 2014 |
| 1754e628-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Get Fit Fast | 5 Reasons to Love Interval Training | You get more fat loss with alternating medium or high intensity activity with periods of rest than training for the same. | interval-training | Mar 04, 2014 |
| 175447d6-21f8-11ec-bdf6-acde48001122 | PARENTING | The Cost of Internet Defamation | None | With the electronic frontier evolving, online defamation has reared an ugliness that has ruined lives both emotionally and financially. | the-cost-of-internet-defamation | Mar 05, 2014 |
| 1754c832-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Cloudy With a Chance of Meatheads | None | As long we impart to nutrition the mediagenic volatility associated with the weather, we can all but guarantee that our understanding of what is good for us will remain very much clouded over. | diet-and-nutrition | Mar 05, 2014 |
| 1754373c-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | We Can't Even With Martha Stewart's Sex Advice | None | Want to read more from HuffPost Taste. | martha-stewart-reddit-ama-sex-advice | Mar 06, 2014 |
| 17547ff8-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 5 Things That Scare Me Most About Stress | None | Stress alone doesn't makes you a better, stronger person. | dealing-with-stress | Mar 06, 2014 |
| 17547d82-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The 21 New York Restaurants I'll Miss The Most When I Move To LA | None | After 15 years in the Tri-State Area, I'm moving to LA. | new-york-restaurants-ill-miss-the-most | Mar 06, 2014 |
| 17542fe4-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Bubbles Rising | Sparkling Trend in Santa Barbara? | An increasing number of excellent Santa Barbara area producers are trying their hand at creating delicious sparkling wines. | bubbles-rising-sparkling | Mar 07, 2014 |
| 17544d58-21f8-11ec-bdf6-acde48001122 | PARENTING | He Said, 'I Think Your Baby Has Dwarfism' | None | When you don't see it coming at all, it will feel like you are blindsided. | he-said-i-think-your-baby-has-dwarfism | Mar 07, 2014 |
| 1754a280-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Dinner Tonight | Crab Mac + Radicchio Salad | Crab Mac, if you haven't had it, is a Monday kind of dish: rich, comforting, and laced with salty bits of crab and prosciutto. | dinner-tonight-crab-mac | Mar 09, 2014 |
| 1754f19a-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 9 Steps to Overcoming Fear | None | Fear is something you can have, that's true -- but fear isn't of you. | 9-steps-to-overcoming-fea | Mar 10, 2014 |
| 17543214-21f8-11ec-bdf6-acde48001122 | PARENTING | About That ‘Common Core' Math Problem Making the Rounds on Facebook... | None | Over the past week, I’ve seen this image multiple times on Facebook and elsewhere, a supposed denunciation of the Common. | Unknown | Mar 11, 2014 |
| 1754a064-21f8-11ec-bdf6-acde48001122 | PARENTING | Why I Won't Ban 'Bossy' | None | The great misstep with this campaign and others like it is suggesting, even in jest, that we limit one freedom to solve a problem. | why-i-wont-ban-bossy | Mar 12, 2014 |
| 175488f4-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Get Out of the War | None | See the suffering in the other people and yourself, and see if you can have compassion for all parties. | get-out-of-the-war | Mar 12, 2014 |
| 175430d4-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | My Day as a Test Case for Self-Compassion | None | That's when I saw it. | my-day-as-a-test-case-for | Mar 14, 2014 |
| 1754c440-21f8-11ec-bdf6-acde48001122 | BUSINESS | The Best And Worst Paying Cities For Women | None | Despite improving since the 1960s, the gender pay gap is still quite wide in the United States. | Unknown | Mar 15, 2014 |
| 17542db4-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Open-faced Avocado Hummus Sandwich With Pickled Shallots and Baby Spinach | None | Here's a sandwich that's easy to assemble, healthy and quite spunky. | open-face-avocado-hummus | Mar 18, 2014 |
| 17547cce-21f8-11ec-bdf6-acde48001122 | PARENTING | The Problem With 'It's Not Fair!' | None | Fair does not mean equal. | the-problem-with-its-not-fair | Mar 20, 2014 |
| 1754f5dc-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Can Sleep Science Help You Pick a Perfect March Madness Bracket? | None | As a sleep specialist, helping elite athletes deal with sleep and travel is what I do for a living. | sleep-tips | Mar 20, 2014 |
| 1754a244-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The Spring Vegetables We're So Excited For | None | Bring it on, spring. | spring-vegetables | Mar 20, 2014 |
| 1754b144-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | QUIZ | Do You Know Where Your Booze Comes From? | From tequila to bourbon, find out where your favorite booze originated. | booze-comes-from | Mar 21, 2014 |
| 175452d0-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Leave No (Kidney) Stone Unturned | Or Better Yet, Prevent Them From Forming | March is National Kidney Month and the National Kidney Foundation encourages people to learn about the kidneys and kidney-related conditions, including kidney stones. | national-kidney-month | Mar 24, 2014 |
| 175450f0-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | This Bloody Mary Is Bonkers, And Comes Topped With Roast Chicken And A Brownie | None | Get your belly ready (and head to Canada). | crazy-bloody-mary | Mar 24, 2014 |
| 17544178-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Starbucks vs. Dunkin' | We Found Out Which Is America's Favorite | Not too surprisingly, Dunkin' Donuts is New England's coffee chain of choice -- Bostonians' love for Dunkies will never, ever. | coffee-chains-starbucks-dunkin | Mar 25, 2014 |
| 175491c8-21f8-11ec-bdf6-acde48001122 | PARENTING | My Daughter's Olympic Dream | None | I felt I did the right thing, but still... | my-daughters-olympic-dream | Mar 28, 2014 |
| 1754be1e-21f8-11ec-bdf6-acde48001122 | PARENTING | March Madness for College Admissions Decisions | None | Just as the top college basketball teams are competing their way towards the April 7 National Championship Game, so are high schools seniors as they learn which colleges have accepted, waitlisted or rejected them. | march-madness-for-college | Mar 29, 2014 |
| 1754a460-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 2 Cases Of Ebola Confirmed In Liberia | None | The suspected spread of disease into Liberia and Sierra Leone has stirred concern that one of the most lethal infectious. | ebola-liberia | Mar 30, 2014 |
| 1754c0f8-21f8-11ec-bdf6-acde48001122 | PARENTING | The Spring F-Word | None | Like many of you, my family has a rhythm, and spring forward rocks us to our core. | spring-fword | Apr 01, 2014 |
| 1754795e-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | FDA Approves Oral Drug For Grass Allergy | None | Oralair was approved in the European Union in 2008 and is also sold in Canada, Australia and Russia for the treatment of. | grass-allergy-drug-oralair | Apr 01, 2014 |
| 17547bac-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Cooking Off the Cuff | Potato Pizza? Tarte Flambee? You Be the Judge | It's amazing how inspiring leftover spuds can be, don't you think. | cooking-off-the-cuff-pota | Apr 02, 2014 |
| 17544c22-21f8-11ec-bdf6-acde48001122 | PARENTING | Your Biological Clock Turns Cuckoo Earlier Than You Think | None | Knowledge, as they say, is power, and even if you're not seeing anyone special, staying on top of your fertility can only serve you in the long run. | your-biological-clock-turns-cuckoo-earlier-than-you-think | Apr 02, 2014 |
| 1754b0cc-21f8-11ec-bdf6-acde48001122 | PARENTING | Toddler Has No Clue This Basketball Hoop Is Actually Just A Cardboard Box | None | He shoots. | toddler-cardboard-basketball-hoop | Apr 03, 2014 |
| 1754731e-21f8-11ec-bdf6-acde48001122 | PARENTING | Probiotics Don't Reduce The Rate Of Colic In Babies (STUDY) | None | The probiotic also showed no benefits for family or maternal well-being, or infant sleep, and didn't alter the babies' gut. | probiotics-dont-help-babies-with-colic | Apr 03, 2014 |
| 1754eeac-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The Food Hall Revolution | None | Forget what you know about the food court; there's a new definition on the rise. | the-food-hall-revolution | Apr 03, 2014 |
| 1754bde2-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Wheelchair Wisdom | Keep Stillness Inside of You | Discovering the Calm and Stillness I came of age as part of the Woodstock generation and the Age of Aquarius, seeking a new. | wheelchair-wisdom-keep-st | Apr 04, 2014 |
| 1754eae2-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Autism Awareness and Advocacy in Our Community | None | While autism is a condition affecting people in all sectors of society, socioeconomic disparities influence its diagnosis and treatment among African-Americans. | autism-minorities | Apr 04, 2014 |
| 17544c90-21f8-11ec-bdf6-acde48001122 | PARENTING | Facebook Friends Help Diagnose A 3-Year-Old With Eye Disease | None | Two of Taylor's Facebook friends pointed that out and said something seemed off. | facebook-helps-3-year-old-with-eye-disease | Apr 04, 2014 |
| 17548aac-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | The AROMAFORK™ Will Make Your Food Taste Better. Seriously. | None | This could change everything. | aromafork | Apr 08, 2014 |
| 175459b0-21f8-11ec-bdf6-acde48001122 | PARENTING | Women Collaborate to Achieve Success | An Interview with Jen Mann | I've been writing professionally for a long time now, taking breaks here and there to procreate, and I can tell you that I would not be as far along in my career if it weren't for a network of women who have helped me along the way, just as I've helped them. | women-collaborate-to-achieve-success-an-interview-with-jen-mann | Apr 09, 2014 |
| 175497fe-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Are You Drinking Drugs? | None | Because the pharmaceuticals register in such small amounts -- measured in parts per billion, in some cases -- health officials aren't worried about the risk to humans. | drinking-water | Apr 09, 2014 |
| 1754a83e-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 10 Animals Who Remind Us To Stop And Smell The Roses | None | For more GPS Guides, click here. | stop-and-smell-the-roses | Apr 10, 2014 |
| 17542d5a-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Sriracha, Sapporo and 17 Other Food Brand Names You're Probably Mispronouncing | None | Is it Sa-POE-roe or SA-poe-roe. | sriracha-sapporo-and-17-m | Apr 10, 2014 |
| 17548b2e-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | High-Fat Diet Increases Breast Cancer Risk, Study Finds | None | Although the study indicates that as more saturated fat is consumed, the risk of breast cancer steadily rises, Hirshfield. | high-fat-diet-breast-cancer | Apr 10, 2014 |
| 17547a12-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | These Countries Are So Much Better Than America When It Comes To Work-Life Balance | None | In France, that concern is being taking seriously. | why-other-countries-are-s | Apr 11, 2014 |
| 1754887c-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Berry Coconut Frozen Yogurt | Leftovers Achieve Their Full Potential | Berry Coconut Frozen Yogurt is the flirty little sundress of desserts. | berry-coconut-frozen-yogurt | Apr 15, 2014 |
| 17548b6a-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Olive Oil-Thyme Bundt Cake With Candied Meyer Lemon Peels and Citrus Compote | None | Who doesn't love the look of a Bundt cake. | olive-oil-thyme-bundt-cak | Apr 15, 2014 |
| 1754a1fe-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | 19 Ideas For A Healthier Easter Basket | None | The Easter Bunny is the bearer of all things sweet, delicious and right with the world. | Unknown | Apr 16, 2014 |
| 1754b090-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | You've Been Cutting Tomatoes Wrong, But This Hack Shows You To Cut Them Like A Ninja (VIDEO) | None | You'll be face palming in no time. | cut-tomatoes-ninja-cooking-hack | Apr 16, 2014 |
| 1754b05e-21f8-11ec-bdf6-acde48001122 | LIFESTYLE | Yes, The Chia Seeds You Eat Are The Same Ones That Grow On Chia Pets | None | It's a little disturbing. | chia-seeds | Apr 17, 2014 |
| 1754772e-21f8-11ec-bdf6-acde48001122 | POLITICS | What Democrats Must Do to Win in November | None | This November, Democrats will have chance to reconnect with ethnic voters and win support from them while still courting other key groups. | what-democrats-must-do-to | Apr 19, 2014 |
| 17545b9a-21f8-11ec-bdf6-acde48001122 | BUSINESS | Top 5 Tips for Helping Lead a Productive and Happy Team | None | I am managing a team of 11. | top-five-tips-for-helping-leadership | Apr 28, 2014 |
| 17543ab6-21f8-11ec-bdf6-acde48001122 | BUSINESS | Class of 2014 | Tips for Renting Your First Post-Grad Apartment | You've got your diploma and a killer new job, now all you need to do is find a place to live. | class-of-2014-tips-for-re | May 16, 2014 |
| 175487c8-21f8-11ec-bdf6-acde48001122 | BUSINESS | Teens and the Summer Job | None | I've read articles knocking the teen sector for their lack of willingness to find a summer gig; but every young person I've encountered wants a summer job because they want money. | teens-and-the-summer-job | May 20, 2014 |
| 17546f18-21f8-11ec-bdf6-acde48001122 | POLITICS | Bring on the Prosperity! | None | On Monday, Obama will announce new rules to reduce carbon pollution from power plants. | bring-on-the-prosperity | May 30, 2014 |
| 1754fd02-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Stunting Stalls in Timor-Leste, Exposing 'Human Infrastructure' Investment Gap | None | A 2013 UNICEF report listed Timor-Leste as having the highest percentage of children under five who are moderately or severely stunted in the world, matched only by Burundi. | stunting-stalls-in-timorl | Jun 03, 2014 |
| 1754609a-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Fatah and Hamas | Spontaneous Combustion | Barely had the pictures of the Palestinian unity government been published, when skirmishes broke out around ATMs in Gaza between Hamas and Fatah government workers. | fatah-and-hamas-spontaneo | Jun 07, 2014 |
| 17548fe8-21f8-11ec-bdf6-acde48001122 | BUSINESS | Think Summer Hours Are Enough to Make People Happy? | None | While you may think giving your staff a couple of extra hours of free time a week is feeding their souls, you're wrong. | think-summer-hours-are-en | Jun 13, 2014 |
| 1754618a-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | The Party and the Army | Civil-Military Relations in Cuba | Today, eight ministries are led by career military officers, three of whom are still on active duty. | the-party-and-the-army-ci | Jun 26, 2014 |
| 17549dbc-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Youth, Television and What Might Keep Afghanistan from Ending up Like Iraq | None | Ever since the Islamic State of Iraq and Syria (ISIS) began their recent offensive in Iraq, anxieties about the potential of something similar taking place in Afghanistan have abounded. | youth-television-and-afghanistan | Jul 09, 2014 |
| 17547dbe-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | America Needs to Change Its Failed Iraq-Iran Policy | None | Preaching democratic values while engaging in supporting undemocratic and repressive regimes has never enhanced American credibility, and it has rarely been a successful security tactic in the long term. | america-needs-to-change-i | Jul 18, 2014 |
| 1754fd66-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Gaza and Palestinian Leadership | The More It Changes, the More it Gets Worse | Back in June, 1967, the second day of the Six Day War, I became the first foreign correspondent to enter Gaza City when Israeli troops took that forsaken piece of real estate from Egyptian control. | gaza-and-palestinian-leadership | Jul 22, 2014 |
| 1754b40a-21f8-11ec-bdf6-acde48001122 | BUSINESS | Your Career - Paved Road or Tall Grass? | None | Imagine a time in your career when the road ahead seems seems perfectly clear. | do-you-want-to-walk-a-pav | Jul 24, 2014 |
| 17549aec-21f8-11ec-bdf6-acde48001122 | BUSINESS | Dining Etiquette | 7 Foods Not To Order On A Job Interview | Pick and choose with caution. | dining-etiquette-7-foods-job-interview | Jul 30, 2014 |
| 17544ee8-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | On Centennial, Seven Harvard Scholars List Lessons of WWI -- And How They Might Apply Today | None | This week marks the centennial of the outbreak of World War I. | wwi-centennial-lessons | Jul 31, 2014 |
| 1754640a-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Mother Courage in Israel, Gaza, Iraq, Syria and the Ukraine | None | There's a disconnect between armies and ideologies and those who bear the burden of conflicts like those raging in Israel, Gaza, Iraq, Syria and the Ukraine. | mother-courage-in-israel- | Aug 07, 2014 |
| 1754ec7c-21f8-11ec-bdf6-acde48001122 | BUSINESS | Interruption Rich | None | When combined with multiple electronic communication systems an interruption-rich work environment is created. | interruption-rich | Aug 19, 2014 |
| 1754942a-21f8-11ec-bdf6-acde48001122 | BUSINESS | Being of Service | Why Meaning and Mission Matter in Business | Value is what attracts and retains customers and employees. | being-of-service-why-mean | Aug 20, 2014 |
| 1754a4ce-21f8-11ec-bdf6-acde48001122 | BUSINESS | Legacy Wars | Steve Jobs vs. Bill Gates | Not long ago, Malcolm Gladwell made a bold prediction: Fifty years from now, Apple will be around and Microsoft will be gone, but Bill Gates will be remembered -- and Steve Jobs won't. | legacy-wars-steve-jobs-vs | Aug 25, 2014 |
| 1754cb5c-21f8-11ec-bdf6-acde48001122 | BUSINESS | The Mysteries of Inequality Are Only Mysterious to Elites | None | We have the central bank of the US acting deliberately to keep workers from getting pay increases. | the-mysteries-of-inequali | Sep 23, 2014 |
| 1754c1e8-21f8-11ec-bdf6-acde48001122 | BUSINESS | Hardly Strictly Warren Hellman | A Bluegrass Hero and Civic Patron | For inspiration on how to manage the flexibility that accompanies Phase 4 of the Four Phases of Startup Life -- the What's Next. | hardly-strictly-warren-he | Sep 29, 2014 |
| 175476b6-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Remembering my Interview with Jean-Claude Duvalier | On the Occasion of His Death | Until the last minute I didn't believe it would happen. | remembering-my-interview- | Oct 06, 2014 |
| 1754cd78-21f8-11ec-bdf6-acde48001122 | BUSINESS | Protect Your Franchise from the Same Fate as McDonald's | None | The National Labor Relations Board's recent ruling labeling McDonald's as a joint employer of their franchisees struck a current of fear into most franchisors. | protect-your-franchise-fr | Oct 15, 2014 |
| 17547f44-21f8-11ec-bdf6-acde48001122 | BUSINESS | How to Have More Money, Time, Fun and Happiness, Overnight and Guaranteed! | None | Plan out your dream and then damn well go and do the dream because I think we're both adult enough to accept that planning dreams does little to nothing to make them come true if you don't also take now action on those dreams, yeah. | how-to-have-more | Oct 16, 2014 |
| 17546cb6-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Send in the Air Force Combat Controllers and Green Berets to Destroy ISIS. | None | As Rome (or at least Kobani) burns and faces the very real threat of a Srebrenica-style massacre, it is time for the US to stop fiddling and entertain the idea of putting small groups of US troops into the fray to empower our Kurdish peshmerga, Free Syrian Army and Iraqi government allies. | send-in-the-air-force-com | Oct 22, 2014 |
| 17548f34-21f8-11ec-bdf6-acde48001122 | BUSINESS | Embracing 'Showrooming' | None | You can't fight the Internet and you can't bite the hand that feeds you. | embracing-showrooming | Oct 23, 2014 |
| 17542eb8-21f8-11ec-bdf6-acde48001122 | POLITICS | If (When) Baghdad Falls, Keep American Soldiers Away From the Mess Created By Bush and Obama | None | With Iraq falling apart and a new enemy on the horizon that's simply a rebranding of the old one, there's a striking observation to be made about two presidents, Congress, and the leaders who send our soldiers off to war. | if-when-baghdad-falls-kee | Oct 24, 2014 |
| 17547f80-21f8-11ec-bdf6-acde48001122 | POLITICS | Is Bipartisanship Possible? | None | Voters in many communities continue to be subjected to wave after wave of negative political ads. | is-bipartisanship-possibl | Nov 01, 2014 |
| 17549c40-21f8-11ec-bdf6-acde48001122 | POLITICS | The Power of Your Vote | None | The Koch's tidal wave of money can corrupt our democracy, but we must not abet it with our silence. | the-power-of-your-vote | Nov 03, 2014 |
| 17545780-21f8-11ec-bdf6-acde48001122 | BUSINESS | Is Job Hunting During the Holidays a Waste of Time? | None | Because so many job seekers slack off during the end of the year, for the holidays or just because they have more to do in their personal lives, fewer job seekers go after every job. | is-job-hunting-during-the | Nov 06, 2014 |
| 17545352-21f8-11ec-bdf6-acde48001122 | BUSINESS | Super Majority Without The Super Power | None | Recognizing the power of the purse and the women who carry them should be a priority for companies if they are going to tap their respective market's full potential. | super-majority-without-th | Nov 11, 2014 |
| 17547c60-21f8-11ec-bdf6-acde48001122 | POLITICS | Illogical Logic of Our Iraq Policy | None | We are back again in Iraq except that this time we are also bombing another sovereign nation, Syria, to remove ISIS even though it is not a direct threat to the U.S., according to Joint Chiefs chairman General Dempsey. | reluctant-warrior | Nov 17, 2014 |
| 1754a87a-21f8-11ec-bdf6-acde48001122 | BUSINESS | AT&T's--REDACTED--to the FCC's Requests about--REDACTED--Fiber Optic Deployment--REDACTED. | None | AT&T must be investigated for its previous failures to fulfill basic commitments in prior mergers, especially the AT&T-BellSouth merger and the FCC should audit the new proposed fiber optic plans, not just take AT&T's word for it. | attsredactedto-the-fccs-r | Nov 28, 2014 |
| 17545b5e-21f8-11ec-bdf6-acde48001122 | BUSINESS | It's 2015. How Are We Still Having These Conversations? | None | The person kicking ass in a negotiation might have ovaries, but that doesn't require her to smile sweetly and make sure everyone is okay with the outcome of the deal. | its-2015-how-are-we-still | Dec 14, 2014 |
| 175496be-21f8-11ec-bdf6-acde48001122 | BUSINESS | Being Vulnerable in Business Can Be a Good Thing | None | Most of us fundamentally believe if we show the vulnerable side of ourselves, our clients, employees and partners won't want to work with us and our business will be seen as a failure. | being-vulnerable-in-business-can-be-a-good-thing | Dec 17, 2014 |
| 17548cc8-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | President Obama Has Created A Dangerous Precedent In Cuba | None | President Obama not only handed Castro a huge propaganda victory, but also created a dangerous precedent by signaling our enemies that major policy concessions can be gained by taking an American hostage. | hope-in-change-is-not-a-v | Jan 10, 2015 |
| 1754993e-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | PK -- A Masterstroke Off Hirani's Canvas | None | Khan and his versatility never fails to impress. | pk-a-masterstroke-off-hir | Jan 12, 2015 |
| 1754e4de-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Washington Is Well As Others Are Implicated In Their Wars | None | What was absent in President Barack Obama's State of the Union Address was more intriguing than what he mentioned, in relation to international conditions, and the positions of the United States on them. | washington-is-well-as-oth | Jan 23, 2015 |
| 1754f9ba-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Weekend Roundup | One Year On, The WorldPost Has 28 Million Monthly Views | The WorldPost was launched one year ago in Davos. | weekend-roundup-50 | Jan 24, 2015 |
| 1754461e-21f8-11ec-bdf6-acde48001122 | BUSINESS | Rupert Murdoch, Are You OK? | None | What is the billionaire media magnate trying to tell us. | rupert-murdoch-ambivalent-tweet-drama | Jan 27, 2015 |
| 17543ef8-21f8-11ec-bdf6-acde48001122 | BUSINESS | 32 Effective Formats to Package Your Systems | None | Have you ever been frustrated that your staff has ignored the step-by-step systems you created to lead them through a defined process. | 32-effective-formats-to-p | Jan 30, 2015 |
| 1754e54c-21f8-11ec-bdf6-acde48001122 | POLITICS | Will Congress OK War Without Limits? | None | The specter of the Islamic State has silenced congressional criticism and marginalized anti-war voices on the outside. | will-congress-ok-war-with | Feb 03, 2015 |
| 17549592-21f8-11ec-bdf6-acde48001122 | BUSINESS | Women in Business Q&A | Betsy Myers, Founding Director, Centre for Women and Business, Bentley University | Betsy Myers is the founding director of The Center for Women and Business at Bentley University. | women-in-business-qa-bets | Feb 07, 2015 |
| 1754ea7e-21f8-11ec-bdf6-acde48001122 | BUSINESS | Will the United States End Up Like Greece? The Risks of the Trans-Pacific Partnership | None | For years people have been running around Washington yelling that the United States was at risk of becoming Greece. | will-the-united-states-en | Feb 10, 2015 |
| 17544272-21f8-11ec-bdf6-acde48001122 | BUSINESS | From Uniform & Impersonal to Personalized and Targeted | None | Sports consumption is inherently personal, and ESPN has leveraged this to provide greater relevance for their user and a greater audience for their own content. | from-uniform-impersonal-t | Feb 10, 2015 |
| 17543bec-21f8-11ec-bdf6-acde48001122 | BUSINESS | Urban Headwinds, Suburban Tailwinds | None | Although home prices are rising faster in urban neighborhoods, population is growing faster in suburban neighborhoods. | urban-headwinds-suburban-tailwinds | Feb 11, 2015 |
| 175465ae-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Diversity Education to Promote Tolerance | None | While privileged and generally very expensive schools around the globe bank on diversity through both their internationally recognized curriculums and extracurricular activities like Model United Nations, the accessibility to such resources lacks in mainstream schools in most countries. | diversity-education-to-pr | Feb 16, 2015 |
| 1754ea42-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | From Megawatts to Gigawatts -- India's Swach Shakti Moment | None | So India can have its Swach Shakti moment, its gigawatts of solar and wind, its high performance urban development, its inclusive, low-carbon growth. | from-megawatts-to-gigawatts-indias-swach-shakti | Feb 21, 2015 |
| 1754f8d4-21f8-11ec-bdf6-acde48001122 | BUSINESS | Imagine Being Able To See The Doctor And Get Medicine At Work | None | At some companies an on-site clinic is already a reality. | doctor-at-work | Feb 25, 2015 |
| 17543f66-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | A Growing Rift Between Washington and the Gulf States on Yemen | None | Activity intensified over the past week at the United Nations with respect to the deteriorating situation in Yemen -- amid further evidence of a rift over the country's future between Washington and its traditional Gulf allies. | a-growing-rift-between-wa | Mar 01, 2015 |
| 17547490-21f8-11ec-bdf6-acde48001122 | BUSINESS | The Hottest Cars at the Geneva Auto Show | None | You can count on the semi-annual Geneva auto show to bring out the most outrageous pieces of automotive design. | the-hottest-cars-at-the-g | Mar 05, 2015 |
| 17547828-21f8-11ec-bdf6-acde48001122 | BUSINESS | What's Your R.O.T.? The More You Know, The More You Make | None | The other day I was tired. | whats-your-rot-the-more-y | Mar 17, 2015 |
| 175453ca-21f8-11ec-bdf6-acde48001122 | BUSINESS | One Hack That Turns a Loyal Customer Into a Lifelong Loyal Customer | None | Loyal customers are great. | one-hack-that-turns-a-loy | Mar 17, 2015 |
| 175456e0-21f8-11ec-bdf6-acde48001122 | BUSINESS | Top 80 US Real Estate Crowdfunding Sites Open New Doors in 2015 | None | The evolution of crowdfunding as a new investment vehicle in the US real estate industry has been remarkable in the past few years. | top-80-us-real-estate-cro | Mar 18, 2015 |
| 175443d0-21f8-11ec-bdf6-acde48001122 | BUSINESS | Women in Business Q&A | Naama Bloom, Founder and CEO, HelloFlo | Naama Bloom is the Founder and CEO of HelloFlo, an everyday health and wellness resource for women and girls with sponsorships in place with Tampax, Always, LUNA Bar, and others. | women-in-business-qa-naam | Apr 05, 2015 |
| 17542dfa-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | The Kenya Massacre | Why We Need One Global Democracy | What we need instead is rule of law in which everyone has a voice and a stake. | the-kenya-massacre-why-we | Apr 06, 2015 |
| 1754cd3c-21f8-11ec-bdf6-acde48001122 | BUSINESS | 10 Ways Freelance Life Is Different Than A Day Job | None | Wouldn't it be grand if you could trade in the tedious predictability of the 9-to-5 grind for 100 percent control of your efforts and the resulting profits, plus the authority to give yourself as much vacation time as you need. | 10-ways-freelance-life-is-different-than-a-day-job | Apr 07, 2015 |
| 17544448-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | The Impact of Energy on China/Myanmar Relations | None | The acquisition of energy has become a dominant influence in China's foreign policy orientation generally, and has been a driving force in its relationship with Myanmar in recent years. | the-impact-of-energy-of-c | Apr 14, 2015 |
| 17547044-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Yarmouk Camp, Anybody still there? | None | Sami was one of the pioneers of the revolution in a time when the revolution meant hope. | yarmouk-camp-anybody-stil | Apr 29, 2015 |
| 175477ec-21f8-11ec-bdf6-acde48001122 | BUSINESS | Executive Onboarding From a Subordinate's Perspective | None | Everything communicates -- everything a new leader says and does and doesn't say and doesn't do. | executive-onboarding-from | Apr 29, 2015 |
| 17547922-21f8-11ec-bdf6-acde48001122 | BUSINESS | What Stephen Curry Can Teach Entrepreneurs | None | Stephen Curry, like Google and Harvard, provide great examples on the significance of a wow-factor for budding entrepreneurs. | stephen-curry-provides-a- | Apr 29, 2015 |
| 17544a88-21f8-11ec-bdf6-acde48001122 | POLITICS | How Racism Is Destroying the Middle Class | None | While the Tea Party, and Republicans, have denied that their war on the poor isn't racially biased, they occasionally slip up. | how-racism-is-destroying- | May 04, 2015 |
| 1754ba5e-21f8-11ec-bdf6-acde48001122 | BUSINESS | The Rise and Fall of Krugmania in the UK | None | It is already conventional to name the former party leaders Ed Miliband, Nick Clegg and Nigel Farage as the biggest losers of the British general election. | the-rise-and-fall-of-krugmania-in-the-uk | May 11, 2015 |
| 1754a334-21f8-11ec-bdf6-acde48001122 | BUSINESS | 10 Common Mistakes Managers Make That Hurt Their Business | None | Fortunately (and unfortunately) many people that start and run a business often don't know the problems and difficulties they are likely to face. | 10-common-mistakes-managers-make-that-hurt-their-business | Jun 13, 2015 |
| 17547e68-21f8-11ec-bdf6-acde48001122 | BUSINESS | The Job Market | A Game of Musical Chairs Over Hot Coals | There's a common belief that people who don't have jobs somehow just aren't trying hard enough, and this belief is therefore based on the idea that there are enough jobs for everyone. | the-job-market-a-game-of- | Jun 15, 2015 |
| 17543a0c-21f8-11ec-bdf6-acde48001122 | BUSINESS | 8 Recruitment Myths Preventing You From Finding the Best | None | Employees are just as important to a business as the products and services being sold. | 8-recruitment-myths-preve | Jun 16, 2015 |
| 17548d40-21f8-11ec-bdf6-acde48001122 | BUSINESS | Living Local | The Rise of Local Currency | Look to any local high street at the moment and you will see an economy on the rise. | living-localthe-rise-of-l | Jun 30, 2015 |
| 17545c8a-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | The U.S. and China Should Not Risk War Over a "Damn Fool Thing" in the South China Sea | None | Some territorial claims are easy. | the-us-and-china-should-n | Jul 04, 2015 |
| 1754fb90-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Greek Financial Crisis Hits Poorest And Hungriest The Hardest | None | ATHENS — Behind the lace curtains of a soup kitchen run by a parish in the humble Athens neighborhood of Kerameikos, the. | Unknown | Jul 11, 2015 |
| 1754349e-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Serbian Prime Minister Attacked At Srebrenica Commemoration | None | SREBRENICA, Bosnia-Herzegovina (AP) — Anger boiled over Saturday at a massive commemoration of the slaughter of Bosnia Muslims. | serbian-prime-minister-attacked | Jul 11, 2015 |
| 17548e30-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Euro Zone Agrees To Move Forward With Bailout Loan For Greece | None | euro-zone-greece-bailout | Jul 13, 2015 | |
| 1754b5f4-21f8-11ec-bdf6-acde48001122 | POLITICS | Journalists Want Transparency, But Not Right Away | None | Reporters clash with open government advocates over the merits of a new FOIA policy. | journalists-foia-policy | Jul 14, 2015 |
| 1754b720-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Syria's Assad Gives First Public Address In A Year | None | BEIRUT (AP) — In his first public address in a year, embattled Syrian President Bashar Assad vowed Sunday to win his country's. | syria-assad-speech | Jul 26, 2015 |
| 17543700-21f8-11ec-bdf6-acde48001122 | POLITICS | Martin O'Malley Breaks Into Song At Iowa Campaign Event | None | The former Maryland governor serenaded supporters with a guitar performance. | martin-omalley-song | Jul 26, 2015 |
| 17548214-21f8-11ec-bdf6-acde48001122 | POLITICS | Are Ted Cruz's Super PACs Keeping Their Promise To Support Him? | None | One pro-Cruz super PAC donated to another Republican presidential candidate. | ted-cruzs-super-pacs-have-lots-of-money-but-who-do-they-support | Jul 31, 2015 |
| 1754b6e4-21f8-11ec-bdf6-acde48001122 | POLITICS | Hillary Clinton's Shifting Rhetoric On Coal Is A Departure From Her Coal Miner Roots | None | She walks a fine line between appeasing environmentalists and the coal industry. | hillary-clinton-coal | Aug 09, 2015 |
| 175478a0-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | 70 Years After the War | The Radio Broadcasts Of Ellis Zacharias, A Naval Captain Committed To Peace Between Japan And America | Who exactly was Captain Zacharias, beyond being fluent in Japanese and giving himself the title of official spokesman of the U.S. | 70-years-after-the-war-th | Aug 15, 2015 |
| 17547ea4-21f8-11ec-bdf6-acde48001122 | POLITICS | Protesters Confront John McCain During Visit To Navajo Capital | None | A Navajo teen now has what might be the most kick-ass profile picture on Facebook. | john-mccain-navajo-nation | Aug 17, 2015 |
| 17545064-21f8-11ec-bdf6-acde48001122 | POLITICS | Scott Walker And The Trouble With Obamacare 'Replacement' Plans | None | Repeal is one thing. | scott-walker-obamacare-replacement | Aug 18, 2015 |
| 1754846c-21f8-11ec-bdf6-acde48001122 | POLITICS | Joe Biden Meets With Elizabeth Warren Ahead Of Possible Presidential Campaign | Report | Biden is reportedly reaching out to potential people who could support his White House bid. | joe-biden-elizabeth-warren | Aug 22, 2015 |
| 17548156-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | ISIS Destroys Part Of Another Ancient Temple In Palmyra, Monitor Says | None | The Temple of Bel has reportedly been severely damaged. | isis-palmyra-temple-destroyed-bel | Aug 30, 2015 |
| 1754bf86-21f8-11ec-bdf6-acde48001122 | POLITICS | Three Rich Treasury Secretaries Laugh It Up Over Income Inequality | None | LOL. | geithner-rubin-paulson-income-inequality | Sep 04, 2015 |
| 1754c29c-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Experts Reject Mexican Government's Account Of Missing Students | None | The 43 students were abducted in the city of Iguala last September. | mexico-missing-students-report-rejected | Sep 06, 2015 |
| 175432be-21f8-11ec-bdf6-acde48001122 | POLITICS | Shooting Reported At Union Station Near Capitol Hill | None | shooting-union-station | Sep 11, 2015 | |
| 17549eac-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Egypt's Government Resigns Amid Corruption Probe | None | CAIRO (AP) — Egypt's government resigned Saturday in the face of intense criticism from state-friendly media that reflects. | egypt-government-resigns | Sep 12, 2015 |
| 17544236-21f8-11ec-bdf6-acde48001122 | BUSINESS | 9 Books For People Who Need Job Advice But Hate Advice Books | None | Enjoy. | 9-book-to-get-you-through-your-first-job | Sep 22, 2015 |
| 17546edc-21f8-11ec-bdf6-acde48001122 | BUSINESS | Public Markets Are Great Equalizers In An Age Of Inequality | None | Markets are some of the few remaining places where people of different economic classes still interact. | public-markets-inequality | Sep 26, 2015 |
| 1754c742-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | France Fires First Airstrikes On Islamic State In Syria | None | PARIS (AP) — Six French jet fighters targeted and destroyed an Islamic State training camp in eastern Syria, President Francois. | france-fires-first-airstrikes-on-islamic-state-in-syria | Sep 27, 2015 |
| 1754c99a-21f8-11ec-bdf6-acde48001122 | POLITICS | Jeb Bush Just Gave A Middle Finger To The Entire Native American Community | None | Bush says the name of Dan Snyder's team isn't offensive to him. | jeb-bush-native-americans | Sep 30, 2015 |
| 1754c7b0-21f8-11ec-bdf6-acde48001122 | POLITICS | Justice Breyer Couldn't Save Richard Glossip, But He Won The Day Anyway | None | Oklahoma's disastrous lethal-injection protocol shows he was right about the death penalty all along. | stephen-breyer-richard-glossip-death-penalty | Oct 03, 2015 |
| 17549880-21f8-11ec-bdf6-acde48001122 | POLITICS | Watch Robert Kennedy Push Gun Control In Same Town As Recent Mass Shooting | None | Two weeks before he was assassinated, he addressed gun violence on the campaign trail. | robert-kennedy-gun-control-roseburg | Oct 05, 2015 |
| 1754a8e8-21f8-11ec-bdf6-acde48001122 | POLITICS | Ten Commandments Monument Removed From Oklahoma Capitol Grounds | None | Workers removing the monument were protected by a heavy security presence. | oklahoma-ten-commandments | Oct 06, 2015 |
| 17546e5a-21f8-11ec-bdf6-acde48001122 | POLITICS | Homeland Security Secretary Says Border Wall And Fearmongering Are 'Not The Answer' On Immigration | None | Deportation numbers are down, but that doesn't mean immigration enforcement is lying down on the job, he says. | jeh-johnson-immigration-border-wall | Oct 07, 2015 |
| 1754866a-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | ISIS Leader Survives Attack By Iraqi Air Force | None | Eight other senior figures in ISIS were reported killed. | isis-leaders-convoy-hit-by-iraqi-air-force | Oct 11, 2015 |
| 1754fa1e-21f8-11ec-bdf6-acde48001122 | POLITICS | Democrats And Independents Are Starting To Like John Boehner Now That He's Leaving | None | Republicans, not so much. | john-boehner-democrats-polls | Oct 16, 2015 |
| 1754faaa-21f8-11ec-bdf6-acde48001122 | BUSINESS | 4-Year-Old Obsessed With CVS Just Got A Birthday Party She'll Never Forget | None | This is pretty darn cute. | cvs-birthday-party-iris-gill | Oct 20, 2015 |
| 1754a5be-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Death Toll In Romania Fire Rises To 41, Ex-Mayor Arrested | None | BUCHAREST, Nov 7 (Reuters) - Nine people died on Saturday from injuries sustained in a fire at a nightclub in Romania eight. | romania-fire-kills-41-former-mayor-arrested | Nov 07, 2015 |
| 17542ef4-21f8-11ec-bdf6-acde48001122 | POLITICS | Rubio's Mysterious Credit Card Data Revealed | None | WASHINGTON, Nov 7 (Reuters) - Presidential candidate Marco Rubio put more than $7,000 in personal expenses on a Republican. | marco-rubio-credit-card-data-revealed | Nov 08, 2015 |
| 17543192-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Deadly Paris Attacks Come Amid Rising Religious Tension In France | None | As violent incidents increase, so do claims of anti-Muslim laws and views in the nation. | paris-attacks-religion | Nov 14, 2015 |
| 1754b4be-21f8-11ec-bdf6-acde48001122 | POLITICS | Black Americans Twice As Likely To Report Force In Last Police Encounter | None | The feds will now track how police departments handle citizen complaints. | use-of-force-statistics-doj | Nov 16, 2015 |
| 17548af2-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Man Arrested On Flight After Threatening To Open Plane Door | None | A Serbian handball team helped detain him. | lufthansa-plane-arrest-door | Dec 06, 2015 |
| 17543246-21f8-11ec-bdf6-acde48001122 | BUSINESS | 9 Idiotic Office Rules That Drive Everyone Insane | None | Companies need to have rules--that's a given--but they don't have to be shortsighted and lazy attempts at creating order. | 9-idiotic-office-rules-th | Dec 12, 2015 |
| 1754cdbe-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | As More Borders Close, Families Rush For Refuge | None | There is now an urgency that has filled the boats from Turkey with more women and children. | susan-sarandon-mother-children | Dec 25, 2015 |
| 1754c5da-21f8-11ec-bdf6-acde48001122 | WORLD NEWS | Belgian Police Investigate Alleged Orgy During Terror Lockdown | None | While authorities searched for suspected Paris attackers, two police officers and eight soldiers allegedly had sex together. | belgian-solider-orgy-terror | Dec 30, 2015 |
%%nose
last_output = _
import pandas as pd
pd.set_option("max_colwidth", 5000)
import numpy as np
import re
from pandas.api.types import is_numeric_dtype
# Create DataFrames
test_solution = pd.read_csv('datasets/news_sol.csv')
student_result = last_output.DataFrame()
def test_resultset():
try:
# Check whether the answer has been saved and is a SQL ResultSet
assert str(type(last_output)) == "<class 'sql.run.ResultSet'>"
except AssertionError:
assert False, 'Please ensure a SQL ResultSet is the output of the challenge.'
def test_project():
# Function to test mixed columns
def test_mixed_column(test_ages, student_ages):
eval_list = []
for x, y in zip(test_ages, student_ages):
try:
eval_list.append(abs(int(x) - int(y)) <= 1)
except:
eval_list.append(str(x) == str(y))
return np.array(eval_list).all()
# Having identified the existence of the ResultSet and transformed into a DF,
# convert all the column names to lower-case
test_solution.columns = [x.lower() for x in test_solution.columns.tolist()]
student_result.columns = [x.lower() for x in student_result.columns.tolist()]
# Some fixes for problems with the data when it's converted to a DataFrame (for some reason)
student_result.subtitle.fillna('None', inplace=True)
for col in ('subtitle', 'description'):
student_result[col] = student_result[col].str.strip()
student_result['description'] = student_result.description.str.replace('\xa0', ' ')
student_result['description'] = student_result.description.str.replace(' ', ' ')
# For each column in the DataFrame, ensure it's in the test_solution DataFrame
assert len(student_result) == 188, \
'Your SQL ResultSet does not contain the expected number of rows!'
assert all([x in test_solution.columns for x in student_result.columns]), \
'Your SQL ResultSet is missing the required columns!'
# Check whether the values (converted to an integer) contain in the only column are correct
for col in test_solution.columns.tolist():
if col != "publish_date":
assert (test_solution[col].values == student_result[col].values).all(),\
'The values in your SQL ResultSet do not match the solution!'
# For the date column, remove the spaces so that's not what trips people up
else:
assert (test_solution[col].str.replace(" ", "", regex=False).values == \
student_result[col].str.replace(" ", "", regex=False).values).all(),\
'The values in your SQL ResultSet do not match the solution!'
1/2 tests passed; 1 failed
========
__main__.test_project
========
Traceback (most recent call last):
File "/usr/lib/python3.6/unittest/case.py", line 59, in testPartExecutor
yield
File "/usr/lib/python3.6/unittest/case.py", line 605, in run
testMethod()
File "/usr/local/lib/python3.6/dist-packages/nose/case.py", line 198, in runTest
self.test(*self.arg)
File "<string>", line 52, in test_project
AssertionError: The values in your SQL ResultSet do not match the solution!