Skip to content

Instantly share code, notes, and snippets.

Avatar
😋

Kyle kpennell

😋
View GitHub Profile
View target_stores_enriched_with_geosocial_safegraph_2.csv
We can't make this file beautiful and searchable because it's too large.
the_geom,cases_per_cap,area_deprivation_index_percent,cartodb_id,unnamed_0,city,contact,country,county,district,formatted,_group,id,last_remodel,latitude,longitude,opened,region,state,store_features,store_name,stores_open,street,subtype,timings,type,zipcode,median_non_home_dwell_time,positive_sentiment_posts,negative_sentiment_posts
0101000020E61000001E6FF25B74B355C05804FF5BC99C4040,2.91771789397949,5,1,0,Alabaster,(205) 564-2608,United States,Shelby,340,"250 S Colonial Dr, Alabaster, AL 35007-4657",394,2276,NaN,33.224895000000004,-86.803977,2007-07-25T12:00:00,300,AL,"['CVS pharmacy', 'Cafe-Pizza', 'Drive Up', 'Starbucks', 'Wine & Beer Available']",Alabaster,"['Monday-Friday', 'Saturday', 'Sunday']",250 S Colonial Dr,NaN,"[{'Week Day': 'Monday-Friday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}, {'Week Day': 'Saturday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}, {'Week Day': 'Sunday', 'Open Hours': '8:00 a.m.-9:00 p.m.'}]",Store,35007-4657,127.45517163505,20.3442457478019,15.9417324310794
View targetstores_revenueandemployees.csv
We can't make this file beautiful and searchable because it's too large.
the_geom,cartodb_id,field_1,city,contact,country,county,district,formatted,_group,id,last_remodel,latitude,longitude,opened,region,state,store_features,store_name,stores_open,street,subtype,timings,type,zipcode,revenue,employee_count
0101000020E6100000F71F990E9D0E57C052D2C3D0EA644140,138,137,North Little Rock,(501) 771-4220,United States,Pulaski,167,"4000 McCain Blvd, North Little Rock, AR 72116-8039",194,162,2007-03-23T12:00:00,34.788416,-92.228336,1982-07-20 12:00:00+00,100,AR,"['Café', 'Drive Up']",Little Rock North,"['Monday-Friday', 'Saturday', 'Sunday']",4000 McCain Blvd,normal,"[{'Week Day': 'Monday-Friday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}, {'Week Day': 'Saturday', 'Open Hours': '8:00 a.m.-11:00 p.m.'}, {'Week Day': 'Sunday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}]",Store,72116-8039,662129,99
View targetstores_revenueandemployees.csv
We can't make this file beautiful and searchable because it's too large.
the_geom,cartodb_id,field_1,city,contact,country,county,district,formatted,_group,id,last_remodel,latitude,longitude,opened,region,state,store_features,store_name,stores_open,street,subtype,timings,type,zipcode,revenue,employee_count
0101000020E6100000F71F990E9D0E57C052D2C3D0EA644140,138,137,North Little Rock,(501) 771-4220,United States,Pulaski,167,"4000 McCain Blvd, North Little Rock, AR 72116-8039",194,162,2007-03-23T12:00:00,34.788416,-92.228336,1982-07-20 12:00:00+00,100,AR,"['Café', 'Drive Up']",Little Rock North,"['Monday-Friday', 'Saturday', 'Sunday']",4000 McCain Blvd,normal,"[{'Week Day': 'Monday-Friday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}, {'Week Day': 'Saturday', 'Open Hours': '8:00 a.m.-11:00 p.m.'}, {'Week Day': 'Sunday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}]",Store,72116-8039,662129,99
View targetswithnolatlng.csv
We can't make this file beautiful and searchable because it's too large.
City,Contact,Country,County,District,Formatted,Group,ID,Last Remodel,Opened,Region,State,Store Features,Store_Name,Stores_Open,Street,SubType,Timings,Type,Zipcode
Alabaster,(205) 564-2608,United States,Shelby,340,"250 S Colonial Dr, Alabaster, AL 35007-4657",394,2276,null,2007-07-25T12:00:00,300,AL,"['CVS pharmacy', 'Cafe-Pizza', 'Drive Up', 'Starbucks', 'Wine & Beer Available']",Alabaster,"['Monday-Friday', 'Saturday', 'Sunday']",250 S Colonial Dr,,"[{'Week Day': 'Monday-Friday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}, {'Week Day': 'Saturday', 'Open Hours': '8:00 a.m.-10:00 p.m.'}, {'Week Day': 'Sunday', 'Open Hours': '8:00 a.m.-9:00 p.m.'}]",Store,35007-4657
View examplegooglesheetsresult.js
{
"spreadsheetId": "1Qyn6530gveP7wnLHswBH0a_6ndTbWE65hvMWY17313Y",
"valueRanges": [
{
"range": "export!A1:W998",
"majorDimension": "ROWS",
"values": [
[
"id",
"move",
View index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
</head>
<body>
<script id="jsbin-javascript">
View index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
</head>
<body>
<script id="jsbin-javascript">
View books
https://www.google.com/search?hl=en&q=Author+First+Name+Author+Last+Name+Title+Series+Series+Number+goodreads+reviews
https://www.google.com/search?hl=en&q=A.+J.+Hartley+Act+of+Will+Will+Hawthorne+1+goodreads+reviews
https://www.google.com/search?hl=en&q=A.+J.+Hartley+Will+Power+Will+Hawthorne+2+goodreads+reviews
https://www.google.com/search?hl=en&q=A.+J.+Jacobs+The+Year+of+Living+Biblically:+One+Man's+Humble+Quest+to+Follow+the+Bible+as+Literally+as+Possible+goodreads+reviews
https://www.google.com/search?hl=en&q=A.+Lee+Martinez+A+Nameless+Witch+goodreads+reviews
https://www.google.com/search?hl=en&q=A.+Manette+Ansay+Good+Things+I+Wish+You+goodreads+reviews
https://www.google.com/search?hl=en&q=A.+N.+&+Rice+Roquelaure+Beauty's+Punishment+Sleeping+Beauty+Trilogy+2+goodreads+reviews
https://www.google.com/search?hl=en&q=A.+N.+&+Rice+Roquelaure+Beauty's+Release+Sleeping+Beauty+Trilogy+3+goodreads+reviews
https://www.google.com/search?hl=en&q=Ace+Atkins+Devil's+Garden+goodreads+reviews
View index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
</head>
<body>
<script id="jsbin-javascript">
View favorite mixes
Best of the best house:
https://soundcloud.com/super-flu-de/super_flu_fusion_2014 (must listen)
https://soundcloud.com/midnightcityamsterdam/fouk-midnight-city-15102016 (amazing groove)
https://soundcloud.com/times-are-ruff/feel-my-bicep-podcast-2013
https://soundcloud.com/wildeburg/times-are-ruff-wildeburg-17072016 (good throughout)
You can’t perform that action at this time.