US City and State CSV File

I've seen requests for this type of file on a few forums. Well, I just happen to have a pretty large list of those cities and states at my disposal, so I'm posting it on HTMLMonitor.com for anyone to download.

If you want any more data to go with it, just let me know. Otherwise, enjoy.

US City and State CSV File

Comments

rumblepup said…
You forgot the zips! Actually, a great source.
Thursday, January 04, 2007 9:22:00 AM
Brian Mark said…
I could create that file as well, though it's not quite complete. If you'd like it, I'll email it to you.
Thursday, January 04, 2007 9:56:00 AM
Post a Comment

Popular posts from this blog

Yii multiple select dropdownlist with default values

So I was coding a form in Yii, and came across a situation where I had a value of 0111110 (no, yes, yes, yes, yes, yes, no) that I needed to pre-populate values in a multiple select drop down. This didn't seem like it should be that hard, but the Yii documentation lacked a bit there. The first step was to split out the string. $optionValues = str_split($model->variable); Now, we create a blank array to hold our options. $options = array(); Then, we go through those options and set selected on the ones that need selected. foreach ($optionValues as $optionKey=>$optionVal) {      if ($optionVal) {         $options[$optionKey] = array('selected' => 'selected');     } } Now, we render the drop down list. echo $form->dropDownList($model, 'variable', array('0' => 'Zero', '1' => 'One','2'=>'Two','3' => 'Three', '4' => 'Four', '5' =...
Read more

Need some feedback

Image
Once again, we've made lots of changes at ToolBarn. But now, I'm looking for some feedback. We've got a cache on our local servers of what most of the competing sites are priced at on every product we offer. If we show that, similar to Progressive Auto Insurance, are we asking for trouble? Two thoughts on why we should : 1) Establish ourselves as a destination. 2) Give our customers less reason to leave our site and look around. Two thoughts on why we should not : 1) We may not always have the lowest price. 2) We've got more traffic than most of these sites, so we'd be building their brand for them. Such a tough choice. We'll probably run an experiment at some point and see what it does. What do you think?
Read more

Wal-Mart's pricing is different online

Image
As I was browsing Wal-Mart.com for a monitor today, I noticed they had one for less than most of the other online sites I usually check out. I decided that since this wasn't an "Online Only" listing that I'd head over and pick one up. I didn't have much trouble finding it in the store (they don't have much selection, so it's easy to spot it), then I went to the checkout. I was grabbing the one below: I wasn't thinking about it much as I approached the register, but when the lady scanned the box and it came up as $192, I wasn't pleased. $22.12 extra just for shopping in the store? That's not right. That's an extra 13%, plus I'll have to pay more in sales tax. For now, Wal-Mart is on that list that begins with the letter "S" once again. Not that they ever stray much from that list, but I've got another reason. Too bad my hometown doesn't have much else to choose from. I'll have to venture out after work one of these ...
Read more