View table: social_media

Table structure:

  1. original_date - Date (mandatory)
  2. hour_of_day - Integer (mandatory; allowed values: 0 · 1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 · 19 · 20 · 21 · 22 · 23)
  3. subjects - List of Page, delimiter: , (mandatory)
  4. type - List of String, delimiter: , (mandatory; allowed values: album · song · birthday · death · show)
  5. needs_review - Boolean (mandatory)

This table has 219 rows altogether.

Recreate data.

Page original date hour of day subjects type needs review
SPCodex:Social media page/All Your Love (edit) 2020-04-30 15 All Your Love song No
SPCodex:Social media/1979 (edit) 1996-01-23 5 1 song No
SPCodex:Social media/1979 (edit) 1996-01-23 5 1979 song No
SPCodex:Social media/1979 (music video) (edit) 1996-01-23 15 1979 song No
SPCodex:Social media/A Song for a Son (edit) 2009-12-08 14 A Song for a Son song No
SPCodex:Social media/A Stitch in Time (edit) 2010-03-02 16 A Stitch in Time song No
SPCodex:Social media/A Very Special Christmas 3 (edit) 1997-10-07 14 A Very Special Christmas 3 Christmastime album No
SPCodex:Social media/Adore (edit) 1998-06-02 9 Adore album No
SPCodex:Social media/AEGEA (edit) 2014-05-15 15 AEGEA album No
SPCodex:Social media/Alan Moulder (edit) 1959-06-11 15 Alan Moulder birthday No
SPCodex:Social media/American Gothic (edit) 2008-01-02 12 American Gothic album No
SPCodex:Social media/Anno Satana (edit) 2020-10-09 14 Anno Satana Birch Grove song No
SPCodex:Social media/Another Life and Higher Than The Sky (edit) 2019-09-19 15 Another Life Higher Than The Sky song No
SPCodex:Social media/Apartment Life (edit) 1997-10-07 16 Apartment Life album No
SPCodex:Social media/Ava Adore (edit) 1998-05-18 12 Ava Adore song No
SPCodex:Social media/Ava Adore (music video) (edit) 1998-06-01 14 Ava Adore song No
SPCodex:Social media/Be Strong Now (edit) 1998-02-23 16 Be Strong Now song No
SPCodex:Social media/Beguiled (edit) 2022-09-20 15 Beguiled song No
SPCodex:Social media/Being Beige (edit) 2014-10-20 15 Being Beige song No
SPCodex:Social media/Billy Corgan (edit) 1967-03-17 10 Billy Corgan birthday No
SPCodex:Social media/Billy Corgan 1996-01-17 (edit) 1996-01-17 15 Billy Corgan 1996-01-17 show Yes
SPCodex:Social media/Billy Corgan 1997-02-17 (edit) 1997-02-17 17 Billy Corgan 1997-02-17 show No
SPCodex:Social media/Billy Corgan 1999-03-25 (edit) 1999-03-25 18 Billy Corgan 1999-03-25 show No
SPCodex:Social media/Billy Corgan 2006-04-29 (edit) 2006-04-29 20 Billy Corgan 2006-04-29 show No
SPCodex:Social media/Billy Corgan 2010-09-30 (edit) 2010-09-30 15 Billy Corgan 2010-09-30 Chants Magnétiques show No
SPCodex:Social media/Billy Corgan 2012-09-13 (edit) 2012-09-13 15 Billy Corgan 2012-09-13 show Yes
SPCodex:Social media/Billy Corgan 2014-08-30 (edit) 2014-08-30 15 Billy Corgan 2014-08-30 show Yes
SPCodex:Social media/Billy Corgan 2017-10-14 (edit) 2017-10-14 15 Billy Corgan 2017-10-14 show No
SPCodex:Social media/Billy Corgan 2017-10-14 (edit) 2017-10-15 15 Billy Corgan 2017-10-14 show No
SPCodex:Social media/Billy Corgan 2021-12-18 (edit) 2021-12-18 16 Billy Corgan 2021-12-18 show No
SPCodex:Social media/Blue-Sky Research (edit) 2005-08-16 16 Blue-Sky Research album No
SPCodex:Social media/Blvds of Splendor (edit) 2019-04-13 16 Blvds of Splendor album No
SPCodex:Social media/Bullet with Butterfly Wings (edit) 1995-10-23 15 Bullet with Butterfly Wings song No
SPCodex:Social media/Butch Vig (edit) 1955-08-02 12 Butch Vig birthday No
SPCodex:Social media/Bye Bye Blackbird (edit) 2016-05-27 16 Bye Bye Blackbird album Yes
SPCodex:Social media/Celebrity Skin (edit) 1998-09-08 15 Celebrity Skin album No
SPCodex:Social media/Cherub Rock (edit) 1993-07-13 10 Cherub Rock song No
SPCodex:Social media/Confessions of a Dopamine Addict (edit) 2020-09-25 15 Confessions of a Dopamine Addict Wrath song Yes
SPCodex:Social media/Cotillions (edit) 2019-11-22 13 Cotillions album No
SPCodex:Social media/Crestfallen (edit) 2022-11-02 15 Crestfallen song No
SPCodex:Social media/CYR (edit) 2020-11-27 15 CYR album No
SPCodex:Social media/Cyr (song) (edit) 2020-08-28 14 Cyr (song) song No
SPCodex:Social media/D'arcy Wretzky (edit) 1968-05-01 12 D'arcy Wretzky birthday Yes
SPCodex:Social media/Daughter (edit) 1992-04-04 13 Daughter song No
SPCodex:Social media/Disarm (edit) 1994-03-22 10 Disarm song No
SPCodex:Social media/Drum + Fife (edit) 2014-11-21 15 Drum + Fife song No
SPCodex:Social media/Eye (edit) 1996-09-25 12 Eye song Yes
SPCodex:Social media/Flood (edit) 1960-08-16 14 Flood birthday No
SPCodex:Social media/FOL (edit) 2009-02-01 14 FOL song Yes
SPCodex:Social media/For the Masses (edit) 1998-08-04 15 For the Masses Never Let Me Down Again album No
SPCodex:Social media/Freak (edit) 2010-07-06 14 Freak song Yes
SPCodex:Social media/G.L.O.W. (edit) 2008-11-04 15 G.L.O.W. song No
SPCodex:Social media/Get Ready (edit) 2001-08-27 15 Get Ready album No
SPCodex:Social media/Ginger Pooley (edit) 1977-04-22 16 Ginger Pooley birthday No
SPCodex:Social media/Gish (edit) 1991-05-28 11 Gish album No
SPCodex:Social media/God's Gonna Cut You Down (edit) 2015-04-07 14 God's Gonna Cut You Down album Yes
SPCodex:Social media/Good Soldier (edit) 2014-02-25 21 Good Soldier album No
SPCodex:Social media/Great Civilizations (edit) 2011-06-21 19 Great Civilizations album No
SPCodex:Social media/Greatest Hits Video Collection (1991–2000) (edit) 2001-11-20 15 Greatest Hits Video Collection (1991–2000) album No
SPCodex:Social media/Haenim (edit) 2021-07-14 15 Haenim song No
SPCodex:Social media/Honestly (edit) 2023-02-24 15 Honestly song Yes
SPCodex:Social media/Hot Saki & Bedtime Stories (edit) 1996-09-17 15 Hot Saki & Bedtime Stories album No
SPCodex:Social media/Humanity: Hour I (edit) 2007-05-25 18 Humanity: Hour I album No
SPCodex:Social media/I Am One (edit) 1992-08-24 13 I Am One song No
SPCodex:Social media/If All Goes Wrong (edit) 2008-11-11 15 If All Goes Wrong album No
SPCodex:Social media/Iommi (edit) 2000-10-17 15 Iommi album No
SPCodex:Social media/Jack Bates (edit) 1989-09-27 12 Jack Bates birthday Yes
SPCodex:Social media/James Iha (edit) 1968-03-26 10 James Iha birthday No
SPCodex:Social media/Jeff Schroeder (edit) 1974-02-04 8 Jeff Schroeder birthday No
SPCodex:Social media/Jimmy Chamberlin (edit) 1964-06-10 12 Jimmy Chamberlin birthday Yes
SPCodex:Social media/Jimmy Chamberlin Complex 2005-01-15 (edit) 2005-01-15 18 Jimmy Chamberlin Complex 2005-01-15 show No
SPCodex:Social media/Kerry Brown (edit) 1963-12-05 7 Kerry Brown birthday No
SPCodex:Social media/Kissin Time (edit) 2002-03-04 17 Kissin Time album No
SPCodex:Social media/Knights of Malta (edit) 2018-11-09 14 Knights of Malta song No
SPCodex:Social media/Landslide (edit) 1994-10-04 13 Landslide Pisces Iscariot song No
SPCodex:Social media/Let It Come Down (edit) 1998-02-10 6 Let It Come Down album No
SPCodex:Social media/Life Begins Again (edit) 2005-01-25 15 Life Begins Again album No
SPCodex:Social media/Light Into Dark (edit) 1989-04-12 15 Light Into Dark album No
SPCodex:Social media/Lightning Strikes (edit) 2011-03-18 15 Lightning Strikes song No
SPCodex:Social media/Linda Linda Linda (edit) 2005-07-20 15 Linda Linda Linda album No
SPCodex:Social media/Linda Strawbery (edit) 1981-09-09 12 Linda Strawberry birthday Yes
SPCodex:Social media/Lisa Harriton (edit) 1980-11-17 14 Lisa Harriton birthday Yes
SPCodex:Social media/Live Smashing Pumpkins (edit) 2009-01-15 15 Live Smashing Pumpkins album No
SPCodex:Social media/Look to the Sky (edit) 2012-03-14 13 Look to the Sky album No
SPCodex:Social media/Lull (edit) 1991-11-05 12 Lull album No
SPCodex:Social media/Lyric (edit) 2003-06-02 19 Lyric song Yes
SPCodex:Social media/Machina II/The Friends & Enemies of Modern Music (edit) 2000-09-05 12 Machina II/The Friends & Enemies of Modern Music album No
SPCodex:Social media/Machina sessions (edit) 2000-02-28 20 Machina/The Machines of God album No
SPCodex:Social media/Machina/The Machines of God (edit) 2000-02-28 13 Machina/The Machines of God album No
SPCodex:Social media/Maison Atia (edit) 2020-12-05 16 Maison Atia song No
SPCodex:Social media/Mark Stoermer (edit) 1977-06-28 15 Mark Stoermer birthday No
SPCodex:Social media/Mary Star of the Sea (edit) 2003-01-28 3 Mary Star of the Sea album No
SPCodex:Social media/Matt Sweeney (edit) 1969-07-02 15 Matt Sweeney birthday No
SPCodex:Social media/Melissa Auf der Maur (edit) 1972-03-17 16 Melissa Auf der Maur birthday No
SPCodex:Social media/Mellon Collie and the Infinite Sadness (edit) 1995-10-23 12 Mellon Collie and the Infinite Sadness album No
SPCodex:Social media/Mellon Collie artwork (edit) 1995-10-24 18 Mellon Collie and the Infinite Sadness album No
SPCodex:Social media/Mellon Collie sessions (edit) 1995-10-25 15 March-August 1995 – Pumpkinland and Chicago Recording Company Mellon Collie and the Infinite Sadness album No
SPCodex:Social media/Mike Byrne (edit) 1990-02-06 15 Mike Byrne birthday No
SPCodex:Social media/Monuments to an Elegy (edit) 2014-12-09 13 Monuments to an Elegy album No
SPCodex:Social media/Music For Hangovers (edit) 1999-06-15 16 Music For Hangovers album No

More...