GitHub Repository Link:¶
https://github.com/neherdata/njsavi.neherdata.com
Launch on Binder:¶
Reference links:¶
https://dev.socrata.com/foundry/data.nj.gov/tfhb-8beb¶
https://data.nj.gov/stories/s/NJSAVI-Dataset-Story/9k98-6fqb/¶
Datasets Used:¶
Out-of-State Businesses Certified in NJ by State [yiaw-wr5c = out_of_state_businesses_certified_in_nj_by_state]¶
https://data.nj.gov/resource/yiaw-wr5c.json¶
https://data.nj.gov/resource/yiaw-wr5c.csv¶
The New Jersey Selective Assistance Vendor Information (NJSAVI) [tfhb-8beb = njsavi]¶
https://data.nj.gov/w/tfhb-8beb/default?cur=wGrdnkPCZjy¶
https://www.opendatanetwork.com/dataset/data.nj.gov/tfhb-8beb¶
https://data.nj.gov/resource/tfhb-8beb.json¶
https://data.nj.gov/resource/tfhb-8beb.csv¶
NJ Certified Businesses by Zip Code Based on NJSAVI [8anu-hsjm = nj_certified_businesses]¶
https://data.nj.gov/resource/8anu-hsjm.json¶
https://data.nj.gov/resource/8anu-hsjm.csv¶
In [ ]:
import pandas as pd
from sodapy import Socrata
import env
In [ ]:
# import app_token from env.py, create using env-template.py
app_token = env.app_token
In [ ]:
# Unauthenticated client only works with public data sets. Note 'None'
# in place of application token, and no username or password:
# client = Socrata("data.nj.gov", None)
# Example authenticated client (needed for non-public datasets):
client = Socrata("data.nj.gov", app_token=app_token)
In [ ]:
# Returned as JSON from API / converted to Python list of
# dictionaries by sodapy.
njsavi = client.get("tfhb-8beb")
out_of_state_businesses_certified_in_nj_by_state = client.get("yiaw-wr5c")
nj_certified_businesses = client.get("8anu-hsjm")
In [ ]:
# Convert to pandas DataFrame
njsavi_df = pd.DataFrame.from_records(njsavi)
njsavi_df
Out[ ]:
| business_name | business_address | business_city | business_state | business_zip | contact_name | primary_phone | email_address | major_field_of_operation | certification_type | commodity_type | commodity_code_description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BTNJ, LLC (AKA) POWER & AUTOMATION ELECTRICAL ... | 851 VAN HOUTEN AVE | CLIFTON | NJ | 7013 | JOSEPH CASCIANO | (973)777-4701 | NOLIVEIRA@POWERANDAUTOMATION.COM | INDUSTRIAL ELECTRIC CONTRACTOR MAINLY PROVIDIN... | SBE | CONSTRUCTION CRAFT | NaN |
| 1 | WICKERSHEIM & SONS, INC. (AKA) WICKERSHEIM & S... | 92 FAIRMOUNT AVE. | HACKENSACK | NJ | 7601 | ROBERT WICKERSHEIM | (201)343-4157 | INFO@WICKERSHEIMPLUMBING.COM | PLUMBING, HEATING AND AIR CONDITIONING SERVICE... | SBE | CONSTRUCTION CRAFT | NaN |
| 2 | GALIA CONSTRUCTION, INC. | 94 GORDON AVENUE | TOTOWA | NJ | 7512 | ELIZABETA BOSKOVSKI | (973)897-4450 | GALIACONSTRUCTION@YAHOO.COM | GALIA CONSTRUCTION, INC. IS CONCENTRATED IN RE... | SBE | CONSTRUCTION CRAFT | NaN |
| 3 | ASSUNCAO BROS., INC. (AKA) ASSUNCAO BROTHERS | 29 WOOD AVE | EDISON | NJ | 8820 | MARTIN ASSUNCAO | (732)549-8582 | GARRETT@ASSUNCAOBROTHERS.COM | HEAVY HIGHWAY CONSTRUCTION, CONCRETE FLATWORK | SBE | CONSTRUCTION CRAFT | NaN |
| 4 | EASTERN ALLIANCE LLC | 400 GOFFLE RD | HAWTHORNE | NJ | 7506 | MATTHEW JACKOWITZ | (201)543-4352 | MATT.JACKOWITZ@EASTALLIANCE.COM | EASTERN ALLIANCE LLC IS A GC PERFORMING TELECO... | SBE | CONSTRUCTION CRAFT | NaN |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 995 | ROBOTECH CAD SOLUTIONS, INC. | 2 MARINE VIEW PLAZA | HOBOKEN | NJ | 7030 | SHLOMO MAROM | (201)792-6300 | SHLOMO@ROBOTECHCAD.COM | COMPUTER AIDED DESIGN (CAD), BUILDING INFORMAT... | SBE | CONSTRUCTION CRAFT | COMMODITY | PLOTTERS, GRAPHIC | ARCHITECTURAL SOFTWARE, ... |
| 996 | INDUSTRIAL/COMMERCIAL CLEANING GROUP, INC. | 14 SOUTH BURNT MILL ROAD | VOORHEES | NJ | 8043 | KIM JORDAN | (856)541-7241 | KJORDAN@ICCGRPINC.COM | FACILITIES SUPPORT SERVICES | SBE | CONSTRUCTION CRAFT | COMMODITY | AGRICULTURAL CROPS AND GRAINS, PURCHASED LOCAL... |
| 997 | SERVICE SUPPORT SPECIALTIES, INC. (AKA) S-CUBED | 6 MARS COURT | MONTVILLE | NJ | 7045 | GARY HILLMAN | (973)263-0640 | GARYH@S-CUBED.COM | SUPPLIER OF SEMICONDUCTOR MACHINERY AND PARTS | SBE | CONSTRUCTION CRAFT | COMMODITY | ACTUATORS AND CONTROLS: ROBOTICS, SERVO SYSTEM... |
| 998 | PSP CONSTRUCTION, INC. | 38 ELIZABETH ST | HACKENSACK | NJ | 7601 | HARESH SAVALIA | (917)299-5157 | PSPCONSSTRUCTION@YAHOO.COM | GENERAL AND HEAVY CONSTRUCTION. | SBE | CONSTRUCTION CRAFT | COMMODITY | CONSTRUCTION SERVICES, HEAVY, INCLUDING MAINTE... |
| 999 | LAMANNA ELECTRIC INC. | 10 WEST MANOR WAY | ROBBINSVILLE | NJ | 8691 | CHARLES LAMANNA JR | (609)259-6282 | DEBBIER@LAMANNAELECTRIC.COM | ELECTRICAL CONTRACTOR | SBE | CONSTRUCTION CRAFT | COMMODITY | ACOUSTICAL TILE, INSULATING MATERIALS, AND SUP... |
1000 rows × 12 columns
In [ ]:
# Convert to pandas DataFrame
out_of_state_businesses_certified_in_nj_by_state_df = pd.DataFrame.from_records(
out_of_state_businesses_certified_in_nj_by_state
)
out_of_state_businesses_certified_in_nj_by_state_df
Out[ ]:
| business_name | business_address | business_city | business_state | business_zip | contact_name | primary_phone | email_address | major_field_of_operation | commodity_code_description | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | STAATS, AIMEE (AKA) DAKOTA CONSULTING | 8761 BLUFF LANE | FAIR OAKS | CA | 95628 | AIMEE STAATS | (916)642-9410 | APSTAATS@GMAIL.COM | MANAGEMENT CONSULTING, PROPOSAL MANAGEMENT, RE... | MANAGEMENT CONSULTING |
| 1 | INTUEOR CONSULTING INC | 7700 IRVINE CENTER DRIVE, STE 610 | IRVINE | CA | 92618 | VIJENDER MIDIDADDI | (949)466-5663 | MIDIDADDI@INTUEOR.COM | INTUEOR IS A STRATEGY, MANAGEMENT, AND TECHNOL... | MANAGEMENT CONSULTING |
| 2 | LOTUS NEW JERSEY LLC (AKA) LOTUS NEW JERSEY LLC | 38 MOSS STREET, UNIT B103 | SAN FRANCISCO | CA | 94103 | PHUONG TRAN | (415)235-1388 | JOSHUABLACK33@GMAIL.COM | APPLYING FOR LEGAL AND LICENSED RETAIL CANNABI... | MISCELLANEOUS PRODUCTS (NOT OTHERWISE CLASSIFI... |
| 3 | MAKE GREEN GO, INC. | 405 MORELLO DR | HAYWARD | CA | 94541 | LA WANDA KNOX | (510)255-4669 | LAWANDA@MAKEGREENGO.COM | ONLINE EDUCATION AND TRAINING, CURRICULUM DEVE... | CONSULTING SERVICES | ADMINISTRATIVE CONSULT... |
| 4 | EXAVALU, INC. (AKA) EXAVALU | 5000 BIRCH STREET, WEST TOWER, SUITE 3000 | NEWPORT BEACH | CA | 92660 | REFIK ONGUN | (310)245-2855 | ACCOUNTING@EXAVALU.COM | INFORMATION TECHNOLOGY CONSULTING SERVICES | CONSULTING SERVICES |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 420 | ASTYRA CORPORATION | 411 FRANKLIN STREET, SUITE 105 | RICHMOND | VA | 23219 | KENNETH AMPY | (804)433-1100 | REMIT@ASTYRA.COM | STAFFING AGENCY | GEOGRAPHIC INFORMATION SYSTEMS (GIS) | OFFIC... |
| 421 | OAKTON INFRASTRUCTURE SOLUTIONS LLC (AKA) OAKT... | 3000 PHYLLMAR PLACE | OAKTON | VA | 22124 | PRAVEEN MATHEWS | (516)780-5060 | PRAVEEN@OAKTONIS.COM | CONSULTING SERVICES IN ENERGY CONSERVATION AND... | ENERGY CONSERVATION SERVICES, INCLUDING AUDITS |
| 422 | WIZZY'S NJ LLC | 500 106TH AVE. NE #1801 | BELLEVUE | WA | 98004 | ZOYA VOLYNSKY | (206)601-3598 | ZOYA@BELLEVUEHILLS.COM | CANNABIS ESTABLISHMENT | DRUGS AND PHARMACEUTICALS | MISCELLANEOUS PR... |
| 423 | HIGHER LEAF LLC | 13611 NE 8TH STREET, UNIT 207 | BELLEVUE | WA | 98005 | MIRA ILYAGUYEV | (425)445-9925 | MIRAZDY@HOTMAIL.COM | CANNABIS ESTABLISHMENT | DRUGS AND PHARMACEUTICALS | MISCELLANEOUS PR... |
| 424 | ILLUME ADVISING LLC (AKA) ILLUME ADVISING, LLC | 440 SCIENCE DRIVE, SUITE 202 | MADISON | WI | 53711 | ALYSSA PRICE | (608)807-2061 | ALYSSA@ILLUMEADVISING.COM | ILLUME ADVISING IS A WHOLLY WOMAN-OWNED RESEAR... | ENERGY CONSERVATION SERVICES, INCLUDING AUDITS... |
425 rows × 10 columns
In [ ]:
nj_certified_businesses_df = pd.DataFrame.from_records(nj_certified_businesses)
nj_certified_businesses_df
Out[ ]:
| business_name | business_address | business_city | business_state | business_zip | contact_name | primary_phone | email_address | major_field_of_operation | commodity_code_description | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BTNJ, LLC (AKA) POWER & AUTOMATION ELECTRICAL ... | 851 VAN HOUTEN AVE | CLIFTON | NJ | 7013 | JOSEPH CASCIANO | (973)777-4701 | NOLIVEIRA@POWERANDAUTOMATION.COM | INDUSTRIAL ELECTRIC CONTRACTOR MAINLY PROVIDIN... | NaN |
| 1 | WICKERSHEIM & SONS, INC. (AKA) WICKERSHEIM & S... | 92 FAIRMOUNT AVE. | HACKENSACK | NJ | 7601 | ROBERT WICKERSHEIM | (201)343-4157 | INFO@WICKERSHEIMPLUMBING.COM | PLUMBING, HEATING AND AIR CONDITIONING SERVICE... | NaN |
| 2 | GALIA CONSTRUCTION, INC. | 94 GORDON AVENUE | TOTOWA | NJ | 7512 | ELIZABETA BOSKOVSKI | (973)897-4450 | GALIACONSTRUCTION@YAHOO.COM | GALIA CONSTRUCTION, INC. IS CONCENTRATED IN RE... | NaN |
| 3 | ASSUNCAO BROS., INC. (AKA) ASSUNCAO BROTHERS | 29 WOOD AVE | EDISON | NJ | 8820 | MARTIN ASSUNCAO | (732)549-8582 | GARRETT@ASSUNCAOBROTHERS.COM | HEAVY HIGHWAY CONSTRUCTION, CONCRETE FLATWORK | NaN |
| 4 | EASTERN ALLIANCE LLC | 400 GOFFLE RD | HAWTHORNE | NJ | 7506 | MATTHEW JACKOWITZ | (201)543-4352 | MATT.JACKOWITZ@EASTALLIANCE.COM | EASTERN ALLIANCE LLC IS A GC PERFORMING TELECO... | NaN |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 995 | ROBOTECH CAD SOLUTIONS, INC. | 2 MARINE VIEW PLAZA | HOBOKEN | NJ | 7030 | SHLOMO MAROM | (201)792-6300 | SHLOMO@ROBOTECHCAD.COM | COMPUTER AIDED DESIGN (CAD), BUILDING INFORMAT... | PLOTTERS, GRAPHIC | ARCHITECTURAL SOFTWARE, ... |
| 996 | INDUSTRIAL/COMMERCIAL CLEANING GROUP, INC. | 14 SOUTH BURNT MILL ROAD | VOORHEES | NJ | 8043 | KIM JORDAN | (856)541-7241 | KJORDAN@ICCGRPINC.COM | FACILITIES SUPPORT SERVICES | AGRICULTURAL CROPS AND GRAINS, PURCHASED LOCAL... |
| 997 | SERVICE SUPPORT SPECIALTIES, INC. (AKA) S-CUBED | 6 MARS COURT | MONTVILLE | NJ | 7045 | GARY HILLMAN | (973)263-0640 | GARYH@S-CUBED.COM | SUPPLIER OF SEMICONDUCTOR MACHINERY AND PARTS | ACTUATORS AND CONTROLS: ROBOTICS, SERVO SYSTEM... |
| 998 | PSP CONSTRUCTION, INC. | 38 ELIZABETH ST | HACKENSACK | NJ | 7601 | HARESH SAVALIA | (917)299-5157 | PSPCONSSTRUCTION@YAHOO.COM | GENERAL AND HEAVY CONSTRUCTION. | CONSTRUCTION SERVICES, HEAVY, INCLUDING MAINTE... |
| 999 | LAMANNA ELECTRIC INC. | 10 WEST MANOR WAY | ROBBINSVILLE | NJ | 8691 | CHARLES LAMANNA JR | (609)259-6282 | DEBBIER@LAMANNAELECTRIC.COM | ELECTRICAL CONTRACTOR | ACOUSTICAL TILE, INSULATING MATERIALS, AND SUP... |
1000 rows × 10 columns