Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/

28 rows

View and edit SQL

Link rowid ▼ code display_order is_public material_property_category_id physical_format_id name
1 - 0 1     Undefined
2 1 1 1     Downloadable Audiobook
3 2 2 1     Downloadable Book
4 3 3 1     Downloadable Music
5 4 4 1     Downloadable Video
6 5 5 1     Book on Cassette
7 6 6 1     Microform
8 7 7 1     Music Cassette
9 8 8 1     LP Record
10 9 9 1     2-D Graphic
11 a 10 1     Book
12 b 11 1     Government Document
13 c 12 1     Music Score
14 e 13 1     Map
15 g 14 1     DVD
16 h 15 1     VHS
17 i 16 1     Book on CD
18 j 17 1     Music CD
19 l 18 1     Large Print
20 m 19 1     CD-ROM
21 n 20 1     Newspaper
22 q 21 1     Playaway
23 s 22 1     Magazine
24 v 23 1     Web Document
25 w 24 1     Website
26 x 25 1     E-Magazine
27 y 26 1     E-Newspaper
28 z 27 1     E-Resource

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE material_property_myuser (
	code TEXT, 
	display_order INTEGER, 
	is_public BOOLEAN, 
	material_property_category_id TEXT, 
	physical_format_id TEXT, 
	name TEXT
);