|
1.
| 20081224 | the West Pacific | 2,754 | the faeyas | |
|
2.
| 20081218 | the West Pacific | 2,898 | the faeyas | |
|
3.
| 20081210 | the West Pacific | 2,989 | the faeyas | |
|
4.
| 20081129 | the West Pacific | 3,350 | the faeyas | |
|
5.
| 20081122 | the West Pacific | 3,474 | the faeyas | |
|
6.
| 20081116 | the West Pacific | 3,591 | the faeyas | |
|
7.
| 20081109 | the West Pacific | 3,690 | the faeyas | |
|
8.
| 20081101 | the West Pacific | 3,741 | the faeyas | |
|
9.
| 20081026 | the West Pacific | 3,857 | the faeyas | |
|
10.
| 20081020 | the West Pacific | 3,857 | the faeyas | |
|
11.
| 20081012 | the West Pacific | 3,811 | BIteland | |
|
12.
| 20081005 | the West Pacific | 3,802 | BIteland | |
|
13.
| 20080928 | the West Pacific | 3,809 | BIteland | |
|
14.
| 20080921 | the West Pacific | 3,933 | BIteland | |
|
15.
| 20080914 | the West Pacific | 4,001 | BIteland | |
|
16.
| 20080908 | the West Pacific | 4,056 | BIteland | |
|
17.
| 20080901 | the West Pacific | 4,092 | BIteland | |
|
18.
| 20080823 | the West Pacific | 3,984 | BIteland | |
|
19.
| 20080816 | the West Pacific | 3,783 | BIteland | |
|
20.
| 20080811 | the West Pacific | 3,590 | BIteland | |
|
21.
| 20080804 | the West Pacific | 3,355 | BIteland | |
|
22.
| 20080727 | the West Pacific | 3,277 | BIteland | |
|
23.
| 20080720 | the West Pacific | 3,361 | BIteland | |
|
24.
| 20080714 | the West Pacific | 3,396 | BIteland | |
|
25.
| 20080707 | the West Pacific | 3,437 | BIteland | |
|
26.
| 20080628 | the West Pacific | 3,502 | BIteland | |
|
27.
| 20080622 | the West Pacific | 3,619 | BIteland | |
|
28.
| 20080614 | the West Pacific | 3,689 | BIteland | |
|
29.
| 20080608 | the West Pacific | 3,742 | BIteland | |
|
30.
| 20080601 | the West Pacific | 3,823 | BIteland | |
|
31.
| 20080526 | the West Pacific | 3,802 | BIteland | |
|
32.
| 20080518 | the West Pacific | 3,835 | BIteland | |
|
33.
| 20080511 | the West Pacific | 3,929 | Wickedly evil people | |
|
34.
| 20080503 | the West Pacific | 3,865 | Wickedly evil people | |
|
35.
| 20080427 | the West Pacific | 3,873 | lots of ants | |
|
36.
| 20080420 | the West Pacific | 3,788 | lots of ants | |
|
37.
| 20080413 | the West Pacific | 3,711 | lots of ants | |
|
38.
| 20080405 | the West Pacific | 3,669 | lots of ants | |
|
39.
| 20080330 | the West Pacific | 3,645 | lots of ants | |
|
40.
| 20080322 | the West Pacific | 3,699 | lots of ants | |
|
41.
| 20080316 | the West Pacific | 3,740 | lots of ants | |
|
42.
| 20080310 | the West Pacific | 3,761 | taos un nation | |
|
43.
| 20080302 | the West Pacific | 3,800 | taos un nation | |
|
44.
| 20080224 | the West Pacific | 3,721 | taos un nation | |
|
45.
| 20080219 | the West Pacific | 3,736 | taos un nation | |
|
46.
| 20080210 | the West Pacific | 3,716 | taos un nation | |
|
47.
| 20080203 | the West Pacific | 3,577 | taos un nation | |
|
48.
| 20080126 | the West Pacific | 3,455 | taos un nation | |
|
49.
| 20080120 | the West Pacific | 3,401 | taos un nation | |
|
50.
| 20080109 | the West Pacific | 3,533 | taos un nation | |
| | | | | | |
|
50 records
|
|
The Nation database contains 52,316,272 records and the newest are dated Saturday, July 29, 2023
The Region database contains 15,446,689 records and the newest are dated Sunday, September 17, 2023
The WA/UN database contains 157 records and the newest are dated Tuesday, April 10, 2012
Currently tracking exactly 4,122,144 uniquely named Nations
Currently tracking exactly 438,322 uniquely named Regions
|
|
|
Overview
In May 2003, we started wondering about the world we lived in. We created a spider that would read the the pages of "The World". At
first it was just The Regions (http://www.nationstates.net/page=list_regions).
Then we added The Nations (http://www.nationstates.net/page=list_nations).
It simply collected all the data in the three columns displayed. The first couple simply gathered the names. With tweaking, the UN/WA status was captured as well. Due to a
fortuitous naming convention, the date was captured as well. We tried to run it once a week. This worked great for years. In late 2009, [violet] happened to be watching
the server when we did this and banned us. Fortunately, we were able to negotiate a return with the promise not to hammer the server quite so hard. Today, what used to take
an hour now takes 10+ hours.
We originally intended to do this in XML, until we took inventory of just how much data we had. We have over
19 million nation records and over 4 million
region records. Current counts are listed above. Needless to say, we needed a database to hold that much data.
This is still a work in progress although there is not much left to do. There are a couple more categories of data we have collected since we started on January 21, 2003. In
particular, we have UN/WA vote counts one every Resolution since then. That data was collected manually and we have not written a parser for that yet.
There is too much to manually enter it in a database, but we are working on getting it in.
This is a .NET 2.0 application and is written in ASP.NET using C# with a
Microsoft SQL Server database. It is best viewed with Internet Explorer.
|
Notes
1. The queries will only return a maximum of 100,000 20,000 records. If your query returns more than that, you will have to reformulate it. Trust us, you do not want any more than 100,000 20,000!
2. The counts and latest data dates are at the bottom of the page.
3. There is some missing nation data from August 2006 to March 2007. We do not know if we just lost the data over the years or whether NS changed the format and we did not compensate for it for many months.
|
4. We did not start collecting UN/WA data on nations until February, 2004.
5. The #1 Most Frequently Asked Question about NSHistory: Is it possible to find out
he region where the nation resided at that time? Answer: No (see the source of the
data linked in the Overview above) Sorry! We would love to have that data as well.
6. Things on To Do List:
|
7. Add the remaining WA records
8. Automate data collection (too much manual action involved now).
9. Start tracking what region nations are in when we collect data. ☺
|
10. Feel free to save off the images for use on your own websites. Do not hotlink to them for they
are purged on a sliding 24-hour scale.
11. Also, you can post links to your nation or region in the format:
http://nsdossier.texasregion.net/history.aspx?region=texas
or
http://nsdossier.texasregion.net/history.aspx?nation=newtexas
12. more to come...
|
13. We hope you enjoy the tool.
|
|
|