cabinet_fts_idx

Data source: ParlGov · About: simonw/parlgov-datasette

33 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link segid term pgno
1,b'' 1 <Binary: 0 bytes> 2
1,b'0170' 1 <Binary: 4 bytes> 4
1,b'01994' 1 <Binary: 5 bytes> 6
1,b'0202' 1 <Binary: 4 bytes> 8
1,b'0288' 1 <Binary: 4 bytes> 10
1,b'070' 1 <Binary: 3 bytes> 12
1,b'0ac' 1 <Binary: 3 bytes> 14
1,b'0ana' 1 <Binary: 4 bytes> 16
1,b'0appr' 1 <Binary: 5 bytes> 18
1,b'0bir' 1 <Binary: 4 bytes> 20
1,b'0cai' 1 <Binary: 4 bytes> 22
1,b'0char' 1 <Binary: 5 bytes> 24
1,b'0contr' 1 <Binary: 6 bytes> 26
1,b'0dir' 1 <Binary: 4 bytes> 28
1,b'0ende' 1 <Binary: 5 bytes> 30
1,b'0foo' 1 <Binary: 4 bytes> 32
1,b'0hart' 1 <Binary: 5 bytes> 34
1,b'0iii' 1 <Binary: 4 bytes> 36
1,b'0invo' 1 <Binary: 5 bytes> 38
1,b'0kip' 1 <Binary: 4 bytes> 40
1,b'0mads' 1 <Binary: 5 bytes> 42
1,b'0mo' 1 <Binary: 3 bytes> 44
1,b'0ns' 1 <Binary: 3 bytes> 46
1,b'0onl' 1 <Binary: 4 bytes> 50
1,b'0pho' 1 <Binary: 4 bytes> 52
1,b'0pun' 1 <Binary: 4 bytes> 54
1,b'0roc' 1 <Binary: 4 bytes> 56
1,b'0somet' 1 <Binary: 6 bytes> 58
1,b'0thei' 1 <Binary: 5 bytes> 60
1,b'0unit' 1 <Binary: 5 bytes> 62
1,b'0wag' 1 <Binary: 4 bytes> 64
1,b'0withd' 1 <Binary: 6 bytes> 66
1,b'0yea' 1 <Binary: 4 bytes> 68

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE 'cabinet_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID;