Sample query for the CNPJ sqlite3 database

cnpj_sample_query.py

import sqlite3
import csv
import pandas as pd
 
def main():
  database_file = "CNPJ_full.db"

  conn = conn = sqlite3.connect(database_file)

  df = pd.read_sql_query("SELECT * FROM empresas WHERE municipio='PELOTAS'", conn)

  df.to_csv('cnpj_empresas_pelotas.csv', quotechar='"', quoting=csv.QUOTE_NONNUMERIC, index=False, encoding='utf-8')

if __name__ == '__main__':
    main()