MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Nationality = 532

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio 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 Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
165777 33.65.20 0 1 267991 Photographs 13 Photograph 997 Wharf opposite Richmond           Artist|Artist|Former Attribution 767 Formerly attributed to John Reekie|Alexander Gardner|Mathew B. Brady American, active 1860s|American, Glasgow, Scotland 1821–1882 Washington, D.C.|American, born Ireland, 1823?–1896 New York   Reekie, John|Gardner, Alexander|Brady, Mathew B. 14820 American|American, Scottish 532 1860 |1821 |1823 1869 |1882 |1896 ca. 1865 1863 1867 Albumen silver print from glass negative 26061   Harris Brisbane Dick Fund, 1933                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
165807 33.65.228 0 1 268021 Photographs 13 Photograph 997 Ruins in Carey Street, Richmond           Artist|Artist|Former Attribution 767 Formerly attributed to Thomas C. Roche|Alexander Gardner|Mathew B. Brady American, 1826–1895|American, Glasgow, Scotland 1821–1882 Washington, D.C.|American, born Ireland, 1823?–1896 New York   Roche, Thomas C.|Gardner, Alexander|Brady, Mathew B. 14821 American|American, Scottish 532 1826 |1821 |1823 1895 |1882 |1896 1865 1865 1865 Albumen silver print from glass negative 26061 Image: 18.6 x 23.8 cm (7 5/16 x 9 3/8 in.) Harris Brisbane Dick Fund, 1933                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
165993 33.65.396 0 1 268207 Photographs 13 Photograph 997 Falmouth, Virginia. Abandoned Camp           Artist|Artist|Former Attribution 767 Formerly attributed to Andrew Joseph Russell|Alexander Gardner|Mathew B. Brady American, 1830–1902|American, Glasgow, Scotland 1821–1882 Washington, D.C.|American, born Ireland, 1823?–1896 New York   Russell, Andrew Joseph|Gardner, Alexander|Brady, Mathew B. 14827 American|American, Scottish 532 1830 |1821 |1823 1902 |1882 |1896 1862 1862 1862 Albumen silver print from glass negative 26061   Harris Brisbane Dick Fund, 1933                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
180310 33.65.482 0 0 283899 Photographs 13 Photograph 997 Wharf opposite Richmond           Artist|Artist|Former Attribution 767 Possibly by|Possibly by|Formerly attributed to John Reekie|Alexander Gardner|Mathew B. Brady American, active 1860s|American, Glasgow, Scotland 1821–1882 Washington, D.C.|American, born Ireland, 1823?–1896 New York   Reekie, John|Gardner, Alexander|Brady, Mathew B. 14820 American|American, Scottish 532 1860 |1821 |1823 1869 |1882 |1896 1865 (?) 1865 1865 Albumen silver print from glass negative 26061 16.5 x 21.3 cm (6 1/2 x 8 3/8 in. ) Harris Brisbane Dick Fund, 1933                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
224482 21.36.165 0 0 352075 Drawings and Prints 11 Book 97 The Sketch Book           Author|Illustrator 1235   Washington Irving|William Hart American, New York 1783–1859 Sleepy Hollow, New York|American, Paisley, Scotland 1823–1894 Mount Vernon, New York   Irving, Washington|Hart, William 26296 American|American, Scottish 532 1783 |1823 1859 |1894 1848 1848 1848 Illustrations: lithography 28996 9 5/8 x 7 1/16 in. (24.5 x 18 cm) Museum Accession, transferred from the Library, 1921                       Books 442   Metropolitan Museum of Art, New York, NY 1
240207 54.90.711 0 0 368297 Drawings and Prints 11 Print 731 These are to certify that_____is pursuant to LAW, nominated and appointed one of the Firemen of the City of New York           Artist|Artist 13 After Peter Maverick|Archibald Robertson American, New York 1780–1831 New York|American, Moneymusk, Scotland 1765–1835 New York   Maverick, Peter|Robertson, Archibald 33280 American|American, Scottish 532 1780 |1765 1831 |1835 March 1807 1807 1807 Engraving 7208 image: 13 1/2 x 9 7/8 in. (34.3 x 25.1 cm) sheet: 15 1/4 x 10 5/8 in. (38.7 x 27 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
240209 54.90.1158 0 0 368299 Drawings and Prints 11 Print 731 This is to Certify that___was admitted and regularly enrolled in the first company of New-York Grenadiers           Artist|Artist 13 After Peter Maverick|Archibald Robertson American, New York 1780–1831 New York|American, Moneymusk, Scotland 1765–1835 New York   Maverick, Peter|Robertson, Archibald 33280 American|American, Scottish 532 1780 |1765 1831 |1835 1800–1831 1800 1831 Etching 26137 sheet: 14 x 11 5/8 in. (35.5 x 29.6 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
256627 21.36.59(15) 0 0 385304 Drawings and Prints 11 Print 731 Italia           Publisher|Artist 740 Published by New York Etching Club|Walter Shirlaw American, Paisley, Scotland 1838–1909 Madrid   New York Etching Club|Shirlaw, Walter 36969 American|American, Scottish 532 1838 1909 1883 1883 1883 Etching 26137 plate: 3 x 5 1/2 in. (7.6 x 14 cm) sheet: 11 3/4 x 8 7/8 in. (29.8 x 22.6 cm) Harris Brisbane Dick Fund, transferred from the Library, 1921                       Prints 13   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 139.568ms · Data license: CC0 · Data source: metmuseum/openaccess