View Single Post
Old 03-29-2016, 05:04 PM   #4
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Posts: 12,018
Sure. See the attachment.

Note that it's a zipped openoffice calc file and the Canadian cities are very incomplete. The American cities, however, have the top 100 from almost every decade, with 2010 having far more, all from census.gov. I did find a couple errors in that site's own numbers (e.g. one decade they confused Youngstown, OH with Youngstown, PA, which I corrected) so if anyone finds anymore please let me know and I'll correct them. I'll probably be updating it in the future so if someone wants a copy months from now you might want to PM me for the latest one. Or if you have an idea for something I should add to it, let me know.

I find the best way to sort it is to select the entire "master" sheet, deselect the top 2 rows by pressing ctrl then selecting them (I often use 2 rows for headers), and then running a descending sort on the population column I'm interested in. I should add a macro to automate all that, but not today.
Attached Files
File Type: zip NA Population Censuses over the Decades v1.0.ods.zip (22 Bytes, 39 views)
kq76 is offline   Reply With Quote