Baselight
Sign In

Biogas Production From Cow Manure

Measurements fm experiments using domestic biodigestors by prof Jackson Milano

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor

Loading...
Loading...

About this Dataset

Biogas Production From Cow Manure

This dataset was granted by professor Jackson Milano, from Universidade Positivo, as part of his essay with BGS domestic biodigestors, in a ranch, for 14 months, experimenting 4 different biodigestor configurations to obtain continuous biogas production from cow manure all over the year in south of Brazil.

About the settings and tests

Settings used on his experiments:

  • bio 1: biodigestor 1 straight to the ground with NO insulation
  • bio 2: biodigestor 2 insulated from the ground

Timeline of tests/settings and main events:

  1. test 0: may21 - oct21 (bio1)
  2. test 1: nov21 - feb21 (bio1 + bio 2 installation)
  3. test 2: 22-mar-06 to 22-mai-06 (bio 1 + bio 2 + gas recirculation 20s/hour)
  4. test 3: 22-mai-07 to 22-jul-07 (bio 1 + bio 2 + gas recirculation 40s/hour)

File information

Column names and general information:

  • Data: date
  • Hora: hour
  • umidAmb: air humidity (Umidade ambiente)
  • tempAmb: air temperature in celsius (temperatura ambiente)
  • tempSubst: efluent temperature in celsius (temperatura do substrato)
  • tempSolo: ground temperature in celsius (temperatura do solo)
  • umidGas: biogas humidity (umidade do biogás)
  • tempGas: biogas temperature in celsius (temperatura do biogás)
  • decDeBiogas: biogás production dm3 (decímetros cúbicos de biogás produzido)
  • volumeTotal: daily total volume produced (volume total produzido no dia)

Other details:

  • Columns with no suffix at all are for bio 1
  • Columns with suffix "B2" (nov/21 onwards) refers to bio 2 (measurements from both biodigestors combined in a single file)
  • 998 and 999 values are sensor errors and should be ignored/removed

Tables

Biogas Bio1 Aug2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_aug2021
  • 72.25 kB
  • 1,227 rows
  • 86 columns
Loading... 
CREATE TABLE biogas_bio1_aug2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85
);

Biogas Bio1 Bio2 Apr2022

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_apr2022
  • 31.41 kB
  • 1,481 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_apr2022 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" BIGINT,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" BIGINT,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" BIGINT,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Dec2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_dec2021
  • 55.42 kB
  • 2,837 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_dec2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" DOUBLE,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" DOUBLE,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" BIGINT,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" BIGINT,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Feb2022

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_feb2022
  • 48.98 kB
  • 2,591 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_feb2022 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" BIGINT,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" BIGINT,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" BIGINT,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Jan2022

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_jan2022
  • 46.97 kB
  • 2,677 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_jan2022 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" DOUBLE,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" DOUBLE,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" DOUBLE,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Jul2022

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_jul2022
  • 19.83 kB
  • 502 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_jul2022 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" BIGINT,
  "tempamb" DOUBLE,
  "tempgas" BIGINT,
  "umidgasb2" BIGINT,
  "tempsolob2" DOUBLE,
  "umidgas" BIGINT,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" BIGINT,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" BIGINT,
  "volumetotal" BIGINT,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Jun2022

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_jun2022
  • 35.01 kB
  • 1,581 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_jun2022 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" BIGINT,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" BIGINT,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" BIGINT,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" BIGINT,
  "volumetotal" BIGINT,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Mai2022

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_mai2022
  • 38.97 kB
  • 1,886 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_mai2022 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" BIGINT,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" BIGINT,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" BIGINT,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" BIGINT,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Mar2022

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_mar2022
  • 61.4 kB
  • 3,123 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_mar2022 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" DOUBLE,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" DOUBLE,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" DOUBLE,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Bio2 Nov2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_bio2_nov2021
  • 84.73 kB
  • 2,771 rows
  • 18 columns
Loading... 
CREATE TABLE biogas_bio1_bio2_nov2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempgasb2" DOUBLE,
  "tempamb" DOUBLE,
  "tempgas" DOUBLE,
  "umidgasb2" DOUBLE,
  "tempsolob2" DOUBLE,
  "umidgas" DOUBLE,
  "falhasensor" VARCHAR,
  "tempsubst" DOUBLE,
  "umidamb" DOUBLE,
  "falhasensorb2" VARCHAR,
  "volumetotalb2" DOUBLE,
  "decdebiogasb2" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "tempsubstb2" DOUBLE,
  "tempsolo" DOUBLE
);

Biogas Bio1 Jul2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_jul2021
  • 32.66 kB
  • 1,245 rows
  • 10 columns
Loading... 
CREATE TABLE biogas_bio1_jul2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" BIGINT,
  "volumetotal" BIGINT
);

Biogas Bio1 Jun2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_jun2021
  • 32.83 kB
  • 1,265 rows
  • 10 columns
Loading... 
CREATE TABLE biogas_bio1_jun2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" BIGINT,
  "volumetotal" BIGINT
);

Biogas Bio1 May2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_may2021
  • 30.5 kB
  • 1,005 rows
  • 10 columns
Loading... 
CREATE TABLE biogas_bio1_may2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE
);

Biogas Bio1 Oct2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_oct2021
  • 11.73 kB
  • 611 rows
  • 10 columns
Loading... 
CREATE TABLE biogas_bio1_oct2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE
);

Biogas Bio1 Sep2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio1_sep2021
  • 11.88 kB
  • 203 rows
  • 10 columns
Loading... 
CREATE TABLE biogas_bio1_sep2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE
);

Biogas Bio2 Oct2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio2_oct2021
  • 63.61 kB
  • 611 rows
  • 104 columns
Loading... 
CREATE TABLE biogas_bio2_oct2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "unnamed_97" VARCHAR  -- Unnamed: 97,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

Biogas Bio2 Sept2021

@kaggle.ivandaudt_biogas_production_bgs_domestic_biodigestor.biogas_bio2_sept2021
  • 64.99 kB
  • 203 rows
  • 104 columns
Loading... 
CREATE TABLE biogas_bio2_sept2021 (
  "data" TIMESTAMP,
  "hora" VARCHAR,
  "umidamb" DOUBLE,
  "tempamb" DOUBLE,
  "tempsubst" DOUBLE,
  "tempsolo" DOUBLE,
  "umidgas" DOUBLE,
  "tempgas" DOUBLE,
  "decdebiogas" DOUBLE,
  "volumetotal" DOUBLE,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "unnamed_97" VARCHAR  -- Unnamed: 97,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

Share link

Anyone who has the link will be able to view this.