STOCK_UNITE_LEGALE

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

Info

Property	Value
Source	SIRENE
Database	RESILIANS_SIRENE_DB
Schema	RAW_DBO
Layer	🟤 Raw
Type	BASE TABLE
Rows	29,331,094
Columns	37

Columns

#	Column	Type	Nullable	Default	Description
1	SIREN	TEXT	✅	—	—
2	STATUTDIFFUSIONUNITELEGALE	TEXT	✅	—	—
3	UNITEPURGEEUNITELEGALE	TEXT	✅	—	—
4	DATECREATIONUNITELEGALE	TEXT	✅	—	—
5	SIGLEUNITELEGALE	TEXT	✅	—	—
6	SEXEUNITELEGALE	TEXT	✅	—	—
7	PRENOM1UNITELEGALE	TEXT	✅	—	—
8	PRENOM2UNITELEGALE	TEXT	✅	—	—
9	PRENOM3UNITELEGALE	TEXT	✅	—	—
10	PRENOM4UNITELEGALE	TEXT	✅	—	—
11	PRENOMUSUELUNITELEGALE	TEXT	✅	—	—
12	PSEUDONYMEUNITELEGALE	TEXT	✅	—	—
13	IDENTIFIANTASSOCIATIONUNITELEGALE	TEXT	✅	—	—
14	TRANCHEEFFECTIFSUNITELEGALE	TEXT	✅	—	—
15	ANNEEEFFECTIFSUNITELEGALE	TEXT	✅	—	—
16	DATEDERNIERTRAITEMENTUNITELEGALE	TEXT	✅	—	—
17	NOMBREPERIODESUNITELEGALE	TEXT	✅	—	—
18	CATEGORIEENTREPRISE	TEXT	✅	—	—
19	ANNEECATEGORIEENTREPRISE	TEXT	✅	—	—
20	DATEDEBUT	TEXT	✅	—	—
21	ETATADMINISTRATIFUNITELEGALE	TEXT	✅	—	—
22	NOMUNITELEGALE	TEXT	✅	—	—
23	NOMUSAGEUNITELEGALE	TEXT	✅	—	—
24	DENOMINATIONUNITELEGALE	TEXT	✅	—	—
25	DENOMINATIONUSUELLE1UNITELEGALE	TEXT	✅	—	—
26	DENOMINATIONUSUELLE2UNITELEGALE	TEXT	✅	—	—
27	DENOMINATIONUSUELLE3UNITELEGALE	TEXT	✅	—	—
28	CATEGORIEJURIDIQUEUNITELEGALE	TEXT	✅	—	—
29	ACTIVITEPRINCIPALEUNITELEGALE	TEXT	✅	—	—
30	NOMENCLATUREACTIVITEPRINCIPALEUNITELEGALE	TEXT	✅	—	—
31	NICSIEGEUNITELEGALE	TEXT	✅	—	—
32	ECONOMIESSOCIALE	TEXT	✅	—	—
33	SOCIETEMISSIONUNITELEGALE	TEXT	✅	—	—
34	CARACTEREEMPLOYEURUNITELEGALE	TEXT	✅	—	—
35	ACTIVITEPRINCIPALENAF25UNITELEGALE	TEXT	✅	—	—
36	_LOADED_AT	TIMESTAMP_NTZ	✅	—	—
37	_SOURCE_FILE	TEXT	✅	—	—