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

115 rows

View and edit SQL

Link rowid ▼ code display_order itype_property_category_id physical_format_id target_audience_id name
1 105 54       Leased DVD
2 155 90       Reference Realia
3 154 89       Reference Print
4 152 88       Reference Poster/Print
5 151 87       Poster/Print
6 199 99       Cleanup
7 126 66       Web Document
8 127 67       Website
9 121 61       Downloadable Music
10 122 62       Downloadable Video
11 6 6       Leased Book
12 102 51       Bluray
13 123 63       Downloadable Book
14 110 55       MakerSpace Equipment
15 2 2   1   Juvenile Book
16 3 3   1   Juvenile Book (Branches)
17 4 4   1   Teen Book
18 5 5   1   Teen Book (Branches)
19 0 0   1   Book
20 1 1   1   Book (Branches)
21 111 56       Portable Technology Device
22 113 58       Laptop
23 104 53       Video Kit
24 103 52       Reference Video
25 82 42   38   LP Record
26 37 27       Newspaper
27 83 43       Reference LP Record
28 67 34       Reference Music Cassette
29 66 33       Juvenile Music on Cassette
30 65 32       Music on Cassette
31 62 31       Reference Book on Cassette
32 60 29       Book on Cassette
33 61 30       Juvenile Book on Cassette
34 94 48       Reference Playaway View
35 93 47       Playaway View
36 21 15   35   Large Print Book (Branches)
37 22 16   35   Juvenile Large Print Book
38 23 17   35   Juv Large Print Book (Branches)
39 24 18   35   Teen Large Print Book
40 26 19   35   Reference Large Print Book
41 27 20   35   Reference Juv Large Print Book
42 92 46   36   Teen Playaway
43 91 45   36   Juvenile Playaway
44 15 10       Braille
45 16 11       Reference Braille
46 17 12       Government Document
47 18 13       Reference Government Document
48 46 28       Rare Book
49 32 23   33   Teen Magazine
50 31 22   33   Juvenile Magazine
51 101 50   34   DVD/Videocassette
52 100 49   34   New Release DVDs
53 20 14   35   Large Print Book
54 90 44   36   Playaway
55 71 36   29   Juvenile Book on CD
56 72 37   29   Teen Book on CD
57 73 38   29   Reference Book on CD
58 70 35   29   Book on CD
59 10 7   1   Reference Book
60 78 40   32   Juvenile Music on CD
61 77 39   32   Music on CD
62 138 75       Unknown Graphic
63 139 76       Reference Graphic
64 136 73       Ephemeral
65 137 74       Globe
66 131 69       Architectural Drawing
67 130 68       16mm Film
68 143 80       Teen Kit
69 144 81       Map
70 141 78       Kit
71 202 102       OhioLINK Periodical
72 203 103       OhioLINK Sound Record
73 204 104       OhioLINK Comp. software
74 205 105       OhioLINK Audio-Visual
75 200 100       OhioLINK Book
76 145 82       Microfiche
77 146 83       Microfilm
78 147 84       Photograph
79 148 85       Picture
80 149 86       Reference Picture
81 140 77       InterLibrary Loan Item
82 142 79       Juvenile Kit
83 201 101       OhioLINK Curr Cent
84 206 106       OhioLINK Microform
85 207 107       OhioLINK Non-Circ
86 208 108       OhioLINK Media
87 209 109       OhioLINK Microforms
88 210 110       OhioLINK Circulating Periodical
89 230 111       OHPIR Requestable
90 232 113       OHPIR Non-Requestable
91 231 112       OHPIR Requestable Movie
92 233 114       OHPIR test
93 125 65   33   E-Magazine
94 158 92   37   Music Score (Branches)
95 157 91   37   Music Score
96 159 93   37   Juvenile Music Score
97 160 94   37   Juvenile Music Score (Branches)
98 161 95   37   Reference Music Score
99 162 96   37   Reference Juvenile Music Score
100 79 41   32   Reference Music on CD

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE itype_property_myuser (
	code INTEGER, 
	display_order INTEGER, 
	itype_property_category_id TEXT, 
	physical_format_id INTEGER, 
	target_audience_id TEXT, 
	name TEXT
);