Site
Home / Forum / General Discussion / [REQUESTS] New leagues

[REQUESTS] New leagues


Posted: 17 Jan 2023 19:32
curswine
Posts: 868
Joined: 2020-06-17

I made a start on how I'd need the data to look to add to the DB.

https://docs.google.com/spreadsheets/d/1xKJyN9gXWSdvjdBIyl0v_ROyqV9j3Mo9vr8F7_zTbU8/edit?usp=sharing (I've enabled viewing without needing access this time lol)

Some timezones might be off as I've just tied each state to a single tz, but I know its not that simple.

Also there's not much that can be done with the games that don't have start times. They can be found at the bottom of the spreadsheet.

Before all of that there's small the task of adding 582 teams and logos to the DB.

sportsbot5000, zag
Posted: 18 Jan 2023 14:23

zag
Posts: 3,327
Joined: 2020-03-23

Its a huge task, i'm not really sure if its worth supporting without an API link...

NCAA mens was a massive undertaking at the time.

Posted: 19 Jan 2023 09:20
sportsbot5000
Posts: 5
Joined: 2020-08-04

Understood, thanks all for your help! If this doesn't pass the test for TheSportsDB, it's no problem at all, no worries. But I've had some fun improving things for v2:

https://docs.google.com/spreadsheets/d/1eYvUXq50M_jyqICipHtp4y1NDLUaqU7MTX2InpWYBwI/edit?usp=sharing

It doesn't have quite everything you need just yet, but I added:

- urls for team logos, 500x500
- utc event start times, for all future games
- appended " Women" to all team names
- separated city, state, and venue columns

I can probably get more venue/location/timezone information with some basic geolocation code and some better code organization. I haven't implemented properly associated scores yet either, but can probably do that in time as well if necessary.

Let me know your thoughts on next steps etc if you're up for it! It might help me to learn a little more about how the data can be maintained and updated etc as well. If you're interested in chatting more deeply, drop me a line at [email protected], but no pressure. Thanks and talk to you soon!

Adam

zag
Posted: 19 Jan 2023 15:05
curswine
Posts: 868
Joined: 2020-06-17

Understood, thanks all for your help! If this doesn't pass the test for TheSportsDB, it's no problem at all, no worries. But I've had some fun improving things for v2:

https://docs.google.com/spreadsheets/d/1eYvUXq50M_jyqICipHtp4y1NDLUaqU7MTX2InpWYBwI/edit?usp=sharing

It doesn't have quite everything you need just yet, but I added:

- urls for team logos, 500x500
- utc event start times, for all future games
- appended " Women" to all team names
- separated city, state, and venue columns

I can probably get more venue/location/timezone information with some basic geolocation code and some better code organization. I haven't implemented properly associated scores yet either, but can probably do that in time as well if necessary.

Let me know your thoughts on next steps etc if you're up for it! It might help me to learn a little more about how the data can be maintained and updated etc as well. If you're interested in chatting more deeply, drop me a line at [email protected], but no pressure. Thanks and talk to you soon!

Adam


I've had a look through the latest spreadsheet, good work getting all the logo urls, can find and replace on the URLs to make then 512x512 (which is the dimensions we use here). There are still 216 teams without logos, which goes to show how big of an operation this is.

If home games are always played at the same location then an index and match could be employed to fill in the gaps, and then manually correct any outlying events played at different venues.

I do have a script for bulk adding teams, but I'd really like to get some more details first. I've made a start on the spreadsheet format which I use to add teams here: https://docs.google.com/spreadsheets/d/1Ou3dmGqoXRhvUUrC8NHdw5P2PqolwG27__SOGwkclvY/edit?usp=sharing I'd really like it to be as complete as possible with websites/social media links and Wikipedia descriptions.

Posted: 21 Jan 2023 11:28

Ovokx
Posts: 1,698
Joined: 2020-06-17

Some leagues to be added to watersports, please:

Watersports / World Swimming Championships SC / Division 1
Watersports / European Swimming Championships / Division 2
Watersports / European Swimming Championships SC / Division 2

Some leagues to be added related to Commonwealth Games in order to complete all available sports on the DB, please:

Watersports / Commonwealth Games Swimming / Division 1
Watersports / Commonwealth Games Diving / Division 1
Badminton / Commonwealth Games Badminton / Division 1
Basketball / Commonwealth Games 3x3 Basketball / Cup Competition
Volleyball / Commonwealth Games Beach Volleyball / Cup Competition
Fighting / Commonwealth Games Boxing / Cup Competition
Cricket / Commonwealth Games Cricket / Cup Competition
Cycling / Commonwealth Games Mountain Bike / Cup Competition
Cycling / Commonwealth Games Road Cycling / Cup Competition
Cycling / Commonwealth Games Track Cycling / Cup Competition
Gymnastics / Commonwealth Games Artistic Gymnastics / Division 1
Gymnastics / Commonwealth Games Rhythmic Gymnastics / Division 1
Field Hockey / Commonwealth Games Field Hockey / Cup Competition
Fighting / Commonwealth Games Judo / Cup Competition
Netball / Commonwealth Games Netball / Cup Competition
Rugby / Commonwealth Games 7s Rugby / Cup Competition
Table Tennis / Commonwealth Games Table Tennis / Division 1
Multi-Sports / Commonwealth Games Triathlon / Division 1
Weightlifting / Commonwealth Games Weightlifting / Division 1
Fighting / Commonwealth Games Wrestling / Cup Competition


zag
Posted: 29 Jan 2023 11:27

Ovokx
Posts: 1,698
Joined: 2020-06-17

Please add "_Defunct Watersports Teams" to Watersports

zag
Posted: 25 Feb 2023 08:09

Ovokx
Posts: 1,698
Joined: 2020-06-17

Please add:

Ice Hockey / International Friendlies Ice Hockey / Cup Competition
(API ID 150)

zag
Posted: 26 Feb 2023 16:14
Franz
Posts: 11
Joined: 2022-06-18

Is it possible to add the Italian Serie A2 basketball league?

zag
Posted: 27 Feb 2023 19:31

Ovokx
Posts: 1,698
Joined: 2020-06-17

Is it possible to add the Italian Serie A2 basketball league?

@zag, here you can see the info to add it:

Basketball / Division 2 / Italian Serie A2
(API ID 242)
https://en.wikipedia.org/wiki/Serie_A2_(basketball)




Franz, zag
Posted: 28 Feb 2023 11:24

zag
Posts: 3,327
Joined: 2020-03-23

All added thanks, please update artwork and any content/players you have.

Franz
Posted: 19 Mar 2023 22:11
Shadess
Posts: 1
Joined: 2023-03-19

Add if possible.

Fighting / KOK
https://en.wikipedia.org/wiki/King_of_Kings_(kickboxing)

zag
Posted: 26 Apr 2023 22:57
keniiis
Posts: 3
Joined: 2023-04-24

With ignorance, I edited this https://www.thesportsdb.com/league/4367 thousand apologies, and I inserted a logo that did not correspond

to soccer:
-Chile Cup
-America bicentenary Cup, which differs from the traditional one.

Tennis:

-Federation Chile, given that this year it belongs to the Davis Cup world group, besides having a rich tradition in this sport, among which stands out a world number 1, a double gold medalist, among other feats.

Posted: 27 Apr 2023 08:55
curswine
Posts: 868
Joined: 2020-06-17

@zag This is the ID for Copa Chile https://thesportsdb.com/sync_apifootball_leagues2.php?id=5105

I've never heard of the other competition you're talking about. Please can you post a link to a website with more information about it, please?

Also, are you looking for the Chilean National Tennis team to be added to the Davis Cup section?

Posted: 27 Apr 2023 12:36

zag
Posts: 3,327
Joined: 2020-03-23

With ignorance, I edited this https://www.thesportsdb.com/league/4367 thousand apologies, and I inserted a logo that did not correspond

to soccer:
-Chile Cup
-America bicentenary Cup, which differs from the traditional one.

Tennis:

-Federation Chile, given that this year it belongs to the Davis Cup world group, besides having a rich tradition in this sport, among which stands out a world number 1, a double gold medalist, among other feats.


Sure always happy to help out new users who contribute:
https://www.thesportsdb.com/league/5378

Please fill out any artwork and descriptions.
Events should auto populate over time. But some teams are missing so will need to be added.

also
https://www.thesportsdb.com/team/147357-Chile-Tennis

Posted: 27 Apr 2023 12:40

zag
Posts: 3,327
Joined: 2020-03-23

Add if possible.

Fighting / KOK
https://en.wikipedia.org/wiki/King_of_Kings_(kickboxing)


Added here: https://www.thesportsdb.com/league/5379-KOK
As always please fill out the artwork and any events.

Posted: 11 May 2023 15:05
minerva
Posts: 1
Joined: 2023-05-11

I hope this is the right place to ask -- would it be possible to add the new, "F1 Academy?"

https://en.wikipedia.org/wiki/F1_Academy

https://www.skysports.com/f1/news/12433/12862689/f1-academy-all-you-need-to-know-ahead-of-all-female-series-inaugural-season

Posted: 15 May 2023 07:36
curswine
Posts: 868
Joined: 2020-06-17

I hope this is the right place to ask -- would it be possible to add the new, "F1 Academy?"

https://en.wikipedia.org/wiki/F1_Academy

https://www.skysports.com/f1/news/12433/12862689/f1-academy-all-you-need-to-know-ahead-of-all-female-series-inaugural-season


Try applying to be an editor and making some edits first before requesting entire new leagues.

We have too many people requesting and dipping out without contributing anything.

zag
Posted: 27 May 2023 18:16

Ovokx
Posts: 1,698
Joined: 2020-06-17

New leagues to be added, please:

Basketball / Cup Competition / Coupe de France de Basket
API ID: 9

Basketball / Cup Competition / LNB Pro A Leaders Cup
API ID: 11

zag
Posted: 05 Jun 2023 10:27

zag
Posts: 3,327
Joined: 2020-03-23

New leagues to be added, please:

Basketball / Cup Competition / Coupe de France de Basket
API ID: 9

Basketball / Cup Competition / LNB Pro A Leaders Cup
API ID: 11


Done

https://www.thesportsdb.com/league/5380-Coupe-de-France-de-Basket
https://www.thesportsdb.com/league/5381-LNB-Pro-A-Leaders-Cup

Posted: 05 Jun 2023 10:30

zag
Posts: 3,327
Joined: 2020-03-23

I hope this is the right place to ask -- would it be possible to add the new, "F1 Academy?"

https://en.wikipedia.org/wiki/F1_Academy

https://www.skysports.com/f1/news/12433/12862689/f1-academy-all-you-need-to-know-ahead-of-all-female-series-inaugural-season


done

https://www.thesportsdb.com/league/5382-F1-Academy

Posted: 23 Jun 2023 08:29

Ovokx
Posts: 1,698
Joined: 2020-06-17

Basketball / Cup Competition / Olympics Basketball Women
API ID: 193

Soccer / Cup Competition / Olympics Soccer Women
API ID: 524

Once created, please, can you move the next events into soccer women, please?

1330433
1330434
1330435
1330436
1330437
1330438
1330949
1330950
1330951
1330952
1330953
1347137
1347096
1347097
1347098
1347099
1347100
1347101
1347650
1347651
1347652
1347653
1362205
1362206


zag
Posted: 28 Jun 2023 14:15
curswine
Posts: 868
Joined: 2020-06-17

All teams are available for these leagues in the DB.

Montenegrin Second League - Soccer - League - Tier 2 - API ID: 5306
Slovenian 2. SNL - Soccer - League - Tier 2 - API ID: 5304

zag
Posted: 30 Jun 2023 21:13

Ovokx
Posts: 1,698
Joined: 2020-06-17

Basketball / Cup Competition / FIBA Womens Asia Cup
API ID: 310

zag
Posted: 02 Jul 2023 14:03

Ovokx
Posts: 1,698
Joined: 2020-06-17

Watersports / Division 1 / World Open Water Swimming Championships
https://en.wikipedia.org/wiki/FINA_World_Aquatics_Championships

Watersports / Division 1 / World Artistic Swimming Championships
https://en.wikipedia.org/wiki/FINA_World_Aquatics_Championships

Watersports / Division 1 / World Diving Championships
https://en.wikipedia.org/wiki/FINA_World_Aquatics_Championships

Watersports / Division 1 / World High Diving Championships
https://en.wikipedia.org/wiki/FINA_World_Aquatics_Championships

Watersports / Division 1 / World Water Polo Championships
https://en.wikipedia.org/wiki/FINA_World_Aquatics_Championships

Watersports / Division 1 / Water Polo World Cup
https://en.wikipedia.org/wiki/FINA_Water_Polo_World_Cup

Watersports / Division 1 / Water Polo World Cup Women
https://en.wikipedia.org/wiki/FINA_Women%27s_Water_Polo_World_Cup

Posted: 04 Jul 2023 10:24
curswine
Posts: 868
Joined: 2020-06-17

All teams present:-

Denmark Series - Group 1 - Soccer - Tier 4 - League - API ID: 5335
Denmark Series - Group 2 - Soccer - Tier 4 - League - API ID: 5336
Denmark Series - Group 3 - Soccer - Tier 4 - League - API ID: 5337
Denmark Series - Group 4 - Soccer - Tier 4 - League - API ID: 5338


Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm

About Us

Discussion forum for TheSportsDB.com site and related topics

Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 450 to 475 (Total: 522)