MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

33 rows where Portfolio = 1828

View and edit SQL

Suggested facets: Artist Role, Artist Display Name, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Medium, Dimensions

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
281002 1982.1174.152 0 0 410298 Drawings and Prints 11 Print 731 A Messieur les membres du Consielle de discipline du 1er batalion, from La Boîte aux Lettres, published in Le Charivari, August 28, 1837, plate 1         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 August 28, 1837 1837 1837 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281032 1982.1174.153 0 0 410328 Drawings and Prints 11 Print 731 Vous avez le secret de ma vie....., from La Boîte aux Lettres, published in Le Charivari, December 5, 1842, plate 2         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 December 5, 1842 1842 1842 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281038 1982.1174.154 0 0 410334 Drawings and Prints 11 Print 731 La Lettre qu'on lit, from La Boîte aux Lettres, published in Le Charivari, October 4, 1837, plate 3         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Caboche, Gregoire et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Caboche, Gregoire et Cie 41021 French 2 1804 1866 October 4, 1837 1837 1837 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281040 1982.1174.38 0 0 410336 Drawings and Prints 11 Print 731 J'au ta lettre cherie, ô mon Ernest, je la presse sur mon coeur et la couvre de mes baisers......., from La Boîte aux Lettres, published in Le Charivari, February 24, 1838, plate 4         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 February 24, 1838 1838 1838 Lithograph; fourth state of four (Armelhault & Bocher) 43562 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281041 1982.1174.155 0 0 410337 Drawings and Prints 11 Print 731 Je prends la plume d'une main tremblante......, from La Boîte aux Lettres, published in Le Charivari, July 29, 1837, plate 5         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 July 29, 1837 1837 1837 Lithograph; third state of three (Armelhault & Bocher) 43493 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281042 1982.1174.156 0 0 410338 Drawings and Prints 11 Print 731 ..........Peut aitre en-aige trop dit mon excusse est dans mon coeur votre chagement de conduite [...], from La Boîte aux Lettres, published in Le Charivari, August 25, 1837, plate 6         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 August 25, 1837 1837 1837 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281043 1982.1174.157 0 0 410339 Drawings and Prints 11 Print 731 Chère ange, from La Boîte aux Lettres, published in Le Charivari, plate 7         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 ca. 1837 1832 1842 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281044 1982.1174.180 0 0 410340 Drawings and Prints 11 Print 731 Viens me prendre ce soir, from La Boîte aux Lettres, plate 8         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 ca. 1837 1832 1842 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281045 1982.1174.158 0 0 410341 Drawings and Prints 11 Print 731 ....................Ma siere épouse je vous fait bien me complimens à vous inqi que ma petit je fait bien de complimens à mesoncles [...], from La Boîte aux Lettres, published in Le Charivari, September 11, 1837, plate 9         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 September 11, 1837 1837 1837 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281047 1982.1174.159 0 0 410343 Drawings and Prints 11 Print 731 Adolphe! Adolphe!, from La Boîte aux Lettres, published in Le Charivari, July 26, 1837, plate 10         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 July 26, 1837 1837 1837 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281050 1982.1174.160 0 0 410346 Drawings and Prints 11 Print 731 Congé en Partie Double, from La Boîte aux Lettres, published in Le Charivari, November 4, 1837, plate 11         La Boîte aux Lettres 1828 Artist|Printer 715   Paul Gavarni [Chevalier]|Aubert et Cie French, Paris 1804–1866 Paris   Gavarni, Paul|Aubert et Cie 38642 French|French 21 1804 |1829 1866 |1929 November 4, 1837 1837 1837 Lithograph 14948 Sheet: 13 x 9 13/16 in. (33 x 25 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281052 1982.1174.161 0 0 410348 Drawings and Prints 11 Print 731 Je soussingné, Roi des Batignolles, prince de Clichy, Duc d'Anières et de St Ouen, Vicomte de la Garenne [...], from La Boîte aux Lettres, published in Le Charivari, March 20, 1838, plate 12         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 March 20, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281055 1982.1174.39 0 0 410351 Drawings and Prints 11 Print 731 Ah! prenez pitié de l'état cruel où me laisse mon attachement pour vous!, from La Boîte aux Lettres, published in Le Charivari, November 7, 1837, plate 14         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 November 7, 1837 1837 1837 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281056 1982.1174.40 0 0 410352 Drawings and Prints 11 Print 731 Je souhaite le bonjour à Mr Emile et lui fais savoir que je ne puis monter à cheval de cette samaine pour des raisons à moi connu, from La Boîte aux Lettres, published in Le Charivari, August 1, 1838, plate 15         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 August 1, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281058 1982.1174.41 0 0 410354 Drawings and Prints 11 Print 731 Mon Cher Camille, from La Boîte aux Lettres, published in Le Charivari, September 1, 1838, plate 16         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 September 1, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281059 1982.1174.42 0 0 410355 Drawings and Prints 11 Print 731 Cher, il va chasser demain [...], from La Boîte aux Lettres, published in Le Charivari, August 20, 1838, plate 17         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 August 20, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281061 1982.1174.43 0 0 410357 Drawings and Prints 11 Print 731 Ma santee est autant bonne qu'ils est possible quels soit étant separée de tout ce que j'ai de plus chere [...], from La Boîte aux Lettres, published in Le Charivari, September 15, 1838, plate 18         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 September 15, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281062 1982.1174.45 0 0 410358 Drawings and Prints 11 Print 731 Recevez en attendent ce leger acte de ma reconnaissance....., from La Boîte aux Lettres, published in Le Charivari, October 3, 1838, plate 20         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 October 3, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281065 1982.1174.44 0 0 410361 Drawings and Prints 11 Print 731 A Madami Hippolite, from La Boîte aux Lettres, published in Le Charivari, September 26, 1838, plate 19         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 September 26, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281068 1982.1174.46 0 0 410364 Drawings and Prints 11 Print 731 Je fini en mouillant de mes larmes la main et la plume qui ont tracé ces caractère[...], from La Boîte aux Lettres, published in Le Charivari, October 13, 1838, plate 21         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 October 13, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281078 1982.1174.47 0 0 410374 Drawings and Prints 11 Print 731 Monsieur le sargent major, from La Boîte aux Lettres, published in Le Charivari, October 27, 1838, plate 22         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 October 27, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281082 1982.1174.48 0 0 410378 Drawings and Prints 11 Print 731 Mon ami, from La Boîte aux Lettres, published in Le Charivari, November 8, 1838, plate 23         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 November 8, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281085 1982.1174.49 0 0 410381 Drawings and Prints 11 Print 731 Mon cher Amis, from La Boîte aux Lettres, published in Le Charivari, November 14, 1838, plate 24         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 November 14, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281095 1982.1174.50 0 0 410391 Drawings and Prints 11 Print 731 Madame Larabe, from La Boîte aux Lettres, published in Le Charivari, November 16, 1838, plate 25         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 November 16, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281098 1982.1174.52 0 0 410394 Drawings and Prints 11 Print 731 Ton concierge m'a remis ce billet, from La Boîte aux Lettres, published in Le Charivari, December 1, 1838, plate 27         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 December 1, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281113 1982.1174.51 0 0 410409 Drawings and Prints 11 Print 731 A S. Ex. Mons Le Ministre des finances, from La Boîte aux Lettres, published in Le Charivari, November 21, 1838, plate 26         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 November 21, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281114 1982.1174.53 0 0 410410 Drawings and Prints 11 Print 731 Je pense que vous ne me refuserez pas de vous trouver à lendroit indiqué, je vous en conjure ne manquez pas, car je serais las plus malheureuse des fammes, from La Boîte aux Lettres, published in Le Charivari, December 13, 1838, plate 28         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 December 13, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281115 1982.1174.55 0 0 410411 Drawings and Prints 11 Print 731 A son Excellence Le Ministre des finances, from La Boîte aux Lettres, published in Le Charivari, December 30, 1838, plate 30         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 December 30, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281116 1982.1174.54 0 0 410412 Drawings and Prints 11 Print 731 Ma siere amie [...], from La Boîte aux Lettres, published in Le Charivari, December 22, 1838, plate 29         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 December 22, 1838 1838 1838 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281117 1982.1174.56 0 0 410413 Drawings and Prints 11 Print 731 ......Oui, mon cher Oncle [...], from La Boîte aux Lettres, plate 31         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 ca. 1839 1834 1844 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281118 1982.1174.57 0 0 410414 Drawings and Prints 11 Print 731 Adieu, mon bon ange, from La Boîte aux Lettres, published in Le Charivari, January 4, 1839, plate 32         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 January 4, 1839 1839 1839 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281119 1982.1174.58 0 0 410415 Drawings and Prints 11 Print 731 Il y a maintenant entre nous, ô mon bien aimé, un mystère que nul regard humain ne doit pénétrer, from La Boîte aux Lettres, published in Le Charivari, February 2, 1839, plate 33         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 February 2, 1839 1839 1839 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
281120 1982.1174.59 0 0 410416 Drawings and Prints 11 Print 731 Adieu ami, à demain [...], from La Boîte aux Lettres, published in Le Charivari, February 6, 1939         La Boîte aux Lettres 1828 Printer|Artist 717   Aubert et Cie|Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Aubert et Cie|Gavarni, Paul 40942 French|French 21 1829 |1804 1929 |1866 February 6, 1839 1839 1839 Lithograph 14948 Sheet: 13 x 9 5/8 in. (33 x 24.5 cm) Gift of Michael G. Wilson, 1982                       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 158.433ms · Data license: CC0 · Data source: metmuseum/openaccess