text:
Q: Insert a dict into a sql table i wanted to insert some data into my sql but having trouble because there is alot of columns so i would have to write alot of parameters after VALUE. I have a table with all attributes from the json file and a player_id which i add myself
#Gamelogs for players and Teams
import requests
import json
import psycopg2

# Connect to your postgres DB
conn = psycopg2.connect("dbname=NBA user=postgres password=********")

# Open a cursor to perform database operations
cur = conn.cursor()
cur.execute('CREATE TABLE player_logs("player_id" int,"GameId" int,"Date" int,"Team" VARCHAR(10),"Opponent" VARCHAR(10),"Minutes" int,"Arc3Assists" int,"Arc3FGA" int,"Arc3Frequency" int,"AssistPoints" int,"Assists" int,"AtRimAssists" int,"AtRimFG3AFrequency" int,"Avg2ptShotDistance" int,"Avg3ptShotDistance" int,"BadPassOutOfBoundsTurnovers" int,"BadPassSteals" int,"BadPassTurnovers" int,"Corner3FGA" int,"Corner3Frequency" int,"DeadBallTurnovers" int,"DefArc3ReboundPct" int,"DefFGReboundPct" int,"DefPoss" int,"DefRebounds" int,"DefThreePtReboundPct" int,"DefThreePtRebounds" int,"EfgPct" int,"FG2A" int,"FG2M" int,"FG3A" int,"FG3APct" int,"FTA" int,"Fg2Pct" int,"FirstChancePoints" int,"Fouls" int,"FoulsDrawn" int,"FtPoints" int,"LiveBallTurnoverPct" int,"LiveBallTurnovers" int,"LongMidRangeAccuracy" int,"LongMidRangeAssists" int,"LongMidRangeFGA" int,"LongMidRangeFGM" int,"LongMidRangeFrequency" int,"Loose Ball Fouls" int,"LostBallTurnovers" int,"NonHeaveArc3FGA" int,"OffFGReboundPct" int,"OffPoss" int,"OffRebounds" int,"OffShortMidRangeReboundPct" int,"OffTwoPtReboundPct" int,"OffTwoPtRebounds" int,"OnDefRtg" int,"OnOffRtg" int,"PenaltyArc3FGA" int,"PenaltyArc3Frequency" int,"PenaltyDefPoss" int,"PenaltyEfgPct" int,"PenaltyFG2A" int,"PenaltyFG2M" int,"PenaltyFG3A" int,"PenaltyFg2Pct" int,"PenaltyOffPoss" int,"PenaltyOffPossExcludingTakeFouls" int,"PenaltyOffPossPct" int,"PenaltyPoints" int,"PenaltyPointsExcludingTakeFouls" int,"PenaltyPointsPct" int,"PenaltyShotQualityAvg" int,"PenaltyTsPct" int,"PenaltyTurnovers" int,"Period2Fouls2Minutes" int,"Period3Fouls3Minutes" int,"PlusMinus" int,"Points" int,"PtsUnassisted2s" int,"Rebounds" int,"SecondChanceOffPoss" int,"SelfOReb" int,"SelfORebPct" int,"ShootingFouls" int,"ShootingFoulsDrawnPct" int,"ShortMidRangeAccuracy" int,"ShortMidRangeAssists" int,"ShortMidRangeFGA" int,"ShortMidRangeFGM" int,"ShortMidRangeFrequency" int,"ShortMidRangeOffReboundedPct" int,"ShotQualityAvg" int,"Steals" int,"ThreePtAssists" int,"TotalPoss" int,"TsPct" int,"Turnovers" int,"TwoPtAssists" int,"TwoPtShootingFoulsDrawn" int,"TwoPtShootingFoulsDrawnPct" int,"UnblockedLongMidRangeAccuracy" int,"UnblockedShortMidRangeAccuracy" int,"Usage" int,"Arc3Accuracy" int,"Arc3FGM" int,"Arc3PctAssisted" int,"Assisted2sPct" int,"Assisted3sPct" int,"AtRimAccuracy" int,"AtRimFGA" int,"AtRimFGM" int,"AtRimFrequency" int,"AtRimOffReboundedPct" int,"AtRimPctBlocked" int,"Blocked2s" int,"BlockedShortMidRange" int,"Blocks" int,"BlocksRecoveredPct" int,"Corner3Assists" int,"DefAtRimReboundPct" int,"DefLongMidRangeReboundPct" int,"DefShortMidRangeReboundPct" int,"DefTwoPtReboundPct" int,"DefTwoPtRebounds" int,"FG2APctBlocked" int,"FG3M" int,"Fg2aBlocked" int,"Fg3Pct" int,"LongMidRangeOffReboundedPct" int,"LostBallSteals" int,"NonHeaveArc3Accuracy" int,"NonHeaveArc3FGM" int,"NonHeaveFg3Pct" int,"NonPutbacksAssisted2sPct" int,"NonShootingFoulsDrawn" int,"NonShootingPenaltyNonTakeFoulsDrawn" int,"OffLongMidRangeReboundPct" int,"Offensive Fouls Drawn" int,"PenaltyArc3Accuracy" int,"PenaltyArc3FGM" int,"PenaltyAtRimAccuracy" int,"PenaltyAtRimFGA" int,"PenaltyAtRimFGM" int,"PenaltyAtRimFrequency" int,"PenaltyFG3M" int,"PenaltyFg3Pct" int,"PenaltyFtPoints" int,"PtsAssisted2s" int,"PtsAssisted3s" int,"PtsPutbacks" int,"PtsUnassisted3s" int,"RecoveredBlocks" int,"SecondChanceArc3FGA" int,"SecondChanceArc3Frequency" int,"SecondChanceEfgPct" int,"SecondChanceFG2A" int,"SecondChanceFG2M" int,"SecondChanceFG3A" int,"SecondChanceFg2Pct" int,"SecondChancePoints" int,"SecondChancePointsPct" int,"SecondChanceShotQualityAvg" int,"SecondChanceTsPct" int,"ShortMidRangePctAssisted" int,"ShortMidRangePctBlocked" int,"ThreePtShootingFoulsDrawn" int,"ThreePtShootingFoulsDrawnPct" int,"UnblockedArc3Accuracy" int,"UnblockedAtRimAccuracy" int,"OffArc3ReboundPct" int,"OffThreePtReboundPct" int,"OffThreePtRebounds" int,"Offensive Fouls" int,"Corner3Accuracy" int,"Corner3FGM" int,"ThreePtOffReboundedPct" int,"UnblockedCorner3Accuracy" int,"DefFTReboundPct" int,"FTDefRebounds" int,"Technical Free Throw Trips" int,"BlockedAtRim" int,"LostBallOutOfBoundsTurnovers" int,"OffAtRimReboundPct" int,"BlockedLongMidRange" int,"Charge Fouls Drawn" int,"LongMidRangePctAssisted" int,"NonShootingPenaltyNonTakeFouls" int,"SecondChanceTurnovers" int,"Travels" int,"SecondChanceAtRimFGA" int,"SecondChanceAtRimFrequency" int,"Clear Path Fouls" int,"DefCorner3ReboundPct" int,"HeaveAttempts" int,"LongMidRangePctBlocked" int,"2pt And 1 Free Throw Trips" int,"AtRimPctAssisted" int,"Period3Fouls4Minutes" int,"Period4Fouls4Minutes" int,"Charge Fouls" int,"Loose Ball Fouls Drawn" int,"PeriodOTFouls4Minutes" int,"SecondChanceAtRimAccuracy" int,"SecondChanceAtRimFGM" int,"PenaltyCorner3FGA" int,"PenaltyCorner3Frequency" int,"Corner3PctAssisted" int,"SecondChanceFtPoints" int,"OffCorner3ReboundPct" int,"SecondChanceArc3Accuracy" int,"SecondChanceArc3FGM" int,"SecondChanceFG3M" int,"SecondChanceFg3Pct" int,"3pt And 1 Free Throw Trips" int,"Defensive 3 Seconds Violations" int,"Period4Fouls5Minutes" int,"StepOutOfBoundsTurnovers" int,"Period1Fouls2Minutes"int)')
x = 'https://api.pbpstats.com/get-all-players-for-league/nba'
headers = {'user-agent': 'Chrome/88.0.4324.190'}
jsonData1 = requests.get(x, headers=headers).json() # Player id and name

EntityId = json.loads(json.dumps(jsonData1)[12:-1])
SeasonType = {'R':'Regular+Season','P':'Playoff+Season','A':'All'}
EntityType = {'P':'Player','T':'Team'}
Season = {
            '2008-09',
            '2009-10',
            '2010-11',
            '2011-12',
            '2012-13',
            '2013-14',
            '2014-15',
            '2015-16',
            '2016-17',
            '2017-18',
            '2018-19',
            '2019-20',
            '2020-21'
            }
def log (S:Season,ST:SeasonType,EI:EntityId,ET:EntityType):
    url = 'https://api.pbpstats.com/get-game-logs/nba'
    payload = {
                'Season': S,
                'SeasonType': ST,
                'EntityId': EI,
                'EntityType': ET
                }
    r = requests.get(url, headers=headers, params=payload).json()
    if r == {'error': 'no results'} :
        return()
    else :
        for c in r['multi_row_table_data']:
            j = {'Player_id':EI}
            c.update(j)
            cur.execute('INSERT INTO player_log (Player_id,GameId,Date,Team,Opponent,Minutes,Arc3Assists,Arc3FGA,Arc3Frequency,AssistPoints,Assists,AtRimAssists,AtRimFG3AFrequency,Avg2ptShotDistance,Avg3ptShotDistance,BadPassOutOfBoundsTurnovers,BadPassSteals,BadPassTurnovers,Corner3FGA,Corner3Frequency,DeadBallTurnovers,DefArc3ReboundPct,DefFGReboundPct,DefPoss,DefRebounds,DefThreePtReboundPct,DefThreePtRebounds,EfgPct,FG2A,FG2M,FG3A,FG3APct,FTA,Fg2Pct,FirstChancePoints,Fouls,FoulsDrawn,FtPoints,LiveBallTurnoverPct,LiveBallTurnovers,LongMidRangeAccuracy,LongMidRangeAssists,LongMidRangeFGA,LongMidRangeFGM,LongMidRangeFrequency,Loose_Ball_Fouls,LostBallTurnovers,NonHeaveArc3FGA,OffFGReboundPct,OffPoss,OffRebounds,OffShortMidRangeReboundPct,OffTwoPtReboundPct,OffTwoPtRebounds,OnDefRtg,OnOffRtg,PenaltyArc3FGA,PenaltyArc3Frequency,PenaltyDefPoss,PenaltyEfgPct,PenaltyFG2A,PenaltyFG2M,PenaltyFG3A,PenaltyFg2Pct,PenaltyOffPoss,PenaltyOffPossExcludingTakeFouls,PenaltyOffPossPct,PenaltyPoints,PenaltyPointsExcludingTakeFouls,PenaltyPointsPct,PenaltyShotQualityAvg,PenaltyTsPct,PenaltyTurnovers,Period2Fouls2Minutes,Period3Fouls3Minutes,PlusMinus,Points,PtsUnassisted2s,Rebounds,SecondChanceOffPoss,SelfOReb,SelfORebPct,ShootingFouls,ShootingFoulsDrawnPct,ShortMidRangeAccuracy,ShortMidRangeAssists,ShortMidRangeFGA,ShortMidRangeFGM,ShortMidRangeFrequency,ShortMidRangeOffReboundedPct,ShotQualityAvg,Steals,ThreePtAssists,TotalPoss,TsPct,Turnovers,TwoPtAssists,TwoPtShootingFoulsDrawn,TwoPtShootingFoulsDrawnPct,UnblockedLongMidRangeAccuracy,UnblockedShortMidRangeAccuracy,Usage,Arc3Accuracy,Arc3FGM,Arc3PctAssisted,Assisted2sPct,Assisted3sPct,AtRimAccuracy,AtRimFGA,AtRimFGM,AtRimFrequency,AtRimOffReboundedPct,AtRimPctBlocked,Blocked2s,BlockedShortMidRange,Blocks,BlocksRecoveredPct,Corner3Assists,DefAtRimReboundPct,DefLongMidRangeReboundPct,DefShortMidRangeReboundPct,DefTwoPtReboundPct,DefTwoPtRebounds,FG2APctBlocked,FG3M,Fg2aBlocked,Fg3Pct,LongMidRangeOffReboundedPct,LostBallSteals,NonHeaveArc3Accuracy,NonHeaveArc3FGM,NonHeaveFg3Pct,NonPutbacksAssisted2sPct,NonShootingFoulsDrawn,NonShootingPenaltyNonTakeFoulsDrawn,OffLongMidRangeReboundPct,Offensive_Fouls_Drawn,PenaltyArc3Accuracy,PenaltyArc3FGM,PenaltyAtRimAccuracy,PenaltyAtRimFGA,PenaltyAtRimFGM,PenaltyAtRimFrequency,PenaltyFG3M,PenaltyFg3Pct,PenaltyFtPoints,PtsAssisted2s,PtsAssisted3s,PtsPutbacks,PtsUnassisted3s,RecoveredBlocks,SecondChanceArc3FGA,SecondChanceArc3Frequency,SecondChanceEfgPct,SecondChanceFG2A,SecondChanceFG2M,SecondChanceFG3A,SecondChanceFg2Pct,SecondChancePoints,SecondChancePointsPct,SecondChanceShotQualityAvg,SecondChanceTsPct,ShortMidRangePctAssisted,ShortMidRangePctBlocked,ThreePtShootingFoulsDrawn,ThreePtShootingFoulsDrawnPct,UnblockedArc3Accuracy,UnblockedAtRimAccuracy,OffArc3ReboundPct,OffThreePtReboundPct,OffThreePtRebounds,Offensive_Fouls,Corner3Accuracy,Corner3FGM,ThreePtOffReboundedPct,UnblockedCorner3Accuracy,DefFTReboundPct,FTDefRebounds,Technical_Free_Throw_Trips,BlockedAtRim,LostBallOutOfBoundsTurnovers,OffAtRimReboundPct,BlockedLongMidRange,Charge_Fouls_Drawn,LongMidRangePctAssisted,NonShootingPenaltyNonTakeFouls,SecondChanceTurnovers,Travels,SecondChanceAtRimFGA,SecondChanceAtRimFrequency,Clear_Path_Fouls,DefCorner3ReboundPct,HeaveAttempts,LongMidRangePctBlocked,"2pt_And_1_Free_Throw_Trips",AtRimPctAssisted,Period3Fouls4Minutes,Period4Fouls4Minutes,Charge_Fouls,Loose_Ball_Fouls_Drawn,PeriodOTFouls4Minutes,SecondChanceAtRimAccuracy,SecondChanceAtRimFGM,PenaltyCorner3FGA,PenaltyCorner3Frequency,Corner3PctAssisted,SecondChanceFtPoints,OffCorner3ReboundPct,SecondChanceArc3Accuracy,SecondChanceArc3FGM,SecondChanceFG3M,SecondChanceFg3Pct,"3pt_And_1_Free_Throw_Trips",Defensive_3_Seconds_Violations,Period4Fouls5Minutes,StepOutOfBoundsTurnovers,Period1Fouls2Minutes) VALUES',
                        c)
    return()

y=log('2020-21','Regular+Season','101108','Player')

conn.commit()
conn.close()
cur.close()

So was wondering if i could insert the data so it matched with the key and the column name. So the table and dict isnt order the same way either if it makes a difference.

A: This is fairly simple to do by adopting two helper libraries: pandas and preql.
You can use pandas to load the json into a single dataframe, and then use preql to import it into the database.
Here is runnable code demonstrating how to do it:
import requests
import pandas as pd
from preql import Preql

headers = {'user-agent': 'Chrome/88.0.4324.190'}

def log(S,ST,EI,ET):
    url = 'https://api.pbpstats.com/get-game-logs/nba'
    payload = {
                'Season': S,
                'SeasonType': ST,
                'EntityId': EI,
                'EntityType': ET
                }
    r = requests.get(url, headers=headers, params=payload).json()
    if r == {'error': 'no results'} :
        return
    else:
        return [{'Player_id':EI, **d} for d in r['multi_row_table_data']]

rows=log('2020-21','Regular+Season','101108','Player')
df = pd.DataFrame.from_dict(rows)
print("Dataframe shape:", df.shape) # (50, 218)

p = Preql()     # For postgres use: p = Preql("postgres://user:pass@server")
p.import_pandas(my_table=df)

print('SQL columns:', p('count(columns(my_table))'))       # 219 - includes id
print('SQL rows:', p('count(my_table)'))                   # 50

Note that this code example is currently using Python's built-in Sqlite, but you can easily make it work with postgres by providing Preql with the postgres URL, as the comment shows.
Install them with pip install pandas preql-lang

A: Might not be the best solution, but I wrote a small function that just converts to SQL statement.
def insert_into_table_query(table, data):
    col_names = list(data.keys())
    task = tuple(data.values())

    col_str = ', '.join(str(item) for item in col_names)
    col_str = '(' + col_str + ')'

    value_str = ', '.join('%s' for item in task)
    value_str = '(' + value_str + ');'

    sql = 'INSERT INTO {tn} '.format(tn=table) + col_str + ' VALUES ' + value_str

    return (sql, task)


text:
Home News DeSantis vows to veto latest GOP-proposed congressional boundaries in Florida
DeSantis vows to veto latest GOP-proposed congressional boundaries in Florida
Over the objections of DeSantis, a Republican who publicly vowed to veto their work, the GOP-controlled House and Senate passed new congressional boundaries Friday that would reshape the political landscape in Florida for the next decade. In an unusual step, state lawmakers approved two maps: one that draws new boundaries to a more Republican advantage and one that is closer to the status quo. If the first map is not approved by the state Supreme Court, then the second safer map would be implemented.
"What makes you think when I say I'm going to do something that I'm not going to follow through?" DeSantis said at a news conference in Jacksonville. "I don't make declarations lightly."
"I don't bluff," he added.
The House passed the maps 67-47, with some Republicans voting against the new boundaries. The Senate vote was 24-15.
The showdown over the maps is a rare public power struggle between DeSantis and the Florida Legislature, which has almost always ceded to the governor and his agenda during his tenure in office.
DeSantis has urged lawmakers in his party to get behind a much more partisan map, one that could give Republicans the advantage in at least 18 of the 28 districts in the state, and as many as 20. His insistence echoes similar calls from Republican operatives that want to see the GOP press its advantage in hopes of helping the party win a majority in the US House this fall.
Florida Republicans currently hold 16 seats in the US House to 11 for the Democrats. The state gained a seat in redistricting and will have 28 House seats for the next decade.
But Republican state lawmakers have stood by their work, insisting their maps are constitutionally sound.
"The two-map solution is a creative solution that captures the feedback of all our stakeholders: the public, the members of this chamber and the Governor," said state Rep. Tyler Sirois, the chairman of the House Congressional Redistricting Subcommittee.
DeSantis, meanwhile, has pushed for lawmakers to break up two of four Black-access districts in what Democrats say is a violation of the Voting Rights Act and the state's Fair District amendment to its constitution.
State Sen. Janet Cruz, a Tampa Democrat, said the governor's threats to lawmakers were "a stain in this whole process."
DeSantis has inserted himself into the state's once-in-a-decade redistricting process far more than any of his predecessors, even going so far as to submit his own maps for consideration. He has repeatedly said he would veto any map that does not reapportion Florida's 5th Congressional District, a Black plurality seat that stretches across north Florida to connect African American communities in Tallahassee and Jacksonville. The district is represented by Democratic Rep. Al Lawson, who is Black. DeSantis would also break up an Orlando-area district represented by Rep. Val Demings, who is also Black.
DeSantis believes Lawson's district represents an unconstitutional gerrymander, even though it was approved by the state Supreme Court last decade.
If DeSantis vetoes the maps, then the Legislature could override him with two-thirds of the vote. If state lawmakers cannot come to agreement on a map, then they could kick the fight to the state Supreme Court.
Florida is one of four states that have yet to finalize their congressional maps.
DeSantis vows to veto latest GOP-proposed congressional boundaries in Florida - CNNPolitics
Previous articleReal estate workforce growth outshines others in February
Next articleAnalysis: The push to ban Russian oil is gaining steam. Here's what that means for US energy prices

redpajama_set_name: RedPajamaCommonCrawl


Just put your details below and click REGISTER.
When you register your institution on yaaka, you can put up courses that you can charge for students to access. You can sell your courses individually or in modules/ batches.
Your role as an education institution is to put up courses, engage students so they learn well and understand, provide and mark assignments and quizzes and give feedback.
Your skills and knowledge can reach and benefit many more people who will become better academically, economically and socially when they learn from you from wherever they are are.
In addition to putting up courses for free access to to be paid, you can become a sought after institution because of the interactive courses you put here.


text:
Saskia Reeves Interview: The Journeys & Joys of Making "Us"
Starring alongside Tom Hollander in Us, actor Saskia Reeves brings a wry spirit to the role of artist, mom, and aspiring singleton Connie Peterson. Find out what this frequent MASTERPIECE alum, whose diverse and memorable turns include Roadkill, The Child in Time, Wolf Hall, and more, thought about her unique character, plus what it was like making the bittersweet dramedy in a whirlwind tour of some of Europe's greatest cities. You may even learn a travel tip or two! Missed Us or want to watch it again? Stream the entire miniseries with PBS Passport, an added member benefit.
Masterpiece:
While the characters of Us are very specific, the show portrays a universal span of a family relationship: romance, the discovery of young love, the shared project of child rearing, and then those uncomfortable unknowns that lie ahead after the children have grown. Can speak to its universality?
Saskia Reeves:
There's a horrible phrase, "empty nesters," isn't there? The teenager leaves and suddenly you're staring across at your partner going, "What the hell of we got in common with each other?" So on one very stereotypical level, I think that's what's going on here. But you've got quite a few dysfunctional relationships, especially the father and the son, who have very different interests, which in itself is universal at this point, when kids are 18, 19 years old. I have a 19-year-old and a 15-year-old, and it's difficult being a parent, especially with the older child, because I've never been a parent to a 19-year-old before; I don't know what it's like.
I think a lot of people feel like that, and they see themselves in this series, and [novelist and screenwriter] David Nicholls has so beautifully written the language that we use with our children. But then, when you're watching it subjectively and see it from the child's point of view, you go, "Oh my God, that's a terrible thing to say to your child!" There's one scene I find particularly painful, where Douglas storms into Albie's room, opens the window, and is like, "Have the birds been smoking cigarettes again?" And you think, "But he's just chilling out in his bedroom and you barged in like it's your property!" And then, "How many times have I done that, in those initial stages of his young adulthood, where I've still treated him like he's 15 or 13?" I think everybody in this family is learning about how they're all changing, and how they're all growing. Are they going to stay together? Albie is about to leave for college: Is he going to ever speak to his dad again? Especially the way Douglas regards the course [of study] that Albie is doing—that's universal, isn't it, that you don't understand your child? My son loves to play computer games and I try and try and try to be interested, but there is a part of me where I do not get it, I don't. But you have to keep that to yourself, really. Because what do I know?
In the scene you describe, where Douglas barges into the room, it does seem like a violation, but I also understood Douglas' position. And that nuance runs through the DNA of this show, and makes each character so sympathetic, even if they're behaving badly.
I think what the series tries to do is say that there isn't a good or bad person, there isn't a side to take, actually, because we are all in each of these characters. They're not bad people. I think the difficulty with this story is that nothing really bad has happened—he didn't have a raging affair with somebody half his age, or she hasn't got a drink problem (or she does, actually, but anyway…). They're just getting on with life and dealing with the loss of a child, years ago, which I know had such a profound, disturbing, impact on Connie that everything after that was different.
If you had any advice for young Connie, what might it be?
Stop drinking, I would say. Because maybe then she could commit to herself, and to the people she gets involved with, a bit better. She could maybe really understand who she wants to be with. And also, to not give up the art, to not stop, because as any artist knows, perseverance is what you need.
I think Connie was a very, very under-confident artist and a very chaotic person. David [Nicholls] talks in his book about her family life before she meets Douglas, and I always saw her upbringing as one of the reasons she chose so many inappropriate boyfriends, and perhaps why she liked to get obliterated quite a lot and to numb herself in some way. She always wants to be having a great time, but she didn't have a lot of self-confidence. Then Douglas comes along, falls head over heels in love with her, and provides her with this lovely safe haven for a while, and stability and total adoration. And he's very funny and very interesting, and she goes with it for a while…And I think Douglas so adores her and so thinks she's amazing, that ironically, through his love and his devotion, he builds and builds her confidence and loves her and loves her and loves her until she has the confidence to turn around and go, "You know what? I need to be on my own; I need to be the artist I always thought I was going to be." She sees her son doing what he really wants to do, and she wants to do that too.
Albie's desire to study art and make it his career must be an important factor in her relationship with Douglas.
Yeah, absolutely. She encourages Albie and probably lives a bit vicariously through him. And she sides with Albie in a way that I don't think is very good parenting—you know, they leave Douglas out a lot, and she acts like big sister sometimes, which is not really the way to go about things.
Are you more like Connie or Douglas when it comes to travel?
I'm certainly not as organized as Douglas…No, I'm more like Connie, actually. But then as I've gotten older, I think I've gotten better at being more pre-prepared. I remember I was touring with a theater company going all around Brazil and India and Pakistan, a long, long time ago. There were eight of us on this job, and one of the actors had an Uncle Dick who would get a map, find out all the places to go—he'd have it all worked out when they went on holiday with him. So we would get to a town and between the eight of us, somebody would say, "So who's going to be Uncle Dick?" And that person would then have to get the maps, get the bus timetables, and get the best places, because we only had a limited time to explore the amazing places we were visiting. I'm certainly not like that and I don't think I'll ever be, while Douglas is an Uncle Dick. So yeah, I'm more like Connie.
I remember my dad was always very organized. But he was an actor, so there were some holidays that he'd have set up where he suddenly couldn't come. There was one where we'd booked this journey to the south of France, and my mom, who drives but had never done anything like that, had to drive us all the way to the south of France on her own. And she actually did it—I didn't think she'd be able to, but she did it—and it made me realize that it was really cool to be a woman and to be that on top of traveling, like that. Somebody told me once, a long time ago, "Never pack a suitcase that you can't carry yourself." And I thought that was really cool as well. So though I'm certainly not like Douglas, I do actually enjoy and embrace the idea of being completely self-sufficient and organized and ready. In fact, the more organized you are, the more free you can be, as well.
Did you have any favorite moments or memorable challenges from doing this whirlwind shoot?
There was one when we had to get on a train. I think we were going to Spain, either from France or Holland to Spain—and that was what was so wonderful about this job, moving all around Europe on a train, it's just beautiful. Anyway, we there was some sort of issue with travel and roadblocks, and Tom and I nearly missed that train. It was the most scary, stressful hour, because if we'd missed that train—the whole crew were on it—it would have been a total disaster. But we didn't. We got on it, thank God.
One of the most exciting things was being able to be in art galleries when nobody else was there. We had sections of the Louvre where we could walk around on our own. And the Rijksmuseum—there was nobody there! I could walk right up to these Vermeers and just stand and take my time. It was beautiful and really, we were so privileged. We never had the luxury of time because we were shooting in streets and trains and art galleries, and we had a very strict timeframe to do things, so we had to be very prepared, and on it. But I love all that anyway—it's very exciting.
With all that rushing around that the family does too, it's wonderful—and rather unusual—to have these beautiful moments with the art in the museums. It really takes its time. But it makes me wonder, how do you personally like to experience museums and art, and what was it like, then, to look at art as Connie?
That's an interesting question…I did Art History as an A Level [at university]. But I had this friend, one of the actors in the theater company, who used to work at Sotheby's before he was an actor—we used to go to art galleries together and when we were touring around the world, we'd go to art galleries. And I'd say, "But oh, I sort of feel uncomfortable sometimes, because I feel"—a bit like Douglas—"like I have to say something." And he said, "No, you don't. Whatever you feel is what you feel, and that's acceptable. There's no right or wrong." And like anything, the more you expose yourself to it, the easier it gets and the more enjoyable it becomes. You start to have a relationship with it and with different types of art.
With Us, I went to Barcelona, Holland and Amsterdam, and Paris, and I've been to all those museums before—the Miro, the Rijksmuseum, and the Louvre many times. And as I said, it's lovely to have been in those spaces with nobody else around. But I think I took a lot of very good advice from dear friends, when I was much younger, to say, "Well, it doesn't matter, there is no right or wrong." Poor Douglas is like, "I don't know what to say," so he just kept making jokes about things, like, "What a very big frame that picture is in." I think Connie was trying to instill her sense that there's no right or wrong in her son, and trying to lead Douglas, trying to get him to come along with them on this journey.
Tom Hollander Interview: The Uncool Everyman in David Nicholls' Us
Meet the Cast & Characters of Us
The Art of Us: A Guide to the Masterpieces in the Show
Sign up for the MASTERPIECE newsletter for the latest schedule and show news and exclusive content.
*** START *** The plugin meta info in content-specialfeature.php:
show_featured_image: 0
hide_title: 0
mp_sf_type: None
suppress_modal: 0
flipcard: 0
interview: 1
letter_format: 0
listicle: 0
question_answer: 0
related_content_module: 1
timeline: 0
lead_image_image: 16090
lead_image_image_alt_text: Saskia Reeves stars at Connie Peterson in Us on MASTERPIECE on PBS
lead_image_image_caption:
lead_image_image_credit:
lead_image:
interviewer: Masterpiece
interview_subject: Saskia Reeves
mp_interview_content_0_question: While the characters of Us are very specific, the show portrays a universal span of a family relationship: romance, the discovery of young love, the shared project of child rearing, and then those uncomfortable unknowns that lie ahead after the children have grown. Can speak to its universality?
mp_interview_content_0_answer: There's a horrible phrase, "empty nesters," isn't there? The teenager leaves and suddenly you're staring across at your partner going, "What the hell of we got in common with each other?" So on one very stereotypical level, I think that's what's going on here. But you've got quite a few dysfunctional relationships, especially the father and the son, who have very different interests, which in itself is universal at this point, when kids are 18, 19 years old. I have a 19-year-old and a 15-year-old, and it's difficult being a parent, especially with the older child, because I've never been a parent to a 19-year-old before; I don't know what it's like. I think a lot of people feel like that, and they see themselves in this series, and [novelist and screenwriter] David Nicholls has so beautifully written the language that we use with our children. But then, when you're watching it subjectively and see it from the child's point of view, you go, "Oh my God, that's a terrible thing to say to your child!" There's one scene I find particularly painful, where Douglas storms into Albie's room, opens the window, and is like, "Have the birds been smoking cigarettes again?" And you think, "But he's just chilling out in his bedroom and you barged in like it's your property!" And then, "How many times have I done that, in those initial stages of his young adulthood, where I've still treated him like he's 15 or 13?" I think everybody in this family is learning about how they're all changing, and how they're all growing. Are they going to stay together? Albie is about to leave for college: Is he going to ever speak to his dad again? Especially the way Douglas regards the course [of study] that Albie is doing—that's universal, isn't it, that you don't understand your child? My son loves to play computer games and I try and try and try to be interested, but there is a part of me where I do not get it, I don't. But you have to keep that to yourself, really. Because what do I know?
mp_interview_content_1_question: In the scene you describe, where Douglas barges into the room, it does seem like a violation, but I also understood Douglas' position. And that nuance runs through the DNA of this show, and makes each character so sympathetic, even if they're behaving badly.
mp_interview_content_1_answer: I think what the series tries to do is say that there isn't a good or bad person, there isn't a side to take, actually, because we are all in each of these characters. They're not bad people. I think the difficulty with this story is that nothing really bad has happened—he didn't have a raging affair with somebody half his age, or she hasn't got a drink problem (or she does, actually, but anyway…). They're just getting on with life and dealing with the loss of a child, years ago, which I know had such a profound, disturbing, impact on Connie that everything after that was different.
mp_interview_content_2_question: If you had any advice for young Connie, what might it be?
mp_interview_content_2_answer: Stop drinking, I would say. Because maybe then she could commit to herself, and to the people she gets involved with, a bit better. She could maybe really understand who she wants to be with. And also, to not give up the art, to not stop, because as any artist knows, perseverance is what you need. I think Connie was a very, very under-confident artist and a very chaotic person. David [Nicholls] talks in his book about her family life before she meets Douglas, and I always saw her upbringing as one of the reasons she chose so many inappropriate boyfriends, and perhaps why she liked to get obliterated quite a lot and to numb herself in some way. She always wants to be having a great time, but she didn't have a lot of self-confidence. Then Douglas comes along, falls head over heels in love with her, and provides her with this lovely safe haven for a while, and stability and total adoration. And he's very funny and very interesting, and she goes with it for a while…And I think Douglas so adores her and so thinks she's amazing, that ironically, through his love and his devotion, he builds and builds her confidence and loves her and loves her and loves her until she has the confidence to turn around and go, "You know what? I need to be on my own; I need to be the artist I always thought I was going to be." She sees her son doing what he really wants to do, and she wants to do that too.
mp_interview_content_3_question: Albie's desire to study art and make it his career must be an important factor in her relationship with Douglas.
mp_interview_content_3_answer: Yeah, absolutely. She encourages Albie and probably lives a bit vicariously through him. And she sides with Albie in a way that I don't think is very good parenting—you know, they leave Douglas out a lot, and she acts like big sister sometimes, which is not really the way to go about things.
mp_interview_content_4_question: Are you more like Connie or Douglas when it comes to travel?
mp_interview_content_4_answer: I'm certainly not as organized as Douglas…No, I'm more like Connie, actually. But then as I've gotten older, I think I've gotten better at being more pre-prepared. I remember I was touring with a theater company going all around Brazil and India and Pakistan, a long, long time ago. There were eight of us on this job, and one of the actors had an Uncle Dick who would get a map, find out all the places to go—he'd have it all worked out when they went on holiday with him. So we would get to a town and between the eight of us, somebody would say, "So who's going to be Uncle Dick?" And that person would then have to get the maps, get the bus timetables, and get the best places, because we only had a limited time to explore the amazing places we were visiting. I'm certainly not like that and I don't think I'll ever be, while Douglas is an Uncle Dick. So yeah, I'm more like Connie. I remember my dad was always very organized. But he was an actor, so there were some holidays that he'd have set up where he suddenly couldn't come. There was one where we'd booked this journey to the south of France, and my mom, who drives but had never done anything like that, had to drive us all the way to the south of France on her own. And she actually did it—I didn't think she'd be able to, but she did it—and it made me realize that it was really cool to be a woman and to be that on top of traveling, like that. Somebody told me once, a long time ago, "Never pack a suitcase that you can't carry yourself." And I thought that was really cool as well. So though I'm certainly not like Douglas, I do actually enjoy and embrace the idea of being completely self-sufficient and organized and ready. In fact, the more organized you are, the more free you can be, as well.
mp_interview_content_5_question: Did you have any favorite moments or memorable challenges from doing this whirlwind shoot?
mp_interview_content_5_answer: There was one when we had to get on a train. I think we were going to Spain, either from France or Holland to Spain—and that was what was so wonderful about this job, moving all around Europe on a train, it's just beautiful. Anyway, we there was some sort of issue with travel and roadblocks, and Tom and I nearly missed that train. It was the most scary, stressful hour, because if we'd missed that train—the whole crew were on it—it would have been a total disaster. But we didn't. We got on it, thank God. One of the most exciting things was being able to be in art galleries when nobody else was there. We had sections of the Louvre where we could walk around on our own. And the Rijksmuseum—there was nobody there! I could walk right up to these Vermeers and just stand and take my time. It was beautiful and really, we were so privileged. We never had the luxury of time because we were shooting in streets and trains and art galleries, and we had a very strict timeframe to do things, so we had to be very prepared, and on it. But I love all that anyway—it's very exciting.
mp_interview_content_6_question: With all that rushing around that the family does too, it's wonderful—and rather unusual—to have these beautiful moments with the art in the museums. It really takes its time. But it makes me wonder, how do you personally like to experience museums and art, and what was it like, then, to look at art as Connie?
mp_interview_content_6_answer: That's an interesting question…I did Art History as an A Level [at university]. But I had this friend, one of the actors in the theater company, who used to work at Sotheby's before he was an actor—we used to go to art galleries together and when we were touring around the world, we'd go to art galleries. And I'd say, "But oh, I sort of feel uncomfortable sometimes, because I feel"—a bit like Douglas—"like I have to say something." And he said, "No, you don't. Whatever you feel is what you feel, and that's acceptable. There's no right or wrong." And like anything, the more you expose yourself to it, the easier it gets and the more enjoyable it becomes. You start to have a relationship with it and with different types of art. With Us, I went to Barcelona, Holland and Amsterdam, and Paris, and I've been to all those museums before—the Miro, the Rijksmuseum, and the Louvre many times. And as I said, it's lovely to have been in those spaces with nobody else around. But I think I took a lot of very good advice from dear friends, when I was much younger, to say, "Well, it doesn't matter, there is no right or wrong." Poor Douglas is like, "I don't know what to say," so he just kept making jokes about things, like, "What a very big frame that picture is in." I think Connie was trying to instill her sense that there's no right or wrong in her son, and trying to lead Douglas, trying to get him to come along with them on this journey.
mp_interview_content: a:7:{i:0;s:17:"mp_interview_item";i:1;s:17:"mp_interview_item";i:2;s:17:"mp_interview_item";i:3;s:17:"mp_interview_item";i:4;s:17:"mp_interview_item";i:5;s:17:"mp_interview_item";i:6;s:17:"mp_interview_item";}
related_content_intro:
related_content_links_0_title: Tom Hollander Interview: The Uncool Everyman in David Nicholls' Us
related_content_links_0_url: https://www.pbs.org/wgbh/masterpiece/specialfeatures/tom-hollander-interview-the-uncool-everyman-in-david-nicholls-us/
related_content_links_0_open_in_new_window: 1
related_content_links_1_title: Meet the Cast & Characters of Us
related_content_links_1_url: https://www.pbs.org/wgbh/masterpiece/specialfeatures/meet-the-cast-and-characters-of-us/
related_content_links_2_title: The Art of Us: A Guide to the Masterpieces in the Show
related_content_links_2_url: https://www.pbs.org/wgbh/masterpiece/specialfeatures/the-art-of-us-on-masterpieces-pbs/
related_content_links: a:4:{i:0;s:4:"link";i:1;s:4:"link";i:2;s:4:"link";i:3;s:4:"link";}
related_content:
related_content_links_3_title: Sign up for the MASTERPIECE newsletter for the latest schedule and show news and exclusive content.
related_content_links_3_url: https://www.pbs.org/wgbh/masterpiece/sign-up-for-the-masterpiece-email-newsletter/
*** END **********************************************************************


Visit the Flu website to learn where to obtain a flu vaccine.
There's a good deal of discussion about the need to immunize children against infectious diseases like chicken pox and measles, but I think we've gotten complacent about what vaccines adults need. We shouldn't be, because each year in the United States, up to 50,000 adults die from vaccine-preventable diseases or their complications. In fact, it's the sixth leading cause of death.
I'm Dr. William Walker, Director of Contra Costa Health Services, and I'm here to talk to you about the importance of flu vaccine.
I've seen an evolution over the years in immunization efforts. Several decades ago, we focused primarily on those who were most at risk - the frail elderly and those with compromised immune systems for example.
More recently, we've encouraged people who have close contact with those who are most vulnerable to also get vaccinated. This includes anyone who lives with or cares for someone elderly, and someone who is a health care worker.
Young children under 5 are also at high risk of flu complications and also need the flu vaccine. To further protect children - their parents, older siblings and childcare providers should get vaccinated, too.
Pregnant women also are encouraged to get the flu shot to protect themselves and their baby. However, people who are allergic to eggs should not get the flu vaccination.
In my practice, I've also observed a change in patients' attitudes. Years ago, I had to twist people's arms (figuratively speaking of course) to get flu shots.
Now people are requesting it and are much more willing. And the nasal flu vaccine for healthy people ages 2 to 49 is widely available now for those who don't like needles.
There are still people who are reluctant. They worry that they'll get sick from the vaccine. I have patients who say they know someone who got the flu from the vaccine.
Since the flu shot is not made from a live virus, that is not possible. Any potential side effects from the shot - a low grade fever, soreness in the arm and aches - are much less severe than the illness from the influenza viruses we are now seeing. There is a slightly higher risk with the nasal vaccine but it's still very low.
For information about flu vaccinations, visit our website at cchealth.org Thanks for listening.


text:
Q: How to execute a sql procedure as a raw query in entity framewrok core What is the Alternate for SqlQuery in EF Core2.0 I dont want to create a model for executing the procedure
     var result =  _context.Database.SqlQuery<string>("TWS_config_MidOfficeSystems_Validate @mo,@ga,@pcc,@xmo",
                                   parameters: new SqlParameter[]
                                   {   new SqlParameter("@mo",lineData),
                                    new SqlParameter("@ga", gdsAccessId),
                                    new SqlParameter("@pcc", crsPCC),
                                    new SqlParameter("@xmo", bkMidOfficeCode),
                                   }).FirstOrDefaultAsync();

A: As EF Core tightly coupled, You have to create class with properties coming from stored procedure.
 public class ExampleClass
 {
     public string Name { get; set; }
     public string Email { get; set; }
 }

In ApplicationDbContext.cs add that class as DbQuery
 public DbQuery<ExampleClass> ExampleClassDbQuery { get; set; }

Implement Dependency Injection into your controller or services
private readonly ApplicationDbContext _db;

    public ExampleService(ApplicationDbContext applicationDbContext)
    {
        _db = applicationDbContext;
    }

Then call stored procedure like this:
_db.ExampleClassDbQuery.FromSql("storedProcedureName", []parameters);

For more to know about running raw queries using FromSql please follow this Microsoft Docs

redpajama_set_name: RedPajamaStackExchange


The Clermont Town Board held its regular Town Board meeting on Monday, December 5, 2005. Those present were Supervisor William E. Banks, Councilman Staats, Councilwoman Lent, Councilman Harned and Councilman Tousey. Others present were William Cole, Kimberlea Shaw Rea, Esq., Judith Neary, Elizabeth Mahar, Dagmar Payne, Dennis Palazzo, Robert Desmond, Walter and Vera Brembs, Laurence Saulpaugh, Gregory Fingar, George Davis, Chris Nolan, Meri Puccio, Paul Doherty, Rachel Hyman and Richard Roth, Independent.
Supervisor Banks opened the meeting with a salute to the flag. A motion was made to accept the minutes as presented by Councilman Staats, seconded by Councilman Tousey. All in favor. So carried.
·	Walter Brembs asked about the results of the survey sent out by the Hamlet Steering Committee. In the absence of Chairwoman Rebecca Sethi, Bob Desmond who is on the committee explained that arrangements have been made to have the results compiled. The process should take about 2-3 weeks. Five hundred fifty surveys were sent out and approximately 200 were returned. Chris Nolan noted that Meri Puccio, owner of Julia and Isabellas Restaurant, who is here tonight, donated a prize for the drawing. Supervisor Banks suggested, that thank you notes be sent out by the committee to those donating.
·	Chris Nolan asked if anyone had contacted Chris Gilbert, the owner of the former Boice property regarding the removal of C&D materials. The owner maintains that no one has spoken to him. Chief Larry Saulpaugh has personally spoken to him, as well as, DEC regarding this situation.
·	Once again, the Con Ed funds were brought up and it was suggested that Mr. Nolan file a FOIL request for the information and he will receive copies of what has been extracted to date for the other applicant.
1. Roland Vosburgh, Director, Columbia County Planning - Keep Farming Program Opportunity - regarding RFP from Glynwood Center. Submission deadline is 1/9/06. Rebecca Sethi provided copies for the Board members. Councilman Tousey explained that the Glynwood Center designs programs are to keep farming alive based on how many farms, acreage involved, etc. They offer a $20,000 grant, with the town providing $5,000. It is possible that Scenic Hudson would provide the $5,000.
Bob Desmond suggested that the towns of Clermont, Germantown and Livingston might consider doing this together. A motion was made by Councilman Tousey, seconded by Councilman Staats to proceed with the grant request. All in favor. So carried. Councilwoman Lent will work the Rebecca on the request.
2. Letter from Catherine All, Office for the Aging seeking volunteers to form a taskforce to determine the local impact of the expected demographic shift as Baby boomers begin to retire in 2015. Supervisor Banks asked for any interested person to represent the Town at the next meeting on December 7°i.
State Comptrollers teleconference material was handed out to the Board members for a conference on December 12 for Just Elected Officials; Chris Nolan received a packet, since he is newly elected, and the Association of Towns conference for newly elected officials in January. Also included was information about the Training School and Annual Meeting in New York City in February.
4. Conferences being held on Zoning and Land Use- 1/31/06, Phase II Stormwater Regulation and Compliance - 1/31/06 and the Many Faces of SEQRA on 2/15/06, all being held in White Plains.
5. NYS Energy Research and Development Authority - Info about electric audit for Small business.
Town Clerk's report for November - Check to town for $572.69. A motion to accept report by Councilman Staats, seconded by Councilman Harned. All in favor. So carried.
·	Judith Neary reported on a building tour of the Red Hook schools. Seeking input on the needs for population growth, renovations, etc. Demographics studies are usual required by the State for expansion of schools.
·	Rebecca Sethi reported on the Hamlet Steering Committee survey. Rebecca has contacted the grantees of the Laura Musser funds to see if these funds can be used to have the results of the survey consolidated. This would insure objectivity. It is possible to use the funds and the cost would be $1.75 per survey. A motion was made by Councilman Tousey, seconded by Councilwoman Lent to hire someone to complete the survey results. Beehan Associates of Saratoga responded to the planning proposal for the hamlet steering committee and there are some points in their proposal, which they are seeking clarification on.
·	Kimberlea Shaw Rea was present to discuss the communications she has had with DEC regarding the former LaMunyan site on Route 9G. She has written to DEC requesting clarification on their position on the C&D site. In their response, they noted that the site violates Part 360 Regulations and is non-compliant. They have failed to comply with the completion of the site investigation and closure plan. Ms. Shaw-Rea recommended that Billy Cole should take appropriate remediation and that the town should not grant any permits on the property until it is compliant. Mr. Cole stated that this would cost millions and he would walk away from the property. She suggested to Mr. Cole that the nine acres be surveyed and the limits of the C&D waste delineated. In this way, he might possibly be able to use the portion, which is not contaminated and leave the balance undisturbed. Supervisor Banks asked Ms.
Shaw-Rea to contact DEC and request them to come down and footprint the area and clarify as to what part of the acreage owner can use.
·	Councilwoman Lent reported that if anyone is looking for trees or wreaths, the Edward Kahle family on County Route 6 have trees for sale and the children make and decorate wreaths and greens for the Christmas season.
Marilyn Kaplan recommended that we proceed with La Tone Construction with a base bid of $32,900; Alt. 2- Cupola Restoration - $16,000; Alt. 3 - Chimney rebuild - $6,400. Total of $55,300. It was also recommended to consider wood shingles for the roof as opposed to asphalt. A motion was made by Councilwoman Lent, seconded by Councilman Harned, to award the bid to LaTorre Construction Base bid, Alt. #2 and Alt. #3 and wood shingles for the roof for a total of $63,300. All in favor. So carried.
·	Councilman Tousey presented Resolution #17-05. Councilman Tousey made a motion, seconded by Councilwoman Lent authorizing the Supervisor to transfer $100,000, which was declared a surplus, from the General Account into the General Building Capital Reserve. All in favor. So carried.
·	Councilwoman Lent reported that seven display pedestals have been made and stained for use in the Community House. There is $2,000 in the budget for this expense.
·	Councilman Staats reported that the Christmas Program would be held on Sunday, December 18'j' at 7:00 P.M. with caroling at St. Lukes Church, Santa Claus and refreshments to follow. This will be posted on the website.
·	There is a vacancy to be filled on the Planning Board, as Chris Nolan will be taking his seat on the Town Board on January IS'. There are also three positions whose terms will expire on December 31, 2005. They are on the Planning Board, Zoning Board of Appeals and Board of Assessment Review. Interviews will be held on December 27' at 6:30 P.M. after the year-end meeting. Those currently holding the three seats will be notified and anyone else interested should contact the Town Clerk. This will be posted on the website.
·	Supervisor Banks reported that Albert Trezza, Town Attorney is retiring at the end of this year. Also Peter Ostrander, Sole Assessor will stay on during the year 2006.
A motion was made by Councilman Harned, seconded by Councilwoman Lent to approve payment of Trust and Agency abstract #12, vouchers 12-14 in the amount of $2,104.25. All in favor. So carried.
A motion was made by Councilman Harned, seconded by Councilwoman Lent to approve payment of General Abstract #12, pages 1,2,3, vouchers #299 - 340 in the amount of $35,049.00. All in favor. So carried.
A motion was made by Councilman Harned, seconded by Councilman Staats to adjourn at 8:30 P.M.


text:
Hinduism, Theravada Buddhism, and Mahayana Buddhism: A Comparative Analysis
© by Jens Micah De Guzman
The first traceable roots of Hinduism lie with the conquering Aryans, who moved into the northwest of the Indian subcontinent from about 1500 BC.
The Aryans' priestly caste, the Brahmans, was responsible for the sacrificial rites. The ritual hymns which they chanted, passed down orally for many centuries, were compiled in the Rigveda, believed to be the earliest of all religious texts.
It is held that the arrival of the Aryan people in India represented a significant moment in the history of Hinduism.
The Aryans supplanted the earlier Harappan culture in the Indus valley, and they are thus the people described in the Vedas, the earliest sacred literature of Hinduism.
On the other hand, Siddhartha Gautama, the founder of Buddhism, was born in the sixth century B.C. in what is now modern Nepal--which was part of India before.
His father, Suddhodana, was the ruler of the Sakya people, and Siddhartha grew up living the extravagant life of a young prince.
Theravada, the 'Doctrine of the Elders,' is the name for the school of Buddhism that takes its scriptural inspiration from the Pali Canon, or Tipitaka, which is generally acknowledged as the oldest record of the teachings of that man from India--Siddharta Gautama or Buddha.
Also known as the Great Vehicle, Mahayana Buddhism is the branch of Buddhism prominent in North Asia, such as in China, Mongolia, Tibet, Korea, and Japan.
Technically, it also traces its roots from India. Arising out of schisms, basically about both doctrine and monastic rules, within Indian Buddhism in the first century C.E., the Great Vehicle (naturally) considers itself a more genuine version of the Buddhism.
Many more similiraties can be discerned from these "Indian" religions. Some find their differences minimal, if not unessential.
Continue reading here: The Uniqueness and Similarities of Mahayana and Theravada Buddhism
Copyright © by Jens Micah De Guzman
For other free lectures for students like this, visit Homepage: Introduction to World Religions and Belief Systems
The Uniqueness and Similarities of Mahayana and Theravada Buddhism
Mahayana Buddhism 101: The Brief History, Core Teachings, Fundamental Beliefs, Practices, and Related Issues
Theravada Buddhism 101: The Brief History, Core Teachings, Fundamental Beliefs, Practices, and Related Issues
Hinduism: The Brief History, Core Teachings, Fundamental Beliefs, Practices, and Related Issues
The Brief History, Core Teachings, Fundamental Beliefs, Practices, and Related Issues of Islam
The Brief History, Core Teachings, Fundamental Beliefs, Practices, and Related Issues of Christianity
The brief history, core teachings, fundamental beliefs, practices, and related issues of Judaism
The Influences of Religion to Culture and Society
The Interconnectedness of Geography, Culture and Religions
The Concept, Elements and Characteristics of Belief System, World View, Religion, and Spirituality
Religion vs Spirituality: What is the difference between them?
Judaism, Christianity, and Islam: A Comparative Analysis
Hinduism, Theravada Buddhism, and Mahayana Buddhism: Similarities and Differences
Feng Shui: The Basics in Taoist Environmentalism that You Need to Understand
Confucianism Philosophy: As Applied in Education, Ethics, Social Philosophy, Religion and More
Mahayana Buddhism Meditation: The Basics You Need to Know
Yoga: Did you know its real origin?
Definition of the Four Noble Truths: A Simplified Discussion
Buddhism's Eightfold Path: A Simplified Summary
The Tripitaka of Theravada Buddhism: A Simplified Summary
The Life of Buddha: Short Biography of Siddharta Gautama
What is the Difference between Theravada and Mahayana Buddhism? A Simplified Answer
Theravada Buddhism vs Hinduism: Basic Similarities and Differences
Hindu Caste System in India: A Simplified Summary
Hindu God Names: A Simplified Summary of Hindu Deities
Vedas, Upanishads, and Bhagavad-Gita: A Simplified Summary
Islam vs Hinduism: A Simple Comparison
For STUDENTS' ASSIGNMENT, use the COMMENT SECTION here: The Indian Roots of Hinduism, Theravada Buddhism, and Mahayana Buddhism


text:
WCSCC Charities, Inc.
Resident Sponsor
Caring and Sharing Together
Make A Difference in Our Community Today
Seeing a need for energetic, nonprofit work in our area, WCSCC Charities was created in 2008 as a 501(c)3, a not-for-profit organization, with the following mission statement: "WCSCC Charities mobilizes the Sugarloaf community to support local charities whose purposes are to improve the financial, emotional and/or physical wellbeing of families and individuals living in Gwinnett County." The WCSCC Charities Charity Board falls under the umbrella of our Women's Club, and it consists of Women's Club members. The Charity Board votes each year on local charities to support. This year, the chosen charities are Annandale Village, Duluth Co-op, Mosiac, The Next Stop Foundation, and Wellspring Living. Both the Women's Club and the Charity Board have Executive Boards which represent our Women's Club members.
In August, we will be doing a Back in the Swing Lawn Games and Tennis Round Robin Event. This will be combined with other lawn games, as well as food and drinks. We will also be hosting our annual Turkey Trot on Thanksgiving morning and a Dinner Dance event in the spring of 2021. We have many opportunities for you to help us as we fundraise for these wonderful charities: Corporate Sponsorships, Resident Sponsorships, and advertising in our monthly Sugarloaf Living magazine. Over the last 12 years we have raised over $1.4 million dollars. All of this was made possible by the generosity and compassion of the Sugarloaf and Gwinnett county communities. Seeing a need for energetic, nonprofit work in our area, WCSCC Charities was created in 2008 as a 501(c)3, a not-for-profit organization, with the following mission statement: "WCSCC Charities mobilizes the Sugarloaf community to support local charities whose purposes are to improve the financial, emotional and/or physical wellbeing of families and individuals living in Gwinnett County." The WCSCC Charities Charity Board falls under the umbrella of our Women's Club and it consists of Women's Club members. The Charity Board votes each year on local charities to support. The charities chosen for 2020/21 are: Annandale Village, Duluth Co-op, Mosiac, The Next Stop Foundation, and Wellspring Living. Both the Women's Club and the Charity Board have Executive Boards which represent our Women's Club members.
Cruising Into the Spring
Please check back for more details on this event.
Date: 4/23/2021 05:30 PM
Location: 2595 Sugarloaf Club Drive, Duluth, GA, USA (Map)
Sugarloaf Turkey Trot 25 Nov 2021 Thursday 2595 Sugarloaf Club Drive, Duluth, GA, USA Closed
Tennis Round Robin Night 16 Oct 2020 Friday 2845 Sugarloaf Club Drive, Duluth, GA, USA Closed
'Back in the Swing' Lawn and Tennis Party 21 Aug 2020 Friday TPC Sugarloaf Tennis Courts Closed
For a $250 tax deductible Resident Sponsorship, you will be recognized as a 2021 Resident Sponsor in our marketing materials and at our fundraising events in 2021, you will receive one of our mailbox adornments.
To become a resident sponsor by check click here and mail to:
c/o Sandy Elliott
1880 Sugarloaf Club Drive
or drop in birdie box at same address
$250.00 Other
Annandale Village
Founded in 1969, Annandale Village is an award-winning nonprofit organization dedicated solely to providing progressive life assistance to adult with developmental disabilities and acquired brain injuries so they can maximize their abilities and maintain their independence in the least restrictive environment.
Duluth Co-op
The Duluth Co-Op is a not-for-profit organization providing food, financial emergency assistance and resources for our neighbors in need in Duluth. With the dedication of many volunteers who staff their office and food pantry, the Duluth Co-Op is making a difference for those who struggle in our community. Their goal is to make life better by focusing on the values of service to others, self-reliance, strong families and engaged seniors.
Mosiac
The mission of Mosaic is to take action and guide change for the safety, health & justice of children and adults impacted by sexual violence.
The Next Stop
The Next Stop's basic vision has remained the same since day one: we wanted to establish a place where adults with special needs in our community could come and have opportunities to socialize, enjoy recreation, and learn life application skills alongside their peers. We saw these adults thriving in an enjoyable, structured and supportive setting where they could laugh, learn, and shine!
Wellspring Living
Founded in 2001, Wellspring Living is a non-profit organization in Atlanta, Georgia that provides domestic sex trafficking victims and those at risk with specialized recovery services through four residential programs, two community-based programs and graduate services. The programs provide transformative care through therapeutic services, education, life skills, and personal and professional development. The focus for each participant is on developing their courage to move forward and their confidence to succeed.
Name, Logo & link on WCSCC Charities website
Recognition at WCSCC Charity Events Logo
Business Profiled in May issue of Sugarloaf Living Magazine Name, Business highlights & Contact
Tickets to Charity Dinner Dance (8)
Tickets to Charity Week Gala (2)
Logo on Turkey Trot T-shirt Large
Marketing Materials in Turkey Trot Runner Bags
Table at Turkey Trot upon request
Name and Logo & link on WCSCC Charities website
Recognition at WCSCC Charity Events--Logo
Business Profiled in May issue of Sugarloaf Living Magazine
Tickets to Charity Dinner Dance(2)
Tickets to Charity Week Gala(2)
Logo on Turkey Trot T-shirt-Medium
Name on WCSCC Charities website
Recognition at WCSCC Charity Events--Name
Name on WCSCC Charities website--Name
Business Profiled in May issue of Sugarloaf Living Magazine--Name & Contact Information
Logo on Turkey Trot T-shirt-Small
Turkey Trot T-Shirt Sponsor
One T-shirt
One entry to the race
Name listed on back of t-shirt
Name listed on WCSCC Charities website Acknowledgement in Sugarloaf Magazine
Place promotional material into race day bags
Jan McPheely
Brian and I moved to Sugarloaf fifteen years ago with our three children. They are now adults living in the Brookhaven, Decatur area. We are blessed with two wonderful daughters-in-law and three grandchildren. Originally from Michigan, we own a cottage in northern Michigan where we spend as much time as possible during the summer. I enjoy playing tennis and am trying to enjoy playing golf. I also love to spend time with my family, sew, cook, entertain, take walks and read.
Ginger Ragsdale
Ginger Ragsdale Barber has been a resident of Gwinnett County for over 25 years. Ginger was born in North Carolina, went to school at UNC-G and graduated in 1976 with a design degree. She moved to Georgia in 1983 and started working with interior design firms as well as local home builders. Sugarloaf has been their home with her late husband, Mike Barber and family of 4 kids since 2000. Other interests and past activities involve playing tennis and enjoying 5 grandchildren. She has been a past chairperson with the Sugarloaf Tour of homes, previously on the board of the Sugarloaf POA and board of the Atlanta SPCA. Ginger is still actively involved with her building company, G. Ragsdale Builders, completing renovations and new construction for the many families of our subdivision and surrounding areas.
Wendy Armstrong
Wendy grew up in SC and graduated from the Univ. of South Carolina and was a flight attendant for Northwest Airlines for 28 years.She has lived in Gwinnett for 30 years and is currently a GCPS substitute teacher. She and her husband, Kerry, have one daughter, Jenny, and she loves to spend time with her and also likes to spend time playing tennis and hiking.
Sandy Elliott
Born and raised in Georgia, Sandy has lived in Gwinnett County for over 40 years. She has three daughters and eight grandchildren. She loves to be with her children and grandchildren and play tennis. She is also a part of the Gwinnett Parks Foundation. She has a BSED from University of Georgia in Health and Physical Education.
Cynthia Fitzhugh
Liaision
Cynthia was born, raised and attended college in North Carolina. Her 16-year sales career with Union Camp / International Paper carried her to Virginia and Tennessee. She has been retired from the paper industry since 1999. She has been married to Jim for 27 years and they have one son, Brock, who is 21. She enjoys gardening, tennis, traveling and serving as the liaison for the Sugarloaf Women's Club and Charity Boards.
Jane Haro-LaMotte
Magazine Editor
Born and raised in North Dakota, Jane has also lived in suburbs of Milwaukee, St. Louis, Cincinnati, and the past 16 years in Duluth, GA. She and Joe have one son, two daughters, and four grandchildren. She taught Advanced Placement HS English for many years and was later a pharmaceutical rep for Abbot Labs. Jane is active in her church, is a trained Stephen Minister, has fund raised for many organizations, and is presently the Editor of our Sugarloaf Living Magazine. She also enjoys entertaining family and friends, the theatre, and travel.
Marshall Barton
Marshall Barton has been involved with the Women's Club of Sugarloaf Country Club Charities for ten years in a variety of roles. She is VP, Animal Health US Business Law, for Boehringer-Ingelheim, the makers of NEXGARD®, HEARTGARD®, and FRONTLINE®. She earned her JD from the College of William & Mary and a BS from Vanderbilt University. Marshall also is active in several other civic and charitable organizations, including serving as the current Chair of the Board of Directors for Rainbow Village, Inc., a long term transformational housing program for homeless families with children, and on the Gwinnett Advisory Board for the United Way. She resides in Duluth with her husband, Tom, who also is a lawyer, and their two dogs and two cats. Happily, their five children, two daughters-in-law, seven grandchildren, and two grand-dogs are frequent visitors.
Debbie Bush
I grew up in a very small town in Virginia, Clifton Forge, and received my bachelor's degree from Virginia Tech. My husband and I moved to Georgia when he was in the Army at Fort Benning and we decided to stay. We both received our master's degrees from Georgia State University. While teaching I went on to obtain my Educational Specialist degree from Brenau University and Georgia State University. I retired from education in 2012. While I was teaching I worked with some of my students on Shakespeare and we presented plays as a culminating activity. When I saw an ad in the paper for auditions at a local community theatre, I decided to try out and got a part in the play, "It's a Wonderful Life" in 2008. I had caught the theater bug! I went on to act in many plays in the area, mostly at New Dawn, but also at Players Guild at Sugar Hill. Another passion of mine is DAR. I had done some research on my family history, but I was lucky to have an aunt who had completed the line on my mother's side. Thus began my love of DAR. I am currently the Vice Regent at the Duluth chapter, William Day, and will be Vice Chair for two Georgia State DAR committees – American Indians and Constitution Week for the next two years. Finally, my love of music drives me in chairing the parade for the Duluth Fall Festival. Unfortunately, the festival is cancelled this year due to the coronavirus, but I am getting prepared for the 2021 festival parade! I love a parade!
Mary McNeil
Originally from Buffalo, New York, Mary has lived in Atlanta for 31 years, 10 of them in Sugarloaf. She has a Bachelor of Science in Business Administration from Northeastern University. She married her college sweetheart, Dave, and has two sons and a wonderful daughter-in-law. Mary serves as the Director, Associate Relations for Northside Hospital Gwinnett, where she has worked for 20 years. She is passionate about helping people and has been involved with WCSCC Charities, Inc. for the last 7 years.
Angela Pittman
Angela was born and raised in Norristown, Pennsylvania and has lived in Georgia for over 20 years. Angela worked in accounting for General Electric (GE) for 13 years in various locations including Valley Forge, Pennsylvania , Huntsville, Al. and Fairfield, Ct. Angela met her husband, Greg, of 37 years while working at GE. Together they have three children, two daughter-in-law's, two dogs and they are expecting their first grandson in July of 2020. After leaving GE and raising their kids, Angela started her own sewing business that specializes in window treatments, and beginner sewing lessons. Angela is a member of Cross Pointe Church in Duluth GA and she previously has served on the board of the Sugarloaf POA. Along with working out and striving to live a clean lifestyle with Young Living essential oils, Angela's hobbies include: tennis, golf, sewing, and charity work with the Women's Club.
Mary Jane Wolfe
Phil and I have been residents of Sugarloaf for 15 years. Phil retired in the fall, so we split our time between Atlanta and our home on Cape San Blas, Florida. I am involved in a few things other than the Sugarloaf Women's Club Charity Committee that I am proud of. Aurora Theatre Board of Directors, Gwinnett Parks Foundation, Partnership Against Domestic Violence, and more animal rescue groups than I can mention. We have no children, but are very involved with many of our nieces and nephews spread around the country.
Suzanne Whitehead
Suzanne and her husband Don have been married 43 years. They moved to Atlanta in 1980 from MS for Don to go to graduate school with no intention of staying they fell for the big city and had their five children here. They are all married and as of now she has eight grandchildren. Suzanne is a member of Perimeter Church . She enjoys hanging with her recently retired husband, activities with her family, group fitness classes, walking, a heart for hospitality, going out to eat and being with friends.
Gina Connell
Nominator--Annandale Village
Gina has lived all over the country but has been in Gwinnett County for the last 17 years. She has been married for over 31 years, has an adult son who has autism and resides at Annandale Village in Suwanee, GA, and a daughter who is studying to become a special eduction teacher. She has been involved with WCSCC Charities, Inc. for over 10 years and has been active in supporting other autism and special needs related charitable organizations in the Gwinnett County area.
Barb Barger
Barb was born and raised in Cincinnati, Oh and has lived in a multitude of places since she got married. She has lived in Atlanta for nearly 20 years. She and her husband Dennis have been married 39 years and they have 3 children who all live in Dallas, Tx. Two of the three children are married. Barb and Dennis are expecting their first grandchild in August. Besides being involved on the Sugarloaf Charity Board, Barb enjoys tennis, golf, walking, reading, and her Bible Study.
Kiersten Greeff
Kiersten was born and raised in Oregon and moved to Georgia in 1991. She and her husband, Mark, have a son and a daughter, and are soon to be empty nesters. Kiersten has served in several roles on the Charity Board, and is currently a Nominator for Annandale Village. She also serves as the Chairperson for From Hunger to Hope with Feed My Starving Children. She enjoys spending time with family and friends, as well as playing tennis.
Judy Gagne
Nominator--Duluth Co Op
Originally from the Boston area, Judy and her husband Mark have lived in Sugarloaf Country Club for 20 years where they raised their 3 sons; Greg, Andrew and Nick. Judy holds an undergraduate degree in Accounting from Boston College and a masters degree in Computer Information Systems from Bentley College and was a licensed CPA. She has been active in both the WCSCC and WCSCC Charities serving both on the executive board and as a charity nominator for Duluth Co-Operative Ministries. In her free time, Judy enjoys playing golf, gardening, traveling and spending time with her grandchildren.
Terri Schraudenbach
Terri and her husband, John, grew up in East Point, GA where they were high school sweethearts. They both went on to attend UGA where Terri majored in Early Childhood Education. She spent her career as an elementary school teacher prior to retiring to stay home with her three children. She has lived in Gwinnett since 1982 and moved into Sugarloaf CC in 1998. Terri has two daughters (Brooke and Katie) and a son (Adam) who are all married and have each contributed a grandson to the crew. In addition to spending time with her family and helping with her grandchildren, some of her interests include watching sports (especially Ga football), playing tennis, Bible study and volunteer work.
Margaret Washburn
Nominator--Mosiac
Margaret has a general trial practice dedicated to family law, corporate, probate, criminal defense, personal injury and workers comp in Lawrenceville. She was born in Salisbury, NC and moved to Atlanta in 1959. She attended Lakeside High School, Oglethorpe University and graduated Emory University School of Law, J.D, in 1979. She is the Chief Judge, Municipal Court for the City of Sugar Hill; Associate Judge, Duluth and Berkeley Lake; recipient of numerous awards from Gwinnett County Bar Association and Council for Municipal Court Judges of Georgia; "Best of Gwinnett" for legal representation 2014-present; People to Know; Past President, GCBA, Lawrenceville Kiwanis Club and Council for Municipal Court Judges; over 75 published articles. Margaret's 2 sons are lawyers, and her 2 daughters-in-law are also lawyers. Margaret has 3 amazing grandchildren, that are superstars, of course. She is a member of the Gwinnett Chamber of Commerce, 1818 Club, Gwinnett Leadership of Women, TPC Sugarloaf, and attends the Catholic Church of St. Monica with her fiancé' Eric Ballinger. Her hobbies are Tennis, writing and running and she is a Dedicated Georgia Bulldawg!
Joyce Larkins
Nominator--The Next Stop
Joyce is originally from Indiana, living in several states before moving to Georgia. She has lived in Georgia for the past 32 years, in Gwinnett County for 18 years. She has been married for 53 years. Joyce has 2 sons, 1 daughter, and 2 granddaughters. Her hobbies include Scrapbooking and tennis. She also enjoys traveling around the world. Joyce have been involved with the Sugarloaf's Charities for the past 4 years.
Julie Higgins
Nominator--Wellspring Living
Living a military lifestyle is how Julie has spent nearly her whole life. She has lived in 13 states and in England before settling in Duluth in November 2017 when her husband retired from the Air Force. She has a B.S. in business administration from Auburn University. Julie enjoys family time with her two sons and with extended family, which also provides opportunities to enjoy FL beaches and NC hiking and enjoyment of waterfalls and the great outdoors. She spends her time in GA serving and singing in the choir at her church, volunteering at Treasures (upscale resale store to benefit Wellspring Living), and facilitating a Bible study group in the community.
6555 Sugarloaf Parkway, Suite 307-198 Duluth, GA, USA
wcscccharities@gmail.com
Welcome to our new forum.
Here you can find a great community for sharing new ideas and talking about day-to-day life.
Enter Forum
Copyright © 2021 All rights reserved - WCSCC Charities, Inc.


Brian Fritzsche joined Moller Financial Services in 2018 as a financial planner. Prior to his tenure at the firm, he spent over eight years as a financial derivatives trader at DRW Trading Group in Chicago. While at DRW, Brian worked in the trading pits at the Chicago Board of Trade, grew relationships with options brokers, and executed trades electronically.
Brian's goal is to enhance clients' understanding, knowledge, and decision-making while facing financial decisions. He focuses on making sure all client needs are met and assists with financial planning and quarterly reporting. Brian strives to provide comprehensive and holistic solutions in order to help prioritize and achieve financial goals.
Brian earned a Bachelor of Arts degree in Economics from Stanford University and has held the Chartered Financial Analyst® designation since 2013. He passed the CFP® Certification exam in 2017. Brian lives in Glenview with his wife, Emily, and their 15-pound Alaskan Klee Kai, Madison. He and Emily enjoy traveling, attending concerts, and spending time with both of their families.