Created new page for generation songs

There were 17 generation songs when this page was created. The first is the 2nd generation’s “Kakigoori no kataomoi“, followed by the 3rd generation’s “Sanbanme no kaze“, which shows how few generation songs were released in the early days of Nogizaka46.

The 2nd gen has the fewest at 4, the 3rd gen has the most at 7, and the 4th gen has 5.

Against” is the sole generation song for the 1st gen. All songs were performed by 1st gen members until the 2nd gen joined, but of course those songs are not counted as 1st gen songs.

http://n46db.com/songs/gen-songs.php

Hori Miona graduates

2nd Generation member Hori Miona graduated from Nogizaka46 on March 28, 2021, at the online concert by 2nd Generation members as part of the 9th Year Birthday Live.

Hori was thrust into the center position for the 7th single back when 2nd Gen members were new and not yet full members. Through the 26th single, she was senbatsu 19 times and the 2 times that she did not make senbatsu she was the under center.

She sings a solo song “Tsumetai mizu no naka” as a coupling song for the 26th single.

Updated profile photos and heights of members

The profile photos on the official Nogizaka46 website were changed to the 26th single uniform, so the DB profile photos were also updated.

Furthermore, the heights of members on the official website were updated, so the DB was updated to reflect this.

New page: hometowns of members

Created a new page showing the hometowns of members and a ranking of prefectures.

Wrote a script that tabulates the hometowns of members in the database. I wanted to display the prefectures from north to south, so I downloaded “prefecture codes” used by the Japanese government and put them in a table. An INNER JOIN was used in the SQL query to combine the two tables, and ORDER BY based on the prefecture codes was used to display the results from north to south.

http://n46db.com/scripts/hometown-ranking.php