Kanji database 漢字データベース SQL interface

SQL query:


For the database specialists: run any SQL query you like using the Kanji and/or Jukugo databases. Table and column names can be entered by clicking, to prevent typing errors. Remember to always use backticks around `column names` and 'single' or "double quotes" around strings! Some queries are forbidden for security reasons.

RESULT:

Empty query

Kanji table name:

KanjiTable

Kanji table columns:

`id`
`Kanji`
`Strokes`
`Grade`
`Kanji Classification`
`JLPT-test`
`Name of Radical`
`Radical Freq.`
`Reading within Joyo`
`Reading beyond Joyo`
`# of On`
`On within Joyo`
`Kanji ID in Nelson`
`# of Meanings of On`
`Translation of On`
`# of Kun within Joyo with inflections`
`# of Kun within Joyo without inflections`
`Kun within Joyo`
`# of Meanings of Kun`
`Translation of Kun`
`Year of Inclusion`
`Kanji Frequency with Proper Nouns`
`Acc. Freq. On with Proper Nouns`
`Acc. Freq. Kun with Proper Nouns`
`On Ratio with Proper Nouns`
`Acc. Freq. On beyond Joyo with Proper Nouns`
`Acc. Freq. Kun beyond Joyo with Proper Nouns`
`Acc. On Ratio beyond Joyo with Proper Nouns`
`Kanji Frequency without Proper Nouns`
`Acc. Freq. On without Proper Nouns`
`Acc. Freq. Kun without Proper Nouns`
`On Ratio without Proper Nouns`
`Acc. Freq. On beyond Joyo without Proper Nouns`
`Acc. Freq. Kun beyond Joyo without Proper Nouns`
`On Ratio beyond Joyo without Proper Nouns`
`Left Kanji Prod.`
`Right Kanji Prod.`
`Acc. Freq. Left Prod.`
`Acc. Freq. Right Prod.`
`Symmetry`
`Left Entropy`
`Right Entropy`
`Left1sound`
`Left1freq`
`Left2sound`
`Left2freq`
`Left3sound`
`Left3freq`
`Left4sound`
`Left4freq`
`Left5sound`
`Left5freq`
`Left6sound`
`Left6freq`
`Right1sound`
`Right1freq`
`Right2sound`
`Right2freq`
`Right3sound`
`Right3freq`
`Right4sound`
`Right4freq`
`Right5sound`
`Right5freq`
`Right6sound`
`Right6freq`
`Right7sound`
`Right7freq`

Jukugo table name:

JukugoTable

Jukugo table columns:

`id`
`Comp. Word`
`Frequency`
`Grammatical Feature`
`Pronunciation`
`English Translation`

Example queries:

Version: Juli 17, 2020 13:39 scripts © S.Sanders