Conference Corpus Query Event_crossref Schema

# cid name type notnull dflt_value pk
1 0 sponsor TEXT 0 0
2 1 acronym TEXT 0 0
3 2 name TEXT 0 0
4 3 location TEXT 0 0
5 4 source TEXT 0 0
6 5 title TEXT 0 0
7 6 ordinal INTEGER 0 0
8 7 eventId TEXT 0 0
9 8 doi TEXT 0 0
10 9 lookupAcronym TEXT 0 0
11 10 url TEXT 0 0
12 11 city TEXT 0 0
13 12 cityWikidataid TEXT 0 0
14 13 region TEXT 0 0
15 14 regionIso TEXT 0 0
16 15 regionWikidataid TEXT 0 0
17 16 country TEXT 0 0
18 17 countryIso TEXT 0 0
19 18 countryWikidataid TEXT 0 0
20 19 startDate DATE 0 0
21 20 year INTEGER 0 0
22 21 month INTEGER 0 0
23 22 endDate DATE 0 0
24 23 number TEXT 0 0
25 24 theme TEXT 0 0