Etat des lieux des équipements sportifs - Football

Name: Etat des lieux des équipements sportifs - Football
Creator: opendatasoft

APIQuery nowOpen workbench🇫🇷France

Website Docs

Etat des lieux des équipements sportifs dédiés au football.

⬇ Export CSV List records Select & filter API base URL Read the docs

Trust score

How is this computed?

poor

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	—
100%	communeCommune	text	—
100%	code_inseeINSEE commune code	text	—
64.7%	club_nomClub nom	text	—
71.4%	total_clubTotal club	double	—
1.8%	foot_entFoot ent	double	—
2.3%	foot_loisirFoot loisir	double	—
2.4%	futsal	double	—
70.5%	libre	double	—
0.1%	polePôle	double	—
3.4%	total_sssTotal sss	double	—
0%	c_arbitresC arbitres	double	—
0.4%	c_femC Fém.	double	—
0.2%	c_futsalC futsal	double	—
2.9%	c_garconsC Garçons	double	—
0%	c_agricoleC agricole	double	—
3.1%	total_cTotal c	double	—
0.1%	l_arbitresL arbitres	double	—
0.6%	l_femL Fém.	double	—
0.1%	l_futsalL futsal	double	—
1.3%	l_garconsL Garçons	double	—
0.4%	l_agricoleL agricole	double	—
1.5%	total_lTotal l	double	—
71.4%	total_licencesTotal licences	double	—
71.4%	l_moy_ageL Moy âge	double	—
71.4%	total_licenciesTotal Licenciés	double	—
71.4%	delta	double	—
71.4%	delta0Delta %	double	—
55.8%	arbitre	double	—
71.2%	dirigeant	double	—
41.6%	educateur	double	—
62.2%	foot_animFoot anim	double	—
60.1%	u12_u15U12 u15	double	—
65.8%	u16_u19U16 u19	double	—
69%	u20_seniorU20 senior	double	—
0.5%	pro	double	—
25.9%	foot_loisir0Foot Loisir	double	—
69.6%	veteranVétéran	double	—
4.4%	f_arbitreF arbitre	double	—
56.9%	f_dirigeantF dirigeant	double	—
7.7%	f_educateurF educateur	double	—
51.4%	f_foot_animF foot anim	double	—
31.2%	f_u12_u15F u12 u15	double	—
20%	f_u16_u19F u16 u19	double	—
14.2%	f_u20_seniorF u20 senior	double	—
0%	f_proF pro	double	—
1.1%	f_foot_loisirF foot loisir	double	—
0.1%	f_veteranF Vétéran	double	—
64.4%	f_totalF total	double	—
64.4%	f_moy_ageF Moy âge	double	—
55.5%	m_arbitreM arbitre	double	—
71.2%	m_dirigeantM dirigeant	double	—
41.6%	m_educateurM educateur	double	—
62%	m_foot_animM foot anim	double	—
59.7%	m_u12_u15M u12 u15	double	—
65.6%	m_u16_u19M u16 u19	double	—
68.9%	m_u20_seniorM u20 senior	double	—
0.5%	m_proM pro	double	—
25.8%	m_foot_loisirM foot loisir	double	—
69.6%	m_veteranM Vétéran	double	—
—	m_totalM total	double	—
—	m_moy_ageM Moy âge	double	—
—	total_equipTotal équip.	double	—
—	pnat_ech1Pnat ech1	double	—
—	pnat_ech2Pnat ech2	double	—
—	pnat_ech3Pnat ech3	double	—
—	pnat_ech4Pnat ech4	double	—
—	pnat_ech5Pnat ech5	double	—
—	sy_ech1Sy ech1	double	—
—	sy_ech2Sy ech2	double	—
—	sy_ech3Sy ech3	double	—
—	sy_ech4Sy ech4	double	—
—	sy_ech5Sy ech5	double	—
—	stab_ech5Stab ech5	double	—
—	reduit_pnatRéduit Pnat	double	—
—	reduit_stabRéduit Stab.	double	—
—	reduit_syRéduit Sy	double	—
—	futsal_ech1Futsal ech1	double	—
—	futsal_ech2Futsal ech2	double	—
—	futsal_ech3Futsal ech3	double	—
—	futsal_ech4Futsal ech4	double	—
—	futsal_ech5Futsal ech5	double	—
—	localisation	geo_point_2d	—

Schema captured from opendatasoft 1 hour 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 POULIGUEN",
  "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": 1,
  "pnat_ech4": null,
  "pnat_ech5": null,
  "reduit_sy": null,
  "stab_ech5": null,
  "total_sss": null,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "44135",
  "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": 1,
  "f_u20_senior": null,
  "foot_loisir0": null,
  "localisation": {
    "lat": 47.2716208982,
    "lon": -2.43210265977
  },
  "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": -17,
  "f_pro": null,
  "l_fem": null,
  "libre": 1,
  "m_pro": null,
  "delta0": -0.038202247191,
  "futsal": null,
  "arbitre": 3,
  "commune": "ST PHILBERT DE GRAND LIEU",
  "f_total": 22,
  "m_total": 423,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": 1,
  "sy_ech4": null,
  "sy_ech5": null,
  "total_c": null,
  "total_l": null,
  "u12_u15": 95,
  "u16_u19": 45,
  "veteran": 35,
  "c_futsal": null,
  "club_nom": "U.S. ST PHILBERT DE GRANDLIEU",
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": 54,
  "educateur": 7,
  "f_arbitre": null,
  "f_moy_age": 18.7727272727,
  "f_u12_u15": 6,
  "f_u16_u19": 7,
  "f_veteran": null,
  "foot_anim": 133,
  "l_garcons": null,
  "l_moy_age": 20.2539759295,
  "m_arbitre": 3,
  "m_moy_age": 21.7352245863,
  "m_u12_u15": 89,
  "m_u16_u19": 38,
  "m_veteran": 35,
  "pnat_ech1": null,
  "pnat_ech2": null,
  "pnat_ech3": 2,
  "pnat_ech4": null,
  "pnat_ech5": null,
  "reduit_sy": null,
  "stab_ech5": null,
  "total_sss": null,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "44188",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": 1,
  "u20_senior": 73,
  "departement": "Loire-Atlantique",
  "f_dirigeant": 4,
  "f_educateur": null,
  "f_foot_anim": 5,
  "foot_loisir": null,
  "futsal_ech1": null,
  "futsal_ech2": null,
  "futsal_ech3": null,
  "futsal_ech4": null,
  "futsal_ech5": null,
  "m_dirigeant": 50,
  "m_educateur": 7,
  "m_foot_anim": 128,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 3,
  "f_u20_senior": null,
  "foot_loisir0": null,
  "localisation": {
    "lat": 47.0602912538,
    "lon": -1.65711361304
  },
  "m_u20_senior": 73,
  "f_foot_loisir": null,
  "m_foot_loisir": null,
  "total_licences": 445,
  "total_licencies": 428
}

Record 3pro: — · pole: —

{
  "pro": null,
  "pole": null,
  "c_fem": null,
  "delta": -27,
  "f_pro": null,
  "l_fem": null,
  "libre": 1,
  "m_pro": null,
  "delta0": -0.0851735015773,
  "futsal": null,
  "arbitre": 2,
  "commune": "ST BARTHELEMY D ANJOU",
  "f_total": 34,
  "m_total": 283,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": 1,
  "sy_ech4": null,
  "sy_ech5": null,
  "total_c": null,
  "total_l": null,
  "u12_u15": 52,
  "u16_u19": 35,
  "veteran": 8,
  "c_futsal": null,
  "club_nom": "ST BARTHELEMY D'ANJOU FOOTBALL",
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": 33,
  "educateur": 5,
  "f_arbitre": null,
  "f_moy_age": 28.9117647059,
  "f_u12_u15": 1,
  "f_u16_u19": 5,
  "f_veteran": null,
  "foot_anim": 97,
  "l_garcons": null,
  "l_moy_age": 24.8799106215,
  "m_arbitre": 2,
  "m_moy_age": 20.8480565371,
  "m_u12_u15": 51,
  "m_u16_u19": 30,
  "m_veteran": 8,
  "pnat_ech1": null,
  "pnat_ech2": null,
  "pnat_ech3": 2,
  "pnat_ech4": 1,
  "pnat_ech5": 1,
  "reduit_sy": null,
  "stab_ech5": 2,
  "total_sss": null,
  "c_agricole": null,
  "c_arbitres": null,
  "code_insee": "49267",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": 1,
  "u20_senior": 61,
  "departement": "Maine-et-Loire",
  "f_dirigeant": 6,
  "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": 27,
  "m_educateur": 5,
  "m_foot_anim": 94,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 7,
  "f_u20_senior": 19,
  "foot_loisir0": 24,
  "localisation": {
    "lat": 47.4738114322,
    "lon": -0.485526012217
  },
  "m_u20_senior": 42,
  "f_foot_loisir": null,
  "m_foot_loisir": 24,
  "total_licences": 317,
  "total_licencies": 290
}

Record 4pro: — · pole: —

{
  "pro": null,
  "pole": null,
  "c_fem": null,
  "delta": -16,
  "f_pro": null,
  "l_fem": null,
  "libre": 1,
  "m_pro": null,
  "delta0": -0.0704845814978,
  "futsal": null,
  "arbitre": 1,
  "commune": "ST JEAN DE LINIERES",
  "f_total": 4,
  "m_total": 223,
  "sy_ech1": null,
  "sy_ech2": null,
  "sy_ech3": null,
  "sy_ech4": null,
  "sy_ech5": null,
  "total_c": null,
  "total_l": null,
  "u12_u15": 26,
  "u16_u19": 30,
  "veteran": 50,
  "c_futsal": null,
  "club_nom": "ST JEAN ST LAMBERT F.C.",
  "foot_ent": null,
  "l_futsal": null,
  "c_garcons": null,
  "dirigeant": 16,
  "educateur": 3,
  "f_arbitre": null,
  "f_moy_age": 19.5,
  "f_u12_u15": null,
  "f_u16_u19": null,
  "f_veteran": null,
  "foot_anim": 70,
  "l_garcons": null,
  "l_moy_age": 22.0347533632,
  "m_arbitre": 1,
  "m_moy_age": 24.5695067265,
  "m_u12_u15": 26,
  "m_u16_u19": 30,
  "m_veteran": 50,
  "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": "49289",
  "l_agricole": null,
  "l_arbitres": null,
  "total_club": 1,
  "u20_senior": 30,
  "departement": "Maine-et-Loire",
  "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": 15,
  "m_educateur": 3,
  "m_foot_anim": 67,
  "reduit_pnat": null,
  "reduit_stab": null,
  "total_equip": 1,
  "f_u20_senior": null,
  "foot_loisir0": 1,
  "localisation": {
    "lat": 47.4586878354,
    "lon": -0.674607472395
  },
  "m_u20_senior": 30,
  "f_foot_loisir": null,
  "m_foot_loisir": 1,
  "total_licences": 227,
  "total_licencies": 211
}

Record 5pro: — · 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": "ST LOUP DU DORAT",
  "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": "53233",
  "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": 47.8857485976,
    "lon": -0.423854225277
  },
  "m_u20_senior": null,
  "f_foot_loisir": null,
  "m_foot_loisir": null,
  "total_licences": null,
  "total_licencies": null
}

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

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 1 hour 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.