Nice but the SIC data is hierarchical and the schema you defined makes it hard to find parent and child entries.
This should be more sth like:
CREATE TABLE `sic_code` (
`code` varchar(32) NOT NULL DEFAULT ”,
`label` varchar(256) DEFAULT NULL,
`parent_code` varchar(32) DEFAULT NULL,
`level` int(11) DEFAULT NULL
) DEFAULT CHARSET=utf8;

INSERT INTO `sic_code` (`code`,`label`,`parent_code`,`level`)
VALUES
(‘D’,’MANUFACTURING’,NULL,0),
(‘I’,’SERVICES’,NULL,0),
(‘H’,’FINANCE, INSURANCE, AND REAL ESTATE’,NULL,0),
(‘F’,’WHOLESALE TRADE’,NULL,0),
(‘E’,’TRANSPORTATION, COMMUNICATIONS, ELECTRIC, GAS, AND SANITARY SERVICES’,NULL,0),
(‘J’,’PUBLIC ADMINISTRATION’,NULL,0),
(‘3199′,’Leather goods, not elsewhere classified’,’319′,3),
(‘478′,’Miscellaneous services incidental to transportation’,’47’,2),
(‘473′,’Arrangement of transportation of freight and cargo’,’47’,2),
(‘474′,’Rental of railroad cars’,’47’,2),
(‘8399′,’Social services, not elsewhere classified’,’8

Pretty neat solution!

Thanks! :)

Using your ready-made SIC code SQL. Thanks — this will save me a bit of time!

Glad I could help! :) Thanks again, this made a report I was writing much easier!

@Alex: Ah, that what it was then – some of the statements failed, but I didn’t notice and/or care when I imported it.

Then I read your post literally like 5 minutes after reading the bug report about missing values on the test system and I was like “aw, crap!”. :)

It shall be easy to fix now. Thanks!

Hey Luke,

That’s strange, I just checked my DB and I have all the values, including between 23xx and 35xx. I did have to sanitize the SQL file a bit; you had semicolons in the `description` values which were throwing things off. I have an updated SQL file with all the quotes sanitized which ran without any errors; if you want I’ll email it to you, just let me know and leave me your email address (mine is alex@imperialtextile.com.

@Alex: Btw, a recent ticket in my bug tracking system tells me that list is incomplete. It’s missing entries between 23xx and 35xx codes.

I shall update it here once I get to it at work. Must clear all the stuff that is marked critical and omg-the-sky-is-falling first.

Hey… I have been searching for just this kind of file! I was hoping at best for TXT or CSV but to find the SQL is ideal so thank you very much!

@Jaba: Ah, yes. The code highlighting plugin actually escapes all the HTML entities automatically. :)

And yeah, I’m somewhat familiar with macros. The beautiful thing about lisp is that it’s code is expressed in therms of it’s data structures. So data can be code, and code can be data, which introduces a mind boggling level of flexibility into the language.

Thanks for the examples. I will have to go over them slowly again later. :)

mmm let me re-write the end of the last pps:
with pre lang=”lisp” plugin, the & character gets represented as:

 &