Skip to content

Instantly share code, notes, and snippets.

View rutgerhofste's full-sized avatar

Rutger Hofste rutgerhofste

  • WRI
  • Washington DC
View GitHub Profile
Facility Name,Street Address,City,State/Province,Zip code,Country
Adiv Pure Nature Products Pvt Ltd,"B/10,Nandkishore industrial Estate, off Mahakali caves road, Andheri East. ",Mumbai ,,400093,India
Andari Fashion Inc.,9626 Telstar Avenue, El Monte,CA,91731,USA
"APRESTOS DE LANERIA, S.A.","MOLI AMAT, S/N (RIU RIPOLL) 08208-SABADELL-",BARCELONA,,,Spain
Art Atlas,URB Quinta Tristan Z4-11 - Jose Bustamante,Arequipa,,,Peru
"BAIRD MC NUTT, IRELAND",72 SHANKBRIDGE ROAD,KELLS,BALLYMENA,,N.IRELAND
Bo Luo Liga Plus Knitting Ltd,1460-1514 Jin Long Da Dao,"Boluo Xian, Huizhou Shi",Guangdong Sheng,,China
BOSSA T.A.S.,HACI SABANCI ORGAN?ZE SANAY?? BÖLGES? TURGUT ÖZAL BUL. NO.2 01350 SARIÇAM ,,,,Turkey
CARIAGGI LANIFICIO SPA,VIA FLAMINIA NORD 48 CAGLI,,,,ITALY
Dongguan Changping Wisfield Knitting Co. Ltd.,"Xia Keng Industrial Zone, Xia Keng, Chang Ping",Dongguan,GuangDong,,China
This file has been truncated, but you can view the full file.
62 Another Development - AD Sanchaung, Yangon 11111 MM
MOOSMATTENSTR. 25,79117 FREIBURG
19555 ,Shoemakersville, PA
Vintergatan 50, Skelleftehamn
110 W Tehachapi Blvd Tehachapi, CA 93561-1632, United States
UHRLAUBSTR. 9,31582 NIENBURG
locate=0 Hwy 29 North, Danielsville, GA 30633, US
AVENWEDDER STR. 55,33335 G�TERSLOH
IM LERCHENRAIN 3,74626 BRETZFELD
LUBLIN, UL. SEKUTOWICZA 35 35A, DIEGO PIZZA
@rutgerhofste
rutgerhofste / complete_v02.csv
Last active May 3, 2019 12:00
make_it_rain_soybean_yield
We can't make this file beautiful and searchable because it's too large.
year,STATEFP,COUNTYFP,YIELD_SOYBEAN_BUSHELPERACRE,UNIQUE_ID,STATE,COUNTY
2009,1,1,30,STATE_1_COUNTY_1,AL,Autauga County
2010,1,1,16.9,STATE_1_COUNTY_1,AL,Autauga County
2011,1,1,26,STATE_1_COUNTY_1,AL,Autauga County
2013,1,1,41.2,STATE_1_COUNTY_1,AL,Autauga County
2016,1,1,0,STATE_1_COUNTY_1,AL,Autauga County
2003,5,1,45,STATE_5_COUNTY_1,AR,Arkansas County
2004,5,1,46,STATE_5_COUNTY_1,AR,Arkansas County
2005,5,1,41,STATE_5_COUNTY_1,AR,Arkansas County
2006,5,1,46,STATE_5_COUNTY_1,AR,Arkansas County
NAME_1 VARNAME_1 STATE_FIPS
Arkansas AR 5
Illinois IL 17
Indiana IN 18
Iowa IA 19
Kansas KS 20
Minnesota MN 27
Missouri MO 29
Nebraska NE 31
North Dakota ND 38
@rutgerhofste
rutgerhofste / example.csv
Created May 3, 2019 18:33
histogram bigquery
We can't make this file beautiful and searchable because it's too large.
system:index,COUNTYFP,LST_Day_1km,Land_Cover_Type_1,NAME,STATEFP,sur_refl_b01,sur_refl_b02,sur_refl_b03,sur_refl_b04,sur_refl_b05,sur_refl_b06,sur_refl_b07,.geo
00005b20f5ee97c47684,031,"[[0.0, 4.0], [8.0, 0.0], [16.0, 0.0], [24.0, 0.0], [32.0, 0.0], [40.0, 0.0], [48.0, 0.0], [56.0, 0.0], [64.0, 1.0], [72.0, 1.0], [80.0, 4.0], [88.0, 0.0], [96.0, 0.0], [104.0, 0.0], [112.0, 0.0], [120.0, 0.0], [128.0, 0.0], [136.0, 0.0], [144.0, 0.0], [152.0, 0.0], [160.0, 0.0], [168.0, 0.0], [176.0, 0.0], [184.0, 0.0], [192.0, 0.0], [200.0, 0.0], [208.0, 0.0], [216.0, 0.0], [224.0, 0.0], [232.0, 0.0], [240.0, 0.0], [248.0, 0.0]]","[[0.0, 0.0], [8.0, 10.0], [16.0, 0.0], [24.0, 0.0], [32.0, 0.0], [40.0, 0.0], [48.0, 0.0], [56.0, 0.0], [64.0, 0.0], [72.0, 0.0], [80.0, 0.0], [88.0, 0.0], [96.0, 0.0], [104.0, 0.0], [112.0, 0.0], [120.0, 0.0], [128.0, 0.0], [136.0, 0.0], [144.0, 0.0], [152.0, 0.0], [160.0, 0.0], [168.0, 0.0], [176.0, 0.0], [184.0, 0.0], [192.0, 0.0], [200.0, 0.0], [208.0, 0.0], [216.0, 0.0], [224.0, 0.0], [232.0,
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 40 columns, instead of 31. in line 2.
dayofyear,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019
1,1.480330512,2.793618662,2.406307453,7.347986741,8.940525147,4.176921844,2.526860476,2.280632492,7.021742388,4.867977188,7.843544556,3.51459728,2.085447555,2.441190588,9.346102846,2.551887896,3.86302963,1.775953473,2.994755248,2.41926193,2.08842335,7.070227207,2.263064725,3.951957345,2.21285154,2.572686646,2.152149275,3.981434269,4.301088885,2.846923767,7.934326535,8.772714168,1.968872577,2.279577898,2.773446393,2.267968844,2.952547192,2.467595253,2.636406137
6,3.002461915,4.958106722,4.1640819,11.98915654,11.23016054,7.635143145,4.899311502,4.08726464,15.35203131,8.945329365,10.71868857,5.394065525,3.645456647,4.432518638,15.48630894,5.19587659,9.091153033,2.363738715,5.295967277,4.517586631,3.783647159,10.27984572,3.993540897,6.84410369,6.24773649,5.353579097,3.794264349,5.904076742,8.820615783,6.61990414
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 40 columns, instead of 20. in line 3.
doy,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019
1,0,0,0,2.054361521,8.419297357,0,0,0.196125639,0,3.156129305,5.882610138,5.536418288,0,0,13.1081503,0.279442414,0.013112066,0,0.009001094,0.209941065,0.068736441,0,0,2.210026518,0.111261044,0,0,0,0,0,0,10.14940479,4.693093232,4.287277116,3.046706289,1.264636834,2.907586017,5.161891566,0
2,0,0,0,4.592891856,15.8742555,0,0,5.738429975,0,3.156129305,10.21767472,6.230765639,0.042719697,0,15.32623742,1.16387467,0.331763624,0.043245224,0.009001094,0.209941065,0.128119703,0,0.443420382,2.221262015,0.115764399,0.0150457,0,0,0,2.171839603,1.941218697,15.10511269,4.693093232,4.376128302,3.183847033,1.519362305,4.343652278,5.188236645,1.039875376
3,0,0.361742687,0.190689932,4.592891856,16.14786958,0,0,5.746300543,0,3.178700773,13.40608347,9.40666216,0.049600321,2.962094568,15.32623742,1.16387467,0.331763624,0.06391966,0.111
We can't make this file beautiful and searchable because it's too large.
int64_field_0,pfafid_30spfaf06,temporal_resolution,year,month,area_m2_30spfaf06,area_count_30spfaf06,ptotww_m_30spfaf06,ptotwn_m_30spfaf06,pdomww_m_30spfaf06,pdomwn_m_30spfaf06,pindww_m_30spfaf06,pindwn_m_30spfaf06,pirrww_m_30spfaf06,pirrwn_m_30spfaf06,plivww_m_30spfaf06,plivwn_m_30spfaf06,riverdischarge_m_30spfaf06,ma10_ptotww_m_30spfaf06,ma10_ptotwn_m_30spfaf06,ma10_pdomww_m_30spfaf06,ma10_pdomwn_m_30spfaf06,ma10_pindww_m_30spfaf06,ma10_pindwn_m_30spfaf06,ma10_pirrww_m_30spfaf06,ma10_pirrwn_m_30spfaf06,ma10_plivww_m_30spfaf06,ma10_plivwn_m_30spfaf06,ma10_riverdischarge_m_30spfaf06,min10_ptotww_m_30spfaf06,min10_ptotwn_m_30spfaf06,min10_pdomww_m_30spfaf06,min10_pdomwn_m_30spfaf06,min10_pindww_m_30spfaf06,min10_pindwn_m_30spfaf06,min10_pirrww_m_30spfaf06,min10_pirrwn_m_30spfaf06,min10_plivww_m_30spfaf06,min10_plivwn_m_30spfaf06,min10_riverdischarge_m_30spfaf06,max10_ptotww_m_30spfaf06,max10_ptotwn_m_30spfaf06,max10_pdomww_m_30spfaf06,max10_pdomwn_m_30spfaf06,max10_pindww_m_30spfaf06,max10_pindwn_m_30spfaf06,m
integer label
0 Animal
1 Archway
2 Bicyclist
3 Bridge
4 Building
5 Car
6 CartLuggagePram
7 Child
8 Column_Pole
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 40 columns, instead of 20. in line 3.
doy,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019
1,0,0,0,2.054361521,8.419297357,0,0,0.196125639,0,3.156129305,5.882610138,5.536418288,0,0,13.1081503,0.279442414,0.013112066,0,0.009001094,0.209941065,0.068736441,0,0,2.210026518,0.111261044,0,0,0,0,0,0,10.14940479,4.693093232,4.287277116,3.046706289,1.264636834,2.907586017,5.161891566,0
2,0,0,0,4.592891856,15.8742555,0,0,5.738429975,0,3.156129305,10.21767472,6.230765639,0.042719697,0,15.32623742,1.16387467,0.331763624,0.043245224,0.009001094,0.209941065,0.128119703,0,0.443420382,2.221262015,0.115764399,0.0150457,0,0,0,2.171839603,1.941218697,15.10511269,4.693093232,4.376128302,3.183847033,1.519362305,4.343652278,5.188236645,1.039875376
3,0,0.361742687,0.190689932,4.592891856,16.14786958,0,0,5.746300543,0,3.178700773,13.40608347,9.40666216,0.049600321,2.962094568,15.32623742,1.16387467,0.331763624,0.06391966,0.111