Base de données de siren/siret d'entreprises

Plus de 3,665,041 sirens d'entreprise disponibles à consulter

Les entreprises par les villes

Liste des villes avec le nombre d'entreprises enregistrées

WordPress database error: [Unknown column 'code_postal' in 'field list']
SELECT code_postal, name, count FROM ss565688_cities AS villes RIGHT JOIN ( SELECT code_postal, count FROM `ss565688_cache_ville_count` ORDER BY count DESC LIMIT 32 ) AS ville_count ON villes.zip_code = ville_count.code_postal ORDER BY count DESC

Les entreprises par départements

Liste des départements avec le nombre d'entreprises enregistrées

WordPress database error: [Unknown column 'code' in 'field list']
SELECT code, name, count FROM ss565688_cache_departement_count

WordPress database error: [Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=']
SELECT unite.siren AS siren, etab.siret, etab.date_creation AS date_creation, unite.tranche_effectifs AS tranche_effectifs, unite.annee_effectifs AS annee_effectifs, unite.date_dernier_traitement AS date_dernier_traitement, categorie_entreprise, unite.annee_categorie_entreprise AS annee_categorie_entreprise, unite.categorie_juridique AS categorie_juridique, activite_principale_title, categorie_juridique_title, longitude, latitude, unite.date_debut AS date_debut, unite.denomination AS denomination, numero_voie, type_voie, libelle_voie, code_postal, libelle_commune, prenom_1, nom, sexe, etab.updated_at as updated_at FROM (SELECT sirets.siret AS siret, siren, numero_voie, type_voie, libelle_voie, code_postal, libelle_commune, longitude, latitude, date_creation, activite_principale, updated_at FROM `ss565688_etablissements` AS etab INNER JOIN ( SELECT siret FROM `ss565688_etablissements` WHERE etablissement_siege = 1 AND statut_diffusion = 1 AND activite_principale LIKE '%10%' /*ORDER BY created_at_unix DESC*/ LIMIT 12 OFFSET 12 ) AS sirets ON etab.siret = sirets.siret ) AS etab LEFT JOIN ss565688_unites_legales AS unite ON etab.siren = unite.siren LEFT JOIN ss565688_categories_juridiques AS cj ON unite.categorie_juridique = cj.categorie_juridique LEFT JOIN ss565688_codes_naf AS cn ON etab.activite_principale = cn.naf_code WHERE unite.statut_diffusion = 1 /*ORDER BY date_creation DESC*/