Spaces:
Running
Running
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8" /> | |
| <link rel="icon" href="/favicon.ico" sizes="32x32" /> | |
| <link rel="icon" href="/icon.svg" type="image/svg+xml" /> | |
| <link rel="apple-touch-icon" href="/apple-touch-icon.png" /> | |
| <link rel="manifest" href="/manifest.webmanifest" /> | |
| <meta name="viewport" content="width=device-width, initial-scale=1" /> | |
| <script> | |
| try { | |
| /** @type {'light' | 'dark' | 'system'} */ | |
| const savedTheme = localStorage.getItem('evidence-theme') ?? 'system'; | |
| const prefersDark = window.matchMedia('(prefers-color-scheme: dark)').matches; | |
| const theme = savedTheme === 'system' ? (prefersDark ? 'dark' : 'light') : savedTheme; | |
| document.documentElement.setAttribute('data-theme', theme); | |
| } catch (e) {} | |
| </script> | |
| <link href="/_app/immutable/assets/0.DOZ2siFK.css" rel="stylesheet"> | |
| <link href="/_app/immutable/assets/VennDiagram.DBCXi1Yl.css" rel="stylesheet"> | |
| <link rel="modulepreload" href="/_app/immutable/entry/start.Cm-tlAbH.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/entry.CmEkywbK.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/scheduler.B2FSa8mv.js"> | |
| <link rel="modulepreload" href="/_app/immutable/entry/app.eVNqlex7.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/preload-helper.D7HrI6pR.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/index.CzNnnxDZ.js"> | |
| <link rel="modulepreload" href="/_app/immutable/nodes/0.kcWwAGgm.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/VennDiagram.svelte_svelte_type_style_lang.BvCrDgSx.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/index.rV6zwFgL.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/button.DfeRvuoX.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/arrays.DATw8jA9.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/stores.BQnhBgve.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/index.CqVitEmB.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/AccordionItem.BAM5BvX8.js"> | |
| <link rel="modulepreload" href="/_app/immutable/nodes/5.DjysBRZq.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/AreaMap.u3IdXB4f.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/Prismjs.DElG_ecN.js"> | |
| <link rel="modulepreload" href="/_app/immutable/chunks/await_block.Dveih0bk.js"><title>Evidence</title><!-- HEAD_svelte-6lktun_START --> <meta name="twitter:card" content="summary"><meta name="twitter:site" content="@evidence_dev"><!-- HEAD_svelte-6lktun_END --> | |
| </head> | |
| <body> | |
| <script> | |
| </script> | |
| <div> | |
| <!-- SvelteKit Hydrated Content --> | |
| <div class="z-[1] fixed right-0 bottom-0 mx-10 my-6 w-80"></div> <div data-sveltekit-preload-data="hover" class="antialiased"> <header class="fixed w-full top-0 z-40 flex h-12 shrink-0 justify-start items-center gap-x-4 border-b border-base-300/50 bg-base-100/90 backdrop-blur print:hidden "><div class=" max-w-7xl mx-auto px-6 sm:px-8 md:px-12 flex flex-1 items-center justify-between" style="max-width:undefinedpx;"><div class="flex gap-x-4 items-center"><button type="button" class="text-base-content hover:bg-base-200 rounded-lg p-1 transition-all duration-500 md:hidden"><span class="sr-only" data-svelte-h="svelte-73kebv">Open sidebar</span> <svg class="w-5 h-5" width="100%" height="100%" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round" xmlns="http://www.w3.org/2000/svg"><path stroke="none" d="M0 0h24v24H0z" fill="none"></path><path d="M4 6l16 0"></path><path d="M4 12l16 0"></path><path d="M4 18l16 0"></path></svg></button> <a href="/" class="text-sm font-bold text-base-content hidden md:block"><img src="/_app/immutable/assets/wordmark-black.rfl-FBgf.png" alt="Home" class="h-5 aspect-auto block dark:hidden" href="/"> <img src="/_app/immutable/assets/wordmark-white.C8ZS96Ri.png" alt="Home" class="h-5 aspect-auto hidden dark:block" href="/"></a></div> <div class="flex gap-2 text-sm items-center"> <div class="flex gap-2 items-center"><a href="https://github.com/archiewood/nyc-taxi" class="hover:bg-base-200 rounded-lg p-2 transition-all duration-200" target="_blank" rel="noreferrer"><svg role="img" viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" width="100%" height="100%" class="w-4 h-4 text-base-content"><path d="M12 .297c-6.63 0-12 5.373-12 12 0 5.303 3.438 9.8 8.205 11.385.6.113.82-.258.82-.577 0-.285-.01-1.04-.015-2.04-3.338.724-4.042-1.61-4.042-1.61C4.422 18.07 3.633 17.7 3.633 17.7c-1.087-.744.084-.729.084-.729 1.205.084 1.838 1.236 1.838 1.236 1.07 1.835 2.809 1.305 3.495.998.108-.776.417-1.305.76-1.605-2.665-.3-5.466-1.332-5.466-5.93 0-1.31.465-2.38 1.235-3.22-.135-.303-.54-1.523.105-3.176 0 0 1.005-.322 3.3 1.23.96-.267 1.98-.399 3-.405 1.02.006 2.04.138 3 .405 2.28-1.552 3.285-1.23 3.285-1.23.645 1.653.24 2.873.12 3.176.765.84 1.23 1.91 1.23 3.22 0 4.61-2.805 5.625-5.475 5.92.42.36.81 1.096.81 2.22 0 1.606-.015 2.896-.015 3.286 0 .315.21.69.825.57C20.565 22.092 24 17.592 24 12.297c0-6.627-5.373-12-12-12"></path></svg></a> </div> <div class="relative"> <button type="button" tabindex="0" aria-controls="Nk1jBKLK1Q" aria-expanded="false" data-state="closed" id="3DCNhM4d1m" data-melt-dropdown-menu-trigger="" data-menu-trigger="" class="inline-flex items-center justify-center font-medium whitespace-nowrap transition-colors focus-visible:outline-none focus-visible:ring-1 focus-visible:ring-base-content-muted disabled:pointer-events-none disabled:opacity-50 hover:text-base-content h-8 rounded-md text-xs px-1 hover:bg-base-200 shadow-base-200" aria-label="Menu" data-button-root=""><svg class="h-6 w-6" width="100%" height="100%" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round" xmlns="http://www.w3.org/2000/svg"><path stroke="none" d="M0 0h24v24H0z" fill="none"></path><path d="M5 12m-1 0a1 1 0 1 0 2 0a1 1 0 1 0 -2 0"></path><path d="M12 12m-1 0a1 1 0 1 0 2 0a1 1 0 1 0 -2 0"></path><path d="M19 12m-1 0a1 1 0 1 0 2 0a1 1 0 1 0 -2 0"></path></svg></button> </div></div></div></header> <div class=" max-w-7xl print:w-[650px] print:md:w-[841px] mx-auto print:md:px-0 print:px-0 px-6 sm:px-8 md:px-12 flex justify-start" style="max-width:undefinedpx;"><div class="print:hidden"> <aside class="w-48 flex-none hidden md:flex"><div class="hidden: md:block fixed w-48 top-20 bottom-8 overflow-y-auto flex-1 text-sm pretty-scrollbar"><div class="flex flex-col pb-6"><a class="sticky top-0 bg-base-100 shadow shadow-base-100 font-semibold pb-1 mb-1 group inline-block capitalize hover:underline text-base-heading" href="/">Home</a> </div> </div> </aside></div> <main class="md:pl-8 md:pr-8 mt-16 sm:mt-20 flex-grow overflow-x-hidden print:px-0 print:mt-8"><div class="print:hidden"><div class="flex items-start mt-0 whitespace-nowrap overflow-auto"><div class="inline-flex items-center text-sm capitalize gap-1 text-base-content-muted mb-2 sm:mb-4"><a href="/" class="hover:underline">Home </a><svg class="icon icon-tabler icon-tabler-chevron-right" width="12px" height="12px" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round" xmlns="http://www.w3.org/2000/svg"><path stroke="none" d="M0 0h24v24H0z" fill="none"></path><path d="M9 6l6 6l-6 6"></path></svg> <span class="cursor-default">borough</span><svg class="icon icon-tabler icon-tabler-chevron-right" width="12px" height="12px" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round" xmlns="http://www.w3.org/2000/svg"><path stroke="none" d="M0 0h24v24H0z" fill="none"></path><path d="M9 6l6 6l-6 6"></path></svg> <a href="/borough/Bronx" class="hover:underline">Bronx</a></div></div></div> <article id="evidence-main-article" class="select-text markdown pb-10"> <h1 class="markdown" id="paramsborough"><a href="#paramsborough">Bronx</a></h1> <div class="over-container svelte-1p12lev"> </div> <div class="contents print:hidden"><div class="mt-2 mb-4 ml-0 mr-2 inline-block"> <div class="flex"> <button type="button" tabindex="0" role="button" aria-haspopup="dialog" aria-expanded="false" data-state="closed" id="UYwNPB-VJe" data-melt-popover-trigger="" data-popover-trigger="" class="items-center whitespace-nowrap transition-colors focus-visible:outline-none focus-visible:ring-1 focus-visible:ring-base-content-muted disabled:pointer-events-none disabled:opacity-50 border border-base-300 bg-transparent shadow-sm h-8 rounded-md px-3 text-xs flex justify-start rounded-r-none border-r-0 text-left font-normal hover:bg-base-200 shadow-base-200" data-button-root=""><span class="hidden sm:inline">Jan 1, 2022 - Dec 2, 2022</span> <span class="sm:hidden">1/1/22 - 12/2/22</span></button> <button aria-autocomplete="list" aria-controls="j0LXhn7HXx" aria-expanded="false" aria-labelledby="bU4jysDYL4" id="867LpMPQSD" role="combobox" type="button" data-melt-select-trigger="" data-select-trigger="" class="border border-base-300 flex items-center justify-between rounded-md bg-transparent py-2 shadow-sm placeholder:text-base-content-muted focus:outline-none focus:ring-1 focus:ring-base-content-muted disabled:cursor-not-allowed disabled:opacity-50 h-8 w-40 rounded-l-none px-3 text-xs font-medium hover:bg-base-200 transition-colors" sameWidth><span class="hidden sm:inline text-base-content-muted" data-svelte-h="svelte-184xn4x">Select a Range</span> <span class="sm:hidden" data-svelte-h="svelte-1a1txje">Range</span> <div><svg viewBox="0 0 15 15" fill="none" xmlns="http://www.w3.org/2000/svg" width="100%" height="100%" class="h-4 w-4"><path fill-rule="evenodd" clip-rule="evenodd" d="M4.93179 5.43179C4.75605 5.60753 4.75605 5.89245 4.93179 6.06819C5.10753 6.24392 5.39245 6.24392 5.56819 6.06819L7.49999 4.13638L9.43179 6.06819C9.60753 6.24392 9.89245 6.24392 10.0682 6.06819C10.2439 5.89245 10.2439 5.60753 10.0682 5.43179L7.81819 3.18179C7.73379 3.0974 7.61933 3.04999 7.49999 3.04999C7.38064 3.04999 7.26618 3.0974 7.18179 3.18179L4.93179 5.43179ZM10.0682 9.56819C10.2439 9.39245 10.2439 9.10753 10.0682 8.93179C9.89245 8.75606 9.60753 8.75606 9.43179 8.93179L7.49999 10.8636L5.56819 8.93179C5.39245 8.75606 5.10753 8.75606 4.93179 8.93179C4.75605 9.10753 4.75605 9.39245 4.93179 9.56819L7.18179 11.8182C7.35753 11.9939 7.64245 11.9939 7.81819 11.8182L10.0682 9.56819Z" fill="currentColor"></path></svg></div></button> </div></div></div> <div class="over-container svelte-1p12lev"> </div> <div class="inline-block font-sans pt-2 pb-3 pr-3 pl-0 mr-3 items-center align-top" style=" | |
| min-width: 18%; | |
| max-width: none; | |
| "><p class="text-sm">Rides</p> <div class="relative text-xl font-medium my-0.5"> <span style="color: ">47,271</span> </div> </div> <div class="inline-block font-sans pt-2 pb-3 pr-3 pl-0 mr-3 items-center align-top" style=" | |
| min-width: 18%; | |
| max-width: none; | |
| "><p class="text-sm">Fare Amount</p> <div class="relative text-xl font-medium my-0.5"> <span style="color: ">$1.4M</span> </div> </div> <div class="inline-block font-sans pt-2 pb-3 pr-3 pl-0 mr-3 items-center align-top" style=" | |
| min-width: 18%; | |
| max-width: none; | |
| "><p class="text-sm">Trip Distance</p> <div class="relative text-xl font-medium my-0.5"> <span style="color: ">1,564,637 mi</span> </div> </div> <div class="inline-block font-sans pt-2 pb-3 pr-3 pl-0 mr-3 items-center align-top" style=" | |
| min-width: 18%; | |
| max-width: none; | |
| "><p class="text-sm">Fare Per Mile</p> <div class="relative text-xl font-medium my-0.5"> <span style="color: ">$0.86</span> </div> </div> <div class="over-container svelte-1p12lev"> </div> <div style="margin-top: 15px; margin-bottom: 10px;"><h4 class="markdown mb-2">Rides by Pickup Location</h4> <div class="relative break-inside-avoid svelte-z9gk2f"> <div class="z-0 rounded-md focus:outline-none svelte-z9gk2f" style="height: 300px;"><div class="svelte-z9gk2f"> </div> </div> </div></div></article></main> <div class="print:hidden"><aside class="hidden lg:block w-48"><div class="fixed w-48 top-20 bottom-20 pl-4 px-3 overflow-auto pretty-scrollbar"></div></aside></div></div></div> | |
| <script type="application/json" data-sveltekit-fetched data-url="/api/customFormattingSettings.json/GET.json">{"status":200,"statusText":"","headers":{},"body":"{\"customFormattingSettings\":{\"version\":\"1.0\",\"customFormats\":[]}}"}</script> | |
| <script type="application/json" data-sveltekit-fetched data-url="/api/pagesManifest.json">{"status":200,"statusText":"","headers":{},"body":"{\"label\":\"Home\",\"href\":\"/\",\"children\":{\"borough\":{\"label\":\"borough\",\"children\":{\"[borough]\":{\"children\":{},\"isTemplated\":true,\"isPage\":true}},\"frontMatter\":{},\"isTemplated\":false,\"isPage\":false}},\"frontMatter\":{\"title\":\"NYC Taxi Data 2022\",\"sidebar\":\"never\"},\"isTemplated\":false,\"isPage\":true}"}</script> | |
| <script type="application/json" data-sveltekit-fetched data-url="/api//borough/[borough]/evidencemeta.json">{"status":200,"statusText":"","headers":{},"body":"{\"queries\":[{\"id\":\"date_range\",\"compiledQueryString\":\"select * from taxi.dates\",\"inputQueryString\":\"select * from taxi.dates\",\"compiled\":false,\"inline\":true},{\"id\":\"aggregate_stats\",\"compiledQueryString\":\"select\\n sum(rides) as rides,\\n sum(fare_amount) as fare_amount,\\n sum(trip_distance) as trip_distance,\\n sum(fare_amount)/sum(trip_distance) as fare_per_mile\\nfrom taxi.summary_borough\\nleft join zones.zones z on taxi.summary_borough.pickup_location_id = z.location_id\\nwhere day between '${inputs.date_range.start}' and '${inputs.date_range.end}'\\nand lower(borough) = lower('${params.borough}')\",\"inputQueryString\":\"select\\n sum(rides) as rides,\\n sum(fare_amount) as fare_amount,\\n sum(trip_distance) as trip_distance,\\n sum(fare_amount)/sum(trip_distance) as fare_per_mile\\nfrom taxi.summary_borough\\nleft join zones.zones z on taxi.summary_borough.pickup_location_id = z.location_id\\nwhere day between '${inputs.date_range.start}' and '${inputs.date_range.end}'\\nand lower(borough) = lower('${params.borough}')\",\"compiled\":false,\"inline\":true},{\"id\":\"fares_by_pickup_location\",\"compiledQueryString\":\"select\\n pickup_location_id,\\n zone,\\n borough,\\n sum(rides) as rides,\\n sum(fare_amount) as fare_amount,\\n sum(trip_distance) as trip_distance\\nfrom taxi.location l\\nleft join zones.zones z on l.pickup_location_id = z.location_id\\nwhere day between '${inputs.date_range.start}' and '${inputs.date_range.end}'\\nand lower(borough) = lower('${params.borough}')\\ngroup by all\\norder by 1\",\"inputQueryString\":\"select\\n pickup_location_id,\\n zone,\\n borough,\\n sum(rides) as rides,\\n sum(fare_amount) as fare_amount,\\n sum(trip_distance) as trip_distance\\nfrom taxi.location l\\nleft join zones.zones z on l.pickup_location_id = z.location_id\\nwhere day between '${inputs.date_range.start}' and '${inputs.date_range.end}'\\nand lower(borough) = lower('${params.borough}')\\ngroup by all\\norder by 1\",\"compiled\":false,\"inline\":true}]}"}</script> | |
| <script> | |
| { | |
| __sveltekit_1fkx0il = { | |
| base: "" | |
| }; | |
| const element = document.currentScript.parentElement; | |
| const data = [null,null]; | |
| Promise.all([ | |
| import("/_app/immutable/entry/start.Cm-tlAbH.js"), | |
| import("/_app/immutable/entry/app.eVNqlex7.js") | |
| ]).then(([kit, app]) => { | |
| kit.start(app, element, { | |
| node_ids: [0, 5], | |
| data, | |
| form: null, | |
| error: null | |
| }); | |
| }); | |
| } | |
| </script> | |
| </div> | |
| <!-- SplashScreen --> | |
| <div | |
| aria-disabled | |
| id="__evidence_project_splash" | |
| data-test-id="__evidence_project_splash" | |
| class="fixed inset-0 w-screen h-screen flex items-center justify-center z-[9999] bg-base-100" | |
| style="visibility: hidden" | |
| > | |
| <svg | |
| width="100" | |
| height="100" | |
| viewBox="-8 -8 588 588" | |
| xmlns="http://www.w3.org/2000/svg" | |
| fill="currentColor" | |
| class="animate-pulse" | |
| > | |
| <path | |
| d="M7.19462e-05 74.3583C109.309 74.3583 195.795 86.2578 286.834 37.825C377.872 -10.6077 466.416 1.29174 573.667 1.29175L573.667 126.549C466.416 126.549 377.373 114.91 286.834 163.082C196.294 211.254 109.309 199.615 6.11417e-05 199.615L7.19462e-05 74.3583Z" | |
| /> | |
| <path | |
| d="M573.669 499.31C464.36 499.31 377.874 487.411 286.835 535.843C195.797 584.276 107.252 572.377 0.0014801 572.377V447.12C107.252 447.12 196.295 458.758 286.835 410.586C377.375 362.415 464.36 374.053 573.669 374.053V499.31Z" | |
| /> | |
| <path | |
| d="M452.896 186.499C395.028 187.686 341.581 194.947 286.835 224.074C211.396 264.212 136.995 262.826 52.2355 261.247C35.2696 260.931 17.8887 260.608 0.0014801 260.608V385.865C18.1032 385.865 35.6721 386.204 52.81 386.534C137.212 388.162 211.162 389.589 286.835 349.331C341.838 320.07 395.18 312.831 452.896 311.685V186.499Z" | |
| /> | |
| </svg> | |
| </div> | |
| </body> | |
| </html> | |