HTML5 Web SQL database file location in chrome
Navigate your Chrome to chrome://version url and check the Profile Path value. Your sqlite db should be inside it, in 'databases' folder.
And your particular problem with 2 found rows (rather than 4) is probably caused by inserting rows with same ids. id column is unique, so additional inserts are failing.
Open chrome. Press F12 and then go to application in the first row (you may use >> symbol).Go to storage->websql and see your database :)