GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together. Yes. Learn more. Thanks so much! Only two of the state capitals — Trenton, New Jersey, and Carson City, Nevada — border another state, while Juneau, Alaska, shares a border with the Canadian province of British Columbia. Scott has saved the day and cut many hours off a project, if not days!

(SHA1: 30E7C3C17BA818129C2D3535F737F7907256F8AD), 50_us_states_two_letter_abbreviations.csv Submitted by editor on 27 January, 2014 - 12:23. This contains list of 3143 Counties & county equivalent of US. In 33 of the 50 U.S. states, the state capital is not the state's most populous city. Yes. Once I had these sorted, I deleted all the non-ppl designations, and I then deleted all the …

Buyer Beware! In 33 of the 50 U.S. states, the state capital is not the state's most populous city. Database updates are performed four times per year at the start of January, April, July and October. We do not store or permanently record your card details. Clicking this link will download the full database directly to your computer. Check the Data tab in the Excel ribbon.

Gaines|PA|Pennsylvania|TIOGA|Manhattan 61 states total (including foreign and military): … This contains list of 50 US state & their capitals.

The US Cities CSV download has cities broken down by state, and provides metro name, code and the state abbreviation, and is available under a Creative Commons Attribution 3.0 License.

In order to create the data set, I downloaded the US Concise file from USGS, and imported it into an Excel spreadsheet. It saved us a ton of time…” Business; $79.95: Business and/or Commercial use: SQL, Excel and CSV: Quarterly updates included For a period of 1 year: Updated for Summer 2020: Immediate online download: Helpful and friendly online support: … CONVERSIONS BETWEEN COMMON UNITS OF SPEED, 50_us_states_two_letter_abbreviations.csv, http://www.whypad.com/posts/excel-spreadsheet-of-us-states/583/, http://www.whypad.com/wp-content/uploads/us_states.zip, https://owl.english.purdue.edu/owl/resource/735/02/, http://www.extendoffice.com/documents/excel/865-excel-create-custom-list.html, http://www.whypad.com/posts/excel-spreadsheet-of-us-states/583/comment-page-1/#comment-3197, Introduction to Scale-Invariant Feature Transform (SIFT), Types of Problems Machine Learning Can Solve, Review of Tesla’s Short Self-driving Proof of Concept, [Solved] … is not a supported wheel on this platform. If nothing happens, download the GitHub extension for Visual Studio and try again. We accept payment with credit card, debit card or PayPal from almost anywhere in the world – including Canada, Australia, India, the United Kingdom and all EU countries. Only two of the state capitals — Trenton, New Jersey, and Carson City, Nevada — border another state, while Juneau, Alaska, shares a border with the Canadian province of British Columbia. [a] The dates listed in the following table indicate the year in which the city started to continuously serve as the state's sole capital. Download list of State Capitals of United States in Excel, CSV and PDF free of cost. I have a file with around 6,000 zip codes and when I paste it into your Excel sheet it is only returning about 1500 of the city and states. Includes linked counties, states, ZIP codes, latitude-longitude, populations and more. MS Excel(2007) PDF CSV Zip of all formats Related Downloads. The appropriate amount in your local currency will be billed to your card or PayPal account based on the current interbank exchange rates.