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.

Select Column and time interval

select dataset & columntime intervalcm/Ma
Dataset:Top stage/age:
Column: Base stage/age:

Mode: View is selected - change to edit mode if you want to edit the metadata

Column metadata

Name: column id:183
dataset: forams - microfossils North Sea (dataset id: 51)
column_type:pointdata_table:
Column properties:Width:   Colour:
Field for labels/data:source_col id:
TSC notes:
Compilation notes:
refs to add:
linked refs:
Path:

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

Interval Data selection query
select i.id,i.intervalx,i.has_added_abv,i.block_label,i.base_age,i.top_age,i.colour,i.polarity,i.stage,e.event_display,e.age from arkL_intervals as i left join arkL_events as e on i.base_id=e.id where i.column_id=183 and base_age>= 0 and top_age <= 700 order by base_age, top_age

Column content


There are 40 intervals in the North Sea Zone column of the forams - microfossils North Sea dataset (id=51)
They range in age from 0.0001 Ma (Calabrian) to 132.6000 Ma (Hauterivian)

idintervalxhas_added_abvTSC labeltop_agebase_agestage
4432Cassidulina teretis (NSR 13)Cassidulina teretis (NSR 13)0.00011.8000Calabrian
4433Cibicidoides grossus (NSR 12B)Cibicidoides grossus (NSR 12B)1.80002.8572Gelasian
4434Globorotalia inflata (NSR 12A)Globorotalia inflata (NSR 12A)2.85723.6000Piacenzian
4435Neogloboquadrina atlantica (NSR 11)Neogloboquadrina atlantica (NSR 11)3.60005.3350Zanclean
4436Bolboforma metzmacheri (NSR 10)Bolboforma metzmacheri (NSR 10)5.33508.0614Messinian
4437Ehrenbergina variabilis (NSR 9B)Ehrenbergina variabilis (NSR 9B)8.061412.3225Tortonian
4438Globorotalia praescitula (NSR 9A)Globorotalia praescitula (NSR 9A)12.322516.9731Langhian
4439Catapsydrax unicavus (NSR 8B)Catapsydrax unicavus (NSR 8B)16.973123.0400Burdigalian
4440Siliceous biofacies (NSR 8A)Siliceous biofacies (NSR 8A)23.040027.8590Chattian
4441Turrilina alsatica (NSR 7B)Turrilina alsatica (NSR 7B)27.859031.9837Rupelian
4442Adercotryma agterbergi (NSR 7A)Adercotryma agterbergi (NSR 7A)31.983734.2764Rupelian
4443un-named (NSR 6B)un-named (NSR 6B)34.276437.7100Priabonian
4444Reticulophragmium amplectens (NSR 6A)Reticulophragmium amplectens (NSR 6A)37.710041.0300Bartonian
4445Ammomarginulina aubertae (NSR 5B)Ammomarginulina aubertae (NSR 5B)41.030044.0070Lutetian
4446Reticulophragmium intermedium (NSR 5A)Reticulophragmium intermedium (NSR 5A)44.007048.8780Lutetian
4447Subbotina patagonica (NSR 4)Subbotina patagonica (NSR 4)48.878052.9795Ypresian
4448Fenestrella antiqua (NSR 3)Fenestrella antiqua (NSR 3)52.979556.0010Ypresian
4449Reticulophragmium pauperum (NSR 2B)Reticulophragmium pauperum (NSR 2B)56.001060.6054Thanetian
4450Ammoanita ruthvenmurrayi (NSR 2A)Ammoanita ruthvenmurrayi (NSR 2A)60.605462.3334Selandian
4451Morozovella pseudobulloides (NSR 1)Morozovella pseudobulloides (NSR 1)62.333466.0400Danian
3965Pseudotextularia elegans MfNSeaZyesPseudotextularia elegans66.040067.9750Maastrichtian
3966Reussella szajnochae MfNSeaZyesReussella szajnochae67.975072.1700Maastrichtian
3967Tritaxia dubia MfNSeaZyesTritaxia dubia72.170079.0613Campanian
3968Fenestrella bellii MfNSeaZyesFenestrella bellii79.061383.6500Campanian
3969Inoceramus LCO MfNSeaZyesInoceramus LCO83.650084.9200Santonian
3970Stensioeina polonica MfNSeaZyesStensioeina polonica84.920085.7000Santonian
3971Marginotruncana MfNSeaZyesMarginotruncana85.700091.5850Coniacian
3972Dicarinella MfNSeaZyesDicarinella91.585093.9000Turonian
3973Whiteinella brittonensis MfNSeaZyesWhiteinella brittonensis93.900095.6700Cenomanian
3974Hedbergella delrioensis LCO MfNSeaZyesHedbergella delrioensis LCO95.670098.3700Cenomanian
3975Sigmoilina antiqua MfNSeaZyesSigmoilina antiqua98.3700100.5000Cenomanian
3976Osangularia schloenbachi MfNSeaZyesOsangularia schloenbachi100.5000103.1325Albian
3977Uvigerinammina una MfNSeaZyesUvigerinammina una103.1325106.9800Albian
3978Recurvoides / Glomospira MfNSeaZyesRecurvoides / Glomospira106.9800110.2200Albian
3979Verneuilinoides chapmani MfNSeaZyesVerneuilinoides chapmani110.2200114.8000Albian
3980(no zone) MfNSeaZyes(no zone)114.8000121.4000Aptian
3981Gavelinella barremiana MfNSeaZyesGavelinella barremiana121.4000124.4006Barremian
3982Falsogaudryinella xenogena MfNSeaZyesFalsogaudryinella xenogena124.4006125.3166Barremian
3983Falsogaudryinella praemoesiana Acme MfNSeaZyesFalsogaudryinella praemoesiana Acme125.3166129.5503Hauterivian
3984Protomarssonella kummi MfNSeaZyesProtomarssonella kummi129.5503132.6000Hauterivian

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 Zone column from the forams - microfossils North Sea dataset for the interval. For intervals tables the events re also shown 0 - 700 Ma