In [ ]:

    

import sqlite3
db = "npi_data.db"


    

In [ ]:

    

conn = sqlite3.connect(db)
c = conn.cursor()


    

In [ ]:

    

c.execute("SELECT * FROM npi_data WHERE lower(city)='houston'")
result = c.fetchall()
print(len(result))


    

In [ ]:

    

c.execute("SELECT * FROM npi_data WHERE lower(city)='athens'")
result = c.fetchall()
print(len(result))


    

In [ ]:

    

c.execute("SELECT * FROM npi_data WHERE lower(city)='athens' and state='TX'")
result = c.fetchall()
print(len(result))


    

In [ ]:

    

c.execute("SELECT * FROM npi_data WHERE city LIKE 'Z%'")
result = c.fetchall()
print((result))


    

In [ ]:

    

c.execute("SELECT * FROM npi_data WHERE city LIKE 'Z___'")
result = c.fetchall()
print((result))


    

In [ ]:

    

c.execute("SELECT * FROM npi_data WHERE city LIKE 'Z___' and state='IL'")
result = c.fetchall()
print((result))


    

In [ ]:

    

c.execute("SELECT * FROM npi_data WHERE city LIKE 'Z___' and state='IL' and name like 'MA%'")
result = c.fetchall()
print((result))


    

In [ ]:

    

result[0][0]


    

In [ ]:

    

result[0][0].split("  ")


    

In [ ]:

    

conn.close()


    

In [ ]: