We whined yesterday that the O's version of the Oregon PERS beneficiary database was too filtered to be of much practical use. In response, Mark Friesen of the O gave us all a link to the full database file -- a heavy, heavy .csv file running over 3 megabytes. Older versions of Excel can't handle it, and even translated into a web page by a text editor, it's a monster.
Anyway, here's an html page with the whole list, Aardvark to ZZ Top. Not much more useful than what the O has provided -- maybe less -- but we'll keep working on it. Maybe we'll try for three files that older Excel can handle.
While we do that, think about it -- there are more than 105,000 PERS beneficiaries. And if each of them has one other sympathetic voter in their family or household, that's 210,000 votes leaning heavily against government employee pension reform in Oregon. No wonder John Kroger's the state attorney general, and the place is going broke.
UPDATE, 11/30, 4:06 p.m.: Update (with an Excel file) here.
Comments (15)
And then think of all the current .gov employees local, state, and fed and then all the contractors who exist solely on .gov contracts and then you see it's quite the miracle that the PPS bond measure failed.
That is exactly the numbers game that liberals hit on over the last 20 years. They figured out that they could buy votes with taxpayer money. They made the choice to focus large sums of money on public union members in order to buy votes.
As John points out, it is exactly the same process used in Greece and other Euro countries. The non-union working class is forced to transfer money to the segment of the population that votes Progressive. The Progressive politicians take the money and hand it out to friends and family.
Most of the politicians in Oregon follow this model. They all are determined to shovel as much tax money as possible to friends and family while they are in office. Any talk of "reform" brings out the big guns. Everyone is enlisted to protect the gravy train.
Repeat the process until bankruptcy. I don't think Progressives have a plan after bankruptcy. They just want to get rich before we go broke and then they'll let someone else deal with it.
(And no, it's not the named parties involved! Here in the 21st century Republicans/Conservatives are as self serving in opposition and crooked in power as Democtrats/Progressives. The glorious future is here!)
Oregon has 3.5M. Probably at most 2M are registered to vote. Standard election, 40% show up = 800,000.
Think of all those PERS accounts showing up 100% (give the public employee unions credit, they do get out the vote) to make sure their benes are protected = 200K out of 800K total.
Steve, what formula are you using for PV? A present value of $451 billion is about 167 years of $2.7 billion annual payments. (The $2.7 billion of annual payments DOES match what PERS has on its website, on page 18 of this document:
I just want to say to Andy that this has nothing to do with Liberals. I am so tired of every time someone has a complanit they have to blame a Liberal or Conservative. That is alienating and just keeps us from focusing on how to fix it. I am a Liberal and I hate PERS. I think it was designed by people that were simply ignorant and we have those on both sides of the aisle. Let's get it changed!!
Charamba, Douro 2008
Horse Heaven Hills, Cabernet 2010
Lorelle, Horse Heaven Hills Pinot Grigio 2011
Avignonesi, Montepulciano 2004
Lorelle, Willamette Valley Pinot Noir 2011
Villa Antinori, Toscana 2007
Mercedes Eguren, Cabernet Sauvignon 2009
Lorelle, Columbia Valley Cabernet 2011
Purple Moon, Merlot 2011
Purple Moon, Chardonnnay 2011
Abacela, Vintner's Blend No. 12
Opula Red Blend 2010
Liberte, Pinot Noir 2010
Chateau Ste. Michelle, Indian Wells Red Blend 2010
Woodbridge, Chardonnay 2011
King Estate, Pinot Noir 2011
Famille Perrin, Cotes du Rhone Villages 2010
Columbia Crest, Les Chevaux Red 2010
14 Hands, Hot to Trot White Blend
Familia Bianchi, Malbec 2009
Terrapin Cellars, Pinot Gris 2011
Columbia Crest, Walter Clore Private Reserve 2009
Campo Viejo, Rioja, Termpranillo 2010
Ravenswood, Cabernet Sauvignon 2009
Quinta das Amoras, Vinho Tinto 2010
Waterbrook, Reserve Merlot 2009
Lorelle, Horse Heaven Hills, Pinot Grigio 2011
Tarantas, Rose
Chateau Lajarre, Bordeaux 2009
La Vielle Ferme, Rose 2011
Benvolio, Pinot Grigio 2011
Nobilo Icon, Pinot Noir 2009
Lello, Douro Tinto 2009
Quinson Fils, Cotes de Provence Rose 2011
Anindor, Pinot Gris 2010
Buenas Ondas, Syrah Rose 2010
Les Fiefs d'Anglars, Malbec 2009
14 Hands, Pinot Gris 2011
Conundrum 2012
Condes de Albarei, Albariño 2011
Columbia Crest, Walter Clore Private Reserve 2007
Penelope Sanchez, Garnacha Syrah 2010
Canoe Ridge, Merlot 2007
Atalaya do Mar, Godello 2010
Vega Montan, Mencia
Benvolio, Pinot Grigio
Nobilo Icon, Pinot Noir, Marlborough 2009
Portuga, Rose 2011
Revelation, Chardonnay, Pays d'Oc 2010
Beaulieu, Cabernet, Rutherford 2005
Monte Alto, Tinto Reserva 2005
Chateau Ste. Michelle, Cabernet, Indian Wells 2009
Espiral, Vinho Rose
Vin-Koru, Pinot Gris 2011
14 Hands, Hot to Trot Red 2009
Rodney Strong, Cabernet, Sonoma 2009
Abacela, Vintner's Blend #11
Portuga, White 2010
La Bourgeoisie, Red 2009
Januik, Red 2009
Three Rivers, River's Red 2008
Kirkland, Alexander Valley Merlot 2008
Muga, Rioja Rose 2010
Quinta das Amoras, Vinho Tinto 2009
Mauro Molino, Barbera d'Alba 2009
Garda Chiaretto Rose
Columbia Crest, Two Vines Vineyard 10 White
Chateau Ste. Michelle, Pinot Gris, Columbia Valley 2009
L'Hortus, Rose de Saignee 2010
Maculan, Pino & Toi 2008
McKinley Springs, Bombing Range Red 2008
Trader Joe's Pinot Gris 2009
Montes Alpha, Cabernet 2007
Gran Sasso, Sangiovese, Terre di Chieti 2009
Garda, Classico Chiaretto Rose
Beaulieu, Cabernet, Rutherford 1999
Picos del Montgo, Tempranillo 2008
Chateau de Montmirail, Vacqueyras 2008
La Granja 360, Syrah 2009
Montgras, Carmenere Reserva 2009
Lange, Pinot Gris 2009
Columbia Crest, Horse Heaven Hills Cabernet 2008
Kirkland, Pinot Grigio 2010
Trader Joe's Coastal Syrah 2009
Columbia Crest, Horse Heaven Hills Merlot 2008
Trader Joe's Coastal Chardonnay 2009
Vieux Papes Red
Domaine de l'Aujardiere, Chardonnay 2009
Santa Rita, Cabernet, Medalla Real 2007
Penfold's, Koonunga Hill Shiraz Cabernet 2008
Guild, Red, Lot #02 2008
Dievole, Dievolino Sangiovese 2008
Laforet, Burgogne Chardonnay 2009
Columbia Winery, Merlot 2007
Bonterra, Cabernet 2008
Elk Cove, Pinot Gris 2009
Maquis Lien 2006
Scott Paul, Pinot Noir, Le Paulee 2007
The Occasional Book
Neil Young - Waging Heavy Peace
Mark Bego - Aretha Franklin, the Queen of Soul (2012 ed.)
Jenny Lawson - Let's Pretend This Never Happened
J.D. Salinger - Franny and Zooey
Charles Dickens - A Christmas Carol
Timothy Egan - The Big Burn
Deborah Eisenberg - Transactions in a Foreign Currency
Kurt Vonnegut Jr. - Slaughterhouse Five
Kathryn Lance - Pandora's Genes
Cheryl Strayed - Wild
Fyodor Dostoyevsky - The Brothers Karamazov
Jack London - The House of Pride, and Other Tales of Hawaii
Jack Walker - The Extraordinary Rendition of Vincent Dellamaria
Colum McCann - Let the Great World Spin
Niccolò Machiavelli - The Prince
Harper Lee - To Kill a Mockingbird
Emma McLaughlin & Nicola Kraus - The Nanny Diaries
Brian Selznick - The Invention of Hugo Cabret
Sharon Creech - Walk Two Moons
Keith Richards - Life
F. Sionil Jose - Dusk
Natalie Babbitt - Tuck Everlasting
Justin Halpern - S#*t My Dad Says
Mark Herrmann - The Curmudgeon's Guide to Practicing Law
Barry Glassner - The Gospel of Food
Phil Stanford - The Peyton-Allan Files
Jesse Katz - The Opposite Field
Evelyn Waugh - Brideshead Revisited
J.K. Rowling - Harry Potter and the Sorcerer's Stone
David Sedaris - Holidays on Ice
Donald Miller - A Million Miles in a Thousand Years
Mitch Albom - Have a Little Faith
C.S. Lewis - The Magician's Nephew
F. Scott Fitzgerald - The Great Gatsby
William Shakespeare - A Midsummer Night's Dream
Ivan Doig - Bucking the Sun
Penda Diakité - I Lost My Tooth in Africa
Grace Lin - The Year of the Rat
Oscar Hijuelos - Mr. Ives' Christmas
Madeline L'Engle - A Wrinkle in Time
Steven Hart - The Last Three Miles
David Sedaris - Me Talk Pretty One Day
Karen Armstrong - The Spiral Staircase
Charles Larson - The Portland Murders
Adrian Wojnarowski - The Miracle of St. Anthony
William H. Colby - Long Goodbye
Steven D. Stark - Meet the Beatles
Phil Stanford - Portland Confidential
Rick Moody - Garden State
Jonathan Schwartz - All in Good Time
David Sedaris - Dress Your Family in Corduroy and Denim
Anthony Holden - Big Deal
Robert J. Spitzer - The Spirit of Leadership
James McManus - Positively Fifth Street
Jeff Noon - Vurt
Road Work
Miles run year to date: 21
At this date last year: 52
Total run in 2012: 129
In 2011: 113
In 2010: 125
In 2009: 67
In 2008: 28
In 2007: 113
In 2006: 100
In 2005: 149
In 2004: 204
In 2003: 269
Comments (15)
And then think of all the current .gov employees local, state, and fed and then all the contractors who exist solely on .gov contracts and then you see it's quite the miracle that the PPS bond measure failed.
Posted by Pistolero | November 29, 2011 8:09 AM
Greece.
Posted by John Rettig | November 29, 2011 9:06 AM
OpenOffice doesn't have a problem with more than 64k rows. I'm not terribly fond of it, but the price is right!
Posted by CM | November 29, 2011 9:54 AM
That is exactly the numbers game that liberals hit on over the last 20 years. They figured out that they could buy votes with taxpayer money. They made the choice to focus large sums of money on public union members in order to buy votes.
As John points out, it is exactly the same process used in Greece and other Euro countries. The non-union working class is forced to transfer money to the segment of the population that votes Progressive. The Progressive politicians take the money and hand it out to friends and family.
Most of the politicians in Oregon follow this model. They all are determined to shovel as much tax money as possible to friends and family while they are in office. Any talk of "reform" brings out the big guns. Everyone is enlisted to protect the gravy train.
Repeat the process until bankruptcy. I don't think Progressives have a plan after bankruptcy. They just want to get rich before we go broke and then they'll let someone else deal with it.
Posted by Andy | November 29, 2011 10:07 AM
Same as it ever was.
(And no, it's not the named parties involved! Here in the 21st century Republicans/Conservatives are as self serving in opposition and crooked in power as Democtrats/Progressives. The glorious future is here!)
Posted by EB | November 29, 2011 10:38 AM
210,000 votes you say?
Lets include in that voter block all the children of the PERS beneficiaries who don't want either mom or dad looking to them for financial support.
Posted by Abe | November 29, 2011 10:49 AM
That data needs something like Access or oracle to process. Excel kind of sucks with real world data.
Posted by Pistolero | November 29, 2011 1:53 PM
OK, slow day. I summed it up:
Sum $228,040,694.58/month
Sum $2,736,488,334.96/year
PV ($451,580,390,096.78)
20 yrs @ 4% per annum
Now who knows today's balance of what they actually have in the account so we know our unfunded liability.
I gotta say, I just don't see $451B in the account today. That's about 30 biennial budgets for the state of Oregon, right?
Just think 1% of that going to schools. Just think every PERS reicpient who moves out of state won't pay OR $0.01 in income tax on that amount.
Posted by Steve | November 29, 2011 2:25 PM
"210,000 votes you say?"
Oregon has 3.5M. Probably at most 2M are registered to vote. Standard election, 40% show up = 800,000.
Think of all those PERS accounts showing up 100% (give the public employee unions credit, they do get out the vote) to make sure their benes are protected = 200K out of 800K total.
That bloc will vote in lock-step.
Posted by Steve | November 29, 2011 2:40 PM
Steve, what formula are you using for PV? A present value of $451 billion is about 167 years of $2.7 billion annual payments. (The $2.7 billion of annual payments DOES match what PERS has on its website, on page 18 of this document:
http://oregon.gov/PERS/docs/general_information/pers_by_the_numbers_11_11.pdf
Posted by PM | November 29, 2011 3:40 PM
"what formula are you using for PV?"
One that assumed annual pmts as monthly pmts.
My screw-up and my apologies to all the deserving PERS members:
($37,631,699,174.73) = PV
$37B makes a lot of diff obviously (still about 5 years of Oregon's state budget.)
I'd really be curious how much money is in the PERS acct today.
Posted by Steve | November 29, 2011 3:58 PM
Steve, that's something I've done before with calculations. It looks like the PERS fund data is posted monthly on the Treasury website, here:
http://www.ost.state.or.us/FactsAndFigures/PERS/Monthly/2011/OPERF_1011.pdf
Posted by PM | November 29, 2011 8:52 PM
And we're outta' here and moving to NJ where it's, what? Crap, worse. I can't win.
Posted by Canucken | November 30, 2011 7:30 AM
"It looks like the PERS fund data is posted monthly"
Interesting, the fund is worth $57B. So you need about $42B to support the existing retirees.
Then I read the report that another 70K are able to retire, so they have about $15B to support those.
All this assumes they don't have another 2008 year (or a Jul-Sep 11 where NAV dropped 10%).
Posted by Steve | November 30, 2011 11:47 AM
I just want to say to Andy that this has nothing to do with Liberals. I am so tired of every time someone has a complanit they have to blame a Liberal or Conservative. That is alienating and just keeps us from focusing on how to fix it. I am a Liberal and I hate PERS. I think it was designed by people that were simply ignorant and we have those on both sides of the aisle. Let's get it changed!!
Posted by Teddi | November 30, 2011 11:47 AM