Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
---|---|---|---|---|---|---|---|---|---|---|
Apijson | 15,892 | 2 days ago | 224 | other | Java | |||||
🏆 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码,前端(客户端) 定制返回 JSON 的数据和结构。 🏆 A JSON Transmission Protocol and an ORM Library 🚀 provides APIs and Docs without writing any code. | ||||||||||
Sqlmodel | 10,733 | 119 | 3 days ago | 8 | August 30, 2022 | 240 | mit | Python | ||
SQL databases in Python, designed for simplicity, compatibility, and robustness. | ||||||||||
Datasette | 8,268 | 35 | 148 | a day ago | 133 | April 27, 2023 | 542 | apache-2.0 | Python | |
An open source multi-tool for exploring and publishing data | ||||||||||
Poco | 7,334 | 1 | 14 hours ago | 8 | November 02, 2022 | 284 | other | C | ||
The POCO C++ Libraries are powerful cross-platform C++ libraries for building network- and internet-based applications that run on desktop, server, mobile, IoT, and embedded systems. | ||||||||||
Manticoresearch | 6,214 | 10 hours ago | 308 | gpl-2.0 | C++ | |||||
Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon | ||||||||||
Countries States Cities Database | 5,445 | 18 hours ago | 66 | odbl-1.0 | PHP | |||||
🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities | ||||||||||
Octosql | 4,551 | 3 | a month ago | 38 | May 30, 2023 | 39 | mpl-2.0 | Go | ||
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. | ||||||||||
Go Awesome | 3,692 | 2 months ago | 4 | cc0-1.0 | ||||||
Go 语言优秀资源整理,为项目落地加速🏃 | ||||||||||
Dsq | 3,317 | 3 months ago | 2 | October 20, 2022 | 19 | other | Go | |||
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. | ||||||||||
China_regions | 2,882 | 10 months ago | 33 | apache-2.0 | JavaScript | |||||
最全最新中国省,市,地区json及sql数据 |
===
2021/03/22 15:39:04 GMT+0800 ()
npm install province-city-china --save-dev
const { data, province, city, area, town } = require('province-city-china/data');
data
- (///)province
- (//)city
- ()area
- ()town
- (/)const provinces = require('province-city-china/dist/data.json');
// provinces ===>
[
{"code":"110000","name":"","province":"11","city":0,"area":0,"town":0},
{"code":"110101","name":"","province":"11","city":"01","area":"01","town":0},
{"code":"110102","name":"","province":"11","city":"01","area":"02","town":0},
{"code":"110105","name":"","province":"11","city":"01","area":"05","town":0},
....
]
province - (//)
- city=0
, area=0
, town=0
city - ()
- area=0
, town=0
area - ()
- town=0
0
town - (/)
- 0
province
1``2``3``4``5``6
-> 42
4
``
const city = require('province-city-china/dist/city.json');
// city ===>
[
{"code":"01","name":"","province":"13"},
{"code":"02","name":"","province":"13"},
{"code":"03","name":"","province":"13"},
{"code":"04","name":"","province":"13"},
{"code":"05","name":"","province":"13"},
....
]
code
-name
-province
- //JSON | CSV | SQL | CDN | |
---|---|---|---|---|
(#13) | country.json (min) | country.csv | - | csv / json |
(///) | data.json (min) | data.csv | data.sql | data.sql / csv / json |
(///) | level.json (min) | - | - | level.json |
(//) | province.json (min) | province.csv | - | province.json / csv |
() | city.json (min) | city.csv | - | city.json / csv |
() | area.json (min) | area.csv | - | area.json / csv |
(/) | town.json (min) | town.csv | - | town.json / csv |
not-found-town.json (min) | - | - | not-found-town.json | |
<> |
hongkong.json macau.json |
hongkong.csv / macau.csv | - |
hongkong.json (csv) macau.json (csv) |
district-code.json | district-code.csv | - | district-code.json / csv |
CDN
> <>34
: data/province.json
: data/province.csv
: data/province.min.json
> <>337
: data/city.json
: data/city.csv
: data/city.min.json
> <>2846
: data/area.json
: data/area.csv
: data/area.min.json
> <><><>3217
: data/data.json
: data/data.min.json
: data/data.csv
> <>
: data/level.json
: data/level.min.json
country.json | country.min.json | country.csv
id=cnname=name=fullname=alpha2=alpha3=numeric=
[
{
"id": 1,
"cnname": "",
"name": "Afghanistan",
"fullname": "the Islamic Republic of Afghanistan",
"alpha2": "AF",
"alpha3": "AFG",
"town": 4
},
{
"id": 45,
"cnname": "",
"name": "China",
"fullname": "the People's Republic of China",
"alpha2": "CN",
"alpha3": "CHN",
"town": 156
}
// ...
]
id: 'i'
cnname: 'c'
name: 'n'
fullname: 'f'
alpha2: 'a2'
alpha3: 'a3'
numeric: 'r'
data.json | data.min.json | data.csv | data.sql
<>
[
{
"code": "110000",
"name": "",
"province": "11",
"city": 0,
"area": 0,
"town": 0
},
// ...
]
code: 'c'
name: 'n'
province: 'p'
city: 'y'
area: 'a'
town: 't'
<>
[
{
"code": "420000",
"name": "",
"province": "42",
"children": [
{
"code": "420100",
"name": "",
"province": "42",
"city": "01",
"children": [
{
"code": "420102",
"name": "",
"province": "42",
"city": "01",
"area": "02"
},
// ...
]
}
// ...
]
}
// ...
]
code: 'c'
name: 'n'
province: 'p'
city: 'y'
area: 'a'
children: 'd'
province.json | province.min.json | province.csv
[
{
"code": "110000",
"name": "",
"province": "11"
},
{
"code": "120000",
"name": "",
"province": "12"
},
// ...
]
code: 'c'
name: 'n'
province: 'p'
city: 'y'
area: 'a'
children: 'd'
city.json | city.min.json | city.csv
[
{
"code": "130100",
"name": "",
"province": "13",
"city": "01"
},
// ...
]
code: 'c'
name: 'n'
province: 'p'
city: 'y'
area.json | area.min.json | area.csv
[
{
"code": "110101",
"name": "",
"province": "11",
"city": "01",
"area": "01"
},
// ...
]
code: 'c'
name: 'n'
province: 'p'
city: 'y'
area: 'a'
town.json | town.min.json | town.csv
[
{
"code": "110101001000",
"name": "",
"province": "11",
"city": "01",
"area": "01",
"town": "001000"
},
// ...
]
code: 'c'
name: 'n'
province: 'p'
city: 'y'
area: 'a'
town: 't'
not-found-town.json | not-found-town.min.json
[
{
"code": "659010",
"name": "",
"province": "65",
"city": "90",
"area": "10",
"town": 0
},
// ...
]
code: 'c'
name: 'n'
province: 'p'
city: 'y'
area: 'a'
town: 't'
hongkong.json | hongkong.csv | macau.json | macau.csv
[
{
"code": "810002",
"name": "",
"province": "81",
"city": "00",
"area": "02"
},
// ...
]
district-code.json | district-code.csv
[
{ "name": "", "code": "010" },
// ...
]
http://www.mca.gov.cn/article/sj/xzqh/2020/20201201.html
-``
([](http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2021/42.html)[](http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2021/41.html)) [`-`]
``
http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2021/<>/<><>.html
- 42 -> #
- 46 -> #
- 65 -> #
- 41 -> #
# - 46 ->
# - 23 ->
4
``
90
[
{ code: '429004', name: '', province: '42', city: '90' },
{ code: '429005', name: '', province: '42', city: '90' },
{ code: '429006', name: '', province: '42', city: '90' },
{ code: '429021', name: '', province: '42', city: '90' }
]
http://www.mca.gov.cn/article/sj/xzqh/2020/20201201.html
<><><> csv
, min.json
, level.json
, level.min.json
<>
<>
<>
<><>
001099
100199
200399
400599
001199
200-399