How can I find all public corporations that match the following criteria:
Located in one of the following MSAs - Las Vegas:AZ, Phoenix-Mesa:AZ, Los Angeles-Long Beach:CA, Oakland:CA, Orange County:CA, Riverside-San Bernardino:CA, San Diego:CA, San Francisco:CA, San Jose:CA, Ventura:CA, Boulder-Longmont:CO, Denver:CO, Ann Arbor:MI, Detroit:MI, Lansing-East Lansing:MI, Las Vegas:NV, Austin-San Marcos:TX, Dallas:TX, Houston:TX, San Antonio:TX
Located in one of the following MSAs - Ann Arbor:MI, Detroit:MI, Lansing-East Lansing:MI
I searched using this database; however, the database does not filter for both criteria. After systematically checking, I compiled a list that matched the criteria. My problem is that the database is not exhaustive. For example, ironically, I found out that Google has a US office location in Detroit:MI while the database does not list any location in Detroit:MI. What database(s) can be used to find all the results based on my criteria?
Correct me if I’m wrong, but a single corporation is usually incorporated in only ONE state. Multinationals are typically incorporated in each country where they have sufficient presence, but not across the united states.
That is what I am thinking too. I will even go out on a limb and say that no such database exists. I can’t think of a reason one would have every single location for every publicly traded company. Many companies have small satellite offices all over the place. What about retail locations?
May I inquire what this query is for? It might help us figure out how to get the info if it is even possible.
If a library near you has access to ReferenceUSA (business edition), it has the ability to search by ZIP code or city/state along with limiting the search to publicly traded companies. While you can search for multiple ZIP code locations, the search function considers it an OR - meaning you will get all companies in both areas, not just those that exist in both.
Thinking about it now, I’d go to a library (academic with a business program should have a copy, public libraries may or may not) and check Dun & Bradstreet’s America’s Corporate Familes. IIRC (since I’m not at work at the moment), it has a geographic index that you can use to identify companies in a specific area, then you can see where else those companies have offices. These will mostly be publicly traded - but the entry for each company will tell you specifically.
The other print option is Ward’s Directory of U.S. Public and Private Companies - again, I believe this set has the information, but I don’t know off the top of my head.
Take a look at this map. This map shows that Intel is not based in Detroit, does not have a presence, a branch, whatever you want to call it.
My ideal job is headquartered or based in the Southwest AND headquartered or based in Detroit. Why? Because I want to to live either in the Southwest or in Detroit while being able to travel back and forth between these two regions. If I’m relocated in San Diego, for example, I can travel back home for business purposes and might get time to see family. Based on my criteria, Intel is not among my the ideal companies.
There are 15 million US companies. Looking up each company and finding out if they match my criteria would take waaaay too much time. There must be a better way. Only with a list of corporations meeting my criteria can I make an informed decision.
I agree. The title of the thread turned out to be a lie too. As someone who has frequently changes jobs in IT consulting, I have never heard of such specific criteria for finding a place to work. The idea that one could just travel back abd forth between desired regions pretty much at will is a little strange. You could get a job that had offices all over and never get to leave your home cubicle.
You are, of course, entitled to your opinion. But I wish that you would at least be civil and be open to ideas.
My uncle is in the phamacutical industry with a company based in Washington DC. It didn’t seem strange that I got the opportunity to spend weekends with him in Washington. But that’s besides the point. What I am getting at is there’s something that all of us are up against. When I post on SDMB, I know that I will be in for a challenge. But it’s a whole other ballgame when you go out into the real world. There may be criticism and misunderstandings here but go out there and it’s all different.
It’s the system that wrong. You said it yourself “you could get a job that had offices all over and never leave your home cubicle”. No, you could be an employee of a company that has office all over and never leave your home cubicle. But that would be that person’s fault. I’m not going to be that person. Two words: corporate jets. If that sounds strange, then so be it. Yes, eventually, I’m going to make it to the top because I’m not going to be like the rest of the sheep. And even if I don’t make it, I will still be able to travel because I may go into marketing or advertising where it’s all about targeting the geographic location and the democraphic.
The title is no lie! I am indeed looking for a company NOT a job. I’m try to get out of the mind set of how to find employment. I know I want to go into marketing; now I need to find a good company. Virtually every company needs a good marketing department. They may not be posting their j-o-b today but if I research all my prospective employers then I will be ahead of the game. Most of the information about locations is under investor relations and not careers. And I know that most openings aren’t even advertised. Gee, I wonder why?
Information is power. Since I’m most likely going to be in marketing, I’m going to narrow down the companies based on my criteria. Why? I’d at the very least have a chance of visiting my family back in Michigan. I’m not niave; I know there’s no gurantee, but at least I’ll have a chance! And I’ll even have a greater chance if I go into marketing as I pointed out. This is how I want to find a corporation for employment. It may not be your thing, but I am entitled to my opinon.
Good for you! Except, by the time you can get hired in a job where you get a choice of when and where to travel, if ever, is the time when you’ll already know the corporations that have offices here and there in YOUR industry, so you’ll be able to apply to a specific company.
Knowing where the offices are now, before you’re upper management, gives you no useful information and only makes your path a lot harder.
I am not opposed to your general ideas, it is the reality that seems off. I am guessing that you have never really worked in marketing or advertising for a big company because any of the people that I know that have worked in those fields would never make such claims (and they are successful ambitious people). I have worked for several big, famous companies. Younger employees that get to ride on the corporate jet (do many companies even have those now?) are going to be worked so hard that they will forget that they even have a family. Shooting up tthe ladder that fast means that virtually everything else must go. If it was that easy, don’t you think other people would be doing it all the time?
I have had jobs with travel. I had one job where I had to work one week a month in Indiana. I didn’t hate it but I don’t know anyone in Indiana. I worked a 12 hour day, went out to dinner by myself, and went back to the motel. The next week, a coworker would fly in and do the same thing. That is pretty typical for corporate travel and I know lots of people that do it.
OTOH, I can give you an example that did work. My mother is an international speaker. She travels about 15 - 20 days a month to all 50 states, Europe, and Asia. New England isn’t a huge convention hotbed but she does get engagments 3 - 6 times a year that are close enough and long enough so that she can see us (especially her only granddaughter). She drops by so often it seems like she lives down the street rather than 2000 miles away. Her profession is also her own business however and even she doesn’t have complete control over where she goes.
Honestly, you are much better off getting a job that pays well and gives you enough free time so that you can visit whoever you want on your own terms.
It’s a simple maxim that needs to be said. Where you live is just as important as what job you have. I hope that someone who is also searching for a job can give their insight.
Move where you want to live and then find a job there. Finding a job from where you are in a specific place where you want to be is silly, you’re annihilating your chances. Most jobs are filled locally first.
Don’t worry about where you’ll live (yet). Pick your career. You’ve mentioned Marketing. You should figure out if that’s something you’re really interested in, something to which you will devote a good portion of your life.
There are 14 million corporations. Of those there is hypothically a list with 5,000 jobs that would be *my * ideal. Three of them are Lucent Technologies, Southwest, and
Sprint. Therefore, I need to find 4,997 or so other corporations that are in common with the aforementoned three, in other words, those that fit my criteria.
I would be thrilled if I could limit my chances, that would mean I’d have options!
Rather than select from companies located in both places, choose a dynamic company located (preferably based) in only one. Once on board, put together a proposal to expand the business into the other location.
This will involve frequent travel between the locations.
When the opportunities for the company warrant it, you will naturally be chosen to establish a permanent presence in the new market. Lots of kudos, lots of money, and undoubtedly lots of travel between your branch and head office. In your company jet of course.
That’s how a real higher flyer would do it.
(I’m only half joking - our company established two international markets pretty much exactly like this. I wasn’t the person who did it in either case, but I do now get to visit all of our offices.)
Lord Mondegreen, yes I could do that. I also could start my own company. But first I want to do it this way.
From 36,000 corporations I found 100 that matched my criteria. Then I narrowed down those 100 to 11. BBDO,Campbell-Ewald, Proctor & Gamble, Kimberly-Clark, Georgia-Pacific, Quest, Lucent Technologies, Southwest, Sprint, Verizon, and SBC.
That means that from 14 millions corporations there are at least 4277 corporations that are my ideal. I want that list of 38,000 corporations that fit my criteria. I need that list to narrow down my options to the roughtly 4,000 corporations that are my ideal.