integrityError: UNIQUE constraint failed: sqlite, even though no primary keys?

I have an enormous json file which I'm putting into sqlite. I create the table like so:

create table table_name
(ID integer, account text
primary key(ID));

While putting it into a table, I kept getting an error:

integrityError: UNIQUE constraint failed: sqlite

So, I recreated the table WITHOUT the primary keys, like so:

create table table_name
(ID integer,
         account text);

But, still the same error arises. How do I get rid of this error?