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

31 rows

View and edit SQL

Link rowid ▼ code display_order name
1 ! 0 ON HOLDSHELF
2 # 1 SearchOH/OL RECEIVED
3 $ 2 LOST AND PAID
4 % 3 SearchOH/OL RETURNED
5 & 4 SearchOH/OHIOLINK REQUEST
6 ( 5 SearchOH/OL PAGED
7 ) 6 SearchOH/OL CANCEL'D
8 + 7 RENEWAL PENDING
9 - 8 CHECK SHELVES
10 = 9 RENEWAL DENIED
11 @ 10 SearchOH/OL OFFSITE
12 _ 11 SearchOH/OL RE-REQUEST
13 b 12 AT BINDERY
14 d 13 ON ORDER
15 e 14 EXCUSED LOSS
16 f 15 DISCARD TO FRIENDS
17 g 16 LONG INTRANSIT
18 i 17 MISSING IN INVENTORY
19 l 18 LOST IN SYMPHONY
20 m 19 MISSING
21 n 20 BILLED
22 o 21 LIBRARY USE ONLY
23 p 22 IN PROCESSING
24 r 23 IN REPAIR
25 s 24 ON SEARCH
26 t 25 IN TRANSIT
27 u 26 ORDER PENDING
28 v 27 ONLINE
29 w 28 WITHDRAWN
30 y 29 UNAVAILABLE
31 z 30 CLMS RETD

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE item_status_property_myuser (
	code TEXT, 
	display_order INTEGER, 
	name TEXT
);