This is my 78th original article

A product elder brother seeks me to want national standard administrative division table, I say you want this stem what play? Just ask for one from the guys in The warehouse. He said he couldn’t read what the guys in the warehouse gave him. I was convinced

We actually have a lot of sources of data. Take the national standard administrative region as an example, this is the official release of the national government, we directly go to the official website to find it.

Some people go to the statistics bureau, and the statistics bureau updates them, but by the nature of their work they update their data on an annual basis.

So here it is: the Ministry of Civil Affairs.

www.mca.gov.cn/article/sj/…

Here is updated every month, there are full and incremental, there are to the city, there are to the county and township. They are all national standard area codes.

And in this text form, it’s very crawl-friendly. Write your own crawler, go and have a look regularly every month, and make sure your administrative district is up to date! Mom doesn’t have to worry about districts being updated anymore.

In addition, it is recommended that you build a date dimension table, although the window function is very easy to use, but in holidays, working days will not work.

I have the dates of counties from 2009 to 2020, and all the holidays are marked for you. Tables are set up, SQL is written for you. You could have just thrown it in the garage.

Of course, you can also write your own, just come once a year, or find a website to climb. This is the kind of thing we could save a lot of time with.

Details, guys! Use technology to make our jobs easier. While using technology to meet the needs of others, don’t forget to take care of yourself.

The date dimension with 11 years of holidays is ready for you, and you can download the document by replying to the background “date dimension”. \

Enjoy better with the following articles

6 layer commercial moat | shells of all solutions!

Analyze | shell behind the secret weapon – this ACN!

Thinking | according to the formula of shells chaozuoye, can succeed?

I need your upvotes. I love you