Yuichi Yazaki n1n9-jp
n1n9-jp
/ 落札実績（Json）
Created
June 23, 2023 09:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ファイルバージョン,ファイル名,落札実績情報,調達案件番号,調達案件名称,落札決定日,落札価格,府省コード,入札方式コード,商号又は名称,法人番号 | |
| fileversion,filename,successfulBidRecordInfo,procurementItemNo,procurementItemNm,successfulBidDate,successfulBidPrice,ministryCd,biddingMethodCd,tradeNameKanji,corporationNo |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 調達案件番号,調達案件名称,落札決定日,落札価格,府省コード,入札方式コード,商号又は名称,法人番号 |
n1n9-jp
/ 国税庁・リソース定義書・法人種別
Created
February 18, 2023 03:40
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| コード 項目値名称 | |
| 101 国の機関 | |
| 201 地方公共団体 | |
| 301 株式会社 | |
| 302 有限会社 | |
| 303 合名会社 | |
| 304 合資会社 | |
| 305 合同会社 | |
| 399 その他の設立登記法人 | |
| 401 外国会社等 |
n1n9-jp
/ detect_404_before_error
Created
March 11, 2022 00:34
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // https://www.finleyghosh.com/blog/check-for-a-page-404-with-only-javascript | |
| function UrlExists(url) { | |
| var http = new XMLHttpRequest(); | |
| http.open('HEAD', url, false); | |
| http.send(); | |
| if (http.status != 404) | |
| return true; | |
| else | |
| return false; |
n1n9-jp
/ 国税庁全データ変数名（CSV版）
Last active
July 1, 2023 04:10
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sequenceNumber,corporateNumber,process,correct,updateDate,changeDate,name,nameImageId,kind,prefectureName,cityName,streetNumber,addressImageId,prefectureCode,cityCode,postCode,addressOutside,addressOutsideImageId,closeDate,closeCause,successorCorporateNumber,changeCause,assignmentDate,latest,enName,enPrefectureName,enCityName,enAddressOutside,furigana,hihyoji | |
| 一連番号,法人番号,処理区分,訂正区分,更新年月日,変更年月日,商号又は名称,商号又は名称イメージID,法人種別,国内所在地（都道府県）,国内所在地（市区町村）,国内所在地（丁目番地等）,国内所在地イメージID,都道府県コード,市区町村コード,郵便番号,国外所在地,国外所在地イメージID,登記記録の閉鎖等年月日,登記記録の閉鎖等の事由,承継先法人番号,変更事由の詳細,法人番号指定年月日,最新履歴,商号又は名称（英語表記）,国内所在地（都道府県）（英語表記）,国内所在地（市町村丁目番地等）（英語表記）,国外所在地（英語表記）,フリガナ,検索対象除外 |
n1n9-jp
/ BigQuery.sql
Last active
May 10, 2020 08:52
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #【BigQuery】CREATE文を使えるの知ってた？SQLでテーブル作成｜ 開発者ブログ ｜ 株式会社アイソルート https://www.isoroot.jp/blog/1651/ | |
| #Google BigQuery の SQL文tips - 備忘録 blog http://sharply.hatenablog.com/entry/2019/04/15/000641 | |
| # example1 | |
| SELECT count(name) | |
| FROM [プロジェクトID:tokyo_companies.company] | |
| WHERE city = "千代田区" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Python code to remove emoji | |
| # source: http://www.unicode.org/charts/ | |
| import re | |
| def remove_emojis(data): | |
| emoj = re.compile("[" | |
| u"\U00002700-\U000027BF" # Dingbats | |
| u"\U0001F600-\U0001F64F" # Emoticons | |
| u"\U00002600-\U000026FF" # Miscellaneous Symbols |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| license: mit |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| license: mit |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "nodes": [ | |
| { | |
| "name_en": "Independent Regions", | |
| "name_ja": "自立地域 ", | |
| "group": "町", | |
| "id": 1 | |
| }, | |
| { | |
| "name_en": "The Distribution Of Towns", |
NewerOlder