insert era category_id into state table