Iterate over the file, loading each line as JSON in the loop:

tweets = []
with open('tweets.json', 'r') as file:
    for line in file:
        tweets.append(json.loads(line))

This avoids storing intermediate python objects. As long as you write one full tweet per append() call, this should work.

You have two records in your json file, and json.loads() is not able to decode more than one. You need to do it record by record.

See Python json.loads shows ValueError: Extra data

OR you need to reformat your json to contain an array:

{
    "foo" : [
       {"name": "XYZ", "address": "54.7168,94.0215", "country_of_residence": "PQR", "countries": "LMN;PQRST", "date": "28-AUG-2008", "type": null},
       {"name": "OLMS", "address": null, "country_of_residence": null, "countries": "Not identified;No", "date": "23-FEB-2017", "type": null}
    ]
}

would be acceptable again. But there cannot be several top level objects.

There are several ways to decode json from response obtained through requests library.

I expect that you got response with code similar to this:

response = requests.get(url)

First, most low-level, but reliable and easy to debug, it uses response.content which is raw body bytes of response:

result = json.loads(response.content.decode('utf-8'))

second uses response.text which is basically response.content automatically converted to text string using best matching encoding by requests library:

result = json.loads(response.text)

and most high-level and simple, where requests takes all care to do the right job of conversion:

result = response.json()

One of this methods should work.

Also after receiving response you always need to check status code, because requests doesn't throw exception on non-200 status code, so you need to do assert response.status_code == 200 or response.raise_for_status() before decoding. Status code not equal to 200 always means that server responded with error and response will not contain json. Here is List of HTTP Status Codes.

All most common features of requests library (including json parsing) are described in short documentation here.

This is bug in AutoTS.

https://github.com/winedarksea/AutoTS/blame/7a843d050f62c1b4046c0b08020838e8eb95388a/autots/templates/general.py#L467

As seen on that row, it has '" at the start and that causes the json decoder to fail.

Downgrade autots for quick fix.