Telecoms Package LawTracks Software

From La Quadrature du Net
Jump to navigationJump to search

Telecoms Package LawTracks: Implemented Software Framework

Pages on this wiki related to Telecoms Package LawTracks are based upon a Mysql database. Some Perl scripts are run to populate this database and to extract informations from this database in order to create wiki pages. Hence these wiki pages can be viewed as a frontend to this database. However there is no real time synchronizations between the database and the wiki pages. Updates of the database from the wiki are frequently made in a semi-automatic way.

Download and license

A dump of the database, and Perl scripts can be downloaded freely, as well as sources of the PHP navigation form and templates for including other languages into the database.

All scripts are licensed under GNU General Public License version 3 or higher.

Description of the database

Tables

  • tp_text
  • tp_diff_texts
  • tp_three_texts
  • tp_versions
  • tp_lang
  • tp_origin
  • tp_amending
  • tp_amended
  • tp_translations

Identifiers for chunks of text

Static tables

tp_versions
id lang origin description date url1 url2 url3 url4 url5
a en Parliament & Council Original Directives 2002-03-07 http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=CELEX:32002L0019:EN:NOT http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=CELEX:32002L0020:EN:NOT http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=CELEX:32002L0021:EN:NOT http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=CELEX:32002L0022:EN:NOT http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=CELEX:32002L0058:EN:NOT
b en Commission Initial Proposal 2007-11-13 http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=COM:2007:0697:FIN:EN:HTML http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=COM:2007:0698:FIN:EN:HTML NULL NULL NULL
c en JURI Opinion 2008-05-29 http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/730/730352/730352en.pdf http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/726/726164/726164en.pdf NULL NULL NULL
d en CULT Opinion 2008-06-02 http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/727/727274/727274en.pdf http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/727/727281/727281en.pdf NULL NULL NULL
e en ECON Opinion 2008-06-03 http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/725/725956/725956en.pdf http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/725/725954/725954en.pdf NULL NULL NULL
f en LIBE Opinion 2008-05-29 http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/724/724548/724548en.pdf http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/730/730933/730933en.pdf NULL NULL NULL
g en ITRE Report & Opinion 2008-07-07 http://www.europarl.europa.eu/document/activities/cont/200807/20080728ATT35127/20080728ATT35127EN.pdf http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/726/726618/726618en.pdf NULL NULL NULL
h en IMCO Opinion & Report 2008-07-07 http://www.europarl.europa.eu/meetdocs/2004_2009/documents/ad/731/731298/731298en.pdf http://www.europarl.europa.eu/document/activities/cont/200807/20080718ATT35014/20080718ATT35014EN.pdf NULL NULL NULL
i en Parliament First Reading 2008-09-24 http://www.europarl.europa.eu/sides/getDoc.do?type=TA&language=EN&reference=P6-TA-2008-0449 http://www.europarl.europa.eu/sides/getDoc.do?type=TA&language=EN&reference=P6-TA-2008-0452 NULL NULL NULL
j en Commission Amended Proposal 2008-11-06 http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=COM:2008:0724:FIN:EN:PDF http://register.consilium.europa.eu/pdf/en/08/st15/st15422.en08.pdf NULL NULL NULL
k en Council Political Agreement 2008-11-27 http://register.consilium.europa.eu/pdf/en/08/st17/st17006.en08.pdf http://register.consilium.europa.eu/pdf/en/08/st17/st17007.en08.pdf http://register.consilium.europa.eu/pdf/en/08/st17/st17009.en08.pdf http://register.consilium.europa.eu/pdf/en/08/st17/st17011.en08.pdf http://register.consilium.europa.eu/pdf/en/08/st17/st17014.en08.pdf
l en Council Common Position 2009-02-09 http://register.consilium.europa.eu/pdf/en/08/st16/st16496.en08.pdf http://register.consilium.europa.eu/pdf/en/08/st16/st16497.en08.pdf NULL NULL NULL
tp_lang
id name
en English
fr Français
de Deutsch
es Español
tp_origin
short_name lang name
Commission en European Commission
Parliament en European Parliament
Council en Council of European Union
JURI en Committee on Legal Affairs
CULT en Committee on Culture and Education
ECON en European Parliament Committee on Economic and Monetary Affairs
LIBE en Committee on Civil Liberties, Justice and Home Affairs
ITRE en Committee on Industry, Research and Energy
IMCO en Committee on the Internal Market and Consumer Protection
tp_amending
id lang number title
0 en NULL NULL
1 en COD/2007/0247 Proposal for a Directive of the European Parliament and of the Council amending Directives 2002/21/EC on a common regulatory framework for electronic communications networks and services, 2002/19/EC on access to, and interconnection of, electronic communications networks and services, and 2002/20/EC on the authorisation of electronic communications networks and services
2 en COD/2007/0248 Proposal for a Directive of the European Parliament and of the Council amending Directive 2002/22/EC on universal service and users' rights relating to electronic communications networks, Directive 2002/58/EC concerning the processing of personal data and the protection of privacy in the electronic communications sector and Regulation (EC) No 2006/2004 on consumer protection cooperation
tp_amended
id lang number title short_name
0 en NULL NULL NULL
1 en 2002/19/EC Directive on access to, and interconnection of, electronic communications networks and associated facilities Access
2 en 2002/20/EC Directive on the authorisation of electronic communications networks and services Authorisation
3 en 2002/21/EC Directive on a common regulatory framework for electronic communications networks and services Framework
4 en 2002/22/EC Directive on universal service and users' rights relating to electronic communications networks and services Universal Service
5 en 2002/58/EC Directive concerning the processing of personal data and the protection of privacy in the electronic communications sector ePrivacy
tp_translations
id lang translation
Title fr Titre
Recital fr Considérant
Article fr Article
Annex fr Annexe
Telecoms Package fr Paquet télécom
Evolution fr Évolution
Comparison fr Comparaison

How to add a translation