SQL Developer / Metadata knowledge

SQL Developer / Metadata knowledge

I need one person who can create a data-based from the details file of the JSON field
Can filter the data only needed
below the structure sample

Structure
The data dumps are structured as follows:

When you unzip/untar the file, you will have a single directory of the form doaj_zx[type]_data_[date generated].
Inside that directory, you will find a list of files with names of the form [type]_batch_[number].json.
For example, journal_batch_3.json or article_batch_27.json.
Each file contains up to 100,000 records and is UTF-8 encoded. All files should contain the same number of records, apart from the last one, which may have fewer.
The structure of each file is as a JSON list: [ { ... first record ... }, { ... second record ... }, { ... third record ...}, ... etc ... ]
Records are not explicitly ordered and the order is not guaranteed to remain consistent across data dumps produced on different days.