sql-advanced/db_dump.sql at master · amadr-95/sql-advanced · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
--
-- PostgreSQL database dump
--

-- Dumped from database version 15.3
-- Dumped by pg_dump version 15.3

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: sales; Type: SCHEMA; Schema: -; Owner: amador
--

CREATE SCHEMA sales;


ALTER SCHEMA sales OWNER TO amador;

--
-- Name: count_people_by_first_name(text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.count_people_by_first_name(p_first_name text) RETURNS integer
    LANGUAGE plpgsql
    AS $$
DECLARE
    total_people INT;
BEGIN
    SELECT COUNT(*)
    INTO total_people --store the value in the variable
    FROM people
    WHERE first_name ILIKE p_first_name;

    RETURN total_people;
END;
$$;


ALTER FUNCTION public.count_people_by_first_name(p_first_name text) OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: account; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.account (
    id bigint NOT NULL,
    name text NOT NULL,
    balance numeric(10,2)
);


ALTER TABLE public.account OWNER TO postgres;

--
-- Name: accounts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.accounts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accounts_id_seq OWNER TO postgres;

--
-- Name: accounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.accounts_id_seq OWNED BY public.account.id;


--
-- Name: customer; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.customer (
    id bigint NOT NULL,
    first_name text NOT NULL,
    last_name text NOT NULL,
    email text NOT NULL,
    address text,
    created_at timestamp without time zone NOT NULL
);


ALTER TABLE public.customer OWNER TO postgres;

--
-- Name: customer_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.customer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.customer_id_seq OWNER TO postgres;

--
-- Name: customer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.customer_id_seq OWNED BY public.customer.id;


--
-- Name: customer_order; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.customer_order (
    id bigint NOT NULL,
    customer_id bigint NOT NULL,
    total_amount numeric(10,2) NOT NULL,
    created_at timestamp without time zone NOT NULL,
    CONSTRAINT amount_greater_than_zero CHECK ((total_amount > (0)::numeric))
);


ALTER TABLE public.customer_order OWNER TO postgres;

--
-- Name: customer_order_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.customer_order_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.customer_order_id_seq OWNER TO postgres;

--
-- Name: customer_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.customer_order_id_seq OWNED BY public.customer_order.id;


--
-- Name: order_item; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.order_item (
    id bigint NOT NULL,
    order_id bigint NOT NULL,
    product_id bigint NOT NULL,
    quantity integer NOT NULL,
    price numeric(10,2) NOT NULL,
    CONSTRAINT price_greater_than_zero CHECK ((price > (0)::numeric)),
    CONSTRAINT quantity_greater_than_zero CHECK ((quantity > 0))
);


ALTER TABLE public.order_item OWNER TO postgres;

--
-- Name: order_item_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.order_item_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.order_item_id_seq OWNER TO postgres;

--
-- Name: order_item_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.order_item_id_seq OWNED BY public.order_item.id;


--
-- Name: people; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.people (
    id bigint NOT NULL,
    first_name text NOT NULL,
    last_name text NOT NULL
);


ALTER TABLE public.people OWNER TO postgres;

--
-- Name: people_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.people_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.people_id_seq OWNER TO postgres;

--
-- Name: people_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.people_id_seq OWNED BY public.people.id;


--
-- Name: product; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.product (
    id bigint NOT NULL,
    name text NOT NULL,
    price numeric(5,2) NOT NULL,
    discontinued boolean NOT NULL,
    CONSTRAINT price_greater_than_zero CHECK ((price > (0)::numeric))
);


ALTER TABLE public.product OWNER TO postgres;

--
-- Name: product_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.product_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_id_seq OWNER TO postgres;

--
-- Name: product_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.product_id_seq OWNED BY public.product.id;


--
-- Name: people; Type: TABLE; Schema: sales; Owner: amador
--

CREATE TABLE sales.people (
);


ALTER TABLE sales.people OWNER TO amador;

--
-- Name: account id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.account ALTER COLUMN id SET DEFAULT nextval('public.accounts_id_seq'::regclass);


--
-- Name: customer id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer ALTER COLUMN id SET DEFAULT nextval('public.customer_id_seq'::regclass);


--
-- Name: customer_order id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_order ALTER COLUMN id SET DEFAULT nextval('public.customer_order_id_seq'::regclass);


--
-- Name: order_item id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_item ALTER COLUMN id SET DEFAULT nextval('public.order_item_id_seq'::regclass);


--
-- Name: people id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.people ALTER COLUMN id SET DEFAULT nextval('public.people_id_seq'::regclass);


--
-- Name: product id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.product ALTER COLUMN id SET DEFAULT nextval('public.product_id_seq'::regclass);


--
-- Data for Name: account; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.account (id, name, balance) FROM stdin;
1	user1	600.00
2	user2	1400.00
\.


--
-- Data for Name: customer; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.customer (id, first_name, last_name, email, address, created_at) FROM stdin;
1	John	Doe	john.doe@example.com	123 Main St	2024-04-23 19:14:17.556011
2	Jane	Smith	jane.smith@example.com	456 Elm St	2024-04-23 19:14:17.556011
3	Michael	Johnson	michael.johnson@example.com	789 Oak St	2024-04-23 19:14:17.556011
4	Emily	Brown	emily.brown@example.com	101 Pine St	2024-04-23 19:14:17.556011
5	David	Lee	david.lee@example.com	202 Cedar St	2024-04-23 19:14:17.556011
\.


--
-- Data for Name: customer_order; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.customer_order (id, customer_id, total_amount, created_at) FROM stdin;
1	1	81.97	2024-04-23 19:14:17.676826
2	1	74.98	2024-04-23 19:14:17.676826
5	5	245.97	2024-04-23 19:14:17.676826
3	3	141.95	2024-04-23 19:14:17.676826
4	4	89.98	2024-04-23 19:14:17.676826
\.


--
-- Data for Name: order_item; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.order_item (id, order_id, product_id, quantity, price) FROM stdin;
1	1	1	2	31.98
2	1	3	1	49.99
3	2	2	1	39.99
4	2	5	1	34.99
5	3	4	3	89.97
6	3	7	2	51.98
7	4	8	1	19.99
8	4	10	1	69.99
9	5	6	2	199.98
10	5	9	1	45.99
\.


--
-- Data for Name: people; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.people (id, first_name, last_name) FROM stdin;
1	Eliza	Gregory
2	Dean	Rodgers
3	Christine	Alvarez
4	Dennis	Peterson
5	Ernest	Roberts
6	Jorge	Wood
7	Harvey	Strickland
8	Eugene	Rivera
9	Tillie	Bell
10	Marie	Lloyd
11	John	Lyons
12	Lucas	Gray
13	Edward	May
14	Randy	Fields
15	Nell	Malone
16	Jacob	Maxwell
17	Eric	Glover
18	Mabel	Gordon
19	Curtis	Rodriquez
20	Johanna	Pearson
21	Theodore	Gregory
22	Katharine	Hawkins
23	Norman	Davidson
24	Ollie	Luna
25	Isabelle	Davidson
26	Earl	Craig
27	Douglas	Poole
28	Zachary	Lewis
29	Dylan	Knight
30	Leona	Arnold
31	Jordan	Harmon
32	Estelle	Sandoval
33	Melvin	Brown
34	Edwin	Henry
35	Catherine	Estrada
36	Minerva	Quinn
37	Chad	Keller
38	Owen	Robbins
39	Frances	Hughes
40	Myrtle	Lucas
41	Hattie	Fisher
42	Jerome	Gordon
43	Sallie	Strickland
44	Harry	Luna
45	Dollie	Clark
46	Ralph	Moran
47	Ethel	Dunn
48	Russell	Moreno
49	Leila	Burton
50	Ronald	Tran
51	Jorge	Dean
52	Iva	Burton
53	Cecelia	Spencer
54	Ellen	White
55	Bryan	Webb
56	Billy	Grant
57	Dollie	Burns
58	Lucile	Rowe
59	Willie	Reed
60	Maria	McGuire
61	Ethan	Davis
62	Frederick	Harrison
63	Warren	Elliott
64	Francis	King
65	Leila	Cooper
66	Cecilia	Delgado
67	Ollie	Christensen
68	Gary	Keller
69	Ronnie	Hammond
70	Marvin	Carpenter
71	Adeline	Palmer
72	Winifred	Rios
73	George	Webb
74	Jayden	Fowler
75	Andre	Boyd
76	Adelaide	Osborne
77	Eliza	Roberson
78	Claudia	Tucker
79	Effie	Gibson
80	Gertrude	Roberts
81	Antonio	Andrews
82	Willie	Blake
83	Ruth	Holland
84	Owen	Rodriquez
85	Ethel	Wilkins
86	Timothy	Newton
87	Callie	Goodwin
88	Benjamin	Walters
89	Virginia	Moore
90	James	Lawrence
91	Angel	Moran
92	Gertrude	Johnson
93	Rebecca	James
94	James	Burgess
95	Ernest	Stokes
96	Leona	Lloyd
97	Jeff	Gonzalez
98	Linnie	Sanders
99	Carl	Bell
100	Blake	Fitzgerald
101	Jesus	Gordon
102	Louis	Berry
103	Mable	Mendoza
104	Earl	Mathis
105	Andre	Lawson
106	Teresa	Jensen
107	Irene	Underwood
108	Mollie	Olson
109	Esther	Wise
110	Etta	Zimmerman
111	Nelle	Hale
112	Wayne	Caldwell
113	Jean	Robertson
114	Adrian	Wright
115	Jose	Hill
116	Claudia	Sandoval
117	Darrell	Holt
118	Danny	Barnett
119	Lola	Reese
120	Jane	Brooks
121	Alta	Phelps
122	Kenneth	Rogers
123	Arthur	Palmer
124	Adeline	Phillips
125	Franklin	Daniel
126	Elijah	Doyle
127	Gussie	Holt
128	Stella	Smith
129	Marion	Gordon
130	Cole	Jackson
131	Mildred	Benson
132	Ronnie	McKenzie
133	John	Walker
134	Amelia	McCoy
135	Katharine	Rogers
136	Logan	Andrews
137	Chase	Howell
138	Joshua	Wise
139	Dustin	Douglas
140	Curtis	Rhodes
141	Mathilda	Nash
142	Lucille	Wright
143	Ada	Arnold
144	Ora	Pope
145	Leona	Silva
146	Eleanor	Marsh
147	Randall	Brock
148	Corey	Webb
149	Terry	Rose
150	Benjamin	Turner
151	Vincent	Sanchez
152	Josie	Henry
153	Amanda	Hampton
154	Louisa	Terry
155	Georgie	Morales
156	Lloyd	Price
157	Ola	Hardy
158	Devin	Vargas
159	Adeline	Crawford
160	Virgie	Jones
161	Bess	Price
162	Floyd	George
163	Adrian	Gonzalez
164	Rosie	Townsend
165	Martha	Moss
166	Martin	Morris
167	May	Ray
168	Hettie	Miller
169	Lou	Johnston
170	Bryan	Richardson
171	Betty	McCarthy
172	Martin	Flores
173	Eleanor	Fox
174	Eva	Ball
175	Paul	Andrews
176	Lula	Holmes
177	Sylvia	Cross
178	Elmer	Osborne
179	Hulda	Cannon
180	Chris	McKinney
181	Hilda	Mathis
182	Carlos	Dawson
183	Ray	Webb
184	Dollie	Lee
185	Winifred	Hampton
186	Bertha	Jackson
187	Barry	Bell
188	Derek	Hawkins
189	George	Alvarado
190	Micheal	Moreno
191	Herbert	Young
192	Claudia	Ray
193	Nell	Stevenson
194	Jeff	Gordon
195	Andrew	Long
196	Isabelle	Hamilton
197	Walter	Moody
198	Edward	Rodgers
199	Tillie	Diaz
200	Flora	King
201	Hulda	Morris
202	Flora	Casey
203	Virginia	Simpson
204	Bettie	Hanson
205	Elsie	Barnett
206	Jeanette	Welch
207	Christian	Hernandez
208	Polly	Willis
209	Adrian	Lewis
210	Ollie	Moss
211	Marguerite	Jimenez
212	Gabriel	West
213	Millie	Hamilton
214	Jennie	Barnett
215	Jimmy	White
216	Kate	Bowen
217	Stanley	Glover
218	Lottie	McGee
219	Rosetta	McKenzie
220	Mark	Ford
221	Joel	Campbell
222	Hester	Black
223	Elizabeth	Bowman
224	Victoria	Graham
225	Samuel	Reid
226	Roy	Peters
227	Don	Vasquez
228	Virgie	Bradley
229	Teresa	Cannon
230	William	Hines
231	Jim	Pratt
232	Florence	Castro
233	Bernice	Dennis
234	Carolyn	Wagner
235	Allie	Wolfe
236	Timothy	Sherman
237	Kate	Simpson
238	Laura	Baldwin
239	Wesley	Fuller
240	Shane	Garrett
241	Belle	Pittman
242	Margaret	Welch
243	Adelaide	Phelps
244	Mae	Parks
245	Frances	Baldwin
246	Betty	Ortega
247	Mayme	Hanson
248	Gavin	Higgins
249	Blanche	Thornton
250	Kevin	Gregory
251	Edward	Lynch
252	Aaron	Watts
253	Lucas	Ramsey
254	Nannie	Lopez
255	Polly	Nelson
256	Hallie	Tate
257	Myrtie	Love
258	Eddie	McCarthy
259	Jason	Perry
260	Jon	Moody
261	Chase	Farmer
262	Caleb	Stephens
263	Marcus	Paul
264	James	Kim
265	Charlie	George
266	Cordelia	Butler
267	Trevor	Schneider
268	Lela	Doyle
269	Owen	Norman
270	Lora	Atkins
271	Lettie	Bradley
272	Elsie	Rice
273	Susan	Nash
274	Pearl	Ferguson
275	Nina	Sullivan
276	Olive	Peters
277	Harold	Douglas
278	Florence	Castillo
279	Victoria	Coleman
280	Lizzie	Gross
281	Frances	Frazier
282	Loretta	Norton
283	Johanna	Watson
284	Daniel	Bowers
285	Chris	Meyer
286	Nina	Henry
287	Bruce	Willis
288	Essie	Riley
289	Philip	Drake
290	Jay	Tucker
291	Francis	Torres
292	Glen	Fuller
293	Gilbert	Holt
294	Dale	Lambert
295	Jesus	Welch
296	Lura	Barrett
297	Vincent	Miles
298	Noah	Howard
299	Jeffrey	Wilson
300	Marian	Webster
301	Derrick	Atkins
302	Henry	Higgins
303	Callie	Barnes
304	Gertrude	Martinez
305	Nannie	Perez
306	Milton	Henry
307	Loretta	Larson
308	Ivan	Allison
309	Florence	Malone
310	Francisco	Cain
311	Ethel	May
312	Eugenia	Diaz
313	Marvin	Bush
314	Jimmy	Walton
315	Nelle	Mitchell
316	Bettie	Elliott
317	Amy	Maldonado
318	Leah	Cortez
319	Derrick	Todd
320	Tommy	Holland
321	Elmer	May
322	Olive	Alvarado
323	Olivia	Adams
324	Hester	Farmer
325	Evelyn	May
326	Vincent	Silva
327	Linnie	Harris
328	Brent	Hopkins
329	Helena	Mason
330	Vera	Goodwin
331	Chad	Nash
332	Barbara	Garrett
333	Terry	Cobb
334	Rose	Atkins
335	Sam	Delgado
336	Luis	Soto
337	Isaiah	Bowman
338	Kyle	Green
339	Cecelia	Lloyd
340	Leila	Horton
341	Roxie	Harrington
342	Lucinda	Carter
343	Jeff	Fields
344	Landon	Lloyd
345	Josie	Watkins
346	Theodore	Nelson
347	Esther	Douglas
348	Nell	Richards
349	Martha	Myers
350	Craig	Gonzales
351	Rosa	Marshall
352	Rodney	Kelley
353	Ronnie	Rios
354	Angel	Sullivan
355	Nannie	Luna
356	Lucas	Woods
357	Bernice	Ruiz
358	Mitchell	Barker
359	Cornelia	Walsh
360	Ellen	Williamson
361	John	Gibbs
362	Glenn	Powell
363	Jessie	Bennett
364	Callie	Hall
365	Jon	Welch
366	Charlotte	Carlson
367	Alice	Cross
368	Rosie	Carson
369	Leona	Gonzalez
370	Mattie	Wright
371	Cory	McCarthy
372	Kenneth	Atkins
373	Laura	McDonald
374	Maude	Bowen
375	Ray	Reynolds
376	Steve	Gill
377	Ola	Hardy
378	Ricardo	Williams
379	Ryan	White
380	Mina	Richards
381	Daisy	Carson
382	Adeline	Fitzgerald
383	Maud	Underwood
384	Jordan	Young
385	Milton	Jimenez
386	Eunice	Evans
387	Douglas	Vega
388	Agnes	Hall
389	Christina	Aguilar
390	Georgia	Gonzales
391	Hester	Edwards
392	Leo	Robertson
393	Myra	Parker
394	Ray	Park
395	Luella	Abbott
396	Jay	Perkins
397	Jeremiah	Byrd
398	Glenn	Harper
399	Edgar	Carr
400	Effie	Burns
401	Caroline	Hart
402	Duane	Ramos
403	Earl	Tucker
404	Rena	Garrett
405	Katie	Woods
406	Mike	Fernandez
407	Carlos	Martin
408	Gavin	Valdez
409	James	Roberson
410	Hettie	Sanchez
411	Mabel	Ford
412	Isabella	Sherman
413	Alfred	Obrien
414	Craig	Roberts
415	Christian	Warren
416	Angel	Schwartz
417	Clarence	Ferguson
418	Jeremy	Crawford
419	Dean	Andrews
420	Mittie	Henry
421	Iva	Haynes
422	Betty	Doyle
423	Todd	Walters
424	George	Lyons
425	Lenora	Lindsey
426	Mollie	Gonzales
427	Sam	Griffin
428	Lula	Ray
429	Lester	Arnold
430	Randy	Daniel
431	Charles	Howard
432	Alvin	Young
433	Darrell	Hoffman
434	Ricardo	Harris
435	Viola	Young
436	Clyde	Wade
437	Lelia	Ray
438	Betty	White
439	Gussie	Schwartz
440	Danny	Snyder
441	Frank	Reeves
442	Lois	Hampton
443	Cole	Walters
444	Josephine	Gordon
445	Francisco	Hubbard
446	Clara	Alvarado
447	Mason	Chandler
448	Bertha	Simon
449	Samuel	Clayton
450	Sean	Bowman
451	Winnie	Chambers
452	Harold	Mack
453	Isabelle	Morgan
454	Ethel	Schwartz
455	Ollie	Norris
456	Chad	Howell
457	Derrick	Bowman
458	Luella	Hawkins
459	Luis	Harmon
460	Randy	Sullivan
461	Carolyn	Quinn
462	Alex	Mack
463	Sadie	Garza
464	Norman	Watts
465	Mable	Brewer
466	Chase	Vasquez
467	Norman	Benson
468	Lela	Stevenson
469	Bradley	Potter
470	Lillian	Hanson
471	Hannah	Williamson
472	Mitchell	Garza
473	Rodney	Riley
474	Earl	Brown
475	Jane	Hammond
476	Jacob	Fox
477	Craig	Hunter
478	Johanna	Castro
479	Daisy	Fleming
480	Steve	Francis
481	Andre	Fields
482	Jerry	Myers
483	Maud	Potter
484	Joshua	Tran
485	Clifford	Kelly
486	Henrietta	Robbins
487	Maude	Willis
488	Gabriel	Floyd
489	Jennie	Moran
490	Frances	Richards
491	Gilbert	Klein
492	Polly	Drake
493	Edgar	Waters
494	Ophelia	Jennings
495	Joseph	Jimenez
496	Hattie	Lamb
497	Sally	Leonard
498	Derrick	May
499	Randy	Townsend
500	Madge	Wells
501	Alice	Blair
502	Victor	Salazar
503	Sallie	Jimenez
504	Philip	Cook
505	Lora	Sandoval
506	Bessie	Cohen
507	Mattie	Richardson
508	Chad	Erickson
509	Ray	Boone
510	Leonard	Hawkins
511	Micheal	Ward
512	Adeline	Ball
513	Jose	Olson
514	Lloyd	Newman
515	Ora	Baker
516	Zachary	Hill
517	Ryan	Wood
518	Ellen	Allison
519	Gussie	Jensen
520	Raymond	Flowers
521	Isaiah	Cohen
522	Ann	Love
523	Hester	Owens
524	Linnie	Murphy
525	Martin	Curtis
526	Mitchell	Tucker
527	Donald	George
528	Cynthia	Harper
529	Lily	Hardy
530	Jeanette	Matthews
531	Francisco	Sullivan
532	Dollie	Fernandez
533	Vincent	Adams
534	Henrietta	Schneider
535	Lida	Garner
536	Elnora	Saunders
537	Maria	Mack
538	Craig	Howard
539	Helena	Benson
540	Elnora	Hunter
541	Keith	Graham
542	Timothy	Allison
543	George	Beck
544	Lloyd	Wong
545	Ralph	Vargas
546	Jeremiah	Terry
547	Jerome	Lee
548	Troy	Bradley
549	Ralph	Mills
550	Mike	Atkins
551	Winnie	Moore
552	May	Ortiz
553	Mathilda	Walters
554	Alvin	Rhodes
555	Rose	Hardy
556	Nancy	Lyons
557	Ethel	Coleman
558	Peter	Harmon
559	Clifford	Anderson
560	Ethan	Sullivan
561	Nicholas	Valdez
562	Clayton	Porter
563	Edward	Chapman
564	Dennis	Gregory
565	Ethan	Stephens
566	Mae	McDonald
567	Stephen	Romero
568	Olive	Morris
569	Cole	Moran
570	Herbert	Yates
571	Juan	Powell
572	Teresa	Garrett
573	Lora	Roy
574	Cecelia	Phillips
575	Micheal	Chandler
576	Gene	Reyes
577	Cody	Drake
578	Anne	McCarthy
579	Rachel	Wolfe
580	Francis	Herrera
581	Ophelia	Welch
582	Jack	Reese
583	Terry	Wade
584	Leo	Schmidt
585	Della	Becker
586	Cecilia	Pratt
587	Lilly	Atkins
588	Julian	Figueroa
589	Sophia	Padilla
590	Johnny	Casey
591	Calvin	Wise
592	Daisy	Rice
593	Bettie	Copeland
594	Walter	Jenkins
595	Iva	Wallace
596	Lucile	Marsh
597	Edith	Jennings
598	Estelle	Austin
599	Lottie	Nash
600	Anthony	Miller
601	Marguerite	Brock
602	Noah	Powers
603	Cornelia	Powers
604	George	Lamb
605	Dennis	Howard
606	Carl	Curtis
607	Madge	Silva
608	Lloyd	Matthews
609	Brent	Stevenson
610	Loretta	Haynes
611	Glen	Robbins
612	John	Pena
613	Winifred	McBride
614	Isabel	Townsend
615	Frederick	Leonard
616	Danny	Parks
617	Keith	Lambert
618	Phoebe	Nguyen
619	Mitchell	Rios
620	Louis	Logan
621	Lena	Reyes