SQL Server 2016 Deeper Insights
Overview
In the last few years Analytics workloads have undergone a huge transformation in terms of the volume and type of structured and unstructured data that needs to be analyzed. This data could be from a variety of sources like IoT data from sensor devices, text data from files and records or consumer sentiment data from social media platforms. One of the platforms that is used to analyze this type of high volume unstructured data is Hadoop. Microsoft Azure HDInsight enables customers to setup Hadoop clusters utilizing Azure Blob storage as the data store for the raw and analyzed data. Increasingly, BI analysts are expected to produce quick insights into trends and anomalies observed in the businesses they support which requires correlating non-relational data with traditional relational data in the SQL Server relational database. Traditionally, to enable this it usually involved:
- Data ETL from relational to non-relational data sources and moving large amounts of data between the sources
- Potentially crossing security boundaries not permitted due to data security policies
- Analysts having to learn new skill sets to analyze the data in languages other than T-SQL
These factors lead to expensive and complex ETL implementations and time delays in achieving time sensitive insights into the data.
SQL Server 2016 introduces a number of capabilities like PolyBase with the ability to connect to non-relational data sources enabling analysis in T-SQL and avoid ETL implementations with associated data movement.
The following sections explain these capabilities and also enumerate considerations that the Hosting Service Provider (HSP) database administrator has to keep in mind while implementing the Deeper Insights offer.
DBA Considerations
In order to implement the Hybrid Analytics database on SQL Server 2016 database administrators should:
- Understand the source and location of the non-relational data sets that need to be correlated and analyzed with the relational data
- Work with their networking team to ensure network connectivity between the SQL Server and the non-relational data source
The rest of the document provides details of the capabilities leveraged and gives step-by-step guidance on implementing the hybrid analytics database in the context of a customer scenario.
SQL Server 2016 capabilities for a Hybrid Analytics database implementation
PolyBase Engine
The goal of PolyBase is to make interacting with unstructured, semi-structured and non-relational data stored in Hadoop as easy as writing Transact-SQL statements. PolyBase allows users to query non-relational data in Hadoop, blobs or files, and combine it anytime, anywhere with their existing relational data in SQL Server. It is a transparent access bridge from SQL to Hadoop. As a channel between Hadoop and relational databases, it allows users to query files (structured, semi-structured and unstructured) in Hadoop using the familiar language of TSQL. For more information, see the PolyBase guide.
Azure HDInsight
Azure HDInsight is a managed Big Data platform for analyzing structured and unstructured data. Azure HDInsight enables users to spin up or down Apache Hadoop clusters in Azure without the need for expensive hardware. For more information, see HDInsight Hadoop introduction.
Example Scenario
A healthcare ISV HealthSoft Inc. collects patient observation data from hundreds of point of care facilities like clinics and hospitals. This data is unstructured, stored and analyzed in Azure HDInsight with the analyzed data stored in an Azure Blob store. However, sensitive patient and provider data is stored in a hosted SQL Server database.
The BI analysts at HealthSoft are asked to explain trends and anomalies observed in the field using analysis based on healthcare provider, patient, patient risk factors and provider geo-location which allows the providers to be informed immediately when necessary.
- The patient and provider reference data is present in a hosted SQL Server database
- Some of the observational data is analyzed in HDInsight and is stored in Azure Blob storage
Solution Design
Reference architecture diagram
Database Design
The Patients and Providers tables contains Personal Identifiable Information (PII) and are stored on premise in the SQL Server. The Measurements table only contains id numbers for patients and providers. By itself, the Measurements data cannot be used to identify a patient or a provider. This data can be stored in Azure.
High level implementation steps
- Install PolyBase on the SQL Server
- Create a database
- Create local tables
- Upload HDInsight sample data into Azure blob storage
- Connect SQL Server to Azure Blob Storage
- Define the file format
- Connect an external table to the data file
- Query the data
Implementation
Install PolyBase on the SQL Server
Install the Java Runtime Engine (JRE) or the Java Development Kit (JDK)
Run the SQL Server setup program and navigate to the Feature Selection screen. Select "PolyBase Query Service for External Data" and click "Next".
Configure SQL Server as a standalone PolyBase-enabled instance
Verify Polybase is installed
TSql Script (cut/paste):
SELECT SERVERPROPERTY ('IsPolybaseInstalled') AS IsPolybaseInstalled;
As shown below:
Create a database
Create a database to hold the external tables
Using the SQL Create Table dialog:
TSql Script (cut/paste):
USE [master]
GO
CREATE DATABASE [TestDb] CONTAINMENT = NONE
ON PRIMARY (
NAME = N'TestDb',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATATestDb.mdf',
SIZE = 8192KB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 65536KB
)
LOG ON (
NAME = N'TestDb_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\TestDb_log.ldf' ,
SIZE = 8192KB,
MAXSIZE = 2048GB,
FILEGROWTH = 65536KB
)
GO
Set the Collation to SQL_Latin1_General_CP1_CI_AS or Latin1_General_100_CI_AS_KS_WS
Create local tables
Run PatientTable.sql
CREATE TABLE [dbo].[Patients] (
[Id] [char](4) NULL,
[GivenName] [varchar](20) NULL,
[FamilyName] [varchar](20) NULL,
[Phone] [char](10) NULL,
[Birthday] [date] NULL,
[DiabetesPedigree] [tinyint] NULL
) ON [PRIMARY]
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0336','Harper','Quintero','1274550681','11/25/1972 13:38:39',0.510)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0266','Logan','Quintero','5006411536','02/21/1964 13:38:39',0.351)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0233','Harper','Downing','2947295521','11/10/1942 13:38:39',0.560)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0281','Reagan','Balakrishnan','6234839521','04/18/1974 13:38:39',0.167)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0431','Harper','Balakrishnan','3450714912','08/13/1962 13:38:40',2.288)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0256','Jayden','Quintero','4294967296','11/20/1972 13:38:38',0.572)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0310','Carter','Badwe','9235210000','08/10/1973 13:38:39',0.874)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0353','Jayden','Downing','1552740288','12/03/1972 13:38:39',0.262)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0305','Cameron','Peruvemba','8653650625','07/19/1969 13:38:39',1.391)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0000','Cameron','Badwe','8653650625','09/01/1972 13:38:38',0.572)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0376','Micah','Quintero','1998717337','02/01/1973 13:38:39',0.143)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0380','Reagan','Badwe','2085136000','02/14/1972 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0271','Micah','Balakrishnan','5393580481','03/05/1971 13:38:39',0.400)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0301','Cameron','Balakrishnan','8208541201','07/01/1936 13:38:39',0.398)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0258','Jayden','Tourigny','4430766096','01/24/1970 13:38:39',0.207)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0300','Cameron','Badwe','8100000000','06/24/1973 13:38:39',0.527)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0458','Jayden','Tourigny','4400093569','09/13/1964 13:38:40',0.551)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0296','Ryan','Quintero','7676563456','06/04/1948 13:38:39',0.197)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0433','Harper','Downing','3515212512','08/28/1969 13:38:39',1.391)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0346','Hunter','Quintero','1433192065','11/18/1972 13:38:39',0.452)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0393','Ryan','Downing','2385449360','03/30/1971 13:38:39',0.165)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0354','Jayden','Gautam','1570409985','12/06/1974 13:38:39',0.268)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0398','Ryan','Tourigny','2509182721','11/11/1944 13:38:39',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0290','Ryan','Badwe','7072810000','05/18/1974 13:38:39',0.229)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0366','Logan','Quintero','1794420993','03/30/1970 13:38:40',0.757)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0311','Carter','Balakrishnan','9354951841','08/09/1963 13:38:39',0.205)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0394','Ryan','Gautam','2409821569','04/02/1964 13:38:39',0.351)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0232','Harper','Chiluvuri','2897022976','11/07/1972 13:38:39',0.487)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0222','Dylan','Chiluvuri','2428912656','01/06/1973 13:38:39',0.108)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0341','Hunter','Balakrishnan','1352127096','12/21/1957 13:38:39',0.328)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0360','Logan','Badwe','1679616000','12/17/1972 13:38:39',0.487)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0316','Carter','Quintero','9971220736','08/26/1962 13:38:39',0.743)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0248','Hunter','Tourigny','3782742016','12/23/1972 13:38:39',0.143)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0199','Ryan','Ybarra','1568239201','09/23/1971 13:38:39',0.188)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0276','Micah','Quintero','5802782976','07/07/1971 13:38:39',0.730)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0240','Hunter','Badwe','3317760000','11/25/1971 13:38:39',0.138)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0332','Harper','Chiluvuri','1214933017','11/06/1972 13:38:39',0.323)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0329','Dylan','Ybarra','1171611408','11/05/1972 13:38:39',0.257)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0382','Reagan','Chiluvuri','2129381377','02/22/1973 13:38:39',0.583)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0371','Micah','Balakrishnan','1894504488','01/15/1974 13:38:39',0.187)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0340','Hunter','Badwe','1336336000','11/16/1971 13:38:39',0.415)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0402','Cameron','Chiluvuri','2611585281','04/23/1958 13:38:39',0.254)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0227','Dylan','Shelly','2655237841','10/27/1952 13:38:39',0.235)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0454','Jayden','Gautam','4248380545','11/20/1960 13:38:39',0.391)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0274','Micah','Gautam','5636405776','03/14/1958 13:38:39',0.254)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0420','Dylan','Badwe','3111696000','07/03/1974 13:38:39',0.192)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0297','Ryan','Shelly','7780827681','06/08/1966 13:38:39',0.564)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0280','Reagan','Badwe','6146560000','04/12/1974 13:38:39',0.586)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0391','Ryan','Balakrishnan','2337260016','03/25/1973 13:38:39',0.107)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0194','Ryan','Gautam','1416468496','09/18/1972 13:38:39',0.491)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0242','Hunter','Chiluvuri','3429742096','11/30/1968 13:38:39',0.526)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0244','Hunter','Gautam','3544535296','12/10/1971 13:38:39',0.249)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0337','Harper','Shelly','1289791776','12/02/1967 13:38:39',0.711)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0347','Hunter','Shelly','1449832728','11/23/1928 13:38:39',0.254)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0230','Harper','Badwe','2798410000','11/01/1973 13:38:39',0.248)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0377','Micah','Shelly','2020065264','02/03/1942 13:38:39',0.744)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0468','Logan','Tourigny','4797151257','12/26/1971 13:38:39',0.415)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0405','Cameron','Peruvemba','2690420062','05/10/1974 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0415','Carter','Peruvemba','2966145062','06/13/1972 13:38:39',0.532)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0250','Jayden','Badwe','3906250000','12/27/1971 13:38:39',0.253)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0254','Jayden','Gautam','4162314256','01/13/1973 13:38:39',0.583)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0328','Dylan','Tourigny','1157431705','11/04/1971 13:38:39',0.236)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0325','Dylan','Peruvemba','1115664062','10/07/1956 13:38:39',0.855)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0427','Dylan','Shelly','3324386424','07/29/1972 13:38:39',0.422)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0196','Ryan','Quintero','1475789056','09/21/1969 13:38:39',0.334)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0289','Reagan','Ybarra','6975757441','05/12/1971 13:38:39',0.773)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0286','Reagan','Quintero','6690585616','05/02/1974 13:38:39',0.692)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0434','Harper','Gautam','3547798273','08/20/1960 13:38:40',1.021)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0351','Jayden','Balakrishnan','1517848640','11/30/1970 13:38:39',0.205)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0320','Dylan','Badwe','1048576000','09/09/1972 13:38:39',0.682)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0247','Hunter','Shelly','3722098081','12/18/1972 13:38:39',0.206)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0326','Dylan','Quintero','1129458817','10/11/1960 13:38:39',0.391)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0432','Harper','Chiluvuri','3482851737','08/14/1969 13:38:40',0.270)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0224','Dylan','Gautam','2517630976','10/22/1967 13:38:39',0.207)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0293','Ryan','Downing','7370050801','05/25/1967 13:38:39',0.695)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0246','Hunter','Quintero','3662186256','12/14/1971 13:38:39',0.237)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0488','Reagan','Tourigny','5671256473','01/26/1973 13:38:39',0.487)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0324','Dylan','Gautam','1101996057','09/27/1967 13:38:39',0.601)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0385','Reagan','Peruvemba','2197065062','05/23/1971 13:38:40',0.324)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0265','Logan','Peruvemba','4931550625','02/18/1971 13:38:39',0.165)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0191','Ryan','Balakrishnan','1330863361','09/16/1973 13:38:39',0.258)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0467','Logan','Shelly','4756281192','12/22/1968 13:38:39',0.342)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0238','Harper','Tourigny','3208542736','11/20/1937 13:38:39',0.277)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0339','Harper','Ybarra','1320683624','11/12/1968 13:38:39',0.342)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0204','Cameron','Gautam','1731891456','09/27/1972 13:38:39',0.323)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0287','Reagan','Shelly','6784652161','05/04/1972 13:38:39',0.532)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0497','Ryan','Shelly','6101344608','02/17/1972 13:38:39',0.828)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0390','Ryan','Badwe','2313441000','03/22/1974 13:38:39',0.256)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0261','Logan','Balakrishnan','4640470641','02/07/1973 13:38:39',0.179)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0225','Dylan','Peruvemba','2562890625','10/24/1972 13:38:39',0.262)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0396','Ryan','Quintero','2459125785','11/01/1969 13:38:39',0.455)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0295','Ryan','Peruvemba','7573350625','05/29/1972 13:38:39',0.626)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0343','Hunter','Downing','1384128720','01/02/1973 13:38:39',0.196)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0374','Micah','Gautam','1956529537','01/23/1972 13:38:39',0.237)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0333','Harper','Downing','1229637032','11/14/1971 13:38:39',0.278)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0312','Carter','Chiluvuri','9475854336','10/25/1966 13:38:39',0.582)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0282','Reagan','Chiluvuri','6324066576','04/18/1976 13:38:39',0.443)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0532','Harper','Chiluvuri','8010258457','10/04/1970 13:38:40',0.759)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0342','Hunter','Chiluvuri','1368057729','12/25/1973 13:38:39',0.142)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0268','Logan','Tourigny','5158686976','09/22/1969 13:38:39',0.455)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0550','Jayden','Badwe','9150625000','10/04/1970 13:38:40',0.496)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0429','Dylan','Ybarra','3387108968','08/10/1936 13:38:39',0.398)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0345','Hunter','Peruvemba','1416695062','11/17/1926 13:38:39',0.735)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0279','Micah','Ybarra','6059221281','04/11/1932 13:38:39',0.741)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0383','Reagan','Downing','2151766272','08/12/1964 13:38:39',0.161)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0211','Carter','Balakrishnan','1982119441','10/03/1968 13:38:39',0.342)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0338','Harper','Tourigny','1305169153','11/10/1972 13:38:39',0.252)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0308','Cameron','Tourigny','8999178496','07/27/1973 13:38:39',0.597)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0369','Logan','Ybarra','1853981792','01/08/1972 13:38:39',0.828)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0395','Ryan','Peruvemba','2434380062','04/06/1933 13:38:39',0.687)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0273','Micah','Downing','5554571841','03/10/1962 13:38:39',0.787)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0219','Carter','Ybarra','2300257521','10/14/1928 13:38:39',0.254)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0406','Cameron','Quintero','2717090689','05/14/1971 13:38:39',0.454)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0479','Micah','Ybarra','5264317248','01/09/1971 13:38:39',0.205)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0500','Cameron','Badwe','6250000000','02/28/1972 13:38:39',0.249)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0252','Jayden','Chiluvuri','4032758016','01/05/1972 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0409','Cameron','Ybarra','2798293296','05/28/1974 13:38:39',0.167)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0372','Micah','Chiluvuri','1915013145','01/19/1972 13:38:39',0.249)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0442','Hunter','Chiluvuri','3816709249','08/29/1968 13:38:40',0.167)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0299','Ryan','Ybarra','7992538801','06/19/1972 13:38:39',0.422)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0319','Carter','Ybarra','1035530112','10/26/1973 13:38:39',0.258)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0284','Reagan','Gautam','6505390336','04/22/1974 13:38:39',0.766)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0435','Harper','Peruvemba','3580610062','09/04/1970 13:38:39',0.520)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0327','Dylan','Shelly','1143381104','10/13/1971 13:38:39',0.166)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0671','Micah','Balakrishnan','2027169580','10/08/1969 13:38:40',0.319)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0450','Jayden','Badwe','4100625000','12/07/1972 13:38:39',0.491)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0349','Hunter','Ybarra','1483548360','11/26/1972 13:38:39',0.207)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0277','Micah','Shelly','5887339441','03/31/1974 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0359','Jayden','Ybarra','1661031216','12/13/1968 13:38:39',0.407)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0226','Dylan','Quintero','2608757776','10/27/1974 13:38:39',0.268)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0331','Harper','Balakrishnan','1200361272','11/03/1976 13:38:39',0.446)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0304','Cameron','Gautam','8540717056','07/12/1972 13:38:39',0.315)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0523','Dylan','Downing','7481811384','05/16/1933 13:38:39',0.687)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0243','Hunter','Downing','3486784401','12/06/1973 13:38:39',0.187)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0229','Dylan','Ybarra','2750058481','10/30/1973 13:38:39',0.326)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0348','Hunter','Tourigny','1466617881','01/26/1972 13:38:40',0.217)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0309','Cameron','Ybarra','9116621361','08/04/1963 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0401','Cameron','Balakrishnan','2585696160','04/19/1962 13:38:39',0.787)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0239','Harper','Ybarra','3262808641','11/23/1972 13:38:39',0.260)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0375','Micah','Peruvemba','1977539062','01/27/1973 13:38:39',0.206)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0355','Jayden','Peruvemba','1588230062','02/20/1971 13:38:40',0.280)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0428','Dylan','Tourigny','3355637785','08/03/1973 13:38:39',0.527)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0426','Dylan','Quintero','3293353857','08/05/1971 13:38:40',0.431)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0418','Carter','Tourigny','3052847617','06/27/1974 13:38:39',0.229)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0358','Jayden','Tourigny','1642601089','12/11/1973 13:38:39',0.248)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0378','Micah','Tourigny','2041583745','02/05/1972 13:38:39',0.253)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0288','Reagan','Tourigny','6879707136','05/10/1951 13:38:39',0.153)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0236','Harper','Quintero','3102044416','11/16/1968 13:38:39',0.666)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0357','Jayden','Shelly','1624324760','03/01/1969 13:38:40',0.198)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0367','Logan','Shelly','1814112672','01/02/1973 13:38:39',0.260)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0452','Jayden','Chiluvuri','4174012441','11/06/1967 13:38:39',0.601)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0440','Hunter','Badwe','3748096000','12/04/1966 13:38:39',0.582)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0462','Logan','Chiluvuri','4555834113','10/30/1957 13:38:40',0.238)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0350','Jayden','Badwe','1500625000','02/03/1953 13:38:40',0.233)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0436','Harper','Quintero','3613648921','09/05/1973 13:38:39',0.597)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0441','Hunter','Balakrishnan','3782285936','08/28/1972 13:38:40',0.686)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0184','Reagan','Gautam','1146228736','09/15/1966 13:38:39',0.582)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0292','Ryan','Chiluvuri','7269949696','05/24/1974 13:38:39',0.192)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0259','Jayden','Ybarra','4499860561','01/27/1971 13:38:39',0.655)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0321','Dylan','Balakrishnan','1061744768','10/26/1966 13:38:39',0.284)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0363','Logan','Downing','1736306936','03/21/1970 13:38:40',0.933)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0400','Cameron','Badwe','2560000000','04/17/1971 13:38:39',0.580)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0251','Jayden','Balakrishnan','3969126001','01/02/1973 13:38:39',0.078)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0275','Micah','Peruvemba','5719140625','03/19/1973 13:38:39',0.115)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0456','Jayden','Quintero','4323738009','12/14/1971 13:38:39',0.236)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0278','Micah','Tourigny','5972816656','04/04/1971 13:38:39',0.454)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0249','Hunter','Ybarra','3844124001','12/25/1941 13:38:39',0.744)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0253','Jayden','Downing','4097152081','01/11/1967 13:38:39',0.658)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0379','Micah','Ybarra','2063273688','02/11/1973 13:38:39',0.078)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0270','Micah','Badwe','5314410000','10/02/1944 13:38:39',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0260','Logan','Badwe','4569760000','02/03/1975 13:38:39',0.561)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0387','Reagan','Shelly','2243075336','03/08/1971 13:38:39',0.655)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0208','Cameron','Tourigny','1871773696','09/28/1971 13:38:39',0.340)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0361','Logan','Balakrishnan','1698356304','12/20/1942 13:38:39',0.560)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0307','Cameron','Shelly','8882874001','07/26/1970 13:38:39',0.520)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0323','Dylan','Downing','1088454024','09/24/1964 13:38:39',0.839)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0529','Dylan','Ybarra','7831098528','05/29/1962 13:38:39',0.787)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0210','Carter','Badwe','1944810000','10/01/1972 13:38:39',0.252)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0397','Ryan','Shelly','2484059688','06/26/1968 13:38:40',0.215)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0255','Jayden','Peruvemba','4228250625','07/03/1964 13:38:39',0.161)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0262','Logan','Chiluvuri','4711998736','02/10/1974 13:38:39',0.256)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0193','Ryan','Downing','1387488001','09/16/1966 13:38:39',0.284)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0381','Reagan','Balakrishnan','2107171592','02/20/1967 13:38:39',0.658)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0235','Harper','Peruvemba','3049800625','11/13/1970 13:38:39',0.191)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0455','Jayden','Peruvemba','4285935062','11/22/1971 13:38:39',0.166)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0231','Harper','Balakrishnan','2847396321','11/03/1968 13:38:39',0.407)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0399','Ryan','Ybarra','2534495840','04/14/1971 13:38:39',0.400)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0368','Logan','Tourigny','1833965977','01/04/1972 13:38:39',0.138)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0218','Carter','Tourigny','2258530576','10/09/1972 13:38:39',0.452)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0410','Carter','Badwe','2825761000','05/28/1976 13:38:39',0.443)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0422','Dylan','Chiluvuri','3171391105','07/28/1970 13:38:40',0.237)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0344','Hunter','Gautam','1400340889','01/08/1971 13:38:39',0.528)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0272','Micah','Chiluvuri','5473632256','03/08/1971 13:38:39',0.580)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0365','Logan','Peruvemba','1774890062','12/29/1973 13:38:39',0.389)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0298','Ryan','Tourigny','7886150416','06/15/1974 13:38:39',0.717)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0392','Ryan','Chiluvuri','2361262489','03/27/1971 13:38:39',0.133)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0384','Reagan','Gautam','2174327193','02/28/1971 13:38:39',0.123)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0362','Logan','Chiluvuri','1717252993','12/22/1961 13:38:39',0.447)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0483','Reagan','Downing','5442375752','03/31/1971 13:38:40',0.280)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0200','Cameron','Badwe','1600000000','09/25/1971 13:38:39',0.236)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0223','Dylan','Downing','2472973441','10/21/1970 13:38:39',0.205)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0457','Jayden','Shelly','4361790480','12/15/1972 13:38:39',0.257)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0237','Harper','Shelly','3154956561','11/19/1973 13:38:39',0.389)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0221','Dylan','Balakrishnan','2385443281','10/17/1972 13:38:39',0.207)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0421','Dylan','Balakrishnan','3141437208','07/04/1967 13:38:39',0.695)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0424','Dylan','Gautam','3231941017','07/14/1948 13:38:39',0.197)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0182','Reagan','Chiluvuri','1097199376','09/12/1967 13:38:38',0.624)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0264','Logan','Gautam','4857532416','02/15/1971 13:38:39',0.133)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0453','Jayden','Downing','4211073368','11/16/1956 13:38:39',0.855)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0370','Micah','Badwe','1874161000','01/09/1969 13:38:39',0.526)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0245','Hunter','Peruvemba','3603000625','12/13/1958 13:38:39',1.138)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0322','Dylan','Chiluvuri','1075037185','10/28/1972 13:38:39',0.491)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0594','Ryan','Gautam','1244932428','02/26/1951 13:38:39',0.932)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0212','Carter','Chiluvuri','2019963136','10/07/1971 13:38:39',0.415)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0267','Logan','Shelly','5082121521','02/25/1933 13:38:39',0.687)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0302','Cameron','Chiluvuri','8318169616','07/09/1975 13:38:39',0.364)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0461','Logan','Balakrishnan','4516517544','12/24/1971 13:38:39',0.278)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0413','Carter','Downing','2909378376','06/08/1973 13:38:39',0.219)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0388','Reagan','Tourigny','2266349593','06/03/1973 13:38:40',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0352','Jayden','Chiluvuri','1535220121','12/01/1967 13:38:39',0.207)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0423','Dylan','Downing','3201558704','07/30/1971 13:38:40',0.365)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0407','Cameron','Shelly','2743959120','05/21/1932 13:38:39',0.741)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0465','Logan','Peruvemba','4675325062','09/19/1937 13:38:40',1.159)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0335','Harper','Peruvemba','1259445062','11/23/1954 13:38:39',0.292)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0373','Micah','Downing','1935687864','01/22/1959 13:38:39',1.138)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0303','Cameron','Downing','8428892481','07/09/1950 13:38:39',0.771)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0263','Logan','Downing','4784350561','02/13/1973 13:38:39',0.107)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0217','Carter','Shelly','2217373921','10/08/1926 13:38:39',0.735)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0364','Logan','Gautam','1755519001','12/26/1968 13:38:39',0.666)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0285','Reagan','Peruvemba','6597500625','04/29/1973 13:38:39',0.219)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0269','Logan','Ybarra','5236114321','02/29/1968 13:38:39',0.497)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0386','Reagan','Quintero','2219980801','05/29/1975 13:38:40',0.412)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0313','Carter','Downing','9597924961','08/24/1961 13:38:39',0.338)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0195','Ryan','Peruvemba','1445900625','09/19/1969 13:38:39',0.482)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0201','Cameron','Balakrishnan','1632240801','09/26/1972 13:38:39',0.257)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0408','Cameron','Tourigny','2771026329','05/22/1974 13:38:39',0.586)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0234','Harper','Gautam','2998219536','11/12/1961 13:38:39',0.447)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0283','Reagan','Downing','6414247921','04/21/1966 13:38:39',0.181)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0389','Reagan','Ybarra','2289804504','03/19/1973 13:38:39',0.179)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0573','Micah','Downing','1077999322','10/09/1973 13:38:40',0.646)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0356','Jayden','Quintero','1606201369','02/26/1948 13:38:40',0.378)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0496','Ryan','Quintero','6052387225','02/13/1972 13:38:39',0.138)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0446','Hunter','Quintero','3956757505','09/02/1973 13:38:40',0.366)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0241','Hunter','Balakrishnan','3373402561','11/29/1971 13:38:39',0.828)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0445','Hunter','Peruvemba','3921390062','08/30/1973 13:38:40',0.646)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0412','Carter','Chiluvuri','2881302553','06/01/1974 13:38:39',0.766)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0493','Ryan','Downing','5907281640','02/07/1974 13:38:39',0.389)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0463','Logan','Downing','4595406816','09/17/1964 13:38:40',1.096)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0464','Logan','Gautam','4635236761','01/04/1973 13:38:39',0.510)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0559','Jayden','Ybarra','9764437536','09/22/1962 13:38:40',2.288)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0438','Harper','Tourigny','3680412033','09/19/1973 13:38:39',0.874)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0481','Reagan','Balakrishnan','5352791232','01/12/1973 13:38:39',0.262)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0128','Dylan','Tourigny','5352791232','10/11/1972 13:38:38',0.572)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0504','Cameron','Gautam','6452412825','03/13/1973 13:38:39',0.143)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0508','Cameron','Tourigny','6659702809','03/26/1972 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0586','Reagan','Quintero','1179208128','10/23/1964 13:38:40',0.551)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0561','Logan','Balakrishnan','9904930784','10/07/1969 13:38:39',1.391)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0474','Micah','Gautam','5047930497','12/28/1972 13:38:39',0.452)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0521','Dylan','Balakrishnan','7368021648','05/09/1971 13:38:39',0.165)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0482','Reagan','Chiluvuri','5397444097','01/15/1975 13:38:39',0.268)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0526','Dylan','Quintero','7654960897','12/21/1944 13:38:39',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0494','Ryan','Gautam','5955356929','05/09/1970 13:38:40',0.757)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0439','Harper','Ybarra','3714138384','09/18/1963 13:38:39',0.205)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0522','Dylan','Chiluvuri','7424753025','05/12/1964 13:38:39',0.351)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0469','Logan','Ybarra','4838284152','01/30/1958 13:38:39',0.328)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0444','Hunter','Gautam','3886260249','10/05/1962 13:38:39',0.743)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0404','Cameron','Gautam','2663946265','08/16/1971 13:38:39',0.730)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0460','Logan','Badwe','4477456000','12/16/1972 13:38:39',0.323)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0510','Carter','Badwe','6765201000','04/03/1973 13:38:39',0.583)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0499','Ryan','Ybarra','6200149800','02/24/1974 13:38:39',0.187)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0530','Harper','Badwe','7890481000','06/02/1958 13:38:39',0.254)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0582','Reagan','Chiluvuri','1147339481','12/30/1960 13:38:39',0.391)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0548','Hunter','Tourigny','9018249241','08/12/1974 13:38:39',0.192)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0425','Dylan','Peruvemba','3262539062','07/18/1966 13:38:39',0.564)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0519','Carter','Ybarra','7255534832','05/04/1973 13:38:39',0.107)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0475','Micah','Peruvemba','5090664062','01/02/1929 13:38:39',0.254)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0505','Cameron','Peruvemba','6503775062','03/15/1942 13:38:39',0.744)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0596','Ryan','Quintero','1261784066','10/31/1964 13:38:40',0.962)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0533','Harper','Downing','8070655992','06/19/1974 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0543','Hunter','Downing','8693593280','07/23/1972 13:38:39',0.532)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0555','Jayden','Peruvemba','9487940062','09/07/1972 13:38:39',0.422)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0417','Carter','Shelly','3023738432','06/21/1971 13:38:39',0.773)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0414','Carter','Gautam','2937658881','06/11/1974 13:38:39',0.692)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0562','Logan','Chiluvuri','9975743233','09/29/1960 13:38:40',1.021)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0448','Hunter','Tourigny','4028209561','10/19/1972 13:38:39',0.682)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0560','Logan','Badwe','9834496000','09/23/1969 13:38:40',0.270)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0616','Carter','Quintero','1439868559','06/02/1973 13:38:40',0.127)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0513','Carter','Downing','6925792256','07/02/1971 13:38:40',0.324)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0595','Ryan','Peruvemba','1253337006','03/01/1961 13:38:39',0.255)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0625','Dylan','Peruvemba','1525878906','06/30/1974 13:38:40',0.434)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0518','Carter','Tourigny','7199776897','05/01/1974 13:38:39',0.256)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0524','Dylan','Gautam','7539197977','12/11/1969 13:38:39',0.455)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0471','Micah','Balakrishnan','4921342928','02/11/1973 13:38:39',0.196)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0502','Cameron','Chiluvuri','6350601601','03/04/1972 13:38:39',0.237)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0660','Logan','Badwe','1897473600','11/13/1970 13:38:40',0.759)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0470','Micah','Badwe','4879681000','02/03/1974 13:38:39',0.142)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0678','Micah','Tourigny','2113093798','11/13/1970 13:38:40',0.496)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0557','Jayden','Shelly','9625444200','09/19/1936 13:38:39',0.398)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0473','Micah','Downing','5005466544','12/27/1926 13:38:39',0.735)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0511','Carter','Balakrishnan','6818417664','09/21/1964 13:38:39',0.161)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0466','Logan','Quintero','4715672833','12/20/1972 13:38:39',0.252)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0534','Harper','Gautam','8131394433','06/23/1971 13:38:39',0.454)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0607','Cameron','Shelly','1357546656','11/02/1969 13:38:40',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0628','Dylan','Tourigny','1555387394','07/05/1974 13:38:40',0.509)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0537','Harper','Shelly','8315668016','07/07/1974 13:38:39',0.167)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0570','Micah','Badwe','1055600100','10/08/1968 13:38:40',0.167)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0447','Hunter','Shelly','3992363648','12/05/1973 13:38:39',0.258)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0563','Logan','Downing','1004693469','10/14/1970 13:38:39',0.520)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0799','Ryan','Ybarra','4075558368','11/17/1969 13:38:40',0.319)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0578','Micah','Tourigny','1116121190','12/11/1974 13:38:39',0.497)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0477','Micah','Shelly','5176944584','01/05/1973 13:38:39',0.207)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0487','Reagan','Shelly','5624913456','01/22/1969 13:38:39',0.407)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0459','Jayden','Ybarra','4438648376','12/13/1976 13:38:39',0.446)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0651','Jayden','Balakrishnan','1796072876','11/10/1972 13:38:40',0.427)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0476','Micah','Quintero','5133668377','03/06/1972 13:38:40',0.217)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0437','Harper','Shelly','3646915896','09/13/1963 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0503','Cameron','Downing','6401355408','03/08/1973 13:38:39',0.206)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0556','Jayden','Quintero','9556506649','09/12/1973 13:38:39',0.527)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0554','Jayden','Gautam','9419743105','09/14/1971 13:38:40',0.431)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0546','Hunter','Quintero','8887314945','08/06/1974 13:38:39',0.229)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0486','Reagan','Quintero','5578855041','01/20/1974 13:38:39',0.248)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0506','Cameron','Quintero','6555443329','03/17/1972 13:38:39',0.253)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0416','Carter','Quintero','2994837913','06/19/1951 13:38:39',0.153)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0485','Reagan','Peruvemba','5533080062','04/10/1969 13:38:40',0.198)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0495','Ryan','Peruvemba','6003725062','02/11/1973 13:38:39',0.260)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0580','Reagan','Badwe','1131649600','12/16/1967 13:38:39',0.601)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0568','Logan','Tourigny','1040862453','11/01/1965 13:38:39',0.703)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0590','Ryan','Badwe','1211736100','12/09/1957 13:38:40',0.238)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0478','Micah','Tourigny','5220493825','03/14/1953 13:38:40',0.233)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0564','Logan','Gautam','1011850652','10/15/1973 13:38:39',0.597)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0569','Logan','Ybarra','1048211851','10/07/1972 13:38:40',0.686)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0449','Hunter','Ybarra','4064296320','12/05/1966 13:38:39',0.284)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0491','Ryan','Balakrishnan','5812004856','04/30/1970 13:38:40',0.933)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0528','Dylan','Tourigny','7772051865','05/27/1971 13:38:39',0.580)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0403','Cameron','Downing','2637668328','04/28/1973 13:38:39',0.115)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0584','Reagan','Gautam','1163191951','01/05/1951 13:38:39',0.234)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0507','Cameron','Shelly','6607418840','03/23/1973 13:38:39',0.078)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0515','Carter','Peruvemba','7034430062','04/17/1971 13:38:39',0.655)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0489','Reagan','Ybarra','5717885264','01/29/1943 13:38:39',0.560)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0451','Jayden','Balakrishnan','4137196680','11/03/1964 13:38:39',0.839)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0657','Jayden','Shelly','1863208592','09/22/1968 13:38:40',0.236)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0525','Dylan','Peruvemba','7596914062','08/05/1968 13:38:40',0.215)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0509','Cameron','Ybarra','6712296456','04/01/1967 13:38:39',0.658)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0583','Reagan','Downing','1155245323','01/01/1972 13:38:39',0.166)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0527','Dylan','Shelly','7713339744','05/24/1971 13:38:39',0.400)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0538','Harper','Tourigny','8377782913','07/07/1976 13:38:39',0.443)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0472','Micah','Chiluvuri','4963271065','02/17/1971 13:38:39',0.528)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0520','Dylan','Badwe','7311616000','05/06/1971 13:38:39',0.133)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0512','Carter','Chiluvuri','6871947673','04/09/1971 13:38:39',0.123)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0490','Ryan','Badwe','5764801000','01/31/1962 13:38:39',0.447)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0611','Carter','Balakrishnan','1393685690','05/10/1971 13:38:40',0.280)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0585','Reagan','Peruvemba','1171179506','04/09/1970 13:38:39',0.867)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0549','Hunter','Ybarra','9084256280','08/13/1967 13:38:39',0.695)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0552','Jayden','Chiluvuri','9284452761','08/23/1948 13:38:39',0.197)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0581','Reagan','Balakrishnan','1139474287','12/26/1956 13:38:39',0.855)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0498','Ryan','Tourigny','6150598401','02/18/1969 13:38:39',0.526)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0722','Dylan','Chiluvuri','2717370086','11/16/1970 13:38:40',2.420)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0430','Harper','Badwe','3418801000','08/18/1975 13:38:39',0.364)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0589','Reagan','Ybarra','1203541802','02/02/1972 13:38:39',0.278)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0541','Hunter','Balakrishnan','8566216776','07/18/1973 13:38:39',0.219)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0516','Carter','Quintero','7089225753','07/13/1973 13:38:40',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0480','Reagan','Badwe','5308416000','01/10/1968 13:38:39',0.207)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0551','Jayden','Balakrishnan','9217356720','09/08/1971 13:38:40',0.365)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0535','Harper','Peruvemba','8192475062','06/30/1932 13:38:39',0.741)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0593','Ryan','Downing','1236570192','10/29/1937 13:38:40',1.159)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0501','Cameron','Balakrishnan','6300150200','03/03/1959 13:38:39',1.138)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0492','Ryan','Chiluvuri','5859498009','02/04/1969 13:38:39',0.666)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0514','Carter','Gautam','6979952641','07/08/1975 13:38:40',0.412)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0536','Harper','Quintero','8253899161','07/01/1974 13:38:39',0.586)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0411','Carter','Balakrishnan','2853430424','05/31/1966 13:38:39',0.181)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0517','Carter','Shelly','7144340952','04/28/1973 13:38:39',0.179)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0701','Cameron','Balakrishnan','2414749428','11/18/1973 13:38:40',0.646)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0484','Reagan','Gautam','5487587353','04/06/1948 13:38:40',0.378)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0624','Dylan','Gautam','1516136693','06/24/1970 13:38:40',0.600)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0574','Micah','Gautam','1085544345','10/12/1973 13:38:40',0.366)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0540','Hunter','Badwe','8503056000','07/11/1974 13:38:39',0.766)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0621','Dylan','Balakrishnan','1487189808','06/14/1969 13:38:40',0.330)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0591','Ryan','Balakrishnan','1219972169','10/27/1964 13:38:40',1.096)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0592','Ryan','Chiluvuri','1228250152','02/13/1973 13:38:39',0.510)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0687','Reagan','Shelly','2227547369','11/01/1962 13:38:40',2.288)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0566','Logan','Quintero','1026279667','10/29/1973 13:38:39',0.874)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0609','Cameron','Ybarra','1375527161','05/03/1970 13:38:40',0.263)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0632','Harper','Chiluvuri','1595395317','07/15/1972 13:38:40',0.401)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0636','Harper','Quintero','1636170140','05/10/1976 13:38:40',0.674)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0714','Carter','Gautam','2598919616','12/02/1964 13:38:40',0.551)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0689','Reagan','Ybarra','2253600278','11/03/1969 13:38:40',0.222)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0602','Cameron','Chiluvuri','1313366592','04/07/1974 13:38:39',1.072)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0649','Hunter','Ybarra','1774102824','09/02/1971 13:38:40',0.704)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0610','Carter','Badwe','1384584100','05/06/1971 13:38:40',0.284)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0654','Jayden','Gautam','1829409766','09/14/1973 13:38:40',0.177)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0622','Dylan','Chiluvuri','1496792294','06/18/1970 13:38:40',0.757)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0567','Logan','Shelly','1033551771','10/28/1963 13:38:39',0.205)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0650','Jayden','Badwe','1785062500','09/04/1973 13:38:40',0.605)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0597','Ryan','Shelly','1270273752','03/10/1958 13:38:39',0.328)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0572','Micah','Chiluvuri','1070493698','11/14/1962 13:38:39',0.743)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0588','Reagan','Tourigny','1195389135','01/26/1973 13:38:39',0.170)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0638','Harper','Tourigny','1656848179','08/05/1972 13:38:40',0.233)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0627','Dylan','Shelly','1545504106','03/16/1945 13:38:40',1.390)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0658','Jayden','Tourigny','1874578252','09/22/1965 13:38:40',0.696)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0710','Carter','Badwe','2541168100','11/24/1950 13:38:40',0.721)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0676','Micah','Quintero','2088270645','10/14/1970 13:38:40',1.893)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0553','Jayden','Downing','9351914448','08/27/1966 13:38:39',0.564)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0647','Hunter','Shelly','1752334948','08/27/1974 13:38:40',0.886)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0603','Cameron','Downing','1322115048','04/11/1975 13:38:40',0.198)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0633','Harper','Downing','1605516747','07/20/1970 13:38:40',0.362)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0724','Dylan','Gautam','2747604789','12/10/1964 13:38:40',0.962)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0661','Logan','Balakrishnan','1908999602','09/25/1951 13:38:40',1.781)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0683','Reagan','Downing','2176119871','10/24/1943 13:38:40',0.845)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0545','Hunter','Peruvemba','8822385062','07/31/1971 13:38:39',0.773)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0542','Hunter','Chiluvuri','8629728769','07/21/1974 13:38:39',0.692)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0690','Ryan','Badwe','2266712100','11/08/1960 13:38:40',1.021)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0576','Micah','Quintero','1100753141','11/28/1972 13:38:39',0.682)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0688','Reagan','Tourigny','2240545423','11/02/1969 13:38:40',0.270)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0744','Hunter','Gautam','3064021032','12/13/1963 13:38:40',0.227)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0641','Hunter','Balakrishnan','1688231961','08/11/1971 13:38:40',0.324)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0723','Dylan','Downing','2732456074','12/07/1960 13:38:40',0.261)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0753','Jayden','Downing','3214992060','12/17/1965 13:38:40',0.325)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0646','Hunter','Quintero','1741526438','08/23/1963 13:38:40',1.222)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0652','Jayden','Chiluvuri','1807134108','09/13/1970 13:38:40',0.930)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0599','Ryan','Ybarra','1287381576','03/23/1973 13:38:39',0.196)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0630','Harper','Badwe','1575296100','07/11/1971 13:38:40',0.247)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0788','Reagan','Tourigny','3855714511','12/23/1970 13:38:40',0.759)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0598','Ryan','Tourigny','1278806208','03/14/1974 13:38:39',0.142)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0806','Cameron','Quintero','4220269324','12/23/1970 13:38:40',0.496)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0685','Reagan','Peruvemba','2201721006','10/27/1974 13:38:40',1.394)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0601','Cameron','Balakrishnan','1304661624','04/02/1971 13:38:39',0.238)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0639','Harper','Ybarra','1667260390','08/07/1964 13:38:40',0.457)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0662','Logan','Chiluvuri','1920578035','09/28/1974 13:38:40',0.496)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0735','Harper','Peruvemba','2918430506','12/12/1969 13:38:40',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0756','Jayden','Quintero','3266533992','12/17/1966 13:38:40',0.337)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0665','Logan','Peruvemba','1955629506','09/15/1972 13:38:40',0.871)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0698','Ryan','Tourigny','2373677376','11/17/1968 13:38:40',0.167)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0575','Micah','Peruvemba','1093128906','11/25/1972 13:38:39',0.591)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0691','Ryan','Balakrishnan','2279881053','11/10/1974 13:38:40',0.347)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0927','Dylan','Shelly','7384463302','12/27/1969 13:38:40',0.319)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0706','Cameron','Quintero','2484384460','11/20/1953 13:38:40',0.190)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0605','Cameron','Peruvemba','1339743006','04/18/1972 13:38:40',0.725)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0615','Carter','Peruvemba','1430541506','01/04/1973 13:38:40',0.483)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0587','Reagan','Shelly','1187277957','01/22/1977 13:38:39',0.446)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0779','Micah','Ybarra','3682559992','12/20/1972 13:38:40',0.427)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0604','Cameron','Gautam','1330907138','04/15/1972 13:38:40',0.217)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0565','Logan','Peruvemba','1019046006','10/23/1963 13:38:39',0.299)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0631','Harper','Balakrishnan','1585321819','07/13/1970 13:38:40',0.197)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0684','Reagan','Gautam','2188892367','10/27/1971 13:38:40',0.375)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0682','Reagan','Chiluvuri','2163403353','10/24/1971 13:38:40',0.431)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0674','Micah','Gautam','2063666841','10/10/1969 13:38:40',0.742)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0614','Carter','Gautam','1421259840','05/24/1970 13:38:40',0.238)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0634','Harper','Gautam','1615686259','07/26/1973 13:38:40',0.455)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0544','Hunter','Gautam','8757811609','07/29/1951 13:38:39',0.153)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0613','Carter','Downing','1412023413','05/20/1969 13:38:40',0.198)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0623','Dylan','Downing','1506441206','06/22/1968 13:38:40',2.329)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0708','Cameron','Tourigny','2512655976','11/23/1971 13:38:40',0.089)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0696','Ryan','Quintero','2346588610','11/13/1977 13:38:40',0.645)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0718','Carter','Tourigny','2657649945','01/18/1958 13:38:40',0.238)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0606','Cameron','Quintero','1348622796','04/23/1953 13:38:40',0.233)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0692','Ryan','Chiluvuri','2293107304','11/11/1973 13:38:40',0.479)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0697','Ryan','Shelly','2360103844','11/16/1972 13:38:40',0.686)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0577','Micah','Shelly','1108417190','12/10/1974 13:38:39',0.612)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0619','Carter','Ybarra','1468123519','06/09/1970 13:38:40',0.933)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0656','Jayden','Quintero','1851890728','09/20/1974 13:38:40',1.258)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0531','Harper','Balakrishnan','7950200552','06/07/1973 13:38:39',0.115)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0712','Carter','Chiluvuri','2569922191','11/28/1967 13:38:40',0.808)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0635','Harper','Peruvemba','1625904006','07/29/1967 13:38:40',0.334)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0643','Hunter','Downing','1709400756','08/18/1972 13:38:40',0.240)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0617','Carter','Shelly','1449241147','06/04/1971 13:38:40',0.496)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0579','Micah','Ybarra','1123865280','12/13/1964 13:38:39',0.839)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0785','Reagan','Peruvemba','3797332506','12/20/1972 13:38:40',0.209)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0653','Jayden','Downing','1818246352','09/14/1968 13:38:40',0.215)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0637','Harper','Shelly','1646484813','08/01/1966 13:38:40',0.218)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0711','Carter','Balakrishnan','2555514814','11/27/1974 13:38:40',0.127)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0655','Jayden','Peruvemba','1840624506','09/18/1970 13:38:40',0.381)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0666','Logan','Quintero','1967419251','10/04/1963 13:38:40',0.346)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0600','Cameron','Badwe','1296000000','03/28/1971 13:38:39',0.528)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0648','Hunter','Tourigny','1763193692','07/12/1937 13:38:40',0.305)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0640','Hunter','Badwe','1677721600','08/09/1969 13:38:40',0.246)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0618','Carter','Tourigny','1458659417','06/07/1969 13:38:40',0.816)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0739','Harper','Ybarra','2982481466','12/13/1967 13:38:40',0.238)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0713','Carter','Downing','2584390401','11/29/1973 13:38:40',0.340)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0677','Micah','Shelly','2100654722','10/15/1974 13:38:40',0.371)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0680','Reagan','Badwe','2138137600','10/21/1966 13:38:40',0.205)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0709','Cameron','Ybarra','2526881877','11/24/1971 13:38:40',0.686)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0626','Dylan','Quintero','1535667993','07/02/1968 13:38:40',0.264)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0850','Jayden','Badwe','5220062500','12/26/1970 13:38:40',2.420)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0558','Jayden','Tourigny','9694754049','09/27/1975 13:38:39',0.364)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0717','Carter','Shelly','2642874999','12/02/1950 13:38:40',0.335)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0669','Logan','Ybarra','2003108487','10/08/1967 13:38:40',0.502)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0644','Hunter','Gautam','1720059496','08/22/1973 13:38:40',0.259)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0608','Cameron','Tourigny','1366514728','05/01/1966 13:38:40',0.197)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0679','Micah','Ybarra','2125588036','10/18/1971 13:38:40',0.365)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0663','Logan','Downing','1932209057','10/01/1975 13:38:40',0.536)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0721','Dylan','Balakrishnan','2702346652','12/08/1937 13:38:40',1.159)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0629','Dylan','Ybarra','1565318008','07/09/1958 13:38:40',0.238)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0620','Dylan','Badwe','1477633600','06/11/1966 13:38:40',0.968)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0642','Hunter','Chiluvuri','1698791628','08/17/1975 13:38:40',0.412)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0664','Logan','Gautam','1943892828','10/01/1956 13:38:40',1.461)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0539','Harper','Ybarra','8440245144','07/10/1966 13:38:39',0.181)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0645','Hunter','Peruvemba','1730768006','08/22/1955 13:38:40',1.162)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0829','Dylan','Ybarra','4723001920','12/24/1976 13:38:40',0.880)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0612','Carter','Chiluvuri','1402832079','05/16/1948 13:38:40',0.378)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0752','Jayden','Chiluvuri','3197947740','12/17/1969 13:38:40',0.364)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0702','Cameron','Chiluvuri','2428557824','11/21/1973 13:38:40',0.366)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0668','Logan','Tourigny','1991158581','10/04/1967 13:38:40',0.441)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0749','Hunter','Ybarra','3147221220','12/15/1969 13:38:40',0.358)
GO
INSERT INTO dbo.Patients (Id,GivenName,FamilyName,Phone,Birthday,DiabetesPedigree) VALUES('0719','Carter','Ybarra','2672486755','12/06/1964 13:38:40',1.096)
GO
As shown below:
Embedded script below:
PatientTable.sql
Run ProviderTable.sql
CREATE TABLE [dbo].[Providers] (
[Id] [char](4) NULL,
[Reference] [varchar](20) NULL,
[Phone] [char](10) NULL
) ON [PRIMARY]
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('4367','Seattle','8328169886')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('1981','Kirkland','7774159141')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('1429','Edmonds','2918076589')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('2065','Esperance','8805624625')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('2015','Bothel','8181353375')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('6722','Redmond','3037354790')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('1771','Kent','5554637011')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('3341','Bellevue','3729318082')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('1701','Lake Forest Park','4921675101')
GO
INSERT INTO dbo.Providers (Id,Reference,Phone) VALUES('5330','Everett','1514194370')
GO
As shown below:
Embedded script below:
ProviderTable.sql
Upload HDInsight sample data into Azure blob storage
The Azure Storage Explorer can be used to manage blob storage content. Add the storage account to the program.
The Azure Storage Explorer is an open source utility that allows the user to perform operations on Azure storage resources.
This utility can be downloaded from http://azurestorageexplorer.codeplex.com/
The documentation is located here http://azurestorageexplorer.codeplex.com/documentation
An alternate utility "Microsoft Azure Storage Explorer" can also be used. It can be downloaded from http://storageexplorer.com/
Embedded diabetes measurements data file below:
The connection information for a storage account can be accessed using the "Manage Access Keys" link on the Azure portal -> Storage page (below).
Click the container to open the container. Click Upload, select the file and click ok. The file will then be uploaded into Azure blob storage
Connect SQL Server to Azure Blob Storage
Enable the traceflag for using a database-scoped credential
TSql Script (cut/paste):
DBCC TRACEON(4631,-1);
As shown below:
Set the master key encryption password
TSql Script (cut/paste):
CREATE MASTER KEY ENCRYPTION BY PASSWORD='<Password>';
As shown below:
Create a credential to allow SQL Server to access the storage account
TSql Script (cut/paste):
CREATE DATABASE SCOPED CREDENTIAL <Credential Name> WITH IDENTITY='<Name>', SECRET='<Storage Account Key>';
As shown below:
Create an external data source to access the storage account
TSql Script (cut/paste):
CREATE EXTERNAL DATA SOURCE <Data Source Name>
WITH (
TYPE = HADOOP,
LOCATION = 'wasb://<Container Name>@<Storage Account Name>.blob.core.windows.net/',
CREDENTIAL = <Credential Name>
);
As shown below:
Define the file format
Define the format
TSql Script (cut/paste):
CREATE EXTERNAL FILE FORMAT <Format Name>
WITH (
FORMAT_TYPE = DELIMITEDTEXT,
FORMAT_OPTIONS (FIELD_TERMINATOR = ','
)
);
As shown below:
Connect an external table to the data file
Create an external table
TSql Script (cut/paste):
CREATE EXTERNAL TABLE <Table Name>
(
<Field Name> <Data Type>,
<Field Name> <Data Type>
)
WITH (
LOCATION='<Path To File>',
DATA_SOURCE = <Data Source Name>,
FILE_FORMAT = <Format Name>,
REJECT_TYPE = VALUE,
REJECT_VALUE = 0
);
As shown below:
Query the data
Call list for patient's whose last measurement was between specific dates
TSql Script (cut/paste):
SELECT
MAX(Patients.GivenName) AS GivenName,
MAX(Patients.FamilyName) AS FamilyName,
MAX(Patients.Phone) AS Phone,
MAX(Measures.Date) AS LastMeasurementDate,
Patients.Id
FROM (SELECT * FROM Measurements WHERE (Date BETWEEN '01/01/2015' AND '04/01/2016')) AS Measures
INNER JOIN Patients ON Measures.PatientId = Patients.Id
GROUP BY Patients.Id
As shown below:
Average glucose level measurement by provider for 2015
TSql Script (cut/paste):
SELECT
Providers.Id,
Providers.Reference,
AVG(Measures.GlucoseLevel) AS AverageGlucoseLevel
FROM (SELECT * FROM Measurements WHERE Date BETWEEN '01/01/2015' AND '12/31/2015') AS Measures
INNER JOIN Providers ON Measures.ProviderId = Providers.Id
GROUP BY Providers.Id, Providers.Reference
As shown below:
Highest glucose measurement by provider
TSql Script (cut/paste):
SELECT
Providers.Id,
Providers.Reference,
MAX(Measurements.GlucoseLevel) AS HighestGlucoseMeasurement
FROM Providers
INNER JOIN Measurements ON Providers.Id = Measurements.ProviderId
GROUP BY Providers.Id, Providers.Reference
As shown below:
References
|
PolyBase |
|
|
HDInsight |
|
|
Power BI |
