files

Table actions

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

3 rows where "createdAt" is on date 2020-03-19 and ext = "pdf"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Link project ext createdAt name updatedAt size etag
UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE=,README.pdf COVID_HospitalBeds_CountyDemographics_NursingHomes UHJvamVjdDo3NDQ0YTU5NC01MzlkLTQyZjktYTI3My0yMWE2MWRmMjE5MDE= pdf 2020-03-19T01:03:11.524000+00:00 README.pdf 2020-03-19T01:03:11.524000+00:00    
UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ=,README.pdf COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= pdf 2020-03-19T01:40:59.554000+00:00 README.pdf 2020-03-19T01:40:59.554000+00:00    
UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ=,vulnerability_index_paper.pdf COVID_CDC_SVI UHJvamVjdDpiMGVmMjIyYS0zNzE4LTRhZTgtYWJjNC1lNzA3M2M0MDFmZGQ= pdf 2020-03-19T01:38:24.633000+00:00 vulnerability_index_paper.pdf 2020-03-19T01:38:24.633000+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])
);