Public
Edited
Apr 5, 2024
Fork of SQL + Chart
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
all_orgs_merged_20240120.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
await console.log("data", all_orgs_merged_20240120)
Insert cell
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT stargazers_count FROM all_orgs_merged_20240120 WHERE stargazers_count >2
Insert cell
Insert cell
Plot.plot({
caption: "What are the stargazers count?",
x: {
transform: d => d ,
label: "stargazers count",
},
marks: [
Plot.ruleY([0]),
Plot.rectY(query, Plot.binX({y: "sum"}, {x: "stargazers_count",domain: [0, 9000],thresholds: d3.range(1, 300)}))
]
})
Insert cell
Insert cell
all_orgs_merged_20240120.csv
SELECT * FROM all_orgs_merged_20240120 WHERE stargazers_count >20
Insert cell
Plot.plot({
y: {grid: true},
color: {legend: true},
marks: [
Plot.rectY(query_2, Plot.binX({y: "count"}, {x: "stargazers_count", fill: "subscribers_count"})),
Plot.ruleY([0])
]
})
Insert cell
Insert cell
all_orgs_merged_20240120.csv
SELECT * FROM all_orgs_merged_20240120 WHERE stargazers_count >10000
Insert cell
Insert cell
all_orgs_merged_20240120.csv
SELECT * FROM all_orgs_merged_20240120 WHERE stargazers_count > 10000 AND forks_count < 1000;
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT * FROM all_orgs_merged_20240120 WHERE forks_count > 200 AND stargazers_count < 1000
Insert cell
Plot.plot({
marks: [
Plot.dot(high_forks_lower_stars, {x: "forks_count", y: "stargazers_count"})
]
})
Insert cell
Insert cell
Insert cell
Plot.plot({
marks: [
Plot.dot(all_orgs_merged_20240120, {x: "forks_count", y: "stargazers_count"})
]
})
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT * FROM all_orgs_merged_20240120 WHERE forks_count < 200 AND stargazers_count < 1000
Insert cell

Plot.plot({
marks: [
Plot.dot(lowerStarsAndForks, {x: "forks_count", y: "stargazers_count"})
]
})
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT COUNT(*) FROM all_orgs_merged_20240120
Insert cell
all_orgs_merged_20240120
SELECT DISTINCT(owner) FROM all_orgs_merged_20240120
Insert cell
all_orgs_merged_20240120
SELECT DISTINCT(topics) FROM all_orgs_merged_20240120
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT DISTINCT(homepage) FROM all_orgs_merged_20240120 WHERE owner == 'nasa' AND homepage LIKE '%https://nasa.github.io%';
Insert cell
all_orgs_merged_20240120
SELECT MIN(forks_count), MAX(forks_count), SUM(forks_count), owner FROM all_orgs_merged_20240120 GROUP BY owner
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT source_name, full_name, description, stargazers_count, forks_count, archived FROM all_orgs_merged_20240120 WHERE source_name IS NOT NULL AND source_name != ''
Insert cell
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT source_name, full_name, description, stargazers_count, forks_count, owner, archived FROM all_orgs_merged_20240120 WHERE source_name IS NOT NULL AND source_name != '' AND archived == true
Insert cell
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT COUNT(full_name), owner FROM all_orgs_merged_20240120 WHERE "metadata.files.license" == '' GROUP BY owner
Insert cell
all_orgs_merged_20240120
SELECT source_name, full_name, "metadata.files.license", description, stargazers_count, forks_count, owner, archived, created_at FROM all_orgs_merged_20240120 WHERE "metadata.files.license" == ''
Insert cell
Insert cell
Insert cell
all_orgs_merged_20240120
SELECT source_name, full_name, "metadata.files.license", description, owner, archived, created_at, updated_at, stargazers_count, forks_count, FROM all_orgs_merged_20240120 WHERE "metadata.files.license" == '' AND owner == 'nasa'
Insert cell
Insert cell
Plot.plot({
y: {grid: true},
color: {legend: true},
marks: [
Plot.rectY(nasaNoLicenseA, Plot.binX({y: "count"}, {x: "created_at", fill: "stargazers_count"})),
Plot.ruleY([0])
]
})
Insert cell
Insert cell
Plot.plot({
y: {grid: true},
color: {legend: true},
marks: [
Plot.rectY(all_orgs_merged_20240120, Plot.binX({y: "count"}, {x: "created_at", fill: "stargazers_count"})),
Plot.ruleY([0])
]
})
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more