Hello !
Here is the database dump with 50 records:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE json_tbl(id integer primary key, json text collate nocase);
INSERT INTO "json_tbl" VALUES(1,'{"id" : 1, "value" : "the_value_1"}');
INSERT INTO "json_tbl" VALUES(2,'{"id" : 2, "value" : "the_value_2"}');
INSERT INTO "json_tbl" VALUES(3,'{"id" : 3, "value" : "the_value_3"}');
INSERT INTO "json_tbl" VALUES(4,'{"id" : 4, "value" : "the_value_4"}');
INSERT INTO "json_tbl" VALUES(5,'{"id" : 5, "value" : "the_value_5"}');
INSERT INTO "json_tbl" VALUES(6,'{"id" : 6, "value" : "the_value_6"}');
INSERT INTO "json_tbl" VALUES(7,'{"id" : 7, "value" : "the_value_7"}');
INSERT INTO "json_tbl" VALUES(8,'{"id" : 8, "value" : "the_value_8"}');
INSERT INTO "json_tbl" VALUES(9,'{"id" : 9, "value" : "the_value_9"}');
INSERT INTO "json_tbl" VALUES(10,'{"id" : 10, "value" : "the_value_10"}');
INSERT INTO "json_tbl" VALUES(11,'{"id" : 11, "value" : "the_value_11"}');
INSERT INTO "json_tbl" VALUES(12,'{"id" : 12, "value" : "the_value_12"}');
INSERT INTO "json_tbl" VALUES(13,'{"id" : 13, "value" : "the_value_13"}');
INSERT INTO "json_tbl" VALUES(14,'{"id" : 14, "value" : "the_value_14"}');
INSERT INTO "json_tbl" VALUES(15,'{"id" : 15, "value" : "the_value_15"}');
INSERT INTO "json_tbl" VALUES(16,'{"id" : 16, "value" : "the_value_16"}');
INSERT INTO "json_tbl" VALUES(17,'{"id" : 17, "value" : "the_value_17"}');
INSERT INTO "json_tbl" VALUES(18,'{"id" : 18, "value" : "the_value_18"}');
INSERT INTO "json_tbl" VALUES(19,'{"id" : 19, "value" : "the_value_19"}');
INSERT INTO "json_tbl" VALUES(20,'{"id" : 20, "value" : "the_value_20"}');
INSERT INTO "json_tbl" VALUES(21,'{"id" : 21, "value" : "the_value_21"}');
INSERT INTO "json_tbl" VALUES(22,'{"id" : 22, "value" : "the_value_22"}');
INSERT INTO "json_tbl" VALUES(23,'{"id" : 23, "value" : "the_value_23"}');
INSERT INTO "json_tbl" VALUES(24,'{"id" : 24, "value" : "the_value_24"}');
INSERT INTO "json_tbl" VALUES(25,'{"id" : 25, "value" : "the_value_25"}');
INSERT INTO "json_tbl" VALUES(26,'{"id" : 26, "value" : "the_value_26"}');
INSERT INTO "json_tbl" VALUES(27,'{"id" : 27, "value" : "the_value_27"}');
INSERT INTO "json_tbl" VALUES(28,'{"id" : 28, "value" : "the_value_28"}');
INSERT INTO "json_tbl" VALUES(29,'{"id" : 29, "value" : "the_value_29"}');
INSERT INTO "json_tbl" VALUES(30,'{"id" : 30, "value" : "the_value_30"}');
INSERT INTO "json_tbl" VALUES(31,'{"id" : 31, "value" : "the_value_31"}');
INSERT INTO "json_tbl" VALUES(32,'{"id" : 32, "value" : "the_value_32"}');
INSERT INTO "json_tbl" VALUES(33,'{"id" : 33, "value" : "the_value_33"}');
INSERT INTO "json_tbl" VALUES(34,'{"id" : 34, "value" : "the_value_34"}');
INSERT INTO "json_tbl" VALUES(35,'{"id" : 35, "value" : "the_value_35"}');
INSERT INTO "json_tbl" VALUES(36,'{"id" : 36, "value" : "the_value_36"}');
INSERT INTO "json_tbl" VALUES(37,'{"id" : 37, "value" : "the_value_37"}');
INSERT INTO "json_tbl" VALUES(38,'{"id" : 38, "value" : "the_value_38"}');
INSERT INTO "json_tbl" VALUES(39,'{"id" : 39, "value" : "the_value_39"}');
INSERT INTO "json_tbl" VALUES(40,'{"id" : 40, "value" : "the_value_40"}');
INSERT INTO "json_tbl" VALUES(41,'{"id" : 41, "value" : "the_value_41"}');
INSERT INTO "json_tbl" VALUES(42,'{"id" : 42, "value" : "the_value_42"}');
INSERT INTO "json_tbl" VALUES(43,'{"id" : 43, "value" : "the_value_43"}');
INSERT INTO "json_tbl" VALUES(44,'{"id" : 44, "value" : "the_value_44"}');
INSERT INTO "json_tbl" VALUES(45,'{"id" : 45, "value" : "the_value_45"}');
INSERT INTO "json_tbl" VALUES(46,'{"id" : 46, "value" : "the_value_46"}');
INSERT INTO "json_tbl" VALUES(47,'{"id" : 47, "value" : "the_value_47"}');
INSERT INTO "json_tbl" VALUES(48,'{"id" : 48, "value" : "the_value_48"}');
INSERT INTO "json_tbl" VALUES(49,'{"id" : 49, "value" : "the_value_49"}');
CREATE INDEX json_tbl_idx on json_tbl(json_extract(json, '$.value'));
COMMIT;
?
