files

Table actions

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

3 rows where ext = "xlsx"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: project, createdAt (date), updatedAt (date)

ext ✖

  • xlsx · 3 ✖
Link project ext createdAt name updatedAt size etag
UHJvamVjdDo5NTI5MzAwYy1jNmZiLTQ3ZDItYWI2ZC03MDMxYjFlMTNjNDk=,capitol_arrests_012220-010521.xlsx us_capitol_police_reports UHJvamVjdDo5NTI5MzAwYy1jNmZiLTQ3ZDItYWI2ZC03MDMxYjFlMTNjNDk= xlsx 2021-01-09T00:48:46.659000+00:00 capitol_arrests_012220-010521.xlsx 2021-01-09T00:48:46.659000+00:00    
UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI=,Kentucky_warn_orig_2017-2020.xlsx COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= xlsx 2020-04-22T06:49:16.117000+00:00 Kentucky_warn_orig_2017-2020.xlsx 2020-04-22T06:49:16.117000+00:00    
UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI=,kentucky_warn__orig_1998-2016.xlsx COVID_WARN_Notices UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= xlsx 2020-04-22T06:50:47.893000+00:00 kentucky_warn__orig_1998-2016.xlsx 2020-04-22T06:50:47.893000+00:00    

Advanced export

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

CSV options: 

CREATE TABLE "files" (
   [project] TEXT REFERENCES [projects]([id]),
   [ext] TEXT,
   [createdAt] TEXT,
   [name] TEXT,
   [updatedAt] TEXT,
   [size] INTEGER,
   [etag] TEXT,
   PRIMARY KEY ([project], [name])
);