Count the number of inspections per each risk category.
Categorize records with null values under the 'No Risk' category.
Sort the result based on the number of inspections in descending order.
table name:sf_restaurant_health_violations
Solution:
select coalesce(risk_category,'No Risk') category,
count(distinct inspection_id) as noOfIns
from sf_restaurant_health_violations
group by risk_category
order by noOfIns desc
Output:
SQL Script:
USE [StrataScratch]
GO
CREATE TABLE [dbo].[sf_restaurant_health_violations](
[business_id] [int] NOT NULL,
[business_name] [varchar](500) NULL,
[business_address] [varchar](500) NULL,
[business_city] [varchar](500) NULL,
[business_state] [varchar](500) NULL,
[business_postal_code] [decimal](18, 10) NULL,
[business_latitude] [decimal](18, 10) NULL,
[business_longitude] [decimal](18, 10) NULL,
[business_location] [varchar](500) NULL,
[business_phone_number] [decimal](18, 10) NULL,
[inspection_id] [varchar](500) NULL,
[inspection_date] [datetime] NULL,
[inspection_score] [decimal](18, 10) NULL,
[inspection_type] [varchar](500) NULL,
[violation_id] [varchar](500) NULL,
[violation_description] [varchar](500) NULL,
[risk_category] [varchar](500) NULL,
CONSTRAINT [PK_sf_restaurant_health_violations] PRIMARY KEY CLUSTERED
(
[business_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (61, N'Chowders', N'Pier 39 Space A3', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4100000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.410189'', ''needs_recoding'': False, ''latitude'': ''37.80824'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'61_20160708', CAST(N'2016-07-08T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'61_20160708_103150', N'Improper or defective plumbing', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (88, N'J.B.''S PLACE', N'1435 17th St', N'San Francisco', N'CA', CAST(94107.0000000000 AS Decimal(18, 10)), CAST(37.7650000000 AS Decimal(18, 10)), CAST(-122.3980000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.398084'', ''needs_recoding'': False, ''latitude'': ''37.765003'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'88_20171016', CAST(N'2017-10-16T00:00:00.000' AS DateTime), CAST(82.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'88_20171016_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (247, N'Toy Boat Dessert Cafe', N'401 Clement St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), CAST(37.7830000000 AS Decimal(18, 10)), CAST(-122.4640000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.46351'', ''needs_recoding'': False, ''latitude'': ''37.782953'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'247_20161114', CAST(N'2016-11-14T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'247_20161114_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (500, N'Roxanne Cafe', N'570 Powell St', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7900000000 AS Decimal(18, 10)), CAST(-122.4090000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.408688'', ''needs_recoding'': False, ''latitude'': ''37.790003''}', NULL, N'500_20150930', CAST(N'2015-09-30T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'500_20150930_103145', N'Improper storage of equipment utensils or linens', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (509, N'Cafe Bakery', N'1365 Noriega St', N'San Francisco', N'CA', CAST(94122.0000000000 AS Decimal(18, 10)), CAST(37.7540000000 AS Decimal(18, 10)), CAST(-122.4780000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.478248'', ''needs_recoding'': False, ''latitude'': ''37.75409'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'509_20160328', CAST(N'2016-03-28T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (606, N'TSING TAO RESTAURANT', N'3107 CLEMENT St', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), CAST(37.7820000000 AS Decimal(18, 10)), CAST(-122.4930000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.492609'', ''needs_recoding'': False, ''latitude'': ''37.781624'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'606_20170720', CAST(N'2017-07-20T00:00:00.000' AS DateTime), CAST(78.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'606_20170720_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (935, N'PEKING WOK RESTAURANT', N'4920 03rd St', N'San Francisco', N'CA', CAST(94124.0000000000 AS Decimal(18, 10)), CAST(37.7340000000 AS Decimal(18, 10)), CAST(-122.3910000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.391183'', ''needs_recoding'': False, ''latitude'': ''37.733891'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'935_20150928', CAST(N'2015-09-28T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'935_20150928_103133', N'Foods not protected from contamination', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (950, N'IRVING PIZZA', N'1825 IRVING St', N'San Francisco', N'CA', CAST(94122.0000000000 AS Decimal(18, 10)), CAST(37.7640000000 AS Decimal(18, 10)), CAST(-122.4780000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.47764'', ''needs_recoding'': False, ''latitude'': ''37.763513'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'950_20160531', CAST(N'2016-05-31T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'950_20160531_103121', N'Inadequate procedures or records for time as a public health control', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1031, N'IL BORGO', N'500 FELL St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), CAST(37.7760000000 AS Decimal(18, 10)), CAST(-122.4260000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.426264'', ''needs_recoding'': False, ''latitude'': ''37.775538'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1031_20180328', CAST(N'2018-03-28T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1031_20180328_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1199, N'PANCHO''S', N'3440 GEARY Blvd', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), CAST(37.7820000000 AS Decimal(18, 10)), CAST(-122.4560000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.456176'', ''needs_recoding'': False, ''latitude'': ''37.781507'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1199_20180117', CAST(N'2018-01-17T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1199_20180117_103129', N'Insufficient hot water or running water', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1203, N'TAWAN''S THAI FOOD', N'4403 GEARY Blvd', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), CAST(37.7810000000 AS Decimal(18, 10)), CAST(-122.4670000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.46659'', ''needs_recoding'': False, ''latitude'': ''37.780834'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1203_20180802', CAST(N'2018-08-02T00:00:00.000' AS DateTime), CAST(77.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1203_20180802_103132', N'Improper thawing methods', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1204, N'ROYAL GROUND COFFEE', N'5301 GEARY Blvd', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), CAST(37.7800000000 AS Decimal(18, 10)), CAST(-122.4760000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.47641'', ''needs_recoding'': False, ''latitude'': ''37.780394'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1204_20171222', CAST(N'2017-12-22T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1398, N'YUMMA''S MED GRILL', N'721 IRVING St', N'San Francisco', N'CA', CAST(94122.0000000000 AS Decimal(18, 10)), CAST(37.7640000000 AS Decimal(18, 10)), CAST(-122.4660000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.465539'', ''needs_recoding'': False, ''latitude'': ''37.764053'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1398_20160609', CAST(N'2016-06-09T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1398_20160609_103116', N'Inadequate food safety knowledge or lack of certified food safety manager', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1598, N'Cafe Bean', N'800 Sutter St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7890000000 AS Decimal(18, 10)), CAST(-122.4140000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.413795'', ''needs_recoding'': False, ''latitude'': ''37.788587'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1598_20170417', CAST(N'2017-04-17T00:00:00.000' AS DateTime), CAST(80.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1598_20170417_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1615, N'Starbucks Coffee', N'27 Drumm St', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), CAST(37.7940000000 AS Decimal(18, 10)), CAST(-122.3970000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.396524'', ''needs_recoding'': False, ''latitude'': ''37.794184'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1615_20160504', CAST(N'2016-05-04T00:00:00.000' AS DateTime), CAST(98.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1615_20160504_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1617, N'CLEMENT BBQ RESTAURANT', N'617 CLEMENT St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), CAST(37.7830000000 AS Decimal(18, 10)), CAST(-122.4660000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.4659'', ''needs_recoding'': False, ''latitude'': ''37.782843'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1617_20180522', CAST(N'2018-05-22T00:00:00.000' AS DateTime), CAST(71.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1617_20180522_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1867, N'Escape From New York Pizza', N'333 Bush St #103', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), CAST(37.7910000000 AS Decimal(18, 10)), CAST(-122.4030000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.403168'', ''needs_recoding'': False, ''latitude'': ''37.790844'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1867_20160412', CAST(N'2016-04-12T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1867_20160412_103162', N'Other low risk violation', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1939, N'STARBUCKS COFFEE CO. #603', N'74 NEW MONTGOMERY St', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), CAST(37.7880000000 AS Decimal(18, 10)), CAST(-122.4010000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.400998'', ''needs_recoding'': False, ''latitude'': ''37.787838'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1939_20161214', CAST(N'2016-12-14T00:00:00.000' AS DateTime), CAST(98.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1939_20161214_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1970, N'MICADO RESTAURANT', N'2126 IRVING St', N'San Francisco', N'CA', CAST(94122.0000000000 AS Decimal(18, 10)), CAST(37.7630000000 AS Decimal(18, 10)), CAST(-122.4810000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.480646'', ''needs_recoding'': False, ''latitude'': ''37.763468'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1970_20171121', CAST(N'2017-11-21T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1970_20171121_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (1991, N'SRI THAI CUISINE', N'4621 LINCOLN Way', N'San Francisco', N'CA', CAST(94122.0000000000 AS Decimal(18, 10)), CAST(37.7640000000 AS Decimal(18, 10)), CAST(-122.5080000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.507779'', ''needs_recoding'': False, ''latitude'': ''37.764073'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'1991_20171129', CAST(N'2017-11-29T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'1991_20171129_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2110, N'A La Turca', N'869 Geary St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7860000000 AS Decimal(18, 10)), CAST(-122.4180000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.417617'', ''needs_recoding'': False, ''latitude'': ''37.786143'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2110_20170905', CAST(N'2017-09-05T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2216, N'Hong Kong Clay Pot City Restaurant', N'960 Grant Ave', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7960000000 AS Decimal(18, 10)), CAST(-122.4070000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.406557'', ''needs_recoding'': False, ''latitude'': ''37.795868'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2216_20170103', CAST(N'2017-01-03T00:00:00.000' AS DateTime), CAST(77.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2216_20170103_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2218, N'Starbucks Coffee Co', N'99 Jackson St', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), CAST(37.7970000000 AS Decimal(18, 10)), CAST(-122.3980000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.398284'', ''needs_recoding'': False, ''latitude'': ''37.79703'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2218_20170503', CAST(N'2017-05-03T00:00:00.000' AS DateTime), CAST(91.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2218_20170503_103143', N'Inadequate warewashing facilities or equipment', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2233, N'The AA Bakery & Cafe', N'1068 Stockton St', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7960000000 AS Decimal(18, 10)), CAST(-122.4080000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.40809'', ''needs_recoding'': False, ''latitude'': ''37.795564'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2233_20160524', CAST(N'2016-05-24T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2233_20160524_103102', N'Unclean hands or improper use of gloves', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2249, N'Ramzi''s Cafe', N'0044 Montgomery St LL1', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), CAST(37.7900000000 AS Decimal(18, 10)), CAST(-122.4020000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.401999'', ''needs_recoding'': False, ''latitude'': ''37.789552'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2249_20171204', CAST(N'2017-12-04T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2249_20171204_103138', N'Improper storage use or identification of toxic substances', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2280, N'SAKANA BUNE RESTAURANT', N'5701 GEARY Blvd', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), CAST(37.7800000000 AS Decimal(18, 10)), CAST(-122.4810000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.480599'', ''needs_recoding'': False, ''latitude'': ''37.780204'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2280_20180222', CAST(N'2018-02-22T00:00:00.000' AS DateTime), CAST(83.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2280_20180222_103109', N'Unclean or unsanitary food contact surfaces', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2418, N'MANIVANH THAI RESTAURANT', N'2732 24th St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), CAST(37.7530000000 AS Decimal(18, 10)), CAST(-122.4070000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.407062'', ''needs_recoding'': False, ''latitude'': ''37.752968'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2418_20170328', CAST(N'2017-03-28T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2418_20170328_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2622, N'WING HING RESTAURANT', N'2550 SAN BRUNO Ave', N'San Francisco', N'CA', CAST(94134.0000000000 AS Decimal(18, 10)), CAST(37.7290000000 AS Decimal(18, 10)), CAST(-122.4040000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.404391'', ''needs_recoding'': False, ''latitude'': ''37.729408'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2622_20171106', CAST(N'2017-11-06T00:00:00.000' AS DateTime), CAST(70.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2622_20171106_103109', N'Unclean or unsanitary food contact surfaces', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2721, N'Red Jade Restaurant', N'245 Church St.', N'San Francisco', N'CA', CAST(94114.0000000000 AS Decimal(18, 10)), CAST(37.7670000000 AS Decimal(18, 10)), CAST(-122.4290000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.428846'', ''needs_recoding'': False, ''latitude'': ''37.766814'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2721_20170816', CAST(N'2017-08-16T00:00:00.000' AS DateTime), CAST(80.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2721_20170816_103103', N'High risk food holding temperature', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2798, N'MONGKOK DIM SUM & RESTAURANT', N'2438 NORIEGA St', N'San Francisco', N'CA', CAST(94122.0000000000 AS Decimal(18, 10)), CAST(37.7540000000 AS Decimal(18, 10)), CAST(-122.4900000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.489972'', ''needs_recoding'': False, ''latitude'': ''37.753678'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2798_20160524', CAST(N'2016-05-24T00:00:00.000' AS DateTime), CAST(83.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2798_20160524_103105', N'Improper cooling methods', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (2933, N'Castagnola''s Restaurant', N'286 Jefferson St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4170000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.417194'', ''needs_recoding'': False, ''latitude'': ''37.808098'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'2933_20170807', CAST(N'2017-08-07T00:00:00.000' AS DateTime), CAST(83.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'2933_20170807_103107', N'Improper reheating of food', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (3084, N'ITALIAN AMERICAN SOCIAL CLUB', N'25 RUSSIA Ave', N'San Francisco', N'CA', CAST(94112.0000000000 AS Decimal(18, 10)), CAST(37.7210000000 AS Decimal(18, 10)), CAST(-122.4370000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.436628'', ''needs_recoding'': False, ''latitude'': ''37.721347'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'3084_20160907', CAST(N'2016-09-07T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'3084_20160907_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (3285, N'Wing Lum Cafe', N'1150 Polk St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7870000000 AS Decimal(18, 10)), CAST(-122.4200000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.419952'', ''needs_recoding'': False, ''latitude'': ''37.787438'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'3285_20171025', CAST(N'2017-10-25T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (3529, N'Great Eastern Restaurant', N'649 Jackson St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.7960000000 AS Decimal(18, 10)), CAST(-122.4060000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.405918'', ''needs_recoding'': False, ''latitude'': ''37.796093'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'3529_20171213', CAST(N'2017-12-13T00:00:00.000' AS DateTime), CAST(83.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'3529_20171213_103149', N'Wiping cloths not clean or properly stored or inadequate sanitizer', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (3642, N'ABSINTHE PASTRY', N'201 IVY St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), CAST(37.7770000000 AS Decimal(18, 10)), CAST(-122.4210000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.421458'', ''needs_recoding'': False, ''latitude'': ''37.777492'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'3642_20170510', CAST(N'2017-05-10T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'3642_20170510_103142', N'Unclean nonfood contact surfaces', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (3676, N'Chinatown Restaurant', N'744 Washington St', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7950000000 AS Decimal(18, 10)), CAST(-122.4060000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.405943'', ''needs_recoding'': False, ''latitude'': ''37.795248'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'3676_20160107', CAST(N'2016-01-07T00:00:00.000' AS DateTime), CAST(76.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'3676_20160107_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (3816, N'Washington Bakery & Restaurant', N'733 Washington St', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7950000000 AS Decimal(18, 10)), CAST(-122.4060000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.405845'', ''needs_recoding'': False, ''latitude'': ''37.795174'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'3816_20160728', CAST(N'2016-07-28T00:00:00.000' AS DateTime), CAST(67.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'3816_20160728_103108', N'Contaminated or adulterated food', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (4421, N'Crepe Cafe', N'Pier 39 Space D-3', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4100000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.410189'', ''needs_recoding'': False, ''latitude'': ''37.80824'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'4421_20180326', CAST(N'2018-03-26T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'4421_20180326_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (4654, N'House of Bagels', N'5030 Geary Blvd', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), CAST(37.7810000000 AS Decimal(18, 10)), CAST(-122.4730000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.473471'', ''needs_recoding'': False, ''latitude'': ''37.780688'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'4654_20170503', CAST(N'2017-05-03T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (4986, N'SENIORE''S PIZZA', N'2415 19th Ave', N'San Francisco', N'CA', CAST(94116.0000000000 AS Decimal(18, 10)), CAST(37.7430000000 AS Decimal(18, 10)), CAST(-122.4760000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.475714'', ''needs_recoding'': False, ''latitude'': ''37.742728'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'4986_20160324', CAST(N'2016-03-24T00:00:00.000' AS DateTime), NULL, N'Structural Inspection', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5039, N'PRESIDIO THEATRE', N'2340 CHESTNUT St', N'San Francisco', N'CA', CAST(94123.0000000000 AS Decimal(18, 10)), CAST(37.8000000000 AS Decimal(18, 10)), CAST(-122.4420000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.441914'', ''needs_recoding'': False, ''latitude'': ''37.800128'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5039_20170314', CAST(N'2017-03-14T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'5039_20170314_103138', N'Improper storage use or identification of toxic substances', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5104, N'In-N-Out Burger', N'333 Jefferson St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4180000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.417887'', ''needs_recoding'': False, ''latitude'': ''37.807923'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5104_20160630', CAST(N'2016-06-30T00:00:00.000' AS DateTime), CAST(98.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'5104_20160630_103156', N'Permit license or inspection report not posted', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5124, N'PIZZA HUT #758280', N'728 GEARY St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7860000000 AS Decimal(18, 10)), CAST(-122.4150000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.415454'', ''needs_recoding'': False, ''latitude'': ''37.786477'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5124_20161227', CAST(N'2016-12-27T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'5124_20161227_103156', N'Permit license or inspection report not posted', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5523, N'AT&T Park - Coffee and Ice Cream (5A+5B)', N'24 WILLIE MAYS PLAZA', N'San Francisco', N'CA', CAST(94107.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'5523_20160814', CAST(N'2016-08-14T00:00:00.000' AS DateTime), NULL, N'Non-inspection site visit', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5606, N'CALIFORNIA PACIFIC MEDICAL CENTER', N'45 Castro St', N'San Francisco', N'CA', CAST(94114.0000000000 AS Decimal(18, 10)), CAST(37.7690000000 AS Decimal(18, 10)), CAST(-122.4360000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.435736'', ''needs_recoding'': False, ''latitude'': ''37.768922'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5606_20170707', CAST(N'2017-07-07T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'5606_20170707_103150', N'Improper or defective plumbing', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5654, N'S. F. Gourmet Hot Dog Cart', N'Pier 39', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4100000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.410189'', ''needs_recoding'': False, ''latitude'': ''37.80824'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5654_20161031', CAST(N'2016-10-31T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'5654_20161031_103130', N'Inadequate sewage or wastewater disposal', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5800, N'John Chin Elementary School', N'350 Broadway St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.7980000000 AS Decimal(18, 10)), CAST(-122.4030000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.403154'', ''needs_recoding'': False, ''latitude'': ''37.798358'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5800_20171017', CAST(N'2017-10-17T00:00:00.000' AS DateTime), CAST(98.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'5800_20171017_103149', N'Wiping cloths not clean or properly stored or inadequate sanitizer', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5862, N'MARTIN L. KING MIDDLE SCHOOL', N'350 GIRARD St', N'San Francisco', N'CA', CAST(94134.0000000000 AS Decimal(18, 10)), CAST(37.7280000000 AS Decimal(18, 10)), CAST(-122.4050000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.404921'', ''needs_recoding'': False, ''latitude'': ''37.728088'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5862_20150923', CAST(N'2015-09-23T00:00:00.000' AS DateTime), CAST(100.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (5880, N'Francisco Middle School', N'2190 Powell St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8040000000 AS Decimal(18, 10)), CAST(-122.4120000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.411617'', ''needs_recoding'': False, ''latitude'': ''37.804368'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'5880_20180214', CAST(N'2018-02-14T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'5880_20180214_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (6643, N'T & L FOOD MARKET', N'405 EDDY St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7840000000 AS Decimal(18, 10)), CAST(-122.4140000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.414341'', ''needs_recoding'': False, ''latitude'': ''37.783661'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'6643_20160609', CAST(N'2016-06-09T00:00:00.000' AS DateTime), CAST(69.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'6643_20160609_103102', N'Unclean hands or improper use of gloves', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (6718, N'General Nutrition #302', N'576 Market St', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), CAST(37.7890000000 AS Decimal(18, 10)), CAST(-122.4010000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.401309'', ''needs_recoding'': False, ''latitude'': ''37.789353'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'6718_20170620', CAST(N'2017-06-20T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'6718_20170620_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (7601, N'Old Blue', N'Pier 41', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4120000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.412'', ''needs_recoding'': False, ''latitude'': ''37.808494'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'7601_20160713', CAST(N'2016-07-13T00:00:00.000' AS DateTime), CAST(98.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'7601_20160713_103157', N'Food safety certificate or food handler card not available', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (7661, N'DONA TERE''S MARKET', N'2780 21st St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), CAST(37.7580000000 AS Decimal(18, 10)), CAST(-122.4100000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.410392'', ''needs_recoding'': False, ''latitude'': ''37.757578'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'7661_20171127', CAST(N'2017-11-27T00:00:00.000' AS DateTime), CAST(83.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'7661_20171127_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (7759, N'PASITA''S BAKERY', N'10 PERSIA Ave', N'San Francisco', N'CA', CAST(94112.0000000000 AS Decimal(18, 10)), CAST(37.7230000000 AS Decimal(18, 10)), CAST(-122.4360000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.435983'', ''needs_recoding'': False, ''latitude'': ''37.723086'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'7759_20160804', CAST(N'2016-08-04T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (8948, N'SEGAFREDO', N'33 Powell St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), CAST(37.7850000000 AS Decimal(18, 10)), CAST(-122.4080000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.407764'', ''needs_recoding'': False, ''latitude'': ''37.784858'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'8948_20180212', CAST(N'2018-02-12T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (10083, N'Morning Brew Cafe', N'401 Sansome St', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), CAST(37.7940000000 AS Decimal(18, 10)), CAST(-122.4010000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.401299'', ''needs_recoding'': False, ''latitude'': ''37.794024'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'10083_20160315', CAST(N'2016-03-15T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'10083_20160315_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (10238, N'King of Thai Noodle House', N'184 O''Farrell St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), CAST(37.7860000000 AS Decimal(18, 10)), CAST(-122.4080000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.407764'', ''needs_recoding'': False, ''latitude'': ''37.786498'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'10238_20180508', CAST(N'2018-05-08T00:00:00.000' AS DateTime), CAST(76.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'10238_20180508_103133', N'Foods not protected from contamination', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (18126, N'Tacos San Buena', N'768 Sansome St', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), CAST(37.7970000000 AS Decimal(18, 10)), CAST(-122.4020000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.401957'', ''needs_recoding'': False, ''latitude'': ''37.797327'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'18126_20170127', CAST(N'2017-01-27T00:00:00.000' AS DateTime), NULL, N'Structural Inspection', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (18616, N'Kate O''Brien''s', N'579 HOWARD St', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), CAST(37.7870000000 AS Decimal(18, 10)), CAST(-122.3980000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.397632'', ''needs_recoding'': False, ''latitude'': ''37.787248'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'18616_20170810', CAST(N'2017-08-10T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'18616_20170810_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (18952, N'Hilton Financial District- Restaurant Seven Fifty', N'750 Kearny St 1st Floor', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7950000000 AS Decimal(18, 10)), CAST(-122.4050000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.404876'', ''needs_recoding'': False, ''latitude'': ''37.795057'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'18952_20160610', CAST(N'2016-06-10T00:00:00.000' AS DateTime), CAST(100.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (19379, N'Andersen Bakery', N'50 Post St #1', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), CAST(37.7890000000 AS Decimal(18, 10)), CAST(-122.4030000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.402861'', ''needs_recoding'': False, ''latitude'': ''37.789064'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'19379_20171114', CAST(N'2017-11-14T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'19379_20171114_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (24572, N'S & T Hong Kong Seafood', N'2588 Noriega St', N'San Francisco', N'CA', CAST(94122.0000000000 AS Decimal(18, 10)), CAST(37.7540000000 AS Decimal(18, 10)), CAST(-122.4910000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.491313'', ''needs_recoding'': False, ''latitude'': ''37.753608'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'24572_20161130', CAST(N'2016-11-30T00:00:00.000' AS DateTime), CAST(87.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'24572_20161130_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (26340, N'VIP Coffee & Cake Shop', N'671 Broadway St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.7980000000 AS Decimal(18, 10)), CAST(-122.4080000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.408058'', ''needs_recoding'': False, ''latitude'': ''37.797704'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'26340_20180521', CAST(N'2018-05-21T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (27821, N'Duboce Park Cafe', N'2 Sanchez St', N'San Francisco', N'CA', CAST(94114.0000000000 AS Decimal(18, 10)), CAST(37.7690000000 AS Decimal(18, 10)), CAST(-122.4310000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.431407'', ''needs_recoding'': False, ''latitude'': ''37.769305'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'27821_20180720', CAST(N'2018-07-20T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (29246, N'Rico Pan Bakery', N'3717 Mission St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), CAST(37.7370000000 AS Decimal(18, 10)), CAST(-122.4240000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.424078'', ''needs_recoding'': False, ''latitude'': ''37.737021'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'29246_20160502', CAST(N'2016-05-02T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'29246_20160502_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (32556, N'Seal Rock Inn Restaurant', N'545 Point Lobos Ave', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), CAST(37.7800000000 AS Decimal(18, 10)), CAST(-122.5090000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.509128'', ''needs_recoding'': False, ''latitude'': ''37.779853'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'32556_20180620', CAST(N'2018-06-20T00:00:00.000' AS DateTime), CAST(77.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'32556_20180620_103133', N'Foods not protected from contamination', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (33442, N'Miller''s East Coast Deli', N'1725 Polk St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7930000000 AS Decimal(18, 10)), CAST(-122.4210000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.421164'', ''needs_recoding'': False, ''latitude'': ''37.792784'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'33442_20160216', CAST(N'2016-02-16T00:00:00.000' AS DateTime), CAST(75.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'33442_20160216_103145', N'Improper storage of equipment utensils or linens', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (33914, N'Subway 30303', N'3911 Alemany Bl.', N'San Francisco', N'CA', CAST(94132.0000000000 AS Decimal(18, 10)), CAST(37.7110000000 AS Decimal(18, 10)), CAST(-122.4680000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.46779'', ''needs_recoding'': False, ''latitude'': ''37.711185'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'33914_20160216', CAST(N'2016-02-16T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'33914_20160216_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (33916, N'Extreme Pizza', N'1062 Folsom St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), CAST(37.7770000000 AS Decimal(18, 10)), CAST(-122.4070000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.407108'', ''needs_recoding'': False, ''latitude'': ''37.777374'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'33916_20160823', CAST(N'2016-08-23T00:00:00.000' AS DateTime), CAST(80.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'33916_20160823_103153', N'Inadequate dressing rooms or improper storage of personal items', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (33940, N'The Good Life Grocery', N'1524 20th St', N'San Francisco', N'CA', CAST(94107.0000000000 AS Decimal(18, 10)), CAST(37.7600000000 AS Decimal(18, 10)), CAST(-122.3970000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.396813'', ''needs_recoding'': False, ''latitude'': ''37.760018'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'33940_20180130', CAST(N'2018-01-30T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'33940_20180130_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (34186, N'Angel Cafe and Deli', N'700 Geary St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7870000000 AS Decimal(18, 10)), CAST(-122.4150000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.415064'', ''needs_recoding'': False, ''latitude'': ''37.786528'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'34186_20170628', CAST(N'2017-06-28T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'34186_20170628_103150', N'Improper or defective plumbing', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (34676, N'Golden Kim Tar Restaurant', N'434 Larkin St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), CAST(37.7820000000 AS Decimal(18, 10)), CAST(-122.4170000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.417147'', ''needs_recoding'': False, ''latitude'': ''37.781786'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'34676_20171005', CAST(N'2017-10-05T00:00:00.000' AS DateTime), CAST(68.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'34676_20171005_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (34743, N'Rotee Express', N'180 HOWARD St', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), CAST(37.7910000000 AS Decimal(18, 10)), CAST(-122.3930000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.393159'', ''needs_recoding'': False, ''latitude'': ''37.790863'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'34743_20160826', CAST(N'2016-08-26T00:00:00.000' AS DateTime), CAST(71.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'34743_20160826_103103', N'High risk food holding temperature', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (35507, N'Marina Meats Inc.', N'2395 Chestnut St', N'San Francisco', N'CA', CAST(94123.0000000000 AS Decimal(18, 10)), CAST(37.8000000000 AS Decimal(18, 10)), CAST(-122.4430000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.442716'', ''needs_recoding'': False, ''latitude'': ''37.799944'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'35507_20160212', CAST(N'2016-02-12T00:00:00.000' AS DateTime), CAST(82.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'35507_20160212_103145', N'Improper storage of equipment utensils or linens', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (36020, N'Cadillac Market', N'499 Eddy St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7830000000 AS Decimal(18, 10)), CAST(-122.4160000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.415829'', ''needs_recoding'': False, ''latitude'': ''37.783464'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'36020_20180501', CAST(N'2018-05-01T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'36020_20180501_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (36473, N'Maggie Cafe', N'848 Grant Ave', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7950000000 AS Decimal(18, 10)), CAST(-122.4060000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.406356'', ''needs_recoding'': False, ''latitude'': ''37.794898'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'36473_20151202', CAST(N'2015-12-02T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'36473_20151202_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (36570, N'7-Eleven, Store 2366-21389F', N'2200 BAYSHORE Blvd', N'San Francisco', N'CA', CAST(94134.0000000000 AS Decimal(18, 10)), CAST(37.7120000000 AS Decimal(18, 10)), CAST(-122.4030000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.402934'', ''needs_recoding'': False, ''latitude'': ''37.712166'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'36570_20161217', CAST(N'2016-12-17T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'36570_20161217_103102', N'Unclean hands or improper use of gloves', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (36602, N'Cafe Insalata', N'209 Jackson St', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), CAST(37.7970000000 AS Decimal(18, 10)), CAST(-122.4000000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.399936'', ''needs_recoding'': False, ''latitude'': ''37.796854'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'36602_20170926', CAST(N'2017-09-26T00:00:00.000' AS DateTime), CAST(98.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'36602_20170926_103161', N'Low risk vermin infestation', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (36687, N'Jay''s Cheesesteak', N'3285 21st St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), CAST(37.7570000000 AS Decimal(18, 10)), CAST(-122.4210000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.420849'', ''needs_recoding'': False, ''latitude'': ''37.756893'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'36687_20170721', CAST(N'2017-07-21T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (36695, N'Golden Natural Foods', N'130 Church St', N'San Francisco', N'CA', CAST(94114.0000000000 AS Decimal(18, 10)), CAST(37.7690000000 AS Decimal(18, 10)), CAST(-122.4290000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.429127'', ''needs_recoding'': False, ''latitude'': ''37.768824'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'36695_20161104', CAST(N'2016-11-04T00:00:00.000' AS DateTime), CAST(98.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'36695_20161104_103150', N'Improper or defective plumbing', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (37151, N'Man Sung Company', N'1116 Grant Ave', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.7970000000 AS Decimal(18, 10)), CAST(-122.4070000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.406807'', ''needs_recoding'': False, ''latitude'': ''37.797129'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'37151_20160801', CAST(N'2016-08-01T00:00:00.000' AS DateTime), CAST(82.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'37151_20160801_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (37482, N'Bursa', N'60 West Portal Ave.', N'San Francisco', N'CA', CAST(94127.0000000000 AS Decimal(18, 10)), CAST(37.7400000000 AS Decimal(18, 10)), CAST(-122.4670000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.466569'', ''needs_recoding'': False, ''latitude'': ''37.740144'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'37482_20180222', CAST(N'2018-02-22T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'37482_20180222_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (38231, N'Wines of California Wine Bar', N'Pier 39 Space N-111', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4100000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.410189'', ''needs_recoding'': False, ''latitude'': ''37.80824'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'38231_20180328', CAST(N'2018-03-28T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'38231_20180328_103150', N'Improper or defective plumbing', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (38566, N'Tropisueño', N'75 Yerba Buena Ln', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), CAST(37.7860000000 AS Decimal(18, 10)), CAST(-122.4040000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.404189'', ''needs_recoding'': False, ''latitude'': ''37.785638'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'38566_20171025', CAST(N'2017-10-25T00:00:00.000' AS DateTime), NULL, N'Complaint', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (39119, N'Brothers Restaurant', N'4128 GEARY Blvd', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), CAST(37.7810000000 AS Decimal(18, 10)), CAST(-122.4640000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.463762'', ''needs_recoding'': False, ''latitude'': ''37.781148'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'39119_20160718', CAST(N'2016-07-18T00:00:00.000' AS DateTime), CAST(79.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'39119_20160718_103133', N'Foods not protected from contamination', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (39396, N'New Regent Cafe', N'638 Pacific Ave', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.7970000000 AS Decimal(18, 10)), CAST(-122.4060000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.406313'', ''needs_recoding'': False, ''latitude'': ''37.797008'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'39396_20171206', CAST(N'2017-12-06T00:00:00.000' AS DateTime), CAST(68.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'39396_20171206_103142', N'Unclean nonfood contact surfaces', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (57698, N'China Fun Express', N'211 Kearny St', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), CAST(37.7900000000 AS Decimal(18, 10)), CAST(-122.4040000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.403915'', ''needs_recoding'': False, ''latitude'': ''37.790055'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'57698_20160303', CAST(N'2016-03-03T00:00:00.000' AS DateTime), CAST(78.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'57698_20160303_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (57755, N'Events Management @ Legion of Honor', N'100 34th Ave', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), CAST(37.7860000000 AS Decimal(18, 10)), CAST(-122.5000000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.500155'', ''needs_recoding'': False, ''latitude'': ''37.785711'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'57755_20180425', CAST(N'2018-04-25T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'57755_20180425_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (58673, N'New Luen Sing Fish Market', N'1207 Stockton St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.7970000000 AS Decimal(18, 10)), CAST(-122.4090000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.408504'', ''needs_recoding'': False, ''latitude'': ''37.796973'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'58673_20171206', CAST(N'2017-12-06T00:00:00.000' AS DateTime), CAST(84.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'58673_20171206_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (60518, N'Ninki Sushi Bar & Restaurant', N'1439 TARAVAL St', N'San Francisco', N'CA', CAST(94116.0000000000 AS Decimal(18, 10)), CAST(37.7430000000 AS Decimal(18, 10)), CAST(-122.4820000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.481749'', ''needs_recoding'': False, ''latitude'': ''37.742743'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'60518_20170824', CAST(N'2017-08-24T00:00:00.000' AS DateTime), CAST(78.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'60518_20170824_103109', N'Unclean or unsanitary food contact surfaces', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (60548, N'Annie''s Hot Dogs & Pretzels', N'Golden Gate Park, JFK Dr.@Conservatory of Flowers', N'San Francisco', N'CA', NULL, CAST(37.7770000000 AS Decimal(18, 10)), CAST(-122.4200000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.419639'', ''needs_recoding'': False, ''latitude'': ''37.777122'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'60548_20180608', CAST(N'2018-06-08T00:00:00.000' AS DateTime), CAST(83.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'60548_20180608_103150', N'Improper or defective plumbing', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (61861, N'SO', N'1010 BRYANT St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), CAST(37.7720000000 AS Decimal(18, 10)), CAST(-122.4070000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.407339'', ''needs_recoding'': False, ''latitude'': ''37.772264'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'61861_20171214', CAST(N'2017-12-14T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'61861_20171214_103105', N'Improper cooling methods', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (62334, N'Prospect', N'318 Spear St 1A, 1B', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), CAST(37.7900000000 AS Decimal(18, 10)), CAST(-122.3910000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.390736'', ''needs_recoding'': False, ''latitude'': ''37.789805'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'62334_20160916', CAST(N'2016-09-16T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'62334_20160916_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (62532, N'Pica Pica', N'401 VALENCIA St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), CAST(37.7660000000 AS Decimal(18, 10)), CAST(-122.4220000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.421986'', ''needs_recoding'': False, ''latitude'': ''37.766394'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'62532_20180320', CAST(N'2018-03-20T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'62532_20180320_103109', N'Unclean or unsanitary food contact surfaces', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (63210, N'Let''s Be Frank', N'Justin Herman Plaza', N'San Francisco', N'CA', NULL, CAST(37.7770000000 AS Decimal(18, 10)), CAST(-122.4200000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.419639'', ''needs_recoding'': False, ''latitude'': ''37.777122'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'63210_20160513', CAST(N'2016-05-13T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'63210_20160513_103116', N'Inadequate food safety knowledge or lack of certified food safety manager', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (64236, N'Sutter Pub and Restaurant', N'700 Sutter St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), CAST(37.7890000000 AS Decimal(18, 10)), CAST(-122.4120000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.41188'', ''needs_recoding'': False, ''latitude'': ''37.78881'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'64236_20170725', CAST(N'2017-07-25T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'64236_20170725_103133', N'Foods not protected from contamination', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (64682, N'Straw', N'203 Octavia St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), CAST(37.7740000000 AS Decimal(18, 10)), CAST(-122.4240000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.42419'', ''needs_recoding'': False, ''latitude'': ''37.773928'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'64682_20160129', CAST(N'2016-01-29T00:00:00.000' AS DateTime), CAST(86.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'64682_20160129_103142', N'Unclean nonfood contact surfaces', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (64814, N'My Ivy Corp.', N'1901 DIVISADERO St', N'San Francisco', N'CA', CAST(94115.0000000000 AS Decimal(18, 10)), CAST(37.7870000000 AS Decimal(18, 10)), CAST(-122.4400000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.440323'', ''needs_recoding'': False, ''latitude'': ''37.787323'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'64814_20160914', CAST(N'2016-09-14T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (65111, N'Cafe Fiore', N'3599 24th St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), CAST(37.7520000000 AS Decimal(18, 10)), CAST(-122.4230000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.422827'', ''needs_recoding'': False, ''latitude'': ''37.751951'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'65111_20160211', CAST(N'2016-02-11T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (65238, N'La Quinta Restaurant', N'2425 MISSION St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), CAST(37.7580000000 AS Decimal(18, 10)), CAST(-122.4190000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.418976'', ''needs_recoding'': False, ''latitude'': ''37.758204'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'65238_20160829', CAST(N'2016-08-29T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (65412, N'Jackson Fillmore Trattoria', N'2506 FILLMORE St', N'San Francisco', N'CA', CAST(94115.0000000000 AS Decimal(18, 10)), CAST(37.7930000000 AS Decimal(18, 10)), CAST(-122.4350000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.434556'', ''needs_recoding'': False, ''latitude'': ''37.792658'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'65412_20160919', CAST(N'2016-09-19T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'65412_20160919_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (65834, N'Roma Pizzeria', N'5099 MISSION St', N'San Francisco', N'CA', CAST(94112.0000000000 AS Decimal(18, 10)), CAST(37.7170000000 AS Decimal(18, 10)), CAST(-122.4400000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.440265'', ''needs_recoding'': False, ''latitude'': ''37.717423'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'65834_20160809', CAST(N'2016-08-09T00:00:00.000' AS DateTime), CAST(78.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'65834_20160809_103124', N'Inadequately cleaned or sanitized food contact surfaces', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (67067, N'Tupelo', N'1337 Grant Ave', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.7990000000 AS Decimal(18, 10)), CAST(-122.4070000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.407334'', ''needs_recoding'': False, ''latitude'': ''37.799293'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'67067_20160805', CAST(N'2016-08-05T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (67448, N'Soo Fong Restaurant', N'3801 03rd St 370', N'San Francisco', N'CA', CAST(94124.0000000000 AS Decimal(18, 10)), CAST(37.7420000000 AS Decimal(18, 10)), CAST(-122.3880000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.388098'', ''needs_recoding'': False, ''latitude'': ''37.741829'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'67448_20170620', CAST(N'2017-06-20T00:00:00.000' AS DateTime), CAST(75.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'67448_20170620_103102', N'Unclean hands or improper use of gloves', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (67565, N'King of Thai Noodles Cafe', N'1541 TARAVAL St', N'San Francisco', N'CA', CAST(94116.0000000000 AS Decimal(18, 10)), CAST(37.7430000000 AS Decimal(18, 10)), CAST(-122.4830000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.482819'', ''needs_recoding'': False, ''latitude'': ''37.742703'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'67565_20161212', CAST(N'2016-12-12T00:00:00.000' AS DateTime), CAST(81.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'67565_20161212_103132', N'Improper thawing methods', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (68263, N'MV Taurus', N'Pier 41', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), CAST(37.8080000000 AS Decimal(18, 10)), CAST(-122.4120000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.412'', ''needs_recoding'': False, ''latitude'': ''37.808494'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'68263_20160518', CAST(N'2016-05-18T00:00:00.000' AS DateTime), CAST(100.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (68872, N'Jiang Ling Cuisine Restaurant', N'2517 SAN BRUNO Ave', N'San Francisco', N'CA', CAST(94134.0000000000 AS Decimal(18, 10)), CAST(37.7300000000 AS Decimal(18, 10)), CAST(-122.4050000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.404526'', ''needs_recoding'': False, ''latitude'': ''37.729985'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'68872_20171212', CAST(N'2017-12-12T00:00:00.000' AS DateTime), CAST(72.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'68872_20171212_103105', N'Improper cooling methods', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (69397, N'Minna SF Group LLC', N'142 Minna St', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'69397_20170203', CAST(N'2017-02-03T00:00:00.000' AS DateTime), CAST(64.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'69397_20170203_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (69512, N'Elephant Sushi', N'1916 Hyde St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.7990000000 AS Decimal(18, 10)), CAST(-122.4190000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.418867'', ''needs_recoding'': False, ''latitude'': ''37.79861'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'69512_20160727', CAST(N'2016-07-27T00:00:00.000' AS DateTime), CAST(61.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'69512_20160727_103142', N'Unclean nonfood contact surfaces', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (69694, N'Split Bread', N'145 04th St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), CAST(37.7840000000 AS Decimal(18, 10)), CAST(-122.4040000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.403513'', ''needs_recoding'': False, ''latitude'': ''37.783984'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'69694_20180323', CAST(N'2018-03-23T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (69909, N'T & L Liquor Store Inc.', N'3168 MISSION St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), CAST(37.7460000000 AS Decimal(18, 10)), CAST(-122.4190000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.4194'', ''needs_recoding'': False, ''latitude'': ''37.746459'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'69909_20180309', CAST(N'2018-03-09T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'69909_20180309_103142', N'Unclean nonfood contact surfaces', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (69962, N'Hong Kee & Kim', N'91 Drumm St', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'69962_20160617', CAST(N'2016-06-17T00:00:00.000' AS DateTime), CAST(75.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'69962_20160617_103156', N'Permit license or inspection report not posted', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (70090, N'Cathead''s BBQ', N'1665 FOLSOM St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), CAST(37.7700000000 AS Decimal(18, 10)), CAST(-122.4150000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.415342'', ''needs_recoding'': False, ''latitude'': ''37.770126'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'70090_20170105', CAST(N'2017-01-05T00:00:00.000' AS DateTime), CAST(93.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'70090_20170105_103105', N'Improper cooling methods', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (70755, N'North Point Market', N'3098 Polk St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), CAST(37.8050000000 AS Decimal(18, 10)), CAST(-122.4240000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.423563'', ''needs_recoding'': False, ''latitude'': ''37.805281'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'70755_20180615', CAST(N'2018-06-15T00:00:00.000' AS DateTime), CAST(100.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (71131, N'Rico Pan', N'5488 MISSION St', N'San Francisco', N'CA', CAST(94112.0000000000 AS Decimal(18, 10)), CAST(37.7130000000 AS Decimal(18, 10)), CAST(-122.4450000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.44456'', ''needs_recoding'': False, ''latitude'': ''37.71291'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'71131_20161005', CAST(N'2016-10-05T00:00:00.000' AS DateTime), CAST(81.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'71131_20161005_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (72004, N'David''s Deli & Bistro', N'474 Geary St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'72004_20161103', CAST(N'2016-11-03T00:00:00.000' AS DateTime), CAST(80.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'72004_20161103_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (72164, N'Modern Thai Inc.', N'1247 Polk St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'72164_20161024', CAST(N'2016-10-24T00:00:00.000' AS DateTime), CAST(75.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'72164_20161024_103124', N'Inadequately cleaned or sanitized food contact surfaces', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (74866, N'Tacolicious', N'1548 Stockton St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'74866_20170508', CAST(N'2017-05-08T00:00:00.000' AS DateTime), NULL, N'Complaint', N'74866_20170508_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (75448, N'Laguna Café', N'1821 Haight St', N'San Francisco', N'CA', CAST(94117.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'75448_20180711', CAST(N'2018-07-11T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'75448_20180711_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (76126, N'Yerba Buena Tea Co (formerly Tea Smiths of SF)', N'3251 20th Ave', N'San Francisco', N'CA', CAST(94132.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'76126_20161009', CAST(N'2016-10-09T00:00:00.000' AS DateTime), CAST(100.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (76218, N'Tenderloin Market & Deli', N'200 Leavenworth', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'76218_20170313', CAST(N'2017-03-13T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (76408, N'Cabin', N'1750 Polk St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'76408_20151001', CAST(N'2015-10-01T00:00:00.000' AS DateTime), CAST(85.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'76408_20151001_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (76479, N'Roadside Rosy''s', N'1018 Columbus Ave', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'76479_20160801', CAST(N'2016-08-01T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (76676, N'Little Vietnam Cafe', N'309 06th Ave', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'76676_20160727', CAST(N'2016-07-27T00:00:00.000' AS DateTime), CAST(81.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'76676_20160727_103133', N'Foods not protected from contamination', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (77731, N'Souvla', N'517 Hayes St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'77731_20170403', CAST(N'2017-04-03T00:00:00.000' AS DateTime), CAST(89.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'77731_20170403_103124', N'Inadequately cleaned or sanitized food contact surfaces', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (77767, N'The Willows', N'1582 Folsom St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'77767_20171023', CAST(N'2017-10-23T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'77767_20171023_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (78075, N'Belly Burger', N'5740 Geary Blvd', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'78075_20170627', CAST(N'2017-06-27T00:00:00.000' AS DateTime), CAST(80.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'78075_20170627_103142', N'Unclean nonfood contact surfaces', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (78102, N'Pho Luen Fat Bakery & Restaurant', N'110 Leland Ave', N'San Francisco', N'CA', CAST(94134.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'78102_20160628', CAST(N'2016-06-28T00:00:00.000' AS DateTime), CAST(79.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'78102_20160628_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (78220, N'Howard & 6th Street Food Market Inc.', N'1000 Howard St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'78220_20161005', CAST(N'2016-10-05T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'78220_20161005_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (78332, N'Hot Pot Island', N'5512 Geary Blvd', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'78332_20170818', CAST(N'2017-08-18T00:00:00.000' AS DateTime), CAST(76.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'78332_20170818_103103', N'High risk food holding temperature', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (78426, N'Pabu', N'101 California St', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'78426_20161207', CAST(N'2016-12-07T00:00:00.000' AS DateTime), NULL, N'Complaint', N'78426_20161207_103121', N'Inadequate procedures or records for time as a public health control', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (78934, N'Koja Kitchen CA01', N'343 Clement St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'78934_20160706', CAST(N'2016-07-06T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (78965, N'Dragoneats', N'555 Folsom St', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'78965_20170712', CAST(N'2017-07-12T00:00:00.000' AS DateTime), NULL, N'Non-inspection site visit', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (79050, N'Restaurante Montecristo', N'3723 Mission St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'79050_20170621', CAST(N'2017-06-21T00:00:00.000' AS DateTime), CAST(81.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'79050_20170621_103154', N'Unclean or degraded floors walls or ceilings', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (79196, N'Veraci Pizza', N'32 06th St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'79196_20170223', CAST(N'2017-02-23T00:00:00.000' AS DateTime), CAST(79.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'79196_20170223_103124', N'Inadequately cleaned or sanitized food contact surfaces', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (79206, N'Pho Express', N'380 Bush St #4', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'79206_20180629', CAST(N'2018-06-29T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (79248, N'Ha Nam Ninh Restaurant', N'701 Larkin St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'79248_20170919', CAST(N'2017-09-19T00:00:00.000' AS DateTime), CAST(71.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'79248_20170919_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (79345, N'Bayshore Taqueria', N'300 Bayshore Blvd #A', N'San Francisco', N'CA', CAST(94124.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'79345_20180501', CAST(N'2018-05-01T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (79414, N'Home Plate', N'2274 Lombard St', N'San Francisco', N'CA', CAST(94123.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'79414_20161017', CAST(N'2016-10-17T00:00:00.000' AS DateTime), CAST(67.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'79414_20161017_103103', N'High risk food holding temperature', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (80121, N'West Coast Wine & Cheese', N'2165 Union St', N'San Francisco', N'CA', CAST(94123.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'80121_20161108', CAST(N'2016-11-08T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'80121_20161108_103133', N'Foods not protected from contamination', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (80242, N'Wing Lee BBQ Restaurant', N'501 Clement St.', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'80242_20160509', CAST(N'2016-05-09T00:00:00.000' AS DateTime), CAST(78.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'80242_20160509_103149', N'Wiping cloths not clean or properly stored or inadequate sanitizer', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (80659, N'Azalina''s', N'1355 Market St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'80659_20160623', CAST(N'2016-06-23T00:00:00.000' AS DateTime), CAST(83.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'80659_20160623_103103', N'High risk food holding temperature', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (81116, N'Dragon Beaux', N'5700 Geary Blvd', N'San Francisco', N'CA', CAST(94121.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'81116_20150918', CAST(N'2015-09-18T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (81250, N'Stanford Court Hotel', N'905 California St', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'81250_20171027', CAST(N'2017-10-27T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (81473, N'24th and Folsom Eatery', N'3109 24th St', N'San Francisco', N'CA', NULL, NULL, NULL, N'', NULL, N'81473_20150930', CAST(N'2015-09-30T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (81579, N'Salem Grocery', N'920 Geary St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'81579_20171221', CAST(N'2017-12-21T00:00:00.000' AS DateTime), CAST(91.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'81579_20171221_103103', N'High risk food holding temperature', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (81886, N'Cafe Broadway', N'674 Broadway St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'81886_20180418', CAST(N'2018-04-18T00:00:00.000' AS DateTime), CAST(76.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'81886_20180418_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (82231, N'Rusty''s Southern LLC', N'750 Ellis St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'82231_20170706', CAST(N'2017-07-06T00:00:00.000' AS DateTime), CAST(84.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'82231_20170706_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (82232, N'24 Hour Fitness Club, #273', N'3951 Alemany Blvd', N'San Francisco', N'CA', CAST(94132.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'82232_20170530', CAST(N'2017-05-30T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'82232_20170530_103156', N'Permit license or inspection report not posted', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (82466, N'Tanuki Restaurant', N'4419 California St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'82466_20180828', CAST(N'2018-08-28T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'82466_20180828_103142', N'Unclean nonfood contact surfaces', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (82655, N'Mizutani Sushi Bar', N'4406 California St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'82655_20160609', CAST(N'2016-06-09T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (82930, N'Blue Bottle Coffee', N'115 Sansome St', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'82930_20160720', CAST(N'2016-07-20T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (83046, N'Project Juice', N'364 Hayes St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'83046_20171019', CAST(N'2017-10-19T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'83046_20171019_103131', N'Moderate risk vermin infestation', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (83351, N'City Super', N'1108 Stockton St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'83351_20171127', CAST(N'2017-11-27T00:00:00.000' AS DateTime), CAST(78.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'83351_20171127_103150', N'Improper or defective plumbing', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (83423, N'Carbon Grill', N'852 Clement St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'83423_20170328', CAST(N'2017-03-28T00:00:00.000' AS DateTime), CAST(75.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'83423_20170328_103132', N'Improper thawing methods', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (83436, N'San Francisco Marriott Union Square - Main Kitchen', N'480 Sutter St 1st Floor', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'83436_20160628', CAST(N'2016-06-28T00:00:00.000' AS DateTime), CAST(92.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'83436_20160628_103124', N'Inadequately cleaned or sanitized food contact surfaces', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (83655, N'Bellissimo Pizza', N'920 Sutter St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'83655_20160714', CAST(N'2016-07-14T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'83655_20160714_103124', N'Inadequately cleaned or sanitized food contact surfaces', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (83746, N'The Lord George', N'555 02nd St', N'San Francisco', N'CA', CAST(94107.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'83746_20180330', CAST(N'2018-03-30T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'83746_20180330_103149', N'Wiping cloths not clean or properly stored or inadequate sanitizer', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (83824, N'Earthbar', N'301 Pine St', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'83824_20160826', CAST(N'2016-08-26T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'83824_20160826_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (84922, N'Taco Bell Cantina #31685', N'710 03rd St', N'San Francisco', N'CA', CAST(94107.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'84922_20160919', CAST(N'2016-09-19T00:00:00.000' AS DateTime), CAST(100.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (85051, N'Blue Bottle Coffee', N'1 Ferry Building Kiosk #56', N'San Francisco', N'CA', CAST(94111.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'85051_20180117', CAST(N'2018-01-17T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (85843, N'House of Xian Dumpling', N'925 Kearny St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'85843_20171206', CAST(N'2017-12-06T00:00:00.000' AS DateTime), CAST(88.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'85843_20171206_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (85908, N'Yummy Sticks', N'428 11th St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'85908_20160618', CAST(N'2016-06-18T00:00:00.000' AS DateTime), CAST(81.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'85908_20160618_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86276, N'Contrada', N'2136 Union St', N'San Francisco', N'CA', CAST(94123.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'86276_20161110', CAST(N'2016-11-10T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86306, N'Dim Sum Bistro', N'675 Broadway St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'86306_20171130', CAST(N'2017-11-30T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'86306_20171130_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86475, N'Sushi Hon', N'2598 Harrison St', N'San Francisco', N'CA', CAST(94110.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'86475_20160616', CAST(N'2016-06-16T00:00:00.000' AS DateTime), NULL, N'New Ownership', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86486, N'Surisan', N'505 Beach St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'86486_20180228', CAST(N'2018-02-28T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'86486_20180228_103144', N'Unapproved or unmaintained equipment or utensils', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86645, N'Old Siam Thai Restaurant', N'201 Ellis St', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'86645_20160720', CAST(N'2016-07-20T00:00:00.000' AS DateTime), CAST(84.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'86645_20160720_103161', N'Low risk vermin infestation', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86647, N'Da Cafe', N'407 Clement St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'86647_20160907', CAST(N'2016-09-07T00:00:00.000' AS DateTime), CAST(48.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'86647_20160907_103112', N'No hot water or running water', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86766, N'Coffee Cultures SOMA', N'1301 Mission St.', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'86766_20180212', CAST(N'2018-02-12T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'86766_20180212_103157', N'Food safety certificate or food handler card not available', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (86780, N'Peet''s Coffee & Tea', N'405 Howard St', N'San Francisco', N'CA', CAST(94104.0000000000 AS Decimal(18, 10)), CAST(37.7890000000 AS Decimal(18, 10)), CAST(-122.3950000000 AS Decimal(18, 10)), N'{''longitude'': ''-122.395322'', ''needs_recoding'': False, ''latitude'': ''37.789057'', ''human_address'': ''{"address":"","city":"","state":"","zip":""}''}', NULL, N'32823_20171027', CAST(N'2017-10-27T00:00:00.000' AS DateTime), NULL, N'Reinspection/Followup', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (87021, N'Southern Comfort Kitchen', N'Off The Grid', N'San Francisco', N'CA', NULL, NULL, NULL, N'', NULL, N'87021_20180305', CAST(N'2018-03-05T00:00:00.000' AS DateTime), NULL, N'Structural Inspection', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (87048, N'Hans Coffee Shop', N'900 Sutter St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'87048_20160413', CAST(N'2016-04-13T00:00:00.000' AS DateTime), NULL, N'Structural Inspection', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (87364, N'Dip, LLC', N'1318 Grant Ave', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'87364_20170425', CAST(N'2017-04-25T00:00:00.000' AS DateTime), CAST(78.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'87364_20170425_103149', N'Wiping cloths not clean or properly stored or inadequate sanitizer', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (87611, N'Sam Rong Cafe', N'670 Broadway St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'87611_20170523', CAST(N'2017-05-23T00:00:00.000' AS DateTime), CAST(67.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'87611_20170523_103114', N'High risk vermin infestation', N'High Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (87645, N'Batter Bakery', N'1517 Pine St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'87645_20160912', CAST(N'2016-09-12T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'87645_20160912_103139', N'Improper food storage', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (87664, N'Poke Kana', N'65 Cambon Dr', N'San Francisco', N'CA', CAST(94132.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'87664_20160722', CAST(N'2016-07-22T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (88099, N'Fair Trade Cafe LLC', N'75 Hawthorne St', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'88099_20170929', CAST(N'2017-09-29T00:00:00.000' AS DateTime), NULL, N'Non-inspection site visit', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (88688, N'Akira Japanese Restaurant', N'1634 Bush St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'88688_20170111', CAST(N'2017-01-11T00:00:00.000' AS DateTime), CAST(90.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'88688_20170111_103149', N'Wiping cloths not clean or properly stored or inadequate sanitizer', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (88883, N'Jane the Bakery', N'1875 Geary Blvd', N'San Francisco', N'CA', CAST(94115.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'88883_20161202', CAST(N'2016-12-02T00:00:00.000' AS DateTime), NULL, N'New Ownership', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (89338, N'Nabe', N'2151 Lombard St', N'San Francisco', N'CA', CAST(94123.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'89338_20161019', CAST(N'2016-10-19T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (89393, N'Panuchos', N'620 Broadway St', N'San Francisco', N'CA', CAST(94133.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'89393_20180411', CAST(N'2018-04-11T00:00:00.000' AS DateTime), CAST(84.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'89393_20180411_103157', N'Food safety certificate or food handler card not available', N'Low Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (89594, N'Luke''s Local Inc.', N'960 Cole St.', N'San Francisco', N'CA', CAST(94117.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'89594_20171127', CAST(N'2017-11-27T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'89594_20171127_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (89640, N'The Bindery', N'1727 Haight St', N'San Francisco', N'CA', CAST(94117.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'89640_20171023', CAST(N'2017-10-23T00:00:00.000' AS DateTime), NULL, N'New Ownership', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (89686, N'Big Fish Little Fish Poke', N'121 Spear St B09', N'San Francisco', N'CA', CAST(94105.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'89686_20180227', CAST(N'2018-02-27T00:00:00.000' AS DateTime), CAST(82.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'89686_20180227_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (89775, N'Flores', N'2030 Union St', N'San Francisco', N'CA', CAST(94123.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'89775_20161116', CAST(N'2016-11-16T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (90217, N'Heritage', N'708 Clement St', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'90217_20180605', CAST(N'2018-06-05T00:00:00.000' AS DateTime), CAST(87.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'90217_20180605_103119', N'Inadequate and inaccessible handwashing facilities', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (90221, N'Iza Ramen', N'1155 Folsom St', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'90221_20180529', CAST(N'2018-05-29T00:00:00.000' AS DateTime), CAST(81.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'90221_20180529_103129', N'Insufficient hot water or running water', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (90839, N'The Grove - Design District', N'65 Division St.', N'San Francisco', N'CA', CAST(94103.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'90839_20180427', CAST(N'2018-04-27T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'90839_20180427_103124', N'Inadequately cleaned or sanitized food contact surfaces', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (91276, N'A Mano', N'450 Hayes St., Suite C-2', N'San Francisco', N'CA', CAST(94102.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'91276_20170505', CAST(N'2017-05-05T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (91762, N'Pho Huynh Sang', N'239 Clement St.', N'San Francisco', N'CA', CAST(94118.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'91762_20170612', CAST(N'2017-06-12T00:00:00.000' AS DateTime), NULL, N'Non-inspection site visit', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (91934, N'Keep It, Inc.', N'1170 Powell St', N'San Francisco', N'CA', CAST(94108.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'91934_20171026', CAST(N'2017-10-26T00:00:00.000' AS DateTime), NULL, N'New Construction', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (91979, N'Milkbomb Ice Cream', N'415 De Haro St., Unit 105', N'San Francisco', N'CA', CAST(94107.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'91979_20180615', CAST(N'2018-06-15T00:00:00.000' AS DateTime), CAST(94.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'91979_20180615_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (91989, N'Kuma Sushi + Sake', N'1040 Polk St', N'San Francisco', N'CA', CAST(94109.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'91989_20170803', CAST(N'2017-08-03T00:00:00.000' AS DateTime), NULL, N'Non-inspection site visit', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (93607, N'Boos Voni', N'5170 Mission St', N'San Francisco', N'CA', CAST(94112.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'93607_20171116', CAST(N'2017-11-16T00:00:00.000' AS DateTime), NULL, N'New Ownership', N'', N'', NULL)
GO
INSERT [dbo].[sf_restaurant_health_violations] ([business_id], [business_name], [business_address], [business_city], [business_state], [business_postal_code], [business_latitude], [business_longitude], [business_location], [business_phone_number], [inspection_id], [inspection_date], [inspection_score], [inspection_type], [violation_id], [violation_description], [risk_category]) VALUES (95117, N'95117 Premium Commissary Room', N'24 Willie Mays Pl Field Level', N'San Francisco', N'CA', CAST(94107.0000000000 AS Decimal(18, 10)), NULL, NULL, N'', NULL, N'95117_20180326', CAST(N'2018-03-26T00:00:00.000' AS DateTime), CAST(96.0000000000 AS Decimal(18, 10)), N'Routine - Unscheduled', N'95117_20180326_103120', N'Moderate risk food holding temperature', N'Moderate Risk')
GO