MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Classification = 705

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Artist Role	Artist Prefix	Artist Display Name	Artist Display Bio	Artist Suffix	Artist Alpha Sort	Artist Nationality	Artist Begin Date	Artist End Date	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	City	Classification	Link Resource	Metadata Date	Repository
220164	220164	51.644.70	0	347695	Drawings and Prints 11	Album 1119	7 East 96 Street, Residence of Ogden Codman										n.d.	1800	1951			Gift of Estate of Ogden Codman, 1951		Albums\|Photographs 705	http://www.metmuseum.org/art/collection/search/347695	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
221769	221769	22.106.29	0	349327	Drawings and Prints 11	Album 1119	Epistole et Evangelii et Lectioni Volgari in Lingua Toscana	Publisher\|Editor 1633	Edited by	The Roxburghe Club\|Alfred W. Pollard	London\|British, 1859–1944		Roxburghe Club The\|Pollard, Alfred W. 24157	British\|British 9	1900 \|1859	1950 \|1944	1910	1910	1910	Photographic reproductions 34515		Transferred from the Library, 1922	London 14	Albums\|Photographs 705	http://www.metmuseum.org/art/collection/search/349327	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
230269	230269	1996.19	1	357955	Drawings and Prints 11	Album ; Photograph 13961	"Bronze Works" album of photographs	Artist 2		Tiffany Studios	1902–32	, New York	Tiffany Studios 547		1902	1932	ca. 1912	1907	1917	Photography 34987		Friends of the American Wing Fund; Edward Pearce Casey Fund, 1996		Albums\|Photographs 705	http://www.metmuseum.org/art/collection/search/357955	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
458091	458091	45.94	0	773678	Drawings and Prints 11	Album Photographs 27370	Photo Album with 36 Photogravures of the Coaching Club Tour, New York to Lakewood, January 19-21, 1903										1903	1903	1903	Photogravure 26078	11 9/16 × 14 3/4 × 1 3/8 in. (29.4 × 37.5 × 3.5 cm)	Gift of James Hazen Hyde, 1945		Albums\|Photographs 705	http://www.metmuseum.org/art/collection/search/773678	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
458093	458093	46.12.2	0	773680	Drawings and Prints 11	Album Photographs 27370	Photo Album with Images of the Coaching Club Tour, New York to Philadelphia, James H. Hyde & Alfred G. Vanderbilt, Sept. 10, 1901	Subject\|Subject 5106		James Hazen Hyde\|Alfred Gwynne Vanderbilt	American, 1877–1915		Hyde, James Hazen\|Gwynne Vanderbilt, Alfred 58772				1901	1901	1901	Gelatin Silver Print (?) 63724	14 1/2 × 17 15/16 × 2 3/16 in. (36.8 × 45.5 × 5.5 cm)	Gift of James Hazen Hyde, 1946		Albums\|Photographs 705	http://www.metmuseum.org/art/collection/search/773680	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");