States
State-Level Statistical Variables
@datacommons.states
Punjab - Time Series For Statistical Variables
@datacommons.states.punjab_wikidataid_q22424
This table contains time series data for 4961 statistical variables for location: Punjab (Data Commons location id: wikidataId/Q22424).
- 27.62 MB
- 2929645 rows
- 12 columns
place_idPlace Id | place_namePlace Name | parent_place_idParent Place Id | parent_place_nameParent Place Name | variableVariable | dateDate | valueValue | measurement_methodMeasurement Method | observation_periodObservation Period | import_nameImport Name | provenance_domainProvenance Domain | datacommons_urlDatacommons Url |
|---|---|---|---|---|---|---|---|---|---|---|---|
| wikidataId/Q22424 | Punjab | country/IND | India | indianCensus/Count_Person_Religion_Muslim_MarginalWorker_OtherWorkers | 2011 | 17701 | IndiaCensus_PrimaryReligion | censusindia.gov.in | https://datacommons.org/browser/wikidataId/Q22424?statVar=indianCensus/Count_Person_Religion_Muslim_MarginalWorker_OtherWorkers | ||
| wikidataId/Q22424 | Punjab | country/IND | India | indianCensus/Count_Person_Religion_Buddhist_MarginalWorker_Cultivators_Male | 2011 | 25 | IndiaCensus_PrimaryReligion | censusindia.gov.in | https://datacommons.org/browser/wikidataId/Q22424?statVar=indianCensus/Count_Person_Religion_Buddhist_MarginalWorker_Cultivators_Male | ||
| wikidataId/Q22424 | Punjab | country/IND | India | Count_Person_Houseless_MainWorker_HouseholdIndustries_Rural | 2011 | 361 | IndiaCensus_PrimaryHouseless | censusindia.gov.in | https://datacommons.org/browser/wikidataId/Q22424?statVar=Count_Person_Houseless_MainWorker_HouseholdIndustries_Rural | ||
| wikidataId/Q22424 | Punjab | country/IND | India | indianCensus/Count_Person_Religion_Total_MarginalWorker_Cultivators_Rural_Female | 2011 | 64985 | IndiaCensus_PrimaryReligion | censusindia.gov.in | https://datacommons.org/browser/wikidataId/Q22424?statVar=indianCensus/Count_Person_Religion_Total_MarginalWorker_Cultivators_Rural_Female | ||
| wikidataId/Q22424 | Punjab | country/IND | India | Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 | 2097-06 | -34.6603543333333 | Percentile10AcrossModels | P1M | NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels | nasa.gov | https://datacommons.org/browser/wikidataId/Q22424?statVar=Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 |
| wikidataId/Q22424 | Punjab | country/IND | India | Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 | 2070-06 | -24.4643938333333 | Percentile10AcrossModels | P1M | NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels | nasa.gov | https://datacommons.org/browser/wikidataId/Q22424?statVar=Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 |
| wikidataId/Q22424 | Punjab | country/IND | India | Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 | 2038-03 | -21.6489771666666 | Percentile10AcrossModels | P1M | NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels | nasa.gov | https://datacommons.org/browser/wikidataId/Q22424?statVar=Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 |
| wikidataId/Q22424 | Punjab | country/IND | India | Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 | 2065-09 | -20.6721171666667 | Percentile10AcrossModels | P1M | NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels | nasa.gov | https://datacommons.org/browser/wikidataId/Q22424?statVar=Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 |
| wikidataId/Q22424 | Punjab | country/IND | India | Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 | 2094-02 | -20.6697563333333 | Percentile10AcrossModels | P1M | NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels | nasa.gov | https://datacommons.org/browser/wikidataId/Q22424?statVar=Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 |
| wikidataId/Q22424 | Punjab | country/IND | India | Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 | 2036-02 | -26.5288798333333 | Percentile10AcrossModels | P1M | NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels | nasa.gov | https://datacommons.org/browser/wikidataId/Q22424?statVar=Percentile10AcrossModels_DifferenceRelativeToBaseDate2015To2020_Radiation_Downwelling_ShortwaveRadiation_SSP245 |
CREATE TABLE punjab_wikidataid_q22424 (
"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
);