Businesses Registered With EBR Parish
City of Baton Rouge
@usgov.city_of_baton_rouge_businesses_registered_with_ebr_parish
City of Baton Rouge
@usgov.city_of_baton_rouge_businesses_registered_with_ebr_parish
CREATE TABLE table_1 (
"account_no" BIGINT,
"account_name" VARCHAR,
"legal_name" VARCHAR,
"account_location_code" DOUBLE,
"account_location" VARCHAR,
"contact_person" VARCHAR,
"business_open_date" TIMESTAMP,
"business_status" VARCHAR,
"business_close_date" TIMESTAMP,
"ownership_type" VARCHAR,
"account_type_code" DOUBLE,
"account_type" VARCHAR,
"home_based_business" VARCHAR,
"naics_code" DOUBLE,
"naics_category" VARCHAR,
"naics_group" VARCHAR,
"abc_status_code" BIGINT,
"abc_status" BIGINT,
"consolidated_filer" BIGINT,
"filing_frequency" VARCHAR,
"mailing_address_line_1" VARCHAR -- MAILING ADDRESS - LINE 1,
"mailing_address_line_2" VARCHAR -- MAILING ADDRESS - LINE 2,
"mailing_address_city" VARCHAR -- MAILING ADDRESS - CITY,
"mailing_address_state" VARCHAR -- MAILING ADDRESS - STATE,
"mailing_address_zip_code" VARCHAR -- MAILING ADDRESS - ZIP CODE,
"physical_address_line_1" VARCHAR -- PHYSICAL ADDRESS - LINE 1,
"physical_address_line_2" VARCHAR -- PHYSICAL ADDRESS - LINE 2,
"physical_address_city" VARCHAR -- PHYSICAL ADDRESS - CITY,
"physical_address_state" VARCHAR -- PHYSICAL ADDRESS - STATE,
"physical_address_zip_code" VARCHAR -- PHYSICAL ADDRESS - ZIP CODE,
"address_id" VARCHAR,
"geolocation" VARCHAR
);
Anyone who has the link will be able to view this.