Get JSON with all words from pbd171.db

get_json.js

const words = require('./temp.json')
const fs = require('fs')

for (let i = 0; i < words.length; i+=1904) {
	const lcode = 'word_'+words[i].lan_code
	for (let j = 0; j < 1904; j++) {
		words[j][lcode] = words[i+j].word
	}
}

for (let j = 0; j < 1904; j++) {
	delete words[j]['word']
	delete words[j]['lan_code']
}

fs.writeFile('words.json', JSON.stringify(words.slice(0, 1904)), 'utf8', console.log)

script.bash

sqlite3 -json pbd171.db "select * from tblWords" > temp.json
node get_json.js

Run script.bash