• arkL
  • notes
  • introduction and login
  • notes on sequence data
  • notes on data table creation
  • view data
  • multicolumn view
  • dataset view
  • column view
  • event view
  • interval view
  • references
  • taxon links
  • data upload & integration
  • upload data
  • populate (integrate and check data)

View/edit a column - North Sea Zone

TimeScaleCreator displays data in columns, as selected in the Choose Columns pane of TSC settings. This page allows selection of a column and review of metadata on it. It also displays the content of the column.

• Columns which have not yet had data imported into this database are not shown.
• Column colour is based on the dataset/subdataset so the options to change colour are given on the dataset page.
  
• Most col names have been copied from TSC, to activate an existing column enter the dataset_id directly in the arkL_columns database
• Once columns exist and are assigned to a datset they can be edited from this page
• Events and intervals are not directly assigned to a column in the database instead the column metadata defines which events and intervals are selected

Select Column and time interval

select dataset & column		time interval		cm/Ma
Dataset:	chronostratigraphyQuaternary Regional Stagesstages Australian (Cenoz, Sil-Ord)stages Baltoscania (Sil_Ord)stages Boreal (Late J/early K)stages British (Late J/early K)stages California (Cenozoic)stages Donets Basin (Carb)stages Iberian-Morocco (Ord-Camb)stages Japan (Neogene, Cret)stages Kazakhistan (Camb)stages New Zealandstages North American (Cret & Palaeozoic)stages North China (Camb)stages Paratethys (Neogene)stages Russia (Permo-Carb, Camb)stages Siberia (Carb, Camb)stages South China (Jur -> Camb)stages Tethyan - Pamirs (Permian)stages Tethyan - Salt Range (Permian)stages Western Europe (Cret, Permo-Carb, Ord-Camb) strat - Dorset Late Jurassicstrat - German Triassicstrat - type Mississippianstrat - Yangtse Platform (China, Tr)strat - Yorkshire Oxfordiananoxic episodesLower Paleozoic Time Slicesbiotic eventsmagnetochronologymagnetochronology - Jurassic pre M26 PacDeepTow at depthmagnetochronology - Quaternary eventsmagnetochronology - Triassic outcropmagnetochronology- Jurassic outcropammonites Russian Borealammonites Siberian Borealammonites Sub-Borealammonites Tethyanammonites Western Interiorbelemnites Balto-Scandiabelemnites Borealbelemnites Russian platform belemnites Tethyangraptolitestrilobitesbivalves Siberianbivalves Triassicbrachiopods Borealbrachiopods Tethyaninoceramids Aquitaineinoceramids Russian platforminoceramids Western Europeinoceramids Western interiorrudistsarchaeocyathsdacryoconarids (tentaculitids)conchostracansconodontsconodonts Australiaconodonts NAmostracods Borealostracods Devonianostracods Frenchostracods Tethyancalcareous algaecalpionellidscharophytesdiatoms low-latdiatoms mid-lat NPacdiatoms Soceanforams - Fusulinids & bforams - Eurasiaforams - Fusulinids & bforams - NAmericaforams - LBF letter stagesforams - LBFsforams - LBFs- French 1997 datumsforams - microfossils North Seaforams - plankticforams - SBFs Borealforams - SBFs Frenchforams - SBFs Tethyannannos Borealnannos Tethyanradiolaria low-latradiolaria Permo-Triassicradiolaria Southen mid & high latacritarchschitinozoadflgs Borealdflgs North Seadflgs NW Europedflgs Tethyanmiospores - Australianmiospores - E Europeanmiospores - SEAustralianmiospores - W Europeanpollen & spores - Arctic Triassicpollen & spores - German Triassicmacrofloramammals Asia & Chinamammals Australianmammals Europemammals North Americamammals South AmericaVert - AcanthodiansVert - Australian Early FishVert - Fish and Reptile faunachronsVert - PlacodermsVert - Sharkscyclostrat Martinez cyclessea-level Slilurian Loydell 98sequences - Boreal Jurassicsequences - Devoniansequences - Devonian Johnson85 T-Rsequences - NAm Ordovician of Hollandsequences & sea-level Silurian & Ordoviciansequences Carb Donets Basinsequences Carb Eurasiansequences globalsequences Perm-Carb-Dev NAmAntarctic CO2Antarctic delta-DeuteriumCarbon-13 compositeCarbon-13 eventsCenogrid - Westerhold2020Chinese Loess Mag suscLisiecki&Raymo 2005Marine Isotope StagesMilankovitch parametersOxygen-18 Cramer 2009Oxygen-18 eventsStrontiumMiller et al 2020	Top stage/age:
Column:	North Sea Zone North Sea Event Deep-Water Agglutinated Foraminifers (Offshore Norway) all events	Base stage/age:

Column metadata

Name:		North Sea Event column id:185
dataset:		chronostratigraphy Quaternary Regional Stages stages Australian (Cenoz, Sil-Ord) stages Baltoscania (Sil_Ord) stages Boreal (Late J/early K) stages British (Late J/early K) stages California (Cenozoic) stages Donets Basin (Carb) stages Iberian-Morocco (Ord-Camb) stages Japan (Neogene, Cret) stages Kazakhistan (Camb) stages New Zealand stages North American (Cret & Palaeozoic) stages North China (Camb) stages Paratethys (Neogene) stages Russia (Permo-Carb, Camb) stages Siberia (Carb, Camb) stages South China (Jur -> Camb) stages Tethyan - Pamirs (Permian) stages Tethyan - Salt Range (Permian) stages Western Europe (Cret, Permo-Carb, Ord-Camb) strat - Dorset Late Jurassic strat - German Triassic strat - type Mississippian strat - Yangtse Platform (China, Tr) strat - Yorkshire Oxfordian anoxic episodes Lower Paleozoic Time Slices biotic events magnetochronology magnetochronology - Jurassic pre M26 PacDeepTow at depth magnetochronology - Quaternary events magnetochronology - Triassic outcrop magnetochronology- Jurassic outcrop ammonites Russian Boreal ammonites Siberian Boreal ammonites Sub-Boreal ammonites Tethyan ammonites Western Interior belemnites Balto-Scandia belemnites Boreal belemnites Russian platform belemnites Tethyan graptolites trilobites bivalves Siberian bivalves Triassic brachiopods Boreal brachiopods Tethyan inoceramids Aquitaine inoceramids Russian platform inoceramids Western Europe inoceramids Western interior rudists archaeocyaths dacryoconarids (tentaculitids) conchostracans conodonts conodonts Australia conodonts NAm ostracods Boreal ostracods Devonian ostracods French ostracods Tethyan calcareous algae calpionellids charophytes diatoms low-lat diatoms mid-lat NPac diatoms Socean forams - Fusulinids & bforams - Eurasia forams - Fusulinids & bforams - NAmerica forams - LBF letter stages forams - LBFs forams - LBFs- French 1997 datums forams - microfossils North Sea forams - planktic forams - SBFs Boreal forams - SBFs French forams - SBFs Tethyan nannos Boreal nannos Tethyan radiolaria low-lat radiolaria Permo-Triassic radiolaria Southen mid & high lat acritarchs chitinozoa dflgs Boreal dflgs North Sea dflgs NW Europe dflgs Tethyan miospores - Australian miospores - E European miospores - SEAustralian miospores - W European pollen & spores - Arctic Triassic pollen & spores - German Triassic macroflora mammals Asia & China mammals Australian mammals Europe mammals North America mammals South America Vert - Acanthodians Vert - Australian Early Fish Vert - Fish and Reptile faunachrons Vert - Placoderms Vert - Sharks cyclostrat Martinez cycles sea-level Slilurian Loydell 98 sequences - Boreal Jurassic sequences - Devonian sequences - Devonian Johnson85 T-R sequences - NAm Ordovician of Holland sequences & sea-level Silurian & Ordovician sequences Carb Donets Basin sequences Carb Eurasian sequences global sequences Perm-Carb-Dev NAm Antarctic CO2 Antarctic delta-Deuterium Carbon-13 composite Carbon-13 events Cenogrid - Westerhold2020 Chinese Loess Mag susc Lisiecki&Raymo 2005 Marine Isotope Stages Milankovitch parameters Oxygen-18 Cramer 2009 Oxygen-18 events Strontium Miller et al 2020 forams - microfossils North Sea (dataset id: 51)
column_type:		intervals events lithology range chart sequence pointdata bar chart graphic sea-level curve images stacked filled curve pointdata_table:
Column properties:		Width:   Colour:
Field for labels/data:		source_col id:
TSC notes:
Compilation notes:
refs to add:
linked refs:
Path:		Microfossils/Planktonic and Benthic Foraminifers/North Sea Microfossil Zones

Column References ↑

Dataset References ↑

select * from arkL_refs as r left join arkL_reflinks as l on r.refno=l.refno where (l.dbase='arkL_datasets' and l.dbase_id=51) order by abv_ref, disambig

Gradstein, F., Kaminski, M. A. & Agterberg, F. P. (1999). Biostratigraphy and paleoceanography of the Cretaceous seaway between Norway and Greenland. Earth-Science Reviews. 46: 27-98. gs

Data selection query:
select * from arkL_events where column_id=185 AND age > 0 and age < 700 order by age

Column content

Within the selected interval there are 48 events in the North Sea Zone column of the forams - microfossils North Sea dataset (id=51)
They range in age from 0.4638 Ma (Chibanian) to 129.5503 Ma (Hauterivian)

id	eventx	has_added_abvE	event_type	TSC label	age	stage
6365	LAD Elphidium clavatum, Cassidulina teretis, Cibicidoides scaldisiensis, Neogloboquadrina pachyderma	-	LAD	LAD Elphidium clavatum, Cassidulina teretis, Cibicidoides scaldisiensis, Neogloboquadrina pachyderma	0.4638	Chibanian
6366	LAD Cibicidoides grossus, Ammonia beccarii	-	LAD	LAD Cibicidoides grossus, Ammonia beccarii	1.8	Calabrian
6367	LAD Cibicidoides grossus LCO, Sigmoilopsis schlumbergeri, Nonion affine LCO, Monspeliensis pseudotepida, Globorotalia inflata	-	LAD	LAD Cibicidoides grossus LCO, Sigmoilopsis schlumbergeri, Nonion affine LCO, Monspeliensis pseudotepida, Globorotalia inflata	2.8572	Piacenzian
6368	LAD S. North Sea: Hyalinea balthica	-	LAD	LAD S. North Sea: Hyalinea balthica	2.9664	Piacenzian
6369	LAD Neogloboquadrina atlantica, Globorotalia crassaformis, Globorotalia puncticulata, Neogloboquadrina humerosa	-	LAD	LAD Neogloboquadrina atlantica, Globorotalia crassaformis, Globorotalia puncticulata, Neogloboquadrina humerosa	3.6	Piacenzian
6370	LAD Bolboforma metzmacheri, Cibicides telegdi, Neogloboquadrina atlantica (dextral), Globigerina bulloides, Neogloboquadrina acostaensis	-	LAD	LAD Bolboforma metzmacheri, Cibicides telegdi, Neogloboquadrina atlantica (dextral), Globigerina bulloides, Neogloboquadrina acostaensis	5.335	Zanclean
6371	LAD Ehrenbergina variabilis, Cassidulina subglobosa, Martinotiella cylindrica, Bolboforma fragori, Bolboforma spiralis, Neogloboquadrina pachyderma	-	LAD	LAD Ehrenbergina variabilis, Cassidulina subglobosa, Martinotiella cylindrica, Bolboforma fragori, Bolboforma spiralis, Neogloboquadrina pachyderma	8.0614	Tortonian
6372	LAD Globorotalia praemenardii, DWAF	-	LAD	LAD Globorotalia praemenardii, DWAF	12.0678	Serravallian
6373	LAD Cibicidoides wuellerstorfi, Uvigerina semiornata; Neogloboquadrina continuosa, Globigerina praebulloides	-	LAD	LAD Cibicidoides wuellerstorfi, Uvigerina semiornata; Neogloboquadrina continuosa, Globigerina praebulloides	12.3225	Serravallian
6374	LAD Spirosigmoilinella compressa, Globorotalia praescitula/zealandica, Sphaeroidinellopsis disjuncta, Sphaeroidinellopsis seminulina	-	LAD	LAD Spirosigmoilinella compressa, Globorotalia praescitula/zealandica, Sphaeroidinellopsis disjuncta, Sphaeroidinellopsis seminulina	14.7418	Langhian
6375	LAD Catapsydrax unicavus, Globigerinoides trilobus, Asterigerina guerichi	-	LAD	LAD Catapsydrax unicavus, Globigerinoides trilobus, Asterigerina guerichi	16.9731	Burdigalian
6376	LAD Siliceous biofacies, S.North Sea = Globigerina ciperoensis, Globoquadrina praedehiscens, Dentoglobigerina baroemoensis	-	LAD	LAD Siliceous biofacies, S.North Sea = Globigerina ciperoensis, Globoquadrina praedehiscens, Dentoglobigerina baroemoensis	20.448	Burdigalian
6377	LAD Siliceous biofacies LCO, Cibicidoides mundulus, Aulacodiscus insignis var. (sp.3,4,5); S. North Sea = Globigerina officinalis, Almaena osnabrugensis	-	LAD	LAD Siliceous biofacies LCO, Cibicidoides mundulus, Aulacodiscus insignis var. (sp.3,4,5); S. North Sea = Globigerina officinalis, Almaena osnabrugensis	23.04	Aquitanian
6378	LAD Turrilina alsatica LO, Spirosigmoilinella compressa LCO, Dorothia seigliei	-	LAD	LAD Turrilina alsatica LO, Spirosigmoilinella compressa LCO, Dorothia seigliei	26.6238	Chattian
6379	LCO Turrilina alsatica LCO	-	LCO	LCO Turrilina alsatica LCO	27.859	Rupelian
6380	LAD Adercotryma agterbergi, Annectina biedai, Rotaliatina bulimoides, DWAF LCO (rare), Reticulophragmium acutidorsatum, Ammodiscus latus, Reticulophragmoides jarvisi	-	LAD	LAD Adercotryma agterbergi, Annectina biedai, Rotaliatina bulimoides, DWAF LCO (rare), Reticulophragmium acutidorsatum, Ammodiscus latus, Reticulophragmoides jarvisi	31.9837	Rupelian
6381	LAD S. North Sea = Subbotina linaperta, Turborotalia pomeroli, Globorotalia cerroazulensis	-	LAD	LAD S. North Sea = Subbotina linaperta, Turborotalia pomeroli, Globorotalia cerroazulensis	33.9049	Rupelian
6382	LAD Ammosphaerodina pseudopauciloculata	-	LAD	LAD Ammosphaerodina pseudopauciloculata	34.2764	Priabonian
6383	LAD Reticulophragmium amplectens; S. North Sea = Marginulopsis decorata, Cibicidoides truncanus	-	LAD	LAD Reticulophragmium amplectens; S. North Sea = Marginulopsis decorata, Cibicidoides truncanus	37.71	Priabonian
6384	LAD Ammomarginulina aubertae, Karrerulina conversa, Karrerulina coniformis, Haplophragmoides kirki	-	LAD	LAD Ammomarginulina aubertae, Karrerulina conversa, Karrerulina coniformis, Haplophragmoides kirki	41.03	Bartonian
6385	LAD Recticulophragmium intermedium, Recurvoidella lamella, Spiroplectammina navarroana	-	LAD	LAD Recticulophragmium intermedium, Recurvoidella lamella, Spiroplectammina navarroana	44.007	Lutetian
6386	LAD S. North Sea = Turrilina robertsi, Acarinina pentacamerata, Acarinina sp.	-	LAD	LAD S. North Sea = Turrilina robertsi, Acarinina pentacamerata, Acarinina sp.	44.9817	Lutetian
6387	LAD Popovia spp., Subbotina patagonica; S. North Sea = Planorotolites planoconicus, Acarinina densa, Acarinina pseudotopilensis, Planorotalites australiformis, Morozovella formosa gracilis, Acarinina soldadoensis, Bulimina trigonalis	-	LAD	LAD Popovia spp., Subbotina patagonica; S. North Sea = Planorotolites planoconicus, Acarinina densa, Acarinina pseudotopilensis, Planorotalites australiformis, Morozovella formosa gracilis, Acarinina soldadoensis, Bulimina trigonalis	48.878	Ypresian
6388	LAD Fenestrella antiqua	-	LAD	LAD Fenestrella antiqua	52.9795	Ypresian
6389	LAD DWAF (rare)	-	LAD	LAD DWAF (rare)	56.001	Ypresian
6390	LAD Spiroplectammina dentata (S. North Sea)	-	LAD	LAD Spiroplectammina dentata (S. North Sea)	56.941	Thanetian
6391	LAD DWAF LCO, including Rzehakina minima, Hyperammina rugosa, Saccamina placenta, Reticulophragmium pauperum, Reticulophragmium garcilassoi (rare), Spiroplectammina spectabilis LCO	-	LAD	LAD DWAF LCO, including Rzehakina minima, Hyperammina rugosa, Saccamina placenta, Reticulophragmium pauperum, Reticulophragmium garcilassoi (rare), Spiroplectammina spectabilis LCO	57.101	Thanetian
6392	LAD Ammoanita ruthvenmurrayi, Hormosina excelsa, Labrospira pacifica (rare), Cystammina sveni, Conotrochammina voeringensis (rare), Ammoanita ingerlisae (rare)	-	LAD	LAD Ammoanita ruthvenmurrayi, Hormosina excelsa, Labrospira pacifica (rare), Cystammina sveni, Conotrochammina voeringensis (rare), Ammoanita ingerlisae (rare)	60.6054	Selandian
6393	LAD Cenosphaera lenticularis, Gavelinella beccariiformis, Remesella varians, Morozovella pseudobulloides, Globanomalina cf. compressa, Subbotina triloculinoides, ’Globigerina’ trivialis, Globoconusa daubjergensis, ’Globigerina’ simplicissimum	-	LAD	LAD Cenosphaera lenticularis, Gavelinella beccariiformis, Remesella varians, Morozovella pseudobulloides, Globanomalina cf. compressa, Subbotina triloculinoides, ’Globigerina’ trivialis, Globoconusa daubjergensis, ’Globigerina’ simplicissimum	62.3334	Danian
5792	LADnsea Cretecaous planktic forams	-	LAD	LADnsea Cretecaous planktic forams	66.04	Danian
5793	LADnsea Reussella szajnochae	-	LAD	LADnsea Reussella szajnochae	67.975	Maastrichtian
5794	LADnsea Tritaxia dubia	-	LAD	LADnsea Tritaxia dubia	72.17	Maastrichtian
5795	LADnsea Fenestrella bellii	-	LAD	LADnsea Fenestrella bellii	79.0613	Campanian
5796	LCOnsea Inoceramus	-	LCO	LCOnsea Inoceramus	83.65	Campanian
5797	LADnsea Stensioeina polonica	-	LAD	LADnsea Stensioeina polonica	84.92	Santonian
5798	LADnsea Marginotruncana marginata	-	LAD	LADnsea Marginotruncana marginata	85.7	Santonian
5799	LADnsea Dicarinella	-	LAD	LADnsea Dicarinella	91.585	Turonian
5800	LADnsea Whiteinella brittonensis	-	LAD	LADnsea Whiteinella brittonensis	93.9	Turonian
5801	LADnsea Hedbergella delrioensis LCO	-	LCO	LADnsea Hedbergella delrioensis LCO	95.67	Cenomanian
5802	LADnsea Sigmoilina antiqua	-	LAD	LADnsea Sigmoilina antiqua	98.37	Cenomanian
5803	LADnsea Osangularia schloenbachi	-	LAD	LADnsea Osangularia schloenbachi	100.5	Cenomanian
5804	LADnsea Uvigerinammina una	-	LAD	LADnsea Uvigerinammina una	103.1325	Albian
5805	LADnsea Recurvoides / Glomospira	-	LAD	LADnsea Recurvoides / Glomospira	106.98	Albian
5806	LADnsea Verneuilinoides chapmani	-	LAD	LADnsea Verneuilinoides chapmani	110.22	Albian
5808	LADnsea Gavelinella barremiana	-	LAD	LADnsea Gavelinella barremiana	121.4	Aptian
5809	LADnsea Falsogaudryinella xenogena	-	LAD	LADnsea Falsogaudryinella xenogena	124.4006	Barremian
5810	LADnsea Falsogaudryinella praemoesiana Acme	-	LCO	LADnsea Falsogaudryinella praemoesiana Acme	125.3166	Barremian
5811	LADnsea Protomarssonella kummi	-	LAD	LADnsea Protomarssonella kummi	129.5503	Hauterivian

Column mock-up

This column mock-up plot is a simple plot of the data to allow visual comparaison with the output from TimeScale Creator. For interval tables the defining events are also shown

The data plotted here is the North Sea Event column from the forams - microfossils North Sea dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma