Skip to content

Instantly share code, notes, and snippets.

View zocoi's full-sized avatar

Hưng Đào zocoi

14 followers · 7 following
View GitHub Profile
@zocoi
zocoi / tl_2017_06_place.geojson
Created October 27, 2017 00:15
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@zocoi
zocoi / myfile1.csv
Created November 3, 2017 00:13
130ch74g https://ripplenews.com/p/130ch74g /read/san-francisco/come-to-the-castro-and-enjoy-our-chipotle-130ch74g ‘Come to the Castro and Enjoy Our Chipotle’ come-to-the-castro-and-enjoy-our-chipotle 2016-04-13 10:40:58 -0700
130h6gg5 https://ripplenews.com/p/130h6gg5 /read/san-francisco/don-t-call-it-frisco-takes-aim-at-the-city-130h6gg5 ‘Don’t Call It Frisco’ Takes Aim at The City don-t-call-it-frisco-takes-aim-at-the-city 2016-05-15 10:02:00 -0700
uqcloae https://ripplenews.com/p/uqcloae /read/misr-al-gadida/sometimes-small-things-make-a-huge-difference-uqcloae " Sometimes small things, make a huge difference" sometimes-small-things-make-a-huge-difference 2016-02-21 08:45:12 -0800
10h0hsqb https://ripplenews.com/p/10h0hsqb /read/al-khalifa-wal-moqattam/camera-is-my-motivator-10h0hsqb "Camera is my motivator !" camera-is-my-motivator 2016-03-13 14:51:37 -0700
@zocoi
zocoi / myfile2.csv
Created November 3, 2017 01:52
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 7 columns, instead of 3. in line 4.
130ch74g,https://ripplenews.com/p/130ch74g,/read/san-francisco/come-to-the-castro-and-enjoy-our-chipotle-130ch74g,22778,‘Come to the Castro and Enjoy Our Chipotle’,come-to-the-castro-and-enjoy-our-chipotle,2016-04-13 10:40:58 -0700
130h6gg5,https://ripplenews.com/p/130h6gg5,/read/san-francisco/don-t-call-it-frisco-takes-aim-at-the-city-130h6gg5,22779,‘Don’t Call It Frisco’ Takes Aim at The City,don-t-call-it-frisco-takes-aim-at-the-city,2016-05-15 10:02:00 -0700
uqcloae,https://ripplenews.com/p/uqcloae,/read/misr-al-gadida/sometimes-small-things-make-a-huge-difference-uqcloae,22780,""" Sometimes small things, make a huge difference""",sometimes-small-things-make-a-huge-difference,2016-02-21 08:45:12 -0800
10h0hsqb,https://ripplenews.com/p/10h0hsqb,/read/al-khalifa-wal-moqattam/camera-is-my-motivator-10h0hsqb,22781,"""Camera is my motivator !""",camera-is-my-motivator,2016-03-13 14:51:37 -0700
le76rng,https://ripplenews.com/p/le76rng,/read/san-francisco/for-here-or-to-go-director-and-writer-producer-at-sfo-fly
@zocoi
zocoi / map_2.geojson
Last active December 1, 2017 01:10
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@zocoi
zocoi / myfile1.csv
Created January 9, 2018 01:43
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 7.
"Trenton, NJ",Mercer County
"Lancaster, PA",Lancaster County
"Cleveland-Elyria, OH","Lorain County, Geauga County, Medina County"
"Chicago-Naperville-Elgin, IL-IN-WI","Kendall County, Cook County, DeKalb County, Kane County, Grundy County, Will County, DuPage County, McHenry County, Newton County, Lake County, Jasper County, Porter County, Kenosha County"
"San Antonio-New Braunfels, TX","Bandera County, Comal County, Guadalupe County, Medina County, Kendall County, Bexar County, Atascosa County, Wilson County"
"Pittsburgh, PA","Butler County, Fayette County, Allegheny County, Washington County, Armstrong County, Westmoreland County, Beaver County"
"Atlanta-Sandy Springs-Roswell, GA","Barrow County, Paulding County, Meriwether County, Fayette County, Haralson County, Bartow County, Coweta County, Jasper County, Henry County, Carroll County, Walton County, Dawson County, Morgan County, Douglas County, Lamar County, Clayton County, DeKalb County, Pickens County, Gwinnett County, Pike County, Rockdale County, Ful
@zocoi
zocoi / miniset2.csv
Created January 26, 2018 05:00
We can't make this file beautiful and searchable because it's too large.
,Unnamed: 0,Unnamed: 0.1,Unnamed: 0.1.1,Unnamed: 0.1.1.1,Unnamed: 0.1.1.1.1,category,created_at,description,id,link,locations,source,title,body_len,ordered_entities,formatted_locations,Mapbox location id
3,3,3,3,3,3,"{""id"": ""crime_safety"", ""name"": ""Crime & Safety""}",2017-12-31 1:21:38,"Jonathan Lopez, a Brooklyn sixth-grader in a schoolyard tussle with two girls, got caught up in the sex-harassment tornado. Jonathan insists he only tried to grab the water bottle and backpack of c…",cc1f60a9-940b-4d1f-b454-ecdbb836fffb,https://nypost.com/2017/12/30/my-son-was-wrongly-accused-of-sexual-misconduct-at-school,"[{""id"": ""17b72262-4df8-4078-89ac-cda5eeaae901"", ""location_id"": ""ea5f5412-dcf6-4256-afc8-4a0e69e4cf73"", ""neighborhood_id"": ""3e5df1bd-0d02-46fa-9be0-6cf87c7c0f63"", ""neighborhood_name"": ""Sunset Park"", ""city_id"": ""6f17c6a4-a745-450e-aeea-9ffca09e2566"", ""city_name"": ""New York City"", ""formatted_name"": ""MS 88, 544 7th Avenue, Brooklyn, NY"", ""formatted_address"": ""544 7th Avenue
@zocoi
zocoi / miniset2.csv
Created January 26, 2018 19:51
We can't make this file beautiful and searchable because it's too large.
,Unnamed: 0,Unnamed: 0.1,Unnamed: 0.1.1,Unnamed: 0.1.1.1,Unnamed: 0.1.1.1.1,Unnamed: 0.1.1.1.1.1,body_len,category,id,link,title,formatted_address,neighborhood_name,city_name,created_at,description,locations,name,ordered_entities,source
0,3,3,3,3,3,3,3829,"{""id"": ""crime_safety"", ""name"": ""Crime & Safety""}",cc1f60a9-940b-4d1f-b454-ecdbb836fffb,https://nypost.com/2017/12/30/my-son-was-wrongly-accused-of-sexual-misconduct-at-school,This 11-year-old got wrongly caught up in the Pervnado,"544 7th Avenue, Brooklyn, NY",Sunset Park,New York City,2017-12-31 1:21:38,"Jonathan Lopez, a Brooklyn sixth-grader in a schoolyard tussle with two girls, got caught up in the sex-harassment tornado. Jonathan insists he only tried to grab the water bottle and backpack of c…","[{""id"": ""17b72262-4df8-4078-89ac-cda5eeaae901"", ""location_id"": ""ea5f5412-dcf6-4256-afc8-4a0e69e4cf73"", ""neighborhood_id"": ""3e5df1bd-0d02-46fa-9be0-6cf87c7c0f63"", ""neighborhood_name"": ""Sunset Park"", ""city_id"": ""6f17c6a4-a745-450e-aee
@zocoi
zocoi / miniset2.csv
Created February 2, 2018 06:58
We can't make this file beautiful and searchable because it's too large.
,Unnamed: 0,Unnamed: 0.1,category,created_at,description,source,neighborhood_name,id,locations,title,link,formatted_address,city_name,name
0,1,45056,"{""id"": ""crime_safety"", ""name"": ""Crime & Safety""}",2017-06-13 23:20:44,"An elderly Studio City woman is recovering after she was beaten inside her home Monday night during a “knock-knock burglary” gone wrong, authorities said.Los Angeles Police Department Officer Tony Im of the Media Relations Section","{""id"": ""d49e214f-b1a2-4e30-aea5-4574c4c13c1a"", ""name"": ""rss news"", ""broken_reason"": null, ""link"": ""http://www.dailynews.com/section?mime=xml&profile=4000030&template=RSS"", ""status"": ""on"", ""type"": ""rss"", ""publisher"": {""id"": ""92c8cbcc-37c6-4c96-a368-db0ace0ed1c6"", ""city_id"": ""81e80b6c-d108-4f4d-a9f9-1479ca347c7f"", ""name"": ""L.A. Daily News"", ""city_name"": ""Los Angeles"", ""logo"": {""id"": ""41845cc8-739f-484b-95b1-a7d1ed4863d2"", ""type"": ""image"", ""original_url"": {""url"": ""https://d2wcpa9bmrr57n.cloudfront.net/ori
@zocoi
zocoi / compare2.csv
Created April 4, 2018 20:16
We can't make this file beautiful and searchable because it's too large.
,Unnamed: 0,Unnamed: 0.1,category,created_at,description,source,neighborhood_name,Article IDs,locations,Article Title,Article Links,Google Tagged name,Mapbox Tagged Name,Google Tagged address,Google Tagged City,mapbox_json,Mapbox address,Mapbox city,Google v.s Mapbox Is Match? ,Correct Mapbox ID,Missing POI (Y/N),POI Types,Notes,,Unnamed: 0,Unnamed: 0.1,category,created_at,description,source,neighborhood_name,id,locations,title,link,Google Tagged City,Yelp Tagged Name,Google Tagged name,Google Tagged address,Yelp Tagged address,Yelp Tagged city,Yelp Tagged state,Yelp postal_code,Google v.s Yelp is Match (Y/N),Missing POI (Y/N),POI Types,Notes,"Mapbox (0,1)","Yelp (0,1)",MapBox+Yelp
3037,2927,45050,"{""id"": ""community_society"", ""name"": ""Community & Society""}",2017-06-13 23:32:15,Our ABC7 Pet of the Week is an 8-month old Jack Russell Terrier mix named Benny. Please help give him a good home!,"{""id"": ""0b192e95-568a-4061-a47d-f1d060933e99"", ""name"": ""ABC7 rss"", ""broken_reason"": null, ""link"": ""
@zocoi
zocoi / compare2.csv
Created April 4, 2018 20:16
We can't make this file beautiful and searchable because it's too large.
,Unnamed: 0,Unnamed: 0.1,category,created_at,description,source,neighborhood_name,Article IDs,locations,Article Title,Article Links,Google Tagged name,Mapbox Tagged Name,Google Tagged address,Google Tagged City,mapbox_json,Mapbox address,Mapbox city,Google v.s Mapbox Is Match? ,Correct Mapbox ID,Missing POI (Y/N),POI Types,Notes,,Unnamed: 0,Unnamed: 0.1,category,created_at,description,source,neighborhood_name,id,locations,title,link,Google Tagged City,Yelp Tagged Name,Google Tagged name,Google Tagged address,Yelp Tagged address,Yelp Tagged city,Yelp Tagged state,Yelp postal_code,Google v.s Yelp is Match (Y/N),Missing POI (Y/N),POI Types,Notes,"Mapbox (0,1)","Yelp (0,1)",MapBox+Yelp
3037,2927,45050,"{""id"": ""community_society"", ""name"": ""Community & Society""}",2017-06-13 23:32:15,Our ABC7 Pet of the Week is an 8-month old Jack Russell Terrier mix named Benny. Please help give him a good home!,"{""id"": ""0b192e95-568a-4061-a47d-f1d060933e99"", ""name"": ""ABC7 rss"", ""broken_reason"": null, ""link"": ""