MATH 216 Homework 1

Admistrative:

Please indicate

Who you collaborated with: Me, Myself, and Albert Kim. (office hours on Tuesday Oct 4th.)
Roughly how much time you spent on this HW so far: Likely three or four hours. I sped up as I practiced more throughout the week.
The URL of the RPubs published URL here.
What gave you the most trouble: The month function. Understanding conceptually what was happening with the grouping function and what variables to use.
Any comments you have: I would like the homework to be worth more percentage points for our grades because they are where the learning happens. Or the class excercises being worth something. Incentives.

Question 1:

Plot a “time series” of the proportion of flights that were delayed by > 30 minutes on each day. i.e.

the x-axis should be some notion of time
the y-axis should be the proportion.

Using this plot, indicate describe the seasonality of when delays over 30 minutes tend to occur.

date2	num_flights_30
07	2792
06	2528
05	2319
04	2193
03	2095
12	2063
08	1793
01	1716
02	1668
10	1497
11	1415
09	1394

date2	num_flights	num_flights_30	proportion_flight_delayed
01	18910	1716	0.0907456
02	17128	1668	0.0973844
03	19470	2095	0.1076014
04	18593	2193	0.1179476
05	19172	2319	0.1209576
06	19600	2528	0.1289796
07	20548	2792	0.1358770
08	20176	1793	0.0888680
09	18065	1394	0.0771658
10	18696	1497	0.0800706
11	18021	1415	0.0785195
12	19117	2063	0.1079144

Question 2:

Some people prefer flying on older planes. Even though they aren’t as nice, they tend to have more room. Which airlines should these people favor?

## Source: local data frame [15 x 2]
## 
##    carrier mean_years
##      <chr>      <dbl>
## 1       AA   1986.675
## 2       AS   2005.554
## 3       B6   2006.080
## 4       CO   2001.137
## 5       DL   1990.240
## 6       EV   2004.586
## 7       F9   2003.878
## 8       FL   2002.110
## 9       MQ   1981.579
## 10      OO   2004.983
## 11      UA   1996.365
## 12      US   1991.922
## 13      WN   1997.943
## 14      XE   2000.442
## 15      YV   2003.886

Question 3:

What states did Southwest Airlines’ flight paths tend to fly to?
What states did Southwest Airlines’ flights tend to fly to?

For example, Southwest Airlines Flight 60 to Dallas consists of a single flight path, but since it flew 299 times in 2013, it would be counted as 299 flights.

#lets first join airports and flights to find states SW flies to. 
sw_join <- full_join(airports, flights, by=c("iata"="dest"))

#dataset with only SouthWest airline flights and no NAs. 
sw_flights <- sw_join %>% 
  filter(!is.na(flight)) %>% 
  filter((carrier == "WN")) 

sw_tot <- sw_flights %>% 
  select(flight) %>% 
  tally() %>% 
  rename(tot_sw = n)

#find state where flight paths tend to fly to (so dont group by destination)
sw_fp <- sw_flights %>% 
  group_by(flight, state) %>% 
  tally() %>% 
  rename(flight_dest = n)
   # head(10) %>%
  #  format(big.mark = ",") %>%
    knitr::kable(sw_fp)

flight	state	flight_dest
1	CO	35
1	FL	12
1	MS	56
1	NJ	1
1	TX	137
2	TX	256
3	FL	25
3	MS	20
3	NM	1
3	TX	210
3	NA	9
4	TN	1
4	TX	263
5	AL	30
5	CA	2
5	FL	63
5	LA	27
5	NM	22
5	OK	41
5	PA	2
5	TX	12
6	FL	1
6	TX	261
7	AL	24
7	FL	128
7	MO	31
7	MS	32
7	TX	25
8	CA	1
8	TX	276
9	AL	59
9	CA	3
9	FL	72
9	LA	3
9	MO	31
9	NM	4
9	OK	1
9	TX	102
10	TX	61
11	AL	34
11	FL	56
11	LA	38
11	MO	3
11	PA	59
11	SC	35
11	TN	1
11	TX	62
12	TX	294
14	TX	87
15	FL	4
15	MO	1
15	NV	54
15	SC	34
15	TX	120
15	NA	90
16	TX	301
17	FL	1
17	PA	5
18	FL	5
18	LA	7
18	TX	12
19	FL	30
19	LA	1
19	MS	1
19	SC	60
19	TX	29
19	NA	138
20	TX	293
21	FL	38
21	LA	10
21	NA	25
22	TX	15
23	FL	1
23	LA	59
23	NV	3
23	PA	41
23	SC	31
23	TN	30
23	TX	71
24	TX	288
25	TX	9
26	TX	1
27	IL	30
27	TN	25
27	TX	204
27	NA	12
28	TX	297
29	TX	28
29	NA	26
30	TX	298
31	AZ	33
31	FL	47
31	NM	30
31	TN	41
31	TX	89
31	NA	30
32	TX	283
33	CA	29
33	FL	33
33	IL	38
33	MO	30
33	TX	10
33	NA	59
34	OK	1
34	TX	297
35	CO	34
35	FL	57
35	LA	43
35	OK	58
35	TN	1
35	TX	39
35	NA	42
36	TX	301
37	FL	59
37	IL	29
37	LA	65
37	PA	67
37	TN	9
37	TX	1
37	NA	25
38	LA	1
38	TX	298
39	AZ	29
39	FL	41
39	OK	9
39	PA	20
39	TN	71
39	TX	92
39	NA	36
40	TX	310
41	CA	59
41	CO	1
41	PA	35
41	TN	30
41	TX	73
41	NA	24
42	TX	297
43	CO	24
43	FL	110
43	LA	5
43	MO	9
43	NV	29
43	TX	59
44	SC	1
44	TX	296
45	FL	131
45	LA	1
45	MD	92
45	NV	25
45	PA	9
46	CA	1
46	TX	297
47	AL	9
47	CA	1
47	FL	64
47	MD	80
47	PA	1
47	TN	3
47	TX	89
48	TX	298
49	FL	97
49	MD	59
49	OK	1
49	TX	41
49	NA	33
50	TX	300
51	FL	172
51	TX	90
51	NA	39
52	TX	303
53	CA	5
53	CO	4
53	TX	6
53	NA	1
54	TX	10
55	FL	22
55	MS	1
55	TX	267
56	TX	291
58	TX	171
60	TX	299
61	LA	6
62	TX	1
63	TX	1
64	IL	1
100	LA	1
101	FL	1
102	AR	10
102	CO	1
102	FL	1
102	IL	1
102	TX	1
103	CA	1
103	TX	7
104	MO	9
104	NJ	7
104	NM	24
104	TX	35
105	AR	42
105	FL	1
106	FL	1
106	TX	5
107	TX	3
108	CA	2
109	CO	1
110	IL	1
110	LA	10
110	TX	1
111	FL	1
111	OK	5
112	CA	5
112	NJ	22
112	TX	1
113	CA	41
113	NM	1
113	TN	34
114	OK	7
114	TX	1
117	NJ	1
117	OK	34
117	TX	1
118	NV	1
118	OK	9
118	TX	9
119	IL	2
121	OK	1
122	CA	38
122	TN	8
123	CA	1
123	TX	35
124	FL	4
124	MO	30
125	AZ	30
125	OK	59
125	TX	6
126	FL	1
127	CA	1
127	MO	1
127	OK	24
127	TX	1
129	IL	34
131	CO	28
131	TX	3
132	NA	1
135	FL	1
135	IL	1
135	TX	1
136	CA	25
136	LA	1
139	AL	1
139	TX	10
141	AL	1
143	MO	1
143	TX	1
144	TX	1
146	TX	7
148	IL	1
148	TN	34
148	TX	1
149	NV	41
149	TX	1
150	CA	9
150	MS	1
150	TX	3
153	AZ	1
153	TN	22
153	TX	2
155	TX	34
156	TX	1
157	FL	1
157	MD	1
158	AZ	1
159	FL	1
159	NA	6
162	SC	1
164	CA	60
164	FL	1
165	CA	2
165	TN	1
165	TX	30
166	LA	1
167	CO	1
167	LA	30
167	NV	1
168	TX	7
169	IL	24
169	MS	9
170	CO	22
170	TX	6
171	OK	29
173	OK	8
175	AZ	1
175	TX	16
176	CA	6
176	TX	3
177	CA	1
177	IL	23
177	TX	7
178	TX	2
179	FL	29
179	NV	1
181	CO	1
181	NV	3
181	TX	5
182	MS	1
183	AR	30
183	AZ	9
183	FL	1
184	IL	25
184	MO	1
184	TX	7
185	FL	5
186	MS	3
187	FL	10
188	TX	2
190	TN	5
195	TX	25
196	OK	1
197	CA	25
197	TX	9
198	AZ	1
198	FL	3
198	IL	59
198	LA	7
198	NV	9
198	TN	30
199	CA	1
199	TN	58
199	TX	7
200	LA	1
200	MD	1
200	OK	1
200	TX	1
201	AZ	34
201	CA	58
201	FL	117
201	PA	1
201	TX	32
203	MD	7
203	TN	3
206	IL	1
206	OK	30
207	TX	40
208	LA	31
209	NM	1
210	CO	1
210	FL	1
212	LA	7
213	LA	67
214	FL	40
214	TX	59
215	AZ	24
215	MO	38
215	TX	6
216	MS	1
216	NM	7
217	CA	25
217	FL	7
217	OK	1
218	AL	2
218	CO	1
218	LA	9
218	TX	22
220	TX	3
221	IL	10
221	TX	1
222	SC	10
224	TX	10
226	NV	33
226	TX	1
228	CA	38
228	TX	1
229	CA	7
230	MS	59
230	TX	1
231	AL	30
231	LA	24
231	OK	1
231	TX	5
233	IL	1
234	CO	1
234	MS	32
235	TX	1
236	NV	1
236	TX	1
237	CA	9
237	FL	28
237	TX	10
239	CO	35
239	MS	9
240	FL	3
240	IL	1
240	LA	1
240	NV	5
240	OK	2
241	CA	1
241	SC	1
242	TN	28
242	TX	3
243	AZ	49
243	OK	25
243	TX	42
244	FL	1
244	OK	1
244	TX	8
245	NV	1
246	IL	1
246	MO	7
247	CO	7
247	SC	1
248	TX	11
249	IL	10
249	TX	30
252	PA	1
252	TN	1
253	TX	4
254	TN	58
255	CA	2
255	MS	34
255	TX	2
257	TX	3
258	FL	7
258	LA	23
259	NV	1
261	SC	40
261	TX	22
262	AZ	42
263	TX	39
264	FL	24
265	LA	9
267	CA	2
267	TX	59
269	FL	9
269	MS	23
269	NV	1
271	CA	1
272	OK	1
273	OK	33
274	FL	29
274	NV	6
274	TX	30
275	AZ	7
275	IL	4
275	TX	2
277	CA	22
277	TX	6
279	MD	1
280	LA	1
280	MO	23
280	OK	7
280	TX	9
284	TX	9
285	NM	22
285	OK	1
286	LA	30
287	CA	5
287	FL	30
287	LA	31
290	TX	2
291	FL	59
291	LA	31
293	MS	1
293	NJ	60
295	IL	1
295	TX	58
296	OK	2
297	AZ	9
297	FL	49
297	TX	25
299	FL	1
300	AZ	6
300	TX	32
301	CA	28
301	TX	3
301	NA	7
302	MD	1
303	CA	30
303	MD	1
303	TX	1
304	TX	1
305	LA	5
305	NV	32
307	TX	25
310	FL	1
310	NV	2
310	TX	6
312	FL	1
312	OK	1
312	TX	5
313	TX	34
314	OK	1
316	LA	59
316	TX	9
317	CO	9
317	TX	1
319	TX	10
321	TX	7
322	AZ	1
322	FL	2
322	SC	6
323	FL	24
323	MS	58
324	NM	1
324	NV	1
325	TX	33
326	OK	9
329	NV	31
329	TX	7
330	CA	2
332	FL	16
332	NM	58
332	TX	2
333	TX	1
333	NA	5
335	CA	20
335	MO	1
337	TX	5
338	OK	2
340	FL	22
341	AZ	10
342	SC	10
343	MO	1
345	AL	33
346	CO	5
347	MD	5
347	SC	1
347	TX	7
348	AZ	7
348	MO	6
349	LA	1
349	MD	33
350	FL	1
350	TX	10
351	TX	1
352	CA	60
352	SC	1
353	AZ	1
354	TX	1
355	MO	36
357	MD	1
358	AR	1
359	MO	20
359	TX	1
360	FL	5
361	CO	34
361	MO	1
361	TX	1
362	FL	1
362	LA	25
366	IL	2
366	OK	1
368	LA	1
369	FL	5
371	FL	1
372	MO	28
374	CA	1
374	MS	6
374	OK	31
376	FL	58
376	TX	5
377	SC	7
380	OK	3
382	NV	1
383	TX	8
384	CO	5
384	SC	7
385	MD	1
386	TX	38
388	TX	1
389	AR	2
389	CA	1
389	LA	3
389	TX	1
390	NV	1
392	LA	1
392	OK	4
392	TX	9
395	MO	33
396	CA	7
396	TX	1
397	IL	25
397	NA	1
399	CA	34
399	IL	2
399	TX	1
401	FL	38
402	FL	1
403	LA	1
403	PA	9
405	CO	20
405	TX	22
406	NV	29
409	TX	7
410	MO	1
410	TX	63
412	CA	8
412	NM	7
414	IL	1
414	TX	7
415	TX	1
417	CO	42
417	FL	1
417	NV	4
419	AZ	25
419	TX	12
420	IL	20
421	NM	6
421	TX	3
423	NV	1
423	TX	1
424	AZ	22
425	CA	9
425	TN	6
425	TX	3
426	NA	1
427	LA	2
428	AL	9
429	LA	1
429	SC	30
429	TX	36
434	TX	6
436	FL	8
437	IL	6
437	TX	7
438	FL	9
439	MD	31
441	AL	1
441	CO	1
441	MS	60
444	TX	1
444	NA	7
445	TX	33
446	LA	30
448	OK	1
450	NV	10
451	FL	29
451	TX	1
452	TX	6
453	CO	34
454	TX	1
455	AZ	30
455	IL	9
455	LA	1
457	MO	2
457	NM	10
459	NV	9
460	MS	2
460	TX	7
462	CA	59
462	PA	4
463	CA	6
463	PA	7
464	LA	38
464	MS	30
465	FL	5
465	LA	7
465	TX	59
466	LA	1
467	IL	1
467	OK	20
468	CA	22
468	TX	10
469	MD	9
469	OK	1
470	FL	1
470	MO	4
470	TX	5
471	FL	24
471	LA	7
471	NV	1
471	TX	30
473	AZ	59
473	FL	2
473	LA	1
473	MO	9
473	TX	1
476	LA	33
478	TN	30
479	TN	4
479	TX	14
480	TX	5
481	TX	7
484	CA	9
484	TX	7
485	TN	2
487	TX	1
489	TX	6
490	TX	5
491	CA	4
491	MO	58
491	TX	33
492	NM	35
492	TX	1
493	FL	1
494	OK	28
495	CO	29
495	TX	32
496	FL	25
496	IL	1
498	CA	7
500	LA	5
500	TX	29
502	FL	38
502	TX	1
504	LA	9
504	OK	30
505	NV	9
505	TX	1
506	IL	9
508	FL	1
508	NJ	1
509	CA	9
509	TN	30
511	TX	38
512	NV	58
513	OK	32
514	AZ	2
514	FL	1
515	TX	1
516	TN	1
517	IL	23
518	AZ	6
518	LA	6
519	MO	1
519	TX	1
521	FL	1
523	CA	7
525	MD	49
526	FL	32
526	NV	2
526	TX	1
527	LA	59
527	TX	1
528	AZ	1
530	CO	3
531	FL	6
531	MO	2
532	MO	8
533	NV	3
534	CA	28
537	TX	28
538	TX	1
539	LA	6
542	FL	1
542	LA	25
544	NJ	50
548	OK	5
549	AZ	1
550	TX	7
552	TX	10
553	LA	1
554	AZ	30
557	CO	1
557	FL	4
559	OK	24
561	TX	3
563	TX	33
564	TX	1
565	IL	28
565	TX	1
566	MD	1
566	TX	6
567	IL	1
570	NV	38
572	CA	2
574	AZ	7
575	TX	28
576	FL	49
576	TX	24
577	TX	6
578	CO	11
579	TX	25
580	IL	4
581	OK	22
581	TX	1
583	NV	34
583	SC	1
583	TN	33
584	TX	30
586	LA	35
586	TN	6
589	IL	9
589	NM	1
590	FL	1
591	TX	2
592	TX	49
593	FL	3
594	TX	3
594	NA	1
595	FL	3
597	IL	1
598	IL	1
598	LA	9
598	TX	22
599	TX	7
600	TX	1
601	FL	7
602	TX	41
603	FL	1
603	TX	4
604	OK	30
605	FL	2
607	CO	31
611	CO	25
611	TX	37
613	LA	1
614	NV	5
615	AZ	1
618	CA	50
618	TX	6
621	FL	1
621	LA	34
621	OK	30
621	TX	1
625	AR	30
625	LA	1
625	MD	51
627	TN	1
627	TX	5
628	MO	5
628	TX	30
629	TN	59
630	TX	34
632	TX	31
633	IL	7
633	LA	49
634	TX	5
635	AZ	4
636	AZ	7
639	LA	1
640	IL	22
643	CO	7
644	CA	1
648	LA	1
648	MO	20
650	CA	1
651	OK	7
653	MO	1
653	NV	49
658	TX	2
659	CO	9
659	IL	34
659	TX	1
662	NM	31
663	IL	29
663	OK	1
664	CA	1
664	TX	10
665	CO	9
667	FL	5
667	NV	28
668	LA	3
670	CO	5
670	MO	4
670	MS	1
670	NM	1
671	CO	30
674	FL	1
674	MS	3
674	NV	2
675	MO	1
676	AZ	9
676	IL	25
676	NV	38
676	TX	10
676	NA	5
677	MD	60
678	LA	33
679	OK	33
679	TX	2
680	TN	30
681	CA	38
682	IL	3
683	CA	8
683	LA	22
684	TN	1
690	AR	2
690	LA	10
690	TX	2
691	CA	1
692	MD	1
693	IL	6
693	OK	1
695	TX	1
696	TX	3
697	OK	1
698	TN	5
698	TX	34
702	CA	3
703	LA	33
704	AL	2
704	NV	6
706	CA	7
706	MD	7
706	MO	30
707	IL	5
707	OK	30
708	AL	1
708	CA	38
709	IL	49
709	OK	25
709	TX	24
710	IL	25
712	CO	30
713	NM	6
715	OK	59
717	IL	2
717	MS	8
718	FL	1
720	AZ	28
722	AR	5
723	FL	11
723	OK	1
726	NM	64
727	LA	9
730	FL	1
731	LA	38
732	TX	6
734	MD	30
735	TX	6
736	IL	3
736	OK	8
741	AR	33
741	OK	38
744	FL	3
744	TX	7
745	FL	1
745	IL	4
745	PA	1
745	TX	1
748	AL	6
748	FL	3
749	NA	5
752	CO	3
752	NV	30
753	MS	1
753	TX	4
754	LA	1
755	OK	1
756	MD	34
757	AZ	1
757	MD	22
757	TX	38
760	NV	59
762	CA	1
762	MD	9
763	NV	59
765	CO	7
766	CO	7
766	TN	1
766	TX	5
767	OK	5
769	NM	9
770	CO	50
770	TX	1
773	AL	33
773	TX	5
774	CA	4
776	NV	38
777	CA	3
778	CO	38
778	TX	9
779	TN	6
779	TX	1
780	TX	1
782	MO	24
783	CO	34
784	OK	4
785	MD	9
785	TX	1
786	MO	1
787	CA	33
787	NM	31
789	IL	25
791	TX	30
792	OK	6
793	TX	3
794	CA	60
794	FL	5
794	NV	40
795	CA	32
795	MD	9
796	MD	1
796	MO	25
798	TX	24
801	AR	1
801	CA	38
806	IL	38
806	TX	2
809	MD	1
811	NV	6
811	TX	1
814	CA	5
814	CO	2
815	CA	6
816	AZ	6
816	MD	5
816	TX	30
818	FL	5
819	TX	33
820	TX	1
823	TX	9
825	OK	4
827	CA	4
827	NJ	2
831	OK	1
832	CO	1
832	TX	1
833	FL	1
833	IL	31
833	TX	3
834	LA	59
836	CA	3
837	LA	41
838	FL	30
839	CA	3
841	FL	8
841	MS	9
843	CA	1
843	FL	1
843	NM	2
844	TX	3
846	TX	5
848	LA	30
848	OK	59
850	NM	5
850	TX	1
851	TX	7
853	LA	7
853	NV	1
854	TX	31
856	CO	3
856	LA	1
856	MD	30
859	LA	49
860	MS	2
861	OK	9
862	AZ	38
862	TX	1
863	AR	59
863	NM	29
863	OK	3
863	TX	5
864	TX	42
865	TN	7
865	TX	1
866	NV	1
867	LA	5
869	CA	9
869	MO	24
869	NV	30
871	FL	6
873	CA	5
873	FL	24
873	NV	29
876	NM	38
877	LA	32
878	LA	2
879	AL	42
880	IL	5
880	MO	1
881	NM	25
882	AZ	30
882	CO	5
885	AZ	2
887	TX	39
889	TX	2
893	AZ	6
894	NJ	8
895	MO	4
896	IL	7
897	FL	1
898	TX	6
899	LA	1
902	CA	22
903	OK	3
905	NM	7
906	TX	31
907	CA	23
907	NM	7
908	NJ	2
908	OK	1
912	TX	10
913	CA	41
914	CA	3
915	TX	53
916	CA	28
919	FL	7
919	TN	30
920	TX	1
922	TX	30
923	NA	6
924	LA	30
925	FL	10
926	FL	59
927	TX	1
928	MS	5
928	OK	9
931	FL	31
931	TN	24
931	TX	1
932	TX	49
933	CO	10
933	LA	1
934	MD	32
935	PA	10
935	TN	3
936	TX	2
937	IL	6
937	MS	5
938	CO	9
939	MO	58
939	TX	36
940	TX	5
941	TX	1
942	OK	9
944	IL	2
945	NM	5
945	OK	3
947	NJ	38
948	IL	59
949	FL	1
949	IL	31
950	CA	46
951	CO	1
952	MO	6
953	FL	22
954	FL	16
954	MD	2
955	AZ	28
955	OK	9
956	TX	6
958	IL	1
959	FL	7
963	IL	5
963	TN	38
964	MO	7
965	CA	4
966	CA	1
966	LA	10
968	IL	9
969	TX	9
970	FL	7
971	FL	59
972	CA	4
974	IL	1
974	TX	5
975	TN	31
976	TX	1
977	TN	10
978	LA	1
979	TX	3
980	MO	1
980	TX	9
981	TN	1
985	PA	59
986	NA	10
988	MS	23
989	IL	9
990	OK	59
994	LA	15
994	TX	29
996	TX	3
997	CA	33
999	FL	1
1002	CO	30
1003	IL	38
1003	NM	3
1005	TN	59
1007	IL	7
1008	FL	2
1009	NV	30
1013	FL	22
1013	NV	9
1014	LA	3
1014	NM	1
1014	TX	6
1015	FL	1
1016	FL	2
1016	IL	30
1016	LA	33
1016	TX	3
1019	MO	7
1021	TX	38
1022	AL	5
1022	LA	4
1022	OK	10
1023	LA	7
1023	TX	5
1024	TX	9
1025	FL	1
1025	NJ	9
1026	MD	1
1026	TN	4
1030	LA	7
1030	NV	5
1031	IL	1
1033	LA	6
1034	LA	29
1037	CA	2
1038	AL	1
1038	CO	25
1039	LA	1
1039	MS	6
1039	TX	59
1040	AZ	38
1042	TX	5
1045	MO	7
1046	CO	3
1046	LA	1
1047	TX	1
1050	MO	29
1053	CA	9
1053	PA	1
1054	CO	5
1054	TX	10
1055	IL	33
1056	OK	33
1057	CA	30
1058	FL	25
1058	LA	6
1060	OK	31
1062	CA	1
1062	MO	2
1062	NM	9
1067	TX	6
1069	MD	1
1069	NA	10
1070	TX	5
1072	NV	38
1076	CA	3
1076	NM	31
1079	PA	1
1079	TX	1
1080	TX	40
1081	OK	2
1082	IL	1
1082	MO	3
1082	NJ	30
1082	TX	1
1086	FL	2
1087	AZ	1
1091	FL	1
1091	TX	4
1093	CA	1
1093	MO	32
1093	TN	9
1094	IL	28
1094	LA	43
1094	MO	58
1095	TX	38
1098	AZ	29
1098	IL	2
1099	CA	30
1100	SC	29
1101	TX	6
1104	NV	29
1104	TX	50
1106	CA	1
1106	IL	41
1106	MD	38
1107	TN	1
1107	TX	9
1109	FL	5
1109	MD	7
1110	TX	5
1111	TX	9
1117	IL	5
1118	CA	7
1118	TX	4
1120	NM	4
1120	TX	6
1123	OK	2
1124	LA	31
1124	NV	4
1125	OK	1
1126	CO	3
1129	TX	1
1130	LA	7
1131	TX	6
1132	FL	10
1132	TX	5
1133	FL	5
1133	NV	1
1136	AZ	9
1137	TX	7
1139	CO	5
1139	TX	1
1140	FL	9
1140	TX	4
1144	TN	30
1145	LA	30
1146	CA	7
1147	SC	2
1147	TX	38
1148	IL	3
1148	OK	1
1149	TX	9
1150	MD	1
1151	IL	7
1153	TX	5
1154	MS	33
1158	NV	10
1159	IL	9
1159	NM	10
1160	NJ	7
1161	NV	3
1162	FL	3
1164	SC	31
1167	CA	31
1167	LA	67
1168	LA	1
1168	OK	24
1169	CO	6
1171	TX	5
1173	LA	1
1173	TX	4
1174	TN	3
1178	AZ	58
1178	TX	6
1179	FL	7
1179	LA	38
1179	TX	31
1180	FL	1
1180	MD	9
1181	AZ	3
1181	TX	2
1183	NM	29
1184	TX	5
1185	TX	30
1186	IL	40
1186	TN	1
1187	TX	7
1188	MD	31
1189	CA	1
1189	TX	1
1190	TX	9
1191	FL	22
1191	TX	60
1192	TX	2
1193	LA	1
1193	TX	9
1195	OK	1
1195	TX	9
1196	TX	1
1197	OK	32
1199	LA	3
1200	LA	9
1201	FL	9
1201	SC	1
1202	FL	49
1202	OK	6
1203	MS	5
1203	OK	6
1203	TX	2
1204	TX	31
1206	MS	3
1206	TX	5
1207	FL	5
1212	CA	30
1212	FL	38
1212	TX	58
1213	MD	31
1214	OK	38
1214	TX	1
1215	TX	9
1216	MD	5
1216	TN	1
1217	FL	3
1217	TN	7
1218	TX	1
1219	TN	1
1221	NV	6
1222	CA	58
1222	LA	34
1222	TN	35
1223	OK	53
1224	CA	5
1224	LA	22
1225	AL	3
1226	LA	9
1226	TX	9
1227	TN	32
1229	CO	58
1229	TX	3
1230	NV	2
1230	TX	1
1231	TX	36
1233	OK	25
1236	FL	5
1236	TX	1
1240	OK	58
1240	TN	1
1242	FL	1
1243	SC	9
1244	TN	7
1245	FL	1
1245	TX	1
1245	NA	1
1247	MS	6
1249	LA	25
1249	TX	1
1250	TX	5
1251	NM	1
1251	TN	9
1251	TX	7
1252	TX	2
1254	LA	22
1256	IL	35
1257	FL	1
1257	TX	10
1258	SC	8
1260	FL	6
1263	FL	5
1263	TX	1
1264	IL	3
1264	TN	3
1265	NV	10
1266	NM	2
1268	FL	7
1270	NM	24
1270	OK	40
1271	FL	33
1271	TX	7
1272	CA	34
1273	FL	1
1273	LA	7
1274	TX	11
1275	OK	9
1276	TX	30
1278	CA	1
1279	FL	1
1279	OK	3
1280	FL	7
1281	CA	1
1281	LA	7
1283	TX	60
1286	LA	38
1286	OK	2
1286	TX	9
1287	IL	7
1288	AL	29
1291	FL	1
1292	NV	9
1293	TX	5
1295	AL	3
1295	FL	1
1296	CA	3
1296	CO	1
1296	MO	38
1297	CA	9
1297	FL	1
1298	IL	7
1299	CA	1
1299	LA	7
1300	LA	30
1300	TX	42
1302	FL	5
1302	TX	4
1304	LA	1
1305	CA	9
1305	NV	6
1305	OK	39
1307	NV	1
1308	MO	3
1309	TX	2
1310	OK	31
1310	NA	6
1316	LA	3
1317	LA	6
1317	MO	40
1317	SC	5
1318	TX	1
1322	FL	1
1326	OK	6
1328	TX	3
1329	NA	1
1332	CO	38
1334	LA	35
1336	FL	2
1341	TX	1
1343	AL	29
1344	TX	29
1345	AL	1
1346	TX	9
1347	CA	1
1347	MS	1
1347	TX	6
1348	CA	1
1350	CA	1
1350	MS	1
1350	TX	1
1351	NJ	9
1352	IL	38
1354	AZ	1
1355	FL	3
1359	CA	2
1359	MS	6
1359	OK	1
1359	TX	5
1360	NV	2
1362	TX	9
1363	IL	1
1366	TX	30
1369	NV	6
1371	CO	6
1371	TX	1
1372	FL	24
1374	OK	59
1376	CA	1
1376	LA	1
1376	NV	1
1377	NM	1
1377	TX	38
1380	TX	6
1381	NV	3
1381	OK	6
1382	TX	1
1383	TX	7
1384	TX	1
1387	CA	6
1389	TX	38
1390	MO	40
1392	OK	7
1392	TX	6
1393	TN	1
1396	MO	9
1400	IL	1
1400	MS	1
1401	CO	10
1401	MS	38
1402	MS	6
1402	OK	1
1402	TX	6
1403	AZ	29
1403	TX	2
1405	AL	60
1405	FL	7
1406	LA	5
1407	AZ	42
1407	TX	8
1408	LA	1
1410	TX	16
1411	SC	31
1412	IL	2
1413	IL	5
1414	IL	1
1415	TX	1
1420	AZ	1
1420	CA	32
1421	TN	6
1425	NM	38
1425	TN	37
1431	NV	5
1434	AZ	9
1434	CA	3
1434	FL	8
1435	AZ	2
1436	TX	6
1439	TX	5
1440	TX	1
1441	FL	5
1441	NV	5
1442	AZ	7
1442	CO	1
1442	TX	38
1445	MD	10
1447	TX	1
1448	MD	6
1449	AZ	29
1451	CA	3
1454	TN	2
1454	TX	18
1456	TX	8
1457	TN	6
1458	MS	3
1463	TX	5
1464	TX	29
1465	TX	7
1466	FL	4
1466	OK	6
1466	TX	1
1467	AL	1
1467	CO	6
1469	TX	36
1471	TX	5
1476	TX	3
1478	IL	1
1480	MS	7
1481	SC	6
1484	CA	2
1485	TX	1
1487	AZ	49
1487	CA	7
1490	FL	40
1491	TX	7
1493	LA	6
1493	TX	62
1494	TX	1
1495	AZ	30
1495	FL	59
1497	FL	20
1497	LA	3
1498	AR	1
1501	CO	5
1502	MS	30
1504	OK	24
1505	NV	2
1506	AL	1
1507	IL	20
1508	CA	30
1509	CA	24
1509	TX	22
1510	CO	6
1514	OK	7
1514	TX	2
1516	FL	1
1516	TX	6
1518	TX	6
1519	FL	1
1520	IL	3
1521	FL	4
1521	TN	1
1522	IL	7
1522	TN	1
1523	CA	6
1528	MO	7
1534	TX	5
1535	CA	24
1536	CA	24
1540	IL	1
1542	SC	6
1543	FL	2
1543	TX	3
1545	FL	1
1549	TN	10
1551	FL	1
1552	NM	6
1553	IL	58
1554	AL	7
1557	AZ	3
1557	CA	20
1557	TN	7
1558	CO	7
1558	LA	32
1559	NV	60
1561	MS	7
1563	MO	5
1564	NV	1
1565	TX	44
1566	IL	7
1567	AR	2
1568	AZ	6
1568	CA	30
1568	IL	29
1574	NM	41
1576	LA	34
1576	TX	36
1577	AZ	3
1577	OK	2
1579	TX	20
1580	OK	38
1583	IL	1
1588	AZ	5
1589	NM	1
1590	LA	20
1592	CO	29
1593	MD	2
1594	TX	5
1596	TX	1
1597	OK	29
1599	CO	3
1599	TX	40
1601	TX	4
1607	TX	6
1608	AL	1
1608	TN	1
1609	CO	1
1610	LA	24
1612	NV	6
1615	TX	33
1616	TX	29
1620	OK	5
1621	TX	4
1626	TX	6
1627	TN	1
1628	FL	34
1628	LA	49
1628	MD	30
1628	NM	49
1628	OK	1
1628	TN	2
1628	TX	31
1629	TX	1
1630	TN	1
1634	LA	7
1636	TX	261
1637	PA	1
1637	NA	5
1638	CO	1
1639	CO	1
1639	LA	38
1640	SC	6
1642	TN	3
1643	IL	6
1643	MD	1
1644	MO	6
1648	LA	1
1650	TX	7
1652	TX	5
1653	NM	24
1655	LA	20
1655	TX	38
1657	TN	8
1659	IL	5
1661	AZ	5
1662	MS	24
1662	TN	28
1664	MO	7
1665	OK	42
1668	TX	1
1669	IL	5
1670	CO	5
1672	TX	5
1673	FL	8
1673	OK	6
1673	TN	20
1673	TX	39
1674	FL	30
1675	NV	34
1676	IL	5
1676	NV	6
1676	TN	1
1677	TX	6
1681	TX	25
1682	IL	1
1683	FL	6
1683	TN	6
1684	TX	22
1685	TX	5
1687	CA	5
1687	MD	41
1688	MS	5
1689	NM	1
1689	TX	6
1690	CA	6
1690	MD	2
1691	NV	1
1693	OK	4
1695	CO	7
1695	TX	4
1698	TN	6
1699	FL	5
1699	SC	41
1699	TX	29
1703	TX	7
1704	CA	10
1704	NM	3
1704	OK	6
1705	OK	1
1706	TX	6
1707	LA	41
1708	AZ	1
1708	CA	38
1709	IL	5
1709	MS	8
1710	TX	4
1712	LA	6
1713	CA	6
1713	NM	7
1715	LA	7
1715	TX	10
1717	NV	1
1717	TX	5
1720	NJ	5
1720	TX	7
1721	TN	9
1725	IL	1
1725	LA	3
1726	OK	1
1726	NA	4
1727	CA	38
1727	FL	1
1729	FL	1
1729	TX	7
1732	TX	7
1733	FL	5
1735	NV	8
1736	NA	7
1737	TX	6
1740	CO	1
1741	FL	41
1741	MO	1
1741	TX	11
1744	LA	5
1744	TX	7
1745	CA	1
1745	FL	6
1745	LA	4
1745	TX	6
1747	IL	3
1747	OK	7
1749	CO	1
1749	TN	6
1750	AZ	30
1751	LA	9
1751	MO	3
1751	OK	2
1752	CA	40
1752	OK	1
1754	TX	41
1756	AR	36
1756	FL	1
1756	NA	1
1758	CA	1
1759	CA	36
1760	OK	3
1762	TX	2
1767	IL	33
1768	FL	2
1768	OK	1
1771	FL	42
1773	TX	20
1775	SC	2
1776	CA	5
1778	FL	38
1778	TX	5
1779	LA	5
1779	MD	6
1780	CA	1
1781	MS	1
1782	LA	8
1784	TX	1
1786	TX	7
1789	IL	9
1789	MS	6
1789	TX	5
1790	TX	24
1792	FL	1
1793	LA	5
1793	NM	6
1795	AZ	3
1795	LA	8
1796	AL	24
1797	MD	7
1798	AR	3
1798	CA	6
1799	IL	7
1802	FL	7
1802	TX	1
1805	OK	1
1808	LA	1
1810	FL	1
1811	AR	5
1811	MD	6
1812	MO	1
1815	MS	1
1815	TX	5
1819	NJ	5
1819	TX	1
1823	TX	1
1826	FL	4
1826	OK	1
1828	CA	1
1830	MS	2
1832	NM	1
1837	TX	1
1839	LA	34
1839	NM	1
1851	FL	1
1852	IL	30
1853	TX	2
1854	TX	6
1856	TX	1
1857	FL	5
1859	TX	8
1860	NM	60
1860	TX	5
1861	AR	38
1863	CO	60
1863	LA	1
1863	TX	6
1864	TX	1
1867	CO	5
1867	LA	1
1867	TX	33
1868	TX	5
1869	CO	7
1870	NA	1
1873	LA	5
1873	TX	4
1874	TX	1
1875	LA	20
1875	PA	5
1877	AZ	7
1882	CO	14
1886	OK	5
1887	TX	7
1888	LA	1
1889	MS	1
1889	TX	6
1890	MD	2
1892	CA	1
1892	CO	6
1892	FL	1
1894	LA	3
1895	NA	7
1896	CO	24
1899	LA	5
1899	MS	40
1899	TX	8
1900	TN	1
1900	TX	11
1901	AZ	8
1901	IL	6
1902	TX	1
1903	AZ	31
1903	CO	1
1904	FL	3
1905	FL	6
1909	AL	5
1911	CA	1
1914	AZ	1
1915	TX	3
1918	MO	10
1919	MD	38
1919	TX	34
1921	AZ	1
1921	CA	20
1924	CA	6
1924	TX	10
1925	TX	6
1926	CO	28
1926	TX	42
1930	AL	38
1931	CA	7
1932	FL	38
1932	SC	6
1935	MO	8
1937	IL	1
1937	TX	6
1938	AZ	1
1938	TX	24
1939	TX	6
1940	NV	6
1945	IL	24
1949	MS	29
1949	TX	1
1951	MO	5
1951	TX	1
1952	IL	29
1954	IL	1
1954	PA	4
1954	TX	1
1956	LA	1
1956	OK	6
1956	TX	3
1959	FL	1
1959	MO	1
1959	TX	40
1961	TX	30
1962	CA	7
1962	TN	5
1963	AL	6
1965	CA	6
1970	SC	6
1978	NM	4
1978	TN	1
1980	TX	6
1980	NA	5
1981	FL	1
1981	TX	1
1982	CO	49
1983	FL	7
1983	TX	1
1984	FL	9
1986	OK	1
1989	CO	1
1989	LA	4
1989	PA	8
1990	FL	6
1990	MD	6
1991	AL	7
1991	LA	6
1993	FL	2
1996	LA	8
1998	FL	1
1998	OK	1
1999	SC	1
2001	CA	2
2002	LA	49
2004	TX	6
2006	TX	6
2008	TX	5
2010	NM	1
2012	FL	3
2012	MO	25
2013	IL	1
2013	NV	1
2018	IL	24
2018	TX	6
2022	TX	25
2023	TN	6
2024	NV	1
2025	TX	118
2027	FL	6
2027	MD	3
2029	AL	30
2029	CA	24
2030	CA	10
2030	NM	5
2031	TX	5
2032	MO	3
2032	TX	1
2033	MS	1
2033	NA	2
2034	TX	10
2038	TX	1
2042	MO	7
2042	TX	5
2043	FL	4
2044	TX	1
2045	CA	6
2046	CO	6
2046	MD	8
2047	TX	1
2049	IL	1
2049	NV	3
2051	CO	10
2051	LA	6
2052	LA	1
2052	PA	6
2061	MD	30
2061	MO	5
2061	SC	7
2061	TX	1
2062	CA	3
2066	NM	2
2067	TX	1
2068	FL	1
2068	OK	35
2068	TX	24
2070	CA	1
2072	OK	1
2072	PA	6
2074	TX	6
2075	TX	6
2076	MO	1
2076	TX	40
2078	TX	1
2080	LA	1
2081	FL	6
2082	MO	6
2085	MS	24
2086	OK	1
2086	TX	30
2088	CO	1
2090	OK	30
2091	MO	2
2093	AR	2
2093	IL	6
2093	MO	6
2094	IL	1
2094	OK	24
2094	TX	1
2097	TX	3
2099	OK	9
2100	LA	2
2100	TX	42
2101	TX	5
2103	NV	30
2104	AZ	1
2105	NM	1
2106	LA	59
2112	CA	42
2112	FL	1
2113	NV	24
2117	TX	3
2118	MS	7
2121	AZ	1
2122	FL	3
2123	AZ	24
2123	FL	1
2127	MD	4
2127	NM	2
2127	TX	2
2129	AL	1
2130	TX	6
2131	TX	5
2133	OK	10
2134	AZ	10
2134	OK	24
2134	TX	1
2139	SC	7
2139	TX	6
2147	NM	3
2147	TX	5
2151	FL	40
2154	TX	29
2157	MO	2
2158	NV	3
2159	CA	5
2162	NJ	1
2162	NV	38
2164	OK	5
2165	NV	1
2170	AZ	33
2170	FL	7
2170	IL	41
2170	LA	1
2171	FL	7
2172	CA	1
2176	TX	6
2177	LA	40
2181	FL	4
2181	IL	25
2184	LA	6
2185	FL	2
2185	NA	5
2186	NV	1
2186	TX	5
2189	CO	4
2189	TX	36
2191	IL	41
2192	MD	30
2192	NM	6
2194	AZ	24
2194	OK	2
2194	TX	5
2195	MD	24
2196	NJ	9
2196	TX	1
2198	TN	2
2200	TX	25
2202	FL	28
2202	LA	1
2203	LA	5
2206	NV	5
2210	LA	41
2211	TX	9
2212	LA	5
2212	MS	6
2213	NV	5
2213	TX	6
2214	TX	6
2215	FL	8
2216	TX	7
2217	MO	1
2218	TX	34
2219	LA	30
2221	NV	2
2222	CA	5
2226	TX	3
2227	CA	7
2229	TX	4
2231	TX	5
2235	AZ	6
2235	CO	6
2237	LA	6
2239	MO	1
2247	NM	7
2248	CA	8
2250	AR	5
2250	FL	6
2255	MS	5
2257	AZ	1
2258	FL	7
2259	CO	7
2261	CA	30
2266	CA	25
2268	TX	7
2273	TX	30
2277	CO	1
2277	TX	58
2279	FL	9
2282	TX	5
2283	CA	1
2284	CA	4
2288	AZ	41
2291	LA	25
2296	FL	1
2298	AR	6
2299	NM	33
2300	OK	20
2305	CA	3
2307	MS	30
2309	LA	6
2312	IL	1
2312	MD	3
2313	CA	6
2314	NV	5
2315	AZ	1
2315	LA	24
2317	AR	6
2317	FL	1
2318	LA	1
2319	TX	1
2320	LA	34
2323	AZ	5
2323	IL	8
2326	CA	6
2333	LA	24
2333	TX	1
2336	TX	7
2337	TX	1
2338	TN	1
2339	LA	2
2340	TX	3
2341	FL	6
2341	NJ	30
2342	FL	1
2343	TX	1
2344	MO	5
2344	NA	1
2345	AL	1
2345	TX	8
2347	NJ	41
2353	AL	10
2353	LA	41
2358	NV	20
2358	TX	7
2360	CA	6
2360	TN	1
2361	AZ	2
2362	OK	1
2362	TX	5
2363	TX	42
2368	TX	7
2369	OK	1
2372	MS	2
2378	MS	30
2378	TX	2
2380	IL	5
2380	OK	1
2381	TX	1
2382	FL	2
2383	TX	24
2387	FL	5
2387	TX	6
2389	TX	25
2393	CO	1
2394	TX	1
2396	CA	30
2396	NJ	1
2399	TX	6
2402	CA	6
2402	OK	1
2403	CA	1
2404	TX	1
2407	AZ	2
2410	NV	7
2412	TX	7
2413	CA	1
2413	NM	30
2417	NV	1
2419	IL	3
2419	OK	5
2419	TX	1
2424	AL	9
2424	MD	25
2424	TX	35
2427	AZ	1
2427	TX	4
2428	LA	1
2430	TX	1
2433	OK	4
2435	MD	5
2445	AZ	5
2448	FL	5
2449	CA	4
2449	TX	3
2451	OK	25
2453	TX	24
2456	OK	5
2457	CA	1
2459	CA	1
2459	FL	25
2459	TX	1
2460	SC	5
2463	OK	1
2468	CA	1
2470	CO	24
2472	FL	1
2477	TX	30
2479	AR	1
2479	CA	6
2479	FL	4
2480	TX	24
2481	CA	6
2481	LA	1
2483	LA	3
2484	PA	7
2488	FL	5
2489	CA	1
2491	TX	3
2492	CO	5
2492	TX	1
2493	TX	25
2502	TX	24
2506	LA	7
2508	CA	30
2511	FL	3
2511	TX	30
2514	TX	7
2515	TX	1
2516	LA	1
2516	TX	9
2517	LA	1
2522	CA	1
2522	FL	1
2522	TX	6
2525	IL	101
2533	NV	7
2534	LA	29
2539	AZ	38
2539	TN	5
2543	FL	5
2543	LA	1
2544	TX	4
2552	MO	2
2552	NV	1
2553	AZ	1
2554	NM	1
2554	TN	7
2556	TX	24
2556	NA	5
2564	LA	6
2565	FL	30
2566	TX	1
2568	TX	5
2570	TX	1
2572	IL	10
2573	SC	1
2575	NM	1
2577	TX	1
2578	OK	24
2581	TX	1
2582	NM	5
2583	TX	6
2584	MD	1
2585	OK	5
2585	TX	1
2586	NV	25
2589	TX	1
2591	AZ	1
2594	MO	1
2597	FL	1
2597	OK	1
2599	AR	1
2599	LA	3
2599	TN	5
2601	NV	2
2601	TX	7
2604	NV	5
2605	NV	1
2606	TN	9
2606	TX	1
2607	TX	5
2608	NM	1
2608	TX	3
2610	LA	30
2612	LA	30
2614	CO	1
2616	CO	2
2619	TX	1
2621	IL	6
2622	LA	28
2622	TX	30
2623	CA	22
2625	TX	1
2628	IL	10
2634	TX	1
2636	TN	6
2640	FL	1
2642	LA	1
2643	TX	6
2644	TX	29
2649	TX	3
2652	NV	1
2653	CA	25
2655	CA	1
2657	FL	7
2660	CO	7
2661	TX	3
2663	MO	3
2664	MO	30
2665	TX	30
2670	TX	3
2672	TX	3
2673	TX	1
2674	TX	5
2675	CA	5
2675	LA	29
2677	TX	8
2678	CA	24
2681	IL	7
2683	NA	1
2684	CO	5
2688	FL	5
2688	TX	3
2689	FL	1
2690	LA	6
2690	TX	1
2697	TX	3
2698	TX	7
2705	CA	1
2708	TX	34
2710	CO	1
2713	LA	1
2714	FL	1
2719	TX	20
2725	CA	38
2725	TX	33
2727	LA	5
2734	TX	5
2735	NM	1
2737	LA	1
2739	AR	7
2742	TX	1
2744	IL	6
2745	TX	1
2747	TX	1
2749	NV	7
2749	OK	1
2751	MS	1
2753	OK	1
2755	NA	3
2756	TX	5
2761	FL	30
2762	MO	6
2765	MO	30
2765	OK	6
2771	CA	30
2773	LA	6
2776	CO	2
2780	TX	1
2781	TX	5
2782	LA	7
2782	TX	8
2788	CA	10
2790	OK	3
2792	AZ	5
2794	CA	3
2795	AZ	20
2795	NJ	40
2796	TX	5
2797	TX	59
2798	TX	31
2801	LA	24
2802	LA	6
2802	TX	1
2805	TX	25
2807	TX	59
2808	MS	1
2809	FL	1
2811	TX	30
2814	AL	1
2826	LA	2
2826	TX	7
2830	CA	1
2832	CO	3
2836	CO	30
2837	CO	7
2839	AR	24
2842	FL	1
2844	TX	22
2852	CA	4
2854	AZ	7
2857	PA	1
2857	TN	24
2858	CO	10
2868	OK	2
2873	TX	59
2875	FL	1
2878	SC	30
2880	NV	1
2882	AL	3
2882	AZ	8
2882	IL	6
2883	MO	28
2884	PA	1
2884	TX	10
2893	OK	2
2898	FL	2
2899	TX	1
2904	MO	59
2906	FL	9
2907	FL	24
2908	AZ	2
2908	OK	41
2911	TX	1
2913	AL	1
2914	PA	1
2918	CA	10
2919	MO	1
2920	AZ	1
2920	IL	1
2923	MD	6
2924	NV	2
2924	TX	3
2925	CO	5
2926	FL	6
2928	IL	1
2932	FL	1
2932	LA	4
2933	MS	7
2934	IL	7
2934	TX	6
2936	TX	6
2937	FL	8
2939	FL	1
2941	OK	1
2944	TX	6
2946	AZ	6
2954	NV	24
2955	TX	6
2956	TX	30
2957	TX	7
2960	OK	6
2964	LA	1
2965	AR	9
2969	NV	25
2970	LA	2
2971	TX	1
2976	AL	7
2982	CO	4
2984	LA	25
2984	OK	7
2986	OK	1
2989	TX	9
2993	FL	1
2994	CA	28
3004	AZ	5
3004	TX	6
3005	TX	1
3009	TN	1
3013	OK	5
3013	TX	4
3018	LA	1
3019	LA	8
3020	CO	1
3022	MO	1
3028	CO	6
3028	TX	1
3029	LA	2
3030	NV	7
3034	AR	1
3034	FL	5
3042	LA	1
3049	MS	1
3056	AL	38
3056	TX	30
3059	TX	41
3064	TX	1
3067	TX	6
3068	MS	42
3071	TX	7
3072	LA	1
3079	FL	6
3085	PA	22
3086	SC	1
3087	FL	6
3090	NM	7
3090	TX	1
3095	MD	7
3096	FL	7
3097	OK	30
3098	AL	4
3098	FL	1
3099	TX	3
3104	MO	1
3106	LA	2
3112	CA	5
3116	TN	1
3123	CA	7
3125	TX	1
3126	AL	1
3130	IL	5
3130	MD	1
3133	TX	25
3135	TX	25
3136	NV	1
3136	TX	1
3139	CO	2
3142	MD	6
3143	CA	2
3144	TX	1
3146	NV	6
3151	OK	6
3163	TX	7
3168	NJ	9
3170	TX	1
3175	FL	1
3175	IL	1
3175	TX	11
3177	TN	1
3177	TX	5
3183	TX	7
3185	CA	5
3187	FL	7
3188	MD	7
3190	TX	1
3192	CA	25
3203	OK	1
3206	CO	6
3209	AZ	1
3212	CA	7
3212	NV	1
3214	TX	9
3215	AL	1
3216	TX	6
3219	TX	9
3220	LA	30
3220	TX	6
3221	LA	7
3227	TX	3
3228	IL	2
3231	TN	9
3233	IL	1
3236	IL	9
3242	IL	38
3243	TX	38
3251	SC	9
3254	TX	42
3256	TX	2
3257	TX	34
3263	FL	5
3264	MD	6
3271	TX	10
3274	NM	9
3276	AL	7
3276	CO	1
3280	FL	5
3284	TX	5
3285	CO	1
3292	NA	5
3295	TX	6
3297	CO	9
3301	IL	1
3301	NV	6
3306	TN	30
3307	OK	30
3308	TX	9
3309	MS	41
3313	TX	1
3317	PA	1
3317	TN	31
3318	IL	59
3318	MO	34
3318	TX	5
3322	TX	1
3325	TX	6
3339	CA	7
3341	IL	3
3344	OK	8
3345	LA	6
3348	IL	5
3351	TX	24
3355	FL	6
3355	LA	1
3357	TX	7
3358	FL	24
3363	LA	3
3365	OK	6
3366	MO	4
3366	TX	6
3367	CO	1
3374	CA	7
3381	TX	1
3386	MD	24
3393	SC	1
3403	NM	3
3403	OK	25
3404	IL	6
3404	LA	2
3404	NV	2
3406	MS	1
3410	MS	25
3410	TN	1
3414	TX	1
3416	FL	6
3418	FL	10
3419	CA	6
3421	AL	1
3426	OK	34
3428	TX	24
3429	NA	7
3432	MS	1
3435	FL	7
3438	FL	1
3440	CO	1
3448	NV	5
3449	AZ	2
3449	LA	7
3452	TX	6
3455	TX	1
3457	LA	1
3458	TX	1
3463	FL	1
3464	PA	1
3465	NV	1
3465	TX	7
3470	TX	5
3470	NA	1
3474	MO	20
3478	TX	1
3479	FL	10
3480	AL	7
3482	AZ	10
3485	FL	1
3485	TX	9
3486	SC	60
3488	MO	25
3491	AR	3
3492	MO	38
3492	TX	1
3493	CO	25
3495	TX	25
3498	TX	8
3499	NM	9
3499	TX	8
3503	TX	1
3507	IL	1
3507	PA	7
3509	FL	30
3510	LA	6
3513	FL	41
3514	TX	6
3521	TX	16
3531	NJ	1
3533	MS	1
3549	LA	10
3550	IL	8
3552	TX	8
3553	TX	8
3555	LA	1
3556	TX	10
3556	NA	3
3558	TX	6
3560	TX	1
3561	TX	7
3569	NV	30
3574	TX	59
3575	CO	7
3575	TX	20
3576	AZ	8
3578	CA	9
3578	IL	25
3578	NM	2
3579	MD	40
3582	TX	1
3585	FL	8
3588	TX	9
3600	TX	1
3610	MO	10
3613	NV	7
3614	TX	3
3616	CA	1
3617	CA	10
3619	FL	7
3626	CA	9
3628	FL	10
3629	AZ	1
3637	CA	6
3638	TX	1
3639	TX	10
3644	MS	3
3647	MO	1
3649	OK	1
3651	IL	10
3654	OK	40
3659	LA	2
3664	MD	3
3664	NV	6
3665	TX	25
3671	IL	5
3671	TX	1
3675	CO	38
3680	TX	6
3681	LA	30
3682	CA	8
3686	FL	7
3688	TX	7
3692	LA	2
3697	TX	7
3704	OK	9
3713	CA	10
3720	IL	24
3727	TX	6
3731	OK	24
3734	LA	10
3738	AZ	9
3740	IL	1
3741	IL	7
3743	FL	9
3744	TX	49
3750	TX	7
3751	FL	5
3754	TX	1
3757	TX	6
3762	NA	1
3766	TX	34
3768	CA	3
3772	CA	30
3776	TX	6
3780	FL	20
3784	TX	7
3790	OK	6
3791	FL	10
3791	IL	1
3792	FL	24
3793	LA	7
3800	FL	9
3800	OK	1
3800	TX	7
3803	TX	20
3805	TX	7
3810	MD	3
3811	FL	7
3816	MD	7
3818	MS	9
3823	MD	7
3823	NV	2
3829	TX	25
3831	TX	6
3832	IL	24
3840	TX	31
3844	MS	1
3846	MS	10
3848	TX	3
3850	TX	1
3866	OK	3
3869	LA	30
3871	NM	8
3873	NJ	1
3874	TX	6
3877	AZ	3
3877	CA	7
3885	FL	1
3890	CA	1
3890	TX	6
3891	TX	7
3895	TX	6
3900	FL	3
3902	IL	7
3907	TX	25
3911	FL	6
3915	IL	5
3915	TN	3
3921	FL	6
3925	AL	30
3926	NM	3
3927	MS	1
3927	OK	30
3933	TX	9
3937	PA	30
3938	FL	32
3940	LA	42
3943	CO	8
3948	AZ	1
3948	NM	6
3955	AL	1
3955	NV	9
3955	TX	1
3958	MO	10
3964	MD	10
3964	TX	6
3973	NM	6
3974	TX	1
3976	TN	1
3977	NA	1
3983	FL	10
3989	TX	4
3989	NA	1
3990	TX	1
3991	TX	1
3996	TN	1
3998	MD	10
3998	TX	3
3999	TX	6
5001	AZ	3
5008	CA	6
5016	TX	24
5018	NM	20
5025	NA	1
5032	IL	4
5047	TN	6
5049	FL	6
5050	PA	3
5060	CO	24
5062	FL	3
5070	IL	3
5087	TX	7
5130	MO	6

#gives us the common flight destinations for flight paths.
#find states flights tend to fly to 
sw_states <- sw_flights %>% 
  select(state, iata) %>% 
  group_by(state, iata) %>% 
  tally() %>% 
  rename(state_count = n) %>% 
  head(10) %>%
    format(big.mark = ",") %>%
    knitr::kable("markdown", align = c('l', 'r'))

Question 4:

I want to know proportionately what regions (NE, south, west, midwest) each carrier flies to/from Houston in the month of July. Consider the month() function from the lubridate package.

#month function. proportionally. carrier region total/ flight total
#carrier region total/ flight total. 

#sw_join was data made earlier, joiningg airoprts and flights dataset togehter. 
sw_join <- full_join(airports, flights, by=c("iata"="dest"))
region <- full_join(sw_join, states, by = "state")


July_Flight <- region %>% 
  filter(!is.na(carrier) & (!is.na(date)))  %>% 
  mutate(month = month(date)) %>% 
  filter(month == 7) 
                            
regionTot <- July_Flight %>% 
  group_by(region, carrier) %>% 
  tally() %>% 
  rename(region_fly_tot = n) 

flight_tot <- July_Flight %>% 
  group_by(region) %>%       
  tally() %>% 
  rename(tot_flights = n)

#to compute this proportion, let's join region flight totals and flights totals 
props <- left_join(regionTot, flight_tot, by="region") %>% 
  mutate(prop_region = (region_fly_tot/tot_flights)) 

#mutate(props, prop_region=as.numeric(prop_region)) 

ggplot(data = props, aes(x=carrier, y=prop_region, col = region)) +
geom_point() +
         labs(x = "Airline Carrier", y = "Proportion", 
              title = "Proportionately what regions each 
airline carrier flies to in July")