Difference between revisions of "Project:Ecosystem/Facebook/Visualizations"

From Wikibase Personal data
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{SPARQL|label= Mickey Mouse's social network
 +
|state={{{state}}}
 +
|query=
 +
#defaultView:Graph
 +
SELECT ?node ?nodeLabel ?nodeImage ?childNode ?childNodeLabel ?childNodeImage ?rgb WHERE {
 +
  {
 +
    BIND(pdio:Q308 AS ?node)
 +
    ?node ?p ?i.
 +
    OPTIONAL { ?node pdiot:P47 ?nodeImage. }
 +
    ?childNode ?x ?p.
 +
    ?childNode rdf:type wikibase:Property.
 +
    FILTER(STRSTARTS(STR(?i), "https://wiki.personaldata.io/entity/Q"))
 +
    FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/P"))
 +
  }
 +
  UNION
 +
  {
 +
    BIND("EFFBD8" AS ?rgb)
 +
    pdio:Q308 ?p ?childNode.
 +
    OPTIONAL { ?childNode pdiot:P47 ?childNodeImage. }
 +
    ?node ?x ?p.
 +
    ?node rdf:type wikibase:Property.
 +
    FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/Q"))
 +
  }
 +
  OPTIONAL {
 +
    ?node pdiot:P47 ?nodeImage.
 +
    ?childNode pdiot:P47 ?childNodeImage.
 +
  }
 +
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
 +
}
 +
}}
 +
 
{{SPARQL|label=simple view of FB|state={{{state}}}|query={{SPARQLTableQuery|table=Q383}}}}
 
{{SPARQL|label=simple view of FB|state={{{state}}}|query={{SPARQLTableQuery|table=Q383}}}}
 
{{SPARQL|label=extended view of FB
 
{{SPARQL|label=extended view of FB
Line 15: Line 46:
 
}
 
}
 
}}
 
}}
 +
{{SPARQL|label=simple view of various Facebook tools, and how they exchange information|state={{{state}}}|query={{SPARQLTableQuery|table=Q383}}}}
 +
 +
{{SPARQL|label=extended view of various Facebook tools, and how they exchange information
 +
|state={{{state}}}
 +
|query=#defaultView:Graph
 +
SELECT ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
 +
{
 +
 
 +
  pdio:Q1044 pdiot:P129 ?origin.
 +
  pdio:Q1044 pdiot:P129 ?destination.
 +
  pdio:Q1044 pdiop:P130 ?association_statement.
 +
  ?association_statement pdiopq:P131 ?origin.
 +
  ?association_statement pdiopq:P132 ?destination.
 +
  ?association_statement pdiops:P130 ?edge.
 +
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 +
}
 +
}}
 +
{{SPARQL|label=how disinformation blends into our information ecosystem through Facebook|state={{{state}}}|query={{SPARQLTableQuery|table=Q366}}}}
 +
{{SPARQL|state={{{state}}}|label=summary of the Cambridge Analytica scandal|query={{SPARQLTableQuery|table=Q384}}}}

Latest revision as of 23:37, 26 January 2020

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
#defaultView:Graph
SELECT ?node ?nodeLabel ?nodeImage ?childNode ?childNodeLabel ?childNodeImage ?rgb WHERE {
  {
    BIND(pdio:Q308 AS ?node)
    ?node ?p ?i.
    OPTIONAL { ?node pdiot:P47 ?nodeImage. }
    ?childNode ?x ?p.
    ?childNode rdf:type wikibase:Property.
    FILTER(STRSTARTS(STR(?i), "https://wiki.personaldata.io/entity/Q"))
    FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/P"))
  }
  UNION
  {
    BIND("EFFBD8" AS ?rgb)
    pdio:Q308 ?p ?childNode.
    OPTIONAL { ?childNode pdiot:P47 ?childNodeImage. }
    ?node ?x ?p.
    ?node rdf:type wikibase:Property.
    FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/Q"))
  }
  OPTIONAL {
    ?node pdiot:P47 ?nodeImage.
    ?childNode pdiot:P47 ?childNodeImage.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Mickey Mouse's social network (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
   BIND(pdio:Q383 AS ?table).
   OPTIONAL {
     ?table pdiop:P26 ?domain_prop.
     ?domain_prop pdiops:P26 ?domain.
     ?domain_prop pdiopq:P27 ?domainLabel
   }.
   OPTIONAL {
     ?table pdiop:P26 ?range_prop.
     ?range_prop pdiops:P26 ?range.
     ?range_prop pdiopq:P27 ?rangeLabel
   }.
   {
     SELECT ?domain ?range WHERE {
          ?table pdiop:P25 ?relationshipStatement.
          ?relationshipStatement pdiopq:P24 ?domain.
          ?relationshipStatement pdiopq:P23 ?range.
       }
     
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P58 ?relationshipInStatement.
          ?relationshipInStatement pdiops:P58 ?range.
          ?relationshipInStatement pdiopq:P61 ?domain.
       }
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P59 ?relationshipOutStatement.
          ?relationshipOutStatement pdiops:P59 ?domain.
          ?relationshipOutStatement pdiopq:P60 ?range.
       }
   }.
}

simple view of FB (embedded)

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
#defaultView:Graph
SELECT ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
   
   pdio:Q1044 pdiot:P129 ?origin.
   pdio:Q1044 pdiot:P129 ?destination.
   pdio:Q1044 pdiop:P130 ?association_statement.
   ?association_statement pdiopq:P131 ?origin.
   ?association_statement pdiopq:P132 ?destination.
   ?association_statement pdiops:P130 ?edge.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

extended view of FB (embedded)

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
   BIND(pdio:Q383 AS ?table).
   OPTIONAL {
     ?table pdiop:P26 ?domain_prop.
     ?domain_prop pdiops:P26 ?domain.
     ?domain_prop pdiopq:P27 ?domainLabel
   }.
   OPTIONAL {
     ?table pdiop:P26 ?range_prop.
     ?range_prop pdiops:P26 ?range.
     ?range_prop pdiopq:P27 ?rangeLabel
   }.
   {
     SELECT ?domain ?range WHERE {
          ?table pdiop:P25 ?relationshipStatement.
          ?relationshipStatement pdiopq:P24 ?domain.
          ?relationshipStatement pdiopq:P23 ?range.
       }
     
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P58 ?relationshipInStatement.
          ?relationshipInStatement pdiops:P58 ?range.
          ?relationshipInStatement pdiopq:P61 ?domain.
       }
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P59 ?relationshipOutStatement.
          ?relationshipOutStatement pdiops:P59 ?domain.
          ?relationshipOutStatement pdiopq:P60 ?range.
       }
   }.
}

simple view of various Facebook tools, and how they exchange information (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
#defaultView:Graph
SELECT ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
   
   pdio:Q1044 pdiot:P129 ?origin.
   pdio:Q1044 pdiot:P129 ?destination.
   pdio:Q1044 pdiop:P130 ?association_statement.
   ?association_statement pdiopq:P131 ?origin.
   ?association_statement pdiopq:P132 ?destination.
   ?association_statement pdiops:P130 ?edge.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

extended view of various Facebook tools, and how they exchange information (embedded)

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
   BIND(pdio:Q366 AS ?table).
   OPTIONAL {
     ?table pdiop:P26 ?domain_prop.
     ?domain_prop pdiops:P26 ?domain.
     ?domain_prop pdiopq:P27 ?domainLabel
   }.
   OPTIONAL {
     ?table pdiop:P26 ?range_prop.
     ?range_prop pdiops:P26 ?range.
     ?range_prop pdiopq:P27 ?rangeLabel
   }.
   {
     SELECT ?domain ?range WHERE {
          ?table pdiop:P25 ?relationshipStatement.
          ?relationshipStatement pdiopq:P24 ?domain.
          ?relationshipStatement pdiopq:P23 ?range.
       }
     
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P58 ?relationshipInStatement.
          ?relationshipInStatement pdiops:P58 ?range.
          ?relationshipInStatement pdiopq:P61 ?domain.
       }
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P59 ?relationshipOutStatement.
          ?relationshipOutStatement pdiops:P59 ?domain.
          ?relationshipOutStatement pdiopq:P60 ?range.
       }
   }.
}

how disinformation blends into our information ecosystem through Facebook (embedded)

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
   BIND(pdio:Q384 AS ?table).
   OPTIONAL {
     ?table pdiop:P26 ?domain_prop.
     ?domain_prop pdiops:P26 ?domain.
     ?domain_prop pdiopq:P27 ?domainLabel
   }.
   OPTIONAL {
     ?table pdiop:P26 ?range_prop.
     ?range_prop pdiops:P26 ?range.
     ?range_prop pdiopq:P27 ?rangeLabel
   }.
   {
     SELECT ?domain ?range WHERE {
          ?table pdiop:P25 ?relationshipStatement.
          ?relationshipStatement pdiopq:P24 ?domain.
          ?relationshipStatement pdiopq:P23 ?range.
       }
     
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P58 ?relationshipInStatement.
          ?relationshipInStatement pdiops:P58 ?range.
          ?relationshipInStatement pdiopq:P61 ?domain.
       }
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          ?table pdiop:P59 ?relationshipOutStatement.
          ?relationshipOutStatement pdiops:P59 ?domain.
          ?relationshipOutStatement pdiopq:P60 ?range.
       }
   }.
}

summary of the Cambridge Analytica scandal (embedded)