home / data

sample-data_metadata

1 row where Location_Country = "United States", Location_text = "United States | Harrisburg | Oregon | Linn County" and Mime_type = "image/gif | image/jpg | image/jp2"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Last_updated_in_api (date)

Link rowid ▼ Date Digitized Id IIIF_manifest Language Last_updated_in_api Location_text City_text County_text State_text Country_text Mime_type Notes Number_of_files Online_format Original_format Part_of Preview_url Repository Title Type_of_resource Location_Short_name Location_Full_name Location_Osm_url Location_Latitude Location_Longitude Location_County Location_State_district Location_State Location_Country Location_secondary_text
10 10 1908-04 True http://www.loc.gov/item/sanborn07375_005/ http://www.loc.gov/item/sanborn07375_005/manifest.json English 2024-01-03T22:41:07.167Z United States | Harrisburg | Oregon | Linn County Harrisburg Linn County Oregon United States image/gif | image/jpg | image/jp2 Apr 1908. | 4 sheet(s). 4.0 Image Map American Memory | Sanborn Maps | Geography And Map Division https://tile.loc.gov/storage-services/service/gmd/gmd429m/g4294m/g4294hm/g4294hm_g073751908/07375_1908-0001.gif | https://tile.loc.gov/storage-services/service/gmd/gmd429m/g4294m/g4294hm/g4294hm_g073751908/07375_1908-0001.gif#h=150&w=126 | https://tile.loc.gov/image-services/iiif/service:gmd:gmd429m:g4294m:g4294hm:g4294hm_g073751908:07375_1908-0001/full/pct:12.5/0/default.jpg#h=956&w=806 | https://tile.loc.gov/image-services/iiif/service:gmd:gmd429m:g4294m:g4294hm:g4294hm_g073751908:07375_1908-0001/full/pct:25/0/default.jpg#h=1912&w=1612 Library of Congress Geography and Map Division Washington, D.C. 20540-4650 USA Sanborn Fire Insurance Map from Harrisburg, Linn County, Oregon. Cartographic Harrisburg Harrisburg, Linn County, Oregon, United States https://www.openstreetmap.org/relation/186530 44.2740124 -123.170648 Linn County Unknown Oregon United States  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [sample-data_metadata] (
   [Date] TEXT,
   [Digitized] TEXT,
   [Id] TEXT,
   [IIIF_manifest] TEXT,
   [Language] TEXT,
   [Last_updated_in_api] TEXT,
   [Location_text] TEXT,
   [City_text] TEXT,
   [County_text] TEXT,
   [State_text] TEXT,
   [Country_text] TEXT,
   [Mime_type] TEXT,
   [Notes] TEXT,
   [Number_of_files] TEXT,
   [Online_format] TEXT,
   [Original_format] TEXT,
   [Part_of] TEXT,
   [Preview_url] TEXT,
   [Repository] TEXT,
   [Title] TEXT,
   [Type_of_resource] TEXT,
   [Location_Short_name] TEXT,
   [Location_Full_name] TEXT,
   [Location_Osm_url] TEXT,
   [Location_Latitude] TEXT,
   [Location_Longitude] TEXT,
   [Location_County] TEXT,
   [Location_State_district] TEXT,
   [Location_State] TEXT,
   [Location_Country] TEXT,
   [Location_secondary_text] TEXT
);
Powered by Datasette · Queries took 3796.6ms