cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.48597/epc5-uepk
title: Measurement of PCB_180 at Storhofdi

description: Measurement of PCB_180 at Storhofdi
DOI: 10.48597/eu3q-sau8
title: Measurement of Manganese at Reykjavik

description: Measurement of Manganese at Reykjavik
DOI: 10.48597/f74k-hka2
title: Measurement of Gamma_HCH at Storhofdi

description: Measurement of Gamma_HCH at Storhofdi
DOI: 10.48597/f7yf-6f8q
title: Measurement of Op_DDT at Storhofdi

description: Measurement of Op_DDT at Storhofdi
DOI: 10.48597/f8cb-u77p
title: Measurement of Conductivity at Reykjavik

description: Measurement of Conductivity at Reykjavik
DOI: 10.48597/fkuw-92uj
title: Measurement of Ammonium at Kårvatn

description: Measurement of Ammonium at Kårvatn
DOI: 10.48597/g9g3-nqya
title: Measurement of Beta_HCH at Storhofdi

description: Measurement of Beta_HCH at Storhofdi
DOI: 10.48597/ge7k-hd43
title: Measurement of Iron at Reykjavik

description: Measurement of Iron at Reykjavik
DOI: 10.34740/kaggle/dsv/7770304
title: Public Opinion Russia Ukraine War (Updated Daily)
DOI: 10.48597/ggz9-nsak
title: Measurement of Sodium at Irafoss

description: Measurement of Sodium at Irafoss
DOI: 10.48597/h64q-yzrj
title: Measurement of Magnesium at Birkenes II

description: Measurement of Magnesium at Birkenes II
DOI: 10.48597/h9fm-g5hk
title: Measurement of Potassium at Kårvatn

description: Measurement of Potassium at Kårvatn
DOI: 10.48597/hg97-u5zn
title: Measurement of Magnesium at Irafoss

description: Measurement of Magnesium at Irafoss
DOI: 10.48597/hkfv-ymrg
title: Measurement of Iron at Irafoss

description: Measurement of Iron at Irafoss
DOI: 10.48597/hvnz-btbf
title: Measurement of Cobalt at Reykjavik

description: Measurement of Cobalt at Reykjavik
DOI: 10.7284/157176
title: GNSS (Global Navigation Satellite System) data collected during research cruise SR2312 using a Hemisphere V104S instrument system onboard the platform RV Sally Ride

description: Original (unprocessed) data collected during a Field_expedition
DOI: 10.48597/hw9g-qfaw
title: Measurement of Calcium at Birkenes II

description: Measurement of Calcium at Birkenes II
DOI: 10.48597/j4ay-92pp
title: Measurement of Chloride at Irafoss

description: Measurement of Chloride at Irafoss
DOI: 10.48597/jjhd-pefv
title: Measurement of Copper at Reykjavik

description: Measurement of Copper at Reykjavik
DOI: 10.48597/k2ab-2t77
title: Measurement of Nitric_acid at Birkenes II

description: Measurement of Nitric_acid at Birkenes II
DOI: 10.48597/k4ry-c2j5
title: Measurement of Magnesium at Reykjavik

description: Measurement of Magnesium at Reykjavik
DOI: 10.48597/kafh-ay8g
title: Measurement of Potassium at Irafoss

description: Measurement of Potassium at Irafoss
DOI: 10.48597/kdbx-3at8
title: Measurement of Nitrogen_dioxide at Kårvatn

description: Measurement of Nitrogen_dioxide at Kårvatn
DOI: 10.48597/krnv-4bwn
title: Measurement of Sum_ammonia_and_ammonium at Birkenes II

description: Measurement of Sum_ammonia_and_ammonium at Birkenes II
DOI: 10.48597/ku3v-nymj
title: Measurement of Calcium at Reykjavik

description: Measurement of Calcium at Reykjavik
DOI: 10.15468/dl.8hyors
title: Occurrence Download

description: A dataset containing 73561 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Smilacaceae",
 "HasCoordinate is true"
 ]
}

 The dataset includes 73561 records from 336 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-160430102343922/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.o1szrx
title: Occurrence Download

description: A dataset containing 56 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "BasisOfRecord is Human Observation",
 "BasisOfRecord is Material sample",
 "BasisOfRecord is Literature Occurrence",
 "BasisOfRecord is Specimen",
 "BasisOfRecord is Living Specimen"
 ]
 },
 {
 "or" : [
 "Country is Mexico",
 "Country is Cuba",
 "Country is El Salvador",
 "Country is Costa Rica"
 ]
 },
 "HasCoordinate is true",
 "TaxonKey is Forestiera rhamnifolia Griseb.",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 56 records from 21 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0016149-191105090559680/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.pv6cgy
title: Occurrence Download

description: A dataset containing 6 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Magnolia ashei Weath.",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Geometry POLYGON((-78 5, -76 11, -88 23, -32 30, -65 73, -75 77, -65 83, -74 84, -168 77, -169 27, -78 5))",
 "Year 2000-2020"
 ]
}

 The dataset includes 6 records from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0176137-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.7k28tv
title: Occurrence Download

description: A dataset containing 59 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Paraboea rufescens (Franch.) B.L.Burtt",
 "HasGeospatialIssue is false",
 "HasCoordinate is true"
 ]
}

 The dataset includes 59 records from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-160803222355964/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.v6p2dz
title: Occurrence Download

description: A dataset containing 362 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "BasisOfRecord is Material sample",
 "BasisOfRecord is Specimen"
 ]
 },
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Mylabris quadripunctata (Linnaeus, 1767)"
 ]
}

 The dataset includes 362 records from 9 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0233701-200613084148143/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.bfjmr5
title: Occurrence Download

description: A dataset containing 15 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Pilosocereus pusillibaccatus P.J.Braun & Esteves"
 ]
}

 The dataset includes 15 records from 9 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0184908-240321170329656/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.tyak7k
title: Occurrence Download

description: A dataset containing 703 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Macropsychanthus hexander (Ralph) L.P.Queiroz & Snak"
 ]
}

 The dataset includes 703 records from 41 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0176138-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.lkjldx
title: Occurrence Download

description: A dataset containing 2200 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Dubusia taeniata (Boissonneau, 1840)"
 ]
}

 The dataset includes 2200 records from 58 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-160822134323880/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.mhtqq6
title: Occurrence Download

description: A dataset containing 71 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Gentiana manshurica Kitag."
 ]
}

 The dataset includes 71 records from 10 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0233702-200613084148143/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.335skh
title: Occurrence Download

description: A dataset containing 14 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Lysimachia cordifolia Hand.-Mazz."
 ]
}

 The dataset includes 14 records from 7 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0233716-200613084148143/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.acfoni
title: Occurrence Download

description: A dataset containing 51 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is Plasm bearing foraminifera counts of multinet M21/5_MSN739"
 ]
}

 The dataset includes 51 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-160910150852091/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.9wpmni
title: Occurrence Download

description: A dataset containing 14592 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Spain",
 {
 "or" : [
 "TaxonKey is Primula acaulis subsp. acaulis",
 "TaxonKey is Polygonum bistorta var. bistorta",
 "TaxonKey is Polygonum balansae Boiss.",
 "TaxonKey is Echium onosmifolium Webb & Berthel.",
 "TaxonKey is Echium flavum Desf.",
 "TaxonKey is Rochelia disperma var. disperma",
 "TaxonKey is Echium decaisnei Webb & Berthel.",
 "TaxonKey is Cerinthe glabra Mill.",
 "TaxonKey is Onosma tricerosperma Lag.",
 "TaxonKey is Onosma tricerosperma subsp. tricerosperma",
 "TaxonKey is Echium wildpretii H.Pearson ex Hook.fil.",
 "TaxonKey is Echium triste Svent.",
 "TaxonKey is Echium triste subsp. triste",
 "TaxonKey is Viola bubanii Timb.-Lagr.",
 "TaxonKey is Pinguicula grandiflora Lam.",
 "TaxonKey is Utricularia ×australis R.Br.",
 "TaxonKey is Pinguicula longifolia subsp. longifolia",
 "TaxonKey is Limonium cossonianum Kuntze",
 "TaxonKey is Limonium ovalifolium (Poir.) Kuntze",
 "TaxonKey is Armeria genesiana Nieto Fel.",
 "TaxonKey is Armeria genesiana subsp. genesiana",
 "TaxonKey is Armeria filicaulis (Boiss.) Boiss.",
 "TaxonKey is Armeria pubinervis Boiss.",
 "TaxonKey is Armeria bigerrensis (Pau ex C.Vicioso & Beltrán) Rivas Mart.",
 "TaxonKey is Valeriana longiflora Willk.",
 "TaxonKey is Centranthus nevadensis Boiss.",
 "TaxonKey is Centranthus lecoqii Jord.",
 "TaxonKey is Berberis hispanica subsp. hispanica",
 "TaxonKey is Scabiosa saxatilis Cav.",
 "TaxonKey is Lomelosia graminifolia (L.) Greuter & Burdet",
 "TaxonKey is Scabiosa graminifolia L.",
 "TaxonKey is Knautia rupicola (Willk.) Font Quer",
 "TaxonKey is Teline osyrioides (Svent.) P.E.Gibbs & Dingwall",
 "TaxonKey is Teline osyrioides subsp. osyrioides",
 "TaxonKey is Adenocarpus aureus (Cav.) Pau",
 "TaxonKey is Echinospartum ibericum Rivas Mart., Sánchez Mata & Sancho",
 "TaxonKey is Plantago alpina L.",
 "TaxonKey is Laurus azorica (Seub.) Franco",
 "TaxonKey is Thymus villosus subsp. villosus",
 "TaxonKey is Salvia canariensis L."
 ]
 }
 ]
}

 The dataset includes 14592 records from 110 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-170627171947987/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.as07sd
title: Occurrence Download

description: A dataset containing 431 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-72.20215 -18.56295,-69.56543 -18.7295,-68.24707 -17.30869,-67.54395 -14.34955,-68.68652 -10.91962,-69.65332 -8.23324,-72.37793 -7.9722,-71.7627 -5.87833,-69.30176 -4.82826,-69.21387 -2.1089,-71.41113 -1.31824,-73.6084 0.43945,-76.33301 0.70311,-76.86035 -1.66969,-78.96973 -3.33795,-80.81543 -2.28455,-83.0127 -3.86425,-80.90332 -8.75479,-77.12402 -16.55196,-72.20215 -18.56295))",
 "TaxonKey is Heliodoxa schreibersii (Bourcier, 1847)",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 431 records from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0028379-191105090559680/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.q4i28s
title: Occurrence Download

description: A dataset containing 521170 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Human Observation",
 "Year 1970-2020",
 "TaxonKey is Crataegus monogyna Jacq."
 ]
}

 The dataset includes 521170 records from 658 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0032273-191105090559680/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.ybcyys
title: Occurrence Download

description: A dataset containing 46286 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "TaxonKey is Lacerta agilis Linnaeus, 1758",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 46286 records from 186 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-171002173027117/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.8eb5j7
title: Occurrence Download

description: A dataset containing 11537 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Plantae",
 "DecimalLatitude is greater than 45.0896049226882",
 "DecimalLatitude is less than 45.895629951694",
 "DecimalLongitude is greater than -123.051880702581",
 "DecimalLongitude is less than -122.226042235547"
 ]
}

 The dataset includes 11537 records from 47 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-171025204727650/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.fgpjaq
title: Occurrence Download

description: A dataset containing 3217 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "Country is Spain",
 "Country is Portugal"
 ]
 },
 "TaxonKey is Silene mellifera Boiss. & Reut."
 ]
}

 The dataset includes 3217 records from 55 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0233732-200613084148143/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.a0htz5
title: Occurrence Download

description: A dataset containing 21076 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "TaxonKey is Scheuchzeria palustris L.",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 21076 records from 112 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001826-171113114016250/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.13130/rd_unimi/t0kw7c/gjzsbh
title: procs
DOI: 10.13130/rd_unimi/t0kw7c/gs2pfn
title: acqus
DOI: 10.13130/rd_unimi/t0kw7c/y9wq7d
title: peaklist.xml
DOI: 10.13130/rd_unimi/t0kw7c/61wnfx
title: intrng
DOI: 10.15468/dl.6cfar6
title: Occurrence Download

description: A dataset containing 6009 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Tracheophyta",
 "DecimalLatitude is greater than or equal to 64.085278",
 "DecimalLatitude is less than or equal to 69.085278",
 "DecimalLongitude is greater than or equal to -120.0",
 "DecimalLongitude is less than or equal to -115.0",
 "HasCoordinate is TRUE",
 "HasGeospatialIssue is FALSE"
 ]
}

 The dataset includes 6009 records from 62 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0011984-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.13130/rd_unimi/t0kw7c/pj7b7d
title: uxnmr.info
DOI: 10.13130/rd_unimi/t0kw7c/vlskiq
title: pulseprogram.precomp
DOI: 10.13130/rd_unimi/t0kw7c/apkptq
title: acqu
DOI: 10.13130/rd_unimi/t0kw7c/zedvxx
title: peaklist.xml
DOI: 10.13130/rd_unimi/t0kw7c/gkn9dn
title: 1i
DOI: 10.13130/rd_unimi/t0kw7c/zbd0es
title: outd
DOI: 10.13130/rd_unimi/t0kw7c/cocgn9
title: peaklist.xml
DOI: 10.13130/rd_unimi/t0kw7c/fw5uur
title: pulseprogram
DOI: 10.13130/rd_unimi/t0kw7c/go5tgu
title: 1r
DOI: 10.13130/rd_unimi/t0kw7c/tl78bh
title: 1i
DOI: 10.13130/rd_unimi/t0kw7c/jy6szq
title: specpar
DOI: 10.13130/rd_unimi/t0kw7c/am2ta5
title: 1i
DOI: 10.13130/rd_unimi/t0kw7c/beonc9
title: pulseprogram
DOI: 10.13130/rd_unimi/t0kw7c/zpdhdt
title: outd
DOI: 10.13130/rd_unimi/t0kw7c/rvsryg
title: uxnmr.info
DOI: 10.13130/rd_unimi/t0kw7c/dyqvcy
title: procs
DOI: 10.13130/rd_unimi/t0kw7c/iradhg
title: intrng
DOI: 10.13130/rd_unimi/t0kw7c/5ens7s
title: peaks
DOI: 10.13130/rd_unimi/t0kw7c/l4imuh
title: acqu
DOI: 10.13130/rd_unimi/t0kw7c/eyf4ee
title: scon2
DOI: 10.13130/rd_unimi/t0kw7c/unpoap
title: prosol_History
DOI: 10.13130/rd_unimi/t0kw7c/tkrl23
title: shimvalues
DOI: 10.13130/rd_unimi/t0kw7c/3mpeff
title: 1r
DOI: 10.13130/rd_unimi/t0kw7c/bzh8jj
title: peakrng
DOI: 10.13130/rd_unimi/t0kw7c/djqxa6
title: acqu
DOI: 10.13130/rd_unimi/t0kw7c/zvfnev
title: uxnmr.info
DOI: 10.13130/rd_unimi/t0kw7c/09r5ia
title: uxnmr.par
DOI: 10.13130/rd_unimi/t0kw7c/o9esyf
title: 1i
DOI: 10.13130/rd_unimi/t0kw7c/ulw38x
title: procs
DOI: 10.5281/zenodo.17591647
title: fembod

description: Database Name: fembod

Tables:

Category

Content of the extract/topic of the quote

Genre

Literary genre of the text

S_Keyword

Keyword used to find that piece of text

Search Keyword

è Name changed into s.keyword = search keyword

Source

Author name + title + century (- = BC ǀ empty = AD)

Texts

It includes all the quotations. Details: Keyword (connect to Table keyword and the ids DONE) + Source (connect with Source table) + Chapter + Paragraph + Verse + Greek + English + Category (connect to category table) + Notes

 

Plutarch Moralia  specific book specified in Chapter

Plutarch Lives  specific book specified in Chapter

 

Links

Link to LOEB Classical Library or Perseus Scaife Viewer

Images

How can I insert image files? Link? 

Id + source + image + category (connect with category table) + notes

ID numbers?

2.22.24

I transferred the database from my computer to a server at the Faculty of Arts so that it has a daily backup, is accessible to me from any computer, is more secure, and allows more people to work on it—making collaboration easier.

Popular Commands:

-        Temporary table created called temporanea in which IDs of sources match. Next move: substitute in the general table texts the sources column with their IDs. 

 

-- questo e’ un commento

/*questo e’un commento*/

 

-        ON = matchs, couples, e.g. select*from texts t left join category c on c.category = t.category

 

-        How to substitute a column with proper values with a column with IDs:

 

UPDATE texts SET category_id = (SELECT id FROM category c WHERE c.category = texts.category);

 

-        UPDATE texts SET section = ‘’ WHERE section is null

-        Create authors table: Creare tabella autori:

CREATE TABLE SELECT DISTINCT author from source; 

= only once, do not repeat the same author more than once. 

-        Fill in the table: comando INSERT

INSERT INTO author (author, date1, date2) SELECT (distinct author, date1, date2 FROM source;  

JOIN TABLE

SELECT * FROM texts t left join source s on t.source_id left join genre g on g genre = s.genre left join category c on t.category_id = c.id; 

 

26.2: update

- Link Table created – Substituted column with Greek quote + link with 2 separate columns: Greek quote / Link ID:

SELECT 

    a.author, s.title, t.greek_quote

FROM

    texts t

        LEFT JOIN

    source s ON t.source_id = s.id

        LEFT JOIN

    genre g ON g.id = s.genre_id

        LEFT JOIN

    category c ON t.category_id = c.id

        LEFT JOIN

    s_keyword sk ON sk.id = t.s_keyword_id

        LEFT JOIN

    author a ON a.id = s.author_id

        LEFT JOIN

    link l ON l.text_id = t.id

WHERE

    sk.keyword = 'Woman';
DOI: 10.13130/rd_unimi/t0kw7c/uqc1r1
title: proc
DOI: 10.5281/zenodo.17591646
title: fembod

description: Database Name: fembod

Tables:

Category

Content of the extract/topic of the quote

Genre

Literary genre of the text

S_Keyword

Keyword used to find that piece of text

Search Keyword

è Name changed into s.keyword = search keyword

Source

Author name + title + century (- = BC ǀ empty = AD)

Texts

It includes all the quotations. Details: Keyword (connect to Table keyword and the ids DONE) + Source (connect with Source table) + Chapter + Paragraph + Verse + Greek + English + Category (connect to category table) + Notes

 

Plutarch Moralia  specific book specified in Chapter

Plutarch Lives  specific book specified in Chapter

 

Links

Link to LOEB Classical Library or Perseus Scaife Viewer

Images

How can I insert image files? Link? 

Id + source + image + category (connect with category table) + notes

ID numbers?

2.22.24

I transferred the database from my computer to a server at the Faculty of Arts so that it has a daily backup, is accessible to me from any computer, is more secure, and allows more people to work on it—making collaboration easier.

Popular Commands:

-        Temporary table created called temporanea in which IDs of sources match. Next move: substitute in the general table texts the sources column with their IDs. 

 

-- questo e’ un commento

/*questo e’un commento*/

 

-        ON = matchs, couples, e.g. select*from texts t left join category c on c.category = t.category

 

-        How to substitute a column with proper values with a column with IDs:

 

UPDATE texts SET category_id = (SELECT id FROM category c WHERE c.category = texts.category);

 

-        UPDATE texts SET section = ‘’ WHERE section is null

-        Create authors table: Creare tabella autori:

CREATE TABLE SELECT DISTINCT author from source; 

= only once, do not repeat the same author more than once. 

-        Fill in the table: comando INSERT

INSERT INTO author (author, date1, date2) SELECT (distinct author, date1, date2 FROM source;  

JOIN TABLE

SELECT * FROM texts t left join source s on t.source_id left join genre g on g genre = s.genre left join category c on t.category_id = c.id; 

 

26.2: update

- Link Table created – Substituted column with Greek quote + link with 2 separate columns: Greek quote / Link ID:

SELECT 

    a.author, s.title, t.greek_quote

FROM

    texts t

        LEFT JOIN

    source s ON t.source_id = s.id

        LEFT JOIN

    genre g ON g.id = s.genre_id

        LEFT JOIN

    category c ON t.category_id = c.id

        LEFT JOIN

    s_keyword sk ON sk.id = t.s_keyword_id

        LEFT JOIN

    author a ON a.id = s.author_id

        LEFT JOIN

    link l ON l.text_id = t.id

WHERE

    sk.keyword = 'Woman';
DOI: 10.13130/rd_unimi/t0kw7c/canwo0
title: peaks
DOI: 10.13130/rd_unimi/t0kw7c/onn2cc
title: shimvalues
DOI: 10.13130/rd_unimi/t0kw7c/z7g8bf
title: audita.txt
DOI: 10.15468/dl.qukhg6
title: Occurrence Download

description: A dataset containing 5943 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Fraxinus)",
 "Country is one of (New Zealand, Australia, South Africa, Bolivia (Plurinational State of), Brazil, Chile, Argentina, Uruguay, Ecuador, Colombia)",
 "HasCoordinate is true"
 ]
}

 The dataset includes 5943 records from 126 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0011985-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.13130/rd_unimi/t0kw7c/mzkgff
title: peaklist.xml