{"id":34212,"date":"2025-06-05T17:27:59","date_gmt":"2025-06-05T15:27:59","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/how-can-i-build-a-dataset-of-us-public-companies-by-industry-using-naics-sic-codes\/"},"modified":"2025-06-05T17:27:59","modified_gmt":"2025-06-05T15:27:59","slug":"how-can-i-build-a-dataset-of-us-public-companies-by-industry-using-naics-sic-codes","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/how-can-i-build-a-dataset-of-us-public-companies-by-industry-using-naics-sic-codes\/","title":{"rendered":"How Can I Build A Dataset Of US Public Companies By Industry Using NAICS\/SIC Codes?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>I&#8217;m working on a project where I need to identify <strong>all U.S. public companies<\/strong> listed on NYSE, NASDAQ, etc. that have <strong>over $5 million in annual revenue<\/strong> and operate in the following industries:<\/p>\n<ul>\n<li>Energy<\/li>\n<li>Defense<\/li>\n<li>Aerospace<\/li>\n<li>Critical Minerals &amp; Supply Chain<\/li>\n<li>Maritime &amp; Infrastructure<\/li>\n<li>Pharmaceuticals &amp; Biotech<\/li>\n<li>Cybersecurity<\/li>\n<\/ul>\n<p>I&#8217;ve already completed <strong>Step 1<\/strong>, which was mapping out all relevant <strong>2022 NAICS\/SIC codes<\/strong> for these sectors (over 80 codes total, spanning manufacturing, mining, logistics, and R&amp;D).<\/p>\n<p>Now for <strong>Step 2<\/strong>, I want to build a dataset of companies that:<\/p>\n<ol>\n<li>Are listed on U.S. stock exchanges<\/li>\n<li>Report &gt;$5M in revenue<\/li>\n<li>Match one or more of the NAICS codes<\/li>\n<\/ol>\n<h1>My questions:<\/h1>\n<ul>\n<li>What&#8217;s the best public or open-source method to get this data?<\/li>\n<li>Are there APIs (EDGAR, Yahoo Finance, IEX Cloud, etc.) that allow filtering by NAICS and revenue?<\/li>\n<li>Is scraping from company listings (e.g. NASDAQ screener, Yahoo Finance) a viable path?<\/li>\n<li>Has anyone built something similar or have a workflow for this kind of company-industry filtering?<\/li>\n<\/ul><\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Hour_Presentation657\"> \/u\/Hour_Presentation657 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1l40s1g\/how_can_i_build_a_dataset_of_us_public_companies\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1l40s1g\/how_can_i_build_a_dataset_of_us_public_companies\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-34212 jlk' href='javascript:void(0)' data-task='like' data-post_id='34212' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-34212 lc'>0<\/span><\/a><\/div><\/div> <div class='status-34212 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>I&#8217;m working on a project where I need to identify all U.S. public companies listed on NYSE,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-34212","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/34212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=34212"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/34212\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=34212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=34212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=34212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}