Communicating (Data) Science
Reports & Dashboards
Collaborating
Astro 497, Week 12, Monday
TableOfContents()
Reports
You (or your team) performed a detailed analysis.
A report shares your conclusions and recommendations with others.
Who are you reporting to?
Your team members (e.g., regular group meeting)
A wider collaboration (e.g., internal white paper, annual collaboration meeting)
Experts beyond your collaboration (e.g., journal article, scientific meeting)
Funding agency (e.g., progress/final grant report)
General public (e.g., press release, funding agency)
Planning committee (e.g., white paper for decadal survey)
What are you aiming to accomplish from the report?
Stimulate suggestions for how to solve current roadblock
Provide documentation for team members to build on your results
Help identify future opportunities for connections to other researchers/projects
Get critical feedback to identify weak points of analysis
Provide documentation to justify continued/increased support for project
Prepare report to advance specific goals
Use the knowledge gained from performing a detailed analysis positions
Narrative & choice of figures (in report body) directly support report's goals
Typical Scientific Report Structure
Summary of Conclusions/Recommendations
Abstract
Executive Summary
Opening paragraphs "above the fold"
Context:
Why did you do this work?
Problem or unmet need
Previous studies left unanswered question
What other information is needed to understand your approach and results?
Why did you choose this approach, as opposed to alternatives?
Describe Input Data
Where did data come from?
How was data collected?
What is known (or unknown) about quality of data?
What concerns about data should be kept in mind?
Describe Data Analysis & Outputs
How were data analyzed?
What are the outputs of the analysis?
Sometimes includes limited straight-forward results
Interpret Data
Explain rationale for each conclusion/recommendation
Conclusions/Recommendations
Concise summary
What comes next?
Motivate what you want to do next
Inspire others to contribute
Appendices
Supporting Data, Tables, Figures, Codes
More details about Analysis Methods & Implementation Details
Describe checks that were performed and passed
Pros of Typical Written Scientific Report
Provides details needed to understand, evaluate and/or build on results
Great for referring back to long after report was prepared
Sense of accomplishment from finishing a project
Cons of Typical Written Scientific Report
Can take significant time to prepare
Can take significant time to understand
Easy to overlook important elements "buried" in a long report
Readers may skim/skip over parts
Often "dry"
Oral Report/Presentations
Summarizes key elements of written report
Refers to written report for details (e.g., data, methodology, analysis, complete list of assumptions/caveats)
Should still highlight most important assumptions/caveats
Best presentations tell a story
Easier to maintain audience's attention
More likely to be remembered
Dashboard
Goal: Efficiently communicate what can be learned from data
Support people in making future decisions
Won't represent the best-possible analysis
Automates performing common tasks & analysis
Needs to be robust & capable of handling corner cases gracefully
Pros of Dashboard
Enables people to gain insights efficiently
Accelerate science
Reduce errors by automating routine steps
Allows team members to focus on other steps
Can integrates expertise from multiple team members
Cons of Dashboard
Takes significant time to make pipeline robust
Takes significant time to design effective visualizations
May not be able to refer back to dashboard's state at previous time
Takes time/knowledge to keep running smoothly
Often want to update dashboard (repeatedly) as needs change
Risks oversimplifying complex cases
Can contribute to leaders becoming overconfident
Key Differences between a Report & a Dashboard
Reports | Dashboards |
---|---|
Static | Dynamic |
Reviewed & Proofed | Rely on previous tests |
Explanatory | Exploratory |
Tailored to support message | Effective for any incoming data |
Help reader reach your conclusion | Help viewer form hypothesis |
Examples of Dashboards at Penn State
Dashboards aim to
Reduce cognitive load of viewer...
but provide all information necessary
Anticipate questions that viewers will have...
but questions change with time/new data
Be flexible enough to deal with whatever data comes in...
but incoming data changes with time
Data Disagregation & Drilldown
Show Drilldown Plots
if drilldown_plots
md"""
Discovery Method: $(@bind disc_method_idx Select(0:length(keys(df_by_method)) .=> vcat("All",map(k->k.discoverymethod,keys(df_by_method)))))
"""
end
if drilldown_plots
let
plt = plot() # histogram(df.disc_year, legend=:none)
if disc_method_idx >= 1
local df_plt = df_by_method[disc_method_idx]
histogram!(plt, df_plt.disc_year, bin=range(2000,stop=2022), legend=:none )
end
end
end
if drilldown_plots
let
plt = plot() #xscale=:log10, yscale=:log10, legend=:none)
histogram!(plt, df.disc_year, markersize=1, markerstrokewidth=0)
xlabel!("Period (d)")
ylabel!("Radius (Rⱼ)")
if disc_method_idx >= 1
local df_plt = df_by_method[disc_method_idx]
scatter!(df_plt.pl_orbper,df_plt.pl_radj, markersize=1, markerstrokewidth=0, markercolor=3)
end
end
end
if drilldown_plots && disc_method_idx >= 1
df_plt = df_by_method[disc_method_idx]
scatter(df_plt.pl_orbper,df_plt.pl_radj)
end
Collaborating
Asynchronous
Write separate files/functions/modules
Maintain independent repositories
Merge changes via git
Create branches for new features, so main branch is always usable
Synchronous
Like asynchronous, but ask questions as you go
Pair Coding: Driver & Navigator
Debugging: Explainer & Audience
Beware of using shared filesystem
Tools
Merging updates: Git
Sharing screen: Zoom, Teams, Virtual Desktop
Collaborative coding: VS Code/VS Codium, Repl.it, Google Colab
Setup/Helper Code
ChooseDisplayMode()
begin
using PlutoUI, PlutoTeachingTools
using CSV, DataFrames, Plots
end
begin
query_base_url = "https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query="
query_table = "ps"
query_where = "default_flag=1"
query_max_rows = 10_000
url_to_use = make_tap_query_url(query_base_url, query_table, where=query_where, max_rows=query_max_rows)
end;
begin
datadir = joinpath(pwd(),"data")
mkpath(datadir)
filename = "nexsci_ps.tsv"
datapath = joinpath(datadir,filename)
end;
begin
if !isfile(datapath) || filesize(datapath)==0
Downloads.download(url_to_use, datapath)
fresh_data = true
else
fresh_data = false
end
#@test filesize(datapath) >0
end
false
begin
fresh_data
df_raw = CSV.read(datapath,DataFrame)
end;
begin
# Create new Dataframe that eliminates columns that have names ending in "str"
colnames_ending_in_str = filter(x->contains(x,r"str$"), names(df_raw) )
df = select(df_raw,Not(Symbol.(colnames_ending_in_str)))
# Convert columns containing HTML into HTML
df.sy_refname = HTML.(df.sy_refname)
df.disc_refname = HTML.(df.disc_refname)
df.pl_refname = HTML.(df.pl_refname)
df
end;
unique(df.discoverymethod)
11-element Vector{String31}: "Transit" "Radial Velocity" "Imaging" "Astrometry" "Microlensing" "Transit Timing Variations" "Orbital Brightness Modulation" "Eclipse Timing Variations" "Pulsar Timing" "Pulsation Timing Variations" "Disk Kinematics"
df_by_method = groupby(df,:discoverymethod)
GroupedDataFrame with 11 groups based on key: discoverymethod
Row | pl_name | pl_letter | hostname | hd_name | hip_name | tic_id | gaia_id | default_flag | pl_refname | sy_refname | disc_pubdate | disc_year | discoverymethod | disc_locale | disc_facility | disc_instrument | disc_telescope | disc_refname | ra | dec | glon | glat | elon | elat | pl_orbper | pl_orbpererr1 | pl_orbpererr2 | pl_orbperlim | pl_orblpererr1 | pl_orblper | pl_orblpererr2 | pl_orblperlim | pl_orbsmax | pl_orbsmaxerr1 | pl_orbsmaxerr2 | pl_orbsmaxlim | pl_orbincl | pl_orbinclerr1 | pl_orbinclerr2 | pl_orbincllim | pl_orbtper | pl_orbtpererr1 | pl_orbtpererr2 | pl_orbtperlim | pl_orbeccen | pl_orbeccenerr1 | pl_orbeccenerr2 | pl_orbeccenlim | pl_eqt | pl_eqterr1 | pl_eqterr2 | pl_eqtlim | pl_occdep | pl_occdeperr1 | pl_occdeperr2 | pl_occdeplim | pl_insol | pl_insolerr1 | pl_insolerr2 | pl_insollim | pl_dens | pl_denserr1 | pl_denserr2 | pl_denslim | pl_trandep | pl_trandeperr1 | pl_trandeperr2 | pl_trandeplim | pl_tranmid | pl_tranmiderr1 | pl_tranmiderr2 | pl_tranmidlim | pl_trandur | pl_trandurerr1 | pl_trandurerr2 | pl_trandurlim | sy_umag | sy_umagerr1 | sy_umagerr2 | sy_rmag | sy_rmagerr1 | sy_rmagerr2 | sy_imag | sy_imagerr1 | sy_imagerr2 | sy_zmag | sy_zmagerr1 | sy_zmagerr2 | sy_w1mag | sy_w1magerr1 | sy_w1magerr2 | sy_w2mag | sy_w2magerr1 | sy_w2magerr2 | sy_w3mag | sy_w3magerr1 | sy_w3magerr2 | sy_w4mag | sy_w4magerr1 | sy_w4magerr2 | ⋯ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
String31 | String1 | String31 | String15 | String15 | String15 | String31 | Int64 | HTML… | HTML… | String15 | Int64 | String31 | String31 | String | String | String | HTML… | Float64 | Float64 | Float64 | Float64 | Float64 | Float64 | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | ⋯ | |
1 | OGLE-TR-10 b | b | OGLE-TR-10 | missing | missing | TIC 130150682 | Gaia DR2 4056443366649948160 | 1 | HTML{String}("<a refstr=TORRES_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008ApJ...677.1324T/abstract target=ref> Torres et al. 2008 </a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2005-05 | 2004 | Transit | Ground | OGLE | OGLE CCD Array | 1.3 m Warsaw University Telescope | HTML{String}("<a refstr=KONACKI_ET_AL__2005 href=https://ui.adsabs.harvard.edu/abs/2005ApJ...624..372K/abstract target=ref> Konacki et al. 2005 </a>") | 267.868 | -29.8765 | 359.851 | -1.57666 | 268.139 | -6.45096 | 3.10128 | missing | missing | 0 | missing | missing | missing | missing | 0.0434 | 0.0013 | -0.0015 | 0 | 90.0 | 0.0 | -3.9 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 0.4 | 0.18 | -0.12 | 0 | 1.21 | 0.044 | -0.044 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | ⋯ |
2 | Kepler-17 b | b | Kepler-17 | missing | missing | TIC 273874849 | Gaia DR2 2086449761846310784 | 1 | HTML{String}("<a refstr=DESERT_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJS..197...14D/abstract target=ref> Désert et al. 2011 </a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2011-11 | 2011 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=DESERT_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJS..197...14D/abstract target=ref> Désert et al. 2011 </a>") | 298.395 | 47.815 | 81.8249 | 10.2417 | 322.252 | 66.1797 | 1.48571 | 2.0e-7 | -2.0e-7 | 0 | missing | missing | missing | missing | 0.02591 | 0.00037 | -0.00036 | 0 | 87.2 | 0.15 | -0.15 | 0 | missing | missing | missing | missing | 0.011 | missing | missing | 1 | 1570.0 | 200.0 | -200.0 | 0 | 0.0058 | 0.001 | -0.001 | 0 | missing | missing | missing | missing | 1.35 | 0.08 | -0.08 | 0 | missing | missing | missing | missing | 2.45519e6 | 2.3e-5 | -2.6e-5 | 0 | 2.2764 | 0.00168 | -0.00168 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 12.55 | 0.023 | -0.023 | 12.594 | 0.022 | -0.022 | 12.291 | 0.216 | -0.216 | 8.715 | missing | missing | ⋯ |
3 | Kepler-24 c | c | Kepler-24 | missing | missing | TIC 122376177 | Gaia DR2 2052823535171095296 | 1 | HTML{String}("<a refstr=FORD_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..113F/abstract target=ref> Ford et al. 2012 </a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2012-05 | 2011 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=FORD_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..113F/abstract target=ref> Ford et al. 2012 </a>") | 290.413 | 38.3437 | 70.5499 | 11.0183 | 302.608 | 59.4935 | 12.3335 | missing | missing | 0 | missing | missing | missing | missing | 0.106 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45497e6 | missing | missing | 0 | 3.71 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 13.249 | 0.025 | -0.025 | 13.261 | 0.027 | -0.027 | 12.401 | 0.326 | -0.326 | 8.701 | missing | missing | ⋯ |
4 | Kepler-32 b | b | Kepler-32 | missing | missing | TIC 273590427 | Gaia DR2 2080287892525359872 | 1 | HTML{String}("<a refstr=FABRYCKY_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..114F/abstract target=ref> Fabrycky et al. 2012 </a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2012-05 | 2011 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=FABRYCKY_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..114F/abstract target=ref> Fabrycky et al. 2012 </a>") | 297.842 | 46.5744 | 80.5392 | 9.96232 | 320.064 | 65.2468 | 5.90124 | 0.0001 | -0.0001 | 0 | missing | missing | missing | missing | 0.05 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 0.165 | missing | missing | 0 | 2.45497e6 | 0.008 | -0.008 | 0 | 2.112 | 0.12 | -0.12 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 12.57 | 0.023 | -0.023 | 12.6 | 0.024 | -0.024 | 12.55 | 0.357 | -0.357 | 9.418 | missing | missing | ⋯ |
5 | Kepler-370 c | c | Kepler-370 | missing | missing | TIC 137411225 | Gaia DR2 2053578521704124160 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 292.171 | 40.9162 | 73.51 | 10.9429 | 306.776 | 61.5546 | 19.0229 | 0.000177 | -0.000177 | 0 | missing | missing | missing | missing | 0.14 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45497e6 | 0.0054 | -0.0054 | 0 | 3.418 | 0.155 | -0.155 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 13.559 | 0.026 | -0.026 | 13.616 | 0.033 | -0.033 | 12.329 | missing | missing | 9.135 | missing | missing | ⋯ |
6 | Kepler-400 b | b | Kepler-400 | missing | missing | TIC 122707140 | Gaia DR2 2101510008826160256 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 290.944 | 40.4801 | 72.6919 | 11.5843 | 304.642 | 61.4242 | 9.02439 | 3.4e-5 | -3.4e-5 | 0 | missing | missing | missing | missing | 0.087 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45497e6 | 0.00239 | -0.00239 | 0 | 3.128 | 0.072 | -0.072 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 12.203 | 0.023 | -0.023 | 12.232 | 0.023 | -0.023 | 12.044 | 0.228 | -0.228 | 8.359 | 0.206 | -0.206 | ⋯ |
7 | Kepler-221 b | b | Kepler-221 | missing | missing | TIC 272601375 | Gaia DR2 2080344586094498432 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 296.655 | 46.8352 | 80.3729 | 10.8017 | 318.574 | 65.8393 | 2.79591 | 4.0e-6 | -4.0e-6 | 0 | missing | missing | missing | missing | 0.037 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45497e6 | 0.00084 | -0.00084 | 0 | 2.064 | 0.029 | -0.029 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 11.868 | 0.023 | -0.023 | 11.902 | 0.022 | -0.022 | 12.157 | 0.217 | -0.217 | 9.271 | 0.466 | -0.466 | ⋯ |
8 | Kepler-367 c | c | Kepler-367 | missing | missing | TIC 28159518 | Gaia DR2 2087250476887856256 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 297.293 | 49.9817 | 83.4033 | 11.9213 | 323.315 | 68.4274 | 53.5786 | 0.000382 | -0.000382 | 0 | missing | missing | missing | missing | 0.253 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.455e6 | 0.00434 | -0.00434 | 0 | 5.236 | 0.128 | -0.128 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 10.589 | 0.023 | -0.023 | 10.659 | 0.02 | -0.02 | 10.668 | 0.067 | -0.067 | 9.519 | missing | missing | ⋯ |
9 | Kepler-393 c | c | Kepler-393 | missing | missing | TIC 159580535 | Gaia DR2 2127390970655877888 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 290.995 | 45.1922 | 77.0676 | 13.5768 | 308.15 | 65.8735 | 14.6136 | 0.000231 | -0.000231 | 0 | missing | missing | missing | missing | 0.124 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45497e6 | 0.00736 | -0.00736 | 0 | 5.401 | 0.191 | -0.191 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 12.002 | 0.064 | -0.064 | 12.029 | 0.058 | -0.058 | 12.023 | missing | missing | 9.277 | missing | missing | ⋯ |
10 | Kepler-304 c | c | Kepler-304 | missing | missing | TIC 377909730 | Gaia DR2 2076565805151925760 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 294.442 | 40.5575 | 73.9863 | 9.2491 | 309.902 | 60.6552 | 5.31595 | 7.0e-6 | -7.0e-6 | 0 | missing | missing | missing | missing | 0.054 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45497e6 | 0.00085 | -0.00085 | 0 | 1.114 | 0.033 | -0.033 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 12.464 | 0.023 | -0.023 | 12.54 | 0.024 | -0.024 | 12.212 | 0.267 | -0.267 | 9.203 | 0.417 | -0.417 | ⋯ |
11 | Kepler-360 b | b | Kepler-360 | missing | missing | TIC 158213532 | Gaia DR2 2106316012810255104 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 286.285 | 44.7816 | 75.2999 | 16.4666 | 299.988 | 66.5336 | 3.28967 | 1.2e-5 | -1.2e-5 | 0 | missing | missing | missing | missing | 0.044 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45496e6 | 0.00213 | -0.00213 | 0 | 2.312 | 0.068 | -0.068 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 13.207 | 0.023 | -0.023 | 13.259 | 0.026 | -0.026 | 12.647 | 0.325 | -0.325 | 9.493 | missing | missing | ⋯ |
12 | Kepler-243 c | c | Kepler-243 | missing | missing | TIC 164886497 | Gaia DR2 2104090257679181696 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 285.11 | 42.034 | 72.3127 | 16.2214 | 296.312 | 64.0993 | 20.0262 | 0.000163 | -0.000163 | 0 | missing | missing | missing | missing | 0.142 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45498e6 | 0.00404 | -0.00404 | 0 | 1.319 | 0.16 | -0.16 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 13.022 | 0.023 | -0.023 | 13.098 | 0.023 | -0.023 | 12.615 | missing | missing | 9.474 | missing | missing | ⋯ |
13 | Kepler-261 c | c | Kepler-261 | missing | missing | TIC 137148674 | Gaia DR2 2052528625536778624 | 1 | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2014-03 | 2014 | Transit | Space | Kepler | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>") | 291.365 | 37.6092 | 70.2185 | 10.0204 | 303.615 | 58.5807 | 24.5709 | 6.9e-5 | -6.9e-5 | 0 | missing | missing | missing | missing | 0.156 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45497e6 | 0.00159 | -0.00159 | 0 | 2.761 | 0.052 | -0.052 | 0 | 16.126 | 0.0061588 | -0.0061588 | 12.1978 | 0.0022747 | -0.0022747 | 15.7464 | 0.0135906 | -0.0135906 | 13.1533 | 0.0036238 | -0.0036238 | 11.537 | 0.022 | -0.022 | 11.61 | 0.021 | -0.021 | 11.677 | 0.178 | -0.178 | 8.721 | missing | missing | ⋯ |
⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋱ |
3868 | K2-387 b | b | K2-387 | missing | missing | TIC 376938120 | Gaia DR2 2580505553613124992 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 19.4418 | 11.3685 | 133.214 | -50.9769 | 22.2281 | 2.92623 | 28.7353 | 0.000992 | -0.000994 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.4574e6 | 0.0011 | -0.0011 | 0 | missing | missing | missing | missing | 19.8276 | 0.0406685 | -0.0406685 | 15.6964 | 0.0044987 | -0.0044987 | 14.7663 | 0.0045757 | -0.0045757 | 14.4117 | 0.0046616 | -0.0046616 | 12.183 | 0.023 | -0.023 | 12.175 | 0.024 | -0.024 | 12.189 | 0.354 | -0.354 | 9.087 | missing | missing | ⋯ |
3869 | K2-368 d | d | K2-368 | missing | missing | TIC 38136597 | Gaia DR2 2613924969021549440 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 332.636 | -11.1661 | 47.8861 | -49.0228 | 330.609 | 0.09746 | 20.2011 | 0.002354 | -0.002736 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45699e6 | 0.0026 | -0.0018 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 10.99 | 0.023 | -0.023 | 11.03 | 0.021 | -0.021 | 10.935 | 0.147 | -0.147 | 8.173 | missing | missing | ⋯ |
3870 | K2-378 b | b | K2-378 | missing | missing | TIC 741119 | Gaia DR2 3616517223789495424 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 205.16 | -11.1172 | 321.883 | 49.9354 | 207.353 | -0.62842 | 2.06044 | 0.000118 | -7.4e-5 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45722e6 | 0.0018 | -0.0034 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 13.317 | 0.024 | -0.024 | 13.367 | 0.029 | -0.029 | 12.502 | 0.446 | -0.446 | 8.591 | missing | missing | ⋯ |
3871 | K2-381 c | c | K2-381 | missing | missing | TIC 10195089 | Gaia DR2 4081376064109034496 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 288.027 | -21.0076 | 16.1314 | -13.7859 | 286.797 | 1.38671 | 16.0347 | 0.001844 | -0.001572 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.4573e6 | 0.003 | -0.0027 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 10.241 | 0.024 | -0.024 | 10.273 | 0.022 | -0.022 | 10.106 | 0.113 | -0.113 | 7.741 | missing | missing | ⋯ |
3872 | K2-367 b | b | K2-367 | missing | missing | TIC 12821302 | Gaia DR2 2601048588348190976 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 337.859 | -13.2645 | 48.862 | -54.5087 | 334.613 | -3.70355 | 20.6451 | 0.000995 | -0.001375 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.457e6 | 0.002 | -0.0014 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 10.873 | 0.024 | -0.024 | 10.933 | 0.021 | -0.021 | 10.994 | 0.12 | -0.12 | 8.916 | missing | missing | ⋯ |
3873 | EPIC 206317286 b | b | EPIC 206317286 | missing | missing | TIC 250956593 | Gaia DR2 2621545958991110144 | 1 | HTML{String}("<a refstr=HELLER_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019A&A...627A..66H/abstract target=ref>Heller et al. 2019</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2019-07 | 2019 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=HELLER_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019A&A...627A..66H/abstract target=ref>Heller et al. 2019</a>") | 337.618 | -7.97246 | 56.1702 | -51.5448 | 336.343 | 1.30362 | 1.58252 | 0.00017 | -0.00018 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45701e6 | 0.0024 | -0.0024 | 0 | missing | missing | missing | missing | 16.678 | 0.0074948 | -0.0074948 | 13.694 | 0.002872 | -0.002872 | 13.4008 | 0.00244 | -0.00244 | 13.2274 | 0.002882 | -0.002882 | 11.591 | 0.023 | -0.023 | 11.66 | 0.022 | -0.022 | 11.902 | 0.274 | -0.274 | 8.892 | missing | missing | ⋯ |
3874 | K2-381 b | b | K2-381 | missing | missing | TIC 10195089 | Gaia DR2 4081376064109034496 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 288.027 | -21.0076 | 16.1314 | -13.7859 | 286.797 | 1.38671 | 7.93893 | 0.000596 | -0.000592 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.4573e6 | 0.0033 | -0.0063 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 10.241 | 0.024 | -0.024 | 10.273 | 0.022 | -0.022 | 10.106 | 0.113 | -0.113 | 7.741 | missing | missing | ⋯ |
3875 | WASP-189 b | b | WASP-189 | HD 133112 | HIP 73608 | TIC 157910432 | Gaia DR2 6339097679918871168 | 1 | HTML{String}("<a refstr=LENDL_ET_AL__2020 href=https://ui.adsabs.harvard.edu/abs/2020A&A...643A..94L/abstract target=ref>Lendl et al. 2020</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2020-11 | 2020 | Transit | Space | CHaracterising ExOPlanets Satellite (CHEOPS) | Teledyne e2v CCD detector | 0.3 m Ritchey-Chretien Telescope | HTML{String}("<a refstr=LENDL_ET_AL__2020 href=https://ui.adsabs.harvard.edu/abs/2020A&A...643A..94L/abstract target=ref>Lendl et al. 2020</a>") | 225.687 | -3.03149 | 354.491 | 46.2782 | 224.125 | 13.6331 | 2.72403 | missing | missing | 0 | missing | missing | missing | missing | 0.05053 | 0.00098 | -0.00098 | 0 | 84.03 | 0.14 | -0.14 | 0 | missing | missing | missing | missing | 0.0 | missing | missing | 0 | 3353.0 | 27.0 | -34.0 | 0 | 0.00879 | 0.00043 | -0.00043 | 0 | missing | missing | missing | missing | 0.62199 | 0.07692 | -0.03647 | 0 | missing | missing | missing | missing | 2.45893e6 | 6.5e-5 | -6.4e-5 | 0 | 4.3336 | 0.0054 | -0.0058 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 6.097 | 0.076 | -0.076 | 6.029 | 0.021 | -0.021 | 6.118 | 0.011 | -0.011 | 5.961 | 0.046 | -0.046 | ⋯ |
3876 | EPIC 206317286 c | c | EPIC 206317286 | missing | missing | TIC 250956593 | Gaia DR2 2621545958991110144 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 337.618 | -7.97246 | 56.1702 | -51.5448 | 336.343 | 1.30362 | 17.5155 | 0.002288 | -0.002965 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45698e6 | 0.0071 | -0.0031 | 0 | missing | missing | missing | missing | 16.678 | 0.0074948 | -0.0074948 | 13.694 | 0.002872 | -0.002872 | 13.4008 | 0.00244 | -0.00244 | 13.2274 | 0.002882 | -0.002882 | 11.591 | 0.023 | -0.023 | 11.66 | 0.022 | -0.022 | 11.902 | 0.274 | -0.274 | 8.892 | missing | missing | ⋯ |
3877 | K2-380 b | b | K2-380 | missing | missing | TIC 90605642 | Gaia DR2 4073600356552513280 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 283.435 | -26.5387 | 9.18589 | -12.2236 | 282.022 | -3.65837 | 9.40131 | 0.000469 | -0.000506 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.4573e6 | 0.002 | -0.0017 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 9.589 | 0.022 | -0.022 | 9.621 | 0.02 | -0.02 | 9.348 | 0.047 | -0.047 | 8.149 | 0.254 | -0.254 | ⋯ |
3878 | K2-365 b | b | K2-365 | missing | missing | TIC 220604190 | Gaia DR2 6246622017519183616 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 238.82 | -21.027 | 350.415 | 24.4485 | 241.1 | -0.66151 | 23.4482 | 0.000766 | -0.000996 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.4569e6 | 0.0019 | -0.0013 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 9.559 | 0.024 | -0.024 | 9.553 | 0.021 | -0.021 | 9.423 | 0.046 | -0.046 | 8.725 | 0.448 | -0.448 | ⋯ |
3879 | K2-368 b | b | K2-368 | missing | missing | TIC 38136597 | Gaia DR2 2613924969021549440 | 1 | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2022-03 | 2022 | Transit | Space | K2 | Kepler CCD Array | 0.95 m Kepler Telescope | HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>") | 332.636 | -11.1661 | 47.8861 | -49.0228 | 330.609 | 0.09746 | 5.0256 | 0.000287 | -0.000342 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 2.45698e6 | 0.0025 | -0.0027 | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 10.99 | 0.023 | -0.023 | 11.03 | 0.021 | -0.021 | 10.935 | 0.147 | -0.147 | 8.173 | missing | missing | ⋯ |
⋮
Row | pl_name | pl_letter | hostname | hd_name | hip_name | tic_id | gaia_id | default_flag | pl_refname | sy_refname | disc_pubdate | disc_year | discoverymethod | disc_locale | disc_facility | disc_instrument | disc_telescope | disc_refname | ra | dec | glon | glat | elon | elat | pl_orbper | pl_orbpererr1 | pl_orbpererr2 | pl_orbperlim | pl_orblpererr1 | pl_orblper | pl_orblpererr2 | pl_orblperlim | pl_orbsmax | pl_orbsmaxerr1 | pl_orbsmaxerr2 | pl_orbsmaxlim | pl_orbincl | pl_orbinclerr1 | pl_orbinclerr2 | pl_orbincllim | pl_orbtper | pl_orbtpererr1 | pl_orbtpererr2 | pl_orbtperlim | pl_orbeccen | pl_orbeccenerr1 | pl_orbeccenerr2 | pl_orbeccenlim | pl_eqt | pl_eqterr1 | pl_eqterr2 | pl_eqtlim | pl_occdep | pl_occdeperr1 | pl_occdeperr2 | pl_occdeplim | pl_insol | pl_insolerr1 | pl_insolerr2 | pl_insollim | pl_dens | pl_denserr1 | pl_denserr2 | pl_denslim | pl_trandep | pl_trandeperr1 | pl_trandeperr2 | pl_trandeplim | pl_tranmid | pl_tranmiderr1 | pl_tranmiderr2 | pl_tranmidlim | pl_trandur | pl_trandurerr1 | pl_trandurerr2 | pl_trandurlim | sy_umag | sy_umagerr1 | sy_umagerr2 | sy_rmag | sy_rmagerr1 | sy_rmagerr2 | sy_imag | sy_imagerr1 | sy_imagerr2 | sy_zmag | sy_zmagerr1 | sy_zmagerr2 | sy_w1mag | sy_w1magerr1 | sy_w1magerr2 | sy_w2mag | sy_w2magerr1 | sy_w2magerr2 | sy_w3mag | sy_w3magerr1 | sy_w3magerr2 | sy_w4mag | sy_w4magerr1 | sy_w4magerr2 | ⋯ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
String31 | String1 | String31 | String15 | String15 | String15 | String31 | Int64 | HTML… | HTML… | String15 | Int64 | String31 | String31 | String | String | String | HTML… | Float64 | Float64 | Float64 | Float64 | Float64 | Float64 | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Int64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | Float64? | ⋯ | |
1 | HD 97048 b | b | HD 97048 | HD 97048 | HIP 54413 | TIC 454291762 | Gaia DR2 5201128124701636864 | 1 | HTML{String}("<a refstr=PINTE_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019NatAs...3.1109P/abstract target=ref>Pinte et al. 2019</a>") | HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>") | 2019-08 | 2019 | Disk Kinematics | Ground | Atacama Large Millimeter Array (ALMA) | 12-m Array | Atacama Large Millimeter Array (ALMA) | HTML{String}("<a refstr=PINTE_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019NatAs...3.1109P/abstract target=ref>Pinte et al. 2019</a>") | 167.013 | -77.6549 | 297.37 | -15.914 | 238.837 | -66.2596 | missing | missing | missing | missing | missing | missing | missing | missing | 130.0 | missing | missing | 0 | 40.0 | missing | missing | 0 | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | missing | 4.474 | 0.029 | -0.029 | 4.467 | 0.1 | -0.1 | 1.34 | 0.015 | -0.015 | -1.32 | 0.005 | -0.005 | ⋯ |
"Returns a vector of strings with names of columns in DataFrame containing a variable of type."
function get_cols_containing_type(df::DataFrame, type::Type)
filter(c->eltype(df[!,c])<:Union{Missing,type}, names(df) )
end
"Returns a vector of strings with names of columns in DataFrame containing some form of string."
get_cols_containing_string(df) = get_cols_containing_type(df,AbstractString)
"Returns a vector of strings with names of columns in DataFrame containing some form of real number."
get_cols_containing_real(df) = get_cols_containing_type(df,Real)
"""
`make_tap_query_url(base_url, query_table; ...)`
Returns url for a Table Access Protocol (TAP) query.
Inputs:
- base url
- table name
Optional arguments:
- max_rows (all)
- select_cols (all)
- where (no requirement)
- order_by_cols (not sorted)
- format (tsv)
See [NExScI](https://exoplanetarchive.ipac.caltech.edu/docs/TAP/usingTAP.html#sync) or [Virtual Observatory](https://www.ivoa.net/documents/TAP/) for more info.
"""
function make_tap_query_url(query_base_url::String, query_table::String; max_rows::Integer = 0, select_cols::String = "", where::String = "", order_by_cols::String = "", format::String="tsv" )
query_select = "select"
if max_rows > 0
query_select *= "+top+" * string(max_rows)
end
if length(select_cols) >0
query_select *= "+" * select_cols
else
query_select *= "+*"
end
query_from = "+from+" * query_table
query_where = length(where)>0 ? "+where+" * where : ""
query_order_by = length(order_by_cols) > 0 ? "+order+by+" * order_by_cols : ""
query_format = "&format=" * format
url = query_base_url * query_select * query_from * query_where * query_order_by * query_format
end
Built with Julia 1.8.2 and
CSV 0.10.7DataFrames 1.4.2
Plots 1.35.8
PlutoTeachingTools 0.2.5
PlutoUI 0.7.48
To run this tutorial locally, download this file and open it with Pluto.jl.
To run this tutorial locally, download this file and open it with Pluto.jl.
To run this tutorial locally, download this file and open it with Pluto.jl.
To run this tutorial locally, download this file and open it with Pluto.jl.