inspection

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

activity_nr ▼ reporting_id state_flag estab_name site_address site_city site_state site_zip owner_type owner_code adv_notice safety_hlth sic_code naics_code insp_type insp_scope why_no_insp union_status safety_manuf safety_const safety_marit health_manuf health_const health_marit migrant mail_street mail_city mail_state mail_zip host_est_key nr_in_estab open_date case_mod_date close_conf_date close_case_date ld_dt
18 316700   BOLIE'S METAL FINISHING 123 MAIN ST HARRISBURG PA 17105 A 0 N S 3471 332813 H A   N X             123 MAIN ST HARRISBURG PA 17105 N102 000024233 15 2006-07-11 2016-06-10 2006-07-11 2013-12-31 2016-06-30 01:10:52 EDT
26 951510   RAINBOW SYSTEMS 200 MAPLE STREET HONOLULU HI 96819 A 0 N S 1799 0 C A   Y                     0   20 1993-04-06   1993-04-06 1993-04-06 2011-10-14 16:38:47 EDT
34 112600   SYCAMORE GARDENS CO. 5678 POST ROAD SPRINGFIELD MA 1103 A 0 N S 1799 0 H A   Y X             P.O. BOX 711 SPRINGFIELD MA 1103   75 1992-02-27   1992-02-27 1992-02-27 2011-10-14 16:38:47 EDT
42 253610   HIGHWAY DEPARTMENT TOWN ROTTERDAM 54 DUANESBURG ROAD SCHENECTADY NY 12306 B 0 Y S 8211 0 H A   Y                     0   10 1993-02-02   1993-02-03 1993-02-03 2011-10-14 16:38:47 EDT
75 317900   HICKORY LANES 1725 TENTH AVE. ALLENTOWN PA 18102 A 0 N S 1799 0 H A   Y   X                 0   75 1992-03-25 2011-01-05   2011-01-05 2011-10-14 16:38:47 EDT
109 626300   OAK CANYONS 1427 LONDON LANE DALLAS TX 75228 A 0 N H 4581 0 H A   N       X             0   2 1992-04-01   1992-04-01 1995-07-26 2011-10-14 16:38:47 EDT
117 854910   MULBERRY DEALERSHIP 224 HOLLYWOOD DRIVE SALT LAKE CITY UT 84115 A 0 N S 2070 0 H A   N X                   0   75 1992-12-07   1992-12-08 1992-12-08 2011-10-14 16:38:47 EDT
133 1055340   LARCH LARIX 47 ELMIRA PLACE OLYMPIA WA 98501 A 0 N S 1799 0 H A   Y                     0   75 1992-03-25 2011-01-05 1992-03-27 2011-01-05 2011-10-14 16:38:47 EDT
141 627700   CENTURY ICE OF TULSA, INC. 8904 EAST ADMIRAL PLACE TULSA, OK 74115 A 0 N S 2097 0 H A   B X                   0   21 1987-08-06   1987-08-07 1988-03-03 2011-10-14 16:38:47 EDT
158 418800   HAWTHORN MEADOWS 17 FIFTH STREET PLANTATION FL 33324 A 0 N S 1620 0 H A   Y   X                 0   75 1992-04-01 2011-01-05   2011-01-05 2011-10-14 16:38:47 EDT
232 521700   PARATECH, INCORPORATED 1025 LAMBRECHT ROAD FRANKFORT IL 60423 A 0 N H 3569 0 H A   N       X             0   21 1995-01-19   1995-01-20 1995-07-11 2011-10-14 16:38:47 EDT
992 854910   DEMO 333 VERNAL UT 84078 A 0 N S 1780 0 F A   N X             888 DEMO UT 84014   6 1992-11-18 2011-01-05 1992-11-19 2011-01-05 2011-10-14 16:38:47 EDT
11619 316700   MELLINGER MFG. COMPANY 367 MILLWOOD ROAD WILLOW STREET PA 17584 A 0 N S 3444 0 H D D N                     0   7 1998-03-26 2011-01-05 1998-03-26 2011-01-05 2011-10-14 16:38:47 EDT
16295 215800   ROME IRON MILLS INC COMMERCIAL DR PRICE CHOPPER ST New Hartford NY 13413   0   S 1791 0 H A   A   X                 0   4 1984-01-10   1984-01-11 1984-02-13 2011-10-14 16:38:47 EDT
16865 1032700   CROWN ZELLERBACH CANBY BOOM NE TERRITORIAL RD   OR 97013       S 4491   H A   A     X                   3 1984-01-19 2017-09-28 1984-01-19 1984-02-17 2017-10-03 01:06:11 EDT
16873 1032700   CROWN ZELLERBACH CORP WAREHOUSE NO 3 West Linn OR 97068   0   S 4491 0 H A   A     X               0   600 1984-01-19   1984-01-19 1984-02-27 2011-10-14 16:38:47 EDT
16881 1032700   NORTHWEST MARINE IRON WORKS SWAN ISLAND Portland OR 97217   0   H 3731 0 H A   A                     0   300 1984-01-19   1984-05-16 1984-05-29 2011-10-14 16:38:47 EDT
16899 1032700   US DEPT OF INTERIOR PO BOX B Warm Springs OR 97761 D 7106   H 8099 0 H B   A                     0   5 1984-01-24   1984-02-24 1984-02-27 2011-10-14 16:38:47 EDT
16980 931300   ALPHA CONSTRUCTION CORP ROUTE 1 Dededo GU 96912   0   S 1541 0 H A   B   X                 0   7 1984-01-25   1984-01-25 1984-03-06 2011-10-14 16:38:47 EDT
16998 931300   PACIFIC R & K INC DBA R & K CONST CO LOT 49 Sinajana GU 96910   0   S 1521 0 H A   B   X                 0   3 1984-01-26   1984-01-26 1984-05-17 2011-10-14 16:38:47 EDT
17004 931300   B H S CORPORATION ROUTE 8 Agana GU 96910   0   S 1542 0 H A   B   X                 0   2 1984-01-26   1984-01-26 1985-02-15 2011-10-14 16:38:47 EDT
17053 316100   MEREDITH CONSTRUCTION CO INC FORT MONROE Hampton VA 23664   0   S 1542 0 H A   B   X                 0   30 1984-01-13   1984-01-16 1984-02-06 2011-10-14 16:38:47 EDT
17061 316100   B & H SALES CORP FORT MONROE Hampton VA 23664   0   S 1795 0 H A   B   X                 0   25 1984-01-13   1984-01-16 1984-02-02 2011-10-14 16:38:47 EDT
17418 215600   CARDINAL RIBBON & CARBON CO IN 1075 IRVING AVE New York -Richmond NY 11385   0   S 3955 0 H C   A X                   0   24 1984-01-23   1984-01-23 1984-01-23 2011-10-14 16:38:47 EDT
19497 551800   CURTIS PRODUCTS INC 228 EAST BRONSON South Bend IN 46618   0   S 3498 0 H C   B X                   0   150 1984-01-25   1984-01-25 1984-02-01 2011-10-14 16:38:47 EDT
19786 627400   CONCRETE INC 3101 W INDUSTRIAL Midland TX 79704   0   S 3273 0 H A   B X                   0   45 1984-02-01   1984-02-01 1984-02-23 2011-10-14 16:38:47 EDT
19794 627400   APLEX INDUSTRIES INC 2045 S HOLIDAY HILLS ROAD Midland TX 79703   0   S 3561 0 H C   B X                   0   12 1984-02-02   1984-02-02 1984-02-23 2011-10-14 16:38:47 EDT
19802 627400   EXCEL CORP FRIONA DIV 5 MI W OF FRIONA ON HWY 60 Friona TX 79035   0   S 2011 0 H C   A X                   0   1187 1984-01-31   1984-01-31 1984-02-23 2011-10-14 16:38:47 EDT
19810 627400   ENGINEERED COMPONENTS INC 8605 TRIANGLE DR Amarillo TX 79117   0   S 3448 0 H C   B X                   0   21 1984-02-01   1984-02-01 1984-02-23 2011-10-14 16:38:47 EDT
21444 215000   SPARTAN DISMANTLING CORP 350 PARK AVE New York -Richmond NY 10022   0   H 1795 0 H B   A         X           0   100 1984-01-24   1984-03-20 1984-03-20 2011-10-14 16:38:47 EDT
35220 317500   STERLING LEBANON PACKAGING CORPORATION THOMAS AVENUE & LAFFERTY STREET JEANNETTE PA 15644 A 0 N H 2657 0 B B   Y               P.O. BOX 768 JEANNETTE PA 15644   137 1987-10-02   1987-10-23 1987-12-31 2011-10-14 16:38:47 EDT
53884 355131   J H COTHRAN CO INC BURKS SCOTT BLDG 119 E MAIN ST Bedford VA 24523   0   S 1711 0 H A   B   X                 0   6 1984-01-24   1984-01-25 1984-01-25 2011-10-14 16:38:47 EDT
90779 317740   LEHIGH VALLEY FIREWORKS INC. 7936 VALLEY VIEW RD. NORTHAMPTON PA 18067 A 0 N S 7999 0 H D B                       0     1986-05-27   1986-05-27 1986-06-02 2011-10-14 16:38:47 EDT
100495 215000   BAUM W & E BRONZE TABLET CORP 524 WEST 43RD ST New York -Richmond NY 10036   0   S 3499 0 H C   B X                   0   14 1984-02-02   1984-02-02 1984-02-06 2011-10-14 16:38:47 EDT
100503 215000   TOWER ISLES BAKERY INC 1195 ATLANTIC AVE New York -Richmond NY 11216   0   S 2011 0 H C   B X                   0   45 1984-02-01   1984-02-01 1984-02-02 2011-10-14 16:38:47 EDT
100511 215000   A TO Z KOSHER MEAT PROD CO INC 123 FRAND ST New York -Richmond NY 11211   0   S 2013 0 H C   A X                   0   19 1984-02-01   1984-02-01 1984-02-02 2011-10-14 16:38:47 EDT
100529 215000   CRUCIBLE PRODUCTS CORP 62 NINTH AVE New York -Richmond NY 10011   0   S 2522 0 H C   B X                   0   12 1984-02-01   1984-02-01 1984-02-02 2011-10-14 16:38:47 EDT
100537 215000   SCHMULKA BERSTEIN & CO INC 1100 UTICA AVE New York -Richmond NY 11203   0   S 2013 0 H C   A X                   0   15 1984-01-31   1984-01-31 1984-01-31 2011-10-14 16:38:47 EDT
100545 215000   CONSOLIDATED EDISON 4 IRVING PLACE New York -Richmond NY 14003   0   H 4911 0 B B   A                     0   5000 1984-02-02   1984-02-02 1984-02-03 2011-10-14 16:38:47 EDT
100552 215000   PFIZER INC 630 FLUSHING AVE New York -Richmond NY 11206   0   S 2830 0 B B   B                     0   1000 1984-01-31   1984-01-31 1984-02-01 2011-10-14 16:38:47 EDT
100560 215000   FRANKLIN BODY & EQUIPMENT CORP 1042 DEAN ST New York -Richmond NY 11238   0   H 3713 0 H A   A       X             0   25 1984-01-27   1984-02-01 1984-02-17 2011-10-14 16:38:47 EDT
100578 215000   FIELDSTON CLOTHES INC 225 W37 ST New York -Richmond NY 10018   0   H 2385 0 H A   A       X             0   25 1984-01-27   1984-01-27 1984-11-02 2011-10-14 16:38:47 EDT
100586 215000   DELTA METAL PRODUCTS CO 476 FLUSHING AVE New York -Richmond NY 11205   0   S 3644 0 H A   A X                   0   52 1984-02-01   1984-02-02 1984-04-04 2011-10-14 16:38:47 EDT
100594 215000   UNITED PAINTING CORP 600 1ST AVE New York -Richmond NY 10016   0   H 1795 0 H B   A         X           0   70 1984-01-30   1984-03-07 1984-03-19 2011-10-14 16:38:47 EDT
100602 215000   AARON H DUBIN INC 488 BROADWAY New York -Richmond NY 11211   0   S 2013 0 H C   A X                   0   30 1984-02-01   1984-02-01 1984-02-05 2011-10-14 16:38:47 EDT
100610 215000   COASTAL DRY DOCK & REPAIR CORP USS BEARY DRY DOCK 4 New York -Richmond NY 11205   0   H 3731 0 B B   A                     0   1000 1984-02-02   1984-02-23 1984-02-24 2011-10-14 16:38:47 EDT
100628 215000   REVERE SUGAR CORP 280 RICHARDS ST New York -Richmond NY 11231   0   S 4491 0 H A   A     X               0   340 1984-02-02   1984-02-02 1984-03-01 2011-10-14 16:38:47 EDT
100636 215000   M J RUDOLPH CORP 280 RICHARDS ST New York -Richmond NY 11231   0   S 4491 0 H A   A     X               0   35 1984-02-02   1984-02-02 1984-02-28 2011-10-14 16:38:47 EDT
100644 215000   DE CON MECHANICAL CORP 5TH AVE BUS DEPOT & 38TH ST New York -Richmond NY 11220   0   S 1711 0 H A   A   X                 0   20 1984-02-02   1984-02-06 1984-06-26 2011-10-14 16:38:47 EDT
100651 215000   LAQUILA CONSTRUCTION 5TH AVE BUS DEPOT & 38TH ST New York -Richmond NY 11220   0   S 1542 0 H A   A   X                 0   29 1984-02-02   1984-02-06 1984-06-26 2011-10-14 16:38:47 EDT
100669 215000   L & L MASONS INC 5TH AVE BUS DEPOT & 38TH ST New York -Richmond NY 11220   0   S 1741 0 H A   A   X                 0   19 1984-02-02   1984-02-06 1984-03-13 2011-10-14 16:38:47 EDT
100677 215000   SHELDON ELECTRIC CO INC 5TH AVE BUS DEPOT & 38TH ST New York -Richmond NY 11220   0   S 1731 0 H A   A   X                 0   7 1984-02-02   1984-02-06 1984-02-13 2011-10-14 16:38:47 EDT
100685 215000   CORBETT STEVEDORING CO INC 280 RICHARDS ST New York -Richmond NY 11231   0   S 4491 0 H A   A     X               0   40 1984-02-02   1984-02-02 1984-04-04 2011-10-14 16:38:47 EDT
100693 215000   E C I BUILDING CORP 320 E 40TH ST New York -Richmond NY 10016   0   S 1629 0 H A   A   X                 0   50 1984-02-06   1984-02-08 1984-02-08 2011-10-14 16:38:47 EDT
100701 215000   KANO CONSTRUCTION CORP 95 MADISON AVE New York -Richmond NY 10016   0   S 1721 0 H A   B   X                 0   20 1984-02-06   1984-02-08 1984-02-21 2011-10-14 16:38:47 EDT
100719 215000   NEW YORK AMBULANCE SERVICE CO 55 AUDUBON AVENUE New York -Richmond NY 10033   0   S 4119 0 B B   A                     0   20 1984-02-06   1984-02-10 1984-03-01 2011-10-14 16:38:47 EDT
100727 215000   A & G SHIP MAINTENANCE CORP RED HOOK TERMINAL New York -Richmond NY 11231   0   S 4491 0 H A   A     X               0   9 1984-02-08   1984-02-09 1984-03-02 2011-10-14 16:38:47 EDT
100735 215000   GRATA CONSTRUCTION CORP 320 E 40TH ST New York -Richmond NY 10016   0   S 1771 0 H A   A   X                 0   20 1984-02-08   1984-02-08 1984-05-22 2011-10-14 16:38:47 EDT
100743 215000   KENSICO CONSTRUCTION CO INC WEST 163RD ST & FT WASH AVE New York -Richmond NY 10032   0   S 1522 0 H A   A   X                 0   8 1984-02-06   1984-03-01 1984-04-10 2011-10-14 16:38:47 EDT
100750 215000   BLUEPRINT PLUMBING CORP WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1711 0 H A   A   X                 0   5 1984-02-06   1984-03-01 1984-06-25 2011-10-14 16:38:47 EDT
100768 215000   SILHOUTTE DRYWALL SYSTEMS INC WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1742 0 H A   A   X                 0   15 1984-02-06   1984-03-01 1984-05-22 2011-10-14 16:38:47 EDT
100776 215000   CROCETTI TILE INC WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1743 0 H A   A   X                 0   3 1984-02-06   1984-03-01 1984-03-16 2011-10-14 16:38:47 EDT
100784 215000   CITY WINDOW ERECTORS INC WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1751 0 H A   A   X                 0   4 1984-02-06   1984-03-01 1984-09-19 2011-10-14 16:38:47 EDT
100792 215000   MAJESTIC DRYWALL INC WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1742 0 H A   A   X                 0   1 1984-02-06   1984-03-01 1984-09-28 2011-10-14 16:38:47 EDT
100800 215000   REMARK ELECTRIC CO INC WEST 163RD ST & FT WASH AVE New York -Richmond NY 10032   0   S 1731 0 H A   A   X                 0   7 1984-02-06   1984-03-01 1984-04-09 2011-10-14 16:38:47 EDT
100818 215000   UTOPIA PIPING CORP WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1711 0 H A   A   X                 0   8 1984-02-06   1984-03-01 1986-08-20 2011-10-14 16:38:47 EDT
100826 215000   SALISA PAINTING INC WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1721 0 H A   A   X                 0   2 1984-02-06   1984-03-01 1984-04-09 2011-10-14 16:38:47 EDT
100834 215000   ROSEN PLASTERING CORP WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1741 0 H A   A   X                 0   5 1984-02-06   1984-03-01 1984-04-09 2011-10-14 16:38:47 EDT
100842 215000   ROMAN GENERAL CONTRS INC WEST 163RD ST & FT WASH AVE New York -Richmond NY 10032   0   S 1771 0 H A   A   X                 0   4 1984-02-06   1984-03-01 1984-04-10 2011-10-14 16:38:47 EDT
100859 215000   R W DANDORPH INSULATION CORP WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1799 0 H A   A   X                 0   3 1984-02-06   1984-03-01 1984-04-09 2011-10-14 16:38:47 EDT
100867 215000   EASTERN METAL WORKS INC WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1711 0 H A   A   X                 0   3 1984-02-06   1984-03-01 1984-03-02 2011-10-14 16:38:47 EDT
100875 215000   SERGE ELEVATOR CO INC WEST 163RD ST & FORT WASH AVE New York -Richmond NY 10032   0   S 1796 0 H A   A   X                 0   2 1984-02-06   1984-03-01 1984-03-02 2011-10-14 16:38:47 EDT
100883 215000   S & A STRUCTURE INC 101 W 79 ST & COLUMBUS AVE New York -Richmond NY 10024   0   S 1771 0 H A   A   X                 0   88 1984-02-09   1984-02-14 1984-07-17 2011-10-14 16:38:47 EDT
100891 215000   A F G O ENGINEERING CORP 101 W 79 ST & COLUMBUS AVE New York -Richmond NY 10024   0   S 1711 0 H A   A   X                 0   8 1984-02-09   1984-02-14 1984-03-01 2011-10-14 16:38:47 EDT
100925 215000   OTIS ELEVATOR CO 101 W 79 ST & COLUMBUS AVE New York -Richmond NY 10024   0   S 1796 0 H A   A   X                 0   3 1984-02-09   1984-02-14 1984-02-17 2011-10-14 16:38:47 EDT
100933 215000   L S R ELECTRICAL CO 101 W 79 ST & COLUMBUS AVE New York -Richmond NY 10024   0   S 1731 0 H A   A   X                 0   18 1984-02-09   1984-02-14 1984-03-01 2011-10-14 16:38:47 EDT
100941 215000   S A F LASALA CORP 101 W 79 ST & COLUMBUS AVE New York -Richmond NY 10024   0   S 1741 0 H A   A   X                 0   6 1984-02-09   1984-02-14 1984-04-04 2011-10-14 16:38:47 EDT
100958 215000   CIRCLE INDUSTRIES 101 W 79 ST & COLUMBUS AVE New York -Richmond NY 10024   0   S 1742 0 H A   A   X                 0   6 1984-02-09   1984-02-14 1984-03-01 2011-10-14 16:38:47 EDT
100966 215000   FALCO CONSTRUCTION CORP 5100 FIRST AVENUE New York -Richmond NY 11232   0   S 1542 0 H A   B   X                 0   2 1984-02-08   1984-02-13 1984-06-26 2011-10-14 16:38:47 EDT
100974 215000   UNIVERSAL STEEL ERECTORS INC 5100 FIRST AVENUE New York -Richmond NY 11232   0   S 1791 0 H A   A   X                 0   2 1984-02-08   1984-02-08 1984-02-15 2011-10-14 16:38:47 EDT
100982 215000   REMARK ELECTRIC CORP 5100 FIRST AVENUE New York -Richmond NY 11232   0   S 1731 0 H A   A   X                 0   7 1984-02-08   1984-02-13 1984-04-09 2011-10-14 16:38:47 EDT
100990 215000   MEDCO PLUMBING INC 5100 FIRST AVENUE New York -Richmond NY 11232   0   S 1711 0 H A   A   X                 0   4 1984-02-08   1984-02-13 1984-04-09 2011-10-14 16:38:47 EDT
101006 215000   BIRK IRONWORKS INC 5100 FIRST AVENUE New York -Richmond NY 11232   0   S 1791 0 H A   A   X                 0   4 1984-02-09   1984-02-13 1984-02-15 2011-10-14 16:38:47 EDT
101014 215000   ANGELO CAPOBIANCO INC 5100 FIRST AVENUE New York -Richmond NY 11232   0   S 1741 0 H A   A   X                 0   7 1984-02-09   1984-02-13 1984-04-04 2011-10-14 16:38:47 EDT
101022 215000   COTY ENTERPRISES LTD 600 RICHMOND TERRACE New York -Richmond NY 10301   0   H 4225 0 H B   A                     0   116 1984-02-07   1984-02-13 1984-02-27 2011-10-14 16:38:47 EDT
101030 215000   MAIMONIDES MEDICAL CENTER 4802 TENTH AVENUE New York -Richmond NY 11219   0   H 8062 0 B A   A                     0   3100 1984-02-07   1984-03-02 1984-03-02 2011-10-14 16:38:47 EDT
101048 215000   HERITAGE SHEET METAL FABRIC 101 W 79 ST & COLUMBUS AVE New York -Richmond NY 10024   0   S 1711 0 H A   A   X                 0   4 1984-02-10   1984-02-14 1984-02-17 2011-10-14 16:38:47 EDT
101063 215000   KENSTON WAREHOUSE FOOT OF 50 STREET & 1ST AVE New York -Richmond NY 11232   0   H 4225 0 H A   A                     0   9 1984-02-08   1984-02-08 1984-02-10 2011-10-14 16:38:47 EDT
101071 215000   GALBREATH-RUFFI 85 BROAD ST New York -Richmond NY 10004   0   S 7349 0 B B   A                     0   140 1984-02-21   1984-02-21 1984-02-22 2011-10-14 16:38:47 EDT
101089 215000   GEORGES RESTAURANT 18 WEST 33RD ST New York -Richmond NY 10001   0   S 5812 0 B B   A                     0   16 1984-02-17   1984-02-17 1984-02-21 2011-10-14 16:38:47 EDT
101097 215000   B & S WOODWORKING CO INC 42 W 44 ST New York -Richmond NY 10036   0   S 1751 0 H A   A   X                 0   2 1984-02-14   1984-02-15 1984-02-17 2011-10-14 16:38:47 EDT
101105 215000   HERBERT CONSTRUCTION CO INC 42 W 44 ST New York -Richmond NY 10036   0   S 1542 0 H A   A   X                 0   4 1984-02-14   1984-02-15 1984-02-17 2011-10-14 16:38:47 EDT
101113 215000   LONDON ELECTRIC INC 42 W 44 ST New York -Richmond NY 10036   0   S 1731 0 H A   A   X                 0   16 1984-02-14   1984-02-15 1984-02-21 2011-10-14 16:38:47 EDT
101121 215000   COMPTROLLER OF CURRENCY 1211 AVE AMERICAS SUITE 4250 New York -Richmond NY 10036   0   H 3356 0 H A   B       X             0   57 1984-02-13   1984-03-16 1984-03-16 2011-10-14 16:38:47 EDT
101139 215000   R B SAMUELS CO 1211 AVE AMERICAS New York -Richmond NY 10036   0   H 1731 0 H A   A         X           0   100 1984-02-14   1984-03-16 1984-06-25 2011-10-14 16:38:47 EDT
101147 215000   INTERSTATE MAINTENANCE INC 39TH ST TERMINAL New York -Richmond NY 11232   0   S 4491 0 H A   A     X               0   35 1984-02-16   1984-02-17 1984-03-16 2011-10-14 16:38:47 EDT
101162 215000   INTL TERMINAL OPERATING CO INC FOOT OF 39TH STREET New York -Richmond NY 11232   0   S 4491 0 H A   A     X               0   390 1984-02-14   1984-02-17 1984-07-11 2011-10-14 16:38:47 EDT
101170 215000   INTL MARINE WORKS INC FOOT OF 39TH ST TERMINAL New York -Richmond NY 11232   0   S 3731 0 H A   B                     0   15 1984-02-14   1984-02-17 1984-04-09 2011-10-14 16:38:47 EDT
101196 215000   JOYCE BEVERAGES BROOKLYN NAVY YARD BLDG 230 New York -Richmond NY 11205   0   S 2086 0 H A   A X                   0   60 1984-02-21   1984-02-21 1984-05-14 2011-10-14 16:38:47 EDT
101204 215000   GOLD RUSH MFG LTD 844 EAST 94 STREET New York -Richmond NY 11236   0   H 3341 0 H A   B       X             0   15 1984-02-16     1984-02-24 2011-10-14 16:38:47 EDT

Next page

CREATE TABLE "inspection" (
   [activity_nr] INTEGER PRIMARY KEY,
   [reporting_id] INTEGER,
   [state_flag] INTEGER,
   [estab_name] TEXT,
   [site_address] TEXT,
   [site_city] TEXT,
   [site_state] TEXT,
   [site_zip] INTEGER,
   [owner_type] TEXT,
   [owner_code] INTEGER,
   [adv_notice] TEXT,
   [safety_hlth] TEXT,
   [sic_code] INTEGER,
   [naics_code] INTEGER,
   [insp_type] TEXT,
   [insp_scope] TEXT,
   [why_no_insp] TEXT,
   [union_status] TEXT,
   [safety_manuf] TEXT,
   [safety_const] TEXT,
   [safety_marit] TEXT,
   [health_manuf] TEXT,
   [health_const] TEXT,
   [health_marit] TEXT,
   [migrant] TEXT,
   [mail_street] TEXT,
   [mail_city] TEXT,
   [mail_state] TEXT,
   [mail_zip] INTEGER,
   [host_est_key] TEXT,
   [nr_in_estab] INTEGER,
   [open_date] TEXT,
   [case_mod_date] TEXT,
   [close_conf_date] TEXT,
   [close_case_date] TEXT,
   [ld_dt] TEXT
);