compare_cbcl

library(compareDF)

Registered S3 method overwritten by 'dplyr':
  method           from
  print.rowwise_df     

library(arsenal)

table1 <- read.csv("C:\\Users\\alucic2\\Documents\\cbcl1.csv", stringsAsFactors = FALSE) # reading cbcl1 table 
table2 <- read.csv("C:\\Users\\alucic2\\Documents\\cbcl2.csv", stringsAsFactors = FALSE) #reading cbcl2

comp <- compare_df(table1, table2, c("id")) # how are the two entries different?

Creating comparison table...

|========================================  | 96% ~0 s remaining     
|========================================  | 96% ~0 s remaining     
|========================================  | 97% ~0 s remaining     
|========================================  | 97% ~0 s remaining     
|========================================= | 98% ~0 s remaining     
|========================================= | 98% ~0 s remaining     
|========================================= | 99% ~0 s remaining     
|========================================= | 99% ~0 s remaining     
|========================================= |100% ~0 s remaining     
|==========================================|100% ~0 s remaining     

Truncating HTML diff table to 100 rows...
Loading required namespace: htmlTable
Registered S3 methods overwritten by 'htmltools':
  method               from         
  print.html           tools:rstudio
  print.shiny.tag      tools:rstudio
  print.shiny.tag.list tools:rstudio
Registered S3 method overwritten by 'htmlwidgets':
  method           from         
  print.htmlwidget tools:rstudio
Creating HTML table for first 100 rows

print(comp$comparison_df)

comp$html_output #print the summary of differences

id	chng_type	formdt	date	X1	X2	X3	X4	X5	X6	X7	X8	X9	X10	X11	X12	X13	X14	X15	X16	X17	X18	X19	X20	X21	X22	X23	X24	X25	X26	X27	X28	X29	X30	X31	X32	X33	X34	X35	X36	X37	X38	X39	X40	X41	X42	X43	X44	X45	X46	X47	X48	X49	X50	X51	X52	X53	X54	X55	X56	X57	X58	X59	X60	X61	X62	X63	X64	X65	X66	X67	X68	X69	X70	X71	X72	X73	X74	X75	X76	X77	X78	X79	X80	X81	X82	X83	X84	X85	X86	X87	X88	X89	X90	X91	X92	X93	X94	X95	X96	X97	X98	X99	X100
203	+	12/13/2016	6/20/2017	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
203	-	12/13/2016	9/8/2017	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
204	+	12/9/2016	6/20/2017	1	0	1	1	1	1	1	1	0	1	1	0	1	0	1	1	1	1	0	1	1	0	1	0	1	0	1	0	1	1	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	2	0	0	0	0	1	0	0	0	1	0	0	1	1	0	0	0	0	0	0	2	1	0	0	1	1	0	0	1	0	0	0	0	0	0	1	1	1	1	0	0
204	-	12/9/2017	7/14/2017	1	0	1	1	1	1	1	1	0	1	1	0	1	0	1	1	1	1	0	1	1	0	1	0	1	0	1	0	1	1	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	2	0	0	0	0	1	0	0	0	1	0	0	1	1	0	0	0	0	0	0	2	1	0	0	1	1	0	0	1	0	0	0	0	0	0	1	1	1	1	0	0
206	+	1/15/2017	6/20/2017	0	0	0	0	0	1	1	2	1	1	1	0	0	0	1	2	0	0	0	1	1	0	1	0	0	0	1	0	1	0	0	1	0	1	0	1	0	1	0	0	0	1	0	0	0	0	0	1	1	1	0	0	0	1	0	1	0	1	1	0	0	1	0	1	1	0	0	0	1	0	0	0	0	0	0	1	1	0	0	1	1	1	0	0	0	1	0	1	0	0	1	0	0	0	1	1	2	0	0	0
206	-	1/15/2017	7/14/2016	0	0	0	0	0	1	1	2	1	1	1	0	0	0	1	2	0	0	0	1	1	0	1	0	0	0	1	0	1	0	0	1	0	1	0	1	0	1	0	0	0	1	0	0	0	0	0	1	1	1	0	0	0	1	0	1	0	1	1	0	0	1	0	1	1	0	0	0	1	0	0	0	0	0	0	1	1	0	0	1	1	1	0	0	0	1	0	1	0	0	1	0	0	0	1	1	2	0	0	0
207	+	12/6/2016	6/20/2017	0	0	0	0	0	1	0	2	0	0	1	2	1	0	2	2	0	0	0	1	0	0	1	2	0	0	1	0	2	2	0	1	1	0	0	1	0	1	0	0	0	0	0	1	1	0	0	0	0	1	0	2	0	0	0	0	0	2	0	0	2	0	0	1	1	2	0	0	0	0	0	0	0	0	0	1	0	0	0	0	2	1	1	0	2	0	0	1	0	0	0	0	1	0	0	2	1	0	0	0
207	-	12/6/2016	7/14/2017	0	0	0	0	0	1	0	2	0	0	1	2	1	0	2	2	0	0	0	1	0	0	1	2	0	0	1	0	2	2	0	1	1	0	0	1	0	1	0	0	0	0	0	1	1	0	0	0	0	1	0	2	0	0	0	0	0	2	0	0	2	0	0	1	1	2	0	0	0	0	0	0	0	0	0	1	0	0	0	0	2	1	1	0	2	0	0	1	0	0	0	0	1	0	0	2	1	0	0	0
218	+	1/30/2017	6/20/2017	0	0	0	0	0	1	0	1	0	991	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
218	-	1/30/2017	7/14/2017	0	0	0	0	0	1	0	1	0	991	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
222	+	2/12/2017	6/20/2017	0	0	1	0	1	1	2	2	1	1	1	0	0	0	1	2	0	0	0	1	0	0	1	1	0	0	1	1	1	1	0	0	0	1	0	1	1	1	0	1	0	1	0	1	0	0	0	0	0	1	0	0	0	1	0	1	0	1	1	0	1	0	0	1	0	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	1	0	0	0	1	1	0	1	0	1	0	0	0	0	0	1	1	0	0	0
222	-	2/12/2017	7/14/2017	0	0	1	0	1	1	2	2	1	1	1	0	0	0	1	2	0	0	0	1	0	0	1	1	0	0	1	1	1	1	0	0	0	1	0	1	1	1	0	1	0	1	0	1	0	0	0	0	0	1	0	0	0	1	0	1	0	1	1	0	1	0	0	1	0	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	1	0	0	0	1	1	0	1	0	1	0	0	0	0	0	1	1	0	0	0
223	+	NO DATE	6/20/2017	0	0	0	0	0	0	1	2	1	1	0	0	0	0	1	2	0	0	0	1	1	0	1	0	0	0	1	0	1	1	0	1	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
223	-	9/17/1902	7/14/2017	0	0	0	0	0	0	1	2	1	1	0	0	0	0	1	2	0	0	0	1	1	0	1	0	0	0	1	0	1	1	0	1	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
225	+	2/6/2017	6/20/2017	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	991	0	0	0	0	0	0	0	0	0	0	0	0	0	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991
225	-	2/6/2017	7/14/2017	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	991	0	0	0	0	0	0	0	0	0	0	0	0	0	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991
230	+	2/16/2017	6/20/2017	1	0	1	1	1	991	0	0	0	1	1	1	1	0	1	1	991	0	0	0	0	2	1	0	0	0	1	0	0	0	0	1	0	0	0	0	0	1	0	1	0	0	0	1	0	0	1	0	0	0	0	1	0	0	0	0	0	1	1	0	1	0	0	1	0	1	0	0	0	1	1	1	1	1	0	1	1	0	0	0	1	1	0	2	1	0	0	1	1	1	1	0	0	1	1	2	1	1	0	0
230	-	2/16/2017	7/14/2017	1	0	1	1	1	991	0	0	0	1	1	1	1	0	1	1	0	0	0	0	0	2	1	0	0	0	1	0	0	0	0	1	0	0	0	0	0	1	0	1	0	0	0	1	0	0	1	0	0	0	0	1	0	0	0	0	0	1	1	0	1	0	0	1	0	1	0	0	0	1	1	1	1	1	0	1	1	0	0	0	1	1	0	2	1	0	0	1	1	1	1	0	0	1	1	2	1	1	0	0
235	+	1/29/2017	6/23/2017	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
235	-	1/29/2017	7/14/2017	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
236	+	2/7/2017	6/23/2017	0	0	0	0	1	1	0	1	1	1	1	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	1	0	1	0	0	0	0	0	1	1	0	0	0	0	2	0	0	0	0	0	1	0	0	0	0	2	0	0	0	0	1	1	1	0	0	1	0	0	1	0	0	0	0	1	0	0	0	2	0	0	2	1	0	0	1	0	0	0	0	0	1	1	1	1	0	0	0
236	-	2/7/2017	7/14/2017	0	0	0	0	1	1	0	1	1	1	1	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	1	0	1	0	0	0	0	0	1	1	0	0	0	0	2	0	0	0	0	0	1	0	0	0	0	2	0	0	0	0	1	1	1	0	0	1	0	0	1	0	0	0	0	1	0	0	0	1	0	0	2	1	0	0	1	0	0	0	0	0	1	1	1	1	0	0	0
238	+	2/12/2017	6/23/2017	0	0	0	0	1	1	0	1	0	0	0	0	0	0	1	1	0	0	0	1	0	1	1	0	0	0	0	0	0	0	0	1	0	0	0	1	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0
238	-	2/12/2017	7/14/2017	0	0	0	0	1	1	0	1	0	0	0	0	0	0	1	1	0	0	0	1	0	1	1	0	0	0	0	0	0	0	0	1	0	0	0	1	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0
241	+	NO DATE	6/23/2017	0	0	1	1	1	1	1	1	1	1	1	0	1	0	1	1	0	0	1	1	1	0	1	1	1	1	1	1	1	1	0	1	1	0	0	1	0	1	0	1	0	0	1	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	1	1	0	1	1	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	1	0	0	1	1	1	0	1	0	0	0	1	0	0	0	1	1	0	1	0
241	-	9/17/1902	7/14/2017	0	0	1	1	1	1	1	1	1	1	1	0	1	0	1	1	0	0	1	1	1	0	1	1	1	1	1	1	1	1	0	1	1	0	0	1	0	1	0	1	0	0	1	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	1	1	0	1	1	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	1	0	0	1	1	1	0	1	0	0	0	1	0	0	0	1	1	0	1	0
242	+	1/30/2017	6/23/2017	0	0	0	0	0	0	0	1	0	0	0	0	1	0	1	1	0	1	0	1	0	0	0	1	0	0	1	0	1	1	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	1	1	0	0	1	0	0	0	0	0	0	2	0	0	0	0	1	0	0	0	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
242	-	1/30/2017	7/14/2017	0	0	0	0	0	0	0	1	0	0	0	0	1	0	1	1	0	1	0	1	0	0	0	1	0	0	1	0	1	1	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	1	1	0	0	1	0	0	0	0	0	0	2	0	0	0	0	1	0	0	0	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
245	+	3/30/2017	6/23/2017	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
245	-	3/30/2017	7/14/2017	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
248	+	2/22/2017	6/23/2017	0	0	0	0	0	1	0	1	0	0	1	1	1	0	1	1	0	1	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	0	1	1	0	0	0	0	0	0	0	1	0	1	0	0	0	1	1	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0
248	-	2/22/2017	7/14/2017	0	0	0	0	0	1	0	1	0	0	1	1	1	0	1	1	0	1	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	0	1	1	0	0	0	0	0	0	0	1	0	1	0	0	0	1	1	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0
255	+	2/2/2017	6/23/2017	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
255	-	2/2/2017	7/14/2017	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
256	+	2/9/2017	6/27/2017	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
256	-	2/9/2017	7/14/2017	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
257	+	2/4/2017	6/27/2017	0	0	1	0	1	1	1	1	1	1	0	0	2	0	1	0	0	0	0	0	2	2	0	0	0	0	1	1	0	0	0	0	1	1	0	1	1	2	991	1	0	0	0	0	991	0	0	991	0	1	0	0	0	0	0	0	0	1	1	0	1	1	0	2	0	1	0	0	0	0	0	0	0	0	0	0	0	991	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	0	1	1	0	0	0
257	-	2/4/2017	7/14/2017	0	0	1	0	1	1	1	1	1	1	0	0	2	0	1	0	0	0	0	0	2	2	0	0	0	0	1	1	0	0	0	0	1	1	0	1	1	2	991	1	0	0	0	0	0	0	0	991	0	1	0	0	0	0	0	0	0	1	1	0	1	1	0	2	0	1	0	0	0	0	0	0	0	0	0	0	0	991	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	0	1	1	0	0	0
259	+	1/29/2017	6/27/2017	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	1	0	0	1	0	0	1	0	0	0
259	-	1/29/2017	7/14/2017	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	1	0	0	1	0	0	1	0	0	0
260	+	5/30/2017	9/11/2017	1	0	1	0	1	1	0	1	1	1	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0
260	-	5/30/2017	7/14/2017	1	0	1	0	1	1	0	1	1	1	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0
262	+	2/23/2017	6/27/2017	0	0	1	0	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	2	1	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	2	0	0	0	1	0	0	1	1	0	0	0	0	0	0	0	1	0	0	1	1	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0
262	-	2/23/2017	7/14/2017	0	0	1	0	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	2	1	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	2	0	0	0	1	0	0	1	1	0	0	0	0	0	0	0	1	0	0	1	1	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0
268	+	3/15/2017	6/27/2017	0	0	0	1	0	1	0	2	1	1	1	0	1	0	1	1	1	1	0	1	1	2	1	1	0	0	1	0	1	1	0	0	1	1	0	2	0	2	0	1	0	0	1	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	0	2	1	1	0	0	1	0	0	1	1	1	0	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0
268	-	3/15/2017	7/14/2017	0	0	0	1	0	1	0	2	1	1	1	0	1	0	1	1	1	1	0	1	1	2	1	1	0	0	1	0	1	1	0	0	1	1	0	2	0	2	0	1	0	0	1	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	0	2	1	1	0	0	1	0	0	1	1	1	0	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0
269	+	3/26/2017	6/27/2017	0	0	1	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	991	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
269	-	3/26/2017	7/14/2017	0	0	1	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
274	+	3/21/2017	6/27/2017	0	0	1	1	1	1	0	1	0	1	1	0	0	0	1	1	0	0	0	1	0	2	1	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0
274	-	3/21/2017	7/19/217	0	0	1	1	1	1	0	1	0	1	1	0	0	1	1	0	0	0	1	0	1	2	1	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0
275	+	NO DATE	6/27/2017	0	0	2	0	1	0	0	0	0	1	0	0	2	0	1	1	0	0	0	1	1	2	1	1	0	0	0	0	2	1	0	2	2	2	0	2	1	1	0	1	0	1	0	1	0	0	1	1	1	2	0	0	0	1	0	0	0	0	1	0	1	1	0	2	2	2	0	2	1	0	0	0	1	0	0	0	0	0	0	0	2	0	2	0	2	1	1	1	0	0	0	2	0	1	1	2	2	0	0	0
275	-	No Date	7/19/2017	0	0	2	0	1	0	0	0	0	1	0	0	2	0	1	1	0	0	0	1	1	2	1	1	0	0	0	0	2	1	0	2	2	2	0	2	1	1	0	1	0	1	0	1	0	0	1	1	1	2	0	0	0	1	0	0	0	0	1	0	1	1	0	2	2	2	0	2	1	0	0	0	1	0	0	0	0	0	0	0	2	0	2	0	2	1	1	1	0	0	0	2	0	1	1	2	2	0	0	0
276	+	NO DATE	6/27/2017	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	1	0	1	2	0	0	1	0	2	2	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0
276	-	No Date	7/19/2017	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	1	0	1	2	0	0	1	0	2	2	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0
277	+	2/20/2017	6/27/2017	0	0	1	0	1	0	2	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	1	1	0	1	0	1	0	1	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	1	2	0	0	0	0	0	0	0	0	0	1	0	0	1	1	0	0	1	0	0	0	0	1	0	0	0	1	2	0	1	0	0	0	0	0	0	0	0	0	0	0	0
277	-	2/20/2017	7/21/2017	0	0	1	0	1	0	2	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	1	1	0	1	0	1	0	1	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	1	2	0	0	0	0	0	0	0	0	0	1	0	0	1	1	0	0	1	0	0	0	0	1	0	0	0	1	2	0	1	0	0	0	0	0	0	0	0	0	0	0	0
282	+	NO DATE	9/11/2017	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
282	-	No Date	7/21/2017	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
283	+	6/6/2017	6/30/2017	0	0	0	0	0	0	0	2	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991	991
283	-	6/6/2017	7/21/2017	0	0	0	0	0	0	0	2	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990	990
285	+	4/20/2017	6/30/2017	0	0	1	1	0	0	0	1	0	1	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	1	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
285	-	4/20/2017	7/21/2017	0	0	1	1	0	0	0	1	0	1	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	1	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
288	+	4/29/2017	9/11/2017	0	0	1	1	0	0	0	1	1	1	1	0	1	0	0	1	0	0	0	1	1	0	1	0	0	0	0	0	1	1	1	1	0	1	0	1	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0
288	-	4/29/2017	9/8/2017	0	0	1	1	0	0	0	1	1	1	1	0	1	0	0	1	0	0	0	1	1	0	1	0	0	0	0	0	1	1	1	1	0	1	0	1	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0
289	+	6/4/2017	6/30/2017	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
289	-	6/4/2017	7/21/2017	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
290	+	7/5/2017	9/11/2017	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	0	1	1	1	1	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0
290	-	7/5/2017	9/6/2017	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	0	1	1	1	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0
291	+	6/25/2017	9/11/2017	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0
291	-	No Date	7/21/2017	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0
295	+	4/25/2017	6/30/2017	0	0	1	0	1	0	0	0	1	0	0	0	0	0	1	0	1	0	0	0	1	0	0	0	0	0	2	0	0	1	0	1	0	0	0	1	1	0	0	1	0	0	0	1	0	1	0	1	1	0	0	0	0	1	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	1	0	1	0	0	0	0	1	0	0	0	1	1	0	0	1	0	0	0	0	0	1	0	0	1	0	1	1	0	0	0
295	-	4/25/2017	7/21/2017	0	0	1	0	1	0	0	0	1	0	0	0	0	0	1	0	1	0	0	0	1	0	0	0	0	0	2	0	0	1	0	1	0	0	0	1	1	0	0	1	0	0	0	1	0	1	0	1	1	0	0	0	0	1	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	1	0	1	0	0	0	0	1	0	0	0	1	1	0	0	1	0	0	0	0	0	1	0	0	1	0	1	1	0	0	0
296	+	4/30/2017	6/30/2017	1	0	0	0	1	1	0	1	2	1	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	2	0	1	0	0	0	2	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	2	0	0	0	0	1	0	0	0	0	1	0	1	1	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0
296	-	4/30/2017	7/21/2017	1	0	0	0	1	1	0	1	2	1	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	2	0	1	0	0	0	2	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	2	0	0	0	0	1	0	0	0	0	1	0	1	1	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0
299	+	4/25/2017	6/30/2017	1	0	0	1	0	1	1	1	1	1	0	0	0	0	2	1	1	1	0	1	1	1	0	0	0	0	0	0	1	1	0	1	1	1	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	1	0	0	0	1	0	0	1	0	0	0	1	0	0	1	0	0	0	1	0	1	0	1	1	0	1	1	1	1	0	0	0	1	0	0	0	0	1	0	0	0	0
299	-	6/25/2017	7/21/2017	1	0	0	1	0	1	1	1	1	1	0	0	0	0	2	1	1	1	0	1	1	1	0	0	0	0	0	0	1	1	0	1	1	1	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	1	0	0	0	1	0	0	1	0	0	0	1	0	0	1	0	0	0	1	0	1	0	1	1	0	1	1	1	1	0	0	0	1	0	0	0	0	1	0	0	0	0
300	+	7/19/2017	9/11/2017	0	0	0	0	0	2	1	2	0	1	0	0	2	0	2	2	1	0	0	1	1	2	0	0	0	0	0	0	1	1	0	0	1	0	0	2	1	2	0	0	0	0	0	1	0	0	0	1	0	1	0	0	0	1	0	0	0	0	1	0	0	0	0	2	0	2	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	1	2	2	0	1	0	0	0	0	0	2	0	2	2	0	0	0
300	-	7/19/2017	9/8/2017	0	0	0	0	0	2	1	2	0	1	0	0	2	0	2	2	1	0	0	1	1	2	0	0	0	0	0	0	1	1	0	0	1	0	0	2	1	2	0	0	0	0	0	1	0	0	0	1	0	1	0	0	0	1	0	0	0	0	1	0	0	0	0	2	0	2	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	1	2	2	0	1	0	0	0	0	0	1	0	2	2	0	0	0
301	+	6/15/2017	9/1/2017	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	1	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	2	0	0	0	0	1	1	0	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0
301	-	6/15/2017	7/21/2017	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	1	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	2	0	0	0	0	1	1	0	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0
306	+	6/30/2017	9/11/2017	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
306	-	6/30/2017	9/8/2017	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
307	+	6/27/2017	9/11/2017	0	0	0	0	0	1	0	0	1	1	0	0	0	1	0	1	0	1	1	0	1	0	0	1	0	0	0	1	0	1	1	1	0	0	1	0	1	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0
307	-	6/27/2017	7/21/2017	0	0	0	0	0	1	0	1	1	0	0	0	1	0	1	0	1	1	0	1	0	0	1	0	0	0	1	0	1	1	1	0	0	1	0	1	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0
309	+	6/15/2017	9/11/2017	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
309	-	6/15/2017	7/21/2017	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
312	+	6/30/2017	9/11/2017	0	0	0	0	0	0	0	1	1	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
312	-	6/30/2017	9/8/2017	0	0	0	0	0	0	0	1	1	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0
313	+	7/19/2017	9/11/2017	0	1	2	1	1	1	1	1	1	2	2	0	1	0	0	1	0	0	0	1	2	2	1	0	0	0	0	0	1	2	0	0	0	0	0	0	1	1	0	1	0	1	0	1	0	0	0	0	0	1	1	0	0	1	0	0	0	1	1	0	0	0	0	1	1	0	0	0	0	0	0	0	1	0	0	0	1	0	1	0	1	1	0	1	1	1	1	1	0	0	0	1	0	1	0	2	2	0	0	0
313	-	7/9/2017	9/8/2017	0	1	2	1	1	1	1	1	1	2	2	0	1	0	0	1	0	0	0	1	2	2	1	0	0	0	0	0	1	2	0	0	0	0	0	0	1	1	0	1	0	1	0	1	0	0	0	0	0	1	1	0	0	1	0	0	0	1	1	0	0	0	0	1	1	0	0	0	0	0	0	0	1	0	0	0	1	0	1	0	1	1	0	1	1	1	1	1	0	0	0	1	0	1	0	2	2	0	0	0
314	+	6/9/2017	9/11/2017	0	0	0	1	1	1	0	1	1	1	0	0	0	0	1	0	0	0	0	1	0	1	1	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	0	1	0	0	0	1	0	0	0	0	0	1	0	1	0	1	0	0	0	0	1	0	0	0	0	1	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0
314	-	6/9/2017	7/21/2017	0	0	0	1	1	1	0	1	1	1	0	0	0	0	1	0	0	0	0	1	0	1	1	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	0	1	0	0	0	1	0	0	0	0	0	1	0	1	0	1	0	0	0	0	1	0	0	0	0	1	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0
315	+	6/11/2017	9/11/2017	1	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	1	0	1	0	0	0	2	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	1	1	0	0	0	1	0	0	0	0	0	0	0	0
315	-	6/11/2017	7/21/2017	1	0	0	0	0	0	1	0	1	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	1	0	1	0	0	0	2	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	1	1	0	0	0	1	0	0	0	0	0	0	0	0
316	+	6/21/2017	9/11/2017	0	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	1	1	0	0	1	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
316	-	6/21/2017	7/21/2017	0	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	1	1	0	0	1	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
317	+	8/4/2017	9/11/2017	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	1	0	0	0	1	0	2	0	1	0	0	0	0	0	1	0	1	0	1	0	2	0	2	0	1	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	1	1	0	1	0	0	1	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	1	0	0	1	2	0	1	0	0	0
317	-	No Date	9/8/2017	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	1	0	0	0	1	0	2	0	1	0	0	0	0	0	1	0	1	0	1	0	2	0	2	0	1	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	1	1	0	1	0	0	1	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	1	0	0	1	2	0	1	0	0	0
318	+	7/14/2017	9/11/2017	0	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
318	-	7/14/2017	9/19/2017	0	0	0	0	0	0	1	1	1	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

comp_summary <- summary(comparedf(table1, table2, by = "id"))
print(comp_summary) # prints out the summary of differences as a table

Summary of data.frames

version	arg	ncol	nrow
x	table1	103	220
y	table2	103	219

NA

Summary of overall comparison

statistic	value
Number of by-variables	1
Number of non-by variables in common	102
Number of variables compared	102
Number of variables in x but not y	0
Number of variables in y but not x	0
Number of variables compared with some values unequal	102
Number of variables compared with all values equal	0
Number of observations in common	217
Number of observations in x but not y	3
Number of observations in y but not x	2
Number of observations with some compared variables unequal	209
Number of observations with all compared variables equal	8
Number of values unequal	538

NA

Variables not shared

No variables not shared

NA

Other variables not compared

No other variables not compared

NA

Observations not shared

version	id	observation
x	429	1
x	518	205
x	520	206
y	465	128
y	595	200

NA

Differences detected by variable

var.x	var.y	n	NAs
formdt	formdt	29	0
date	date	204	0
X1	X1	1	0
X2	X2	2	0
X3	X3	1	0
X4	X4	2	0
X5	X5	2	0
X6	X6	1	0
X7	X7	2	0
X8	X8	5	0
X9	X9	2	0
X10	X10	3	0
X11	X11	2	0
X12	X12	3	0
X13	X13	4	0
X14	X14	3	0
X15	X15	5	0
X16	X16	5	0
X17	X17	3	0
X18	X18	1	0
X19	X19	3	0
X20	X20	4	0
X21	X21	6	0
X22	X22	1	0
X23	X23	5	0
X24	X24	4	0
X25	X25	2	0
X26	X26	1	0
X27	X27	4	0
X28	X28	2	0
X29	X29	4	0
X30	X30	7	0
X31	X31	3	0
X32	X32	3	0
X33	X33	3	0
X34	X34	4	0
X35	X35	3	0
X36	X36	5	0
X37	X37	3	0
X38	X38	5	0
X39	X39	2	0
X40	X40	5	0
X41	X41	2	0
X42	X42	3	0
X43	X43	3	0
X44	X44	2	0
X45	X45	2	0
X46	X46	2	0
X47	X47	1	0
X48	X48	2	0
X49	X49	1	0
X50	X50	2	0
X51	X51	1	0
X52	X52	2	0
X53	X53	1	0
X54	X54	4	0
X55	X55	1	0
X56	X56	1	0
X57	X57	2	0
X58	X58	3	0
X59	X59	5	0
X60	X60	3	0
X61	X61	5	0
X62	X62	3	0
X63	X63	2	0
X64	X64	5	0
X65	X65	4	0
X66	X66	2	0
X67	X67	2	0
X68	X68	2	0
X69	X69	2	0
X70	X70	3	0
X71	X71	1	0
X72	X72	2	0
X73	X73	4	0
X74	X74	2	0
X75	X75	1	0
X76	X76	1	0
X77	X77	1	0
X78	X78	1	0
X79	X79	3	1
X80	X80	3	1
X81	X81	6	1
X82	X82	4	1
X83	X83	4	1
X84	X84	5	1
X85	X85	8	1
X86	X86	3	1
X87	X87	3	1
X88	X88	7	1
X89	X89	5	1
X90	X90	2	1
X91	X91	3	1
X92	X92	2	1
X93	X93	3	1
X94	X94	5	1
X95	X95	2	1
X96	X96	5	1
X97	X97	7	1
X98	X98	5	1
X99	X99	2	1
X100	X100	6	1

NA

Differences detected (488 not shown)

var.x	var.y	id	values.x	values.y	row.x	row.y
formdt	formdt	204	12/9/2016	12/9/2017	3	83
formdt	formdt	223	NO DATE	9/17/1902	209	1
formdt	formdt	241	NO DATE	9/17/1902	210	2
formdt	formdt	275	NO DATE	No Date	211	206
formdt	formdt	276	NO DATE	No Date	212	207
formdt	formdt	282	NO DATE	No Date	213	208
formdt	formdt	291	6/25/2017	No Date	39	209
formdt	formdt	299	4/25/2017	6/25/2017	27	38
formdt	formdt	313	7/19/2017	7/9/2017	49	43
formdt	formdt	317	8/4/2017	No Date	52	210
date	date	203	6/20/2017	9/8/2017	4	4
date	date	204	6/20/2017	7/14/2017	3	83
date	date	206	6/20/2017	7/14/2016	5	5
date	date	207	6/20/2017	7/14/2017	2	3
date	date	218	6/20/2017	7/14/2017	8	8
date	date	222	6/20/2017	7/14/2017	15	15
date	date	223	6/20/2017	7/14/2017	209	1
date	date	225	6/20/2017	7/14/2017	12	12
date	date	230	6/20/2017	7/14/2017	17	17
date	date	235	6/23/2017	7/14/2017	6	6
X1	X1	561	0	1	208	205
X2	X2	457	0	1	118	117
X2	X2	485	1	0	131	131
X3	X3	485	0	1	131	131
X4	X4	511	0	1	150	139
X4	X4	567	1	0	171	170
X5	X5	432	1	0	105	93
X5	X5	567	0	1	171	170
X6	X6	485	1	0	131	131
X7	X7	485	0	1	131	131
X7	X7	567	1	0	171	170
X8	X8	307	0	1	40	39
X8	X8	336	1	0	53	51
X8	X8	485	1	0	131	131
X8	X8	566	0	1	165	164
X8	X8	567	0	1	171	170
X9	X9	380	1	0	63	61
X9	X9	566	0	1	165	164
X10	X10	307	1	0	40	39
X10	X10	432	1	0	105	93
X10	X10	614	0	2	190	189
X11	X11	218	1	2	8	8
X11	X11	485	0	1	131	131
X12	X12	432	0	2	105	93
X12	X12	485	1	0	131	131
X12	X12	566	1	0	165	164
X13	X13	307	0	1	40	39
X13	X13	380	0	1	63	61
X13	X13	485	0	1	131	131
X13	X13	566	1	0	165	164

NA

Non-identical attributes

No non-identical attributes

NA