Paid for by patrons
Weekly Content Selection #44
This week I worked diligently on my population data projects. I'm still working on expanding the population data for my "part one" article regarding the DESW (developed English speaking world) to each decennial census of the nineteenth century. The United States Bureau of the Census didn't publish a collectively exhaustive list of all of the municipalities in the country until the 1900 census. The 1890 census had a list of all municipalities above 1,000 inhabitants. The 1860, 1870, 1880, 1890, and 1900 censuses all had sections that broke down the minor civil divisions of the United States. It is these sections that I'm using to acquire most of the municipality data from. Due to the fact that these minor civil division sections are incredibly lengthy and encompassing all of the divisions of the United States including townships, it is a very time consuming process. Currently, going alphabetically according to states, I'm just about to finish aggregating data for 1880 and 1870 for New York state from the 1880 census (includes figures from the previous decennial census). I'm hoping that by the time I'm aggregating from the 1860 and older censuses things will progress faster since there were fewer municipalities in existence the further you go back. As a result of how time consuming collecting has been for this expansion I've been looking up ways to maximize how I use Google Spreadsheets. I've learned a few new tricks that will help me streamline my process. As I'm collecting figures, I'm not only aggregating for municipalities that had more than 1,000 inhabitants in 1900, but also those that had more than 1,000 inhabitants before 1900 but subsequently either lost population, were absorbed, or dissolved. It is due to this that the process is even more time consuming. Since the places in New England are quite exceptional in their administrative character relative to the rest of the areas that I study, I worked on finishing aggregating for all of them this week all the way back to the 1800 census. As I'm adding more and more municipalities from the older decennial censuses, I'm also adding their corresponding administrative data. I've also been trying to identify municipalities that were at one time before 1900 capitals themselves. I've also realized that many municipalities have changed names throughout history which is another thing that slows down my aggregation process. Due to this, I've refined my naming notation system to better reflect this. I now use the following around names to distinguish them from each other; pre-1900 names , (post 1900 names), and [by 1900 absorbed by this name]. I've also worked on reordering some of the columns in my data. I'm now putting the municipal designation column before the municipal name column. The beginning of a row now reads like this; 8 | City (of) | Boston | Suffolk | Massachusetts | .... I think the identification of what a place was referred to at a particular time will help people better understand what they are looking at. I also worked on aggregating municipality data for all of the Canadian municipalities in my data for every decennial census in the 1800's. Due to Canada only beginning to officially take censuses in 1871, the figures before that date are less accurate. I've mostly finished aggregating for the Canadian municipalities this week. A screenshot of the most populated municipalities in Canada in the year 1901 along with the preceding decennial figures during the nineteenth century is included in this post (it didn't load correctly so you can find it here: https://plus.google.com/105706178492556563330/posts/9woKeqbY2wU, if this link doesn't work, the image can be found on my G+: https://plus.google.com/+BillyWilson/posts ). Through all of this, none of this has been publicly released in an update yet. I'm waiting until I'm done. I might release an intermittent update though if I find that the process of aggregating is taking up too much time or if anyone would like to see an update. I did however update source #42 in my reference list to reflect what I've been working on. You can find that list here: http://www.thebillywilson.com/p/to-simplify-things-i-use-this-one.html You can find the main article that all of these updates will be released to here: http://www.thebillywilson.com/2012/12/the-population-of-every-city-in-canada.html As always, thank you SO much for your continued support! It means a great deal to me both mentally and financially!