User:Indrajitdas/Queries

From Wikidata
Jump to navigation Jump to search

Documenting Kolkata Heritage

[edit]
Grade I Heritages of Kolkata of which photos are not present in Wikimedia Commons
The following query uses these:
  • Properties: heritage designation (P1435)  View with Reasonator View with SQID, located in the administrative territorial entity (P131)  View with Reasonator View with SQID, image (P18)  View with Reasonator View with SQID
    # Grade I Heritages of Kolkata of which photos are not present in Wikimedia Commons
SELECT ?itemLabel ?WardNumberLabel ?WithImageLabel ?GradeLabel ?item WHERE {
  ?item wdt:P1435 wd:Q51368786;
    wdt:P131 ?WardNumber;
    wdt:P1435 ?Grade.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  OPTIONAL { ?item wdt:P18 ?WithImage. }
}
GROUP BY ?itemLabel ?WardNumberLabel ?WithImageLabel ?GradeLabel ?item
ORDER BY DESC (?WithImageLabel)
Try it!
Grade IIA Heritages of Kolkata of which photos are not present in Wikimedia Commons
The following query uses these:
  • Properties: heritage designation (P1435)  View with Reasonator View with SQID, located in the administrative territorial entity (P131)  View with Reasonator View with SQID, image (P18)  View with Reasonator View with SQID
    # Grade IIA Heritages of Kolkata of which photos are not present in Wikimedia Commons
SELECT ?itemLabel ?WardNumberLabel ?WithImageLabel ?GradeLabel ?item WHERE {
  ?item wdt:P1435 wd:Q51368804;
    wdt:P131 ?WardNumber;
    wdt:P1435 ?Grade.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  OPTIONAL { ?item wdt:P18 ?WithImage. }
}
GROUP BY ?itemLabel ?WardNumberLabel ?WithImageLabel ?GradeLabel ?item
ORDER BY DESC (?WithImageLabel)
Try it!
Grade IIB Heritages of Kolkata of which photos are not present in Wikimedia Commons
The following query uses these:
  • Properties: heritage designation (P1435)  View with Reasonator View with SQID, located in the administrative territorial entity (P131)  View with Reasonator View with SQID, image (P18)  View with Reasonator View with SQID
    # Grade IIB Heritages of Kolkata of which photos are not present in Wikimedia Commons
SELECT ?itemLabel ?WardNumberLabel ?WithImageLabel ?GradeLabel ?item WHERE {
  ?item wdt:P1435 wd:Q51368840;
    wdt:P131 ?WardNumber;
    wdt:P1435 ?Grade.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  OPTIONAL { ?item wdt:P18 ?WithImage. }
}
GROUP BY ?itemLabel ?WardNumberLabel ?WithImageLabel ?GradeLabel ?item
ORDER BY DESC (?WithImageLabel)
Try it!
List of Streets in Kolkata

List of Streets in Kolkata

List of Parks & Squares in Kolkata

List of Parks & Squares in Kolkata

List of Ponds in Kolkata

List of Ponds in Kolkata

List of Kolkata Corporation's Borough Offices(ward wise)

List of Kolkata Corporation's Borough Offices(ward wise)

District wise list of Schools in West Bengal

[edit]
District Wise List
List of Schools in Kolkata (2083)

List of Schools in Kolkata

List of Schools in Howrah (3078)

List of Schools in Howrah

List of Schools in Purulia (4109)

List of Schools in Purulia

List of Schools in Nadia (3940)

List of Schools in Nadia

List of Schools in Malda (3075)

List of Schools in Malda

List of Schools in Bankura (4865)

List of Schools in Bankura

**List of Schools in Cooch Behar (10)

List of Schools in Cooch Behar

**List of Schools in Birbhum (1)

List of Schools in Birbhum

**List of Schools in Darjeeling(13)

List of Schools in Darjeeling

List of Schools in Dakshin Dinajpur(2002)

List of Schools in Dakshin Dinajpur

List of Schools in Uttar Dinajpur (2801)

List of Schools in Uttar Dinajpur

List of Schools in Hooghly (4207)

List of Schools in Hooghly

**List of Schools in Alipurduar (03)

List of Schools in Alipurduar

**List of Schools in Paschim Bardhaman (01)

List of Schools in Paschim Bardhaman

**List of Schools in Purba Bardhaman (01)

List of Schools in Purba Bardhaman

**List of Schools in Jalpaiguri (07)

List of Schools in Jalpaiguri

List of Schools in Jhargram (2240)

List of Schools in Jhargram

**List of Schools in Kalimpong (03)

List of Schools in Kalimpong

List of Schools in Paschim Medinipur (6264)

List of Schools in Paschim Medinipur

List of Schools in Purba Medinipur (5759)

List of Schools in Purba Medinipur

List of Schools in Murshidabad (6033)

List of Schools in Murshidabad

List of Schools in North 24 Parganas (4182)

List of Schools in North 24 Parganas

List of Schools in South 24 Parganas (6024)

List of Schools in South 24 Parganas

List of Schools in West Bengal has no Label in Bengali

[edit]
District Wise List
List of Schools in Kolkata

List of Schools in Kolkata

List of Schools in Howrah

List of Schools in Howrah

List of Schools in Purulia

List of Schools in Purulia

List of Schools in Nadia

List of Schools in Nadia

List of Schools in Malda

List of Schools in Malda

List of Schools in Bankura

List of Schools in Bankura

List of Schools in Cooch Behar

List of Schools in Cooch Behar

List of Schools in Darjeeling

List of Schools in Darjeeling

List of Schools in Dakshin Dinajpur

List of Schools in Dakshin Dinajpur

List of Schools in Uttar Dinajpur

List of Schools in Uttar Dinajpur

List of Schools in Hooghly

List of Schools in Hooghly

List of Schools in Jhargram

List of Schools in Jhargram

List of Schools in Paschim Medinipur

List of Schools in Paschim Medinipur

List of Schools in Purba Medinipur

List of Schools in Purba Medinipur

List of Schools in Murshidabad

List of Schools in Murshidabad

List of Schools in North 24 Parganas

List of Schools in North 24 Parganas

List of Schools in South 24 Parganas

List of Schools in South 24 Parganas

Other Queries

[edit]
List of German Poets & Writers has no label in Bengali

list of German Poet & Writer has no label in Bengali [1]

Film actors and actors, Labels are missing

Film actors and actors, Labels are missing

Requested Queries

[edit]
List of Uttam Kumar's acted Films

| List of Uttam Kumar's acted Films Requested by @Tarunsamanta:

List of Schools in Gujarat has no Label in Gujrati

List of Schools in Gujarat has no Label in Gujrati

Retrieved from "https://www.wikidata.org/w/index.php?title=User:Indrajitdas/Queries&oldid=1167770756"