Name: Oregon Newsroom Test Dataset
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Oregon Newsroom Test Dataset

Oregon.gov News room
Organization: State of Oregon
Last updated: 2020-12-04T19:09:22.588630

Tables

Table 1

@usgov.state_of_oregon_oregon_newsroom_test_dataset.table_1

135.85 kB
50 rows
34 columns

CREATE TABLE table_1 (
  "agency" VARCHAR,
  "related_agencies" VARCHAR,
  "headline" VARCHAR,
  "subheadline" VARCHAR,
  "publish_date" VARCHAR,
  "publish_year" BIGINT,
  "city" VARCHAR,
  "state" VARCHAR,
  "header_content" VARCHAR,
  "content" VARCHAR,
  "footer_content" VARCHAR,
  "category_tags" VARCHAR,
  "social_media_tagline" VARCHAR,
  "ispinned" VARCHAR,
  "isarchived" VARCHAR,
  "contact1" VARCHAR,
  "contact2" VARCHAR,
  "contact3" VARCHAR,
  "contact4" VARCHAR,
  "contact5" VARCHAR,
  "date_expire" VARCHAR,
  "date_entered" VARCHAR,
  "entered_by" VARCHAR,
  "date_last_modified" VARCHAR,
  "last_modified_by" VARCHAR,
  "category_tag1" VARCHAR,
  "category_tag2" VARCHAR,
  "category_tag3" VARCHAR,
  "category_tag4" VARCHAR,
  "category_tag5" VARCHAR,
  "content2" VARCHAR,
  "content3" VARCHAR,
  "content4" VARCHAR,
  "content5" VARCHAR
);