|
|
| (2 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | | + | https://diagrams.bitplan.com/render/svg/0x28a15f08.svg |
| − | <uml format='svg'>
| + | http://diagrams.bitplan.com/render/png/0xe26be126.png |
| − | title
| |
| − | ConfIDent Entities
| |
| − | 2020-10-20
| |
| − | [[https://projects.tib.eu/en/confident/ © 2019-2020 ConfIDent project]]
| |
| − | see also [[http://ptp.bitplan.com/settings Proceedings Title Parser]]
| |
| − | | |
| − | end title
| |
| − | package DataDonations {
| |
| − | class Event << Entity >> {
| |
| − | acronym : TEXT
| |
| − | eventId : TEXT <<PK>>
| |
| − | lookupAcronym : TEXT
| |
| − | source : TEXT
| |
| − | title : TEXT
| |
| − | url : TEXT
| |
| − | year : INTEGER
| |
| − | }
| |
| − | Note top of Event_or
| |
| − | [[https://rq.bitplan.com/index.php/Open_Research_Entities Open Research Entities]]
| |
| − | 8825 instances
| |
| − | End note
| |
| − | class Event_or << Entity >> {
| |
| − | [[https://www.openresearch.org/wiki/Property:Acronym{acronym of the conference, word or name formed from the initial components of a longer name or phrase, usually using individual initial letters} acronym]] : TEXT
| |
| − | [[https://www.openresearch.org/wiki/Property:Has_location_city{city of where the conferece occurs} city]] : TEXT
| |
| − | [[https://www.openresearch.org/wiki/Property:Has_location_country{country of where the conference occurs} country]] : TEXT
| |
| − | [[https://www.openresearch.org/wiki/Property:Creation_date{SMW automatic property tracking creation of a page} creation_date]] : TIMESTAMP
| |
| − | [[https://www.openresearch.org/wiki/Property:End_date{end date of the event} end_date]] : TIMESTAMP
| |
| − | event : TEXT
| |
| − | [[https://www.openresearch.org/wiki/Property:Homepage{the homepage of an event} homepage]] : TEXT
| |
| − | [[https://www.openresearch.org/wiki/Property:Modification_date{SMW automatic property tracking modification of a page} modification_date]] : TIMESTAMP
| |
| − | [[https://www.openresearch.org/wiki/Property:Event_in_series{foreign key - pagename of the Event series this event belongs to} series]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Open_Research_Entities#Openresearch::source{source of the data here: or} source]] : TEXT
| |
| − | [[https://www.openresearch.org/wiki/Property:Start_date{start date of the event} start_date]] : TIMESTAMP
| |
| − | [[https://www.openresearch.org/wiki/Property:Title{title of the conference, long form} title]] : TEXT
| |
| − | }
| |
| − | Note top of Event_CEURWS
| |
| − | [[https://rq.bitplan.com/index.php/PTP PTP]]
| |
| − | 2667 instances
| |
| − | End note
| |
| − | class Event_CEURWS << Entity >> {
| |
| − | [[https://cr.bitplan.com/index.php/Concept:City{large permanent human settlement} city]] : TEXT
| |
| − | [[https://cr.bitplan.com/index.php/Concept:Country{distinct region in geography; a broad term that can include political divisions or regions associated with distinct political characteristics} country]] : TEXT
| |
| − | daterange : TEXT
| |
| − | delimiter : TEXT
| |
| − | enum : TEXT
| |
| − | eventType : TEXT
| |
| − | extract : TEXT
| |
| − | field : TEXT
| |
| − | location : TEXT
| |
| − | month : TEXT
| |
| − | ordinal : INTEGER
| |
| − | organization : TEXT
| |
| − | prefix : TEXT
| |
| − | [[https://cr.bitplan.com/index.php/Concept:State{territorial and constitutional community forming part of a federal union} province]] : TEXT
| |
| − | publish : TEXT
| |
| − | scope : TEXT
| |
| − | syntax : TEXT
| |
| − | topic : TEXT
| |
| − | volume : INTEGER
| |
| − | }
| |
| − | Note top of Event_crossref
| |
| − | [[https://rq.bitplan.com/index.php/Crossref Crossref]]
| |
| − | 46099 instances
| |
| − | End note
| |
| − | class Event_crossref << Entity >> {
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::conference_acronym{acronym of the conference, word or name formed from the initial components of a longer name or phrase, usually using individual initial letters} acronym]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::doi{DOI as main id} doi]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::conference_enddate{the end date of the event} endDate]] : DATE
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::conference_location{location of the conference, city and country} location]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::month{the month in which the event took place} month]] : INTEGER
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::conference_name{The title or name of the academic event} name]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::conference_number{numer that is connected to the date, might be congruent to the event year} number]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::conference_sponsor{sponsors of the conferences, financial support to enable the event} sponsor]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::conference_startdate{the start date of the event} startDate]] : DATE
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::title{titel of proceedings from the conferene} title]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Crossref#CrossRef::year{the year in which the event took place} year]] : INTEGER
| |
| − | }
| |
| − | Note top of Event_confref
| |
| − | [[https://rq.bitplan.com/index.php/Confref Confref]]
| |
| − | 37945 instances
| |
| − | End note
| |
| − | class Event_confref << Entity >> {
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::acronym{acrynom of the conference} acronym]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::city{city where the conference occurs} city]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::country{country where the conference occurs} country]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::endDate endDate]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::startDate{start date of the conference} startDate]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::submissionExtended{submission extendet, information about canceled submission dates} submissionExtended]] : BOOLEAN
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::title{title of the conference - short form with eventyear} title]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/Confref#ConfRef::year{year of when the conference occurs} year]] : INTEGER
| |
| − | }
| |
| − | Note top of Event_dblp
| |
| − | [[https://rq.bitplan.com/index.php/DBLP DBLP]]
| |
| − | 43976 instances
| |
| − | End note
| |
| − | class Event_dblp << Entity >> {
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::booktitle{acronym without yearnumber} booktitle]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::editor{editor, author} editor]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::editorOrcid{editor on orcid} editorOrcid]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::ee{position of the electronic edition} ee]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::isbn{isbn of conference} isbn]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::mdate{date} mdate]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::publisher{publisher of proceedings} publisher]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::series{Series of proceedings} series]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::source{source of the data here: dblp} source]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/DBLP#dblp::title{title of the conference, despription with city, date} title]] : TEXT
| |
| − | volume : TEXT
| |
| − | }
| |
| − | Note top of Event_gnd
| |
| − | [[https://rq.bitplan.com/index.php/GND GND]]
| |
| − | 14281 instances
| |
| − | End note
| |
| − | class Event_gnd << Entity >> {
| |
| − | [[https://d-nb.info/standards/elementset/gnd#geographicAreaCode{geographic area code, taken fromthe list of area codes used in the Integrated Authority File} areaCode]] : TEXT
| |
| − | [[https://d-nb.info/standards/elementset/gnd#dateOfConferenceOrEvent{german date or daterange, mostly year only} date]] : TEXT
| |
| − | endDate : DATE
| |
| − | [[https://d-nb.info/standards/elementset/gnd#homepage{homepage of the event} homepage]] : TEXT
| |
| − | [[https://d-nb.info/standards/elementset/gnd#placeOfConferenceOrEvent{Place where the conference or event takes place, information about geographic, country, coordinates & type} place]] : TEXT
| |
| − | startDate : DATE
| |
| − | [[https://d-nb.info/standards/elementset/gnd#preferredNameForTheConferenceOrEvent{titel of the conference or the event} title]] : TEXT
| |
| − | [[https://d-nb.info/standards/elementset/gnd#topic{topic of the event} topic]] : TEXT
| |
| − | [[https://d-nb.info/standards/elementset/gnd#variantNameForTheConferenceOrEvent{multiple entries possible for different variant names e.g. languages, shortNames} variant]] : TEXT
| |
| − | }
| |
| − | Note top of Event_wikicfp
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP WikiCFP]]
| |
| − | 81966 instances
| |
| − | End note
| |
| − | class Event_wikicfp << Entity >> {
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::Notification_Due{Notification of Organizers, date organizers notify authors} Notification_Due]] : DATE
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::Submission_Deadlin{Paper submission deadline, date until when athor has so submit papers to organizers} Submission_Deadline]] : DATE
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::deleted{True if an event has been deleted e.g. http://www.wikicfp.com/cfp/servlet/event.showcfp?eventid=15} deleted]] : BOOLEAN
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::endDate{end date of the event} endDate]] : DATE
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::eventType{seems to be always "Conference" even for Workshops etc.} eventType]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::locality{location of the event} locality]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::source{source of the data here: WikiCFP} source]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::startDate{start date of the event} startDate]] : DATE
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::title{title of the conference, sometimes the short version} title]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::url{id of link to wikicfp page of this event} url]] : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::wikiCFPId{id used by wikiCFP: a running integer number started from 1 and at 112778 as of 2020-09-04} wikiCFPId]] : INTEGER
| |
| − | [[https://rq.bitplan.com/index.php/WikiCFP#WikiCFP::year{the year that the event occured in} year]] : INTEGER
| |
| − | }
| |
| − | Note top of Event_wikidata
| |
| − | [[https://rq.bitplan.com/index.php/PTP PTP]]
| |
| − | 15951 instances
| |
| − | End note
| |
| − | class Event_wikidata << Entity >> {
| |
| − | [[https://cr.bitplan.com/index.php/Concept:City{large permanent human settlement} city]] : TEXT
| |
| − | [[https://cr.bitplan.com/index.php/Concept:Country{distinct region in geography; a broad term that can include political divisions or regions associated with distinct political characteristics} country]] : TEXT
| |
| − | daterange : TEXT
| |
| − | delimiter : TEXT
| |
| − | description : TEXT
| |
| − | enum : TEXT
| |
| − | eventType : TEXT
| |
| − | extract : TEXT
| |
| − | field : TEXT
| |
| − | [[https://rq.bitplan.com/index.php/PTP#PTP::frequency{repetition of the event is how often?} frequency]] : TEXT
| |
| − | location : TEXT
| |
| − | month : TEXT
| |
| − | ordinal : INTEGER
| |
| − | organization : TEXT
| |
| − | prefix : TEXT
| |
| − | [[https://cr.bitplan.com/index.php/Concept:State{territorial and constitutional community forming part of a federal union} province]] : TEXT
| |
| − | publish : TEXT
| |
| − | scope : TEXT
| |
| − | syntax : TEXT
| |
| − | topic : TEXT
| |
| − | }
| |
| − | Event <|-- Event_or
| |
| − | Event <|-- Event_CEURWS
| |
| − | Event <|-- Event_crossref
| |
| − | Event <|-- Event_confref
| |
| − | Event <|-- Event_dblp
| |
| − | Event <|-- Event_gnd
| |
| − | Event <|-- Event_wikicfp
| |
| − | Event <|-- Event_wikidata
| |
| − | }
| |
| − | | |
| − | ' BITPlan Corporate identity skin params
| |
| − | ' Copyright (c) 2015 BITPlan GmbH
| |
| − | ' see http://wiki.bitplan.com/PlantUmlSkinParams#BITPlanCI
| |
| − | ' skinparams generated by com.bitplan.restmodelmanager
| |
| − | skinparam note {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam component {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam package {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam usecase {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam activity {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam classAttribute {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam interface {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam class {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | skinparam object {
| |
| − | BackGroundColor #FFFFFF
| |
| − | FontSize 12
| |
| − | ArrowColor #FF8000
| |
| − | BorderColor #FF8000
| |
| − | FontColor black
| |
| − | FontName Technical
| |
| − | }
| |
| − | hide Circle
| |
| − | ' end of skinparams '
| |
| − | </uml>
| |
| | | | |
| | = Generalized View = | | = Generalized View = |
https://diagrams.bitplan.com/render/svg/0x28a15f08.svg
Generalized View
drop view if exists event;
create view event as
select eventId,title,url,lookupAcronym,acronym,source,year from event_CEURWS
union
select eventId,title,url,lookupAcronym,acronym,source,year from event_crossref
union
select eventId,title,url,lookupAcronym,acronym,source,year from event_confref
union
select eventId,title,url,lookupAcronym,acronym,source,year from event_dblp
union
select eventId,title,url,lookupAcronym,acronym,source,year from event_gnd
union
select eventId,title,url,lookupAcronym,acronym,source,year from event_or
union
select eventId,title,url,lookupAcronym,acronym,source,year from event_wikicfp
union
select eventId,title,url,lookupAcronym,acronym,source,year from event_wikidata;
select count(*) from event;
select count(*),lookupAcronym
from event
group by lookupAcronym
having count(*)>2
order by 1 desc;
236886
List of Data Donations
Queries
Count of Events grouped by source
query
select
source,count(*) as count
from event
group by source
union
select
"TOTAL",count(*) as count
from event
order by count
result
| source |
count
|
| CEUR-WS |
2656
|
| or |
8824
|
| wikidata |
15951
|
| confref |
37945
|
| dblp |
43976
|
| crossref |
46099
|
| wikicfp |
81966
|
| TOTAL |
237417
|
Crossref number usage
query
select count(*) as count,cast(number as integer) as enum,number from event_crossref
where number is not null
group by enum,number
having count>1
order by enum
result
| count |
enum |
number
|
| 5 |
0 |
.
|
| 40 |
0 |
0
|
| 3 |
0 |
??
|
| 13 |
0 |
I
|
| 11 |
0 |
II
|
| 9 |
0 |
III
|
| 9 |
0 |
IV
|
| 4 |
0 |
IX
|
| 2 |
0 |
V
|
| 5 |
0 |
VI
|
| 4 |
0 |
VII
|
| 4 |
0 |
VIII
|
| 5 |
0 |
X
|
| 2 |
0 |
XIII
|
| 4 |
0 |
none
|
| 843 |
1 |
1
|
| 2 |
1 |
1st
|
| 705 |
2 |
2
|
| 2 |
2 |
2 & 3
|
| 3 |
2 |
2nd
|
| 555 |
3 |
3
|
| 2 |
3 |
3nd
|
| 449 |
4 |
4
|
| 400 |
5 |
5
|
| 360 |
6 |
6
|
| 307 |
7 |
7
|
| 2 |
7 |
7th
|
| 290 |
8 |
8
|
| 2 |
9 |
09
|
| 250 |
9 |
9
|
| 248 |
10 |
10
|
| 190 |
11 |
11
|
| 166 |
12 |
12
|
| 145 |
13 |
13
|
| 124 |
14 |
14
|
| 109 |
15 |
15
|
| 108 |
16 |
16
|
| 106 |
17 |
17
|
| 95 |
18 |
18
|
| 85 |
19 |
19
|
| 72 |
20 |
20
|
| 71 |
21 |
21
|
| 65 |
22 |
22
|
| 60 |
23 |
23
|
| 52 |
24 |
24
|
| 38 |
25 |
25
|
| 35 |
26 |
26
|
| 34 |
27 |
27
|
| 35 |
28 |
28
|
| 27 |
29 |
29
|
| 22 |
30 |
30
|
| 23 |
31 |
31
|
| 22 |
32 |
32
|
| 22 |
33 |
33
|
| 15 |
34 |
34
|
| 14 |
35 |
35
|
| 18 |
36 |
36
|
| 12 |
37 |
37
|
| 15 |
38 |
38
|
| 10 |
39 |
39
|
| 13 |
40 |
40
|
| 5 |
41 |
41
|
| 9 |
42 |
42
|
| 8 |
43 |
43
|
| 7 |
44 |
44
|
| 9 |
45 |
45
|
| 10 |
46 |
46
|
| 8 |
47 |
47
|
| 5 |
48 |
48
|
| 6 |
49 |
49
|
| 6 |
50 |
50
|
| 3 |
51 |
51
|
| 4 |
52 |
52
|
| 2 |
53 |
53
|
| 2 |
69 |
69
|
| 2 |
71 |
71
|
| 2 |
72 |
72
|
| 2 |
74 |
74
|
| 2 |
1952 |
1952
|
| 2 |
1967 |
1967
|
| 2 |
1970 |
1970
|
| 3 |
1971 |
1971
|
| 2 |
1973 |
1973
|
| 3 |
1975 |
1975
|
| 3 |
1976 |
1976
|
| 2 |
1977 |
1977
|
| 2 |
1978 |
1978
|
| 2 |
1979 |
1979
|
| 2 |
1980 |
1980
|
| 6 |
1982 |
1982
|
| 3 |
1983 |
1983
|
| 2 |
1984 |
1984
|
| 7 |
1985 |
1985
|
| 17 |
1986 |
1986
|
| 14 |
1987 |
1987
|
| 17 |
1988 |
1988
|
| 19 |
1989 |
1989
|
| 24 |
1990 |
1990
|
| 20 |
1991 |
1991
|
| 23 |
1992 |
1992
|
| 27 |
1993 |
1993
|
| 24 |
1994 |
1994
|
| 24 |
1995 |
1995
|
| 27 |
1996 |
1996
|
| 33 |
1997 |
1997
|
| 37 |
1998 |
1998
|
| 37 |
1999 |
1999
|
| 55 |
2000 |
2000
|
| 36 |
2001 |
2001
|
| 37 |
2002 |
2002
|
| 59 |
2003 |
2003
|
| 52 |
2004 |
2004
|
| 66 |
2005 |
2005
|
| 105 |
2006 |
2006
|
| 94 |
2007 |
2007
|
| 108 |
2008 |
2008
|
| 135 |
2009 |
2009
|
| 113 |
2010 |
2010
|
| 120 |
2011 |
2011
|
| 134 |
2012 |
2012
|
| 138 |
2013 |
2013
|
| 162 |
2014 |
2014
|
| 143 |
2015 |
2015
|
| 169 |
2016 |
2016
|
| 134 |
2017 |
2017
|
| 122 |
2018 |
2018
|
| 77 |
2019 |
2019
|
| 2 |
2020 |
2020
|
Crossref events with long numbers
query
select number,cast(number as integer) as enum,year,title
from event_crossref
where enum> 53 and enum<1952
result
| number |
enum |
year |
title
|
| 69 |
69 |
2014 |
ABM Proceedings
|
| 55 |
55 |
2018 |
ABM Proceedings
|
| 71 |
71 |
None |
Proceedings of the 71st International Symposium on Molecular Spectroscopy
|
| 74 |
74 |
None |
Proceedings of the 74th International Symposium on Molecular Spectroscopy
|
| 72 |
72 |
None |
Proceedings of the 72nd International Symposium on Molecular Spectroscopy
|
| 71 |
71 |
2016 |
Anais do Congresso Anual da ABM
|
| 72 |
72 |
2017 |
Anais do Congresso Anual da ABM
|
| 54 |
54 |
2017 |
Anais do Seminário de Laminação e Conformação
|
| 69 |
69 |
None |
Proceedings of the 69th International Symposium on Molecular Spectroscopy
|
| 70 |
70 |
None |
Proceedings of the 70th International Symposium on Molecular Spectroscopy
|
| 206 |
206 |
2006 |
Proceedings of the 2006 International Conference on Privacy, Security and Trust Bridge the Gap Between PST Technologies and Business Services - PST '06
|
| 76 |
76 |
2019 |
ITAA Annual Conference Proceedings
|
| 74 |
74 |
2019 |
ABM Proceedings
|
| 101 |
101 |
2014 |
ROSCon Hong Kong
|
| 103 |
103 |
2019 |
ROSCon France
|
| 73 |
73 |
None |
Proceedings of the 73rd International Symposium on Molecular Spectroscopy
|
WikiCfP year distribution
query
select year,count(*) as count
from event_wikicfp
group by year
order by year
result
| year |
count
|
| None |
8235
|
| 35 |
1
|
| 1920 |
1
|
| 2000 |
20
|
| 2001 |
5
|
| 2002 |
1
|
| 2004 |
1
|
| 2005 |
2
|
| 2007 |
462
|
| 2008 |
2177
|
| 2009 |
2541
|
| 2010 |
4069
|
| 2011 |
5363
|
| 2012 |
5298
|
| 2013 |
5153
|
| 2014 |
5742
|
| 2015 |
5721
|
| 2016 |
6346
|
| 2017 |
7355
|
| 2018 |
8207
|
| 2019 |
8006
|
| 2020 |
6237
|
| 2021 |
1014
|
| 2022 |
2
|
| 2024 |
1
|
| 2025 |
1
|
| 2026 |
3
|
| 2081 |
1
|
| 2091 |
1
|
wikidata enums and ordinals
query
select count(*) as count,enum,ordinal
from event_wikidata
where enum is not null
group by enum,ordinal
union
select count(*) as count,'total',''
from event_wikidata
where enum is not null
order by 1 desc limit 20
result
| count |
enum |
ordinal
|
| 6668 |
total |
|
| 343 |
2nd |
2
|
| 276 |
3rd |
3
|
| 265 |
4th |
4
|
| 261 |
First |
1
|
| 248 |
5th |
5
|
| 230 |
1st |
1
|
| 206 |
Second |
2
|
| 180 |
Third |
3
|
| 175 |
6th |
6
|
| 173 |
1 |
1
|
| 168 |
2 |
2
|
| 156 |
7th |
7
|
| 151 |
8th |
8
|
| 134 |
9th |
9
|
| 124 |
Fourth |
4
|
| 122 |
10th |
10
|
| 110 |
11th |
11
|
| 101 |
15th |
15
|
| 101 |
Fifth |
5
|
Event View Schema
query
pragma table_info('event');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
eventId |
TEXT |
0 |
None |
0
|
| 1 |
title |
TEXT |
0 |
None |
0
|
| 2 |
url |
TEXT |
0 |
None |
0
|
| 3 |
lookupAcronym |
TEXT |
0 |
None |
0
|
| 4 |
acronym |
TEXT |
0 |
None |
0
|
| 5 |
source |
TEXT |
0 |
None |
0
|
Event_CEURWS Schema
query
pragma table_info('event_CEURWS');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
acronym |
TEXT |
0 |
None |
0
|
| 1 |
country |
TEXT |
0 |
None |
0
|
| 2 |
enum |
TEXT |
0 |
None |
0
|
| 3 |
eventType |
TEXT |
0 |
None |
0
|
| 4 |
lookupAcronym |
TEXT |
0 |
None |
0
|
| 5 |
scope |
TEXT |
0 |
None |
0
|
| 6 |
topic |
TEXT |
0 |
None |
0
|
| 7 |
title |
TEXT |
0 |
None |
0
|
| 8 |
source |
TEXT |
0 |
None |
0
|
| 9 |
eventId |
TEXT |
0 |
None |
1
|
| 10 |
url |
TEXT |
0 |
None |
0
|
| 11 |
city |
TEXT |
0 |
None |
0
|
| 12 |
prefix |
TEXT |
0 |
None |
0
|
| 13 |
province |
TEXT |
0 |
None |
0
|
| 14 |
location |
TEXT |
0 |
None |
0
|
| 15 |
daterange |
TEXT |
0 |
None |
0
|
| 16 |
extract |
TEXT |
0 |
None |
0
|
Event_confref Schema
query
pragma table_info('event_confref');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
acronym |
TEXT |
0 |
None |
0
|
| 1 |
city |
TEXT |
0 |
None |
0
|
| 2 |
country |
TEXT |
0 |
None |
0
|
| 3 |
eventId |
TEXT |
0 |
None |
1
|
| 4 |
year |
INTEGER |
0 |
None |
0
|
| 5 |
startDate |
TEXT |
0 |
None |
0
|
| 6 |
endDate |
TEXT |
0 |
None |
0
|
| 7 |
submissionExtended |
BOOLEAN |
0 |
None |
0
|
| 8 |
title |
TEXT |
0 |
None |
0
|
| 9 |
lookupAcronym |
TEXT |
0 |
None |
0
|
| 10 |
source |
TEXT |
0 |
None |
0
|
| 11 |
url |
TEXT |
0 |
None |
0
|
Event_dblp Schema
query
pragma table_info('event_dblp');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
acronym |
TEXT |
0 |
None |
0
|
| 1 |
editor |
TEXT |
0 |
None |
0
|
| 2 |
title |
TEXT |
0 |
None |
0
|
| 3 |
booktitle |
TEXT |
0 |
None |
0
|
| 4 |
year |
TEXT |
0 |
None |
0
|
| 5 |
publisher |
TEXT |
0 |
None |
0
|
| 6 |
isbn |
TEXT |
0 |
None |
0
|
| 7 |
series |
TEXT |
0 |
None |
0
|
| 8 |
volume |
TEXT |
0 |
None |
0
|
| 9 |
ee |
TEXT |
0 |
None |
0
|
| 10 |
url |
TEXT |
0 |
None |
0
|
| 11 |
eventId |
TEXT |
0 |
None |
1
|
| 12 |
mdate |
TEXT |
0 |
None |
0
|
| 13 |
lookupAcronym |
TEXT |
0 |
None |
0
|
| 14 |
source |
TEXT |
0 |
None |
0
|
| 15 |
editorOrcid |
TEXT |
0 |
None |
0
|
Event_crossref Schema
query
pragma table_info('event_crossref');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
name |
TEXT |
0 |
None |
0
|
| 1 |
location |
TEXT |
0 |
None |
0
|
| 2 |
source |
TEXT |
0 |
None |
0
|
| 3 |
title |
TEXT |
0 |
None |
0
|
| 4 |
eventId |
TEXT |
0 |
None |
1
|
| 5 |
url |
TEXT |
0 |
None |
0
|
| 6 |
acronym |
TEXT |
0 |
None |
0
|
| 7 |
sponsor |
TEXT |
0 |
None |
0
|
| 8 |
number |
TEXT |
0 |
None |
0
|
| 9 |
startDate |
DATE |
0 |
None |
0
|
| 10 |
year |
INTEGER |
0 |
None |
0
|
| 11 |
month |
INTEGER |
0 |
None |
0
|
| 12 |
endDate |
DATE |
0 |
None |
0
|
| 13 |
lookupAcronym |
TEXT |
0 |
None |
0
|
Event_or Schema
query
pragma table_info('event_or');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
homepage |
TEXT |
0 |
None |
0
|
| 1 |
acronym |
TEXT |
0 |
None |
0
|
| 2 |
city |
TEXT |
0 |
None |
0
|
| 3 |
event |
TEXT |
0 |
None |
0
|
| 4 |
series |
TEXT |
0 |
None |
0
|
| 5 |
title |
TEXT |
0 |
None |
0
|
| 6 |
start_date |
TIMESTAMP |
0 |
None |
0
|
| 7 |
end_date |
TIMESTAMP |
0 |
None |
0
|
| 8 |
creation_date |
TIMESTAMP |
0 |
None |
0
|
| 9 |
modification_date |
TIMESTAMP |
0 |
None |
0
|
| 10 |
eventId |
TEXT |
0 |
None |
1
|
| 11 |
url |
TEXT |
0 |
None |
0
|
| 12 |
lookupAcronym |
TEXT |
0 |
None |
0
|
| 13 |
source |
TEXT |
0 |
None |
0
|
| 14 |
country |
TEXT |
0 |
None |
0
|
Event_wikicfp Schema
query
pragma table_info('event_wikicfp');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
Notification_Due |
DATE |
0 |
None |
0
|
| 1 |
Submission_Deadline |
DATE |
0 |
None |
0
|
| 2 |
acronym |
TEXT |
0 |
None |
0
|
| 3 |
deleted |
BOOLEAN |
0 |
None |
0
|
| 4 |
endDate |
DATE |
0 |
None |
0
|
| 5 |
eventId |
TEXT |
0 |
None |
1
|
| 6 |
eventType |
TEXT |
0 |
None |
0
|
| 7 |
locality |
TEXT |
0 |
None |
0
|
| 8 |
lookupAcronym |
TEXT |
0 |
None |
0
|
| 9 |
startDate |
DATE |
0 |
None |
0
|
| 10 |
title |
TEXT |
0 |
None |
0
|
| 11 |
wikiCFPId |
INTEGER |
0 |
None |
0
|
| 12 |
source |
TEXT |
0 |
None |
0
|
| 13 |
url |
TEXT |
0 |
None |
0
|
Event_wikidata Schema
query
pragma table_info('event_wikidata');
result
| cid |
name |
type |
notnull |
dflt_value |
pk
|
| 0 |
acronym |
TEXT |
0 |
None |
0
|
| 1 |
description |
TEXT |
0 |
None |
0
|
| 2 |
eventType |
TEXT |
0 |
None |
0
|
| 3 |
location |
TEXT |
0 |
None |
0
|
| 4 |
lookupAcronym |
TEXT |
0 |
None |
0
|
| 5 |
scope |
TEXT |
0 |
None |
0
|
| 6 |
topic |
TEXT |
0 |
None |
0
|
| 7 |
title |
TEXT |
0 |
None |
0
|
| 8 |
source |
TEXT |
0 |
None |
0
|
| 9 |
eventId |
TEXT |
0 |
None |
1
|
| 10 |
url |
TEXT |
0 |
None |
0
|
| 11 |
enum |
TEXT |
0 |
None |
0
|
| 12 |
country |
TEXT |
0 |
None |
0
|
| 13 |
daterange |
TEXT |
0 |
None |
0
|
| 14 |
month |
TEXT |
0 |
None |
0
|
| 15 |
prefix |
TEXT |
0 |
None |
0
|
| 16 |
frequency |
TEXT |
0 |
None |
0
|
| 17 |
extract |
TEXT |
0 |
None |
0
|
| 18 |
year |
TEXT |
0 |
None |
0
|
| 19 |
city |
TEXT |
0 |
None |
0
|
