Empty database while working with SQLite

Q&A DQ Courses
#1

Screen Link: http://127.0.0.1:8888/notebooks/SQLite.ipynb

My Code: 

%%sql
SELECT *
  FROM sqlite_master
WHERE type='table';

What I expected to happen:

type name tbl_name rootpage sql
table sqlite_sequence sqlite_sequence 3 CREATE TABLE sqlite_sequence(name,seq)
table facts facts 47 CREATE TABLE “facts” (“id” INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, “code” varchar(255) NOT NULL, “name” varchar(255) NOT NULL, “area” integer, “area_land” integer, “area_water” integer, “population” integer, “population_growth” float, “birth_rate” float, “death_rate” float, “migration_rate” float)

What actually happened:

  • sqlite:///factbook(3).db
    Done.
type	name	tbl_name	rootpage	sql

please somebody to take me through, I am stuck…