Skip to content

Instantly share code, notes, and snippets.

View stiles's full-sized avatar

Matt Stiles stiles

View GitHub Profile
@stiles
stiles / la_zips_map.geojson
Created August 12, 2019 20:24
2nd District Donations: 2019
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stiles
stiles / la_zips_map.geojson
Created August 12, 2019 20:22
2nd District Donations: 2019
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stiles
stiles / oc_place_of_birth.geojson
Created August 11, 2019 21:53
Orange County, CA — By Place of Birst
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@stiles
stiles / docs.json
Created August 9, 2019 16:39
LA County Board of Supervisors Supporting Documents
This file has been truncated, but you can view the full file.
{"results":[{"date":"08/06/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"5-SIG 19-5117","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/138645.pdf","categories":"","motionedBy":"","sdSummary":"5-SIG 19-5117. Microsoft Word - Document1. Five-signature letter pending","transcript":"","tsURL":"","tsSummary":""},{"date":"08/06/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"CEO Memo 19-5117a","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/138613.pdf","categories":"","motionedBy":"","sdSummary":"CEO Memo 19-5117a. County of Los Angeles CHIEF EXECUTIVE OFFICE Kenneth Hahn Hall of Administration 500 West Temple Street, Room 713, Los Angeles, California 90012 (213) 974-1101 http://ceo.lacounty.gov Board of Supervisors HILDA L. SOLIS Augus","transcript":"","tsURL":"","tsSummary":""},{"date":"08/06/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"CEO Memo 19-5135a","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/138611.pdf","categories":"","motionedBy":"","sdSummary":"CEO Memo 19-5
@stiles
stiles / statements.json
Created August 9, 2019 16:37
LA County of Board of Supervisors Statements of Proceedings
{"results":[{"date":"07/23/2019","sop":"Statement of Proceedings for 7/23/19","sopURL":"http://file.lacounty.gov/SDSInter/bos/sop/1059442_072319.pdf","sopSummary":"Statement of Proceedings for 7/23/19. Statement Of Proceedings. STATEMENT OF PROCEEDINGS FOR THE REGULAR MEETING OF THE BOARD OF SUPERVISORS OF THE COUNTY OF LOS ANGELES HELD IN ROOM 381B OF THE KENNETH HAHN HALL OF ADMINISTRATION 500 WEST TEMPLE","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"","tsURL":"","tsSummary":""},{"date":"07/16/2019","sop":"Statement of Proceedings for 7/16/19","sopURL":"http://file.lacounty.gov/SDSInter/bos/sop/1058736_071619.pdf","sopSummary":"Statement of Proceedings for 7/16/19. Statement Of Proceedings. STATEMENT OF PROCEEDINGS FOR THE REGULAR MEETING OF THE BOARD OF SUPERVISORS OF THE COUNTY OF LOS ANGELES HELD IN ROOM 381B OF THE KENNETH HAHN HALL OF ADMINISTRATION 500 WEST TEMPLE","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"","tsURL":"","t
@stiles
stiles / transcripts.json
Last active November 20, 2019 01:04
LA County Board of Supervisors Transcripts
{"results":[{"date":"11/05/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"11-05-19 Board Meeting Transcript","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1064146_110519.pdf","tsSummary":"11-05-19 Board Meeting Transcript. November 5, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat Reader"},{"date":"10/29/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"10-29-19 Board Meeting Transcript (C)","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1063943_102919.pdf","tsSummary":"10-29-19 Board Meeting Transcript (C). October 29, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat R"},{"date":"10/22/2019","sop":"","sopURL":"","sopSumma
@stiles
stiles / transcripts.json
Created August 9, 2019 16:36
LA County Board of Supervisors Transcripts
{"results":[{"date":"07/30/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"07-30-19 Board Meeting Transcript (C)","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1059255_073019.pdf","tsSummary":"07-30-19 Board Meeting Transcript (C). July 30, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat R"},{"date":"07/23/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"","sdURL":"","categories":"","motionedBy":"","sdSummary":"","transcript":"07-23-19 Board Meeting Transcript (C)","tsURL":"http://file.lacounty.gov/SDSInter/bos/sop/transcripts/1058916_072319.pdf","tsSummary":"07-23-19 Board Meeting Transcript (C). July 23, 2019 1 Adobe Acrobat Reader Finding Words You can use the Find command to find a complete word or part of a word in the current PDF document. Acrobat R"},{"date":"07/16/2019","sop":"","sopURL":"","sopSummary"
@stiles
stiles / motions.json
Last active November 20, 2019 01:02
LA County Board of Supervisors Motions
{"results":[{"date":"11/19/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"HLS Motion 19-7360","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/141895.pdf","categories":"","motionedBy":"1 - Solis","sdSummary":"HLS Motion 19-7360. Motion_2004. MOTION SOLIS ___________________________ RIDLEY-THOMAS ___________________________ KUEHL ___________________________ BARGER ___________________________ HAHN ___________________________ AGN","transcript":"","tsURL":"","tsSummary":""},{"date":"11/19/2019","sop":"","sopURL":"","sopSummary":"","supDoc":"HLS Motion 19-7361","sdURL":"http://file.lacounty.gov/SDSInter/bos/supdocs/141891.pdf","categories":"","motionedBy":"1 - Solis","sdSummary":"HLS Motion 19-7361. Motion_2004. MOTION SOLIS ___________________________ RIDLEY-THOMAS ___________________________ KUEHL ___________________________ BARGER ___________________________ HAHN ___________________________ AGN","transcript":"","tsURL":"","tsSummary":""},{"date":"11/19/2019","sop":"","sopURL":"","sopSummary":"","sup

The pandas equivalent to...

select * from table where column_name = some_value

is:

table[table.column_name == some_value]

Multiple conditions:

@stiles
stiles / graphics-palms.csv
Last active July 10, 2019 21:39
Palm Tree Proportions
place palm other
Redondo Beach 2972 10637
Santa Monica 6802 28433
Beverly Hills 4641 22314
Artesia 500 2450
South Pasadena 1555 9794
Culver City 2249 14737
West Hollywood 1082 7984
Long Beach 16605 124217
Pasadena 8133 62999