MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Artist Alpha Sort = 1390

View and edit SQL

Suggested facets: Title, Object Date, Object Begin Date, Object End Date, Credit Line

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
9945 26.47 0 1 10759 American Paintings and Sculpture 2 Painting, miniature 73 George Catlin           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1835 1835 1835 Watercolor on ivory 620 2 3/16 x 1 13/16 in. (5.6 x 4.6 cm) Rogers Fund, 1926                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
9946 1988.280 0 1 10760 American Paintings and Sculpture 2 Painting, miniature 73 Kate Roselie Dodge           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1854 1854 1854 Watercolor on ivory 620 Sight: 3 x 2 1/2 in. (7.6 x 6.4 cm) Morris K. Jesup Fund, 1988                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
9947 46.14 0 1 10761 American Paintings and Sculpture 2 Painting, miniature 73 Mrs. George P. Burne           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1852 1852 1852 Watercolor on ivory 620 Sight: 2 7/16 x 1 15/16 in. (6.2 x 4.9 cm) Rogers Fund, 1946                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
11973 1981.447.1 0 1 13024 American Paintings and Sculpture 2 Painting, miniature 73 Portrait of a Gentleman           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1841 1841 1841 Watercolor on ivory 620 Sight: 2 7/8 x 2 3/8 in. (7.3 x 6 cm) Gift of Isabella Reeder Jones, in memory of her husband, Eugene Jones II, 1981                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13875 2006.235.53 0 1 15042 American Paintings and Sculpture 2 Painting, miniature 73 James O. Owens           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1832 1832 1832 Watercolor on ivory 620 2 5/16 x 1 7/8 in. (5.9 x 4.8 cm) Dale T. Johnson Fund, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13876 2006.235.241 0 1 15043 American Paintings and Sculpture 2 Painting, miniature 73 Reverend William Lupton Johnson           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1834 1834 1834 Watercolor on ivory 620 1 5/8 x 1 5/16 in. (4.2 x 3.3 cm) Gift of Gloria Manney, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13877 2006.235.51 0 1 15044 American Paintings and Sculpture 2 Painting, miniature 73 Edward S. Dodge           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1835 1835 1835 Watercolor on ivory 620 3 3/4 x 3 1/4 in. (9.5 x 8.2 cm) Dale T. Johnson Fund, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13878 2006.235.49 0 1 15045 American Paintings and Sculpture 2 Painting, miniature 73 A. L. Clements           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1838 1838 1838 Watercolor on ivory 620 2 3/8 x 1 7/8 in. (6 x 4.8 cm) Dale T. Johnson Fund, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13879 2006.235.50 0 1 15046 American Paintings and Sculpture 2 Painting, miniature 73 Mrs. A. L. Clements (Mary Louisa Wells)           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1838 1838 1838 Watercolor on ivory 620 2 1/2 x 2 in. (6.4 x 5 cm) Dale T. Johnson Fund, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13880 2006.235.54 0 1 15047 American Paintings and Sculpture 2 Painting, miniature 73 Portrait of a Gentleman           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 ca. 1833 1828 1838 Watercolor on ivory 620 2 5/8 x 2 1/8 in. (6.7 x 5.5 cm) Gift of Gloria Manney, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13881 2006.235.56 0 1 15048 American Paintings and Sculpture 2 Painting, miniature 73 Portrait of a Lady           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 ca. 1835 1832 1838 Watercolor on ivory 620 2 13/16 x 2 1/4 in. (7.1 x 5.6 cm) Dale T. Johnson Fund, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13882 2006.235.55 0 1 15049 American Paintings and Sculpture 2 Painting, miniature 73 Portrait of a Lady           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 ca. 1835 1830 1840 Watercolor on ivory 620 2 13/16 x 2 1/4 in. (7.2 x 5.8 cm) Gift of Gloria Manney, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13883 2006.235.52 0 1 15050 American Paintings and Sculpture 2 Painting, miniature 73 Mrs. Annie C. Hyde           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1863 1863 1863 Watercolor on ivory 620 3 9/16 x 2 7/8 in. (9.2 x 7.3 cm) Gift of Gloria Manney, 2006                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
16214 2005.29 0 1 17901 American Paintings and Sculpture 2 Painting, miniature 73 Mrs. John Wood Dodge (Mary Louise Dodge)           Artist 2   John Wood Dodge 1807–1893   Dodge, John Wood 1390 American 1 1807 1893 1836 1836 1836 Watercolor on ivory 620 4 3/4 x 3 5/8 in. (12.1 x 9.2 cm) Purchase, Martha J. Fleischman Gift, in honor of Lillian Brenwasser, 2005 Made in 1       United States 3             Paintings 11   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 122.483ms · Data license: CC0 · Data source: metmuseum/openaccess