ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
SELECT *
FROM "los_angeles"."agent_licenses" "agent_licenses"
WHERE ((CAST("agent_licenses"."county_name" AS TEXT) = 'SAN FRANCISCO')
AND (CAST("agent_licenses"."lic_status" AS TEXT) = 'Licensed')
AND (CAST("agent_licenses"."lic_type" AS TEXT) IN ('Broker', 'Salesperson'))
AND ((((CAST(TRUNC(EXTRACT(YEAR FROM "agent_licenses"."upload_date")) AS INTEGER) * 10000)
+ (CAST(TRUNC(EXTRACT(MONTH FROM "agent_licenses"."upload_date")) AS INTEGER) * 100))
+ CAST(TRUNC(EXTRACT(DAY FROM "agent_licenses"."upload_date")) AS INTEGER)) = 20220215))
3
4
5
6
7
8
9
10
11
12
**OR** Download lists manually from https://www.dre.ca.gov/Licensees/ExamineeLicenseeListDataFiles.html. Download and consolidate Broker Associates List (Updated Weekly on Monday) and Licensee List ZIP (Updated Weekly on Monday). See https://docs.google.com/document/d/1xgtWggWuswaHk8XJwkN3f_FkAaGUxME9XX1NbRql9HQ/edit# for directions and process.
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