CARVIEW |
Select Language
HTTP/2 200
date: Sat, 19 Jul 2025 19:22:56 GMT
content-type: text/html; charset=utf-8
vary: X-PJAX, X-PJAX-Container, Turbo-Visit, Turbo-Frame, X-Requested-With,Accept-Encoding, Accept, X-Requested-With
etag: W/"6520b681226f8cbe4e6aab7b4de6fe73"
cache-control: max-age=0, private, must-revalidate
strict-transport-security: max-age=31536000; includeSubdomains; preload
x-frame-options: deny
x-content-type-options: nosniff
x-xss-protection: 0
referrer-policy: no-referrer-when-downgrade
content-security-policy: default-src 'none'; base-uri 'self'; child-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/; connect-src 'self' uploads.github.com www.githubstatus.com collector.github.com raw.githubusercontent.com api.github.com github-cloud.s3.amazonaws.com github-production-repository-file-5c1aeb.s3.amazonaws.com github-production-upload-manifest-file-7fdce7.s3.amazonaws.com github-production-user-asset-6210df.s3.amazonaws.com *.rel.tunnels.api.visualstudio.com wss://*.rel.tunnels.api.visualstudio.com objects-origin.githubusercontent.com copilot-proxy.githubusercontent.com proxy.individual.githubcopilot.com proxy.business.githubcopilot.com proxy.enterprise.githubcopilot.com *.actions.githubusercontent.com wss://*.actions.githubusercontent.com productionresultssa0.blob.core.windows.net/ productionresultssa1.blob.core.windows.net/ productionresultssa2.blob.core.windows.net/ productionresultssa3.blob.core.windows.net/ productionresultssa4.blob.core.windows.net/ productionresultssa5.blob.core.windows.net/ productionresultssa6.blob.core.windows.net/ productionresultssa7.blob.core.windows.net/ productionresultssa8.blob.core.windows.net/ productionresultssa9.blob.core.windows.net/ productionresultssa10.blob.core.windows.net/ productionresultssa11.blob.core.windows.net/ productionresultssa12.blob.core.windows.net/ productionresultssa13.blob.core.windows.net/ productionresultssa14.blob.core.windows.net/ productionresultssa15.blob.core.windows.net/ productionresultssa16.blob.core.windows.net/ productionresultssa17.blob.core.windows.net/ productionresultssa18.blob.core.windows.net/ productionresultssa19.blob.core.windows.net/ github-production-repository-image-32fea6.s3.amazonaws.com github-production-release-asset-2e65be.s3.amazonaws.com insights.github.com wss://alive.github.com api.githubcopilot.com api.individual.githubcopilot.com api.business.githubcopilot.com api.enterprise.githubcopilot.com; font-src github.githubassets.com; form-action 'self' github.com gist.github.com copilot-workspace.githubnext.com objects-origin.githubusercontent.com; frame-ancestors 'none'; frame-src viewscreen.githubusercontent.com notebooks.githubusercontent.com; img-src 'self' data: blob: github.githubassets.com media.githubusercontent.com camo.githubusercontent.com identicons.github.com avatars.githubusercontent.com private-avatars.githubusercontent.com github-cloud.s3.amazonaws.com objects.githubusercontent.com release-assets.githubusercontent.com secured-user-images.githubusercontent.com/ user-images.githubusercontent.com/ private-user-images.githubusercontent.com opengraph.githubassets.com copilotprodattachments.blob.core.windows.net/github-production-copilot-attachments/ github-production-user-asset-6210df.s3.amazonaws.com customer-stories-feed.github.com spotlights-feed.github.com objects-origin.githubusercontent.com *.githubusercontent.com; manifest-src 'self'; media-src github.com user-images.githubusercontent.com/ secured-user-images.githubusercontent.com/ private-user-images.githubusercontent.com github-production-user-asset-6210df.s3.amazonaws.com gist.github.com; script-src github.githubassets.com; style-src 'unsafe-inline' github.githubassets.com; upgrade-insecure-requests; worker-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/
server: github.com
content-encoding: gzip
accept-ranges: bytes
set-cookie: _gh_sess=Ca0xZ0Gxbh%2BPvdSXT987RGaWR4%2FBdgg8wBAn4lh7gdUPeZ9Wobxb8Ktcg2oeAQn5oLIwrb%2FRHVAXCUKM4zRnv%2Fvsm8IwovrtKLuovoDynsa%2Bdzc7Rb0AlzHqdpa4Is5cGGsZP31RmJph%2B95HTIMRaasC9r%2Fv5v2XILJy%2B6LHMDtoImo%2Fbrs4K8nImXZxsLKGHmKgDXdaG9VUiJHj8XqFdfc%2BGJFHI3PVTVwGSovidQ8c7%2FCJ9NNrtA%2B01J9WheMZvtq1fWMRTlK3WTZi3oBv4w%3D%3D--4S3n0ICvMhzyndz6--llTrP7lfkk1urVWit4HQ3w%3D%3D; Path=/; HttpOnly; Secure; SameSite=Lax
set-cookie: _octo=GH1.1.133847953.1752952976; Path=/; Domain=github.com; Expires=Sun, 19 Jul 2026 19:22:56 GMT; Secure; SameSite=Lax
set-cookie: logged_in=no; Path=/; Domain=github.com; Expires=Sun, 19 Jul 2026 19:22:56 GMT; HttpOnly; Secure; SameSite=Lax
x-github-request-id: BBB4:0A55:4F9C78:63720A:687BF090
d3.js · AlaSQL/alasql Wiki · GitHub
Skip to content
Navigation Menu
{{ message }}
-
Notifications
You must be signed in to change notification settings - Fork 680
d3.js
Mathias Rangel Wulff edited this page Sep 7, 2017
·
7 revisions
AlaSQL plays nice with d3.js to create diagrams from complex data queries.
In this example AlaSQL reads an Excel file with Olympic Prizes, group and sort rows, and then take top 10 records and create a list with axe values:
function graph(axe) {
alasql(['SELECT TOP 10 '+axe+', SUM([Gold Medals]) AS Gold, \
SUM([Silver Medals]) AS Silver, SUM([Bronze Medals]) AS Bronze \
FROM XLSX("medals.xlsx",{headers:true}) \
GROUP BY '+axe+' ORDER BY '+axe]).then(function(data){
d3.select("body")
.append('ul')
.data(data)
.entry()
.append('li')
.text(function(d){return d[axe]});
});
}
graph('Axe');
See a simple example of AlaSQL + d3.js integration.
alasql(['SELECT * FROM xlsx("https://cdn.rawgit.com/agershun/alasql-org/gh-pages/demo/014map/cities.xlsx")']).then(function(data){
g.selectAll("text")
.data(data)
.enter()
.append('text')
.text(function(d){return d.city})
.attr("x", function(d) {
return projection([d.lon, d.lat])[0];
})
.attr("y", function(d) {
return projection([d.lon, d.lat])[1];
})
});
See the full code of this example in jsFiddle.
© 2014-2024, Andrey Gershun & Mathias Rangel Wulff
Please help improve the documentation by opening a PR on the wiki repo
Clone this wiki locally
You can’t perform that action at this time.