2021 GT4 database (US)
11-08-2020, 09:38 PM
#1
Pro
Thread Starter
2021 GT4 database (US)
I started this as a purely selfish thing trying to determine how many people were ordering Python Green cars, but decided it might have value to others as well.
I have started a database of all 2021 GT4s for the US market. The information was pulled from VIN Analytics, and then added to the database. I'm also printing out the specs for each car to keep separately. Please note that this is only for GT4s for the US market. If anyone is interested in doing something similar for Spyders, or cars for other markets, I'd be happy to help get you started.
Currently the database has VIN number, color, transmission, seats, production date, and working on inputting wheel color. It then breaks out the number of each of these options in separate tabs and the percentage of US production of each option shown above.
I have hopefully set this up as a "View Only" spreadsheet in Google Sheets, and will add new cars as they show up on VIN Analytics.
A couple of notes, first of all VIN Analytics shows what "sequence number" each car is in the total US production, but what I've found is that this number is changing as additional VINs show up. For example, my car was #65 of 83, and is now #67 of 87. Secondly, the VIN order isn't a direct correlation to build order. So there are cars with a lower VIN that were actually built after cars with a higher VIN.
Also of interest, there are VIN numbers that are identical with the exception of the digit that shows which factory it was built in. For example, VIN WP0AC2A87MS289075 was built in Zuffenhausen (the S signifies this) while VIN WP0AC2A87MK289075 was built in Osnabruck (the K signifies this.)
https://docs.google.com/spreadsheets...it?usp=sharing
Anyway, hopefully some others find this useful. Since this is quite monotonous to add in additional options, I definitely won't be adding in everything, but if there is a big enough interest for something in particular, I may be willing to add that in.
If anyone finds a discrepancy in the database, please direct message me so we can figure out where the issue is. I’m human, so I make mistakes occasionally. Also, please verify the VIN is 100% correct. As noted above, GT4s are being built in two factories, and have the exact same VIN except for “S” vs. “K” 7 digits from the end. This can be confusing and easy to overlook.
Enjoy,
Ron
I have started a database of all 2021 GT4s for the US market. The information was pulled from VIN Analytics, and then added to the database. I'm also printing out the specs for each car to keep separately. Please note that this is only for GT4s for the US market. If anyone is interested in doing something similar for Spyders, or cars for other markets, I'd be happy to help get you started.
Currently the database has VIN number, color, transmission, seats, production date, and working on inputting wheel color. It then breaks out the number of each of these options in separate tabs and the percentage of US production of each option shown above.
I have hopefully set this up as a "View Only" spreadsheet in Google Sheets, and will add new cars as they show up on VIN Analytics.
A couple of notes, first of all VIN Analytics shows what "sequence number" each car is in the total US production, but what I've found is that this number is changing as additional VINs show up. For example, my car was #65 of 83, and is now #67 of 87. Secondly, the VIN order isn't a direct correlation to build order. So there are cars with a lower VIN that were actually built after cars with a higher VIN.
Also of interest, there are VIN numbers that are identical with the exception of the digit that shows which factory it was built in. For example, VIN WP0AC2A87MS289075 was built in Zuffenhausen (the S signifies this) while VIN WP0AC2A87MK289075 was built in Osnabruck (the K signifies this.)
https://docs.google.com/spreadsheets...it?usp=sharing
Anyway, hopefully some others find this useful. Since this is quite monotonous to add in additional options, I definitely won't be adding in everything, but if there is a big enough interest for something in particular, I may be willing to add that in.
If anyone finds a discrepancy in the database, please direct message me so we can figure out where the issue is. I’m human, so I make mistakes occasionally. Also, please verify the VIN is 100% correct. As noted above, GT4s are being built in two factories, and have the exact same VIN except for “S” vs. “K” 7 digits from the end. This can be confusing and easy to overlook.
Enjoy,
Ron
Last edited by ronbauer; 11-09-2020 at 02:31 PM. Reason: Add info to contact me if a discrepancy is found.
11-08-2020, 10:02 PM
#2
Rennlist Member
I started this as a purely selfish thing trying to determine how many people were ordering Python Green cars, but decided it might have value to others as well.
I have started a database of all 2021 GT4s for the US market. The information was pulled from VIN Analytics, and then added to the database. I'm also printing out the specs for each car to keep separately. Please note that this is only for GT4s for the US market. If anyone is interested in doing something similar for Spyders, or cars for other markets, I'd be happy to help get you started.
Currently the database has VIN number, color, transmission, seats, production date, and working on inputting wheel color. It then breaks out the number of each of these options in separate tabs and the percentage of US production of each option shown above.
I have hopefully set this up as a "View Only" spreadsheet in Google Sheets, and will add new cars as they show up on VIN Analytics.
A couple of notes, first of all VIN Analytics shows what "sequence number" each car is in the total US production, but what I've found is that this number is changing as additional VINs show up. For example, my car was #65 of 83, and is now #67 of 87. Secondly, the VIN order isn't a direct correlation to build order. So there are cars with a lower VIN that were actually built after cars with a higher VIN.
Also of interest, there are VIN numbers that are identical with the exception of the digit that shows which factory it was built in. For example, VIN WP0AC2A87MS289075 was built in Zuffenhausen (the S signifies this) while VIN WP0AC2A87MK289075 was built in Osnabruck (the K signifies this.)
https://docs.google.com/spreadsheets...it?usp=sharing
Anyway, hopefully some others find this useful. Since this is quite monotonous to add in additional options, I definitely won't be adding in everything, but if there is a big enough interest for something in particular, I may be willing to add that in.
Enjoy,
Ron
I have started a database of all 2021 GT4s for the US market. The information was pulled from VIN Analytics, and then added to the database. I'm also printing out the specs for each car to keep separately. Please note that this is only for GT4s for the US market. If anyone is interested in doing something similar for Spyders, or cars for other markets, I'd be happy to help get you started.
Currently the database has VIN number, color, transmission, seats, production date, and working on inputting wheel color. It then breaks out the number of each of these options in separate tabs and the percentage of US production of each option shown above.
I have hopefully set this up as a "View Only" spreadsheet in Google Sheets, and will add new cars as they show up on VIN Analytics.
A couple of notes, first of all VIN Analytics shows what "sequence number" each car is in the total US production, but what I've found is that this number is changing as additional VINs show up. For example, my car was #65 of 83, and is now #67 of 87. Secondly, the VIN order isn't a direct correlation to build order. So there are cars with a lower VIN that were actually built after cars with a higher VIN.
Also of interest, there are VIN numbers that are identical with the exception of the digit that shows which factory it was built in. For example, VIN WP0AC2A87MS289075 was built in Zuffenhausen (the S signifies this) while VIN WP0AC2A87MK289075 was built in Osnabruck (the K signifies this.)
https://docs.google.com/spreadsheets...it?usp=sharing
Anyway, hopefully some others find this useful. Since this is quite monotonous to add in additional options, I definitely won't be adding in everything, but if there is a big enough interest for something in particular, I may be willing to add that in.
Enjoy,
Ron
interested to see the carbon gray one.
The following users liked this post:
ronbauer (11-09-2020)
11-08-2020, 10:58 PM
#4
Rennlist Member
Thank you for your hard work Ron!
11-08-2020, 11:09 PM
#5
Burning Brakes
Where the Spyder database?
11-08-2020, 11:55 PM
#6
Pro
Thread Starter
11-09-2020, 12:01 AM
#7
Pro
Thread Starter
The following users liked this post:
911therapy (11-09-2020)
Trending Topics
The following users liked this post:
ronbauer (11-09-2020)
11-09-2020, 12:32 AM
#10
Pro
Thread Starter
Ron
The following users liked this post:
ronbauer (11-09-2020)
11-09-2020, 12:44 AM
#13
RL Community Team
Rennlist Member
Rennlist Member
This needs to be a stickie.
11-09-2020, 01:43 AM
#14
This one didn’t get stickied - https://rennlist.com/forums/987-981-...-database.html
Last edited by Merlotsj; 11-09-2020 at 01:44 AM. Reason: Spelling error (auto correct)
11-09-2020, 03:18 AM
#15
Nordschleife Master
