Inventory of Sports Facilities - FootballEtat des lieux des équipements sportifs - Football

Etat des lieux des équipements sportifs - FootballInventory of Sports Facilities - Football

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset provides an inventory of sports facilities dedicated to football in the Pays de la Loire region of France. It is published as part of the region's open data portal and is freely accessible without authentication. The data covers the regional territory and can be used to identify and assess the distribution and condition of football-related sports infrastructure across the area.Etat des lieux des équipements sportifs dédiés au football.

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (83 fields)

Filterable via the API (82)

departementcommunecode_inseeclub_nomtotal_clubfoot_entfoot_loisirfutsallibrepoletotal_sssc_arbitresc_femc_futsalc_garconsc_agricoletotal_cl_arbitresl_feml_futsall_garconsl_agricoletotal_ltotal_licencesl_moy_agetotal_licenciesdeltadelta0arbitredirigeanteducateurfoot_animu12_u15u16_u19u20_seniorprofoot_loisir0veteranf_arbitref_dirigeantf_educateurf_foot_animf_u12_u15f_u16_u19f_u20_seniorf_prof_foot_loisirf_veteranf_totalf_moy_agem_arbitrem_dirigeantm_educateurm_foot_animm_u12_u15m_u16_u19m_u20_seniorm_prom_foot_loisirm_veteranm_totalm_moy_agetotal_equippnat_ech1pnat_ech2pnat_ech3pnat_ech4pnat_ech5sy_ech1sy_ech2sy_ech3sy_ech4sy_ech5stab_ech5reduit_pnatreduit_stabreduit_syfutsal_ech1futsal_ech2futsal_ech3futsal_ech4futsal_ech5

Click a field to see example values.

Fill	Field	Type	Description
100%	departement	text	Name or code of the department.Name or code of the department.
100%	communeCommune	text	Name of the municipality.Name of the municipality.
100%	code_inseeINSEE commune code	text	INSEE code identifying the municipality.INSEE code identifying the municipality.
64.7%	club_nomClub nom	text	Name of the football club.Name of the football club.
71.4%	total_clubTotal club	double	Total number of football clubs.Total number of football clubs.
1.8%	foot_entFoot ent	double	Number of company (entreprise) football teams or players.Number of company (entreprise) football teams or players.
2.3%	foot_loisirFoot loisir	double	Number of leisure football participants.Number of leisure football participants.
2.4%	futsal	double	Number of futsal participants or teams.Number of futsal participants or teams.
70.5%	libre	double	Number of free/unaffiliated football practitioners.Number of free/unaffiliated football practitioners.
0.1%	polePôle	double	Number of training centres (pôles).Number of training centres (pôles).
3.4%	total_sssTotal sss	double	Total number of school sports sections related to football.Total number of school sports sections related to football.
0%	c_arbitresC arbitres	double	Number of certified (C) referees.Number of certified (C) referees.
0.4%	c_femC Fém.	double	Number of certified female participants.Number of certified female participants.
0.2%	c_futsalC futsal	double	Number of certified futsal participants.Number of certified futsal participants.
2.9%	c_garconsC Garçons	double	Number of certified male/boys participants.Number of certified male/boys participants.
0%	c_agricoleC agricole	double	Number of certified agricultural sector participants.Number of certified agricultural sector participants.
3.1%	total_cTotal c	double	Total number of certified participants.Total number of certified participants.
0.1%	l_arbitresL arbitres	double	Number of licensed referees.Number of licensed referees.
0.6%	l_femL Fém.	double	Number of licensed female participants.Number of licensed female participants.
0.1%	l_futsalL futsal	double	Number of licensed futsal participants.Number of licensed futsal participants.
1.3%	l_garconsL Garçons	double	Number of licensed male/boys participants.Number of licensed male/boys participants.
0.4%	l_agricoleL agricole	double	Number of licensed agricultural sector participants.Number of licensed agricultural sector participants.
1.5%	total_lTotal l	double	Total number of licensed participants.Total number of licensed participants.
71.4%	total_licencesTotal licences	double	Total number of football licences issued.Total number of football licences issued.
71.4%	l_moy_ageL Moy âge	double	Average age of licensed players.Average age of licensed players.
71.4%	total_licenciesTotal Licenciés	double	Total number of licensed club members.Total number of licensed club members.
71.4%	delta	double	Change in number of licensees compared to previous period.Change in number of licensees compared to previous period.
71.4%	delta0Delta %	double	Percentage change in number of licensees.Percentage change in number of licensees.
55.8%	arbitre	double	Number of registered referees.Number of registered referees.
71.2%	dirigeant	double	Number of registered club officials/leaders.Number of registered club officials/leaders.
41.6%	educateur	double	Number of registered coaches/educators.Number of registered coaches/educators.
62.2%	foot_animFoot anim	double	Number of players in youth introductory football programme.Number of players in youth introductory football programme.
60.1%	u12_u15U12 u15	double	Number of players aged 12 to 15.Number of players aged 12 to 15.
65.8%	u16_u19U16 u19	double	Number of players aged 16 to 19.Number of players aged 16 to 19.
69%	u20_seniorU20 senior	double	Number of players aged 20 and senior.Number of players aged 20 and senior.
0.5%	pro	double	Number of professional players.Number of professional players.
25.9%	foot_loisir0Foot Loisir	double	Number of leisure football participants.Number of leisure football participants.
69.6%	veteranVétéran	double	Number of veteran (senior) players.Number of veteran (senior) players.
4.4%	f_arbitreF arbitre	double	Number of female referees.Number of female referees.
56.9%	f_dirigeantF dirigeant	double	Number of female club officials/leaders.Number of female club officials/leaders.
7.7%	f_educateurF educateur	double	Number of female coaches/educators.Number of female coaches/educators.
51.4%	f_foot_animF foot anim	double	Number of female players in youth introductory football programme.Number of female players in youth introductory football programme.
31.2%	f_u12_u15F u12 u15	double	Number of female players aged 12 to 15.Number of female players aged 12 to 15.
20%	f_u16_u19F u16 u19	double	Number of female players aged 16 to 19.Number of female players aged 16 to 19.
14.2%	f_u20_seniorF u20 senior	double	Number of female players aged 20 and senior.Number of female players aged 20 and senior.
0%	f_proF pro	double	Number of female professional players.Number of female professional players.
1.1%	f_foot_loisirF foot loisir	double	Number of female leisure football participants.Number of female leisure football participants.
0.1%	f_veteranF Vétéran	double	Number of female veteran players.Number of female veteran players.
64.4%	f_totalF total	double	Total number of female licensees.Total number of female licensees.
64.4%	f_moy_ageF Moy âge	double	Average age of female licensees.Average age of female licensees.
55.5%	m_arbitreM arbitre	double	Number of male referees.Number of male referees.
71.2%	m_dirigeantM dirigeant	double	Number of male club officials/leaders.Number of male club officials/leaders.
41.6%	m_educateurM educateur	double	Number of male coaches/educators.Number of male coaches/educators.
62%	m_foot_animM foot anim	double	Number of male players in youth introductory football programme.Number of male players in youth introductory football programme.
59.7%	m_u12_u15M u12 u15	double	Number of male players aged 12 to 15.Number of male players aged 12 to 15.
65.6%	m_u16_u19M u16 u19	double	Number of male players aged 16 to 19.Number of male players aged 16 to 19.
68.9%	m_u20_seniorM u20 senior	double	Number of male players aged 20 and senior.Number of male players aged 20 and senior.
0.5%	m_proM pro	double	Number of male professional players.Number of male professional players.
25.8%	m_foot_loisirM foot loisir	double	Number of male leisure football participants.Number of male leisure football participants.
69.6%	m_veteranM Vétéran	double	Number of male veteran players.Number of male veteran players.
—	m_totalM total	double	Total number of male licensees.Total number of male licensees.
—	m_moy_ageM Moy âge	double	Average age of male licensees.Average age of male licensees.
—	total_equipTotal équip.	double	Total number of sports facilities/equipment.Total number of sports facilities/equipment.
—	pnat_ech1Pnat ech1	double	Number of facilities rated national plan level 1.Number of facilities rated national plan level 1.
—	pnat_ech2Pnat ech2	double	Number of facilities rated national plan level 2.Number of facilities rated national plan level 2.
—	pnat_ech3Pnat ech3	double	Number of facilities rated national plan level 3.Number of facilities rated national plan level 3.
—	pnat_ech4Pnat ech4	double	Number of facilities rated national plan level 4.Number of facilities rated national plan level 4.
—	pnat_ech5Pnat ech5	double	Number of facilities rated national plan level 5.Number of facilities rated national plan level 5.
—	sy_ech1Sy ech1	double	Number of synthetic turf pitches rated level 1.Number of synthetic turf pitches rated level 1.
—	sy_ech2Sy ech2	double	Number of synthetic turf pitches rated level 2.Number of synthetic turf pitches rated level 2.
—	sy_ech3Sy ech3	double	Number of synthetic turf pitches rated level 3.Number of synthetic turf pitches rated level 3.
—	sy_ech4Sy ech4	double	Number of synthetic turf pitches rated level 4.Number of synthetic turf pitches rated level 4.
—	sy_ech5Sy ech5	double	Number of synthetic turf pitches rated level 5.Number of synthetic turf pitches rated level 5.
—	stab_ech5Stab ech5	double	Number of stabilized (unpaved) pitches rated level 5.Number of stabilized (unpaved) pitches rated level 5.
—	reduit_pnatRéduit Pnat	double	Number of reduced-size pitches meeting national plan standard.Number of reduced-size pitches meeting national plan standard.
—	reduit_stabRéduit Stab.	double	Number of reduced-size stabilized pitches.Number of reduced-size stabilized pitches.
—	reduit_syRéduit Sy	double	Number of reduced-size synthetic turf pitches.Number of reduced-size synthetic turf pitches.
—	futsal_ech1Futsal ech1	double	Number of futsal facilities rated level 1.Number of futsal facilities rated level 1.
—	futsal_ech2Futsal ech2	double	Number of futsal facilities rated level 2.Number of futsal facilities rated level 2.
—	futsal_ech3Futsal ech3	double	Number of futsal facilities rated level 3.Number of futsal facilities rated level 3.
—	futsal_ech4Futsal ech4	double	Number of futsal facilities rated level 4.Number of futsal facilities rated level 4.
—	futsal_ech5Futsal ech5	double	Number of futsal facilities rated level 5.Number of futsal facilities rated level 5.
—	localisation	geo_point_2d	Geographic coordinates of the municipality or club.Geographic coordinates of the municipality or club.

Schema captured from opendatasoft 3 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1pro: — · pole: —

{
  "pro": null,
  "pole": null,
  "c_fem": null,
  "delta": null,
  "f_pro": null,
  "l_fem": null,
  "libre": null,
  "m_pro": null,
  "delta0": null,
  "futsal": null,
  "arbitre": null,
  "commune": "LE TEMPLE DE BRETAGNE",
  "f_total": null,
  "m_total": null,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": null,
  "sy_ech4": null,
  "sy_ech5": null,
  "total_c": null,
  "total_l": null,
  "u12_u15": null,
  "u16_u19": null,
  "veteran": null,
  "c_futsal": null,
  "club_nom": null,
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": null,
  "educateur": null,
  "f_arbitre": null,
  "f_moy_age": null,
  "f_u12_u15": null,
  "f_u16_u19": null,
  "f_veteran": null,
  "foot_anim": null,
  "l_garcons": null,
  "l_moy_age": null,
  "m_arbitre": null,
  "m_moy_age": null,
  "m_u12_u15": null,
  "m_u16_u19": null,
  "m_veteran": null,
  "pnat_ech1": null,
  "pnat_ech2": null,
  "pnat_ech3": null,
  "pnat_ech4": 1,
  "pnat_ech5": null,
  "reduit_sy": null,
  "stab_ech5": 1,
  "total_sss": null,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "44203",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": null,
  "u20_senior": null,
  "departement": "Loire-Atlantique",
  "f_dirigeant": null,
  "f_educateur": null,
  "f_foot_anim": null,
  "foot_loisir": null,
  "futsal_ech1": null,
  "futsal_ech2": null,
  "futsal_ech3": null,
  "futsal_ech4": null,
  "futsal_ech5": null,
  "m_dirigeant": null,
  "m_educateur": null,
  "m_foot_anim": null,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 2,
  "f_u20_senior": null,
  "foot_loisir0": null,
  "localisation": {
    "lat": 47.3284386017,
    "lon": -1.79041386059
  },
  "m_u20_senior": null,
  "f_foot_loisir": null,
  "m_foot_loisir": null,
  "total_licences": null,
  "total_licencies": null
}

Record 2pro: — · pole: —

{
  "pro": null,
  "pole": null,
  "c_fem": null,
  "delta": -1,
  "f_pro": null,
  "l_fem": null,
  "libre": 1,
  "m_pro": null,
  "delta0": -0.0133333333333,
  "futsal": null,
  "arbitre": 1,
  "commune": "MACHE",
  "f_total": 4,
  "m_total": 71,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": null,
  "sy_ech4": null,
  "sy_ech5": null,
  "total_c": null,
  "total_l": null,
  "u12_u15": null,
  "u16_u19": 3,
  "veteran": 8,
  "c_futsal": null,
  "club_nom": "ENT. SAINT PAUL MACHE",
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": 11,
  "educateur": null,
  "f_arbitre": null,
  "f_moy_age": 22.75,
  "f_u12_u15": null,
  "f_u16_u19": null,
  "f_veteran": null,
  "foot_anim": 40,
  "l_garcons": null,
  "l_moy_age": 22.5228873239,
  "m_arbitre": 1,
  "m_moy_age": 22.2957746479,
  "m_u12_u15": null,
  "m_u16_u19": 3,
  "m_veteran": 8,
  "pnat_ech1": null,
  "pnat_ech2": null,
  "pnat_ech3": 1,
  "pnat_ech4": null,
  "pnat_ech5": null,
  "reduit_sy": null,
  "stab_ech5": null,
  "total_sss": null,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "85130",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": 1,
  "u20_senior": 12,
  "departement": "Vendée",
  "f_dirigeant": 1,
  "f_educateur": null,
  "f_foot_anim": 3,
  "foot_loisir": null,
  "futsal_ech1": null,
  "futsal_ech2": null,
  "futsal_ech3": null,
  "futsal_ech4": null,
  "futsal_ech5": null,
  "m_dirigeant": 10,
  "m_educateur": null,
  "m_foot_anim": 37,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 1,
  "f_u20_senior": null,
  "foot_loisir0": null,
  "localisation": {
    "lat": 46.771364944,
    "lon": -1.69526445062
  },
  "m_u20_senior": 12,
  "f_foot_loisir": null,
  "m_foot_loisir": null,
  "total_licences": 75,
  "total_licencies": 74
}

Record 3pro: — · pole: —

{
  "pro": null,
  "pole": null,
  "c_fem": null,
  "delta": null,
  "f_pro": null,
  "l_fem": null,
  "libre": null,
  "m_pro": null,
  "delta0": null,
  "futsal": null,
  "arbitre": null,
  "commune": "PONTMAIN",
  "f_total": null,
  "m_total": null,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": null,
  "sy_ech4": null,
  "sy_ech5": null,
  "total_c": null,
  "total_l": null,
  "u12_u15": null,
  "u16_u19": null,
  "veteran": null,
  "c_futsal": null,
  "club_nom": null,
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": null,
  "educateur": null,
  "f_arbitre": null,
  "f_moy_age": null,
  "f_u12_u15": null,
  "f_u16_u19": null,
  "f_veteran": null,
  "foot_anim": null,
  "l_garcons": null,
  "l_moy_age": null,
  "m_arbitre": null,
  "m_moy_age": null,
  "m_u12_u15": null,
  "m_u16_u19": null,
  "m_veteran": null,
  "pnat_ech1": null,
  "pnat_ech2": null,
  "pnat_ech3": null,
  "pnat_ech4": 1,
  "pnat_ech5": null,
  "reduit_sy": null,
  "stab_ech5": null,
  "total_sss": null,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "53181",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": null,
  "u20_senior": null,
  "departement": "Mayenne",
  "f_dirigeant": null,
  "f_educateur": null,
  "f_foot_anim": null,
  "foot_loisir": null,
  "futsal_ech1": null,
  "futsal_ech2": null,
  "futsal_ech3": null,
  "futsal_ech4": null,
  "futsal_ech5": null,
  "m_dirigeant": null,
  "m_educateur": null,
  "m_foot_anim": null,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 1,
  "f_u20_senior": null,
  "foot_loisir0": null,
  "localisation": {
    "lat": 48.4336187982,
    "lon": -1.06521474954
  },
  "m_u20_senior": null,
  "f_foot_loisir": null,
  "m_foot_loisir": null,
  "total_licences": null,
  "total_licencies": null
}

Record 4pro: — · pole: —

{
  "pro": null,
  "pole": null,
  "c_fem": null,
  "delta": -4,
  "f_pro": null,
  "l_fem": null,
  "libre": 1,
  "m_pro": null,
  "delta0": -0.0289855072464,
  "futsal": null,
  "arbitre": 2,
  "commune": "MARSAC SUR DON",
  "f_total": 10,
  "m_total": 128,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": null,
  "sy_ech4": null,
  "sy_ech5": null,
  "total_c": null,
  "total_l": null,
  "u12_u15": 9,
  "u16_u19": 12,
  "veteran": 8,
  "c_futsal": null,
  "club_nom": "AV.S. MARSACAIS",
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": 16,
  "educateur": 2,
  "f_arbitre": 1,
  "f_moy_age": 18.7,
  "f_u12_u15": 2,
  "f_u16_u19": 2,
  "f_veteran": null,
  "foot_anim": 48,
  "l_garcons": null,
  "l_moy_age": 20.68203125,
  "m_arbitre": 1,
  "m_moy_age": 22.6640625,
  "m_u12_u15": 7,
  "m_u16_u19": 10,
  "m_veteran": 8,
  "pnat_ech1": null,
  "pnat_ech2": null,
  "pnat_ech3": 1,
  "pnat_ech4": null,
  "pnat_ech5": null,
  "reduit_sy": null,
  "stab_ech5": null,
  "total_sss": null,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "44091",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": 1,
  "u20_senior": 41,
  "departement": "Loire-Atlantique",
  "f_dirigeant": 1,
  "f_educateur": null,
  "f_foot_anim": 2,
  "foot_loisir": null,
  "futsal_ech1": null,
  "futsal_ech2": null,
  "futsal_ech3": null,
  "futsal_ech4": null,
  "futsal_ech5": null,
  "m_dirigeant": 15,
  "m_educateur": 2,
  "m_foot_anim": 46,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 1,
  "f_u20_senior": 2,
  "foot_loisir0": null,
  "localisation": {
    "lat": 47.5923270414,
    "lon": -1.69651775245
  },
  "m_u20_senior": 39,
  "f_foot_loisir": null,
  "m_foot_loisir": null,
  "total_licences": 138,
  "total_licencies": 134
}

Record 5pro: — · pole: —

{
  "pro": null,
  "pole": null,
  "c_fem": null,
  "delta": -53,
  "f_pro": null,
  "l_fem": null,
  "libre": 2,
  "m_pro": null,
  "delta0": -0.0445378151261,
  "futsal": null,
  "arbitre": 7,
  "commune": "REZE",
  "f_total": 196,
  "m_total": 994,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": 1,
  "sy_ech4": 1,
  "sy_ech5": null,
  "total_c": null,
  "total_l": 2,
  "u12_u15": 228,
  "u16_u19": 165,
  "veteran": 37,
  "c_futsal": null,
  "club_nom": null,
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": 133,
  "educateur": 27,
  "f_arbitre": null,
  "f_moy_age": 21.2040816327,
  "f_u12_u15": 49,
  "f_u16_u19": 29,
  "f_veteran": null,
  "foot_anim": 343,
  "l_garcons": 2,
  "l_moy_age": 21.2096866916,
  "m_arbitre": 7,
  "m_moy_age": 21.2152917505,
  "m_u12_u15": 179,
  "m_u16_u19": 136,
  "m_veteran": 37,
  "pnat_ech1": null,
  "pnat_ech2": 1,
  "pnat_ech3": 2,
  "pnat_ech4": null,
  "pnat_ech5": null,
  "reduit_sy": 1,
  "stab_ech5": 2,
  "total_sss": 2,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "44143",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": 3,
  "u20_senior": 185,
  "departement": "Loire-Atlantique",
  "f_dirigeant": 26,
  "f_educateur": null,
  "f_foot_anim": 33,
  "foot_loisir": 1,
  "futsal_ech1": null,
  "futsal_ech2": null,
  "futsal_ech3": null,
  "futsal_ech4": null,
  "futsal_ech5": null,
  "m_dirigeant": 107,
  "m_educateur": 27,
  "m_foot_anim": 310,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 8,
  "f_u20_senior": 59,
  "foot_loisir0": 65,
  "localisation": {
    "lat": 47.1762338904,
    "lon": -1.54966399893
  },
  "m_u20_senior": 126,
  "f_foot_loisir": null,
  "m_foot_loisir": 65,
  "total_licences": 1190,
  "total_licencies": 1137
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://data.paysdelaloire.fr/api/explore/v2.1/catalog/datasets/234400034-etat-des-lieux-des-equipements-sportifs-football

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.paysdelaloire.fr/api/explore/v2.1/catalog/datasets/234400034-etat-des-lieux-des-equipements-sportifs-football/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

5 000 req/day

per ipmeasured

observed 3 days ago

Dataset

Volume & freshness

Records

977

Last upstream update

6 years ago

2020-09-03

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.