MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

25 rows where Portfolio = 601

View and edit SQL

Suggested facets: Title, Object Date, Object Begin Date, Object End Date, Medium

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
233371 20.81.3.103 0 0 361122 Drawings and Prints 11 Print 731 Ciuis Coloniensis Uxor (Wife of a Citizen of Cologne)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; second state of three 29764   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233372 20.81.3.104 0 0 361123 Drawings and Prints 11 Print 731 Mulier Coloniensis (Woman of Cologne)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of two 29408   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233373 20.81.3.105 0 0 361124 Drawings and Prints 11 Print 731 Mulier Coloniensis (Woman of Cologne)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of two 29408   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233374 20.81.3.106 0 0 361125 Drawings and Prints 11 Print 731 Mulier Coloniensis bonae qualitatis (A woman of Cologne of good quality)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1642 1642 1642 Etching; first state of three 30755   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233375 20.81.3.107 0 0 361126 Drawings and Prints 11 Print 731 Mulier Generosa Coloniensis (A Lady of Cologne)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of three 30755   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233376 20.81.3.108 0 0 361127 Drawings and Prints 11 Print 731 Ancilla Coloniensis expatians (A Woman of Cologne in Her Best Attire)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching and engraving; first state of two 32458   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233377 20.81.3.109 0 0 361128 Drawings and Prints 11 Print 731 Ancilla Coloniensis expatians (A Woman of Cologne in Her Best Attire)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching and engraving; first state of two 32458   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233379 20.81.3.110 0 0 361130 Drawings and Prints 11 Print 731 Ancilla Coloniensis (Serving Maid of Cologne)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching and engraving; first state of two 32458   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233380 20.81.3.111 0 0 361131 Drawings and Prints 11 Print 731 Civis Coloniensis Filia (Daughter of a Citizen of Cologne)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of three 30755   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233381 20.81.3.112 0 0 361132 Drawings and Prints 11 Print 731 Mulier ex inferiori Palatinatu (A Woman of the Lower Palatinate)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; second state of four 29292   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233382 20.81.3.113 0 0 361133 Drawings and Prints 11 Print 731 Mulier Franconiensis (A Woman of Franconia)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of two 29408   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233383 20.81.3.114 0 0 361134 Drawings and Prints 11 Print 731 Matrona Francofurtensis (Matron from Frankfurt)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of two 29408   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233384 20.81.3.115 0 0 361135 Drawings and Prints 11 Print 731 Mulier Norimbergiensis Uxor (Married woman of Nuremberg)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; second state of two 29783   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233386 20.81.3.117 0 0 361137 Drawings and Prints 11 Print 731 Mulier Austriae superioris (A woman of Upper Austria)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; second state of two 29783   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233393 20.81.3.123 0 0 361144 Drawings and Prints 11 Print 731 Mulier Moguntiana (Woman of Mainz)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching 26137   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233396 20.81.3.126 0 0 361147 Drawings and Prints 11 Print 731 Mercatoris Francofurtensis Uxor (Wife of a Frankfurt merchant)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of two 29408   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233420 20.81.3.148 0 0 361171 Drawings and Prints 11 Print 731 Mulier Danica (Danish Woman)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of three 30755   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233431 20.81.3.158 0 0 361182 Drawings and Prints 11 Print 731 Mulier Religiosa Antuerpiensis (Religious Woman of Antwerp)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of two 29408   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233717 20.81.3.81 0 0 361468 Drawings and Prints 11 Print 731 Opificis Parisiensis Uxor (Parisian artificer's wife)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of four 30631   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233718 20.81.3.82 0 0 361469 Drawings and Prints 11 Print 731 Rustica Gallica (Country woman of France)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; third state of four 33318   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233722 20.81.3.86 0 0 361473 Drawings and Prints 11 Print 731 Mercantoris Hollandici Uxor (Merchant's Wife of Holland)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1644 1644 1644 Etching, second state of three 36441   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233727 20.81.3.90 0 0 361478 Drawings and Prints 11 Print 731 Mulier Generosa Brabantica (Gentlewoman of Brabant)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; second state of four 29292   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233728 20.81.3.91 0 0 361479 Drawings and Prints 11 Print 731 Mulier Belgica in Vestitu Domestic (Belgian Woman in Domestic Dress)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of three 30755   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233729 20.81.3.92 0 0 361480 Drawings and Prints 11 Print 731 Mulier Antuerpiensis (Woman of Antwerp)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of three 30755   Rogers Fund, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
233730 20.81.3.93 0 0 361481 Drawings and Prints 11 Print 731 Mulier Antuerpiensis, bonae qualitatis (A woman of Antwerp of good quality)         Theatrum Mulierum 601 Artist 2   Wenceslaus Hollar Bohemian, Prague 1607–1677 London   Hollar, Wenceslaus 12447 Bohemian 69 1607 1677 1643 1643 1643 Etching; first state of three 30755   Rogers Fund, 1920                       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 104.104ms · Data license: CC0 · Data source: metmuseum/openaccess