Сохранение в файл JSON

import psycopg2
import sqlite3
import json
 
pg_connection = #данные соединения 
conn = psycopg2.connect(**pg_connection)
cursor = conn.cursor()
sql_str = """
    SELECT movieid, COUNT(movieid) FROM ratings 
    GROUP BY movieid 
    ORDER BY COUNT(movieid) DESC LIMIT 10;
"""
cursor.execute(sql_str)
row_count = [i for i in cursor.fetchall()]
conn.commit()
cursor.close()
for row in row_count:
    row_dict = {"movieid": row[0], "popularity": row[1]}
    popular_json = json.dumps(row_dict)
    print(popular_json)
with open("./content_popularity.json", "w") as file:
    file.write(popular_json)

with open("./content_popularity.json") as f:
    d = json.load(f)
    print(d)

with open("./content_popularity.json", "w") as file:
    for row in row_count:
        row_dict = {"movieid": row[0], "popularity": row[1]}
        popular_json = json.dumps(row_dict)
        print(popular_json)
        file.write(popular_json)

file.writelines(popular_json)

import json
 
row_count = [[1, 0], [2, 1], [3, 2]]
 
popular_json = {}
popular_json['data'] = []
 
for row in row_count:
    row_dict = {"movieid": row[0], "popularity": row[1]}
    popular_json['data'].append(row_dict)
 
json_data = json.dumps(popular_json)
with open("content_popularity.json", "w") as file:
    file.writelines(json_data)
 
with open('content_popularity.json') as json_file:  
    data = json.load(json_file)
    print(data)