Data source: Big Local News · About: big-local-datasette

1 row where "createdAt" is on date 2020-03-27

View and edit SQL

Suggested facets: updatedAt (date)

createdAt (date)

  • 2020-03-27 · 1
id ▼ contact createdAt description isOpen name updatedAt readme_markdown
UHJvamVjdDo4NTBjOWJmYy03YzAyLTRkNDgtYjYzMS04OThhODFmZjQxNDQ= biglocalnews@stanford.edu 2020-03-27T19:23:57.548111+00:00 The full text of tweets and selected Twitter metadata from the Twitter accounts of state and local public officials, as well as education and health agencies, since the beginning of the COVID-19 pandemic. We begin with state governors with more data to come. Where possible, please cite Big Local News as collecting and disseminating this information. We ask because it helps us show the impact we can have and that makes it easier to create ongoing support for Big Local News. 1 COVID_twitter_data 2020-06-13T16:36:52.113000+00:00  

Advanced export

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

CSV options:

CREATE TABLE [projects] (
   [contact] TEXT,
   [createdAt] TEXT,
   [description] TEXT,
   [id] TEXT PRIMARY KEY,
   [isOpen] INTEGER,
   [name] TEXT,
   [updatedAt] TEXT
, [readme_markdown] TEXT);