# Cellar Extractor
A Python library for extracting CELLAR case law data from EUR-Lex.
This library contains functions to get CELLAR case law data from the EUR-Lex SPARQL endpoint and scrape additional information from EUR-Lex websites.
## Version
Python 3.9+
## Tests

## Contributors
<table>
<tr>
<td align="center"> <a href="https://github.com/pranavnbapat"> <img src="https://avatars.githubusercontent.com/u/7271334?v=4" width="100;" alt="pranavnbapat"/> <br />
<sub><b>Pranav Bapat</b></sub> </a>
</td>
<td align="center"> <a href="https://github.com/Cloud956"> <img src="https://avatars.githubusercontent.com/u/24865274?v=4" width="100;" alt="Cloud956"/> <br /> <sub><b>Piotr Lewandowski</b></sub> </a> </td>
<td align="center"> <a href="https://github.com/shashankmc"> <img src="https://avatars.githubusercontent.com/u/3445114?v=4" width="100;" alt="shashankmc"/> <br /> <sub><b>shashankmc</b></sub> </a> </td>
<td align="center"> <a href="https://github.com/gijsvd"> <img src="https://avatars.githubusercontent.com/u/31765316?v=4" width="100;" alt="gijsvd"/> <br /> <sub><b>gijsvd</b></sub> </a> </td>
<td align="center"> <a href="https://github.com/venvis"> <img src="https://avatars.githubusercontent.com/venvis" width="100;" alt="venvis"/> <br /> <sub><b>venvis</b></sub> </a> </td>
</tr>
</table>
## How to install?
``pip install cellar-extractor``
## What are the functions?
1. ``get_cellar``
Gets all the ECLI data from the eurlex sparql endpoint and saves them in the CSV or JSON format, in-memory or as a saved file.
2. ``get_cellar_extra``
Gets all the ECLI data from the eurlex sparql endpoint, and on top of that scrapes the eurlex websites to acquire
the full text, keywords, case law directory code and eurovoc identifiers. If the user does have an eurlex account with access to the eurlex webservices, he can also
pass his webservices login credentials to the method, in order to extract data about works citing work and works
being cited by work. The full text is returned as a JSON file, rest of data as a CSV. Can be in-memory or as saved files.
3. ``get_nodes_and_edges_lists``
Gets 2 list objects, one for the nodes and edges of the citations within the passed dataframe.
Allows the creation of a network graph of the citations. Can only be returned in-memory.
4. ``filter_subject_matter``
Returns a dataframe of cases only containing a certain phrase in the column containing the subject of cases.
## What are the classes?
1. ``FetchOperativePart``
A class whose instance(declaration) when called returns a list of the all the text contained within the operative part for each European Court of Justice (CJEU, formerly known as European Court of Justice (ECJ)) judgement (English only). The ``FetchOperativePart`` class has eleven functions - each function scrapes for the operative part depending on the html structure of the page :
- ``html_page_structure_one`` - This function retreives operative part from documents of the respected celex id's. This function scrapes/parse the operative part from a nested table structure . The relevant text lies inside the coj-bold class of the span tag.
- ``html_page_structure_two`` - This function retreives operative part from documents of the respected celex id's. This function scrapes/parse the operative part from a paragraph (p) structure. The relevant text lies inside the normal class of the p tag which comes after the keyword operative of the previous span tag.
- ``structure_three`` - This function retreives operative part from documents of the respected celex id's. This function scrapes/parse the operative part from a nested table structure. The relevant text lies inside the coj-bold class of the span tag.
- `structure_four` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a paragraph (p) structure. The relevant text lies inside the p tag which comes after the keyword operative of the previous span tag.
- `structure_five` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a paragraph (p) structure. The relevant text lies inside the normal class of the p tag which comes after the keyword operative of the previous span tag.
- `structure_six` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a h2 (header) structure. The relevant text lies inside the p tag which comes after the keyword operative part of the respective h2 tag.
- `structure_seven` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a table (table) structure. The relevant text lies inside the span tag which comes after the p tag, with the class name=normal.
- `structure_eight` - This function retrieves the operative part from documents of the respected celex ids. The text is extracted from the span tag nested inside the tbody tag. Returns a list as output.
- `structure_nine` - This function retrieves the operative part from documents of the respected celex ids. The operative part is under the bold (b) tag after the p tag where the keywords "on those grounds" exist.
- `structure_ten` - This function retrieves the operative part from documents of the respected celex ids. Since the content is preloaded using js/client server side functions, the text from the current page is retrieved and the operative part is scraped after the occurrence of the phrase "On those grounds".
- `structure_eleven` - This function retrieves the operative part from documents of the respected celex ids. The operative part is under the paragraph (p) tag after the b tag where the keywords "operative part" exist.
2. ``Writing``
A class which writes the text for the operative part for each European Case law case(En-English only) into csv,json and txt files(Generated upon initialization). The ``Writing`` class has three functions:
- ``to_csv()`` - Writes the operative part along with celex id into a csv file.
- ``to_json()`` - Writes the operative part along with celex id into a json file.
- ``to_txt()`` - Writes the operative part along with celex id into a txt file
3. ``CellarSparqlQuery``
A class which includes methods to extract extra data for each court case using a sparql query.
- ``get_endorsements`` - Fetches endorsements of the judgement
- ``get_subjects`` - Fetches subjects of the judgement
- ``get_parties`` - Fetches parties of the judgement
- ``get_keywords`` - Fetches keywords of the judgement
- ``get_citations`` - Fetches court cases cited by the source judgement
- ``get_grounds`` - Fetches grounds of the judgement
## What are the parameters?
1. ``get_cellar``
**Parameters**:
- **max_ecli**: **int, optional, default 100**
Maximum number of ECLIs to retrieve.
- **sd: date, optional, default '2022-05-01'**
The start last modification date (yyyy-mm-dd).
- **ed: date, optional, default current date**
The end last modification date (yyyy-mm-dd).
- **save_file: ['y', 'n'],optional, default 'y'**
Save data in a data folder, or return in-memory.
- **file_format: ['csv', 'json'],optional, default 'csv'**
Returns the data as a JSON/dictionary, or as a CSV/Pandas Dataframe object.
2. ``get_cellar_extra``
- **max_ecli: int, optional, default 100**
Maximum number of ECLIs to retrieve.
- **sd: date, optional, default '2022-05-01'**
The start last modification date (yyyy-mm-dd).
- **ed: date, optional, default current date**
The end last modification date (yyyy-mm-dd).
- **save_file: ['y', 'n'],optional, default 'y'**
Save the full text of cases as JSON file / return as a dictionary and save the rest ofthe data as a CSV file / return as a Pandas Dataframe object.
- **threads: int ,optional, default 10**
Extracting the additional data takes a lot of time. The use of multi-threading can cut down this time. Even with this, the method may take a couple of minutes for a couple of hundred cases. A maximum number of 10 recommended, as this method may also affect the device's internet connection.
- **username: string, optional, default empty string**
The username to the eurlex webservices.
- **password: string, optional, default empty string**
The password to the eurlex webservices.
3. ``get_nodes_and_edges_lists``
- **df: DataFrame object, required, default None**
DataFrame of cellar metadata acquired from the ``get_cellar_extra`` method with eurlex webservice credentials passed. This method will only work on dataframes with citations data.
- **only_local: boolean, optional, default False**
Flag for nodes and edges generation. If set to True, the network created will only include nodes and edges between
cases exclusively inside the given dataframe.
4. ``filter_subject_matter``
- **df: DataFrame object, required, default None**
DataFrame of cellar metadata acquired from any of the cellar extraction methods listed above.
- **phrase: string, required, default None**
The phrase which has to be present in the subject matter of cases. Case insensitive.
5. ``Analyzer``
- **celex id: str, required**
- Pass as a constructor upon initializing the class
6. ``Writing``
- **celex id: str, required**
- Pass as a constructor upon initializing the class
## Examples
```python
import cellar_extractor as cell
# Below are examples for in-file saving:
cell.get_cellar(save_file='y', max_ecli=200, sd='2022-01-01', file_format='csv')
cell.get_cellar_extra(max_ecli=100, sd='2022-01-01', threads=10)
# Below are examples for in-memory saving:
df = cell.get_cellar(save_file='n', file_format='csv', sd='2022-01-01', max_ecli=1000)
df,json = cell.get_cellar_extra(save_file='n', max_ecli=100, sd='2022-01-01', threads=10)
```
Create a callback of the instance of the class initiated and pass a list as it's value.
```python
import cellar_extractor as cell
instance=cell.FetchOperativePart(celex_id:str)
output_list=instance()
print(output_list) # prints operative part of the Case as a list
```
The Writing Class also takes a celex id , upon initializing the class , through the means of the constructor and writes the content of its operative part into different files, depending on the function called.
```python
import cellar_extractor as cell
instance=cell.Writing(celex_id:str)
output=instance.to_csv() # for csv
output=instance.to_txt() # for txt
output=instance.to_json() # for json
```
## License
[](https://opensource.org/licenses/Apache-2.0)
Previously under the [MIT License](https://opensource.org/licenses/MIT), as of 28/10/2022 this work is licensed under a [Apache License, Version 2.0](https://opensource.org/licenses/Apache-2.0).
```
Apache License, Version 2.0
Copyright (c) 2022 Maastricht Law & Tech Lab
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
```
Raw data
{
"_id": null,
"home_page": null,
"name": "cellar-extractor",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": null,
"keywords": "cellar, extractor, eurlex, legal, case-law, sparql, ecli",
"author": null,
"author_email": "LawTech Lab <law-techlab@maastrichtuniversity.nl>",
"download_url": "https://files.pythonhosted.org/packages/08/be/cba295b2599f7aac04cc9ec1eb9608e504063bdf77a03886a4e2317d829d/cellar_extractor-1.2.4.tar.gz",
"platform": null,
"description": "# Cellar Extractor\n\nA Python library for extracting CELLAR case law data from EUR-Lex.\n\nThis library contains functions to get CELLAR case law data from the EUR-Lex SPARQL endpoint and scrape additional information from EUR-Lex websites.\n\n## Version\n\nPython 3.9+\n\n## Tests\n\n\n\n## Contributors\n\n<table>\n <tr>\n <td align=\"center\"> <a href=\"https://github.com/pranavnbapat\"> <img src=\"https://avatars.githubusercontent.com/u/7271334?v=4\" width=\"100;\" alt=\"pranavnbapat\"/> <br />\n <sub><b>Pranav Bapat</b></sub> </a> \n </td>\n <td align=\"center\"> <a href=\"https://github.com/Cloud956\"> <img src=\"https://avatars.githubusercontent.com/u/24865274?v=4\" width=\"100;\" alt=\"Cloud956\"/> <br /> <sub><b>Piotr Lewandowski</b></sub> </a> </td>\n <td align=\"center\"> <a href=\"https://github.com/shashankmc\"> <img src=\"https://avatars.githubusercontent.com/u/3445114?v=4\" width=\"100;\" alt=\"shashankmc\"/> <br /> <sub><b>shashankmc</b></sub> </a> </td>\n <td align=\"center\"> <a href=\"https://github.com/gijsvd\"> <img src=\"https://avatars.githubusercontent.com/u/31765316?v=4\" width=\"100;\" alt=\"gijsvd\"/> <br /> <sub><b>gijsvd</b></sub> </a> </td>\n <td align=\"center\"> <a href=\"https://github.com/venvis\"> <img src=\"https://avatars.githubusercontent.com/venvis\" width=\"100;\" alt=\"venvis\"/> <br /> <sub><b>venvis</b></sub> </a> </td>\n </tr>\n</table>\n\n## How to install?\n\n``pip install cellar-extractor``\n\n## What are the functions?\n\n1. ``get_cellar`` \n Gets all the ECLI data from the eurlex sparql endpoint and saves them in the CSV or JSON format, in-memory or as a saved file.\n2. ``get_cellar_extra`` \n Gets all the ECLI data from the eurlex sparql endpoint, and on top of that scrapes the eurlex websites to acquire \n the full text, keywords, case law directory code and eurovoc identifiers. If the user does have an eurlex account with access to the eurlex webservices, he can also \n pass his webservices login credentials to the method, in order to extract data about works citing work and works \n being cited by work. The full text is returned as a JSON file, rest of data as a CSV. Can be in-memory or as saved files.\n3. ``get_nodes_and_edges_lists`` \n Gets 2 list objects, one for the nodes and edges of the citations within the passed dataframe.\n Allows the creation of a network graph of the citations. Can only be returned in-memory.\n4. ``filter_subject_matter`` \n Returns a dataframe of cases only containing a certain phrase in the column containing the subject of cases.\n\n## What are the classes?\n\n1. ``FetchOperativePart`` \n A class whose instance(declaration) when called returns a list of the all the text contained within the operative part for each European Court of Justice (CJEU, formerly known as European Court of Justice (ECJ)) judgement (English only). The ``FetchOperativePart`` class has eleven functions - each function scrapes for the operative part depending on the html structure of the page :\n - ``html_page_structure_one`` - This function retreives operative part from documents of the respected celex id's. This function scrapes/parse the operative part from a nested table structure . The relevant text lies inside the coj-bold class of the span tag.\n - ``html_page_structure_two`` - This function retreives operative part from documents of the respected celex id's. This function scrapes/parse the operative part from a paragraph (p) structure. The relevant text lies inside the normal class of the p tag which comes after the keyword operative of the previous span tag.\n - ``structure_three`` - This function retreives operative part from documents of the respected celex id's. This function scrapes/parse the operative part from a nested table structure. The relevant text lies inside the coj-bold class of the span tag.\n - `structure_four` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a paragraph (p) structure. The relevant text lies inside the p tag which comes after the keyword operative of the previous span tag.\n - `structure_five` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a paragraph (p) structure. The relevant text lies inside the normal class of the p tag which comes after the keyword operative of the previous span tag.\n - `structure_six` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a h2 (header) structure. The relevant text lies inside the p tag which comes after the keyword operative part of the respective h2 tag.\n - `structure_seven` - This function retrieves the operative part from documents of the respected celex ids. This function scrapes/parses the operative part from a table (table) structure. The relevant text lies inside the span tag which comes after the p tag, with the class name=normal. \n - `structure_eight` - This function retrieves the operative part from documents of the respected celex ids. The text is extracted from the span tag nested inside the tbody tag. Returns a list as output.\n - `structure_nine` - This function retrieves the operative part from documents of the respected celex ids. The operative part is under the bold (b) tag after the p tag where the keywords \"on those grounds\" exist.\n - `structure_ten` - This function retrieves the operative part from documents of the respected celex ids. Since the content is preloaded using js/client server side functions, the text from the current page is retrieved and the operative part is scraped after the occurrence of the phrase \"On those grounds\".\n - `structure_eleven` - This function retrieves the operative part from documents of the respected celex ids. The operative part is under the paragraph (p) tag after the b tag where the keywords \"operative part\" exist.\n\n2. ``Writing`` \nA class which writes the text for the operative part for each European Case law case(En-English only) into csv,json and txt files(Generated upon initialization). The ``Writing`` class has three functions:\n - ``to_csv()`` - Writes the operative part along with celex id into a csv file.\n - ``to_json()`` - Writes the operative part along with celex id into a json file.\n - ``to_txt()`` - Writes the operative part along with celex id into a txt file\n \n3. ``CellarSparqlQuery``\nA class which includes methods to extract extra data for each court case using a sparql query.\n - ``get_endorsements`` - Fetches endorsements of the judgement\n - ``get_subjects`` - Fetches subjects of the judgement\n - ``get_parties`` - Fetches parties of the judgement\n - ``get_keywords`` - Fetches keywords of the judgement\n - ``get_citations`` - Fetches court cases cited by the source judgement\n - ``get_grounds`` - Fetches grounds of the judgement\n\n## What are the parameters?\n\n1. ``get_cellar`` \n **Parameters**:\n - **max_ecli**: **int, optional, default 100** \n Maximum number of ECLIs to retrieve.\n - **sd: date, optional, default '2022-05-01'** \n The start last modification date (yyyy-mm-dd).\n - **ed: date, optional, default current date** \n The end last modification date (yyyy-mm-dd).\n - **save_file: ['y', 'n'],optional, default 'y'** \n Save data in a data folder, or return in-memory.\n - **file_format: ['csv', 'json'],optional, default 'csv'** \n Returns the data as a JSON/dictionary, or as a CSV/Pandas Dataframe object.\n\n2. ``get_cellar_extra``\n - **max_ecli: int, optional, default 100** \n Maximum number of ECLIs to retrieve.\n - **sd: date, optional, default '2022-05-01'** \n The start last modification date (yyyy-mm-dd).\n - **ed: date, optional, default current date** \n The end last modification date (yyyy-mm-dd).\n - **save_file: ['y', 'n'],optional, default 'y'** \n Save the full text of cases as JSON file / return as a dictionary and save the rest ofthe data as a CSV file / return as a Pandas Dataframe object.\n - **threads: int ,optional, default 10** \n Extracting the additional data takes a lot of time. The use of multi-threading can cut down this time. Even with this, the method may take a couple of minutes for a couple of hundred cases. A maximum number of 10 recommended, as this method may also affect the device's internet connection.\n - **username: string, optional, default empty string** \n The username to the eurlex webservices.\n - **password: string, optional, default empty string** \n The password to the eurlex webservices.\n\n3. ``get_nodes_and_edges_lists``\n - **df: DataFrame object, required, default None** \n DataFrame of cellar metadata acquired from the ``get_cellar_extra`` method with eurlex webservice credentials passed. This method will only work on dataframes with citations data.\n - **only_local: boolean, optional, default False** \n Flag for nodes and edges generation. If set to True, the network created will only include nodes and edges between\n cases exclusively inside the given dataframe.\n\n4. ``filter_subject_matter``\n - **df: DataFrame object, required, default None** \n DataFrame of cellar metadata acquired from any of the cellar extraction methods listed above.\n - **phrase: string, required, default None** \n The phrase which has to be present in the subject matter of cases. Case insensitive.\n\n5. ``Analyzer``\n - **celex id: str, required**\n - Pass as a constructor upon initializing the class\n\n6. ``Writing``\n - **celex id: str, required**\n - Pass as a constructor upon initializing the class\n\n## Examples\n\n```python\nimport cellar_extractor as cell\n\n# Below are examples for in-file saving:\n\ncell.get_cellar(save_file='y', max_ecli=200, sd='2022-01-01', file_format='csv')\ncell.get_cellar_extra(max_ecli=100, sd='2022-01-01', threads=10)\n\n# Below are examples for in-memory saving:\n\ndf = cell.get_cellar(save_file='n', file_format='csv', sd='2022-01-01', max_ecli=1000)\ndf,json = cell.get_cellar_extra(save_file='n', max_ecli=100, sd='2022-01-01', threads=10)\n```\n\nCreate a callback of the instance of the class initiated and pass a list as it's value.\n\n```python\nimport cellar_extractor as cell\ninstance=cell.FetchOperativePart(celex_id:str)\noutput_list=instance()\nprint(output_list) # prints operative part of the Case as a list\n```\n\nThe Writing Class also takes a celex id , upon initializing the class , through the means of the constructor and writes the content of its operative part into different files, depending on the function called.\n\n```python\nimport cellar_extractor as cell\ninstance=cell.Writing(celex_id:str)\noutput=instance.to_csv() # for csv\noutput=instance.to_txt() # for txt\noutput=instance.to_json() # for json\n```\n\n## License\n[](https://opensource.org/licenses/Apache-2.0)\n\nPreviously under the [MIT License](https://opensource.org/licenses/MIT), as of 28/10/2022 this work is licensed under a [Apache License, Version 2.0](https://opensource.org/licenses/Apache-2.0).\n```\nApache License, Version 2.0\n\nCopyright (c) 2022 Maastricht Law & Tech Lab\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this file except in compliance with the License.\nYou may obtain a copy of the License at\n \n http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n```\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Library for extracting CELLAR case law data from EUR-Lex",
"version": "1.2.4",
"project_urls": {
"Bug Tracker": "https://github.com/maastrichtlawtech/cellar-extractor/issues",
"Documentation": "https://github.com/maastrichtlawtech/cellar-extractor/blob/main/README.md",
"Homepage": "https://github.com/maastrichtlawtech/cellar-extractor",
"Source Code": "https://github.com/maastrichtlawtech/cellar-extractor"
},
"split_keywords": [
"cellar",
" extractor",
" eurlex",
" legal",
" case-law",
" sparql",
" ecli"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "b75af1f3986d83da45cc45444ba3a17d89ddbe8e6dfedcb20090f59d363b1523",
"md5": "7962236a69d9b22244abd122302d06ed",
"sha256": "019dddbfa57df6297d6948c793bdefcfd8a520814040aa4968af2cc7ed1c62df"
},
"downloads": -1,
"filename": "cellar_extractor-1.2.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "7962236a69d9b22244abd122302d06ed",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 34113,
"upload_time": "2025-08-22T09:51:02",
"upload_time_iso_8601": "2025-08-22T09:51:02.065921Z",
"url": "https://files.pythonhosted.org/packages/b7/5a/f1f3986d83da45cc45444ba3a17d89ddbe8e6dfedcb20090f59d363b1523/cellar_extractor-1.2.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "08becba295b2599f7aac04cc9ec1eb9608e504063bdf77a03886a4e2317d829d",
"md5": "09a88bd8bb99ebb6dea7e78d8a98d187",
"sha256": "1530726e230fe293959cf0d247397121d9d403938ff35f241e1f0dd8209c1e77"
},
"downloads": -1,
"filename": "cellar_extractor-1.2.4.tar.gz",
"has_sig": false,
"md5_digest": "09a88bd8bb99ebb6dea7e78d8a98d187",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 53271,
"upload_time": "2025-08-22T09:51:03",
"upload_time_iso_8601": "2025-08-22T09:51:03.179919Z",
"url": "https://files.pythonhosted.org/packages/08/be/cba295b2599f7aac04cc9ec1eb9608e504063bdf77a03886a4e2317d829d/cellar_extractor-1.2.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-22 09:51:03",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "maastrichtlawtech",
"github_project": "cellar-extractor",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [
{
"name": "xmltodict",
"specs": []
},
{
"name": "requests",
"specs": []
},
{
"name": "beautifulsoup4",
"specs": []
},
{
"name": "tqdm",
"specs": []
},
{
"name": "SPARQLWrapper",
"specs": []
},
{
"name": "pandas",
"specs": []
}
],
"lcname": "cellar-extractor"
}