Baselight
SELECT
    CASE WHEN LOWER("type") LIKE '%boeing%' THEN survivalrate ELSE NULL END AS "Boeing survival rate",
    CASE WHEN LOWER("type") LIKE '%airbus%' THEN survivalrate ELSE NULL END AS "Airbus survival rate",
    "date"
FROM
@kaggle.juancarlosventosa_large_passenger_plane_crashes_19332009.large_passenger_plane_crashes_1933_to_2009
WHERE
    CASE WHEN LOWER("type") LIKE '%boeing%' THEN survivalrate ELSE NULL END IS NOT NULL
    OR CASE WHEN LOWER("type") LIKE '%airbus%' THEN survivalrate ELSE NULL END IS NOT NULL
ORDER BY "date" ASC;
Boeing survival rateAirbus survival ratedate
0null1969-06-04 00:00:00
0.771186441null1969-09-21 00:00:00
0.006097561null1971-07-30 00:00:00
1null1971-07-30 00:00:00
0null1971-09-04 00:00:00
0.128712871null1973-01-22 00:00:00
0.026548673null1973-02-21 00:00:00
0.082089552null1973-07-11 00:00:00
0.012658228null1973-07-22 00:00:00
0.993288591null1973-08-28 00:00:00
0.830508475null1973-12-17 00:00:00
0.04950495null1974-01-30 00:00:00
0.996644295null1974-02-02 00:00:00
0null1974-04-22 00:00:00
0null1974-09-08 00:00:00
0null1974-09-15 00:00:00
0.624203822null1974-11-20 00:00:00
0null1974-12-01 00:00:00
0.088709677null1975-06-24 00:00:00
0null1975-08-03 00:00:00
1null1975-08-07 00:00:00
0null1976-01-01 00:00:00
null0.9728682171976-06-27 00:00:00
0null1976-09-19 00:00:00
0.094720497null1977-03-27 00:00:00
0.201219512null1977-11-19 00:00:00
0null1977-12-04 00:00:00
0null1978-01-01 00:00:00
0.981651376null1978-04-20 00:00:00
0null1978-09-25 00:00:00
0.992424242null1978-12-17 00:00:00
0null1979-11-26 00:00:00
0null1980-01-21 00:00:00
0.985185185null1980-02-27 00:00:00
0null1980-04-25 00:00:00
0.933628319null1980-11-19 00:00:00
0null1981-08-22 00:00:00
0.063291139null1982-01-13 00:00:00
0.983050847null1982-05-25 00:00:00
0null1982-06-08 00:00:00
0.846846847null1982-06-22 00:00:00
1null1982-06-24 00:00:00
0null1982-07-09 00:00:00
0null1983-07-11 00:00:00
0null1983-09-01 00:00:00
0null1983-09-23 00:00:00
0null1983-11-08 00:00:00
0.057291667null1983-11-27 00:00:00
0.311111111null1983-12-07 00:00:00
0.982758621null1984-08-30 00:00:00
0null1985-02-19 00:00:00
1null1985-02-19 00:00:00
0.993464052null1985-06-14 00:00:00
0null1985-06-23 00:00:00
0.007633588null1985-08-12 00:00:00
0.598540146null1985-08-22 00:00:00
0.417475728null1985-11-24 00:00:00
0null1986-03-31 00:00:00
0.966942149null1986-04-02 00:00:00
0.958333333null1986-09-05 00:00:00
0.405660377null1986-12-25 00:00:00
0null1987-08-31 00:00:00
0null1987-11-28 00:00:00
0null1987-11-29 00:00:00
0null1988-03-17 00:00:00
0.982142857null1988-04-05 00:00:00
0.989473684null1988-04-28 00:00:00
null0.9779411761988-06-26 00:00:00
null01988-07-03 00:00:00
0.87037037null1988-08-31 00:00:00
0.663461538null1988-09-15 00:00:00
0.03875969null1988-10-19 00:00:00
0null1988-12-21 00:00:00
0.626984127null1989-01-08 00:00:00
0null1989-02-08 00:00:00
0.974719101null1989-02-24 00:00:00
0.130136986null1989-10-21 00:00:00
0null1989-11-27 00:00:00
0.537974684null1990-01-25 00:00:00
null0.3698630141990-02-14 00:00:00
0.932773109null1990-05-11 00:00:00
0.433628319null1990-10-02 00:00:00
0.95959596null1990-12-03 00:00:00
0null1991-05-26 00:00:00
0null1991-08-16 00:00:00
null0.093751992-01-20 00:00:00
null01992-07-31 00:00:00
null01992-09-28 00:00:00
0null1992-11-24 00:00:00
0null1992-12-22 00:00:00
0.525423729null1993-04-26 00:00:00
0null1993-05-19 00:00:00
0.381818182null1993-07-26 00:00:00
null01994-03-23 00:00:00
null0.0258302581994-04-26 00:00:00
null11994-08-10 00:00:00
0null1994-09-08 00:00:00
0.996587031null1994-12-10 00:00:00
null0.9874476991994-12-26 00:00:00
0.934306569null1995-11-13 00:00:00
0.076923077null1995-12-03 00:00:00
0.024390244null1995-12-20 00:00:00
0null1996-02-06 00:00:00
0null1996-02-29 00:00:00
0null1996-07-17 00:00:00
0null1996-10-02 00:00:00
0null1996-11-07 00:00:00
0null1996-11-12 00:00:00
0.274285714null1996-11-23 00:00:00
0.098425197null1997-08-06 00:00:00
null01997-09-26 00:00:00
0null1997-12-19 00:00:00
0.997455471null1997-12-28 00:00:00
null01998-02-16 00:00:00
null11998-03-22 00:00:00
0.147727273null1998-05-05 00:00:00
null0.3013698631998-12-11 00:00:00
0.998065764null1999-07-23 00:00:00
0.378640777null1999-08-31 00:00:00
0null1999-10-31 00:00:00
null0.9947089951999-12-24 00:00:00
null0.0558659222000-01-30 00:00:00
1null2000-03-05 00:00:00
0null2000-04-19 00:00:00
null0.9966442952000-05-25 00:00:00
null02000-08-23 00:00:00
0.536312849null2000-10-31 00:00:00
null0.991228072000-11-20 00:00:00
null12001-08-24 00:00:00
0null2001-09-11 00:00:00
null02001-11-12 00:00:00
0null2002-01-28 00:00:00
0.228915663null2002-04-15 00:00:00
0null2002-05-25 00:00:00
0null2002-07-01 00:00:00
0.009708738null2003-03-06 00:00:00
0.008547009null2003-07-08 00:00:00
0.130434783null2003-12-25 00:00:00
0null2004-01-03 00:00:00
0null2005-02-03 00:00:00
0.982248521null2005-04-20 00:00:00
null12005-08-02 00:00:00
0null2005-08-14 00:00:00
0.591836735null2005-08-23 00:00:00
0.153846154null2005-09-05 00:00:00
0null2005-10-22 00:00:00
1null2005-12-08 00:00:00
null02006-05-03 00:00:00
null0.3694581282006-07-09 00:00:00
0.043478261null2006-09-29 00:00:00
0.085714286null2006-10-29 00:00:00
0null2007-01-01 00:00:00
0.842857143null2007-03-07 00:00:00
0null2007-05-05 00:00:00
null02007-07-17 00:00:00
1null2008-01-17 00:00:00
null0.9779411762008-05-30 00:00:00
null0.850467292008-06-10 00:00:00
0.244444444null2008-08-24 00:00:00
0null2008-09-14 00:00:00
null12009-01-15 00:00:00
0.932835821null2009-02-25 00:00:00
null02009-06-01 00:00:00
0null2061-02-15 00:00:00
0null2062-03-01 00:00:00
0.015151515null2062-06-03 00:00:00
0null2062-06-22 00:00:00
0null2062-11-27 00:00:00
0null2063-12-08 00:00:00
0.05952381null2064-05-11 00:00:00
0.048null2065-05-20 00:00:00
0null2065-06-25 00:00:00
1null2065-06-28 00:00:00
0.964285714null2065-12-04 00:00:00
0null2066-01-24 00:00:00
0null2066-02-04 00:00:00
0null2066-03-05 00:00:00
0null2067-07-19 00:00:00
0.960629921null2068-04-08 00:00:00
0.0390625null2068-04-20 00:00:00

Share link

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