Skip to content

Instantly share code, notes, and snippets.

View keith44's full-sized avatar

Keith Miller keith44

  • Austin, TX
View GitHub Profile
We can't make this file beautiful and searchable because it's too large.
valence,year,acousticness,artists,danceability,duration_ms,energy,explicit,id,instrumentalness,key,liveness,loudness,mode,name,popularity,release_date,speechiness,tempo
0.7240000000000001,1953,0.7859999999999999,['Doris Day & With Orchestra'],0.5579999999999999,128667,0.422,0,6g6IumW57HO2qaxZ2mt8Vo,0,0,0.218,-9.403,1,Just Blew In from the Windy City,30,19672,0.203,201.582
0.457,2003,0.000577,"['Too $hort', 'Lil Jon', 'Eastside Boyz']",0.937,278707,0.695,1,3XabgBQYC7H80agKcAq83Y,3.19e-05,0,0.295,-6.932,1,Shake That Monkey (feat. Lil' Jon & The EastSide Boyz),56,37622,0.134,99.997
0.464,2020,0.183,['Juice WRLD'],0.868,154767,0.55,1,0fCwrjKfWxF3xQhZrYUw4T,0,6,0.109,-6.417,1,Blood On My Jeans,79,44022,0.226,117.943
0.568,2020,0.0582,"['King Von', 'Polo G']",0.831,202413,0.62,1,5NOUjBikzECEJyZMTxtErD,0,6,0.119,-8.397,0,The Code (feat. Polo G),78,44134,0.338,133.17
0.877,1951,0.909,"['Marge Champion', 'Gower Champion']",0.667,196973,0.32299999999999995,0,6MMF38qO03XJ7puIxVl8Gg,0.0148,1,0.0301,-12.993,1,I Might Fall
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 19 columns, instead of 18 in line 5.
valence,year,acousticness,artists,danceability,duration_ms,energy,explicit,id,instrumentalness,key,liveness,loudness,mode,name,popularity,release_date,speechiness,tempo
0.0594,1921,0.982,"['Sergei Rachmaninoff', 'James Levine', 'Berliner Philharmoniker']",0.279,831667,0.211,0,4BJqT0PrAfrxzMOxytFOIz,0.878,10,0.665,-20.096,1,"Piano Concerto No. 3 in D Minor, Op. 30: III. Finale. Alla breve",4,1921,0.0366,80.954
0.963,1921,0.732,['Dennis Day'],0.8190000000000001,180533,0.341,0,7xPhfUan2yNtyFG0cUWkt8,0,7,0.16,-12.441,1,Clancy Lowered the Boom,5,1921,0.415,60.93600000000001
0.0394,1921,0.961,['KHP Kridhamardawa Karaton Ngayogyakarta Hadiningrat'],0.328,500062,0.166,0,1o6I8BglA6ylDMrIELygv1,0.913,3,0.101,-14.85,1,Gati Bali,5,1921,0.0339,110.339
0.165,1921,0.967,['Frank Parker'],0.275,210000,0.309,0,3ftBPsC5vPBKxYSee08FDH,2.77e-05,5,0.381,-9.316,1,Danny Boy,3,1921,0.0354,100.109
0.253,1921,0.957,['Phil Regan'],0.418,166693,0.193,0,4d6HGyGT8e121BsdKmw9v6,1.68e-06,3,0.229,-10.096,1,When Irish Eyes Are Smiling,2,1921,0
@keith44
keith44 / README.md
Last active February 25, 2026 03:25
denver e-scooter usage metrics
--What's the most expensive listing? What else can you tell me about the listing?
--100000
--id: 24650875
--name: Full House Victorian: 7500 SqFt, 4 Floors
--host_id: 6460979
--host_name: Sarah
--neighbourhood_group: no data
--neighbourhood: Western Addition
--latitude: 37.780230017385364
@keith44
keith44 / SQL_data_access_methods.sql
Last active February 26, 2019 19:16
SQL BASICS
SQL Basics Drill
# Selects the IDs and durations for all trips of duration greater than 500, ordered by duration.
SELECT
trip_id,
duration
FROM
trips
WHERE