States

This table contains time series data for 3246 statistical variables for location: Dadra and Nagar Haveli (Data Commons location id: wikidataId/Q46107).

175.15 KB
4540 rows
12 columns

place_id Place Id	place_name Place Name	parent_place_id Parent Place Id	parent_place_name Parent Place Name	variable Variable	date Date	value Value	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Muslim_MarginalWorker_WorkedUpto3Months_Rural	2011	25	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Muslim_MarginalWorker_WorkedUpto3Months_Rural
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Total_MarginalWorker_OtherWorkers_Worked3To6Months_Urban_Male	2011	1918	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Total_MarginalWorker_OtherWorkers_Worked3To6Months_Urban_Male
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Jain_MarginalWorker_WorkedUpto3Months_Urban_Male	2011	1	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Jain_MarginalWorker_WorkedUpto3Months_Urban_Male
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Hindu_MarginalWorker_Rural_Female	2011	13993	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Hindu_MarginalWorker_Rural_Female
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Total_MarginalWorker_Cultivators_WorkedUpto3Months_Rural	2011	659	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Total_MarginalWorker_Cultivators_WorkedUpto3Months_Rural
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Jain_MainWorker_HouseholdIndustries_Urban_Male	2011	14	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Jain_MainWorker_HouseholdIndustries_Urban_Male
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Sikh_Workers_Rural	2011	26	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Sikh_Workers_Rural
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	Count_Person_Houseless_ScheduledTribe_Rural	2011	468	IndiaCensus_PrimaryHouseless	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=Count_Person_Houseless_ScheduledTribe_Rural
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Muslim_MarginalWorker_HouseholdIndustries	2011	11	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Muslim_MarginalWorker_HouseholdIndustries
wikidataId/Q46107	Dadra and Nagar Haveli	wikidataId/Q77997266	Dadra and Nagar Haveli and Daman and Diu	indianCensus/Count_Person_Religion_Buddhist_MarginalWorker_HouseholdIndustries_Worked3To6Months	2011	1	IndiaCensus_PrimaryReligion	censusindia.gov.in	https://datacommons.org/browser/wikidataId/Q46107?statVar=indianCensus/Count_Person_Religion_Buddhist_MarginalWorker_HouseholdIndustries_Worked3To6Months


CREATE TABLE dadra_and_nagar_haveli_wikidataid_q46107 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);