Looking At Pretty Graphics Of Dot Com Demographics
I'm unemployed and bored.
With all the talk about dotcom booms and people moving away and all these really general statements people are making; i was curious as to what's really going on now, what went on four years ago and what effect did the boom really have on this community.
So.. i wrote a script that went through the craigslist archive on egroups and tallied the number of postings each day for each category then i stuffed it in a database and made a grapher tool.
It's kinda neat cos you can basically see some somwhat hard data on what the san francisco bay area has been doing over the past four years. you can graph job postings from various industries against things like apartments for rent or housing wanted postings, also for sale postings and resumes.
Some of the interesting things I found is that the number of housing wanted postings seems to be slightly down recently but pretty much unaffected by the drop in jobs. perhaps people are always in a state of wanting to move to a city.
One thing to bear in mind, this data isn't one hundred percent accurate for a few reasons... people do repost their information multiple times in a given month, sometimes people post a number of avaliable apartments in a single posting and craigslist has become significantly more popular over the years in question. however, I do still think that it makes for a decent general indicator of trends in our community. (I'm considering doing some kind of normalizing based on the total volume of posts- I need to think about it some more)
(Unfortunately, personal listings aren't archived. I guess that's a good thing... but I guess it also would have been cool to graph activity on the personals categories against some of the categories that reflect the general state of the economy. (maybe when people aren't tied up in career they start to think about more important things, or maybe not...) )
Either way, the data is there, you can look at it for different time periods and categories. draw your own conclusions and have fun!
The url is here:
http://www.signal11.com/charts/chart-o-m atic.cgi
take it easy..
--adam "
Not just Silicon Valley is being affected by the job crunch - there are a lot of GOOD people out of work in the Los Angeles area too. Not FrontPage monkeys either, real designers and coders.
Now, enough praise...
There seems to be some data missing - most notably the "people" data, which would have been interesting to plot the migration of people to and from the area as opposed to housing availability, jobs availability, etc. The other thing is that the server sometimes seems to return an error for some reason or another, although this may be due to the
But other than that, a good attempt, and certainly some good ideas there.
Smegma.
A lot of people have been laid off - a few of them are talented hackers. But really, the vast majority of dotcom casualties were overpaid frontpage monkeys who will never get a real job outside of bagging groceries or serving fries.
just b/c you lost your job does not mean that you are quite ready to pick up and leave immediately. Most people are going to try and find a job in the general vicinity *first*, then if they cannot find anything a relocation would be necessary. I would assume that is why there is little change in that department.
The guys who are MCSEs and FrontPage Monkeys will be out of work for a LONG time. It seems the trend here in NYC is towards the UNIX/Linux world (seriously). :))
Since there are over 300,000 MCSEs here, and the companies that want them are disappearing, they need a new skill set.
There was always a minority of *NIX people, and THEY are the ones who can still be picky about the pay/job they want.
Since the financial industry is a UNIX world, AIX and HP/UX guys are in HIGH demand.
At the job I got a month ago, they were looking for a good UNIX admin for 10 months before they hired me! That's why their infrastructure in in such a state of disarray.
They hired me on the spot and wanted me to start same day. I am not even the best UNIX admin out there. (I still can't get the UNIX printing system
The market is flooded with Java guys from India who will work for less (Nothing against the East Indians..I'm just stating fact)
I now lead a department. Out of 100 in the department, 97 are from India/Pakistan.
They had NO trouble finding a job.
They all have UNIX skills, DB2 or Oracle and they all have Siebel skills.
If you're not a Liberal in your 20's, then you have no heart.If you're still a Liberal in your 30's you have no brain.
Like I said, this is just jealously, bitterness.. but a social group which lacks the basics of humbleness, and toots its own horn shamelessly, becomes a prick in the side of this lowly helpdesk worker.
oh, hell. I'm posting anonymously.
I don't feel sad for every one of the dot-com unemployed. Many of them were dreamers, who never lived in the real world.
There are/were thousands of silly dot-coms, with stupid business plans and cobbled-together technology. Many of these shops were not part of any "talent pool".
I remember this one guy who I worked with. Marc was a nice guy. Marc thought of himself as a strong manager who was helping to fuel the dot-com revolution.
But the fact is that Marc didn't have a clue about management OR technology - he was just caught up in a ball of momentum. Marc was in a high-profile position in a very high profile organization. But that fact alone didn't make Marc a capable guy.
Marc left us for the dot coms of Atlanta. The last I heard, Marc was still looking for a job. Not because of the economy, but because he didn't have any skills.
the slashdot effect is in effect. we underestimated the traffic it would generate and are moving the script to a bigger machine now.
if you can't get to it, please bear with us and try again in a few hours.
thanks again
--adam
Ralph Castain of Fort Collins, Colorado wrote the following, which began on the same page (12) as Google's ad, "Google Seeks Expert Computer Scientists"
--
There is no hatred more pure and true than that expressed by children.
After playing with the chart for a while and noticing the indication of an exodus from the bay area I began to get upset that all these "dot.com" people came to to bay area, jacked up the median rental and home prices, then bailed after things started going bad. Although rentals and home prices have started to level off they have, for the most part, not gone down. If they did that would accelerate our decent into resession. That sad thing is that's inevitable. Foreclosure rates have already gone up.
So now what I have to say to all the people who flocked here, threw high-test gasoline on the fires of the economy, burned everything to a crisp then took off, Thanks a whole lot from someone who was here a long time before you! I feel no pain for any of the dot.com loosers.
How about starting a head hunting service linked to the /. amount of people in the techincal field.
/. as a portal for answers. And OSDN could even charge a small subscription fee for all the new services.
Everyone bitches about issues, how about using
--
Computers are useless. They can only give you answers. Pablo Picasso (1881 - 1973)
You have it backwards. It was during the boom when people were wasting their talent, creating useless software and websites, justified by insane business plans. These hard times are a correction. Their unemployment is a sign to people laid off from the boom that they have wasted their previous years, and they need to find something next that truly will be useful.
Well...
:)
The resume is on there at the suggestion of someone on craigslist who said that I should put it on there. I thought it was a bit slimey but at the same time I figured that it couldn't hurt.
As far as it getting posted to Slashdot, I didn't post it and I *do* know the guy who posted it but I did not ask him to do so, nor did he tell me before he did it. (and his text is a bit cheesy, no?)
As far as useful statistics and normalizing based on total number posted. I am planning on adding that stuff. For the second version, I'm planning on adding normalizing, moving averages by day (right now it's only tallied by month) and possibly some other stats. (I've recieved a few good ideas from a few people and I've got some emails out to some math folks about how I might be able to do some interesting forecast graphs)
--adam
There's definitely a difference in the quality of the emails I get from software engineers these days. They're much more technically adept.
.coms neither had the interest nor the ability to solve real computer science problems and have now switched to non-technical, and for them, more interesting careers. Wired ran a story about how many armchair engineers from the 90's went back to school and followed their true passion to become actors, artists, and writers.
Seems as if most of the computer scientists working for
You might say the quality of software being written today is slightly up compared to the 90's because the only people programming are the ones who really want to do it.
Hi All,
Another unemplyed geek here. I wrote a set of perl scripts that graphed the # of Jobs available on computerjobs.com for several cities. It is on the main page of AtlantaGeek.com
Visit Savagenumber.com
Long time reader, first time poster.
Just got my WIRED magazine subscription a short time ago, and what do I see on the cover "Why Linux will lose the desktop war: page 134".
Now before you tell me this has nothing to do with the dotcom boom and subsequent bust, I think you would do well to note these quotes from the article.
If that doesn't relate to the dot-com bust, I don't know what does. He goes on to state the following on the same page:
Pretty damming commentary from someone who supports Linux, don't you think? Or at least he still does, but on the server platform where it has gained the most ground.
Comments?
I'm sure that this will take forever to become a proper thread unto itself, that is why I've bothered to post it here today.
Desiato_Hotblack
** By reading this post, you've agreed to my EULA - which includes not modding-down due to difference in opinion. **
I could really make good use of those figures that show that an outsourced 1st level support position can cost $5k-$6k. I would be very grateful if you could post a citation on those numbers.
When information is power, privacy is freedom.
As astounding as this data is, it would be infinitely more useful (and accurate) if it were normalized againt actuall traffic usage on craigslist, so the growing/weaning popularity of the site wouldn't skew the demo data.
Anyone wanna get Craig's archived logfiles?
Kevin Fox
The source(s) and limitations are stated on the site and any one knowing statistics knows aswell how to use this one.
Good luck on the job hunt!
"The likes of Facebook and WhatsApp are free to those whose privacy is of zero value."
- March '98 to August '01
- apartments avaliable
- housing wanted
- resumes
- for sale
You can see that these all tracked each other fairly well up to December '99, when resumes/for-sale went off on their own, and apartments/housing stayed fairly even for a while.Then, apartment availability started shooting up around August '00, kind of tracked resumes/for sale for a while, and then shot through resumes in February, picking up for-sale which has tracked it ever since.
I'll leave it as an excercize for the reader to correlate all this with external economic factors, but I think it's pretty clear that for a while people were selling stuff to make the rent while they were looking for work, and then between August and February people started selling stuff because they were leaving the area.
The real Webmaven is user ID 27463. I don't rate an imposter, because my ID is such a lame-ass high number.
Anyone else notice the "yourmom=1" that is inserted in the URL when you use this? If you set it to zero or remove it, the graph won't use your start/end dates...funny.
the guy whop put the up the CG/webpage claims that the graphics are his copyright
correct me if I am wrong but he is redistributeing the database in a differant format
he is not doing any analysis or changeing the data in any way but redisplaying it
so he has no copyright claim at all as far as I can see bit of a joke really
regards
john jones
while i don't have too much knowledge as to the effects of the dotcom boom and bust nationally and globally, i have formed a few opinions on what has happened locally.
while the boom sucked in a number of ways: computer jobs became glamourous and attracted a lot of goldrushers or hollywood ego types, which made working in these types of jobs a little obnoxious. the people who i hated in high school who were stuck up and going to fancy colleges found themselves getting rich in marketing and management positions, riding on the backs of the geeks who actually did the work. the talent pool was suddenly flooded with people who weren't really into what they were doing but they were doing it because that is where the money was. etc..
it also did a few cool things: it provided a way for slackers, artists, writers, etc to actually earn a living wage. (not exemplary salaries, but salaries that actually made it possible for them to live reasonably comfortably in the bay area) suddenly people that had been making peanuts could make a decent salary 30-50K and live comfortably knowing that they could pay their bills and some were gaining a skill that could turn into a career.
unfortunately, things got out of hand when the aforementioned fancy college educated folks had a little too much money to play around with and traders saw a wave of hype which they could ride to grow their assets. idiotic companies with pathetic business plans, idiot management and stupid ideas were recieving insane amounts of venture capital, which they were happy to spend the majority on things like office adornments, lame marketing and other things irrelevant to the core products they were building.
when this all was happening, the rest of the economy grew to support all these new businesses needing services and now that they're all gone, not only is the technology industry affected, but also the industries they relied upon and the industries those industries relied upon. hopefully the ripple won't be catastrophic.
personally, i was happy to see the bubble burst at first for the reasons i listed above. i was sick of hollywood ego internet types and this sudden 'coolness' that surrounded all things internet. i was also sick of seeing people who had no real interest in technology at all get filthy rich off of the hype.
however, now my opinion has changed a little. a lot of my friends are in fairly gnarly positions as a result of the layoffs. they weren't trying to get rich, and never were. they just wanted a honest living wage for a days work. they had the promise of a career and living wage for the years to come laid out before them and now it's all vanished into thin air.
in one way, i think it's a good thing, because the boom distracted people from what they really wanted to do with their lives. while doing operations for a dotcom may pay decent, it's not the most productive thing to do with one's eight hours a day in the grand scheme of things. (given that someone is not completely a geek at heart) now people are being forced to reevaluate themselves and their master plans for life, some are going back to college, some are persuing art, others are getting involved in vocations that they've been meaning to do for a while and i think that that is a very good thing.
i think that it is also a good thing for technology. now that there are less distractions and promise of riches for geeks working on bunk technologies, there will a decent talent pool of geeks looking to work for a decent wage on something that is technologically cool. that is also pretty exciting. while venture capitalists may be stopping the handouts, they're not going to stop completely and now they're not going to have nearly as many proposals to review. i'm hoping that in the next couple years we'll see a number of new companies that are doing stuff that is truly innovative.
...Anyone who just skimmed the above and has some mod points to spare, re-read the above post and mod it up.
More realistically, though, thinks UptownGuy...
You'll just have to settle for my high praise, anonymous coward, whoever you are. There is so much truth in what you wrote above... I actually took the time to read it and re-read it over 5 times. Especially the last paragraph. Truth with a capital "T" my friend. Techie or not, dot-com casualty or not, they are still words of wisdom!
I would have to say that explosives are the most abused technology in all of history.
I don't believe there was ever a time housing prices dropped in the bay area. Even in the recessions of 1992 and 1980 prices continued to rise, though at a slow rate. The key is to lock in a down payment while you're still young, before the inflation curve leaves you behind forever. Most of my college friends either got a house as soon as they graduated or forever paid rent.
If you go to Atlanta Geek's home page, someone has been tracking the number of job postings for various cities around the USA, with data taken from ComputerJobs.com. If this is reflective of the actual IT market (when in fact it's also reflective of third-party recruiter activity), it would appear that most cities have lost 20% of their jobs in the past month, but Boston! They've leaked 30%!
You hire people based on how good their Slashdot posts are? I've heard of weird interview techniques, but this takes the cake!
-- ;-)
Kuro5hin.org: where the good times never end.
The economic hardtimes that the dotcom (and other IT-related) companies are seeing now it quite self inflicted.
Those companies has not had a working business-model. The major part of the dot-coms have lived on banners and thats just unrealistic.
In you put ads in a newspaper you can get nice big ad-space that really draws attension to your products. Compare that to a banner at the top of a site, do even someone look at them?
And for other IT-related companies I think the focus on market-share instead of revenue just makes it impossible to keep companies alive. Many seems to have thought "market share is everything, revenue is something we deal with then the VC money is gone".
Many has given their products away for free and have thought that later down the line they are going to be able to charge for it. Personally I think it's very hard to make people pay for something that they got for free before. If not impossible.
Extracting data from a web site and graphing it is a useful skill, but I would expect any reasonably smart college student to be able to figure this stuff out. It takes a lot more than that to succeed and innovate when it comes to computers.
Hey, you mind letting me know when you get laid off, so I can remind you of your post and laugh at you??
I've known plenty of companies that lay off not based on "lack of talent" but because of high pay scales...
so those complaining about being unemployed are often unemployed because they won't take a 30-40% cut in their asking price.
(I have a friend who was a web producer who was looking for a year, and didn't find anything until he chopped his asking price and broadened his job objective... he was hired pretty soon after that).
I bet there aren't a whole lot of CEOs out there who've taken a 30-40% cut in what they get paid.
(IMHO, the "REAL WORLD" prefers "tinie punie" tricks... for example sales people are highly paid for the "punie" trick of being likeable and persuasive. More highly paid than those who have the REAL talents of making the things they're selling.)
-marsh
This is also the basis of much age-based discrimination -- older and more senior workers cost more. Illegal, but so what?
Here's a prime example that any slashdotter can relate too, even though it's not in our industry. Back in 1994, Paramount had an extremely successful syndicated series. But it had been on the air for seven years, all the regular actors had huge fan bases and plenty of leverage to demand higher and higher salaries. The solution must have seemed obvious: cancel the series and start something close enough to grab the same viewer base. So The Next Generation (not great TV, but it had its moments) was replaced by the putrid Voyager.