The list of former members can be ordered by their age when they graduated or the duration that they were members of Nogizaka46.
Created page “Age At Graduation and Years in Group”
Created page for rappers Kitagawa Yuri and Hayashi Runa
The idol group Nogizaka46 has two members who can rap.
4th generation members Kitagawa Yuri and Hayashi Runa showed off their skills on several occasions. I created a page that shows the lyrics that they wrote.
Created page for height of members
Created page for height of members. Includes average heights for each generation and a graph.
Created page for members’ birth month
New page shows which members were born in each month.
Created page for movies with Nogizaka46 members in cast
To celebrate Iwamoto Renka’s actress debut in a movie and her first starring role, a new page for movie appearances by Nogizaka46 members was created.
Created page for “Nogizaka Star Tanjou”
Entered the data for the music show “Nogizaka Star Tanjou”, which is currently airing weekly.
You can see which member has participated in the most total songs or the most solo, duet and unit songs.
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.
Created new page for unit songs
Nogizaka46 songs performed by two to 10 members are defined as unit songs in this database, and a list of all unit songs has been created.
A graph shows which number of participants is the most popular among unit songs.
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.
New page “Blood type of members” created
I basically created this page because I wanted to use the “chart.js” javascript graph-creation script.
The is a pie chart and bar graph.