notices

Data license: 비공개

449 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: law_type, is_d5_alerted, proposer, region, start_date (date), end_date (date), collected_at (date), outcome_checked_at (date)

Next page

CREATE TABLE notices (
	id INTEGER NOT NULL, 
	elis_id VARCHAR(50) NOT NULL, 
	title VARCHAR(500) NOT NULL, 
	url VARCHAR(1000), 
	ministry VARCHAR(100), 
	law_type VARCHAR(50), 
	field VARCHAR(100), 
	content TEXT, 
	start_date VARCHAR(30), 
	end_date VARCHAR(30), 
	collected_at DATETIME, 
	is_channel_posted BOOLEAN, 
	is_d5_alerted BOOLEAN, 
	bill_no VARCHAR(50), 
	outcome VARCHAR(20), 
	promulgated_date VARCHAR(30), 
	outcome_checked_at DATETIME, proposer VARCHAR(200), region VARCHAR(20), district VARCHAR(30), council_level VARCHAR(10), 
	PRIMARY KEY (id), 
	UNIQUE (elis_id)
);