Skip to content

Instantly share code, notes, and snippets.

View sirwart's full-sized avatar

Brian Smith sirwart

12 followers · 3 following
View GitHub Profile
@sirwart
sirwart / showtables.sql
Last active January 26, 2019 15:46
numeracy#TEST@DEMO_DB.(no schema)>show tables;
+-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------+
| created_on | name | database_name | schema_name | kind | comment | cluster_by | rows | bytes | owner | retention_time |
|-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------|
| 2019-01-26 07:40:25.633 -0800 | BAR_TEST | DEMO_DB | BAR | TABLE | | | 0 | 0 | SYSADMIN | 1 |
| 2019-01-26 07:39:58.247 -0800 | TEST | DEMO_DB | BAR | TABLE | | | 0 | 0 | SYSADMIN | 1 |
| 2019-01-26 07:40:13.771 -0800 | FOO_TEST | DEMO_DB | FOO | TABLE | | | 0 | 0 | SYSADMIN | 1 |
+-------------------------------+----------+---------------+-------------+-------+-
@sirwart
sirwart / keybase.md
Created April 19, 2017 00:41

Keybase proof

I hereby claim:

  • I am sirwart on github.
  • I am sirwart (https://keybase.io/sirwart) on keybase.
  • I have a public key ASBvdhbopj_3r0mUXLp_pW7X3VKvt540v1qn5OyVp1BUlwo

To claim this, I am signing this object:

@sirwart
sirwart / .block
Created September 22, 2016 18:48
Tampa Bay Census Tracts
license: mit
@sirwart
sirwart / sf-homelessness.ipynb
Last active August 15, 2016 06:25
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@sirwart
sirwart / index.html
Last active July 13, 2016 03:00
San Francisco Zero Waste Data
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<script src="https://d3js.org/d3.v4.min.js"></script>
<style>
body {
margin: 0;
font-family: "Helvetica Neue", Helvetica, Sans-Serif;
}
svg {
@sirwart
sirwart / .block
Last active July 17, 2016 22:56
Per-Capita Police Involved Deaths by State
license: gpl-3.0
@sirwart
sirwart / .block
Created April 16, 2016 06:33
Albers USA Projection
license: gpl-3.0
@sirwart
sirwart / .block
Last active April 13, 2016 00:28
Rate of Police Involved Deaths vs Violent Crime
license: gpl-3.0
@sirwart
sirwart / README.md
Created April 12, 2016 23:35
Simple Scatterplot
@sirwart
sirwart / .block
Last active October 15, 2016 01:07
Fatal Encounters Deaths by Year
license: mit