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

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

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
);