info_id
Data source: ParlGov · About: simonw/parlgov-datasette
11 rows where table_variable = "news_type" sorted by wikipedia
This data as json, CSV (advanced)
Suggested facets: description
id | table_variable | order | short | name | description | wikipedia ▼ | old_id |
---|---|---|---|---|---|---|---|
107 | news_type | 1 | recent | recent event | |||
108 | news_type | 90 | votes | votes level | |||
109 | news_type | 9 | change | change data | |||
110 | news_type | 15 | stable | stable release | |||
111 | news_type | 20 | presentation | presentation | |||
112 | news_type | 3 | update | update | |||
113 | news_type | 25 | publication | publication | |||
114 | news_type | 7 | new-data | new data | |||
115 | news_type | 30 | announce | announcement | |||
116 | news_type | 50 | misc | miscellaneous | |||
120 | news_type | 12 | snippets | snippets | ParlGov snippets on Github -- https://github.com/hdigital/parlgov-snippets |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "info_id" ( "id" integer NOT NULL PRIMARY KEY, "table_variable" varchar(100) NOT NULL, "order" integer unsigned NOT NULL, "short" varchar(10) NOT NULL, "name" varchar(50) NOT NULL, "description" text, "wikipedia" varchar(200), "old_id" integer unsigned, UNIQUE ("table_variable", "short") ); CREATE INDEX "info_id_67219af6" ON "info_id" ("table_variable"); CREATE INDEX "info_id_3ba08eca" ON "info_id" ("order"); CREATE INDEX "info_id_2ffcd08c" ON "info_id" ("short");