MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query

Artist Alpha Sort

id, value

Many rows

Artist Nationality

id, value

3,806 rows

Artist Role

id, value

6,090 rows

City

id, value

2,569 rows

Classification

id, value

1,201 rows

Country

id, value

1,079 rows

County

id, value

1,139 rows

Culture

id, value

7,132 rows

Department

id, value

20 rows

Dynasty

id, value

348 rows

Excavation

id, value

339 rows

Geography Type

id, value

128 rows

Locale

id, value

831 rows

Locus

id, value

1,322 rows

Medium

id, value

Many rows

MetObjects

Object Number, Is Highlight, Is Public Domain, Object ID, Department, Object Name, Title, Culture, Period...

Many rows

Object Name

id, value

27,381 rows

Portfolio

id, value

3,044 rows

Region

id, value

788 rows

Reign

id, value

366 rows

Repository

id, value

1 row

River

id, value

229 rows

State

id, value

103 rows

Subregion

id, value

370 rows

Artist Alpha Sort_value_fts (hidden)

value

Many rows

Artist Alpha Sort_value_fts_docsize (hidden)

docid, size

59,247 rows

Artist Alpha Sort_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

4 rows

Artist Alpha Sort_value_fts_segments (hidden)

blockid, block

405 rows

Artist Alpha Sort_value_fts_stat (hidden)

id, value

1 row

Artist Nationality_value_fts (hidden)

value

Many rows

Artist Nationality_value_fts_docsize (hidden)

docid, size

3,806 rows

Artist Nationality_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Artist Nationality_value_fts_segments (hidden)

blockid, block

14 rows

Artist Nationality_value_fts_stat (hidden)

id, value

1 row

Artist Role_value_fts (hidden)

value

Many rows

Artist Role_value_fts_docsize (hidden)

docid, size

6,090 rows

Artist Role_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Artist Role_value_fts_segments (hidden)

blockid, block

17 rows

Artist Role_value_fts_stat (hidden)

id, value

1 row

City_value_fts (hidden)

value

Many rows

City_value_fts_docsize (hidden)

docid, size

2,569 rows

City_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

City_value_fts_segments (hidden)

blockid, block

8 rows

City_value_fts_stat (hidden)

id, value

1 row

Classification_value_fts (hidden)

value

1,201 rows

Classification_value_fts_docsize (hidden)

docid, size

1,201 rows

Classification_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Classification_value_fts_segments (hidden)

blockid, block

4 rows

Classification_value_fts_stat (hidden)

id, value

1 row

Country_value_fts (hidden)

value

1,079 rows

Country_value_fts_docsize (hidden)

docid, size

1,079 rows

Country_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Country_value_fts_segments (hidden)

blockid, block

4 rows

Country_value_fts_stat (hidden)

id, value

1 row

County_value_fts (hidden)

value

1,139 rows

County_value_fts_docsize (hidden)

docid, size

1,139 rows

County_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

County_value_fts_segments (hidden)

blockid, block

4 rows

County_value_fts_stat (hidden)

id, value

1 row

Culture_value_fts (hidden)

value

Many rows

Culture_value_fts_docsize (hidden)

docid, size

7,132 rows

Culture_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Culture_value_fts_segments (hidden)

blockid, block

27 rows

Culture_value_fts_stat (hidden)

id, value

1 row

Department_value_fts (hidden)

value

20 rows

Department_value_fts_docsize (hidden)

docid, size

20 rows

Department_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Department_value_fts_segments (hidden)

blockid, block

0 rows

Department_value_fts_stat (hidden)

id, value

1 row

Dynasty_value_fts (hidden)

value

348 rows

Dynasty_value_fts_docsize (hidden)

docid, size

348 rows

Dynasty_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Dynasty_value_fts_segments (hidden)

blockid, block

2 rows

Dynasty_value_fts_stat (hidden)

id, value

1 row

Excavation_value_fts (hidden)

value

339 rows

Excavation_value_fts_docsize (hidden)

docid, size

339 rows

Excavation_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Excavation_value_fts_segments (hidden)

blockid, block

2 rows

Excavation_value_fts_stat (hidden)

id, value

1 row

Geography Type_value_fts (hidden)

value

128 rows

Geography Type_value_fts_docsize (hidden)

docid, size

128 rows

Geography Type_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Geography Type_value_fts_segments (hidden)

blockid, block

0 rows

Geography Type_value_fts_stat (hidden)

id, value

1 row

Locale_value_fts (hidden)

value

831 rows

Locale_value_fts_docsize (hidden)

docid, size

831 rows

Locale_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Locale_value_fts_segments (hidden)

blockid, block

5 rows

Locale_value_fts_stat (hidden)

id, value

1 row

Locus_value_fts (hidden)

value

1,322 rows

Locus_value_fts_docsize (hidden)

docid, size

1,322 rows

Locus_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Locus_value_fts_segments (hidden)

blockid, block

6 rows

Locus_value_fts_stat (hidden)

id, value

1 row

Medium_value_fts (hidden)

value

Many rows

Medium_value_fts_docsize (hidden)

docid, size

63,888 rows

Medium_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

2 rows

Medium_value_fts_segments (hidden)

blockid, block

341 rows

Medium_value_fts_stat (hidden)

id, value

1 row

MetObjects_fts (hidden)

Title, Artist Display Name, Medium, Credit Line

Many rows

MetObjects_fts_docsize (hidden)

docid, size

Many rows

MetObjects_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

15 rows

MetObjects_fts_segments (hidden)

blockid, block

Many rows

MetObjects_fts_stat (hidden)

id, value

1 row

Object Name_value_fts (hidden)

value

Many rows

Object Name_value_fts_docsize (hidden)

docid, size

27,381 rows

Object Name_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Object Name_value_fts_segments (hidden)

blockid, block

97 rows

Object Name_value_fts_stat (hidden)

id, value

1 row

Portfolio_value_fts (hidden)

value

Many rows

Portfolio_value_fts_docsize (hidden)

docid, size

3,044 rows

Portfolio_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Portfolio_value_fts_segments (hidden)

blockid, block

27 rows

Portfolio_value_fts_stat (hidden)

id, value

1 row

Region_value_fts (hidden)

value

788 rows

Region_value_fts_docsize (hidden)

docid, size

788 rows

Region_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Region_value_fts_segments (hidden)

blockid, block

3 rows

Region_value_fts_stat (hidden)

id, value

1 row

Reign_value_fts (hidden)

value

366 rows

Reign_value_fts_docsize (hidden)

docid, size

366 rows

Reign_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Reign_value_fts_segments (hidden)

blockid, block

2 rows

Reign_value_fts_stat (hidden)

id, value

1 row

Repository_value_fts (hidden)

value

1 row

Repository_value_fts_docsize (hidden)

docid, size

1 row

Repository_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Repository_value_fts_segments (hidden)

blockid, block

0 rows

Repository_value_fts_stat (hidden)

id, value

1 row

River_value_fts (hidden)

value

229 rows

River_value_fts_docsize (hidden)

docid, size

229 rows

River_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

River_value_fts_segments (hidden)

blockid, block

0 rows

River_value_fts_stat (hidden)

id, value

1 row

State_value_fts (hidden)

value

103 rows

State_value_fts_docsize (hidden)

docid, size

103 rows

State_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

State_value_fts_segments (hidden)

blockid, block

0 rows

State_value_fts_stat (hidden)

id, value

1 row

Subregion_value_fts (hidden)

value

370 rows

Subregion_value_fts_docsize (hidden)

docid, size

370 rows

Subregion_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Subregion_value_fts_segments (hidden)

blockid, block

2 rows

Subregion_value_fts_stat (hidden)

id, value

1 row

Powered by Datasette · Query took 461.148ms · Data license: CC0 · Data source: metmuseum/openaccess